Please include formulas used to find values.

Management Instructions Beginning Inventory Safety Stock Lot Size 12,105 1,500 2,400 Master Production Schedule Period 1 Demand 21,215 2 3 4 5 6 7 8 21,050 22,000 24,400 23,000 22,500 18,050 19,000 Customer Orders 22,335 24,040 25,600 18,000 33,333 6,000 7,250 3,200 Projected On-Hand Inventory (POHI) (at the end of the period) Master Production Schedule Available To Promise (1-period look ahead) Available To Promise (1-period look ahead) Cumulative What is the POHI value for Period 4? What is the POHI value for Period 5? What is the POHI value for Period 8? What is the MRP for Period 2? What is the MRP for Period 4? What is the MRP for Period 6? What is the Cumulative ATP for Period 3? What s the Discrete ATP for Period 5? What is the Discrete ATP for Period 6