Master Production Schedule Item name: CF151 Ceiling Fan Quantity on Hand: Forecast Customer Orders (Booked) Projected on-hand inventory MPS quantity MPS start ATP FOQ: 400 Lead Time: 1 week 0 Wk. 1 102 (102) Wk. 2 811 1,087 2,000 0 Wk. 3 Wk. 4 Wk. 5 717 370 476 (105) 242 (347) 96 (444) 0 0 0 0 Item name: PF032 Personal Fan FOQ: 1,197 Lead Time: 2 weeks Quantity on Hand: 2,243 Forecast Customer Orders (Booked) Projected on-hand inventory MPS quantity MPS start ATP 0 2,243 Wk. 1 Wk. 2 Wk. 3 A - CF151 Ceiling Fan B - PF032 Personal Fan L - 3020007 Personal Fan Blade 758 589 515 74 237 (163) 0 0 0 0 0 C - 2012000 Subassy; L4L Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases LT = 1 D - 3020003 Blade; FOQ = 4,800 Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases LT = 1 1,000 1,500 SS = 1,000 4,800 10,000 Wk. 5 896 1,347 MRP Explosion Pd 1 Pd 2 Item name Wk. 4 Pd 3 0 Pd 4 0 101 (264) Pd 5 0 0 E - 4012000 Box; FOQ = 1,800 Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases LT = 2 F - 4015000 Screw; FOQ = 100,000 Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases LT = 1 G - 4013000 Elec. Mtr.; L4L Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases LT = 1 H - 3013003 Housing; L4L Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases LT = 1 I - 4010000 Adhesive; FOQ = 640 Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases LT = 1 J - 4014000 HDPE; POQ = 3 Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases LT = 1 K - 2012001 Subassy.; L4L Gross requirements Scheduled receipts LT = 1 3,289 37,375 SS = 200 900 SS = 30 2,200 902 SS = 640 640 40 SS = 1,600 70,000 20,000 1,500 Projected on-hand inventory Planned receipts Planned order releases 2,000 L - 3020007 Blade; FOQ = 4,000 Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases LT = 1 M - 4012001 Box; FOQ = 2,000 Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases LT = 2 N - 4013002 Elec. Mtr.; L4L Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases LT = 2 SS = 100 4,000 3,500 2,000 3,126 900 SS = 40 O - 3013004 Housing; POQ = 2 Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases LT = 2 1,600 Lead Time: 1 week Wk. 6 10 (453) FOQ: 1,197 Lead Time: 2 weeks Wk. 6 11 (274) Pd 6 Level 0 0 Level 1 A - CF151 Ceiling Fan C-2012000 (1) Subassembly D - 3020003 (5) Blade E - 4012000 (1) Box F - 4015000 (10) Screw B - PF032 Personal Fan K - 2012001 (1) Subassembly L - 3020007 (4) Blades M - 4012001 (1) Box F - 4015000 (10) Screws Level 2 Level 3 G - 4013000 (1) Elec Mtr H -3013003 (1) Housing J - 4014000 (8) HDPE I - 4010000 (.25) Adhesive J - 4014000 (16) HDPE N - 4013002 (1) Elec Mtr O - 3013004 (1) Housing J - 4014000 (6) HDPE I - 4010000 (.25) Adhesive J - 4014000 (2) HDPE Table 1 Part Numbers & Descriptions Part Number Description (A) CF151 42\" Ceiling Fan (B) PF032 6\" Personal Fan (C) 2012000 Ceiling Fan subassembly (D) 3020003 Ceiling Fan blades (E) 4012000 Ceiling Fan box (F) 4015000 Screws (G) 4013000 Electric Motor (H) 3013003 Housing (I) 4010000 Adhesive (J) 4014000 HDPE (High Density Polyethylene) (K) 2012001 Personal Fan subassembly (L) 3020007 Personal Fan blades (M) 4012001 Personal Fan box (N) 4013002 Electric Motor (O) 3013004 Housing Table 2 Replacement Part Demand Item Description & Pt. # Qty. Blades (30200007) 100 Blades (30200007) 50 Date Week 3 Week 6