Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Handouts_Special Meeting_Tab 01_06/30/2010 Budget
General Fund Budget Summary Village of Tequesta Fiscal Year 2010/2011 Estimated Revenues The Village of Tequesta Ad Valorem Taxes 4,355,960 OtherTaxes 1,226,760 Fiscal Year 2010/2011 Franchise Fees 385,000 Licenses & Permits 242,400 Budget in Brief Intergovernmental Revenues 733,110 Charges for Services 823,100 Miscellaneous Revenues 209,770 Intragovernmental Revenues 323,110 Unrestricted Inv Earnings 32,000 T Revenues 8,331,210 Highlights: Transfers In 250,000 • The proposed fiscal year 201012011 Fund Balances / R ese rv e s /Net Assets 250,000 millage rate is 5.7671 Total Revenues Transfers & Balances 8,831,210 • This is 2.25% lower than the 1993 Estimated Expenditures millage rate of 5.9000. General Government 1,327,110 it is also 6.91% less than the rolled back rate of 6.1949. (The rolled back Public Safety 5,750,805 rate is the millage rate that would be T ransportation 733,080 imposed in order to generate the le isure Services 559,340 some amount of ad valorem taxes as E D ebt Service 419,400 received in the prior year.) ether Financing Uses 12,000 • Property values dropped 6.9% from otal Expenditu 8,801,735 2009 which resulted in a 6.2% Transfers Out 0 decrease in ad valorem taxes. Fund Balances /Reserves /Net A 29,475 • Proposed budgeted expenditures in I otal Appropriated Expenditures, the General Fund for fiscal year r ansfers, Reserves & Balances 8,831,210 The Village of Tequesta 201012011 are 3.21% less than the Village Hall fiscal year 200912010 original Other Funds Proposed Total Budgets budgeted expenditures. _ pital Improvement Fund 250,000 345 Tequesta Drive � Tequesta, FL 33469 Despite the projected decrease in ater Utility Fund 4,034,370 revenues and e the Phone: 561 - 575 -6200 p Refuse & Recycling To Be Announced Fax: 561 - 575 -6203 Village strives to sustain current Stormwater Fund 422,850 service levels. Tequesta at a Glance Where the Money Comes From Final Gross Taxable Value Date of Incorporation General Fund h 1,100 c 1,000 June 4, 1957 j a 3% ��3�o � 800 Form of Government 4% 3� � 700 600 Council - Manager 4% 400 r1 N M It Ln lD n 00 0) O c Village Council 0 0 00 00 0 0 0 0 0 0 0 0 0 00000 N N N N N N N N N N N Pat Watkins Mayor Tom Paterno Vice -Mayor Total Taxes Levied Vince Arena Council Member Jim Humpage Council Member 6 C 0 5 lawff Calvin Turnquest Council Member H Ad Valorem Taxes 49% ■Other Taxes 14% 4 Village Manager W Charges for Services 9% ■ Intergovernmental Revenue 8% 3 Michael R. Couzzo, Jr. o Franchise Fees 4% o Intragovernmental Revenue 4% 2 W Licenses & Permits 3% u Transfers In 3% 0 0 0 0 0 0 0 00 0 0 � 14 O O O O O O O O O O O u Fund Balances /Reserves 3% u Miscellaneous Revenue 3% N N N N N N N N N N N Adopted Millage Rate vs. Rolled Back Rate u Unrestricted Investment Earning 0% Projected Cash and Investment 7 Balances at FYE 09/30/10 b Where the Money Goes Y Fund 6.8 6.6 General Fund o General Fund 1% - $3,664,034 6.4 ■ Water Fund 6.2 $3,399,802 W Capital Imp. Fund 6 $492,596 5.8 ■ Stormwater Fund $396,220 5.6 v Capital Proj. Fund $267,773 5.4 11 Refuse & Rec. Fund 5.2 $103,919 1 N M-T Ln tD r 00 rn 01 0 0 0 0 0 0 0 0 0 -1-1 O N 0 0 0 0 0 0 0 0 0 N O Public Safety 65% ■ General Government 15% •m*wMilla a Rate ■Rolled Back Rate , W Transportation 8% ■ Leisure Services 6% g Data charted in yellow on the graphs in this document was W Debt Service 5% o Fund Balances /Reserves 1% obtained from the DR -420. The other data was obtained from W Other Financing Uses 0% V Transfers Out 0% the DR -422. BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 1 6/30/2010 Village of Tequesta 5:30 pm Prior - --------------- - - - - -- Current Year - - - - - -- (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 - General Fund Revenues Function: 000 General Revenues Dept: 000 General Acct Class: 311 General Property Taxes 311.000 Ad Valorem Taxes - Current 5,162,044 4,636,000 4,636,000 4,515,832 4,636,000 4,350,960 4,350,960 4,350,960 311.100 Ad Valorem Taxes -Del 11,764 0 0 4,333 5,000 5,000 5,000 5,000 General Property Taxes 5,173,808 4,636,000 4,636,000 4,520,165 4,641,000 4,355,960 4,355,960 4,355,960 Acct Class: 316 Other Taxes 314.100 Utility Tax - Electricity 400,266 385,000 385,000 280,914 400,000 400,000 400,000 400,000 314.300 Utility Tax -Water 143,697 145,000 145,000 103,294 145,000 145,000 145,000 145,000 314.800 Utility Tax - Propane 15,399 13,000 13,000 20,323 20,000 18,000 18,000 18,000 314.900 Miscellaneous taxes 0 0 0 0 0 315.000 Comm.Services Tax (CST) 432,100 384,740 384,740 258,709 385,000 377,260 377,260 377,260 321,000 Local Business Tax (Occ Lic) 88,455 82,500 82,500 79,684 79,706 80,000 80,000 80,000 321.001 Home Business Tax 3,145 4,000 4,000 4,944 4,944 4,500 4,500 4,500 Other Taxes 1,083,062 1,014,240 1,014,240 747,868 1,034,650 1,024,760 1,024,760 1,024,760 Acct Class: 318 Franchise fees - gross receipt 313.100 Fran Fees - Electric 466,541 490,000 490,000 293,554 426,500 385,000 385,000 385,000 Franchise fees - gross receipt 466,541 490,000 490,000 293,554 426,500 385,000 385,000 385,000 Acct Class: 329 Intragovemmental Revenue 341.401 Admin Mgmt Fees-Water 277,190 291,150 291,150 218,363 291,150 305,700 305,700 341.402 Admin Mgmt Fee -Ref & Recycling 5,860 6,150 6,150 4,613 6,150 6,450 6,450 341.403 Admin Mgmt Fees - Storm Water 9,940 10,440 10,440 7,830 10,440 10,960 10,960 Intragovemmental Revenue 292,990 307,740 307,740 230,806 307,740 0 323,110 323,110 Acct Class: 331 Grants Federal 369.104 Reimb - FEMA 9,209 0 0 0 0 Grants Federal 9,209 0 0 0 0 0 0 0 Acct Class: 335 Intergovernmental Revenue 335.120 State Revenue Sharing Proceeds 170,190 167,170 167,170 112,123 170,000 167,170 167,170 167,170 335.150 Alcoholic Beverage Licenses 5,893 4,000 4,000 4,332 4,332 4,000 4,000 4,000 335.180 Local Govt Half -Cent Sales Tax 361,628 343,810 343,810 248,514 348,500 345,000 345,000 375,000 338.101 Local Gas Tax -6 Cent 111,829 108,150 108,150 76,443 110,000 108,150 108,150 108,150 338.102 Local Gas Tax 1 -5 Cent 53,076 50,560 50,560 35,800 52,000 50,550 50,550 50,550 338.110 Shared Revenue - SWA 0 0 0 6,484 6,484 Intergovernmental Revenue 702,616 673,690 673,690 483,696 691,316 674,870 674,870 704,870 Acct Class: 341 Chgs for Sery - Gen Gov 341.101 Certification /Copy Fees 2,732 1,000 1,000 5,604 6,000 6,000 6,000 6,000 341.103 Election qualifying fees 60 100 100 150 150 150 150 150 341.105 Admin fees from other Gov'ts 469 1,000 1,000 914 1,000 1,000 1,000 1,000 341.900 Other Genl Gov Charges & Fees 31 0 0 0 0 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 2 6/30/2010 Village of Tequesta 5:30 pm Prior ------ - - - - -- Current Year-- - - - - -- (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 -General Fund Revenues Function: 000 General Revenues Dept: 000 General Chgs for Sery - Gen Gov 3,292 2,100 2,100 6,668 7,150 7,150 7,150 7,150 Acct Class: 361 Unrestricted Investment Eamin 361.100 Interest/Investment Eamings 6,681 55,000 55,000 16,131 27,500 30,000 30,000 30,000 361.101 PBC Tax Col - Interest on Dep 2,044 2,000 2,000 896 896 2,000 2,000 2,000 361.300 Net Change in FMV 0 0 0 0 0 Unrestricted Investment Eamin 8,725 57,000 57,000 17,027 28,396 32,000 32,000 32,000 Acct Class: 362 Rents & Royalties 362.100 Rental -Facilities 0 0 0 5,962 7,665 2 9,517 30,400 30,400 23,313 30,400 31,310 31,310 31,310 362.112 Lease -T- Mobile 43,473 45,550 45,550 33,825 45,550 47,370 47,370 47,370 362.115 Lease - Nextel 43,533 47,900 47,900 33,716 47,900 47,090 47,090 47,090 362.116 Lease -AT&T 0 45,000 45,000 20,000 45,000 30,000 30,000 30,000 Rents & Royalties 116,523 168,850 168,850 116,816 176,515 155,770 155,770 155,770 mom 366 Coninbutiolos�Donations 100 0 0 1,560 1,560 M Donation - Founfei�dHonOr 0 0 Contributions & Donations 100 0 0 1,560 1,560 Acct Class: 369 Miscellaneous Revenues 6,000 10,000 10,000 0 0 5,000 5,000 5,000 364.100 Disposition of Fixed Assets 2,500 2,500 369.000 Other Miscellaneous Revenue 2,060 2,500 2,500 5,860 5,858 2,500 7,007 0 0 32,090 32,006 369.100 Insurance Reimbursment 7,500 Miscellaneous Revenues 15,067 12,500 12,500 37,950 37,864 7,500 7,500 7,871,933 7,362,120 7,362,120 6,456,110 7,352,691 General 6,966,120 6,996,120 6,643,010 6,456,110 7,352,691 6,643,010 6,966,120 6,996,120 General Revenues 7,871,933 7,362,120 7,362,120 Function: 410 General Government Dept: 120 Village Clerk Acct Class: 369 Miscellaneous Revenues 0 0 0 0 0 369.000 Other Miscellaneous Revenue 0 0 0 0 0 0 0 Miscellaneous Revenues 0 0 0 0 0 0 0 0 Village Clerk 0 0 General Government 0 0 0 0 0 0 0 Function: 420 Public Safety Dept: 171 Police -Admin Acct Class: 316 Other Taxes 0 0 0 65,000 65,000 65,000 65,000 312.520 Casualty Insurance Premium Tax 65,148 Other Taxes 65,148 0 0 0 65,000 65,000 65,000 65,000 Acct Class: 320 Licenses & Permits 9,460 5,400 5,400 2,560 2,520 5,000 5,400 5,400 329.101 Alarm Permits 338 0 0 75 75 329.102 Special Truck Permits BUDGET WORKSHEET DRAFT DRAFT DRAFT Page:3 6/30/2010 Village of Tequesta 5:30 pm Prior Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 - General Fund Revenues Function: 420 Public Safety Dept: 171 Police-Admin Acct Class: 320 Licenses & Permits 329.105 Golf Cart Permits 1,550 2,000 2,000 575 575 2,000 2,000 Licenses & Permits 11,348 7,400 7,400 3,210 3,170 5,000 7,400 7,400 Acct Class: 334 Grants - State 334.201 State Police Block Grant 1,080 0 0 0 0 Grants - State 1,080 0 0 0 0 0 0 0 Acct Class: 335 Intergovemmental Revenue 338.201 PBC 911 Maint Reimbursement 0 5,000 5,000 0 6,400 5,000 5,000 338.202 PBC 911 DISPATCH REIMBURSEMENT 17,719 16,750 16,750 0 16,750 17,000 17,000 Intergovernmental Revenue 17,719 21,750 21,750 0 23,150 0 22,000 22,000 Acct Class: 342 Chgs for Sery - Public Safety 342.101 Vehicle Reinspection Fees 9 10 10 0 0 342.102 Police-Extra Duty 2,326 0 0 0 0 342.110 PBC - Marine law enforce. sery 3,960 5,000 5,000 6,629 6,629 4,000 5,000 5,000 342.171 Sery Chrg Excess Alarm Respons 50 0 0 0 0 50 50 Chgs for Sery - Public Safety 6,345 5,010 5,010 6,629 6,629 4,000 5,050 5,050 Acct Class: 351 Fines & Forfeitures 351.100 Court Fines 14,045 10,000 10,000 6,627 5,703 10,000 10,000 10,000 351.250 $12.50 traffic violation fund 0 0 0 0 0 1,500 1,500 354.101 Parking Tickets 2,070 2,400 2,400 1,445 1,345 2,000 2,400 2,400 354.102 Code Enf Fines & Court Costs 18,762 10,000 10,000 3,629 2,954 10,000 10,000 10,000 Fines & Forfeitures 34,877 22,400 22,400 11,701 10,002 22,000 23,900 23,900 Acct Class: 363 Impact Fees 362.221 Police Impact Fees 126 0 0 546 483 Impact Fees 126 0 0 546 483 0 0 0 Acct Class: 366 Contributions & Donations 366.100 Contrib & Donations & Sponsors 305 500 500 300 300 500 500 Contributions & Donations 305 500 500 300 300 0 500 500 Police-Admin 136,948 57,060 57,060 22,386 108,734 96,000 123,850 123,850 Dept: 180 Building & Zoning Acct Class: 320 Licenses & Permits 322.000 Building Permit Fees 178,374 220,000 220,000 146,640 175,000 215,000 215,000 329.000 Contractor's Registration 21,646 20,000 20,000 13,248 20,000 20,000 20,000 341.102 Sale of Maps and Publications 3 0 0 14 30 Licenses & Permits 200,023 240,000 240,000 159,902 195,030 0 235,000 235,000 Acct Class: 340 Charges for Services 342.501 Site Plan Review Fees 9,580 14,000 14,000 4,850 8,700 9,000 9,000 343.700 Water Conservation & Resource 188 0 0 236 400 400 400 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page:4 6/30/2010 Village of Tequesta 5:30 pm Prior -- - - - - -- - -- Current Year - (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 -General Fund Revenues Function: 420 Public Safety Dept: 180 Building & Zoning Charges for Services 9,768 14,000 14,000 5,086 9,100 0 9,400 9,400 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 2,427 0 0 90 200 200 200 Miscellaneous Revenues 2,427 0 0 90 200 0 200 200 Building & Zoning 212,218 254,000 254,000 165,078 204,330 0 244,600 244,600 Dept: 192 Fire Control Acct Class: 316 Other Taxes 312.510 Fire Insurance Prem Tax 136,853 0 0 0 137,000 137,000 137,000 137,000 Other Taxes 136,853 0 0 0 137,000 137,000 137,000 137,000 Acct Class: 334 Grants - State 337.201 PBC EMS Grant 25,314 0 0 0 0 Grants - State 25,314 0 0 0 0 0 0 0 Aoct Class: 335 Intergovernmental Revenue 335.201 Fire Incentive Pay 4,040 5,000 5,000 2,680 5,000 5,000 6,240 6,240 Intergovernmental Revenue 4,040 5,000 5,000 2,680 5,000 5,000 6,240 6,240 Acct Class: 342 Chgs for Sery - Public Safety 342.192 Fire - Extra Duty 220 0 0 3,410 3,410 2,500 2,500 342.201 Fire Plan Review Fees 10,148 7,000 7,000 19,851 20,000 18,000 18,000 342.202 Fire Inspections 26,411 27,000 27,000 18,036 26,500 26,500 26,500 26,500 342.401 Emergency Service-JIC 205,330 204,200 204,200 154,367 204,200 204,200 210,300 210,300 342.402 Fire Rescue -CPR Program 0 0 0 0 0 700 700 342.410 Emergency Svc- PBC Fire Rescue 0 168,000 168,000 126,000 168,000 168,000 168,000 168,000 342.600 EMS Transportation Fees 276,865 300,000 300,000 166,269 250,000 293,150 300,000 Chgs for Sery - Public Safety 518,974 706,200 706,200 487,933 672,110 398,700 719,150 726,000 Acct Class: 363 Impact Fees 362.222 Fire Impact Fees 173 0 0 510 500 500 500 Impact Fees 173 0 0 510 500 0 500 500 Acct Class: 366 Contributions & Donations 366.100 Contrib & Donations & Sponsors 1,575 1,500 1,500 810 1,200 1,200 1,200 Contributions & Donations 1,575 1,500 1,500 810 1,200 0 1,200 1,200 Acct Class: 369 Miscellaneous Revenues 365.102 Fire Dept Sales 12 0 0 41 100 100 100 365.350 Fire Mark Revenue 0 0 0 0 0 366.115 Tequesta's Golden Walk 0 0 0 0 0 369.000 Other Miscellaneous Revenue 13,417 0 0 30 30 Miscellaneous Revenues 13,429 0 0 71 130 0 100 100 Fire Control 700,358 712,700 712,700 492,004 815,940 540,700 864,190 871,040 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 5 6/30/2010 Village of Tequesta 5:30 pm Prior - Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 - General Fund Revenues Public Safety 1,049,524 1,023,760 1,023,760 679,468 1,129,004 636,700 1,232,640 1,239,490 Function: 450 Leisure Services Dept: 231 Leisure Services Acct Class: 347 Charges for Services - Recr. 347.100 Harvest Fest 6,525 7,000 7,000 13,636 13,636 13,000 18,000 18,000 347.190 Special Events -Other 6,011 5,000 5,000 9,060 9,034 7,500 7,500 7,500 347.201 Spring /Summer Camp Fees 35,964 36,000 36,000 45,320 45,125 39,000 39,000 39,000 347.205 Recreation Programs Fees 10,389 11,000 11,000 7,432 11,000 11,000 11,000 11,000 Charges for Services - Recr. 58,889 59,000 59,000 75,448 78,795 70,500 75,500 75,500 Acct Class: 362 Rents & Royalties 362.100 Rental -Facilities 4,072 3,000 3,000 3,195 3,195 3,500 3,000 3,000 Rents & Royalties 4,072 3,000 3,000 3,195 3,195 3,500 3,000 3,000 Acct Class: 363 Impact Fees 363.271 Parks and Rec Impact Fees 551 0 0 827 550 Impact Fees 551 0 0 827 550 0 0 0 Acct Class: 366 Contributions & Donations 366.100 Contrib & Donations & Sponsors 8,500 8,000 8,000 1,550 4,000 8,000 8,000 Contributions & Donations 8,500 8,000 8,000 1,550 4,000 0 8,000 8,000 Acct Class: 369 Miscellaneous Revenues 365.110 Concession Sales 9,525 9,000 9,000 7,781 9,000 9,000 9,000 9,000 369.000 Other Miscellaneous Revenue 40 5,000 5,000 30 100 100 100 100 Miscellaneous Revenues 9,565 14,000 14,000 7,811 9,100 9,100 9,100 9,100 Leisure Services 81,577 84,000 84,000 88,831 95,640 83,100 95,600 95,600 Leisure Services 81,577 84,000 84,000 88,831 95,640 83,100 95,600 95,600 Function: 581 Other Financing Sources and Us Dept: 900 Interfund Transfers Acct Class: 391 Transfers In 381.101 Transferfrom IBR 369,490 0 0 0 0 381.301 Transfer -In from Cap Improvemn 0 0 0 0 0 250,000 250,000 Transfers In 369,490 0 0 0 0 0 250,000 250,000 Interfund Transfers 369,490 0 0 0 0 0 250,000 250,000 Other Financing Sources and Us 369,490 0 0 0 0 0 250,000 250,000 Function: 590 Other Nonoperating Dept: 950 Other Nonoperating Acct Class: 367 Investment income 367.100 Unrealized gain /loss on invest 0 0 0 34,525 0 Investment income 0 0 0 34,525 0 0 0 0 Other Nonoperating 0 0 0 34,525 0 0 0 0 Dept: 990 Other /Reserve /Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 644,934 1,249,008 0 0 250,000 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 6 6/ Village of Tequesta 50 30m P Prior - -- - - - -- Current Year - - - - -- (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 - General Fund Revenues Function: 590 Other Nonoperating Dept: 990 Other /Reserve /Contingency Other Financing Sources 0 644,934 1,249,008 0 0 0 0 250,000 Other /Reserve /Contingency 0 644,934 1,249,008 0 0 0 0 250,000 Other Nonoperating 0 644,934 1,249,008 34,525 0 0 0 250,000 Total Revenues 9,372,524 9,114,814 9,718,888 7,258,934 8,577,335 7,362,810 8,544,360 8,831,210 Expenditures Function: 410 General Government Dept: 100 Council Acct Class: 530 Operating Expenditures /Expense 531.311 Council Fees -Arena 3,000 3,000 3,000 2,500 3,000 3,000 3,000 3,000 531.312 Council Fees - Tumquist 3,000 3,000 3,000 2,500 3,000 3,000 3,000 3,000 531.313 Council fees - T. Patemo 3,000 3,000 3,000 2,500 3,000 3,000 3,000 3,000 531.315 Council Fees - Humpage 3,000 3,000 3,000 2,500 3,000 3,000 3,000 3,000 531.317 Council Fees - Watkins 3,000 3,000 3,000 2,500 3,000 3,000 3,000 3,000 540.301 Council Discretionary - Arena 1,177 1,500 1,500 887 1,500 1,500 1,500 1,500 540.302 Council DiscretionarTumquist 1,500 1,500 1,500 1,368 1,500 1,500 1,500 1,500 540.305 Council Discrectionary Humpage 1,421 1,500 1,500 130 1,500 1,500 1,500 1,500 540.307 Council Discretionary Watkins 360 1,500 1,500 1,233 1,500 1,500 1,500 1,500 540.308 Council Discretionary Patemo 0 1,500 1,500 50 50 1,500 1,500 1,500 549.300 Other Misc Chgs & Obligations 1,259 1,500 1,500 1,142 1,500 1,000 500 500 549.350 Volunteer Appreciation 1,630 2,500 2,500 -3 1,800 1,800 1,800 1,800 552.302 Small Tools and Equipment 110 750 750 0 250 500 750 750 554.300 Books, Publ, Subs & Membership 3,191 3,600 3,600 3,142 3,600 3,600 3,600 582.800 Aid to Community Organizations 8,500 9,000 9,000 1,400 7,200 Operating Expenditures /Expense 34,148 39,850 39,850 21,849 35,400 29,400 150 Council 34,148 39,850 39,850 21,849 35,400 29,400 29,150 29,150 Dept: 110 Manager Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 115,525 122,050 122,050 86,415 120,400 120,600 120,600 120,600 515.103 Bonus Pay Plan 10,878 0 0 0 0 515.104 Sick Leave Conversion Pay 0 0 0 0 0 515.108 Auto Allowance 3,000 3,000 3,000 2,250 3,000 3,000 3,000 3,000 516.100 Compensated Absences 0 0 0 0 0 521.101 FICA Taxes 5,668 7,800 7,800 4,480 5,791 5,780 5,780 5,780 521.102 Medicare Taxes 1,861 1,850 1,850 1,326 1,841 1,800 1,800 1,800 522.102 VOT Pension Contributions 9,215 10,850 10,850 6,893 9,610 11,300 11,300 11,300 523.101 Life /Health Insurance 22,953 22,350 22,350 18,588 22,310 22,400 22,400 22,400 I BUDGET WORKSHEET DRAFT DRAFT DRAFT Page:7 6/30/2010 Village of Tequesta 5:30 pm Prior - - Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMEN MANA Fund: 001 - General Fund Expenditures Function: 410 General Government Dept: 110 Manager Acct Class: 510 Personal Services 524.100 Workers' Comp Insurance 528 590 590 356 356 360 360 526.104 ICMA -Def Comp Plan 8,803 9,300 9,300 6,509 9,080 9,100 9,100 9,100 554.301 Personnel Training 0 0 0 0 0 Personal Services 178,431 177,790 177,790 126,817 172,388 173,980 174,340 174,340 Acct Class: 530 Operating Expenditures /Expense 540.300 Travel & Per Diem 0 500 500 0 0 546.320 Computer system maint & suppli 396 750 750 0 500 500 500 500 547.300 Printing & Binding 0 0 0 0 0 549.300 Other Misc Chgs & Obligations 20 0 0 0 0 554.300 Books, Pub[, Subs & Membership 1,379 2,000 2,000 1,996 2,000 2,000 2,000 2,000 Operating Expenditures /Expense 1,795 3,250 3,250 1,996 2,500 2,500 2,500 2,500 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 Manager 180,226 181,040 181,040 128,813 174,888 176,480 176,840 176,840 Dept: 111 Human Resources Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 130,671 110,450 97,156 74,576 95,735 110,500 110,500 75,100 514.100 Overtime 0 0 0 0 0 515.103 Bonus Pay Plan 0 0 0 0 0 515.104 Sick Leave Conversion Pay 0 0 0 0 0 515.107 Part-time Salaries 0 0 12,130 4,274 12,265 28,400 516.100 Compensated Absences 6,945 0 1,164 1,164 1,164 521.101 FICA Taxes 8,377 6,850 6,850 4,872 6,670 6,900 6,900 6,500 521.102 Medicare Taxes 1,959 1,600 1,600 1,139 1,560 1,600 1,500 1,500 522.101 FRS Contributions 3,444 0 0 0 0 522.102 VOT Pension Contributions 8,484 9,950 9,950 6,011 7,720 10,400 10,400 7,100 523.101 Life /Health Insurance 21,208 17,550 17,550 12,751 13,825 17,600 17,600 6,500 524.100 Workers' Comp Insurance 294 330 330 327 327 330 330 526.101 Employee Recognition Program 5,580 5,500 5,500 3,176 5,500 5,500 5,500 526.102 Employee Assistance Program 3,485 3,800 3,800 2,554 3,800 4,000 4,000 526.103 Education Reimbursement Prgm 0 3,000 2,000 0 0 2,000 526.105 Employee Physical /Psycological 0 500 500 0 500 554.301 Personnel Training 1,374 2,000 3,025 1,590 3,025 3,000 3,000 554.310 Employee Development 168 2,000 2,000 0 2,000 2,000 2,000 Personal Services 191,989 163,530 163,555 112,434 154,091 147,000 163,730 139,930 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 8 6/30/2010 Village of Tequesta 5:30 pm Prior - -- - - Current Year - -- (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 -General Fund Expenditures Function: 410 General Government Dept: 111 Human Resources Acct Class: 530 Operating Expenditures /Expense 534.300 Other Contractual Services 0 0 0 0 0 540.300 Travel & Per Diem 1,465 1,600 1,700 1,672 1,700 1,500 1,500 546.320 Computer system maint & suppli 819 500 500 64 500 800 800 547.300 Printing & Binding 1,000 500 500 182 500 1,000 1,000 549.300 Other Misc Chgs & Obligations 0 700 575 0 575 700 700 549.401 Recruitment expenses 0 500 500 215 500 500 500 552.302 Small Tools and Equipment 63 500 500 50 500 500 500 554.300 Books, Publ, Subs & Membership 1,252 500 500 302 500 500 500 Operating Expenditures /Expense 4,599 4,800 4,775 2,485 4,775 0 5,500 5,500 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 Human Resources 196,588 168,330 168,330 114,919 158,866 147,000 169,230 145,430 Dept: 120 Village Clerk Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 98,276 103,350 103,350 74,036 103,176 103,400 103,400 103,400 515.103 Bonus Pay Plan 0 0 0 0 0 521.101 FICA Taxes 5,912 6,450 6,450 4,463 6,215 6,500 6,500 6,500 521.102 Medicare Taxes 1,383 1,500 1,500 1,044 1,460 1,500 1,500 1,500 522.102 VOT Pension Contributions 7,921 9,300 9,300 5,967 8,320 9,800 9,800 9,800 523.101 Life /Health Insurance 21,710 21,150 21,150 17,612 21,135 21,200 21,200 21,200 524.100 Workers' Comp Insurance 269 310 310 304 304 310 310 526.103 Education Reimbursement Prgm 0 0 0 0 0 2,000 2,000 554.301 Personnel Training 1,928 1,600 1,600 720 1,200 1,300 1,300 Personal Services 137,399 143,660 143,660 104,146 141,810 142,400 146,010 146,010 Acct Class: 530 Operating Expenditures /Expense 531.303 Codification Services 5,045 6,600 6,600 2,912 4,000 5,000 5,000 531.304 Recording Secy Service 7,167 7,350 7,350 5,280 7,350 7,350 7,350 534.301 Election Expense 657 15,000 14,750 10,797 13,000 13,000 13,000 534.302 Legal Advertising 7,956 10,100 10,100 3,465 8,000 8,250 8,250 540.300 Travel & Per Diem 4,310 3,450 3,450 2,070 3,000 3,300 3,300 541.300 Communication Services 620 800 800 489 800 800 800 546.320 Computer system maint & suppli 1,179 3,400 3,650 3,720 3,850 3,300 1,400 549.100 Miscellaneous Archival 2,926 2,500 2,500 290 2,500 2,500 2,500 549.201 Advertising & Promotion 211 1,000 1,000 0 500 1,000 1,000 549.300 Other Misc Chgs & Obligations 1,205 2,000 2,000 564 1,500 2,550 2,550 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page:9 6/30/2010 Village of Tequesta 5:30 pm Prior - - -- Current Year -- (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPART MANAGER Fund: 001 - General Fund Expenditures Function: 410 General Government Dept: 120 Village Clerk Acct Class: 530 Operating Expenditures /Expense 552.302 Small Tools and Equipment 159 500 500 0 100 500 500 552.306 Microfilm Service /Supplies 8 30 30 8 10 30 30 554.300 Books, Publ, Subs & Membership 310 960 960 849 900 1,010 1,010 Operating Expenditures /Expense 31,753 53,690 53,690 30,444 45,510 0 48,590 46,690 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 2,500 Capital Outlay 0 0 0 0 0 0 2,500 0 Village Clerk 169,152 197,350 197,350 134,590 187,320 142,400 197,100 192,700 Dept: 130 Finance Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 250,058 263,000 263,000 188,394 262,560 263,000 263,000 209,300 514.100 Overtime 0 0 0 0 0 515.103 Bonus Pay Plan 0 0 0 0 0 515.107 Part -time Salaries 0 0 0 0 0 43,100 516.100 Compensated Absences 0 0 0 0 0 521.101 FICA Taxes 14,809 16,350 16,350 11,183 15,570 16,300 16,300 15,700 521.102 Medicare Taxes 3,463 3,850 3,850 2,615 3,650 3,900 3,900 3,700 522.102 VOT Pension Contributions 20,154 23,600 21,600 15,185 21,170 24,800 24,800 19,700 523.101 Life /Health Insurance 56,494 55,000 55,000 45,797 54,960 55,000 55,000 48,700 524.100 Workers' Comp Insurance 822 890 890 775 775 780 780 525.100 Unemployment Compensation 2,212 0 0 0 0 526.103 Education Reimbursement Prgm 799 1,600 1,600 596 596 554.301 Personnel Training 2,838 5,500 5,500 3,475 3,475 4,600 4,600 4,600 Personal Services 351,649 369,790 367,790 268,020 362,756 367,600 368,380 345,580 Acct Class: 530 Operating Expenditures /Expense 532.300 Accounting & Auditing Services 30,315 25,590 29,895 29,890 29,895 26,600 26,600 26,600 540.300 Travel & Per Diem 836 2,000 2,000 1,241 1,600 1,300 1,300 1,300 546.301 Office Equip /Repair & Maint 375 800 800 385 390 800 800 800 546.320 Computer system maint & suppli 10,776 7,900 9,900 5,717 9,160 11,200 11,200 6,000 549.300 Other Misc Chgs & Obligations 80 500 500 135 200 500 500 500 551.300 Office Supplies 2,399 4,000 4,000 2,547 4,000 4,000 4,000 4,000 551.310 Printing & Binding 3,257 4,500 4,500 3,028 4,500 4,500 4,500 4,500 552.302 Small Tools and Equipment 480 0 0 0 0 500 500 500 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 10 6/30/2010 Village of Tequesta 5:30 pm Prior - -- Current Year -- (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 - General Fund Expenditures Function: 410 General Government Dept: 130 Finance Acct Class: 530 Operating Expenditures /Expense 554.300 Books, Publ, Subs & Membership 1,183 1,200 1,200 940 1,200 1,500 1,500 1,500 Operating Expenditures /Expense 49,701 46,490 52,795 43,883 50,945 50,900 50,900 45,700 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.601 Computer Equipment 0 0 0 0 0 Capital Outlay 0 0 0 0 0 0 0 0 Finance 401,350 416,280 420,585 311,903 413,701 418,500 419,280 391,280 Dept: 140 Legal Acct Class: 530 Operating Expenditures /Expense 531.301 Legal Services 89,937 85,000 85,000 37,625 60,000 75,000 75,000 531.308 Legal fees - Personnel 26,447 25,000 25,000 16,732 25,000 20,000 20,000 531.310 Legal -Special 0 0 0 0 0 549.300 Other Misc Chgs & Obligations 0 0 0 87 100 Operating Expenditures /Expense 116,384 110,000 110,000 54,444 85,100 0 95,000 95,000 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Legal 116,384 110,000 110,000 54,444 85,100 0 95,000 95,000 Dept: 160 General Government Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 78,175 82,100 82,100 58,811 81,960 82,100 82,100 82,100 515.104 Sick Leave Conversion Pay 3,966 4,000 1,210 0 0 3,000 3,000 516.100 Compensated Absences 2,789 0 2,790 0 0 521.101 FICA Taxes 4,908 5,350 5,350 3,649 5,090 5,300 5,300 5,300 521.102 Medicare Taxes 1,295 1,250 1,250 853 1,190 1,300 1,300 1,300 522.102 VOT Pension Contributions 6,301 7,400 7,400 4,740 6,610 7,800 7,800 7,800 523.101 Life /Health Insurance 6,615 6,500 6,500 5,395 6,480 6,500 6,500 6,500 524.100 Workers' Comp Insurance 224 250 250 241 241 250 250 Personal Services 104,273 106,850 106,850 73,689 101,571 103,000 106,250 106,250 Acct Class: 530 Operating Expenditures /Expense 531.305 Computer Programming Services 0 0 0 0 0 534.300 Other Contractual Services 19,711 20,000 19,790 14,991 19,790 20,000 20,000 20,000 534.303 Special Events 2,914 20,520 10,417 3,766 3,766 14,500 14,500 541.300 Communication Services 14,157 14,710 19,100 13,754 18,650 26,600 26,600 10,800 541.301 Postage 5,600 3,600 3,600 2,599 3,600 3,850 3,850 3,850 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 11 6/30/2010 Village of Tequesta 5:30 pm Prior ----- - - - - -- Current Year - (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 613012010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 - General Fund Expenditures Function: 410 General Government Dept: 160 General Government Acct Class: 530 Operating Expenditures /Expense 541.302 Electronic Communications 0 0 0 0 0 541.305 Website Maintenance 5,159 5,650 7,150 5,811 7,150 7,500 7,500 7,500 543.300 Utility Services 16,515 18,760 18,760 11,034 17,500 20,400 20,400 20,400 544.301 Equipment Leases 5,619 5,780 6,051 4,668 6,030 6,080 6,080 6,080 545.300 Insurance 49,217 49,170 49,170 47,563 49,170 49,170 49,170 546.301 Office Equip /Repair & Maint 2,835 3,210 3,210 2,143 2,580 2,660 2,660 2,660 546.302 Vehicle Repair & Maintenance 642 400 1,310 1,309 1,309 1,000 1,000 1,000 546.303 Building Repair & Maint 4,434 2,000 6,052 7,368 8,000 5,000 4,000 4,000 546.310 Equipment Repair & Maint 9,101 8,000 3,948 459 2,000 2,000 2,000 2,000 546.320 Computer system maint & suppli 13,961 22,000 16,560 10,089 12,000 29,000 12,500 547.300 Printing & Binding 3,726 1,500 1,500 354 500 1,000 1,000 1,000 549.300 Other Misc Chgs & Obligations 4,883 14,000 11,514 8,510 10,000 8,000 8,000 8,000 549.302 Village Newsletter 5,223 5,500 5,500 8,793 9,600 19,200 19,200 549.304 Licenses, Fees & Permits 2,106 1,750 1,750 1,152 1,200 1,200 1,200 1,200 549.366 Donations - Memorials 0 0 0 1,440 1,560 549.390 Penalties, Late Fees & Charges 0 0 0 0 0 551.300 Office Supplies 3,510 2,500 2,500 2,048 2,500 2,500 2,500 2,500 552.301 Gas & Oil 94 1,000 1,000 230 400 400 400 400 554.300 Books, Publ, Subs & Membership 1,637 1,600 3,015 2,845 3,015 3,700 3,700 3,700 Operating Expenditures /Expense 171,044 201,650 191,897 150,926 180,320 111,890 222,760 190,460 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.600 MachlEquipment 0 0 2,090 2,090 2,090 664.601 Computer Equipment 35,184 15,000 15,000 6,466 7,400 Capital Outlay 35,184 15,000 17,090 8,556 9,490 0 0 0 General Government 310,501 323,500 315,837 233,171 291,381 214,890 329,010 296,710 General Government 1,408,349 1,436,350 1,432,992 999,689 1,346,656 1,128,670 1,415,610 1,327,110 Function: 420 Public Safety Dept: 171 Police-Admin Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 148,239 149,550 96,350 90,643 100,172 149,600 149,520 149,520 514.100 Overtime 0 0 0 0 0 515.103 Bonus Pay Plan 0 0 0 0 0 515.106 Clothing & Boot Allowance 0 450 450 0 0 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 12 6/30/2010 Village of Tequesta 5:30 pm Prior Current Year - (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 613012010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 - General Fund Expenditures Function: 420 Public Safety Dept: 171 Police-Admin Acct Class: 510 Personal Services 515.108 Auto Allowance 0 0 0 0 0 516.100 Compensated Absences 0 0 0 0 0 521.101 FICA Taxes 8,921 9,300 5,960 4,739 5,270 9,300 9,280 9,280 521.102 Medicare Taxes 2,139 2,200 1,420 1,301 1,430 2,200 2,170 2,170 522.102 VOT Pension Contributions 4,442 3,050 3,050 1,952 2,720 3,200 3,180 3,180 522.110 Other Pension Contributions 65,148 0 0 0 65,000 65,000 65,000 65,000 523.101 Life /Health Insurance 27,741 26,150 30,650 24,817 29,781 29,800 31,470 29,800 524.100 Workers' Comp Insurance 2,821 3,280 3,280 3,277 3,277 3,280 3,280 525.100 Unemployment Compensation 0 0 0 0 0 526.101 Employee Recognition Program 514 1,500 1,500 469 1,500 750 750 526.103 Education Reimbursement Prgm 0 1,500 1,500 0 1,500 1,500 1,500 526.104 ICMA -Def Comp Plan 4,999 5,800 3,150 3,322 3,322 5,800 5,790 5,790 526.105 Employee Physical /Psycological 1,637 2,800 5,500 3,809 5,500 4,290 4,290 554.301 Personnel Training 275 900 900 620 900 350 350 Personal Services 266,876 206,480 153,710 134,949 220,372 264,900 276,580 274,910 Acct Class: 530 Operating Expenditures /Expense 540.300 Travel & Per Diem 659 1,300 1,300 1,283 1,300 100 100 541.300 Communication Services 35,643 36,540 36,540 24,846 31,500 28,380 27,300 541.301 Postage 3,111 3,800 3,800 1,533 3,800 2,800 2,800 543.300 Utility Services 33,582 38,500 38,500 19,273 38,500 32,900 32,900 544.301 Equipment Leases 2,874 3,460 3,460 2,284 3,460 3,460 3,460 545.300 Insurance 35,064 39,050 41,114 40,349 41,114 40,800 40,800 546.301 Office Equip /Repair & Maint 509 1,000 1,000 0 500 500 500 546.303 Building Repair & Maint 10,401 10,000 19,267 10,971 16,000 12,750 12,750 546.310 Equipment Repair & Maint 1,511 1,840 1,840 707 1,840 1,090 1,090 546.320 Computer system maint & suppli 0 0 2,000 2,000 2,000 22,200 28,500 547.300 Printing & Binding 3,283 3,500 3,500 1,936 3,500 2,000 2,000 549.300 Other Misc Chgs & Obligations 993 2,000 2,000 1,335 2,000 750 750 549.304 Licenses, Fees & Permits 1,101 1,150 1,150 1,231 1,150 500 500 551.300 Office Supplies 8,147 8,800 8,800 2,609 7,300 5,000 5,000 551.301 Crime Prevention Supplies 5,089 4,500 4,500 2,730 4,500 3,500 3,500 552.302 Small Tools and Equipment 772 500 500 96 500 450 450 552.305 Uniforms 548 960 960 0 300 710 710 554.300 Books, Pub[, Subs & Membership 1,595 1,600 1,600 1,369 1,600 830 830 Operating Expenditures /Expense 144,882 158,500 171,831 114,552 160,864 0 158,720 163,940 Acct Class: 590 Other Financing Sources & Uses BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 13 6/30/2010 Village of Tequesta 5:30 pm Prior -- Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30 /2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 - General Fund Expenditures Function: 420 Public Safety Dept: 171 Police-Admin Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 127,406 0 0 Other Financing Sources & Uses 0 0 127,406 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.600 Mach /Equipment 995 0 3,123 3,122 3,122 664.601 Computer Equipment 0 0 0 0 0 664.602 Vehicles 0 0 24,000 0 24,000 Capital Outlay 995 0 27,123 3,122 27,122 0 0 0 Police-Admin 412,753 364,980 480,070 252,623 408,358 264,900 435,300 438,850 Dept: 172 Police- Communication Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 192,303 232,600 213,360 147,037 210,950 226,700 226,700 226,700 514.100 Overtime 13,499 15,860 19,360 12,944 15,600 15,000 16,440 16,440 515.101 Holiday Pay 4,302 11,220 11,220 6,694 8,500 9,000 8,440 8,440 515.103 Bonus Pay Plan 4,500 5,000 5,000 4,577 4,577 5,000 5,000 5,000 515.104 Sick Leave Conversion Pay 0 0 1,140 1,139 1,140 515.106 Clothing & Boot Allowance 1,945 2,130 2,130 1,801 1,801 2,130 2,130 2,130 515.107 Part -time Salaries 29,677 17,940 19,440 15,735 18,600 15,000 15,720 15,720 516.100 Compensated Absences 0 0 0 0 0 521.101 FICA Taxes 15,075 17,700 17,700 11,643 16,800 17,000 18,150 17,100 521.102 Medicare Taxes 3,526 4,150 4,150 2,723 3,950 4,000 4,250 4,000 522.101 FRS Contributions 6,055 6,700 6,700 4,926 6,700 8,500 8,120 7,100 522.102 VOT Pension Contributions 10,863 15,550 15,550 8,417 12,220 15,800 16,490 15,800 523.101 Life /Health Insurance 33,317 47,200 47,200 28,995 35,440 38,700 41,510 38,700 524.100 Workers' Comp Insurance 730 720 720 711 711 720 720 525.100 Unemployment Compensation 0 0 0 0 0 554.301 Personnel Training 209 1,750 1,750 1,207 1,750 1,000 1,000 Personal Services 316,001 378,520 365,420 248,549 338,739 356,830 364,670 358,850 Acct Class: 530 Operating Expenditures/Expense 540.300 Travel & Per Diem 182 1,000 1,000 437 1,000 650 650 546.301 Office Equip /Repair & Maint 0 500 500 0 500 100 100 546.304 Communication Equip Maint 7,750 12,020 12,020 5,790 12,020 14,520 14,520 546.320 Computer system maint & suppli 9,814 11,500 11,500 18,230 18,500 549.300 Other Misc Chgs & Obligations 3 0 0 0 0 552.302 Small Tools and Equipment 1,491 1,500 3,100 552 3,100 750 750 552.305 Uniforms 1,297 1,400 1,400 70 1,400 990 990 554.300 Books, Publ, Subs & Membership 74 100 100 0 100 100 100 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 14 6/30/2010 Village of Tequesta 5:30 pm Prior ----- - - - - -- Current Year-- - - - - -- (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6130 /2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 - General Fund Expenditures Function: 420 Public Safety Dept: 172 Police- Communication Operating Expenditures /Expense 20,611 28,020 29,620 25,079 36,620 0 17,110 17,110 Acct Class: 600 Capital Outlay 664.600 Mach /Equipment 2,729 0 0 0 0 Capital Outlay 2,729 0 0 0 0 0 0 0 Police- Communication 339,341 406,540 395,040 273,628 375,359 356,830 381,780 375,960 Dept: 175 Police- Operations Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 1,048,067 1,087,420 1,118,920 803,111 1,118,452 1,122,600 1,113,440 1,053,100 514.100 Overtime 94,794 89,730 115,820 108,279 145,820 86,000 68,430 68,430 514.300 Overtime - Training 0 0 0 0 0 515.101 Holiday Pay 34,181 40,000 40,000 33,348 40,000 49,300 46,320 46,320 515.103 Bonus Pay Plan 5,492 4,750 6,976 8,241 8,241 6,250 6,250 6,250 515.104 Sick Leave Conversion Pay 1,843 3,600 1,900 1,892 1,892 2,000 3,600 3,600 515.105 Extra Duty Pay - Contract Svcs 1,925 0 0 0 0 515.106 Clothing & Boot Allowance 9,804 9,500 9,500 9,175 9,175 9,600 9,950 9,600 515.107 Part -time Salaries 0 0 10,000 9,817 20,000 10,000 10,000 24,000 516.100 Compensated Absences 0 40,000 32 0 0 43,200 521.101 FICA Taxes 72,712 79,050 79,050 59,305 82,750 79,800 75,030 77,800 521.102 Medicare Taxes 17,006 18,500 18,500 13,870 19,600 18,700 17,550 18,200 522.101 FRS Contributions 90,180 91,700 91,700 70,218 98,000 134,600 128,020 89,000 522.102 VOT Pension Contributions 83,997 234,940 111,940 77,876 109,000 170,400 155,550 137,200 523.101 Life /Health Insurance 163,496 157,000 157,000 140,648 168,850 169,100 169,100 161,900 524.100 Workers' Comp Insurance 55,293 31,830 31,830 31,823 31,823 31,830 31,830 554.301 Personnel Training 5,513 10,000 3,400 2,306 3,400 4,300 4,300 Personal Services 1,684,303 1,898,020 1,796,568 1,369,909 1,857,003 1,858,350 1,839,370 1,774,730 Acct Class: 530 Operating Expenditures /Expense 531.301 Legal Services 23,715 18,000 27,600 20,628 27,600 18,000 18,000 531.320 Code Enforcement Service 1,646 5,000 5,000 1,410 5,000 4,000 4,000 531.331 Board of Adjustment 0 0 0 0 0 540.300 Travel & Per Diem 5,492 7,800 4,800 4,336 4,800 3,000 3,000 546.301 Office Equip /Repair & Maint 0 700 700 0 700 500 500 546.302 Vehicle Repair & Maintenance 32,907 32,000 32,000 21,483 32,000 32,000 32,000 546.310 Equipment Repair & Maint 5,593 9,400 9,400 4,661 9,400 4,400 4,400 546.320 Computer system maint & suppli 0 0 130 0 0 549.300 Other Misc Chgs & Obligations 1,527 1,750 1,750 1,740 1,750 1,250 1,250 549.303 Investigative Expenses 769 1,440 1,440 654 1,440 1,090 1,090 549.309 Tequesta SRT 0 0 0 0 0 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 15 6/3012010 Village of Tequesta 5:30 pm Prior -- Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 -General Fund Expenditures Function: 420 Public Safety Dept: 175 Police- Operations Acct Class: 530 Operating Expenditures /Expense 549.311 Marine Unit Operations 1,362 9,080 9,080 1,648 9,080 2,760 2,760 549.314 K.E.Y.S. Program 1,315 2,500 2,500 588 2,500 2,500 2,500 552.301 Gas & Oil 43,801 50,000 50,000 37,933 50,000 64,440 64,440 552.302 Small Tools and Equipment 29,910 9,130 15,430 11,282 15,430 7,410 7,410 552.305 Uniforms 8,564 9,330 12,830 12,577 12,830 9,460 9,460 552.307 Photo/Video Supplies 469 550 550 103 550 250 250 554.300 Books, Publ, Subs & Membership 638 950 950 944 950 730 730 Operating Expenditures/Expense 157,708 157,630 174,160 119,987 174,030 0 151,790 151,790 Acct Class: 600 Capital Outlay 664.600 Mach /Equipment 13,627 9,000 32,000 22,999 31,150 664.601 Computer Equipment 0 0 0 0 0 664.602 Vehicles 50,231 30,000 30,000 26,144 30,000 24,000 CapitalOutiay 63,858 39,000 62,000 49,143 61,150 0 24,000 0 Police- Operations 1,905,869 2,094,650 2,032,728 1,539,039 2,092,183 1,858,350 2,015,160 1,926,520 Dept: 180 Building & Zoning Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 168,844 107,150 34,289 31,786 34,289 9,000 8,900 514.100 Overtime 0 0 0 0 0 515.103 Bonus Pay Plan 0 0 0 0 0 515.104 Sick Leave Conversion Pay 0 0 0 0 0 515.107 Part-time Salaries 904 46,200 54,700 37,718 54,390 59,200 59,200 59,200 515.108 Auto Allowance 3,000 3,000 750 750 750 516.100 Compensated Absences 6,945 0 2,565 2,565 2,565 521.101 FICA Taxes 11,035 9,700 5,710 4,507 5,710 4,300 3,670 4,300 521.102 Medicare Taxes 2,581 2,300 1,340 1,054 1,340 1,000 860 1,000 522.101 FRS Contributions 3,509 0 265 170 265 500 400 522.102 VOT Pension Contributions 11,467 9,650 3,045 2,747 3,045 1,600 1,400 523.101 Life /Health Insurance 18,873 6,600 1,639 1,638 1,638 524.100 Workers' Comp Insurance 3,397 3,750 3,750 1,180 1,180 1,500 1,500 525.100 Unemployment Compensation 0 0 10,725 3,575 9,900 825 825 554.301 Personnel Training 380 0 0 0 0 500 500 Personal Services 230,935 188,350 118,778 87,690 115,072 75,600 66,555 78,025 Acct Class: 530 Operating Expenditures /Expense 531.301 Legal Services 27,996 20,000 20,000 16,431 24,650 22,000 22,000 531.306 Temporary Service 0 0 0 0 0 531.320 Code Enforcement Service 0 0 0 0 0 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 16 6/30/2010 Village of Tequesta 5:30 pm Prior - - - -- Current Year - (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 - General Fund Expenditures Function: 420 Public Safety Dept: 180 Building & Zoning Acct Class: 530 Operating Expenditures /Expense 531.321 Mapping Services 3,120 2,500 2,500 0 1,750 2,500 2,500 531.322 Misc Planning Service 18,940 4,000 4,000 400 800 2,500 2,500 531.323 Site Plan Review 1,540 2,000 2,000 0 0 531.325 Inspection Services 63,570 66,000 66,000 60,132 91,000 104,600 128,960 91,000 531.331 Board of Adjustment 102 500 500 0 500 500 500 531.332 Planning and Zoning Board 2,189 3,000 3,000 911 2,400 2,500 2,500 534.302 Legal Advertising 3,010 1,000 1,000 608 1,000 1,250 1,250 540.300 Travel & Per Diem 0 1,000 1,000 0 0 1,000 1,000 541.300 Communication Services 1,756 2,000 2,000 1,802 2,700 2,200 2,220 541.301 Postage 1,935 2,000 2,000 605 1,500 1,500 1,500 543.300 Utility Services 6,072 6,000 6,000 4,460 7,030 6,500 6,500 544.301 Equipment Leases 0 0 0 0 0 545.300 Insurance 0 0 0 0 0 546.301 Office Equip /Repair & Maint 2,673 2,500 2,500 1,849 3,000 2,500 2,500 546.302 Vehicle Repair & Maintenance 0 0 0 0 0 546.303 Building Repair & Maint 0 0 0 3,701 4,000 546.320 Computer system maint & suppli 3,057 2,500 2,500 2,414 2,800 4,700 3,370 547.300 Printing & Binding 626 1,000 1,000 231 600 800 800 549.300 Other Misc Chgs & Obligations 212 500 500 72 300 500 500 549.304 Licenses, Fees & Permits 1,056 1,200 1,200 231 750 1,200 1,200 551.300 Office Supplies 2,942 1,500 1,500 859 1,500 1,500 1,500 552.301 Gas & Oil 0 0 0 0 0 552.302 Small Tools and Equipment 0 0 0 0 0 552.305 Uniforms 0 0 0 0 0 554.300 Books, Pub], Subs & Membership 1,196 1,000 1,000 1,181 1,181 1,000 1,000 Operating Expenditures /Expense 141,992 120,200 120,200 95,887 147,461 104,600 183,610 144,340 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 69,572 0 0 Other Financing Sources & Uses 0 0 69,572 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.601 Computer Equipment 6,083 0 0 0 0 1,500 1,500 Capital Outlay 6,083 0 0 0 0 0 1,500 1,500 Building & Zoning 379,010 308,550 308,550 183,577 262,533 180,200 251,665 223,865 Dept: 191 Civil Preparation Acct Class: 510 Personal Services 554.301 Personnel Training 0 0 0 0 0 350 350 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 17 6/30/2010 Village of Tequesta 5:30 pm Prior -- Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6130 /2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 - General Fund Expenditures Function: 420 Public Safety Dept: 191 Civil Preparation Personal Services 0 0 0 0 0 0 350 350 Acct Class: 530 Operating Expenditures /Expense 540.300 Travel & Per Diem 0 500 500 78 0 960 960 541.300 Communication Services 3,757 3,500 3,500 2,597 3,520 3,820 3,350 546.320 Computer system maint & suppli 720 1,000 1,000 720 800 800 800 549.900 Disaster Relief & Initial Resp 1,211 5,000 5,000 0 0 2,500 2,500 552.308 Safety Supplies 967 2,000 2,000 754 1,800 3,350 3,350 552.309 Civil Defense Supplies 254 1,500 1,500 1,061 750 1,500 1,500 552.310 Disaster Relief Supplies -193 1,500 1,500 0 0 1,500 1,500 Operating Expenditures /Expense 6,716 15,000 15,000 5,210 6,870 0 14,430 13,960 Civil Preparation 6,716 15,000 15,000 5,210 6,870 0 14,780 14,310 Dept: 192 Fire Control Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 1,351,408 1,430,510 1,430,510 1,029,152 1,436,880 1,430,600 1,430,820 1,430,400 514.100 Overtime 46,185 29,500 105,873 75,488 105,873 18,400 18,350 18,350 514.300 Overtime - Training 11,969 18,000 18,000 7,931 12,000 17,700 17,650 17,650 515.101 Holiday Pay 43,137 44,000 44,000 38,181 46,320 45,850 46,350 46,350 515.103 Bonus Pay Plan 0 0 0 3,679 3,679 515.104 Sick Leave Conversion Pay 913 1,500 1,500 8,395 8,395 3,300 3,230 3,230 515.106 Clothing & Boot Allowance 600 600 600 600 600 600 600 600 515.107 Part-time Salaries 14,493 10,440 34,731 22,947 34,731 17,850 17,850 17,850 515.110 Intern Fire Fighter Pay 40,583 56,950 56,950 44,549 61,545 60,300 58,720 60,260 516.100 Compensated Absences 8,152 0 0 0 0 521.101 FICA Taxes 92,095 98,700 105,100 74,149 103,400 98,900 98,800 98,900 521.102 Medicare Taxes 21,556 23,100 24,600 17,532 24,500 23,200 23,110 23,200 522.101 FRS Contributions 6,550 7,050 7,050 5,019 6,870 8,800 7,610 7,300 522.102 VOT Pension Contributions 146,241 445,434 311,034 206,655 288,200 396,400 266,000 319,400 522.110 Other Pension Contributions 136,853 0 0 0 137,000 137,000 137,000 137,000 523.101 Life /Health Insurance 212,010 206,050 206,050 171,816 206,735 205,300 206,050 210,400 524.100 Workers' Comp Insurance 43,461 51,280 51,280 51,275 51,275 51,280 51,280 526.101 Employee Recognition Program 217 3,450 3,450 210 2,200 3,450 3,450 526.103 Education Reimbursement Prgm 10,961 20,400 20,400 7,816 20,400 20,400 20,400 526.105 Employee Physical/Psycological 9,085 9,000 9,000 9,007 9,007 9,870 9,870 554.301 Personnel Training 4,518 8,500 8,500 3,352 3,202 8,450 8,450 Personal Services 2,200,987 2,464,464 2,438,628 1,777,753 2,562,812 2,464,200 2,425,590 2,484,340 Acct Class: 530 Operating Expenditures /Expense 540.300 Travel & Per Diem 4,061 5,140 5,140 2,604 3,500 5,140 5,140 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 18 6/30/2010 Village of Tequesta 5:30 pm Prior - Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 -General Fund Expenditures Function: 420 Public Safety Dept: 192 Fire Control Acct Class: 530 Operating Expenditures /Expense 541.300 Communication Services 14,764 15,200 15,200 10,352 14,300 13,500 10,800 541.301 Postage 1,456 1,980 1,980 675 1,500 1,500 1,500 543.300 Utility Services 34,912 36,980 36,980 20,243 30,000 33,270 33,270 543.310 Utilities - Fire Station II 0 0 6,730 4,816 6,730 544.301 Equipment Leases 5,582 6,800 6,800 5,320 7,050 7,200 7,200 544.303 Office Lease 0 0 9,226 8,320 9,226 545.300 Insurance 20,960 22,260 22,260 21,978 22,260 22,260 22,260 546.302 Vehicle Repair & Maintenance 20,021 25,000 25,000 17,411 26,500 27,820 27,820 546.303 Building Repair & Maint 11,314 15,000 18,267 12,404 16,500 16,870 16,870 546.310 Equipment Repair & Maint 13,983 18,000 18,000 9,803 17,000 19,940 19,940 546.320 Computer system maint & suppli 3,455 6,550 8,800 6,654 7,200 10,500 12,400 547.300 Printing & Binding 757 970 970 149 750 970 970 549.300 Other Misc Chgs & Obligations 1,640 2,630 2,630 289 1,600 2,630 2,630 549.304 Licenses, Fees & Permits 15,870 15,990 15,990 11,990 15,000 17,350 17,350 549.311 Marine Unit Operations 1,370 2,380 2,380 1,662 1,519 2,020 2,020 551.300 Office Supplies 2,195 2,970 2,970 1,379 2,800 2,970 2,970 551.302 Fire Prevention Education 1,441 1,760 1,760 1,323 1,800 1,800 1,800 552.301 Gas & Oil 15,814 16,820 16,820 6,473 14,000 16,820 16,820 552.304 Chemicals 1,111 1,290 1,290 0 1,000 1,290 1,290 552.305 Uniforms 23,877 23,410 23,410 13,181 21,800 23,410 23,410 552.308 Safety Supplies 15,261 19,300 17,937 15,125 17,000 19,300 19,300 552.311 CPR Program Supplies 0 400 400 0 300 340 340 552.312 Medical Supplies 28,090 29,810 29,810 25,440 32,000 32,400 32,400 552.344 Fire Station Supplies 592 1,100 1,100 1,133 1,500 1,560 1,560 552.345 Station II Supplies 0 0 1,950 1,799 1,950 552.350 Fire Marks 0 0 0 0 0 554.300 Books, Publ, Subs & Membership 2,214 2,500 2,500 1,425 2,300 2,400 2,400 Operating Expenditures /Expense 240,740 274,240 296,300 201,948 277,085 0 283,260 282,460 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 125,575 0 0 Other Financing Sources & Uses 0 0 125,575 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.600 Mach /Equipment 4,113 9,000 233,334 209,908 208,500 4,500 4,500 664.601 Computer Equipment 8,341 0 0 0 0 664.602 Vehicles 0 0 0 0 0 Capital Outlay 12,454 9,000 233,334 209,908 208,500 0 4,500 4,500 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 19 Village of Tequesta 6/ 5 P 30 m Prior - - - - -- Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 - General Fund Expenditures Function: 420 Public Safety Fire Control 2,454,181 2,747,704 3,093,837 2,189,609 3,048,397 2,464,200 2,713,350 2,771,300 Public Safety 5,497,870 5,937,424 6,325,225 4,443,686 6,193,700 5,124,480 5,812,035 5,750,805 Function: 431 Transportation Dept: 210 Public Works Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 189,096 194,000 194,000 136,508 190,745 190,800 190,800 192,400 514.100 Overtime 623 1,500 1,500 0 500 1,000 1,000 1,000 515.104 Sick Leave Conversion Pay 0 0 0 0 0 515.106 Clothing & Boot Allowance 400 400 400 400 400 400 400 400 516.100 Compensated Absences 3,480 0 0 0 0 521.101 FICA Taxes 11,294 12,150 12,150 7,995 11,300 12,000 12,000 12,100 521.102 Medicare Taxes 2,649 2,850 2,850 1,870 2,660 2,800 2,800 2,900 522.101 FRS Contributions 13,346 12,750 12,750 9,070 12,750 16,700 16,700 14,000 522.102 VOT Pension Contributions 4,750 6,150 6,150 3,768 5,285 6,200 6,200 6,300 523.101 Life/Health Insurance 44,477 45,750 45,750 38,102 45,730 45,800 45,800 45,800 524.100 Workers' Comp Insurance 10,945 11,820 11,820 11,816 11,816 11,820 11,820 525.100 Unemployment Compensation 7,150 0 0 0 0 Personal Services 288,210 287,370 287,370 209,529 281,186 275,700 287,520 286,720 Acct Class: 530 Operating Expenditures /Expense 531.302 Engineering Services 0 1,500 7,250 6,685 7,250 2,000 2,000 534.300 Other Contractual Services 0 2,500 2,500 0 2,000 2,500 2,500 540.300 Travel & Per Diem 0 250 250 0 250 250 250 541.300 Communication Services 3,383 3,600 3,600 2,726 4,250 3,600 4,650 543.300 Utility Services 57,460 54,000 54,000 47,606 71,500 80,000 80,000 543.301 Street Lights 110,702 103,000 103,000 84,863 113,500 120,000 120,000 544.304 FEC Lease 6,487 11,000 11,000 8,993 11,000 11,000 11,000 545.300 Insurance 11,814 12,510 12,510 12,502 12,502 12,510 12,510 546.200 R &M - Station 11 0 0 0 14,505 10,465 2,000 2,000 546.301 Office Equip /Repair & Maint 273 500 500 94 500 500 500 546.302 Vehicle Repair & Maintenance 2,959 2,500 2,500 1,948 2,500 3,000 3,000 546.303 Building Repair & Maint 1,376 2,000 2,000 2,701 2,250 2,000 2,000 546.305 Pathway Maintenance 10,056 5,000 5,000 3,527 5,000 5,000 5,000 546.306 General Maintenance 21,029 30,000 26,920 13,299 26,920 30,000 30,000 546.309 Landscape & Irrigation Maint 155,240 178,000 152,366 98,747 149,316 125,000 125,000 546.310 Equipment Repair & Maint 3,423 3,000 3,000 3,230 5,000 4,000 4,000 546.320 Computer system maint & suppli 0 0 0 122 150 1,000 300 546.350 R & M - Roads 10,987 12,750 53,625 32,313 55,965 12,000 12,000 549.300 Other Misc Chgs & Obligations 1,323 1,800 1,800 236 1,800 1,800 1,800 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 20 Village of Tequesta 6/30/2010 5 : 30 p m Prior ----------- - - - - -- Current Year- (6) (7) (8) Year Original Amended Actual Thru Estimated Mo 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 - General Fund Expenditures Function: 431 Transportation Dept: 210 Public Works Acct Class: 530 Operating Expenditures /Expense 549.304 Licenses, Fees & Permits 1,555 1,600 1,600 629 1,600 1,500 1,500 551.300 Office Supplies 313 450 450 0 450 450 450 551.400 Janitorial Supplies 2,248 4,000 4,000 1,539 3,500 3,000 3,000 552.301 Gas & Oil 5,783 6,000 6,000 3,312 6,000 6,000 6,000 552.302 Small Tools and Equipment 794 900 900 900 900 900 900 552.305 Uniforms 1,033 2,000 2,000 779 1,600 2,000 2,000 553.300 Road Materials & Supplies 195 0 0 0 0 553.301 Road Signs 1,840 4,800 4,800 1,854 4,800 4,000 4,000 563.600 Public Works Misc Projects 7,500 7,500 7,500 0 5,160 7,500 7,500 563.601 Streetscape Trees 4,400 2,500 2,500 222 2,500 2,500 2,500 Operating Expenditures /Expense 422,173 453,660 471,571 343,332 508,628 0 446,010 446,360 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 663.600 Improvements other than Bldgs 4,752 0 0 0 0 664.600 Mach /Equipment 29,422 0 17,518 15,977 17,520 664.602 Vehicles 0 0 0 0 0 25,000 Capital Outlay 34,174 0 17,518 15,977 17,520 0 25,000 0 Public Works 744,557 741,030 776,459 568,838 807,334 275,700 758,530 733,080 Transportation 744,557 741,030 776,459 568,838 807,334 275,700 758,530 733,080 Function: 450 Leisure Services Dept: 230 Parks Acct Class: 530 Operating Expenditures /Expense 531.302 Engineering Services 7,000 0 0 0 0 546.306 General Maintenance 71,840 0 16,000 17,715 17,715 Operating Expenditures /Expense 78,840 0 16,000 17,715 17,715 0 0 0 Acct Class: 600 Capital Outlay 662.000 Cap Outlay 0 0 0 0 0 Capital Outlay 0 0 0 0 0 0 0 0 Parks 78,840 0 16,000 17,715 17,715 0 0 0 Dept: 231 Leisure Services Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 142,676 150,250 150,250 107,647 150,020 150,300 150,300 150,300 515.103 Bonus Pay Plan 1,356 0 0 0 0 515.104 Sick Leave Conversion Pay 0 0 0 1,410 1,410 515.106 Clothing &Boot Allowance 100 100 100 0 100 100 100 100 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 21 6/30/2010 Village of Tequesta 5:30 pm Prior - - -- Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6130 12010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 -General Fund Expenditures Function: 450 Leisure Services Dept: 231 Leisure Services Acct Class: 510 Personal Services 515.107 Part-time Salaries 35,284 47,550 47,550 34,011 47,550 46,700 46,700 46,500 515.108 Auto Allowance 3,000 3,000 3,000 2,250 3,000 3,000 3,000 3,000 515.109 Seasonal Salaries & Wages 26,830 34,000 34,000 7,726 30,000 30,000 30,000 30,000 516.100 Compensated Absences 1,074 0 0 0 0 521.101 FICA Taxes 12,640 14,400 14,400 9,194 14,400 14,300 14,300 14,300 521.102 Medicare Taxes 2,956 3,400 3,400 2,150 3,400 3,400 3,400 3,400 522.102 VOT Pension Contributions 11,500 13,500 13,500 8,676 12,100 14,200 14,200 14,200 523.101 Life /Health Insurance 36,930 35,950 35,950 29,939 35,930 35,800 35,800 36,000 524.100 Workers' Comp Insurance 6,997 7,870 7,870 7,867 7,867 7,870 7,870 526.105 Employee Physical /Psycological 1,364 200 200 848 1,400 1,400 1,400 554.301 Personnel Training 1,714 1,200 1,200 0 1,200 1,200 1,200 Personal Services 284,421 311,420 311,420 211,718 308,377 297,800 308,270 308,270 Acct Class: 530 Operating Expenditures /Expense 531.305 Computer Programming Services 0 0 0 0 0 531.324 Grants Acquistion & Admin 0 0 0 0 0 534.303 Special Events 51,367 57,000 66,303 72,775 72,775 75,000 75,000 540.300 Travel & Per Diem 1,444 3,000 3,000 0 3,000 3,000 3,000 541.300 Communication Services 1,831 2,500 2,850 1,802 3,350 2,500 4,850 541.301 Postage 96 150 150 155 200 150 150 543.300 Utility Services 12,718 18,200 18,200 9,391 14,000 14,000 14,000 545.300 Insurance 14,278 13,420 13,420 13,418 13,418 13,420 13,420 546.302 Vehicle Repair& Maintenance 1,188 1,500 1,500 1,093 1,500 1,500 1,500 546.303 Building Repair & Maint 22,075 22,000 22,000 11,130 22,000 22,000 22,000 546.306 General Maintenance 36,042 30,000 30,000 26,208 30,000 30,000 30,000 546.310 Equipment Repair &Maint 1,006 1,500 1,500 1,292 1,500 1,500 1,500 546.320 Computer system maint & suppli 493 100 100 488 500 1,300 1,100 547.300 Printing & Binding 0 0 0 0 0 549.201 Advertising & Promotion 7,865 8,000 8,000 8,992 9,300 10,000 10,000 549.300 Other Misc Chgs & Obligations 1,690 7,000 7,000 1,166 2,000 5,000 5,000 549.304 Licenses, Fees & Permits 1,306 2,000 2,000 809 1,000 1,000 1,000 549.332 Recreation Program Expense 20,752 30,000 30,000 24,831 30,000 35,000 35,000 549.333 Spring /Summer Camp 11,845 21,000 21,000 10,573 21,000 21,000 21,000 549.334 Program transaction fees 699 0 0 0 0 549.401 Recruitment expenses 0 0 0 0 0 551.300 Office Supplies 1,882 2,000 2,000 1,215 2,000 2,000 2,000 551.315 Concession Supplies 3,939 7,000 7,000 3,437 4,000 7,000 7,000 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 22 6/30/2010 Village of Tequesta 5:30 pm Prior - - -- -- - Current Year -- (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 - General Fund Expenditures Function: 450 Leisure Services Dept: 231 Leisure Services Acct Class: 530 Operating Expenditures/Expense 552.301 Gas & Oil 1,182 1,500 1,500 686 1,200 1,200 1,200 552.302 Small Tools and Equipment 5,427 1,500 1,500 761 1,500 1,500 1,500 552.305 Uniforms 210 250 250 348 350 350 350 554.300 Books, Publ, Subs & Membership 119 300 300 433 500 500 500 Operating ExpenditureslExpense 199,454 229,920 239,573 191,003 235,093 0 248,920 251,070 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 664.600 Mach /Equipment 8,750 5,000 5,000 0 1,500 Capital Outlay 8,750 5,000 5,000 0 1,500 0 0 0 Leisure Services 492,625 546,340 555,993 402,721 544,970 297,800 557,190 559,340 Dept: 361 Tequesta Drive Park Acct Class: 600 Capital Outlay 662.631 Construction 0 0 0 0 0 662.632 Architect & Engeering 0 0 0 0 0 Capital Outlay 0 0 0 0 0 0 0 0 Tequesta Drive Park 0 0 0 0 0 0 0 0 Leisure Services 571,465 546,340 571,993 420,436 562,685 297,800 557,190 559,340 Function: 581 Other Financing Sources and Us Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 591.301 Trsf to Capital Imp Fund 1,273,323 0 158,549 108,549 158,549 Interfund Transfers Out 1,273,323 0 158,549 108,549 158,549 0 0 0 Interfund Transfers 1,273,323 0 158,549 108,549 158,549 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 Other Financing Sources and Us 1,273,323 0 158,549 108,549 158,549 0 0 0 Function: 590 Other Nonoperating Dept: 700 Debt Service Acct Class: 471 D/S - Principal 571.700 Debt Svc - Principal 0 0 0 0 0 571.706 P/S Prin - BOA - P/S Bldg 208,881 218,000 218,000 162,623 218,000 227,600 227,600 227,600 571.708 P/S - Prin - SunTrust - Pumper 40,541 42,010 42,010 42,005 42,010 43,600 43,600 43,600 571.709 P/S -Prin - Lease - Ambulance 05 29,409 22,110 22,110 24,830 24,830 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 23 6/30/2010 Village of Tequesta 5:30 pm Prior - - - - -- - Current Year - - (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 001 - General Fund Expenditures Function: 590 Other Nonoperating Dept: 700 Debt Service Acct Class: 471 D/S - Principal 571.714 Prin - PD 800mghz radios 0 0 0 0 0 D /S - Principal 278,831 282,120 282,120 229,458 284,840 271,200 271,200 271,200 Acct Class: 472 D/S - Interest 572.706 P/S - Int. BOA - P.S Bldg 163,621 154,510 154,510 116,753 154,510 145,000 145,000 145,000 572.708 P/S - SunTrust - Pumper 6,179 4,720 4,720 4,715 4,720 3,200 3,200 3,200 572.709 P /S -Int- Lease - Ambulance 05 1,497 320 320 288 288 573.700 Other Debt Service Costs 0 0 0 0 0 D/S -Interest 171,297 159,550 159,550 121,756 159,518 148,200 148,200 148,200 Debt Service 450,128 441,670 441,670 351,214 444,358 419,400 419,400 419,400 Dept: 950 Other Nonoperating Acct Class: 590 Other Financing Sources & Uses 549.391 Bank Charges 9,473 12,000 12,000 6,789 10,000 12,000 12,000 12,000 590.001 Allocate to Fund Balance 0 0 0 0 0 999.001 Suspense 0 0 0 15 0 999.200 Suspense - A/P 0 0 0 0 0 Other Financing Sources & Uses 9,473 12,000 12,000 6,804 10,000 12,000 12,000 12,000 Other Nonoperating 9,473 12,000 12,000 6,804 10,000 12,000 12,000 12,000 Dept: 990 Other /ReservelContingency Acct Class: 590 Other Financing Sources & Uses 599.902 Reserves - Contingency 0 0 0 0 0 29,475 Other Financing Sources & Uses 0 0 0 0 0 0 0 29,475 Other /Reserve /Contingency 0 0 0 0 0 0 0 29,475 Other Nonoperating 459,601 453,670 453,670 358,018 454,358 431,400 431,400 460,875 Total Expenditures 9,955,165 9,114,814 9,718,888 6,899,216 9,523,282 7,258,050 8,974,765 8,831,210 General Fund - 582,641 0 0 359,718 - 945,947 104,760 - 430,405 0 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 24 6/ Village of Tequesta 5:30 pm 0 1 Prior - Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6130/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 301 - Capital Improvement Fund Revenues Function: 000 General Revenues Dept: 000 General Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 31,615 0 0 0 0 Miscellaneous Revenues 31,615 0 0 0 0 0 0 0 General 31,615 0 0 0 0 0 0 0 General Revenues 31,615 0 0 0 0 0 0 0 Function: 581 Other Financing Sources and Us Dept: 900 Interfund Transfers Acct Class: 391 Transfers In 381.001 Transfer from General Fund 1,273,323 0 158,549 108,549 158,549 381.303 Tsfer -In from Capital Projects 0 115,000 115,000 115,000 115,000 Transfers In 1,273,323 115,000 273,549 223,549 273,549 0 0 0 Interfund Transfers 1,273,323 115,000 273,549 223,549 273,549 0 0 0 Other Financing Sources and Us 1,273,323 115,000 273,549 223,549 273,549 0 0 0 Function: 590 Other Nonoperating Dept: 990 Other /Reserve /Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 1,198,323 1,119,282 0 571,644 250,000 Other Financing Sources 0 1,198,323 1,119,282 0 571,644 0 0 250,000 Other /Reserve/Contingency 0 1,198,323 1,119,282 0 571,644 0 0 250,000 Other Nonoperating 0 1,198,323 1,119,282 0 571,644 0 0 250,000 Total Revenues 1,304,938 1,313,323 1,392,831 223,549 845,193 0 0 250,000 Expenditures Function: 000 General Revenues Dept: 000 General 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 General 0 0 0 0 0 0 0 0 General Revenues 0 0 0 0 0 0 0 0 Function: 431 Transportation Dept: 210 Public Works Acct Class: 600 Capital Outlay 663.652 Pathway Improvements 0 0 0 0 0 663.657 Roadway Improvements 0 0 0 0 0 Capital Outlay 0 0 0 0 0 0 0 0 Public Works 0 0 0 0 0 0 0 0 Dept: 315 Tequesta Drive (Bridge) Acct Class: 600 Capital Outlay 662,632 Architect & Engeering 371,302 0 51,250 22,691 56,680 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 25 613012010 Village of Tequesta 5:30 pm Prior - Current Year - (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 301 - Capital Improvement Fund Expenditures Function: 431 Transportation Dept: 315 Tequesta Drive (Bridge) Acct Class: 600 Capital Outlay 662.633 Construction -Other 189,968 0 31,058 31,366 35,000 663.301 Construction - Bridge 0 1,198,323 1,195,523 0 648,323 Capital Outlay 561,270 1,198,323 1,277,831 54,057 740,003 0 0 0 Tequesta Drive (Bridge) 561,270 1,198,323 1,277,831 54,057 740,003 0 0 0 Transportation 561,270 1,198,323 1,277,831 54,057 740,003 0 0 0 Function: 450 Leisure Services Dept: 317 Recreation Center Acct Class: 530 Operating Expenditures /Expense 546.303 Building Repair & Maint 0 0 65,000 41,029 66,905 Operating Expenditures /Expense 0 0 65,000 41,029 66,905 0 0 0 Acct Class: 600 Capital Outlay 664.600 Mach /Equipment 0 65,000 0 0 0 Capital Outlay 0 65,000 0 0 0 0 0 0 Recreation Center 0 65,000 65,000 41,029 66,905 0 0 0 Dept: 399 Misc Proj - General Acct Class: 600 Capital Outlay 664.600 Mach /Equipment 0 50,000 50,000 44,149 49,807 Capital Outlay 0 50,000 50,000 44,149 49,807 0 0 0 Misc Proj - General 0 50,000 50,000 44,149 49,807 0 0 0 Leisure Services 0 115,000 115,000 85,178 116,712 0 0 0 Function: 581 Other Financing Sources and Us Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 591.001 Transfer to General Fund 0 0 0 0 0 250,000 250,000 Interfund Transfers Out 0 0 0 0 0 0 250,000 250,000 Interfund Transfers 0 0 0 0 0 0 250,000 250,000 Dept: 910 Other Financing Sources & Uses 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 Financing Sources & Uses 0 0 0 0 0 0 0 0 Other Financing Sources and Us 0 0 0 0 0 0 250,000 250,000 Total Expenditures 561,270 1,313,323 1,392,831 139,235 856,715 0 250,000 250,000 Capital Improvement Fund 743,668 0 0 84,314 - 11,522 0 - 250,000 0 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 26 6/30/2010 Village of Tequesta 5:30 pm Prior - - -- Current Year -- (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6130 /2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 303 - Capital Projects Fund Revenues Function: 000 General Revenues Dept: 000 General Acct Class: 334 Grants - State 334.205 State DEP Grant 0 0 80,000 100,000 100,000 Grants - State 0 0 80,000 100,000 100,000 0 0 0 General 0 0 80,000 100,000 100,000 0 0 0 General Revenues 0 0 80,000 100,000 100,000 0 0 0 Function: 581 Other Financing Sources and Us Dept: 900 Interfund Transfers Acct Class: 391 Transfers In 381.001 Transfer from General Fund 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 Other Financing Sources and Us 0 0 0 0 0 0 0 0 Function: 590 Other Nonoperating Dept: 990 Other /Reserve /Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 115,000 115,000 0 95,000 Other Financing Sources 0 115,000 115,000 0 95,000 0 0 0 Other /Reserve /Contingency 0 115,000 115,000 0 95,000 0 0 0 Other Nonoperating 0 115,000 115,000 0 95,000 0 0 0 Total Revenues 0 115,000 195,000 100,000 195,000 0 0 0 Expenditures Function: 000 General Revenues Dept: 000 General 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 General 0 0 0 0 0 0 0 0 General Revenues 0 0 0 0 0 0 0 0 Function: 450 Leisure Services Dept: 316 Constitution Park Acct Class: 600 Capital Outlay 663.672 Miscellaneous Park Projects 0 0 0 0 0 Capital Outlay 0 0 0 0 0 0 0 0 Constitution Park 0 0 0 0 0 0 0 0 Dept: 317 Recreation Center Acct Class: 530 Operating Expenditures /Expense 546.303 Building Repair & Maint 0 0 0 0 0 Operating Expenditures /Expense 0 0 0 0 0 0 0 0 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 27 613012010 Village of Tequesta 5:30 pm Prior - Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 613012010 Actual Budget Budget June Total FINANCE EPARTMENTS MANA Fund: 303 - Capital Projects Fund Expenditures Function: 450 Leisure Services Recreation Center 0 0 0 0 0 0 0 0 Dept: 323 Tequesta Park Acct Class: 600 Capital Outlay 663.672 Miscellaneous Park Projects 19,961 0 80,000 80,000 80,000 Capital Outlay 19,961 0 80,000 80,000 80,000 0 0 0 Tequesta Park 19,961 0 80,000 80,000 80,000 0 0 0 Dept: 361 Tequesta Drive Park Acct Class: 600 Capital Outlay 662.631 Construction 0 0 0 0 0 662.632 Architect & Engeering 0 0 0 0 0 662.633 Construction- Other 0 0 0 0 0 Capital Outlay 0 0 0 0 0 0 0 0 Tequesta Drive Park 0 0 0 0 0 0 0 0 Dept: 399 Misc Proj - General Acct Class: 600 Capital Outlay 663.675 FEC Project 7,523 0 0 0 0 Capital Outlay 7,523 0 0 0 0 0 0 0 Misc Proj - General 7,523 0 0 0 0 0 0 0 Leisure Services 27,484 0 80,000 80,000 80,000 0 0 0 Function: 581 Other Financing Sources and Us Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 591.301 Trsf to Capital Imp Fund 0 115,000 115,000 115,000 115,000 Interfund Transfers Out 0 115,000 115,000 115,000 115,000 0 0 0 Interfund Transfers 0 115,000 115,000 115,000 115,000 0 0 0 Other Financing Sources and Us 0 115,000 115,000 115,000 115,000 0 0 0 Total Expenditures 27,484 115,000 195,000 195,000 195,000 0 0 0 Capital Projects Fund - 27,484 0 0 - 95,000 0 0 0 0 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 28 6/30/2010 Village of Tequesta 5:30 pm Prior - Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS M ANA G ER Fund: 401 -Water Fund Revenues Function: 000 General Revenues Dept: 000 General Acct Class: 340 Charges for Services 343.301 Water Sales 2,159,118 2,265,750 2,265,750 1,680,551 2,200,000 2,244,000 2,244,000 2,314,100 343.302 Water- Connect Charges 17,379 8,500 8,500 11,350 12,000 12,240 12,240 12,070 343.303 Water -Fire Hydrants Rent 73,883 64,000 64,000 57,249 76,000 77,520 77,520 68,000 343.304 Water Surcharge 331,876 325,000 325,000 232,085 345,000 351,900 351,900 330,000 343.306 Monthly Service Charge 1,211,239 1,200,000 1,200,000 961,553 1,247,000 1,271,940 1,271,940 1,224,000 343.307 Penalty Charges 4,417 4,000 4,000 3,861 4,000 4,000 4,000 4,000 343.308 Other Water Service Income 6,450 2,500 2,500 3,592 4,000 4,080 4,080 3,000 343.309 Convenience Fee - CC 0 0 0 161 109 40 40 343.700 Water Conservation & Resource 188 200 200 236 196 200 Charges for Services 3,804,550 3,869,950 3,869,950 2,950,638 3,888,305 3,965,720 3,965,720 3,955,370 Acct Class: 361 Unrestricted Investment Eamin 361.100 InteresUlnvestment Earnings 0 25,640 25,640 10,035 15,000 15,000 15,000 15,000 361.105 Int Income - Tropic Vista Asse 0 0 0 0 0 Unrestricted Investment Eamin 0 25,640 25,640 10,035 15,000 15,000 15,000 15,000 Acct Class: 369 Miscellaneous Revenues 363.101 Martin/Tropic V -Const portion 19,949 18,500 18,500 37,455 18,727 18,500 18,500 18,500 369.000 Other Miscellaneous Revenue 22,131 0 0 17,089 17,087 369.100 Insurance Reimbursment 0 0 0 3,767 3,767 Miscellaneous Revenues 42,080 18,500 18,500 58,311 39,581 18,500 18,500 18,500 Acct Class: 390 Other Financing Sources 369.110 Capital Connect Charge - Cust 13,179 14,000 14,000 23,503 23,503 14,000 14,000 17,000 369.111 Capital Connect Charge - Devel 27,927 10,000 10,000 5,404 5,404 5,500 5,500 10,000 369.112 Capital Connect -Tropic Vist 17,784 18,500 18,500 0 18,727 18,500 18,500 18,500 Other Financing Sources 58,890 42,500 42,500 28,907 47,634 38,000 38,000 45,500 General 3,905,520 3,956,590 3,956,590 3,047,891 3,990,520 4,037,220 4,037,220 4,034,370 General Revenues 3,905,520 3,956,590 3,956,590 3,047,891 3,990,520 4,037,220 4,037,220 4,034,370 Function: 590 Other Nonoperating Dept: 950 Other Nonoperating Acct Class: 367 Investment income 367.100 Unrealized gain /loss on invest 0 0 0 21,530 0 Investment income 0 0 0 21,530 0 0 0 0 Other Nonoperating 0 0 0 21,530 0 0 0 0 Dept: 990 Other /Reserve /Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 211,000 229,848 0 0 Other Financing Sources 0 211,000 229,848 0 0 0 0 0 Other /Reserve /Contingency 0 211,000 229,848 0 0 0 0 0 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 29 6/30/2010 Village of Tequesta 5:30 pm Prior - Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 401 -Water Fund Revenues Other Nonoperating 0 211,000 229,848 21,530 0 0 0 0 Total Revenues 3,905,520 4,167,590 4,186,438 3,069,421 3,990,520 4,037,220 4,037,220 4,034,370 Expenditures Function: 533 Water Utility Services Dept: 241 Water- Administration Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 110,004 116,200 114,550 82,231 114,542 114,800 114,800 114,800 515.103 Bonus Pay Plan 10,878 0 0 0 0 515.104 Sick Leave Conversion Pay 2,981 0 0 0 0 515.108 Auto Allowance 3,000 3,000 3,000 2,250 3,000 3,000 3,000 3,000 516.100 Compensated Absences 0 0 0 0 0 521.101 FICA Taxes 5,543 7,400 6,600 4,385 5,660 5,660 5,660 5,660 521.102 Medicare Taxes 1,978 1,750 1,821 1,303 1,821 1,800 1,800 1,800 522.102 VOT Pension Contributions 8,770 10,350 9,150 6,555 9,136 10,700 10,700 10,700 523.101 Life /Health Insurance 10,096 9,850 9,850 8,184 9,821 9,900 9,900 9,900 524.100 Workers' Comp Insurance 0 400 400 338 338 340 340 526.1041CMA- Def Comp Plan 8,803 9,300 9,100 6,509 9,072 9,100 9,100 9,100 Personal Services 162,053 158,250 154,471 111,755 153,390 154,960 155,300 155,300 Acct Class: 530 Operating Expenditures /Expense 531.301 Legal Services 9,385 7,500 7,500 4,250 7,500 7,500 7,500 531.302 Engineering Services 36,310 25,000 54,500 19,589 54,500 35,000 35,000 532.300 Accounting & Auditing Services 35,250 29,760 30,653 30,643 30,643 30,900 30,900 30,900 534.300 Other Contractual Services 25,451 18,000 18,000 13,500 18,000 18,000 18,000 18,000 544.304 FEC Lease 11,468 12,000 11,779 11,679 11,679 12,000 12,000 12,000 545.300 Insurance 55,368 50,700 50,700 50,630 50,630 50,700 50,700 546.320 Computer system maint & suppli 0 0 4,000 0 4,000 547.300 Printing & Binding 0 0 0 0 0 549.301 Admin Mgmt Fees 277,190 291,150 291,150 218,363 291,150 305,700 305,700 549.304 Licenses, Fees & Permits 781 800 800 781 781 800 800 800 552.302 Small Tools and Equipment 770 0 0 0 0 Operating Expenditures/Expense 451,973 434,910 469,082 349,435 468,883 61,700 460,600 460,600 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Water - Administration 614,026 593,160 623,553 461,190 622,273 216,660 615,900 615,900 Dept: 242 Water- Production Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 371,327 392,450 392,450 268,735 374,300 374,800 374,800 378,900 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 30 6/30/2010 Village of Tequesta 5:30 pm Prior - - - -- Current Year - - -- (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6130 /2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 401 - Water Fund Expenditures Function: 533 Water Utility Services Dept: 242 Water- Production Acct Class: 510 Personal Services 514.100 Overtime 6,662 12,000 12,000 2,159 5,000 10,000 10,000 10,000 515.102 Standby Pay 4,701 5,800 5,800 3,371 4,800 5,000 5,000 5,000 515.103 Bonus Pay Plan 0 0 0 1,822 1,822 515.104 Sick Leave Conversion Pay 7,864 4,500 4,500 0 0 515.106 Clothing & Boot Allowance 600 600 600 600 600 600 600 600 516.100 Compensated Absences 0 0 0 0 0 521.101 FICA Taxes 24,410 25,750 25,750 16,816 24,000 24,200 24,200 24,500 521.102 Medicare Taxes 5,709 6,050 6,050 3,933 5,600 5,700 5,700 5,800 522.101 FRS Contributions 20,632 21,650 21,650 10,540 15,000 19,800 19,800 16,300 522.102 VOT Pension Contributions 13,737 16,350 16,350 12,980 18,100 21,000 21,000 21,400 523.101 Life /Health Insurance 54,148 52,900 52,900 51,116 61,530 62,500 62,500 62,500 524.100 Workers' Comp Insurance 9,959 11,120 11,120 11,113 11,113 11,120 11,120 554.301 Personnel Training 603 1,000 1,700 826 1,700 1,000 1,000 Personal Services 520,352 550,170 550,870 384,011 523,565 523,600 535,720 537,120 Acct Class: 530 Operating Expenditures /Expense 531.342 Water Analysis & Sampling 38,834 40,000 39,325 27,257 39,325 40,000 40,000 540.300 Travel & Per Diem 758 2,500 3,500 1,112 3,500 2,000 2,000 541.300 Communication Services 7,521 9,000 9,000 6,470 9,650 8,000 9,000 9,400 541.301 Postage 963 500 1,175 1,251 1,375 500 500 543.300 Utility Services 416,475 428,000 398,500 280,584 385,000 410,000 470,000 450,000 544.301 Equipment Leases 9,240 9,500 9,500 6,990 9,500 9,500 9,500 9,500 546.302 Vehicle Repair & Maintenance 2,230 2,500 4,000 3,701 4,000 2,500 2,500 546.303 Building Repair & Maint 6,263 7,000 7,000 6,539 9,200 9,000 9,000 546.309 Landscape & Irrigation Maint 5,535 7,000 7,000 3,631 6,000 7,000 7,000 546.310 Equipment Repair & Maint 15,963 18,000 18,000 15,963 18,000 18,000 18,000 546.320 Computer system maint & suppli 0 0 0 611 611 1,000 1,300 546.342 Water System Maintenance 52,175 60,000 55,651 11,659 44,340 60,000 60,000 546.343 Well Redevelopment 21,446 25,000 25,000 20,847 33,300 25,000 25,000 549.300 Other Misc Chgs & Obligations 3,961 6,000 2,200 741 2,000 2,000 2,000 549.304 Licenses, Fees & Permits 17,257 18,000 23,800 23,189 23,800 21,250 21,250 551.300 Office Supplies 2,828 3,000 3,000 1,501 2,500 2,500 2,500 552.301 Gas & Oil 4,956 5,000 5,000 3,215 5,000 5,000 5,000 552.302 Small Tools and Equipment 3,719 4,000 4,000 3,618 4,000 4,000 4,000 552.303 Diesel Fuel 3,356 15,000 15,000 0 5,000 15,000 15,000 552.305 Uniforms 1,144 1,400 1,400 1,244 1,400 1,400 1,400 552.341 Water Purchases 0 30,000 30,000 0 0 30,000 30,000 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 31 6/30/2010 Village of Tequesta 5:30 pm Prior Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 401 -Water Fund Expenditures Function: 533 Water Utility Services Dept: 242 Water- Production Acct Class: 530 Operating Expenditures/Expense 552.342 Water Chemicals 211,702 240,000 240,000 113,730 240,000 260,000 245,000 552.343 Laboratory Supplies 11,425 11,000 11,000 9,460 11,000 11,000 11,000 554.300 Books, Publ, Subs & Membership 1,231 1,500 1,500 1,111 1,500 1,500 1,500 Operating Expenditures/Expense 838,982 943,900 914,551 544,424 860,001 427,500 1,007,150 972,850 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 2,849 2,849 2,849 Capital Outlay 0 0 2,849 2,849 2,849 0 0 0 Water- Production 1,359,334 1,494,070 1,468,270 931,284 1,386,415 951,100 1,542,870 1,509,970 Dept: 243 Water- Distribution Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 378,910 407,800 407,800 290,133 404,660 404,600 404,600 406,200 514.100 Overtime 4,020 8,000 8,000 2,948 4,500 5,000 5,000 5,000 515.102 Standby Pay 5,919 6,400 6,400 4,852 6,400 6,400 6,400 6,400 515.103 Bonus Pay Plan 0 0 0 0 0 515.104 Sick Leave Conversion Pay 7,146 0 0 0 0 515.106 Clothing & Boot Allowance 600 600 600 600 600 600 600 600 516.100 Compensated Absences 0 0 0 0 0 521.101 FICA Taxes 23,685 26,250 26,250 17,318 24,500 25,900 25,900 26,000 521.102 Medicare Taxes 5,911 6,150 6,150 4,197 5,850 6,100 6,100 6,100 522.101 FRS Contributions 22,001 12,900 12,900 8,983 12,600 16,700 16,700 14,000 522.102 VOT Pension Contributions 15,423 17,150 17,150 16,235 22,650 17,700 17,700 26,600 523.101 Life /Health Insurance 78,127 76,000 76,000 67,845 80,850 80,900 80,900 80,900 524.100 Workers' Comp Insurance 9,374 10,330 10,330 10,328 10,328 10,330 10,330 525.100 Unemployment Compensation 7,150 0 0 0 0 554.301 Personnel Training 0 1,000 1,000 855 1,000 1,000 1,000 Personal Services 558,266 572,580 572,580 424,294 573,938 563,900 575,230 583,130 Acct Class: 530 Operating Expenditures /Expense 540.300 Travel & Per Diem 0 750 770 592 770 541.300 Communication Services 5,496 5,000 5,000 4,023 6,000 5,000 7,150 541.301 Postage 18,199 22,000 22,000 16,156 22,000 20,000 23,000 23,000 544.301 Equipment Leases 1,992 2,000 2,000 1,361 2,042 2,160 2,500 2,500 546.301 Office Equip /Repair & Maint 277 650 650 394 650 500 650 650 546.302 Vehicle Repair & Maintenance 5,538 4,800 4,800 3,307 4,800 5,000 5,000 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 32 6/ Village of Tequesta 50 P m 30 Prior - - - - - -- Current Year -- (6) (7) (8) Year Original Amended Actual Thru Estimated Mon 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 401 - Water Fund Expenditures Function: 533 Water Utility Services Dept: 243 Water - Distribution Acct Class: 530 Operating Expenditures /Expense 546.303 Building Repair& Maint 1,464 4,000 4,000 1,278 4,000 3,500 3,500 546.309 Landscape & Irrigation Maint 0 900 900 265 900 900 900 546.310 Equipment Repair & Maint 5,497 5,000 5,000 3,036 5,000 500 500 546.320 Computer system maint & suppli 2,741 3,600 3,600 4,597 4,597 3,500 3,600 6,400 546.342 Water System Maintenance 18,321 19,000 32,330 32,981 34,830 19,000 19,000 546.344 New Service Connection Expense 486 900 900 0 900 900 900 549.300 Other Misc Chgs & Obligations 128 2,000 2,000 446 2,000 2,000 2,000 549.304 Licenses, Fees & Permits 1,230 1,520 1,520 404 1,520 800 1,520 1,520 551.300 Office Supplies 1,319 950 950 1,129 1,400 950 950 551.310 Printing & Binding 2,085 2,800 2,800 2,269 2,800 2,850 2,800 2,800 552.301 Gas & Oil 14,025 19,000 19,000 7,048 10,610 19,000 19,000 552.302 Small Tools and Equipment 638 1,500 1,500 1,499 1,499 1,500 1,500 552.305 Uniforms 1,296 2,400 2,380 1,400 1,800 2,400 2,400 554.300 Books, Publ, Subs & Membership 0 400 400 0 400 Operating Expenditures /Expense 80,732 99,170 112,500 82,185 108,518 29,810 94,720 99,670 Acct Class: 590 Other Financing Sources & Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Water- Distribution 638,998 671,750 685,080 506,479 682,456 593,710 669,950 682,800 Dept: 411 Renewal & Replacement Acct Class: 530 Operating Expenditures /Expense 546.605 R &M - Well Site Rehab 10,468 15,000 11,300 3,309 11,300 8,000 8,000 549.671 Misc. Renewal & Replacement 36,819 40,000 40,000 19,396 40,000 40,000 40,000 552.601 Meters, Valves & Hydrants 10,106 12,000 12,000 9,713 12,000 12,000 12,000 552.603 Filter Cartridges /ROP 4,988 5,000 5,000 4,973 5,000 5,000 5,000 552.610 R.0 Membrane Replacement 0 130,000 130,000 122,475 122,475 Operating Expenditures /Expense 62,381 202,000 198,300 159,866 190,775 0 65,000 65,000 Acct Class: 600 Capital Outlay 664.600 Mach /Equipment 0 0 0 0 0 664.602 Vehicles 0 0 0 0 0 25,000 25,000 Capital Outlay 0 0 0 0 0 0 25,000 25,000 Renewal & Replacement 62,381 202,000 198,300 159,866 190,775 0 90,000 90,000 Dept: 412 Capital Improvement Acct Class: 600 Capital Outlay 664.600 Mach /Equipment 0 25,000 25,000 22,042 24,870 Capital Outlay 0 25,000 25,000 22,042 24,870 0 0 0 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 33 6/30/2010 Village of Tequesta 5:30 pm Prior - -- Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 401 -Water Fund Expenditures Function: 533 Water Utility Services Capital Improvement 0 25,000 25,000 22,042 24,870 0 0 0 Dept: 414 Capital Expansion Projects Acct Class: 164 Improvements Other Than Bldgs. 662.640 Misc Water Main Extension 0 0 0 0 0 Improvements Other Than Bldgs. 0 0 0 0 0 0 0 0 Acct Class: 600 Capital Outlay 662.632 Architect & Engeering 0 0 0 0 0 662.641 Const- Pipeline 0 0 0 5,250 5,250 662.710 Water Storage Tank 0 0 0 0 0 665.632 Eng: RO WTP Expansion 0 0 4,625 4,625 4,625 665.639 Eng. - Miscellaneous 0 0 0 0 0 Capital Outlay 0 0 4,625 9,875 9,875 0 0 0 Capital Expansion Projects 0 0 4,625 9,875 9,875 0 0 0 Water Utility Services 2,674,739 2,985,980 3,004,828 2,090,736 2,916,664 1,761,470 2,918,720 2,898,670 Function: 581 Other Financing Sources and Us Dept: 910 Other Financing Sources & Uses Acct Class: 590 Other Financing Sources & Uses 567.000 Gain /Loss on Investments 9,687 0 0 0 0 567.100 Unrealized Loss on Investments 0 0 0 0 0 Other Financing Sources & Uses 9,687 0 0 0 0 0 0 0 Other Financing Sources & Uses 9,687 0 0 0 0 0 0 0 Other Financing Sources and Us 9,687 0 0 0 0 0 0 0 Function: 590 Other Nonoperating Dept: 700 Debt Service Acct Class: 471 D/S - Principal 571.704 Prin -1998 Water Rev Bnds 0 0 0 0 0 571.705 Prin - 2004 Water N/P BOA 0 25,000 25,000 25,000 25,000 26,000 26,000 26,000 571.720 Prin - 2008 Water Utility Note 0 237,940 237,940 177,270 237,940 247,000 247,000 247,000 D/S - Principal 0 262,940 262,940 202,270 262,940 273,000 273,000 273,000 Acct Class: 472 D/S - Interest 572.704 Int -1998 Water Revenue Bonds 0 0 0 0 0 572.705 Int - 2004 Water N/P BOA 20,075 19,400 19,400 11,334 19,400 18,200 18,200 18,200 572.720 Int - 2008 Water Utility Note 238,578 230,520 230,520 153,975 230,520 221,500 221,500 221,500 573.700 Other Debt Service Costs 24,033 29,000 29,000 0 29,000 29,000 29,000 29,000 DIS -Interest 282,686 278,920 278,920 165,309 278,920 268,700 268,700 268,700 Debt Service 282,686 541,860 541,860 367,579 541,860 541,700 541,700 541,700 Dept: 950 Other Nonoperating Acct Class: 530 Operating Expenditures /Expense 559.300 Depreciation 941,035 0 0 0 0 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 34 Village of Tequesta 6/30/2010 m 5:30 p 5:30 p Prior - -- Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6130 /2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 401 - Water Fund Expenditures Function: 590 Other Nonoperating Dept: 950 Other Nonoperating Acct Class: 530 Operating Expenditures /Expense 559.301 Budgeted Depreciation (netted) 0 627,750 627,750 0 606,800 582,000 582,000 582,000 Operating Expenditures /Expense 941,035 627,750 627,750 0 606,800 582,000 582,000 582,000 Acct Class: 590 Other Financing Sources & Uses 549.391 Bank Charges 9,482 12,000 12,000 6,723 10,000 12,000 12,000 12,000 549.395 Credit Card Fees and Charges 7 0 0 0 0 590.001 Allocate to Fund Balance 0 0 0 0 0 999.001 Suspense 0 0 0 0 0 999.200 Suspense - A/P 0 0 0 0 0 Other Financing Sources & Uses 9,489 12,000 12,000 6,723 10,000 12,000 12,000 12,000 Other Nonoperating 950,524 639,750 639,750 6,723 616,800 594,000 594,000 594,000 Dept: 990 Other /ReservelContingency Acct Class: 590 Other Financing Sources & Uses 599.902 Reserves - Contingency 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Other /Reserve /Contingency 0 0 0 0 0 0 0 0 Other Nonoperating 1,233,210 1,181,610 1,181,610 374,302 1,158,660 1,135,700 1,135,700 1,135,700 Total Expenditures 3,917,636 4,167,590 4,186,438 2,465,038 4,075,324 2,897,170 4,054,420 4,034,370 Water Fund 12,116 0 0 604,383 - 84,804 1,140,050 - 17,200 0 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 35 6/30/2010 Village of Tequesta 5:30 pm Prior Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 402 - Refuse & Recycling Revenues Function: 000 General Revenues Dept: 000 General Acct Class: 340 Charges for Services 343.307 Penalty Charges 2 0 0 1 0 343.400 Refuse / Recycling Fees 414,310 417,680 417,680 402,824 401,235 429,510 429,510 429,510 Charges for Services 414,312 417,680 417,680 402,825 401,235 429,510 429,510 429,510 Acct Class: 361 Unrestricted Investment Eamin 361.100 InteresUlnvestment Eamings 0 950 950 452 452 500 500 500 361.101 PBC Tax Col - Interest on Dep 171 0 0 82 82 361.300 Net Change in FMV 0 0 0 0 0 Unrestricted Investment Eamin 171 950 950 534 534 500 500 500 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 19,190 19,190 0 0 15,000 15,000 15,000 Other Financing Sources 0 19,190 19,190 0 0 15,000 15,000 15,000 General 414,483 437,820 437,820 403,359 401,769 445,010 445,010 445,010 General Revenues 414,483 437,820 437,820 403,359 401,769 445,010 445,010 445,010 Function: 590 Other Nonoperating Dept: 950 Other Nonoperating Acct Class: 367 Investment income 367.100 Unrealized gain /loss on invest 0 0 0 1,191 0 Investment income 0 0 0 1,191 0 0 0 0 Other Nonoperating 0 0 0 1,191 0 0 0 0 Other Nonoperating 0 0 0 1,191 0 0 0 0 Total Revenues 414,483 437,820 437,820 404,550 401,769 445,010 445,010 445,010 Expenditures Function: 534 Refuse & Recycling Dept: 245 Refuse and Recycling Aoct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 92 500 500 147 500 500 500 500 543.302 Solid Waste /Residential 259,884 255,440 255,440 188,946 251,930 437,310 437,310 437,310 543.303 Recycling /Residential 91,300 85,240 89,731 66,486 88,650 543.304 Yard Waste /Residential 86,754 89,740 85,249 63,077 84,100 549.300 Other Misc Chgs & Obligations 558 750 750 179 750 750 750 750 549.301 Admin Mgmt Fees 5,860 6,150 6,150 4,613 6,150 6,450 6,450 Operating Expenditures /Expense 444,448 437,820 437,820 323,448 432,080 438,560 445,010 445,010 Refuse and Recycling 444,448 437,820 437,820 323,448 432,080 438,560 445,010 445,010 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 36 6l Village of Tequesta 5:30 0 m P Prior - - - - -- Current Year — (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 613012010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 402 - Refuse & Recycling Expenditures Refuse & Recycling 444,448 437,820 437,820 323,448 432,080 438,560 445,010 445,010 Function: 581 Other Financing Sources and Us Dept: 910 Other Financing Sources & Uses Acct Class: 590 Other Financing Sources & Uses 567.000 Gain /Loss on Investments 328 0 0 0 0 567.100 Unrealized Loss on Investments 0 0 0 0 0 Other Financing Sources & Uses 328 0 0 0 0 0 0 0 Other Financing Sources & Uses 328 0 0 0 0 0 0 0 Other Financing Sources and Us 328 0 0 0 0 0 0 0 Total Expenditures 444,776 437,820 437,820 323,448 432,080 438,560 445,010 445,010 Refuse & Recycling - 30,293 0 0 81,102 - 30,311 6,450 0 0 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 37 Village of Te uesta 6/ 5:30 p 0 g 4 5:30 pm Prior ----- - - - - -- Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30 12010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 403 - Stormwater Utility Revenues Function: 000 General Revenues Dept: 000 General Acct Class: 340 Charges for Services 343.901 Storm Water Utility Fees 314,567 317,000 317,000 304,874 303,829 317,000 317,000 317,000 Charges for Services 314,567 317,000 317,000 304,874 303,829 317,000 317,000 317,000 Acct Class: 361 Unrestricted Investment Eamin 361.100 InteresUlnvestment Earnings 512 1,050 1,050 1,045 1,045 1,980 1,980 1,980 361.101 PBC Tax Col - Interest on Dep 124 0 0 62 62 361.300 Net Change in FMV 0 0 0 0 0 Unrestricted Investment Eamin 636 1,050 1,050 1,107 1,107 1,980 1,980 1,980 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 0 0 0 792 792 Miscellaneous Revenues 0 0 0 792 792 0 0 0 General 315,203 318,050 318,050 306,773 305,728 318,980 318,980 318,980 General Revenues 315,203 318,050 318,050 306,773 305,728 318,980 318,980 318,980 Function: 590 Other Nonoperating Dept: 950 Other Nonoperating Acct Class: 367 Investment income 367.100 Unrealized gain /loss on invest 0 0 0 1,211 0 Investment income 0 0 0 1,211 0 0 0 0 Other Nonoperating 0 0 0 1,211 0 0 0 0 Dept: 990 Other /Reserve /Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0 0 53 0 0 103,870 Other Financing Sources 0 0 53 0 0 0 0 103,870 Other /Reserve /Contingency 0 0 53 0 0 0 0 103,870 Other Nonoperating 0 0 53 1,211 0 0 0 103,870 Total Revenues 315,203 318,050 318,103 307,984 305,728 318,980 318,980 422,850 Expenditures Function: Dept: 340 Swale Construction Acct Class: 600 Capital Outlay 663.663 Drainage Improvements 0 5,000 5,000 0 5,000 5,000 5,000 Capital Outlay 0 5,000 5,000 0 5,000 0 5,000 5,000 Swale Construction 0 5,000 5,000 0 5,000 0 5,000 5,000 Function: 0 5,000 5,000 0 5,000 0 5,000 5,000 Function: 550 Storrnwater Dept: 250 Storm Water Utilities Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 34,251 37,800 37,100 21,944 30,482 36,000 36,000 30,400 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 38 Village of Te uesta 6/ 5:30 p 0 9 q 5:30 pm Prior - - -- Current Year -- (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 403 - Stormwater Utility Expenditures Function: 550 Stormwater Dept: 250 Storm Water Utilities Acct Class: 510 Personal Services 514.100 Overtime 517 1,000 1,000 237 600 1,000 1,000 1,000 515.102 Standby Pay 1,359 1,200 1,200 768 1,200 1,400 1,400 1,400 515.103 Bonus Pay Plan 0 0 0 0 0 515.106 Clothing & Boot Allowance 100 100 100 100 200 100 100 100 516.100 Compensated Absences 282 0 0 2,101 2,101 521.101 FICA Taxes 2,230 2,500 2,500 1,552 2,150 2,400 2,400 2,100 521.102 Medicare Taxes 522 600 600 363 500 600 600 500 522.102 VOT Pension Contributions 2,761 3,400 3,400 1,769 2,460 3,400 3,400 2,900 523.101 Life /Health Insurance 6,387 6,250 6,250 3,682 5,190 6,300 6,300 6,300 524.100 Workers' Comp Insurance 1,011 1,140 1,140 1,139 1,139 1,140 1,140 554.301 Personnel Training 0 400 400 0 0 500 500 Personal Services 49,420 54,390 53,690 33,655 46,022 51,200 52,840 46,340 Acct Class: 530 Operating Expenditures /Expense 531.301 Legal Services 0 0 0 0 0 531.302 Engineering Services 833 1,500 1,500 1,493 1,500 2,000 2,000 532.300 Accounting & Auditing Services 4,935 4,170 4,223 4,218 4,218 4,350 4,350 4,350 540.300 Travel & Per Diem 0 400 400 255 400 500 500 541.300 Communication Services 636 500 500 590 950 500 1,000 541.301 Postage 0 300 300 0 100 300 300 546.302 Vehicle Repair & Maintenance 1,097 500 1,400 1,077 1,400 500 500 546.303 Building Repair & Maint 25 2,000 2,000 0 2,000 2,000 2,000 546.308 Drainage Maintenance 56,427 40,000 39,100 16,080 38,600 40,000 40,000 546.310 Equipment Repair & Maint 1,478 1,500 1,500 599 1,500 1,500 1,500 546.320 Computer system maint & suppli 0 0 700 122 700 450 546.350 R& M- Roads 0 0 22,150 0 22,150 549.300 Other Misc Chgs & Obligations 150 950 950 366 950 950 950 549.301 Admin Mgmt Fees 9,940 10,440 10,440 7,830 10,440 10,960 10,960 549.304 Licenses, Fees & Permits 2,363 2,800 2,726 2,040 2,040 2,800 2,800 551.300 Office Supplies 152 300 300 0 300 300 300 552.301 Gas & Oil 2,457 3,000 3,000 1,083 3,000 3,000 3,000 552.302 Small Tools and Equipment 225 400 474 474 474 400 400 554.100 Public Education Program 0 500 500 82 250 500 500 Operating Expenditures /Expense 80,718 69,260 92,163 36,309 90,972 4,350 70,560 71,510 Acct Class: 590 Other financing Sources & Uses 599.100 Budget Cost Savings 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 39 6130/2010 Village of Tequesta 5:30 pm Prior - -- - Current Year (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 613012010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Fund: 403 - Stormwater Utility Expenditures Function: 550 Stormwater Dept: 250 Storm Water Utilities Acct Class: 600 Capital Outlay 662.632 Architect & Engeering 0 0 0 0 0 663.663 Drainage Improvements 0 100,000 77,850 54,735 77,850 300,000 300,000 664.600 Mach /Equipment 0 0 0 0 0 Capital Outlay 0 100,000 77,850 54,735 77,850 0 300,000 300,000 Storm Water Utilities 130,138 223,650 223,703 124,699 214,844 55,550 423,400 417,850 Stormwater 130,138 223,650 223,703 124,699 214,844 55,550 423,400 417,850 Function: 581 Other Financing Sources and Us Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 591.101 Trsf to IBR 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 Other Financing Sources and Us 0 0 0 0 0 0 0 0 Function: 590 Other Nonoperating Dept: 950 Other Nonoperating Acct Class: 530 Operating Expenditures /Expense 559.300 Depreciation 96,362 0 0 0 0 559.301 Budgeted Depreciation (netted) 0 89,400 89,400 0 89,400 Operating Expenditures /Expense 96,362 89,400 89,400 0 89,400 0 0 0 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 96,362 89,400 89,400 0 89,400 0 0 0 Dept: 990 Other /Reserve /Contingency Acct Class: 590 Other Financing Sources & Uses 599.902 Reserves - Contingency 0 0 0 0 0 Other Financing Sources & Uses 0 0 0 0 0 0 0 0 Other /Reserve /Contingency 0 0 0 0 0 0 0 0 Other Nonoperating 96,362 89,400 89,400 0 89,400 0 0 0 Total Expenditures 226,500 318,050 318,103 124,699 309,244 55,550 428,400 422,850 BUDGET WORKSHEET DRAFT DRAFT DRAFT Page: 40 6/30/2010 Village of Tequesta 5:30 pm Prior --------- ---- -- Current Year -- (6) (7) (8) Year Original Amended Actual Thru Estimated Month: 6/30/2010 Actual Budget Budget June Total FINANCE EPARTMENTS MANAGER Stormwater Utility 88,703 0 0 183,285 -3,516 263,430 - 109,420 0 Grand Total: 179,837 0 0 1,217,802 - 1,076,100 1,514,690 - 807,025 0