Please include the formulas used to calculate the values.

Management Instructions Beginning Inventory Safety Stock Lot Size 1,507 400 800 4 5 6 7 8 4,900 4,800 4,800 7,000 7,950 Master Production Schedule Period 1 2 3 Demand 2,400 6,100 6,400 Customer Orders 4,105 5,580 6,850 Projected On-Hand Inventory (POHI) (at the end of the period) 4,850 3,300 2,000 4.000 9,145 Master Production Schedule Available To Promise (1-period look ahead) Discrete Available To Promise (1-period look ahead) Cumulative 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 MRP for Period 1? What is the MRP for Period 4? What is the MRP for Period 7? What is the Discrete ATP for Period 2? What s the Discrete ATP for Period 5? What is the Cumulative ATP for Period 6