Please post solution on Excel and show formulas used to solve this. Thank you!

8. An operations planner, Lovell Bradley, is developing a sales and operations plan that involves back orders. The company's demand and production rates for the next four periods are as follows: Beginning inventory at the start of period 1 is 400 units. Calculate beginning inventory, ending inventory, average inventory, and the back order amount, if any, for each of the next four periods. 8. An operations planner, Lovell Bradley, is developing a sales and operations plan that involves back orders. The company's demand and production rates for the next four periods are as follows: Beginning inventory at the start of period 1 is 400 units. Calculate beginning inventory, ending inventory, average inventory, and the back order amount, if any, for each of the next four periods