Loading...
Ordinance 034-17Dayton Legal Blank, Inc. RECORD OF ORDINANCES Ordinance No. 34 -17 Passed AN ORDINANCE ADOPTING THE PROPOSED TAX BUDGET FOR FISCAL YEAR 2018 Form No. 30043 ,20 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). [SOW, HEREFORE, BE IT ORDAINED by the Council of the City of Dublin, State of Ohio, of the elected members concurring that: Section 1.. The proposed 2018 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. /' I ILJI. Clerk of Council Ciryof Dublin Office of the City Manager 5200 Emerald Parkway � Dublin, OH 43017 -1090 Phone; 614 - 410-4400. Fax 614 - 410-4490 Toy Members of Dublin City Council From; Dana 1, McDaniel, City Mana Dates May 18, 2017 initiated Bye Angel L. Mumma, Director of Finance David Gaines, Deputy Finance Director Melody Kennedy, Budget Manager Summary Re. Ordinance Na 34.17 — Adapting the Proposed Tax Budget #or Fiscal Year 2018 In compliance with the Ohio Revised Cade (ORC) Section 5705,28, submitted for your approval is the proposed tax budget for fiscal year (FY) 2018 Under state budgetary law, cities in Franklin County must adopt a tax budget far the ensuing year by no later than 7uly 15th of the preceding year. The approved tax budget must be filed with the office of the County Auditor by no later than July 20th, The tax budget is the i:frst legally required step in the annual budget process and represents the City's first estimate of its anticipated financial condition, resources and needs for the coming year. The primary purpose of the tax budget is to demonstrate to the County Budget Commission the City's financial need to levy properly taxes for the coming fiscal year, Once the tax budget is adopted, it will be filed with the Delaware and Franklin County Budget Commissions, Union Caunry does not require the tax budget to be filed with their County Budget Commission. The City's eligibility to receive the State's shared revenue, "'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 any property tax levy assessments outside the ten -mill limitation to verify the appropriate millage for those obligations. The tax budget includes actual revenue and expenditures for the two preceding years (2015 and 2016) and estimates of revenue and expenditures for the current and upcoming year (2017 and 2018) The 2017 estimate is based on the 2017 appropriations approved by City Council on December 5, 2016 (ordinance 56 -16) and includes minor updates for revenue and expenditures that are certain at this time. Pro e Tax Distribution The allocation of the City`s inside millage (also known as "'unvated" millage), a fatal of 1,75 mills, can be adjusted an an annual basis As part of the 2017 — 2021 CIP review, City Council approved the same aNacation where 80% (1,4 mills) of the properly tax revenue from the City's "'inside millage" is allocated to the Capital Improvements Tax Fund, with the remaining 20% (.35 mills) allocated to the Parkland Acquisition Fund, Following is a history of approved allocations. Ord. 34 -17 — Adopting the Proposed Tax Budget for Fiscal Year 2018 May 18, 2017 Page 2 Fiscal Year Millage Prior to 2000 1.17 .5a 1,75 2001 - 2006 1J5 Fund General Fund .08 Safety Fund General Obligation Debt Service Fund Parkland Acquisition Fund 2007 - 2009 .95 Parkland Acquisition Fund ,80 Capital Improvements Tax Fund 1.75 2010-2017 .35 Parkland Acquisition Fund 140 Capital Improvements Tax Fund 1.75 The City has the option to reallocate the tax revenue from the inside millage each year as part of the tax budget process, and then again later in the year when the Resolution Accepting the Amounts and Rates is approved by Council in the autumn. It is important to note that, despite the fact that 20% of the property tax revenue received from the inside millage is allocated to the Parkland Acquisition Fund, the amount allocated within the Capital Improvement Tax Fund may also be used for parkland acquisition and other park - related capital improvements, as well as other capital improvements. In addition to the revenue generated from the City's iJS mills from inside millage, the City also receives revenue from 1,20 mills of outside millage, which is credited to the Safety Fund for police operations. The current effective rates for residential�agriculture and commercial millage is 0.194622 and 0.328208, respectively. For every $100,000 in valuation, those rates translate into taxes of $6.81 for residential /agriculture properties and $11,49 for commercial properties Income Tax On April 20, 2017, the first quarter 2017 financial update was provided to City Council, 1n the 2017 Operating Budget, it was projected that revenue from local income flax would be $84,734,100 with 75% or $63,550,575 programmed in the General Fund and 25% or $21,183,525 programmed in the Capital Improvements Tax Fund. This projection was based on an assumption of a 4 %decrease over the 2016 revised revenue estimate, determined when the 2017 Operating Budget was approved However, the City's actual income tax revenue far 2016 exceeded the revised estimate by 5w1 %. As a result, compared to 2015 income tax revenue, the 2016 collections increased 2,5 %. As reported, income tax revenues through the first quarter of 2017 decreased 1.3 °/0 over the first quarter of 2016, The largest source of income tax revenue, withholding taxes derived from those individuals working in Dublin, decreased 0.8 ° /0, while business net profits increased 68 %and revenue from individual returns decreased 18.9 %. The total income tax revenue collected for the first quarter was $20,991,087. April and October are the two largest months in which income tax revenue is received Through April, year -ta -date income tax revenues were down .40% over the same time period in 2016, Given that staff budgeted an overall decrease of 5.8% over actual 2016 income tax revenue, this relatively minor decrease is not concerning to the overall financial position of the City relative to Ord, 34 -17 -- Adopting the Proposed Tax Budget for Fiscal Year 2018 May 18, 2017 Page 2 the 2017 budget. However, income tax revenues are monitored on a daily basis, If activity in the upcoming months warrants an adjustment to the estimate (up or down), staff will inform Council. General Fund Balance The City's policy is to maintain ayear -end balance equal to or greater than 50% of the General Fund expenditures including operating transfers Based on estimated revenue and expenditures, the 2018 tax budget reflects an estimated 2017 year -end Genera! Fund balance of $59,863,667 and $55,877,766 for 2018, which, as a percentage of General Fund expenditures and operating transfers and advances, equals 78% and 77 %, respectively. When looking at the projected General Fund balance, it is important to remember that these figures assume that all funds appropriated in 2017 and 2018 wi0 be spent, which is never the case. This budgeting method is consistent with the City's past practice of conservatively estimating both revenues and expenditures. Revenues and Ex enditures The proposed tax budget reflects a steady state of City operations. As in the past, income tax, property tax, and charges for services (fees paid to various City departments for permitting and other services rendered per the City's fee ordinance) continue ko be the City's primary source of funding, The 2018 tax budget reflects a prudent 1% rate of growth in revenues with income tax revenue projected at a 1.5% rate of growth. On the expenditure side of the tax budget, in most cases, a modest 1 °/° projected rate of growth has been used to calculate 2018 operating expenditures, A 2 °/n projected rate of growth was used for general operations payroll, and 2,75% was used for police payroll per their negotiated contract for years 2018 (and 2019), While the proposed tax budget for FY 2018 reflects a very precursory review of revenue and expenditures for the upcoming year, staff continues to monitor actual revenue and expenditures for 2017, provide updated reports, and make current and future revenue and expenditure adjustments as necessary. It is important to note that the preparation of the tax budget is done for the sole purpose of meeting the filing requirement for the County Budget Commissions. Finance Department personnel do not involve other departments and divisions in the preparation of this very preliminary budget far a number of reasons, First, in order to meet the deadline imposed by the Budget Commission,. staff would need ko begin working with Departments and Divisions in the first quarter of the year to determine their operational needs for the next fiscal year. Given that the City's fiscal year is the calendar year, there is not sufficient information available that early on ko accurately budget for the following year Additionally, the Ciry's annual Operating Budget, which is submitted to Council in the late October�early November for approval in December, is prepared with all department and division involvement and is a more accurate assessment of anticipated revenues and expenditures for the following year. Each department and division carefully prepares their budget requests for the upcoming year based on the City`s strategic focus areas and the City Manager's priorities. All requests are then complied and measured against the expected resources, As required by the Charter, the City Manager then submits his proposed Operating Budget to City Council, City Council reviews the Operating Budget during budget workshops) held in November before voting on the proposed spending plan during the December meeting, Due to the Ord, 34 -17 — Adopting the Proposed Tax Budget for Fiscal Year 2018 May 18, 2017 Page 2 comprehensive nature of the Operating Budget (bath the preparation by staff and the review by City Council, it is not advantageous to spend a significant amount of time on this very preliminary budget,. Recommen�ativn Staff recommends passage of Ordinance 34 -17 at the second reading�public hearing on June 12, 2017, Attachment For all Adamantine excluding school anNN, this Wal meet be aaoptaa 4y the Igys411ve Wov USOVIII CWndt TwrtMP Tai or Mm general ee er Lasers aW 15th all bm caspin muss be eubmnreb A the Coueiv Realtor on or belle Jun Ma. FAILURE TO COMPLY WITH SECTION 54151& 00.E SEAL RESULT IN LOW OF LOCAL GOVERNMENT FUND SUMMARYOF SCHEDULE AND COUNTY AUDITORS ESTIMATED RATES BUDGET COMMISSION, L or municipal use r budget FUND Denied bnlyNbse funds MIT are requeeiing general proseaytaxrevenue) Budget A Vear Pur Carl of Budget Com mission lwltles Outside Budget Year Par Approved by Budget Com mission Inside 16 Mill Fa Rdtlon County Auditors examine Budget Year Tax Rate to be Levied Par burP tobe DenvWFrom Inside 16 Mill Outside 16 Mlll Levies ON4Ee llln aetl BUpget Lima Budget 10 Mill limitation Vear Year Columns Column 2 Column Column 4 Column 5 GOVERNMENT FUNDS xxxxxxxxx xxxxxxxx xxxxxxxx xxxxxxxx xxxxxxxx GENERALFUND 6 6 6 PouCUSAFETVOPERATING FUND 400,000 B 400,000 PARKLAND ACQUISITION 631,350 631,350 0 CAPITAL IMPROVEMENTS TAX FUND 2,463,500 2,463,500 0 PROPRIETARYFUNDS xxxxxxxx xxxxxxxx xxxxxxxxx xxxxxxxxx xxxxxxxx FIDUCIARVFUNDS xxxxxxxx xxxxxxxx xxxxxxxx xxxxxxxx xxxxxxxx TOTAL ALL FUNDS 3,495,356 3,095,356 466,666 City omubm, Ohio 5n9nnn SCHEDULE B LEVIES OUTSIDE 10 MILL LIMITATION, EXCLUSIVE 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) GENERALFUND: 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 11/1981 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 / / 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 / / 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. M1 FUND, Levy authorized by voters on City of Dublin, Ohio 5/19/2017 FUNDNAME: GENERALFUND FUNDTYPE /CLASSIFICATION: GOVERNMENTAL -- GENERAL This Exhibit is to be used for the General Fund Only EXHI BIT I DESCRIPTION (1) For 2015 Actual (2) For 2016 Actual (3) Current Year Estimated for 2017 (4) Budget Year Estimated for 2018 (5) 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 65,838,948 67,485,222 63,550,575 64,503,750 Other Local Taxes 0 0 0 0 Total Local Taxes 65,838,948 67,485,222 63,550,575 64,503,750 Intergovernmental Revenues State Shared Taxes and Permits Local Government 504,954 334,202 395,220 335,000 Estate Tax 10,786 369 0 0 Cigarette Tax 560 448 425 425 Liquor and Beer Permits 60,393 63,866 60,000 60,000 Gasoline Tax 0 0 0 0 Library and Local Government Support Fun 0 0 0 0 Property Tax Allocation 0 0 0 0 Total State Shared Taxes and Permits 576,694 398,884 455,645 395,425 Federal Grants or Aid 0 0 0 0 State Grants or Aid 0 0 0 0 Other Grants or Aid 0 0 0 0 Total Intergovernmental Revenues 576,694 398,884 455,645 395,425 Special Assessments 0 0 0 0 Charges for Services 1,182,787 822,615 943,000 952,430 Fines, Licenses, and Permits 3,580,849 4,095,567 2,439,270 2,463,665 Miscellaneous 1,103,311 1,178,632 430,500 434,805 Other Financing Sources: Proceeds from Sale of Debt 0 0 0 0 Transfers 0 0 0 0 Advances 24,060,000 11,673,427 11,670,000 30,000 Other Sources (Sale of Capital Assets) 0 0 200,000 0 TOTAL REVENUE 96,342,589 85,654,347 79,688,990 68,780,075 City of Dublin, Ohio 5/19/2017 FUNDNAME: GENERALFUND FUNDTYPE /CLASSIFICATION: GOVERNMENTAL -- GENERAL This Exhibit is to be used for the General Fund Only EXHIBIT I DESCRIPTION (1) For 2015 Actual (2) For 2016 Actual (3) Current Year Estimated for 2017 (4) Budget Year Estimated for 2018 (5) EXPENDITURES XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Security of Persons and Property Personal Services 0 0 0 0 Travel Transportation 0 0 0 0 Contractual Services 232,276 222,732 235,000 237,350 Supplies and Materials 79,096 17,281 125,000 126,250 Capital Outlay 01 0 0 0 Total Security of Persons and Property 311,372 240,013 360,000 363,600 Public Health Services Personal Services 0 0 0 0 Travel Transportation 0 0 0 0 Contractual Services 348,647 369,129 398,000 401,980 Capital Outlay 0 0 0 0 Total Public Health Services 348,647 369,129 398,000 401,980 Leisure Time Activities Personal Services 4,961,611 5,221,522 5,798,690 5,914,665 Travel Transportation 17,596 0 0 0 Contractual Services 1,369,653 1,298,643 1,474,135 1,488,875 Supplies and Materials 382,090 368,9101 446,145 450,605 Capital Outlay 237,308 0 312,650 315,775 Total Leisure Time Activities 6,968,257 6,889,075 8,031,620 8,169,920 Community Environment Personal Services 5,574,988 6,017,208 6,528,605 6,659,180 Travel Transportation 59,945 0 0 0 Contractual Services 605,041 1,128,394 1,323,810 1,337,045 Supplies and Materials 36,341 27,738 70,900 71,605 Capital Outlay 4,784 0 8,825 8,910 Total Community Environment 6,281,099 7,173,340 7,932,140 8,076,740 Basic Utility Services Personal Services 628,478 687,924 771,850 787,290 Travel Transportation 417 0 0 0 Contractual Services 2,294,583 60,823 2,474,805 2,499,555 Supplies and Materials 2,813 1,134 2,240 2,260 Capital Outlay 0 0 r3,,'4149,881 5,125 5,175 Total Basic Utility Services 2,926,291 3,254,020 3,294,280 L - - - i��� City of Dublin, Ohio 5/19/2017 FUND NAME: GENERAL FUND FUND TYPE /CLASSIFICATION: GOVERNMENTAL — GENERAL This Exhibit is to be used for the General Fund Only EXHIBIT I DESCRIPTION (1) E(2) For 2016 Actual (3) Current Year Estimated for 2017 (4) Budget Year Estimated for 2018 (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,918,004 11,385,189 12,724,800 12,979,295 Travel Transportation 262,578 0 0 0 Contractual Services 8,101,927 7,092,872 7,430,030 7,504,330 Supplies and Materials 2,690,758 3,161,636 5,387,310 5,441,180 Capital Outlay 1 190,9801 3,396,929 1,365,125 1,378,775 Total General Government 21,164,247 25,036,627 26,907,265 27,303,580 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 15,780,000 15,870,000 18,540,000 18,540,000 Advances 36,942,000 22,237,177 4,806,000 555,000 Contingencies 140,702 134,063 150,000 150,000 Other Uses of Funds (Refunds /Incentives /Grants) 6,940,683 7,415,206 6,142,450 5,910,875 Total Other Uses of Funds 59,803,386 45,656,446 29,638,450 25,155,875 TOTAL EXPENDITURES 97,803,298 88,514,511 76,521,495 72,765,976 Revenues over /(under) Expenditures (1,460,710) (2,860,164) 3,167,495 (3,985,901) Beginning Cash Fund Balance 61,017,045 59,556,335 56,696,172 59,863,667 Ending Cash Fund Balance 59,556,335 56,696,172 59,863,667 Estimated Encumbrances (2,809,811) (3,561,625) 0 E5577 Estimated Ending Unencumbered Fund Balance 56,746,524 53,134,547 59,863,667 City of Dublin, Ohio 5/19/2017 FUND NAME: SAFETY /POLICE OPERATING EXHIBIT II FUND TYPE /CLASSIFICATION: SPECIAL REVENUE To be used for any fund receiving property tax revenue except the General Fund. DESCRIPTION (1) For 2015 Actual (2) For 2016 Actual (3) Current Year Estimated for 2017 (4) Budget Year Estimated for 2018 (5) REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX Local Taxes 438,598 451,485 400,000 400,000 Intergovernmental Revenue 63,113 88,227 42,500 42,925 Charges for Services 1,654,749 1,732,885 1,690,285 1,707,180 Miscellaneous 17,923 29,745 1,000 1,010 Other Financing Sources: Transfers 10,130,000 10,580,000 11,580,000 12,225,000 Other Sources 0 0 0 0 TOTAL REVENUE 12,304,383 12,882,342 13,713,785 14,376,115 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 11,789,241 1 12,577,439 1 13,607,465 1 13,981,670 Travel /Transportation 136,744 0 01 0 Contractual Services 216,162 179,374 203,300 205,330 Supplies and Materials 89,512 173,354 202,000 204,020 Capital Outlay 16,280 10,673 78,500 79,285 Other Uses(Refunds and other misc.) 3,395 4,206 5,500 5,555 TOTAL EXPENDITURES 12,251,334 12,945,046 14,096,765 14,475,860 Revenues Over (Under) Expenditures 53,050 (62,704) (382,980) (99,745) Beginning Cash Fund Balance Ending Cash Fund Balance Estimated Encumbrances (outstanding at end of year) Estimated Ending Unencumbered Fund Balance 1,501,831 1,554,881 1,492,177 1,109,197 1,554,881 1,492,177 1,109,197 1,009,451 (150,125) (263,099)1 0 0 1,404,756JI 1,229,0771 1,109,197 1,009,451 City of Dublin, Ohio 5/19/2017 EXHIBIT II FUND TYPE /CLASSIFICATION: CAPITAL PROJECTS To be used for any fund receiving property tax revenue except the General Fund. DESCRIPTION (1) For 2015 Actual (2) For 2016 Actual (3) Current Year Estimated for 2017 (4) Budget Year Estimated for 2018 (5) REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX Local Taxes* Property Tax - - Real Estate /Personal Property 2,501,080 2,555,782 2,463,500 2,463,500 Municipal Income Tax (Note 1) 21,945,914 22,495,076 21,183,525 21,501,250 Intergovernmental Revenue 662,581 287,847 250,000 252,500 Fines, Licenses, and Permits 0 0 0 0 Miscellaneous 224,652 382,600 51,000 155,000 Other Financing Sources: Transfers 0 400,000 0 0 Other Sources- Advances 927,975 800,000 533,500 533,500 Proceeds from Bonds 0 0 0 0 TOTAL REVENUE 26,262,202 26,921,306 24,481,525 24,905,750 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 38,837 37,002 39,000 39,390 Capital Outlay 19,379,094 19,884,947 22,565,000 18,525,000 Transfers 2,722,228 3,731,976 3,522,600 3,522,600 Advances 4,691,000 5,355,000 2,015,000 4,275,000 TOTAL EXPENDITURES 26,831,159 29,008,924 28,141,600 26,361,990 Revenues Over (Under) Expenditures (568,957) (2,087,619) (3,660,075) (1,456,240) 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 18,605,685 18,036,729 15,949,112 12,289,037 18,036,729 15,949,112 12,289,037 10,832,797 (12,805,471) (9,707,185) 0 0 5,231,258 6,241,927 12,289,037 10,832,797 Note 1: A portion of this revenue is designated to retire debt for capital improvements. City of Dublin, Ohio 5/19/2017 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 2015 Actual (2) For 2016 Actual (3) Current Year Estimated for 2017 (4) Budget Year Estimated for 2018 (5) REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX Local Taxes- Real Estate 625,237 638,896 631,850 631,850 Intergovernmental Revenue 125,906 121,954 108,000 108,000 Fines, Licenses, and Permits 0 0 0 0 Miscellaneous 5,426 2,412 1,500 1,515 Other Financing Sources: Transfers 0 0 0 Other Sources- Advances 2,015,609 0 0 Proceeds from Bonds 0 0 0 0 TOTAL REVENUE 2,772,177 763,262 741,350 741,365 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 9,714 9,592 10,000 10,000 Capital Outlay 503,977 385,000 401,100 401,100 Transfers 233,445 236,700 238,900 238,900 Advances 400,000 540,000 200,000 200,000 TOTAL EXPENDITURES 1,147,136 1,171,292 850,000 850,000 Revenues Over (Under) Expenditures 1,625,042 (408,029) (108,650) (108,635) 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 45,088 1,670,130 1,262,100 1,153,450 1,670,130 1,262,100 1,153,450 1,044,815 (320,000) (320,000) 0 0 1,350,130 942,100 1,153,450 1,044,815 City of Dublin, Ohio 5/19/2017 EXHIBIT III List of All Funds Individually Unless Reported on Exhibits I and II FUND List All Funds Individually Unless Reported on Exhibit I or II Estimated Jr-encumberec Fund Balance 01/01/18 Budget Year Receipt Total Available Expenditures Budget Year Expenditures and Encumbrances Personal Services Other Total Estimated Unencumbered Balance 12131/18 GOVERNMENTAL: SPECIAL REVENUE: XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Street Maintenance & Repair 7,939 3,752,680 3,760,619 2,377,150 1,381,915 3,759,065 1,554 State Highway Improvement 599,458 120,756 720,214 0 262,600 262,600 457,614 Cemetery 3,340 179,715 183,055 146,805 36,110 182,914 141 Recreation 913,336 8,170,547 9,083,883 5,019,960 3,051,350 8,071,310 1,012,573 Swimming Pool 302,266 920,211 1,222,477 634,560 382,415 1,016,975 205,502 Permissive Tax 797,225 91,405 888,630 0 0 0 888,630 Hotel /Motel Tax 3,096,035 4,196,651 7,292,686 772,260 3,861,970 4,634,230 2,658,456 Enforcement & Education 79,322 1,111 80,433 2,055 0 2,055 78,378 Law Enforcement Trust 2,865 106 2,971 0 0 0 2,971 Mandatory Drug Fine 2,580 15 2,595 0 0 0 2,595 Mayor's Court Computer 18,325 15,175 33,500 1,755 18,685 20,440 13,060 Accrued Leave Reserves 203,450 180,386 383,836 200,000 0 200,000 183,836 Wireless 9-1 -1 System 763,040 373,801 1,136,841 0 80,000 80,000 1,056,841 TOTAL SPECIAL REVENUE FUNDS 6,789,181 18,002,559 24,791,740 9,154,545 9,075,045 18,229,590 6,562,150 DEBT SERVICE FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX General Debt Service 4,511,548 11,115,700 15,627,248 0 11,115,700 11,115,700 4,511,548 Economic Development Bond Retirement 19 1,690,106 1,690,125 0 1,690,106 1,690,106 19 1992 Special Assessment Bond Retiremei 0 0 0 0 0 0 0 2001 Special Assessment Bond Retiremei 185,152 128,150 313,302 0 128,150 128,150 185,152 TOTAL DEBT SERVICE FUNDS 4,696,719 12,933,956 17,630,675 0 12,933,956 12,933,956 4,696,719 CAPITAL PROJECT FUNDS XXXXXXXX XXXXXXXX XXXXXX)CX XXXXXX)CX XXXXXX)CX XXXXXX)CX XXXXXXXX Note: Various construction funds not included. TOTAL CAPITAL PROJECTS 0 0 0 0 0 0 0 PERMANENT IMPROVEMENT FUN XXXXXXXX XXXXXX)CX XXXXXX)CX XXXXXX)CX XXXXXX)CX XXXXXX)CX XXXXXX)CX Cemetery Perpetual Care 1,372,449 33,835 1,406,284 0 0 0 1,406,284 TOTAL PERMANENT IMPROVEMENTS FUN 1,372,449 33,835 1,406,284 0 0 0 1,406,284 EIEIFIMME! City of Dublin, Ohio 5/19/2017 EXHIBIT III List of All Funds Individually Unless Reported on Exhibits I and II FUND List All Funds Individually Unless Reported on Exhibit I or II Estimated Unencumbered Fund Balance 01/01/18 Budget Year Estimated Receipt Total Available For Expenditures Budget Year Expenditures and Encumbrances Personal Services Other Total Estimated Unencumbered Balance 12/31/18 PROPRIETARY: ENTERPRISE FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Water 10,766,095 1,093,325 11,859,420 310,875 2,322,245 2,633,120 9,226,300 Sewer 2,138,188 2,812,744 4,950,932 955,695 1,828,479 2,784,174 2,166,758 Merchandising 28,779 0 28,779 0 0 0 28,779 TOTAL ENTERPRISE FUNDS 12,933,062 3,906,069 16,839,131 1,266,570 4,150,724 5,417,294 11,421,836 11 F— INTERNAL SERVICE FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXX Employee Benefits Self- Insurance 1,138,347 7,434,570 8,572,917 137,425 7,973,995 8,111,420 461,497 Workers Compensation Self-Insurai 185,328 100,000 285,328 0 282,245 282,245 3,083 TOTAL INTERNAL SERVICE FUNDS 1,323,675 7,534,570 8,858,245 137,425 8,256,240 8,393,665 464,579 TRUST AND AGENCY FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Dublin Convention& Visitors Bureau 263,643 1,131,200 1,394,843 0 1,144,330 1,144,330 250,513 Agency(Deposits) 441,285 992,123 1,433,408 0 1,186,295 1,186,295 247,114 COIRS 1,100 266,236 267,336 0 265,125 265,125 2,211 TOTAL TRUST AND AGENCY FUNDS 706,028 2,389,559 3,095,587 0 2,595,750 2,595,750 499,838 000000 TOTAL FOR MEMORANDUM ONLY 26,448,665 44,766,714 71,215,379 10,558,538 37,011,716 47,570,254 23,645,122 City of Dublin, Ohio 5/19/2017 STATEMENT OF PERMANENT IMPROVEMENTS EXHIBIT IV (Do Not Include Expense to be Paid from Bond Issue) Section 5705.29. Revised Code DESCRIPTION Estimated Cost of Permanent Improvement Amount to be Budgeted During Current Year Name of Paying Fund Total Project Cost 2017 -2021 (May Include Other Funding Sources including debt proceeds) 2018 Projects (See Note at bottom of page) CIP - Administration Administration (land acquisition, 9,000,000 1,800,000 Capital Improvements Construction & Parkland Acquisition Fund contingencies, sewer ext.) Municipal Facilities 6,755,000 625,000 Capital Improvements Tax Fund Computer Hardware /Software 6,630,000 950,000 Capital Improvements Tax Fund Fleet Management 7,450,000 1,650,000 Capital Improvements Tax Fund and Water & Sewer, Hotel /Motel CIP - Parks & Recreation Parks 32,490,000 2,480,000 Capital Improvements Tax Fund Cl P - Safety Police 1,465,000 170,000 Capital Improvements Tax Fund /Grant CIP - Sanitary Sewer System Sewer Improvements 18,170,000 3,835,000 Sewer Fund CIP - Stormwater System Stormwater Improvements 4,600,000 575,000 Capital Improvements Tax Fund CIP - Water Distribution System Water Improvements 7,455,000 1,270,000 Water Fund CIP - Transpiration Bicycles and Pedestrians 5,845,000 645,000 Capital Improvements Tax Fund Bridges and Culverts 30,650,000 3,580,000 Capital Improvements Tax Fund Streets and Parking 121,950,000 14,480,000 Capital Improvements Tax Fund TOTAL 252,460,000 32,060,000 NOTE: List does not include GO debt, T1F, Federal or State funded projects or permissive tax funded projects. City of Dublin, Ohio 5/19/2017 EXHIBIT V lsl u,.ary..wU m uuss m� .,fmvm ms $ *TuM r i Mi nl Cl In aw•o+ 1.1 lsl u,.ary..wU m uuss v r ms $ *TuM r i nl vum T 1.1 Mlri. Ie M mum Pm. Ifl urn iono Bum LMAm m.11l6 lubB IF mmhyx.i lm - 1.) � lvm la _ .ABUT evvm !u lvWl �Woow 11159,307 23LW "I NzA ,la®) 411M w mu- n BRl :r bl, a uvr. W um4 tq umiobbtfi lMl¢ o rav w rav w m..m I.l um. (4) � .w Mc 12(1 m (n �� .ew Mco nr. „ RDl � X K3NAAil ya a . Ol 0 b aN. !Em rc mn i