Lease a Lemon

Lease a Lemon - 41.99999999 $B$13 Clev Pitts 3.00 0.00 131...

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

View Full Document Right Arrow Icon
Total Costs $16,495 c(i,j) Pitts Buff Phil NY 439 396 91 DC 296 434 133 Clev 131 184 479 X(i,j) Pitts Buff Phil Cars leaving from each city Surplus NY 0.00 0.00 26.00 26 <= 26 DC 29.00 0.00 0.00 29 <= 43 Clev 3.00 28.00 0.00 31 <= 31 Cars Received in each city 32 28 26 >= >= >= Demand 32 28 26
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 12.0 Sensitivity Report Worksheet: [Lease a Lemon_class.xls]Lease a Lemon Report Created: 1/25/2008 9:44:33 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$11 NY Pitts 0.00 143.00 439 1.0000E+030 143 $C$11 NY Buff 0.00 47.00 396 1.0000E+030 47 $D$11 NY Phil 26.00 0.00 91 41.99999999 91 $B$12 DC Pitts 29.00 0.00 296 47 165 $C$12 DC Buff 0.00 85.00 434 1.0000E+030 85.00000002 $D$12 DC Phil 0.00 42.00 133 1.0000E+030
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 41.99999999 $B$13 Clev Pitts 3.00 0.00 131 165 47 $C$13 Clev Buff 28.00 0.00 184 47 349 $D$13 Clev Phil 0.00 553.00 479 1.0000E+030 553 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$11 NY Cars leaving from each city 26 26 1.0000E+030 $E$12 DC Cars leaving from each city 29 43 1.0000E+030 14 $E$13 Clev Cars leaving from each city 31-165 31 29 3 $B$14 Cars Received in each city Pitts 32 296 32 14 29 $C$14 Cars Received in each city Buff 28 349 28 3 28 $D$14 Cars Received in each city Phil 26 91 26 26...
View Full Document

Page1 / 2

Lease a Lemon - 41.99999999 $B$13 Clev Pitts 3.00 0.00 131...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online