Page 209 - Keller FY20 Approved Budget
P. 209

WATER AND WASTEWATER FUND OVERVIEW



            FUND DESCRIPTION:
            The Water and Wastewater Fund provides water and wastewater utility services including water delivery, utility line maintenance,
            and wastewater treatment and is funded through consumption-based water and wastewater utility fees.


                                                                                         FY 2019-20
                                                 FY 2017-18    FY 2018-19   FY 2018-19    Adopted       Budget
                                                   Actual       Budget       YE Proj.      Budget     Variance ($)
             ONE-TIME EXPE
                                                                             24,593,547 -
                                                                                                         (218,181) -
                                                                27,951,785 -
                                                                                           27,733,604 -

            REVENUE TOTALNDITURES              $        27,021,133 -
                                                                           $
                                                              $
                                                                                                      $

                                                                                        $
            EXPENDITURE TOTAL                  $        24,844,653  $    27,963,085  $    26,822,550  $       27,338,452  $       (624,633)
            VARIANCE                           $          2,176,479  $          (11,300) $     (2,229,003) $           395,152  $          406,452
             ASSIGNED
             RESERVE FUND BALANCE                          4,830,905            5,437,267          5,215,496             5,315,810           (121,456)
             UNASSIGNED FUND BALANCE                       1,676,663            1,059,001            (936,931)             (642,093)       (1,701,095)
            FUND BALANCE                       $          6,507,568  $        6,496,268  $      4,278,565  $        4,673,717  $    (1,822,551)



            RESERVE AND UNASSIGNED ANALYSIS
             % OF OPERATING EXPENDITURES               26.2%        23.2%        16.0%         17.1%
            TARGET % LEVEL                             19.4%        19.4%        19.4%         19.4%

             # OF DAYS OPERATING
            EXPENDITURES                                          94.29                 83.63                 57.42                  61.54
            TARGET # OF DAYS                                           70                      70                      70                       70


                                               Water and Wastewater Summary
                 30,000,000


                 25,000,000



                 20,000,000


                 15,000,000


                 10,000,000



                  5,000,000


                         -
                              FY 2017-18 Actual   FY 2018-19 Budget       FY 2018-19           FY 2019-20
                                                                           YE Proj.         Adopted Budget
                                     REVENUE TOTAL     EXPENDITURE TOTAL    FUND BALANCE



                                                             207
   204   205   206   207   208   209   210   211   212   213   214