Loading...
HomeMy WebLinkAboutHandouts_Workshop_Tab 03_11/05/2012 � (���YI � �� � .: � � �� �.�*'�'� � � '! � k � - j¢ � 9 5:. "" <. . �""'. �i.r�� � j�. 1'1N:1NC:�: DL;I'11Ri�RiENT DATE: NOVEMBER 5, 2012 �- TO: MICHAEL R. COUZZO, VILLAGE MANAGER FROM: JOANN FORSYTHE, FINANCE DIItECTOR RE: FY - REVENUE & EXPENDITURES — DRAFT 11-5-2012 Below is an overview of the financial results of the Village as of 11-5-2012: GENERAL FUND #001 Revenues: Budget to actual revenues in the General Fund, removing the effects of appropriations and transfers in, are; Original Budget Amended Bud�et YTD Actual $8,676,999 $8,919,678 $8,903,677 Expenditures• $9,266,559 9 620 972 9 484 387 Diff 89 �� 580 710 The funding for the differences above was made up of transfers- in of $251,300 and General fund appropriations ($338,260;$449,994; $329,410). Revenues: Some items to note: Revenues that were higher than budget ($10,000 +); Sales and use taxes $23,861 Police Impact fees $10,625 Fire Plan Review Fees $44,173 EMS Transports fees $36,223 Unrestricted Invest Inc (SBA) $10,724 Misc (settlement - unbudgeted) $22,001 ��s-�a 11 / 5 / 124:46 PM ��1'Yl. � � 1 Revenues that were less than budget ($10,000 +): Building Permits $70,463 Fire Insurance Premium Ta�c 26,594 Spring Summer Camp fees 19,126 Exnenditures• Overall, expenditures in the general fund were 98.7% of budget. The legal department (140) was in excess of the budget (-$20,219). At this time there are no additional appropriations being requested for the General fund in FY 2012, however, there are inter-departmental budget amendments that will be brought before the Village Council at the November 8` Regular Council meeting for their approval. Confidential 2 , REVENUEIEXPENDITURE REPORT • FY 2012 Page: 1 11/5I2012 Village of Tequesta 4:46 pm For the Period: 101112011 to 9l3012012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001 - General Fund Revenues Function: 000 General Revenues Dept: 000 General General Property Taxes 4,271,000.00 4,271,000.04 4,268,732.11 3,838.01 0.00 2,267.89 99.9 Sales & Use Taxes 1,027,500.00 1,027,500.00 1,051,360.89 154,984.00 0.00 -23,860.89 102.3 Franchise fees - gross receipt 390,000.00 390,000.00 355,069.58 34,000.52 0.00 34,930.42 91.0 Intragovemmental Revenue 334,659.00 503,163.00 503,163.00 196,392.25 0.00 0.00 100.0 IntergovemmentalRevenue 722,500.00 722,500.00 717,130.63 95,$77.38 0.00 5,369.37 99.3 Chgs for Serv - Gen Gov 8,650.00 5,650.00 14,164.92 798.70 0.00 -5,514.92 163.8 Unrestricted Investment Eamin 16,000.00 0.00 0.00 0.00 0.00 0.00 0.0 Rents & Royalties 162,190.00 162,190.00 160,993.33 12,581.14 0.00 1,196.67 99.3 Miscellaneous Revenues 24,500.00 24,500.00 39,923.21 1,996.62 0.00 -15,423.21 163.0 General 6,956,999.00 7,109,503.00 7,110,537.67 500,468.62 0.00 -1,034.67 100.0 General Revenues 6,956,999.00 7,109,503.00 7,110,537.67 500,468.62 0.00 -1,034.67 100.0 Function: 410 General Govemment Dept: 150 Comprehensive Planning ChargesforServices 64,100.00 64,100.00 64,116.27 745.00 0.00 -16.27 100.0 Miscellaneous Revenues 200.00 200.00 0.00 0.00 0,00 200.00 0.0 Comprehensive Planning 64,300.00 64,300.00 64,116.27 745.00 0.00 183.73 99.7 General Govemment 64,300.00 64,300.00 64,116.27 745.00 0.00 183.73 99.7 Function: 420 Public Safety Dept: 171 Police Sales & Use Taxes 0.00 56,467.00 56,A66,20 0.00 0.00 0.80 100.0 Licenses & Permits 6,100.00 6,100.00 5,607.50 75.00 0,00 492.50 91.9 Grants Federal 0.00 0.00 1,000.00 1,000.00 0.00 -1,000.00 0.0 Intergovemmental Revenue 38,000.00 38,000.00 31,274.49 0.00 0.00 6,725.51 82.3 Chgs for Serv - Public Safety 20,000.00 20,000.00 ti5,000.00 0.00 0.00 5,000.00 75.0 Fines & Forfeitures 20,800.00 20,800.00 20,792.95 1,932.32 0.00 7.05 100.0 Impact Fees 350.00 350.00 10,974.88 0.00 0.00 -10,624.88 3,135.7 Contributions & Donations 100.00 100.00 250.00 Q,00 0.00 -150.00 250.0 Miscellaneous Revenues 0.00 0.00 466.00 6.00 0.00 -466.00 0.0 ' REVENUEIEXPENDITURE REPORT ' FY 2012 Page: 2 11/5/2012 Village of Tequesta 4:46 pm For the Period: 10I112011 to 913012012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001- General Fund Revenues Function: 420 Public Safety Police 85,350.00 141,817.Op 941,832.02 2,953.32 0.00 -15.02 10p.0 Dept: 175 Police Department Miscellaneous Revenues 0.00 0.00 94.18 35.00 0.00 -94.18 0.0 Police Department 0.00 0.00 94.18 35.00 0.00 -94.18 0.0 Dept: 180 Building & Zoning Licenses & Permits 478,100.00 478,100.00 412,094.87 19,392.51 0.00 66,005.13 86.2 Miscellaneous Revenues 0.00 0.00 242.95 0.00 0.00 -242.95 0.0 Building & Zoning 478,100.00 478,100.00 412,337.82 19,392.51 0.00 65,762.18 86.2 Dept: 192 Fire Control Sales & Use Taxes 137,000.00 154,708.00 128,114.23 31,596.78 0.00 26,593.77 82.8 Intergovemmental Revenue 6,$40.00 6,840.00 4,680.00 0.00 0.00 2,160.00 68.4 Charges for Services 707,540.00 707,540.00 787,922.49 68,746.01 0.00 -80,382.49 111.4 Impact Fees 500.00 500.00 6,730.66 0.00 0.00 -6,230.661,346.1 Contributions & Donations 1,000.00 1,000.00 200.00 0.00 0.00 800.00 20.0 Miscellaneous Revenues 600.00 600.00 866.08 50.00 0.00 -266.08 144.3 Fire Control 853,480.00 871,188.Q0 928,513.46 100,392.79 0.00 57,325.46 106.6 Public Safety 1,416,930.00 1,491,105.00 1,482,777.48 122,773.62 0.00 8,327.52 99.4 Function: 450 Leisure Services Dept: 231 Leisure Services Charges for Services - Recr. 85,900.00 85,900.00 66,974.09 1,014.60 0.00 18,925.91 78.0 Rents & Royalties 3,000.00 3,000.00 6,642.45 288.86 0.00 -3,642.45 221.4 Impact Fees 0.00 0.00 551.20 0.00 0.00 -551.20 0.0 Contributions & Donations 7,000.00 7,000.00 6,294.00 0.00 0.00 706.00 89.9 Miscellaneous Revenues 7,000.00 7,000.00 4,748.13 0.00 0.00 2,251.87 67.8 Leisure Services 102,900.00 102,900.00 85,209.87 1,303.46 0.00 17,690.13 82.8 Leisure Seroices 1Q2,900.00 102,900.00 85,209.87 1,303.46 0.00 17,690.13 82.8 Function: 581 Other Financing Sources and Us Dept: 900 Interfund Transfers Transfers In 251,300.00 251,300.00 251,300.00 50,000.00 0.00 0.00 100.0 Interfund Transfers 251,300.00 251,300.00 251,300.00 50,000.00 0.00 0.00 100.0 Dept: 910 Other Financing Sources & Uses ' REVENUEIEXPENDITURE REPORT � FY 2012 Page: 3 11/5/2012 Village of Tequesta 4:46 pm For the Period: 10/1/2011 to 913012012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001- General Fund � Revenues Function: 581 Other Financing Sources and Us Dept: 910 Other Financing Sources & Uses Other Financing Sources 120,870.00 120,870.00 120,869.92 0.00 0.00 0.08 100.0 Other Financing Sources & Uses 120,870.00 120,870.00 120,869.92 0.00 0.00 0.08 100.0 Other Financing Sources and Us 372,170.00 372,170,00 372,169.92 50,000.00 0.00 0.08 100.0 Function: 590 Other Nonoperating Dept: 950 Other Nonoperating Unrestricted Investment Eamin 15,000.00 31,000.00 39,946.01 5,729.57 0.00 -8,946.01 128.9 OtherNonoperating 15,000.00 31,000.00 39,946.U1 5,729.57 0.00 -5,946.01 128.9 Dept: 990 OthedReservelContingency Other Financing Sources 338,260.00 449,994.00 0.00 0.00 0.00 449,994,00 0.0 OthedReseroelContingency 338,260.00 449,994.00 0.00 0.00 0.00 449,994.00 0.0 Other Nonoperating 353,260.00 480,994.00 39,946.01 5,729.57 0.00 441,047.99 8.3 Revenues 9,266,559.00 9,620,972.00 9,154,757.22 681,020.27 0.00 466,214.78 95.2 Expenditures Function: 410 General Govemment Dept: 100 Council Operating ExpenditureslExpense 28,950.00 30,550.00 31,411.56 1,463.34 0.00 -861.56 102.8 Council 28,950.00 30,550.00 31,411.56 1,463.34 0.00 -861.56 102.8 Dept: 110 Manager Personal Services 187,830.00 192,863.00 189,734.08 20,279.59 0.00 3,128.92 98.4 Operating Expenditures/Expense 4,600.00 3,536.00 2,872.40 0.00 0.00 663.60 81.2 Capital0utlay 0.00 1,031.00 1,030.70 0.00 0.00 0.30 100.0 Manager 192,430.00 197,430.00 193,637.18 20,279.59 0.00 3,792.82 98.1 Dept: 111 Human Resources Personal Services 143,690.00 144,843.00 143,206.09 12,902.31 0.00 1,636.91 98.9 Operating ExpenditureslExpense 4,500.00 8,747.00 8,323.27 4,788.01 0.00 423.73 95.2 Human Resources 148,190.00 153,590.00 151,529.36 17,690.32 0.00 2,060.64 98.7 Dept: 120 Village Clerk Personal Services 150,080.00 150,405.00 148,689.25 16,287.73 0.00 1,715.75 98.9 Operating ExpenditureslExpense 48,710.00 46,035.00 29,16021 5,223.41 0.00 16,874.79 63.3 Village Clerk 198,790.00 196,440.00 177,849.46 21,511.14 O.QO 18,590.54 90.5 Dept: 130 Finance Personal Seroices 337,690.00 337,690.00 318,750.18 31,118.60 0.00 18,939.82 94.4 ` REVENUEIEXPENDITURE REPORT � FY 2012 Page: 4 111512012 Village of Tequesta 4:46 pm For hhe Period: 10/1/2011 to 9I30/2012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001- General Fund Expenditures Function: 410 General Govemment Dept: 130 Finance Operating Expenditures/Expense 47,950.00 47,950.00 41,673.96 1,527.49 0.00 6,276.04 86.9 Finance 385,640.00 385,640.00 360,424.14 32,646.09 0.00 25,215.86 93.5 Dept: 140 Legal Operating Expenditures/Expense 95,000.00 95,000.00 115,219.25 25,169.67 0.00 -20,219.25 121.3 Legal 95,000.00 95,000.00 115,219.25 25,169.67 0.00 -20,219.25 121.3 Dept: 150 Comprehensive Planning OperaGng ExpenditureslExpense 121,570.00 144,316.00 142,127.93 20,092.00 0.00 2,188.07 98.5 Capital0utlay 0.00 1,151.00 1,150.19 0.00 0.00 0.81 99.9 Comprehensive Planning 121,570.00 145,467.00 143,278.12 20,092.00 0.00 2,188.88 98.5 Dept: 160 General Govemment Personal Services 107,530.00 109,646.00 112,818.31 13,994.45 0.00 -3,172.31 102.9 Operating ExpenditureslExpense 183,290.00 184,469.00 181,047.68 14,667.83 0.00 3,421.32 98.1 CapitalOuUay 37,133.00 38,433.00 32,155.92 4,298.00 5,800.01 477.07 98.8 General Government 327,953.00 332,548.00 326,021.91 32,960.28 5,800.01 726.08 99.8 General Govemment 1,498,523.00 1,536,665.00 1,499,370.98 171,812.43 5,800.01 31,494.01 98.0 Function: 420 Public Safety Dept: 171 Police Personal Services 201,260.00 0.00 Q.00 0.00 0.00 0.00 0.0 Operating ExpenditureslExpense 184,630.00 0.00 0.00 0.00 0.00 0.00 0.0 Police 385,890.00 0.00 0.00 0.00 0.00 0.00 0.0 Dept: 172 Police-Comm�nication Personal Services 363,170.00 0.00 0.00 0.00 0.00 0.00 0.0 Operating ExpenditureslExpense 18,050.00 0.00 0.00 0.00 0.00 0.00 0.0 Police-Communication 381,220.00 0.00 0.00 0.00 0.00 0.00 0.0 Dept: 175 Police Department Personal Services 1,733,870.00 2,448,997.00 2,448,146.23 182,689.95 0.00 850.77 100.0 Operating ExpenditureslExpense 165,190.00 374,077.00 375,106.19 47,376.51 0.00 -1,029.19 100.3 Capital0utlay 193,240.00 262,380.00 261,801.72 1,865.06 0.00 578.28 99.8 Police Department 2,092,300.00 3,085,454.00 3,085,054.14 231,931.52 0.00 399.86 100.0 Dept: 180 Building & Zoning Personal Services 154,200.00 162,871.00 160,940.84 16,990.81 0.00 1,930.16 98.8 ' REVENUEIEXPENOITURE REPORT � FY 2012 Page: 5 11/512012 Village of Tequesta 4:46 pm For the Period: 101112011 to 913012012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal °/a Bud Fund: 001 - General Fund Expenditures Function: 420 Public Safety Dept: 180 Building � Zoning Operating ExpenditureslExpense 111,820.00 125,122.00 120,468.65 16,363.59 0.00 4,653.35 96.3 Capital0utlay 0.00 1,151.00 1,150.19 0.00 0.00 0.81 99.9 Building & Zoning 266,020.00 289,144.00 282,559.68 33,354.40 0.00 6,584.32 97.7 Dept: 191 Civil Preparation Personal Services 350.00 0.00 0.00 0.00 0.00 0.00 0.0 Operating ExpenditureslExpense 13,970.00 0.00 0.00 0.00 0.00 0.00 0.0 Civil Preparation 14,320.00 0.00 0.00 0.00 0.00 0.00 0.0 Dept: 192 Fire Control Personal Services 2,521,710.00 2,550,379.00 2,544,218.26 223,899.76 0.00 6,160.74 99.8 Operating Expenditures/Expense 297,940.00 306,628.00 292,922.14 25,287.62 0.00 13,705.86 95.5 Fire Control 2,819,650.00 2,857,007.00 2,837,140.40 249,187.38 0.00 19,866.60 99.3 Public Safety 5,959,400.00 6,231,605.00 6,204,754.22 514,473.30 0.00 26,850.78 99.6 Function: 431 Transportation Dept: 210 Public Works Personal Services 287,870.00 287,870.00 268,3$8.91 22,803.94 0.00 19,481.09 93.2 Qperating ExpenditureslExpense 475,100.00 508,868.00 455,061.02 64,747.77 5,000.00 48,806.98 90.4 Capital0utlay 35,000.00 45,298.00 45,063.00 0.00 0.00 235.00 99.5 PublicWorks 797,970.00 842,036.00 768,512.93 87,551,71 5,000.00 68,523.07 91.9 Transportation 797,970.00 842,036.00 768,512.93 87,551.71 5,000.00 68,523.07 91.9 Function: 450 Leisure Services Dept: 231 Leisure Services Personal Services 306,270.00 314,714.00 308,073.63 26,672.11 0.00 6,640.37 97.9 Operating ExpenditureslExpense 268,320.00 259,876.00 243,928.11 13,637.55 0.00 15,947.89 93.9 Leisure Seroices 574,590.00 574,590.00 552,001.74 40,309.66 0.00 22,588.26 96.1 Leisure Services 574,590,00 574,590.00 552,001.74 40,309.66 0.00 22,588.26 96.1 Function: 590 Other Nonoperating Dept: 700 Debt Service DIS - Principal 286,791.00 286,791.00 285,310.79 20,176.84 0.00 1,480.21 99.5 DIS - Interest 137,285.00 137,285.00 137,027.30 10,864.95 0.00 257.70 99.8 Debt Service 424,076.00 424,076.00 422,338.09 31,041.79 0.00 1,737.91 99.6 Dept: 950 Other Nonoperating ' REVENUEIEXPENDITURE REPORT � FY 2012 Page: 6 111512012 Village of Tequesta 4:46 pm For the Period: 10I1I2011 to 913012012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001 - General Fund Expenditures Function: 590 Other Nonoperating Dept: 950 Other Nonoperating Other Financing Sources & Uses 12,000.00 12,000.00 37,491.27 28,471.35 0.00 -25,491.27 312.4 Other Nonoperating 12,000.00 12,000.00 37,491.27 28,471.35 0.00 -25,49127 312.4 Other Nonoperating 436,076.00 436,076.00 459,829.36 59,513.14 0.00 -23,753.36 105.4 Expenditures 9,266,559.00 9,620,972.00 9,484,469.23 873,660.24 10,800.01 125,702.76 98.7 Net Effect for General Fund 0.00 0.00 -329,712.01 -192,639.97 10,800.01 340,512.02 0.0 Change in Fund Balance: -329,712.01 REVENUEIEXPENDITURE REPORT � FY 2012 Page: 7 1115l2012 Village of Tequesta 4:46 pm For the Period: 10I112011 to 9I3012012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 301 - Capital Improvement Fund Revenues Function: 000 General Revenues Dept: 000 General Grants - State 48,000.00 48,000.00 0.00 0.00 0.00 48,000.00 0.0 Miscellaneous Revenues 0.00 0.00 153,471.85 -9,226.96 0.00 -153,471.85 0.0 General 48,000.00 48,000.00 153,471.85 -9,226.96 0.00 -105,471.85 319.7 General Revenues 48,000.00 48,000.00 153,471.85 -9,226.96 0.00 -105,471.85 319.7 Function: 590 Other Nonoperating Dept: 950 Other Nonoperating Unrestricted Investment Eamin 0.00 0.00 9,226.96 9,226.96 0.00 -9,226.96 0.0 Other Nonoperating 0.00 0.00 9,226.96 9,226.96 0.00 -9,226.96 0.0 Dept: 990 OthedReservelContingency Qther Financing Sources 201,300.00 201,300.00 0.00 0.00 0.00 201,300.00 0.0 OthedReservelContingency 201,300.00 201,300.00 0.00 0.00 0.00 201,300.00 0.0 Other Nonoperating 201,300.00 201,300.00 9,226.96 9,226.96 0.00 192,073.04 4.6 Revenues 249,300.00 249,300.00 162,698.81 0.00 0.00 86,601.19 65.3 Expenditures Function: 450 Leisure Seroices Dept: 399 Misc Proj-General CapitalOuUay 48,000.00 48,000.00 0.00 0.00 0.00 48,000.00 0.0 Misc Proj-General 48,000.00 48,000.00 0.00 0.00 0.00 48,000.00 0.0 Leisure Services 48,000.00 48,000.00 0.00 0.00 0.00 48,000.00 0.0 Function: 581 Other Financing Sources and Us Dept: 900 Interfund Transfers Interfund Transfers Out 201,300.Q0 201,300.00 201,300.00 0.00 0.00 0.00 100.0 Interfund Transfers 201,300.00 201,300.00 201,300.00 0.00 0.00 0.00 100.0 Other Financing Sources and Us 201,300.00 201,300.00 201,300.00 0.00 0.00 0.00 100.0 Expenditures 249,300.00 249,3Q0.00 201,300.00 0.00 0.00 48,000.00 80.7 Net Effect for Capital Improvement Fund 0.00 0.00 -38,601.19 0.00 0.00 38,601.19 0.0 Change in Fund Balance: -38,601.19 ' REVENUEIEXPENDITURE REPORT � FY 2012 Page: 8 111512012 Village of Tequesta 4:46 pm For the Period: 1011/2011 to 9/3012012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 401- Water Fund Revenues Function: 000 General Revenues Dept: 000 General Charges for Services 4,226,500.00 4,226,500.00 4,311,408.29 483,459.92 0.00 -84,908.29 102.0 Unrestricted Investment Eamin 8,000.00 0.00 0.00 0.00 0.00 0.00 0.0 Miscellaneous Revenues 21,400.00 21,400.00 30,802.04 -18,991.09 0.00 -9,402.04 143.9 Other Financing Sourc:es 37,080.00 37,080.00 125,550.16 23,157.30 0.00 -88,470.16 338.6 General 4,292,980.00 4,284,980.00 4,467,760.49 487,626.13 0.00 -182,780.49 104.3 General Revenues 4,292,980.00 4,284,980.00 4,467,760.49 487,626.13 0.00 -182,780.49 104.3 Function: 590 Other Nonoperating Dept: 950 Other Nonoperating Unrestricted Investment Eamin 0.00 8,000.00 26,930.46 3,840.62 0.00 -18,930.46 336.6 Other Nonoperating O.OQ 8,000.00 26,930.46 3,840.62 0.00 -18,930.46 336.6 Dept: 990 OthedReservelContingency Other Financing Sources 0.00 461,036.00 0.00 0.00 0.00 461,036.00 0.0 OthedReservelContingency 0.00 461,036.00 0.00 0.00 0.00 461,036.00 0.0 Other Nonoperating 0.00 469,036.00 26,930.46 3,840.62 0.00 442,105.54 5.7 Revenues 4,292,980.00 4,754,016.00 4,494,690.95 491,466.75 0.00 259,325.05 94.5 Expenditures Function: 533 Water Utility Services Dept: 241 Water-Administration Personal Services 166,910.00 172,005.00 170,134.57 19,645.18 0.00 1,870.43 98.9 Operating Expenditures/Expense 503,380.00 660,719.00 627,441.36 206,647.47 3,850.00 29,427.64 95.5 Water-Administration 670,290.00 832,724.00 797,575.93 226,292.65 3,850.00 31,298.07 96.2 Dept: 242 Water- Production Personal Services 548,830.00 557,007.00 541,575.39 37,774.74 0.00 15,431.61 97.2 Operating ExpenditureslExpense 953,200.00 943,722.00 749,438.45 74,218.34 0.00 194,283.55 79.4 Water- Production 1,502,030.00 1,500,729.00 1,291,013.84 111,993.08 0.00 209,715.16 86.0 Dept: 243 Water-Distribution Personal Services 591,910.00 596,168.00 583,171.62 56,681.61 0.00 12,996.38 97.8 Opera6ng ExpenditureslExpense 109,150.00 105,693.00 94,172.89 3,659.23 0.00 11,520.11 89.1 Water-Distribution 701,060.00 701,861.00 677,344.51 60,340.84 0.00 24,516.49 96.5 Dept: 411 Renewal & Replacement Opera6ng Expenditures/Expense 78,000.00 73,221.00 55,323.58 3,423.02 0.00 17,897.42 75.6 ' REVENUEIEXPENDITURE REPORT � FY 2012 Page: 9 111512012 Village of Tequesta 4:46 pm For the Period: 10/1l2011 to 913012012 Original Bud. Amended Bud. YTD Actual CURR MTH �ncumb. YTD UnencBal °� Bud Fund: 401 - Water Fund Expenditures Function: 533 Water Utility Services Dept: 411 Renewal & Replacement Capital0utlay 120,000.00 115,003.00 103,660.05 1,800.00 10,2�0.00 1,142.95 99.0 Renewal & Replacement 198,000.00 188,224.00 158,983.63 5,223.02 10,200.00 19,040.37 89.9 Dept: 412 Capital Improvement Capital0utlay 350,000.00 479,500.00 342,390.08 272,992.12 81,890.38 55,219.54 88.5 Capitallmprovement 350,000.00 479,500.00 342,390.08 272,992.12 81,890.38 55,219.54 88.5 Dept: 414 Capital Expansion Projects Capital0utlay 0.00 179,378.00 140,207.70 0.00 0.00 39,170.30 78.2 Capital Expansion Projects 0.00 179,378.00 140,207.70 0.00 0.00 39,170.30 78.2 Water Utility Services 3,421,380.00 3,882,416.00 3,407,515.69 676,841.71 95,940.38 378,959.93 90.2 Function: 590 Other Nonoperating Dept: 700 Debt Service DIS - Principal 282,900.00 282,900.00 0.00 -261,122.33 0.00 282,900.00 0.0 D/S - Interest 254,600.00 254,600.00 252,196.83 65,124.17 0.00 2,403.17 99.1 Debt Service 537,50Q.00 537,500.00 252,196.83 -195,998.16 0.00 285,303.17 46.9 Dept: 950 Other Nonoperating Operating ExpenditureslExpense 322,100.00 322,100.00 0.00 0.00 0.00 322,100.00 0.0 Other Financing Sources & Uses 12,000.00 12,000.00 9,643.38 804.99 0.00 2,356.62 80.4 OtherNonoperating 334,100.00 334,100.00 9,643.38 804.99 0.00 324,456.62 2.9 Other Nonoperating 871,600.00 871,600.00 261,840.21 -195,193.17 0.00 609,759.79 30.0 Expenditures 4,292,980.00 4,754,016.00 3,669,355.90 481,648.54 95,940.38 988,719.72 79.2 Net Effect for Water Fund 0.00 0.00 825,335.05 9,818.21 95,940.38 -729,394.67 0.0 Change in Fund Balance: 825,335.05 � REVENUEIEXPENDITURE REPORT � FY 2012 Page: 10 11I512012 Village of Tequesta 4:46 pm For the Period: 10I1I2011 to 9130/2012 Ori inal Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal °/a Bud Fund: 402 - Refuse & Recycling Revenues Function: 000 General Revenues Dept: 000 General Intergovemmental Revenue 0.00 0.00 13,943.60 2,384.76 0.00 -13,943.60 0.0 Charges for Services 474,535.00 474,535.00 473,448.36 2,989.87 0.00 1,086.64 99.8 Unrestricted Investment Eamin 320.00 0.00 0.00 0.00 0.00 0.00 0.0 General 474,855.00 474,535.00 487,391.96 5,374.63 0.00 -12,856.96 102.7 General Revenues 474,855.00 474,535.00 487,391.96 5,374.63 0.00 -12,856.96 102.7 Function: 590 Other Nonoperating Dept: 950 Other Nonoperating UnrestrictedlnvestmentEamin 500.OQ 820.00 1,305.07 186.03 0.00 -485.07 159.2 Other Nonoperating 500.00 820.00 1,305.07 186.03 0.00 1385.07 159.2 OtherNonoperating 500.00 82Q.00 1,305.07 186.03 0.00 �85.07 159.2 Revenues 475,355.00 475,355.00 488,697.03 5,560.66 0.00 -13,342.03 102.8 Expenditures Function: 534 Refuse & Recycling Dept: 245 Refuse and Recycling Operating ExpenditureslExpense 475,355.00 475,355.00 468,636.68 77,521.61 0.00 6,718.32 98.6 Refuse and Recycling 475,355.00 475,355.00 468,636.68 77,521.61 O.OQ 6,718.32 98.6 Refuse & RecyGing 475,355.00 475,355.00 468,636.68 77,521.61 0.00 6,718.32 98.6 Expenditures 475,355.00 475,355.00 468,636.68 77,521.61 0.00 6,718.32 98.6 Net Effect for Refuse & Recycling 0.00 0.00 20,060.35 -71,960.95 0.00 -20,060.35 0.0 Change in Fund Balance: 20,060.35 " REVENUEIEXPENDITURE REPORT � FY 2012 Page: 11 1115/2012 Village of Tequesta 4:46 pm For the Period: 101112011 to 9130/2012 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 403 - Stormwater Utility Revenues Function: 000 General Revenues Dept: 000 General Charges for Services 323,350.00 323,350.00 323,193.13 2,446.60 0,00 156.87 100.0 Unrestricted Investment Earnin 1,100.00 0.00 0.00 0.00 0.00 0.00 0.0 General 324,450.00 323,350.00 323,193.13 2,446.60 0.00 156.87 100.0 General Revenues 324,450.00 323,350.00 323,193.13 2,446.60 0.00 156.87 100.0 Function: 590 Other Nonoperating Dept: 950 Other Nonoperating Unrestricted Investment Eamin 0.00 1,100.00 2,211.73 263.83 0.00 -1,111.73 201.1 Other Nonoperating 0.00 1,100.00 2,211.73 263.83 0.00 -1,111.73 201.1 bept: 990 OthedReservelCon6ngency Other Financing Sources 258,130.00 339,863.00 0.00 0.00 0.00 339,863.00 0.0 OthedReserve/Contingency 258,130.00 339,863.00 0.00 0.00 0.00 339,863.00 0.0 Other Nonoperafing 258,130.00 340,963.00 2,211.73 263.83 0.00 338,751.27 0.6 Revenues 582,580.00 664,313.00 325,404.86 2,710.43 0.00 338,908.14 49.0 Expenditures Function: 550 Stormwater Dept: 250 Storm Water Utilities Personal Services 52,490.00 53,575.00 52,972.97 4,652.62 0.00 602.03 98.9 Opera6ng Expenditures/Expense 71,340.00 70,255.00 58,344.33 13,367.06 0.00 11,910.67 83.0 CapitalOuUay 340,000.00 421,733.00 206,611.44 123,026.15 215,040.83 80.73 100.0 Storm Water Utilities 463,830.00 545,563.00 317,928.74 141,045.83 215,040.63 12,593.43 97.7 Stormwater 463,830.00 545,563.00 317,928.74 141,045.83 215,040.83 12,593.43 97.7 Function: 590 Other Nonoperating Dept: 950 Other Nonoperating Opera6ng ExpenditureslExpense 118,750.00 118,750.00 0.00 0.00 0.00 118,750.00 0.0 Other Nonoperating 118,750.00 118,750.00 0.00 0.00 0.00 118,750.00 0.0 Other Nonoperating 118,750.OQ 118,750.00 0.00 0.00 0.00 118,750.00 0.0 Expenditures 582,580.00 664,313.00 317,928.74 141,045.83 215,040.83 131,343.43 80.2 Net Effect for Stormwater Utility 0.00 0.00 7,476.12 -138,335.40 215,040.83 207,564.71 0.0 Change in Fund Balance: 7,476.12 Grand Total Net Effect: 0.00 0.00 484,558.32 -393,118.11 321,781.22 -162,777.10