Use Excel to solve the transportation problem as having a minimum cost as depicted on the next slide and then answer the following. Attach you Excel file with at least the Answer and Sensitivity Reports included. Attached either a PowerPoint or Word file with complete answers is written sentences to the questions below. 1) What amounts are shipped on each route in the optimal solution s1d1 = s1d2= s2d1 = s2d2= ? 2) What is the minimum cost of these shipments? 3) Give an explanation of the range of optimality of variable s2d1. 4) If any variable has a reduced cost identify the variable and explain what the reduced cost means. 5) Give an explanation of the range of feasibility of s2 and what the shadow price there means. 6) Give an explanation of the range of feasibility of d2 and what the shadow price there means. Use Excel to solve the transportation problem as having a minimum cost as depicted on the next slide and then answer the following. Attach you Excel file with at least the Answer and Sensitivity Reports included. Attached either a PowerPoint or Word file with complete answers in written sentences to the questions below. 1) What amounts are shipped on each route in the optimal solution s1d1 = s1d2= s2d1 = s2d2= ? 2) What is the minimum cost of these shipments? 3) Give an explanation of the range of optimality of variable s2d1. 4) If any variable has a reduced cost identify the variable and explain what the reduced cost means. 5) Give an explanation of the range of feasibility of s2 and what the shadow price there means. 6) Give an explanation of the range of feasibility of d2 and what the shadow price there means