Please provide answer in excel format with formulas showing. This is a OSCM class.

If you can send this to Abhishek I would aporeciate it.

1. An operations planner, Lovell Bradley, is developing a sales and operations plan that involves backorders. The company's demand and production rates for the next six periods are as follows Period 3 Demand Production 8,000 +64 8,000 10,000 -6Y 8,000 7,000+32 8,200 6,600 + 648,200 10,000 -24 8,600 8,000+32 7,800 5 6 Beginning inventory at the start of period 1 is 64 units. Calculate beginning inventory, ending inventory, average inventory, and the backorder amount, if any, for each of the next six periods. 1 2 3 4 5 6 Period: Beginning Inventory Production Demand Ending Inventory Average Inventory* Backorders