Page 74 - Grapevine FY23 Adopted Budget (1)
P. 74

FY 2022-23 APPROVED OPERATING BUDGET
        STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE
        GENERAL FUND


                                                    2019-20      2020-21      2021-22      2021-22       2022-23
                                                    Actual       Actual       Budget       Estimate     Approved





        BEGINNING FUND BALANCE:                          13,705,470          11,574,295          11,582,854          11,582,854          20,897,283
        OPERATING REVENUE:
          Ad Valorem Taxes                               12,740,172            13,521,636            14,135,767          14,125,716          14,630,519





          Sales Taxes                                    25,758,869            28,590,889          29,147,580            35,092,347            33,400,000



          Mixed Beverage Taxes                             1,477,422            1,793,124              2,057,000            1,949,048            2,157,000

          Franchise Fees                                   6,216,567              5,858,497              6,216,567            5,823,151            6,025,000







          Licenses & Permits                               1,385,370            1,472,258            1,624,796            1,351,883            1,609,746






          Charges for Services                             7,848,563            8,199,050            9,294,760            7,677,525            9,747,281




          Intergovernmental                                   331,383            3,990,496                 344,094            3,544,210               344,094


          Fines and Forfeitures                            1,026,561               967,554              1,178,550            1,080,244            1,018,300


          Miscellaneous                                    1,680,104              2,261,365              1,066,800            3,580,083               959,600



          Total Operating Revenue                         58,465,011           66,654,869           65,065,914           74,224,207           69,891,540
        TRANSFERS IN:




          Admin. Fee - Utility Fund                        1,866,000            1,817,850            1,694,663            1,476,709              1,773,038



          Admin. Fee - CVB Fund                            1,455,526              1,213,537            1,255,274            1,096,429              1,549,798


          Admin. Fee - Golf Fund                                111,463               134,992                124,370               118,452               125,000

          Administrative Fee - SDUS Fund                      112,000               108,750                 107,775                   89,008               109,013



          Administrative Fee - 4B Fund                          306,000                 353,046                 281,509               354,013               313,875


          Transfers In - Special Revenue Fund                   27,374               244,134                       -                       -                       -




          Total Transfers In                               7,988,070              3,872,309            3,463,591            3,134,611              3,870,724




        TOTAL REVENUE AND TRANSFERS                      66,453,079          70,527,178          68,529,505            77,358,818            73,762,264
        OPERATING EXPENDITURES:



          Personnel                                      34,151,272          34,415,045          34,878,522          35,481,398          37,386,031



          Supplies                                         2,997,950             2,992,663              3,269,131            3,131,389              3,581,056




          Maintenance                                      1,228,508              1,487,167            1,569,428            1,599,781              2,357,226
          Services                                       13,341,686          12,878,971          12,521,093            13,727,314            13,570,905




          Capital Outlay                                        835,033                   85,576                 115,000                 606,327               149,500


          Insurance                                          9,021,298            8,675,693              9,603,341            7,566,440            10,557,971

          Total Operating Expenditures                   61,575,747          60,535,115          61,956,515          62,112,649          67,602,689




        TRANSFERS OUT:


          To Permanent Capital Maintenance                 3,279,000                       -            1,640,000            1,640,000            1,640,000


          To Capital Equipment Acquisition Fund               830,004                       -                       -                       -                       -



          To Crime Control & Prevention District Fund              3,406,824              5,513,302            4,291,740            4,291,740              4,519,575

          To Lake Parks Fund                                          -            4,463,346                       -                       -                       -
          Total Transfers Out                              7,515,828              9,983,504            5,931,740            5,931,740              6,159,575



        TOTAL EXPENDITURES AND TRANSFERS                 69,091,575          70,518,619          67,888,255          68,044,389          73,762,264






        SURPLUS (DEFICIT)                                 (2,638,497)                   8,559                 641,250            9,314,429                       -
        ENDING FUND BALANCE:                             11,574,295            11,582,854            12,224,104            20,897,283            20,897,283

        FUND BALANCE REQUIREMENT:                        12,315,149            12,107,023            12,391,303            12,422,530            13,520,538

        * Fund balance requirement is 20% of total budgeted expenditures (72 days of operation).
          The FY 2022-23 projected Ending Fund Balance represents 31% of total budgeted expenditures (113 days of operation).
                                                         74
   69   70   71   72   73   74   75   76   77   78   79