Please email the excel document to sanzamhlongo482@gmail.com 2. A foundry company has 3 plants that supply light and heavy steel castings to 4 different types of industries in South Africa. The associated supply (in tonnes) from each plant and demand of each industry is given in Table 2 below. The cost (in Rands) of sending a tonne of steel from a plant to the delivery location of each industry depends on the distance the steel castings must travel. Formulate the LP to minimize the cost of meeting each industry's peak steel demand. Solve with the Simplex Method, using Excel Solver. Note: do not do this manually (34) Table 1: Supply and Demand Information From Agriculture Aircrafts Plant 1 128 96 Plant 2 144 192 Plant 3 224 144 Demand 90 40 TO Automobile Mining 160 144 208 112 256 80 60 60 Supply 70 100 80