Reference no: EM131063751
Group Assignment Scenario
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.
Assignment Requirements
1.Discuss the criteria to consider in specifying the structure and features of CGC's new system.
2. 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.
|
Total dollar value of all final goods and services
: The total dollar value of all final goods and services produced within a nation in a particular year + income earned by its citizens (including income of those located abroad) - minus income of non-residents located in that country is generally ca..
|
|
Write a review about article facing the urban frontier
: Write a article review about the article Facing the Urban Frontier: African American History in the Reshaping of the Twentieth Century American West by Quintard Taylor.
|
|
Average beta of the new stocks added to the portfolio
: A mutual fund manager has a $20 million portfolio with a beta of 1.5. The risk-free rate is 3.5%, and the market risk premium is 6.5%. The manager expects to receive an additional $5 million, which she plans to invest in a number of stocks. After inv..
|
|
Major channels of monetary policy transmission
: Discuss three major channels of monetary policy transmission. Explain why transmission could remain incomplete.
|
|
Group assignment scenario
: Citizen's Gas Company (CGC) provides natural gas service to 200,000 customers. The customer base is divided into the following three revenue classes:
|
|
Conduct npv analysis for each of the project alternatives
: Financial Management (FIN5FMA) - Determination of the cost of the various sources of costly (interest-bearing) financing used by the firm and, based on this information, Fortescue Metals Group Limited's overall weighted average cost of capital (WA..
|
|
Calculate the required rate of return
: Calculate the required rate of return for Aggies Enterprises assuming that investors expect a 4.0% rate of inflation in the future. The real risk-free rate is 3.0%, and the market risk premium is 7.0%. Aggie has a beta of 0.75, and its realized rate ..
|
|
What was the companys net income after taxes
: ACME Corporation had revenues of $867,030 in 2014. It also had expenses (excluding depreciation) of $356,240, depreciation of $103,456, and interest expense of $52,423. What was the company's net income after taxes if its average tax rate was 40 perc..
|
|
Discuss how accounting firms should modify
: Evaluate whether legislation and regulatory agency oversight will increase or decrease corporate fraud. Explain your position.
|