post excel steps

Question 1) Consider the following transportation problem. Factory A, B, and C are the suppliers of a certain product. The products from the three factories must be transported to the three warehouses called 1,2 , and 3 . The last column of the following table shows the number of units of supply available at the three factories. The last row of the table shows the demand at the three warehouses 1,2 , and 3. The table also shows the per unit transportation cost for shipping a unit of product from a factory location to a warehouse. (a) Formulate the problem as a linear programming model where the objective is to minimize the total transportation cost and (b) solve the formulation by using Excel solver. Upload your file to Exam 2 folder