# Question 31 Real Answer - \$B\$4 newspaper produced 2.5 4000...

This preview shows pages 1–3. Sign up to view the full content.

Microsoft Excel 12.0 Answer Report Worksheet: [Question 31.xlsx]Sheet1 Report Created: 9/27/2010 10:52:02 PM Target Cell (Min) Cell Name Original Value Final Value \$B\$7 # produced 0 40000 Adjustable Cells Cell Name Original Value Final Value \$B\$3 television # produced 0 0 \$B\$4 newspaper # produced 0 2.5 \$B\$5 radio # produced 0 5 Constraints Cell Name Cell Value Formula Status Slack \$J\$3 radio: commercial 0 \$J\$3>=\$L\$3 Binding 0 \$J\$4 total customers 100000 \$J\$4>=\$L\$4 Binding 0 \$J\$5 young:senior 2500 \$J\$5>=\$L\$5 Not Binding 2500 \$J\$6 female 25000 \$J\$6>=\$L\$6 Not Binding 25000 \$J\$7 2.5 \$J\$7<=\$L\$7 Not Binding 4.5

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Question 31.xlsx]Sheet1 Report Created: 9/27/2010 10:52:02 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$3 television # produced 0 5000 15000 1.00E+030 5000
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: \$B\$4 newspaper # produced 2.5 4000 16000 \$B\$5 radio # produced 5 6000 4000 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$J\$3 radio: commercial 6.67 0.44 \$J\$4 total customers 100000 0.4 100000 180000 100000 \$J\$5 young:senior 2500 2500 1.00E+030 \$J\$6 female 25000 25000 1.00E+030 \$J\$7 2.5 7 1.00E+030 4.5 Department Store Advertising Type of ad # produced cost young senior male female total constraints television 15000 15000 10000 10000 15000 25000 radio: commercial 0 >= newspaper 2.5 4000 3000 7000 6000 4000 10000 total customers 100000 >= 100000 radio 5 6000 12000 3000 6000 9000 15000 young:senior 2500 >= 30000 20000 22000 28000 female 25000 >= 40000 2.5 <= 7...
View Full Document

{[ snackBarMessage ]}

### Page1 / 3

Question 31 Real Answer - \$B\$4 newspaper produced 2.5 4000...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online