4-4 - 0.069 $D$5 Number of ounces Ingr C 4.125 0.000 0.60...

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

View Full Document Right Arrow Icon
Burn-Off Diet Drink A B C D Ingr A Ingr B Ingr C Ingr D Number of ounces 10.250 0.000 4.125 21.625 Cost (cents) $0.40 $0.20 $0.60 $0.30 $13.06 Constraints Daily dosage 1 1 1 1 36.00 >= 36 Chemical X 3 4 8 10 280.00 >= 280 Chemical Y 5 3 6 6 205.75 >= 200 Chemical Z 10 25 20 40 1050.00 <= 1050 LHS Sign RHS
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 10.0 Sensitivity Report Worksheet: [4-4.xls]Burn-Off Diet Drink Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 Number of ounces Ingr A 10.250 0.000 0.40 0.061 0.250 $C$5 Number of ounces Ingr B 0.000 0.069 0.20 1.00E+030
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 0.069 $D$5 Number of ounces Ingr C 4.125 0.000 0.60 1.500 0.073 $E$5 Number of ounces Ingr D 21.625 0.000 0.30 0.085 1.00E+030 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$8 Daily dosage 36.000 0.375 36.00 16.500 1.278 $F$9 Chemical X 280.000 0.088 280.00 41.000 11.000 $F$10 Chemical Y 205.750 0.000 200.00 5.750 1.00E+030 $F$11 Chemical Z 1050.000-0.024 1050.00 47.143 346.000...
View Full Document

This note was uploaded on 12/10/2011 for the course INSY 4508 taught by Professor Graham during the Spring '10 term at Bentley.

Page1 / 2

4-4 - 0.069 $D$5 Number of ounces Ingr C 4.125 0.000 0.60...

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