I cannot figure out how to set up the problem below,

Question

A major coffee supplier has warehouses in Seattle and San Jose. The coffee supplier receives orders from coffee retailers in Salt Lake City and Reno. The retailer in Salt Lake City needs 400 pounds of​ coffee, and the retailer in Reno needs 200 pounds of coffee. The Seattle warehouse has 550 pounds​ available, and the warehouse in San Jose has 500 pounds available. The cost of shipping from Seattle to Salt Lake City is​ $2.50 per​ pound, from Seattle to Reno $4 per​ pound, from San Jose to Salt Lake City $6 per​ pound, and from San Jose to Reno $3 per pound. Find the number of pounds to be shipped from each warehouse to each retailer to minimize the cost.

Ship ______ pounds of coffee from Seattle to Salt Lake​ City, _________ pounds of coffee from Seattle to​ Reno, ________ pounds of coffee from San Jose to Salt Lake​ City, and __________

pounds of coffee from San Jose to Reno.

Answer 1

I get the following through the EXCEL Solver:

Ship 400 lbs from Seattle to Salt Lake City

Ship 0 lbs from Seattle to Reno

Ship 0 lbs from San Jose to Salt Lake City

Ship 200 lbs from San Jose to Reno

Total Cost = $1,600