Loading...
HomeMy WebLinkAboutDocumentation_Workshop_Tab 03_06/23/2014 BUDGET WORKSHEET Page: 25 6/20I2014 Village of Tequesta 2: � � Pria' Current Year (6) (7) (8} Y�r Original Am�dad Acbual Thru Estimated Monlh:6/30/2014 Adual Budget Budget June Totai DEPARTMENT MANAGER COUNCIL Fund 401- Water Fund Expendilures Dept 241 Water-AdminisVation Acct Ciass: 510 Personal Services 512.100 Regular Salaries � Wages 139,413 139,700 139,700 98,283 139,500 162,300 515.103 BanusPayPlan a 0 3,150 3,150 3,150 515.108 Auto Allowance 3,000 3,000 3,000 2,250 3,000 3,000 r~- 515.t25 OlherAtlawances 1,200 1,200 1,200 900 1,200 1,200 516.100 Compensa6ed Absencc�s 1,753 5,000 5,818 4,6i3 8,600 13,500 516.105 Compensated Absences - HSA 3,430 0 0 0 0 521.101 fICATaxes 7,093 7,300 7,438 5,331 7,4� 8,700 521.102 MadicareTaxes 2,273 2.200 2,359 1,607 2.350 2,600 522.102 VOT Pension Contributions 13,d76 12,900 12,906 9.022 12,800 13,700 523.101 Life/Healtl�lnsurance 10,316 12,600 12,600 9,408 12,550 12,200 ~- 523.105 HSA-HealthSevingsAccount 1,400 0 0 0 0 524.100 Workers' Comp Insurance 411 310 310 231 310 310 526.104 ICMA-Def Comp Plan 9,826 9,900 9,900 6,927 9,830 10,300 554.301 Personnel Training 0 0 750 750 750 Personal Services 193,191 194,110 199,125 142,472 201,440 227,810 0 0 Acct Class: 530 Operating ExpendihireslExpense 531.301 Legal Services 1,235 7,500 6,250 1,549 2,000 2,000 531.302 Engina�ing Services 19,478 25,000 101,500 36,50d 101,500 30,000 532.300 Aa:oundng & Audibng Services 27,800 28,100 27,750 27,750 27,750 28,624 534.300 Olher Conh�acluai Services 21,850 24,OQ0 24,500 13,320 29 21,000 544.304 FEC Lease 12,357 13,050 12,535 12,531 12,535 13,000 545.3001nsurance 46,770 47,600 47,600 37,616 48,050 48,050 549.301 Admin Wk�mtFeas 485,229 499,785 499,785 333,790 499,785 514,750 549.304 Licenses, Fees � Pertnits 78t 806 800 781 781 800 Opereting ExpendituraslExpense 615,500 645,835 720,720 463,241 721,401 658,250 0 0 Acct Class: 590 Otl�er Finat�ci►g Sources 8 Uses 599.100 Budget Cost Savirgs 0 3,400 0 0 0 Other Financin� Sources & Uses 0 3,400 0 0 0 0 0 0 Water-Administra6on 808,691 843,345 919.845 605,713 922,841 886,p60 p 0 Dept 242 Water- Praduction Acct Class: 510 Personal Servic�s 512.100 Regular Salaries & Wages 37U,269 397,000 361,000 271,811 383,900 399,600 514.100 Ovefime 8,154 8,000 9,00p 4,038 9,000 9,000 BUD�ET WORKSHE�T Page: 26 6120/2014 Yliage oi Tequesta 2:58 pm Prior CurceMYear - �6) (7) �g) Y�r Original Amended Acbual Thru Es6mated Month:613012014 Adual Budget Budget June 7otal DEPARTMENT MANAGER CAUNCiI Fund: 401 - Water Fund Expenditures Dept 242 Water - Production Aat Class: 51Q Personal Services 515.102 Standby Pay 5,119 6,000 6,Q00 3,510 6,000 6,000 5t5.1Q3 8onus Pay Plan 0 0 3,000 3,000 3,000 515.106 Cloihing 8 Boot Allowanoe 600 600 600 600 500 fi00 516.100 Canpensated Absences 1,288 5,000 5,000 2,622 5,000 5,000 516.105 Compensated Absences • HSA 0 0 0 0 0 521.101 FICA Taxes 23,487 25,400 25,400 16,T47 25,400 25,400 527.102 Medic�e Taxes 5,493 6,000 6,000 3,916 6,000 6,000 522.10t FRS Contributions 3,950 3,900 5,000 3,334 5,000 5,300 522.102 VOTPensionCoMributiais 27,918 29,800 29,800 2Q,197 28,715 27,200 523.101 LifeMe�thlnsurance 51,743 63,200 78,500 57,521 78,500 61,200 523.105 HSA - Fl�alth Savings qc�count 1,700 0 0 0 Q 523.110 Re6ree Healtl� Care E�cpense 0 0 0 0 0 524.100 Workers' Comp Insurance 11,270 12,$70 12,870 9,649 12,870 12,870 554.301 Persannel Trainin9 395 1,500 1,500 874 1,Sa0 2,000 Personal Services 511,386 559,270 569,6T0 397,819 565,485 560,170 0 0 Acct Class: 530 Operatir�g FacpendituresJExpense 531.342 Wa�r Malysis & Sampling 33,422 48,530 48,530 18,877 40,000 44,000 540.300 Travel & Per Diem 264 3,000 3,000 1,732 2,5Q0 3,500 541.300 Canmunica6on 5ervices 8,311 9,400 9,400 6,197 9,400 9,400 541.301 Postage 836 1,500 1,500 1,157 1,500 2,500 543.300 Utility Servit:es 325,275 394,000 346,930 183,418 308,000 385,000 544.301 Operating Leases 10,240 9,400 10,800 8,390 10,600 10,000 546.302 Vehide Repar & Meintenance 4,295 3,000 5,000 3,994 4,Q00 3,000 546.303 Building Repair & Maint 14,582 28,500 28,500 5,523 25,000 2Q,000 546.309 Landscape 8 trtigetion Maint 4,632 3,000 19,000 17,503 18,000 3,000 546.310 Ecp�ipment Repair & Maint 14,054 28,000 73.490 22,086 73,490 20,000 546.320 Computer system maint & suppli 2,888 8,400 8,400 2,821 8,400 16,700 546.342 Water S�rst�n Maintenance 11 t,718 70,000 90,965 36,614 70,000 120,000 546.343 Wep Redev�opment 29,785 30,000 49,000 12,998 49,000 80,000 547.300 Prin6ng 8 Bin�ng 1,891 2,500 2,500 1,254 2,500 3,000 549.300 Olher NGsc Chgs & Obligations 5,858 2,000 2,OOd 1,652 2,000 2,000 549.304 Licenses, Fees & PermiGg 22,534 30,000 30,000 21,034 30,000 30,000 551.300 Ofirc:e Supplies � Equipment 3,153 2,500 2,500 1,320 2,000 2,500 552.301 Gas & Oil 5,550 8,100 8,100 2,845 5,000 8,100 552.302 Small Tools and Equipment 1,615 3,000 3,000 908 2,500 3,OU0 552.303 Diesel Fuel 7,430 15,000 15,000 0 4,U00 15,000 BUDGFlWQRKSHEET Page: 27 ' 6/20I2014 iftllage of Tequesta 2:58 pm Pria' CurrentYeer fg) �7) (g) Year Originai Amended Aclual Thru Estimated Month:613012014 Adual Buciget Budget June T�al DEPARTMENT MANAGER COUNCII Fund: 401-Water Fund Expenditures Dept 242 Water - Produc6on Acct Gass: 530 Operating ExpenditureslExpense 552.305 Uniforms 1,494 1,500 2,500 2,123 2,500 2.500 552.341 Water Purcheses 0 30,000 30,000 0 0 30,000 552•342 Wa�erChemicals 133,731 188,000 176,100 95,341 160,000 197,400 552.343 Laboratary Supplies 45,891 14,000 14,000 9,952 14,000 14,000 554,300 Books, PuW, Subs & Membership 1,552 1,600 1,600 878 1,500 1,600 Uperating Expenditures/Expense 762,001 934,930 981,815 458,617 845,890 1,026,200 0 0 Acct Ciass: 590 Otl� Finanang Sources & Uses 599.100 Budget Cost Savings 0 3,230 0 0 0 Oiher Finandng Sources 8 Us� 0 3,230 0 0 0 0 0 0 Water- Produetion 1,2T3,387 1,497,430 1,551,485 656,436 1,411,375 1,586,370 0 0 Dept 243 We6ar-Distribution Acct Class: 510 Personai Services 512.100 RegWar Salaries 8� Wages 368,Q02 387,800 387,800 273,247 388,000 386,b00 514.106 Overlime 3,769 5,000 5,000 2,452 5,000 . 5,000 515.102 Standby Pey 9,212 8,500 9.850 7,265 9,850 10,000 515.103 Bonus Pay Plan 0 0 3,000 3,000 3,000 515.106 ClothingBBootAllowance 600 500 500 500 500 5pp 515.107 Part�imeSalaries 4t,111 0 0 0 0 515.108 AutoAllowance 2,400 0 0 0 0 516.100 Compensated Abs�ces 19,412 5,000 5,000 2,094 5,000 5,000 516.105 Compensated Absenoes - HSA 0 0 0 0 0 521.101 FICATaxes 26,751 24,300 24,300 16,789 24,300 24,500 521.102 Madicare Ta�ces 6,256 5,700 5,700 3,926 5,700 5,800 522.101 FRS Contributions T,889 8,200 10,000 6,95b 10,000 10,700 522.102 VOTPensionContributions 21,950 23,100 23,100 16,194 23,005 2p,700 523.101 LifeJHealth Insurence 72,987 94,100 91,180 67,142 94,950 60,300 523.105 H5A - HeaHh Savings Account 2,700 0 0 0 0 523.110 Retiree Heallh Care Expense 0 0 0 0 0 524.100 Workers' Comp Insurance iQ917 9,090 9,09Q 6,815 9,090 9,090 525.100 Unereployment Compensation 0 0 0 0 0 554.301 PersonnelT�aining 125 1,500 1,500 260 710 1,500 Personal Services 594,Q81 572,790 576,020 406,638 579,105 539,590 0 p Acct Class: 530 OPe►'atin9 ExpenditureslExpense 540.300 Trave! 8 Per Dism 152 500 500 92 500 500 541.300 Canmunicetion Services 6,OOU 7,700 7,700 3,455 6,000 6,000 541.301 Posiage 22,797 23,�0 23,000 10,910 23.000 23.000 544.301 Op�ating Leases 2,788 4,500 4,500 2,092 3,121 3.200 BUDGETWORKSHEEf P�e: 28 �Ilage of Tequesta 6/2012014 2:58 pm Pria ^____ � Current Year -- - (g) (7� (g) Year Original Amended Acival Thru Estimaded Mon1h:613Q12014 Aqual Budget Budget June Total DEPARTMENT MANAGER COUNCIL Fund: 401- Water Fund Expend�ures f�ept 243 Water-Distrihution Acct Gass: 530 Operating ExpenditureslEupense 546.301 Qffice EquiplRepair & Maint 679 1,200 1,200 24S 900 1,200 546.3Q2 Vehide Repeir � Maintenence 5.210 7,000 7,000 6,684 7,300 6,506 546.303 Build'e� Repair & MaiM 2,435 5,OOd 5,000 905 5,OU0 5,000 546.309 Landsc�e � Irrigatiai Mamt 239 900 900 859 900 900 546.310 Equipment Repair & Maint 5,416 5,000 5,000 3,031 5,000 5,000 546.320 Comput� system maint 8�ppli 7,588 6,900 6,900 5,245 6,900 14,200 546.342 Water Systern Maintenance 19,302 25,U00 25,000 16,883 25,000 35.000 547.300 Prir�ting 8 Bin�ing 2,642 3,000 3,000 2,123 3,OOQ 3,000 549.30Q OH�r A�isc Chgs � Obligations 4,356 2,500 2,500 818 2,500 2,500 �~- 549.304 Licenses, Fees & Permib 1,607 1 1,700 1.207 1,700 1,700 551.300 0lfice Supplies 8 Equipment 1,500 1,500 1,500 332 1,5d0 1,500 552.301 Gas & Oil 14,315 14,000 14,000 9,197 14,000 14,000 552.302 SmaN Tools and Equipment 1,094 4,000 4,OW 1,841 4,000 4,000 552.305 Uniforms 1,453 2,000 2,000 1,564 2,000 2,000 Operating Expen�tureslExpensQ 99.573 115,400 115,400 67,478 112,321 127,200 0 0 Acct Class: 590 Other Fnancing Sources 8 Uses 599.100 Budget Cost Savings 0 3,230 0 0 0 Other Finanang Sources & Uses 0 3,230 0 0 0 0 0 0 Water•DisUibution &93,654 691,420 691,420 474,116 691,426 666,790 0 0 Dept 411 Renewal 8 Replacement Acxt Ciass: 530 Opera6ng ExpenditureslExpense 546.605 R&M - Weil 5ite Rehab 2,550 4,000 4,000 1,790 2,500 4,000 549.671 Msc. Renewal & Repiacement 116,017 60,000 787,951 75,048 787,000 285,000 552.601 Mehxs, Valves � Hydranis 30,289 30,000 37,455 20,921 37,455 60,000 552.603 FilterCartridgeslROP 3,Q30 7,000 7,000 0 5,000 7,000 �p��9 �P��+�xPe�e 151,886 101,000 836,406 97,759 831,955 356,000 Q p Acct Cless: 600 Capital Outlay 663.671 Msc. Renewel and Repla�ment 0 0 0 0 0 664.600 MachlEquipm�tt 0 0 0 0 0 25,000 664.601 Computer Equipment 0 1,500 1,500 0 1.500 664.602 Vehides 0 33,500 36,500 36,496 36,500 136,000 �P� �tieY 0 35,000 38,000 36,496 38,000 161,000 0 0 Renewal & Replac�ment 151,886 136,000 87A,406 134,255 869,955 517,000 0 0 Dept 412 Cepital Improvement Aat qass: 600 Cepital Outlay 664.600 MadUEquipment 0 68,000 57,000 2,330 52,510 CaPite� Outle9 0 68,000 57,000 2,330 52,510 0 0 0 BUD(iET WdRKSHEET Page: 29 6J20/2014 Yll�e of Tequesta 2:58 pm Prior Current Year - is) f� i8) Year Original Amended Actual ThN Es4mated lu�ntl�:6l30I2014 Adual Budget Budget June Total DEPARTMEIdT MANAGER COUNCIL Fund: 401 - Water Fund E�diGrcas Capitallmprovertient 0 68,000 57,000 2,330 52,510 0 0 0 Dept 700 Debt Service Aa3 Gass: 471 D/S - Prir�cipel 571.705 Prin - 2004 Water N/P BOA 0 30,000 30,000 30,000 3Q000 32,000 571.720 Prin - 2008 Water Utiliiy Note 0 277,900 277,900 207,418 277,900 287,890 D/S - Principal 0 307.900 307.900 237,418 307.900 319,890 0 0 Na;t qess: 472 D/S - Interest 572.7051nt-2004WeterNlPBOA 14,887 14,100 14,100 8,2A8 14,100 12,600 572.720 int- 2008 Water Utility Nota 201,533 192,200 t92.200 128.526 192,200 191,310 573.700 Otl�er D�t Servioe Costs 46,676 25,000 25,000 0 23,000 23,000 D/S - Interest 263,096 231,300 231,300 136,734 229,300 226,910 0 0 DebtService 263,096 539,20Q 539,200 374,152 537,200 54g,gpp 0 0 Dapt 910 Ofher Financing Sourc.es & Uses Acct Ctass: 590 Other Fnancing Sources & Uses 567.000 GaiNLoss on Invesbments 0 0 0 0 0 567.100 Unreaized Loss an Inveshnents 0 0 0 0 0 Other Finanang Sources 8 Uses 0 0 0 0 0 0 0 p Other Finandng Sour�s & Uses 0 0 0 0 0 0 0 0 Dept 950 Other NonoperaGng Acct Class: 530 Opera6ng Expenditures/Expense 559.300 Depreaafion 1,000,083 0 0 0 0 559.301 Budgeted Depreaation (nefled) 0 605,320 605,320 0 0 Opereting ExpendidireslEupense 1,000,083 6Q5,320 605,320 0 0 0 0 0 Acct Class: 590 Other Financing Sourc�s 8 t�es 549.391 Bank Charges 10,038 10,400 10,000 6,799 10,000 10,000 549.395 Credit Card Fees and Charges 4,118 4,500 4,500 4,114 5.500 6,500 590.001 Alloc�6a io Fund Balance 0 12,885 0 0 0 999.001 Suspense 0 0 0 0 0 999.200 Susper�se-A!P 0 0 0 0 0 Other Financiqq Sources & Uses 14,156 27,385 14,500 10,913 15,500 16,500 0 0 Other Nonoperating 1,014,239 632,705 619,820 10,913 15,500 16,500 0 0 Dept 990 OlhedReaenre/CoM+ng�cy Acct Cl�s: 590 Other Finandng Sourc�s 8 Uses 599.9Q2 Reserves - Cantingency 0 0 0 0 0 Other Fnencing Sourc� 8 U�s 0 0 0 0 0 0 D 0 ���eS����s��r a o 0 0 0 0 0 0 Total Expendibures 4,204,953 4,408,100 5,253,176 2,457,915 4,500,807 4,219,520 0 0 WaterFund -130,637 0 0 517,564 �3,708,676 -4,210,02U 0 D BI}DGET WORKSHEET Page: 32 6J2012014 Yllage af Tequesta 2: � � Prior -- Current Year �6J �7) �g) Year Original Amended qctual Thru Estimatad Month:6/3Q/2014 Actual Budg� Budget June Total DEPARTMENT MANAGER COUNCIL �und: 403 - Stormwater Utili#y Expenditures Dep� 241 Water-Administration Aa�t Ctass: 51Q Personal Services 515,103 Bonus Pay Plan 0 0 0 0 0 Personal Senrices 0 0 0 0 0 0 0 0 Water-Administra6on 0 4 0 Q 0 0 0 0 Depr 243 Water-Distribution Acct Class: 59U PersQnal Services 515.1U3 Bonus Pay Plan � 0 0 0 0 —._.__ ' Personai Services 0 0 0 � 0 0 0 0 p Water-Distribution p p � � � d � � D�t Z50 Storm Water U61i6es Aoct Class: 510 Persona! Servioes 512.90� RegularSalaries & Wages 43,818 60,50Q 60,500 42,352 59,982 69,200 514.100 Overtime 509 1,000 1,000 412 1,OQ0 1,000 515.142 Standby Pay 9,689 1,440 2,300 1,329 2,300 2,040 `— 515.903 8onus Pay Plan � Q 1,500 1,500 1,500 �— 515.106 Clothing � BootAf(owance t00 150 150 150 150 150 515.908 AutoAllowance 750 900 1,800 1,350 1,800 1,800 �_� BUDGET WORKSFfEET Pa�: 33 6/20/2014 V�age oF Tequesta 2:58 pm Priar CurrentYear (61 p) (8) Year Original Amended Adual Thru Estimated Monlh:6f3012014 Adual Budget Budget June T�al DEPARI'MEN3 MANAGER COUNCIL Fund: 403 - Stortnwater Ut�ty E�ndiGues Dept 250 S�orm Water UHfies Hcxt qass: 510 Persaial Services 516.100 Canpensated Absences 566 0 0 0 0 516.105 Canper�sated Absences - HSA 0 0 0 Q 0 521.101 FiCA Taxes 2,407 3,500 3,728 2,607 3,700 3,80Q 521.102 Medcare Taues 563 900 919 610 919 900 52Z.102 VOT Pension Contri6utions 4,120 S,6Q0 5,600 3,728 5,505 5,000 523.101 LifeMealth Insurance 16,720 24,4Q0 22,373 14,557 T7,430 10,800 523.105 HSA - HeaRh Savirgs Acwunt 850 0 0 0 0 524.100 Worksrs' Camp Insurence 1,094 2,800 2,800 2,099 2,800 2,800 554.301 Personnel Ttaining 0 0 0 D 0 Personal Services 73.280 101,150 102,fi70 70,694 97,066 89,450 0 0 Acct Gass: 530 Operatin9 ExP�d�ureslE�ense 53�•302 En9i�ri�9 Services 6,042 8,000 9,300 10,158 11,545 532.3U0 Accounfing &Audi6ng Services 3,892 4,000 4,000 3,885 3,885 4,010 540.3U0 Travel 8� Per Diem 0 0 0 0 0 541.300 Communication Servic�s 1,680 1,900 1,�0 1,1U9 1,800 4,900 541.301 Postage 0 300 300 0 300 300 546.302 Vehide Repair & Maintenance 701 5p0 1,500 222 1,Spp 2,ppp 546.303 Building Repair & Maint 1,806 2,000 1,000 199 1,000 2,000 . 546.308 Drainage Maintenance 12,294 25,000 24,000 10,392 24,000 25.000 546.310 Equipment Repair & Maird 1,356 1,500 1,500 1,446 1,500 2,500 546.32Q Computer sys�em maint & suppli 293 800 800 272 800 1,200 549.300 Other Misc Chgs 8 Obligatiau 145 1.000 1.000 240 1,000 1.000 549.301 Admin Mgmt Feas 11,630 11.920 12,020 7,985 11,97$ 12,340 549.304 Licenses, Feas & Pertnits 4,109 4,500 4,500 4,099 4,100 4,500 551.3U0 Otfice Supplies � Equipmertt 117 300 300 0 300 300 552.301 Gas & Oil 2,33? 3,000 2.70Q 4,400 2,�0 2,700 552.302 Small Tools and EquipmeM 1,822 1,200 1,200 487 1,200 7,500 554.100 Public Educatiai Pmgram 0 500 500 0 500 250 OperaSng Expencktures/Expense 48,218 66,420 66,520 41,894 67,408 67,500 0 0 Acct Class: 590 Other Finanang Sources g Uses 599.100 Budget Cost Savings 0 1,620 0 0 0 Other Financing Sources & Uses 0 1,620 0 0 0 0 0 0 Aak Class: 600 Capital Outlay 662.632 Archited & Ergeerir�g 0 0 0 0 0 25,000 663.663 Drainage Improvements 0 0 0 0 0 250,000 664.602 VehiGes 0 30,000 30,000 21,797 30,000 �_ Cap'� Outlay 0 30,000 30,OOQ 21,797 30,000 275,000 0 0 ' BUDGET WORKSHEET Page: 34 V11age � Tequesta 6/20l2014 2:56 pm �' Curr�tt Y� Ig) m �8 Year Original Amended AcWal firu Estimated Ma�1h:6C30@014 l�k�ual Budget Budget June total DEPAR7MENT MANAGER COUNCIL Fund: 4Q3 - Stamw�er Utility Ex�didres Storm WaEerUtilibes 121,49$ 199,190 199,190 134,385 994,474 431,950 0 0 Dept 910 Olh� Fnanang Souroes & Use, Acd Class: 590 Othe�' Finanang Sources & Uses 5&7.100 Un�alized Loss on In�stments 0 0 0 0 0 0�' Finanpn9 Sou�es � �se.s 0 0 0 0 0 0 0 0 Other Frrancing Sourc�s & Uses 0 0 0 0 0 0 0 0 Dept 950 OlherNonopera6ng Acd Class: 530 Ope�atin9 ExPend�ures/Expense 559.300 Depreaation 99,785 0 0 0 0 559.301 Budgeted depreciatian (ne�ted) 0 70,250 70,256 0 0 Operating FxpendidueslExpense 99,785 70,250 70,250 0 0 0 0 0 Aa;t Class: 590 Olher Fnanang Sources & Uses 590.001 Allocate bo Fund Balance 0 49,710 49,710 0 p Otl� Financing Sauces & Uses 0 49,710 49,710 0 0 0 0 0 OU�rN°n°P��9 99.785 119,960 119.960 0 0 0 0 0 Dept 990 OlhedRe.serve/Contingency Acd Ciass: 590 Omer Financing Sources & llses 599.902 Reserves - Cantirgency 0 0 0 0 0 Other Fnancing Sources $ Uses 0 0 0 0 0 0 0 0 Oth�'/FteservelCor�tingency 0 0 0 0 0 0 0 0 Total Expendh�res 221,283 319.150 319,150 'l34,385 194,474 431,950 0 0 �'�'a�' ��Y 1Q3,747 0 0 182,559 -194,474 -430,850 0 0 Grand Total: -531,957 0 -1 2,258,522 -4,694,119 -4,660,251 9,741,479 D