The Financial Targets worksheet has been set up with Solver parameters to find reasonable target sales goals for the two worst locations for each quarter. Some locations had shown very uneven profit-loss results from quarter-to-quarter. The Solver parameters include constraints to limit the new sales target for each cell to less than or equal to the average quarterly sales for that location. Fix the Solver parameters to find the maximum possible value for the overall average quarter income (cell G24) by changing the values in cells C10, C15, D15, D19, E15, E19, F10, and F19 within the following constraints. It may be easier to delete all of the existing constraints and start over. 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. 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 constraintsone 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. Fix the Solver