Question: Please include work and formulas please. Thanks in advance :) 3.18. a. Given the following master schedule, fill in the projected available and available to

Please include work and formulas please. Thanks in advance :)

Please include work and formulas please. Thanks

3.18. a. Given the following master schedule, fill in the projected available and available to promise rows: On hand: 35 Lot size: 200 Planning time fence: 10 Demand time fence: 2 Period 1 2 3 4 5 6 7 8 9 10 11 12 30 40 40 50 40 40 30 40 40 50 40 40 31 35 29 21 17 14 33 11 5 2 0 1 Forecast Customer Orders Projected Available Available to Promise MPS 200 200 b. A customer wants an order of 100 in period 4. What can you tell him? c. The customer from part (b) cancels his request, but then says he wants 120 in period 5. What do you tell him now? d. Sales has requested that you add an MPS of 200 in period 9 to cover their needs for a sales promotion. What do you tell them and why? e. What action (if any) should be taken in period 11? Why is it okay to take the action? 3.18. a. Given the following master schedule, fill in the projected available and available to promise rows: On hand: 35 Lot size: 200 Planning time fence: 10 Demand time fence: 2 Period 1 2 3 4 5 6 7 8 9 10 11 12 30 40 40 50 40 40 30 40 40 50 40 40 31 35 29 21 17 14 33 11 5 2 0 1 Forecast Customer Orders Projected Available Available to Promise MPS 200 200 b. A customer wants an order of 100 in period 4. What can you tell him? c. The customer from part (b) cancels his request, but then says he wants 120 in period 5. What do you tell him now? d. Sales has requested that you add an MPS of 200 in period 9 to cover their needs for a sales promotion. What do you tell them and why? e. What action (if any) should be taken in period 11? Why is it okay to take the action

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 General Management Questions!