# M and D - Microsoft Excel 11.0 Answer Report Worksheet[M...

• Notes
• PrivateBraveryPrairieDog9600
• 8

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.

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.

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

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

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

• Spring '08
• MARTIN
• Optimization, Hebrew numerals, Adrenergic receptor, gallons

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern