Tri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern 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: Southern Gas, 500 units; and Northwest Gas, 400 units. Distribution costs for the countries vary, depending upon the location of the suppliers. The distribution costs per unit (in thousands of dollars) are as follows: FromHamiltonButlerClermontSouthern Gas102015Northwest Gas121518 Develop a network representation of the distribution system.Develop the objective function and the constraints.

Given - Demand Forecast is - Butler = 200 units Hamilton = 400 units Clermont = 300 units

Answered: Tri-County Utilities, Inc., supplies…

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

Related questions

Question

Tri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern 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: Southern Gas, 500 units; and Northwest Gas, 400 units. Distribution costs for the countries vary, depending upon the location of the suppliers. The distribution costs per unit (in thousands of dollars) are as follows: