Question: A partially completed MPS record for an end item is shown in the table below. The current on - hand inventory ( in units )

A partially completed MPS record for an end item is shown in the table below. The current on-hand inventory (in units), the order quantity (in units), and the lead time (LT, in weeks) are given in the table. Develop MPS for the end item. Round to the nearest whole number.
[Note: Projected on-hand inventory at the end of this week = On-hand inventory at the end of last week + MPS quantity due at start of this week - Projected requirements this week.
ATP for the first week = Projected on-hand inventory at the end of last week + MPS quantity for the first week - The cumulative total number of customer orders booked up to (but not including) the week in which the next MPS quantity arrives.
ATP for the 2nd,3rd,... weeks = MPS quantity - The cumulative total number of customer orders booked up to (but not including) the week in which the next MPS quantity arrives.] Current on-hand inventory: 50
Order quantity: 60
LT: 1
\table[[,1,2,3,4],[Forecast,21,45,35,12],[Customer orders (booked),14,13,25,20],[Projected on-hand inventory,29,,,],[MPS quantity,,,,],[MPS start,,,,],[ATP inventory,,,,]]
What is the projected on-hand inventory for week 2?
Group of answer choices
6
44
98
What is the available-to-promise inventory (ATP) for week 1?
Group of answer choices
15
36
0
Flag question: Question 3
Question 37 pts
What is the projected on-hand inventory for week 3?
Group of answer choices
5
9
Flag question: Question 4
Question 47 pts
What is the projected on-hand inventory for week 4?
Group of answer choices
45
49
Flag question: Question 5
Question 57 pts
What is the MPS start quantity for week 1?
Group of answer choices
20
60
Flag question: Question 6
Question 67 pts
What is the MPS quantity for week 2?
Group of answer choices
40
60
 A partially completed MPS record for an end item is shown

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!