{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

lab 3 excel

# lab 3 excel - Increase Decrease \$F\$5 Polymer Total 200 300...

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

Microsoft Excel 10.0 Answer Report Worksheet: [LP.xls]Sheet1 Report Created: 10/13/2010 11:13:03 PM Target Cell (Max) Cell Name Original Value Final Value \$F\$4 Profit Total 0 33600 Adjustable Cells Cell Name Original Value Final Value \$D\$11 x1 0 240 \$E\$11 x2 0 420 Constraints Cell Name Cell Value Formula Status Slack \$F\$5 Polymer Total 900 \$F\$5<=\$H\$5 Binding 0 \$F\$6 Labour hrs Total 2400 \$F\$6<=\$H\$6 Binding 0 \$F\$7 Demand 1 Total -180 \$F\$7<=\$H\$7 Not Binding 480 \$F\$8 Demand 2 Total 660 \$F\$8<=\$H\$8 Not Binding 40

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

View Full Document
Microsoft Excel 10.0 Sensitivity Report Worksheet: [LP.xls]Sheet1 Report Created: 10/13/2010 11:13:03 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$D\$11 x1 240 0 70 10 40 \$E\$11 x2 420 0 40 53.33 5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side

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: Increase Decrease \$F\$5 Polymer Total 900 32 900 200 300 \$F\$6 Labour hrs Total 2400 2 2400 200 800 \$F\$7 Demand 1 Total-180 300 1.00E+030 480 \$F\$8 Demand 2 Total 660 700 1.00E+030 40 Microsoft Excel 10.0 Limits Report Worksheet: [LP.xls]Limits Report 1 Report Created: 10/13/2010 11:13:03 PM Target Cell Name Value \$F\$4 Profit Total 33600 Adjustable Lower Target Upper Target Cell Name Value Limit Result Limit Result \$D\$11 x1 240 16800 240 33600 \$E\$11 x2 420 16800 420 33600 x1 x2 Razors Zoomers Total Availability Profit 70 40 33600 Polymer 2 1 900 <= 900 Labour hrs 3 4 2400 <= 2400 Demand 1 1-1-180 <= 300 Demand 2 1 1 660 <= 700 Output Results x1 x2 Z 240 420 33600...
View Full Document

• Fall '08
• Camateros
• Limit superior and limit inferior, Adjustable Cells Cell, Allowable Allowable Increase, Allowable Increase Decrease, Labour hrs Total

{[ snackBarMessage ]}

### Page1 / 4

lab 3 excel - Increase Decrease \$F\$5 Polymer Total 200 300...

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

View Full Document
Ask a homework question - tutors are online