Pennington Hardwood Lumber Supplier has three lumber mills in San Jose, Dayton, and Boston that manufacture pre-cut

Question:

Pennington Hardwood Lumber Supplier has three lumber mills in San Jose, Dayton, and Boston that manufacture pre-cut hardwood. These pre-cut hardwood are shipped to building warehouses in Cleveland, Orlando, Denver, San Diego, and New York for further distribution. The following table shows the production capacity in tons of pre-cut hardwood at each mill, the number of tons of hardwood required at each of the building warehouse, and the shipping costs (in $ per ton). Solve this transportation problem to minimize total costs using Excel Solver.

To San Diego Mill Capacity (in tons) Orlando Denver From New York Cleveland San Jose $21 $13 $22 45 $15 $10 21 9. 50 11