GOODTIRE - Set up with Solver

GOODTIRE - Set up with Solver - Amount Shipped Out...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
eb8dee68413fd54d66d550dc7fa0fbdbbaf68987.xlsx Objective: Total Cost: 0 Decisions (Changing Cells): Shipping From Akron to Regional Warehouses: Location Quantity (tires/month) Cost ($/tire) Cleveland 0 0.25 Harrisburg 0 0.5 Chicago 0 0.75 Trenton 0 0.75 Louisville 0 0.75 Shipping Quantity (tires/month) from Regional Warehouses to Wholesale Customers: Customers Cleveland Harrisburg Chicago Trenton Louisville Cleveland 0 0 0 0 0 Cincinnati 0 0 0 0 0 Dayton 0 0 0 0 0 Indianapolis 0 0 0 0 0 Chicago 0 0 0 0 0 Buffalo 0 0 0 0 0 Pittsburgh 0 0 0 0 0 Philadelphia 0 0 0 0 0 Nashville 0 0 0 0 0 Boston 0 0 0 0 0 Shipping Cost ($/tire) from Regional Warehouses to Wholesale Customers: Customers Cleveland Harrisburg Chicago Trenton Louisville Cleveland 0.25 0.63 1.75 2.13 1.75 Cincinnati 1.25 1.5 1.5 2.75 0.5 Dayton 0.75 1.38 1.38 2.38 1 Indianapolis 1.63 1.75 1 3.5 0.5 Chicago 1.75 2.38 0.25 3.88 1.5 Buffalo 1 1.13 2.75 1.88 2.75 Pittsburgh 0.63 0.88 2.38 1.75 2 Philadelphia 2.13 0.63 3.88 0.5 3.5 Nashville 2.63 2.88 2.38 4.25 0.88 Boston 3.25 2.75 5 1.25 4.88 Fixed Costs Decision (1 locate; 0 do not locate) Cost ($/month) Capacity (tires/month) Cleveland 0 40000 80000 Harrisburg 0 20000 60000 Chicago 0 30000 60000 Trenton 0 25000 60000 Louisville 0 20000 60000 Constraints: Regional-Warehouse Flow Constraints: Amount Shipped In (tires/month)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Amount Shipped Out (tires/month) Cleveland Harrisburg Chicago Trenton Louisville Regional-Warehouse Capacity Constraints: Capacity Used (tires/month) Capacity Available (tires/month) Cleveland Harrisburg Chicago Trenton Louisville Wholesale Customer Demand Constraints: Amount Shipped In (tires/month) Demand (tires/month) Cleveland 30000 Cincinnati 20000 Dayton 18000 Indianapolis 16000 Chicago 38000 Buffalo 22000 Pittsburgh 27000 Philadelphia 32000 Nashville 19000 Boston 26000 Good Tire, Inc Warehouse-Location Problem B C D E F G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86...
View Full Document

Ask a homework question - tutors are online