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. c. Describe the distribution plan and show the total distribution cost.
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. c. Describe the distribution plan and show the total distribution cost.
Practical Management Science
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
I need d)

Transcribed Image Text: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 follow-
ing 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:
То
From
Hamilton
Butler
Clermont
Southern Gas
10
20
15
Northwest Gas
12
15
18
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.
c. Describe the distribution plan and show the total distribution cost.
d. Recent residential and industrial growth in Butler County has the potential for increas-
ing demand by as much as 100 units. Which supplier should Tri-County contract with
to supply the additional capacity?
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps with 3 images

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education


Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning

Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.