MPS problem 5 Using the MPS/ATP worksheets provided, do the following. Safety stock=10 Order quantity=50 There is a MPS of 50 scheduled in week 2. Demand time fence two weeks: no changes to MPS can be made within the first two weeks; the projected available balance (PAB) only subtracts actual orders and NOT the forecast. Outside of the demand time fence, use the PAB convention of subtracting the GREATER of orders or forecast in a time period. a. Complete the MPS/ATP time phased record. b. The following orders are received in the order shown. Can they be accepted as requested? Order 1 2 3 4 Amount 30 35 30 8 Desired week 4 5 3 1 Enter each order one at a time to the MPS from part a. First, without changing the projected available line or the MPS line, update the orders and ATP numbers. After trying to do this, do you see any problems? What options might be considered to address these problems? c. Finally, with all the new orders entered as requested (whether or not you said to accept them in "b"), recalculate the projected available, MPS, and ATP. Beginning work sheet Q=50; SS=10; demand time fence_two weeks Week 1 2 3 4 5 6 7 8 9 10 Forecast 15 15 20 25 25 25 35 35 35 35 Orders 12 8 4 10 Projected Available 20 ATP MPS 50 Use this for part c. Update the order line to show the new order totals (original orders plus new orders). Q=50 ; SS=10; demand time fence two weeks Week 1 2 3 4 5 6 7 8 9 10 Forecast 15 15 20 25 25 25 35 35 35 35 Orders Projected Available 20 ATP MPS 50 MPS problem 5 Using the MPS/ATP worksheets provided, do the following. Safety stock=10 Order quantity=50 There is a MPS of 50 scheduled in week 2. Demand time fence two weeks: no changes to MPS can be made within the first two weeks; the projected available balance (PAB) only subtracts actual orders and NOT the forecast. Outside of the demand time fence, use the PAB convention of subtracting the GREATER of orders or forecast in a time period. a. Complete the MPS/ATP time phased record. b. The following orders are received in the order shown. Can they be accepted as requested? Order 1 2 3 4 Amount 30 35 30 8 Desired week 4 5 3 1 Enter each order one at a time to the MPS from part a. First, without changing the projected available line or the MPS line, update the orders and ATP numbers. After trying to do this, do you see any problems? What options might be considered to address these problems? c. Finally, with all the new orders entered as requested (whether or not you said to accept them in "b"), recalculate the projected available, MPS, and ATP. Beginning work sheet Q=50; SS=10; demand time fence_two weeks Week 1 2 3 4 5 6 7 8 9 10 Forecast 15 15 20 25 25 25 35 35 35 35 Orders 12 8 4 10 Projected Available 20 ATP MPS 50 Use this for part c. Update the order line to show the new order totals (original orders plus new orders). Q=50 ; SS=10; demand time fence two weeks Week 1 2 3 4 5 6 7 8 9 10 Forecast 15 15 20 25 25 25 35 35 35 35 Orders Projected Available 20 ATP MPS 50