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_Tab 01_08/29/2016_amended budget
BUDGET WORKSHEET FY2017 DRAFT at OS/19/16 Page: 1 8/2912016 Village of Tequesta 11:19 am Prior ---------------------- Curzent Year --------------- (6) (�) ($) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Revenues Dept: 000 General Acct Class: 311 General Property Taxes 311.000 Ad Valorem Taxes- Current 5,237,859 5,618,900 5,618,900 5,651,698 5,651,698 6,074,400 311.100 Ad Valorem Taxes-Del 37,552 10,000 10,000 31,869 31,869 30,000 GeneralProperty Taxes 5,275,411 5,628,900 5,628,900 5,683,567 5,683,567 0 6,104,400 0 Acct Class: 316 Sales & Use Taxes 312.510 Fire Insurance Prem Tax 189,010 122,500 122,500 0 155,000 155,000 155,000 314.100 U61ity Tax-Electricity 509,338 476,000 476,000 415,810 490,000 500,000 314.300 Utility Tax-Water 169,550 163,000 163,000 152,252 168,000 122,000 314.400 UtilityTax-NaturalGas 1,195 300 300 1,355 1,500 1,500 314.800 UfilityTax-Propane 27,159 30,000 30,000 21,789 27,000 27,000 315.000 Comm.ServicesTax(CST} 317,979 310,000 310,000 251,903 300,000 281,000 321.000 Local Business Tax 76,182 75,000 75,000 81,604 82,000 81,000 81,000 321.001 Home Business Tax 4,750 4,500 4,500 4,445 4,500 4,800 4,800 321.010 LocalBusiness Tax- County 9,148 4,800 4,800 6,281 6,281 7,800 7,800 Sales & Use Taxes 1,304,311 1,186,100 1,186,100 935,439 1,234,281 248,600 1,180,100 0 Acct Class: 318 Franchise fees - gross receipt 313.100 Fran Fees-Elechic 462,312 456,000 456,000 365,150 462,000 462,000 Franchise fees - gross receipt 462,312 456,000 456,000 365,150 462,000 0 462,000 0 Acct Class: 329 Intragovemmental Revenue 341.401 Admin Mgmt Fees-Water 514,780 530,200 530,200 486,017 530,200 540,800 540,800 341.402 Admin Mgmt Fee-Ref & Recycling 7,270 7,450 7,450 6,829 7,450 7,600 7,600 341.403 Admin Mgmt Fees - Storm Water 12,340 12,700 12,700 11,642 12,700 12,950 12,950 369.010 Misc Revenue - Hats 26 0 0 0 0 Intragovernmental Revenue 534,416 550,350 550,350 504,488 550,350 561,350 561,350 0 Acct Class: 335 Intergovemmental Revenue 335.120 Municipal Revenue Sharing Prog 178,888 180,000 180,000 164,548 180,000 182,000 335.150 Alcoholic Beverage Licenses 10,931 6,000 6,000 6,922 8,000 8,000 335.180 Loc Gov 1/2 Cent Sales Tax Pro 436,966 460,000 460,000 379,532 453,300 463,600 338.101 Local Gas Tax-6 Cent 125,371 126,000 126,000 107,610 125,000 131,500 338.102 Local Gas Tax1-5 Cent 58,888 58,900 58,900 50,052 58,000 60,000 Intergovernmental Revenue 811,044 830,900 830,900 708,664 824,300 0 845,100 0 Acct Class: 341 Chgs for Serv - Geo Gov 341.101 Certification/Copy Fees 13,468 12,000 12,000 12,701 13,500 12,000 341.103 Election qualifying fees 60 0 0 90 90 341.105 Admin fees from otherGov'ts 1,999 1,200 1,200 1,203 1,203 1,200 Chgs for Serv - Gen Gov 15,527 13,200 13,200 13,994 14,793 0 13,200 0 Acct Class: 362 Rents & Royalties 362.110 Lease - Sprint 37,188 38,300 38,300 35,111 38,300 39,400 �"a9 (� I �Crn t a�.m��,�,� b�.dq.�- BUDGET WORKSHEET FY2017 DRAFT at 08/19116 Page: 2 8/29/2016 �Ilage of Tequesta 11:19 am Prior -------------------- Current Year -------------------- (6) ��) �$) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Revenues Dept: 000 General Acct Class: 362 Rents & Royalties 362.112 Lease-T-Mobile 52,836 54,950 54,950 49,878 54,430 57,100 362.115 Lease - Ne�el 0 0 0 0 0 362.116 Lease - AT&T 30,000 30,000 30,000 30,000 30,000 30,000 362.117 Verizon-901 Old Dixie 36,240 37,650 37,650 34,445 37,440 39,100 362.118 Verizon-136 Bridge Rd 30,075 30,500 30,500 27,951 30,450 30,900 Rents & Royalties 186,339 191,400 191,400 177,385 190,620 0 196,500 0 Acct Class: 366 Contributions & Donafions 366.100 Contrib 8 Dona6ons & Sponsors 0 0 0 0 0 Contributions 8 Donafions 0 0 0 0 0 0 0 0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 1,176 0 0 306 306 369.100 Insurance Reimbursement 11,816 0 0 12,279 12,279 12,000 Miscellaneous Revenues 12,992 0 0 12,585 12,585 0 12,000 0 General 8,602,352 8,856,850 8,856,850 8,401,272 8,972,496 809,950 9,374,650 0 Dept: 150 Comprehensive Planning Acct Class: 340 Charges for Services 343.700 Water Conservation & Resource 959 0 0 0 0 Charges for Services 959 0 0 0 0 0 0 0 Acct Class: 341 Chgs for Serv - Gen Gov 341.150 Land DevelopmentFees 49,551 35,000 35,000 47,630 50,000 35,000 35,000 Chgs for Serv - Gen Gov 49,551 35,000 35,000 47,630 50,000 35,000 35,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 Comprehensive Planning 50,510 35,000 35,000 47,630 50,000 35,000 35,000 0 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 Ciass: 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 Biock �rant 2,387 0 0 0 0 Grants - State 2,387 0 0 0 0 0 0 0 Acct Ciass: 335 Intergovernmentai Revenue 338.201 PBC 911 Maint Reimbursement 11,669 8,000 8,000 0 8,000 8,000 338.202 PBC 911 DISPATCH REIMBURSEMENT 15,170 18,300 18,300 0 18,300 18,000 BUDGET WORKSHEET FY2017 DRAF'f at 08119/16 Page: 3 8/29/2016 Village of Tequesta 11:19 am Prior --------- Current Year ---------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Revenues Dept: 171 Police Intergovemmental Revenue 26,839 26,300 26,300 0 26,300 0 26,000 0 Acct Class: 337 Grants & Contributions - Local 366.122 Donations -Military to Main St 7,500 0 0 0 0 Grants & Contributions - Local 7,500 0 0 0 0 0 0 0 Acct Class: 342 Chgs for Serv - Public Safety 342.110 PBC - Marine law enforce. serv 16,660 16,600 16,600 16,660 16,600 16,600 16,600 Chgs for Serv - Public Safety 16,660 16,600 16,600 16,660 16,600 16,600 16,600 0 Acct Class: 351 Fines & Forfeitures 351.100 Court Fines 13,862 5,000 5,000 9,671 10,000 5,000 5,000 351.250 $12.50 traffic violation fund 0 0 0 5,424 5,424 5,500 354.101 Parking Tickets 4,470 1,000 1,000 1,000 1,000 500 500 354.102 Code Enf Fines & Court Costs 0 0 0 0 0 Fines & Forfeitures 18,332 6,000 6,000 16,095 16,424 5,500 11,000 0 Acct Class: 363 Impact Fees 362221 Police Impact Fees 252 0 0 63 63 impact Fees 252 0 0 63 63 0 0 0 Acct Class: 366 Contributions & Donations 366.100 Contrib & Donations & Sponsors 2 0 0 0 0 Contributions & DonaGons 2 0 0 0 0 0 0 0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 4,147 0 0 2,640 2,640 Misceilaneous Revenues 4,147 0 0 2,640 2,640 0 0 0 Police 76,119 48,900 48,900 35,458 62,027 22,100 53,600 0 Dept: 175 Police Department Acct Class: 369 Misceilaneous Revenues 359.100 Forfeitures/Confiscafions 50 0 0 50 50 Misceilaneous Revenues 50 0 0 50 50 0 0 0 Police DepaRment 50 0 0 50 50 0 0 0 Dept: 180 Building & Zoning Acct Class: 320 Licenses & Permits 322.000 Building PermitFees 333,173 394,000 394,000 498,380 500,000 502,000 502,000 329.000 Contractor's Registration 8,320 9,700 9,700 7,770 7,770 329.010 Contractor Reg. - County 5,036 5,300 5,300 2,968 2,968 Licenses 8 Permits 346,529 409,000 409,000 509,118 510,738 502,000 502,000 0 Acct Class: 351 Fines & Forfeitures 354.102 Code Enf Fines & CouR Costs 71,333 48,000 48,000 36,594 48,000 42,000 54,000 Fines & Forfeitures 71,333 48,000 48,000 36,594 48,000 42,000 54,000 0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 0 0 0 120 120 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 4 8/29/2016 Village of Tequesta 11:19 am Prior --------------- Current Year --- (6) (� (8) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - �eneral Fund Revenues Dept: 180 Building & Zoning Miscellaneous Revenues 0 0 0 120 120 0 0 0 Building & Zoning 417,862 457,000 457,000 545,832 558,858 544,000 556,000 0 Dept: 192 Fire Control Acct Class: 334 Grants - State 337.201 Local Govemment Grant PBC 0 0 24,200 0 24,200 �rants - State 0 0 24,200 0 24,200 0 0 0 Acct Class: 335 Intergovemmental Revenue 335.201 Fire Incentive Pay 4,066 3,600 3,600 2,700 3,000 3,000 3,000 Intergovemmental Revenue 4,066 3,600 3,600 2,700 3,000 3,000 3,000 0 Acct Class: 340 Charges for Services 342.950 Allow for doubtful rev- �ovFnd 0 0 0 0 0 Charges for Services 0 0 0 0 0 0 0 0 Acct Class: 342 Chgs for Serv - Public Safety 342.192 Fire - Extra Duty 0 500 500 5,857 5,857 750 750 342.201 Fire Plan Review Fees 21,851 30,000 30,000 40,205 40,205 30,600 30,600 342.202 Fire Inspectlons 28,678 23,700 23,700 24,869 25,000 24,100 24,100 342.401 Emergency Service-JIC 400,000 400,000 400,000 400,000 400,000 400,000 400,000 342.402 Fire Rescue-CPR Program 1,015 700 700 300 600 700 700 342.410 Emergency Svc- PBC Fire Rescue 265,206 201,000 219,773 234,631 234,631 207,000 207,000 342.600 EMS Transportation Fees 332,858 315,000 315,000 309,698 325,000 350,900 350,900 ChgsforServ-PublicSafety 1,049,608 970,900 989,673 1,015,560 1,031,293 1,014,050 1,014,050 0 Acct Class: 363 Impact Fees 362.222 Fire Impact Fees 348 500 500 88 350 500 500 ImpactFees 348 500 500 88 350 500 500 0 Acct Class: 366 Contributions & Donations 366.100 Contrib & Donations & Sponsors 5 250 250 375 375 250 250 Contributions & Dona6ons 5 250 250 375 375 250 250 0 Acct Class: 369 Miscellaneous Revenues 365.102 Fire Dept Sales 95 50 50 43 70 50 50 369.000 Other Miscellaneous Revenue 160 1,600 1,600 4,421 4,500 3,000 3,000 Miscellaneous Revenues 255 1,650 1,650 4,464 4,570 3,050 3,050 0 FireConfiol 1,054,282 976,900 1,019,873 1,023,187 1,063,788 1,020,850 1,020,850 0 Dept: 231 Leisure Services Acct Ciass: 334 Grants - State 334.205 State DEP Grant -(FRDAP) 0 50,000 50,000 0 50,000 Grants - State 0 50,000 50,000 0 50,000 0 0 0 Acct Class: 347 Charges for Services - Recr. 347.100 Tequesta Fest 7,752 7,800 7,800 5,396 5,396 7,800 7,800 347.190 Special Events - Other 10,602 10,000 10,000 4,980 6,000 6,000 6,000 BUOGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 5 8/29/2016 �Ilage of Tequesta 11:19 am Prior ----------------- Current Year ---------------- (6) (� (8) Year Originai Amended Actual Thru Es6mated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Revenues Dept: 231 Leisure Services Acct Class: 347 Charges for Services - Recr. 347.201 Winter/Summer Camp Fees 32,531 37,750 37,750 39,951 39,951 37,500 37,500 347.205 Recreation Programs Fees 8,953 6,000 6,000 8,517 8,900 6,000 6,000 Charges for Services - Recr. 59,838 61,550 61,550 58,844 60,247 57,300 57,300 0 Acct Class: 362 Rents & Royalties 362.100 Rental - Faalities 5,917 6,500 6,500 7,371 7,400 6,500 6,500 Rents 8 Royalties 5,917 6,500 6,500 7,371 7,400 6,500 6,500 0 Acct Class: 363 Impact Fees 363.271 Parks and Rec Impact Fees 1,102 0 0 276 276 Impact Fees 1,102 0 0 276 276 0 0 0 Acct Class: 366 Conhibutions & Donations 366.100 Contrib & Donations & Sponsors 7,500 7,200 7,200 4,500 4,500 4,500 4,500 Contributions & DonaGons 7,500 7,200 7,200 4,500 4,500 4,500 4,500 0 Acct Class: 369 Miscellaneous Revenues 365.110 Concession Sales 921 5,000 5,000 1,009 1,009 1,500 1,500 369.000 Other Miscellaneous Revenue 0 0 0 0 0 Miscellaneous Revenues 921 5,000 5,000 1,009 1,009 1,500 1,500 0 Leisure Services 75,278 130,250 130,250 72,000 123,432 69,800 69,800 0 Dept: 900 Interfund Transfers Acct Class: 391 Transfers In 381.301 Transfer-In from Cap Improvemn 0 0 0 0 0 381.303 Tsfer-In from Capitai Projects 0 0 0 0 0 381.605 Tfr In - Special Law Enf Trust 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: 910 Other Financing Sources & Uses Acct Class: 390 Other Financing Sources 383.100 Capital Lease at Inception 240,658 163,300 163,300 132,774 133,300 Other Financing Sources 240,658 163,300 163,300 132,774 133,300 0 0 0 OtherFinancing Sources & Uses 240,658 163,300 163,300 132,774 133,300 0 0 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investment Eamin 361.100 InteresUlnvestment Earnings 6,997 8,500 8,500 6,665 7,900 5,000 361.101 PBC Tax Col-Interest on Dep 142 0 0 200 200 367.100 Net Unreai appreciation (Dep) 0 0 0 0 0 Unrestricted Investment Eamin 7,139 8,500 8,500 6,865 8,100 0 5,000 0 Acct Class: 369 Misceilaneous Revenues 364.100 Disposition of Assets 13,073 250,000 6,000 15,409 15,409 10,000 Miscellaneous Revenues 13,073 250,000 6,000 15,409 15,409 0 10,000 0 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 6 8/29/2016 Village of Tequesta 11:19 am Prior ----------------- Current Year --------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Revenues Other Nonoperating 20,212 258,500 14,500 22,274 23,509 0 15,000 0 Dept: 990 Other/ReservelContingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 0 318,478 0 0 247,850 Other Financing Sources 0 0 318,478 0 0 0 247,850 0 Other/Reserve/Contingency 0 0 318,478 0 0 0 247,850 0 Total Revenues 10,537,323 10,926,700 11,044,151 10,280,477 10,987,460 2,501,700 11,372,750 0 Expenditures Dept: 100 Council Acct Class: 530 Operating Expenditures/Expense 531.311 Council Fees -Are�a 3,000 5,100 5,100 4,500 5,100 7,300 7,300 531.313 Council fees - T. Patemo 3,000 3,000 3,000 2,750 3,000 5,200 5,200 531.314 Council fees - F. D'Ambra 3,000 5,100 5,100 4,500 5,100 7,300 7,300 531.316 Council fees - S. Okun 3,000 5,100 5,100 4,500 5,100 7,300 7,300 531.317 Council Fees - Brennan 3,000 3,000 3,000 2,750 3,000 5,200 5,200 540.301 CouncilExpenses-Arena 0 3,000 1,183 1,183 1,183 3,000 3,000 540.304 Council Expense - F. D'Ambra 1,764 3,000 2,500 500 500 3,000 3,000 540.306 Council Expense - S. Okun 2,915 3,000 3,000 534 3,000 3,000 3,000 540.307 CouncilExpenses-Brennan 2,892 3,000 3,300 3,400 3,400 3,000 3,000 540.308 Council Expenses - Patemo 1,214 3,000 3,000 0 3,000 3,000 3,000 549.300 Other Misc Chgs & Obligations 284 700 700 624 668 700 700 549.350 VolunteerAppreciation 843 800 800 1,171 1,172 800 1,400 554.300 Books, Publ, Subs & Membership 3,060 3,500 3,500 3,060 3,060 3,700 3,700 582.800 Aid to Community Organizations 0 0 0 0 0 582.801 Aid to Com.Org - Arena 500 0 500 500 500 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 28,972 41,300 40,283 30,472 38,283 52,500 53,100 0 Council 28,972 41,300 40,283 30,472 38,283 52,500 53,100 0 Dept: 110 Manager Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 141,027 146,900 146,900 130,052 146,900 153,400 153,400 514.100 Overtime 0 0 0 0 0 515.103 Bonus Pay Plan 5,000 750 8,250 8,250 8,250 750 750 515.108 Auto Allowance 3,000 3,000 3,000 2,750 3,000 3,000 3,000 515.125 OtherAllowances 1,200 1,200 1,200 1,100 1,200 1,200 1,200 516.100 CompensatedAbsences 0 3,500 3,500 1,100 1,101 3,650 1,750 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 7 8/29/2016 Village of Tequesta 11:19 am Prior ------------------------ Current Year --------------- (s) (�) ($) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 110 Manager Acct Class: 510 Personal Services 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 7,240 8,000 8,000 7,139 7,700 8,000 7,800 521.102 Medicare Taxes 2,330 2,400 2,400 2,235 2,500 2,400 2,400 522.102 VOT Pension Contributions 11,889 11,000 11,000 9,728 11,000 12,700 16,400 523.101 Life/Heaith insurance 17,577 19,700 19,700 18,015 19,700 19,700 20,900 523.105 HSA - Health Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 234 250 250 237 237 250 250 526.104 ICMA-Def Comp Pian 10,219 10,700 10,700 9,447 10,700 11,200 11,200 554.301 Personnel Training 785 1,000 1,000 0 0 1,000 Personal Services 200,501 208,400 215,900 190,053 212,288 217,250 219,050 0 Acct Ciass: 530 Operating Expenditures/Expense 540.300 Travel & Per Diem 2,224 1,400 1,400 0 0 2,200 546.320 Computer system maint 8 suppli 1,948 800 800 0 0 800 800 549.300 Other Misc Chgs & Obligations 0 250 250 500 500 250 250 554.300 Books, Publ, Subs & Membership 2,528 3,400 3,400 2,287 3,400 3,700 3,700 Operating Expenditures/Expense 6,700 5,850 5,850 2,787 3,900 6,950 4,750 0 Acct Ciass: 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 Capital0utlay 0 0 0 0 0 0 0 0 Manager 207,201 214,250 221,750 192,840 216,188 224,200 223,800 0 Dept: 111 Human Resources Acct Ciass: 510 Personal Services 512.100 Regular Salaries & Wages 104,899 138,400 135,000 119,403 134,950 141,200 148,700 515.103 BonusPayPlan 0 750 750 750 750 1,500 1,500 515.107 Part-fime Salaries 27,322 0 0 0 0 6,750 515.120 Cellphoneallowance 700 1,200 1,200 1,100 1,200 1,200 1,200 516.100 Compensated Absences 3,353 2,700 2,700 2,618 2,618 2,850 2,800 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 8,358 8,700 8,700 7,419 8,350 8,900 9,800 521.102 Medicare Taxes 1,955 2,100 2,100 1,735 2,000 2,100 2,700 522.102 VOT Pension Contributions 8,843 10,400 10,400 8,931 10,100 11,700 15,900 523.101 LifelHealth Insurance 11,040 26,600 26,600 24,360 26,575 26,700 28,200 523.105 HSA - Health Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 195 250 250 223 223 250 250 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 8 8/2912016 Village of Tequesta 11:19 am Prior -----___.___--------- Current Year ---------------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 111 Human Resources Acct Class: 510 Personal Services 525.100 UnemploymentCompensation 1,925 0 0 0 0 526.101 Employee Recognition Program 7,152 10,000 10,000 6,264 10,000 12,000 12,000 526.102 Employee Assistance Program 3,406 4,200 16,200 9,406 15,500 10,200 10,200 526.103 EducationReimbursementPrgm 0 1,000 1,000 0 1,000 1,000 1,000 554.301 Personnei Training 1,875 2,500 2,500 1,485 2,500 3,000 3,000 554.310 Employee Development 2,431 4,000 4,000 2,013 4,000 4,000 10,000 Personal Services 183,454 212,800 221,400 185,707 219,766 226,600 254,000 0 Acct Class: 530 Operating Expenditures/Expense 534.300 Other Contractual Services 0 0 0 477 477 500 540.300 Travel & Per Diem 2,314 2,000 2,000 1,710 2,000 2,500 2,500 546.320 Computer system maint & suppli 522 1,200 9,930 9,034 10,920 13,200 15,000 547.300 Printing&Binding 1,044 1,500 215 0 215 1,500 1,500 549.300 Other Misc Chgs & Obliga6ons 0 500 500 275 500 500 500 549.401 Recruitmentexpenses 914 1,500 1,500 160 161 1,500 1,500 552.302 Smail Tools and Equipment 0 500 500 0 450 500 500 554.300 Books, Publ, Subs & Membership 474 600 600 340 600 600 600 Operating Expenditures/Expense 5,268 7,800 15,245 11,996 15,323 20,300 22,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 Acct Class: 600 Capital Outlay 664.601 Computer Equipment 1,521 0 1,285 1,320 1,320 Capital0utlay 1,521 0 1,285 1,320 1,320 0 0 0 Human Resources 190,243 220,600 237,930 199,023 236,409 246,900 276,600 0 Dept: 120 Village Clerk � Acct Class: 510 Personal Services e 512.100 Regular Salaries & Wages 118,608 125,100 124,100 104,599 118,750 129,300 127,600 514.100 Overtime 235 2,200 2,200 0 2,200 2,200 1,100 515.103 Bonus Pay Plan 0 750 750 750 750 1,100 1,100 515.107 PaR-time Salaries 0 26,500 26,500 21,691 26,500 26,000 27,600 515.108 Auto Allowance 0 0 0 2,750 3,000 3,000 3,000 516.100 Compensated Absences 0 0 0 339 340 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 7,511 9,900 9,900 8,009 9,300 10,000 9,700 521.102 Medicare Taxes 1,757 2,400 2,400 1,873 2,200 2,400 2,300 522.102 VOT Pension Contributions 9,999 9,400 9,400 7,818 8,875 10,700 13,700 523.101 Life/Health Insurance 17,387 19,300 19,300 15,100 16,800 15,200 21,100 BUDGET WORKSHEET FY2017 DRAFT at 081t 9/16 Page: 9 8129/2016 �Ilage of Tequesta 11:19 am Prior ----------------- Current Year ----------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:9/3012016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCiI Fund: 001- General Fund Expenditures Dept: 120 �Ilage Clerk Acct Class: 510 Personat Services 523.105 HSA - Health Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 194 200 200 199 200 250 250 526.103 Educa6on Reimbursement Prgm 0 0 0 2,036 2,036 3,000 3,000 554.301 Personnel Training 2,100 1,950 3,650 2,190 3,650 1,400 1,400 Personal Services 157,791 197,700 198,400 167,354 194,601 204,550 211,850 0 Acct Class: 530 Operafing ExpenditureslExpense 531.303 Codificafion Services 8,106 10,700 10,700 3,171 4,999 5,800 5,800 531.304 Recording Secy Service 8,859 0 0 0 0 534.301 Election Expense 988 18,600 1,600 1,368 1,368 18,050 18,050 534.302 LegalAdvertising 9,800 14,800 14,800 4,196 10,000 13,800 13,800 534.311 Election exp. - annexations 0 0 0 0 0 540.300 Travel & Per Diem 4,063 3,450 1,750 147 1,750 2,800 4,000 541.300 Communication Services 1,198 1,300 1,300 883 1,300 1,300 1,300 546.320 Computer system maint & suppli 18,931 10,750 10,750 3,939 10,750 10,750 10,750 548.110 Marketing and Public Relations 1,718 2,200 2,200 1,731 2,200 4,200 3,200 549.100 Miscelianeous Archival 683 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,025 2,300 2,300 1,752 2,300 2,250 2,250 552.302 Small Tools and Equipment 124 500 500 482 500 500 500 552.306 PAicrofilm Service/Supplies 11 0 0 0 0 554.300 Books, Publ, Subs & Membership 1,001 1,160 1,160 964 1,160 900 900 Operating ExpenditureslExpense 56,507 68,260 49,560 18,633 37,327 62,850 63,050 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Finanang Sources & Uses 0 0 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.601 Computer Equipment 1,600 0 0 0 0 Capital0utlay 1,600 0 0 0 0 0 0 0 Village Clerk 215,898 265,960 247,960 185,987 231,928 267,400 274,900 0 Dept: 130 Finance Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 248,180 255,400 254,800 225,611 254,800 265,600 225,400 514.100 Overtime 0 0 0 0 0 515.103 Bonus Pay Pian 0 2,250 2,250 2,250 2,250 1,750 1,400 515.120 Cell phone allowance 350 600 600 550 600 600 600 516.100 Compensated Absences 2,536 3,600 1,900 0 1,885 3,800 31,500 516.105 Compensat� Absences - HSA 0 0 0 0 0 BUDGET WORKSHEET FY2017 DRAFT at 08/19116 Page: 10 8/29I2016 �Ilage of Tequesta 11:19 am Prior ----------------- Current Year ---- - (6) (7) (8) Year Original Amended Actual Thru Es6mated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 130 Finance Acct Class: 510 Personal Services 521.101 FICA Taxes 14,873 15,400 15,400 13,196 15,100 15,900 15,700 521.102 Medicare Taxes 3,536 3,700 3,700 3,201 3,650 3,900 3,700 522.102 VOT Pension Contributions 20,922 19,100 19,100 16,876 19,100 21,900 21,900 523.101 Life/Health Insurance 43,467 49,000 49,000 44,852 48,950 49,100 46,500 523.105 HSA - Health Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 392 450 450 447 447 450 450 525.100 Unemployment Compensation 0 0 0 0 0 554.301 Personnel Training 1,433 4,400 2,537 2,537 2,537 4,400 4,400 Personal Services 335,689 353,900 349,737 309,520 349,319 367,400 351,550 0 Acct Class: 530 Operating ExpenditureslE�ense 532.300 Accounting &Auditing Services 24,605 25,100 26,173 26,173 26,173 25,600 25,600 540.300 Travel & Per Diem 989 1,000 1,000 1,184 1,184 1,500 1,500 546.301 Office Equip/Repair & Maint 425 900 900 511 900 900 900 546.320 Computer system maint & suppli 7,396 13,100 20,100 10,799 20,100 9,�0 13,000 547.300 Printing & Binding 1,466 3,000 2,490 1,851 2,000 3,000 3,000 549.300 Other Misc Chgs & Obligations 0 1,000 100 7 100 1,000 1,000 551.300 Office Supplies & Equipment 2,938 4,000 2,000 974 2,000 4,000 4,000 552.302 Smali Tools and Equipment 0 500 0 0 0 500 500 554.300 Books, Publ, Subs & Membership 1,386 1,600 1,600 991 1,600 1,600 1,600 Operating Expenditures/Expense 39,205 50,200 54,363 42,490 54,057 48,000 51,100 0 Acct Ciass: 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 Capital0utlay 0 0 0 0 0 0 0 0 Finance 374,894 404,100 404,100 352,010 403,376 415,400 402,650 0 Dept: 140 Legal Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 65,424 90,000 90,000 59,352 75,000 90,000 90,000 531.308 Legal fees - Personnel 60,118 60,000 60,000 71,331 105,000 60,000 60,000 Operating Expenditures/Expense 125,542 150,000 150,000 130,683 180,000 150,000 150,000 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 Legal 125,542 150,000 150,000 130,683 180,000 150,000 150,000 0 Dept: 150 Comprehensive Planning Acct Class: 510 Personal Services BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 11 8/29/2016 Village of Tequesta 11:19 am Prior ---------------------- Current Year --------------------- � ��) �$) Year Original Amended Actual Thru EsGmated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 150 Comprehensive Planning Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 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 Confibutions 0 0 0 0 0 523.101 LifetHealth 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 LegalServices 26,268 22,000 22,000 17,539 25,000 22,000 20,000 531.321 Mapping Services 2,117 2,500 2,500 1,062 2,500 2,500 2,500 531.322 Misc Planning Service 135,129 143,550 143,550 103,878 143,550 143,550 143,550 531.326 Comp Plan Service 0 0 0 0 0 531.331 Board of Adjustment 0 0 0 0 0 531.332 Planning and Zoning Board 667 1,000 1,000 0 1,000 1,000 1,000 531.405 Legal-Annexation 0 0 0 0 0 534.300 Other Contractual Services 6,536 5,000 5,000 2,675 5,000 5,000 3,000 534.302 Legal AdveRising 3,302 7,500 7,500 3,462 4,100 7,500 5,000 534.420 Legal Advertising - Annexation 0 0 0 0 0 546.320 Computer system maint & suppli 3,766 3,800 3,800 3,000 3,800 3,800 3,800 547.300 Printing & Binding 132 500 500 335 333 500 500 549.150 Miscellaneous annexation exp 0 0 0 0 0 549.300 Other Misc Chgs & Obligations 228 500 500 0 500 500 500 551.300 Office Supplies & Equipment 619 750 750 375 700 750 750 554.300 Books, Publ, Subs & Membership 900 900 900 900 900 900 900 Operating Expenditures/Expense 179,664 188,000 188,000 133,226 187,383 188,000 181,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 664.601 Computer Equipment 0 0 0 0 0 Capital0utlay 0 0 0 0 0 0 0 0 Comprehensive Planning 179,664 188,000 188,000 133,226 187,383 188,000 181,500 0 Dept: 160 General Govemment Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 70,787 72,900 72,900 64,703 73,050 75,900 75,900 BUDGET WORKSHEET FY2017 DRAFT at 08/19116 Page: 12 8/2912016 Village of Tequesta 11:19 am Prior --------------- Curzent Year ----------------------- � ��) � Year Original Amended Actual Thru Es6mated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 160 General Govemment Acct Class: 510 Personal Services 515.103 Bonus Pay Plan 0 600 600 600 600 600 600 515.107 Part-timeSalaries 0 0 0 17,820 21,300 26,300 26,000 516.100 Compensated Absences 0 4,100 4,100 0 1,300 3,000 3,000 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 4,150 4,700 4,700 4,857 5,700 6,400 6,400 521.102 Medicare Taxes 971 1,100 1,100 1,136 1,40o 1,500 1,500 522.102 VOT Pension Contributions 5,967 5,500 5,500 4,840 5,500 6,300 8,100 523.101 Life/Health Insurance 13,105 15,200 15,200 13,869 15,150 15,200 16,100 523.105 HSA - Health Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 123 150 150 119 119 200 5,200 526.101 Employee Recognition Program 903 0 0 3 0 526.102 Employee Assistance Program 978 11,950 4,250 3,758 4,200 526.103 Education Reimbursement Prgm 0 3,000 3,000 0 0 3,000 3,000 554.301 Personnel Training 590 2,000 2,000 750 0 2,000 1,000 Personal Services 97,574 121,200 113,500 112,455 128,319 140,400 146,800 0 Acct Class: 530 Operating ExpenditureslExpense 531.306 IT - Other Contractual Service 11,713 32,000 32,000 0 0 534.300 OtherContractualServices 24,210 20,300 20,300 21,536 24,200 20,500 20,500 534.303 Special Events 308 10,000 10,000 3,682 10,000 10,000 10,000 540.300 Travel 8 Per Diem 0 2,000 2,000 69 70 2,000 2,000 541.300 Communication Services 16,552 15,000 15,000 9,437 10,700 16,100 10,600 541.301 Postage 4,231 4,300 4,300 2,647 4,300 4,300 4,300 541.305 Website Maintenance 6,547 6,500 6,500 6,357 6,357 6,600 6,600 543.300 Udlity Services 16,145 17,000 17,000 13,338 18,600 18,400 17,500 544.301 Operating Leases 4,844 5,300 5,300 4,807 5,245 5,300 48,150 545.3001nsurance 56,123 68,000 69,955 69,997 69,997 75,650 79,900 546.301 Office Equip/Repair & Maint 1,894 3,000 3,000 1,514 2,000 3,000 3,000 546.302 Vehicle Repair & Maintenance 70 500 500 0 500 300 300 546.303 Building Repair & Maint 0 0 0 120 120 546.310 Equipment Repair& Maint 42 1,000 1,000 0 1,000 546.320 Computer system maint & suppli 12,153 32,500 32,500 28,493 32,500 32,500 32,750 547.300 Printing 8 Binding 6,155 2,000 2,000 32 2,000 2,000 2,000 549.300 Olher Misc Chgs & Obligations 9,274 10,000 8,045 7,251 8,000 10,000 10,000 549.302 Village Newsletter 17,494 21,000 21,000 9,433 9,433 21,000 19,000 549.304 Licenses, Fees & Permits 2,239 2,700 2,700 2,076 2,700 2,700 2,700 551.300 Office Supplies & Equipment 4,310 4,000 4,000 3,399 4,000 4,000 4,000 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 13 8/29/2016 Village of Tequesta 11:19 am Prior --------------- Current Year ------------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:9/30(2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 160 General Govemment Acct Class: 530 Operating Expenditures/Expense 552.160 IT Operating Supplies 732 800 800 1,030 1,030 1,200 1,200 552.301 Gas & Oil 117 500 500 141 300 300 300 552.302 SmailToolsandEquipment 1,180 1,000 1,000 2,985 2,986 1,000 1,000 554.300 Books, Publ, Subs & Membership 2,143 2,500 2,500 2,456 2,500 2,800 2,800 Operating Expenditures/Expense 198,476 261,900 261,900 190,800 218,538 239,650 278,600 0 Acct Class: 590 Other Financing Sources R 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 Capitai Outlay 662.600 Buildings 3,998 0 0 0 0 664.600 Mach/Equipment 2,670 0 0 0 0 664.601 Computer Equipment 6,302 0 0 0 0 49,850 664.602 Vehicles 0 0 0 0 0 664.607 Equipment - Tech 0 0 0 0 0 9,000 Capital0utlay 12,970 0 0 0 0 0 58,850 0 Generai Govemment 309,020 383,100 375,400 303,255 346,857 380,050 484,250 0 Dept: 175 Police Department Acct Ciass: 510 Personal Services 512.171 Sal & Wages - Adminstration 126,314 133,300 133,300 142,269 167,800 139,100 226,600 512.172 Reg SaI & Wages - Communiratio 249,303 256,000 256,000 209,452 240,100 307,100 199,600 512.175 Reg Sal & Wages - Operations 1,041,485 1,091,300 1,091,300 915,205 1,025,400 1,139,700 1,146,300 514.172 Ovefime-Communications 14,020 21,400 21,400 25,911 32,600 23,100 23,000 514.175 Ove�ime-Operations 107,829 93,170 93,170 106,196 132,968 133,600 39,400 515.101 Holiday Pay 43,989 45,000 45,000 40,266 45,000 45,000 45,000 515.103 Bonus Pay Plan 9,250 10,250 10,250 10,000 10,000 11,000 9,000 515.106 Clothing & Boot Allowance 12,200 13,250 13,250 12,073 12,074 12,700 12,300 515.107 Part-time Salaries 0 0 0 0 0 515.108 Auto Allowance 6,000 6,000 6,000 7,500 8,500 6,000 12,000 515.120 Ceiiphoneallowance 1,200 1,200 1,200 1,500 1,700 1,200 2,400 515.125 Other Ailowances 8,400 8,400 8,400 15,700 16,400 8,400 8,400 515.172 PtT Salary - Communications 48,598 36,800 36,800 33,414 43,302 8,900 32,000 515.175 PIT Salary - Operations 42,300 93,500 93,500 87,602 105,700 122,900 56,200 516.100 Compensated Absences 10,615 15,500 15,500 10,376 10,400 15,500 8,000 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 103,051 108,700 108,700 96,075 108,700 117,000 108,300 521.102 Medicare Taxes 24,477 25,900 25,900 22,829 25,900 27,900 25,900 522.101 FRS Contributions 43,673 46,100 46,100 42,104 48,000 49,900 43,700 BUDGET WORKSHEET FY2017 DRAFT at 08119116 Page: 14 8/29/2016 Viilage of Tequesta 11:19 am Prior ----------------- Current Year ----------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 175 Police Department Acct Class: 510 Personal Services 522.102 VOT Pension Contributions 96,373 66,200 66,200 48,277 56,200 52,400 61,600 522.105 Defined Confibution 39,319 47,100 47,100 41,940 48,000 58,500 66,100 522.110 Other Pension Contribu6ons 0 0 0 0 0 523.101 Life/Health Insurance 221,326 252,200 252,200 237,770 259,100 327,300 322,100 523.105 HSA-HealthSavingsAccount 3,480 4,200 4,200 1,040 1,120 850 1,100 524.100 Workers' Comp Insurance 34,164 32,350 32,350 32,305 32,305 33,000 38,250 525.100 Unemployment CompensaGon 825 0 0 0 0 526.101 Employee Recognition Program 1,347 3,000 3,000 2,204 3,000 3,000 3,000 526.103 Education Reimbursement Prgm 0 4,000 4,000 4,000 7,000 4,000 4,000 526.105 Employee Physical/Psycological 435 3,400 3,400 1,363 2,000 4,250 4,250 554.301 Personnel Training 7,626 11,000 11,000 11,350 11,350 11,000 12,000 Personal Services 2,297,599 2,429,220 2,429,220 2,158,721 2,454,619 2,663,300 2,510,500 0 Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 0 0 0 0 0 531.320 Code Enforcement Service 0 0 0 0 0 531.327 Other Contractual -MTMS 55,365 0 0 0 0 534.300 Other Contractual Services 2,538 0 0 0 0 540.300 Travel & Per Diem 7,902 12,000 12,000 5,076 12,000 12,000 9,000 541.300 Communication Services 25,590 30,500 30,500 18,126 23,000 30,500 23,000 541.301 Postage 928 2,000 2,000 623 2,000 2,000 2,000 543.300 Utility Services 26,423 25,000 25,000 20,911 25,000 25,000 25,000 544.301 Operaqng Leases 1,996 2,000 2,000 1,666 2,000 2,000 2,000 545.3001nsurance 55,528 59,800 60,723 60,709 60,723 68,450 53,650 546.175 K-9 Equipment 8 Maintenance 4,881 6,000 6,000 5,286 6,000 6,000 6,000 546.301 Office Equip/Repair8 Maint 296 1,000 1,000 2,332 2,332 1,000 1,000 546.302 Vehicie Repair 8� Maintenance 32,654 20,650 20,650 15,476 20,650 20,650 18,000 546.303 Building Repair 8 Maint 14,488 35,000 34,077 39,808 39,809 35,000 35,000 546.304 Communica6on Equip Maint 12,790 32,850 32,850 29,283 32,850 30,600 30,600 546.310 Equipment Repair & Maint 3,633 2,500 2,500 3,580 3,581 2,500 2,500 546.320 Computer system maint 8 suppli 78,201 103,600 102,558 87,944 102,558 98,000 98,000 547.300 Printing & Binding 1,617 4,000 4,000 819 4,000 4,000 4,000 549.300 Other Misc Chgs & Obligations 3,294 5,000 5,000 5,078 5,079 5,000 5,000 549.303 Investigative Expenses 1,067 2,000 2,000 930 2,000 2,000 2,000 549.304 Licenses, Fees & Permits 1,929 2,500 2,500 1,966 2,500 2,500 2,500 549.311 MarineUnitOperatlons 1,363 1,750 1,750 3,303 3,303 1,750 1,750 549.314 K.E.Y.S. Program 0 0 0 0 0 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 15 8/29/2016 Village of Tequesta 11:19 am Prior --------------------- Current Year -------------------- (6) (�) (8) Year Original Ame�ded Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 175 Police Department Acct Class: 530 Operating Expenditures/Expense 549.401 Recruitmentexpenses 0 0 0 1,786 1,786 551.300 Office Supplies & Equipment 4,737 5,000 5,000 3,574 5,000 5,000 5,000 551.301 Crime Prevention Supplies 1,364 2,500 2,500 3,435 3,436 2,500 2,500 552.301 Gas & Oil 37,497 45,000 45,000 23,186 30,000 45,000 25,000 552.302 Small Tools and Equipment 22,765 16,000 16,000 13,236 16,000 16,000 16,000 552.305 Uniforms 17,155 18,000 18,000 13,583 18,000 18,000 18,000 554.300 Books, Publ, Subs 8 Membership 1,967 3,700 3,700 2,515 3,700 3,700 3,700 Operating Expenditures/Expense 417,968 438,350 437,308 364,231 427,307 439,150 391,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 663.710 Police Department Capitai Proj 0 0 0 0 0 664.600 Mach/Equipment 6,321 0 1,042 1,042 1,042 664.601 Computer Equipment 0 0 0 0 0 664.602 Vehicles 244,778 0 0 931 931 664.607 Equipment - Tech 0 0 0 0 0 42,500 664.620 Intangible - Software 0 0 0 0 0 Capital0utlay 251,099 0 1,042 1,973 1,973 0 42,500 0 Police Department 2,966,666 2,867,570 2,867,570 2,524,925 2,883,899 3,102,450 2,944,200 0 Dept: 180 Building & Zoning Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 216,708 245,800 297,618 259,869 296,050 327,000 327,600 515.103 Bonus Pay Plan 0 500 500 500 500 500 500 515.106 Clothing 8 Boot Allowance 100 100 100 0 200 200 200 515.107 Part-timeSalaries 56,879 58,000 6,182 6,108 6,109 516.100 Compensated Absences 0 0 0 73 73 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 16,851 18,900 18,900 16,170 18,400 19,900 20,000 521.102 Medicare Taxes 3,941 4,400 4,400 3,782 4,300 4,700 4,700 522.102 VOT Pension Contributions 18,269 18,400 18,400 19,438 22,150 27,000 35,000 523.101 Life/Health Insurance 20,827 23,300 23,300 31,874 35,350 41,600 45,800 523.105 HSA - Health Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 3,386 3,100 3,100 3,051 3,051 3,500 3,800 525.100 Unemployment Compensation 309 0 0 0 0 554.301 Personnel Training 1,519 2,400 2,400 1,444 1,444 2,400 2,400 PersonalServices 338,789 374,900 374,900 342,309 387,627 426,800 440,000 0 BUDGET WORKSHEET FY2017 DRAFT at 08/19116 Page: 16 8/29/2016 Village of Tequesta 11:19 am Prior ----------------- Current Year ---______-------- �g) ��) �g) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 180 Building & Zoning Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 30,341 20,000 20,000 34,480 42,600 22,000 22,000 531.320 Code Enforcement Service 5,554 4,000 4,000 5,640 6,500 4,200 7,200 531.325 Inspection Services 0 0 0 0 0 531.328 Legal Services - Code Enf. 0 0 0 0 0 534.300 OtherGontractualServices 1,350 5,250 5,250 0 2,000 1,500 1,500 540.300 Travel & Per Diem 1,420 3,000 3,000 2,885 2,886 1,950 1,950 541.300 Communica6on Services 5,528 6,000 6,000 5,724 7,000 5,500 7,500 541.301 Postage 2,425 1,600 1,600 1,640 2,400 2,400 2,400 543.300 Utility Services 6,003 6,000 6,000 4,740 6,000 6,000 6,200 544.301 Operating Leases 1,843 1,850 1,850 1,689 1,850 1,850 1,850 545.300 Insurance 0 1,100 1,100 1,076 1,076 1,200 1,400 546.301 Office Equip/Repair& Maint 1,295 1,000 1,000 955 1,300 1,150 1,150 546.302 Vehicle Repair& Maintenance 5,463 2,250 2,100 2,230 2,231 1,000 1,000 546.303 Building Repair & Maint 0 0 0 0 0 546.320 Computer system maint & suppli 14,467 18,750 18,750 17,637 18,750 16,000 18,500 547.300 Printing & Binding 141 300 300 184 200 150 150 549.300 Other Misc Chgs & Obligations 1,103 800 800 669 800 800 800 549.304 Licenses, Fees & Permits 1,332 1,700 1,700 996 997 1,400 1,400 551.300 Office Supplies & Equipment 4,909 2,800 2,800 2,879 2,880 2,200 2,200 552.301 Gas & Oil 834 1,000 1,000 819 1,000 1,100 1,100 554.300 Books, Publ, Subs & Membership 1,438 1,000 1,150 1,182 1,200 1,450 1,450 Operating Expenditures/Expense 85,446 78,400 78,400 85,425 101,670 71,850 79,750 0 Acct Class: 590 Other Financing Sources 8 Uses 549.395 Credit Card Fees and Charges 454 500 500 5,970 6,000 5,000 6,000 Other Financing Sources & Uses 454 500 500 5,970 6,000 5,000 6,000 0 Acct Class: 600 Capital Outlay 664.600 Mach/Equipment 0 0 0 0 0 664.601 ComputerEquipment 0 0 0 0 0 41,700 664.602 Vehicles 0 0 0 0 0 32,000 32,000 664.620 Intangibie - Software 0 0 0 0 0 CapitalOuUay 0 0 0 0 0 32,000 73,700 0 Building & Zoning 424,689 453,800 453,800 433,704 495,297 535,650 599,450 0 Dept: 192 Fire Control Acct Class: 510 Personai Services 512.100 RegularSalaries&Wages 1,451,390 1,492,800 1,492,800 1,330,476 1,506,700 1,582,300 1,559,800 514.100 Overtime 68,307 67,500 67,500 55,650 63,000 65,100 65,100 514.300 Overtime - Training 20,659 19,500 19,500 18,404 19,500 36,950 19,500 BUDGET WORKSHEET FY2017 DRAFT at 08I19/16 Page: 17 8/29/2016 Village of Tequesta 11:19 am Prior ---------- Current Year -------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 192 Fire Control Acct Class: 510 Personal Services 515.101 Holiday Pay 50,448 50,700 50,700 46,388 55,200 53,000 49,400 515.103 Bonus Pay Plan 0 4,450 4,450 4,988 4,988 5,500 5,500 515.107 Part-tlme Salaries 36,376 39,800 39,800 36,656 39,400 67,500 59,000 515.108 Auto Allowance 0 0 0 0 0 3,600 4,800 515.110 Intem Fire Fighter Pay 59,120 62,800 61,877 52,066 59,500 64,600 63,300 515.120 Cell phone allowance 1,200 1,200 1,200 1,100 1,200 1,200 1,200 515.125 OtherAllowances 3,600 3,300 3,300 3,700 4,200 516.100 Compensated Absences 6,565 22,000 22,000 33,780 33,800 5,000 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 102,484 107,200 107,200 95,632 110,000 113,100 109,200 521.102 MedicareTaxes 23,968 25,100 25,100 22,366 26,000 26,700 26,000 522.102 VOTPensionContributions 339,528 203,600 63,710 63,185 63,600 185,000 212,200 522.110 Other Pension Contribufions 189,010 122,500 122,500 0 155,000 155,000 155,000 523.101 Life/Health Insurance 201,282 273,000 273,000 254,822 279,300 301,500 312,100 523.105 HSA - Health Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 51,556 45,800 45,800 45,771 45,771 46,000 54,650 525.100 Unemployment Gompensation 0 0 0 0 0 526.101 Employee Recogni6on Program 2,762 2,950 2,950 2,147 2,500 3,000 3,000 526.103 Education Reimbursement Prgm 11,899 24,900 24,900 13,733 24,900 25,800 15,000 526.104 ICMA-Def Comp Plan 4,905 3,800 3,800 5,603 7,200 14,700 526.105 Employee Physical/Psycological 11,099 9,900 9,900 9,682 9,800 10,000 10,000 554.301 Personnei Training 6,828 9,200 9,200 4,793 8,900 9,700 9,700 Personal Services 2,642,986 2,592,000 2,451,187 2,100,942 2,520,459 2,755,550 2,754,150 0 Acct Class: 530 Operating ExpenditureslExpense 531.318 Volunteer Fire Fighter Program 0 0 0 0 0 534.300 Other Contractual Services 7,505 0 0 0 0 10,000 540.300 Travel & Per Diem 4,426 5,300 5,300 995 3,850 5,300 5,300 541.300 Communication Services 14,597 13,750 13,750 9,833 12,000 14,800 11,500 541.301 Postage 1,208 1,500 1,500 1,017 1,350 1,500 1,500 543.300 UtilityServices 30,325 33,500 33,500 23,238 31,500 33,000 33,400 544.301 Operating Leases 5,538 5,900 5,900 3,309 4,500 4,600 4,600 545.300 Insurance 22,381 20,800 21,723 21,714 21,723 22,500 19,400 546.302 Vehicle Repair & Maintenance 73,810 3,700 22,473 34,663 34,663 3,700 1,500 546.303 Building Repair & Maint 22,083 43,300 42,300 42,055 42,300 39,700 30,000 546.310 Equipment Repair & Maint 22,038 24,800 24,800 17,210 24,800 25,200 25,200 546.320 Computer system maint & suppli 18,674 36,350 35,308 32,573 36,350 32,500 47,500 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 18 8/29/2016 Ullage of Tequesta 11:19 am Prior --------------------- Current Year -__�_------ �g) �7) �g) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 192 Fire Controi Acct Class: 530 Operating Expenditures/Expense 547.300 Printing&Binding 1,127 1,450 1,450 1,629 1,630 1,450 1,450 549.300 Other Misc Chgs & Obligations 3,682 3,850 3,850 4,691 4,692 4,000 4,000 549.304 Licenses, Fees & Permits 17,502 19,000 19,000 17,074 18,500 19,000 19,000 549.311 Marine Unit Operations 1,536 3,700 3,700 3,505 3,505 3,700 3,700 549.397 Bad Debt Expense 62,994 0 0 830 830 551.300 Office Suppiies & Equipment 2,640 2,700 2,700 3,442 3,443 3,000 3,000 551.302 Fire Prevention Education 2,221 2,350 2,350 890 2,3� 2,350 2,350 552.301 Gas & Oil 14,757 19,200 19,200 9,335 14,500 16,800 10,000 552.302 Smail Tools and Equipment 2,669 3,250 3,250 2,645 2,850 3,200 3,200 552.304 Chemicals 950 1,000 1,000 1,000 1,000 1,000 1,000 552.305 Uniforms 18,532 23,350 23,350 22,816 22,817 23,400 23,400 552.308 SafetySupplies 11,525 19,700 18,626 14,412 18,500 19,700 19,700 552.310 Disaster Relief Supplies 1,367 5,300 5,300 50 4,500 5,300 4,000 552.311 CPR Program Supplies 540 550 550 344 500 550 550 552.312 Medical Supplies 31,127 36,000 36,000 35,089 43,500 45,000 45,000 552.344 Fire Sta6on Supplies 1,677 3,000 3,000 1,681 2,450 2,900 2,900 554.300 Books, Pubi, Subs � Membership 3,258 3,400 3,400 2,884 3,400 3,500 3,500 Operating Expenditures/Expense 400,689 336,700 353,280 308,924 361,953 347,650 326,650 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.600 Mach/Equipment 6,321 133,300 177,594 177,130 177,594 36,100 36,100 664.601 Computer Equipment 0 0 0 0 0 664.602 Vehicles 0 0 0 0 0 30,000 664.607 Equipment - Tech 0 0 0 0 0 42,500 664.620 Intangible - Software 0 0 0 0 0 Capital0utlay 6,321 133,300 177,594 177,130 177,594 66,100 78,600 0 Fire Controi 3,049,996 3,062,000 2,982,061 2,586,996 3,060,006 3,169,300 3,159,400 0 Dept: 210 Public Works Acct Class: 510 Personai Services 512.100 Regular Salaries & Wages 185,058 298,900 291,020 252,880 289,800 320,400 341,500 514.100 Overtime 1,605 1,500 1,500 1,207 1,500 1,600 1,600 515.103 Bonus Pay Plan 0 0 0 0 0 200 200 515.106 Clothing & Boot Ailowance 450 750 750 500 700 750 750 515.107 Part-time Salaries 0 0 0 0 0 515.108 Auto Allowance 240 1,450 1,450 1,320 1,440 1,450 1,450 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 19 8/29/2016 Village of Tequesta 11:19 am Prior --------------___--- Current Year ----------___-------- � ��) �$) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - �enerai Fund Expenditures Dept: 210 Public Works Acct Class: 510 Personal Services 515.120 Cell phone allowance 80 0 480 440 480 500 500 516.100 CompensatedAbsences 2,694 0 0 1,116 1,116 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICATaxes 11,545 17,700 17,700 15,265 17,400 19,600 21,200 521.102 MedicareTaxes 2,700 4,200 4,200 3,570 4,100 4,600 5,000 522.101 FRS Contributions 0 0 0 0 0 522.102 VOT Pension Contribu6ons 15,606 22,400 22,400 18,913 21,700 26,400 36,500 523.101 Life/Healthlnsurance 46,600 94,600 62,750 56,524 62,400 66,000 71,400 523.105 HSA - Heaith Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 13,158 14,350 14,350 14,306 14,306 17,000 20,000 Personal Services 279,736 455,850 416,600 366,041 414,942 458,500 500,100 0 Acct Glass: 530 Operating Expenditures/Expense 531.302 Engineering Services 2,780 2,000 15,512 14,787 15,512 14,000 14,000 534.300 OtherContractualServices 7,444 1,000 1,395 1,395 1,395 2,000 2,000 540.300 Travel & Per Diem 0 100 100 0 100 100 100 541.300 Communication Services 5,013 4,700 8,000 6,323 7,300 4,700 8,000 543.300 Utility Services 103,169 110,000 110,000 79,690 110,000 110,000 105,000 543.301 Street Lights 136,543 137,000 137,000 113,894 137,000 137,000 137,000 544.301 Operating Leases 844 1,200 1,200 0 0 1,200 1,200 544.304 FEC Lease 14,648 15,300 15,300 15,296 15,300 15,300 15,300 545.300 Insurance 11,614 13,800 13,800 13,793 13,800 16,100 14,650 546.200 R&M - Station 11 341 2,500 500 0 500 8,500 8,500 546.301 Office Equip/Repair & Maint 68 200 200 22 200 450 450 546.302 Vehicle Repair & Maintenance 4,787 6,300 6,300 5,174 6,300 6,500 6,500 546.303 Building Repair & Maint 10,951 12,000 23,000 20,224 23,000 44,500 44,500 546.305 Pathway Maintenance 7,422 22,400 14,827 11,613 14,827 150,000 30,000 546.306 General Maintenance 27,065 30,000 25,000 25,330 25,331 30,000 30,000 546.309 Landscape & Irrigation Maint 129,098 137,000 150,590 117,120 142,000 151,000 151,000 546.310 Equipment Repair & Maint 4,386 11,000 5,000 4,766 5,000 11,000 7,000 546.320 Computer system maint & suppli 317 3,800 3,800 2,690 3,800 2,100 2,100 546.350 R& M- Roads 83,225 62,300 47,988 34,161 47,988 65,000 65,000 549.300 Other Misc Chgs & Obligations 3,100 3,500 3,500 3,532 3,533 3,500 3,500 549.304 Licenses,Fees&Permits 1,616 1,500 1,500 1,362 1,500 1,500 1,500 551.300 Office Supplies & Equipment 336 450 650 473 650 650 650 551.400 JanitorialSupplies 5,082 6,000 6,000 5,955 6,000 6,000 6,000 552.301 Gas & Oil 5,509 6,000 6,000 3,089 4,000 6,000 5,000 BUDGET WORKSHEET FY2017 DRAFT at 08/19116 Page: 20 8/29/2016 Viilage of Tequesta 11:19 am Prior ----------------- Current Year ---------------- (6) (7) (8) Year Original Amended Acival Thru Estimated Month:9/3012016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 210 Public Works Acct Class: 530 Operating Expenditures/Expense 552.302 Small Tools and Equipment 4,605 3,000 8,800 8,452 8,800 3,400 3,400 552.305 Uniforms 1,744 2,000 3,000 2,854 3,000 2,600 2,600 553.301 Road Signs 4,983 10,000 10,000 11,162 11,163 10,000 10,000 563.600 Public Works Misc Projects 75,415 20,330 7,435 6,886 7,435 20,500 17,650 Operating Expenditures/Expense 652,105 625,380 626,397 510,043 615,434 823,600 692,600 0 Acct Ciass: 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 OuNay 663.650 Pathways 4,708 20,000 20,000 17,826 20,000 664.600 Mach/Equipment 17,252 30,000 30,000 18,123 30,000 45,000 45,000 664.602 Vehicles 53,955 0 0 0 0 34,000 664.607 Equipment-Tech 0 0 0 0 0 Capital0utlay 75,915 50,000 50,000 35,949 50,000 45,000 79,000 0 Public Works 1,007,756 1,131,230 1,092,997 912,033 1,080,376 1,327,100 1,271,700 0 Dept: 230 Parks Acct Class: 530 Operating Expenditures/Expense 546.315 Facilities - Repair & Maint 0 0 0 0 0 Operating ExpenditureslExpense 0 0 0 0 0 0 0 0 Parks 0 0 0 0 0 0 0 0 Dept: 231 Leisure Services Acct Class: 510 Personal Services 512.100 Reguiar Salaries & Wages 169,845 175,000 175,000 154,629 174,650 182,000 183,300 515.103 Bonus Pay Plan 0 2,450 2,450 2,487 2,487 2,500 2,500 515.106 Clothing & Boot Allowance 100 100 100 100 100 100 100 515.107 Part-timeSaiaries 46,131 49,400 49,400 39,412 49,400 56,100 55,600 515.108 Auto Allowance 3,000 3,000 3,000 2,750 3,000 3,000 3,000 515.109 Seasonal Salaries & Wages 23,876 20,000 20,000 24,706 24,706 20,000 20,000 515.120 Cellphoneallowance 700 1,200 1,200 1,100 1,200 1,200 1,200 516.100 Compensated Absences 2,329 4,000 4,000 2,375 2,376 4,200 4,200 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 14,733 15,400 15,400 13,599 15,400 16,200 16,300 521.102 MedicareTaxes 3,446 3,600 3,600 3,180 3,600 3,800 3,800 522.102 VOTPensionContributions 14,318 13,100 13,100 11,566 13,100 15,000 19,600 523.101 Life/Health Insurance 39,370 44,700 44,700 40,962 44,700 44,800 47,900 523.105 HSA - Health Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 6,378 6,400 6,400 6,375 6,375 7,100 8,400 BUOGET WORKSHEET FY2017 DRAFT at OS/19116 Page: 21 8/29/2016 Village of Tequesta 11:19 am Prior -------------------- Current Year -------------- �6) �7) �$) Year Original Amended Actual Thru Estimated Month:9/30I2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 231 Leisure Services Acct Class: 510 Personal Services 525.100 Unemployment Compensation 0 0 0 0 0 526.105 Empioyee Physical/Psycological 965 2,500 2,500 1,008 2,500 1,500 1,500 554.301 PersonnelTraining 210 1,200 1,200 0 0 1,200 1,200 Personal Services 325,401 342,050 342,050 304,249 343,594 358,700 368,600 0 Acct Class: 530 Operating Expenditures/Expense 531.324 �rants Acquistion & Admin 2,000 0 0 0 0 2,000 2,000 534.300 Other Contractual Services 0 0 0 0 0 4,000 4,000 534.303 Special Events 46,442 51,240 51,240 50,168 50,168 51,000 51,000 540.300 Travel & Per Diem 0 1,500 1,500 0 0 1,500 1,500 541.300 Communira6on Services 6,458 5,700 5,700 9,835 12,500 5,700 14,000 541.301 Postage 161 150 150 155 155 150 150 543.300 Utility Services 10,336 14,000 12,495 9,930 11,000 14,000 14,600 545.300 Insurance 14,871 15,600 15,600 15,553 15,554 17,600 13,100 546.302 Vehicle Repair& Maintenance 1,951 4,450 4,450 3,371 3,500 1,000 1,000 546.303 Building Repair& Maint 21,685 20,000 20,000 23,862 25,000 20,000 30,000 546.306 General Maintenance 27,650 30,000 30,000 26,759 30,000 35,000 35,000 546.310 EquipmentRepair&Maint 850 1,700 1,700 1,614 1,700 1,700 1,700 546.315 Facilities - Repair & Maint 0 50,000 50,000 49,381 50,000 546.320 Computer system maint & suppli 1,701 5,150 5,150 3,541 5,150 4,100 4,100 549.201 Advertising 8 Promotion 4,910 5,000 5,000 6,185 6,185 6,000 6,000 549.300 Other Misc Chgs & Obligations 2,684 5,000 5,000 1,100 3,000 3,450 3,450 549.304 Lice�ses, Fees & Permits 2,330 2,200 2,200 1,993 2,200 2,200 2,200 549.332 Recreation Program Expense 39,002 38,300 38,300 38,400 38,401 38,000 38,000 549.333 Spring/Summer Camp 12,889 15,000 15,000 13,254 14,000 15,000 15,000 551.300 Office Supplies & Equipment 766 2,000 2,000 1,235 1,950 2,000 2,000 551.315 Concession Supplies 1,732 5,000 5,000 1,215 1,215 1,500 1,500 552.301 Gas & Oil 1,416 2,500 2,500 887 1,200 2,500 2,500 552.302 Smail Tools and Equipment 1,620 1,500 1,500 834 1,500 1,500 1,50o 552.305 Uniforms 367 500 500 834 834 500 500 554.300 Books, Publ, Subs & Membership 0 500 500 165 165 500 500 Operating Expenditures/Expense 201,821 276,990 275,485 260,271 275,377 230,900 245,300 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources 8� Uses 0 0 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 663.600 Improvements other than Bidgs 0 0 0 0 0 8,600 8,600 663.650 Pathways 0 0 0 0 0 24,000 24,000 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 22 8/29/2016 Ullage of Tequesta 11:19 am Prior -------------------- Current Year ---------------------- (6) (�) ($) Year Original Amended Actual Thru Estimated Month:9/30I2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 231 Leisure Services Acct Class: 600 Capital Outlay 664.600 MachlEquipment 0 0 0 0 0 664.601 Computer Equipment 0 0 0 0 0 664.602 Vehicles 0 30,000 31,505 0 31,505 30,000 30,000 664.607 Equipment - Tech 0 0 0 0 0 20,000 Capital0utlay 0 30,000 31,505 0 31,505 62,600 82,600 0 Leisure Services 527,222 649,040 649,040 564,520 650,476 652,200 696,500 0 Dept: 700 Debt Service Acct Class: 471 D/S - Principal 571.706 P/S Prin - BOA - P/S Bldg 269,915 281,700 281,700 257,760 281,700 294,000 294,000 571.708 P/S - Prin - SunTrust - Pumper 38,802 39,800 39,800 39,742 39,743 40,800 40,800 571.710 P/S Prin - 2015 PD Vehicles 25,914 78,600 78,600 71,886 78,600 81,000 81,000 571.712 2015 Public Works Vehicles 0 19,400 19,400 0 0 571.716 Principal -L.S. - Transport va 0 9,700 9,700 0 0 571.727 Lease Prin - SCVA Fire Equip 0 25,100 25,100 28,089 28,089 27,500 27,500 D/S - Principal 334,631 454,300 454,300 397,477 428,132 443,300 443,300 0 Acct Class: 472 D/S - Interest 572.706 P/S - Int. BOA - P.S Bldg 102,586 90,900 90,900 83,700 90,900 78,600 78,600 572.708 P/S - SunTrust - Pumper 9,333 8,400 8,400 8,393 8,393 7,500 7,500 572.710 Interest - 2015 PD Vehicles 2,053 5,400 5,400 5,023 5,400 3,000 3,000 572.712 2015 Public Works Vehicles 0 1,600 1,600 0 0 572.716 Interest - L.S. - Transport va 0 800 800 0 0 572.725 Int. 2012 Ford Focus - Admin 14 0 0 0 0 572.727 Lease Int. - SCVA - Fire Equip 0 3,750 3,750 0 2,300 2,500 2,500 D/S -Interest 113,986 110,850 110,850 97,116 106,993 91,600 91,600 0 DebtService 448,617 565,150 565,150 494,593 535,125 534,900 534,900 0 Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 591.301 Trsf to Capital Imp Fund 85,000 316,800 316,800 316,800 316,800 140,000 106,000 591.605 Tfr toSpecial Law Enf Trust 0 0 50,000 50,000 50,000 Interfund Transfers Out 85,000 316,800 366,800 366,800 366,800 140,000 106,000 0 Interfund Transfers 85,000 316,800 366,800 366,800 366,800 140,000 106,000 0 Dept: 910 Other Financing Sources & Uses Acct Ciass: 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 BUDGET WORKSHEET FY2017 DRAFT at 08i19/16 Page: 23 8/29(2016 Village of Tequesta 11:19 am Prior ------------ Current Year ------------------ (6) (7) (8) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 950 Other Nonoperating Acct Class: 590 Other Finanang Sources & Uses 549.391 Bank Charges 10,225 11,000 11,000 9,842 11,000 11,000 549.395 Credit Card Fees and Charges 1,984 2,800 2,800 347 2,800 2,800 567.000 Gain/Loss on Investments 119 0 0 0 0 590.001 Ailocate 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 - A/P 0 0 0 0 0 Other Financing Sources & Uses 12,328 13,800 13,800 10,189 13,800 0 13,800 0 Other Nonoperating 12,328 13,800 13,800 10,189 13,800 0 13,800 0 Dept: 990 OthedReserve/Contingency Acct Ciass: 590 Other Financing Sources & Uses 599.902 Reserves - Contingency 0 0 187,510 0 0 Other Financing Sources & Uses 0 0 187,510 0 0 0 0 0 OthedReserve/Con6ngency 0 0 187,510 0 0 0 0 0 TotalExpenditures 10,153,708 10,926,700 11,044,151 9,421,256 10,926,203 11,386,050 11,372,750 0 Generel Fund 383,615 0 0 859,221 61,257 -8,884,350 0 0 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 24 8/29/2016 �Ilage of Tequesta 11:19 am Prior -------------------- Current Year --------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 301 - Capital Improvement Fund Revenues Dept: 000 General Acct Class: 366 Contribu6ons & Donations 366.100 Contrib 8 Donations & Sponsors 0 0 0 0 0 Contributions 8 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 85,000 316,800 316,800 316,800 316,800 140,000 106,000 381.303 Tsfer-In from Capital Projects 0 0 0 0 0 Transfersln 85,000 316,800 316,800 316,800 316,800 140,000 106,000 0 Interfund Transfers 85,000 316,800 316,800 316,800 316,800 140,000 106,000 0 Dept: 950 Other Nonoperating Acct Ciass: 361 Unrestricted Investment Eamin 361.100 Interest(Investment Eamings 0 0 0 0 0 Unrestricted Investrnent Eamin 0 0 0 0 0 0 0 0 Other Nonoperating 0 0 0 0 0 0 0 0 Dept: 990 OtherlReserve/Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 0 8,000 0 0 Other Financing Sources 0 0 8,000 0 0 0 0 0 OthedReservelCon6ngency 0 0 8,000 0 0 0 0 0 Total Revenues 85,000 316,800 324,800 316,800 316,800 140,000 106,000 0 Expenditures Dept: 000 General Acct Class: 530 Operating E�enditures/Expense 546.305 Pathway Maintenance 0 0 0 0 0 Operating Expenditures/E�ense 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 0 0 166,800 93,466 166,800 140,000 106,000 553.301 Road Signs 0 0 0 0 0 Operating Expenditures/Expense 0 0 166,800 93,466 166,800 140,000 106,000 0 Acct Class: 600 Capital Outlay 663.652 Pathway/Sidewalk Improvements 0 50,000 50,000 50,000 50,000 663.653 Signage 0 45,000 0 0 0 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 25 8/29/2016 �Ilage of Tequesta 11:19 am Prior -------------------- Current Year - __----------------- (s) (�) ($) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 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 121,800 0 0 0 Capital0u8ay 0 216,800 50,000 50,000 50,000 0 0 0 Public Works 0 216,800 216,800 143,466 216,800 140,000 106,000 0 Dept: 371 US1 Boulevard Project Acct Class: 530 Operating Expenditures/Expense 546.657 R& M- Roadway Improvements 78,285 0 8,000 8,000 8,000 Operating Expenditures/Expense 78,285 0 8,000 8,000 8,000 0 0 0 Acct Class: 600 Capital Outlay 663.657 Roadway Improvements 0 100,000 100,000 0 100,000 Gapital0uday 0 100,000 100,000 0 100,000 0 0 0 US1 Boulevard Project 78,285 100,000 108,000 8,000 108,000 0 0 0 Dept: 399 Misc Proj-General Acct Class: 600 Capital Outlay 663.647 IT - Storage Project 0 0 0 0 0 Capital0u8ay 0 0 0 0 0 0 0 0 Misc Proj-General 0 0 0 0 0 0 0 0 Dept: 900 Interiund Transfers Acct Class: 591 Interfund Tra�sfers 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 78,285 316,800 324,800 151,466 324,800 140,000 106,000 0 Capital Improvement Fund 6,715 0 0 165,334 -8,000 0 0 0 BUDGET WORKSHEET FY2017 DR,4FT at 08/19/16 Page: 26 8129/2016 Village of Tequesta 11:19 am Prior -----_---_ Current Year ----------------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 303 - Capital Projects Fund Revenues 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 0 0 Expenditures 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 Totai Expenditures 0 0 0 0 0 0 0 0 Capital Projects Fund 0 0 0 0 0 0 0 0 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 27 8/29/2016 Village of Tequesta 11:19 am Prior --------------- Current Year ---------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 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 WaterSales 2,400,486 2,503,800 2,503,800 2,195,019 2,473,432 2,704,100 2,737,000 343.302 Water- Connect Charges 21,645 18,190 18,190 25,336 25,336 19,600 17,000 343.303 Water-Fire Hydrants Rent 67,472 72,360 72,360 65,125 67,400 72,300 67,400 343.304 WaterSurcharge 394,799 409,280 409,280 353,297 412,242 400,000 456,100 343.306 MonthlyServiceCharge 1,438,881 1,530,100 1,530,100 1,393,035 1,491,769 1,652,500 1,491,700 343.307 Penalty Charges 4,947 4,820 4,820 4,728 5,500 4,800 4,500 343.308 OtherWaterServicelncome 1,923 1,500 1,500 769 1,500 1,500 1,500 343.309 Convenience Fee - CC 0 0 0 0 0 343.700 Water Conservation & Resource 1,015 1,000 1,000 2,369 2,369 1,000 1,000 343.950 Allow for doubful rev - Enterp 0 0 0 0 0 CnargesforServices 4,331,168 4,541,050 4,541,050 4,039,678 4,479,548 4,855,800 4,776,200 0 Acct Class: 369 Miscellaneous Revenues 363.101 Martin(fropic V-Const portion 17,864 12,000 12,000 33,840 33,840 12,000 369.000 Other Miscellaneous Revenue 26 0 0 30 30 369.100 Insurance Reimbursement 2,541 0 0 3,174 3,174 Misceilaneous Revenues 20,431 12,000 12,000 37,044 37,044 0 12,000 0 Acct Class: 390 Other Financing Sources 369.110 Capital Connect Charge - Cust 44,002 19,260 19,260 47,763 47,763 21,600 25,900 369.111 Capital Connect Charge - Devel 30,934 16,050 16,050 26,326 26,326 19,400 8,600 369.112 Capital Connect - Tropic Vist 15,925 10,000 10,000 0 0 10,000 Other Financing Sources 90,861 45,310 45,310 74,089 74,089 41,000 44,500 0 General 4,442,460 4,598,360 4,598,360 4,150,811 4,590,681 4,896,800 4,832,700 0 Dept: 900 Interfund Transfers Acct Class: 391 Transfersln 381.403 Transfer from Stormwater Util 19,981 0 0 0 0 Transfers In 19,981 0 0 0 0 0 0 0 Interfund Transfers 19,981 0 0 0 0 0 0 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investment Eamin 361.100 Interest/Investment Eamings 10,000 8,500 8,500 10,623 10,623 7,800 361.105 Int Income - Tropic Vista Asse 0 0 0 0 0 367.100 Net Unreal appreciafion (Dep) 0 0 0 0 0 Unrestricted Investment Eamin 10,000 8,500 8,500 10,623 10,623 0 7,800 0 Acct Class: 369 Miscellaneous Revenues 364.100 Disposition of Assets 0 0 0 4,226 4,226 Misceilaneous Revenues 0 0 0 4,226 4,226 0 0 0 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 28 8/29/2016 Village of Tequesta 11:19 am Prior -------------------- Current Year --------------------- (6) (�) (8) Year Original Amended Actuai Thru Estimated Month:9/30/2016 Actual Budget Budget September Totai DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Revenues Other Nonoperating 10,000 8,500 8,500 14,849 14,849 0 7,800 0 Dept: 990 Other/Reserve/Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 1,786,590 2,400,207 0 0 3,034,450 Other Financing Sources 0 1,786,590 2,400,207 0 0 0 3,034,450 0 OthedReserve/Contlngency 0 1,786,590 2,400,207 0 0 0 3,034,450 0 TotaiRevenues 4,472,441 6,393,450 7,007,067 4,165,660 4,605,530 4,896,800 7,874,950 0 Expenditures Dept: 241 Water-Administration Acct Class: 510 Personal Services 512.100 Regular Salaries 8 Wages 170,618 206,200 206,200 181,746 205,300 213,800 242,000 515.103 BonusPayPlan 5,000 650 8,150 8,150 8,150 850 1,250 515.106 Clothing 8 Boot Allowance 0 50 50 0 0 515.108 Auto Allowance 3,240 4,450 4,450 4,070 4,450 4,450 4,450 515.120 Cellphoneallowance 430 600 600 990 1,100 1,100 1,100 515.125 OtherAllowances 1,200 1,200 1,200 1,100 1,200 1,200 1,200 516.100 Compensated Absences 6,184 8,400 8,400 0 2,600 8,400 35,000 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 8,812 10,600 10,600 9,674 10,600 11,400 15,300 521.102 MedicareTaxes 2,755 3,200 3,200 2,942 3,200 3,400 4,100 522.102 VOT Pension Contributions 14,390 15,500 15,500 13,595 15,400 17,600 23,700 522.150 Pension Expense -14,533 0 0 0 0 523.101 Life/Health Insurance 13,817 22,900 15,500 14,172 15,500 15,900 23,200 523.105 HSA - Health Savings Account 0 0 0 0 0 523.110 Retiree Health Care Expense 800 0 0 0 0 524.100 Workers' Comp Insurance 278 250 250 247 248 4,700 8,000 526.102 Employee Assistance Program 225 2,700 2,700 876 1,000 526.104 ICMA-Def Comp Plan 10,220 10,700 10,700 9,447 10,700 11,200 11,200 554.301 Personnel Training 0 0 0 0 0 Personal Services 223,436 287,400 287,500 247,009 279,448 294,000 370,500 0 Acct Class: 530 Operating Expenditures/Expense 531.301 LegalServices 10,304 2,000 9,000 12,635 19,000 10,000 10,000 531.302 Engineering Services 60,079 75,000 73,413 20,618 40,000 75,000 75,000 532.300 Accounting & Auditing Services 28,611 29,200 29,200 30,433 30,433 29,800 29,800 534.300 Other Contractual Services 56,637 30,000 30,000 16,500 19,500 20,000 20,000 541.300 Communication Services 3,050 3,050 3,050 2,250 2,250 4,000 4,000 544.304 FEC Lease 12,694 13,000 13,000 12,792 12,792 13,500 13,500 545.300 Insurance 46,780 45,300 46,887 46,830 46,831 49,600 44,200 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 29 8/29/2016 Village of Tequesta 11:19 am Prior ------------------- Current Year ---------------------- � ��) � Year Original Amended Actual Thru Estimated Month:9/30I2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Expenditures Dept: 241 Water-Administration Acct Class: 530 Operating Expenditures/Expense 549.301 Admin Mgmt Fees 514,780 514,800 514,800 486,017 530,200 540,850 540,850 549.304 Licenses, Fees 8 Permits 781 800 800 781 781 800 800 Operating Expenditures/Expense 733,716 713,150 720,150 628,856 701,787 743,550 738,150 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 400 0 0 Other Financing Sources & Uses 0 0 400 0 0 0 0 0 Water-Administration 957,152 1,000,550 1,008,050 875,865 981,235 1,037,550 1,108,650 0 Dept: 242 Water- Production Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 424,097 528,800 528,800 446,709 505,800 603,900 596,800 514.100 Ove�ime 7,543 10,000 10,000 16,053 15,000 10,000 10,000 515.101 Holiday Pay 4,655 5,200 5,200 4,830 5,200 5,200 5,200 515.102 Standby Pay 4,773 6,000 6,000 4,427 6,000 6,000 6,000 515.103 Bonus Pay Plan 0 500 500 0 0 500 500 515.106 Clothing & Boot Allowance 700 800 800 572 800 800 800 515.107 Part-time Salaries 0 0 0 0 0 515.108 Auto Allowance 3,500 6,000 6,000 5,500 6,000 6,000 6,000 515.120 Cell phone ailowance 700 1,200 1,200 1,100 1,200 1,200 1,200 516.100 Compensated Absences 14,837 5,000 5,000 7,227 7,227 5,000 5,000 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICATaxes 27,806 33,500 33,500 29,190 33,500 38,400 37,600 521.102 Medicare Taxes 6,503 7,900 7,900 6,827 7,900 9,000 8,800 522.101 FRS Contribufions 5,146 5,300 5,300 4,695 5,300 5,700 5,700 522.102 VOT Pension Contributions 29,908 34,300 34,300 28,756 32,700 44,200 56,600 522.150 Pension Expense -37,057 0 0 0 0 523.101 LifelHealthlnsurance 74,514 118,900 102,100 84,751 92,400 119,500 131,500 523.105 HSA - Health Savings Account 0 0 0 0 0 523.110 Retiree Heaith Care Expense 4,200 0 0 0 0 524.100 Workers' Comp Insurance 11,445 9,950 9,950 9,933 9,934 11,100 15,450 554.301 Personnel Treining 1,550 4,000 4,000 3,543 4,000 6,000 6,000 Personal Services 584,820 777,350 760,550 654,113 732,961 872,500 893,150 0 Acct Class: 530 Operating Expenditures/Expense 531.342 Water Analysis & Sampling 32,065 50,000 50,000 24,815 45,000 50,000 50,000 540.300 Travel & Per Diem 1,317 4,000 4,000 2,206 4,000 4,000 4,000 541.300 Communication Services 11,864 9,500 9,500 15,444 17,200 9,500 19,000 541.301 Postage 2,048 2,000 2,000 1,177 3,000 5,000 5,000 543.300 U61ity Services 349,848 357,000 357,000 281,265 350,000 357,000 357,000 BUDGET WORKSHEET FY2017 DRAFT at 08119l16 Page: 30 S/29/2016 Village of Tequesta 11:19 am Prior ----------------- Current Year ------------- (B) (7) (8) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Expenditures Dept: 242 Water - Productlon Acct Class: 530 Operating Expenditures/Expense 544.301 Operafing Leases 7,500 10,000 7,900 6,690 7,900 10,000 10,000 546.302 Vehicle Repair & Maintenance 7,479 8,050 8,050 5,578 10,000 10,000 10,000 546.303 Building Repair & Maint 23,169 50,000 88,570 82,292 88,570 80,000 80,000 546.309 Landscape &Irrigation Maint 10,236 10,000 23,000 23,823 23,548 25,000 25,000 546.310 Equipment Repair & Maint 60,916 75,000 75,000 30,485 75,000 100,000 100,000 546.320 Computer system maint 8 suppli 6,487 22,650 45,494 42,869 42,869 22,500 22,500 546.342 Water System Maintenance 105,865 100,000 100,000 69,478 100,000 100,000 100,000 546.343 Well Redevelopment 64,216 0 0 0 0 547.300 Printing & Binding 3,668 3,000 3,000 3,014 3,015 3,000 3,000 549.300 Other Misc Chgs & Obligations 4,736 2,000 2,000 2,809 2,756 5,000 5,000 549.304 Licenses, Fees & Permits 27,828 30,000 30,000 29,481 30,000 30,000 30,000 551.300 Office Supplies & Equipment 4,545 4,000 4,000 5,885 5,809 4,000 4,000 552.301 Gas & Oil 3,531 5,000 5,000 2,211 4,500 5,000 5,000 552.302 Small Tools and Equipment 5,130 5,000 5,000 4,685 5,000 5,000 5,000 552.303 Diesel Fuel 2,603 15,000 15,000 6,168 13,000 15,000 15,000 552.305 Unifortns 3,284 3,000 3,000 2,530 3,000 4,000 4,000 552.341 WaterPurchases 0 30,000 30,000 0 0 30,000 30,000 552.342 WaterChemicals 141,163 185,000 171,000 136,028 170,000 175,000 175,000 552.343 Laboratory Supplies 19,591 15,000 15,000 15,575 15,041 15,000 15,000 554.300 Books, Publ, Subs & Membership 1,673 1,600 1,600 1,482 1,600 1,600 1,600 Operating Expenditures/Expense 900,762 996,800 1,055,114 795,990 1,020,808 1,065,600 1,075,100 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 127,440 0 0 Other Financing Sources & Uses 0 0 127,440 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.607 Equipment - Tech 0 0 0 0 0 Capital0utlay 0 0 0 0 0 0 0 0 Water- Production 1,485,582 1,774,150 1,943,104 1,450,103 1,753,769 1,938,100 1,968,250 0 Dept: 243 Water-Distribution Acct Class: 510 Personal Services 512.100 Regular Salaries 8 Wages 380,330 394,300 394,300 346,170 391,000 407,400 404,300 514.100 Overtime 3,460 5,100 5,100 4,530 5,100 5,100 5,100 515.102 Standby Pay 11,115 10,200 10,200 8,870 10,200 10,200 10,200 515.103 Bonus Pay Plan 0 1,000 1,000 1,000 1,000 1,000 1,000 515.106 Clothing & Boot Allowance 500 500 500 500 500 500 500 515.107 Part-time Salaries 0 0 0 0 0 515.108 Auto Allowance 0 0 0 0 0 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 31 8/29I2016 Village of Tequesta 11:19 am Prior -------------_____ Current Year -------------------- (B) (7) (8) Year Original Amended Actual Thru Es6mated Month:9/30/2016 Actuai Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Expenditures Dept: 243 Water-Distribution Acct Class: 510 Personal Services 516.100 CompensatedAbsences 4,627 5,100 5,100 2,179 2,179 5,100 5,100 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 24,055 25,100 25,100 21,753 25,100 25,900 26,000 521.102 Medicare Taxes 5,626 5,900 5,900 5,087 5,900 6,100 6,100 522.101 FRS ContribuUons 10,599 10,800 10,800 9,613 10,800 11,700 11,600 522.102 VOT Pension Contributions 20,245 18,800 18,800 16,386 18,600 21,300 27,200 522.150 Pension Expense -34,560 0 0 0 0 523.101 Life/Health Insurance 75,926 83,100 78,950 71,922 78,950 79,100 85,200 523.105 HSA - Health Savings Account 0 0 0 0 0 523.110 Retiree Health Care Expense 3,800 0 0 0 0 524.100 Workers' Comp Insurance 8,352 8,200 8,200 8,152 8,152 7,000 8,100 525.100 Unemployment Compensation 0 0 0 0 0 554.301 Personnel Training 621 3,000 3,000 2,969 3,000 3,000 3,000 Personal Services 514,696 571,100 566,950 499,131 560,481 583,400 593,400 0 Acct Class: 530 Opereting E�enditures/Expense 540.300 Travel& PerDiem 292 1,000 1,000 109 1,000 1,000 1,000 541.300 Communication Services 6,269 6,000 6,000 8,908 11,500 6,000 14,000 541.301 Postage 22,360 23,000 23,000 20,286 23,000 24,000 24,000 544.301 Operating Leases 2,840 3,200 3,200 1,807 3,200 3,200 3,200 546.301 Office Equip/Repair& Maint 199 1,200 1,200 264 1,200 1,500 1,500 546.302 Vehicie Repair & Maintenance 2,396 10,400 10,400 7,521 8,000 10,000 10,000 546.303 Building Repair & Maint 1,735 6,000 6,000 585 5,500 10,000 10,000 546.309 Landscape 8lrzigation Maint 679 1,000 1,000 273 1,000 1,000 1,000 546.310 Equipment Repair & Maint 3,843 5,000 5,000 2,174 5,000 6,500 6,500 546.320 Computer system maint & suppli 7,928 12,000 12,000 10,033 12,000 10,000 10,000 546.342 WaterSystem Maintenance 34,722 40,000 40,000 33,592 45,000 45,000 45,000 547.300 Printing 8 Binding 2,498 3,000 3,000 2,195 2,500 3,000 3,000 549.300 Other Misc Chgs 8 Obligations 1,629 2,500 2,500 1,347 2,400 2,500 2,500 549.304 Licenses, Fees & Permits 1,447 1,700 1,700 1,673 1,700 1,800 1,800 551.300 Office Supplies & Equipment 2,065 1,500 1,500 1,211 1,500 1,500 1,500 552.301 Gas & Oil 9,619 14,000 14,000 5,494 8,000 12,000 12,000 552.302 Small Tools and Equipment 2,133 5,000 5,000 1,952 4,000 5,000 5,000 552.305 Uniforms 1,590 2,000 2,000 1,559 2,000 3,000 3,000 Operating Expenditures/Expense 104,244 138,500 138,500 100,983 138,500 147,000 155,000 0 Acct Ciass: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 4,150 0 0 BUDGET WORKSHEET FY2017 DRAFT at 08119/16 Page: 32 8/29/2016 Village of Tequesta 11:19 am Prior ------------------ Current Year ----------------------- � (�) ($) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Expenditures Dept: 243 Water-Distribution Other Financing Sources & Uses 0 0 4,150 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.607 Equipment-Tech 0 0 0 0 0 CapitalOuBay 0 0 0 0 0 0 0 0 Water-Distribution 618,940 709,600 709,600 600,114 698,981 730,400 748,400 0 Dept: 411 Renewal 8 Replacement Acct Class: 530 Operating Expenditures/Expense 531.302 Engineering Services 0 0 0 0 135,000 125,000 150,000 546.604 R 8 M- Pump and Motor Rehab 0 0 0 0 0 40,000 40,000 546.605 R&M - Well Rehabilitation 0 100,000 111,222 68,674 111,222 100,000 100,000 546.607 R&M - Water Mains 0 0 0 0 0 50,000 50,000 546.615 R&M - JIC - Engneering 73,142 93,300 93,300 17,162 93,300 546.617 R&M-JIC-Construction 0 1,245,000 1,740,000 0 1,740,000 549.671 Misc. Renewai & Replacement 402,534 115,000 19,013 4,013 19,013 1,297,000 1,700,000 552.601 Meters, Valves & Hydrants 69,188 60,000 60,000 47,731 60,000 200,000 200,000 552.603 Filter Cartridges/ROP 4,213 7,000 7,000 0 6,500 7,000 7,000 552.605 Spare Pumps & Motors 0 5,000 5,000 0 5,000 10,000 10,000 Operating Expenditures/Expense 549,077 1,625,300 2,035,535 137,580 2,170,035 1,829,000 2,257,000 0 Acct Class: 600 Capital Outlay 663.671 Misc. Renewel and Replacement 0 0 0 0 0 664.600 Mach/Equipment 0 0 14,248 18,184 18,184 60,000 60,000 664.601 Computer Equipment 0 10,000 22,680 14,069 14,679 80,950 664.602 Vehicles 0 0 0 0 0 30,000 30,000 Capital0utlay 0 10,000 36,928 32,253 32,863 90,000 170,950 0 Renewai & Replacement 549,077 1,635,300 2,072,463 169,833 2,202,898 1,919,000 2,427,950 0 Dept: 700 Debt Service Acd Class: 471 D/S - Prindpal 571.705 Prin - 2004 Water NIP BOA 0 33,000 33,000 33,000 33,000 35,000 35,000 571.720 Prin - 2008 Water Utility Note 0 300,400 300,400 274,829 300,400 312,900 312,900 D/S - Principai 0 333,400 333,400 307,829 333,400 347,900 347,900 0 Acct Class: 472 D/S - Interest 572.705 Int-2004 WaterN/P BOA 11,919 11,100 11,100 6,418 11,100 9,400 9,400 572.720 Int - 2008 Water Utility Note 180,742 180,800 180,800 142,626 180,800 170,300 170,300 573.700 Other Debt Service Costs 22,467 23,000 23,000 0 23,000 D/S - Interest 215,128 214,900 214,900 149,044 214,900 179,700 179,700 0 DebtService 215,128 548,300 548,300 456,873 548,300 527,600 527,600 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 BUDGET WORKSHEET FY2017 DRAFT at OS/19/16 Page: 33 8/29/2016 Village of Tequesta 11:19 am Prior ---------------- Current Year ------------------ �s) �7) �8) Year Original Amended Actual Thru Es6mated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCiI Fund: 401 - Water Fund Expenditures Dept: 910 Other Finandng Sources & Uses Acct Class: 590 Other Financing Sources & Uses 567.100 Unrealized Loss on Investments 0 0 0 0 0 Other Finandng Sources & Uses 0 0 0 0 0 0 0 0 Other Financing Sources 8 Uses 0 0 0 0 0 0 0 0 Dept: 950 Other Nonoperating Acct Class: 530 Operating Expenditures/Expense 559.300 Deprecia6on 1,066,711 0 0 0 0 559.301 Budgeted Depreciation (netted) 0 707,550 707,550 0 707,550 1,072,100 Operating Expenditures/Expense 1,066,111 707,550 707,550 0 707,550 0 1,072,100 0 Acct Class: 590 Other Financing Sources & Uses 549.391 Bank Charges 10,036 11,000 11,000 9,672 11,000 11,000 549.395 Credit Card Fees and Charges 9,192 7,000 7,000 9,296 11,000 11,000 567.000 Gain/Loss on Investments 341 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 - A'P 0 0 0 0 0 Other Financing Sources 8 Uses 19,569 18,000 18,000 18,968 22,000 0 22,000 0 Other Nonoperating 1,086,280 725,550 725,550 18,968 729,550 0 1,094,100 0 Dept: 990 Other/Reserve/Conti�gency 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 OthedReserve/Contingency 0 0 0 0 0 0 0 0 Total Expenditures 4,912,159 6,393,450 7,007,067 3,571,756 6,914,733 6,152,650 7,874,950 0 WaterFund -439,718 0 0 593,904 -2,309,203 -1,255,850 0 0 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 34 8/29/2016 Village of Tequesta 11:19 am Prior --------------------- Current Year ----------____----- �g) �7) �g) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 402 - Refuse & Recycling Revenues Dept: 000 General Acct Class: 335 Intergovemmental Revenue 338.110 Recycling Shared Rev - SWA 5,633 5,000 5,000 3,058 3,058 Intergovemmental Revenue 5,633 5,000 5,000 3,058 3,058 0 0 0 Acct Class: 340 Charges for Services 343.307 Penalty Charges 0 0 0 0 0 343.400 Refuse! Recycling Fees 472,983 485,000 485,000 483,311 485,000 484,000 484,000 Charges for Services 472,983 485,000 485,000 483,311 485,000 484,000 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 Other Financing Sources 0 0 0 0 0 0 0 0 General 478,616 490,000 490,000 486,369 488,058 484,000 484,000 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investrnent Eamin 361.100 Interestllnvestment Earnings 126 0 0 113 113 361.101 PBC Tax Col-Interest on Dep 13 0 0 17 17 367.100 Net Unreal apprecia6on (Dep) 0 0 0 0 0 Unrestricted Investment Eamin 139 0 0 130 130 0 0 0 OtherNonoperating 139 0 0 130 130 0 0 0 Total Revenues 478,755 490,000 490,000 486,499 488,188 484,000 484,000 0 Expenditures Dept: 245 Refuse and Recycling Acct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 0 0 0 0 0 543.302 Solid Waste/Residentiai 257,806 256,830 256,656 213,879 256,656 259,000 259,000 543.303 Recycling/Residential 91,306 90,960 90,923 75,769 90,923 91,700 91,700 543.304 Yard WastelResidential 85,552 84,530 85,169 70,973 85,169 85,950 85,950 543.305 PBC Tax Col Fees & Discounts 0 0 0 0 0 543.306 Fuei Factor 57,546 49,640 49,490 41,241 49,490 39,150 39,150 549.300 Other Misc Chgs & Obligafions 190 590 312 189 189 600 600 549.301 Admin Mgmt Fees 7,270 7,450 7,450 6,829 7,450 7,600 7,600 Operating Expenditures/Expense 499,670 490,000 490,000 408,880 489,877 484,000 484,000 0 Refuse and Recycling 499,670 490,000 490,000 408,880 489,877 484,000 484,000 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 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 35 8/29/2016 Village of Tequesta 11:19 am Prior ------------------- Current Year --------------------- (s) (�) ($) Year Original Amended Actual Thru Esfimated Monih:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 402 - Refuse & RecyGing E�enditures Dept: 910 Other Finanang Sources & Uses Acct Class: 590 Other Financing Sources & Uses 567.100 Unrealized Loss on Investments 0 0 0 0 0 Other Finanang 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 Otfier Financing Sources & Uses 567.000 Gain/Loss on Investments 310 0 0 0 0 590.001 Allocate to Fund Balance 0 0 0 0 0 Other Financing Sources & Uses 310 0 0 0 0 0 0 0 Other Nonoperating 310 0 0 0 0 0 0 0 TotalExpenditures 499,980 490,000 490,000 408,880 489,877 484,000 484,000 0 Refuse&Recyding -21,225 0 0 77,619 -1,689 0 0 0 BUDGET WORKSHEET FY2017 DRAFT at OS/19/16 Page: 36 8/29/2016 Village of Tequesta 11:19 am Prior ----------- Current Year ----__���___ �g) �7) �g) Year Original Amended Actual Thru EsUmated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 403 - Stormwater Utility Revenues Dept: 000 �eneral Acct Class: 340 Charges for Services 343.901 Storm WaterUtility Fees 319,993 325,000 325,000 322,979 325,000 325,000 341,250 Charges for Services 319,993 325,000 325,000 322,979 325,000 325,000 341,250 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 319,993 325,000 325,000 322,979 325,000 325,000 341,250 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investment Eamin 361.100 Interest/Investment Earnings 1,030 1,000 1,000 878 1,000 361.101 PBC Tax Col-Interest on Dep 9 0 0 11 11 367.100 Net Unreal appreciation (Dep) 0 0 0 0 0 Unrestricted Investrnent Eamin 1,039 1,000 1,000 889 1,011 0 0 0 OtherNonoperating 1,039 1,000 1,000 889 1,011 0 0 0 Dept: 990 OthedReserve/Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 231,550 231,550 0 0 342,100 Other Financing Sources 0 231,550 231,550 0 0 0 342,100 0 OthedReserve/Con6ngency 0 231,550 231,550 0 0 0 342,100 0 Total Revenues 321,032 557,550 557,550 323,868 326,011 325,000 683,350 0 Expenditures Dept: 250 Storm Water Utilifies Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 55,588 91,300 82,000 72,502 82,400 213,700 87,100 514.100 OveRime 717 1,000 1,000 1,246 1,246 1,000 1,000 515.102 Standby Pay 1,839 2,000 2,000 2,558 2,475 2,000 2,000 515.103 Bonus Pay Plan 0 0 0 0 0 100 100 515.106 Clothing & Boot Allowance 150 250 250 100 200 400 200 515.108 Auto Allowance 120 750 750 660 750 750 750 515.120 Cell phone allowance 40 0 0 220 250 250 250 516.100 Compensated Absences 1,477 0 0 0 0 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 3,539 5,600 5,600 4,755 5,400 13,100 5,700 521.102 MedicareTaxes 828 1,300 1,300 1,112 1,250 3,100 1,400 522.102 VOT Pension Contributions 4,673 6,900 6,900 5,423 6,165 17,100 9,300 522.150 Pension Expense -4,722 0 0 0 0 523.101 Life/Health Insurance 10,894 28,600 13,200 12,002 13,205 52,000 16,400 523.105 HSA - Health Savings Account 0 0 0 0 0 BUDGET WORKSHEET FY2017 DRAFT at 08/19/16 Page: 37 8/29/2016 Village of Tequesta 11:19 am Prior ------------------- Curcent Year ------_�____�-- �g) ��) �g) Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 403 - Stormwater Utility Expenditures Dept: 250 Storm Water Utili6es Acct Class: 510 Personal Services 523.110 Retiree Health Care Expense 500 0 0 0 0 524.100 Workers' Comp Insurance 1,946 1,050 1,050 1,003 1,004 4,600 5,500 526.102 Employee Assistance Program 17 300 300 91 102 554.301 Personnel Training 0 0 0 0 0 1,500 1,000 Personal Services 77,606 139,050 114,350 101,672 114,447 309,600 130,700 0 Acct Class: 530 Operating E�enditures/Expense 531.302 Engineering Services 14,414 50,000 50,000 3,280 25,000 50,000 25,000 532.300 Accounting & Auditing Services 4,006 4,100 4,100 4,261 4,261 4,200 4,200 534.300 Other Contractual Services 0 50,000 50,000 38,992 50,000 50,000 50,000 540.300 Travel & Per Diem 0 0 0 0 1,000 1,500 1,500 541.300 Communication Services 1,829 1,900 1,900 3,722 4,600 2,500 6,000 541.301 Postage 0 1,100 1,100 0 1,000 1,100 1,100 545.3001nsurence 0 0 0 0 0 500 450 546.302 Vehicle Repair & Maintenance 687 2,000 2,000 877 2,000 4,000 2,000 546.303 Building Repair & Maint 0 2,000 2,000 405 1,000 4,000 2,000 546.308 Drainage Maintenance 16,696 42,300 37,300 23,183 37,300 60,000 45,000 546.310 Equipment Repair & Maint 1,951 2,500 2,500 1,852 2,500 5,000 5,000 546.320 Computersystemmaint&suppli 317 1,750 1,750 937 1,750 1,400 1,400 549.300 Other Misc Chgs & Obligations 1,044 1,000 1,000 1,316 1,065 2,000 2,000 549.301 Admin Mgmt Fees 12,340 12,400 12,400 11,642 12,700 13,000 13,000 549.304 Licenses, Fees & Permits 3,936 4,500 4,500 3,889 4,500 4,500 4,500 551.300 Office Supplies & Equipment 232 300 300 93 300 1,000 1,000 552.301 Gas 8� Oil 1,620 2,700 2,700 985 2,700 5,000 5,000 552.302 Small Tools and Equipment 3,662 7,500 7,500 3,966 7,500 15,000 7,500 554.100 Public Education Program 0 1,000 1,000 0 1,000 1,000 1,000 Operating Expenditures/Expense 62,734 187,050 182,050 99,400 160,176 225,700 177,650 0 Acct Class: 590 Other Financing Sources 8 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 Ouday 662.632 Architect & Engeering 0 0 0 0 0 663.663 Drainage Improvements 0 0 0 0 0 664.600 Mach/Equipment 0 0 0 0 0 15,000 15,000 664.602 Vehicles 0 0 0 0 0 60,000 664.607 Equipment - Tech 0 0 0 0 0 Capital0utlay 0 0 0 0 0 75,000 15,000 0 Storm Water Utilities 140,340 326,100 296,400 201,072 274,623 610,300 323,350 0 BUDGET WORKSHEET FY2017 DRAFT at 08I19116 Page: 38 Village of Tequesta 8 am Prior ---------------------- Current Year ---------------------- � ��) � Year Original Amended Actual Thru Estimated Month:9/30/2016 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 403 - Stormwater Utility Expenditures Dept: 411 Renewal 8 Replacement Acct Class: 530 Operating Expenditures/Expense 531.302 Engineering Services 16,670 20,000 0 0 0 20,000 40,000 546.308 Drainage Maintenance 0 100,000 149,700 146,138 149,700 390,000 210,000 546.319 S.Cypress rear alleyway improv 0 0 0 0 0 546.321 Budget Alleyway lmprovements 0 0 0 0 0 546.322 Seabrook Stormwater Imprvmnts 0 0 0 0 0 Operating Expenditures/Expense 16,670 120,000 149,700 146,138 149,700 410,000 250,000 0 Renewal 8� Replacement 16,670 120,000 149,700 146,138 149,700 410,000 250,000 0 Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 591.401 Tfr to Water U6lities # 401 19,981 0 0 0 0 Interfund Transfers Out 19,981 0 0 0 0 0 0 0 Interfiind Transfers 19,981 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 ExpenditureslExpense 559.300 Depreciation 105,406 0 0 0 0 559.301 Budgeted Depreciation (netted) 0 111,450 111,450 0 111,450 110,000 Operating Expenditures/Expense 105,406 111,450 111,450 0 111,450 0 110,000 0 Acct Class: 590 Other Financing Sources & Uses 567.000 Gain/Loss on Investments 541 0 0 0 0 590.001 Ailocate to Fund Balance 0 0 0 0 0 Other Financing Sources & Uses 541 0 0 0 0 0 0 0 Other Nonoperating 105,947 111,450 111,450 0 111,450 0 110,000 0 Dept: 990 Other/Reserve/Contingency Acct Class: 590 Other Financing Sources & Uses 599.902 Reserves - Contingency 0 0 0 0 0 Other Finanang Sources & Uses 0 0 0 0 0 0 0 0 Other/Reserve/Contingency 0 0 0 0 0 0 0 0 Total Expenditures 282,938 557,550 557,550 347,210 535,773 1,020,300 683,350 0 Stormwater Utility 38,094 0 0 -23,342 -209,762 -695,300 0 0 Grand Total: -32,519 0 0 1,672,736 -2,467,397 -10,835,500 0 0