Question

In: Operations Management

Sycamore Plastics (SP) is a manufacturer of polyethylene plastic pellets used as a raw material by...

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 table below.

PLANT MAXIMUM CAPACITY
(× 100,000 LBS.)
PROD. COST
(PER 1,000 LBS.)
Philadelphia 7.4 $334.00
Atlanta 9.1 $284.00
St. Louis 12.0 $314.00
Salt Lake City 10.4 $259.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 LBS.
FROM/TO NYC BIRMINGHAM TERRE HAUTE DALLAS SPOKANE SAN DIEGO
Philadelphia $40 $47 $51 $57 $60 $97
Atlanta 50 37 53 54 62 94
St. Louis 52 55 45 49 47 82
Salt Lake City 67 66 62 52 40 72
Total Demand
(× 1,000 lbs.)
538 427 938 602 305 413


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.)

CombinedCosts 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.)
From/To NYC Birmingham Terre Haute Dallas Spokane San Diego
Philadelphia
Atlanta
St. Louis
Salt Lake City
Received
Total Costs
From/To NYC Birmingham Terre Haute Dallas Spokane San Diego
Philadelphia $ $ $ $ $ $
Atlanta
St. Louis
Salt Lake City
Total cost $

Solutions

Expert Solution

Spreadsheet model and solution using Solver is as follows:

Combined cost is sum of transport cost and prod. cost

Formulas:

B15 =SUM(B11:B14)   copy to B15:G15

H11 =SUM(B11:G11)   copy to H11:H14

B19 =B3*B11   copy to B19:G22

G23 =SUM(B19:G22)

Total cost = $ 1,085,651


Related Solutions

Sycamore Plastics (SP) is a manufacturer of polyethylene plastic pellets used as a raw material by...
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 table below. PLANT MAXIMUM CAPACITY (× 100,000 LBS.) PROD. COST (PER 1,000 LBS.) Philadelphia 8.1 $322.00 Atlanta 9.2 $272.00 St. Louis 12.1 $302.00 Salt Lake City...
Sycamore Plastics (SP) is a manufacturer of polyethylene plastic pellets used as a raw material by...
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 table below. PLANT MAXIMUM CAPACITY (× 100,000 LBS.) PROD. COST (PER 1,000 LBS.) Philadelphia 8.0 $321.00 Atlanta 9.2 $271.00 St. Louis 12.1 $301.00 Salt Lake City...
Sycamore Plastics (SP) is a manufacturer of polyethylene plastic pellets used as a raw material by...
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 table below. PLANT MAXIMUM CAPACITY (× 100,000 LBS.) PROD. COST (PER 1,000 LBS.) Philadelphia 7.5 $326.00 Atlanta 9.5 $278.00 St. Louis 12.5 $306.00 Salt Lake City...
63. Ethylene, C2H4, used to make polyethylene plastics, can be made from ethane, C2H6, one of...
63. Ethylene, C2H4, used to make polyethylene plastics, can be made from ethane, C2H6, one of the components of natural gas. The heat of reaction for the decomposition of ethane gas into ethylene gas and hydrogen gas is 136.94 kJ per mole of C2H4 formed, so it is endothermic. The reaction is run at high temperature, in part because at 800-900 °C, the equilibrium constant for the reaction is much higher, indicating that a higher percentage of products forms at...
Berry Plastics is a manufacturer. Berry has inventory consisting of raw materials, work in process and...
Berry Plastics is a manufacturer. Berry has inventory consisting of raw materials, work in process and finished goods totaling $24 million. Is Berry required to report the amounts for each class of inventory or can it just report the total of $24 million? Prepare a memo to me explaining your answer. You must provide Codification references to support your answer or you will receive a You answer should be in the FIRAC format discussed in the video or in class....
Berry Plastics is a manufacturer. Berry has inventory consisting of raw materials, work in process and...
Berry Plastics is a manufacturer. Berry has inventory consisting of raw materials, work in process and finished goods totaling $24 million. Is Berry required to report the amounts for each class of inventory or can it just report the total of $24 million? You must provide Codification references to support your answer! You answer should be in the FIRAC format Facts Issue(s)(typically a question) Review of authoritative literature (ASC) Analysis (link the facts to the authority) Conclude (answer the issue...
Piscataway Plastics Company manufactures a highly specialized plastic that is used extensively in the automobile industry....
Piscataway Plastics Company manufactures a highly specialized plastic that is used extensively in the automobile industry. The following data have been compiled for the month of June. Conversion activity occurs uniformly throughout the production process. Work in process, June 1—40,000 units: Direct material: 100% complete, cost of $ 219,500 Conversion: 40% complete, cost of 61,800 Balance in work in process, June 1 $ 281,300 Units started during June 220,000 Units completed during June and transferred out to finished-goods inventory 190,000...
Piscataway Plastics Company manufactures a highly specialized plastic that is used extensively in the automobile industry....
Piscataway Plastics Company manufactures a highly specialized plastic that is used extensively in the automobile industry. The following data have been compiled for the month of June. Conversion activity occurs uniformly throughout the production process. Work in process, June 1—60,000 units: Direct material: 100% complete, cost of $ 292,500 Conversion: 40% complete, cost of 159,200 Balance in work in process, June 1 $ 451,700 Units started during June 240,000 Units completed during June and transferred out to finished-goods inventory 190,000...
Piscataway Plastics Company manufactures a highly specialized plastic that is used extensively in the automobile industry....
Piscataway Plastics Company manufactures a highly specialized plastic that is used extensively in the automobile industry. The following data have been compiled for the month of June. Conversion activity occurs uniformly throughout the production process. Work in process, June 1—60,000 units: Direct material: 100% complete, cost of $ 292,500 Conversion: 40% complete, cost of 159,200 Balance in work in process, June 1 $ 451,700 Units started during June 240,000 Units completed during June and transferred out to finished-goods inventory 190,000...
Piscataway Plastics Company manufactures a highly specialized plastic that is used extensively in the automobile industry....
Piscataway Plastics Company manufactures a highly specialized plastic that is used extensively in the automobile industry. The following data have been compiled for the month of June. Conversion activity occurs uniformly throughout the production process. Work in process, June 1—40,000 units: Direct material: 100% complete, cost of $ 155,500 Conversion: 40% complete, cost of 25,200 Balance in work in process, June 1 $ 180,700 Units started during June 200,000 Units completed during June and transferred out to finished-goods inventory 190,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT