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
Image of page 4
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
Image of page 5
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 >=
Image of page 6
RHS 100 40 50 10
Image of page 7
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
Image of page 8
Image of page 9

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture