WILL RATE!
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) Lot Size: 95 Lead Time: 2 weeks Week 5 6 7 20 20 45 0 3 10 4 45 15 2 45 48 3 45 7 45 5 9 45 0 10 45 0 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start 150 105 57 12 62 42 22 72 771 32 0019 NOOO 0 95 0 95 95 0 0 0 95 95 95 ATP 80 87 0 85 95 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 105 units to be delivered in period 4. > Order 3 is for 90 units to be delivered in period 6. > Order 4 is for 115 units to be delivered in period 7. > Order 5 is for 120 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 accept based on the available to promise (ATP)? Order Order Acceptance accept 1 2 accept 3 reject 4 reject 5 reject 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) Lot Size: 95 Lead Time: 2 weeks Week 5 6 7 20 20 45 0 3 10 4 45 15 2 45 48 3 45 7 45 5 9 45 0 10 45 0 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start 150 105 57 12 62 42 22 72 771 32 0019 NOOO 0 95 0 95 95 0 0 0 95 95 95 ATP 80 87 0 85 95 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 105 units to be delivered in period 4. > Order 3 is for 90 units to be delivered in period 6. > Order 4 is for 115 units to be delivered in period 7. > Order 5 is for 120 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 accept based on the available to promise (ATP)? Order Order Acceptance accept 1 2 accept 3 reject 4 reject 5 reject
