be very detailed in solution and please put excel forumlas

Q1. [Spoints] Formulate the above problem as a linear programming (LP) problem and type it, asing variables xij(l=1,2,3,4,5;j=1,2,3,4). Q2. [10 points) Solve the problem using EXCEL or any other LP-solver (Such as MATLAB or GAMS, LINDO, cte): (a) Print and attach the INPUT codes you wrote in the L.P-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 valoc, Q3. [5 points] Assume that the cost of transportation (Refer to Table 1) from Supplier A so Shreveport (W) is increased from $50 to $250 per Ton. Now, solve the problem again with any LP-tolver. Do you see any change in the optimum solution? If so what? Q4. [5 points] Assume that the cost of transportation (Refer to Table 1) from Supplier A to Alezandria (X) is increased from $100 to $200 per Ton. Solve the problem again with any LP-solver. Do you see any change in the optimum solution? If so what? Q5. [5 points] What difference do you observe in the answers for Q3 and Q4? Why or Why not? Q6. [ 5 points] Present the original problem (Tables 1,2 and 3) in a transportation table (given at the end of the exercise). Using the tabular values find an initial basic feasible solution (BFS) and the total transportation cost by one of the following method depending on the number of students in your group": (a) Northwest Corner Method (1-member group) (b) Least Cost Method. (2-member group) (c) Vogel Approximation Method ( 3 or mote-member group) Q7. [1 5points] Starting with the BFS obtained in Q6, find the optimum solution by the Iterativeimultipller Method (i.e, uy Method). Show all iterative solutions in each table (cample MS Woed table is provided at the end]. Write the transportation solution and the total cost of transportation. Table 0: BSF Solution 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 Louisiana. 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 suppliers to the same destination varies to some extent due to their own policies 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 (\$/Ton). Table 2 shows the quantity available at these suppliers and Table 3 shows the total demand by the buyers from these suppliers during a year. Table 2: Available quantity (Tons) Table 3: Total dernand 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 demand at each destination has to be satisfied by not excecding the available quantity from any supplier. Answer each question, in the same order, starting on a new page (otherwise you lose -2 points)