The following are the reference books used for this section: APICS Dictionary , 12th Edition 2008

1. The following are the reference books used for this section: APICS Dictionary, 12th Edition 2008 APICS Learning System, Version 2.1, 2010 Edition Arnold, J.R. Tony, S.N. Chapman, and L.M. Clive. Introduction to Materials Management, 6th edition, Prentice Hall, 2008 BIBLIOGRAPHY Slide 1

2. SAMPLE WORKSHEET PRINTING INSTRUCTION To print a copy of this sample worksheet, press [Ctrl] [P] Master Schedule for Product A (Week 12) Cumulative lead time: 4 weeks 5-week plan horizon Week 12 13 14 15 16 Lot size: 60 units On hand: 40 units Demand 45 40 40 40 45 Projected available balance 40 Master production schedule 60 60 Quality Management Solutions Slide 2 • Note: • PAB for weeks 12 – 16 is the same as it was when these weeks were 11 -15 • PAB for week 16 is 40

3. SAMPLE WORKSHEET PRINTING INSTRUCTION The printer dialog box will appear. Select your printer name and select the “Current slide” option. Then press Master Schedule for Product A (Week 12) Cumulative lead time: 4 weeks 5-week plan horizon Week 12 13 14 15 16 Lot size: 60 units On hand: 40 units Demand 45 40 40 40 45 Projected available balance 40 Master production schedule 60 60 Quality Management Solutions Slide 3 • Note: • PAB for weeks 12 – 16 is the same as it was when these weeks were 11 -15 • PAB for week 16 is 40

4. PRINT SAMPLE WORKSHEET Master Schedule for Product A (Week 12-16) Cumulative lead time: 4 weeks 5-week plan horizon Week 12 13 14 15 16 Lot size: 60 units On hand: 40 units Demand 45 40 40 40 45 Projected available balance 40 Master production schedule 60 60 Quality Management Solutions Slide 4 • Note: • PAB for weeks 12 – 16 is the same as it was when these weeks were 11 -15 • PAB for week 16 is 40

5. WEEK 12 Exercise: Complete the master schedule for week 12 (beginning wk. 12) Calculate the PAB for weeks 12 – 15 Calculate the MPS and the PAB for weeks 12, 13, and 16 Master Schedule for Product A (Week 12) Cumulative lead time: 4 weeks 5-week plan horizon Week 12 13 14 15 16 Lot size: 60 units On hand: 40 units Demand 45 40 40 40 45 Projected available balance 40 Master production schedule 60 60 Quality Management Solutions Slide 5 • Note: • PAB for weeks 12 – 16 is the same as it was when these weeks were 11 -15 • PAB for week 16 is 40

6. WEEK 12 WEEK 12

7. WEEK 12 Exercise: Complete the master schedule for week 12 (beginning wk. 12) Calculate the PAB for weeks 12 – 15 Calculate the MPS and the PAB for weeks 12, 13, and 16 Master Schedule for Product A (Week 12) Cumulative lead time: 4 weeks 5-week plan horizon Week 12 13 14 15 16 Lot size: 60 units On hand: 40 units Demand 45 40 40 40 45 Projected available balance -5 40 Master production schedule 60 60 Projected balance: 40 (on hand) – 45 (Demand) = -5 Quality Management Solutions Slide 7 • Note: • PAB for weeks 12 – 16 is the same as it was when these weeks were 11 -15 • PAB for week 16 is 40

8. WEEK 12 Exercise: Complete the master schedule for week 12 (beginning wk. 12) Calculate the PAB for weeks 12 – 15 Calculate the MPS and the PAB for weeks 12, 13, and 16 Master Schedule for Product A (Week 12) Cumulative lead time: 4 weeks 5-week plan horizon Week 12 13 14 15 16 Lot size: 60 units On hand: 40 units Demand 45 40 40 40 45 Projected available balance 55 40 Master production schedule 60 60 60 Release: 60 from MPS (Lot size = 60). PAB = 60 – (40 – 45) = 55 Quality Management Solutions Slide 8 • Note: • PAB for weeks 12 – 16 is the same as it was when these weeks were 11 -15 • PAB for week 16 is 40

9. WEEK 13 WEEK 13

