1. For the given forecasts, customer orders and on hand inventory shown below, drive the MPS. Lot size is multiples of 400 units. (10pts) Current inventory=500 Period Period 1 2 3 4 5 6 Forecast 700 700 800 1000 1100 1200 Orders 600 800 500 300 Available Available to promise MPS Following events occurred during week 1 according to table above: Actual sales during week 1 was 800 units. An order for 500 units in period 5 was accepted. An additional order for 300 units in period 2, 150 units in period 3, and 100 units in period 4 were accepted. Update the record below. (15 pts) Current inventory= Period 2. Period 4 5 6 7 Forecast 700 800 1000 1100 1200 1300 Orders Available Available to promise MPS