Solve using excel$-$ During the war with Iraq in $1991,$ the Terraco Motor Company produced a lightweight, all$-$terrain vehicle code$-$named $"$J$99$ Terra" for the military.

The company is now planning to sell the Terra to the public. It has five plants that manufacture the vehicle and four regional distribution centers.

The company is unsure of public demand for the Terra, so it is considering reducing its fixed operating costs by closing one or more plants, even though it would incur an increase in transportation costs. The relevant costs for the problem are provided in the following table. The transportation costs are per thousand vehicles shipped; for example, the cost of shipping $1,000$ vehicles from plant $1$ to warehouse C is $$32,000.$

Transportation Costs $($$$1,000$s$)$ to

Warehouse