The URL can be used to link to this page

Home My WebLink AboutOrdinance 28-11RECORD OF ORDINANCES Dayton Legal Blank, Inc. 28 -11 Ordinance No . . ......... ................... Passed..... ..... AN ORDINANCE ADOPTING THE PROPOSED TAX BUDGET FOR FISCAL YEAR 2012 WHEREAS, Section 5705.28 of the Ohio Revised Code requires that City Council adopt a tax budget for the following year on or before July 15; and WHEREAS, Section 5705.30 of the Ohio Revised Code requires the tax budget to be filed with the County Auditor(s), as secretary to the budget commission(s), on or before July 20; and WHEREAS, the filing of the tax budget with the County Auditor(s) entitles the City to participate in "local government funds," which are monies collected by the State of Ohio and shared with its various political subdivisions via the County(s). NOW, THEREFORE, BE IT ORDAINED by the Council of the City of Dublin, State of Ohio, 1l of the elected members concurring that: Section 1 . The proposed 2012 tax budget, hereto attached as an Exhibit, be and hereby is approved. Section 2 . This ordinance shall take effect on the earliest date permitted under applicable law. Passed this 1 34� day of , 2011 ATTEST: Clerk of Council I hereby certify that copies of this Ordinance/ Resolution were posted in the City of Dublin in accordance with Section 4.12(a) of the Revised Charter of the City of Dublin. uty Clerk of Council, Dublin, Ohio CITY OF DUBLIN- Office of the City Manager 5200 Emerald Parkway • Dublin, OH 43017 -1090 Phone: 614 -410 -4400 • Fax: 614 -410 -4490 To: Members of Dublin City Council From: Marsha I. Grigsby, City Manager'Cn Date: May 19, 2011 Initiated By: Bryan K. Thurman, Deputy Director of Finance Melody M. Kennedy, Financial Analyst 1TC�T•7 Re: Ordinance No. 28 -11 - Adopting the Proposed Tax Budget for Fiscal Year 2012 Summary Ordinance No. 28 -11 authorizes the adoption of the proposed tax budget for fiscal year 2012. The tax budget represents the earliest step in the formulation of the City's annual operating budget. The Ohio Revised Code (ORC) mandates the annual filing of the tax budget. The tax budget includes actual revenue and expenditures for the two preceding years, and estimates of revenue and expenditures for the current year and for the next year. Once adopted, it will be filed with the Delaware and Franklin County Budget Commissions. Union County does not require the tax budget to be filed with their County Budget Commission. The ORC requires the adoption of the tax budget by July 15 and the City is required to submit the tax budget to the County Budget Commissions before July 20. The City's eligibility to receive "local government funds" from Delaware and Franklin counties is contingent upon the timely filing of a tax budget with the respective County Budget Commissions. The Franklin County Budget Commission also reviews property tax levy assessments outside the ten - mill limitation to verify the appropriate millage for those obligations. As City Council is aware, the allocation of the City's inside millage, a total of 1.75 mills, can be adjusted on an annual basis. For fiscal years 2001 — 2006, 100 percent of the property tax revenue from the inside millage was allocated to the Parkland Acquisition Fund. Since 2007, a portion of the inside millage has been allocated to the Capital Improvements Tax Fund. As approved in the 2010 — 2014 Capital Improvements Program (CIP), the amount of property tax revenue allocated to the Capital Improvements Tax Fund was increased from .80 mills to 1.4 mills for 2010 and 2011. For 2012, this allocation is currently scheduled to return to 2009 allocations, with .80 mills to the Capital Improvements Tax Fund and the remaining .95 mills to the Parkland Acquisition Fund. This is reflected in the attached document. The City has the option to reallocate the tax revenue from the inside millage each year as part of the tax budget process, and later in the year when the "Resolution Accepting the Amounts and Rates" is considered in early September. The allocation of the inside millage will be reviewed as part of the upcoming 2012 — 2016 CIP process. During the Finance Committee of the Whole meeting on April 11, 2011, the City Manager submitted a financial update through the first quarter of 2011. As discussed at the meeting, income tax revenues through the first quarter of 2011 had increased 7.39% over the first quarter of 2010. Through April, income tax collections have increased 3.8% compared to the year -to -date total Ordinance No. 28 -11 - Adopting the Proposed Tax Budget for FY 2012 May 19, 2011 Page 2 through April 2010. Because income tax revenues collected through April represent a large percentage of the overall income tax collections expected for the year, staff is now better able to project revenues for the 2011 tax year. As a result, the estimated income tax revenue for 2011 has been revised to match 2010 income tax revenues and represents an increase over the original 2011 budget projections. The tax budget reflects an estimated growth in expenditures in 2012 of 2.5% over 2011 projected expenditures. As in the past, the City remains conservative in estimating revenues and expenditures. The General Fund balance is a critical component to the financial stability of the City and continues to be a key financial indicator used by the rating agencies in evaluating the financial strength of the City. The City's practice has been to maintain a year -end balance equal to or greater than 50 percent of the General Fund expenditures, including operating transfers. Based on estimated revenue and expenditures, the 2012 tax budget reflects an estimated year -end General Fund balance, before any repayment of advances, of $36,384,885 for 2011 and $33,949,514 for 2012 which, as a percentage of General Fund expenditures and operating transfers, equals 69.95 percent and 64.28 percent, respectively. The Proposed Tax Budget for FY 2012 shows a precursory review of revenue and expenditures for next year; however, it does include an updated projection for income tax revenues. Staff will continue to monitor revenue and expenditures, provide updated reports and make current and future revenue and expenditure adjustments as necessary. Recommendation Staff recommends approval of Ordinance 28 -11 at the second reading/public hearing on June 13, 2011. (Attachments) SCHEDULE A SUMMARY OF AMOUNTS REQUIRED FROM GENERAL PROPERTY TAX APPROVED BY BUDGET COMMISSION, AND COUNTY AUDITOR'S ESTIMATED RATES Fnr tali inirinni I IcP For Budget Commission Use For County Auditor Use FUND (Include only those funds which are requesting g eneral propegy tax revenue) Budget Year Amount Requested of Budget Commission Inside/ Outside Budget Year Amount Approved by Budget Commission Inside 10 Mill Limitation County Auditor's estimate Budget Year Tax Rate to be Levied Amount to be Derived From Inside 10 Mill Outside 10 Mill Levies Outside Limited Budget Limit Budget 10 Mill Limitation Year Year Column 1 Column 2 Column 3 Column 4 Column 5 GOVERNMENT FUNDS XXXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX GENERAL FUND 0 POLICE/SAFETY OPERATING FUND 417,150 G. O. DEBT SERVICE FUND 0 PARKLAND ACQUISITION 1,728,000 CAPITAL IMPROVEMENTS TAX FUND 1,472,000 PROPRIETARY FUNDS XXXXXXXX X)UOOWOC XXXXXXXXX XXXXXXXXX XXXXXXXX FIDUCIARY FUNDS XX)UWUU( XX)O(ODUC XXXXXXXX XXXX)O= XXXXXXXX TOTAL ALL FUNDS 3,617,150 M:1FA%Tax Budgets%TAX BUDGET 20121Taxbud2012 MK modified (2).xlsx 5/16/2011 SCHEDULE B LEVIES OUTSIDE 10 MILL LIMIT EX CLUSIVE OF DEBT LEVIES FUND Maximum Rate Authorized to be Levied Tax Year County Auditor's Estimate of Yield of Levy (Carry to Schedule A, Column 3 GENERAL FUND: Current Expense Levy authorized by voters on not exceed years. Authorized under Sect. R.C. Current Expense Levy authorized by voters on / / not exceed years. Authorized under Section. R.C. Current Expense Levy authorized by voters on ! / not exceed years. Authorized under Section. R.C. Current Expense Levy authorized by voters on ! / not exceed years. Authorized under Section. R.C. Current Expense Levy authorized by voters on ! / not exceed years. Authorized under Section. R.C. not exceed years. Authorized under Section. R.C. Current Expense Levy authorized by voters on / / not exceed years. Authorized under Section. R.C. TOTAL GENERAL FUND OUTSIDE 10 MILL LIMITATION SPECIAL LEVY FUNDS POLICE /SAFETY FUND, Levy authorized by voters on 06/1976 1.2 not to exceed ONGOING years. Authorized under Section R.C. FUND, Levy authorized by voters on not to exceed years. Authorized under Section R.C. FUND, Levy authorized by voters on not to exceed years. Authorized under Section R.C. FUND, Levy authorized by voters on I / not to exceed years. Authorized under Section R.C. FUND, Levy authorized by voters on I 1 not to exceed years. Authorized under Section R.C. FUND, Levy authorized by voters on ! ! not to exceed years. Authorized under Section R.C. FUND, Levy authorized by voters on I / not to exceed years. Authorized under Section R.C. FUND, Levy authorized by voters on not to exceed years. Authorized under Section R.C. FUND, Levy authorized by voters on not to exceed years. Authorized under Section R.C. FUND, Levy authorized by voters on / / M: \FA \Tax Budgets \TAX BUDGET 2012\Taxbud2012 MK modified (2)xlsx 5116/2011 FUND NAME: GENERAL FUND EXHIBIT I FUND TYPE /CLASSIFICATION: GOVERNMENTAL -- GENERAL This Exhibit is to be used for the General Fund Only DESCRIPTION (1) For 2009 Actual ( For 2010 Actual ( Current Year Estimated for 2011 ( Budget Year Estimated for 2012 ( _ REVENUES XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Local Taxes General Property Tax -- Real Estate 0 0 0 0 Tangible Personal Property Tax 0 0 0 0 Municipal Income Tax 49,430,696 51,636,396 51,636,400 51,636,400 Other Local Taxes 0 0 0 0 Total Local Taxes 49,430,696 51,636,396 51,636,400 51,636,400 Intergovernmental Revenues State Shared Taxes and Permits Local Government 1,072,791 1,040,697 903,200 645,140 Estate Tax 1,290,736 493,998 25,000 25,000 Cigarette Tax 342 544 250 250 Liquor and Beer Permits 55,137 51,954 40,000 40,000 Gasoline Tax 0 0 0 0 Library and Local Government Support Func 0 0 0 0 Property Tax Allocation 13,411 10,503 0 0 Total State Shared Taxes and Permits 2,432,417 1,597,695 968,450 710,390 Federal Grants or Aid 54,210 52,292 0 0 State Grants or Aid 0 31,700 0 0 Other Grants or Aid 0 0 0 Total Intergovernmental Revenues 2,486,627 1,681,687 968,450 710,390 Special Assessments 0 0 0 0 Charges for Services 586,592 841,436 710,000 710,000 Fines, Licenses, and Permits 1,854,455 1,756,098 1,424,800 1,424,800 Miscellaneous 1,344,362 1,306,928 828,000 828,000 Other Financing Sources: Proceeds from Sale of Debt 0 0 0 0 Transfers 0 0 0 0 Advances 6,925,625 2,148,000 3,711,730 75,000 Other Sources 0 0 0 0 TOTAL REVENUE 62,628,358 11 59,370,5L5j 59,279,380 55,384,590 M: \FA \Tax Budgets \TAX BUDGET 2012 \Taxbud2012 MK modified (2).xlsx 5/16/2011 FUND NAME: GENERAL FUND FUND TYPE /CLASSIFICATION: GOVERNMENTAL -- GENERAL EXHIBIT I M: \FA \Tax Budgets \TAX BUDGET 2012\Taxbud2012 MK modified (2).xlsx 5/16/2011 This Exhibit is to be used for the General Fund Only DESCRIPTION (1) For 2009 Actual (3) For 2010 Actual (3) Current Year Estimated for 2011 (4) Budget Year Estimated for 2012 (5) EXPENDITURES XXXXXXXX XXXXXXXX XXXXXXXX X XXXXXXX Security of Persons and Property Personal Services 0 0 0 0 Travel Transportation 0 0 0 0 Contractual Services 185,616 210,113 185,000 189,620 Supplies and Materials 86,159 119,332 125,000 128,120 Capital Outlay 0 0 0 0 Total Security of Persons and Property 271,775 329,445 310,000 317,740 Public Health Services Personal Services 0 0 0 0 Travel Transportation 0 0 0 0 Contractual Services 222,949 222,949 232,180 237,980 Capital Outlay 0 0 0 Total Public Health Services 222,949 222,949 232,180 237,980 Leisure Time Activities Personal Services 4,475,494 4,475,802 4,581,250 4,695,780 Travel Transportation 21,329 226,580 241,620 241,620 Contractual Services 1,124,403 771,341 915,300 938,180 Supplies and Materials 392,645 544,421 451,680 462,970 Capital Outlay 270,378 146,029 135,800 139,190 Total Leisure Time Activities 6,284,249 6,164,173 6,325,650 6,477,740 Community Environment Personal Services 5,859,183 5,488,824 5,582,830 5,722,400 Travel Transportation 53,928 48,890 60,450 60,450 Contractual Services 611,913 370,518 604,500 619,610 Supplies and Materials 45,979 36,115 58,400 59,860 Capital Outlay 4,145 3,457 5,410 5,540 Total Community Environment 6,575,149 5,947,804 6,311,590 6,467,860 Basic Utility Services Personal Services 710,383 694,363 672,470 689,280 Travel Transportation 1,978 1,217 2,700 2,700 Contractual Services 2,378,851 2,464,011 2,608,210 2,673,410 Supplies and Materials 3,684 3,010 7,550 7,740 Capital Outlay 0 540 0 0 Total Basic Utility Services L 3,094,896 3,163,142 3,290,930 3,373,130 M: \FA \Tax Budgets \TAX BUDGET 2012\Taxbud2012 MK modified (2).xlsx 5/16/2011 FUND NAME: GENERAL FUND EXHIBIT I FUND TYPE /CLASSIFICATION: GOVERNMENTAL --GENERAL This Exhibit is to be used for the General Fund Only DESCRIPTION (1) For 2009 Actual (2) For 2010 Actual (3) Current Year Estimated for 2011 (4) Budget Year Estimated for 2012 (5) Transportation Personal Services 0 0 0 0 Travel Transportation 0 0 0 0 Contractual Services 0 0 0 0 Supplies and Materials 0 0 0 0 Capital Outlay 0 0 0 0 Total Transportation 0 0 0 0 General Government Personal Services 9,003,741 8,560,066 9,313,180 9,546,010 Travel Transportation 151,110 110,351 199,440 199,440 Contractual Services 5,908,829 6,393,997 6,609,230 6,774,460 Supplies and Materials 1,878,014 2,082,079 2,540,310 2,603,820 Capital Outlay 71,614 950 22,900 23,470 Total General Government 17,013,309 17,147,443 18,685,060 19,147,200 Debt Service Interest 0 0 0 0 Other Debt Service 0 0 0 0 Total Debt Service 0 0 0 0 Other Uses of Funds Transfers 13,250,000 13,900,000 15,675,000 15,675,000 Advances 655,000 232,300 240,000 230,000 Contingencies 56,186 154,931 150,000 150,000 Other Uses of Funds (Refunds /Incentives /Grants) 6,836,518 5,550,840 5,754,450 5,898,310 Total Other Uses of Funds 20,797,704 19,838,070 21,819,450 21,953,310 TOTAL EXPENDITURES 54,260,029 52,813,026 56,974,860 57,974,960 Revenues over /(under) Expenditures 8,368,329 6,557,519 2,304,520 (2,590,370) Beginning Cash Fund Balance 22,626,246 30,994,575 37,552,095 39,856,615 Ending Cash Fund Balance 30,994,575 37,552,095 39,856,615 37,266,245 Estimated Encumbrances (2,460,166) (2,372,843) 0 0 Estimate Ending Unencumbered Fund Balance 28,534,409 35,179,251 39,856 1 37,266, M:1FA \Tax Budgets\TAX BUDGET 2012 \Taxbud2012 MK modified (2).xlsx 5/16/2011 FUND NAME: SAFETY /POLICE OPERATING EXHIBIT II FUND TYPE /CLASSIFICATION: SPECIAL REVENUE To be used for any fund receiving property tax revenue except the DESCRIPTION (1) General Fund. Current Year Budget Year For 2009 For 2010 Estimated for Estimated for Actual Actual 2011 2012 (2) (3) (4) (5) REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX Local Taxes 437,216 433,502 417,150 417,150 Intergovernmental Revenue 176,714 304,443 128,200 128,200 Charges for Services 551,499 591,417 542,550 542,550 Miscellaneous 39,964 27,196 9,090 9,090 Other Financing Sources: Transfers 8,700,000 9,099,999 9,580,000 9,580,000 Other Sources 0 0 0 0 TOTAL REVENUE 9,905,393 10,456,556 10,676,990 10,676,990 EXPENDITURES (Identify each program and object code at the same level shown on (PROGRAM) (OBJECT) XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Security of Persons and Property Personal Services 10,007,683 9,884,947 9,827,930 10,073,630 Travel/Transportation 62,230 11,665 68,000 68,000 Contractual Services 273,703 219,408 262,200 268,750 Supplies and Materials 103,459 85,439 170,960 175,230 Capital Outlay 61,772 9,435 16,650 17,070 Other Uses(Refunds) 100 70 500 520 TOTAL EXPENDITURES 10,508,947 10,210,965 10,346,240 10,603,200 Revenues Over (Under) Expenditures (603,554) 245,591 330,750 73,790 Beginning Cash Fund Balance Ending Cash Fund Balance Estimated Encumbrances (outstanding at end of year) Estimated Ending Unencumbered Fund Balance 828,764 225,210 470,800 801,550 225,210 470,800 801,550 875,340 (65,572) (37,203) 0 0 159,638 433,597 801,550 8 75,340 M: \FA \Tax Budgets \TAX BUDGET 2012\Taxbud2012 MK modified (2).xlsx 5/16/2011 FUND NAME: GENERAL OBLIGATION BOND RETIREMENT EXHIBIT II FUND TYPE /CLASSIFICATION: DEBT SERVICE To be used for any fund receiving property tax revenue except the General Fund DESCRIPTION (1) For 2009 Actual (2) For 2010 Actual (3) Current Year Estimated for 2011 (4) Budget Year Estimated for 2012 (5) REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX Local Taxes 0 0 0 0 Intergovernmental Revenue 591 147,426 142,110 142,110 Miscellaneous 50,009 21,417 18,870 18,870 Other Financing Sources: 0 0 0 0 Proceeds From Sale Of Debt 225,339 3,441 0 0 Transfers 7,211,304 6,785,132 5,545,980 5,682,300 Advances 0 0 0 TOTAL REVENUE 7,487,244 6,957,416 5,706,960 5,843,280 EXPENDITURES (Identify each program and object code at the same level shown on Exhibit 1) XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Debt Service: Redemption of Principal 5,510,883 5,105,915 4,051,970 4,007,440 Interest 1,693,045 1,844,941 1,641, 360 1,816,580 Other Debt Service 230,160 16,930 20,000 20,000 Advances 0 0 0 TOTAL EXPENDITURES 7,434,087 6,967,785 5,713,330 5,844,020 Revenues Over (Under) Expenditures Beginning Unencumbered Fund Balance (Use Actual Cash Balance in Col. 2 and 3) Ending Cash Fund Balance Estimated Encumbrances (outstanding at end of year Estimated Ending Unencumbered Fund Balance 53,157 (10,369) (6,370) (740) 780,379 833,536 823,170 816,800 833,536 823,170 816,800 816,060 0 0 0 0 833,536 823,170 816,800 816,060 M: \FA \Tax Budgets \TAX BUDGET 2012 \Taxbud2012 MK modified (2).x1sx 5/16/2011 EXHIBIT II FUND TYPE /CLASSIFICATION: CAPITAL PROJECTS To be used for any fund receiving property tax revenue except the General Fund. DESCRIPTION (1) For 2009 Actual (2) For 2010 Actual (3) Current Year Estimated for 2011 (4) Budget Year Estimated for 2012 (5) REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX Local Taxes'' Property Tax -- Real Estate /Personal Property 1,413,428 2,484,841 2,504,140 1,472,000 Municipal Income Tax 16,476,896 17,212,130 17,212,130 17,212,130 Intergovernmental Revenue 512,291 2,279,439 2,172,430 259,530 Fines, Licenses, and Permits 0 0 0 0 Miscellaneous 423,205 638,443 303,500 300,000 Other Financing Sources: Transfers 80,000 80,000 0 0 Other Sources - Advances 703,859 1,126,197 0 0 Proceeds from Bonds 0 0 0 0 TOTAL REVENUE 19,609,679 23,821,050 22,192,200 19,243,660 EXPENDITURES (Identify each program and object code at the same level shown on (PROGRAM) (OBJECT) XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Contractual Services 19,979 36,256 20,000 20,500 Capital Outlay 10,979,840 10,749,700 16,788,200 14,865,000 Transfers 7,110,047 6,921,750 3,381,605 7,755,180 Advances 1,341,150 207,150 3,600,000 1,500,000 TOTAL EXPENDITURES 19,451,016 17,914,855 23,789,805 24,140,680 Revenues Over (Under) Expenditures 158,663 5,906,195 (1,597,605) (4,897,020) Beginning Unencumbered Fund Balance (Use Actual Cash Balance in Col. 2 and 3) Ending Cash Fund Balance Estimated Encumbrances (outstanding at end of year) Estimated Ending Unencumbered Fund Balance 8,395,589 8,554,252 14,460,450 12,862,845 8,554,252 14,460,450 12,862,845 7,965,825 (3,970,757) (3,145,800) 0 0 4,583,495 1 11,31i,649JI 12,862,845 1 7,965,825 M: \FA \Tax Budgets \TAX BUDGET 2012 \Taxbud2012 MK modified (2).Asi 5/16/2011 FUND NAME: PARKLAND ACQUISITION EXHIBIT II FUND TYPE /CLASSIFICATION: CAPITAL PROJECTS To be used for any fund receiving property tax revenue except the General Fund. DESCRIPTION (1) For 2009 Actual (2) For 2010 Actual (3) Current Year Estimated for 2011 (4) Budget Year Estimated for 2012 (5) REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXX Local Taxes - Real Estate 1,678,446 621,210 626,230 1,728,000 Intergovernmental Revenue 355,758 707,207 151,530 106,530 Fines, Licenses, and Permits 0 0 0 0 Miscellaneous 161,405 372,449 61,250 61,250 Other Financing Sources: Transfers 0 0 0 Other Sources - Advances 0 0 0 Proceeds from Bonds 0 0 0 0 TOTAL REVENUE 2,195,609 1,700,866 839,010 1,895,780 EXPENDITURES (Identify each program and object code at the same level shown on (PROGRAM) (OBJECT) XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Contractual Services 26,507 13,598 15,000 15,370 Capital Outlay 4,200,296 857,866 650,000 1,728,000 Transfers 582,581 236,485 228,140 225,700 Advances 0 1,065,609 0 0 TOTAL EXPENDITURES 4,809,384 2,173,558 893,140 1,969,070 Revenues Over (Under) Expenditures (2,613,775) (472,692) (54,130) (73,290) Beginning Unencumbered Fund Balance (Use Actual Cash Balance in Col. 2 and 3) Ending Cash Fund Balance Estimated Encumbrances (outstanding at end of year) Estimated En ding Unencumbered Fund Balance 6,751,419 4,137,644 3,664,950 3,610,820 4,137,644 3,664,950 3,610,820 3,537,530 0 0 0 0 4,137,644 3,664,950 3,6 10,820JI 3,537,530 M: \FA \Tax Budgets \TAX BUDGET 2012 \Taxbud2012 MK modified (2).xlsx 5/16/2011 EXHIBIT III FUND List All Funds Individually Unless Reported on Exhibit I or II Estimated Unencumbered Fund Balance 011/01/12 11 Budget Year Estimated Receipt Total Available For Expenditures 1 1 Budget Year Expenditures and Encumbrances Personal Services Other Total Estimated Unencumbered Balance 12/31/12 GOVERNMENTAL: SPECIAL REVENUE: Street Maintenance & Repair XXXXXXXX XXXXXXXX 334,900 XXXXXXXX XXXXXXXX 3,358,250 XXXXXXXX XXXXXXXX 3,693,150 XXXXXXXX XXXXXXXX 2,307,710 XXXXXXXX XXXXXXXX 1,220,900 XXXXXXXX XXXXXXXX 3,528,610 XXXXXXXX XXXXXXXX 164,540 State Highway Improvement 267,940 139,180 407,120 0 25,630 25,630 381,490 Cemetery 19,380 147,930 167,310 120,260 27,400 147,660 19,650 Recreation 242,820 7,838,310 8,081,130 4,982,770 2,752,320 7,735,090 346,040 Swimming Pool 103,550 901,780 1,005,330 541,310 410,470 951,780 53,550 permissive Tax 1,295,590 106,200 1,401,790 0 167,000 167,000 1,234,790 Hotel /Motel Tax 1,597,700 2,706,950 4,304,650 497,520 2,764,160 3,261,680 1,042,970 Enforcement & Education 69,410 2,610 72,020 0 0 0 72,020 Law Enforcement Trust 27,710 1,220 28,930 0 24,750 24,750 4,180 Mandatory Drug Fine 2,470 40 2,510 0 0 0 2,510 Mayor's Court Computer 18,110 9,530 27,640 0 22,000 22,000 5,640 Accrued Leave Reserves 1,542,000 150,000 1,692,000 1 150,000 0 150,000 1,542,000 Wireless 9 -1 -1 System 140,000 120,000 260,000 175,000 175,000 85,000 TOTAL SPECIAL REVENUE FUNDS DEBT SERVICE FUNDS 5,661,580 XXXXXXXX 15,482,000 XXXXXXXX 21,143,580 XXXXXXXX 8,599,570 XXXXXXXX 7,589,630 XXXXXXXX 16,189,200 XXXXXXXX 4,954,380 XXXXXXXX Special Assessment Bond Retirement 0 0 0 0 0 0 1992 Special Assessment Bond Retirement 72,310 102,680 174,990 0 108,240 108,240 66,750 2001 Special Assessment Bond Retirement 144,530 150,000 294,530 0 128,650 128,650 165,880 TOTAL DEBT SERVICE FUNDS 216,840 252,680 469,520 --- 236,89011 236,890 232,630 CAPITAL PROJECT FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Note: Various construction funds not included. il TOTAL CAPITAL PROJECTS 1 01 0 0 0 0 0 0 M: \FA \Tax Budgets \TAX BUDGET 2012 \Taxbud2012 MK modified (2).xlsx 5/1612011 EXHIBIT III FUND fist All Funds Individually Unless Reported on Exhibit I or 11 Estimated Unencumbere Fund Balance 01/01/12 1 Budget Year Estimated Receipt 11 Total Available For Expenditures 11 Budget Year Expenditures and Encumbrances Personal Services Other Total Estimated Unencumbered Balance 12/31/12 PROPRIETARY: ENTERPRISE FUNDS Water XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX 11, 695, 310 4,062,740 15, 758,050 186,380 4,102, 790 4,289,170 11,468, 880 Sewer 6,471,620 3,830,530 10,302,150 785,920 3,406,980 4,192,900 6,109,250 Merchandising 34,220 2,620 36,840 0 8,000 8,000 28,840 TOTAL ENTERPRISE FUNDS 18,201,150 7,895,890 26,097,040 972,300 7,517,770 8,490,070 17,606,970 INTERNAL SERVICE FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXX Employee Benefits Self- Insurance 781,820 5,638,650 6,420,470 28,240 5,441,700 5,469,940 950,530 Workers Compensation Self- Insurance 648,430 265,240 913,670 0 401,610 401,610 512,060 TOTAL INTERNAL S FUNDS 1,430,250 5,903,890 7,334,140 28,240 5,843,310 5,871,550 1,4 TRUST AND AGENCY FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Drug Enforcement 0 0 0 0 0 0 0 Cemetery Perpetual Care 1,009,050 38,230 1,047,280 0 0 0 1,047,280 Dublin Convention & Visitors Bureau 40,190 483,300 523,4 01 0 483,300 483,300 40,190 Agency(Deposits) 162,160 428,100 590,260 0 543,600 543,600 46,660 TOTAL TRUST AND AGENCY FUNDS 1,211,400 949,630 2,161,030 0 1,026,900 1,026,900 1,134,130 TOTAL FOR MEMORANDUM ONLY 26,721,220 30,484,090 57,205,310 9,600,112JI 22,214,500 31,81 4,610 F 25 ,390,700 M: \FA \Tax Budgets \TAX BUDGET 2012 \Taxbud2012 MK modified (2).xisx 5/16/2011 STATEMENT OF PERMANENT IMPROVEMENTS EXHIBIT IV (Do Not Include Expense to be Paid from Bond Issue) (Section 5705.29. Revised Code) Estimated Cost Amount to be DESCRIPTION of Permanent Budgeted During Name of Paying Fund Improvement Current Year Leisure Time Activities 1,295,000 580,000 Various Various park improvements 7,545,000 1,675,000 Capital Improvements Tax Fund Annual street maintenance 3,235,000 3,235,000 Capital Improvements Tax Fund Various roadway improvements 8,745,000 1,280,000 Capital Improvements Tax Fund General Government Various City equipment 2,250,000 2,250,000 Capital Improvements Tax Fund Other capital improvements 8,790,000 11 1,940,000 IlCapital Improvements Tax Fund TOTAL 11 31,860,000 1 10,960,000 ] M:\FA \Tax BudgabkTAX BUDGET 2012\Taxbud2012 MK modified (2).xlsx 5/16/2011 STATEMENT OF AMOUNTS REQUIRED FOR EXHIBIT V PAYMENT OF FINAL JUDGEMENTS M: \FA \Tax Budgets \TAX BUDGET 2012 \Taxbud2012 MK modified (2).xlsx 5/16/2011 EXHIBIT VI BUDGET YEAR PURPOSE OF BONDS AND NOTES Authority for Levy Outside 10 Mill Limit* Date of Issue Date of Maturity Ordinance or Resolution Serial or Term Rate of Interest Amounts of Bonds and Notes Outstanding Standing at Beginning of Budgeted Year January 1, 2012 Amount Required for Principal and Interest 1/1/12 to 12/31/12 1 11 Amount Receivable from Other Sources to Meet Debt Payments 111/12 to 12/31/12 Payable from Bond Retirement Fund: XXXXXXXX XXXXXXXX XXXXXX XXXXXX XXXXX XXXXX XXXXXXX XXXXXXX XXXXX XXXXX XXXXXX XXXXXX OUTSID 10 MILL LIMIT: XXXXXXXX XXXXXX XXXXX XXXXXXX XXXXX XXXX)0( 0 0 TOTAL to $0 $0 * if the levy is outside the 10 mill limit by vote enter the words "by vote" and the date of the election. If outside the 10 mill limit without a vote, enter the reference to the statute under which the levy is exempt from the 10 mill limit. NOTE: Complete listing of outstanding debt attached. The issue in this exhibit is retired with property tax revenue. M:IFA1Tax Budgets\TAX BUDGET 20121Taxbud2012 MK modified (2).xlsx 5/16/2011