Problem 11-19 Prepare a master production schedule for industrial pumps in the m
ID: 334903 • Letter: P
Question
Problem 11-19 Prepare a master production schedule for industrial pumps in the manner of the following table. Use the MPS rule to "schedule production when the projected on-hand inventory would be less than 10 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 "O" wherever required.) June Jul 30 20 30 10 30 30 40 40 40 40 Forecast Customer orders (committed) Projected on-hand inventory MPS ATPExplanation / Answer
MASTER PRODUCTION SCHEDULE FOR INDUSTRIAL SCHEDULE
Projected
on-hand inventory
(64-33) =
31
(31+30) - 30 =
31
(31+30) - 30 =
31
(31+30) - 30 =
31
(31+30) - 40 =
21
(30+21) - 40 =
11
(30+11) - 40 =
1
(60+1) - 40 =
21
PRODUCT TABLE ORDER POLICY 70 LEAD TIME 1 week Quantity on hand 64 1 2 3 4 5 6 7 8 Forecast 30 30 30 30 40 40 40 40 Customer orders 33 20 10 4 2 0 0 0Projected
on-hand inventory
(64-33) =
31
(31+30) - 30 =
31
(31+30) - 30 =
31
(31+30) - 30 =
31
(31+30) - 40 =
21
(30+21) - 40 =
11
(30+11) - 40 =
1
(60+1) - 40 =
21
MPS 0 30 30 30 30 30 30 60 ATP 30 30 30 30 30 30 60 0