Project #2 Result

Project #2 Result - 4000 92 4000 1.0000E+030 4000 $E$23...

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 11/8/2010 9:51:03 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$12 Number to produce A 0 1 76 1.0000E+030 1.3333333313 $C$12 Number to produce B 2667 0 90 1.9999999968 1.0000E+030 $D$12 Number to produce C 0 28 148 1.0000E+030 28.33333333 $B$13 Number to subcontract A 4000 0 92 1.3333333312 1.0000E+030 $C$13 Number to subcontract B 333 0 116 1.0000E+030 1.9999999968 $D$13 Number to subcontract C 1800 0 163 28.33333333 1.0000E+030 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$20 Machine Time LHS 6666.666667 0 13000 1.0000E+030 6333.333333 $E$21 Labor Time LHS 8000 -8.6666666659 8000 1000 8000 $E$22 Demand A LHS
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 4000 92 4000 1.0000E+030 4000 $E$23 Demand B LHS 3000 116 3000 1.0000E+030 333.3333333 $E$24 Demand C LHS 1800 163 1800 1.0000E+030 1800 Christian Liyadi Model A Model B Model C Number ordered 4,000 3,000 1800 Cost For One Hour of Machine time 12 Required machine hrs/unit 3 2.5 4 Cost For One Hour of Labor time 20 Required labor hrs/unit 2 3 5 Cost Per Unit 76 90 148 Target Subcontraction Cost Per Unit 92 116 163 940067 A B C Number to produce 2667 Number to subcontract 4000 333 1800 Subject Constraints A B C LHS RHS Machine Time 3 2.5 4 6667 <= 13000 Labor Time 2 3 5 8000 <= 8000 Demand A 4000 = 4000 Demand B 3000 = 3000 Demand C 1800 = 1800...
View Full Document

Page1 / 2

Project #2 Result - 4000 92 4000 1.0000E+030 4000 $E$23...

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

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