please complete in excel and show formulas in each cell in yellow

1. Excelsior Springs Ltd. schedules production of one end product, Hi-Sulphur, in batches of 80 units whenever the projected ending inventory balance in a quarter falls below 10 units. It takes one quarter to make a batch of 80 units. Excelsior currently has 30 units on hand. The sales forecast for the next four quarters is: a. Prepare a time-phased MPS record showing the sales forecast and MPS for Hi-Sulphur. b. What are the inventory balances at the end of each quarter? c. During the first quarter, no units were sold. The revised forecast for the rest of the year is: Problem 1 on page 171