PLEASE SOLVE USING COMPUTER IN EXCEL & SHOW FORMULAS USED IN STEPS. THANK YOU

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. Monthly Supply (bbl) Brewery 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 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 4 5 2 3 From 1 $0.75 $0.45 0.55 $0.80 020 0.65 $0.60 0.40 $0.35 0.65 50.50 0.25 B 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. Monthly Supply (bbl) Brewery 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 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 4 5 2 3 From 1 $0.75 $0.45 0.55 $0.80 020 0.65 $0.60 0.40 $0.35 0.65 50.50 0.25 B