Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Documentation_Regular_Tab 06_12/13/2012
� � � - ��� ,X���'i� k 3 * � . � - � . � ; ., . .., „ , ,s,� , � . �. . . . ., _ . ,,,_ .. . , , , ._ , t .. FINANCE DEPARTN�NT DATE: DECEMBER 7,2012 TO: NIICHAEL R COUZZO,VII,LAGE MANAGER FROM: JOANN FORSYTHE,FINANCE DIRECTOR RE: OVERVIEW OF REVENUES AND EXPENDITiJRES AS OF NOVEMBER 30, 2012 Per your request,below is a summary of revenues and expenditures as af November 30,2012 by fund. Village of Tequesta Summary of Revenues and E�enditures as of November 30, 2012 Governmental Funds AATD Reven�es MTD Expenditures 001 -General Fund 638,887.32 969,742.20 101 -Improvemerrt Bond Revenue 0.00 0.00 301 -Capital improvement Fund 0.00 0.00 302-Bond Construction Fund 0.00 0.00 303-Capital P�ojects Fund � � TO�'dl 638,887.32 969,742.20 Enterorise Funds 401 -Water Fund 353,456.38 283,995.83 402-Refi�se&ReCydir� 42,175.24 40,334.40 403-Stormwater Utility �6,792.73 116.778.21 TOtal 422,364.35 441,108.44 12/10/121:00 PM Gener�l Fund: Revenues: Overall the Villages' revenues ate on target with projections. • We expect to receive appro�mately 60% of ad valorem revenues (the largest single revenue source)in the month of December. • Tequesta Fest revenues (including sponsorships)were budgeted at $27,000 and we have recorded $27,591 to date. • Leisure Services "Special Events" has exceeded the budget by $778.00 which is the result of the success of the Green Market. Expenditures; We are in communications with various departnients to resolve small adjustments within individual accounts within their departments. However, overtime within the Police Department (communication services) is trending higher than budgeted due to unanticipated employee FMLA leave and may need additional funding. Additionally, • The following accounts: "Compensated Absences", "Life/Health Insuta.nce" and "HSA — Health Savings Account", have been adjusted and the remaining balances reflect expected expenditures/expenses that will be incurred during the year. o The Police depariment has budgeted 7 additional hires that will impact the above accounts by the fiscal year end. • The account "Legal — Anne�tion" was created to accumulate the legal cost of annexation, however,it has not been funded at this titne. • Public Works,"Insurance"is higher than anticipated due primarily to unforeseen charges related to a former employee. Water Utility Revenues, Overall,revenues are trending close to budget Of interest; � Water Connect fees and Capital Connect Charges are higher than anticipated due to the addition of Tequesta Family Medical Center to the system. Expenses Salaries (plant) are under budget due the resignation of Roy Fallon and subsequent vacancy in that pasition. Confidenrial 2 REYENUEIFXPEN�TURE REPORT as of November 30,2012 Page: 1 12110/2012 \fi�age af Tequesta 12:52 pm For fhe Periad: 10/1/2012 to 11/�12012 ��' 'nal�. M�ended Bud. YTD A�al CURR b(TFI Emwmb.YTD UnencBal %Bud Fund:001-Gene.ral Fund Revenuss Dept 000 General Gerreral Property Taxes 4,3T/,000.00 4,3T7,0�.00 305,714.78 305,714.78 0.00 4,W1,285.22 7.0 Sales&Use T�ces 1,032,700.00 1,032,700.00 168,865.39 90,978.20 0.00 863,834.61 16.A Frand�isetees-gros.s2ceipt 401.A00.00 401,400.00 74.153.62 38,719.89 0.00 327,246.38 18.5 InU�gorernrr�tal Revenue 503,709.00 503,709.00 83,951.48 41,975.74 0.00 419,757.52 16.7 Infergovemmental Revenue 719,000.00 719,W0.00 71,129.35 56,813.33 0.00 647,870.65 9.9 Chgs for Sarv-Gan Gov 8,650.00 8.656.� 1.598.64 777'.93 0.00 7,051.36 18.5 Rents 8�Royal6es 140,050.00 144,050.00 29,738.94 16,119.47 0.00 110,311.� 21.2 CanUibutions&Daia�or�s 0.00 1,500.U0 1,500.00 0.00 0.00 0.00 100.0 �s RevenueS 15,50Q.00 15,500.00 14.00 13.00 0.00 15,486.OQ 0.9 General 7,198,009.00 7,199,509.00 7�,666.20 551,11234 0.00 6,4fi1,642.80 10.2 Dept 150 Comprehensive Plam�ing Charges for Services q5,000.00 b5,000.00 4,843.25 1,243.25 0.00 40.156.75 10.8 Miscellaneous Revenues 200.00 200.00 0.00 0.00 0.00 200.00 0.0 Co�ensive Planning 45,200.00 45,200.00 4,843.25 1,24325 0.00 40,356.75 10.7 Dept 171 Pokce S�es&Use T�ces 56,470.00 56,470.00 0.00 O.OQ 0.00 56,470.� 0.0 Lrc:enses&Permits 6,300.00 6,300.00 5,040.00 6�.00 0.00 1,260.� 8(I.0 Intergovemmental Revenue 21,850.00 21,850.00 0.00 O.OD 0.00 21,850.00 0.0 Chgs for Serv-PuWic SaFery 20,000.00 20,000.00 0.00 0.00 0.00 20,000.00 0.0 Fmes&Fofidh�res 20,800.00 20,800.00 2,873.18 140.00 0.00 17,926.82 13.8 Impact Fces 0.00 0.00 62.98 62.98 0.00 �2.98 0.0 Miscellaneous Revenues 0.00 0.00 5.W 0.00 0.00 -5.00 0.0 Police 125,420.00 125,420.00 7,981.16 882.98 0.00 117,438.84 6.4 Dept 180 Bu�dim�8 Zoning Licenses&Permifs 315,750.00 315,750.00 56,975.10 34,918.5fi 0.06 258,774.90 18.0 Bu�g&Znning 315,7�A0 315,750.00 56,975.10 34,916.56 O.OD 258,774.90 18.0 Depk 192 Fire C�trol Sale.s&Use T�ces 154,700.00 154,7�.00 0.00 0.00 0.00 154,700.06 0.0 Intergovemmental Revenue 6,840.00 6,840.00 0.00 0.00 O.Op 6,&W.00 0.0 REYENUFJEXFENDITURE REPORT as�November 30.2012 Page: 2 12/102012 Y�tlage of Tequesha 1252 pm For Uie Period: 1011I2012�011f3012012 Origmal Bud. A�Bud. YTD Adual CUI�MTH Encurt�.YTD Unen�Bal 96 Bud Fund: 001-General Fund Revenues DepC 192 Fire Controt ChargesforServices 747,040.00 747,040.00 96,053.19 29.068.47 0.00 650,9�.81 12.9 ImpaclFees 500.0p 500.00 86.7A 86.74 0.00 41326 17.3 Cantribudons&Donadons 1,000.� 1.000.00 100.00 100.00 0.� 900.00 10.0 A�us Rerenues 700.00 700.00 16.50 16.50 0.00 663.50 2.4 Fire Confiol 910,780.00 910,78p.00 96,256.43 29,271.71 0.00 614,523.57 10.6 Dept 231 Leisure Services Charges for ServN;es-Recr. 83,900.00 83,900.00 26,266.34 18,588.96 0.00 57,633.66 31.3 Rents 8 Roy�ties 3,000.00 3,OU0.00 1,240.42 808.39 0.00 1,759.58 41.3 Im{�ct Fees 0.00 0.00 2I5.60 275.60 D.00 -275.60 0.0 Con6ributions&Donations 7,000.00 7,000.00 8.700.00 600.00 0.00 -1,700.� 124.3 bGsceN�eousRevenues 5,000.� 5,000.00 1,151.86 406.60 0.00 3,848.12 23.0 IBisure Services 98,900.00 98,900.00 37,634.24 20,679.55 0.00 61.26576 36.1 Dept 900 IMerfund Transfers Transfers In 452,440.00 452,440.00 0.00 0.00 0.00 452,440.00 0.0 lolerfu�d Transfers 452,440.00 452,440.00 0.00 0.00 0.00 452,440.00 0.0 D�t 950 01��brwpe�in9 Un�es6it�d Inveshn�t E.�nin 25,500.00 25.5�.00 3.033.76 778.93 0.00 22.466.24 11.9 Other Nonoperadng 25,5�.00 25,500.00 3,033.76 778.93 0.00 22,466.24 11.9 Dept: 990 OU�edReservelCa�tingenq Oiher Finanang Sarr�s 470,991.00 410,342.00 0.00 0.00 0.� 410,342.OD 0.0 OtherA�ser�eM.ontingency 470,�J1.00 410,34200 0.00 0.00 0.00 410,342.� 0.0 Revenues 9,642,990.00 9.583,841.00 943,390.14 638.887.32 0.00 8.640,450.86 9.8 ExpendituBs o�x �oo ca,�a Operating F�endid�reslExpense 28,450.00 28,450.00 6,854.53 2,606.53 D.00 21.�5.47 24.1 Council 28,450.00 28,450.00 6,854.53 2,606.53 0.00 21,595.47 24.1 Dept: 110 Manager Personal Services 199,330.� 199,705.00 36,153.3,9 17,366.15 285.00 163,266.61 18.2 Operatirg ExpeiM�ure,c/Expe�se 4,�0.00 4,800.00 1,712.03 471.00 0.00 3,087.97 35.7 Manager 204,230.00 204,505.00 37,865.42 17,837.15 285.00 166,354.58 18.7 Dept 111 Human Resoumzs ftkVEOWEIEXPENDRURE REPOftT as�November 30,2012 Page: 3 1?/10/2012 Y�ge of Teq�sha 12:52 pm Fot 1he Period: 90/1/2012 to 11/30/2012 Oripe�al&d. Amended Bud. YTD Actual CURR MTH Encumb.YTD Ut�encBal 96 Bud Futld: 001-General FurM Expenditures Dep� 111 Human I�SOUrt;es Personal Services 152,736.00 152,050.00 24,384.81 13,879.27 2,�1.7(1 124,863.49 17.9 Opera6tg Expeodi�iss/Exper�se 6,700.00 6,700.00 1,991.51 1,686.83 0.00 4,708.A9 29.7 Human Resources 159,430.00 158,750.00 26,376.32 15,566.10 2,801.70 129,571.98 18.4 Depk 120 Ytllage Clerk PersonalServices 154,590.00 157,489.00 26,423.77 15,420.97 247.50 130,817.73 16.9 Operating Expenditures/Expense 62,335.00 62,335.00 4,495.27 3,615.18 0.00 57,839.73 7.2 �Ilage Clerk 216,925.00 219,824.00 30,919.04 19.036.15 247.50 186,657.4fi 14.2 Oept: 130 Fin�ce Per�al Services 347,870.00 340,542.00 52,353.94 29,003.61 5T7.50 287,610.56 15.5 Operating F_xpendiWreslE�ense 49,450.00 49,400.00 8,9�.21 4,900.37 19,245.� 21,1�4.71 57.1 Financs 397,320.00 389,942.00 61,334.15 33,903.98 19,822.58 308,785.27 20.8 Dept 140 Legal Operatirg Expendidue�Expense 1f4,000.00 114,000.00 10,480.00 10,480.00 12,500.00 91,020.00 20.2 Legal 114,000.00 114,000.00 10,480.00 10,480.� 12,500.00 91,020.00 20.2 Dept: 15E1 C�er�sive Pianning Oper�ng Exp�di��es/Expense 149,580.� 149,5�.00 17,891.18 13,256.68 91,842.� 39.846.32 73.4 CompBhensnre Pl�ning 149,560.00 149,580.00 17,891.18 13,258.68 91,84250 39,846.32 73.4 D�t 160 General Govemment Person�Services 94,910.00 94,990.00 14,716.35 7,439.13 157.50 80,ttd.15 15.7 Opera6rg ExpendiWreslExpense 181,700.00 181,700.00 37,626.09 18,865.74 57,814.53 86,259.38 52.5 Capital0utlay 0.00 5,801.00 5,800.01 0.00 0.00 0.99 100.0 General Govemment 276.610.00 282.491.00 58,144.45 26.�4.87 57,972.03 166,374.52 41.1 Dept 175 PoGce Depaitrnent Personal Serv� 2,511.670.00 2,466,239.00 375,484.06 200,004.83 28,462.50 2,062,292.44 16.4 Opera6ng ExpendiWres/Experae 374,080.00 374,080.00 63,363.67 46,916.56 46,074.65 264.641.68 29.3 Capit�OuUay 40,000.00 66,129.00 0.00 0.00 53,712.75 12,416.25 81.2 Pdice Departrnent 2.925,750.00 2,906,448.00 438.847.73 246,931.39 128,2b9.90 2,339,350.37 19.5 Dept 18D Build'mg 8 7.onim� PersonalServices 193.680.00 192,170.00 29,118.90 16,577.71 285.� 162.7B6.10 15.3 OpwaBng Expend'AureslExpense 151,400.00 151,400.00 20.320.90 19,648.23 99,43Q.70 31,648.40 79.1 Building&Zating 345,080.00 343.570.00 49,439.80 36,225.94 99,715.70 194.414.50 43.4 REVENUFJD(PENDfTURE REPORT as of November 3D,2012 Page: 4 ��oizo�a �Bage a�Tequesfa 12:52 pm For ihe Period: 10l1/2012 to 11130PI012 Original Bud. M�ended Bud. YTD Adual CURR MTH Encu�.YTD UnencBal 96&ui Fur�l: 001-Gen�al Fund ExpendiW�es D�t 192 Fae Control Personal Serv�es 2,683,105.� 2,639,475.00 �4,317.53 213,6'08.34 50,604.93 2,194,552.54 16.9 Opera6ng Exp�iWres/Expense 310,140.00 314.930.00 40,111.35 23,280.94 40,120.60 234,698.05 25.5 C�rital0u8ay 7,500.00 7,500.00 0.� 0.00 0.00 7,500.00 0.0 Fre Control 3,000,745.00 2,961,905.00 434,428.88 2�,88.9.28 90.725.53 2.436,750.59 17.7 Dept 210 Public Wo�a Personal3ervices 3U7,180.00 �.780.00 47,345.00 32,235.94 8,160.00 250,275.D0 18.2 Oper�n9 Fxpe���nse 480,220.� 486,720.00 69,132.80 50.534.52 32.399.24 385,187.96 20.9 PuWic Works 787.4�.00 792,500.00 116,477.80 82,770.46 40.559.24 635,462.96 19.8 Dept 231 Leisure Services Personal5ervices 338,090.00 332,496.00 49,172.85 27,�.73 6,142.50 277,180.65 16.6 �eradng Exp�dilureslExpense 252,320.00 252,320.00 99,422.63 93,230.30 9,828.90 143,088.27 A3.3 Lei,su2 Senices 590,410.00 584.816.00 1A8.595.68 12Q,329.03 15,971.40 420,248.92 28.1 Dept 700 Debt Service D/S-Prinapal �,995.00 �.995.00 41,671.78 21,070.63 3,210.69 261,112.53 14.7 D!S-Interest 125,065.i10 125,065.00 2L580.51 10,750.30 295.44 103,188.05 17.5 DebtService 431,080.00 431,060.00 63,252.29 31,820.93 3.506.13 364,301.58 15.5 Dept: 950 Other Nonoperating Ott�er Finanting Sour�s 8 lkes 16,000.00 16,000.00 1,99'1.95 1,2�.09 0.00 14,017.05 12.4 OlherNor�erating 16,000.00 16.000.00 1,982.95 1.208.09 0.00 14,017.05 12.4 Expendilures 9,662,990.00 9,583,841.00 1,502,890.22 895,168.58 564,199.21 7,516,751.57 21.6 Net Efiect for General Fund 0.00 0.00 -55.9,500.08 -256,281.26 564,199.21 1.123,699.29 0.0 Cha�e in Fund Balance: -559,500.08 REVENUEID(PENDITURE REPORT as of Novembet 30,2012 Page: 5 12110/2012 Vidage�Teque.sta 12:52 pm For tlie Period: 10/1/2012 to 11/30/2012 Oripinad Bud. Amended Bud. YTD Aclu� CURR MTH Encumb.YTD UnencBal %Bud Fund: 301-C�itai Im�xovertient Fund Revenues Dept 990 OlhedRese�lCCaii6n9��Y Otl�er Financing Sourt�s 290,440.00 29D,440.00 0.00 0.00 0.� 290,440.00 0.0 OthedReserve/Conti�gency 290,440.00 290,440.00 0.00 0.00 0.00 290,44D.00 0.0 Revenues 290,440.00 290,440.00 0.00 0.00 0.00 290,440.00 0.0 Expenditures Deph 900 fnterfund Transfers ms�a r�o� �,aao.00 zso,aao.00 o.00 o.oa o.� zso,aao.00 o.o m�,�a T�,sr�s 2so,a4o.00 zso,aao.00 o.� o.00 o.00 zso,ano.00 o.o �� zso,4+o.� �so,aao.00 o.ao o.00 o.00 �so,aao.00 o.o Net Efrect for Capital Improvement Fund 0.00 0.00 0.00 0.00 0.00 0.00 0.0 Change in Fund B��ce: -559,�0.08 REVENUFJD(PENDITURE REPORT as�November 30,2012 Page: 6 12110/2012 Village of Tequesta 12.52 pm For the Period: 1011 J2012�11130f2012 Oripinal Bud. M�endgd Bud. YTD Aclual CURR MfH Er�cumb.YTD UnencBal 96 Bw! Fund: 303-Capit�Projecis Fund Revenues Dept 990 O�etA28serwalCoe6o9���9 Otlter Fin�chig Sources 112,OOD.00 112,000.00 0.00 0.00 0.00 112,000.00 0.0 OthedReservelContingency 112,000.00 112,000.00 0.00 0.00 0.00 112,000.00 0.0 Revenues 112,000.00 112,000.00 0.00 0.00 0.00 112.000.00 0.0 Expenditures DepF. 900 IMerfund Transfers In�rfund Transfe�s Out 112,000.00 112,000.00 0.00 0.� 0.00 112,�0.00 0.0 I�rfund Transfers 112,000.00 112,000.00 D.00 0.00 0.00 112,000.00 0.0 Expendihtres 112,000.00 112,OOO.QO 0.00 0.� 0.00 112,000.� 0.0 Net E�ect for Capihal Projects Fund 0.00 0.00 0.00 0.00 0.00 0.� 0.0 Change in Fund B�ance: -559,500.� Mayo, Deanna From: Forsythe, Jody Sent: Tuesday, December 04, 2012 5:02 PM To: McWilliams, Lori; Mayo, Deanna Cc: Couao, Michael; Telfrin, Debra Subject: Budget Update as of November 30, 2012 Attachments: �Re36A. pdf Lori, Please find attached a copy of the Revenue and Expenditure (budget to actual) report as of November 30, 2012. I am in the process of reviewing the report to identify any items that should be brought to the attention of the Village Manager and Village Council and will forward a report to you in the next day or two. -lody ,Io.�nn Forsyt6i.e, CP.�I Finance Director Village of Tequesta 561-768-0424 iforsvthe@tequesta.or� 1 REVENUEIEXPENDITURE REPORT as of November 30, 2012 Page: 1 12I4/2012 Vill M T equesta 4:55 pm For the Period: 10I1I2012 to 11I30I2012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001- General Fund Revenues Function: 000 General Revenues Dept 000 General Acct Class: 311 General Property Taxes 311.000 Ad Valo�em Taxes - Curtent 4,372,000.00 4,372,000.00 305,714.78 305,714.78 0.00 4,066,28522 7.0 311.100 Ad Valorem Taxes-Del 5,000.00 5,000.00 0.00 0.00 0.00 5,000.00 0.0 GeneralPropertyTaxes 4,377,000.00 4,377,000.00 305,714.78 305,714.78 0.00 4,071,285.22 7.0 Acct Class: 316 Sales & Use Taxes 314.100 Utility Tax-Electricity 416,000.00 416,000.00 45,456.63 45,456.63 0.00 370,543.37 10.9 314.300 Utility Tax-Water 154,000.00 154,000.00 24,733.42 13,295.72 0.00 129,266.58 16.1 314.800 UtilityTax-Propane 28,000.00 28,000.00 1,347.04 1,347.04 0.00 26,652.96 4.8 315.000 Comm.Services Tax (CS� 354,600.00 354,600.00 26,988.76 26,988.76 0.00 327,61124 7.6 321.000 Local Business Tax (Occ Lic) 71,000.00 71,000.00 64,639.00 2,742.00 0.00 6,361.00 91.0 321.001 Home Business Tax 4,600.00 4,600.00 3,355.00 415.00 0.00 1,245.00 72.9 321.010 Local Business Tax - County 4,500.00 4,500.00 2,345.54 733.55 0.00 2,154.46 52.1 Sales 8 Use Taxes 1,032,700.00 1,032,700.00 168,865.39 90,97820 0.00 863,834.61 16.4 Acct Class: 318 Franchise fees - gross receipt 313.100 Fran Fees-Electric 401,400.00 401,400.00 74,153.62 38,719.89 0.00 327,246.38 18.5 Franchise fees - g�oss receipt 401,400.00 401,400.00 74,153.62 38,719.89 0.00 327,246.38 18.5 Acct Class: 329 Intragovemmenhal Revenue 341.401 Admin Mgmt Fees-Water 485,229.00 485,229.00 80,871.50 40,435.75 0.00 404,357.50 16.7 341.402 Admin Mgmt Fee-Ref & Recycling 6,850.00 6,850.00 1,141.66 570.83 0.00 5,708.34 16.7 341.403AdminMgmtFees-StormWater 11,630.00 11,630.00 1,938.32 969.16 0.00 9,691.68 16.7 Intragovemmental Revenue 503,709.00 503,709.00 83,951.48 41,975.74 0.00 419,757.52 16.7 Acct Class: 335 Intergovemmental Revenue 335.120 State Revenue Sharing Proceeds 173,000.00 173,000.00 28,632.04 14,316.02 0.00 144,367.96 16.6 335.150 Alcoholic Beverage Licenses 5,000.00 5,000.00 0.00 0.00 0.00 5,000.00 0.0 335.180 Local Govt Half-Cent Sales Tau 370,000.00 370,000.00 29,037.59 29,037.59 0.00 340,962.41 7.8 338.101 Local Gas Tax-6 Cent 116,500.00 116,500.00 9,180.18 9,180.18 0.00 107,319.82 7.9 338.102 Local Gas Tax 1-5 Cent 54,500.00 54,500.00 4,279.54 4,279.54 0.00 50,220.46 7.9 Intergovemmental Revenue 719,000.00 719,000.00 71,129.35 56,813.33 0.00 647,870.65 9.9 Acct Class: 341 Chgs for Serv - Gen Gov 341.101 CertificatioNCopy Fees 8,000.00 8,000.00 1,495.71 675.00 0.00 6,504.29 18.7 341.103 Electlon qualirying fees 150.00 150.00 0.00 0.00 0.00 150.00 0.0 341.105 Admin fees from other Gov'is 500.00 500.00 102.93 102.93 0.00 397.07 20.6 Chgs for Serv - Gen Gov 8,650.00 8,650.00 1,598.64 777.93 0.00 7,051.36 18.5 Acct Class: 362 Renfs 8 Royalties 362.110 Lease-Sprint 34,260.00 34,260.00 6,017.42 3,�8.71 0.00 28,242.58 17.6 362.112 Lease-T-Mobile 48,850.00 48,850.00 7,887.28 3,943.64 0.00 40,962.72 16.1 362.115 Lease-Nextel 26,940.00 26,940.00 8,334.24 4,167.12 0.00 18,605.76 30.9 362.116 Lease-AT&T 30,000.00 30,000.00 7,500.00 5,000.00 0.00 22,500.00 25.0 Rents & Royalties 140,050.00 140,050.00 29,738.94 16,119.47 0.00 110,311.06 21.2 Acct Class: 366 Contribu6ons & Donations 366.100 Contrib & Donations & Sponsors 0.00 1,500.00 1,500.00 0.00 0.00 0.00 100.0 Contributions & Donations 0.00 1,500.00 1,500.00 0.00 0.00 0.00 100.0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 500.00 5W.00 14.00 13.00 0.00 48fi.00 2.8 369.100 Insurance Reimbursement 15,000.00 15,000.00 0.00 0.00 0.00 15,000.00 0.0 Miscellaneous Revenues 15,500.00 15,500.00 14.00 13.00 0.00 15,486.00 0.1 General 7,198,009.00 7,199,509.00 736,666.20 551,112.34 0.00 6,462,842.80 10.2 REVENUEIEXPENDITURE REPORT as of November 30, 2012 Page: 2 1214/2012 Village of Tequesta 4:55 pm For the Period: 1011I2012 to 11I30I2012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001 - General Fund Revenues General Revenues 7,198,009.00 7,199,509.00 736,666.20 551,112.34 0.00 6,462,842.80 10.2 Function: 410 General Govemment Dept: 150 Comp2her�sive Planning Acct Class: 340 Charges for Services 341.150 Land Development Fees 45,000.00 45,000.00 4,800.00 1,200.00 0.00 40,200.00 10.7 343.700 Water Conservation & Resource 0.00 0.00 38925 38925 0.00 -389.25 0.0 Charges for Services 45,000.00 45,000.00 5,18925 7,589.25 0.00 39,810.75 11.5 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 200.00 200.00 0.00 0.00 0.00 200.00 0.0 Miscellaneous Revenues 20p.00 200.00 0.00 0.00 0.00 200.00 0.0 Comprehensive Planning 45,200.00 45,200.00 5,f89.25 1,58925 0.00 40,010.75 11.5 General GovemmeM 45,200.00 45,200.00 5,189.25 1,589.25 0.00 40,010.75 11.5 Fundion: 420 Public Safety Dept: 171 Police Acct Class: 316 Sales & Use Tazes 312.520 Casualty Insurance Premium Tax 56,470.00 56,470.00 0.00 0.00 0.00 56,470.00 0.0 Sales & Use Taxes 56,470.00 56,470.00 0.00 0.00 0.00 56,470.00 0.0 Acct Class: 320 Licenses & Pertnits 329.101 Alarm Pertnits 5,600.00 5,600.00 5,040.00 680.00 0.00 560.00 90.0 329.105 Goff Cart Pertnik 700.00 700.00 0.00 0.00 0.00 700.00 0.0 Licenses & Pertnits 6,300.00 6,300.00 5,040.00 680.00 0.00 1,260.00 80.0 Acct Class: 335 Intergovemmental Revenue 338.201 PBC 911 Maint Reimburse�nt 8,100.00 6,100.00 0.00 0.00 0.00 8,100.00 0.0 338202 PBC 911 DISPATCH REIMBURSEMENT 13,750.00 13,750.00 0.00 0.00 0.00 13,750.00 0.0 Intergovemmental Revenue 21,850.00 21,850.00 0.00 0.00 0.00 21,850.00 0.0 Acct Class: 342 Chgs ior Serv - Public Safety 342.110 PBC - Marine law e�orce. serv 20,000.00 20,000.00 0.00 0.00 0.00 20,000.00 0.0 Chgs for Serv - Public Safety 20,000.00 20,000.00 0.00 0.00 0.00 20,000.00 0.0 Acct Class: 351 Fines & Forfeitures 351.100 Court Fines 10,000.00 10,000.00 0.00 0.00 0.00 10,000.00 0.0 354.101 Parking Tickets 800.00 800.00 280.00 140.00 0.00 520.00 35.0 354.102 Code Er� Fines & Court CosLs 10,000.00 10,000.00 2,593.18 0.00 0.00 7,406.82 25.9 Fines 8 Forfeitures 20,800.00 20,800.00 2,873.18 140.00 0.00 17,926.82 13.8 Acct Class: 363 Impact Fees 362.221 Police Impact Fees 0.� 0.00 62.98 62.98 0.00 -62.98 0.0 Impact Fees 0.00 0.00 62.98 62.98 0.00 -62.98 0.0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 0.00 0.00 5.00 0.00 0.00 -5.00 0.0 Miscellaneous Revenues 0.00 0.00 5.00 0.00 0.00 -5.00 0.0 Police 125,420.00 125,420.00 7,981.16 882.98 0.00 117,438.84 6.4 Dept: 180 Building & Zoning Acct Class: 320 Licenses 8 Pertnits 322.000 Building Permit Fees 3W,000.00 300,000.00 51,344.38 33,201.68 0.00 248,655.62 17.1 329.000 Contracror's Registration 9,750.00 9,750.00 3,100.00 1,105.00 0.00 6,650.00 31.8 329.010 Contraclor Reg. - County 6,000.00 6,000.00 2,530.72 611.88 0.00 3,469.28 422 Licenses & Permits 315,750.00 315,750.00 56,975.10 34,918.56 0.00 258,774.90 18.0 REVENUEIEXPENDITURE REPORT as of November 30, 2012 Page: 3 12I4I2012 Village of Tequesta 4:55 pm For the Period: 10I112012 to 11I30I2012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001 - General Fund Revenues Function: 420 Public Safety Buikling 8 Zoning 315,750.00 315,750.00 56,975.10 34,918.56 0.00 258,774.90 18.0 Dept 192 Fire Conlrol Acct Class: 316 Sales & Use Taxes 312.510 Fi2 Insurance P2m Tax 154,700.00 154,700.00 0.00 0.00 O.QO 154,700.00 0.0 Sales & Use Taxes 154,700.00 154,700.00 0.00 0.00 0.00 154,700.00 0.0 Acct Class: 335 Inte�govemmeMal Revenue 335.201 Fire Incentive Pay 6,840.00 6,840.00 0.00 0.00 0.00 6,640.00 0.0 Intergovemmental Revenue 6,840.00 6,840.00 0.00 0.00 0.00 6,840.00 0.0 Acct Class: 340 Cha�ges for Services 342.192 Fire - ExUa Duty 500.00 500.00 0.00 0.00 0.00 500.00 0.0 342201 Fire Plan Review Fees 26,000.00 26,000.00 2,948.76 1,612.50 0.00 23,05124 11.3 342202 Fire Inspections 24,740.00 24,740.00 5,088.82 3,131.51 0.00 19,651.18 20.6 342.401 Emergency Service-JIC 223,100.00 223,100.00 0.00 0.00 0.00 223,100.00 0.0 342.402 Fire Rescue-CPR Program 700.00 700.00 75.00 25.00 0.00 625.00 10.7 342.410 Emergency Svo- PBC Fire Rescue 184,0�.00 184,000.00 46,000.00 0.00 0.00 138,000.00 25.0 342.600 EMS Transportatlon Fees 288,000.00 288,000.00 17,641.15 0.00 0.00 270,358.85 6.1 Charges for Services 747,040.00 747,040.00 71,753.73 4,769.01 0.00 675,28627 9.6 Acct Class: 363 Impact Fees 362.222 Fire Impact Fees 500.00 500.00 86.74 86.74 0.00 413.26 17.3 Impact Fees 500.00 500.00 86.74 86.74 0.00 413.26 17.3 Acct Class: 366 Contributions 8 Donations 366.100 Contrib & Donations 8 Sponsors 1,000.00 1,000.00 110.00 110.00 0.00 890.IX1 11.0 Contributions&Donations 1,000.00 1,000.00 110.00 110.00 0.00 890.00 11.0 Acct Class: 369 Miscellaneous Revenues 365.102 Fi2 Dept Sales 100.00 100.00 16.50 16.50 0.00 83.50 16.5 369.000 Other Miscellaneous Revenue 600.00 600.00 0.00 0.00 0.00 600.00 0.0 Miscellaneous Revenues 700.00 700.00 16.50 16.50 0.00 683.50 2.4 Fi2Control 910,780.00 910,780.00 71,966.97 4,98225 0.00 838,813.03 7.9 PublicSafery 1,351,950.00 1,351,950.00 136,923.23 40,783.79 0.00 1,215,026.77 10.1 Function: 450 Leisure Services Dept: 231 Leisure Services Acct Class: 347 Charges for Services - Recr. 347.1� TequestaFest 20,000.00 20,000.00 18,89074 16,606.98 0.00 1,109.26 94.5 347.190 Special Events - Other 5,000.00 5,000.00 5,778.00 977.38 0.00 -778.00 115.6 347.201 Spring ISummer Camp Fees 52,900.00 52,900.00 400.00 400.00 0.00 52,500.00 0.8 347.205 Recreation Programs Fees 6,000.00 6,000.00 1,197.60 604.60 0.00 4,802.40 20.0 Charges for Services - Recx. 83,900.00 83,900.00 26,266.34 18,588.96 0.00 57,633.66 31.3 Acct Class: 362 Rents 8 Royakies 362.100 Rental-Facilities 3,000.00 3,000.00 1,240.42 808.39 0.00 1,759.58 41.3 Rents 6 Royalties 3,000.00 3,000.00 1,240.42 808.39 0.00 1,759.58 41.3 Acct Class: 363 Impact Fees 363271 Parks and Rec Impact Fees 0.00 0.00 275.60 275.�0 0.00 -275.60 0.0 Impact Fees 0.00 0.00 275.60 275.60 0.00 -275.60 0.0 Acct Class: 366 Contributions & Donations 366.100 Contrib & Donadons & Sponsors 7,000.00 7,000.00 8,700.00 600.00 0.00 -1,706.00 124.3 Contributlons & Donations 7,000.00 7,000.00 8,700.00 600.00 0.00 -1,700.00 124.3 REVENUEIEXPENDITURE REPORT as of November 30, 2012 Page: 4 1214/2012 Village of Tequesta 4:55 pm For the Period: 1011I2012 to 11/30I2012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001 - General Fund Revenues Function: 450 Leisure Services Dept: 231 Leisure Services Acct Class: 369 Miscellaneous Revenues 365.110 Concession Sales 5,000.00 5,000.00 1,151.88 406.60 0.00 3,846.12 23.0 Miscellaneous Revenues 5,000.00 5,000.00 1,151.88 406.60 0.00 3,848.12 23.0 Leisure Services 98,900.00 98,900.00 37,634.24 20,679.55 0.00 61,265.76 38.1 Leisu�e Services 98,900.00 98,900.00 37,634.24 20,679.55 0.00 61,265.76 38.1 Function: 581 Other Financing Sources and Us Dept: 900 Interfund Transfers Acct Class: 391 Transfers In 381.301 Transfer-In from Cap Imp�ovemn 290,440.00 290,440.00 0.00 0.00 0.00 290,440.00 0.0 381.303 Tsfer-In from Capital Projecls 112,000.00 112,000.00 0.00 0.00 0.00 112,000.00 0.0 381.605 Tfr In - Special Law Enf Trust 50,000.00 50,000.00 0.00 0.00 0.00 50,000.00 0.0 Transfers In 452,440.00 452,440.00 0.00 0.00 0.00 452,440.00 0.0 Interiund Transfers 452,440.00 452,440.00 0.00 0.00 0.00 452,440.00 0.0 Other Financing Sources and Us 452,440.00 452,440.00 0.00 0.00 0.00 452,440.00 0.0 Function: 590 Other Nonoperating Dept: 950 Other Noraperating Acct Class: 361 Un2shided Investment Eamin 361.1001nteresUlnvesfi�entEamings 10,000.00 10,000.00 1,267.00 326.41 0.00 8,733.00 12.7 361.101 PBC Tax Col-Interest on Dep 500.00 500.00 0.00 0.00 0.00 500.00 0.0 367.100 Net Unreal app�ecia6on (Dep) 15,000.00 15,000.00 1,314.24 0.00 0.00 13,685.76 8.8 Unrestricted Investrnent Eamin 25,500.00 25,500.00 2,58124 326.41 0.00 22,918.76 10.1 Other Nonoperating 25,500.00 25,500.00 2,58124 326.41 0.00 22,918.76 10,1 Dept 990 OthedResenelCor�tingency Acct Class: 390 Other Financing Sou�es 399.999 Appropriate Fund Balance 470,991.00 410,342.00 0.00 0.00 0.00 410,342.00 0.0 Olher Financing Sources 470,991.00 410,342.00 0.00 0.00 0.00 410,342.00 0.0 OfhedReservelCoMingency 470,991.00 410,342.00 0.00 0.00 0.00 410,342.00 0.0 Other Nonoperating 496,491.00 435,842.00 2,58124 326.41 0.00 433,260.76 0.6 Revenues 9,642,990.00 9,583,841.00 918,994.16 614,491.34 0.00 8,664,846.84 9.6 Ezpenditures Function: 410 General Govemment Dept: 100 Council Acct Class: 530 OperaUng Expenditures/Expense 531.311 CouncilFees-Arena 3,000.00 3,000.00 750.00 500.00 0.00 2,250•00 25.0 531.313 Counal fees - T. Patemo 3,000.00 3,000.00 750.00 500.00 0.00 2,250.00 25.0 531.314 Council fees - F. D'Ambra 3,000.00 3,000.00 750.00 500.00 0.00 2,250•00 25.0 531.316 Council fees - S. Okun 3,000.00 3,000.00 750.00 500.00 0.00 2,250.00 25.0 531.317 Council Fees - Brennan 3,000.00 3,�0.00 750.00 500.00 0.00 2,250.00 25.0 540.301 CouncilExpenses-Arena 1,500.00 1,500.00 0.00 0.00 0.00 1,500.00 0.0 540.304 Council Expense- F. D'Ambra 1,500.00 1,500.00 0.00 0.00 0.00 1,500.00 0.0 540.306 CouncilExpense-S.Okun 1,500.00 1,500.00 73.53 60.53 0.00 1,426.47 4.9 540.307 CouncilExpenses-Brennan 1,500.00 1,500.00 0.00 0.00 0.00 1,500.00 0.0 540.308 CouncilExpenses- Patemo 1,500.00 1,500.00 0.00 0.00 0.00 1,500.00 0.0 549.300 Other Misc Chgs & Obligations 1,000.00 1,000.00 17.50 17.50 0.00 982.50 1.8 549.350 VolunteerAppreciation 800.00 800.00 0.00 0.00 0.00 800.00 0.0 552.302 Small Tools and Equipment 750.00 750.00 0.00 0.00 0.00 750.00 0.0 REVENUEIEXPENDITURE REPORT as of November 30, 2012 Page: 5 1?J4/2012 Vill o f T equesta 4:55 pm For the Period: t01112012 to 11I30I2012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001 - General Fund Expenditures Function: 410 General Govemment Dept: 100 Council Acct Class: 530 Operating ExpenditureslExpense 554.300 Books, Publ, Subs 8 Membership 3,400.00 3,400.00 2,985.00 0.00 0.00 415.00 87.8 Operating ExpenditureslExpense 28,450.00 28,450.00 6,826.03 2,578.03 0.00 21,623.97 24.0 Council 28,450.00 28,450.00 6,826.03 2,578.03 0.00 21,623.97 24.0 Dept 110 Manager Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 129,600.00 129,600.00 17,379.35 9,912.02 0.00 112,220.65 13.4 514.100 Overtime 0.00 100.00 66.53 66.53 0.00 33.47 66.5 515.108 Auto Allowance 3,000.00 3,000.00 500.00 250.00 0.00 2,500.00 16.7 516.100 Compensated Absences 11,400.00 11,325.00 6,825.00 0.00 0.00 4,500.00 60.3 521.101 FICA Taxes 6,500.00 6,500.00 336.46 197.45 0.00 6,163.54 5.2 521.102 MedicaB Taxes 2,000.00 2,000.00 262.83 150.99 0.00 1,737.17 13.1 522.102 VOT Pension Contributions 12,200.00 12,200.00 1,611.42 920.36 0.00 10,588.58 132 523.101 LifelHealth Insurance 23,600.00 21,400.00 144.80 50.94 0.00 21,25520 0.7 523.105 HSA - HeaNh Savings Acwunt 0.00 2,550.00 2,550.00 0.00 0.00 0.00 100.0 524.100 Workers' Comp Insurance 380.00 380.00 94.40 0.00 285.00 0.60 99.8 526.104 ICMA-Def Comp Plan 9,900.00 9,900.00 1,317.73 752.99 0.00 8,582.27 13.3 554.301 Personnel Training 750.00 750.00 0.00 0.00 0.00 750.00 0.0 Personal Services 199,330.00 199,705.00 31,088.52 12,301.28 285.00 168,331.48 15.7 Acct Class: 530 Opera6ng ExpenditureslExpense 540.300 Travel & Per Diem 1,500.00 1,400.00 0.00 0.00 0.00 1,400.00 0.0 546.320 Computer system maiM 8 suppli 500.00 500.00 0.00 0.00 0.00 500.00 0.0 548.110 Marketing and Public Relations 1.00 1.00 0.00 0.00 0.00 1.00 0.0 549.300 Other Misc Chgs 8 Obligations 249.00 249.00 0.00 0.00 0.00 249.00 0.0 554.300 Books, Publ, Subs & Membership 2,650.00 2,650.00 1,712.03 471.00 0.00 937.97 64.6 Operating ExpenditureslExpense 4,900.00 4,800.00 1,712.03 471.00 0.00 3,087.97 357 Manager 204,230.00 204,505.00 32,800.55 12,772.28 285.00 171,419.45 162 Dept: 111 Human Resources Acct Class: 510 Personal Services 512.100 Regular Salaries 8 Wages 79,800.00 79,800.00 10,674.72 6,099.84 0.00 69,12528 13.4 515.107 Part-time Salaries 30,300.00 30,300.00 4,053.01 2,316.01 0.00 26,246.99 13.4 516.100 Compensated Absences 4,100.00 3,220.00 1,219.97 0.00 0.00 2,000.03 37.9 521.101 FICA Taxes 7,000.00 7,000.00 877.57 504.01 0.00 6,122.43 12.5 521.102 Medica2Taxes 1,700.00 1,700.00 205.24 117.87 0.00 1,494.76 12.1 522.102 VOT Pension Contributions 7,600.00 7,600.00 1,00128 572.16 0.00 6,598.72 13.2 523.101 L'rfelHeafth Insurance 7,600.00 6,800.00 103.01 33.96 0.00 6,696.99 1.5 523.105 HSA-HeaNhSavingsAcxouM 0.00 1,000.00 1,000.00 0.00 0.00 0.00 100.0 524.100 Workers' Comp Insurance 330.00 330.00 82.19 0.00 247.50 0.31 99.9 526.101 Employee Recognition Program 5,500.00 5,500.00 233.00 152.00 0.00 5,267.00 4.2 526.102 Employee Assistance Pro9ram 3,800.00 3,800.00 851.40 0.00 3,40.5.60 -457.00 112.0 554.301 Personnel Training 3,000.00 3,000.00 1,159.34 1,159.34 0.00 1,840.66 38.6 554.310 Employee Development 2,000.00 2,000.00 0.00 0.00 0.00 2,000.00 0.0 Personal Services 152,730.00 152,Q50.00 21,460.73 10,955.19 3,653.10 126,936.17 16.5 Acct Class: 530 Operating Expenditures/Expense 540.300 Travel 8 Per Diem 1,500.00 1,500.00 1,195.00 1,195.00 0.00 305.00 79.7 546.320 Computer system maint & suppli 1,700.00 1,700.00 0.00 0.00 0.00 1,700.00 0.0 547.300 Prin6ng 6 Binding 1,500.00 1,500.00 237.08 237.08 0.00 1,262.92 15.8 549.300 Other Misc Chgs 8 ObligaGons 500.00 500.00 0.00 0.00 0.00 500.00 0.0 549.401 Recruitment expenses 500.00 500.00 50.00 50.00 0.00 450.00 10.0 552.302 Small Tools and Equipment 500.00 500.00 115.76 115.76 0.00 38424 23.2 554.300 Books, Publ, Subs 6 Membership 500.00 500.00 304.68 0.00 0.00 195.32 60.9 Operafing ExpenditureslExpense 6,700.00 6,7W.00 1,902.52 1,597.84 0.00 4,797.48 28.4 REVENUEIF�(PENDITURE REPORT as of November 30, 2012 Page: 6 1214/2012 �Ilage of Tequesla 4:55 pm For lhe Period: 1011I2012 to 11I30/2012 Oripinal Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001 - General Fund Expendih�res � Function: 410 General Govemment Human Resou�es 159,430.00 158,750.00 23,36325 12,553.03 3,653.10 131,733.65 17.0 Dept 120 Village Clerk Acct Class: 510 Personal Services 512.100 Regular Salaries 8 Wages 109,800.00 109,800.00 14,700.97 8,400.55 0.00 95,099.03 13.4 516.100 Compensated Absences 4,300.00 1,399.00 1,396.17 0.00 0.00 0.83 99.9 521.101 FICA Taxes 6,800.00 6,800.00 802.55 466.38 0.00 5,997.45 11.8 521.102 MedicareTaxes 1,600.00 1,600.00 187.70 109.08 0.� 1,412.30 11.7 522.102 VOT Pension Contributlons 10,400.00 10,400.00 1,378.96 787.98 0.00 9,021.04 13.3 523.101 LifelHealth Insurance 19,100.00 23,200.00 185.14 67.92 0.00 23,014.86 0.8 523.105 HSA-HealthSavingsAcxount 0.00 1,700.00 1,700.00 0.00 0.00 0.00 100.0 524.100 Workers' Comp Insurance 330.00 330.00 81.22 0.00 247.50 1.28 99.6 554.301 Personnel Training 2,260.00 2,260.00 550.00 150.00 0.00 1,710.00 24.3 Personal Services 154,590.00 157,489.00 20,984.71 9,961.91 247.50 136,256.79 13.5 Acct Class: 530 Operating Expend'RureslExpense 531.303 Codification Services 7,650.00 7,650.00 950.00 950.00 0.00 6,700.00 12.4 531.304 Recording Secy Service 7,350.00 7,350.00 1,177.54 892.10 0.00 6,172.46 16.0 534.301 Election Expense 14,400.00 14,400.00 0.00 0.00 0.00 14,400.00 Q.0 534.302 Legal AdveAising 19,000.00 19,000.00 350.00 350.00 0.00 18,650.00 1.8 540.300 Travel & Per Diem 4,000.00 4,000.00 475.60 187.60 0.00 3,524.40 11.9 541.300 Communication Services 1,250.00 1,250.00 97.67 97.67 0.00 1,152.33 7.8 546.320 Computer system maiM 8 suppli 2,000.00 2,000.00 18226 59.36 0.00 1,817.74 9.1 549.100 Miscellaneous Archival 2,500.00 2,500.00 0.00 0.00 0.00 2,500.00 0.0 549.201 Advertising & Promo6on 1,000.00 1,000.00 88.80 88.80 0.00 911.20 8.9 549.300 Other Misc Chgs 8 Oblgations 1,800.00 1,800.00 75.87 75.87 0.00 1,724.73 4.2 552.302 Small Tools and Equipment 500.00 500.00 0.00 0.00 0.00 500.00 0.0 552.306 Microfilm ServicelSupplies 25.00 25.00 0.00 0.00 0.00 25.00 0.0 554.300 Baoks, Publ, Subs & Membership 860.00 860.00 356.25 172.50 0.00 503.75 41.4 Operating ExpenditureslExpense 62,335.00 62,335.00 3,753.99 2,873.90 0.00 58,581.01 6.0 Village Clerk 216,925.00 219,824.00 24,738.70 12,855.81 247.50 194,837.80 11.4 Dept: 130 Finance Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 242,500.00 242,500.00 32,319.11 18,312.10 0.00 210,180.89 13.3 514.100 Overtime 0.00 0.00 12.00 12.00 0.00 -12.00 0.0 516.100 CompensatedAbsences 11,300.00 5,572.00 3,074.78 0.00 0.00 2,497.22 552 521.101 FICATaxes 14,900.00 14,900.00 1,957.40 1,090.63 0.00 12,942.60 13.1 521.102 Medicare Taxes 3,500.00 3,500.00 457.80 255.08 0.00 3,042.20 13.1 522.102 VOT Pension Contributions 22,900.00 22,900.00 2,781.47 1,469.85 0.00 20,118.53 12.1 523.101 LifelHealth Insurance 47,400.00 42,400.00 352.30 106.97 0.00 42,047.70 0.8 523.105 HSA - HeaNh Savings AccouM 0.00 3,350.00 3,350.00 0.00 0.00 0.00 100.0 524.100 Workers' Comp Insurance 770.00 770.00 192.10 0.00 577.50 0.40 99.9 554.301 Personnel Training 4,600.00 4,600.00 100.00 0.00 0.00 4,500.00 22 Personal Services 347,870.00 340,492.00 44,596.96 21,246.63 577.50 295,317.54 13.3 Acct Class: 530 Operating ExpenditureslExpense 532.300 Axoundng 8 Auditlng Services 28,950.00 28,950.00 4,404.92 4,404.92 19,245.08 5,300.00 81.7 540.300 Travel & Per Diem 1,300.00 1,300.00 0.00 0.00 0.00 1,300.00 0.0 546.301 Office EquiplRepair & Maint 800.00 800.00 164.60 0.00 0.00 635.40 20.6 546.320 Computer system maint & suppli 8,500.00 8,500.00 3,637.99 0.00 0.00 4,862.01 42.8 547.300 PrinBng 8 Binding 3,000.00 3,000.00 0.00 0.00 0.00 3,000.00 0.0 549.300 Other Misc Chgs 8 Obligations 1,000.00 1,000.00 36.50 36.50 0.00 963.50 3.7 551.300 Office Supplies & Equipment 4,000.00 4,000.00 0.00 0.00 0.00 4,000.00 0.0 552.302 Small Tools and Equipment 500.00 500.00 0.00 0.00 0.00 500.00 0.0 554.300 Books, Publ, Subs 8 Membership 1,400.00 1,400.00 736.20 458.95 0.00 663.80 52.6 Operating ExpenditureslExpense 49,450.00 49,450.� 8,980.21 4,900.37 19,245.08 21,224.71 57.1 REVENUFIE)(PENDITURE REPORT as of November 30, 2012 Page: 7 1214/2012 �Ilage of Tequesta 4:55 pm For the Period: 1011/2012 to 1 t13012012 Oripinal Bud. Amended Bud. YTD Actual CURR MTH Er�cumb. YTD UnencBal °� Bud Fund: 001 - General Fund Expenditures Function: 410 General Govemment Finance 397,320.00 389,942.00 53,577.17 26,147.00 79,822.58 316,54225 18.8 Dept: 140 Legal Acct Class: 530 Operating Exper�ditureslExpense 531.301 Legal Services 94,000.00 94,000.00 10,480.00 10,480.00 12,500.00 71,020.00 24.4 531.308 Legal fees - Personnel 20,W0.00 20,000.00 0.00 0.00 0.00 20,000.00 0.0 Operating ExpendiWreslE�cpense 114,000.00 114,000.00 10,480.00 10,480.00 12,500.00 91,020.00 202 Legal 114,000.00 114,000.00 10,480.00 10,480.00 12,500.00 91,020.00 202 Dept: 150 Comprehensive Plannirg Axt Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 20,000.00 20,000.00 855.00 855.00 0.00 19,145.00 4.3 531.321 Mapping Services 2,500.00 2,500.00 0.00 0.00 0.00 2,500.00 0.0 531.322 Misc Planning Senice 106,080.00 106,080.00 14,237.50 9,605.00 91,842.50 0.00 100.0 531.331 Board of AdjustmeM 500.00 500.00 0.00 0.00 0.00 500.00 0.0 531.332 Planning and Zoning Board 2,500.00 2,500.00 0.00 0.00 0.00 2,500.00 0.0 531.405 Legal - Annexation 0.00 0.00 2,465.00 2,465.00 0.00 -2,465.00 0.0 534.300 Other Contractual Services 5,000.00 5,000.00 0.00 0.00 0.00 5,000.00 0.0 534.302 Legal AdveRising 12,000.00 12,000.00 0.00 0.00 0.00 12,000.� 0.0 547.300 Printing & Binding 500.00 500.00 0.� 0.00 0.00 500.00 0.0 549.300 Other Misc Chgs 8 Obligations 500.00 500.00 0.00 0.00 0.00 500.00 0.0 Operating ExpenditureslExpense 149,580.00 149,580.00 17,557.50 12,925.00 91,842.50 40,180.00 73.1 Comprehensive Planning 149,580.00 149,580.00 17,557.50 12,925.00 91,842.50 40,180.00 73.1 Dept: 160 General Govemment Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 69,800.00 69,800.00 9,34220 5,338.40 0.00 60,457.80 13.4 516.100 CompensatedAbsences 1,700.00 1,680.00 1,680.00 0.00 0.00 0.00 100.0 521.101 FICA Taxes 4,400.00 4,400.00 574.94 328.83 0.00 3,825.06 13.1 521.102 MedicareTaxes 1,100.00 1,100.00 134.47 76.91 0.00 965.53 122 522.102 VOT Pension Contributions 6,600.00 6,600.00 876.29 500.74 0.00 5,723.71 13.3 523.101 LifelHealth Insurance 6,100.00 5,400.00 84.96 20.38 0.00 5,315.04 1.6 523.105 HSA - HeaHh Savings AccouM 0.00 800.00 800.00 0.00 0.00 0.00 100.0 524.100 Workers' Comp Insurance 210.00 210.00 51.62 0.00 757.50 0.88 99.6 554.301 Personnel Training 5,000.00 5,000.00 0.00 0.00 0.00 5,000.00 0.0 Personal Services 94,910.00 94,990.00 13,544.48 6,265.26 157.50 81,288.02 14.4 Acct Class: 530 Operating ExpenditureslExpense 534.300 OtherContractualServices 20,000.00 20,000.00 3,148.42 3,000.00 75,000.00 1,851.58 90.7 534.303 Special Events 10,000.00 10,000.00 75.00 75.00 0.00 9,925.00 0.8 540.300 Travel 8 Per Diem 2,000.00 2,000.00 0.00 0.00 0.00 2,000.00 0.0 541.300 Communication Services 11,2IX1.00 11,200.00 4,627.73 4,587.72 0.00 6,572.27 41.3 541.301 Postage 3,400.00 3,400.00 104.60 104.60 0.00 3,295.40 3.1 541.305 Website Maintenance 7,750.00 7,750.00 202.74 202.74 1,650.00 5,89726 23.9 543.300 Utility Services 14,000.00 14,000.00 2,069.23 2,043.29 0.00 11,930.77 14.8 544.301 Operating Leases 5,620.00 5,620.00 534.78 405.93 4,860.63 224.59 96.0 545.3001nsurance 50,580.00 50,580.00 14,075.83 0.00 36,402.75 101.42 99.8 546.301 Office EquiplRepair 8 Maint 2,000.00 2,000.00 139.17 139.17 0.00 1,860.83 7.0 546.310 Equipment Repair & Maint 1,000.00 1,000.00 240.00 240.00 0.00 760.00 24.0 546.320 Computer system ma1�t & suppli 13,300.00 13,300•00 4,041.23 321.27 0.00 9,258•77 30.4 547.300 PriMing & Binding 1,000.00 1,000.00 0.00 0.00 0.00 1,000.00 0.0 549.300 Other Misc Chgs & Obligations 8,000.00 8,000.00 81.64 81.64 0.00 7,918.36 1.0 549.302 Vllage Newsletter 18,200.00 18,200.00 3,640.00 3,640.00 0.00 14,560.00 20.0 549.304 Licenses, Fees & Pertnits 2,650.00 2,650.00 1,338.80 1,338.80 0.00 1,31120 50.5 551.300 Office Supplies & Equipment 4,000.00 4,000.00 773.36 760.37 0.00 3,226.64 19.3 552.160 IT Operating Supplies 400.00 400.00 0.00 0.00 0.00 400.00 0.0 552.301 Gas & Oil 600.00 600.00 0.00 0.00 0.00 600.00 0.0 552.302 Small Tools and Equipment 1,500.00 1,500.00 0.00 0.00 0.00 1,500.00 0.0 REVENUEIEXPENDITURE REPORT as of November 30, 2012 Page: 8 1214/2012 Village of Tequesta 4:55 pm For the Period: 10/1/2012 to 1 t13012012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001 - General Fund Expendi��es Fundion: 410 General Govemment Dept: 160 Ger�eral Govemment Acct Class: 530 Operating Expenditures/Expense 554.300 Books, Publ, Subs & A4embership 4,500.00 4,500.00 2,095.01 1,486.66 0.00 2,404.99 46.6 Operating Expenditu2slExpense 181,700.00 181,700.00 37,187.54 t8,427.19 57,913.38 86,599.08 52.3 Acct Class: 600 Capital Outlay 664.601 Computer Equipment 0.00 5,801.00 5,800.01 0.00 0.00 0.99 100.0 Capital0utlay 0.00 5,801.00 5,800.01 0.00 0.00 0.99 100.0 General Govemment 276,610.00 282,491.00 56,532.03 24,692.45 58,070.88 167,888.09 40.6 GeneralGovemment 1,546,545.00 1,547,542.00 225,87523 115,003.60 186,421.56 1,135,245.21 26.6 Function: 420 PuWic Safety Dept: 175 Police Department Acct Class: 510 Personal Services 512.171 Sal&Wages-Adminshation 180,500.00 180,500.00 17,914.97 10,157.48 0.00 162,585.03 9.9 512.172 Reg Sal 8 Wages - Communicatio 199,200.00 199,200.00 32,307.09 18,743.86 0.00 166,892.91 162 512.175 Reg Sal 8 Wages - Operations 1,027,900.00 992,900.00 103,723.88 60,545.56 0.00 889,176.12 10.4 514.172 OverBme - Communications 17,000.00 17,000.00 9,623.72 5,794.46 0.00 7,376.28 56.6 514.175 Overtime - Operations 70,000.00 70,000.00 13,731.97 9,488.82 0.00 56,268.03 19.6 515.101 Holiday Pay 48,900.00 48,900.00 2,941.91 2,941.91 0.00 45,958.09 6.0 515.103 Bonus Pay Plan 8,250.00 8,250.00 4,750.00 1,250.00 0.00 3,500.00 57.6 515.106 Clothing & Boot Allowance 16,500.00 16,500.00 6,386.95 0.00 0.00 10,113.05 38.7 515.172 PIT Salary - Communications 6,200.00 6,200.00 630.45 67.95 0.00 5,569.55 10.2 515.175 P/TSalary-Operafions 100,400.00 109,271.00 21,141.96 12,841.46 0.00 88,129.04 19.3 516.100 Compensated Absences 76,300.00 43,598.00 38,254.75 0.00 0.00 5,343.25 87.7 521.101 FICA Taues 102,200.00 102,200.00 12,861.72 7,228.79 0.00 89,33828 12.6 521.102 Medica�eTaxes 23,900.00 23,900.00 3,007.96 1,690.61 0.00 20,892.04 12.6 522.101 FRS Contributions 46,500.00 46,500.00 5,873.64 3,549.74 0.00 40,626.36 12.6 522.102 VOT Pension Contribu6ons 178,900.00 178,900.00 21,552.55 12,169.73 0.00 157,347.45 12.0 522.110 Other Pension Contributions 56,470.00 56,470.00 0.00 0.00 0.00 56,470.00 0.0 523.101 L'rfelHealth Insurance 297,100.00 281,100.00 1,874.86 611.28 0.00 279,225.14 0.7 523.105 HSA - HeaHh Savings Account 0.00 29,400.00 15,900.00 0.00 0.00 13,5Q0.00 54.1 524.100 Workers' Comp Insurance 37,950.00 37,950.00 9,482.50 0.00 28,462.50 5.00 100.0 526.101 Employee Recognitlon Program 1,000.00 1,000.00 0.00 0.00 0.00 1,000.00 0.0 526.105 Employee PhysicaUPsycological 6,000.00 6,000.00 0.00 0.00 0.00 6,000.00 0.0 554.301 Personnel Training 10,500.00 10,500.00 1,500.00 900.00 0.00 9,000.00 14.3 Personal Services 2,511,670.00 2,466,239.00 323,460.88 147,981.65 28,462.50 2,114,315.62 14.3 Acct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 15,000.00 15,000.00 1,514.46 1,328.78 0.00 13,485.54 10.1 531.320 Code Eniorcement Service 4,000.00 4,000.00 0.� 0.00 0.00 4,000.00 0.0 540.300 Travel 8 Per Diem 9,650.00 9,650.00 2,81929 2,224.60 0.00 6,830.71 29.2 541.300 Communication Services 25,000.00 25,000.00 1,495.93 1,495.93 0.00 23,504.07 6.0 541.301 Postage 2,000.00 2,000.00 0.00 0.00 0.00 2,000.00 0.0 543.300 U61ityServices 26,000.00 26,000.00 2,165.06 2,165.06 0.00 23,834.94 8.3 544.301 Operating Leases 2,500.00 2,500.00 0.00 0.00 1,995.60 504.40 79.8 545.3001nsurance 43,280.00 43,280.00 11,391.02 0.00 31,906.25 -17.27 100.0 546.30� Office EquiplRepair& Maint 1,000.00 1,000.00 30.45 30.45 0.00 969.55 3.0 546.302 Vehicle Repair 6 Maintenance 35,000.00 35,000.00 1,882.58 1,192.87 0.00 33,117.42 5.4 546.303 Building Repair 8 Maint 15,000.00 15,000.00 716.74 716.74 0.00 14,283.26 4.8 546.304 Communication Equip Maint 16,000.00 16,000.00 874.80 874.80 12,172.80 2,952.40 81.5 546.310 Equipment Repair 8 Maint 7,700.00 7,700.00 537.50 537.50 0.00 7,162.50 7.0 546.320 Computer system maiM & suppli 52,800.00 52,800.00 29,800.18 26,926.26 0.00 22,999.82 56.4 547.300 Printing & Binding 2,500.00 2,500.00 0.00 0.00 0.00 2,500.00 0.0 549.300 Other Misc Chgs & Oblgations 5,500.00 5,500.00 9.99 9.99 0.00 5,490.01 0.2 549.303 Investigative Expenses 1,100.00 1,100.00 230.85 230.85 0.00 869.15 21.0 549.304 Licenses, Fees & Permits 1,500.00 1,500.00 1,338.78 1,338.78 0.00 161.22 89.3 549.311 Marine Unft Operatans 3,000.00 3,000.00 220.00 0.00 0.00 2,780.Op 7.3 549.314 K.E.Y.S. Program 2,500.00 2,500.00 0.00 0.00 0.00 2,500.00 0.0 REVENUEIFJ(PENDITURE REPORT as of November 30, 2012 Page: 9 12I4I2012 Village of Tequesta 4 pm For the Period: t011/2012 to 11I30I2012 Oripinal Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: IXl1 - General Fund Expenditu2s Function: 420 PuWic Safety Dept: 175 Police Department Acct Class: 530 Opera6ng FxpenditureslExpense 551.300 Office Supplies 6 Equipment 5,000.00 5,000.00 329.43 329.43 0.00 4,670.51 6.6 551.301 Crime P2vention Supplies 4,000.00 4,000.00 0.00 0.00 0.00 4,000.00 0.0 552.301 Gas & Oil 60,000.00 60,000.00 5,332.00 5,332.00 0.00 54,668.00 8.9 552.302 Small Tools and Equipment 9,050.00 9,050.00 1,743.18 1,743.18 0.00 7,306.82 19.3 552.305 Uniforms 20,500.00 20,500.00 203.79 30.00 0.00 20,29621 1.0 554.300 Books, Publ, Subs & Membership 4,500.00 4,500.00 406.40 98.10 0.00 4,093.60 9.0 Operating ExpenditureslExpense 374,080.00 374,080.00 63,042.43 46,605.32 46,074.65 264,962.92 29.2 Acct Class: 6IXl CapiNal Outlay 664.600 MadUEquipment 0.00 26,129.00 0.00 0.00 26,128.75 025 100.0 664.602 Vehicles 40,000.00 40,000.00 0.00 0.00 27,584.00 12,416.00 69.0 Capital0utlay 40,000.00 66,129.00 0.00 0.00 53,712.75 12,416.25 81.2 Police DepaAment 2,925,750.00 2,906,448.00 386,503.31 194,586.97 128,249.90 2,391,694.79 17.7 Dept: 1 BO Building & Zoning Acct Class: 510 Personal Services 512.1� Regular Salaries & Wages 123,200.00 123,200.00 16,489.89 9,422.80 0.00 106,710.11 13.4 515.107 Part-time Salaries 29,300.00 29,300.00 3,808.00 2,176.00 0.00 25,492.00 13.0 516.100 Compensated Absences 4,100.00 1,490.00 1,489.94 0.00 0.00 0.06 100.0 521.101 FICA Taxes 9,500.00 9,500.00 1,251.09 715.43 0.00 8,248.91 13.2 521.102 Medica�e Tazes 2,300.00 2,300.00 292.59 167.32 0.00 2,OQ7.41 12.7 522.101 FRS ContribuUons 4,100.00 4,100.00 540.26 308.72 0.00 3,559.74 13.2 522.102 VOT Pension Contribu6ons 4,300.00 4,300.00 568.47 324.84 0.00 3,731.53 13.2 523.101 LifelHeafth Insurance 15,000.00 15,100.00 190.65 67.92 0.00 14,909.35 1.3 523.105 HSA - Healih Savings Account 0.00 1,000.00 1,000.00 0.00 0.00 0.00 100.0 524.100 Workers' Comp Insurance 380.00 380.00 93.33 0.00 285.00 1.67 99.6 554.301 Personnel Training 1,500.00 1,500.00 0.00 0.00 0.00 1,500.00 0.0 PersonalServices 193,680.00 192,170.00 25,72422 13,183.03 285.00 166,160.78 13.5 Acct Class: 530 Operating ExpenditureslExpense 531.325 Inspection Senrices 113,000.00 113,000.00 10,545.00 10,545.00 102,455.00 0.00 100.0 534.300 OtherContractualServices 11,500.00 11,500.00 0.00 0.00 0.00 11,500.00 0.0 540.300 Travel 6 Per Diem 2,240.00 2,240.00 0.00 0.00 0.00 2,240.00 0.0 541.300 Communica6on Services 3,240.00 3,240.00 98.10 52.38 0.00 3,141.90 3.0 541.301 Postage 1,020.00 1,020.00 0.00 0.00 O.W 1,020.00 0.0 543.300 Utiliry Services 5,500.00 5,500.00 69.22 69.22 0.00 5,430.78 1.3 544.301 OperatingLeases 1,910.00 1,910.00 317.14 158.57 1,744.27 -151.41 1W.9 546.301 Office EquiplRepair & Maint 1,000.00 1,000.00 96.78 96.78 0.00 90.3.22 9.7 546.320 Computer system maint & suppli 5,200.00 5,200.00 1,718.05 1,249.67 0.00 3,481.95 33.0 547.300 PriMing & Binding 1,000.00 1,000.00 0.00 0.00 0.00 1,000.00 0.0 549.300 Other Misc Chgs 8 Obligffiions 6�.00 600.00 27.50 27.50 0.00 572.50 4.6 549.304 Licenses, Fees & Pertnits 1,400.00 1,400.00 1,338.78 1,338.78 0.00 61.22 95.6 551.300 �ce Supplies 8 Equipment 2,540.00 2,540.00 595.91 595.91 0.� 1,944.09 23.5 554.300 Books, Publ, Subs 8 Membership 1,250.00 1,250.00 900.00 900.00 0.00 350.00 72.0 Operating Expend'RureslExpense 151,400.00 151,400.00 15,706.48 15,033.81 104,199.27 31,494.25 792 Building & Zoning 345,OB0.00 343,570.00 41,430.70 28,216.84 104,48427 197,655.03 42.5 Dept: 192 Fire Control Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 1,430,900.00 1,430,900.00 192,815.30 106,093.61 0.00 1,238,084.70 13.5 514.100 Overtime 50,000.00 50,000.00 6,410.03 5,462.91 0.00 43,589.97 12.8 514.300 Overtime-Training 19,890.00 19,890.00 7,340.47 1,340.47 0.00 18,549.53 6.7 515.101 Holiday Pay 49,800.00 49,800.00 4,119.76 4,119.76 0.00 45,68024 8.3 515.107 Part-6me Salaries 49,8IX1.00 49,800.00 5,355.93 3,105.39 0.00 44,444.07 10.8 515.110 Intem Fire Fighter Pay 72,100.00 67,310.00 7,798.37 3,964.54 0.00 59,511.63 11.6 515.120 Cell phone allowance 1,2W.00 1,200.00 200.00 100.00 0.00 1,000.00 16.7 REVENUFJFXPENDITURE REPORT as of November 30, 2012 Page: 10 12/4I2012 Village of Tequesta 4:55 pm For the Period: 10I1I2012 to 11I30I2012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001 - General Fund Expenditures Function: 420 Public Safety Dept: 192 Fire Control Acct Class: 510 Personal Services 516.100 Compensated Absences 67,700.00 30,360.00 27,681.87 2,988.74 0.00 2,678.13 912 521.101 FICA Taxes 102,800.00 102,800.00 12,767.21 7,375.47 0.00 90,032.79 12.4 521.102 MedicareTaxes 24,100.00 24,100.00 2,985.84 1,724.87 0.00 21,114.16 12.4 522.102 VOT Pension ConfibuGons 337,900.00 337,900.00 45,568.92 25,891.23 0.00 292,331.08 13.5 522.110 Other Pension Contributions 154,700.00 154,700.00 0.00 0.00 0.00 154,700.00 0.0 523.101 LifelHeaRh Insurance 235,700.00 208,900.00 1,887.01 645.24 0.00 207,012.99 0.9 523.105 HSA - Health Savings AcxouM 0.00 25,300.00 23,300.00 2,700.00 0.00 2,000.00 92.1 524.100 Workers' Comp Insurance 55,970.00 55,970.00 13,990.71 0.00 41,977.50 1.79 100.0 526.101 Employee Recognition Program 1,605.00 1,605.00 0.00 0.00 0.00 1,60.5.00 0.0 526.103 Education Reimbursement Prgm 10,000.00 10,000.00 0.00 0.00 0.00 10,000.00 0.0 526.105 Employee PhysicallPsycological 9,870.00 9,870.00 0.00 0.00 8,627.43 1,242.57 87.4 554.301 Personnel Training 9,070.00 9,070.00 0.00 0.00 0.00 9,070.00 0.0 Personal Services 2,683,105.00 2,639,475.00 346,221.42 165,592.23 50,604.93 2,242,648.65 15.0 Acct Class: 530 Operating EupenditureslExpense 531.318 VoluMeer Fire Fighter Program 8,930.00 8,930.00 0.00 0.00 0.00 8,930.00 0.0 540.300 Travel & Per Diem 6,100.00 6,100.00 0.00 0.00 0.00 6,100.00 0.0 541.300 Communica6on Services 15,460.00 15,460.00 639.11 290.36 0.00 14,820.89 4.1 541.301 Postage 1,500.00 1,500.00 0.00 0.00 0.00 1,500.00 0.0 543.300 Utility Services 28,760.00 28,760.00 2,625.61 2,825.61 0.00 25,934.39 9.8 544.301 Operating Leases 7,740.00 7,740.00 650.34 548.17 4,906.00 2,183.66 71.8 545.3001nsurance 21,550.00 24,065.00 8,582.82 2,500.00 15,481.50 0.68 100.0 546.302 Vehicle Repair 8 MaiMenance 9,500.00 9,500.00 2,22429 2,164.57 0.00 7,275.71 23.4 546.303 Building Repair & MaiM 25,610.00 25,610.00 1,070.45 534.50 0.00 24,539.55 4.2 546.310 Equipment Repair & Maint 21,720.00 21,720.00 1,286.42 421.42 3,95325 16,480.33 24.1 546.320 Computer system maiM 8 suppli 18,000.00 18,000.00 4,146.35 625.80 0.00 13,853.65 23.0 547.300 Printing & Bindin9 920.00 920.00 0.00 0.00 0.00 920.00 0.0 549.300 Other Misc Chgs & Obliga6ons 2,600.00 2,600.00 266.00 226.75 0.00 2,334.00 102 549.304 Licenses, Fces & Permits 17,010.00 18,485.00 6,497.73 4,058.43 10,526.85 1,460.42 92.1 549.311 Marine Unit Opera6ons 5,480.00 5,480.00 220.00 0,00 0.00 5,260.00 4.0 551.300 Office Supplies 8 Equipment 2,790.00 2,790.00 282.27 270.77 0.00 2,507.73 10.1 551.302 Fire Prevention Education 2,310.00 2,310.00 0.00 0.00 0.00 2,310.00 0.0 552.301 Gas & Oil 20,000.00 20,000.00 825.34 237.37 0.00 19,174.66 4.1 552.304 Chemicals 990.00 990.00 0.00 0.00 0.00 990.00 0.0 552.305 Unitorms 23,310.00 23,310.00 1,018.13 1,018.13 5,253.00 17,038.87 26.9 552.308 Safety Supplies 22,840.00 22,840.00 0.00 0.00 0.00 22,840.00 0.0 552.310 Disaster Relief Supplies 5,500.00 5,500.00 0.00 0.00 0.00 5,500.00 0.0 552.311 CPR Program Supplies 340.00 340.00 210.00 210.00 0.00 130.IXI 61.8 552.312 Medical Supplies 37,170.00 37,170.00 3,999.41 2,865.41 0.00 33,170.59 10.8 552.344 FireStationSupplies 1,260.00 2,060.00 1,107.96 1,092.13 0.00 952.04 53.8 554.300 Books, Publ, Subs & Membership 2,750.00 2,750.00 1,197.62 330.02 0.00 1,552.38 43.5 Operating ExpenditureslExpense 310,140.00 314,930.00 37,049.85 20,219.44 40,120.60 237,759.55 24.5 Acct Class: 600 Capital Outlay 664.600 MachlEquipment 7,500.00 7,500.00 0.00 0.00 0.00 7,500.00 0.0 Capital0uday 7,500.00 7,500.00 0.00 0.00 0.00 7,500.00 0.0 FireControl 3,000,745.00 2,961,905.00 383,271.27 185,731.67 90,725.53 2,487,908.20 16.0 PublicSafety 6,271,575.00 6,211,923.00 811,20528 408,535.48 323,459.70 5,077,258.02 18.3 Func6on: 431 Transportation Depi: 210 Public Works Acct Class: 510 Personal Services 512.100 Regular Salaries 6 Wages 177,700.00 177,700.00 23,813.33 13,519.99 0.00 153,886.67 13.4 514.100 Overtime 1,000.00 1,000.00 180.00 180.00 0.00 820.00 18.0 575.106 Clothing & Boot Allowance 500.00 500.00 400.00 0.00 0.00 100.00 80.0 515.107 PaA-time Salaries 18,900.00 18,900.00 0.00 0.00 0.00 16,900.00 0.0 516.100 Compensated Absences 11,600.00 0.00 0.00 0.00 0.00 0.00 0.0 REVENUElEXPENDITURE REPORT as of November 30, 2012 Page: 11 12I4I2012 Village of Tequesia 4:55 pm For Yhe Period: 10It12012 to 17I30/2012 Oriainal Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001 - General Fund Expendih�2s Function: 431 Transportation Dept 210 Public Works Acct Class: 510 Personal Services 521.101 FICATaxes 11,700.00 11,700.00 1,311.33 749.44 0.00 10,388.67 11.2 521.102 Medicare Taxes 2,800.00 2,800.00 306.68 175.27 0.00 2,493.32 11.0 522.101 FRS Contributions 4,100.00 4,100.00 547.51 308.32 0.00 3,552.49 13.4 522.102 VOT Pension Contribu6ons 9,800.00 9,800.00 1,284.15 733.80 0.00 8,515.85 13.1 523.101 LifelHeafth Insurance 58,200.00 68,400.00 349.40 135.84 0.00 68,050.60 0.5 524.100 Workers' Comp Insurance 10,880.00 10,880.00 2,719.32 0.00 8,160.00 0.68 100.0 Personal Services 307,180.00 305,780.00 30,911.72 15,802.66 8,160.00 266,70628 72.8 Acct Class: 530 Operating ExpendftureslExpense 531.302 Engineering Services 2,000.00 2,000.00 0.00 0.00 0.00 2,000.00 0.0 534.300 Other Contractual Services 2,000.00 2,000.00 0.00 0.00 0.00 2,000.00 0.0 540.300 Travel 8 Per Diem 250.00 250.00 0.00 0.00 0.00 250.00 0.0 541.300 Communication Services 4,000.00 4,000.00 129.08 129.08 0.00 3,870,92 3.2 543.300 Utility Services 90,000.00 90,000.00 16,143.16 16,143.16 0.00 73,856.84 17.9 543.301 StreetLights 110,000.00 110,000.00 1,824.75 1,824.75 0.00 108,175.25 1.7 544.301 Operating Leases 1,200.00 1,200.00 0.00 0.00 1,125.24 74.76 93.8 544.304 FEC Lease 14,000.00 14,000.00 8,662.43 0.00 0.00 5,337.57 61.9 545.300Insurance 10,800.00 10,800.00 5,198.00 2,500.00 8,094.00 -2,492.00 123.1 546200 R�M - Sta6on 11 2,000.00 2,000.00 385.00 0.00 0.00 1,615.00 19.3 546.301 Office EquiplRepair & Maint 200.00 200.00 0.00 0.00 0.00 200.00 0.0 546.302 Vehicle Repair & Maintenance 4,000.00 4,000.00 212.02 27.45 0.00 3,787.98 5.3 546.303 Building Repair8 Maint 8,000.00 8,000.00 1,184.47 1,034.47 0.00 6,815.53 14.8 546.305 Pathway Maintenance 15,000.00 15,000.00 0.00 0.00 0.00 15,000.00 0.0 546.306 General Maintenance 30,000.00 30,000.00 1,26528 846.35 0.00 28,734.72 4.2 546.309 Landscape & Irrigatbn Maint 130,000.00 130,000.00 10,967.26 6,929.38 18,180.00 100,852.74 22.4 546.310 Equipment Repair & Maint 6,000.00 11,OOO.UO 865.60 242.� 5,000.00 5,134.40 53.3 546.320 Computer system maint & suppli 1,020.00 1,020.00 98.74 21.42 0.00 921.26 9.7 546.350 R& M- Roads 20,000.00 20,000.00 15,780.00 15,780.00 0.00 4,220.00 78.9 549.300 Other Misc Chgs & Obligations 1,600.00 3,300.00 1,404.00 1,404.00 0.00 1,896.00 42.5 549.304 Licenses, Fees & Permits 4,500.00 4,500.00 1,95725 1,707.25 0.00 2,542.75 43.5 551.300 Office Supplies & Equipment 450.00 450.00 0.00 0.00 0.00 450.00 0.0 551.400 Janitorial Supplies 4,500.00 4,500.00 832.27 832.27 0.00 3,667.73 18.5 552.301 Gas 8 Oil 6,000.00 6,000.00 665.93 0.00 0.00 5,334.07 11.1 552.302 Small Tools and Equipment 1,500.00 1,500.00 15.29 15.29 0.00 1,484.71 1.0 552.305 Unifortns 2,000.00 2,000.00 444.70 0.00 0.00 1,555.30 22.2 553.301 Road Signs 2,000.00 2,000.00 0.00 0.00 0.00 2,000.00 0.0 563.600 Public Works Misc Projects 5,000.00 5,000.00 0.00 0.00 0.00 5,000.00 0.0 563.601 Streeiscape Trees 2,000.00 2,000.00 0.00 0.00 0.00 2,000.00 0.0 Operating ExpenditureslExpense 480,220.00 486,720.00 68,03523 49,436.95 32,399.24 386,285.53 20.6 Public Works 787,400.00 792,500.00 98,946.95 65,239.61 40,559.24 652,993.81 17.6 Transportation 787,400.00 792,500.00 98,946.95 65,239.61 40,559.24 652,993.81 17.6 Function: 450 Leisure Services Dept 231 Leisure Services Acct Class: 510 Personal Services 512.100 Regular Salaries 8 Wages 159,700.00 159,700.00 21,374.86 12,214.21 0.00 138,325.14 13.4 515.106 Clothing & Boot Allowance 100.00 100.00 100.00 0.00 0.00 0.00 100.0 515.107 Part-time Salaries 45,000.00 45,000.00 5,086.04 2,920.65 0.00 39,913.96 11.3 515.108 Auto Allowance 3,000.00 3,000.00 500.00 250.00 0.00 2,500.00 16.7 515.109 Seasonal Salaries 8 Wages 30,000.00 30,000.00 0.00 0.00 0.00 30,000.00 0.0 516.100 Compensated Absences 13,800.00 6,606.00 3,105.96 0.00 0.00 3,500.04 47.0 521.101 FICATaxes 14,600.00 14,600.00 1,547.77 888.85 0.00 13,052.23 10.6 521.102 MedicareTaxes 3,500.00 3,500.00 361.97 207.88 0.00 3,138.03 10.3 522.102 VOT Pension CoMributions 15,100.00 15,100.00 2,004.95 1,145.69 0.00 13,095.05 13.3 523.101 L'rfelHealth Insurance 41,400.00 39,600.00 275.68 101.88 0.00 39,324.32 0.7 523.105 HSA - Healih Savings Account 0.00 3,400.00 3,400.00 0.00 0.00 0.00 100.0 524.100 Workers' Comp Insurance 8,190.00 8,190.00 2,046.05 0.00 6,142.50 1.45 100.0 REVENUEIEXPENDITURE REPORT as of November 30, 2012 Page: 12 12I4I2012 Village of Tequesta 4:55 pm For the Period: 10/1I2012 to 11I�I2012 Oriqinal Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001 - General Fund Expendi�res Function: 450 Leisure Services Dept 231 Leisure Services Acct Class: 510 Personal Services 526.105 Empbyee PhysicallPsycological 2,500.00 2,500.00 0.00 0.00 0.00 2,500.00 0.0 554.301 PersonnelTraining 1,200.00 1,200.00 0.00 0.00 0.00 1,200.00 0.0 Personal Services 338,090.00 332,496.00 39,803.28 17,729.16 6,14250 286,550.22 13.8 Acct Class: 530 Operating ExpendiWreslExpense 534.303 Special Events 79,000.00 79,000.00 68,59121 68,591.21 456.90 9,951.89 87.4 540.300 Travel & Per Diem 3,000.00 3,000.00 0.00 0.00 0.00 3,000.00 0.0 541.300 Communication Services 5,730.00 5,730.00 80.02 40.01 0.00 5,649.98 1.4 541.301 Postage 150.00 150.00 0.00 0.00 0.00 150.00 0.0 543.300 Utility Services 15,500.00 15,500.IX1 746.64 746.64 0.00 14,753.36 4.6 545.3001nsurance 12,500.00 12,500.00 3,723.80 0.00 9,372.00 420 100.0 546.302 Vehicle Repair8 Maintenance 1,800.IX1 1,800.00 100.00 100.00 0.00 1,700.00 5.6 546.303 Building Repair & MaiM 20,000.00 20,000.00 2,164.05 786.66 0.00 17,835.95 10.8 546.306 General Maintenance 30,000.00 30,000.00 3,336.81 3,336.81 0.00 26,663.19 11.1 546.310 EquipmentRepair&MaiM 1,700.00 1,700.00 0.00 0.00 0.00 1,700.00 0.0 546.320 Computersystemmaint8suppli 1,740.00 1,740.00 297.56 64.25 0.00 1,442.44 17.1 549.201 Advertising & Prortwtion 9,000.00 9,000.00 6,073.14 5,967.58 0.00 2,926.86 67.5 549.300 Other Misc Chgs & Obligations 5,000.00 5,000.00 0.00 0.00 0.00 5,000.00 0.0 549.304 Licenses, Fees & Permits 2,200.00 2,200.00 1,775.24 1,586.48 0.00 424.76 80.7 549.332 RecreaGon Program Expense 38,300.00 38,300.00 4,557.60 4,557.60 0.00 33,742.40 11.9 549.333 SpringlSummer Camp 16,000.00 16,000.00 0.00 0.00 0.00 16,000.00 0.0 551.300 Office Supplies 8 Equipment 2,000.00 2,000.00 837.28 5.96 0.00 1,162.72 41.9 551.315 Concession Supplies 5,000.00 5,000.00 823.37 823.37 0.00 4,176.63 16.5 552.301 Gas&Oil 1,200.00 1,200.00 154.88 0.00 0.00 1,045.12 12.9 552.302 Small Tools and Equipment 1,500.00 1,500.00 18.99 18.99 0.00 1,481.01 1.3 552.305 Uniforms 500.00 500.00 0.00 0.00 0.00 500.00 0.0 554.300 Books, Publ, Subs 8 Membership 500.00 500.00 137.50 0.00 0.00 362.50 27.5 Operating Expenditu�eslExpense 252,320.00 252,320.00 92,818.09 86,625.56 9,828.90 149,673.01 40.7 Leisure Services 590,410.00 584,816.00 132,621.37 104,354.72 15,971.40 436,223.23 25.4 Leisure Services 590,410.00 584,816.00 132,621.37 104,354.72 15,971.40 436,223.23 25.4 Function: 590 Other Nonoperating Dept: 700 Debt Service Acct Class: 471 DIS - Principal 571.706 PIS Prin - BOA - PIS Bldg 247,810.00 247,810.00 40,569.84 20,321.03 0.00 207,240.16 16.4 571.725 Prin - 2012 Ford Focus - Admin 4,315.00 4,315.00 712.37 360.03 3,600.26 2.37 99.9 571.726 Prin. - CTS Smart Cop Lease 53,870.00 53,870.00 0.00 0.00 0.00 53,870.00 0.0 D!S - Principal 305,995.00 305,995.00 41,28221 20,681.06 3,600.26 261,112.53 14.7 Acct Class: 472 D/5 - Interest 572.706 PIS - Int. BOA - P.S Bldg 124,700.00 124,700.00 21,513.74 10,720.76 0.00 103,186.26 17.3 572.725 Int. 2012 Forcl Focus - Admin 365.00 365.00 66.77 29.54 295.44 2.79 992 D/S-Interest 125,065.00 125,065.00 21,580.51 10,750.30 295.44 103,189.05 17.5 DebtService 431,060.00 431,060.00 62,862.72 31,431.36 3,895.70 364,301.58 15.5 Dept: 950 Other Nonoperating Acct Class: 590 Other Financing Sources & Uses 549.391 Bank Charges 12,000.00 12,000.00 1,553.66 841.69 0.00 10,446.34 12.9 549.395 Credit Card Fees and Charges 4,000.00 4,000.00 62.89 0.00 0.00 3,937.11 1.6 999.001 Suspense 0.00 0.00 224,794.74 224,794.74 0.00 -224,794.74 0.0 Other Financing Sources 8 Uses 16,000.00 16,000.00 226,41129 225,636.43 0.00 -210,411.29 1,415.1 Ofher Nonoperating 16,000.00 16,000.00 226,411.29 225,636.43 0.00 -210,411.29 1,415.1 REVENUEIEXPENDITURE REPatT as of November 30, 2012 Page: 13 12I4I2012 Village of Tequesta 4:55 pm For the Period: t01112012 to 11/30I2012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001- General Fund ExpendiWr�es Other Nonoperating 447,060.00 447,060.00 289,274.01 257,067.79 3,695.70 753,890.29 65.6 Expenditures 9,642,990.00 9,583,841.00 1,557,92284 950,201.20 570,307.60 7,455,610.56 22.2 Net Effect for General Fund 0.00 0.00 -638,928.68 -335,709.86 570,307.60 1,209,23628 0.0 Change in Fur�d Balance: -638,928.68 REVENUEIEXPENDITURE REPORT as of November 30, 2012 Page: 14 12/4/2012 Village of Tequesfa 4:55 pm For the Period: t01112012 to 11I30I2012 Oriainal Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 301 - Capital Improvement Fund Revenues Function: 590 Other Nonoperating Dept: 990 OthedReservelContingency Acet Class: 390 Other Finar�cing Souices 399.999 Appropriate Fund Balance 290,440.00 290,440.00 0.00 0.00 0.00 290,440.00 0.0 Other Financing Sources 290,440.00 290,440.00 0.00 0.00 0.00 290,440.00 0.0 OtheNReservelContingency 290,440.00 29Q,440.00 0.00 0.00 0.00 290,440.00 0.0 Other Nonoperating 290,440.00 290,440.00 0.00 0.00 0.00 290,440.00 0.0 Revenues 290,440.00 290,440.00 0.00 0.00 0.00 290,440.00 0.0 ExpendiW2s Function: 581 Other Financing Sources and Us Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 591.001 Transfer to General Fund 29p,440.00 290,440.00 0.00 0.00 0.00 290,440.00 0.0 Intertund Transfers Out 290,440.00 290,440.00 0.00 0.00 0.00 290,440.00 0.0 Intertund Transfers 290,440.00 290,440.00 0.00 0.00 0.00 290,440.00 0.0 Other Financing Sources and Us 290,440.00 290,440.00 0.00 0.00 0.00 290,440.00 0.0 Expenditures 290,440.00 290,440.00 0.00 0.00 0.00 290,440.00 0.0 NetEffectforCapitallmprovementFund 0.00 0.00 0.00 0.00 0.00 0.00 0.0 Change in Fund Balar�ce: -638,928.88 REVENUEIEXPENDITURE REPORT as of November 30, 2012 Page: 15 12I4I2012 Village of Tequesfa 4:55 pm For the Period: 10I1I2012 to 11/30/2012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 303 - Capital Projects Fund Revenues Function: 590 Other Nonoperating Dept 990 OtheNReserve/Contingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 112,000.00 112,000.00 0.00 0.00 0.00 112,000.00 0.0 Other Financing Souices 112,000.00 112,000.00 0.00 0.00 0.00 112,000.00 0.0 OthedReservelContingency 112,000.00 112,000.00 0.00 0.00 0.00 112,000.00 0.0 Other Nonoperating 112,000.00 112,000.00 0.00 0.00 0.00 112,000.00 0.0 Revenues 112,000.00 112,000.00 0.00 0.00 0.00 112,000.00 0.0 Expenditures Function: 581 Other Financing Sources and Us Dept: 900 Interfund Transfers Acct Class: 591 Interfund Transfers Out 591.001 Transfer to General Fund 112,000.00 112,000.00 0.00 0.00 0.00 112,000.00 0.0 Interfund Transfers Out 112,000.00 112,000.00 0.00 0.00 O.OQ 112,000.00 0.0 Interfund Transfers 112,000.00 112,000.00 0.00 0.00 0.00 112,000.00 0.0 Other Finanang Sources and Us 112,000.00 112,000.00 0.00 0.00 0.00. 112,000.00 0.0 Expenditures 112,000.00 112,000.00 0.00 0.00 0.00 112,000.00 0.0 Net Eifect for Capital Projects Fund 0.00 0.00 0.00 0.00 0.00 0.00 0.0 Change in Fund Balance: -638,928.68 REVENUFJEXPENDITURE REPORT as of November 30, 2012 Page: 16 12/4I2012 �Ilage of Tequ 4:55 pm For the Period: t01112012 to 11/30/2012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 401 - Water Fund Revenues Function: 000 General Revenues Dept: 000 General Acct Class: 340 Charges for Services 342.501 Site Plan Review Fees 600.00 600.00 0.00 0.00 0.00 600.00 0.0 343.301 Water Sales 2,354,000.00 2,354,000.00 195,323.47 190,355.87 0.00 2,158,676.53 8.3 343.302 Water- Connect Charges 13,500.00 13,500.00 3,933.65 1,928.59 0.00 9,566.35 29.1 343.303 Water-Fire Hydranis Rent 63,500.00 63,500.00 10,705.47 5,353.27 0.00 52,794.53 16.9 343.304 WaterSurchaige 405,000.00 405,000.00 56,375.84 29,665.00 0.00 348,624.16 13.9 343.306 MonthlyServiceCharge 1,350,000.00 1,350,000.00 233,023.40 116,551.02 0.00 1,116,976.60 17.3 343.307 Penalty Charges 4,200.00 4,200.00 755.40 371.65 0.00 3,444.60 18.0 343.308 Other Water Service Income 1,8W.IX1 1,800.00 135.00 80.00 0.00 1,665.00 7.5 343.309 Convenience Fee - CC 0.00 0.00 217.25 0.00 0.00 -21725 0.0 343.700 Water Conservation fl Resouice 500.00 500.00 4,339.37 4,339.37 0.00 -3,839.37 867.9 ChargesforServices 4,193,100.00 4,193,100.00 504,808.85 348,644.77 0.00 3,688,291.15 12.0 Acct Class: 369 Miscellaneous Revenues 363.101 MaRiNTropic V-Const portion 19,000.00 19,000.00 0.00 0.00 0.00 19,000.00 0.0 369.100 Insurance Reimbursement 4,000.00 4,000.00 0.00 0.00 0.00 4,000.00 0.0 Miscellaneous Revenues 23,000.00 23,000.00 0.00 0.00 0.00 23,000.00 0.0 Acct Class: 390 Other Finanang Sou�es 369.110 Capital Connect Cha�ge - Cust 18,000.00 18,000.00 0.00 0.00 0.00 18,000.00 0.0 369.111 Capital Connect Charge - Devel 10,000.00 10,000.00 10,709.29 3,604.13 0.00 -709.29 107.1 369.712 Capital Connect - Tropic Vist 18,000.00 18,000.00 0.00 0.00 0.00 18,000.00 0.0 Other Financin9 Sources 46,000.00 46,000.00 10,709.29 3,604.13 0.00 35,290.71 23.3 General 4,262,100.00 4,262,100.00 515,518.14 352,248.90 0.00 3,746,561.86 12.1 General Revenues 4,262,100.00 4,262,100.00 515,518.14 352,248.90 0.00 3,746,581.86 12.1 Function: 590 Other Nonoperadng Dept: 950 Other Norroperating Acct Class: 361 Un2stricted Investment Eamin 361.100 InteresUlnvestrnent Eamings 7,500.00 7,500.00 1,045.78 199.44 0.00 6,454.22 13.9 367.100 Net Unreal appreciation (Dep) 0.00 0.00 822.58 0.00 0.00 -822.58 0.0 UnresUic�d Investment Eamin 7,500.00 7,500.00 1,868.36 199.44 0.00 5,631.64 24.9 Other Nonope2dng 7,500.00 7,500.00 1,868.36 199.44 0.00 5,631.64 24.9 Dept 990 Other/ReservelContingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 177,209.00 239,580•00 0.00 0.00 0.00 239,580.00 0.0 Other Financing Sources 177,209.00 239,580.00 0.00 0.00 0.00 239,580.00 0.0 OthedReservelConGngency 177,209.00 239,580.00 0.00 0.00 0.00 239,580.00 0.0 Other Nonoperating 184,709.00 247,080.00 1,868.36 199.44 0.00 245,211.64 0.8 Revenues 4,446,809.Q0 4,509,180.00 517,386.50 352,448.34 0.00 3,991,793.50 11.5 Expenditures Function: 533 Water Utility Services Dept: 241 Waler-Administration Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 140,900.00 140,900.00 18,89522 10,782.99 0.00 122,004.78 13.4 515.108 AuMAllowance 3,000.00 3,000.00 500.00 250.00 0.00 2,500.00 16.7 516.100 Compensated Absences 8,500.00 8,430.00 3,430.08 0.00 0.00 4,999.92 40.7 521.101 FICA Taxes 7,100.00 7,100.00 477.91 273.13 0.00 fi,622.09 6.7 521.102 Medicare Taxes 2,200.00 2,200.00 295.88 168.67 0.00 1,904.12 13.4 522.102 VOT Pension ContribuGons 13,200.00 13,200.00 1,753.60 1,002.06 0.00 11,446.40 13.3 REVENUEIEXPENDITURE REPORT as of November 30, 2012 Page: 77 1?14I2012 Village of Tequesfa 4:55 pm For the Period: 10/1I2012 to 1 1 /3 01201 2 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 401 - Wffier Fund Expendih�res Function: 533 Water Ufility Services Dept: 241 Water-Administration Acct Class: 510 Personal Services 523.101 L'rfeMealth Insurance 10,800.00 9,500.00 115.96 42.45 0.00 9,384.04 1.2 523.105 HSA - HeaNh Savings AccouM 0.00 1,400.00 1,400.00 0.00 0.00 0.00 100.0 524.1 QO Workers' Comp Insurance 420.00 420.00 102.71 0.00 315.00 2.29 99.5 526.104 ICMA-Def Comp Plan 9,900.00 9,900.00 1,317.72 752:98 0.00 8,582.28 13.3 Personal Services 196,020.00 196,050.00 28,289.08 13,272.28 315.00 167,445.92 14.6 Acct Class: 530 Operating ExpenditureslE�cpense 531.301 Legal Services 7,500.00 7,500.00 0.00 0.00 0.00 7,500.00 0.0 531.302 Engineering Services 25,000.00 25,000.00 0.00 0.00 0.00 25,000.00 0.0 532.300 Acxoundng 8 Auditing Services 29,500.00 29,500.00 5,122.00 5,122.00 22,378.00 2,000.00 93.2 534.300 Other Contractual Services 18,000.00 21,850.00 3,000.00 3,000.00 18,850.00 0.00 100.0 544.304 FEC Lease 12,900.00 12,900.00 4,W1.04 0.00 0.00 8,828.96 31.6 545.3001nsurar�ce 49,6�.00 49,630.00 13,497.05 0.00 36,154.50 -21.55 100.0 549.301 Admin Mgmt Fees 485,229.00 485,229.00 80,871.50 40,435.75 0.00 404,357.50 16.7 549.304 Licenses, Fees & Permits 800.00 800.00 781.00 0.00 0.00 19.00 97.6 Operating Expenditu2slExpense 628,559.00 632,409.00 107,342.59 48,557.75 77,382.50 447,683.91 292 Water-Administratlon 824,579.00 828,459.00 135,631.67 61,830.03 77,697.50 615,129.83 25.8 Dept 242 Water- Production Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 400,100.00 400,100.00 41,395.80 24,055.18 0.00 358,704.20 10.3 514.100 OverUme 5,500.00 5,500.00 161.24 161.24 0.00 5,338.76 2.9 515.102 Standby Pay 5,000.00 5,000.00 758.65 419.68 0.00 4,241.35 152 515.106 Clothing & Boot Allowance 600.00 600.00 0.00 0.00 0.00 600.00 0.0 516.100 Compensated Absences 17,600.00 5,000.00 0.00 0.00 0.00 5,000.00 0.0 521.101 FICATaxes 25,500.00 25,500.00 2,590.06 1,510.68 0.00 22,909.94 10.2 521.102 Medicare Taxes 6,000.00 6,000.00 605.73 353.30 0.00 5,394.27 10.1 522.101 FRS Contributions 8,100.00 8,100.00 466.93 266.82 0.00 7,633.07 5.8 522.102 VOT Pension ContribuGons 22,800.00 22,800.00 2,998.07 1,733.88 0.00 19,601.93 13.1 523.101 LifelHealth Insurance 71,300.00 58,500.00 547.01 203.76 0.00 57,952.99 0.9 523.105 HSA - HeaHh Savings Aawunt 0.00 1,700.00 0.00 0.00 0.00 1,700.00 0.0 523.110 Retlree Health Care Expense 5,000.00 5,000.00 0.00 0.00 0.00 5,000.00 0.0 524.100 Workers' Comp Insurance 11,280.00 11,280.00 2,817.52 0.00 8,460.00 2.48 100.0 554.301 Personnel Training 1,500.00 1,500.00 0.00 0.00 0.00 1,500.00 0.0 Personal Services 580,280.00 556,580.00 52,341.01 28,704.54 8,460.00 495,778.99 10.9 AcctClass: 530 OperatingExpenditures/Expense 531.342 WalerAnalysis & Sampling 44,130.00 44,130.00 2,299.80 2,299.80 0.00 41,83020 5.2 540.300 Travel 8 Per Diem 3,000.00 3,000.00 23.20 23.20 0.00 2,976.80 0.8 541.300 Communication Services 9,400.00 9,400.00 280.88 280.88 0.00 9,119.12 3.0 541.301 Postage 1,500.00 1,500.00 0.00 0.00 0.00 1,500.00 0.0 543.300 UUIityServices 420,000.00 420,000.00 30,174.41 30,174.41 0.00 389,825.59 7.2 544.301 Operating Leases 9,000.00 9,000.00 750.00 0.00 8,25Q.00 0.00 100.0 546.302 Vehicle Repair & Maintenance 3,000.00 3,000.00 711.09 24.45 0.00 2,288.91 23.7 546.303 Bui�ing Repair& Maint 9,500.00 9,500.00 1,209.52 1,089.52 0.00 8,290.48 12.7 546.309 landscape 8lrrigation Maint 3,000.00 3,000.00 814.11 686.94 0.00 2,185.89 27.1 , 546.310 EquipmentRepair&Maint 18,000.00 18,000.00 1,159.28 871.28 0.00 16,840.72 6.4 546.320 Computersystemmaint&suppli 2,500.00 2,500.00 2,503.69 1,573.60 0.00 -3.69 100.1 546.342 Water System Maintenance 60,0�.00 60,000.00 14,524.75 9,353.45 0.00 45,475.25 242 546.343 Well Redevelopment 25,000.00 25,000.00 0.00 0.00 0.00 25,000.00 0.0 549.300 Other Misc Chgs & Obligations 2,000.00 2,000.00 0.00 0.00 0.00 2,000.00 0.0 549.304 Licenses, Fees 8 Permits 30,000.00 �,000.00 10,111.95 4,299.45 0.00 19,888.05 337 551.300 Office Supplies & Equipment 2,500.00 2,500.00 448.32 375.34 0.00 2,051.68 17.9 552.301 Gas & Oil 8,100.00 8,100.00 815.47 0.00 0.00 7,284.53 10.1 552.302 Small Tools and Equipment 3,000.00 3,000.00 0.00 0.00 0.00 3,000.00 Q.0 552.303 Diesel Fuel 15,000.00 15,000.00 0.00 0.00 0.00 15,000.00 0.0 552.305 Uniforms 1,200.00 1,200.00 1,203.89 1,203.89 0.00 -3.89 100.3 552.341 Water Purchases 30,000.00 30,000.00 0.00 0.00 0.00 30,000.00 0.0 REVENUE�XPEND�URE REPORT as of November 30, 2012 Page: 18 12I42012 �Ilage of Tequesta 4:55 pm For the Period: 10I1I2012 to 11I30I2012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 401 - Water Fund Expenditures Function: 533 Water Utility Services Dept 242 Water- Production Acct Class: 530 Operaating ExpenditureslExpense 552.342 Water Chemicals 235,000.00 235,000.00 6,288.49 3,733.63 9,104.00 219,607.51 6.5 552.343 Laboratory Supplies 13,000.00 13,000.00 985.06 640.56 0.00 12,014.94 7.6 554.300 Books, Publ, Subs 8 Membership 1,500.00 1,500.00 627.47 354.00 0.00 872.53 41.8 OperaUng Expenditu2slExpense 949,330.00 949,330.00 74,931.38 56,984.40 17,354.00 857,044.62 9.7 Water- Production 1,529,610.00 1,505,910.00 127,272.39 85,688.94 25,814.00 1,352,823.61 10.2 Dept: 243 Water-Distribution Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 408,500.00 408,500.00 55,040.20 31,624.77 0.00 353,459.80 13.5 514.100 Overtime 6,200•00 6,200.00 262.89 104.19 0.00 5,937.11 42 515.102 Sfandby Pay 6,800.00 6,800.00 1,000.63 527.04 0.00 5,799.37 14.7 515.106 Clothing 8 Boot Allowance 600.00 600.00 600.00 0.00 0.00 0.00 100.0 515.107 Part-time Salaries 42,600.00 42,600.00 5,999.18 3,535.35 0.00 36,600.82 14.1 515.108 Auto Allowance 4,800.00 4,800.00 800.00 400.00 0.00 4,000.00 16.7 516.100 Compensated Absences 20,300.00 2,500.00 0.00 0.00 0.00 2,500.00 0.0 521.101 FICATaxes 28,900.00 28,900.00 3,81320 2,181.74 0.00 25,086.80 13.2 521.102 Medicare Taxes 6,800.00 6,800.00 891.80 510.25 0.00 5,908.20 13.1 572.101 FRS Contributions 7,200.00 7,200.00 945.01 534.38 0.00 6,254.99 13.1 522.102 VOT Pension Contributions 26,200.00 26,200.00 3,472.07 1,984•OS 0.00 22,727.93 13.3 523.101 LifelHealth Insurance 77,800.00 83,000.00 692.83 254.70 0.00 82,307.17 0.8 523.105 HSA - Health Savings Accoum 0.00 2,700.00 2,700.00 0.00 0.00 0.00 100.0 523.110 Re6ree Health Care Expense 5,000.00 5,000.00 0.00 0.00 0.00 5,000.00 0.0 524.100 Workers' Comp Insurance 10,920.00 10,920.00 2,729.26 0.00 8,190.00 0.74 100.0 554.301 PersonnelTraining 1,500.00 1,500.00 0.00 0.00 0.00 1,500.00 0.0 Personal Services 654,12(1.00 644,220.00 78,947.W 41,656.47 8,190.00 557,082.93 13.5 Acct Class: 530 Operating ExpenditureslExpense 540.300 Travel & Per Diem 500.00 500.00 0.00 0.00 0.00 500.00 0.0 541.300 CommunicaGon Senices 7,680.00 7,680.00 175.29 135.28 0.00 7,504.71 2.3 541.301 Postage 23,000.00 23,000.00 0.00 0.00 0.00 23,000.00 0.0 54t.301 Operating Leases 4,500.00 4,500.00 0.00 0.00 3,120.84 1,379.16 69.4 546.301 Office Equip/Repair & Maint 200.00 200.00 9.19 9.19 0.00 190.81 4.6 546.302 Vehicle Repair 8 Maintenance 7,000.00 7,000.00 54.90 27.45 0.00 6,945.10 0.8 546.303 Building Repair 8 Maint 4,000.00 4,000.00 40.00 40.00 0.00 3,960.00 1.0 546.309 Landscape & Irtigation Maint 900.00 900.00 350.00 350.00 0.00 550.00 38.9 546.310 Equipment Repair 8 MaiM 5,000.00 5,000.00 662.23 192.65 0.00 4,337.77 132 546.320 Computer system maiM 8 suppli 6,920.00 6,920.00 3,705.46 223.45 0.00 3,214.54 53.5 546.342 WaterSystemMaintenance 24,000.00 24,000.00 4,829.41 4,717.73 0.00 19,170.59 20.1 546.344 New Service Connection Expense 1,000.00 1,000.00 0.00 0.00 0.00 1,000.00 0.0 547.300 Prin6ng 8 Binding 3,000.00 3,000.00 0.00 0.00 0.00 3,000.00 0.0 549.300 Other Misc Chgs & Obligafions 2,500.00 2,500.00 378.45 378.45 0.00 2,121.55 15.1 549.304 Licenses, Fees 8 Permits 1,700.00 1,700.00 1,181.62 1,181.62 0.00 518.38 69.5 551.300 Office Supplies 8 Equipment 1,500.00 1,500.00 752.48 752.48 0.00 747.52 502 552.301 Gas 8 Oil 19,000.00 19,000.00 1,342.62 0.00 0.00 17,657.38 7.1 552.302 Small Tools and Equipment 3,000.00 3,000.00 1,452.25 236.79 0.00 1,547.75 48.4 552.305 Unifortns 2,400.00 2,400.00 798.05 131.00 0.00 1,601.95 33.3 Operatin9 ExpenditureslExpense 117,800.00 117,800.00 15,731.95 8,376.09 3,120.84 98,947.21 16.0 Water-Distribution 771,920.00 762,020.00 94,679.02 50,032.56 11,310.84 656,030.14 13.9 Dept: 411 Renewal 8 ReplacemeM Acct Class: 530 Operating ExpenditureslExpense 546.605 R&M - WeII Site Rehab 4,000.00 4,000.00 0.00 0.00 0.00 4,000.00 0.0 549.671 Misc. Renewal 8 Replacement 37,300.00 37,300.00 2,818.08 2,257.64 0.00 34,481.92 7.6 552.601 Meters, Valves & Hydrants 25,000.00 25,000.00 1,425.00 1,425.00 10,326.00 13,249.00 47.0 552.603 Filter Cartridgeslf20P 7,000.00 7,000.00 0.00 0.00 0.00 7,000.00 0.0 REVENUEIEXPENDITURE REPORT as of November 30, 2012 Page: 19 1214/2012 Vill of T equesta 4: 55 pm For the Period: 10/1I2012 to 11130I2012 Oriuinal Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 401 - Water Fund Expenditu2s Function: 533 Water Utility Services Dept: 411 Renewal & ReplacemeM Operatlng ExpenditureslExpense 73,300.00 73,3W.00 4,243.08 3,682.64 10,326.00 58,730.92 19.9 Aat Class: 600 Capital Outlay 663.671 Misc. Renewel and Replacement 575,000.00 585,200.00 0.00 0.00 10,200.00 575,000.00 1.7 664.602 Vehicles 26,000.00 26,000.00 0.00 0.00 24,472.00 1,528.00 94.1 Capihal0utlay 601,000.00 611,200.00 0.00 0.00 34,672.00 576,528.00 5.7 Renewal & Replacement 674,300.00 684,500.00 4,243.08 3,682.64 44,998.00 635,258.92 7.2 Dept: 412 Capital Improvement Acct Class: 600 Capital OuBay 664.600 MachlEquipment 0.00 81,891.00 22,155.00 22,155.00 59,405.38 330.62 99.6 Capital0utlay 0.00 81,891.00 22,155.00 22,155.00 59,405.38 330.62 99.6 Capitallmp�ovement 0.00 81,891.00 22,155.00 22,155.00 59,405.38 330.62 99.6 Water Utility Services 3,800,409.00 3,862,780.00 383,981.16 223,389.17 219,225.72 3,259,573.12 15.6 Function: 590 Other Nonoperating Dept: 700 Debt Service Acct Class: 471 DIS - Principal 571.705 Prin - 2004 Water NIP BOA 29,000.00 29,000.00 0.00 0.00 0.00 29,000.00 0.0 571.720 Prin - 2IX18 Water Utility Note 267,250.00 267,250.00 43,416.18 21,708.09 0.00 723,833.82 162 D/S-Principal 296,250.00 296,250.00 43,416.18 21,708.09 0.00 252,833.82 14.7 Acct Class: 472 D5 - Interest 572.705 Int - 2004 Water N/P BOA 14,800.00 14,800.00 1,289.57 0.00 0.00 13,510.43 8.7 572.720 Int - 2008 Water Utility Note 202,400.00 202,400.00 17,501.70 17,501.70 0.00 184,898.30 8.6 573700 Other Debt Service Costs 25,000.00 25,000.00 O.W 0.00 0.00 25,000.00 0.0 D!S-Interest 242,200.00 242,200.00 18,79127 17,501.70 0.00 223,408.73 7.8 Debt Service 538,450.00 538,450.00 62,207.45 39,209.79 0.00 476,242.55 11.6 Dept 950 Other Nonoperating Acct Class: 530 Operating ExpenditureslExpense 559.301 Budgeted Depreciation (nelted) 95,950.00 95,950.00 0.00 0.00 0.00 95,950.00 0.0 Operating ExpenditureslExpense 95,950.00 95,950.00 0.00 0.00 0.00 95,950.00 0.0 Acct Class: 590 Other Financing Sources 8 Uses 549.391 Bank Charges 10,000.00 10,000.00 1,520.65 825.19 0.00 8,479.35 15.2 549.395 Credft Card Fees and Chaiges 2,000.00 2,000.00 30525 0.00 0.00 1,694.75 15.3 OYher Financing Sources & Uses 12,000.00 12,000.00 1,825.90 625.19 0.00 10,174.10 152 OtherNonoperating 107,950.00 1W,950.00 1,825.90 825.19 0.00 106,124.10 1.7 Other Nonoperating 646,400.00 646,400.00 64,033.35 40,034.96 0.00 582,366.65 9.9 Expenditures 4,446,809.00 4,509,180.00 448,014.51 263,424.15 219,225.72 3,841,939.77 14.8 Net Effect Tor Water Fund 0.00 0.00 69,371.99 89,024.19 219,225.72 149,853.73 0.0 Change in Fund Balance: 69,371.99 REVENUEIEXPENDITURE REPORT as of November 30, 2012 Page: 20 1214/2012 Village of Tequesta 4:55 pm For the Period: 1011/2012 to 11I30I2012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 402 - Refuse & Recyding Revenues Function: 000 General Revenues Dept 000 Genera! Acct Class: 335 IntergovemmeMal Revenue 336.110 Recycling Shared Rev - SWA 7,500.00 7,500.00 0.00 0.00 0.00 7,500.00 0.0 Intergovemmental Revenue 7,500.00 7,500.00 0.00 0.00 0.00 7,500.00 0.0 Acct Class: 340 Charges for Services 343.400 Refuse I Recycling Fees 472,410.00 472,410.00 42,165.34 42,101.34 0.00 430,244.66 8.9 ChargesforServices 472,410.00 472,410.00 42,165.34 42,101.34 0.00 430,244.66 8.9 Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 4,670.00 4,670.00 0.00 0.00 0.00 4,670.00 0.0 Other Financing Sources 4,670.00 4,670.00 0.00 0.00 0.00 4,670.00 0.0 General 484,580.00 484,580.00 42,165.34 42,101.34 0.00 442,414.66 8.7 General Revenues 484,580.00 484,580.00 42,165.34 42,101.34 0.00 442,414.66 8.7 Function: 590 Other Nonoperating Dept 950 OtherNonoperaUng Acct Class: 361 Unrestricted Investr�nt Eamin 361.100 InteresHlnvestrnent Eamirgs 200.00 200.00 27.67 13.29 0.00 172.33 13.8 361.101 PBC Tax Col-Interest on Dep 100.00 100.00 0.00 0.00 0.00 100.00 0.0 367.100 Net Unieal appreciffiion (Dep) 300.00 300.00 4722 0.00 0.00 252.78 15.7 Unrestricted Investment Eamin 600.00 600.00 74.89 13.29 0.00 525.11 12.5 Other Nonoperating 600.00 600.00 74.89 13.29 0.00 525.11 12.5 Other NonoperaGng 600.00 600.00 74.89 13.29 0.00 525.17 12.5 Revenues 485,180.00 485,180.00 42,240.23 42,114.63 0.00 442,939.77 8,7 Expenditures Function: 534 Refuse & Recycling Dept 245 Refuse and Recycling Acct Class: 530 Operadng FxpenditureslExpense 531.301 Legal Services 500.00 500.00 0.00 0.00 0.00 500.00 0.0 543.302 Solid WastelResidential 248,860.00 248,860.00 20,729.52 20,729.52 0.00 228,130.48 8.3 543.303 Recyclirg/Residentlal 87,770.00 87,770.00 7,325.71 7,325.71 0.00 80,44429 8.3 543,304 Yard W�telResidenlial 82,700.00 82,700.00 6,877.85 6,677.85 0.00 75,8T2.15 8.3 543.306 Fuel Factor 57,750.00 57,750.00 4,830.49 4,830.49 0.00 52,919.51 8.4 549.300 Other Misc Chgs & Obligations 750.00 750.00 0.00 0.00 0.00 750.00 0.0 549.301 Admin Mgmt Fees 6,850.00 6,850.00 1,741.66 570.83 0.00 5,708.34 16.7 Operating Expendituresl6cpense 485,180.00 485,180.00 40,90523 40,334.40 0.00 444,274.77 8.4 Refuse and Recycling 485,180.00 485,180.00 40,905.23 40,334.40 0.00 444,274.77 8.4 Retuse & Recycling 485,180.00 465,180.00 40,905.23 40,334.40 0.00 444,274.77 8.4 Expenditures 485,180.00 485,180.00 40,905.23 40,334.40 0.00 444,274.77 8.4 Net Effed for ReTuse & Recycling 0.00 0.00 1,335.00 1,780.23 0.00 -1,335.00 0.0 Change in Fund Balance: 1,335.00 REVENUEIEXPENDITURE REPORT as of November 30, 2012 Page: 21 12I4I2012 Village of Tequesfa 4:55 pm For tlie Period: 1011I2012 to 11/30I2012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 403 - Stormwater Utility Revenues Function: 000 GeneralRevenues Dept: 000 General Acct Class: 340 Charges for Services 343.901 Stortn Water Utiliry Fees 318,000.00 318,000.00 26,708.55 26,708.55 0.00 291,291.45 8.4 Charges for Services 318,000.00 318,000.00 26,708.55 26,708.55 0.00 291,291.45 8.4 General 318,000.00 318,000.00 26,708.55 26,708.55 0.00 291,291.45 8.4 General Revenues 318,000.00 318,000.00 26,708.55 26,708.55 0.00 291,291.45 8.4 Function: 590 Other Nonoperating Dept: 950 Ofher Noraperating Acct Class: 361 Unrestricted Investment Eamin 361.1001nteresUlnvestrneniEamings 1,100.00 1,100.00 170.59 83.60 0.00 929.41 15.5 367.100 Net Unreal apprecia6on (Dep) 0.00 0.00 49.37 0.00 0.00 �9.37 0.0 Unrestricted Inves6ment Eamin 1,100.00 1,100.00 219.96 83.60 0.00 880.04 20.0 OtherNonoperating 1,100.00 1,100.00 219.96 83.60 0.00 880.04 20.0 Dept: 990 OthedReservelContingency Acct Class: 390 Other Financing Sources 399.999 Appropriate Fund Balance 0.00 215,042.00 0.00 0.00 0.00 215,042.00 0.0 Ofher Financing Sources 0.00 215,042.00 0.00 0.00 0.00 215,042.00 0.0 OthedReservelCor�tingency 0.00 215,042.00 0.00 0.00 0.00 215,042.00 0.0 OtherNonoperating 1,100.00 216,142.00 219.96 83.60 0.00 215,922.04 0.1 Revenues 319,100.00 534,142.00 26,928.51 26,792.15 0.00 507,213.49 5.0 6cpendih�res Fundion: 550 Stortnwater Dept 250 Stortn Wa�er Utilities Acct Class: 510 Personal Services 512.100 Regular Salaries & Wages 33,800.00 33,800.00 4,522.64 2,584.37 0.00 29,277.36 13.4 514.100 Overtime 1,000.00 1,000.00 96.92 48.46 0.00 903.08 9.7 515.102 Shandby Pay 1,400.00 1,400.00 193.83 129.22 0.00 1,206.17 13.8 515.106 Clothirg & Boot Allowance 100.00 100.00 100.00 0.00 0.00 0.00 100.0 516.100 Compensated Absences 3,600.00 0.00 0.00 0.00 0.00 0.00 0.0 521.101 FICATaxes 2,200.00 2,200.00 232.43 131.57 0.00 1,967.57 10.6 521.102 Medicare Taxes 500.00 500.00 54.36 30.77 0.00 445.64 10.9 522.102 VOT Pension Contributions 3,200.00 3,200.00 42423 242.42 0.00 2,775.77 13.3 523.101 LifelHealth Insurance 12,900.00 14,900.00 83.50 33.96 0.00 14,816.50 0.6 524.100 Workers' Comp Insurance 1,100.00 1,100.00 273.62 0.00 825.00 1.38 99.9 554.301 Personnel Training 500.00 500.00 0.00 0.00 0.00 500.00 0.0 Personal Services 60,300.00 58,700.00 5,981.53 3,200.77 825.00 51,893.47 11.6 Acct Class: 530 Operating ExpenditureslExpense 531.302 Engineering Services 5,000.00 5,000.00 0.00 0.00 0.00 5,000.00 0.0 532.300 Acxountlng & Auditing Services 4,100.00 4,100.00 717.08 717.08 3,132.92 250.00 93.9 540.300 Travel & Per Diem 300.00 300.00 7.47 7.47 0.00 292.53 2.5 541.300 CommunicaUon Services 1,750.00 1,750.00 44.00 44.00 0.00 1,706.00 2.5 541.301 Postage 300.00 300.00 0.00 0.00 0.00 300.00 0.0 546.302 Vehicle Repair 6 Maintenance 800.00 800.00 0.00 0.00 0.00 800.00 0.0 546.303 Building Repair 8 Maint 2,000.00 2,000.00 0.00 0.00 0.00 2,000.00 0.0 546.308 Drainage Maintenance 25,000.00 24,532.00 1,664.90 892.45 0.00 22,867.10 6.8 546.310 Equipment Repair & Maint 1,500.00 1,500.00 0.00 0.00 0.00 1,500.00 0.0 546.320 Computer system maint 8 suppli 700.00 700.00 99.57 21.42 0.00 600.43 14.2 549.300 Other Misc Chgs & Obligations 1,000.00 1,000.00 0.00 0.00 0.00 1,000.00 0.0 549.301 Admin Mgmt Fees 11,630.00 11,630.00 1,938.32 969.16 0.00 9,691.68 16.7 REVENUEIFJ(PENDITURE REPORT as of November 30, 2012 Page: 22 17J4/2012 Village of Tequesta 4:55 pm For the Period: 10I1I2012 to 11/30/2012 Oripinal Bud. Amended Bud. YTD Adual CURR MTH Encumb. YTD UnencBal % Bud Fund: 403 - Stormwater Utility Expenditu�es Function: 550 Sromiwater Dept: 250 Stortn Water Utilities Acct Class: 530 Operating ExpenditureslExpense 549.304 Licenses, Fees & Permits 3,500.00 3,968.00 3,958.62 3,958.62 0.00 9.38 99.8 551.300 Office Supplies & Equipment 300.00 300.00 0.00 0.00 0.00 300.00 0.0 552.301 Gas 6 Oil 3,000.00 3,000.00 223.65 0.00 0.00 2,776.35 7.5 552.302 Small Tools and Equipment 1,200.00 1,200.00 0.00 0.00 0.00 1,200.00 0.0 554.100 Public EducaGon Program 500.00 500.00 0.00 0.00 0.00 500.00 0.0 Operating ExpenditureslExpense 62,580.00 62,580.00 8,653.61 6,610.20 3,13292 50,793.47 18.8 Acct Class: 600 Capital Outlay 662.632ArchitectBEngeering 0.00 6,171.00 4,202.20 4,202.20 1,968.53 027 100.0 663.663 Drainage Improvements 0.00 208,871.00 102,660.93 102,660.93 106,209.17 0.90 100.0 Capital0utlay 0.00 215,042.00 106,863.13 106,863.13 108,177.70 1.17 100.0 S1ortnWaterUtiY6es 122,880.00 336,322.00 121,498.27 116,674.10 112,135.62 102,688.11 69.5 SOormwater 122,880.00 336,322.00 121,498.27 116,674.10 112,135.62 102,688.11 69.5 Function: 590 Other Nonoperating Dept 950 OtherNonopera6ng Acct Class: 530 Operating Fxpenditures/Expense 559.301 Budgeted Depreciation (netted) 110,950.00 110,950.00 0.00 0.00 0.00 110,950.00 0.0 Operating ExpenditureslExpense 110,950.00 110,950.00 0.00 0.00 0.00 110,950.00 0.0 Acct Class: 590 Other Financing Sources 8 Uses 590.001 Allocate to Fund Balance 85,270.00 86,870.00 0.00 0.00 0.00 86,870.00 0.0 Other Financing Sources & Uses 85,270.00 86,870.00 0.00 0.00 0.00 86,870.00 0.0 Other Nonoperating 196,220.00 197,820.00 0.00 0.00 0.00 197,820.00 0.0 Other Nonoperating 196,220.00 197,820.00 0.00 0.00 0.00 197,820.00 0.0 ExpendiWres 319,1IX1.00 534,142.00 121,498.27 116,674.10 112,135.62 300,508.11 43.7 Net Effect for Stormwater Utility 0.00 0.00 -94,569.76 -89,881.95 112,135.62 206,705.38 0.0 Change in FurM Balance: -94,56976 Grand To�l Net EtEect: 0.00 0.00 -662,791.45 -334,787.39 901,668.94 1,564,460.39