I need help completing this problem in Excel with Step by Step Examples, Showing how and what to add to the formula.

Thank you!

Solve this problem by using the computer. 9. The Shotz Beer Company has breweries in two cities, the breweries can supply the following numbers of barrels of draft beer to the company's distributors each month: Brewery A. Tampa B. St. Louis Total Monthly Supply (bbl) 3.500 5,000 8,500 The distributors, which are spread throughout six states, have the following total monthly demand: PROBLEMS 265 Distributor 1. Tennessee 2. Georgia 3. North Carolina 4. South Carolina 5. Kentucky 6. Virginia Total Monthly Demand (bbl) 1.600 1.800 1.500 950 1.250 1.400 8.500 The company must pay the following shipping costs per barrel: To (cost) From 2 3 4 5 6 A $0.50 0.25 $0.35 0.65 $0.80 B $0.60 0.40 $0.45 0.55 $0.75 0.65 0.20 a. Solve this problem by using the computer b. If the Shotz Beer Company management negotiated a new shipping contract with a trucking firm between its Tampa brewery and its distributor in Kentucky that reduces the shipping cost per barrel from $0.80 per barrel to $0.65 per barrel, how will this cost change affect the optimal solution? Solve this problem by using the computer. 9. The Shotz Beer Company has breweries in two cities, the breweries can supply the following numbers of barrels of draft beer to the company's distributors each month: Brewery A. Tampa B. St. Louis Total Monthly Supply (bbl) 3.500 5,000 8,500 The distributors, which are spread throughout six states, have the following total monthly demand: PROBLEMS 265 Distributor 1. Tennessee 2. Georgia 3. North Carolina 4. South Carolina 5. Kentucky 6. Virginia Total Monthly Demand (bbl) 1.600 1.800 1.500 950 1.250 1.400 8.500 The company must pay the following shipping costs per barrel: To (cost) From 2 3 4 5 6 A $0.50 0.25 $0.35 0.65 $0.80 B $0.60 0.40 $0.45 0.55 $0.75 0.65 0.20 a. Solve this problem by using the computer b. If the Shotz Beer Company management negotiated a new shipping contract with a trucking firm between its Tampa brewery and its distributor in Kentucky that reduces the shipping cost per barrel from $0.80 per barrel to $0.65 per barrel, how will this cost change affect the optimal solution