# 2.17.11 - Microsoft Excel 12.0 Answer Report...

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

Microsoft Excel 12.0 Answer Report Worksheet: [P4.7.xlsx]Sheet1 Report Created: 08/04/2010 7:10:43 PM Target Cell (Max) Cell Name Original Value Final Value \$J\$4 Max P = 250G + 150A Max P 0 32500 Adjustable Cells Cell Name Original Value Final Value \$H\$2 Production G 0 130 \$I\$2 Production A 0 0 Constraints Cell Name Cell Value Formula Status Slack \$J\$6 Wiring Required 260 \$J\$6<=\$L\$6 Binding 0 \$J\$7 Testing Required 130 \$J\$7<=\$L\$7 Not Binding 10

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

View Full Document
Microsoft Excel 12.0 Sensitivity Report Worksheet: [P4.7.xlsx]Sheet1 Report Created: 08/04/2010 7:10:44 PM Adjustable Cells Cell Name \$H\$2 Production G \$I\$2 Production A Constraints Cell Name \$J\$6 Wiring Required \$J\$7 Testing Required
change in your objective function by Final Reduced Objective Allowable Value Cost Coefficient Increase 130 0 250 1.00E+030 0 -225 150 225 Final Shadow Constraint Allowable Value Price R.H. Side Increase 260 125 260 20 130 0 140 1.00E+030

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

View Full Document
y 1; gain \$ in revenue Allowable Decrease 150 1.00E+030 Allowable Decrease 260 10 we can add 10 hours because this says 20
Microsoft Excel 12.0 Limits Report

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 8

2.17.11 - Microsoft Excel 12.0 Answer Report...

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

View Full Document
Ask a homework question - tutors are online