solver practice

solver practice - Report Created: 4/1/2003 2:27:20 PM...

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: [Book1]Sheet1 Report Created: 4/1/2003 2:22:03 PM Target Cell (Max) Cell Name Original Value Final Value $E$6 Volume Objective 0 0 Adjustable Cells Cell Name Original Value Final Value $B$6 Volume Z1 0 0 $C$6 Volume Z2 0 0 Constraints Cell Name Cell Value Formula Status Slack $B$14 C1 Constraints 0 $B$14<=$B$10 Not Binding 1000 $B$15 Constraints 0 $B$15<=$C$10 Binding 0 $B$6 Volume Z1 0 $B$6<=$B$8 Not Binding 400 $C$6 Volume Z2 0 $C$6<=$C$8 Not Binding 500
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 Answer Report Worksheet: [Book1]Sheet1 Report Created: 4/1/2003 2:27:20 PM Target Cell (Max) Cell Name Original Value Final Value $E$6 Volume Objective 0 2360 Adjustable Cells Cell Name Original Value Final Value $B$6 Volume Z1 0 320 $C$6 Volume Z2 0 360 Constraints Cell Name Cell Value Formula Status Slack $B$14 C1 Constraints 1000 $B$14<=$B$10 Binding 0 $B$15 C2 Constraints 2400 $B$15<=$B$11 Binding 0 $C$6 Volume Z2 360 $C$6<=$C$8 Not Binding 140 $B$6 Volume Z1 320 $B$6<=$B$8 Not Binding 80
Background image of page 2
Microsoft Excel 9.0 Sensitivity Report Worksheet: [Book1]Sheet1
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: Report Created: 4/1/2003 2:27:20 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$6 Volume Z1 320 4 2 1.75 $C$6 Volume Z2 360 3 2.33 1 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$14 C1 Constraints 1000 1.4 1000 100 233.33 $B$15 C2 Constraints 2400 0.4 2400 350 400 Microsoft Excel 9.0 Limits Report Worksheet: [Book1]Sheet1 Report Created: 4/1/2003 2:27:21 PM Target Cell Name Value $E$6 Volume Objective 2360 Adjustable Lower Target Upper Target Cell Name Value Limit Result Limit Result $B$6 Volume Z1 320 1080 320 2360 $C$6 Volume Z2 360 1280 360 2360 Z1 Z2 Objective Volume CM 4 3 Demand 400 500 Minutes 1000 2400 Constraints C1 C2 A B C D E 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 scenario 1 Page 6...
View Full Document

Page1 / 6

solver practice - Report Created: 4/1/2003 2:27:20 PM...

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