I have labeled the three worksheets below for your solutions. Use them in this same file and just change the file name to put your last name$($s$)$

Use Level Production Strategy $($Constant Production, will have inventory and backorder$--$see explanation below$)$

Use Chase Production strategy $($Hire and Fire$)$

Use your unique strategy$--$a combination of different strategies$--$explain the strategy in a couple of sentences

Instructions:

Solution for each strategy needs to be on different spreadsheets labeled below as Level, Chase and Unique.

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 also.