Sycamore Plastics (SP) is a manufacturer of polyethylene plastic pellets used as a raw material by manufacturers of plastic goods around the U.S. 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 following table.
Plant Philadelphia Atlanta St. Louis Salt Lake City Maximum Capacity (×100,000 lbs.) 7.59.012.010.3 Prod. Costs (per 1,000lbs.)$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 following table. (Answers in Appendix D)
Transport Costs per 1,000 lbs. From/To Philadelphia Atlanta St. Louis Salt Lake City Total Demand (×1,000 lbs.) NYC $45$55$57$72525 Birmingham $52$42$60$71415 Terre Haute $56$58$50$67925 Dallas $62$59$54$57600 Spokane $78$80$65$52325 San Diego $85$82$70$60400
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?