Original Value Final Value F5 Min Cost Min cost 540 Variable Cells Cell Name

# Original value final value f5 min cost min cost 540

This preview shows page 4 - 9 out of 14 pages.

Original Value Final Value \$F\$5 Min Cost Min cost \$ 5.40 ### Variable Cells Cell Name Original Value Final Value Integer \$B\$3 Solution X1 40 40 Contin \$C\$3 Solution X2 0 0 Contin \$D\$3 Solution X3 50 50 Contin \$E\$3 Solution X4 10 10 Contin Constraints Cell Name Cell Value Formula Status Slack \$F\$10 >50 LHS 60 \$F\$10>=\$H\$10 Not Binding 10 \$F\$11 >10 LHS 10 \$F\$11>=\$H\$11 Binding 0 \$F\$8 Total LHS 100 \$F\$8=\$H\$8 Binding 0 \$F\$9 <40 LHS 40 \$F\$9<=\$H\$9 Binding 0
Microsoft Excel 14.0 Sensitivity Report Worksheet: [Book2]Blend Report Created: 8/25/2015 1:45:14 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$3 Solution X1 40 0 0.04 0.01 1.000E+030 \$C\$3 Solution X2 0 0.01 0.05 1.000E+030 0.01 \$D\$3 Solution X3 50 0 0.06 0.02 0.02 \$E\$3 Solution X4 10 0 0.08 1.000E+030 0.02 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$F\$10 >50 LHS 60 0 50 10 1.000E+030 \$F\$11 >10 LHS 10 0.02 10 50 10 \$F\$8 Total LHS 100 0.06 100 1.000E+030 10 \$F\$9 <40 LHS 40 -0.02 40 10 40
X1 X2 X3 X4 Solution 40 0 50 10 Min cost Min Cost \$ 0.04 \$ 0.05 \$ 0.06 \$ 0.08 \$ 5.40 Constraints LHS Signs Total 1 1 1 1 100 = <40 1 1 40 <= >50 1 1 60 >= >10 1 10 >=
RHS 100 40 50 10
Microsoft Excel 14.0 Sensitivity Report Worksheet: [Week_5_Sensitivity Analysis Practice.xlsx]Media Exposure Report Created: 8/25/2015 2:05:24 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$3 Solution Sun ads 20 0 925 1075 925 \$C\$3 Solution TV ads 0 1075 2000 1.000E+030 1075 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$D\$8 exposure city core LHS 0.8 0 0.4 0.4 1.000E+030

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

Want to read all 14 pages?

• Summer '17
• Jasmin Manseau
• Harshad number, LHS, 3rd millennium, R.H. Side