Page 161 - FY2020Colleyville
P. 161

UTILITY OPERATING FUND SUMMARY

                                                 BUDGET     BUDGET    PROJECTION  PROJECTION  PROJECTION  PROJECTION
                                                  FY 2019   FY 2020    FY 2021    FY 2022    FY 2023    FY 2024
           TOTAL BEG. WORKING CAPITAL             4,494,686  4,494,687  4,494,687  4,494,687  4,494,687  4,494,688
           FUND REVENUES
             Water Sales                                0          0          0          0         0          1
             Water - Base Rate                    1,692,467  1,742,896  1,764,347  1,804,671  1,845,889  1,888,020
             Water - Volumetric Rate              9,794,756  10,578,071  10,929,340  11,327,057  11,740,196  12,169,396
             Wastewater Sales                           0          0          0          0         0          0
             Wastewater - Base Rate               1,281,579  1,268,040  1,279,994  1,310,631  1,341,968  1,374,021
             Wastewater - Volumetric Rate         3,299,803  3,629,783  3,992,762  4,392,038  4,831,242  5,314,366
             Water Installation                     42,000     42,000     42,000     42,000     42,000     42,000
             Wastewater Installation                15,000     15,000     15,000     15,000     15,000     15,000
             Engineering Charges                     5,000      5,000      5,000      5,000      5,000     5,000
             Penalties                             200,000    200,000    200,000    200,000    200,000    200,000
             Miscellaneous                          15,000     15,000     15,000     15,000     15,000     15,000
             Interest Income                        60,000     60,000     60,000     60,000     60,000     60,000
           TOTAL REVENUES                       16,405,605  17,555,789  18,303,443  19,171,396  20,096,294  21,082,804
           FUND EXPENSES
             Utility Billing                       457,638    438,748    447,523    456,473    465,603    474,915
             IS GIS                                 66,549     69,235     71,658     74,166     76,762     79,449
             Utility Support                      1,178,946  1,168,323  1,191,689  1,215,523  1,239,834  1,264,630
             Utility Operations - Water            701,346    772,875    788,333    804,099    820,181    836,585
                 TRA Water (volumetric)           6,627,588  7,252,545  7,437,538  7,660,664  7,890,484  8,127,199
                 TRA Water (debt)                 3,167,168  3,325,526  3,491,802  3,666,392  3,849,712  4,042,198
             Utility Operations - Wastewater       290,458    298,019    303,979    310,059    316,260    322,585
                 TRA Wastewater                   3,299,803  3,629,783  3,992,762  4,392,038  4,831,242  5,314,366
             Non-Departmental                      233,605    233,605    238,277    243,043    247,903    252,862
             Transfer to General Fund              226,117    250,030    258,781    267,838    277,213    286,915
             Transfer/Repayment to Colleyville Tomorrow Fund  44,286  0       0          0         0          0
             Transfer for future vehicle replacement  81,100   81,100     81,100     81,100     81,100     81,100
             Compensation Adjustment (merit pool)   31,000     36,000         0          0         0          0
             Debt Service                               0          0          0          0         0          0
           TOTAL EXPENDITURES                   16,405,604  17,555,789  18,303,443  19,171,396  20,096,294  21,082,803
           ENDING WORKING CAPITAL - 9/30          4,494,687  4,494,687  4,494,687  4,494,687  4,494,688  4,494,691

           Notes:
           1. 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).  FY 2017 numbers shown here have been adjusted for
           2. Year-end operating surpluses are transferred to the Utility Capital Projects Fund for future utility capital projects.
           100 days of reserves are maintained in the Utility Operating Fund.
           3. In FY 2018, all Utility Fund debt was paid off by the City of Colleyville. The City is working to make a complete
           transition to a cash funded strategy.

































                                                                                                          159
   156   157   158   159   160   161   162   163   164   165   166