Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Documentation_Workshop_Tab 02_09/03/2014
The Villase of Tequesta Chan�es Made to the FY2015 Proaosed Bud�et Between June 26, 2014 and Au�ust 25, 2014 � F� �cy i�taace on �26f i� 9�,+� 7/1/2014 Increased Other Contractual Services in 160 for computer mapping (15,000) Deleted website expenditures from the computer account 8,100 7/19/2014 Adjusted summer camp revenues per Greg's e-mail 10,750 Misc. payroll changes (2,800) 7/29/2014 Added Military to Main Street (35,400) Increased building inspector's salary to $90k (12,200) 8/7/2014 C1NA contract changes (health insurance $50/$100) (13,800) Changed pension from DB to 401a for the lieutenant position and replaced Broedell with Franklin 20,100 8/8/2014 Dept. 180-Decreased legal from $26k to $20k and inspection services from $75k to $65k 16,000 8/12/2014 Decreased misc. planning services in planning, building inspections in building and legal fees in both 18,880 8/18/2014 Increased Dept. 180 by $4,100 - p/t permit tech hrly rate to $20 (4,100) Decreased communication services tax per State's updated projections (5,500) Increased Ad Valorem taxes per tentative millage increase 211,800 Increased personnel expenditures: Non-unionized: eliminated $50/$100 employee health ins. premium Police-added $3,000 bonus and increased 401a employer contribution from 5% to 10% (105,350) 8/19/2014 Removed part time fire fighter position 11,500 8/22/2014 Updated insurance numbers per Risk Managements instructions, added the part time fire fighter position back and added Matrix increases for firefighters. (28,970) IT changes: increased Dept. 120 by $1,100 and Dept. 175 by $4,650 (5,750) � f���te i�fi� baiance am 0�/?5j14 1�7� BU�ET WORKSt�ET DRAFT Budget @ &2&2074 Pege: 1 8I28/2014 Wlege af Tpu� 4:57 pm Prior CurreMY�r (6) 0) �8) Ye� Origir�l Amend� AcNel Thru Estlmeted Momh:9130I2014 Nch�al Budget Budget September Totel DEPARTMENT MANAGER COUNCR Fund: 001- General Fund Revenu� Rmctlon: 000 Geireral Reverm� Dept 000 General Axt Class: 311 General Properry Texes 311.000 Ad Valorem Taxes - Curtent 4,337,570 4,759,000 4,759,Q00 4,755,463 4,755,483 5,230,800 5,230,800 311.100 Ad Valorem Tax�-Del 1,644 5,009 5,000 8,369 8,368 5,000 5,000 Gerre�al Properly Taxes 4,338,214 4,764,000 4,764,000 4,763.832 4,763.�i2 5,Z15,800 5,235,800 0 Aai Cless: 316 Sel� & Use Texes 314.100 UtllflyTex-Elechidty 467,498 430,Opp q30,00p 408,660 470,000 470,W0 470,000 314.300 UTllily T�c-Water 156,360 156,000 156,000 137,251 160,000 160,000 180,000 374.400 U1DRy Tax - Nehual G� 0 0 0 173 155 314.800 Ut➢ItyT�c-pio�ne 20,618 24,000 24,000 28,376 30,000 30,000 30,000 315.000 Comm.Servic� Tax (CSl') 344,204 333,380 333,360 271,577 325,000 319,500 318,500 321.W0 Local Business Tax (Occ Lic) 71,685 71,000 71,000 73,242 73,242 72.000 72,000 321.001 Home Busin�s Tex 4,500 4,500 4,500 5,544 5,544 4,500 4,500 321.070 LacalBuslnesaTax-CouMy 7,880 4,500 4,500 6,072 6,022 4,600 4,800 Sal� 8 UseTaxes 1,072.755 1,023,3f� 1,023.360 930,845 1,OG9,9q 1,060,600 1,060,800 0 Acct Clasa: 318 Frenchi� fea� - gra9s recetpt 313.100 Fran Fees-El�tric 380,160 392,000 392,000 284,732 380,000 414,000 414,000 Frenchisef�s-groasreceipt 380,180 392,000 392,000 294,732 390,000 414,000 414,000 0 Acd Ciess: 329 Ir�hagovemmeMal Revenue 341.401 Admin Mgmt Fe�-Weter 4&5,229 499,785 499,785 416,488 499,785 514,780 514,780 341.402 Admfn Mgmt FeeRef & Re�ycling 6,850 7,055 7,055 5,878 7,055 7,270 7,270 347.403 Admin Mgmt Feea - Slorm Weter 11,6;i0 71,978 11,978 9,982 11,878 12,340 12,340 369.010 Misc Revenue - Hats 0 0 0 370 370 In4agovemmeMel Revenue 5ai,709 518,818 518,818 432,719 519,188 534,380 534,390 0 Acxt Class: 335 Irtlergovemme�l Revenue 335.120 Munldpel Revenue Sharing Prog 173,789 174,500 774,500 160,990 178,000 176,000 178,000 335.150 Alcoho�c Beverage Licerises 5,576 5,000 5,000 7,276 7,216 6,000 6,OU0 335.180 Lx Gov 1!2 CeM Sal� Tax Pio 388,009 398,300 398,300 350,780 4Q5,000 405,W0 405,000 338.107 Lowl Gas Tex� CeM 114,868 176,900 716,900 98,026 116,000 116,000 178,000 338.102 Loc�l Ges Tex 7S Cent 53�6'82 54,000 54�000 46,861 56.OW 56.000 58.000 338.110 R�.ycling Shered Rev - SWA 0 0 0 0 0 Irrtergovemmental Revenue 735,924 748,700 748,700 883,873 760,216 758,000 759,000 0 Ac� Ciess: 341 Chgs for Serv - Gen Gov 347.701 CertiAflcatlon/Copy F� 11,895 10,000 10,OW 11,823 11,900 10,000 10,0� 341.103 Electlon qualifyir�g f� 80 150 150 90 90 341.10.5 Admfnf�sfromotherGov'b 1,6'64 1,000 1,000 1,400 1,400 1z00 7,200 ChgsforServ-GenOov 13,619 11,150 11,150 13,313 13,390 11200 17Z00 0 Axt Class: 362 ReMs & Royeltles 382110 L��-Sprint 35,053 34,190 34,190 33,096 34,190 37,187 37,187 BUDGET WORKSHEET DRAFT Budget (t� &26-2014 Page: 2 8126/2014 Vlllage of Teque� 4:57 pm Prlor CurteMYear (8) Cn (8) Year Odginal Amended AcWal Tfw EsUmeted MoMh:9/30/2014 Ac�al Budget Budget Sep6em�r ToTel DEPARTMENT MANAGER COUNCa FurM: DOt - Generel FurM Reverni� Functlon: 000 Gerreral Revenues Dept U00 General Acct Class: 362 Renb & Royaltl� �2.112 L�se-T-Mob�e 48,850 50,800 50,800 46,539 50,800 52�836 52,836 362115 Lease-Nextel 26,847 0 0 0 0 362116 L�se - ATflT �,000 30.00p 30,00p 30,000 3p,000 30,000 30,�U0 362117 L�se-Verizan 0 0 0 0 13,000 �,000 66,000 Rentv 8 Royeltl�v 140,850 114,990 114,990 109,635 127,990 188,023 186,023 0 Acct Class: 368 ConMbutlor�s & Donatlons 366.100 ConMb & Donedmis & Spo�ra 1,525 0 0 0 0 CoMributlore 8 Donatlor�s 1,525 0 0 0 0 0 0 0 Acct Cless: 3&9 Misceilan�us Revenu� 364.100 Disposftlon oFAgsels 0 0 0 0 0 �9.OU0 Othsr Mi�lianeous Revenue 13,610 0 18,000 23,903 24,000 8,000 8,000 �9.100 Inaurance ReimbiusemeM 31,014 15,500 15,500 28,6�i 28,683 15,500 15,500 Miscelleneous Revenu� 44,624 15,500 33,500 52,586 52,�3 23,500 23,500 0 General 7,232,380 7,588,518 7,606,518 7,280,835 7,697,262 8,224,513 8,?24,513 0 Generel Revenuaa 7,232,�0 7,588,518 7,806,518 7�,935 7,697,262 8,224,513 8,224,513 0 Fimctlon: 410 Gerre�al GovemmeM Dept 150 Comprehenshre Planning Aad Class: 340 Charges for Servic� 341.150 Lend DevelopmeM Fe� 35,276 35,000 35,000 29,941 35,000 35,000 35,000 343.700 Water Conserve�nn 8 R�ource 8?2 0 0 913 913 Cherg� for Services 36,098 35,000 35,000 30,854 35,913 35,000 35,000 0 Acct Class: 369 Miscelleneoua Revenu� 369.000 Other Miscellaneous Revenue 0 0 0 0 0 Mbceltaneous Revenu� 0 0 0 0 0 0 0 0 Comprehensive PlannMg 38,088 35,000 35,000 30,854 35,913 35,000 35,000 0 Gerreial Govemment 36,098 35,OW 35.000 30,854 35,913 35,000 35,OW 0 Funcdon: 420 Pub�c Sefety Dept 171 Police Acct Ciass: 318 Sal� & Use Tex�v 312520 Cesuelty Insuram� Premium Tax 76,177 0 0 0 0 Sal� & Use Tex� 76,177 0 0 0 0 0 0 0 Aa� Ciass: 320 Licenses & Pertnifs 329.101 Alerm Perrtdis 6,440 0 0 0 0 329.102 SpedalTruck PertnNs � 0 0 15 15 329.10.5 Golf Cart PertnNs 0 700 700 0 0 Licer� & Permib 6,508 700 700 15 15 0 0 0 Acct Cless: 331 Grar� Federal 331210 FDLE - F�erel G�arrt 0 0 0 0 0 BUDOET WORKSF�ET DRAFT Budget (� &2E2014 Pege: 3 8126/2014 Wlage of TecN� 4:57 pm Prlor CurterrtY�r (6) (n (8) Year Orighrel Amend� Achial Thru Esftrma0ed MoMh:9/30@014 Ach�al Budget Budget September Totel DEPARTMENT MANAGER COUNCIL Fund: 001- Geneial Furb Revenu� Rmdion: 4Z0 PubncSafety Dept 171 Police Grertls Federal 0 0 0 0 0 0 0 0 Acct Class: 335 Irrtergwemmerdal Rever�ue 338201 PBC 911 Maint Rehnbursement 0 8,000 B 0 0 8,000 8,000 338202 PBC 911 DISPATCH REIMBURSEMENT 13,353 26,000 26,000 27,4� 27,428 19,320 19,320 Intergovemmerdel Rsvenue 13,353 34,000 34,000 27,428 27,428 27,320 27,320 0 Acct Cless: 337 G�arrts & Caiitributlorus - Lacel 366.172 Donatlo�s -Mf�y to Main St 0 0 0 10,000 10,000 5,000 5,000 Granis & Contribudons - Lasl 0 0 0 10,000 10,U00 S,OW 5,000 0 Acct Class: 342 Chgs for Serv - Public Safety 342170 PBC - Marine law errforce. serv 18,b'81 18,500 18,500 9,100 9,100 Chgs for Serv - PubAc Safety 18,6'81 18,500 18,500 9,100 9,700 0 0 0 Aat Ciess: 351 Fr� 8 Farfeifii�es 351.100 Court Ffn� 7,178 15,000 15,000 4,128 4,728 2.000 2,0� 354.101 ParMnglldcets 1,440 800 800 1,610 1.570 800 800 354.102 Code Errf Fmes 8 CouR Cosffi 9,158 9,000 9,000 24,230 24,230 Flnes 8 ForfeiWr� 77,776 24,800 24,800 29,9fi8 �,928 2,800 2,8� 0 Acct Class: 363 Impact Fe� 362.Z21 Palice Impac� Fe� 378 0 0 128 726 Impad F�s 378 0 0 126 126 0 0 0 Acxt Class: 366 Contribubor�s 8 Donador�s 366.100 Coimib 8 Donations 8 S��sors 0 0 0 0 0 Contributlo� & Donatlons 0 0 0 0 0 0 0 0 Acct Class: 369 Miscellen�us Revenue.s 369.000 Other Misce�an�us Revenue 3,138 0 0 530 530 Miscelleneous Revenues 3,138 0 0 530 530 0 0 0 Pollce 136,011 78,000 78,000 77,167 77,127 35,120 35,120 0 Dept 175 Police Departrrierd Acct Class: 369 Miscellen�us Revenues 359.100 Forfefhu�ICor�flscatlons 153 0 0 0 0 Miscellan�us Revenu� 153 0 0 0 0 0 0 0 Police DeparlmeM 153 0 0 0 0 0 0 0 Dept 180 Bundfng & Zonir�g Aa�:t Cless: 320 Licer� & Pertnib 322000 BuIldUig Pertnft F� 308,830 371,500 322,500 389,646 400,000 363,040 3Ci 329.000 Contracrors Re.gistration 8,975 9,750 9,750 9,225 9,750 9,700 9,700 329.070 Contractar Reg. - County 8,256 6,000 8,000 3,248 5,000 5,000 5,000 Llcereag & Permits 324,081 338z50 338,250 402,118 414,750 377,740 377,740 0 Acct Cless: 351 Fln� 8 FarfeiWres 354.102 Code Errf Fln� & CauR Costs 0 0 0 0 0 4,500 4,500 BUDGET WORKSHEET DRAFT Budget @ &28-2014 Pege: 4 �26/2014 Vlllage of Tpuesla 4:57 pm Prlor Curter�Y�r (6) (n (8) Year Odghial Amended Achiel Thru Estlmet� Mordh:9/30/2014 AcWal Budget Budget Sep6smber To�l DEPARTMENT hUWAGER COUNCd FurM: 001- General Fund Revenue.a Functlon: 420 Public Safety Dept 180 BuUding 8 Zanhig Flna9 & ForfefUires D 0 0 0 0 4,500 4,500 0 Acct Class: 369 Miacelleneous Revenu� 369.000 Other N�xellan�us Revenue 0 0 0 60 80 Miscellan�ua Revemies 0 0 0 60 80 0 0 0 Building 8 Zonir�g 324,061 338250 338,250 402,179 414,810 382,240 382,240 0 Dept 192 Flre Control Acct Class: 316 Sel� 8 Use Tax� 312510 Flre Ins�uance Prem Tax 117,996 154,700 118,000 0 718,U00 118,W0 118,000 Sales & Use Tex� 117,996 154,700 118,000 0 118,000 118,0�0 118,0� 0 Acct Class: 334 Grards - Stete 337201 Sta6e EMS GRANT 48,600 0 0 0 0 GraMS - Stahe 48,600 0 0 0 0 0 0 0 Aca Class: 335 Ir�tergovemmerdel Revenue 335201 Flre Incentive Pay 3,451 3,600 3,600 1,875 3,W0 3,600 3,800 IMergovemme�l Revanue 3,451 3,600 3,800 1,875 3,�0 3,600 3,600 0 Acct Ciass: 340 Cherg� for Services 342792 Flre - Extra Duly 0 500 500 325 500 500 500 342201 Flre Plen Review F� 20,831 27,000 21,000 54,512 54,600 42,000 42,000 342202 Flre Inspectlons 25,808 22,990 22,990 23,687 23,500 23,720 23,720 342401 Emergenc,y ServIce,IIC 222,502 400,000 400,000 400,000 400,000 400,000 400,000 342402 Flre Resae-CPR Program 915 700 700 735 735 700 700 342.410 Emergency Svc- PBC Fire R�cue 184,W0 189,520 189.520 189,520 188,520 195206 195,206 342600 EMS Trensporlation F�s 300,088 29t1,700 290,700 258,755 292,500 315,000 315,000 342950 Allow for doubtful rew GovF� 0 • 0 0 0 0 Charg�forServices 753,923 925,410 825,410 927,534 961,355 977,126 977,126 0 Acct Giess: 3fi3 Impact F� 362222 Flrelmpad F� 520 500 500 173 500 500 500 ImpactF� 520 500 500 173 500 5D0 500 0 Acxt Cless: 366 Contributlorre 8 Donatlor�s 366.100 CoriMb 8 Donetlons 8 Spor�sora 110 500 500 130 200 250 250 CmiMbutlore & Donetlona 110 500 500 130 200 250 250 0 Acxt Class: 368 Miscellaneous Revenues 365.102 Flre Dept Sela9 43 50 50 65 65 50 50 �9.000 OtherNtlscellan�uaRevenue 11,836 600 600 2,668 2,700 600 1,600 Mbcellen�ua Revenu�v 11,878 650 650 2,734 2,785 650 1,650 0 FlreCoMrol 836,479 1,085,360 1,048,660 832,446 1,086,420 1,100,126 1,101,126 0 Pub�cSafety 1,386,704 1,501,610 1,484,910 1,411,792 1,578,357 1,517,486 1,518,486 0 Functlon: 431 Tranaportatlon BUDGET WORI(SHEETT DRAF'f Budget (o� &28-2014 Page: 5 �26@014 VIDege oF Tequ�ta 4:57 pm Prior Curtent Y�r (6) (n (8) Yeer Origfnel Amand� Acwal Tfw Esttrnated Mordh:9130/2014 Achial Budget Budget September Tatal DEPARTMENT MANAGER COUNCd Furnl: 001- General Fuml Revenue.s - Fimctlon: 431 Transportatlon �pt 210 Public Works Acct Class: 3&9 Miscelleneous Revenu� 369.000 Other NllaoeOeneous Revenue 4,480 0 0 0 0 Miscelleneaus Reverm� 4,480 0 0 0 0 0 0 0 PubOc Wor� 4,480 0 0 0 0 0 0 0 Transportedon 4,480 0 0 0 0 0 0 0 Functlon: 450 Leisiue Services Dept 231 Leisure Servlc� Accc Class: 347 Cherg� for Services - Recr. 347.100 Teque.vla F�t 18,891 0 0 7,774 7,774 7,800 7,800 347.1� SpeaalEvems-Other 12,5?2 9,000 9,000 11,041 11,041 9,000 10,000 347201 WhdedSwnmer Cemp Fees 39,836 47,000 47,000 38,330 42,750 42,750 42,750 347205 Reaeatlon Pmgrams Fe� 8,291 6,000 6,000 9,182 10,000 8,000 6,000 Charg�forServices-Recr. 79�340 62.000 62,000 64�327 71�565 65,550 86�550 0 Acct Class: 362 Rerrts 8 RoyelU� 362100 Remal - Fflc� 6,453 4,000 4,000 8,985 8,500 4,000 6,5� Rer�s & RoYe�U�s 6,453 4,000 4,000 8,965 8,500 4,000 6,500 0 Acct Class: 383 Impact Fe� 363271 Parkg �d Rec Impact Fe� 1,654 0 0 551 551 �mpaa Fees 1,654 0 0 551 551 0 0 0 Acct Class: 36'6 Contrtbutlons & Donatlo� 366.100 Contrib & Donetlans & S�rrsors 10,950 0 0 7,125 7,125 7,200 7,2� CoriMbutlo� & Donatlor�s 10,950 0 0 7,125 7,125 7,200 7,200 0 Ncct Class: 369 Miscellan�us Revenuag 365.110 Concession �I� 5,357 5,000 5,000 2,677 2,677 5,000 5,000 369.000 Other Mfaoedaneous Revenue 0 0 0 0 0 Miscellaneous Rsvenu� 5,357 5,000 5,000 2,6T/ 2,877 5,000 5,000 0 Lefsiue Servic� 103,754 71,000 71,000 83,645 90,418 81,750 85250 0 Leisure Servic� 103,754 71,000 71,000 83,645 90,418 81,750 85,250 0 Functlon: 581 Other Flnancing Sourt� and Us Dept 900 Intefimd TranaFers Acct Cleas: 391 Transfers In 381.301 Transfer-In fram Cap Improvemn 290,440 100,000 100,000 100,000 100,000 381.303 Tsfer-In from Cepf�l Pmjecb 80,000 50�000 50,000 50�000 50�000 381.6Q5 Tfr In - Sp�al Law 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 Ir�terfund Trer�afers 420,440 200,000 200,0� 150,000 150,000 0 0 0 Dept 910 Other Flnandng Sourc� & Us�s Acct Class: 390 Other Flnancing Sources 383.100 Capital Lease at Inceptlon 0 432,850 432,850 432,844 432,844 240,000 300,W0 BUDGET WORKSHEET DRAFT Budget @ &28-2014 Page: 8 8/28@014 Villege of Teques� 4:57 pm Prlor CurteM Y�r (6) (� (8) Yeer Original Amended AcWal Tfw EstlnmUed MoMh:9/30l2014 Adual Budget Budget September Tolal DEPARTMENT MANAGER COUNCa Fund: 001- General Furni Revenu� Fwctlon: 581 Olher Flnendng Sour� end Us Dept 910 Olher Flnendng So� 8 Uses Other Finendng Sources 0 432,850 432,850 432,844 432,844 240,000 300.000 0 Other Flnaming Sources 8 Uses 0 432,850 432,850 432,844 432.844 240,000 300A00 0 Other Flna�ing Sources end Us 420�440 832.850 632,850 58Z844 582.844 240�000 300�000 0 Funcllon: 590 Olher Norroperatfig Dept 950 OlherNonoperatlng Acct Gesa: 381 UnresMcted Inveahnerrt Eemin 381.100 Irrterestllnv�trneM EamMgs 9,974 11.000 11,000 7,013 9,000 9,000 9,000 361.101 PBC Tax Col-Intereat on Dep 584 B00 800 132 500 500 500 387.100 Net Unreal appredaUon (Dep) 11,748 18,000 18,000 4,812 6,000 7,500 7,500 Unrestrict� InveshneM Eamin 71,316 29,800 28,800 11,957 15,500 17,000 17,000 0 Acct Cless: 369 M�SCeDan�us Revenu� 384.100 DlaposiUonoFAsseta 28,313 75,000 15,000 0 0 90,000 90,000 Mlscellaneous Revsnu� 26,313 15,000 15,000 0 0 90,000 90,000 0 Other Nonoperatln9 48,629 44,800 44,800 11,957 15,500 107.000 107,000 0 Dept 990 OlhedR�ervelContfigenq Acct Class: 390 Other Finandr�g Sour� 399.995 Appropria0e FB - SmertCop 0 0 0 0 0 399.999 ApproPriate Pund Balence 0 0 453,718 0 0 Other Flnendng Sources 0 0 453,718 0 0 0 0 0 OthedReservelCordNgency 0 0 453,718 0 0 0 0 0 OtherNonoperatlng 48,628 44,800 498,578 11,957 15,500 107,000 1W,000 0 Totel Revenu�v 9,242,485 9,873,778 10,308,796 9,382,027 10,000,284 10,205,749 10,270,249 0 ExpendiWr� Functlon: 410 Gerreral Govemmer� Dept 100 Coundl Acct Ciass: 530 OPeratln9 F�er��4rt�lExPe�e 531.311 Coundl Fees-Arene 3,000 3,000 3,000 2,750 3,000 3,OW 3,000 531.313 Coundl fees - T. Petemo 3,000 3,000 3,000 2,750 3,000 3,000 3,000 531.314 Coundl f�s - F. D'Ambra 3,000 3,000 3,OU0 2,750 3,000 3,000 3,000 531.318 Coundlf�s-S.Olam 3,000 3,000 3,OW 2,750 3,000 3,000 3,000 531.317 Coundl F�.v - Brennen 3,000 3,000 3,000 2,750 3,000 3,000 3,000 540.301 CoundlExpens�v-Arene 9 1,500 1,000 0 1.000 3,000 3,000 540.304 Cour�cllEzpanae-F.D'Amb�a 9 1,500 1,000 0 7,OU0 3,000 3,000 540.308 CoundlExpense-S.Okun 1,3Q8 1,500 1,500 388 1,500 3,OW 3,000 540.307 CoumilE�ena�-Brennen 1,490 1,500 1,500 985 1,500 3,000 3,000 540.308 Coundl Expenses- Patemo 76 1,500 1,500 190 1,500 3,000 3,000 549.300 Other Mlsc Chga & Obllgatlons 635 700 664 531 864 700 700 BUDGET WORKSHEEf DRAFT Budget (d� &26-2014 Pege: 7 8126/2014 Vlllege oF Tequesla 4:57 pm Prlor CurteMYear (8) Cn (9) Year Origfnel Amend�l Achiiel Thru Estlmet� Mordh:8l3012014 Actual Budget Budget September Total DEPARTMENT MAIVAGER COUNC� Fuml: 001- General Fur�d Fxpendihires Funcdon: 410 Geirerel GovemmeM Dept 100 Cowm Acd Clasa: 530 �Pe��9 ���� 549.350 VolwteerAppr�iatlon 678 800 B36 835 835 800 8U0 554.300 Books, Publ, Subs � Membershfp 2,985 3,400 3,400 2,985 3,400 3,500 3,500 582800 Aid m Commwfty Orgenizetlor�s 0 0 0 0 0 582.801 Ald to Com.Org - Arena 400 0 500 500 500 582804 Aid m Commimfty O�g - D'Ambra 400 0 500 500 500 582807 Aid ro Com. O�g. - Brennan 200 0 0 0 0 582808 Aid Oo Com. Oig. - Pelemo 0 0 0 0 0 Qperedo9 F�endfhu�IF�@e�e 23.191 27,400 27,400 20,664 27,399 35.000 35,000 0 Counm 23,197 27,400 27,400 20,664 27,399 35,000 35,000 0 Dept 110 Mar�ager • P� Class: 510 Personal Services 5121�0 RegularSaleriesBWag� 130,206 132,400 132,400 113,358 132,100 137200 137,200 514.700 Overtime 183 0 0 0 0 515.103 Bonus Pey Plen 0 0 4,500 4,500 4,500 ' 515.108 AuOoAllowance 3,000 3,000 3,000 2,750 3,000 3,000 3,OW 515.125 OtherAtlowenc�v 7,200 1,200 1,200 1.100 7,200 1,200 1,200 516.100 Compensetai Absences 4,314 5,000 10,376 3,9� 5,805 9,000 9,000 516.105 Compenset� Absenc� - HSA 6,825 0 0 0 0 521.101 FlCA Taxes 6,711 6,900 6,952 6,211 6,730 7,400 7,400 521.102 M�Ic�reTaxes 2,053 2,000 2.177 1,828 2,150 2200 2,200 522102 VOT Perelon Contributlo� 12,213 12200 12,200 10,406 12.125 11,600 11,600 523.101 LNelHalth Ireurar� 22,088 25,300 18,400 17,775 19,330 17,000 18,800 523.105 HSA - H�Ith Sevir�gs Accourrt 2,550 0 0 0 0 524.100 Worlcers' Comp Insivance 378 270 270 260 260 230 230 526.104 ICMhDef Comp Plan 9,828 9,800 9,900 8,433 9,�i0 10,300 10,300 554.301 Per�mrel T�aintrig 874 750 1,395 1,395 1,395 1,000 1,000 Personel Servic� 201,932 198,920 203.770 171,934 198,425 200,130 201,930 0 Acxt Class: 530 Opeiadng ExpenditureslExpense 540.300 Travel & Per Dtem 1,449 1,400 1,400 730 1,400 1,400 1,400 546.320 Computer syslem maiM 8 suppll 0 500 500 0 0 500 500 548.110 Merketlng end Publlc Reletlons 355 0 0 0 0 549.300 Other Mlsc Chgs � Obligatlona 0 250 250 30 30 250 250 554.300 Books, Publ, Subs 8 Membership 2,640 2,800 2,800 2,531 2,800 3,150 3,150 O�ratlng E�erbitur�lExpense 4,444 4,950 4,950 3,281 4a30 5,300 5,300 0 Acct Cless: 590 Other Flnendng Sources & Us� 599.100 Budget Coat Savinga 0 4,&50 0 0 0 BUDGET WORI(SF�EET DRAFT Budget (a� &26-2014 Pege: 8 8/26I2014 Villege of Tequ� 4:57 pm Prior Currer�Yeer (8) (n (8) Year Odginal Amended Acluel Thru EsUmaOed MoMh:9/30@014 Ach�el Budget Budget September ToTal DEPARTMENT MANAGER COUNCIL Furnl: 001- Gsneral Fund Expenditur� Functlon: 410 Gerrerel Govemmerit Dept 110 Manager Other Flnandng Sources 8 Uae.s 0 4,850 0 0 0 0 0 0 Acxt Class: 600 CapBal Outlay 864.601 Computer Equipment 0 0 0 0 0 Cap(tel0utlay 0 0 0 0 0 0 0 0 Meneger 206,376 208,720 208,720 175,725 202,655 205,430 207,230 0 Dept 171 Human R�ourc� Acct Class: 510 Per�nal Servi� 512100 RegWar Salaries 8� Wag� 79,�3 79,8D0 78,800 88,318 79,605 113,900 118,100 515.103 Bonus Pay Plen 0 0 3,0� 3,000 3,W0 575.7W PartUmeSelerles 30,028 30,�0 33,300 26,654 �,770 518.tU0 Compensa�lAbsenc� 1,882 2,000 2,000 1,982 1,982 2,000 2,000 516.1 Q5 Compenseted Ab�nc� - HSA 1,220 0 0 0 0 521.101 FICA Taxes 6,705 7,000 7,124 5,885 6,785 7,000 7,300 521.102 M�I�reTexes 1,568 1,700 1,72.9 1,372 1,590 1,700 1,7U0 522102 VOT Perelon Contributlor�s 7,467 7,400 7,400 6,272 7,370 8,600 10,UU0 523.101 L(f�Health Insuram� 6,708 7,300 7,300 6,689 7,255 17,700 20,8U0 523.105 HSA - H�Ith �Nr�gs A�urrt 7,000 0 0 0 0 524.100 Workers' Comp Insurance 329 720 220 216 216 190 190 526.101 Employ� Recognitlon Piogram 6,774 5,500 5,500 5,290 5,500 5,500 5,5� 526.102 Employee Assistance Program 3,408 4,000 4,000 3,406 4,000 4,000 4,000 526.103 Eduratlon Retmbursemerrt Prgm 0 1,W0 0 0 0 7,000 1,000 554.307 Pe�nnel T�ainhig 2,060 2,500 2,500 2,100 2,500 2,500 2,500 554.310 Employee DevelopmeM 132 2,000 2,000 850 850 2,000 2,000 Per�nel Services 148,�2 150,720 155,873 132,014 151,383 167,090 175,090 0 Acct Ciass: 530 Operatlng ExpendiUu�lExpense 540.300 Travel8 Per Diem 1,840 1,300 1,300 1,248 1,300 1,300 7,300 546.32Q Computer system matrd & suppli 1,658 500 500 53 500 500 500 547.300 Prtrrtfig & Bindirtg 619 1,500 300 0 300 1,500 1,500 549.300 Other Misc Chgs 8 Obligatlons 0 500 327 126 327 500 500 549.401 ReauilmeMexpenses 257 1,000 500 401 500 1,500 1,500 552302 Smell Tools e� Equipmem 224 500 200 60 200 500 500 554.300 800k�, Publ, Subs & Membership 730 500 750 564 750 700 700 Operatlng Expenditur�lExper�se 5,329 5,800 3,877 2,452 3,877 6,500 8,500 0 Acct Class: 590 O�her Flnandng Sources 8 Uses 599.100 Budget Cost �vings 0 3,230 0 0 0 Other Flnendng Sourcea & Usea 0 3,230 0 0 0 0 0 0 Acct Class: 600 Cap(tal OuUay BUDGET WORK3I�T DRAFT Budget (a� &26-2014 Pege: 9 8f26P2014 Vmage of Teques� 4:57 pm Prior CurteM Ypr (6) (n (8) Y�r Oiiytrial Am�d� AcWel Tfw Esdmat� Month:9/30@074 Achiial Budget Budget SepOember Tofel DEPARTMENT MANAGER COUNCd Furtd: 001- General Fund E�en�res Fwctlon: 410 Gerreral Govemmeirt Dept 711 Hurt�an R�ources Acxt Class: 800 CepHal Outlay . 664.601 Computer EquipmeM 0 0 0 0 0 1,600 1,600 Cepftel0utley 0 0 0 0 0 7,600 1,8� 0 Hiurren Ra9ourc� 154,311 759,750 158,750 134,466 155,240 175,190 183.1� 0 Dept 120 Vl�age Cierk Axt Cless: 510 Per�nel SeMc� 572100 R�ular Saleri� & Weges 109.878 109,900 709,9� 94,082 109.630 712,500 112,500 514.100 OveRime 86 0 0 0 0 515.703 Bonus Pay Plan 0 0 3,000 3,000 3,000 516.100 Compen��ed Absenc� 0 0 0 0 0 516.10.5 Compenaemd A6.9enc� - HSA 1,388 0 0 0 0 521.701 FlCA Taxes 6,�4 6,500 6,730 5,68'1 6,670 7,400 7,600 521.102 M�I�are Tex� 1,493 1,600 1,800 1,329 1,560 7,800 7,800 522102 VOT Perislon ContribWor�s 10,288 10,200 10,200 8,637 10,065 9,500 9,500 523.101 LIfeIFleaHh I�uiance 23.180 25,100 25,100 22,323 24,070 18,800 17,400 523.1Q5 HSA - H�Ith �Nr�gs A�wd 1,700 0 0 0 0 524.100 Woriceis' Comp Insurance 325 220 220 216 218 190 190 526.103 Educatlon RehnbursemeM Prgm 0 0 327 326 327 554.301 Personrrel Tia6dng 1,565 2,250 1,823 100 1,923 1,98D 1,980 Personal Services 156,095 155,770 159,000 135,695 157,401 152,170 150.970 0 Acct Clasa: 530 Operatfig Expe�Ih�r�r�se 531.303 CodHic�tlon Servkk�s 8,888 8,700 15292 12,282 15,282 10,700 10,700 531.304 Rabrtllng Secy Service 7,511 7,350 7,350 5,156 7,350 7,350 7,350 534.307 Electlon F�nse 88'1 15,840 8,348 1,306 1,307 15,940 75,940 534.302 Legel Advertlshig 15,910 74,8I10 14,800 8,830 14,800 14,800 14,800 534.311 Electlon exp. - ennexetlore 10,030 0 0 0 0 540.300 Travel 8 Per Diem 2,859 3,050 3,050 1,167 3,000 3,440 3,440 541.300 Communicatlon Services 1,143 1,300 1,300 9&5 1,300 1,300 1,300 546.320 CompuOersystemmaint&suppli 2,844 7,300 1,500 495 1,500 19,300 19,300 548.110 Marlcetlng and Public Reletlm�s 0 0 400 400 400 2�00 2,200 548.100 MbcellaneousA�hfval 47 2,500 2,500 7W 7,500 2,500 2,500 549201 Advertlsir�g � Promotlon 187 1,000 600 0 0 549.300 Other Misc Chgs 8 ObOgaUons 217 1,800 1,800 692 1,fi00 2,300 2,300 552302 Smell Tools ar�d Equipment 508 50p 500 153 500 500 500 552306 MlcaoflUn ServiwlSuppli� 11 30 30 11 30 30 30 554.300 Books, PuW, Subs & Membershlp 466 860 860 344 B80 �0 8� �P�9 ���� 51,483 59,130 59,130 29.718 49,438 81,220 81,220 0 BUDGET WORKSF�EET DRAFT Budget (a� &28-2014 Page: 10 8/26/2014 VNage of Tequ�ta 4:57 pm Prior CurreM Y�r (6) (� (9) Y�r Origtrial Amended Ac�al Tfw Esffinet� Mwrth:9/30/2074 Achial Budget Budget September Totel DEPARTMENT MANAGER COUNCd FmM: 001- General FurM Fxpen�r� Fwctlon: 410 General Govemment Dept 120 ViDage Clerk Acct Cless: 580 Other FNandng Sour� 8 Uses 599.100 Budget Coat Sevhigs 0 3,230 0 0 0 Other Flnandng Sourt�s & Usea 0 3,230 0 0 0 0 0 0 Vlllege Clerk 207,5/8 218,130 218,130 1&5,413 208,840 233,390 232,190 0 �pt 730 Finance Aat Cless: 510 Personel SeMces 572100 R�ulerSelaii� 8 Wages 238,906 240,500 237,6fi5 203,606 237,501 245,100 245,100 514.100 OveNme 12 0 0 0 0 515.103 Bonus Poy Plen 0 0 7,950 7,950 7,950 516.100 Compenae0ed Absences 2,645 4,500 4,500 1,444 4,015 3,500 3,500 518.1Q5 Compenseted A�nc� - HSA 2,571 0 0 0 0 521.101 FlCA Taxea 74,354 14,800 14,400 12,079 74,�0 75,100 15,300 521.102 Medlcare Tax� 3,387 3,500 3,544 2,86'6 3,370 3,500 3,600 522102 VOT Pe�lon Contribudorw 22,133 ?2,Z00 22Z00 18,691 21,805 20,700 20,700 523.101 LffelHealih I�u�ar�ce 37,6'88 42,300 43,850 40,306 43,931 38,600 39,900 523.105 HSA - Health Savings Accourrt 3,350 0 0 0 0 524.100 Workers' Comp Insivance 7� 480 480 473 473 �0 380 525.100 UrremploymeMCampen�tlon 0 0 4,400 0 4,400 554.301 Personnel T�ainim� 3,490 4,600 4,800 980 4,600 4,400 4,400 Peraonal Servi� 330,304 332.880 343,689 288,395 342,345 329,280 332,880 0 Axt Cless: 530 Opeiatlng ExperMihueslF�cperree 532.300 Accountl� & Auditlng Services 23,908 24,200 23,8&5 23,865 23,865 24,610 24,610 540.300 TravelBPerDl�n 173 1,000 1,000 298 1,000 1,000 1.000 546.301 OfAce EquiplRepair � Matrrt 578 800 800 527 800 800 800 548.320 Computer sys[em meMt & suppll 6,447 8,800 8,800 7,027 8,800 8,800 8,800 547.300 PrNtlng&Bindir�g 1,322 3,000 1,800 1,759 1,8f10 3,000 3,000 549.300 Other Miac Chgs & Ob�gatlons 288 1,000 1,000 586 1,000 1,004 1,000 551.300 Ofiice Suppll� & EqulpmeM 3,448 4,000 3,286 1,451 3Z88 4,000 4,000 552302 Small Tools and Equlpmerrt 0 500 500 0 500 500 500 554.300 Books, Publ.Sulm 8 Membershlp 7,355 1,400 1,400 724 7,400 1,600 1,600 OperaUng ExpendiWr�vfExper�ae 37,520 44,700 42,457 36,237 42,451 45,410 45,410 0 Acct Class: 590 Olher Finandng Sou�s fl Us� 599.100 Budget Co� Sevings 0 8,560 0 0 0 Otlier Finandng Sources 8 Usea 0 8,560 0 0 0 0 0 0 Acd Class: 600 Cepftel Outlay 884.801 Compu6er Equfpment 1,259 0 0 0 0 Capflal0utley 1,259 0 0 0 0 0 0 0 BU�ET WORKSHEEr DRAFT Budget @ &2G2014 Pege: 11 B/28P1014 Vi�age of Teques� 4:57 pm Prior CurteMYear (6) (� (8) Yeer Origfrrel Amended Aduel Thru EatlmeOed Mmdh:9/30/2014 Actual Budget Budget 5ep6ember Totel DEPARTMENT MANAGER COUNCa Fund: 001- Geneial Fund ExpenmWres Functlon: 410 Gerreial Govemmer� Flrrence 369,083 386,140 386,140 324,832 384,786 374,690 378,290 0 Dept 140 L�al Acct Cless: 530 �Pe��9 ����� 531.301 Legel Services 118,593 90,000 90,000 82,383 1�,000 90,000 90,000 531.308 Legal fees - Per�nrrel 42,720 20,000 20,000 89,772 110.000 60,000 60,000 �P ����� 158,313 110,000 110.000 172,1&5 210,000 150,000 150,W0 0 Acct Class: 590 Other FlnmicUig Sources 8 Us� 599.100 Budget Cost Sevings 0 0 0 0 0 Other Ffnar�cing Sourc� 8 Us� 0 0 0 0 0 0 0 0 �� 159,313 110,000 110,000 172,785 210.000 150,000 150,000 0 Dept 150 Comprehens(ve Planning Acct Class: 510 Per�nel Services 5121 W Regular Selaries 8 Weges 0 78,000 78,000 66,750 88,538 515.103 Bomis Pay Plan 0 0 3,OW 3.000 3,W0 516.100 Comper�sated A6senc� 0 0 0 0 4,433 521.101 FlCA Tax� 0 4,800 4,900 4,055 4,485 521.102 M�IcereTax� 0 1,200 1,200 948 1,050 522101 FRS ConMbutlons 0 4,500 5,530 4,6&9 5,130 523.101 LifdN�ith Insu�ance 0 9,300 7Z50 6,843 6,843 524.100 Workers' Comp Inswance 0 280 280 272 272 Persone� Servic� 0 98,080 100,160 86,357 93,551 0 0 0 Acct Class: 530 Operatfig Expendihu�lEx�nse 531.301 Legal Servic� 27218 11,000 11,000 19,760 25,U00 30,000 22,OU0 537.321 Mapping Services 0 2,500 2,500 1,848 2,500 2,500 2,500 531.322 Misc Plenntng Service 103,891 62,500 63,420 56,900 76,930 746,080 135,200 531.331 B�rd af AdJustrnent 286 500 250 0 250 250 250 531.332 Planning erM Zanhig Board 535 1,000 750 500 750 750 750 537.4Q5 Legal-Mnexadon 5,415 0 0 0 0 534.3�0 Other Contrac�ual Ssrvic� 10,990 5,000 5,000 2,688 5,000 5,000 5,000 , 534.302 Legel Advertlsing 5,313 8,500 5,500 4,043 5,500 8,500 8,500 534.420 Legel Advertlsing - Mrrexetlon 875 0 0 0 0 548.320 Compu6er aystem maiM & suppll 0 0 4,800 4,200 4,800 4,800 4,800 547.3�0 Prtritlng & Bindir�g 0 500 500 0 500 500 500 549.150 Miscellaneous annexatlon exp 1,481 0 0 0 0 549.300 Other Miac Chgs 8 Obllgatlons 0 500 500 125 500 500 500 551.300 Oftice Suppll� & Equlpment 0 0 500 316 500 750 750 Operetlng Expenditure�lExper�ae 158,004 82,000 94,720 80,380 172,230 198,630 180,750 0 Acct Cless: 590 Other Flnendng Sourt�s 8 Uaes BWGET WORKSI�ET DRAFT Budget @ &26-2014 Page: 12 B@612014 Vmege af T�u� 4:57 pm Prlor CurteM Y�r (6) (1) (8) Year Odginal Amended Aduel Thru Estlnm� Mordh:9/30@014 Ach�al Budget Budget September Total DEPARTMENT MANAGER COUNCa FurM: 001 - Gen�al Fund ExpenmWres Function: 410 General Govemment Dept 150 Comprehensfve Plerndng Acct Cless: 590 Other Flnandng Sour� & Uses 599.100 Budget Cost Savhigs 0 0 0 0 0 Other Flnandng Sources & U�s 0 0 0 0 0 0 0 0 Acd Cless: 600 Cepftel Outlay 664.601 Computer Equlpmerd 0 0 0 0 0 �P� D�Y 0 0 0 0 0 0 0 0 Comprehens(ve Plennhig 156,004 190,080 194,880 176,737 215,781 199,q0 180.750 0 Dept 160 General CwvemmeM Acct Cless: 510 Personal Services 512.1� RegWarSalari�&Wages 69.666 68,800 69,800 59,790 69,667 71,500 71,500 515.103 Bonus Pey Plen 0 0 2,400 2,400 2,400 516.100 Compen�0ed Absences 0 4,000 8,411 2,7&5 6,411 4,000 4,000 516.105 Compenseted A�enc� - HSA 1,680 0 0 0 0 521.101 FlCA Taxes 4,256 4,600 4,749 3,757 4,540 4,700 4,500 521.102 M�IcareTexes 995 1,100 1,135 879 1,065 1,100 1,100 522102 VOTPensionConMbutlo� 6,535 6,500 8,500 5,4&9 6,400 6,100 6,700 523.101 LffelHeeiih Insurance 5,332 5,900 7,690 6,591 7,690 5,200 13,200 523.1Q5 HSA- H�Ith Sevim�s Axount 800 0 0 0 0 524.100 Warkers' Comp Insmance 206 140 140 137 137 120 1 ZIl 554.301 Personnel Trelning 0 5,000 5,000 995 5,U00 5,OU0 5,000 Personal Services 89,470 97,040 103,825 82,803 103,310 97,720 10.5,520 0 Acxt Gass: 530 Operatlng ExperMihueslExperise 534.300 Other Corrtachiel Services 71,015 20,000 20,706 19,201 20,706 20,100 35,100 534.303 Sp�al Evenb 4,048 10,000 10,OW 8,257 10,000 10,000 10,000 540.300 Travel & Per Diem 1,436 2,000 2,000 393 2,000 2,000 2,000 541.300 Communiratlon Services 12,787 13,000 13,000 11,704 12,700 14,500 14,500 541.301 Pasfage 3,104 3,000 3,500 1,902 3,500 4,300 4,300 541.30.5 Website Malrrtenence 7,BB9 7,800 7,900 7,770 7,770 8,100 8,100 543.300 UtllityServlcav 15,853 16,000 16,000 13,OB2 18,OW 16,000 16,000 544.3D1 Operering Leases 5,457 5,350 5,350 4,386 5,187 5,350 5,350 545.3001nsurence 45�969 48,900 48,900 48�7� 48.729 56�150 58�150 546.301 Oflice Equip/Repair 8 Maint 1,473 2,000 2,000 1,150 2,000 2,000 2,0� 546.302 Vehide Repair 8 Malntenance 20 100 100 20 100 100 100 548.303 Buadfig Repair 8 Melrrt 0 0 0 0 0 546.310 Equipmerrt Re�ir 8 Maint 1,916 1,000 1,000 388 1.W0 1,000 1,000 546.320 Computersys0emrtreint&suppli 11,Q51 13,400 13,400 12,106 73,400 25.000 17.750 547.300 PfiiWtg 8 Bimm�g 362 1,000 1,000 739 1,000 1,000 1,000 BUDGET WORI(BF�ET DRAFT Budget @ &28-2074 Page: 13 8f26@014 Vmege af Tequeate 4:57 pm Prior CurrerttYear (6) (� (8) Year Originel Amended Ach�al Tfw EstlrtmOed Mordh:9/30/2014 Actual Budget Budget Septemt�r Total DEPARTMENT MANAGER COUNCR. FurM: 001- Gene�al Fund Expen�rea Ftmctlon: 410 General Govemment Dept 160 Genetel GovemmeM Ncx:t Class: 530 Operabng ExperMihu�lExpense 549.300 Olher N�ac Chga 8 ObVgedons 2,745 8,000 8,3T1 7,257 8,377 10,000 70,000 549.302 Vmege Newsletter 19,101 18,200 13,499 4,532 9,000 19,000 19,000 549.304 Licer�. F� � Pertnib 7,980 2,�0 2,600 1,960 1,960 2,600 2,800 557.300 Oflice Supplies 8 EquiprtreM 4,119 4,000 4,000 2,882 4,�0 4,000 4,000 5521� R Operadng Suppll� 309 800 800 617 800 800 800 552301 Gas & 00 175 500 500 135 250 500 500 552.302 Smell Tools arb EquipmeM 618 1,500 1,5� 5Q5 1,500 1,500 1,500 554.300 Books, Publ, Subs 8 Memberahlp 2,056 4,500 4,500 2,553 2,500 2,500 2,500 Operatlng Expenditur�lExper�se 164,243 183,750 180,632 148,268 172,479 206,500 214,250 0 Acct Class: 590 Other Flnandng Sourt�s & Uses 599.100 Budget Cost Sevhigs 0 2,590 0 0 0 Other Finendng Sour� 8 Uses 0 2,590 0 0 0 0 0 0 Acct Class: 600 CepHel OuUey 664.600 MadilEqulpmeM 0 0 0 0 0 664.601 Computer Equlpment 6,680 0 0 0 0 6'64.602 Vehl�J�v 0 0 0 0 0 Cepftel0utlay 6,�0 0 0 0 0 0 0 0 Generel GovemmeM 2�,393 283,380 284,457 231,071 275,789 304,?20 319,770 0 General Govemment 7,536,249 1,583,600 1,589,4T/ 1,400,373 1,678,500 1,8T/,550 1,686,420 0 Functlon: 420 Public Sefety Dept 175 Police DepertmeM Acct Cleas: 510 Per�nel Servicav 512177 Se18Weges-Admirqtratlon 121,206 123,500 123,500 104,671 122,330 128,600 128,600 512172 RegSalBWeg�-Communiratlo 244,353 245,100 245,100 208,680 244,370 251,000 251,000 512175 RegSelBWag�-OperaHons 918.133 1,032,900 933,294 782,449 921,W0 1,068,400 1,012,800 5121 BO Reg Sel 8 Wag� - Code Fsf 0 0 0 0 0 59,750 514.172 Overtlme-Communipdons �,489 10,000 24,965 17,571 24,985 21,000 18,000 514.175 Overtlme-Operetlor�s 57,733 70,OU0 133,000 118,�8 133,000 80,000 63,500 515.101 Ho�dey Pey 42,253 48,8W 48,900 36,235 41,000 43,600 43,600 515.103 Bonus Pey Pian 7,500 7,250 13,250 13,250 13,250 7,300 58,250 515.106 Clothing8800tAllowance 11,724 12,250 12,250 10,619 11,260 73,300 12,700 515.107 PaR-time Seleri� 0 0 32,Q00 23,882 32,000 515.108 Auto Alloxrence 4,000 6,000 6,000 5,500 6,000 6,000 6,000 515.120 Cell phorre allowence 800 1,200 1200 1,100 1,200 1z00 1,200 515.125 OtherPJlowanc�s 13,600 8,400 8,400 7,700 8,400 8,400 8,400 515.172 PITSeIery-CommuNratlons 27,213 18,200 40,000 31,031 40,W0 24,000 24,000 515.175 Pff Salary-Operatlons 80,945 0 0 0 0 46,600 46,600 BUDGET WORKSi�ET DRAF1' Budget (a� &26-2074 Paga: 14 8(28/2014 VIDage of Tequ�la 4:57 pm Prior Cur�eMYear (6) (n (8) Year Original Amended Achiel Thru Estlmated Mordh:9l30/2014 Actual Budget Budget Septsmber Totel DEPARTMENT MANAGER COUNCa Fund: 001- General Fund E�endflures Fimctlon: 420 Pub�c Sefety Dept 175 PaOce DeperhneM Acd Ciass: 510 Personel SeMces 515.180 PfT Salary - Code Fs(orcemeM 0 0 0 0 0 16,900 516.1U0 Compen�lHl�ences 30,012 15,000 33,838 33,838 33,&38 15,000 15,000 516.105 Compensat� Absenc�s - HSA 35,588 0 0 0 0 521.101 FICATaxes 95,401 85,700 96,686 83,155 98.�6 107,700 102,000 521.102 M�licare Tex� 22,312 22,700 72,944 19,483 22,944 25,800 24,2� 522101 FRS Co�rtributlorre 47,446 37,000 44Z00 36,096 44,200 39,8W 39,600 522.102 VOT Pe�lon Corttributlons 159,218 156,600 138,900 117,729 138,900 126,000 108,300 5221Q5 Defln� Contributlon 7,909 31,500 20,500 16,327 7A,000 Z7,700 58,000 522110 Other Pensian CoriMbutlons 76,177 0 0 0 0 523.101 Lif�Health Ireurar�ce 220,014 272,800 233,502 212,584 232,070 240,70D 221,800 523.105 HSA- Hedlth Savir�gs Accoimt 27,900 0 0 0 0 524.100 Workers' Comp Insu�ance 37,930 45,430 45,430 45,425 45,425 32,540 32,540 525.100 UnemploymerrtCompsn�ion 7,877 0 635 635 635 526.101 Emptoyee R�n(tlan Program 162 3,000 3,OU0 1,207 2,500 3,000 3,000 526.103 Eduratlon Reimbur�meM Prgm 0 4,000 1,000 0 0 4,000 4,000 526.105 Employ� PhysicallPsycalogical 1,789 6,000 9,000 8,833 9.000 8,000 B 554.301 Pe�nrrel Trahiing 3,839 11,000 11,000 8,907 11,000 11,000 11,QW Per�nel Servic� 2,325.541 2,�4,430 2,282,495 7,946,405 2,255,974 2,418,490 2,302,090 0 Acct Class: 530 Operatlng Expemifhu�lExperise 531.301 L�al Services 21,389 25,000 25,000 18,240 20,OU0 531.320 Cade Fsfarcement Service 7 4,W0 4,�00 873 2,009 531.327 Other ContracWal -MTMS 0 0 22,000 0 12,OOD 40,400 40,400 540.300 Travel & Per Dfem 8,360 13,000 13,OD0 8,401 8,800 12,000 1Z,000 541.300 Communiratlon Servic�s 25,905 32,000 29,000 23,255 26,000 32,000 32,000 541.301 Postage 2,585 2,000 2,000 1,524 2,D00 2,000 2,000 543.300 UtlIHy Servic�s 24,756 28,000 28,000 20,603 25,300 25,000 25,OW 544.301 Operetlng Leasea 1,729 2,100 2,100 1,829 2,100 2,000 2,D00 545.3001naivance 42,536 47,700 48,350 48,483 48.483 56,750 56.750 546.175 K-9 EquipmeM 8 Mair�ance 0 0 4,047 3,473 4,000 8,000 6,Q00 546.301 Offlce EquiplRepair & Meint 7T/ 1,000 1,000 290 1,000 1,000 1,Q00 546.302 Vehide Repah fl Meirdenance 44,114 40,000 25,365 22,325 25,365 18,500 18,500 546.303 Buildhig Repair8 Maint 21,265 20,000 20,600 12,862 20,000 19,100 19,100 546.304 Commimi�tlon Equip MaiM 13,143 16,OQ0 92,405 91,836 92,4Q5 12,800 12,800 548.310 EquipmeM Re�ir 8 MaiM 3,168 7,700 8,700 975 3,900 2,500 2,500 548.320 Compuler system maint & suppli 44,347 69,000 73.500 65,407 73,500 100,500 86,500 547.300 Prh�dng & Bmmr�g 334 2,000 2,500 2,713 2,500 1,800 1,800 swcFr wowcs�r DRAFT Budget (a3 &2E2014 Page: 15 8126/2(114 V�e of T�{u� 4:57 pm Prior CurreM Y�r (6) (� (8) Yeer Originel Amended Achiel Thru Eetimeted Mordh:9/3012014 Achiel Budget Budget September Totel DEPARTMENT MANAGER COUNCIL Fund: 001- Generel Fund Expenditures Fwctlon: 420 Public Safety Dept 175 PoOce Departrner� Acct Class: 530 Operatlng ExpendihueslExper�se 549.300 Otlier IM� Chga 8 ObOgatlons 6,209 5,500 5,500 4,802 5,500 5,000 5,000 549.303 Im�tlgative Fxpenses 1,078 1,100 1,100 1,142 1,100 1,100 1,100 549.304 Licer�ses, Fea9 8 Pemiits 2,323 3,000 3,000 1,824 3,000 2,500 2,500 549.311 Marirre Unit Operatlona 1,671 3,000 3,000 2,293 2,500 1,750 1,750 549.314 KEY.S. Program � 0 2,500 1,000 700 1,000 549.407 ReauihneM expensea 5,457 0 0 0 0 551.300 Office Suppll�v 8 Eq�ripment 5,085 5,000 5,000 4,333 5,000 5,000 5,000 551.301 Cfine Preventlon Supplie,v 3,014 4,000 4,000 1,214 4,000 2,500 2,500 552301 Gas 8 Otl 65,735 70,000 60,000 46z17 60,000 63,000 63,000 552302 SmaO Tools arM Equipment 112,99 9,000 20,000 14,177 20,000 12,000 12,000 552305 Uniforms 20.308 20,000 r1,500 78,298 22,500 18,000 18,000 554.300 Books, Publ, Subs 8 Membership 1,780 4,000 4,000 7292 3,000 2,400 2,400 ��9 ������ 378,334 434,600 526,687 418,785 SW,953 445,600 431,600 0 Aa:t Gle�: 590 Other Flnendng Sources 8 Uaes 599.100 Budget Cost Sav6igs 0 6,460 0 0 0 ��+���9 �� &� 0 6,480 0 0 0 0 0 0 Acet Cless: 600 Cep(tal Outlay 663.710 Police Departrnerrt Capi�l Proj 10,710 0 2,333 2,333 2,333 664.6U0 MechlEquipmeM 26,1� 0 719,926 215,216 215,216 �4.801 Computer EquipmeM 3,265 0 9,000 0 9,000 �4.602 Vehides 63.751 �,000 60,000 0 60,000 240,000 240,000 664•620 �r�an9lb�e - Software 0 0 0 0 0 Capital0utley 103,855 60,000 301,259 217,549 286,549 240,000 240,000 0 Po�ceDeperlmeM 2,8W,730 2,785,490 3,110,421 2,58'L,739 3,050,476 3,102,090 2,973,890 0 Dept 180 BuOding 8 Zonfng Aa�t Class: 510 Personal Services 572100 Regular Saleri� & Weg� 1?2,968 45,300 45.300 38,786 52,463 194,900 203,3� 515.103 Bonua Pay Plan 0 0 0 0 0 515.108 Clothing & Baot Nlowance 0 0 0 0 0 100 515.107 Pert Ume Selerle,v 28,238 0 20,130 11,4fi3 14,800 16,900 42,800 518.100 Campenset� A�enc� 609 0 0 0 0 516.105 Compen��ed Abaenc� - HSA 1,480 0 0 0 0 521.107 FICATax� 9,253 2,800 4,040 3,088 4,140 6,900 15,100 521.102 MedicareTex� 2,164 700 960 772 970 1,700 3,600 522101 FRS ConMbutlons 4,430 0 0 0 0 522.102 VOT Per�slon Contributlona 4,239 4,200 4,200 3,560 4,820 9,500 17,200 BUDGET WORI(SHEEr DRAFT Budget (d� &2E2014 Pege: 16 8/26/2014 VNage of Tequ�ta 4:57 pm Prior CurteMY�r (6) (n (8) Yeer Odghiel Amend� AcWel Thru Estlrrrer�d Morrth:9l30I2014 Achiel Budget Budget SepOember Tafal DEPARTMENT MANAGER COUNCIL Fu�: 001- Gene�al Fund Expendihires Functlon: 420 Public Safety Dept 180 Bunding 8 Zontrig Acct Class: 510 Personel Servi� 523.101 LffelHeelth Irisurance 15,072 9,700 9,100 8,299 9,015 74,700 32,SU0 523.1Q5 HSA - H�lth Savi�s AccouM 1,000 0 0 0 0 524.100 Workers' Comp Insurance 373 180 160 158 158 3,230 3,230 525.100 UnemploymentCom�nsatlon 0 0 504 3,209 3,209 1,000 1,000 554.301 Per�nrrel Tralnhig 295 1,500 0 0 0 Personel5ervic�a 188,131 63,760 84,384 69,285 89,575 248,830 318,630 0 Axt Cless: 530 OPeretln8 ExperMitureslExper�se 531.301 Legel Servic�s 0 0 2,020 1,995 2,020 26,000 20,000 531.320 Code FnforcemeM Service 0 0 0 0 0 4,000 4,000 531.325 Inspectlon Servic�es 121,684 160,880 138,050 141,123 164,W0 75,000 &5,000 534.300 Other Contractual Services 4,74D 0 8,000 9,000 9,�0 6,000 8,000 540.300 TrevelBPerDiem 586 1,170 0 0 0 500 500 547.300 Communicatlon Servi� 2,56g 3,240 2,650 2,270 2,650 3,000 3,000 541.301 Poslege 7,416 1,500 1,500 349 1,500 7,000 7,000 543.300 UdIllyServices 5.992 6,500 6,790 4,877 6,100 6,000 6,000 544.301 Operadng Leas� 7,903 1,910 1,910 1,719 1,875 1,850 1,850 546.301 Offlce EqulplRepalr & Mahit 7,Q36 1,500 1,000 722 1,000 1,000 1,000 546.303 BuOdir�g Repalr & Mamt 0 0 0 0 0 546.320 Camputer system meint & suppll 3,683 14,400 11,410 9,961 11,�0 13,500 12,600 547.300 Printlng 8 Binding 853 1,000 1,000 532 1,000 1,500 1,500 549.300 Other Misc Chgs & Obligatlons 145 600 600 645 645 600 800 549.304 Licer�, F� 8 PertnNs 1,339 1,400 1,436 1,435 1,435 1,700 7,700 551.300 Office Supplies 8 EquipmeM 2,435 3,000 3,000 1,402 3,�0 3,000 3,000 554.300 Books, Publ, Subs 8 Memberehip 990 1,250 950 940 940 500 500 Operffifng Expenditur�lEx�nse 148,751 798,150 181,716 176,970 206,525 145,150 128,250 0 Acct Ciasa: 600 CepHal Outlay 664.600 MechlEquipmeM 0 0 0 0 0 �4.601 Computer EquipmeM 0 0 0 0 0 664.6201ntang@le-Software 0 0 0 0 0 �P� �eY 0 0 0 0 0 0 0 0 Bulldir�g&Zoning 336,882 261,910 266,110 246,255 296,700 393,980 446,880 0 Dept 192 Flre Control Acct Cless: 510 Per�nal Services 512.100 Reguler Salari� & Weges 1,407,129 1,451,400 1,458,150 1,251,119 1,458.150 1,493,800 1.512,500 514.100 Overtime 45,586 56,100 59,800 53,358 59,BQ0 S6,B00 58,800 514.300 Overtime-Treinfng 9,6'85 19,800 19,800 9,916 18,500 19,500 18,500 ewaer wo�cs�r DRAF'f Budget @ &2�2014 Pege: 17 8/26/2014 VNage of Tequeam 4:57 pm Prlor CurreMY�r (B) (7) (B) Year Originel Amended AcNel Thru Estlmeted MoMh:913012014 Acwal Budget Budget September Totel DEPARTMENT MANAGER COUNCIL Fund: 001- Generel FurM Expendihues Fimctlon: 42f1 Public Safety Dept 192 Fhe Contral Acct Cless: 510 Personel Servi� 515.101 Ho�day Pay 47,849 49,200 49,643 45,247 49,643 49,700 49,700 515.103 Bonus Pay Plan 0 0 58,SU0 58,5W 58.500 515.107 Pert-ffine Selari� 39,ZW 50.400 50,400 34,366 48,500 50,900 50,900 515.110 InOem Flre Flghffir Pay 58,429 58,700 58,700 49,184 57.700 61,200 61,200 515.12(I Cell phorre ellowance 1,200 1,200 1,2� 1,100 7,200 7,200 1,200 515.125 OtlierAllowanc� 1,200 3,600 3,800 3,300 3,BUU 3,600 3,600 518.100 CompenseGed Absences 3,297 3,609 3,600 1,420 3,600 19,600 19,600 518.1 Q5 Compensetsd Al�venc� - HSA 28,780 0 0 0 0 521.101 FICA Tax� 96,015 102,200 103,862 88,121 103,862 105,800 107,700 521.102 Medicere Taxes 72,455 23,900 24,289 20,609 24,289 24.700 25,200 522102 VOT Pe�lon Cmitributlor�s 343,772 345,500 358,000 306,364 356,000 348,600 353,500 522110 Other Pension ConMbuHons 117,996 154,700 118,000 0 718,�0 118,000 718,000 523.101 LffelHealth Irisurance 205.908 221,700 210,087 190,889 206,615 180,000 782,900 523.705 HSA - H�Ith �vir�gs A�uM 24,300 0 0 0 0 524.700 Workers' Comp Insurance 55,983 55,fi60 55,660 55,654 55,654 49,100 49,100 525.100 Unemploymerrt Compensetlon 0 0 0 0 0 526.701 Employ� Recognitlon Prt�gram 0 2,930 2,9� 1,728 2,200 2,950 2,950 526.103 Educatlon RehnbursemeM Prgm 9,178 15,400 15,400 12,026 15,400 19,900 19,900 526.1041CMA-DefCompPlen 0 0 1,620 929 7,820 4,900 4,900 528.1Q5 EmployeePhysicaVPsycaloglcal 8,912 9,870 9,870 8,433 9,500 9,900 9,900 554.301 Personnel Trainir�g 2,589 9,070 B,WO 3,107 6,070 9,200 8,200 Personal Servic� 2,527,428 2,634,930 2,866,981 2.184,870 2,658,203 2,629,150 2,658,250 0 Acct Cless: 530 Operatlng ExpendihiravlEzpsnse 531.318 Volurdeer Flre Flghter Progiam 5,448 7,780 7,680 6,852 7,500 540.300 Travel 8 Per Diem 1,232 5,930 955 666 955 5,300 5,300 541.300 Cammunic�Uon Services 14,439 13,080 12,058 11,883 12,Q58 13,700 13,700 541.301 Pos�ge 1,482 1,500 1,500 1,749 1,500 1,500 7,500 543.300 Utllity Services 27,400 27,800 28,802 24,815 T/,500 30.850 30,650 544.301 Operatfig I.eases 7,841 7,920 7,920 5,232 7,796 5,760 5,760 545.3001nsivance 24,499 21,900 21.900 21,736 21.9U0 22,400 22,400 546.302 Vehlde Repatr 8 Meirdenence 8,123 5,670 5,670 2,487 5,200 4,700 4,700 546.303 Bu�ding Repelr 8 Melnt 21,�8 Z3,610 29,710 21,93'1 26,700 25,850 25,950 546.310 Equlpmer� Re�lr & MaiM 21,478 22,020 22,020 15,379 22,020 72,750 22,750 546.320 Computer aystem melM & suppll 13,903 19,500 18,500 13,975 19,500 32,809 28,900 547.300 Printlng 8 Binding 892 1,420 1,420 742 1,300 1,450 1,450 549.300 Other Mlsc Chgs 8 Obllgetlons 4,198 3,200 3,20D 2,0&9 3,100 3,850 3,850 BUDGET WORKSI�ET DRAF1' Budget (a� &28-2014 Pege: 18 8128l2014 Wlage of T�uesha 4:57 pm Pdor CuReMYeer (6) (� (81 Year Origfnal Amend� Achial Thru Estlmat� MoMh:9/30@014 Achiel Budget Budget Ssptsmber Tolal DEPARTMENT MANAGER COUNCIL Fur�d: 001- Geneial FurM Expendihu� Functlon: 420 Pub�cSafety Dept 192 Flre Control Acxt Cless: 530 OP��9 ����� 549.304 Licer�ses, F�s & PertnHs 17,104 17,590 17,590 15,954 17,100 18,850 18,850 549.311 Merine Unit Operatlons 1,650 5,370 4,734 1,974 3,500 3,900 3,900 549.397 Bed Debt Fxpense 77,504 0 0 0 0 551.300 OHice Suppli�a & Equipmerrt 2,�8 2,780 2,7A0 2,403 2,600 2.7U0 2,700 551.302 Flre Preventton Educatlon 2,268 2,310 2,310 1,280 2,300 2,350 2,350 552.301 Gas & Oil 14,812 19,920 19,920 12,986 16,500 17,700 17,700 552.302 SmaO T�Is erb Equipmerrt 0 2,920 2,920 2,259 2,920 3,250 3,250 552.304 Chemicals 950 990 890 950 950 7.000 1,D00 552305 Unfforma 71,882 23,310 23,310 18,275 23,000 23,350 23,350 552308 SefetySupp� 8,829 27,000 16z58 11,102 16,258 21,700 21,700 552.310 DI�sGer Relief SuppU� 0 5,300 5,3� 0 4,500 5,300 5,300 552.311 CPR Pragram Suppli� 316 400 500 500 500 550 550 552.312 M�ical Supplies 37,799 37,200 36,200 30,637 38,200 38.OW 38,000 552344 Flre Sfedon Suppli� 2,364 3,000 3,000 2,848 2,800 3,000 3,000 554.3U0 Bool�, Publ, Subs 8 Membership 2,519 3,050 3,050 2,296 3,050 3,300 3,300 Operatlng ExpeiMihir�lEx�nse 333,�6 306,460 301,2W 232,�7 289,207 315,760 309,860 0 Acct Cless: 590 Olher Flnandng Sourca� 8 Uses 599.100 Budget Cost �vings 0 58,140 0 0 0 Other Flnancing Saur�es & Uses 0 58,140 0 0 0 0 0 0 Acct Class: 600 Capflel OuUay 664.600 Mech/Equipmerrt 8,604 432,850 540,080 540,080 540,080 ?2,000 Z2,000 664.62fllr�ngible-Soflware 0 0 0 0 0 Capital0utley 8,�4 432,850 540,OB0 540,080 540,080 22,000 22,000 0 Flre Control 2,869,328 3,432,380 3,508,268 2,967,331 3,487,490 2,966,910 2,990,110 0 Public Sefety 6,013,940 6,479,780 6,884,799 5,796,325 8,834,068 6,462,980 8,410,680 0 Fwctlon: 431 Transporta8on Dept 210 Pubtic Worka Acct Ciess: 510 Personel Servic� 512.100 Reguler Setedes 8 Wag� 183,951 198,300 188,100 164.487 186,850 183,100 183,100 514.100 Overtlme 919 1,000 1,000 211 1,000 1,OOD 1,000 515.103 Bonus Pey Plan 0 0 1,500 1,500 1,500 515.106 Clolhhig 8 Boot AOoxance 400 550 550 550 550 550 550 515.107 Pert Ume Salari� 11,835 19,800 19,800 15,345 17,600 20,200 20,200 515.108 AutoAllowance 750 900 1,800 1,650 1,600 450 450 516.100 Compen�ted A6senc� 0 0 15,387 756 18,620 516.10.5 Compensa�ed Absences - HSA 0 0 0 0 0 521.101 FlCATexes 11,171 12,400 73,600 10,502 13,U05 17,9W 12,100 � BUDGET WORKSI�ET DRAFf Budget (a� &2G2014 Page: 79 8f�12014 Wlage af Tsques� 4:57 pm Prior CurteM Y�r (6) (� (8) Year Originel Amend� Achial Tfw Estlmat� Mor�th:9/3012014 Actual Budget Budget September Total DEPARTMENT MANAGER COUNC� Fund: 001- Generel Fumi Fxpendihira9 Fwctlon: 431 Trensporletlon Dept 210 Public Works Acct Cless: 510 Peraonal Servic�s 521.102 M�licare Texes 2,813 2,900 3,185 2,458 3,050 2,800 2,900 522101 FRS ConMbutlons 5,317 7,800 9,125 7,286 8,�5 522102 VOT Perrelon Contributlor�s 10,5/2 12,000 12,000 9,875 11,560 15,500 15,5� 523.101 LifelH�Nh Insuiarice 68,538 74,900 64,123 61,420 &5,465 54,600 60,000 523.10.5 HSA - Health Savir�gs Accourrt 850 0 0 0 0 524.100 Workers' Comp Insmance 10,877 17,180 17,180 17,173 17,173 12,530 12,530 Personal Ssrvic� 305,794 345,730 347,350 293,191 346,958 302.630 308.330 0 Acct Class: 530 Opeiathng E�emif4�r�lEx�nse 537.302 Engin�ring Servic� 7,381 2,000 2,000 5,162 5,162 2,000 2,000 534.300 OtherCorttracwalServices 500 2,000 2,000 0 1,OW ' 1,000 7,OW 540.300 Trevel 8 Per Diem 0 250 250 0 0 150 750 541.300 Commimication Services 4,205 4,000 4,350 4,090 4,500 4,000 4,5� 543.300 UtllityServices 90,793 90,000 90.000 80,203 98,000 112,000 112,OW 543.301 Sheet Lights 724,847 , 120,000 120,000 111,402 133,285 125,000 735,000 544.307 Operadng L�sas 1,125 1,200 1,200 949 1,200 1z00 1,2U0 544.304 FEC Lzase 11,185 14.750 14,150 14,031 14,031 14.850 14,fi50 545.300 Insurance 14,333 10,500 10,500 10,463 10,463 12,900 12,900 546200 R&M-Stattonll 2,011 2,500 2,500 0 0 2,500 2,5� 546.301 Oflice EquiplRepeir & Matrit 705 200 200 63 2t10 200 200 546.302 Vehicle Repair 8 MaiMenance 2,627 4,OQ0 4,000 1,764 4,009 4,000 4,000 546.303 BuOdtrig Repair & Ma6it 26,896 B 10,500 9,fi58 11,OQ0 12,000 12,OU0 546.30.5 Pathwey MainOanance 7,410 10,000 10,Q00 2,962 10,OOD 12,000 72,000 546.306 GerteralMairdsr�ance 11,1W 30,009 30,000 25,736 30,WD 30,000 30,000 546.309 Lendscgpe � Ir�gaGon Maint 133,549 132,009 132,000 105,fi38 132,000 137,000 137,QU0 546.310 Equipmerrt Repair & Mehit 9,424 11,000 11,000 9,367 11,000 11,000 11,000 546.320 ComputersystemmeiMBsuppll 293 1,100 1,100 308 1,100 1,700 1,250 546.350 R 8 M- Roads Z3,006 25,000 25,000 23,558 25,000 30,000 30,000 549.300 Other IMsc Chgs & 0611gallons 2,902 4,000 4,000 1,466 3,500 3,500 3,500 549.304 Licer�es, F� & Permib 1,957 4,500 4,500 1,4� 1,500 1,500 1,500 551.300 Offlce Suppliav & Equipmsnt 97 450 450 133 450 45D 450 551.400 JanHorlal Supplie.v 5,416 5,500 5,500 4,737 5,500 6,UQ0 6,000 552301 Gas & 011 7,378 8,000 B 5,748 8,000 6,000 6,000 552302 Smell Twls and Equipmertt 4,212 1,500 1,500 4 1,500 3,000 3,OW 552305 Un(forms 1,257 2,000 2,000 1,410 2,000 2,000 2,000 553.301 R�d Signs 1,168 2,000 2,OU0 1,652 2,000 2,500 2,500 563.600 Public dVorks Misc ProJects 0 5,500 2,850 2,45'8 2,650 5,500 5,500 BUDGET WORKSF�ET DRAFf Budget (a� &26-2014 P�e: 20 8Y16l2014 Vmage of Tequesta 4:57 pm Prior CurtentYear (6) (n (8) Year Original Amend� Ach�el Thru Estlrtieted Mo�h:9l30I2014 Achial Budget Budget September To�l DEPARTMENT MANAGER COUNCd FurM: 001-GeneralFurb Expendihrres Fwctlon: 431 Trensportatlon Dept 210 Public Works Operetln9 F�erMihu�lExPeroe 495.185 499,350 499,350 424,400 517,641 543.750 553.800 0 Acct Ciess: 590 Other Finandng Swroes & Usea 599.100 Budget Cost SavNgs 0 1,620 0 0 0 �� ��8 �� & �� 0 1,620 0 0 0 0 0 0 Acct Clasa: 800 Capifel Outlay 6'64.600 MadUEquipmeM 0 0 0 0 0 15,000 15,000 664.602 Vehides 0 0 0 0 0 60,000 60,000 CePitelOudey 0 0 0 0 0 75,000 75,000 0 Pub�cWarks 800,959 848.700 846.700 717,597 863,999 921,380 937,130 0 Trensportatlon 800.959 846,700 846,700 717,591 8�i.999 921,380 837,1� 0 Functlon: 450 Lelsure Servl� Dept 231 Leisure Senricea Aat Cless: 510 Peraonal Service.s 572100 Regular Salari� 8 Weges 159,395 159,700 159,700 136,799 159,400 183,800 763,600 515.103 Bonus Pay Plan 0 0 6,000 6,000 6,000 515.106 Clothhig 8 Baot Allaivence 100 700 100 100 100 100 700 515.107 Part-tlme Seleries 40,150 45,100 45,100 35,074 42,000 47,300 47,300 515.108 AuOo Allowance 3,000 3,000 3,000 2,750 3,000 3,000 3,000 515.109 Seasonel Salaries & Weges 24,609 30,000 30,000 19.960 24,000 30.000 30.OW 516.100 Compensat�A�ences 3,629 3,500 3,500 638 1,515 4,000 4,000 516.1Q5 CompensetedAb.aences-HSA 3,106 0 0 0 0 521.101 FlCA Taxa 13,532 14,400 74,648 71,fi83 13,900 14,800 14,900 521.102 Medl�reTex� 3,165 3,400 3,458 2,732 3,300 3,500 3,500 522.102 VOT Perelon ContribuUor�s 14,951 14,800 14,800 12,558 14,635 13,800 13,800 523.101 Life/Flealth Inaurance 39,585 42,700 42,700 39,100 42,530 36,400 38,200 523.10.5 HSA - H�Ith Sevings Aa;ount 3,400 0 0 0 0 524.100 Workeis'Compins�uance 8,184 7,170 7,110 7,100 7,100 6,080 6,080 525.100 UrremploymeM Campern,�tlon 0 0 0 0 0 526.70.5 Employee PhysicaVPsycologit�l 808 2,500 2,500 757 2,500 2,500 2,500 554.301 Peraonnel TiatriNg 535 1,200 1,200 0 1,200 1,200 1,200 PersonelServi� 318,148 327,510 333,816 275251 321,180 326280 328,160 0 Acd Class: 530 Ope�atln9 Expeodfh���lExperise 534.303 Special Ever� T1,�9 20,878 40,578 40,578 40,578 45,000 45,000 540.300 Travel & Per Dlem 0 1,500 1,500 0 1,500 1,500 1,500 547.300 Communiratlon Servic�a 5,402 5,700 5,854 5,271 5,800 5,700 5,700 541.301 Poslege 48 150 150 25 150 150 150 543.300 UtlIKy Servi� 11,174 14,000 14,000 8,764 12,000 14,000 14,000 BUDGET NfORKSFIIEETT DRAFT Budget @ &2fr2014 Pege: 27 8@812014 VfOage af T�uesm 4:57 pm Pri�or Curtent Y�r (6) (n (9) Year OrigNel Amend� Achial Thru EatlmaOed MoMh:9/3012014 Achiel Budget Budget Septeml�r Totel DEPARTMENT MANAGER COUNCd Fu�: 001- General Fu� F�ryendiwres Fimcdon: 450 Lelsure Servl� Dept 231 Leisure Servicea Axt Class: 530 Operadn8 ExPeodfhu�lE�e� 545.3001ns�uance 14,396 74,500 14,5U0 14,494 74,494 14,800 14,900 548.302 Vehide Repatr 8 Meintenance 3,115 3,200 3,200 505 3,200 3,200 3,200 546.303 BuildMg Repalr 8 Ma6it 18,872 2f1,000 27,484 22,473 27,484 20,000 20,000 546.308 Gerre�al Mal�eirer� 35,675 30�000 30�000 22,887 30,000 30,000 30�000 546.370 Equipment Re�lrB MeUrt 1,307 1,700 1,700 801 1,700 1,700 1,700 546.320 Computer system metrd fl suppll 2,004 7,700 4,064 3,345 4,064 4.000 2,650 549201 Adv�tisir�g 8 PromoUon 8,454 5,000 4,546 4,546 4,546 5,000 5,000 549.300 Other Misc Chgs 8 Ob�getlons � 7,525 5,000 2,215 357 2,215 5,000 5,000 549.304 Liwnses, Fe� 8 PerMis 1,973 2,200 2,200 1,762 2,2W 2200 2,200 549.332 Reaeation Progrem Experise 35,031 38,300 37,415 33,786 37,415 �,300 38,300 549.333 SpdnglSwnmer Camp 15,881 15,000 15,000 11,584 15,000 15,000 15,000 551.300 Offlce Supplies 8 EqWpmerrt 2,041 2,000 2.000 1,192 2,000 2,000 2,000 551.315 Conc�slon Supp�� 4,851 5,000 2,498 2,498 2,498 5,000 5,000 552301 Ges 8 0� 1,928 2.500 2,500 1,563 2.500 2,500 2,500 552.302 Smell Too6s end Equipment 1,500 1,500 1,500 707 7,500 1,500 1,500 55230.5 Unlforms 159 500 500 45 500 500 500 554.300 Bool�. Publ. Subs 8 Membarahip 2� 500 500 0 500 500 500 Opered�9 E��Ihu�lExper�se 243.783 190,828 213,904 177,203 211,844 217,fi50 218.300 0 Acct Clasa: 590 Other Flnendng Sources & Us� 598.100 Budget Cost Sevings 0 6,460 0 0 0 Other Flnandng Sources & Uses 0 6,460 0 0 0 0 0 0 Aat Class: 800 Cepitel 0utlay 664.600 MachlEQidpmeM 0 0 1,200 1200 1,200 �eP� O�eY 0 0 1,200 1,200 1,200 0 0 0 Leisiue SeMces 561,942 524,798 548.820 453,654 534,224 543,830 544,480 0 Lelaure Servl� 561,942 524,798 548,920 453,654 534,714 543,930 544,480 0 Functlon: 581 Otlier Flnendng Sourt�s end Us Dept 900 Interfund TransFers Acd Class: 591 I�rfund Tianafers Out 591.301 Trsf to Cepflal Imp Fund 0 0 0 0 0 IrnerfurM T�ansfew Out 0 0 0 0 0 0 0 0 IMerfund T�ar�sfera 0 0 0 0 0 0 0 0 Dept 910 Olher Flnendr�g So�ucea 8 Us� Acct Class: 590 Other Flnendng Sources 8 Uses 587.100 Unreelized Loss on Inv�lmenb 0 0 0 0 0 Otlier Flnaming Sourc� & Uses 0 0 0 0 0 0 0 0 Other Flnendng Sources 8 Uses 0 0 0 0 0 0 0 0 BUDGET WORKSi�T DRAFT Budget @ &26-2014 Page: 22 8/26@014 VNage of Tequ� 4:51 pm Prior CurteMYear (6) (n (8) Y�r Odglnal Amended Ach�al Thru Estlrnated Mordh:9130/2014 Ach�al Budget Budget Septemf�er Totel DEPARTMENT MANAGER COUNCd Fund: 001- General FurM Fxpenditur� Other Flnandng Sources and Ua 0 0 0 0 0 0 0 0 Functlon: 590 Other Norroperating Dept 700 Debt Service Acct Ciess: 471 D/S - Prind�l 571.706 P/S Piin - BOA- P/S Bldg 247,809 258,700 258,700 238,849 258.700 289,920 289,920 571.708 P/S - Prin - S�mTrust- Piunper 0 35,930 51,600 47,785 47,785 �,810 38,810 571.710 P/S Prin - 2015 PD Vehid� 0 0 0 0 0 76,830 76,830 571.712 2015 Public Worl� Vehlcles 0 0 0 0 0 11,070 571.725 Prfi - 2012 Ford Foas - Admin 0 0 0 0 0 571726 Prin. - CTS Smert Cop Leage 0 0 0 0 0 D/5 - Prindpel 247,809 294,630 310,300 284,434 306,485 �5,56'0 396,630 0 Acct Cless: 472 D/S - Irrter�t 572.706 PIS - Irrt. BOA- P.S Bidg 124,692 113,900 113,900 104,810 113,900 102,590 102,590 572708 P/S - SimTrust - Pumper 0 16,670 1,000 350 350 9,340 9,340 572710 2015 PD Vehides 0 0 0 0 0 8z10 8,210 572712 2015 PubQc Worl� Vehides 0 0 0 0 0 2,200 572725IM.2012FordFaws-Admin 382 200 200 772 Z00 20 20 D!S - Ir�er�t 125,054 130,770 715.100 105,332 114,450 120,160 122,360 0 Debt Service 372,863 425,400 425,400 389,766 420,935 505,720 518,990 0 Dept 950 OtherNonoperatlng Acx;t Cless: 590 Other Finandng Sourc� & Uses 549.391 Bank Charg� 10,150 11,000 11,000 8,659 11,000 11,000 17,UU0 549.395 C�R Card Fe� aml Cherg�s 1,720 2,500 2,500 2,123 2,500 2,800 2,800 590.001 Alla;�e Go Fimd Balanoe 0 0 0 0 0 80,389 158,749 999.001 Suspense 0 0 0 1,000 0 999.002 Susperise - Payroll 0 0 0 0 0 999200 Suspe�e-AIP 0 0 0 0 0 Other Flnendng Sour�es & Uses 11,870 13,500 13,500 11,782 13,500 94,189 172,549 0 OlherNotroparatlng 11,870 13,500 13,500 11,782 13,500 94,189 172,549 0 Dept 990 OthedReserve/Contlngency Acct Class: 590 Other Flnendng Sources 8 Uses 599.902 R�serve.a - Cor�tlr�gency 0 0 0 0 0 Other Finandng Sources & Usea 0 0 0 0 0 0 0 0 OlhedReserv�Cor�tlngen�y 0 0 0 0 0 0 0 0 OtherNonoperatlr�g 384,733 438,900 438,900 401,548 434,435 599.909 891,539 0 Total Expendihues 9.297,823 9,873,T/8 10,308,786 8,769,491 10,345,Y14 10,205,749 10,270249 0 Gerreral Fund -55,338 0 0 612,538 -344,930 0 0 0 euocerwowcs�r DRAFT Budget Q&28-2014 page: 23 8/26/2014 Wlage of T�uesm 4:57 pm Prior CurteM Y�r (6) (n (8) Year Odginal Amended Ach�el Thru Estlmat�i Mor�th:9/30/2014 Acwal Budget Budget September Tatal DEPARTMENT MANAGER COUNCa Fur�d: 301- Capital Improvement Fund Revertua Functlon: 000 General Revenu� Dept 000 General Acct Cless: 366 Cantributlo� 8�natlor�s 368.100 Contrib $ Donatlons & S{�r�rs 0 0 0 0 0 Contributlorre & Donatlons 0 0 0 0 0 0 0 0 Aaa:t Cless: 369 Miscellan�us Revenu� 369.000 Other hllscellaneous Revenue 0 0 0 0 0 Misc:ellan�us Revenuaa 0 0 0 0 0 0 0 0 ��e� 0 0 0 0 0 0 0 0 Gerreral Revenu� 0 0 0 0 0 0 0 0 Fimctlon: 581 Other Finandng Snur�es end Us Dept 900 Interfwd Tiansfers Acct Ciass: 391 Transfers In 381.001 Transferfrom General FurM 0 0 0 0 0 381.303 Tsfer-In from CapNal Projecis 0 0 0 0 0 Transfers In 0 0 0 0 0 0 0 0 Irderlund Trar�fers 0 0 0 0 0 0 0 0 �� ���9 �� �d � 0 0 0 0 0 0 0 0 FuncNon: 590 Other Nonopeiating Dept 950 Olher Nonoper�ng Acct Class: 361 Unrestrict� ImestrneM Eamin 367.100 Inter�Ulnv�hneM Eamings 0 0 0 0 0 Unrastricted ImeshneM Eamin 0 0 0 0 0 0 0 0 Other Nonoperating 0 0 0 0 0 0 0 0 �ept 990 OlhedReseroelConUngency Acct Class: 380 Other Finandng Sources 399.999 Appropria0e Rmd Balance 0 100,000 100,000 0 100,000 Other Flnandng Sources 0 100,000 100,000 0 100,W0 0 0 0 ������9���Y 0 100,000 100,000 0 100,000 0 0 0 OtherNonoperatlng 0 100,000 100,000 0 1W,000 0 0 0 Totel Revenu� 0 100,000 100,000 0 100,000 0 0 0 F�cpendiwres Functlon: 581 Other Ffnendng Sources and Us Dept 900 InGefimd Transfera ' Acct Class: 591 Irderfund Transfers Out 581.001 Transfer tn Gerreral Fund 290,440 100,000 100,000 100,000 100,000 Inlerfund Transfers Out 290,440 100,000 100,000 100,000 100.000 0 0 0 InherfurM Transfers 290,440 100,000 100,000 100,000 100,000 0 0 0 Other Flnanctrig Sour� and Us 290.440 100,000 100,W0 100,000 100,000 0 0 0 BWGET WORKSF�ET DRAFT Budget @ &2�2014 P�e: 24 8i161�114 V�age of Tequesla 4:57 pm Prior CurreM Year (8) C� (8) Year Origtrrel Amended Achiiel Tfw Eadmat� MoMh:9l30P1014 Actual Budget Budget Septeml�r Ta�l DEPARTMENT MANAGER COUNCd FmM: 301- Capital Mprovement Fund Totel Exper�ihires 290,440 100,000 100,000 100,000 100,000 0 0 0 Capftel Improvemant FurM -290,440 0 0 -100,OW 0 0 0 0 BUDGET WORKSF�EI' DRAFT Budget (� &2&2014 Pege: 25 8fZ8l2014 Vmage of Tequeata 4:57 pm Prior CurtsM Y�r (6) (� (8) Year Orighml Amend� AcWel Thru Eetlme�ed Mmrth:913012014 Actuel Budget Budget September Totel DEPARTMENT MANAGER COUNCtl. FurM: 303 - Capital PraJects FurM Revenu�v Fimctlon: 590 Other Norroperatlng Dept 990 Olher/ReservelCantlrn�ency Acct Class: 390 Other Flnendng Sourcav 399.999 MP�Priate Fund Balance 0 50,000 50,000 0 50,000 Other Flnendng Sources 0 50,000 50,000 0 50,000 0 0 0 OthedR�ervelCordfigen�y 0 50,000 50,000 0 50,000 0 0 0 Other Norroperatfig 0 50,000 50,000 0 50,000 0 0 0 Total Revenu� 0 �,000 50,000 0 50,000 0 0 0 Expendihires Fimctlon: 450 Leisure Services Dept 3.99 Misc Prof-General Acct Class: 530 aperadng Expe�iWraslExperoe 546.311 FEC Trac�c Meintenance 78,271 0 0 0 0 Operatlng Experbf�ueslExpense 78,211 0 0 0 0 0 0 0 Misc Proj-Generel 78,211 0 0 0 0 0 0 0 Leisure Services 78,211 0 0 0 0 0 0 0 Fimctlon: 581 Other Flnandng Sources and Us Dept 900 I�erfund Transfers Acct Class: 591 IrrterfurM Transfers Out 591.001 TtansFer Oo Gerreral Fund 80.000 50.000 50�000 50.OU0 50,000 591.301 Trsf ro Cepitel Imp Fwd 0 0 0 0 0 I�erfurM Transfers Out 80,OD0 50,000 50,000 50,000 50,000 0 0 0 IMerfuml Trarisfers 8(I,000 50,000 50,000 50,000 50,000 0 0 0 Other Fnandng Sourc� end Us 8(1,000 50,000 50,000 50,000 50,000 0 0 0 Total Expenditur� 158,211 50,000 50,000 50,000 50,000 0 0 0 Capftal Projecb Fund -158,211 0 0 -50,OW 0 0 0 0 BUDGET WORK.4F�ET DRAFI' Budget @ &28-2014 Pege: 26 8l�P1014 VfOege of Tequ� 4:57 pm Pdor CurteM Y�r (6) (� (8) Y�r OrigMal Amended Achial Tfw Eattrnat� MoMh:9f3012014 Achiel Budget Budget SepOember Totel DEPARTMENT MANAGER COUNCa Fund: 401- We�r Fund Rsvenue.v Functlon: 000 General Revenues Dept 000 Generel Acct Class: 340 Cherges for Servicea 342501 Site Plan ReNew Fees 0 500 500 0 0 343.301 WeterSales 2,1�,978 2,375,OW 2.375,000 1,881,770 2,250,000 2,300,000 2,�0,000 343.302 Water-ConnectCharg� 17,895 15,000 15,000 20.Oq 19,960 17,000 77.0� 343.303 Weter-Flre HydraMS Rerrt 64,268 65,000 65,000 60,109 65,000 68.300 68.3W 343.304 WeterSurcherge 361,2T/ 380.000 �0,000 306,648 375,000 �2�500 382,5� 343.306 Mor�thlyServiceCherge 1,385,257 1,485,000 1,485,000 1z79,487 7,395.000 1,423,000 1,423,000 343.307 PermltyCherges 5,W2 4,500 4,500 4,564 4,564 4,500 4,500 343.308 OtherWeterSeMcelncome 1,541 7,500 1,500 1,403 1,500 1,500 1,5U0 343.309 ConvenlenceFee-CC 0 500 500 0 0 343.700 Water Conaenratlon 8 Resoiuce 1,514 1,000 1,OW 913 1,000 1,000 1,000 343.950 A�ow for doubful rev - Enterp 0 0 0 0 0 Cherg�forServic� 3,9fi6,832 4,328,000 4,328,000 3,584,957 4,172,024 4,195,800 4.195,800 0 Acxt Class: 369 Misce�eneo� Revenu� 3q.101 MertinlTmplc V-Corist �Non 23,145 15,900 15,900 34,298 17,127 16,000 16,000 369.000 Other Misoellen�us Revenue 0 0 7,455 7.463 7,500 369.100 Inaivance ReimbursemeM 8,361 8,000 8,000 7,8p 7,883 8,000 8,000 MLscellaneous Revenu� 31,506 23,900 31,355 49,624 32,490 24,000 24,000 0 Acct Ciess: 380 Other Flnencing Sourc� 369.110 CapHel Conned Cherge - Cusl 20,581 20,000 20,000 7,304 7,304 369.111 Capital Connect Charge - Devel 10.709 12,000 12,000 34,694 76.434 369.112 CapHel Connect - Tropic Viat 20,633 14,200 14,200 0 15,288 14,000 14,000 Otlier Flnandng Sources 51,923 46,200 48,200 41,998 39,008 14,000 14,000 0 Gerrerel 4,050,267 4,398,100 4,405,555 3,858,579 4,183,520 4,233,800 4,233,800 0 Gerrerel Revenues 4,050,261 4,398,700 4,405,555 3,656,579 4,183,520 4,233,800 4,233,800 0 Fimctlon: 590 Other Norro�rating Dept 950 Olher Nonape�atlng Acct Ciess: 361 Unrestricled Irnastrnent Eemin 361.100 IrroeresNnveshmeM Eamings 11,188 10,000 70,000 8,778 8,T/8 9,500 9,500 361.1U5 IM Incorne - Tropic Visla Aqse 0 0 0 0 7 367.100 Net Unr�l epprecletlon (Dep) 7,356 0 0 3,056 0 Unreshict�IrnestrneMEamin 18,545 10,000 10,000 11,834 8,785 9,500 9,500 0 Acxt Clasa: 369 Miscelleneous Revenu� 364.100 Dispositlon of Assets 5,510 0 0 0 0 Miscellen�us Revenu�v 5,510 0 0 0 0 0 0 0 Other Noiroperatlng 24,055 10,000 10,000 11,834 8,785 8,500 9,500 0 Dept 890 OlherlR�erve/Contfigency Ac�t Cless: 390 Other Flnancing Sourc�s BUDGET WORKSHEET DRAFT Budget @ &26-2014 Pege: 27 8126Ym14 Vlllage of Tequesta 4:57 pm Pdor CurteMY�r (6) (n (8) Year Origtnel Amended Hchiel Thru Estlme� Month:9/3012014 Actual Budget Budget Seplember Tolel DEPARTMENT MANAGER COUNCIL Fund: 401- Water Fund Revenu� Fim�on: 590 Other Nonopetadng Dept 990 OlhedR�erve/Cordfigency Acct Class: 390 Other Finencing �urc� �9.998 Appropriam Fund Balance 0 0 837,621 0 0 �7,530 702,330 Other Flnendng Sources 0 0 837,821 0 0 �7,530 702,330 0 OthedReserve/Contlngency 0 0 837,821 0 0 687,530 702,330 0 Other Norroperatlng 24,055 10,000 847,821 11,834 8,785 fi97,030 711,830 0 Total Revsmies 4,074,318 4,408,100 5,253,176 3,66'8,413 4,192,305 4,93b,830 4,945,q0 0 Expenditures Fimdion: 533 Water Ut01ly Servlces Dept 241 Water-Administratlon Ac� Gass: 510 Personal Servic�s 512100 Ra�uler Saleries � Wagas 139,413 139,700 139,700 119,648 139,415 182,300 162,300 575.703 Bonus Pay Pien 0 0 3,150 3,150 3,150 515.108 Aulo Allowence 3,000 3,000 3,000 2,750 3,000 3,000 3,000 515.125 OlherAllowances 1,200 1,2(!0 1,200 1,700 1,200 1,ZU0 1,2U0 516.700 Comper��ed A6sen� 1,753 5,000 5,818 4,613 8,800 13,500 13,500 516.10.5 Compen�0ed A�nc� - HSA 3,430 0 0 0 0 521.101 FlCA Tax� 7,093 7,300 7,4� 6,608 7,200 8,700 8,700 521.102 M�I�reTaxes 2,273 2,200 2,359 1,941 2,300 2,600 2,600 522.702 VOT Pension CoMribWons 13,076 72,900 12,900 10,884 72,800 13,700 13,700 523.101 LffelHeaflh Insmance 10,316 12,600 12,600 11,868 13,027 12,200 13,300 523.1Q5 HSA-Health�vir�gsAccount 1,40D 0 0 0 0 524.100 Workers'Compinsurance 411 310 310 308 309 270 270 526.104 ICMA-Def Comp Plen 9,�6 9,900 9,900 8,433 9,830 10,300 10,300 554.301 Personrrel Treining 0 0 750 750 750 Per�nel Servi� 193,191 194,110 199,125 172,155 201,781 227,770 228,870 0 Acct Class: 530 Operatfi9 E�emlfhue�ExPer�se 531.301 Legel Servi� 1,235 7,500 6,250 1,892 2,500 2,000 2,000 531.302 Engineertng Servic�s 18,478 25,000 101,500 68,116 106,386 140,000 140,000 532.300 Acxountlng 8 AudfUr�g Services 27,800 �,100 27,750 27,750 27,750 28,620 28,620 534.300 OtherContradualServices 21,850 24,000 24,500 20,160 29,000 21,000 21.000 544.304 FEC L�se 12,357 13,050 12,535 12,531 12,535 13,000 13,W0 545.3001nsurance 46,770 47,600 47,800 48,986 48,986 47,800 47,600 549.301 Admin Mgmt Fees 485,229 499,785 499,785 416,488 499,785 514,780 514,780 549.304 Licenaes, F� & Pertnifs 781 800 800 781 781 800 800 Operatlng Expendfhir�lExpe�e 615,500 845,835 720,720 596,504 727,703 7W,800 767,800 0 Acct Cless: 580 Other Ffnandng Sources $ Uaes 599.100 Budget Cost Savings 0 3,400 0 0 0 BUDGET WORKSF�ET ' DRAFf Budget Qa &26-2014 Page: 28 8126@014 Vmege aF T�u�ta 4:57 pm Prior CurteM Y�r (6) (n (8) Yeer Orig6ial Amend� Achial Thru E�rre�d Montl�:9l30/2014 Ach�al Budget Budget Sepffimber Tatal DEPARTMENT MANAGER COUNCIL FurM: 401- Weter Furb E�nditlires Fwcdon: 533 Weter UdOry Servic� Dept 241 Weter-Adminfstratlon Other Flnandng Sourt�s & Us� 0 3,400 0 0 0 0 0 0 Wa6er-Administratlon 808,&91 843,345 919,845 768,659 929,484 995,570 996,670 0 Dept 242 Weffir- Produdfon Acxt Cleas: 510 Per�nal Servic�s 512100 Regular Salaries & Wages 370,269 397,000 387,OW 330,828 385,700 484,100 484,100 514.100 Overtlme 8,154 8,000 9,000 5,642 9,�0 9,000 8,000 515.102 Stendby Pey 5,119 8,000 6,000 4,250 6,000 6,OW 6,000 515.103 Bonus Pay Plan 0 0 3,000 3,000 3,000 515.106 ClothUig & Boot Allowance 600 600 600 600 600 800 800 516.100 Compen�tedAbsences 1,�8 5,000 5,000 2,622 5,000 5,000 5,000 516.1Q5 CompensetedA�en�-HSA 0 0 0 0 0 521.101 FICA Tazes 23,487 25,400 25.400 20,397 25,400 30,100 30.500 521.102 MedicareTexe.a 5,493 6,000 6,OD0 4,770 B.WO 7.100 7200 522.101 FRS ConMbutlons 3,850 3,900 5,000 4,145 5,000 5209 5,200 522.102 VOT Pe�lon Contributlo� 27,918 29,800 29,800 24,621 �,715 34,400 34,400 523.101 LifelHealth Insurance 51,743 63,200 78,500 71,762 78,500 91,200 99,000 523.10.5 HSA - Health Savings Acxoimt 7,700 0 0 0 , 0 523.170 Retlree Health Cere Expense 0 0 0 0 0 524.100 Workers' Comp Insurance 17a70 12,870 12,870 12,866 12,866 10,900 10,900 554.301 Personnel Tralning 385 1,500 1,500 1,314 1,500 2,000 2,000 Per�nel Servic�s 511,386 559,270 569,670 486,817 567,287 685,8W 694,100 0 Acct Class: 530 Operatlng Expendih�reslExpense 531.342 WaterMalysis & Sampling 33,422 48,530 43,530 28,632 4D,000 44,000 44,000 540.300 Trevel & Per Diem 264 3,000 3,000 2,911 2,�9 3,500 3,500 541.300 Communlcatlon Services 9,311 9,400 9,400 8,821 9,400 8,400 9,400 541.301 Postege 836 1,500 2,500 1,157 2,500 2,000 2,000 543.300 Utllity Servic� 325,275 354,000 343,930 271,413 340,�0 357,000 357,000 544.301 Operetlng Leas� 10,240 9,400 10,800 8,880 10,600 10,000 10,000 546.302 Vehicle Re�ir 8 Mehdenance 4,295 3,000 5,000 4,776 4,035 4,000 4,Q00 546.303 BuildNg Repair8 Mehit 14,582 �,500 28,500 17,187 25,W0 20,000 20,000 546.309 Lendscape & Irtigatlon Matrd 4,632 3,000 19,000 17,503 18,000 6,000 6,000 546.310 EquipmeM Re�tr & Matrrt 14,054 �,000 73,490 22,854 73,490 20,000 20,000 546.320 Compuoer sysmm maint & suppli 2,888 8,400 8,400 2,969 8,400 71,000 9,200 546.342 WeterSyrs�emMatritermnce 771,718 70,009 90,965 61,3� 70,U00 7D,000 70,000 546.343 Well Redevelopmsnt 29,785 30,000 49,0� 28,710 49,000 BO,OQO 80,000 547.300 Pdntlng & Bindir�g 7,891 2,500 4,500 4,290 4.500 3,000 3,000 549.300 Other Misc Chgs & Obligatlons 5,858 2,000 2,Q00 1,7Tf 2,OU0 2,000 2,000 BUDGET WORI(SHEET DRAFT Budget (� &2G2014 Pege: 29 ' �28/2014 1Mage of Tequeala 4:51 pm Prlor CurteM Y�r (6) (� (8) Year OdgMal Amend� AcWel Thru EetlmeOed MoMh:9l30I2014 Achiel Budget Budget Septemk�r Total DEPARTMIIENT MANAGER COUNCa Fund: 401- WaOer Fund Expendihires F�mctlon: 5�i WaOer UUQty Servlcea Dept 242 Weter- Productlon /uxt Cless: 530 OPeratln9 F�emlf4u�E�CPer�e 549.304 Liceru�, Fe� & Pertnits 22�534 30,000 30�000 72,846 30.000 30.000 30.DW 551.300 Offlce Suppli�s 8 Equipmer� 3,153 2,500 2,500 1,921 2,000 2,500 2,500 552301 Gas 8 OQ 5,550 8,100 8,100 3,304 5,000 5,000 5,000 552302 Small Tools arM Equipmetrt 1,615 3,000 3,000 1,223 2,500 3,000 3,000 552.303 DI�I Fuel 7,430 15,000 15,000 6,958 4,000 15,000 15,000 552305 Uniforms 1,494 1,500 2.500 2,123 2.500 2,500 2,500 552341 Wafer Pu�h� 0 30,000 30,000 0 0 30,000 30,000 552342 WeterChemicals 133,731 1�,000 176.100 121,611 160,OW 168.000 768,000 �2� ��ry �pp0� 15,891 14,OQ0 19,000 16,52f1 19,000 14,000 14,000 554.300 Books, Publ, Subs 8 Mem6ersfdp 1,552 1,600 1,600 878 1,500 1,800 1,6W aPeratln9 Expendfhu�sfEx�r�se 762,001 934,930 981,815 660,882 886,314 913,500 911,700 0 Aa;t Cless: 590 Olher Flnendng Sourc�v 8 Uses 599.100 Budget Cost Savings 0 3,230 0 0 0 Other Flnandng Sourca9 & Uses 0 3,230 0 0 0 0 0 0 Water- Praductlon 1,273,�7 1,497,430 1,551,485 1.147,679 1,453,595 1,599,300 1.605,800 0 Dept 243 Water-Distributlon Aa3 Cless: 510 Personal SeMces 5721U0 R�uler Selaiiie.v & Wag� 3�,002 387,800 388,000 332,849 3�.000 386.500 �6,5U0 514.100 Overthne 3,769 5,000 5,000 3,100 5,000 5,000 5,000 515.102 Stanc@y Pay 9,212 8,500 8.850 9,1Q3 9,850 10,000 10,000 515.703 Bonus Pey Plan 0 0 3,000 3,Q00 3,U00 515.1 U6 Clolhing 8 Boot Allowance 6pp Spp 5pp Spp Spp 5p0 Spp 515.1 W Pert-time Salaries 41,117 0 0 0 0 515.108 AuUo Allowance 2,400 0 0 0 0 518.100 Compenset� Af�vences 19,412 5,000 5,000 2,094 5,000 5,000 5,000 516.1Q5 Campensat� Absenc�s - HSA 0 0 0 0 0 521.101 FICA Tax� 26,751 24,300 24,300 20,457 24,300 24,500 24,800 521.102 M�icere Tex� 6,256 5,700 5,700 4,784 5,700 5,800 5,800 522.107 FRS ConMbutlons 7,889 8,200 10,000 8,542 10,000 10,700 10,700 522102 VOT Perelon CoMribudor�s 21,950 23,100 23,100 19,732 23,005 20,700 20,700 523.101 LifeMeeNh Insurance 72,987 94,100 94,950 85,727 93,873 60,300 66,300 523.105 HSA - H�Rh Savings Account 2,700 0 0 0 0 � 523.110 Retlr� Health Cere Fxpen� 0 0 0 0 • 0 524.100 Workers' Comp Insurance 10,917 8,080 9,090 9,087 9,087 7,980 7,980 525.100 UnemploymeM Compensatlon 0 0 0 0 0 554.301 Per�nnel Tralning 125 1,500 860 796 710 ' 1,500 1,500 BUDGET WORKSF�ET DRAFT Budget (a� &Z&2014 pege: 3p 8126/2014 VmegeofTeques� 4:57 pm Pdor Curterrt Year (6) (n (8) Year Orighial AmeiMed Achiel Tfw Esdmated Mmrth:9/30/2014 Ach�al Budget Budget September Total DEPARTMENT MANAGER COUNCd FurM: 401- Weter FurM Expendihir� Fimctlon: 533 Wa6er UtOity Servi� Dept 243 WaOer-DlstrmWon Personal Services 594,081 572,790 579,350 499.T71 578,125 538.4� 544.760 0 Axt Cleas: 530 Ope�9 Expenditur�lExDense 540.300 Travel& PerDiem 752 Spp Spp gZ Spp Spp 50p 541.300 Commwlt�tlon Servi� 8,000 7,700 6,000 4,856 6,000 6,000 8,000 541.301 Pos�ge 22,797 73,000 23,000 10.910 23,000 23.000 23.000 544.301 Operatlng Leases 2,788 4,500 3,200 2,778 3,121 3z00 3,200 546.301 Oftice EquiplRe�ir 8 MaNt 879 1,200 1,02f1 254 9I10 1,200 1,200 548.302 Vehide Repetr 8 Mehdenence 5,210 7,000 7,000 6,820 7,000 8,500 8,500 546.303 Build6ig Repair 8 MeiM 2,435 5,000 5,000 985 5,000 5,000 5,000 548.309 Lendscepe 8lrtigetlon Meint 239 900 900 859 900 900 900 546.310 EqWpmeM Re�tr 8 MaiM 5,416 5,000 5,000 3,434 5,000 5,D00 5,000 546.320 ComputersysGemmehit&suppll 7,588 6,900 6,9W 5,383 6,900 10,200 8,400 546.342 WaOer Syatem Meintsnance 18.302 25,000 24,850 19.884 24,850 35,000 35,000 547.300 Pdntlng 8� Binmr�g 2,642 3,000 3,OW 2,439 3,000 3.000 3,000 549.300 Other Mlsc Chgs 8 Ob�getlons 4,356 2,500 2,500 1,140 2,500 2,500 2,500 549.304 Licerrees, Fees 8 Pertnits 1,607 1,700 1,700 1,427 1,700 7,700 1,700 551.300 Offlce Supplle.a 8 EquipmeM 1,500 1,500 1,500 7,470 1,500 7,500 1,500 552301 Gas & Oil 14,315 14,000 14,000 10,638 14,000 14,000 74,000 552302 Small Tools and EqulpmeM 1,094 4,000 4,000 3,346 4,000 4,000 4,000 552305 Uniforma 1.453 2�000 2�000 1,864 2�000 2�000 2,000 Operatlng F�Q�erbfhir�vlF�cper�se 89,573 115,400 112,070 78,689 111,871 127�U0 125,400 0 Acct Class: 590 Other Finentlng Sourc� 8 Uses 599.700 Budget Ca9t Sevinga 0 3,230 0 0 0 Other Flnendng Sources 8 Use.a 0 3,xi0 0 0 0 0 0 0 Weter-0istrmudon 683,fi54 691,420 691,420 578.460 688,996 885.680 670,1� 0 Dept 411 Rerrewal 8 ReplacemeM Acct Cleas: 530 OPe�atln9 Expenditiu�lExPe�e 548.6Q5 R8M - We0 Site Reheb 2,550 4,000 4,000 1,780 2,500 4,000 4,000 548.871 Misc. Renewel 8 ReplecemeM 116,077 60,000 787,951 317,598 787,000 310,W0 310,000 552801 MeOe�s, Velves & Hydrertls 30,289 30,000 37,455 38,570 37,455 60,000 60,000 552603 Fltter Certiidg�IROP 3.030 7,000 7,000 4,213 5,OW 7,000 7,000 �P��9 ���� 151,�8 701,000 838,406 360,172 831,955 381,000 381.000 0 Acct Class: 600 Cepitel Oudey 66;i.671 Misc. Renewel and ReplecemeM 0 0 0 0 0 664.800 MachlEqulpmeM 0 0 0 0 0 25,000 25,000 �4.801 Computer Equlpment 0 1,500 1,500 0 1,500 664.fi02 Vehicles 0 33,500 36,500 36,496 36,500 136,000 136,000 eu�erwoaus�r DRAFT Budget @ &2G2014 Page: 31 8126I2014 VNage of Tequ�la 4:57 pm Pdor CurtentY�r (6) (n (8) Y�r Original AmerM� Ach�al Thru Estlmafed Mordh:9/30PL014 Achiel Budget Budget September Total DEPARTMENT MANAGER COUNCIL Fund: 401 - Water Fund ExpendfWres Functlon: 533 Water Ut�ity Servic�s Dept 411 Renewal8 Replacem�rt Capilal0utley 0 35,000 38,000 36,496 38,000 161,000 161,000 0 Renewal 8 ReplacemeM 151,888 136,000 874,406 396,b'68 869,955 542,000 54z000 0 Dept 412 Cepitel ImpravemeM Acct Cless: B0� CepHal Outlay 664.600 MechlEquipmem 0 68,000 57,000 2,330 52,510 Capltal0utley 0 68,000 57,000 2,330 52,510 0 0 0 Cepitellmprovemertt 0 �,000 57,000 2,330 52,510 0 0 0 WeGerUWtyServices 2,927,618 3,236,185 4,094,156 2,893,786 3,995,540 3,802,530 3,814,q0 0 Functlon: 581 Other Flnancmg Sourca� and Us Dept 910 Other FNandr�g Sources 8 Us� Aat Class: 590 Other Finandng Sourc� & Us� 567.000 GeINLoss on Imeshnerds 0 0 0 0 0 567.100 Unrealiz� Loss on Inveshnsnts 0 0 0 0 0 Other Flnancmg Saurces & Usas 0 0 0 0 0 0 0 0 Other Flnandng Sources 8 Uses 0 0 0 0 0 0 0 0 Other Flnandng Sourcas and Us 0 0 0 0 0 0 0 0 Functlon: 590 Other Norroperatfig Dept 7U0 Debt Service Acct Class: 471 D/S - Prmd�l 57170.5 Pdn - 2004 Water IWP BOA 0 30,000 30,000 30,000 30,000 32,0�0 32,000 571.7Z0 Pdn - 2008 Water Utllily Note 0 277,900 277,900 254,384 277,900 287,890 287,890 D/S - Prfidpal 0 3W,900 307,900 284,384 307,900 319,890 319,890 0 Acct Clesa: 472 D/S - In6erest 5727051nt-2004WaterWPBOA 14,887 14,100 14,100 8,208 14,100 12,600 12,600 572720 IM-2008 Weter Utllity No6e 201,533 192,200 192,200 160,062 192,200 791,310 191,310 573.700 Other DeM Service Cosis 46,676 25,000 25,000 0 23,OD0 23,000 23,000 D/S-Iriterest 263,086 231,300 231,300 168,270 229,300 226,870 226,910 0 Debt Service 263,088 539,200 539,200 452,&54 537,200 546,800 546,800 0 Dept 950 Other Nono�ratfig Acct Cless: 530 OPe�a►in9 Ex�rnlihu�lExpense 559.300 Depredetlon 1,000,083 0 0 0 0 558.301 Budgeted Depredetlon (nett�) 0 BQ5,320 605,320 0 605,320 565,000 565,000 Operatlng ExpenditiueslExpe�e 1,000,083 605,320 805,320 0 6Q5,320 5&5,000 565,000 0 Aat Ciess: 590 Other Finandng Sour� 8 U� 549.391 BankCharges 10,038 10,000 10,W0 8,519 10,000 10,OOD 10,000 549.395 Cr�(t Card F� and Charg� 4,118 4,500 4,500 5,769 6,000 6,500 6,500 590.001 Morate ta Fimd Balance 0 12,885 0 0 0 999.001 Suspense 0 0 0 0 0 999200 Susperise - AIP 0 0 0 0 0 BUDGET WORKSHEETT DRAFT Budget @ &267A14 Pege: 32 8128/2014 Wl�e of Tequ� 4:57 pm Prior CurteMY�r (6) (n (8) Yeer Origtrrel Amended Achiiel Thru EsWneted Morrth:9130/2014 Achiel 8udget Budget Septeml�r Tofal DEPARTMENT MANAGER COUNCd Fu�: 401 - Water FurM ExpendiWres Fimc�on: 590 Ofher Norwperatlng Dept 850 Olher Nono{�ratlng Other Flnandng Sourcas 8 Uses 14,156 27,385 14,500 74Z88 16,000 16,500 18.500 0 OtherNorroperadng 1,014,238 632,70.5 619,820 74�88 621,320 581,500 581,500 0 Dept 990 OfhedReservelContlngency Axt Cless: 590 Olher Finandng Sou� fl Us� 599.902 Reserv�-Cor�dngen�y 0 0 0 0 0 2,700 Other Finam�ng Source,v 8 Usas 0 0 0 0 0 0 2,7Q0 0 OtherlReservelCorrtfigenc.y 0 0 0 0 0 0 2,700 0 OtherNonoperedng 1,277.335 1,171,9Q5 1,159.020 466,942 1,158,520 1,128,300 1.131,000 0 Totel Expendf�res 4,204,9rn3 4,408,100 5,253,176 3,360,738 5,154,060 4,930,830 4,945,830 0 Water Fwd -130,637 0 0 307,675 -961,755 0 0 0 suucEr aro�cs�r DRAFT Budget @ &262014 Page: 33 8126@074 Vmege af Tequ� 4:57 pm Piior CurreM Y�r (6) (� (8) Year Originel Amended Achiel Thru Esl6neted Mo�rth:9l3012014 Ach�al Budget Budget Sephsmber Tatel DEPARTMENT MANAGER COUNCIL FurM: 402 - Refuae 8 R�.Y��9 Revenu� Fwctlon: 000 Gerreral Revenue,v Dept WO Gen�al Acxt Class: 335 IrdergovemmeMal Revenue 338.110 Rec.ycMg Sh�ed Rev - SWA 8,680 7,300 7,300 5,733 5,OW 5,000 5,000 I�govemmemal Reverme 8,690 7,300 7,300 5,733 5,000 5,000 5,000 0 Axt Class: 340 Cherges for Servi� 343.307 Per�aliyCherg� 7 0 0 1 0 343.400 Reh�se / R�rding Fe� 473,731 472,680 472,880 469,924 472,245 472,245 472,245 Cha�g� for Servic� 473,732 472.680 472,680 469,925 472,245 472,245 472,245 0 Acd Class: 3� M4sceDan�us Revenues 369.000 Other AN�Oan�us Revenue 0 0 0 0 0 Miscelleneous Revenues 0 0 0 0 0 0 0 0 Acct Cless: 390 Otl�er Flnancing Sources 399.999 Appmpdete Fund Balence 0 9,855 9,855 0 0 22,175 22,175 Other Finendng Sou�s 0 9,&55 9,855 0 0 7'1,775 Y1,175 0 General 482,422 489,835 489,835 475,858 471,245 499,42(1 499,42t1 0 General Revenu� 482,472 489,835 488,835 475,&58 4T/,245 499,420 499,420 0 Fwctlon: 590 Olher Noiroperating Dept 950 Olher Nonoperedng Axt�Class: 361 Unrestric6ed Irneshnent Eamin 361.100 InOer�tllnves4neM Eamings 770 200 200 142 175 175 175 381.101 PBC Tax Col-In�er�t on Dep 71 100 100 70 10 367.100 Net Unr�l appredetlon (Dep) 424 300 300 207 200 200 200 Unrestricted Irnatrnerrt Eemin 665 600 800 353 385 375 375 0 OtherNoiroperetlng 665 600 800 353 385 375 375 0 OtherNorroperetlng 665 600 600 353 385 375 375 0 Tatel Revenu� 483,087 490,435 490,435 476,011 477,630 499,795 499,785 0 ExpenmWres Fwcdon: 533 Water Utllfty Services Dept 241 Water-Admin49tretlon Acct Ciess: 510 Personel Services 515.103 Bonus Pey Plen 0 0 0 0 0 PeBOnel Services 0 0 0 0 0 0 0 0 Weter-Admin49traUon 0 0 0 0 0 0 0 0 Dept 242 Weter- Productlon Axt Class: 510 Personel Seroices 515.103 Bonus Pey Plan 0 0 0 0 0 Personal Servic�a 0 0 0 0 0 0 0 0 Weter- Produc8on 0 0 0 0 0 0 0 0 Dept 243 Weter-DlstribuUon Hax Ciess: 510 Personal Services BUDGET WORKSFIEE� DRAFT Budget @ &2&2014 Pege: 34 8126@014 Vmege oF T�N� 4:57 pm Pdor Cur�eM Y�r (6) (� (8) Year Origirml Amended Actual Thru EsUrnet� Mmrth:9130/2014 Aclual Budget Budget SepOemb� Tofel DEPARTMENT MANAGER COUNCIL Furb: 402 - ReFuse & Recydir�g Expendihir� Fimctlon: 533 W�er Ut�ity Services Dept 243 Weter-Dlatributlon Aa� Class: 510 Per�nel Services 575.70;i Bonus Pay Plen 0 0 0 0 0 Personal Servic� 0 0 0 0 0 0 0 0 Weter-DlstrmuUon 0 0 0 0 0 0 0 0 WeOer UtlIf1Y SeM� 0 0 0 0 0 0 0 0 Fwctlon: 534 Refuse 8 ReaY��9 Dept 245 Refuse end Rec,ycJtrig Aat Ciess: 530 OP��9 ���� 531•301 Legel Servi� 0 0 0 0 0 543.302 Solid WestelResidentlel 248,735 251,905 251,905 209,782 251,747 257,810 257,810 543.303 Re�y�ng/ResideMial 87,902 89.090 89,090 74.191 89,033 91,310 91,310 543.304 Yerd WestelR�ldentlal 82,528 83,715 83.715 69,714 83,660 85,555 85,555 543.306 Fuel Fector 57,961 58,370 58,370 48,6W 58.332 57,550 57,550 549.300 Other Misc Chgs 8 Ob�getlons 789 300 300 190 300 300 300 549.301 Admin Mgmt Fee,a 6,850 7,Q55 7,055 5,878 7,055 7,270 7,270 �P8�9 ��d���� 484,165 490,435 490,435 408,364 490,127 499,795 498,785 0 Refuse end Re�yding 484,185 490,435 490,435 408,364 490,127 499,795 499,795 0 Refuse & Rd.yding 484.165 490.435 490,435 408,364 490,127 499,785 499,795 0 Functlon: 581 Other Finandng Sourc� and Us Dept 910 Ofher Ffnendng Sourc�s & Uses Acd Class: 590 ather Flnandng Sources 8 Us� 567.000 GeWLoss on Imeshnenb 0 0 0 0 0 567.100 Unrealb.ed Loss on Inveshnerds 0 0 0 0 0 Other Flnandng Sourc� 8 Usa9 0 0 0 0 0 0 0 0 Other Flnendng Sources & Uses 0 0 0 0 0 0 0 0 Olher Finandng Sources and Ua 0 0 0 0 0 0 0 0 Functlon: 590 Olher Nonoperadrn,� Dept 950 OlherNonoperatlng Ncct Ciass: 590 Other Ffnendng Sourc� 8 Uses 590.001 ADocaGe to Fund Belence 0 0 0 0 0 Other Flnandng Sources & Usa9 0 0 0 0 0 0 0 0 Other Norroperating 0 0 0 0 0 0 0 0 Olher Norroperatlr�g 0 0 0 0 0 0 0 0 Total Expendihirea 484,185 490,435 490.435 408,364 4A0,127 499,795 499.795 0 Refuse & Recyding -1,W8 0 0 87,847 -12,497 0 0 0 BUDGET WORKSF�ET DRAFT Budget @ �26-2014 Pege: 35 �28/2014 VlDage of Tequ� 4:57 pm Prior CurteMYear (6) (� (8) Year Original Amend� AcWel Ttw EstlmaOed Mordh:9/30l2014 Ach�al Budget Budget SepOem�r Total DEPARTMENT MANAGER COUNCa Fund: 403 - Stortmvater UBlity Revenu� Functlon: OUO General Revenues Dept WO General Acct Ciess: 340 Charg� for Servlc� 343.901 Storm Weter Utiity Fee.s 323,513 318,000 318,000 321,388 321,388 318,000 318,000 Cherg�for3ervic�s 323,513 318,000 318,000 321,388 321,388 318,000 318,000 0 Acct Cless: 369 Miscellan�us Revenu� 389.W0 OtlrerMiscellaneousRevenue 0 0 0 0 0 Miscelleneoua Revenu�s 0 0 0 0 0 0 0 0 Genera� 323,513 318,000 318,000 321,388 321,388 318,000 318,000 0 General Revenues 323,513 318,000 318,000 321,388 321,388 318,OU0 318,000 D Fwctlon: 590 Other Noiroperadng Dept 950 OlherNonoperating Acct Ciass: 361 UnrasMcted Inve.gtrnerrt Eamin 361.tOD In6eresfllnv�lmeMEammgs 1,027 1,100 1,100 854 767 1,100 1,700 361.101 PBC Tax CoNrtGer�t an Dep 46 Sp 5p 7 0 367.100 Net Urueal eppredatlon (�p) 444 0 0 229 0 Unre.stricGedlrnestmeMEemin 1,517 1,150 7,750 1,090 767 1,100 1,tU0 0 OlherN�opera�g 1,577 1,150 7,750 1,090 767 1,100 1,100 0 Dept 990 OthedReserve/C�dngenc.y Acct Class: 390 Other Rnan�g Sour� 399.999 Appropria0e Fimd Balance 0 0 0 0 0 145,OW 146,170 Other Fnendng Sources 0 0 0 0 0 145,0� 746,110 0 OthedReserve/Car�tingenc.y 0 0 0 0 0 145,060 146,110 0 OtherNorroperatlng 1,517 1,150 1,150 1,090 767 146,760 147,270 0 Totel Revenu� 325,030 319,150 319,150 322,478 322,155 464,160 465,210 0 Fxpenclihrres Functlon: 533 Water Utll(ty Services Dept 241 Weter-Administratlon Acct Class: 510 Personal Services 515.103 Bonus Pay Plan 0 0 0 0 0 Per�nel SeM� 0 0 0 0 0 0 0 0 Weter-Adminlatratlon 0 0 0 0 0 0 0 0 Dspt 243 Water-DlsMbutlon Acct Class: 510 Personal Servic� 515.103 Bonus Pay Plen 0 0 0 0 0 Personal Serv(c� 0 0 0 0 0 0 0 0 Weter-Distribudon 0 0 0 0 0 0 0 0 WaGer UtlOty Servic�s 0 0 0 0 0 0 0 0 Functlon: 550 Stormvrater Dept 250 Storm Wffier Utilities Acet Cless: 510 Personal Servica9 BU�ET WORKSHEET DRAFT Budget@ &26-2014 paga 3g 8/26@014 VfOege af T�uaste 4:57 pm Pdor Curterrt Y�r (6) (n (8) Year Odghrel Amended AcNel Tfw EattrnaUed Mordh:8/30Y1074 Actual Budget Budget September 7olal DEPARTMENT MANAGER COUNCd Fu�: 403 - Stormweter Utl6ty Fxpenclihires Functlon: 550 Stormweter Dept 250 Storm WaOer Utllitles Axd Class: 510 Personel Services 5127� RegularSelerles 8 Weg� 43.918 80,500 60,500 51,190 58,862 58,200 59200 514.100 Overtlme 509 1,000 1,000 412 1,000 1.W0 1,000 515.102 Stm�dby PaY 1,689 1,400 2,300 1.423 2,300 2,000 2,000 515.103 BomisPeyPlan 0 0 1,500 1,500 1,500 515.706 Clothtrig&BootMrnuar�ce 1U0 150 150 150 150 150 150 515.108 Auto Allowence 750 900 1,800 1,fi50 7,800 450 450 516.100 Compar�hed Absences 5� 0 0 0 0 516.1 Q5 Compenseted A�ences - HSA 0 0 0 0 0 527.107 FlCATmtea 2,407 3,500 3,728 3,162 3,700 3,800 3,800 521.102 M�icare Taxes 5q 900 818 740 919 900 900 522.102 VOT Per�slon ConMbutlor�s 4,120 5,600 5,800 4,540 5,300 5,000 5,000 523.101 LffelHealtli Insurance 16,720 24,400 20,128 16,272 77,398 10.800 12,000 523.105 HSA - H�Ifh Savir�gs A�uM 850 0 0 0 0 524.100 Worke�s' Camp Insivance 1,094 2,800 2,800 2,798 2,799 1,860 7,860 554.301 Persomrel TraMim� 0 0 0 0 0 Pe�nal Services 73,280 701,150 100.425 83,838 96,828 85,160 86,360 0 Aa�t Class: 530 OPeratln9 F�erM�u�Expe�e 531.302 Engineering Servicag 6,042 8,000 14,835 14,835 74,835 36,500 36,500 532300 Accour�tlng 8 Auditlr�g Servic� 3,882 4,000 4,000 3,885 3,�5 4,010 4,010 534.300 Other Contrectual Servlc� 0 0 0 1,540 1,540 540.300 Travel 8 Per Dlem 0 0 0 0 0 541.300 Communlcetlon Services 1,�0 1,900 1,900 1,485 1,800 7,900 1,900 541.301 PosTage 0 300 300 0 300 300 300 546.302 Vehlcle Re�ir 8 Matrrtenance 701 500 1.500 1,234 7,500 2,000 2,000 546.303 Buildhig Repelr & Mahrt 1,808 2,Q00 7,000 799 7,000 2,000 2,000 548.308 D�ainege Malyder�ance 12,294 25,000 20,710 14,801 20,710 285,000 �5,000 546.310 Equipmerrt Re�ir 8 Mairrt 7,356 1,SU0 1,500 1,446 1,500 2,50D 2,500 546.320 Computer sys0em meiM 8 suppli 293 800 800 309 800 1,200 750 549.300 Other Misc Chgs & Obligetlons 745 1,000 1,000 503 1,000 1,000 1,000 549.301 Adrttln Mgmt Fees 71,830 11,920 12,020 9,982 11,878 12,340 12,340 549.304 Llcens�s, F� 8 Permib 4,109 4,500 4,500 4,099 4,1Q0 4,50D 4,500 551.300 Offlce Suppli� & Equipment 717 300 300 300 300 300 300 552301 Gas & 00 2,331 3,000 2,700 1,509 2,�00 2,700 2,700 552.302 Smell Tools erb Equipment 1,822 1,200 1Z00 823 1,200 7,500 7,500 554.100 Public Educetlon Progiam 0 500 500 0 500 250 250 �P8��9 ������ 48,218 68,420 68,765 58.9� �,948 384.000 36;i,550 0 swcEr wowcs�r DRAFT Budget @ &2fr2p14 Page: 37 BY16@014 VNaga of Tequesle 4:57 pm �+o� c��Mr�r es) m (e) Y�r Orighrel Amended Achrral Thru Estlma�ed Mmrth:9130/2014 Aclual Budget Budget September Tofal DEPARTMENT MANAGER COUNC� FurM: 403 - S6ortnx�ater UtlOty Expen�tur� F�mctlon: 550 S6orrtnvater Dept 250 Starm WaGer Utllitl� Acct Cleas: 590 Other Flnandng Sources & Uses 599.100 Budget Co� Savings 0 1,620 0 0 0 Other Flnandng Sour�es & Us� 0 1,620 0 0 0 0 0 0 Acct Cless: 600 Cepflal Outlay 662632 Architect & Engeering 0 0 0 0 0 663.663 Dralnage Unprovemerds 0 0 0 0 0 664.600 MechlEquipmsM 0 0 0 0 0 15,U00 15,000 664.602 Vehides 0 30,000 30,OOD 21,797 30,000 Capital0utley 0 30,000 30,000 21,797 30,000 15,000 15,000 0 Storm Water UtIDtl� 121,498 199,180 199,190 162,595 195,776 4fi4,160 464,910 0 Starmxiater 121,498 199,190 199,190 162,595 195,776 464,160 464,910 0 Fimcdon: 587 Ofher Ffnandng Sources and Us Dept 910 Olher Finandr�g Sourc�s & Usa9 Acct Ciass: 590 Other Flnendng Sourc� & Uses 567.100 Unreal¢ed Loss on Inveshnsrds 0 0 0 0 0 Other Ffnendng Saurc� 8 Us� 0 0 0 0 0 0 0 0 Other Financmg Sourc� 8 Uses 0 0 0 0 0 0 0 0 Ofher Finandng Sources end Us 0 0 0 0 0 0 0 0 Fwctlon: 590 Olher Norroperatlng Dept 950 OtherNarropeiatlng Acd Ciass: 530 O�atlng FxpendihueslExpense 559.300 Depr�ietlon 99,785 0 0 0 0 559.301 Budget� Deprec�tion (netD�) 0 70,250 70,250 0 0 Operatlng ExpsndihuavlExpense 99,785 70,250 70,250 0 0 0 0 0 Acct Class: 590 Other Flnandng Sour�es 8 Uses 590.001 Allocate to Fund Belence 0 49,710 49,710 0 0 Other Flnandng Sources & Usav 0 49,710 49,710 0 0 0 0 0 Other Norrope�aUng 99,785 119,960 119,860 0 0 0 0 0 Dept 990 OlhedRavervelContlngency Atxt Cless: 590 Otlter Flnandng Sourcea & Uses 598.802 Re�rr� - Cor�r�gency 0 0 0 0 0 300 Other Finendng Sour�es & Us�a 0 0 0 D 0 0 300 0 Other/R�ervelContlngency 0 0 0 0 0 0 300 0 Other Norroperatlng 98,7&5 119,960 119,960 0 0 0 300 0 Total Ex�ndiWres 221,283 319,150 319,150 162,595 195,T76 464,160 465,210 0 Storrtnvater Utllity 103,747 0 0 159,883 126,379 0 0 0 BUDGET WORKSHEETT DRAFT Budget (a� &2G2014 Pege: 38 8f28l2014 Village of Tequ� 4:57 pm Prior CurteM Y�r (6) (n (8) Year OrigNel Artrend� Ach�al Tfw Estlrrmeed Month:9130/2074 Hchiel Budget Budget Septem6� Total DEPARTMENT MFWAGER COUNCd Grand ToTel: -531,957 0 0 997,741 -1,192,803 0 0 0