linear progression for this problem in excel

Example from Slides ( Op Research) Transportation Problem Acme Block Company has orders for 80 tons of concrete blocks at three suburban locations as follows: Northwood -- 25 tons, Westwood -- 45 tons, and Eastwood - 10 tons. Acme has two plants, each of which can produce 50 tons per week. Delivery cost per ton from each plant to each suburban location is shown below. How should end of week shipments be made to fill the above orders? Northwood Westwood Eastwood 24 30 40 40 42 hant 1 20