please show the steps in excel along with the formulas, thank you!

Complete the following MRP time-phased record: The following events occurred during week 1 : 1. Actual demand during week 1 was only 5 units. 2. A scheduled receipt of 45 was received during week 1 . 3. A cycle count of on-hand units showed 17 units at the start of week 1 . 4. Marketing forecasted that 40 toasters would be required in week 9 . Update the record below after rolling through time