1. A company imports goods at two ports: Philadelphia and New Orleans. Shipments of one product are made to customers in Atlanta, Dallas, Columbus, and Boston. For the next planning period, the supplies at each port, customer demands, and shipping costs per case from each port to each customer are as follows:

Customers
Port	Atlanta	Dallas	Columbus	Boston	Port Supply
Philadelphia	2	6	6	2	5000
New Orleans	1	2	5	7	3000
Demand	1400	3200	2000	1400

1. Develop a network representation of the distribution system (transportation problem).
2. Develop a linear programming model for the problem; be sure to define the variables in your model.
3. Solve the linear program to determine the optimal solution.
4. Discuss the distributions from the Port to the customers.

Please help me solve this in excel