Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Documentation_Workshop_Tab 01_7/21/2022
Agenda Item #1. Workshop STAFF MEMO Meeting: Workshop - Jul 21 2022 Staff Contact: Jeremy Allen, Village Manager Department: Manager TITLE Discussion on Fiscal Year (FY) 2022-23 Proposed Budget. SUMMARY: Each year the Village of Tequesta is required to appropriate an annual expenditure budget and set a maximum ad valorem tax rate. The annual budget sets the fiscal year. Included in the packet is the draft budget for discussion Staff is recommending a millage tax rate to the Village Council of 6.6290. The millage rate of 6.6290 represents the same rate as the FY 2019-20, FY 2020-21, and FY 2021-22 budget year. As presented in the draft budget the estimated revenue and expenditures for the general fund is $16,058,248 which includes using American Rescue Plan (ARPA) Funding. Below you will find some budget highlights: General Fund Current Financial Condition and Reserves. Long-term General Fund balance target is two months or 17% of General Fund expenditures: FY 2021-22 the target is = $2,438,936. Projected Balance FY21 (9/30/21) = $5,322,838 including a significant portion of ARPA funds. Since 2019 Council and staff have worked to restore reserves to 17%. Estimated $2,883,902 above target by 9/30/22. (A significant portion of these reserves will be ARPA funds.) Continued with dedicated funding source and 5 year outlay plan for Capital Projects. Our AmericanRescueFunds mustbeusedfor general governmental operations. (Recommending one-time expenditures for majority of these monies). American Rescue Funds increases expenditures and target to estimated $3,008,236 from FY 2021-22 through FY 2023-24. Major Revenue Sources ($780,278 Net Increase over Adopted Budget FY 2021-22): No planned increase in millage rate. Property tax revenue up by 2.6% bringing total increase to 15.5% (a significant portion is due to new sales which resets the taxable value) - $207,667. Increased investment earnings - $102,000. Increased Recreation Center programs and fees to $61,000. Increase to Emergency Transports - $52,629. Expenditures ($780,278 Net Increase over Adopted Budget FY 2021-22): Budgeted Expenditures - $16,058,248. Budget Includes Funding for Modest Salary Increases. Page 3 of 79 Agenda Item #1. Employee Compensation to Date: o PBA Negotiations ongoing. o IAFF 3.00% Step/2% Cola. o CWA Negotiations ongoing. o Non-Union Recommending a 5% increase. Business Liaison and Special Events personnel (ARPA funded) - $85,000. Health Insurance Increase (Place holder until actual) - $200,000. Proposing new Firefighter Position Salaries and Equipment - $114,480. Debt Service: o Cost of Debt Service Recreation Ctr. $430,000 o Cost of Debt Service SAN Project $58,050. Capital Projects/Capital Purchases: o Includes Planned Funding two Fire Trucks with ARAP Funds $1.865 million. o Includes transfer to Stormwater Fund of $300,000 of American Rescue Plan funds for Stormwater improvements. o Total recommended transfer for road improvements for FY 2022-23 - $773,285. Estimated usage of American Rescue Plan funds - $2,250,588. Building Fund (Restricted) Budgeted Expenses $849,754. Modest Salary Increases. Increase in Health Insurance Costs. Full time Building Specialist. One Vehicle. Planned Usage of Reserves ~ $243K Enterprise Funds - Budgetary Highlights Water Utility Fund (Budget - $17,971,444): Fund 401 Overall increase of $4,467,298 in budget primarily due to Repair & Maintenance and upgrades to infrastructure including the Water Plant energy and resource improvements ($5.5 Million), Asbestos Cement Water Main (ACWM) Replacement Program ($5.3 Million). Borrowing $10,855,000 in Low Interest Debt from the Florida State Revolving Fund for Utilities. Rate is set at the time of actual borrowing for below market value. Planned utilization of Water Utility Reserves of $426K. Increase of 3.5% in water rates. Refuse & Recycling Fund (Budget - $530,010): Fund 402 Waste Management (WM) requests to exercise the extraordinary cost provision referenced in Citing steel needs for solid waste & Recycling have increased by more than 150%. Continuing labor shortages causing upward pressure on salaries. WM requesting to increase charges 13.6% which equates to $22.17/yr. for residential customer or $1.85/month. Stormwater Fund (Budget - $768,800): Fund 403 The budget has increased the prior year and is proposed to increase again for FY 2022-23 as the Village utilizes the America Rescue Plan Act (ARPA) for needed Stormwater Projects. $188,565 for FY 2021-22. $300,000 proposed for FY 2022-23. Page 4 of 79 Agenda Item #1. Proposing a 5% increase in Stormwater rates to continue the Repair & Maintenance planned programming. Planned Resiliency Study $95K. El Portal project, construction $300K. Planned Swale Restoration $26K. Planned Pipe Lining $53K. Planned Pipe Replacement $26K. Next Steps Village Council holds public hearings approving millage rate and budget. This document and any attachments may be reproduced upon request in an alternative format by completing our Accessibility Feedback Form, sending an e-mail to the Village Clerk or calling 561-768-0443. BUDGET INFORMATION: PROJECT NAME: N/A BUDGET: FY 2022-23 ENCUMBERED: 0 Proposed Proposed: Projected Remaining: 37,923,013 0 PROJECTED TOTAL: 0 POTENTIAL MOTION / DIRECTION REQUESTED: Tentatively approve the proposed budget. ATTACHMENTS: Budget Presentation 7-21-22 Final 2022.07.12 Budget Worksheet Page 5 of 79 Agenda Item #1. Budget Workshop -Fiscal Year 2022 Page 6 of 79 July 21, 2022 Agenda Item #1. Village of Tequesta Council Mayor Molly Young (Seat2), Vice-Mayor Kyle Stone (Seat 4), Frank D’Ambra (Seat 1), Laurie Brandon (Seat 3), Aaron Johnson (Seat 5) Vision Values We will preserve and enhance the unique character, •Excellence community spirit, small town Wevalueexcellenceinallthings.Professionalism,courtesy,accountability,andinnovationdriveour values and superior quality of commitmenttothedeliveryofexceptionalcustomerservices. life for allwho reside, visit and work in the Village of Tequesta. •Ethics and Transparency Wesethighstandardsandareresponsibleforourpersonal,professionalandorganizationalconductand Mission actwithintegrity.Weprovideopenaccess,encouragecommunityinvolvementandpromptlyrespondto The Village of Tequesta's requestsforinformation. mission is to protect the health, safety and well-being of the •Quality of Life community, provide Wevaluemaintainingasafe,family-friendlyandhealthyenvironmenttobuildourfutureandconduct exceptional,fiscally sound and business.Wefosterrecreation,publicsafety,youthactivitiesandeventsthatbenefittheentirecommunity. efficient customer service, uphold the public interest and •Employees advance the community vision. Werecognizethatourdiversestaffisinvaluableandweprovideaworkenvironmentthatemphasizes teamwork,respect,dignityandsupport.Weattractthebestrecruits,retaintop-levelemployeesandinvest intheirprofessionalgrowth. Page 7 of 79 Administration: Jeremy Allen-Village Manager, Merlene Reid-Risk Management/HR Director, Greg Corbitt-Leisure Services Director, Gus Medina-Police Chief, Brad Gomberg-IT Director, Jose Rodriguez-Building Official, Jeff Snyder-Finance Director, Lori McWilliams-Village Clerk, Open-Utilities Director, James Trube-Fire Chief, Nilsa Zacarias-Planning Director, Doug Chambers-Public Works Director, Debra Telfrin-Administrative Assistant Agenda Item #1. GeneralFund–FundisusedtofundVillageservicessuchasPolice, Fire,Parks,Planning,Finance,IT,Administration.Ad-valorem,State sharedrevenues,investmentinterestincome,salestaxesare examplesofrevenueforthisfund.TheGeneralFund’srevenues aretaxbased.TheMayorandCouncilcanutilizetheserevenuesfor programsandservicesinanyarea. Governmental BuildingFund–Fundedbybuildingandinspectionfees.Fundsand reservesmayonlybeusedtosupportthedeliveryofthosespecific Activities services.Maynotbeusedtosupportorsupplementtheotherfunds. CapitalImprovementFund-ThisfundisfundedbytheStateSales Surtaxintheamountestimatedof$474,893(Sunsets2024)andthe WaterUtilitytaxestimated$217,463.Thisfundisusedtoaccount forthemaintenanceandupkeepofTheVillage’sgeneralinfrastructure Page 8 of 79 (suchasroads,bridgesandsidewalks). 3 Agenda Item #1. CapitalProjectsFund–Toaccountforcapitalprojectswhichare fundedthroughGeneralFundrevenuesandotherfinancingsources fortheVillage’sinfrastructureincludingbuildings,parks,roads, bridges,etc. Governmental Activities SpecialLawEnforcementFund-Thisfundaccountsforforfeitures receivedbythePoliceDepartment.Theforfeituresmustbe (continued) expendedforcertainlawenforcementpurposesasprescribedby FloridaStateStatueChapter932.704 Page 9 of 79 4 Agenda Item #1. st Budget Changes from 1Workshop FY 2022-2023 General Fund Increase in Revenues -$217,387: Increase in Assessed Valuation (July 1 from June 1) Estimated Increase in Ad Valorem Tax Revenue -$207,667. Increase in Emergency Services –Palm Beach County Fire Rescue -$9,720. General Fund Increase in Expenditures -$217,387: Increase in Transfers to Capital Projects Fund -$207,667. Allocated Additional Amount to Reserves -$9,720. Page 10 of 79 5 Agenda Item #1. st Budget Changes from 1Workshop FY 2022-2023 Capital Projects Fund Increase in Revenues, Transfers -$207,667. Capital Project Fund Increase in Expenditures: Increase in Side Walk Construction Projects -$170,000. Increase in Beautification and Landscaping -$37,667. Water Utility Fund Increase in Sources of Revenue -$612,310: Fees for Services Increase in Revenues -$186,185. Page 11 of 79 Appropriation of Unrestricted Net Assets -$426,125. 6 Agenda Item #1. st Budget Changes from 1Workshop FY 2022-2023 Stormwater Fund Revenue Increase -$32,331: Fees for Services Increase in Revenues -$32,331. Stormwater Fund Expenditure Increase -$32,331: Increase in Funds for Increasing Reserves -$62,331. Decrease Amount Funded in FY 2021-22 for El Portal Expenses – ($30,000). Page 12 of 79 7 Agenda Item #1. Budget Summary –All Funds FY 2022 FY 2023 Expenditure Description$ Change % Change AdoptedProposed General Fund$15,277,970$16,058,248$780,278 5.1% Building Fund676,260849,754173,494 25.7% Capital Improvement Fund765,2601,218,122110,225 59.2% Capital Projects Fund342,000207,667(134,333) (39.3%) WaterUtility Fund12,937,35017,971,444 5,034,094 38.6% Refuse & Recycling Fund530,010601,97271,962 13.6% Page 13 of 79 Stormwater Utility Fund679,210916,099236,889 34.9% Special Law Enforcement Fund99,707-24,787 74,920 33.1% Total$31,282,980$37,923,013$6,640,033 21.2% Agenda Item #1. General Fund –Estimated Revenues $16,058,248 Misc. Other: $440,892 Administrative Fees, Rents/Royalties -$264,262 Misc. Other, $440,892 , 3% Charges for Services, $863,075 , 5% Investment earnings: $110,488 $1,597,386 , 10% Fines & Forfeitures -$18,877 Other Misc. -$13,699 Intergovernmental Contributions -$3,850 Revenue, $903,855 , 6% Impact Fees -$6,926 License & Permits -$1,000 Disposition of Assets -$21,790 Franchise Fees, General Property Taxes, $484,710 , 3% $9,401,670 , 59% Page 14 of 79 Other Taxes, $1,979,760 , 12% 10 Grant Funds, $386,900 , 2% Agenda Item #1. General Fund –Proposed Expenditures $16,058,248 Non-Operating Debt Service Salaries & Wages -$6,514,970 Expenditures4% 10% Capital Outlay 0% Employee Benefits -$3,260,895 Salaries & Wages Operating Expenditures - Operating 40% $4,127,093 Expenditures 26% Capital Outlay -$9,000 Employee Benefits Non-Operating -$1,554,890 20% Page 15 of 79 Debt Service -$591,400 11 Agenda Item #1. General Fund -Budget Summary by Department FY2022 FY2023 Percent Expenditure DescriptionDollar Change Adopted Proposed Change Council$77,350 $93,165$15,81520.5% Manager306,720319,62012,9004.2% Human Resources385,040409,68324,6436.4% 411,925 Village Clerk373,94037,98510.2% Finance715,220762,27847,0586.6% Legal190,000180,000(10,000)(5.3%) Comprehensive Planning281,540179,540(102,000)(36.2%) General Government314,310246,215(68,095)(21.7%) IT476,650481,9615,3111.1% Police Department3,558,3703,543,703(14,667)(0.4%) Code Compliance124,480104,925(19,555)(15.7%) Fire Control4,172,2954,519,2388.3% 346,943 Public Works1,546,9151,609,03362,1184.0% Page 16 of 79 Leisure Services942,0801,065,672123,59213.1% Debt Service886,280591,400(294,880)(33.3%) Interfund Transfers827,2601,215,353388,09346.9% Other Nonoperating99,520 324,537226.1% 314,817 Total$15,277,970$16,058,248$780,2785.1% Agenda Item #1. General Fund Budgetary Highlights FY 2022-23 Major Revenue Sources ($780,278 net increase over Adopted Budget FY 2021-22): No planned increase in millage rate. Property tax revenue up by 2.6% bringing total increase to 15.5% (a significant portion is due to new sales which resets the taxable value) -$207,667. Increased investment earnings -$102,000. Increased Recreation Center programs and fees to $61,000. Increase to Emergency Transports -$52,629. Page 17 of 79 13 Agenda Item #1. General Fund Budgetary Highlights FY 2022-23 Expenditures ($780,278 Net Increase over Adopted Budget FY 2021-22): Budget Includes Funding for Modest Salary Increases. Employee Compensation to Date: PBA –Negotiations ongoing. IAFF –3.00% Step/2% Cola. CWA –Negotiations ongoing. Non-Union –Recommending a 5% increase. Business Liaison and Special Events personnel -$85,000. Proposing new Firefighter Position–Salaries and Equipment -$114,480. Page 18 of 79 14 Agenda Item #1. General Fund Budgetary Highlights FY 2022-23 Expenditures -continued ($898,020 Net Increase over Adopted Budget FY 2021-22): Debt Service: Cost of Debt Service –Recreation Ctr. $430,000. Cost of Debt Service –SAN Project $58,050. Capital Projects/Capital Purchases: Includes Planned Funding two Fire Trucks with ARAP Funds $1.865 million. Includes transfer to Stormwater Fund of $300,000 of American Rescue Plan funds for Stormwater improvements. Total recommended transfer for road improvements for FY 23 -$773,285. Page 19 of 79 Estimated usage of American Rescue Plan funds -$2,250,588. 15 Agenda Item #1. General Fund Expenditure History FISCALYR Fiscal YearTOTAL CAPITAL OUTLAYDEBT SERVICEEMPLOYEE BENEFITS NON-OPERATING EXPOTHER OPERATING EXPPENSION BENEFITSSALARIES & WAGES 2015-16 ACTUAL$ 261,191 $ 534,896 $ 1,390,940 $ 367,800 $ 2,524,227 $ 475,327 $ 5,230,963 $10,785,344 2016-17 ACTUAL$ 346,226 $ 532,841 $ 1,503,847 $ 107,250 $ 2,989,873 $ 692,571 $ 5,502,582 $11,675,190 2017-18 ACTUAL$ 607,881 $ 504,100 $ 1,661,080 $ 740,100 $ 3,094,908 $ 830,060 $ 5,621,756 $13,059,885 2018-19 ACTUAL$ 256,601 $ 455,429 $ 1,825,064 $ 422,754 $ 2,988,611 $ 1,747,854 $ 6,039,301 $13,735,614 2019-20 ACTUAL$ 598,644 $ 475,029 $ 1,918,399 $ 281,500 $ 3,295,757 $ 916,450 $ 6,352,601 $13,838,380 2020-21 ACTUAL$ 541,300 $ 542,100 $ 1,941,500 $ 721,400 $ 3,554,000 $ 1,089,200 $ 6,346,900 $14,736,400 Page 20 of 79 2021-22 ADOPTEDBUDGET$ 308,260$ 886,280$ 1,834,560$ 941,780$ 4,041,560$ 990,050$ 6,275,480$ 15,277,970 16 2022-23 PROPOSEDBUDGET$ 9,000$ 591,400$ 2,110,585$ 1,554,890$ 4,127,093$ 992,225$ 6,673,055$ 16,058,248 Agenda Item #1. Millage Rate History – Last Ten Fiscal Years Millage Rate History 24.000025.0000 23.0000 20.0000 22.0000 15.0000 21.0000 10.0000 20.0000 Millage Rate 5.0000 19.0000 18.00000.0000 FY2013FY2014FY2015FY2016FY2017FY2018FY2019FY2020FY2021FY2022 Total Millage Rate 23.596621.592121.763021.549220.929320.443120.162221.025120.806420.6320 Page 21 of 79 Other Taxing Authorities 17.829515.542115.471015.257214.637314.151113.870214.396114.177414.003 Village of Tequesta 5.76716.05006.29206.29206.29206.29206.29206.62906.62906.6290 17 RankMunicipalityPopulationTotal Millage Agenda Item #1. Town of Palm Beach16.2251 19,253 Manalapan16.4980 2419 Highland Beach16.9509 34,300 Gulf Stream17.0009 4949 18 Hypoluxo17.1109 52,686 Cloud Lake17.3690 6136 Glenridge17.3690 7217 Boca Raton18.0570 898,046 County or Jupiter18.4236 61,121 9 Royal Palm Beach19.2890 1039,144 Juno Beach19.3847 Municipality Total 113,862 Ocean Ridge19.4109 121,828 Palm Beach Gardens19.4609 1359,755 Tax Rate and Jupiter Inlet Beach Colony19.5630 14403 Wellington19.8390 1561,768 Population Village of Golf19.8737 16257 Delray Beach20.1688 1766,948 Palm Beach County, FL Lantana20.2866 1811,579 Greenacres20.3109 1944,549 Loxahatchee Groves20.3690 3,379 20 North Palm Beach20.3785 2113,167 Palm Springs20.5860 2226,904 Tequesta20.6320 236,152 Palm Beach Shores20.6899 241,330 South Palm Beach20.8690 251,472 Boynton Beach21.2185 2681,011 Atlantis21.4409 272,145 West Palm Beach21.7468 28119,255 Riviera Beach21.7805 2938,125 Haverhill21.8690 302,193 Lake Park22.1340 319,039 Westlake22.4940 321,757 Page 22 of 79 Lake Worth23.3911 3342,572 Lake Clarke Shores23.6488 343,562 South Bay23.6779 354,924 Mangonia Park23.8109 362,142 Belle Glade23.9109 3716,893 Briny Breezes23.9109 38499 Pahokee23.9109 395,580 Agenda Item #1. General Fund – Fund Balance Projection DescriptionFY 2018FY 2019FY 2020FY2021*FY 2022* Expenditures less Capital11,711,90613,479,01013,286,37712,654,38114,633,936 Two Months’ Expenditures (reserves)1,951,9842,246,5022,214,3962,109,0642,438,936 Unassigned FundBalance at Year-end1,150,2291,479,0051,884,3044,356,8645,322,838 Amount Over/(Under) Reserve Target(801,755)(767,497)(330,092)2,247,8002,883,902 Page 23 of 79 *FY22amountprojected(asignificantportionoftheamountoverisARPAfundswhichmust bespentby2024)theupcomingbudgetproposesaddingapproximately$300,000toour 19 reserves. Agenda Item #1. Building Fund 101-$849,754 Budget includes funding for : Modest Salary Increases. Increase in Health Insurance Costs. Full time Building Specialist. One Vehicle. Planned Usage of Reserves ~ $243K Page 24 of 79 20 Agenda Item #1. Building Fund 101 Beginning Reserve Balance, 10/01/21$ 864,932 Estimated Cash Inflows: Projected Revenues 624,512 Estimated Cash Outflows: Projected Expenditures (778,969) Estimated Change in Fund Balance (154,457) Estimated Reserve Ending Balance, 9/30/22$ 710,475 Page 25 of 79 21 Agenda Item #1. Capital Improvement Fund 301-$1,218,122 Budget includes funding for : Repairs and maintenance for roads -$773,285. Sidewalk Improvements –Seabrook Rd from Tequesta Dr. -$75,000. Tree Canopy/Streetscaping-$75,000. Cardiac Monitors -$73,873. Traffic Pre-Emption Devices -$55,000. Air Compressor for Fire –$46,000. Page 26 of 79 Phone System -$120,000. 22 Agenda Item #1. Capital Improvement (Surtax Fund/Public Service Tax) – Fund 301 Beginning Reserve Balance, 10/01/21$ 353,291 Estimated Cash Inflows: Projected Revenues 693,900 Estimated Cash Outflows: Projected Expenditures (693,900) Estimated Change in Fund Balance - Estimated Reserve Ending Balance, 9/30/22$ 353,291 Page 27 of 79 23 Agenda Item #1. Capital Projects Fund 303 - $207,667 Budget includes funding for : Sidewalk Improvements –Tequesta Dr. From Tequesta Bridge - $85,000. Sidewalk Improvements –Tequesta Dr. From Seabrook to US 1- $85,000. Beautification Landscaping-$37,667. Page 28 of 79 24 Agenda Item #1. Capital Projects – Fund 303 Beginning Balance, 10/01/21$ 2,550,094 Estimated Cash Inflows: Projected Revenues 118,219 Estimated Cash Outflows: Projected Expenditures (2,549,888) Estimated Change in Fund Balance (2,431,669) Estimated Reserve Ending Balance, 9/30/22$ 118,425 Page 29 of 79 25 Agenda Item #1. Special Law Enforcement Fund 605 - $99,707 Budget includes funding for : Boat Dock -$35,000. Five Floating Marine Ballistic Vests -$22,500. Continued Accreditation Services -$25,000. Planned Reserve usage -$36,007. Page 30 of 79 26 Agenda Item #1. Special Law Enforcement Fund 605 Beginning Balance, 10/01/20$ 157,041 Estimated Cash Inflows: Projected Revenues 89,610 Estimated Cash Outflows: Projected Expenditures (171,488) Estimated Change in Fund Balance (81,878) Estimated Reserve Ending Balance, 9/30/21$ 75,163 Page 31 of 79 27 Agenda Item #1. Enterprise Funds –User fees for services support the following funds: Water Utility -This fund is used to account for the activities of the water utility. Fees are set to cover expenditures and future capital needs. Business -Type Stormwater Utility –Funded by user fees established on an equivalent residential unit (ERU) basis. ERU’s are calculated by Funds utilizing the total of the impervious surface for each parcel. All businesses, residential and multi-family dwelling units are charged a fee commensurate with the impact on the system. Refuse and Recycling -This fund is used to account for the fees charged for solid waste, yard waste and recyclable material Page 32 of 79 collection. 29 Agenda Item #1. Water Utility Fund 401 Water Utility Fund (Budget -$17,971,444): Overall increase of $4,467,298 in budget primarily due to Repair & Maintenance and upgrades to infrastructure including the Water Plant energy and resource improvements ($5.5 Million), Asbestos Cement Water Main (ACWM) Replacement Program ($5.3 Million). Borrowing $10,855,000 in Low Interest Debt from the Florida State Revolving Fund for Utilities. Rate is set at the time of actual borrowing for below market value. Planned utilization of Water Utility Reserves of $426K. Increase of 3.5% in water rates. Page 33 of 79 30 Agenda Item #1. Water Utility Fund 401 Highlights FY 2021-22 Asbestos Cement WaterMain (ACWM) Replacement Program Project Tequesta Drive & Country Club Drive (Construction continued). ACWM Replacement Program Project Beach RoadPhase 1 in process. WTP Equipment and SCADA Upgrades & Energy Improvements underway. Surficial Well Replacement Well #S18 and #S19 in process. Floridian Well Rehabilitations in process. Page 34 of 79 Concentrate DisposalRelocation for FDOT Federal Highway Bridge Relocation Project in process. 31 Agenda Item #1. Water Utility Fund 401 Beginning Unrestricted Net Position, 10/01/21$ 5,344,091 Estimated Cash Inflows: Projected Revenues 6,601,963 Estimated Cash Outflows: Projected Expenses (10,161,232) Estimated Change in Net Position (3,559,269) Est. Ending Unrestricted Net Position, 9/30/22$ 1,784,822 Page 35 of 79 32 Agenda Item #1. Refuse & Recycling Fund 402 Refuse & Recycling Fund (Budget -$601,972) Waste Management (WM) requests to exercise the extraordinary cost provision referenced in the Village’s Solid Waste Franchise Agreement. Citing steel needs for solid waste & Recycling have increased by more than 150%. Continuing labor shortages causing upward pressure on salaries. WM requesting to increase charges 13.6% which equates to $22.17/yr. for residential customer or $1.85/month. Page 36 of 79 33 Agenda Item #1. Refuse & Recycling Fund 402 Beginning Unrestricted Net Position, 10/01/21$ 114,832 Estimated Cash Inflows: Projected Revenues 503,182 Estimated Cash Outflows: Projected Expenses (529,407) Estimated Change in Net Position (26,225) Est. Ending Unrestricted Net Position, 9/30/22$ 88,607 Page 37 of 79 34 Agenda Item #1. Stormwater Fund 403 Stormwater Fund (Budget -$768,800) The budget has increased the prior year and is proposed to increase again for FY 2022-23 as the Village utilizes the America Rescue Plan Act (ARPA) for needed Stormwater Projects. $188,565 for FY 2021-22. $300,000 proposed for FY 2022-23. Proposing a 5% increase in Stormwater rates to continue the Repair & Maintenance planned programming. Planned Resiliency Study $95K. El Portal project, construction $300K. Page 38 of 79 Planned Swale Restoration $26K. Planned Pipe Lining $53K. 35 Planned Pipe Replacement $26K. Agenda Item #1. Stormwater Utility Fund 403 Highlights FY 2021-22 Stormwater Pipe Lining Projects: Country Club Circle. Tradewinds Circle. Leeward Circle. SwaleRestoration Program. Page 39 of 79 36 Agenda Item #1. Stormwater Utility – Fund 403 Beginning Unrestricted Net Position, 10/01/21$ (18,600) Estimated Cash Inflows: Projected Revenues 804,065 Estimated Cash Outflows: Projected Expenses (774,510) Estimated Change in Net Position 29,555 Est. Ending Unrestricted Net Position, 9/30/22$ 10,955 Page 40 of 79 37 Agenda Item #1. Questions Page 41 of 79 38 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 1 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE Fund 001 - GENERAL FUND ESTIMATED REVENUES Dept 000 - GENERAL GENERAL PROPERTY TAXES Revenue 001-000-311.000AD VALOREM TAXES - CURRENT7,494,9487,843,5378,158,0708,158,0708,259,906(101,836.00)1.018,181,6329,192,0039,399,6701,241,60015.22 001-000-311.100AD VALOREM TAXES-DEL2,1455,207001,032(1,032.00)0.001,0322,0002,0002,0000.00 TOTAL REVENUE7,497,0937,848,7448,158,0708,158,0708,260,938(102,868.00)1.018,182,6649,194,0039,401,6701,243,60015.24 GENERAL PROPERTY TAXES7,497,0937,848,7448,158,0708,158,0708,260,938(102,868.00)1.018,182,6649,194,0039,401,6701,243,60015.24 SALES & USE TAXES Revenue 001-000-312.510INSURANCE PREM TAX FIRE171,940193,278171,900171,9000171,900.000.00193,280193,280193,28021,38012.44 001-000-312.520INSURANCE PREMIUM TAX POLICE 91,37591,64991,30091,300091,300.000.0091,65091,84291,8425420.59 001-000-312.610LOCAL DISC. INFRASTRUCTURE S404,870473,106465,920465,920335,788130,132.000.72470,231474,893474,8938,9731.93 001-000-314.100UTILITY TAX-ELECTRICITY566,668566,653540,000540,000367,570172,430.000.68545,540568,037568,03728,0375.19 001-000-314.300UTILITY TAX-WATER46,485215,944217,000217,000154,51162,489.000.71194,077217,793217,7937930.37 001-000-314.400UTILITY TAX - NATURAL GAS2,0812,5383,0003,0001,8041,196.000.602,6122,4362,436(564)(18.80) 001-000-314.800UTILITY TAX-PROPANE30,03335,50332,00032,00031,677323.000.9946,11633,85033,8501,8505.78 001-000-315.000COMM.SERVICES TAX (CST)302,967302,744300,540300,540217,80582,735.000.72325,192307,429307,4296,8892.29 001-000-321.000LOCAL BUSINESS TAX79,55670,95078,00078,00076,3521,648.000.9874,03273,82773,827(4,173)(5.35) 001-000-321.010LOCAL BUSINESS TAX - COUNTY15,84214,52611,00011,0008,4612,539.000.7714,36016,37316,3735,37348.85 TOTAL REVENUE1,711,8171,966,8911,910,6601,910,6601,193,968716,692.006.181,957,0901,979,7601,979,76069,1003.62 SALES & USE TAXES1,711,8171,966,8911,910,6601,910,6601,193,968716,692.006.181,957,0901,979,7601,979,76069,1003.62 FRANCHISE FEES - GROSS RECEIPT Revenue 001-000-313.100FRAN FEES-ELECTRIC445,913506,492460,000460,000317,763142,237.000.69470,734482,580482,58022,5804.91 001-000-313.400FRAN FEES - NATURAL GAS1,7693,4712,0002,0002,761(761.00)1.382,7612,1302,1301306.50 TOTAL REVENUE447,682509,963462,000462,000320,524141,476.002.07473,495484,710484,71022,7104.92 FRANCHISE FEES - GROSS RECEIPT447,682509,963462,000462,000320,524141,476.002.07473,495484,710484,71022,7104.92 LICENSES & PERMITS Revenue 001-000-329.020SPECIAL EVENT PERMITS6801,0501,0001,00099010.000.991,0006201,00000.00 TOTAL REVENUE6801,0501,0001,00099010.000.991,0006201,00000.00 LICENSES & PERMITS6801,0501,0001,00099010.000.991,0006201,00000.00 GRANTS FEDERAL Revenue 001-000-331.200FED GRANT - COVID-190127,5840000.000.0000000.00 001-000-331.211FED GRANT - ARPA FUNDS01,537,1200000.000.0000000.00 001-000-331.211-9FED GRANT - ARPA FUNDS0001,145,23001,145,230.000.001,537,12000(1,145,230)(100.00) Page 42 of 79 TOTAL REVENUE01,664,70401,145,23001,145,230.000.001,537,12000(1,145,230)(100.00) GRANTS FEDERAL01,664,70401,145,23001,145,230.000.001,537,12000(1,145,230)(100.00) GRANTS - STATE Revenue 001-000-334.207FMIT MATCING SAFETY GRANT02,01000183(183.00)0.001,0001,0001,0001,0000.00 TOTAL REVENUE02,01000183(183.00)0.001,0001,0001,0001,0000.00 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 2 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE GRANTS - STATE02,01000183(183.00)0.001,0001,0001,0001,0000.00 INTERGOVERNMENTAL REVENUE Revenue 001-000-335.120MUNICIPAL REVENUE SHARING PR181,679196,984208,080208,080143,54964,531.000.69191,398195,651195,651(12,429)(5.97) 001-000-335.150ALCOHOLIC BEVERAGE LICENSES10,80610,98112,00012,0007,7514,249.000.6510,39711,57811,578(422)(3.52) 001-000-335.180LOC GOV 1/2 CENT SALES TAX PR439,536511,046494,670494,670409,04585,625.000.83499,936503,891503,8919,2211.86 001-000-338.101LOCAL GAS TAX-6 CENT120,507125,214126,780126,78088,25238,528.000.70120,784125,180125,180(1,600)(1.26) 001-000-338.102LOCAL GAS TAX 1-5 CENT55,41157,01858,43058,43040,36718,063.000.6957,38260,50960,5092,0793.56 TOTAL REVENUE807,939901,243899,960899,960688,964210,996.003.55879,897896,809896,809(3,151)(0.35) INTERGOVERNMENTAL REVENUE807,939901,243899,960899,960688,964210,996.003.55879,897896,809896,809(3,151)(0.35) CHGS FOR SERV - GEN GOV Revenue 001-000-341.101CERTIFICATION/COPY FEES38,18664,25635,50035,50035,46040.001.0046,96638,13338,1332,6337.42 001-000-341.103ELECTION QUALIFYING FEES90900090(90.00)0.00900000.00 001-000-341.105ADMIN FEES FROM OTHER GOV'TS1,15100000.000.0000000.00 TOTAL REVENUE39,42764,34635,50035,50035,550(50.00)1.0047,05638,13338,1332,6337.42 CHGS FOR SERV - GEN GOV39,42764,34635,50035,50035,550(50.00)1.0047,05638,13338,1332,6337.42 INTRAGOVERNMENTAL REVENUE Revenue 001-000-341.180ADMIN MGMT FEES-BUILDING104,100100,002106,010106,010106,013(3.00)1.00106,013107,655107,6551,6451.55 001-000-341.401ADMIN MGMT FEES-WATER598,596836,872655,200655,200655,209(9.00)1.00655,209657,362657,3622,1620.33 001-000-341.402ADMIN MGMT FEE-REF & RECYCLI8,4488,5508,7008,7008,707(7.00)1.008,7069,6729,67297211.17 001-000-341.403ADMIN MGMT FEES - STORM WATE14,29285,87386,40086,40086,413(13.00)1.0086,41288,38588,3851,9852.30 TOTAL REVENUE725,4361,031,297856,310856,310856,342(32.00)4.00856,340863,074863,0746,7640.79 INTRAGOVERNMENTAL REVENUE725,4361,031,297856,310856,310856,342(32.00)4.00856,340863,074863,0746,7640.79 RENTS & ROYALTIES Revenue 001-000-362.110LEASE - SPRINT43,11144,80945,73045,73040,4705,260.000.8848,56450,11850,1184,3889.60 001-000-362.112LEASE-T-MOBILE64,28466,85569,53069,53052,01617,514.000.7569,53072,31072,3102,7804.00 001-000-362.116LEASE - AT&T30,46630,92331,37031,37026,1425,228.000.8331,37031,85831,8584881.56 001-000-362.117VERIZON-901 OLD DIXIE44,09245,85547,69047,69035,53012,160.000.7547,68849,59749,5971,9074.00 001-000-362.118VERIZON-136 BRIDGE RD32,39932,88533,37033,37024,9718,399.000.7533,37833,87933,8795091.53 TOTAL REVENUE214,352221,327227,690227,690179,12948,561.003.96230,530237,762237,76210,0724.42 RENTS & ROYALTIES214,352221,327227,690227,690179,12948,561.003.96230,530237,762237,76210,0724.42 CONTRIBUTIONS & DONATIONS Revenue 001-000-366.100CONTRIB & DONATIONS & SPONSO00002,850(2,850.00)0.002,8502,8502,8502,8500.00 TOTAL REVENUE00002,850(2,850.00)0.002,8502,8502,8502,8500.00 Page 43 of 79 CONTRIBUTIONS & DONATIONS00002,850(2,850.00)0.002,8502,8502,8502,8500.00 MISCELLANEOUS REVENUES Revenue 001-000-369.000OTHER MISCELLANEOUS REVENU8,6895,7765,0005,0001,1043,896.000.221,8735,7715,77177115.42 001-000-369.100INSURANCE REIMBURSEMENT6,0716,1755,0005,00005,000.000.002,2004,5934,593(407)(8.14) TOTAL REVENUE14,76011,95110,00010,0001,1048,896.000.224,07310,36410,3643643.64 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 3 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE MISCELLANEOUS REVENUES14,76011,95110,00010,0001,1048,896.000.224,07310,36410,3643643.64 Totals for dept 000 - GENERAL11,459,18614,223,52612,561,19013,706,42011,540,5422,165,878.0022.9814,173,11513,709,08513,917,132210,7121.54 Dept 150 - COMPREHENSIVE PLANNING CHGS FOR SERV - GEN GOV Revenue 001-150-341.150LAND DEVELOPMENT FEES170,789581,821160,000168,500347,488(178,988.00)2.06375,610168,500168,50000.00 TOTAL REVENUE170,789581,821160,000168,500347,488(178,988.00)2.06375,610168,500168,50000.00 CHGS FOR SERV - GEN GOV170,789581,821160,000168,500347,488(178,988.00)2.06375,610168,500168,50000.00 Totals for dept 150 - COMPREHENSIVE PLANNING170,789581,821160,000168,500347,488(178,988.00)2.06375,610168,500168,50000.00 Dept 171 - POLICE GRANTS FEDERAL Revenue 001-171-331.210FEDERAL GRANT049,96320,40020,40048,494(28,094.00)2.3845,21623,90023,9003,50017.16 TOTAL REVENUE049,96320,40020,40048,494(28,094.00)2.3845,21623,90023,9003,50017.16 GRANTS FEDERAL049,96320,40020,40048,494(28,094.00)2.3845,21623,90023,9003,50017.16 GRANTS - STATE Revenue 001-171-334.207FMIT MATCING SAFETY GRANT94200000.000.0000000.00 TOTAL REVENUE94200000.000.0000000.00 GRANTS - STATE94200000.000.0000000.00 INTERGOVERNMENTAL REVENUE Revenue 001-171-338.202PBC 911 DISPATCH WAGES REIMB1,29900000.000.0000000.00 TOTAL REVENUE1,29900000.000.0000000.00 INTERGOVERNMENTAL REVENUE1,29900000.000.0000000.00 MISCELLANEOUS REVENUES Revenue 001-171-369.000OTHER MISCELLANEOUS REVENU79415,8021,2801,280561719.000.441,2801,2001,200(80)(6.25) TOTAL REVENUE79415,8021,2801,280561719.000.441,2801,2001,200(80)(6.25) MISCELLANEOUS REVENUES79415,8021,2801,280561719.000.441,2801,2001,200(80)(6.25) CHGS FOR SERV - PUBLIC SAFETY Revenue 001-171-342.110PBC - MARINE LAW ENFORCE. SER18,66018,46016,66018,7509,0139,737.000.489,01316,66016,660(2,090)(11.15) 001-171-342.120BLM - LAW ENFORCEMENT SERVIC7,45528,74536,50036,50016,21020,290.000.4436,50036,50036,50000.00 TOTAL REVENUE26,11547,20553,16055,25025,22330,027.000.9245,51353,16053,160(2,090)(3.78) Page 44 of 79 CHGS FOR SERV - PUBLIC SAFETY26,11547,20553,16055,25025,22330,027.000.9245,51353,16053,160(2,090)(3.78) FINES & FORFEITURES Revenue 001-171-351.100COURT FINES4,0545,1915,5005,5004,572928.000.836,3265,8305,8303306.00 001-171-351.250$12.50 TRAFFIC VIOLATION FUND2,4961,5762,5002,5001,675825.000.671,6752,3142,314(186)(7.44) 001-171-354.101LOCAL ORDINANCE VIOLATION8301,29550050060440.000.122755665666613.20 TOTAL REVENUE7,3808,0628,5008,5006,3072,193.001.628,2768,7108,7102102.47 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 4 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE FINES & FORFEITURES7,3808,0628,5008,5006,3072,193.001.628,2768,7108,7102102.47 IMPACT FEES Revenue 001-171-362.221POLICE IMPACT FEES1,5233,1045005004,525(4,025.00)9.054,52550050000.00 TOTAL REVENUE1,5233,1045005004,525(4,025.00)9.054,52550050000.00 IMPACT FEES1,5233,1045005004,525(4,025.00)9.054,52550050000.00 Totals for dept 171 - POLICE38,053124,13683,84085,93085,110820.0014.41104,81087,47087,4701,5401.79 Dept 181 - CODE COMPLIANCE CHGS FOR SERV - PUBLIC SAFETY Revenue 001-181-342.181CODE ENF - EXTRA DUTY0020,00020,00020,0000.001.0020,00020,00020,00000.00 TOTAL REVENUE0020,00020,00020,0000.001.0020,00020,00020,00000.00 CHGS FOR SERV - PUBLIC SAFETY0020,00020,00020,0000.001.0020,00020,00020,00000.00 FINES & FORFEITURES Revenue 001-181-354.102CODE ENF FINES & COURT COSTS4,32814,74410,00010,0007,3512,649.000.749,12210,16710,1671671.67 TOTAL REVENUE4,32814,74410,00010,0007,3512,649.000.749,12210,16710,1671671.67 FINES & FORFEITURES4,32814,74410,00010,0007,3512,649.000.749,12210,16710,1671671.67 Totals for dept 181 - CODE COMPLIANCE4,32814,74430,00030,00027,3512,649.001.7429,12230,16730,1671670.56 Dept 192 - FIRE CONTROL GRANTS FEDERAL Revenue 001-192-331.200FED GRANT - COVID-199,37800000.000.0000000.00 001-192-331.201FEDERAL GRANT P/S - HURRICANE82,68500000.000.0000000.00 TOTAL REVENUE92,06300000.000.0000000.00 GRANTS FEDERAL92,06300000.000.0000000.00 GRANTS - STATE Revenue 001-192-334.207FMIT MATCING SAFETY GRANT3,29300000.000.0000000.00 001-192-337.201LOCAL GOVERNMENT GRANT PBC013,60512,00020,67512,1028,573.000.5920,77612,00012,000(8,675)(41.96) TOTAL REVENUE3,29313,60512,00020,67512,1028,573.000.5920,77612,00012,000(8,675)(41.96) GRANTS - STATE3,29313,60512,00020,67512,1028,573.000.5920,77612,00012,000(8,675)(41.96) INTERGOVERNMENTAL REVENUE Revenue 001-192-335.201FIRE INCENTIVE PAY6,6307,8027,3607,3604,7412,619.000.646,4277,0467,046(314)(4.27) Page 45 of 79 TOTAL REVENUE6,6307,8027,3607,3604,7412,619.000.646,4277,0467,046(314)(4.27) INTERGOVERNMENTAL REVENUE6,6307,8027,3607,3604,7412,619.000.646,4277,0467,046(314)(4.27) CONTRIBUTIONS & DONATIONS Revenue 001-192-366.100CONTRIB & DONATIONS & SPONSO01000000.000.0000000.00 TOTAL REVENUE01000000.000.0000000.00 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 5 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE CONTRIBUTIONS & DONATIONS01000000.000.0000000.00 MISCELLANEOUS REVENUES Revenue 001-192-365.102FIRE DEPT SALES21313715015048102.000.3215015015000.00 001-192-369.000OTHER MISCELLANEOUS REVENU6301,126003,938(3,938.00)0.001,5371,9851,9851,9850.00 TOTAL REVENUE8431,2631501503,986(3,836.00)0.321,6872,1352,1351,9851,323.33 MISCELLANEOUS REVENUES8431,2631501503,986(3,836.00)0.321,6872,1352,1351,9851,323.33 CHGS FOR SERV - PUBLIC SAFETY Revenue 001-192-342.192FIRE - EXTRA DUTY2,2909102,0002,0002,335(335.00)1.172,1062,6072,60760730.35 001-192-342.201FIRE PLAN REVIEW FEES35,891178,03835,00035,00022,89012,110.000.6516,85024,08724,087(10,913)(31.18) 001-192-342.202FIRE INSPECTIONS29,53731,03627,00027,00020,0326,968.000.7428,52228,25128,2511,2514.63 001-192-342.401EMERGENCY SERVICE-JIC432,640449,946467,940467,940350,958116,982.000.75467,942478,646478,64610,7062.29 001-192-342.402FIRE RESCUE-CPR PROGRAM225562400400520(120.00)1.3054858358318345.75 001-192-342.410EMERGENCY SVC- PBC FIRE RESC296,297301,690310,070310,070277,93132,139.000.90310,070310,070319,7909,7203.13 001-192-342.600EMS TRANSPORTATION FEES331,433420,829350,000350,000225,924124,076.000.65324,963402,629402,62952,62915.04 TOTAL REVENUE1,128,3131,383,0111,192,4101,192,410900,590291,820.006.161,151,0011,246,8731,256,59364,1835.38 CHGS FOR SERV - PUBLIC SAFETY1,128,3131,383,0111,192,4101,192,410900,590291,820.006.161,151,0011,246,8731,256,59364,1835.38 IMPACT FEES Revenue 001-192-362.222FIRE IMPACT FEES1,1944,0911,0001,0003,423(2,423.00)3.423,4231,5701,57057057.00 TOTAL REVENUE1,1944,0911,0001,0003,423(2,423.00)3.423,4231,5701,57057057.00 IMPACT FEES1,1944,0911,0001,0003,423(2,423.00)3.423,4231,5701,57057057.00 Totals for dept 192 - FIRE CONTROL1,232,3361,409,8721,212,9201,221,595924,842296,753.0011.131,183,3141,269,6241,279,34457,7494.73 Dept 231 - LEISURE SERVICES GRANTS - STATE Revenue 001-231-334.205STATE DEP GRANT - (FRDAP)000000.000.00050,00050,00050,0000.00 TOTAL REVENUE000000.000.00050,00050,00050,0000.00 GRANTS - STATE000000.000.00050,00050,00050,0000.00 RENTS & ROYALTIES Revenue 001-231-362.100RENTAL - FACILITIES4,5795,67827,50027,50018,0159,485.000.6619,00025,50025,500(2,000)(7.27) 001-231-362.109RENTALS - MARTIN COUNTY00001,810(1,810.00)0.002,0001,0001,0001,0000.00 TOTAL REVENUE4,5795,67827,50027,50019,8257,675.000.6621,00026,50026,500(1,000)(3.64) RENTS & ROYALTIES4,5795,67827,50027,50019,8257,675.000.6621,00026,50026,500(1,000)(3.64) Page 46 of 79 CONTRIBUTIONS & DONATIONS Revenue 001-231-366.100CONTRIB & DONATIONS & SPONSO5,50002,0002,0005001,500.000.255002,0001,000(1,000)(50.00) TOTAL REVENUE5,50002,0002,0005001,500.000.255002,0001,000(1,000)(50.00) CONTRIBUTIONS & DONATIONS5,50002,0002,0005001,500.000.255002,0001,000(1,000)(50.00) MISCELLANEOUS REVENUES 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 6 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE Revenue 001-231-365.110CONCESSION SALES008008000800.000.00000(800)(100.00) TOTAL REVENUE008008000800.000.00000(800)(100.00) MISCELLANEOUS REVENUES008008000800.000.00000(800)(100.00) IMPACT FEES Revenue 001-231-363.271PARKS AND REC IMPACT FEES82718,738001,654(1,654.00)0.002,8334,8564,8564,8560.00 TOTAL REVENUE82718,738001,654(1,654.00)0.002,8334,8564,8564,8560.00 IMPACT FEES82718,738001,654(1,654.00)0.002,8334,8564,8564,8560.00 CHARGES FOR SERVICES - RECR. Revenue 001-231-347.100TEQUESTA FEST10,576010,00010,000010,000.000.00010,00010,00000.00 001-231-347.190SPECIAL EVENTS - OTHER3,41103,0003,00003,000.000.0003,0003,00000.00 001-231-347.201WINTER/SUMMER CAMP FEES04,3208,0008,00008,000.000.00000(8,000)(100.00) 001-231-347.205RECREATION PROGRAMS FEES8,8361,25525,19025,1904,04521,145.000.1617,00040,00040,00014,81058.79 001-231-347.250OTHER FEES 00002,751(2,751.00)0.004,0008,0008,0008,0000.00 TOTAL REVENUE22,8235,57546,19046,1906,79639,394.000.1621,00061,00061,00014,81032.06 CHARGES FOR SERVICES - RECR.22,8235,57546,19046,1906,79639,394.000.1621,00061,00061,00014,81032.06 Totals for dept 231 - LEISURE SERVICES33,72929,99176,49076,49028,77547,715.001.0745,333144,356143,35666,86687.42 Dept 900 - INTERFUND TRANSFERS TRANSFERS IN Revenue 001-900-381.101TRANSFER FROM BLDNG195,37810,1030000.000.0000000.00 001-900-381.401TRSF FROM WATER FUND021,8910000.000.0000000.00 TOTAL REVENUE195,37831,9940000.000.0000000.00 TRANSFERS IN195,37831,9940000.000.0000000.00 Totals for dept 900 - INTERFUND TRANSFERS195,37831,9940000.000.0000000.00 Dept 910 - OTHER FINANCING SOURCES & USES OTHER FINANCING SOURCES Revenue 001-910-383.100CAPITAL LEASE AT INCEPTION105,305318,62301,865,58801,865,588.000.00000(1,865,588)(100.00) TOTAL REVENUE105,305318,62301,865,58801,865,588.000.00000(1,865,588)(100.00) OTHER FINANCING SOURCES105,305318,62301,865,58801,865,588.000.00000(1,865,588)(100.00) Totals for dept 910 - OTHER FINANCING SOURCES & 105,305318,62301,865,58801,865,588.000.00000(1,865,588)(100.00) Dept 950 - OTHER NONOPERATING OTHER FINANCING SOURCES Page 47 of 79 Revenue 001-950-364.100DISPOSITION/SALE OF ASSETS21,97626,52500972(972.00)0.001,93021,79121,79121,7910.00 TOTAL REVENUE21,97626,52500972(972.00)0.001,93021,79121,79121,7910.00 OTHER FINANCING SOURCES21,97626,52500972(972.00)0.001,93021,79121,79121,7910.00 UNRESTRICTED INVESTMENT EARNIN Revenue 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 7 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE 001-950-361.100INTEREST/INVESTMENT EARNINGS46,5497,0628,3008,30011,418(3,118.00)1.3822,12953,781110,000101,7001,225.30 001-950-361.101PBC TAX COL-INTEREST ON DEP1,5164880000.000.004884884884880.00 001-950-367.100NET UNREAL APPRECIATION (DEP00006,465(6,465.00)0.0000000.00 TOTAL REVENUE48,0657,5508,3008,30017,883(9,583.00)1.3822,61754,269110,488102,1881,231.18 UNRESTRICTED INVESTMENT EARNIN48,0657,5508,3008,30017,883(9,583.00)1.3822,61754,269110,488102,1881,231.18 Totals for dept 950 - OTHER NONOPERATING70,04134,0758,3008,30018,855(10,555.00)1.3824,54776,060132,279123,9791,493.72 Dept 990 - OTHER/RESERVE/CONTINGENCY OTHER FINANCING SOURCES Revenue 001-990-399.994APPROPRIATE FB - ARPA FUNDS001,145,230000.000.0000300,000300,0000.00 001-990-399.999APPROPRIATE FUND BALANCE00094,275094,275.000.00000(94,275)(100.00) TOTAL REVENUE001,145,23094,275094,275.000.0000300,000205,725218.22 OTHER FINANCING SOURCES001,145,23094,275094,275.000.0000300,000205,725218.22 Totals for dept 990 - OTHER/RESERVE/CONTINGEN001,145,23094,275094,275.000.0000300,000205,725218.22 TOTAL ESTIMATED REVENUES13,309,14516,768,78215,277,97017,257,09812,972,9634,284,135.0054.7615,935,85115,485,26216,058,248(1,198,850)(6.95) APPROPRIATIONS Dept 100 - COUNCIL OPERATING EXPENDITURES/EXPENSE Expenditure 001-100-531.311COUNCIL FEES - SEAT 1 - D'AMBR 7,7177,8718,0508,0506,6781,372.000.838,0308,2008,2001501.86 001-100-531.313COUNCIL FEES - SEAT 4 - STONE7,7177,8718,0508,0506,6781,372.000.838,0308,2008,2001501.86 001-100-531.314COUNCIL FEES - SEAT 5 - JOHNSO7,7177,8718,0508,0506,7781,272.000.848,0308,2008,2001501.86 001-100-531.316COUNCIL FEES - SEAT 3 - BRANDO7,7177,8718,0508,0506,6781,372.000.838,0308,2008,2001501.86 001-100-531.317COUNCIL FEES - SEAT 2 - YOUNG7,7177,9088,0508,0506,6781,372.000.838,0308,2008,2001501.86 001-100-540.301COUNCIL EXPENSES - SEAT 1 - D'A1,5272,2973,0003,0002,276724.000.763,0003,0003,00000.00 001-100-540.301-0COUNCIL EXPENSES - SEAT 1 - EN3700000.000.0000000.00 001-100-540.304COUNCIL EXPENSES - SEAT 5 - JO1,4431,9333,0003,0003562,644.000.123,0003,0003,00000.00 001-100-540.306COUNCIL EXPENSES - SEAT 3 - BR6612003,0003,0001,1761,824.000.393,0003,0003,00000.00 001-100-540.307COUNCIL EXPENSES - SEAT 2 - YO1,4641,3653,0003,0001,3361,664.000.453,0003,0003,00000.00 001-100-540.308COUNCIL EXPENSES - SEAT 4 - ST6591,9333,0003,00003,000.000.003,0003,0003,00000.00 001-100-540.309MAYORAL DUTIES01,3292,5002,5007111,789.000.282,0002,5002,50000.00 001-100-546.320COMPUTER SYSTEM MAINT & SUP01,58812,50012,5008,5773,923.000.6912,50025,80025,80013,300106.40 001-100-549.300OTHER MISC CHGS & OBLIGATION7476961,4001,4002861,114.000.201,0001,0001,000(400)(28.57) 001-100-549.350VOLUNTEER APPRECIATION1,20702,0002,0002,157(157.00)1.082,8004,0004,0002,000100.00 001-100-554.300BOOKS, PUBL, SUBS & MEMBERSH3,1803,1373,7003,7003,137563.000.853,5373,8653,8651654.46 TOTAL EXPENDITURE49,51053,87077,35077,35053,50223,848.008.9876,98793,16593,16515,81520.45 OPERATING EXPENDITURES/EXPENSE49,51053,87077,35077,35053,50223,848.008.9876,98793,16593,16515,81520.45 CAPITAL OUTLAY Expenditure Page 48 of 79 001-100-664.601COMPUTER EQUIPMENT2,32700000.000.0000000.00 TOTAL EXPENDITURE2,32700000.000.0000000.00 CAPITAL OUTLAY2,32700000.000.0000000.00 Totals for dept 100 - COUNCIL51,83753,87077,35077,35053,50223,848.008.9876,98793,16593,16515,81520.45 Dept 110 - MANAGER 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 8 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE OPERATING EXPENDITURES/EXPENSE Expenditure 001-110-540.300TRAVEL & PER DIEM1,6539236,0006,0009945,006.000.176,0006,0006,00000.00 001-110-541.300COMMUNICATION SERVICES001,2001,200721479.000.601,0501,2001,20000.00 001-110-546.320COMPUTER SYSTEM MAINT & SUP63302,5002,5005541,946.000.222,5002,7002,7002008.00 001-110-549.300OTHER MISC CHGS & OBLIGATION204280000.000.0000000.00 001-110-554.300BOOKS, PUBL, SUBS & MEMBERSH1,8871,9392,1402,1401,612528.000.751,6122,1402,14000.00 001-110-554.301PERSONNEL TRAINING7682,3581,6001,600929671.000.581,6001,6001,60000.00 TOTAL EXPENDITURE4,3915,67813,44013,4404,8108,630.002.3212,76213,64013,6402001.49 OPERATING EXPENDITURES/EXPENSE4,3915,67813,44013,4404,8108,630.002.3212,76213,64013,6402001.49 PERSONAL SERVICES Expenditure 001-110-512.100REGULAR SALARIES & WAGES201,769207,964219,030219,030163,86855,162.000.75218,214232,200229,98010,9505.00 001-110-515.103BONUS PAY PLAN10,2508,0261,2501,2501,2500.001.001,2501,2501,25000.00 001-110-515.107PART-TIME SALARIES7200000.000.0000000.00 001-110-515.108AUTO ALLOWANCE3,9003,6005,4005,4004,2751,125.000.795,4005,4005,40000.00 001-110-516.100COMPENSATED ABSENCES1,5281,5742,5002,5001,506994.000.601,5072,5002,50000.00 001-110-521.101FICA TAXES12,80111,47811,80011,8008,5363,264.000.7211,80012,30012,2504503.81 001-110-521.102MEDICARE TAXES3,0593,1313,3003,3002,435865.000.743,3003,5003,4501504.55 001-110-522.102VOT PENSION CONTRIBUTIONS GE21,94723,00121,20021,20015,8135,387.000.7521,06019,60019,450(1,750)(8.25) 001-110-523.101LIFE/HEALTH INSURANCE25,63927,30128,40028,40023,6054,795.000.8328,40031,20031,2002,8009.86 001-110-524.100WORKERS' COMP INSURANCE36530040040033367.000.8333550050010025.00 TOTAL EXPENDITURE281,330286,375293,280293,280221,62171,659.007.01291,266308,450305,98012,7004.33 PERSONAL SERVICES281,330286,375293,280293,280221,62171,659.007.01291,266308,450305,98012,7004.33 Totals for dept 110 - MANAGER285,721292,053306,720306,720226,43180,289.009.34304,028322,090319,62012,9004.21 Dept 111 - HUMAN RESOURCES OPERATING EXPENDITURES/EXPENSE Expenditure 001-111-526.101EMPLOYEE RECOGNITION PROGR11,79215,45415,00015,00013,9971,003.000.9317,00015,00015,00000.00 001-111-526.102EMPLOYEE ASSISTANCE PROGRA11,4913,3354,0004,0002,3681,632.000.594,0004,0004,00000.00 001-111-534.300OTHER CONTRACTUAL SERVICES5,9264282,0002,0004021,598.000.202,0002,0002,00000.00 001-111-540.300TRAVEL & PER DIEM1,8737873,5003,5001,0962,404.000.313,5004,8504,8501,35038.57 001-111-541.300COMMUNICATION SERVICES9269181,2001,200841359.000.701,2501,3001,3001008.33 001-111-546.320COMPUTER SYSTEM MAINT & SUP10,29111,28012,50012,5009,9252,575.000.7912,50012,35012,350(150)(1.20) 001-111-547.300PRINTING & BINDING05361,0001,000130870.000.131,0002,0004,0003,000300.00 001-111-549.300OTHER MISC CHGS & OBLIGATION2474941,0001,00075925.000.081,0001,0001,00000.00 001-111-549.401RECRUITMENT EXPENSES503019,00019,0005,99313,007.000.3219,00019,00017,000(2,000)(10.53) 001-111-552.302SMALL TOOLS AND EQUIPMENT0365005000500.000.0050050050000.00 001-111-554.300BOOKS, PUBL, SUBS & MEMBERSH1,1201,1071,2901,2901,22565.000.951,2901,5531,55326320.39 001-111-554.301PERSONNEL TRAINING3,3682,9354,4004,4002,6331,767.000.604,4004,0004,000(400)(9.09) 001-111-554.310EMPLOYEE DEVELOPMENT9867,00210,00010,0008,1191,881.000.8110,00010,00010,00000.00 TOTAL EXPENDITURE48,52344,31275,39075,39046,80428,586.006.4177,44077,55377,5532,1632.87 OPERATING EXPENDITURES/EXPENSE48,52344,31275,39075,39046,80428,586.006.4177,44077,55377,5532,1632.87 Page 49 of 79 CAPITAL OUTLAY Expenditure 001-111-664.601-9COMPUTER EQUIPMENT COVID-191,62400000.000.0000000.00 TOTAL EXPENDITURE1,62400000.000.0000000.00 CAPITAL OUTLAY1,62400000.000.0000000.00 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 9 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE PERSONAL SERVICES Expenditure 001-111-512.100REGULAR SALARIES & WAGES217,594210,904218,100218,100163,13154,969.000.75217,232231,200228,94510,8454.97 001-111-514.100OVERTIME7100000.000.0000000.00 001-111-515.103BONUS PAY PLAN1,9501,7502,3002,3002,3000.001.002,3002,3002,30000.00 001-111-515.107PART-TIME SALARIES4,29314,51220,75020,75010,63110,119.000.5120,75021,46020,800500.24 001-111-515.120CELL PHONE ALLOWANCE3253500000.000.0000000.00 001-111-516.100COMPENSATED ABSENCES2,9084,1943,0003,0004,299(1,299.00)1.434,3005,1005,1002,10070.00 001-111-521.101FICA TAXES12,54113,42014,50014,50010,5004,000.000.7214,50015,00014,9204202.90 001-111-521.102MEDICARE TAXES3,1573,2363,6003,6002,5611,039.000.713,6003,7003,660601.67 001-111-522.102VOT PENSION CONTRIBUTIONS GE23,66723,32621,10021,10015,7425,358.000.7520,97019,50019,325(1,775)(8.41) 001-111-523.101LIFE/HEALTH INSURANCE27,46722,85023,80023,80021,6412,159.000.9123,75034,30034,30010,50044.12 001-111-523.105HSA - HEALTH SAVINGS ACCOUNT2,3722,2802,1002,1001,800300.000.862,4002,3002,2801808.57 001-111-524.100WORKERS' COMP INSURANCE40033640040035743.000.8935750050010025.00 TOTAL EXPENDITURE296,745297,158309,650309,650232,96276,688.008.53310,159335,360332,13022,4807.26 PERSONAL SERVICES296,745297,158309,650309,650232,96276,688.008.53310,159335,360332,13022,4807.26 Totals for dept 111 - HUMAN RESOURCES346,892341,470385,040385,040279,766105,274.0014.95387,599412,913409,68324,6436.40 Dept 120 - VILLAGE CLERK OPERATING EXPENDITURES/EXPENSE Expenditure 001-120-531.303CODIFICATION SERVICES6,3216,98311,00011,0006,7354,265.000.6111,00011,00511,00550.05 001-120-534.300OTHER CONTRACTUAL SERVICES002,2002,2001172,083.000.0502,5002,50030013.64 001-120-534.301ELECTION EXPENSE2024,34526,97024,95089524,055.000.0489534,65034,6509,70038.88 001-120-534.302LEGAL ADVERTISING7,9524,13611,95011,9506,6495,301.000.5611,95011,75011,750(200)(1.67) 001-120-540.300TRAVEL & PER DIEM3,1308294,9004,9006144,286.000.134,9004,7004,700(200)(4.08) 001-120-541.300COMMUNICATION SERVICES1,0359631,4001,400642758.000.461,4001,4001,40000.00 001-120-541.305WEBSITE MAINTENANCE005,1507,1707,919(749.00)1.107,1708,5608,5601,39019.39 001-120-546.320COMPUTER SYSTEM MAINT & SUP13,78414,44515,00015,00014,185815.000.9515,00017,70017,7002,70018.00 001-120-548.110MARKETING AND PUBLIC RELATIO12,9195,5219,0009,0005,0573,943.000.569,00010,11510,1151,11512.39 001-120-549.100MISCELLANEOUS ARCHIVAL1301,0212,5002,500112,489.000.001,0002,5002,50000.00 001-120-549.300OTHER MISC CHGS & OBLIGATION2,5363,37150050040595.000.8150050050000.00 001-120-549.302VILLAGE NEWSLETTER0020,00020,00011,4018,599.000.5720,00022,00022,0002,00010.00 001-120-552.302SMALL TOOLS AND EQUIPMENT40912350050047426.000.9550050050000.00 001-120-554.300BOOKS, PUBL, SUBS & MEMBERSH9011,0691,4201,4201,013407.000.711,4201,4201,42000.00 001-120-554.301PERSONNEL TRAINING1,6641,8392,4502,4501,1601,290.000.472,4503,1503,15070028.57 TOTAL EXPENDITURE50,80164,645114,940114,94057,27757,663.007.9787,185132,450132,45017,51015.23 OPERATING EXPENDITURES/EXPENSE50,80164,645114,940114,94057,27757,663.007.9787,185132,450132,45017,51015.23 CAPITAL OUTLAY Expenditure 001-120-664.600MACH/EQUIPMENT1,06400000.000.0000000.00 001-120-664.601COMPUTER EQUIPMENT05,7190000.000.0000000.00 001-120-664.601-9COMPUTER EQUIPMENT COVID-191,80800000.000.0000000.00 TOTAL EXPENDITURE2,8725,7190000.000.0000000.00 Page 50 of 79 CAPITAL OUTLAY2,8725,7190000.000.0000000.00 PERSONAL SERVICES Expenditure 001-120-512.100REGULAR SALARIES & WAGES203,616163,089168,500168,500125,99842,502.000.75167,784178,600176,8308,3304.94 001-120-514.350OVERTIME - DISASTER22200000.000.0000000.00 001-120-515.103BONUS PAY PLAN1,7501,7502,3002,3002,3000.001.002,3002,3002,30000.00 001-120-515.107PART-TIME SALARIES020,73527,30027,30018,3758,925.000.6727,30028,70028,3951,0954.01 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 10 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE 001-120-515.108AUTO ALLOWANCE3,0993,0003,0003,0002,308692.000.773,0003,0003,00000.00 001-120-515.120CELL PHONE ALLOWANCE6503750000.000.0000000.00 001-120-516.100COMPENSATED ABSENCES04,0870000.000.0000000.00 001-120-521.101FICA TAXES12,15011,33812,40012,4008,7343,666.000.7012,40012,85012,7503502.82 001-120-521.102MEDICARE TAXES2,8412,6522,9002,9002,043857.000.702,9003,0002,975752.59 001-120-522.102VOT PENSION CONTRIBUTIONS GE22,14818,03816,30016,30012,1594,141.000.7516,20015,10014,925(1,375)(8.44) 001-120-523.101LIFE/HEALTH INSURANCE45,25826,75925,90025,90028,724(2,824.00)1.1134,50037,90037,90012,00046.33 001-120-524.100WORKERS' COMP INSURANCE350268400400294106.000.7429440040000.00 TOTAL EXPENDITURE292,084252,091259,000259,000200,93558,065.007.19266,678281,850279,47520,4757.91 PERSONAL SERVICES292,084252,091259,000259,000200,93558,065.007.19266,678281,850279,47520,4757.91 Totals for dept 120 - VILLAGE CLERK345,757322,455373,940373,940258,212115,728.0015.16353,863414,300411,92537,98510.16 Dept 130 - FINANCE OPERATING EXPENDITURES/EXPENSE Expenditure 001-130-532.300ACCOUNTING & AUDITING SERVIC27,48967,87760,20060,20055,0005,200.000.9155,00060,00060,000(200)(0.33) 001-130-534.300OTHER CONTRACTUAL SERVICES1,7111,2651,5001,500772728.000.511,5004,5004,5003,000200.00 001-130-540.300TRAVEL & PER DIEM30906,1406,1401,2824,858.000.214,8206,9006,90076012.38 001-130-541.300COMMUNICATION SERVICES00960960779181.000.819201,0001,000404.17 001-130-544.301OPERATING LEASES2,4672,5902,5502,5501,823727.000.712,8532,7202,7201706.67 001-130-546.320COMPUTER SYSTEM MAINT & SUP14,05928,84420,00020,00018,8711,129.000.9420,05121,40021,4001,4007.00 001-130-547.300PRINTING & BINDING1,9241,6551,9001,9001,366534.000.721,7802,0002,0001005.26 001-130-549.300OTHER MISC CHGS & OBLIGATION5201,4951,0001,00011989.000.011,0001,0001,00000.00 001-130-549.304LICENSES, FEES & PERMITS00500500525(25.00)1.0546050050000.00 001-130-551.300OFFICE SUPPLIES & EQUIPMENT7452,0142,0002,0001,96733.000.982,0002,0002,00000.00 001-130-554.300BOOKS, PUBL, SUBS & MEMBERSH9831,7222,9002,9002,193707.000.761,8182,9002,90000.00 001-130-554.301PERSONNEL TRAINING2,7483,3694,8704,8705244,346.000.112,4605,3335,3334639.51 TOTAL EXPENDITURE52,955110,831104,520104,52085,11319,407.007.7394,662110,253110,2535,7335.49 OPERATING EXPENDITURES/EXPENSE52,955110,831104,520104,52085,11319,407.007.7394,662110,253110,2535,7335.49 CAPITAL OUTLAY Expenditure 001-130-664.601COMPUTER EQUIPMENT1,66900000.000.0000000.00 001-130-664.601-9COMPUTER EQUIPMENT COVID-195,09300000.000.0000000.00 TOTAL EXPENDITURE6,76200000.000.0000000.00 CAPITAL OUTLAY6,76200000.000.0000000.00 PERSONAL SERVICES Expenditure 001-130-512.100REGULAR SALARIES & WAGES263,546409,732437,500437,500309,110128,390.000.71417,986461,000459,35521,8555.00 001-130-515.103BONUS PAY PLAN1,8753,0003,0003,0003,0000.001.003,0003,0003,00000.00 001-130-515.120CELL PHONE ALLOWANCE6507000000.000.0000000.00 001-130-516.100COMPENSATED ABSENCES1,76911,1934,6004,60021,322(16,722.00)4.6421,3235,0005,0004008.70 001-130-521.101FICA TAXES15,67124,86026,90026,90020,1616,739.000.7526,90027,90027,8009003.35 001-130-521.102MEDICARE TAXES3,6655,8146,4006,4004,7151,685.000.746,4006,6006,5001001.56 Page 51 of 79 001-130-522.102VOT PENSION CONTRIBUTIONS GE28,66745,38642,30042,30030,06512,235.000.7140,60038,90038,770(3,530)(8.35) 001-130-523.101LIFE/HEALTH INSURANCE49,16572,09587,10087,10069,51817,582.000.8093,850110,700110,70023,60027.10 001-130-523.105HSA - HEALTH SAVINGS ACCOUNT01,1402,1002,1003801,720.000.1838000(2,100)(100.00) 001-130-524.100WORKERS' COMP INSURANCE450592800800650150.000.8165190090010012.50 TOTAL EXPENDITURE365,458574,512610,700610,700458,921151,779.0010.33611,090654,000652,02541,3256.77 PERSONAL SERVICES365,458574,512610,700610,700458,921151,779.0010.33611,090654,000652,02541,3256.77 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 11 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE Totals for dept 130 - FINANCE425,175685,343715,220715,220544,034171,186.0018.06705,752764,253762,27847,0586.58 Dept 140 - LEGAL OPERATING EXPENDITURES/EXPENSE Expenditure 001-140-531.301LEGAL SERVICES79,15498,525110,000110,00082,74827,252.000.75100,000100,000100,000(10,000)(9.09) 001-140-531.301-9LEGAL SERVICES COVID-199,14221,0500000.000.0000000.00 001-140-531.308LEGAL FEES PERSONNEL60,54675,87080,00080,00032,69747,303.000.4180,00080,00080,00000.00 TOTAL EXPENDITURE148,842195,445190,000190,000115,44574,555.001.16180,000180,000180,000(10,000)(5.26) OPERATING EXPENDITURES/EXPENSE148,842195,445190,000190,000115,44574,555.001.16180,000180,000180,000(10,000)(5.26) Totals for dept 140 - LEGAL148,842195,445190,000190,000115,44574,555.001.16180,000180,000180,000(10,000)(5.26) Dept 150 - COMPREHENSIVE PLANNING OPERATING EXPENDITURES/EXPENSE Expenditure 001-150-531.301LEGAL SERVICES19,95020,34414,00014,00021,229(7,229.00)1.5223,00030,00017,0003,00021.43 001-150-531.321MAPPING SERVICES8001,4551,5001,5001,870(370.00)1.251,9002,0001,50000.00 001-150-531.322MISC PLANNING SERVICE117,222119,275141,440149,94096,60853,332.000.64149,940141,440141,440(8,500)(5.67) 001-150-534.300OTHER CONTRACTUAL SERVICES18,16210,06810,00010,00013,802(3,802.00)1.3838,00010,00010,00000.00 001-150-534.300-0OTHER CONTRACTUAL SERVICES-00105,000105,00010,50094,500.000.10105,00000(105,000)(100.00) 001-150-534.302LEGAL ADVERTISING3,0724,6925,0005,0002,6182,382.000.523,5005,0005,00000.00 001-150-546.320COMPUTER SYSTEM MAINT & SUP5687671,6001,6001501,450.000.091,6001,6001,60000.00 001-150-547.300PRINTING & BINDING69701,0001,000411589.000.415501,0001,00000.00 001-150-549.300OTHER MISC CHGS & OBLIGATION652251,0001,000849151.000.859501,0001,00000.00 001-150-554.300BOOKS, PUBL, SUBS & MEMBERSH1,0001,0001,0001,0001,0000.001.001,0001,1001,00000.00 TOTAL EXPENDITURE162,123157,626281,540290,040149,037141,003.007.76325,440193,140179,540(110,500)(38.10) OPERATING EXPENDITURES/EXPENSE162,123157,626281,540290,040149,037141,003.007.76325,440193,140179,540(110,500)(38.10) Totals for dept 150 - COMPREHENSIVE PLANNING162,123157,626281,540290,040149,037141,003.007.76325,440193,140179,540(110,500)(38.10) Dept 160 - GENERAL GOVERNMENT OPERATING EXPENDITURES/EXPENSE Expenditure 001-160-531.302ENGINEERING SERVICES000000.000.00015,000000.00 001-160-531.324GRANTS ACQUISTION & ADMIN01,6667,5007,5002207,280.000.037,5007,5007,50000.00 001-160-534.300OTHER CONTRACTUAL SERVICES24,63934,31775,50077,80036,48041,320.000.4775,96841,50036,500(41,300)(53.08) 001-160-534.303SPECIAL EVENTS2,6964,5046,0008,5007,564936.000.896,0236,00010,0001,50017.65 001-160-534.303-4SPECIAL EVENTS0008,0004,9543,046.000.623,95100(8,000)(100.00) 001-160-541.300COMMUNICATION SERVICES7,8477,6105,5405,5404,631909.000.845,1675,6405,6401001.81 001-160-541.301POSTAGE2,3042,2802,8002,8001,884916.000.672,7952,8002,80000.00 001-160-541.305WEBSITE MAINTENANCE7,2615,0000000.000.0000000.00 001-160-543.300UTILITY SERVICES15,36716,75119,14019,14012,2896,851.000.6419,24319,31019,3101700.89 001-160-544.301OPERATING LEASES47,43746,86748,06014,06012,3291,731.000.8813,3223,9603,960(10,100)(71.83) 001-160-545.300INSURANCE62,85199,023102,060102,06096,7375,323.000.95102,060114,960114,96012,90012.64 001-160-546.301OFFICE EQUIP/REPAIR & MAINT2,1581,0223,6003,6001,1472,453.000.322,0003,6003,60000.00 001-160-546.320COMPUTER SYSTEM MAINT & SUP30,96400000.000.0000000.00 Page 52 of 79 001-160-547.300PRINTING & BINDING1,6982275,0002,0008651,135.000.432,0002,0002,00000.00 001-160-549.300OTHER MISC CHGS & OBLIGATION7,5412,71910,00010,0002,7477,253.000.2710,00010,00010,00000.00 001-160-549.302VILLAGE NEWSLETTER16,71018,1740000.000.0000000.00 001-160-549.304LICENSES, FEES & PERMITS2,3962,4282,0502,0502,069(19.00)1.012,0692,2752,27522510.98 001-160-549.391BANK CHARGES533921,5001,5002061,294.000.14500500500(1,000)(66.67) 001-160-549.395CREDIT CARD FEES AND CHARGE1,1621,3551,0001,0001,328(328.00)1.332,5002,5002,5001,500150.00 001-160-549.397BAD DEBT EXPENSE000050(50.00)0.0000000.00 001-160-551.300OFFICE SUPPLIES & EQUIPMENT6,2433,5596,5006,5003,7562,744.000.586,5006,5006,50000.00 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 12 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE 001-160-552.310-9DISASTER RELIEF - COVID-19 5,5032,7450000.000.0000000.00 001-160-554.300BOOKS, PUBL, SUBS & MEMBERSH2,7482,0763,0603,0602,388672.000.782,5383,1703,1701103.59 TOTAL EXPENDITURE248,058252,415299,310275,110191,64483,466.0010.84264,136247,215231,215(43,895)(15.96) OPERATING EXPENDITURES/EXPENSE248,058252,415299,310275,110191,64483,466.0010.84264,136247,215231,215(43,895)(15.96) CAPITAL OUTLAY Expenditure 001-160-664.600MACH/EQUIPMENT00005,043(5,043.00)0.0000000.00 001-160-664.600-9MACH/EQUIPMENT COVID-191,59900000.000.0000000.00 001-160-664.601COMPUTER EQUIPMENT29,10000000.000.0000000.00 TOTAL EXPENDITURE30,6990005,043(5,043.00)0.0000000.00 CAPITAL OUTLAY30,6990005,043(5,043.00)0.0000000.00 OTHER FINANCING SOURCES & USES Expenditure 001-160-599.902RESERVES - CONTINGENCY0015,0005,20005,200.000.000015,0009,800188.46 TOTAL EXPENDITURE0015,0005,20005,200.000.000015,0009,800188.46 OTHER FINANCING SOURCES & USES0015,0005,20005,200.000.000015,0009,800188.46 Totals for dept 160 - GENERAL GOVERNMENT278,757252,415314,310280,310196,68783,623.0010.84264,136247,215246,215(34,095)(12.16) Dept 161 - IT OPERATING EXPENDITURES/EXPENSE Expenditure 001-161-526.103EDUCATION REIMBURSEMENT PR3,00000000.000.0003,0003,0003,0000.00 001-161-534.300OTHER CONTRACTUAL SERVICES033720,00020,00011,0258,975.000.5520,00020,00020,00000.00 001-161-540.300TRAVEL & PER DIEM003,0003,00003,000.000.003,0003,0003,00000.00 001-161-541.300COMMUNICATION SERVICES001,2001,200271,173.000.021,2001,2001,20000.00 001-161-546.320COMPUTER SYSTEM MAINT & SUP0121,831184,000184,000157,38826,612.000.86184,000174,136174,136(9,864)(5.36) 001-161-546.320-9COMPUTER SYSTEM MAINT & SUP01,1410000.000.0000000.00 001-161-549.300OTHER MISC CHGS & OBLIGATION54700000.000.0000000.00 001-161-552.160IT OPERATING SUPPLIES1,6676132,0002,0008721,128.000.442,0002,0002,00000.00 001-161-552.301GAS & OIL008008000800.000.0080080080000.00 001-161-554.301PERSONNEL TRAINING5,3516,0148,0008,0002,8965,104.000.368,0008,0008,00000.00 TOTAL EXPENDITURE10,565129,936219,000219,000172,20846,792.002.23219,000212,136212,136(6,864)(3.13) OPERATING EXPENDITURES/EXPENSE10,565129,936219,000219,000172,20846,792.002.23219,000212,136212,136(6,864)(3.13) CAPITAL OUTLAY Expenditure 001-161-664.601COMPUTER EQUIPMENT1,82000000.000.0000000.00 001-161-664.607EQUIPMENT - TECH0101,4840000.000.0000000.00 TOTAL EXPENDITURE1,820101,4840000.000.0000000.00 CAPITAL OUTLAY1,820101,4840000.000.0000000.00 Page 53 of 79 PERSONAL SERVICES Expenditure 001-161-512.100REGULAR SALARIES & WAGES139,092182,151188,400188,400137,13951,261.000.73187,617196,525197,0608,6604.60 001-161-514.350OVERTIME - DISASTER92300000.000.0000000.00 001-161-515.103BONUS PAY PLAN1,4001,7501,7501,7501,7500.001.001,7501,7501,75000.00 001-161-515.120CELL PHONE ALLOWANCE9921,20000923(923.00)0.001,2001,2001,2001,2000.00 001-161-516.100COMPENSATED ABSENCES3,68213,304006,309(6,309.00)0.006,3090000.00 001-161-521.101FICA TAXES8,45311,11011,50011,5008,7472,753.000.7611,50012,10012,0605604.87 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 13 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE 001-161-521.102MEDICARE TAXES1,9772,5982,7002,7002,046654.000.762,7002,8502,8201204.44 001-161-522.102VOT PENSION CONTRIBUTIONS GE15,12520,14618,20018,20013,2344,966.000.7318,10516,60016,635(1,565)(8.60) 001-161-523.101LIFE/HEALTH INSURANCE24,34333,25234,70034,70026,3318,369.000.7634,50037,90037,9003,2009.22 001-161-524.100WORKERS' COMP INSURANCE250256400400278122.000.7027840040000.00 TOTAL EXPENDITURE196,237265,767257,650257,650196,75760,893.005.43263,959269,325269,82512,1754.73 PERSONAL SERVICES196,237265,767257,650257,650196,75760,893.005.43263,959269,325269,82512,1754.73 Totals for dept 161 - IT208,622497,187476,650476,650368,965107,685.007.65482,959481,461481,9615,3111.11 Dept 175 - POLICE DEPARTMENT OPERATING EXPENDITURES/EXPENSE Expenditure 001-175-526.101EMPLOYEE RECOGNITION PROGR2,9874,4154,5004,5004,021479.000.894,5004,5004,50000.00 001-175-526.103EDUCATION REIMBURSEMENT PR3,8413,3268,0008,0003817,619.000.058,0008,0008,00000.00 001-175-526.105EMPLOYEE PHYSICAL/PSYCOLOG1,5701,0004,2504,25004,250.000.003,0003,0003,000(1,250)(29.41) 001-175-534.300OTHER CONTRACTUAL SERVICES4,900209,252215,300215,300161,31953,981.000.75215,092239,865239,86524,56511.41 001-175-540.300TRAVEL & PER DIEM5,8002,00812,00012,0005,8806,120.000.499,0009,0009,000(3,000)(25.00) 001-175-541.300COMMUNICATION SERVICES26,01421,34426,65026,65015,26811,382.000.5726,65026,65026,65000.00 001-175-541.301POSTAGE2143151,0001,00075925.000.081,0001,0001,00000.00 001-175-543.300UTILITY SERVICES31,89935,37038,00038,00028,3139,687.000.7538,00038,00038,00000.00 001-175-544.301OPERATING LEASES2,1332,1332,1502,1501,411739.000.662,1502,1502,15000.00 001-175-545.300INSURANCE61,22174,24782,15082,15079,8442,306.000.9782,15092,00892,0089,85812.00 001-175-546.175K-9 EQUIPMENT & MAINTENANCE6,5585,3086,0006,0004795,521.000.086,0006,0006,00000.00 001-175-546.301OFFICE EQUIP/REPAIR & MAINT1,1171,0451,2001,200804396.000.671,2001,2001,20000.00 001-175-546.302VEHICLE REPAIR & MAINTENANCE39,80936,43430,00030,00023,5236,477.000.7830,00030,00030,00000.00 001-175-546.303BUILDING REPAIR & MAINT26,4661,8872,0002,0005711,429.000.292,0002,0002,00000.00 001-175-546.304COMMUNICATION EQUIP MAINT31,23510,95915,00015,00013,6241,376.000.9115,00015,00015,00000.00 001-175-546.310EQUIPMENT REPAIR & MAINT2,239503,0003,0001,6481,352.000.553,0003,0003,00000.00 001-175-546.320COMPUTER SYSTEM MAINT & SUP133,58643,54443,00043,00022,71120,289.000.5343,00051,97551,9758,97520.87 001-175-547.300PRINTING & BINDING1,1557531,5001,500957543.000.641,5001,2001,200(300)(20.00) 001-175-549.300OTHER MISC CHGS & OBLIGATION13,2529,56210,00010,0005,2424,758.000.5210,00010,00010,00000.00 001-175-549.303INVESTIGATIVE EXPENSES1,9562,2333,0003,0001,7251,275.000.583,0003,0003,00000.00 001-175-549.304LICENSES, FEES & PERMITS1,9362,0232,5002,5002,41981.000.972,5002,5002,50000.00 001-175-549.311MARINE UNIT OPERATIONS25,26313,50412,60012,6007,8274,773.000.62012,60012,60000.00 001-175-549.314K.E.Y.S. PROGRAM14,0636,35313,00013,0006,8146,186.000.52013,00013,00000.00 001-175-549.996-9HURRICANE EXPENSES-ISAIAS25800000.000.0000000.00 001-175-551.300OFFICE SUPPLIES & EQUIPMENT3,9654,6185,0005,0003,1731,827.000.6304,0004,000(1,000)(20.00) 001-175-551.301CRIME PREVENTION SUPPLIES1,7273774,0004,00004,000.000.0002,5002,500(1,500)(37.50) 001-175-552.301GAS & OIL34,60145,50130,00030,00052,218(22,218.00)1.74070,00070,00040,000133.33 001-175-552.302SMALL TOOLS AND EQUIPMENT8,2388,04313,00013,0003,3149,686.000.25010,00010,000(3,000)(23.08) 001-175-552.305UNIFORMS22,05227,68231,80031,80014,40617,394.000.45025,00025,000(6,800)(21.38) 001-175-552.310-1COVID-19 POLICE GRANT 2020019,7400000.000.0000000.00 001-175-552.310-9DISASTER RELIEF - COVID-19 5,1356450000.000.0000000.00 001-175-554.300BOOKS, PUBL, SUBS & MEMBERSH3,6053,3693,0003,0002,188812.000.733,0003,0003,00000.00 001-175-554.301PERSONNEL TRAINING17,6103,69720,00020,00012,5307,470.000.6320,00018,00018,000(2,000)(10.00) 001-175-554.301-1PERSONNEL TRAINING0545001,636(1,636.00)0.0000000.00 TOTAL EXPENDITURE536,405601,282643,600643,600474,321169,279.0017.30529,742708,148708,14864,54810.03 Page 54 of 79 OPERATING EXPENDITURES/EXPENSE536,405601,282643,600643,600474,321169,279.0017.30529,742708,148708,14864,54810.03 CAPITAL OUTLAY Expenditure 001-175-664.600MACH/EQUIPMENT1,1955,9480000.000.0000000.00 001-175-664.600-1MACH/EQUIPMENT00043,50943,5081.001.0043,50900(43,509)(100.00) 001-175-664.601COMPUTER EQUIPMENT34,60000000.000.0000000.00 001-175-664.602VEHICLES121,501178,111244,610000.000.0000000.00 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 14 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE 001-175-664.602-1COVID-19 POLICE GRANT 202029,08400000.000.0000000.00 001-175-664.602-9VEHICLES000244,61074,528170,082.000.30243,63800(244,610)(100.00) TOTAL EXPENDITURE186,380184,059244,610288,119118,036170,083.001.30287,14700(288,119)(100.00) CAPITAL OUTLAY186,380184,059244,610288,119118,036170,083.001.30287,14700(288,119)(100.00) PERSONAL SERVICES Expenditure 001-175-512.171SAL & WAGES - ADMINSTRATION260,971265,934277,000277,000207,24769,753.000.75275,915293,350290,61513,6154.92 001-175-512.171-9SAL & WAGES - ADMIN COVID-19 52,41400000.000.0000000.00 001-175-512.172REG SAL & WAGES - COMMUNICAT197,30100000.000.0000000.00 001-175-512.175REG SAL & WAGES - OPERATIONS1,257,9821,307,7181,321,4801,321,4801,006,965314,515.000.761,349,2421,371,2701,361,67040,1903.04 001-175-512.175-9REG SAL & WAGES - OPS COVID-1 11,17000000.000.0000000.00 001-175-514.172OVERTIME - COMMUNICATIONS11,97900000.000.0000000.00 001-175-514.175OVERTIME - OPERATIONS89,19267,238112,000114,09068,45945,631.000.6095,266120,880120,8806,7905.95 001-175-514.175-9OVERTIME - OPS COVID-19 5%34500000.000.0000000.00 001-175-514.350OVERTIME - DISASTER13,91800000.000.0000000.00 001-175-515.101HOLIDAY PAY55,54353,60661,47061,47053,2278,243.000.8762,20565,95065,3303,8606.28 001-175-515.103BONUS PAY PLAN10,5007,0006,4006,4006,4000.001.006,4006,7506,7503505.47 001-175-515.105CONTRACT SERVICES4,50022,77521,95021,95015,6806,270.000.7120,64021,92021,920(30)(0.14) 001-175-515.106CLOTHING & BOOT ALLOWANCE14,53812,50012,95012,95013,125(175.00)1.0113,12513,12513,1251751.35 001-175-515.107PART-TIME SALARIES15,09714,34016,45016,45011,7144,736.000.7116,45017,45017,2658154.95 001-175-515.108AUTO ALLOWANCE6,1986,0006,0006,0004,6151,385.000.776,0006,0006,00000.00 001-175-515.120CELL PHONE ALLOWANCE1,2401,2001,2001,200923277.000.771,2001,2001,20000.00 001-175-515.125OTHER ALLOWANCES6,1986,0006,0006,0004,6151,385.000.776,0006,0006,00000.00 001-175-515.172P/T SALARY - COMMUNICATIONS23,41800000.000.0000000.00 001-175-515.172-9P/T SALARY - COMM COVID-19 5%27900000.000.0000000.00 001-175-516.100COMPENSATED ABSENCES68,61750,97235,96035,96018,88217,078.000.5335,60039,00039,0003,0408.45 001-175-521.101FICA TAXES115,916105,126112,400112,40083,97228,428.000.75112,400116,300115,4003,0002.67 001-175-521.101-9FICA TAXES COVID-1985100000.000.0000000.00 001-175-521.102MEDICARE TAXES27,21224,86426,50026,50019,7406,760.000.7426,50027,50027,2007002.64 001-175-521.102-9MEDICARE TAXES COVID-1919900000.000.0000000.00 001-175-522.101FRS CONTRIBUTIONS35,64516,3050000.000.0000000.00 001-175-522.101-9FRS CONTRIBUTIONS COVID-1925100000.000.0000000.00 001-175-522.102VOT PENSION CONTRIBUTIONS GE27,9476,5686,0006,0004,4331,567.000.745,9035,5005,450(550)(9.17) 001-175-522.102-9VOT PENSION CONTRIBUTIONS GE 5900000.000.0000000.00 001-175-522.103VOT PENSION CONTRIBUTIONS PS2,014100,619110,900110,90082,77428,126.000.75108,800237,200117,6006,7006.04 001-175-522.105DEFINED CONTRIBUTION26,27426,59327,70027,70020,7256,975.000.7527,60029,40029,1001,4005.05 001-175-522.105-9DEFINED CONTRIBUTION COVID-192,01100000.000.0000000.00 001-175-522.110OTHER PENSION CONTRIBUTIONS91,37591,64991,30091,300091,300.000.0091,64991,65091,6503500.38 001-175-523.101LIFE/HEALTH INSURANCE364,041343,785359,300359,300302,95256,348.000.84358,200434,400434,40075,10020.90 001-175-524.100WORKERS' COMP INSURANCE60,49048,65557,20057,20052,0705,130.000.9152,06965,60065,0007,80013.64 001-175-525.100UNEMPLOYMENT COMPENSATION911,6500000.000.0000000.00 TOTAL EXPENDITURE2,805,7762,581,0972,670,1602,672,2501,978,518693,732.0014.732,671,1642,970,4452,835,555163,3056.11 PERSONAL SERVICES2,805,7762,581,0972,670,1602,672,2501,978,518693,732.0014.732,671,1642,970,4452,835,555163,3056.11 Totals for dept 175 - POLICE DEPARTMENT3,528,5613,366,4383,558,3703,603,9692,570,8751,033,094.0033.333,488,0533,678,5933,543,703(60,266)(1.67) Page 55 of 79 Dept 181 - CODE COMPLIANCE OPERATING EXPENDITURES/EXPENSE Expenditure 001-181-531.301LEGAL SERVICES13,14110,92910,50010,50011,716(1,216.00)1.1215,00015,00015,0004,50042.86 001-181-531.320CODE ENFORCEMENT SERVICE0582,0002,0008701,130.000.442,0002,0002,00000.00 001-181-540.300TRAVEL & PER DIEM1,28202,5002,5007071,793.000.282,5003,0003,00050020.00 001-181-541.300COMMUNICATION SERVICES6854861,0001,5001,164336.000.781,0001,5001,50000.00 001-181-541.301POSTAGE526738500500586(86.00)1.1750050050000.00 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 15 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE 001-181-546.302VEHICLE REPAIR & MAINTENANCE9548291,0001,000597403.000.601,0001,0001,00000.00 001-181-549.300OTHER MISC CHGS & OBLIGATION013050050048452.000.1050050050000.00 001-181-551.300OFFICE SUPPLIES & EQUIPMENT240331001000100.000.00100500500400400.00 001-181-552.301GAS & OIL6266225005001,018(518.00)2.0450050050000.00 001-181-554.300BOOKS, PUBL, SUBS & MEMBERSH150272500500128372.000.265001,0001,000500100.00 001-181-554.301PERSONNEL TRAINING60501,5002,0001,570430.000.791,5003,0003,0001,00050.00 TOTAL EXPENDITURE18,20914,09720,60021,60018,4043,196.007.5525,10028,50028,5006,90031.94 OPERATING EXPENDITURES/EXPENSE18,20914,09720,60021,60018,4043,196.007.5525,10028,50028,5006,90031.94 PERSONAL SERVICES Expenditure 001-181-512.100REGULAR SALARIES & WAGES42,95250,82953,10053,10039,58313,517.000.7552,88356,82055,2152,1153.98 001-181-514.100OVERTIME4700000.000.0000000.00 001-181-515.106CLOTHING & BOOT ALLOWANCE12512515015012525.000.8312515015000.00 001-181-515.107PART-TIME SALARIES2,515027,53026,53010,70515,825.000.4010,70500(26,530)(100.00) 001-181-521.101FICA TAXES2,8123,1615,0005,0003,1331,867.000.635,0003,5503,450(1,550)(31.00) 001-181-521.102MEDICARE TAXES6587391,2001,200733467.000.611,200850850(350)(29.17) 001-181-522.102VOT PENSION CONTRIBUTIONS GE4,6735,6225,2005,2003,8201,380.000.735,1044,8004,660(540)(10.38) 001-181-523.101LIFE/HEALTH INSURANCE8,4209,2839,7009,7008,0301,670.000.839,65010,60010,6009009.28 001-181-524.100WORKERS' COMP INSURANCE1,1801,0932,0002,0001,811189.000.911,8111,6001,500(500)(25.00) 001-181-525.100UNEMPLOYMENT COMPENSATION68800000.000.0000000.00 TOTAL EXPENDITURE64,07070,852103,880102,88067,94034,940.005.6986,47878,37076,425(26,455)(25.71) PERSONAL SERVICES64,07070,852103,880102,88067,94034,940.005.6986,47878,37076,425(26,455)(25.71) Totals for dept 181 - CODE COMPLIANCE82,27984,949124,480124,48086,34438,136.0013.24111,578106,870104,925(19,555)(15.71) Dept 192 - FIRE CONTROL OPERATING EXPENDITURES/EXPENSE Expenditure 001-192-526.101EMPLOYEE RECOGNITION PROGR9013,5003,9503,9502,5551,395.000.653,9504,6704,67072018.23 001-192-526.103EDUCATION REIMB PRGRM7,3382,54611,2009,7002,1667,534.000.226,0009,6009,600(100)(1.03) 001-192-526.105EMPLOYEE PHYSICAL/PSYCOLOG12,83619,11722,60022,60017,0405,560.000.7522,60022,45422,454(146)(0.65) 001-192-534.300OTHER CONTRACTUAL SERVICES2,30005305300530.000.005301,0501,05052098.11 001-192-540.300TRAVEL & PER DIEM4,2519768,5002,5002012,299.000.085,0008,5008,5006,000240.00 001-192-541.300COMMUNICATION SERVICES15,19315,19014,10014,10010,2873,813.000.7314,10015,53015,5301,43010.14 001-192-541.301POSTAGE355614750750391359.000.5275075075000.00 001-192-543.300UTILITY SERVICES34,13136,93634,95034,95028,0426,908.000.8034,95042,12042,1207,17020.52 001-192-544.301OPERATING LEASES4,8765,4164,9504,9503,7661,184.000.764,9505,7005,70075015.15 001-192-545.300INSURANCE39,70145,22352,15052,15048,8853,265.000.9452,15058,40858,4086,25812.00 001-192-546.302VEHICLE REPAIR & MAINTENANCE73,61871,48671,80071,80039,61532,185.000.5571,80073,07573,0751,2751.78 001-192-546.303BUILDING REPAIR & MAINT32,0593,9504,2004,2002,9811,219.000.714,2005,8005,8001,60038.10 001-192-546.310EQUIPMENT REPAIR & MAINT14,78315,17421,10021,10019,7901,310.000.9421,10027,35327,3536,25329.64 001-192-546.320COMPUTER SYSTEM MAINT & SUP36,84223,95341,00041,00014,41326,587.000.3541,00072,63772,63731,63777.16 001-192-546.320-9COMPUTER SYSTEM MAINT & SUP02,2740000.000.0000000.00 001-192-547.300PRINTING & BINDING1,8711,3742,7002,7002,206494.000.822,7003,6503,65095035.19 001-192-549.300OTHER MISC CHGS & OBLIGATION6,7503,3124,5505,1624,324838.000.843,6624,9854,985(177)(3.43) 001-192-549.304LICENSES, FEES & PERMITS17,63719,19019,50020,38816,6713,717.000.8219,09221,45921,4591,0715.25 Page 56 of 79 001-192-549.397BAD DEBT EXPENSE71,107157,69870,70070,700070,700.000.0070,70075,00075,0004,3006.08 001-192-549.996-9HURRICANE EXPENSES-ISAIAS57800000.000.0000000.00 001-192-551.300OFFICE SUPPLIES & EQUIPMENT3,5313,5703,9003,9002,2071,693.000.573,9004,0804,0801804.62 001-192-551.302FIRE PREVENTION EDUCATION3,4623,8074,6504,6501,1763,474.000.254,6504,8754,8752254.84 001-192-552.301GAS & OIL11,69311,68414,50014,50010,5313,969.000.7314,50026,10026,10011,60080.00 001-192-552.302SMALL TOOLS AND EQUIPMENT6,44410,12521,12521,12516,8404,285.000.8021,12517,75517,755(3,370)(15.95) 001-192-552.304CHEMICALS9809601,0001,00066934.000.071,0005,0805,0804,080408.00 001-192-552.305UNIFORMS14,47631,52532,10041,60013,88427,716.000.3332,10037,14228,342(13,258)(31.87) 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 16 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE 001-192-552.308SAFETY SUPPLIES17,57925,69824,10024,10020,2493,851.000.8424,10024,85524,8557553.13 001-192-552.310DISASTER RELIEF SUPPLIES02,0416,0006,00006,000.000.006,0006,1206,1201202.00 001-192-552.310-9DISASTER RELIEF - COVID-19 74,62825,887001,495(1,495.00)0.001,4950000.00 001-192-552.310-9DISASTER RELIEF - HURRICANE IS2500000.000.0000000.00 001-192-552.311CPR PROGRAM SUPPLIES1,7261,047900900144756.000.16900750750(150)(16.67) 001-192-552.312MEDICAL SUPPLIES12,16429,82150,00050,00033,84816,152.000.6850,00050,00050,00000.00 001-192-552.344FIRE STATION SUPPLIES3,6443,4744,0004,0004,129(129.00)1.034,0004,5204,52052013.00 001-192-554.300BOOKS, PUBL, SUBS & MEMBERSH4,4565,6185,6005,6005,56040.000.995,6006,8456,8451,24522.23 001-192-554.301PERSONNEL TRAINING12,25214,73421,00017,50014,1593,341.000.8121,00028,91028,91011,41065.20 TOTAL EXPENDITURE544,187597,920578,105578,105337,621240,484.0017.73569,604669,773660,97382,86814.33 OPERATING EXPENDITURES/EXPENSE544,187597,920578,105578,105337,621240,484.0017.73569,604669,773660,97382,86814.33 CAPITAL OUTLAY Expenditure 001-192-664.600MACH/EQUIPMENT43,8129,40710,80031,67622,3469,330.000.7122,34600(31,676)(100.00) 001-192-664.601COMPUTER EQUIPMENT15,44200000.000.0000000.00 001-192-664.602VEHICLES0298,66045,3501,865,58801,865,588.000.00000(1,865,588)(100.00) 001-192-664.602-9VEHICLES00045,35043,6261,724.000.9643,62600(45,350)(100.00) TOTAL EXPENDITURE59,254308,06756,1501,942,61465,9721,876,642.001.6765,97200(1,942,614)(100.00) CAPITAL OUTLAY59,254308,06756,1501,942,61465,9721,876,642.001.6765,97200(1,942,614)(100.00) PERSONAL SERVICES Expenditure 001-192-512.100REGULAR SALARIES & WAGES1,858,8861,945,8221,964,5501,964,5501,491,534473,016.000.761,983,3322,277,6702,139,545174,9958.91 001-192-512.100-9REGULAR SALARIES & WAGES CO 14,74800000.000.0000000.00 001-192-513.101FIRE INSPECTOR PAY17,36517,52728,50028,50015,13213,368.000.5328,91028,92028,7202200.77 001-192-513.101-9FIRE INSPECTOR PAY COVID-19 5%7800000.000.0000000.00 001-192-514.100OVERTIME106,818129,984130,000130,000142,675(12,675.00)1.10130,000176,280138,6158,6156.63 001-192-514.100-9OVERTIME COVID-19 5%1,58800000.000.0000000.00 001-192-514.300OVERTIME - TRAINING14,26000000.000.0000000.00 001-192-514.350OVERTIME - DISASTER10,5176,2310000.000.0000000.00 001-192-514.350-9OVERTIME DISASTER - COVID-1930,14274,2550032,021(32,021.00)0.0032,0210000.00 001-192-515.101HOLIDAY PAY58,53962,28971,10071,10058,60812,492.000.8271,10075,45575,3354,2355.96 001-192-515.103BONUS PAY PLAN11,25013,00018,80018,8006,30012,500.000.346,30010,1508,900(9,900)(52.66) 001-192-515.107PART-TIME SALARIES18,60717,95216,45016,45011,7134,737.000.7116,45017,42517,2658154.95 001-192-515.120CELL PHONE ALLOWANCE000000.000.0001,200000.00 001-192-515.125OTHER ALLOWANCES6,1986,0006,0006,0004,6151,385.000.776,0006,0006,00000.00 001-192-516.100COMPENSATED ABSENCES14,22665,26850,23050,23045,2554,975.000.9050,84745,98545,985(4,245)(8.45) 001-192-521.101FICA TAXES125,106131,809138,800138,800103,09635,704.000.74138,800158,350149,95011,1508.03 001-192-521.101-9FICA TAXES COVID-192,7974,451001,930(1,930.00)0.001,9300000.00 001-192-521.102MEDICARE TAXES29,34230,98932,50032,50024,9057,595.000.7732,50037,05035,0652,5657.89 001-192-521.102-9MEDICARE TAXES COVID-196541,04100451(451.00)0.004520000.00 001-192-522.102VOT PENSION CONTRIBUTIONS GE10,90212,1799,8509,8507,2332,617.000.739,7789,5509,340(510)(5.18) 001-192-522.102-9VOT PENSION CONTRIBUTIONS GE 1800000.000.0000000.00 001-192-522.103VOT PENSION CONTRIBUTIONS PS434,476396,125385,300385,300323,71361,587.000.84406,550403,600374,565(10,735)(2.79) 001-192-522.103-9VOT PENSION CONTRIBUTIONS PS 8,54214,458004,489(4,489.00)0.004,4890000.00 001-192-522.110OTHER PENSION CONTRIBUTIONS171,940193,278171,900171,9000171,900.000.00193,278193,280193,28021,38012.44 Page 57 of 79 001-192-523.101LIFE/HEALTH INSURANCE373,415383,541406,400406,400323,82382,577.000.80400,000533,450506,15099,75024.54 001-192-523.105HSA - HEALTH SAVINGS ACCOUNT6132,8333,0603,0603,456(396.00)1.134,8574,5504,5501,49048.69 001-192-523.105-9HSA - HEALTH SAVINGS ACCOUNT 4470044(44.00)0.00440000.00 001-192-524.100WORKERS' COMP INSURANCE93,95589,049104,600104,60095,3439,257.000.9195,344132,200125,00020,40019.50 001-192-525.100UNEMPLOYMENT COMPENSATION2,0022740000.000.0000000.00 TOTAL EXPENDITURE3,416,9883,598,4023,538,0403,538,0402,696,336841,704.0011.853,612,9824,111,1153,858,265320,2259.05 PERSONAL SERVICES3,416,9883,598,4023,538,0403,538,0402,696,336841,704.0011.853,612,9824,111,1153,858,265320,2259.05 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 17 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE Totals for dept 192 - FIRE CONTROL4,020,4294,504,3894,172,2956,058,7593,099,9292,958,830.0031.254,248,5584,780,8884,519,238(1,539,521)(25.41) Dept 210 - PUBLIC WORKS OPERATING EXPENDITURES/EXPENSE Expenditure 001-210-531.302ENGINEERING SERVICES1,06916,05510,00010,0006,1003,900.000.6110,00030,00030,00020,000200.00 001-210-534.300OTHER CONTRACTUAL SERVICES03,6794,5004,5002,6401,860.000.594,5007,0007,0002,50055.56 001-210-540.300TRAVEL & PER DIEM0111001000100.000.0010010010000.00 001-210-541.300COMMUNICATION SERVICES7,5467,0348,0008,0005,2122,788.000.658,0008,0008,00000.00 001-210-543.300UTILITY SERVICES151,925140,606170,000170,00077,12692,874.000.45170,000172,300172,3002,3001.35 001-210-543.301STREET LIGHTS143,479145,340145,000145,000112,18732,813.000.77145,000146,900146,9001,9001.31 001-210-544.301OPERATING LEASES1,3301,1801,5001,5001,094406.000.731,5001,5001,50000.00 001-210-544.304FEC LEASE19,14519,27021,52521,52520,5161,009.000.9521,5252,26021,485(40)(0.19) 001-210-545.300INSURANCE17,56212,2238,9608,9608,506454.000.958,96010,03610,0361,07612.01 001-210-546.301OFFICE EQUIP/REPAIR & MAINT0110000.000.0000000.00 001-210-546.302VEHICLE REPAIR & MAINTENANCE6,1699,14610,00012,00010,0951,905.000.8410,00012,00012,00000.00 001-210-546.303BUILDING REPAIR & MAINT53,479127,521135,000135,000113,05521,945.000.84135,000135,000135,00000.00 001-210-546.305PATHWAY MAINTENANCE59,91010,99720,00018,00010,4877,513.000.5820,00020,00020,0002,00011.11 001-210-546.306GENERAL MAINTENANCE21,12661,72453,00053,00022,58730,413.000.4353,00053,00053,00000.00 001-210-546.309LANDSCAPE & IRRIGATION MAINT179,048227,981245,000245,000169,61275,388.000.69245,000235,000235,000(10,000)(4.08) 001-210-546.310EQUIPMENT REPAIR & MAINT9,39710,0287,3007,3007,067233.000.977,3008,5008,5001,20016.44 001-210-546.320COMPUTER SYSTEM MAINT & SUP3,1713,1322,0002,0009311,069.000.472,0004,3824,3822,382119.10 001-210-546.340R & M BRIDGE1766,9498,0008,0002,1935,807.000.278,0008,0008,00000.00 001-210-546.350R & M - ROADS55,47533,22630,00030,0008,89121,109.000.3030,00030,00030,00000.00 001-210-549.300OTHER MISC CHGS & OBLIGATION1,4951,1784,5004,5001684,332.000.044,5003,0003,000(1,500)(33.33) 001-210-549.304LICENSES, FEES & PERMITS1,2571,2782,0002,0001,339661.000.672,0002,0002,00000.00 001-210-551.300OFFICE SUPPLIES & EQUIPMENT5378742,0002,0005931,407.000.302,0002,0002,00000.00 001-210-551.400JANITORIAL SUPPLIES5,6862,90511,50011,5007,2164,284.000.6311,50012,50012,5001,0008.70 001-210-551.400-9JANITORIAL SUPPLIES COVID-1931,7116,6840000.000.0000000.00 001-210-552.301GAS & OIL3,8684,0086,0006,0003,4792,521.000.586,00010,00010,0004,00066.67 001-210-552.302SMALL TOOLS AND EQUIPMENT3,7156,7536,0006,0002,8893,111.000.486,0006,0006,00000.00 001-210-552.305UNIFORMS2,8022,7684,0004,0003,733267.000.934,0004,0004,00000.00 001-210-552.310-9DISASTER RELIEF - COVID-191896410000.000.0000000.00 001-210-553.301ROAD SIGNS7,3623,3194,0004,0003,438562.000.864,0004,0004,00000.00 001-210-554.301PERSONNEL TRAINING3,0002,1004,5004,50004,500.000.004,5004,0004,000(500)(11.11) 001-210-563.600MISC PROJECTS9,284030,00030,00020,0619,939.000.6718,04556,00056,00026,00086.67 TOTAL EXPENDITURE800,913868,621954,385954,385621,215333,170.0016.24942,430987,4781,006,70352,3185.48 OPERATING EXPENDITURES/EXPENSE800,913868,621954,385954,385621,215333,170.0016.24942,430987,4781,006,70352,3185.48 CAPITAL OUTLAY Expenditure 001-210-664.600MACH/EQUIPMENT5,36507,5007,5007,5000.001.007,5009,0009,0001,50020.00 TOTAL EXPENDITURE5,36507,5007,5007,5000.001.007,5009,0009,0001,50020.00 CAPITAL OUTLAY5,36507,5007,5007,5000.001.007,5009,0009,0001,50020.00 PERSONAL SERVICES Page 58 of 79 Expenditure 001-210-512.100REGULAR SALARIES & WAGES324,960347,105380,050380,050279,392100,658.000.74369,281389,380381,7751,7250.45 001-210-514.100OVERTIME3,2407,11710,0009,7834,2665,517.000.449,7838,0008,000(1,783)(18.23) 001-210-515.103BONUS PAY PLAN2007501,1301,1301,1255.001.001,1251,4001,40027023.89 001-210-515.106CLOTHING & BOOT ALLOWANCE900650650650775(125.00)1.1977577577512519.23 001-210-515.108AUTO ALLOWANCE2,2043,6003,6003,6002,769831.000.773,6003,6003,60000.00 001-210-515.120CELL PHONE ALLOWANCE0000923(923.00)0.001,2001,2001,2001,2000.00 001-210-516.100COMPENSATED ABSENCES2,8290002,753(2,753.00)0.002,7530000.00 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 18 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE 001-210-521.101FICA TAXES19,98321,63624,00024,00017,6486,352.000.7424,00024,50024,00000.00 001-210-521.102MEDICARE TAXES4,6745,0605,6005,6004,1271,473.000.745,6005,8005,60000.00 001-210-522.102VOT PENSION CONTRIBUTIONS GE35,26038,40236,70036,70026,8469,854.000.7335,40032,90032,225(4,475)(12.19) 001-210-523.101LIFE/HEALTH INSURANCE81,88085,00492,70092,70067,47425,226.000.7382,000101,400101,3558,6559.34 001-210-524.100WORKERS' COMP INSURANCE29,41026,00430,60030,60027,8182,782.000.9127,81934,10033,4002,8009.15 001-210-525.100UNEMPLOYMENT COMPENSATION2,59700217272(55.00)1.2527200(217)(100.00) TOTAL EXPENDITURE508,137535,328585,030585,030436,188148,842.009.22563,608603,055593,3308,3001.42 PERSONAL SERVICES508,137535,328585,030585,030436,188148,842.009.22563,608603,055593,3308,3001.42 Totals for dept 210 - PUBLIC WORKS1,314,4151,403,9491,546,9151,546,9151,064,903482,012.0026.471,513,5381,599,5331,609,03362,1184.02 Dept 231 - LEISURE SERVICES OPERATING EXPENDITURES/EXPENSE Expenditure 001-231-526.105EMPLOYEE PHYSICAL/PSYCOLOG1611265005000500.000.00000(500)(100.00) 001-231-531.324GRANTS ACQUISTION & ADMIN4,5003,50014,50014,500014,500.000.00000(14,500)(100.00) 001-231-531.324-4GRANTS ACQUISTION & ADMIN0010,00010,000010,000.000.00000(10,000)(100.00) 001-231-534.300OTHER CONTRACTUAL SERVICES4,000013,80013,8003,30710,493.000.2413,80055,00055,00041,200298.55 001-231-534.300-4OTHER CONTRACTUAL SERVICES0075,00075,000075,000.000.00000(75,000)(100.00) 001-231-534.303SPECIAL EVENTS56,58656,24050,00050,00050,828(828.00)1.0250,828100,000100,00050,000100.00 001-231-540.300TRAVEL & PER DIEM000000.000.0001,5001,5001,5000.00 001-231-541.300COMMUNICATION SERVICES10,90013,75114,50014,5009,1895,311.000.6310,94311,10011,100(3,400)(23.45) 001-231-541.301POSTAGE16513003(3.00)0.0030000.00 001-231-543.300UTILITY SERVICES17,2069,60322,80022,80021,0221,778.000.9229,18751,92051,92029,120127.72 001-231-544.303OFFICE LEASE014,5508,1008,1006,2251,875.000.776,22500(8,100)(100.00) 001-231-545.300INSURANCE21,41912,59964,78064,78059,8534,927.000.9259,56848,94748,947(15,833)(24.44) 001-231-546.302VEHICLE REPAIR & MAINTENANCE8731,3172,0002,0001,034966.000.521,9892,0002,00000.00 001-231-546.303BUILDING REPAIR & MAINT11,4908,29523,80023,80017,7636,037.000.7523,80024,00024,0002000.84 001-231-546.306GENERAL MAINTENANCE42,62560,59840,00040,00039,037963.000.9840,00050,00050,00010,00025.00 001-231-546.310EQUIPMENT REPAIR & MAINT4522321,7001,7001121,588.000.071,7002,0002,00030017.65 001-231-546.320COMPUTER SYSTEM MAINT & SUP3,5661,1192,9002,9008,707(5,807.00)3.007,2009,6009,6006,700231.03 001-231-549.201ADVERTISING & PROMOTION6,6877,0677,2007,2003,4233,777.000.482,0009,0009,0001,80025.00 001-231-549.300OTHER MISC CHGS & OBLIGATION1,00102,0002,0003,349(1,349.00)1.672,5002,0002,00000.00 001-231-549.304LICENSES, FEES & PERMITS4,0713,7524,5004,5002,2612,239.000.502,3624,5504,550501.11 001-231-549.332RECREATION PROGRAM EXPENSE34,97137,70840,00040,00053,434(13,434.00)1.3451,99556,40056,40016,40041.00 001-231-549.333SPRING/SUMMER CAMP8,17905,0005,00005,000.000.00000(5,000)(100.00) 001-231-549.334PROGRAM FEES-INSTRUCTORS0000911(911.00)0.00025,00025,00025,0000.00 001-231-549.335BUSINESS OUTREACH PROG0060,000000.000.0000000.00 001-231-549.335-9BUSINESS OUTREACH PROG00060,0006,40753,593.000.1110,00010,00010,000(50,000)(83.33) 001-231-549.395CREDIT CARD FEES AND CHARGE00001(1.00)0.0000000.00 001-231-551.300OFFICE SUPPLIES & EQUIPMENT8632002,0002,0002,222(222.00)1.112,5002,5002,50050025.00 001-231-552.301GAS & OIL6421,2312,5002,5001,4711,029.000.592,5003,0003,00050020.00 001-231-552.302SMALL TOOLS AND EQUIPMENT8191271,5001,50001,500.000.001,5001,5001,50000.00 001-231-552.305UNIFORMS01753003000300.000.00300800800500166.67 001-231-552.310-9DISASTER RELIEF - COVID-19 71800000.000.0000000.00 001-231-554.301PERSONNEL TRAINING000000.000.0002,0002,0002,0000.00 001-231-563.600MISC PROJECTS000000.000.00020,00020,00020,0000.00 TOTAL EXPENDITURE231,894232,203469,380469,380290,559178,821.0015.61320,900492,817492,81723,4374.99 Page 59 of 79 OPERATING EXPENDITURES/EXPENSE231,894232,203469,380469,380290,559178,821.0015.61320,900492,817492,81723,4374.99 CAPITAL OUTLAY Expenditure 001-231-663.600-4IMPROVEMENTS OTHER THAN BLD035,0000000.000.0000000.00 001-231-664.601-9COMPUTER EQUIPMENT COVID-191,62400000.000.0000000.00 TOTAL EXPENDITURE1,62435,0000000.000.0000000.00 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 19 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE CAPITAL OUTLAY1,62435,0000000.000.0000000.00 PERSONAL SERVICES Expenditure 001-231-512.100REGULAR SALARIES & WAGES207,594213,791269,700277,100205,94171,159.000.74275,687298,450299,10522,0057.94 001-231-514.100OVERTIME0000384(384.00)0.003840000.00 001-231-515.103BONUS PAY PLAN3,1503,1503,1503,1503,1500.001.003,1503,6503,65050015.87 001-231-515.106CLOTHING & BOOT ALLOWANCE12512515015012525.000.8312515015000.00 001-231-515.107PART-TIME SALARIES45,81533,32042,40076,40033,05143,349.000.4376,400121,394121,05044,65058.44 001-231-515.108AUTO ALLOWANCE3,0993,0003,0003,0002,308692.000.773,0003,0003,00000.00 001-231-515.109SEASONAL SALARIES & WAGES02,8353,0003,00003,000.000.00000(3,000)(100.00) 001-231-515.120CELL PHONE ALLOWANCE1,8901,9001,2001,200923277.000.771,2001,2001,20000.00 001-231-516.100COMPENSATED ABSENCES2,0827,5063,5003,5002,940560.000.848,0008,5008,5005,000142.86 001-231-521.101FICA TAXES15,32415,31119,10019,90015,2414,659.000.7719,90026,80026,7506,85034.42 001-231-521.102MEDICARE TAXES3,5843,5814,5004,7003,5641,136.000.764,7006,3006,3001,60034.04 001-231-522.102VOT PENSION CONTRIBUTIONS GE22,58023,64526,10026,90019,8637,037.000.7426,60525,20025,250(1,650)(6.13) 001-231-523.101LIFE/HEALTH INSURANCE53,28657,02384,20075,00042,22132,779.000.5651,15059,10059,100(15,900)(21.20) 001-231-524.100WORKERS' COMP INSURANCE11,6508,75212,70012,70011,4651,235.000.9011,46618,10018,8006,10048.03 001-231-525.100UNEMPLOYMENT COMPENSATION1,1952230000.000.0000000.00 TOTAL EXPENDITURE371,374374,162472,700506,700341,176165,524.009.12481,767571,844572,85566,15513.06 PERSONAL SERVICES371,374374,162472,700506,700341,176165,524.009.12481,767571,844572,85566,15513.06 Totals for dept 231 - LEISURE SERVICES604,892641,365942,080976,080631,735344,345.0024.72802,6671,064,6611,065,67289,5929.18 Dept 700 - DEBT SERVICE D/S - PRINCIPAL Expenditure 001-700-571.702COMP EQUIP-PRIN-SAN PROJ0055,25055,25055,20347.001.0055,20356,15056,1509001.63 001-700-571.7062002 NOTE PAYABLE -PS BDG334,196348,783364,050364,050271,54392,507.000.75364,05000(364,050)(100.00) 001-700-571.708P/S - PRIN - SUNTRUST - PUMPE43,45444,73246,05046,05046,0473.001.0046,04747,45047,4501,4003.04 001-700-571.710P/S PRIN - PD VEHICLES49029,96350,52050,52036,83813,682.000.7349,09549,10049,100(1,420)(2.81) 001-700-571.714PRIN - PD EQUIPMENT6,6206,6206,6506,65006,650.000.006,62000(6,650)(100.00) 001-700-571.727LEASE PRIN - SCVA FIRE EQUIP27,30000000.000.0000000.00 001-700-571.731PRIN-2021 NOTE-REC CENTER00197,000197,000197,0000.001.00197,000288,000288,00091,00046.19 TOTAL EXPENDITURE412,060430,098719,520719,520606,631112,889.004.47718,015440,700440,700(278,820)(38.75) D/S - PRINCIPAL412,060430,098719,520719,520606,631112,889.004.47718,015440,700440,700(278,820)(38.75) D/S - INTEREST Expenditure 001-700-572.702COMP EQUIP-INT-SAN PROJ002,8502,8502,81238.000.992,8131,9001,900(950)(33.33) 001-700-572.7062002 NOTE PAYABLE - PS BLDG38,30623,7188,5008,5007,834666.000.928,50000(8,500)(100.00) 001-700-572.708P/S - SUNTRUST - PUMPER5,3404,0622,7502,7502,7473.001.002,7481,4001,400(1,350)(49.09) 001-700-572.710INTEREST - PD VEHICLES2152,6764,5604,5603,4371,123.000.754,5814,6004,600400.88 001-700-572.727LEASE INT. - SCVA - FIRE EQUI19700000.000.0000000.00 001-700-572.731INT-2021 NOTE-REC CENTER029,206148,100148,100148,05545.001.00148,055142,800142,800(5,300)(3.58) TOTAL EXPENDITURE44,05859,662166,760166,760164,8851,875.004.66166,697150,700150,700(16,060)(9.63) Page 60 of 79 D/S - INTEREST44,05859,662166,760166,760164,8851,875.004.66166,697150,700150,700(16,060)(9.63) Totals for dept 700 - DEBT SERVICE456,118489,760886,280886,280771,516114,764.009.13884,712591,400591,400(294,880)(33.27) Dept 900 - INTERFUND TRANSFERS INTERFUND TRANSFERS OUT Expenditure 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 20 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE 001-900-591.301TRSF TO CAPITAL IMP FUND173,585460,110677,260677,2600677,260.000.00693,843707,686707,68630,4264.49 001-900-591.303TRSF TO CAPITAL PROJECTS FUN0208,0500000.000.0000207,667207,6670.00 001-900-591.403TRSF TO STORMWATER UTILITIES00150,000188,5650188,565.000.00188,565300,000300,000111,43559.10 TOTAL EXPENDITURE173,585668,160827,260865,8250865,825.000.00882,4081,007,6861,215,353349,52840.37 INTERFUND TRANSFERS OUT173,585668,160827,260865,8250865,825.000.00882,4081,007,6861,215,353349,52840.37 Totals for dept 900 - INTERFUND TRANSFERS173,585668,160827,260865,8250865,825.000.00882,4081,007,6861,215,353349,52840.37 Dept 950 - OTHER NONOPERATING OTHER FINANCING SOURCES & USES Transfers-Out 001-950-999.001SUSPENSE(29)00000.000.0000000.00 TOTAL TRANSFERS-OUT(29)00000.000.0000000.00 Expenditure 001-950-590.001ALLOCATE TO FUND BALANCE0099,52099,520099,520.000.0000324,537225,017226.10 TOTAL EXPENDITURE0099,52099,520099,520.000.0000324,537225,017226.10 OTHER FINANCING SOURCES & USES(29)099,52099,520099,520.000.0000324,537225,017226.10 Totals for dept 950 - OTHER NONOPERATING(29)099,52099,520099,520.000.0000324,537225,017226.10 TOTAL APPROPRIATIONS12,433,97613,956,87415,277,97017,257,09810,417,3816,839,717.00232.0515,012,27815,938,16816,058,248(1,198,850)(6.95) NET OF REVENUES/APPROPRIATIONS - FUND 001875,1692,811,908002,555,5822,555,582.00286.81923,573(452,906)000.00 Fund 101 - BUILDING FUND ESTIMATED REVENUES Dept 000 - GENERAL GRANTS FEDERAL Revenue 101-000-331.200FED GRANT - COVID-1901,8130000.000.0000000.00 TOTAL REVENUE01,8130000.000.0000000.00 GRANTS FEDERAL01,8130000.000.0000000.00 CHGS FOR SERV - GEN GOV Revenue 101-000-341.105ADMIN FEES FROM OTHER GOV'TS21531,554006,940(6,940.00)0.001,1050000.00 TOTAL REVENUE21531,554006,940(6,940.00)0.001,1050000.00 CHGS FOR SERV - GEN GOV21531,554006,940(6,940.00)0.001,1050000.00 MISCELLANEOUS REVENUES Revenue 101-000-369.000OTHER MISCELLANEOUS REVENU5500000.000.0000000.00 TOTAL REVENUE5500000.000.0000000.00 Page 61 of 79 MISCELLANEOUS REVENUES5500000.000.0000000.00 Totals for dept 000 - GENERAL27033,367006,940(6,940.00)0.001,1050000.00 Dept 180 - BUILDING & ZONING LICENSES & PERMITS Revenue 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 21 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE 101-180-322.000BUILDING PERMIT FEES382,639868,665500,000700,000579,449120,551.000.83620,351601,323601,323(98,677)(14.10) 101-180-329.110PARTIAL AND RE-INSPECTION2,5542,5703,0003,0002,100900.000.702,0002,7922,792(208)(6.93) TOTAL REVENUE385,193871,235503,000703,000581,549121,451.001.53622,351604,115604,115(98,885)(14.07) LICENSES & PERMITS385,193871,235503,000703,000581,549121,451.001.53622,351604,115604,115(98,885)(14.07) MISCELLANEOUS REVENUES Revenue 101-180-369.000OTHER MISCELLANEOUS REVENU000056(56.00)0.00560000.00 TOTAL REVENUE000056(56.00)0.00560000.00 MISCELLANEOUS REVENUES000056(56.00)0.00560000.00 Totals for dept 180 - BUILDING & ZONING385,193871,235503,000703,000581,605121,395.001.53622,407604,115604,115(98,885)(14.07) Dept 950 - OTHER NONOPERATING UNRESTRICTED INVESTMENT EARNIN Revenue 101-950-361.100INTEREST/INVESTMENT EARNINGS2,8211,1351,4001,400822578.000.591,0003,0003,0001,600114.29 TOTAL REVENUE2,8211,1351,4001,400822578.000.591,0003,0003,0001,600114.29 UNRESTRICTED INVESTMENT EARNIN2,8211,1351,4001,400822578.000.591,0003,0003,0001,600114.29 Totals for dept 950 - OTHER NONOPERATING2,8211,1351,4001,400822578.000.591,0003,0003,0001,600114.29 Dept 990 - OTHER/RESERVE/CONTINGENCY OTHER FINANCING SOURCES Revenue 101-990-399.999APPROPRIATE FUND BALANCE00171,860171,8600171,860.000.0000242,63970,77941.18 TOTAL REVENUE00171,860171,8600171,860.000.0000242,63970,77941.18 OTHER FINANCING SOURCES00171,860171,8600171,860.000.0000242,63970,77941.18 Totals for dept 990 - OTHER/RESERVE/CONTINGEN00171,860171,8600171,860.000.0000242,63970,77941.18 TOTAL ESTIMATED REVENUES388,284905,737676,260876,260589,367286,893.002.11624,512607,115849,754(26,506)(3.02) APPROPRIATIONS Dept 180 - BUILDING & ZONING OPERATING EXPENDITURES/EXPENSE Expenditure 101-180-531.301LEGAL SERVICES19,0668754,0004,0003,423577.000.864,0004,0004,00000.00 101-180-531.325INSPECTION SERVICES20,79424,97525,00030,00040,790(10,790.00)1.3675,00050,00050,00020,00066.67 101-180-534.300OTHER CONTRACTUAL SERVICES25,68105,000000.000.0005,0005,0005,0000.00 101-180-540.300TRAVEL & PER DIEM1,3313,1513,0003,0008332,167.000.283,0004,0004,0001,00033.33 101-180-541.300COMMUNICATION SERVICES6,1225,7495,0505,0503,9911,059.000.795,0506,0006,00095018.81 101-180-541.301POSTAGE5634371,6001,6004111,189.000.261,6001,6001,60000.00 101-180-543.300UTILITY SERVICES5,6876,3077,6007,6004,6052,995.000.617,6007,6007,60000.00 Page 62 of 79 101-180-544.301OPERATING LEASES1,3501,1372,3002,3001,462838.000.642,3002,6002,60030013.04 101-180-545.300INSURANCE5561,2388,2508,2507,470780.000.918,2509,8659,8651,61519.58 101-180-546.301OFFICE EQUIP/REPAIR & MAINT1,1469901,1501,150234916.000.201,1501,2001,200504.35 101-180-546.302VEHICLE REPAIR & MAINT806446700700279421.000.407001,0001,00030042.86 101-180-546.303BUILDING REPAIR & MAINT00046,00012,64433,356.000.2730,0005,0005,000(41,000)(89.13) 101-180-546.320COMPUTER SYSTEM MAINT & SUP10,59915,70419,70019,70018,0931,607.000.9219,70018,73418,734(966)(4.90) 101-180-547.300PRINTING & BINDING1703,4161,0001,0001,075(75.00)1.081,0001,1001,10010010.00 101-180-549.300OTHER MISC CHGS & OBLIGATION9091,3872,3002,3003141,986.000.142,3002,5002,5002008.70 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 22 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE 101-180-549.301ADMIN MGMT FEES104,100100,002106,020106,020106,0137.001.00106,013107,655107,6551,6351.54 101-180-549.304LICENSES, FEES & PERMITS1,4809553,0003,0001,0921,908.000.363,0003,0003,00000.00 101-180-549.395CREDIT CARD FEES AND CHARGE8,98710,1337,0007,0008,834(1,834.00)1.2610,00010,00010,0003,00042.86 101-180-551.300OFFICE SUPPLIES & EQUIPMENT3,6952,9555,0005,0002,0672,933.000.415,0005,0005,00000.00 101-180-552.301GAS & OIL299326750750349401.000.47750800800506.67 101-180-552.305UNIFORMS1,4621,4781,5001,5001,076424.000.721,5002,0002,00050033.33 101-180-552.310-9DISASTER RELIEF - COVID-19 14500000.000.0000000.00 101-180-554.300BOOKS, PUBL, SUBS & MEMBERSH3,2513,0843,0003,0003,042(42.00)1.013,0004,0004,0001,00033.33 101-180-554.301PERSONNEL TRAINING4,6902,2093,2003,2001,9621,238.000.613,9003,9003,90070021.88 TOTAL EXPENDITURE222,889186,954216,120262,120220,05942,061.0014.54294,813256,554256,554(5,566)(2.12) OPERATING EXPENDITURES/EXPENSE222,889186,954216,120262,120220,05942,061.0014.54294,813256,554256,554(5,566)(2.12) CAPITAL OUTLAY Expenditure 101-180-664.601COMPUTER EQUIPMENT19,51644,8470000.000.0000000.00 101-180-664.601-9COMPUTER EQUIPMENT COVID-191,69800000.000.0000000.00 101-180-664.602VEHICLES00040,000040,000.000.000033,000(7,000)(17.50) 101-180-664.607EQUIPMENT - TECH07,5170000.000.0000000.00 TOTAL EXPENDITURE21,21452,364040,000040,000.000.000033,000(7,000)(17.50) CAPITAL OUTLAY21,21452,364040,000040,000.000.000033,000(7,000)(17.50) PERSONAL SERVICES Expenditure 101-180-512.100REGULAR SALARIES & WAGES323,075317,695333,490363,490262,583100,907.000.72359,555397,577407,65044,16012.15 101-180-514.100OVERTIME504000259(259.00)0.002590000.00 101-180-515.103BONUS PAY PLAN1,3001,0001,2501,2501,2500.001.001,2501,5001,50025020.00 101-180-515.108AUTO ALLOWANCE3,0993,0003,0003,0002,308692.000.773,0003,0003,00000.00 101-180-515.120CELL PHONE ALLOWANCE10000000.000.0000000.00 101-180-516.100COMPENSATED ABSENCES006,000000.000.0006,0006,0006,0000.00 101-180-521.101FICA TAXES19,75719,46221,00021,00016,0884,912.000.7721,00024,96025,6004,60021.90 101-180-521.102MEDICARE TAXES4,6214,5524,9004,9003,7631,137.000.774,9005,8406,0001,10022.45 101-180-522.102VOT PENSION CONTRIBUTIONS GE35,14534,73232,20032,20024,3717,829.000.7633,40833,55034,4002,2006.83 101-180-523.101LIFE/HEALTH INSURANCE52,95151,83754,10054,10046,4517,649.000.8657,03069,72569,75015,65028.93 101-180-524.100WORKERS' COMP INSURANCE3,4503,5844,2004,2003,753447.000.893,7544,8006,3002,10050.00 TOTAL EXPENDITURE444,002435,862460,140484,140360,826123,314.006.53484,156546,952560,20076,06015.71 PERSONAL SERVICES444,002435,862460,140484,140360,826123,314.006.53484,156546,952560,20076,06015.71 Totals for dept 180 - BUILDING & ZONING688,105675,180676,260786,260580,885205,375.0021.08778,969803,506849,75463,4948.08 Dept 900 - INTERFUND TRANSFERS INTERFUND TRANSFERS OUT Expenditure 101-900-591.001TRANSFER TO GENERAL FUND195,37810,1030000.000.0000000.00 TOTAL EXPENDITURE195,37810,1030000.000.0000000.00 INTERFUND TRANSFERS OUT195,37810,1030000.000.0000000.00 Page 63 of 79 Totals for dept 900 - INTERFUND TRANSFERS195,37810,1030000.000.0000000.00 Dept 950 - OTHER NONOPERATING OTHER FINANCING SOURCES & USES Expenditure 101-950-590.001ALLOCATE TO FUND BALANCE00090,000090,000.000.00000(90,000)(100.00) TOTAL EXPENDITURE00090,000090,000.000.00000(90,000)(100.00) 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 23 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE OTHER FINANCING SOURCES & USES00090,000090,000.000.00000(90,000)(100.00) Totals for dept 950 - OTHER NONOPERATING00090,000090,000.000.00000(90,000)(100.00) TOTAL APPROPRIATIONS883,483685,283676,260876,260580,885295,375.0021.08778,969803,506849,754(26,506)(3.02) NET OF REVENUES/APPROPRIATIONS - FUND 101(495,199)220,454008,4828,482.0023.19(154,457)(196,391)000.00 Fund 301 - CAPITAL IMPROVEMENT FUND ESTIMATED REVENUES Dept 900 - INTERFUND TRANSFERS TRANSFERS IN Revenue 301-900-381.001TRANSFER FROM GENERAL FUND173,585460,110677,260677,2600677,260.000.00693,843707,686707,68630,4264.49 TOTAL REVENUE173,585460,110677,260677,2600677,260.000.00693,843707,686707,68630,4264.49 TRANSFERS IN173,585460,110677,260677,2600677,260.000.00693,843707,686707,68630,4264.49 Totals for dept 900 - INTERFUND TRANSFERS173,585460,110677,260677,2600677,260.000.00693,843707,686707,68630,4264.49 Dept 950 - OTHER NONOPERATING UNRESTRICTED INVESTMENT EARNIN Revenue 301-950-361.100INTEREST/INVESTMENT EARNINGS3,4843471,0001,00087913.000.095700(1,000)(100.00) TOTAL REVENUE3,4843471,0001,00087913.000.095700(1,000)(100.00) UNRESTRICTED INVESTMENT EARNIN3,4843471,0001,00087913.000.095700(1,000)(100.00) Totals for dept 950 - OTHER NONOPERATING3,4843471,0001,00087913.000.095700(1,000)(100.00) Dept 990 - OTHER/RESERVE/CONTINGENCY OTHER FINANCING SOURCES Revenue 301-990-399.999APPROPRIATE FUND BALANCE0087,000117,5850117,585.000.000573,736510,436392,851334.10 TOTAL REVENUE0087,000117,5850117,585.000.000573,736510,436392,851334.10 OTHER FINANCING SOURCES0087,000117,5850117,585.000.000573,736510,436392,851334.10 Totals for dept 990 - OTHER/RESERVE/CONTINGEN0087,000117,5850117,585.000.000573,736510,436392,851334.10 TOTAL ESTIMATED REVENUES177,069460,457765,260795,84587795,758.000.09693,9001,281,4221,218,122422,27753.06 APPROPRIATIONS Dept 210 - PUBLIC WORKS OPERATING EXPENDITURES/EXPENSE Expenditure Page 64 of 79 301-210-546.350R & M - ROADS08,7520000.000.00177,665773,285773,285773,2850.00 301-210-546.350-9R & M - ROADS000340,840160,779180,061.000.47000(340,840)(100.00) 301-210-553.301ROAD SIGNS07,6160000.000.0000000.00 TOTAL EXPENDITURE016,3680340,840160,779180,061.000.47177,665773,285773,285432,445126.88 OPERATING EXPENDITURES/EXPENSE016,3680340,840160,779180,061.000.47177,665773,285773,285432,445126.88 CAPITAL OUTLAY 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 24 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE Expenditure 301-210-663.652PATHWAY/SIDEWALK IMPROVEME173,014126,45860,00060,00059,112888.000.9959,11275,00075,00015,00025.00 301-210-663.657ROADWAY IMPROVEMENTS00359,590018,750(18,750.00)0.0000000.00 301-210-663.657-9ROADWAY IMPROVEMENTS00018,750018,750.000.0018,75000(18,750)(100.00) TOTAL EXPENDITURE173,014126,458419,59078,75077,862888.000.9977,86275,00075,000(3,750)(4.76) CAPITAL OUTLAY173,014126,458419,59078,75077,862888.000.9977,86275,00075,000(3,750)(4.76) Totals for dept 210 - PUBLIC WORKS173,014142,826419,590419,590238,641180,949.001.46255,527848,285848,285428,695102.17 Dept 230 - PARKS OPERATING EXPENDITURES/EXPENSE Expenditure 301-230-534.300-4OTHER CONTRACTUAL SERVICES03,6000000.000.0000000.00 TOTAL EXPENDITURE03,6000000.000.0000000.00 OPERATING EXPENDITURES/EXPENSE03,6000000.000.0000000.00 Totals for dept 230 - PARKS03,6000000.000.0000000.00 Dept 315 - TEQUESTA DRIVE (BRIDGE) OPERATING EXPENDITURES/EXPENSE Expenditure 301-315-546.340R & M BRIDGE083,3950000.000.0000000.00 TOTAL EXPENDITURE083,3950000.000.0000000.00 OPERATING EXPENDITURES/EXPENSE083,3950000.000.0000000.00 Totals for dept 315 - TEQUESTA DRIVE (BRIDGE)083,3950000.000.0000000.00 Dept 399 - MISC PROJ-GENERAL CAPITAL OUTLAY Expenditure 301-399-663.655LANDSCAPING000000.000.00075,00075,00075,0000.00 301-399-664.600MACH/EQUIPMENT129,00800000.000.000358,137294,837294,8370.00 TOTAL EXPENDITURE129,00800000.000.000433,137369,837369,8370.00 CAPITAL OUTLAY129,00800000.000.000433,137369,837369,8370.00 Totals for dept 399 - MISC PROJ-GENERAL129,00800000.000.000433,137369,837369,8370.00 Dept 900 - INTERFUND TRANSFERS INTERFUND TRANSFERS OUT Expenditure 301-900-591.303TRSF TO CAPITAL PROJECTS FUN0196,00087,000117,5850117,585.000.00117,58500(117,585)(100.00) TOTAL EXPENDITURE0196,00087,000117,5850117,585.000.00117,58500(117,585)(100.00) INTERFUND TRANSFERS OUT0196,00087,000117,5850117,585.000.00117,58500(117,585)(100.00) Page 65 of 79 Totals for dept 900 - INTERFUND TRANSFERS0196,00087,000117,5850117,585.000.00117,58500(117,585)(100.00) Dept 910 - OTHER FINANCING SOURCES & USES OTHER FINANCING SOURCES & USES Expenditure 301-910-590.001ALLOCATE TO FUND BALANCE00258,670258,6700258,670.000.00320,78800(258,670)(100.00) TOTAL EXPENDITURE00258,670258,6700258,670.000.00320,78800(258,670)(100.00) 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 25 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE OTHER FINANCING SOURCES & USES00258,670258,6700258,670.000.00320,78800(258,670)(100.00) Totals for dept 910 - OTHER FINANCING SOURCES & 00258,670258,6700258,670.000.00320,78800(258,670)(100.00) TOTAL APPROPRIATIONS302,022425,821765,260795,845238,641557,204.001.46693,9001,281,4221,218,122422,27753.06 NET OF REVENUES/APPROPRIATIONS - FUND 301(124,953)34,63600(238,554)(238,554.00)1.5400000.00 Fund 303 - CAPITAL PROJECTS FUND ESTIMATED REVENUES Dept 000 - GENERAL OTHER FINANCING SOURCES Revenue 303-000-384.001PROCEEDS FROM LOC06,890,0000000.000.0000000.00 TOTAL REVENUE06,890,0000000.000.0000000.00 OTHER FINANCING SOURCES06,890,0000000.000.0000000.00 Totals for dept 000 - GENERAL06,890,0000000.000.0000000.00 Dept 900 - INTERFUND TRANSFERS TRANSFERS IN Revenue 303-900-381.001TRANSFER FROM GENERAL FUND0208,0500000.000.0000207,667207,6670.00 303-900-381.301TRANSFER-IN FROM CAP IMPROVE0196,00087,000117,5850117,585.000.00117,58500(117,585)(100.00) TOTAL REVENUE0404,05087,000117,5850117,585.000.00117,5850207,66790,08276.61 TRANSFERS IN0404,05087,000117,5850117,585.000.00117,5850207,66790,08276.61 Totals for dept 900 - INTERFUND TRANSFERS0404,05087,000117,5850117,585.000.00117,5850207,66790,08276.61 Dept 950 - OTHER NONOPERATING UNRESTRICTED INVESTMENT EARNIN Revenue 303-950-361.100INTEREST/INVESTMENT EARNINGS04,133500500634(134.00)1.2763400(500)(100.00) TOTAL REVENUE04,133500500634(134.00)1.2763400(500)(100.00) UNRESTRICTED INVESTMENT EARNIN04,133500500634(134.00)1.2763400(500)(100.00) Totals for dept 950 - OTHER NONOPERATING04,133500500634(134.00)1.2763400(500)(100.00) Dept 990 - OTHER/RESERVE/CONTINGENCY OTHER FINANCING SOURCES Revenue 303-990-399.999APPROPRIATE FUND BALANCE00254,5002,613,13802,613,138.000.00000(2,613,138)(100.00) TOTAL REVENUE00254,5002,613,13802,613,138.000.00000(2,613,138)(100.00) OTHER FINANCING SOURCES00254,5002,613,13802,613,138.000.00000(2,613,138)(100.00) Page 66 of 79 Totals for dept 990 - OTHER/RESERVE/CONTINGEN00254,5002,613,13802,613,138.000.00000(2,613,138)(100.00) TOTAL ESTIMATED REVENUES07,298,183342,0002,731,2236342,730,589.001.27118,2190207,667(2,523,556)(92.40) APPROPRIATIONS Dept 210 - PUBLIC WORKS 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 26 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE OPERATING EXPENDITURES/EXPENSE Expenditure 303-210-546.350R & M - ROADS0236,329255,000255,000255,0000.001.00255,00000(255,000)(100.00) TOTAL EXPENDITURE0236,329255,000255,000255,0000.001.00255,00000(255,000)(100.00) OPERATING EXPENDITURES/EXPENSE0236,329255,000255,000255,0000.001.00255,00000(255,000)(100.00) CAPITAL OUTLAY Expenditure 303-210-663.652PATHWAY/SIDEWALK IMPROVEME000000.000.0000170,000170,0000.00 TOTAL EXPENDITURE000000.000.0000170,000170,0000.00 CAPITAL OUTLAY000000.000.0000170,000170,0000.00 Totals for dept 210 - PUBLIC WORKS0236,329255,000255,000255,0000.001.00255,0000170,000(85,000)(33.33) Dept 231 - LEISURE SERVICES OPERATING EXPENDITURES/EXPENSE Expenditure 303-231-546.320-4COMPUTER SYSTEM MAINT & SUP00007,132(7,132.00)0.007,1320000.00 TOTAL EXPENDITURE00007,132(7,132.00)0.007,1320000.00 OPERATING EXPENDITURES/EXPENSE00007,132(7,132.00)0.007,1320000.00 CAPITAL OUTLAY Expenditure 303-231-662.600-4BUILDINGS04,175,55702,313,6852,029,599284,086.000.882,161,10700(2,313,685)(100.00) 303-231-663.600-4IMPROVEMENTS OTHER THAN BLD0100,0000000.000.0000000.00 303-231-663.632-4ARCHITECT & ENGINEERING-OTHE98,047250,045045,47337,4738,000.000.8245,11300(45,473)(100.00) 303-231-663.634-4SITE WORK/UTILLITY/LANDSCAPE012,423030,06532,621(2,556.00)1.0936,41300(30,065)(100.00) 303-231-664.603-4FURNITURE/FIXTURES/EQUIPMENT0087,00087,0005,82681,174.000.0745,12300(87,000)(100.00) TOTAL EXPENDITURE98,0474,538,02587,0002,476,2232,105,519370,704.002.852,287,75600(2,476,223)(100.00) CAPITAL OUTLAY98,0474,538,02587,0002,476,2232,105,519370,704.002.852,287,75600(2,476,223)(100.00) OTHER DEBT SERVICE Expenditure 303-231-573.700-4OTHER DEBT SERVICE COSTS030,0000000.000.0000000.00 TOTAL EXPENDITURE030,0000000.000.0000000.00 OTHER DEBT SERVICE030,0000000.000.0000000.00 Totals for dept 231 - LEISURE SERVICES98,0474,568,02587,0002,476,2232,112,651363,572.002.852,294,88800(2,476,223)(100.00) Dept 399 - MISC PROJ-GENERAL CAPITAL OUTLAY Expenditure 303-399-663.655LANDSCAPING000000.000.000037,66737,6670.00 TOTAL EXPENDITURE000000.000.000037,66737,6670.00 Page 67 of 79 CAPITAL OUTLAY000000.000.000037,66737,6670.00 Totals for dept 399 - MISC PROJ-GENERAL000000.000.000037,66737,6670.00 TOTAL APPROPRIATIONS98,0474,804,354342,0002,731,2232,367,651363,572.003.852,549,8880207,667(2,523,556)(92.40) NET OF REVENUES/APPROPRIATIONS - FUND 303(98,047)2,493,82900(2,367,017)(2,367,017.00)5.12(2,431,669)0000.00 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 27 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE Fund 401 - WATER FUND ESTIMATED REVENUES Dept 000 - GENERAL GRANTS FEDERAL Revenue 401-000-331.200FED GRANT - COVID-1903,5420000.000.0000000.00 TOTAL REVENUE03,5420000.000.0000000.00 GRANTS FEDERAL03,5420000.000.0000000.00 MISCELLANEOUS REVENUES Revenue 401-000-363.101MARTIN/TROPIC V-CONST PORTIO36,91635,09933,50033,50026,9126,588.000.8033,17732,35232,352(1,148)(3.43) 401-000-369.000OTHER MISCELLANEOUS REVENU7,71226,57715,00015,0003,61711,383.000.246,2007,5987,598(7,402)(49.35) 401-000-369.100INSURANCE REIMBURSEMENT1,3862,3980000.000.0000000.00 TOTAL REVENUE46,01464,07448,50048,50030,52917,971.001.0439,37739,95039,950(8,550)(17.63) MISCELLANEOUS REVENUES46,01464,07448,50048,50030,52917,971.001.0439,37739,95039,950(8,550)(17.63) FINES & FORFEITURES Revenue 401-000-354.101LOCAL ORDINANCE VIOLATION459000563(563.00)0.005630000.00 TOTAL REVENUE459000563(563.00)0.005630000.00 FINES & FORFEITURES459000563(563.00)0.005630000.00 OTHER FINANCING SOURCES Revenue 401-000-369.111CAPITAL CONNECT CHARGE - DEV81,131583,64515,00015,00082,969(67,969.00)5.53118,43236,75836,75821,758145.05 401-000-384.001PROCEEDS FROM LOC004,442,0004,442,00004,442,000.000.002,631,93110,855,00010,855,0006,413,000144.37 TOTAL REVENUE81,131583,6454,457,0004,457,00082,9694,374,031.005.532,750,36310,891,75810,891,7586,434,758144.37 OTHER FINANCING SOURCES81,131583,6454,457,0004,457,00082,9694,374,031.005.532,750,36310,891,75810,891,7586,434,758144.37 CHARGES FOR SERVICES Revenue 401-000-342.501SITE PLAN REVIEW FEES53825,9001,0001,00001,000.000.00006,1855,185518.50 401-000-343.301WATER SALES3,596,7213,349,8093,550,0003,550,0002,255,7931,294,207.000.643,513,3953,585,3603,650,360100,3602.83 401-000-343.302WATER- CONNECT CHARGES27,12244,84925,00025,00020,8694,131.000.8329,75032,77532,7757,77531.10 401-000-343.303WATER-FIRE PROTECTION CHARG79,86079,48087,00087,00061,63625,364.000.7182,07682,51082,510(4,490)(5.16) 401-000-343.304WATER SURCHARGE584,273544,654600,000600,000436,468163,532.000.73564,233593,921593,921(6,079)(1.01) 401-000-343.306MONTHLY SERVICE CHARGE1,976,1821,987,8472,050,0002,050,0001,616,464433,536.000.792,145,4202,096,4252,136,42586,4254.22 401-000-343.307PENALTY CHARGES20,62421,88330,00030,00085,385(55,385.00)2.8585,38532,58432,5842,5848.61 401-000-343.308OTHER WATER SERVICE INCOME3,6433,6323,5003,5003,797(297.00)1.083,9373,8513,85135110.03 TOTAL REVENUE6,288,9636,058,0546,346,5006,346,5004,480,4121,866,088.007.636,424,1966,427,4266,538,611192,1113.03 CHARGES FOR SERVICES6,288,9636,058,0546,346,5006,346,5004,480,4121,866,088.007.636,424,1966,427,4266,538,611192,1113.03 Page 68 of 79 Totals for dept 000 - GENERAL6,416,5676,709,31510,852,00010,852,0004,594,4736,257,527.0014.209,214,49917,359,13417,470,3196,618,31960.99 Dept 950 - OTHER NONOPERATING OTHER FINANCING SOURCES Revenue 401-950-364.100DISPOSITION/SALE OF ASSETS029,834006,803(6,803.00)0.006,8030000.00 TOTAL REVENUE029,834006,803(6,803.00)0.006,8030000.00 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 28 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE OTHER FINANCING SOURCES029,834006,803(6,803.00)0.006,8030000.00 UNRESTRICTED INVESTMENT EARNIN Revenue 401-950-361.100INTEREST/INVESTMENT EARNINGS50,4696,6718,4008,4006,1272,273.000.736,127075,00066,600792.86 401-950-367.100NET UNREAL APPRECIATION (DEP00006,465(6,465.00)0.006,4650000.00 TOTAL REVENUE50,4696,6718,4008,40012,592(4,192.00)0.7312,592075,00066,600792.86 UNRESTRICTED INVESTMENT EARNIN50,4696,6718,4008,40012,592(4,192.00)0.7312,592075,00066,600792.86 Totals for dept 950 - OTHER NONOPERATING50,46936,5058,4008,40019,395(10,995.00)0.7319,395075,00066,600792.86 Dept 990 - OTHER/RESERVE/CONTINGENCY OTHER FINANCING SOURCES Revenue 401-990-399.999APPROPRIATE FUND BALANCE002,076,9502,643,74602,643,746.000.0000426,125(2,217,621)(83.88) TOTAL REVENUE002,076,9502,643,74602,643,746.000.0000426,125(2,217,621)(83.88) OTHER FINANCING SOURCES002,076,9502,643,74602,643,746.000.0000426,125(2,217,621)(83.88) Totals for dept 990 - OTHER/RESERVE/CONTINGEN002,076,9502,643,74602,643,746.000.0000426,125(2,217,621)(83.88) TOTAL ESTIMATED REVENUES6,467,0366,745,82012,937,35013,504,1464,613,8688,890,278.0014.939,233,89417,359,13417,971,4444,467,29833.08 APPROPRIATIONS Dept 241 - WATER-ADMINISTRATION OPERATING EXPENDITURES/EXPENSE Expenditure 401-241-526.103EDUCATION REIMBURSEMENT PR01,4800000.000.0000000.00 401-241-531.301LEGAL SERVICES22,09511,64520,00020,00016,3453,655.000.8220,00020,00020,00000.00 401-241-531.301-9LEGAL SERVICES COVID-1903,9920000.000.0000000.00 401-241-531.302ENGINEERING SERVICES50,94844,146100,000186,70986,93999,770.000.47180,00050,00050,000(136,709)(73.22) 401-241-531.308LEGAL FEES - PERSONNEL9,6688335,0005,00005,000.000.0005,0005,00000.00 401-241-531.308-9LEGAL FEES - PERSONNEL COVID4,1457,0303,0003,00003,000.000.00000(3,000)(100.00) 401-241-531.324GRANTS ACQUISTION & ADMIN225752,5002,40002,400.000.001,0002,5002,5001004.17 401-241-532.300ACCOUNTING & AUDITING SERVIC31,96400000.000.0000000.00 401-241-534.300OTHER CONTRACTUAL SERVICES85,57635,71811,00040,53723,37117,166.000.5840,00010,00010,000(30,537)(75.33) 401-241-540.300TRAVEL & PER DIEM001,8401,840972868.000.531,5002,1102,11027014.67 401-241-541.300COMMUNICATION SERVICES2,1002,1002,5002,5002,237263.000.892,2372,5002,50000.00 401-241-543.300UTILITY SERVICES005,8505,8501,9873,863.000.345,0005,8005,800(50)(0.85) 401-241-544.304FEC LEASE15,16215,54416,20016,30016,26139.001.0016,26217,00017,0007004.29 401-241-545.300INSURANCE113,868134,116154,950154,950142,80712,143.000.92154,950173,568173,56818,61812.02 401-241-546.320COMPUTER SYSTEM MAINT & SUP34,01938,29470,50070,50061,4229,078.000.8770,50075,06475,0644,5646.47 401-241-549.300OTHER MISC CHGS & OBLIGATION15082,0002,0008661,134.000.432,0002,0002,00000.00 401-241-549.301ADMIN MGMT FEES598,596836,872655,210655,210655,2091.001.00655,209657,362657,3622,1520.33 401-241-549.304LICENSES, FEES & PERMITS78190580080078119.000.9878180080000.00 401-241-551.300OFFICE SUPPLIES & EQUIPMENT1,2876741,0001,000289711.000.291,0001,0001,00000.00 Page 69 of 79 401-241-552.310-9DISASTER RELIEF - COVID-19 38200000.000.0000000.00 401-241-554.300BOOKS, PUBL, SUBS & MEMBERSH01,5081,0001,000713287.000.711,0001,1251,12512512.50 401-241-554.301PERSONNEL TRAINING02,2953,5203,5208872,633.000.251,5003,5203,52000.00 TOTAL EXPENDITURE970,8171,137,7351,056,8701,173,1161,011,086162,030.0010.081,152,9391,029,3491,029,349(143,767)(12.26) OPERATING EXPENDITURES/EXPENSE970,8171,137,7351,056,8701,173,1161,011,086162,030.0010.081,152,9391,029,3491,029,349(143,767)(12.26) PERSONAL SERVICES 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 29 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE Expenditure 401-241-512.100REGULAR SALARIES & WAGES325,253161,279219,040219,040165,92053,120.000.76221,081234,650234,99015,9507.28 401-241-514.350OVERTIME - DISASTER75500000.000.0000000.00 401-241-515.103BONUS PAY PLAN4,1752,6598808808755.000.998751,1251,12524527.84 401-241-515.107PART-TIME SALARIES2410,5297,2007,2001,9505,250.000.277,2007,2007,20000.00 401-241-515.108AUTO ALLOWANCE5,7634,0805,4005,4004,1941,206.000.785,4005,4005,40000.00 401-241-515.120CELL PHONE ALLOWANCE24800000.000.0000000.00 401-241-516.100COMPENSATED ABSENCES37,288(26,041)5,0005,00005,000.000.0005,0005,00000.00 401-241-521.101FICA TAXES20,02310,00013,70013,7009,6734,027.000.7113,70014,40014,4507505.47 401-241-521.102MEDICARE TAXES4,7042,4883,4003,4002,409991.000.713,4003,6003,5751755.15 401-241-522.102VOT PENSION CONTRIBUTIONS GE35,37717,76821,20021,20016,0115,189.000.7621,35019,80019,850(1,350)(6.37) 401-241-522.150PENSION EXPENSE7,1588,5290000.000.0000000.00 401-241-523.101LIFE/HEALTH INSURANCE47,18629,43340,50040,50035,0535,447.000.8742,40048,25048,2507,75019.14 401-241-523.110RETIREE HEALTH CARE EXPENSE(10,351)(1,942)0000.000.0000000.00 401-241-524.100WORKERS' COMP INSURANCE3,7953,0404,6004,6004,106494.000.894,1075,3005,40080017.39 TOTAL EXPENDITURE481,398221,822320,920320,920240,19180,729.006.73319,513344,725345,24024,3207.58 PERSONAL SERVICES481,398221,822320,920320,920240,19180,729.006.73319,513344,725345,24024,3207.58 Totals for dept 241 - WATER-ADMINISTRATION1,452,2151,359,5571,377,7901,494,0361,251,277242,759.0016.801,472,4521,374,0741,374,589(119,447)(7.99) Dept 242 - WATER - PRODUCTION OPERATING EXPENDITURES/EXPENSE Expenditure 401-242-526.103EDUCATION REIMBURSEMENT PR004,0004,0001,6472,353.000.413,0003,0003,000(1,000)(25.00) 401-242-531.342WATER ANALYSIS & SAMPLING35,20538,35340,50040,50027,26313,237.000.6740,00042,50042,5002,0004.94 401-242-540.300TRAVEL & PER DIEM6511,7687007000700.000.00500500500(200)(28.57) 401-242-541.300COMMUNICATION SERVICES19,19820,72024,58024,58012,94211,638.000.5322,00024,58024,58000.00 401-242-541.301POSTAGE1102002002198.000.0120020020000.00 401-242-543.300UTILITY SERVICES370,298376,985417,540417,540290,271127,269.000.70420,000442,500442,50024,9605.98 401-242-544.301OPERATING LEASES2,5032,5183,2003,2001,6181,582.000.513,2003,0003,000(200)(6.25) 401-242-546.302VEHICLE REPAIR & MAINTENANCE3,2277,0279,0009,0009,182(182.00)1.0211,0008,0008,000(1,000)(11.11) 401-242-546.303BUILDING REPAIR & MAINT23,12330,85123,60023,60020,2553,345.000.8623,00020,30020,300(3,300)(13.98) 401-242-546.309LANDSCAPE & IRRIGATION MAINT12,68213,86819,75018,75011,2547,496.000.6018,00019,75019,7501,0005.33 401-242-546.310EQUIPMENT REPAIR & MAINT563,24020,00020,00088519,115.000.0410,00010,00010,000(10,000)(50.00) 401-242-546.342WATER SYSTEM MAINTENANCE127,533217,531110,000110,00060,66049,340.000.55100,00095,00095,000(15,000)(13.64) 401-242-547.300PRINTING & BINDING9229301,0001,0001,038(38.00)1.041,0001,0001,00000.00 401-242-549.300OTHER MISC CHGS & OBLIGATION2,4415062,6002,6001202,480.000.051,6002,0002,000(600)(23.08) 401-242-549.304LICENSES, FEES & PERMITS23,58926,50730,45030,45025,8074,643.000.8530,00026,55026,550(3,900)(12.81) 401-242-549.996-9HURRICANE EXPENSES-ISAIAS6100000.000.0000000.00 401-242-551.300OFFICE SUPPLIES & EQUIPMENT6,2505,5366,9006,9003,6783,222.000.536,0006,9006,90000.00 401-242-552.301GAS & OIL2,7773,6325,0005,0004,294706.000.864,0004,0004,000(1,000)(20.00) 401-242-552.302SMALL TOOLS AND EQUIPMENT4,4758,0335,7005,7004,737963.000.835,7005,7005,70000.00 401-242-552.303DIESEL FUEL4,7526,6847,0007,00007,000.000.008,0008,0008,0001,00014.29 401-242-552.305UNIFORMS2,7372,5424,2004,2003,769431.000.904,0004,5004,5003007.14 401-242-552.310-9DISASTER RELIEF - COVID-19 9591,0210000.000.0000000.00 401-242-552.341WATER PURCHASES0010,00010,000010,000.000.00010,00010,00000.00 401-242-552.342WATER CHEMICALS180,548212,233248,500263,500157,387106,113.000.60260,000308,000308,00044,50016.89 401-242-552.343LABORATORY SUPPLIES17,20516,07525,00025,00014,17710,823.000.5723,00025,00025,00000.00 Page 70 of 79 401-242-554.300BOOKS, PUBL, SUBS & MEMBERSH1,7961,7238001,8001,76634.000.981,8002,0502,05025013.89 401-242-554.301PERSONNEL TRAINING1,2554,7211,5001,5004101,090.000.271,5001,5001,50000.00 TOTAL EXPENDITURE844,2541,003,0041,021,7201,036,720653,162383,558.0013.37997,5001,074,5301,074,53037,8103.65 OPERATING EXPENDITURES/EXPENSE844,2541,003,0041,021,7201,036,720653,162383,558.0013.37997,5001,074,5301,074,53037,8103.65 PERSONAL SERVICES Expenditure 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 30 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE 401-242-512.100REGULAR SALARIES & WAGES572,499584,382602,100602,100434,740167,360.000.72578,302610,305570,365(31,735)(5.27) 401-242-512.100-9REGULAR SALARIES & WAGES CO79600000.000.0000000.00 401-242-514.100OVERTIME16,22715,84520,60020,60014,9335,667.000.7220,60021,85021,2206203.01 401-242-514.350OVERTIME - DISASTER2,77220000.000.0000000.00 401-242-515.101HOLIDAY PAY8,92311,58712,45012,4509,6482,802.000.7711,20011,90011,600(850)(6.83) 401-242-515.102STANDBY PAY9,8899,89610,60010,6007,2513,349.000.6810,60011,25010,9203203.02 401-242-515.103BONUS PAY PLAN5005005005005000.001.0050075075025050.00 401-242-515.106CLOTHING & BOOT ALLOWANCE9751,1001,1001,1001,1000.001.001,1001,1001,10000.00 401-242-516.100COMPENSATED ABSENCES005,0005,0001,9963,004.000.401,9965,0005,00000.00 401-242-521.101FICA TAXES36,64137,29739,40039,40028,12411,276.000.7139,40039,80037,250(2,150)(5.46) 401-242-521.101-9FICA TAXES COVID-194700000.000.0000000.00 401-242-521.102MEDICARE TAXES8,5698,7239,2009,2006,5772,623.000.719,2009,3508,750(450)(4.89) 401-242-521.102-9MEDICARE TAXES COVID-191100000.000.0000000.00 401-242-522.101FRS CONTRIBUTIONS12,45714,16213,50013,50011,2502,250.000.8315,50015,2009,900(3,600)(26.67) 401-242-522.102VOT PENSION CONTRIBUTIONS GE53,40255,65850,00050,00036,12313,877.000.7248,12044,55043,600(6,400)(12.80) 401-242-522.102-9VOT PENSION CONTRIBUTIONS GE 8600000.000.0000000.00 401-242-522.150PENSION EXPENSE2,383108,1900000.000.0000000.00 401-242-523.101LIFE/HEALTH INSURANCE125,786130,677136,300136,300110,31025,990.000.81133,500152,150148,70012,4009.10 401-242-523.105HSA - HEALTH SAVINGS ACCOUNT8109601,0201,02096060.000.941,4402,2502,2501,230120.59 401-242-523.110RETIREE HEALTH CARE EXPENSE(22,441)5,2250000.000.0000000.00 401-242-524.100WORKERS' COMP INSURANCE21,84017,85521,80021,80019,8571,943.000.9119,85724,40022,9001,1005.05 401-242-525.100UNEMPLOYMENT COMPENSATION87800000.000.0000000.00 TOTAL EXPENDITURE853,0501,002,059923,570923,570683,369240,201.0010.95891,315949,855894,305(29,265)(3.17) PERSONAL SERVICES853,0501,002,059923,570923,570683,369240,201.0010.95891,315949,855894,305(29,265)(3.17) Totals for dept 242 - WATER - PRODUCTION1,697,3042,005,0631,945,2901,960,2901,336,531623,759.0024.321,888,8152,024,3851,968,8358,5450.44 Dept 243 - WATER-DISTRIBUTION OPERATING EXPENDITURES/EXPENSE Expenditure 401-243-534.300OTHER CONTRACTUAL SERVICES15,26514,06822,00036,00015,11420,886.000.4236,00027,00027,000(9,000)(25.00) 401-243-540.300TRAVEL & PER DIEM131300500500181319.000.365001,4001,400900180.00 401-243-541.300COMMUNICATION SERVICES14,48814,68117,00017,00010,4226,578.000.6115,00018,00018,0001,0005.88 401-243-541.301POSTAGE30,635190100100168(68.00)1.6810010010000.00 401-243-543.300UTILITY SERVICES003,3003,30003,300.000.003,3005,5005,5002,20066.67 401-243-544.301OPERATING LEASES1,3301,1611,5001,5001,075425.000.721,5001,8001,80030020.00 401-243-546.302VEHICLE REPAIR & MAINTENANCE15,08914,19815,00015,0008,1606,840.000.5415,00011,00011,000(4,000)(26.67) 401-243-546.303BUILDING REPAIR & MAINT3,08017,5085,5502,5502,934(384.00)1.152,6935,6005,6003,050119.61 401-243-546.309LANDSCAPE & IRRIGATION MAINT23101,5005000500.000.005001,5001,5001,000200.00 401-243-546.310EQUIPMENT REPAIR & MAINT8,8494,86015,00015,00011,1623,838.000.7415,00016,80016,8001,80012.00 401-243-546.342WATER SYSTEM MAINTENANCE55,331(44,699)59,50059,50052,5676,933.000.8859,00064,50064,5005,0008.40 401-243-547.300PRINTING & BINDING14,78238550050043466.000.8750050050000.00 401-243-549.300OTHER MISC CHGS & OBLIGATION3,6782,9942,1002,1009751,125.000.461,5001,0001,000(1,100)(52.38) 401-243-549.304LICENSES, FEES & PERMITS2,6242,1903,0003,0001,4991,501.000.503,0003,0003,00000.00 401-243-549.996-9HURRICANE EXPENSES-ISAIAS6100000.000.0000000.00 401-243-551.300OFFICE SUPPLIES & EQUIPMENT3,5651,0351,0001,000841159.000.841,0001,5001,50050050.00 401-243-552.301GAS & OIL9,03711,93310,00010,00012,125(2,125.00)1.2112,00015,00015,0005,00050.00 401-243-552.302SMALL TOOLS AND EQUIPMENT7,6369,7935,2007,2007,000200.000.977,20012,00012,0004,80066.67 Page 71 of 79 401-243-552.305UNIFORMS3,7623,4164,2006,2006,262(62.00)1.016,3004,5004,500(1,700)(27.42) 401-243-552.310-9DISASTER RELIEF - COVID-19 8614430000.000.0000000.00 401-243-554.301PERSONNEL TRAINING1,1041,3682,0002,0001,96436.000.982,0003,5303,5301,53076.50 TOTAL EXPENDITURE191,53955,824168,950182,950132,88350,067.0013.96182,093194,230194,23011,2806.17 OPERATING EXPENDITURES/EXPENSE191,53955,824168,950182,950132,88350,067.0013.96182,093194,230194,23011,2806.17 CAPITAL OUTLAY 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 31 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE Expenditure 401-243-664.601COMPUTER EQUIPMENT(1,397)00000.000.0000000.00 401-243-664.601-9COMPUTER EQUIPMENT COVID-191,39700000.000.0000000.00 TOTAL EXPENDITURE000000.000.0000000.00 CAPITAL OUTLAY000000.000.0000000.00 PERSONAL SERVICES Expenditure 401-243-512.100REGULAR SALARIES & WAGES496,351387,360336,500336,500218,856117,644.000.65303,536352,470344,2207,7202.29 401-243-512.100-9REG SALARIES & WAGES COVID-17400000.000.0000000.00 401-243-514.100OVERTIME7,4926,40710,60010,6008,1512,449.000.7710,60011,25011,9201,32012.45 401-243-514.350OVERTIME - DISASTER6500000.000.0000000.00 401-243-515.102STANDBY PAY31,33330,56736,30036,30019,29417,006.000.5325,70027,30026,500(9,800)(27.00) 401-243-515.103BONUS PAY PLAN5005004004001,690(1,290.00)4.2340040040000.00 401-243-515.106CLOTHING & BOOT ALLOWANCE687812800800662138.000.83662790790(10)(1.25) 401-243-516.100COMPENSATED ABSENCES005,0005,0003384,662.000.0705,0005,00000.00 401-243-521.101FICA TAXES32,47825,75123,20023,20014,5468,654.000.6323,20023,35022,800(400)(1.72) 401-243-521.101-9FICA TAXES COVID-19400000.000.0000000.00 401-243-521.102MEDICARE TAXES7,5966,0235,5005,5003,4022,098.000.625,5005,5005,400(100)(1.82) 401-243-521.102-9MEDICARE TAXES COVID-19100000.000.0000000.00 401-243-522.101FRS CONTRIBUTIONS14,28115,9550000.000.0000000.00 401-243-522.102VOT PENSION CONTRIBUTIONS GE44,78133,41432,50032,50021,00011,500.000.6528,70029,55028,850(3,650)(11.23) 401-243-522.102-9VOT PENSION CONTRIBUTIONS GE 800000.000.0000000.00 401-243-522.150PENSION EXPENSE(25,765)124,6540000.000.0000000.00 401-243-523.101LIFE/HEALTH INSURANCE116,26098,575109,500109,50084,25125,249.000.77100,600128,200128,20018,70017.08 401-243-523.110RETIREE HEALTH CARE EXPENSE(13,321)3,3710000.000.0000000.00 401-243-524.100WORKERS' COMP INSURANCE13,99011,97213,10013,10011,8791,221.000.9111,88014,70014,3001,2009.16 TOTAL EXPENDITURE726,815745,361573,400573,400384,069189,331.0010.64510,778598,510588,38014,9802.61 PERSONAL SERVICES726,815745,361573,400573,400384,069189,331.0010.64510,778598,510588,38014,9802.61 Totals for dept 243 - WATER-DISTRIBUTION918,354801,185742,350756,350516,952239,398.0024.60692,871792,740782,61026,2603.47 Dept 244 - WATER CUSTOMER SERVICE OPERATING EXPENDITURES/EXPENSE Expenditure 401-244-540.300TRAVEL & PER DIEM001,3001,300473827.000.361,0001,0101,010(290)(22.31) 401-244-541.301POSTAGE029,07523,90023,90015,3568,544.000.6423,00023,90023,90000.00 401-244-546.310EQUIPMENT REPAIR & MAINT001,0001,00001,000.000.001,0001,0001,00000.00 401-244-547.300PRINTING & BINDING011,67813,25013,2506,2516,999.000.4710,00014,45014,4501,2009.06 401-244-549.300OTHER MISC CHGS & OBLIGATION04841,0009500950.000.00500500500(450)(47.37) 401-244-549.391BANK CHARGES533925,0005,0002064,794.000.04200500500(4,500)(90.00) 401-244-549.395CREDIT CARD FEES AND CHARGE21,76825,83625,00025,00016,2068,794.000.6529,00030,00030,0005,00020.00 401-244-549.397BAD DEBT EXPENSE00009,675(9,675.00)0.0000000.00 401-244-551.300OFFICE SUPPLIES & EQUIPMENT01,6812,0002,0001,291709.000.652,0002,0002,00000.00 401-244-552.305UNIFORMS02223003500350.000.00350300300(50)(14.29) 401-244-554.301PERSONNEL TRAINING00950950717233.000.7595095095000.00 TOTAL EXPENDITURE22,30169,06873,70073,70050,17523,525.003.5768,00074,61074,6109101.23 Page 72 of 79 OPERATING EXPENDITURES/EXPENSE22,30169,06873,70073,70050,17523,525.003.5768,00074,61074,6109101.23 PERSONAL SERVICES Expenditure 401-244-512.100REGULAR SALARIES & WAGES0110,699136,100136,100100,47935,621.000.74135,097147,825145,5209,4206.92 401-244-515.103BONUS PAY PLAN05007507507500.001.0075075075000.00 401-244-516.100COMPENSATED ABSENCES00002,317(2,317.00)0.002,3170000.00 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 32 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE 401-244-521.101FICA TAXES06,4108,1008,1006,0202,080.000.748,1008,8008,7006007.41 401-244-521.102MEDICARE TAXES01,4991,9001,9001,408492.000.741,9002,1002,0501507.89 401-244-522.102VOT PENSION CONTRIBUTIONS GE012,24313,20013,2009,6963,504.000.7313,04012,50012,300(900)(6.82) 401-244-523.101LIFE/HEALTH INSURANCE039,16945,40045,40032,47612,924.000.7237,95036,15036,150(9,250)(20.37) 401-244-524.100WORKERS' COMP INSURANCE0156300300200100.000.6720030030000.00 TOTAL EXPENDITURE0170,676205,750205,750153,34652,404.005.34199,354208,425205,770200.01 PERSONAL SERVICES0170,676205,750205,750153,34652,404.005.34199,354208,425205,770200.01 Totals for dept 244 - WATER CUSTOMER SERVICE22,301239,744279,450279,450203,52175,929.008.91267,354283,035280,3809300.33 Dept 411 - RENEWAL & REPLACEMENT OPERATING EXPENDITURES/EXPENSE Expenditure 401-411-531.302ENGINEERING SERVICES151,737200,6140238,86643,443195,423.000.18238,86600(238,866)(100.00) 401-411-546.604R & M - PUMP AND MOTOR REHAB0025,00025,000025,000.000.0015,00025,00025,00000.00 401-411-546.605R&M - WELL REHABILITATION27,05139,76452,000533,656266,628267,028.000.50496,63051,00051,000(482,656)(90.44) 401-411-546.607R&M - WATER MAINS6500019,077019,077.000.00000(19,077)(100.00) 401-411-549.671MISC. RENEWAL & REPLACEMENT35,66036,600135,000421,2100421,210.000.00300,000552,000552,000130,79031.05 401-411-552.601METERS, VALVES & HYDRANTS742,898275,25825,00078,21231,83546,377.000.4130,00045,00045,000(33,212)(42.46) TOTAL EXPENDITURE957,996552,236237,0001,316,021341,906974,115.001.091,080,496673,000673,000(643,021)(48.86) OPERATING EXPENDITURES/EXPENSE957,996552,236237,0001,316,021341,906974,115.001.091,080,496673,000673,000(643,021)(48.86) CAPITAL OUTLAY Expenditure 401-411-663.600IMPROVEMENTS OTHER THAN BLD001,935,0001,174,80812,5341,162,274.000.01600,000734,000734,000(440,808)(37.52) 401-411-663.632ARCHITECT & ENGINEERING001,289,0001,391,721448,807942,914.000.32838,000507,000507,000(884,721)(63.57) 401-411-664.600MACH/EQUIPMENT00125,000125,0000125,000.000.00125,000264,000264,000139,000111.20 401-411-664.602VEHICLES0071,00071,000071,000.000.0071,00038,00038,000(33,000)(46.48) TOTAL EXPENDITURE003,420,0002,762,529461,3412,301,188.000.331,634,0001,543,0001,543,000(1,219,529)(44.15) CAPITAL OUTLAY003,420,0002,762,529461,3412,301,188.000.331,634,0001,543,0001,543,000(1,219,529)(44.15) Totals for dept 411 - RENEWAL & REPLACEMENT957,996552,2363,657,0004,078,550803,2473,275,303.001.422,714,4962,216,0002,216,000(1,862,550)(45.67) Dept 412 - CAPITAL IMPROVEMENT CAPITAL OUTLAY Expenditure 401-412-663.600IMPROVEMENTS OTHER THAN BLD004,442,0004,442,00004,442,000.000.002,631,93110,855,00010,855,0006,413,000144.37 TOTAL EXPENDITURE004,442,0004,442,00004,442,000.000.002,631,93110,855,00010,855,0006,413,000144.37 CAPITAL OUTLAY004,442,0004,442,00004,442,000.000.002,631,93110,855,00010,855,0006,413,000144.37 Totals for dept 412 - CAPITAL IMPROVEMENT004,442,0004,442,00004,442,000.000.002,631,93110,855,00010,855,0006,413,000144.37 Dept 700 - DEBT SERVICE D/S - PRINCIPAL Expenditure Page 73 of 79 401-700-571.720PRIN - 2008 WATER UTILITY NOT00376,800376,800312,65664,144.000.83376,729391,825391,82515,0253.99 TOTAL EXPENDITURE00376,800376,800312,65664,144.000.83376,729391,825391,82515,0253.99 D/S - PRINCIPAL00376,800376,800312,65664,144.000.83376,729391,825391,82515,0253.99 D/S - INTEREST Expenditure 401-700-572.705INT - 2004 WATER N/P BOA2,8319970000.000.0000000.00 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 33 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE 401-700-572.720INT - 2008 WATER UTILITY NOTE121,502107,92794,20094,20063,56530,635.000.6794,11779,73579,735(14,465)(15.36) TOTAL EXPENDITURE124,333108,92494,20094,20063,56530,635.000.6794,11779,73579,735(14,465)(15.36) D/S - INTEREST124,333108,92494,20094,20063,56530,635.000.6794,11779,73579,735(14,465)(15.36) OTHER DEBT SERVICE Expenditure 401-700-573.700OTHER DEBT SERVICE COSTS22,46722,46722,47022,470022,470.000.0022,46722,47022,47000.00 TOTAL EXPENDITURE22,46722,46722,47022,470022,470.000.0022,46722,47022,47000.00 OTHER DEBT SERVICE22,46722,46722,47022,470022,470.000.0022,46722,47022,47000.00 Totals for dept 700 - DEBT SERVICE146,800131,391493,470493,470376,221117,249.001.50493,313494,030494,0305600.11 Dept 900 - INTERFUND TRANSFERS INTERFUND TRANSFERS OUT Expenditure 401-900-591.001TRANSFER TO GENERAL FUND021,8910000.000.0000000.00 TOTAL EXPENDITURE021,8910000.000.0000000.00 INTERFUND TRANSFERS OUT021,8910000.000.0000000.00 Totals for dept 900 - INTERFUND TRANSFERS021,8910000.000.0000000.00 Dept 950 - OTHER NONOPERATING OPERATING EXPENDITURES/EXPENSE Expenditure 401-950-559.300DEPRECIATION699,645681,5800000.000.0000000.00 TOTAL EXPENDITURE699,645681,5800000.000.0000000.00 OPERATING EXPENDITURES/EXPENSE699,645681,5800000.000.0000000.00 OTHER FINANCING SOURCES & USES Expenditure 401-950-590.100LOSS ON DISPOSAL OF CAPITAL A039,7610000.000.0000000.00 401-950-592.100LEGAL SETTLEMENT69,59000000.000.0000000.00 TOTAL EXPENDITURE69,59039,7610000.000.0000000.00 OTHER FINANCING SOURCES & USES69,59039,7610000.000.0000000.00 Totals for dept 950 - OTHER NONOPERATING769,235721,3410000.000.0000000.00 TOTAL APPROPRIATIONS5,964,2055,832,40812,937,35013,504,1464,487,7499,016,397.0077.5610,161,23218,039,26417,971,4444,467,29833.08 NET OF REVENUES/APPROPRIATIONS - FUND 401502,831913,41200126,119126,119.0092.49(927,338)(680,130)000.00 Fund 402 - REFUSE & RECYCLING ESTIMATED REVENUES Page 74 of 79 Dept 000 - GENERAL INTERGOVERNMENTAL REVENUE Revenue 402-000-338.110RECYCLING SHARED REV - SWA01,208001,992(1,992.00)0.001,9920000.00 TOTAL REVENUE01,208001,992(1,992.00)0.001,9920000.00 INTERGOVERNMENTAL REVENUE01,208001,992(1,992.00)0.001,9920000.00 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 34 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE CHARGES FOR SERVICES Revenue 402-000-343.400REFUSE / RECYCLING FEES487,874485,435500,940500,940500,129811.001.00500,940519,934572,36671,42614.26 TOTAL REVENUE487,874485,435500,940500,940500,129811.001.00500,940519,934572,36671,42614.26 CHARGES FOR SERVICES487,874485,435500,940500,940500,129811.001.00500,940519,934572,36671,42614.26 Totals for dept 000 - GENERAL487,874486,643500,940500,940502,121(1,181.00)1.00502,932519,934572,36671,42614.26 Dept 950 - OTHER NONOPERATING UNRESTRICTED INVESTMENT EARNIN Revenue 402-950-361.100INTEREST/INVESTMENT EARNINGS584363500500142358.000.2825050050000.00 402-950-361.101PBC TAX COL-INTEREST ON DEP10000000.000.0000000.00 TOTAL REVENUE684363500500142358.000.2825050050000.00 UNRESTRICTED INVESTMENT EARNIN684363500500142358.000.2825050050000.00 Totals for dept 950 - OTHER NONOPERATING684363500500142358.000.2825050050000.00 Dept 990 - OTHER/RESERVE/CONTINGENCY OTHER FINANCING SOURCES Revenue 402-990-399.999APPROPRIATE FUND BALANCE0028,57028,570028,570.000.00028,73829,1065361.88 TOTAL REVENUE0028,57028,570028,570.000.00028,73829,1065361.88 OTHER FINANCING SOURCES0028,57028,570028,570.000.00028,73829,1065361.88 Totals for dept 990 - OTHER/RESERVE/CONTINGEN0028,57028,570028,570.000.00028,73829,1065361.88 TOTAL ESTIMATED REVENUES488,558487,006530,010530,010502,26327,747.001.28503,182549,172601,97271,96213.58 APPROPRIATIONS Dept 245 - REFUSE AND RECYCLING OPERATING EXPENDITURES/EXPENSE Expenditure 402-245-543.302SOLID WASTE/RESIDENTIAL240,159247,064255,900255,900191,91663,984.000.75255,888264,900290,80034,90013.64 402-245-543.303RECYCLING/RESIDENTIAL110,872114,325118,200118,20088,62129,579.000.75118,162122,300134,30016,10013.62 402-245-543.304YARD WASTE/RESIDENTIAL136,959141,180146,200146,200109,62536,575.000.75146,167151,300166,20020,00013.68 402-245-549.300OTHER MISC CHGS & OBLIGATION1811811,0001,000184816.000.181841,0001,00000.00 402-245-549.301ADMIN MGMT FEES8,4488,5508,7108,7108,7073.001.008,7069,6729,67296211.04 TOTAL EXPENDITURE496,619511,300530,010530,010399,053130,957.003.43529,107549,172601,97271,96213.58 OPERATING EXPENDITURES/EXPENSE496,619511,300530,010530,010399,053130,957.003.43529,107549,172601,97271,96213.58 Totals for dept 245 - REFUSE AND RECYCLING496,619511,300530,010530,010399,053130,957.003.43529,107549,172601,97271,96213.58 TOTAL APPROPRIATIONS496,619511,300530,010530,010399,053130,957.003.43529,107549,172601,97271,96213.58 Page 75 of 79 NET OF REVENUES/APPROPRIATIONS - FUND 402(8,061)(24,294)00103,210103,210.004.72(25,925)0000.00 Fund 403 - STORMWATER UTILITY ESTIMATED REVENUES Dept 000 - GENERAL GRANTS - STATE 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 35 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE Revenue 403-000-334.201STATE GRANT015,6150000.000.0000000.00 TOTAL REVENUE015,6150000.000.0000000.00 GRANTS - STATE015,6150000.000.0000000.00 CHARGES FOR SERVICES Revenue 403-000-343.901STORM WATER UTILITY FEES432,355450,271497,810497,810487,42710,383.000.98490,000487,240519,57121,7614.37 TOTAL REVENUE432,355450,271497,810497,810487,42710,383.000.98490,000487,240519,57121,7614.37 CHARGES FOR SERVICES432,355450,271497,810497,810487,42710,383.000.98490,000487,240519,57121,7614.37 GRANTS & CONTRIBUTIONS - LOCAL Revenue 403-000-337.300GRANT FUNDS0030,00030,000030,000.000.00125,00095,00095,00065,000216.67 TOTAL REVENUE0030,00030,000030,000.000.00125,00095,00095,00065,000216.67 GRANTS & CONTRIBUTIONS - LOCAL0030,00030,000030,000.000.00125,00095,00095,00065,000216.67 Totals for dept 000 - GENERAL432,355465,886527,810527,810487,42740,383.000.98615,000582,240614,57186,76116.44 Dept 900 - INTERFUND TRANSFERS TRANSFERS IN Revenue 403-900-381.001TRANSFER FROM GENERAL FUND00150,000188,5650188,565.000.00188,565300,000300,000111,43559.10 TOTAL REVENUE00150,000188,5650188,565.000.00188,565300,000300,000111,43559.10 TRANSFERS IN00150,000188,5650188,565.000.00188,565300,000300,000111,43559.10 Totals for dept 900 - INTERFUND TRANSFERS00150,000188,5650188,565.000.00188,565300,000300,000111,43559.10 Dept 950 - OTHER NONOPERATING UNRESTRICTED INVESTMENT EARNIN Revenue 403-950-361.100INTEREST/INVESTMENT EARNINGS8,0958831,4001,400621,338.000.045001,5281,5281289.14 403-950-361.101PBC TAX COL-INTEREST ON DEP8600000.000.0000000.00 TOTAL REVENUE8,1818831,4001,400621,338.000.045001,5281,5281289.14 UNRESTRICTED INVESTMENT EARNIN8,1818831,4001,400621,338.000.045001,5281,5281289.14 Totals for dept 950 - OTHER NONOPERATING8,1818831,4001,400621,338.000.045001,5281,5281289.14 Dept 990 - OTHER/RESERVE/CONTINGENCY OTHER FINANCING SOURCES Revenue 403-990-399.999APPROPRIATE FUND BALANCE00047,352047,352.000.00000(47,352)(100.00) TOTAL REVENUE00047,352047,352.000.00000(47,352)(100.00) Page 76 of 79 OTHER FINANCING SOURCES00047,352047,352.000.00000(47,352)(100.00) Totals for dept 990 - OTHER/RESERVE/CONTINGEN00047,352047,352.000.00000(47,352)(100.00) TOTAL ESTIMATED REVENUES440,536466,769679,210765,127487,489277,638.001.02804,065883,768916,099150,97219.73 APPROPRIATIONS 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 36 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE Dept 250 - STORM WATER UTILITIES OPERATING EXPENDITURES/EXPENSE Expenditure 403-250-531.301LEGAL SERVICES8546133,0005,0003,8851,115.000.785,0005,0005,00000.00 403-250-531.302ENGINEERING SERVICES29,201035,00069,92534,98934,936.000.50160,000115,000115,00045,07564.46 403-250-531.324GRANTS ACQUISTION & ADMIN001,0005000500.000.005001,0001,000500100.00 403-250-532.300ACCOUNTING & AUDITING SERVIC4,47500000.000.0000000.00 403-250-534.300OTHER CONTRACTUAL SERVICES18,4367,2535,0005,0002,8012,199.000.565,0005,0005,00000.00 403-250-540.300TRAVEL & PER DIEM02401,1201,120133987.000.12750800800(320)(28.57) 403-250-541.300COMMUNICATION SERVICES3,8263,8264,2004,2002,6821,518.000.644,0003,8403,840(360)(8.57) 403-250-546.302VEHICLE REPAIR & MAINTENANCE622262,2002,2004251,775.000.192,0002,2002,20000.00 403-250-546.308DRAINAGE MAINTENANCE59,97253,30060,60050,10018,96031,140.000.3850,00060,60060,60010,50020.96 403-250-546.310EQUIPMENT REPAIR & MAINT1,9423,1215,0005,0004,842158.000.975,0005,0005,00000.00 403-250-549.300OTHER MISC CHGS & OBLIGATION1,2156792,0001,000684316.000.681,0002,0002,0001,000100.00 403-250-549.301ADMIN MGMT FEES14,29285,87386,42086,42086,4137.001.0086,41288,38588,3851,9652.27 403-250-549.304LICENSES, FEES & PERMITS4,7735,6905,5005,5004,3221,178.000.795,2935,8005,8003005.45 403-250-552.301GAS & OIL1,5562,0393,0003,0002,019981.000.672,5003,0003,00000.00 403-250-552.302SMALL TOOLS AND EQUIPMENT5,1936,2753,0003,0002,671329.000.893,0003,0003,00000.00 403-250-554.100PUBLIC EDUCATION PROGRAM90501,0001,000170830.000.171,0001,0001,00000.00 403-250-554.301PERSONNEL TRAINING9191,0541,0001,000500500.000.501,0001,0001,00000.00 TOTAL EXPENDITURE147,621170,189219,040243,965165,49678,469.008.84332,455302,625302,62558,66024.04 OPERATING EXPENDITURES/EXPENSE147,621170,189219,040243,965165,49678,469.008.84332,455302,625302,62558,66024.04 PERSONAL SERVICES Expenditure 403-250-512.100REGULAR SALARIES & WAGES87,61189,93586,63086,63068,35018,280.000.7991,85588,35085,545(1,085)(1.25) 403-250-514.100OVERTIME001,0001,00001,000.000.001,0001,0001,00000.00 403-250-514.350OVERTIME - DISASTER13100000.000.0000000.00 403-250-515.103BONUS PAY PLAN100100100100516(416.00)5.1610010010000.00 403-250-515.106CLOTHING & BOOT ALLOWANCE1881882202202137.000.97213215215(5)(2.27) 403-250-515.108AUTO ALLOWANCE7727200000.000.0000000.00 403-250-516.100COMPENSATED ABSENCES(1,161)1,0840000.000.0000000.00 403-250-521.101FICA TAXES5,3805,4255,3005,3004,0931,207.000.775,3005,5005,4001001.89 403-250-521.102MEDICARE TAXES1,2581,2691,3001,300957343.000.741,3001,3001,30000.00 403-250-522.102VOT PENSION CONTRIBUTIONS GE9,5489,8758,4008,4006,5551,845.000.788,8007,4007,300(1,100)(13.10) 403-250-522.150PENSION EXPENSE(2,661)1,9850000.000.0000000.00 403-250-523.101LIFE/HEALTH INSURANCE18,45725,94126,70026,70022,1534,547.000.8326,60020,95020,950(5,750)(21.54) 403-250-523.110RETIREE HEALTH CARE EXPENSE(4,089)1,0090000.000.0000000.00 403-250-524.100WORKERS' COMP INSURANCE3,1252,7333,0003,0002,715285.000.912,7163,4003,30030010.00 TOTAL EXPENDITURE118,659140,264132,650132,650105,55227,098.0010.94137,884128,215125,110(7,540)(5.68) PERSONAL SERVICES118,659140,264132,650132,650105,55227,098.0010.94137,884128,215125,110(7,540)(5.68) Totals for dept 250 - STORM WATER UTILITIES266,280310,453351,690376,615271,048105,567.0019.78470,339430,840427,73551,12013.57 Dept 411 - RENEWAL & REPLACEMENT OPERATING EXPENDITURES/EXPENSE Expenditure Page 77 of 79 403-411-531.302ENGINEERING SERVICES25,7212,485018,05518,0550.001.0018,05500(18,055)(100.00) 403-411-546.308DRAINAGE MAINTENANCE41,47668,97504,37222,550(18,178.00)5.1622,55100(4,372)(100.00) TOTAL EXPENDITURE67,19771,460022,42740,605(18,178.00)6.1640,60600(22,427)(100.00) OPERATING EXPENDITURES/EXPENSE67,19771,460022,42740,605(18,178.00)6.1640,60600(22,427)(100.00) CAPITAL OUTLAY Expenditure 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 37 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE 403-411-663.663DRAINAGE IMPROVEMENTS00282,000132,00077,15054,850.000.5875,000104,000119,000(13,000)(9.85) 403-411-663.663-9DRAINAGE IMPROVEMENTS000188,565102,95285,613.000.55188,565300,000300,000111,43559.10 TOTAL EXPENDITURE00282,000320,565180,102140,463.001.13263,565404,000419,00098,43530.71 CAPITAL OUTLAY00282,000320,565180,102140,463.001.13263,565404,000419,00098,43530.71 Totals for dept 411 - RENEWAL & REPLACEMENT67,19771,460282,000342,992220,707122,285.007.29304,171404,000419,00076,00822.16 Dept 950 - OTHER NONOPERATING OPERATING EXPENDITURES/EXPENSE Expenditure 403-950-559.300DEPRECIATION120,303132,3730000.000.0000000.00 TOTAL EXPENDITURE120,303132,3730000.000.0000000.00 OPERATING EXPENDITURES/EXPENSE120,303132,3730000.000.0000000.00 OTHER FINANCING SOURCES & USES Expenditure 403-950-590.001ALLOCATE TO FUND BALANCE0045,52045,520045,520.000.000069,36423,84452.38 403-950-590.100LOSS ON DISPOSAL OF CAPITAL A010,4490000.000.0000000.00 TOTAL EXPENDITURE010,44945,52045,520045,520.000.000069,36423,84452.38 OTHER FINANCING SOURCES & USES010,44945,52045,520045,520.000.000069,36423,84452.38 Totals for dept 950 - OTHER NONOPERATING120,303142,82245,52045,520045,520.000.000069,36423,84452.38 TOTAL APPROPRIATIONS453,780524,735679,210765,127491,755273,372.0027.07774,510834,840916,099150,97219.73 NET OF REVENUES/APPROPRIATIONS - FUND 403(13,244)(57,966)00(4,266)(4,266.00)28.0929,55548,928000.00 Fund 605 - SPECIAL LAW ENFORCEMENT ESTIMATED REVENUES Dept 171 - POLICE GRANTS - STATE Revenue 605-171-334.207FMIT MATCING SAFETY GRANT4,26500000.000.0000000.00 TOTAL REVENUE4,26500000.000.0000000.00 GRANTS - STATE4,26500000.000.0000000.00 FINES & FORFEITURES Revenue 605-171-359.100FORFEITURES/CONFISCATIONS091,516044,20289,470(45,268.00)2.0289,47063,70063,70019,49844.11 TOTAL REVENUE091,516044,20289,470(45,268.00)2.0289,47063,70063,70019,49844.11 FINES & FORFEITURES091,516044,20289,470(45,268.00)2.0289,47063,70063,70019,49844.11 Totals for dept 171 - POLICE4,26591,516044,20289,470(45,268.00)2.0289,47063,70063,70019,49844.11 Page 78 of 79 Dept 950 - OTHER NONOPERATING UNRESTRICTED INVESTMENT EARNIN Revenue 605-950-361.100INTEREST/INVESTMENT EARNINGS23213100140(140.00)0.001400000.00 TOTAL REVENUE23213100140(140.00)0.001400000.00 UNRESTRICTED INVESTMENT EARNIN23213100140(140.00)0.001400000.00 07/12/2022 BUDGET REPORT FOR VILLAGE OF TEQUESTA 38 Agenda Item #1. 2019-202020-212021-222021-222021-22FY2022FY20222021-222022-232022-232022-232022-23 ACTIVITYACTIVITYAPPROVEDAMENDEDACTIVITY$%PROJECTEDREQUESTEDRECOMMENDEDRECOMMENDEDRECOMMENDED GL NUMBERDESCRIPTIONBUDGETBUDGETTHRU 09/30/22AVAILABLECOMPLETEACTIVITYBUDGETBUDGETAMT CHANGE% CHANGE Totals for dept 950 - OTHER NONOPERATING23213100140(140.00)0.001400000.00 Dept 990 - OTHER/RESERVE/CONTINGENCY OTHER FINANCING SOURCES Revenue 605-990-399.999APPROPRIATE FUND BALANCE0074,920149,6700149,670.000.00036,00736,007(113,663)(75.94) TOTAL REVENUE0074,920149,6700149,670.000.00036,00736,007(113,663)(75.94) OTHER FINANCING SOURCES0074,920149,6700149,670.000.00036,00736,007(113,663)(75.94) Totals for dept 990 - OTHER/RESERVE/CONTINGEN0074,920149,6700149,670.000.00036,00736,007(113,663)(75.94) TOTAL ESTIMATED REVENUES4,49791,64774,920193,87289,610104,262.002.0289,61099,70799,707(94,165)(48.57) APPROPRIATIONS Dept 171 - POLICE OPERATING EXPENDITURES/EXPENSE Expenditure 605-171-534.300OTHER CONTRACTUAL SERVICES08,750022,25015,9746,276.000.7222,25037,25037,25015,00067.42 605-171-540.300TRAVEL & PER DIEM1,51200000.000.0000000.00 605-171-546.320COMPUTER SYSTEM MAINT & SUP01,3914,92011,9204,8127,108.000.404,8124,9574,957(6,963)(58.41) 605-171-552.302SMALL TOOLS AND EQUIPMENT09,44128,00028,00012,82815,172.000.4617,83222,50022,500(5,500)(19.64) TOTAL EXPENDITURE1,51219,58232,92062,17033,61428,556.001.5844,89464,70764,7072,5374.08 OPERATING EXPENDITURES/EXPENSE1,51219,58232,92062,17033,61428,556.001.5844,89464,70764,7072,5374.08 CAPITAL OUTLAY Expenditure 605-171-664.600MACH/EQUIPMENT0042,00087,50072,64514,855.000.8382,39235,00035,000(52,500)(60.00) TOTAL EXPENDITURE0042,00087,50072,64514,855.000.8382,39235,00035,000(52,500)(60.00) CAPITAL OUTLAY0042,00087,50072,64514,855.000.8382,39235,00035,000(52,500)(60.00) Totals for dept 171 - POLICE1,51219,58274,920149,670106,25943,411.002.41127,28699,70799,707(49,963)(33.38) Dept 175 - POLICE DEPARTMENT CAPITAL OUTLAY Expenditure 605-175-664.602VEHICLES00044,202044,202.000.0044,20200(44,202)(100.00) TOTAL EXPENDITURE00044,202044,202.000.0044,20200(44,202)(100.00) CAPITAL OUTLAY00044,202044,202.000.0044,20200(44,202)(100.00) Totals for dept 175 - POLICE DEPARTMENT00044,202044,202.000.0044,20200(44,202)(100.00) TOTAL APPROPRIATIONS1,51219,58274,920193,872106,25987,613.002.41171,48899,70799,707(94,165)(48.57) Page 79 of 79 NET OF REVENUES/APPROPRIATIONS - FUND 6052,98572,06500(16,649)(16,649.00)4.43(81,878)0000.00 ESTIMATED REVENUES - ALL FUNDS21,275,12533,224,40131,282,98036,653,58119,256,28117,397,300.00(83.00)28,003,23336,265,58037,923,01300.00 APPROPRIATIONS - ALL FUNDS20,633,64426,760,35731,282,98036,653,58119,089,37417,564,207.00417.0030,671,37237,546,07937,923,01300.00 NET OF REVENUES/APPROPRIATIONS - ALL FUNDS641,4816,464,04400166,907166,907.00446.40(2,668,139)(1,280,499)0