Loading...
HomeMy WebLinkAboutHandouts_Workshop_Tab 01_08/20/2015 ������N��.� DATE: AUGUST 19, 2015 TO: MICHAEL R. COUZZO, VILLAGE MANAGER FROM: JOANN FORSYTHE, FINANCE DIRECTOR RE: UPDATED FY2016 BUDGET WORKSHEET Attached is the most current version of the FY2016 Budget Worksheet. It includes the following two changes that were requested by the Police Department and Leisure Services. 1) Police Chief Elg requested that the request for an additional F/T Police Officer, at an annual cost of $73,242 be replaced with two P/T Police Officers, at an annual cost of $51,751. This change resulted in lowering the cost of the Police Department budget by $21,491. At your direction, we applied this difference to `Transfers-Out' to Capital Improvement Fund #301 and increased the budget in Fund #301 by that amount. 2) Parks and Recreation Director Greg Corbitt informed us that the Village expects to receive a FRDAP Grant in the amount of $50,000 to be used to improve/repair the facilities at Constitution Park. Both revenues and expenditures were increased in General Fund #001 to reflect the receipt of the grant proceeds and the performance of the required work. 8/19/15338 PM BUDGET WORKSHEET Page: 1 8/19/2015 Village of Tequesta 11:38 am Prior -------------------- Current Year ------------------- �6) ��) �8) Year Original Amended Actual Thru Estimated Month:8/31I2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001- General Fund Revenues Dept: 000 General Acct Class: 311 General Property Taxes 311.000 Ad Valorem Taxes - Current 4,755,463 5,230,800 5,230,800 5,237,859 5,237,859 5,618,900 5,618,900 311.100 Ad Valorem Taxes-Del 12,485 5,000 5,000 20,692 20,692 10,000 10,000 General Property Taxes 4,767,948 5,235,800 5,235,800 5,258,551 5,258,551 5,628,900 5,628,900 0 Acct Class: 316 Sales & Use Taxes 312.510 Fire Insurance Prem Tax 100,617 118,000 118,000 33,970 118,000 122,500 122,500 314.100 Utility Tau-Electriciiy 508,480 470,000 470,000 410,074 476,000 476,000 476,000 314.300 Utility Ta�c-Water 162,922 160,000 160,000 140,296 163,000 163,000 163,000 314.400 Utility Tax - Natural Gas 241 0 0 997 1,000 300 300 314.800 Utility Tax-Propane 31,982 30,000 30,000 23,943 30,000 30,000 30,000 315.000 Comm.Services Tax (CST) 324,530 319,500 319,500 240,342 319,400 319,000 310,000 321.000 Local Business Tax (Occ Lic) 73,887 72,000 72,000 75,955 76,000 75,000 75,000 321.001 Home Business Ta�c 5,544 4,500 4,500 4,750 4,750 4,500 4,500 321.010 Local Business Tax - County 7,899 4,600 4,600 6,847 5,425 4,800 4,800 Sales&UseTaxes 1,216,102 1,178,600 1,178,600 937,174 1,193,575 1,195,100 1,186,100 0 Acct Class: 318 Franchise fees - gross receipt 313.100 Fran Fees-Electric 401,859 414,000 414,000 373,755 456,000 456,000 456,000 Franchise fees - gross receipt 401,859 414,000 414,000 373,755 456,000 456,000 456,000 0 Acct Class: 329 Intragovernmental Revenue 341.401 Admin Mgmt Fees-Water 499,785 514,780 514,780 428,983 514,779 530,200 530,200 341.402 Admin Mgmt Fee-Ref & Recycling 7,055 7,270 7,270 6,058 7,269 7,450 7,450 341.403 Admin Mgmt Fees - Storm Water 11,978 12,340 12,340 10,283 12,339 12,700 12,700 369.010 Misc Revenue - Hats 370 0 0 26 26 Intragovernmental Revenue 519,188 534,390 534,390 445,350 534,413 550,350 550,350 0 Acct Class: 335 Intergovernmental Revenue 335.120 Municipal Revenue Sharing Prog 175,577 176,000 176,000 148,932 177,000 177,000 180,000 335.150 Alcoholic Beverage Licenses 8,901 6,000 6,000 5,282 6,000 6,000 6,000 335.180 Loc Gov1/2 CentSales Tax Pro 413,721 405,000 405,000 337,751 445,000 430,000 460,000 338.101 LocalGas Tax-6 Cent 116,770 116,000 116,000 95,116 122,000 119,000 126,000 338.102 Local Gas Tau 1-5 Cent 55,647 56,000 56,000 44,765 57,500 56,000 58,900 Intergovemmental Revenue 770,616 759,000 759,000 631,846 807,500 788,000 830,900 0 Acct Class: 341 Chgs for Serv - Gen Gov 341.101 CeRification/Copy Fees 13,009 10,000 10,000 12,243 13,000 12,000 12,000 341.103 Election qualifying fees 90 0 0 60 60 341.105 Admin fees from other Gov'ts 1,647 1,200 1,200 1,032 1,200 1,200 1,200 Chgs for Serv - Gen Gov 14,746 11,200 11,200 13,335 14,260 13,200 13,200 0 Acct Class: 362 Rents & Royalties 362.110 Lease-Sprint 36,105 37,187 37,187 34,089 37,187 38,300 38,300 BUDGET WORKSHEET Page: 2 8/19/2015 Village of Tequesta 11:38 am Prior -------------------- Current Year ------------------ �6) ��) �$) Year Original Amended Actual Thru Es6mated Month:B/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Revenues Dept: 000 General Acct Class: 362 Rents & Royalties 362.112 Lease-T-Mobile 50,804 52,836 52,836 48,400 52,836 54,950 54,950 362.115 Lease - Nextel 0 0 0 0 0 362.116 Lease-AT&T 30,000 30,000 30,000 27,500 30,000 30,000 30,000 362.117 Verizon-901 Old Dixie 6,000 66,000 36,000 33,120 36,000 37,650 37,650 362.118 Verizon-136 Bridge Rd 5,000 0 30,000 27,538 30,000 30,500 30,500 Rents & Royalties 127,909 186,023 186,023 170,647 186,023 191,400 191,400 0 Acct Class: 366 Contributions & Dona6ons 366.100 Contrib & Donations & Sponsors 0 0 0 0 0 Contribufions & Donations 0 0 0 0 0 0 0 0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 24,723 8,000 8,000 740 740 369.100 Insurance Reimbursement 28,683 15,500 15,500 11,816 11,816 Miscellaneous Revenues 53,406 23,500 23,500 12,556 12,556 0 0 0 General 7,871,774 8,342,513 8,342,513 7,843,214 8,462,878 8,822,950 8,856,850 0 Dept: 150 Comprehensive Planning Acct Class: 340 Charges for Services 341.150 Land Development Fees 31,465 35,000 35,000 45,471 46,000 35,000 35,000 343.700 Water Conservation & Resource 913 0 0 959 959 Charges for Services 32,378 35,000 35,000 46,430 46,959 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 32,378 35,000 35,000 46,430 46,959 35,000 35,000 0 Dept: 171 Police Acct Class: 320 Licenses & Permits 329.102 Special Truck Permits 15 0 0 0 0 Licenses & Permits 15 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 1,411 0 0 443 443 Grants - State 1,411 0 0 443 443 0 0 0 Acct Class: 335 Intergovemmental Revenue 338.201 PBC 911 Maint Reimbursement 14,554 8,000 8,000 0 8,000 8,000 8,000 338.202 PBC 911 DISPATCH REIMBURSEMENT 27,428 19,320 19,320 15,170 18,000 18,300 18,300 IntergovemmentalRevenue 41,982 27,320 27,320 15,170 26,000 26,300 26,300 0 Acct Class: 337 Grants & Contributions - Local 366.122 Donations -Military to Main St 12,500 5,000 5,000 7,500 7,500 BUDGET WORKSHEET Page: 3 8/19I2015 Village of Tequesta 11:38 am Prior --------------------- Current Year -__._------------- � ��) �$) Year Original Amended Actual Thru Estimated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Revenues Dept: 171 Police Grants & Contributions - Local 12,500 5,000 5,000 7,500 7,500 0 0 0 Acct Class: 342 Chgs for Serv - Public Safety 342.110 PBC - Marine law enforce. serv 9,100 0 0 16,660 16,660 16,600 16,600 Chgs for Serv - Public Safety 9,100 0 0 16,660 16,660 16,600 16,600 0 Acct Class: 351 Fines & Forfeitures 351.100 Court Fines 5,57� 2,060 2,000 10,510 12,000 5,000 5,000 354.101 Parking Tickets 2,070 800 800 3,880 4,000 1,000 1,000 354.102 Code Enf Fines & Court Costs 24,230 0 0 0 0 Fines & Forfeitures 31,877 2,800 2,800 14,390 16,000 6,000 6,000 0 Acct Class: 363 Impact Fees 362.221 Police Impact Fees 126 0 0 252 252 Impact Fees 126 0 0 252 252 0 0 0 Acct Class: 366 Contribu6ons & Dona6ons 366.100 Contrib & Dona6ons & Sponsors 0 0 0 2 2 Contributions & Donations 0 0 0 2 2 0 0 0 Acct Class: 369 Misceilaneous Revenues 369.000 OtherMiscellaneousRevenue 900 0 0 4,144 4,144 Miscellaneous Revenues 900 0 0 4,144 4,144 0 0 0 Police 97,911 35,120 35,120 58,561 71,001 48,900 48,900 0 Dept: 175 Police Department Acct Class: 369 Miscellaneous Revenues 359.100 Forfeitures/Confiscafions 100 0 0 50 50 Miscellaneous Revenues 100 0 0 50 50 0 0 0 Police Department 100 0 0 50 50 0 0 0 Dept: 180 Building & Zoning Acct Class: 320 Licenses & Permits 322.000 Building Permit Fees 419,065 363,040 363,040 291,858 300,000 394,000 394,000 329.000 Contractor's Registration 9,590 9,700 9,700 8,320 9,600 9,700 9,700 329.010 Contraclor Reg. - County 4,755 5,000 5,000 3,379 5,000 5,300 5,300 Licenses & Permits 433,413 377,740 377,740 303,557 314,600 409,000 409,000 0 Acct Class: 351 Fines & Forfeitures 354.102 Code Enf Fines & Court Costs 0 4,500 30,890 56,596 68,000 48,000 48,000 Fines & Forfeitures 0 4,500 30,890 56,596 68,000 48,000 48,000 0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 60 0 0 0 0 Miscellaneous Revenues 60 0 0 0 0 0 0 0 Building & Zoning 433,473 382,240 408,630 360,153 382,600 457,000 457,000 0 Dept 192 Fire Control Acct Class: 334 Grants - State 337.201 State EMS GRANT 0 0 0 0 0 BUDGET WORKSHEET Page: 4 8/19/2015 Village of Tequesta 11:38 am Prior --------------- Current Year ----------------- (6) (7) (8) Year Original Amended Actual Thru Esfimated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Revenues Dept: 192 Fire Control Grants - State 0 0 0 0 0 0 0 0 Acct Class: 335 Intergovernmental Revenue 335.201 Fire Incentive Pay 3,725 3,600 3,600 3,150 3,600 3,600 3,600 Intergovemmental Revenue 3,725 3,600 3,600 3,150 3,600 3,600 3,600 0 Acct Class: 340 Charges for Services 342.192 Fire - Exha Duty 662 500 500 0 350 500 500 342.201 Fire Plan Review Fees 56,792 42,000 42,000 13,136 29,500 30,000 30,000 342.202 Firelnspec6ons 26,599 23,720 23,720 24,689 25,000 23,700 23,700 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 735 700 700 965 965 700 700 342.410 Emergency Svc- PBC Fire Rescue 189,520 195,206 195,206 195,206 195,206 201,000 201,000 342.600 EMS Transportation Fees 307,273 315,000 315,000 282,551 315,000 315,000 315,000 342.950 Allow for doubHul rev- GovFnd 0 0 0 0 0 ChargesforServices 981,581 977,126 977,126 916,547 966,021 970,900 970,900 0 Acct Class: 363 Impact Fees 362.222 Fire Impact Fees 173 500 500 348 500 500 500 ImpactFees 173 500 500 348 500 500 500 0 Acct Class: 366 Contributions & Donations 366.106 Contrib & Donations & Sponsors 130 250 250 5 200 250 250 Contributions & Donations 130 250 250 5 200 250 250 0 Acct Class: 369 Miscellaneous Revenues 365.102 Fire Dept Sales 65 50 50 95 95 50 50 369.000 OtherMiscellaneousRevenue 6,897 1,600 1,600 0 7,600 1,600 1,600 Miscellaneous Revenues 6,962 1,650 1,650 95 1,695 1,650 1,650 0 FireControl 992,571 983,126 983,126 920,145 972,016 976,900 976,900 0 Dept: 231 Leisure Services Acct Class: 334 Grants - State 334.205 State DEP Grant -(FRDAP) 0 0 0 0 0 50,000 Grants - State 0 0 0 0 0 0 50,000 0 Acct Class: 347 Charges for Services - Recr. 347.100 Tequesta Fest 7,774 7,800 7,800 7,752 7,752 7,800 7,800 347.190 Special Events - Other 11,041 10,000 10,000 10,602 10,602 10,000 10,000 347.201 WintedSummer Camp Fees 36,330 42,750 42,750 29,130 35,000 42,750 37,750 347.205 Recreation Programs Fees 9,547 6,000 6,000 6,848 7,800 6,000 6,000 Charges for Services - Recr. 64,692 66,550 66,550 54,332 61,154 66,550 61,550 0 Acct Ciass: 362 Rents & Royalties 362.100 Rental - Facilities 8,997 6,500 6,500 5,624 6,500 6,500 6,500 Rents & Royalties 8,997 6,500 6,500 5,624 6,500 6,500 6,500 0 Acct Class: 363 Impact Fees BUDGET WORKSHEET Page: 5 8/19/2015 Village of Tequesta 11:38 am Prior ------------------------- Current Year -------___--------- � ��) �$) Year Original Amended Actual Thru Estimated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Revenues Dept: 231 Leisure Services Acct Class: 363 Impact Fees 363.271 Parks and Rec Impact Fees 551 0 0 1,102 1,102 ImpactFees 551 0 0 1,102 1,102 0 0 0 Acct Class: 366 Contributions & Donations 366.100 Contrib & Donations & Sponsors 7,125 7,200 7,200 7,500 7,500 7,200 7,200 Contributions & Donations 7,125 7,200 7,200 7,500 7,500 7,200 7,200 0 Acct Class: 369 Miscellaneous Revenues 365.110 Concession Sales 2,677 5,000 5,000 921 921 5,000 5,000 369.000 Other Miscellaneous Revenue 0 0 0 0 0 Miscellaneous Revenues 2,677 5,000 5,000 921 921 5,000 5,000 0 Leisure Services 84,042 85,250 85,250 69,479 77,177 85,250 130,250 0 Dept 900 Interfund Transfers Acct Class: 391 Transfers In 381.301 Transfer-In from Cap Improvemn 100,000 0 0 0 0 381.303 Tsfer-In from Capital Projects 50,000 0 0 0 0 381.605 Tfr In - Special Law Enf Trust 0 0 0 0 0 Transfers In 150,000 0 0 0 0 0 0 0 Interfund Transfers 150,000 0 0 0 0 0 0 0 DepL 910 Other Financing Sources & Uses Acct Class: 390 Other Financing Sources 383.100 Capital Lease at Inception 432,844 60,000 295,000 0 295,000 30,000 163,300 Other Financing Sources 432,844 60,000 295,000 0 295,000 30,000 163,300 0 OtherFinancing Sources & Uses 432,844 60,000 295,000 0 295,000 30,000 163,300 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investrnent Eamin 361.100 InteresUlnvestment Earnings 8,261 9,000 9,000 5,964 7,230 8,500 8,500 361.101 PBC Tax Col-Interest on Dep 132 500 500 142 142 367.100 Net Unreal appreciation (Dep) 4,791 7,500 7,500 0 0 Unrestricted Inveshnent Eamin 13,184 17,000 17,000 6,106 7,372 8,500 8,500 0 AcctClass: 369 MiscellaneousRevenues 364.100 Dispasition of Assets 0 90,000 90,000 13,073 13,073 250,000 Miscellaneous Revenues 0 90,000 90,000 13,073 13,073 0 250,000 0 OtherNonopera6ng 13,184 107,000 107,000 19,179 20,445 8,500 258,500 0 Dept: 990 Other/Reserve/Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 0 100,480 0 0 Other Financing Sources 0 0 100,480 0 0 0 0 0 OthedReserve/Con6ngency 0 0 100,480 0 0 0 0 0 BUDGET WORKSHEET Page: 6 8/19/2015 Village of Tequesta 11:38 am Prior ----------_------ Current Year --------------------- � ��) � Year Original Amended Actual Thru Estimated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001- General Fund TotalRevenues 10,108,277 10,030,249 10,392,119 9,317,211 10,328,126 10,464,500 10,926,700 0 Expenditures Dept: 100 Council Acct Class: 530 Opera6ng Expenditures/Expense 531.311 CouncilFees-Arena 3,000 3,000 3,000 2,750 3,000 5,450 5,100 531.313 Council fees - T. Patemo 3,000 3,000 3,000 2,750 3,000 3,000 3,000 531.314 Council fees - F. D'Ambra 3,000 3,000 3,000 2,750 3,000 5,450 5,100 531.316 Council fees - S. Okun 3,000 3,000 3,000 2,750 3,000 5,450 5,100 531.317 Council Fees - Brennan 3,000 3,000 3,000 2,750 3,000 3,000 3,000 540.301 Council Expenses -Arena 0 3,000 2,500 0 2,500 3,000 3,000 540.304 Council Expense - F. D'Ambra 0 3,000 2,500 580 2,500 3,000 3,000 540.306 Council Expense - S. Okun 813 3,000 3,000 353 3,000 3,000 3,000 540.307 Council Expenses - Brennan 1,907 3,000 3,000 1,974 3,000 3,000 3,000 540.308 Council Expenses - Paterno 190 3,000 3,000 30 3,000 3,000 3,000 549.300 Other Misc Chgs & Obligations 641 700 657 284 657 700 700 549.350 VolunteerAppreciation 835 800 843 843 843 800 800 554.300 Books, Publ, Subs & Membership 2,985 3,500 3,500 3,060 3,500 3,500 3,500 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 23,371 35,000 35,000 21,874 35,000 42,350 41,300 0 Council 23,371 35,000 35,000 21,874 35,000 42,350 41,300 0 Dept: 110 Manager Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 132,079 137,200 141,100 120,429 141,100 146,900 146,900 514.100 Overtime 0 0 0 0 0 515.103 Bonus Pay Pian 4,500 0 0 0 0 750 750 515.108 AutoAllowance 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 Compensated Absences 5,491 9,000 4,200 0 0 3,500 3,500 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Ta�ces 6,619 7,500 7,500 6,706 7,300 8,000 8,000 521.102 MedicareTaxes 2,132 2,200 2,300 1,929 2,300 2,400 2,400 522.102 VOTPensionContributions 12,125 11,600 11,900 10,152 11,900 11,000 11,000 523.101 Life/Health Insurance 19,328 18,800 17,600 16,146 17,600 18,000 19,700 523.105 HSA - Health Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 260 • 240 240 234 234 250 250 BUDGET WORKSHEET Page: 7 8/19/2015 Village of Tequesta 11:38 am Prior --------------------- Current Year ----------------- �6) ��) �8) Year Original Amended Actual Thru Estimated Month:8i3112015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept 110 Manager Acct Class: 510 Personal Services 526.104 ICMA-Def Comp Plan 9,827 10,300 10,300 8,732 10,220 10,700 10,700 554.301 Personnel Training 1,395 1,000 1,000 785 1,000 1,000 1,000 Personal Services 197,956 202,040 200,340 168,963 195,854 206,700 208,400 0 Acct Class: 530 Operating Expenditures/Expense 540.300 Travel & Per Diem 1,281 1,400 1,900 1,898 1,898 1,400 1,400 546.320 Computer system maint & suppli 0 500 1,948 1,948 1,948 800 800 549.300 Other Misc Chgs & Obligations 30 250 2 0 0 250 250 554.300 Books, Publ, Subs & Membership 2,540 3,150 3,150 2,528 3,150 3,400 3,400 Operating Expenditures/Expense 3,851 5,300 7,000 6,374 6,996 5,850 5,850 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 CapitalOuUay 0 0 0 0 0 0 0 0 Manager 201,807 207,340 207,340 175,337 202,850 212,550 214,250 0 Dept: 111 Human Resources Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 79,603 81,700 105,080 85,815 104,900 136,700 138,400 515.103 Bonus Pay Plan 3,000 0 0 0 0 750 750 515.107 Part-time Salaries 30,836 30,000 27,322 27,322 27,740 515.120 Cell phone allowance 0 0 700 600 700 1,200 1,200 516.100 Compensated Absences 1,982 2,000 3,354 3,353 3,354 2,700 2,700 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 6,811 7,100 8,573 7,212 8,400 8,600 8,700 521.102 Medicare Taxes 1,593 1,700 2,105 1,687 2,000 2,000 2,100 522.102 VOT Pension Contributions 7,307 6,900 8,860 7,234 8,850 10,300 10,400 523.101 Life/Healthlnsurance 7,255 7,000 11,050 9,107 11,040 24,400 26,600 523.105 HSA - Health Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 216 200 200 195 195 250 250 525.100 Unemployment Compensation 0 0 2,700 1,925 2,700 526.101 Employee Recognition Program 5,994 5,500 8,173 6,461 6,780 10,000 10,000 526.102 Employee Assistance Program 3,406 4,000 3,500 3,406 3,406 4,200 4,200 526.103 Education Reimbursement Prgm 0 1,000 3 0 0 1,000 1,000 554.301 Personnel Training 2,100 2,500 1,875 1,875 2,398 2,500 2,500 554.310 Employee Development 850 2,000 2,432 2,431 2,432 4,000 4,000 Personal Services 150,953 151,600 185,927 158,623 184,895 208,600 212,800 0 BUDGET WORKSHEET Page: 8 8/19/2015 Village of Tequesta 11:38 am Prior ------------- Current Year ------------------------ �6) ��) �$) Year Original Amended Actual Thru Esfimated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 111 Human Resources Acct Class: 530 Operating Expenditures/Expense 540.300 Travel & Per Diem 1,248 1,300 2,315 2,314 2,315 2,000 2,000 546.320 Computer system maint & suppli 53 500 523 522 523 1,200 1,200 547.300 Printing & Binding 0 1,500 1,150 158 1,500 1,500 1,500 549.300 Other Misc Chgs & Obliga6ons 126 500 0 0 0 500 500 549.401 Recruitmentexpenses 401 1,500 800 714 800 1,500 1,500 552.302 Small Tools and Equipment 60 500 285 0 0 500 500 554.300 Books, Publ, Subs & Membership 564 ' 700 500 474 500 600 600 Operating Expenditures/Expense 2,452 6,500 5,573 4,182 5,638 7,800 7,800 0 Acct Class: 590 Other Financing Sources 8 Uses 599.100 Budget Cost Savings 0 33,400 0 0 0 Other Financing Sources & Uses 0 33,400 0 0 0 0 0 0 Acct Class: 600 Capital OuHay 664.601 Computer Equipment 0 1,600 1,600 1,521 1,522 Capital0utlay 0 1,600 1,600 1,521 1,522 0 0 0 Human Resources 153,405 193,100 193,100 164,326 192,055 216,400 220,600 0 Dept 120 Village Clerk Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 109,623 112,500 112,500 101,244 118,700 125,100 125,100 514.100 Overtime 0 0 1,350 235 1,350 2,200 2,200 515.103 Bonus Pay Plan 3,000 0 0 0 0 750 750 515.107 Part-time Salaries 0 0 0 0 0 27,000 26,500 516.100 Compensated Absences 0 0 0 0 0 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 6,677 7,600 7,700 6,409 7,700 10,000 9,900 521.102 Medicare Taxes 1,561 1,800 1,900 1,499 1,800 2,400 2,400 522.102 VOT Pension Cantribu6ons 10,063 9,500 9,500 8,535 10,000 9,400 9,400 523.101 Life/Health Insurance 24,026 17,400 17,400 15,937 17,400 18,300 19,300 523.105 HSA - Health Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 216 200 200 194 194 250 200 526.103 Education Reimbursement Prgm 326 0 0 0 0 554.301 Personnel Training 399 1,980 2,180 2,100 2,180 1,950 1,950 Personal Services 155,891 150,980 152,730 136,153 159,324 197,350 197,700 0 Acct Class: 530 Operating Expenditures/Expense 531.303 Codification Services 14,850 10,700 10,700 7,774 10,700 10,700 10,700 531.304 Recording Secy Service 6,833 7,350 8,850 7,349 8,850 534.301 Election Expense 1,306 15,940 988 988 988 18,600 18,600 534.302 Legal Advertising 10,361 14,800 14,800 5,762 14,800 14,800 14,800 BUDGET WORKSHEET Page: 9 8/19/2015 Village of Tequesta 11:38 am Prior -------------------- Current Year ------------------ �6) ��) �8) Year Original Amended Actual Thru Es6mated Month:B/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001- General Fund Expenditures Dept 120 Village Clerk Acct Class: 530 Operating Expenditures/Expense 534.311 Election exp. - annexations 0 0 0 0 0 540.300 Travel & Per Diem 2,126 3,440 4,240 4,063 4,240 3,450 3,450 541.300 Communicafion Services 1,039 1,300 1,300 1,118 1,300 1,300 1,300 546.320 Computer system maint & suppli 495 19,300 19,300 18,844 19,300 10,750 10,750 548.110 Marketing and Public Rela6ons 400 2,200 2,200 1,702 2,200 2,200 2,200 549.100 Miscellaneous Archival 107 2,500 900 667 900 2,500 2,500 549.201 Advertising & Promotion 0 0 0 0 0 549.300 Other Misc Chgs & Obligations 768 2,300 1,800 411 411 2,300 2,300 552.302 Small Tools and Equipment 153 500 500 124 500 500 500 552.306 Microfilm Service/Supplies 11 30 30 11 30 554.300 Books, Publ, Subs & Membership 410 860 1,160 1,001 1,002 1,160 1,160 Operating Expenditures/Expense 38,859 81,220 66,768 49,814 65,221 68,260 68,260 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 11,102 0 0 Other Financing Sources & Uses 0 0 11,102 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.601 Computer Equipment 0 0 1,600 1,600 1,600 Capital0utlay 0 0 1,600 1,600 1,600 0 0 0 Village Clerk 194,750 232,200 232,200 187,567 226,145 265,610 265,960 0 DepL 130 Finance Acct Class: 510 Personal Services 572.100 Regular Salaries & Wages 237,480 245,100 248,200 211,896 248,200 255,400 255,400 514.100 Ove�ime 0 0 0 0 0 515.103 Bonus Pay Plan 7,950 0 0 0 0 2,250 2,250 515.120 Cell phone allowance 0 0 350 300 350 600 600 516.100 CompensatedAbsences 4,119 3,500 3,500 0 3,500 3,600 3,600 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taues 14,251 15,200 15,200 12,537 15,000 15,500 15,400 521.102 Medicare Taxes 3,374 3,600 3,600 2,990 3,600 3,800 3,700 522.102 VOT Pension Contribufions 21,801 20,700 20,920 17,863 20;920 19,100 19,100 523.101 Life/Health Insurance 43,930 43,600 43,600 39,844 43,500 45,700 49,000 523.105 HSA - Health Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 473 400 400 392 392 450 450 525.100 Unemployment Compensafion 4,400 0 0 0 0 554.301 PersonnelTraining 1,168 4,400 2,400 1,255 2,400 4,400 4,400 Personal Services 338,946 336,500 338,170 287,077 337,862 350,800 353,900 0 Acct Class: 530 Operating Expenditures/Expense BUDGET WORKSHEET Page: 10 8/19/2015 Village of Tequesta 11:35 am Prior ------------------- Current Year ----------------- (6) (7) (8) Year Original Amended Actual Thru Es6mated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 130 Finance Acct Class: 530 Operating Expenditures/Expense 532.300 Accounting &Auditing Services 23,865 24,610 24,610 24,605 24,606 25,100 25,100 540.300 Travel& Per Diem 462 1,000 1,000 989 1,000 1,000 1,000 546.301 Office Equip/Repair 8� Maint 682 900 900 425 900 900 900 546.320 Computer system maint & suppli 7,699 8,800 8,800 7,396 8,800 13,100 13,100 547.300 Printing & Binding 1,759 3,000 2,330 1,466 2,330 3,000 3,000 549.300 Other Misc Chgs & Obligations 586 1,000 500 0 500 1,000 1,000 551.300 Office Supplies & Equipment 2,796 4,000 4,000 1,203 4,000 4,000 4,000 552.302 Small Tools and Equipment 0 5�0 0 0 0 500 500 554.300 Books, Publ, Subs & Membership 724 1,600 1,600 1,054 1,600 1,600 1,600 Operating Expenditures/Expense 38,573 45,410 43,740 37,138 43,736 50,200 50,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 664.601 Computer Equipment 0 0 0 0 0 Capital0utlay 0 0 0 0 0 0 0 0 Finance 377,519 381,910 381,910 324,215 381,598 401,000 404,100 0 Dept: 140 Legal Acct Class: 530 Operafing Expenditures/Expense 531.301 LegalServices 96,520 90,000 90,000 62,431 90,000 90,000 90,000 531.308 Legalfees- Personnel 100,851 60,000 60,000 49,702 60,000 60,000 60,000 Opera6ng Expenditures/Expense 197,371 150,000 150,000 112,133 150,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 197,371 150,000 150,000 112,133 150,000 150,000 150,000 0 Dept: 150 Comprehensive Planning Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 68,537 0 0 0 0 515.103 Bonus Pay Plan 3,000 0 0 0 0 516.100 Compensated Absences 1,895 0 0 0 0 521.101 FICATaxes 4,247 0 0 0 0 521.102 Medicare Taxes 993 0 0 0 0 522.101 FRS Contributions 4,955 0 0 0 0 523.101 Life/Health Insurance 6,643 0 0 0 0 524.100 Workers' Comp Insurance 272 0 0 0 0 Personal Services 90,542 0 0 0 0 0 0 0 Acct Class: 530 Operating Expenditures/Expense BUDGET WORKSHEET Page: 11 8l19/2015 Village of Tequesta 11:38 am Prior ----------------- Current Year -------------------- �6) ��) �$) Year Original Amended Actual Thru Estimated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 150 Comprehensive Planning Acct Class: 530 Opera6ng ExpenditureslExpense 531.301 LegalServices 23,560 22,000 22,000 22,753 22,000 22,000 22,000 531.321 Mapping Services 2,248 2,500 2,500 420 2,500 7,500 2,500 531.322 Misc Planning Service 73,681 135,200 135,200 106,444 135,200 147,700 143,550 531.326 Comp Plan Service 0 0 0 0 0 9,000 531.331 BoardofAdjustment 0 250 0 0 0 531.332 Planning and Zoning Board 500 750 1,000 630 1,000 1,000 1,000 531.405 Legal - Annexation 0 0 0 0 0 534.300 Other Contractual Services 2,688 5,000 5,000 5,771 5,771 5,000 5,000 534.302 Legal Advertising 4,535 8,500 7,600 2,800 7,500 8,500 7,500 534.420 Legal Advertising - Annexa6on 0 0 0 0 0 546.320 Computer system maint & suppli 4,200 4,800 4,800 3,578 4,800 3,800 3,800 547.300 Printing & Binding 0 500 500 120 500 500 500 549.150 Miscellaneous annexation exp 0 0 0 0 0 549.300 Other Misc Chgs & Obligafions 128 500 500 228 500 500 500 551.300 Office Supplies & Equipment 598 750 750 460 750 750 750 554.300 Books, Publ, Subs & Membership 0 0 900 900 900 900 900 Operating Expenditures/Expense 112,138 180,750 180,750 144,104 181,421 207,150 188,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 Acct Class: 600 Capital Outlay 664.601 Computer Equipment 0 0 0 0 0 Capital0utlay 0 0 0 0 0 0 0 0 ComprehensivePlanning 202,680 180,750 180,750 144,104 187,421 207,150 188,000 0 Dept: 160 General Govemment Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 69,666 71,500 71,500 60,714 71,100 72,900 72,900 515.103 Bonus Pay Plan 2,400 0 0 0 0 600 600 516.100 Compensated Absences 2,765 4,000 3,000 0 3,000 4,100 4,100 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 4,313 4,600 4,600 3,566 4,400 4,700 4,700 521.102 MedicareTaxes 1,009 1,100 1,100 834 1,100 1,100 1,100 522.102 VOTPensionContributions 6,395 6,100 6,100 5,118 6,000 5,500 5,500 523.101 LifelHealthlnsurance 7,690 13,200 13,200 11,989 13,200 13,900 15,200 523.105 HSA - Health Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 137 130 130 123 123 150 150 526.101 Employee Recognition Program 0 0 904 903 904 BUDGET WORKSHEET Page: 12 8/19/2015 Village of Tequesta 11:38 am Prior ---------------- Current Year ----•---------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:813112015 Actual Budget Budget August Total DEPARTMENT MANAGER GOUNCIL Fund: 001 - General Fund Expenditures Dept: 160 General Govemment Acct Class: 510 Personal Services 526.102 Employee Assistance Program 0 0 1,105 648 1,105 11,950 11,956 526.103 Educafion Reimbursement Prgm 0 0 0 0 0 3,000 3,000 554.301 Personnel Training 1,475 5,000 590 590 590 2,000 2,000 Personal Services 95,850 105,630 102,229 84,485 101,522 119,9U0 121,20U � Acct Class: 530 Operating ExpenditureslExpense 531.306 IT • Other Contractual Service 0 0 0 6,868 0 32,000 534.300 Other Contractual Services 20,701 35,100 37,600 22,791 37,600 52,300 20,300 534.303 Special Events 6,370 10,000 230 0 0 10,000 10,000 540.300 Travel & Per Diem 2,025 2,000 0 0 0 2,000 2,000 541.300 Communication Services 12,773 14,500 16,600 15,475 16,600 15,000 15,000 541.301 Postage 3,309 4,300 4,300 3,810 4,306 4,300 4,300 541.305 Website Maintenance 7,770 8,100 6,550 6,547 6,547 6,500 6,500 543.300 Utility Services 16,022 16,000 16,000 12,761 16,000 17,000 17,000 544.301 Operafing Leases 5,223 5,350 5,350 4,407 5,250 5,300 5,300 545.300 Insurance 48,729 56,150 56,150 56,123 56,123 56,150 68,000 546.301 Office Equip/Repair & Maint 1,596 2,000 2,000 1,624 2,000 3,000 3,000 546.302 Vehicle Repair & Maintenance 20 100 100 70 100 500 500 546.303 Building Repair & Maint 0 0 0 0 0 546.310 Equipment Repair & Maint 1,083 1,000 295 0 0 1,000 1,000 546.320 Computer system maint & suppli 12,646 17,750 17,750 11,735 17,750 27,700 32,500 547.300 Printing & Binding 739 1,000 6,516 6,065 6,516 2,000 2,000 549.300 Other Misc Chgs & Obligations 8,728 10,000 9,740 9,000 9,740 10,000 10,000 549.302 Village Newsletter 10,689 19,000 19,000 12,466 19,000 21,000 21,000 549.304 Licenses, Fees & Permits 1,960 2,600 2,600 2,239 2,240 2,700 2,700 551.300 Office Supplies 8 Equipment 3,353 4,000 4,000 3,755 4,000 4,000 4,000 552.160 IT Operating Supplies 702 800 800 732 800 800 S00 552.301 Gas & Oil 165 500 500 121 250 500 500 552.302 Small Tools and Equipment 505 1,500 1,500 1,180 1,500 1,000 1,000 554.300 Books, Publ, Subs & Membership 2,429 2,500 2,500 2,143 2,500 2,500 2,500 Operating Expenditures/Expense 167,537 214,250 210,081 179,912 208,816 245,250 261,900 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 0 0 0 OtherFinancing Sources & Uses 0 0 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 662.600 Buildings 0 0 4,000 3,998 4,000 664.600 Mach/Equipment 0 0 2,670 2,670 2,670 664.601 Computer Equipment 0 0 2,400 0 2,400 11,400 BUDGET WORKSHEET Page: 13 8/19/2015 Village of Tequesta 11:38 am Prior ----------------------- Current Year ------------------ ls) ��) l$) Year Original Amended Actual Thru Es6mated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept 160 General Govemment Acct Class: 600 Capital Outlay 664.602 Vehicles 0 0 0 0 0 664.607 Equipment-Tech 0 0 0 0 0 44,000 Capital0utlay 0 0 9,070 6,668 9,070 55,400 0 0 General Govemment 263,387 319,880 321,380 271,065 319,408 420,550 383,100 0 Dept: 175 Police Department Acct Class: 510 Personal Services 512.171 Sal & Wages - Adminstration 122,287 128,600 128,600 108,409 127,300 133,300 133,300 512.172 Reg Sal & Wages - Communicatio 244,408 251,000 251,000 213,131 249,500 256,000 256,000 512.175 RegSal&Wages-Operations 916,325 1,012,800 1,050,300 892,783 1,046,100 1,179,100 1,091,300 514.172 Overtime - Communications 19,051 18,000 18,000 12,655 18,000 21,400 21,400 514.175 Overtime-Operations 125,568 63,500 90,000 87,163 90,000 106,000 106,000 515.101 Holiday Pay 39,449 43,600 43,600 40,778 43,600 45,000 45,000 515.103 Bonus Pay Plan 13,250 58,250 8,500 9,250 9,250 10,250 10,250 515.106 Clothing & BootAllowance 10,619 12,700 12,200 12,200 12,200 13,800 13,250 515.107 Part-6me Salaries 30,251 0 0 0 0 515.108 AutoAllowance 6,000 6,000 6,000 5,500 6,000 6,000 6,000 515.120 Cell phone allowance 1,200 1,200 1,200 1,100 1,200 1,200 1,200 515.125 OtherAllowances 8,400 8,400 8,400 7,700 8,400 8,400 8,400 515.172 P/T Salary - Communications 38,884 24,000 45,000 43,406 45,000 36,800 36,800 515.175 PfT Salary - Operations 0 46,600 44,662 35,532 42,000 45,300 93,500 516.100 CompensatedAbsences 35,123 15,000 15,000 7,520 15,000 15,500 15,500 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 96,391 101,800 101,000 87,978 101,000 113,400 109,400 521.102 MedicareTaxes 22,578 24,200 24,000 20,952 24,000 27,000 26,100 522,101 FRS Contributions 41,731 39,600 39,600 37,199 44,000 42,600 46,500 522.102 VOT Pension Contributions 132,984 108,300 96,051 81,353 96,051 67,400 66,900 522.105 Defined Contribufion 19,782 58,000 42,322 33,690 39,800 54,200 47,100 522.110 Other Pension Contributions 0 0 0 0 0 523.101 Life/Health Insurance 231,329 227,800 224,256 203,212 221,700 265,700 252,200 523.105 HSA - Health Savings Account 0 3,500 3,500 2,900 3,450 4,200 4,200 524.100 Workers' Comp Insurance 45,425 34,200 34,200 34,164 34,165 35,900 32,350 525.100 Unemployment Compensation 635 0 825 825 825 526.101 Employee Recognifion Program 1,207 3,000 3,000 1,262 3,000 3,000 3,000 526.103 Education Reimbursement Prgm 0 4,000 2,000 0 2,000 4,000 4,000 526.105 Employee Physical/Psycological 6,926 8,000 2,081 355 2,881 3,400 3,400 554.301 Personnel Training 9,306 11,000 8,000 6,947 8,000 11,000 11,000 BUDGET WORKSHEET Page: 14 8/19/2015 Village of Tequesta 11:38 am Prior --------------------- Current Year ---------------------- �s) ��) �$) Year Original Amended Actual Thru Estimated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 175 Police Department Personal Services 2,219,109 2,313,050 2,303,297 1,987,964 2,294,452 2,509,850 2,444,050 0 Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 22,143 0 0 0 0 531.320 Code Enforcement Service 563 0 0 0 0 531.327 Other Contractual -MTMS 16,595 40,400 55,366 55,365 55,366 534.300 Other Contractual Services 0 0 2,538 2,538 2,538 540.300 Travel & Per Diem 8,449 12,000 9,000 7,385 9,000 12,000 12,000 541.300 Communication Services 24,890 32,000 30,500 23,411 30,500 30,500 30,500 541.301 Postage 2,473 2,000 2,000 782 2,000 2,000 2,000 543.300 Utility Services 25,592 25,000 25,000 21,500 25,000 25,000 25,000 544.301 Operating Leases 1,996 2,000 2,000 1,829 2,000 2,000 2,000 545.300 Insurance 48,483 56,750 56,750 55,528 55,529 56,750 59,800 546.175 K-9 Equipment & Maintenance 4,000 6,000 6,000 3,672 6,000 6,000 6,000 546.301 Office Equip/Repair & Maint 333 1,000 1,000 246 1,000 1,000 1,000 546.302 Vehicle Repair & Maintenance 33,092 18,500 32,000 30,019 27,483 20,650 20,650 546.303 BuildingRepair&Maint 18,362 19,100 19,100 11,465 19,100 20,000 35,000 546.304 Communication Equip Maint 92,350 12,800 13,294 12,790 13,294 32,850 32,850 546.310 Equipment Repair & Maint 5,687 2,500 3,800 3,585 3,586 2,500 2,500 546.320 Computer system maint & suppli 71,762 86,500 83,500 69,608 83,500 96,700 103,600 547.300 Printing & Binding 2,494 1,800 1,800 1,311 1,800 4,000 4,000 549.300 Other Misc Chgs & Obliga6ons 5,606 5,000 5,000 2,365 5,000 5,000 5,000 549.303 Investigative Expenses 943 1,100 1,100 983 1,100 2,000 2,000 549.304 Licenses, Fees & Permits 1,624 2,500 2,500 1,929 2,500 2,500 2,500 549.311 Marine UnitOperations 2,888 1,750 1,750 1,280 1,750 1,750 1,750 549.314 K.E.Y.S. Program 700 0 0 0 0 551.300 Office Supplies & Equipment 5,195 5,000 5,000 3,868 5,000 5,000 5,000 551.301 Crime Prevention Supplies 1,954 2,500 2,500 1,364 2,500 2,500 2,500 552.301 Gas & Oil 55,037 63,000 41,300 32,557 36,000 63,000 45,000 552.302 Small Tools and Equipment 23,108 12,000 23,334 22,753 23,334 16,000 16,000 552.305 Uniforms 24,021 18,000 18,000 16,282 18,000 18,000 18,000 554.300 Books, Publ, Subs & Membership 2,339 2,400 2,400 1,636 2,400 3,700 3,700 Operating Expenditures/Expense 502,679 431,600 446,532 386,051 435,280 431,400 438,350 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 487 0 0 Other Financing Sources & Uses 0 0 487 0 0 0 0 0 Acct Class: 600 Capital OuUay 663.710 Police Department Capital Proj 2,333 0 0 0 0 BUDGET WORKSHEET Page: 15 8/19/2015 Village of Tequesta 11:38 am Prior --------------------- Current Year --------------------- �s) ��) �$) Year Original Amended Actual Thru Estimated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 175 Police Department AcctClass: 600 CapitalOuUay 664.600 Mach/Equipment 215,216 0 0 0 0 4,000 664.601 Computer Equipment 4,808 0 0 0 0 664.602 Vehicles 67,604 0 238,434 4,120 238,434 664.607 Equipment-Tech 0 0 0 0 0 60,000 664.620 Intangible - Software 0 0 0 0 0 CapitalOuUay 289,961 0 238,434 4,120 238,434 64,000 0 0 ' Police Department 3,011,749 2,744,650 2,988,750 2,378,135 2,968,166 3,005,250 2,882,400 0 Dept 180 Building & Zoning Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 52,462 196,900 218,000 181,872 216,750 314,300 245,800 515.103 Bonus Pay Plan 0 0 0 0 0 500 500 515.106 Clothing & Boot Allowance 0 100 100 100 100 100 100 515.107 Part-6me Salaries 13,512 42,600 62,700 53,212 62,400 16,900 58,000 516.100 Compensated Absences 0 0 0 0 0 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICATaxes 4,058 14,900 18,100 14,484 17,500 20,400 18,900 521.102 Medicare Taxes 949 3,500 4,250 3,388 4,150 4,800 4,400 522.102 VOT Pension Contributions 4,816 16,600 18,400 15,332 18,300 23,600 18,400 523.101 Life/Healthlnsurance 9,011 20,600 21,400 19,084 20,830 39,500 23,300 523.105 HSA - Health Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 158 3,400 3,400 3,386 3,387 3,600 3,100 525.100 Unemployment Compensation 3,209 1,000 1,000 309 1,000 554.301 Personnel Training 0, 0 1,700 1,310 1,700 3,000 2,400 PersonalServices 88,175 299,600 349,050 292,477 346,117 426,700 374,900 0 Acct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 1,995 20,000 23,350 22,921 23,350 20,000 20,000 531.320 Code Enforcement Service 0 4,000 5,000 4,840 5,000 5,000 4,000 531.325 Inspection Services 157,255 65,000 0 0 0 534.300 Other Contractual Services 9,957 6,000 1,350 1,350 1,350 1,250 5,250 540.300 Travel& Per Diem 160 500 1,200 1,052 1,200 3,000 3,000 541.300 Communicafion Services 2,706 3,000 5,800 5,090 5,800 6,000 6,000 541.301 Postage 925 1,000 2,250 1,731 2,256 1,600 1,600 543.300 Ufility Services 5,979 6,000 6,000 4,786 5,800 6,000 6,000 544.301 Operating Leases 1,873 1,850 1,850 1,689 1,850 1,850 1,850 545.3001nsurance 0 0 0 0 0 1,100 546.301 Office Equip/Repair & Maint 839 1,000 1,200 998 1,000 1,000 1,000 546.302 Vehicle Repair & Maintenance 0 0 5,754 5,248 5,754 2,250 2,250 BUDGET WORKSHEET Page: 16 8/19/2015 Village of Tequesta 11:38 am Prior -------------------- Current Year ---------------- �6) ��) �a) Year Original Amended Actual Thru Estimated Month:B/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 180 Building & Zoning Acct Class: 530 Operating Expenditures/Expense 546.303 Building Repair & Maint 0 0 0 0 0 546.320 Computer system maint & suppli 9,994 12,600 17,250 13,040 17,250 20,200 18,750 547.300 Printing & Binding 650 1,500 146 141 141 500 300 549.300 Other Misc Chgs & Obliga6ons 852 600 900 868 868 800 800 549.304 Licenses, Fees & Permits 1,435 1,700 1,700 1,332 1,700 2,000 1,700 551.300 Office Supplies & Equipment 2,067 3,000 4,900 4,680 4,900 3,800 2,800 552.301 Gas 8 Oil 0 0 700 609 700 1,000 1,000 554.300 Books, Publ, Subs & Membership 1,056 500 1,850 1,622 1,850 2,000 1,000 Operafing E�cpenditures/Expense 197,743 128,250 81,200 71,997 80,763 78,250 78,400 0 Acct Class: 590 Other Financing Sources & Uses 549.395 Credit Card Fees and Charges 0 0 600 424 600 500 500 Other Financing Sources & Uses 0 0 600 424 600 500 500 0 Acct Class: 600 Capital OuBay 664.600 Mach/Equipment 0 0 0 0 0 664.601 Computer Equipment 0 0 0 0 0 18,000 664.602 Vehicles 0 0 0 0 0 58,250 664.620 Intangible - Software 0 0 0 0 0 CapitalOuUay 0 0 0 0 0 76,250 0 0 Building &Zoning 285,918 427,850 430,850 364,898 427,480 581,700 453,800 0 Dept: 192 Fire Control Acct Class: 510 Personal Services 512.100 RegularSalaries & Wages 1,453,251 1,512,500 1,465,700 1,246,973 1,469,000 1,488,100 1,492,800 514.100 Overtime 61,568 56,800 66,800 66,400 69,000 67,500 67,500 514.300 Overtime-Training 17,129 19,500 19,500 18,669 78,504 19,500 19,500 515.101 Holiday Pay 49,644 49,700 49,700 46,376 50,600 50,600 50,700 515.103 Bonus Pay Plan 58,500 0 0 0 0 4,450 4,450 515.107 Part-time Salaries 39,423 40,300 37,490 30,583 36,200 65,400 39,800 515.11� lntem Fire Fighter Pay 57,453 61,200 61,200 51,044 59,915 62,900 62,800 515.120 Cell phone aliowance 1,200 1,200 1,200 1,100 1,200 1,200 1,200 515.125 Other Allowances 3,600 3,600 3,600 3,300 3,600 3,300 3,300 516.100 Compensated Absences 7,151 19,600 19,600 6,565 8,000 22,000 22,000 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 102,539 107,100 107,100 88,796 107,100 107,800 107,200 521.102 Medicare Taxes 23,981 25,100 25,100 20,767 25,100 25,200 25,100 522.102 VOT Pension Confibutions 355,679 353,500 353,500 292,905 350,000 369,400 203,600 522.110 OtherPension Conhibutions 100,617 118,000 118,000 33,970 118,000 122,500 122,500 523.101 Life/Health Insurance 206,612 188,300 193,300 184,358 201,500 229,300 273,000 BUDGET WORKSHEET Page: 17 8/19/2015 Village of Tequesta 11:38 am Prior ------------------------ Curcent Year --------------------- � ��) �$) Year Original Amended Actual Thru Estimated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 192 Fire Control Acct Class: 510 Personal Services 523.105 HSA - Heafth Savings Accrount 0 0 0 0 0 524.100 Workers' Comp Insurance 55,654 51,560 51,560 51,556 51,557 54,150 45,800 525.100 Unemployment Compensation 0 0 0 0 0 526.101 Employee Recognition Program 1,228 2,950 2,950 2,303 2,250 2,950 2,950 526.103 Education ReimbursementPrgm 15,454 19,900 14,900 6,169 14,900 24,900 24,900 526.104 ICMA-Def Comp Plan 1,626 4,900 4,900 4,163 4,907 3,800 3,800 526.105 Employee Physical/Psycological 9,307 9,900 9,900 9,541 9,500 9,900 9,900 554.301 PersonnelTraining 5,985 9,200 9,200 6,146 8,100 9,200 9,200 Personal Services 2,627,601 2,654,810 2,615,200 2,171,684 2,608,933 2,744,050 2,592,000 0 Acct Class: 530 Operating Expenditures/Expense 531.318 Volunteer Fire Fighter Program 6,852 0 0 0 0 534.300 Other Contractual Services 0 0 2,810 2,807 2,807 540.300 Travel & Per Diem 666 5,300 5,300 4,078 3,850 5,300 5,300 541.300 Communication Services 13,264 13,700 13,700 13,397 14,400 13,750 13,750 541.301 Postage 1,717 1,500 1,500 1,033 1,250 1,500 1,500 543.300 Utility Services 29,460 30,650 30,650 24,830 32,600 33,500 33,500 544.301 Operating Leases 5,491 5,760 5,760 4,985 5,300 5,900 5,900 545.3001nsurance 21,736 22,400 22,400 22,351 22,381 22,400 20,800 546.302 Vehicle Repair & Maintenance 2,627 4,700 4,700 1,897 3,500 3,700 3,700 546.303 Building Repair & Maint 27,900 25,950 25,950 18,512 27,500 28,300 43,300 546.310 Equipment Repair & Maint 17,060 22,750 22,750 18,598 22,500 24,800 24,800 546.320 Computersystemmaint&suppli 20,555 26,900 26,900 16,376 26,900 33,100 36,350 547.300 Printing & Binding 967 1,450 1,450 1,090 1,100 1,450 1,450 549.300 Other Misc Chgs & Obligations 2,300 3,850 3,850 3,536 3,536 3,850 3,850 549.304 Licenses, Fees & Permits 15,954 18,850 18,850 17,502 18,000 19,000 19,000 549.311 Marine Unit Operations 2,225 3,900 3,900 1,453 3,200 3,700 3,700 551.300 Office Supplies & Equipment 2,403 2,700 2,700 2,369 2,600 2,700 2,700 551.302 Fire Prevention Education 2,046 2,350 2,350 1,709 2,300 2,350 2,350 552.301 Gas & Oil 16,279 17,700 17,700 13,115 18,850 19,200 19,200 552.302 Small Tools and Equipment 2,259 3,250 3,250 2,669 2,900 3,250 3,250 552.304 Chemicals 950 1,000 1,000 0 950 1,000 1,000 552.305 Uniforms 19,260 23,350 23,350 16,845 21,000 23,350 23,350 552.308 Safety Supplies 11,394 21,700 21,700 11,283 20,000 19,700 19,700 552.310 Disaster Relief Supplies 0 5,300 5,300 0 4,500 5,300 5,300 552.311 CPR Program Supplies 500 550 550 465 500 550 550 552.312 MedicalSupplies 36,520 38,000 38,000 28,738 35,000 36,000 36,000 BUDGET WORKSHEET Page: 18 8/19/2015 Village of Tequesta 11:38 am Prior ----------------------- Current Year ---------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month: S/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 192 Fire Control Acct Class: 530 Operating Expenditures/Expense 552.344 Fire Station Supplies 2,992 3,000 3,000 1,385 2,800 3,000 3,000 554.300 Books, Publ, Subs & Membership 2,296 3,300 3,300 3,229 3,300 3,400 3,400 Operating 6cpenditures/Expense 265,673 309,860 312,670 234,282 303,524 320,050 336,700 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 11,400 59,220 0 0 Other Financing Sources & Uses 0 11,400 59,220 0 0 0 0 0 Acct Class: 600 Capital OuUay 664.600 Mach/Equipment 540,080 22,000 10,980 0 10,980 133,300 133,300 664.607 Equipment-Tech 0 0 0 0 0 60,000 664.620 Intangible - Soflware 0 0 0 0 0 Capital0utlay 540,080 22,000 10,980 0 10,980 193,300 133,300 0 Fire Control 3,433,354 2,998,070 2,998,070 2,405,966 2,923,437 3,257,400 3,062,000 0 Dept: 210 Public Works Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 189,161 183,100 18Q,406 154,145 172,152 328,30� 298,90� 514.100 Overtime 211 1,000 1,555 1,554 1,555 1,500 1,500 515.103 Bonus Pay Plan 1,500 0 0 0 0 250 515.106 Clothing & Boot Allowance 550 450 450 450 450 750 750 515.107 Part-fime Salaries 16,545 0 0 0 0 515.108 Auto Allowance 1,800 450 0 0 0 1,450 516.100 Compensated Absences 18,296 0 2,694 2,694 2,694 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 13,090 11,200 11,200 9,673 11,200 19,600 17,700 521.102 Medicare Taxes 3,062 2,600 2,600 2,262 2,600 4,600 4,200 522.101 FRS Contributions 8,966 0 0 0 0 522.102 VOT Pension Confibutions 11,790 15,500 15,500 13,035 14,435 24,600 22,400 523.101 Life/Health Insurance 65,498 50,500 47,505 43,151 46,655 100,100 94,600 523.105 HSA - Health Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 17,173 13,160 13,160 13,158 13,159 13,850 14,350 Personal Services 347,642 277,960 275,070 240,122 264,900 493,550 455,850 0 Acct Class: 530 Operating Expenditures/Expense 531.302 Engineering Services 7,590 2,000 3,550 2,451 3,550 2,000 2,000 534.300 Other Contractual Services 0 1,000 7,700 2,532 7,700 1,000 1,000 540.300 Travel & Per Diem 0 150 150 0 100 100 100 541.300 Communica6on Services 4,487 4,500 5,100 4,563 5,100 4,700 4,700 543.300 Utility Services 103,212 112,000 112,000 80,256 109,000 110,000 110,000 543.301 StreetLights 134,241 135,000 137,500 113,920 137,000 137,000 137,000 BUDGET WORKSHEET Page: 19 8/19/2015 Village of Tequesta 11:38 am Prior --------------------- Current Year ------------------ (6) (7) (8) Year Original Amended Actual Thru Estimated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 210 Public Works Acct Class: 530 Operating Expenditures/Expense 544.301 Operating Leases 1,137 1,200 1,200 844 1,200 1,200 1,200 544.304 FEC Lease 14,031 14,650 14,650 14,648 14,650 15,300 15,300 545.300 Insurance 10,463 12,900 12,900 11,614 11,614 12,900 13,800 546.200 R&M - Station 11 0 2,500 1,000 341 1,000 2,500 2,500 546.301 Office Equip/Repair & Maint 85 200 200 68 200 200 200 546.302 Vehicle Repair & Maintenance 2,159 4,000 6,000 4,661 6,000 6,300 6,300 546.303 Building Repair & Maint 10,708 12,000 12,000 7,379 12,000 12,000 12,000 546.305 Pathway Maintenance 7,162 12,000 7,423 7,422 7,423 12,000 22,400 546.306 General Maintenance 29,098 30,000 27,800 24,767 27,800 30,000 30,000 546.309 Landscape & Irrigation Maint 126,190 137,000 136,021 102,927 136,021 137,000 137,000 546.310 Equipment Repair & Maint 13,458 11,000 4,000 3,638 4,000 11,000 11,000 546.320 Computer system maint & suppli 325 1,250 1,250 291 1,250 3,400 3,800 546.350 R&M-Roads 23,796 30,000 84,190 80,103 84,190 56,400 62,300 549.300 Other Misc Chgs & Obligations 2,033 3,500 3,290 2,370 3,290 3,500 3,500 549.304 Licenses, Fees & Permits 1,429 1,500 1,500 1,409 1,500 1,500 1,500 551.300 Office Supplies & Equipment 319 450 450 249 450 450 450 551.400 Janitorial Supplies 5,236 6,000 5,000 4,010 5,000 6,000 6,000 552.301 Gas & Oil 7,528 6,000 6,000 4,159 6,000 6,000 6,000 552.302 Small Tools and Equipment 842 3,000 4,606 4,605 4,606 3,000 3,000 552.305 Uniforms 1,410 2,000 2,000 1,534 2,000 2,000 2,000 553.301 Road Signs 1,739 2,500 4,700 3,793 4,700 2,500 10,000 563.600 Public Works Misc Prajects 2,468 5,500 40,920 25,514 40,920 5,500 5,500 Operating Expenditures/Expense 511,146 553,800 643,100 510,068 638,264 585,450 610,550 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 31,100 0 0 0 Other Financing Sources & Uses 0 31,100 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 663.650 Pathways 0 0 3,300 2,957 2,957 20,000 664.600 Mach/Equipment 0 15,000 15,000 14,758 14,758 30,000 664.602 Vehicles 0 60,000 60,000 0 60,000 664.607 Equipment-Tech 0 0 0 0 0 13,000 Capital0utlay 0 75,000 78,300 17,715 77,715 13,000 50,000 0 Public Works 858,788 937,860 996,470 767,905 980,879 1,092,000 1,116,400 0 Dept: 230 Parks Acct Class: 530 Operating Expenditures/Expense 546.315 Facilities - Repair & Maint 0 0 0 0 0 Operating Expenditures/Expense 0 0 0 0 0 0 0 0 BUDGET WORKSHEET Page: 20 8119/2015 Viilage of Tequesta 11:38 am Prior ------------------ Current Year ---------------- {6) {7) (8) Year Original Amended Actual Thru Estimated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Parks 0 0 0 0 0 0 0 0 Dept: 231 Leisure Services Acct Class: 510 Personal Seruices 512.100 Regular Salaries & Wages 159,395 163,600 169,900 145,015 169,900 175,000 175,000 515.103 Bonus Pay Plan 6,000 0 0 0 0 2,450 2,450 515.106 Clothing & Boot Allowance 100 100 100 100 100 100 100 515.107 Part-time Salaries 41,256 47,300 44,971 39,239 44,971 49,400 49,400 515.108 AutoAllowance 3,000 3,000 3,000 2,750 3,000 3,000 3,000 515.109 SeasonalSalaries & Wages 19,960 25,000 21,455 21,981 20,000 25,000 20,000 515.120 Cell phone allowance 0 0 700 600 700 1,200 1,200 516.100 CompensatedAbsences 2,133 4,000 4,000 2,329 4,000 4,000 4,000 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 13,457 14,700 14,700 12,711 14,400 15,800 15,400 521.102 MedicareTaxes 3,147 3,500 3,500 2,973 3,400 3,700 3,600 522.102 VOT Pension Contributions 14,632 13,800 14,350 12,225 14,320 13,100 13,100 523.101 Life/Healthlnsurance 42,528 39,400 39,400 36,089 39,400 41,400 44,700 523.105 HSA - Health Savings Account 0 0 0 0 0 524.100 Workers' Comp Insurance 7,100 6,380 6,380 6,378 6,379 6,700 6,400 525.100 Unemployment Compensa6on 0 0 0 0 0 526.105 Employee PhysicallPsycological 757 2,500 2,500 965 2,5�0 2,500 2,500 554.301 Personnel Training 0 1,200 210 210 210 1,200 1,200 PersonalServices 313,465 324,480 325,166 283,565 323,280 344,550 342,050 0 Acct Class: 530 Operating Expenditures/Expense 531.324 Grants Acquistion & Admin 0 0 2,000 2,000 2,000 534.303 Special Events 40,578 45,000 46,443 46,442 46,443 45,000 51,240 540.300 Travel& PerDiem 0 1,500 0 0 0 1,500 1,500 541.300 Communication Services 5,764 5,700 6,700 5,977 6,700 5,700 5,700 541.301 Postage 30 150 200 155 200 150 150 543.300 UtilityServices 10,903 14,000 14,000 8,192 12,000 14,000 14,000 545.300 Insurance 14,494 14,900 14,900 14,871 14,871 14,900 15,600 546.302 Vehicle Repair & Maintenance 784 3,200 3,200 1,195 3,200 4,450 4,450 546.303 Building Repair & Maint 25,157 20,000 20,000 17,981 20,000 20,000 20,000 546.306 General Maintenance 31,457 30,000 30,000 26,265 30,000 30,000 30,000 546.310 Equipment Repair & Maint 801 1,700 1,700 732 1,700 1,700 1,700 546.315 Facilities - Repair & Maint 0 0 0 0 0 50,000 546.320 Computer system maint & suppli 3,463 2,650 2,650 1,623 2,650 4,400 5,150 549.201 Adve�ising & Promotion 4,546 5,000 5,000 4,110 5,000 5,000 5,000 549.300 Other Misc Chgs & Obligations 473 5,000 3,557 2,335 3,557 5,000 5,000 BUDGET WORKSHEET Page: 21 8/19/2015 Village of Tequesta 11:38 am Prior ---------__--------- Current Year -------------------- � ��) � Year Original Amended Actual Thru Estimated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept 231 Leisure Services Acct Class: 530 Operating Expenditures/Expense 549.304 Licenses, Fees & Permits 1,762 2,200 2,330 2,330 2,330 2,200 2,200 549.332 Recreation Program Expense 34,086 38,300 39,002 39,002 39,002 38,300 38,300 549.333 Spring/Summer Camp 11,594 15,000 15,000 12,627 15,000 15,000 15,000 551.300 Office Supplies & Equipment 1,325 2,000 2,000 697 2,000 2,000 2,000 551.315 Concession Supplies 2,498 5,000 1,733 1,732 1,733 5,000 5,000 552.301 Gas & Oil 1,987 2,500 2,500 1,087 2,500 2,500 2,500 552.302 Small Tools and Equipment 1,357 1,500 1,699 993 1,699 1,500 1,500 552.305 Uniforms 387 500 500 367 500 500 500 554.300 Books, Publ, Subs & Membership 165 500 500 0 500 500 500 Operating Expenditures/Expense 193,605 216,300 215,614 190,713 213,585 219,300 276,990 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 5,300 5,300 0 0 Other Financing Sources & Uses 0 5,300 5,300 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.600 Mach/Equipment 1,200 0 0 0 0 664.602 Vehicles 0 0 0 0 0 30,000 30,000 664.607 Equipment - Tech 0 0 0 0 0 45,000 Capital0utlay 1,200 0 0 0 0 75,000 30,000 0 Leisure Services 508,270 546,080 546,080 474,278 536,865 638,850 649,040 0 Dept 700 Debt Service Acct Class: 471 D/S - Principal 571.706 PIS Prin - BOA - P/S Bldg 258,626 269,920 269,920 246,979 269,920 281,700 281,700 571.708 P/S - Prin - SunTrust - Pumper 47,785 38,810 38,810 38,802 38,802 39,800 39,800 571.710 P/S Prin - 2015 PD Vehicles 0 0 50,422 13,055 25,915 78,600 78,600 571.712 2015 Public Works Vehicles 0 11,070 11,070 0 0 19,400 19,400 571.716 Principal -L.S. - Transport va 0 0 0 0 0 9,700 9,700 571.727 Lease Prin - SCVA Fire Equip 0 0 0 0 0 25,100 D/S - Principal 306,411 319,800 370,222 298,836 334,637 429,200 454,300 0 Acct Class: 472 D!S - Interest 572.706 P/S - Int. BOA - P.S Bldg 113,875 102,590 102,590 94,481 102,590 90,900 90,900 572.708 P/S - SunTrust - Pumper 350 9,340 9,340 9,333 9,333 8,400 8,400 572.710 Interest - 2015 PD Vehicles 0 0 4,238 928 2,053 5,400 5,400 572.712 2015 Public Works Vehicles 0 2,200 2,200 0 0 1,600 1,600 572.716 Interest - L.S. - Transport va 0 0 0 0 0 S00 800 572.725 Int. 2012 Ford Focus - Admin 172 20 20 14 14 572.727 Lease Int. - SCVA - Fire Equip 0 0 0 0 0 3,750 D/S-Interest 114,397 114,150 118,388 104,756 113,990 107,100 110,850 0 BUDGET WORKSHEET Page: 22 8/19/2015 Village of Tequesta 11:38 am Prior ------------------- Current Year ---------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:B/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures DebtService 420,808 433,950 488,610 403,592 448,627 536,300 565,150 0 Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 591.301 Trsf to Capital Imp Fund 0 85,000 85,000 85,000 85,000 316,800 Interfund Transfers Out 0 85,000 85,000 85,000 85,000 0 316,800 0 Interfund Transfers 0 85,000 85,000 85,000 85,000 0 316,800 0 Dept: 910 Other Financing Sources & Uses Acct Class: 590 Other Financing Sources & Uses 567.100 Unrealized Loss on Investments 0 0 0 119 0 Other Financing Sources & Uses 0 0 0 119 0 0 0 0 Other Financing Sources & Uses 0 0 0 119 0 0 0 0 Dept: 950 Other Nonoperating Acct Class: 590 Other Financing Sources & Uses 549.391 Bank Charges 10,335 11,000 11,000 9,430 11,000 11,000 11,000 549.395 Credit Card Fees and Charges 2,400 2,800 2,800 1,462 2,800 2,800 2,800 567.000 Gain/Loss on Investments 0 0 0 0 0 590.001 Allocate to Fund Balance 0 142,809 142,809 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,735 156,609 156,609 10,892 13,800 13,800 13,800 0 Other Nonopera6ng 12,735 156,609 156,609 10,892 13,800 13,800 13,800 0 Dept: 990 OthedReserve/Cantingency Acct Class: 590 Other Financing Sources & Uses 599.902 Reserves - Con6ngency 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Other/ReservelCon6ngency 0 0 0 0 0 0 0 0 Total Expenditures 10,145,912 10,030,249 10,392,119 8,291,406 10,072,731 11,040,910 10,926,700 0 GeneralFund -37,635 0 0 1,025,805 255,395 -576,410 0 0 BUDGET WORKSHEET Page: 23 8/19/2015 Ullage of Tequesta 11:38 am Prior ---------------------- Current Year --------------------- � (�) (8) Year Original Amended Actual Thru Estimated Month:B/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 301 - Capital Improvement Fund Revenues Dept• 000 General Acct Class: 366 Contribufions & Donations 366.100 Contrib & Donafions & 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 0 85,000 85,000 85,000 85,000 316,800 381.303 Tsfer-In from Capital ProjecLs 0 0 0 0 0 Transfersln 0 85,000 85,000 85,000 85,000 0 316,800 0 Interfund Transfers 0 85,000 85,000 85,000 85,000 0 316,800 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investrnent Eamin 361.100 InteresUlnvestment Earnings 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 OthedReserve/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 85,000 85,000 85,000 85,000 0 316,800 0 Expenditures Dept: 210 Public Works Acct Class: 600 Capital Outlay 663.652 Pathway/Sidewalk Improvements 0 0 0 0 0 50,000 663.653 Signage 0 0 0 0 0 45,000 663.655 Landscaping 0 0 0 0 0 663.657 Roadway improvements 0 0 0 0 0 121,800 Capital0utlay 0 0 0 0 0 0 216,800 0 Public Works 0 0 0 0 0 0 216,800 0 Dept: 371 US1 Boulevard Project Acct Ciass: 600 Capital Outlay 663.657 Roadwaylmprovements 0 85,000 85,000 52,998 85,000 100,000 Capital0utlay 0 85,000 85,000 52,998 85,000 0 100,000 0 US1 Boulevard Project 0 85,000 85,�0� 52,998 85,000 0 100,000 0 Dept 399 Misc Proj-General BUDGET WORKSHEET Page: 24 8/19/2015 Village of Tequesta 11:38 am Prior ------------------------ Current Year ----------------- � ��) � Year Original Amended Actual Thru Es6mated Month:8l31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 301 -Capital ImprovementFund Expenditures Dept: 399 Misc Proj-General Acct Class: 600 Capital OuBay 663.647 IT - Storage Project 0 0 0 0 0 Capital0utlay 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 100,000 0 0 0 0 Interfund Transfers Out 100,000 0 0 0 0 0 0 0 Interfund Transfers 100,000 0 0 0 0 0 0 0 TotalExpenditures 100,000 85,000 85,000 52,998 85,000 0 316,800 0 Capital Improvement Fund -100,000 0 0 32,002 0 0 0 0 BUDGET WORKSHEET Page: 25 8/19/2015 Village of Tequesta 11:38 am Prior ---------------- Current Year ----------------------- �6) �7) �a) Year Original Amended Actual Thru Es6mated Month:6/31I2015 Actual Budget 8udget August Total DEPARTMENT MANAGER COUNCIL Fund: 303 - Capital ProjecGs Fund Revenues Dept 990 OthedReserve/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 ExpendituresiExpense 546.311 F�C Track Maintenance 0 0 0 0 0 Operating ExpenditureslExpense 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 50,000 0 0 0 0 591.301 Trsf to Capital Imp Fund 0 0 0 0 0 Interfund Transfers Out 50,000 0 0 0 0 0 0 0 Interfund Transfers 50,000 0 0 0 0 0 0 0 Total Expenditures 50,�00 � 0 0 0 0 0 0 Capital Projects Fund -50,000 0 0 0 0 0 0 0 BUDGET WORKSHEET Page: 26 8/19/2015 Village of Tequesta 11:38 am Prior ---------------------- Current Year ------------------- (6) ��) �$) Year Original Amended Actual Thru Es6mated Month:8/31/2015 Actual Budget Budget August 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 Water Sales 2,235,894 2,300,000 2,300,000 2,026,784 2,350,000 2,350,000 2,503,800 343.302 Water-ConnectCharges 22,017 17,000 17,000 19,449 19,500 17,000 18,190 343.303 Water-Fire Hydrants Rent 65,574 66,300 66,300 61,848 67,400 67,400 72,360 343.304 Water Surcharge 369,395 382,500 382,500 328,465 394,000 394,000 409,280 343.306 Monthly Service Charge 1,395,689 1,423,000 1,423,000 1,318,887 1,434,000 1,434,000 1,530,100 343.307 Penalty Charges 4,975 4,500 4,500 4,577 5,000 4,500 4,820 343.308 Other Water Seroice Income 1,502 1,500 1,500 1,868 1,753 1,500 1,500 343.309 Convenience Fee - CC 0 0 0 0 0 343.700 Water Conservation & Resource 913 1,000 1,000 790 1,000 1,000 1,000 343.950 Allow for doubful rev - Enterp 0 0 0 0 0 ChargesforServices 4,095,959 4,195,800 4,195,800 3,762,671 4,272,653 4,269,400 4,541,050 0 Acct Class: 369 Miscellaneous Revenues 363.101 Martin/Tropic V-Const poRion 20,087 16,000 16,000 33,789 16,000 12,000 12,000 369.000 Other Miscellaneous Revenue 7,465 0 0 11 11 369.100 Insurance Reimbursement 7,863 8,000 8,000 2,541 2,541 Miscellaneous Revenues 35,415 24,000 24,000 36,341 18,552 12,000 12,000 0 Acct Class: 390 Other Financing Sources 369.110 Capital Connect Charge - Cust 7,304 0 0 44,002 44,002 19,260 19,260 369.111 Capital Connect Charge - Devel 34,694 0 0 23,413 23,413 16,050 16,050 369.112 Capital Connect - Tropic Ust 17,907 14,000 14,000 0 14,000 10,000 10,000 Other Financing Sources 59,905 14,000 14,000 67,415 81,415 45,310 45,310 0 General 4,191,279 4,233,800 4,233,800 3,866,427 4,372,620 4,326,710 4,598,360 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investrnent Eamin 361.100 Interest/Investment Earnings 10,291 9,500 9,500 8,370 8,500 8,500 8,500 361.105 Int Income - Tropic Vista Asse 0 0 0 0 0 367.100 Net Unreal apprec4ation (Dep) 3,043 0 0 0 0 Unrestricted Investrnent Eamin 13,334 9,500 9,500 8,370 8,500 8,500 8,500 0 Acct Class: 369 Miscellaneous Revenues 364.100 Disposition of Assets 0 0 0 0 0 Miscellaneous Revenues 0 0 0 0 0 0 0 0 OtherNonoperating 13,334 9,500 9,500 8,370 8,500 8,500 8,500 0 Dept: 990 OtherlReserve/Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 714,990 1,158,123 0 0 1,786,590 Other Financing Sources 0 714,990 1,158,123 0 0 0 1,786,590 0 BUDGET WORKSHEET Page: 27 8/1912015 Village of Tequesta 11:38 am Prior ------------------------ Current Year ------------------ (6) ��) �$) Year Original Amended Actual Thru Estimated Month:8/3112015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Revenues Other/Reserve/Contingency 0 714,990 1,158,123 0 0 0 1,786,590 0 Total Revenues 4,204,613 4,958,290 5,401,423 3,874,797 4,381,120 4,335,210 6,393,450 0 Expenditures Dept: 241 Water-Adminishation Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 139,413 162,300 166,800 142,356 166,800 173,300 206,200 515.103 Bonus Pay Plan 3,150 0 0 0 0 650 650 515.106 Clothing & Boot Allowance 0 0 0 0 0 50 515.108 Auto Allowance 3,000 3,000 3,000 2,750 3,000 3,000 4,450 515.120 Cell phone allowance 0 0 350 300 350 600 600 515.125 OtherAllowances 1,200 1,200 1,200 1,100 1,200 1,200 1,200 516.100 Compensated Absences 24,229 13,500 4,900 0 4,250 8,400 8,400 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 7,189 8,600 8,600 7,693 8,600 8,600 10,600 521.702 Medicare Taxes 2,288 2,600 2,600 2,218 2,600 2,700 3,200 522.102 VOTPensionContributions 12,798 13,700 14,100 12,000 14,100 13,000 15,500 523.101 Life/Healthlnsurance 13,026 15,200 15,200 12,700 13,900 14,000 22,900 523.105 HSA - Health Savings Account 0 0 0 0 0 523.110 Retiree Health Care Expense 500 0 0 0 0 524.100 Workers' Comp Insurance 309 280 280 278 278 300 250 526.102 Employee Assistance Program 0 0 250 146 250 2,700 2,700 526.104 ICMA-Def Comp Plan 9,826 10,300 10,300 8,732 10,300 10,700 10,700 554.301 Personnel Training 750 0 0 0 0 Personal Services 217,678 230,680 227,580 190,273 225,628 239,150 287,400 0 Acct Class: 530 Operating Expenditures/Expense 531.301 LegalServices 2,024 2,000 5,100 6,457 5,174 2,000 2,000 531.302 Engineering Services 118,646 136,950 84,020 55,214 84,020 75,000 75,000 532.300 Accounting & Auditing Services 27,750 28,620 28,620 28,611 28,611 29,200 29,200 534.300 Other Contractual Services 23,617 21,000 61,500 39,046 61,500 30,000 30,000 541.300 Communication Services 0 3,050 3,050 3,050 3,050 3,050 3,050 544.304 FEC Lease 12,531 13,000 13,000 12,694 12,695 13,000 13,000 545.300 Insurance 48,986 47,600 47,600 46,780 46,780 47,600 45,300 549.301 Admin Mgmt Fees 499,785 514,780 514,780 428,983 514,780 514,800 574,800 549.304 Licenses, Fees & Permits 781 800 800 781 781 800 800 Opera6ng ExpenditureslExpense 734,120 767,800 758,470 621,616 757,391 715,450 713,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 BUDGET WORKSHEET Page: 28 8/19/2015 Village of Tequesta 11:38 am Prior ------------------------ Current Year -------------------- (6) ��) � Year Original Amended Actual Thru Es6mated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Expendftures Water-Administration 951,798 998,480 986,050 811,889 983,019 954,600 1,000,550 0 Dept 242 Water- Producfion Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 385,395 484,100 426,600 350,046 426,600 523,900 528,800 514.100 Overtime 6,191 9,000 9,000 5,627 9,000 10,000 10,000 515.101 Holiday Pay 0 0 5,000 4,077 5,000 5,200 5,200 515.102 Standby Pay 4,915 6,000 6,000 3,789 6,000 6,000 6,000 515.103 Bonus Pay Plan 3,000 0 0 0 0 500 500 515.106 Clothing & BootAllowance 600 S00 1,000 700 1,000 900 800 515.107 Part-time Salaries 0 0 0 0 0 12,900 515.108 Auto Allowance 0 0 3,500 3,000 3,500 6,000 6,000 515.120 Cell phone allowance 0 0 700 600 700 1,200 1,200 516.100 Compensated Absences 2,622 5,000 15,150 14,837 14,838 5,000 5,000 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 23,688 30,600 28,300 23,136 28,300 34,500 33,500 521.102 MedicareTaxes 5,540 7,200 6,700 5,411 6,700 8,100 7,900 522.101 FRS Contributions 4,868 5,200 5,200 4,407 5,200 5,300 5,300 522.102 VOT Pension Contributions 28,735 34,400 30,200 24,507 30,200 34,000 34,300 523.101 LifelHealth Insurance 78,477 99,000 75,900 66,781 75,900 113,200 118,900 523.105 HSA - Health Savings Account 0 0 0 0 0 523.110 Retiree Health Care Expense 3,600 0 0 0 0 524.100 Workers' Comp Insurance 12,866 11,450 11,450 11,445 11,446 12,050 9,950 554.301 Personnel Training 1,314 2,000 2,000 1,550 2,000 4,000 4,000 Personal Services 561,811 694,750 626,700 519,913 626,384 782,750 777,350 0 Acct Class: 530 Opera6ng Expenditures/Expense 531.342 WaterAnalysis & Sampling 33,676 44,000 35,000 26,327 35,000 50,000 50,000 540.300 Travel & Per Diem 2,973 3,500 1,100 834 1,100 4,000 4,000 541.300 Communication Services 9,790 9,400 11,740 10,920 11,740 9,500 9,500 541.301 Postage 190 2,000 2,100 2,033 2,100 2,000 2,000 543.300 Ufility Services 325,867 357,000 328,500 289,834 328,500 357,000 357,000 544.301 Operating Leases 10,640 10,000 10,000 6,750 10,000 10,000 10,000 546.302 Vehicle Repair & Maintenance 4,176 4,000 7,500 5,668 7,500 8,050 8,050 546.303 Building Repair & Maint 18,333 20,000 58,570 18,275 20,000 50,000 50,000 546.309 Landscape & Irrigation Maint 17,578 6,000 11,300 8,086 11,300 10,000 10,000 546.310 Equipment Repair & Maint 25,389 20,000 62,913 56,960 62,913 �5,000 �5,000 546.320 Computer system maint & suppli 8,397 9,200 26,200 5,772 9,200 21,000 22,650 546.342 WaterSystem Maintenance 90,190 70,000 115,052 93,882 95,577 100,000 100,000 546.343 Well Redevelopment 41,355 80,000 90,OD0 64,216 89,633 BUDGET WORKSHEET Page: 29 8/19/2015 Village of Tequesta 11:38 am Prior --------------------- Current Year -------------------- �6) �7) �$) Year Original Amended Actual Thru Estimated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Expenditures Dept: 242 Water - Produc6on Acct Class: 530 Operating Expenditures/Expense 547.300 Printing & Binding 4,290 3,000 4,000 3,668 4,000 3,000 3,000 549.300 Other Misc Chgs & Obliga6ons 2,145 2,000 6,300 3,654 6,300 2,000 2,000 549.304 Licenses, Fees & Permits 22,846 30,000 27,800 27,708 27,800 30,000 30,000 551.300 Office Supplies & Equipment 2,226 . 2,500 4,500 4,111 4,500 4,000 4,000 552.301 Gas & Oil 4,140 5,000 5,000 2,756 5,000 5,000 5,000 552.302 Small Tools and Equipment 2,828 3,000 3,000 2,858 3,000 5,000 5,000 552.303 Diesel Fuel 6,958 15,000 7,188 0 7,188 15,000 15,000 552.305 Uniforms 2,123 2,500 3,000 2,620 3,000 3,000 3,000 552.341 WaterPurchases 0 30,000 30,000 0 0 30,000 30,000 552.342 WaterChemicals 148,240 168,000 170,172 119,996 170,172 185,000 185,000 552.343 LaboratorySupplies 17,642 14,000 17,000 16,792 17,000 15,000 15,000 554.300 Books, Publ, Subs & Membership 878 1,600 1,800 1,633 1,634 1,600 1,600 Operating Expenditures/Expense 802,870 911,700 1,039,735 775,353 934,157 995,150 996,800 0 AcctClass: 590 ather Financing Sources & Uses 599.100 BudgetCostSavings 0 0 199,950 0 0 Other Financing Sources & Uses 0 0 199,950 0 0 0 0 0 Acct Class: 600 Capital OuBay 664.607 Equipment-Tech 0 0 0 0 0 82,000 Capital0utlay 0 0 0 0 0 82,000 0 0 Water- Production 1,364,681 1,606,450 1,866,385 1,295,266 1,560,541 1,859,900 1,774,150 0 Dept: 243 Water-Distribution Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 388,207 386,500 386,500 324,945 380,400 507,700 394,300 514.100 Overtime 4,191 5,000 5,000 2,897 5,000 5,100 5,100 515.102 Standby Pay 10,820 10,000 10,000 9,456 10,000 10,200 10,200 515.103 Bonus Pay Plan 3,000 0 0 0 0 1,000 1,000 515.106 Clothing & Boot Allowance 500 500 500 500 500 850 500 515.107 Part-6me Salaries 0 0 0 0 0 12,900 515.108 Auto Allowance 0 0 0 0 0 516.100 CompensatedAbsences 2,094 5,000 5,000 4,627 4,627 5,100 5,100 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 23,868 24,900 24,900 20,603 24,900 32,700 25,100 521.102 Medicare Taxes 5,582 5,800 5,800 4,818 5,800 7,700 5,900 522.101 FRS Contributions 10,056 10,700 10,700 9,080 10,700 10,900 10,800 522.102 VOT Pension Contributions 23,026 20,700 20,700 17,298 20,250 27,300 18,800 523.101 Life/Health Insurance 93,972 76,000 76,000 69,599 75,950 122,300 83,100 523.105 HSA - Health Savings Account 0 0 0 0 0 BUDGET WORKSHEET Page: 30 8/19/2015 Village of Tequesta 11:38 am Prior ---------------------- Current Year --------------------------- � � �$) Year Original Amended Actual Thru Esfimated Month:B/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Expenditures Dept: 243 Water-Distribution Acct Class: 510 Personal Services 523.110 Retiree Health Care Expense 4,100 0 0 0 0 524.100 Workers' Comp In'surance 9,087 8,360 8,360 8,352 8,353 8,800 8,200 525.100 Unemployment Compensation 0 0 0 0 0 554.301 Personnel Training 796 1,500 1,500 621 1,500 3,000 3,000 Personal Services 579,299 554,960 554,960 472,796 547,980 755,550 571,100 0 Acct Class: 530 Operating Expenditures/Expense 540.300 Travel & Per Diem 171 500 500 88 500 1,000 1,000 541.300 Communication Services 5,336 6,000 6,000 5,692 6,000 6,000 6,000 541.301 Postage 23,958 23,000 23,000 15,080 23,000 23,000 23,000 544.301 Operating Leases 3,132 3,200 3,200 2,673 3,200 3,200 3,200 546.301 Office Equip/Repair & Maint 276 1,200 700 174 700 1,200 1,200 546.302 Vehicle Repair & Maintenance 6,920 8,500 6,500 2,060 6,500 10,400 10,400 546.303 Building Repair & Maint 985 5,000 5,000 2,069 5,000 6,000 6,000 546.309 Landscape & Irrigation Maint 859 90� 90U 607 900 1,000 1,000 546.310 Equipment Repair & Maint 3,434 5,000 5,000 4,184 5,000 5,000 5,000 546.320 Computer system maint & suppli 5,458 8,400 8,400 7,824 8,400 11,200 12,000 546.342 Water System Maintenance 29,787 35,000 37,000 33,721 37,000 40,000 40,000 547.300 Printing & Binding 2,582 3,000 3,000 2,498 3,000 3,000 3,000 549.300 Other Misc Chgs & Obliga6ons 1,141 2,500 2,500 1,353 2,500 2,500 2,500 549.304 Licenses, Fees & Permits 1,647 1,700 1,700 1,447 1,700 1,700 1,700 551.300 Office Supplies & Equipment 1,970 1,500 2,000 1,692 2,000 1,500 1,500 552.301 Gas & Oil 13,900 14,000 14,000 7,346 14,000 14,000 14,000 552.302 Small Tools and Equipment 3,364 4,000 4,000 2,035 4,000 5,000 5,000 552.305 Uniforms 1,864 2,000 2,000 1,833 2,000 2,000 2,000 Operating Expenditures/Expense 106,784 125,400 125,400 92,376 125,400 137,700 138,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.607 Equipment - Tech 0 0 0 0 0 13,000 CapitalOuNay 0 0 0 0 0 13,000 0 0 Water-Distribution 686,083 680,360 680,360 565,172 673,380 906,250 709,600 0 Dept: 411 Renewal & Replacement Acct Class: 530 Operating Expenditures/Expense 531.302 Engineering Services 0 0 0 0 0 75,000 546.604 R& M- Pump and Motor Rehab 0 0 0 0 0 15,000 546.605 R&M - Well Rehabilitation 3,205 4,000 0 0 0 100,000 100,000 BUDGET WORKSHEET Page: 31 8/19/2015 Village of Tequesta 11:38 am Prior ---------------------- Current Year ------------------- (6) (�) (a) Year Original Amended Actual Thru Esfimated Month:B/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Expenditures Dept: 411 Renewal & Replacement Acct Class: 530 Operating Expenditures/Expense 546.607 R&M - Water Mains 0 0 0 0 0 100,000 546.615 R&M - JIC - Engneering 0 0 75,880 69,348 75,880 93,257 93,300 546.617 R&M - JIC- Construction 0 0 0 0 0 1,245,000 1,245,000 549.671 Misc. Renewal & Replacement 453,757 310,000 406,548 390,496 406,548 1,100,000 115,000 552.601 Meters, Valves & Hydrants 14,470 60,000 60,000 59,157 60,000 125,000 60,000 552.603 Filter Cartridges/ROP 4,213 7,000 7,000 0 7,000 7,000 7,000 552.605 Spare Pumps & Motors 0 0 0 0 0 5,000 5,000 Operating Expenditures/Expense 475,645 381,000 549,428 519,001 549,428 2,865,257 1,625,300 0 Acct Class: 600 Capital OuUay 663.671 Misc. Renewel and Replacement 0 0 0 0 0 664.600 Mach/Equipment 0 25,000 0 0 0 664.601 Computer Equipment 0 0 52,200 1,418 1,418 10,000 664.602 Vehicles 0 136,000 136,000 105,004 136,000 50,000 Capital0utlay 0 161,000 188,200 106,422 137,418 50,000 10,000 0 Renewal& Replacement 475,645 542,000 737,628 625,423 686,846 2,915,257 1,635,300 0 Dept: 700 Debt Service Acct Class: 471 D/S - Principal 571.705 Prin -2004 Water N/P BOA 0 32,000 32,000 32,000 32,000 33,000 33,000 571.720 Prin - 2008 Water U61ity Note 0 287,890 287,890 263,387 287,890 300,400 300,400 D/S - Principal 0 319,890 319,890 295,387 319,890 333,400 333,400 0 Acct Class: 472 D/S - Interest 572.7051nt-2004WaterN/PBOA 13,448 12,600 12,600 7,345 12,600 11,100 11,100 572.720 Int-2008 WaterUtility Note 191,307 191,310 191,310 151,291 191,310 180,800 180,800 573.700 Other Debt Service Costs 22,467 23,000 23,000 0 23,000 23,000 23,000 D/S -interest 227,222 226,910 226,910 158,636 226,910 214,900 214,900 0 Debt Service 227,222 546,800 546,800 454,023 546,800 548,300 548,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 341 0 Other Financing Sources & Uses 0 0 0 341 0 0 0 0 Other Financing Sources & Uses 0 0 0 341 0 0 0 0 Dept: 950 Other Nonoperating Acct Class: 530 Operating Expenditures/Expense 559.300 Deprecia6on 1,059,500 0 0 0 0 559.301 Budgeted Depreciation (netted) 0 565,000 565,000 0 635,040 707,550 707,550 Operating Expenditures/Expense 1,059,500 565,000 565,000 0 635,040 707,550 707,550 0 Acct Ciass: 590 Other Financing Sources & Uses BUDGET WORKSHEET Page: 32 8/19/2015 Village of Tequesta 11:38 am Prior ------------------------ Current Year ---------------------- � ��) �$) Year Original Amended Actual Thru Es6mated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Expenditures Dept: 950 Other Nonoperating Acct Class: 590 Other Financing Sources & Uses 549.391 Bank Charges 10,163 10,000 10,000 9,275 10,000 11,000 11,000 549.395 Credit Card Fees and Charges 6,931 6,500 6,500 7,506 6,700 7,000 7,000 567.000 Gain/Loss on Investrnents 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 - A/P 0 0 0 0 0 OtherFinancing Sources & Uses 17,094 16,500 16,500 16,781 16,700 18,000 18,000 0 Other Nonoperating 1,076,594 581,500 581,500 16,781 651,740 725,550 725,550 0 Dept: 990 OthedReserve/Contingency Acct Class: 590 Other Financing Sources & Uses 599.902 Reserves - Contingency 0 2,700 2,700 0 0 Other Financing Sources & Uses 0 2,700 2,700 0 0 0 0 0 Other/Reserve/Contingency 0 2,700 2,700 0 0 0 0 0 Total Expenditures 4,782,023 4,958,290 5,401,423 3,768,895 5,102,326 7,909,857 6,393,450 0 WaterFund -577,410 0 0 105,902 -721,206 -3,574,647 0 0 BUDGET WORKSHEET Page: 33 8/19/2015 Ullage of Tequesta 11:38 am Prior --------------------- Current Year ------------------------- � ��) �$) Year Original Amended Actual Thru Estimated Month:8131/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 402 - Refuse & Recycling Revenues Dept 000 General Acct Class: 335 Intergovemmental Revenue 338.110 Recycling Shared Rev - SWA 7,747 5,000 5,000 4,579 4,579 5,000 5,000 Intergovernmental Revenue 7,747 5,000 5,000 4,579 4,579 5,000 5,000 0 Acct Class: 340 Charges for Services 343.307 Penalty Charges 1 0 0 0 0 343.400 Refuse l Recycling Fees 473,047 472,245 472,245 469,938 472,245 485,000 485,000 Charges for Services 473,048 472,245 472,245 469,938 472,245 485,000 485,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 22,175 22,175 0 22,175 Other Financing Sources 0 22,175 22,175 0 22,175 0 0 0 General 480,795 499,420 499,420 474,517 498,999 490,000 490,000 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investrnent Eamin 361.100 Interest/Investment Earnings 171 175 175 106 105 361.101 PBC Tax Col-Interest on Dep 10 0 0 13 13 367.100 Net Unreal appreciation (Dep) 200 200 200 0 0 Unrestricted Investment Eamin 381 375 375 119 118 0 0 0 Other Nonoperating 381 375 375 119 118 0 0 0 Total Revenues 481,176 499,795 499,795 474,636 499,117 490,000 490,000 0 Expenditures Dept: 245 Refuse and Recycling Acct Class: 530 Opera6ng Expenditures/Expense 531.301 Legal Services 0 0 0 0 0 543.302 Solid Waste/Residential 251,727 257,810 257,810 214,838 257,810 256,830 256,830 543.303 Recycling/Residenfial 89,025 91,310 91,310 76,089 91,310 90,960 90,960 543.304 Yard Waste/Residential 83,653 85,555 85,555 71,293 85,555 84,530 84,530 543.305 PBC Tax Col Fees & Discounts 0 0 0 0 0 543.306 FuelFactor 58,327 57,550 57,550 47,955 57,550 49,640 49,640 549.300 Other Misc Chgs & Obliga6ons 190 300 300 190 300 590 590 549.301 Admin Mgmt Fees 7,055 7,270 7,270 6,058 7,270 7,450 7,450 Operating Expenditures/Expense 489,977 499,795 499,795 416,423 499,795 490,000 490,000 0 Refuse and Recycling 489,977 499,795 499,795 416,423 499,795 490,000 490,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 Page: 34 8/1912015 �Ilage of Tequesta 11:38 am Prior --�—�--�-----�---- Current Year -----�--------�—�-� (6) (7) (8) Year Original Amended Actual Thru Estimated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 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 310 0 Other Financing Sources & Uses 0 0 0 310 0 0 0 0 Other Financing Sources & Uses 0 0 0 310 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 Financing Sources & Uses 0 0 0 0 0 0 0 0 Other Nonoperating 0 0 0 0 0 0 0 0 TotalExpenditures 489,977 499,795 499,795 416,733 499,795 490,000 490,000 0 Refuse & Recyciing -8,801 0 0 57,903 -678 0 0 0 BUDGET WORKSHEET Page: 35 8/19/2015 Village of Tequesta 11:38 am Prior --------------------- Current Year ------------------ �s) �7) �$) Year Original Amended Actual Thru Es6mated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 403 - Stortnwater Utility Revenues Dept: 000 General Acct Class: 340 Charges for Services 343.901 Storm Water Utility Fees 323,363 318,000 318,000 318,107 318,107 325,000 325,000 ChargesforServices 323,363 318,000 318,000 318,107 318,107 325,000 325,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 General 323,363 318,000 318,000 318,107 318,107 325,000 325,000 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investrnent Eamin 361.1001nterest(InvestmentEarnings 1,026 1,100 1,100 857 1,000 1,000 1,000 361.101 PBC Tax Col-Interest on Dep 7 0 0 9 9 367.100 Net Unreal appreciafion (Dep) 228 0 0 0 0 Unrestricted Inuestment Eamin 1,261 1,100 1,100 866 1,009 1,000 1,000 0 Other Nonoperating 1,261 1,100 1,100 866 1,009 1,000 1,000 0 Dept: 990 OthedReserve/Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 146,200 168,200 0 0 231,550 Other Financing Sources 0 146,200 168,200 0 0 0 231,550 0 Other/Reserve/Con6ngency 0 146,200 168,200 0 0 0 231,550 0 Total Revenues 324,624 465,300 487,300 318,973 319,116 326,000 557,550 0 Expenditures Dept: 250 Stortn Water Utilities Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 59,366 59,200 58,200 48,605 58,200 173,900 91,300 514.100 Overtime 457 1,000 1,000 572 1,000 1,000 1,000 515.102 Standby Pay 1,543 2,000 2,000 1,561 2,000 2,000 2,000 515.103 Bonus Pay Plan 1,500 0 0 0 0 250 515.106 Clothing & Boot Allowance 150 150 150 150 150 400 250 515.108 AutoAllowance 1,800 450 425 0 0 750 516.100 Compensated Absences 371 0 2,694 2,694 2,694 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 3,665 3,800 3,800 3,071 3,800 10,500 5,600 521.102 Medicare Taxes 857 900 900 718 900 2,500 1,300 522,102 VOT Pension Contributions 5,290 5,000 5,000 4,059 4,955 13,100 6,900 523.101 Life/Health Insurance � 17,339 12,000 10,900 10,340 10,894 55,100 28,600 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 2,799 1,950 1,950 1,946 1,946 2,050 1,050 BUDGET WORKSHEET Page: 36 8/19I2015 Village of Tequesta 11:38 am Prior ---------------------- Current Year --__---------------- � ��) � Year Original Amended Actual Thru Estimated Monih:8131/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 403 - Stormwater Utility Expenditures Dept: 250 Stortn Water Utilities Acct Class: 510 Personal Services 526.102 Employee Assistance Program 0 0 25 11 25 300 300 554.301 Personnel Training 0 0 0 0 0 Persona{ Services 95,937 86,450 87,044 73,727 86,564 261,100 139,050 0 Acct Class: 530 Operating Expenditures/Expense 531.302 Engineering Services 26,303 4,500 16,500 14,094 17,295 50,000 50,000 532.30� Acxounting & Auditing Services 3,885 4,010 4,010 4,006 4,006 4,100 4,100 534.300 Other Contractual Services 1,540 0 0 0 0 50,000 50,000 540.300 Travel & Per Diem 0 0 0 0 0 541.300 Communication Services 1,637 1,900 1,900 1,688 1,900 1,900 1,900 541.301 Postage 0 300 300 0 300 1,100 1,100 545.3001nsurance 0 0 0 0 0 546.302 Vehicle Repair & Maintenance 1,412 2,000 2,000 687 2,000 2,000 2,000 546.303 Building Repair & Maint 199 2,000 1,406 0 1,406 2,000 2,000 546.308 Drainage Maintenance 19,424 11,200 22,700 12,568 22,700 35,000 A2,300 546.310 Equipment Repair & Maint 1,446 2,500 2,500 1,904 2,500 2,500 2,500 546.320 Computer system maint & suppli 325 750 750 291 750 1,500 1,750 549.300 Other Misc Chgs & Obligations 503 1,000 1,000 796 1,000 1,000 1,000 549.301 Admin Mgmt Fees 11,978 12,340 12,340 10,283 12,340 12,400 12,400 549.304 Licenses, Fees & Permits 4,099 4,500 4,500 3,936 4,500 4,500 4,500 551.300 Office Supplies & Equipment 300 300 300 232 300 300 300 552.301 Gas & Oil 2,056 2,700 2,700 1,256 2,500 2,700 2,700 552.302 Small Tools and Equipment 823 7,500 5,329 3,536 5,329 7,500 7,500 554.100 Public Education Program 0 250 250 0 250 1,000 1,000 Operating Expenditures/Expense 75,930 57,750 78,485 55,277 79,076 179,500 187,050 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 7,620 0 0 Other Financing Sources & Uses 0 0 7,620 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 MachlEquipment 0 15,000 7,380 7,379 7,379 664.602 Vehicles 0 0 0 0 0 664.607 Equipment - Tech 0 0 0 0 0 Capital0utlay 0 15,000 7,350 7,379 7,379 0 0 0 Storm Water Ufilities 171,867 159,200 180,529 136,383 173,019 440,600 326,100 0 Dept: 411 Renewal & Replacement Acct Class: 530 Operating Expenditures/Expense BUDGET WORKSHEET Page: 37 8/19/2015 Village of Tequesta 11:38 am Prior ----------°------- Current Year --------------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:8/31/2015 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 403 - Stortnwater Utility Expenditures Dept 411 Renewal & Replacement Acct Class: 530 Opera6ng Expenditures/Expense 531.302 Engineering Services 0 16,000 16,671 12,670 26,671 20,000 20,000 546.308 Drainage Maintenance 0 0 0 0 50,000 100,000 100,000 546.319 S.Cypress rear alleyway improv 0 83,000 83,000 0 83,000 546.321 Budget Alleyway Improvements 0 23,000 23,000 0 23,000 546.322 Seabrook Stormwater Imprvmnts 0 183,800 183,800 0 183,800 Operating Expenditures/Expense 0 305,800 306,471 12,670 366,471 120,000 120,000 0 Renewal & Replacement 0 305,800 306,471 12,670 366,471 120,000 120,000 0 Dept: 910 Other Financing Sources & Uses Acct Class: 590 Other Financing Sources & Uses 567.100 Unrealized Loss on Investments 0 0 0 541 0 Other Financing Sources & Uses 0 0 0 541 0 0 0 0 Other Financing Sources & Uses 0 0 0 541 0 0 0 0 Dept: 950 Other Nonoperating Acct Class: 530 OperaGng Expenditures/Expense 559.300 Depreciation 107,186 0 0 0 0 559.301 Budgeted Depreciation(netted) 0 0 0 0 101,045 111,450 111,450 Operating Expenditures/Expense 107,186 0 0 0 101,045 111,450 111,450 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 OtherNonoperating 107,186 0 0 0 101,045 111,450 111,450 0 Dept: 990 OthedReserve/Contingency Acct Class: 590 Other Financing Sources & Uses 599.902 Reserves-Con6ngency 0 300 300 0 0 Other Financing Sources & Uses 0 300 300 0 0 0 0 0 OthedReserve/Confingency 0 300 300 0 0 0 0 0 TotalExpenditures 279,053 465,300 487,300 149,594 640,535 672,050 557,550 0 Stormwater Utility 45,571 0 0 169,379 -321,419 -346,050 0 0 GrandTotal: -728,275 0 0 1,390,991 -787,908 -4,497,107 0 0