Loading...
HomeMy WebLinkAboutDocumentation_Workshop_Tab 03_06/30/2014 BUDGET WORKSHEET June 30, 201411:49 am Page: 1 6130/2014 Village of Tequesta 11:49 am Prior ------------- Current Year ------------ (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June 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,337,570 4,759,000 4,759,000 4,655,929 4,760,000 5,019,000 5,019,000 311.100 Ad Valorem Taxes-Del 1,644 5,000 5,000 8,369 8,369 5,000 5,000 General Property Taxes 4,339,214 A,764,000 4,764,000 4,664,298 4,768,369 5,024,000 5,024,000 0 Acct Class: 316 Sales 8 Use Taxes 314.100 Utility Tax-Electriciiy 467,498 430,000 430,000 316,858 470,000 470,000 470,000 314.300 Utility Tax-Water 156,360 156,000 156,000 109,055 160,000 160,000 160,000 314.800 Utility Tax-Propane 20,618 24,000 24,000 24,444 30,000 30,000 30,000 315.000 Comm.Services Tax (CST) 344,204 333,360 333,360 217,981 325,000 325,000 325,000 321.000 Local Business Tax (Occ Lic) 71,695 71,000 71,000 71,997 72,100 72,000 72,000 321.001 Home Business Tax 4,500 4,500 4,500 5,494 5,494 4,500 4,500 321.010 LocalBusiness Tax- County 7,880 4,500 4,500 4,661 4,661 4,600 4,600 Sales&UseTaxes 1,072,755 1,023,360 1,023,360 750,490 1,067,255 1,066,100 1,066,100 0 Acct Class: 318 Franchise fees - gross receipt 313.100 Fran Fees-Electric 3&Q,160 392,�0o 392,000 262,751 390,000 414,000 414,000 Franchise fees - gross receipt 380,160 392,000 392,000 262,751 390,000 414,000 414,000 0 Acct Class: 329 Intragovemmental Revenue 341.401 Admin Mgmt Fees-Water 485,229 499,785 499,785 374,839 499,785 514,780 514,780 341.402 Admin Mgmt Fee-Ref & Recycling 6,850 7,055 7,055 5,291 7,055 7,270 7,270 341.403 Admin Mgmt Fees - Storm Water 11,630 11,978 11,978 8,983 11,978 12,340 12,340 369.010 Misc Revenue - Hats 0 0 0 357 357 Intragovemmental Revenue 503,709 518,818 518,818 389,470 519,175 534,390 534,390 0 Acct Class: 331 Grants Federal 314.400 U61ity Tax - Natural Gas 0 0 0 22 22 Grants Federal 0 0 0 22 22 0 0 0 Acct Class: 335 Intergovemmental Revenue 335.120 Municipal Revenue Sharing Prog 173,789 174,500 174,500 129,693 176,000 176,000 176,000 335.150 Alcoholic Beverage Licenses 5,576 5,000 5,000 6,111 6,120 6,000 6,000 335.180 Loc Gov 1/2 Cent Sales Tax Pro 388,009 398,300 398,300 284,456 405,000 405,000 405,000 338.101 Local Gas 7ax-6 Cent 114,868 116,900 116,900 78,317 116,000 116,000 116,000 338.102 Local Gas Tax 1-5 Cent 53,682 54,000 54,000 37,769 56,000 56,000 56,000 338.110 Recycling Shared Rev - SWA 0 0 0 0 0 IntergovernmentalRevenue 735,924 748,700 748,700 536,346 759,120 759,000 759,000 0 Acct Class: 341 Chgs for Serv - Gen Gov 341.101 CertificationlCopyFees 11,895 10,000 10,000 9,577 10,000 10,000 10,000 341.103 Election qualifying fees 60 150 150 90 90 341.105 Admin fees from other Gov'ts 1,664 1,000 1,000 1,054 1,200 1,200 1,200 ChgsforServ- Gen Gov 13,619 11,150 11,150 10,721 11,290 11,200 11,200 0 Acct Class: 362 Rents & Royalties BUDGET WORKSHEET June 30, 201411:49 am Page: 2 6/30/2014 Village of Tequesta 11:49 am Prior ---------- Current Year ------------ (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30(2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Revenues Dept: 000 General Acct Class: 362 Rents & Royalties 362.110 Lease-Sprint 35,053 34,190 34,190 27,078 34,190 37,187 37,187 362.112 Lease-T-Mobile 48,850 50,800 50,800 38,008 50,800 52,836 52,836 362.115 Lease - Nextel 26,947 0 0 0 0 362.116 Lease-AT&T 30,000 30,000 30,000 25,000 30,000 30,000 30,000 362.117 Lease- Verizon 0 0 0 0 0 66,000 66,000 Rents & Royalties 140,850 114,990 114,990 90,086 114,990 186,023 186,023 0 Acct Class: 366 Contributions & Donations 366.100 Contrib & Donations & Sponsors 1,525 0 0 0 0 Contributions & Donations 1,525 0 0 0 0 0 0 0 Acct Class: 369 Miscellaneous Revenues 364.100 Disposition of Assets 0 0 0 0 0 369.000 Other Miscellaneous Revenue 13,610 0 18,000 23,843 24,000 8,000 8,000 369.100 Insurance Reimbursement 31,014 15,500 15,500 28,683 28,683 15,500 15,500 Miscellaneous Revenues 44,624 15,500 33,500 52,526 52,683 23,500 23,500 0 General 7,232,380 7,588,518 7,606,518 6,756,710 7,682,904 8,018,213 8,018,213 0 Dept: 150 Comprehensive Planning Acct Class: 340 Charges for Services 341.150 Land Development Fees 35,276 35,000 35,000 25,841 35,000 35,000 35,000 343.700 Water Conservation & Resource 822 0 0 503 503 Charges for Services 36,098 35,000 35,000 26,344 35,503 35,000 35,000 0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 0 0 0 0 0 Misceilaneous Revenues 0 0 0 0 0 0 0 0 Comprehensive Planning 36,098 35,000 35,000 26,344 35,503 35,000 35,000 0 Dept: 171 Police Acct Class: 316 Sales & Use Taxes 312.520 Casualty Insurance Premium Tax 76,177 0 0 0 0 Sales & Use Taxes 76,177 0 0 0 0 0 0 0 Acct Class: 320 Licenses & Permits 329.101 Alarm Permits 6,440 0 0 0 0 329.102 Special Truck Permits 68 0 0 15 15 329.105 Golf Cart Permits 0 700 700 0 0 Licenses & Permits 6,508 700 700 15 15 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 D 0 0 Acct Class: 335 Intergovernmental Revenue 338.201 PBC 911 Maint Reimbursement 0 8,000 8,000 0 8,000 8,000 8,000 BUDGET WORKSHEET June 30, 201411:49 am Page: 3 6/30/2014 Village of Tequesta 11:49 am Prior ------------ Current Year ------------ (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6130/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Revenues Dept: 171 Police Acct Class: 335 Intergovemmental Revenue 338.202 PBC 911 DISPATCH REIMBURSEMENT 13,353 26,000 26,000 27,428 27,428 19,320 19,320 Intergovemmental Revenue 13,353 34,000 34,000 27,428 35,428 27,320 27,320 0 Acct Class: 337 Grants & Contributions - Local 366.122 Donations -Military to Main St 0 0 0 15,000 15,000 Grants 8� Contributions - Local 0 0 0 15,000 15,000 0 0 0 Acct Class: 342 Chgs for Serv - Public Safeiy 342.110 PBC - Marine law enforce. serv 18,681 18,500 18,500 9,100 9,100 Chgs for Serv - Public Safety 18,681 18,500 18,500 9,100 9,100 0 0 0 Acct Class: 351 Fines & Forfeitures 351.100 CourtFines 7,178 15,000 15,000 3,471 3,471 2,000 2,000 354.101 ParkingTickets 1,440 800 800 770 800 800 800 354.102 Code Enf Fines & Court Costs 9,158 9,000 9,000 23,863 24,000 Fines & Forfeitures 17,776 24,800 24,800 28,104 28,271 2,800 2,800 0 Acct Class: 363 Impact Fees 362.221 Police Impact Fees 378 0 0 126 126 Impact Fees 378 0 0 126 126 0 0 0 Acct Class: 366 Conhibutions & Donations 366.100 Confib & Donations & Sponsors 0 0 0 0 0 Contributions & Donations 0 0 0 0 0 0 0 0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 3,138 0 0 510 500 Miscellaneous Revenues 3,138 0 0 510 500 0 0 0 Police 136,011 78,000 78,000 80,283 88,440 30,120 30,120 0 Dept: 175 Police Department Acct Class: 369 Miscellaneous Revenues 359.100 Forfeitures/Confiscations 153 0 0 0 0 Miscellaneous Revenues 153 0 0 0 0 0 0 0 Police Department 153 0 0 0 0 0 0 0 Dept: 180 Building & Zoning Acct Class: 320 Licenses & Permits 322.000 Building Permit Fees 308,830 322,500 322,500 339,365 340,000 363,040 363,040 329.000 Contractor's Registration 8,975 9,750 9,750 7,850 9,750 9,700 9,700 329.010 Contractor Reg. - County 6,256 6,000 6,000 2,750 5,000 5,000 5,000 Licenses & Permits 324,061 338,250 338,250 349,965 354,750 377,740 377,740 0 Acct Class: 351 Fines & Forfeitures 354.102 Code Enf Fines & Court Costs 0 0 0 0 0 4,500 4,500 Fines 8 Forfeitures 0 0 0 0 0 4,500 4,500 0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 0 0 0 60 60 BUDGET WORKSHEET June 30, 201411:49 am Page: 4 6/30/2014 Village of Tequesta 11:49 am Prior ------------- Current Year -------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - �eneral Fund Revenues Dept: 180 Building & Zoning Miscellaneous Revenues 0 0 0 60 60 0 0 0 Building & Zoning 324,061 338,250 338,250 350,025 354,810 382,240 382,240 0 Dept: 192 Fire Control Acct Class: 316 Sales & Use Taxes 312.510 Fire Insurance Prem Tax 117,996 154,700 118,000 0 118,000 118,000 118,000 Sales & Use Taxes 117,996 154,700 118,000 0 118,000 118,000 118,000 0 Acct Class: 334 Grants - State 337.201 State EMS GRANT 48,600 0 0 0 0 Grants - State 48,600 0 0 0 0 0 0 0 Acct Class: 335 Intergovemmental Revenue 335.201 Fire Incentive Pay 3,451 3,600 3,600 1,875 3,600 3,600 3,600 IntergovernmentalRevenue 3,451 3,600 3,600 1,875 3,600 3,600 3,600 0 Acct Class: 340 Charges for Services 342.192 Fire - Extra Duty 0 500 500 325 500 500 500 342.201 Fire Plan Review Fees 20,631 21,000 21,000 45,245 54,600 42,000 42,000 342.202 Fire Inspections 25,806 22,990 22,990 17,445 23,500 23,720 23,720 342.401 Emergency Service-JIC 222,502 400,000 400,000 300,000 400,000 400,000 400,000 342.402 Fire Rescue-CPR Program 915 700 700 710 710 700 700 342.410 Emergency Svc- PBC Fire Rescue 184,000 189,520 189,520 189,520 189,520 195,206 195,206 342.600 EMS Transportation Fees 300,069 290,700 290,700 201,792 292,500 315,000 315,000 342.950 Allow for doubtful rev- GovFnd 0 0 0 0 0 ChargesforServices 753,923 925,410 925,410 755,037 961,330 977,126 977,126 � Acct Class: 363 Impact Fees 362.222 Fire Impact Fees 520 500 500 173 500 500 500 ImpactFees 520 500 500 173 500 500 500 0 Acct Class: 366 Contributions 8 Donations 366.100 Contrib & Donations & Sponsors 110 500 500 130 200 250 250 Contributions & Donations 110 500 500 130 200 250 250 0 Acct Class: 369 Miscellaneous Revenues 365.102 Fire Dept Sales 43 50 50 57 50 50 50 369.000 Other Miscellaneous Revenue 11,836 600 600 2,669 2,700 600 1,600 Miscellaneous Revenues 11,879 650 650 2,726 2,750 65� 1,650 0 FireControl 936,479 1,085,360 1,048,660 759,941 1,086,380 1,100,126 1,101,126 0 Dept: 210 Public Works Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 4,480 0 0 0 0 Miscellaneous Revenues 4,480 0 0 0 0 0 0 0 Public Works 4,480 0 0 0 0 0 0 0 Dept: 231 Leisure Services BUDGET WORKSHEET June 30, 201411:49 am Page: 5 6I30/2014 Village of Tequesta 11:49 am Prior ----------- Current Year ----------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Revenues Dept: 231 Leisure Services Acct Class: 347 Charges for Services - Recr. 347.100 Tequesta Fest 18,891 0 0 7,774 7,774 7,800 7,800 347.190 Special Events-Other 12,522 9,000 9,000 11,041 11,041 9,000 10,000 347.201 Winter/Summer Camp Fees 39,636 47,000 47,000 28,970 32,000 32,000 32,000 347205 Recreation Programs Fees 8,291 6,000 6,000 7,237 7,500 6,000 6,000 Charges for Services - Recr. 79,340 62,000 62,000 55,022 58,315 54,800 55,800 0 Acct Class: 362 Rents & Royalties 362.100 Rental - Facilities 6,453 4,000 4,000 6,350 6,500 4,000 6,500 Rents & Royalties 6,453 4,000 4,000 6,350 6,500 4,000 6,500 0 Acct Class: 363 Impact Fees 363.271 Parks and Rec Impact Fees 1,654 0 0 551 551 Impact Fees 1,654 0 0 551 551 0 0 0 Acct Class: 366 Contributions & Donations 366.100 Contrib & Donations & Sponsors 10,950 0 0 7,125 7,125 7,200 7,200 Confributions & Donations 10,950 0 0 7,125 7,125 7,2oo 7,200 0 Acct Class: 369 Miscellaneous Revenues 365.110 Concession Sales 5,357 5,000 5,000 2,677 2,677 5,000 5,000 369.000 Other Miscellaneous Revenue 0 0 0 0 0 Miscellaneous Revenues 5,357 5,000 5,000 2,677 2,677 5,000 5,000 0 LeisureServices 103,754 71,000 71,000 71,725 75,168 71,000 74,500 p Dept: 900 Inter(und Transfers Acct Class: 391 Transfers In 381.301 Transfer-In from Cap Improvemn 290,440 100,000 100,000 100,000 100,000 381.303 Tsfer-In from Capital Projects 80,000 50,000 50,000 50,000 50,000 381.605 Tfr In - Special Law Enf Trust 50,000 50,000 50,000 0 0 Transfers In 420,440 200,000 200,000 150,000 150,000 0 0 0 Interfund Transfers 420,440 200,000 200,000 150,000 150,000 0 0 0 Dept: 910 Other Financing Sources & Uses Acct Class: 390 Other Financing Sources 383.100 Capital Lease at Inception 0 432,850 432,850 432,844 432,844 240,000 300,000 Other Financing Sources 0 432,850 432,850 432,844 432,844 240,000 300,000 0 Other Financing Sources & Uses 0 432,850 432,850 432,844 432,844 240,000 300,000 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investment Eamin 361.1001nterest/InvestmentEamings 9,974 11,000 11,000 5,688 9,000 9,000 9,000 361.101 PBC Tax Col-Interest on Dep 594 800 800 104 500 500 500 367.100 Net Unreal appreciation (Dep) 11,748 18,�00 18,000 3,490 6,000 7,500 7,500 Unrestricted Investrnent Eamin 22,316 29,800 29,800 9,282 15,500 17,000 17,000 0 Acct Class: 369 Miscellaneous Revenues 364.100 Disposition of Assets 26,313 15,000 15,000 0 0 90,000 90,000 BUDGET WORKSHEET June 30, 201411:49 am Page: 6 Village of Tequesta 6130/2014 11:49 am Prior ---------- Current Year ----------- (6) (7) (8) Year Original Amended Actual Thru Esfimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Revenues Dept: 950 Other Nonoperating Miscellaneous Revenues 26,313 15,000 15,000 0 0 90,000 90,000 0 Other Nonoperating 48,629 44,800 44,800 9,262 15,500 107,000 107,000 0 Dept: 990 Other/Reserve/Contingency Acct Class: 390 Other Financing Sources 399.995 Appropriate FB - SmartCop 0 0 0 0 0 399.999 Appropriate Fund Balance 0 0 453,718 0 0 Other Financing Sources 0 0 453,718 0 0 0 0 0 Other/Reserve/Contingency 0 0 453,718 0 0 0 0 0 Total Revenues 9,242,485 9,873,778 10,308,796 8,637,154 9,921,549 9,983,699 10,048,199 0 Expenditures Dept: 100 Council Acct Class: 530 Operating Expenditures/Expense 531.311 CouncilFees-Arena 3,000 3,000 3,000 2,250 3,000 3,000 3,000 531.313 Council fees - T. Patemo 3,000 3,000 3,000 2,250 3,00� 3,�00 3,000 531.314 Council fees - F. D'Ambra 3,000 3,000 3,000 2,250 3,000 3,000 3,000 531.316 Council fees - S. Okun 3,000 3,000 3,000 2,250 3,000 3,000 3,000 531.317 Council Fees - Brennan 3,000 3,000 3,000 2,250 3,000 3,000 3,000 540.301 CouncilExpenses-Arena 9 1,500 1,000 0 1,000 3,000 3,000 540.304 CouncilExpense-F.D'Ambra 9 1,500 1,000 0 1,000 3,000 3,000 540.306 CouncilExpense-S.Okun 1,308 1,500 1,500 284 1,506 3,000 3,000 540.307 Council Expenses - Brennan 1,490 1,500 1,500 920 1,500 3,000 3,000 540.308 CouncilExpenses- Paterno 76 1,500 1,500 165 1,500 3,000 3,000 549.300 Other Misc Chgs & Obligations 635 700 700 302 700 700 700 549.350 VolunteerAppreciation 679 800 800 717 800 800 800 554.300 Books, Publ, Subs & Membership 2,985 3,400 3,400 2,985 3,400 3,500 3,500 582.800 Aid to Community Organizations 0 0 0 0 0 582.801 Aid to Com.Org - Arena 400 0 500 500 500 582.804 Aid to Community Org - D'Ambra 400 0 500 500 500 582.807 Aid to Com. Org. - Brennan 200 0 0 0 0 582.808 Aid to Com. Org. - Patemo 0 0 0 0 0 Operating Expenditures/Expense 23,191 27,400 27,400 17,623 27,400 35,000 35,000 0 Council 23,191 27,400 27,400 17,623 27,400 35,000 35,000 0 Dept: 110 Manager Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 130,206 132,400 132,400 93,114 132,100 137,200 137,200 514.100 Overtime 183 0 0 0 0 515.103 Bonus Pay Plan 0 0 4,500 4,500 4,500 BUDGET WORKSHEET June 30, 201411:49 am Page: 7 Villa e of Te uesta 6I30/2014 9 q 11:49 am Prior ------------ Current Year ----------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:613012014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 110 Manager Acct Class: 510 Personal Services 515.108 Auto Allowance 3,000 3,000 3,000 2,250 3,000 3,000 3,000 515.125 OtherAllowances 1,200 1,200 1,200 900 1,200 1,200 1,200 516.100 Compensated Absences 4,314 5,000 11,021 3,922 7,500 9,000 9,000 516.105 Compensated Absences - HSA 6,825 0 0 0 0 521.101 FICA Taxes 6,221 6,900 6,952 5,019 6,620 7,400 7,400 521.102 MedicareTaxes 2,053 2,000 2,177 1,512 2,170 2,200 2,200 522.102 VOT Pension Contributions 12,213 12,200 12,200 8,548 12,130 11,600 11,600 523.101 Life/Health Insurance 22,089 25,300 19,400 14,607 19,330 17,000 17,000 523.105 HSA - Health Savings Account 2,550 0 0 0 0 524.100 Workers' Comp Insurance 378 270 270 195 270 270 270 526.104 ICMA-Def Comp Plan 9,826 9,900 9,900 6,928 9,830 10,300 1�,300 554.301 PersonnelTraining 874 750 750 1,395 750 1,000 1,000 Personal Services 201,932 198,920 203,770 142,890 199,400 200,170 200,170 0 Acct Class: 530 Operating Expenditures/Expense 540.300 Travel & Per Diem 1,449 1,400 1,400 730 0 1,400 1,400 546.320 Computer system maint & suppli 0 500 500 0 0 500 500 548.110 Marketing and Public Relations 355 0 0 0 0 549.300 Other Misc Chgs & Obligations 0 250 250 30 30 250 250 554.300 Books, Publ, Subs & Membership 2,640 2,800 2,800 2,382 2,800 3,150 3,150 Operating ExpenditureslExpense 4,444 4,950 4,950 3,142 2,830 5,300 5,300 0 Acct Class: 590 Other Financing Sources & Uses 599.140 Budget Cost Savings 0 4,850 0 0 0 Other Financing Sources & Uses 0 4,850 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.601 Computer Equipment 0 0 0 0 0 Capital0utlay 0 0 0 0 0 0 0 0 Manager 206,376 208,720 208,720 146,032 202,230 205,470 205,470 0 Dept: 111 Human Resources Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 79,603 79,800 79,800 56,119 79,605 113,900 118,100 515.103 Bonus Pay Plan 0 0 3,000 3,000 3,000 515.107 Part-timeSalaries 3�,028 30,300 33,300 22,178 31,100 516.100 Compensated Absences 1,982 2,000 2,000 1,982 1,982 2,000 2,000 516.105 Compensated Absences - HSA 1,220 0 0 0 0 521.101 FICATaxes 6,705 7,000 7,124 4,857 7,100 7,000 7,200 521.102 Medicare Taxes 1,568 1,700 1,729 1,136 1,700 1,700 1,700 522.102 VOT Pension Contributions 7,467 7,400 7,400 5,152 7,310 9,600 10,000 BUDGET WORKSHEET June 30, 201411:49 am Page: 8 6/30/2014 Village of Tequesta 11:49 am Prior ------------- Cucrent Year ------------ (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/3012014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - Generai Fund Expenditures Dept: 111 Human Resources Acct Class: 510 Personal Services 523.101 Life/Healthlnsurance 6,708 7,300 7,300 5,522 7,255 17,700 19,200 523.105 HSA- Health Savings Account 1,000 0 0 0 0 524.100 Workers' Comp Insurance 329 220 220 162 220 220 220 526.101 Employee Recognition Program 6,774 5,500 5,500 4,316 5,500 5,500 5,500 526.102 Employee Assistance Program 3,406 4,000 4,000 1,703 4,000 4,000 4,000 526.103 Education Reimbursement Prgm 0 1,000 0 0 0 1,000 1,000 554.301 PersonnelTraining 2,060 2,500 2,500 2,100 2,500 2,500 2,500 554.310 Employee Development 132 2,000 2,000 850 2,000 2,000 2,000 Personal Services 148,982 150,720 155,873 109,077 153,272 167,120 173,420 0 Acct Class: 530 Opereting ExpenditureslExpense 540.300 Travel & PerDiem 1,840 1,300 1,300 1,248 1,300 1,300 1,300 546.320 Computer system maint 8 suppli 1,659 500 500 53 500 500 500 547.300 Printing & Binding 619 1,500 300 0 300 1,500 1,500 549.300 Other Misc Chgs & Obligations 0 500 327 126 327 500 500 549.401 Recruitmentexpenses 257 1,000 500 401 500 1,500 1,500 552.302 Small Tools and Equipment 224 500 200 60 200 500 500 554.300 Books, Publ, Subs & Membership 730 500 750 564 750 700 700 Operating Expenditures/Expense 5,329 5,800 3,877 2,452 3,877 6,500 6,500 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 3,230 0 0 0 Other Financing Sources & Uses 0 3,230 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.601 ComputerEquipment 0 0 0 0 0 1,600 1,600 Capital0utlay 0 0 0 0 0 1,600 1,600 0 Human Resources 154,311 159,750 159,750 111,529 157,149 175,220 181,520 0 Dept: 120 Village Clerk Acct Ciass: 510 Personal Services 512.100 Regular Salaries & Wages 109,676 109,900 109,900 77,281 109,630 112,500 112,500 514.100 Overtime 86 0 0 0 0 515.103 Bonus Pay Plan 0 0 3,000 3,000 3,000 516.100 Compensated Absences 0 0 0 0 0 516.105 Compensated Absences - HSA 1,398 0 0 0 0 521.101 FICA Taxes 6,3&4 6,500 6,730 4,660 6,700 7,400 7,400 521.102 MedicareTaxes 1,493 1,600 1,600 1,090 1,600 1,800 1,800 522.102 VOT Pension Contributions 10,288 10,200 10,200 7,094 10,065 9,500 9,500 523.101 Life/Health Insurance 23,180 25,100 25,100 18,860 24,965 18,800 18,800 523.105 HSA - Health Savings Account 1,700 0 0 0 0 BUDGET WORKSHEET June 30, 201411:49 am Page: 9 6/30/2014 �Ilage of Tequesta 11:49 am Prior ------------ Current Year --�-----�-- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 120 Village Clerk Acct Class: 510 Personal Services 524.100 Workers' Comp Insurance 325 220 220 162 220 220 220 526.103 Education Reimbursement Prgm 0 0 327 326 327 554.301 PersonnelTraining 1,565 2,250 1,923 50 1,923 1,980 1,980 Personal Services 156,095 155,770 159,000 112,523 158,430 152,200 152,200 0 Acct Class: 530 Operating Expenditures/Expense 531.303 Codification Services 8,868 8,700 15,292 12,292 15,292 10,700 10,700 531.304 Recording Secy Service 7,511 7,350 7,350 4,424 7,350 7,350 7,350 534.301 Election Expense 882 15,940 9,348 1,306 1,307 15,940 15,940 534.302 Legal Advertising 15,910 14,800 14,800 6,630 14,800 14,800 14,800 534.311 Elec6on exp. - annexations 10,030 0 0 0 0 540.300 Travel & Per Diem 2,859 3,050 3,050 1,167 3,000 3,440 3,440 541.300 Communication Services 1,143 1,300 1,300 817 1,300 1,300 1,300 546.320 Computersystemmaint&suppli 2,844 1,300 1,500 495 1,500 18,200 18,200 548.110 Marketing and Public Relations 0 0 400 400 400 2,200 2,200 549.100 MiscellaneousArchivai 47 2,500 2,500 35 1,500 2,500 2,500 549.201 Advertising & Promotion 187 1,000 600 0 0 549.300 OtherMiscChgs&Obligations 217 1,800 1,600 1,225 1,600 2,300 2,300 552.302 Small Tools and Equipment 508 500 500 0 500 500 500 552.306 Microfilm Service/Supplies 11 30 30 0 30 30 30 554.300 Books, Publ, Subs & Membership 466 86� 860 344 860 860 860 Operating ExpenditureslExpense 51,483 59,130 59,130 29,135 49,439 80,120 80,120 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 3,230 0 0 0 Other Financing Sources & Uses 0 3,230 0 0 0 0 0 0 Village Clerk 207,578 218,130 218,130 141,658 207,869 232,320 232,320 0 Dept: 130 Finance Acct Class: 510 Personal Services 512.100 Regular Salaries 8 Wages 239,906 240,500 237,715 167,171 237,700 245,100 245,100 514.100 Overtime 12 0 0 0 0 515.103 Bonus Pay Plan 0 0 7,950 7,950 7,950 516.100 Compensated Absences 2,645 4,500 4,500 1,444 4,500 3,500 3,500 516.105 Compensated Absences - HSA 2,571 0 0 0 0 521.101 FICATaxes 14,354 14,800 14,400 9,915 14,400 15,100 15,100 521.102 Medicare Taxes 3,387 3,500 3,544 2,360 3,400 3,500 3,500 522.102 VOT Pension Contributions 22,133 22,200 22,200 15,346 21,850 20,700 20,700 523.101 Life/Health Insurance 37,688 42,300 43,900 32,848 43,900 36,600 36,600 523.105 HSA - Health Savings Account 3,350 0 0 0 0 BUDGET WORKSHEET June 30, 201411:49 am Page: 10 6/30/2014 Village of Tequesta 11:49 am Prior ------------ Current Year -------------- � ��) � Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 130 Finance Acct Class: 510 Personal Services 524.100 Workers' Comp Insurance 768 480 480 355 480 480 480 525.100 Unemployment Compensation 0 0 4,400 0 4,400 554.301 Personnel Training 3,490 4,600 4,600 980 4,600 4,400 4,400 Personal Services 330,304 332,880 343,689 238,369 343,180 329,380 329,380 0 Acct Class: 530 Operating E�enditureslExpense 532.300 Accounting & Auditing Services 23,908 24,200 23,865 23,865 23,865 24,610 24,610 540.300 Travel & Per Diem 173 1,000 1,000 447 1,000 1,000 1,000 546.301 Office Equip/Repair & Maint 578 800 800 527 800 900 900 546.320 Computer system maint & suppli 6,447 8,800 8,800 6,944 8,800 8,800 8,800 547.300 Printing & Binding 1,322 3,000 1,800 1,271 1,800 3,000 3,000 549.300 OtherMiscChgs&Obligations 288 1,000 1,000 143 1,000 1,000 1,000 551.300 Office Supplies & Equipment 3,449 4,000 3,286 805 3,286 4,000 4,000 552.302 Small Tools and Equipment 0 500 500 0 500 500 500 554.300 Books, Publ, Subs & Membership 1,355 1,400 1,400 724 1,400 1,600 1,600 Operating Expenditures/Expense 37,520 44,700 42,451 34,726 42,451 45,410 45,410 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 8,560 0 0 0 Other Financing Sources & Uses 0 8,560 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.601 Computer Equipment 1,259 0 0 0 0 Capital0utlay 1,259 0 0 0 0 0 0 0 Finance 369,083 386,140 386,140 273,095 385,631 374,790 374,790 0 Dept: 140 Legal Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 116,593 90,000 90,000 66,100 90,000 90,000 90,000 531.308 Legalfees- Personnel 42,720 20,000 20,000 70,287 90,000 60,000 60,000 Operating Expenditures/Expense 159,313 110,000 110,000 136,387 180,000 150,000 150,000 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 6 0 0 0 0 Other Financing Sources 8 Uses 0 0 0 0 0 0 0 0 Legal 159,313 110,000 110,000 136,387 180,000 150,000 150,000 0 Dept: 150 Comprehensive Planning Acct Class: 510 Personal Services 512.100 Regular Salaries 8 Wages 0 78,000 78,000 54,830 77,800 79,800 79,800 515.103 Bonus Pay Plan 0 0 1,020 3,000 3,000 521.101 FICA Taxes 0 4,800 4,900 3,350 4,760 5,000 5,000 521.102 MedicareTaxes 0 1,200 1,200 783 1,150 1,200 1,200 522.101 FRS Contributions 0 4,500 5,430 3,811 5,550 5,900 5,900 BUDGET WORKSHEET June 30, 201411:49 am Page: 11 6/30/2014 Village of Tequesta 11:49 am Prior -------------- Current Year -------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 150 Comprehensive Planning Acct Class: 510 Personal Services 523.101 Life/Health Insurance 0 9,300 7,250 5,515 7,250 6,400 6,400 524.100 Workers' Comp Insurance 0 280 280 204 280 280 280 Personal Services 0 98,080 98,080 71,493 99,790 98,580 98,580 0 Acct Class: 530 Operating Expenditures/Expense 531.301 LegalServices 27,218 11,000 11,000 15,675 25,000 30,000 15,000 531.321 Mapping Services 0 2,500 2,500 1,740 2,500 2,500 2,500 531.322 Misc Planning Service 103,891 62,500 62,500 45,360 62,500 62,500 62,500 531.331 Board of Adjustment 286 500 250 0 250 250 250 531.332 Planning and Zoning Board 535 1,000 750 428 750 750 750 531.405 Legal - Annexation 5,415 0 0 0 0 534.300 Other Contractual Services 10,990 5,000 5,000 2,245 5,000 5,000 5,000 534.302 Legal Advertising 5,313 8,500 8,500 3,317 8,500 8,500 8,500 534.420 Legal Advertising - Annexation 875 0 0 0 0 546.320 Computer system maint & suppli 0 0 4,800 4,200 4,800 4,800 4,800 547.300 Printing & Binding 0 500 500 0 500 500 500 549.150 Miscellaneous annexation exp 1,481 0 0 0 0 549.300 Other Misc Chgs 8 Obligations 0 500 500 125 500 500 500 551.300 Office Supplies 8 Equipment 0 0 500 240 500 750 750 Operating ExpenditureslExpense 156,004 92,000 96,800 73,330 110,800 116,050 101,050 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 Capital0u8ay 0 0 0 0 0 0 0 0 Comprehensive Planning 156,004 190,080 194,880 144,823 210,590 214,630 199,630 0 Dept: 160 General Govemment Acct Class: 510 Personal Services 512.100 RegularSalaries & Wages 69,666 69,800 69,800 49,113 69,700 71,500 71,500 515.103 Bonus Pay Plan 0 0 2,400 2,400 2,400 516.100 Compensated Absences 0 4,000 4,000 2,765 4,000 4,000 4,000 516.105 Compensated Absences - HSA 1,680 0 0 0 0 521.101 FICATaxes 4,256 4,600 4,749 3,144 4,500 4,700 4,700 521.102 Medicare Taxes 995 1,100 1,135 735 1,050 1,100 1,100 522.102 VOT Pension Contri6utions 6,535 6,500 6,500 4,509 6,400 6,100 6,100 523.101 Life/Health Insurance 5,332 5,900 5,900 4,382 5,800 5,200 5,200 523.105 HSA - Health Savings Account 800 0 0 0 0 BUDGET WORKSHEET June 30, 201411:49 am Page: 12 6/30/2014 Village of Tequesta 11:49 am Prior ------------- Current Year ------------ (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 160 General Govemment Acct Class: 510 Personal Services 524.100 Workers' Comp Insurance 206 140 140 103 140 140 140 554.301 Personnel Training 0 5,000 5,000 0 5,000 5,000 5,000 Personal Services 89,470 97,040 99,624 67,151 98,990 97,740 97,740 0 Acct Class: 530 Operating Expenditures/Expense 534.300 Other Contractual Services 22,015 20,000 20,006 15,001 20,002 20,100 20,100 534.303 Special Events 4,048 10,000 10,000 6,257 10,000 10,000 10,000 540.300 Travel & Per Diem 1,436 2,000 2,000 0 2,000 2,000 2,000 541.300 Communication Services 12,767 13,000 13,000 9,627 13,500 14,500 14,500 541.301 Postage 3,104 3,000 3,000 1,902 4,000 4,300 4,300 541.305 Website Maintenance 7,689 7,900 7,900 7,770 7,770 8,100 8,100 543.300 UtilityServices 15,853 16,000 16,000 10,197 16,000 16,000 16,000 544.301 Operating Leases 5,457 5,350 5,350 3,986 3,700 5,350 5,350 545.3001nsurance 45,969 48,900 48,900 37,034 48,900 48,900 48,900 546.301 Office Equip/Repair & Maint 1,473 2,000 2,000 1,150 2,000 2,000 2,000 546.302 Vehicle Repair & Maintenance 20 100 100 20 100 100 100 546.303 Building Repair & Maint 0 0 0 0 0 546.310 EquipmentRepair&Maint 1,916 1,000 1,000 84 1,000 1,000 1,000 546.320 Computer system maint & suppli 11,051 13,400 13,400 10,583 13,400 33,100 25,850 547.300 Printing & Binding 362 1,000 1,000 739 1,000 1,000 1,000 549.300 Other Misc Chgs & Obligafions 2,745 8,000 9,077 5,136 9,000 10,000 10,000 549.302 Village Newsletter 19,101 18,200 18,200 4,532 8,000 19,000 19,000 549.304 Licenses, Fees & Permits 1,960 2,600 2,600 1,960 1,960 2,600 2,600 551.300 Office Supplies & Equipment 4,119 4,000 4,000 2,217 3,000 4,000 4,000 552.160 IT Operating Supplies 309 800 800 574 800 800 800 552.301 Gas & Oil 175 500 500 135 250 500 500 552.302 Small Tools and Equipment 618 1,500 1,500 505 1,500 1,500 1,500 554.300 Books, Publ, Subs & Membership 2,056 4,500 4,500 2,331 2,500 2,500 2,500 Operating Expenditures/Expense 164,243 183,750 184,833 121,740 170,382 207,350 200,100 Q Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 2,590 0 0 0 Other Financing Sources & Uses 0 2,590 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.600 MachlEquipment 0 0 0 0 0 664.601 Computer Equipment 6,680 0 0 0 0 664.602 Vehicles 0 0 0 0 0 Capital0utlay 6,680 0 0 0 0 0 0 0 General Government 260,393 283,380 284,457 188,891 269,372 305,090 297,840 0 BUDGET WORKSHEET June 30, 201411:49 am Page: 13 6/30I2014 Village of Tequesta 11:49 am Prior ------------ Current Year ------------ (g) (7) �g� Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 175 Police Department Acct Class: 510 Personal Services 512.171 Sal & Wages - Adminstration 121,206 123,500 123,500 85,588 122,330 128,600 128,600 512.172 Reg Sal & Wages - Communicatio 244,353 245,100 245,100 171,961 244,400 251,000 251,000 512.175 Reg Sal & Wages - Operations 918,133 1,032,900 969,300 636,531 913,000 1,068,400 1,022,300 512.180 Reg Sal & Wages - Code Enf 0 0 0 0 0 59,750 514.172 Overtime - Communications 28,499 10,000 18,465 14,241 18,465 21,000 18,000 514.175 Overtime - Operations 57,733 70,000 93,000 91,644 93,000 80,000 63,500 515.101 Holiday Pay 42,253 48,900 48,900 32,868 44,400 43,600 43,600 515.103 Bonus Pay Plan 7,500 7,250 13,250 13,250 13,250 7,300 7,300 515.106 Clothing & BootAllowance 11,724 12,250 12,250 10,619 11,250 13,300 12,700 515.107 Part-time Salaries 0 0 32,000 17,277 32,000 515.108 Auto Allowance 4,000 6,000 6,000 4,500 6,000 6,000 6,000 515.120 Cellphoneallowance 800 1,200 1,200 900 1,200 1,200 1,200 515.125 Other Allowances 13,600 8,400 8,400 6,300 8,400 8,400 8,400 515.172 PfT Salary - Communications 27,213 18,200 21,000 20,619 21,000 24,000 24,000 515.175 PIT Salary - Operations 80,945 0 0 0 0 46,600 46,600 515.180 PIT Salary - Code Enforcement 0 0 0 0 0 16,900 516.100 Compensated Absences 30,012 15,000 19,833 19,832 19,832 15,000 15,000 516.105 Compensated Absences - HSA 35,598 0 0 0 0 521.101 FICA Taxes 95,401 95,700 96,686 66,805 96,686 107,700 99,100 521.102 Medicare Taxes 22,312 22,700 22,944 15,659 22,944 25,600 23,600 522.101 FRS Contributions 47,446 37,000 44,200 29,570 44,200 39,800 39,600 522.102 VOT Pension Contributions 159,216 156,600 156,900 95,267 135,000 126,000 120,300 522.105 Defined Contribution 7,909 31,500 31,500 12,955 20,000 27,700 25,400 522.110 Other Pension Contributions 76,177 0 0 0 0 523.101 Life/Health Insurance 220,014 272,800 253,502 172,485 237,000 240,100 217,600 523.105 HSA-HealthSavingsAccount 21,900 0 0 0 0 524.100 Workers' Comp Insurance 37,930 45,430 45,430 34,069 A5,430 45,430 45,430 525.100 Unemployment Compensation 7,877 0 0 0 635 526.101 Employee Recognition Program 162 3,000 3,000 333 3,000 3,000 3,000 526.103 Education Reimbursement Prgm 0 4,000 4,000 0 4,000 4,000 4,000 526.105 Employee Physical/Psycological 1,789 6,000 6,000 4,884 6,000 8,000 8,000 554.301 PersonnelTraining 3,839 11,000 11,000 7,237 11,000 11,000 11,000 Personal Services 2,325,541 2,284,430 2,287,360 1,565,394 2,174,422 2,429,380 2,245,230 0 Acct Class: 530 Operating ExpenditureslExpense 531.301 LegalServices 21,369 25,000 25,000 15,874 18,500 531.320 Code Enforcement Service 7 4,000 4,000 0 4,000 BUDGET WORKSHEET June 30, 201411:49 am Page: 14 Village of Tequesta 6/30/2014 11:49 am Prior ---------- Current Year ------------ (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 175 Police Department Acct Class: 530 Operating Expenditures/Expense 540.300 Travel & Per Diem 8,360 13,000 13,000 7,624 13,000 12,000 12,000 541.300 Communication Services 25,905 32,000 32,000 20,265 32,000 32,000 32,000 541.301 Postage 2,585 2,000 2,000 1,491 2,100 2,000 2,000 543.300 Utility Services 24,756 26,000 26,000 15,987 25,300 25,000 25,000 544.301 Operating Leases 1,729 2,100 2,100 1,164 2,100 2,000 2,000 545.300 Insurance 42,536 47,700 48,350 36,454 48,350 48,350 48,350 546.175 K-9 Equipment & Maintenance 0 0 0 1,478 2,047 6,000 6,000 546.301 Office Equip/Repair& Maint 777 1,000 1,000 206 1,000 1,000 1,000 546.302 Vehicle Repair & Maintenance 44,114 40,000 40,000 15,817 40,000 18,500 18,500 546.303 Building Repair& Maint 21,265 20,000 26,100 9,059 20,000 19,100 19,100 546.304 Communication Equip Maint 13,143 16,000 101,905 5,931 101,905 12,800 12,800 546.310 Equipment Repair & Maint 3,168 7,700 7,700 1,874 7,000 2,500 2,500 546.320 Computer system maint & suppli 44,347 69,000 69,000 55,744 69,000 95,900 81,850 547.300 Printing & Binding 334 2,000 2,000 2,082 2,000 1,800 1,800 549.300 Other Misc Chgs 8 Obligations 6,209 5,500 5,500 4,050 5,500 5,000 5,000 549.303 Investigative Expenses 1,078 1,100 1,100 569 1,100 1,100 1,100 549.304 Licenses, Fees & Permits 2,323 3,000 3,000 1,624 3,000 2,500 2,500 549.311 Marine Unit Operations 1,671 3,000 3,000 995 3,000 1,750 1,750 549.314 K.E.Y.S. Program 0 2,500 2,500 0 2,500 549.401 Recruitmentexpenses 5,457 0 0 0 0 551.300 Office Supplies & Equipment 5,085 5,000 5,000 4,107 5,000 5,000 5,000 551.301 Crime Prevention Supplies 3,014 4,000 4,000 1,214 4,000 2,500 2,500 552.301 Gas & Oii 65,735 70,000 70,000 36,577 66,000 63,000 63,000 552.302 Small Tools and Equipment 11,299 9,000 9,000 6,208 9,000 12,000 12,000 552.305 Unifortns 20,308 20,000 20,000 13,315 20,000 18,000 18,000 554.300 Books, Publ, Subs & Membership 1,760 4,000 4,000 1,845 3,000 2,400 2,400 Operating Expenditures/Expense 378,334 434,600 527,255 261,554 512,402 392,200 378,150 0 Acct Class: 590 Other Financing Sources 8 Uses 599.100 Budget Cost Savings 0 6,460 0 0 0 Other Financing Sources & Uses 0 6,460 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 663.710 Police Department Capital Proj 10,710 0 2,880 2,576 2,333 664.600 MachlEquipment 26,129 0 232,926 0 232,926 664.601 Computer Equipment 3,265 0 0 0 0 664.602 Vehicles 63,751 60,000 60,000 0 60,000 240,000 240,000 664.620 Intangible - Software 0 0 0 0 0 BUDGET WORKSHEET June 30, 201411:49 am Page: 15 6/30/2014 Village of Tequesta 11:49 am Prior ------------ Current Year ------------- (6) (7) �g) Year Original Amended Actual Thru Estimated Month:6/30I2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 175 Police Department Capital0utlay 103,855 60,000 295,806 2,576 295,259 240,000 240,000 0 Police Deparlment 2,807,730 2,785,490 3,110,421 1,829,524 2,982,083 3,061,580 2,863,380 0 Dept: 180 Building & Zoning Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 122,968 45,300 45,300 31,860 45,200 194,900 194,800 515.103 Bonus Pay Plan 0 0 0 0 0 515.106 Clothing & Boot Allowance 0 0 0 0 0 100 515.107 Part-time Salaries 26,238 0 20,130 10,518 12,850 16,900 38,800 516.100 Compensated Absences 609 0 0 0 0 516.105 Compensated Absences - HSA 1,490 0 0 0 0 521.101 FICA Taxes 9,253 2,800 4,040 2,604 3,575 6,900 14,100 521.102 MedicareTaxes 2,164 700 960 609 840 1,700 3,300 522.101 FRS Contributions 4,430 0 0 0 0 522.102 VOT Pension Contributions 4,239 4,200 4,200 2,925 4,150 9,500 16,500 523.101 LifelHealth Insurance 15,072 9,100 9,100 6,822 9,015 14,700 29,900 523.105 HSA - Health Savings Account 1,000 0 0 0 0 524.100 Workers' Comp insurance 373 160 160 119 160 160 160 525.100 UnemploymentCompensation 0 0 504 503 3,209 1,000 1,000 554.301 PersonnelTraining 295 1,500 100 0 0 Personal Services 188,131 63,760 84,494 55,960 78,999 245,760 298,660 0 Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 0 0 2,020 1,568 2,020 26,000 26,000 531.320 Code Enforcement Service 0 0 0 0 0 4,000 4,000 531.325 Inspection Services 121,664 160,680 139,050 101,982 162,000 75,000 75,000 534.300 Other Contractual Services 4,140 0 9,000 9,000 9,000 6,000 6,000 540.300 Travel & Per Diem 586 1,170 0 0 0 500 500 541.300 Communication Services 2,569 3,240 2,140 1,676 2,100 3,000 3,000 541.301 Postage 1,416 1,500 1,500 349 1,000 1,000 1,000 543.300 Utility Services 5,992 6,500 6,500 3,787 6,000 6,000 6,000 544.301 Operating Leases 1,903 1,910 1,910 1,105 1,910 1,850 1,850 546.301 OfficeEquip/Repair&Maint 1,036 1,500 1,000 467 1,000 1,000 1,000 546.303 Building Repair & Maint 0 0 0 0 0 546.320 Computer system maint & suppli 3,683 14,400 11,210 9,893 11,360 13,500 12,600 547.300 Printing & Binding 853 1,000 1,000 532 1,000 1,500 1,500 549.300 Other Misc Chgs & Obligations 145 600 600 248 600 600 600 549.304 Licenses, Fees & Permits 1,339 1,400 1,436 1,435 1,435 1,700 1,700 551.300 Office Supplies & Equipment 2,435 3,000 3,000 1,555 3,000 3,000 3,000 BUDGET WORKSHEET June 30, 201411:49 am Page: 16 6/30/2014 Village of Tequesta 11:49 am Prior -------------CurrentYear-------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 180 Building & Zoning Acct Class: 530 Operating Expenditures/Expense 554.300 Books, Publ, Subs & Membership 990 1,250 1,250 940 940 500 500 Operating Expenditures/Expense 148,751 198,150 181,616 134,537 203,365 145,150 144,250 0 Acct Class: 600 Capital Outlay 664.600 Mach/Equipment 0 0 0 0 0 664.601 Computer Equipment 0 0 0 0 0 664.620 Intangible - Software 0 0 0 0 0 Capital0utlay 0 0 0 0 0 0 0 0 Buiiding&Zoning 336,882 261,910 266,110 190,497 282,364 390,910 442,910 0 Dept: 192 Fire Control Acct Class: 510 Personal Services 512.100 RegularSalaries & Wages 1,407,129 1,451,400 1,451,400 1,028,091 1,458,150 1,491,500 1,491,500 514.100 OveRime 45,586 56,100 51,600 40,751 51,600 56,800 56,800 514.300 Overtime - Training 9,685 19,800 19,800 8,923 18,500 19,500 19,500 515.101 Holiday Pay 47,849 49,200 49,200 40,852 49,200 49,700 49,700 515.103 Bonus Pay Plan 0 0 58,500 58,500 58,500 515.107 Part-time Salaries 39,207 50,400 50,400 28,529 48,500 50,900 50,900 515.110 Intern Fire Fighter Pay 58,429 58,700 58,700 40,096 57,700 61,200 61,200 515.120 Cellphoneallowance 1,200 1,200 1,200 800 1,200 1,200 1,200 515.125 OtherAllowances 1,200 3,600 3,600 2,400 3,600 3,600 3,600 516.100 Compensated Absences 3,297 3,600 3,600 1,420 3,600 19,600 19,600 516.105 Compensated Absences - HSA 26,760 0 0 0 0 521.101 FICA Taxes 96,015 102,200 103,862 72,607 102,650 106,400 106,400 521.102 Medicare Taxes 22,455 23,900 24,289 16,981 23,780 24,900 24,900 522.102 VOT Pension Contributions 343,772 345,500 347,900 254,299 347,900 348,100 348,100 522.110 Other Pension Contributions 117,996 154,700 118,000 0 118,000 118,000 118,000 523.101 Life/Health Insurance 205,908 221,700 221,700 158,693 209,700 180,000 180,000 523.105 HSA - Health Savings Account 24,300 0 0 0 0 524.100 Workers' Comp Insurance 55,963 55,660 55,660 41,740 55,660 55,660 55,660 525.100 Unemployment Compensation 0 0 0 0 0 526.101 Employee Recognition Program 0 2,930 2,930 253 2,200 2,950 2,950 526.103 Education Reimbursement Prgm 9,176 15,400 15,400 6,645 15,400 19,900 19,900 526.104 ICMA-Def Comp Plan 0 0 0 0 0 4,900 4,900 526.105 Employee Physical/Psycological 8,912 9,870 9,870 6,897 9,500 9,900 9,900 554.301 Personnel Training 2,589 9,070 9,070 2,382 8,100 9,200 9,200 Personai Services 2,527,428 2,634,930 2,656,681 1,810,859 2,643,440 2,633,910 2,633,910 0 Acct Class: 530 Operating Expenditures/Expense 531.318 Volunteer Fire Fighter Program 5,448 7,780 7,680 2,112 7,500 BUDGET WORKSHEET June 30, 201411:49 am Page: 17 6/30/2014 Village of Tequesta 11:49 am Prior -------------- Current Year -------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:613012014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 192 Fire Control Acct Class: 530 Operating Expenditures/Expense 540.300 Travel & Per Diem 1,232 5,930 5,930 851 3,850 5,300 5,300 541.300 Communication Services 14,439 13,060 12,058 9,781 12,058 13,700 13,700 541.301 Postage 1,482 1,500 1,500 1,149 1,500 1,500 1,500 543.300 UtilityServices 27,400 27,800 28,802 19,170 27,500 30,650 30,650 544.301 Operating Leases �,841 7,920 7,920 4,359 7,796 5,760 5,760 545.300 Insurance 24,499 21,900 21,900 16,457 21,900 21,900 21,900 546.302 Vehide Repair & Maintenance 8,123 5,670 5,670 2,326 5,200 4,700 4,700 546.303 Building Repair & Maint 21,688 23,610 29,710 17,815 26,700 25,450 25,450 546.310 Equipment Repair 8� Maint 21,478 22,020 22,020 16,775 22,020 23,250 23,250 546.320 Computer system maint & suppli 13,903 19,500 19,500 13,449 19,500 32,800 26,900 547.300 Printing&Binding 892 1,420 1,420 682 1,300 1,450 1,450 549.300 Other Misc Chgs 8� Obligations 4,198 3,200 3,200 1,365 3,100 3,850 3,850 549.304 Licenses, Fees & Permits 17,104 17,590 17,590 13,586 17,100 18,850 18,850 549.311 Marine Unit Operations 1,650 5,370 5,370 676 3,500 3,900 3,900 549.397 Bad DebtExpense 77,504 0 0 0 0 551.300 Office Supplies 8 Equipment 2,666 2,790 2,790 1,996 2,600 2,700 2,700 551.302 Fire Prevention Education 2,268 2,310 2,310 1,280 2,300 2,350 2,350 552.301 Gas & Oil 14,812 19,920 19,920 11,014 16,500 17,700 17,700 552.302 Small Tools and Equipment 0 2,920 2,920 2,002 2,920 3,250 3,250 552.304 Chemicals 950 990 990 950 950 1,000 1,000 552.305 Uniforms 11,892 23,310 23,310 14,096 23,000 23,350 23,350 552.308 SafetySupplies 8,829 21,000 20,258 8,242 18,500 21,700 21,700 552.310 Disaster Relief Supplies 0 5,300 5,300 0 4,500 5,300 5,300 552.311 CPR Program Supplies 316 400 500 500 500 550 550 552.312 Medical Supplies 37,799 37,200 37,200 25,036 37,000 38,000 38,000 552.344 Fire Station Supplies 2,364 3,000 3,000 1,678 2,800 3,000 3,000 554.300 Books, Publ, Subs & Membership 2,519 3,050 3,050 2,515 3,050 3,300 3,300 Operating Expenditures/Expense 333,296 306,460 311,818 189,862 295,144 315,260 309,360 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 58,140 -311 0 0 Other Financing Sources & Uses 0 58,140 -311 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.600 Mach/Equipment 8,604 432,850 540,080 540,080 540,080 22,000 22,000 664.620 Intangible - Software 0 0 0 0 0 Capital0utlay 8,604 432,850 540,080 540,080 540,080 22,000 22,000 0 Fire Control 2,869,328 3,432,380 3,508,268 2,540,801 3,478,664 2,971,170 2,965,270 0 Dept: 210 Pubiic Works BUDGET WORKSHEET June 30, 201411:49 am Page: 18 6I3012014 Village of Tequesta 11:49 am Prior -------------- Current Year ------------- (6) (7) (g) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 210 Public Works Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 183,951 196,300 196,300 134,491 192,320 183,100 183,100 514.100 Overtime 919 1,000 1,000 211 1,000 1,000 1,000 515.103 Bonus Pay Plan 0 0 1,500 1,500 1,500 515.106 Clothing 8 Boot Allowance 400 550 550 550 550 550 550 515.107 Part-time Salaries 11,835 19,800 19,800 14,985 19,800 20,200 20,200 515.108 AutoAllowance 750 900 1,800 1,350 1,800 450 450 516.1Qo Compensated Absences 0 0 0 756 18,772 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 11,171 12,400 12,478 8,700 13,600 11,900 11,800 521.102 Medicare Taxes 2,613 2,900 2,919 2,035 3,185 2,800 2,800 522.101 FRS Contributions 5,317 7,800 8,600 6,017 8,600 522.102 VOT Pension Contributions 10,572 12,000 12,000 8,055 11,800 15,500 15,500 523.101 LifelHealth Insurence 66,539 74,900 73,223 52,408 69,410 54,600 54,600 523.105 HSA - Health Savings Account 850 0 0 0 0 524.100 Workers' Comp Insurance 10,877 17,180 17,180 12,880 17,180 17,180 17,180 Personal Services 305,794 345,730 347,350 243,938 359,517 307,280 307,180 0 Acct Class: 530 Operating Expenditures/Expense 531.302 Engineering Services 7,361 2,000 2,000 4,364 3,524 2,000 2,000 534.300 Other Contracival Services 500 2,000 2,000 480 2,000 1,000 1,000 540.300 Travel & Per Diem 0 250 250 0 250 150 150 541.300 Communication Services 4,205 4,000 4,000 3,300 4,500 4,000 4,500 543.300 Utility Services 90,793 90,000 90,000 63,731 112,000 112,000 112,000 543.301 Street Lights 124,847 120,000 120,000 88,543 135,000 125,000 135,000 544.301 Operating Leases 1,125 1,200 1,200 762 1,200 1,200 1,200 544.304 FEC Lease 11,185 14,150 14,150 14,031 14,150 14,650 14,650 545.3001nsurance 14,333 10,500 10,500 7,847 10,500 10,500 10,500 546.200 R&M - Station 11 2,011 2,500 2,500 0 2,500 2,500 2,500 546.301 Office Equip/Repair & Maint 105 200 200 50 200 200 200 546.302 Vehicle Repair & Maintenance 2,627 4,000 4,000 1,580 4,000 4,000 4,000 546.303 Building Repair & Maint 26,896 8,000 9,500 9,223 9,500 12,000 12,000 546.305 Pathway Maintenance 7,410 10,000 10,000 2,567 10,000 12,000 12,000 546.306 General Maintenance 11,107 30,000 30,000 17,328 30,000 30,OOQ 30,000 546.309 Landscape & Irrigation Maint 133,549 132,000 132,000 85,122 132,000 137,000 137,000 546.310 EquipmentRepair&Maint 9,424 11,000 11,000 7,719 11,000 11,000 11,000 546.320 Computersystemmaint&suppii 293 1,100 1,100 275 1,100 1,700 1,250 546.350 R& M- Roads 23,006 25,000 25,000 13,713 25,000 30,000 30,000 BUDGET WORKSHEET June 30, 201411:49 am Page: 19 6/30/2014 Village of Tequesta 11:49 am Prior ------------ Current Year ------------ (g) (7) �g) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 210 Public Works Acct Class: 530 Operating Expenditures/Expense 549.300 Other Misc Chgs & Obligations 2,902 4,000 4,000 924 3,500 3,500 3,500 549.304 Licenses, Fees & Permits 1,957 4,500 4,500 1,429 1,500 1,500 1,500 551.300 Office Supplies & Equipment 97 450 450 133 450 450 450 551.400 Janitorial Supplies 5,416 5,500 5,500 3,414 5,500 6,000 6,000 552.301 Gas & Oil 7,378 6,000 6,000 5,044 6,000 6,000 6,000 552.302 Small Tools and Equipment 4,212 1,500 1,500 4 1,500 3,000 3,000 552.305 Uniforms 1,257 2,000 2,000 1,215 2,000 2,000 2,000 553.301 Road Signs 1,169 2,000 2,000 1,346 2,000 2,500 2,500 563.600 Public Works Misc Projects 0 5,500 4,000 2,468 4,000 5,500 5,500 Operating Expenditures/Expense 495,165 499,350 499,350 336,612 534,874 541,350 551,400 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 1,620 0 0 0 Other Financing Sources 8� Uses 0 1,620 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.600 Mach/Equipment 0 0 0 0 0 15,000 15,000 664.602 Vehicles 0 0 0 0 0 60,000 60,000 Capital0utlay 0 0 0 0 0 75,000 75,000 0 Public Works 800,959 846,700 846,700 580,550 894,391 923,630 933,580 0 Dept: 231 Leisure Services Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 159,395 159,700 159,700 112,371 159,400 163,600 163,600 515.103 Bonus Pay Plan 0 0 6,000 6,000 6,000 515.106 Ciothing & Boot Allowance 100 100 100 100 100 100 100 515.107 Part-time Salaries 40,150 45,100 45,100 27,849 41,500 47,300 47,300 515.108 Auto Allowance 3,000 3,000 3,000 2,250 3,000 3,000 3,000 515.109 Seasonal Salaries & Wages 24,609 30,000 30,000 2,694 25,000 30,000 30,000 516.100 Compensated Absences 3,629 3,500 3,500 638 3,500 4,000 4,000 516.1�5 Compensated Absences - HSA 3,106 0 0 0 0 521.101 FICA Taxes 13,532 14,400 14,648 8,716 14,648 14,800 14,800 521.102 MedicareTaxes 3,165 3,400 3,458 2,038 3,458 3,500 3,500 522.102 VOT Pension Contributions 14,951 14,800 14,800 10,316 14,635 13,800 13,800 523.101 Life/Health Insurance 39,585 42,700 42,700 32,099 42,530 36,400 36,400 523.105 HSA - Health Savings Account 3,400 0 0 0 0 524.100 Workers' Comp Insurance 8,184 7,110 7,110 5,325 7,110 7,110 7,110 525.1�0 UnemploymentCompensation 0 0 0 0 0 526.105 Employee PhysicaVPsycological 808 2,500 2,500 322 2,500 2,500 2,500 554.301 PersonnelTraining 535 1,200 1,200 0 1,200 1,200 1,200 BUDGET WORKSHEET June 30, 201411:49 am Page: 20 Village of Tequesta 6/30/2014 11:49 am Prior ------------ Current Year ------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 231 Leisure Services Personal Services 318,149 327,510 333,816 210,718 324,581 327,310 327,310 0 Acct Class: 530 Operating ExpenditureslExpense 534.303 Special Events 77,289 20,878 40,578 40,578 40,578 45,000 45,000 540.300 Travel & Per Diem 0 1,500 1,500 0 1,500 1,500 1,500 541.300 Communication Services 5,402 5,700 5,854 4,301 5,700 5,700 5,700 541.301 Postage 48 150 150 25 150 150 150 543.300 UtilityServices 11,174 14,000 14,000 7,115 14,000 14,000 14,000 545.300 Insurance 14,396 14,500 14,500 10,870 14,500 14,500 14,500 546.302 Vehicle Repair & Maintenance 3,115 3,200 3,200 390 3,200 3,200 3,200 546.303 Building Repair & Maint 18,872 20,000 27,484 19,519 27,484 20,000 20,000 546.306 General Maintenance 35,615 30,000 30,000 19,034 30,000 30,000 30,000 546.310 Equipment Repair& Maint 1,307 1,700 1,700 721 1,700 1,700 1,700 546.320 Computer system maint & suppli 2,004 1,700 4,064 3,242 4,064 4,000 2,650 549.201 Advertising & Promotion 9,454 5,000 4,546 4,546 4,546 5,000 5,000 549.300 Other Misc Chgs & Obligations 1,525 5,000 3,521 274 3,521 5,000 5,000 549.304 Licenses, Fees & Permits 1,913 2,200 2,200 1,762 2,200 2,200 2,200 549.332 Recreation Program Expense 35,031 38,300 37,415 32,799 37,415 38,300 38,300 549.333 Spring/Summer Camp 15,881 15,000 15,000 3,888 15,000 15,000 15,000 551.300 Office Supplies & Equipment 2,041 2,000 2,000 584 2,000 2,000 2,000 551.315 Concession Supplies 4,851 5,000 2,392 2,391 2,392 5,000 5,000 552.301 Gas & Oil 1,928 2,500 2,500 1,247 2,500 2,500 2,500 552.302 SmallToolsandEquipment 1,500 1,500 1,500 655 1,500 1,500 1,500 552.305 Uniforms 159 500 500 45 500 500 500 554.300 Books, Publ, Subs & Membership 288 500 500 0 500 500 500 Operating Expenditures/Expense 243,793 190,828 215,104 153,986 214,950 217,250 215,900 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 6,460 0 0 0 Other Financing Sources & Uses 0 6,460 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.600 Mach/Equipment 0 0 0 1,200 0 CapitalOuBay 0 0 0 1,200 0 � 0 0 Leisure Services 561,942 524,798 548,920 365,904 539,531 544,560 543,210 0 Dept: 700 Debt Service Acct Class: 471 D/S - Principal 571.706 P/S Prin-BOA - P/S Bldg 247,809 258,700 258,700 192,930 258,700 269,920 269,920 571.708 P/S - Prin - SunTrust - Pumper 0 35,930 51,600 47,785 47,785 38,810 38,810 571.710 P/S Prin - 2015 PD Vehicles 0 0 0 0 0 76,830 76,830 571.712 2015 Pubiic Works Vehicles 0 0 0 0 0 11,070 BUDGET WORKSHEET June 30, 201411:49 am Page: 21 6/30/2014 �Ilage of Tequesta 11:49 am Prior ----------- Current Year ------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 001 - General Fund Expenditures Dept: 700 Debt Service Acct Class: 471 DIS - Principal 571.725 Prin - 2012 Ford Focus - Admin 0 0 0 0 0 571.726 Prin. - CTS Smart Cop Lease 0 0 0 0 0 D/S - Principal 247,809 294,630 310,300 240,715 306,485 385,560 396,630 0 Acct Class: 472 D/S - Interest 572.706 P/S - Int. BOA - P.S Bldg 124,692 113,900 113,900 86,446 113,900 102,590 102,590 572.708 P/S - SunTrust - Pumper 0 16,670 1,000 350 350 9,340 9,340 572.710 2015 PD Vehicles 0 0 0 0 0 8,210 8,210 572.712 2015 Public Works Vehicles 0 0 0 0 0 2,200 572.725 Int. 2012 Ford Facus - Admin 362 200 200 157 200 20 20 D/S-Interest 125,054 130,770 115,100 86,953 114,450 120,160 122,360 0 Debt Service 372,863 425,400 425,400 327,668 420,935 505,720 518,990 0 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,150 11,000 11,000 6,905 11,000 11,000 11,000 549.395 Credit Card Fees and Charges 1,720 2,500 2,500 1,754 2,500 2,800 2,&Q� 590.001 Allocate to Fund Balance 0 0 0 0 0 999.001 Suspense 0 0 0 1,000 0 999.002 Suspense - Payroll 0 0 0 0 0 999200 Suspense - A/P 0 0 0 0 0 Other Financing Sources & Uses 11,870 13,500 13,500 9,659 13,500 13,800 13,800 0 OtherNonoperating 11,870 13,500 13,500 9,659 13,500 13,800 13,800 0 Dept: 990 OthedReserve/Contingency Acct Class: 590 Other Financing Sources & Uses 599.902 Reserves - Contingency 0 0 0 0 0 90,489 Other Financing Sources & Uses 0 0 0 0 0 0 90,489 0 Other/Reserve/Contingency 0 0 0 0 0 0 90,489 0 Total Expenditures 9,297,823 9,873,778 10,308,796 7,004,641 10,251,709 10,103,890 10,048,199 0 BUDGET WORKSHEET June 30, 201411:49 am Page: 22 Village of Tequesta 6/30I2014 11:49 am Prior ------------- Current Year ---------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DE P A RTMENT MA NAGER COUNCIL GeneralFund -55,338 0 0 1,632,513 -330,160 -120,191 0 0 BUDGET WORKSHEET June 30, 201411:49 am Page: 23 Village of Tequesta 6130/2014 11:49 am Pnor ------------- Current Year ------------- (6) (7) (g) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 301 - Capital Improvement Fund Revenues Dept: 000 General Acct Class: 366 Contributions & Donations 366.100 Confib & Donations 8 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 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: 950 Other Nonoperating Acct Class: 361 Unrestricted Investment Eamin 361.100 Interest/Investment Eamings 0 0 0 0 0 Unrestricted Investment Eamin 0 0 0 0 0 0 0 0 Other Nonoperating 0 0 0 0 0 0 0 0 Dept: 990 OthedReservelContingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 100,000 100,000 0 100,000 Other Financing Sources 0 100,000 100,000 0 100,000 0 0 0 Other/Reserve/Contingency 0 100,000 100,000 0 100,000 0 0 0 Total Revenues 0 100,000 100,000 0 100,000 0 0 0 Expenditures Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 591.001 Transfer to General Fund 290,440 100,000 100,000 100,000 100,000 Interfund Transfers Out 290,440 100,000 100,000 100,000 100,000 0 0 0 Interfund Transfers 290,440 100,000 100,000 100,000 100,000 0 0 0 Total Expenditures 290,440 100,000 100,000 100,000 100,000 0 0 0 Capital Improvement Fund -29Q,440 0 0 -100,000 0 0 0 0 BUDGET WORKSHEET June 30, 201411:49 am Page: 24 6/30/2014 Village of Tequesta 11:49 am Prior ------------ Current Year ----------- �s) ��) �$) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 303 - Capital Projects Fund Revenues Dept: 990 Other/ReservelContingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 50,000 50,000 0 50,000 Other Financing Sources 0 50,000 50,000 0 50,000 0 0 0 Other/ReservelContingency 0 50,000 50,000 0 50,000 0 0 0 Total Revenues 0 50,000 50,000 0 50,000 0 0 0 Expenditures Dept: 399 Misc Proj-General Acct Class: 530 Operating Expenditures/Expense 546.311 FEC Track Maintenance 78,211 0 0 0 0 Operating ExpenditureslExpense 78,211 0 0 0 0 0 0 0 Misc Proj-General 78,211 0 0 0 0 0 0 0 Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 591.001 Transferto General Fund 80,000 50,000 50,000 50,000 50,000 591.301 Trsf to Capital Imp Fund 0 0 0 0 0 Interfund Transfers Out 80,000 50,000 50,000 50,000 50,000 0 0 0 Interfund Transfers 80,000 50,000 50,000 50,000 50,000 0 0 0 Total Expenditures 158,211 50,000 50,000 50,000 50,000 0 0 0 Capital Projects Fund -158,211 0 0 -50,000 0 0 0 0 BUDGET WORKSHEET June 30, 201411:49 am Page: 25 6/3012014 Village of Tequesta 11:49 am Prior ----------- Current Year ----------- (6) (7) (8) Year O�ginal Amended Actuaf Thru Estimated Monih:613012014 Actual Budget Budget June 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 500 500 0 0 343.301 WaterSales 2,129,978 2,375,000 2,375,000 1,544,792 2,250,000 2,300,000 2,300,000 343.302 Water- Connect Charges 17,995 15,000 15,000 15,088 17,000 17,000 17,000 343.303 Water-Fire Hydrants Rent 64,268 65,000 65,000 49,171 65,000 66,300 66,300 343.304 Water Surcharge 361,277 380,000 380,000 242,277 375,000 382,500 382,500 343.306 Monthly Service Charge 1,385,257 1,485,000 1,485,000 1,046,623 1,395,000 1,423,000 1,423,000 343.307 Penalty Charges 5,002 4,500 4,500 3,791 4,500 4,500 4,500 343.308 OtherWaterService Income 1,541 1,500 1,500 1,176 1,500 1,500 1,500 343.309 Convenience Fee - CC 0 500 500 0 0 343.700 Water Conservation & Resource 1,514 1,000 1,000 503 1,000 1,000 1,000 343.950 Allow for doubful rev - Enterp 0 0 0 0 0 Charges for Services 3,966,832 4,328,000 4,328,000 2,903,421 4,109,000 4,195,800 4,195,800 0 Acct Class: 369 Miscellaneous Revenues 363.101 MartiNTropicV-Constportion 23,145 15,900 15,900 32,395 17,127 16,000 16,000 369.000 Other Miscellaneous Revenue 0 0 7,455 7,463 7,500 369.100 Insurance Reimbursement 8,361 8,000 8,000 7,863 7,863 8,000 8,000 Miscellaneous Revenues 31,506 23,900 31,355 47,721 32,490 24,000 24,000 0 Acct Class: 390 Other Financing Sources 369.110 Capital Connect Charge - Cust 20,581 20,000 20,000 7,304 7,304 369.111 Capital Connect Charge - Devel 10,709 12,000 12,000 7,304 7,304 369.112 CapitalConnect -TropicVist 20,633 14,200 14,200 0 15,268 14,000 14,000 Other Financing Sources 51,923 46,200 46,200 14,608 29,876 14,000 14,000 0 General 4,050,261 4,398,100 4,405,555 2,965,750 4,171,366 4,233,800 4,233,800 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investment Eamin 361.100 Interest/Investment Earnings 11,189 10,000 10,000 7,193 0 9,500 9,500 361.105 Int Income - Tropic Vista Asse 0 0 0 0 0 367.100 Net Unreal appreciation (Dep) 7,356 0 0 2,205 0 Unrestricted Investment Eamin 18,545 10,000 10,000 9,398 0 9,500 9,500 0 Acct Class: 369 Miscellaneous Revenues 364.100 Disposition of Assets 5,510 0 0 0 0 Miscellaneous Revenues 5,510 0 0 0 0 0 0 0 Other Nonoperating 24,055 10,000 10,000 9,398 0 9,500 9,500 0 Dept: 990 OthedReserve/Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 0 837,621 0 0 696,820 703,920 Other Financing Sources 0 0 837,621 0 0 696,820 703,920 0 BUDGET WORKSHEET June 30, 201411:49 am Page: 26 Village of Tequesta 6I30/2014 11:49 am Prior ------------CurrentYear-------------- (6) ��) �$) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Revenues Other/Reserve/Contingency 0 0 837,621 0 0 696,820 703,920 0 Total Revenues 4,074,316 4,408,100 5,253,176 2,975,148 4,171,366 4,940,120 4,947,220 0 Expenditures Dept: 241 Water-Administration Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 139,413 139,700 139,700 98,283 139,500 162,300 162,300 515.103 Bonus Pay Plan 0 0 3,150 3,150 3,150 515.108 Auto Allowance 3,000 3,000 3,000 2,250 3,000 3,000 3,000 515.125 OtherAllowances 1,200 1,200 1,200 900 1,200 1,200 1,200 516.100 Compensated Absences 1,753 5,000 5,818 4,613 8,600 13,500 13,500 516.105 Compensated Absences - HSA 3,430 0 0 0 0 521.101 FICA Taxes 7,093 7,300 7,438 5,331 7,400 8,700 8,700 521.102 MedicareTaxes 2,273 2,200 2,359 1,607 2,350 2,600 2,600 522.102 VOT Pension Contributions 13,076 12,900 12,900 9,022 12,800 13,700 13,700 523.101 Life/Health Insurance 10,316 12,600 12,600 9,502 12,550 12,200 12,200 523.105 HSA - Heaith Savings Account 1,400 0 0 0 0 524.100 Workers' Comp Insurance 411 310 310 231 310 310 310 526.104 ICMA-Def Comp Plan 9,826 9,900 9,900 6,927 9,830 10,300 10,300 554.301 Personnel Training 0 0 750 750 750 Personal Services 193,191 194,110 199,125 142,566 201,440 227,810 227,810 0 Acct Class: 530 Operating Expenditures/Expense 531.301 LegalServices 1,235 7,500 6,250 8,205 2,000 2,000 2,000 531.302 Engineering Services 19,478 25,000 101,500 46,160 101,500 140,000 140,000 532.300 Accounting & Auditing Services 27,800 28,100 27,750 27,750 27,750 28,620 28,620 534.300 OtherContractualServices 21,850 24,000 24,500 15,960 29,000 21,000 21,000 544.304 FEC Lease 12,357 13,050 12,535 12,531 12,535 13,000 13,000 545.3001nsurance 46,770 47,600 47,600 37,616 48,050 48,050 48,050 549.301 Admin Mgmt Fees 485,229 499,785 499,785 374,839 499,785 514,780 514,780 549.304 Licenses, Fees & Permits 781 800 800 781 781 800 800 Operating Expenditures/Expense 615,500 645,835 720,720 523,842 721,401 768,250 768,250 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 3,400 0 0 0 Other Financing Sources & Uses 0 3,400 0 0 0 0 0 0 Water-Administration 808,691 843,345 919,845 666,408 922,841 996,060 996,060 0 Dept: 242 Water - Production Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 370,269 397,000 387,000 271,811 383,900 484,100 484,100 514.100 Overtime 8,154 8,000 9,000 4,038 9,000 9,000 9,000 BUDGET WORKSHEET June 30, 201411:49 am Page: 27 Village of Tequesta 6/30/2014 11:49 am Prior ------------ Current Year -------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/3012014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Expenditures Dept: 242 Water- Production Acct Class: 510 Personal Services 515.102 Standby Pay 5,119 6,000 6,000 3,510 6,000 6,000 6,000 515.103 Bonus Pay P1an 0 0 3,000 3,000 3,000 515.106 Clothing & Boot Allowance 600 600 600 600 600 800 800 516.100 Compensated Absences 1,288 5,000 5,000 2,622 5,000 5,000 5,000 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICATaxes 23,487 25,400 25,400 16,747 25,400 30,100 30,100 521.102 MedicareTaxes 5,493 6,000 6,000 3,916 6,000 7,100 7,100 522.101 FRS Conhibutions 3,950 3,900 5,000 3,334 5,000 5,200 5,200 522.102 VOT Pension Contributions 27,918 29,800 29,800 20,197 28,715 34,400 34,400 523.101 Life/Health Insurance 51,743 63,200 78,500 57,999 78,500 91,200 91,200 523.105 HSA - Health Savings Account 1,700 0 0 0 0 523.110 Retiree Health Care Expense 0 0 0 0 0 524.100 Workers' Comp Insurance 11,270 12,870 12,870 9,649 12,870 12,870 12,870 554.301 PersonnelTraining 395 1,500 1,500 1,094 1,500 2,000 2,000 Personal Services 511,386 559,270 569,670 398,517 565,485 687,770 687,770 0 Acct Class: 530 Operating Expenditures/Expense 531.342 WaterAnalysis & Sampling 33,422 48,530 48,530 21,000 40,000 44,000 44,000 540.300 Travel & Per Diem 264 3,000 3,000 1,973 2,500 3,500 3,500 541.300 Communication Services 9,311 9,400 9,400 6,907 9,400 9,400 9,400 541.301 Postage 836 1,500 2,500 1,157 2,500 2,000 2,000 543.300 UtilityServices 325,275 394,000 344,430 211,795 340,000 357,000 357,000 544.301 Operating Leases 10,240 9,400 10,800 8,390 10,600 10,000 10,000 546.302 Vehicle Repair & Maintenance 4,295 3,000 5,000 3,994 4,000 4,000 4,000 546.303 Building Repair & Maint 14,582 28,500 28,500 9,590 25,000 20,000 20,000 546.309 Landscape & Irrigation Maint 4,632 3,000 19,000 17,503 18,000 6,000 6,�0� 546.310 Equipment Repair 8 Maint 14,054 28,000 73,490 22,086 73,490 20,000 20,000 546.320 Computer system maint & suppli 2,888 8,400 8,400 2,831 8,400 16,700 14,900 546.342 Water System Maintenance 111,718 70,000 90,965 40,851 70,000 70,000 70,000 546.343 Well Redevelopment 29,785 30,000 49,000 12,998 49,000 80,000 80,000 547.300 Printing & Binding 1,891 2,500 4,000 3,779 4,000 3,000 3,000 549.300 Other Misc Chgs & Obligations 5,858 2,000 2,000 1,652 2,000 2,000 2,006 549.304 Licenses,Fees & Permits 22,534 30,000 30,000 21,034 30,000 30,000 30,000 551.300 Office Supplies & Equipment 3,153 2,500 2,500 1,591 2,000 2,500 2,500 552.301 Gas & Oil 5,550 8,100 8,100 2,927 5,000 5,000 5,000 552.302 Small Tools and Equipment 1,615 3,000 3,000 908 2,500 3,000 3,000 552.303 Diesel Fuel 7,430 15,000 15,000 0 4,000 15,000 15,000 BUDGET WORKSHEET June 30, 201411:49 am Page: 28 6I30/2014 �Ilage of Tequesta 11:49 am Prior --�--------- Current Year ------------ (6) (7) (g) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 401- Water Fund Expenditures Dept: 242 Water- Production Acct Class: 530 Operating Expenditures/Expense 552.305 Uniforms 1,494 1,500 2,500 2,123 2,500 2,500 2,500 552.341 Water Purchases 0 30,000 30,000 0 0 30,000 30,000 552.342 WaterChemicals 133,731 188,000 176,100 102,587 160,000 168,000 168,000 552.343 Laboratory Supplies 15,891 14,000 14,000 10,230 14,000 14,000 14,000 554.300 Books, Publ, Subs & Membership 1,552 1,600 1,600 878 1,500 1,600 1,600 Operating Expenditures/Expense 762,001 934,930 981,815 508,784 880,390 919,200 917,400 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 3,230 0 0 0 Other Financing Sources & Uses 0 3,230 0 0 0 0 0 0 Water- Production 1,273,387 1,497,430 1,551,485 907,301 1,445,875 1,606,970 1,605,170 0 Dept: 243 Water-Distribution Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 368,002 387,800 388,000 273,247 388,000 386,500 386,500 514.100 Overtime 3,769 5,000 5,000 2,452 5,000 5,000 5,000 515.102 Standby Pay 9,212 8,500 9,850 7,265 9,850 10,000 10,000 515.103 Bonus Pay Plan 0 0 3,000 3,000 3,000 515.106 Clothing & Boot Allowance 600 500 500 500 500 500 500 515.107 Part-time Salaries 41,111 0 0 0 0 515.108 Auto Aliowance 2,400 0 0 0 0 516.100 Compensated Absences 19,412 5,000 5,000 2,094 5,000 5,000 5,000 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 26,751 24,300 24,300 16,789 24,300 24,500 24,500 521.102 Medicare Taxes 6,256 5,700 5,706 3,926 5,700 5,800 5,800 522.101 FRS Conhibutions 7,889 8,200 10,000 6,954 10,000 10,700 10,700 522.102 VOT Pension Contributions 21,950 23,100 23,100 16,194 23,005 20,700 20,700 523.101 Life/Health Insurance 72,987 94,100 94,950 67,685 94,950 60,300 60,300 523.105 HSA - Health Savings Account 2,700 0 0 0 0 523.110 Retiree Health Care Expense 0 0 0 0 0 524.100 Workers' Comp Insurance 10,917 9,090 9,090 6,815 9,090 9,090 9,090 525.100 Unemployment Compensation 0 0 0 0 0 554.301 PersonnelTraining 125 1,500 710 386 710 1,500 1,500 Personal Services 594,081 572,790 579,200 407,307 579,105 539,590 539,590 0 Acct Class: 530 Operating Expenditures/Expense 540.300 Travel & Per Diem 152 500 500 92 500 500 500 541.300 Communication Services 6,000 7,700 6,000 3,901 6,000 6,000 6,000 541.301 Poslage 22,797 23,000 23,000 10,910 23,000 23,000 23,000 544.301 Operating Leases 2,788 4,500 3,200 2,092 3,121 3,200 3,200 BUDGET WORKSHEET June 30, 201411:49 am Page: 29 6/30/2014 Village of Tequesta 11:49 am Prior ---------- Current Year -------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund E�enditures Dept: 243 Water-Distribution Acct Class: 530 Operating Expenditures/Expense 546.301 OfficeEquiplRepair&Maint 679 1,200 1,020 241 900 1,200 1,200 546.302 Vehicle Repair & Maintenance 5,210 7,000 7,000 6,869 7,300 8,500 8,500 546.303 Building Repair & Maint 2,435 5,000 5,000 905 5,000 5,000 5,000 546.309 Landscape &Irrigation Maint 239 900 900 859 900 900 900 546.310 Equipment Repair & Maint 5,416 5,000 5,000 3,136 5,000 5,000 5,000 546.320 Computer system maint & suppli 7,588 6,900 6,900 5,256 6,900 10,200 8,400 546.342 Water System Maintenance 19,302 25,000 25,000 17,343 25,000 35,000 35,000 547.300 Printing & Binding 2,642 3,000 3,000 2,439 3,000 3,000 3,000 549.300 Other Misc Chgs & Obligations 4,356 2,500 2,500 818 2,500 2,500 2,500 549.304 Licenses, Fees & Permits 1,607 1,700 1,700 1,427 1,700 1,700 1,700 551.300 Office Supplies & Equipment 1,500 1,500 1,500 332 1,500 1,500 1,500 552.301 Gas & Oil 14,315 14,000 14,000 9,417 14,000 14,000 14,000 552.302 Small Tools and Equipment 1,094 4,000 4,000 2,706 4,000 4,000 4,000 552.305 Uniforms 1,453 2,000 2,000 1,564 2,000 2,000 2,000 Operating Expenditures/Expense 99,573 115,400 112,220 70,307 112,321 127,200 125,400 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 3,230 0 0 0 Other Financing Sources & Uses 0 3,230 0 0 0 0 0 0 Water-Distribution 693,654 691,420 691,420 477,614 691,426 666,790 664,990 0 Dept: 411 Renewal & Replacement Acct Class: 530 Operating ExpenditureslExpense 546.605 R&M - Well Site Rehab 2,550 4,000 4,000 1,790 2,500 4,000 4,000 549.671 Misc. Renewal & Replacement 116,017 60,000 787,951 75,048 787,000 310,000 310,000 552.601 Meters,Vaives & Hydrants 30,289 30,000 37,455 25,918 37,455 60,000 60,000 552.603 Filter Cartridges/ROP 3,030 7,000 7,000 0 5,000 7,000 7,000 Operating Expenditures/Expense 151,886 101,000 836,406 102,756 831,955 381,000 381,000 0 Acct Class: 600 Capital Outlay 663.671 Misc. Renewel and Replacement 0 0 0 0 0 664.600 Mach/Equipment 0 0 0 0 0 25,000 25,000 664.601 ComputerEquipment 0 1,500 1,500 0 1,500 664.602 Vehicles 0 33,500 36,500 36,496 36,500 136,000 136,000 Capital0utlay 0 35,000 38,000 36,496 38,000 161,000 161,000 0 Renewal & Replacement 151,886 136,000 874,406 139,252 869,955 542,000 542,000 0 Dept: 412 Capitallmprovement Acct Class: 600 Capital Outlay 664.600 Mach/Equipment 0 68,000 57,000 2,330 52,510 Capital0utlay 0 68,000 57,000 2,330 52,510 0 0 0 BUDGET WORKSHEET June 30, 201411:49 am Page: 30 6/30I2Q14 Village of Tequesta 11:49 am Prior ----------- Current Year ------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund Expenditures Capitallmprovement 0 68,000 57,�00 2,330 52,510 0 0 0 Dept: 700 Debt Service Acct Class: 471 D/S - Principal 571.705 Prin - 2004 Water N/P BOA 0 30,000 30,000 30,000 30,000 32,000 32,000 571.720 Prin - 2008 Water Utility Note 0 277,900 277,900 207,418 277,900 287,890 287,890 D/S - Principal 0 307,900 307,900 237,418 307,900 319,890 319,890 0 Acct Class: 472 D/S -Interest 572.705 Int-2004 Water N/P BOA 14,887 14,100 14,100 8,208 14,100 12,600 12,600 572.720 Int-2008 Water Utility Note 201,533 192,200 192,200 128,526 192,200 191,310 191,310 573.700 Other Debt Service Costs 46,676 25,000 25,000 0 23,000 23,000 23,000 D/S -Interest 263,096 231,300 231,300 136,734 229,30Q 226,910 226,910 0 DebtService 263,096 539,200 539,200 374,152 537,200 546,800 546,800 0 Dept: 910 Other Financing Sources & Uses Acct Class: 590 Other Financing Sources & Uses 567.000 Gain/Loss on Investments 0 0 0 0 0 567.100 Unrealized Loss on Investments 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Dept: 950 Other Nonoperating Acct Class: 530 Operating Expenditures/Expense 559.300 Depreciation 1,000,083 0 0 0 0 559.301 Budgeted Depreciation (netted) 0 605,320 605,320 0 605,320 565,000 565,000 Operating Expenditures/Expense 1,000,083 605,320 605,320 0 605,320 565,000 565,000 0 Acct Class: 590 Other Financing Sources & Uses 549.391 Bank Charges 10,038 10,000 10,000 6,799 10,000 10,000 10,000 549.395 Credit Card Fees and Charges 4,118 4,500 4,500 4,114 5,500 6,500 6,500 590.001 Allocate to Fund Balance 0 12,885 0 0 0 999.001 Suspense 0 0 0 0 0 999.200 Suspense-AIP 0 0 0 0 0 Other Financing Sources & Uses 14,156 27,385 14,500 10,913 15,500 16,500 16,500 0 OtherNonoperating 1,014,239 632,705 619,820 10,913 620,820 581,500 581,500 0 Dept: 990 OthedReserve/Contingency Acct Class: 590 Other Financing Sources & Uses 599.902 Reserves - Con6ngency 0 0 0 0 0 10,700 Other Financing Sources & Uses 0 0 0 0 0 0 10,700 0 Other/Reserve/Contingency 0 0 0 0 0 0 10,700 0 Total Expenditures 4,204,953 4,408,100 5,253,176 2,577,970 5,140,627 4,940,120 4,947,220 0 Water Fund -130,637 0 0 397,178 -969,261 0 0 0 BUDGET WORKSHEET June 30, 201411:49 am Page: 31 Village of Tequesta 6I30/2014 11:49 am Prior ------------ Current Year ------------- (6) (7) (g) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 402 - Refuse & Recycling Revenues Dept: 000 General Acct Class: 335 Intergovernmental Revenue 338.110 Recycling Shared Rev - SWA 8,690 7,300 7,300 3,445 5,000 5,000 5,000 Intergovemmental Revenue 8,690 7,300 7,300 3,445 5,000 5,000 5,000 0 Acct Class: 340 Charges for Services 343.307 Penalty Charges 1 0 0 1 0 343.400 Refuse / Recycling Fees 473,731 472,680 472,680 461,455 472,245 472,245 472,245 ChargesforServices 473,732 472,680 472,680 461,456 472,245 472,245 472,245 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 9,855 9,855 0 0 22,175 22,175 Other Financing Sources 0 9,855 9,855 0 0 22,175 22,175 0 General 482,422 489,835 489,835 464,901 477,245 499,420 499,420 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investment Eamin 361.100 Interest/lnvestment Eamings 170 200 200 113 175 175 175 361.101 PBC Tax Col-Interest on Dep 71 100 100 10 0 367.100 Net Unreai appreciation (Dep) 424 300 300 138 200 200 200 Unrestricted Investment Eamin 665 600 600 261 375 375 375 0 Other Nonoperating 665 600 600 261 375 375 375 0 Total Revenues 483,087 490,435 490,435 465,162 477,620 499,795 499,795 0 Expenditures Dept: 241 Water-Administration Acct Class: 510 Personal Services 515.103 Bonus Pay Plan 0 0 0 0 0 Personal5ervices 0 0 0 0 0 0 0 0 Water-Administration 0 0 0 0 0 0 0 0 Dept: 242 Water- Production Acct Class: 510 Personai Services 515.103 Bonus Pay Plan 0 0 0 0 0 Personal Services 0 0 0 0 0 0 0 0 Water- Production 0 0 0 0 0 0 0 0 Dept: 243 Water-Distribution Acct Class: 510 Personal Services 515.103 Bonus Pay Plan 0 0 0 0 0 Personal Services 0 0 0 0 0 0 0 0 Water-Distribution 0 0 0 0 0 0 0 0 Dept: 245 Refuse and Recyding BUDGET WORKSHEET June 30, 201411:49 am Page: 32 Village of Tequesta 6I30/2014 11:49 am Prior ------------- Current Year ------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 402 - Refuse & Recycling Expenditures Dept: 245 Refuse and Recycling Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 0 0 0 0 0 543.302 Solid Waste/Residential 248,735 251,905 251,905 167,831 251,747 257,810 257,810 543.303 Recycling/Residential 87,902 89,090 89,090 59,355 89,033 91,310 91,310 543.304 Yard Waste/Residential 82,528 83,715 83,715 55,773 83,660 85,555 85,555 543.306 Fuel Factor 57,961 58,370 58,370 38,888 58,332 57,550 57,550 549.300 Other Misc Chgs & Obligations 189 300 300 190 300 300 300 549.301 Admin Mgmt Fees 6,850 7,055 7,055 5,291 7,055 7,270 7,270 Operating Expenditures/Expense 48A,165 490,435 490,435 327,328 490,127 499,795 499,795 0 Refuse and Recycling 484,165 490,435 490,435 327,328 490,127 499,795 499,795 0 Dept: 910 Other Financing Sources & Uses Acct Class: 590 Other Financing Sources & Uses 567.000 Gain/Loss on Investments 0 0 0 0 0 567.100 Unrealized Loss on Investments 0 0 0 0 0 Other 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 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 Total Expenditures 484,165 490,435 490,435 327,328 490,127 499,795 499,795 0 Refuse & Recyciing -1,078 0 0 137,834 -12,507 0 0 0 BUDGET WORKSHEET June 30, 201411:49 am Page: 33 6/30/2014 Village of Tequesta 11:49 am Prior ------------ Current Year -------------- (6) �7) �$) Year Original Amended Acival Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 403 - Stormwater Utility Revenues Dept: 000 General Acct Class: 340 Charges for Services 343.901 Storm Water Utiliry Fees 323,513 318,000 318,000 316,100 318,000 318,000 318,000 Charges for Services 323,513 318,000 318,000 316,100 318,000 318,000 318,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,513 318,000 318,000 316,100 318,000 318,000 318,000 0 Dept: 950 Other Nonoperating Acct Class: 361 Unrestricted Investrnent Eamin 361.1001nteresUlnvestmentEamings 1,027 1,100 1,100 683 0 1,100 1,100 361.101 PBC Tax Col-Interest on Dep 46 50 50 7 0 367.100 Net Unreal appreciation (Dep) 444 0 0 154 0 Unrestricted Investrnent Eamin 1,517 1,150 1,150 844 0 1,100 1,100 0 OtherNonoperating 1,517 1,150 1,150 844 0 1,100 1,100 0 Dept: 990 OthedReservelContingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 0 0 0 0 146,000 146,250 Other Financing Sources 0 0 0 0 0 146,000 146,250 0 Other/Reserve/Contingency 0 0 0 0 0 146,000 146,250 0 Total Revenues 325,030 319,150 319,150 316,944 318,000 465,100 465,350 0 Expenditures Dept: 241 Water-Administration Acct Class: 510 Personal Services 515.103 Bonus Pay Plan 0 0 0 0 0 Personal Services 0 0 0 0 0 0 0 0 Water-Administration 0 0 0 0 0 0 0 0 Dept: 243 Water-Distribution Acct Class: 510 Personal Services 515.103 Bonus Pay Plan 0 0 0 0 0 Personal Services 0 0 0 0 0 0 0 0 Water-Distribution 0 0 0 0 0 0 0 0 Dept: 250 Storm Water Utilities Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 43,918 60,500 60,500 42,352 59,962 59,200 59,200 514.100 Overtime 509 1,000 1,000 412 1,000 1,000 1,000 515.102 Standby Pay 1,689 1,400 2,300 1,329 2,300 2,000 2,000 515.103 Bonus Pay Plan 0 0 1,500 1,500 1,500 515.106 Clothing & Boot Allowance 100 150 150 150 150 150 150 515.108 AutoAllowance 750 900 1,800 1,350 1,800 450 450 BUDGET WORKSHEET June 30, 201411:49 am Page: 34 Village of Tequesta 6130/2014 11:49 am Prior ------------ Current Year ------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 403 - Stormwater Utility Expenditures Dept: 250 Storm Water Utilities Acct Class: 510 Personal Services 516.100 Compensated Absences 560 0 0 0 0 516.105 Compensated Absences - HSA 0 0 0 0 0 521.101 FICA Taxes 2,407 3,500 3,728 2,607 3,700 3,800 3,800 521.102 Medicare Taxes 563 900 919 610 919 900 900 522.102 VOT Pension Confibutions 4,120 5,600 5,600 3,728 5,505 5,000 5,000 523.101 Life/Health Insurance 16,720 24,400 20,128 14,613 17,430 10,800 10,800 523.105 HSA - Health Savings Account 850 0 0 0 0 524.100 Workers' Comp Insurance 1,094 2,800 2,800 2,099 2,800 2,800 2,800 554.301 Personnel Training 0 0 0 0 0 Personal Services 73,280 101,150 100,425 70,750 97,066 86,100 86,100 0 Acct Class: 530 Operating Expenditures/Expense 531.302 Engineering Services 6,042 8,000 11,545 14,835 11,545 36,500 36,500 532.300 Accounting & Auditing Services 3,892 4,000 4,000 3,885 3,885 4,010 4,010 540.300 Travel & Per Diem 0 0 0 0 0 541.300 Communication Services 1,680 1,900 1,900 1,217 1,800 1,900 1,900 541.301 Postage 0 300 300 0 300 300 300 546.302 Vehicie Repair & Maintenance 701 500 1,500 961 1,500 2,000 2,000 546.303 Building Repair& Maint 1,806 2,000 1,000 199 1,000 2,000 2,000 546.308 Drainage Maintenance 12,294 25,000 24,000 11,318 24,000 285,000 285,000 546.310 Equipment Repair& Maint 1,356 1,500 1,500 1,446 1,500 2,500 2,500 546.320 Computer system maint 8 suppli 293 800 800 275 800 1,200 750 549.300 OtherMiscChgs&Obligations 145 1,000 1,000 490 1,000 1,000 1,000 549.301 AdminMgmtFees 11,630 11,920 12,020 8,983 11,978 12,340 12,340 549.304 Licenses, Fees 8� Permits 4,109 4,500 4,500 4,099 4,100 4,500 4,500 551.300 Office Supplies & Equipment 117 300 300 0 300 300 300 552.301 Gas & Oil 2,331 3,000 2,700 1,434 2,000 2,700 2,700 552.302 Small Tools and Equipment 1,822 1,200 1,200 487 1,200 7,500 7,500 554.100 Public Education Program 0 500 500 0 500 250 250 Operating Expenditures/Expense 48,218 66,420 68,765 49,629 67,408 364,000 363,550 0 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 1,620 0 0 0 Other Financing Sources & Uses 0 1,620 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 662.632 Architect & Engeering 0 0 0 0 0 663.663 Drainage Improvements 0 0 0 0 0 664.600 Mach/Equipment 0 0 0 0 0 15,000 15,000 664.602 Vehicles 0 30,000 30,000 21,797 30,000 BUDGET WORKSHEET June 30, 201411:49 am Page: 35 Village of Tequesta 6/3012014 11:49 am Prior -------------- Current Year ------------- (6) (7) (8) Year Original Amended Actual Thru Estimated Month:6/30/2014 Actual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 403 - Stormwater Utility Expenditures Dept: 250 Storm Water Utilities Capital0utlay 0 30,000 30,000 21,797 30,000 15,000 15,000 0 StormWaterUtilities 121,498 199,190 199,190 142,176 194,474 465,100 464,650 0 Dept: 910 Other Financing Sources & Uses Acct Class: 590 Other Financing Sources & Uses 567.100 Unrealized Loss on Investments 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Dept: 950 Other Nonoperating Acct Class: 530 Operating Expenditures/Expense 559.300 Depreciation 99,785 0 0 0 0 559.301 Budgeted Depreciation (netted) 0 70,250 70,250 0 0 Operating Expenditures/Expense 99,785 70,250 70,250 0 0 0 0 0 Acct Ciass: 590 Other Financing Sources & Uses 590.001 Allocate to Fund Balance 0 49,710 49,710 0 0 Other Financing Sources & Uses 0 49,71d 49,710 0 0 0 0 0 Other Nonoperating 99,785 119,960 119,960 0 0 0 0 0 Dept: 990 OthedReserve/Contingency Acct Class: 590 Other Financing Sources & Uses 599.902 Reserves - Contingency 0 0 0 0 0 700 Other Financing Sources 8 Uses 0 0 0 0 0 0 700 0 Other/Reserve/Contingency 0 0 0 0 0 6 700 0 Total Expenditures 221,283 319,150 319,150 142,176 194,474 465,100 465,350 0 Stormwater Utility 103,747 0 0 174,768 123,526 0 0 0 Grand Total: -531,957 0 0 2,192,293 -1,188,402 -120,191 0 0