# Shipping Cost

#### just2cusmile

##### New Member
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
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.

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

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.

### Which adblocker are you using?

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

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