Loading...
HomeMy WebLinkAboutDocumentation_Regular_Tab 10_9/12/2019Agenda Item #10. �T J Regular Council STAFF MEMO A� CO�M41 Meeting: Regular Council - Sep 12 2019 Staff Contact: Jeremy Allen, Village Manager Department: Manager Manager's Report Below are list of the Financial and Departmental reports presented and statistical data for the month of July 2019. Financial Reports — Unadjusted, Unaudited -Balance Sheets, Summary (attached) -Revenue & Expenditure Report, Detailed (attached) -Revenue & Expenditure Report (prior year comparison), Summary, Detailed (attached) -Revenue & Expenditure Report (target budget), Summary (attached) -Cash and Investment Report (attached) -Departmental Reports/Statistics 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 100% of the budgeted amount. We are waiting for receipt of the delinquent tax distribution payment in the month of August, which is insignificant. Historically, 91 % of ad valorem tax distribution receipted by the end of February. 3)Sales Taxes collected $359 thousand, which represent 77% of the budgeted amount and on target for nine-month collection due to the distribution to be month behind the collection/reported period. 4)Other sales/use taxes (66%) and intergovernmental revenues (77%) fall below 83% budget target due to the distribution to be month behind the collection/reported period. Local Discretionary infrastructure surtax falls two moth behind. 5)Revenues (Budgetary comparison) recorded in the General fund are $11.4 million, which represents 89% of budgeted mainly due to the property taxes collected at 100%. Overall revenues within targeted ranges with the exception of few that are exceeded Village's expectations or were not budgeted at all due to the unpredicted nature: -General Government charges for services above budgeted $11,518 due to the fee schedule adjustment; -Insurance reimbursement $13,211 (not budgeted); -Summer Camp $47,463 vs $33,750 budgeted; Page 222 of 485 Agenda Item #10. -Investment earnings $113,257 vs $80,000 budgeted. 6)Overall Expenditures (Budgetary comparison) in the General Fund are $9.1 million, which represents 77% of budgeted, which is below targeted amount, by $831 thousand. Senior staff has been advised to be cautious of spending's and stay within the budgeted amounts as we are approaching the fiscal year end. 7)Although all Expenditures/Expenses related to FY 2019 have not been recorded at this time, we have noted that the following departments in the General Fund reporting actual expenses in excess of budget (a full report is attached): -Dep 150: Planning — Other contractual services ($4,195 over) -Dep 175: Police — Clothing and boot allowance at 112% budget used ($1,630 over) -Dep 175: Police — P/T salaries at 104% budget used -Dep 175: Police — P/T salaries — communications at 127% budget used ($6,781 over) -Dep 192: Fire — Overtime is at 91 % budget used -Dep 192: Fire — Vehicle repair and maintenance at 92% budget used 8)Revenues (Prior year comparison) all funds recorded this year are $760 thousand (4.6%) more than prior year due to the increase in ad valorem taxes, higher investment earnings that is offset by less fees collected due to not as many big construction projects this year. 9)Expenditures (Prior year comparison) all funds has decreased by $401 thousand (2.6%) due to budget cuts at the beginning of the fiscal year in the General fund, not any road/sidewalks projects budgeted in FY 2019. Balance Sheet 7.31.19 2Copy of Revenue Expenditure July 2019 3 3Rev exp detailed Copy of Cash Investments Monthly Report Final Jully Managers Report 2 Page 223 of 485 II ##0##10� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 1/7 e Period Ending 07/31/2019 DB: Tequesta Fund 001 GENERAL FUND GL Number Description Balance *** Assets *** Cash and Cash Equivalents 169,267.03 Investments 5,051,874.16 Accounts Receivable 264,430.74 Due from Other Funds 0.00 Inventories 35,828.95 Prepaids 40,411.76 Other Assets - Current 0.00 Other Fixed Assets 0.00 Total Assets 5,561,812.64 *** Liabilities *** Accounts Payable 29,949.08 Accrued liabilities (4,257.77) Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 3,856.38 Deferred Revenue 0.00 Other Current Liabilities 0.00 Customer Deposits 0.00 Noncurrent liabilities 0.00 Def Inflows of Resources 119,422.82 Total Liabilities 148,970.51 *** 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 224,994.55 Fund Balance - Restricted 1,506,888.00 Fund Balance - Committed 500,000.00 Fund Balance - Assigned 0.00 Fund Balance - Unassigned 1,650,228.03 Total Fund Balance 3,882,110.58 Beginning Fund Balance 3,882,110.58 Net of Revenues VS Expenditures 1,530,731.55 Ending Fund Balance 5,412,842.13 Total Liabilities And Fund Balance 5,561,812.64 Page 224 of 485 Usxltrr, O� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 2/7 �` Period Ending 07/31/2019 DB: Tequesta Fund 301 Capital Improvement Fund GL Number Description Balance *** Assets *** Cash and Cash Equivalents 11,970.39 Investments 0.00 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Total Assets 11,970.39 *** 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 - Assigned 0.00 Fund Balance - Unassigned 30,524.77 Total Fund Balance 30,524.77 Beginning Fund Balance 30,524.77 Net of Revenues VS Expenditures (18,554.38) Ending Fund Balance 11,970.39 Total Liabilities And Fund Balance 11,970.39 Page 225 of 485 f7'7c�9 �Gtil �� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 3/7 �` Period Ending 07/31/2019 DB: Tequesta Fund 303 Capital Projects Fund GL Number Description Balance *** Assets *** Cash and Cash Equivalents 169,312.79 Investments 0.00 Accounts Receivable 0.00 Due from Other Funds 0.00 Prepaids 0.00 Improvements Other Than Bldgs. 0.00 Total Assets 169,312.79 *** 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 204,312.79 Total Fund Balance 204,312.79 Beginning Fund Balance 204,312.79 Net of Revenues VS Expenditures (35,000.00) Ending Fund Balance 169,312.79 Total Liabilities And Fund Balance 169,312.79 Page 226 of 485 Q�7a9'�ii�oBALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 4/7 s WO fF Period Ending 07/31/2019 DB: Tequesta Fund 401 Water Fund GL Number Description Balance *** Assets *** Current Assets 0.00 Cash and Cash Equivalents 754,919.54 Investments 5,275,630.21 Accounts Receivable 609,456.55 Special Assess -Current 0.00 Special Assess - noncurrent 0.00 Due from Other Funds 0.00 Inventories 211,488.74 Prepaids 19,487.35 Other Assets - Current 0.00 Land 83,335.00 Other Assets - Non Current 83,335.00 INFRASTRUCTURE 14,612,902.33 Buildings 272,115.17 Improvements Other Than Bldgs. 31,708.80 Machinery & Equipment 230,717.18 Construction in Progress 2,517.38 Intangible Assets 80,635.19 Other Fixed Assets 0.00 Deferred Outflows 553,023.53 FIXED ASSETS 0.00 Total Assets 22,737,936.97 *** Liabilities *** Accounts Payable 55,570.80 Accrued liabilities 17.15 Retainage Payable 0.00 Due to Other Funds 0.00 Due to Other Governments 335.52 Deferred Revenue 0.00 Current Portion of Debt 387,702.79 Other Current Liabilities 0.00 Customer Deposits 36,818.87 Noncurrent liabilities 3,507,580.03 Other Long Term Liabilities 400,755.63 Def Inflows of Resources 231,539.00 Total Liabilities 4,620,319.79 *** 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 5,464,397.11 Total Fund Balance 17,549,160.98 Beginning Fund Balance 17,549,160.98 Net of Revenues VS Expenditures 568,456.20 Fund Balance Adjustments 0.00 Ending Fund Balance 18,117,617.18 Total Liabilities And Fund Balance 22,737,936.97 Page 227 of 485 IIs kdif # 0. BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 5/7 Period Ending 07/31/2019 DB: Tequesta Fund 402 Refuse & Recycling GL Number Description Balance *** Assets *** Cash and Cash Equivalents 172,526.30 Investments 69,822.17 Accounts Receivable 490.74 Other Assets - Current 0.00 Total Assets 242,839.21 *** 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 118,098.59 Total Fund Balance 118,098.59 Beginning Fund Balance 118,098.59 Net of Revenues VS Expenditures 124,740.62 Ending Fund Balance 242,839.21 Total Liabilities And Fund Balance 242,839.21 Page 228 of 485 0111to.� #10� BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 6/7 111 fF Period Ending 07/31/2019 DB: Tequesta Fund 403 Stormwater Utility GL Number Description Balance *** Assets *** Cash and Cash Equivalents 166,453.30 Investments 907,572.15 Accounts Receivable 421.58 Due from Other Funds 0.00 Inventories 555.74 Prepaids 0.00 Other Assets - Current 0.00 Other Assets - Non Current 0.00 INFRASTRUCTURE 1,115,691.07 Buildings 0.00 Improvements Other Than Bldgs. 0.00 Machinery & Equipment 15,508.84 Construction in Progress 0.00 Deferred Outflows 21,769.00 Total Assets 2,227,971.68 *** Liabilities *** Accounts Payable 778.39 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 12,034.41 Def Inflows of Resources 11,223.00 Total Liabilities 24,035.80 *** 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 843,213.86 Total Fund Balance 2,079,600.92 Beginning Fund Balance 2,079,600.92 Net of Revenues VS Expenditures 124,334.96 Fund Balance Adjustments 0.00 Ending Fund Balance 2,203,935.88 Total Liabilities And Fund Balance 2,227,971.68 Page 229 of 485 It 0BALANCE SHEET FOR VILLAGE OF TEQUESTA Page: 7/7 Period Ending 07/31/2019 DB: Tequesta Fund 605 Special Law Enforcement GL Number Description Balance *** Assets *** Cash and Cash Equivalents 108,391.34 Investments 0.00 Accounts Receivable 0.00 Inventories 0.00 Total Assets 108,391.34 *** Liabilities *** Accounts Payable 8,445.89 Due to Other Funds 0.00 Total Liabilities 8,445.89 *** Fund Balance *** Fund Balance - Nonspendable 0.00 Fund Balance - Assigned 0.00 Fund Balance - Unassigned 108,391.34 Total Fund Balance 108,391.34 Beginning Fund Balance 108,391.34 Net of Revenues VS Expenditures (8,445.89) Ending Fund Balance 99,945.45 Total Liabilities And Fund Balance 108,391.34 Page 230 of 485 im U2 (D CL sy (D CD VILLAGE OF TEQUESTA REVENUE AND EXPENDITURE REPORT FOR THE VILLAGE OF TEQUESTA PERIOD ENDING 07/31/2019 YTD BALANCE YTD BALANCE DESCRIPTION 07/31/2018 07/31/2019 1 VARIANCE % VARIANCE NOTES REVENUES General Property Taxes 6,422,348 6,799,306 376,957 5.87% Property value increase Sales & Use Taxes 1,029,094 1,032,108 3,015 0.29% Franchise fees - gross receipt 378,903 376,319 (2,584) -0.68% Intergovernmental Revenue 700,887 671,277 (29,610) -4.22% Chgs for Sery - Gen Gov 82,947 57,618 (25,329) -30.54% Land development fees due to current projects varies Intragovernmental Revenue 481,083 495,583 14,500 3.01% Rents & Royalties 176,099 177,982 1,883 1.07% Miscellaneous Revenues 52,832 61,080 8,248 15.61% Insurance reimbursement higher in FY 2019 Chgs for Sery - Public Safety 920,030 910,223 (9,808) -1.07% Fines & Forfeitures 7,364 50,989 43,625 592.37% Code enforcement fees collected higher in FY 2019 Impact Fees 391 425 34 8.73% Due to the big construction projects Contributions & Donations 1,400 8,100 6,700 478.57% Park and Recreation increased donations Licenses & Permits 637,434 600,067 (37,367) -5.86% Grants - State 22,000 17,192 (4,808) -21.85% Grants differ from year to year Charges for Services 5,382,178 5,773,352 391,174 7.27% Charges for Services - Recr. 70,716 74,225 3,509 4.96% Other Financing Sources 126,316 46,038 (80,279) -63.55% Capital connect fees for big construction projects Unrestricted Investment Earning 138,165 237,944 99,779 72.22% Higher interest rate and investment balance Transfers In 740,100 0 (740,100) -100.00% Transfers differ from year to year TOTAL REVENUES 17,370,288.62 17,389,829.75 19,541.13 0.11% TOTAL REVENUES LESS TRANSFERS 16,630,188.62 17,389,829.75 759,641.13 4.57% EXPENDITURES General Fund 10,727,172 9,901,603 (825,569) -7.70% Budget spending's cut Capital Improvement Fund 546,626 19,720 (526,906) -96.39% Side walk projects in prior year Capital Projects 0 35,000 35,000 100.00% New recreation center architect Water Fund 3,888,528 4,459,727 571,199 14.69% Refuse & Recycling 360,304 360,553 249 0.07% Stormwater Utility 552,635 318,518 (234,117) -42.36% No projects were completed S"cial Law Enforcement 169,871 8,446 (161,425) -95.03% No purchases were budgeted in FY 2019 JTAL EXPENDITURES 16,245,136 15,103,567 (1,141,570) -7.03% TWAL EXP LESS TRANSFERS 15,505,136 15,103,567 (401,570) -2.59% IgT OF REVENUES & EXPENDITURES 1,125,152 2,286,263 1,161,111 im U2 (D CL sy (D CD i VILLAGE OF TEQUESTA REVENUE AND EXPENDITURE REPORT FOR THE VILLAGE OF TEQUESTA PERIOD ENDING 07/31/2019 YTD BALANCE YTD BALANCE DESCRIPTION 07/31/2018 07/31/2019 VARIANCE % VARIANCE NOTES REVENUES General Property Taxes 6,422,348 6,799,306 376,957 5.87% Property value increase Sales & Use Taxes 1,029,094 1,032,108 3,015 0.29% Franchise fees - gross receipt 378,903 376,319 (2,584) -0.68% Intergovernmental Revenue 700,887 671,277 (29,610) -4.22% Chgs for Sery - Gen Gov 82,947 57,618 (25,329) -30.54% Land development fees due to current projects varies Intragovernmental Revenue 481,083 495,583 14,500 3.01% Rents & Royalties 176,099 177,982 1,883 1.07% Miscellaneous Revenues 52,832 61,080 8,248 15.61% Insurance reimbursement higher in FY 2019 Chgs for Sery - Public Safety 920,030 910,223 (9,808) -1.07% Fines & Forfeitures 7,364 50,989 43,625 592.37% Code enforcement fees collected higher in FY 2019 Impact Fees 391 425 34 8.73% Due to the big construction projects Contributions & Donations 1,400 8,100 6,700 478.57% Park and Recreation increased donations Licenses & Permits 637,434 600,067 (37,367) -5.86% Grants - State 22,000 17,192 (4,808) -21.85% Grants differ from year to year Charges for Services 5,382,178 5,773,352 391,174 7.27% Charges for Services - Recr. 70,716 74,225 3,509 4.96% Other Financing Sources 126,316 46,038 (80,279) -63.55% Capital connect fees for big construction projects Unrestricted Investment Earning 138,165 237,944 99,779 72.22% Higher interest rate and investment balance Transfers In 740,100 0 (740,100) -100.00% Transfers differ from year to year TOTAL REVENUES 17,370,288.62 17,389,829.75 19,541.13 0.11% TOTAL REVENUES LESS TRANSFERS 16,630,188.62 17,389,829.75 759,641.13 4.57% EXPENDITURES General Fund 10,727,172 9,901,603 (825,569) -7.70% Budget spending's cut Capital Improvement Fund 546,626 19,720 (526,906) -96.39% Side walk projects in prior year Capital Projects 0 35,000 35,000 100.00% New recreation center architect Water Fund 3,888,528 4,459,727 571,199 14.69% Refuse & Recycling 360,304 360,553 249 0.07% Spmwater Utility 552,635 318,518 (234,117) -42.36% No projects were completed � cial Law Enforcement 169,871 8,446 (161,425) -95.03% No purchases were budgeted in FY 2019 TbJAL EXPENDITURES 16,245,136 15,103,567 (1,141,570) -7.03% IV T®TAL EXP LESS TRANSFERS 15,505,136 15,103,567 (401,570) -2.59% F OF REVENUES & EXPENDITURES 1,125,152 2,286,263 1,161,111 i VILLAGE OF TEQUESTA REVENUE REPORT FOR THE VILLAGE OF TEQUESTA PERIOD ENDING 07/31/2019 YTD BALANCE I YTD BALANCE DESCRIPTION 07/31/2018 07/31/2019 VARIANCE I % VARIANCE NOTES REVENUES Fund 001- GENERAL FUND General Property Taxes Sales & Use Taxes Franchise fees - gross receipt Intergovernmental Revenue Chgs for Sery - Gen Gov Intragovernmental Revenue Rents & Royalties Miscellaneous Revenues Chgs for Sery - Public Safety Fines & Forfeitures Impact Fees Licenses & Permits Grants - State Charges for Services - Recr. Contributions & Donations Unrestricted Investment Earning Other Financing Sources Total General Fund Fund 301- Capital Improvement Fund Miscellaneous Revenues Transfers In Total Capital Improvement Fund Fund 303 - Capital Projects Fund Transfers In Total Capital Projects Fund; Fund 401- Water Fund Miscellaneous Revenues Unrestricted Investment Earning Other Financing Sources Charges for Services Ta&I Water Fund !y cn F&d 402 - Refuse & Recycling Nergovernmental Revenue 6Warestricted Investment Earning Skarges for Services 4- 00 Cn 6,422,348 6,799,306 376,957 5.87% Property value increase, collected 100% 1,029,094 1,032,108 3,015 0.29% 378,903 376,319 (2,584) -0.68% 699,432 670,593 (28,838) -4.12% 82,947 57,618 (25,329) -30.54% Land dvlpmnt fees due to current projects varies 481,083 495,583 14,500 3.01% 176,099 177,982 1,883 1.07% 18,006 23,328 5,322 29.55% Insurance reimbursement higher in FY 2019 920,030 910,223 (9,808) -1.07% 7,364 50,989 43,625 592.37% Code enforcement fees higher in FY 2019 391 425 34 8.73% Due to the big construction projects 637,434 600,067 (37,367) -5.86% 22,000 17,192 (4,808) -21.85% Grants differ from year to year 70,716 74,225 3,509 4.96% 1,400 8,100 6,700 478.57% Park and Recreation increased donations 72,753 114,678 41,924 57.63% Higher interest rate and investment balance 9,965 23,597 13,632 136.80% Sale of assets differ year to year 11,029,966 11,432,335 402,369 3.65% 0 1,166 1,166 100.00% Differ from year to year and budgeted at low 540,100 0 (540,100) -100.00% Transfers differ from year to year 540,100 1,166 (538,934) -99.78% 200,000 0 (200,000) -100.00% Transfers differ from year to year 200,000 0 (200,000) -100.00% 34,826 36,586 1,761 5.06% Differ from year to year and budgeted at low 55,055 102,407 47,352 86.01% Interest rate and account balance increase 116,352 22,441 (93,911) -80.71% Capital connect charges due to the projects 4,525,637 4,866,748 341,111 7.54% Water rate increase 4,731,869 5,028,183 296,314 6.26% 1,456 683 (772) -53.05% Recycled shared revenue received only for 2 qtrs. 1,775 1,642 (133) -7.49% Interest rate and account balance increase 483,255 482,968 _- (286) -0.06% 91% of fees collected by the end of February i Total Refuse & Recycling: Fund 403 - Stormwater Utility Charges for Services Unrestricted Investment Earning Total Stormwater Utility TOTAL REVENUES - ALL FUND; TOTAL REVENUE LESS TRANSFER !y (D N W .P O 00 01 486,485 485,294 (1,191) -0.24% I D 373,286.42 423,635.96 50,350 13.49% 91% of fees collected by the end of February 8,581.88 19,216.85 10,635 123.92`Yo Interest rate and account balance increase � 381,868 442,853 60,985 15.97% 17,370,289 17,389,830 19,541 0.11% 16,630,189 17,389,830 759,641 4.57% CD Fund 301- Capital Improvement Fund Public Works Total Capital Improvement Fund Fund 303 - Capital Projects Fund Recreation Center Total Capital Projects Fund: Fund 401- Water Fund Water -Administration Water- Production Water -Distribution Renewal & Replacement Debt Service Other Nonoperating T�hI Water Fund. (a FGAd 402 - Refuse & Recycling ,Jefuse and Recycling TCl91 Refuse & Recycling: O Fwd 403 - Stormwater Utility Rtorm Water Utilities 546,626 19,720 (526,906) -96.39% Side walk projects in prior year 546,626 19,720 (526,906) -96.39% 0 35,000 35,000 100.00% New recreation center architect 0 35,000 35,000 100.00% 1,011,869 VILLAGE OF TEQUESTA EXPENDITURE REPORT FOR THE VILLAGE OF TEQUESTA PERIOD ENDING 07/31/2019 54,869 YTD BALANCE YTD BALANCE 1,432,211 % -2.75% DESCRIPTION 07/31/2018 07/31/2019 VARIANCE I VARIANCE NOTES EXPENDITURES 218.44% Renewal, replacement and capital purchase 444,017 422,788 (21,229) Fund 001- GENERAL FUND 20,071 28,019 7,948 39.60% Changes in a bank fee schedule Council 38,623 38,854 231 0.60% Manager 201,785 209,964 8,179 4.05% Human Resources 275,206 300,225 25,019 9.09% Regular Salaries & Wages increase Village Clerk 251,257 298,213 46,957 18.69% Laserfiche Avanti purchase (comp.eq purchase) Finance 321,459 337,088 15,629 4.86% Increase in personal, auditing srvcs, Khronos Legal 143,456 95,453 (48,003) -33.46% Differs from year to year, cap on $100K in 2019 Comprehensive Planning 155,090 128,011 (27,079) -17.46% Fees are based on current projects General Government 246,251 266,426 20,175 8.19% Comp equipment purchases IT 157,814 164,106 6,292 3.99% Regular salaries increase Police Department 2,671,399 2,745,872 74,473 2.79% Building & Zoning 492,516 412,559 (79,957) -16.23% Code enf is separated from Building department Code Compliance 0 79,527 79,527 100.00% Code enf is separated from Building department Fire Control 2,801,781 2,903,250 101,469 3.62% Personal increases Public Works 1,144,656 977,549 (167,108) -14.60% Sidewalk projects are budgeted in fund 301 Leisure Services 634,604 548,989 (85,616) -13.49% No capital purchases in FY 2019 Debt Service 442,017 393,346 (48,671) -11.01% No capital purchases in FY 2019 Interfund Transfers 740,100 0 (740,100) -100.00% Transfers differ from year to year Other Nonoperating 9,158 2,171 (6,987) -76.30% Changes in a bank fee schedule Total General Fund 10,727,172 9,901,603 (825,569) -7.70% Fund 301- Capital Improvement Fund Public Works Total Capital Improvement Fund Fund 303 - Capital Projects Fund Recreation Center Total Capital Projects Fund: Fund 401- Water Fund Water -Administration Water- Production Water -Distribution Renewal & Replacement Debt Service Other Nonoperating T�hI Water Fund. (a FGAd 402 - Refuse & Recycling ,Jefuse and Recycling TCl91 Refuse & Recycling: O Fwd 403 - Stormwater Utility Rtorm Water Utilities 546,626 19,720 (526,906) -96.39% Side walk projects in prior year 546,626 19,720 (526,906) -96.39% 0 35,000 35,000 100.00% New recreation center architect 0 35,000 35,000 100.00% 1,011,869 1,066,738 54,869 5.42% Personnel legal fees are now recorded 1,472,738 1,432,211 (40,527) -2.75% 705,968 765,245 59,278 8.40% Pension liability will be recorded at year end 233,865 744,726 510,861 218.44% Renewal, replacement and capital purchase 444,017 422,788 (21,229) -4.78% Differed ammort lose on funding 20,071 28,019 7,948 39.60% Changes in a bank fee schedule 3,888,528 4,459,727 571,199 14.69% 360,304 360,553 249 0.07% 360,304 360,553 249 0.07% 168,065 196,956 28,891 17.19% Drainage maintenance i �D 7 IZ L O Renewal & Replacement Total Stormwater Utility Fund 605 - Special Law Enforcement Police Total Special Law Enforcement: TOTAL EXPENDITURES - ALL FUND! TOTAL EXP LESS TRANSFERS v co CD N GJ M O h .p DD Cl 384,570 121,562 (263,008) -68.39% Less projects were completed D 552,635 318,518 (234,117) -42.36% (3 CD 7 169,871 8,446 (161,425) -95.03% Less purchases were budgeted in FY 2019 a=y 169,871 8,446 (161,425) -95.03% ear M 16,245,136 15,103,567 (1,141,570) -7.03% 15,505,036 15,103,567 (401,470) -2.59% O 08/15/2019 04:34 PM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 1/28 D User: tracanati DB: Tequesta PERIOD ENDING 07/31/2019 2018-19 YTD BALANCE ORIGINAL 2018-19 07/31/2019 ENCUMBERED UNENCUMBERED % BDIV GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE UshQ Fund 001 - GENERAL FUND Revenues 3 Dept 000 - GENERAL General Property Taxes 001-000-311.000 Ad Valorem Taxes - Current 6,800,600.00 6,800,600.00 6,798,211.22 0.00 2,388.78 99.90 001-000-311.100 Ad Valorem Taxes -Del 0.00 0.00 1,094.59 0.00 (1,094.59) 100.00 General Property Taxes 6,800,600.00 6,800,600.00 6,799,305.81 0.00 1,294.19 99.98 Sales & Use Taxes 001-000-312.510 Fire Insurance Prem Tax 155,000.00 155,000.00 0.00 0.00 155,000.00 0.00 001-000-312.610 Local Disc. Infrastructure Su 439,900.00 439,900.00 285,776.90 0.00 154,123.10 64.96 001-000-314.100 Utility Tax -Electricity 528,000.00 528,000.00 401,780.23 0.00 126,219.77 76.09 001-000-314.400 Utility Tax - Natural Gas 0.00 0.00 221.61 0.00 (221.61) 100.00 001-000-314.800 Utility Tax -Propane 30,000.00 30,000.00 24,609.65 0.00 5,390.35 82.03 001-000-315.000 Comm.Services Tax (CST) 309,000.00 309,000.00 227,749.65 0.00 81,250.35 73.71 001-000-321.000 Local Business Tax 86,000.00 86,000.00 85,334.26 0.00 665.74 99.23 001-000-321.010 Local Business Tax - County 8,000.00 8,000.00 6,635.98 0.00 1,364.02 82.95 Sales & Use Taxes 1,555,900.00 1,555,900.00 1,032,108.28 0.00 523,791.72 66.34 Franchise fees - gross receipt 001-000-313.100 Fran Fees -Electric 460,000.00 460,000.00 376,318.93 0.00 83,681.07 81.81 Franchise fees - gross receipt 460,000.00 460,000.00 376,318.93 0.00 83,681.07 81.81 Intergovernmental Revenue 001-000-335.120 Municipal Revenue Sharing Pro 187,600.00 187,600.00 151,114.81 0.00 36,485.19 80.55 001-000-335.150 Alcoholic Beverage Licenses 6,000.00 6,000.00 10,026.53 0.00 (4,026.53) 167.11 001-000-335.180 Loc Gov 1/2 Cent Sales Tax Pr 464,400.00 464,400.00 358,696.43 0.00 105,703.57 77.24 001-000-338.101 Local Gas Tax -6 Cent 137,100.00 137,100.00 101,039.43 0.00 36,060.57 73.70 001-000-338.102 Local Gas Tax 1-5 Cent 63,200.00 63,200.00 46,934.63 0.00 16,265.37 74.26 Intergovernmental Revenue 858,300.00 858,300.00 667,811.83 0.00 190,488.17 77.81 Chgs for Sery - Gen Gov 001-000-341.101 Certification/Copy Fees 14,000.00 14,000.00 25,103.35 0.00 (11,103.35) 179.31 001-000-341.103 Election qualifying fees 0.00 0.00 90.00 0.00 (90.00) 100.00 001-000-341.105 Admin fees from other Gov'ts 1,500.00 1,500.00 1,824.90 0.00 (324.90) 121.66 Chgs for Sery - Gen Gov 15,500.00 15,500.00 27,018.25 0.00 (11,518.25) 174.31 Intragovernmental Revenue 001-000-341.401 ADMIN MGMT FEES -WATER 572,900.00 572,900.00 477,416.60 0.00 95,483.40 83.33 001-000-341.402 Admin Mgmt Fee -Ref & Recyclin 8,100.00 8,100.00 6,750.00 0.00 1,350.00 83.33 001-000-341.403 Admin Mgmt Fees - Storm Water 13,700.00 13,700.00 11,416.60 0.00 2,283.40 83.33 Intragovernmental Revenue 594,700.00 594,700.00 495,583.20 0.00 99,116.80 83.33 is & Royalties -000-362.110 Lease - Sprint 41,800.00 41,800.00 34,879.20 0.00 6,920.80 83.44 Qp1-000-362.112 Lease -T -Mobile 61,800.00 61,800.00 51,432.01 0.00 10,367.99 83.22 OMI -000-362.116 Lease - AT&T 30,000.00 30,000.00 25,000.00 0.00 5,000.00 83.33 UQ -000-362.117 Verizon -901 Old Dixie 42,300.00 42,300.00 35,095.80 0.00 7,204.20 82.97 -000-362.118 Verizon -136 Bridge Rd 31,900.00 31,900.00 26,534.10 0.00 5,365.90 83.18 Pants & Royalties 207,800.00 207,800.00 172,941.11 0.00 34,858.89 83.22 b4 cellaneous Revenues = -000-369.000 Other Miscellaneous Revenue 0.00 0.00 5,689.89 0.00 (5,689.89) 100.00 08/15/2019 04:34 PM User: tracanati DB: Tequesta GL NUMBER DESCRIPTION Fund 001 - GENERAL FUND Revenues 001-000-369.100 Insurance Reimbursement Miscellaneous Revenues Total Dept 000 - GENERAL Dept 150 - Comprehensive Planning Chgs for Sery - Gen Gov 001-150-341.150 Land Development Fees Chgs for Sery - Gen Gov Total Dept 150 - Comprehensive Planning Dept 171 - Police Miscellaneous Revenues 001-171-359.100 Forfeitures/Confiscations 001-171-369.000 Other Miscellaneous Revenue Miscellaneous Revenues Chgs for Sery - Public Safety 001-171-342.110 PBC - Marine law enforce. ser Chgs for Sery - Public Safety Fines & Forfeitures 001-171-351.100 Court Fines 001-171-354.101 Parking Tickets Fines & Forfeitures Impact Fees 001-171-362.221 Police Impact Fees Impact Fees Total Dept 171 - Police Dept 180 - Building & Zoning Miscellaneous Revenues 0$1-180-369.000 Other Miscellaneous Revenue 2scellaneous Revenues (D Wes & Forfeitures 0=-180-354.102 Code Enf Fines & Court Costs Ernes & Forfeitures C-y,J enses & Permits -180-322.000 Building Permit Fees REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 2/28 D PERIOD ENDING 07/31/2019 2018-19 YTD BALANCE ORIGINAL 2018-19 07/31/2019 ENCUMBERED UNENCUMBERED $ BD& BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE US$p 3 0.00 0.00 13,211.20 0.00 (13,211.20) 100.0 0.00 0.00 18,901.09 0.00 (18,901.09) 100.00 10,492,800.00 10,492,800.00 9,589,988.50 0.00 902,811.50 91.40 60,000.00 60,000.00 30,600.00 0.00 29,400.00 51.00 60,000.00 60,000.00 30,600.00 0.00 29,400.00 51.00 60,000.00 60,000.00 30,600.00 0.00 29,400.00 51.00 0.00 0.00 2,269.00 0.00 (2,269.00) 100.00 0.00 0.00 710.00 0.00 (710.00) 100.00 0.00 0.00 2,979.00 0.00 (2,979.00) 100.00 16,600.00 22,575.00 22,635.00 0.00 (60.00) 100.27 16,600.00 22,575.00 22,635.00 0.00 (60.00) 100.27 5,500.00 5,500.00 5,314.04 0.00 185.96 96.62 500.00 500.00 505.00 0.00 (5.00) 101.00 6,000.00 6,000.00 5,819.04 0.00 180.96 96.98 0.00 0.00 62.98 0.00 (62.98) 100.00 0.00 0.00 62.98 0.00 (62.98) 100.00 22,600.00 28,575.00 31,496.02 0.00 (2,921.02) 110.22 0.00 0.00 1.81 0.00 (1.81) 100.00 0.00 0.00 1.81 0.00 (1.81) 100.00 10,000.00 10,000.00 0.00 0.00 10,000.00 0.00 10,000.00 10,000.00 0.00 0.00 10,000.00 0.00 625,000.00 625,000.00 592,973.54 0.00 32,026.46 94.88 08/15/2019 04:34 PM User: tracanati DB: Tequesta GL NUMBER DESCRIPTION Fund 001 - GENERAL FUND Revenues 001-180-329.010 Contractor Reg. - County 001-180-329.110 PARTIAL AND RE -INSPECTION Licenses & Permits Total Dept 180 - Building & Zoning Dept 181 - Code Compliance Fines & Forfeitures 001-181-354.102 Code Enf Fines & Court Cost Fines & Forfeitures Total Dept 181 - Code Compliance Dept 192 - Fire Control Intergovernmental Revenue 001-192-335.201 Fire Incentive Pay Intergovernmental Revenue Miscellaneous Revenues 001-192-365.102 Fire Dept Sales 001-192-369.000 Other Miscellaneous Revenue Miscellaneous Revenues Chgs for Sery - Public Safety 001-192-342.192 Fire - Extra Duty 001-192-342.201 Fire Plan Review Fees 001-192-342.202 Fire Inspections 001-192-342.401 Emergency Service-JIC 001-192-342.402 Fire Rescue -CPR Program 001-192-342.410 Emergency Svc- PBC Fire Res 001-192-342.600 EMS Transportation Fees Chgs for Sery - Public Safety Impact Fees 643,000.00 001-192-362.222 Fire Impact Fees Impact Fees 93.32 nts - State -192-337.201 Local Government Grant PBC Wants - State N GWtributions & Donations 6&-192-366. 100 Contrib & Donations & Spons (2ptributions & Donations OD 01 REVENUE AND EXPENDITURE REPORT FOR VILLAGE PERIOD ENDING 07/31/2019 2018-19 ORIGINAL 2018-19 BUDGET AMENDED BUDGET Costs cu or OF TEQUESTA YTD BALANCE 07/31/2019 NORM (ABNORM) ENCUMBERED YEAR-TO-DATE Page: 3/28 UNENCUMBERED BALANCE D a % BEIV USFQ 0.00 0.00 1,439.72 0.00 (1,439.72) 100.U,� 8,000.00 8,000.00 5,653.97 0.00 2,346.03 70. 633,000.00 633,000.00 600,067.23 0.00 32,932.77 94. 643,000.00 643,000.00 600,069.04 0.00 42,930.96 93.32 0.00 40,000.00 45,170.23 0.00 (5,170.23) 112.93 0.00 40,000.00 45,170.23 0.00 (5,170.23) 112.93 0.00 40,000.00 45,170.23 0.00 (5,170.23) 112.93 6,700.00 6,700.00 2,781.61 0.00 3,918.39 41.52 6,700.00 6,700.00 2,781.61 0.00 3,918.39 41.52 150.00 150.00 89.89 0.00 60.11 59.93 0.00 0.00 863.87 0.00 (863.87) 100.00 150.00 150.00 953.76 0.00 (803.76) 635.84 2,500.00 2,500.00 2,821.45 0.00 (321.45) 112.86 25,000.00 25,000.00 16,420.08 0.00 8,579.92 65.68 25,000.00 25,000.00 23,318.57 0.00 1,681.43 93.27 416,000.00 416,000.00 312,000.00 0.00 104,000.00 75.00 250.00 250.00 415.00 0.00 (165.00) 166.00 219,700.00 289,700.00 289,705.64 0.00 (5.64) 100.00 329,000.00 329,000.00 242,906.93 0.00 86,093.07 73.83 1,017,450.00 1,087,450.00 887,587.67 0.00 199,862.33 81.62 0.00 0.00 86.74 0.00 (86.74) 100.00 0.00 0.00 86.74 0.00 (86.74) 100.00 0.00 17,192.00 17,192.00 0.00 0.00 100.00 0.00 17,192.00 17,192.00 0.00 0.00 100.00 0.00 0.00 200.00 0.00 (200.00) 100.00 0.00 0.00 200.00 0.00 (200.00) 100.00 08/15/2019 04:34 PM R User: tracanati DB: Tequesta GL NUMBER DESCRIPTION Fund 001 - GENERAL FUND Revenues Total Dept 192 - Fire Control Dept 231 - Leisure Services Rents & Royalties 001-231-362.100 Rental - Facilities Rents & Royalties Miscellaneous Revenues 001-231-365.110 Concession Sales 001-231-369.000 Other Miscellaneous Revenue Miscellaneous Revenues Impact Fees 001-231-363.271 Parks and Rec Impact Fees Impact Fees Contributions & Donations 001-231-366.100 Contrib & Donations & Sponsor Contributions & Donations Charges for Services - Recr. 001-231-347.100 Tequesta Fest 001-231-347.190 Special Events - Other 001-231-347.201 Winter/Summer Camp Fees 001-231-347.205 Recreation Programs Fees Charges for Services - Recr. Total Dept 231 - Leisure Services Dept 910 - Other Financing Sources & Uses Other Financing Sources 001-910-383.100 Capital Lease at Inception Other Financing Sources Total Dept 910 - Other Financing Sources & Uses IDe t 950 - Other Nonoperating er Financing Sources 1-950-364.100 DISPOSITION/SALE OF ASSETS Aher Financing Sources N =restricted Investment Earnin (01-950-361.100 Interest/Investment Earnings %1- 950-361.101 PBC Tax Col -Interest on Dep ia'estricted Investment Earnin Cn EVENUE AND EXPENDITURE REPORT FOR VILLAGE PERIOD ENDING 07/31/2019 2018-19 ORIGINAL 2018-19 BUDGET AMENDED BUDGET OF TEQUESTA YTD BALANCE 07/31/2019 NORM (ABNORM) ENCUMBERED YEAR-TO-DATE Page: 4/28 UNENCUMBERED BALANCE D BD& U!zz 3 1,024,300.00 1,111,492.00 908,801.78 0.00 202,690.22 81.74 O 7,000.00 7,000.00 5,041.23 0.00 1,958.77 72.02 7,000.00 7,000.00 5,041.23 0.00 1,958.77 72.02 800.00 800.00 452.33 0.00 347.67 56.54 0.00 0.00 40.00 0.00 (40.00) 100.00 800.00 800.00 492.33 0.00 307.67 61.54 0.00 0.00 2.75.60 0.00 (275.60) 100.00 0.00 0.00 275.60 0.00 (275.60) 100.00 1,500.00 1,500.00 7,900.00 0.00 (6,400.00) 526.67 1,500.00 1,500.00 7,900.00 0.00 (6,400.00) 526.67 12,000.00 12,000.00 9,585.07 0.00 2,414.93 79.88 5,300.00 5,300.00 3,871.03 0.00 1,428.97 73.04 33,750.00 33,750.00 47,462.50 0.00 (13,712.50) 140.63 15,000.00 15,000.00 13,306.64 0.00 1,693.36 88.71 66,050.00 66,050.00 74,225.24 0.00 (8,175.24) 112.38 75,350.00 75,350.00 87,934.40 0.00 (12,584.40) 116.70 0.00 31,100.00 0.00 0.00 31,100.00 0.00 0.00 31,100.00 0.00 0.00 31,100.00 0.00 0.00 31,100.00 0.00 0.00 31,100.00 0.00 0.00 0.00 23,597.19 0.00 (23,597.19) 100.00 0.00 0.00 23,597.19 0.00 (23,597.19) 100.00 80,000.00 80,000.00 113,257.00 0.00 (33,257.00) 141.57 0.00 0.00 1,420.59 0.00 (1,420.59) 100.00 80,000.00 80,000.00 114,677.59 0.00 (34,677.59) 143.35 08/15/2019 04:34 PM User: tracanati DB: Tequesta GL NUMBER DESCRIPTION Fund 001 - GENERAL FUND Revenues Total Dept 950 - Other Nonoperating Dept 990 - Other/Reserve/Contingency Other Financing Sources 001-990-399.999 Appropriate Fund Balance Other Financing Sources Total Dept 990 - Other/Reserve/Contingency TOTAL REVENUES Expenditures Dept 100 - Council Operating Expenditures/Expense REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA PERIOD ENDING 07/31/2019 2018-19 YTD BALANCE ORIGINAL 2018-19 07/31/2019 BUDGET AMENDED BUDGET NORM (ABNORM) 001-100-531.311 COUNCIL FEES - SEAT 1 - ARENA 001-100-531.313 COUNCIL FEES - SEAT 4 - STONE 001-100-531.314 COUNCIL FEES - SEAT 5 - JOHNSON 001-100-531.316 COUNCIL FEES - SEAT 3 - BRANDON 001-100-531.317 COUNCIL FEES - SEAT 2 - BRENNAN 001-100-540.301 COUNCIL EXPENSES - SEAT 1 - ARENA 001-100-540.304 COUNCIL EXPENSES - SEAT 5 - JOHNSON 001-100-540.306 COUNCIL EXPENSES - SEAT 3 - BRANDON 001-100-540.307 COUNCIL EXPENSES - SEAT 2 - BRENNAN 001-100-540.308 COUNCIL EXPENSES - SEAT 4 - STONE 001-100-549.300 OTHER MISC CHGS & OBLIGATIONS 001-100-549.350 VOLUNTEER APPRECIATION 0.00 001-100-554.300 BOOKS, PUBL, SUBS & MEMBERSHI Operating Expenditures/Expense Total Dept 100 - Council Dept 110 - Manager Operating Expenditures/Expense 001-110-540.300 Travel & Per Diem 001-110-546.320 Computer system maint & suppl 001-110-549.300 Other Misc Chgs & Obligations 001-110-549.401 Recruitment expenses 001-110-554.300 Books, Publ, Subs & Membershi QU-110-554.301 Personnel Training 7,600.00 7,600.00 derating Expenditures/Expense Q UNENCUMBERED sonal Services -110-512.100 Regular Salaries & wages 1-110-515.103 Bonus Pay Plan -110-515.108 Auto Allowance 01.1-110-515.125 Other Allowances (�-110-516.100 Compensated Absences 60,000.00 807,150.00 807,150.00 80,000.00 317,036.00 317,036.00 807,150.00 317,036.00 138,274.78 0.00 0.00 0.00 13,205,200.00 12,879,353.00 11,432,334.75 7,600.00 Page: 5/28 D 0.00 1,307.68 to 7,600.00 7,600.00 (D 0.00 1,307.68 82.79 7,600.00 7,600.00 6,292.32 ENCUMBERED UNENCUMBERED o BCW YEAR-TO-DATE BALANCE US$,p 0.00 1,307.68 82.79 7,600.00 7,600.00 6,292.32 0.00 (58,274.78) 172.8 0.00 317,036.00 0.00 0.00 317,036.00 0.00 0.00 317,036.00 3,000.00 0.00 0.00 1,447,018.25 88.76 0.00 7,600.00 7,600.00 6,292.32 0.00 1,307.68 82.79 7,600.00 7,600.00 6,292.32 0.00 1,307.68 82.79 7,600.00 7,600.00 6,292.32 0.00 1,307.68 82.79 7,600.00 7,600.00 6,292.32 0.00 1,307.68 82.79 7,600.00 7,600.00 6,292.32 0.00 1,307.68 82.79 3,000.00 3,000.00 891.01 0.00 2,108.99 29.70 3,000.00 3,000.00 639.03 0.00 2,360.97 21.30 3,000.00 3,000.00 109.00 0.00 2,891.00 3.63 3,000.00 3,000.00 2,269.30 0.00 730.70 75.64 3,000.00 3,000.00 146.79 0.00 2,853.21 4.89 700.00 700.00 144.53 0.00 555.47 20.65 1,400.00 1,400.00 56.20 0.00 1,343.80 4.01 3,700.00 3,700.00 3,137.00 0.00 563.00 84.78 58,800.00 58,800.00 38,854.46 0.00 19,945.54 66.08 58,800.00 58,800.00 38,854.46 0.00 19,945.54 66.08 1,000.00 1,000.00 0.00 0.00 1,000.00 0.00 2,000.00 2,000.00 2,491.52 0.00 (491.52) 124.58 250.00 250.00 36.79 0.00 213.21 14.72 0.00 10,000.00 3,078.43 0.00 6,921.57 30.78 3,700.00 2,000.00 939.99 0.00 1,060.01 47.00 1,000.00 1,000.00 75.00 0.00 925.00 7.50 7,950.00 16,250.00 6,621.73 0.00 9,628.27 40.75 323,300.00 198,050.00 158,961.99 0.00 39,088.01 80.26 1,250.00 1,250.00 1,250.00 0.00 0.00 100.00 7,500.00 3,750.00 300.00 0.00 3,450.00 8.00 3,000.00 1,500.00 0.00 0.00 1,500.00 0.00 2,500.00 2,500.00 7,564.18 0.00 (5,064.18) 302.57 08/15/2019 04:34 PM User: tracanati DB: Tequesta GL NUMBER DESCRIPTION Fund 001 - GENERAL FUND Expenditures Employee Assistance Program 001-110-521.101 FICA Taxes 001-110-521.102 Medicare Taxes 001-110-522.102 VOT Pension Contributions 001-110-523.101 Life/Health Insurance 001-110-524.100 Workers' Comp Insurance 001-110-526.104 ICMA-Def Comp Plan Personal Services Other Misc Chgs & Obligations Capital Outlay Recruitment expenses 001-110-664.601 Computer Equipment Capital Outlay Books, Publ, Subs & Membershi Total Dept 110 - Manager Dept 111 - Human Resources Operating Expenditures/Expense REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA PERIOD ENDING 07/31/2019 2018-19 YTD BALANCE ORIGINAL 2018-19 07/31/2019 BUDGET AMENDED BUDGET NORM (ABNORM) 001-111-526.101 Employee Recognition Program 001-111-526.102 Employee Assistance Program 001-111-526.103 Education Reimbursement Prgm 001-111-534.300 Other Contractual Services 001-111-540.300 Travel & Per Diem 001-111-541.300 Communication Services 001-111-546.320 Computer system maint & suppl 001-111-547.300 Printing & Binding 001-111-549.300 Other Misc Chgs & Obligations 001-111-549.401 Recruitment expenses 001-111-552.302 Small Tools and Equipment 001-111-554.300 Books, Publ, Subs & Membershi 001-111-554.301 Personnel Training 001-111-554.310 Employee Development Operating Expenditures/Expense Personal Services 30,100.00 001-111-512.100 Regular Salaries & Wages 001-111-515.103 Bonus Pay Plan 001-111-515.107 Part-time Salaries 001-111-516.100 Compensated Absences 001-111-521.101 FICA Taxes 001-111-521.102 Medicare Taxes 001-111-522.102 VOT Pension Contributions 001-111-523.101 Life/Health Insurance 001-111-523.105 HSA - Health Savings Account 00 -111-524.100 Workers' Comp Insurance sMrsonal Services 54.21 (D N 0.00 al Dept 111 - Human Resources O 209,963.93 -++ t 120 - Village Clerk rating Expenditures/Expense Page: 6/28 D CQ CD ENCUMBERED UNENCUMBERED % BDjW YEAR-TO-DATE BALANCE US" 13,000.00 9,600.00 8,919.34 0.00 680.66 92. 4,900.00 3,025.00 2,522.56 0.00 502.44 83.3,$1 36,400.00 22,300.00 7,341.57 0.00 14,958.43 32.90 41,300.00 27,850.00 11,164.55 0.00 16,685.45 40.03 500.00 650.00 649.84 0.00 0.16 99.98 30,100.00 4,200.00 3,022.38 0.00 1,177.62 71.96 463,750.00 274,675.00 201,696.41 0.00 72,978.59 73.43 0.00 1,700.00 1,645.79 0.00 54.21 96.81 0.00 1,700.00 1,645.79 0.00 54.21 96.81 292,625.00 0.00 71.75 471,700.00 209,963.93 82,661.07 14,000.00 14,000.00 9,003.81 0.00 4,996.19 64.31 12,100.00 12,100.00 10,471.70 0.00 1,628.30 86.54 3,000.00 3,000.00 1,827.00 0.00 1,173.00 60.90 10,500.00 900.00 426.14 0.00 473.86 47.35 5,000.00 5,000.00 3,632.32 0.00 1,367.68 72.65 0.00 1,100.00 988.94 0.00 111.06 89.90 16,000.00 16,000.00 15,084.74 0.00 915.26 94.28 1,500.00 1,500.00 1,113.78 0.00 386.22 74.25 600.00 600.00 292.60 0.00 307.40 48.77 500.00 500.00 223.60 0.00 276.40 44.72 500.00 500.00 0.00 0.00 500.00 0.00 1,500.00 1,500.00 676.00 0.00 824.00 45.07 5,000.00 5,000.00 3,160.00 0.00 1,840.00 63.20 10,000.00 10,000.00 5,847.60 0.00 4,152.40 58.48 80,200.00 71,700.00 52,748.23 0.00 18,951.77 73.57 221,700.00 212,500.00 171,822.35 0.00 40,677.65 80.86 1,900.00 2,025.00 2,025.00 0.00 0.00 100.00 6,500.00 15,000.00 11,327.96 0.00 3,672.04 75.52 3,000.00 2,780.00 2,777.24 0.00 2.76 99.90 14,500.00 14,500.00 10,469.41 0.00 4,030.59 72.20 3,400.00 3,400.00 2,654.33 0.00 745.67 78.07 24,900.00 24,900.00 19,284.09 0.00 5,615.91 77.45 34,400.00 29,300.00 24,777.05 0.00 4,522.95 84.56 0.00 2,160.00 1,800.00 0.00 360.00 83.33 500.00 540.00 539.81 0.00 0.19 99.96 310,800.00 307,105.00 247,477.24 0.00 59,627.76 80.58 378,805.00 79.26 391,000.00 300,225.47 0.00 78,579.53 08/15/2019 04:34 User: tracanati DB: Tequesta GL NUMBER PM REVENUE AND DESCRIPTION EXPENDITURE REPORT FOR VILLAGE PERIOD ENDING 07/31/2019 2018-19 ORIGINAL 2018-1907/31/2019 BUDGET AMENDED BUDGET OF TEQUESTA YTD BALANCE NORM (ABNORM) ENCUMBERED YEAR-TO-DATE Page: 7/28 UNENCUMBERED BALANCE 3 % BDff USLD Fund 001 - GENERAL FUND Expenditures 3 001-120-526.103 Education Reimbursement Prgm 3,000.00 3,000.00 3,000.00 0.00 0.00 100.0 001-120-531.303 Codification Services 6,100.00 6,100.00 5,358.26 0.00 741.74 87. 001-120-534.301 Election Expense 18,800.00 17,214.00 16,928.06 0.00 285.94 98.30 001-120-534.302 Legal Advertising 13,800.00 13,800.00 6,020.80 0.00 7,779.20 43.63 001-120-540.300 Travel & Per Diem 4,500.00 4,150.00 1,836.33 0.00 2,313.67 44.25 001-120-541.300 Communication Services 2,700.00 2,700.00 965.74 0.00 1,734.26 35.77 001-120-546.320 Computer system maint & suppl 11,600.00 14,476.00 10,543.36 0.00 3,932.64 72.83 001-120-548.110 Marketing and Public Relation 3,000.00 1,710.00 1,656.24 0.00 53.76 96.86 001-120-549.100 Miscellaneous Archival 2,500.00 2,500.00 1,030.06 0.00 1,469.94 41.20 001-120-549.300 Other Misc Chgs & Obligations 2,800.00 2,800.00 516.64 0.00 2,283.36 18.45 001-120-552.302 Small Tools and Equipment 500.00 500.00 167.99 0.00 332.01 33.60 001-120-554.300 Books, Publ, Subs & Membershi 1,000.00 1,000.00 1,000.02 0.00 (0.02) 100.00 001-120-554.301 Personnel Training 2,100.00 2,450.00 1,710.00 0.00 740.00 69.80 Operating Expenditures/Expense 72,400.00 72,400.00 50,733.50 0.00 21,666.50 70.07 Personal Services 001-120-512.100 Regular Salaries & Wages 185,100.00 192,795.00 153,039.26 0.00 39,755.74 79.38 001-120-515.103 Bonus Pay Plan 2,150.00 2,150.00 2,125.00 0.00 25.00 98.84 001-120-515.108 Auto Allowance 3,000.00 3,000.00 2,538.36 0.00 461.64 84.61 001-120-521.101 FICA Taxes 11,500.00 11,900.00 9,178.98 0.00 2,721.02 77.13 001-120-521.102 Medicare Taxes 2,700.00 2,800.00 2,146.65 0.00 653.35 76.67 001-120-522.102 VOT Pension Contributions 20,800.00 21,550.00 17,186.37 0.00 4,363.63 79.75 001-120-523.101 Life/Health Insurance 40,200.00 43,450.00 35,648.47 0.00 7,801.53 82.04 001-120-524.100 Workers' Comp Insurance 500.00 500.00 475.31 0.00 24.66 95.07 Personal Services 265,950.00 278,145.00 222,338.43 0.00 55,806.57 79.94 Capital Outlay 001-120-664.601 Computer Equipment 26,000.00 26,000.00 25,141.16 0.00 858.84 96.70 Capital Outlay 26,000.00 26,000.00 25,141.16 0.00 858.84 96.70 Total Dept 120 - Village Clerk 364,350.00 376,545.00 298,213.09 0.00 78,331.91 79.20 Dept 130 - Finance Operating Expenditures/Expense 001-130-532.300 Accounting & Auditing Service 26,800.00 28,305.00 28,305.00 0.00 0.00 100.00 001-130-534.300 Other Contractual Services 0.00 0.00 3,600.00 0.00 (3,600.00) 100.00 001-130-540.300 Travel & Per Diem 3,900.00 3,900.00 673.42 0.00 3,226.58 17.27 001-130-544.301 Operating Leases 2,300.00 2,400.00 1,441.55 533.19 425.26 82.28 001-130-546.301 Office Equip/Repair & Maint 400.00 900.00 419.18 0.00 480.82 46.58 001-130-546.320 Computer system maint & suppl 14,000.00 14,000.00 11,286.39 0.00 2,713.61 80.62 001-130-547.300 Printing & Binding 3,000.00 3,000.00 1,610.18 0.00 1,389.82 53.67 001-130-549.300 Other Misc Chgs & Obligations 1,000.00 900.00 286.00 0.00 614.00 31.78 02 -130-551.300 Office Supplies & Equipment 4,000.00 2,595.00 583.70 0.00 2,011.30 22.49 1-130-554.300 Books, Publ, Subs & Membershi 1,600.00 1,600.00 1,403.90 0.00 196.10 87.74 1-130-554.301 Personnel Training 3,000.00 3,000.00 2,422.00 0.00 578.00 80.73 ftD�rating Expenditures/Expense 60,000.00 60,600.00 52,031.32 533.19 8,035.49 86.74 W P(5rsonal Services 0V -130-512.100 Regular Salaries & Wages 257,300.00 249,073.00 198,757.48 0.00 50,315.52 79.80 130-515.103 Bonus Pay Plan 2,150.00 2,150.00 2,125.02 0.00 24.98 98.84 -130-515.120 Cell phone allowance 600.00 600.00 438.74 0.00 161.26 73.12 08/15/2019 04:34 PM User: tracanati DB: Tequesta GL NUMBER DESCRIPTION Fund 001 - GENERAL FUND Expenditures Mapping Services 001-130-516.100 Compensated Absences 001-130-521.101 FICA Taxes 001-130-521.102 Medicare Taxes 001-130-522.102 VOT Pension Contributions 001-130-523.101 Life/Health Insurance 001-130-524.100 Workers' Comp Insurance Personal Services Other Misc Chgs & Obligations Total Dept 130 - Finance Dept 140 - Legal Operating Expenditures/Expense 001-140-531.301 Legal Services 001-140-531.308 Legal fees - Personnel Operating Expenditures/Expense Total Dept 140 - Legal Dept 150 - Comprehensive Planning Operating Expenditures/Expense REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA PERIOD ENDING 07/31/2019 2018-19 YTD BALANCE ORIGINAL 2018-19 07/31/2019 ENCUMBERED BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE 001-150-531.301 Legal Services 001-150-531.321 Mapping Services 001-150-531.322 Misc Planning Service 001-150-531.332 Planning and Zoning Board 001-150-534.300 Other Contractual Services 001-150-534.302 Legal Advertising 001-150-546.320 Computer system maint & suppl 001-150-547.300 Printing & Binding 001-150-549.300 Other Misc Chgs & Obligations 001-150-551.300 Office Supplies & Equipment 001-150-554.300 Books, Publ, Subs & Membershi Operating Expenditures/Expense Total Dept 150 - Comprehensive Planning Dept 160 - General Government Operating Expenditures/Expense 160-531.302 Engineering Services qT -160-534.300 Other Contractual Services 1-160-534.303 Special Events (Xp1-160-541.300 Communication Services QQ01-160-541.301 Postage 000-1-160-541.305 Website Maintenance Oe1-160-543.300 Utility Services 0_1-160-544.301 Operating Leases 0 1-160-545.300 Insurance -160-546.301 Office Equip/Repair & Maint O;OL-160-546.302 Vehicle Repair & Maintenance 2,500.00 16,000.00 3,800.00 28,900.00 47,900.00 600.00 359,750.00 419,750.00 100,000.00 80,000.00 180,000.00 180,000.00 15,000.00 2,500.00 129,000.00 1,000.00 10,000.00 5,000.00 5,200.00 3,100.00 500.00 750.00 900.00 172,950.00 172,950.00 10,227.00 7,725.89 16,000.00 11,961.19 3,800.00 2,820.12 28,900.00 22,286.59 47,750.00 38,310.41 650.00 630.77 359,150.00 285,056.21 419,750.00 337,087.53 100,000.00 75,206.80 80,000.00 20,246.41 180,000.00 95,453.21 180,000.00 95,453.21 15,000.00 9,712.50 2,500.00 175.00 129,000.00 96,560.00 1,000.00 0.00 10,000.00 16,792.60 5,000.00 2,734.80 5,200.00 227.77 3,100.00 502.78 500.00 50.00 750.00 355.47 900.00 900.00 172,950.00 128,010.92 172,950.00 128,010.92 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Page: 8/28 D 80.43 0.00 24,793.20 75.21 0.00 59,753.59 25.31 a UNENCUMBERED % BDA' BALANCE USLD 53.03 0.00 2,501.11 75.5a 4,038.81 74.7 979.88 74.20 6,613.41 77.12 9,439.59 80.23 19.23 97.04 74,093.79 79.37 533.19 82,129.28 80.43 0.00 24,793.20 75.21 0.00 59,753.59 25.31 0.00 84,546.79 53.03 15,000.00 84,546.79 53.03 0.00 0.00 5,287.50 64.75 0.00 2,325.00 7.00 32,440.00 0.00 100.00 0.00 1,000.00 0.00 0.00 (6,792.60) 167.93 0.00 2,265.20 54.70 0.00 4,972.23 4.38 0.00 2,597.22 16.22 0.00 450.00 10.00 0.00 394.53 47.40 0.00 0.00 100.00 32,440.00 12,499.08 92.77 32,440.00 12,499.08 92.77 0.00 1,333.00 1,332.50 0.00 0.50 99.96 20,000.00 25,496.00 8,945.00 0.00 16,551.00 35.08 15,000.00 3,994.00 4,246.54 0.00 (252.54) 106.32 8,600.00 7,600.00 6,040.17 0.00 1,559.83 79.48 4,300.00 3,300.00 1,864.68 0.00 1,435.32 56.51 7,600.00 7,600.00 7,049.32 0.00 550.68 92.75 19,000.00 19,100.00 15,457.25 0.00 3,642.75 80.93 48,100.00 48,100.00 43,288.76 3,568.00 1,243.24 97.42 94,200.00 94,350.00 94,254.39 0.00 95.61 99.90 3,000.00 3,320.00 2,447.43 0.00 872.57 73.72 500.00 0.00 0.00 0.00 0.00 0.00 08/15/2019 04:34 PM User: tracanati DB: Tequesta GL NUMBER DESCRIPTION REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 9/28 D Fund 001 - GENERAL FUND Expenditures Travel & Per Diem 001-160-546.320 Computer system maint & suppl 001-160-547.300 Printing & Binding 001-160-549.300 Other Misc Chgs & Obligations 001-160-549.302 Village Newsletter 001-160-549.304 Licenses, Fees & Permits 001-160-551.300 Office Supplies & Equipment 001-160-552.301 Gas & Oil 001-160-552.302 Small Tools and Equipment 001-160-554.300 Books, Publ, Subs & Membershi Operating Expenditures/Expense Capital Outlay Life/Health Insurance 001-160-664.600 Mach/Equipment 001-160-664.601 Computer Equipment 001-160-664.607 Equipment - Tech Capital Outlay 5,033.74 Total Dept 160 - General Government Dept 161 - IT Operating Expenditures/Expense 001-161-526.103 Education Reimbursement Prgm 001-161-540.300 Travel & Per Diem 001-161-552.160 IT Operating Supplies 001-161-554.301 Personnel Training Operating Expenditures/Expense Personal Services 175-541.301 001-161-512.100 Regular Salaries & Wages 001-161-515.103 Bonus Pay Plan 001-161-515.120 Cell phone allowance 001-161-521.101 FICA Taxes 001-161-521.102 Medicare Taxes 001-161-522.102 VOT Pension Contributions 001-161-523.101 Life/Health Insurance 001-161-524.100 Workers' Comp Insurance Personal Services 335.88 Total Dept 161 - IT Mipt 175 - Police Department Berating Expenditures/Expense - Employee Recognition Program V -175-526.103 Education Reimbursement Prgm 01-175-526.105 Employee Physical/Psycologica (61-175-540.300 Travel & Per Diem 011-175-541.300 Communication Services 175-541.301 Postage -175-543.300 Utility Services PERIOD ENDING 07/31/2019 2018-19 YTD BALANCE ORIGINAL2018-19 07/31/2019 ENCUMBERED UNENCUMBERED % BEW BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USLQ 28,100.00 28,100.00 24,432.05 0.00 3,667.95 86. 2,000.00 2,500.00 2,564.33 0.00 (64.33) 102.5 10,000.00 13,673.00 10,568.48 0.00 3,104.52 77.20 16,500.00 16,500.00 10,733.71 0.00 5,766.29 65.05 2,800.00 2,304.00 1,968.12 0.00 335.88 85.42 4,000.00 6,500.00 5,033.74 0.00 1,466.26 77.44 300.00 300.00 0.00 0.00 300.00 0.00 1,000.00 1,000.00 68.82 0.00 931.18 6.88 2,900.00 2,976.00 3,002.29 0.00 (26.29) 100.88 287,900.00 288,046.00 243,297.58 3,568.00 41,180.42 85.70 15,000.00 0.00 0.00 0.00 0.00 0.00 16,400.00 16,400.00 4,102.85 11,897.79 399.36 97.56 35,000.00 35,000.00 19,025.55 9,004.47 6,969.98 80.09 66,400.00 51,400.00 23,128.40 20,902.26 7,369.34 85.66 354,300.00 339,446.00 266,425.98 24,470.26 48,549.76 85.70 6,000.00 6,000.00 3,000.00 0.00 3,000.00 50.00 2,000.00 2,000.00 0.00 0.00 2,000.00 0.00 2,000.00 2,000.00 648.78 0.00 1,351.22 32.44 4,000.00 4,000.00 2,035.94 0.00 1,964.06 50.90 14,000.00 14,000.00 5,684.72 0.00 8,315.28 40.61 139,500.00 139,500.00 113,637.19 0.00 25,862.81 81.46 1,500.00 1,500.00 1,000.01 0.00 499.99 66.67 1,000.00 1,000.00 812.11 0.00 187.89 81.21 8,600.00 8,600.00 6,954.83 0.00 1,645.17 80.87 2,100.00 2,100.00 1,626.48 0.00 473.52 77.45 15,700.00 15,700.00 12,761.53 0.00 2,938.47 81.28 27,100.00 27,100.00 21,288.18 0.00 5,811.82 78.55 400.00 400.00 340.93 0.00 59.07 85.23 195,900.00 195,900.00 1581421.26 0.00 37,478.74 80.87 209,900.00 209,900.00 164,105.98 0.00 45,794.02 78.18 3,000.00 3,000.00 3,185.40 0.00 (185.40) 106.18 9,000.00 6,000.00 0.00 0.00 6,000.00 0.00 4,250.00 2,818.00 2,902.00 0.00 (84.00) 102.98 13,000.00 13,000.00 6,523.19 0.00 6,476.81 50.18 23,000.00 23,000.00 17,907.00 0.00 5,093.00 77.86 1,000.00 600.00 490.79 0.00 109.21 81.80 35,000.00 33,000.00 24,410.11 0.00 8,589.89 73.97 08/15/2019 04:34 PM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 10/28 User: tracanati cc DB: Tequesta PERIOD ENDING 07/31/2019 (D 2018-19 YTD BALANCE CL ORIGINAL 2018-19 07/31/2019 ENCUMBERED UNENCUMBERED % BDW GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USjj,p Fund 001 - GENERAL FUND Expenditures 3 001-175-544.301 Operating Leases 2,000.00 2,102.00 1,388.63 533.19 180.18 91.4 001-175-545.300 Insurance 54,100.00 54,160.00 54,154.99 0.00 5.01 99. 001-175-546.175 K-9 Equipment & Maintenance 6,000.00 6,000.00 3,754.18 0.00 2,245.82 62.50 001-175-546.301 Office Equip/Repair & Maint 1,200.00 1,200.00 819.27 0.00 380.73 68.77 001-175-546.302 Vehicle Repair & Maintenance 30,000.00 33,400.00 29,158.49 0.00 4,241.51 87.30 001-175-546.303 Building Repair & Maint 51,000.00 46,000.00 32,143.88 6,045.00 7,811.12 83.02 001-175-546.304 Communication Equip Maint 36,000.00 36,000.00 34,353.00 0.00 1,647.00 95.43 001-175-546.310 Equipment Repair & Maint 3,000.00 3,000.00 2,336.06 0.00 663.94 77.87 001-175-546.320 Computer system maint & suppl 104,800.00 104,800.00 75,918.04 0.00 28,881.96 72.44 001-175-547.300 Printing & Binding 1,500.00 1,500.00 1,321.61 0.00 178.39 88.11 001-175-549.300 Other Misc Chgs & Obligations 7,000.00 11,210.00 9,199.59 0.00 2,010.41 82.07 001-175-549.303 Investigative Expenses 2,000.00 2,000.00 1,785.49 0.00 214.51 89.27 001-175-549.304 Licenses, Fees & Permits 2,500.00 1,750.00 1,319.48 0.00 430.52 75.40 001-175-549.311 Marine Unit Operations 4,250.00 4,250.00 2,061.20 0.00 2,188.80 48.50 001-175-549.314 K.E.Y.S. Program 12,000.00 15,600.00 7,125.43 0.00 8,474.57 45.68 001-175-551.300 Office Supplies & Equipment 5,000.00 4,000.00 2,994.16 0.00 1,005.84 74.85 001-175-551.301 Crime Prevention Supplies 4,000.00 3,000.00 899.54 0.00 2,100.46 29.98 001-175-552.301 Gas & Oil 28,000.00 41,182.00 27,166.86 0.00 14,015.14 65.97 001-175-552.302 Small Tools and Equipment 19,000.00 12,380.00 6,244.38 0.00 6,135.62 50.44 001-175-552.305 Uniforms 21,000.00 20,000.00 18,401.19 0.00 1,598.81 92.01 001-175-554.300 Books, Publ, Subs & Membershi 3,700.00 2,700.00 2,219.08 0.00 480.92 82.19 001-175-554.301 Personnel Training 17,000.00 17,000.00 11,452.00 0.00 5,548.00 67.36 Operating Expenditures/Expense 503,300.00 504,652.00 381,635.04 6,578.19 116,438.77 76.93 Personal Services 001-175-512.171 Sal & Wages - Adminstration 244,900.00 244,900.00 197,917.82 0.00 46,982.18 80.82 001-175-512.172 Reg Sal & Wages - Communicati 206,300.00 206,300.00 165,237.25 0.00 41,062.75 80.10 001-175-512.175 Reg Sal & Wages - Operations 1,212,600.00 1,204,550.00 935,296.20 0.00 269,253.80 77.65 001-175-514.172 Overtime - Communications 15,000.00 15,000.00 8,348.35 0.00 6,651.65 55.66 001-175-514.175 Overtime - Operations 94,200.00 92,685.00 59,663.33 0.00 33,021.67 64.37 001-175-515.101 Holiday Pay 55,700.00 55,700.00 43,547.10 0.00 12,152.90 78.18 001-175-515.103 Bonus Pay Plan 10,000.00 10,000.00 8,750.00 0.00 1,250.00 87.50 001-175-515.106 Clothing & Boot Allowance 13,100.00 13,100.00 14,729.81 0.00 (1,629.81) 112.44 001-175-515.107 Part-time Salaries 10,000.00 10,000.00 10,428.92 0.00 (428.92) 104.29 001-175-515.108 Auto Allowance 12,000.00 6,693.00 5,769.25 0.00 923.75 86.20 001-175-515.120 Cell phone allowance 1,200.00 1,200.00 1,015.30 0.00 184.70 84.61 001-175-515.125 Other Allowances 0.00 5,310.00 4,384.63 0.00 925.37 82.57 001-175-515.172 P/T Salary - Communications 25,000.00 25,000.00 31,781.92 0.00 (6,781.92) 127.13 001-175-515.175 P/T Salary - Operations 41,700.00 41,700.00 33,323.22 0.00 8,376.78 79.91 001-175-516.100 Compensated Absences 22,000.00 25,220.00 25,219.19 0.00 0.81 100.00 001-175-521.101 FICA Taxes 118,700.00 118,700.00 92,878.87 0.00 25,821.13 78.25 001-175-521.102 Medicare Taxes 27,800.00 27,800.00 21,749.14 0.00 6,050.86 78.23 001-175-522.101 FRS Contributions 31,900.00 31,900.00 24,075.32 0.00 7,824.68 75.47 001-175-522.102 VOT Pension Contributions 280,800.00 280,800.00 272,484.12 0.00 8,315.88 97.04 001-175-522.105 Defined Contribution 22,100.00 22,100.00 19,604.90 0.00 2,495.10 88.71 �-175-523.101 Life/Health Insurance 368,300.00 368,300.00 301,851.83 0.00 66,448.17 81.96 1-175-523.105 HSA - Health Savings Account 1,100.00 995.00 560.00 0.00 435.00 56.28 aD1-175-524.100 Workers' Comp Insurance 51,400.00 59,450.00 59,434.70 0.00 15.30 99.97 eeyrsonal Services 2,865,800.00 2,867,403.00 2,338,051.17 0.00 529,351.83 81.54 da'l)ital Outlay d&1-175-664.600 Mach/Equipment 0.00 31,100.00 0.00 0.00 31,100.00 0.00 01 -175-664.601 Computer Equipment 48,800.00 48,800.00 26,185.97 17,433.92 5,180.11 89.39 � ital Outlay 48,800.00 79,900.00 26,185.97 17,433.92 36,280.11 54.59 08/15/2019 04:34 PM User: tracanati DB: Tequesta GL NUMBER DESCRIPTION Fund 001 - GENERAL FUND Expenditures REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA PERIOD ENDING 07/31/2019 2018-19 YTD BALANCE ORIGINAL 2018-19 07/31/2019 BUDGET AMENDED BUDGET NORM (ABNORM) Total Dept 175 - Police Department 3,417,900.00 3,451,955.00 Dept 180 - Building & Zoning Operating Expenditures/Expense 001-180-531.301 Legal Services 13,000.00 4,000.00 001-180-531.320 Code Enforcement Service 7,000.00 0.00 001-180-531.325 Inspection Services 20,000.00 25,000.00 001-180-534.300 Other Contractual Services 0.00 1,500.00 001-180-540.300 Travel & Per Diem 3,000.00 5,500.00 001-180-541.300 Communication Services 7,500.00 5,500.00 001-180-541.301 Postage 2,800.00 1,600.00 001-180-543.300 Utility Services 7,600.00 7,600.00 001-180-544.301 Operating Leases 2,300.00 2,300.00 001-180-545.300 Insurance 1,600.00 1,600.00 001-180-546.301 Office Equip/Repair & Maint 1,150.00 1,150.00 001-180-546.302 Vehicle Repair & Maintenance 1,000.00 700.00 001-180-546.320 Computer system maint & suppl 8,600.00 9,900.00 001-180-547.300 Printing & Binding 1,000.00 1,500.00 001-180-549.300 Other Misc Chgs & Obligations 800.00 2,300.00 001-180-549.304 Licenses, Fees & Permits 2,000.00 3,000.00 001-180-551.300 Office Supplies & Equipment 3,000.00 3,000.00 001-180-552.301 Gas & Oil 1,500.00 750.00 001-180-552.305 Uniforms 500.00 1,500.00 001-180-554.300 Books, Publ, Subs & Membershi 2,000.00 1,400.00 001-180-554.301 Personnel Training 6,000.00 9,000.00 Operating Expenditures/Expense 92,350.00 88,800.00 Personal Services 001-180-512.100 Regular Salaries & Wages 423,000.00 304,294.00 001-180-514.100 Overtime 0.00 1,500.00 001-180-515.103 Bonus Pay Plan 1,000.00 2,600.00 001-180-515.106 Clothing & Boot Allowance 150.00 150.00 001-180-515.108 Auto Allowance 0.00 0.00 001-180-516.100 Compensated Absences 4,500.00 4,500.00 001-180-521.101 FICA Taxes 25,800.00 18,685.00 001-180-521.102 Medicare Taxes 6,100.00 4,450.00 001-180-522.102 VOT Pension Contributions 47,500.00 34,250.00 001-180-523.101 Life/Health Insurance 94,100.00 62,995.00 001-180-524.100 Workers' Comp Insurance 3,900.00 4,506.00 Personal Services 606,050.00 437,930.00 Capital Outlay 180-664.600 Mach/Equipment 150,000.00 1,700.00 -180-664.601 11- Computer Equipment 18,100.00 5,400.00 180-664.607 Equipment - Tech 15,000.00 15,000.00 ital Outlay 0.00 183,100.00 22,100.00 A 0.00 1,415.98 0.00 OUher Financing Sources & Uses 497.05 0.00 0981-180-549.395 Credit Card Fees and Charges 6,000.00 7,500.00 Wer Financing Sources & Uses 6,000.00 7,500.00 00 0.00 417.01 0.00 01 0.00 1,511.97 0.00 Page: 11/28 D to ENCUMBERED UNENCUMBERED 96 BDff YEAR-TO-DATE BALANCE USE➢ 2,745,872.18 24,012.11 2,668.75 0.00 0.00 0.00 19,800.00 5,175.00 1,109.00 0.00 6,371.75 0.00 3,516.29 0.00 797.30 0.00 4,365.43 0.00 1,723.05 0.00 1,415.98 0.00 713.41 0.00 497.05 0.00 9,921.42 0.00 1,161.03 0.00 2,313.68 0.00 1,275.65 0.00 2,510.35 0.00 417.01 0.00 1,501.78 0.00 1,511.97 0.00 6,480.17 0.00 70,071.07 5,175.00 229,678.58 0.00 811.13 0.00 2,040.00 0.00 0.00 0.00 230.76 0.00 1,089.58 0.00 14,049.59 0.00 3,285.79 0.00 25,762.47 0.00 39,561.07 0.00 4,505.77 0.00 321,014.74 0.00 0.00 0.00 5,372.47 2,974.45 8,153.82 3,859.06 13,526.29 6,833.51 7,946.80 0.00 7,946.80 0.00 3 682,070.71 80.2 1,331.25 0.00 25.00 391.00 (871.75) 1,983.71 802.70 3,234.57 576.95 184.02 436.59 202.95 (21.42) 338.97 (13.68) 1,724.35 489.65 332.99 (1.78) (111.97) 2,519.83 13,553.93 74,615.42 688.87 560.00 150.00 (230.76) 3,410.42 4,635.41 1,164.21 8,487.53 23,433.93 0.23 116,915.26 1,700.00 (2,946.92) 2,987.12 1,740.20 (446.80) (446.80) 66.72 0.00 99.90 73.93 115.85 63.93 49.83 57.44 74.92 88.50 62.04 71.01 100.22 77.40 100.59 42.52 83.68 55.60 100.12 108.00 72.00 84.74 75.48 54.08 78.46 0.00 100.00 24.21 75.19 73.84 75.22 62.80 99.99 73.30 0.00 154.57 80.09 92.13 105.96 105.96 08/15/2019 04:34 PM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 12/28 D User: tracanati (a DB: Tequesta PERIOD ENDING 07/31/2019 CD 2018-19 YTD BALANCE CLC ORIGINAL 2018-19 07/31/2019 ENCUMBERED UNENCUMBERED % BC" GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USF.p Fund 001 - GENERAL FUND Expenditures Total Dept 180 - Building & Zoning 887,500.00 556,330.00 412,558.90 12,008.51 131,762.59 76.3.1 O Dept 181 - Code Compliance Operating Expenditures/Expense 001-181-531.301 Legal Services 0.00 17,348.00 16,106.35 0.00 1,241.65 92.84 001-181-531.320 Code Enforcement Service 0.00 8,619.00 2,654.20 0.00 5,964.80 30.79 001-181-540.300 Travel & Per Diem 0.00 1,500.00 1,347.26 0.00 152.74 89.82 001-181-541.300 Communication Services 0.00 2,000.00 523.24 0.00 1,476.76 26.16 001-181-541.301 Postage 0.00 1,200.00 267.70 0.00 932.30 22.31 001-181-546.302 Vehicle Repair & Maintenance 0.00 500.00 642.79 0.00 (142.79) 128.56 001-181-551.300 Office Supplies & Equipment 0.00 0.00 67.19 0.00 (67.19) 100.00 001-181-552.301 Gas & Oil 0.00 750.00 650.62 0.00 99.38 86.75 001-181-554.300 Books, Publ, Subs & Membershi 0.00 600.00 130.00 0.00 470.00 21.67 001-181-554.301 Personnel Training 0.00 3,000.00 1,578.00 0.00 1,422.00 52.60 Operating Expenditures/Expense 0.00 35,517.00 23,967.35 0.00 11,549.65 67.48 Personal Services 001-181-512.100 Regular Salaries & Wages 0.00 43,680.00 36,338.41 0.00 7,341.59 83.19 001-181-514.100 Overtime 0.00 0.00 129.78 0.00 (129.78) 100.00 001-181-515.106 Clothing & Boot Allowance 0.00 150.00 125.00 0.00 25.00 83.33 001-181-515.107 Part-time Salaries 0.00 10,470.00 4,278.96 0.00 6,191.04 40.87 001-181-521.101 FICA Taxes 0.00 4,115.00 2,518.20 0.00 1,596.80 61.20 001-181-521.102 Medicare Taxes 0.00 960.00 588.92 0.00 371.08 61.35 001-181-522.102 VOT Pension Contributions 0.00 7,450.00 4,080.73 0.00 3,369.27 54.77 001-181-523.101 Life/Health Insurance 0.00 9,050.00 7,500.06 0.00 1,549.94 82.87 Personal Services 0.00 75,875.00 55,560.06 0.00 20,314.94 73.23 Total Dept 181 - Code Compliance 79,527.41 0.00 71.39 0.00 111,392.00 31,864.59 Dept 192 - Fire Control Operating Expenditures/Expense 001-192-526.101 Employee Recognition Program 3,500.00 3,500.00 2,625.06 0.00 874.94 75.00 001-192-526.103 EDUCATION REIMB PRGRM 15,000.00 12,485.00 9,458.66 0.00 3,026.34 75.76 001-192-526.105 Employee Physical/Psycologica 13,000.00 13,000.00 12,596.60 84.20 319.20 97.54 001-192-540.300 Travel & Per Diem 9,000.00 6,500.00 5,083.99 0.00 1,416.01 78.22 001-192-541.300 Communication Services 12,000.00 12,000.00 10,869.04 0.00 1,130.96 90.58 001-192-541.301 Postage 1,500.00 1,500.00 456.60 0.00 1,043.40 30.44 001-192-543.300 Utility Services 32,000.00 32,000.00 25,968.52 0.00 6,031.48 81.15 001-192-544.301 Operating Leases 5,000.00 5,000.00 2,999.15 0.00 2,000.85 59.98 001-192-545.300 Insurance 19,900.00 19,900.00 19,533.98 0.00 366.02 98.16 001-192-546.302 Vehicle Repair & Maintenance 2,000.00 78,731.00 72,723.12 0.00 6,007.88 92.37 dU-192-546.303 Building Repair & Maint 46,000.00 46,000.00 31,340.23 4,295.00 10,364.77 77.47 j�1-192-546.310 Equipment Repair & Maint 21,000.00 21,000.00 15,330.17 0.00 5,669.83 73.00 1-192-546.320 Computer system maint & suppl 36,600.00 36,600.00 27,141.01 0.00 9,458.99 74.16 192-547.300 Printing & Binding 2,000.00 2,000.00 1,646.57 0.00 353.43 82.33 -192-549.300 Other Misc Chgs & Obligations 4,500.00 4,500.00 3,841.70 0.00 658.30 85.37 GM -192-549.304 Licenses, Fees & Permits 20,000.00 20,000.00 18,082.41 1,272.23 645.36 96.77 Qq1-192-549.311 Marine Unit Operations 3,700.00 4,125.00 4,121.76 0.00 3.24 99.92 192-551.300 Office Supplies & Equipment 3,850.00 3,850.00 3,341.24 0.00 508.76 86.79 192-551.302 2:192-552.301 Fire Prevention Education 3,000.00 3,000.00 2,516.84 0.00 483.16 83.89 Gas & Oil 12,000.00 12,000.00 9,559.35 0.00 2,440.65 79.66 08/15/2019 04:34 User: tracanati DB: Tequesta GL NUMBER PM REVENUE AND DESCRIPTION EXPENDITURE REPORT FOR VILLAGE PERIOD ENDING 07/31/2019 2018-19 ORIGINAL 2018-19 BUDGET AMENDED BUDGET OF TEQUESTA YTD BALANCE 07/31/2019 NORM (ABNORM) ENCUMBERED YEAR-TO-DATE Page: 13/28 UNENCUMBERED BALANCE CD CL $ BEW US6Q d. Fund 001 - GENERAL FUND CD Expenditures 3 001-192-552.302 Small Tools and Equipment 3,850.00 3,850.00 2,959.28 0.00 890.72 76.£ 001-192-552.304 Chemicals 1,000.00 1,000.00 960.00 0.00 40.00 96. 001-192-552.305 Uniforms 35,000.00 35,000.00 34,495.59 0.00 504.41 98.5m 001-192-552.308 Safety Supplies 18,500.00 18,500.00 9,301.87 0.00 9,198.13 50.2$ 001-192-552.310 Disaster Relief Supplies 4,000.00 4,000.00 757.00 0.00 3,243.00 18.93 001-192-552.311 CPR PROGRAM SUPPLIES 1,000.00 1,344.00 1,343.05 0.00 0.95 99.93 001-192-552.312 Medical Supplies 60,000.00 57,994.00 34,159.52 0.00 23,834.48 58.90 001-192-552.344 Fire Station Supplies 4,300.00 4,300.00 2,679.03 0.00 1,620.97 62.30 001-192-554.300 Books, Publ, Subs & Membershi 4,000.00 4,000.00 3,913.26 0.00 86.74 97.83 001-192-554.301 Personnel Training 16,000.00 13,515.00 12,876.71 0.00 638.29 95.28 Operating Expenditures/Expense 413,200.00 481,194.00 382,681.31 5,651.43 92,861.26 80.70 Personal Services 001-192-512.100 Regular Salaries & Wages 1,837,900.00 1,754,520.00 1,398,974.89 0.00 355,545.11 79.74 001-192-513.101 FIRE INSPECTOR PAY 0.00 21,000.00 16,966.92 0.00 4,033.08 80.79 001-192-514.100 Overtime 77,300.00 116,716.00 103,232.76 0.00 13,483.24 88.45 001-192-514.300 Overtime - Training 23,200.00 23,200.00 21,991.62 0.00 1,208.38 94.79 001-192-515.101 Holiday Pay 47,100.00 55,110.00 50,183.12 0.00 4,926.88 91.06 001-192-515.103 Bonus Pay Plan 5,000.00 10,000.00 10,000.00 0.00 0.00 100.00 001-192-515.107 Part-time Salaries 31,900.00 21,300.00 10,517.23 0.00 10,782.77 49.38 001-192-515.110 Intern Fire Fighter Pay 21,500.00 7,430.00 7,075.11 0.00 354.89 95.22 001-192-515.120 Cell phone allowance 1,200.00 1,200.00 138.45 0.00 1,061.55 11.54 001-192-515.125 Other Allowances 6,000.00 6,000.00 5,307.71 0.00 692.29 88.46 001-192-516.100 Compensated Absences 10,000.00 15,000.00 11,953.25 0.00 3,046.75 79.69 001-192-521.101 FICA Taxes 122,000.00 122000.00 96,419.82 0.00 25,580.18 79.03 001-192-521.102 Medicare Taxes 29,000.00 29,000.00 22,805.73 0.00 6,194.27 78.64 001-192-522.102 VOT Pension Contributions 304,600.00 335,700.00 274,963.91 0.00 60,736.09 81.91 001-192-522.110 Other Pension Contributions 155,000.00 155,000.00 0.00 0.00 155,000.00 0.00 001-192-523.101 Life/Health Insurance 393,500.00 393,500.00 309,270.37 0.00 84,229.63 78.59 001-192-523.105 HSA - Health Savings Account 0.00 770.00 770.00 0.00 0.00 100.00 001-192-524.100 Workers' Comp Insurance 78,200.00 90,370.00 90,362.62 0.00 7.38 99.99 001-192-526.104 ICMA-Def Comp Plan 15,400.00 984.00 984.09 0.00 (0.09) 100.01 Personal Services 3,158,800.00 3,158,800.00 2,431,917.60 0.00 726,882.40 76.99 Capital Outlay 001-192-664.600 Mach/Equipment 50,000.00 69,198.00 40,494.56 9,242.81 19,460.63 71.88 001-192-664.601 Computer Equipment 51,200.00 35,100.00 22,872.72 7,931.86 4,295.42 87.76 001-192-664.602 Vehicles 60,000.00 61,100.00 25,284.00 0.00 35,816.00 41.38 Capital Outlay 161,200.00 165,398.00 88,651.28 17,174.67 59,572.05 63.98 Total Dept 192 - Fire Control 3,733,200.00 3,805,392.00 2,903,250.19 22,826.10 879,315.71 76.89 dot 210 - Public Works Anerating Expenditures/Expense 1-210-531.302 Engineering Services 15,000.00 18,900.00 2,049.79 8,100.00 8,750.21 53.70 210-534.300 Other Contractual Services 3,000.00 0.00 0.00 0.00 0.00 0.00 -210-540.300 Travel & Per Diem 400.00 0.00 0.00 0.00 0.00 0.00 SA-210-541.300 Communication Services 8,500.00 8,500.00 5,595.63 0.00 2,904.37 65.83 (a)1-210-543.300 Utility Services 115,000.00 115,000.00 80,095.92 0.00 34,904.08 69.65 dn-210-543.301 Street Lights 140,000.00 140,000.00 108,234.62 0.00 31,765.38 77.31 -210-544.301 Operating Leases 600.00 1,200.00 998.12 0.00 201.88 83.18 LUTp.-210-544.304 FEC Lease 18,100.00 18,100.00 18,021.72 0.00 78.28 99.57 08/15/2019 04:34 User: tracanati DB: Tequesta GL NUMBER PM REVENUE AND DESCRIPTION EXPENDITURE REPORT FOR VILLAGE PERIOD ENDING 07/31/2019 2018-19 ORIGINAL 2018-19 BUDGET AMENDED BUDGET OF TEQUESTA YTD BALANCE 07/31/2019 NORM (ABNORM) ENCUMBERED YEAR-TO-DATE Page: 14/28 UNENCUMBERED BALANCE to CD % BDW USaa d. Fund 001 - GENERAL FUND Expenditures 3 001-210-545.300 Insurance 15,800.00 15,800.00 15,161.53 0.00 638.47 95. 001-210-546.301 Office Equip/Repair & Maint 600.00 0.00 0.00 0.00 0.00 0.0� 001-210-546.302 VEHICLE REPAIR & MAINTENANCE 7,000.00 12,000.00 8,441.16 0.00 3,558.84 70.3® 001-210-546.303 Building Repair & Maint 60,000.00 60,000.00 44,709.92 2,755.14 12,534.94 79.11 001-210-546.305 Pathway Maintenance 15,000.00 15,000.00 4,031.58 5,785.00 5,183.42 65.44 001-210-546.306 General Maintenance 35,000.00 35,000.00 24,542.07 523.45 9,934.48 71.62 001-210-546.309 Landscape & Irrigation Maint 175,000.00 214,000.00 149,676.63 23,535.28 40,788.09 80.94 001-210-546.310 Equipment Repair & Maint 7,000.00 7,000.00 5,752.57 0.00 1,247.43 82.18 001-210-546.320 Computer system maint & suppl 2,200.00 2,200.00 1,413.10 0.00 786.90 64.23 001-210-546.340 R & M Bridge 30,000.00 4,000.00 0.00 0.00 4,000.00 0.00 001-210-546.350 R & M - Roads 40,000.00 14,100.00 11,506.51 1,187.50 1,405.99 90.03 001-210-549.300 Other Misc Chgs & Obligations 4,000.00 4,400.00 3,914.49 100.00 385.51 91.24 001-210-549.304 Licenses, Fees & Permits 2,000.00 2,000.00 1,366.93 0.00 633.07 68.35 001-210-551.300 Office Supplies & Equipment 1,500.00 1,500.00 986.10 0.00 513.90 65.74 001-210-551.400 Janitorial Supplies 7,500.00 7,500.00 5,963.21 0.00 1,536.79 79.51 001-210-552.301 Gas & Oil 5,500.00 5,500.00 3,823.05 0.00 1,676.95 69.51 001-210-552.302 Small Tools and Equipment 7,000.00 15,000.00 12,462.64 0.00 2,537.36 83.08 001-210-552.305 Uniforms 4,000.00 4,000.00 3,282.37 0.00 717.63 82.06 001-210-553.301 Road Signs 10,000.00 6,000.00 6,004.39 0.00 (4.39) 100.07 001-210-563.600 Public Works Misc Projects 20,000.00 23,000.00 19,261.95 0.00 3,738.05 83.75 Operating Expenditures/Expense 749,700.00 749,700.00 537,296.00 41,986.37 170,417.63 77.27 Personal Services 001-210-512.100 Regular Salaries & Wages 379,500.00 328,460.00 262,232.59 0.00 66,227.41 79.84 001-210-514.100 Overtime 9,000.00 9,000.00 6,555.37 0.00 2,444.63 72.84 001-210-515.103 Bonus Pay Plan 200.00 200.00 200.00 0.00 0.00 100.00 001-210-515.106 Clothing & Boot Allowance 1,100.00 975.00 775.00 0.00 200.00 79.49 001-210-515.108 Auto Allowance 1,500.00 1,500.00 1,163.09 0.00 336.91 77.54 001-210-521.101 FICA Taxes 23,900.00 21,625.00 16,337.15 0.00 5,287.85 75.55 001-210-521.102 Medicare Taxes 5,600.00 5,065.00 3,820.83 0.00 1,244.17 75.44 001-210-522.102 VOT Pension Contributions 42,700.00 38,600.00 29,466.83 0.00 9,133.17 76.34 001-210-523.101 Life/Health Insurance 102,300.00 93,355.00 74,224.11 0.00 19,130.89 79.51 001-210-524.100 Workers' Comp Insurance 31,000.00 45,480.00 45,477.83 0.00 2.17 100.00 Personal Services 596,800.00 544,260.00 440,252.80 0.00 104,007.20 80.89 Capital Outlay 001-210-664.601 Computer Equipment 1,000.00 1,000.00 0.00 991.48 8.52 99.15 001-210-664.602 Vehicles 34,000.00 0.00 0.00 0.00 0.00 0.00 Capital Outlay 35,000.00 1,000.00 0.00 991.48 8.52 99.15 Total Dept 210 - Public Works 1,381,500.00 1,294,960.00 977,548.80 42,977.85 274,433.35 78.81 61Q)t 231 - Leisure Services erating Expenditures/Expense 1-231-526.105 Employee Physical/Psycologica 1,500.00 1,500.00 369.40 0.00 1,130.60 24.63 231-531.324 Grants Acquistion & Admin 0.00 3,000.00 3,000.00 0.00 0.00 100.00 �ft-231-534.303 Special Events 55,000.00 55,000.00 54,744.21 0.00 255.79 99.53 OBJ.-231-540.300 Travel & Per Diem 1,500.00 0.00 0.00 0.00 0.00 0.00 ODD -231-541.300 Communication Services 14,000.00 12,187.00 8,284.85 0.00 3,902.15 67.98 231-541.301 Postage 150.00 150.00 3.79 0.00 146.21 2.53 ab'J-231-543.300 Utility Services 13,500.00 21,000.00 15,670.01 0.00 5,329.99 74.62 -231-545.300 Insurance 14,700.00 14,700.00 14,663.79 0.00 36.21 99.75 08/15/2019 04:34 PM User: tracanati DB: Tequesta GL NUMBER DESCRIPTION REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA PERIOD ENDING 07/31/2019 2018-19 YTD BALANCE ORIGINAL 2018-19 07/31/2019 ENCUMBERED BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE Fund 001 - GENERAL FUND 0.00 Expenditures 0.00 0.O&b 001-231-546.200 R&M - Station 11 5,000.00 001-231-546.302 VEHICLE REPAIR & MAINTENANCE 1,500.00 001-231-546.303 Building Repair & Maint 30,000.00 001-231-546.306 General Maintenance 36,000.00 001-231-546.310 Equipment Repair & Maint 1,700.00 001-231-546.320 Computer system maint & suppl 7,500.00 001-231-549.201 Advertising & Promotion 6,000.00 001-231-549.300 Other Misc Chgs & Obligations 3,450.00 001-231-549.304 Licenses, Fees & Permits 3,100.00 001-231-549.332 Recreation Program Expense 46,900.00 001-231-549.333 Spring/Summer Camp 17,000.00 001-231-551.300 Office Supplies & Equipment 2,000.00 001-231-551.315 Concession Supplies 800.00 001-231-552.301 Gas & Oil 2,500.00 001-231-552.302 Small Tools and Equipment 1,500.00 001-231-552.305 Uniforms 500.00 001-231-554.300 Books, Publ, Subs & Membershi 500.00 001-231-554.301 Personnel Training 1,200.00 Operating Expenditures/Expense 1,020.00 267,500.00 Personal Services 1.62 99.84 001-231-512.100 Regular Salaries & Wages 206,000.00 001-231-515.103 Bonus Pay Plan 3,150.00 001-231-515.106 Clothing & Boot Allowance 200.00 001-231-515.107 Part-time Salaries 64,300.00 001-231-515.108 Auto Allowance 3,000.00 001-231-515.109 Seasonal Salaries & Wages 30,000.00 001-231-515.120 Cell phone allowance 1,200.00 001-231-516.100 Compensated Absences 3,000.00 001-231-521.101 FICA Taxes 18,800.00 001-231-521.102 Medicare Taxes 4,400.00 001-231-522.102 VOT Pension Contributions 23,200.00 001-231-523.101 Life/Health Insurance 53,700.00 001-231-524.100 Workers' Comp Insurance 11,900.00 Personal Services 200.00 422,850.00 Capital Outlay 75.00 62.50 001-231-664.600 Mach/Equipment 10,000.00 001-231-664.601 Computer Equipment 1,900.00 Capital Outlay 0.00 11,900.00 Total Dept 231 - Leisure Services 702,250.00 0.00 9,808.03 67.31 j pt 700 - Debt Service 1,015.30 0.00 S - Principal 84.61 3,000.00 700-571.706 2002 Note Payable -PS bdg 320,300.00 -700-571.708 P/S - Prin - SunTrust - Pumpe 42,800.00 001-700-571.714 PRIN - PD EQUIPMENT 0.00 001-700-571.727 Lease Prin - SCVA Fire Equip 26,600.00 QS - Principal 75.48 389,700.00 Page: 15/28 D cc (D C. UNENCUMBERED o BDA BALANCE US,y',a 0.00 0.00 0.00 0.00 0.O&b 2,000.00 1,775.33 0.00 224.67 88.7y 70,000.00 24,676.17 0.00 45,323.83 35.20 36,000.00 29,156.25 0.00 6,843.75 80.99 1,700.00 394.16 0.00 1,305.84 23.19 7,500.00 2,562.28 0.00 4,937.72 34.16 7,194.00 7,193.00 0.00 1.00 99.99 3,450.00 407.21 0.00 3,042.79 11.80 3,100.00 3,118.90 0.00 (18.90) 100.61 38,900.00 35,381.40 0.00 3,518.60 90.95 22,000.00 12,153.79 0.00 9,846.21 55.24 2,000.00 1,170.43 0.00 829.57 58.52 1,020.00 1,018.38 0.00 1.62 99.84 2,500.00 886.64 0.00 1,613.36 35.47 1,000.00 703.95 0.00 296.05 70.40 500.00 109.75 0.00 390.25 21.95 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 306,401.00 217,443.69 0.00 88,957.31 70.97 204,360.00 159,379.61 0.00 44,980.39 77.99 3,150.00 3,150.00 0.00 0.00 100.00 200.00 125.00 0.00 75.00 62.50 64,300.00 47,870.70 0.00 16,429.30 74.45 3,000.00 2,538.36 0.00 461.64 84.61 30,000.00 20,191.97 0.00 9,808.03 67.31 1,200.00 1,015.30 0.00 184.70 84.61 3,000.00 2,693.05 0.00 306.95 89.77 18,800.00 14,201.55 0.00 4,598.45 75.54 4,400.00 3,321.31 0.00 1,078.69 75.48 23,200.00 17,898.30 0.00 5,301.70 77.15 53,700.00 44,522.55 0.00 9,177.45 82.91 13,540.00 13,538.25 0.00 1.75 99.99 422,850.00 330,445.95 0.00 92,404.05 78.15 1,099.00 1,099.00 0.00 0.00 100.00 1,900.00 0.00 1,900.00 0.00 100.00 2,999.00 1,099.00 1,900.00 0.00 100.00 548,988.64 181,361.36 732,250.00 1,900.00 75.23 320,300.00 265,800.03 0.00 54,499.97 82.98 42,800.00 42,358.12 0.00 441.88 98.97 6,620.00 6,620.00 0.00 0.00 100.00 26,600.00 26,533.21 0.00 66.79 99.75 396,320.00 341,311.36 0.00 55,008.64 86.12 08/15/2019 04:34 PM User: tracanati DB: Tequesta GL NUMBER DESCRIPTION REVENUE AND EXPENDITURE REPORT FOR VILLAGE PERIOD ENDING 07/31/2019 2018-19 ORIGINAL 2018-19 BUDGET AMENDED BUDGET OF TEQUESTA YTD BALANCE 07/31/2019 NORM (ABNORM) ENCUMBERED YEAR-TO-DATE Page: 16/28 UNENCUMBERED BALANCE D a $ BEW USF Fund 001 - GENERAL FUND Expenditures 3 D/S - Interest 001-700-572.706 2002 Note Payable - PS Bldg 52,300.00 52,300.00 44,617.87 0.00 7,682.13 85.3361 001-700-572.708 P/S - SunTrust - Pumper 5,500.00 5,500.00 6,435.82 0.00 (935.82) 117.010 001-700-572.727 Lease Int. - SCVA - Fire Equi 1,600.00 1,600.00 980.67 0.00 619.33 61.2 D/S - Interest 59,400.00 59,400.00 52,034.36 0.00 7,365.64 87.60 Total Dept 700 - Debt Service 449,100.00 455,720.00 393,345.72 0.00 62,374.28 86.31 Dept 950 - Other Nonoperating Other Financing Sources & Uses 001-950-549.391 Bank Charges 11,000.00 11,000.00 1,119.49 0.00 9,880.51 10.18 001-950-549.395 Credit Card Fees and Charges 0.00 0.00 1,051.30 0.00 (1,051.30) 100.00 001-950-590.001 Allocate to Fund Balance 0.00 31,533.00 0.00 0.00 31,533.00 0.00 Other Financing Sources & Uses 11,000.00 42,533.00 2,170.79 0.00 40,362.21 5.10 Total Dept 950 - Other Nonoperating 11,000.00 42,533.00 2,170.79 0.00 40,362.21 5.10 TOTAL EXPENDITURES 13,205,200.00 12,879,353.00 9,901,603.20 161,168.02 2,816,581.78 78.13 Fund 001 - GENERAL FUND: TOTAL REVENUES 13,205,200.00 12,879,353.00 11,432,334.75 0.00 1,447,018.25 88.76 TOTAL EXPENDITURES 13,205,200.00 12,879,353.00 9,901,603.20 161,168.02 2,816,581.78 78.13 NET OF REVENUES & EXPENDITURES 0.00 0.00 1,530,731.55 (161,168.02) (1,369,563.53) 100.00 N (D N 01 N O 41 4- 00 Cn 08/15/2019 04:34 PM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 17/28 D User: tracanati �Q DB: Tequesta PERIOD ENDING 07/31/2019 2018-19 YTD BALANCE ORIGINAL 2018-1907/31/2019 ENCUMBERED UNENCUMBERED $ BDff GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE US$p Fund 301 - Capital Improvement Fund Revenues 3 Dept 000 - GENERAL Miscellaneous Revenues 301-000-369.000 Other Miscellaneous Revenue 0.00 0.00 1,165.62 0.00 (1,165.62) 100.00 Miscellaneous Revenues 0.00 0.00 1,165.62 0.00 (1,165.62) 100.00 Total Dept 000 - GENERAL 0.00 0.00 100.00 0.00 1,165.62 (1,165.62) Dept 990 - Other/Reserve/Contingency Other Financing Sources 301-990-399.999 Appropriate Fund Balance 0.00 20,000.00 0.00 0.00 20,000.00 0.00 Other Financing Sources 0.00 20,000.00 0.00 0.00 20,000.00 0.00 Total Dept 990 - Other/Reserve/Contingency 0.00 0.00 0.00 0.00 20,000.00 20,000.00 TOTAL REVENUES 0.00 1,165.62 18,834.38 20,000.00 0.00 5.83 Expenditures Dept 210 - Public Works Capital Outlay 301-210-663.652 Pathway/Sidewalk Improvements 0.00 20,000.00 19,720.00 0.00 280.00 98.60 Capital Outlay 0.00 20,000.00 19,720.00 0.00 280.00 98.60 Total Dept 210 - Public Works 20,000.00 0.00 98.60 0.00 19,720.00 280.00 TOTAL EXPENDITURES 20,000.00 0.00 98.60 0.00 19,720.00 280.00 Fund 301 - Capital Improvement Fund: TOTAL REVENUES 0.00 20,000.00 1,165.62 0.00 18,834.38 5.83 TOTAL EXPENDITURES 0.00 20,000.00 19,720.00 0.00 280.00 98.60 NET OF REVENUES & EXPENDITURES 0.00 0.00 (18,554.38) 0.00 18,554.38 100.00 v (t] CD IV U1 W O OD M 08/15/2019 04:34 PM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 18/28 D User: tracanati 0.00 3,000,000.00 cQ DB: Tequesta PERIOD ENDING 07/31/2019 3,000,000.00 M 3,000,000.00 2018-19 YTD BALANCE 0.00 3,000,000.00 ORIGINAL 2018-19 07/31/2019 ENCUMBERED UNENCUMBERED % BE" GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USEL Fund 303 - Capital Projects Fund Revenues Dept 000 - GENERAL Other Financing Sources 303-000-384.001 Proceeds from LOC Other Financing Sources Total Dept 000 - GENERAL TOTAL REVENUES Expenditures Dept 317 - Recreation Center Capital Outlay 303-317-662.600 Buildings 303-317-663.632 Architect & Engineering -Other Capital Outlay Total Dept 317 - Recreation Center TOTAL EXPENDITURES Fund 303 - Capital Projects Fund: TOTAL REVENUES TOTAL EXPENDITURES NET OF REVENUES & EXPENDITURES (Q CD N Cl O h -01 Cb Cl 3,000,000.00 3,000,000.00 0.00 0.00 3,000,000.00 0.00 3,000,000.00 3,000,000.00 0.00 0.00 3,000,000.00 0.00 3,000,000.00 3,000,000.00 0.00 0.00 3,000,000.00 0.00 3,000,000.00 3,000,000.00 0.00 0.00 3,000,000.00 0.00 3,000,000.00 2,965,000.00 0.00 0.00 2,965,000.00 0.00 0.00 35,000.00 35,000.00 0.00 0.00 100.00 3,000,000.00 3,000,000.00 35,000.00 0.00 2,965,000.00 1.17 3,000,000.00 3,000,000.00 35,000.00 0.00 2,965,000.00 1.17 3,000,000.00 3,000,000.00 35,000.00 0.00 2,965,000.00 1.17 3,000,000.00 3,000,000.00 0.00 0.00 3,000,000.00 0.00 3,000,000.00 3,000,000.00 35,000.00 0.00 2,965,000.00 1.17 0.00 0.00 (35,000.00) 0.00 35,000.00 100.00 08/15/2019 04:34 PM User: tracanati DB: Tequesta GL NUMBER DESCRIPTION REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 19/28 D PERIOD ENDING 07/31/2019 2018-19 YTD BALANCE ORIGINAL 2018-19 07/31/2019 ENCUMBERED UNENCUMBERED % BEJW Fund 401 - Water Fund Revenues Dept 000 - GENERAL Miscellaneous Revenues 401-000-363.101 Martin/Tropic V -Const portion 401-000-369.000 Other Miscellaneous Revenue 401-000-369.100 Insurance Reimbursement Miscellaneous Revenues Other Financing Sources 401-000-369.110 Capital Connect Charge - Cust 401-000-369.111 Capital Connect Charge - Deve Other Financing Sources Charges for Services 401-000-343.301 Water Sales 401-000-343.302 Water- Connect Charges 401-000-343.303 WATER -FIRE PROTECTION CHARGES 401-000-343.304 Water Surcharge 401-000-343.306 Monthly Service Charge 401-000-343.307 Penalty Charges 401-000-343.308 OTHER WATER SERVICE INCOME 401-000-343.700 Water Conservation & Resource Charges for Services Total Dept 000 - GENERAL Dept 950 - Other Nonoperating Other Financing Sources 401-950-364.100 DISPOSITION/SALE OF ASSETS Other Financing Sources Unrestricted Investment Earnin 401-950-361.100 Interest/Investment Earnings Unrestricted Investment Earnin Total Dept 950 - Other Nonoperating Dept 990 - Other/Reserve/Contingency Other Financing Sources 49J-990-399.999 Appropriate Fund Balance Mher Financing Sources (D N 91al Dept 990 - Other/Reserve/Contingency O h T,WAL REVENUES 00 O7 17,800.00 17,800.00 33,508.59 9,000.00 9,000.00 10.07 0.00 0.00 3,067.80 26,800.00 26,800.00 36,586.46 27,100.00 27,100.00 0.00 9,000.00 9,000.00 20,218.52 36,100.00 36,100.00 20,218.52 3,087,300.00 3,087,300.00 2,666,146.42 17,800.00 17,800.00 19,954.88 70,700.00 70,700.00 69,033.81 516,600.00 516,600.00 473,633.31 1,886,300.00 1,886,300.00 1,591,439.31 48,000.00 48,000.00 40,732.34 1,500.00 1,500.00 5,808.10 1,000.00 1,000.00 0.00 5,629,200.00 5,629,200.00 4,866,748.17 0.00 1,000.00 4,923,553.15 5,692,100.00 5,692,100.00 0.00 0.00 2,222.25 0.00 0.00 2,222.25 60,000.00 60,000.00 102,407.38 60,000.00 60,000.00 102,407.38 (42,407.38) 170.68 104,629.63 60,000.00 60,000.00 2,095,750.00 2,140,000.00 0.00 2,095,750.00 2,140,000.00 0.00 0.00 2,140,000.00 0.00 2,095,750.00 7,892,100.00 0.00 7,847,850.00 5,028,182.78 L 0.00 (15,708.59) 188.240 0.00 8,989.93 0.1'1 0.00 (3,067.80) 100.00 0.00 (9,786.46) 136.52 0.00 27,100.00 0.00 0.00 (11,218.52) 224.65 0.00 15,881.48 56.01 0.00 421,153.58 86.36 0.00 (2,154.88) 112.11 0.00 1,666.19 97.64 0.00 42,966.69 91.68 0.00 294,860.69 84.37 0.00 7,267.66 84.86 0.00 (4,308.10) 387.21 0.00 1,000.00 0.00 0.00 762,451.83 86.46 0.00 86.50 768,546.85 0.00 (2,222.25) 100.00 0.00 (2,222.25) 100.00 0.00 (42,407.38) 170.68 0.00 (42,407.38) 170.68 0.00 174.38 (44,629.63) 0.00 2,140,000.00 0.00 0.00 2,140,000.00 0.00 0.00 0.00 2,140,000.00 2,863,917.22 63.71 0.00 08/15/2019 04:34 PM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 20/28 D User: tracanati to DB: Tequesta PERIOD ENDING 07/31/2019 2018-19 YTD BALANCE ORIGINAL 2018-19 07/31/2019 ENCUMBERED UNENCUMBERED % BDW GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE US" Fund 401 - Water Fund Expenditures Dept 241 - Water -Administration Operating Expenditures/Expense 401-241-531.301 Legal Services 15,000.00 15,000.00 2,163.96 0.00 12,836.04 14.40 401-241-531.302 Engineering Services 50,000.00 75,000.00 64,948.25 0.00 10,051.75 86.6b 401-241-531.308 Legal fees - Personnel 0.00 75,000.00 69,165.00 0.00 5,835.00 92.22 401-241-532.300 Accounting & Auditing Service 31,100.00 32,850.00 32,850.00 0.00 0.00 100.00 401-241-534.300 Other Contractual Services 20,000.00 68,415.00 13,500.00 52,250.00 2,665.00 96.10 401-241-541.300 Communication Services 2,500.00 2,500.00 2,100.00 0.00 400.00 84.00 401-241-544.304 FEC Lease 15,300.00 15,300.00 15,121.77 0.00 178.23 98.84 401-241-545.300 Insurance 45,300.00 46,055.00 46,054.37 0.00 0.63 100.00 401-241-546.320 Computer system maint & suppl 36,300.00 36,300.00 23,436.74 0.00 12,863.26 64.56 401-241-549.300 Other Misc Chgs & Obligations 2,100.00 1,345.00 0.00 0.00 1,345.00 0.00 401-241-549.301 Admin Mgmt Fees 572,900.00 572,900.00 477,416.60 0.00 95,483.40 83.33 401-241-549.304 Licenses, Fees & Permits 800.00 800.00 781.00 0.00 19.00 97.63 Operating Expenditures/Expense 791,300.00 941,465.00 747,537.69 52,250.00 141,677.31 84.95 Personal Services 401-241-512.100 Regular Salaries & Wages 319,700.00 272,320.00 232,166.93 0.00 40,153.07 85.26 401-241-515.103 Bonus Pay Plan 1,850.00 1,850.00 1,324.97 0.00 525.03 71.62 401-241-515.108 Auto Allowance 1,500.00 5,250.00 1,263.02 0.00 3,986.98 24.06 401-241-515.120 Cell phone allowance 900.00 900.00 641.30 0.00 258.70 71.26 401-241-515.125 Other Allowances 0.00 1,500.00 0.00 0.00 1,500.00 0.00 401-241-516.100 Compensated Absences 2,500.00 10,227.00 13,903.50 0.00 (3,676.50) 135.95 401-241-521.101 FICA Taxes 19,900.00 15,470.00 13,183.43 0.00 2,286.57 85.22 401-241-521.102 Medicare Taxes 4,700.00 4,700.00 3,674.46 0.00 1,025.54 78.18 401-241-522.102 VOT Pension Contributions 35,900.00 21,625.00 16,554.18 0.00 5,070.82 76.55 401-241-523.101 Life/Health Insurance 44,500.00 25,590.00 21,386.00 0.00 4,204.00 83.57 401-241-524.100 Workers' Comp Insurance 8,800.00 12,080.00 12,078.73 0.00 1.27 99.99 401-241-526.104 ICMA-Def Comp Plan 0.00 3,025.00 3,024.00 0.00 1.00 99.97 Personal Services 440,250.00 374,537.00 319,200.52 0.00 55,336.48 85.23 Total Dept 241 - Water -Administration 1,316,002.00 1,066,738.21 197,013.79 1,231,550.00 52,250.00 85.03 Dept 242 - Water - Production Operating Expenditures/Expense 401-242-531.342 Water Analysis & Sampling 33,000.00 33,000.00 30,730.00 0.00 2,270.00 93.12 401-242-540.300 Travel & Per Diem 2,200.00 2,200.00 1,754.90 0.00 445.10 79.77 401-242-541.300 Communication Services 22,000.00 22,000.00 13,540.45 0.00 8,459.55 61.55 401-242-541.301 Postage 3,300.00 3,300.00 1,971.65 0.00 1,328.35 59.75 401-242-543.300 Utility Services 385,000.00 385,000.00 345,515.11 0.00 39,484.89 89.74 401-242-544.301 Operating Leases 8,800.00 8,800.00 1,848.08 0.00 6,951.92 21.00 401-242-546.302 Vehicle Repair & Maintenance 8,800.00 13,800.00 10,378.61 0.00 3,421.39 75.21 401-242-546.303 Building Repair & Maint 66,000.00 61,000.00 28,631.52 0.00 32,368.48 46.94 Landscape & Irrigation Maint 33,000.00 33,000.00 9,059.62 0.00 23,940.38 27.45 11-242-546.342-242-546.309 -242-546.310 Equipment Repair & Maint 71,500.00 0.00 0.00 0.00 0.00 0.00 Water System Maintenance 86,900.00 138,931.00 95,949.66 0.00 42,981.34 69.06 242-547.300 Printing & Binding 3,100.00 3,100.00 2,366.79 0.00 733.21 76.35 -242-549.300 Other Misc Chgs & Obligations 5,200.00 5,200.00 2,111.21 0.00 3,088.79 40.60 42ft-242-549.304 Licenses, Fees & Permits 30,900.00 30,900.00 16,164.47 0.00 14,735.53 52.31 491-242-551.300 Office Supplies & Equipment 7,300.00 7,300.00 4,976.29 0.00 2,323.71 68.17 242-552.301 Gas & Oil 4,200.00 4,200.00 2,376.23 0.00 1,823.77 56.58 -242-552.302 Small Tools and Equipment 5,700.00 5,700.00 5,152.24 0.00 547.76 90.39 -242-552.303 Diesel Fuel 7,300.00 7,300.00 3,601.68 0.00 3,698.32 49.34 08/15/2019 04:34 PM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 21/28 D User: tracanati a DB: Tequesta PERIOD ENDING 07/31/2019 2018-19 YTD BALANCE n. ORIGINAL 2018-19 07/31/2019 ENCUMBERED UNENCUMBERED $ BDJ' GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USAQ Fund 401 - Water Fund Expenditures 3 401-242-552.305 Uniforms 4,200.00 4,200.00 3,046.15 0.00 1,153.85 72. 401-242-552.341 Water Purchases 30,000.00 30,000.00 0.00 0.00 30,000.00 0. 401-242-552.342 Water Chemicals 196,000.00 203,360.00 171,689.13 7,747.09 23,923.78 88.2® 401-242-552.343 Laboratory Supplies 30,000.00 30,000.00 14,511.93 3,790.17 11,697.90 61.OR 401-242-554.300 Books, Publ, Subs & Membershi 2,100.00 2,100.00 1,137.25 0.00 962.75 54.15 401-242-554.301 Personnel Training 6,200.00 6,200.00 2,142.00 0.00 4,058.00 34.55 Operating Expenditures/Expense 1,052,700.00 1,040,591.00 768,654.97 11,537.26 260,398.77 74.98 Personal Services 401-242-512.100 Regular Salaries & Wages 596,900.00 570,492.00 425,483.04 0.00 145,008.96 74.58 401-242-514.100 Overtime 25,000.00 25,000.00 16,117.52 0.00 8,882.48 64.47 401-242-515.101 Holiday Pay 7,500.00 7,500.00 7,302.78 0.00 197.22 97.37 401-242-515.102 Standby Pay 10,300.00 10,300.00 6,777.40 0.00 3,522.60 65.80 401-242-515.103 Bonus Pay Plan 500.00 500.00 0.00 0.00 500.00 0.00 401-242-515.106 Clothing & Boot Allowance 1,000.00 1,000.00 1,100.00 0.00 (100.00) 110.00 401-242-516.100 Compensated Absences 5,000.00 5,000.00 1,772.96 0.00 3,227.04 35.46 401-242-521.101 FICA Taxes 39,000.00 39,000.00 27,703.36 0.00 11,296.64 71.03 401-242-521.102 Medicare Taxes 9,200.00 9,200.00 6,479.08 0.00 2,720.92 70.42 401-242-522.101 FRS Contributions 7,200.00 7,200.00 10,279.03 0.00 (3,079.03) 142.76 401-242-522.102 VOT Pension Contributions 58,400.00 58,400.00 40,683.75 0.00 17,716.25 69.66 401-242-523.101 Life/Health Insurance 141,600.00 141,600.00 92,989.02 0.00 48,610.98 65.67 401-242-524.100 Workers' Comp Insurance 17,700.00 23,906.00 23,905.59 0.00 0.41 100.00 401-242-525.100 Unemployment Compensation 0.00 0.00 394.59 0.00 (394.59) 100.00 Personal Services 919,300.00 899,098.00 660,988.12 0.00 238,109.88 73.52 Capital Outlay 401-242-664.600 Mach/Equipment 0.00 0.00 2,567.91 0.00 (2,567.91) 100.00 Capital Outlay 0.00 0.00 2,567.91 0.00 (2,567.91) 100.00 Total Dept 242 - Water - Production 1,939,689.00 11,537.26 74.43 1,972,000.00 1,432,211.00 495,940.74 Dept 243 - Water -Distribution Operating Expenditures/Expense 401-243-540.300 Travel & Per Diem 600.00 2,500.00 1,060.83 0.00 1,439.17 42.43 401-243-541.300 Communication Services 14,500.00 12,800.00 10,360.15 0.00 2,439.85 80.94 401-243-541.301 POSTAGE 24,800.00 24,800.00 21,429.74 0.00 3,370.26 86.41 401-243-544.301 Operating Leases 4,300.00 2,600.00 998.11 0.00 1,601.89 38.39 401-243-546.301 Office Equip/Repair & Maint 1,600.00 0.00 0.00 0.00 0.00 0.00 401-243-546.302 Vehicle Repair & Maintenance 10,300.00 10,300.00 7,888.28 0.00 2,411.72 76.59 401-243-546.303 Building Repair & Maint 5,200.00 5,200.00 4,420.90 0.00 779.10 85.02 401-243-546.309 Landscape & Irrigation Maint 2,100.00 2,100.00 737.50 0.00 1,362.50 35.12 401-243-546.310 Equipment Repair & Maint 5,200.00 10,200.00 10,981.33 0.00 (781.33) 107.66 243-546.342 Water System Maintenance 46,400.00 43,530.00 45,273.38 0.00 (1,743.38) 104.01 1-243-547.300 Printing & Binding 15,000.00 13,000.00 8,126.26 0.00 4,873.74 62.51 1-243-549.300 Other Misc Chgs & Obligations 3,100.00 3,100.00 6,529.86 0.00 (3,429.86) 210.64 243-549.304 Licenses, Fees & Permits 1,900.00 1,900.00 1,363.04 0.00 536.96 71.74 -243-551.300 Office Supplies & Equipment 2,100.00 4,100.00 2,445.85 0.00 1,654.15 59.65 491-243-552.301 Gas & Oil 10,300.00 10,300.00 8,154.81 0.00 2,145.19 79.17 43)1-243-552.302 Small Tools and Equipment 5,200.00 5,200.00 5,032.26 0.00 167.74 96.77 243-552.305 Uniforms 3,200.00 3,200.00 3,161.50 0.00 38.50 98.80 -243-554.301 Personnel Training 3,100.00 2,800.00 2,218.50 0.00 581.50 79.23 01 08/15/2019 04:34 PM User: tracanati DB: Tequesta GL NUMBER DESCRIPTION REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 22/28 D PERIOD ENDING 07/31/2019 2018-19 YTD BALANCE ORIGINAL2018-19 07/31/2019 ENCUMBERED UNENCUMBERED % BDW BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USZQ Fund 401 - Water Fund 17,447.70 88.9# Expenditures Operating Expenditures/Expense 158,900.00 157,630.00 Personal Services 375,037.62 0.00 102,047.38 401-243-512.100 Regular Salaries & Wages 494,600.00 477,085.00 401-243-514.100 Overtime 10,000.00 10,000.00 401-243-515.102 Standby Pay 24,500.00 24,500.00 401-243-515.103 Bonus Pay Plan 1,250.00 1,250.00 401-243-515.106 Clothing & Boot Allowance 850.00 850.00 401-243-516.100 Compensated Absences 5,000.00 5,000.00 401-243-521.101 FICA Taxes 32,700.00 32,700.00 401-243-521.102 Medicare Taxes 7,700.00 7,700.00 401-243-522.101 FRS Contributions 19,800.00 19,800.00 401-243-522.102 VOT Pension Contributions 37,400.00 37,400.00 401-243-523.101 Life/Health Insurance 112,900.00 112,900.00 401-243-524.100 Workers' Comp Insurance 12,700.00 15,215.00 Personal Services 5,937.00 759,400.00 744,400.00 Capital Outlay 5,937.00 0.00 2,000.00 401-243-664.600 Mach/Equipment 0.00 7,937.00 Capital Outlay 765,245.08 0.00 7,937.00 Total Dept 243 - Water -Distribution 918,300.00 909,967.00 Dept 411 - Renewal & Replacement 24,083.23 6.65 Operating Expenditures/Expense 0.00 1,500.90 401-411-531.302 Engineering Services 150,000.00 140,000.00 401-411-546.604 R & M - Pump and Motor Rehab 25,800.00 25,800.00 401-411-546.605 R&M - Well Rehabilitation 51,500.00 63,609.00 401-411-549.671 Misc. Renewal & Replacement 1,840,000.00 1,830,000.00 401-411-552.601 Meters, Valves & Hydrants 204,000.00 74,233.00 Operating Expenditures/Expense 2,271,300.00 2,133,642.00 Capital Outlay 80.18 34,941.25 19,308.17 401-411-664.600 Mach/Equipment 0.00 118,000.00 401-411-664.601 Computer Equipment 9,100.00 14,200.00 401-411-664.607 Equipment - Tech 50,000.00 50,000.00 Capital Outlay 0.00 59,100.00 182,200.00 Total Dept 411 - Renewal & Replacement 2,330,400.00 2,315,842.00 0 0.00 3,640.56 46.46 apt 700 - Debt Service DMS - Principal 4%-700-571.705 Prin - 2004 Water N/P BOA 39,000.00 39,000.00 T-700-571.720 Prin - 2008 Water Utility Not 336,300.00 336,300.00 D6S - Principal 375,300.00 375,300.00 Interest -700-572.705 Int - 2004 Water N/P BOA 6,800.00 6,800.00 140,182.30 0.00 17,447.70 88.9# 375,037.62 0.00 102,047.38 78.61 7,809.71 0.00 2,190.29 78.10 21,486.29 0.00 3,013.71 87.70 1,750.00 0.00 (500.00) 140.00 687.49 0.00 162.51 80.88 32,303.57 0.00 (27,303.57) 646.07 24,954.62 0.00 7,745.38 76.31 5,836.07 0.00 1,863.93 75.79 9,582.71 0.00 10,217.29 48.40 35,132.65 0.00 2,267.35 93.94 89,330.28 0.00 23,569.72 79.12 15,214.77 0.00 0.23 100.00 619,125.78 0.00 125,274.22 83.17 5,937.00 0.00 2,000.00 74.80 5,937.00 0.00 2,000.00 74.80 0.00 84.10 765,245.08 144,721.92 94,063.83 54,967.50 (9,031.33) 106.45 1,716.77 0.00 24,083.23 6.65 62,108.10 0.00 1,500.90 97.64 517,719.32 1,298,936.55 13,344.13 99.27 34,176.54 19,190.18 20,866.28 71.89 709,784.56 1,373,094.23 50,763.21 97.62 0.00 0.00 118,000.00 0.00 7,716.96 6,444.64 38.40 99.73 27,224.29 12,863.53 9,912.18 80.18 34,941.25 19,308.17 127,950.58 29.77 1,392,402.40 92.28 744,725.81 178,713.79 39,000.00 0.00 0.00 100.00 279,245.42 0.00 57,054.58 83.03 318,245.42 0.00 57,054.58 84.80 3,159.44 0.00 3,640.56 46.46 08/15/2019 04:34 PM REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 23/28 D User: tracanati DB: Tequesta PERIOD ENDING 07/31/2019 CD 3 2018-19 YTD BALANCECL ORIGINAL 2018-19 07/31/2019 ENCUMBERED UNENCUMBERED $ BE%W GL NUMBER DESCRIPTION BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE Us." ft Fund 401 - Water Fund CD Expenditures a 401-700-572.720 Int - 2008 Water Utility Note 135,000.00 135,000.00 101,382.87 0.00 33,617.13 75. 401-700-573.700 Other Debt Service Costs 22,500.00 22,500.00 0.00 0.00 22,500.00 0. D/S - Interest 164,300.00 164,300.00 104,542.31 0.00 59,757.69 63. Total Dept 700 - Debt Service 539,600.00 0.00 539,600.00 422,787.73 116,812.27 78.35 Dept 950 - Other Nonoperating Operating Expenditures/Expense 401-950-559.301 Budgeted Depreciation (netted 825,000.00 825,000.00 0.00 0.00 825,000.00 0.00 Operating Expenditures/Expense 825,000.00 825,000.00 0.00 0.00 825,000.00 0.00 Other Financing Sources & Uses 401-950-549.391 Bank Charges 11,000.00 11,000.00 1,352.33 0.00 9,647.67 12.29 401-950-549.395 Credit Card Fees and Charges 20,000.00 20,000.00 11,666.42 0.00 8,333.58 58.33 401-950-592.100 LEGAL SETTLEMENT 0.00 15,000.00 15,000.00 0.00 0.00 100.00 Other Financing Sources & Uses 31,000.00 46,000.00 28,018.75 0.00 17,981.25 60.91 Total Dept 950 - Other Nonoperating 871,000.00 0.00 856,000.00 28,018.75 842,981.25 3.22 TOTAL EXPENDITURES 7,892,100.00 4,459,726.58 1,976,183.76 74.96 7,847,850.00 1,456,189.66 Fund 401 - Water Fund: TOTAL REVENUES 7,847,850.00 7,892,100.00 5,028,182.78 0.00 2,863,917.22 63.71 TOTAL EXPENDITURES 7,847,850.00 7,892,100.00 4,459,726.58 1,456,189.66 1,976,183.76 74.96 NET OF REVENUES & EXPENDITURES 0.00 0.00 568,456.20 (1,456,189.66) 887,733.46 100.00 O CQ O N 01 O 0o 01 08/15/2019 04:34 PM User: tracanati DB: Tequesta GL NUMBER DESCRIPTION Fund 402 - Refuse & Recycling Revenues Dept 000 - GENERAL Intergovernmental Revenue 402-000-338.110 Recycling Shared Rev - SW Intergovernmental Revenue Charges for Services 402-000-343.400 Refuse / Recycling Fees Charges for Services Total Dept 000 - GENERAL Dept 950 - Other Nonoperating Unrestricted Investment Earnin 402-950-361.100 Interest/Investment Earning 402-950-361.101 PBC Tax Col -Interest on Dep Unrestricted Investment Earnin Total Dept 950 - Other Nonoperating TOTAL REVENUES Expenditures Dept 245 - Refuse and Recycling Operating Expenditures/Expense 402-245-543.302 Solid Waste/Residential 402-245-543.303 Recycling/Residential 402-245-543.304 Yard Waste/Residential 402-245-549.300 Other Misc Chgs & Obligatio 402-245-549.301 Admin Mgmt Fees Operating Expenditures/Expense Total Dept 245 - Refuse and Recycling Dept 950 - Other Nonoperating Other Financing Sources & Uses 402-950-590.001 Allocate to Fund Balance Other Financing Sources & Uses N (O <D t al Dept 950 - Other Nonoperating O ITAL EXPENDITURES 00 REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 24/28 D PERIOD ENDING 07/31/2019 (D 2018-19 YTD BALANCE ORIGINAL 2018-19 07/31/2019 ENCUMBERED UNENCUMBERED $ BDW BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE USF,a A 0.00 0.00 683.39 0.00 (683.39) 100.00 0.00 0.00 683.39 0.00 (683.39) 100.00 484,000.00 484,000.00 482,968.35 0.00 1,031.65 99.79 484,000.00 484,000.00 482,968.35 0.00 1,031.65 99.79 484,000.00 484,000.00 483,651.74 0.00 348.26 99.93 Earnings 2,000.00 2,000.00 1,540.43 0.00 459.57 77.02 0.00 0.00 101.62 0.00 (101.62) 100.00 2,000.00 2,000.00 1,642.05 0.00 357.95 82.10 2,000.00 1,642.05 0.00 82.10 2,000.00 357.95 486,000.00 485,293.79 0.00 99.85 486,000.00 706.21 232,200.00 232,200.00 174,076.65 58,025.55 97.80 99.96 107,100.00 107,100.00 80,276.67 26,758.89 64.44 99.94 132,400.00 132,400.00 99,266.85 33,088.95 44.20 99.97 is 600.00 600.00 183.00 0.00 417.00 30.50 8,100.00 8,100.00 6,750.00 0.00 1,350.00 83.33 480,400.00 480,400.00 360,553.17 117,873.39 1,973.44 99.59 480,400.00 360,553.17 117,873.39 99.59 480,400.00 1,973.44 5,600.00 5,600.00 0.00 0.00 5,600.00 0.00 5,600.00 5,600.00 0.00 0.00 5,600.00 0.00 5,600.00 0.00 5,600.00 5,600.00 0.00 0.00 486,000.00 360,553.17 117,873.39 98.44 486,000.00 7,573.44 08/15/2019 04:34 PM User: tracanati DB: Tequesta GL NUMBER DESCRIPTION Fund 402 - Refuse & Recycling Fund 402 - Refuse & Recycling: TOTAL REVENUES TOTAL EXPENDITURES NET OF REVENUES & EXPENDITURES CQ CD N Cn O .P Cb 01 REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA Page: 25/28 PERIOD ENDING 07/31/2019 2018-19 YTD BALANCE ORIGINAL 2018-19 07/31/2019 ENCUMBERED UNENCUMBERED % BUDGET AMENDED BUDGET NORM (ABNORM) YEAR-TO-DATE BALANCE 486,000.00 486,000.00 486,000.00 486,000.00 0.00 0.00 485,293.79 360,553.17 124,740.62 0.00 117,873.39 (117,873.39) 706.21 99. 7,573.44 98.4j (6,867.23) 100.5.0 08/15/2019 04:34 PM User: tracanati DB: Tequesta GL NUMBER DESCRIPTION Fund 403 - Stormwater Utility Revenues Dept 000 - GENERAL Charges for Services 403-000-343.901 Storm Water Utility Fees Charges for Services Total Dept 000 - GENERAL REVENUE AND EXPENDITURE REPORT FOR VILLAGE OF TEQUESTA PERIOD ENDING 07/31/2019 2018-19 YTD BALANCE ORIGINAL 2018-19 07/31/2019 BUDGET AMENDED BUDGET NORM (ABNORM) Dept 950 - Other Nonoperating Unrestricted Investment Earnin 403-950-361.100 Interest/Investment Earnings 403-950-361.101 PBC Tax Col -Interest on Dep Unrestricted Investment Earnin Total Dept 950 - Other Nonoperating Dept 990 - Other/Reserve/Contingency Other Financing Sources 403-990-399.999 Appropriate Fund Balance Other Financing Sources Total Dept 990 - Other/Reserve/Contingency TOTAL REVENUES Expenditures Dept 250 - Storm Water Utilities Operating Expenditures/Expense 403-250-531.302 Engineering Services 403-250-532.300 Accounting & Auditing Service 403-250-534.300 Other Contractual Services 403-250-540.300 Travel & Per Diem 403-250-541.300 Communication Services 403-250-541.301 Postage 403-250-545.300 Insurance 403-250-546.302 Vehicle Repair & Maintenance 403-250-546.303 Building Repair & Maint 403-250-546.308 Drainage Maintenance 4ID -250-546.310 Equipment Repair & Maint 03-250-546.320 Computer system maint & suppl 3-250-549.300 Other Misc Chgs & Obligations 3-250-549.301 Admin Mgmt Fees 250-549.304 Licenses, Fees & Permits -250-551.300 Office Supplies & Equipment 3-250-552.301 Gas & Oil -250-552.302 Small Tools and Equipment 4,pb¢3�-250-554.100 Public Education Program V -250-554.301 Personnel Training 394,000.00 394,000.00 423,635.96 394,000.00 394,000.00 423,635.96 394,000.00 394,000.00 423,635.96 8,000.00 8,000.00 19,133.91 0.00 0.00 82.94 8,000.00 8,000.00 19,216.85 8,000.00 8,000.00 19,216.85 56,600.00 104,950.00 0.00 56,600.00 104,950.00 0.00 56,600.00 104,950.00 0.00 458,600.00 506,950.00 442,852.81 10,000.00 Page: 26/28 D 0.00 (22,764.71) to 4,400.00 4,645.00 M 0.00 0.00 100.00 5,000.00 53,105.00 CL ENCUMBERED UNENCUMBERED °a BD" YEAR-TO-DATE BALANCE U.- 0.00 500.00 0.00 4,000.00 4,000.00 2,946.25 0.00 1,053.75 73.66 0.00 (29,635.96) 107.50 0.00 (29,635.96) 107.52 0.00 (29,635.96) 919.99 107.52 0.00 (11,133.91) 239.17 0.00 (82.94) 100.00 0.00 (11,216.85) 240.21 0.00 (11,216.85) 0.00 240.21 0.00 104,950.00 0.00 0.00 104,950.00 0.00 0.00 3,600.00 0.00 104,950.00 0.00 905.90 87.36 0.00 64,097.19 10,000.00 10,000.00 32,764.71 0.00 (22,764.71) 327.65 4,400.00 4,645.00 4,645.00 0.00 0.00 100.00 5,000.00 53,105.00 7,252.50 41,097.50 4,755.00 91.05 500.00 500.00 0.00 0.00 500.00 0.00 4,000.00 4,000.00 2,946.25 0.00 1,053.75 73.66 500.00 500.00 0.00 0.00 500.00 0.00 500.00 920.00 919.99 0.00 0.01 100.00 2,000.00 2,000.00 212.48 0.00 1,787.52 10.62 1,000.00 1,000.00 1,583.87 0.00 (583.87) 158.39 42,000.00 30,267.50 22,850.50 1,187.50 6,229.50 79.42 3,600.00 3,600.00 2,694.10 0.00 905.90 74.84 1,400.00 1,400.00 643.70 0.00 756.30 45.98 2,000.00 1,580.00 1,172.22 0.00 407.78 74.19 13,700.00 13,700.00 11,416.60 0.00 2,283.40 83.33 5,000.00 5,000.00 4,658.04 0.00 341.96 93.16 1,000.00 1,000.00 246.70 0.00 753.30 24.67 1,500.00 1,500.00 1,219.01 0.00 280.99 81.27 5,000.00 5,000.00 2,872.30 0.00 2,127.70 57.45 500.00 500.00 0.00 0.00 500.00 0.00 1,000.00 1,000.00 325.00 0.00 675.00 32.50 08/15/2019 04:34 PM REVENUE AND User: tracanati DB: Tequesta GL NUMBER DESCRIPTION EXPENDITURE REPORT FOR VILLAGE PERIOD ENDING 07/31/2019 2018-19 ORIGINAL 2018-19 BUDGET AMENDED BUDGET OF TEQUESTA YTD BALANCE 07/31/2019 NORM (ABNORM) ENCUMBERED YEAR-TO-DATE Page: 27/28 UNENCUMBERED BALANCE D Brff USAQ Fund 403 - Stormwater Utility Expenditures 3 Operating Expenditures/Expense 104,600.00 141,217.50 98,422.97 42,285.00 509.53 99.6ft Personal Services 0 403-250-512.100 Regular Salaries & Wages 82,500.00 81,910.00 65,709.26 0.00 16,200.74 80.22 403-250-514.100 Overtime 1,000.00 0.00 0.00 0.00 0.00 0.00 403-250-515.103 Bonus Pay Plan 100.00 100.00 100.00 0.00 0.00 100.00 403-250-515.106 Clothing & Boot Allowance 200.00 200.00 187.51 0.00 12.49 93.76 403-250-515.108 Auto Allowance 800.00 800.00 581.55 0.00 218.45 72.69 403-250-521.101 FICA Taxes 5,300.00 5,300.00 4,102.77 0.00 1,197.23 77.41 403-250-521.102 Medicare Taxes 1,300.00 1,300.00 959.46 0.00 340.54 73.80 403-250-522.102 VOT Pension Contributions 9,300.00 9,300.00 7,379.21 0.00 1,920.79 79.35 403-250-523.101 Life/Health Insurance 16,200.00 16,200.00 13,625.76 0.00 2,574.24 84.11 403-250-524.100 Workers' Comp Insurance 4,300.00 5,890.00 5,887.05 0.00 2.95 99.95 Personal Services 121,000.00 121,000.00 98,532.57 0.00 22,467.43 81.43 Total Dept 250 - Storm Water Utilities 225,600.00 262,217.50 196,955.54 42,285.00 22,976.96 91.24 Dept 411 - Renewal & Replacement Operating Expenditures/Expense 403-411-531.302 Engineering Services 25,000.00 23,000.00 11,081.06 1,684.25 10,234.69 55.50 403-411-546.308 Drainage Maintenance 100,000.00 113,732.50 110,481.25 0.00 3,251.25 97.14 Operating Expenditures/Expense 125,000.00 136,732.50 121,562.31 1,684.25 13,485.94 90.14 Total Dept 411 - Renewal & Replacement 125,000.00 136,732.50 121,562.31 1,684.25 13,485.94 90.14 Dept 950 - Other Nonoperating Operating Expenditures/Expense 403-950-559.301 Budgeted Depreciation (netted 108,000.00 108,000.00 0.00 0.00 108,000.00 0.00 Operating Expenditures/Expense 108,000.00 108,000.00 0.00 0.00 108,000.00 0.00 Total Dept 950 - Other Nonoperating 108,000.00 108,000.00 0.00 0.00 108,000.00 0.00 TOTAL EXPENDITURES 458,600.00 506,950.00 318,517.85 43,969.25 144,462.90 71.50 Fund 403 - Stormwater Utility: AL REVENUES 458,600.00 506,950.00 442,852.81 0.00 64,097.19 87.36 AL EXPENDITURES 458,600.00 506,950.00 318,517.85 43,969.25 144,462.90 71.50 IT OF REVENUES & EXPENDITURES 0.00 0.00 124,334.96 (43,969.25) (80,365.71) 100.00 N 0) W O h 46 00 01 08/15/2019 04:34 PM User: tracanati DB: Tequesta GL NUMBER DESCRIPTION Fund 605 - Special Law Enforcement Revenues Dept 990 - Other/Reserve/Contingency Other Financing Sources 605-990-399.999 Appropriate Fund Balance Other Financing Sources Total Dept 990 - Other/Reserve/Contingency TOTAL REVENUES Expenditures Dept 171 - Police Operating Expenditures/Expense 605-171-540.300 Travel & Per Diem 605-171-549.300 Other Misc Chgs & Obligation 605-171-552.302 Small Tools and Equipment 605-171-554.301 Personnel Training Operating Expenditures/Expense Capital Outlay 605-171-664.600 Mach/Equipment Capital Outlay Total Dept 171 - Police TOTAL EXPENDITURES Fund 605 - Special Law Enforcement: TOTAL REVENUES TOTAL EXPENDITURES NET OF REVENUES & EXPENDITURES TOTAL REVENUES - ALL FUNDS TOTAL EXPENDITURES - ALL FUNDS OF REVENUES & EXPENDITURES (Q (D IV C) �A O 00 01 REVENUE AND EXPENDITURE REPORT FOR VILLAGE PERIOD ENDING 07/31/2019 2018-19 ORIGINAL 2018-19 BUDGET AMENDED BUDGET OF TEQUESTA YTD BALANCE 07/31/2019 NORM (ABNORM) ENCUMBERED YEAR-TO-DATE Page: 28/28 UNENCUMBERED BALANCE D (Q (D $ BDW USF.➢ 3 0.00 32,652.00 0.00 0.00 32,652.00 0.00 0.00 32,652.00 0.00 0.00 32,652.00 0.00 0.00 32,652.00 0.00 0.00 32,652.00 0.00 0.00 32,652.00 0.00 0.00 32,652.00 0.00 0.00 8,782.00 0.00 8,386.00 396.00 95.49 s 0.00 500.00 0.00 500.00 0.00 100.00 0.00 17,470.00 4,250.00 13,220.00 0.00 100.00 0.00 1,700.00 0.00 1,700.00 0.00 100.00 0.00 28,452.00 4,250.00 23,806.00 396.00 98.61 0.00 4,200.00 4,195.89 0.00 4.11 99.90 0.00 4,200.00 4,195.89 0.00 4.11 99.90 0.00 32,652.00 8,445.89 23,806.00 400.11 98.77 0.00 32,652.00 8,445.89 23,806.00 400.11 98.77 0.00 32,652.00 0.00 0.00 32,652.00 0.00 0.00 32,652.00 8,445.89 23,806.00 400.11 98.77 0.00 0.00 (8,445.89) (23,806.00) 32,251.89 100.00 24,997,650.00 24,817,055.00 17,389,829.75 0.00 7,427,225.25 70.07 24,997,650.00 24,817,055.00 15,103,566.69 1,803,006.32 7,910,481.99 68.12 0.00 0.00 2,286,263.06 (1,803,006.32) (483,256.74) 100.00 Agenda Item #10. Page 265 of 485 Agenda Item #10. Department Reports (July 2019) Village CloWs Office 19 -Jul YTD 2018 Agendas Compiled and Distribute 5 31 39 Summer Camp Registration 45 45 Council/Comm Meeting Hours 6.75 38.5 62.75 Orders Processed 3 17 48 Ages 5-7 13 13 Resolutions Processed 10 25 35 Ages 7-12 32 32 Ordinances Processed 1 10 11 Ages New Famili, 6 6 Agreements Processed 9 28 65 Revenue $46,687.50 Legal Advertisements Recreation Programs Legal Notices 2 27 38 Tai Chi Classes 14 14 Bids/RFPs 0 1 3 Yoga Classes 20 20 Public Records Processed 26 136 226 Tennis Classes 13 13 Lien Request Processed 42 303 539 Fencing Classes 8 8 Imaged/scanned pages 1983 7384 10917 Gymnastics Classes 0 0 Open Gym Classes 0 0 Ninja Scouts Classes 0 0 Homeschool Classes 0 0 Mah Jongg Program 0 0 Revenue Public Information Officer Facility Rentals Facebook Posts 33 233 426 Constitution Parl 3 1 Facebook Message Resposes 15 141 410 Recreation Cent( 1 1 Facebook Followers 3308 3308 unk Tequesta Park Page Views 738 Link unk Groups 3 3 Post Engagement 2219 19010 unk Reservatior 3 0 Revenue Press Releases 1 4 3 Special Events CodeRed Messages Launched 3 15 N/A Tequesta Fest: Saturday, Nov. 30th, 12:00pm - 5:00pm Smoke Signals 1 3 4 Food Trucks: Begins Oct. 4th, 5:00pm - 9:00pm Clerk/1310 Events & Meetings: New Manager Welcome event, Tequesta Business Assoc/Hobe Sound Chbr meeting and kick off event planning, Orange Lien Data meetin Line Maintenance 9 1 Station Maintenance 273 1,059 Equipment Maintenance 2 2 Daily Training 664 735 Work Orders (Non Meter) 7 6 Company Training 122 107.03 Employee Call Back 11 4 Multi Company Training 0 0 Valves Exercised 10 9 Officer Development Training 114 105.5 Service Repairs 1 1 Driver & Operator Training 51 108.75 Meter Set/Changed Out 13 5 Hazmat Training 7.5 51 Meter Reader Related Work Ord( 161 109 Other Training 12 6 Locates Performed 231 80 FF Admin Duties 811 919 Staff Vacancies (Days) 6.5 0 Unit Repose Data Fire 10 10 Customer Service 19 -!un 19-1ull EMS 77 68 New Accounts 45 46 SPOP's 2 1 Closed Accounts 42 51 Other 1 4 Work Orders Completed 209 230 Mutal Aid Given - PBCFR/ 4 6 Total Accounts Billed 5092 5102 Mutual Aid Received - PB 5 15 Aging Report Inspection Data 30 Days $18,901.95 $ 23,013.65 New Construction 14 15 60 Days $9,112.17 $ 11,514.90 Aunnual Fire 21 34 90 Days $15,199.07 $ 12,974.55 New Buisness/New Occup 1 2 180 Days $21,634.05 $ 22,275.32 Re -Inspections 9 9 Past Due Shutoff List (Slow Pay) 64 84 Food Truck/Tents 0 0 Amount $15,712.02 $ 17,522.63 Public Relations Events Data Page 266 of 485 Agenda Item #10. Bill Adjustment Report 9 Accounts 11 Accounts Community Functions 2 2 Amount Billed $501,404.57 $527,122.54 Station Tours 0 0 Water Usage 68,617 69,789 Walk -Ins 0 0 IT 19 -Jul Prior Month YTD Helpdesk Tickets 205 134 1111 Projects Council Chambers Telestaff Exchange 2016 FDLE Technical Audit Water Distribution 19 -Jun 19 -Jul YTD Water Production Total 78.921 MG 85.618 65.065 Communication Division Maximum Day 3.174 MG 3.134 2.769 Officer Initiated Calls 745 684 4910 Minimum Day 2.229 MG 2.335 1.747 Calls for Service 335 309 2903 Average Daily 2.631 MG 2.762 2.169 Fire Rescue 42 49 463 Backwash Water 1.645 MG 1.827 2.217 Patrol Division Monthly Total Gallons Flushed 2.175 MG 2.253 2.438 Reports Filed 32 17 209 Monthly Rainfall 10.98 (inches) 4.29 8.84 Arrest 8 4 49 Projects Crashes lnvestivated 10 6 111 New Caustic Feed System Complete and Online as part of the $1.8 million Watei Traffic Stops 279 186 2049 Temporary Acid feed tank online to facilitate the demo and replacement of the Citations 63 33 449 Annual Consumer Confidence Report completed and delivered 6/28/2019 Warnings 79 31 526 Human Resources 19 -Jun 19 -Jul YTD Administration Open Positions 8 7 27 Open Positions 1 1 1 Applications Rec'd 42 105 929 Resignations 0 0 2 Onboardings (hires) 1 3 26 Public Records Request 44 30 329 Offboardings (Terms) 2 0 17 Payroll Authorizations 19 31 - Community Development 19 -Jun 19 -Jul EE Benefit Chgs & Verifications 75 34 - Land Development Applications 8 7 EE Recognition - Individual 19 16 159 Board Meetings 1 1 EE Recognition - Group 0 0 3 Ongoing Projects 4 3 Training (Headcount) 12 10 89 10 Year Water Supply Plan 1 1 FMLA Requests 1 1 8 Non Ad Valorem (NAV) Work Comp Claims 0 1 5 Annexation Research N/A Lawsuits 2 1 5 ADA Compliance Documents 4 Policy/Handbook updates 1 2 Major Meetings/Conference Calls 5 6 Records Requests 2 3 18 Lighthouse Art Center 2 2 HRIS Adjustments 1018 1600 11,660 (2GHO) - Reserve and Seaglass 3 3 Newsletter 1 1 5 Phil Perko - Seaglass 1 1 Safety Mtgs & Rpts 0 1 3 Herb Evans 1 Auto, Property, Liability Claims 0 0 5 DRC Meeting 1 Permits (New Single Family and C. 8 4 Properties & Areas Mowed 4x per month 33 33 Phone Calls/Emails/Walk-Ins 85 72 Properties Trimmed Hedges 5 19 Properties Trimmed Palms, Trees 5 10 Flowers Planted 66 0 Properties Fertilized 6 2 Landscape equipment maintenance frequency per month 1 1 Sidewalk Repairs/Grinding 5 0 Street Signs Replaced 6 2 Road Repairs 4 1 Pet Pots Maintained 2x per week 8 8 Page 267 of 485 Agenda Item #10. Banners Hung 25 16 Outdoor lights Repaired 5 11 Street Light Outages 0 0 Work Orders 0 49 Standby Generator Maintenance 2 2 Fleet Maintenance/Vehicles Serviced 15 19 Surplus - Junked or Sold lems 37 8 Utility Locates 811 Dig 6 1 Engineering Services 1 2 Customer Calls 9 17 Event Set-up 5 5 Projects 9 10 Building Dept. 19 -Jun 19 -Jul YTD In -Office Meetings With Residents 16 34 Permits Issued 143 139 New Residential Permits 0 0 Residential Remodel Permits 56 23 New Construction Permits 0 0 Commercial Remodel Permits 15 9 Trade Permits 72 73 Residential Plan Reviews 56 130 Commercial Plan Reviews 15 9 Total Inspections 263 283 Certificates of Compliance 98 23 Over the Counter 29 48 Electronic 114 91 Building permit fees 53,788.71 49,184.83 Expenditures $43,145.25 $42,380.62 Building fees minus expenditures $10,643.46 $6,804.21 Building Permits average turnaround 48 hrs 48 hrs Complaints 2 3 Record Requests 11 18 Permit/Code Information Requests 24 23 Regular Council Meetings 1 1 Council Workshop Meetings 1 1 FFMA-ASFPM Meetings/Training 1 2 BCAIB-BOAF-BOATC/ DBPR Meetings 2 2 Code Enforcement Inspections 23 15 Notices of Violation Issued 12 6 High grass and weeds 2 6 Rubbish and accumulation 0 1 Junked vehicles 0 1 easement violation 0 1 Illegal RV/camper/trailer parking 5 5 Dangerous structure 1 0 Stagnant water 0 0 Illegal water drainage 1 1 Obstructed view 1 0 Other 6 10 Code Cases Opened 16 23 Code Cases Closed 13 15 Code Cases Cleared Within 30 Days 14 15 Code Cases Scheduled for Hearing 2 2 Magistrate Meeting 1 1 Meeting With Residents Re Violations 17 21 Page 268 of 485 Agenda Item #10. Buildint Dept June Year to Date (IFY) Prior Year Total (FY) Permits and Reviews In -Office Meetings With Residents 16 Permits Issued 143 New Residential Permits 0 Residential Remodel Permits 56 New Construction Permits 0 Commercial Remodel Permits 15 Trade Permits 72 Page 269 of 485 Agenda Item #10. Residential Plan Reviews 56 Commercial Plan Reviews 15 Total Inspections 263 Certificates of Compliance 98 Permit Application Over The Counter 29 Electronic 114 Building Permit Valuations and Turnaround Building Permit Fees 53,788.71 Expenditures $43,145.25 Building Fees Minus Expenditures $10,643.46 Building Permits Average Turnaround 48 hrs Complaints 2 Request for Information Record Request 11 Permit/Code Information Request 24 Code Enforcement Activity Code Enforcement Inspections 23 Notices of Violation Issued 12 High grass and weeds 2 Rubbish and accumulation 0 Junked vehicles 0 easement violation 0 Illegal RV/camper/trailer parking 5 Dangerous structure 1 Stagnant water 0 Illegal water drainage 1 Obstructed view 1 Other 6 Code Cases Opened 16 Code Cases Closed 13 Code Cases Cleared Within 30 Days 14 Code Cases Scheduled for Hearing 2 Magistrate Meeting 1 Meeting With Residents Re Violations 17 Page 270 of 485