Refer to Case Study 3.1 in your textbook for background information about Acme Water Pumps. The table reflects a new 10-week cycle for firm customer orders and forecast. No time-fence is considered for this schedule. There are 50 units on hand prior to Period 1 and the MPS is set to produce 300 units in week 2, 5 and 8. Use your own worksheet to complete the missing information in the table and answer the following questions in the space below. a) What is the ATP in weeks 2, 5 & 8? Can Acme accept an additional customer order for 10 units in week 3? (Explain your answer) b) What is the projected available balance for each period? c) The sales team has acquired a new customer who is looking for 50 water pumps in weeks 5, 7 and 9. Answer the following with reference to Acme operations: i) Can this new order request be fulfilled? ii) How does this impact other operational considerations for MPS and servicing customer demand?

Period	0	1	2	3	4	5	6	7	8	9	10
Forecast		44	74	98	95	75	78	95	95	90	95
Customer Orders		45	75	100	95	75	80	100	95	95	100
Projected Available Balance	50	5	230	130	35	260	180	80	285	190	90
MPS			300			300			300
ATP			30			45			10