Shafer Office Supplies has four distribution centers, located in Atlanta, Lexington, Milwaukee, and Salt Lake City, and

Question:

Shafer Office Supplies has four distribution centers, located in Atlanta, Lexington, Milwaukee, and Salt Lake City, and ships to 12 retail stores, located in Seattle, San Francisco, Las Vegas, Tuscon, Denver, Charlotte, Minneapolis, Fayetteville, Birmingham, Orlando, Cleveland, and Philadelphia. The company wants to minimize the transportation costs of shipping one of its higher volume products, boxes of standard copy paper. The per unit shipping cost from each distribution center to each retail location and the amounts currently in inventory and ordered at each retail location are shown in the following table. Develop and solve an optimization model to minimize the total transportation cost and answer the following questions. Use the sensitivity report to answer parts c and d.

a. What is the minimum cost of shipping?
b. Which distribution centers will operate at capacity in this solution? c. Suppose that 500 units of extra supply are available (and that the cost of this extra capacity is a sunk cost). To which distribution center should this extra supply be allocated, and why?
d. Suppose that the cost of shipping from Atlanta to Birmingham increased to $.

Seattle San Francisco Las Vegas Tuscon Denver Charlotte Minneapolis Atlanta $2.15 $2.10 $1.75 $1.50 $1.20 $0.65 $0.90 Lexington $1.95 $2.00 $1.70 $1.53 $1.10 $0.55 $0.60 Milwaukee $1.70 $1.85 $1.50 $1.41 $0.95 $0.40 $0.40 Salt Lake City $0.60 $0.55 $0.35 $0.60 $0.40 $0.95 $1.00 Demand 5,000 16,000 4,200 3,700 4,500 7,500

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
Question Posted: