Product A is an assemble-to-order product. It has a lot size of 150, and currently has an on-hand inventory of 110 units. There is a 2-week demand time fence and a 12-week planning time fence. The following table gives the original forecast and the actual customer orders for the next 12 weeks:
Week 1 2 3 4 5 6 7 8 9 10 11 12
Forecast 80 80 80 70 70 70 70 70 70 70 70 70
Demand 83 78 65 61 49 51 34 17 11 7 0 0
a. Given this information, develop a realistic master schedule, complete with ATP logic.
b. Tell how you would respond to each of the following customer order requests.
Assume these are independent requests, and do not have cumulative effects.
20 units in week 3
40 units in week 5
120 units in week 7