Ch2.6 - Microsoft Excel 9.0 Answer Report Worksheet[Book2]Sheet1 Report Created 4:12:13 PM Target Cell(Max Cell Name $E$6 Exposure Total Adjustable

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

View Full Document Right Arrow Icon
Microsoft Excel 9.0 Answer Report Worksheet: [Book2]Sheet1 Report Created: 7/6/2001 4:12:13 PM Target Cell (Max) Cell Name Original Value Final Value $E$6 Exposure Total 0 520000 Adjustable Cells Cell Name Original Value Final Value $C$4 Ads Weekday 0 12 $D$4 Ads Sunday 0 2 Constraints Cell Name Cell Value Formula Status Slack $E$7 Budget Total 40000 $E$7<=$G$7 Binding 0 $E$8 Max Weekday Total 12 $E$8<=$G$8 Not Binding 14 $E$9 Max Sunday Total 2 $E$9<=$G$9 Not Binding 3 $E$10 Min Weekday Total 12 $E$10>=$G$10 Not Binding 4 $E$11 Min Sunday Total 2 $E$11>=$G$11 Binding 0
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 9.0 Sensitivity Report Worksheet: [Book2]Sheet1 Report Created: 7/6/2001 4:12:14 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 Ads Weekday 12 0 30000 1.00E+030 10000 $D$4 Ads Sunday 2 0 80000 40000 1.00E+030 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$7 Budget Total 40000 15 40000 28000
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/15/2009 for the course MGT mgt taught by Professor Tannous during the Spring '09 term at University of Houston - Downtown.

Page1 / 6

Ch2.6 - Microsoft Excel 9.0 Answer Report Worksheet[Book2]Sheet1 Report Created 4:12:13 PM Target Cell(Max Cell Name $E$6 Exposure Total Adjustable

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