Fix the Solver parameters to find the maximum possible value for the overall

average quarter income $($cell G$24)$ by changing the values in cells C$10,$ C$15,$

D$15,$ D$19,$ E$15,$ E$19,$ F$10,$ and F$19$ within the following constraints. It may be

easier to delete all of the existing constraints and start over.

a$.$ For each quarter, the value of the two variable cells for that quarter

must be equal to each other. This requires a total of four constraints.

b$.$ None of the changing cells can have a value greater than half the

average for that location $($the location average is calculated in column G$).$

This requires a total of eight constraints$$one for each variable cell where

the value is less than or equal to the value in the average cell for that

location divided by two.

c$.$ Fix the Solver parameters and then run Solver. Make sure to uncheck

the Make Unconstrained Variables Non$-$Negative check box before running

Solver. IMPORTANT NOTE: As of the release of this project, Solver on

Excel for Mac was not working properly and Mac users may not be able

to complete step $12.$c correctly.

d$.$ Keep the Solver solution and create a new scenario named: Solver

Results

$13.$ Create a scenario summary report to show the changing results for cell

G$24$ only.

$14.$ Save and