Question

The following table shows the demand forecasts and committed orders for a product.
Month	Forecast	Committed orders
1	60	80
2	60	60
3	60	40
4	60	82
5	45	20
6	45	0
7	45	0
8	45	0
The lot size has been determined to be 80 units whenever there is scheduled production. Beginning inventory is 95 units.
Calculate the MPS and ATP for each week. If no MPS or ATP for a week, enter 0. No decimals.

Answer 1

Month	Forecast	Committed orders	Projected on-hand	MPS	ATP
			95
1	60	80	15	0	15
2	60	60	35	80	20
3	60	40	55	80	40
4	60	82	53	80	0
5	45	20	8	0	0
6	45	0	43	80	80
7	45	0	78	80	80
8	45	0	33	0	80