HI5019 Strategic Information Systems
Assessment Description
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.
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.
Get assignment help from urgenthomework.com
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
- Discuss the criteria to consider in specifying the structure and features of CGC’s new system.
- 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
- You at least should have the following details:
- Assignment Cover Page clearly stating your name and student number
- A table of contents and executive summary
- A brief introduction or overview of what the report is about.
- Body of the report with sections to answer the above questions
(ASSIGNMENT REQUIREMENTS 1 TO 2) and with appropriate section headings - Conclusion
- List of references.
- Diagrams and tables clearly labelled and explained.
- Ensure all materials are correctly referenced. Plagiarism will be severely penalised.
- Submission deadlines are strictly enforced and late submission incurs penalties of 5 (five) % of the assessment value per calendar day.
- All assignments must be submitted electronically using a word processor, uploaded to Blackboard via SafeAssign. You must print and attach the full SafeAssign report with the Holmes Institute Cover Sheet to the printed assignment (hard copy). Note: ONLY one member of the group will submit the assignment to Blackboard via SafeAssign.
Holmes University Assignment
- HA2011 Managerial Accounting
- HA2022 Business Law
- HA2042 Accounting Information Systems T2 2019
- HA3011 Advanced Financial Accounting
- HA3042 Taxation Law
- HC1010 Accounting For Business
- HC1082 Marketing T2 2020
- HI5001 Accounting for Business Decisions
- HI5002 Finance for Business Tutorial Questions 2
- HI5002: Finance for Business
- HI5003 Economics for Business
- HI5004 Marketing Management T1 2020 Individual Report
- HI5004 Marketing Management T1 2020 Group Report
- HI5004 Marketing Management
- HI5014 International Business Across Borders
- HI5015 Legal Aspects of International business
- HI5016 international trade and enterprise
- Hi5017 Managerial Accounting T1 2021
- Hi5017 Activity-based costing
- HI5017 Managerial Accounting
- HI5017 Managerial Accounting T2 2019
- HI5017 Managerial Accounting Trimester 1 2019
- HI5017 Managerial Accounting Trimester 3 2018
- HI5017 Managerial Accounting Trimester 1 2018
- HI5019 Tutorial Questions 2
- HI5019 Tutorial Questions 1
- HI5019 T1 2020
- HI5019 Strategic Information systems for business and enterprise
- HI5019 Strategic Information Systems
- HI5019 T2 2019
- HI5019 T1 2019
- HI5020 Corporate Accounting Tutorial Questions 2
- HI5020 Corporate Accounting
- HI6005 Assignment
- HI6005: Management and Organisations
- HI6005 Research Paper 2
- HI6006 Tutorial questions
- HI6006 Competitive Strategy Individual T1 2020
- HI6006 Competitive Strategy
- HI6006 Assignment 2 Group Report
- HI6007 Final Assignment T2 2021
- HI6007 Assessment 2 T1 2020
- HI6007 group assignment
- HI6007 Statistics for Business Decision Making
- HI6008 Business Research Project T2 2020
- HI6008 business research
- HI6025 Accounting Theory Tutorial Questions 1
- HI6025 Accounting Theory and Current Issues
- HI6026 audit assurance and compliance
- HI6026 audit assurance and compliance Assignment Help
- HI6027 business and corporate law tutorial Assignment T1 2021
- HI6027 Business and Corporate Law T2 2019
- HI6027 Business and Corporate Law T3 2019
- Hi6028 taxation theory, practice and law Final Assessment t1 2021
- HI6028 Taxation Theory, Practice and Law T2 2021
- HI6028 Taxation Theory, Practice and Law T1 2021
- HI6028 Taxation Theory, Practice and Law T2 2020
- HI6028 Taxation Law Theory and Practice
- HI6028 Taxation Theory T1 2019
- HS2021 Database Design