PLEASE ANSWER THIS QUESTION IN EXCEL AND SHOW YOUR WORK PLEASE AND THANK YOU $!$

A company imports goods at two ports: Philadelphia and New Orleans.

Shipments of one product are made to customers in Atlanta, Dallas, 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:

$(1\mathrm{.}1)$ Develop a network representation of the above transportation problem.

$(1\mathrm{.}2)$ Formulate a linear programming model that minimizes the total transportation cost

while meeting the supply demand requirements. Clearly define the decision variables.

$(1\mathrm{.}3)$ Solve the above developed model and obtain an optimal solution.

$(1\mathrm{.}4)$ Assume transportation from New Orleans to Dallas is not possible for some reasons.

Explain the impact of this assumption on your developed LP model.