Ch2.2 - Objective Allowable Allowable Cell Name Value Cost...

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: [Ch2.2.xls]Golden Electronics Report Created: 7/6/2001 3:27:56 PM Target Cell (Max) Cell Name Original Value Final Value $E$6 Profit Total 0 8625 Adjustable Cells Cell Name Original Value Final Value $C$4 Produce GE45 0 105 $D$4 Produce GE60 0 45 Constraints Cell Name Cell Value Formula Status Slack $E$7 Production Total 300 $E$7<=$G$7 Binding 0 $E$8 Assembly Total 240 $E$8<=$G$8 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: [Ch2.2.xls]Golden Electronics Adjustable Cells Final Reduced
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: Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 Produce GE45 105 50 25 25 $D$4 Produce GE60 45 75 75 25 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$7 Production Total 300 18.75 300 180 140 $E$8 Assembly Total 240 12.5 240 210 90 GOLDEN ELECTRONICS GE45 GE60 Produce 105 45 Total Profit 50 75 8625 Production 2 2 300 <= 300 Assembly 1 3 240 <= 240...
View Full 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 / 3

Ch2.2 - Objective Allowable Allowable Cell Name Value Cost...

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