just2cusmile
New Member
- Joined
- Dec 9, 2005
- Messages
- 4
You sell product x in eight separate outlet stores. The stores are located in Atlanta, Baltimore, Boise, Dallas, Denver, Chicago, New York, and San Diego. You have two production facilities located in San Francisco and Los Angeles. Customer demand varies by city. Atlanta demands 720 units. Baltimore demands 1,077 units. Boise demands 369 units. Dallas demands 1,803 units. Denver demands 288 units. Chicago demands 939 units. New York demands 1,440 units. San Diego demands 720 units. When shipping a unit from San Francisco, it costs $21.79 to ship to Atlanta, $23.29 to ship to Baltimore, $4.05 to ship to Boise, $16.80 to ship to Dallas, $10.17 to ship to Denver, $17.33 to ship to Chicago, $24.04 to ship to New York, and $10.62 to shipt to San Diego. When shipping from Los Angeles, it costs $18.00 to ship to Atlanta, $21.90 to ship to Baltimore, $15.63 to ship to Boise, $7.68 to ship to Dallas, $10.00 to ship to Denver, $15.90 to ship to Chicago, $22.00 to ship to New York, and $4.30 to ship to San Diego. What shipping plan should you follow to meet demand at a minimum cost if you have an initial inventory of 3,750 units in San Francisco and 3,750 units in Los Angeles?
How do I begin to do this in excel?
How do I begin to do this in excel?