Solver: Go back to Income Statement sheet. It must be completed by now. Copy the gray area (A3:G23). Go to the sheet of Solver Analysis, and paste it at the cell A3.
At the blank Rows 1 & 2, merge some cells and add a title 2017 Income Statement Projections
Change the label Unit Sold (at the cell C3) to Units to Sell.
Within the Solver Analysis worksheet, input the following Solver Parameters:
Objective cell: Net Profit (C22) to the value of $80,000.
Constraint 1: Product A must sell at least 6000 units
Constraint 2: Total Operating Expenses is less than or equal $215,000.
Constraint 3: All unit sold quantities (C4:C7) are integers.
Write up a brief conclusion on the major findings from the solver analysis.