Glendale City Council
November 28, 2023

OPERATIONS & MAINTENANCE EXPENSE
EWRF - GWP ADM (Elec. Works, Rev Fund)
Salaries & Benefits
Salaries 5820-4505 41100 $ 96,305 LBRxAG 96,305 - - - - - - - 96,305 Overtime 5820-4505 41200 $ - NA - - - - - - - - - Hourly 5820-4505 41300 $ - NA - - - - - - - - - Benefits 5820-4505 Various $ 23,662 LBRxAG 23,662 - - - - - - - 23,662 PERS Retirement 5820-4505 42700 $ 37,970 LBRxAG 37,970 - - - - - - - 37,970 PERS cost sharing 5820-4505 42701 $ (2,848) LBRxAG (2,848) - - - - - - - (2,848) Salaries & Benefits Total $ $155,089 $155,089 $0 $0 $0 $0 $0 $0 $0 $155,089 Maintenance & Operation
Contractual services 5820-4505 43110 $ 45,026 G-Gen 45,026 - - - - - - - 45,026 Advertising 5820-4505 44200 $ - NA - - - - - - - - - Postage 5820-4505 44450 $ 105 G-Gen 105 - - - - - - - 105 Travel 5820-4505 44550 $ 1,788 LBRxAG 1,788 - - - - - - - 1,788 Training 5820-4505 44650 $ 1,788 LBRxAG 1,788 - - - - - - - 1,788 Computer software 5820-4505 44700 $ - NA - - - - - - - - - Regulatory 5820-4505 44760 $ 1,577 G-Gen 1,577 - - - - - - - 1,577 Membership and dues 5820-4505 44800 $ 3,427 LBRxAG 3,427 - - - - - - - 3,427 Periodicals and newspapers 5820-4505 45050 $ - NA - - - - - - - - - Books 5820-4505 45100 $ - NA - - - - - - - - - Furniture and equipment 5820-4505 45150 $ 14,898 LBRxAG 14,898 - - - - - - - 14,898 Computer hardware 5820-4505 45170 $ 74 LBRxAG 74 - - - - - - - 74 Office supplies 5820-4505 45250 $ 2,235 LBRxAG 2,235 - - - - - - - 2,235 General supplies & COVID Supplies 5820-4505 45350 $ 526 G-Gen 526 - - - - - - - 526 Printing and graphics 5820-4505 45450 $ - NA - - - - - - - - - Uncollectible accounts 5820-4505 45680 $ 745 LBRxAG 745 - - - - - - - 745 Business meetings 5820-4505 45681 $ 745 LBRxAG 745 - - - - - - - 745 Miscellaneous 5820-4505 45682 $ 7,464 LBRxAG 7,464 - - - - - - - 7,464 Utilities 5820-4505 46005 $ 8,392 G-Gen 8,392 - - - - - - - 8,392 Cost allocation charge 5820-4505 46007 $ 603,665 G-Gen 603,665 - - - - - - - 603,665 Fleet equipment rental charge 5820-4505 46008 $ 155,517 LBRxAG 155,517 - - - - - - - 155,517 ISD service charge 5820-4505 46009 $ 375,323 G-Gen 375,323 - - - - - - - 375,323 Building maint service charge 5820-4505 46010 $ 192,539 G-Gen 192,539 - - - - - - - 192,539 Liability Insurance 5820-4505 46011 $ 5,156 LBRxAG 5,156 - - - - - - - 5,156 Excess insurance and surety 5820-4505 46012 $ 47,957 G-Gen 47,957 - - - - - - - 47,957 Maintenance & Operation Total $ $1,468,946 $1,468,946 $0 $0 $0 $0 $0 $0 $0 $1,468,946 TOTAL EWRF - GWP ADM $ $1,624,035 $1,624,035 $0 $0 $0 $0 $0 $0 $0 $1,624,035 $
EWRF - GWP ADM -Customer Service
Salaries & Benefits
Salaries 5820-4509 41100 $ 3,003,022 C-Services 3,003,022 - - - - - - - 3,003,022 Overtime 5820-4509 41200 $ 47,611 C-Services 47,611 - - - - - - - 47,611 Hourly wages 5820-4509 41300 $ 75,687 C-Services 75,687 - - - - - - - 75,687 Benefits 5820-4509 Various $ 794,529 C-Services 794,529 - - - - - - - 794,529 PERS Retirement 5820-4509 42700 $ 1,214,817 C-Services 1,214,817 - - - - - - - 1,214,817 PERS cost sharing 5820-4509 42701 $ (91,107) C-Services (91,107) - - - - - - - (91,107) Salaries & Benefits Total $ $5,044,560 $5,044,560 $0 $0 $0 $0 $0 $0 $0 $5,044,560 Maintenance & Operation
Contractual services 5820-4509 43110 $ 1,769,327 C-Services 1,769,327 - - - - - - - 1,769,327 Postage 5820-4509 44450 $ 12,778 C-Services 12,778 - - - - - - - 12,778 Travel 5820-4509 44550 $ 8,254 C-Services 8,254 - - - - - - - 8,254 Training 5820-4509 44650 $ 10,682 C-Services 10,682 - - - - - - - 10,682 Regulatory 5820-4509 44760 $ - NA - - - - - - - - - Membership and dues 5820-4509 44800 $ 586 C-Services 586 - - - - - - - 586 Furniture and equipment 5820-4509 45150 $ 10,116 C-Services 10,116 - - - - - - - 10,116 Computer hardware 5820-4509 45170 $ - NA - - - - - - - - - Office supplies 5820-4509 45250 $ 15,972 C-Services 15,972 - - - - - - - 15,972 Claims 5820-4509 45652 $ - NA - - - - - - - - - Small tools 5820-4509 45300 $ - NA - - - - - - - - - General supplies 5820-4509 45350 $ 2,130 C-Services 2,130 - - - - - - - 2,130 Appendix A
Customer Classification
Test Year
Description Fund-Dept Account Units 2024-2028 Allocator C-Services C-Accounting Other Other Other Other Other Other Total Public benefit programs 5820-4509 45512 $ - NA - - - - - - - - - Uncollectible accounts 5820-4509 45680 $ 2,026,630 C-Services 2,026,630 - - - - - - - 2,026,630 Business meetings 5820-4509 45681 $ 1,065 C-Services 1,065 - - - - - - - 1,065 Miscellaneous 5820-4509 45682 $ 1,597 C-Services 1,597 - - - - - - - 1,597 Cost allocation charge 5820-4509 46007 $ 994,366 C-Services 994,366 - - - - - - - 994,366 Fleet equipment rental charge 5820-4509 46008 $ 37,923 C-Services 37,923 - - - - - - - 37,923 ISD service charge 5820-4509 46009 $ 736,372 C-Services 736,372 - - - - - - - 736,372 Building maint service charge 5820-4509 46010 $ 550,182 C-Services 550,182 - - - - - - - 550,182 Liability Insurance 5820-4509 46011 $ 167,378 C-Services 167,378 - - - - - - - 167,378 Maintenance & Operation Total $ $6,345,356 $6,345,356 $0 $0 $0 $0 $0 $0 $0 $6,345,356 TOTAL EWRF - GWP ADM - Customer Service $ $11,389,916 $11,389,916 $0 $0 $0 $0 $0 $0 $0 $11,389,916 EWRF - GWP ADM - Conserv & Utility Modernization
Salaries & Benefits
Salaries 5820-4520 41100 $ 400,250 C-Services 400,250 - - - - - - - 400,250 Overtime 5820-4520 41200 $ - NA - - - - - - - - - Hourly wages 5820-4520 41300 $ 124,614 C-Services 124,614 - - - - - - - 124,614 Benefits 5820-4520 Various $ 82,206 C-Services 82,206 - - - - - - - 82,206 PERS Retirement 5820-4520 42700 $ 207,871 C-Services 207,871 - - - - - - - 207,871 PERS cost sharing 5820-4520 42701 $ (15,596) C-Services (15,596) - - - - - - - (15,596) Salaries & Benefits Total $ $799,345 $799,345 $0 $0 $0 $0 $0 $0 $0 $799,345 Maintenance & Operation
Contractual services 5820-4520 43110 $ 3,270,256 C-Services 3,270,256 - - - - - - - 3,270,256 Repairs to equipment 5820-4520 44100 $ - NA - - - - - - - - - Advertising 5820-4520 44200 $ 20,976 C-Services 20,976 - - - - - - - 20,976 Postage 5820-4520 44450 $ 79,859 C-Services 79,859 - - - - - - - 79,859 Travel 5820-4520 44550 $ 6,229 C-Services 6,229 - - - - - - - 6,229 Laundry and towel service 5820-4520 44600 $ - NA - - - - - - - - - Training 5820-4520 44650 $ 6,229 C-Services 6,229 - - - - - - - 6,229 Computer software 5820-4520 44700 $ - NA - - - - - - - - - Membership and dues 5820-4520 44800 $ 10,648 C-Services 10,648 - - - - - - - 10,648 Periodicals and newspapers 5820-4520 45050 $ - NA - - - - - - - - - Furniture and equipment 5820-4520 45150 $ 3,727 C-Services 3,727 - - - - - - - 3,727 Computer hardware 5820-4520 45170 $ - NA - - - - - - - - - Office supplies 5820-4520 45250 $ 4,259 C-Services 4,259 - - - - - - - 4,259 General supplies 5820-4520 45350 $ 10,648 C-Services 10,648 - - - - - - - 10,648 Printing and graphics 5820-4520 45450 $ 53,240 C-Services 53,240 - - - - - - - 53,240 Public benefit programs 5820-4520 45512 $ - NA - - - - - - - - - Low carbon fuel std programs 5820-4520 45514 $ 1,929,742 C-Services 1,929,742 - - - - - - - 1,929,742 Business meetings 5820-4520 45681 $ 5,324 C-Services 5,324 - - - - - - - 5,324 Miscellaneous 5820-4520 45682 $ 29,282 C-Services 29,282 - - - - - - - 29,282 Liability Insurance 5820-4520 46011 $ 28,105 C-Services 28,105 - - - - - - - 28,105 Maintenance & Operation Total $ $5,458,524 $5,458,524 $0 $0 $0 $0 $0 $0 $0 $5,458,524 TOTAL EWRF - GWP ADM - Conserv & Utility Modernization $ $6,257,869 $6,257,869 $0 $0 $0 $0 $0 $0 $0 $6,257,869 EWRF - GWP ADM - Bus System Support
Salaries & Benefits
Salaries 5820-4521 41100 $ 28,755 LBRxAG 28,755 - - - - - - - 28,755 Overtime 5820-4521 41200 $ 3,342 LBRxAG 3,342 - - - - - - - 3,342 Hourly wages 5820-4521 41300 $ - NA - - - - - - - - - Benefits 5820-4521 Various $ 6,816 LBRxAG 6,816 - - - - - - - 6,816 PERS retirement 5820-4521 42700 $ 11,374 LBRxAG 11,374 - - - - - - - 11,374 PERS cost sharing 5820-4521 42701 $ (854) LBRxAG (854) - - - - - - - (854) Salaries & Benefits Total $ $49,433 $49,433 $0 $0 $0 $0 $0 $0 $0 $49,433 Maintenance & Operation
Contractual services 5820-4521 43110 $ 280,207 G-Gen 280,207 - - - - - - - 280,207 Repairs to office equipment 5820-4521 44120 $ 1,788 LBRxAG 1,788 - - - - - - - 1,788 Data communication 5820-4521 44250 $ - NA - - - - - - - - - Postage 5820-4521 44450 $ 112 LBRxAG 112 - - - - - - - 112 Travel 5820-4521 44550 $ 2,086 LBRxAG 2,086 - - - - - - - 2,086 Training 5820-4521 44650 $ 2,682 LBRxAG 2,682 - - - - - - - 2,682 Computer software 5820-4521 44700 $ - NA - - - - - - - - - Membership and dues 5820-4521 44800 $ 223 LBRxAG 223 - - - - - - - 223 Appendix A
Customer Classification
Test Year
Description Fund-Dept Account Units 2024-2028 Allocator C-Services C-Accounting Other Other Other Other Other Other Total Furniture and equipment 5820-4521 45150 $ 5,959 LBRxAG 5,959 - - - - - - - 5,959 Computer hardware 5820-4521 45170 $ 4,470 LBRxAG 4,470 - - - - - - - 4,470 Office supplies 5820-4521 45250 $ 447 LBRxAG 447 - - - - - - - 447 General supplies 5820-4521 45350 $ 2,086 LBRxAG 2,086 - - - - - - - 2,086 Business meetings 5820-4521 45681 $ 119 LBRxAG 119 - - - - - - - 119 Miscellaneous 5820-4521 45682 $ 2,235 LBRxAG 2,235 - - - - - - - 2,235 Liability Insurance 5820-4521 46011 $ 1,720 LBRxAG 1,720 - - - - - - - 1,720 Maintenance & Operation Total $ $304,132 $304,132 $0 $0 $0 $0 $0 $0 $0 $304,132 TOTAL EWRF - GWP ADM - Bus System Support $ $353,566 $353,566 $0 $0 $0 $0 $0 $0 $0 $353,566 EWRF - GWP ADM - Utility Finance
Salaries & Benefits
Salaries 5820-4530 41100 $ 62,051 LBRxAG 62,051 - - - - - - - 62,051 Overtime 5820-4530 41200 $ - NA - - - - - - - - - Benefits 5820-4530 Various $ 16,349 LBRxAG 16,349 - - - - - - - 16,349 PERS retirement 5820-4530 42700 $ 24,545 LBRxAG 24,545 - - - - - - - 24,545 PERS cost sharing 5820-4530 42701 $ (1,841) LBRxAG (1,841) - - - - - - - (1,841) Salaries & Benefits Total $ $101,104 $101,104 $0 $0 $0 $0 $0 $0 $0 $101,104 Maintenance & Operation
Contractual services 5820-4530 43110 $ - NA - - - - - - - - - Training 5820-4530 44650 $ - NA - - - - - - - - - Furniture and equipment 5820-4530 45150 $ 149 LBRxAG 149 - - - - - - - 149 General supplies 5820-4530 45350 $ 74 LBRxAG 74 - - - - - - - 74 Liability Insurance 5820-4530 46011 $ 3,323 LBRxAG 3,323 - - - - - - - 3,323 Maintenance & Operation Total $ $3,546 $3,546 $0 $0 $0 $0 $0 $0 $0 $3,546 TOTAL EWRF - GWP ADM - Utility Finance $ $104,650 $104,650 $0 $0 $0 $0 $0 $0 $0 $104,650 EWRF - GWP ADM - Enviro & Safety
Salaries & Benefits
Salaries 5820-4540 41100 $ 1,493 G-Plant 1,493 - - - - - - - 1,493 Overtime 5820-4540 41200 $ - NA - - - - - - - - - Hourly wages 5820-4540 41300 $ - NA - - - - - - - - - Benefits 5820-4540 Various $ 203 G-Plant 203 - - - - - - - 203 PERS Retirement 5820-4540 42700 $ 588 G-Plant 588 - - - - - - - 588 PERS cost sharing 5820-4540 42701 $ (44) G-Plant (44) - - - - - - - (44) Salaries & Benefits Total $ $2,240 $2,240 $0 $0 $0 $0 $0 $0 $0 $2,240 Maintenance & Operation
Contractual services 5820-4540 43110 $ 702 G-Plant 702 - - - - - - - 702 Postage 5820-4540 44450 $ 1 G-Plant 1 - - - - - - - 1 Travel 5820-4540 44550 $ - NA - - - - - - - - - Training 5820-4540 44650 $ 62 G-Plant 62 - - - - - - - 62 Regulatory 5820-4540 44760 $ 130 G-Plant 130 - - - - - - - 130 Membership and dues 5820-4540 44800 $ 8 G-Plant 8 - - - - - - - 8 Office supplies 5820-4540 45250 $ - NA - - - - - - - - - General supplies 5820-4540 45350 $ 52 G-Plant 52 - - - - - - - 52 Business meetings 5820-4540 45681 $ 3 G-Plant 3 - - - - - - - 3 Miscellaneous 5820-4540 45682 $ 182 G-Plant 182 - - - - - - - 182 Liability Insurance 5820-4540 46011 $ 80 G-Plant 80 - - - - - - - 80 Maintenance & Operation Total $ $1,220 $1,220 $0 $0 $0 $0 $0 $0 $0 $1,220 TOTAL EWRF - GWP ADM - Enviro & Safety $ $3,460 $3,460 $0 $0 $0 $0 $0 $0 $0 $3,460 EWRF - GWP ADM - Util Oper Center & Warehouse
Salaries & Benefits
Salaries 5820-4550 41100 $ - NA - - - - - - - - - Overtime 5820-4550 41200 $ - NA - - - - - - - - - Hourly wages 5820-4550 41300 $ - NA - - - - - - - - - Benefits 5820-4550 Various $ - NA - - - - - - - - - PERS retirement 5820-4550 42700 $ - NA - - - - - - - - - PERS cost sharing 5820-4550 42701 $ - NA - - - - - - - - - Salaries & Benefits Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Maintenance & Operation
Repairs buildings and grounds 5820-4550 43050 $ - NA - - - - - - - - - Lease payments 5820-4550 43070 $ - NA - - - - - - - - - Appendix A
Customer Classification
Test Year
Description Fund-Dept Account Units 2024-2028 Allocator C-Services C-Accounting Other Other Other Other Other Other Total Contractual services 5820-4550 43110 $ - NA - - - - - - - - - Postage 5820-4550 44450 $ - NA - - - - - - - - - Laundry and towel service 5820-4550 44600 $ - NA - - - - - - - - - Training 5820-4550 44650 $ - NA - - - - - - - - - Furniture and equipment 5820-4550 45150 $ - NA - - - - - - - - - Office supplies 5820-4550 45250 $ - NA - - - - - - - - - Small tools 5820-4550 45300 $ - NA - - - - - - - - - General supplies 5820-4550 45350 $ - NA - - - - - - - - - Materials overhead 5820-4550 45620 $ - NA - - - - - - - - - Business meetings 5820-4550 45681 $ - NA - - - - - - - - - Miscellaneous 5820-4550 45682 $ - NA - - - - - - - - - Utilities 5820-4550 46005 $ - NA - - - - - - - - - Liability Insurance 5820-4550 46011 $ - NA - - - - - - - - - Maintenance & Operation Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL EWRF - GWP ADM - Util Oper Center & Warehouse $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 EWRF - GWP Yard ADM
Salaries & Benefits
Salaries 5820-4560 41100 $ 13,921 LBRxAG 13,921 - - - - - - - 13,921 Overtime 5820-4560 41200 $ - NA - - - - - - - - - Hourly wages 5820-4560 41300 $ - NA - - - - - - - - - Benefits 5820-4560 Various $ 5,818 LBRxAG 5,818 - - - - - - - 5,818 PERS retirement 5820-4560 42700 $ 5,482 LBRxAG 5,482 - - - - - - - 5,482 PERS cost sharing 5820-4560 42701 $ (411) LBRxAG (411) - - - - - - - (411) Salaries & Benefits Total $ $24,810 $24,810 $0 $0 $0 $0 $0 $0 $0 $24,810 Maintenance & Operation
Furniture and equipment 5820-4560 45150 $ - NA - - - - - - - - - Office supplies 5820-4560 45250 $ 1,788 LBRxAG 1,788 - - - - - - - 1,788 General supplies 5820-4560 45350 $ - NA - - - - - - - - - Printing and graphics 5820-4560 45450 $ - NA - - - - - - - - - Miscellaneous 5820-4560 45682 $ - NA - - - - - - - - - Liability Insurance 5820-4560 46011 $ 745 LBRxAG 745 - - - - - - - 745 Maintenance & Operation Total $ $2,533 $2,533 $0 $0 $0 $0 $0 $0 $0 $2,533 TOTAL EWRF - GWP Yard ADM $ $27,344 $27,344 $0 $0 $0 $0 $0 $0 $0 $27,344 EWRF - GWP Electric - Engineering
Salaries & Benefits
Salaries 5820-4600 41100 $ - NA - - - - - - - - - Overtime 5820-4600 41200 $ - NA - - - - - - - - - Hourly wages 5820-4600 41300 $ - NA - - - - - - - - - Benefits 5820-4600 Various $ - NA - - - - - - - - - PERS Retirement 5820-4600 42700 $ - NA - - - - - - - - - PERS cost sharing 5820-4600 42701 $ - NA - - - - - - - - - Salary charges in (out) 5820-4600 42799 $ - NA - - - - - - - - - Salaries & Benefits Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Maintenance & Operation
Contractual services 5820-4600 43110 $ - NA - - - - - - - - - Data communication 5820-4600 44250 $ - NA - - - - - - - - - Postage 5820-4600 44450 $ - NA - - - - - - - - - Travel 5820-4600 44550 $ - NA - - - - - - - - - Training 5820-4600 44650 $ - NA - - - - - - - - - Computer software 5820-4600 44700 $ - NA - - - - - - - - - Regulatory 5820-4600 44760 $ - NA - - - - - - - - - Membership and dues 5820-4600 44800 $ - NA - - - - - - - - - Books 5820-4600 45100 $ - NA - - - - - - - - - Furniture and equipment 5820-4600 45150 $ - NA - - - - - - - - - Office supplies 5820-4600 45250 $ - NA - - - - - - - - - Small tools 5820-4600 45300 $ - NA - - - - - - - - - General supplies 5820-4600 45350 $ - NA - - - - - - - - - Business meetings 5820-4600 45681 $ - NA - - - - - - - - - Miscellaneous 5820-4600 45682 $ - NA - - - - - - - - - Utilities 5820-4600 46005 $ - NA - - - - - - - - - ISD service charge 5820-4600 46009 $ - NA - - - - - - - - - Appendix A
Customer Classification
Test Year
Description Fund-Dept Account Units 2024-2028 Allocator C-Services C-Accounting Other Other Other Other Other Other Total Liability Insurance 5820-4600 46011 $ - NA - - - - - - - - - Maintenance & Operation Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL EWRF - GWP Electric - Engineering $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 EWRF - GWP Electric - Customer Support
Salaries & Benefits
Salaries 5820-4610 41100 $ 805,089 C-Services 805,089 - - - - - - - 805,089 Overtime 5820-4610 41200 $ - NA - - - - - - - - - Benefits 5820-4610 Various $ 163,726 C-Services 163,726 - - - - - - - 163,726 PERS retirement 5820-4610 42700 $ 317,446 C-Services 317,446 - - - - - - - 317,446 PERS cost sharing 5820-4610 42701 $ (23,811) C-Services (23,811) - - - - - - - (23,811) Salary charges in (out) 5820-4610 42799 $ (109,368) C-Services (109,368) - - - - - - - (109,368) Salaries & Benefits Total $ $1,153,082 $1,153,082 $0 $0 $0 $0 $0 $0 $0 $1,153,082 Maintenance & Operation
Training 5820-4610 44650 $ - NA - - - - - - - - - General supplies 5820-4610 45350 $ - NA - - - - - - - - - Liability Insurance 5820-4610 46011 $ 43,113 C-Services 43,113 - - - - - - - 43,113 Maintenance & Operation Total $ $43,113 $43,113 $0 $0 $0 $0 $0 $0 $0 $43,113 TOTAL EWRF - GWP Electric - Customer Support $ $1,196,195 $1,196,195 $0 $0 $0 $0 $0 $0 $0 $1,196,195 EWRF - GWP Electric - Street Lighting
Salaries & Benefits
Salaries 5820-4620 41100 $ - NA - - - - - - - - - Overtime 5820-4620 41200 $ - NA - - - - - - - - - Benefits 5820-4620 Various $ - NA - - - - - - - - - PERS Retirement 5820-4620 42700 $ - NA - - - - - - - - - PERS cost sharing 5820-4620 42701 $ - NA - - - - - - - - - Salary charges in (out) 5820-4620 42799 $ - NA - - - - - - - - - Salaries & Benefits Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Maintenance & Operation
Repairs buildings and grounds 5820-4620 43050 $ - NA - - - - - - - - - Contractual services 5820-4620 43110 $ - NA - - - - - - - - - Repairs to equipment 5820-4620 44100 $ - NA - - - - - - - - - Small tools 5820-4620 45300 $ - NA - - - - - - - - - General supplies 5820-4620 45350 $ - NA - - - - - - - - - Business meetings 5820-4620 45681 $ - NA - - - - - - - - - Utilities 5820-4620 46005 $ - NA - - - - - - - - - Liability Insurance 5820-4620 46011 $ - NA - - - - - - - - - Maintenance & Operation Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL EWRF - GWP Electric - Street Lighting $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 EWRF - GWP Electric - Howard Substation
Salaries & Benefits
Salaries 5820-4630 41100 $ - NA - - - - - - - - - Overtime 5820-4630 41200 $ - NA - - - - - - - - - Benefits 5820-4630 Various $ - NA - - - - - - - - - PERS Retirement 5820-4630 42700 $ - NA - - - - - - - - - PERS cost sharing 5820-4630 42701 $ - NA - - - - - - - - - Salaries & Benefits Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Maintenance & Operation
Telephone 5820-4630 44300 $ - NA - - - - - - - - - Travel 5820-4630 44550 $ - NA - - - - - - - - - Training 5820-4630 44650 $ - NA - - - - - - - - - Furniture and equipment 5820-4630 45150 $ - NA - - - - - - - - - Computer hardware 5820-4630 45170 $ - NA - - - - - - - - - Office supplies 5820-4630 45250 $ - NA - - - - - - - - - General supplies 5820-4630 45350 $ - NA - - - - - - - - - Business meetings 5820-4630 45681 $ - NA - - - - - - - - - Utilities 5820-4630 46005 $ - NA - - - - - - - - - Liability Insurance 5820-4630 46011 $ - NA - - - - - - - - - Maintenance & Operation Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL EWRF - GWP Electric - Howard Substation $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Appendix A
Customer Classification
Test Year
Description Fund-Dept Account Units 2024-2028 Allocator C-Services C-Accounting Other Other Other Other Other Other Total EWRF - GWP Electric - Meter & Test Shop
Salaries & Benefits
Salaries 5820-4640 41100 $ - NA - - - - - - - - - Overtime 5820-4640 41200 $ - NA - - - - - - - - - Hourly wages 5820-4640 41300 $ - NA - - - - - - - - - Benefits 5820-4640 Various $ - NA - - - - - - - - - PERS Retirement 5820-4640 42700 $ - NA - - - - - - - - - PERS cost sharing 5820-4640 42701 $ - NA - - - - - - - - - Salary charges in (out) 5820-4640 42799 $ - NA - - - - - - - - - Salaries & Benefits Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Maintenance & Operation
Contractual services 5820-4640 43110 $ - NA - - - - - - - - - Repairs to equipment 5820-4640 44100 $ - NA - - - - - - - - - Repairs to office equipment 5820-4640 44120 $ - NA - - - - - - - - - Postage 5820-4640 44450 $ - NA - - - - - - - - - Travel 5820-4640 44550 $ - NA - - - - - - - - - Training 5820-4640 44650 $ - NA - - - - - - - - - Small tools 5820-4640 45300 $ - NA - - - - - - - - - General supplies 5820-4640 45350 $ - NA - - - - - - - - - Liability Insurance 5820-4640 46011 $ - NA - - - - - - - - - Maintenance & Operation Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL EWRF - GWP Electric - Meter & Test Shop $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 EWRF - GWP Electric - Station Maintenance
Salaries & Benefits
Salaries 5820-4650 41100 $ - NA - - - - - - - - - Overtime 5820-4650 41200 $ - NA - - - - - - - - - Benefits 5820-4650 Various $ - NA - - - - - - - - - PERS Retirement 5820-4650 42700 $ - NA - - - - - - - - - PERS cost sharing 5820-4650 42701 $ - NA - - - - - - - - - Salary charges in (out) 5820-4650 42799 $ - NA - - - - - - - - - Salaries & Benefits Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Maintenance & Operation
Repairs buildings and grounds 5820-4650 43050 $ - NA - - - - - - - - - Contractual services 5820-4650 43110 $ - NA - - - - - - - - - Repairs to equipment 5820-4650 44100 $ - NA - - - - - - - - - Postage 5820-4650 44450 $ - NA - - - - - - - - - Travel 5820-4650 44550 $ - NA - - - - - - - - - Laundry and towel service 5820-4650 44600 $ - NA - - - - - - - - - Training 5820-4650 44650 $ - NA - - - - - - - - - Computer software 5820-4650 44700 $ - NA - - - - - - - - - Regulatory 5820-4650 44760 $ - NA - - - - - - - - - Books 5820-4650 45100 $ - NA - - - - - - - - - Office supplies 5820-4650 45250 $ - NA - - - - - - - - - Small tools 5820-4650 45300 $ - NA - - - - - - - - - General supplies 5820-4650 45350 $ - NA - - - - - - - - - Business meetings 5820-4650 45681 $ - NA - - - - - - - - - Liability Insurance 5820-4650 46011 $ - NA - - - - - - - - - Maintenance & Operation Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL EWRF - GWP Electric - Station Maintenance $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 EWRF - GWP Electric - OH & UG
Salaries & Benefits
Salaries 5820-4660 41100 $ - NA - - - - - - - - - Overtime 5820-4660 41200 $ - NA - - - - - - - - - Hourly wages 5820-4660 41300 $ - NA - - - - - - - - - Benefits 5820-4660 Various $ - NA - - - - - - - - - PERS retirement 5820-4660 42700 $ - NA - - - - - - - - - PERS cost sharing 5820-4660 42701 $ - NA - - - - - - - - - Salary charges in (out) 5820-4660 42799 $ - NA - - - - - - - - - Salaries & Benefits Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Maintenance & Operation
Repairs buildings and grounds 5820-4660 43050 $ - NA - - - - - - - - - Appendix A
Customer Classification
Test Year
Description Fund-Dept Account Units 2024-2028 Allocator C-Services C-Accounting Other Other Other Other Other Other Total Contractual services 5820-4660 43110 $ - NA - - - - - - - - - Construction services 5820-4660 43111 $ - NA - - - - - - - - - Repairs to equipment 5820-4660 44100 $ - NA - - - - - - - - - Repairs to office equipment 5820-4660 44120 $ - NA - - - - - - - - - Postage 5820-4660 44450 $ - NA - - - - - - - - - Travel 5820-4660 44550 $ - NA - - - - - - - - - Laundry and towel service 5820-4660 44600 $ - NA - - - - - - - - - Training 5820-4660 44650 $ - NA - - - - - - - - - Regulatory 5820-4660 44760 $ - NA - - - - - - - - - Membership and dues 5820-4660 44800 $ - NA - - - - - - - - - Books 5820-4660 45100 $ - NA - - - - - - - - - Furniture and equipment 5820-4660 45150 $ - NA - - - - - - - - - Office supplies 5820-4660 45250 $ - NA - - - - - - - - - Small tools 5820-4660 45300 $ - NA - - - - - - - - - General supplies 5820-4660 45350 $ - NA - - - - - - - - - Printing and graphics 5820-4660 45450 $ - NA - - - - - - - - - Business meetings 5820-4660 45681 $ - NA - - - - - - - - - Miscellaneous 5820-4660 45682 $ - NA - - - - - - - - - ISD service charge 5820-4660 46009 $ - NA - - - - - - - - - Liability Insurance 5820-4660 46011 $ - NA - - - - - - - - - Maintenance & Operation Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL EWRF - GWP Electric - OH & UG $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 EWRF - GWP Electric - Substructure
Salaries & Benefits
Salaries 5820-4670 41100 $ - NA - - - - - - - - - Overtime 5820-4670 41200 $ - NA - - - - - - - - - Benefits 5820-4670 Various $ - NA - - - - - - - - - PERS retirement 5820-4670 42700 $ - NA - - - - - - - - - PERS cost sharing 5820-4670 42701 $ - NA - - - - - - - - - Salary charges in (out) 5820-4670 42799 $ - NA - - - - - - - - - Salaries & Benefits Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Maintenance & Operation
Contractual services 5820-4670 43110 $ - NA - - - - - - - - - Construction services 5820-4670 43111 $ - NA - - - - - - - - - Repairs to equipment 5820-4670 44100 $ - NA - - - - - - - - - Training 5820-4670 44650 $ - NA - - - - - - - - - Small tools 5820-4670 45300 $ - NA - - - - - - - - - General supplies 5820-4670 45350 $ - NA - - - - - - - - - Liability Insurance 5820-4670 46011 $ - NA - - - - - - - - - Maintenance & Operation Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL EWRF - GWP Electric - Substructure $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 EWRF - GWP Electric - Power Management
Salaries & Benefits
Salaries 5820-4680 41100 $ - NA - - - - - - - - - Overtime 5820-4680 41200 $ - NA - - - - - - - - - Hourly wages 5820-4680 41300 $ - NA - - - - - - - - - Benefits 5820-4680 Various $ - NA - - - - - - - - - PERS retirement 5820-4680 42700 $ - NA - - - - - - - - - PERS cost sharing 5820-4680 42701 $ - NA - - - - - - - - - Salaries & Benefits Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Maintenance & Operation
Contractual services 5820-4680 43110 $ - NA - - - - - - - - - Postage 5820-4680 44450 $ - NA - - - - - - - - - Travel 5820-4680 44550 $ - NA - - - - - - - - - Training 5820-4680 44650 $ - NA - - - - - - - - - Computer software 5820-4680 44700 $ - NA - - - - - - - - - Regulatory 5820-4680 44760 $ - NA - - - - - - - - - RAC variance 5820-4680 44761 $ - NA - - - - - - - - - Membership and dues 5820-4680 44800 $ - NA - - - - - - - - - Periodicals and newspapers 5820-4680 45050 $ - NA - - - - - - - - - Office supplies 5820-4680 45250 $ - NA - - - - - - - - - Appendix A
Customer Classification
Test Year
Description Fund-Dept Account Units 2024-2028 Allocator C-Services C-Accounting Other Other Other Other Other Other Total Furniture and equipment 5820-4680 45150 $ - NA - - - - - - - - - Fuel natural gas 5820-4680 45502 $ - NA - - - - - - - - - Carbon allowances 5820-4680 45506 $ - NA - - - - - - - - - Renewable energy credits 5820-4680 45507 $ - NA - - - - - - - - - ECAC variance 5820-4680 45509 $ - NA - - - - - - - - - Purchased power 5820-4680 45510 $ - NA - - - - - - - - - Hedging costs 5820-4680 45511 $ - NA - - - - - - - - - Business meetings 5820-4680 45681 $ - NA - - - - - - - - - Miscellaneous 5820-4680 45682 $ - NA - - - - - - - - - Gas depletion 5820-4680 46001 $ - NA - - - - - - - - - Utilities 5820-4680 46005 $ - NA - - - - - - - - - General supplies 5820-4680 45350 $ - NA - - - - - - - - - Liability Insurance 5820-4680 46011 $ - NA - - - - - - - - - Maintenance & Operation Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL EWRF - GWP Electric - Power Management $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 EWRF - GWP Electric - Power Plant (Grayson, Wartsila ICE, Tesla Battery) Salaries & Benefits
Salaries 5820-4690 41100 $ - NA - - - - - - - - - Overtime 5820-4690 41200 $ - NA - - - - - - - - - Hourly wages 5820-4690 41300 $ - NA - - - - - - - - - Benefits 5820-4690 Various $ - NA - - - - - - - - - PERS retirement 5820-4690 42700 $ - NA - - - - - - - - - PERS cost sharing 5820-4690 42701 $ - NA - - - - - - - - - Salaries & Benefits Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Maintenance & Operation
Repairs buildings and grounds 5820-4690 43050 $ - NA - - - - - - - - - Lease payments 5820-4690 43070 $ - NA - - - - - - - - - Contractual services 5820-4690 43110 $ - NA - - - - - - - - - Repairs to equipment 5820-4690 44100 $ - NA - - - - - - - - - Postage 5820-4690 44450 $ - NA - - - - - - - - - Travel 5820-4690 44550 $ - NA - - - - - - - - - Laundry and towel service 5820-4690 44600 $ - NA - - - - - - - - - Training 5820-4690 44650 $ - NA - - - - - - - - - Computer software 5820-4690 44700 $ - NA - - - - - - - - - Regulatory 5820-4690 44760 $ - NA - - - - - - - - - Office supplies 5820-4690 45250 $ - NA - - - - - - - - - Small tools 5820-4690 45300 $ - NA - - - - - - - - - General supplies 5820-4690 45350 $ - NA - - - - - - - - - Business meetings 5820-4690 45681 $ - NA - - - - - - - - - Miscellaneous 5820-4690 45682 $ - NA - - - - - - - - - Utilities 5820-4690 46005 $ - NA - - - - - - - - - Liability Insurance 5820-4690 46011 $ - NA - - - - - - - - - Maintenance & Operation Total $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL EWRF - GWP Electric - Power Plant $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL OPERATIONS & MAINTENANCE EXPENSE $ $20,957,035 $20,957,035 $0 $0 $0 $0 $0 $0 $0 $20,957,035 Fuel, Purchased Power, Wheeling $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total O&M less Fuel, PP, Wheeling $ $20,957,035 $20,957,035 $0 $0 $0 $0 $0 $0 $0 $20,957,035 Transfers to the General Fund
TOTAL Transfers to the General Fund $ $1,439,911 RRxTransfer $1,439,911 $0 $0 $0 $0 $0 $0 $0 $1,439,911 Capital Paid from Cash / Earnings
Capital from Cash $ 157 Cash CIP 157 - - - - - - - 157 Total Capital from Cash $ $157 $157 $0 $0 $0 $0 $0 $0 $0 $157 Debt Service
Existing Debt Service
2013 $ - NA - - - - - - - - - 2013 Refunding $ 7,284 N-Plant 7,284 - - - - - - - 7,284 Appendix A
Customer Classification
Test Year
Description Fund-Dept Account Units 2024-2028 Allocator C-Services C-Accounting Other Other Other Other Other Other Total 2016 Refunding $ 8,638 N-Plant 8,638 - - - - - - - 8,638 Total Existing Debt Service $ $15,922 $15,922 $0 $0 $0 $0 $0 $0 $0 $15,922 Proposed Debt Service
Grayson Grayson $166 mil debt in 2024, 2025 & 2026 $ - NA - - - - - - - - - Total New Debt Service $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
TOTAL Debt Service $ $15,922 $15,922 $0 $0 $0 $0 $0 $0 $0 $15,922 Miscellaneous Expenses (Revenues)
Open $ - NA - - - - - - - - - Interest Income $ (230,906) RRxFPPW (230,906) - - - - - - - (230,906) Sale of Property $ - NA - - - - - - - - - Capital Contributions $ - NA - - - - - - - - - Miscellaneous Revenues $ (2,178,217) RRxFPPW (2,178,217) - - - - - - - (2,178,217) Sales to Other utilities $ - NA - - - - - - - - - TOTAL Miscellaneous Expenses (Revenues) $ ($2,409,123) ($2,409,123) $0 $0 $0 $0 $0 $0 $0 ($2,409,123) Contribution to Reserves
Change in Reserves $ 374,501 RR 374,501 - - - - - - - 374,501 Change in Reserves $ - NA - - - - - - - - - TOTAL Change in Reserves $ $374,501 $374,501 $0 $0 $0 $0 $0 $0 $0 $374,501 Revenue Requirement Summary
O&M $ 20,957,035 20,957,035 - - - - - - - 20,957,035 Capital from Cash $ 157 157 - - - - - - - 157 Debt Service $ 15,922 15,922 - - - - - - - 15,922 Transfers to the General Fund $ 1,439,911 1,439,911 - - - - - - - 1,439,911 Miscellaneous Expenses (Revenues) $ (2,409,123) (2,409,123) - - - - - - - (2,409,123) Contribution to Reserves $ 374,501 374,501 - - - - - - - 374,501 Total Revenue Requirement $ $20,378,404 $20,378,404 $0 $0 $0 $0 $0 $0 $0 $20,378,404 -
Total Revenues under Current Rates $
Over (Under) Collection Percentage %
Plant in Service
Gross Plant in Service (Does not include SCPPA Natural Gas Reserve Pinedale Project) Production
Steam Production
Land & Land Rights 310 $ - NA - - - - - - - - - Structures and Improvements 311 $ - NA - - - - - - - - - Boiler Plant Equipment 312 $ - NA - - - - - - - - - Turbogenerator Units 314 $ - NA - - - - - - - - - Engines for Biogas at Scholl Canyon Biogas at Scholl Canyon$ - NA - - - - - - - - - Engines Unit 10-13 at Grayson $ - NA - - - - - - - - - Accessory Electric Equip. 315 $ - NA - - - - - - - - - Misc. Power Plant Equip. 316 $ - NA - - - - - - - - - Total steam production $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Combustion turbine & other production
Structures and Improvements 341 $ - NA - - - - - - - - - Fuel Holder, Producer & Acc 342 $ - NA - - - - - - - - - Prime Movers 343 $ - NA - - - - - - - - - Generators 344 $ - NA - - - - - - - - - Accessory Plant Equipment 345 $ - NA - - - - - - - - - Misc. Power Plant Equipment 346 $ - NA - - - - - - - - - Total combustion turbine & other production $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total production $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Transmission
Tesla Battery Storage $ - NA - - - - - - - - - Land and Land Rights 350 $ - NA - - - - - - - - - Energy Storage 351 $ - NA - - - - - - - - - Structures and Improvements 352 $ - NA - - - - - - - - - Appendix A
Customer Classification
Test Year
Description Fund-Dept Account Units 2024-2028 Allocator C-Services C-Accounting Other Other Other Other Other Other Total Station Equipment 353 $ - NA - - - - - - - - - Towers and Fixtures 354 $ - NA - - - - - - - - - O.H. Conductors & Devices 356 $ - NA - - - - - - - - - Underground Conduit 357 $ - NA - - - - - - - - - Underground Conductors 358 $ - NA - - - - - - - - - Total transmission $ - - - - - - - - - - Distribution $
Land and Land Rights 360 $ - NA - - - - - - - - - Structures and Improvements 361 $ - NA - - - - - - - - - Station Equipment 362 $ - NA - - - - - - - - - Poles, Towers & Fixtures 364 $ - NA - - - - - - - - - O.H. Conductors & Devices 365 $ - NA - - - - - - - - - Underground Conduits 366 $ - NA - - - - - - - - - U.G. Conductors & Devices 367 $ - NA - - - - - - - - - Line Transformers 368 $ - NA - - - - - - - - - Services 369 $ - NA - - - - - - - - - Meters 370 $ - NA - - - - - - - - - Street Lights 373 $ - NA - - - - - - - - - Total distribution $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal before general $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 General
Land and Land Rights 389 $ 212,739 LBR 212,739 - - - - - - - 212,739 Structures and Improvements 390 $ 3,855,206 LBR 3,855,206 - - - - - - - 3,855,206 Office Furniture & Equip. 391 $ 39,379 LBR 39,379 - - - - - - - 39,379 Transportation Equipment 392 $ 1,395,960 LBR 1,395,960 - - - - - - - 1,395,960 Tools, Shop & Garage Equip. 394 $ 100,601 LBR 100,601 - - - - - - - 100,601 Laboratory Equipment 395 $ 2,151 G-Plant 2,151 - - - - - - - 2,151 Power Operated Equipment 396 $ 106 G-Plant 106 - - - - - - - 106 Communication Equipment 397 $ 7,227 G-Plant 7,227 - - - - - - - 7,227 Misc. Equipment 398 $ 49,550 G-Plant 49,550 - - - - - - - 49,550 Other Tangible 399 $ - NA - - - - - - - - - Total general $ $5,662,918 $5,662,918 $0 $0 $0 $0 $0 $0 $0 $5,662,918 Total gross plant in service $ $5,662,918 $5,662,918 $0 $0 $0 $0 $0 $0 $0 $5,662,918 -
Accumulated Depreciation
Production
Steam Production
Land & Land Rights 310 $ - NA - - - - - - - - - Structures and Improvements 311 $ - NA - - - - - - - - - Boiler Plant Equipment 312 $ - NA - - - - - - - - - Turbogenerator Units 314 $ - NA - - - - - - - - - Engines for Biogas at Scholl Canyon 0 $ - NA - - - - - - - - - Engines Unit 10-13 at Grayson 0 $ - NA - - - - - - - - - Accessory Electric Equip. 315 $ - NA - - - - - - - - - Misc. Power Plant Equip. 316 $ - NA - - - - - - - - - Total steam production $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Combustion turbine & other production
Structures and Improvements 341 $ - NA - - - - - - - - - Fuel Holder, Producer & Acc 342 $ - NA - - - - - - - - - Prime Movers 343 $ - NA - - - - - - - - - Generators 344 $ - NA - - - - - - - - - Accessory Plant Equipment 345 $ - NA - - - - - - - - - Misc. Power Plant Equipment 346 $ - NA - - - - - - - - - Total combustion turbine & other production $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total production $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Transmission
Appendix A
Customer Classification
Test Year
Description Fund-Dept Account Units 2024-2028 Allocator C-Services C-Accounting Other Other Other Other Other Other Total Tesla Battery Storage 0 $ - NA - - - - - - - - - Land and Land Rights 350 $ - NA - - - - - - - - - Energy Storage 351 $ - NA - - - - - - - - - Structures and Improvements 352 $ - NA - - - - - - - - - Station Equipment 353 $ - NA - - - - - - - - - Towers and Fixtures 354 $ - NA - - - - - - - - - O.H. Conductors & Devices 356 $ - NA - - - - - - - - - Underground Conduit 357 $ - NA - - - - - - - - - Underground Conductors 358 $ - NA - - - - - - - - - Total transmission $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Distribution
Land and Land Rights 360 $ - NA - - - - - - - - - Structures and Improvements 361 $ - NA - - - - - - - - - Station Equipment 362 $ - NA - - - - - - - - - Poles, Towers & Fixtures 364 $ - NA - - - - - - - - - O.H. Conductors & Devices 365 $ - NA - - - - - - - - - Underground Conduits 366 $ - NA - - - - - - - - - U.G. Conductors & Devices 367 $ - NA - - - - - - - - - Line Transformers 368 $ - NA - - - - - - - - - Services 369 $ - NA - - - - - - - - - Meters 370 $ - NA - - - - - - - - - Street Lights 373 $ - NA - - - - - - - - - Total distribution $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal before general $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 General
Land and Land Rights 389 $ - LBR - - - - - - - - - Structures and Improvements 390 $ 3,316,233 LBR 3,316,233 - - - - - - - 3,316,233 Office Furniture & Equip. 391 $ 39,379 LBR 39,379 - - - - - - - 39,379 Transportation Equipment 392 $ 1,079,919 LBR 1,079,919 - - - - - - - 1,079,919 Tools, Shop & Garage Equip. 394 $ 92,167 LBR 92,167 - - - - - - - 92,167 Laboratory Equipment 395 $ 2,151 G-Plant 2,151 - - - - - - - 2,151 Power Operated Equipment 396 $ 26 G-Plant 26 - - - - - - - 26 Communication Equipment 397 $ 2,487 G-Plant 2,487 - - - - - - - 2,487 Misc. Equipment 398 $ 46,452 G-Plant 46,452 - - - - - - - 46,452 Other Tangible 399 $ - NA - - - - - - - - - Total general $ $4,578,812 $4,578,812 $0 $0 $0 $0 $0 $0 $0 $4,578,812 Total accumulated depreciation $ $4,578,812 $4,578,812 $0 $0 $0 $0 $0 $0 $0 $4,578,812 -
Net Plant in Service
Production
Steam Production
Land & Land Rights 310 $ - NA - - - - - - - - - Structures and Improvements 311 $ - NA - - - - - - - - - Boiler Plant Equipment 312 $ - NA - - - - - - - - - Turbogenerator Units 314 $ - NA - - - - - - - - - Engines for Biogas at Scholl Canyon 0 $ - NA - - - - - - - - - Engines Unit 10-13 at Grayson 0 $ - NA - - - - - - - - - Accessory Electric Equip. 315 $ - NA - - - - - - - - - Misc. Power Plant Equip. 316 $ - NA - - - - - - - - - Total steam production $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Combustion turbine & other production
Structures and Improvements 341 $ - NA - - - - - - - - - Fuel Holder, Producer & Acc 342 $ - NA - - - - - - - - - Prime Movers 343 $ - NA - - - - - - - - - Generators 344 $ - NA - - - - - - - - - Accessory Plant Equipment 345 $ - NA - - - - - - - - - Misc. Power Plant Equipment 346 $ - NA - - - - - - - - - Total combustion turbine & other production $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Appendix A
Customer Classification
Test Year
Description Fund-Dept Account Units 2024-2028 Allocator C-Services C-Accounting Other Other Other Other Other Other Total Total production $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Transmission
Tesla Battery Storage 0 $ - NA - - - - - - - - - Land and Land Rights 350 $ - NA - - - - - - - - - Energy Storage 351 $ - NA - - - - - - - - - Structures and Improvements 352 $ - NA - - - - - - - - - Station Equipment 353 $ - NA - - - - - - - - - Towers and Fixtures 354 $ - NA - - - - - - - - - O.H. Conductors & Devices 356 $ - NA - - - - - - - - - Underground Conduit 357 $ - NA - - - - - - - - - Underground Conductors 358 $ - NA - - - - - - - - - Total transmission $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Distribution
Land and Land Rights 360 $ - NA - - - - - - - - - Structures and Improvements 361 $ - NA - - - - - - - - - Station Equipment 362 $ - NA - - - - - - - - - Poles, Towers & Fixtures 364 $ - NA - - - - - - - - - O.H. Conductors & Devices 365 $ - NA - - - - - - - - - Underground Conduits 366 $ - NA - - - - - - - - - U.G. Conductors & Devices 367 $ - NA - - - - - - - - - Line Transformers 368 $ - NA - - - - - - - - - Services 369 $ - NA - - - - - - - - - Meters 370 $ - NA - - - - - - - - - Street Lights 373 $ - NA - - - - - - - - - Total distribution $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal before general $ $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 General
Land and Land Rights 389 $ 212,739 LBR 212,739 - - - - - - - 212,739 Structures and Improvements 390 $ 538,973 LBR 538,973 - - - - - - - 538,973 Office Furniture & Equip. 391 $ - LBR - - - - - - - - - Transportation Equipment 392 $ 316,041 LBR 316,041 - - - - - - - 316,041 Tools, Shop & Garage Equip. 394 $ 8,434 LBR 8,434 - - - - - - - 8,434 Laboratory Equipment 395 $ - G-Plant - - - - - - - - - Power Operated Equipment 396 $ 80 G-Plant 80 - - - - - - - 80 Communication Equipment 397 $ 4,741 G-Plant 4,741 - - - - - - - 4,741 Misc. Equipment 398 $ 3,098 G-Plant 3,098 - - - - - - - 3,098 Other Tangible 399 $ - NA - - - - - - - - - Total general $ $1,084,106 $1,084,106 $0 $0 $0 $0 $0 $0 $0 $1,084,106 Total net plant in service $ $1,084,106 $1,084,106 $0 $0 $0 $0 $0 $0 $0 $1,084,106 -
Allocation factors
C-Services C-Services 100% 0% 0% 0% 0% 0% 0% 0% 100%
1 - - - - - - - 1 C-Accounting C-Accounting 0% 100% 0% 0% 0% 0% 0% 0% 100% - 1 - - - - - - 1 Other Other 0% 0% 100% 0% 0% 0% 0% 0% 100%
- - 1 - - - - - 1 Other Other 0% 0% 0% 100% 0% 0% 0% 0% 100%
- - - 1 - - - - 1 Other Other 0% 0% 0% 0% 100% 0% 0% 0% 100%
- - - - 1 - - - 1 Other Other 0% 0% 0% 0% 0% 100% 0% 0% 100%
- - - - - 1 - - 1 Other Other 0% 0% 0% 0% 0% 0% 100% 0% 100%
- - - - - - 1 - 1 Other Other 0% 0% 0% 0% 0% 0% 0% 100% 100%
Appendix A
Customer Classification
Test Year
Description Fund-Dept Account Units 2024-2028 Allocator C-Services C-Accounting Other Other Other Other Other Other Total - - - - - - - 1 1 Open Open 0% 0% 0% 0% 0% 0% 0% 0% 0%
-
RevReq RR 100% 0% 0% 0% 0% 0% 0% 0% 100%
20,378,404 - - - - - - - 20,378,404 Revenue Requirement less Fuel/PP/Wheeling RRxFPPW 100% 0% 0% 0% 0% 0% 0% 0% 100% 20,378,404 - - - - - - - 20,378,404 Gross Plant G-Plant 100% 0% 0% 0% 0% 0% 0% 0% 100%
5,662,918 - - - - - - - 5,662,918 Net Plant N-Plant 100% 0% 0% 0% 0% 0% 0% 0% 100%
1,084,106 - - - - - - - 1,084,106 Labor LBR 100% 0% 0% 0% 0% 0% 0% 0% 100%
7,329,663 - - - - - - - 7,329,663 Labor x/ A&G LBRxAG 100% 0% 0% 0% 0% 0% 0% 0% 100%
7,073,470 - - - - - - - 7,073,470 Gross General G-Gen 100% 0% 0% 0% 0% 0% 0% 0% 100%
5,662,918 - - - - - - - 5,662,918 Open Cash CIP 100% 0% 0% 0% 0% 0% 0% 0% 100%
2,979 - 2,979
Open Open 0% 0% 0% 0% 0% 0% 0% 0% 0%
-
Open Open 0% 0% 0% 0% 0% 0% 0% 0% 0%
-
Open Open 0% 0% 0% 0% 0% 0% 0% 0% 0%
-
Open Open 0% 0% 0% 0% 0% 0% 0% 0% 0%
-
Rev Req without Transfers RRxTransfer 100% 0% 0% 0% 0% 0% 0% 0% 100% 18,938,493 - - - - - - - 18,938,493 Not Applicable NA 0% 0% 0% 0% 0% 0% 0% 0% 0%
-
Appendix A
Allocated Cost of Service
Test Year Residential Sml. Business Med. Business Lg. Business Street Lights Description Units 2024-2028 Allocator L-1 L-2 LD-2 PC-1 SL1, SL2, SL3 Total Allocation
Power Supply
Demand
GWP Demand Baseload $ 61,453,179 12CP 26,851,565 5,961,442 13,157,306 15,355,698 127,168 61,453,179 GWP Demand Peaking $ 49,566,750 4CP 24,443,231 4,571,287 9,733,728 10,763,878 54,626 49,566,750 Market Demand $ 3,611,436 12CP 1,577,993 350,338 773,219 902,413 7,473 3,611,436 Energy
Variable $ 121,315,341 NEFL 47,578,496 11,048,979 27,361,393 34,624,463 702,011 121,315,341 Total Power Supply $ 235,946,706 100,451,286 21,932,046 51,025,645 61,646,452 891,278 235,946,706 -
Transmission
Demand
Demand $ 7,122,397 4CP 3,512,322 656,862 1,398,669 1,546,694 7,849 7,122,397 Total Transmission $ 7,122,397 3,512,322 656,862 1,398,669 1,546,694 7,849 7,122,397 -
Distribution
Demand
Demand Substation $ 13,249,118 4 NCP 7,386,498 1,043,739 2,252,708 2,518,465 47,708 13,249,118 Demand Primary Lines $ 7,569,897 4 NCP 4,220,283 596,341 1,287,087 1,438,927 27,258 7,569,897 Demand Secondary Lines $ 16,798,985 4 NCP 9,365,579 1,323,391 2,856,281 3,193,243 60,491 16,798,985 Demand Transformers $ 335,781 4 NCP 187,201 26,452 57,092 63,827 1,209 335,781 Customer
Customer Transformers $ 24,672 C-Xformer 20,707 2,660 455 49 801 24,672 Customer Services $ 173,438 No. Cust 150,444 19,329 3,305 358 1 173,438 Customer Meters $ 4,517,959 No. Meter 3,918,977 503,518 86,091 9,335 39 4,517,959 Other
Customer Streetlights $ 685,614 St. Light - - - - 685,614 685,614 Total Distribution $ 43,355,464 25,249,688 3,515,431 6,543,019 7,224,205 823,121 43,355,464 -
Customer
Customer
C-Services $ 20,378,404 C-Service 14,869,141 3,820,831 979,925 708,361 147 20,378,404 C-Accounting $ - C-Accounting - - - - - - Total Customer $ 20,378,404 - 14,869,141 3,820,831 979,925 708,361 147 20,378,404 -
Total Revenue Requirement $ 306,802,972 - 144,082,437 29,925,170 59,947,259 71,125,712 1,722,395 306,802,972 -
Analysis
Revenues under current rates
Base Rate $ 230,130,506 100,811,925 20,845,918 50,107,775 55,458,888 2,906,000 230,130,506 ECA $ - - - - - - RAC $ - - - - - - RDC $ - - - - - - Total Bill Revenues $ 230,130,506 100,811,925 20,845,918 50,107,775 55,458,888 2,906,000 230,130,506 -
Total Rate Revenue VS Revenue Requirement
Total Bill - Over / (Under) Recovery $ (76,672,465) (43,270,512) (9,079,251) (9,839,484) (15,666,824) 1,183,605 (76,672,465) Total Bill - Rate Increase (Decrease) needed 33.3% 42.9% 43.6% 19.6% 28.2% -40.7% 33.3% Base Rate Revenues VS Revenue Requirement
Base Rate - Revenue Requirement $ 306,802,972 144,082,437 29,925,170 59,947,259 71,125,712 1,722,395 306,802,972 Base Rate - Current Revenues $ 230,130,506 100,811,925 20,845,918 50,107,775 55,458,888 2,906,000 230,130,506 Total Over / (Under) Recovery $ (76,672,465) (43,270,512) (9,079,251) (9,839,484) (15,666,824) 1,183,605 (76,672,465) Base Rate Increase (Decrease) needed 33.3% 42.9% 43.6% 19.6% 28.2% -40.7% 33.3% Unit Cost Analysis
Power Supply
Appendix A
Demand
GWP Demand Baseload $ 26.36 12CP 26.36 26.36 26.36 26.36 26.36 26.36 GWP Demand Peaking $ 45.30 4CP 45.30 45.30 45.30 45.30 45.30 45.30 Market Demand $ 1.55 12CP 1.55 1.55 1.55 1.55 1.55 1.55 Energy $ -
Variable $ 0.1167 NEFL 0.1167 0.1167 0.1167 0.1167 0.1167 0.1167 Total Power Supply $ 73.33 - 73.33 73.33 73.33 73.33 73.33 73.33 Transmission
Demand
Demand $ 7 4CP 6.51 6.51 6.51 6.51 6.51 6.51 Total Transmission $
Distribution
Demand
Demand Substation $ 10.04 4 NCP 10.04 10.04 10.04 10.04 10.04 10.04 Demand Primary Lines $ 5.74 4 NCP 5.74 5.74 5.74 5.74 5.74 5.74 Demand Secondary Lines $ 12.73 4 NCP 12.73 12.73 12.73 12.73 12.73 12.73 Demand Transformers $ 0.25 4 NCP 0.25 0.25 0.25 0.25 0.25 0.25 Customer $ -
Customer Transformers $ 0.26 C-Xformer 0.26 0.26 0.26 0.26 0.26 0.26 Customer Services $ 1.92 No. Cust 1.92 1.92 1.92 1.92 1.92 1.92 Customer Meters $ 49.92 No. Meter 49.92 49.92 49.92 49.92 49.92 49.92 Other $ -
Customer Streetlights $ 56.46 St. Light - - - - 56.46 56.46 Total Distribution $ 137.32 80.86 80.86 80.86 80.86 137.32 137.32 Customer
Customer
C-Services $ 189.40 C-Service 189.40 189.40 189.40 189.40 189.40 189.40 C-Accounting $ - C-Accounting - - - - - - Other $ - NA - - - - - - Total Customer $ 189 189 189 189 189 189 189 Energy rate without Demand 0.2925 0.3377 0.2938 0.2680 0.2529 0.1866 0.2925 Test Year COSA $/kWh sales 0.3134$ 0.3766$ 0.3368$ 0.2725$ 0.2555$ 0.1866$ 0.3134$ Test Year Current Revenues $/kWh sales (incl. current pass throughs) 33.3% 0.2350$ 0.2635$ 0.2346$ 0.2277$ 0.1992$ 0.3149$ 0.2350$ kWh per Month 406 734 10,631 124,074 991,510 902 Revenue Requirement Classified
Demand $ 159,707,543 77,544,673 14,529,852 31,516,090 35,783,146 333,782 159,707,543 Energy $ 121,315,341 47,578,496 11,048,979 27,361,393 34,624,463 702,011 121,315,341 Customer $ 25,094,473 18,959,268 4,346,338 1,069,775 718,104 988 25,094,473 Other $ 685,614 - - - - 685,614 685,614 $ 306,802,972 144,082,437 29,925,170 59,947,259 71,125,712 1,722,395 306,802,972 $ - - - - - - - Revenue Requirement Classified Unit Cost
Demand-4CP 145.96$ 143.71$ 143.99$ 146.67$ 150.59$ 276.80$ 145.96$ Demand-SMD 33.15$ 25.82$ 33.87$ 45.43$ 52.71$ 24.58$ 33.15$ Energy-NEFL 0.1167$ 0.1167$ 0.1167$ 0.1167$ 0.1167$ 0.1167$ 0.1167$ Energy-Sales 0.1239$ 0.1244$ 0.1244$ 0.1244$ 0.1244$ 0.0761$ 0.1239$ Customer-No Cust./light 277.27$ 241.50$ 430.90$ 620.30$ 3,840.13$ 0.08$ 277.27$ Customer-No Cust./month 23.11$ 20.13$ 35.91$ 51.69$ 320.01$ 0.01$ 23.11$ Class Characteristics
kWh/customer or light/month 902 406 734 10,631 124,074 63 902 Load Factor 28% 17% 28% 43% 56% 93% 28%
Avg kW/Customer or light 4 3.2 3.5 33.5 302.6 0.1 4.4 Percent of Total Energy 100% 39% 9% 22% 28% 1% 100%
Percent of Total SMD 100% 62% 9% 14% 14% 0% 100%
Percent of Total Customers 100% 87% 11% 2% 0% 0% 100%
Percent of Energy Costs 100% 39% 9% 23% 29% 1% 100%
Percent of Demand Costs 100% 49% 9% 20% 22% 0% 100%
Appendix A
Percent of Customer Costs 100% 76% 17% 4% 3% 0% 100%
No. Customers or Lights 78,506 10,087 1,725 187 12,144 90,505 Allocation factors
Net Energy For Load NEFL 39% 9% 23% 29% 1% 100%
407,751,486 94,690,628 234,489,308 296,734,393 6,016,289 1,039,682,104 Open Open 0% 0% 0% 0% 0% 0%
-
Open Open 0% 0% 0% 0% 0% 0%
-
Energy at Meter - Sales Sales 39% 9% 22% 28% 1% 100%
382,588,066 88,847,019 220,018,354 278,422,130 9,229,305 979,104,873 12 Coincident Peak 12CP 44% 10% 21% 25% 0% 100%
1,018,483 226,118 499,058 582,443 4,823 2,330,926 4 Coincident Peak 4CP 49% 9% 20% 22% 0% 100%
539,587 100,912 214,873 237,614 1,206 1,094,191 Open Open 0% 0% 0% 0% 0% 0%
-
12 Non Coincident Peak 12 NCP 51% 8% 19% 22% 0% 100%
1,445,142 235,950 535,439 628,650 14,253 2,859,434 4 Non Coincident Peak 4 NCP 56% 8% 17% 19% 0% 100%
735,603 103,943 224,342 250,808 4,751 1,319,447 Open Open 0% 0% 0% 0% 0% 0%
-
Open 0% 0% 0% 0% 0% 0%
-
Open 0% 0% 0% 0% 0% 0%
-
Sum of Maximum Demands Sum Max Dem 62% 9% 14% 14% 0% 100% 3,003,141 428,983 693,799 678,930 13,577 4,818,431 Number of Customers No. Cust 87% 11% 2% 0% 0% 100%
78,506 10,087 1,725 187 1 90,505 Number of Meters No. Meter 87% 11% 2% 0% 0% 100%
78,506 10,087 1,725 187 1 90,505 Street Lights St. Light 0% 0% 0% 0% 100% 100%
- - - - 12,144 12,144 Number of Service Connections C-Connections 87% 11% 2% 0% 0% 100% 78,506 10,087 1,725 187 0 90,504 Number of Customers for Transformers C-Xformer 84% 11% 2% 0% 3% 100% 78,506 10,087 1,725 187 3,036 93,540 Customer Accounting C-Accounting 83% 11% 2% 4% 0% 100%
78,506 10,087 1,725 3,740 1 94,058 Customer Service C-Service 73% 19% 5% 3% 0% 100%
78,506 20,173 5,174 3,740 1 107,594 Open 0% 0% 0% 0% 0% 0%
-
Open 0% 0% 0% 0% 0% 0%
-
Not Applicable NA 0% 0% 0% 0% 0% 0%
-
225 Union Boulevard, Suite 450, Lakewood, Colorado 80228 Phone: (720) 633-9514
Email: [email protected]
www.newgenstrategies.net