Question: An end item's demand forecasts for the next 6 weeks are 35 units, followed by forecasts of 30 units for weeks 7 though 10. The

An end item's demand forecasts for the next 6 weeks are 35 units, followed by forecasts of 30 units for weeks 7 though 10. The current on-hand inventory is 70units. The order policy is to produce in lots of 120.The booked customer orders for the item, starting with week 1, are 17, 35, 15, 15, 0, 0, 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 "0" is equivalent to being not applicable.)An end item's demand forecasts for the next 6 weeks are 35

1 35 17 2 35 3 35 4 35 Lot Size: 120 Lead Time: 2 weeks Week 5 6 7 35 35 30 0 8 30 9 30 70 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start ATP 000 olan OO000 b. The marketing department has received six orders for this item in the following sequence: > Order 1 is for 60 units to be delivered in period 3. > Order 2 is for 50 units to be delivered in period 4. > Order 3 is for 70 units to be delivered in period 6. > Order 4 is for 40 units to be delivered in period 3. > Order 5 is for 5 units to be delivered in period 5. > Order 6 is for 30 units to be delivered in period 9. 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 Enter your answer in each of the answer boxes

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 Accounting Questions!