{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Lab Workshop 3 - Solutions

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

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

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

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

View Full Document
Heavenly Hound Kennels Model Parameters A B C Limit Cost (\$/lb) 0.45 0.4 0.27
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

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