use Excel : SOLVER

A company has received a contract to supply gravel to three new construction projects located in towns A, B and C. the construction engineers have estimated that the required amounts of gravel which will be needed at those construction projects are Project location Weekly requirement (Truckloads) 72 B 102 41 OUDT The company has three gravel pits located in towns X, Y and Z. the gravel required by the construction projects can be supplied by three pits. The amount of gravel that can be supplied by each pit is as follows Plant Y Z Amount available 76 82 77 (truckloads) The company has computed the delivery cost from each pit to each project site. These costs in Rs) are shown in the following table Pit Project location A B 4 8 8 Y 16 24 16 Z 8 16 24 Schedule the shipment from each pit to each project in such a manner that it minimizes the total transportation cost within the constraints imposed by pit capacities and project requirements. Also find the minimum costs