Identify data that should be incorporated into cgcs system

Assignment Help Case Study
Reference no: EM13836308

Citizen's Gas Company (CGC) provides natural gas service to 200,000 customers. The customer base is divided into the following three revenue classes:

Class

Customers

Sales in Cubic
Feet

Revenues

Residential

160,000

80 billion

$160 million

Commercial

38,000

15 billion

$ 25 million

Industrial

2,000

50 billion

$ 65 million

Totals

 

145 billion

$250 million

Residential customer gas usage is highly correlated with the weather. Commercial customer usage is partially weather dependent. Industrial customer usage is governed almost entirely by business factors.

The company buys natural gas from 10 pipeline companies in the amounts specified in contracts that run for 5 to 15 years. For some contracts, the supply is in equal monthly increments; for other contracts, the supply varies according to the heating season. Supply over the contract amounts is not available, and some contracts contain take-or-pay clauses. That is, the company must pay for the gas volume specified in the contract, regardless of the amount used.

To match customer demand with supply, gas is pumped into a storage field when supply exceeds customer demand. Gas is withdrawn when demand exceeds supply. There are no restrictions on the gas storage field except that the field must be full at the beginning of each gas year (September 1). Consequently, when the contractual supply for the remainder of the gas year is less than that required to satisfy projected demand and fill the storage field, CGC curtails service to industrial customers (except for heating quantities). The curtailments must be carefully controlled to prevent either an oversupply at year-end or a curtailing of commercial or residential customers so the storage field can be filled at year-end.

In recent years, CGC's planning efforts have not been able to control the supply during the gas year or provide the information needed to establish long-term contracts. Customer demand has been projected only as a function of the total number of customers. Commercial and industrial customers' demand for gas has been curtailed. This has resulted in lost sales and caused an excess of supply at the end of the gas year.

To correct the problems, CGC has hired a director of corporate planning. She is presented with a conceptual design for an information system that will help analyze gas supply and demand. The system will provide a monthly gas plan for the next five years, with particular emphasis on the first year. The plan will provide detailed reports that assist in the decision- making process. The system will use actual data during the year to project demand for the year. The president has indicated that she will base her decisions on the effect alternative plans have on operating income.

1. According to the case, Identify the data that should be incorporated into CGC's new system to provide adequate planning capability. Explain why each data item it is important and the level of detail needed for the data to be useful.(800-1000 words)

a. Diagrams and tables clearly labelled and explained

b. List reference

Reference no: EM13836308

Questions Cloud

Describe a change in the price or quantity : Draw a supply/demand graph of the product. It must be created by you, not lifted off of the internet of copied from another student. It's OK to hand draw and send a photo or scan, or draw using a computer program (Myeconlab has one that is easy to..
Write the firms average aggregated cost equation : In this module, it is demonstrated that sometimes extensive diseconomies of scale, say, due to high transportation costs, would require that the firm produce its product in a multiple of plants. The average hauling (freight) cost is $0.8Q; that is AF..
Explain briefly the alternative asset measurement approaches : Describe what you understand by the above statement and explain briefly the alternative asset measurement approaches using examples from your selected annual report.
Federal government calculates the budget on a fiscal year : The federal government calculates the budget on a fiscal year that begins each year on October 1 and ends the following September 30. At the beginning of the 2005 fiscal year, the Congressional Budget Office [CBO] forecast that the federal budget def..
Identify data that should be incorporated into cgcs system : Identify the data that should be incorporated into CGC's new system to provide adequate planning capability and Explain why each data item it is important and the level of detail needed for the data to be useful.
What is the nominal annual interest rate on this loan : A Technology Management graduate student bought a motorcycle for $30,000, paying a down payment of $10,000. The dealership agrees to take the bike back for $8,000 at the end of 4 years. The student’s uncle owns the dealership. If the monthly payment ..
Discuss the trade-offs of this policy : The National Park Service (NPS) grants a single firm the right to sell food and other goods in Yosemite National Park. In return, the NPS receives a fraction of the firm’s profits. Discuss the trade-offs of this policy. (ie. What are the pros and con..
Describe four potential high-rate wpan applications : List and describe four potential high-rate WPAN applications. Explain each field of Wireless Gigabit (WiGig) protocol stack
Monopolistic firms and the trans pacific partnership : What do the monopolistic firms and the Trans Pacific Partnership (tpp) have in common and how the monopolistic firm will be effective. Will the profit increase or decrease.

Reviews

Write a Review

Case Study Questions & Answers

  From the scenario, prioritize the attributes of golds reling

From the scenario, prioritize the attributes of Golds Reling's brand from the brand map presented in the scenario according to the attributes that you believe would be most important to the new tablet's target market. Provide support for your respons..

  Discuss critically infosys current and future strategy

Discuss critically Infosys current and future strategy. What advice would you give Kris Gopalakrishnan and KShop has resulted in information overload among staff. What operational measures would you suggest to overcome such challenges?

  Review tarmac business case for diversity

Review Tarmac's Business Case for Diversity and the Learning Resources. Think about Tarmac's approach to managing diversity and how it relates to organisational behaviour concepts and human resource processes.

  Enron case shared activity

Enron was the first nationwide natural gas pipeline network in the United States. As the company grew, executives shifted the company's primary focus from energy delivery and infrastructure to investing in the stock market.

  Ebay inc internet success or fairy tale

Read the case study "eBay Inc.: Internet Success or Fairy Tale? "and answer the question below,   Use the 2002 financial statement data to replicate the Meyer's report calculations that illustrate the conclusion based on the 2001 data reached in the ..

  Mintendo game girl case study

Which option delivers the maximum profit for the supply chain: Sandra's plan, Bill's plan, or no promotion plan at all? How does the answer change if a discount of $10 must be given to reach the same level of impact that the $5 discount received?

  Splash soft drinks case study

Splash Soft Drinks Inc. (SSD) has recently achieved sales that exceeded its expectations after it introduced a new beverage that was greatly welcomed by their customers. The company is currently considering opening a new plant to which some of the pr..

  Details of the task using tesco plc

Details of the task Using Tesco plc (www.tesco.com) as a case study, prepare a report of no more than 2,500 words that:

  What are the common manifestations of alcoholic cirrhosis

What are the common manifestations of alcoholic cirrhosis? Which of these are secondary to hepatocellular failure? Which are secondary to portal hypertension?

  Judge the extent to which the marketing plan at just us

From the case study, judge the extent to which the marketing plan at Just Us! is outdated. Propose two (2) ways that Just Us! could improve the customer experience and thus sustain future growth.

  Read natasha kingery case and answer the questions

Read the DATA CASE on pages 126-127 about Natasha Kingery who is considering furthering her education and is seeking financial advice. Determine the interest rate she is currently earning on her inheritance by going to Yahoo!

  Identify the relevant facts of the case study

Imagine you are the financial controller of XYZ Ltd a corporation that is a very large donor to HOHO. You have recently become aware that its TV advertising has resulted in the charity violating the 25% expenditure ratio for its charity drive.    Id..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd