Problem 1: Prepare a Master Schedule given the following information: The forecast for each week for an eight-week schedule is 75 units. The Master Production Schedule (MPS) rule is to schedule production if the projected on-hand inventory would be negative without it. Committed customer orders are as follows: Week Customer order 1 75 2 2 53 3 26 4 . 18 a 17 75 8 75 75 Use a production lot size of 100 units and no beginning inventory. Week Beginning inventory=0 1 2 3 4 5 Forecast 75 75 75 75 75 Customer Orders Projected On-Hand Inventory MPS Formulas for Projected On-Hand Inventory Week 1 = Beginning Inventory + MPS MAX (Forecast Customer Order) Weeks 2 - 8 = Previous Week Inventory - MPS - (Forecast: Customer Order) Because the problem says we cannot have any negative inventory, then we require MPS shipments to come in. When a shipment comes in it is in lots of 100. In this problem. MPS will be added for Weeks 1,2,3, and Weeks 5.6.7. No MPS shipments are expected in Week 4 or Week 8