4-2 - Binding 0.00 Microsoft Excel 10.0 Sensitivity Report...

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

View Full Document Right Arrow Icon
Anderson Electronics V S T D VCR Stereo TV DVD Solution value 0.00 380.00 0.00 1060.00 Selling price $70 $80 $150 $110 $147,000.00 Cost price $41 $48 $78 $56 $77,600.00 Profit $29 $32 $72 $54 $69,400.00 Constraints Cost Electronic comp 3 4 4 3 4700.00 <= 4700 $7 Non-electronic comp 2 2 4 3 3940.00 <= 4500 $5 Assembly time 1 1 3 2 2500.00 <= 2500 $10 LHS Sign RHS
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 10.0 Answer Report Worksheet: [4-2.xls]Anderson Electronics Target Cell (Max) Cell Name Original Value Final Value $F$8 Profit $0.00 $69,400.00 Adjustable Cells Cell Name Original Value Final Value $B$5 Solution value VCR 0.00 0.00 $C$5 Solution value Stereo 0.00 380.00 $D$5 Solution value TV 0.00 0.00 $E$5 Solution value DVD 0.00 1060.00 Constraints Cell Name Cell Value Formula Status Slack $F$10 Electronic comp 4700.00 $F$10<=$H$10 Binding 0.00 $F$11 Non-electronic comp 3940.00 $F$11<=$H$11 Not Binding 560.00 $F$12 Assembly time 2500.00 $F$12<=$H$12
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: Binding 0.00 Microsoft Excel 10.0 Sensitivity Report Worksheet: [4-2.xls]Anderson Electronics Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 Solution value VCR 0.00-1.00 29.00 1.00 1.00E+030 $C$5 Solution value Stereo 380.00 0.00 32.00 40.00 1.67 $D$5 Solution value TV 0.00-8.00 72.00 8.00 1.00E+030 $E$5 Solution value DVD 1060.00 0.00 54.00 10.00 5.00 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$10 Electronic comp 4700.00 2.00 4700.00 2800.00 950.00 $F$11 Non-electronic comp 3940.00 0.00 4500.00 1.00E+030 560.00 $F$12 Assembly time 2500.00 24.00 2500.00 466.67 1325.00...
View Full Document

This note was uploaded on 12/10/2011 for the course INSY 4508 taught by Professor Graham during the Spring '10 term at Bentley.

Page1 / 3

4-2 - Binding 0.00 Microsoft Excel 10.0 Sensitivity Report...

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