Q$2-(2\mathrm{.}5$ marks$)$ a compressor company has plants in three locations: Cleveland, Chicago, and

Boston. During the past week the total production of a special compressor unit out of each plant

has been $35,50,$ and $40$ units respectively. The company wants to ship $45$ units to a distribution

center in Dallas, $20$ to Atlanta, $30$ to San Francisco, and $30$ to Philadelphia. The unit production

and distribution costs from each plant to each distribution center are given in the following table

The question is: How the compressor unit should be shipped to the distribution center in order to

minimize total transportation cost. $($Write the mathematical model, then solve the mathematical

model using Excel$).$ You dont need to draw the network representation and.

Show how the solution will be if the route between Cleveland is blocked.

FROM TO Availability

$($units$)$

Dallas Atlanta San

Francisco

Phila.

Cleveland $8610935$

Chicago $91213750$

Boston $14916540$

Requirements $45203030$