LP - Increase Decrease $F$5 Polymer Total 900 32 900 200...

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

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

LP - Increase Decrease $F$5 Polymer Total 900 32 900 200...

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