Chpt 4 number 26

Chpt 4 number 26 - Reduced Objective Allowable Allowable...

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [Chpt 4 number 26.xlsx]Sheet1 Report Created: 9/27/2010 9:41:18 PM Target Cell (Min) Cell Name Original Value Final Value $B$11 Cost= Cost per pount 420 420 Adjustable Cells Cell Name Original Value Final Value $D$4 lbs. Usage 200 200 $D$5 lbs. Usage 0 0 $D$6 lbs. Usage 200 200 $D$7 lbs. Usage 100 100 Constraints Cell Name Cell Value Formula Status Slack $D$8 Usage 500 $D$8>=$D$10 Binding 0 $E$8 <= 0 $E$8<=$E$10 Binding 0 $H$8 -400 $H$8<=$H$10 Not Binding 400 $F$8 Avaliable 50 $F$8>=$F$10 Not Binding 50 $G$8 Left Over 0 $G$8>=$G$10 Binding 0 $D$4 lbs. Usage 200 $D$4<=$F$4 Not Binding 100 $D$5 lbs. Usage 0 $D$5<=$F$5 Not Binding 400 $D$6 lbs. Usage 200 $D$6<=$F$6 Binding 0 $D$7 lbs. Usage 100 $D$7<=$F$7 Binding 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
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Chpt 4 number 26.xlsx]Sheet1 Report Created: 9/27/2010 9:41:18 PM Adjustable Cells Final
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $D$4 lbs. Usage 200 0.5 0.7 1.00E+030 $D$5 lbs. Usage 1.2 0.8 0.65 $D$6 lbs. Usage 200-1.3 0.6 1.3 1.00E+030 $D$7 lbs. Usage 100 2 ### 0.8 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$8 Usage 500 1.36 500 $E$8 &lt;=-0.7 50 $H$8-400 1.00E+030 400 $F$8 Avaliable 50 50 1.00E+030 $G$8 Left Over 0.8 100 Southfork Feed Company Resources Cost per pount Unit Usage Constraint Avaliable Left Over Oats 0.5 lbs. 200 &lt;= 300 100 Corn 1.2 lbs. 0 &lt;= 400 400 Soybeans 0.6 lbs. 200 &lt;= 200 Vitamin Supplement 2 lbs. 100 &lt;= 100 500 50-400 Constraint &gt;= &lt;= &gt;= &gt;= &lt;= 500 Cost= 420 d...
View Full Document

This note was uploaded on 09/01/2011 for the course BIT 2406 at Virginia Tech.

Page1 / 3

Chpt 4 number 26 - Reduced Objective Allowable Allowable...

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