{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

solver practice

# solver practice - Report Created 2:27:20 PM Adjustable...

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

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

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

View Full Document
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
Microsoft Excel 9.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 4/1/2003 2:27:20 PM

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

View Full Document

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: 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

{[ snackBarMessage ]}

### Page1 / 6

solver practice - Report Created 2:27:20 PM Adjustable...

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

View Full Document
Ask a homework question - tutors are online