Chapter 11b P19 - Excel AutoSave He Home Insert Page Layout Formulas Data Review View Help Search = = = Arial BIU 11 - A A. 13 Wrap Test Merge & Center - General $ % Conditional format as Cell Formatting Table Styles Clipboard AB Management Instructions Beginning Inventory Safety Stock Lot Size 1,507 400 800 6 7 Master Production Schedule Period Demand 2,400 6,100 6,400 Customer Orders 4,105 5,580 6,850 4,900 4.850 4,800 3,300 4,800 7,000 2,000 4,000 7,950 9,145 Projected On-Hand Inventory (POHI) 11 (at the end of the period) Master Production Schedule Available To Promise 11-eriod look ahead P10 What is the POHI value for Period 2? 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 4? What is the MPS for Period 7? What is the ATP for Period 2? What is the MPS for Period 4? What is the MPS for Period 7? What is the ATP for Period 2? What s the ATP for Period 5? What is the ATP for Period 6