Anderson Watch Company is considering opening four possible distribution centers located in Atlanta, Lexington, Milwaukee, and Salt Lake City with a fixed cost to open of $17,000, $22,000, $35,000, and $25,000, respectively. They currently have ten retail stores located in Seattle, San Francisco, Las Vegas, Tucson, Denver, Dallas, Birmingham, Orlando, Cleveland, and Philadelphia. Lisa, the supply chain VP, wants to minimize the transportation costs of shipping their French down pillows. 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 tables.  What is the minimum cost solution?   What is the minimum cost solution if Lisa wants to use single sourcing?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
icon
Concept explainers
Topic Video
Question

Anderson Watch Company is considering opening four possible distribution centers located in Atlanta, Lexington, Milwaukee, and Salt Lake City with a fixed cost to open of $17,000, $22,000, $35,000, and $25,000, respectively. They currently have ten retail stores located in Seattle, San Francisco, Las Vegas, Tucson, Denver, Dallas, Birmingham, Orlando, Cleveland, and Philadelphia. Lisa, the supply chain VP, wants to minimize the transportation costs of shipping their French down pillows. 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 tables.

 What is the minimum cost solution? 

 What is the minimum cost solution if Lisa wants to use single sourcing?

Shipping
Cost
San
Seattle
Francisco
Las Vegas
Tucson
Denver
Dallas
Atlanta
$2.15
$2.10
$1.75
$1.50
$1.20
$0.80
Lexington
$1.95
$2.00
$1.70
$1.35
$1.10
$1.05
Milwaukee
$1.70
$1.85
$1.50
$1.41
$0.95
$0.95
Salt Lake
City
Demand
$0.60
$0.55
$0.35
$0.60
$0.40
$1.10
8,800
18,000
5,300
3,700
6,500
9,000
Shipping
Cost
Birmingham
Orlando
Cleveland Philadelphia
Supply
Atlanta
$0.35
$0.15
$0.60
$0.50
26,000
Lexington
$0.60
$0.50
$0.25
$0.30
30,000
Milwaukee
$0.70
$0.70
$0.35
$0.40
25,000
Salt Lake
City
$1.35
$1.60
$1.60
$1.70
32,000
Demand
3,300
12,000
9,500
16,000
Transcribed Image Text:Shipping Cost San Seattle Francisco Las Vegas Tucson Denver Dallas Atlanta $2.15 $2.10 $1.75 $1.50 $1.20 $0.80 Lexington $1.95 $2.00 $1.70 $1.35 $1.10 $1.05 Milwaukee $1.70 $1.85 $1.50 $1.41 $0.95 $0.95 Salt Lake City Demand $0.60 $0.55 $0.35 $0.60 $0.40 $1.10 8,800 18,000 5,300 3,700 6,500 9,000 Shipping Cost Birmingham Orlando Cleveland Philadelphia Supply Atlanta $0.35 $0.15 $0.60 $0.50 26,000 Lexington $0.60 $0.50 $0.25 $0.30 30,000 Milwaukee $0.70 $0.70 $0.35 $0.40 25,000 Salt Lake City $1.35 $1.60 $1.60 $1.70 32,000 Demand 3,300 12,000 9,500 16,000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 7 images

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.