Please include the formulas used to find values.

Management Instructions Beginning Inventory Safety Stock Lot Size 7 75 144 Master Production Schedule 1 23 Period 4 5 5 6 6 7 8 Demand 505 580 575 550 520 350 100 525 Customer Orders 710 660 570 330 100 515 80 40 Projected On-Hand Inventory (POHI) (at the end of the period) 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 MPS for Period 1? What is the MPS for Period 4? What is the MPS for Period 7? What is the Discrete ATP for Period 1? What s the Cumulative ATP for Period 5? What is the Discrete ATP for Period 6