Question: An end item's demand forecasts for the next 10 weeks are 45, 45, 45, 45, 20, 20, 45, 45, 45, and 45 units. The current

An end item's demand forecasts for the next 10

An end item's demand forecasts for the next 10 weeks are 45, 45, 45, 45, 20, 20, 45, 45, 45, and 45 units. The current on-hand inventory is 150 units. The order policy is to produce in lots of 95. The booked customer orders for the item, starting with week 1, are 15, 48, 7,5, 0, 3, 10, 0, 0, and 0 units. The lead time is 2 weeks. a. Develop an MPS for this end item. (Enter your responses as integers. A response of "O" is equivalent to being not applicable.) 8 1 45 15 150 105 2 45 48 57 3 45 7 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start Lot Size: 95 Lead Time: 2 weeks Week 5 6 7 20 20 45 0 3 3 10 42 22 72 4 45 5 62 45 0 0 27 9 45 0 77 95 10 45 0 32 12 0 0 95 0 0 95 0 0 0 95 0 0 0 95 0 95 0 0 0 ATP 80 0 0 0 0 87 0 0 85 0 95 0 0 b. The marketing department has received five orders for this item in the following sequence: > Order 1 is for 20 units to be delivered in period 1. > Order 2 is for 125 units to be delivered in period 4 > Order 3 is for 90 units to be delivered in period 6. > Order 4 is for 125 units to be delivered in period 7. > Order 5 is for 90 units to be delivered in period 10. Assuming that the prospective MPS you developed in part (a) does not change, which orders would you be able to acceptt accept ible to promise (ATP)? reject Order Orde: 1 1

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!