4. How would you modify your MPS for problem-3 above if Sherwin Williams keeps a safety stock of 15 gallons of "Harmony Interior Acrylic Latex" paint? (10 points) Quarter On Hand 1 2 3 4 Forecast 20 70 70 20 Hojected Available Balance 30 MPS Question 3 Formula to use is given available balance Project available balance = last period available balance + MPS - Forecast If the project available balance is less than 15k then MPS quantity will be 80k, because we have to maintain a safety stock of 15k - Quarter On hand 1 2 3 4 Forecast 20 70 70 20 Projected available balance 30 90 20 30 90 (30+80 - 20) (90 +0-70) (20 + 80 - 70) (30 + 80 -20) MPS 80 0 80 80