View Homework Help - Interpreting+Excel+Solver+Sensitivity+Report from MGT 2251 at Georgia Institute Of Technology. 1 Interpreting Excels Sensitivity Report to Assess the Impact of Changes to a. Solve the following optimization model using the Excel Solver and generate a sensitivity report. Upload the final excel file. Min z = 10x1 + 11x2 +9X3 s.t 15x1 + 13x2 +19x3 2 400 16X1 + 15x2 + 18x3 2550 5X1 +4x2 + 10x3 s 150 X1,42,43 20. It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs. Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help.
- Excel Solver Nt Generating Sensitivity Reported
- Excel Solver Nt Generating Sensitivity Report Example
Reduced Cost | Shadow Price
Sensitivity analysis gives you insight in how the optimal solution changes when you change the coefficients of the model. After the solver found a solution, you can create a sensitivity report.
1. Before you click OK, select Sensitivity from the Reports section.
Below you can find the optimal solution and the sensitivity report.
It is optimal to order 94 bicycles and 54 mopeds. This solution gives the maximum profit of 25600. This solution uses all the resources available (93000 units of capital and 101 units of storage). You can find these numbers in the Final Value column.
Reduced Cost
The reduced costs tell us how much the objective coefficients (unit profits) can be increased or decreased before the optimal solution changes. If we increase the unit profit of Child Seats with 20 or more units, the optimal solution changes.
Excel Solver Nt Generating Sensitivity Reported
1. At a unit profit of 69, it's still optimal to order 94 bicycles and 54 mopeds. Below you can find the optimal solution.
2. At a unit profit of 71, the optimal solution changes.
Conclusion: it is only profitable to order child seats if you can sell them for at least 70 units.
Shadow Price
The shadow prices tell us how much the optimal solution can be increased or decreased if we change the right hand side values (resources available) with one unit.
1. With 101 units of storage available, the total profit is 25600. Below you can find the optimal solution.
2. With 102 units of storage available, the total profit is 25700 (+100).
Excel Solver Nt Generating Sensitivity Report Example
Note: with a shadow price of 100 for this resource, this is according to our expectations. This shadow price is only valid between 101 - 23,5 and 101 + 54 (see sensitivity report).