Solver add-in?

[Moxmonkey0]

Hey guys. I have been trying to figure out this issue for some time. Please take a look and post any tips on how to finish this. Thanks!!

Here is the problem: Your company has warehouses in New York, Philadelphia, and Washington DC. They can supply the amount of units listed below of a product. The Demand shows who the supplier cities can sell to and how many units each city is willing to purchase. In the bottom chart is the prices at which each supplier will sell to each city. Of course you want to maximize your sales by selling your items the highest possible to each city without exceeding the demand by each city. Now, how do you set this up in the bottom chart using the Solver add-in? Remember not to exceed the demands and you want to sell as high as possible for each demand.

I hope this makes sense. I know that this problem could be done in your head because the numbers are actually fairly easy but I want the real equations for it. Thanks for any help guys.

Supply
City Units
New York 10000
Philadelphia 15000
Washington DC 25000

Demand
City / Units
Los Angeles 22,000
San Diego 17,000
Phoenix 11,000

Selling Prices
Los Angeles / San Diego / Phoenix
New York $0.10 / $0.18 / $0.14
Philadelphia $0.15 / $0.16 / $0.16
Washington DC $0.18 / $0.13 / $0.19


Purchase
Los Angeles / San Diego / Phoenix
New York 0 / 0 / 0
Philadelphia 0 / 0 / 0
Washington DC 0 / 0 / 0

I have all this in Excel is this would be easier. Check it out here. http://www.geocities.com/moxmonkey0/GroupProject.xls