help please

Problem 14-9 (Algo) 10 2 Sycamore Plastics (SP) is a manufacturer of polyethylene plastic pellets used as a water by manufacturers of plastic soda around the United States SP currently operates four manufactung centers in Philadelphia, PA, GASLU, MOS Lake City, UT The plants have different capacities and production costs as indicated in the table below MAXTHE CANCITY TO I 100.000 1.100 Pindo $320.00 MI 128.00 B. o 12.1 18.1 Salt Lake City 1014 SP current has six contract customers located in New York City limingham, AL Hut, I Do, TX WAS Diego, CA Transportation costs between the plants and anous customers, as well as contracte demand from each shown in the table below TO 353 TERE . 50 51 51 22 at La Total Demand 1.000 The 523 Create a solve model and find the optimal solution to help Path will be customers' demand. (Enter your answers in terms of cost per 1.000 los andes per tots. Round your answers to the nearest whole number. Leave the cells blank, whenever 10 ) Condote NIC Bardham Terre 30 350 55 Help 10 a. Create a solver model and find the optimal solution to help SP develop a distribution plan that wil minimice costs to supy the customers' demand. (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 (O) is required.) 2 points NYC 5 From/to Philadelphia Atlanta St Louis Salt Lake City Combined Costs Per 1.000 Birmingham Terre Haute 3741s 3815 305s 334 321 337 356 360 359 326 325 321 Dallas 390 s 338 33 311 San Diego 12 s 411 354 558 376 3001 300k Print References Solution 1,000 lbs) Birmingham Terre Haute Dallas Spokan San Diego NYC From/To Philadelphia Atlanta St. Louis Salt Lake City Received 0 05 05 05 0 $ $ 0 $ 2 Doints NYC Solution 1.000 lbs) Birmingham Terre Haute Dallas Spokane San Diego From TO Philadelphia Atlanta St. Louis Salt Lake City Received Prim $ D rences $ os OS Ols 05 0 Total Costs Terre Haute NYC Birmingham Spokan San Diego From/To Philadelphia Atlanta St. Louis Salt Lake City Total Costs 0