Question

Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 60 units. The MPS rule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed) are as follows:

Answer 1

Answer:

	June	July
	1	2	3	4	5	6	7	8
Forecast	60	60	60	60	60	60	60	60
Customer Orders	52	38	23	12	0	0	0	0
Projected on hand inventory	48	88	128	68	108	148	88	128
MPS	100	100	100	0	100	100	0	100
ATP	48	62	65	0	100	100	0	100

Projected on hand inventory (POHI) = On-hand Inventory at the end of last week + MPS due at start of the week – Project requirements of that week

Week 1 = 0 +100 - 52 = 48

Week 2 = 48 +100 - 60 = 88

Week 3 =88+100 – 60 = 128

Week 4 = 128 – 60 = 68

Week 5 = 68 +100 - 60 = 108

Week 6 = 108 +100 – 60 = 148

Week 7 = 148 – 60 = 88

Week 8 = 88 +100 - 60 = 128

MPS is not used in Week 4 and Week 7 because POHI is not negative without it.         

ATP = MPS - Cumulative customer order until next MPS is used

Week 1 = 100 – 52 = 48

Week 2 = 100 - 38 = 62

Week 3 = 100 – (23+12) = 65

Week 4 = 0-0 = 0

Week 5 = 100 - 0 = 100

Week 6 = 100 - 0 = 100

Week 7 = 0 - 0 = 0

Week 8 = 100 - 0 = 100