{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chpt 4 number 26

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

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

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

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

View Full Document
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
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 <=-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 <= 300 100 Corn 1.2 lbs. 0 <= 400 400 Soybeans 0.6 lbs. 200 <= 200 Vitamin Supplement 2 lbs. 100 <= 100 500 50-400 Constraint >= <= >= >= <= 500 Cost= 420 d...
View Full Document

{[ snackBarMessage ]}

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