Please write the formulas you used and explanation on how to use the solver parameters

Design a spreadsheet that can be used to evaluate aggregate plans. The spreadsheet should enable the evaluation of: 1. pure strategy based on leveling production, 2. pure strategy based on minimizing inventory by laying off/hiring as needed, 3. a mix of the above two. The spreadsheet should have the following headings: All but columns 1,2 , and 4 should be computed using cell formulas. Column 5 should allow for using cell formulas in the case of level production or direct input for mixed plans. The cost of any plan, in total and for each cost component, should be computed without additional effort. Assume an 8-month horizon and use the following data to test your spreadsheet