HomeMy WebLinkAbout10 Attachment 2 Water Budget SummaryOPERATING BUDGET PRIOR 12 MOS BUDGET $ BUDGET % BUDGET BUDGET $ BUDGET % BUDGET
REVENUE FY21 ENDING 6.2021 FY22 CHANGE CHANGE FY23 CHANGE CHANGE
Residential Sales $12,094,808 $12,509,773 $14,169,117 $2,074,309 17%$15,379,160 $1,210,043 9%
Commercial Sales 1,661,919 1,705,402 1,818,345 156,426 9%1,973,631 155,286 9%
Misc. Operating Revenue 252,578 274,820 272,382 19,804 8%258,669 (13,713)-5%
Miscellaneous Rents 76,651 110,800 69,261 (7,390)-10%69,608 347 1%
Standby Revenue 119,582 114,800 104,742 (14,840)-12%102,647 (2,095)-2%
TOTAL OPERATING REVENUE $14,205,538 $14,715,595 $16,433,847 $2,228,309 16%$17,783,715 1,349,868 8%
Interest Income (General Fund only)103,000 69,865 14,000 (89,000)-86%22,000 8,000 57%
Transfer in from Facilities Fees & Reserve - Debt - 2006 COP 356,179 356,179 358,008 1,829 1%1,358,672 1,000,664 0%
Transfer in from DLAD surcharge for debt payment 800,852 800,852 0 (800,852)-100%0 0 -
Transfer in from DLAD billing surcharge - 2006 COPs 96,216 98,504 99,060 2,844 3%97,837 (1,223)-1%
Transfer in from Capital Reserve Fund 0 0 100,000 100,000 -960,000 860,000 860%
Transfer in from Vehicle Reserve Fund 270,000 270,000 644,306 374,306 139%157,720 (486,586)100%
Transfer in from overhead to cover CalPers sidefund interest
payment 13,022 13,022 2,663 (10,359)100%0 (2,663)-100%
Transfer in from Prop 55 reserve for final debt payment 342,000 342,000 0 (342,000)100%0 0 -
TOTAL WATER REVENUE & TRANSFERS $16,186,807 $16,666,017 $17,651,884 $1,465,078 9%$20,379,944 $2,728,060 15%
TDPUD Budget FY2022 and FY2023 (Draft 11/3/2021)
WATER OPERATIONS REVENUE STATEMENT
10/27/2021 9:43 PM I:\BUDGET\CYB\Central\Summary Budget Sheets Op Rev-Wtr 8A2 Water 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
WATER REVENUES & TRANSFERS $16,186,807 $16,666,017 $17,651,884 $1,465,078 9%$20,379,944 $2,728,060 15%
WATER OPERATING EXPENSES
Board of Directors 166,110 223,089 292,051 125,941 76%226,350 (65,701)-22%
General Management 798,223 946,873 1,367,790 569,567 71%1,412,007 44,217 3%
Administrative Services 1,429,038 1,431,346 1,396,984 (32,054)-2%1,450,006 53,022 4%
Conservation 104,846 58,291 95,194 (9,652)-9%98,645 3,451 4%
Water Operations 5,991,979 5,780,211 6,631,200 639,221 11%6,952,556 321,356 5%
Information Technology (IT)767,900 732,002 859,479 91,579 12%867,412 7,933 1%
Interdepartmental Rent (Appendix I)536,536 521,688 490,824 (45,712)-9%572,076 81,252 17%
TOTAL OPERATING EXPENSES $9,794,633 $9,693,501 $11,133,522 $1,338,889 14%$11,579,052 $445,530 4%
Debt Service (Appendix IX)3,087,521 3,215,064 1,552,201 (1,535,320)-50%1,993,917 441,716 28%
Debt Issuance Costs 285,000 285,000 -0 (285,000)-100%
Transfer to Vehicle Reserve Fund 279,950 279,950 240,000 (39,950)-14%247,000 7,000 3%
Transfer to Capital Reserve 1,015,747 1,015,747 0 (1,015,747)-100%0 0 -
TOTAL EXPENSES & TRANSFERS $14,177,851 $14,204,262 $13,210,723 ($967,128)-7%$13,819,969 $609,246 5%
NET AVAILABLE FOR CAPITAL $2,008,956 $2,461,756 $4,441,162 $2,432,206 121%$6,559,975 $2,118,814 48%
Capital Expenditures (2,008,956)(3,100,000)(9,397,231)(7,388,275)368%(15,276,588)(5,879,357)63%
Bond Debt Proceeds Utilized --5,789,025 5,789,025 -8,965,975 3,176,950 55%
Net Change in General Fund, Water -$(638,244)$832,956$832,956 -249,362$(583,593)-70%
Budget 2022 and 2023, 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 WATER REVENUES AND EXPENSES
10/27/2021 9:43 PM I:\BUDGET\CYB\Central\Summary Budget Sheets Rev-Exp Sum-Wtr 8A2 Water Budget - Page 2 of 8
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 $117,500 $90,978 343%$53,775 ($63,725)-54%
Miscellaneous General Expenses 139,588 197,946 174,551 34,963 25%172,575 ($1,976)-1%
TOTAL $166,110 $223,089 $292,051 $125,941 76%$226,350 ($65,701)-22%
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.
WATER EXPENDITURE DETAIL
8A2 Water 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,317 $117,290 $26,605 29%$122,394 $5,104 4%
This account includes the activities of the PIO plus the website and newsletter.
Administrative & General - Salaries 411,319 567,293 625,564 214,245 52%638,317 12,753 2%
This account is used to charge general administrative staff time other than safety and board related activities.
Legislature & Regulations 46,256 39,628 46,824 568 1%46,942 118 0%
This account is for legislation and regulation tracking labor.
Office Supplies & Expenses 77,020 68,125 79,000 1,980 3%81,368 2,368 3%
This account is used to cover cell phone use, computer expenses, dues & memberships including LAFCO, industry meetings, office supplies, postage, training, assessment, personnel expenses and safety .
Outside Services Employed 60,049 83,554 184,576 124,527 207%193,783 9,207 5%
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.
Injuries & Damages (Safety)2,305 3,206 102,779 100,474 4359%106,911 4,132 4%
General Advertising Expenses 64,772 23,986 137,664 72,892 113%145,008 7,344 5%
This account is used for the cost of publishing ordinances, surplus material, and other legal ad requirements.
Misc General Expenses 45,817 65,764 74,093 28,276 62%77,284 3,191 4%
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 industry organizations.
TOTAL $798,223 $946,873 $1,367,790 $569,567 71%$1,412,007 $44,217 3%
$148,649
19%
WATER 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).
8A2 Water 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 $0 $0 $0-$0 $0-
This account is used by the meter readers to charge their time to perform meter connects, disconnects and service transfers. It is also used for investigating customer high bill complaints.
Customer Account Operations Expense-Salaries 155,783 158,951 151,728 (4,055)-3%158,340 6,612 4%
This account includes the management staff supervision of the customer service and billing functions.
Meter Reading Expense 967 0 1,100 133 14%1,133 33 3%
Customer Records & Collections Expense 551,863 423,256 533,476 (18,387)-3%555,344 21,868 4%
Provision for Bad Debts 5,249 11,085 7,500 2,251 43%7,725 225 3%
This account represents the amount of uncollectable bills for the year.
Administrative & Operations General-Salaries 462,481 492,192 405,425 (57,056)-12%425,819 20,394 5%
Office Supplies & Expenses 71,112 78,545 83,300 12,188 17%85,795 2,495 3%
Outside Services Employed 27,189 128,322 45,500 $18,311 67%41,638 (3,862)-8%
Insurance 140,277 126,882 140,500 223 0%144,715 4,215 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)14,117 12,114 28,455 14,338 102%29,497 1,042 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,429,038 $1,431,346 $1,396,984 ($32,054)-2%$1,450,006 $53,022 4%
$2,308
0%
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.
WATER 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, 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.
8A2 Water 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
Water Conservation $77,282 $46,609 $58,790 (18,492)-24%$61,010 2,220 4%
This account includes water conservation & efficiency
Public Benefit - R&D, Conservation 0 0 9,771 9,771 -10,100 329 3%
Admin & General Salaries 9,395 0 8,663 (732)-8%9,027 364 4%
This account includes the administrative salaries to perform
Office Supplies & Expenses 6,967 943 3,870 (3,097)-44%3,985 115 3%
This account includes office supplies, dues, memberships and
Injuries & Damages (Safety)94 343 0 (94)-100%0 0-
Safety meetings
General Advertising 8,018 10,396 11,100 3,082 38%11,433 333 3%
This account includes TDPUD marketing and media activities.
Misc General Expense 3,090 0 3,000 (90)-3%3,090 90 3%
This account includes support of community activities such as
TOTAL $104,846 $58,291 $95,194 ($9,652)-9%$98,645 $3,451 4%
($46,555)
-44%
WATER EXPENDITURE DETAIL
8A2 Water Budget - Page 6 of 8
WATER BUDGET PRIOR 12 MOS BUDGET $ BUDGET % BUDGET BUDGET $ BUDGET % BUDGET
OPERATIONS FY21 ENDING 6.2021 FY22 CHANGE CHANGE FY23 CHANGE CHANGE
Operations Supervision & Engineering $383,476 $406,727 $336,629 ($46,847)-12%$352,226 $15,597 5%
Facilities Operations (source of supply Ops)889,761 1,111,020 1,091,217 201,456 23%1,135,218 44,001 4%
Power Supply 1,333,468 1,375,917 1,433,728 100,260 8%1,516,028 82,300 6%
This account includes the cost of electrical power for the operation of the wells and pump stations.
Distribution Operations/PM 563,891 691,836 662,856 98,965 18%690,322 27,466 4%
This account includes the labor and materials to operate the water distribution system.
Meters/Service Operation 508,956 78,645 389,414 (119,542)-23%404,661 15,247 4%
Misc General Operations/PM 442,803 482,237 657,393 214,590 48%696,641 39,248 6%
Maintenance of Operations Sup & Engineering 221,355 263,750 217,937 (3,418)-2%227,194 9,257 4%
Used by water manager, superintendent and engineer for supervision, engineering and management of District water system.
Maintenance of Sources 844,156 722,455 659,268 (184,888)-22%701,332 42,064 6%
This account includes the maintenance and repair of pumps, motors, electrical control equipment and building repair.
Maintenance of Distribution Lines 718,575 525,164 1,078,797 360,222 50%1,120,494 41,697 4%
This account includes the maintenance and repair of distribution line leaks, broken fire hydrants, etc.
Injuries & Damages 85,537 122,460 103,961 18,424 22%108,440 4,479 4%
This account includes labor for safety meetings, equipment and training expenses.
Maintenance of District Office Building (Div 1)440,391 329,696 761,214 320,823 73%744,787 (16,427)-2%
TOTAL $6,432,370 $6,109,907 $7,392,414 960,044 15%$7,697,343 $304,929 4%
($322,462)
-5%
Total, excluding Maintenance of D.O.B.$5,991,979 $5,780,211 $6,631,200 639,221 11%$6,952,556 321,356 5%
($211,768)
-4%
WATER EXPENDITURE DETAIL
This account includes a variety of items such as environmental compliance, GIS mapping of the water system, SCADA repairs and maintenance, cell phones, pagers,
computer hardware and software, clothing allowance, DMV physicals, meals, uniforms, land fill charges, meeting expenses, advertising and testing for new employees,
training, and Underground Service Alert marking of utilities and associated fees and costs.
This account includes the operation of wells, pump stations, water treatment, water quality, DHS reports and fees and water quality reports. It also includes snow removal
and related employee training.
This account is utilized by the water manager, superintendent and engineer for supervision, engineering and management of District water system.
10/27/2021 9:43 PM I:\BUDGET\CYB\Central\Summary Budget Sheets CC#7-Water 8A2 Water 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 $117,822 $134,409 $119,373 $1,551 1%$123,935 $4,562 4%This account is for the operational use of SCADA, Outage
Management and Engineering support.
GIS/Engineering Operations 92,927 54,489 85,528 (7,399)-8%88,889 3,361 4%This account is for the maintenance of software and data that
supports engineering and SCADA.
Meter Reading 39,819 20,026 53,636 13,817 35%55,456 1,820 3%This account is for the maintenance of software and data that
supports meter technology and AMI.
Customer Records 100,873 92,649 113,740 12,867 13%117,580 3,840 3%This account is for the maintenance of software and data that
supports Customer Information and Customers.
Administrative & General IT Ops 380,188 374,496 395,900 15,712 4%397,884 1,984 1%This account is for the maintenance of hardware and software
infrastructure that supports data transport, storage and
Office Supplies & Expenses 9,175 38,172 9,205 30 0%9,481 276 3%This account includes office supplies, dues, memberships,
meeting and training expenses.
Outside Services Employed 10,300 5,670 65,300 55,000 534%56,659 (8,641)-13%
This account is for outside professional services contracted to maintain hardware, software and data.
Safety 16,796 12,091 16,797 1 0%17,528 731 4%
This account includes department labor for safety meetings, safety equipment and training expenses.
TOTAL $767,900 $732,002 $859,479 $91,579 12%$867,412 $7,933 1%
($35,898)
-5%
WATER EXPENDITURE DETAIL
8A2 Water Budget - Page 8 of 8