Texas Transport Example Solved

Texas Transport Example Solved - $E$5 San Antonio Temple...

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

View Full Document Right Arrow Icon
Shipping Quantity from Plants to Distribution Centers (in 1,000 units) Distribution Centers Plants San Marcos Waco Temple Austin San Antonio 0 0 0 45 Dallas 42 78 0 0 Arlingon 38 0 47 10 Shipping Costs ($/1000 units) from Plants to Distribution Centers Distribution Centers Plants San Marcos Waco Temple Austin San Antonio 250 420 380 280 Dallas 1280 990 1440 1520 Arlingon 1550 1420 1660 1730 Objective (Target Cell) Total Cost: 297800 Constraints Supply Amount Produced Capacity San Antonio 45 45 Dallas 120 120 Arlingon 95 95 Demand Constraints Amount Shipped In Demand San Marcos 80 80 Waco 78 78 Temple 47 47 Austin 55 55
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: [Texas Transport Example.xlsx]Sheet1 Report Created: 9/5/2011 12:26:41 PM Target Cell (Min) Cell Name Original Value Final Value $C$17 Total Cost: San Marcos 0 297800 Adjustable Cells Cell Name Original Value Final Value $C$5 San Antonio San Marcos 0 0 $D$5 San Antonio Waco
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $E$5 San Antonio Temple $F$5 San Antonio Austin 45 $C$6 Dallas San Marcos 42 $D$6 Dallas Waco 78 $E$6 Dallas Temple $F$6 Dallas Austin $C$7 Arlingon San Marcos 38 $D$7 Arlingon Waco $E$7 Arlingon Temple 47 $F$7 Arlingon Austin 10 Constraints Cell Name Cell Value Formula Status Slack $C$21 San Antonio Amount Produced 45 $C$21<=$D$21 Binding $C$22 Dallas Amount Produced 120 $C$22<=$D$22 Binding $C$23 Arlingon Amount Produced 95 $C$23<=$D$23 Binding $C$26 San Marcos Amount Shipped In 80 $C$26>=$D$26 Binding $C$27 Waco Amount Shipped In 78 $C$27>=$D$27 Binding $C$28 Temple Amount Shipped In 47 $C$28>=$D$28 Binding $C$29 Austin Amount Shipped In 55 $C$29>=$D$29 Binding...
View Full Document

{[ snackBarMessage ]}

Page1 / 2

Texas Transport Example Solved - $E$5 San Antonio Temple...

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