Q1.

Scenario 1

Complete the Projected Available and MPS rows of the following Master Production Schedule. As indicated, the current on-hand inventory is100 units. By policy MPS quantities are in multiples of 195 units and no safety stock is required.

In any week where no MPS quantity is needed, enter a value of zero.

Week		1	2	3	4	5	6	7	8
Forecast		90	90	90	90	80	80	80	80
COB		64	68	50	65	53	43	25	43
Projected Available	100	ANSWER HERE	ANSWER HERE	ANSWER HERE	ANSWER HERE	ANSWER HERE	ANSWER HERE	ANSWER HERE	ANSWER HERE
MPS		ANSWER HERE	ANSWER HERE	ANSWER HERE	ANSWER HERE	ANSWER HERE	ANSWER HERE	ANSWER HERE	ANSWER HERE
ATP

Q2.

Complete the Available-to-Promise row of the following Master Production Schedule. As indicated, the current on-hand inventory is 100 units. By policy MPS quantities are in multiples of 215 units and no safety stock is required.

In any week where there is no ATP quantity, enter a value of zero.

Week		1	2	3	4	5	6	7	8
Forecast		75	75	75	75	75	75	75	75
COB		69	46	42	34	26	49	44	22
Projected Available	100	25	165	90	15	155	80	5	145
MPS		0	215	0	0	215	0	0	215
ATP		ANSWER HERE	ANSWER HERE	ANSWER HERE	ANSWER HERE	ANSWER HERE	ANSWER HERE	ANSWER HERE	ANSWER HERE

Q3.