For several years, many utilities have employed regression analysis to forecast monthly utility usage by residential customers using weather forecasts, the number of holidays, the number of days in the month, and other factors. For example, the Connecticut Department of Public Utility Control (CDPUC) has determined that regression, properly used, can accurately predict natural gas usage. Most public gas utilities serving Connecticut have reported levels of accuracy from 4% to 10% using regression. One company, Dominion Natural Gas Company of Ohio, uses this approach not to forecast, but to explain to customers why their natural gas bills have gone up or down compared to the prior month and to the same month of the prior year. The bill shows total MCF (thousand cubic feet of natural gas) used by the customer for that month and why the total MCF usage has changed, based on three factors: 1. Change in temperature. Each degree increase in temperature causes an increase in the number of MCFs consumed. The relationship between the change in temperature and the usage of MCF is not linear, but the monthly bill shows the average change in temperature for the month and the increase or decrease in MCF related to that change. 2. Number of billing days in the period. 3. The residual-the change in usage by the customer that is not attributable to temperature or the number of days in the billing period. A customer of Dominion has used 14.4 MCF in December and is charged $13.10 per MCF for a total bill that month of $188.64. The following data are available to compare the current month's weather and billing period to the prior month and to the same month last year: Usage Factors Weather Number of billing days Customer-controlled usage Usage Factors Current Month vs. Last Month 2 degrees cooler; +2.0 MCF 7 more days; +0.7 MCF +0.5 MCF per billing period Required: 1. Determine the amount of difference in the customer's bill from the prior month and from the current month last year. (Negative amounts should be indicated with minus sign. Round your answers to 2 decimal places.) Weather Number of billing days Customer-controlled usage Total change Current Month vs. Last December 6 degrees warmer; -2.5 MCF 3 less days; -0.3 MCF -1.9 MCF per billing period Current Month vs. Last Month 2 degrees cooler; +2 MCF 7 more days; +0.7 MCF +0.5 MCF $ Amount Change Current Month vs. Last December 6 degrees warmer; -2.5 MCF 3 less days; -0.3 MCF -1.9 MCF $ Amount Change

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
For several years, many utilities have employed regression analysis to forecast monthly utility usage by residential customers using
weather forecasts, the number of holidays, the number of days in the month, and other factors. For example, the Connecticut
Department of Public Utility Control (CDPUC) has determined that regression, properly used, can accurately predict natural gas usage.
Most public gas utilities serving Connecticut have reported levels of accuracy from 4% to 10% using regression. One company,
Dominion Natural Gas Company of Ohio, uses this approach not to forecast, but to explain to customers why their natural gas bills
have gone up or down compared to the prior month and to the same month of the prior year. The bill shows total MCF (thousand cubic
feet of natural gas) used by the customer for that month and why the total MCF usage has changed, based on three factors:
1. Change in temperature. Each degree increase in temperature causes an increase in the number of MCFs consumed. The
relationship between the change in temperature and the usage of MCF is not linear, but the monthly bill shows the average change
in temperature for the month and the increase or decrease in MCF related to that change.
2. Number of billing days in the period.
3. The residual-the change in usage by the customer that is not attributable to temperature or the number of days in the billing
period.
A customer of Dominion has used 14.4 MCF in December and is charged $13.10 per MCF for a total bill that month of $188.64. The
following data are available to compare the current month's weather and billing period to the prior month and to the same month last
year:
Usage Factors
Weather
Number of billing days
Customer-controlled usage
Usage Factors
Current Month vs. Last Month
2 degrees cooler; +2.0 MCF
7 more days; +0.7 MCF
+0.5 MCF per billing period
Required:
1. Determine the amount of difference in the customer's bill from the prior month and from the current month last year. (Negative
amounts should be indicated with minus sign. Round your answers to 2 decimal places.)
Weather
Number of billing days
Customer-controlled usage
Total change
Current Month vs. Last December
6 degrees warmer; -2.5 MCF
3 less days; -0.3 MCF
-1.9 MCF per billing period
Current Month vs. Last Month
2 degrees cooler; +2 MCF
7 more days; +0.7 MCF
+0.5 MCF
$ Amount
Change
Current Month vs. Last
December
6 degrees warmer; -2.5 MCF
3 less days; -0.3 MCF
-1.9 MCF
$ Amount
Change
Transcribed Image Text:For several years, many utilities have employed regression analysis to forecast monthly utility usage by residential customers using weather forecasts, the number of holidays, the number of days in the month, and other factors. For example, the Connecticut Department of Public Utility Control (CDPUC) has determined that regression, properly used, can accurately predict natural gas usage. Most public gas utilities serving Connecticut have reported levels of accuracy from 4% to 10% using regression. One company, Dominion Natural Gas Company of Ohio, uses this approach not to forecast, but to explain to customers why their natural gas bills have gone up or down compared to the prior month and to the same month of the prior year. The bill shows total MCF (thousand cubic feet of natural gas) used by the customer for that month and why the total MCF usage has changed, based on three factors: 1. Change in temperature. Each degree increase in temperature causes an increase in the number of MCFs consumed. The relationship between the change in temperature and the usage of MCF is not linear, but the monthly bill shows the average change in temperature for the month and the increase or decrease in MCF related to that change. 2. Number of billing days in the period. 3. The residual-the change in usage by the customer that is not attributable to temperature or the number of days in the billing period. A customer of Dominion has used 14.4 MCF in December and is charged $13.10 per MCF for a total bill that month of $188.64. The following data are available to compare the current month's weather and billing period to the prior month and to the same month last year: Usage Factors Weather Number of billing days Customer-controlled usage Usage Factors Current Month vs. Last Month 2 degrees cooler; +2.0 MCF 7 more days; +0.7 MCF +0.5 MCF per billing period Required: 1. Determine the amount of difference in the customer's bill from the prior month and from the current month last year. (Negative amounts should be indicated with minus sign. Round your answers to 2 decimal places.) Weather Number of billing days Customer-controlled usage Total change Current Month vs. Last December 6 degrees warmer; -2.5 MCF 3 less days; -0.3 MCF -1.9 MCF per billing period Current Month vs. Last Month 2 degrees cooler; +2 MCF 7 more days; +0.7 MCF +0.5 MCF $ Amount Change Current Month vs. Last December 6 degrees warmer; -2.5 MCF 3 less days; -0.3 MCF -1.9 MCF $ Amount Change
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Accounting Changes and Error Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education