Shipping Cost

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?
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446
Wow, is it SAT prep help day?

Show what you have so far, since this sounds a lot like homework. I have already done enough of that today.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,680
Messages
5,573,624
Members
412,539
Latest member
itchy00
Top