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 $.

Transcribed Image Text:

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 3,000 Fayetteville Bimingham Orlando Cleveland Philadelphia Supply Atlanta $0.80 $0.35 $0.15 $0.60 $0.50 40,000 Lexington $1.05 $0.60 $0.50 $0.25 $0.30 35,000 Milwaukee $0.95 $0.70 $0.70 $0.35 $0.40 15,000 Salt Lake City $1.10 $1.35 $1.60 $1.60 $1.70 16,000 Demand 9,000 3,300 12,000 9,500 16,000