We need to ship a single product from two plants to two warehouses, and then from these two warehouses to three customers.

The two plants are $p1$ and $p2$

Plant p$2$ has an annual capacity of $60,000$ units.

The two plants have the same production costs.

The two warehouses are $w1$ and $w2$ with identical warehouse handling costs.

The three customers are $c1,c2$ and $c3$ with demands of $50,000,100,0$c $0$ and $50,000,$ respectively.

Products are shipped from the plants to the warehouses, and from the warehouses to the customers.

Let

$x(p1,w1),x(p1,w2),x(p2,w1)$ and $x(p2,w2)$ be the flows from the plants to the warehouses

$x(w1,c1),x(w1,c2),x(w1,c3)$ be the flows from the warehouse $w1$ to customers $c1,c2$ and $c3$

$x(w2,c1),x(w2,c2),x(w2,c3)$ be the flows from warehouse $w2$ to customers $c1,c2$ and $c3$

Construct the Linear Programming model to minimize the total distribution cost. construct the mathematical model and use excel solver to minimize the total distribution cost.