Page 72 - CityofDalworthingtonGardensFY25AdoptedBudget
P. 72

180-PRFDC FUND SUMMARY




                                     BEGINNING FUND BALANCE                         581,220               675,759            678,595               659,648         659,648            716,510  Variance Calculations



                                                                                                                                                                      FY 23/24                   FY 24/25
                                                                                                                                     FY 23/24                         Actual +     Proposed Budget          FY 24/25
                                                                                                                       FY 23/24                    FY 24/25
                                                                                                                                                                                     Over/(Under)
                                                                         FY 20/21        FY 21/22       FY 22/23                      TOTAL                          Projected                         Proposed Budget
                                        REVENUE CATEGORY                                                              Amended                     Proposed
                                                                                                                                                                                    FY 23/24 Actual
                                                                          Actual          Actual         Actual                     Actual plus                     Over/(Under)                                  Over/(Under)
                                                                                                                        Budget                     Budget
                                                                                                                                     Projected                        FY 23/24                                   FY 23/24 Budget
                                                                                                                                                                                         plus
                                                                                                                                                                       Budget         Projected
                               Sales & Use Tax                                      139,042               148,169            144,026               151,083          129,239            129,217                    (21,844)                         (22)             (21,866)  -17%
                               Total Charges for Service                                     -                         -                   1,080                    1,500                 975                    975                          (525)                         -                   (525)  -54%


                               Other Revenue                                          28,411                    4,593              71,821                  22,100            28,351              24,000                        6,251                    (4,351)                 1,900  8%
                               Other Sources                                          20,777                       425              20,532                        -                   -                      -                            -                          -                      -

                                          TOTAL REVENUE                             188,229               153,188            237,459               174,683         158,565            154,192                    (16,118)                    (4,373)             (20,491)  -13%






                                                                                                                                                                      FY 23/24                   FY 24/25
                                                                                                                                     FY 23/24                         Actual +     Proposed Budget          FY 24/25
                                                                                                                       FY 23/24                    FY 24/25
                                                                                                                                                                                     Over/(Under)
                                                                         FY 20/21        FY 21/22       FY 22/23                      TOTAL                          Projected                         Proposed Budget
                                      EXPENDITURE CATEGORY                                                            Amended                     Proposed
                                                                                                                                                                                    FY 23/24 Actual
                                                                          Actual          Actual         Actual                     Actual plus                     Over/(Under)                                  Over/(Under)
                                                                                                                        Budget                     Budget
                                                                                                                                     Projected                        FY 23/24                                   FY 23/24 Budget
                                                                                                                                                                                         plus
                                                                                                                                                                       Budget         Projected
                               Personnel Salary & Wages                               30,841                  35,383              36,084                  53,527            36,297              55,295                    (17,231)                   18,998                 1,767  3%

                               Personnel Taxes & Benefits                               12,362                  16,585              17,388                  23,635            16,739              30,112                       (6,895)                   13,373                 6,478  22%
                               Training & Travel                                            165                        -                       86                       190                    14                    175                          (175)                         161                     (15)  -8%
                               Materials & Supplies                                      3,297                    4,700                 4,231                    6,255              6,004                 7,307                          (252)                     1,303                 1,052  14%
                               Utilities                                                 5,055                    6,870                 5,881                    7,237              6,114                 6,529                       (1,123)                         416                   (707)  -11%
                               Maintenance                                              12,579                  32,869              10,754                  16,446            15,710              11,606                          (736)                    (4,104)               (4,840)  -42%
                               Consultants                                               4,103                  39,415              30,965                    2,000              1,450              11,000                          (550)                     9,550                 9,000  82%
                               Contractual                                               5,538                    6,231                 5,935                    6,777              6,880                 8,151                           103                     1,270                 1,373  17%
                               Other Expenses                                            4,587                    8,299                 7,479                  13,415            12,496                 6,775                          (919)                    (5,721)               (6,640)  -98%

                               Capital Outlay                                         15,163                        -             137,603                        -                   -                 2,750                            -                      2,750                 2,750  100%

                               Other Uses                                                    -                         -                      -                         -                   -                      -                            -                          -                      -
                                        TOTAL EXPENDITURES                            93,690               150,352            256,406               129,482         101,703            139,700                    (27,779)                   37,997              10,218  7%


                                    REVENUE OVER EXPENDITURES                         94,539                    2,836             (18,947)                 45,201            56,862              14,492                       11,661                  (42,370)             (30,709)  -212%

                                       ENDING FUND BALANCE                          675,759               678,595            659,648               704,849         716,510            731,002
   67   68   69   70   71   72   73   74   75   76   77