Problem 11-21 Prepare a master schedule given this information: The forecast for

Question

Problem 11-21 Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 50 units. The MPS rule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed) are follows Week Customer Order 52 35 20 12 Use a production lot size of 75 units and no beginning inventory. (Leave no cells blank - be certain to enter "O" wherever required.) June Jul 50 52 50 35 50 20 50 12 50 50 50 0 50 0 Forecast Customer Orders Projected on-hand inventory MPS ATP

Explanation / Answer

Projected on hand inv = Inventory from previous week - Current week requirement + MPS Current week requirement = Max(Forecast,Customer orders) ATP = MPS - next week commited orders - current week committed orders MPS is done when on hand inventory is less than current week requirement 1 2 3 4 5 6 7 8 Forecast 50 50 50 50 50 50 50 50 Customer orders 52 35 20 12 Projected on hand 23 48 73 23 48 73 23 48 MPS 75 75 75 0 75 75 75 ATP 0 20 43 0 75 75 75

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---