Page 151 - Report
P. 151

Budget Worksheet Condensed                                                                                                                          For Fiscal: 2022-2023 Period Ending: 08/31/2023

                                                                                                                          2020-2021      2021-2022      2022-2023     2022-2023      2023-2024
                                                                                                                       Total Activity  Total Activity  Total Budget  YTD Activity    2023-2024

                         Fund: 900 - Utility Fund
                           Revenue
                             Department: 900 - Water/Sewer Department
                         900-900-4050-00                  Credit Card Processing Fee                                        3,004.25     19,987.80      19,200.00      17,216.33      19,200.00







                         900-900-4910-00                  Sewer Income                                                   551,720.94     490,873.58     528,000.00     441,435.50     528,000.00





                             Budget Detail
                             Budget Code               Description                                                      Units       Price         Amount
                             2023-2024                 Based on 3 year average                                          12.00  -44,000.00      -528,000.00

                         900-900-4930-00                  Water Income                                                   821,180.88     769,466.71     792,000.00     663,860.61     801,000.00






                             Budget Detail
                             Budget Code               Description                                                      Units       Price         Amount
                             2023-2024                 Based on 3 year average                                           1.00 -801,000.00      -801,000.00


                         900-900-4941-00                  Disconnect/Reconnect Fee                                          2,135.00     12,040.00       6,000.00       7,700.00       6,000.00






                         900-900-4943-00                  Late Fees                                                       20,669.49      39,583.79      37,800.00      18,326.66      20,400.00






                             Budget Detail
                             Budget Code               Description                                                      Units       Price         Amount
                             2023-2024                 Based on current activity                                        12.00   -1,700.00       -20,400.00

                         900-900-4944-00                  N Trinity Groundwater Conserv…                                  12,037.22      13,496.77      13,200.00      11,178.81      13,200.00











                         8/4/2023 11:06:01 AM                                                                                                                                                                  Page 67 of 116
                                                                                                                         9/18                                                          FY 2024 Adopted Budget
   146   147   148   149   150   151   152   153   154   155   156