PLEASE show all calculations within each cell and step by step to get a thumbs up! Also include the title of each chart such as total costs, solution, and combined costs.

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. PLANT Philadelphia Atlanta St. Louis Salt Lake City MAXIMUM CAPACITY (* 100,000 LB.) 7.5 9.0 12.0 10.3 PROD. COSTS (PER 1,000 LB.) $325.00 $275.00 $305.00 $250.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. FROM/TO Philadelphia Atlanta St. Louis Salt Lake City Total Demand (x 1,000 lb.) NYC $ 45 55 57 72 TRANSPORT COSTS PER 1,000 LB. BIRMINGHAM TERRE HAUTE DALLAS SPOKANE SAN DIEGO $ 52 $ 56 $ 62 78 $ 85 42 58 59 80 82 60 50 54 65 70 71 67 57 52 415 925 600 325 400 523 60 525 600 325 a. 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. (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.) Combined Costs Per 1,000 lbs. From/To NYC Birmingham Terre Haute Dallas Spokane San Diego Philadelphia Atlanta St. Louis Salt Lake City Solution (* 1,000 lbs.) Terre Haute Dallas From/To NYC Birmingham Spokane San Diego Philadelphia Atlanta St. Louis Salt Lake City Received 0 0 0 0 0 0 Total Costs From/To NYC Birmingham Terre Haute Dallas Spokane San Diego Philadelphia Atlanta St. Louis Salt Lake City Total cost $