Original value final value f5 min cost min cost 540

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