Please read the question carefully and answer them specfically according to the way it needs to be solved.

The teacher is very specific and likes to see alot of work. so please show steps as well using Excel for the 2nd Question

Rice Transportation Problem There are five silos (suppliers) coded as A, B, C, D and E in Louisiana supplying rice regularly to buyers in four major cities of Loulsiana. The related data has been collected from the concerned suppliers for the purpose of a mathematical formulation of the transportation problem. The transportation cost of different supptiers to the same destination varies to some extent due to their own polices and distances. Transportation costs per ton of rice from suppliers to destinations (Shreveport, Alexandria, Lake Charles and Lafayette) are displayed in Table 1. Table 1: Transportation cost (SrTon). Table 2 shows the quantity avallable at these suppliers and Table 3 shows the total demand by the buyers from these suppliers during a year. Table 2: Avallable quantity (Tons) Table 3: Total demand at different destinations The objective of this transportation problem is to find the optimum quantities of rice supply from each supplier to each buyer's destination to minimize the total cost of transportation. The dermand at each question, in the same order, starting on a new page (otherwise you lose -2 points): Q2. [10 points] Solve the problem using EXCEL or any other L.P-solver (Such as MATLAB or GAMS, LINDO, etc.): (a) Print and attach the INPUT codes you wrote in the LP-solver or a screen shot of the solver (b) Print and attach the output from the solver. (c) Write what are your solutions and objective functional value. Q3. I5 points) Assume that the cost of transportation (Refer to Table 1) from Supplier A to Shreveport (W) is increased from $50 to $250 per Ton. Now, solve the problem again with any LP-solver. Do you see ny change in the optimum solution? If so what