Example 6

# Example 6 - Increase Decrease \$B\$3 Units to be Produced...

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

Microsoft Excel 12.0 Answer Report Worksheet: [Book2]Sheet1 Report Created: 25-07-2010 12:02:52 Target Cell (Max) Cell Name Original Value Final Value \$E\$5 Objective function 12.25 112.5 Adjustable Cells Cell Name Original Value Final Value \$B\$3 Units to be Produced Bread 1 0 \$C\$3 Units to be Produced Cake 2 0 \$D\$3 Units to be Produced Pizza 3 45 Constraints Cell Name Cell Value Formula Status Slack \$B\$3 Units to be Produced Bread 0 \$B\$3>=3*\$C\$3 Binding 0 \$D\$3 Units to be Produced Pizza 45 \$D\$3>=3*\$C\$3 Not Binding 45 \$E\$7 A Used 135 \$E\$7<=\$G\$7 Not Binding 15 \$E\$8 B Used 89.9999999999 \$E\$8<=\$G\$8 Binding 0 \$E\$9 C Used 45 \$E\$9<=\$G\$9 Not Binding 105

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

View Full Document
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Book2]Sheet1 Report Created: 25-07-2010 12:02:53 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Increase Decrease \$B\$3 Units to be Produced Bread-0.5 0.75 0.5 1.00E+030 \$C\$3 Units to be Produced Cake-0.5 2 0.5 1.00E+030 \$D\$3 Units to be Produced Pizza 45 2.5 1.00E+030 0.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$B\$3 Units to be Produced Bread 1.00E+030 \$D\$3 Units to be Produced Pizza 45 45 1.00E+030 \$E\$7 A Used 135 150 1.00E+030 15 \$E\$8 B Used 90 1.25 90 10 90 \$E\$9 C Used 45 150 1.00E+030 105 Bread Cake Pizza Units to be Produced 45 Sales price 0.75 2 2.5 Objective function 112.4999999999 Ingredients Used Availability A 1 5 3 134.9999999999 <= 150 B 1 2 2 89.9999999999 <= 90 C 2 1 1 45 <= 150...
View Full Document

{[ snackBarMessage ]}

### Page1 / 3

Example 6 - Increase Decrease \$B\$3 Units to be Produced...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online