Question 31 Real Answer

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
Background image of page 3
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 &gt;= newspaper 2.5 4000 3000 7000 6000 4000 10000 total customers 100000 &gt;= 100000 radio 5 6000 12000 3000 6000 9000 15000 young:senior 2500 &gt;= 30000 20000 22000 28000 female 25000 &gt;= 40000 2.5 &lt;= 7...
View Full Document

Page1 / 3

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

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online