5_RMC_What If Analysis - Microsoft Excel 14.0 Answer Report Worksheet[Week_5_RMC_What If Analysis]Sheet1 Report Created 10:22:38 AM Result Solver found

# 5_RMC_What If Analysis - Microsoft Excel 14.0 Answer Report...

This preview shows page 1 - 7 out of 21 pages.

Microsoft Excel 14.0 Answer ReportWorksheet: [Week_5_RMC_What If Analysis.xlsx]Sheet1Report Created: 8/25/2015 10:22:38 AMResult: Solver found a solution. All Constraints and optimality conditions are satisfied.Solver EngineEngine: Simplex LPSolution Time: 0.062 Seconds.Iterations: 2 Subproblems: 0Solver OptionsMax Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic ScalingMax Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegativeObjective Cell (Max)CellNameOriginal ValueFinal Value\$D\$5Profit Total16001600Variable CellsCellNameOriginal ValueFinal ValueInteger\$B\$3Solution Fuel add2525 Contin\$C\$3Solution Solvent Base2020 ContinConstraintsCellNameCell ValueFormulaStatusSlack\$D\$8Material 1 LHS20 \$D\$8<=\$F\$8Binding0\$D\$9Material 2 LHS4 \$D\$9<=\$F\$9Not Binding1\$D\$10Material 3 LHS21 \$D\$10<=\$F\$10Binding0
Microsoft Excel 14.0 Sensitivity ReportWorksheet: [Week_5_RMC_What If Analysis.xlsx]Sheet1Report Created: 8/25/2015 10:22:38 AMVariable CellsFinalReducedObjectiveAllowableAllowableCellNameValueCostCoefficientIncreaseDecrease\$B\$3Solution Fuel add250402016\$C\$3Solution Solvent Base200302010ConstraintsFinalShadowConstraintAllowableAllowableCellNameValuePriceR.H. SideIncreaseDecrease\$D\$8Material 1 LHS20 33.333333333201.56\$D\$9Material 2 LHS405 1.000E+0301\$D\$10Material 3 LHS21 44.4444444442192.25
x1x2Fuel addSolvent BaseSolution2520TotalProfit\$ 40.00 \$ 30.00 \$ 1,600.00 ConstraintsLHSSignsRHSMaterial 10.40.520<=20Material 200.24<=5Material 30.60.321<=21
Microsoft Excel 14.0 Sensitivity ReportWorksheet: [Week_5_RMC_What If Analysis.xlsx]Sheet2Report Created: 8/25/2015 10:38:04 AMVariable CellsFinalReducedObjectiveAllowableAllowableCellNameValueCostCoefficientIncreaseDecrease\$B\$3Solution Fuel add35040 1.000E+03010\$C\$3Solution Solvent Base0-5155 1.000E+030ConstraintsFinalShadowConstraintAllowableAllowableCellNameValuePriceR.H. SideIncreaseDecrease\$D\$8Material 1 LHS14020 1.000E+0306\$D\$9Material 2 LHS005 1.000E+0305\$D\$10Material 3 LHS21 66.66666666721921
x1x2Fuel addSolvent BaseSolution350TotalProfit\$ 40.00 \$ 15.00 1400ConstraintsLHSSignsRHSMaterial 10.40.514<=20Material 200.20<=5Material 30.60.321<=21We have a new solution, C2, the coefficient for the Solvent base was decrease beyond the acceptable range of 20 to 50The new solution, wants only Fuel Additive as products
Microsoft Excel 14.0 Sensitivity ReportWorksheet: [Week_5_RMC_What If Analysis.xlsx]RMC RHS Change Example

#### You've reached the end of your free preview.

Want to read all 21 pages?

• Fall '05
• EL
• Shadow price, R.H. Side, Reduced cost