Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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:

image text in transcribed
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 Current Month vs. Last Month Current Month vs. Last December Weather 2 degrees cooler; +2.0 MCF 6 degrees warmer; -2.5 MCF Number of billing days 7 more days; +0.7 MCF 3 less days; -0.3 MCF Customer-controlled usage +0.5 MCF per billing period -1.9 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.) $ Amount Current Month vs. Last $ Amount Usage Factors Current Month vs. Last Month Change December Change 6 degrees warmer; -2.5 MCF Weather 2 degrees cooler; +2 MCF 3 less days; -0.3 MCF Number of billing days 7 more days; +0.7 MCF Customer-controlled usage +0.5 MCF -1.9 MCF $ 0.00 $ 0.00 Total change

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Advanced Accounting In Canada

Authors: Hilton Murray, Herauf Darrell

9th Edition

1259654699, 978-1259654695

More Books

Students also viewed these Accounting questions

Question

2. The purpose of the acquisition of the information.

Answered: 1 week ago

Question

1. What is the meaning of the information we are collecting?

Answered: 1 week ago