Page 76 - DWGFY24AdoptedBudget
P. 76

180-PRFDC FUND SUMMARY




                                    BEGINNING FUND BALANCE                         553,365               581,220               675,759               678,595         678,595            664,266  Variance Calculations


                                                                                                                                                                      FY 22/23                   FY 23/24
                                                                                                                                      FY 22/23                         Actual +     Proposed Budget          FY 23/24
                                                                                                                        FY 22/23                    FY 23/24
                                                                                                                                                                                     Over/(Under)
                                                                        FY 19/20        FY 20/21        FY 21/22                       TOTAL                          Projected                         Proposed Budget
                                        REVENUE CATEGORY                                                               Amended                     Proposed
                                                                         Actual          Actual          Actual                      Actual plus                    Over/(Under)                                  Over/(Under)
                                                                                                                                                                                    FY 22/23 Actual
                                                                                                                        Budget                      Budget
                                                                                                                                      Projected                       FY 22/23                                   FY 22/23 Budget
                                                                                                                                                                                          plus
                                                                                                                                                                       Budget          Projected
                              Sales & Use Tax                                      125,517               139,042               148,169               151,913         151,083            151,083                          (830)                             0                   (830)  -1%
                              Total Charges for Service                                     -                         -                         -                     1,500              1,500                 1,500                            -                            -                      -  0%
                              Other Revenue                                             8,451                 28,411                    4,593                    4,300            71,722              22,100                      67,422                  (49,622)              17,800  81%
                              Other Sources                                             2,667                 20,777                       425                        -             25,000                     -                      25,000                  (25,000)                     -
                                          TOTAL REVENUE                            136,634               188,229               153,188               157,713         249,305            174,683                       91,592                  (74,622)              16,970  10%






                                                                                                                                                                      FY 22/23                   FY 23/24
                                                                                                                                      FY 22/23                         Actual +     Proposed Budget          FY 23/24
                                                                                                                        FY 22/23                    FY 23/24
                                                                                                                                                                                     Over/(Under)
                                                                        FY 19/20        FY 20/21        FY 21/22                       TOTAL                          Projected                         Proposed Budget
                                     EXPENDITURE CATEGORY                                                              Amended                     Proposed
                                                                         Actual          Actual          Actual                      Actual plus                    Over/(Under)                                  Over/(Under)
                                                                                                                                                                                    FY 22/23 Actual
                                                                                                                        Budget                      Budget
                                                                                                                                                                                          plus
                                                                                                                                      Projected                       FY 22/23                                   FY 22/23 Budget
                                                                                                                                                                       Budget          Projected

                              Personnel Salary & Wages                               29,085                 30,841                 35,383                 40,264            35,833              53,527                      (4,431)                   17,694              13,263  25%
                              Personnel Taxes & Benefits                             14,100                 12,362                 16,585                 20,078            17,320              23,635                        (2,758)                     6,315                 3,556  15%
                              Training & Travel                                             -                        165                        -                        525                 261                    190                          (264)                          (72)                   (336)  -177%
                              Materials & Supplies                                         764                    3,297                    4,700                    4,270              4,738                 6,255                           468                     1,518                 1,985  32%
                              Utilities                                                 5,232                    5,055                    6,870                    7,722              6,681                 7,237                        (1,041)                         556                   (485)  -7%
                              Maintenance                                               4,151                 12,579                 32,869                 14,703              8,540              16,446                        (6,163)                     7,906                 1,743  11%
                              Consultants                                            28,597                    4,103                 39,415                 50,655            33,877                 2,000                    (16,778)                  (31,877)             (48,655)  -2433%
                              Contractual                                               3,207                    5,538                    6,231                    6,349              5,936                 6,777                          (413)                         842                    428  6%
                              Other Expenses                                            4,083                    4,587                    8,299                 10,140              8,378              13,415                        (1,762)                     5,037                 3,275  24%
                              Capital Outlay                                         19,560                 15,163                        -                  56,755         142,071                     -                      85,316                (142,071)             (56,755)
                              Other Uses                                                    -                         -                         -                         -                   -                      -                            -                            -                      -
                                       TOTAL EXPENDITURES                          108,779                 93,690               150,352               211,461         263,635            129,482                     52,174                (134,153)             (81,979)  -63%

                                   REVENUE OVER EXPENDITURES                         27,855                 94,539                    2,836                (53,748)          (14,330)              45,201                       39,418                   59,531              98,949  219%


                                      ENDING FUND BALANCE                          581,220               675,759               678,595               624,847         664,266            709,467
   71   72   73   74   75   76   77   78   79   80   81