to from 1 2 3 4 5 6 A 0.5 0.35 0.6 0.45 0.8 0.75 B 0.25 0.65 0.4 0.55 0.2 0.65 Set up an excel file to complete the transportation problem and have 1 answer report, 1 sensitivity report and 1 limit report included (you can delete the ones that are incorrect, should you have any). You will attach this file upon submitting the assignment. Also answer a) What is the minimum cost of shipping while meeting the characteristics of the problem? b) Indicate the units shipped on each route (including zero shipments). c) What is the range of optimality of the coefficient on the shipping amount from Tampa to Tennessee and what does this range mean? d) What is the range of feasibility for the demand amount in Kentucky and what does the shadow price for Kentucky mean? Exhibit A The Shotz Beer Company has breweries in two cities; the breweries can supply the following num- bers of barrels of draft beer to the company's distributors each month: Brewery Monthly Supply (bbl) A. Tampa B. St. Louis Total 3,500 5,000 8,500 The distributors, which are spread throughout six states, have the following total monthly demand: Distributor Monthly Demand (bbl) 1. Tennessee 2. Georgia 3. North Carolina 4. South Carolina 5. Kentucky 6. Virginia Total 1,600 1,800 1,500 950 1,250 1,400 8,500 to from 1 2 3 4 5 6 A 0.5 0.35 0.6 0.45 0.8 0.75 B 0.25 0.65 0.4 0.55 0.2 0.65 Set up an excel file to complete the transportation problem and have 1 answer report, 1 sensitivity report and 1 limit report included (you can delete the ones that are incorrect, should you have any). You will attach this file upon submitting the assignment. Also answer a) What is the minimum cost of shipping while meeting the characteristics of the problem? b) Indicate the units shipped on each route (including zero shipments). c) What is the range of optimality of the coefficient on the shipping amount from Tampa to Tennessee and what does this range mean? d) What is the range of feasibility for the demand amount in Kentucky and what does the shadow price for Kentucky mean? Exhibit A The Shotz Beer Company has breweries in two cities; the breweries can supply the following num- bers of barrels of draft beer to the company's distributors each month: Brewery Monthly Supply (bbl) A. Tampa B. St. Louis Total 3,500 5,000 8,500 The distributors, which are spread throughout six states, have the following total monthly demand: Distributor Monthly Demand (bbl) 1. Tennessee 2. Georgia 3. North Carolina 4. South Carolina 5. Kentucky 6. Virginia Total 1,600 1,800 1,500 950 1,250 1,400 8,500