AppendA_Solver_LP

# AppendA_Solver_LP - Adjustable Cells Final Reduced...

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

Hockey Sticks and Chess Sets Page 1 Exhibit A.2 Hockey Sticks Chess Sets Total Decision 24 4 28 Profit \$2 \$4 \$64 Resources Hockey Sticks Chess Sets Used Capacity Machine A 4 6 120 <= 120 Machine B 2 6 72 <= 72 Machine C 1 4 <= 10

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

View Full Document
Microsoft Excel 9.0 Answer Report Worksheet: [TN2_Solver_LP.xls]Hockey Stocks and Chess Sets Report Created: 2/28/2003 9:51:54 AM Target Cell (Max) Cell Name Original Value Final Value \$D\$5 Profit Total \$64 \$64 Adjustable Cells Cell Name Original Value Final Value \$B\$4 Decision Hockey Sticks 24 24 \$C\$4 Decision Chess Sets 4 4 Constraints Cell Name Cell Value Formula Status Slack \$D\$9 Machine A Used 120 \$D\$9<=\$F\$9 Binding 0 \$D\$10 Machine B Used 72 \$D\$10<=\$F\$10 Binding 0 \$D\$11 Machine C Used 4 \$D\$11<=\$F\$11 Not Binding 6 \$B\$4 Decision Hockey Sticks 24 \$B\$4>=0 Not Binding 24 \$C\$4 Decision Chess Sets 4 \$C\$4>=0 Not Binding 4
Microsoft Excel 9.0 Sensitivity Report Worksheet: [TN2_Solver_LP.xls]Hockey Stocks and Chess Sets Report Created: 2/28/2003 9:51:55 AM

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.

Unformatted text preview: Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$4 Decision Hockey Sticks 24 2 0.67 0.67 \$C\$4 Decision Chess Sets 4 4 2 1 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$D\$9 Machine A Used 120 0.33 120 24 36 \$D\$10 Machine B Used 72 0.33 72 18 12 \$D\$11 Machine C Used 4 10 1.00E+030 6 Microsoft Excel 9.0 Limits Report Worksheet: [TN2_Solver_LP.xls]Hockey Sticks and Chess Sets Report Created: 2/28/2003 9:51:55 AM Target Cell Name Value \$D\$5 Profit Total \$64 Adjustable Lower Target Upper Target Cell Name Value Limit Result Limit Result \$B\$4 Decision Hockey Sticks 24 16 24 64 \$C\$4 Decision Chess Sets 4 48 4 64...
View Full Document

{[ snackBarMessage ]}

### Page1 / 4

AppendA_Solver_LP - Adjustable Cells Final Reduced...

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

View Full Document
Ask a homework question - tutors are online