HomeMy WebLinkAbout10 Attachment 1 Electric Budget SummaryTDPUD Budget FY2022 and FY2023 (Draft 11/3/2021)
ELECTRIC OPERATIONS REVENUE STATEMENT
OPERATING BUDGET PRIOR 12 MOS BUDGET $ BUDGET % BUDGET BUDGET $ BUDGET % BUDGET
REVENUE FY21 ENDING 6.2021 FY22 CHANGE CHANGE FY23 CHANGE CHANGE
Residential Sales $14,705,571 $15,822,797 $17,523,806 $2,818,235 19%$18,756,168 $1,232,362 7%
Commercial Sales 10,677,560 10,692,605 11,855,692 1,178,132 11%12,689,444 833,752 7%
Interdepartmental Sales 1,308,775 1,241,201 1,373,234 64,459 5%1,489,959 116,725 9%
Miscellaneous Operating Revenue 170,578 117,614 115,785 (54,793)-32%116,364 579 1%
Standby Revenue 18,225 18,670 17,000 (1,225)-7%16,600 (400)-2%
Pole Replacements and Contacts 267,266 477,231 277,231 9,965 4%278,617 1,386 0%
Interdepartmental Rent 536,536 521,688 490,824 (45,712)-9%572,076 81,252 17%
TOTAL OPERATING REVENUE $27,684,511 $28,891,806 $31,653,572 $3,969,061 14%$33,919,228 $2,265,656 7%
Interest Income (General Fund Only)388,712 175,111 19,000 (369,712)-95%27,000 8,000 42%
Transfer in from Vehicle Reserve Fund 450,000 450,000 497,193 47,193 10%763,164 265,971 53%
Transfer in from Capital Reserve Fund 1,772,658 0 6,650,000 4,877,342 275%650,000 (6,000,000)-90%
Transfer in from Facility Fees Fund 72,428 72,428 0 (72,428)-100%0 0 -
Transfer in from overhead to cover CalPers
sidefund interest payment 19,532 19,532 3,994 (15,538)-80%0 (3,994)-100%
Transfer in from AB32 Reserve Fund 1,400,000 1,400,000 1,000,000 (400,000)-29%550,000 (450,000)-45%
TOTAL ELECTRIC REVENUE & TRANSFERS $31,787,842 $31,008,878 $39,823,759 $8,035,917 25%$35,909,392 ($3,914,367)-10%
10/27/2021 9:37 PM I:\BUDGET\CYB\Central\Summary Budget Sheets Op Rev-Elec 8A1 Electric Budget - Page 1 of 8
BUDGET PRIOR 12 MOS BUDGET $ BUDGET % BUDGET BUDGET $ BUDGET % BUDGET
FY21 ENDING 6.2021 FY22 CHANGE CHANGE FY23 CHANGE CHANGE
ELECTRIC REVENUES & TRANSFERS $31,787,842 $31,008,878 $39,823,759 $8,035,917 25%$35,909,392 ($3,914,367)-10%
ELECTRIC OPERATING EXPENSES
Board of Directors 166,110 224,019 452,049 285,939 172%386,344 (65,705)-15%
General Management 902,536 1,030,575 1,465,677 563,141 62%1,533,653 67,976 5%
Administrative Services 1,417,122 1,503,496 1,427,862 10,740 1%1,476,195 48,333 3%
Conservation 817,370 463,553 883,071 65,701 8%915,162 32,091 4%
Electric Operations 5,979,295 7,096,277 6,988,308 1,009,013 17%7,105,456 117,148 2%
Information Technology (IT)1,529,658 1,206,919 1,636,077 106,419 7%1,661,373 25,296 2%
Purchased Power 12,915,399 12,206,025 13,509,000 593,601 5%13,982,000 473,000 3.5%
Building Maintenance (cost 100% distributed)440,391 329,696 761,214 320,823 73%744,787 (16,427)-2%
TOTAL OPERATING EXPENSES $24,167,881 $24,060,561 $27,123,258 $2,955,377 12%$27,804,970 $681,712 3%
Debt Service 642,933 632,409 447,394 (195,539)-30%441,491 (5,903)-1%
Debt Issuance Costs 185,000 185,000 -0 (185,000)-100%
Transfer to Vehicle Reserve 214,556 214,556 675,000 460,444 215%786,000 111,000 16%
Transfer to Electric Rate Reserve Fund 0 0 326,000 326,000 0%210,000 (116,000)-36%
Transfer to Electric Capital Fund 257,486 257,486 0 (257,486)-100%0 0 0%
TOTAL EXPENSES & TRANSFERS 25,282,856 25,165,012 28,756,652 3,473,796 14%29,242,461 485,809 2%
NET AVAILABLE FOR CAPITAL $6,504,986 $5,843,866 $11,067,107 $4,562,121 70%$6,666,931 ($4,400,176)-40%
Capital Expenditures (6,504,986)(5,300,000)(16,397,910)(9,892,924)152%(6,617,937)9,779,973 -60%
Bond Debt Proceeds utilized --6,000,000 6,000,000 --(6,000,000)-100%
Net Change in General Fund, Electric -$543,866$669,197$669,197 -48,994$(620,203)-93%
Budget 2022, the Increase in General Fund is to improve operating reserve (general fund reserve) based on District Code defined goal.
TDPUD Budget FY2022 and FY2023 (Draft 11/3/2021)
SUMMARY OF ELECTRIC REVENUES AND EXPENSES
10/27/2021 9:37 PM I:\BUDGET\CYB\Central\Summary Budget Sheets Rev-Exp Sum-Elec 8A1 Electric Budget - Page 2 of 8
ELECTRIC EXPENDITURE DETAIL
BOARD OF BUDGET PRIOR 12 MOS BUDGET $ BUDGET % BUDGET BUDGET $ BUDGET % BUDGET
DIRECTORS FY21 ENDING 6.2021 FY22 CHANGE CHANGE FY23 CHANGE CHANGE
Outside Services Employed $26,523 $25,142 $277,500 $250,978 946%$213,775 ($63,725)-23%
Miscellaneous General Expenses 139,588 198,877 174,549 34,961 25%172,569 (1,980)-1%
TOTAL $166,110 $224,019 $452,049 $285,939 172%$386,344 ($65,705)-15%
This account is utilized to reflect costs associated with the District's general counsel attendance at board meetings and his performance of research on legal issues
presented at the board level.
This account covers compensation and benefits paid to directors, election, annual employee recognition dinner, training and conferences attended by directors, minor
office supplies and equipment.
10/27/20219:37 PMI:\BUDGET\CYB\Central\Summary Budget SheetsCC#1-Elec 8A1 Electric Budget - Page 3 of 8
GENERAL BUDGET PRIOR 12 MOS BUDGET $ BUDGET % BUDGET BUDGET $ BUDGET % BUDGET
MANAGEMENT FY21 ENDING 6.2021 FY22 CHANGE CHANGE FY23 CHANGE CHANGE
Public Information $90,685 $95,354 $117,292 $26,607 29%$122,396 $5,104 4%
Administrative & General - Salaries 411,319 567,482 625,575 214,256 52%638,326 12,751 2%
Legislature & Regulations 96,082 90,549 99,111 3,029 3%98,956 (155)0%
Office Supplies & Expenses 77,020 66,505 79,000 1,980 3%81,372 2,372 3%
Outside Services Employed 64,581 82,242 202,079 137,498 213%234,472 32,393 16%
Injuries & Damages 2,305 3,543 77,781 75,476 3274%81,164 3,383 4%
General Advertising Expenses 91,861 42,231 169,944 78,083 85%178,258 8,314 5%
Misc General Expenses 68,683 82,669 94,895 26,212 38%98,709 3,814 4%
TOTAL $902,536 $1,030,575 $1,465,677 $563,141 62%$1,533,653 $67,976 5%
$128,039
14%
ELECTRIC EXPENDITURE DETAIL
This account includes labor for department safety meetings and training and the organization's wellness program, and addition of Safety and Risk Coordinator postion
FTE starting in Budget 2022 (split 50%E/50%W).
This account is used for the cost of publishing ordinances, surplus material, and other legal ad requirements.
This account is used to perform board related activities such as preparing meeting minutes, resolutions and ordinances; it is also charged with dues and
memberships in electric utility organizations.
This account is used to charge general administrative staff time other than safety and board related activities.
This account is used to cover cell phone use, computer expenses, dues & memberships including LAFCO and NCPA, industry meetings, office supplies, postage,
training, assessment, personnel expenses and safety .
This account is used to charge the costs of general counsel to review contracts and agreements, property issues, insurance claims, bid issues, capital contract issues
and union matters.
This account includes the activities of the PIO plus the website and newsletter.
This account is for legislation and regulation tracking labor.
10/27/20219:37 PMI:\BUDGET\CYB\Central\Summary Budget SheetsCC#2-Elec 8A1 Electric Budget - Page 4 of 8
ADMINISTRATIVE BUDGET PRIOR 12 MOS BUDGET $ BUDGET % BUDGET BUDGET $ BUDGET % BUDGET
SERVICES FY21 ENDING 6.2021 FY22 CHANGE CHANGE FY23 CHANGE CHANGE
Meters/Services Operations Expenses $0 $12,813 $0 $0-$0 $0-
This account is used by the meter readers to charge their time to perform meter connects, disconnects and service transfers.
Customer Installation Expense 0 1 0 0-0 0-
This account includes charges for GO165 inspections for the electric department as well as investigations of energy diversion.
Customer Account Operations Expense-Salaries 155,783 158,999 151,732 (4,051)-3%158,343 6,611 4%
This account includes the management staff supervision of the customer service and billing functions.
Meter Reading Expense 8,850 6,797 9,000 150 2%9,270 270 3%
Customer Records & Collections Expense 551,863 438,100 533,483 (18,380)-3%555,357 21,874 4%
Customer Records & Collections - Meter Readers 19,636 471 10,851 (8,785)-45%11,298 447 4%
This account includes the meter readers labor and overheads to deliver 48 hour notices and perform disconnect and reconnects relating to non-payment of utility bills.
Provision for Bad Debts 12,851 51,282 17,500 4,649 36%12,275 (5,225)-30%
This account represents the amount of uncollectable bills for the year.
Administrative & Operations General-Salaries 462,481 544,344 405,441 (57,040)-12%425,831 20,390 5%
Office Supplies & Expenses 66,157 79,253 91,300 25,143 38%94,043 2,743 3%
Outside Services Employed 14,258 67,304 45,600 $31,342 220%41,745 ($3,855)-8%
This account includes any professional services hired from the outside such as audit or accounting services, trust services for our certificates of participation and community facilities districts and arbitrage calculation services for the same.
Insurance 106,747 123,783 134,500 27,753 26%138,535 4,035 3%
This account Includes annual insurance premiums for property, liability, umbrella liability, directors & officers liability, difference in conditions, boiler & machinery coverage insurance.
Injuries & Damages (Safety)18,496 20,350 28,455 9,959 54%29,498 1,043 4%
This account Includes costs for safety training, Department of Transportation Drug and Alcohol training, worker's compensation expenses for employees who have been injured and safety related equipment.
TOTAL $1,417,122 $1,503,496 $1,427,862 $10,740 1%$1,476,195 $48,333 3%
$86,374
6%
ELECTRIC EXPENDITURE DETAIL
This account includes the major expenses involved in serving our customers. Included are answering and directing phone calls, answering customer questions, customer account setup expenses, taking and processing customer payments, creating
connect, disconnect and transfer paperwork for the crews, creating and reviewing bills, expenses related to the printing and mailing of the bills, account collection expense, billing software and hardware support, standby billing expenses, billing equipment
maintenance expenses, printed billing and collection forms, billing postage and customer service staff training.
This account includes most of the labor for the administration department except meter reading and customer account related expenses. It includes preparation of the budget and financial statements, accounts payable and payroll, construction
accounting, cash management activities and processing the daily mail.
This account is used to charge meter reading expenses which includes meter reader labor, overheads, and the hardware and software that supports the meter readers; it also includes their clothing allowance, uniform expenses, vehicle expenses and
training.
This account includes bank charges, answering service charges, phone charges, computer and network operating expenses, software maintenance and support for the accounting system, printed forms and material, office equipment leases and equipment
maintenance expenses.
10/27/20219:37 PMI:\BUDGET\CYB\Central\Summary Budget SheetsCC#3-Elec 8A1 Electric Budget - Page 5 of 8
BUDGET PRIOR 12 MOS BUDGET $ BUDGET % BUDGET BUDGET $ BUDGET % BUDGET
CONSERVATION FY21 ENDING 6.2021 FY22 CHANGE CHANGE FY23 CHANGE CHANGE
Public Benefits - Conservation $207,530 $193,492 $196,681 ($10,849)-5%$196,093 ($588)0%
The account includes general energy conservation and efficiency programs and wire to water.
Public Benefits - Elec Vehicle Chrg Rebates 0 6,500 38,043 38,043 -44,036 5,993 16%
This account includes electic vehicle charger rebates
Public Benefits - Research & Development 103,156 8,754 77,304 (25,852)-25%85,138 7,834 10%
This account includes energy conservation and efficiency R&D activities.
Public Benefits - Income-Qualifed 55,954 69,323 28,046 (27,908)-50%28,976 930 3%
This account includes income-qualifed programs.
Public Benefits - Renewable Power 150,000 71,062 150,000 0 0%155,000 5,000 3%
This account includes renewable purchases and programs.
Public Benefits - Rebates 230,609 86,775 318,468 87,859 38%328,765 10,297 3%
This account includes energy conservation and efficiency rebates.
Admin & General Salaries 27,947 1,374 32,599 4,652 17%33,965 1,366 4%
This account includes the administrative salaries to perform various administrative projects.
Office Supplies & Expenses 16,256 1,299 9,030 (7,226)-44%9,302 272 3%
This account includes office supplies, dues, memberships and meeting and training expenses.
Injuries & Damages (Safety)0 510 0 0-0 0-
Safety meetings
General Advertising 18,709 24,466 25,900 7,191 38%26,677 777 3%
This account includes TDPUD marketing and media activities.
Misc General Expense 7,210 0 7,000 (210)-3%7,210 210 3%
This account includes support of community activities such as sponsorship of the Truckee Home Show, Chamber activities, etc.
TOTAL $817,370 $463,553 $883,071 $65,701 8%$915,162 $32,091 4%
($353,817)
-43%
ELECTRIC EXPENDITURE DETAIL
10/27/20219:37 PMI:\BUDGET\CYB\Central\Summary Budget SheetsCC#4-Elec 8A1 Electric Budget - Page 6 of 8
ELECTRIC BUDGET PRIOR 12 MOS BUDGET $ BUDGET % BUDGET BUDGET $ BUDGET % BUDGET
OPERATIONS FY21 ENDING 6.2021 FY22 CHANGE CHANGE FY23 CHANGE CHANGE
Operations/PM Sup & Engineering $1,147,466 $1,460,754 $1,186,324 $38,859 3%$1,237,903 $51,579 4%
Substation Operations/PM 218,472 282,258 477,703 259,231 119%495,896 18,193 4%
Distribution Operations/PM 2,365,482 3,131,799 2,893,209 527,727 22%2,977,385 84,176 3%
Security/Street Light Operations/PM 1,489 7,805 11,753 10,264 690%12,248 495 4%
Meter Operations/PM 210,658 194,263 236,252 25,594 12%240,044 3,792 2%
Customer Installation Operations/PM 236,065 303,919 126,170 (109,895)-47%131,501 5,331 4%
Misc General Operations/PM 579,762 686,159 549,672 (30,090)-5%577,212 27,540 5%
Maintenance of Station Equipment 3,457 9,611 3,514 57 2%3,638 124 4%
Maintenance of Distribution Lines 724,927 559,690 821,300 96,373 13%851,757 30,457 4%
Maintenace of Security/Street Lights 5,748 5,006 1,751 (3,997)-70%1,803 52 3%
Professional Services 154,500 165,154 295,000 140,500 91%164,800 (130,200)-44%
Injuries & Damages (Safety)270,919 238,903 325,295 54,376 20%333,835 8,540 3%
Regulatory Commission Expense 60,351 50,955 60,365 14 0%77,434 17,069 28%
TOTAL $5,979,295 $7,096,277 $6,988,308 $1,009,013 17%$7,105,456 $117,148 2%
$1,116,982
19%
OPERATION 5,245,164 6,521,970 6,161,743 916,579 17%6,248,258 86,515 1%
MAINTENANCE 734,132 574,307 826,565 92,433 13%857,198 30,633 4%
5,979,295 7,096,277 6,988,308 1,009,013 17%7,105,456 117,148 2%
This account includes labor, materials and supplies (replacement bulbs, photocells and fixtures) for the maintenance and repair of security and street lights.
This account includes payments to Energy Source and Power Supply consultants. It also includes UAMPS expenditures.
This account Includes labor for safety meetings, safety equipment and safety meeting/training expenses.
This account includes staff labor and legal fees for any FERC activity.
This account includes connecting and disconnecting meters, checking the operation of demand meters, meter audits where we verify the wiring and accuracy of commercial meter installations, rebuilding of old commercial meter
installations and training of meter technicians.
This account primarily includes the inspection of new residential services including checks of wiring code compliance. It is also used to do field investigations of customer high bill complaints, voltage irregularities and energy diversion.
This account includes testing of transformer oil to determine PCB content, GIS mapping of the electric system, SCADA repairs and maintenance, cell phones qne pages. It also includes computer hardware and software maintenance,
clothing allowance, DMV physicals, meals, uniforms, land fill charges, meeting expenses, advertising, new employee testing, employee development and training, and Underground Service Alert marking of utilities.
This account Includes labor and material to maintain the reclosers and regulators within the substations.
This account primarily includes labor and material material for recloser repair, distribution line repair, damage tree clearing, standby labor and storm damage repair.
ELECTRIC EXPENDITURE DETAIL
This account is utilized by the electric superintendent and electric engineer for supervision, engineering and management of District electric operations and electric projects. It also includes design and engineering labor of District electric
projects.
This account Includes all work done on, and within, substations including snow removal, maintenance, repairs and associated materials and employee training.
This account Includes the purchase and installation of street and security lights throughout the District.
This account Includes all maintenance work such as mandated programs (including wildfire mitigation), pole testing, tree trimming, pole clearing, small tools and employee training.
10/27/20219:37 PMI:\BUDGET\CYB\Central\Summary Budget SheetsCC#6-Elec 8A1 Electric Budget - Page 7 of 8
BUDGET PRIOR 12 MOS BUDGET $ BUDGET % BUDGET BUDGET $ BUDGET % BUDGET
INFORMATION TECHNOLOGY (IT)FY21 ENDING 6.2021 FY22 CHANGE CHANGE FY23 CHANGE CHANGE
Engineering & SCADA Operations $185,610 $102,187 $203,330 $17,720 10%$211,167 $7,837 4%This account is for the operational use of SCADA, Outage
Management and Engineering support.
GIS/Engineering Operations 255,619 133,898 244,696 (10,923)-4%253,966 9,270 4%This account is for the maintenance of software and data that
supports engineering and SCADA.
Meter Reading 156,022 97,100 152,108 (3,914)-3%157,317 5,209 3%This account is for the maintenance of software and data that
supports meter technology and AMI.
Customer Records 151,309 151,256 170,609 19,300 13%176,366 5,757 3%This account is for the maintenance of software and data that
supports Customer Information and Customers.
Administrative & General IT Ops 706,064 620,303 735,240 29,176 4%738,932 3,692 1%This account is for the maintenance of hardware and software
infrastructure that supports data transport, storage and
Office Supplies & Expenses 17,039 57,263 17,095 56 0%17,608 513 3%This account includes office supplies, dues, memberships,
meeting and training expenses.
Outside Services Employed 41,200 21,535 96,200 55,000 133%88,486 (7,714)-8%
This account is for outside professional services contracted to maintain hardware, software and data.
Safety 16,796 23,378 16,799 3 0%17,531 732 4%
This account includes department labor for safety meetings, safety equipment and training expenses.
TOTAL $1,529,658 $1,206,919 $1,636,077 $106,419 7%$1,661,373 $25,296 2%
($322,739)
-21%
ELECTRIC EXPENDITURE DETAIL
10/27/20219:37 PMI:\BUDGET\CYB\Central\Summary Budget SheetsCC#9-Electric 8A1 Electric Budget - Page 8 of 8