Help me to solve the problem with solver in ms excel.

Problem#6 Sunco Oil produces oil at two wells. Well 1 can produce as many as 150,000 barrels per day, and well 2 can produce as many as 200,000 barrels per day. It is possible to ship oil directly from the wells to Sunco's customers in Los Angeles and New York. Alternatively, Sunco could transport oil to the ports of Mobile and Galveston and then ship it by tanker to New York or Los Angeles. Los Angeles requires 160,000 barrels per day, and New York requires 140,000 barrels per day. The costs of shipping 1,000 barrels between two points are shown in Table 61. Formulate a transshipment model (and equivalent transportation model) that could be used to minimize the transport costs in meeting the oil demands of Los Angeles and New York. TABLE 61 To ($) From Well 1 Well 2 Mobile Galveston N.Y. L.A. 0 10 0 15 0 13 12 6 0 25 26 16 Well 1 Well 2 Mobile Galveston N.Y. L.A. 28 25 17 6 14 0 16 15 0 15 Note: Dashes indicate shipments that are not allowed