{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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 Document Right Arrow Icon
Microsoft Excel 9.0 Sensitivity Report Worksheet: [Ch2.2.xls]Golden Electronics Adjustable Cells Final Reduced Objective
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

  • Spring '09
  • tannous
  • Objective Allowable Allowable, Constraint Allowable Allowable, Golden Electronics, Allowable Allowable Value

{[ snackBarMessage ]}