please show wor

Instructions: Using the spreadsheet provided (Ch11_S11.1), solve the problem and determine the effect of a reduction in production capacity at the Gary location from 310 tons to 260 tons per week. S11.1. Steel mills in three cities produce the following amounts of steel: These mills supply steel to four cities, where manufacturing plants have the following demand: Shipping costs per ton of steel are as follows: Because of a truckers' strike, shipments are prohibited from Birmingham to Chicago. a) Solve this problem. b) What would be the effect of a reduction in production capacity at the Gary location from 310 tons to 260 tons per week? (a) Instructions: Solve the problem and determine the effect of a reduction in production capacity at the Gary location from 310 tons to 260 tons per week. Cost= (b) Instructions: Determine what the effect would be of a reduction in production capacity at the Gary location from 310 tons to 260 tons per week