Stor. Assign. EC

Stor. Assign. EC - Formula Status Slack $B$16 Supply A 8...

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 9/19/2008 2:30:37 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$2 A1 6 0 1600 400 2400 $B$3 A2 2 0 4000 800 400 $B$4 A3 0 1600 3200 1.00E+030 1600 $B$5 B1 0 400 2800 1.00E+030 400 $B$6 B2 1 0 4800 400 800 $B$7 B3 0 1600 4000 1.00E+030 1600 $B$8 C1 0 4800 7200 1.00E+030 4800 $B$9 C2 0 3200 8000 1.00E+030 3200 $B$10 C3 7 0 2400 1600 2400 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$16 Supply A 8 -800 8 1 2 $B$17 Supply B 1 0 3 1.00E+030 2 $B$18 Supply C 7 0 10 1.00E+030 3 $B$19 Demand 1 6 2400 6 2 1 $B$20 Demand 2 3 4800 3 2 1 $B$21 Demand 3 7 2400 7 3 7
Background image of page 1

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [Book1]Sheet1 Report Created: 9/19/2008 2:31:33 PM Target Cell (Min) Cell Name Original Value Final Value $B$13 Min. Cost 39200 39200 Adjustable Cells Cell Name Original Value Final Value $B$2 A1 6 6 $B$3 A2 2 2 $B$4 A3 0 0 $B$5 B1 0 0 $B$6 B2 1 1 $B$7 B3 0 0 $B$8 C1 0 0 $B$9 C2 0 0 $B$10 C3 7 7 Constraints Cell Name Cell Value
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 Document Right Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Formula Status Slack $B$16 Supply A 8 $B$16<=$D$16 Binding $B$17 Supply B 1 $B$17<=$D$17 Not Binding 2 $B$18 Supply C 7 $B$18<=$D$18 Not Binding 3 $B$19 Demand 1 6 $B$19>=$D$19 Binding $B$20 Demand 2 3 $B$20>=$D$20 Binding $B$21 Demand 3 7 $B$21>=$D$21 Binding Variables A1 6 A2 2 A3 B1 B2 1 B3 C1 C2 C3 7 Objective Min. Cost 39200 Constraints Supply A 8 <= 8 Supply B 1 <= 3 Supply C 7 <= 10 Demand 1 6 >= 6 Demand 2 3 >= 3 Demand 3 7 >= 7 Questions a. The least cost plan would be 6 flights for A1, 2 for A2, 0 for A3, 0 for B1, 1 for B2, 0 for B3, 0 for b. The total cost for this plan will be $39200. c. New York has 0 extra planes, Boston has 2 extra planes, and Miami has 3 extra planes. r C1, 0 for C2, and 7 for C3....
View Full Document

{[ snackBarMessage ]}

Page1 / 4

Stor. Assign. EC - Formula Status Slack $B$16 Supply A 8...

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

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