T N P A
TV
spots
Newspaper
ads
Prime-time
radio spots
Afternoon
radio spots
Constraints:
Maximum TV 1 1.97 <= 12
Win Big Gambling Club
Problem 4-13. Win Big Gambling Club
Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$5 Number of units TV spots 1.97 0.00 5000.00 1620.69 5000.00
$C$5 Number of units Newspaper ads 5.00 0.00 8500.00 1E+30 2718.75
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$F$8 Maximum TV 1.97 0.00 12.00 1E+30 10.03
Microsoft Excel 14.0 Sensitivity Report