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

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

View Full Document Right Arrow Icon
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
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 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
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7

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

View Full DocumentRight Arrow Icon
Background image of page 8
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 Right Arrow Icon
Ask a homework question - tutors are online