please help with 1 and 2 the level production and chase production showing excel formulas. im confused on using formulas

I have labeled the three worksheets below for your solutions, Use them in this same file athd just change the fite name to put your last name(s) 1. Use Level Production Stratepy (Constant Production, will have inventory and backordef-sese explanation below) 2. Use Chase Proquction strategy (Hire and fire) 3. Use your unique strategy -a combination of different strategies-explain the strategy in a couple of sentences Instructions: 1. Solution for each strateiy needs to be on different spreadsheets labeled below as Level, Chase and Unique. 24. Show the formulae and calculation for each stratesy. in other words, cannot we calculator and type answers in. I want to see your Excel ikils also. Backorder fxample- 21i. Back Order is INe negative inventory. Let's assume john Doe orders 10 tractors from a fractor dealer in the month of 29. Baniary. The retaiter has only four to ship and is short by six to met the demand, The retailer met the demand for 4 . 30 tractors and had the remaining wik on backorder, let's assume that sohn received the fractor in Aprit, three months after. it weas ordered. The tractor dealer incurred a backorder cost for a months (\$20') months e 500 fier unit). Obvibush.. you cannot have inventory and backorders in the same monthy just like vou cannot have hiring and laying off in the same: Aggregrate Planning Problem Student Name(s): I have lsbeled the three woiksheets below for your solutions, Use them in this same file and just change the file name to put your last name(s) 1. Use Level Production Strategy (Constant Production, will have imventory and backorder-see explanation below). 2. Use Chase Production stratety (Hire and Fire ) 3. Use your unique strategy-a combination of different strategies-explain the strategy in a couple of sentences testructions: 23. Solution for each strategy needs to be on different spreadsheets labeled below as tevel, Chase and unique. 2. Show the formulae and calculation for each strategy. In other words, cannot use calculator and type answers in. I want to see your Excel skills alsa