AppendA_Solver_LP

AppendA_Solver_LP - Adjustable Cells Final Reduced...

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

View Full Document Right Arrow Icon
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
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 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
Background image of page 2
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
Background image of page 3

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

View Full Document Right Arrow Icon
Background image of page 4
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 Right Arrow Icon
Ask a homework question - tutors are online