Ch2.3 - 80 100 80 6.25 20 GOLDEN ELECTRONICS GE45 GE60...

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

View Full Document Right Arrow Icon
Microsoft Excel 9.0 Answer Report Worksheet: [Book3]Golden Electronics With QC Report Created: 7/6/2001 3:36:14 PM Target Cell (Max) Cell Name Original Value Final Value $E$6 Profit Total 0 8000 Adjustable Cells Cell Name Original Value Final Value $C$4 Produce GE45 0 80 $D$4 Produce GE60 0 53.33 Constraints Cell Name Cell Value Formula Status Slack $E$7 Production Total 266.67 $E$7<=$G$7 Not Binding 33.33 $E$8 Assembly Total 240 $E$8<=$G$8 Binding 0 $E$9 Quality Control Total 80 $E$9<=$G$9 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: Golden Electronics With QC Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 Produce GE45 80 0 50 0 25 $D$4 Produce GE60 53.33 0 75 75 0 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$7 Production Total 266.67 0 300 1.00E+030 33.33 $E$8 Assembly Total 240 0 240 80 50 $E$9 Quality Control Total
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 80 100 80 6.25 20 GOLDEN ELECTRONICS GE45 GE60 Produce 80 53.33 Total Profit 50 75 8000 Production 2 2 266.67 &lt;= 300 Assembly 1 3 240 &lt;= 240 Quality Control 0.5 0.75 80 &lt;= 80 GOLDEN ELECTRONICS -- Max GE60's with $8000 Profit GE45 GE60 Produce 80 53.33 Total Profit 50 75 8000 Production 2 2 266.67 &lt;= 300 Assembly 1 3 240 &lt;= 240 Quality Control 0.5 0.75 80 &lt;= 80 GOLDEN ELECTRONICS -- Max GE45's with $8000 Profit GE45 GE60 Produce 130 20 Total Profit 50 75 8000 Production 2 2 300 &lt;= 300 Assembly 1 3 190 &lt;= 240 Quality Control 0.5 0.75 80 &lt;= 80 GOLDEN ELECTRONICS--3 times as many GE 45 as GE60 TV's GE45 GE60 Produce 106.67 35.56 Total Profit 50 75 8000 Production 2 2 284.44 &lt;= 300 Assembly 1 3 213.33 &lt;= 240 Quality Control 0.5 0.75 80 &lt;= 80 GE45 = 3GE60 1-3 =...
View Full Document

Page1 / 6

Ch2.3 - 80 100 80 6.25 20 GOLDEN ELECTRONICS GE45 GE60...

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

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