PA-Question# 1-Flamingo.xlsx - Microsoft Excel 16.0...

This preview shows page 1 - 3 out of 12 pages.

Microsoft Excel 16.0 Sensitivity Report Worksheet: [PA-QN1.xlsx]Flamingo Report Created: 6/4/2018 6:10:46 AM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $D$8 Number of add Television 10 0 90 1.00E+030 35 $E$8 Number of add radio 15 0 25 1.00E+030 5 $F$8 Number of add News paper 20 0 10 1.00E+030 5 $J$8 Number of add Television 5 0 55 15 5 $K$8 Number of add radio 18 0 20 5 3.75 $L$8 Number of add News paper 10 0 5 0.5 32.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $H$12 <= 279000 0.005416667 279000 60000 0 $H$13 >= 150000 0 140000 10000 1.00E+030 $H$14 <= 99000 0.00125 99000 0 54000 $H$15 >= 30000 0 30000 0 1.00E+030 $H$16 <= 10 35 10 5 10 $H$17 <= 15 5 15 18 15 $H$18 <= 20 5 20 10 20 $H$19 >= 127100 0 100000 27100 1.00E+030 $H$20 <= 15 0 20 1.00E+030 5 $H$21 >= 0 -0.416666667 0 12 0
Advertising media Television Exposure rating per add 90 New customer per add 4000 Cost per add 10000 Number of add 10 Constraints Total budget 0 Budget for TV 0 Budget for radio Budget for news paper Maximum number of TV add for hig 0 Maximum number of Radio add for high output Maximum number of Nes paper add for high output Maximum customer add 0 Number of TV add 0 Number of radio add

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture