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?
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,023
Messages
5,834,996
Members
430,331
Latest member
Syed Yasir Hannan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top