lab 3 excel - Increase Decrease $F$5 Polymer Total 900 32...

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 DocumentRight 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 DocumentRight 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 &lt;= 900 Labour hrs 3 4 2400 &lt;= 2400 Demand 1 1-1-180 &lt;= 300 Demand 2 1 1 660 &lt;= 700 Output Results x1 x2 Z 240 420 33600...
View Full Document

This note was uploaded on 05/09/2011 for the course MGMT 3100 taught by Professor Camateros during the Fall '08 term at CSU East Bay.

Page1 / 4

lab 3 excel - Increase Decrease $F$5 Polymer Total 900 32...

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