Ordinance 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