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

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

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

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

View Full Document
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
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 <= 200 L2 0.2 170.0000000001 <= 170 Total Unit 1000.0000000004 = 1000...
View Full Document

## This note was uploaded on 03/01/2012 for the course STRATEGY Om121 taught by Professor Abhinavdhar during the Spring '12 term at Harvard.

### 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
Ask a homework question - tutors are online