HomeMy WebLinkAboutDocumentation_Workshop_Tab 01 _09/08/2006 � FINAL BUDGET EXPENDITURES Page: 1 9/7/2006 ,� Village of Tequesta 5:58 pm Prior Current Yr Current Next Year Budget Year Amended Year Adopted Percent Actual Budget Estimate Budget Change Fund; 001 - General Fund Expenditures Total General 0 0 0 0 0.00 Function: 410 General Govemment Total Council 39,530 68,500 64,550 53,500 -21.90 Total Manager 138,594 140,400 139,630 148,500 5.77 Total Human Resources 196,884 262,050 191,740 217,910 -16.84 Total Village Clerk 91,215 168,930 166,710 164,68� -2.52 Total Finance 290,218 373,600 352,860 384,700 2.97 Total Legal 194,544 190,000 229,000 170,000 -10.53 Total Planning 94,705 142,145 45,830 44,500 -68,69 Total General Government 264,888 247,893 237,160 313,668 26.64 Total General Govemment 1,310,577 1,593,318 1,427,480 1,497,458 -6.02 Function: 420 Public Safety Total Contractural Planning Services 0 0 0 0 0.�0 Total Police-Admin 388,999 484,581 467,940 489,690 1.05 Total Police-Communication 302,077 378,220 359,100 347,770 -8.05 Total Police-Compliance Inspection 0 0 0 0 0.00 Total Police-Investigative 98,044 108,127 105,730 109,080 0.88 Total Police-Patrol 1,480,007 1,666,900 1,450,870 1,699,930 1.98 Total Building & Zoning 225,729 331,545 418,580 384,130 15.86 Total Code Compliance 41,946 87,150 75,820 85,000 -2.47 Total Board of Adjustments 0 0 0 0 0.00 Total Planning and Zoning Board 0 0 0 0 0.00 Total Civil Preparation 11,972 13,486 12,470 72,340 436.41 Total Fire Control 1,546,774 1,810,941 1,776,260 1,927,330 6.43 Total Emergency Metlical Services 320,717 351,272 342,820 360,150 2.53 Total EMS-Transportation Services 17,356 29,612 23,660 41,970 41.73 Total Mosquito Control 0 0 0 0 0.00 Total Public Safety 4,433,621 5,261,834 5,033,250 5,517,390 4.86 Function; 431 Transportation Total Public Works 632,446 1,018,219 920,680 1,031,432 1.30 Total Hurricane Frances Costs 0 0 0 0 0.00 Total Transportation 632,446 1,018,219 920,680 1,031,432 1.30 � FINAL BUDGET EXPENDITURES Page: 2 9ni2006 � Villaqe of Tequesta 5:58 pm Prior Current Yr Current Ne� Year Budget � . Year Amended Year Adopted Percent Actual Budget Estimate Budget Change Fund: 001- General Fund Expenditures Function: 450 Leisure Services Total Parks 285,474 392,660 385,810 88,250 -77.53 Total Recreation Programfng 240,563 355,000 335,139 393,400 10.82 Total Leisure Services 526,037 747,660 720,949 481,650 -35.5$ Function: 518 Pension Benefits Total Pension 0 0 0 0 0.00 Total Pension Benefits 0 0 0 0 0.00 �unction: 572 Leisure Services Total Special Events 0 0 0 0 0.00 Total Leisure Services 0 0 0 0 0.00 Function: 581 Other Financing Sources and Us Total Interfund Transfers 2,711,800 1,469,550 1,469,553 385,914 -73.74 Total Other Financing Sources & Uses 152,999 0 0 0 0.00 Total Other Financing Sources and Us 2,864,799 1,469,550 1,469,553 385,914 -73.74 Function: 590 Other Nonoperating Totai Debt Service 450,919 494,400 480,620 528,310 6.86 Tota! Other Nonoperating 6,944 8,500 5,800 5,800 -31.76 Total Reserves 0 9,590 0 100,100 943.80 Total Other Nonoperating 457,863 512,490 486,420 634,210 23.75 Total Expenditures 10,225,343 10,603,071 10,058,332 9,548,054 -9.95 ' FINAI BUDGET EXPENDITURES Page: 3 9/7/2006 . Viilage of Tequesta 5:58 pm Prior Current Yr Current Next Year Budget Year Amended Year Adopted Percent Actual Budget Estimate Budget Change Fund: 101 - Improvement Bond Revenue Expenditures Total General 141,490 140,200 140,140 143,370 2.26 Function: 581 Other Financing Sources and Us Total Interfund Transfers 357,040 360,100 360,100 406,830 12.98 Total Other Financing Sources and Us 357,040 360,100 360,100 406,830 12.98 Total Expenditures 498,530 500,300 500,240 550,200 9.97 FINAL BUDGET EXPENDITURES Page: 4 smzoos - Village of Tequesta 5:58 pm Prior Current Yr Current Next Year Budget Year Amended Year Adopted Percent Actual Budget Estimate Budget Change Fund: 301 - Capilaf fmprovement Fund Expenditures Total Country Club Interior-Phase 1 0 0 0 0 0.00 Total Country Club Interior-Phase 2 0 0 0 0 0.00 Total Capital Improvement 0 0 0 0 0.00 Total Tequesta Penisula Project - 2 0 0 0 0 0.00 Function: 431 Transportation Total Pubiic Works 11,550 4,000 0 0 -100.00 Total Annual Paving Project A 0 0 0 0.00 Total Country Club Drive 0 0 0 0 0.00 Total Tequesta Drive 0 134,000 134,000 167,400 24.93 Total Seabrook Road South 0 0 0 0 0.00 Total Seabrook Road North 0 0 0 0 0.00 Total Cypress Drive South 0 0 0 36,000 0.00 Total Riverside Drive North 0 0 0 0 0.00 Total Rehab US 1/Old Dixie Overlay 0 0 0 0 0.00 Total Riverside Drive - South 0 0 0 0 0.00 Total CBDR - New Road (Main Street) 0 0 0 0 0.00 Total Tequesta Bridge Project 0 373,251 373,250 0 -100.00 Total Transportation 11,550 511,251 507,250 203,400 -60.22 Function: 450 Leisure Services Tota{ Parks 0 0 0 0 0.00 Total Constitution Park 0 25,225 25,230 30,000 18.93 Total Recreation Center 0 0 0 0 0.00 Total Tequesta Park 0 0 0 0 0.00 Total Misc Proj-General 0 0 0 0 0.00 Total Leisure Services 0 25,225 25,230 30,000 18,93 Function: 538 Stormwater Total Swale Construction 0 0 0 0 0.00 Total Stormwater 0 0 0 0 0.00 Function; 581 Other Financing Sources and Us Total Interfund Transfers 0 133,418 133,420 0 -100.00 Total Other Financing Sources and Us 0 133,418 133,420 0 -100.00 Function: 590 Other Nonoperating Total Other Nonoperating 0 0 0 0 0,00 FINAL BUDGET EXPENDITURES Page: 5 9/7/2006 _ Village of Tequesta 5:58 pm Prior Current Yr Current Next Year Budget Year Amended Year Adopted Percent Actual Budget Estimate Budget Change Fund: 301 - Capital Improvement Fund Expenditures Total Other Nonoperating 0 0 0 0 0.00 _ Total Expenditures 11,550 669,894 665,900 233,400 -65.16 FINAL BUDGET EXPENDITURES Page: 6 sm2oos . Village of Tequesta 5•58 pm Prior Current Yr Current Next Year Budget Year Amended Year Adopted Percent Actual Budget Estimate Budget Change '" Fund: 302 - Bond Construction Fund Expenditures Function: 450 Leisure Services Total Misc Proj-General 0 0 0 0 0.00 Total Leisure Services 0 0 0 0 0.00 Total Expenditures 0 0 0 0 0.00 FINAL BUDGET EXPENDITURES Page; 7 9!7l2006 _ Villaqe of Tequesta 5:58 pin Prior Current Yr Current Next Year Budget Year Amended Year Adopted Percent Actual Budget Estimate Budget Change Fund: 303 - Capital Projects Fund Expenditures Total General 0 0 0 0 0.00 Total Main Street- Phase II 0 0 0 0 0.00 Total CBDR - Retail Building 0 0 0 0 0.04 Total CBDR - Bridge Road 0 0 0 0 0.00 Total Vehicle Acquisitions 0 0 0 0 0.00 Function: 410 General Govemment Total CBDR - Municipal Center 152,712 3,058,803 2,403,595 730,210 -76.13 Toial Generai Government 152,712 3,058,803 2,403,595 730,210 -76.13 Function: 420 Public Safety Tofal Public Safety Facility 0 0 0 0 0.00 Total Public Safety 0 0 0 0 0.00 Function: 431 Transportation Total CBDR - New Road (Main Street) 0 0 0 0 0.00 Total Tequesta Bridge Project 0 0 0 0 0.00 Total Viilage-wide projects 13,875 176,490 175,000 175,000 -0.84 Total Transportation 13,875 176,490 175,000 175,000 -0.84 Function: 450 Leisure Services Total Constitution Park 395,538 358,176 358,180 0 -100.00 Total Recreation Center 0 0 0 0 0.00 Total Tequesta Park 0 0 0 130,000 0.00 Total Misc Proj-General 48,176 736,184 726,184 20,000 -9728 Total Leisure Services 443,715 1,094,360 1,084,364 150,000 -86.29 Function: 581 Other Financing Sources and Us Total Interfund Transfers 0 0 0 0 0.00 � Total Other Financing Sources and Us 0 0 0 0 0.00 Function: 590 Other Nonoperating Total Other Nonoperating 0 0 0 0 0.00 Total Other Nonoperating 0 0 0 0 0.00 Total Expenditures 610,302 4,329,653 3,662,959 1,055,210 -75.63 FINAL BUDGET EXPENDITURES Page: 8 9/7/2006 � Village of Tequesta 5:58 pm Prior Current Yr CuRent Next Year Budget Year Amended Year Adopted Percent Actual Budget Estimate Budget Change Fund: 401 - Water Fund Expenditures Total General 0 0 0 0 0.00 Total CBDR - Bridge Road 0 0 0 0 0.00 Total Renewal & Replacement 133,038 289,025 261,280 172,200 -40.42 Total Capital Improvement 28,000 1,500 0 20,000 1,233.33 Total RO Bond Project 0 0 0 0 0.00 Total Capital Expansion Projects 0 3,873,688 1,708,720 2,810,000 -27.46 Total Tequesta Penisuia Project -1 0 0 0 0 0.00 Total Tequesta Penisula Project - 2 0 0 0 0 0.00 Total Teq/Jup - U.S. 1 Crossing 0 0 0 0 0.00 Total Misc Proj-Enterprise 0 18,493 14,900 60,000 224.45 Function: 431 Transportation Total CBDR - New Road (Main Street) 0 0 0 0 0.00 Total Transportation 0 0 0 0 0,00 Function: 533 Water Utility Services Total Water-Administration 563,431 536,523 516,740 530,360 -1.15 Total Water-Pumping & Storage 1,612,886 1,641,947 1,712,620 1,628,700 -0.81 Total Wafer-Distribution 559,840 597,210 � 585,290 671,160 12.38 Total Water Utility Services 2,736,156 2,775,680 2,814,650 2,830,220 1.96 Function: 538 Stormwater Total Storm Water Utilities 0 0 0 0 0.00 Total Stormwater 0 0 0 0 0.00 Function: 581 Other Financing Sources and Us Total Interfund Transfers 0 0 0 0 0.00 Total Other Financing Sources and Us 0 0 0 0 0.00 Function: 590 Other Nonoperating Total Debt Seroice 36$,576 569,000 601,730 571,450 0.43 Total Other Nonoperating 760,261 5,800 5,800 5,800 0.00 Total Reserves 0 16,615 0 2,500 -84.95 Total Other Nonoperating 1,128,838 591,415 607,530 579,750 -1.97 Total Expenditures 4,026,031 7,549,801 5,407,080 6,472,170 -1427 FINAL BUDGET EXPENDITURES Page: 9 9/7/2006 - Village of Tequesta 5:58 pm Prior Current Yr Current Next Year Budget Year Amended Year Adopted Percent Actual Budget Estimate Budget Change Fund: 402 - Refuse & Recycling Expenditures Function: 534 Refuse & Recycling Total Refuse and Recycling 260,714 276,400 271,420 284,300 2.86 Total Refuse & Recycling 260,714 276,400 271,420 284,300 2.86 Function: 538 Stormwater Total Storm Water Utilities 0 0 0 0 0.00 Tofal Stormwater 0 0 0 0 0.00 Function: 590 Other Nonoperating Total Other Nonoperating 0 0 0 0 0.00 Total Other Nonoperating 0 0 0 0 0.00 Total Expenditures 260,714 276,400 271,420 284,300 2.86 FINAL BUDGET EXPENDITURES Page: 10 9/7/2006 � Village of 7equesta 5:58 pm Prior Current Yr Current Next Year Budget Year Amended Year Adopted Percent Actual Budget Estimate Budget Change Fund: 403 - Stormwater Utility Expenditures Total Bridge Road- do not use 0 0 0 0 0.00 Total Swale Construction 0 0 0 0 0.00 Total Dover Ditch 0 0 0 0 0.00 Total Tequesta Penisula Project -1 0 0 0 0 0.00 Totai Tequesta Penisula Project - 2 4 0 0 0 0.00 Total Misc F�roj-Enterprise Q 130,000 0 0 -100.00 Function: 431 Transpor�atis�n � Total Fairview Drive 0 0 0 0 0.00 Total Country Club Drive 0 0 0 0 0.00 Total Tequesta Drive 0 0 0 0 0.00 Total Seabrook Road South 0 0 0 0 0.00 Total Seabrook Road North d 0 0 0 0.00 Total Cypress Drive South 0 280,000 31,250 525,000 87.50 Total Cyrpess Drive - North 0 2'.,014 ��,OOi, 0 -100.3� Total Golfview Drive 0 0 0 0 0.00 Total CBDR - New Road (Main Street) 0 0 0 0 0.00 Total Waterway Road 0 0 0 0 0.00 Total Transportation 0 301,014 52,250 525,000 74.41 Function: 533 Water Utility Services Total Water-Distribution 0 0 0 0 0.00 Total Water Utility Services 0 0 0 0 0.00 Function: 538 Stormwater Total Storm Water Utilities 78,095 248,830 188,090 140,184 -43.66 Total Stormwater 78,095 248,830 188,090 140,184 -43,66 Function: 581 Other Financing Sources and Us Total Interfund Transfers 60,300 60,300 60,300 60,300 0.00 Total Other Financing Sources and Us 60,300 60,300 60,300 60,300 0.00 Function: 590 Other Nonoperating Total Other Nonoperating 64,694 0 0 0 0.00 Tota1 Reserves 0 0 0 0 0.00 Total Other Nonoperating 64,694 0 0 0 0,00 Total Expenditures 203,088 740,144 300,640 725,484 -1.98 . . . - � . Memo To: JoAnn Forsythe From: Michelle Gload Date: 9/8/06 Re: Fiscal Year 2007 Updated Budget Worksheet Please find attached an updated copy of the budget worksheet. Items of Interest: 1. General Fund — Total budeet chanee ($300,000.001 as detailed below. a. Revenues i. Department 180 — Building & Zoning: The estimated building permit fees were reduced by $300,000.00. Account Account Previously Updated Number Name Proposed Proposed Chanqe 322.000 Building Permit Fees 500,000.00 200,000.00 (300,000.00) Tota4: (300,000.00) Total Revenue Change: (300,000.00) b. Expenditures i. Department - Various: The health insurance projected increase has decreased by 5.4% and the dental insurance projected increase has decreased by 7%. Account Account Previously Updated Number Name Proposed Proposed Chan e N/A Personal Services 5,914,350.00 5,877,950.00 (36,400.00) Total: (36,400.00) ii. Department - Various: The total of the merit and the COLA increases for the CWA Union employees increased by 1.6%. Account Account Previously Updated Number Name Proposed Proposed Chanae N/A Personal Services 5,877,950.00 5,893,850.00 15,900.00 Total: 15,900.00 iii. Department 210 — Public Works: Ron Smith's personal expenses have been added, the General Maintenance account was increased $86,692.Q0 and the requested truck purchase has 6een withdrawn. Account Account Previously Updated Number Name Proposed Proposed Chans�e N/A Personl Services 221,700.00 297,800.00 76,100.00 546.306 General Maint. 12,000.00 98,692.00 86,692.00 664.602 Vehicles 29,000.00 0.00 (29,000.00) Total: 133,792.00 iv. Department 230 — Parks: Ron Smith's salary has been moved to The Public Works Department, the General Maintenance account was decreased $101,692.00 and the requested lawnmower purchase has been withdrawn. Account Account Previously Updated Number Pfame Pronosed Proposed Chanqe N/A Personl Services 102,200.00 26,100.00 (76,100.00) 546.306 General Maint. 101,692.00 0.00 (101,692.00) 664.600 Mach. & Equipment 6,000.00 0.00 (6,000.00) Total: (183,792.00) v. Department 900 — Interfund Transfers: The interfund transfer to the Capital Lnprovement Fund has been decresed $257,600.00. Account Account Previously Updated Number Name Proposed Prouosed Chan e 591.301 Transfer to Cap. Imp. 455,000.00 197,400.00 (257,600.00) Total: (257,600.00) vi. Department 990 — Reserves: The contingency account has been increased by $28,100.00. Account Account Previously Updated Number Name Proposed Proposed Chan e 599.902 Contingency 72,000.00 100,100.00 28,100.00 Total: 28,100.00 Total Expenditure Change: (300,000.00) 2. Canital Improvement Fund - Total budeet chanee ($257,600.00) as detailed below. a. Revenues i. Department 900 — Interfund Transfers: The interfund transfer from the General Fund has been decreased $257,600.00. Account Account Previously Updated Number Name Proposed Proposed Chan e 381.001 Trnsfr from Gen. Fund 455,000.00 197,400.00 (257,600.00) Total: (257,600.00) Total Revenue Change: (257,600.00) b. Expenditures i. Department 315 — Tequesta Drive: The Tequesta Drive contingency account has been decreased $257,600.00. Account Account Previously Updated Number Name Proposed Proposed Chan e 700 Contingency 425,000.00 167,400.00 (257,600.00) Total: (257,600.00) 7otal Expenditure Change: (257,600.00) 3. Water Fund - Total budeet chan¢e $0.00 as detailed below. a. Expenditures i. Department - Various: The health insurance projected increase has decreased by 5.4% and the dental insurance projected increase has decreased by 7%. Account Account Previously Updated Number Name Proposed Proposed Chan e N/A Personal Services 1,131,300.00 1,124,600.00 (6,700.00) TotaL• (6,700.00) ii. Department - Various: The total of the merit and the COLA increases for the CWA Union employees increased by 1.6%. Account Account Previously Updated Number Name Proposed Proposed Chan e N/A Personal Services 1,124,600.00 1,128,800.00 4,200.00 Total: 4,200.00 iii. Department 990 — Reserves: The contingency account has been increased by $2,SQ0.00. Account Account Previously Updated Number Name Proposed Proposed Chanqe 599.902 Contingency 0.00 2,500.00 2,500.00 Total: 2,500.00 Total Expenditure Change: 0.00 4. Storm Water Fund -Total bud�et chanee $0.00 as detaifed below. a. Expenditures i. Department 250 — Storm Water Utilities: The health insurance projected increase has decreased by 5.4% and the dental insurance projected increase has decreased by 7%. Account Account Previousiy Updated Number Name Proposed Proposed Chanqe N/A Personal Services 43,800.00 43,500.00 (300.00) Total: (300.00) ii. Department 250 — Storm Water Utilities: The total of the merit and the COLA increases for the CWA Union employees increased by 1.6%. Account Account Previously Updated Number Name Proposed Proposed Chanqe N/A Personal Services 43,500.00 43,900.00 400.00 Total: 400.00 iii. Department 250 — Storm Water Utilities: The Drainage Maintenance account has been decreased $100.00. Account Account Previously Updated Number Name Proaosed Proposed Chanpe 546.308 Drainage Maint. 40,000.00 39,900.00 (100.00) Total: (100.00} Total Expenditure Change: 0.00 BUDGET SUMMARY VILLAC3E OF TEQUESTA - FISCAL YEAR 2006 - 2007 General Fund 6.4980 General Special Capital Water Refuse & Stormwater ESTIMATED REVENUES Fund Revenue ProjecLs Utility Recycling Utilily Total Taxes: Millage Per $1000 AdValoremTaxes 6.4980 6,061,684 6,061,684 Sales and Use Taxes 1,058.300 1,058,300 Franchise Fees 348,000 348,000 licenses and PermiLs . 233,000 131,000 364,000 Inlergovernmenial Revenues 618,190 618,190 Chargesfor5ervices 616,390 4,002,100 278,000 298,600 5,195,090 Miscellaneous Revenues 280,510 10,900 89,100 6,300 300 387,110 fnVagovemmenlal Services 273,150 273,150 Grants and Contributions 0 312,500 430,000 742,500 TOTALSOURCES $9,141,224 $489,900 $312,500 $4,521,200 $284,300 $298,900 $15,048,024 Transfers fn $406,830 $60,300 $385,914 $0 $853,044 FundBalanceslReserves/NetAssets $0 $590,196 $1,950,970 $14,100 $426,584 $2,981,850 TOTAL REVENUES, TRANSFERS & � BALANCES $9,548,054 $550,200 $1,288,610 $6,472,170 $298,400 $725,484 $18,882,918 EXPENDITURES General Government Services 1,497,458 730,210 2,227,668 Public Safery 5,517,390 5,517,390 Physical Environment 5,892,420 284,300 665,184 6,841,904 Transportation 1,031,432 398,400 1,429,832 Leisure Services 481,650 160,000 641,650 Debt Service 528,310 143,370 571,450 1,243,130 Other Financing lkes 5,800 8,300 14,100 TOTALEXPENDITURES $9,062,040 $143,370 51,288,610 56,472,170 $254,300 $665,184 $17,915,674 Transfers Out $385,914 $406,830 SO $60,300 $853,044 Fund Balances�Reserves�NetAssels $100,100 TOTAL APPROPRIATED EXPENDITURES TRANSFERS,RESERVES & BALANCES $9,548,054 $550,200 $1,288,610 $6,472,170 $284,300 $725,484 $18,868,818 i General Fund Revenues Budget Year 2006 I 2007 ❑Ad Valorem Taxes i 63.49% � � ❑ Miscellaneous i � I 2.94% � � � OtherTaxes ❑ Interfund Transfers 11.08% 426% I ■ Intergovernmental � ■ Licenses & Permits 6.47% 2.44% � ❑ Intragovernmental ■ Charges for Services i 2.86% 6.46% General Fund Expenditures , Budget Year 2006 / 2007 ■ Public Safety 57.79% i i - F' ■ Leisure Services ❑ Other 5.04% 0.06% � O General Government 15.68% i 0 Public Works 10.80% ❑ Fund Balance/Reserves J 1.05% ❑DebtService �Transfers-Out 5.53% 4.04% I i