Big Time Tires manufactures heavy-duty truck tires. The tires are manufactured in St. Louis and Detroit and

Question:

Big Time Tires manufactures heavy-duty truck tires. The tires are manufactured in St. Louis and Detroit and shipped to warehouses in Oakland, Miami, Minneapolis, Cleveland, and Boston. The following table shows the number of tires available at each plant, the number of tires required by each warehouse, and the shipping costs (in dollars per tire).

Warehouse Tires available Miami Boston Plant Oakland Minneapolis Cleveland St. Louis Detroit 5 20 10 10 9000 8000 10 4 2

a) Enter the model in Excel and solve for the optimal distribution plan. Include your spreadsheet with your homework submission.
b) What is the optimal distribution plan?
c) What is the cost of the optimal distribution plan?
d) Which warehouse will have a shortage and how big will the shortage be?

Distribution
The word "distribution" has several meanings in the financial world, most of them pertaining to the payment of assets from a fund, account, or individual security to an investor or beneficiary. Retirement account distributions are among the most...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Quantitative Methods for Business

ISBN: 978-0324651751

11th Edition

Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey cam

Question Posted: