Reference no: EM131072677
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:
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.
Format of the Report and important notes
1. You at least should have the following details:
a. Assignment Cover Page clearly stating your name and student number
b. A table of contents and executive summary
c. A brief introduction or overview of what the report is about.
d. Body of the report with sections to answer the above questions (ASSIGNMENT REQUIREMENTS 1 TO 2) and with appropriate section headings
e. Conclusion
f. List of references.
2. Diagrams and tables clearly labelled and explained.
3. Ensure all materials are correctly referenced. Plagiarism will be severely penalised.
|
Capital structure shift change the firm cost of equity
: Lauterbach Corporation uses no debt, its beta is 1.0, and its tax rate is 40%. However, the CFO is considering moving to a capital structure with 30% debt and 70% equity. If the risk-free rate is 5.0% and the market risk premium is 6.0%, by how much ..
|
|
Investment portfolio-what is expected return
: Your investment portfolio has 15,000 shares of Fairfax Paint, which has an expected return of 6.88 percent and a price of 7 dollars per share, and 15,000 shares of Litchfield Design, which has a price of 4 dollars per share. If your portfolio has an ..
|
|
Assessing an organization readiness for change
: This questionnaire is designed to help you understand the level of support or opposition to change within an organization. Please respond to each of the following 16 items according to how true it is in terms of an organization with which you are ..
|
|
What was the standard deviation of the stock returns
: A stock had returns of 15 percent, 36 percent, and -15 percent over the past three years. What was the standard deviation of the stock’s returns? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered a..
|
|
Identify the data that incorporated into cgc new system
: HI5019 STRATEGIC INFORMATION SYSTEMS FOR BUSINESS AND ENTERPRISE - 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 need..
|
|
What was the compound annual return over past five years
: Middlefield Motors has never paid any dividends. The firm’s stock was selling for 79.7 dollars per share 5 years ago. Today the stock is priced at 110.15 dollars. What was the compound annual return over the past 5 years? Answer as a rate in decimal ..
|
|
Find the surface area
: Find the surface area that portion of the surface y2 + z2 = a2 that lies inside the surface x2 + y2 = a2
|
|
Rowe program at best buy
: Jennifer Janssen works in the finance department at the headquarters of Best Buy, located in Minneapolis, Minnesota. One of Best Buy's electronics suppliers is furious because he claims he has not been paid. Janssen states: "He told me, 'I'm not g..
|
|
What is the firm required rate of return
: Angler equipment has a beta of 1.2 and an expected dividend growth rate of 6.00% per year. The T-bill rate is 1.00% and the 10 year T-bond rate is 2.13%. The annual return on the stock market during the past 4 years was 12.25%. Investors expect the a..
|