Petes Plastics manufactures plastic at plants in Miami St Lo

Pete’s Plastics manufactures plastic at plants in Miami, St. Louis and Cleveland. Pete needs to ship plastic to customers in Pittsburgh, Atlanta and Chicago. He wants to minimize the cost of shipping the plastic from his plants to his customers. Suppose the unit shipping cost is charged by a flat rate. The data for the problem is summarized in the following table:

Distance From Plants to Customers (miles)

Plant

Pittsburgh

Atlanta

Chicago

Supply

Miami

1200

700

1300

30

St. Louis

700

550

300

40

Cleveland

125

675

350

60

Demand

40

60

20

Build spreadsheet model for this problem and solve it by Solver software.

		Distance From Plants to Customers (miles)
	Plant	Pittsburgh	Atlanta	Chicago	Supply
	Miami	1200	700	1300	30
	St. Louis	700	550	300	40
	Cleveland	125	675	350	60
	Demand	40	60	20

Solution

Plant/Miles Pittsburg Atlanta Chicago Supply Remaining Miami 1200 700 1300 30 St. Louis 700 550 300 40 Cleveland 125 675 350 60 needed demand 40 60 20 Plant/Miles Pittsburg Atlanta Chicago Supply Remaining Miami 1200 700 1300 30 St. Louis 700 550 300 40 Cleveland 125 /40 675 350 20 needed demand 0 60 20 Plant/Miles Pittsburg Atlanta Chicago Supply Remaining Miami 1200 700 1300 30 St. Louis 700 550 300/20 20 Cleveland 125 /40 675 350 20 needed demand 0 60 0 Plant/Miles Pittsburg Atlanta Chicago Supply Remaining Miami 1200 700 1300 30 St. Louis 700 550/20 300/20 0 Cleveland 125 /40 675 350 20 needed demand 0 40 0 Plant/Miles Pittsburg Atlanta Chicago Supply Remaining Miami 1200 700 1300 30 St. Louis 700 550/20 300/20 0 Cleveland 125 /40 675/20 350 0 needed demand 0 20 0 Plant/Miles Pittsburg Atlanta Chicago Supply Remaining Miami 1200 700/20 1300 10 St. Louis 700 550/20 300/20 0 Cleveland 125 /40 675/20 350 0 needed demand 0 0 0 Plant/Miles Pittsburg Atlanta Chicago Supply Remaining Miami 1200 700/20 1300 10 St. Louis 700 550/20 300/20 0 Cleveland 125 /40 675/20 350 0 needed demand 0 0 0