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

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 gas public utilities serving Connecticut have reported levels of accuracy from 4 percent to 10 percent 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 also compared 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 13.7 MCF in December and is charged $12.50 per MCF for a total bill that month of $171.25. 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 FactorsCurrent Month vs Last MonthCurrent Month to Last December

Weather3 degrees cooler; +2.5MCF8 degrees warmer; - 3.5MCF
Number of Billing Days5 more days; +.05 MCF1 less day; -0.1 MCF
Customer controlled usage+.9 MCF-          1.8 MCF


Required
1. Determine the amount of difference in the customer’s bill from the prior month and from the current month last year.
2. How does the Dominion Company’s billing system affect environmentalsustainability?

For several years many utilities have been able to use regression analysis to forecast monthly utility usage by resi dential customers using weather forecasts, the number of holidays, the number of days in the month and other factors. For example, the Connecticut Departm ent of Public Utility Control (CDPUC) has determined that regression properly used, can accurately predict natural gas usage. Most gas public utilities serving Connecticut have reported levels of accuracy of from 4% to 10% using regression. One company, Dominion Natural Gas Company of Ohio ses this approach, not to forecast, but to explain to customers why their natural gas bills have gone up or down mpared to the prior month, and also compared to the same month of the prior year. The bill shows total MCF thousand cubic feet of natural gas) used by the custom er for that month and why the total MCF usage has changed, based on three factors: Change in temperature: each degree increase in temperature causes an increase in the number 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 Number of billing days in the period The residual, the change in usage by the custom er that is not attributable to temperature or the number of days in the billing period. o A customer of Dominion has used13.7 MCF in December andis charged S12.50 per MCF for a total bill that month of $171.25. The following data is available to compare the current month's weather and billing period to the prior month and to the same month last year

Step by Step Solution

3.55 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

1 The calculations are as follows The customers current bill was 4875 greater than last months bill ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

249-B-M-L-P (312).xlsx

300 KBs Excel File

Students Have Also Explored These Related Management Leadership Questions!