Page 57 - City of Colleyville FY22 Adopted Budget

UTILITY OPERATING FUND SUMMARY

ACTUAL PROJECTED BUDGETED
FY 2020 FY 2021 FY 2022
BEG. WORKING CAPITAL 5,873,267 5,873,267 5,699,511
FUND REVENUES
Water - Base Rate 1,797,655 1,830,000 1,985,445
Water - Volumetric Rate 10,123,865 9,277,232 10,605,069
Sale of Material 4,362 3,214 0
Wastewater - Base Rate 1,230,121 1,380,000 1,452,695
Wastewater - Volumetric Rate 2,964,397 3,259,153 3,303,963
Water Installation 24,430 20,000 42,000
Wastewater Installation 7,200 7,000 15,000
T.R.A. TRUE-UP 440,771 1,452,481 450,000
Engineering Charges 62,217 5,000 5,000
Penalties 91,060 50,000 200,000
Miscellaneous 8,505 7,000 15,000
Interest Income 104,305 10,000 14,000
TOTAL REVENUES 16,858,888 17,301,081 18,088,171
FUND EXPENSES
Utility Billing 415,035 418,052 482,912
IS GIS 73,034 77,235 76,032
Utility Support 1,130,731 1,186,007 1,273,326
Utility Operations - Water 844,476 838,022 908,623
TRA Water (volumetric) 6,004,020 6,056,723 6,923,613
TRA Water (debt) 3,393,244 3,220,509 3,681,456
Utility Operations - WW 320,549.00 366,651 368,803
TRA Wastewater 2,874,020 3,259,153 3,303,963
Non-Departmental 174,020 237,043 233,605
Transfer to General Fund 250,030 281,861 304,738
T.R.A. True-Up / Capital Transfer 1,263,708 1,452,481 450,000
VERF Transfer 81,100 81,100 81,100
Merit Pool* 34,922 - -
TOTAL EXPENDITURES 16,858,888 17,474,837 18,088,171

ENDING WORKING CAPITAL 5,873,267 5,699,511 5,699,511

Costs related to the purchase of water/sewer treatment from the
Trinity River Authority
Costs related to maintenance and operation of the City's system
Days of Working Capital 127 119 115

*The Merit Pool (salary increases) costs used to be shown in one line item. Since 2021,
these costs are distributed in each department's budget.
**In FY 2017 the Utility Fund was divided into a Utility Operating Fund (shown here)
and a Utility Capital Projects Fund (to separately track resources for utility capital
projects). Depreciation expenses are not included.

***Year-end operating surpluses are transferred to the Utility Capital Projects Fund for
future utility capital projects. A minimum of 100 days of reserves are maintained in the
Utility Operating Fund.

55