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.

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...
icon
Related questions
icon
Concept explainers
Topic Video
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 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
Transcribed Image Text:То From Hamilton Butler Clermont Southern Gas 10 20 15 Northwest Gas 12 15 18
(d) Recent residential and industrial growth in Butler County has the potential for increasing demand by 100 units.
(i) 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
Total Cost
(ii) 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
Northwest-Hamilton
$|
Northwest-Butler
Northwest-Clermont
$|
Total Cost
(iii) Which supplier should Tri-County contract with to supply the additional capacity?
The Tri-County contract should go to the supplier with the ---Select--- v cost, i.e. ---Select---
24
24
Transcribed Image Text:(d) Recent residential and industrial growth in Butler County has the potential for increasing demand by 100 units. (i) 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 Total Cost (ii) 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 Northwest-Hamilton $| Northwest-Butler Northwest-Clermont $| Total Cost (iii) Which supplier should Tri-County contract with to supply the additional capacity? The Tri-County contract should go to the supplier with the ---Select--- v cost, i.e. ---Select--- 24 24
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 6 images

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.