Please solve in excel (Fill table)

Word questions below

Instructions: Complete the MPS table, then answer questions below. Do not modify completed MPS table when answering questions. Copy and paste table below questions (below row 23) and show changes td table in copied version if desired. Period On- Hand Forecast DI 35 25 30 20 | 25 15 | 20 30 15 20 300 Customer Orders Projected Available Available to Promise MPS | 25 MPS Lot Size = adei Page 2 Lead-time = 0 Projected Available = BI + MPS - Max (Customer Orders; Forecast) ATP action bucket = BI + MPS - customer orders between current MPS and next scheduled replenishment Available to Promise = MPS - customer orders between current MPS and next scheduled replenishment Questions: - Would you accept an order for 25 units in period 6? Why? (answer in complete sehtences) - Would you accept an order for 50 units in period 8? Why? What could you do instead? (answer in complete sentences)