Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Handouts_Workshop_08_06/29/2017
The Village of Tequesta Proposed Budget- DRAFT FY2 018 Proposed Fiscal Year 2018 Budget - DRAFT General Fund #001 lit vtO F TFQGNi 9r4,' /II FCC � v,-4: F r l..fr. I l �z ®Q 'A ,4 , ` �`��.. S L.�\�`a --ic - ,..y - y ti covN The Village of Tequesta Proposed Budget - DRAFT FY2018 VILLAGE OF TEQUESTA General Fund #001 Dept. 100 - Village Council SUMMARY FY 2015 FY 2016 FY 2016 FY 2017 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: - - - - N/A EXPENDITURES: Personnel - - - - N/A Operating 32,871 53,100 52,960 58,050 9.32% Capital - - - - N/A Total Expenditures: 32,871 53,100 52,960 58,050 9.32% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time - -Part Time - - - Total Employees: - - - Explanation of Significant Changes Operating Expenditures: Ordinance 2-15, effective October 1, 2015, changed the amount of the monthly fees that the Village Council receives. BUDGET WORKSHEET Page: 1 6/28/2017 Village of Tequesta 12:11 pm Prior Current Year -- (6) (7) (8) Year Original Amended Actual Thru Estimated the 6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT 'rind: 001-General Fund Expenditures Dept: 100 Council Acct Class: 510 Personal Services 514.350 Overtime-Disaster 0 0 0 0 0 Personal Services 0 0 0 0 0 0 0 0 Acct Class: 530 Operating Expenditures/Expense 531.311 Council Fees-Arena 5,100 7,300 7,300 5,436 7,272 7,450 7,450 531.313 Council fees-T.Patemo 3,000 5,200 5,200 3,336 5,172 7,450 7,450 531.314 Council fees-F.D'Ambra 5,100 7,300 7,300 5,436 7,272 7,450 7,450 531.316 Council fees-S.Okun 5,100 7,300 7,300 5,436 7,272 7,450 7,450 531.317 Council Fees-Brennan 3,000 5,200 5,200 3,336 5,172 7,450 7,450 540.301 Council Expenses-Arena 1,183 3,000 2,250 605 2,250 3,000 3,000 540.304 Council Expense-F.D'Ambra 500 3,000 2,500 109 2,500 3,000 3,000 540.306 Council Expense-S.Okun 583 3,000 3,000 318 3,000 3,000 3,000 540.307 Council Expenses-Brennan 3,450 3,000 3,000 2,645 3,000 3,000 3,000 540.308 Council Expenses- Patemo 0 3,000 3,000 25 3,000 3,000 3,000 549.300 Other Misc Chgs&Obligations 624 700 700 548 700 700 700 549.350 Volunteer Appreciation 1,171 1,400 1,400 890 1,400 1,400 1,400 '4.300 Books,Publ,Subs&Membership 3,060 3,700 3,700 3,531 3,700 3,700 3,700 2.800 Aid to Community Organizations 0 0 0 0 0 582.801 Aid to Com.Org-Arena 500 0 750 750 750 582.804 Aid to Community Org-D'Ambra 500 0 500 500 500 582.807 Aid to Com.Org.-Brennan 0 0 0 0 0 582.808 Aid to Com.Org.-Patemo 0 0 0 0 0 Operating Expenditures/Expense 32,871 53,100 53,100 32,901 52,960 58,050 58,050 0 Council 32,871 53,100 53,100 32,901 52,960 58,050 58,050 0 Total Expenditures 32,871 53,100 53,100 32,901 52,960 58,050 58,050 0 General Fund -32,871 -53,100 -53,100 -32,901 -52,960 -58,050 -58,050 0 Grand Total: -32,871 -53,100 -53,100 -32,901 -52,960 -58,050 -58,050 0 The Village of Tequesta Proposed Budget- DRAFT FY2 018 VILLAGE OF TEQUESTA General Fund #001 Dept. 110 - Village Manager SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: - - - - N/A EXPENDITURES: Personnel 211,986 219,760 223,328 232,300 5.71% Operating 2,831 4,740 5,078 4,750 0.21% Capital - - - - N/A Total Expenditures: 214,817 224,500 228,406 237,050 5.59% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time 1.50 1.50 1.50 Part Time - - - Total Employees: 1.50 1.50 1.50 Explanation of Significant Changes Personnel:This increase is primarily due to employee salary increases, projected increases in health insurance premiums and increased defined benefit pension contribution rates. Operating Expenditures:This Department has no significant changes in operating expenditures. BUDGET WORKSHEET Page: 14 6/28/2017 Village of Tequesta 11:49 am Prior --- - -Current Year -- --- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 110 Manager Acct Class: 510 Personal Services 512.100 Regular Salaries&Wages 146,835 153,900 153,760 106,448 153,760 160,900 160,900 514.100 Overtime 0 0 0 0 0 514.350 Overtime-Disaster 0 0 0 0 0 515.103 Bonus Pay Plan 8,250 750 750 750 750 1,000 1,000 515.108 Auto Allowance 3,000 3,000 3,000 2,250 3,000 3,000 3,000 515.125 Other Allowances 1,200 1,200 1,200 900 1,200 1,200 1,200 516.100 Compensated Absences 1,100 1,750 1,750 5,318 5,318 6,000 2,500 516.105 Compensated Absences-HSA 0 0 0 0 0 521.101 FICA Taxes 7,559 7,900 8,200 5,989 8,200 8,600 8,400 521.102 Medicare Taxes 2,501 2,400 2,600 1,807 2,600 2,600 2,500 522.102 VOT Pension Contributions 10,983 16,500 16,410 11,358 16,410 18,100 18,100 523.101 Life/Health Insurance 19,652 20,900 20,825 17,289 20,825 22,800 22,800 523.105 HSA-Health Savings Account 0 0 0 0 0 524.100 Workers'Comp Insurance 237 250 250 245 250 300 300 526.104 ICMA-Def Comp Plan 10,669 11,200 11,015 7,623 11,015 11,600 11,600 301 Personnel Training 0 0 0 0 0 Personal Services 211,986 219,750 219,760 159,977 223,328 236,100 232,300 0 Acct Class: 530 Operating Expenditures/Expense 540.300 Travel&Per Diem 0 0 0 0 0 546.320 Computer system maint&suppli 0 800 800 1,138 1,138 800 800 549.300 Other Misc Chgs&Obligations 544 250 240 23 240 250 250 554.300 Books,Publ,Subs&Membership 2,287 3,700 3,700 2,289 3,700 3,700 3,700 Operating Expenditures/Expense 2,831 4,750 4,740 3,450 5,078 4,750 4,750 0 Acct Class: 590 Other Financing Sources&Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.601 Computer Equipment 0 0 0 0 0 Capital Outlay 0 0 0 0 0 0 0 0 Manager 214,817 224,500 224,500 163,427 228,406 240,850 237,050 0 The Village of Tequesta Proposed Budget- DRAFT FY2018 VILLAGE OF TEQUESTA General Fund #001 Dept. 111 - Human Resources SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: - - - - N/A EXPENDITURES: Personnel 212,472 247,332 245,493 272,600 10.22% Operating 11,927 27,934 28,007 28,800 3.10% Ca pital 1,320 1,334 1,333 15,000 1024.44% Total Expenditures: 225,719 276,600 274,833 316,400 14.39% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time 2.00 2.00 2.25 Part Time - - Total Employees: 2.00 2.00 2.25 Explanation of Significant Changes Personnel: This increase is primarily due to an increase in the number of full time employees in the department. The increase also includes increases in existing employee salaries, projected health insurance premiums and defined benefit pension contribution rates. Operating: This increase is primarily due to the addition of contractual service fees for risk management services. BUDGET WORKSHEET Page: 15 6/28/2017 Village of Tequesta 11:49 am Prior Current Year------------------ (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 111 Human Resources Acct Class: 510 Personal Services 512.100 Regular Salaries&Wages 134,914 148,700 148,700 102,065 148,600 161,800 167,000 514.350 Overtime-Disaster 0 0 0 0 0 515,103 Bonus Pay Plan 750 1,500 1,500 1,500 1,500 1,700 1,700 515.107 Part-time Salaries 0 6,750 432 190 191 515.120 Cell phone allowance 1,200 1,200 1,200 877 1,200 1,200 1,200 516.100 Compensated Absences 2,618 2,800 2,800 2,452 2,452 2,800 3,300 516.105 Compensated Absences-HSA 0 0 0 0 0 521.101 FICA Taxes 8,342 9,800 9,800 6,317 9,200 10,300 10,600 521.102 Medicare Taxes 1,951 2,700 2,700 1,477 2,150 2,400 2,500 522.102 VOT Pension Contributions 10,092 15,900 15,900 10,890 15,900 18,200 18,700 523.101 Life/Health Insurance 26,574 28,200 28,200 23,390 28,200 28,500 28,500 523.105 HSA-Health Savings Account 0 0 0 0 0 524.100 Workers'Comp Insurance 223 250 250 226 250 300 300 525.100 Unemployment Compensation 0 0 0 0 0 526.101 Employee Recognition Program 6,824 12,000 12,000 7,400 12,000 12,000 12,000 102 Employee Assistance Program 15,406 10,200 10,200 6,215 10,200 11,300 11,300 0L8.103 Education Reimbursement Prgm 0 1,000 250 0 250 1,500 1,500 554.301 Personnel Training 1,485 3,000 3,400 3,384 3,400 4,000 4,000 554.310 Employee Development 2,093 10,000 10,000 8,812 10,000 10,000 10,000 Personal Services 212,472 254,000 247,332 175,195 245,493 266,000 272,600 0 Acct Class: 530 Operating Expenditures/Expense 534.300 Other Contractual Services 408 500 5,084 5,156 5,157 7,000 7,000 540.300 Travel&Per Diem 1,710 2,500 3,250 2,782 3,250 4,000 4,000 546.320 Computer system maint&suppli 9,034 15,000 15,000 12,070 15,000 14,200 14,200 547.300 Printing&Binding 0 1,500 1,500 0 1,500 1,500 1,500 549.300 Other Misc Chgs&Obligations 275 500 500 0 500 500 500 549.401 Recruitment expenses 160 1,500 1,500 44 1,500 500 500 552.302 Small Tools and Equipment 0 500 500 0 500 500 500 554.300 Books,Publ,Subs&Membership 340 600 600 190 600 600 600 Operating Expenditures/Expense 11,927 22,600 27,934 20,242 28,007 28,800 28,800 0 Acct Class: 590 Other Financing Sources&Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 ord Class: 600 Capital Outlay (301 Computer Equipment 1,320 0 1,334 1,333 1,333 15,000 15,000 Capital Outlay 1,320 0 1,334 1,333 1,333 15,000 15,000 0 Human Resources 225,719 276,600 276,600 196,770 274,833 309,800 316,400 0 The Village of Tequesta Capital Requests Fiscal Year 2018 .and: 001 - General Fund - Capital $ 15,000.00 Dept: 111 Human Resources 664.601 Computer Equipment $ 15,000.00 Integration Software for BSA/BambooHR $ 15,000.00 1 The Village of Tequesta Proposed Budget- DRAFT FY2 018 VILLAGE OF TEQUESTA General Fund #001 Dept. 120 - Village Clerk SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: - - - - N/A EXPENDITURES: Personnel 189,019 227,736 227,838 248,600 9.16% Operating 24,065 47,164 42,541 65,250 38.35% Capital - - - - N/A Total Expenditures: 213,084 274,900 270,379 313,850 14.17% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time 2.00 3.00 2.75 Part Time 1.00 - - Total Employees: 3.00 3.00 2.75 Explanation of Significant Changes Personnel: This increase is primarily due to an increase in the number of full time employees in the department. This increase also includes increases in existing employee salaries, projected health insurance premiums and defined benefit pension contribution rates. Operating: The Village was not required to hold an election in FY2017. Funds for that election were transferred into personnel expenditures to fund additional staffing. The increase in the FY2018 operating expenditures is the result of adding the election funds back into the Clerk's operating accounts. BUDGET WORKSHEET Page: 16 6/28/2017 Village of Tequesta 11:49 am Prior - -Current Year-- --- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 120 Village Clerk Acct Class: 510 Personal Services 512.100 Regular Salaries&Wages 118,714 127,600 151,250 100,434 151,215 166,800 166,800 514.100 Overtime 0 1,100 1,100 306 1,000 1,100 1,100 514.350 Overtime-Disaster 0 0 0 827 827 515.103 Bonus Pay Plan 750 1,100 1,100 750 750 1,400 1,400 515.107 Part-time Salaries 24,497 27,600 9,086 9,086 9,086 515.108 Auto Allowance 3,000 3,000 3,000 2,192 3,000 3,000 3,000 516.100 Compensated Absences 339 0 0 0 0 516.105 Compensated Absences-HSA 0 0 0 0 0 521.101 FICA Taxes 9,032 9,700 9,800 6,733 9,800 10,400 10,400 521.102 Medicare Taxes 2,112 2,300 2,350 1,575 2,350 2,500 2,500 522.102 VOT Pension Contributions 8,874 13,700 16,150 10,711 16,130 18,700 18,700 523.101 Life/Health Insurance 17,276 21,100 27,600 21,692 27,415 39,300 39,300 523.105 HSA-Health Savings Account 0 0 0 0 0 524.100 Workers'Comp Insurance 199 250 250 248 250 300 300 525.100 Unemployment Compensation 0 0 1,650 825 825 '03 Education Reimbursement Prgm 2,036 3,000 3,000 3,000 3,000 3,000 3,000 oD4.301 Personnel Training 2,190 1,400 1,400 1,898 2,190 2,100 2,100 Personal Services 189,019 211,850 227,736 160,277 227,838 248,600 248,600 0 Acct Class: 530 Operating Expenditures/Expense 531.303 Codification Services 3,391 5,800 5,800 1,866 3,391 6,100 6,100 531.304 Recording Secy Service 0 0 0 0 0 534.301 Election Expense 1,368 18,050 1,132 1,145 1,650 18,100 18,100 534.302 Legal Advertising 6,236 13,800 13,800 2,728 13,000 13,800 13,800 534.304 Public Records Requests 0 0 0 0 0 534.311 Election exp.-annexations 0 0 0 0 0 540.300 Travel&Per Diem 260 4,000 4,000 3,668 4,000 4,800 4,800 541.300 Communication Services 963 1,300 1,300 977 1,300 1,400 1,400 546.320 Computer system maint&suppli 6,747 10,750 11,550 9,188 11,550 11,550 11,550 548.110 Marketing and Public Relations 1,760 3,200 3,200 1,286 3,000 3,200 3,200 549.100 Miscellaneous Archival 0 2,500 2,500 0 1,000 2,500 2,500 549.201 Advertising&Promotion 0 0 0 0 0 549.300 Other Misc Chgs&Obligations 1,782 2,250 2,250 973 2,250 2,300 2,300 552.302 Small Tools and Equipment 594 500 500 0 500 500 500 °").306 Microfilm Service/Supplies 0 0 0 0 0 ..300 Books,Publ,Subs&Membership 964 900 900 375 900 1,000 1,000 Operating Expenditures/Expense 24,065 63,050 46,932 22,206 42,541 65,250 65,250 0 Acct Class: 590 Other Financing Sources&Uses BUDGET WORKSHEET Page: 17 6/28/2017 Village of Tequesta 11:49 am Prior —Current Year-- ---- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 120 Village Clerk Acct Class: 590 Other Financing Sources&Uses 599.100 Budget Cost Sayings 0 0 232 0 0 Other Financing Sources&Uses 0 0 232 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.601 Computer Equipment 0 0 0 0 0 Capital Outlay 0 0 0 0 0 0 0 0 Village Clerk 213,084 274,900 274,900 182,483 270,379 313,850 313,850 0 The Village of Tequesta Proposed Budget - DRAFT FY2018 VILLAGE OF TEQUESTA General Fund #001 Dept. 130 - Finance SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: - - - - N/A EXPENDITURES: Personnel 347,990 336,394 336,225 351,350 4.45% Operating 46,473 71,182 71,182 55,300 -22.31% Capital - 1,574 1,685 15,000 852.99% Total Expenditures: 394,463 409,150 409,092 421,650 3.06% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time 4.00 3.50 3.50 Part Time - - - Total Employees: 4.00 3.50 3.50 Explanation of Significant Changes Personnel:This increase is primarily due to employee turnover in the Finance Director position. This increase is offset by a reduction in compensated absences (also related to the employee turnover in the Finance Director position). This increase also includes increases in employee salaries, projected health insurance premiums and defined benefit pension contribution rates. Operating:This decrease is primarily due to a decrease in other contractual service fees (also related to the employee turnover in the Finance Director position). BUDGET WORKSHEET Page: 18 6/28/2017 Village of Tequesta 11:49 am Prior ------- Current Year------------------ (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 130 Finance Acct Class: 510 Personal Services 512.100 Regular Salaries&Wages 254,794 225,400 224,300 153,849 224,300 239,800 242,200 514.100 Overtime 0 0 0 0 0 514.350 Overtime-Disaster 0 0 0 0 0 515.103 Bonus Pay Plan 2,250 1,400 1,875 1,875 1,875 1,700 1,750 515.120 Cell phone allowance 600 600 600 346 531 600 600 516.100 Compensated Absences 785 31,500 18,269 18,268 18,269 5,000 5,000 516.105 Compensated Absences-HSA 0 0 0 0 0 521.101 FICA Taxes 14,973 15,700 14,500 9,872 14,500 14,800 15,100 521.102 Medicare Taxes 3,616 3,700 3,700 2,432 3,600 3,500 3,600 522.102 VOT Pension Contributions 19,059 21,900 23,950 16,420 23,950 26,900 27,200 523.101 Life/Health Insurance 48,929 46,500 45,350 37,437 45,350 57,400 51,000 523.105 HSA-Heath Savings Account 0 0 0 0 0 524.100 Workers'Comp Insurance 447 450 450 425 450 500 500 525.100 Unemployment Compensation 0 0 0 0 0 554.301 Personnel Training 2,537 4,400 3,400 1,474 3,400 4,400 4,400 Personal Services 347,990 351,550 336,394 242,398 336,225 354,600 351,350 0 Acct Class: 530 Operating Expenditures/Expense 532.300 Accounting&Auditing Services 26,173 25,600 27,320 27,319 27,320 26,200 26,200 534.300 Other Contractual Services 0 0 15,642 15,642 15,642 540.300 Travel&Per Diem 1,184 1,500 1,500 467 1,500 1,500 1,500 546.301 Office Equip/Repair&Maint 511 900 900 354 900 900 900 546.320 Computer system maint&suppli 14,299 13,000 17,926 15,056 17,926 16,600 16,600 547.300 Printing&Binding 1,851 3,000 1,720 1,121 1,720 3,000 3,000 549.300 Other MiscChgs&Obligations 7 1,000 1,817 1,513 1,817 1,000 1,000 551.300 Office Supplies&Equipment 1,414 4,000 2,257 1,614 2,257 4,000 4,000 552.302 Small Tools and Equipment 0 500 500 481 500 500 500 554.300 Books,Publ,Subs&Membership 1,034 1,600 1,600 689 1,600 1,600 1,600 Operating Expenditures/Expense 46,473 51,100 71,182 64,256 71,182 55,300 55,300 0 Acct Class: 590 Other Financing Sources&Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.601 Computer Equipment 0 0 1,574 1,685 1,685 15,000 15,000 Capital Outlay 0 0 1,574 1,685 1,685 15,000 15,000 0 Finance 394,463 402,650 409,150 308,339 409,092 424,900 421,650 0 The Village of Tequesta Capital Requests Fiscal Year 2018 .and: 001 - General Fund - Capital $ 15,000.00 Dept: 111 Human Resources Dept: 130 Finance 664.601 Computer Equipment $ 15,000.00 Integration Software for BSA/BambooHR $ 15,000.00 The Village of Tequesta Proposed Budget - DRAFT FY2 018 VILLAGE OF TEQUESTA General Fund #001 Dept. 140 - Legal SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: - - - - N/A EXPENDITURES: Personnel - - - - N/A Operating 202,798 150,000 180,000 160,000 6.67% Capital - - - - N/A Total Expenditures: 202,798 150,000 180,000 160,000 6.67% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time - - - Part Time - - - Total Employees: - - - Explanation of Significant Changes Operating: The Village has experienced an increase in legal fees relating to personnel issues. BUDGET WORKSHEET Page: 19 6/28/2017 Village of Tequesta 11:49 am Prior Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated •6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 140 Legal Acct Class: 510 Personal Services 514.350 Overtime-Disaster 0 0 0 0 0 Personal Services 0 0 0 0 0 0 0 0 Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 76,309 90,000 90,000 54,933 70,000 90,000 80,000 531.308 Legal fees-Personnel 126,489 60,000 60,000 109,205 110,000 80,000 80,000 Operating Expenditures/Expense 202,798 150,000 150,000 164,138 180,000 170,000 160,000 0 Acct Class: 590 Other Financing Sources&Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Finandng Sources&Uses 0 0 0 0 0 0 0 0 Legal 202,798 150,000 150,000 164,138 180,000 170,000 160,000 0 The Village of Tequesta Proposed Budget - DRAFT FY2 018 VILLAGE OF TEQUESTA General Fund #001 Dept. 150 - Comprehensive Planning SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: 57,007 35,000 60,061 45,000 28.57% EXPENDITURES: Personnel - - - - N/A Operating 191,143 181,500 214,500 191,150 5.32% Capital - - - - N/A Total Expenditures: 191,143 181,500 214,500 191,150 5.32% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time - - - Part Time - - - Total Employees: - - - Explanation of Significant Changes Revenues This increase is primarily due to increased contractual service fees incurred by the Village for plan review. These fees and any other additional costs necessary to complete the review process are paid by the Village and then billed to the applicant. Operating: This increase is primarily due to increased contractual service fees incurred by the Village for plan review. These fees and any other additional costs necessary to complete the review process are paid by the Village and then billed to the applicant. BUDGET WORKSHEET Page: 3 6/28/2017 Village of Tequesta 11:49 am Prior Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Revenues Dept: 150 Comprehensive Planning Acct Class: 340 Charges for Services 343.700 Water Conservation&Resource 0 0 0 0 0 Charges for Services 0 0 0 0 0 0 0 0 Acct Class: 341 Chgs for Sery-Gen Gov 341.150 Land Development Fees 57,007 35,000 35,000 58,480 60,000 45,000 45,000 Chgs for Sell/-Gen Gov 57,007 35,000 35,000 58,480 60,000 45,000 45,000 0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 0 0 0 61 61 Miscellaneous Revenues 0 0 0 61 61 0 0 0 Comprehensive Planning 57,007 35,000 35,000 58,541 60,061 45,000 45,000 0 BUDGET WORKSHEET Page: 20 6/28/2017 Village of Tequesta 11:49 am Prior Current Year ---- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 150 Comprehensive Planning Acct Class: 510 Personal Services 512.100 Regular Salaries&Wages 0 0 0 0 0 514.350 Overtime-Disaster 0 0 0 0 0 515.103 Bonus Pay Plan 0 0 0 0 0 516.100 Compensated Absences 0 0 0 0 0 521.101 FICA Taxes 0 0 0 0 0 521.102 Medicare Taxes 0 0 0 0 0 522.101 FRS Contributions 0 0 0 0 0 523.101 Life/Health Insurance 0 0 0 0 0 524.100 Workers'Comp Insurance 0 0 0 0 0 Personal Services 0 0 0 0 0 0 0 0 Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 24,854 20,000 20,000 20,378 25,000 20,000 20,000 531.321 Mapping Services 2,462 2,500 2,500 2,425 2,500 2,500 2,500 531.322 Misc Planning Service 143,379 143,550 143,550 94,558 143,550 147,700 147,700 531.326 Comp Plan Service 0 0 0 0 0 '331 Board of Adjustment 0 0 0 0 0 _1.332 Planning and Zoning Board 84 1,000 1,000 79 1,000 1,000 1,000 531.405 Legal-Annexation 0 0 0 0 0 534.300 Other Contractual Services 11,549 3,000 3,000 30,391 31,000 10,000 10,000 534.302 Legal Advertising 4,205 5,000 5,000 3,928 5,000 5,000 5,000 534.420 Legal Advertising-Annexation 0 0 0 0 0 546.320 Computer system maint&suppli 3,000 3,800 3,800 3,082 3,800 2,300 2,300 547.300 Printing&Binding 335 500 500 130 500 500 500 549.150 Miscellaneous annexation exp 0 0 0 0 0 549.300 Other Misc Chgs&Obligations 0 500 500 70 500 500 500 551.300 Office Supplies&Equipment 375 750 750 319 750 750 750 554.300 Books,Publ,Subs&Membership 900 900 900 900 900 900 900 Operating Expenditures/Expense 191,143 181,500 181,500 156,260 214,500 191,150 191,150 0 Acct Class: 590 Other Financing Sources&Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.601 Computer Equipment 0 0 0 0 0 Capital Outlay 0 0 0 0 0 0 0 0 Comprehensive Planning 191,143 181,500 181,500 156,260 214,500 191,150 191,150 0 The Village of Tequesta Proposed Budget - DRAFT FY2 018 VILLAGE OF TEQUESTA ` General Fund #001 T Dept. 160 - General Government SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: - - - - N/A EXPENDITURES: Personnel 129,868 148,000 141,107 5,600 -96.22% Operating 208,335 271,779 268,309 282,500 3.94% Capital - 59,471 59,471 19,300 -67.55% Total Expenditures: 338,203 479,250 468,887 307,400 -35.86% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time 0.80 0.80 Part Time 1.00 1.00 - Total Employees: 1.80 1.80 - Explanation of Significant Changes Personnel: Personnel expenditures for I.T. are being moved from Dept. 160 (General Government) to Dept. 161 (I.T.). Operating: This increase is primarily due to projected increases in auto, liability and property insurances and an increase in special events funding. BUDGET WORKSHEET Page: 21 6/28/2017 Village of Tequesta 11:49 am Prior ---Current Year -- --- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 160 General Government Acct Class: 510 Personal Services 512.100 Regular Salaries&Wages 73,034 75,900 75,900 51,985 75,090 127,600 514.350 Overtime-Disaster 0 0 0 177 177 515.103 Bonus Pay Plan 600 600 600 600 600 1,100 515.107 Part-time Salaries 20,966 26,000 26,000 19,448 28,225 515.120 Cell phone allowance 0 0 1,200 701 1,000 1,000 516.100 Compensated Absences 0 3,000 3,000 0 0 516.105 Compensated Absences-HSA 0 0 0 0 0 521.101 FICA Taxes 5,528 6,400 6,400 4,302 6,400 7,900 521.102 Medicare Taxes 1,293 1,500 1,500 1,006 1,500 1,900 522.102 VOT Pension Contributions 5,463 8,100 8,100 5,547 8,015 14,300 523.101 Life/Health Insurance 15,130 16,100 16,100 13,317 16,040 26,500 523.105 HSA-Health Savings Account 0 0 0 0 0 524.100 Workers'Comp Insurance 119 5,200 5,200 170 170 5,800 5,600 526.101 Employee Recognition Program 3 0 0 0 0 526.102 Employee Assistance Program 4,092 0 0 0 0 ;03 Education Reimbursement Prgm 2,890 3,000 3,000 2,890 2,890 3,000 054.301 Personnel Training 750 1,000 1,000 0 1,000 8,000 Personal Services 129,868 146,800 148,000 100,143 141,107 197,100 5,600 0 Acct Class: 530 Operating Expenditures/Expense 531.306 IT-Other Contractual Service 0 0 0 0 0 534.300 Other Contractual Services 23,036 20,500 20,500 15,457 20,400 22,000 22,000 534.303 Special Events 3,882 10,000 5,000 4,469 5,000 15,000 15,000 540.300 Travel&Per Diem 99 2,000 2,000 0 2,000 2,000 541.300 Communication Services 10,115 10,600 9,400 6,633 9,200 8,500 8,500 541.301 Postage 3,897 4,300 4,300 2,387 4,300 4,300 4,300 541.305 Website Maintenance 6,357 6,600 6,600 6,548 6,548 7,200 7,200 543.300 Utility Services 17,230 17,500 17,500 11,244 17,500 19,000 19,000 544.301 Operating Leases 5,207 48,150 48,150 36,556 48,100 48,100 48,100 545.300Insurance 69,997 79,900 79,900 80,421 80,421 87,900 87,900 546.301 Office Equip/Repair&Maint 1,862 3,000 3,000 1,536 3,000 3,000 3,000 546.302 Vehicle Repair&Maintenance 0 300 300 250 300 500 500 546.303 Building Repair&Maint 0 0 0 0 0 546.310 Equipment Repair&Maint 100 0 0 0 0 "6.320 Computer system maint&suppli 32,971 32,750 32,129 26,441 32,129 35,900 26,900 .300 Printing&Binding 1,567 2,000 2,000 687 2,000 2,000 2,000 549.300 Other Misc Chgs&Obligations 9,546 10,000 10,000 9,519 10,000 10,000 10,000 BUDGET WORKSHEET Page: 22 6/28/2017 Village of Tequesta 11:49 am Prior - Current Year - --- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 160 General Govemment Acct Class: 530 Operating Expenditures/Expense 549.302 Village Newsletter 9,433 19,000 19,000 10,659 16,500 17,500 17,500 549.304 Licenses,Fees&Permits 2,076 2,700 2,700 1,440 2,000 2,600 2,600 551.300 Office Supplies&Equipment 4,312 4,000 4,000 2,503 4,000 4,000 4,000 552.160 IT Operating Supplies 1,030 1,200 1,200 261 1,200 1,200 552.301 Gas&Oil 167 300 300 29 100 300 300 552.302 Small Tools and Equipment 2,995 1,000 1,000 333 1,000 1,000 1,000 554.300 Books,Publ,Subs&Membership 2,456 2,800 2,800 2,610 2,611 2,700 2,700 Operating Expenditures/Expense 208,335 278,600 271,779 219,983 268,309 294,700 282,500 0 Acct Class: 590 Other Financing Sources&Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 662.600 Buildings 0 0 0 0 0 664.600 Mach/Equipment 0 0 0 0 0 15,000 664.601 Computer Equipment 0 49,850 50,471 9,038 50,471 44,700 4,300 -602 Vehicles 0 0 0 0 0 ,.607 Equipment-Tech 0 9,000 9,000 0 9,000 Capital Outlay 0 58,850 59,471 9,038 59,471 44,700 19,300 0 General Govemment 338,203 484,250 479,250 329,164 468,887 536,500 307,400 0 The Village of Tequesta Capital Requests Fiscal Year 2018 ,and: 001 - General Fund - Capital $ 19,300.00 Dept. 160 General Government 664.600 Machinery& Equipment $ 15,000.00 Condensing Unit for Village Hall $ 15,000.00 664.601 Computer Equipment $ 4,300.00 vMware Hosts(2) $ 4,300.00 The Village of Tequesta Proposed Budget - DRAFT FY2 018 VILLAGE OF TEQUESTA General Fund #001 Dept. 161 - I.T. SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: - - - - N/A EXPENDITURES: Personnel - - - 187,500 N/A Operating - - - 3,200 N/A Capital - - - - N/A Total Expenditures: - - - 190,700 N/A Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time - - 1.80 Part Time - - - Total Employees: - - 1.80 Explanation of Significant Changes Personnel: This department is requesting to change a part time position to a full time position. This budget also includes increases for existing employee salaries, projected health insurance premiums and defined benefit pension contribution rates. Operating: The operating budget in this department is for I.T. supplies and travel and per diem expenditures. BUDGET WORKSHEET Page: 23 6/28/2017 Village of Tequesta 11:49 am Prior Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT .und: 001-General Fund Expenditures Dept: 161 IT Acct Class: 510 Personal Services 512.100 Regular Salaries&Wages 0 0 0 0 0 127,600 515.103 Bonus Pay Plan 0 0 0 0 0 1,100 515.107 Part-time Salaries 0 0 0 0 0 515.120 Cell phone allowance 0 0 0 0 0 1,000 516.100 Compensated Absences 0 0 0 0 0 521.101 FICA Taxes 0 0 0 0 0 7,900 521.102 Medicare Taxes 0 0 0 0 0 1,900 522.102 VOT Pension Contributions 0 0 0 0 0 14,300 523.101 Life/Health Insurance 0 0 0 0 0 26,500 524.100 Workers'Comp Insurance 0 0 0 0 0 200 526.103 Education Reimbursement Prgm 0 0 0 0 0 3,000 554.301 Personnel Training 0 0 0 0 0 4,000 Personal Services 0 0 0 0 0 0 187,500 0 Acct Class: 530 Operating Expenditures/Expense 540.300 Travel&Per Diem 0 0 0 0 0 2,000 160 IT Operating Supplies 0 0 0 0 0 1,200 Operating Expenditures/Expense 0 0 0 0 0 0 3,200 0 IT 0 0 0 0 0 0 190,700 0 The Village of Tequesta Proposed Budget - DRAFT FY2 018 VILLAGE OF TEQUESTA General Fund #001 Dept. 175 - Police SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: 42,169 57,263 38,555 28,100 -50.93% EXPENDITURES: Personnel 2,397,442 2,553,061 2,515,976 2,662,250 4.28% Operating 389,447 391,255 420,776 398,650 1.89% Capital 5,803 103,445 142,763 82,000 -20.73% Total Expenditures: 2,792,692 3,047,761 3,079,515 3,142,900 3.12% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time 23.00 25.00 25.00 Part Time* 5.00 4.50 4.50 Total Employees: 28.00 29.50 29.50 *Several P/T Communications Officers share(1)one part time position which is an "as needed"position. Explanation of Significant Changes Revenues: This decrease is primarily due to the elimination of PBC 911 revenues from the FY2018 budget. Personnel:This increase is primarily due to projected increases in employee salaries, projected health insurance premiums and coverage and defined benefit pension contribution rates. This increase is offset by decreases in compensated absences and FRS contributions related to employee turnover in the Detective position. Operating:This increase is primarily due to projected increases in auto, liability and property insurances. It is offset by a projected decrease in building repair costs. BUDGET WORKSHEET Page: 4 6/28/2017 Village of Tequesta 11:49 am Prior Current Year- - (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Revenues Dept: 171 Police Acct Class: 320 Licenses&Permits 329.102 Special Truck Permits 0 0 0 0 0 Licenses&Permits 0 0 0 0 0 0 0 0 Acct Class: 331 Grants Federal 331.210 FDLE-Federal Grant 0 0 0 0 0 Grants Federal 0 0 0 0 0 0 0 0 Acct Class: 334 Grants-State 334.201 State Police Block Grant 0 0 0 0 0 Grants-State 0 0 0 0 0 0 0 0 Acct Class: 335 Intergovernmental Revenue 338.201 PBC 911 Maint Reimbursement 0 8,000 8,000 0 0 338.202 PBC 911 DISPATCH REIMBURSEMENT 0 18,000 18,000 0 0 Intergovernmental Revenue 0 26,000 26,000 0 0 0 0 0 Acct Class: 337 Grants&Contributions-Local 366.122 Donations-Military to Main St 0 0 0 0 0 Grants&Contributions-Local 0 0 0 0 0 0 0 0 Acct Class: 342 Chgs for Sery-Public Safety '10 PBC-Marine law enforce.sery 16,660 16,600 20,263 20,323 20,323 16,600 16,600 Chgs for Sery-Public Safety 16,660 16,600 20,263 20,323 20,323 16,600 16,600 0 Acct Class: 351 Fines&Forfeitures 351.100 Court Fines 12,274 5,000 5,000 6,085 7,000 5,500 5,500 351.250 $12.50 traffic violation fund 5,424 5,500 5,500 4,706 5,500 5,500 5,500 354.101 Parking Tickets 1,180 500 500 655 800 500 500 354.102 Code Enf Fines&Court Costs 0 0 0 0 0 Fines&Forfeitures 18,878 11,000 11,000 11,446 13,300 11,500 11,500 0 Acct Class: 363 Impact Fees 362.221 Police Impact Fees 63 0 0 3,568 3,568 Impact Fees 63 0 0 3,568 3,568 0 0 0 Acct Class: 366 Contributions&Donations 366.100 Contrib&Donations&Sponsors 1,030 0 0 25 25 Contributions&Donations 1,030 0 0 25 25 0 0 0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 5,538 0 0 1,339 1,339 Miscellaneous Revenues 5,538 0 0 1,339 1,339 0 0 0 Police 42,169 53,600 57,263 36,701 38,555 28,100 28,100 0 BUDGET WORKSHEET Page: 24 6/28/2017 Village of Tequesta 11:49 am Prior - Current Year ---- -- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 175 Police Department Acct Class: 510 Personal Services 512.171 Sal&Wages-Adminstration 167,733 226,600 226,600 155,627 225,500 235,700 235,700 512.172 Reg Sal&Wages-Communicatio 231,230 199,600 190,100 131,260 190,600 199,100 199,100 512.175 Reg Sal&Wages-Operations 1,020,842 1,146,300 1,082,000 738,402 1,058,500 1,170,500 1,120,700 514.172 Overtime-Communications 28,518 23,000 23,000 7,980 16,000 25,000 20,000 514.175 Overtime-Operations 117,756 39,400 109,400 75,231 109,400 125,000 90,000 514.350 Overtime-Disaster 0 0 0 27,410 27,411 515.101 Holiday Pay 43,701 45,000 45,000 35,647 45,000 50,000 47,000 515.103 Bonus Pay Plan 10,000 9,000 9,000 9,500 9,000 7,800 9,500 515.106 Clothing&Boot Allowance 12,073 12,300 14,367 14,366 14,367 13,700 13,100 515.107 Part-time Salaries 0 0 3,570 1,330 3,570 7,100 7,100 515.108 Auto Allowance 8,500 12,000 12,000 8,885 12,000 12,000 12,000 515.120 Cell phone allowance 1,700 2,400 2,400 1,777 2,400 2,400 2,400 515.125 Other Allowances 16,400 8,400 8,400 6,300 8,400 8,400 8,400 515.172 PIT Salary-Communications 34,924 32,000 32,000 10,394 16,000 39,900 25,000 515.175 Pit Salary-Operations 94,833 56,200 74,000 54,805 74,000 70,200 70,200 00 Compensated Absences 10,376 8,000 47,898 47,898 47,898 8,000 8,000 516.105 Compensated Absences-HSA 0 0 0 0 0 521.101 FICA Taxes 107,412 108,300 108,300 77,340 108,300 117,600 113,200 521.102 Medicare Taxes 25,481 25,900 25,900 18,653 25,900 28,000 27,000 522.101 FRS Contributions 46,752 43,700 43,700 24,126 35,000 26,800 29,200 522.102 VOT Pension Contributions 53,581 61,600 61,600 43,182 61,600 136,900 136,100 522.105 Defined Contribution 48,522 66,100 71,800 49,096 71,800 81,400 76,800 522.110 Other Pension Contributions 0 0 0 0 0 523.101 Life/Health Insurance 258,902 322,100 300,426 246,316 294,000 364,900 343,300 523.105 HSA-Health Savings Account 1,120 1,100 1,100 810 1,080 1,100 1,100 524.100 Workers'Comp Insurance 32,305 38,250 38,250 38,230 38,250 42,100 42,100 525.100 Unemployment Compensation 3,300 0 0 0 0 526.101 Employee Recognition Program 1,464 3,000 3,000 1,997 2,500 3,000 3,000 526.103 Education Reimbursement Prgm 7,000 4,000 4,000 0 3,000 6,000 6,000 526.105 Employee PhysicaVPsycological 1,962 4,250 4,250 1,916 3,500 4,250 4,250 554.301 Personnel Training 11,055 12,000 11,000 7,093 11,000 12,000 12,000 Personal Services 2,397,442 2,510,500 2,553,061 1,835,571 2,515,976 2,798,850 2,662,250 0 Acct Class: 530 Operating Expenditures/Expense "301 Legal Services 0 0 0 0 0 ,.320 Code Enforcement Service 0 0 0 0 0 531.327 Other Contractual-MTMS 0 0 0 0 0 BUDGET WORKSHEET Page: 25 6/28/2017 Village of Tequesta 11:49 am Prior ---Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT .und: 001-General Fund Expenditures Dept: 175 Police Department Acct Class: 530 Operating Expenditures/Expense 534.300 Other Contractual Services 0 0 0 0 0 540.300 Travel&Per Diem 6,457 9,000 10,000 9,586 15,000 15,000 10,000 541.300 Communication Services 20,057 23,000 21,000 15,519 21,000 23,000 23,000 541.301 Postage 686 2,000 2,000 518 1,200 1,000 1,000 543.300 Utility Services 25,294 25,000 23,000 16,856 23,000 25,000 25,000 544.301 Operating Leases 1,833 2,000 2,000 1,500 2,000 2,000 2,000 545.300Insurance 60,709 53,650 53,650 53,559 53,650 59,100 59,100 545.310 Insurance Claims 0 0 0 5,000 5,000 546.175 K-9 Equipment&Maintenance 5,408 6,000 6,000 2,267 5,500 6,000 6,000 546.301 Office Equip/Repair&Maint 2,459 1,000 1,000 532 1,000 1,200 1,200 546.302 Vehicle Repair&Maintenance 19,331 18,000 20,000 20,304 20,251 21,000 20,000 546.303 Building Repair&Maint 42,079 35,000 59,068 39,065 59,068 75,500 45,000 546.304 Communication Equip Maint 29,283 30,600 30,813 25,717 30,600 38,400 30,600 546.310 Equipment Repair&Maint 3,454 2,500 2,500 2,263 3,000 3,000 3,000 546.320 Computer system maint&suppli 90,998 98,000 97,055 84,964 90,225 101,600 88,300 l00 Printing&Binding 1,072 4,000 1,787 781 1,400 2,500 2,500 549.300 Other Misc Chgs&Obligations 5,611 5,000 5,000 4,168 5,000 5,500 5,500 549.303 Investigative Expenses 1,115 2,000 2,000 1,070 1,800 2,000 2,000 549.304 Licenses,Fees&Permits 1,848 2,500 2,500 1,381 1,900 2,500 2,500 549.311 Marine Unit Operations 3,416 1,750 1,750 368 1,000 1,750 1,750 549.314 K.E.Y.S.Program 0 0 0 0 0 549.401 Recruitment expenses 1,786 0 0 0 0 551.300 Office Supplies&Equipment 3,935 5,000 5,000 4,377 5,000 5,000 5,000 551.301 Crime Prevention Supplies 3,435 2,500 2,500 1,286 2,000 2,500 2,500 552.301 Gas&Oil 27,816 25,000 25,000 20,243 25,000 30,000 25,000 552.302 Small Tools and Equipment 13,236 16,000 14,677 8,888 14,000 20,000 16,000 552.305 Uniforms 15,583 18,000 23,323 23,323 23,323 24,000 18,000 554.300 Books,Publ,Subs&Membership 2,546 3,700 3,700 3,028 3,029 3,700 3,700 Operating Expenditures/Expense 389,447 391,200 415,323 346,563 413,946 471,250 398,650 0 Acct Class: 590 Other Financing Sources&Uses 599.100 Budget Cost Savings 0 0 -63,386 0 0 Other Financing Sources&Uses 0 0 -63,386 0 0 0 0 0 Acct Class: 600 Capital Outlay 663.710 Police Department Capital Proj 0 0 0 0 0 .600 Mach/Equipment 4,872 0 99,318 0 99,318 664.601 Computer Equipment 0 0 945 945 7,775 159,800 82,000 664.602 Vehicles 931 0 0 0 0 BUDGET WORKSHEET Page: 26 6/28/2017 Village of Tequesta 11:49 am Prior Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 175 Police Department Acct Class: 600 Capital Outlay 664.607 Equipment-Tech 0 42,500 42,500 0 42,500 664.620 Intangible-Software 0 0 0 0 0 Capital Outlay 5,803 42,500 142,763 945 149,593 159,800 82,000 0 Police Department 2,792,692 2,944,200 3,047,761 2,183,079 3,079,515 3,429,900 3,142,900 0 The Village of Tequesta Capital Requests Fiscal Year 2018 And: 001 - General Fund - Capital $ 82,000.00 Dept. 175 Police 664.601 Computer Equipment $ 82,000.00 PD Laptop Replacement(24) $ 75,000.00 vMware Hosts(2) $ 7,000.00 The Village of Tequesta Proposed Budget - DRAFT FY2 018 VILLAGE OF TEQUESTA General Fund #001 Dept. 180 - Building SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: 591,777 556,000 552,099 546,000 -1.80% EXPENDITURES: Personnel 387,170 424,917 363,525 362,300 -14.74% Operating 105,106 93,788 99,804 92,800 -1.05% Capital - 91,145 84,345 - -100.00% Total Expenditures: 492,276 609,850 547,674 455,100 -25.38% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time 5.00 4.00 4.00 Part Time - 1.00 1.00 Total Employees: 5.00 5.00 5.00 Explanation of Significant Changes Revenues: This decrease is due to projected code enforcement revenues. Personnel: This decrease is primarily due to the elimination of a full time position. This decrease is offset by projected increases in employee salaries, projected health insurance premiums, defined benefit pension contribution rates and the addition of a part time code enforcement position. Operating: This decrease is primarily due to savings in computer expenditures resulting from the transition to BS&A software. This decrease is offset by increased contractual service fees for inspection and scanning services. BUDGET WORKSHEET Page: 6 6/28/2017 Village of Tequesta 11:49 am Prior Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT .und: 001-General Fund Revenues Dept 180 Building&Zoning Acct Class: 320 Licenses&Permits 322.000 Building Permit Fees 542,056 502,000 502,000 452,831 530,000 510,000 510,000 329.000 Contractors Registration 7,770 0 0 0 0 329.010 Contractor Reg.-County 4,765 0 0 1,647 1,647 329.180 Other Building dept fees 0 0 0 15,175 16,000 6,000 6,000 Licenses&Permits 554,591 502,000 502,000 469,653 547,647 516,000 516,000 0 Acct Class: 351 Fines&Forfeitures 354.102 Code Enf Fines&Court Costs 37,066 54,000 54,000 4,596 4,381 30,000 30,000 Fines&Forfeitures 37,066 54,000 54,000 4,596 4,381 30,000 30,000 0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 120 0 0 71 71 Miscellaneous Revenues 120 0 0 71 71 0 0 0 Building&Zoning 591,777 556,000 556,000 474,320 552,099 546,000 546,000 0 BUDGET WORKSHEET Page: 27 6/28/2017 Village of Tequesta 11:49 am Prior -Current Year- -- - - (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 180 Building&Zoning Acct Class: 510 Personal Services 512.100 Regular Salaries&Wages 294,086 329,000 266,217 188,665 266,200 261,900 261,900 512.180 Reg Sal&Wages-Code Enf 0 0 0 0 0 514.100 Overtime 0 0 5,600 2,166 5,600 10,500 10,500 514.350 Overtime-Disaster 0 0 0 216 217 515.103 Bonus Pay Plan 500 500 0 0 0 500 500 515.106 Clothing&Boot Allowance 0 200 200 125 125 200 200 515.107 Part-time Salaries 8,561 0 898 897 898 516.100 Compensated Absences 73 0 4,535 4,535 4,535 516.105 Compensated Absences-HSA 0 0 0 0 0 521.101 FICA Taxes 18,397 20,100 16,900 11,943 16,900 16,700 16,700 521.102 Medicare Taxes 4,302 4,700 4,000 2,793 4,000 3,900 3,900 522.102 VOT Pension Contributions 21,998 35,100 27,300 19,000 27,300 29,400 29,400 523.101 Life/Health Insurance 34,758 46,300 32,000 26,689 31,750 32,600 32,600 523.105 HSA-Health Savings Account 0 0 0 0 0 524.100 Workers'Comp Insurance 3,051 3,800 3,800 3,797 3,800 4,200 4,200 100 Unemployment Compensation 0 0 0 0 0 bb4.301 Personnel Training 1,444 2,400 2,200 1,759 2,200 2,400 2,400 Personal Services 387,170 442,100 363,650 262,585 363,525 362,300 362,300 0 Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 40,737 22,000 22,000 19,887 22,000 23,000 23,000 531.310 Legal fees-Code Enf 0 0 0 0 0 531.320 Code Enforcement Service 6,420 7,200 7,200 3,645 7,200 7,000 7,000 531.325 Inspection Services 0 0 7,500 7,800 12,500 10,500 12,500 531.328 Legal Services-Code Enf. 0 0 0 0 0 534.300 Other Contractual Services 1,255 1,500 1,500 1,480 1,500 5,000 5,000 540.300 Travel&Per Diem 2,885 1,950 2,500 2,856 3,000 2,500 3,000 541.300 Communication Services 6,319 7,500 7,000 3,846 7,000 7,500 7,500 541.301 Postage 2,053 2,400 2,400 1,555 2,400 2,400 2,400 543.300 Utility Services 6,192 6,200 6,200 4,018 6,200 6,200 6,200 544.301 Operating Leases 1,843 1,850 1,850 1,113 1,850 1,850 1,850 545.300 Insurance 1,076 1,400 1,400 1,372 1,400 1,600 1,600 546.301 Office Equip/Repair&Maint 1,103 1,150 1,150 518 1,150 1,150 1,150 546.302 Vehicle Repair&Maintenance 2,327 1,000 1,000 880 1,000 1,000 1,000 "q.303 Building Repair&Maint 0 0 0 0 0 ,.320 Computer system maint&suppli 18,268 18,500 18,338 14,568 18,338 8,900 6,500 547.300 Printing&Binding 184 150 200 358 358 500 500 BUDGET WORKSHEET Page: 28 6/28/2017 Village of Tequesta 11:49 am Prior Current Year--------- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 180 Building&Zoning Acct Class: 530 Operating Expenditures/Expense 549.300 Other Misc Chgs&Obligations 862 800 800 1,008 1,008 800 800 549.304 Licenses,Fees&Permits 996 1,400 1,400 955 1,400 1,400 1,400 551.300 Office Supplies&Equipment 2,879 2,200 2,800 1,971 2,800 2,800 2,800 552.301 Gas&Oil 1,157 1,100 1,100 621 1,100 1,100 1,100 554.300 Books,Publ,Subs&Membership 1,182 1,450 1,450 1,600 1,600 1,500 1,500 Operating Expenditures/Expense 97,738 79,750 87,788 70,051 93,804 86,700 86,800 0 Acct Class: 590 Other Financing Sources&Uses 549.395 Credit Card Fees and Charges 7,368 6,000 6,000 3,321 6,000 6,000 6,000 599.100 Budget Cost Savings 0 0 61,267 0 0 Other Financing Sources&Uses 7,368 6,000 67,267 3,321 6,000 6,000 6,000 0 Acct Class: 600 Capital Outlay 664.600 Mach/Equipment 0 0 0 0 0 664.601 Computer Equipment 0 41,700 59,145 12,135 54,845 664.602 Vehicles 0 32,000 32,000 29,467 29,500 34,000 664.620 Intangible-Software 0 0 0 0 0 Capital Outlay 0 73,700 91,145 41,602 84,345 34,000 0 0 Building&Zoning 492,276 601,550 609,850 377,559 547,674 489,000 455,100 0 The Village of Tequesta Proposed Budget- DRAFT FY2 018 VILLAGE OF TEQUESTA General Fund #001 Dept. 192 - Fire SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: 1,129,289 1,116,179 1,156,552 1,051,850 -5.76% EXPENDITURES: Personnel 2,509,625 2,754,150 2,773,009 2,873,800 4.34% Operating 372,888 337,047 356,785 336,850 -0.06% Capital 178,731 103,532 103,432 25,100 -75.76% Total Expenditures: 3,061,244 3,194,729 3,233,226 3,235,750 1.28% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time 20.00 20.00 21.00 Part Time 4.00 4.00 3.00 Interim Firefighters 3.00 3.00 3.00 Total Employees: 24.00 24.00 24.00 Explanation of Significant Changes Revenues: This decrease is primarily due to two grants that the Fire department received in FY2017 and the recording of vehicle repair and maintenance services that the Village receives from Palm Beach County Fire Rescue (this revenue is recorded quarterly). It is offset by projected increases in fire plan review fees; fire extra duty work and Palm Beach County fire rescue service fees. Personnel: This department is requesting to change a part time position to a full time position. This budget also includes increases for existing employee salaries, projected health insurance premiums and defined benefit pension contribution rates. Operating:This decrease is primarily due to the recording of vehicle repair and maintenance services that the Village receives from Palm Beach County Fire Rescue. It is offset by projected increases in the cost of medical supplies and uniforms. BUDGET WORKSHEET Page: 7 6/28/2017 Village of Tequesta 11:49 am Prior -----------------Current Year--------------------- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT , und: 001-General Fund Revenues Dept: 192 Fire Control Acct Class: 334 Grants-State 334.206 State Grant-FIND 0 0 60,000 0 60,000 337.201 Local Govemment Grant PBC 24,200 0 17,500 0 17,500 Grants-State 24,200 0 77,500 0 77,500 0 0 0 Acct Class: 335 Intergovemmental Revenue 335.201 Fire Incentive Pay 3,600 3,000 3,000 2,850 3,000 3,600 3,600 Intergovernmental Revenue 3,600 3,000 3,000 2,850 3,000 3,600 3,600 0 Acct Class: 340 Charges for Services 342.950 Allow for doubtful rev-GovFnd 0 0 0 0 0 Charges for Services 0 0 0 0 0 0 0 0 Acct Class: 342 Chgs for Sery-Public Safety 342.192 Fire-Extra Duty 6,968 750 750 299 7,000 7,000 7,000 342.201 Fire Plan Review Fees 43,742 30,600 30,600 53,776 55,000 43,700 43,700 342.202 Fire Inspections 27,785 24,100 24,100 17,166 24,100 27,800 27,800 342.401 Emergency Service-JIC 400,000 400,000 400,000 300,000 400,000 400,000 400,000 342.402 Fire Rescue-CPR Program 325 700 700 380 380 850 850 342.410 Emergency Svc-PBC Fire Rescue 262,033 207,000 224,829 173,149 224,829 213,300 213,300 .600 EMS Transportation Fees 354,939 350,900 350,900 201,374 350,900 350,000 350,000 Chgs for Sery-Public Safety 1,095,792 1,014,050 1,031,879 746,144 1,062,209 1,042,650 1,042,650 0 Acct Class: 363 Impact Fees 362.222 Fire Impact Fees 88 500 500 2,695 2,695 500 500 Impact Fees 88 500 500 2,695 2,695 500 500 0 Acct Class: 366 Contributions&Donations 366.100 Contrib&Donations&Sponsors 375 250 250 500 500 Contributions&Donations 375 250 250 500 500 0 0 0 Acct Class: 369 Miscellaneous Revenues 365.102 Fire Dept Sales 46 50 50 19 50 369.000 Other Miscellaneous Revenue 5,188 3,000 3,000 10,598 10,598 5,100 5,100 Miscellaneous Revenues 5,234 3,050 3,050 10,617 10,648 5,100 5,100 0 Fire Control 1,129,289 1,020,850 1,116,179 762,806 1,156,552 1,051,850 1,051,850 0 BUDGET WORKSHEET Page: 29 6/28/2017 Village of Tequesta 11:49 am Prior Current Year -- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 192 Fire Control Acct Class: 510 Personal Services 512.100 Regular Salaries&Wages 1,499,258 1,559,800 1,546,000 1,060,899 1,542,000 1,643,700 1,643,700 514.100 Overtime 67,586 65,100 74,300 60,178 74,300 75,100 75,000 514.300 Overtime-Training 20,080 19,500 21,500 17,792 21,500 22,500 22,500 514.350 Overtime-Disaster 0 0 0 30,520 30,521 515.101 Holiday Pay 50,770 49,400 52,000 42,864 52,000 53,600 53,600 515.103 Bonus Pay Plan 4,988 5,500 5,500 3,488 3,488 5,500 5,500 515.107 Part-time Salaries 43,237 59,000 59,000 39,794 62,500 33,300 27,600 515.108 Auto Allowance 0 4,800 4,800 0 0 515.110 Intern Fire Fighter Pay 58,927 63,300 63,300 43,735 60,000 66,800 66,800 515.120 Cell phone allowance 1,200 1,200 1,200 877 1,200 1,200 1,200 515.125 Other Allowances 4,200 0 6,000 4,385 6,000 6,000 6,000 516.100 Compensated Absences 39,851 5,000 5,000 3,705 5,000 5,000 5,000 516.105 Compensated Absences-HSA 0 0 0 0 0 521.101 FICA Taxes 108,113 109,200 109,200 79,171 109,200 114,200 113,500 521.102 Medicare Taxes 25,285 26,000 26,000 18,542 26,000 27,100 26,900 '02 VOT Pension Contributions 63,576 212,200 212,200 148,091 212,200 196,900 201,900 pall° Other Pension Contributions 152,443 155,000 155,000 0 155,000 155,000 155,000 523.101 Life/HealthInsurance 278,846 312,100 299,250 248,558 298,200 347,800 347,800 523.105 HSA-Health Savings Account 0 0 0 0 0 524.100 Workers'Comp Insurance 45,771 54,650 54,650 54,610 54,650 60,200 60,200 525.100 Unemployment Compensation 0 0 0 0 0 526.101 Employee Recognition Program 2,147 3,000 3,000 1,986 3,000 3,500 3,500 526.103 Education Reimbursement Prgm 17,907 15,000 18,250 5,956 18,250 20,000 20,000 526.104 ICMA-Def Comp Plan 7,155 14,700 15,300 10,703 15,300 15,400 15,400 526.105 Employee PhysicaVPsycological 10,142 10,000 10,000 4,411 10,000 10,000 10,000 554.301 Personnel Training 8,143 9,700 12,700 8,175 12,700 12,700 12,700 Personal Services 2,509,625 2,754,150 2,754,150 1,888,440 2,773,009 2,875,500 2,873,800 0 Acct Class: 530 Operating Expenditures/Expense 531.318 Volunteer Fire Fighter Program 0 0 0 0 0 534.300 Other Contractual Services 0 0 0 0 0 540.300 Travel&Per Diem 3,100 5,300 5,300 1,196 3,000 6,000 5,300 541.300 Communication Services 10,953 11,500 11,500 6,927 11,500 12,000 12,000 541.301 Postage 1,136 1,500 1,500 668 1,500 1,500 1,500 '1.300 Utility Services 28,096 33,400 33,400 17,971 33,400 34,000 30,000 ..301 Operating Leases 3,792 4,600 4,600 2,646 4,600 5,000 5,000 545.300Insurance 21,714 19,400 19,400 19,282 19,400 21,400 21,400 BUDGET WORKSHEET Page: 30 6/28/2017 Village of Tequesta 11:49 am Prior -- --- Current Year-- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 192 Fire Control Acct Class: 530 Operating Expenditures/Expense 546.302 Vehicle Repair&Maintenance 62,169 1,500 19,329 19,156 19,329 2,000 2,000 546.303 Building Repair&Maint 44,044 30,000 54,068 42,953 54,068 42,500 37,500 546.310 Equipment Repair&Maint 18,176 25,200 25,200 15,464 25,200 26,000 20,000 546.320 Computer system maint&suppli 33,725 47,500 40,068 39,126 40,068 33,350 30,150 547.300 Printing&Binding 1,941 1,450 1,450 1,679 1,680 2,000 2,000 549.300 Other Misc Chgs&Obligations 5,143 4,000 4,000 1,285 4,000 5,200 4,000 549.304 Licenses,Fees&Permits 17,074 19,000 19,000 45,128 19,000 19,500 19,500 549.311 Marine Unit Operations 3,639 3,700 3,700 3,375 3,240 3,700 3,700 549.397 Bad Debt Expense 830 0 0 0 0 551.300 Office Supplies&Equipment 4,305 3,000 3,000 2,107 3,000 3,500 3,500 551.302 Fire Prevention Education 2,200 2,350 2,350 1,920 2,350 2,500 2,500 552.301 Gas&Oil 10,407 10,000 10,000 7,356 9,000 10,500 10,000 552.302 Small Tools and Equipment 2,735 3,200 3,200 1,736 3,200 34,500 3,500 552.304 Chemicals 1,000 1,000 1,000 990 1,000 1,000 1,000 552.305 Uniforms 24,255 23,400 23,400 15,356 23,000 34,750 34,800 108 Safety Supplies 19,767 19,700 19,700 7,126 19,700 23,000 18,000 552.310 Disaster Relief Supplies 1,543 4,000 4,000 2,333 4,000 10,000 4,000 552.311 CPR Program Supplies 595 550 550 340 550 1,000 1,000 552.312 Medical Supplies 44,568 45,000 45,000 31,473 45,000 57,800 57,800 552.344 Fire Station Supplies 3,077 2,900 2,900 1,173 2,500 3,200 3,200 554.300 Books,Publ,Subs&Membership 2,904 3,500 3,500 2,503 3,500 3,500 3,500 Operating Expenditures/Expense 372,888 326,650 361,115 261,269 356,785 399,400 336,850 0 Acct Class: 590 Other Financing Sources&Uses 599.100 Budget Cost Savings 0 0 -24,068 0 0 Other Financing Sources&Uses 0 0 -24,068 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.600 Mach/Equipment 177,130 36,100 53,600 49,280 53,500 22,000 22,000 664.601 Computer Equipment 1,601 0 7,432 2,116 7,432 10,600 3,100 664.602 Vehicles 0 0 0 0 0 664.607 Equipment-Tech 0 42,500 42,500 0 42,500 664.620 Intangible-Software 0 0 0 0 0 Capital Outlay 178,731 78,600 103,532 51,396 103,432 32,600 25,100 0 Fire Control 3,061,244 3,159,400 3,194,729 2,201,105 3,233,226 3,307,500 3,235,750 0 The Village of Tequesta Capital Requests Fiscal Year 2018 and: 001 - General Fund - Capital $ 25,100.00 Dept: 192 Fire 664.600 Machinery& Equipment $ 22,000.00 Patient Power Loader(1) $ 22,000.00 664.601 Computer Equipment $ 3,100.00 vMware Hosts(2) $ 3,100.00 The Village of Tequesta Proposed Budget- DRAFT FY2018 VILLAGE OF TEQUESTA General Fund #001 Dept. 210 - Public Works SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: - - - - N/A EXPENDITURES: Personnel 406,140 500,700 492,151 580,000 15.84% Operating 622,577 746,024 757,626 710,000 -4.83% Capital 43,832 79,054 78,591 119,000 50.53% Total Expenditures: 1,072,549 1,325,778 1,328,368 1,409,000 6.28% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time 8.10 8.10 9.10 Part Time - - Total Employees: 8.10 8.10 9.10 Explanation of Significant Changes Personnel: This department is requesting to add a full time position. This budget also includes increases for existing employee salaries, projected health insurance premiums and defined benefit pension contribution rates. Operating: This decrease is primarily due to a decrease in projected road and pathway maintenance costs and the transferring of Station 11 to Dept. 231, Parks and Recreation. It is offset by projected increases in bridge maintenance and engineering service costs. BUDGET WORKSHEET Page: 31 6/28/2017 Village of Tequesta 11:49 am Prior -Current Year - - (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 210 Public Works Acct Class: 510 Personal Services 512.100 Regular Salaries&Wages 282,561 341,500 316,700 217,824 316,700 444,400 360,100 514.100 Overtime 1,207 1,600 27,149 4,617 13,500 6,000 6,000 514.350 Overtime-Disaster 0 0 0 954 955 515.103 Bonus Pay Plan 0 200 200 200 200 200 200 515.106 Clothing&Boot Allowance 500 750 750 775 775 1,300 1,100 515.107 Part-time Salaries 0 0 0 0 0 515.108 Auto Allowance 1,440 1,450 1,450 1,052 1,440 1,500 1,500 515.120 Cell phone allowance 480 500 500 351 480 500 500 516.100 Compensated Absences 1,116 0 0 0 0 516.105 Compensated Absences-HSA 0 0 0 0 0 521.101 FICA Taxes 17,034 21,200 22,781 13,642 21,281 27,300 22,000 521.102 Medicare Taxes 3,984 5,000 5,370 3,190 5,070 6,400 5,200 522.101 FRS Contributions 0 0 0 0 0 522.102 VOT Pension Contributions 20,922 36,500 33,800 23,242 33,800 49,800 40,400 523.101 Life/Health Insurance 60,390 71,400 71,400 61,745 77,350 128,200 120,300 105 HSA-Health Savings Account 0 0 0 0 0 524.100 Workers'Comp Insurance 14,306 20,000 20,600 20,598 20,600 22,700 22,700 525.100 Unemployment Compensation 2,200 0 0 0 0 Personal Services 406,140 500,100 500,700 348,190 492,151 688,300 580,000 0 Acct Class: 530 Operating Expenditures/Expense 531.302 Engineering Services 14,787 14,000 8,760 1,750 8,760 20,000 15,000 534.300 Other Contractual Services 1,395 2,000 2,000 883 2,000 3,000 3,000 540.300 Travel&Per Diem 0 100 100 72 100 400 400 541.300 Communication Services 7,048 8,000 8,000 4,502 8,000 8,000 8,000 543.300 Utility Services 98,064 105,000 105,000 77,885 105,000 110,000 110,000 543.301 Street Lights 136,976 137,000 137,000 95,616 137,000 140,000 140,000 544.301 Operating Leases 0 1,200 1,200 0 0 1,500 2,650 544.304 FEC Lease 15,296 15,300 15,300 15,480 15,977 16,700 16,700 545.300 Insurance 13,793 14,650 14,650 14,629 14,650 16,200 16,200 546.200 R&M-Station 11 0 8,500 8,500 8,590 8,591 546.301 Office Equip/Repair&Maint 22 450 450 0 450 600 600 546.302 Vehicle Repair&Maintenance 5,449 6,500 6,500 7,187 7,045 7,000 7,000 546.303 Building Repair&Maint 26,475 44,500 44,500 42,928 44,500 60,000 45,000 " 305 Pathway Maintenance 11,613 30,000 30,000 11,619 30,000 84,000 15,000 J.306 General Maintenance 29,329 30,000 30,000 26,436 30,327 35,000 35,000 546.309 Landscape&Irrigation Maint 152,132 151,000 156,240 135,457 164,693 155,000 155,000 BUDGET WORKSHEET Page: 32 6/28/2017 Village of Tequesta 11:49 am Prior -----------Current Year------ - (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 210 Public Works Acct Class: 530 Operating Expenditures/Expense 546.310 Equipment Repair&Maint 5,220 7,000 14,000 6,458 14,000 7,000 7,000 546.320 Computer system maint&suppli 6,639 2,100 2,046 2,269 2,219 2,350 1,650 546.340 R&M Bridge 0 0 0 0 0 30,000 30,000 546.350 R&M-Roads 52,158 65,000 112,078 67,379 112,078 200,000 40,000 549.300 Other Misc Chgs&Obligations 4,070 3,500 3,500 2,536 3,500 4,000 4,000 549.304 Licenses,Fees&Permits 1,362 1,500 1,500 1,485 1,500 2,000 2,000 551.300 Office Supplies&Equipment 619 650 650 594 780 800 800 551.400 Janitorial Supplies 6,183 6,000 6,000 6,115 6,115 6,500 6,500 552.301 Gas&Oil 4,167 5,000 5,000 2,209 5,000 5,500 5,500 552.302 Small Tools and Equipment 8,604 3,400 3,400 5,974 5,691 7,000 7,000 552.305 Uniforms 3,018 2,600 2,600 2,011 2,600 4,000 4,000 553.301 Road Signs 11,162 10,000 10,000 4,895 10,000 12,000 12,000 563.600 Public Works Misc Projects 6,996 17,650 17,050 12,508 17,050 20,000 20,000 Operating Expenditures/Expense 622,577 692,600 746,024 557,467 757,626 958,550 710,000 0 Acct Class: 590 Other Financing Sources&Uses 100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 663.650 Pathways 17,826 0 0 0 0 69,000 664.600 Mach/Equipment 26,006 45,000 45,000 20,761 44,537 664.601 Computer Equipment 0 0 54 54 54 664.602 Vehicles 0 34,000 34,000 31,487 34,000 664.607 Equipment-Tech 0 0 0 0 0 50,000 50,000 Capital Outlay 43,832 79,000 79,054 52,302 78,591 50,000 119,000 0 Public Works 1,072,549 1,271,700 1,325,778 957,959 1,328,368 1,696,850 1,409,000 0 The Village of Tequesta Capital Requests Fiscal Year 2018 And: 001 - General Fund - Capital $ 119,000.00 Dept: 210 Public Works 663.650 Pathways $ 69,000.00 Pathway Repairs $ 69,000.00 664.607 Equipment-Tech $ 50,000.00 Fiber to Remote Sites $ 50,000.00 The Village of Tequesta Proposed Budget- DRAFT FY2 018 VILLAGE OF TEQUESTA General Fund #001 Dept. 231 - Leisure Services SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: 123,698 69,800 80,808 70,000 0.29%, EXPENDITURES: Personnel 335,215 368,600 364,226 393,200 6.67% Operating 273,794 274,192 274,005 265,300 -3.24% Capital 31,505 58,708 52,255 64,000 9.01% Total Expenditures: 640,514 701,500 690,486 722,500 2.99% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time 3.00 3.00 3.00 Part Time 4.00 4.00 4.00 Seasonal 10.00 10.00 10.00 Total Employees: 17.00 17.00 17.00 Explanation of Significant Changes Revenues: This Department has no significant changes in its revenues. Personnel:This increase is primarily due to employee salary increases, projected increases in health insurance premiums and increased defined benefit pension contribution rates. Operating: This decrease is primarily due to a projected decrease in general maintenance costs. It is offset by the transferring of Station 11 from Public Works, Dept. 210, to Parks and Recreation, Dept. 231. BUDGET WORKSHEET Page: 8 6/28/2017 Village of Tequesta 11:49 am Prior -----------------Current Year ------ (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT . und: 001-General Fund Revenues Dept: 231 Leisure Services Acct Class: 334 Grants-State 334.205 State DEP Grant-(FRDAP) 49,628 0 0 0 0 Grants-State 49,628 0 0 0 0 0 0 0 Acct Class: 347 Charges for Services-Recr. 347.100 Tequesta Fest 5,396 7,800 7,800 11,852 11,852 8,000 8,000 347.190 Special Events•Other 4,999 6,000 6,000 5,143 5,600 6,000 6,000 347.201 Winter/Summer Camp Fees 39,951 37,500 37,500 32,249 37,500 37,500 37,500 347.205 Recreation Programs Fees 10,726 6,000 6,000 11,376 11,376 7,000 7,000 Charges for Services-Recr. 61,072 57,300 57,300 60,620 66,328 58,500 58,500 0 Acct Class: 362 Rents&Royalties 362.100 Rental-Facilities 7,213 6,500 6,500 5,447 6,500 6,500 6,500 Rents&Royalties 7,213 6,500 6,500 5,447 6,500 6,500 6,500 0 Acct Class: 363 Impact Fees 363.271 Parks and Rec Impact Fees 276 0 0 3,135 3,135 Impact Fees 276 0 0 3,135 3,135 0 0 0 Acct Class: 366 Contributions&Donations 366.100 Contrib&Donations&Sponsors 4,500 4,500 4,500 3,300 3,300 3,500 3,500 Contributions&Donations 4,500 4,500 4,500 3,300 3,300 3,500 3,500 0 Acct Class: 369 Miscellaneous Revenues 365.110 Concession Sales 1,009 1,500 1,500 852 1,500 1,500 1,500 369.000 Other Miscellaneous Revenue 0 0 0 45 45 Miscellaneous Revenues 1,009 1,500 1,500 897 1,545 1,500 1,500 0 Leisure Services 123,698 69,800 69,800 73,399 80,808 70,000 70,000 0 BUDGET WORKSHEET Page: 34 6/28/2017 Village of Tequesta 11:49 am Prior Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 231 Leisure Services Acct Class: 510 Personal Services 512.100 Regular Salaries&Wages 174,624 183,300 183,300 126,228 182,350 232,900 191,600 514.350 Overtime-Disaster 0 0 0 174 175 515.103 Bonus Pay Plan 2,487 2,500 2,500 2,488 2,488 2,000 2,500 515,106 Clothing&Boot Allowance 100 100 125 125 125 200 200 515.107 Part-time Salaries 43,068 55,600 55,600 32,400 55,600 30,200 59,400 515.108 Auto Allowance 3,000 3,000 3,000 2,192 3,000 3,000 3,000 515.109 Seasonal Salaries&Wages 24,706 20,000 20,000 389 20,000 30,000 25,000 515.120 Cell phone allowance 1,200 1,200 1,200 877 1,200 1,200 1,200 516.100 Compensated Absences 2,375 4,200 4,175 688 688 3,000 3,000 516.105 Compensated Absences-HSA 0 0 0 0 0 521.101 FICA Taxes 15,014 16,300 16,300 9,869 16,300 18,300 17,200 521.102 Medicare Taxes 3,511 3,800 3,800 2,308 3,800 4,300 4,100 522.102 VOT Pension Contributions 13,062 19,600 19,600 13,469 19,500 26,100 21,500 523.101 Life/Health Insurance 44,685 47,900 47,900 39,767 47,900 61,300 52,500 523.105 HSA-Health Savings Account 0 0 0 0 0 100 Workers'Comp Insurance 6,375 8,400 8,400 8,393 8,400 9,300 9,300 525.100 Unemployment Compensation 0 0 0 0 0 526.105 Employee PhysicaVPsycological 1,008 1,500 1,500 1,107 1,500 1,500 1,500 554.301 Personnel Training 0 1,200 1,200 746 1,200 1,200 1,200 Personal Services 335,215 368,600 368,600 241,220 364,226 424,500 393,200 0 Acct Class: 530 Operating Expenditures/Expense 531.324 Grants Acquistion&Admin 0 2,000 850 850 850 2,000 2,000 534.300 Other Contractual Services 0 4,000 0 0 0 534.303 Special Events 50,168 51,000 57,975 57,974 57,974 58,000 54,000 540.300 Travel&Per Diem 0 1,500 1,500 0 1,500 1,500 1,500 541.300 Communication Services 11,206 14,000 13,113 8,815 13,113 14,000 14,000 541.301 Postage 156 150 150 5 150 150 150 543.300 Utility Services 11,898 14,600 14,600 9,547 14,600 14,600 14,600 545.300 Insurance 15,553 13,100 13,100 12,285 13,100 14,500 14,500 546.200 R&M-Station 11 0 0 0 0 0 20,000 10,000 546.302 Vehicle Repair&Maintenance 3,524 1,000 1,000 613 1,000 1,000 1,000 546.303 Building Repair&Maint 25,244 30,000 30,000 22,512 30,000 40,000 30,000 546.306 General Maintenance 28,405 35,000 59,000 37,957 59,000 44,000 35,850 "q.310 Equipment Repair&Maint 1,688 1,700 1,700 963 1,700 1,700 1,700 J.315 Facilities-Repair&Maint 49,381 0 0 0 0 546.320 Computer system maim&suppli 5,543 4,100 3,992 3,571 3,992 4,450 3,000 BUDGET WORKSHEET Page: 35 6/28/2017 Village of Tequesta 11:49 am Prior Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT .und: 001-General Fund Expenditures Dept: 231 Leisure Services Acct Class: 530 Operating Expenditures/Expense 549.201 Advertising&Promotion 6,935 6,000 3,000 2,660 2,660 6,000 6,000 549.300 Other Misc Chgs&Obligations 2,119 3,450 3,450 1,508 3,450 3,450 3,450 549.304 Licenses,Fees&Permits 1,993 2,200 2,262 2,416 2,416 2,200 2,200 549.332 Recreation Program Expense 40,852 38,000 45,000 42,620 45,000 45,000 45,850 549.333 Spring/Summer Camp 13,470 15,000 15,000 2,775 15,000 17,000 17,000 551.300 Office Supplies&Equipment 1,235 2,000 2,000 1,194 2,000 2,000 2,000 551.315 Concession Supplies 1,215 1,500 1,500 786 1,500 1,500 1,500 552.301 Gas&Oil 1,281 2,500 2,500 756 2,500 2,500 2,500 552.302 Small Tools and Equipment 929 1,500 1,500 116 1,500 1,500 1,500 552.305 Uniforms 834 500 500 342 500 500 500 554.300 Books,Publ,Subs&Membership 165 500 500 165 500 500 500 Operating Expenditures/Expense 273,794 245,300 274,192 210,430 274,005 298,050 265,300 0 Acct Class: 590 Other Financing Sources&Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 Class: 600 Capital Outlay J.600 Improvements other than Bldgs 0 8,600 8,600 4,998 4,998 30,000 30,000 663.650 Pathways 0 24,000 0 0 0 664.600 Mach/Equipment 0 0 0 0 0 18,000 14,000 664.601 Computer Equipment 0 0 108 108 108 664.602 Vehicles 31,505 30,000 30,000 27,149 27,149 664.607 Equipment-Tech 0 20,000 20,000 0 20,000 20,000 20,000 Capital Outlay 31,505 82,600 58,708 32,255 52,255 68,000 64,000 0 Leisure Services 640,514 696,500 701,500 483,905 690,486 790,550 722,500 0 The Village of Tequesta Capital Requests Fiscal Year 2018 . ,,nd: 001 - General Fund - Capital $ 64,000.00 Dept: 231 Leisure Services 663.600 Improvements Other than Buildings $ 30,000.00 Pumptrack $ 30,000.00 664.600 Machinery& Equipment $ 14,000.00 John Deere Utility Vehicle $ 9,000.00 Zero Turn HD44 Gravely ZT Mower $ 5,000.00 664.607 Equipment-Tech $ 20,000.00 Fiber to Remote Sites $ 20,000.00 The Village of Tequesta Proposed Budget- DRAFT FY2018 VILLAGE OF TEQUESTA General Fund #001 Depts. 700-950 - Other SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: - - - - N/A EXPENDITURES: Debt Service 534,896 534,900 530,557 505,100 -5.57% Inter-fund Transfers 366,800 106,000 106,000 495,000 366.98% Other 11,275 13,800 13,800 13,800 0.00% Total Expenditures: 912,971 654,700 650,357 1,013,900 54.86% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time - - - Part Time - - Total Employees: - - - Explanation of Significant Changes Debt Service: The General Fund is not entering into any new debt in FY2018. Inter-fund Transfers:The General Fund #001 is transferring$295,000.00 to the Capital Improvement Fund #301 and $200,000.00 to the Capital Projects Fund in FY2018. Other: Other includes bank charges and credit card fees. BUDGET WORKSHEET Page: 36 6/28/2017 Village of Tequesta 11:49 am Prior Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT .und: 001-General Fund Expenditures Dept 700 Debt Service Acct Class: 471 D/S-Principal 571.706 2002 Note Payable-PS bdg 281,697 294,000 294,000 219,313 294,000 306,900 306,900 571.708 P/S-Prin-SunTrust-Pumper 39,742 40,800 40,800 40,706 40,706 41,700 41,700 571.710 P/S Prin-2015PDVehicles 78,520 81,000 81,000 60,457 81,000 55,400 55,400 571.712 2015 Public Works Vehicles 0 0 0 0 0 571.716 Principal-L.S.-Transport va 0 0 0 0 0 571.727 Lease Prin-SCVA Fire Equip 28,089 27,500 27,500 25,064 25,064 25,800 25,800 D/S-Principal 428,048 443,300 443,300 345,540 440,770 429,800 429,800 0 Acct Class: 472 D/S-Interest 572.706 2002 Note Payable-PS Bldg 90,805 78,600 78,600 60,063 78,600 65,700 65,700 572.708 P/S-SunTrust-Pumper 8,393 7,500 7,500 7,429 7,430 6,500 6,500 572.710 Interest -2015 PD Vehicles 5,381 3,000 3,000 2,469 3,000 700 700 572.712 2015 Public Works Vehicles 0 0 0 0 0 572.716 Interest-L.S.-Transport va 0 0 0 0 0 572.725 Int.2012 Ford Focus-Admin 0 0 0 0 0 572.727 Lease Int.-SCVA-Fire Equip 2,269 2,500 2,500 756 757 2,400 2,400 D/S-Interest 106,848 91,600 91,600 70,717 89,787 75,300 75,300 0 Debt Service 534,896 534,900 534,900 416,257 530,557 505,100 505,100 0 BUDGET WORKSHEET Page: 37 6/28/2017 Village of Tequesta 11:49 am Prior ----- Current Year-------------- (6) (7) (8) Year Original Amended Actual Thru Estimated 6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT ,und: 001-General Fund Expenditures Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 591.301 Trsf to Capital Imp Fund 316,800 106,000 106,000 106,000 106,000 295,000 591.303 Trsf to Capital Projects Fund 0 0 0 0 0 200,000 591.605 TfrtoSpecial Law Enf Trust 50,000 0 0 0 0 Interfund Transfers Out 366,800 106,000 106,000 106,000 106,000 0 495,000 0 Interfund Transfers 366,800 106,000 106,000 106,000 106,000 0 495,000 0 BUDGET WORKSHEET Page: 39 6/28/2017 Village of Tequesta 11:49 am Prior -----Current Year----------- (6) (7) (8) Year Original Amended Actual Thru Estimated , 6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 001-General Fund Expenditures Dept: 950 Other Nonoperating Acct Class: 590 Other Financing Sources&Uses 549.391 Bank Charges 10,861 11,000 11,000 10,103 11,000 11,000 11,000 549.395 Credit Card Fees and Charges 414 2,800 2,800 163 2,800 2,800 2,800 567.000 Gain/Loss on Investments 0 0 0 0 0 590.001 Allocate to Fund Balance 0 0 0 0 0 999.001 Suspense 0 0 0 0 0 999.002 Suspense-Payroll 0 0 0 0 0 999.200 Suspense-AIP 0 0 0 132 0 Other Financing Sources&Uses 11,275 13,800 13,800 10,398 13,800 13,800 13,800 0 Other Nonoperating 11,275 13,800 13,800 10,398 13,800 13,800 13,800 0 The Village of Tequesta Proposed Budget- DRAFT FY2 018 Proposed Fiscal Year 2018 Budget - DRAFT Capital Improvement Fund #301 PGA O F T EQei `v ��A 'F' r � i � a, , , Q _~~ ,, I h AV‘r O d'oc4 , • .H COUN The Village of Tequesta Proposed Budget- DRAFT FY2 018 VILLAGE OF TEQUESTA Capital Improvement Fund #301 SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: 316,800 106,000 106,000 344,900 225.38% EXPENDITURES: Pathway Improvements 48,209 - - 175,000 N/A R & M - Roads 166,800 48,000 48,000 149,900 212.29% US1 Project 8,000 58,000 108,083 20,000 -65.52% Total Expenditures: 223,009 106,000 156,083 344,900 225.38% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time -Part Time - Total Employees: - - - Explanation of Significant Changes Revenues: The Capital Improvement Fund #301 is receiving a transfer-In from the General Fund #001 for$295,000.00. It is also appropriating$49,900.00 from Fund Balance. Capital: Capital projects budgeted in this fund are as follows: • Pathway Improvements • Roadway resurfacing • US1 Project BUDGET WORKSHEET Page: 1 6/28/2017 Village of Tequesta 12:05 pm Prior Current Year - (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 301-Capital Improvement Fund Revenues Dept: 000 General Acct Class: 366 Contributions&Donations 366.100 Contrib&Donations&Sponsors 0 0 0 0 0 Contributions&Donations 0 0 0 0 0 0 0 0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 0 0 0 0 0 Miscellaneous Revenues 0 0 0 0 0 0 0 0 General 0 0 0 0 0 0 0 0 Dept: 900 Interfund Transfers Acct Class: 391 Transfers In 381.001 Transfer from General Fund 316,800 106,000 106,000 106,000 106,000 295,000 381.303 Tsfer-In from Capital Projects 0 0 0 0 0 Transfers In 316,800 106,000 106,000 106,000 106,000 0 295,000 0 Interfund Transfers 316,800 106,000 106,000 106,000 106,000 0 295,000 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investment Eamin 361.100 Interest/Investment Eamings 0 0 0 0 0 Unrestricted Investment Eamin 0 0 0 0 0 0 0 0 Other Nonoperating 0 0 0 0 0 0 0 0 Dept: 990 Other/Reserve/Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 0 0 0 0 49,900 Other Financing Sources 0 0 0 0 0 0 49,900 0 Other/ReservelContingency 0 0 0 0 0 0 49,900 0 Total Revenues 316,800 106,000 106,000 106,000 106,000 0 344,900 0 Expenditures Dept: 000 General Acct Class: 530 Operating Expenditures/Expense 546.305 Pathway Maintenance 0 0 0 0 0 Operating Expenditures/Expense 0 0 0 0 0 0 0 0 General 0 0 0 0 0 0 0 0 Dept: 210 Public Works Acct Class: 530 Operating Expenditures/Expense 546.305 Pathway Maintenance 0 0 0 0 0 546.350 R&M-Roads 166,800 106,000 48,000 0 48,000 553.301 Road Signs 0 0 0 0 0 Operating Expenditures/Expense 166,800 106,000 48,000 0 48,000 0 0 0 Class: 600 Capital Outlay __3.652 Pathway/Sidewalk Improvements 48,209 0 0 0 0 175,000 663.653 Signage 0 0 0 0 0 BUDGET WORKSHEET Page: 2 6/28/2017 Village of Tequesta 12:05 pm Prior -- ----Current Year------------- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 301-Capital Improvement Fund Expenditures Dept: 210 Public Works Acct Class: 600 Capital Outlay 663.655 Landscaping 0 0 0 0 0 663.657 Roadway Improvements 0 0 0 0 0 149,900 Capital Outlay 48,209 0 0 0 0 0 324,900 0 Public Works 215,009 106,000 48,000 0 48,000 0 324,900 0 Dept: 371 US1 Boulevard Project Acct Class: 530 Operating Expenditures/Expense 546.657 R&M-Roadway Improvements 8,000 0 0 0 0 Operating Expenditures/Expense 8,000 0 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 663.657 Roadway Improvements 0 0 58,000 108,083 108,083 20,000 Capital Outlay 0 0 58,000 108,083 108,083 0 20,000 0 US1 Boulevard Project 8,000 0 58,000 108,083 108,083 0 20,000 0 Dept: 399 MiscProj-General Acct Class: 600 Capital Outlay 663.647 IT-Storage Project 0 0 0 0 0 Capital Outlay 0 0 0 0 0 0 0 0 Misc Proj-General 0 0 0 0 0 0 0 0 Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 591.001 Transfer to General Fund 0 0 0 0 0 Interfund Transfers Out 0 0 0 0 0 0 0 0 Interfund Transfers 0 0 0 0 0 0 0 0 Total Expenditures 223,009 106,000 106,000 108,083 156,083 0 344,900 0 Capital Improvement Fund 93,791 0 0 -2,083 -50,083 0 0 0 The Village of Tequesta Capital Requests Fiscal Year 2018 . und: 301 - Capital Improvement Fund - Capital $ 344,900.00 Dept: 210 Public Works 663.652 Pathway/Sidewalk Improvements $ 175,000.00 Pathway/Sidewalk Improvements $ 175,000.00 663.657 Roadway Improvements $ 149,900.00 Roadway Improvements $ 149,900.00 663.657 Roadway Improvements $ 20,000.00 Roadway Improvements - US1 $ 20,000.00 The Village of Tequesta Proposed Budget- DRAFT FY2018 Proposed Fiscal Year 2018 Budget - DRAFT Capital Projects Fund #303 ii(1114). ;/,.; 41g s-oNf pN0 if boo of The Village of Tequesta Proposed Budget - DRAFT FY2 018 VILLAGE OF TEQUESTA Capital Projects Fund #303 SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: - - - 200,000 N/A EXPENDITURES: Recreation Center A&E - - - 200,000 N/A - N/A _ - N/A Total Expenditures: - - - 200,000 N/A Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time - - - Part Time - Total Employees: Explanation of Significant Changes Revenues: The Capital Projects Fund #301 is receiving a transfer-In from the General Fund #001 for$200,000.00. Capital: Capital projects budgeted in this fund are as follows: • Recreation Center/Gym BUDGET WORKSHEET Page: 3 6/28/2017 Village of Tequesta 12:05 pm Prior Current Year --— — (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REO MGR RECOM CNCL ADOPT .und: 303-Capital Projects Fund Revenues Dept: 900 Interfund Transfers Acct Class: 391 Transfers In 381.001 Transfer from General Fund 0 0 0 0 0 200,000 Transfers In 0 0 0 0 0 0 200,000 0 Interfund Transfers 0 0 0 0 0 0 200,000 0 Dept: 990 Other/Reserve/Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 0 0 0 0 Other Financing Sources 0 0 0 0 0 0 0 0 Other/Reserve/Contingency 0 0 0 0 0 0 0 0 Total Revenues 0 0 0 0 0 0 200,000 0 Expenditures Dept: 317 Recreation Center Acct Class: 600 Capital Outlay 662.600 Buildings 0 0 0 0 0 663.632 Architect&Engineering-Other 0 0 0 0 0 200,000 Capital Outlay 0 0 0 0 0 0 200,000 0 Recreation Center 0 0 0 0 0 0 200,000 0 Dept: 399 Misc Proj-General Acct Class: 530 Operating Expenditures/Expense 546.311 FEC Track Maintenance 0 0 0 0 0 Operating Expenditures/Expense 0 0 0 0 0 0 0 0 Misc Proj-General 0 0 0 0 0 0 0 0 Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 591.001 Transfer to General Fund 0 0 0 0 0 591.301 Trsf to Capital Imp Fund 0 0 0 0 0 Interfund Transfers Out 0 0 0 0 0 0 0 0 Interfund Transfers 0 0 0 0 0 0 0 0 Total Expenditures 0 0 0 0 0 0 200,000 0 Capital Projects Fund 0 0 0 0 0 0 0 0 The Village of Tequesta Capital Requests Fiscal Year 2018 ,end: 303 - Capital Projects Fund - Capital $ 200,000.00 Dept: 317 Recreation Center 663.632 Architect& Engineering-Other $ 200,000.00 Recreation Building $ 200,000.00 The Village of Tequesta Proposed Budget- DRAFT FY2 018 Proposed Fiscal Year 2018 Budget - DRAFT Water Utility Fund #401 ltrilk v*` OFTFQ6 i r,--4, ° 't 1 /1; At Q 3 J of illifr isb CO The Village of Tequesta Proposed Budget- DRAFT FY2 018 VILLAGE OF TEQUESTA Water Fund #401 SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget(%) Total Revenues: 4,865,280 7,547,156 5,025,138 5,376,100 -28.77% EXPENDITURES: Water Administration 961,557 1,085,617 1,078,964 1,096,300 0.98% Water Production 1,675,741 1,880,430 1,799,535 1,996,300 6.16% Water Distribution 688,000 770,350 770,324 903,250 17.25% Renewal & Replacement 98,540 2,707,909 2,707,909 1,315,300 -51.43% Debt Service 202,974 527,600 527,600 528,300 0.13% Other 1,100,041 575,250 575,250 387,400 -32.66% Total Expenditures: 4,726,853 7,547,156 7,459,582 6,226,850 -17.49% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time 18.90 20.40 22.40 Part Time - - Total Employees: 18.90 20.40 22.40 Explanation of Significant Changes Revenues: The Water Utility is appropriating approximately$1,856,000.00 less in FY2018 than it did in FY2017. This is offset by an 8% increase in water sales and water surcharges and a 20% increase in monthly service charges. The Village of Tequesta Proposed Budget- DRAFT FY2 018 Explanation of Significant Changes Continued Water Administration: This increase is primarily due to employee turnover in the Finance Director position.This increase is offset by a reduction in compensated absences and other contractual service fees (also related to the employee turnover in the Finance Director position). This increase also includes increases employee salaries, projected health insurance premiums, defined benefit pension contribution rates and administration management fees. Water Production: This department is requesting to add a full time mechanic position. This increase also includes increases in employee salaries, projected health insurance premiums, defined benefit pension contribution rates and the cost of chemicals. Water Distribution: This department is requesting to add a full time service technician trainee position. This increase also includes increases in employee salaries, standby pay, projected health insurance premiums, defined benefit pension contribution rates and the cost of water system maintenance. Renewal and Replacement: This decrease is primarily due to the completion of the Jupiter Inlet Colony Water Main Replacement Project and a projected decrease in renewal and replacement projects at the Water Plant. It is offset by projected increases in water main repair and maintenance costs. Debt Service: The Water Utility and Storm Water Utility Funds are entering into a five (5) year lease for a backhoe in FY2018. Other: Other includes budgeted depreciation, bank charges and credit card fees. BUDGET WORKSHEET Page: 4 6/28/2017 Village of Tequesta 12:05 pm Prior - - - -Current Year----- -- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT ,und: 401-Water Fund Revenues Dept: 000 General Acct Class: 340 Charges for Services 342.501 Site Plan Review Fees 0 0 0 0 0 343.301 Water Sales 2,667,793 2,737,000 2,737,000 2,088,374 2,737,000 2,952,200 2,952,200 343.302 Water-Connect Charges 28,894 17,000 17,000 14,115 17,000 17,000 17,000 343.303 Water-Fire Hydrants Rent 71,219 67,400 67,400 54,889 67,400 67,400 67,400 343.304 Water Surcharge 434,886 456,100 456,100 323,681 456,100 492,000 492,000 343.306 Monthly Service Charge 1,523,587 1,491,700 1,491,700 1,265,553 1,650,750 1,780,500 1,780,500 343.307 Penalty Charges 5,172 4,500 4,500 4,329 4,500 4,500 4,500 343.308 Other Water Service Income 2,535 1,500 1,500 840 1,500 1,500 1,500 343.309 Convenience Fee-CC 0 0 0 0 0 343.700 Water Conservation 8 Resource 2,369 1,000 1,000 677 1,000 1,000 1,000 343.950 Allow for doubful rev-Enterp 0 0 0 0 0 Charges for Services 4,736,455 4,776,200 4,776,200 3,752,458 4,935,250 5,316,100 5,316,100 0 Acct Class: 369 Miscellaneous Revenues 363.101 Martin/Tropic V-Const portion 17,891 12,000 12,000 32,069 17,000 17,000 17,000 369.000 Other Miscellaneous Revenue 117 0 0 11 11 100 Insurance Reimbursement 3,174 0 0 11,377 11,377 Miscellaneous Revenues 21,182 12,000 12,000 43,457 28,388 17,000 17,000 0 Acct Class: 390 Other Financing Sources 369.110 Capital Connect Charge-Cust 47,763 25,900 25,900 16,924 25,900 25,900 25,900 369.111 Capital Connect Charge-Devel 26,326 8,600 8,600 3,761 8,600 8,600 8,600 369.112 Capital Connect -Tropic Vist 15,949 10,000 10,000 0 15,000 Other Financing Sources 90,038 44,500 44,500 20,685 49,500 34,500 34,500 0 General 4,847,675 4,832,700 4,832,700 3,816,600 5,013,138 5,367,600 5,367,600 0 Dept: 900 Interfund Transfers Acct Class: 391 Transfers In 381.403 Transfer from Stormwater Util 0 0 0 0 0 Transfers In 0 0 0 0 0 0 0 0 Interfund Transfers 0 0 0 0 0 0 0 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investment Eamin 361.100 Interest/Investment Eamings 13,379 7,800 7,800 11,921 12,000 8,500 8,500 361.105 Int Income-Tropic Vista Asse 0 0 0 0 0 367.100 Net Unreal appreciation(Dep) 0 0 0 0 0 Unrestricted Investment Eamin 13,379 7,800 7,800 11,921 12,000 8,500 8,500 0 "-I Class: 390 Other Financing Sources 100 Disposition of Assets 4,226 0 0 0 0 Other Financing Sources 4,226 0 0 0 0 0 0 0 BUDGET WORKSHEET Page: 5 6/28/2017 Village of Tequesta 12:05 pm Prior Current Year- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT .und: 401-Water Fund Revenues Other Nonoperating 17,605 7,800 7,800 11,921 12,000 8,500 8,500 0 Dept: 990 Other/Reserve/Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 1,714,750 2,706,656 0 0 Other Financing Sources 0 1,714,750 2,706,656 0 0 0 0 0 Other/Reserve/Contingency 0 1,714,750 2,706,656 0 0 0 0 0 Total Revenues 4,865,280 6,555,250 7,547,156 3,828,521 5,025,138 5,376,100 5,376,100 0 Expenditures Dept: 241 Water-Administration Acct Class: 510 Personal Services 512.100 Regular Salaries&Wages 205,239 242,000 240,600 164,945 240,600 256,500 256,500 514.350 Overtime-Disaster 0 0 0 27 28 515.103 Bonus Pay Plan 8,150 1,250 1,250 1,225 1,225 1,000 1,200 515.106 Clothing&Boot Allowance 0 0 0 0 0 515.108 Auto Allowance 4,440 4,450 4,500 3,302 4,500 4,500 4,500 515.120 Cell phone allowance 1,080 1,100 1,300 872 1,300 1,400 1,400 515.125 Other Allowances 1,200 1,200 1,200 900 1,200 1,200 1,200 100 Compensated Absences 3,746 35,000 21,798 21,797 21,798 5,000 5,000 516.105 Compensated Absences-HSA 0 0 0 0 0 521.101 FICA Taxes 10,549 15,300 15,500 10,019 15,500 14,300 14,400 521.102 Medicare Taxes 3,314 4,100 4,200 2,872 4,200 3,900 3,900 522.102 VOT Pension Contributions 15,352 23,700 25,700 17,600 25,700 28,800 28,800 522.150 Pension Expense 2,551 0 0 0 0 523.101 Life/Health Insurance 15,460 23,200 21,850 17,924 21,850 31,800 25,400 523.105 HSA-Health Savings Account 0 0 0 0 0 523.110 Retiree Health Care Expense 2,637 0 0 0 0 524.100 Workers'Comp Insurance 247 8,000 8,000 2,470 2,470 8,800 8,800 526.102 Employee Assistance Program 959 0 0 0 0 526.104 ICMA-Def Comp Plan 10,669 11,200 11,200 7,623 11,050 11,600 11,600 554.301 Personnel Training 0 0 0 0 0 Personal Services 285,593 370,500 357,098 251,576 351,421 368,800 362,700 0 Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 14,060 10,000 10,000 8,302 10,000 15,000 10,000 531.302 Engineering Services 20,618 50,000 50,000 24,788 50,000 50,000 50,000 532.300 Accounting&Auditing Services 30,433 29,800 31,767 31,767 31,767 30,400 30,400 300 Other Contractual Services 18,000 20,000 34,650 30,118 34,650 20,000 20,000 u41.300 Communication Services 2,250 4,000 2,752 2,318 2,318 4,000 4,000 544.304 FEC Lease 12,792 13,500 13,500 12,958 12,958 13,500 13,500 BUDGET WORKSHEET Page: 6 6/28/2017 Village of Tequesta 12:05 pm Prior -----------Current Year- - - -- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 401-Water Fund Expenditures Dept: 241 Water-Administration Acct Class: 530 Operating Expenditures/Expense 545.300Insurance 46,830 44,200 44,200 44,051 44,200 48,700 48,700 549.301 Admin Mgmt Fees 530,200 540,850 540,850 360,533 540,850 556,200 556,200 549.304 Licenses,Fees&Permits 781 800 800 0 800 800 800 Operating Expenditures/Expense 675,964 713,150 728,519 514,835 727,543 738,600 733,600 0 Acct Class: 590 Other Financing Sources&Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 Water-Administration 961,557 1,083,650 1,085,617 766,411 1,078,964 1,107,400 1,096,300 0 Dept: 242 Water- Production Acct Class: 510 Personal Services 512.100 Regular Salaries&Wages 506,749 596,800 571,800 392,521 570,500 617,300 668,800 514.100 Overtime 21,354 10,000 10,000 8,735 11,000 11,000 11,000 514.350 Overtime-Disaster 0 0 0 6,873 6,873 515.101 Holiday Pay 5,636 5,200 7,200 5,978 7,200 7,200 7,200 515.102 Standby Pay 5,049 6,000 6,000 6,190 9,500 7,000 10,000 s15.103 Bonus Pay Plan 0 500 500 500 500 500 500 .106 Clothing&Boot Allowance 572 800 850 850 850 900 1,100 515.107 Part-time Salaries 0 0 0 0 0 515.108 Auto Allowance 6,000 6,000 6,000 4,385 6,000 6,000 6,000 515.120 Cell phone allowance 1,200 1,200 1,200 877 1,200 1,200 1,200 516.100 Compensated Absences 7,227 5,000 5,000 0 0 5,000 5,000 516,105 Compensated Absences-HSA 0 0 0 0 0 521.101 FICA Taxes 33,244 37,600 37,600 25,959 37,600 39,800 43,200 521.102 Medicare Taxes 7,775 8,800 8,800 6,071 8,800 9,400 10,100 522.101 FRS Contributions 5,336 5,700 5,700 3,881 5,700 6,100 7,800 522,102 VOT Pension Contributions 32,646 56,600 56,600 36,582 53,500 60,800 66,600 522.150 Pension Expense 3,770 0 0 0 0 523.101 Life/Health Insurance 92,386 131,500 106,500 87,689 106,100 132,700 139,900 523.105 HSA-Heath Savings Account 0 0 0 0 0 523.110 Retiree Health Care Expense 14,830 0 0 0 0 524.100 Workers'Comp Insurance 9,933 15,450 15,450 15,419 15,450 17,000 17,000 554.301 Personnel Training 3,993 6,000 6,000 1,100 3,500 6,000 6,000 Personal Services 757,700 893,150 845,200 603,610 844,273 927,900 1,001,400 0 Acct Class: 530 Operating Expenditures/Expense 342 Water Analysis&Sampling 28,227 30,000 30,000 22,730 34,000 30,000 30,000 ;"0.300 Travel&Per Diem 2,271 4,000 2,780 2,088 2,780 2,000 2,000 541.300 Communication Services 17,308 19,000 19,000 10,852 19,000 20,000 20,000 BUDGET WORKSHEET Page: 7 6/28/2017 Village of Tequesta 12:05 pm Prior Current Year - -- -- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 401-Water Fund Expenditures Dept: 242 Water- Production Acct Class: 530 Operating Expenditures/Expense 541.301 Postage 1,178 5,000 5,000 1,224 1,700 3,000 3,000 543.300 Utility Services 338,033 357,000 357,000 239,166 357,000 350,000 350,000 544.301 Operating Leases 6,690 10,000 10,000 4,074 10,000 8,000 8,000 546.302 Vehicle Repair&Maintenance 5,983 10,000 10,000 6,659 10,000 8,000 8,000 546.303 Building Repair&Maint 83,357 62,350 62,350 20,657 62,350 65,000 60,000 546.309 Landscape&Irrigation Maint 25,420 25,000 25,000 18,947 25,000 50,000 30,000 546.310 Equipment Repair&Maint 43,329 68,050 68,050 5,806 54,150 65,000 65,000 546.320 Computer system maint&suppli 43,265 22,500 26,687 20,050 26,687 37,200 33,900 546.342 Water System Maintenance 78,321 85,000 80,570 56,142 80,570 82,500 82,500 546.343 Well Redevelopment 0 0 0 0 0 547.300 Printing&Binding 3,014 3,000 3,000 2,578 3,000 3,000 3,000 549.300 Other Misc Chgs&Obligations 3,792 5,000 5,000 2,931 5,000 5,000 5,000 549.304 Licenses,Fees&Permits 29,481 30,000 30,000 21,281 30,000 30,000 30,000 551.300 Office Supplies&Equipment 6,897 4,000 4,000 6,650 8,000 7,000 7,000 552.301 Gas&Oil 3,105 5,000 5,000 1,698 5,000 4,000 4,000 302 Small Tools and Equipment 4,857 5,000 5,000 1,940 5,000 5,500 5,500 bb2.303 Diesel Fuel 6,168 15,000 10,000 4,548 10,000 7,000 7,000 552.305 Uniforms 2,639 4,000 4,000 2,147 4,000 4,000 4,000 552.341 Water Purchases 0 30,000 30,000 0 0 30,000 30,000 552.342 Water Chemicals 161,648 175,000 170,685 119,993 170,685 185,000 185,000 552.343 Laboratory Supplies 21,576 15,000 20,000 21,591 29,200 20,000 20,000 554.300 Books,Publ,Subs&Membership 1,482 1,600 1,898 1,897 1,897 2,000 2,000 Operating Expenditures/Expense 918,041 990,500 985,020 595,649 955,019 1,023,200 994,900 0 Acct Class: 590 Other Financing Sources&Uses 599.100 Budget Cost Savings 0 0 49,967 0 0 Other Financing Sources&Uses 0 0 49,967 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.601 Computer Equipment 0 0 243 243 243 664.607 Equipment-Tech 0 0 0 0 0 Capital Outlay 0 0 243 243 243 0 0 0 Water- Production 1,675,741 1,883,650 1,880,430 1,199,502 1,799,535 1,951,100 1,996,300 0 Dept: 243 Water-Distribution Acct Class: 510 Personal Services 512.100 Regular Salaries&Wages 390,939 419,900 419,900 290,580 419,500 476,500 478,900 100 Overtime 4,972 5,100 7,000 6,764 8,500 7,000 8,000 ,,,4.350 Overtime-Disaster 0 0 0 373 374 515.102 Standby Pay 9,843 10,200 15,000 16,290 22,200 15,000 24,500 BUDGET WORKSHEET Page: 8 6/28/2017 Village of Tequesta 12:05 pm Prior -------Current Year---- (6) (7) (8) __ Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 401-Water Fund Expenditures Dept: 243 Water-Distribution Acct Class: 510 Personal Services 515.103 Bonus Pay Plan 1,000 1,000 1,000 1,000 1,000 1,000 1,000 515.106 Clothing&Boot Allowance 500 550 563 563 563 900 900 515.107 Part-time Salaries 0 0 0 0 0 515.108 Auto Allowance 0 0 0 0 0 516.100 Compensated Absences 2,179 5,100 5,100 1,544 3,100 5,000 5,000 516.105 Compensated Absences-HSA 0 0 0 0 0 521.101 FICA Taxes 24,427 26,600 26,600 19,082 26,600 30,700 31,500 521.102 Medicare Taxes 5,713 6,300 6,300 4,463 6,300 7,200 7,400 522.101 FRS Contributions 10,878 11,600 15,400 10,960 15,400 18,300 23,000 522.102 VOT Pension Contributions 18,506 29,000 29,000 20,116 29,000 35,800 36,100 522.150 Pension Expense 2,419 0 0 0 0 523.101 Life/Health Insurance 78,295 88,900 88,900 71,664 86,100 114,600 114,600 523.105 HSA-Heath Savings Account 0 0 0 0 0 523.110 Retiree Health Care Expense 13,183 0 0 0 0 524.100 Workers'Comp Insurance 8,152 8,100 8,100 8,085 8,100 9,000 9,000 100 Unemployment Compensation 0 0 0 0 0 554.301 Personnel Training 2,969 3,000 3,000 1,228 1,500 3,000 3,000 Personal Services 573,975 615,350 625,863 452,712 628,237 724,000 742,900 0 Acct Class: 530 Operating Expenditures/Expense 540.300 Travel&Per Diem 155 1,000 1,000 79 100 500 500 541.300 Communication Services 9,926 14,000 14,000 8,288 13,000 14,000 14,000 541.301 Postage 22,125 24,000 24,000 16,583 24,000 24,000 24,000 544.301 Operating Leases 1,991 3,200 3,200 1,659 3,200 3,000 4,150 546.301 Office Equip/Repair&Maint 432 1,500 1,500 214 500 1,500 1,500 546.302 Vehicle Repair&Maintenance 8,098 10,000 15,000 12,194 15,000 10,000 10,000 546.303 Building Repair&Maint 622 10,000 5,000 2,337 5,000 5,000 5,000 546.309 Landscape&Irrigation Maint 273 1,000 1,000 17 100 7,000 2,000 546.310 Equipment Repair&Maint 2,249 6,500 6,500 2,882 5,500 5,000 5,000 546.320 Computer system maint&suppli 10,138 10,000 13,892 11,963 13,892 22,900 21,300 546.342 Water System Maintenance 38,297 45,000 36,000 36,781 42,500 45,000 45,000 547.300 Printing&Binding 2,195 3,000 3,000 3,197 3,200 3,000 3,000 549.300 Other Misc Chgs&Obligations 1,537 2,500 2,500 667 2,500 3,000 3,000 549.304 Licenses,Fees&Permits 1,673 1,800 1,800 1,664 1,800 1,800 1,800 "1.300 Office Supplies&Equipment 1,631 1,500 1,500 1,620 2,100 2,000 2,000 _.301 Gas&Oil 7,513 12,000 6,487 4,791 6,487 10,000 10,000 552.302 Small Tools and Equipment 2,114 5,000 5,000 1,463 1,500 5,000 5,000 BUDGET WORKSHEET Page: 9 6/28/2017 Village of Tequesta 12:05 pm Prior Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MAR RECOM CNCL ADOPT .und: 401-Water Fund Expenditures Dept: 243 Water-Distribution Acct Class: 530 Operating Expenditures/Expense 552.305 Uniforms 3,056 3,000 3,000 1,525 1,600 3,100 3,100 Operating Expenditures/Expense 114,025 155,000 144,379 107,924 141,979 165,800 160,350 0 Acct Class: 590 Other Financing Sources&Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.601 Computer Equipment 0 0 108 108 108 664.607 Equipment-Tech 0 0 0 0 0 Capital Outlay 0 0 108 108 108 0 0 0 Water-Distribution 688,000 770,350 770,350 560,744 770,324 889,800 903,250 0 Dept: 411 Renewal&Replacement Acct Class: 530 Operating Expenditures/Expense 531.302 Engineering Services 0 145,000 145,000 37,226 145,000 150,000 150,000 546.604 R&M-Pump and Motor Rehab 0 40,000 40,000 3,287 3,287 25,000 25,000 546.605 R&M-Well Rehabilitation 82,108 50,000 50,000 18,326 50,000 50,000 50,000 546.607 R&M-Water Mains 0 50,000 50,000 19,432 86,713 150,000 150,000 515 R&M-JIC-Engneering 0 0 6,907 0 6,907 546.617 R&M-JIC-Construction 0 0 845,432 845,432 845,432 549.671 Misc.Renewal&Replacement 4,013 1,060,000 1,060,000 4,291 1,060,000 580,000 580,000 552.601 Meters,Valves&Hydrants 3,669 181,800 321,400 29,295 321,400 198,000 198,000 552.603 FilterCartridges/ROP 5,186 7,000 7,000 4,999 7,000 552.605 Spare Pumps&Motors 3,564 10,000 10,000 2,947 10,000 Operating Expenditures/Expense 98,540 1,543,800 2,535,739 965,235 2,535,739 1,153,000 1,153,000 0 Acct Class: 600 Capital Outlay 663.671 Misc.Renewel and Replacement 0 0 0 0 0 664.600 Mach/Equipment 0 60,000 60,000 3,945 60,000 30,000 85,000 664.601 Computer Equipment 0 80,950 80,950 8,418 80,950 7,800 2,300 664.602 Vehicles 0 30,000 31,220 31,220 31,220 664.607 Equipment-Tech 0 0 0 0 0 75,000 75,000 Capital Outlay 0 170,950 172,170 43,583 172,170 112,800 162,300 0 Renewal&Replacement 98,540 1,714,750 2,707,909 1,008,818 2,707,909 1,265,800 1,315,300 0 Dept: 700 Debt Service Acct Class: 471 D/S-Principal 571.705 Prin-2004 Water N/P BOA 0 35,000 35,000 35,000 35,000 37,000 37,000 571.717 Backhoe Principle 0 0 0 0 0 10,000 720 Prin-2008 Water Utility Note 0 312,900 312,900 233,135 312,900 324,800 324,800 D/S-Principal 0 347,900 347,900 268,135 347,900 361,800 371,800 0 Acct Class: 472 D/S-Interest BUDGET WORKSHEET Page: 10 6/28/2017 Village of Tequesta 12:05 pm Prior -- Current Year --- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 401-Water Fund Expenditures Dept: 700 Debt Service Acct Class: 472 D/S-Interest 572.705 Int-2004 Water N/P BOA 10,303 9,400 9,400 5,462 9,400 7,700 7,700 572.717 Backhoe Interest 0 0 0 0 0 2,400 572.720 Int-2008 Water Utility Note 170,204 170,300 170,300 106,670 170,300 146,400 146,400 573.700 Other Debt Service Costs 22,467 0 0 0 0 D/S-Interest 202,974 179,700 179,700 112,132 179,700 154,100 156,500 0 Debt Service 202,974 527,600 527,600 380,267 527,600 515,900 528,300 0 Dept: 910 Other Financing Sources&Uses Acct Class: 590 Other Financing Sources&Uses 567.000 Gain/Loss on Investments 0 0 0 0 0 567.100 Unrealized Loss on Investments 0 0 0 0 0 Other Financng Sources&Uses 0 0 0 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 Dept: 950 Other Nonoperating Acct Class: 530 Operating Expenditures/Expense 559.300 Depreciation 1,077,679 0 0 0 0 559.301 Budgeted Depreciation(netted) 0 553,250 553,250 0 553,250 365,400 365,400 Operating Expenditures/Expense 1,077,679 553,250 553,250 0 553,250 365,400 365,400 0 Acct Class: 590 Other Financing Sources&Uses 549.391 Bank Charges 10,657 11,000 11,000 9,967 11,000 11,000 11,000 549.395 Credit Card Fees and Charges 11,705 11,000 11,000 9,353 11,000 11,000 11,000 567.000 Gain/Loss on Investments 0 0 0 0 0 590.001 Allocate to Fund Balance 0 0 0 0 0 999.001 Suspense 0 0 0 0 0 999.200 Suspense-AIP 0 0 0 0 • 0 Other Financing Sources&Uses 22,362 22,000 22,000 19,320 22,000 22,000 22,000 0 Other Nonoperating 1,100,041 575,250 575,250 19,320 575,250 387,400 387,400 0 Dept: 990 Other/Reserve/Contingency Acct Class: 590 Other Financing Sources&Uses 599.902 Reserves-Contingency 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 Other/Reserve/Contingency 0 0 0 0 0 0 0 0 Total Expenditures 4,726,853 6,555,250 7,547,156 3,935,062 7,459,582 6,117,400 6,226,850 0 Water Fund 138,427 0 0 -106,541 -2,434,444 -741,300 -850,750 0 The Village of Tequesta Capital Requests Fiscal Year 2018 Jnd: 401 - Water Fund - Capital $ 162,300.00 Dept. 411 Renewal and Replacement 664.600 Machinery& Equipment $ 85,000.00 Acoustic Water Leak Detection Equipment $ 20,000.00 Portable Electric Valve Operator $ 10,000.00 Backhoe $ 55,000.00 664.601 Computer Equipment $ 2,300.00 vMware Hosts(2) $ 2,300.00 664.607 Equipment -Tech $ 75,000.00 Fiber to Remote Sites $ 75,000.00 The Village of Tequesta Proposed Budget- DRAFT FY2 018 Proposed Fiscal Year 2018 Budget - DRAFT Refuse and Recycling Fund #402 ��� OF TFQ6 `se �`rA �, 'P r lot ,,,, .„ 1 ., it r,-•.-_--1 A to f 4... -44 0 ; ,;‘, - �q yt. :a�- N144 cov The Village of Tequesta Proposed Budget- DRAFT FY2018 VILLAGE OF TEQUESTA Refuse & Recycling Fund #402 SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: 490,956 484,000 488,184 499,400 3.18% EXPENDITURES: Personnel - - - - N/A Operating 489,875 484,000 484,000 499,400 3.18% Capital - - - - N/A Total Expenditures: 489,875 484,000 484,000 499,400 3.18% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time - - - Part Time - - Total Employees: - - - Explanation of Significant Changes The Village's current refuse and recycling rate of$157.70 will remain unchanged for FY2018. The number of units receiving refuse and recycling services remains unchanged at 3,197 for FY2018. The Village has budgeted for a 4% increase in refuse and recycling expenses for FY2018. The collection rate for FY2018 remains unchanged at 96%, assuming that all residents will take advantage of the early payment discount. BUDGET WORKSHEET Page: 11 6/28/2017 Village of Tequesta 12:05 pm Prior Current Year --- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT . und: 402-Refuse&Recycling Revenues Dept: 000 General Acct Class: 335 Intergovemmental Revenue 338.110 Recycling Shared Rev - SWA 4,435 0 0 4,023 4,023 Intergovernmental Revenue 4,435 0 0 4,023 4,023 0 0 0 Acct Class: 340 Charges for Services 343.307 Penalty Charges 0 0 0 0 0 343.400 Refuse/Recycling Fees 486,366 484,000 484,000 475,028 484,000 484,000 Charges for Services 486,366 484,000 484,000 475,028 484,000 0 484,000 0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 0 0 0 0 0 Miscellaneous Revenues 0 0 0 0 0 0 0 0 Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 0 0 0 0 15,400 Other Financing Sources 0 0 0 0 0 0 15,400 0 General 490,801 484,000 484,000 479,051 488,023 0 499,400 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investment Eamin 361.100 Interest/Investment Eamings 138 0 0 111 150 101 PBC Tax Col-Interest on Dep 17 0 0 11 11 sb/.100 Net Unreal appreciation(Dep) 0 0 0 0 0 Unrestricted Investment Eamin 155 0 0 122 161 0 0 0 Other Nonoperating 155 0 0 122 161 0 0 0 Total Revenues 490,956 484,000 484,000 479,173 488,184 0 499,400 0 Expenditures Dept: 245 Refuse and Recycling Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 0 0 0 0 0 543.302 Solid Waste/Residential 256,655 259,000 259,000 172,638 259,000 269,400 543.303 Recycling/Residential 90,923 91,700 91,700 61,127 91,700 95,600 543.304 Yard Waste/Residential 85,168 85,950 85,950 57,290 85,950 89,400 543.305 PBC Tax Col Fees&Discounts 0 0 0 0 0 543.306 Fuel Factor 49,490 39,150 39,150 23,274 39,150 36,500 549.300 Other Misc Chgs&Obligations 189 600 600 185 600 600 600 549.301 Admin Mgmt Fees 7,450 7,600 7,600 5,067 7,600 7,900 7,900 Operating Expenditures/Expense 489,875 484,000 484,000 319,581 484,000 8,500 499,400 0 Refuse and Recycling 489,875 484,000 484,000 319,581 484,000 8,500 499,400 0 Dept: 910 Other Financing Sources&Uses .._ct Class: 590 Other Financing Sources&Uses 567.000 Gain/Loss on Investments 0 0 0 0 0 BUDGET WORKSHEET Page: 12 6/28/2017 Village of Tequesta 12:05 pm Prior Current Year ——— (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REO MGR RECOM CNCL ADOPT .und: 402-Refuse&Recycling Expenditures Dept: 910 Other Financing Sources&Uses Acct Class: 590 Other Financing Sources&Uses 567.100 Unrealized Loss on Investments 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 Dept: 950 Other Nonoperating Acct Class: 590 Other Financing Sources&Uses 567.000 Gain/Loss on Investments 0 0 0 0 0 590.001 Allocate to Fund Balance 0 0 0 0 0 Other Finandng Sources&Uses 0 0 0 0 0 0 0 0 Other Nonoperating 0 0 0 0 0 0 0 0 Total Expenditures 489,875 484,000 484,000 319,581 484,000 8,500 499,400 0 Refuse&Recycling 1,081 0 0 159,592 4,184 -8,500 0 0 The Village of Tequesta Proposed Budget- DRAFT FY2 018 Proposed Fiscal Year 2018 Budget - DRAFT Storm Water Utility Fund #403 T e� OF 1'FQe# `• 4") 'P — .4, 1i 7;••'.‘a6,-' ---' v 'A* I ' '. ,,i'-''' 414- ' � �\\M 1, " COO" The Village of Tequesta Proposed Budget- DRAFT FY2018 VILLAGE OF TEQUESTA Storm Water Fund #403 SUMMARY FY 2016 FY 2017 FY 2017 FY 2018 Difference Prior Year Amended Estimated Draft Budget to REVENUES: Actual Budget Actual Budget Budget (%) Total Revenues: 326,072 606,250 342,158 375,300 -38.09% EXPENDITURES: Personnel 120,835 110,138 107,138 115,000 4.41% Operating 117,411 136,085 130,721 145,200 6.70% Capital - 15,027 13,027 55,000 266.01% Renewal & Replacement 146,138 250,000 249,685 275,000 10.00% Debt Service - - - 12,400 N/A Other 106,021 95,000 95,000 115,000 21.05% Total Expenditures: 490,405 606,250 595,571 717,600 18.37% Employees FY 2016 FY 2017 FY 2018 Number of Employees: Actual Estimated Proposed Full Time 1.70 1.70 1.70 Part Time - - Total Employees: 1.70 1.70 1.70 Explanation of Significant Changes Revenues: Staff is recommending a 10% increase in storm water utility fees in FY2018. This fund is also appropriating more reserves in FY2018 to improve the drainage system. Personnel: This increase is primarily due to employee salary increases, projected increases in health insurance premiums and increased defined benefit pension contribution rates. Operating: This increase is primarily due to contractual labor costs associated with a project on Pine Tree Drive. Renewal & Replacement: This department is appropriating more reserves in FY2018 to improve the drainage system. Debt Service: The Water Utility and Storm Water Utility Funds are entering into a five (5) year lease for a backhoe in FY2018. Other: Other includes transfers out and budgeted depreciation. BUDGET WORKSHEET Page: 13 6/28/2017 Village of Tequesta 12:05 pm Prior Current Year -- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT und: 403-Stormwater Utility Revenues Dept: 000 General Acct Class: 340 Charges for Services 343.901 Storm Water Utility Fees 325,005 341,250 341,250 333,537 341,250 375,300 375,300 Charges for Services 325,005 341,250 341,250 333,537 341,250 375,300 375,300 0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 0 0 0 0 0 Miscellaneous Revenues 0 0 0 0 0 0 0 0 General 325,005 341,250 341,250 333,537 341,250 375,300 375,300 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investment Eamin 361.100 Interest/Investment Eamings 1,056 0 0 722 900 361.101 PBC Tax Col-Interest on Dep 11 0 0 8 8 367.100 Net Unreal appreciation(Dep) 0 0 0 0 0 Unrestricted Investment Eamin 1,067 0 0 730 908 0 0 0 Other Nonoperating 1,067 0 0 730 908 0 0 0 Dept: 990 Other/Reserve/Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 265,000 265,000 0 0 Other Financing Sources 0 265,000 265,000 0 0 0 0 0 Other/Reserve/Contingency 0 265,000 265,000 0 0 0 0 0 Total Revenues 326,072 606,250 606,250 334,267 342,158 375,300 375,300 0 Expenditures Dept: 250 Storm Water Utilities Acct Class: 510 Personal Services 512.100 Regular Salaries&Wages 82,630 69,900 73,300 50,947 73,300 77,100 77,100 514.100 Overtime 1,533 1,000 1,000 107 0 1,000 1,000 515.102 Standby Pay 3,147 2,000 2,000 376 0 515.103 Bonus Pay Plan 0 100 100 100 100 100 100 515.106 Clothing&Boot Allowance 100 150 188 188 188 200 200 515.108 Auto Allowance 720 750 750 526 750 800 800 515.120 Cell phone allowance 240 250 250 175 250 300 300 516.100 Compensated Absences 383 0 0 0 0 516.105 Compensated Absences-HSA 0 0 0 0 0 521.101 FICA Taxes 5,434 4,600 4,800 3,495 4,800 5,000 5,000 521.102 Medicare Taxes 1,271 1,100 1,200 817 1,200 1,200 1,200 522.102 VOT Pension Contributions 6,391 7,500 7,850 5,436 7,850 8,700 8,700 150 Pension Expense -1,786 0 0 0 0 0z3.101 Life/Health Insurance 13,203 11,300 12,200 10,124 12,200 13,500 13,500 523.105 HSA-Heatth Savings Account 0 0 0 0 0 BUDGET WORKSHEET Page: 14 6/28/2017 Village of Tequesta 12:05 pm Prior Current Year - ---- (6) (7) (8) Year Original Amended Actual Thru Estimated 6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT ,und: 403-Stormwater Utility Expenditures Dept: 250 Storm Water Utilities Acct Class: 510 Personal Services 523.110 Retiree Health Care Expense 6,465 0 0 0 0 524.100 Workers'Comp Insurance 1,003 5,500 5,500 5,456 5,500 6,100 6,100 526.102 Employee Assistance Program 101 0 0 0 0 554.301 Personnel Training 0 1,000 1,000 833 1,000 1,000 1,000 Personal Services 120,835 105,150 110,138 78,580 107,138 115,000 115,000 0 Acct Class: 530 Operating Expenditures/Expense 531.302 Engineering Services 3,280 10,000 10,000 0 5,500 10,000 10,000 532.300 Accounting&Auditing Services 4,261 4,200 4,448 4,447 4,448 4,300 4,300 534.300 Other Contractual Services 46,366 28,450 28,450 0 28,450 40,000 46,000 540.300 Travel&Per Diem 0 1,500 1,500 30 500 500 500 541.300 Communication Services 4,176 6,000 6,000 2,476 6,000 7,000 7,000 541.301 Postage 0 1,100 1,100 0 0 500 500 545.300 Insurance 0 450 450 415 450 500 500 546.302 Vehicle Repair&Maintenance 1,772 2,000 2,000 2,443 3,500 2,000 2,000 546.303 Building Repair&Maint 405 2,000 2,000 2,435 5,000 1,000 1,000 308 Drainage Maintenance 30,521 45,000 42,000 21,209 42,000 50,000 42,000 48.310 Equipment Repair&Maint 1,926 5,000 5,000 1,347 5,000 2,000 2,000 546.320 Computer system maint&suppli 964 1,400 4,373 1,845 4,373 1,500 1,000 549.300 Other MiscChgs&Obligations 1,520 2,000 1,850 916 1,850 2,000 2,000 549.301 Admin Mgmt Fees 12,700 13,000 13,000 8,633 13,000 13,400 13,400 549.304 Licenses,Fees&Permits 3,889 4,500 4,650 4,638 4,650 5,000 5,000 551.300 Office Supplies&Equipment 93 1,000 1,000 191 1,000 1,000 1,000 552.301 Gas&Oil 1,270 5,000 2,500 742 1,500 1,500 1,500 552.302 Small Tools and Equipment 4,268 7,500 4,764 1,386 3,000 5,000 5,000 554,100 Public Education Program 0 1,000 1,000 0 500 500 500 Operating Expenditures/Expense 117,411 141,100 136,085 53,153 130,721 147,700 145,200 0 Acct Class: 590 Other Financing Sources&Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 662.632 Architect&Engeering 0 0 0 0 0 663.663 Drainage Improvements 0 0 0 0 0 664.600 Mach/Equipment 0 15,000 15,000 12,863 13,000 55,000 664.601 Computer Equipment 0 0 27 27 27 302 Vehicles 0 0 0 0 0 664.607 Equipment-Tech 0 0 0 0 0 Capital Outlay 0 15,000 15,027 12,890 13,027 0 55,000 0 BUDGET WORKSHEET Page: 15 6/28/2017 Village of Tequesta 12:05 pm Prior - -- -Current Year-- ---- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT ,und: 403-Stormwater Utility Expenditures Storm WaterU6lities 238,246 261,250 261,250 144,623 250,886 262,700 315,200 0 Dept: 411 Renewal&Replacement Acct Class: 530 Operating Expenditures/Expense 531.302 Engineering Services 0 40,000 40,000 23,811 39,685 50,000 25,000 546.308 Drainage Maintenance 146,138 210,000 210,000 0 210,000 250,000 250,000 546.319 S.Cypress rear alleyway improv 0 0 0 0 0 546.321 Budget Alleyway Improvements 0 0 0 0 0 546.322 Seabrook Stormwater Imprvmnts 0 0 0 0 0 Operating Expenditures/Expense 146,138 250,000 250,000 23,811 249,685 300,000 275,000 0 Renewal&Replacement 146,138 250,000 250,000 23,811 249,685 300,000 275,000 0 Dept: 700 Debt Service Acct Class: 471 D/S-Principal 571.717 Backhoe Principle 0 0 0 0 0 10,000 D/S-Principal 0 0 0 0 0 0 10,000 0 Acct Class: 472 D/S-Interest 572.717 Backhoe Interest 0 0 0 0 0 2,400 D/S-Interest 0 0 0 0 0 0 2,400 0 Debt Service 0 0 0 0 0 0 12,400 0 Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 591.401 Tfr to Water Utilities#401 0 0 0 0 0 Interfund Transfers Out 0 0 0 0 0 0 0 0 Interfund Transfers 0 0 0 0 0 0 0 0 Dept: 910 Other Financing Sources&Uses Acct Class: 590 Other Financing Sources&Uses 567.100 Unrealized Loss on Investments 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 Dept: 950 Other Nonoperating Acct Class: 530 Operating Expenditures/Expense 559.300 Depreciation 106,021 0 0 0 0 559.301 Budgeted Depreciation(netted) 0 95,000 95,000 0 95,000 115,000 115,000 Operating Expenditures/Expense 106,021 95,000 95,000 0 95,000 115,000 115,000 0 Acct Class: 590 Other Financing Sources&Uses 567.000 Gain/Loss on Investments 0 0 0 0 0 590.001 Allocate to Fund Balance 0 0 0 0 0 Other Financing Sources&Uses 0 0 0 0 0 0 0 0 Other Nonoperating 106,021 95,000 95,000 0 95,000 115,000 115,000 0 Dept: 990 Other/Reserve/Contingency Acct Class: 590 Other Financing Sources&Uses 599.902 Reserves-Contingency 0 0 0 0 0 BUDGET WORKSHEET Page: 16 6/28/2017 Village of Tequesta 12:05 pm Prior Current Year — -- (6) (7) (8) Year Original Amended Actual Thru Estimated :6/30/2017 Actual Budget Budget June Total DEPT REQ MGR RECOM CNCL ADOPT ,und: 403-Stormwater Utility Expenditures Dept: 990 Other/Reserve/Contingency Other Finandng Sources 8 Uses 0 0 0 0 0 0 0 0 Other/Reserve/Contingency 0 0 0 0 0 0 0 0 Total Expenditures 490,405 606,250 606,250 168,434 595,571 677,700 717,600 0 Stormwater Utility -164,333 0 0 165,833 -253,413 -302,400 -342,300 0 Grand Total: 68,966 0 0 216,801 -2,733,756 -1,052,200 -1,193,050 0 The Village of Tequesta Capital Requests Fiscal Year 2018 Fund: 403 - Storm Water Fund - Capital $ 55,000.00 _ Dept.250 Storm Water 664.600 Machinery& Equipment $ 55,000.00 Backhoe $ 55,000.00