Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Documentation_Special Meeting_Tab 03_08/22/2012
� MEMORAND UM FIN �NCE DEP �RT'�fE'�T DATE: AUGUST 20, 2012 TO: MICHAEL R. COUZZO, VILLAGE MANAGER FROM: JOANN FORSYTHE, FINANCE DIRECTOR RE: CHANGES IN 2012-2013 PROPOSED BUDGET RESULTING FROM JULY 9 STRATEGIC PLANNING MEETING Below are changes to the proposed 2012-2013 budget that resulted from the July 9` Village Council Strategic Planning Meeting. The changes were presented to the finance department by the Village Manager and the Village Clerk. Additionally, Council Brennan, reviewed the Village Council budget column and discussed changes with the Village Manager. The list below represents the accumulation of these changes. General Fund #001 Revenues Department Manager Council Dept 192 Fire: 1. 342.410 - Em. Svc -PBC Fire Rescue 168,000 183,120 183,120 2. 342-600 - EMS Transport Fees 278,500 288,000 288,000 Dept 900 Inter-fund Transfers 1. 381.301 - Tfr. in from Cap Improvement 290,440 0 2. 381.303 " " Capital Projects 112,000 0 3. 381.605 " " Sp. Law Enf. Trust 50,000 0 Expenditures Department Mana�er Council Dept 120 Villa e Clerk l. Codification Services 5,650 5,650 7,650 2. Legal Advertising 21,200 14,000 19,000 Dept 150 Comp Planning 1. 531.321 Mapping Services 0 0 2,500 � � g,�2,�24:�2 PM � �a..-� a 2. Exvenditures (Cont'an Deuartment Mana�er Council Dept 175 — Police 1. 515.107 Part Time Salaries 0 32,900 0 2. 521.101 FICA 105,000 104,700 102,24U 3. 521.102 Medicare 24,600 24,500 23,900 Dent 180 — Building & Zoning 1. 531325 Inspection Services 91,000 91,000 113;OU0 2. 546320 Computer Systems etc. 5,200 4,000 5,200 3. 551300 Office Supplies & Equipment 1,440 1,440 2,540 Dept 192 Fire Control 1. 546.302 Vehicle Repair & Maint 42,970 9,500 9,500 2. 552.301 Gas & Oil 22,270 22,270 20,000 Dept 210 — Public Warks 1. 515107 — Part Time Salaries 0 25,200 18,900 2. 521.101 — FICA 12,000 12,100 11,700 Confidential 2 BUDGET WORKSHEET Wednesday,August22,2012 Page: 1 812212012 �Ilage of Tequesta 2:55 pm Prior ---------------------- Current Year ------------------ (s) (7) (8) Year Original Amended Actual Thru Estimated Month:9130/2012 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 4,338,395 4,266,000 4,266,000 4,254,037 4,254,037 4,340,630 4,372,000 4,372,000 311,100 Ad Valorem Taxes-Del 3,273 5,000 5,000 8,861 9,000 5,000 5,000 5,000 GeneralPropertyTaxes 4,341,668 4,271,000 4,271,000 4,262,898 4,263,037 4,345,630 4,377,000 4,377,000 Acct Class: 316 Sales & Use Taxes 314.100 Utility Tax-Electricity 434,553 405,000 405,000 349,595 420,000 416,000 416,000 416,000 314.300 Udlity Tax-Water 165,249 150,000 150,000 132,755 156,000 154,000 154,000 154,000 314.800 Utiliry Tax-Propane 32,552 27,0�0 27,000 24,009 28,000 28,000 28,000 28,000 315.000 Comm.Services Tax (CST) 364,673 364,000 364,000 289,029 363,800 354,600 354,600 354,600 321.000 Local Business Tax (Occ Lic) 74,750 74,000 74,000 73,761 74,000 71,000 71,000 71,000 321.001 Home Business Tax 3,030 3,000 3,000 4,585 4,600 4,600 4,600 4,600 321.010 Local Business Tax - County 8,553 4,500 4,500 7,269 7,269 4,500 4,500 4,500 Sales & Use Taxes 1,083,360 1,027,500 1,027,500 881,003 1,053,669 1,032,700 1,032,700 1,032,700 Acct Class: 318 Franchise fees - gross receipt 313.100 Fran Fees-Electric 412,441 390,000 390,000 288,612 391,800 393,600 401,400 401,400 Franchise fees - gross receipt 412,441 390,000 390,000 288,612 391,800 393,600 401,400 401,400 Acct Class: 329 Inhagovemmental Revenue 341.401 Admin Mgmt Fees-Water 305,700 316,725 316,725 263,938 316,725 326,230 326,230 326,?30 341.402 Admin Mgmt Fee-Ref & Recycling 6,450 6,644 6,644 5,537 6,644 6,850 6,850 6,850 341.403 Admin Mgmt Fees- Storm Water 10,960 11,290 11,290 9,408 11,290 11,630 11,630 11,630 Intragovemmental Revenue 323,110 334,659 334,659 278,883 334,659 344,710 344,710 344,710 Acct Class: 335 Intergovemmental Revenue 335.120 State Revenue Sharing Proceeds 172,265 173,000 173,000 144,755 172,000 173,000 173,000 173,000 335.150 Alcoholic Beverage Licenses 6,115 5,700 5,700 5,331 5,331 5,000 5,000 5,000 335.180 Local Govt Half-Cent Sales Tax 374,814 366,800 366,800 283,911 367,350 370,000 370,000 370,000 338.101 Local Gas Tax-6 Cent 110,950 113,000 113,000 89,021 116,500 116,500 116,500 116,500 338.102 Local Gas Tax 1-5 Cent 51,790 52,000 52,000 41,871 54,200 54,500 54,500 54,500 338.110 Recycling Shared Rev - SWA 0 12,000 12,000 0 0 Intergovemmental Revenue 715,934 722,500 722,500 564,889 715,381 719,000 719,000 719,000 Acct Class: 341 Chgs for Serv - Gen Gov 341.101 CertificationlCopy Fees 8,172 8,000 8,000 9,155 10,000 8,000 8,000 8,000 341.103 Election qualifying fees 60 150 150 90 90 150 150 150 341.105 Admin fees from other Gov'ts 3,329 500 500 4,034 4,100 500 500 500 Chgs for Serv- Gen Gov 11,561 8,650 8,650 13,279 14,190 8,650 8,650 8,650 Acct Class: 361 Unrestricted Investrnent Earnin 361.100 InteresUlnvestment Earnings 32,228 16,000 16,000 10,153 12,000 10,000 10,000 10,000 361.101 PBC Tax Col-Interest on Dep 547 0 0 2,132 2,132 500 5�0 500 Unrestricted Investment Earnin 32,775 16,000 16,000 12,285 14,132 10,500 10,500 10,500 Acct Class: 362 Rents & Royal6es BUDGET WORKSHEET Wednesday, August 22, 2012 Page: 2 812212012 Ullage of Tequesta 2:55 pm Prior ---------------------- Current Year ------------------- (6) C/) (8) Year Original Amended Actual Thru Estimated Month:9130/2012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Revenues Dept: 000 General Acct Class: 362 Rents & Royalties 362.100 Rental - Faalities 3,407 4,000 4,000 0 0 362.110 Lease - Sprint 32,105 32,250 32,250 27,895 33,270 34,260 34,260 34,260 362.112 Lease-T-Mobile 45,513 46,970 46,970 39,084 46,971 48,850 48,850 48,850 362.115 Lease - Nextel 47,086 48,970 48,970 40,635 48,960 26,940 26,940 26,940 362.116 Lease - AT&T 30,000 30,000 30,000 27,500 30,000 30,000 30,000 30,000 Rents & Royalties 158,111 162,190 162,190 135,114 159,201 140,050 140,050 140,050 Acct Class: 366 ConUibu6ons & Donations 366.120 Donation - Fountain of Honor 360 0 0 0 0 Conhibutions & Donafions 360 0 0 0 0 0 0 0 Acct Class: 369 Miscellaneous Revenues 364.100 Disposi6on of Fixed Assets 0 5,000 5,000 0 0 369.000 Other Miscellaneous Revenue 158 500 500 20,505 20,500 500 500 500 369.100 Insurance Reimbursement 22,642 19,000 19,000 17,422 17,422 15,000 15,000 15,000 Miscellaneous Revenues 22,800 24,500 24,5U0 37,927 37,922 15,50Q 15,500 15,500 General 7,102,120 6,956,999 6,956,999 6,474,890 6,983,991 7,010,340 7,049,510 7,049,510 Dept 150 Comprehensive Planning Acct Class: 340 Charges for Services 341.150 Land Development Fees 0 0 64,000 62,018 64,000 45,000 45,000 45,000 342.501 Site Plan Review Fees 10,775 10,000 0 0 0 342.502 Planning & Zoning Fees 71,131 54,000 0 0 0 343.700 Water Conservation & Resource 472 100 100 661 700 Charges for Services 82,378 64,100 64,100 62,679 64,700 45,000 45,000 45,000 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 99 200 200 0 200 200 200 200 Miscellaneous Revenues 99 200 200 0 200 200 200 200 Comprehensive Planning 82,477 64,300 64,300 62,679 64,900 45,200 45,200 45,200 Dept: 171 Police Acct Glass: 316 Sales & Use Taxes 312.520 Casualty Insurance Premium Tax 54,983 0 0 0 56,466 56,470 56,470 Sales 8 Use Taxes 54,983 0 0 0 56,466 0 56,470 56,470 Acct Class: 320 Licenses & Permits 329.101 Alarm Permits 5,040 5,400 5,400 5,540 5,600 5,600 5,600 5,600 329.102 Special Truck Permits 60 0 0 53 53 329.105 Golf Cart Pertnits 1,050 700 700 0 700 700 700 700 Licenses 8 Permits 6,150 6,100 6,100 5,593 6,353 6,300 6,300 6,300 Acct Class: 334 Grants - State 334.201 State Police Block Grant 423 0 0 0 0 Grants - State 423 0 0 0 0 0 0 0 BUDGET WORKSHEET Wednesday,August22,2�12 Page: 3 812212012 �Ilage of Tequesta 2:55 pm Prior ----------------------- Current Year ------------------- (6) (71 (8) Year Original Amended Actual Thru Estimated Month:9136I2012 Actual Budget Budget September Tota1 DEPARTMENT MANAGER COUNCVL Fund: 001 - General Fund Revenues Dept: 171 Police Acct Class: 335 Intergovernmental Revenue 338201 PBC 911 Maint Reim6ursement 8,466 12,000 12,000 0 9,750 8,100 8,100 8,100 338.202 PBC 911 DISPATCH REIMBURSEMENT 20,161 26,000 26,000 31,274 32,000 13,750 13,750 13,750 Intergovernmental Revenue 28,627 38,000 38,000 31,274 41,750 21,850 21,850 21,850 Acct Class: 342 Chgs for Serv - Public Safety 342.110 PBC - Marine law enforce. serv 19,906 20,000 20,000 15,000 15,000 20,000 20,000 20,000 Chgs for Serv - Public Safety 19,906 20,000 20,000 15,000 15,000 20,000 20,000 20,000 Acct Class: 351 Fines & Forfeitures 351.100 CourtFines 16,497 10,000 10,000 11,272 14,000 10,000 10,000 10,000 354.101 Parking Tickets 1,065 800 800 710 800 800 800 800 354.102 Code Enf Fines & Court Costs 186,711 10,000 10,000 6,436 10,000 10,000 10,000 10,000 Fines & Forfeitures 204,273 20,800 20,800 18,418 24,800 2�,800 20,800 20,800 Acct Class: 363 Impact Fees 362221 Police Impact Fees 3,907 350 350 10,975 11,000 ImpactFees 3,907 350 350 10,975 11,000 0 0 0 Acct Class: 366 Contributions � Donations 366.100 ConVib & Donations & Sponsors 100 100 100 250 250 ConVibutions & Dona6ons 100 100 100 250 250 0 0 0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 0 0 0 450 450 Miscellaneous Revenues 0 0 0 450 450 0 0 0 Police 318,369 B5,350 B5,350 81,960 156,069 68,950 125,420 125,420 Dept: 175 Police Department Acct Class: 369 Miscellaneous Revenues 359.100 Forfeitures/Confiscations 2,414 0 0 59 59 Miscellaneous Revenues 2,414 0 0 59 59 0 0 0 Police Department 2,414 0 0 59 59 0 0 0 Dept: 180 Building 8 Zoning Acct Class: 320 Licenses & Permits 322.000 Building Permit Fees 308,977 464,350 464,350 364,150 365,000 300,000 300,000 300,000 329.000 Contractors Registration 11,106 9,750 9,750 9,779 9,800 9,75Q 9,750 9,750 329.010 Contractor Reg. - Counry 6,680 4,000 4,000 5,713 6,000 6,000 6,000 6,000 Licenses 8 Permits 326,763 478,100 478,100 379,642 380,800 315,750 315,750 315,750 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 41 0 0 243 243 Miscellaneous Revenues 41 0 0 243 243 0 0 0 Building 8 Zoning 326,804 478,100 478,100 379,885 381,043 315,750 315,750 315,750 Dept: 192 Fire Conhol Acct Glass: 316 Sales & Use Ta�ces 312.510 Fire Insurance Prem Tax 128,337 137,000 137,000 0 154,707 137,000 137,000 137,000 BUDGET WORKSHEET Wednesday, August 22, 2012 Page: 4 812212012 Village of Tequesta 2:55 pm Prior ------------------- Current Year ------------------ (6) (�l ( Year Original Amended Actual Thru Estimated Month:9130/2012 Actual Budget Budget September 7otal DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Revenues Dept: 192 Fire Control Sales & Use Taxes 128,337 137,000 137,000 0 154,707 137,000 137,000 137,000 Acct Class: 335 Intergovemmental Revenue 335.201 Fire Incentive Pay 6,240 6,840 6,840 4,680 6,840 6,840 6,840 6,840 Intergovemmental Revenue 6,240 6,840 6,840 4,680 6,840 6,840 6,840 6,840 Acct Class: 340 Charges for Services 342.192 Fire - Extra Duty 241 500 500 162 350 500 500 500 342.201 Fire Plan Review Fees 19,213 21,000 21,000 63,261 63,500 26,000 26,000 26,000 342.202 Fire Inspections 26,310 24,740 24,740 20,700 23,500 24,740 24,740 24,740 342.401 Emergency Service-JIC 210,725 216,600 216,600 218,217 218,217 223,100 223,100 223,100 342.410 Emergency Svc- PBC Fire Rescue 168,000 168,000 168,000 126,000 168,000 168,000 183,120 183,120 342.600 EMS Transportation Fees 276,395 276,000 276,000 263,484 275,100 278,500 288,OQ0 288,000 342.950 Allow for doubtful rev- GovFnd 0 0 0 0 0 Charges for Services 700,884 706,840 706,840 691,824 748,667 720,840 745,460 745,460 Acct Class: 342 Chgs for Serv - Public Safety 342.402 Fire Rescue-CPR Program 0 700 700 45 350 700 700 700 Chgs for Serv - Public Safery 0 700 700 45 350 700 700 700 Acct Class: 363 Impact Fees 362.222 Fire Impact Fees 536 500 500 6,731 6,750 500 500 500 Ympact Fees 536 500 500 6,731 6,750 500 500 500 Acct Class: 366 Contributions & Donations 366.100 Contrib & Donations 8 Sponsors 276 1,000 1,000 200 800 1,000 1,000 1,000 Contributions & Dona6ons 276 1,000 1,000 200 800 1,000 1,000 1,000 Acct Class: 369 Miscellaneous Revenues 365.102 Fire Dept Sales 14 100 100 17 25 100 100 100 365.350 Fire Mark Revenue 130 0 0 0 0 369.000 Other Miscellaneous Revenue 11,898 500 500 799 1,200 600 600 600 Miscellaneous Revenues 12,042 600 600 816 1,225 700 700 700 Fire Control 848,315 853,480 853,480 704,296 919,339 867,580 892,200 892,200 Dept: 231 Leisure Services Acct Class: 347 Charges for Services - Recr. 347.100 Tequesta Fest 19,738 20,000 20,000 18,526 18,526 20,000 20,000 20,000 347.190 Special Events - Other 3,953 5,000 5,000 7,673 7,673 5,000 5,000 5,000 347.201 Spring ISummer Camp Fees 42,295 52,900 52,900 33,284 33,284 52,900 52,900 52,900 347.205 Recreation Programs Fees 7,925 8,000 8,000 6,432 7,000 6,000 6,000 6,000 Charges for Services - Recr. 73,911 85,900 85,900 65,915 66,483 83,900 83,900 83,900 Acct Class: 362 Rents & Royalties 362.10D Rental - Facilities 4,541 3,000 3,000 6,241 6,500 3,000 3,000 3,000 Rents 8 Royalties 4,541 3,000 3,000 6,241 6,500 3,000 3,000 3,000 Acct Class: 363 Impact Fees BUDGET WORKSHEET Wednesday, August 22, 2012 Page: 5 812212012 Village oi Tequesta 2:55 pm Prior -----_---------- Current Year ------------------ �6) (�) �8) Year Original Amended Actual Thru Estimated Month:913012012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Revenues Oept: 231 Leisure Services Acct Class: 363 Impact Fees 363.271 Parks and Rec Impact Fees 551 0 0 551 560 ImpactFees 551 0 0 551 560 0 0 0 Acct Class: 366 Contributions 8 Donations 366.100 Contrib 8 Donations & Sponsors 6,270 7,000 7,000 6,294 6,294 7,000 7,000 7,000 Gonhibutions & Donations 6,270 7,000 7,000 6,294 6,294 7,000 7,000 7,000 Acct Class: 3fi9 Miscellaneous Revenues 365.110 Concession Sales 4,044 7,000 7,000 4,748 4,748 5,000 5,000 5,000 369.000 Other Miscellaneous Revenue 40 0 0 0 0 Miscellaneous Revenues 4,084 7,000 7,000 4,748 4,748 5,000 5,000 5,000 Leisure Services 89,357 102,900 102,900 83,749 84,585 98,900 98,900 98,900 Dept: 900 Interfund Transfers Acct Class: 391 Transfers In 381.301 Transfer-In from Cap Improvemn 250,000 201,300 201,300 201,300 201,300 290,440 381.303 Tsfer-In from Capital Projects 0 0 0 0 0 112,000 381.605 Tfr In - Special law Enf Trust 0 50,000 50,000 0 50,000 50,000 Transfersln 250,000 251,300 251,300 201,300 251,300 0 452,440 0 Interfund Transfers 250,000 251,300 251,300 201,300 251,300 0 452,440 0 Dept: 910 Other Financing Sources � Uses Acct Class: 390 Other Financing Sources 383.100 Capital Lease at lnception 0 120,870 120,870 120,870 120,870 Other Financing Sources 0 120,870 120,870 120,870 120,870 0 0 0 OtherFinaoang Sources & Uses 0 120,870 120,870 120,870 120,870 0 0 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investment Earnin 367.100 Net Unreal appreciation (Dep) 0 15,000 15,000 15,789 15,000 15,000 15,000 15,000 UnresUicted Investrnent Eamin 0 15,000 15,000 15,789 15,000 15,000 15,000 15,000 Other Nonoperating 0 15,000 15,000 15,789 15,000 15,000 15,000 15,000 Dept: 990 OtherlReserve/Contingency Acct Class: 390 Other Financing Sources 399.995 Appropriate FB - SmartCop 0 0 0 0 0 399.999 Appropriate Fund Balance 0 338,260 476,661 0 610,748 433,540 Other Financing Sources 0 338,260 476,661 0 610,748 0 433,540 0 Other(ReseNelCa�6ngency 0 338,260 478,661 0 610,748 0 433,540 0 Total Revenues 9,019,856 9,266,559 9,404,960 8,125,477 9,587,904 8,421,720 9,427,960 8,541,980 Expenditures Dept: 100 Council Acct Class: 530 Operating Expenditures/Expense 531.311 Council Fees-Arena 3,000 3,000 3,000 2,750 3,000 3,000 3,000 3,000 BUDGET WORKSHEET Wednesday, August 22, 2012 Page: 6 812212012 Village of Tequesta 2:55 pm Prior -------------------- Current Year -------_--------- �6) (7) (8) Year Original Amended Actual Thru Estimated Month:9/3012012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001- General Fund Expenditures Dept: 100 Council Acct Class: 530 Operating Expenditures/Expense 531.312 CouncilFees-Tumquest 3,000 3,000 1,625 1,625 1,625 531.313 Council fees - T. Patemo 3,000 3,000 3,000 2,750 3,000 3,000 3,000 3,000 531.314 Council fees - F. D'Ambra 0 0 1,375 1,125 1,375 3,000 3,000 3,000 531.315 CouncilFees-Humpage 3,000 3,000 1,625 1,625 1,625 531.316 Council fees - S. Okun 0 0 1,375 1,125 1,375 3,000 3,000 3,000 531.317 Council Fees - Brennan 3,000 3,000 3,000 2,750 3,000 3,000 3,000 3,000 540.301 Council E�cpenses-Arena 0 1,500 900 89 900 1,500 1,500 1,500 540.302 Council Expenses - Tumquest 2,242 1,500 834 834 834 540.304 Council Expense - F. D'Ambra 0 0 366 44 366 1,500 1,500 1,500 540.305 Council Ezpenses - Humpage 21 1,500 0 0 0 540.306 Council Expense - S. Okun 0 0 900 88 900 1,500 1,500 1,500 540.307 CouncilExpenses-Brennan 1,733 1,500 1,200 434 1,200 1,500 1,500 1,500 540.308 CouncilExpenses- Patemo 14 1,500 1,200 538 1,200 1,500 1,500 1,500 549.300 Other Misc Chgs & Obligations 1,299 1,500 1,500 1,360 1,500 1,000 1,000 1,000 549.350 Volunteer Appreciation 0 800 800 337 800 800 800 800 552.302 Small Tools and Equipment 214 750 750 4,460 4,460 750 750 750 554.300 Books, Publ, Subs 8 Membership 3,013 3,400 3,400 2,995 3,400 3,400 3,400 3,400 582.800 Aid to Community Organizations 0 0 1,600 1,600 1,600 582.801 Aid to Com.Org - Arena 500 0 600 600 600 582.802 Aid to Cam.Org - Turnquest 500 0 300 300 300 582.805 Aid to Com. Org - Humpage 0 0 600 600 600 582.807 Aid to Com. Org. - Brennan 0 0 300 300 300 582.808 Aid to Com. Org. - Patemo 0 0 300 300 300 Operating Expenditures/Expense 24,536 28,950 30,550 28,629 34,260 28,450 28,450 28,450 Council 24,536 28,950 30,550 28,629 34,260 28,450 28,450 28,450 Dept: 110 Manager Acct Class: 510 Personal Senrices 512.100 Regular Salaries & Wages 120,660 124,900 124,900 107,732 124,752 129,600 129,600 129,600 515.103 Bonus Pay Plan 1,250 0 5,000 5,000 5,000 515.104 Sick Leave Conversion Pay 3,553 0 0 0 0 515.108 Auto Allowance 3,000 3,000 3,000 2,750 3,000 3,000 3,000 3,000 516.100 Compensated Absences 0 4,800 4,800 0 3,100 4,500 4,500 4,500 521.101 FICA Taxes 5,810 6,600 6,600 5,524 5,860 6,400 6,500 6,500 521.102 MedicareTaxes 1,920 2,000 2,000 1,691 2,000 1,900 2,000 2,000 522.102 VOT Pension Contributions 11,229 11,700 11,700 10,023 11,615 12,200 12,200 12,200 523.101 LifelHealth Insurance 22,704 24,500 24,500 22,248 24,055 24,500 22,800 22,800 524.100 Workers' Comp Insurance 286 330 330 322 322 330 380 330 BUDGET WORKSHEET Wednesday, August 22, 2012 Page: 7 812212012 Village of Tequesta 2:55 pm Prior ---------------------- Current Year ------------------- (6) (�) (8) Year Original Amended Actual Thru Estimated Month:913012012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001- General Fund Expenditures Dept: 110 Manager Acct Class: 510 Personal Services 526.104 ICMA-Def Comp Plan 9,085 9,500 9,500 8,145 9,440 9,900 9,900 9,900 554.301 Personnel Training 0 500 433 179 433 750 750 750 Personal Services 179,497 187,830 192,763 163,614 189,577 193,080 191,630 191,580 Acct Class: 530 Operating Expenditures/Expense 540.300 Travel & Per Diem 0 1,500 750 383 750 1,500 1,500 1,500 546.320 Computer system maint & suppli 0 500 226 0 226 500 500 500 549.300 Other Misc Chgs & Obligations 58 250 250 45 250 250 250 250 554.300 Books, Publ, Subs & Membership 2,292 2,350 2,410 2,444 2,444 2,650 2,650 2,650 Operating ExpenditureslExpense 2,350 4,600 3,636 2,872 3,670 4,900 4,900 4,900 Acct Class: 600 Capital OuUay 664.601 ComputerEquipment 0 0 1,031 1,031 1,031 CapitalOuUay 0 0 1,031 1,031 1,031 0 0 0 Manager 181,847 192,430 197,430 167,517 194,278 197,980 196,530 196,480 Dept: 111 Human Resources Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 75,033 77,300 77,300 66,625 77,200 79,800 79,800 79,&00 515.107 Part-time Salaries 27,030 29,300 28,540 24,157 28,540 30,300 30,300 30,300 516.100 Compensated Absences 553 0 2,685 2,684 2,684 2,000 2,000 2,000 521.101 FICA Taxes 6,295 6,700 6,700 5,666 6,600 7,000 7,000 7,000 521.102 MedicareTaxes 1,472 1,600 1,600 1,325 1,560 1,700 1,700 1,700 522.102 VOT Pension Contribu6ons 7,053 7,300 7,300 6,263 7,260 7,600 7,600 7,600 523.101 LifelHealU� Insurance 6,550 6,900 6,920 6,367 6,911 7,000 7,200 7,200 524.100 Workers' Comp Insurance 251 290 290 281 281 290 330 290 526.101 Employee Recognition Program 6,061 5,500 6,400 6,360 6,400 5,500 5,500 5,500 526.102 Employee Assistance Program 3,461 3,800 3,800 3,406 3,406 3,800 3,800 3,800 554.301 Personnel Training 2,048 3,000 2,000 1,310 2,000 3,000 3,000 3,000 554.310 Employee Development 2,452 2,000 1,108 1,100 1,100 2,000 2,000 2,000 PersonalServices 138,259 143,690 144,643 125,544 143,942 149,990 150,230 150,190 Acct Class: 530 Operating Expenditures/Expense 534.300 Other Contractual Services 0 0 4,500 0 4,500 540.300 Travel & Per Diem 1,407 1,500 1,500 1,176 1,500 1,500 1,500 1,500 546.320 Computer system maint & suppli 348 500 500 296 500 1,700 1,700 1,700 547.300 Prin6ng & Binding 1,245 500 500 387 500 1,500 1,500 1,500 549.300 Other Misc Chgs & Obligations 342 500 447 389 447 500 500 500 549.401 Recruitmentexpenses 421 500 500 457 500 500 500 500 552.302 Small Tools and Equipment 167 500 500 226 500 500 500 500 554.300 Books, Publ, Subs & Membership 449 500 500 508 500 500 500 500 BUDGET WORKSHEET Wednesday,August22,2012 Page: 8 8/2212012 �Ilage of Tequesta 2:55 pm Prior --------------------- Current Year ----------------- ls) �7) �8) Year Original Amended Actual Thru Estimated Month:913012012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 111 Human Resources Operating Expenditures/Expense 4,379 4,500 8,947 3,439 8,947 6,700 6,700 6,700 Acct Class: 600 Capital Outlay 664.601 ComputerEquipment 1,341 0 0 0 0 Capital0utlay 1,341 0 0 0 0 0 0 0 Human Resources 143,979 148,190 153,590 128,983 152,889 156,690 156,930 156,890 Dept: 120 Village Clerk Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 103,334 106,500 106,500 91,754 106,312 109,800 109,800 109,800 515.120 Cell phone allowance 0 0 325 325 325 521.101 FICA Taxes 5,924 6,600 6,600 5,188 6,015 6,700 6,800 6,800 521.102 MedicareTaxes 1,386 1,600 1,600 1,213 1,410 1,600 1,600 1,600 522.102 VOT Pension Contributions 9,713 10,100 10,100 8,625 9,995 10,400 10,400 10,400 523.101 Life/HeaRh Insurance 21,511 23,000 23,000 18,753 20,125 17,300 18,200 18,200 524.100 Workers' Comp Insurance 250 280 280 279 279 280 330 280 554.301 Personnel Training 785 2,000 2,000 1,442 2,000 2,260 2,260 2,260 Personal Services 142,903 150,080 150,405 127,579 146,461 148,340 149,390 149,340 Acct Class: 530 Opera6ng ExpenditureslExpense 531.303 Codification Services 5,479 5,600 6,200 5,733 6,200 5,650 5,650 7,650 531.304 Recording Secy Service 5,388 7,350 7,350 6,030 7,000 7,350 7,350 7,350 534.301 Elec6on Expense 658 13,000 11,400 809 809 14,400 14,400 14,400 534.302 Legal Advertising 6,895 9,250 8,500 4,654 8,500 21,200 14,000 19,000 540.300 Travel & Per Diem 2,350 4,600 4,600 2,117 4,600 4,000 4,000 4,000 541.300 Communication Services 717 800 1,075 794 1,075 1,250 1,250 1,250 546.320 Computer system maint & suppli 1,129 1,000 1,000 959 1,000 2,000 2,000 2,OOQ 549.100 Miscellaneous Archival 2,790 2,500 2,500 425 2,500 2,500 2,500 2,50U 549.201 Advertising & Promo6on 669 1,000 700 40 700 1,000 1,000 1,000 549.300 Other Misc Chgs � Obligatlons 332 2,250 1,350 942 1,350 1,800 1,800 1,800 552.302 Small Tools and Equipment 464 500 500 457 500 500 500 500 552.306 Microfilm Service/Supplies 28 30 30 11 25 25 25 25 554.300 Books, Publ, Subs & Membership 436 830 830 662 830 860 860 860 Operating Expenditures/Expense 27,335 48,710 46,035 23,633 35,089 62,535 55,335 62,335 Acct Class: 600 Capital Outlay 664.601 Camputer Equipment 4,503 0 0 0 0 4,000 CapitalOuUay 4,503 0 0 0 0 4,000 0 0 Village Clerk 174,741 198,790 196,440 151,212 181,550 214,875 204,725 211,675 Dept: 130 Finance Acct Class: 510 Personal Services 512.100 Regular Salaries 8 Wages 209,299 235,500 235,500 202,462 234,610 242,500 242,500 242,500 BUDGET WORKSHEET Wednesday, August 22, 2012 Page: 9 8122/2012 Village of Tequesta 2:55 pm Prior ---------------------- Current Year ----------------------- �6) ��) l$) Year Original Amended Actual Thru Estimated Month:913012012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001- General Fund Expenditures Dept: 130 Finance Acct Class: 510 Personal Services 515.107 Part-tlme Salaries 19,996 0 0 0 0 516.100 Compensated Absences 5,498 3,000 3,000 0 2,775 3,000 3,000 3,000 521.101 FICATaxes 13,414 14,800 14,800 11,695 13,750 14,600 14,900 14,900 521.102 Medicare Taxes 3,163 3,500 3,500 2,760 3,240 3,500 3,500 3,500 522.102 VOT Pension Contribu6ons 19,972 22,300 22,300 19,032 22,055 23,000 22,900 22,900 523.101 L'rfelHealth Insurance 44,529 53,300 53,300 37,986 41,295 43,900 45,500 45,500 524.100 Workers' Comp Insurance 610 690 690 683 683 690 770 690 554.301 Personnel Training 3,244 4,600 4,600 2,370 3,500 4,600 4,600 4,600 PersonalServices 319,725 337,690 337,690 276,988 321,908 335,790 337,670 337,590 Acct Class: 530 Operating Expenditures/Expense 532.300 Accounting & Auditing Seroices 26,535 27,350 27,350 27,331 27,331 24,600 28,950 28,950 540.300 Travel 8 Per Diem 442 1,300 1,300 102 1,000 1,300 1,300 1,300 546.301 Otfice EquiplRepair & Maint 365 800 S00 395 S00 800 800 800 546.320 Computer system maint & suppli 10,917 8,000 8,000 7,078 8,000 8,500 8,500 8,500 547.300 Printing & Binding 0 0 3,500 2,197 3,000 3,000 3,000 3,000 549.300 Other Misc Chgs & Obligations 1,430 1,000 1,000 0 1,000 1,000 1,000 1,000 551.300 Office Supplies & Equipment 3,645 4,000 4,000 1,691 4,000 4,000 4,000 4,000 551,310 Printing & Binding 2,725 3,500 0 0 0 552.302 Small Tools and Equipment 40 500 500 73 500 500 500 500 554.300 Books, Publ, Subs & Membership 978 1,500 1,500 1,321 1,400 1,400 1,400 1,400 Operating ExpenditureslExpense 47,077 47,950 47,950 40,188 47,031 45,100 49,450 49,450 Finance 366,802 385,640 385,640 317,176 368,939 380,890 387,120 387,040 Dept: 140 tegal Acct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 65,256 75,000 75,000 65,267 75,000 94,000 94,000 94,000 531.308 Legal fees - Personnel 58,864 20,000 20,000 24,783 30,000 20,000 20,000 20,000 Operating Expenditures/Expense 124,120 95,000 95,000 90,050 105,000 114,000 114,000 114,000 Legal 124,120 95,000 95,000 90,050 105,000 114,000 114,000 114,000 Dept: 150 Comprehensive Planning Acct Class: 530 Operating EnpenditureslExpense 531.301 Legal Services 46,032 33,000 33,000 33,963 42,500 46,000 20,000 20,000 531.321 Mapping Services 0 2,450 2,450 2,399 2,450 2,500 531.322 Misc Planning Service 83,372 75,000 75,000 74,646 90,000 108,120 106,080 106,080 531.331 Board ofAdjustrnent 0 420 250 275 275 500 500 500 531.332 Planning and Zoning Board 500 2,500 1,000 1,012 1,000 2,500 2,500 2,500 531.405 Legal - Annexation 0 0 0 0 0 534.300 Other Contractual Services 2,275 1,000 4,720 3,600 4,720 11,100 5,000 5,000 BUD�ET WORKSHEET Wednesday, August 22, 2012 Page: 10 8I2212012 �Ilage of Tequesta 2:55 pm Prior --------------------- Current Year ------------------ (6) (7) (8) Year Original Amended Actua{ Thru Estimated Month:9/3012012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001- General Fund Expenditures Dept: 150 Comprehensive Planning Acct Class: 530 Operating ExpenditureslExpense 534.302 Legal Advertising 2,520 1,800 5,000 4,762 7,500 12,000 12,000 12,000 534.420 Legal Advertising - Annexation 0 0 0 0 0 546.320 Computer system maint & suppli 0 0 0 697 697 547.300 Printing & Binding 0 400 400 171 400 500 500 500 549.300 Other Misc Chgs & Obliga6ons 0 5,000 500 476 500 500 500 500 Operating Expenditures/Expense 134,699 121,570 122,320 122,001 150,042 181,220 147,080 149,580 Acct Class: 600 Capital Ouday 664.601 Computer Equipment 0 0 0 1,150 1,150 Capital0utlay 0 0 0 1,150 1,150 0 0 0 Comprehensive Planning 134,699 121,570 122,320 123,151 151,192 181,220 147,080 149,580 Dept: 160 General Government Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 82,084 84,600 84,600 72,885 84,450 69,800 69,800 69,800 521.101 FICATaxes 5,094 5,300 5,300 4,489 5,210 4,300 4,400 4,400 521.102 MedicareTaxes 1,191 1,300 1,300 1,050 1,220 1,000 1,100 1,100 522.102 VOT Pension Contributions 7,716 8,000 8,000 6,851 7,940 6,600 6,600 6,600 523.101 LifelHealth Insurance 6,585 7,000 7,000 6,402 6,950 5,500 5,800 5,800 524.100 Workers' Comp Insurance 198 230 230 222 222 230 210 230 554.301 Personnel Training 100 1,100 3,095 3,095 3,095 5,000 5,000 5,000 Personal Services 102,968 107,530 109,525 94,994 109,087 92,430 92,910 92,930 Acct Class: 530 Operating Expenditures/Expense 534.300 Other Contractual Services 19,784 23,500 26,500 25,366 26,900 31,500 20,000 20,000 534.303 Special Events 6,110 10,000 9,605 9,596 9,596 10,000 10,000 10,000 540.300 Travel & Per Diem 915 1,900 2,400 2,440 2,440 2,400 2,000 2,000 541.300 Communication Services 9,982 10,400 11,400 9,340 11,435 11,200 11,200 11,200 541.301 Postage 2,484 3,400 3,400 2,52p 3,000 3,400 3,400 3,400 541.305 Website Maintenance 7,910 8,350 8,267 7,966 8,267 7,750 7,750 7,750 543.300 Utiliry Services 15,063 16,000 15,000 11,994 15,000 14,000 14,000 14,000 544.301 Opera6ng Leases 6,427 6,400 5,384 4,443 5,255 5,620 5,620 5,620 545.300 Insurance 47,001 50,240 50,660 50,659 50,659 50,310 50,580 50,310 546.301 Office Equip/Repair & Maint 2,659 2,000 1,450 813 1,250 2,000 2,000 2,000 546.302 Vehicle Repair & Maintenance 1,062 1,000 250 15 100 546.303 Building Repair 8 Maint 0 0 0 0 0 546.310 Equipment Repair & Maint 594 1,000 1,000 895 1,000 1,000 1,000 1,000 546.320 Computer system maint 8 suppii 11,867 17,300 22,295 14,990 21,295 13,300 13,300 13,300 547.300 Printing 8 Binding 592 1,000 1,000 483 500 1,000 1,000 1,000 549.300 Other Misc Chgs & Obligations 6,165 8,000 4,326 3,624 4,326 8,000 8,000 8,000 BUDGET WORKSHEET Wednesday,August22,2012 Qa9e� » 8122I2012 Village of Tequesta 2:55 pm Prior - _------------------ Current Year ----------------- (6) �) (8) Year Original Amended Actual Thru Estimated Month:913012012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 160 General Govemment Acct Class: 530 Opera6ng ExpenditureslExpense 549.302 Village Newsletter 12,930 11,250 13,050 10,369 13,050 11,250 18,200 18,200 549.304 Licenses, Fees 8 Permits 2,646 2,650 2,303 2,303 2,303 2,650 2,650 2,650 549.366 DonaGons - Memorials 320 0 0 0 0 551.300 Office Supplies 8 Equipment 2,477 2,500 3,000 3,075 3,500 4,000 4,000 4,000 552.160 IT Opera6ng Supplies 369 400 400 186 360 400 400 400 552.301 Gas & Oil 176 400 400 267 400 600 600 600 552.302 Small Tools and Equipment 1,607 1,500 200 0 200 1,500 1,500 1,500 554.300 Boaks, Publ, Subs & Membership 2,426 4,100 2,300 2,016 2,300 4,500 4,500 4,500 Operating Expenditures/Expense 161,566 183,290 184,590 163,360 183,136 186,380 181,700 181,430 Acct Class: 600 Capital Outlay 664.600 MachlEquipment 0 0 1,300 1,300 1,300 664.601 Computer Equipment 0 24,000 24,000 13,425 24,000 362,000 664.602 Vehides 0 13,133 13,133 13,133 13,133 Capital0utlay 0 37,133 38,433 27,858 38,433 362,000 0 0 General Government 264,534 327,953 332,548 286,212 330,656 640,810 274,610 274,360 Dept: 171 Police Acct Class: 510 Personal Services 512.1 QO Regular Salaries & Wages 136,093 128,500 0 0 0 514.100 Overtime 0 0 0 0 0 515.106 Clothing & Boot Allowance 525 530 0 0 0 516.100 Compensated Absences 206 0 0 0 0 521.101 FICA Taxes 7,960 8,000 0 0 0 521.102 MedicareTaxes 1,862 1,900 0 0 0 522.101 FRS Contributions 18,020 0 0 0 0 522.102 VOT Pension Gontributions 7,190 19,700 0 0 0 522.110 Other Pension Contributions 54,983 0 0 0 0 523.101 L'rfelHealth Insurance 27,372 32,600 0 0 0 524.100 Workers' Comp Insurance 2,495 2,350 0 0 0 526.101 Employee Recogni6on Program 1,160 1,000 0 0 0 526.103 Education Reimbursement Prgm 888 0 0 0 0 526.105 Employee PhysicallPsycological 3,586 6,080 0 0 0 554.301 Personnel Training 650 600 0 0 0 �- Personal Services 262,990 201,260 0 0 0 0 0 0 Acct Class: 530 OperaUng Expenditures/Expense 540.300 Travel & Per Diem 605 200 0 0 0 541.300 Communication Services 33,735 33,660 0 0 0 541.301 Postage 2,179 2,000 0 0 0 BUDGET WORKSHEET Wednesday,August22,2012 Page: 12 8l22/2012 �Ilage of Tequesta 2:55 pm Prior ------------------- Current Year ------------------- (6) (7) (S) Year Original Amended Actual Thru Estimated Month:913012012 Actual Budget Budget September Total DEPARTMENT MANA�ER COUNCIL Fund: 001 - General Fund Expenditures Dept: 171 Police Acct Class: 530 Operating ExpenditureslExpense � 543.300 Utiliiy Services 28,885 30,000 0 0 0 544.301 Operating Leases 3,163 3,460 0 0 0 545.300 Insurance 43,587 45,410 0 0 0 546.301 Office EquiplRepair & Maint 0 500 0 0 0 546.303 Building Repair 8 Maint 19,410 13,100 0 0 0 546.310 Equipment Repair & Maint 1,922 1,000 0 0 0 546.320 Computer system maint & suppli 27,019 37,900 0 0 0 547.300 Prin6ng & Binding 2,807 3,000 0 0 0 549.300 Other Misc Chgs & Obliga8ons 1,168 750 0 0 0 549.304 Licenses, Fees & Permits 1,276 1,500 0 0 0 551.300 Office Supplies 8 Equipment 4,803 5,000 0 0 0 551.301 Crime Prevention Supplies 3,851 4,000 0 0 0 552.302 Small Tools and Equipment 320 450 0 0 0 552.305 Uniforms 1,129 1,500 0 0 0 554.300 Books, Publ, Subs 8 Membership 1,038 1,200 0 0 0 Operating Expenditures/Expense 176,897 184,630 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 Police 439,887 385,890 0 0 0 0 0 0 Dept: 172 Police-Communication Acct Class: 510 Personal Seroices 512.100 Regular Salaries 8 Wages 228,189 235,400 0 0 0 514.100 Qvertime 13,862 16,500 0 0 0 515.101 Holiday Pay 9,447 8,700 0 0 0 515.103 Bonus Pay Plan 5,000 5,000 0 0 0 515.106 Clothing & BootAllowance 2,125 2,130 0 0 0 515.107 Part-time Salaries 8,439 5,400 0 0 0 516.100 Compensated Absences 795 0 0 0 0 521.101 FICA Taxes 16,013 17,000 0 0 0 521.102 Medicare Taxes 3,745 4,000 0 0 0 522.101 FRS ConVibudons 5,997 3,900 0 0 0 522.102 VOT Pension Contribu6ons 15,881 16,500 0 0 0 523.101 Life/Health Insurance 44,729 46,900 0 0 0 524.100 Workers' Comp Insurance 658 740 0 0 0 554.301 Personnel Training 120 1,000 0 0 0 Personal Services 355,000 363,170 0 0 0 0 0 0 BUDGET WORKSHEET Wednesday, August 22, 2012 Page: 13 812212012 �Ilage of Tequesta 2:55 pm Prior ------------------------CurrentYear--------------• (s) (7) (8) Year Original Amended Actual Thru Es6mated Month:9l30/2012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001- General Fund Expenditures Dept: 172 Police-CommunicaGon Acct Class: 530 Operating Expenditures/Expense 540.300 Travel & Per Diem 519 650 0 0 0 546.301 Office EquiplRepair 8 Maint 0 100 0 0 0 546.304 Communica6on Equip Maint 10,648 14,400 0 0 0 549.300 Other Misc Chgs & Obliga6ons 0 0 0 0 0 552.302 Small Tools and Equipment 339 2,000 0 0 0 552.305 Uniforms 691 900 0 0 0 554.300 Books, Publ, Subs & Membership 95 0 0 0 0 Operating ExpenditureslExpense 12,292 18,050 0 0 0 0 0 0 Police-Communication 367,292 381,220 0 0 0 0 0 0 Dept: 175 Police Department Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 1,009,069 1,000,100 0 0 0 512.171 Sal 8 Wages - Adminstra6on 0 0 130,470 112,606 130,470 180,500 180,500 180,500 512.172 Reg Sal & Wages - Communicatio 0 0 237,500 204,962 237,450 199,200 199,200 199,200 512.175 Reg Sal & Wages - Operations 0 0 950,000 823,980 940,4Q0 980,800 1,027,900 1,027,900 514.100 Overtime 94,905 91,100 0 0 0 514.172 Overtime - Communica6ons 0 0 16,500 14,019 16,500 17,000 17,000 17,000 514.175 OveRime - Operations 0 0 91,233 90,904 99,000 123,300 70,000 70,000 514.325 Overtime - DEA -5,250 0 0 0 0 515.101 Holiday Pay 30,960 36,100 49,000 43,770 48,000 48,900 48,900 48,900 515.103 Bonus Pay Plan 6,250 5,000 10,000 9,250 9,250 9,000 8,250 8,250 515.104 Sick Leave Conversion Pay 0 2,500 0 0 0 515.106 Clothing & BootAllowance 9,246 9,080 11,740 11,558 11,558 11,200 16,500 16,500 515.107 Part-time Salaries 31,835 55,000 0 0 0 32,900 515.172 PIT Salary - Communica6ons 0 0 5,400 11,699 15,400 10,000 6,200 6,200 515.175 P(f Salary - Operations 0 0 97,660 135,630 150,660 145,000 100,400 100,400 516.100 Compensated Absences 7,917 45,000 54,940 72,196 72,197 5,000 8,000 8,000 521.101 FICATaxes 71,509 80,300 106,700 90,422 104,000 105,000 104,700 102,200 521.102 Medicare Taxes 16,724 18,800 25,400 21,447 24,800 24,600 24,500 23,900 522.101 FRS Contributlons 63,742 53,100 46,630 38,874 A5,000 50,000 46,500 46,500 522.102 VOT Pension Contributions 105,420 152,000 188,200 206,472 206,472 213,100 178,900 178,900 522.110 Other Pension ConUibutions 0 0 0 0 56,466 56,470 56,470 523.101 LifelHealth Insurance 160,726 145,500 225,000 227,007 245,510 253,900 287,700 287,700 524.100 Workers' Comp Insurance 28,648 32,090 35,180 35,170 35,170 35,180 37,950 35,180 526.101 Employee Recogni6on Program 0 0 1,000 511 1,000 1,000 1,000 1,000 526.105 Employee PhysicallPsycological 0 0 6,080 1,016 3,000 6,000 6,000 6,000 554.301 Personnel Training 3,894 8,200 2,845 2,721 2,721 10,500 10,500 10,500 BUDGET WORKSHEET Wednesday, August 22, 2012 Page: 14 8/22/2012 Village of Tequesta 2:55 pm Prior ---------------- Current Year ----------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:9130/2012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 175 Police Department Personal Services 1,635,595 1,733,870 2,29t,478 2,154,214 2,455,024 2,429,180 2,469,970 2,431,200 Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 25,025 20,000 20,000 20,104 27,600 20,000 15,000 15,000 531.320 Code Enforcement Service 2,869 4,000 4,000 0 2,000 4,OOQ 4,000 4,000 540.300 Travel 8 Per Diem 2,312 3,000 6,350 3,401 5,000 9,650 9,650 9,650 541.300 Communication Services 0 0 31,660 24,929 28,600 30,000 25,000 25,000 541.301 Postage 0 0 2,000 1,404 1,500 2,000 2,000 2,000 543.300 UGlity Services 0 0 24,288 20,013 24,288 28,000 26,000 26,000 544.301 Operating Leases 8,618 9,000 12,460 8,930 9,136 11,500 2,500 2,500 545.3001nsurance 0 0 45,410 44,990 44,990 45,410 43,280 45,410 546.301 Office EquiplRepair & Maint 0 500 1,100 314 750 1,000 1,000 1,000 546.302 Vehide Repair & Maintenance 33,445 29,000 31,500 31,786 35,500 35,000 35,000 35,000 546.303 Building Repair & Maint 0 0 21,179 19,897 20,000 20,000 15,000 15,000 546.304 Communication Equip Maint 0 0 14,400 11,854 13,700 16,000 16,000 16,000 546.310 Equipment Repair & Maint 10,147 6,700 7,700 3,562 5,000 7,700 7,700 7,700 546.320 Computer system maint & suppli 0 0 41,375 37,509 41,375 68,700 52,800 52,800 547.300 PrinGng & Binding 0 0 3,000 1,124 1,900 2,500 2,500 2,500 549.300 Other Misc Chgs & Obligations 490 1,250 3,547 3,199 3,547 4,250 5,500 5,500 549.303 Investigative Eupenses 1,400 1,090 1,090 825 1,090 1,100 1,100 1,100 549.304 Licenses, Fees & Permits 0 0 3,600 3,400 3,600 1,500 1,500 1,500 549.311 Marine Unit Operations 3,287 2,800 2,800 1,789 2,800 3,000 3,000 3,000 549.314 K.E.Y.S. Program 740 2,500 0 0 0 2,500 2,500 2,500 551.300 Office Supplies 8 Equipment 0 0 4,825 4,334 4,825 5,000 5,000 5,000 551.301 Crime Prevention Supplies 0 0 4,000 0 4,000 4,000 4,000 4,000 552.301 Gas & Oil 65,702 64,000 64,000 63,968 79,000 84,000 60,000 60,000 552.302 Small Tools and Equipment 13,867 10,600 11,050 7,340 10,550 9,050 9,050 9,050 552.305 Uniforms 10,737 9,500 10,900 9,336 10,867 18,500 20,500 20,500 552.307 PhotoNideo Supplies 0 250 100 0 0 554.300 Baoks, Publ, Subs 8 Membership 318 1,000 2,200 1,944 2,200 4,500 4,500 4,500 Operating ExpenditureslExpense 178,957 165,190 374,534 325,952 383,818 438,860 374,080 376,210 Acct Class: 600 Capital OuUay 664.600 MachlEquipment 23,631 0 57,705 29,680 57,705 40,000 664.601 ComputerEquipment 1,050 0 1,440 1,439 1,439 21,000 664.602 Vehides 0 30,000 35,000 34,665 34,665 90,000 40,000 40,000 664.620 Intangible - Software 0 163,240 163,240 168,233 16$,233 Capital0utlay 24,681 193,240 257,385 234,017 262,042 151,000 40,000 40,000 Police Department 1,839,233 2,092,300 2,923,397 2,714,183 3,100,884 3,019,040 2,884,050 2,847,410 BUDGET WORKSHEET Wednesday,Augus122,2012 Page: 15 812212012 Ullage of Tequesta 2:55 pm Prior ----------------------- Current Year -----------___----- (6) (�) (a) Year Original Amended Actual Thru Estimated Month:9130/2012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 180 Building & Zoning Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 21,660 59,100 108,371 91,563 107,900 123,200 123,200 123,200 515.104 Sick Leave Conversion Pay 239 0 0 0 0 515.107 Part-time Salaries 59,881 79,900 27,600 22,465 26,400 29,300 29,300 29,300 515.120 Cell phone allowance 120 360 360 240 240 516.100 Compensated Absences 1,293 0 0 0 0 521.101 FICA Taxes 4,838 8,500 8,329 6,509 7,800 9,400 9,500 9,500 521.102 MedicareTaxes 1,203 2,100 2,000 1,627 1,925 2,200 2,300 2,300 522.101 FRS Contributions 619 1,300 2,199 1,497 2,035 4,100 4,100 4,100 522.102 VOT Pension Contribu6ons 1,421 0 4,150 3,520 4,085 4,300 4,300 4,300 523.101 L'rfelHealth Insurance 0 2,300 10,575 9,449 10,521 13,700 14,200 14,200 524.100 Workers' Comp Insurance 2,097 140 140 132 132 140 380 140 525.100 Unemployment Compensation 192 0 0 0 0 554.301 Personnel Training 490 500 500 490 490 1,500 1,500 1,500 PersonalServices 94,053 154,200 164,224 137,492 161,528 187,840 188,780 188,540 Acct Class: 530 Operating Expenditures/Expense 531.325 Inspection Services 89,350 91,000 91,000 83,206 99,000 91,000 91,000 113,000 534.300 Other Contractual Services 0 0 0 0 0 11,500 11,500 11,500 540.300 Travel & Per Diem 1,141 1,180 1,180 1,125 1,180 2,240 2;240 2,240 541.300 Communica6on Services 1,975 1,980 1,980 2,132 2,550 3,240 3,240 3,240 541.301 Pastage 1,374 1,020 1,020 968 1,020 1,020 1,020 1,020 543.300 Utility Services 5,707 5,440 5,440 4,559 5,850 5,500 5,500 5,500 544.301 OperaGng Leases 0 0 1,903 1,744 1,903 1,910 1,910 1,910 546.301 Office EquiplRepair 8 Maint 1,987 2,130 227 700 850 1,000 1,000 1,000 546.303 Building Repair & Maint 0 0 0 0 0 546.320 Computer system maint & suppli 5,116 3,900 3,900 3,856 3,900 5,200 4,000 5,200 547.300 PrinGng & Binding 715 500 546 1,007 1,007 1,000 1,000 1,000 549.300 Other Misc Chgs & Obliga6ons 868 750 704 547 704 600 600 600 549.304 Licenses, Fees & Permits 1,276 1,350 1,350 1,348 1,348 1,400 1,400 1,400 551.300 Office Supplies & Equipment 1,162 1,440 1,440 1,137 2,540 1,440 1,440 2,540 554.300 Books, Publ, Subs & Membership 965 1,130 1,130 1,353 1,353 1,250 1,250 1,250 Opera6ng ExpenditureslExpense 111,636 111,820 111,820 103,682 123,205 128,300 127,100 151,400 Acct Class: 600 Capital Outlay 664.600 MachlEquipment 0 0 0 0 0 664.601 Computer Equipment 0 0 0 1,150 1,150 160,000 Capital0uday 0 0 0 1,150 1,150 160,000 0 0 Building & Zoning 205,689 266,020 276,044 242,324 285,883 476,140 315,880 339,940 Dept: 191 Civil Preparation BUDGET WORKSHEET Wednesday, August 22, 2012 Page: 16 8/2212012 Village of Tequesta 2:55 pm Prior --------------------- Current Year ----------------------- (6) (7) (a) Year Original Amended Actual Thru Estimated Month:9130/2012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001- General �und Expenditures Dept: 191 Civil Prepara6on Acct Class: 510 Personal Senrices 554.301 Personnel Training 0 350 0 0 0 Personal Services 0 350 0 0 0 0 0 0 Acct Class: 530 Opera6ng Expenditures/6cpense 540.300 Travel 8 Per Diem 0 960 0 0 0 541.300 Communication Services 3,724 3,600 0 0 0 546.320 Computer system maint & suppli 755 800 0 0 0 549.900 Disaster Relief & Ini6al Resp 1,527 2,500 0 0 0 552.308 Safery Supplies 48 3,110 0 0 0 552.309 Civil Defense Supplies 712 1,500 0 0 0 552.310 Disaster Relief Supplies 229 1,500 0 0 0 Operating ExpenditureslExpense 6,995 13,970 0 0 0 0 0 0 Civil Preparation 6,995 14,320 0 0 0 0 0 0 Dept: 192 Fire Control Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 1,437,291 1,446,800 1,439,729 1,245,689 1,437,250 1,430,900 1,430,900 1,430,900 514.100 Overtime 49,373 51,500 51,500 44,660 48,000 52,950 50,000 50,000 514.300 Overtime-Training 10,269 11,000 11,000 10,461 11,000 19,890 19,890 19,890 515.101 Holiday Pay 46,91Q 48,500 48,500 44,128 48,360 52,220 49,800 49,800 515.103 Bonus Pay Plan 4,641 0 0 0 0 515.104 Sick Leave Conversion Pay 6,068 3,600 0 0 0 515.106 Clothing 8 BootAllowance 600 0 0 0 0 515.107 Part-Gme Salaries 19,247 18,400 20,000 16,242 20,000 59,990 49,800 49,800 515.110 Intern Fire Fighter Pay 60,262 63,100 63,100 53,059 56,500 64,610 72,100 72,100 515.120 Cell phone allowance 280 840 960 860 960 1,200 1,200 1,200 516.100 Compensated Absences 25,878 0 3,600 3,217 3,217 3,600 3,600 3,600 521.101 FICA Taxes 98,805 101,400 100,971 83,216 97,000 104,420 102,800 102,800 521.102 Medicare Taxes 23,513 23,900 23,800 19,707 23,000 24,420 24,100 24,100 522.101 FRS Contributions 6,042 2,900 2,001 1,730 1,730 522.102 VOT Pensian Contributians 257,804 313,500 313,500 362,802 362,802 338,600 337,900 337,900 522.110 Other Pension Contribufions 128,337 137,000 137,000 0 154,707 137,000 137,000 137,000 523.101 L'rfelHealth Insurance 209,413 214,300 222,775 209,820 227,664 225,640 226,700 226,700 524.100 Workers' Comp Insurance 43,262 48,450 48,450 48,445 48,445 48,450 55,970 48,450 525.100 Unemployment Compensation 3,690 0 125 121 121 526.101 Employee Recognition Program 2,165 2,930 930 0 930 2,930 1,605 1,605 526.103 Educa6on Reimbursement Prgm 19,663 15,000 5,000 2,033 5,000 10,400 10,000 10,000 526.105 Employee Physical/Psycological 9,343 9,870 9,870 9,823 9,825 9,870 9,870 9,870 554.301 Personnel Training 6,303 8,720 9,070 2,824 8,100 12,720 9,070 9,070 BUDGET WORKSHEET Wednesday,August22,2012 Page: 17 812212012 Village of Tequesta 2:55 pm Prior ---------------------- Current Year -°------------------- �6I (�) l Year Original Amended Actual Thru Estimated Month:9/3012012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001- General Fund Expenditures Dept: 192 Fire Control Personal Services 2,469,159 2,521,710 2,511,881 2,158,837 2,564,611 2,599,810 2,592,305 2,584,785 Acct Class: 530 Operating ExpenditureslExpense 531.318 Volunteer Fire Fighter Program 5,137 0 14,486 14,349 14,349 8,930 8,930 8,930 540.300 Travel & Per Diem 1,674 5,140 3,100 1,860 3,100 6,100 6,100 6,100 541.300 Communication Services 14,596 15,120 15,520 12,968 15,520 16,660 15,460 15,460 541.301 Postage 1,296 1,400 1,400 999 1,400 1,500 1,500 1,500 543.300 Utility Services 31,182 30,800 28,300 22,334 28,300 28,760 28,760 28,760 544.301 Operadng Leases 6,682 7,020 7,720 6,177 7,720 7,740 7,740 7,740 545.3001nsurance 20,702 21,390 20,990 20,980 20,980 21,390 21,550 21,390 546.302 Vehicle Repair & Maintenance 25,525 27,420 28,020 25,739 28,020 42,970 9,500 9,500 546.303 Building Repair & Maint 16,573 16,670 28,037 22,972 28,037 25,610 25,610 25,610 546.310 Equipment Repair & Maint 12,439 19,940 21,008 17,643 19,950 21,720 21,720 21,720 546.320 Computer system maint & suppli 14,120 19,100 19,900 12,896 19,900 18,800 18,000 18,000 547.300 Printing & Binding 505 920 920 603 750 920 920 920 549.300 Other Misc Chgs & Obliga6ons 5,610 2,630 1,830 1,324 1,830 2,600 2,600 2,600 549.304 Licenses, Fees & Permits 16,751 17,580 17,185 15,413 16,950 17,010 17,010 17,010 549.311 Marine Unit Operations 3,605 7,380 2,$80 2,013 2,880 5,480 5,480 5,480 551.300 Office Supplies 8 Equipment 2,979 2,970 2,470 1,918 2,470 2,790 2,790 2,790 551.302 Fire Preven6on Education 1,446 1,800 2,300 1,363 2,300 2,310 2,310 2,310 552.301 Gas & Oil 13,143 22,420 18,420 13,837 18,420 22,270 22,270 20,000 552.302 Small Tools and Equipment 0 0 0 0 0 552.304 Chemicals 216 980 480 130 480 990 99� 99� 552.305 Uniforms 18,009 22,750 20,250 13,703 20,125 23,310 23,310 23,310 552.308 Safety Supplies 12,425 19,000 21,042 12,679 19,250 22,840 22,840 22,840 552.310 Disaster Relief Supplies 0 0 5,500 165 4,225 5,500 5,500 5,500 552.311 CPR Program Suppl+es 0 340 500 500 500 340 340 340 552.312 Medical Supplies 34,244 31,630 38,570 34,630 38,570 37,170 37,170 37,170 552.344 Fire Sta6on Supplies 807 1,260 3,960 3,250 3,960 1,260 1,260 1,260 554.300 Books, Publ, Subs & Membership 1,850 2,280 2,630 2,284 2,630 2,750 2,750 2,750 Operating ExpenditureslExpense 261,516 297,940 327,418 262,729 322,616 347,720 312,410 309,980 Acct Class: 600 Capital Outlay 664.600 MachlEquipment 4,400 0 0 0 0 13,100 7,500 7,500 664.601 Computer Equipment 0 0 0 0 0 21,000 664.602 Vehicles 27,421 0 0 0 0 Capital0utlay 31,821 0 0 0 0 34,100 7,500 7,500 Fire Control 2,762,496 2,819,650 2,839,299 2,421,566 2,887,227 2,981,630 2,912,215 2,902,265 Dept: 210 Public Works Acct Class: 510 Personal Seroices BUDGET WORKSHEET Wednesday,August22,2012 Page: 18 8122/2012 �Ilage of Tequesta 2:55 pm Prior --��________---------- Current Year -------------------- (s) p) (8) Year Original Amended Actual Thru Estimated Month:9130/2012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 210 Public Works Acct Class: 510 Personal Services 512.10U Regular 5alaries & Wages 191,009 198,100 198,100 160,963 184,520 210,000 177,700 177,700 514.100 Overtime 362 1,000 1,000 0 1,000 1,000 1,000 1,000 515.104 Sick Leave Conversion Pay 222 0 0 0 0 515.106 Clothing & Boot Allowance 400 400 400 400 400 500 500 500 515.107 Part-time Salaries 0 0 0 0 0 25,200 18,900 521.101 FICATaxes 11,196 12,400 12,400 9,129 10,500 12,000 12,100 11,700 521.102 Medicare Taxes 2,618 2,900 2,900 2,135 2,460 2,800 2,900 2,800 522.101 FRS Contributions 12,014 7,400 6,435 4,517 5,052 4,100 4,100 4,100 522.102 VOT Pension Contributions 6,161 6,500 7,465 6,160 7,450 12,800 9,800 9,800 523.101 LifelHealth Insurance 46,543 48,900 48,900 44,172 48,590 70,800 56,200 56,200 524.100 Workers' Comp Insurance 9,168 10,270 10,270 10,266 10,266 10,270 10,880 10,270 Personal Services 279,693 287,870 287,870 237,742 270,238 324,270 300,380 292,970 Acct Class: 530 Operating ExpenditureslExpense 531.302 Engineering Services 2,982 2,000 2,000 502 1,600 2,000 2,000 2,000 534.300 Other ConVactual Services 0 2,000 2,000 324 1,500 2,000 2,000 2,000 540.300 Travel & Per Diem 0 250 250 0 0 250 250 250 541.300 Communication Services 3,829 4,500 4,500 3,004 3,700 4,000 4,000 4,000 543.300 Utility Services 93,149 90,000 90,000 76,248 89,500 90,000 90,000 90,000 543.301 StreetLights 110,579 120,000 120,000 81,775 109,500 110,000 110,000 110,000 544.301 Operating Leases 0 0 1,126 375 565 1,500 1,200 1,200 544.304 FEC Lease 12,323 14,000 14,000 12,903 12,903 14,000 14,000 14,000 545.300 Insurance 10,917 11,500 11,500 10,846 10,846 11,500 10,800 11,500 546.200 R&M - Station 11 573 2,000 2,000 0 500 2,000 2,000 2,000 546.301 Office Equip/Repair & Maint 146 500 500 4 250 200 200 200 546.302 Vehicle Repair 8 Maintenance 2,015 4,000 4,000 2,942 4,000 4,000 4,000 4,000 546.303 Building Repair & Maint 7,348 7,000 16,000 15,412 16,000 8,000 8,000 8,000 546.305 Pathway Maintenance 9,090 10,000 13,310 11,875 13,310 15,000 15,000 15,000 546.306 General Maintenance 26,375 30,000 23,874 11,142 18,000 30,000 30,000 30,000 546.309 Landscape 8 Irrigation Maint 111,623 125,000 125,000 103,946 125,000 130,000 130,000 130,000 546.310 Equipment Repair & Maint 7,092 5,000 6,000 5,973 6,500 6,000 6,000 6,000 546.320 Computer system maint 8 suppli 858 600 600 459 600 1,020 1,020 1,020 546.350 R& M- Roads 13,628 16,000 39,503 23,124 33,500 45,000 20,000 20,000 549.300 Other Misc Chgs & Obligadons 528 1,800 8,755 6,367 6,320 1,800 1,800 1,800 549.304 Licenses, Fees & Permits 3,969 4,500 4,500 2,390 4,500 4,500 4,500 4,500 551.300 Office Supplies & Equipment 248 450 450 268 450 450 450 450 551.400 Janitorial Supplies 3,470 3,000 3,000 3,049 3,500 4,500 4,500 4,500 BUDGET WORKSHEET Wednesday,August22,2012 Page: 19 8122I2012 Village of Tequesta 2:55 pm Prior ------------------ Current Year ------------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:9130/2012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 210 Public Works Acct Class: 530 Operating Expenditures/Expense 552.301 Gas & Oil 6,757 5,000 5,000 5,707 7,108 6,000 6,000 6,000 552.302 Small Tools and Equipment 734 1,000 1,000 980 1,000 1,500 1,500 1,500 552.305 Uniforms 566 2,000 2,000 914 1,200 2,000 2,000 2,000 553.301 Road Signs 1,216 3,000 3,000 272 1,500 2,000 2,000 2,000 563.600 Public Works Misc Projects 4,126 7,500 2,500 1,632 2,000 7,500 5,000 5,000 563.601 Streetscape Trees 1,100 2,500 2,500 0 500 2,000 2,000 2,000 Operating ExpenditureslExpense 435,241 475,100 508,868 382,433 475,852 508,720 480,220 480,920 Acct Class: 600 Capital Outlay 663.600 Improvements other than Bldgs 5,402 0 2,600 2,365 2,365 664.600 MachlEquipment 0 10,000 21,008 21,008 21,008 664.602 Vehicles 0 25,000 21,690 21,690 21,690 Capital0utlay 5,402 35,000 45,298 45,063 45,063 0 0 0 PublicWorks 720,336 797,970 842,036 665,238 791,153 832,990 780,600 773,890 Dept: 230 Parks Acct Class: 600 Capital Outlay 661.000 Land 231,082 0 0 0 0 CapitalOuUay 231,082 0 0 0 0 0 0 0 Parks 231,082 0 0 0 0 0 0 0 Dept: 231 Leisure Services Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 146,768 154,800 154,800 133,408 154,575 189,800 159,700 159,700 514.100 Overtime 24 0 0 0 0 515.104 Sick Leave Conversion Pay 1,410 1,500 0 0 0 515.106 Clothing & Boot Allowance 100 100 100 100 100 100 100 100 515.107 Part-time Salaries 42,476 34,700 34,700 27,440 33,700 12,200 45,000 45,000 515.108 Auto Allowance 3,000 3,000 3,000 2,750 3,000 3,000 3,000 3,000 515.109 Seasonal Salaries & Wages 29,106 30,000 30,000 28,119 30,000 30,000 30,000 30,000 516.100 Compensated Absences 1,410 0 4,505 2,071 4,504 3,500 3,500 3,500 521.101 FICA Taxes 13,448 13,900 13,900 11,234 13,100 14,100 14,600 14,600 521.102 Medicare Taxes 3,145 3,300 3,300 2,628 3,100 3,300 3,500 3,500 522.102 VOT Pension Contributions 13,768 15,000 15,000 12,540 14,530 17,900 15,100 15,100 523.101 LifelHealth Insurance 36,569 39,200 39,217 36,046 39,217 49,600 40,000 40,000 524.100 Workers' Comp Insurance 6,754 7,570 7,570 7,563 7,563 7,570 8,190 7,570 525.100 Unemployment Compensation 0 0 5,550 5,550 5,550 526.105 Employee PhysicaVPsycological 1,425 2,000 2,500 1,242 2,500 2,500 2,500 2,500 554.301 PersonnelSraining 285 1,200 0 0 0 1,200 1,200 1,200 PersonalSeroices 299,688 306,270 314,142 270,691 311,439 334,770 326,390 325,770 BUDGET WORKSHEET Wednesday, August 22, 2012 Page: 20 8122I2012 Village of Tequesta 2:55 pm Prior ------------------ Current Year -------------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:913012012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 231 Leisure Services Acct Class: 530 Operating ExpenditureslExpense 534.303 Special Events 78,732 90,000 86,700 86,687 86,687 87,000 79,000 79,000 540.300 Travel & Per Diem 0 3,000 0 0 0 3,000 3,000 3,000 541.300 Communica6on Services 4,964 5,250 5,350 4,620 5,320 5,730 5,730 5,730 541.301 Pastage 141 150 150 147 150 150 150 150 543.300 Utility Services 20,093 15,500 15,500 10,033 13,500 15,500 15,500 15,500 545.300 Insurance 12,146 12,570 12,570 12,566 12,566 12,570 12,500 12,570 546.302 Vehicle Repair & Maintenance 555 1,500 2,000 2,789 2,800 1,800 1,800 1,800 546.303 Building Repair & Maint 19,180 20,000 20,000 11,3$5 20,000 20,000 20,000 20,000 546.306 General Maintenance 32,734 30,000 30,000 26,610 30,000 30,000 30,000 30,000 546.310 Equipment Repair & Maint 2,492 1,700 2,700 523 1,700 1,700 1,700 1,700 546.320 Computersystemmaint&suppli 3,986 2,900 2,900 1,265 2,900 1,740 1,740 1,740 549.201 Advertising 8 Promotion 12,400 10,000 10,000 6,358 10,000 9,000 9,000 9,000 549.300 Other Misc Chgs & Obligations 658 5,000 1,228 792 1,228 5,000 5,000 5,000 549.304 Licenses, Fees & Permits 1,963 2,200 2,200 1,914 2,000 2,200 2,200 2,200 549.332 Recreation Program Expense 31,268 35,000 38,300 37,921 38,300 38,300 38,300 38,300 549.333 SpringlSummerCamp 16,591 21,000 21,000 15,638 21,000 16,000 16,000 16,000 551.300 Office Supplies & Equipment 835 2,000 2,000 1,999 2,000 2,000 2,000 2,000 551.315 Concession Supplies 5,302 7,000 3,500 3,463 3,463 5,000 5,000 5,000 552.301 Gas & Oil 1,997 1,200 2,000 1,609 2,000 1,200 1,200 1,200 552.302 Small Tools and Equipment 2,248 1,500 1,500 1,774 1,741 1,500 1,500 1,500 552.305 Unifarms 331 350 350 257 350 500 500 500 554.300 Books, Publ, Subs & Membership 425 500 500 150 500 500 500 500 Operating Expenditures/Expense 249,041 268,320 260,448 228,500 258,205 260,390 252,320 252,390 Acct Class: 600 Capital Outlay 664.600 MachlEquipment 0 0 0 0 0 CapitalOuGay 0 0 0 0 0 0 0 0 Leisure Services 548,729 574,590 574,590 499,191 569,644 595,160 578,710 578,160 Dept: 700 Debt Service Acct Class: 471 D1S - Principal 571.706 P/S Prin - BOA - P/S Bldg 227,514 237,500 237,500 217,268 237,445 247,810 247,810 247,810 571.708 PIS - Prin - SunTrust - Pumper 43,521 45,100 45,100 45,092 45,100 571.725 Prin - 2012 Ford Focus - Admin 0 4,191 4,191 2,423 2,774 4,315 4,315 4,315 571.726 Prin. - CTS Smart Cop Lease 0 0 0 0 0 53,870 53,870 53,870 DIS - Principal 271,035 286,791 286,791 264,783 285,319 305,995 305,995 305,995 Acct Class: 472 DIS - Interest 572.706 PIS - Int. BOA - P.S Bldg 144,987 135,100 135,100 124,192 135,057 124,700 124,700 124,700 572.708 P/S-SunTrust-Pumper 3,199 1,700 1,700 1,628 1,630 BUDGET WORKSHEET Wednesday,August22,2012 Page: 21 8122I2012 Ullage of Tequesta 2:55 pm Prior --------------------- Current Year ------------------- (6) l�) � Year Original Amended Actual Thru Estimated Month:9130/2012 Actual Budget Budget September Total DEPARTMENT MANAGER CQUNCIL Fund: 001 - General Fund Expenditures Dept: 700 Debt Service Acct Class: 472 DIS - Interest 572.725 Int. 2012 Ford Focus - Admin 0 485 485 304 343 365 365 365 DIS-Interest 148,186 137,285 137,285 126,124 137,030 125,065 125,065 125,065 Debt Service 419,221 424,076 424,076 390,907 422,349 431,060 431,060 431,060 Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 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 Dept: 910 Other Financing Sources & Uses Acct Class: 590 Other Financing Sources � Uses 567.100 Unrealized Loss on Investments 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Dept: 950 Other Nonoperating Acct Class: 590 Other Financing Sources & Uses 549.391 Bank Charges 10,499 12,000 12,000 8,161 12,000 12,000 12,000 12,000 549.395 Credit Card Fees and Charges 0 0 0 0 0 4,000 4,000 590.001 Allocate to Fund Balance 0 0 0 0 0 999.001 Suspense 0 0 0 0 0 999.002 Suspense - Payroll 0 0 0 0 � 999.200 Suspense-AIP 0 0 0 0 0 Other Financing Sources & Uses 10,499 12,000 12,000 8,161 12,000 12,000 16,000 16,000 Other Nonoperating 10,499 12,000 12,000 8,161 12,000 12,000 16,000 16,000 Dept: 990 OthedReservelContlngency 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 OtherlReservelContingency 0 0 0 0 0 0 0 U Total Expenditures 8,966,717 9,266,559 9,404,960 8,234,500 9,587,904 10,262,935 9,427,960 9,407,200 General Fund 53,139 0 0 -109,023 0 -1,841,215 0 -865,220 BUDGET WORKSHEET Wednesday, August 22, 2012 Pa9e: ZZ 812212012 Village of Tequesta 2:55 pm Prior ------------------ Current Year ----------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:9/30/2012 Actual Budget Budget September Total DEPARTMENT MANAGER CQUNCIL Fund: 301 - Capital Improvement Fund Revenues Dept: 000 General Acct Class: 334 Grants - State 334.400 State Grant-Transportation 0 48,000 48,000 0 48,000 Grants - State 0 48,000 48,000 0 48,000 0 0 0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 88,000 0 0 162,699 162,700 Miscellaneous Revenues 88,000 0 0 162,699 162,700 0 0 0 General 88,000 48,000 48,000 162,699 210,700 0 0 0 Dept: 900 Interfund Transfers Acct Class: 391 Transfers In 381.001 Transfer from General Fund 0 0 0 0 0 381.303 Tsfer-In from Capital Projects 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: 990 OthedReseroe/Con6ngency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 201,300 201,300 0 38,600 290,440 Other Financing Sources 0 201,300 201,300 0 38,600 0 290,440 0 OtherlReserve/Contingency 0 201,300 201,300 0 38,600 0 290,440 0 Total Revenues 88,000 249,300 249,300 162,699 249,300 0 290,440 0 Expendilures pept: 310 Annual Paving Project Acct Class: 600 Capital Ouday 653.601 Road Improvements 0 0 0 0 0 Capital0utlay 0 0 0 0 0 0 0 0 Annual Paving Project 0 0 0 0 0 0 0 0 Dept: 315 Tequesta Drive (Bridge) Acct Class: 600 Capital Outlay 662.632 Architect & Engeering 15,720 0 0 0 0 662.633 Construction- Other 8,980 0 0 0 0 663.301 Construction - Bridge 594,031 0 0 0 0 Capital0utlay 618,731 0 0 0 0 0 0 0 Tequesta Drive (Bridge) 618,731 0 0 0 0 0 0 0 Dept: 399 Misc Proj-General Acct Class: 600 Capital Outlay 663.655 Landscaping 0 48,000 48,000 0 48,000 Capital0utlay 0 48,000 48,000 0 48,000 0 0 0 Misc Proj-General 0 48,000 48,000 0 48,000 0 0 0 Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out BUDGET WORKSHEET Wednesday,August22,2012 Page: 23 812212012 Village of Tequesta 2:55 pm Prior --------------------- Current Year ------------------ (6) (7) (8) Year Original Amended Actual Thru Estimated Month:9/3012012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 301 - Capital Improvement Fund Expenditures Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 591.001 Transfer to General Fund 250,000 201,300 201,300 201,300 201,300 290,440 Interfund Transfers Out 250,000 201,300 201,300 201,300 201,300 0 290,440 0 Interfund Transfers 250,000 201,300 201,300 201,300 201,300 0 290,440 0 TotalExpendilures 868,731 249,300 249,300 201,300 249,300 0 290,440 0 Capital Improvement Fund -780,731 0 0 -38,601 0 0 0 0 BUDGET WORKSHEET Wednesday, August 22, 2012 Page: 24 8/2212012 �Ilage of Tequesta 2:55 pm Prior ------_----------- Current Year ---------------------- l ��) 1 Year Original Amended Actual Thru Estimated Month:9/3012012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 303 - Capital Projects Fund Revenues Dept: 990 OthedReservelContingency Acct Class: 390 Other Finanang Sources 399.999 Appropriate Fund Balance 0 0 0 0 0 112,000 Other Financing Sources 0 0 0 0 0 0 112,000 0 OtherlReservelCon6ngency 0 0 0 0 0 0 112,000 0 Total Revenues 0 0 0 0 0 0 112,000 0 Expenditures Dept: 321 North Cypress Drive Acct Class: 600 Capital Outlay 663.652 PathwaylSidewalk Improvements 56,250 0 0 0 0 Capital0utlay 56,250 0 0 0 0 0 0 0 North Cypress Drive 56,250 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 112,000 591.301 Trsf to Capital Imp Fund 0 0 0 0 0 Interfund Transfers Out 0 0 0 0 0 0 112,000 0 Interfund Transfers 0 0 0 0 0 0 112,000 0 Total Expenditures 56,250 0 0 0 0 0 112,000 0 Capital Projects Fund -56,250 0 0 0 0 0 0 0 BUDGET WORKSHEET Wednesday,August22,2012 Page: 25 8122/2012 Village of Tequesta 2:55 pm Prior -------------------- Current Year ------------------- (6) (7) ($) Year Original Amended Actual Thru Estimated Month:913012012 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 600 600 600 600 600 343.301 Water Sales 2,506,074 2,438,000 2,438,000 2,164,914 2,358,000 2,354,000 2,354,000 2,354,000 343.302 Water- Connect Charges 14,226 12,400 12,400 13,246 13,500 13,500 13,500 13,500 343.303 Water-Fire Hydrants Rent 63,367 65,000 65,000 57,373 63,500 63,500 63,500 63,500 343.304 WaterSurcharge 592,415 410,000 410,000 308,555 405,000 405,000 405,000 405,000 343.306 Mond�lyServiceCharge 1,349,184 1,295,000 1,295,000 1,243,824 1,350,000 1,350,000 1,350,000 1,350,000 343.307 Penalty Charges 5,647 4,100 4,100 4,843 5,200 4,200 4,200 4,200 343.308 Other Water Service Income 1,573 2,000 2,000 1,498 1,800 1,800 1,800 1,800 343.309 Convenience Fee- CC 350 0 0 1,314 1,400 343.700 Water Conservation & Resource 472 0 0 661 700 500 500 500 343.950 Allow for doubful rev - Enterp 0 0 0 0 0 ChargesforServices 4,533,308 4,226,500 4,226,500 3,796,828 4,199,700 4,193,100 4,193,100 4,193,100 Acct Class: 361 Unrestricted Investment Earnin 361.100 InteresUlnvestment Eamings 25,020 8,000 8,000 9,108 9,200 7,500 7,500 7,500 361.105 Int Income - Tropic Vista Asse 0 0 0 0 0 Unrestricted Investrnent Eamin 25,020 B 8,000 9,108 9,200 7,500 7,SOQ 7,500 Acct Class: 369 Miscellaneous Revenues 363.101 MartinlTropicV-Constportion 21,979 21,400 21,400 44,975 23,775 19,000 19,000 19,000 369.000 Other Miscellaneous Revenue 57,660 0 0 5 5 369.100 Insurance Reimbursement 4,655 0 0 4,813 4,813 4,000 4,000 4,000 Miscellaneous Revenues 84,294 21,400 21,400 49,793 28,593 23,000 23,000 23,000 Acct Class: 390 Other Finandng Sources 369.110 Capital Connect Charge - Cust 18,144 18,000 18,000 21,003 21,003 18,000 18,000 18,000 369.111 Capital Connect Charge - Devel 9,585 0 0 81,390 85,000 10,000 10,000 10,000 369.112 Capital Connect - Tropic �st 19,593 19,080 19,080 0 21,200 18,000 18,000 18,000 Other Financing Sources 47,322 37,080 37,080 102,393 127,203 46,000 46,000 46,000 General 4,689,944 4,292,980 4,292,980 3,958,122 4,364,696 4,269,600 4,269,600 4,269,600 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investment Earnin 367.100 Net Unreal appreciation (Dep) 0 0 0 9,874 8,350 Unrestncted Investrnent Eamin 0 0 0 9,874 8,350 D 0 0 Other Nonoperating 0 0 0 9,874 8,350 0 0 0 Dept: 990 OthedReservelContingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 0 292,537 0 0 Other Financing Sources 0 0 292,537 0 0 0 0 0 OtherlRese�velConGngency 0 0 292,537 0 0 6 0 0 BUDGET WORKSHEET Wednesday, August 22, 2012 Page: 26 8/22/2012 Village of Tequesta 2:55 pm Prior ----------------- Current Year --------------------- (6) 0) ($) Year Original Amended Actual Thru Estimated Month:9130/2012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Total Revenues 4,689,944 4,292,980 4,585,517 3,967,996 4,373,046 4,269,600 4,269,600 4,269,600 Expenditures Dept: 241 Water-Administra6on Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 113,901 118,900 118,900 102,547 118,745 140,900 140,900 140,900 515.103 Bonus Pay Plan 1,250 0 5,000 5,000 5,000 515.104 Sick Leave Conversion Pay 3,553 0 0 0 0 515.108 Auto Allowance 3,000 3,000 3,000 2,750 3,000 3,000 3,000 3,000 516.100 Compensated Absences 9,189 5,200 5,200 0 4,600 5,000 5,000 5,000 521.101 FICA Taxes 5,576 6,200 6,200 5,397 5,830 7,100 7,100 7,100 521.102 Medicare Taxes 1,879 1,900 1,900 1,675 2,000 2,200 2,200 2,200 522.102 VOT Pension Contributions 10,670 11,200 11,200 9,536 11,050 13,200 13,200 13,200 523.101 Life/Health Insurance 9,954 10,700 10,700 9,639 10,325 12,000 10,300 10,300 524.100 Workers' Comp Insurance 273 310 310 306 306 310 420 310 526.104 ICMA-Def Comp Plan 9,085 9,500 9,500 8,145 9,438 9,900 9,900 9,900 Personal Services 168,330 166,910 171,910 144,995 170,294 193,610 192,020 191,910 Acct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 1,380 7,500 7,500 3,420 5,000 7,500 7,500 7,500 531.302 Engineering Services 58,014 66,870 67,805 21,159 30,000 25,000 25,000 25,000 532.300 Accounting & Auditing Services 30,855 31,800 31,800 31,780 31,780 28,600 29,500 29,500 534.300 Other Contractual Seruices 18,000 18,000 18,000 16,500 18,000 48,000 48,000 18,000 544.304 FEC Lease 11,813 12,000 12,000 8,142 8,142 12,900 12,900 12,900 545.3001nsurance 48,747 48,680 48,680 48,680 48,680 48,680 49,630 48,680 546.320 Computer system maint & suppli 0 1,000 1,000 0 0 549.301 Admin Mgmt Fees 305,700 316,730 316,730 263,938 316,730 326,230 326,230 326,230 549.304 Licenses, Fees & Permits 781 800 800 781 781 800 800 800 Operating E�cpenditureslExpense 475,290 503,380 504,315 394,400 459,113 497,710 499,560 468,610 Water-Administration 643,620 670,290 676,225 539,395 629,407 691,320 691,580 660,520 Dept: 242 Water - Production Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 376,425 389,000 389,000 335,400 376,360 400,100 400,100 400,100 514.100 Overtime 3,908 5,000 5,000 4,951 6,250 5,500 5,500 5,500 515.102 Standby Pay 4,459 5,000 5,000 4,363 5,100 5,000 5,000 5,000 515.104 Sick Leave Conversion Pay 3,145 5,000 0 0 0 515.106 Clothing & Boot Allowance 600 600 600 600 600 600 600 600 516.100 Compensated Absences 0 0 5,000 23,214 23,214 5,000 5,000 5,000 521.101 FICA Taxes 23,625 25,100 25,100 22,156 25,450 25,100 25,500 25,500 521.102 Medicare Taxes 5,525 5,900 5,900 5,182 5,960 5,900 6,000 6,000 522.101 FRS Contributions 13,322 8,400 8,400 7,053 8,160 8,100 8,100 8,100 BUD�ET WORKSHEET Wednesday,August22,2012 Page: 27 812212012 �Ilage of Tequesta 2:55 pm Prior ----------------- Current Year ------------------- �6) �7) �8) Year Original Amended Actual Thru Estimated Month:9130/2012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Expenditures Dept: 242 Water- Production Acct Class: 510 Personal Services 522.102 VOT Pension Contribubons 21,356 22,100 22,100 19,016 22,030 22,800 22,800 22,800 523.101 Life/Health Insurance 64,716 66,400 66,400 57,975 59,010 66,500 68,300 68,300 523.110 Re6ree Health Care E�cpense 4,500 5,000 5,000 0 5,000 5,000 5,000 5,000 524.100 Workers' Comp Insurance 8,774 9,830 9,830 9,825 9,825 9,830 11,280 9,830 554.301 Personnel Training 911 1,500 1,500 310 1,500 1,500 1,500 1,500 PersonalServices 531,266 548,830 548,830 490,045 548,459 560,930 564,680 563,230 Acct Class: 530 Operating Expenditures/E�cpense 531.342 WaterAnalysis & Sampling 44,123 39,000 47,000 42,095 47,000 44,130 44,130 44,130 540.300 Travel & Per Diem 1,423 3,000 3,000 1,009 3,000 3,000 3,000 3,000 541.300 Communication Services 9,628 9,400 9,400 7,587 9,650 9,400 9,400 9,400 541.301 Postage 1,250 1,500 1,900 1,868 1,900 1,500 1,500 1,500 543.300 Utility Services 380,100 420,000 412,000 322,776 390,000 420,000 420,000 420,000 544.301 Operating Leases 9,000 9,500 9,500 8,250 9,000 9,000 9,000 9,000 546.302 Vehicle Repair & Maintenance 2,662 3,000 3,000 2,806 3,000 3,000 3,000 3,000 546.303 Building Repair & Maint 8,234 9,000 9,000 8,912 9,500 9,500 9,500 9,500 546.309 Landscape & Irrigation Maint 2,795 6,000 4,200 1,600 2,700 4,000 3,000 3,000 546.310 Equipment Repair & Maint 18,592 18,000 18,000 17,255 18,000 18,000 18,000 18,000 546.320 Computer system maint & suppli 2,874 2,500 2,500 1,730 2,500 2,500 2,500 2,500 546.342 Water System Maintenance 57,346 60,000 60,OOQ 50,897 60,000 60,000 60,000 60,000 546.343 Well Redevelopment 19,269 25,000 25,000 16,490 25,000 25,000 25,000 25,000 549.30� OtherMiscChgs80bligations 956 1,000 1,900 1,401 1,900 2,000 2,000 2,000 549.304 Licenses, Fees & Permits 27,822 30,000 30,000 23,069 30,000 30,000 30,000 30,000 551.300 Office Supplies & Equipment 2,472 2,500 2,500 2,056 2,500 2,500 2,500 2,500 552.301 Gas & Oil 6,207 6,000 6,000 6,039 6,700 8,100 8,100 8,100 552.302 Small Tools and Equipment 4,231 3,000 3,000 2,844 3,000 3,000 3,000 3,000 552.303 Diesel Fuel 5,578 15,000 15,000 8,386 8,386 15,000 15,000 15,000 552.305 Uniforms 1,281 1,300 1,300 1,199 1,199 1,200 1,200 1,200 552.341 Water Purchases 0 30,000 30,000 0 0 30,000 30,000 30,000 552.3A2 Water Chemicals 184,933 245,000 245,000 127,095 175,000 245,000 235,000 235,000 552.343 Laboratory Supplies 11,584 12,000 12,000 11,874 13,000 13,000 13,000 13,000 554.300 Books, Publ, Subs & Membership 1,062 1,500 1,500 1,271 1,500 1,500 1,500 1,500 Operating ExpenditureslExpense 803,422 953,200 952,700 668,509 824,435 960,330 949,330 949,330 Water- Production 1,334,688 1,502,030 1,501,530 1,158,554 1,372,894 1,521,260 1,514,010 1,512,560 Dept: 243 Water-Distribution Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 401,374 396,400 397,000 342,820 397,000 408,500 408,500 408,500 514.100 Overtime 5,599 6,000 6,000 3,622 6,000 6,200 6,200 6,200 BUDGET WORKSHEET Wednesday,August22,2012 Page: 28 8122/2012 Village of Tequesta 2:55 pm Prior ---------------------- Current Year -------------------- ( l�) ( Year Original Amended Actual Thru Estimated Month:913012012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 401- Water Fund Expenditures Dept: 243 Water-Distribu6on Acct Class: 510 Personal Services 515.102 Standby Pay 6,734 6,600 6,600 6,132 6,600 6,800 6,800 6,800 515.104 Sick Leave Conversion Pay 1,852 2,000 0 0 0 515.106 Clothing & Boot Allowance 600 600 600 600 600 600 600 600 515.107 Part-time Salaries 1,958 21,800 22,800 16,285 22,800 42,600 42,600 42,600 515.108 Auto Allowance 4,000 4,800 4,800 4,400 4,800 4,800 4,800 4,800 516.100 Compensated Absences 0 0 2,000 0 2,000 2,500 2,500 2,500 521.101 FICA Taxes 25,489 27,200 27,200 22,309 26,200 28,400 28,900 28,900 521.102 Medicare Taxes 5,961 6,400 6,400 5,218 6,150 6,700 6,800 6,80Q 522.101 FRS Contribu6ons 11,665 7,200 7,200 5,663 6,600 7,200 7,200 7,200 522.102 VOT Pension Contribu6ons 25,905 25,400 25,400 21,742 25,200 26,200 26,200 26,200 523.101 LifelHealth Insurance 74,807 71,600 69,400 63,587 69,105 71,800 74,400 74,400 523.110 Retiree Health Care Expense 4,500 5,000 5,000 0 5,000 5,000 5,000 5,000 524.100 Workers' Comp Insurance 8,396 9,410 9,410 9,404 9,404 9,410 10,920 9,410 525.100 Unemployment Compensation 0 0 5,500 5,500 5,500 554.301 Personnel Training 660 1,500 75 75 75 1,500 1,500 1,500 PersonalServices 579,500 591,910 595,385 507,357 593,034 628,210 632,920 631,410 Acct Class: 530 Operating ExpenditureslExpense 540.300 Travel & Per Diem 53 500 100 0 100 500 500 500 541.300 Communication Services 6,337 7,200 7,680 5,046 7,680 7,680 7,680 7,680 541.301 Pastage 15,007 23,004 20,500 16,587 20,100 23,000 23,000 23,000 544.301 Operafing Leases 2,094 2,500 2,500 2,174 2,500 4,500 4,500 4,500 546.301 Office EquiplRepair & Maint 146 650 650 27 200 200 200 200 546.302 Vehicle Repair & Maintenance 2,727 7,000 7,000 3,468 6,500 7,000 7,000 7,000 546.303 Building Repair & Maint 2,353 3,500 5,500 4,262 5,500 6,000 4,000 4,000 546.309 Landscape & Irrigation Maint 149 900 800 438 800 900 900 900 546.310 Equipment Repair 8 Maint 6,336 1,000 4,000 3,901 4,000 5,000 5,000 5,000 546.320 Computer system maint & suppli 7,723 7,400 7,920 6,814 7,920 6,920 6,920 6,920 546.342 Water System Maintenance 20,940 22,000 21,000 21,401 22,400 24,000 24,000 24,000 546.344 New Service Connection Expense 788 1,000 650 251 650 1,000 1,000 1,000 547.300 Printing & Binding 0 0 3,000 2,561 3,000 3,000 3,000 3,000 549.300 Other Misc Chgs & Obligations 1,923 2,000 1,000 442 1,000 2,500 2,500 2,500 549.304 Licenses, Fees & Permits 1,424 1,600 1,600 1,530 1,600 1,700 1,700 1,700 551.300 Office Supplies 8 Equipment 1,540 1,500 1,500 1,385 1,500 1,500 1,500 1,500 551.310 Printing & Binding 2,350 3,000 0 0 0 552.301 Gas & Oil 12,462 19,000 15,325 11,258 14,425 19,000 19,000 19,000 552.302 Small Tools and Equipment 1,351 3,000 3,350 3,266 3,350 3,000 3,000 3,000 BUDGET WORKSHEET Wednesday,August22,2012 Page: 29 812212012 Village of Tequesta 2:55 pm Prior --------------------- Current Year -----�__------------- (s) ( ( Year Original Amended Actual Thru Estimated Month:913012012 Actual Budget Budget September 7otal DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Expenditures Dept: 243 Water-Distribution Acct Class: 530 Operating ExpenditureslExpense 552.305 Uniforms 1,422 2,400 1,600 1,293 1,600 2,400 2,400 2,400 Operating ExpenditureslExpense 87,125 109,150 105,675 86,104 104,825 119,800 117,800 117,800 Water-Distribution 666,625 701,060 701,060 593,461 697,859 748,010 750,720 749,210 Dept: 411 Renewal & Replacement Acct Class: 530 Operating E�cpenditures/Expense 546.605 R&M - Well Site Rehab 6,452 6,000 6,500 6,384 6,500 6,000 4,000 4,000 549.671 Misc. Renewal & Replacement 17,867 40,000 22,301 16,059 22,300 37,300 37,300 37,300 552.601 Meters, Valves 8 Hydrants 6,275 25,000 37,420 22,555 37,420 25,000 25,000 25,000 552.603 Filter CartridgeslROP 4,550 7,000 7,000 6,903 7,000 7,000 7,000 7,000 552.610 R.0 Membrane Replacement 0 0 0 0 0 Operating ExpenditureslExpense 35,144 78,000 73,221 51,901 73,220 75,300 73,300 73,300 Acct Class: 600 Capital Outlay 663.671 Misc. Renewel and Replacement 0 80,000 0 0 0 575,000 575,000 664.600 MachlEquipment 0 40,000 103,003 101,860 103,001 15,000 664.602 Vehicles 0 0 0 0 0 26,000 26,000 26,000 Capital0utlay 0 120,000 103,003 101,860 103,001 41,000 601,000 601,000 Renewal8 Replacement 35,144 198,000 176,224 153,761 176,221 116,300 674,300 674,300 Dept: 412 Capital Improvement Acct Class: 600 Capital Outlay 663.600 Improvements other than Bldgs 0 50,000 50,000 0 50,000 664.600 MachlEquipment 0 300,000 429,500 15,335 400,000 CapitalOuUay 0 350,000 479,500 15,335 450,000 0 0 0 Capitallmprovement 0 350,000 479,500 15,335 450,000 0 0 0 Dept: 414 Capital Expansion Projects Acct Class: 600 Capital Outlay 662.710 Water plant expansion 0 0 169,228 133,222 130,058 665.632 Eng - RO WTP Expansion 0 0 10,150 10,150 10,150 Capital0utlay 0 0 179,378 143,372 140,208 0 0 0 Capital Expansion Projects 0 0 179,378 143,372 140,208 0 0 0 Dept: 700 Debt Service Acct Class: 471 DIS - Principal 571.705 Prin - 2004 Water NIP BOA 0 27,000 27,000 27,000 27,000 29,000 29,000 29,000 571.720 Prin - 2008 Water Utiliry Note 0 255,900 255,900 234,122 255,830 267,250 267,250 267,250 D/S - Principal 0 282,900 282,900 261,122 282,830 296,250 296,250 296,250 Acct Class: 472 D/S - Interest 572.705 Int - 2004 Water N/P BOA 17,591 16,900 16,900 9,831 16,200 14,800 14,800 14,800 572.720 Int-2008 WaterU6liry Note 184,362 212,700 212,700 177,242 212,671 202,400 202,400 202,400 573.700 Other Debt Service Costs 24,033 25,000 25,000 0 25,000 25,000 25,000 25,000 BUDGET WORKSHEET Wednesday, August 22, 2012 Page: 30 8122/2012 �Ilage of Tequesta 2:55 pm Prior ---------------------- Current Year -----------_____° �g) ��) (g) Year Original Amended Actual Thru Estimated Month:9130/2012 Actual Budget 9udget September Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Expenditures Dept: 700 Debt Service DIS-Interest 225,986 254,600 254,600 187,073 253,871 242,200 242,200 242,200 DebtService 225,986 537,500 537,500 448,195 536,701 538,450 538,450 538,450 Dept: 910 Other Finanang Sources & Uses Acct Class: 590 Other Financing Sources & Uses 567.000 GainlLoss on Investments 0 0 0 0 0 567.100 Unrealized Loss on Inveshnents 0 0 0 0 0 Other Financing Sources 8 Uses 0 0 0 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Dept: 950 Other Nonoperating Acct Class: 530 Operating Expenditures/Expense � 559.300 Depreciation 912,966 0 0 0 0 559.301 Budgeted Depreciation (netted) 0 322,100 322,100 0 300,000 Operating Expenditures/Expense 912,966 322,100 322,100 0 300,000 0 0 0 Acct Class: 590 Other Financing Sources 8 Uses 549.391 Bank Charges 10,301 12,000 12,000 7,996 12,000 10,000 10,000 10,000 549.395 Credit Card Fees and Charges 0 0 0 0 0 2,000 2,000 2,000 590.001 Allocate to Fund Balance 0 0 0 0 57,756 88,540 999.001 Suspense 0 0 0 0 0 999.200 Suspense - AIP 0 0 0 0 0 Other Financing Sources 8 Uses 10,301 12,000 12,000 7,996 69,756 12,000 100,540 12,000 OtherNonoperating 923,267 334,100 334,100 7,996 369,756 12,000 100,540 12,000 Dept: 990 OtherlReservelContingency Acct Class: 590 Other Financing Sources 8 Uses 599.902 Reserves - Contingency 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 OthedReserve/Con6ngency 0 0 0 0 0 0 0 0 Total ExpendiWres 3,829,330 4,292,980 4,585,517 3,060,069 4,373,046 3,627,340 4,269,600 4,147,040 WaterFund 860,614 0 0 907,927 0 642,260 0 122,560 BUDGET WORKSHEET Wednesday,August22,2012 Page: 31 812212012 Village of Tequesta 2:55 pm Prior -------------------------- Current Year ----------------- �6) ��) �8) Year Original Amended Actual Thru Estimated Month:9/30/2012 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 21,993 0 0 11,559 7,600 7,500 7,500 7,500 Intergovemmental Revenue 21,993 0 0 11,559 7,600 7,500 7,500 7,500 Acct Class: 340 Charges for Seroices 343.307 Penalry Charges 1 0 0 2 0 343.400 Refusel Recyding Fees 414,147 474,535 474,535 470,149 470,085 472,410 472,410 472,410 ChargesforServices 414,148 474,535 474,535 470,151 470,085 472,410 472,410 472,410 Acct Class: 361 Unrestricted Investment Earnin 361.100 InteresUlnvestmentEarnings 840 270 270 152 200 200 200 200 361.101 PBC Tax Col-Interest on Dep 52 50 50 207 175 100 100 100 361.300 Net Change in FMV 0 0 0 0 0 UnresUicted Investment Earnin 892 320 320 359 375 300 300 300 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 4,670 4,670 4,670 Other Financing Sources 0 0 0 0 0 4,670 4,670 4,670 Generel 437,033 474,855 474,855 482,069 478,060 484,880 484,880 484,880 Dept: 950 Other NonoperaGng Acct Class: 361 Unrestricted Investment Earnin 367.100 Net Unreal appreciation (Dep) 0 500 500 562 500 300 300 300 Unrestricted Investment Earnin 0 500 500 562 500 300 300 300 OtherNonoperating 0 500 500 562 500 300 300 300 Total Revenues 437,033 475,355 475,355 482,631 478,560 485,180 485,180 485,180 Expenditures Dept: 245 Refuse and Recycling Acct Class: 530 Operating ExpenditureslExpense 531.301 LegalServices 322 500 500 0 500 500 500 500 543.302 Solid WastelResidential 235,555 245,207 245,096 204,096 244,916 248,860 248,860 248,860 543.303 RecyclinglResiden6al 82,866 86,262 86,373 71,978 86,373 87,770 87,770 87,770 543.304 Yard Waste/Residential 78,263 81,469 81,469 67,819 81,383 82,700 82,700 82,700 543.306 Fuel Factor 40,666 54,523 54,523 40,947 49,137 57,750 57,750 57,750 549.300 Other Misc Chgs & Obligations 180 750 750 185 750 750 750 750 549.301 Admin Mgmt Fees 6,450 6,644 6,644 5,537 6,644 6,850 6,650 6,850 Operating ExpenditureslExpense 444,302 475,355 475,355 390,562 469,703 485,180 485,180 485,180 Refuse and Recycling 444,302 475,355 475,355 390,562 469,703 485,180 485,180 485,180 Dept: 910 Other Financing Sources 8 Uses Acct Class: 590 Other Financing Sources & Uses BUDGET WORKSHEET Wednesday,August22,2012 Page: 32 8122l2012 Village of Tequesta 2:55 pm Prior ----_____�_��---- Current Year ------------------- (s) l�) � Year Original Amended Actual Thru Estimated Month:913012012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 402 - Refuse & Recycling Expenditures Dept: 910 Other Financing Sources 8 Uses Acct Class: 590 Other Financing Sources & Uses 567.000 GaiNLoss on Investments 0 0 0 0 0 567.100 Unrealized Loss on Investrnents 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 Other Financing Sources & Uses 590.001 Allocate to Fund Balance 0 0 0 0 8,857 Other Financing Sources & Uses 0 0 0 0 8,857 0 0 0 Other Nonoperating 0 0 0 0 8,857 0 0 0 Total Expenditures 444,302 475,355 475,355 390,562 478,560 485,180 485,180 485,180 Refuse & Recycling -7,269 0 0 92,069 0 0 0 0 BUDGET WORKSHEET Wednesday,August22,2012 Page: 33 8122I2012 �Ilage of Tequesta 2:55 pm Prior -------------------- Current Year ------------------- l6) l�) la) Year Original Amended Actual Thru Estimated Month:913012012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 403 - Stormwater Utiliiy Revenues Dept: 000 General Acct Class: 340 Charges for Services 343.901 Storm Water Utiliry Fees 314,264 323,350 323,350 318,488 318,488 318,000 318,000 ChargesforServices 314,264 323,350 323,350 318,488 318,488 0 318,000 318,000 Acct Class: 361 Unrestricted Investment Eamin 361.100 InteresUlnvestment Earnings 2,122 1,100 1,100 923 836 1,100 1,100 361.101 PBC Tax Col-Interest on Dep 40 0 0 163 139 361.300 Net Change in fMV 0 0 0 0 0 UnrestrictedlnvestmentEarnin 2,162 1,100 1,100 1,086 975 0 1,100 1,100 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 330 0 0 0 0 Miscellaneous Revenues 330 0 0 0 0 0 0 0 General 316,756 324,450 324,450 319,574 319,463 0 319,100 319,100 Dept: 950 Other NonoperaGng Acct Class: 361 Unrestricted Investrnent Earnin 367.100 Net Unreal appreciation (Dep) 0 0 0 583 0 UnresUicted Investment Earnin 0 0 0 583 0 0 0 0 Other Nanoperating 0 0 0 583 0 0 0 0 Dept: 990 OthedReservelCon6ngency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balanee 0 258,130 339,863 0 215,241 Other Financing Sources 0 258,130 339,863 0 215,241 0 0 0 OtherlReseruelContingency 0 258,130 339,863 0 215,241 0 0 0 Total Revenues 316,756 582,580 664,313 320,157 534,704 0 319,100 319,100 Expenditures Dept: 250 Storm Water Utilities Acct Class: 510 Personal Services 512.100 Regular Salaries 8 Wages 30,450 31,200 32,710 28,227 32,710 33,800 33,800 33,800 514.100 Overtime 731 1,000 1,000 735 1,000 1,000 1,000 1,000 515.102 Standby Pay 1,331 1,400 1,400 1,237 1,400 1,400 1,400 1,400 515.106 Clothing & Boot Allowance 100 100 100 100 100 100 100 100 516.100 Compensated Absences 563 0 0 0 0 521.101 FIGA Taxes 1,904 2,100 2,100 1,688 2,100 2,100 2,200 2,200 521.102 Medicare Taxes 445 500 500 395 500 500 500 500 522.102 VOT Pension Contributions 2,862 3,000 3,075 2,653 3,075 3,200 3,200 3,200 523.101 LifelHealth Insurance 11,250 11,800 11,800 10,848 11,800 11,900 12,400 12,400 524.100 Workers' Comp Insurance 794 890 890 886 890 890 1,100 890 525.100 Unemployment Compensation 825 0 0 0 0 554.301 Personnel Training 250 500 0 0 0 500 500 500 BUDGET WORKSHEET Wednesday, August 22, 2012 Page: 34 812212012 Village of Tequesta 2:55 pm Prior -------------------- Current Year ------------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:913012012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 403 - Stormwater U61ity Expenditures Dept: 250 Storm Water Utilities Personal Services 51,505 52,490 53,575 46,769 53,575 55,390 56,200 55,990 Acct Class: 530 Operating Expenditures/Expense 531.302 Engineering Services 0 2,000 11,000 8,740 16,000 5,000 5,000 5,000 532.300 Accounting & Auditing Services 4,320 4,450 4,450 4,449 4,450 4,000 4,100 4,100 540.300 Travel & Per Diem 0 200 0 0 0 300 300 300 541.300 Communication Services 1,657 1,600 1,705 1,357 1,705 1,750 1,750 1,750 541.301 Postage 0 300 300 0 0 300 300 300 546.302 Vehide Repair & Maintenance 729 600 600 376 600 800 800 800 546.303 Building Repair & Maint 584 2,000 2,000 56 2,000 2,000 2,000 2,000 546.308 Drainage Maintenance 12,514 38,000 28,010 11,503 13,000 25,000 25,000 25,000 546.310 EquipmentRepair & Maint 4,760 1,500 1,500 1,467 1,500 1,500 1,500 1,500 546.320 Computer system maint & suppli 384 700 700 214 700 700 700 700 549.300 Other Misc Chgs 8 Obligations 213 900 900 227 900 1,000 1,000 1,000 549.301 AdminMgmtFees 10,960 11,290 11,290 9,408 11,290 11,630 11,630 11,630 549.304 Licenses, Fees & Permits 2,486 3,000 3,000 2,951 2,951 3,500 3,500 3,500 551.300 Office Supplies & Equipment 184 300 300 177 300 300 300 300 552.301 Gas & Oil 2,455 3,000 3,000 2,033 2,500 3,000 3,000 3,000 552.302 Small Tools and Equipment 240 1,000 1,000 611 1,000 1,200 1,200 1,200 554.100 Public Educa6on Program 0 500 500 177 500 500 500 500 Operating Expenditures/Expense 41,486 71,340 70,255 43,746 59,396 62,480 62,580 62,580 Acct Class: 600 Capital Outlay 662.632 Architect & Engeering 0 0 27,550 14,386 27,550 663.663 Drainage Improvements 0 330,000 373,175 7,200 313,175 664.600 Mach/Equipment 0 10,000 21,008 21,008 21,008 CapitalOuUay 0 340,000 421,733 42,594 421,733 0 0 0 Storm Water UtiliGes 92,991 463,830 545,563 133,109 534,704 117,870 118,780 118,570 Dept: 340 Swale ConsVuction Acct Class: 600 Capital Qutlay 663.663 Drainage Improvements 0 0 0 0 0 Capital0utlay 0 0 0 0 0 0 0 0 Swale Construction 0 0 0 0 0 0 0 0 Dept: 910 Other Financing 5ources 8 Uses Acct Class: 590 Other Financing Sources 8 Uses 567.100 Unrealized Loss on Investments 0 0 0 0 0 Other Financing Sources 8 Uses 0 0 0 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Dept: 950 Other Nonoperating Acct Class: 530 Operating Expenditures/Expense 559.300 Deprecia6on 101,340 118,750 118,750 0 0 BUDGET WORKSHEET Wednesday, August 22, 2012 Page: 35 812212012 Village of Tequesta 2:55 pm Prior ------------------------- Current Year ------------------- �s) ��) � Year Original Amended Actual Thru Estimated Month:9/30l2012 Actual Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 403 - Stormwater Utiliry Expenditures Dept: 950 Other Nonoperating Acct Class: 530 Operating ExpenditureslExpense 559.301 Budgeted Depreciation (netted) 0 0 0 0 0 Operating Expenditures/Expense 101,340 118,750 118,750 0 0 0 0 0 Acct Class: 590 OtherFinancing Sources & Uses 590.001 Allocate to Fund Balance 0 0 0 0 0 200,320 Other Financing Sources & Uses 0 0 0 0 0 0 200,320 0 OtherNonoperating 101,340 11&,750 118,750 0 0 0 200,320 0 Dept: 990 OtherlReservelContingency Acct Class: 590 Other Financing Sources & Uses 599.902 Reseroes - Contingency 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 OtherlReserve/Con6ngency 0 0 0 0 0 0 0 0 7otal Expenditures 194,331 582,580 664,313 133,109 534,704 117,870 319,100 118,570 Stormwater Utility 122,425 0 0 187,048 0 -117,870 0 200,530 GrandTotal: 191,928 0 0 1,039,420 0 -1,316,825 0 -542,130 BUDGET WORKSHEET Page: 1 812212012 Village of Tequesta 331 pm Prior ------ Current Year ------------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:813112012 Actual Budget Budget August Total DEPARTMENT MANAGER COUNCIL Fund: 605 - Special Law Enforcement Revenues Dept: 171 Police Acct Class: 369 Miscellaneous Revenues 359.100 ForfeitureslConfiscations 25,699 50,000 50,000 14,273 50,000 50,000 50,000 Miscellaneous Revenues 25,699 50,000 50,000 14,273 50,000 0 50,000 50,000 Police 25,699 50,000 50,000 14,273 50,000 0 50,000 50,000 Dept: 950 Other NonoperaGng Acct Class: 361 Unrestricted Investment Eamin 367.100 Net Unreal appreciation (Dep) 0 0 0 0 0 Unrestricted Investment Earnin 0 0 0 0 0 0 0 0 Other Nonoperating 0 0 0 0 0 0 0 0 Dept: 990 OthedReservelContingency Acct Class: 390 Other Finaocing Sources 399.999 Appropriate Fund Balance 0 1,000 1,000 0 1,000 1,000 1,000 1,000 Other Financing Sources 0 1,000 1,000 0 1,000 1,000 1,000 1,000 OthedReservelContingency 0 1,000 1,000 0 1,000 1,000 1,000 1,000 Total Revenues 25,699 51,000 51,000 14,273 51,000 1,000 51,000 51,000 Expenditures Dept: 000 General Acct Class: 530 Operating ExpenditureslExpense 554.300 Books, Publ, Subs & Membership 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 Operating ExpenditureslExpense 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 Acct Class: 591 Interfund Transfers Out 591.001 Transfer to General Fund 0 50,000 50,000 0 50,000 50,000 50,000 Interfund Transfers Out 0 50,000 50,000 0 50,000 0 50,000 50,000 General 1,000 51,000 51,000 1,000 51,000 1,000 51,000 51,000 Dept: 171 Police Acct Class: 530 Operating ExpenditureslExpense 549.304 Licenses, Fees & Pertnits 0 0 0 0 0 Operating ExpenditureslExpense 0 0 0 0 0 0 0 0 Police 0 0 0 0 0 0 0 0 Total Expenditures 1,000 51,000 51,000 1,000 51,000 1,000 51,000 51,000 Special Law Enforcement 24,699 0 0 13,273 0 0 0 0 Grand Total: 24,699 0 0 13,273 0 0 0 0