AutoSave OFF A Svo Chapter 11b E8 Home Insert Draw Page Layout Formulas Data Review View = deur Custom = = = als Wrap Text v Merge & Center v 5 $ - % 9 || A v Arial v 14 v Paste BI U v P av A | 012 A x v fx B C D 1 Management Instructions Beginning Inventory Safety Stock Lot Size E F G H I J K L 6 480 6 Master Production Schedule Period 1 2 3 Demand 4,400 3,750 4,200 Customer Orders 4,410 4,500 5,300 4 4,175 4,480 5 4,225 3,705 6 4,300 2,700 7 4,350 1,995 8 4,400 230 Projected On-Hand Inventory (POHI) 11 (at the end of the period) Master Production Schedule 12 Available To Promise (1-period look ahead) 13 What is the POHI value for Period 1? What is the POHI value for Period 4? What is the POHI value for Period 6? What is the MPS for Period 1? What is the MPS for Period 5? What is the MPS for Period 8? What is the ATP for Period 1? What s the ATP for Period 7? What is the ATP for Period 8? AutoSave OFF A Svo Chapter 11b E8 Home Insert Draw Page Layout Formulas Data Review View = deur Custom = = = als Wrap Text v Merge & Center v 5 $ - % 9 || A v Arial v 14 v Paste BI U v P av A | 012 A x v fx B C D 1 Management Instructions Beginning Inventory Safety Stock Lot Size E F G H I J K L 6 480 6 Master Production Schedule Period 1 2 3 Demand 4,400 3,750 4,200 Customer Orders 4,410 4,500 5,300 4 4,175 4,480 5 4,225 3,705 6 4,300 2,700 7 4,350 1,995 8 4,400 230 Projected On-Hand Inventory (POHI) 11 (at the end of the period) Master Production Schedule 12 Available To Promise (1-period look ahead) 13 What is the POHI value for Period 1? What is the POHI value for Period 4? What is the POHI value for Period 6? What is the MPS for Period 1? What is the MPS for Period 5? What is the MPS for Period 8? What is the ATP for Period 1? What s the ATP for Period 7? What is the ATP for Period 8