Dan Deceptive example

Dan Deceptive example - 4.2857142857 113000 8818.181818...

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: [Dan Deceptive example.xls]Sheet1 Target Cell (Max) Cell Name Original Value Final Value $C$15 Max profit BW 0 1058571.42857 Adjustable Cells Cell Name Original Value Final Value $C$13 no of adds to make BW 0 8.5714285714 $D$13 no of adds to make color 0 4.2857142857 Constraints Cell Name Cell Value Formula Status Slack $C$18 production used (LHS) 120000 $C$18<=$E$18 Binding 0 $C$19 airing used (LHS) 900000 $C$19<=$E$19 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: [Dan Deceptive example.xls]Sheet1 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$13 no of adds to make BW 8.5714285714 0 67000 8333.333333 4850 $D$13 no of adds to make color
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: 4.2857142857 113000 8818.181818 12500 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $C$18 production used (LHS) 120000 3.4642857143 120000 10909.09091 12000 $C$19 airing used (LHS) 900000 0.7142857143 900000 100000 75000 Dan Deceptive Advertising BW color budget production 8000 12000 120000 airing 2200 4000 900000 revenue 5200 9000 production cost 8000 2200 airing cost 2200 4000 MODEL BW color no of adds to make 8.57 4.29 Max profit 1058571.43 constraints used (LHS) RHS production 120000 <= 120000 airing 900000 <= 900000...
View Full Document

This note was uploaded on 11/18/2011 for the course BUS 220 taught by Professor Drexel during the Fall '08 term at SUNY Stony Brook.

Page1 / 3

Dan Deceptive example - 4.2857142857 113000 8818.181818...

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