Solving Your Problem

To run an optimization problem in Excel, you need to enable the add-on called “Solver.” Follow the link below for details or see the image below.

Screenshot of steps to download Excel solver

Click here for more help if you are having trouble.

You can find your solver add-in by clicking on “data” and then “solver” in the header.

Screenshot of where to find “Solver” add in on the header bar

Next, please download the following template

Follow along in the template to help set up your problem. When using “Solver” you just need to select the cell number and the appropriate relationship between the cells. Your instructor can help you with this if you’re unfamiliar with Excel.

You can use the “answers” Excel to check your answers. There is also a screenshot of the correct way to set up your Solver.


Good luck!