please answer using excel solver & SHOW STEPS

9. 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. SP currently has six contract customers located in New York City; Birmingham, AL; Terre Haute, IN; Dallas, TX; Spokane, WA; and San Dicgo, CA. Transportation costs between the plants and various customers, as well as contracted demand from each customer, are shown in the table below. 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. b. Comment briefly on your solution. Beyond the obvious, does your proposed solution have any other implications for SP