Given the information in the table, update on-hand inventory, schedule MPS, and calculate available-to-promise (ATP) quantities. The order policy is to produce in lots of 150. Show all your calculations to receive full or partial credits.

				Week
Quantity on hand: 40	1	2	3	4	5	6	7	8
Forecast	40	40	40	40	50	50	50	50
Customer orders (booked)	20	95	40	45	15	75	20	10
Projected on-hand Inventory
MPS quantity
Available-to-promise (ATP)

Assume that prospective new customer orders arrive in the following sequence, independent of one another.

Order	Quantity	Week Due		Which of the orders should be accepted? all of the orders orders 1, 2, and 3 only orders 1 and 2 only orders 1, 2, and 4 only none of the above
1 2 3 4	40 30 20 90	4 1 3 7