10. WEEK 13 Exercise: Complete the master schedule for week 13 (beginning wk. 13) Master Schedule for Product A (Week 13) Cumulative lead time: 4 weeks 5-week plan horizon 13 Week 12 14 15 16 Lot size: 60 units On hand: 40 units Demand 45 40 40 40 45 Projected available balance 55 15 40 Master production schedule 60 60 60 Projected balance: 55 (on hand) – 40 (Demand) = 15 (PAB) Quality Management Solutions Slide 10 • Note: • PAB for weeks 12 – 16 is the same as it was when these weeks were 11 -15 • PAB for week 16 is 40

11. WEEK 13 Exercise: Complete the master schedule for week 13 (beginning wk. 13) Master Schedule for Product A (Week 13) Cumulative lead time: 4 weeks 5-week plan horizon Week 12 13 14 15 16 Lot size: 60 units On hand: 40 units Demand 45 40 40 40 45 Projected available balance 55 15 40 Master production schedule 60 0 60 60 Release: 0 (No MPS release required) PAB = 0 + 55 – 40 = 15 Quality Management Solutions Slide 11 • Note: • PAB for weeks 12 – 16 is the same as it was when these weeks were 11 -15 • PAB for week 16 is 40

12. WEEK 14 WEEK 14

13. WEEK 14 Exercise: Complete the master schedule for week 14 (beginning wk. 14) Master Schedule for Product A (Week 14) Cumulative lead time: 4 weeks 5-week plan horizon Week 12 13 14 15 16 Lot size: 60 units On hand: 40 units Demand 45 40 40 40 45 Projected available balance 55 15 35 40 Master production schedule 60 - 60 60 Release: 60 already existed (Lot size = 60). PAB = 60 + (15– 40) = 35 Quality Management Solutions Slide 13 • Note: • PAB for weeks 12 – 16 is the same as it was when these weeks were 11 -15 • PAB for week 16 is 40

14. WEEK 15 WEEK 15

15. WEEK 15 Exercise: Complete the master schedule for week 15 (beginning wk. 15) Master Schedule for Product A (Week 15) Cumulative lead time: 4 weeks 5-week plan horizon Week 12 13 14 15 16 Lot size: 60 units On hand: 40 units Demand 45 40 40 40 45 Projected available balance 55 15 35 55 40 Master production schedule 60 - 60 60 Release: 60 already existed (Lot size = 60). PAB = 60 + (35– 40) = 55 Quality Management Solutions Slide 15 • Note: • PAB for weeks 12 – 16 is the same as it was when these weeks were 11 -15 • PAB for week 16 is 40

16. WEEK 16 WEEK 16

17. WEEK 16 Exercise: Complete the master schedule for week 16 (beginning wk. 16) Master Schedule for Product A (Week 16) Cumulative lead time: 4 weeks 5-week plan horizon Week 12 13 14 15 16 Lot size: 60 units On hand: 40 units Demand 45 40 40 40 45 Projected available balance 55 15 35 55 10 40 Master production schedule 60 - 60 60 PAB = 0 + (55 – 45) = 10 Quality Management Solutions Slide 17 • Note: • PAB for weeks 12 – 16 is the same as it was when these weeks were 11 -15 • PAB for week 16 is 40

18. WEEK 16 Exercise: Complete the master schedule for week 16 (beginning wk. 16) Master Schedule for Product A (Week 16) Cumulative lead time: 4 weeks 5-week plan horizon Week 12 13 14 15 16 Lot size: 60 units On hand: 40 units Demand 45 40 40 40 45 Projected available balance 55 15 35 55 10 40 Master production schedule 60 - 60 60 0 Release: 0 (No MPS release required) Quality Management Solutions Slide 18 • Note: • PAB for weeks 12 – 16 is the same as it was when these weeks were 11 -15 • PAB for week 16 is 40

19. FINAL ANSWER FINAL ANSWER SHEET

20. FINAL ANSWER Cumulative lead time: 4 weeks 5-week plan horizon Week 12 13 14 15 16 Lot size: 60 units On hand: 40 units Demand 45 40 40 40 45 Projected available balance 55 15 35 55 10 40 Master production schedule 60 0 60 60 0 Your results should look like this! Quality Management Solutions Slide 20 • Note: • PAB for weeks 12 – 16 is the same as it was when these weeks were 11 -15 • PAB for week 16 is 40