Loading...
HomeMy WebLinkAboutDocumentation_Workshop_Tab 01_08/04/2014 NOTE: The following budget report is still being refined by department heads, additional submittals may result. suocErwo�cs�r ow�r �e: � �r��no�a Vfllage of Tequesla 1128 em Prior CurterrtYear (8) (� (8) Year Original Amend� Achral Thru Estlmeted Mm�th:7/31/2014 Hch�al Budget Budgei July To�l DEPARTMENT MIWAGER CAUNCd Furb: 001 - Generel Fuml Revenua9 Dept 000 C�eneral Axt Cless: 311 Gerreral PropeAy Texes 311.000 Ad Valorem Taxes - CurreM 4,337,570 4,759,W0 4,759,OW 4,755,463 4,755,463 5,019,000 5,019,000 311.100 Ad Valorem Taxes-Del 1,644 5,000 5,0� 8,368 8,369 5,000 5,000 Gerreral Pro�rty Taxes 4,339,214 4,764,000 4,764,000 4,763,832 4,763,832 5,024,000 5,024,Q00 0 Aat Class: 316 Seles & Use Texes 314.100 UtlIKyTmc-El�tridty 467,498 430,000 430,000 361,910 470,000 470,000 470,000 314.300 UtlIKyTmc-WaGer 156,360 156,OOD 156,000 124,168 160,�0 160.000 16D,000 314.400 UtDKy Tax - NeNral Gas 0 0 0 43 22 314.800 Utlltty Tmc-Pro�ne 20,618 24,000 24,000 28,540 30,000 30,000 30,000 315.000 Comm.Servic� Tax (CS� 344,204 333,380 333,3fi0 245,154 325,000 325,000 325,000 321.000 La�l Bushiess Tax (Oce Llc) 71,695 71,000 71,000 72,652 72,800 72,000 72,U00 321.001 Home Busin�ss Tax 4,500 4,500 4,500 5,544 5,544 4,500 4,500 321.010 Loral Busin�s Tax - County 7,880 4,500 4,500 4,741 4,741 4,600 4,6� Sal� 8 Uae Taxes 1,072,755 1,023,360 1,023,3� 840,752 1,06'8,107 1,068,100 1,066,100 0 Axt Class: 318 Franc�ise fees - groas receipt 313.100 Fran F�Ela,ctric 380,160 392,000 392,UD0 282,751 390,U00 414,000 414,000 Franchise f� - gross r�ipt 380,160 392,000 392,000 262,751 390,000 414,000 414,000 0 Acct Cless: 329 IMragovemmerdal Revenue 341.401 Admin Mgmt Fe�-Weter 485,229 499,785 499,7&5 416,488 499,785 514,780 514,780 341.402 Admin Mgmt Fee-Ref & Recycling 6,850 7,055 7,055 5,879 7,055 7,270 7a70 341.403 Admfn Mgmt F� - Slortn Water 11,630 71,978 17,978 9,982 11,978 72,340 12,340 369.010 Misc Revenue-Hab 0 0 0 370 357 Intregovemmer�l Revenue 503,709 518,818 518,818 432,718 579,175 534,390 534,3� 0 Aat Class: 335 I�ergovemmerdal Revenue 335.120 Munidpal Revenue Shartng Prog 173,789 174,500 174,500 144,280 176,�0 176,000 178,000 335.150 Alcoholic Beverage Licenses 5,576 5,000 5,000 6,111 6,111 6,000 8,000 335.180 Loc Gov 1l2 CeM Sales Tax Pro 388,009 3�,300 398,300 318,710 405,000 405,W0 405,Q00 338.101 Local G� Tax-6 CeM 114,868 116.900 116,800 89,095 118.000 116,000 716,000 338.102 Local G� Tax 15 CeM 53,�2 54,000 54,000 42,749 58,000 56,000 56,000 338.110 R�ycling Shared Rev - SWA 0 0 0 0 0 Intergrnemmer�l Revenue 735,924 748,700 748,700 600,945 759,711 759,000 759,000 0 Aat Class: 341 Chgs Tor Serv - Gen Gov 347.701 CertiflcationlCopy F�s 11,895 10,�0 10,000 10,898 11,000 10,000 10,000 347.703 Electlon quaGfying fe�v 60 150 150 90 90 341.1Q5 AdminfeesfromatherGov9s 1,664 1,000 1,000 1,400 1,400 1,200 1,200 ChgsforServ-GenGov 13,619 11,150 11,150 12,388 12,490 11,200 11,200 0 Acct Class: 382 Rertls & Royaltles 362110 L�se-Spfirt 35,053 34,190 34,190 30,087 34,190 37,187 37,187 BUDGET WORKSF�ET DRAFT Pege: 2 7I31@014 V�e of Teques� 11:28 am Prior CurreM Y�r (6) (� (8) Year Odghial Amend� Actual Tfw EsdmeOed Momh:713112014 AcWal Budget Budget July Totel DEPARTMENT MANAGER COUNCIL Fur�d: 001- Generel Fumi Revenues Dept 000 General Axt Cless: 362 Rerds 8 Rayaltl� 362112 L�se-T-MobOe 48,850 50,800 50,800 42,273 50,800 52,838 52,836 362.115 Lease-NexOel 28,947 0 0 0 0 362.116 Lease-ATBT 30,000 30,000 30,000 27,500 30,000 30,000 30,000 362117 Lease-Verizan 0 0 0 0 0 66,000 86,OU0 ReMS 8 Royaltl� 140,850 114,990 114,990 99,8�1 114,990 186,023 188,023 0 Acct Ciass: 366 Contributlo� 8 Donatlor�s 366.100 Contrib 8 Donetlona & Spor�sors 1,525 0 0 0 0 ConMbWons & Donatlona 1,525 0 0 0 0 0 0 0 Acct Class: 369 Mlscellan�us Revenu� 364.100 Dispositlon af Agsefs 0 0 0 0 0 369.000 Other Miscellaneous Revenue 13,810 0 18,000 23,843 24,000 8,000 8,OQ0 369.100 Insurance Reimbiusemem 31,074 15,500 15,500 28,683 28,683 15,500 15,500 Miscellaneous Revenu� 44,624 15,500 33,500 52,526 52,�3 23,500 23,500 0 Generel 7,232,380 7,SBB,518 7,606,518 7,065,773 7,680,388 8,018,213 8,018213 0 Dept 150 Comprehensive Plerming Axt Cless: 340 Charges for Servi� 341.150 Land DevebpmeM Fe�a 35,276 35.00D 35,000 27,541 35.000 35,000 35,000 343.700 Weter Conservetion & Resource 812 0 0 913 640 ChargesfarServices 36,098 35,000 35,000 28,454 35,640 35,000 35,000 0 Acct Class: 369 MLscellan�us Revenue.a 369.000 Olher Miscellan�us Revenue 0 0 0 0 D Miscellan�us R�renu� 0 0 0 0 0 0 0 0 Comprehensive PlannMg 36,098 35,000 35.000 28,454 35,640 35,000 35.000 0 Dept 171 Police Acxt Class: 316 Sel� & Use Taxa9 312.520 Casualiy Insurance Pramlum Tax 76,1T/ 0 0 0 0 Sale,s 8 Use Tax� 76,177 0 0 0 0 0 0 0 Acct Class: 320 Licer� & Pertnib 329.101 Alartn Permfls 6,440 0 0 0 0 329.102 Spedel Truck Pertnifs � 0 0 15 15 329.1 Q5 Goff Cert Permits 0 700 700 0 0 Llcer� & Pertnils 6,508 700 700 75 15 0 0 0 Acct Ciass: 337 Grerds F�leral 331210 FDLE - Federel Grarrt 0 0 0 0 0 Granffi F�erel 0 0 0 0 0 0 0 0 Acd Class: 335 InOergwemmerrtal Revenue 338201 PBC 917 MaNt ReimbursemeM 0 8,000 8,000 0 0 8,000 8,000 338202 PBC 911 DISPATCH REIIu1BURSEMENT 13,353 26,000 26,OW 27,428 27,428 19,320 18,320 BUDGET WORKSI�ET DRAFT Pege: 3 7/31/2014 Village of Tequ� 1126 am Prior CurtentY�r (B) (n (8) Year Originel Amend� Ach�al Ttw Estlmeted Mmdh:7/31l2014 Actual Budget Budget July To�l DEPARTMEN7' MANAGER COUNCIL Fur�d: 001- General FurM Revenue.s Dept 171 Po�ce IntergovemmeMal Rerenue 13,353 34,U00 34,000 27,428 27,428 27,320 27,320 0 Acct Ciess: 337 Grar� 8 Conhibudore - Laal 368.1� Donatlor�s-M�ftarytoMeinSt 0 0 0 10,000 10,000 5,000 5,W0 GraMs & Contributlona - Lacal 0 0 0 10,000 10,000 5,000 5,000 0 Acct Cless: 342 Chga for 5erv - Public Safery 342.110 PBC - Marine law errt'orce. serv 18,�1 18,500 18,500 9,100 9,100 Chgs for Serv - Pub�c Safety 18,6'81 18,500 18,500 9,100 9,100 0 0 0 Acct Cless: 351 Flr� & FarfeiNr� 351.100 Court Fin�v 7,178 15,000 15,000 3,774 3,774 2.000 2,000 354.101 ParkingTidceb 1,440 B00 B00 1.330 1,300 800 B00 354.102 Code Errf Fln� 8 Court C�ts 9,158 9,000 9.000 24,230 24,230 Flna 8 Forfeihires 77,776 24,800 24,800 29,334 29,304 2,800 2,800 0 Acct Clasa: 363 Impact F� 362221 Pollce Impact Fees 378 0 0 126 126 ImpactFees 378 0 0 128 126 0 0 0 Acct Class: 366 Contributlons fl Donatlons 366.100 Contrib & Donatlor�s & Sporu�rs 0 0 0 0 0 Contribubons 8 Donatlons 0 0 0 0 0 0 0 0 Acct Cless: 369 Miscellen�us Revenu� 369.000 Other IMscellaneous Revenue 3,138 0 0 510 510 Mlacellen�ua Revenu� 3,138 0 0 510 510 0 0 D Palice 136,011 78,000 78,000 76,513 76,483 35,120 35,120 0 Dept 175 Police DepartrneM Acct Class: 369 Miscelleneous Revenu� 359.100 Farfef�r�IConfiscatlons 153 0 0 0 0 Miscelleneous Revenu�s 153 0 0 0 0 0 0 0 Police Depertrnent 153 0 0 0 0 0 0 0 Dept 180 Buliding & Zonim,� Acct Cless: 320 Licens� & Pertnits 372.000 Building Permtt Fees 308,830 322,500 322,500 365,298 365,000 363,040 363,040 329.000 Contractors Registratlon 8,875 9,750 9,750 8,360 9,750 9,700 9,700 329.010 Contractor Reg. - Counly 6,258 6,000 6,000 2,754 5,000 5,000 5,000 Lice�v 8 Permib 324,061 338,250 338,250 376,412 379,750 377,740 3TI,740 0 Acct Ciess: 351 Flr� 8 Forfei�res 354.102 Code Errf Fln� & Court Cosb 0 0 0 0 0 4,500 4,500 Flrres 8 Forfettures 0 0 0 0 0 4,500 4,500 0 Acxt Cless: 389 Miscelleneoua Revenu�v 369.000 Other Miacellan�us Revenue 0 0 0 80 BO Miscellen�us Revenu� 0 0 0 60 80 0 0 0 BUDGET WORKSFIEEI' DRAFT Page: 4 7/31l2014 Wlage of Tequeshd 1126 arn Pdor CurreMY�r (6) (n (8) Year OrigUrel Amend� AcLiall'fw Eatlmeted Morrth:7/312014 Aclual Budget Budget JWy TWaI DEPARTMENT MANAGER COUNCIL FmM: 001 - General FurM Revewes Building 8 Zoning 324,061 338,250 338,250 376,472 379,810 382,240 382,240 0 Dept 192 Flre Control Aa:t Cless: 316 Seles & Use Tex� 312510 Flre Inaurance Prem Tex 117,996 154,700 118,000 0 118,000 118,000 118,0�0 Seles & Use Tax� 117,996 154,700 118,000 0 118,000 118,000 718,000 0 Aa:t C�: 334 GraMs - Stete 337201 Stahe EMS GRANT 48,�0 0 0 0 0 Giards - State 48,600 0 0 0 0 0 0 0 Acct Ciass: 335 Irdergovemmental Revenue 335201 Flre InceMive Pay 3,451 3,600 3,600 1,875 3,600 3,800 3,600 Irrtergovemmerdel Revenue 3,451 3,600 3,600 1,875 3,600 3,800 3,600 0 Acct Cless: 340 Chargea for Services 342.192 Flre- F�dre Duty 0 500 500 325 500 500 500 342201 Flre Plen Review Fe� 2(1,831 21,000 21,000 51,367 54,800 42,000 42,000 342202 Flre Inspectlons 25,806 22,990 22,990 18,997 23,500 23,720 23,720 342401 Emergenq Service-JIC 222,502 400,000 400,000 300,000 400,000 400,000 400,OU0 342402 Flre Rescue-CPR Program 915 700 700 710 710 700 7W 342410 Emergenc,y Svo- PBC Fire R�scue 184,000 789,520 189,520 189,520 789,520 195z06 195,206 342600 EMS Tiar�sportetlon Fees 300,069 290,700 290,700 230,�0 292,500 315,000 315,000 342950 Allow fnr doubtful rev- GovFrM 0 0 0 0 0 Cherg�sforServic�s 753,923 925,410 925,410 790,919 961,330 977,126 977,126 0 Acct Ciass: 363 Impact F� 362.222 FlrelmpactF�.s 520 500 500 173 �0 500 500 Impac[F� 520 500 500 173 500 500 500 0 Axt Class: 36'6 Con4lbutlor�s 8 Danatlons 3fi8.100 ConMb & Donetlons 8 Sponsara 110 500 500 1� 200 250 250 Contribulio� 8 Donatlor�s 110 500 500 130 200 250 250 0 Acct Cless: 369 Misce�en�us Revenu� 365.102 Fra Dept Sales 43 50 50 65 57 50 50 389.000 OtherMiscellaneouaRevenue 11,836 600 600 2,8� 2,700 600 1,800 Misellan�us Revenuag 11,879 650 650 2,734 2,757 650 1,650 0 FreCmitroi 936,479 1,085,360 1,048,660 785,831 1,086,387 1,100,126 1,101,126 0 Dept 210 Public Works Acct Class: 3� Mbcellaneous Revenues 389.000 Other Mi�llaneous Revenue 4,480 0 0 0 0 Miscellan�us Revenu� 4,480 0 0 0 0 0 0 0 Pub6c Workv 4,480 0 0 0 0 0 0 0 Dept 231 Lsisure Services Acct Cless: 347 Charges (w Services - R�v. 347.100 Tequ� Fest 18,891 0 0 7,774 7,774 7,80U 7,800 BUDGET WORKSHEET DRAFT Pege: 5 7/31/2014 Vmege aF Teques� 1126 em Prlor CurreM Y�r (6) (� (8) Year Original Amend� Achiel Thru Estlmeted Monfh:7/31/2014 AcWal Budget Budget July Total DEPARTMENT MANAGER COUNCIL Furb: 001- General Fu� Revenu� Dept 231 Leisure Servit�s Axt Class: 347 Chargag for Servica - Rea. 347.190 Sp�al Everds - Other 12,5?2 9,000 9,000 11,041 71,041 9,000 10,OD0 347201 WfrrtedSummer Cemp Fees 39,836 47,000 47,000 33,060 42,750 42,750 42,750 34720.5 Recreatlon Progrems Fe� 8,281 6,000 6,W0 8,784 10,000 8,000 6,000 ChargesforServices-Rea. 79,340 fi2,000 62,000 80.859 71,565 85,550 66,550 0 Aat Class: 382 Rerhs & Royalti� 362100 Rentel-FeGIId� 6,453 4,000 4,000 7,932 8,U00 4,000 6,500 Rems 8 Royaltl� 6,453 4,000 4,000 7,832 8,000 4,000 6,500 0 Axt Cless: 363 Impact F� 363271 Perlcs and R� Im�ct Fe� 1,654 0 0 551 551 Impact Feag 1,854 0 0 551 551 0 0 0 Acct Ciess: 386 ConMbuUors 8 Donatioro 366.100 Contrib & Donetlorre 8 S�r�sora 10,950 0 0 7,125 7,125 7,200 7,200 Contributlor�s & Donatlona 10,950 0 0 7,125 7,125 7�00 7,200 0 Acct Clasa: 369 Miacellen�us Revenu�a 365.110 Cono�sion Sel� 5,357 5,000 5,000 2,6T/ 2,677 5,000 5,000 �9.000 Olher Miscelleneous Revenue 0 0 0 0 0 Mlscellaneous Rewenu� 5,357 5,000 5,000 2,677 2,677 5,000 5,000 0 Leisure SeMces 103,754 71,000 71,000 78.944 89,918 81,750 &5,250 0 Dept 900 Irderfund T�ansfers Acct Cless: 391 Transfers In 381.301 Transfer-In iram Cep Impravemn 290,440 100,000 100,000 100,000 1 W,000 �1.303 Tsfer-In firom Capifal Projecta 80,000 50,OOD 50,000 50,000 50.000 �1.605 Tfr In - Spedal Lew Errf Trust 50,000 50,000 50,000 0 0 Transfers In 420,440 200,000 200,000 150,000 150,000 0 0 0 Irrterfund Transfers 420,440 Z00,000 200,000 150,000 150,000 0 0 0 Dept 910 Olher Frmndng Sources 8 Uses Acct Ciass: 390 Other Financfig Sourc�s 383.100 Cepitel L�se at Inceptlon 0 432,850 432,850 432,844 432,844 240,000 300,000 Other Flnencing Sources 0 432,850 432,850 432,844 432,844 240,000 300,000 0 Other Flnencing Sour�es & Uses 0 432,850 432,850 432,844 432,844 240,000 300,000 0 Dept 950 Olher NonoperaUng Acct Class: 361 Unrastric� IrneshneM Eamin 361.100 Inte�tllnveshnsM Eamings 9,974 11.00D 11,000 6,351 9.W0 9,000 9,000 381.101 PBC Tax Col-Irrterest on Dep 594 800 800 104 500 500 500 367.100 Net Unreal appredatlon (Dep) 11,748 18,000 18,000 3,965 8,000 7,500 7,500 UnrasMcted Irrveshment Eamin 72,316 29,800 29,800 10,420 15,500 17,000 17,OOD 0 Acct Cless: 369 Miscellen�us Revenu� 364.100 Dispositlon of /l�sets 26,313 15,000 15,000 0 0 90,000 90,000 sunaer wor�csr�r DRAFT Page: 6 7/31l2014 Vmage of Tequ�sta 17:26 am Pdor Currerrt Y�r (6) (n (8) Yeer Original Amend� AcNal Tfw EsdmaOed Month:713112014 Ach�el Budget Budget July Total DEPARTMENT MANAGER COUNCR. Fund: 001- Generel FutM Revernies Dept 950 Olher Nono�ratlng Mlscellaneous Revenu� 26,373 15,W0 15,000 0 0 80,000 90,000 0 Other Norropeiatlng 48,629 44,800 44,8D0 10,420 15,500 107,0� 107,000 0 Dept 990 OthedReservelContlngen�y Acct Class: 390 Other Flnandng Sourcav 399.995 Appropriafe FB - SmartCop 0 0 0 0 0 399.999 Appropriate Fund Balance 0 0 453,718 0 0 Other Finandng Sourt�s 0 0 453,718 0 0 0 0 0 OthedReservelCordfigency 0 0 453,718 0 0 0 0 0 ToTal Revenus� 9,242,485 9,873,778 10,308,796 9,015,251 9,946,970 9,999,449 10,063,949 0 E�ryendihires Dept 100 Cowa1 Acct Cless: 530 Operatlng Fxpenditur�lExpense 531.311 Coundl Fees-Fvena 3,000 3,000 3,000 2,750 3,OD0 3,000 3,000 531.313 Cour�cll fe�v - T. Petemo 3,000 3,000 3,000 2,750 3,�00 3,000 3,000 531.314 Coundl f� - F. D'Ambre 3,000 3,000 3,W0 2,750 3,U00 3,000 3,OU0 531.316 Caundl fe� - S. Okun 3,000 3,000 3,000 2,750 3,000 3,000 3,000 531.317 Caundl Fees - Brennan 3,000 3,000 3,000 2,750 3,000 3,000 3,000 540.301 CoundlExpens�s-Arene 9 1,500 1,000 0 1,�0 3,000 3,000 540.304 CoundlExpense-F.D'Ambra 9 1,500 1,000 0 1,000 3,000 3,000 540.306 Coundl Fxpense-S.Okun 1,308 1,500 1,500 326 1,500 3,000 3,000 540.307 Coundl F�ens�-Brennan 1,490 1,500 7,SU0 9fi5 1,500 3,000 3,000 540.308 Coundl Fxpensag- Petemo 76 1,500 1,500 165 7,500 3,000 3,000 549.300 Other Misc Chgs & Obngatlona 635 700 664 441 664 700 700 549.350 VolunteerAppr�latlon 679 800 836 835 835 800 800 554.300 Books, Publ, Suhs & Membership 2,985 3,400 3,400 2,985 3,400 3,500 3,500 582800 Aid to Community Organizatlons 0 0 0 0 0 582.801 Aid Oo Can.Org - Nena 400 0 500 500 500 582804 Aid to Canmunity Org - D'Ambre 400 0 500 500 500 582.807 Aid 6o Com. Org. - Brennen 200 0 0 0 0 582.808 Aid to Com. Org. - Petemo 0 0 0 0 0 Operatln9 Exper�dfUu�lExPerise 23,191 27,400 27,400 20,467 27,399 35.000 35,000 0 Coundl 23.191 27,400 27,400 20,487 27,�9 35,000 35,000 0 Dept 110 Manager Accc Ciass: 510 Personel Servicea 512.100 Regular Selerias & Wag� 130,206 132,400 132,400 108,295 132,100 137Z00 137,200 514.100 OverHme 183 0 0 0 0 515.103 Bonus Pay Plan 0 0 4,500 4,500 4,500 BUDGET WORKSHEET DRAFT Page: 7 7/31@074 VDlege of Tequesta 1126 em Prior CurteM Y�r (6) (n (8) Y�r Odghial Amended Achiel Ttw Estlmeted Marth:713112014 Actual Budget Budget July Totel DEPARTMENI' MANAGER CAUNCd FurM: 001- General Fund ExpendHur� Dept 110 Manager Acct Class: 510 Pe�onal Servic� 515.108 Auto Allowance 3,000 3,000 3,000 2,500 3,000 3,000 3,000 515.125 Other/Nowenc� 1,200 1,200 1,2� 1,000 1,200 7Z00 1200 516.100 CompensaOedAbssnc� 4,314 5,000 10,376 3,922 6,150 9,000 9,000 516.105 Compenaeted Hl�ences - HSA 8,825 0 0 0 0 521.101 FICA Tazes 6,221 6,900 6,952 5,999 6,620 7,400 7,400 521.102 M�I�ere Tex� 2,053 2.000 2.177 1,746 2.150 2,200 2,200 522.102 VOT Per�sion Contrfbutlo� 12,213 12,200 12,200 9,941 72,125 11,600 11,600 523.101 LIf�HeaNh Inswance 22,088 25,300 19,400 18,217 19,330 17,000 17,000 523.1Q5 HSA - Heelth Savir�gs NccouM 2,550 0 0 0 0 524.100 Workers' Comp lnsivance 378 270 270 260 260 270 270 526.104 ICMA-Def Comp Plan 9,826 9,900 9,900 8,057 9,830 10,300 10,300 554.301 Personrrel Trainhig 874 750 1,395 1,395 1,395 1,000 1,000 Personel Servic�v 201,832 198,920 203,770 183,832 188,660 200,170 200,170 0 Acct Cless: 530 Operetlng FxpenditureslExperise 540.300 TravelBPerDiem 1,449 1,400 1,400 730 1,400 1,400 1,400 546.3� Computer system maint 8 suppll 0 500 500 0 0 500 500 548.110 Merketfig end Public Reletlons 355 0 0 0 0 549.300 Other Mlac Chgs & Obligatlons 0 250 250 30 30 250 250 554.300 Books, Publ, Subs 8 Membership 2,640 2,800 2,800 2,382 2,8�0 3.150 3,150 Operatlng ExpendilureslExper� 4,444 4,950 4,950 3,142 4,230 5,300 5,300 0 Acct Clasa: 590 Other Flnandng Sourt�s 8 Uses 599.10D Budget Cost Sevings 0 4,850 0 0 0 Other Flnendng Sourc�a & Uses 0 4,850 0 0 0 0 0 0 Acct Class: 600 Cepitel 0utlay 664.601 Computer Equipmerrt 0 0 0 0 0 CaplfalOWey 0 0 0 0 0 0 0 0 Meneger 206,376 208,720 208,720 166,974 202,890 205,470 205,470 0 Dept 111 Humen Resour� Acd Class: 510 Personal Services 5121U0 Regular Selaries 8 Wag� 79,603 79,800 79.800 65,268 79,605 113,900 118,100 515.103 Bonus Pay Plan 0 0 3,000 3,000 3,000 515.107 PeR-Ume �lari� 30,028 30,300 33,300 25,501 30,770 516.100 Com�n�ted Al�nc�v 1,982 2,000 2,000 1,982 1,�2 2,000 2.000 516.1Q5 Compen�UedAbsences-HSA 1,�0 0 0 0 0 521.101 FlCATexag 8,705 7,000 7,124 5,609 6.800 7,000 7,300 527.102 M�IcareTax� 1,568 7,700 1,729 7,312 1,6'00 1,700 1,700 522102 VOT Pe�lon Cor�tribuUor�s 7,467 7,400 7,400 5,992 7,310 9,800 10,000 BUDGET WORKSF�EEf DRAFT Page: 8 7/31/2014 VWage of Tequesla 1126 em Prlor CurrerrtY�r (6) (� (8) Year OdgMel Amend� Achiel Thru Esdmeted Mor�th:7/31/2014 Achiel Budget Budget July Totel DEPARTMENI' MANAGER COUNCIL FurM: 001- General FurM ExpendiWres Dept 111 Humen R�urces Aat Class: 510 Peraonal Services 523.101 LifelFleaNh Insurar� 6,708 7,300 7,300 6,219 7,255 77,700 19,200 523.105 HSA - H�Ith Savir�gs Acmurrt 1,000 0 0 0 0 524.100 Workera' Comp Insurance 329 220 220 216 216 720 220 526.101 Employee Recognitlon Program B,T14 5,500 5,500 4,4&5 5,500 5,500 5,500 526.102 EmployesAasistanceProgram 3,408 4,000 4,000 7,703 4,000 4,000 4,000 526.103 Educatlon ReimbursemeM Prgm 0 1,000 0 0 0 1,000 7,000 554.301 Personnel Training 2,060 2,500 2,500 2,100 2,�0 2,500 2,500 554.310 Employee Dsvelopmerrt 132 2,000 2,000 850 2,000 2,000 2,000 PeBOnal Servic� 148,�2 150,720 155,873 124,217 152.538 787,120 173,520 0 Acct Class: 530 OPeratln9 Exper�ft�F�er�se 540.300 TrevelBPerUiem 1,840 1,300 1,300 1,248 1.300 7,300 1,300 546.320 Computer system mairrt 8 suppll 1,659 500 500 53 500 500 500 547.300 Printlng & Binding 619 1,500 300 0 300 1,500 1,500 549.300 Other Misc Chgs & Obligatlons 0 500 327 126 327 500 500 549.401 ReauitrneMe�enses 257 1,000 500 401 500 1,500 1,500 552302 Smell Tools and Equipment 224 500 200 60 200 500 500 554.300 Boolcs, Publ, Subs 8 Membership 730 500 750 564 750 700 700 Operetlng Expenditur�lExpense 5,328 5,800 3,877 2,452 3,877 6,500 6,500 0 Acct Ciass: 590 Otlier Flnandng Sour�es 8 Uses 599.100 Budget Ca9t Savmgs 0 3,230 0 0 0 Other Finendng Sources & Uses 0 3,230 0 0 0 0 0 0 Acct Class: 600 Capifel Outley 664.601 ComputerEquipment 0 0 0 0 0 1,600 1,600 CapitelOWay 0 0 0 0 0 1,800 1,600 0 Humen Reso� 154,311 159,750 159,750 126,669 156,415 175,220 181,6Z0 0 Dept 120 Village Cierk Acct Ciess: 510 Personal Servic�s 512.100 Reguler Selaries 8 Wagas 109,676 109,900 109,900 89,882 109,630 112,500 112,500 514.100 Overtlme 86 0 0 0 0 515.1Q3 Bonus Pay Plen 0 0 3,000 3,000 3,000 516.100 Campenseted A�ences 0 0 0 0 0 516.1Q5 CompensaOedAl�enc�-HSA 1,398 0 0 0 0 521.101 FICA Tax� 6,384 6,500 6,730 5,447 8,730 7,400 7,400 521.102 MedicareTax� 1,493 1,600 1,600 1,274 1,800 1,800 1,800 522.102 VOT Per�slon Cantributlor�s 10,288 10,200 10,200 8,251 10,085 8,500 9,500 523.101 LffelHealih Insurance 23,180 25,100 25,100 20,627 24,026 18,800 18,800 523.105 HSA - H�Ith Sevir�gs Account 1,700 0 0 0 0 BUDGET WORKSF�EEI' DRAFT Pege: 9 7131f2014 Village oF Tequesle 1126 am Prior CurreM Y�r (6) (� (8) Year Odginel Amended AcWal Thru EsUmated Mordh:713112014 Ach�al Budget Budget July Totel DEPARTMENT MANAGER COUNCIL Fund: 001 - General Furb 6ryendilures Dept 120 VlDage Clerk Aa�:t Cless: 510 Personal Servi� 524.100 Workers' Comp Ins�uance 325 720 220 216 216 220 220 528.103 Educetlon RetrnbursemeM Prgm 0 0 327 326 327 554.301 PersonnelTrainhig 1,565 2,250 1,923 100 1,923 1,980 1,980 Peraonal Servic� 156,095 155,770 158,000 129,123 157,517 152200 152,200 0 Acct Ciess: 530 OP��9 ����� 531.303 CodiAcatlon SeMces 8,868 8,700 15,292 12,292 15,292 10,700 10,700 531.304 R�rdir�g Secy Service 7,511 7,350 7,350 4,424 7,350 7,350 7,350 534.301 Eleciion Expense 882 15,940 9,348 1,306 1,307 15.940 15,940 534.302 Legal Adver�sing 15,910 14,800 14,800 6,p0 14,800 74,800 14,800 534.311 Electlon exp. - annexatlor�s 10,030 0 0 0 0 540.300 Trevel & Per Diem 2,&59 3,0.50 3,050 1,167 3,000 3,440 3,440 541.300 Cammunicatlon SsMces 1,143 1,300 1,300 891 1,300 1,300 1,300 546.320 Computersystemmaint$suppli 2,844 1,300 1,SU0 495 1,500 78200 18,200 548.110 Merketlng and Public Relatlons 0 0 4W 400 400 2,200 2,200 549.100 Mlscellan�usArt;hivel 47 2,500 2,500 107 1,500 2,500 2,5� 549201 Adve�isir�g � Promotlon 187 1,000 600 0 0 549.300 Otlter Mlac Chgs & Ob�gatlons 217 1,800 1,600 1,225 1,600 2,3R0 2,300 552.302 Small Toots a� EquipmeM 508 500 500 84 500 500 500 552308 Microfllm ServicelSuppli� 11 30 30 11 30 30 30 554.300 Booka, Publ, Subs 8 Membership 486 860 860 344 860 860 860 Operatlng ExperbfhueslExper� 51,483 59,130 59,130 29,376 49,439 80,120 80,120 0 Acct Ciess: 590 Other Fln�ang Sourc� & Uses 599.100 Budget Cost Sevings 0 3,230 0 0 0 Other Flnendng Sourcas 8 Us� 0 3,230 0 0 0 0 0 0 Village Clerk 207,578 218,130 218,130 158,499 208,958 232,320 232,320 0 Dept 130 Flnance A�xt Clasa: 510 Personel Servica9 512100 Regular Saleries 8 Wagea 239,906 240,500 237,885 194,472 237,535 245,100 245,100 514.100 Overtlme 12 0 0 0 0 515.103 Bonus Pey Plen 0 0 7,950 7,950 7,950 516.100 Compen�ed At�ences 2,645 4,500 4,500 1,444 3.942 3,500 3,500 516.10.5 Compenaeted Absenc� - HSA 2,571 0 0 0 0 521.101 FlCATaxes 14,354 14,800 14,400 11,545 14,300 15,1�0 15,100 521.102 MedicareTaxes 3,387 3,500 3,544 2,741 3,400 3,500 3,500 522102 VOT Pension Contributlorre 22,133 71,209 22,200 17,853 21,810 20,700 20,700 523.101 LlfelHealth Irisorance 37,688 42,300 43,950 36,633 43,931 36,600 36,600 523.1Q5 HSA- H�Itl� Sevings Acco�mt 3,350 0 0 0 0 su�Er wowcsx�r DRAFT Page: 10 7131@014 Vlllage of Tequ� 1126 am Prior CurreM Y�r (6) (n (8) Ye� Original Amended Achiiel Tfw Esttrr�ated Mmitlr.7/31@014 Achiel Budget Budget JWy Totel DEPARTMENT MANAGER COUNCIL FurM: 001- Generel FurM Expendihir� Dept 130 Finence Acct Class: 510 Peraonal Servic� 524.100 Workera' Comp Insurence 7� 480 480 473 473 480 480 525.1� UrremploymeMCompen�tlon 0 0 4,400 0 4,400 554.301 Personnel Treinhig 3,490 4,600 4,800 980 4,�0 4,400 4,400 Personal Services 330,304 332,880 343,689 274,091 342,341 329,380 329.380 0 Acct Class: 530 Opeiatlng F�cperMf4�ra91Expense 532.300 Accowtlng & Auditlng SeMc� 23,908 24,200 23,865 23,865 23,865 24,610 24,610 540.300 Travel 8 Per Diem 173 1,000 7,000 298 1,000 1,000 1,000 546.301 Oflice EqulplRepelr & Matrrt 578 800 800 527 800 900 900 546.320 Compuher system maNt & suppll 6,447 8,800 8,800 7,027 8,800 8,800 8,800 547.300 Printlng & Bindim� 1,322 3,000 1,800 1,425 1,800 3,000 3,000 549.300 OtherMlacChgs&Obligetlons 2� 1,000 1,000 586 1,000 1,000 1,000 551.300 Olflce Suppli� & Equipment 3,449 4,000 3286 1,386 3,288 4,000 4,000 552302 Smaii Tools and Equlpment 0 500 500 0 500 500 5�0 554.300 B�ks, Publ, Subs 8 Membership 1,355 1,400 1,400 724 1,400 7,600 1,600 Opereting Expendfh�lExper�ae 37,520 44,700 42,451 35,8;� 42,451 45,410 45,410 0 Acct Class: 590 Otlrer Flnencing Sources & Uses 599.100 Budgst Coat Savings 0 8,560 0 0 0 Other Flnancing Sources 8 Uses 0 8,560 0 0 0 0 0 0 Acd Class: 600 Cepital Outlay 6'84.801 Computer Equipment 1,259 0 0 0 0 Cepilal0utlay 1,259 0 0 0 0 0 0 0 Fi�nce 369,083 386,140 386,140 309,929 384,792 374,780 374,790 0 Dept 140 Legal Acct Cless: 530 Operetlng Expendltur�lExperise 531.301 Legal Servic�s 116,593 90,000 80,000 75,030 100,000 90,000 90,000 531.308 Le.gal f�a - Personnel 42,720 20,000 20,000 83,Oq 100,OW 60,000 60,000 Operatln9 Expendlhir�lExpense 159.313 710,000 710,000 158,093 200,000 150,000 150,000 0 Acct Ciass: 590 Other Flnendng Sources & Uses 599.700 Budget Cost Savfigs 0 0 0 0 0 Other Flnancing Sourc� & Uses 0 0 0 0 0 0 0 0 L�el 158,313 110,000 110,000 158,083 200,W0 150,000 150,000 0 Dept 150 Comprehenaive Planning Ar,ct Class: 510 Personal Servi� 5121U0 RegWar�lariesBWag� 0 78,000 78,000 63,770 77,780 79,800 79,800 515.103 Bonus Pay Plan 0 0 3,000 3,000 3,000 521.101 FlCAT� 0 4,800 4,900 3,872 4,760 5,000 5,000 521.102 M�IcareTex� 0 1,200 7200 905 1,125 1,200 7,200 522.101 FRS ConMbuuona 0 4,500 5,530 4,470 5,502 5,900 5,900 BU�'iET WORKSI�Ef DRAFT Page: 11 7/31P2014 Village of Tequ� 1126 am Pdor CurteM Y�r (6) (n (8) Yeer Odginal Amended AcLial Thru Eattrnabad MoMh:7/31/2014 Achial Budget Budget July Totel DEPARTMENT MANAGER COUNCd Fund: 001- Generel Fund ExpendiWres Dept 150 Comprehenaive Plerming Acct Ciess: 510 Personal Servic� 523.101 LHelHeaith Insurence 0 9,300 7Z50 6,119 7,250 6,400 8,400 524.100 Workers' Comp Inswance 0 280 280 272 272 �0 280 Personal Servi� 0 98,080 100.160 82,408 99,689 98,580 88,580 0 Na;t Cless: 530 Operatlng FxperMihueslFxper� 531.301 Legal Servic�s 27,218 11,000 11,000 17,338 25,000 30,000 15,000 531.321 Mapping Servic�s 0 2,500 2,500 1,848 2,500 2,500 2,500 531.322 Mfsc Plenning SeMce 103,&91 82,500 83,420 49,5� �,480 62,500 62,500 531.331 Board of Ad�uslmer�t Z86 500 250 0 250 250 250 531.332 Plenning erM Zaning Board 535 1,000 750 428 750 750 750 531.405 L�al-Annexedon 5,415 0 0 0 0 534.300 Other Contrech�el Servlces 10,990 5,000 5,000 2,388 5,000 5,000 5,000 534.302 Legal Advertlsh�g 5,313 8,500 5,500 3,789 5,500 8,500 8,500 534.420 L�al Advertlsing - Mnexadon 875 0 0 0 0 546.32f1 Compuler system maint & auppli 0 0 4,800 4,200 4,800 4,800 4,800 547.300 Pdntlng 8 Binding 0 500 500 0 500 500 500 549.150 Miscellen�us ennexetion exp 1,481 0 0 0 0 549.300 Other Misc Chgs & Obligetions 0 500 500 125 500 500 500 551.300 Offlce Suppll� 8 Equipment 0 0 500 240 500 750 750 Operatlng ExperMftureslExpenae 156,004 92,000 94,720 79,856 113,780 118,050 101,050 0 Acct Class: 590 Other Flnandng Sources & Us�v 599.100 Budget Cost Savhigs 0 0 0 0 0 Olher Flnendng Sourc� & Us�v 0 0 0 0 0 0 0 0 Acct Ciess: 600 Cepitel 0u11ay 664.601 Computer EquipmeM 0 0 0 0 0 CepitalOuUay 0 0 0 0 0 0 0 0 Comprehensive PlanNng 156,004 190,080 194,880 162,264 213,469 214,630 199,630 0 Dept 160 Generel GovemmeM Ncst Class: 510 Personal Services 5721U0 Regular�lerl�BWeges 69,666 69,800 69,800 57,121 69,667 71,500 71,500 515.103 Bonus Pey Plen 0 0 2,400 2,400 2,400 516.100 Compensated At�sences 0 4,000 6,411 2,765 6,411 4,000 4,000 516.10.5 Compensa6ed At�en� - HSA 1,�0 0 0 0 0 521.101 FlCA Taxes 4,256 4,600 4,749 3,808 4,525 4,700 4,700 521.102 M�IcareTaxes 995 1,100 1,135 844 1,060 1,700 1,100 522102 VOT Per�slon Contribudor�s 6,535 6,500 6,500 5,244 6,400 6,100 6,100 523.701 Lif�Health Inaurance 5,332 5,900 7,690 5,50.5 7,680 5200 5,200 523.10.5 HSA- Heakh Savir�gs Accoimt 800 0 0 0 0 BUDGET WORKSHEET DRAFT Page: 12 7/31/21114 VWege of Tequ� 1126 em Prior CurteM Y�r (8) (n (8) Year Odginal Amended AcWal Thru Estlmeted MoMh:7/31/2014 Achial Budget Budget Juiy Totel DEPARTMENT MANAGER COUNCIL Fund: 001- General Fu� ExpendiWr� Dept 160 General GovemmeM Axt Cless: 510 Personal Servic� 524.100 Workers' Comp Inswance 206 140 140 137 137 140 140 554.301 Personrrel Trainir� 0 5,000 5,000 0 5,OQ0 5,000 5,000 Per�nel SeMcea 88,470 97,040 103,825 77,624 1U3,290 97,740 97,740 0 Axt Class: 530 OPe�atln9 E�endfhir�lExpense 534.300 OlherCo�rtachialServices 72,015 20,000 20,006 17,001 20,002 2f1,100 35,700 534.303 Sp�lal Evenb 4,048 10,000 10,000 6,257 10.000 10,000 10,000 540.300 Trevel 8 Per Diem 1,436 2,000 2,000 0 2,�0 2,000 2,Q00 541.300 Commwicetlon Servicea 12,767 13,000 13,000 11,041 12,700 14,500 14,500 541.301 Postege 3,104 3,000 3,500 1,902 3,500 4,3Q0 4,300 541.3Q5 Website Mamtenance 7,�9 7,900 7,900 7,770 7,770 8,100 8,100 543.300 UtllityServi� 15,853 16,000 16,000 11,595 76,000 16,000 16,060 544.301 Operatlng Leas� 5,457 5,350 5.350 4,386 5,187 5,350 5,350 545.3001nsurence 45,969 48,900 48,900 48,729 48,7� 48,900 48,900 546.301 Offlce EqulplRepair & MaIM 1,473 2,000 2,000 1,150 2,000 2.000 2,000 546.302 Vehide Re�fr & MaUdenence 20 100 700 20 100 100 100 546.303 Bu�dtrig Repair & MaNt 0 0 0 0 0 546.310 EquipmentRe�ir&Mahrt 1,916 1,000 1,000 140 1,000 1,000 1,000 546.320 CamputersystemmalM$suppll 11,051 13,400 13,400 11,089 13,400 25,000 17,7� 547.300 Printlng & Bindl� 362 1,000 1,000 739 1,000 1,000 1,000 549.300 Olher Mix Chgs 8 Obligetlons 2,745 8,000 9,077 5,419 9,000 10,000 10,000 549.302 Vlnege Newsletter 19,101 18,200 13,499 4,532 9,000 18,W0 19,000 549.304 Licer�, F�s 8 PermNs 1,960 2,600 2,800 1,960 1,960 2.600 2,600 551.300 Oflice Suppli� 8 Equipment 4,119 4,000 4,000 2,334 4,000 4,000 4,000 552180 IT Operetlng Supplia 309 800 800 617 800 800 800 552.301 Ges & 011 175 500 500 135 250 5W 500 552302 Smell Twis and Eqwpmerrt 618 1,500 1,500 505 7.500 1,500 1,500 554.300 Books, Publ, Subs 8 Mem6ershlp 2,056 4,500 4,500 2,331 2,500 2,50D 2,500 O�retlng Exper�dRureslExpenae 164,243 183,750 180,632 139,652 172,388 199250 2W,000 0 Acct Class: 590 Other Flnendng Sourcea & Uses 599.100 Budget Cast SaNngs 0 2,590 0 0 0 Other Flnandng Sourc�a 8 Usea 0 2,590 0 0 0 0 0 0 Acct Ciess: 600 Cepilal Outlay 664.600 Mach/EquipmeM 0 0 0 0 0 6'64.601 Computer Equipment 6,6'80 0 0 0 0 664.602 Vehlcl� 0 0 0 0 0 Capltal0utlay 6,�0 0 0 0 0 0 0 0 Gerre�al Govemmerrt 260,393 283,380 284,457 217,276 275,fi88 �6,990 304,740 0 BUDGET WORK3I�EET DRAFT Page: 13 7/31I2014 VlUage oFTequ� 11T6 am Prior CurteMYear (6) (� (8) Year Origtr�al Amend� Ach�el Thru Estlrtret� Mmith:713112014 Achial Budget Budget July Totel DEPARTMENT MANAGER COUNCIL Fur�d: 001- Gene�al Fund Expendlhu� Dept 175 Police DeperhneM Aa:t Class: 510 Per�nal Servio� 512171 Sa18Wagea-Admlretratlon 721,206 123,500 123,500 99,900 122,330 728,600 128,600 512172 R�Se18Wag�-Communicatlo 244,353 245.100 245,100 200,379 244,400 251,OW 251,000 512175 R� Sal & Weg� - Opeiations 818,133 1,032,900 933,294 747,912 925,000 1,068,400 1,022,300 512180 R� Sel & Weg� - Code Errf 0 0 0 0 0 59,750 514.172 Overtlme-Communicedons 28,499 10,000 24,965 17,365 24,965 21,09D 18,000 514.175 Overtlme - Operedor�s 57,733 70,000 718,000 115.889 133.000 80,OOD 63,500 515.101 HoOday Pay 42,253 48.900 48,900 36,235 47,000 43,BOD 43,600 515.103 Bonus Pey Plen 7,500 7,250 13,250 13,250 13,250 7,300 7,30� 515.106 Clothlr�g & Boot Allowance 11,724 12,250 12,250 10,619 11,250 13,300 12,700 515.107 PeR-tlme Selerles 0 0 32,000 21,972 32,�0 515.1W AutoAllowance 4,000 6,000 6,000 5,000 6,U00 6,000 6,000 515.120 Ce0 phorre allowance 800 1,200 1,200 1,000 1,200 1�00 1,200 515.125 OtherAlloxrances 13,600 8,400 8,400 7,000 8,400 8,400 8,400 515.172 PffSelary-CommuNratlons 27,213 18,200 27,000 27,808 40,OD9 24,000 24,Q00 515.175 PIT Salery - Operetlons 80,945 0 0 0 0 46,600 46,600 515.180 P/T Selary - Code Er�orcemeM 0 0 0 0 0 16,900 516.100 Compensated A�ences 30,012 15,000 33,839 33,838 33,838 15,OW 15,000 516.105 Compenae� Absenc� - HSA 35,598 0 0 0 0 521.101 FICATaxes 95,401 95,700 98,686 79,631 96,fi86 107,700 98,100 521.102 M�f�are Tex� 71,312 71,700 22,944 18,658 72,944 25.600 23,600 522.101 FRS ConMbutlons 47,448 37,000 44,200 34,475 44,200 39,800 38,600 522.102 VOT Per�slon Corrtributlorus 158,216 156,600 156,900 113,649 138,000 126,000 120,300 571.1Q5 DeflnedContributlon 7,909 31,500 37,500 15,515 20,2()0 27,700 25,400 522110 Other Pension ConMbutlor�s 76,177 0 0 0 0 523.101 Llfe/Heatth Insurance ?20,014 272,800 253,502 193,084 233,000 240,100 217,600 523.1Q5 HSA-HealthSavingsHccoimt 21,900 0 0 0 0 524.100 Workers' Comp Insurance 37,930 45,430 45,430 45,425 45,425 45,430 45,430 525.100 UnemploymeMCompen�tlon 7,877 0 635 635 635 526.101 Employ� R�ognitlon Progiam 162 3,000 3,000 1,146 3,000 3,000 3,000 526.103 Eduratlon ReimbuBemerrt Prgm 0 4,000 4,W0 0 0 4,OD0 4,000 526.10.5 Employee PhysicallPsycologi�l 1,789 8,000 6,000 5,868 8,000 8,000 B 554.301 Personnel Trelning 3,839 11,000 11,000 7,672 11,W0 11,000 11,Q00 Personel Ssrvi� 2,325,541 2,284,430 2,303,495 1,853,596 2,257,723 2,429,380 2,245,230 0 Acd Class: 530 Operatlng Expendihu�IF�erise 531.301 Legel Services 21,369 25,000 25,000 17,498 Z0,000 531.320 Code EMorcemerrt Service 7 4,000 4,000 60 4,000 BUDGET WORKSF�EET DRAFT Page: 14 7(31@014 Vfllage of Tequ�ta 1128 am Prior CurtsM Y�r (6) (� (8) Year Orlginel Amended AcWel Thru Estlma�ed Mor�:713112014 Achial Budget Budget July Tolal DEPARTMENT MANAGER COUNC0. Fund: 001- Generel Fund Expendihires Dept 775 PoQce DepartmeM Acxt Class: 530 OP��9 ������ 531.327 Other Conhach�al -MTMS 0 0 0 0 Y1,000 40,400 40,400 540.300 Travel 8 P� Diem 8,380 13,000 13,000 7,804 13,000 12,000 12,000 541.300 Cammunicatlon Service.v 25,905 32,OQ0 32,000 22,012 26,000 32,000 32,000 541.301 Poslage 2,585 2,000 2,�00 1,500 2,009 2,000 2,000 543.300 Utllity Servi� 24,756 26,000 26,000 18,427 25,300 25,U00 25,000 544.301 Operafng Leas� 1,729 2,100 2.100 1,663 2.100 2,000 2,000 545.3001nsurance 42,536 47,700 48,350 48,483 48.483 48,350 48.350 546.175 K-9 EqulpmeM 8 Mairdenam� 0 0 2,047 2,088 4,000 6,000 6,000 546.301 Offlce Equip/Repair & Matrrt T/7 1,000 1,OU0 269 1,000 1,000 1,000 546.302 VeNcle Repair & Metrdenance 44,114 40,000 38,865 19,314 �,865 18,500 18,500 546.303 BufldhigRepair&Maint 21,265 20,000 26,100 17,710 Zf1,000 19,100 19,100 546.304 Communicatlon Eqidp Malrrt 13,143 16,000 86,405 5,931 96,405 12,8Q0 12,800 546.310 EqulpmeM Re�ir & Melr� 3,168 7,700 7,700 1,020 7,000 2,500 2,500 546.320 Computer system maiM 8 auppli 44,347 69,W0 89,OW 59,691 69.000 95,900 81.850 547.300 Printlng 8 Binding 334 2,W0 2,500 2,194 2,500 1,800 1,800 549.300 Other Mlsc Chgs 8 Obligatlons 6,209 5,500 5,500 4,308 5,SDD 5,000 5,000 549.303 Investlgative Expens� 1,078 1,100 1,100 748 1,100 1,100 1,100 549.304 Licer�ses, F�s & PertnNs 2,323 3,000 3,000 1,624 3,000 2,500 2,500 549.311 Marine UnR Operatlons 1,671 3,000 3,OW 1,221 3,000 1,750 1,750 549.314 ICE.Y.S. Pragram 0 2,500 1,000 700 1,000 549.401 R�auitmerrt expense.s 5,457 0 0 0 0 551.300 Oflice Suppll� & EqwpmeM 5,085 5,000 5,000 4,175 5,000 5,000 5,000 551.301 Come Prever�ion Suppli� 3,014 4,000 4,000 1,214 4,000 2,500 2,500 552.301 Ges 8 00 &5,735 70,000 60,000 41,085 60,000 83,000 63,000 552302 Small Tools and Eq�pment 11,299 9,000 9,000 6,237 16,000 72,000 72,000 552.305 Uniforms 20,308 20,000 20,000 16,017 ZD,000 18,000 18,000 554.300 Bool�, Publ, Subs & Membership 1,760 4,000 4,000 1,929 3,000 2,400 2,4W Operetlng FxperMitureslExperise 378,334 434,60U 511,687 298,920 523,253 432,600 418,550 0 Acct Class: 590 Otlier Flnenang Sources 8 Uses 599.100 Budget Cost Sav6igs 0 6,460 0 0 0 Other Finericing Sources & Usea 0 6,460 0 0 0 0 0 0 Acct Cleas: 600 Capitel Outlay 663.710 Pallce Depertment Capfml ProJ 10,710 0 2,333 2,333 2,333 864.600 MaddEquipmeM 26,129 0 232,926 0 232,926 664.601 Computer Equipmant 3,265 0 0 0 9,000 664.602 Vehl�d� fi3,751 60,000 80,000 0 80,000 240,000 240,000 664.6201ntengible-Softxrare 0 0 0 0 0 BUDGET WORKSF�EET DRAFT Page: 15 7/31/2014 Vlllage of Tequ�la 11:26 am Prlor Currerrt Y�r (6) (� (8) Year OrigMel Amend� Aclual Tfw Estinmted Mordh:7/31/2014 Actuel Budget Budget JWy Tatal DEPARTMENT NUWAGER COUNCIL Fumi: 001- General Furb Expendihir� Dept 175 Po�ce Deparlmerrt Cepflal0utley 103,855 60,000 �5,259 2,333 304,259 240,000 240,000 0 Pa�ce Departrnent 2,807,730 2,785,490 3,110,421 2,154,849 3,0&5,235 3,101,980 2,903,7� 0 Dept 180 Building & Zon6ig Acct Class: 510 Personal Servit�s 512100 Ra�War Satari� 8 Weges 172,988 45,300 45,300 37,054 52,820 194,900 205,2� 515.103 Bonus Pay Plan 0 0 0 0 0 515.106 Clothtng 8 Boot Allowence 0 0 0 0 0 700 515.107 Pert-thne Selaries 28,238 0 20,130 11,347 12,500 16,900 38,800 516.1U0 CompenseUedAbsenc� 609 0 0 0 0 516.105 Compen�ted A�enc� - HSA 1,490 0 0 0 0 521.101 FICA Taxe.a 9,253 2,800 4,040 2,975 4,040 6,900 14,800 521.102 MedicareTaxes 2,164 700 960 896 960 1,700 3,500 522.101 FRS ConMbutlons 4,430 0 0 0 0 522.102 VOT Per�sion Contributlons 4,239 4,200 4,200 3,402 4,850 9,500 17,300 523.101 LifeM�ifh Insurance 15,072 9,100 9,700 7,573 9,015 14,700 30,000 523.105 HSA- H�Ith Savings Accowt 1,000 0 0 0 0 524.100 Workers' Comp Insurance 373 160 160 158 158 160 1 W 525.100 UrremploymentCompensatlon 0 0 504 3,209 3,209 1,000 1,000 554.301 PersonneiTraining 295 1,500 0 0 0 Personal SeMc�s 188,131 83,760 84,394 66,414 87,552 245,7� 310,860 0 Acct Class: 530 Operatlng FxpemllhuaglExpense 531.301 Laa�al Servic�s 0 0 2,020 1,948 2,020 26,000 28,000 531.320 Code Fsforcemerrt Service 0 0 0 0 0 4,000 4,000 531.325 Inap�tlon Services 721,864 160,680 139,050 131,103 164,000 75,000 75,000 534.300 Other CoMiachiei Servic� 4,140 0 9,000 9,000 9,000 6,000 6,000 540.300 Travel & Per Dfem 586 1,170 0 0 0 500 500 541.300 Communiratlon Servfces 2,568 3,240 2,650 2,118 2,650 3,OW 3,OW 541.301 Pos�ge 1,416 1,500 1,500 349 1,500 1,OOD 1,000 543.300 UtllityServicea 5,992 6,500 6,190 4,315 8,100 6,000 8,OQ0 544.301 Operatlng Leeses 1,803 1,910 1,810 1,566 1,875 1,850 1,850 546.301 Office EquiplRepeir 8 Melnt 1,036 1,500 1,000 657 1,000 1,000 1,000 546.303 Bullding Rapelr & Malr� 0 0 0 0 0 546.320 Computer system meint 8 suppli 3,�3 14,409 11,410 9,956 11,�0 13,500 12,6� 547.300 PriMfig 8 Blnding 853 1,000 1,000 532 1,�0 1,500 1,500 549.300 Other ANsc Chgs 8 Oblige8ons 145 600 600 601 600 600 600 549.304 Licenses, Fees 8 PermNs 7,339 1,400 1.436 1.435 1,435 1,700 1,700 551.300 Offlce Suppli� 8 Equipment 2,435 3,000 3,000 1,555 3,000 3,000 3,000 BUDGET WORKSt�ET DRAFf Pege: 16 7/31/2014 Vlllege af T�ueste 1126 em Prlor CurrentY�r (6) (n (8) Y�r OrigMel Amended Aclual Tfw Estlmated Mor�:7/37/2014 AcWal Budget Budget JWy To1el DEPARTMENT MANAGER COUNCa Furb: 001 - Gene�al Fund Expen�r� Dept 180 Buitding 8 Zonim� Acct Cless: 530 Operatlng Expendihu�lExperise 554.300 Books, Publ, Subs 8 Mem�rship 880 1,250 950 940 940 500 500 Operatfig Expendlhu�lExpense 148,751 198,150 181,716 186,075 206,480 145,150 144,250 0 Acct CIa9s: 600 Cepitel Outlay 664.600 MechlEquipmeM 0 0 0 0 0 864.601 Computer Equipment 0 0 0 0 0 684.620 Irdangible - Software 0 0 0 0 0 Capifal0utlay 0 D 0 0 0 0 0 0 Buildhig&Zonir�g 336,�2 281,910 266,110 232,489 294,032 390,910 455,170 0 Dept 192 Fhe Control Axt Ciass: 510 Personel Services 512.100 R�ularSatada8ddeges 1,407,129 1.451,400 1,458,150 1,195z68 1,458,150 1,493,800 1,493,600 514.100 Overtlme 45,586 56,100 51,600 50,677 51,60D 56,800 58,800 514.300 Overtime-Treining 9,685 19,800 19,800 9,749 18,500 19,500 19,500 515.101 Holidey Pey 47,849 49,200 49,643 45,247 48,643 49,700 49,7�0 515.103 Bonus Pey Plan 0 0 58,5�0 58,500 58,500 515.107 PaR-ttme Salari� 39,207 50,400 50,400 3Z907 48,500 50,900 50,900 515.110 InOem Ftre Flghter Pay 58,429 58,700 58,700 46,900 57,700 61,200 67,200 515.120 Cell phone allowance 1,200 1,200 1,200 1,000 1,200 1zOD 1,200 515.125 OtherAllowancas 1,200 3,600 3,600 3,000 3,800 3,600 3,600 516.100 Compen�Ued Absenc� 3,297 3,600 3,600 1,420 3,600 19,800 19,600 518.10.5 Compensa0ed Atuen� - HSA 26,780 0 0 0 0 527.101 FlCA Tax� 96,015 102200 103,862 84,386 102,650 106,500 108,500 521.102 M�ipre Tax� 71,455 23,900 242&9 19,735 23,780 24,900 24.900 522.102 VOT Per�sion Contributlorre 343,772 345,500 356,000 293,709 356,000 348,600 348,600 522.110 Other Pension ConMbuUons 117,996 154,700 118,000 0 118,000 118,000 118,0� 523.101 LlfelHealffi Irowance 205,908 221,700 210,087 175,151 208,815 180,OU0 180,000 523.105 HSA- H�Ith Savir�gs A�wt 24,300 0 0 0 0 524.700 Workers' Comp Insurance 55,9q 55,660 55,660 55,654 55,654 55,860 55.660 525.100 UnemploymerrtCompensetlon 0 0 0 0 0 526.101 Employee R�ognitlon Program 0 2,930 2,930 1,228 2,200 2,950 2,850 526.103 Educetlon Reimburaemem Prgm 9,178 15,400 15,400 12,026 15,400 19,900 19,800 526.104 ICMl�Def Comp Plan 0 0 1,620 743 1,620 4,900 4,800 526.1Q5 EmployeePhysicaVPsycnlogical 8,912 9,870 9,870 8,353 9,500 9.900 9,900 554.301 Per�nnel T�ainfng 2,589 9,070 9,070 2,532 8,100 9,200 9200 Personel Servic�s 2,527,428 2,634,930 2,861,981 2,0�,185 2,850,512 2,636,610 2,638,610 0 Acct Class: 530 Operatlng ExperMiture.vlExperree 531.318 Volunt�r Flre Flghter Program 5,448 7,780 7,680 2,829 7,500 BUDGET NIORKSF�ET DRAFT Page: 17 7/31/2014 Vl�age of Tequ� 1126 am Prior CurtamYear (6) (n (8) Year Orighial Amend� Actual Thru Eatimmeted Morrth:7/31/2014 Nctuel Budget Budget July Totel DEPARTMENT MANAGER COUNC� FurM: 001- General Fund ExpentDh�r� Dept 192 Fue CaMrol Acct Class: 530 Opeiatlng Ex�rMihir�lExper�se 540.300 Travel 8 Per Diem 1,232 5,930 955 &51 955 5,300 5,300 541.300 Communicetlon SeMces 14,439 13,060 12,058 11,380 12,058 13,700 13,700 541.301 Posfage 1,482 1,500 1,500 1,149 1,500 1,500 1,500 543.300 Utllfly Servit� 27,400 27,800 28,802 72,073 27,500 30,650 30.fi50 544.301 Operatlng Leas�v 7.841 7,920 7,920 4,618 7.796 5,760 5,760 545.3W Insurence 24,489 21,900 21,800 21,738 21,900 21.900 21,900 546.302 Vehlcie Re�ir & Meiritenance 8,123 5,670 5,670 2,477 5,200 4,700 4,700 546.303 BuildhigRe�ir&MefM 21,888 23,610 �.710 20,994 26,7D0 25,450 25,450 546.310 Equlpmerd Re�tr 8 MaiM 21,478 22,020 22,020 15,216 22,020 23,250 23a50 546.320 Computer system mafM 8 suppll 13,803 19,500 19,500 73,90{1 19,500 32,800 28,900 547.300 Pitritlng & Bind(r�g 892 1,420 1.42(1 742 1,300 1,450 1.450 549.300 Other Misc Chgs & Ob�gatlons 4,198 3,200 3,200 1,598 3,100 3,850 3,850 549.304 Licenaes, Fe� & Permifs 17,104 17,590 17,590 14,770 17,100 18,850 18,850 549.311 Marine Unft OperaUons 1,650 5,370 4,734 902 3,5W 3,900 3,900 549.397 Bad Debt Expense T/,504 0 0 0 0 551.300 Office Supplfes & Equfpment 2,866 2,790 2,790 2,248 2,600 2,700 2.700 551.302 Flre Prevention Educatlon 2,268 2,310 2,310 1,280 2,3Q0 2,350 2,350 552.301 Gea 8 0� 14,812 19,920 19,920 12,70.3 16,500 17,700 17,700 552.302 Small Twls end Equipment 0 2,920 2,920 2,259 2,920 3,250 3,250 552304 Chemicals 950 990 990 950 950 1,OW 1,000 5523Q5 Unfforms 11,892 23,310 23,310 14,935 23,000 23,350 23,350 552308 SefetySupplles 8,8'19 21,000 20,258 8,332 18,500 21,700 21,700 552.310 DlsasterRelleFSuppli� 0 5,300 5,300 0 4,500 5,300 5,300 552.311 CPR Program Suppli� 316 400 500 500 500 550 550 552.312 Medical SuppQes 37,799 37,200 37,200 27,102 37,000 �,000 38,UU0 552.344 Flre Stadon Suppli� 2,384 3,000 3,000 1,893 2,800 3,OD0 3,000 554.300 Books, Publ, Subs 8 Membershlp 2,519 3,050 3,050 2,296 3,050 3,300 3,300 Operatlng Expenditur�lExper�se 333,�6 306,460 306,207 209,713 292a49 315,2W 309,360 0 Acct Class: 590 Other Fnandng Sources & Us� 599.100 Budget Cast Sevfngs 0 58,140 0 0 0 Other Flnendng Sources 8 Uses 0 58,140 0 0 0 0 0 0 Aoc! Class: 800 Cepital Outlay 664.600 MechlEquipmeM 8,604 432,850 540,080 540,080 540,080 22,000 22,0� 664.6201ntengible-Softxrare 0 0 0 0 0 Capitel0utlayr 8,804 432,850 540�080 540�080 540�080 22,000 22,000 0 Flre Coritrol 2,869,328 3,432,380 3,508,2� 2,847,978 3,482,841 2,973,870 2,967,970 0 Dept 210 Pub�c Worl� BUDGET WORI(BF�ET DRAF'f Pege: 18 7/31/2014 Wlage of T�u� 1126 em Pdor Curtent Y�r (6) (n (8) Yeer Original Amend� AcWal Thru Eatlmated Month:7l37I2014 Achiel Budget Budget JWy Total DEPARTMENT MANAGER COUNCIL Furb: 007 - General Fu� Fxpen�tures Dept 270 PublicWarks Acct Clase: 510 Per�nal Services 512100 RegularSaleriesBWages 183,951 196,300 188,100 156,988 187,000 183,100 183,1� 514.100 Overtime 919 1,000 1,000 211 1,000 1,000 1,OU0 515.103 Bonua Pay Plan 0 0 1,5� 1,500 1,500 575.108 Ciathhig fl Bmt Alloxrence 400 550 550 550 550 550 550 515.107 Pert-time Salari� 11,835 19,800 19,800 14,985 18,010 20,200 20,200 515.108 AutoAllowance 750 900 1,800 1.500 1,�0 450 450 518.100 Compensat� Absences 0 0 15,387 756 18,772 516.10.5 Com�nset� Absences - HSA 0 0 0 0 0 521.101 FICATaxes 11,171 12,400 13,600 10,040 73,800 17,909 11,800 521.102 Medi�reTax� 2,813 2.900 3,185 2,348 3a35 2,800 2,800 5?2.107 FRSConMbudons 5,317 7,800 9,125 8,954 9,125 572.102 VOT Per�sion Cmitributlor�s 10,572 12,000 12,000 9,420 12,000 15,500 15,500 523.101 LffelHealth Insurance 66,539 74,909 64,123 56,842 64,1Q0 54,600 54,600 523.10.5 HSA- H�Itli Savings Aa;ount 850 0 0 0 0 524.100 Warkers' Comp Insurance 10,8T/ 17,180 17,180 17,173 17,773 17,180 17,1� Personal Servicea 30.5,794 345,73D 347,350 279,067 348,065 307,280 307,180 0 /uxt Cless: 530 Operetlng Expendfhir�lExper�se 531.302 Engln�dng Services 7,361 2,000 2,000 4,364 4,844 2,000 2,000 534.300 OtherCorrtactualServices 500 2,000 2,OW 480 1,000 1,OU0 1,000 540.300 Trevel 8 Per Diem 0 250 250 0 250 150 150 541.300 Commimicabon Services 4,205 4,000 4,000 3,827 4,500 4,000 4,500 543.300 U81ityServic� 90,793 90,000 90,000 73,110 98,000 112,000 112,000 543.301 Street Ligh� 124,847 120,000 120,000 99,964 133,285 125,W0 135,000 544.301 Operetfig L�s� 1,125 1,200 1,200 855 1,209 1,200 1,200 544.304 FEC Leese 11,185 14,150 14,150 74,031 14,031 14,650 14,650 545.3001nsurence 14,333 10,500 10,500 10,463 10,463 70,500 10,500 546200 R8M - Stetion 11 2,011 2,500 2,500 0 0 2,500 2,500 546.301 Offlce Equlp/Repelr & Maint 105 200 200 57 200 200 200 546.302 VehlGe Repair & Meintenance 2,627 4,000 4,OW 1,586 4,000 4,000 4,000 546.303 Bulldit�g Repalr& Melnt 26,896 8,000 9,500 9,263 11,000 12,000 12,OW 546.30.5 PalhevayMehrtenance 7,410 10,000 70,000 2,962 10.000 12,000 72,000 546.308 General Mairder�ance 71,107 30,000 30,000 18,108 30,�0 30,OD0 30,000 546.309 Lendscape 8 Ir�getlon Maint 133,549 132,000 132,Q00 93,p8 132,000 137,000 137,000 546.310 EquipmeM Re�U & Mefnt 9,424 11,000 11,W0 8,301 11,000 11,000 11,000 546.320 Computersystemmaint&suppli 293 1,100 1,100 306 1,100 1,700 1250 546.350 R& M- Roads 23,006 25,000 25,000 13,959 25,OU9 30,000 30,000 BUDGET WORKSF�Er DRAFT Page: 19 7/31I2014 Vlllage of Tequ�la 1126 em Prior CurreM Y�r (6) (n (8) Yeer Origimal Amended Ach�el Thru EstlmaOed Mordh:7l31l2014 Achiel Budget Budget July Tatel DEPARTMENT MANAGER COUNC� Fu�: 001- General FurM Fxpenmtures Dept 210 Pubuc Workg Acxt Class: 530 Operatlng ExpenditureslExpense 549.300 Other Misc Chgs 8 Obligetlona 2,902 4,000 4,000 1,173 3,500 3,500 3,500 549.304 Licens�, Fees 8 PertnlLa 1,957 4,500 4,500 1,4� 1,500 1,500 1,500 �1.3W Olflce Supplie,v 8 Equipment 97 450 450 133 450 450 450 551.400 JaNtorial Supplies 5,416 5,500 5,500 4,706 5,500 6,000 6,000 552301 Ges 8 Od 7,378 6,000 6,000 5,748 6,000 8,000 6,W0 552.302 Small T�Is arb Equipment 4,212 1,500 9,500 4 1,500 3,000 3,000 5523Q5 Uniforms 1,257 2,000 2,000 1,215 2,000 2,000 2,000 553.301 Road Signs 1,169 2,000 2,000 1,346 2,000 2,500 2,500 563.600 PubQc Worlca Misc PioJeds 0 5,500 4,000 2,46'8 4,000 5,500 5,500 Operatmg ExperMftureslFxper�se 495,165 499,350 499,350 373,497 518,323 541,350 551,400 0 Acct Ciess: 590 Other Flnendng Sourc� & Us� 599.100 Budget Cost Savings 0 1,620 0 0 0 Other Flnandng Sourt�s 8 Uses 0 1,620 0 0 0 0 0 0 Axt Class: 6W Capitel Outlay �'r1.6W MachlEquipmsM 0 0 0 0 0 15,000 15,OW 864.602 VeMdes 0 0 0 0 0 60,000 60,000 Capilal0utlay 0 0 0 0 0 75,000 75,000 0 Public Works 800.959 846,700 846,7D0 652,564 886,388 923,630 933,580 0 Dspt 231 Leisure Services Acct Class: 510 Personal Servic�s 512.1U0 R�ular Salariea & Wages 759,395 759,700 159,700 730,692 159,400 163,600 163,6U0 515.103 Bonus Pay Plan 0 0 6,000 6,OU0 8,000 515.106 Clothhig & Boot AVowance 100 100 100 100 100 100 100 515.107 Part-time Selerles 40,150 45,100 45,100 33,251 42,ZOD 47,300 47,300 515.108 AutoAllowance 3,000 3,000 3,W0 2,500 3,000 3,000 3,000 515.109 Seaconal Salades 8 Weges 24,�8 30,000 30,000 16,054 24,000 30,000 30,000 516.100 Compensa0ed Al�enc�s 3,629 3,500 3,500 6� 1,515 4,000 4,000 576.1Q5 CompensaOazlAbsen�-HSA 3,108 0 0 0 0 521.101 FlCA Texes 13,532 14,400 14,648 10,966 13,300 14,800 14,800 521.102 M�IcareTax� 3,165 3,400 3,458 2,5&5 3,100 3,500 3,500 522.102 VOT Per�sion Contrlbutlor�s 14,951 14,800 14,800 11,997 14,635 13,800 13,800 523.101 LffelHealth Ir�surance 39,585 42,700 42,700 35,643 42,530 36,400 36,400 523.105 HSA - H�kh Sevings Acxount 3,400 0 0 0 0 524.100 WorkeB' Comp Insurence 8,184 7,110 7,110 7,100 7,100 7,110 7,110 525.100 UrremploymeM Compensatlon 0 0 0 0 0 526.105 Employee PhysicaVPsycological B08 2,500 2,500 607 2,500 2,500 2,500 554.301 PewonnelTraining 535 1,200 1,200 0 1,200 1,200 1,200 BUDGET WORKSHHEETT DRAFT Pege: 20 7/37@074 Viilage of Tequ�la 71:26 am Pdor CurteMYear (6) (� (8) Y�r Odginal Amend� Ach�el Thru Estlm�ed Mmdh:7131@014 Ach�al Budget Budget July Totel DEPARTMENT MANAGER COUNCd FurM: 001- General FurM ExpendiWres Dept 231 Leisure Servit�a Per�nal Servicea 378,149 327,510 333,818 258,113 320,580 327,310 327,310 0 Aa� Ciasa: 530 Operating ExpendlhueslExper�se Si4.303 Spedal EveMs 77,�9 20,878 40,578 40,578 40,578 45,000 45,000 540.300 TravelBPerDlem 0 1,500 1,500 0 1,500 1,500 1,500 541.3� Communic�tlon SeMces 5,402 5,700 5,854 5,119 5,800 5,700 5,700 541.301 Poslage 48 150 150 25 150 150 150 543.3W UtlIHy Serviccres 11,174 14,000 14,000 8,381 12,000 14,000 14,000 545.300 Insurance 14,396 14,500 14,500 14,494 14,494 14,500 14,500 546.302 Vehide Repair 8 MeNtenence 3,715 3,200 3200 390 3,200 3200 3,200 546.303 Buildtrig Repalr & Matrrt 18,872 20,000 27,484 20,351 27,484 Z0,000 2D,000 546.306 General Melr�Genar� 35,615 30,000 30,000 21,382 30,000 30,000 30,000 546.310 Equlpmem Repair 8 Maint 1,307 1,700 1,700 801 1,700 1,700 1,700 546.320 Computer system meint & suppli 2,004 1,700 4,084 3,336 4,064 4,000 2,650 549201 Advertlsing & Promotlon 9,454 5,000 4,546 4,546 4,548 5,OOD 5,000 549.300 Other Misc Chgs 8 Obligatlons 1,525 5,000 2215 287 2,215 5,009 5,000 549.304 Licens�, Fees & PertnBs 1,913 2,200 2,200 7,762 2,200 2,200 2,200 549.332 R�r�tlon Pmgrem Expense 35,031 �,300 37,415 32,681 37,415 �,300 38,300 549.333 SpdnglSummerCamp 15,�1 15,000 15,000 7,222 15,000 15,000 15,000 551.300 Olfice Supplia9 & Equlpment 2,041 2,000 2,000 1,192 2,000 2,000 2,000 551.315 Conc�sion Suppll� 4,851 5,000 2,488 2,498 2,498 5,000 5,000 5523D1 Gas & Ofl 1,928 2,500 2,5U0 1,563 2,50U 2,500 2,500 552302 Small Tools and EqulpmeM 1,500 1,500 1,500 707 1,500 1,500 1,500 552305 Un(forms 159 500 500 45 500 500 500 554.300 Books, Publ, Subs 8 MembersMp 2� 500 500 0 500 500 500 Operetlng ExpendihireslEx�ruse 243,783 190,828 213,904 187.340 211,844 217,250 215,900 0 Acxt Class: 590 Other Flnendng Sourc�s & Us� 599.100 Budget Cost Sevings 0 6,460 0 0 0 Other Flnandng Sources 8 Uses 0 6,4&0 0 0 0 0 0 0 Acct Class: 600 Cepital 0utlay 664.600 MechlEquipmsM 0 0 7��0 1,200 1,200 Cepitel0utley 0 0 1,200 1,200 1,200 0 0 0 Lelsura Servicag 561,942 524,798 548,920 426,853 533,624 544,560 543,210 0 Dept 700 Debt SeMce Acct Class: 471 DIS - Prind�l 571.706 P/S Prin - BOA - P/S Bldg 247,809 258,700 258,7U0 214,751 258,700 269.920 269,920 571.708 P(S - Prin - SunTrust- Pumper 0 35,930 51,600 47,7&5 47,785 38,810 38,870 571.710 PIS Prin - 2015 PD Vehicl� 0 0 0 0 0 76,830 76,830 571.712 2015 PubOc Wort� Vehicl� 0 0 0 0 0 11,070 BUDGET WORKSF�EEf DRAFT Pege: 21 713112014 Vlllege of T�u� 1128 am Prior Curterrt Year (6) Cn (6) Ye� Odgtr�al Amended Achiel Thru EsUrr�at� Month:7l3112014 A�al Budget Budget July Tofel DEPARTMENT MANAGER COUNCIL Fund: 001- General Fund Expendiwres Dept 700 DebtService Acct Class: 471 D/S - Prfid�l 577.725 Prin - 2012 Ford Foais - Admin 0 0 0 0 0 571.728 Prfi. - CTS Smert Cop Le�e 0 0 0 0 0 D/S - Prindpel 247,8D9 294,630 310,300 262,536 306,485 385,560 3.98,630 0 Acct Cless: 472 D/S - Irnerest 572.706 P/S - IM. BOA - P.S Bldg 124,692 113,900 113,900 95,887 113,900 102,590 102,590 572708 P!S-SunTrust-Pumper 0 16,670 7,000 350 350 9,340 9.340 572770 2015 PD Vehid� 0 0 0 0 0 8,210 8,210 572712 2015 PubGc Worka Vehicles 0 0 0 0 0 2,200 5727251M.2012FordFocus-Admin 362 200 200 166 200 20 20 DIS-Inter�st 125.054 130,770 115,100 96,183 114,450 120,160 171,360 0 DebtService 372,8q 425,400 425,400 358,719 420,835 505,720 518,990 0 Dept 900 IMerGmd Trarrefers Acct CIaa9: 581 Irderfund Tranafers Out 591.301 Trsf to Capital Imp Fund 0 0 0 0 0 Interfund Trensfers Out 0 0 0 0 0 0 0 0 InlerfurM Transfers 0 0 0 0 0 0 0 0 Dept 970 Ofher Finandng Sources & Us�v Acct Clasa: 590 Other Finan�g Sources 8 Uses 567.100 Unr�ib.ed Loss on Investrner�ts 0 0 0 0 0 Other Flnenang Sourc�s & Uses 0 0 0 0 0 0 0 0 Other Flrrendng Sources & Uses 0 0 0 0 0 0 0 0 Dept 950 Ofher Nanoperatlng Acct Cless: 590 Other Flnandng Sources 8 Us�s 549.391 Bank Charges 10,150 11,000 11,000 7,783 11,000 11,000 11,OU0 548.395 Cr�ft Cerd F� arM Charge.s 1,720 2,500 2,500 1,801 2,500 2,800 2,8U0 590.001 Allo�te b Fund Balance 0 0 0 0 0 999.001 Suspense 0 0 0 1,000 0 999.002 Suspense - Payroll 0 D 0 0 D 999200 Suaper�se - AIP 0 0 0 0 0 Other Flnandng Sourt�s 8 Uses 11,870 13,500 13,500 10,584 13,500 13,800 13,800 0 OtherNonoperatlrn� 11,870 13,500 13,500 10,584 13,500 13,800 13,8U0 0 Dept 990 OlhedReservelCordingenc.y Acct Cless: 590 Other Finan�g Sources 8 Uses 599.902 Reserves-Cor�tlngency 0 0 0 0 0 91,539 Other Finandng Sources & Uses 0 0 0 0 0 0 91,538 0 OthedReserve/Cor�dngen�y 0 0 0 0 0 0 91,539 0 Totel Expendih�res 8,287,823 9,873,778 10,308,796 8,004,007 10,364,164 10,138,890 10,111,549 0 BUDGET WORKSHEET DRAFT Pege: 72 7l31I2014 Village of Tequesla 1126 am Prlor CuReMY�r (6) (� (8) Year Origtr�al Amend� Achial Thru Estlmet� MoMh:7131/2014 Ach�al Budget Budget Juty Tofel DEPARTMENT MANAGER COUNC� Gerreral F�md 55.338 0 0 1.011,244 �17,194 -139,441 �7,600 0 BUDGET WORKSl�EET DRAFT Page: 23 7/31Y1014 1/mege of Teques� 11:26 em Prlor CurteMY�r (8) (n (8) Year Originel Amend� AcWel Tlvu Estlmeted Mordh:7/31Y2014 Acwal Budget Budget July Total DEPARTMENT MANAGER COUNCIL Fu�: 301- Capitel Improvemerit Fund Revenu�s Dept 000 Generel 9axx� Cleas: 366 Contributlor�s 8 Donetlorre �6.10D ConMb & Donetlons 8 Spor�rs 0 0 0 0 0 ConMbutlore 8 Donatlor�s 0 0 0 0 0 0 0 0 Acct Class: 369 Mlacellan�us Revenu� 369.000 Olher Miscelleneous Revenue 0 0 0 0 0 M4vicellaneous Revanu� 0 0 0 0 0 0 0 0 General 0 0 0 0 0 0 0 0 Dept 900 irderfund Tronsfers Acct Cless: 391 Trensfers In 381.001 Transfer from General Fund 0 0 0 0 0 381.303 TsfeNn from Capilal ProJ�ts 0 0 0 0 0 Transfers In 0 0 0 0 0 0 0 0 Imerfund Trensfers 0 0 0 0 0 0 0 0 Dept 950 Other NonoperaUng Acct Class: 361 Unrestricted Irn�4nent Eamin 361.100 Irtler�fllnv�hneM Eamings 0 0 0 0 0 Unrestricted Imeshnent Eamin 0 0 0 0 0 0 0 0 Other Norroperatlng D 0 0 0 0 0 0 0 Dept 990 OthedReservelCmidngency Acd Ciass: 390 Other Flnendng Sour� 399.999 AppropriaGe Fund Belence 0 100,000 100,000 0 100,000 Other Fnendng Saurces 0 100,OQ0 100,000 0 100,000 0 0 0 OthedReservelCor�tlngency 0 100,000 100,000 0 100,000 0 0 0 Total Revenu�v 0 100,000 100,000 0 100,000 0 0 0 E�endfhu� Dept 900 InherTund Trensfers Acct Class: 591 Irderfur�d Tranafers Out 591.001 Transfer to Gsrreral Fund 290,440 100,000 100,000 100,000 700,000 Irderfur�d Transfers Out 290,440 100,000 100,OW 100.W0 100,000 0 0 0 Irdertund Trerisfers 290,440 100,000 100,OOD 700,000 100,000 0 0 0 Total Expend(h�res 290,440 100,000 100,000 100,000 100,000 0 0 0 Cap(tal Improvement Fur�d -280,440 0 0 -100,000 0 0 0 0 BUDGET WORK9F�ET DRAFT Pege: 24 7/31@014 Vmege aF T�uesta 11:26 am Prior CurtentY�r (8) (� (8) Y�r Odgirol Amend� Acluel Thru EstlrtreGed Month:7/31/2014 Aciuel Budget Budget JWy Tatel DEPARTMENT MANAGER COUNCd FurM: 303 - Cepflel Projects Furb Revenu� Dept 990 OthedR�vervelContlngency Acct Class: 390 Other Flnandng Sourca9 399.999 Apprapria�e Fund Balence 0 50,000 50,000 0 50,000 Other Flnendng Sources 0 50,000 50,000 0 50,000 0 0 0 OthedRaservelCor�tlngenc,y 0 50.00D SO,OW 0 50,000 0 0 0 Total Revenu� 0 50,000 50,000 0 50,000 0 0 0 Fxpendihira Dept 399 Misc ProJ-Generel Acct Ciass: 530 Ope�atlng ExperMihueslExper� 546.311 FEC T�adc Metrihenance 78,211 0 0 0 0 Operetlng Expenditur�lExper�se 78,211 0 0 0 0 0 0 0 Misc Pro}Generel 78,211 0 0 0 0 0 0 0 Dept 900 Irtlerfund Transfers Aax Cless: 591 Interfund Transfers Out 591.001 Transfer to Generel Fund 80,000 50,000 50,000 50,000 50,000 591.301 TrsFro Capilal Imp Fund 0 0 0 0 0 Inherfurtd Transfera Out 80,000 50,000 50,000 50,000 50,000 0 0 0 Interfund Transfers 80,000 50,000 50,000 50,000 50,000 0 0 0 Total F�cpendiNr� 158,211 50,000 50,000 50,000 50,000 0 0 0 Capital Projects Fund -158,211 0 0 -50,000 0 0 0 0 BUDGET WORKSF�ET DRAFT Pege: 25 7/31/2014 Villege of Tequ� 1126 em Prior CurreM Y�r (6) (� (8) Year Odginal Amended AcWal Thru Estlmat� Mmdh:7137l2074 Ach�al Budget Budget July Totel DEPARTMENT MANAGER COUNCa Fumf: 401- Weter Fund Revemi� Dept 000 Genaial Aat Class: 340 Charg� for Servi� 342501 Site Plan Review Fea4 0 500 500 0 0 343.301 WaterSel� 2,729,978 2,375,000 2,375,000 1.718,512 2,250,000 2,300.OW 2,300,000 343.302 Water- Conne�t Cherges 17,995 15,000 15,OW 19,000 18,623 17,000 17,000 343.303 Weter-Flre Hydrards ReM 64,268 65,000 65,000 54,642 65,000 66,300 86,300 343.304 Weter Surcharye 367,277 380,000 380,000 277,�2 375,000 382,500 �2,500 343.308 Morrthly Service Cherge 1,385,257 1,485,OU0 1,485,000 1,1p,151 1,395,000 1,423,OW 1,423.000 343.307 Per�altyCharges 5,002 4,500 4,500 4,2� 4,500 4,500 4,500 343.308 OfherWeterServicelncome 1,541 1,500 1,500 1,323 1.500 1,500 1,5� 343.309 Convenience Fee - CC 0 500 500 0 0 343.700 Weter Conserv�lon 8 R�urce 1,514 1,000 1,000 913 1,000 1,000 1,000 343.950 Allow for doubful rev - Enterp 0 0 0 0 0 Cherg�forServicas 3,986,832 4,328,000 4,328,000 3,238,971 4,110,623 4,195,800 4,195,800 0 Acct Class: 369 Miscellenea� Revenuag 363.101 MertlnlTrapicV�onstpar�on 23,145 15,900 15,900 34,298 17,727 16,000 16,OU0 369.000 Other Misoe�an�us Revenue 0 0 7,455 7,463 7,5W 369.700 Insurence ReimbursemeM 8,361 8.000 8,000 7,863 7,863 8,000 8.000 Miscellan�us Revenu� 31,506 23,900 31,355 49,624 32,490 24,000 24,000 0 Acct Ciess: 390 Other Finenar�g Sour� 369.110 Capital Connect Charge - Cuat 20,581 20,000 20,000 7,304 7,304 369.111 Capifsl Connect Charge - Devsl 10,709 12,000 12,000 34,894 16,434 389.112CapitalConnec[-TropicVist 2(1,633 14,200 14,200 0 15,268 14,000 14,000 Other Flnandng Sour� 51,923 46,200 46,200 41,9� 39,W6 14,000 14,000 0 Gerreial 4,050261 4,398,100 4,405,555 3,330,593 4,182,119 4,233,800 4,233,800 0 Dept 950 Other Nonopeiatlng Acct Ciess: 361 UnresMct� Imestrnerrt Eemin 361.100 InUerestllnv�6meM Eamings 11,189 10,000 10,000 7,98U 7,980 9,500 9,500 361.105 Ir� Income - Tropic Viste Asse 0 0 0 0 7 387.100 Net Unreal eppr�letlon (Dep) 7,356 0 0 2,510 0 UnreshicUed Im�trnent Eemin 18,545 10,000 10,000 10,490 7,987 9,500 9,500 0 Acct Class: 389 Mlacellen�us Revenu� 364.100 Disposltlon of Assefs 5,510 0 0 0 0 Miscellan�ua Revsnu�s 5,510 0 0 0 0 0 0 0 Other Norroperatlng 24,055 10,000 10,000 10,490 7,987 9,500 9,500 0 Dept 990 Ofher/ReservelCantlngenq Acct Cless: 390 Other Flnencir�g Sourc� 388.999 Approprla6e Fund �lence 0 0 837,621 0 0 691,120 6'98,220 Other Flnandng Sources 0 0 837,621 0 0 691,120 698,220 0 BUDGET WORKSHEET DRAFT Pege: 26 7l31I2014 Vfllege of Tequeate 7126 em Prior CurreM Y�r (6) (� (8) Year Odginel Amend� Acwel Tfw E� Month:7131/2014 AcWal 8udget Budget July Tofal DEPARTMENT MANAGER COUNCd Fund: 407 - WaOer Fund Revenu�v OthedReserve/ConUngency 0 0 837,621 0 0 691,120 698,220 0 Total Revenu� 4,074,316 4,406,100 5,253,176 3,341,�3 4,190,106 4,934,420 4,941,520 0 ExpendiWres Dept 241 Weter-AdminisheUon Acct Cless: 510 Per�nel Servic�v 512.100 R�uler Salari� & Wages 138,413 139,700 139,700 114,308 139,415 162,300 162,300 515.103 Bonus Pey Plan 0 0 3,150 3,150 3,150 515.108 Auto Allowance 3,000 3,000 3,000 2,500 3,000 3,000 3,000 515.125 OtherAllowan� 1,200 1,200 1,200 1,OW 1,200 1,200 1,200 516.100 Compen� Abaenc� 1,753 5,000 5,818 4,613 9,070 13,500 13,500 516.105 Compensated Absencea - HSA 3,430 0 0 0 0 521.101 FICA Tex� 7,093 7,300 7,438 6,374 7,�0 8,700 8,700 521.102 MedicareTax�s 2,273 2,200 2,359 1,856 2.300 2,600 2,600 522.102 VOT Perelon Con6lbutlor�s 13,076 12,900 12,900 10,493 12,8(W 13,700 13,700 523.101 LffelHealth Insurar�ce 10,316 12,600 12,600 10,708 13,027 12,200 12,200 523.1Q5 HSA-H�IdiSavirn�sAccowt 1,400 0 0 0 0 524.100 Workers' Comp Ins�uance 411 310 310 309 309 310 310 526.104 ICMA-Def Comp Plan 9.826 9,900 9,900 8,057 9,830 10,300 10,300 554.301 Personnel Training 0 0 750 750 750 Per�nel Services 193,191 194,110 199,125 164,118 202,151 227,810 727,810 0 Acct Ciess: 530 Operetfig Expendilur�lExper�se 531.301 L�al Services 1,235 7,500 6250 1,692 2,500 2,000 2,000 531.302 Engin�dng SeMces 19,478 25,000 101,500 52,818 106,366 140,000 140,000 532.300 Accountlng & Auditlng SeMces 27,800 28,100 27,750 27,750 27,750 28,620 28,620 534.300 OtherContrachiel Services 21,850 24,000 24,500 17,740 29,000 21,000 21,000 544.304 FEC L�se 12,357 13,050 12,535 12,531 12,535 13,000 13,000 545.3001nsurence 48,770 47,600 47,600 48,886 48,986 48,050 48,050 549.301 Admin Mgmt Fe� 485,729 499,785 499,785 418,488 499,785 514,780 514,780 549.304 Licer�ses, Fees 8 Permits 781 800 800 781 781 800 800 Operarin9 Expendih�reslExper�se 615,5U0 645,835 720,720 578.784 727,703 7�250 768,250 0 Acet Class: 590 Other Flnandng Sources & Uses 599.tU0 BudgetCoffiSavings 0 3,400 0 0 0 Other Flnandng Sources 8 Uses 0 3,400 0 0 0 0 0 0 Water-Administratlon 808,691 843,345 978,845 742,902 9�.&54 996,060 996,060 0 Dept 242 Water- Productlon Acct Cless: 510 Personel Services 512100 Regular Saledes 8 Weg� 370,269 397,000 387,000 318,203 385,700 484,100 484,100 514.100 Overtlme 8,154 8,W0 9,000 5,310 9,000 9,000 9,000 BUDGET WORKSf�ET DRAFT Page: Z7 7/31/2014 Vmage of Tequ� 11:26 am Piior CurteMY�r (6) (n (8) Year Origirml Amended Achial Thru Estlmetsd Mo�h:7/31/2014 Actual Budget Budget July Totel DEPARTMENT MANAGER COUNCIL FurM: 401- WaUer Fund Expenditures Dept 242 Weter- Productlon Na3 Cless: 510 Pereonal SeM� 515.102 Stendby Pay 5,119 6,000 6,000 4,052 6,000 6,OU0 8,000 515.103 Bonua Pay Plan 0 0 3,000 3,000 3,000 515.706 Clothhig & Boot Mowence 600 600 600 6U0 600 800 800 516.100 Compenseted Absenc� 1,�8 5,000 5,000 2,622 5,000 5,000 5,0� 516.105 Compen�ted Absences - HSA 0 0 0 0 0 521.101 FlCATa�ce.a 23,487 25,400 25,400 19,510 25,400 30,100 30,100 521.102 M�irareTax� 5,493 6,000 6,000 4,5Ci 6,000 7,100 7,100 522101 FRS ConMbutlons 3,�0 3,900 5,000 3,932 5,OOU 5,200 5,200 522.102 VOT Per�slon Contributlorre 27,918 29,800 29,800 23,515 28,715 34,400 34,400 523.101 LffeMealth Inaurence 51,743 63,200 78,500 64,984 78,500 91200 91,200 523.10.5 HSA- Health Savings Aanurrt 1,700 0 0 0 0 523.110 Retlree Health Care Expense 0 0 0 0 0 524.100 Workers' Comp Insurance 11,270 12,870 12,870 72,866 12,866 12,870 12,870 554.301 Personnsl Training 395 1,500 1,500 1,314 1,500 2,000 2,000 Per�nal Services 571,�6 559,270 569,670 482,471 567,281 �7,770 �7,770 0 Acct Class: 530 Operatlng F�cpendiWr�lExpe�e 531.342 Water Malysis 8 Samplfng 33.472 48,530 48,530 25.511 40,000 44,000 44,000 540.300 Travel & Per Dlem 264 3,000 3,000 2,889 2,862 3,500 3,500 541.300 Communicatlon Servlc� 9,311 9,400 9,400 8,080 9,400 9,400 9,400 541.301 Poslage 836 1,500 2,500 1,157 2,500 2,Q00 2,000 543.300 UdIKy Servi� 325,275 394,000 343,930 244,452 340,009 357,000 357,000 544.301 Operatlng Leas� 10,240 9,400 10,800 9,140 10,W0 10,000 10,000 546.302 Vehide Re�U 8 Malydenence 4,295 3,000 5,000 4,030 4,030 4,000 4,000 546.303 BuildMg Repeir � Meirrt 14,582 �,500 28,500 15,495 25,000 Z0,000 20,Ot10 546.309 Lendsr�pe & Irrigatlon Malnt 4,632 3,009 18,000 17,503 18,000 6,000 6,000 546.310 EquipmeM Re�ir 8 Maint 14,054 28,000 73,490 22,086 73,490 20,000 20,000 546.320 Computer system malM 8 suppll 2,�8 8,400 8,400 2,958 8,400 11,000 9,200 546.342 Water System MaUiter�ance 711,718 70,000 90,965 53,340 70,000 70,000 70,000 546.343 We0 Redevelopmem �,785 30,000 49,000 12,998 49,000 80,OD0 80,000 547.300 Prindng 8 Binding 1,891 2,500 4,500 4,280 4,500 3,000 3,000 549.300 Other Misc Chgs & Oblige8ons 5,858 2,000 2,000 1,673 2,000 2,000 2,000 549.304 Licenses, Fe� & Pertnits 92,534 30,000 30,000 22,846 30,W0 30,000 30,000 551.300 Offlce Supplies 8 Equlpment 3,153 2,500 2,500 1,921 2,000 2,500 2,500 552.301 Gea&011 5,550 8,100 8,1�0 3,281 5,000 5,000 5,000 552.302 Smeil T�IS end Equlpment 1,615 3,000 3,000 936 2,500 3,000 3,000 552303 Dlesel Fue! 7,430 15,000 15,000 6,958 4,U00 15,000 15,000 BUD�ET WORKSF�ET DRAFT Page: 28 7/31@014 Vnlage of Tequesm 1728 am Prior CurreMY�r (6) (� (8) Y�r Origtrial Amended Achiel Tfw Estlmated Month:713112014 Achiel Budget Budget July Tatal UEPARTMENT MANAGER COUNCd Furb: 401- WeOer Fuml Fx�ndihires Dept 242 Weter- Productlon Acct Cla�: 530 Operatlng Expendihu�cpense 552305 Unlforms 1,494 1,500 2,500 2,123 2,500 2,500 2,500 552341 Weler Purchases 0 30,000 30,OW 0 0 30,000 30,000 552.342 WaterChemicels 133,731 188.000 178,100 113,308 760.000 168,000 168,000 552343 Le��atary SuppOe,v 15.891 14,000 14,000 12,242 14.000 14,000 14,000 554.300 B�Ics, Publ, Sut� 8 Memberahip 1,552 1,600 1,600 878 1,500 1,600 1,800 Operatlng Experbihir�lExper� 762,001 934,930 981,815 590,10.5 881,282 913,500 911,700 0 Acct Class: 590 Other Flnandng Sourca9 & Uses 598.100 Budget Cost Sevings 0 3,230 0 0 0 Other Flnem�ng Sources & Usea 0 3,230 0 0 0 0 0 0 Water- Praductlon 1,273.387 1,497,430 1,551,4&5 1,052,576 1,448.5fi3 1,601,270 1,599,470 0 Dept 243 WaterDistributlan Acct Class: 510 Personal SeMces 512.100 R�uter Saleries 8 Weg� 368,002 387,8U0 388,000 317,948 3�,000 386,500 �6,500 514.100 Overtlme 3,769 5,000 5,000 2,831 5,0�0 5,000 5,000 515.102 Stendby Pay 9,212 8,500 9,850 8,749 9,850 70,000 10,000 515.103 Bonus Pay Plan 0 0 3,000 3,000 3,000 575.106 Clothhig 8 Boot Allowance 6U0 500 500 500 500 500 500 515.107 PeR-tlme Saleries 41,111 0 0 0 0 515.108 Aufn Allowance 2,400 0 0 0 0 576.700 Compensa�ed A�enc�s 19,412 5,000 5,000 2.094 5,000 5,000 5,OW 516.10.5 Compensatied Af�en� - HSA 0 0 0 0 0 521.101 FICA Texes 26,751 24,300 24,300 19,555 24,300 24,500 24,500 521.102 M�Icare Taxa9 8,258 5,700 5,700 4,573 5,700 5,800 5,800 592.101 FRS CoMrlbutlons 7,889 8,200 10,000 8,154 10,000 10,700 10,700 522.102 VOT Penslon Contributlor�s 21,950 23,100 23,100 18,847 23,005 20,700 20,700 523.101 LfFelHealth Insurence 72,987 94,100 94,950 Tf,3� 83.973 �,300 60,300 523.105 HSA - H�Ith Savings Acmunt 2,700 0 0 0 0 523.110 Rettree Health Care Expense 0 0 0 0 0 524.100 Workers' Comp Insurance 10,917 9,090 9,090 9,087 9,087 9,090 9,090 525.100 UnemploymeM Compensetlon D 0 0 0 0 554.301 Personnel Tialnir�g 125 1,500 710 646 710 1,500 1,500 Personal Services 594,081 572,790 579,200 473,350 578,125 539,590 539,590 0 Acct Class: 530 Operadng Expendihu�alEx�r� 540.300 Travel & Per Dlem 152 500 500 92 500 500 500 541.300 Communicedon Servic� 6,000 7,700 6,000 4,546 6,000 6,000 6,000 541.301 Poshage 22,797 23,000 23,000 70,910 23,000 23,000 23,000 544.301 O�ratlng Lees�v 2,788 4,500 3,200 2,518 3,121 3,200 3,200 BUDGET WORKSI�EET DRAFT Page: 29 7/31l2014 VfVage of Tequ� 1126 am Prior CurreMYear (6) (� (8) Year OdgMel Amend� Achiel Tfw EstlmaGed Mordh:7/31/2014 Adual Budget Budget Juty Tatal DEPARTMENT MANAGER COUNCa Fund: 401- WaOar Fund Fxpenditurea Dept 243 Weter-Distributlon Acct C�: 530 Operatlng F�erMftur�lExper�ae 548.301 OffMSEquIp/Repeir&MeIM 679 1,200 1,020 248 900 1,200 1,200 546.302 Vehide Re�h & Mairrtenance 5,210 7,000 7,000 6,8&9 7,000 8,500 8,5�0 546.303 Bu➢dtrig Repair 8 Maint 2,435 5,000 5,000 945 5,U00 5,000 5,0� 546.309 Landswpe 8 Irtigetlon Metrrt 239 900 900 859 900 900 900 546.370 Eq�ripmeM Repair & Meint 5,416 5,000 5,000 3,271 5,000 5,000 5,000 546.320 CompuGer sysGem maint 8 suppll 7,588 6,900 6,900 5,38;i 8,900 70,200 8,400 546.342 Water Sys6em Maitdermrtce 19.302 25,000 25,000 79,530 25,000 35,000 35.000 547.300 Printlng 8 Bmding 2,642 3,000 3,000 2,439 3,000 3,600 3,000 549.300 Other Misc Chgs 8 Obligatlons 4,356 2,500 2,500 9� 2,500 2,500 2,500 549.304 Licena�, F� & PertnHs 1,607 1,700 1,700 1,427 1,700 1,700 1,700 551.300 Olflce Suppli� & Equlpment 1,509 1,500 1,500 464 1,500 1,500 1,500 552.301 Gas & 0� 14,315 14,OQ0 14,000 10,6� 14,000 14,000 14,000 552.302 Small Tools and EqWpment 1,094 4,009 4,000 2,893 4,000 4,000 4,000 552305 Unifarms 1,453 2,000 2,000 1,564 2,000 2,000 2,000 Operadng F�ryendfbu�lExpense 99,573 115,40D 112,220 75,504 112,021 127,200 125,400 0 Acd Cless: 590 Otlter Flnencing Sour� 8 Uses 599.100 Budget Cost Savhigs 0 3,230 0 0 0 Ofher Fmenang Sour� 8 Uses 0 3,230 0 0 0 0 0 0 Water-DlstribuHon 693,654 691,420 691,420 548,854 690,146 666,790 864,990 0 Dept 411 Renewel & Replacement Acct Cless: 530 Operatlng Expenditur�lExper�se 546.60.5 R8M - Well S(te Rehab 2,550 4,000 4,000 1,790 2,500 4,000 4,000 549.671 Misc. Renewel & ReplacemeM 116,017 60,000 787,951 252,948 787,000 310,000 310,000 552601 Metere, Valves & Hydran�s 30,289 30,000 37,455 26,231 37,455 60,000 60,000 5526U3 Fll�er Cartridg�IROP 3,030 7,000 7,000 0 S,OUO 7,000 7,000 Operatlng ExperMihir�lExperise 151.886 101,000 836,406 280,967 831,955 �1,000 �1,000 0 Acd Cless: 6� CapHal Outley 6p.671 Misc. Renewel and Replacemerrt 0 0 0 0 0 664.600 MachlEqufpmeM 0 0 0 0 0 25,000 25,000 864.601 ComputerEquipmertt 0 1,500 1,500 0 1,500 664.602 Vehidea 0 33,500 36,500 36,496 36,500 136,000 136,000 CapftalOuNay 0 35,000 38,000 36,496 38,000 181,W0 181,000 0 Renewal & ReplecemeM 151,�6 136,000 874,406 317,463 889,955 542,000 542,000 0 Dept 412 Cepflal ImprovemeM Acct Ciass: fi00 Capital Ouday 664.600 MeciUEq�dpmeM 0 �,000 57,000 2,330 52,510 Capilal0utlay 0 �,000 57,000 2,330 52,510 0 0 0 BU�ET WORKSFIEEf DRAFT Page: 30 7/31Y1014 VlOage of Tequesla 1126 am Pdor Curte�Y�r (6) (n (B) Yeer Odginal Amend� Achiel Thru Estlmated Morrth:7/31/2014 Achiel Budget Budget July Totsl DEPARTMENT MANAGER COUNCIL Fund: 401- Water Fund Expendihires Cepftellmprovement 0 6'8,000 57,000 2,330 52,510 0 0 0 Dept 700 Debt Service Acxt Cless: 471 D/S - Prind�l 5T1.7Q5 Prin - 2004 Weter WP BOA 0 30,000 30,000 30,000 30,000 32,000 32,000 571.77A Prfi - 2008 Weter Utllity Note 0 277,900 277,900 230,901 277,900 287,890 287,890 DB-Pdnd�l 0 307,900 3W,900 260,901 307,900 319,890 319,890 0 Acct Ciess: 472 DIS - Inter�t 57270.51M-2004WaterWPBOA 74,BB7 14,100 14,100 8,208 14,100 12,600 12,800 572720 Int- 2008 Water Utility Note 201,533 192,200 192,200 144,072 192,200 191,310 191,310 573.700 Other Debt Service Costs 46,676 25,000 25,000 0 23,000 23,000 23.000 D/S-Inter�t 263,096 231,300 231,300 752,280 229,300 226,910 226,910 0 Debt Service 263,098 539,200 539,2U0 413,187 537,200 546,&10 548,800 0 Dept 910 Other Finand� So� & Usav Acd Class: 590 Olher Flnandng Sources 8 Uses 567.000 GamlLass on Im�hnenis 0 0 0 0 0 567.100 Unr�lfzed Loss on Inv�tmems 0 0 0 0 0 Other Finamang Sourt�s & Uses 0 0 0 0 0 0 0 0 Othar Flnanc(ng Sourc�a & Uses 0 0 0 0 0 0 0 0 Dept 950 Other Nonopereting Acct Ciass: 530 Operadng ExperMihueslExpense 559.300 Depr�iation 1,000,083 0 0 0 0 559.301 Budge�ed Depreciation (rretted) 0 605,320 605,320 0 6Q5,320 565,OD0 565,000 Operabng Exper�dihu�lExper�ae 1,000,083 805,320 605,320 0 605,320 565,000 565,000 0 Atxt Class: 590 Other Fnandng Source.s & Us� 549.391 Benk Charg� 10,038 10,000 10,000 7,680 10,000 10,000 10,000 549.395 Cr�ft Card Fees end Cherg� 4,718 4,500 4,500 4,648 6,000 6,500 6,500 590.001 Mo� to Fund Belance 0 12,885 0 0 0 999.001 Suspense 0 0 0 0 0 9992W Suspense - A!P 0 0 0 0 0 Other Flnandng Sourc� & Uses 14,156 27,385 14,500 12,306 16,000 16,500 18.500 0 OtherNorroperating 1,014,239 632,705 819,820 12,306 621,320 581,500 581,500 0 Dept 990 OfhedR�senrelContlngen�y Acct Class: 590 Other Flnendng Sourcea & Us� 599.902 R�rv�-CoMingency 0 0 0 D 0 10,700 Other Flnancing Soumss 8 Uses 0 0 0 0 0 0 10,700 0 Other/Reserv�Cor�tlngen�y 0 0 0 0 D 0 10,700 0 Total Expendihir� 4,204,953 4,408,100 5,253,176 3,0&9,612 5,149,548 4,934,420 4,941,520 0 Wa6er Fund -130,837 0 0 251,471 -959,442 0 0 0 BUDGET WORKSHEEl' DRAFT Page: 31 7/31/2014 Villege of Tpuesm 11:26 em Prior CurteMY�r (6) (� (8) Yeer Origlnel Amended Ac�al Tfw EstlmeOed Mor�th:7/31/2014 Actual Budget Budget July Total DEPARTMENT MIWAGER COUNCIL Furnl: 402 - Retuae & Recyding Revenu� Dept 000 General Axt Class: 335 Irrtergovemmertlel Revenue 338.110 Re�yding Shar�l Rev - SWA 8,690 7,300 7,300 5,733 5,000 5,000 5,OW Ir�ergovemmemel Revenue 8,890 7,300 7,300 5,733 5,000 5,000 5,0� 0 Acd Class: 340 Cherges for Servic� 343.307 Penalty Charg� 1 0 0 1 0 343.400 Refi�se I Recyc�ng F�.s 473,731 472.680 472,680 469,809 472,245 472�45 472,245 Cha�ga9forServica 473,732 472,680 472,680 469,810 472,245 472,245 472,245 0 Acct Giass: 369 Miscelleneous Revenu� 368.000 Other Miscellan�us Revenue 0 0 0 0 0 Miscellen�us Revenu� 0 0 0 0 0 0 0 0 Acct Class: 390 Otlter Flnandrn,� Sources 399.999 Appmpriate Fimd Belence 0 9,855 9,855 0 0 71,175 22,175 Olher Flnandng Sourcav 0 9,855 9,855 0 0 22,175 Y1,175 0 Gerreral 4�,422 489,835 488,835 475,543 4T/245 499,420 499,420 0 Dept 950 Other Nonopsratlng Acct Ciess: 361 Unra9Mcted Imestrnerrt Eamin 367.100 InOer�Nnv�trnerrt EemMgs 170 200 200 128 175 175 175 361.101 PBC T�c Col-Inteiest on Dep 71 100 100 10 10 367.100 Net Unr�l appr�aetlon (Dep) 424 300 300 160 200 200 200 Unres61c1ed Irn�trnent Eamin 665 600 600 298 385 375 375 0 OtherNonope�atlng 665 600 600 298 385 375 375 0 Total Revenu� 483,087 490,435 490,435 475,841 4T/,fi30 499,795 499,795 0 Expendiwres Dept 241 Weter-Administradon Acct Class: 510 Pereonel Servic�s 515.103 Bonus Pay Plan 0 0 0 0 0 Peraonal Servic�s 0 0 0 0 0 0 0 0 Water-Administratlon 0 0 0 0 0 0 0 0 Dept 242 Water- Productlon Acct Ciass: 510 Per�nal Servic�s 515.103 Bonus Pey Plan 0 0 0 0 0 Personel Services 0 0 0 0 0 0 0 0 Weter- Produc8on 0 0 0 0 0 0 0 0 Dept 243 Water-0latributlon Acct Cless: 510 Per�nal Servic� 515.103 Bonua Pay Plan 0 0 0 0 0 Per�nal Servic� 0 0 0 0 0 0 0 0 Weter-Distributlon 0 0 0 0 0 0 0 0 Dept 245 Refuse and R�ycling BUDGET WORKSHEET DRAFT Page: � 7/31f2014 Wlage oFTequaale 71:26 am Prior CurteMY�r (81 (� (8) Year Original Amend� Aclual Thru Estlma6ed Mornh:7131/2014 Actual Budget Budget July Total DEPARTMENT MANAGER COUNCIL Fund: 402 - Refuae & Recycling Fx�ndihu� Dept 245 Ftefuse arM R�,ycltrig Acxt Gass: 530 O�ratlng Experbftur�lExpense 531.301 Legal Services 0 0 0 0 0 543.302 So�d WestelResidentlel 248,735 251,905 251,90.5 188,810 251,747 257,810 257,810 543.303 RecycmnglResidentlal 87,902 89,090 89,090 66,774 89,033 97,310 91,310 543.304 YercJ WastelR�identiel 82,528 83,715 83,715 62,745 83,�0 85,555 85,555 543.306 Fuel Facror 57,961 58,370 58,370 43,749 58,332 57,550 57,550 549.300 Other Misc Chgs 8 Ob�gatlons 189 300 300 190 300 300 300 549.301 Admin Mgmt F� 6,&50 7,055 7,055 5,879 7,055 7,270 7270 Operetlng ExpemifhuesfF�er�ae 484,165 490,435 490,435 368,147 490,127 499,795 499,795 0 Refuse and Recycling 484,165 490,435 490,435 368,147 490,127 499,795 499.795 0 Dept 910 Olher Fhiandr�g Sources 8 Uaes Acct Cless: 590 Other Flnendng Sour� & Uses 567.000 GafilLoss on Imeslmerits 0 0 0 0 0 567.100 Unrealb.ed Loss on Inv�hnents 0 0 0 0 0 Other Fmencing Sources & Uses 0 0 0 0 0 0 0 0 Other Financing Sourcea & Uses 0 0 0 0 0 0 0 0 Dept 950 Ofher Nonoperating Acd Class: 590 Other Flnancing Sources & Usea 590.001 Allocate to Fund Balance 0 0 0 0 0 Other Flnendng Sour� 8 Usea 0 0 0 0 0 0 0 0 Other Noiroperating 0 0 0 0 0 0 0 0 Total F�endilur� 484,165 490,435 490,435 388,147 480,127 499,795 499,795 0 Refuse 8 R�,yt�ing -1,078 0 0 107,694 -12,487 0 0 0 BUDGET WORKSF�EET DRAFT Page: 33 7/3112014 Vfllage of Tequesta 11:26 em Prior CurreMY�r (6) (n (8) Yeer Odginal Amended Achiel Thru Estlmeted Mmith:713112014 Actual Budget Budgel July Totel DEPARTMENT MANAGER COUNCIL Fumi: 403 - Stormxrater Utllity Revenu� Dept 000 General Acxt Class: 340 Charga for Servic� 343.901 Storm Wa6er Utllfly Fees 323,513 318,000 318,000 321,388 321,388 318,000 318,000 Charg�forService.a 323,513 318,000 318,000 321,388 321,388 318,000 318,000 0 Acxt Ciass: 3&9 MlsceDaneoua Revenu� 369.000 Other h9scellan�us Revenue 0 0 0 0 0 M�Celleneous Rsvenues 0 0 0 0 0 0 0 0 General 323,513 318,000 318,000 321,388 321,388 318,000 318,000 0 Dept 950 OtherNonoperatlng Acct Class: 361 Unrestrict�i Inveshnent Eamin 361.100 InOeragtllnv�ImeM Eeminga 1,027 1,100 1,100 767 7W 1,100 1.100 361.101 PBC T�c Col-Irnerast an Dep 46 50 50 7 0 367.100 NetUnrealappredatlon(Dsp) 444 0 0 7B0 0 Unrestric0ed Im�hneM Eamin 1,517 1,150 7,750 954 767 1,1U0 7,700 0 OfherNonoperathng 1,517 1,750 1,150 954 767 1,700 1,100 0 Dept 990 OthedR�erve/Contlngency Acct Class: 390 Other Flnandr�g Sources 399.999 Approprie�e Fund Balance 0 0 0 0 0 146,000 146,250 Other Flnan¢ng Sou�es 0 0 0 0 0 146,000 746Z50 0 OthedReserv�Coritlngency 0 0 0 0 0 146,000 746,250 0 Tolal Revenu� 325,030 319,150 319,150 322,342 312,155 465,100 465,350 0 F�endihires Dept 241 Water-Administratlon Acct Cless: 510 Personal Servic�s 515.103 Bonus Pey Plan 0 0 0 0 0 Persanal Servic�s 0 0 0 0 0 0 0 0 WaGSr-AdministraUon 0 0 0 0 0 0 0 0 Dept 243 Water-Distributlon Acct Class: 510 Personel Servic� 515.103 Bonus Pay Plan 0 0 0 0 0 Personel Services 0 0 0 0 0 0 0 0 WffierDistributlan 0 0 0 0 0 0 0 0 Dept 250 Stortn Water Utll(tl� Acct Class: 510 Per�nel Services 512100 Reguler Selarles & Weg� 43,918 60,500 60,500 48,881 59,962 59200 59,200 514.100 Overtlme 509 1,000 1,000 412 1,000 1,000 1,000 515.102 Stendby Pey 1,688 1,400 2,300 1,406 2,300 2,000 2,000 515.103 Bonus Pay Plan 0 0 1,500 1,500 1,500 515.106 Clofhhig & Boot Allowar�ce 100 150 150 150 150 150 150 575.108 Auto Alla�vance 7� 900 1,800 1,500 1,8f10 450 450 BUDGET WORKSHEET DRAFT Pege: 34 7131/2(114 Villege of Teques� 1128 am Prior CurtentYear (6) (� (8) Y�r Original Amended Ach�al Thru Estlmeted Mmrth:7/31/2014 AcNal Budget Budget July Totel DEPARTMEN7' MANAGER COUNCIL Furb: 403 - Stormwater UdQly Fxpendihir� Dept 250 Storm Weter Utllitles Acd Class: 510 Personel Servic� 518.100 Comper�saeed A�enc� 5� 0 0 0 0 516.105 Comper�seted Aimences - HSA 0 0 0 0 0 521.101 FICA Tax� 2,407 3,500 3,728 3,022 3,700 3,800 3,800 521.102 Medicare Tax� 563 900 919 707 919 900 900 522702 VOT Pe�lon CanMbutlar�s 4,120 5,609 5,800 4,337 5,300 5,000 5,000 523.101 LffdH�flh Ir�surance 16,720 24,400 20,128 15,109 17,470 10,800 10,8U0 523.1Q5 HSA - H� Sevings Acmunt 850 0 0 0 0 524.100 Workers' Comp Insmance 1,094 2,800 2,800 2,799 2,799 2,800 2,800 554.301 PersonrrelTiamMg 0 0 0 0 0 Per�nal Servic� 73,280 101,150 100,425 78,823 96,900 88,100 86,100 0 Acct Class: 530 Operating ExpenditurealExpense 531.302 Engineering Services 6,042 8,000 14,835 14,835 14,835 36,500 36,500 532.300 Accounting & Auditing Ssrvicea 3,892 4,000 4,000 3,885 3,885 4,010 4,010 540.300 Travel & Per Diem 0 0 0 0 0 541.300 Commwicatlon Serrices 1,680 1,900 1,900 1,424 1,800 7,900 1,900 541.301 Posmge 0 300 300 0 300 300 3U0 546.302 Vehicle Repair & Matrdenance 701 500 1,500 961 1,500 2,000 2.D00 546.303 BuildingRepairBMeint 1,806 2,000 1,000 199 1,000 2,000 2,000 546.308 Dreirrege Meintenance 12,�4 25,000 20,710 12,905 24,000 285,000 285,000 546.310 EquipmentRe�h&Meint 1,356 1,500 1,500 1,446 1,500 2,500 2,5� 546.320 Computer system mahrt 8 suppll 293 B00 800 306 800 1,200 750 549.300 Other Misc Chgs & ObRgatlons 145 1,000 1,000 503 1,000 1,090 1,000 549.301 Admin Mgmt F� 11,630 11,920 12,020 9,982 11,978 12,340 12,340 549.304 Licer�, Fees 8 Permits 4,109 4,500 4,500 4,099 4,100 4,50D 4,500 551.300 Oftice Suppli� 8 Equipment 117 300 300 0 300 300 300 552301 Gas fl 00 2,3;i7 3,000 2,700 7,509 2,000 2,700 2,700 552302 Smell T�Is and Equipment 1,822 1,200 1,2U0 487 1,200 7,500 7,500 554.100 Public Educatlon Program 0 500 500 0 500 250 250 Operetlng ExpenditureslExperise 48,218 88,420 68,7&5 52,541 70,698 364,�00 383,550 0 Acxt Cless: 590 Other Fnancing Sources & Uaes 598.100 Budget Cost Savings 0 1,620 0 0 0 Other Financing Sources & Uses 0 1,620 0 0 0 0 0 0 Acct Cleas: B00 Capital Outlay 662.632 ArchiOe�� 8 Eng�ring 0 0 0 0 0 663.663 Dralr�age Improvements 0 0 0 0 0 664.600 MechlEquipmeM 0 0 0 0 0 15,000 15,000 664.602 Vehicles 0 30,000 30,000 21,797 30,000 BUDGET WORKSf�EI' DRAFT Pege: 35 7131@014 V�lage of Tequ�la 1126 em Prior CurteM Y�r (6) (n (8) Yeer Originel Amended AcWel Thru EstlmeOed Mordh:7/31@014 AcWel Budget Budget July Totel DEPARTMENT MANAGER COUNCIL Fund: 403 - Storrtrvueter UdIHy Expendihir� Dept 250 Stortn Werter UUlides Capital0utlay 0 30,000 30,000 21,787 30,000 15,000 15.000 0 StormWa�erUtllitles 121,498 199,190 199,190 154,261 197,598 465,100 464.650 0 Dept 810 Other Flnend� Sour� & Uses Acct Class: 590 Other Flnencfng Sources 8 Uses 567.100 Unrealiz� Loss on Inv�trnerds 0 0 0 0 0 Oth� Flnandng Sources � Uses 0 0 0 0 0 0 0 0 om�r �m� s�,� a u� o o a o 0 0 0 0 Dept 950 Olher Nonoperadng Acd Ciess: 530 OPe�tln9 F�e�di�r�lExPer�e 559.300 Depr�ladon 98,785 0 0 0 0 559.301 Budgeted Depreceatlon (net0�i) 0 70,250 70,250 0 0 Operetfig Expendihu�IF�ense 99,785 70,250 70,250 0 0 0 0 0 Ac� Class: 590 Ofher Finandng Sou� 8 Uses 590.007 Allowte to Fund Balance 0 49,710 49,710 0 0 Other Rnendng Sources & Uses 0 49,710 49,710 0 0 0 0 0 Other Nono�ratlng 99,785 119,960 119,980 0 0 0 0 0 Dept 990 OlherlReservelCo�r�genay Acct Class: 590 Other Flnmiang Sources 8 Uses 599.902 Resenres-Ca�r�gency 0 0 0 0 0 700 Other Ffnandng Sources 8� Us� 0 0 0 0 0 0 700 0 OtheAR�serve/Cor�tlngenc,y 0 0 0 0 0 0 700 0 Total F�cpenditures 221,283 319,150 319,150 154,261 197,598 465,100 465,350 0 Stnrmwater U611ty 103,747 0 0 168,081 124,55/ 0 0 0 GiarM Total: •531,957 0 0 1,388,490 -1,264,578 -139,441 -07,800 0