Can you please answer the following the questions using EXCEL?

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 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 demand at each destination has to be satisfied by not exceeding the available quantity from any supplier. Answer each question, in the same order, starting on a new page (otherwise you lose 2 points): Q1. [15points] Formulate the above problem as a linear programming (LP) problem and type it, using variables xij(i=1,2,3,4,5;j=1,2,3,4). Solve it using EXCEL or any other LP-solver (Such as MATLAB or GAMS, LINDO, etc.). (a) Print and attach the codes you write in the LP-solver or a screen shot of the solver and (b) Print and attach the output from the solver. Q2. [5 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 any change in the optimum solution? If so what? Q3. [5 points] Assume that the cost of transportation (Refer to Table 1) from Supplier A to Alexandria (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? Q4. [5 points] What difference do you observe in the answers for Q2 and Q3? Why or Why not? Q5. [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-member group) Q6. [15points] Starting with the BFS obtained in Q5, find the optimum solution by the u-v Method (Iterative/multiplier Method). Show all iterative solutions in each table [An MS Word table is provided to guide you]. Write the transportation solution and the total cost of transportation