M and D

# M and D - \$C\$11 Gallons produced 600-1 600 100 125 \$C\$12...

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

Microsoft Excel 11.0 Answer Report Worksheet: [M and D.xls]Problem Formulation Report Created: 6/1/2009 9:33:16 PM Target Cell (Min) Cell Name Original Value Final Value \$C\$6 Minimize Total Cost A 800 800 Adjustable Cells Cell Name Original Value Final Value \$C\$3 Gallons Produced A 250 250 \$D\$3 Gallons Produced B 100 100 Constraints Cell Name Cell Value Formula Status Slack \$C\$9 Gallons produced 350 \$C\$9>=\$E\$9 Binding 0 \$C\$10 Gallons produced 250 \$C\$10>=\$E\$10 Not Binding 125 \$C\$11 Gallons produced 600 \$C\$11<=\$E\$11 Binding 0 \$C\$12 Gallons produced 100 \$C\$12>=\$E\$12 Not Binding 100

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

View Full Document
Microsoft Excel 11.0 Sensitivity Report Worksheet: [M and D.xls]Problem Formulation Report Created: 6/1/2009 9:33:16 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$C\$3 Gallons Produced A 250 0 2 1 1.00E+030 \$D\$3 Gallons Produced B 100 0 3 1.00E+030 1 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$C\$9 Gallons produced 350 4 350 125 50 \$C\$10 Gallons produced 250 0 125 125 1.00E+030

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

View Full Document

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

View Full Document

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: \$C\$11 Gallons produced 600-1 600 100 125 \$C\$12 Gallons produced 100 100 1.00E+030 Product A B Gallons Produced 250 100 Minimize Total Cost 800 Constraints Gallons produced Gallons required 350 >= 350 250 >= 125 600 <= 600 100 >= Min 2A + 3B Subject to: 1A + 1B ≥ 350 1A ≥ 125 2A + 1B ≤ 600 1B ≥ 0 Constraints Start Point End Point A B A B 1A + 1B >=350 350 350 1A >=125 125 125 600 2A + 1B <=600 300 600 B >=0 600 Start Point End Point Equation A B A B 2A + 3B = 1200 600 400 2A + 3B = 800 400 266.67 100 200 300 400 500 6 100 200 300 400 500 600 700 Feasible Region for the M&D Problem Gallons of Product A Gallons of Product B Feasible Region 400 500 600 700 Total Cost for the M&D Problem roduct B 100 200 300 400 500 60 100 200 300 Gallons of Product A Gallons of Pr Optimal Solution (250,100) 250 600 700 00 700...
View Full Document

## This note was uploaded on 12/04/2010 for the course ACCT 3200 taught by Professor Martin during the Fall '08 term at Kennesaw.

### Page1 / 8

M and D - \$C\$11 Gallons produced 600-1 600 100 125 \$C\$12...

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

View Full Document
Ask a homework question - tutors are online