TH-County Cities, Inc, supplier natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southom Gas and Northwest Gas. Demand forecasts for the coming winter season are as follows Hamilton County, 400 units, Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southem Gas, 500 units; and Northwest es, 400 units. Distribution costs for the counties vary, depending upon the location of the suppliers. The distribution costs per unit (In thousands of dollars) are as follows. From Hamilton Rutier Clermont 20 15 10 Southern Gas Northwest cas 12 15 18 (a) Develop a network presentation of this problem. (Submit a nle with a maximum size of 1 MB) Choose File No Se chosen b) Develop a linear programming model that can be used to determine the plan that wil minimize total distribution costs. *11 - amount slipped from southern Gas to Hamilton amount shipped from Southern Gas to Butler * - amount shipped from Southern Gas to Clermont 21 - amount shipped from Northwest Gas to Hamilton 2 - amount shipped from Northwest Gas te Butler - amount shipped from Northwest Gas to Clermont Min S.C. 1 5 * . . * 5 . 3 '''*** (c) Describe the distribution plan and show the total distribution cost. Optimal Solution Amount Cost Southern-Hamilton Southern-Butler Southern-Clermont Northwest-Hamilton Northwest-Butler Northwest-Clermont Total Cost $ (d) Recent residential and industrial growth in Butler County has the potential for increasing demand by 100 units. (1) Create an updated distribution plan assuming Southern Gas becomes the preferred supplier. Distribution Plan with Southern Gas Amount Cost Southern-Hamilton $ Southern-Butler Southern-Clermont Northwest-Hamilton Northwest-Butler Northwest-Clermont $ II Total Cost (1) Create an updated distribution plan assuming Northwest Gas becomes the preferred supplier. Distribution Plan with Northwest Gas Amount Cost Southern-Hamilton $ $ Southern-Butler Southern-Clermont I $ Northwest-Hamilton $ Northwest-Butler $ Northwest-Clermont $ Total Cost (ill) Which supplier should Tri-County contract with to supply the additional capacity? The Tri-County contract should ag to the supplier with the Selectv.cast Le Select TH-County Cities, Inc, supplier natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southom Gas and Northwest Gas. Demand forecasts for the coming winter season are as follows Hamilton County, 400 units, Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southem Gas, 500 units; and Northwest es, 400 units. Distribution costs for the counties vary, depending upon the location of the suppliers. The distribution costs per unit (In thousands of dollars) are as follows. From Hamilton Rutier Clermont 20 15 10 Southern Gas Northwest cas 12 15 18 (a) Develop a network presentation of this problem. (Submit a nle with a maximum size of 1 MB) Choose File No Se chosen b) Develop a linear programming model that can be used to determine the plan that wil minimize total distribution costs. *11 - amount slipped from southern Gas to Hamilton amount shipped from Southern Gas to Butler * - amount shipped from Southern Gas to Clermont 21 - amount shipped from Northwest Gas to Hamilton 2 - amount shipped from Northwest Gas te Butler - amount shipped from Northwest Gas to Clermont Min S.C. 1 5 * . . * 5 . 3 '''*** (c) Describe the distribution plan and show the total distribution cost. Optimal Solution Amount Cost Southern-Hamilton Southern-Butler Southern-Clermont Northwest-Hamilton Northwest-Butler Northwest-Clermont Total Cost $ (d) Recent residential and industrial growth in Butler County has the potential for increasing demand by 100 units. (1) Create an updated distribution plan assuming Southern Gas becomes the preferred supplier. Distribution Plan with Southern Gas Amount Cost Southern-Hamilton $ Southern-Butler Southern-Clermont Northwest-Hamilton Northwest-Butler Northwest-Clermont $ II Total Cost (1) Create an updated distribution plan assuming Northwest Gas becomes the preferred supplier. Distribution Plan with Northwest Gas Amount Cost Southern-Hamilton $ $ Southern-Butler Southern-Clermont I $ Northwest-Hamilton $ Northwest-Butler $ Northwest-Clermont $ Total Cost (ill) Which supplier should Tri-County contract with to supply the additional capacity? The Tri-County contract should ag to the supplier with the Selectv.cast Le Select