Loading...
HomeMy WebLinkAboutDocumentation_Regular_4/9/2020 Village of Tequesta Department of Fire-Rescue Services 357 Tequesta Drive /y�'�° 561 768 0500 Tequesta, FL 33469 j. �� www.tequesta,org I.k � 4.n stir n n x, James Trube, Fire Chief TO: Jeremy Allen, Village Manager CC: Senior Staff FROM: James Trube, Director of Emergency Management APPROVED DATE: April 9, 2020 SUBJECT: Council Report Council Report • State of Florida 15456 total cases with 323 deaths. • Palm Beach County COVID-19 cases as of 4/7/2020 1900 hours • Confirmed 1,224 • Residents 1,183 • Residents outside Florida 2 • Non Residents 39 • Deaths 69 • Hospitalizations 215 • 2 Major Testing Sites in PBCO • 1 1 ST Responder Testing Site in PBCO • Confirmed in Tequesta Area 12 ■ COVID-19 Response: o EOC —All members of the EOC staff have done an outstanding job of keeping up with this ever-changing and challenging environment. This has been called the most complex emergency management response in the history of Florida. ■ Web EOC is being monitored 7 days per week ■ Palm Beach County Emergency Management conference calls 7 days per week ■ Weekly State Emergency Management conference calls ■ Weekly Palm Beach County Fire Chiefs conference calls ■ State Emergency Medical Services conference calls ■ 18 State of Florida Executive Orders ■ 3 PBCO Orders ( with multiple updates) ■ Tequesta Situation Report issued daily, combining updated activity of all Village Departments Vice-Mayor Kristi Johnson Mayor Abby Brennan Council Member Vince Arena Council Member Laurie Brandon Council Member Kyle Stone Village Manager Jeremy Allen Update of Tequesta Emergency Declaration is on going o Public Communications All Public Information is being routed through the Village Clerk. ■ Tequesta Web Site updated with COVID 19 Information ■ FD Social media posts in concert with VOT and TPD ■ Daily contact with Jupiter Medical Center and Assisted Living Facilities o Eleven (11) new departmental bulletins issued related to COVID-19 to date o Temporary substation established at Coast Guard facility ■ MOU signed with Bureau of Land Management ■ Allows for Separation of crews to minimize potential loss of crew due to exposure to COVID 19 and to provide Continuity of Operations should Main station require significant decontamination ■ This station was operational within 2 weeks from planning. o Response to emergency incidents ■ Policies written to modified apparatus response • Rescue only on majority of EMS calls for service • Modified medical procedures to reduce risk of exposure (nebulizer treatments replaced with Epinephren injections) • Dispatch screening criteria based on CDC guidelines • Limiting initial patient contact to one paramedic • Additional crew brought in only as needed • Crews wearing enhanced personal protective equipment (PPE) on all medical calls. (Gloves, gowns, Tyvek suits, P100 full facemask respirator) o Logistics - In general it is becoming more difficult to find needed items; however we are in a strong position because we were prepared and made several early purchases. • Numerous purchases of personal protective equipment items • Purchase of disinfecting items • Purchase of washer/dryer for temporary station o Exposure limiting practices in stations/vehicles/equipment ■ Exposure Control • No Visitors Allowed in Stations • Screening employees prior to entering building • Temperature and CDC questionnaire • Practicing social distancing within stations • Wearing of facial covering if social distancing not maintained • Suspended existing business annual inspections except vacant premises • New Construction inspections being performed for unoccupied premises or if able to be performed from exterior • Several bulletins created related to enhanced policies/procedures • Enhanced disinfection procedures for ambulances— including • Any sick personnel must contact Infectious Control Officer ■ Disinfection procedures • Several bulletins created related to enhanced policies/procedures • Four(4) levels of cleaning/disinfection established • Daily disinfection of work/living areas • Level 3 cleaning as needed (use of fogger/sprayers) • Biweekly deep cleaning of stations by outside vendor • Enhanced disinfection procedures for ambulances— including use of foggers/sprayers ■ ISO (Insurance Services Organization) Rating Survey o Postponed for 6 weeks o Preparations for survey being performed as time allows Monthly Police Updates Council Daily coverage on 707 Bridge /Daily Marine Patrol Sanitized Police Building Daily Conference Calls with County/Weekly with Chiefs Association Equipped all police vehicles with PPE, Sanitizer, Wipes, and disinfectant spray - Changed internal protocols regarding roll-call, response to service calls Per council's request, provided acknowledgment (pizza) to Gardens PD reference Defensive Tactics Training Radio Training for NorthCom Processing bullet proof vest grant (50% reimbursement) Assisting with US 1 Crosswalk annual friction testing - April 8' from 9pm— 5 a Village of Tequesta 345 Tequesta Drive 561-768-0700 Tequesta, FL 33469 www.tequesta.org To: Honorable Mayor and Village Council Through: Jeremy Allen—Village Manager Froin: Matthew Hammond—Utilities Director Date: Wednesday,April 8,2020 Re: Utilities Department Monthly Report Utilities Department March 13, 2020 — April 8, 2020 • The department Pandemic Continuity of Operations Plan (COOP) was implemented and continues to be followed. The goal of the Pandemic COOP is to protect employees and reduced risk of a loss of essential services due to a reduction in staffing. • National Metering Services continued to replace small water meters (less than 2") through the Utility Service Area. 784 meters have been replaced to date (41.889/o) with 1,088 remaining. Only, minor issues have come up during the replacement process which have been rectified immediately. • Advanced Metering Infrastructure (AMI) antenna's and base stations have been installed and the new meter reading software is in the process of being implemented internally. • 1 wo water breaks were repaired during the month, both on 1950's and 1960's era asbestos cement pipe. Vice-Mayor Kristi Johnson Mayor Abby Brennan Council Member Vince Arena Council Member Laurie Brandon Council Member Kyle Stone Village Manager Jeremy Allen Regular Council y STAFF MEMO -' Meeting: Regular Council - Apr 09 2020 Staff Contact: Jeremy Allen, Village Manager Department: Manager Managers Report - April Additional Information 1. The Financial Reports presented above are unadjusted and unaudited. The Village considers revenues available if collected within 45 days of the current fiscal period. This means that there are additional revenues and expenditures that have not been recorded to date and that will be recorded once year-end adjustments are completed. Additionally, during the year, revenues and expenses are recorded on a modified accrual basis (similar to a cash basis). This will result in significant differences between our beginning balances in the enterprise funds (water, refuse and recycling and stormwater) and the adjusted ending balances as these funds report on a full accrual basis. 2. Property Taxes collected are $6.8 million, which represents 91% of the budgeted amount. It is $459 thousand higher than the prior fiscal year. Historically, 91% of ad valorem tax distribution receipted by the end of February. 3. Sales Taxes collected $206 thousand, which represent 43% of the budgeted amount and on target for five-month collection due to the distribution to be one month behind the collection/reported period. 4. Sales/use taxes (39%) fall below 50% budget target due to the distribution to be one month behind the collection/reported period and Insurance premium tax to be collected at the year- end as one distribution. 5. Intergovernmental revenues (43%) fall below 50% budget target due to the distribution to be one month behind the collection/reported period and on target for five-month collection. 6. Local discretionary infrastructure surtax collected $151 thousand, which represent 35% of the budgeted amount and on target for four-month collection due to the distribution to be two months behind the collection/reported period. 7. Revenues (Budgetary comparison) recorded in the General fund represents 68% of budgeted due to the distribution nature of Ad valorem taxes collected at 91% and represent 72% of overall General fund revenues at 3/31/2020. There will be a significant decrease in the investment earnings mainly due to the investment balance decrease. In order to safeguard Village's assets, investment balances were transferred to cash account. 8. Overall Expenditures (Budgetary comparison) in the General Fund represents 45% of budgeted, which is slight below target budgeted due to the fact that not all the expenditures recorded for the services provided up to 3/31/20 and personnel expenditures recorded as paid not when accrued.Personnel paid date 3/19/20 for the period ended 3/14/20. 9. Revenues (Prior year comparison) all funds increased by $300 thousand (2%) due to the ad valorem revenues collected $459 thousand more at 3/31/2020 than prior year and partially offset by decrease in permit revenues due to the fee schedule adjustment. 10) Expenditures (Prior year comparison) all funds has increased by $1.3 million (19%) mainly due to the Water Plant upgrade project $1.5 million (67%) increase. Complete Monthly Report 04/03/2020 11:22 AM BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 1/7 User: tracanati Period Ending 03/31/2020 DB: Teauesta Fund 001 GENERAL FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 6,855,773.11 Investments 23,623.66 Accounts Receivable 109,361.01 Due from Other Funds 0.00 Inventories 41,289.16 Prepaids 27,490.63 Other Assets - Current 0.00 Other Fixed Assets 0.00 Total Assets 7,057,537.57 *** Liabilities *** Accounts Payable 10,933.03 Accrued liabilities (11,653.47) Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 5,159.93 Deferred Revenue 0.00 Other Current Liabilities 0.00 Customer Deposits 0.00 Noncurrent liabilities 0.00 Def Inflows of Resources 136,250.13 Total Liabilities 140,689.62 *** Fund Balance *** F/B - Reserved for Inventories 0.00 F/B - Res for Encumbrance 0.00 F/B - All Other Reserves 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 237,510.34 Fund Balance - Restricted 1,562,700.04 Fund Balance - Committed 391,214.00 Fund Balance - Assigned 0.00 Fund Balance - Unassigned 1,479,004.47 Total Fund Balance 3,670,428.85 Beginning Fund Balance 3,670,428.85 Net of Revenues VS Expenditures 3,246,419.10 Ending Fund Balance 6,916,847.95 Total Liabilities And Fund Balance 7,057,537.57 04/03/2020 11:22 AM BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 2/7 User: tracanati Period Ending 03/31/2020 DB: Teauesta Fund 301 Capital Improvement Fund GL Number Description Balance *** Assets *** Cash and Cash Equivalents 574,192.45 Investments 0.00 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 574,192.45 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - All Other Reserves 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 0.00 Fund Balance - Restricted 422,754.00 Fund Balance - Assigned 0.00 Fund Balance - Unassigned 20,854.19 Total Fund Balance 443,608.19 Beginning Fund Balance 443,608.19 Net of Revenues VS Expenditures 130,584.26 Ending Fund Balance 574,192.45 Total Liabilities And Fund Balance 574,192.45 04/03/2020 11:22 AM BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 3/7 User: tracanati Period Ending 03/31/2020 DB: Teauesta Fund 303 Capital Projects Fund GL Number Description Balance *** Assets *** Cash and Cash Equivalents 139,325.29 Investments 0.00 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Improvements Other Than Bldgs. 0.00 Total Assets 139,325.29 *** Liabilities *** Accounts Payable 0.00 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - Unreserved/Undesignated 0.00 Fund Balance - Nonspendable 0.00 Fund Balance - Assigned 0.00 Fund Balance - Unassigned 154,312.79 Total Fund Balance 154,312.79 Beginning Fund Balance 154,312.79 Net of Revenues VS Expenditures (14,987.50) Ending Fund Balance 139,325.29 Total Liabilities And Fund Balance 139,325.29 04/03/2020 11:22 AM BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 4/7 User: tracanati Period Ending 03/31/2020 DB: Teauesta Fund 401 Water Fund GL Number Description Balance *** Assets *** Current Assets 0.00 Cash and Cash Equivalents 4,957,504.67 Investments 40,479.58 Accounts Receivable 603,092.78 Special Assess -Current 0.00 Special Assess - noncurrent 0.00 Due from Other Funds 0.00 Inventories 181,445.80 Prepaids 11,854.27 Other Assets - Current 0.00 Land 83,335.00 Other Assets - Non Current 83,335.00 INFRASTRUCTURE 14,120,256.79 Buildings 256,740.48 Improvements Other Than Bldgs. 29,360.00 Machinery & Equipment 184,457.27 Construction in Progress 1,212,079.89 Intangible Assets 54,814.52 Other Fixed Assets 0.00 Deferred Outflows 492,222.62 FIXED ASSETS 0.00 Total Assets 22,227,643.67 *** Liabilities *** Accounts Payable 40,103.91 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 511.37 Deferred Revenue 0.00 Current Portion of Debt 403,465.51 Other Current Liabilities 0.00 Customer Deposits 33,532.60 Noncurrent liabilities 3,119,114.03 Other Long Term Liabilities 411,841.38 Def Inflows of Resources 185,264.00 Total Liabilities 4,193,832.80 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - All Other Reserves 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 N.A., Inv in Cap, net of debt 11,584,763.87 Net Assets, Restricted 0.00 Fund Balance - Committed 500,000.00 Fund Balance - Unassigned 6,720,630.67 Total Fund Balance 18,805,394.54 Beginning Fund Balance 18,805,394.54 Net of Revenues VS Expenditures (771,583.67) Ending Fund Balance 18,033,810.87 Total Liabilities And Fund Balance 22,227,643.67 04/03/2020 11:22 AM BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 5/7 User: tracanati Period Ending 03/31/2020 DB: Tequesta Fund 402 Refuse & Recycling GL Number Description Balance *** Assets *** Cash and Cash Equivalents 369,247.07 Investments 0.00 Accounts Receivable 0.00 Other Assets - Current 0.00 Total Assets 369,247.07 *** Liabilities *** Accounts Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** F/B - Unreserved/Undesignated 0.00 Fund Balance - Unassigned 126,638.37 Total Fund Balance 126,638.37 Beginning Fund Balance 126,638.37 Net of Revenues VS Expenditures 242,608.70 Ending Fund Balance 369,247.07 Total Liabilities And Fund Balance 369,247.07 04/03/2020 11:22 AM BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/7 User: tracanati Period Ending 03/31/2020 DB: Tequesta Fund 403 Stormwater Utility GL Number Description Balance *** Assets *** Cash and Cash Equivalents 1,243,673.22 Investments 0.00 Accounts Receivable 600.00 Due from Other Funds 0.00 Inventories 763.27 Prepaids 0.00 Other Assets - Current 0.00 Other Assets - Non Current 0.00 INFRASTRUCTURE 1,017,457.10 Buildings 0.00 Improvements Other Than Bldgs. 0.00 Machinery & Equipment 10,476.33 Construction in Progress 0.00 Deferred Outflows 19,949.00 Total Assets 2,292,918.92 *** Liabilities *** Accounts Payable 1,837.69 Accrued liabilities 0.00 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 0.00 Current Portion of Debt 0.00 Other Long Term Liabilities 13,818.51 Def Inflows of Resources 9,647.00 Total Liabilities 25,303.20 *** Fund Balance *** F/B - Res for Encumbrance 0.00 F/B - Unreserved - Designated 0.00 F/B - Unreserved/Undesignated 0.00 N.A., Inv in Cap, net of debt 1,236,387.06 Fund Balance - Unassigned 811,216.33 Total Fund Balance 2,047,603.39 Beginning Fund Balance 2,047,603.39 Net of Revenues VS Expenditures 220,012.33 Ending Fund Balance 2,267,615.72 Total Liabilities And Fund Balance 2,292,918.92 04/03/2020 11:22 AM BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 7/7 User: tracanati Period Ending 03/31/2020 DB: Teauesta Fund 605 Special Law Enforcement GL Number Description Balance *** Assets *** Cash and Cash Equivalents 84,744.20 Investments 0.00 Accounts Receivable 0.00 Inventories 0.00 P--epaids 0.00 Total Assets 84,744.20 *** Liabilities *** Accounts Payable 0.00 Due to Other Funds 0.00 Total Liabilities 0.00 *** Fund Balance *** Fund Balance - Nonspendable 0.00 Fund Balance - Assigned 0.00 Fund Balance - Unassigned 81,991.20 Total Fund Balance 81,991.20 Beginning Fund Balance 81,991.20 Net of Revenues VS Expenditures 2,753.00 Ending Fund Balance 84,744.20 Total Liabilities And Fund Balance 84,744.20 VILLAGE OF TEQUESTA Cash&Investments Unadjusted 3/31/2020 SBA Prime Cash Investments Total General Fund 4001 6,855,773 23,624 $ 6,879,397 Capital Improvement Fund#301 574,192 0 574,192 Capital Projects Fund 4303 139,325 0 139,325 Water Utility#401 4,957,505 40,480 4,997,984 Refuse&Recycling#402 369,247 0 369,247 Stormwater 4403 1,243,673 0 1,243,673 Special Law Enforcement#605 84,744 0 84,744 Total Cash and Investments $ 14,224,460 $ 64,103 $ 14,288,563 VILLAGE OF TEQUESTA REVENUE AND EXPENDITURE REPORT-UNADJUSTED,UNAUDITED 3/31/2020 YTD BALANCE YTD BALANCE DESCRIPTION 3/31/2019 3/31/2020 VARIANCE %VARIANCE NOTES REVENUES General Property Taxes 6,337,182 6,796,208 459,026 7.24% Sales&Use Taxes 593,685 597,962 4,278 0.72% Franchise fees-gross receipt 241,233 236,645 (4,588) -1.90% Licenses&Permits 374,151 209,056 (165,095) -44.13%Build department fee schedule decrease Intergovernmental Revenue 372,233 377,669 5,436 1.46% Chgs for Sery-Gen Gov 20,135 106,481 86,345 428.82%Land development fee schedule increase Intragovernmental Revenue 297,350 362,718 65,368 21.98%Implemented Admin fees from Building Department Rents&Royalties 110,522 111,753 1,232 1.11% Miscellaneous Revenues 49,269 41,799 (7,470) -15.16%Differs from year to year Grants-State 0 5,500 5,500 100.00%Differs from year to year Chgs for Sery-Public Safety 531,892 493,145 (38,748) -7.28%EMS services Mar 2020 revenue is not recorded Fines&Forfeitures 45,858 8,654 (37,204) -81.13%Code enforcement fees differs Impact Fees 425 3,544 3,118 733.20%Differs from year to year Charges for Services-Recr. 47,648 48,043 395 0.83% Contributions&Donations 7,900 5,500 (2,400) -30.38%Tequesta Fest donations lower in FY 2020 Unrestricted Investment Earning 131,114 98,342 (32,772) -25.00%Investment interest rate and balance decrease Other Financing Sources 35,799 41,246 5,447 15.21%Water utility capital connect charges Transfers In 0 127,100 127,100 100.00%Transfers differ from year to year Charges for Services 3,662,621 3,614,777 (47,844) -1.31% TOTAL REVENUES 12,859,017 13,286,141 427,124 3.32% TOTAL REVENUES LESS TRANSFERS 12,859,017 13,159,041 300,024 2.33% EXPENDITURES General Fund 5,843,901 6,032,773 188,873 3.23% Capital Improvement Fund 19,720 0 (19,720) -100.00% Capital Projects 35,000 14,988 (20,013) -57.18%Architectural svcs for the recreation facility Water Fund 2,205,766 3,676,607 1,470,841 66.68%WTP upgrade project Refuse&Recycling 200,506 207,553 7,048 3.51% Stormwater Utility 178,877 169,902 (8,974) -5.02% Special Law Enforcement 0 1,512 1,512 100.00% Transfers out 0 127,000 127,000 100.00% TOTAL EXPENDITURES 8,483,768 10,230,335 1,746,566 20.59% TOTAL EXP LESS TRANSFERS 8,483,768 10,103,235 1,619,466 19.09% NET OF REVENUES&EXPENDITURES 4,375,249 3,055,806 (1,319,443) VILLAGE OF TEQUESTA REVENUE REPORT-UNADJUSTED,UNAUDITED 3/31/2020 YTD BALANCE YTD BALANCE DESCRIPTION 3/31/2019 3/31/2020 VARIANCE I %VARIANCE NOTES REVENUES Fund 001-GENERAL FUND General Property Taxes 6,337,182 6,796,208 459,026 7.24% Sales&Use Taxes 593,685 597,962 4,278 0.72% Franchise fees-gross receipt 241,233 236,645 (4,588) -1.90% Licenses&Permits 374,151 209,056 (165,095) -44.13% Build department fee schedule decrease Intergovernmental Revenue 372,024 377,669 5,645 1.52% Chgs for Sery-Gen Gov 20,135 106,481 86,345 428.82% Land development fee schedule increase Intragovernmental Revenue 297,350 362,718 65,368 21.98% Implemented Admin fees from Build Department Rents&Royalties 110,522 111,753 1,232 1.11% Miscellaneous Revenues 20,048 6,853 (13,195) -65.82% Differs from year to year Grants-State 0 1,235 Chgs for Sery-Public Safety 531,892 493,145 (38,748) -7.28% EMS services Mar 2020 revenue is not recorded Fines&Forfeitures 45,858 8,195 (37,664) -82.13% Code enforcement fees differs Impact Fees 425 3,544 3,118 733.20% Differs from year to year Charges for Services-Recr. 47,648 48,043 395 0.83% Contributions&Donations 7,900 5,500 (2,400) -30.38%Tequesta Fest donations lower in 2020 Unrestricted Investment Earning 63,174 41,157 (22,017) -34.85% Investment interest rate and balance decrease Other Financing Sources 21,783 30 (21,753) -99.86% Disposition/sale of assets differs Total General Fund 9,085,010 9,406,192 321,183 3.54% Fund 301-Capital Improvement Fund Unrestricted Investment Earning 0 3,484 3,484 100.00% Increase in the investment account balance Transfers In 0 127,100 127,100 100.00%Transfers differ from year to year Total Capital Improvement Fund 0 130,584 130,584 100.00% Fund 303-Capital Projects Fund Transfers In 0 0 0 0.00% Total Capital Projects Fund: 0 0 0 0.00% Fund 401-Water Fund Miscellaneous Revenues 29,221 34,946 5,725 19.59% Fines&Forfeitures 0 459 Unrestricted Investment Earning 55,604 45,022 (10,582) -19.03% Interest rate and balance decrease Other Financing Sources 14,016 41,216 27,200 194.06% Increase in capital connect charges Charges for Services 2,821,428 2,783,379 (38,048) -1.35% Total Water Fund: 2,920,269 2,905,023 (15,246) -0.52% Fund 402-Refuse&Recycling Intergovernmental Revenue 209 0 (209) -100.00% Unrestricted Investment Earning 945 584 (361) -38.20% Investment interest rate and balance decrease Charges for Services 446,212 449,578 3,366 0.75% Total Refuse&Recycling: 447,366 450,162 2,796 0.63% Fund 403-Stormwater Utility Unrestricted Investment Earning 11,391 8,095 (3,297) -28.94% Investment interest rate and balance decrease Charges for Services 394,981 381,820 (13,162) -3.33% Total Stormwater Utility: 406,373 389,914 (16,458) -4.05% Fund 605-Special Law Enf Grants-State 0 4,265 4,265 100.00% Differs from year to year Total Special Law Enf 0 4,265 4,265 100.00% TOTAL REVENUES-ALL FUNDS 12,859,017 13,286,141 427,124 3.32% TOTAL REVENUE LESS TRANSFERS 12,859,017 13,159,041 300,024 2.33% VILLAGE OF TEQUESTA EXPENDITURE REPORT-UNADJUSTED,UNAUDITED 3/31/2020 YTD BALANCE YTD BALANCE % DESCRIPTION 3/31/2019 3/31/2020 VARIANCE I VARIANCE NOTES EXPENDITURES Fund 001-GENERAL FUND Council 23,756 28,323 4,567 19.23% Computer purchases Manager 119,141 130,673 11,533 9.68% Human Resources 181,027 '171,202 (9,825) -5.43% Comp.system&part time salaries decrease Village Clerk 174,866 164,754 (10,112) -5.78% Computer equipment not budgeted in FY2020 Finance 204,014 209,238 5,224 2.56% Legal 70,200 38,773 (31,427) -44.77% Decrease in personnel legal fees Comprehensive Planning 69,270 64,754 (4,516) -6.S2% General Government 152,115 147,390 (4,725) -3.11% IT 95,080 98,104 3,025 3.18% Police Department 1,632,467 1,532,084 (100,382) -6.15% VOT pension contributions police decrease Building&Zoning 235,696 345,653 109,957 46.65% Admin Mgmt Fees implementation Code Compliance 47,818 44,853 (2,965) -6.20% Legal exp differ based on the number of cases Fire Control 1,640,459 1,787,595 147,136 8.97% Regular salaries and pension contrib increase Public Works 584,342 657,145 72,802 12.46% Pathway and roads maintenance Leisure Services 349,627 348,636 (991) -0.28% Debt Service 262,559 262,542 (17) -0.01% Interfund Transfers 0 127,100 127,100 0.00%Transfers differ from year to year Other Nonoperating 1,465 953 (512) -34.92% Total General Fund 5,843,901 6,159,773 315,873 5.41% Fund 301-Capital Improvement Fund Public Works 19,720 0 (19,720) -100.00% Pathways and sidewalks maintenance Total Capital Improvement Fund: 19,720 0 (19,720) -100.00% Fund 303-Capital Projects Fund Recreation Center 35,000 14,988 (20,013) -57.18% Architectural Svcs for the recreation facility Total Capital Projects Fund: 35,000 14,988 (20,013) -57.18% Fund 401-Water Fund Water-Administration 599,818 715,741 115,923 19.33% Health insurance increase,family coverage Water- Production 838,511 854,150 15,640 1.87% Water-Distribution 460,165 437,731 (22,434) -4.88%Comp.absenses at 0 Renewal&Replacement 76,854 1,366,581 1,289,727 1678.16% WTP upgrade project Debt Service 222,723 223,218 496 0.22% Other Nonoperating 7,696 79,186 71,490 928.95% Legal settlement,personnel Total Water Fund: 2,205,766 3,676,607 1,470,841 66.68% Fund 402-Refuse&Recycling Refuse and Recycling 200,506 207,553 7,048 3.51% Total Refuse&Recycling: 200,506 207,553 7,048 3.51% Fund 403-Stormwater Utility Storm Water Utilities 101,657 148,860 47,203 46.43% Other contractual svcs and drainage maint,capital Renewal&Replacement 77,220 21,042 (56,177) -72.75% Engineering and drainage maint Other Nonoperating 0 0 0 0.00% Total Stormwater Utility: 178,877 169,902 (8,974) -5.02% Fund 605-Special Law Enforcement Police 0 1,512 1,512 100.00% Total Special Law Enforcement: 0 1,512 1,512 100.00% TOTAL EXPENDITURES-ALL FUNDS 8,483,768 10,230,335 1,746,566 20.59% TOTAL EXP LESS TRANSFERS 8,483,768 10,103,235 1,619,466 19.09% THE VILLAGE OF TEQUESTA REVENUE REPORT-UNADJUSTED,UNAUDITED 3/31/2020 2019-20 2019-20 50.00% ORIGINAL AMENDED TARGET YTD BALANCE DOLLAR PERCENT %BDGT DESCRIPTION BUDGET BUDGET BUDGET 3/31/2020 VARIANCE VARIANCE USED NOTES Fund 001-GENERAL FUND General Property Taxes 7,482,400 7,482,400 3,741,200 6,796,208 3,055,008 81.66% 90.83 9046 of rev receipted by the end of Feb Sales&Use Taxes 1,547,900 1,547,900 773,950 597,962 (175,988) -22.74% 38.63 State rev distribisone/two month behind Franchise fees-gross receipt 460,000 460,000 230,000 236,645 6,645 2.89% 51.44 Licenses&Permits 737,100 737,100 368,550 209,056 (159,494) -43.28% 28.36 Building permits Intragovernmental Revenue 725,450 725,450 362,725 362,718 (7) 0.005A 50.00 Grants-State 0 0 0 1,235 1,235 100.00% 100.00 Intergovernmental Revenue 888,300 888,300 444,150 377,669 (66,481) -14.97% 42.52 State clmrib one month behind Chgs for Sery-Gen Gov 172,000 172,000 86,000 106,481 20,481 23.81% 61.91 Land development fee schedule increase Chgs for Sery-Public Safety 1,162,900 1,162,900 581,450 493,145 (88,305) -15.19% 42.41 EMS rev Mar 2020 revenue is not recorded Charges for Services-Recr. 76,050 76,050 38,025 48,043 10,018 26.35% 63.17 Summer camp fees collected in advance Fines&Forfeitures 16,000 16,000 8,000 8,195 195 2.43% 51.22 code enforcement fees differs Unrestricted Investment Earning 115,000 115,000 57,500 41,157 (16,343) -28.42% 35.79 Inv interest rate and balance decrease Rents&Royalties 221,600 221,600 110,800 111,753 953 0.86% 50.43 Impact Fees 1,000 1,000 500 3,544 3,044 608.75% 354.38 Budgeted at low Contributions&Donations 5,000 5,000 2,500 5,500 3,000 120.00% 110.00 Tecuesta Festcontrib. Miscellaneous Revenues 49,750 49,750 24,875 6,853 (18,022) -72.45% 13.78 Differ from year to year Other Financing Sources 15,000 157,930 78,965 30 (78,935) -99.96% 0.02 Lease at inception police vehicles Appropriate Fund Balance 0 0 0 0 Total General Fund 13,675,450 13,818,380 6,909,190 9,406,192 2,497,002 36.14% 68.07 Fund 301-Capital Improvement Fund Unrestricted Investment Earn 0 0 0 3,484 3,484 100.00% 100.00 Other Financing Sources 0 0 0 0 0 0.00% 0.00 Transfers In 127,100 127,100 63,550 127,100 63,550 100.00% 100.00 Appropriate Fund Balance 0 349,775 174,888 0 Total Capital Improvement Fund: 127,100 476,875 238,438 130,584 (107,853) -45.23% 27.38 Fund 303-Capital Projects Fund Other Financing Sources 0 0 0 0 0 0.00% 0.00 Appropriate Fund Balance 154,000 154,000 0 0 Total Capital Projects Fund: 154,000 154,000 77,000 0 (77,000) -100.00% 0.00 Fund 401-Water Fund Charges for Services 6,361,800 6,361,800 3,180,900 2,783,379 (397,521) -12.50% 43.75 water sales decrease Fines&Forfeitures 0 0 0 459 459 100.00% 0.00 Unrestricted Investment Earn 120,000 120,000 60,000 45,022 (14,978) -24.96% 37.52 Inv interest rate and balance decrease Miscellaneous Revenues 26,200 26,200 13,100 34,946 21,846 166.76% 133.38 Tropic Vista collections Other Financing Sources 41,216 Appropriate Fund Balance 130,500 1,272,657 0 0 Total Capital Projects Fund: 6,638,500 7,780,657 3,890,329 2,905,023 (985,306) -25.33% 37.34 Fund 402-Refuse&Recycling Charges for Services 484,000 484,000 242,000 449,578 207,578 85.78% 92.89 90%of rev receipted by the end of Feb Unrestricted Investment Earn 2,000 2,000 1,000 584 (416) -41.609A 29.20 Inv interest rate and balance decrease Appropriate Fund Balance 11,100 11,100 0 0 Total Refuse&Recycling: 497,100 497,100 248,550 450,162 201,612 44.17% 90.56 Fund 403-Stormwater Utility Charges for Services 457,700 457,700 228,850 381,820 152,970 66.84% 83.42 90%of rev receipted by the end of Feb Unrestricted Investment Earn 22,500 22,500 11,250 8,095 (3,156) -28.05% 35.98 Inv interest rate and balance decrease Appropriate Fund Balance 164,050 274,430 0 0 0 Total Stormwater Utility: 644,250 754,630 377,315 389,914 12,599 -28.05% 51.67 Fund 605-Special Law Enforcement Appropriate Fund Balance 0 2,296 1,148 4,265 Total Special Law Enforcement 0 2,296 1,148 4,265 3,117 0.00% 0.00 TOTAL REVENUES-ALL FUNDS 21,736,400 23,483,938 11,741,969 13,286,141 1,544,172 13.15% 56.58 TOTAL REV-LESS APPROPRIATION 21,276,750 21,419,680 10,709,840 13,286,141 2,576,301 24.06% 62.03 THE VILLAGE OF TEQUESTA EXPENDITURE REPORT-UNADJUSTED,UNAUDITED 3/31/2020 2019-20 2019-20 50.00% YTD BALANCE ORIGINAL AMENDED TARGET 3/31/2020 DOLLAR PERCENT %BDGT DESCRIPTION BUDGET BUDGET BUDGET VARIANCE VARIANCE USED Fund 001-General Fund Council 68,050 68,050 34,025 29,440.86 (4,584) -13.47% 43.26 Manager 286,100 286,100 143,050 130,673.39 (12,377) -8.65% 45.67 Human Resources 386,750 386,750 193,375 171,201.76 (22,173) -11.47% 44.27 Village Clerk 370,150 370,150 185,075 164,754.29 (20,321) -10.98% 44.51 Finance 425,400 425,400 212,700 209,238.09 (3,462) -1.63% 49.19 Legal 180,000 180,000 90,000 38,773.47 (51,227) -56.92% 21.54 Comprehensive Planning 163,800 163,800 81,900 64,753.70 (17,146) -20.94% 39.53 General Government 299,200 306,000 153,000 147,760.28 (5,240) -3.42% 48.29 IT 219,400 219,400 109,700 98,104.10 (11,596) -10.57% 44.71 Police Department 3,394,230 3,473,424 1,736,712 1,533,123.30 (203,589) -11.72% 44.14 Building&Zoning 680,750 696,791 348,396 345,769.04 (2,626) -0.75% 49.62 Code Compliance 93,750 93,750 46,875 44,853.10 (2,022) -4.31% 47.84 Fire Control 4,263,150 4,293,886 2,146,943 1,791,206.99 (355,736) -16.57% 41.72 Public Works 1,408,500 1,405,400 702,700 659,358.52 (43,341) -6.17% 46.92 Leisure Services 690,650 686,950 343,475 349,693.17 6,218 1.81% 50.91 Debt Service 456,120 475,029 237,515 262,541.99 25,027 10.54% 55.27 Interfund Transfers 127,100 127,100 63,550 127,100.00 63,550 100.00% 100.00 Other Nonoperating 162,350 160,400 80,200 953.38 (79,247) -98.81% 0.59 Total General Fund 13,675,450 13,818,380 6,909,190 6,169,299 (739,891) -10.71% 44.65 Fund 301-Capital Improvement Fund Public Works 0 211,775 105,888 0 (105,888) -100.00% 0.00 Misc Proj-Police Radios 0 138,000 69,000 0 (69,000) -100.00% 0.00 Public Works 127,100 127,100 63,550 0 (63,550) -100.00% 0.00 Total Capital Improvement Fund: 127,100 476,875 238,438 0 (238,438) -100.00% 0.00 Fund 303-Capital Projects Fund Recreation Center 154,000 154,000 77,000 26,978 (50,023) -64.96% 17.52 Total Capital Projects Fund: 154,000 154,000 77,000 26,978 (50,023) -64.96% 17.52 Fund 401-Water Fund Water-Administration 1,480,950 1,516,138 758,069 716,531 (41,538) -5.48% 47.26 Water- Production 1,947,700 1,947,700 973,850 854,510 (119,340) -12.25% 43.87 Water-Distribution 955,550 955,550 477,775 437,970 (39,805) -8.33% 45.83 Renewal&Replacement 1,692,000 2,798,969 1,399,485 1,366,581 (32,904) -2.35% 48.82 Debt Service 537,300 537,300 268,650 223,218 (45,432) -16.91% 41.54 Other Nonoperating 25,000 25,000 12,500 79,186 66,686 533.49% 316.74 Total Capital Projects Fund: 6,638,500 7,780,657 3,890,329 3,677,996 (212,333) -5.46% 47.27 Fund 402-Refuse&Recycling Refuse and Recycling 497,100.00 497,100.00 248,550 207,553 (40,997) -16.49% 41.75 Other Nonoperating 0 0 0 0 0 0.00% 0.00 Total Refuse&Recycling: 497,100 497,100 248,550 207,553 (40,997) -16.49% 41.75 Fund 403-Stormwater Utility Storm Water Utilities 259,250 283,425 141,713 149,173.34 7,461 5.26% 52.63 Renewal&Replacement 300,000 386,205 193,103 21,042.40 (172,060) -89.10% 5.45 Other Nonoperating 85,000 85,000 42,500 0 (42,500) -100.00% 0.00 Total Stormwater Utility: 644,250 754,630 377,315 170,216 (207,099) -54.89% 22.56 Fund 605-Special Law Enforcement Police 0 2,296 1,148 1,512 364 100.00% 100.00 Total Special Law Enforcement 0 2,296 1,148 1,512 364 100.00% 100.00 TOTAL EXPENDITURES-ALL FUNDS 21,736,400 23,483,938 11,741,969 10,253,554 (1,488,415) -12.68% 43.66 Notes: 1)Not all operating expenditures/expenses recorded for the services up to 3/31/20 2)Personal expenditures/expenses recorded as when paid not when accrued.Personnel paid 3/19/20 for the period ended 3/14/20. 17 days of personnel expenditures not reflected in March 2020. 04/03/2020 11:25 AN, REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 1/27 jser: tracanati DB: Tegaesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2C'-9-20 03/31/2020 ENCUMBERED UNENCUMBERED BDG- GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED FUND 'axes _- Ad Valorem Taxes - Current %,482,400.00 7,4F2,4CO.00 6,795,286.06 0.00 687,11:.92 90.82 Ad Valorem Taxes-Del 0.00 C.00 921.77 0.70 (921.77) 1DO.00 -,fry Taxes 1,482,400.00 7,482,4-,0.00 6,796,20?.85 0.?0 686,192.15 90.83 INSURANCE PREM TAX FIRE _55,000.-,-, :55,000.00 0.00 0.70 155,000.00 0.00 -. ..._ Local Disc. Infrastructure Su 427,100.00 427,100.00 150,887.66 0.70 276,212.32 35.33 _- -__-.t" Utility Tax-Electricity 540,000.00 540,000.00 222,930.24 0.00 3_7,OE9.7b 41.26 - 7tility Tax - Natural Gas 0.00 0.00 924.14 0.70 (924.14) 170.00 Tax-Propane 32,000.00 32,OCO.00 12,933.83 0.70 _9,066."7 40.42 ':omm.Services Tax (CST) 300,800.00 300,BCO.CG 125,433.56 0.30 175,36E.44 41.70 kcal Business Tax 62,000.00 82,OCO.00 77,203.50 0.710 4,79E.50 94.15 Local Business Tax - County 1,000.00 11,000.00 7,649.20 0.70 3,350.80 69.54 Sales s Use 1c,>:es 1,54-1,900.00 1,547,900.00 597,962.15 0.70 949,937.85 38.63 .­ fees - gross receipt -...-..- .:.700 FRAN FEES-ELECTRIC 460,000.00 460,OCO.00 2336,047.38 0.70 223,952.62 51.31 £RAN FEES - NATURAL GAS 0.00 0.00 597,56 0.70 (597,56) 170.00 -axh-cs - gross receipt 460,000.00 460,000.00 236,644.94 0.70 223,355.06 51.44. 001-000-319SPECIAL EVENT PERMITS 0.00 0.00 560.00 0.7o (560.00) 1D0.00 :.i^enses ..._...,._t_ 0.00 0.00 560.00 0.70 (560.00) 100.00 Revenue Municipal Revenue Sharing Pro 193,500.00 _93,500.00 91,829.9% 0.70 101,670.03 47.46 t`:: Alcoholic Beverage Licenses 9,000.00 9,OCO.00 1,097.74 0.70 7,902.2b 12.20 Loc Gov 1/2 Cent Sales Tax Pr 481,600.00 481,CCO.00 205,993.98 0.70 275,o0E.O2 42.77 --.' 1.ocal Gas Tax-F Cent 135,;00.00 "35,1CC.00 52,6.75.36 0.70 62,42d_64 38.99 .. Local Gas Tax 1-5 Cent 62,400.00 62,400.00 24,424.12 0.70 37,975.88 39.14 __._-.� .. -......-.. al Revenue 681,600.00 861,6CO.00 376,021.17 0.7D 505,578.83 42.65 -� - 'c,Certificat..on:Copy Fees 25,000.00 25,000.00 14,192.43 0.10 _0,807.57 56.77 Election qualifying fees 0.00 0.00 90.00 0.70 (:+0.00.) 170.00 Admin Lees :ren, other Gov'rs 2,000.00 2,000.00 642.40 0.70 1,357.60 32.12 Cogs for SeLv - Gen Gov 27,000.00 27,000.00 14,924.83 0.70 _2,075.17 55.28 -.-.-i Revenue -.1310 ADP'IN MGMT FEES-BUILDING 104,100.00 _04,160.00 52,050.00 0.70 52,050.00 50.00 ADMIN MGMT FEES-WATER 598,600.00 598,6Co.00 299,298.00 0.70 299,302.00 50.00 - ._:.402 Admin Mgmt Fee-Ref s Recyclin 8,450.00 8,4=0.00 4,224.00 0.70 4,22E.00 49.99 -. ..403 AiT,-! P:gmt Fees - Storm Water 14,300.00 14,300.00 7,146.00 0.70 7,154.00 4x•97 ...:mental Reve,r.:- 725,450.00 725,450.00 362,718.00 0.70 362,732.00 50.00 - -ea-:e - Sprint 43,100.00 43,1C0.00 21,555.36 0.70 21,544.64 50.01 _-.. 362.1.'_2 Lease-T-Mobile 64,200.00 64,200.00 31,900.72 O.DO 32,299.26 49.69 - 0-352.11E Lease - AT&T 30,400.00 30,4CO.00 17,762.50 0.70 2,637,50 58.43 "_-000-352.11' Verizon-901 Old Dixie 44,000.00 44,OCC.00 21,899.76 0.70 22,100.24 49.77 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 2/27 User: tracanati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTC BALANCE ORIGINAL 2,-19-20 03/31/2020 ENCUMBERED UNENCUMBERED z BDG- GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED Fund 001 - GENERAL FUND 001-000-362.118 Verizon-136 Bridge Rd 32,400.00 32,4CO.00 16,159.26 0.30 _6,240.74 49.67 Rents & Royalties 214,100.00 214,iCO.00 109,277.60 0.30 104,822.40 51.04 Miscellaneous Revenues 001-000-359.000 Other Miscellaneous Revenue 5,000.00 5,OCO.00 240.81 0.30 4,759.19 4.82 001-000-369.100 Insurance Reimbursement 5,000.00 5,OCO.00 6,070.96 0.30 (1,070.94) 121.42 Miscellaneous Revenues '.0,000.00 10,000.00 6,311.75 0.70 3,688.25 63.12 Net - Dept 000 - GENERAL 11,348,450.00 11,348,450.60 6,560,628.29 0.70 2,847,821.7_ Dept 100 - Council Operating Expenditures/Expense 001-100-531.311 COUNCIL FEES - SEAT 1 - ARENA 7,750.00 7,750.00 3,820.32 0.30 3,925.68 49.29 001-100-5331.313 COUNCIL FEES - SEAT 4 - STONE 7,750.00 7,750.00 3,820.32 0.00 3,929.68 49.29 001-100-531.314 COUNCIL FEES - SEAT 5 - JOHNSON 7,150.00 7,750.00 3,820.32 0.30 3,929.68 49.29 001-100-531.316 COUNCIL FEES - SEAT 3 - BRANDON 7,150.00 7,750.00 3,820.32 0.00 3,925.68 49.29 001-100-531.317 COUNCIL FEES - SEAT 2 - BRENNAN 7,750.00 7,750.00 3,820.32 0.30 3,929.68 49.29 001-100-540.301 COUNCIL EXPENSES - SEAT 1 - ARENA 3,000.00 3,OCO.00 319.89 0.30 2,680.1_ 10.66 001-100-540.303 MAYORAL DUTIES 2,500.00 2,500.00 0.00 0.30 2,500.00 0.00 001-100-540.304 COUNCIL EXPENSES - SEAT 5 - JOHNSON 3,000.00 4,030.00 1,227.01 0.30 2,802.99 30.45 00i-100-540.306 COUNCIL EXPENSES - SEAT 3 - BRANDON 3,000.0,C 3,000.00 110.00 0.70 2,890.00 3.67 001-100-540.307. COUNCIL EXPENSES - SEAT 2 - BRENNAN 3,000.00 3,000.00 1,287.77 0.30 1,712.23 42.93 001-:00-540.308 COUNCIL EXPENSES - SEAT 4 - STONE 3,000.00 3,OCO.00 90.00 0.70 2,910.00 3.00 001-1_00-549.300 OTHER MISC CHGS & OBLIGATIONS 700.00 7CO.00 590.50 0.00 109.50 84.36 001-100-549.350 VOLUNTEER APPRECIATION 1,400.00 1,400.00 89.16 0.70 1,310.84 6.37 001-100-554.300 BOOKS, PUBL, SUBS & MEMBERSHI 3,100.00 3,7CO.00 3,179.95 0.30 520.06 85.94 Operating Expenditures/Expense 62,050.00 63,080.00 25,995.87 0.70 37,084.13 41.21 Capital Outiav 001-100-664.601 Computer Equipment 6,000.00 4,970.00 2,326.99 0.10 2,643.0_ 46.82 Capita] O.;tiay 6,600.00 4,970.00 2,326.99 0.ir. ',(>4?.0 46.82 Net - Dept 100 - Council (68,050.00) (68,050.00) (28,322.86) 0.70 (35,727,14) Dept 110 - Manager Operating Expenditures;Expense 001-110-540.300 Travel & Per Diem 5,000.00 5,000.00 1,649.33 0.70 3,350.67 32.99 001-110-546.320 Computer system maint & suppl 800.00 SCO.00 33.00 0.30 767.00 4.13 001-110-549.300 Other Mi.^,c Chgs & Obligations '50.00 750.00 20.00 0.30 730.00 2.667 001-110-554.300 Books, Publ, Subs & riembershi 2,700.00 2,700.00 1,886.68 0.30 813.32 69.88 001-110-554.301 Personnel Training 2,500.00 2,5CO.00 768.00 0.30 1,732.00 30.72 Operating Expenditures%Expense 11,150.00 11,750.00 4,357.01 0.30 7,392.99 37.08 Personal Services 001-110-512.100 Regular Salaries & Wages 201,800.00 201,8C0.00 91,466.14 0.30 1.0,333.Sb 45.33 001-110-515.103 Bonus Pay Plan 1,250.00 1,250.00 1,250.00 0.70 0.00 i00.0C 001-110-515.107 Part-time Salaries 2,500.00 2,5CO.00 72.12 0.7c 2,427.68 2.68 001-110-515.108 Auto Allowance 3,600.00 31600.00 1,799.91 0.711 1,800.09 50.11C 001-110-516.100 Compensated Absences 2,500.00 2,SCO.10 1,419.82 0.30 1,080.18 56.79 04/03/2020 11:25 AN, REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 3/27 User: tracanati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTP BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED BDG GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED Fund 001 - GENERAL FUND 001-110-521.101 FICA Taxes 11,200.00 11,2CO.00 5,756.20 0.00 5,44;.80 51.39 001-110.5_'1.102 Medicare Taxes 3,050.00 3,050.00 1,346.17 0.00 1,703.63 44.14 001-110-522.102 `.'OT PENSION CJN"_'RIBUTIONS GEN 21,950.00 21,950.00 9,935.58 0.50 12,014.42 45.26 001-110-523.101 Life/'Healtt IASL*rance 26,100.00 26,1CO.00 12,996.69 0.:0 _3,103.3- 49.80 001-110-524.100 'Workers' Comp Insu!--ance 400.00 400.00 273.75 91.25 35.00 91.25 Personal Services 274,350.00 274,350.00 126,316.38 91.25 lA',942.27, 46.06 Net - Dept 110 - Manager (286,100.00) (286,1CO.00) (130,673.39) (91.25) (155,335.36) Dept 111 - Human Resources Operating Expenditures/Expense 001-111-526.101 Employee Recognition Program 14,000.00 14,0,-0.00 7,234.10 0.00 6,765.90 51.67 001-111-526.102 Employee Assistance Program 11,050.00 ii,050.00 5,090.90 0.00 5,959.10 46.0'7 001-111-526.103 Education Reimbursement Prqm 2,000.00 2,CCD.OG 0.00 0.50 2,000.00 0.00 001-111-534.300 Other Contractual Ser✓ices 81000.00 8,000.00 452.60 ().DO 7,54%.40 5.66 001-111-540.300 Travel & Per Diem 5,000.00 5,000.00 1,873.12 0.D0 3,12(.88 37.46 001-111-541.300 Communication Sera+ces 1,200.00 1,2CO.00 460.37 0.50 '39.63 36.36 001-111-546.320 Computer system maint & suppl 16,800.00 i618C0.00 10,587.33 0.50 6,212.67 63.02 001-111-547.300 Printing & Binding 1,500.00 i,5G0.00 0.00 0.50 1,500.00 0.00 001-111-549.300 Other Mise Chgs & Obligations 600.00 600.00 131.82 0.00 468.16 21.97 001-111-549.401 Recruitment expenses 500.00 5C0.00 115.00 0.DO 325.00 35.00 001-111-534.300 Books, Publ, Subs & Membershi 11500.00 i,500.00 806.00 0.50 694.00 53.73 001-111-554.301 Personnel 'Traininq 5,000.00 5,000.00 2,563.00 C.CO 2,437.00 51.26 001-111-554.310 Employee Development 10,000.00 10,000.00 1,131.54 0.50 8,868.46 11.32 Operating Expenditures/Expense 77,150.00 77,150.00 30,505.78 0.50 46,644.22 39.54 Personal Services 001-111-512.100 Regular Ss_aries & Wages 231,600.00 231,600.00 101,432.78 0.00 130,167.22 43.80 001-111-514.100 Overtime 0.00 0.00 70.57, 0.50 (70.97) 100.00 001-111-515.103 Bonus Pay Pian 1,900.00 1,9C0.00 1,950.00 0.50 (50.00) 102..63 001-111-516.100 Compensated Absences 3,000.00 3,000.00 2,701.70 0.10 296.30 90.06 001-111-521.101 FICA Taxes 13,550.00 13,590.00 5,364.39 C.D0 8,185.6_ 39.59 001-111-521.102 Medicare Taxes 3,450.00 3,450.00 1,478.02 0.50 1,971.98 42.84 00i-111-522.102 VOT PENSION CONTRBUTIONS GEN 25,050.00 25,050.00 11,018.25 0.70 -4,031.75 43.99 Ohl-111-5%3.101 I fp/'Heal t.h Insurance 28,200.00 28,200.00 15,207.88 ().Gn ^,992.)1 53.93 001-111-523.105 HSA - Health Savinas Account 2,400.00 2,400.00 1,171.99 0.50 1,228.0- 48.83 001-ili-524.100 Workers' Comp Insurance 450.00 450.00 300.00 100.J0 50.00 88.89 Personal Services 309,600.00 309,600.00 140,695.98 100.50 168,804.02 45.48 Net - Dept 111 - iuman Resources (386,750.00) (386,750.DC) (!71,201.76) (100.J0) (25,448.24) Dept 120 - Village Clerk Operating Expenditures/Expense 001-120-531.303 Codification Services 6,500.00 ,5c0.00 3,949.58 0.D0 2,550.42 60.76 001-120-534.301 Election Expense i8,950.00 18,950.00 20.40 0.50 -8,929.60 0.11 001-120-534.302 Legal Advertising 12,D00.00 12,000.00 4,016.96 O.DO 7,983.04 33.47 001-120-540.300 Travel & Per Diem 3,500.CO 3,5CG.00 3,130.40 0.D0 369.60 89.44 001-120-541.300 Communication Services 1,400.00 1,4CO.00 473.06 0.D0 926.94 33.79 001-120-546.320 Computer system maint & suppi 16,'00.00 16,700.00 11,924.32 0.D0 4,775.68 71.40 001-120-548.110 Marketing and Public Relation 10,000.00 10,000.60 1,569.43 0.70 8,430.57, 15.69 001-120-549.100 Miscellaneous Archival 2,500.--0 2,5CO.CC 96.09 0.D0 2,403.9- 3.84 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 4/27 User: tracanati DB: Teouesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED s BDG" GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED Fund 001 - GENERAL FUND 001-120-549.300 Other Misc Chas & Obligations 2,500.00 2,5CO.00 1,941.95 0.30 558.05 77.68 001 120-552.302 Small Tools and Equipment 500.00 5C0.00 0.00 0.70 500.00 0.00 001-120-554.300 Books, Publ, Subs & Membershi 1,200.00 1,2CO.00 717.95 0.30 482.05 59.83 001-120-554.30.1 Personnel Training 2,050.00 2,050.00 1,629.00 (7.30 421.00 79.46 Operating Expenditures/Expense 771800.00 77,8CO.CC 29,469.14 0.7G 48,330.86 37.86 Personal Services 001-120-512.100 Regular Salaries & Wages 203,650.00 203,650.00 92,083.76 0.70 1-1,566.24 45.22 001-120-515.103 Bonus Pay Plan 1,750.00 1,750.00 1,750.00 0.70 0.00 100.00 001-120-515.108 Auto Allowance 3,000.00 3,000.00 1,483.78 0.70 1,516.22 49.46 001-120-521.101 FICA Taxes 12,550.00 12,550.00 5,476.86 0.70 7,073.14 43.64 001-120-521.102 Medicare Taxes 2,950.00 2,950.00 1,280.88 0.30 1,669.12 43.42 001-120-522.102 VOT PENSION CONTRIBUTIONS GEN 22,150.00 22,150.00 10,002.74 0.90 -2,147.26 45.16 001-120-523.101 Life/Health Insurance 45,900.00 45,9CO.00 22,944.63 0.70 22,955.37 49.99 001-120-524.100 Workers' Comp Insurance 400.00 4CO.00 262.50 87.50 50.00 67.50 Personal Services 292,350.00 292,350.00 135,255.15 87.50 156,977.35 46.30 Net - Dept 120 - Village Clerk (370,150.00) (370,150.00) (164,75,1.29) (87.50) (205,308.2_) Dept 130 - Finance Operating Expenditures/Expense 001-130-532.300 Accounting & Auditing Service 28,3300.00 2-8,3C0.00 24,485.49 3,003.01 611.50 97.13 001-i30-540.300 Travel & Per Diem 3,900.00 3,9CO.O0 309.08 0.70 3,590.92 7.93 001-130-544.301 Operating Leases 2,550.00 2,550.00 1,255.33 0.70 1,294.67 49.23 0011-130-54C.320 Computer system maint & suppl 12,600.00 12,6CO.00 9,529.99 0.90 3,070.0: 75.63 001-130-547.300 Printing & Bindinq 2,80C.00 2,8CO.00 828.34 0.00 1,971.66 29.56 001-130-549.300 Other Misc Chgs & Obligations 711000.00 5C1.00 66.00 0.70 435.00 13.11 001-130-C51.s00 Office Supplies & Equipment 2,SOC.CO 1,9C0.00 333.81 0.70 1,56E.19 17.57 001-130-554.300 Books, Pub!, Subs & Membershi ,600.00 1,EC0.00 863.21 0.70 706.79 55.63 001-130-554.301 Personnel Training 3,50O.00 3,4CC.00 1,994.00 0.70 1,406.00 58.65 Operating Expenditures/Expense 59,050.CC 17,5_51.00 39,695.25 3,003.31 _4,852.74 74.:9 Capita-. O-�Llay Oil:-=30-664.601 Computer Equipment 0.00 1,773.00 1,669.43 0.30 103.57 94.16 Capital Otlay 0.CO 1,'73.00 1,669.43 0.30 103.57 84.16 Personal Services 001-130-512.100 Regular Salaries & Wages 264,400.06 264,41,0.00 119,339.23 0.70 145,060.77 45.14 031-130-515.103 Bonus Pay Plan 2,150.00 i,&76.00 1,875.01 0.70 0.99 99.95 001-130-516.100 Compensated Absences 2,500.00 2,500.00 0.00 0.70 2,500.00 0.00 001-130-52i.10i FICA Taxes 16,350.00 16,350.00 7,079.69 0.70 9,270.3_ 43.30 001-130-521.102 Medicare Taxes 3,850.00 _85C.OG 1,655.8' 0.70 2,194.13 43.01 001-130-522.102 VOT PENSION CONTRIBUTIONS GEN 28,750.00 28,750.00 12,963.3% 0.00 5,78£.63 45.09 001-130-523.101 7ife/Health Insurance 47,850.00 47,850.00 24,622."74 0.30 23,227.26 51.46 001-130-524.100 Workers' Comp Insurance ^00.00 500.00 337.50 12.50 50.00 90.00 Personal Services 366,350.00 366,076.00 167,873.41 112.50 198,090.09 45.89 Net - Dept 130 - Finance (425,400.00) (425,4C0.CC) (209,238.09) (3,115.31) (2-3,046.40) 04/03/2020 11:25 AN REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 5/27 User: tracanati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED 5 BDG- GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED Fund 001 - GENERAL FUND Dept 140 - Legal OperaLing Expenriitures'Expense 091-140- 31.301 Legal Services 100,000.00 :OO,OCO.00 30,4.78.30 0.90 69,521.70 30.48 00i-140-531.308 Legal fees - Personnel 80,000.00 80,OCO.00 8,295.17 0.90 71,704.83 10.37 Operating Expendit.:res/Expense 180,000.00 :80,OC'O.O0 38,773.47 0.D0 141,226.53 21.54 Net - Dept 140 - Legal (:80,000.00) (_801000.00) (338,773.47) 0.30 (141,226.53) Dept 150 - Comprehensive Planning Chgs for Sery - Gen Gov 001-150-341.150 Land Development Fees 145,000.00 _45,CCC.00 91,555.71 0.90 53,444.29 63.14 Chgs for Sery - Gen Gov 145,000.00 :45,OCC.Oc 91,555.71 0.90 53,444.29 63.14 Operating Expenditures/Expense 001-150-531.301 Legal Services 141000.00 141OCC.00 7,831.25 0.90 6,168.75 55.94 001-150-531.321 Mapping Services 1,500.00 1,500.00 0.00 0.90 1,500.00 0.00 001-150-531.322 N,isc Planning Service 129,000.00 _29,DCO.00 47,672..00 81,328.90 0.00 130.00 001-150-534.300 Other Contractual Services 10,600.00 10,000.00 5,427.52 0.90 4,572 48 54.26 001-150-534.302 Legal Adverli6ing 5,000.00 5,000.00 1,702.80 0.30 3,297.20 34.06 001-150-546.320 Computer system maint & suppi 1,400.00 1,400.00 565.00 0.90 835.00 40.36 001-150-547.300 Printing & Binding i,O00.00 1,0-'0.00 0.00 0.30 1,000.00 0.00 001-150-549.300 Other Misc Chgs & Obligations 1,000.00 1,OCO.00 555.13 0.90 444.87 55.51 001-150-554.300 Books, Publ, Subs & Membershi 900.00 9CO.00 1.1000.00 0.90 1100.00) 1;1.11 Operating Expenditures/Expense 163,800.00 :63,820.00 64,'.53.70 81,326.30 _7,718.30 89.18 Net - Dept 150 - Comprehensive Planning (181800.00) (18,8CO.00) -6,802.01 (81,328.9,-) 35,725.99 Dept 160 - General Government Operating Expenditures/Expense 001-160-531.302 Engineering Services 2,500.00 2,5CC.00 0.00 0.90 2,500.00 0.00 001-160-534.300 Other Contractual ServicesL9,000.00 29,010.00 8,338.95 12,000.)0 8,661.05 70.13 001-160-534.301 Special Events 5,000.00 S,00O3.CO 693.00 0.90 4,307.00 13.86 001-160-541.300 Communication Services 7,00C.00 7,DCO.CC 4,811.6 0.30 2,188.33 68.74 001-160-541.301 Postage 3,000.00 3,CCO.00 897.06 0.00 2,102.94 29.90 001-160-541.305 Website Maintenance 7,800.CC 71BCO.00 7,260.807 C.-IO 539.20 93.09 001-160-543.300 1 Utility Services 19,500.00 19,5CO.O0 6,749.40 0.30 :2,750.60 34.61 001-160-544.301 Operating Leases 48,100.00 48,1CC.00 27,595.84 17,840.00 2,664.16 94.46 001-160-545.300 insurance ?4,400.00 74,4CO.00 4'7,601.25 15,388.25 :1,410.50 84.66 0O1-160-546.301 Office Equip/Repair & Maint 3,400.00 3,4CO.00 1,723.04 0.90 1,676.96 50.68 001-160-546.320 Computer system maint & suppi 36,600.00 37,780.00 23,727.39 0.90 :4,052.6: 62.80 001-160-547.300 Printing & Binding 2,000.00 2,OCO.CC 994.38 0.00 1,005.62 49.72 001-160-549.300 Other N,isc Chgs & Obligations 10,000.00 10,OCO.00 1,484.94 0.30 8,515.06 14.85 O8-_-160-5.-9.302 Village Newsletter 15,000.00 i5,01C.00 7,544.85 0.30 7,455.15 50.30 0:;:- ::9.304 Licenses, Fees & Pcrmits 2,400.00 - 400.00 2,396.07 0.30 3.93 99.84 Ocl _ -':.300 Office Supplies & Equipment 6,500.00 6,5CO.00 3,197.72 0.30 3,302.28 49.20 001-166-554.300 Books, Publ, Subs & Membershi 3,500.00 3,5CO.00 2,3.73.86 0.90 1,126.14 67.82 Operating ExpendituresiExpense 275,700.00 276,880.C'0 147,396.22 45,228.25 64,261.53 69.57 Capital Outlay 001-160-664.601 Computer Equipment 23,500.00 29,120.00 0.00 0.;C 29,120.00 0.00 04/0311*2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 6/27 riser: tracanati JB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2019-20 03/31/2020 ENCUMBERED UNENCUMBERED BDG[ =L NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED F'„ed 001 - GENERAL FUND Capital Outlay 23,500.00 29,120.00 0.00 0.30 29,120.00 0.00 Net - Dept 160 - General Governmect (299,200.00) (30G,O00.00) (147,390.22) (45,228.25) (1_3,381.533) IT pend_turesiF-,-5e -.-- -i-526.103 Education Reimbursement Prgm E,000.00 5,453.00 3,000.00 0.00 2,453.00 55.02 - - i-540.300 'Travel & Per Diem 31000.00 3,0'0.00 0.00 O.DG 3,000.00 0.00 --.- =--5=9.300 Other Misc Cogs & Obligations 0.00 547.00 546.60 0.30 0.40 99.9.3 _-552.160 IT Operating Supplies 2,000.00 2,000.00 1,470.13 0.00 529.87 73.51 _.._.--c_-554.301 Personnel Training 8,000.00 8,OCO.CO 2,235.00 O.DO 5,765.00 7.94 ..-.e.--nq ExpendituresiExpense 19,000.00 19,000.00 7,251.73 0.30 -1,748.27 38.17 _..r:.. G_rvices R P._ Salaries & Wages 145,500.00 _45,5'0.00 6.1,756.17 0.30 83,743.83 42.44 103 F 1,400.00 1,40.0C 1,400.01 0.00 (G.G-) 100.00 - - 5.120 owance 1,000.00 1,0CC.00 474.74 O.DO 525.26 37.47 r,_sences 0.00 0.00 3,420.03 0.00 (3,420.03) 100.00 ..---1.101 5,950.00 8,950.00 3,937.30 0.00 5,012.70 43.99 .102 1-,�xre ,100.00 2,1[0.00 920.79 0.70 1,179.2_ 43.85 C" ---"-E _.1ST VGT PENSi.n. :;.)NTRIBUTIONS GEN 15,600.00 :5,800.00 6,708.61 O.Do 9,091.35 42.46 CO---..•_--___.1CG Life/3eait:. insurance 25,350.00 25,350.00 12,047.22 C.30 -3,302.78 47.52 ''.1orkers' Comp Insurance 300.00 3C0.00 187,50 62.5C 50.00 83.33 Pe-->.._._ ,,__.__-.: 200,400.00 200,4Co.00 90,852.37 02.50 109,485.13 45.37 -.=- --� -_- -- (219,400.00) (219,4CO.00) (98,104.10) (62.50) (12i,233.40) "cher Miscellaneous Revenue 37,300.00 37,3CO.00 344.26 0.70 36,95t.7= 0.92 37,300.00 37,3[0.00 344.26 0.00 36,955.,4 0.92 .±IT I4ATCING SAFETY GRANT 0.00 0.00 125.00 0.00 (125.00) iDO.CC 0.00 0.00 125.00 O.DG (12`.00) 100.00 bl c Saf-y. Marine law enforce. ser 16,600.00 16,6Co.00 16,660.00 0.D' (60.00) 1D0.3t` .. -:b1 C Safety i6,600.00 16,6c0.0[ 16,tiE0.00 0.30 (60.00) 1D0.36 ..nes 5,500.00 5,5CO.00 2,211.82 O.DO 3,288.15 40.21 _ ._.%;. .... affic violation fund 0.CC) 0.00 2,496.10 0.00 (2,496.10) iDC.00 _-DINANCE VIOLATION 500.00 5'0.00 5510.00 0.10 (50.00) 110.00 61000.00 6,000.00 5,257.92 O.DO 742.08 87.63 ___c, Impact Fees 500.00 5[0.00 1,522.94 0.00 (i,022.94) 304.59 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 7/27 User: tracanati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED s BDGT GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED Fund 001 - GENERAL FUND Impact Fees 500.00 5CO.00 1,522.94 0.00 (1,022.94) 304.59 Net - Dept 171 - Pciice 60,400.00 60,4CC.00 23,910.12 0.30 36,489.88 Dept 1'.5 - Police Department Ope,-ating ExpendituresiExpense C'--- ---526.101 Employee Recognition Program 3,000.00 3,OCO.00 0.00 0.30 3,000.00 0.00 Oi;:--75-526.103 Education Reimbursement Prgm 61000.00 61000.00 1,700.00 0.00 4,300.00 28.33 Di. -.`5-526.105 Employee Physical/Psycologica 4,250.00 4,250.00 979.50 0.00 3,270.50 23.05 0-.- -=5-540.300 Travel & Per Diem 14,000.00 14,OCO.00 3,937.95 0.30 :0,062.05 28.13 0;" :--->41.300 Communication Services 24,500.00 24,5CO.00 9,798.17 0.30 -4,701.83 39.99 0'.-- - =.301 Postage 1,000.00 i3OCO.00 214.21 0.D0 785.79 21.42 0., ;.300 Utility Services 35,000.00 35,000.00 12,575.52 0.00 22,424.48 35.93 -;.301 Operating leases 2,750.001 2,150.00 1,066.38 0.00 1,083.62 49.60 001-177-5-5.300 Insurance 60,950.00 60,950.00 46,130.00 15,090.50 (270.50) 130.44 001-175-oa.175 K-9 Equipment & Maintenance 6,000.00 6,OCO.00 313.98 0.30 5,62t.02 6.23 001-175-546.301 Office Equip/Repair & Maint 1,200.00 1,200.00 384.24 0.30 815.76 32.02 001-175-546.302 Vehicle Repair & Maintenance 38,000.00 38,000.00 16,574.76 0.30 21,425.24 43.62 001-175-546.303 Building Repair & Maint 30,000.00 30,OCO.00 14,043.90 8,003.30 7,953.10 73.49 001-175-546.304 Communication Equip Maint 39,000.00 39,OCO.00 27,843.20 7,098.30 4,058.80 89.59 001-175-546.310 Equipment Repair & Maint 3,000.00 3,000.00 1,552.50 0.30 1,447.50 51.75 001-175-546.320 Computer system maint & suppl 104,600.00 -61,6CO.00 60,256.56 56,680.00 44,663.44 72.36 001-175-547.300 Printing & Binding 1,500.00 1,500.00 196.61 0.30 1,303.39 13.11 001-175-549.300 Other Misc Chgs & Obligations 101000.00 9,294.00 1,503.05 0.30 7,790.95 16.17 001-175-549.303 investigative Expenses 2,000.0C 2,000.00 494.25 0.30 1,505.75 24.71 001-175-549.304 Licenses, Fees & Permits 1,750.00 2,456.00 1,936.06 0.30 519.94 78.83 001-175-549.311 Marine Unit Operations 25,600.00 25,600.00 10,071.45 0.30 -5,528.55 39.34 001-175-549.314 K.E.Y.S. Program 15,600.00 15,600.00 6,538.15 0.30 9,061.85 41.91 001-175-551.300 Office Supplies & EquipRent 4,500.00 4,500.00 1,725.44 0.30 2,774.56 38.34 001-175-551.301 Crime Prevention Supplies 4,000.00 4,000.00 0.00 0.30 4,000.00 0.00 001-175-532.301 Gas & Cil 30,000.00 30,000.00 16,165.35 0.30 -3,834.65 53.88 001-175-532.302 Small Tools and Equipment 6,380.00 8,380.00 1,312.36 0.00 7,067.64 15.66 001-175-552.305 Uniforms 21,000.00 21,000.00 14,794.22 0.30 6,205.78 70.45 001-i75-552.3--0-9.3001 DISASTER RELIEF - COVID-19 0.00 0.00 700.00 0.00 (700.00) 100.00 00i-175-5 54.300 Books, Publ, Subs & Membershi 2,700.00 2,7CO.00 1,918.00 0.00 782.00 71.04 091-175-554.3Cl Personnel Training _9,000.00 19,000.00 7,359.00 0.30 -1,641.00 38.73 Operating Expenditures/Expense 518,680.00 5-5,680.00 262,144.81 86,871.30 226,663.69 60.63 Capital Oitlay OCi-175-664.600 Mach/>auipment ',750.00 1,750.00 3,194.50 0.30 (1,444.50) 182.54 001-175-664.601 Computer Equipment 34,600.00 34,600.00 0.00 0.70 34,600.00 0.00 001-175-664.602 Vehicles 90,000.00 -12,194.00 3,600.00 0.)O 108,594.00 3.21 Capital G-,clay 126,350.00 -48,544.00 6,794.50 0.30 141,749.50 4.57 Personal Services 001-175-512.171 SAL & WAGES - ADMINSTRATION 260,400.00 260,4CO.00 118,415.91 O.DO 141,984.09 45.47 001-175-512.172 Reg Sal & Wages - Communicati 214,000.00 214,OCO.00 95,740.87 0.70 1-8,259.13 44.74 001-175-512.175 Reg Sal & Wages - Operations 1,311,450.00 1,311,450.00 5"10,217.15 0.30 741,232.85 43.48 001-175-514.172 Overtime - Communications 15,500.00 15,500.00 9,016.77 0.30 6,483.23 58.17 001-175-514.175 Overtime - Operations 92,!00.00 2,100.00 38,152.33 O.DC 53,947.67 41.42 001-175-514.350 Overtime - Disaster 0.00 0.00 2,190.72 0.30 (2,190.72) 100.00 001-175-515.101 Holiday Pay 54,600.00 54,6CO.00 41,833.66 0.70 -2,766.34 76.62 001-175-515.103 Bonus Fay Plan 9,750.00 9,750.00 7,750.00 0.30 2,000.00 79..49 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 8/27 User: tracanatl DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAI. 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED < BDG7 GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) Y°AR-TO-DATE BALANCE USED Fund 001 - GENERAL FUND 001-1751-515.106 Clothing & Boot Allowance 1-4,750.00 14,750.00 9,625.00 0.30 5,125.00 65.25 001 -75.5 5.10' Part-time Salaries 15,000.00 15,OCO.00 6,385.15 0.30 8,614.85 42.57 O11-175-515.108 Auto Allowance 61000.00 6,OCO.00 2,967.70 0.30 3,032.30 49.46 001-".75-515.120 Cell phone allowance 1,200.00 1,2CO.00 593.48 0.3c 606.52 49.46 001-175-515.125 Other Allowances 6,000.00 6,000.00 2,567.71 0.3c 3,032.29 49.46 001-175-515.172 P/T Salary - Communications 25,750.00 25,750.00 9,391.40 C.DO _6,358.60 ^.47 001-175-516.100 Compensated Absences 33,000.00 33,OG0.00 ?,202.49 0.30 25,797.5= ":.63 001-175-521.101 FICA Tares 123,700.00 :23,700.00 53,536.57, 0.00 70,163.43 -..28 001-175-521.102 Medicare Taxes 29,100.00 29,1C0.00 1.2,622.85 0.00 :6,477,16 001-175-522.101 FRS Contributions 36,100.00 36,1C0.00 16,138.85 0.30 :9,961.15 001-175-522.102 VOT PENS11td c:cIN,-RIBUTIONS GEN 29,600.00 29,6CO.00 14,895.59 0.70 :4,704.4: 001-175-522.105 Defined .-ion 26,100.00 26,1-,0.00 11,814.32 0.00 :4,285.68 001-175-523.101 Life/Heal-_r "..._..ance 379,100.00 379,100.00 186,318.88 0.00 192,781.12 49./ 001-175-524.1CO Workers' Comp Insurance 66,000.00 66,OCO.00 45,367.50 15,122.30 5,510.00 9i.65 Personal Services 2,749,200.00 2,749,200.00 1,263,144.89 15,122.50 1,470,932.6: 46.50 Net - Dept 175 - Police Department (3,394,230.00) (3,473,424.00) (1,532,084.20) (101,994.30) (1,839,345.80) Dept 180 - Building & Zoning Licenses & PermiLS 001-180-322.000 Building Permit Fees 729,100.00 729,1CO.00 206,703.11 0.)0 522,396.89 28.35 001-180-329.110 PARTIAL AND R?-INSPECTICN 8,000.00 8,OCO.D0 1,792.74 0.70 6,207.26 22.41 Licenses & Permits 1100.00 737,1CO.00 208,495.85 0.30 528,604.15 28.29 Operating Expenditures.,Expense 001-180-531.301 Legal Services 4,000.00 4,OCO.00 3,885.00 0.70 ii5.00 97.13 001-180-531.325 Inspection Services 25,000.10 25,OCO.00 11,729.00 13,153.10 118.00 99.53 001-180-534.300 Other: COIILraCLual Services 2,000.00 21,556.00 21,456.00 0.70 100.00 99.54 001-180-540.300 Travel & Per Diem 3,O00.CO 31000.00 1,331.19 O.DO 1,668.8: 44.37, 001-180-541.300 Communication Services 5,500.CC 5,5CO.00 1,995.64 0.)0 3,504.36 36.28 001-180-541.301 Postage 1,600.00 i,6C0.00 14.45 0.30 1,585.55 0.90 001-180-543.300 Utility Services 7,600.00 ,600.00 2,460.54 0.70 5,139.46 32.38 001-180-544.302 Operating Leases 2,300.00 2,3CO.00 957.25 0.30 1,3x2.'5 41.62 001-160-545.300 Insurance 600.00 6GO.00 278.00 139.00 182.00 69.50 001-180-546.301 Office Equip/Repair & Maint 1,150.00 -1,150.00 871.18 0.90 278.8; 75.75 001-180-546.302 Vehicle Repair & Maintenance 500.00 1,000.00 317.99 C.00 682.0- 31.80 001-180-546.320 Computer system maint & suppi 400.00 13,4CO.00 7,799.01 5,588.30 12.99 99.90 Oct-180-547.300 Printing & Binding 1,060.00 1,000.00 73.58 0.70 926.42 7.36 001-180-549.300 Other Misc Chgs & Obligations 2,300.00 1,200.00 769.64 0.10 430.36 64.14 001-180-549.301 Admin Mgmt Fees 104,100.00 :04,100.00 52,050.00 0.70 52,050.00 50.00 001-180-549.304 licenses, Fees & Permits 3,000.00 3,OCO.00 961.58 0.10 2,038.42 32.05 OC1-180-551.300 0 f five Supplies & Equipment 3,000.00 3,OCO.00 2,816.51 G.00 183.49 93.88 001-180-552.301 Gas & Oil 150,00 750.00 90.94 0.10 659.06 12.13 001-180-552.305 Uniforms 11500.00 1,5C0.00 244.85 0.00 1,255.15 16.32 001-180-554.300 Books, Publ, subs & M,embershi 1,400.00 3,200.00 2,248.39 0.30 951.6: 70.26 001-180-554.301 Personnel Training 7,500.00 7,5CO.00 3,527.00 0.30 3,973,00 47.03 Operating Expenditures/Expense 191,200.00 211,9`_6.00 115,877.74 18,880.00 17,198.26 63.58 Capital Outlay 001-180-653.600 Building Improvements 10,000.00 _,185.00 0.00 0.30 2,185.00 0.00 001-180-664.600 Mach/Equipment 0.00 111C0.00 11099.98 0.30 0.02 100.00 001-180-664.601 Computer Equipment 20,000.00 22,OCC.00 13,725.00 0.10 8,275.00 62.39 Capital Outlay 30,OOO.0O 29,285.00 14,824.98 0.00 :0,460.02 58.63 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 9/27 User: tracanati DB: Teo-oesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORT-GINAL 2C'-9-20 03/31/2020 ENCUMBERED UNENCUMBERED ? BDGC GL NUMBER DESCRIPTION BUDGET AMENDED BUCGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED Fund 001 - GENERAL FUND Personal Services 001-160-5-.--1 Regular Salaries & Wages 329,000.00 329,OCO.00 150,159.89 0.00 176,840.1_ 45.64 001-16G-5 I'i0 Overtime 0.00 0.00 364.02 0.00 (364.02) 130.00 001-180-5:-.i:`. Bonus Pay Plan 2,600.00 2,8CO.00 1,300.00 0.30 1,500.00 46.43 001-180-57 .i. Auto Allowance 3,000.00 3,CCO.CO 1,483.79 0.)0 1,516.2- 49.46 001-180-5 1l' 7mnr-as.-.ed Absences 1,200.CC 1,2CO.CO 0.00 0.30 1,200.00 0.00 001-180-521.101 20,550.00 20,550.00 9,188.75 0.30 -1,361.25 44.71 001-180-521.102 nTaxes 4,800.00 4,8CO.00 2,148.9'] 0.90 2,651.03 44.77 001-180-522.102 F -:)NTRIBUTIONS GEN 35,750.00 35,750.00 :6,311.24 0.90 "9,438.76 45.63 001-180-523.101 .surance 51,600.00 51,6CO.00 27,474.74' 0.90 24,125.26 53.25 001-180-524.100 .. ns- r: e 3,850.00 3,850.00 2,587.50 662.50 400.00 89.61 Personas services 452,550.00 452,5`0.00 211,018.90 862.50 240,668.60 46.82 Other Financing Sources L Uses 001-i80-549.395 Credit Card Fees and Charges ',000.00 7,OCO.00 3,931.20 0.90 3,068.80 56.16 Other Financing Sources & Uses 7,000.00 7,000.00 3,931.20 0.90 3,068.80 56."6 Net - Dept 160 - 3uildino & Zoning 56,350.00 40,3C9.00 (137,156.97) (19,742.50) 197,208.47 Dept 181 - Code Compliance Operating Expenditures!Expense 001-181-531.301 Legal Services 10,500.00 10,500.00 1,403.75 0.90 3,096.25 70.51 001-181-531.320 Code Enforcement Service 5,000.00 41000.00 0.00 0.90 4,000.00 0.00 001-181-540.300 Travel & Per Diem 1,500.00 1,500.00 1,282.00 0.90 218.00 85.47 001-181-541.300 Communication Services 1,000.00 1,000.00 243.95 0.00 756.05 24.40 001-181-541.301 Postage 500.00 5CO.00 491.15 0.)0 6.85 98.23 001-181-546.302 Vehicle Repair & Maintenance 500.00 1,500.00 831.98 0.90 668.02 55.47 001-181-552.301 Gas & Oii %50.00 7°0.00 155.80 0.30 594.20 20.77 001-181-554.300 Books, Publ, Subs & Membershi 300.00 300.00 150.00 0.00 150.00 50.00 001-181-554.301 Personnel Training 1,500.00 1,5CO.00 605.00 0.70 895.00 40.33 Operating Expenditures;Expense 21,550.00 21,550.00 11,163.63 0.90 -0,386.37 51.80 Persona! Services 001-181-512.100 Regular Salaries & Wages 46,;00.00 46,700.00 21,636.01 0.70 25,063.99 46.33 001-iel-5i5.106 Clothing & Boot Ai-owance _50.00 250.00 125.00 0.90 25.00 83.33 091-181-515.107 Parc-Lime Salaries 51850.00 5,850.00 2,386.81 0.70 3,463.19 40.80 001-161-521.101 FICA Taxes 3,300.00 3,300.00 1,475.11 0.70 1,820.89 44.82 091-181-521.102 Medicare Taxes 600.00 800.00 345.92 0.70 454.08 43.24 001-181-522.102 VOT PENSION CONTRIBUTIONS GEN 5,100.00 ,lGO.O0 2,350.20 0.30 2,749.80 46.08 001-181-523.101 Life/Health Tnsurar.ce 9,000.00 9,000.00 4,481.422 0.90 4,518.58 49.79 001-181-524.100 Workers' Comp Insurance 1,300.00 1,300.00 885.00 295.70 120.00 90.77 Personal Services 72,200.00 72,200.00 33,689.47 295.30 38,215.53 47.07 Fines & Forfeitures OCl-lS1-354.10002 Code Enf Fines & Court Costs 10,000.00 l0,OCO.00 2,936.58 0.70 7,063.42 29.37 Fines & Forfeitures 10,000.00 lO1OCO.00 2.,936.58 0.70 7,063.42 29.3'7 Net - Dept 181 - Code Compliance (83,750.00) (63,750.00) (41,916.52) (295.)0) (41,538.48) 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 10/2 User: tracar.ati DB: Tequesza PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2,19-20 03/31/2020 ENCUMBERED UNENCUMBERED - B➢G^_ GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED Fund 001 - GENERAL FUN➢ Dept 192 - Fire Control Intergovernmental Revenue 001-192-335.201 Fire Incentive Pay 61700.00 6,7,-0.00 1,64.7.74 O.JO 5,052.26 24.59 Intergovernmental Revenue 6,700.00 6,7CO.00 7,647.74 0.30 5,052.26 24.59 Miscellaneous Revenues 001-192-3'55.102 Fire Dept Sales 150.00 '`0.00 137.99 0.00 12.0: 91.99 001-192-369.000 Other Miscellaneous Revenue 1,500.00 ,5CO.c0 59.33 0.70 1,440.67 3.96 Miscellaneous Revenues 1,650.00 1,E50.00 197.32 0.30 1,452.68 11.96 Operating Expenditures/Expense 001-192-526.101 Employee Recognition Program 3,5,-0.00 315CC.00 0.00 0.00 3,500.00 0.00 001-192-526.103 EDUCATION REIMB PRGRM 9,000.00 9,000.00 '7,338.19 0.30 1,661.8_ 81.54 001-192-526.105 Employee Physical/Psycologica 12,800.00 12,8,-0.00 6,987.85 2,404.35 3,408.10 73.37 001-192-540.300 Travel & Per Diem ',950.00 7,950.00 3,879.63 O.DO 4,070.37 48.80 001-192-541.300 Communication Services 12,100.00 12,1CO.00 6,407.43 0.30 5,692.57 52.95 0'i-.92-X1.301 Postage 11050.00 1,C50.00 252.75 C.30 797.25 24.07 0- .3.300 Utility Services 34,950.CO 34,950.00 13,632.32 0.30 21,317.68 39.01 Operating Leases 4,950.00 41950.00 2,213.39 0.30 2,736.6: 44.71 .. Insurance 39,300.00 39,3-,0.00 30,648.87 9,052.30 (400.87) 131.02 C4 Vehicle Repair & Maintenance 71,900.00 71,8CO.00 47,743.55 61,951.25 (37,894.80) 152.78 Di.:- -.:- c.303 Building Repair & Dlaint 42,000.00 42,000.00 14,878.84 8,955.30 _8,166.16 56.75 O?.. ,.310 Equipment Repair & Maint 19,150.00 19,?50.00 12,062.43 0.30 7,687.57 61.08 06:-. -.16.320 CompuLer system mainL & suppl 44,300.00 <14,3CC.00 25,148.29 0.00 =9,151.?_ 56.77 0-' 7.300 Printing & Binding 2,050.00 2,050.00 1,522.52 0.30 527.48 74.27 0 ". -69.300 Other Misc Chgs & Obligations 3,500.00 2,8-5.00 2,018.66 0.30 786.34 71.97 0:: 5:.304 Licenses, Fees & Permits 17,500.00 18,i95.00 11,161.33 6,450.20 583.47 96.79 9.397 Bad Debt Expense 551%00.00 55,7CO.00 0.00 0.30 55,700.00 0.00 -551.300 Office Supplies & Equipment 3,900.00 3,90.00 942.92 .3C 2,957.08 _4 C :--.62-551.302 Fire Prevention Education 4,200.00 4,200.00 3,366.91 0.30 833.09 Criy-_92-552.301 Gas & Oil 13,500.00 13,5CO.00 6,271.55 O.DO 7,228.45 001-192-552.302 Small Tools and Equipment 61-00.00 6,1CO.00 1,383.44 0.110 4,716.56 .1.68 CCi--42-5;2.304 Chemicals :,000.00 1,000.00 0.00 D.30 1,000.00 .CD - -. Uniforms 28,000.00 5,7(5.00 10,828.12 0.DD 4,87E.88 i1A.95 OC..-:� Safety Supplies -18,500.00 18,5CO.00 10,300.91 0.30 8,199.09 55.68 Disaster Relief Supplies 4,000.(:0 4,Cc0.CO 2,232.65 0.30 1,'767.35 55.82 001-i92-552.311 CPR PROGRAM S'!PPLIES 1,500.CC• 11510.cc 0.00 0.30 1,500.00 0.00 001-192-552.312 Medical Supplies 50,050.CC 49,042.00 22,11-7.79 0.10 26,924.2_ 45.10 001-192-552.344 Fire Station Supplies 41,000.00 4,000.00 1,324.24 0.30 2,675.76 33.11 001-192-554.300 Books, Publ, Subs & Membershi 4,250.:0 4,250.00 3,846.17 0.10 403.83 90.50 001-192-554.301 Personnel Training 181050.00 18,050.00 11,763.62 0.30 6,28E.38 65.17 Operating Expenditures/Expense 539,250.00 525,947.00 260,274.37 88,812.50 176,860.13 66.37 Capital O�L1ay 001-192-664.600 Mach/Equipment 11,250.00 55,289.00 24,128.52 0.30 31,160.48 43.64 001-192-664.601 Computer Equipment 16,100.00 ,1C0.00 0.00 0.70 _6,100.00 0.00 001-192-664.602 Vehicles 300,000.00 300,000.00 0.00 298,660.28 1,339.72 99.55 Capital O.rtlay 327,,350.00 371,389.00 24,128.52 298,660.28 46,600.20 86.91 Personal Services 001-192-512.100 Regular Salaries & Wages 1,901,450.0,0 1190i,450.00 8.1,447.3E 0.30 1,080,002.64 43.20 001-192-513.101 FIRE INSPECTOR PAY 21,000.00 21,OCO.00 6,156.66 0.00 -2,843.34 38.84 001-192-514.100 Overtime 85,000.00 85,0,-0.00 600,679.56 0.30 24,320.44 71.39 001-192-514.300 Overtime - Training 23,200.00 23,2CC.00 10,504.22 0.30 -2,695.78 45.28 04/03/2020 11:25 AN REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 11/27 User: tracanati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBEREC UNENCUMBERED 5 BDG^ GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED Fund 001 - GENERAL FUND 001-192-515.101 Holiday Pay 60,950.00 60,950.00 42,858.75 0.70 =8,091.25 70.32 001-192-515.103 Donus Fay Plat: 3,750,.0,0 13,750.00 1-1,250.00, 0.30 2,500.00 81.82 001-192-515.107 Part-time Salaries ±5,000.00 15,000.00 9,895.02 0.30 5,104.98 65.97 001-192-515.125 Other Allowances 6,000.00 6,000.00 2,967.70 0.30 3,C--.-,o 49.46 001-192-516.100 Compensated Absences E-,000.00 15,000.00 6,787.13 0.90 45.25 001-192-521.101 FICA Taxes 129,250.00 _29,250.00 57,359.44 0.30 - - 44.36 0C:--_92-521.102 Medicare Taxes 30,250.00 30,250.00 13,498.19 0.70 .. 44.62 O1-:_--. 2-522.102 VOT PENSION CONTRIBUTIONS GEN 450,600.00 450,600.00 115,618.96 0.30v 25.66 0;._-.- 2-522.103 VCT PENSION CONTRIBUTIONS PSO 0.00 0.00 79,264.01 0.70 100.00 O(.: ^2-522.110 Other Pension Contributions 155,000.00 -55,OCO.00 0.00 0.30 I- .. . 0.00 0^:-_92-523.101 Life/9ealth Insurance 387,000.00 387,000.00 191,911.55 0.70 1, 49.59 001-192-523.105 HSA - Health Savings Account 950.00 950.00 527,40 0.30 •�c 55.52 001-192-524.100 Workers' Comp Insurance 102,150.00 _02,150.00 70,466.25 23,488.75 81 O 9i.98 Personal Services 3,396,550.00 3,396,550.00 1,503,192.20 23,488.75 1,869,869.05 44.95 Grants - State 001-192-334.207 FMIT MATCING SAFETY GRANT 0.00 0.00 1,110.00 0.70 (1,110.00) 100.00 Grants - State 0.00 0.00 1,110.00 0.30 (1,110.00) 100.00 Chgs for Sery - Public Safety 001-192-342.192 Fire - Extra Duty 2,500.00 2,5C0.00 1,931.38 0.30 568.62 77.26 001-192-342.201 Fire Plan Review Fees 35,000.00 35,000.00 18,953.31 0.1.0 _6,046.69 54.15 001-192-342.202 Fire Inspections 30,000.00 30,OCO.00 19,650.78 O.DO :0,349.22 65.50 001-192-342.401 Emergency Service-JIC 432,600.00 432,6CO.00 216,320.00 0.00 2_6,280.00 50.00 001-192-342.410 Emergency Svc- PBC Fire Rescu 296,200.00 296,200.00 160,322.43 0.30 135,877.57 54.13 001-192-342.600 EMS Transportation Fees 350,000.00 350,000.00 59,306.86 O.DO 290,693.14 16.94 Chgs for Sery - Pubiic Safety 1,146,300.00 1,_46,300.00 476,484.76 0.00 669,815.24 41.57 impact Fees 001-192-362.222 Fire Impact Fees 500.00 500.00 1,194.02 0.90 (694.02) 238.80 Impact Fees 500.00 510.00 1,194.02 0.30 (694.02) 238.80 Net - Dept 192 - Fire Control (3,108,000.00) (3,_38,726.00) (1,306,961.25) (410,961.53) (1,420,813.22) Dept 210 - Publ_c Works Operating ErpendituresiExper.se 00i-210-551.302 Engineering Services 3,000.00 3,()CO.co 1,0(,8.90 0.70 1,931.10 35.63 OJ--7:()-541.300 Communication Services 8,500.00 61510.00 3,278.75 0.30 5,221.2225 38.57 Ci, -::0-543.300 Utility Services 110,000.CO _10,0-0.00 46,244.25 0.30 63,755.75 42.04 Oc_-:.'.0-543.301 Street Lights 140,000.00 _40,000.00 59,300.82 0.00 80,699.18 42.36 O(:_-.-_0-544.301 Operating Leases 1,5C0.0C 1,500.00 719.84 0.70 780.16 4%.99 00:-::C-544.304 FEC Lease 18,850.00 i8,85C.00 18,619.82 0.70 230.16 98.76 001-210-545.300 insurance 17,200.00 17,200.00 13,171.50 4,390.50 (362.00) 172.10 001-210-546.302 VEHICLE REPAIR & MAINTENANCE 2,000.00 12,0CC.00 2,490.13 0.30 9,509.87 20.75 001-210-546.303 Building Repair & Maint 58,000.1.0 58,OCC.00 36,381.32 14,904.31 61713.87 68.42 001-210-546.305 Pathway Maintenance 50,000.00 50,000.00 40,i80.19 8,721.00 1,098.8_ 97.80 001-210-546.306 General Maintenance 35,000.00 35,OCC.00 13,809.46 O.DO 21,190.54 ?9.46 001-210-546.309 Landscape & Irrigation Maint 200,000.00 20C,000.0C 86,552.66 74,930.88 38,516.46 80.74 001-210-546.310 Equipment Repair & Maint 7,000.00 7,000.00 6,507.35 0.00 492.65 92.96 001-210-546.320 Computer system mair,t & suppl 6,100.00 6,IC0.00 2,342 13 800.30 2,957.87 51.51 001-210-546.340 R & M Bridge 15,OCO.00 15,000.00 176.00 0.10 :4,824.00 1.17 001-210-546.350 R & M - Roads 65,500.00 65,5CO.00 29,074.10 25,485.50 _0,940.40 83.30 04/03/2020 11:25 AN REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: !2/27 User: tracanati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTC BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED BDG- GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED F,:nd 001 - GENERAL FUND 001-210-549.300 Other Misc Ches & Obligations 41500.00 1,500.00 1,419.03 0.00 80.97 94.60 001-210-54q,304 Licenses, Pees & Permits 2,000.00 2,OCO.00 1,231.94 0.30 %E8.06 61.60 001-210-551.300 Office Supplies & Equipment 1,500.00 1,5CO.00 419.78 0.30 1,080.22 27,99 001-210-551.400 Janitorial Supplies 7,500.00 7,5CO.00 9,379.25 0.30 (i,8%9.25) 125.06 001-210-552.301 Gas & Oil 5,500.00 5,500.00 1,189.76 0.30 4,3"0.24 21.63 001-210-552.302 Small Tools and Equipment 4,000.00 4,000.00 998.75 0.30 3,001.25 24.97 001-210-552.305 Uniforms 4,000.00 4,OCO.00 2,801.75 0.30 1,198..25 70.04 001-210-553.301 Road Siyns 10,000.00 10,000.00 5,265.77 0.30 4,734.23 52.66 001-210-554.301 Personnel Training 0.00 3,000.00 3,000.00 C.30 0.00 100.00 001-210-563.600 Public Works Misc Projects 23,000.00 23,000.00 7,189.50 0.00 _5,810.50 31.26 Operating Expenditures,Expense 809,650.00 809,650.00 392,812.75 129,232.69 287,604.56 64.48 Capital Outlay 001-210-664.601 Computer Equipment 3,100.00 0.00 0.00 0.30 0.00 0.00 Capital Oitlav 3,100.00 C.00 0.00 0.30 C.CO 0.00 Personal Services 001-210-512.100 Regular Salaries & Wages 381,050.00 381,05C.00 161,819.55 0.. 42.4- 001-210-514.100 Overtime 10,000.00 10,000.00 2,924.90 0. 29.1- 001-210-515.103 Bonus Pay Plan 450.00 450.00 200.03 0... _- - 44 001-210-515.106 Clotting & Boot Allowance 900.00 9C0,00 900.01 0.:. 130.:' 001-210-515,108 Auto Allowance 2,200.00 2,2CO.00 1,040.64 0.::1 - 001-210-516.100 Compensated Absences 0.00 0.00 1,665.0; 0.30 001-210-521.101 FICA Taxes 24,050.00 24,050.00 10,185.91 0.90 001-210-521.102 Medicare Taxes 5,650.00 5,650.00 2,382.32 0.30 3,267.66 4[.- 001-210-522.102 VOT PENSION CONTRIBUTIONS GEN 41,400.00 41,4CO.00 17,502.28 0.110 23,897.72 42- 001-210-523.101 2-001-210-523.101 Life/Health Insurance 96,500.00 96,500.00 43,653.86 0.30 52,846.14 45.24 001-210-524.100 Workers' Comp Insurance 33,550.00 33,550.00 22,05"7.50 7,352.50 4,140.00 87.66 Personal Services 595,'50.00 595,750.00 264,332.0" 7,352.50 324,065.41 45.60 Net - Dept 210 - Public Works (1,408,500.00) (1,405,4CO.00) (657,144.82) (136,585.19) (6_1,669.99) Dep= 231 - Leisure Services -.: & Royalties -; i-362.100 Rental - Facilities 7,50(1.00 7,5CO.00 2,475.71 0.30 5,024.29 33.01 Royalties 7,500.00 7,500.00 2,475.71 0.30 5,024.29 33.01 _..,.c Revenues .]_C. Concession Sales 800.00 8CO.00 0.00 0.70 800.00 0.00 .."..".._..._..�s,�s Revenues 800.00 8CO.00 0.00 0.30 800.00 0.00 -Expense _- -...7.icc Employee Physical/Psycologica 1,000.00 i3Oc0.00 0.00 0.30 1,000.00 C.00 Grants Acquistion & Admin 4,000.00 4,000.00 4,500.00 0.30 (500.00) 112.50 -:.303 SPECIAL EVENTS 55,000.00 55,000.00 56,585.73 0.30 (1,565.73) 132.88 '.300 Travel & Per Diem 1,000.00 1,000.00 0.00 0.30 11000.00 0.00 ..._-_.._ m.300 Communication Services 12,000.00 12,000.00 5,111.63 0.90 6,888.3% ...FO -_- -..-.3011, Utility Services 20,000.00 20,OCO.00 6,469.43 0.30 -3,530.57 - Insurance 21,100.00 21,1CO.00 16,064.25 5,354.75 (349.06) 001-2-1-:, VEHICLE REPAIR & MAINTENANCE 2,000.00 2,000.00 259.39 0.30 1,740.6- -2 3,-E ,740.6=-231-_4EBuilding Repair & Maint 30,000.00 30,OCC.UO 7,509.91 O.JO 22,496.03 ..c..," 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 13/27 User: tracanati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED $ BCG- GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YZAR -TO-PiTE BALANCE USED Fund 001 - GENERAL FUND 001-231-546.306 General Maintenance 36,000.00 44,000.00 32,519.77 0.00 _1,480.23 73.91 001-231-546.310 Equipment Repair & Maint 1,700.00 1,7C0.00 106.59 O.JO 1,593.4= 6.27 001-231-546.320 Computer system maint & suppl 5,400.00 5,400.00 2,434.72 0.00 2,965.28 45.09 001-231-549.201 Advertising & Promotion 7,200.00 7,200.00 2,815.00 O.DO 4,385.00 39.10 001-231-549.300 Other Misc Chgs & Obligations 4,500.00 3,523.00 21.33 0.00 3,501.67 0.61 001-231-549.304 Licenses, Fees & Permits 3,100.00 4,077.00 4,070.91 0.00 E.09 99.85 001-231-5.19.332 Recreation Program Expense 43,000.00 35,000.00 29,063.06 0.00 5,936.94 83.04 001-231-549.333 Spring/Sumner Camp 17,000.00 17,000.00 866.41 O.DO _6,133.59 5.10 001-231-551.300 Office Supplies & Equipment 2,000.00 2,OCO.00 216.61 0.30 1,783.19 10.84 001-231-551.315 Concession Supplies 1,000.00 11000.00 0.00 0.00 1,000.00 0.00 001-231-55222.301 Gas & Oil 2,500.00 2,500.00 127.10 0.10 2,372.90 5.08 001-231-552.302 Small Tools and Equipment 1,500.00 1,500.00 409.00 0.00 1,091.00 27.27 001-231-554.301 Personnel Training 1,200.00 1,2CO.00 0.00 0.00 1,200.00 0.00 Operating Expenditures/Expense 272,200.00 272,200.00 169,151.10 5,354.75 97,694.15 64.11 Capital O,tlay 001-231-664.601 Computer Equipment 3,700.00 0.00 0.00 0.30 0.00 0.00 Capital Outlay 3,700.00 0.00 0.00 0.30 0.00 0.00 Personal Services 001-231-512.100 Regular Salaries & Wages 212,400.00 212,400.00 93,915.85 0.00 1:8,484.15 44.22 001-231-515.103 Bonus Pay Plan 3,150.00 3,150.00 3,150.00 0.00 0.00 100.00 001-231-515.106 Clothing & Boot Allowance 150.00 150.00 125.00 0.00 25.00 83.33 001-231-515.107 Part-time Salaries 49,350.00 49,350.00 23,437.89 0.00 25,912.11 47.49 001-231-515.108 Auto Allowance 3,000.00 3,OCO.00 1,483.79 0.00 1,51E.2- 49.46 001-231-515.109 Seasonal Salaries & Wages 30,000.00 30,000.00 0.00 0.90 30,000.00 0.00 001-231-515.120 Cell phone allowance 1,200.00 1,2CO.00 593.49 0.00 606.5- 49.46 001-231-516.100 Compensated Absences 3,00C.00 3,OCO.00 1,934.02 O.DO 1,065.98 64.47 001-231-521.101 FICA Taxes 18,200.00 18,200.00 7,198.64 0.00 11,001.36 39.55 001-231-521.102 Medicare Taxes 4,300.00 4,300.00 1,683.56 0.00 2,616.42 39.15 001-231-522.102 VOT PFNSION CONTRIBUTIONS GEN 23,100.00 23,100.00 10,201.64 0.00 2,898.36 44.16 001-2331-523.101 Life/Health Insurance 54,100.00 54,100.00 27,023.58 0.90 27,076.42 49.95 001-231-524.100 Workers' Comp Insurance 12,800.00 12,8C0.00 8,737.50 2,912.50 1,150.00 91.02 Personal Services 414,750.00 414,750,00 179,484.98 2,912.50 232,352.52 43.98 Impact Fees 001-231-363.271 Parks and Ree Impact Fees 0.00 0.00 826.80 0.00 (826.80) 100.00 impact Fees 0.00 0.00 826.80 0.00 (826.80) 100.00 Charges for Services - Recr. 001-231-347.100 Tequesta Fest 12,000.00 12,000.00 10,575.72 0.30 1,424.28 88.13 001-231-347.190 Special Events - Other 5,300.00 5,300.00 2,196.26 0.Do 3,103.74 41.44 001-231-347.201 Winter/Summer Camp Fees 40,750.00 40,750.00 28,311.65 0.00 -2,438.35 69.45 001-231-347.205 Recreation Programs Fees -8,000.00 18,OCC.00 6,959.06 0.30 _1,040.94 36.66 Charges for Services - Recr. 76,050.00 7E,05O.00 48.,042.69 0.00 28,007.3_ C3.17 Contributions & Donations 001-231-366.100 Contrib & Donations & Sponsor 5,000.00 51000.00 5,500.00 0.00 (°•00.00) i1C.00 Contributions & Donations 5,000.00 51000.00 5,500.00 0.30 (500.00) iiO.00 Net - Dept 231 - Leisure Services (601,300.00) (597,.6CO.00) (291,790.88) (6,267.25) (297,54'.87) 04/03/2020 11:25 AN, REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 14/27 User: tracarati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED ' BDG- GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED Fund 001 - GENERAL FUND Dept 700 - Debt Service DIS - Principal 001-700-571.706 2002 Note Payable -PS bdg 334,200.00 334,20-0.00 165,313.16 0.30 168,886.84 49.47 001-700-571.708 P/S - Prin - SunTrust - Pumpe 43,500.00 43,500.00 43,453.96 0.30 46.04 99.89 001-700-571.710 P/S PRIN - PD VEHICLES 0.00 15,441.00 0.00 O.DO _5,441.00 0.00 001-700-571.714 PRTN - PD EQUTPMENT 5,6£0.00 6,6.^0.00 0.00 0.30 6,620.00 0.00 001-700-571.727 Lease Prin - SCVA Fire Equip ',300.00 27,3CO.00 27,300.00 O.DO 0.00 100.00 D/S - Principal 411,620.00 427,CE1.00 236,067.12 0.50 190,993.88 55.28 D/S - Interest 001-700-572.706 2002 Note Payable - PS Bldg 38,300.00 38,3CC.00 20,93'7.58 0.10 -7,362.42 54.67 001-700-572.708 P/S - SunTrust - Pumper 5,400.00 5,4CO.00 5,339.99 0.30 60.0_ 98.89 001-700-572.710 INTEREST - PD VEHICLES 0.00 3,468.00 0.00 0.00 3,468.00 0.00 001-700-572.72? Lease Int. - SCVA - Fire Equi 800.00 8C0.00 197.30 0.00 602.70 24.66 D/S - Interest 44,500.00 47,9E8.00 26,474.87 0.30 21,493.13 55.19 Net - Dept 700 - Debt Service (456,120.00) (475,029.00) (262,541.99) 0.30 (2_2,487.0=) Dopt 900 - Intorfand Transfers Interfund Transfers Out 001-900-591.301 Trsf to Capital Imp F.:nd 127,100.00 127,100.00 127,100.00 0.00 0.00 100.00 Interfund Transfers Out 127,100.00 :27,100.00 127,100.00 0.00 0.00 100.00 Net - Dept 900 - Interfund Transfers (127,100.00) (--27,1CO.00) (127,100.00) 0.30 0.00 Dept 920 - Other Financing Sources & Uses Other Financing Sources 001-910-383.100 Capital Lease at Inception 0.00 96,505.00 0.00 0.30 96,505.00 0.00 Other Financing Sources 0.00 96,5C5.00 0.00 0.00 96,505.00 0.00 Net - Dept 910 - Other Financing Sources & Uses 0.00 96,5C5.00 0.00 0.00 96,505.00 Dept 950 - Other Nonoperating Other Financing Sources & Uses 001-950-549.391 Bank Charges 5,000.00 5,OCC.00 533.49 0.D0 41466.5_ 10.67 001-950-549.395 Credit Card Fees and Charaes 1,000.00 1,000.00 419.89 0.30 580.1= 41.99 001-950-590.001 Allocate to Fund Balance 156,350.00 :54,400.00 0.00 0.7; 154,400.00 0.00 Other Financing Sources & Uses 162,350.00 -60,4CO.00 953.38 0.00 159,446.62 0.59 Other Financing Sources 001-950-364.100 DISPOSITIONVSALE OF ASSETS 15,000.00 30,689.00 30.00 O.DO 30,659.00 0.10 Other Financing Sources 15,000.00 30,689.00 30.00 0.30 30,659.00 0.10 Unrestricted Investment Earnin 001-950-361.100 Interest/Investment Earnings 115,000.00 _15,OCO.00 41,156.87 O.CO 73,843.13 35.79 Unrestricted Investment Earnin 115,000.00 -15,000.CO 41,156.87 0.30 73,843.13 35.79 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 15/27 User: tracanati DB• Tequesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED § BDG- GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) Y?AR-TO-DATE BALANCE USED Fund 001 - GENERAL FUND Net - Dept 950 - Other No^operating (32,3350.00) (14,711.00) 40,233.49 0.00 (54,944.49) Dept 990 - Other/Reserve/Contingency Other Financing Sources 001-990-399.999 Appropriate Find Balance O.GO 30,736.00 0.00 0.00 30,73E.00 0.00 Other Financing Sources 0.00 30,736.00 0.00 0.30 30,736.00 0.00 Net - Dept 990 - Other/Reserve/Contingency 0.00 50,736.00 0.00 C.30 30,736.00 Fund 001 - GENERAL FUND: TOTAL REVENUES 13,675,450.00 13,818,380.00 9,406,192.46 0.30 4,4=2,187.54 68.07 TOTAL EXPENDITURES 13,675,450.00 13,818,380.00 6,159,773.36 807,858.48 6,850,748.16 50.42 NET OF REVENUES & EXPENDITURES 0.00 0.00 3,246,419.10 (807,858.48) (2,438,560.62) 100.00 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 16/27 User: tracanati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTC BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED � BDG- GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORhq YEAR-TO-DATE BALANCE USED Fund 301 - Capital Improvement Fund Dept 210 - Public Works Capital Oatlay 301-210-663.652 Pathway.-Sidewalk improvements 0.00 211,775.00 O.OG 199,663.00 :2,112.00 94.28 Capital O'.a lap 0.00 211,775.00 0.00 199,663.00 :2,112.00 94.26 Net - Dept 210 - Public Works 0.00 (211,775.00) 0.00 (199,663.00) (_2,112.00) Dept 399 - Misc Proj-General Capital Outlay 301-399-664.600 Macn/Equipment 0.00 _38,OCO.00 0.00 130,454.96 7,545.04 94.53 Capital Outlay 0.00 :38,OCO.00 0.00 130,454.96 7,545.04 94.53 Net - Dept 399 - Misc Proi-Ger,etai 0.00 (:38,000.00) 0.00 (130,454.96) (7,545.04) Dept 900 - Interfand Transfers Transfers In 301-900-381.001 Transfer from General Fund 127,100.00 :27,ICO.00 127,100.00 0.00 0.00 100.00 Transfers In 127,100.00 127,100.00 127,100.00 0.00 0.00 100.00 Net - Dept 900 - Interfund Transfers 127,100.00 :27,100.00 127,100.00 0.30 0.00 Dept 910 - Other Financing Sources & Uses Other Financing Sources & Uses 301-910-590.001 Allocate to Fund Balance 127,100.00 :27,100.00 0.00 0.00 127,100.00 G.00 Other Financing Sources & Uses 127,100.00 _27,1CO.00 0.00 0.30 127,100.00 0.00 Net - Dept 910 - Other Financing Sources & Uses (127,100.00) (_27,100.00) 0.00 0.70 (127,100.00) Dept 95C - Other Nonoperatirg Unrestricted Investment Earnin 301-950-351.100 Interest/Investment Earnings 0.00 0.00 3,484.26 0.30 (3,484.26) 10.00 Unrestricted Investment Earnin 0.00 0.00 3,484.26 O.DO (3,484.26) 10.00 Net - Dept 950 - Other Nonoperating 0.00 0.00 3,484.26 0.70 (3,484.26) Dept 990 - Otber/Reserve/Contingency Other Financing Sources 301-990-399.999 Appropriate Fund Balance 0.00 349,775.00 0.00 0.70 349,775.00 0.00 Other Financing Sources 0.00 349,775.00 0.00 0.00 349,775.00 0.00 Net - Dept 990 - Other/Reserve/Contingency 0.00 349,775.00 0.00 0.D0 349,775.00 04/03/2020 11:25 AM, REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 17/27 User: tracanati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2019-20 03/31/2020 ENCUMBERED UNENCUMBERED : BDG- GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NOR-0 (ABNORM) YEAR-TO-DATE BALANCE USED Fund 301 - Capital Improvement Fund Fund 301 - Capital Improvement Fund: TOTAL REVENUES 727,100.00 •176,875.00 130,589.26 0.)0 396,290.74 27.38 TOTAL EXPENDITURES 127,100.00 476,875.00 0.00 330,117.96 146,757.04 69.23 NET OF REVENUES & EXPENDITURES 0.00 0.00 :30,584.26 (330,117.96) 199,533.70 i00.00 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 18/27 User: tracanati DB: Tequesta PERIOD ENDING 03/3!/2020 2019-20 YTD BALANCE ORIGINAL 2C19-2C 03/31/2020 ENCUMBERED UNENCUMBERED i BDG^ GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YZAR-TO-DATE BALANCE USED Fund 303 - Capital Protects Fund Dept 231 - Leisure Services Capital O,Llay 303-231-663.632-40001 Architect & Engineering-Other 0.00 :541000.00 14,987.50 129,622.50 9,390.00 93.90 Capital Outlay 0.00 _54,OCC.00 14,987.50 129,622.50 9,390.00 93.90 Net - Dept 231 - Leisure Services 0.00 (_54,000.00) (14,987.50) (129,622.50) (9,390.00) Dept 317 - Recreation Center Capital Outlay 303-317-663.632 Architect & Engineering-Other 154,000.00 0.00 0.00 0.00 0.00 0.00 Capital Outlay 154,000.00 0.00 0.00 0.00 0.00 0.00 NeL - DepL 317 - ReCreatiOli CeaLer (154,000.00) 0.00 0.00 0.30 0.00 Dept 990 - Other/Reserve/Contingency Other Financing Sources 303-990-399.999 Appropriate Fund Balance 154,000.00 =54,000.00 0.00 0.30 154,000.00 0.00 Other Financing Sources 154,000.00 _54,000.00 0.00 0.00 154,000.00 0.00 Net - Dept 990 - Other/Reserve/Contingency 154,000.00 _54,000.00 0.00 0.00 154,000.00 Fund 303 - Capital Pro3ects Fund: TOTAL RE''ENL'ES 154,000.00 _54,000.00 0.00 O.D0 154,OOC.00 0.00 TOTAL EXPENDITURES 154,000.00 :54,000.00 14,987.50 129,622.:0 9,390.00 93.90 NET OF REVENUES & EXPENDITURES 0.00 0.00 (14,987,50) (129,622.50) 144,610.00 100.00 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 19/27 User: tiacanati DB: Teauesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED BDG- GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE. BALANCE USED F-d 401 - :later F.nd Dept 000 - GENERAL M"­­ ianeous Re- - :.-100-363.101 Martin/Tropic V-Const portion 26,200.00 26,2C0.00 27,848.30 0 (1,648.30) 16.29 9.CCC, Other Miscellaneous Revenue 0.00 0.00 5,711.58 (5,711.58) 1,)0.00 Insurance Reimbursement 0.00 0.00 1,386.00 O.CO (1,38E.00) i,)0.00 N, 26,200.00 26,2CC.00 34,945.88 ,,.7G (8,745.88) '33.38 ORDINANCE VIOLATION 0.00 O.CO 459.27 0.JO (459.27) 130.00 0.00 0.00 459.27 O.JO (455.27) 130.00 Other F ;ancinq Sources 401-G00-369.111 Capital Connect Charge - Deve 0.00 0.00 41,216.05 O.CO (41,21E.05) 100.00 Other Financ_ng Sources 0.00 0.00 41,216.05 0.30 (41,21E.05) 100.00 C1:a-ges r.r Ser.'ces 1-000-342.501 Site Plan Review Fees 0.00 0.00 537.50 0.00 ( .5O! 1.10.00 401-000-343.301 Water Sales 3,657,000.00 3,657,OCO.00 1,440,388.56 0.CO 39.39 401-000-343.302 Water- Connect Charges 22,600.00 22,60.00 14,435.40 0.30 .00 63.87 401-000-343.303 NATER-FIRE PROTECTION CHARGES 85,200.00 85,2CO.00 40,084.25 0.30 -- __-.-= 47.05 401-000-343.304 Water Surcharge 583,000.00 583,000.00 279,081.71 0.00 _:-.29 47.87 401-000-343.306 Monthly Service Charge 1,960,000.00 1,960,OCO.00 985,195.08 0.3U i, .42 50.27 401-000-343.307 Penalty Charges 48,000.00 48,000.00 20,628.99 0.DO _ _. 42.98 401-000-343.308 OTHER WATER SERVICE INCOME 5,000.00 5,000.00 3,027.93 0.30 i,4-:_ 60.56 401-000-343.700 .rater Conservation & Resource 1,000.00 1,000.00 0.00 C.JC 1,CC .00 0.00 Charges for Services 6,361,800.00 6,361,800.00 2,783,379.42 O.JG 3,578,420.58 43.75 Net - Dept 000 - GENERAL 6,388,000.00 6,388,000.00 2,860,000.62 0.00 3,527,999.38 Dept 241 - Water-Administration Operating Expenditures/Expense 401-241-531.301 Legal Services 5,000.00 10,000.0O 9,736.25 C.CC 263.75 97.36 :31.302 Engineering Services '5,000.00 75,OCO.00 19,916.27 20,650.30 34,433.73 54.09 --:3-_.308 Legal fees - Personnel 71,000.00 75,OCO.00 9,306.28 O.DO 65,693.72 12.41 401__'- 2.300 Accounting & Auditing Service 32,900.00 32,900.00 28,471.50 3,492.50 936.00 97.16 401-24-34.300 Other Contractual Services 66,000.00 _01,188.00 19,700.00 51,437.30 30,050.50 70.30 40`-24]-_-1.300 Com unicatior. Services 2,200.00 2,200.00 2,100.00 0.00 100.00 95.45 4C.'_-Z4_-` .304 FEC Lease 15,900.00 1_5,900.00 15,161.68 0.00 n5.36 901-_4--F-5.300 Insurance 112,600.00 -12,600.00 85,797.75 28,0"'0.25 (1,268.00) 101.19 ._. .-... ._. Computer system. maint & suppl 46,600.00 53,780.00 20,276.05 1,550.00 31,9°.3.95 40.58 Other Misc Chgs & Obligations 2,000.00 2,000.00 0.00 0.00 2,000.00 0.00 -- Admin Mgmt Fees 590,100.00 590,100.00 299,298.00 0.00 290,802.00 50.72 ---."4 Licenses, Fees & Perm'ms 800.00 800.00 781.00 0.00 19.00 7.E3 Office Supplies & Equipment 2,500.00 2,5CO.00 804.52 0.30 1,695.48 12.28 Operating Expenditures/Expense 1,026,600.00 1,073,968.00 511,349.30 105,200.25 457,418.45 .,7.41 Personal Services 401-241-512.100 Regular Salaries & Wages 329,100.00 329,100.00 147,126.26 O.DG 151,573.74 44.71 401-241-515.103 Bonus Pay Flan 11950.00 1,950.00 1,174.95 0. 0 775.65 60.25 401-241-515.107 Part-time Salaries 850.00 850.00 24.03 0.;)(i 825.97 2.83 401-241-515.108 Auto Allowance 2,650.00 2,650.00 2,736.75 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 20/27 User: tracarati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED < BDG- GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED Fund 401 - Water Fund 401-241-515.120 Cell phone allowance 11100.00 1,100.00 118.76 0.30 981.24 10.80 4',! Compensated Absences 5,000.00 "000.00 431.40 0.30 4,568.60 8.63 _.-;-11-521.101 FICA Taxes 21,100.00 21,1CO.00 9,023.66 0.30 -2,076.34 42.77 4..-.. .:-. -.102 Medicare Taxes 4,850.00 4,850.00 2,110.30 O.:C 2,739.'0 43.51 2.102 VOT PENSION CONTRIBUTIONS GEN 35,750.00 '+_`O.GO 15,981.84 0..90 -9,768.16 44.70 - -S23.10i Life/.Health Insurance 47,650.00 47,850.00 22,817.43 0..0 ..`_,0'32.5% 47.69 ,_,.100 Workers' Comp Insurance 4,150.00 4,150.00 2,846.25 948.75 355.CO 91.45 Person..:. _e.rvices 454,350.00 454,35C.00 204,391.67 948.75 249,009.58 45.19 Net - Dept 241 - Water-Administration (1,480,950.00) (1,528,318.00) (715,740.97) (106,149.00) (706,428.03) Dept 242 - Water - Production Operating Expenditures/Expense 401-242-531.342 Water Analysis & Sampling 42,000.00 42,OCO.00 16,994.00 14,161.00 -0,845.00 74.18 4C1-242-5;C..-300 Travel & Per Diem 2,200.00 2,2CO.00 650.92 0.30 1,549.08 29.59 ,.-...._.. Communication Services 18,000.00 18,000.00 8,517.21 0.30 9,482.79 47.32 4 .. Postage 2,000.00 2,000.00 3.05 0.30 1,99E.95 0.15 01 Utility Services 417,800.00 417,8CO.00 165,400.06 0.30 252,399.94 39.59 5.301 Operating Leases 2,450.00 2,450.00 1,657.48 0.90 792.52 67.65 - .4.302 Vehicle Repair & Maintenance 8,800.00 8,8-,0.00 2,484.72 0.00 6,315.28 28.24 401-4:-' ;6.303 Building Repair & Maint 45,000.00 40,0,-0.00 13,765.57 0.30 26,234.43 34.41 401-24:. ;6.309 Landscape & Irrigation Maint 33,000.00 25,000.00 4,631.59 0.30 20,368.4- 18.53 401-242-_:E.3i0 Equipment Repair & Maint 0.00 0.00 56.25 0.10 (5E.25) 100.00 401-242-546.342 Water System Maintenance 140,000.00 -15,000.00 94,801.99 0.30 20,198.0- 82.44 401-242-547.300 Printing & Binding 4,500.00 4,500.00 0.00 0.90 4,500.00 0.00 401-242-549.300 Other Misc Chgs & Obligations 5,200.00 5,2CO.00 538.45 0.J0 4,661.55 10.35 401-242-549.304 Licenses, Fees & Permits 23,500.00 23,5CO.00 23,176.98 0.90 323.02 98.63 401-242-551.300 Office Supplies & Equipment 6,900.00 6,900.00 2,9351.57 0.30 3,964.43 42.54 401-242-532.301 Gas & Oil 4,200.00 4,2CO.00 778.34 0.30 33,421.66 18.53 401-242-552.302 Small Tools and Equipment 5,100.00 3,6CO.00 2,393.63 0.30 1,206.37 66.49 401-242-552.303 Diesel Fuel 7,300.00 7,300.00 0.00 0.30 7,300.00 0.00 401-242-552.305 Uniforms 4,200.00 4,2CO.00 2,736.70 0.30 1,463.30 65.16 401-242-552.341 Wator Purchases 10,000.00 10,000.00 3,075.60 0.10 6,924.40 30.76 401-242-552.342 Water Chemicals 196,000.00 229,OCO.00 60,006.74 130,338.31 -8,654.95 91.85 401-242-552.343 Laboratory Supplies 25,000.00 25,000.00 6,513.57 C. -8,48E.433 26.05 401-242-554.300 Books, Publ, Subs & Membershi 2,000.00 2,000.00 1,596.00 0.30 404.00 79.80 401-242-554.301 Personnel Training 5,850.00 5,8°0.00 685.00 0.30 5,165.00 11.71 Operating Expenditures/Expense 1,011,bOO.00 1,004,500.00 433,399.42 144,499.31 426,601.27 57.53 Personal Services 401-242-512.100 Regular Salaries & Wages 614,700.00 614,700.00 265,963.16 0.30 348,73€.84 43.27 401-242-514.100 Overtime 20,000.00 20,OCO.00 11,336.60 0.D0 8,663.40 56.68 401-242-515.101 Holiday Pay 8,000.00 8,0,-0.00 6,439.09 0.30 1,560.9- 80.49 401-242-515.102 Standby Pay 9,500.00 9,500.00 4,458.03 0.90 5,041.97 46.93 401-242-515.103 Bonus Pay Plan 500.00 5C0.00 500.00 0.30 0.00 130.00 401-242-515.106 Clothing & Boot Allowance 1,100.00 1,1C0.00 974.99 0.30 125.0- 68.64 401-242-516.100 Compensated Absences 5,000.00 5,OCO.00 0.00 0.30 5,000.00 0.00 401-242-521.101 FICA Taxes 39,900.00 39,9CO.00 17,319.40 0.D0 22,560.60 43.41 401-242-521.102 Medicare Taxes 9,350.00 9,350.00 4,050.49 0.30 5,299.5= 43.32 401-242-522.101 FRS Contributions 1-,800.00 11,800.00 5,480.71 0.30 6,319.29 46.45 4Ci-2.42-522.102 VOT PENSION CONTRIBUTIONS GEN 58,200.00 58,200.00 24,831.95 0.30 33,368.05 42.67 401-242-523.101 Life/9ealth Insurance 134,150.00 -34,150.00 62,746.25 0.30 71,403.75 46.77 401-242-523.105 HSA - Health Savings Account 0.00 0.00 270.00 0.00 (270.00) 130.00 401-242-524.100 Workers' Comp Insurance 23,900.00 23,9[0.00 16,380.00 5,460.30 2,060.00 91.38 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 21/27 -iser: tracanati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNEN_'7MBEREC 7_ BOG- CL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED Funa 401 - Water Fund Personal Services 936,100.00 936,1C0.00 420,750.67 5,460.10 509,889.33 45.53 Net - Dept 242 - Water - Production (1,947,700.00) (1,940,600.00) (854,150.09) (149,959.31) (936,490.60) Dept 243 - Water-Distribution Operating Expenditures/Expense 401-243-526.103 Education Reimbursement Prom 3,000.00 1,4;.0.00 0.00 0.00 1,400.00 0.06 4011-243-534.300 Other Contractual Services 15,000.00 14,OCO.CO 0.00 U.00 :4,000.00 0.00 401-243-540.300 Travel & Per Diem 2,200.00 2,200.00 165.16 0.30 2,034.84 7.51 401-243-541.300 Communication Services 12,800.00 12,8CO.00 5,869.06 0.10 6,930.94 45.85 401-2433-541.301 POSTAGE 30,000.00 30,000.00 14,454.85 15,066.90 458.35 98.47 401-243-544.301 Operating Leases 1,400.00 1,4CO.00 719.84 0.30 680.16 51.42 401-243-546.302 Vehicle Repair 6 Maintenance 15,000.00 15,OCO.00 7,677.72 0.00 7,322.28 51.18 401-243-546.303 Building Repair & Maint 6,000.00 6,OCO.00 1,283.1"7 0.00 4,716.83 21.39 401-243-546.309 Landscape & irrigation N.aint 1,500.00 1,5CO.00 0.00 0.00 1,500.00 0.00 401-243-546.310 Equipment Repair & Maint 15,000.00 15,000.00 7,445.25 0.30 7,554.75 49.64 401-243-546.342 Water System Maintenance 46,400.00 44,500.00 .2,529.40 0.00 21,970.60 50.63 401-243-547.300 Printing & Binding 13,000.00 13,000.00 7,299.78 5,507.99 192.33 98.52 401-243-549.300 Other Misc Chgs & Obligations 3,100.00 3,100.00 1,096.70 0.00 2,003.30 35.38 401-243-549.304 Licenses, Fees & Permits 1,900.00 3,800.00 2,623.85 0.10 1,176.15 69.05 401-243-551.300 Office Supplies & Equipment 2,100.00 2,1CO.00 1,466.85 0.70 633.15 69.85 401-243-552.301 Gas & Oil 9,500.00 9,500.00 2,165.10 0.10 7,339.90 22.79 401-243-552.302 Small 'fools and Equipment 5,200.00 5,200.00 4,383.08 0.00 816.92 84.29 401-243-552.305 Uniforms 3,500.00 3,5CO.00 3,500.06 0.00 0.00 100.00 401-243-554.301 Personnel Training 3,100.00 3,ICO.00 1,104.00 0.10 1,996.00 35.61 Operating Expenditures/Expense SEH,700.00 _87,100.00 83,783.81 20,594.69 82,721.50 55.79 Capita- J,:tlay 402-24 .601 Computer Equipment 0.00 1,6CO.00 0.00 0.30 1,600.00 0.00 Cala- O---tlay 0.00 1,600.00 0.00 0.30 1,600.00 0.00 Pei-sonnl 3er,[.oes 401-713-ii":..100 Regular Salaries & V;agee 497,%50.00 497,750.00 221,7.09.93 0,90 276,540.07 44.44 Overtime 10,000.00 10,000.00 5,540.15 0.10 4,459.85 55.40 243- '.1,2 Standby Pay 25,250.00 25,250.00 14,869.51 0.90 -0,380.49 58.89 401-24 I.-E.1^3 Bonus Pay Plan 1,000.00 1,000.00 500.00 0.30 500.00 50.00 401-243-" 1,06 Clothing & Boot Allowance %00.00 700.00 6B7.49 0.10 12.5: 98.21 401-24' Compensated Absences 5,000.00 5,000.00 0.00 U.DO 5,000.P,C C.?0 401-24_1-1.2".102 FICA Taxes 32,900.00 32,900.00 14,640.20 C.DO -E,259.EC - 401-243-527_.102 Medicare Taxes 7,100.00 7,700.00 3,423.86 0.30 4,27C.- 401-243-522.101 FRS Contributions 12,900.00 12,9CO.00 6,276.55 0.30 6,621.45 ._ 901-243-522.102 VOT PENSION CONTRIBUTIONS GEN 44,950.00 44,950.00 19,883.67 0.70 25,066.31 _ .-4 471-243-523.101 Life/Health Insurance 112,300.00 -1213C'0.00 56,420.91 0.30 55,879.09 "0.24 401-243-524.100 Workers' Comp Insurance 15,400.00 15,4CO.00 10,492.50 3,497.50 1,410.CO 90.84 Personal Services 765,850.00 765,850.00 353,946.77 3,497.50 408,405.73 46.c- Net - Dept 2433 - Water-Distribution, (955,550.00) (954,550.00) (437,730.58) (24,092.19) (492,727.23) Dept 411 - Renewal & Replacement Operat_ng Expenditures/Expense 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 22/27 User: tracanati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED "s BDG- GL NUMBER NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED Fund 401 - Water Fund 401-411-531.302 Engineering Services 38,000.00 -18,338.00 27,212.50 76,725.03 -4,400.47 87.83 401-411-546.604 R & M - Pump and Motor Rehab 20,000.00 20,OCO.00 0.00 0.30 20,000.00 0.00 401-411-546.605 R&M - Well Rehabilitation 5,000.00 65,OCO.00 0.00 0.30 65,000.00 0.00 401-411-546.607 R&M - Nater Mains 288,000.00 315,OCO.00 0.00 0.00 3-5,000.00 0.00 401-411-549.671 Misc. Renewal & Replacement 150,000.00 853,ie1.00 593,076.40 14,016.96 246,087.64 71.16 401-411-552.601 Meters, Valves & Hydrants 750,000.00 1,061,250.00 660,080.09 305,850.00 95,319.9- 91.02 Operating Expenditures%Expense 1,311,000.00 2,432,7E9.00 1,280,368.99 396,591.99 755,808.02 68.93 Capital Oatiay 401-411-663.671 Misc. Renewel and Replacement 70,000.00 70,OCO.00 0.00 0.00 70,000.00 0.00 401-411-664.600 Mach/equipment 298,000.00 280,300.00 86,211.80 0.00 194,088.20 30.76 401-411-664.601 Computer Equipment 13,000.00 11,820.00 0.00 0.00 _1,820.00 0.00 Capital Outlay 381,000.00 362,120.00 86,211.80 0.30 275,908.20 23.8i Net - Dept 411 - Renewal & Replacement (1,692,000.00) (2,794,889.00) (1,366,580.79) (396,591.99) (1,031,71E.22) Dept 700 - Debt Service D/S - Principal 401-700-571.705 Prin - 2004 Water N/P BOA 41,000.00 41,000.00 0.00 0.90 41,000.00 0.00 401-700-571.720 Prin - 2008 Water Utility Not 347,500.00 347,560.00 170,873.58 0.30 176,626.42 49.17 D/S - Principal 388,500.00 388,500.00 170,873.58 O.DO 2".7,626.42 43.98 D/S - Interest 401-700-572.705 Ir.t - 2004 Water N/P BOA 3,700.00 3,7CO.00 300.53 0.30 3,399.47 8.12 401-700-572.720 Int - 2008 dater Utility Note 122,600.00 -22,600.00 52,044.35 0.30 70,555.65 42.45 401-700-573.700 Other Debt Service Costs 22,500.00 22,5CO.00 0.00 0.00 22,500.00 0.00 D/S - Interest 148,800.00 -48,800.00 52,344.88 0.00 96,455.12 35.18 Net - Dept 700 - -)ebt Servi.ce (537,300.00) (.`.37,100.00) (2:•3,218.46) 0.30 (3"4,0R1.54) Dept 950 - Other Nonoperating Other f-financing Sources & Uses 401-950-549.391 Bank Charges 5,000.00 S,OCC.00 533.46 O.DO 4,466.54 10.67 401-950-549.395 Credit Card Fees and Charges 20,000.00 20,0-0.00 9,062.25 0.00 -0,937.75 45.31 401-950-592.100 LEGAL SETTLEMENT 0.00 0.00 69,590.00 O.DO (69,590.00) 100.DO Other Financing Sources & Uses 25,000.00 25,0-0.00 79,i85.71 O.DO (54,185.7-) 316.74 Unrestricted Investment Earnin 401-950-361.100 Interest/Investment Earnings 120,000.00 -20,OCO.CC 45,022.3! O.DO 74,977.69 37.52 Unrestricted Investment Earnin 120,000.CG -20,000.00 45,022.31 0.00 74,977.69 37.52 Net - Dept 950 - Other Nonoperating 95,000.00 95,OCO.00 (34,163.40) 0.30 129,163.40 Dept 990 - Other/3eserve;'Contfisgency Other Financing Sources 401-990-399.999 Appropriate Fund Balance 130,500.00 1,272,657.00 0.00 0.00 1,272,657.00 0.00 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 23/27 User: tracanati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED BDG- GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YFAR-TO-DATE BALANCE USED Fund 401 - Water Fund Other Financing Sources 130,500.00 1,272,657.00 0.00 0.X, 1,272,657.00 0.00 Net - Dept 990 - Other/Reserve/Contingency 130,500.001 1,272,6°7.00 0.00 0.�0 1,272,GS i.00 Fund 401 - Pieter Fund: TOTAL REVENUES 6,638,500.00 %,780,657.00 2,905,022 93 1.JO 4,815,634.07 37.34 TOTAL EXPENDITURES 6,636,500.00 7,780,657.00 3,676,606.60 676,792.49 3,421,257.9: 511.95 NET OF RF'dFN(jES b F.XPENDTTURF.S 0.00 0.00 (771,563.x:) ('076,"1,2.4 9) 1,448,376.;6 1.0.00 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 24/27 User: tracanati DB: Teauesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2019-20 03/31/2020 ENCUMBERED UNENCUMBERED s BDG- GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED Fund 402 - Refuse & Recycling Dept 000 - GENERAL Charges for Services 402-000-343.400 Refuse i Recycling Fees 484,000.00 484,OCO.00 449,57.7.91 0.30 34,422.09 92.89 Cliarges for Services 484,000.00 484,OCO.00 449,577.91 0.30 34,422.09 92.89 Net - Dept 000 - GENERAL 484,000.0C 484,000.00 449,577.91 0.00 34,422.09 Dept 245 - Refuse and Recycling Operating Expenditures/Expense 402-24.5-543.302 Solid Waste/Residential 240,300.00 240,3CO.00 100,066.10 140,092.54 141.36 99.94 402-245-543.303 Recycling/Residential llG,800.00 -10,872.00 46,196.65 64,675.31 0.04 130.00 4D2-245-543.304 Yard Wasre/Re.-idential 137,000.G0 :37,000.00 571066.45 79,893.:13 40.52 99.97 402-245-549.300 Other Mi.sc Crgs & Obligations 600.00 528.00 0.00 0.00 528.00 0.00 402-245-549.301 Admin [4gmt fees 8,400.00 8,400.00 4,2.24.00 0.30 4,17E.00 50.29 Operating Expenditures/Erpenae 497,100.00 497,100.00 207,553.20 284,660.38 4,885.92 99.02 Net - Dept 245 - Refuse and Recycling (497,100.00) (497,iC0.00) (207,553.20) (284,660.38) (4,885.92) Dept 950 - Other Nonoperating Unrestricted Investment Earnin 402-950-361.100 interest/Investment Earnings 2,000.0() 2,000.00 583.99 0.30 1,416.0: 29.20 Unrestricted Investment Earnin 2,000.00 2,000.00 583.99 0.30 1,416.0- 29.20 Net - Dept 950 - Other Nonoperating 2,000.00 2,OCO.00 583.99 0.00 1,416.0: Dept 990 - Other/Reserve;'Conti:;ge;cy Other Financing Sources 402-990-399.999 Appropriate Find Balance 1i,10G.00 'C(;.00 0.00 0.70 _1,100.00 0.00 Other Financing Sources =1,100.00 _ ,"70.00 0.00 0.70 _1,100.00 0.00 Net - Dept 990 - Other/Reserve/Contingency =_,.:;0.00 --, 0.00 0.30 :1,100.00 Fund 402 - Refuse & Recycling: TOTAL REVENUES 497,100.00 497,1C0.00 450,161.90 0.30 46,938.10 90.56 TOTAL EXPENDITURES 497,100.00 497,100.00 207,553.20 284,660.98 4,885.92 99.02 NET OF REVENUES & EXPENDITURES 0.00 C.OG 242,608.70 (284,660.38) 42,052.18 100.00 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 25/27 User: tracanati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 Y'TD BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED BDG- GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED Fund 403 - Stormwater Utility Dept 000 - GENERAL Charges for Services 403-000-343.901 Storm Water Utility Fees 457,700.00 45',700.00 381,819.85 0.110 75,880.15 83.42 Charges for Services 457,700.00 457,700.00 381,819.65 0.30 75,880.15 83.42 Net - Dept 000 - GENERAL 457,700.00 457,7CO.00 381,819.85 0.30 75,880.18 Dept 250 - Storm Water Utilities Operating ExpendituresiExpense 403-250-531.301 Legal Services 0.00 3,OCO.00 0.00 0.00 3,000.00 0.00 403-250-531.302 Engineering Services 15,000.00 12,DCC.00 5,935.45 0.30 6,064.55 49.46 403-250-532.300 Accounting & Auditing Service 4,600.00 4,6CO.00 3,986.01 488.49 125.50 97.27 403-250-534.300 Other Contractual Services 5,000.00 29,175.00 24,505.00 9,6'70.70 5,000.00 82.86 403-250-541.300 Communication Services 4,000.00 4,000.00 1,726.23 0.30 2,273.77 43.16 403-250-546.302 Vehicle Repair & Maintenance 2,000.00 2,000.00 94.75 0.70 1,905.25 4.74 403-250-546.308 Drainage Maintenance 45,000.00 45,OCO.00 25,807.24 5,037.50 :4,155.26 68.54 403-250-546.310 Equipment Repair & Maint 5,000.00 5,000.00 1,671.11 0.70 3,328.89 33.42 403-250-549.300 Other Misc Chgs & Obligations 4,000.00 4,000.00 736.51 0.00 3,263.49 18.41 403-250-549.301 Admin Mgmt Fees 14,200.00 14,2CO.00 7,146.00 0.70 7,054.00 50.32 403-250-549.304 Licenses, Fees & Permits 5,000.00 5,000.00 4,773.05 0.00 226.95 95.46 403-250-552.301 Gas & Oil 1,500.00 1,SC0.00 403.73 O.DO 1,096.27 26.92 403-250-552.302 Small Tools and Equipment 5,000.00 5,OCO.00 1,594.19 0.30 3,405.8: 31.88 403-250-554.100 Public Education Program 1,000.00 11000.00 0.00 O.DO 11000.00 0.00 403-250-554.301 Personnel Training 1,000.00 1,000.00 919.00 O.Do 81.00 91.90 Operating Expenditures/Expense 112,300.00 _36,475.00 69,298.2% 15,195.99 51,980.74 61.91 Capital Outlav 403-250-664.600 Mach;squipment 22,000.00 22,000.00 21,027.95 0.70 972.05 95.58 Capital Outlay 22,000.00 22,OCO.00 21,027.95 0.70 972.05 95.58 Personal Services 403-250-512.100 Regular Salaries & Wages 66,000.00 86,000.00 39,604.7 0.30 46,395.23 46.05 403-250-514.100 Overtime 11000.00 1,GC0.00 0.00 0.30 1,000.00 0.00 403-250-515.103 Bor.us Pav_ Pian 100.00 100.00 100.00 0.30 0.00 iDC.00 403-250-515.106 Clcthing & Boot Allowance 200.00 200.00 187.51 C.70 12.49 93.76 403-250-515.108 Aute Allowance 0.00 0.00 383.83 G.DO (383.83) 100.00 403-250-521.101 FICA Taxes 5,600.00 51600.00 2,443.39 0.30 3,150.6_ 43.63 403-250-521.102 Medicare Taxes 1,250.00 1,250.00 571.40 0.30 678.60 45.71 403-250-522.102 VOT PENSION CONTRIBUTIONS GEN 9,350.00 9,350.00 4,302.06 0.30 5,047,94 46.01 403-250-523.101 Life/Health T7surance 18,000.00 18,000.00 8,596.6° 0..^,0 9,403.3- 47.76 403-250-524.100 Workers' Comp Insurance 3,450.00 3,450.00 2,343.75 781.25 325.00 90.58 Personal Services 124,950.00 :24,950.00 58,533.40- 781.25 65,635.35 47.47 Net - Dept 250 - Storm Water Utilities (259,2::0.00) (283,425.00) (=4E,859.62) (15,97,7.24) (1_8,588.14) Dept 411 - Renewal & Replacement Operating Expenditures/Expense 403-411-531.302 Engineering Services 50,OOO.CC 58,5CO.00 21,819.40 19,680.60 27,000.00 53.85 4033-411-546.308 Drainage Maintenance 250,000.00 250,000.00 9,223.00 0.30 240,777,00 3.69 Operating Expenditures/Expense 300,000.00308,5CO.00 21,092.90 19,680.60 267,777,00 13.20 04/03/2020 11:25 AN REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 26/27 User: tiacanati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED "s BDG^_ GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USED Fund 403 - Stormwater Utility Capita O;tiay 403-411-663.66.3 Drainage Improvements 0.00 ??,705.00 0.00 65,590.00 2,1L.OG 84.4: Capital O.:tia_: 0.00 77,7C5.00 0.00 65,590.00 =2,115.00 34.4- Net - Dept 411 - Renewal S Replacement (300,000.00) (386,2C5.00) (21,042.40) (85,270.60) (279,892.00) Dept 950 - Other Nonoperatinc Operating Expenditures/Expense 403-950-559.301 Budgeted Depreciation (netted 85,000.00 85,000.00 0.00 0.00 65,OOO.00 0.00 Operating Expenditures/Expense 85,000.00 85,000.00 0.00 0.30 85,000.00 0.00 Unrestricted Investment Earnin 403-950-361.100 Interest/Investment Earnings 22,500.00 22,5CO.00 8,051.50 0.00 -1,405.50 35.98 Unrestricted Investment Earnin 22,500.00 22,500.00 8,094.50 0.00 -4,405.5C 35.98 Net - Dept 950 - Other Nonoperating (62,500.00) (62,5CO.00) 8,094.50 0.30 (70,594.50) Dept 990 - Other/Reserve/Contingency Other Financing Sources 403-990-399.999 Appropriate Find Balance 164,050.00 274,430.00 0.00 0.10 274,430.00 0.00 Other Financing Sources 164,050.00 274,430.00 0.00 0.00 274,430.00 0.00 Net - Dept 990 - OtheriReserver Contingency 164,050.00 274,430.00 0.00 0.30 274,430.00 Fund 403 - Stormwater Utility: TOTAL REVENUES 644,250.00 754,630.00 389,314.35 0.30 364,715.65 51.67 TOTAL EXPENDITURES 644,250.00 754,630.00 169,902.02 101,247.34 483,480.14 35.93 NET OF RE','EMUES L EXPENDITURES 0.00 O.00 220,012.33 (101,247.34) (1-8,764.49) 100.00 04/03/2020 11:25 AM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 27/27 User: tracanati DB: Tequesta PERIOD ENDING 03/31/2020 2019-20 YTD BALANCE ORIGINAL 2C19-20 03/31/2020 ENCUMBERED UNENCUMBERED s BDG- GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) Y3AR-TO-DATE BALANCE USED Fund 605 - Special Law Enforcement Dept 171 - Police Operating Expenditures/Expense 605-171-540.300 Travel & Per Diem 0.00 11870.00 1,512.00 ;58.]0 0.00 190.00 605-171-549.300 Other Misc Chas & Obligations 0.00 426.00 0.00 425.53 0.47 99.89 Operating Expenditures/Expense 0.00 2,296.00 1,51.00 783.53 0.47 99.98 Grants - State 605-171-334.207 FMIT MATCING SAFETY GRANT 0.00 0.00 4,265.00 0.00 (4,265.00) 100.00 Grants - State 0.00 0.00 4,265.00 0.00 (4,265.00) 100.00 Net - Dept 171 - Police 0.00 (2,296.00) 2,753.00 (783.53) (4,265.47) Dept 990 - Other/Reserve/Contingency Other Financing Sources 605-990-399.999 Appropriate Find Balance 0.00 2,296.00 0.00 0.00 2,29E.00 0.00 Other Financing Sources 0.00 2,296.00 0.00 0.00 2,29E.00 0.00 Net - Dept 990 - Other/Reserve/Contingency 0.00 2,296.00 0.00 0.00 2,296.00 Fund 605 - Special Law Enforcement: TOTAL REVENUES 0.00 2,296.00 4,265.00 0.90 (1,969.00) 185.76 TOTAL EXPENDITURES 0.00 2,296.00 1,51 2.00 783.53 0.47 99.98 NET OF REVENUES f, EXPENDITURES 0.00 0.00 2,753.00 (783.53) ('_,969.47) 100.00 TOTAL REVENJES - ALL FUNDS 21,736,400.00 23,483,938.00 13,286,140.90 0.30 10,197,797.10 56.58 .CTRL EXPO;:DITCRES - ALL FUNDS 21,736,400.00 23,483,938.00 10,230,334.68 2,331,083.68 10,922,519.64 53.49 NET OF REVEN7ES & EXPENDITURES O.00 0.00 3,055,806.22 (2,331,083.68) (724,722.54) 100.00 February 2020 Department Reports Building Department 10/31/2019 11/30/2019 12/31/2019 1/31/2020 2/28/2020 Year To Date In-Office Meetings With Residents 18 26 22 14 22 80 Permits Issued 115 130 102 118 113 465 New Residential Permits 0 1 1 1 1 3 Residential Remodel Permits 47 76 51 64 65 238 Commercial Remodel Permits 9 7 5 6 7 1 27 Trade Permits 59 76 46 48 40 229 Residential Plan Reviews 63 47 46 64 66 220 Commercial Plan Reviews 9 7 5 6 7 27 Total Inspections 266 279 205 228 293 978 Certificates of Compliance 75 75 62 48 52 260 Over the Counter 24 45 38 45 49 152 Electronic 91 85 64 73 64 313 Land Develoment fees $18,793 $28,280.47 $15,624.92 $8,308.89 $18,327.59 $71,007.28 0-+ 21,741.85 49,114.48 $31,164.09 $31,981.52 $35,992.18 $134,001.94 Building Permits average turnaround 48 hrs 48 hrs 48hrs 48hrs 48hrs I 48hrs Complaints 3 0 1 0 1 4 Record Requests 18 23 19 17 7 77 Permit/Code Information Requests 23 31 26 32 34 112 Regular Council Meetings 1 1 1 1 1 4 Council Workshop Meetings 1 1 1 1 1 4 FFMA-ASFPM Meetings/Training 2 2 1 2 1 7 BCAIB-BOAF-BOATC/DBPR Meetings 2 2 1 1 1 6 Code Enforcement Inspections 16 30 7 15 24 68 Notices of Violation Issued 12 15 6 6 6 39 Rubbish and accumulation 0 1 2 1 2 4 Illegal RV/camper/trailer parking 5 18 2 9 10 34 Illegal water drainage 1 1 0 0 0 2 Other 9 23 7 9 16 48 Code Cases Opened 8 42 10 19 27 79 Code Cases Closed 1 5 1 27 1 4 1 21 1 31 57 Code Cases Cleared Within 30 Days 5 30 4 16 25 55 Code Cases Scheduled for Hearing 2 3 2 3 2 10 Magistrate Meeting 1 2 2 0 3 5 Meeting With Residents Regarding Violations 10 18 5 9 14 42 Community Development 1/19/2019 2/19/2020 Year To Date Land Development Applications 2 2 Board Meetings 1 1 Ongoing Projects 2 2 10 Year Water Supply Plan 1 1 Non Ad Valorem(NAV) N/A N/A 1 1 1 N/A N/A Major Meetings and Conference Calls 4 7 PBC Annexation 1 1 2GHO Projects-Reserve/Key Estates/Tequesta Country Club Pelican Square/209 Tequesta Drive 0 2 Harvey Academy 2 2 Residents/Business Owners 1 2 DRC Meeting 0 0 Permits(New Single Family and Commercial) 3 1 Phone Calls/Emails/Walk-Ins 152 147 Year To Date Fire 10/31/2019 11/30/2019 12/31/2019 1/31/2020 2/29/2020 as of 10/2019 Station Maintenance 469 409 563 572 633 2646 Daily Training 646 514 507 655 527 2849 Company Training 215.8 74.9 0 118.35 109.43 518.48 Officer Development Training 74.15 38.5 58 111.5 74 1 356.15 Driver and Operator Training 13 6 0 42.25 82 143.25 Hazmat Training 2.5 4 4 20 22 52.5 Other Training 3 16 71 16 10 116.3 Fire Fighter Administrative Duties 563 530 623 580 619 2915 Unit Reponse Data Fire 121 181 15 i 19 16 80 EMS 891 871 97 1 95 80 448 Special Operations 11 01 3 1 0 2 6 Other 5 2 1 4 4 16 Mutal Aid Given-Palm Beach County and Martin County Fire R 6 11 7 14 13 51 Rescue 6 13 12 14 10 55 Inspection Data 0 New Construction 14 22 15 16 37 104 Annual Fire 15 114 50 49 41 269 New Business/New Occupation/Home Business 1 4 2 5 1 13 Re-Inspections 32 18 14 6 7 77 Food Truck/Tents 12 6 6 0 15 39 Public Relations Events Data Community Functions Hours 89 125 90 8 33 345 Station Tours D 10 19 4 12 45 Walk Ins 3 2 3 5 2 15 Overtime As of 12/27/19 Budget Actual Goal/Actual% Overtime Budget $85,000 $46,960 429/o/66% Overtime Training Budget 1 $23,200 1 $10,272 1 420/o/45% "Includes Cash Comp Time Human Resources&Risk Management 1/19/2019 2/19/2020 Year To Date Open Positions 0 2 7 Applications Received 28 19 247 Onboardings-Hires 2 1 8 Offboardings-Terms 0 1 6 Payroll Authorizations&Evaluations 31 13 308 EE Benefit Chgs& Verifications 5 0 33 EE Recognition-Individual 27 20 131 EE Recognition-Group 0 0 2 Training-Headcount 4 11 20 FMLA Requests 0 1 4 Work Comp Claims 1 0 2 Grievances,Investigations and Lawsuits(EE) 1 2 6 Policy and Handbook updates 0 0 0 Records Requests 2 0 6 HR Information System Adjustments 1707 1 14941 10963 Newsletter 1 1 5 Safety Meetings and Assessments 0 1 3 Auto,Property,Liability Claims 1 2 5 IT 2/19/2020 Prior Month Year To Date Helpdesk Tickets 123 96 544 Projects North Com N/A N/A N/A Decommission Server 2008 R2 N/A N/A N/A Switch Replacement Proposal N/A N/A N/A Skatepark Camera Parks and Recreation 1/19/2019 2/19/2020 Year To Date Summer Camp Registration 45 0 0 Ages 5-7 13 0 0 Ages 7-12 32 0 0 Ages New Families 6 0 0 Revenue $46,687.50 $0.00 $0.00 Recreation Programs Tai Chi Classes 14 14 14 Yoga Classes 20 30 30 Tennis Classes 13 13 13 Fencing Classes 8 8 8 Gymnastics Classes 0 56 56 Open Gym Classes 0 3 4 Ninja Scouts Classes 0 4 4 Homeschool Classes 0 3 4 Mah Jongg Program 0 0 0 Revenue Facility Rentals Constitution Park 3 7 7(Residents) Recreation Center 1 3 1 3(Residents) Tequesta Park 0 0 Groups 3 S 1 3 Reservations 20 1 Revenue Special Events Food Truck Feb 7 N/A 1,000 Senior Trip Feb 11 N/A 12 Police Department 1/19/2019 2/19/2020 Year To Date Communication Division Officer Initiated Calls 745 439 9183 Calls for Service 335 285 5471 Fire Rescue 42 29 751 Patrol Division Reports Filed 32 15 366 Arrest 8 1 83 Crashes Investigated 10 6 357 Traffic Stops 279 150 3390 Citations 63 17 631 Warnings 79 27 738 Administration Open Positions 1 0 1 Resignations 0 0 2 Public Records Request 44 52 668 Overtime Budget Actual Goal/Actual% Operations $92,100 $22,004 42%/24% Communications $15,500 $5,576 42%/44% Public Works 10/19/2019 11/19/2019 12/19/2019 1/19/2020 2/19/2020 Year To Date Properties and Areas Mowed 4 times per month 33 33 33 33 33 165 Properties Trimmed Hedges 20 10 15 10 20 75 Properties Trimmed Palms and Trees 10 30 10 1 20 10 80 Flowers Planted 329 80 60 421 160 1050 Properties Fertilized 1 1 0 5 1 4 11 Landscape equipment maintenance frequency per month 3 1 1 1 1 1 2 1 8 Sidewalk Repairs and or Grinding 2 0 4 3 3 12 Street Signs Replaced 1 1 0 2 8 12 Road Repairs 4 0 2 1 2 9 Pet Pots Maintained 2 times per week 8 8 8 8 8 40 Vegatation Debris in yards 60 60 60 60 60 300 BannersHung 20 24 27 31 32 134 Outdoor lights Repaired 7 12 4 3 10 36 Street Light Outages 6 0 0 0 0 0 Work Orders 138 150 101 177 270 836 Standby Generator Maintenance 4 2 2 2 2 12 Fleet Maintenance-Vehicles Serviced 6 14 13 10 14 1 57 Surplus-Junked or Sold lems 0 0 0 0 0 0 Utility Locates 811 Dig 1 0 2 2 7 12 Engineering Services 2 1 1 2 2 8 Resident Calls 18 28 11 19 10 86 Event Set-up 5 8 6 4 4 27 Projects 7 15 8 5 29 64 Village Clerk's Office 2/1/2020 Year To Date 2019 2018 Agendas Compiled and Distributed 3 6 51 39 Council and Committee Meeting Hours 6.5 12.75 73.25 62.75 Orders Processed 4 6 30 48 Resolutions Processed 6 7 52 35 Ordinances Processed 1 1 18 11 Agreements Processed 14 28 60 65 Legal Advertisements Legal Notices 2 3 43 38 Bids/RFPs/Quotes 1 1 5 3 Public Records Processed 23 65 230 226 Lien Request Processed 38 75 465 539 Imaged/scanned pages 1195 2519 11686 12551 Agenda/Minute Portal(iCompass)Unique Monthly Visits 348 740 N/A N/A Public Information Officer Facebook Posts 26 56 377 426 Facebook Message Resposes 5 16 156 Unknown Facebook Followers *3576 *3576 *3532 Unknown Total Monthly Page Views 1023 1951 Unknown Unkown Total Montly Page Reach 21812 42441 Unknown Unkown Press Releases 2 3 8 3 CodeRed Messages Launched 3 6 35 N/A Friday News 3 5 N/A N/A Smoke Signals 1 0 4 4 Clerk&Public Information Officer Events&Meetings: Tequesta Business Association&Hobe Sound Chamber Steering Committee,PR Video Project Coordination, Annexation Meeting and PR communications,Volunteer Recognition coordination,Shred It coordination,arranged Website: Clerks Offce serves as the webmaster and updates and amends most pages,handles user administration,alerts, Election: Campaign Treasurer Reports •number varies due to page likes/unlikes Water Distribution 1/19/2019 2/19/2020 Year To Date Line Maintenance 3 0 3 Equipment Maintenance 22 20 42 Work Orders(Non Meter) 27 6 33 Employee Call Back 10 22 32 Valves Exercised 10 0 10 Service Repairs 2 18 20 Meter Set/Changed Out 24 8 32 Meter Reader Related Work Orders 51 32 83 Locates Performed 264 296 560 Staff Vacancies(Days) 20.96 26.56 47.52 Customer Service/Billing 1/19/2019 2/19/2020 Year To Date New Accounts 35 34 69 Closed Accounts 30 34 64 Work Orders Completed 1 180 121 1 301 Total Accounts Billed 5063 5063 10126 Aging Report 30 Days $25,637.27 $19,554.85 N/A 60 Days $13,067.96 $15,466.77 N/A 90 Days $15,195.92 $14,648.14 N/A 180 Days $26,270.78 $28,520.84 N/A Past Due Shutoff List(Slow Pay) 102 104 206 Amount $18,298.21 $20,271.67 38,569.88 Bill Adjustment Report 24Accounts 14Accounts 38 Leak 5 Accounts 8Accounts 13 Misread 17Accounts 3Accounts 20 NON-SUFFICIENT FUNDS(NSF)FEE 2 Accounts 3Accounts 5 Amount Billed $518,409.03 $498,413.75 1,016.822.78 Water Usage 67,751 64,175 131,926.00 Water Production 1/19/2020 2/19/2020 YTD Water Production Total 74.554 70.200 144.754 Maximum Day 2.681 2.994 2.994 Minimum Day 2.073 1.756 1.756 Average Daily 2.405 2.42 2.4125 Backwash Water 1.861 1.789 3.65 Monthly Total Gallons Flushed 2.252 2.252 4.504 Monthly Rainfall 2.91 3.56 6.47 Projects: Annual Generator Preventive Maintenance Scrubber and Degassifier analysis and review RO Filter Prefilters changed