COSA Results for 2020
June 17, 2019
to: |
Kevin Owens |
from: |
Gail Tabone |
subject: |
COSA Results for 2020 |
Based on your financial forecast for 2020, and all of the other data provided, we have completed our initial COSA and a summary of the results are included in this memo. This reflects several changes resulting from our discussion with the Risk Management Committee. The results are a starting point for rate design, which is not addressed in this memo.
Revenue Requirements
The revenue requirements show the 2020 forecast results and will be the test year for the COSA.
The following are the revenue requirements assumptions:
- Power supply costs are based on the 2019 budget amounts for power purchases and transmission costs as a starting point. The resulting cost per kWh for power supply, and $-kW-month cost for transmission, were then applied to the 2020 forecast loads. The resulting 2020 forecast is higher than what is in your 2020 financial forecast because it is calculated out based on the loads each month rather than based on 2019 numbers plus a % increase. This is important because we want the power costs and revenues to both be based on the detailed load amounts.
- The transmission costs were increased by the 53% proposed by Northwestern. The resulting annual cost for 2020 is projected at $728,241.
- Other costs were based on the 2020 financial forecast, split into the various detailed FERC accounts based on the 2018 actual costs by detailed FERC account.
- The revenue requirement includes depreciation, interest and operating margins as provided in the financial forecast. The margin was adjusted to equal the exact amount collected after the revenues and costs included in the COSA. It is slightly different than what was in the financial forecast.
- The revenue requirement deducts revenue for other sources and therefore only reflects the revenues that need to be collected in retail rates.
The following table provides a summary of the projected revenue requirements. There is no need for a rate increase for 2020. The amounts in the 2020 financial forecast are also shown for comparison purposes. The difference from the financial forecast is that power supply costs are higher by $240,446, partly due to higher transmission charges and partly due to the way the cost was calculated based on loads. The revenues are higher by $300,332 based on the detailed revenue calculations. This results in a margin that is higher by $59,887.
Table 1
2020 Revenue Requirement
FERC Account |
Expenses |
|
COSA |
Financial Forecast |
Power Purchases |
|
|||
XXXX |
Demand Charges (OATT Transmission) |
$728,241 |
|
|
XXXX |
Energy Charges |
$2,687,688 |
|
|
Total Purchased Power |
|
$3,415,929 |
$3,175,483 |
|
Transmission |
|
|||
570.00 |
Maint. of Station Equipment |
$8,942 |
$8,942 |
|
Distribution |
|
|||
580.00 |
Op. Supervision & Engineering |
$135,141 |
|
|
582.00 |
Line and Station Expenses |
$66,863 |
|
|
583.00 |
Overhead Lines |
$247,611 |
|
|
584.00 |
Underground Lines |
$58,705 |
|
|
586.00 |
Meters |
$41,166 |
|
|
587.00 |
Customer Installations |
$3,935 |
|
|
588.00 |
Misc. Distribution |
$479,123 |
|
|
589.00 |
Rents |
$1,669 |
|
|
592.00 |
Maint. of Station Equipment |
$10,552 |
|
|
593.00 |
Maint. of Overhead Lines |
$550,495 |
|
|
594.00 |
Maint. Of Underground Lines |
$70,183 |
|
|
595.00 |
Maint. of Line Transformers |
$25,832 |
|
|
Total Distribution |
|
$1,691,277 |
$1,691,277 |
|
Customer Service, Accounts, & Sales |
|
|||
902.00 |
Meter Reading |
$59,105 |
|
|
903.00 |
Customer Records Collection |
$329,628 |
|
|
908.00 |
Customer Assistance |
$11,016 |
|
|
910.00 |
Misc. Customer Service & Information |
$130,673 |
|
|
912.00 |
Demonstrating & Selling |
$5,242 |
|
|
Total Customer Service, Accounts & Sales |
|
$535,664 |
$535,664 |
Administrative & General |
|
|||
920.00 |
Administrative & General Salaries |
$387,726 |
|
|
921.00 |
Office Supplies |
$52,670 |
|
|
923.00 |
Outside Services |
$128,109 |
|
|
924.00 |
Property Insurance |
$15,154 |
|
|
925.00 |
Injuries and Damages |
$7,155 |
|
|
926.00 |
Employee Pension & Benefits |
$89,415 |
|
|
930.10 |
General Advertising |
$71,282 |
|
|
930.20 |
Misc. General Expense |
$287,182 |
|
|
935.00 |
Maintenance of General Plant |
$136,170 |
|
|
Total Administrative & General |
|
$1,174,864 |
$1,174,864 |
|
Depreciation |
|
|||
403.60 |
Distribution Plant |
$965,456 |
|
|
403.70 |
General Plant |
$67,967 |
|
|
Total Depreciation |
|
$1,033,424 |
$1,033,424 |
|
Taxes |
|
|||
408.00 |
Property Tax |
$2,839 |
$2,839 |
|
Interest and Debt Service Expense |
|
|||
427.00 |
Interest on Long-Term Debt |
$606,746 |
|
|
431.00 |
Other Interest Expense |
$3,000 |
|
|
Total Interest / Debt Service Expense |
|
$609,746 |
$609,746 |
|
Operating Margins |
$513,472 |
$453,585 |
||
Revenue Requirement Before Other Revenues |
|
$8,983,317 |
$8,685,825 |
|
Other Revenues |
|
|||
450.00 |
Forfeited Deposits |
$21,500 |
|
|
451.00 |
Misc. Service Revenues |
$4,400 |
|
|
454.00 |
Rent – Electric Properties |
$12,000 |
|
|
456.00 |
Misc. Revenue (Other) |
$166 |
|
|
419&424 |
Dividends from Affiliates, Interest |
$51,106 |
|
|
415&416 |
Income (Loss) from Equity Investments |
$70,230 |
|
|
Total Other Revenues |
|
$159,402 |
$164,242 |
|
REVENUE REQUIREMENT for COST ALLOCATION |
|
$8,826,754 |
$8,521,582 |
|
|
REVENUES FROM RATES AND OTHER REVENUES |
|
$8,986,156 |
$8,685,824 |
Cost of Service Study
A cost of service analysis (COSA) is concerned with the equitable allocation of the revenue requirement to the various customer classes of service. The following are the assumptions used in the COSA:
- Power supply purchases are allocated on the basis of energy. Wholesale transmission costs are allocated on the sum of the 12 monthly coincident peaks.
- BEC’s internal transmission costs are allocated on the basis of the annual system coincident peak.
- Both the 100% demand and minimum system methods are used for allocating distribution costs, and a non-coincident peak is used for allocation.
- Customer service and accounts costs are allocated on the basis of the number of customers.
- The Southern Exit amortization listed as a separate item under A&G and is classified as customer-related and allocated on the number of customers weighted for the average kWh per customer.
- Most other A&G costs are allocated on the basis of assignments developed by BEC. Based on the total of the various assignments made by BEC, the result is 5% distribution and 95% customer-related. The distribution portion was allocated on the basis of the NCP while the customer portion was allocated on the basis of customers weighted for the average kWh per customer.
- Depreciation and interest payments are assigned on the basis of plant.
- Margin is allocated on the basis of all revenue.
- AMI data for some residential customers during the winter months was used to develop load factors and coincidence factors for the residential class. Hourly data for the Belfry substation was used to help develop load factors and coincidence factors for the irrigation class.
- Revenues were based on specific rate components times the load forecast of customers, demand and energy amounts. It differs from the financial forecast because of the more detailed approach.
2020 COSA results are summarized for the minimum system approach in Table 2 and for the 100 percent demand approach in Table 3.
Table 2 |
|||||
Revenues at Current Rates |
Net Revenue Requirement |
Difference |
Revenue to Cost Ratio |
|
|
Residential |
$7,226,669 |
$7,248,591 |
-$21,922 |
99.7% |
|
Small Commercial |
$805,579 |
$792,708 |
$12,871 |
101.6% |
|
Large Commercial |
$295,956 |
$269,995 |
$25,960 |
109.6% |
|
Industrial |
$145,178 |
$133,544 |
$11,634 |
108.7% |
|
Irrigation |
$353,373 |
$381,916 |
-$28,544 |
92.5% |
|
TOTAL |
$8,826,754 |
$8,826,754 |
$0 |
100% |
|
|
|
|
|
|
|
Table 3 100 Percent Demand Approach |
|||||
Revenues at Current Rates |
Net Revenue Requirement |
Difference |
Revenue to Cost Ratio |
|
|
Residential |
$7,226,669 |
$7,091,616 |
$135,054 |
101.9% |
|
Small Commercial |
$805,579 |
$794,736 |
$10,843 |
101.4% |
|
Large Commercial |
$295,956 |
$309,859 |
-$13,904 |
95.5% |
|
Industrial |
$145,178 |
$159,364 |
-$14,187 |
91.1% |
|
Irrigation |
$353,373 |
$471,179 |
-$117,807 |
75.0% |
|
TOTAL |
$8,826,754 |
$8,826,754 |
$0 |
100% |
|
When looking at the revenue to cost ratios it is important to reflect the uncertainty inherent in any COSA due to methodology approaches and uncertainty in the load data used to allocate costs. For that reason, a range of 90% to 110% is typically used to measure whether customer classes are paying an appropriate share of costs.
Based on the results under the minimum system methodology, all classes are in the 90-110% range and do not need an increase or decrease. In the 100% demand case, all classes except Irrigation are in the 90-110% range.
For the Irrigation class, the COSA shows that they are still underpaying their cost of service in the 100% Demand case but are above 90% in the Minimum System case. This is not an unexpected result due to the nature of the service. On the power supply side, the costs of purchased power do not differ based on season and so there is no benefit to Irrigators related to their summer usage. Power costs may have been more seasonal in the past, but BEC has changed its power supply source and rates are flat across all hours. Because they do not peak at the time of the annual peak for BEC they are not allocated any of the transmission-related costs, however, these costs are small for BEC.
The issue is with the distribution costs. Distribution facilities are designed based on the maximum peak load that the customer might have throughout the year. For this reason, the distribution costs are allocated on the basis of the non-coincident peak. The Irrigators receive a full allocation based on their annual peak loads that occur in the summer months. Unlike other classes, these distribution costs must be spread out over a 4-5 month period rather than the full 12-month period used by other types of customers.
If the Board determines that is appropriate to increase Irrigation rates, it may be difficult to determine who would get a corresponding rate decrease. Under the 100% demand approach, it would go to the residential and small commercial class. Under the minimum system study, it would go to the large commercial and industrial classes. However, given the small amount of revenues associated with the Irrigation class, any offset to the other rates would be small.
Unit Costs
Based on the COSA, Tables 4 and 5 (At the end of the memo) show the unit costs for each customer class. This will be used to assist in developing rate options.
Next Steps
Once we make any adjustments in the revenue requirements and COSA, we can finalize the results and use the per unit costs as an input in the rate design process. Based on the revenue to cost ratios resulting from the COSA, we will need policy direction from the Board as to whether there needs to be an overall rate increase or decrease to any of the classes. Ideally this decision would be made prior to rate design so we know what our revenue targets should be. It might be possible to do rate design first with revenue set to equal current revenues by class, and then have any overall increases or decreases applied after that is done.
Given the discussion among Board members and staff, the rate design step will be much more interactive and take more time than the COSA itself. In that step, we will identify several options for each class and compare them in terms of design, revenue impacts and bill impacts for customers. The per unit costs from the COSA, BEC analysis of costs by category, and rate designs for other utilities will all play a role in rate design. It is likely that there will be several iterations of this process before we reach a final rate design proposal.
Table 4
Beartooth Electric Cooperative – 100% Demand |
||||||||||
SUMMARY OF REVENUE REQUIREMENT UNIT COSTS |
||||||||||
BY CUSTOMER CLASS |
||||||||||
Schedule 2.1 |
||||||||||
Forecast Year: 2020 |
Total |
Residential |
Small Commercial |
Large Commercial |
Industrial |
Irrigation |
||||
Billing Determinants | ||||||||||
Total Demand (kW) |
415,700 |
356,491 |
31,894 |
11,969 |
4,268 |
11,078 |
||||
Total Energy (kWh) |
69,710,381 |
55,587,125 |
7,426,217 |
2,529,981 |
1,608,100 |
2,558,958 |
||||
Average Customers |
6,244 |
5,702 |
463 |
19 |
1 |
59 |
||||
Assigned Cost/Unit Cost |
|
|
|
|
|
|
||||
Power Supply | ||||||||||
Demand (PD) |
$705,083 |
$565,858 |
$57,682 |
$36,434 |
$11,985 |
$33,123 |
||||
$/kW |
$1.59 |
$1.81 |
$3.04 |
$2.81 |
$2.99 |
|||||
Energy (PE) |
$2,603,277 |
$2,078,324 |
$277,656 |
$94,592 |
$57,029 |
$95,676 |
||||
$/kWh |
$0.037 |
$0.037 |
$0.037 |
$0.035 |
$0.037 |
|||||
Transmission | ||||||||||
Demand (TD) |
$11,563 |
$9,915 |
$1,058 |
$509 |
$83 |
|||||
$/kW |
$0.03 |
$0.03 |
$0.04 |
$0.02 |
||||||
Distribution | ||||||||||
Demand (DD) |
$3,631,692 |
$2,854,438 |
$284,482 |
$135,192 |
$64,639 |
$292,941 |
||||
$/kW |
$8.01 |
$8.92 |
$11.30 |
$15.15 |
$26.44 |
|||||
Customer (DC) |
$1,875,139 |
$1,583,082 |
$173,858 |
$43,132 |
$25,629 |
$49,440 |
||||
$/Customer/Month |
$23 |
$31 |
$189 |
$2,136 |
$70 |
|||||
Total |
$8,826,754 |
$7,091,616 |
$794,736 |
$309,859 |
$159,364 |
$471,179 |
||||
Total | ||||||||||
$/kW |
$9.62 |
$10.76 |
$14.38 |
$17.97 |
$29.43 |
|||||
$/kWh |
$0.037 |
$0.037 |
$0.037 |
$0.035 |
$0.037 |
|||||
$/Customer/Month |
|
$23.14 |
$31.32 |
$189.17 |
$2,135.71 |
$69.83 |
||||
Combined Demand/Energy |
$0.0991 |
$0.0836 |
$0.1054 |
$0.0832 |
$0.1648 |
|||||
Table 5
Beartooth Electric Cooperative – Minimum System Analysis |
|||||||||||
SUMMARY OF REVENUE REQUIREMENT UNIT COSTS |
|||||||||||
BY CUSTOMER CLASS |
|||||||||||
Schedule 2.1 |
|||||||||||
Forecast Year: 2020 |
Total |
Residential |
Small Commercial |
Large Commercial |
Industrial |
Irrigation |
|||||
Billing Determinants | |||||||||||
Total Demand (kW) |
415,700 |
356,491 |
31,894 |
11,969 |
4,268 |
11,078 |
|||||
Total Energy (kWh) |
69,710,381 |
55,587,125 |
7,426,217 |
2,529,981 |
1,608,100 |
2,558,958 |
|||||
Average Customers |
6,244 |
5,702 |
463 |
19 |
1 |
59 |
|||||
Assigned Cost/Unit Cost |
|||||||||||
Production | |||||||||||
Demand (PD) |
$705,083 |
$565,858 |
$57,682 |
$36,434 |
$11,985 |
$33,123 |
|||||
$/kW |
$1.59 |
$1.81 |
$3.04 |
$2.81 |
$2.99 |
||||||
Energy (PE) |
$2,603,277 |
$2,078,324 |
$277,656 |
$94,592 |
$57,029 |
$95,676 |
|||||
$/kWh |
$0.037 |
$0.037 |
$0.037 |
$0.035 |
$0.037 |
||||||
Transmission | |||||||||||
Demand (TD) |
$11,563 |
$9,915 |
$1,058 |
$509 |
$83 |
||||||
$/kW |
$0.03 |
$0.03 |
$0.04 |
$0.02 |
|||||||
Distribution | |||||||||||
Demand (DD) |
$2,480,133 |
$1,959,736 |
$197,143 |
$91,824 |
$38,634 |
$192,797 |
|||||
$/kW |
$5.50 |
$6.18 |
$7.67 |
$9.05 |
$17.40 |
||||||
Customer (DC) |
$3,026,698 |
$2,634,759 |
$259,169 |
$46,636 |
$25,813 |
$60,321 |
|||||
$/Customer/Month |
$39 |
$47 |
$205 |
$2,151 |
$85 |
||||||
Total |
$8,826,754 |
$7,248,591 |
$792,708 |
$269,995 |
$133,544 |
$381,916 |
|||||
Total | |||||||||||
$/kW |
$7.11 |
$8.02 |
$10.76 |
$11.88 |
$20.39 |
||||||
$/kWh |
$0.03739 |
$0.037 |
$0.037 |
$0.035 |
$0.037 |
||||||
$/Customer/Month |
|
$38.50 |
$46.69 |
$204.54 |
$2,151.08 |
$85.20 |
|||||
Combined Demand/Energy |
$0.0830 |
$0.0718 |
$0.0883 |
$0.0670 |
$0.1257 |