Page 52 - DWGFY24AdoptedBudget
P. 52

120 - ENTERPRISE FUND                    2021-22               2022-23                OCT-JUN        JUL-SEP                  2022-23                         2023-24              Variance     Variance

                                                                                                                                                                                                                 FY 23/24     FY 23/24
                                                                                                                                                                                                   % Proposed   Proposed     Proposed
                                                                                                                                                               VARIANCE
                                                                                                                     9 months               3 months                         % of                  Budget    vs      Budget                     Budget
                                                                                        Original        Amended                                YTD Actual +   Actual + Projected        Proposed
                                                                        ACTUAL                                       Actual                        Projected               Amended                  FY 22/23       vs                                       s
                                                                                                                                                                                                                                v
                                                                                       Budget         Budget                                    Projected     vs Amended                Budget
                                                                                                                    Oct - Jun     Jul - Sep                                 Budget                 Actual plus               FY 22/23                  FY 22/23
                                                                                                                                                                Budget
                                                                                                                                                                                                    Projected                    Amended
                                                                                                                                                                                                                Actual +
                    Account Number  Account Description                                                                                                                                                         Projected     Budget
                    40.6205        Mat/Supplies: Legal Notices                                   -                            -                            -                               115                          -                            115                            115  0%                          -  0%                       (115)                        -


                    40.6215        Mat/Supplies: Office Supplies                                  44                               13                             13                                13                            1                               15                                   2  118%                            16  110%                             2                            4



                    40.6230        Mat/Supplies: Office Equipment                            2,051                               50                          175                              148                       664                            812                            637  464%                      1,050  129%                          238                        875



                    40.6235        Mat/Supplies: Records Mgmt                                    -                           400                          400                               -                       400                            400                               -  100%                         400  100%                         -                         -

                    40.6240        Mat/Supplies: Printing                                    4,525                         5,222                       5,222                          3,430                    1,806                         5,236                               14  100%                      4,752  91%                       (483)                      (469)
                    40.6245        Mat/Supplies: Postage                                     4,949                         5,580                       5,580                          3,983                    1,673                         5,656                               76  101%                      5,740  101%                           84                        160



                    40.6250        Mat/Supplies: Water Systems                                  959                       1,300                       1,300                               -                    1,300                         1,300                               -  100%                      1,300  100%                         -                         -

                    40.6275        Mat/Supplies: Equipment                                      303                            -                            -                                -                    2,112                           2,112                         2,112  0%                      2,000  95%                       (112)                    2,000
                    40.6276        Mat/Supplies: Furnishings                                    237                            -                            -                                -                          -                             -                               -    0%                          -  0%                         -                         -




                    40.6300        Mat/Supplies: Uniforms                                    2,223                       2,659                       2,659                          1,049                       917                         1,966                           (693)  74%                      2,524  128%                          558                      (136)

                    40.6315        Mat/Supplies: Other                                            70                           308                          308                                22                         143                            165                             (143)  54%                         157  95%                            (8)                      (151)

                    40.6350       Mat/Supplies: Fuel                                         4,314                         6,751                       6,751                          4,170                    2,295                         6,465                             (285)  96%                      7,052  109%                          587                        301

                    40.6400       Mat/Supplies: Tools & Supplies                             3,501                         1,303                       1,303                              606                    2,028                         2,634                         1,332  202%                      1,500  57%                    (1,134)                        198





                    40.6410       Mat/Supplies: Weed & Pest Control                               96                             98                             98                               -                         98                               98                               -  100%                         100  103%                             3                            3

                    40.6450        Mat/Supplies: Testing Supplies                            2,886                         7,500                       7,500                              888                    2,112                         3,000                        (4,500)  40%                      2,000  67%                    (1,000)                   (5,500)

                    40.6499        Mat/Supplies: Cost O/H Recovery                           5,616                       5,958                       5,958                          2,456                    2,751                         5,208                           (750)  87%                      5,809  112%                          602                      (149)



                    Total Materials & Supplies                       $                  31,774  $                 37,140  $                 37,265  $                    16,882                 18,300                       35,182  $                   (2,083)  94%  $               34,400  98%  $                  (782) $               (2,864)





                    40.6500        Utilities:Electricity                                  14,481                       16,595                     16,595                        11,651                    4,890                       16,541                             (54)  100%                    18,147  110%                     1,606                    1,552


                    40.6505        Utilities:Gas                                                109                           113                          113                                86                         11                               97                             (15)                         101  103%                             3                        (12)


                    40.6510        Utilities:Telephone                                          760                           300                          300                              246                         65                            310                               10  103%                         600  193%                          290                        300




                    40.6515        Utilities:Water & Sewer                                      133                           115                          115                              127                         25                            152                               37                         157  104%                             6                          43




                    40.6520        Utilities: Mobile Data                                    1,003                         1,092                       1,092                              678                       244                            922                           (170)  84%                         990  107%                           68                      (102)

                    40.6599        Utilities: Cost O/H Recovery                           10,754                     11,479                     11,479                          8,204                    3,371                       11,575                               96  101%                    12,263  106%                        688                        784


                    Total Utilities                                  $                    27,241  $                 29,694  $                 29,694  $                    20,992                   8,605                       29,597  $                         (96)  100%  $               32,259  109%  $                  2,661  $                2,565




                    40.6805        Maintenance:Vehicles                                      1,249                         1,887                       1,887                              567                    1,132                         1,698                             (189)  90%                      1,837  108%                          139                        (50)




                    40.6810        Maintenance:Blgs/Ground/Park                              2,906                       7,589                       7,349                                83                         47                            130                        (7,219)  2%                         313  241%                        183                   (7,036)


                    40.6825        Maintenance:Equipment                                        935                         5,300                       5,300                                46                    1,700                         1,746                        (3,554)  33%                      3,615  207%                     1,869                   (1,685)

                    40.6900        Maintenance:Water Tank                                    4,674                       7,825                       7,825                        19,790                    6,543                       26,333                       18,508  337%                      2,300  9%                 (24,033)                   (5,525)


                    40.6905        Maintenance:Water Pumps/Motors                            2,750                       7,000                       7,000                               -                    7,000                           7,000                               -  100%                      7,900  113%                          900                        900

                    40.6910        Maintenance:Water Distribution                         95,525                       62,000                     62,000                        54,132                   10,000                       64,132                         2,132  103%                    62,000  97%                    (2,132)                        -
                    40.6925        Maintenance:Sewer Collection                           44,014                     40,000                     40,000                        22,546                   13,454                       36,000                        (4,000)  90%                    40,000  111%                     4,000                        -


                    40.6999        Maintenance:Cost O/H Recovery                             1,911                       2,575                       2,575                              403                    1,100                         1,503                        (1,072)  58%                      2,122  141%                        619                      (453)





                    Total Maintenance                                $                153,964  $              134,176  $                133,936  $                    97,566                 40,976                    138,542  $                     4,606  103%  $              120,087  87%  $            (18,455) $             (13,849)



                    40.7015        Consultants:Legal-Regular                                 1,978                         1,605                       1,605                              691                    1,605                         2,296                            691  143%                      1,500  65%                       (796)                      (105)


                    40.7025        Consultants: Auditor                                      7,384                         7,400                       7,584                          7,584                          -                           7,584                               -  100%                      9,420  124%                     1,836                    1,836


                    40.7030        Consultants:Engineer-Regular                           34,675                       3,000                     32,565                          4,200                   28,365                       32,565                             -    100%                    33,000  101%                        435                        435
                    40.7095        Consultants:Other                                         2,082                            -                            -                                -                        -                               -                               -    0%                          -  0%                         -                         -

                    Total Consultants                                $                    46,119  $                 12,005  $                 41,754  $                    12,475                   29,970                       42,445  $                        691  102%  $               43,920  103%  $                1,475  $                2,166
   47   48   49   50   51   52   53   54   55   56   57