{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

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