If you wish to know which products you should manufacture and which you can discontinue and still make the maximum profit, you can use the solver scenarios in Excel to find a solution!
Implementing Solver and Scenarios in Excel
- Click on Tools in the menu bar
- Select Solver
- If the Solver tool is not installed on your computer, click on Tools, select 'Add-Ins'.
- In the Add-Ins available select 'Solver-Add-In', click 'OK' and follow the necessary instructions
- The example shows how to calculate the maximum profit by applying the necessary constraints of the 'coffeee' business in Microsoft Excel.