MGMT617 Assignment 2 Solution and Discussion

[zareen]

PRODUCTION PLANNING & INVENTORY CONTROL (MGMT617) ASSIGNMENT # 2
Due date: January 29, 2020 Question:
Marks: 10
The distribution Manager of ABC Company is using Error Addback method for his Distribution Requirement Planning (DRP) system for brand C1000 whose weekly demand forecast is 50 units.
a. Complete following DRP record for upcoming weeks using given information.
Forecast Requirement
In transit
Projected available Balance Planned Receipt
Planned Shipments
Q = 70, LT = 1, SS = 15
Week 12345
70 20
b. Modify above DRP record for week 2 onwards as the actual demand occurred was 45, 58 and 54 for week 1, 2 and 3 respectively [complete the records using Error Addback method].
 Actual demand for week 1 = 45
Forecast Requirement
In transit
Projected available Balance Planned Receipt
Planned Shipments
Q = 70, LT = 1, SS = 15
Week 23456

 Actual demand for week 2 = 58
Forecast Requirement
In transit
Projected available Balance Planned Receipt
Planned Shipments
Q = 70, LT = 1, SS = 15
 Actual demand for week 3 = 54
Forecast Requirement
In transit
Projected available Balance Planned Receipt
Planned Shipments
Q = 70, LT = 1, SS = 15
Instructions:
Week 34567
Week 45678
• You have to prepare the DRP in given formats
• No theoretical definition or explanation is required.
• Watch video lectures and consult book/notes to complete the assignment
Important:
24 hours extra / grace period after the due date are usually available to overcome uploading difficulties. This extra time should only be used to meet the emergencies and above mentioned due dates should always be treated as final to avoid any inconvenience.
Deadline:
• Make sure to upload the solution file before the due date on VULMS.
• Any submission made via email after the due date will not be accepted.
Formatting Guidelines:
• Use the font style “Times New Roman” or “Arial” and font size “12”.
• It is advised to compose your document in MS-Word format.
• You may also compose your assignment in Open Office format.
• Use black and blue font colours only.

Referencing Guidelines:
• Use APA style for referencing and citation. For guidance search “APA reference style” in Google and read various websites containing information for better understanding or visit
http://linguistics.byu.edu/faculty/henrichsenl/apa/APA01.html
Rules for Marking
Please note that your assignment will not be graded or graded as Zero (0), if:
• Any of the given instructions is not followed
• It is copied or plagiarized
• It is submitted after the due date.
• The file you uploaded does not open or is corrupt.

[zareen]

please share idea solution