Replace X with 32 and please show formulas in excel!!

2. An operations planner, Lovell Bradley, is developing a sales and operations plan that involves backorders. The companys demand and production rates for the next eight periods are as follows

Period	Demand	Production
1	8,200 (X*10)	7,600
2	10,500 + (X*10)	8,500
3	7,500 (X*10)	8,000
4	6,600 + (X*10)	8,400
5	9,200 + (X*10)	8,600
6	8,000 (X*10)	7,700
7	6,500 (X*10)	8,100
8	8,000 + (X*10)	8,000

Beginning inventory at the start of period 1 is X*2 units. Calculate beginning inventory, ending inventory, average inventory, and the backorder amount, if any, for each of the next eight periods. (25 points)

Period:	1	2	3	4	5	6	7	8
Demand
Production
Beginning Inventory
Ending Inventory
Average Inventory
Backorders