Lab Workshop 3 - Solutions

Lab Workshop 3 - Solutions - Microsoft Excel 14.0...

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

View Full Document Right Arrow Icon
Microsoft Excel 14.0 Sensitivity Report Worksheet: [Lab Workshop 3 - LP - Solutions.xls]Heavenly Hound Report Created: 2/17/2011 1:33:07 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$12 x1 0.4528985507 0 0.45 0.0009090909 0.0029054054 $C$12 x2 0.3985507246 0 0.4 0.0020283019 0.0008064516 $D$12 x3 0 0 0.27 1.0000E+030 0.0062318841 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$17 Protein requirement Value 0.5 0.7246376812 0.5 0.1671875 0.15625 $B$18 Carbohydrate requirement Value 0.0625 0.0144927536 0.0625 0.0284090909 0.0221774194 $B$19 Fat Requirement Value 0.021557971 0 0.03125 1.0000E+030 0.009692029 $B$20 Non-negative A Value 0.4528985507 0 0 0.4528985507 1.0000E+030 $B$21 Non-negative B Value 0.3985507246 0 0 0.3985507246 1.0000E+030 $B$22 Non-negative C Value 0 0.0062318841 0 0.1297169811 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
Heavenly Hound Kennels Model Parameters A B C Limit Cost ($/lb) 0.45 0.4 0.27
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/04/2011 for the course ITIS ITIS 1P97 taught by Professor Dr.susansproule during the Fall '11 term at Brock University.

Page1 / 5

Lab Workshop 3 - Solutions - Microsoft Excel 14.0...

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