Please complete the Indy Deck Builders mid-level exercise at the end of MS Excel – What-If Analysis Chapter.

Items (b) and (c) from the problem have to be read together i.e, Total_Profit and Total_Building_Expense range names should be applied to C15:C16.

If MS Excel on your computer does not have Solver installed, please check the chapter to see how to add-in the Solver.