SOLVE IT USING EXCEL DATA SOLVER LINEAR PROGRAMMING AND WRITE DOWN CONSTRAINTS

and if you can upload the excel file it would be good

Problem 5 Sunco Oil produces oil at two wells. Well 1 can produce as many as 127000 barrels per day, and well 2 can produce as many as 160000 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 either to the port of Mobile or Galveston and then ship it by tanker to New York or Los Angeles. Transhipment capacities through Mobile are bounded by 42500 barrels per day; capacities in Galveston are unlimited. Los Angeles requires 85000 barrels per day, and New York requires 132000 barrels per day. The costs of shipping 1000 barrels between two points are shown in the table below. From Well 1 Well 2 Mobile Galveston Mobile 6 31 To Galveston N.Y. 13 37 16 23 12 10 L.A. 37 19 8 14 What is the minimal transportation costs of meeting oil demands in Los Angeles and New York