Quantitative Methods / Research > EXAM > University of the Incarnate WordPMBA 6312. Problem Set 5 2019 v.2. PMBA 6312 Quantitative Methods / (All)

University of the Incarnate WordPMBA 6312. Problem Set 5 2019 v.2. PMBA 6312 Quantitative Methods / Research.

Document Content and Description Below

PMBA 6312. Problem Set 5 Dr. K. Lehenbauer; 2019 CHAPTER 10 Question 3. 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 counties vary, depending upon the location of the suppliers. The distribution costs per unit (in thousands of dollars) are as follows: a. Develop a network representation of this problem. b. Develop a linear programming model that can be used to determine the plan that will minimize total distribution costs. Describe the distribution plan and show the total distribution cost. The total distribution cost is $11,900 (see attached Excel spreadsheet). d. Recent residential and industrial growth in Butler County has the potential for increasing demand by as much as 100 units. Which supplier should Tri-County contract with to supply the additional capacity? They should contact Northwest Gas to supply the additional capacity (see attached Excel spreadsheet). for clients up to a maximum of 160 hours each over the next four weeks. A third consultant, Campbell, has some administrative assignments already planned and is available for clients up to a maximum of 140 hours over the next four weeks. The company has four clients with projects in process. The estimated hourly requirements for each of the clients over the fourweek period are as follows: Hourly rates vary for the consultant–client combination and are based on several factors, including project type and the consultant’s experience. The rates (dollars per hour) for each consultant–client combination are as follows: [Show More]

Last updated: 3 years ago

Preview 1 out of 8 pages

Buy Now

Instant download

We Accept: