Loading...
HomeMy WebLinkAboutHandouts_Workshop_Tab 03_11/05/2012 (2) � . t � ; � � �, r , ...r"e� ,� ��s�"��,_�� ,.' ��ii'c��- � .; �raS � . t �._ - �� J � 4 . � �,,'; S _ _ .. ... . ......... . ._.__ _ _____. .._ ._ .. _ ._. _- . , _ _ . .. ,- ...,._.._ �, � . � _�'���,�,k - - � �?' � � r`�' � � 4 �� FINANC..F.., DEP.�1R':I'IVIF�i':I' DATE: NOVEMBER 2, 2012 TO: MICHAEL R. COUZZO, VILLAGE MANAGER FROM: JOANN FORSYTHE, FINANCE DIRECTOR RE: FY 2013 - REVENUE & EXPENDITURES - UPDATE Below is an update of the Revenue & Expenditures by Fund as of November 2, 2012: GENERAL FUND #001 Revenues: Overall revenues are as expected. Some items to note: • The first installment of Ad Valorem Taxes are expected November 8th • Sales and local gas taxes are expected the end of November • Parking Tickets - trending higher than budgeted (20% at 83% of the year) • Code Enforcement Fines - trending higher than budgeted (30.4% at 83% of the year) • Contributions and Donations (Leisure Services) were budgeted at $7,000 while actual to date is $8,100. • The interfund transfers o That is budgeted between the Capital Improvement fund, the Capital Projects fund and the General Fund will be made at the end of the month. o The budgeted interfund transfer between the Special Law Enforcement Trust and the General Fund will be made after the Police Chief s request from the Village Council is approved. Expenditures: Expenditures appear as expected, however, • Health Insurance premium to be paid on Monday — there were corrections that Cigna needed to make that have been resolved. • There are a number of purchase orders that have been rolled-forward that have not been funded and these PO's affect the budget-to-actual percentage. Funding of these purchase orders are going before the Village Council at the November 8"' meeting, at which time the amounts will be funded or the purchase orders will be cancelled. I I-Syl a 11/5/124:55 PM I�,�,� �j . � There has been no activity in the Ca,pital Im�provement Fund #301 or the Capital Projects Fund #303 WATER UTILITY FUND #401 Revenues: • At this time we do not have a full month of water revenues recorded. However, usage appears to be in line with the budgeted projections. • Capital connect charges — Developer — are higher than expected (71.1% received in the October) Expenditures: • Same explanation as above for the General Fund #001 Refuse and Recyclin� Fund #402 Revenues: First installment of non-ad valorem taaces are scheduled for November 8, 2012. Stormwater Fund #403 Revenues: First installment of non-ad valorem taxes are scheduled for November 8, 2012. Expenditures: • Stormwater has $215,041 of unfunded drainage improvements that are part of the roll-forward encumbrances from the prior year that are going before the Village Council for approval at the November 8"' meeting. At this time none of the funds have been spent. Confidential 2 REVENUEIEXPENDITURE REPORT . ` FY 2012 Page: 1 1115/2012 Vill o f Tequesta 4:54 pm For the Period: 1011/2012 to 913012013 Ori inal Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal °k Bud Fund: 001 - General Fund � � Revenues Function: 000 General Revenues Dept: 000 General General Property Taxes 4,377,000.00 4,377,000.00 0.00 0.00 0.00 4,377,000.00 0.0 Sales & Use Taxes 1,032,700.00 1,032,700.00 78,295.19 0.00 0.00 954,404.81 7.6 Franchise fees - gross receipt 401,400.00 401,400.00 35,433.73 0.00 0.00 365,966.27 8.8 Intragovernmental Revenue 503,709.00 503,709.00 A1,975.74 0.00 0.00 461,733.26 8.3 Intergovemmental Revenue 719,000.00 719,000.00 14,316.02 0.00 0.00 704,683.98 2.0 Chgs for Serv - Gen Gov 8,650.00 8,650.00 976.69 0.00 0.00 7,673.31 11.3 Rents & Royalties 140,050.00 140,050.00 16,119.47 0.00 0.00 123,930.53 11.5 Contributions & Donations 0.00 1,500.00 1,500.00 0.00 0.00 0.00 100.0 Miscellaneous Revenues 15,500.00 15,500.00 1.00 0.00 0.00 15,499.00 0.0 General 7,198,009.OQ 7,199,509.00 188,617.84 0.00 0.00 7,010,891.16 2.6 General Revenues 7,198,009.00 7,199,509.00 188,617.84 O.OQ 0.00 7,010,891.16 2.6 Function: 410 General Govemment Dept 150 Comprehensive Planning Charges for Services 45,000.00 45,000.00 4,043.25 0.00 0.00 40,956.75 9.0 Miscellaneous Revenues 200.00 200.00 0.00 0.00 0.00 200.00 0.0 Comprehensive Planning 45,200.00 45,200.00 4,043.25 0.00 0.00 41,156.75 8.9 General Govemment 45,200.00 45,200.00 4,043.25 0.00 0.00 41,156.75 8.9 Function: 420 Public Safety Dept: 171 Police Sales & Use Taxes 56,470.00 56,470.00 0.00 0.00 0.00 56,470.00 0.0 Licenses & Permits 6,300.00 6,300.00 4,480.00 0.00 0.00 1,820.00 71.1 Intergovemmental Revenue 21,850.00 21,850.00 0.00 0.00 0.00 21,850.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 Fines & Forfeitures 20,800.00 20,800.00 2,753.18 0.00 0.00 18,046.82 13.2 Impact Fees 0.00 0.00 62.98 0.00 0.00 -62.98 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,301.16 0.00 0.00 118,118.84 5.8 Dept: 180 Building & Zoning Licenses & Permits 315,750.00 315,750.00 40,810.83 0.00 0.00 274,939.17 12.9 REVENUEIEXPENDITURE REPORT . � FY 2012 Page: 2 11/512012 Vill of Tequesta 4:54 pm For the Period: 101112012 to 9/30/2013 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001 - General Fund Revenues Function: 420 Public Safety Building & Zoning 315,750.00 315,750.00 40,810.83 0.00 0.00 274,939.17 12.9 Dept: 192 Fire Control Sales & Use Taxes 154,700.00 154,700.00 0.00 0.00 0.00 154,700.00 0.0 Intergovemmental Revenue 6,840.00 6,840.00 0.00 0.00 0.00 6,840.00 0.0 Charges for Services 747,040.00 747,040.00 66,866.70 0.00 0.00 680,173.30 9.0 Impact Fees 500.00 500.00 86.74 0.00 0.00 413.26 17.3 Contributions & Donations 1,000.00 1,000.00 0.00 0.00 0.00 1,000.00 0.0 Miscellaneous Revenues 700.00 700.00 0.00 0.00 0.00 700.00 0.0 Fire Control 910,780.00 910,780.00 66,953.44 0.00 0.00 843,826,56 7.4 Public Safety 1,351,950.00 1,351,950.00 115,065.43 0.00 0.00 1,236,884.57 8.5 Function: 450 Leisure Services Dept: 231 Leisure Services Charges for Services - Recr. 83,900.00 83,900.00 8,504.76 0.00 0.00 75,395.24 10.1 Rents & Royalties 3,000.00 3,000.00 632.03 0.00 0.00 2,367.97 21.1 Impact Fees 0.00 0.00 275.60 0.00 O.OQ -275.60 0.0 Contributions 8 Donations 7,000.00 7,000.00 8,100.00 0.00 0.00 -1,100.00 115.7 Miscellaneous Revenues 5,000.00 5,000.00 1,176.28 0.00 0.00 3,823.72 23.5 Leisure Services 98,900.00 98,900.00 18,688.67 0.00 0.00 80,211.33 18.9 Leisure Services 98,900.00 98,900.00 18,688.67 0.00 0.00 80,211.33 18.9 Function: 581 Other Financing Sources and Us Dept: 900 Interfund Transfers Transfers In 452,440.00 452,440.00 0.00 0.00 0.00 452,440.00 0.0 Interfund 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 NonoperaGng Dept: 950 Other Nonoperating UnreshictedlnvestmentEamin 25,500.00 25,500.00 416.37 0.00 0.00 25,083.63 1.6 Other Nonoperating 25,500.00 25,500.00 416.37 0.00 0.00 25,083.63 1.6 Dept: 990 OthedReservelContingency Other Financing Sources 470,991.00 470,991.00 0.00 0.00 0.00 470,991.00 0.0 OthedReserve/Contingency 470,991.00 470,991.00 0.00 0.00 0.00 470,991.00 0.0 REVENUEIEXPENDITURE REPORT � � FY 2012 Page: 3 11I5/2012 Vil o f Tequ esta 4:54 pm For the Penod: 1011/2012 to 9/3012013 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD Unenc_Bal % Bud Fund: 001- General Fund Revenues Other Nonoperating 496,491.00 496,491.00 416.37 0.00 0.00 496,074.63 0.1 Revenues 9,642,990.00 9,644,490.00 326,831.56 0.00 0.00 9,317,658.44 3.4 Expenditures Function: 410 General Govemment Dept: 100 Council Opera6ng ExpenditureslExpense 28,450.00 28,450.00 1,280.50 0.00 0.00 27,169.50 4.5 Council 28,450.00 28,450.00 1,280.50 0.00 0.00 27,169.50 4.5 Dept: 110 Manager Personal Services 199,330.00 199,330.00 18,692.84 0.00 285.00 180,352.16 9.5 Operating ExpenditureslExpense 4,900.00 4,900.00 0.00 0.00 0.00 4,900.00 0.0 Manager 204,230.00 204,230.00 18,692.84 0.00 285.00 185,252.16 9.3 Dept: 111 Human Resources Personal Services 152,730.00 152,730.00 11,582.69 0.00 3,653.10 137,494.21 10.0 Operating ExpenditureslExpense 6,700.00 6,700.00 1,32Q.00 0.00 0.00 5,380.00 19.7 Human Resources 159,430.00 159,430.00 12,902.69 0.00 3,653.10 142,874.21 10.4 Dept: 120 Village Clerk Personal Services 154,590.00 154,590.00 10,721.58 0.00 247.50 143,620.92 7.1 Operating ExpenditureslExpense 62,335.00 62,335.00 2,227.80 0.00 0.00 60,107.20 3.6 Village Clerk 216,925.00 216,925.00 12,949.38 0.00 247.50 203,728.12 6.1 Dept: 130 Finance Personal Services 347,870.00 347,870.00 23,124.27 0.00 577.50 324,168.23 6.8 Operating ExpenditureslExpense 49,450.00 49,450.00 458.95 0.00 0.00 48,991.05 0.9 Finance 397,320.00 397,320.00 23,583.22 0.00 577.50 373,159.28 6.1 Dept: 140 Legal Operatlng Expenditures/Expense 114,000.00 114,000.00 1,250.00 0.00 13,750.00 99,000.00 13.2 Legal 114,000.00 114,000.00 1,250.00 0,00 13,750.00 99,000.00 13.2 Dept: 150 Comprehensive Planning Operating ExpenditureslExpense 149,580.00 149,580.00 8,925.00 0.00 97,155.00 43,500.00 70.9 Comprehensive Planning 149,580.00 149,580.00 8,925.00 0.00 97,155.00 43,500.00 70.9 Dept: 160 General Govemment Personal Services 94,910.00 94,910.00 7,214.02 0.00 157.50 87,538.48 7.8 Operating ExpenditureslExpense ' 181,700.00 181,700.00 12,611.18 0.00 60,512.44 108,576.38 40.2 Capital0utlay 0.00 0.00 5,800.01 0.00 0.00 -5,$00.01 0.0 REVENUEIEXPENDITURE REPORT • � FY 2012 Page: 4 11/5/2012 Village of Tequesta 4:54 pm For the Period: 1011I2012 to 9/30/2013 Ori inal Bud. Amended Bud. YTD Actual CURR NfTH Encumb. YTD UnencBal % Bud Fund: 001- General Fund Expenditures Function; 410 General Govemment General Govemment 276,610.00 276,610.00 25,625.21 0.00 60,669.94 190,314.85 31.2 General Govemment 1,546,545.00 1,546,545.00 105,208.84 0.00 176,338.04 1,264,998.12 18.2 Function: 420 Public Safety Dept: 175 Pofice Department Personal Services 2,511,670.00 2,511,670.00 166,244.85 0.00 28,462.50 2,316,962.65 7.8 Operating Expenditures/Expense 374,080.00 374,080.00 13,247.19 0.00 47,182.56 313,650.25 16.2 CapitalOuUay 40,000.00 40,000.00 0.00 0.00 O.OQ 40,000.00 0.0 Police Department 2,925,750.00 2,925,750.00 179,492.04 0.00 75,645.06 2,670,612.90 8.7 Dept: 180 Building & Zoning Personal Senrices 193,680.00 193,680.00 12,447.86 0.00 285.00 180,947.14 6.6 Operating ExpenditureslExpense 151,400.00 151,400.00 5,639.36 0.00 110,830.75 34,929.89 Z6.9 Building&Zoning 345,080.00 345,080.00 18,087.22 0.00 111,115.75 215,877.03 37.4 Dept: 192 Fire Control Personal Services 2,683,105.00 2,683,105.00 166,718.48 0.00 41,977.50 2,474,409.02 7.8 Operating ExpenditureslExpense 310,140.00 310,140.00 11,475.37 0.00 34,361.56 264,303.07 14.8 Capital0utlay 7,500.00 7,500.00 0.00 0.00 0.00 7,500.00 0.0 Fire Control 3,000,745.00 3,000,745.OQ 178,193.85 0.00 76,339.06 2,746,212.09 8.5 Public Safety 6,271,575.00 6,271,575.00 375,773.11 0.00 263,099.87 5,632,702.02 10.2 Function: 431 Transportation Dept: 210 Public Works Personal Seroices 307,180.00 307,180.00 12,389.74 0.00 8,160.00 286,630,26 6.7 Operating ExpenditureslExpense 480,220.00 481,720.00 10,226.76 0.00 49,297.85 422,195.39 12.4 Public Works 787,400.00 788,900.OQ 22,616.50 0.00 57,457.85 708,825.65 10.2 Transportation 787,400.00 788,900.00 22,616.50 0.00 57,457.85 708,825.65 10.2 Function: 450 Leisure Services Depi: 231 Leisure Services Personal Services 338,090.00 338,090.00 20,028.07 0.00 6,142.50 311,919.43 7.7 Operating ExpenditureslExpense 252,320.00 252,320.00 63,916.26 0.00 10,480.23 177,923.51 29.5 Leisure Services 590,410.00 590,410.00 83,944.33 0.00 16,622.73 489,842.94 17.0 Leisure Services 590,410.00 590,410.00 83,944.33 0.00 16,622.73 489,842.94 17.0 Function: 590 Other Nonoperating Dept: 700 Debt Service , REVENUEIEXPENDITURE REPORT � FY 2012 Page: 5 111512012 Village of Tequesta 4:54 pm For the Period: 101112012 to 9130/2013 Oriqinal Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 001 - General Fund Expenditures Function: 590 Other Nonoperating Dept: 700 Debt Service DIS - Principal 305,995.00 305,995.00 20,961.18 0.00 3,600.26 281,433.56 8.0 DIS - Interest 125,065.00 125,065.00 10,859.75 0.00 295.44 113,909.81 8.9 Debt Service 431,060.00 431,060.00 31,820.93 0.00 3,895.70 395,343.37 8.3 Dept; 950 Other Nonoperating Other Financing Sources & Uses 16,000.00 16,000.00 74,952.97 0.00 0.00 -58,952.97 468.5 Other Nonoperating 16,000.00 16,000.00 74,952.97 0.00 0.00 -58,952.97 468.5 Other Nonoperating 447,060.00 447,060.00 106,773.90 0.00 3,895.70 336,390.40 24.8 Expenditures 9,642,990.00 9,644,490.00 694,316.68 0.00 517,414.19 8,432,759.13 12.6 Net Effect for General Fund 0.00 0.00 -367,485.12 0.00 517,414.19 884,899.31 0.0 Change in Fund Balance: -367,485.12 REVENUEIEXPENDITURE REPORT . � FY 2012 Page: 6 11/512012 Village of Tequesta 4:54 pm For the Period: 10I112012 to 9/3012013 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 301 - Capital Improvement Fund Revenues Function: 590 Other Nonoperating Dept: 990 OthedReservelContingency Other Financing Sources 290,440.00 290,440.00 0.00 0.00 0.00 290,440.00 0.0 OthedReservelContingency 290,440.00 290,440.00 0.00 0.00 0.00 290,440.00 0.0 Other Nonoperating 290,440.OQ 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 Expenditures Function: 581 Other Financing Sources and Us Dept 900 Interfund Transfers Interfund Transfers Out 290,440.00 29Q,440.00 0.00 0.00 0.00 290,440.00 0.0 Interfund 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 Net Effect for Capital Improvement Fund 0.00 0.00 0.00 0.00 0.00 0.00 0.0 Change in Fund Balance: -367,485.12 REVENUEIEXPENDITURE REPORT � FY 2012 Page: 7 111512012 Vil of Tequesta 4:54 pm For the Period: 1011/2012 to 9/3012013 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal °/a Bud Fund: 303 - Capital Projects Fund Revenues Function: 590 Other Nonoperating Dept: 990 OthedReservelContingency Other Financing Sources 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,0OO.OQ 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 Interfund Transfers Out 112,000.00 112,000.00 0.00 0.00 0.00 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 Financing 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 Effect for Capital Projects Fund 0.00 0.00 0.00 0.00 0.00 0.00 0.0 Change in Fund Balance: -367,485.12 REVENUEIEXPENDITURE REPORT � FY 2012 Page: 8 1115/2012 Uillage of Tequesta 4:54 pm For the Period: 101112012 to 9I30/2013 On'c�inal 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,193,100.00 4,193,100.00 156,118.93 0.00 0.00 4,036,981.07 3.7 Miscellaneous Revenues 23,000.00 23,000.00 0.00 0.00 0.00 23,000.00 0.0 Other Financing Sources 46,000.00 46,000.00 7,105.16 0.00 0.00 38,894.84 15.4 General 4,262,100.00 4,262,100.00 163,224.09 0.00 0.00 4,098,875.91 3.8 General Revenues 4,262,100.00 4,262,100.00 163,224.09 0.00 0.00 4,098,875.91 3.8 Function: 590 Other NonoperaUng Dept: 950 Other Nonoperating Unrestricted Investment Eamin 7,500.00 7,500.00 247.50 0.00 0.00 7,252.50 3.3 Other Nonoperating 7,500.00 7,500.00 247.50 0.00 0.00 7,252.50 3.3 Dept 990 OthedReservelContingency Other Financing Sources 177,209.00 177,209.00 0.00 0.00 0.00 177,209.00 0.0 OthedReservelContingency 177,209.00 177,209.00 0.00 0.00 0.00 177,209.00 0.0 Other Nonoperating 184,709.00 184,709.00 247.50 0.00 0.00 184,461.50 0.1 Revenues 4,446,809.00 4,446,809.00 163,471.59 0.00 0.00 4,283,337.41 3.7 Expenditures Function: 533 Water Utility Services Dept: 241 Water-Administration Personal Services 196,020.00 196,020.00 14,927.67 0.00 315.00 180,777.33 7.8 Operating ExpenditureslExpense 628,559.00 628,559.00 42,716.75 0.00 56,504.50 529,337.75 15.8 Water-Administration 824,579.00 824,579.00 57,644.42 0.00 56,819.50 710,115.08 13.9 Dept: 242 Water- Production Personal Services 580,280.00 580,280.00 20,818.95 0.00 8,460.00 551,001.05 5.0 Operating ExpenditureslExpense 949,330.00 949,330.00 20,051.07 0.00 18,462.23 910,816.70 4.1 Water- Production 1,529,610.00 1,529,610.00 40,870.02 0.00 26,922.23 1,461,817.75 4.4 Dept 243 Water-Distribution Personal Services 654,120.00 654,120.00 34,561.34 0.00 8,190.00 611,368.66 6.5 Operating ExpenditureslExpense 117,800.00 117,800.00 $,626.08 0.00 3,86Q.19 105,313.73 10.6 Water-Distribution 771,920.00 771,920.00 43,187.42 0.00 12,050.19 716,682.39 7.2 Dept: 411 Renewal & Replacement Operating ExpenditureslExpense 73,300.00 73,300.00 1,280.44 0.00 10,326.00 61,693.56 15.8 Capital0utlay 601,000.00 601,000.00 0.00 0.00 34,672.00 566,328.00 5.8 REVENUEIEXPENDRURE REPORT � � FY 2012 Page: 9 111512012 Village of Tequesta 4:54 pm For the Period: 10/1/2012 to 913012013 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal °� Bud Fund: 401- Water Fund � Expenditures Function: 533 Water Utility Services Renewal & Replacement 674,300.00 674,300.00 1,280.44 0.00 44,998.00 628,021.56 6.9 Dept: 412 Capital Improvement Capital0utlay 0.00 0.00 22,485.00 0.00 59,405.38 -81,890.38 0.0 Capitallmprovement 0.00 0.00 22,485.00 0.00 59,405.38 -81,890.38 0.0 Water Utility Services 3,800,409.00 3,800,409.00 165,467,30 0.00 200,195.30 3,434,746.40 9.6 Function: 590 Other Nonoperating Dept: 700 Debt Service DIS - Principal 296,250.00 296,250.00 43,416.18 0.00 0.00 252,833.82 14.7 D/S - Interest 242,200.00 242,200.00 18,791.27 0.00 0.00 223,408.73 7.8 Debt Service 538,450.00 538,450.00 62,207.45 0.00 0.00 476,242.55 11.6 Dept: 950 Other Nonoperating Operating ExpenditureslExpense 95,950.00 95,950.00 0.00 0.00 0.00 95,950.00 0.0 Other Financing Sources & Uses 12,000.00 12,000.00 695.46 0.00 0.00 11,304.54 5.8 Other Nonoperating 107,950.00 107,950.00 695.46 0.00 0.00 107,254.54 0.6 Other Nonoperating 646,400.00 646,400.00 62,902.91 0.00 0.00 583,497.Q9 9.7 Expenditures 4,446,809.00 4,446,8p9.00 228,370.21 0.00 200,195.30 4,018,243.49 9.6 Net Effect for Water Fund 0.00 0.00 -64,898.62 0.00 200,195.30 265,093.92 0.0 Change in Fund Balance: -64,898.62 , REVENUEIEXPENDITURE REPORT � FY 2012 Page: 10 11/512012 Village of Tequesta 4:54 pm For the Period: 101112012 to 9130/2013 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 402 - Refuse & Recycling Revenues Function: 000 General Revenues Dept: 000 General Intergovemmental Revenue 7,500.00 7,500.00 0.00 0.00 0.00 7,500.00 0.0 Charges for Seroices 472,410.00 472,410.00 64.00 0.00 0.00 472,346.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 64.00 0.00 0.00 484,516.00 0.0 General Revenues 484,580.00 484,580.00 64.00 0.00 0.00 484,516.00 0.0 Function: 590 Other Nonoperating Dept: 950 Other Nonoperating Unrestricted InvesUnent Eamin 600.00 600.00 14.38 0.00 0.00 585.62 2.4 Other Nonoperating 600.00 600.00 14.38 0.00 0.00 585.62 2.4 Other Nonoperating 600.00 600.00 14.35 0.00 0.00 585.62 2.4 Revenues 485,180.00 485,180.00 78.38 0.00 0.00 485,101.62 0.0 Expenditures Function: 534 Refuse & Recycling Dept: 245 Refuse and Recycling Operating ExpenditureslExpense 485,180.00 485,180.00 40,334.40 0.00 0.00 444,845.60 8.3 Refuse and Recycling 485,180.00 485,180.00 40,334.40 0.00 O.QO 444,845.60 8.3 Refuse & Recycling 485,180.00 485,180.00 40,334.40 0.00 0.00 444,845.60 8.3 Expenditures 485,150.00 485,180.00 40,334.40 0.00 0.00 444,845.60 8.3 Net Effect for Refuse & Recyding 0.00 0.00 �30,256.02 0.00 0.00 40,256.02 0.0 Change in Fund Balance: �10,256.02 REVENUEIEXPENDITURE REPORT � FY 2012 Page: 11 11/5/2012 V il l age of T equesta 4:54 pm For the Period: 101112012 to 9130/2013 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 318,000.00 318,000.00 0.00 0.00 0.00 318,000.00 0.0 General 318,000.00 318,000.00 0.00 0.00 0.00 318,000.00 0.0 General Revenues 318,000.00 318,000.00 0.00 0.00 0.00 318,000.00 0.0 Function: 590 Other Nonoperating Dept: 950 Other Nonoperating UnrestrictedlnvestmentEarnin 1,700.00 1,100.00 86.99 0.00 0.00 1,013.01 7.9 OtherNonoperating 1,100.00 1,10Q.00 $6.99 0.00 0.00 1,013.01 7.9 Other Nonoperating 1,100.00 1,100.00 86.99 0.00 0.00 1,013.41 7.9 Revenues 319,100.00 319,100.00 86.99 0.00 0.00 319,013.01 0.0 Expenditures Function: 550 Stormwater Dept: 250 Storm Water Utilities Personal Services 60,300.00 60,300.00 2,507.14 0.00 825.00 56,967.86 5.5 Operating ExpenditureslExpense 62,580.00 62,580.00 4,721.76 0.00 739.35 57,118.89 8.7 Capital0utlay 0.00 0.00 0.00 0.00 215,040.83 -215,040.83 0.0 Storm Water Utilities 122,880.00 122,880.00 7,228.90 0.00 216,605.18 -100,954.08 182.2 Stormwater 122,880.00 122,880.00 7,228.90 0.00 216,605.18 -100,954.08 182.2 Function: 590 Other Nonoperating Dept: 950 Other Nonoperating Operating ExpenditureslExpense 110,950.00 110,950.00 0.00 0.00 0.00 110,950.00 0.0 Other Financing Souroes & Uses 85,270.00 85,270.00 0.00 0.00 0.00 85,270.00 0.0 Other Nonoperating 196,220.00 196,220.00 0.00 0.00 0.00 196,220.00 0.0 Other Nonoperating 196,220.00 196,220.00 0.00 0.00 0.00 196,220.00 0.0 Expenditures 319,100.00 319,100.00 7,228.90 0.00 216,605.18 95,265.92 70.1 Net Effect for Stormwater Utility O.QO 0.00 -7,141.91 0.00 216,605.18 223,747.09 0.0 Change in Fund Balance: -7,141.91 Grand Total Net Effect: 0.00 0.00 -479,781.67 0.00 934,214.67 1,413,996.34