Problem 11-20 Prepare a master schedule given this information: It is now the en
ID: 427277 • Letter: P
Question
Problem 11-20
Prepare a master schedule given this information: It is now the end of week 1; customer orders are 25 for week 2, 16 for week 3, 11 for week 4, 8 for week 5, and 3 for week 6. Use the MPS rule of ordering production when projected on-hand inventory would be negative without production. Suppose that there are currently 64 pumps in inventory and a production lot size of 70 pumps is used. (Leave no cells blank - be certain to enter "0" wherever required.)
Explanation / Answer
Period
2
3
4
5
6
7
8
9
Forecasted Sales
30
30
30
30
40
40
40
40
Customer Orders
33
25
16
11
8
3
0
0
Projected on Hand (64)
34
4
44
14
44
4
34
64
ATP
97
9
58
33
76
41
74
104
Master Production Schedule
0
0
70
0
70
0
70
70
Period
2
3
4
5
6
7
8
9
Forecasted Sales
30
30
30
30
40
40
40
40
Customer Orders
33
25
16
11
8
3
0
0
Projected on Hand (64)
34
4
44
14
44
4
34
64
ATP
97
9
58
33
76
41
74
104
Master Production Schedule
0
0
70
0
70
0
70
70