LPP 2 - Cost Coefficient Increase Decrease $B$2 Units L1...

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [Book4]Sheet1 Report Created: 24-07-2010 20:32:33 Target Cell (Min) Cell Name Original Value Final Value $B$5 Objective Function L1 4 1150 Adjustable Cells Cell Name Original Value Final Value $B$2 Units L1 1 150 $C$2 Units L2 2 850 Constraints Cell Name Cell Value Formula Status Slack $C$12 L1 Utilized Time 37.5 $C$12<=$E$12 Not Binding 162.5 $C$13 L2 Utilized Time 170 $C$13<=$E$13 Binding 0 $C$14 Total Unit Utilized Time 1000 $C$14=$E$14 Not Binding 0
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 12.0 Sensitivity Report Worksheet: [Book4]Sheet1 Report Created: 24-07-2010 20:32:33 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Cost Coefficient Increase Decrease $B$2 Units L1 150 2 1.00E+030 1 $C$2 Units L2 850 1 1 1.00E+030 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $C$12 L1 Utilized Time 37.5 200 1.00E+030 162.5 $C$13 L2 Utilized Time 170-5 170 30 130 $C$14 Total Unit Utilized Time 1000 2 1000 650 150 Production Lines L1 L2 Units 150 850.0000000003 Costs/hr 8 5 Time/unit 0.25 0.2 Objective Function 1150 Constraints Time Utilized Time L1 0.25 37.5 &lt;= 200 L2 0.2 170.0000000001 &lt;= 170 Total Unit 1000.0000000004 = 1000...
View Full Document

Page1 / 3

LPP 2 - Cost Coefficient Increase Decrease $B$2 Units L1...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online