PLS HELP

Problem 14-9 (Algo) Sycamore Plastics (SP) is a manufacturer of polyethylene plastic pellets used as a raw material by manufacturers of plastic goods around the United States. SP currently operates four manufacturing centers in Philadelphia, PA; Atlanta, GA; St. Louis, MO; and Salt Lake City, UT. The plants have different capacities and production costs as indicated in the table below. MAXIMUM CAPACITY (X PRODUCT COST (PER PLANT 100,000 POUNDS) 1,000 POUNDS) Philadelphia 7.5 $337 . 00 Atlanta 9.0 $287 .00 St. Louis 12 . 4 $317 . 00 Salt Lake City 10 .4 $262 .00 SP currently has six contract customers located in New York City; Birmingham, AL; Terre Haute, IN; Dallas, TX; Spokane, WA; and San Diego, CA. Transportation costs between the plants and various customers, as well as contracted demand from each customer, are shown in the table below. TRANSPORT COSTS PER 1, 000 POUNDS FROM/TO NYC BIRMINGHAM TERRE HAUTE DALLAS SPOKANE SAN DIEGO Philadelphia $50 $57 $61 $67 $61 $96 Atlanta 60 47 63 64 63 93 St. Louis 62 65 55 59 48 81 Salt Lake City 77 76 72 62 41 71 Total Demand (x 1,000 pounds) 537 426 937 603 337 412 Create a solver model and find the optimal solution to help SP develop a distribution plan that will minimize costs to supply the customers' demand. Note: Enter your answers in terms of cost per 1,000 lbs and shipment quantities per 1,000 lbs. Round your answers to the nearest whole number. Leave the cells blank, whenever zero (0) is required.A B C D E F G H J K Unit Supply Cost and Demand Supply Combined Costs per 1,000 lbs To NYC Birmingham | Terre Haute Dallas Spokane San Diego Capacity (per 1,000 lbs) Philadelphia $387 $394 $398 $404 $398 $433 750 Atlanta $347 From $334 $350 $351 $350 $380 900 St. Louis $379 $382 $372 $376 $265 $398 1,240 Salt Lake City $339 $338 $334 $324 $303 $333 1,040 Demand 537 426 937 603 337 412 3,930 10 11 Variables: 12 NYC Birmingham | Terre Haute Dallas Spokane San Diego Total Out 13 Philadelphia So SO SO $0 SO 14 Atlanta SO SO SO 15 St. Louis SO $0 SO SO 16 Salt Lake City SO SO $0 17 Demand 18 19 Cost: 20 NYC Birmingham Terre Haute Dallas Spokane San Diego Total 21 Philadelphia SO SO SO $0 SO 22 Atlanta SO SO SO 23 St. Louis SO $0 SO SO 24 Salt Lake City so SO SO 25 Total 26 27 28