GOODTIRE - Solved -...

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

View Full Document Right Arrow Icon
81e77d9023a445f404bfb738f4633e7df99fefe8.xlsx Objective: Total Cost: 422540 Decisions (Changing Cells): Shipping From Akron to Regional Warehouses: Location Quantity (tires/month) Cost ($/tire) Cleveland 80000 0.25 Harrisburg 0 0.5 Chicago 50000 0.75 Trenton 58000 0.75 Louisville 60000 0.75 Shipping Quantity (tires/month) from Regional Warehouses to Wholesale Customers: Customers Cleveland Harrisburg Chicago Trenton Louisville Cleveland 30000 0 0 0 0 Cincinnati 0 0 0 0 20000 Dayton 1000 0 12000 0 5000 Indianapolis 0 0 0 0 16000 Chicago 0 0 38000 0 0 Buffalo 22000 0 0 0 0 Pittsburgh 27000 0 0 0 0 Philadelphia 0 0 0 32000 0 Nashville 0 0 0 0 19000 Boston 0 0 0 26000 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
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/16/2011 for the course OM 368 taught by Professor Morrice during the Spring '11 term at University of Texas at Austin.

Ask a homework question - tutors are online