Using the same data shown here you will create a aggregate plan and then evaluate those plans from a managerial perspective.$$ Please make sure you leave enough time to do a careful evaluation of the plan results.$$ It is a critical part of your homework grade.

Plan A$--$No Promotion

Use Maximize Profit as the objective function.

$1.$ Complete the spreadsheet by entering formulas for each cost $($cells C$36$ through I$36$ and B$48),$ each definitional constraint $($range of cells B$42$:E$47),$ and the Total Cost, Total Revenue, and Total Profit formulas.$$ Don't forget to include possible December backlogs in your total revenue equation.

$2.$ Complete the Solver Window model.

$$ a$.$ Use maximize$$ profit as the objective function

$$ b$.$ Select the change cell range

$$ c$.$ Enter the $3$ must have constraints and do a preliminary analysis to make sure the model runs.

$$ d$.$ Add the constraint on ending inventory.$$ Note you must have a minimum of $500$ units, but may have more.

$$ e$.$ Add constraint$($s$)$ preventing hiring and firing.

$$

$3.$ Run the model and check your results.$$ You must get a solution.

$4.$ Proceed to Plan B by doing the following:

$$ a$.$ Save the Solver model in an empty range on this spreadsheet.

$$ b$.$ Copy this spreadsheet into the Plan B worksheet.

$$ c$.$ Load the Solver model into the Plan B worksheet and follow the instructions posted on that worksheet.