2007 Budget
! ~ ' ~ J
wd
MOl\T1CHLO
CITY
OF
MONTICELLO
2007
ANNUAL
BUDGET
City of Monticello
505 Walnut Street
Suite #1
Monticello, MN 55362
(763) 295.2711
MONTICELLO
2007 MUNICIPAL BUDGET
MONTICELLO CITY COUNCIL
Clint Herbst
Wayne Mayer
Glen Posusta
Tom Perrault
Brian Stumpf
Mayor
Councilmember
Councilmember
Councilmember
Councilmember
MONTICELLO BUDGET STAFF
Richard Wolfsteller
Dawn Grossinger
Cathy Shuman
Paula Mastey
Director of Finance
Deputy City Clerk
Senior Finance Officer
Senior Accountant
2005 BUDGET.xls:cc-budgetstaff: 1/8/2007
CITY OF MONTICELLO
TABLE OF CONTENTS
2007 Budget
SECTION I - Introduction
Director of Finance Budget Transmittal Message 1
Council's Resolution AdoptinQ the Budget and Setting the Tax Levy 5
Levy Certification 6
Comparison of Statistical Data 7
Revenue Source Graph 8
Expenditures by Fund Graph 9
Expenditure Summary Graph 10
Expenditures by Activity Table 11
Expenditures by Activity Graph 12
Tax Levy by Fund Graph 13
Combined Statement of Indebtedness 14
Tax Levies to Retire Bonded Indebtedness 15
Projected Revenues and Expenditures Summary 16
Revenue and Expenditure Summary 17
Tax Levy Summary 18
SECTION" - General Fund
Revenue Source Gra h
19
Ex enditure Summar b
20
21
h
22
2006 BudgetT able of contents; 1/8/2007
SECTION 11- General Fund (continued)
Revenue Summary 23
Expenditure Summary 26
General Government
Mavor and Council 28
Administration 29
Elections 31
Finance 32
Audit 34
Assessing 35
LeQal 36
PlanninQ & Zonina 37
Data Processina 39
City Hall 41
Deputv Reqistrar 43
Public Safety
Law Enforcement 45
Fire Department 46
Suildinq Inspections 48
Civil Defense 50
Animal Control 51
National Guard 52
Public Works
Administration 53
Enaineerina 55
Inspections 56
Streets & Allevs 58
Snow & Ice 60
Shop & Garaae 62
Parkina Lots 64
Street Liqhtina 65
Refuse Collection 66
Community Celebrations 68
Health and Welfare
Information Center 69
Senior Center 70
Community Education 71
YMCA 72
Transit - River Rider 73
Swan River School (Rent) 74
Ice Arena 75
Community Development
Economic Development 76
Unallocated 78
Insurance
Unallocated 79
2006 BudgetT able of contents: 1/8/2007
SECTION III. Special Revenue Funds
UDAG 80
Librarv 81
Street Reconstruction Fund 83
HRA 84
Environmental Clean Uo 89
MN Investment Fund 90
SCERG 7 Small Cities Economic Recoverv GranO 91
CMIF (Central MN Initiative Fund) 92
Shade Tree 93
Park Fund 95
Community Center 99
Park! Pathway Dedication Fund 102
Orderlv Annexation Area 104
Caoitallmorovement Revolvina 105
Economic Development Authoritv 107
Sanitary Sewer Access Fund 108
Storm Sewer Access Fund 111
Water Access Fund 113
Transoortation* 115
SECTION IV - Debt Retirement
Debt Service Funds
1171
SECTION V - Enterprise Funds
Water Fund
Revenue/Collection System 136
Sewer Fund
Revenue 139
Plant & Lab -- WWTP 140
Collection Svstems 141
Liauor Fund
Revenue 143
Purchasina 143
Ooerations 143-145
Riverside Cemeterv 146
SECTION VI- Exhibits
Capital Outlay Expenditure Summary 148
Salarv Distribution for 2006 152
Glossary of Selected Terms 155
*Effective 1/1/2004 this fund was changed from an enterprise fund to a special revenue fund.
2006 Budget:Table of conlents: 1/1 0/2007
2007 BUDGET
TRANSMITTAL MESSAGE
To the Honorable Mayor and Council of the City of Monticello:
I hereby submit to you your 2007 adopted municipal budget. This budget document will be used by the City
staff and the Council as a financial guide for governing the daily operations of the City for the next calendar
year. Various capital projects, or development improvement projects not anticipated to be financed by this
budget will be dealt with separately as each case arises, while this document is intended to mainly address the
anticipated day to day operation costs of the City.
The 2007 budget provides funding for our normal service programs, including refuse collection and recycling
services, public safety programs such as police protection, fire protection, building department services and
recreational programs including our community center and park system operations. The City will be continuing
its participation with the River Rider bus program to provide individual transportation needs for our citizens.
Public safety protection will continue with the City contracting with the Wright County Sheriff's Department for
police contract services with an arrangement that will see an additional 8 hours per day of coverage added
starting July 1, 2007, bringing the total contract hours to 18,980 at an estimated cost of $987,000. The hourly
rate will be set at $52.25 per hour with the additional man hours starting in July targeted for traffic enforcement.
The 2007 budget includes funding for continuing technology upgrades within city departments to enhance the
City's ability to provide services and information to our citizens quicker and more efficiently. An example is the
inclusion of $35,000 for development and implementation of GIS enabling the City to utilize the Wright County
parcel data information and aerial photography by compiling data related to specific parcels within our
community in an accessible manner. The City will continue to explore technology improvements within all city
departments to improve the staff s efficiency and to minimize the need for additional personnel as the City
continues to grow.
The 2007 budget has been developed with the goal of reducing the actual amounts of tax dollars being collected
compared to 2006. This is keeping with the trend of the past few years of keeping tax increases to a minimum
whenever possible. In fact, the 2007 budget will result in a tax levy that is $250,000 lower than the 2006 levy or
a 3.7% reduction in dollars to be collected. The average taxpayer should realize a much greater decrease in their
city tax obligation due to the increased market value of the City because of higher property values and increased
commercial and housing developments. The City's tax capacity rate is expected to drop by over 16% because of
our continued growth.
continued growth.
GENERAL FUND OVERVIEW 2007 REVENUES
The 2007 budget proposes revenues totaling $6,292,235. This would provide the City with a fund balance
projected at the end of 2007 at $4,300,000. This projected fund balance would be equal to approximately 68%
of the projected revenues, which continues to provide the City with a healthy general fund reserve account for
unforeseen expenditures and to be used as working capital for future years.
future years.
SOURCES OF INCOME 2007 BUDGET
Property Taxes
Intergovernmental Aid
Permits & Licenses
Fees & Charges for Services
Other
$3,843,555
$ 264,190
$1,158,700
$ 676,450
$ 430,231
EXPENDITURES 2007 BUDGET
The 2007 general fund budget as adopted calls for a total general fund expenditure of$6,668,126. The excess
general fund expenditures will be covered by transfers to the general fund of$80,891 from the EDA fund and
use of $295,000 in general fund reserve balances.
The community center facility, which includes not only the City Hall offices, but also the mu1ti~use Council
Chambers and banquet facility, senior citizen center, gymnasium, swimming pool, teen center, community
meeting rooms and a National Guard complex will be in its 8th year of operation. The facility continues to see
increased participation in programs and services being offered to its residents. The 2007 budget for the center
will be $2,469,465, which not only covers the daily operation expenses but also includes the debt service
requirements for the facility bond of $857,750. In addition to the tax support totaling $388,820 for the
operations, revenue sources include $250,000 from liquor store funds, and $1,000,245 from memberships, room
rental charges and other program activity fees.
ENTERPRISE FUNDS
The 2007 budget document includes enterprise fund activity for water, sanitary sewer and the municipal off~sale
liquor store. These operations are considered to be self.supporting and have contributed funds in the past to the
general fund for special projects and buildings. For 2007, the budget has been prepared based on Council
direction to provide a fee schedule for sanitary sewer and water utility charges that will provide additional
revenue sources generating approximately $210,000. Within the sewer and water enterprise funds, proposed
transfers totaling $667,300 will be made from the enterprise funds to debt service funds to cover a portion of the
scheduled debt service payments that were previously anticipated to be obtained through tax levies. While
increased user fee revenue from sanitary sewer and water utility charges are not anticipated to cover the entire
amount being transferred to debt service, sufficient retained earnings in the enterprise funds will be utilized as
needed to cover any remaining balance.
utilized as needed to cover any remaining balance.
As in past years, infrastructure improvements will be an important priority for the City during 2007 and will
likely include a combination of transportation improvements, utility infrastructure replacement projects along
with the extensions of new utility service lines and roads to new development projects. Feasibility studies
underway or being planned for 2007 include upgrading Chelsea Road East from Fallon Avenue to Country Road
18 to an urban standard to connect to the recently completed improvements related to the CSAH 18/1-94
interchange project.
2
Planning is also underway for Phase VI of the City's Core Street Reconstruction program that may include
substantial reconstruction of the River Street sanitary sewer system to accommodate additional flows to our
wastewater treatment plant. As in the past, development requests for housing and commercial projects will
likely involve City construction of additional extensions to our street and utility systems to meet the growing
demand for new construction. Funding for these projects are typically handled outside of the normal budget
process and could include use of internal funds to finance the project on a temporary basis or will be
accomplished through future bonding authority.
authority.
While 2006 saw a slowdown in housing starts and new development projects, commercial developments such as
the recently opened Home Depot project and the Super Target facility scheduled for completion in March of
2007 are expected to increase the interest in development along the eastern border of Monticello near the new 1-
94/CSAH 18 interchange. This was the largest transportation project spearheaded by the City in recent history
and is expected to have a high impact on future residential, commercial and industrial growth for the community.
The City is optimistic that the current housing and commercial slowdown that has occurred in the past six
months will be short-lived and with continued reasonable mortgage rates, growth will be expected to continue far
into the future.
future.
The budget adopted for 2007 will result in a tax levy of $6,500,000, $250,000 less than in 2006. The City's
overall market value is estimated to grow by $167,000,000, bringing the total market value of the City to
$1,160,000,000. The $167,000,000 in growth consists of $62,000,000 in new construction for commercial,
residential and industrial properties and $126,000,000 in increased market value for existing structures and
property. Part of the increased valuation of existing properties related to the County Assessor increasing values
of commercial and industrial vacant land values to reflect current market conditions with a smaller portion of the
inflationary value related to residential increases. The result of this market value increase will be to lower the
City's tax capacity rate by over 16% from 51.04 to 42.6 in 2007. This should be good news for taxpayers in all
property classes with a combined decrease in tax dollars budgeted for next year and with more taxpayers to help
share in the levy.
levy.
The City's largest taxpayer continues to be Xcel Energy's power plant valuation estimated at over $255,000,000.
This market value results in a tax capacity value for Xcel Energy of an estimated $5,097,000 which equals
approximately 33.4% of the City's overall tax base. Xcel Energy's property taxes have continued to decline over
the past few years and since 2003, Xcel Energy's share of the City's property taxes has dropped from 49% to
33.4%. This a 34.7% drop in their property taxes in just four years.
All indications are that Xcel Energy's share of the property taxes may continue to decline in the upcoming years
as the City continues to increase its tax base through additional housing and commercial development combined
with Xcel Energy's valuation continuing to decline due to Department of Revenue formula adjustments in
determining their value along with depreciation allowed as the plant ages.
allowed as the plant ages.
3
The City's primary source of revenue continues to be the local property tax at 20% of all budgeted revenues or
$6,500,000. Other revenue sources include liquor store receipts of $3,638,000, charges for services such as
sewer and water fees, hookup fees and other area fees for sewer, water and storm sewer at $4,160,000, TIP
revenue of $814,850, special assessment revenues of $2, 157,000 and interest income of $1 ,086,000. These
revenues along with miscellaneous revenues and transfers will provide total revenue from all budgeted
departments exceeding $26,000,000.
Expenditures are proposed to total $26,523,000 after excluding enterprise fund depreciation and any
infrastructure improvements that may require separate revenue bonding sources. Budgeted expenditures for
2007 include funding for an additional community development/administrative position for $80,000 and also
includes Phase VI of our Street Reconstruction Program expenditures of $1 ,250,000. Within our water access
fund, expenditures totaling $230,000 are planned for the painting of the Monte Hill Water Tower and park fund
capital expenditures for improvements and equipment totaling $277,000.
and equipment totalling $277,000.
2007 will be an exciting time for Monticello residents as the City continues to determine whether creation of a
fiber optic network throughout the community is feasible project to undertake. $75,000 is again included in our
2007 budget for costs associated with this fiber optic study but the result could create a new enterprise facility for
the City residents that would enable the community to receive the triple play of video, telephone and internet
service through one package. Development of a fiber optic network along with equipment necessary to provide
the service to our residents would need to be funded through a separate revenue bond financing mechanism
during the year.
The City continues to explore the feasibility of a joint venture with Wright County in developing a regional park
area just outside the city boundary. Both entities are continuing to develop plans for the purchase of over 1,100
acres of lakes, wetlands and wooded area in an effort to preserve the area for future enjoyment of Monticello and
Wright County residents. 2007 will likely see the culmination of the efforts involved to date in establishing this
park.
The 2007 budget will play an integral part in carrying out the long range goals and objectives of the City. Staff
members have put in many hours of research and preparation in assembling this final budget document. With
this budget and community vision policy as our guide, the staff pledges to continue providing a level of service
that citizens have come to expect from the City while providing services in the most cost efficient manner
possible.
Rick W olfsteller
Director of Finance
4
RESOLUTION NO. 2006-98
RESOLUTION ADOPTING THE 2007 BUDGET AND
SETTING THE TAX LEVY
WHEREAS, the Finance Director has prepared and submitted to the City Council a budget setting forth therein his
estimated needs of the City of Monticello for all operations and the debt service for the fiscal year commencing
January 1, 2007 and
WHEREAS, the City Council has reviewed the same and has made such changes therein as appear to be in the best
interest of the City of Monticello;
NOW, THEREFORE, BE IT RESOLVED BY THE COUNCIL OF THE CITY OF MONTICELLO that the budget so
submitted by the Finance Director, together with the changes made therein by the City Council, be and same hereby
is adopted as a budget for the fiscal year commencing January 1, 2007; and
BE IT FURTHER RESOLVED by the Council of the City of Monticello that there be and hereby is levied for the fiscal
year commencing January 1,2007, and the following sums for the respective purposes indicated therein upon the
taxable property of the City of Monticello, to wit:
General
Communit Center
Parks
Libra
HRA
OAA
Tree
Trans ortation
$3,843,555
$1,246,570
$805,545
$36,660
$0
$650
$20,000
$0
The above resolution was introduced by Councilmember Mayer, was duly seconded by Councilmember Stumpf, with
the following voting in favor thereof: Herbst, Mayer, Perrault, Posusta and Stumpf.
The following voting in the opposition: None
The City Administrator is hereby instructed to transmit a certified copy of this resolution to the
County Auditor of Wright County, Minnesota.
Adopted this 13th day of November, 2006.
Mayor
ATTEST:
City Administrator
2007 BUDGET.XLS:Resolutlon
5
<O't:l
o CI)
0'0
~>
..... Ul
M CI)
U ~
Cl)1-
';,~
.Q .-
l:U
...
~
-
~
~
o
i::
~
u:
i::
ffi
o
~
LIJ
....J
....J
~
u:
~
01-
tJ):t:
wt!)o
z-=
Z~CI)
_ CJ
:E .-
.....1:
LL 0 0
O~~
WZ.....
~:J ~
I-O:!::
U)UU
I::
o
01
.S
Q)
Q)
E
rn
(tj
"0
'6 ..
N
Ii '>
-r--.
go
Q)O
I::N
I:: ...
.- rn
:::2: Q)
- >.
......
..c. Q)
01-
'1:: oS:)
~ ~
rn
'0;
Z'-=
I:: ...
:J 0
0.....
U..Q
OW
- u
W:;::;
u I::
':.p 0
:5:::2:
:::2:'0
'OZ'
Z'O
.- Q)
U..c.
Q)-
..c. ...
_ 0
........
o I::
~ .2
'(3 (tj
I:: ><
:J rn
0-
U>'
oS:)
Q)"O
-= Q)
_ l/)
rn .-
..c. ~
~~
'E 0
Q)-
u....
>.1::
oS:) :J
Q) 0
... E
~ rn
_01
I::
.. .;;:
Z'o
1::_
:J-
o.E
U Q)
...... ..r::::
..r:::: ......
.g' ~
5:~
'OeD
o
C:::0
ON
I-C"'i
0.....
:J ffi
<(.0
Q) E
..c. Q)
...... >
o 0
I-Z
I!) 0 0 I!) 0 0 0 0 0
W- I!) CO "<t r--. N 0 I!) 0
I!) CO I!) I!) 0 0 CO 0
II 't:l ("f) eD L()- ~ r-: ci ci
-iii: ~ "<t ("f) 0 ;1; N 0
WUt:CI) (I() (I() "'!. I!)
-aiCl)..J C"'i ..... eD
5.u
Ul
CI)
_r--. ; ~
eO..c. ~
_0_ 0
NO Ul
~
0
-r--.<3
ug<(
-N:t:
_r--.<(
COOt!)
-~..J
L() 0 0 L() 0 0 0 ~ 0
Ul L() CO ;1; r--. N 0 0
- L() CO L() 0 0 CO 0
l: ri eD lri" eD r--.. ci ci
1ii CI) "<t ("f) 0 "<t "<t N 0
_ r--. OJ E (I() (I() N_ I!) I!)
<(O't:lCl) ri ..... eD
-~ ~.!::
CO ~
0-
CI)
D:
....:
... 1ii
...... 2 I:: ..J
:J
't:l 0 I:: 0 Q) ;:
l: Q) U ~
~ Q) ~ u Q)
LL :J c::: I- 0
I:: ~ U E ...... Q) I-
Q) i: E Q) "0 ~
6; ... > ~ rn
.0 Q) rn 0 ..c.
0::: :.::i 0::: a... U Ci5 CI)
I!) 0 0 I!) 0 0 0 0
I!) CO 0 CO r--. 0 0 I!)
w-g~~ 0 CO 0 0 I!) q 0_ CO
N eD lri" ci eD 0 0
-NI-..J ~ ("') <0 GO "<t 0 N
r--. "'!. I!)
ri .....
Ul
CI)
-..... ; ~
cO..c: ~
_0_ 0
NO Ul
CI)
c:::
-r--.<3
ug<(
-N:t:
_r--.<(
COOt!)
-~..J
I!) 0 0 I!) 0 0 00 0
1Il I!) <0 0 <0 r--. 0 OL() 0
- 0 eo 0 0 I!) 0 oeo 0
l: N- eD L()- ci r!j ci 0 0
...... CI)
-..... CI) E "<t ("f) CO GO 0 N g
OJCI) (I() r--. "'!. L()
<(0 't:l ... C"'i eD
_0 .....
N ~ .-
CO ~
CI)
c:::
lU
l:
u::
.....
o
o
N
't:l
CI)
Ul
o
Co
e
0..
r--.
o
o
N
1Il
Q)
><
19
Z'
'I::
o rn
On.
o 1Il
(170
CO
U
1Il
i.L:
...
o
"0
<(
I::
~~
j g
E~
-a 0:::
ffi~
... ...
Q) rn
'aJlt
0:::0
"0>.
Q) I::
gj rn
CD Q)
Q)"O
:J~
CO g
>:;:
...... 0
~ I::
... 0
rno
:::2:~
CO
...
o
~
1ii
'c
'E
~
...-
~
W
1ii
.....
(5
~
.li<:
U
&:
..0
o
o
N
...:
Q)
.0
E
Q)
u
Q)
o
.....
o
>.
rn
"0
..c.
......
("f)
.....
1Il
~
"0
Q)
(tj
o
-e
Q)
~
Q)
..J
n;
<::
i.i:
cij
s:<!
.-:
w
C!l
o
::>
(()
,....
o
o
N
2007 Budget
Comparison of Statistical Data
a
% of total proposed budget representing
total compensation for employees
wa es, salaries, benefits, etc. 15.98% 14.33% 14.39% 11.29%
Total bud et -- all funds $21,825,368 $27,001613 $27582,113 $38,672,981
Total bud eted salaries/benefits $3486,700 $3,868,530 $3,970,640 $4,368,886
b
40 42 44 46
77 68 67 67
5 5 5 5
9 7 8 9
25 25 22
.Classification/FT
- Administration 2 3 3 3
- Finance 3 4 4 5
- Planning/Zoning-Comm. Dev. 2 2 2 1
- Deputy Registrar 3 3 3 3
- Inspections 5 5 5 6
- Public Works Admin./Engr. 2 1 2 4
- Streets 6 7 7 7
- Economic Development 1 1 1 1
- Water 4 4 4 4
. Parks 5 5 5 5
- Community Center 7 7 7 7
. Liquor Store 5 5 5 5
.. Includes 56 @ Community Center
(c) Budget data on independent contractors and consultants.
$48,000 $77,185 $82,500 $100,000
$75100 $95,000 $105,000 $160,000
$350,000 $442,500 $700,000 $111,000
$797 160 $836,580 $876,000 $991,705
$576,500 $591,300 $611,200 $642,300
$33 525 $34,575 $35,000 $36,750
$155,000 $155,000 $158,000 $166,200
$128,000 $85 000 $88,000 $93,300
$44,510 $47,915 $55,625 $56,125
2007 BudgetCompar1son-statistical data
7
REVENUE SOURCES
All Funds, 2007 Budget
Refunds
1.93%
Interest
3.30%
Transfers 33.10%
Inter-Gov't
Taxes
Taxes-TIF
Lie & Permits
Charges
Fines
Transfers
Interest
Mise
Liquor
Refunds
Special Asmts
TOTAL
2007 BUDGETXLS:CharlRevSources
Sp Assmts 6.72%
Inter-Govt .82%
/
Taxes 20.20%
License/Permits
3.69%
Charges
15.78%
$264,190
$6,512,500
$814,850
$1,190,800
$5,085,465
$36,400
$10,669,039
$1,065,110
$172,070
$3,635,145
$621,000
$2,167.476
$32,234,045
0.82%
20.20%
2.53%
3.69%
15.78%
0.11%
33.10%
3.30%
0.53%
11.28%
1.93%
6.72%
100.00%
8
Liquor 9.44 %
Sanitary Sewer 6.09%
Water 3.92%
Debt Service 15.22%
Water Access .80%
EXPENDITURES BY FUND
ALL FUNDS, 2007 BUDGET
HRA 2.31%
Park/Pathway.16%
Capital Imp Revolving 7.26%
Storm Sew Acce
.68%
San Sewer Access
24.74%
General
Library
Street Recon
HRA
Shade Tree
Parks
Community Center
Park Dedication/Pathway
OM
Capital Imp. Revolving
EDA
Sanitary Sewer Access
Storm Sewer Access
Water Access
Debt Service
Water
Sanitary Sewer
Liquor
Transportation
Cemetery
TOTAL
2007 BUDGET.XLS:Chart-Exp Fund
$6,669.435
$38,330
$1,250,000
$892,505
$36,965
$830,605
$2.484.480
$60,000
$15,700
$2,810,000
$1,000
$9,572,300
$262,700
$310,695
$5,888,793
$1,517,815
$2,355,115
$3,653,293
$0
$35,560
$38,685,291
17.24%
0.10%
3.23%
2.31%
0.10%
2.15%
6.42%
0.16%
0.04%
7.26%
0.00%
24.74%
0.68%
0.80%
15.22%
3.92%
6.09%
9.44%
0.00%
0.09%
100%
9
"
o
......
-1;6)
~6)
v. <<.-.
<b~ 6>0
......0 ~o
~6 ~
;.> is'v.
......6) . <i-
'1t& X
......6> 0'11;.
~~ ~
6>" 'It f?'v~
.~ \S'l
~ 6)QI
05'6) /,
z o 96>
0 0 05'& 0,6... 0
00 6)" ......6>
i52 05'& 0,6... ~%
<C
a. 6)" ......6)
:E h 0,6... '1t6)
0 O~ ......6) O'I/,
ul-
>-w 6) '1t6) 01
D::C) ~ 0'1
<Co . Vo -1;&
:!::J f>.i.O'16)o, . ?~~
:Em
::Jt-- ~ O'~ is'
000
0
WN ~ 7
D:: ......~ 0~ /~~
::J
I- v6> ~v. ez:,
is 05'~ v ?p,
z v~ ~ (9,,/.
W
a. <>' . vQ. .~
x <?o ~ 6>0
W ~~ ~'b 1v&
~ <>'
'9&
Vo t-
o
-1;~ 06>c:Y 0
~
"'~ /, ~
/& .'/) 6>6) ,....
i6
"'6> ~O' ell
0 0 0 0 0 0 0 0 v6> E
0 0 0 0 0 0 0 f:>9- \9 E
0 0 0 0 0 0 0 :J
(f)
0 0 0 0 0 0 0 c.
0 0 0 0 0 0 0 x
UJ
0 0 0 0 0 0 0 t
r-... <0 to ">t (") C'\I ~ ell
.c
f:>9- f:>9- f:>9- f:>9- f:>9- f:>9- f:>9- ()
irj
...J
~
I--
UJ
(9
0
~
III
t-
o
0
N
EXPENDITURES BY ACTIVITY
All Funds
2007 Budget
Personal services $4,368,886 $4,269,255 2.33%
Sup lies $684,390 $607,925 12.58%
Small Tools & E ui ment $77,900 $6,900 1028.99%
other services and char es $7,101,733 $1,776,825 299.69%
Capital outla $10,543,195 $5,122,885 105.81%
Debt service $5,888,793 $6,365,793 -7.49%
Transfers between funds $6,895,745 $3,181,925 116.72%
Liquor products $2,769,149 $2,697,075 2.67%
TIF Ex enditures $355,500 $3,525,360 -89.92%
TOTALS $38,685,291 $27,553,943 40.40%
2007 BUDGETXLS:Exp by Activity
11
EXPENDITURES BY ACTIVITY
All Funds, 2007 Budget
Salaries & Benefits
11.3%
Transfer
17.8%
Salaries & Benefits
Supplies
Small Tools/Equip
Other Services
Capital Outlay
Debt Service
Transfer
Liquor Products
TIF Expense
TOTAL
2007 BUDGET.XLS:Chart-Exp by Act
$4,368,886
$684,390
$77,900
$7,101,733
$10,543,195
$5,888,793
$6,895,745
$2,769,149
$355,500
$38,685,291
Supplies
1.8%
Small Tools/Equip
0.2%
11.29%
1.77%
0.20%
18.36%
27.25%
15.22%
17.83%
7.16%
0.92%
100.00%
Other Services
18.4%
12
TAX LEVY BY FUND
All Funds, 2007 Budget
Community Center
19%
Parks
12%
Debt Retirement
0%
Library 1 %
General
Library
OM
Debt Retirement
Transportation
HRA
Parks
Community Center
Shade Tree
Street Reconstruction
TOTAL
$3,843,555
$36,660
$650
$0
$0
$0
$805,545
$1,246,570
$20,000
$547,020
$6,500,000
2007 BUDGET.XLS:Chart-Tax Levy by Fund:1/8/2007
General
58%
58%
1%
0%
0%
0%
0%
12%
19%
1%
8%
13
0 0 0 0 0; 0 0
~ 0 ~ 0 ~ 0
0 0 LO 0
..n- O .0 0
cry CO ;r; <"l
CO (0 <"l
0 ~ en to
cry ~ ~
~
0 M 0 0 ..... 0 <"l
~ ~ (0 0; ~ .....
(0 LO .....
r:t5 r:t5 r:t5 0
<Xl cry 0 0)
<"l. ~ '<l" cry
;;} ~ ~
0 0 0 0 <"l 0 0
~ 0 ~ 0 CO ~ 0
0 0 cry 0
0 0 c<i 0
~ cry r-- cry
;;} (0 a
;;} ~
C/) 0 LO 0 0) r-- 0 LO
C/) ~ cry ~ co (0 ~
cry r-- """: cry
UJ .0 r:t5 <0 ..,f
Z '<l" LO <"l
cry ~ '<l" a
c ~ ~
UJ
t-
m 0 0 0 0 <0 0 0
0 UJ ~ 0 ~ 0 <"l ~ 0
0 0 ..... 0
...J C ..... 0 0 ..... 0
0 0 cry ~ <0
...J Z co <"l
W I ~ ~ ~ ~
- T""
U LL M
i= 0 I
C'\I
Z t- T"" 0 0 0 0 cry 0 0
~ 0 ~ 0 r-- ~ 0
0 z - 0 0 0) 0
" ~ 0 r:t5 0
:!: w (1) ~ co LO
(0 ..... <0
:!: - (\j ~ 0 to
LL W (,) cry ..... ~
0 (1) ~ ~
S '-
~ ~ 0 0 0 0 r-- 0 0
Q. 0 0 0 0 <"l 0 0
C/) - 0 0 0 0 ~ 0 0
u 0 r:t5 <"i g ..... .0 .0
LO 0; cry ;r; co 0
C 0 ~ 0 cry 0)
W .0 .0 .0 ..,f ~ ~
~ <"l ~ ~ ~
z ~
iii 0 0 0
:!: 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 c<i (\j 0 ci g ..n-
U LO 0) C") '" 0 LO
0 LO ~ co r-- C") LO
.0 r:t5 .0 '<i ~ ~
~ LO ~ ;;} ~ ~
~
'" "0 '"
.Y- o
OJ "0 C ~ ~
-0 c 0 0
0 OJ III a.
z III '" 0
a.(\) OJ "0 0 0;
c C :> c: 0
~~ c: ~
OJ OJ OJ .Y- LO
E E > ~ ..... a;
'" ~ ~ :?:'* OJ .0 tl
"0 u u 0:: () <"l
II} c: I OJ ~ ~
"0 0 c: E OJ() OJ ~ a
II}
c: III >< >< -ob CIl E
0 C (\) CIl z'1: OJ 0 "0 m
III ..... ..... ..J c:
c: OJ c: c: c: :> .... 0 i'i)
0 E ,2 ,2 o E 2 "0 III -"
"" II} CiS CiS ""E c: OJ <( E
(\) II) (\)0"0 Q) OJ LO 0
OJ () 0 II
II} := () 5 0 0;
:c .g: :c :c ..c ~ III .... 0 x
0 0 0 .E <"l ;i
~!!!OJ '1: tl '"
f!! ro e! e! :> OJ Ol
!!! g)~ -0
'0 E !!! "0 ::>
OJ OJ OJ OJ :g E ~ E C :> al
c: c: c: U '"
OJ 1[> OJ OJ OJ OJ OJ 0 0 c: 0
(') (') (') (').....0:: () () .- ?il
'<l"
.....
ll)
.....
co M M 10 ..... M M 10 ..... M M M ..... 0 0 0
10 .., .., 0 M .., 0) 0 CO 0) ~ 0) .., 0 0 0
.., It'!. C'l .., .., C!. ..... ~ 0) M CO M ~ M It'!.
iii ..... N ....: ai 0 ..," ..... 0 M ..; iii ..; ..... ai ....
10 M 10 .., 10 M .... ~ .... 10 C'l M 10 C'l .... ~
.., 10 ..... ..... CO ~ CO 10 "'t ~ ~ ..... ~ ~
N N N C'l" N C'l N N N .... .... .... ~ ~
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
C\I C\I ~ CO CO q q 0 ..... ll) ..- ~ C\I. ~ M Ll:!.
u) ,...: ri ,...: q:j 0> ..- ,...: N ri ~ "<i M ..- m .....
M ..... 0> CO CO ..... 0> CO '<t '<t ll) C\I C\I ..... C\I
~ ..... C\I C\I C\I C\I C\I C\I C\I C\I C\I C\I C\I C\I C\I C\I
~ ~ ~ ~ ~ ~ ~ ~ ~ W- ~ ~ ~ ~ ~
CJ)
CJ)
W
Z 0 0 0 0 0 0 0
0 0 0 0 0 0 0
C 0 CO ll) M C\I ..... '<t
q:j "". ,...: m ci 0 m
W ..... ..... ..... ..... CO CO .....
I- ..... ..... ..... ..... ;; ..... .....
~ ~ ~ ~ ~ ~
OJ
w
C
Z 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 ~ ~ ~ ~ ~ ~ ~ ~
C '<t. C\I 0 ..... M
M "<i u) u) q:j
W C\I C\I C\I C\I C\I
C ~ ~ ~ w ~
0 Z
...J 0 co
...J c
W OJ c
CJ W N ll) 0 0 M CO 0 0 M CO 0 0 0 0
..... ll) ll) ..... M ll) 0 ..... CO ~ ~ ~ ~
i= ~ "" ..... ...... ~ C'l q CO .....
'"" C\I. ,...: u) ..... 0 ..... ..... N ,...:
z i= ('i') M ll) ll) ll) ~ ll) M 0> ll)
CO CO CO CO ...... ...... '": o. q
0 W .... ~ ~ ~ w ..... ..... ..... ..... .....
Go) ~ ~ ~ ~ ~
:E ~ .c
LL. 0 E
0 I- Go) 0 0 0 0 0 0 0 0 0 0 0 0 0
~ CJ) 0 0 0 0 0 0 0 0 0 0 0 ~ ~ ~
Go) M M '<to ..... C\I ""':. C\I ..... CO CO
W C q:j ri ll) ,...: ri 0 ci m cO ,...:
M M M M M M M C\I C\I C\I
CJ :> ..... ~ ..... ..... ..... ..... ..... ~ ..... .....
* ~ ~ ~ ~ ~ ~ ~
W
...J
~ 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 ~ ~ ~ ~ ~ ~ ~ ~ ~
CO C\I. M .....
C ci C\I M. "<i
CO CO CO CO
W ..... ..... ~ ;;
~ ~
...J
::J .....
C <:::>
<:::>
W (::!
!!;>
:I: M M M M M M M M M M M M .....
0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> 0> '<t ...,
U C\I. C\I. C\I. "'- C\I C\I. C\I "'- C\I. "'- C\I. C\I ..... .0
(ll
C\I ~ C\I C\I N C\I N C\I ~ C\I C\I N ..... Cl
CJ) CO CO CO CO CO CO ex) CO CO CO "" ~
o. q q q o. q q o. o. q q q ll)
..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ~ ~
~ ~ ~ ~ w ~ ~ w- ~ ~ ~ ~ "'
(ll
"S:
(ll
...J
><
10 ..... CO 0) 0 ..... C'l M '<t 10 10 ..... CO 0) 0 .... (Il
I-
0 0 0 0 .... .... .... .... .... .... .... ..... .... .... C'l ('II {rj
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ...J
('II ('II C'l ('II ('II ('II ('II ('II ('II C'l C'l ('II ('II ('II ('II ('II X
~
(!)
Cl
10 10 ..... CO 0) 0 .... ('II M .., 10 10 ..... CO 0) 0 .... =>
0 0 0 0 0 .... .... .... .... ..... .... .... .... .... .... ('II ('II al
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .....
('II ('II ('II ('II ('II C'l ('II ('II ('II ('II ('II ('II ('II C'l C'l ('II ('II 0
<:::>
'"
SUMMARY OF PROJECTED REVENUES,
EXPENDITURES AND FUND BALANCES
(Cash & Investments)
; ,'II'" , ,.1 , I I
,
~_c 'i1':O I ,~; , l~iY( I'~I' 'ii:," , I,
'-'" ~1 i ,
".;'1/ ~J:- .. J I)- ~ II I , I
I , " , '. "!'Il':rl~l;:l>' ",
...... ,j," ., " '" ..
Parks Fund $568,650 $830,605 $830.605 $568.650
Park Dedication fund $713.800 $145,365 $60.000 $799,165
General $4,545,882 $6,373.126 $6,669,435 $4,249,573
Library $13,500 $38,360 $38,330 $13,530
Tree $26,400 $22,745 $36,965 $12,180
OM $9,500 $15,700 $15,700 $9.500
Water $1,628,000 $869,385 $1,070,169 $1,427,216
Water Access $346,080 $361,000 $310,695 $396,385
Sewer $1,916.500 $1,439,690 $1,344,318 $2,011,872
Sewer Access $7,076,190 $7.365,980 $10,288,800 $4,153,370
Transportation $0 $0 $0 $0
Liquor $1,842,800 $3,638,865 $3,653,293 $1,828,372
Capital Outlay Revolving $4,771,800 $735,913 $2,810,000 $2.697,713
HRA $1.084,175 $853,710 $883,740 $1,054,145
Minn. Investment Fund $975,200 $25,665 $0 $1,000,865
EDA $1,555,100 $42,945 $1,000 $1,597,045
SCERG $16,230 $570 $0 $16,800
CMIF $2,975 $105 $0 $3,080
Storm Sewer Access $1,305,380 $445,745 $262,700 $1,488,425
Cemetery $66,300 $35,575 $35,560 $66,315
Community Center Fund $272,050 $2,496.815 $2,496,815 $272,050
Street Reconstruction Fund $28,000 $1,243,050 $1,250,000 $21,050
s.ualt,~~.l,\tS::~ll!j,!IB;Wi;':ii::i,;,,;~,,""ij~I~,iJ~~~M,1~~,:l,.' """'I'\i~~i~~8":7,64""'51'2 ~~[~lllt{llIlI!llll~!$~$;:!l80~91..,~ 1:'i~i\1!1:\'ti{Wj,$$2,;058!125 23i6$1Iili~Q:~~III!
!,~h"'::i",J{~t,'f.:" ,', """",,,,,::,,,'~:,:,,,,'t.,,: ';., ,i )l, ,':"
Debt Service
General Obligation Bonds $123,791 $1.085,293 $1.082,293 $126,791
Special Assessment Bonds $7,331,519 $4,772,638 $4,636,800 $7,467,357
Tax Increment Bonds $1.071,932 $165.200 $169,700 $1,067,432
"QE$mJii$ERVI~I;ilSUBJOiJiA!S!il!'~~.":/I:lll',il!lll!ji~l~~'~i!$8;527J~2~2,: illllll!I~~ii$6;,QI~ilil!l!niiil'lj~'II,I!$511~~a~~,93 _$~~'S$1:~'580
TQT,Ji.I"C!'!~I'II'~I"!""'l'" '
:r,~~::",:' ",,;i:i~l~~,!;;.(;liU~1:~ !H,:d-i.~~j~0f,.~
2007 BUDGETXLS:Summ of Proj Rev:1/8/2007
16
REVENUE AND EXPENDITURE SUMMARY
2007 Budget
, ~r ,jl\:' "
''IlIfj" "~"" I ~:, ..... a ."".
I " , ,;\8- I "-I~ " 'm.
General $6,394,097 $8,041,215 $6,373,126 $6,669,435
Parks $797,825 $1,227,125 $830,605 $830,605
Park Dedication $109,205 $50,000 $145,365 $60,000
Library $37,960 $37,960 $38,360 $38,330
Transportation $16,000 $16,000 $0 $0
Shade Tree $33,210 $33,210 $22,745 $36,965
Community Center $2,053,095 $2,045,475 $2,496,815 $2,484,480
DTED Clean Up Fund/Envir $0 $0 $0 $0
OM $7,100 $7,100 $15,700 $15,700
HRA $760,100 $891,565 $853,710 $892,505
Minn. Investment Fund $26.015 $0 $25,665 $0
EDA $38,970 $1 ,000 $42,945 $1,000
SCERG $660 $0 $570 $0
CMIF $210 $0 $105 $0
Debt Service $4,440,560 $5,426,218 $6,023,131 $5,888,793
Liquor $3,608,345 $3.539.200 $3,638,865 $3,653,293
Water $538,312 $884,625 $749,385 $1.517,815
Sewer $994,640 $1,947,045 $1,439,690 $2,355,115
Cemetery $31,000 $33,975 $35,575 $35,560
Capital Improvements $626,925 $545,200 $735,913 $2,810,000
Water Access $491,726 $567,410 $361,000 $310,695
Storm Sewer Access $359,339 $269,800 $445,745 $262,700
Sanitary Sewer Access $1,669,641 $1,267,990 $7,365,980 $9,572,300
Streeet Reconstruction Fund $546,135 $750,000 $593,050 $1,250,000
:17Q;J1.<<\i.:.liIIJrr . ,.....$23581 :OlO l~i!m'llii~ilill$;~rz!rfia2:lIi~!!~~:II, _O;:(5!1!11!!"$~$.r685'2$1J'"
';':-;';;:,'((;:r;::;:: '~' " ~: :,'_. ,:. :';:" :'~:. .< .~I :1:::':,:"."" .,::j ',"", ::1":,' , " :. ,,,. """ -, , ' "',, ., .",-""'
COMMENTS:
(A) includes $1,010,797 Depreciation -- Sewer
( B ) includes $447,646 Depreciation -- Water
*Includes $8,490,000 for WWTP Improvements
** Includes Otter Creek Ind. Park Grading -
** Includes Dalton Ave/School Blvd. -
** Includes Cedar SUDundas Rd -
$365,000
$1,000,000
$850,000
2007 BUDGETXLS:Rev & Sum:1/8/2007
(B)
(A)
**
*
17
TAX LEVY SUMMARY
2007 Budget
All Funds
Net Certified Levy Decrease/Increase
Maximum Lev Allowed
$0
N/A
Payable 2002 Tax Capacity Rate
Payable 2003 Tax Capacity Rate
Payable 2004 Tax Capacity Rate
Payable 2005 Tax Capacity Rate
Payable 2006 Tax Capacity Rate
Est. Payable 2007 Tax Capacity Rate
$805,545
$3,843,555
$36,660
$0
$20,000
$650
$0
$0
$0
$1,246,570
$547,020
.,$61:5001'000
3.70% ($250,000)
67.645
65.558
62.452
58.760
51.040
42.603
2001/Pa able 2002 $9,606,212 67.645 $6,498,079
2002/Pa able 2003 $10,344,950 65.558 $6,782,018
2003/Pa able 2004 $11,141,052 62.452 $6,957,915
2004/Pa able 2005 $11,840,000 58.76 $6,957,915
2005 Pa able 2006 $13,224,144 51.04 $6,750,000
Est. Pa able 2007 $15,256,892 42.603 $6,500,000
COMMENTS:
*Community Center budget levy includes $857,750 for debt service
and $388,820 operations
Maximum levy without a pUblic hearing being required:: $7,183,262
2007 Budget.xls:Tax Levy Sum:1/8/2007
18
REVENUE SOURCES
General Fund, 2007 Budget
Fines
0.38%
Transfer
1.27%
Refunds
0.41%
Fines
Refunds
* Tax
Lie & Permits
Interest Income
Inter~Gov't
Transfers
Mise
Charges
TOTAL
$24,000
$26,000
$3,856,055
$1,158,700
$239,780
$264,190
$80,891
$47,060
$676.450
$6,373,126
0.38%
0.41%
60.50%
18.18%
3.76%
4.15%
1.27%
0.74%
10.61%
100.00%
*Includes delinquent taxes/penalty.
2007 BUDGETXLS:Chart-Rev Sources: 1/8/2007
Tax
60.5%
19
EXPENDITURES BY ACTIVITY
General Fund, 2007 Budget
Supplies
5.00%
Personal Services
35.30%
Capital Outlay
8.63%
Supplies
Other Services
Capital Outlay
Transfers
Personal Services
TOTALS
$333,625
$3,405,920
$575,845
$0
$2,354,045
$6,669,435
5,00%
51.07%
8.63%
0,00%
35,30%
100.00%
2007 BUDGET.XLS:Chart-Exp,Gen. Act.:1/8/2007
Other Services
51.07%
20
EXPENDITURES BY DIVISION
General Fund, 2007 Budget
Health & Welfare
2.82%
Public Works
34.95%
Comm Dev
1.19%
General Gov't
Misc
Comm Celebrations
Pu blic Safety
Transit
Community Dev.
Public Works
Health & Welfare
TOTAL
2006 BUDGET.XLS:Chart.Expend by Div:1/8/2007
Misc
2.74%
Comm Celebrations
0.16%
Public Safety
28.86%
$1,924,700
$182,470
$10,700
$1,930,150
$23,500
$79,070
$2,330,730
$188,115
$6,669,435
28.86%
2.74%
0.16%
28.94%
0.35%
1.19%
34.95%
2.82%
100.00%
21
'"
o
o
....
OJ
c
8
m
-i
X
!n
t(1
."
en
<:
3
3
G-l
(J)
"
."
<:
"
"-
o
",'
0>
j;3
8
...,
N
N
S:OOI-i-o-oG)
iii' 0 0 CD Ql c C CD
o33~iilg;g;ffi
3 3 ::T _. 0 0 ::"!
c. "".....:;:(IJe!..
:!. 0 <;: 0 III ^
-<"9!.<;: al'~
ofg.9!. ~-<"<;.
CD~Dl' .....
<: III ~
gCD
:>
fJ)
~; Y> rs~~
o")~~.ffi---:a.'6'lWCOCD
C>>CO-..j-'CONWWN
50 N 50 .0 .co !A .0 !=> .~ N
~~O-..j-'01-..j-'-..jO
W-..j-..jO-'OW0100
01000010000-..j
~f Y> rs~~
WWEf> -' m0101
C>>C>>-..jEf>CO m~N
.-..j 01 .C>> .01 .w .co .-' 9' N
N~<OO1-' C>>C>> 0
-'~<OO~Y>NN80
01000000010C>>
~
~ '0
o 0
o 0
'0 '0
Y> 0 0
000
......-----1......------L...
G)
(J)
"
G)
~
.
N
o
o
-.....J
II
N
o
o
0'>
-u
<:
C"
i'i'
~
(;'
.:;t
;E"'Il
" <:
~ C"
~lif
--j
OJ
"
g:,
.$23,50C
11$0
:;::t:
m,!l
III -
~ ".
(J) Ilo
.$188,11E
1I$183,14C
()
ib'
OJ 3
'"'3
;
.$10,70C
1I$5,50C
()
o~
(J) 3
< <:
"
~
;::
1);'
f'
~
<.n
o
o
'0
o
o
_-----L.....
Y> Ef> Y>
NNW
'0 <.n '0
000
000
'0 '0 '0
000
000
.~-.'-.~._...J
.$1,930,15C
liJ$2,668,62C
mm
'<><
0""0
_. m
< Z
~: 2
o -I
:J c:
c,::tJ
CD m
:J en
CD c:
QJ 3:
-s:
">
s::: ;;0
a-<
GENERAL FUND SUMMARY
2007 Budget
REVENUE
101.31011
101.31021
101.31031
101.31920
101.31910
101.32111
101.32112
101.32113
101.32199
Licenses and Permits - Non-Business
Buildin Permits
Variances/Conditional Uses
Gradin Permits
Mobile Home Permits
Si n/Banner Permits
Animal Licenses
Fiber Optic Franchise Fee
Other Non-Business License & Permits
Electric Franchise Fee
...."I'!:......::..,,'. .. S:l!ll~:I..'ft
"':\l~:::~, ; "..~,'i~':,I7:
1 01.32211
1 01.32212
101.32215
101.32221
101.32222
1 01.32241
1 01.32263
1 01.32299
1 01.34970
<;i/~~:. .~' i ".;'/.::,;':':.i;",.,
$31,450
$1,500
$0
$2,800
.$llZ'O
$775,000
$4,000
$0
$0
$500
$275
$500
$3,000
$0
'/":'::'::""":",>'lI!."';.-"!".,',..'
,::f+:<:.',':,;: :.:- '.'. .,)P:f':;Y,i)f4i:t:::,:
$825,000
$4,100
$0
$300
$5,000
$500
$500
$2,200
$275,000
:1~:2'
101.33401
101.33402
101.33403
101.33404
101.33408
101.33410
101.33420
101.33421
101.33499
101.33610
101.33620
101.36210
$0
$0
$0
$6,740
$15,000
$77,450
$96,500
$46,000
$0
$11,500
$0
$11,000
,UtO'
Aid
2007 BUDGET.XLS:GenFundSumRev:1/8/2007
23
h
GENERAL FUND SUMMARY
2007 Budget
C araes for ServIces
ZoninQ/Subdivision Fees 101.34103 $11,652 $3,000
Sale of Maps & Publications 101.34105 $250 $0
MV license sales/Deputy Reg. 101.34106 $268,000 $285,000
Assessment Searches 101.34107 $10,250 $10,000
Planning Administration 101.34122 $77,000 $100,000
NSF Check Fee 101.34198 $0 $100
Inspection Fees 101.34204 $85,000 $90,000
Assessor Fee 101.34205 $5,000 $5,000
Fire Protection Township Contract 101.34206 $45,675 $50,250
Fire Emergency Response Calls 101.34207 $2,000 $4,500
Fire ~ Other Fees 101.34208 $0 $1,000
Blight Mowing Fees 101.34210 $300 $800
Junk Amnesty Fees 101.34407 $7,000 $8,500
Special Garbage Proc/Recycle 101.34408 $2,700 $2,800
Garbaqe Charqe 101.34409 $50,000 $68,500
Garbage Cart Rental 101.34410 $38,500 $46,000
Park Rental Fees 101.34780 $0 $0
Construction Cost (Reimbursement) 101.34960 $515,000 $0
Other CharQes for Services 101.~ $1,000 $1,000
. ...ij;~HAR,<P&S\f'ARSIRYICB$ ...ii I'~ ~.~.'tilO;12.~"<""'."~
Miscellaneous Revenue
Interest Earninqs 101.36210 $175,500 $220,150
Interest EarninQs~Anderson 101.36215 $5,295 $5,300
Interest Earnings-Arop/ax 101.36214 $3,485 $3,035
Interest Earnings - Swan River 101.36217 $11,635 $11,295
Renta/ of Property 101.36220 $12,615 $38,260
Rental of Equipment 101.36221 $0 $0
Contributions - Private 101.36230 $7,500 $0
Sale of City Property 101.36240 $500 $1,000
Misc Items for Resale 101.36249 $0 $0
Lock (Fire) Boxes 101.36242 $750 $800
Signs & Install (New Plats) 101.36243 $0 $0
Other Miscellaneous Revenue 101.36299 $6,800 $7,000
rGr~l;.MI$C~-N$GUsRe~eNlI ................//3...... I...................~Q$O I....... . .... lIivH6j4J40
2007 BUDGET.XLS:GenFundSumRev:1/BI2007
24
GENERAL FUND SUMMARY
2007 Budget
101.39203
1T'~TAU'~NEMI..!f:!"M':~Q8'::'i'i'i>;;]"'.i:!;;')?I';;;!':"'"i"(:."!'+~',Z.m;:,:r,:gl'!'. .,;c.:'..:$$tUfiWl.J:;i..;:.!!. .'."',3~$;~.~1
2007 BUDGETXLS:GenFundSumRev:1/8/2007
25
GENERAL FUND SUMMARY
2007Budget
EXPENDITURES
2006
$41,455
$290,585
$246,475
$38,900
$66,665
$297,730
$55.625
$214,150
$126,710
$106.040
$20,080
$21,485
o
Public Safet
Law Enforcement
Fire
Buildin Inspections
Civil Defense
Animal Control
:J;Oil:'l$;i~UBCIQiiSAFE,
$94,915
$18,200
$0
$75.000
$0
i :'$,~ 88;'~it5'
2007 BUDGET.XLS:GenFundSum-Exp:1/8/2007
26
GENERAL FUND SUMMARY
2007Budget
$20,530
$161,940
$0
!,iS82141i(li
T0J1~I:J:;GENEMI4;.Fi\Il~DI.E}(eE;;NDI]QBE;;Sii;i!i~1~~I~..
2007 BUDGETXLS:GenFundSum-Exp:1/8/2007
27
GENERAL FUND
2007 Budget
Mayor and Council
Personal Services
Salaries, Ful/- Time - Re
Salaries, Other
PERA Contributions
FICA Contributions
Medicare Contributions
101.41110.1010
101 .41110.1090
101.41110.1210
101.41110.1220
101.41110.1250
$22,200
$1,700
$1 ,000
$800
$360
Services & Char es
Printed Forms & Paper
Meetin Supplies
Misc Office Supplies
Misc Professional Services
Misc Communication
Travel Expense
Conference & Schools
Dues, Membership & Subscriptions
Books & Pamphlets
Misc Other Ex ense
Furniture & Fixtures
101.41110.2030
101.41110.2075
101.41110.2099
101.41110.3199
101.41110.3299
101.41110.3310
101.41110.3320
1 01 .4111 0.4330
101.41110.4350
101.41110.4399
101.41110.5601
$0
$0
$0
$0
$0
$500
$750
$7,905
$0
$1,500
$0
COMMENTS:
Misc Other Expense: $1,000 for Employee Picnic/Christmas Gathering
2007 BUDGET.XLS:Gen Fund.May&Cou:1/8/2007
28
GENERAL FUND
2007 Budget
Administration
Personal Services
Salaries, Full-Time - Re
Salaries, Full-Time - OT
Salaries, Part-Time - Re .
Salaries, Part-Time ~ OT
Salaries, Temporar - Re .
Salaries, Tempora - OT
Salaries, Other
Severance Pa
PERA Contribution
ICMA Insurance Contribution
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
Flexible S endin Benefits
101.41301.1010
101.41301.1020
101.41301.1030
101.41301.1031
101.41301.1040
101.41301.1050
101.41301.1090
101.41301.1110
101.41301.1210
101.41301.1211
101.41301.1220
101.41301.1250
101.41301.1310
101.41301.1315
$175,100
$0
$7,650
$0
$1 ,000
$0
$0
$4,200
$11,485
$0
$11,395
$2,665
$27,230
$425
Sup lies
Du licating & Co Supplies
Printed Forms & Paper
Misc. Office Supplies
Motor Fues
Misc 0 eratin Supplies
Small Tools/Misc.
Maps
101.41301.2020
101.41301.2030
101.41301.2099
101.41301.2120
101.41301.2199
101.41301.2410
101.41301.2580
$0
$0
$0
$0
$125
$0
$0
S &Ch
ervlces arges
Software 101.41301.3091 $0
Maintenance Agreements 101.41301.3190 $2,000
Newsletter 101.41301.3195 $0
Misc. Professional Services 101.41301.3199 $11,000
Telephone 101.41301.3210 $0
PostaQe 101.41301.3220 $4,500
Delivery Mail Service (UPS) 101.41301.3240 $0
Travel Expense 101.41301.3310 $2,375
Conference & Schools 101.41301.3320 $3,500
Misc Transportation 101.41301.3399 $0
Advertising 101.41301.3499 $0
General Public Information 101.41301.3520 $0
Misc General Insurance Bond 101.41301.3699 $0
Repair & Mtc. - Machinerv & Equipment 101.41301.4044 $0
2007 BUDGET.XLS:Gen Fund-Admin:1/B/2007
29
GENERAL FUND
2007 Budget
Administration
101.41301.4160
101.41301.4330
101.41301.4350
101.41301.4393
101.41301.4395
101.41301.4399
$0
$1,060
$100
$5,000
$0
$200
101.41301.5601
101.41301.5701
101.41301.5702
COMMENTS:
Salaries:
100% Dawn, Cathy K., 50% Jeff, 30% Carolyn, 50% of Asst. Admin (new)
2007 BUDGET.XLS:Gen Fund-Admin:1/8/2007
30
GENERAL FUND
2007 Budget
Elections
Personal Services
Salaries, Tempora
FICA Contributions
Medicare Contributions
101.41410.1040
101.41410.1220
101.41410.1250
$1,000
$0
$0
101.41410.2030
101.41410.2070
101.41410.2099
101.41410.2199
101.41410.2472
$0
$0
$0
$0
$0
Services & Char es
Maintenance A reements
Misc. Professional Services
Travel Expense
Conference & Schools
Le al Notice Publication
Equi ment Rental
Mise Other Expense
Office Equi ment
101.41410.3190
101.41410.3199
101.41410.3310
101.41410.3320
101.41410.3510
101.41410.4150
101.41410.4399
101.41410.5701
$0
$0
$0
$0
$0
$0
$0
$0
2007 BUDGET.xLS:Gen Fund-Elections:1/8/2007
31
GENERAL FUND
2007 Budget
Finance
Personal Services
Salaries, Full-Time - Re
Salaries, Full-Time - aT
Salaries, Part-time - Re
Salaries, Part-time - aT
Salaries, Tem ora - Re
Salaries, Temporar - aT
Salaries, Other
Severance Pa
PERA Contributions
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
Flex Benefits
U.C. Benefit Pa ments
101.41520.1010
101.41520.1020
101.41520.1030
101.41520.1031
101.41520.1040
101.41520.1050
1 01 .41520.1 090
101.41520.1110
101.41520.1210
101.41520.1220
101.41520.1250
101.41520.1310
101.41520.1315
101.41520.1420
$238,300
$16,000
$1,000
$0
$0
$0
$2,100
$0
$15,955
$15,830
$3,700
$23,215
$450
$0
101.41520.2030
101.41520.2099
101.41520.2199
101.41520.2299
Small Tools and Equipment
Small Tools/Misc.
T&E Machiner
T &E/F urniture
T&E/Office Equi ment
T&E/Computer E uipment
T &E/Other
101.45120.2410
101.45120.2440
101.45120.2460
101.45120.2471
101.45120.2472
101.45120.2499
$0
$0
$0
$0
$1,500
$0
5 &Ch
ervlces arges
Prof. Services - Data Processing 101.41520.3090 $0
Prof. Services - Maintenance Agreements 101.41520.3190 $375
Misc. Professional Services 101.41520.3199 $0
Travel Expense 101.41520.3310 $1 , 1 00
Conference & Schools 101.41520.3320 $3,540
Legal Notice Publication 101.41520.3510 $0
General Public Information 101.41520.3520 $1 ,000
Misc. Printing 101.41520.3599 $0
2007 BUDGETXLS:Gen Fund-Finance:1/8/2007
32
GENERAL FUND
2007 Budget
Finance
Dues, Membership & Subscri tion
Spec Assessment Fees - Count
Refunds/Reimbursements Out
Bank Char es
Mise Other Expense
101.41520.4330
101.41520.4335
101.41520.4395
101.41520.4398
101.41520.4399
$160
$3,500
$0
$12,000
$150
COMMENTS:
Salaries:
100% Annie, Cathy, Paula, Rick, 30% Carolyn
2007 BUDGET.xLS:Gen Fund-Finance:1/8/2007
33
GENERAL FUND
2007 Budget
Audit
Services & Char es
Prof Services - Audit
Misc. Other Expense
2007 BUDGET.XLS:Gen Fund-Audit:1/8/2007
34
GENERAL FUND
2007 Budget
Assessing
Su plies
Printed Forms & Paper
Misc. Office Su lies
Misc. Operating Sup lies
Small Tools & Equipment
101.41550.2030
101.41550.2099
101.41550.2199
101.41550.2410
$0
$0
$0
$0
Services & Char es
Prof. Services - Assessin
Telephone
Travel Ex ense
Conference & Schools
Le al Notice Publication
General Public Information
Dues, Membershi s & Subscriptions
101.41550.3125
101.41550.3210
101.41550.3310
101.41550.3320
101.41550.3510
101.41550.3520
101.41550.4330
$56,125
$0
$0
$0
$0
$0
$0
COMMENTS:
Professional Services: Assessing Contract - Wright County Assessor
4800 parcels @ $10.50
New Construction - Houses 150 @ $25
New Construction - Commercial 3 @ $25
New Construction - Commercial 19 @ $100
2007 SUDGET.XLS:Gen Fund-Assessing:1/8/2007
35
GENERAL FUND
2007 Budget
Legal
Services & Char es
Prof. Services - Le al Fees
Prof. Services - Le al Fees Reimbursement
Misc. Professional Services
Le '-11 Notice Publication
Dues, Memberships & Subscriptions
Misc. Other Expense
101.41601.3040
101.41601.3045
101.41601.3199
101.41601.3510
101.41601.4330
101.41601.4399
$30,000
$0
$0
$30,000
$16,915
$0
COMMENTS:
Legal Notice Publications ~ includes $6,000 for publishing minute summaries.
Dues:
Coalition of Utility Cities
2007 BUDGET.xLS:Gen Fund-Legal:1/8/2007
36
GENERAL FUND
2007 Budget
Planning & Zoning
Personal Services
Salaries, Full-Time - Re
Salaries, Full-Time - OT
Salaries, Part-Time - Reg
Salaries, Part-Time - OT
Salaries, Temporar - Reg
Salaries, Tem orary - OT
Salaries, Other
Severance Pay
PERA Contributions
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
Flex Benefits
101.41910.1010
101.41910.1020
101.41910.1030
101.41910.1031
101.41910.1040
101.41910.1050
101.41910.1090
101.41910.1110
101.41910.1210
101.41910.1220
101.41910.1250
101.41910.1310
101.41910.1315
$125,375
$1,200
$250
$0
$0
$0
$0
$0
$7,925
$7,865
$1,840
$17,830
$150
101.41910.2030
101.41910.2075
101.41910.2099
101.41910.2199
Small Tools and Equipment
Small Tools/Misc.
T&E Machiner
T&E Furniture
T&E/Office Equipment
T&E/Computer Equipment
T&E/Other
101.41910.2410
101.41910.2440
101.41910.2460
101.41910.2471
101.41910.2472
101.41910.2499
Services & Charges
Prof. Services - Architect's Fees 101.41910.3020 $0
Prof. Services - EnQineerinQ Fees 101.41910.3030 $6,000
Prof. Services - LeQal Fees 101.41910.3040 $70,000
Misc. Professional Services - Aerial Map 101.41910.3075 $0
Prof. Services - Maintenance AQreements 101.41910.3190 $1,300
Misc. Professional Services 101.41910.3199 $160,000
Telephone 101.41910.3210 $650
Delivery Mail Service (UPsj- 101.41910.3240 $0
Misc. Communication 101.41910.3299 $0
2007 BUDGET.XLS:Gen Fund-P&Z:1/8/2007
37
GENERAL FUND
2007 Budget
Planning & Zoning
101.41910.3310
101.41910.3320
101.41910.3330
101.41910.3499
101.41910.3510
101.41910.3520
101.41910.3599
101.41910.3710
101.41910.4330
101.41910.4350
101.41910.4395
101.41910.4399
$1,000
$2,500
$0
$0
$1,200
$0
$0
$0
$500
$100
$0
$400
COMMENTS:
Salaries:
50% Jeff, 100% Angela, 50% of new position
Leqal Fees:
Now budgeted in Planning Department rather than Legal Department
2007 BUDGET.XLS:Gen Fund-P&Z:1/8/2007
38
GENERAL FUND
2007 Budget
Data Processing
Personal Services
Salaries, Full Time - Re
Salaries, Full Time - aT
Salaries Part-Time - Re
Salaries, Part-Time - aT
Salaries, Tempora - Re
Salaries, Tempora - aT
Salaries, Other
Severance Pa
PERA Contributions
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
Flex Benefits
101.41910.1010
101.41910.1020
101.41910.1030
101.41910.1031
101.41910.1040
101.41910.1050
101.41910.1090
101.41910.1110
101.41910.1210
101.41910.1220
101.41910.1250
101.41910.1310
101.41910.1315
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Small Tools and Equi ment
Data Processing Supplies
Small Tools/Mise
T&E/Machiner
T &E/Furniture
T&E/Office Equi ment
T&E/Computer E uipment
T &E/Other
101.41920.2025
101.41920.2410
101.41920.2440
101.41920.2460
101.41920.2471
101.41920.2472
101.41920.2499
$3,700
$0
$0
$0
$0
$37,200
$0
Prof Services - Data Process in
Software
Prof Services - Website/E-mail
Maintenance A reements
Misc Professional Services
T ele hone
DeliveMail service
Travel Expense
Conference and Schools
Advertisin
Repair & Mtc ~ Machiner & Equi ment
Dues, Membershi s & Subscriptions
Books & Pamphlets
Mise Other Expense
101.41920.3090
101.41920.3091
101.41920.3092
101.41920.3190
101.41920.3199
101.41920.3210
101.41920.3240
101.41920.3310
101.41920.3320
101.41920.3499
101.41920.4044
101.41920.4330
101.41920.4350
101.41920.4399
$63,000
$7,000
$7,480
$0
$105,000
$0
$0
$200
$2,000
$0
$500
$0
$0
$0
2007 BUDGETXLS:Gen Fund-Data Proc:1/8/2007
39
GENERAL FUND
2007 Budget
Data Processing
Capital Outla
Furniture & Fixture
Office Equi ment
Computer Equipment
101.41920.5601
101.4 1920.5701
101.4 1920.5702
COMMENTS:
T&E: Computer Equipment Replacements
Server
Tape Backup
LCD Multimedia Projector
Firewall Equipment
$21,100
$7,000
$4,000
$3,000
$2,100
$37,200
Professional Services Fiber Optic Network
GIS Planning/Implementation
$75,000
$30,000
$105,000
2007 BUDGET.xLS:Gen Fund-Data Proc:1/8/2007
40
GENERAL FUND
2007 Budget
City Hall
Personal Services
Salaries, Full-Time - Re
Salaries, Full-Time - OT
Salaries, Part-Time - Re
Salaries, Part-Time - OT
Salaries, Tempora - Re
Salaries, Tem orar - OT
Salaries, Other
Severance Pa
PERA Contributions
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
101.41940.1010
1 01 .41940.1 020
101.41940.1030
101.41940.1031
101.41940.1040
101.41940.1050
101.41940.1090
101.41940.1110
101.41940.1210
101.41940.1220
101.41940.1250
101.41940.1310
$2,345
$0
$5,000
$0
$0
$0
$0
$0
$460
$455
$110
$260
101.41940.2020
101.41940.2030
101.41940.2099
101.41940.2110
101.41940.2111
101.41940.2199
101.41940.2230
101.41940.2299
$0
$4,100
$7,700
$0
$0
$5,000
$0
$0
Small Tools and E ui ment
Small Tools/Misc.
T&E/Machiner
T &E/Furniture
T&E/Office E ui ment
T&E/Com uter E uipment
T &E/Other
101.41940.2410
101.41940.2440
101.41940.2460
101.41940.2471
101.41940.2472
101.4194.2499
$0
$0
$0
$0
$0
$0
S &Ch
ervlces arges
Professional Services - Custodial 101.41940.3110 $0
Maintenance Agreements 101.41940.3190 $39,000
Professional Services - Newsletter 101.41940.3195 $9,200
Mise Professional Services 101.41940.3199 $500
T eleohone 101.41940.3210 $24,000
Postaqe 101.41940.3220 $12,000
2007 BUDGET.XLS:Gen Fund-City Hall:1/8/2007
41
GENERAL FUND
2007 Budget
City Hall
Travel Ex ense
Advertising
General Public Information
General Liabilit Insurance
Pro pert Taxes
Electric
Gas
Refuse
Re air & Maintenance - Suildin s
Re air & Maintenance - Machine
BId IRoom Rental
E uipment Rental
Dues, Membershi s & Subscriptions
Misc Other Ex ense
101.41940.3310
101.41940.3499
101.41940.3520
101.41940.3610
101.41940.3710
101.41940.3810
101.41940.3830
101.41940.3840
101.41940.4010
101.41940.4044
101.41940.4120
101.41940.4150
101.41940.4330
101.41940.4399
$500
$200
$400
$1,000
$0
$16,100
$4,400
$0
$500
$700
$5,240
$2,200
$100
$500
Capital Outla 5
Buildin s
Improvements
Furnitures & Fixtures
Office Equipment
Other E ui ment
101.41940.5201
101.41940.5301
101.41940.5601
101.41940.5701
101.41940.5801
COMMENTS:
Salaries:
100% cleaning by MCC, 5% Parks, $1500 for maintenance by Comm. Ctr. Staff
2007 BUDGET.XLS:Gen Fund-City Hall: 1/8/2007
42
GENERAL FUND
2007 Budget
Deputy Registrar
Personal Services
Salaries, Full-Time - Re
Salaries, Full-Time - aT
Salaries, Part-Time - Re
Salaries, Part-Time - aT
Salaries, Tem ora - Re
Salaries, Temporary - aT
Salaries, Other
Severance Pa
PERA Contributions
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
Flex Benefits
101.41990.1010
101.41990.1020
101.41990.1030
101.41990.1031
101.41990.1040
101.41990.1050
101.41990.1090
101.41990.1110
101.41990.1210
101.41990.1220
101.41990.1250
101.41990.1310
101.41990.1315
$122,950
$1,000
$35,700
$0
$0
$0
$0
$0
$9,980
$9,900
$2,315
$15,885
$400
lies
101.41990.2020
101.41990.2030
101.41990.2099
101.41990.2110
101.41990.2199
Small Tools and Equi ment
Small Tools/Mise
T &E/Machiner
T &E/Furniture
T&E/Office E ui ment
T&E/Com uter E uipment
T &E/Other
101.41990.2410
101.41990.2440
101.41990.2460
101.41990.2471
101.41990.2472
101.41990.2499
$0
$0
$0
$0
$0
$0
S dCh
ervlces an arges
Professional Services - Website/E-mail 101.41990.3092 $1,200
Professional Services - Custodial 101.41990.3110 $0
Maintenance Agreements 101.41990.3190 $500
Mise Professional Services 101.41990.3199 $300
Telephone 101.41990.3210 $3,400
Postage 101.41990.3220 $1 ,300
T ravel Expense 101.41990.3310 $375
Conference & Schools 101.41990.3320 $0
General Public Information 101.41990.3520 $100
Electric 101.41990.3810 $1,800
2007 BUDGETXLS:Gen Fund-Dep. Registrar:1/8/2007
43
Gas
Repair & Maintenance - Buildin s
Re air & Maintenance - Machiner & E uipment
Dues, Memberships & Subscri tions
Books & Pam hlets
Misc Other Ex ense
GENERAL FUND
2007 Budget
Deputy Registrar
101.41990.3830
101.41990.4010
101.41990.4044
101.41990.4330
101.41990.4350
101.41990.4399
$800
$6,200
$0
$500
$0
$100
Capital Outlay
Buildin s
Furniture & fixtures
Office Equi ment
101.41990.5201
101.41990.5601
101.41990.5701
COMMENTS:
Salaries:
FT - 100% Diane, Ann,Kim
PT - Carolyn
Repair/Maint: F&F: Includes $2,500 for air exchanger
Bldgs: Painting $2,500; tuckpointing bldg $2,200 and sidewalk $1,500
2007 BUDGET.XLS:Gen Fund-Dep. Registrar:1/8/2007
44
GENERAL FUND
2007 Budget
Law Enforcement
Services & Char es
Professional Services - Law Enforcement
Mise, Professional Services
COMMENTS:
Professional Services;
18,980 hours @ $52.25/hr.
Misc. Professional Services: Includes $3,000 for "MEADA" Program.
2007 BUDGET.xLS;Gen Fund-Law Enforcement: 1/8/2007
45
GENERAL FUND
2007 Budget
Fire Department
Personal Services
Salaries, Full-Time - Re
Salaries, Full-Time - OT
Salaries, Part-Time - Re
Salaries, Part-Time - OT
Salaries, T em ora - Re
Salaries, T em ora - OT
Salaries, Other
Severance Pa
PERA/Pension Contributions
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
101.42201.1010
101.42201.1020
101.42201.1030
101.42201.1031
101.42201.1040
101.42201.1050
101.42201.1090
101.42201.1110
101.42201.1210
101.42201.1220
101.42201.1250
101.42201.1310
$65,000
$0
$2,345
$0
$7,900
$0
$3,120
$0
$0
$4,860
$1,135
$260
101.42201.2030
101.42201.2070
101.42201.2099
101.42201.2111
101.42201.2120
101.42201.2130
101.42201.2199
101.42201.2210
101.42201.2211
101.42201.2230
101.42201.2299
$350
$500
$300
$8,400
$4,500
$100
$8,000
$750
$1,200
$8,000
$500
ui ment
101.42201.2410
101.42201.2440
1 01.42201 .2460
101.42201.2471
101.42201.2472
1 01 .42201 .2499
$1,500
$0
$0
$0
$500
$7,500
Professional Services - Website/E-Mail 101.42201.3092 $0
Professional Services - Lawn Service 101.42201.3105 $600
Professional Services - Custodial 101.42201.3110 $1,070
Maintenance Aqreements 101.42201.3190 $500
Mise Professional Services 101.42201.3199 $4,600
Telephone 101.42201.3210 $1,500
Postage 101.42201.3220 $0
Travel Expense 101.42201.3310 $1,700
Conference & Schools 101.42201.3320 $8,500
Freioht 101.42201.3330 $0
Leoal Notice Publication 101.42201.3510 $0
General Public Information 101.42201.3520 $200
2007 BUDGET.XLS:Gen Fund-Fire Department:1/8/2007
46
Misc Printin
General Liabilit Insurance
Pro ert Insurance
Vehicle Insurance
Misc General Insurance
Electric
Gas
Re air & Maintenance - Buildin
Re air & Maintenance - Machine
Re air & Maintenance - Vehicles
Re air & Maintenance - Other
Dues, Membershi s & Subscri tions
Books & Pam hlets
Licenses & Permits
Reimb Fire Relief Assn Aid
Misc Other Ex ense
GENERAL FUND
2007 Budget
Fire Department
101.42201.3599
101.42201.3610
101.42201.3620
101.42201.3630
101.42201.3699
101.42201.3810
101.42201.3830
101.42201.4010
101.42201.4044
101.42201.4050
101.42201.4099
101 .42201.4330
101.42201.4350
101.42201.4370
101.42201.4395
101.42201.4399
$0
$0
$1,050
$8,905
$8,880
$3,425
$4,400
$4,000
$3,300
$21,000
$0
$800
$1,000
$200
$96,500
$500
101.42201.5301
101.42201.5501
101.42201.5601
101.42201.5701
101.42201.5801
$15.000
$125,000
$0
$0
$0
COMMENTS:
Salaries: $9/hr.
Salaries Other: 240 hours for part-time inspector
Misc. Professional Services: Includes (5) stress tests @ $300/each
Motor Vehicles: Fire Truck Reserve (Yr 7)
$125,000
Imorovements: Partial - 800 MHZ Radio System
(Estimated cost $41,500)
$15,000
Clothing Supplies: (5) Turnout suits (6 yr replacement plan)
Misc helmets, gloves, boots
$5,500
$500
$5,500
2007 BUDGET.XLS:Gen Fund-Fire Department:1/8/2007
47
GENERAL FUND
2007 Budget
Building Inspections
Personal Services
Salaries, Full-Time - Re
Salaries, Full-Time - OT
Salaries, Part-Time - Re
Salaries, Part-Time ~ OT
Salaries, Temporar - Re
Salaries, Tem orary - OT
Salaries Other
Severance Pa
PERA Contributions
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
Flex Benefits
101.42401.1010
101.42401.1020
101.42401.1030
101.42401.1031
101.42401.1040
101.42401.1050
101.42401.1090
101.42401.1110
101.42401.1210
101.42401.1220
101.42401.1250
101.42401.1310
101.42401.1315
$192,040
$3,000
$0
$0
$1,000
$0
$0
$2,800
$12,255
$12,155
$2,845
$36,905
$400
101.42401.2030
101.42401.2099
101.42401.2111
101.42401.2120
101.42401.2199
101.42401.2299
$600
$300
$2,000
$2,500
$1,000
$0
Small Tools and Equi ment
Small Tools/Mise
T&E/Machiner
T&E/Furniture
T&E/Office Equi ment
T&E/Computer Equi ment
T &E/Other
101.42401.2410
101.42401.2440
101.42401.2460
101.42401.2471
101.42401.2472
101.42401.2499
$500
$0
$0
$0
$2,200
$0
S
ervices & Charges
Professional Services - Engineering Fees 101.42401.3030 $0
Professional Services - Software/Programminq 101.42401.3091 $0
Professional Services - Lawn Service 101.42401.3105 $3,000
Misc Professional Services - Reimbursable 101.42401.3198 $0
Mise Professional Services 101.42401.3199 $2,000
Telephone 101.42401.3210 $5,000
Postage 101.42401.3220 $0
T ravel Expense 101.42401.3310 $500
Conferences & Schools 101.42401.3320 $2,500
LeQal Notice Publications 101.42401.3510 $0
General Public Information 101.42401.3520 $0
2007 BUDGET.XLS:Gen Fund-Building Inspections:1/8/2007
48
Ordinance Publication
Misc Printin
Electric
Gas
Re air & Maintenance - Buildin s
Repair & Maintenance - Machiner & Equipment
Repair & Maintenance - Vehicles
Dues, Membershi s & Subscri tions
Books & Pamphlets
Licenses & Permits
Misc Other Ex ense
GENERAL FUND
2007 Budget
Building Inspections
101.42401.3530
101.42401.3599
101.42401.3810
101.42401.3830
101.42401.4010
101.42401.4044
101.42401.4050
101.42401.4330
101.42401.4350
101.42401.4370
101.42401.4399
$0
$800
$300
$800
$9,000
$1,000
$4,850
$500
$1,000
$40,000
$1,000
101.42401.5201
101.42401.5501
101.42401.5701
COMMENTS:
Salaries:
85% Gary, 100% Ron, 100% Debra, 100% DJ; 30% Carolyn (PT)
Reoair & Maint.: Bldgs: Reroof storage garage
Mech. New Furnace/Air Conditioner
BuildinQs: 26' x 42' garage addition
Vehicles: '97 Jeep Cherokee
2007 BUDGET.XLS:Gen Fund-Building Inspections:1/8/2007
49
GENERAL FUND
2007 Budget
Civil Defense
Personal Services
Salaries, Full-Time - Reg
Salaries, Full-Time - aT
Salaries, Part-Time - Re
Salaries, Part-Time - aT
Salaries, Tem ora - Reg
Salaries, Tempora - aT
Salaries, Other
Severance Pa
PERA Contributions
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
101.42501.1010
101.42501.1020
101.42501.1030
101.42501.1031
101.42501.1040
101.42501.1050
101.42501.1090
101.42501.1110
101.42501.1210
101.42501.1220
101.42501.1250
101.42501.1310
$10,050
$0
$0
$0
$0
$0
$0
$0
$630
$625
$145
$995
Small Tools and Equipment
Small Tools/Mise
T&E/Machine
T&E/Furniture
T&E/Office Equipment
T&E/Computer Equipment
T&E/Other
101.42501.2410
101.42501.2440
101.42501.2460
101.42501.2471
101.42501.2472
101.42501.2499
$0
$0
$0
$2,500
$0
$0
Services & Char es
Misc Professional Services
Telephone
Travel Ex ense
Conferences & Schools
Electric
Repair & Maintenance - Machine & Equipment
Dues, Memberships & Subscri tions
Licenses & Permits
Mise Other Expense
1997 Storm Dama e Ex ense
Office Equi ment
Other Equipment
101.42501.3199
101.42501.3210
101.42501.3310
101.42501.3320
101.42501.3810
101.42501.4044
101.42501.4330
101.42501.4370
101.42501.4399
101.42501.4401
101.42501.5701
101.42501.5801
$0
$0
$100
$0
$200
$1,000
$0
$0
$0
$0
$1,600
$0
COMMENTS:
Salaries: 15% Gary
T&E Office Eauipment: Radios
2007 BUDGET.XLS:Gen Fund-Civil Defense:1/8/2007
50
GENERAL FUND
2007 Budget
Animal Control
101.42701.2030
101.42701.2099
101.42701.2110
101.42701.2199
101.42701.2230
101.42701.2299
$100
$100
$150
$2,000
$100
$0
Small Tools and E uipment
Small Tools/Mise
T&E/Machine
T&E/Furniture
T&E/Office Equipment
T&E/Computer Equipment
T &E/Other
101.42701.2410
101.42701.2440
101.42701.2460
101.42701.2471
101.42701.2472
101.42701.2499
$0
$0
$0
$0
$0
$0
Services & Char es
Professional Services - Animal Control Officer
Mise Professional Services
Telephone
Posta e
Travel Expense
Conferences & Schools
Le al Notice Publication
General Public Information
Electric
Gas
Refuse
Re air & Maintenance - Buildin s
Dues, Membershi s & Subscriptions
Tree Replacement
Mise Other Expense
101.42701.3120
101.42701.3199
101.42701.3210
101.42701.3220
101.42701.3310
101.42701.3320
101.42701.3510
101.42701.3520
101.42701.3810
101.42701.3830
101.42701.3840
101.42701.4010
101.42701.4330
101.42701.4391
101.42701.4399
$36,750
$1,250
$1,750
$0
$650
$0
$0
$0
$1 ,250
$1,250
$0
$100
$50
$0
$0
101.42701.5201
101.42701.5301
101.42701.5601
101.42701.5702
101.42701.5801
COMMENTS: Professional Services: Patty Salzwe,del contract
2007 BUDGET.XLS:Gen Fund-Animal Control:1/8/2007
51
GENERAL FUND
2007 BUDGET
NATIONAL GUARD
Personal Services
Salaries, Full-Time - Reg
101.42810.3610
101.42810.3620
101.42810.3810
101.42810.3830
101.42810.4120
Salaries: Comm. Ctr. Staff maintenance allocation.
2007 BUDGET.XLS:Gen Fund-National Guard:1/8/2007
52
GENERAL FUND
2007 Budget
PW/Administration
Personal Services
Salaries, Full-Time - Re
Salaries, Full-Time - aT
Salaries, Part-Time ~ Re
Salaries, Part-Time - aT
Salaries, Tem ora ~ Re
Salaries, Temporar - aT
Salaries, Other
Severance Pa
PERA Contributions
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
Flex Benefit
101.43110.1010
101.43110.1020
101.43110.1030
101.43110.1031
101.43110.1040
101.43110.1050
101.43110.1090
101.43110.1110
101.43110.1210
101.43110.1220
101.43110.1250
101.43110.1310
101.43110.1315
$153,755
$200
$0
$0
$0
$0
$0
$0
$9,625
$9,545
$2,235
$16,040
$100
101.43110.2020
101.43110.2030
101.43110.2099
101.43110.2110
101.43110.2111
101.43110.2120
101.43110.2199
$200
$150
$4,000
$100
$300
$0
$1,700
Small Tools and Equipment
Small Tools/Misc
T&E/Machinery
T &E/Furniture
T&E/Office E uipment
T&E/Computer E ui ment
T &E/Other
101.43110.2410
101.43110.2440
101.43110.2460
101.43110.2471
101.43110.2472
101.43110.2499
$500
$0
$0
$0
$500
$0
Services & Charges
Professional Services ~ Engineering Fees 101.43110.3030 $0
Professional Services - Engineering Reimb 101.43110.3035 $0
Professional Services - Custodial 101.43110.3110 $0
Maintenance Agrements 101.43110.3190 $500
Misc Profesisonal Services 101.43110.3199 $700
Telephone 101.43110.3210 $10,000
Postage 101.43110.3220 $1,000
Delivery Service (UPS) 101.43110.3240 $100
2007 BUDGET.XLS:Gen Fund - PW Admin:1/8/2007
53
Travel Ex ense
Conferences & Schools
Advertisin
Le al Notice Publication
General Public Information
Misc. Printin
Propert Taxes
Repair & Maintenance - Machiner
Repair & Maintenance - Vehicles
Equi ment Rental
Uniform Rental
Dues, Membershi s & Subscri tions
Books & Pamphlets
Licenses and Permits
Misc Other Expense
GENERAL FUND
2007 Budget
PW/Administration
101.43110.3310
101.43110.3320
101.43110.3499
101.43110.3510
101.43110.3520
101.43110.3599
101.43110.3710
101.43110.4044
101.43110.4050
101.43110.4150
101.43110.4170
101.43110.4330
101.43110.4350
101.43110.4370
101.43110.4399
$100
$500
$300
$300
$500
$0
$0
$300
$0
$500
$300
$700
$0
$50
$500
101.43110.5301
101.43110.5501
101.43110.5601
101.43110.5701
101.43110.5801
COMMENTS:
FT Salaries:
100% John S., Beth, Julie
2007 BUDGETXLS:Gen Fund - PW Admin:1/8/2007
54
GENERAL FUND
2007 Budget
PW/Engineering
Personal Services
Salaries - Full Time
Salaries - Tempora
PERA Contributions
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
101.43111.1010
101.43111.1040
101.43111.1210
101.43111.1220
101.43111.1250
101.43111.1310
$77,200
$3,600
$4,825
$5,010
$1,170
$11,835
101.43111.2020
101.43111.2030
101.43111.2099
101.43111.2199
Small Tools and E uipment
T & E - Equipment
T & E - Furniture
T & E - Office E uipment
T & E - Computer
T & E - Other
101.43111.2410
101.43111.2460
101.43111.2471
101.43111.2472
101.43111.2499
$0
$0
$0
$0
$0
101.43111.3030
101.43111.3199
101.43111.3210
101.43111.3220
101.43111.3310
101.43111.3320
101.43111.4330
$105,000
$12,500
$500
$0
$335
$500
$100
COMMENTS:
Salaries: 100% Bruce
Professional Services - enqineerinq fees:
Consultant engineering fees for project related services
2007 BUDGET.XLS:Gen Fund-PW Engineering:1/Bl2007
55
GENERAL FUND
2007 Budget
PW/lnspections
Personal Services
Salaries, Full-Time - Re
Salaries, Full-Time - OT
Salaries, Parth Time - Re
Salaries, Part-Time - OT
Salaries, Tem ora - Re
Salaries, Tempora - OT
Salaries, Other
Severance Pa
PERA Contributions
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
101.43115.1010
101.43115.1020
101.43115.1030
101.43115.1031
101.43115.1040
101.43115.1050
101.43115.1090
101.43115.1110
101.43115.1210
101.43115.1220
101.43115.1250
101.43115.1310
$101,425
$6,600
$0
$0
$0
$0
$0
$0
$6,750
$6,700
$1 ,565
$16,000
101.43115.2030
101.43115.2099
101.43115.2111
101.43115.2120
101.43115.2199
101.43115.2211
101.43115.2299
$250
$150
$500
$6,000
$1,800
$1,000
$500
Small Tools and Equipment
Small Tools/Mise
T &E/Machiner
T&E/Furniture
T&E/Office Equi ment
T&E/Computer Equipment
T&E/Other
101.43115.2410
101.43115.2440
101.43115.2460
101.43115.2471
101.43115.2472
101.43115.2499
$1,500
$0
$0
$0
$750
$0
Ch &S
arges ervlces
Professional Services - Software/Progamming 101.43115.3091 $0
Misc Professional Services 101.43115.3199 $300
Telephone 101.43115.3210 $2,000
Travel Expense 101.43115.3310 $0
Conferences & Schools 101.43115.3320 $1,500
Repair & Mtc - Vehicles 101.43115.4050 $500
Equipment Rental 101.43115.4150 $0
Uniform Rental 101.43115.4170 $750
Books & Pamphlets 101.43115.4350 $100
2007 BUDGET.XLS:Gen Fund-PW Inspections:1/8/2007
56
Licenses & Perm its
Misc Other Expense
GENERAL FUND
2007 Budget
PW/lnspections
101.43115.4370
101.43115.4399
101.43115.5501
101.43115.5601
101.43115.5701
COMMENTS:
Salaries:
100% Tom Bose, Karen Ludvigson
Vehicles: Replacement for '97 Ford Ranger pickup
2007 BUDGET.XLS:Gen Fund-PW Inspeclions:1/8/2007
57
GENERAL FUND
2007 Budget
PW/Streets & Alleys
Personal Services
Salaries, Full-Time - Re
Salaries, Full~Time - aT
Salaries, Part-Time - Re
Salaries, Part-Time ~ aT
Salaries, Tem ora - Re
Salaries, Tem orar NOT
Salaries, Other
Severance Pa
PERA Contributions
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
U.C. Benefit Pa ments
Worker's Com Beneift Pa ment
lies
Small Tools and E uipment
Small Tools/Misc.
T &E/Machinery
T &E/Furniture
T&E/Office E uipment
T&E/Computer Equi ment
T &E/Other
101.43120.1010
101.43120.1020
101.43120.1030
101.43120.1031
101.43120.1040
101.43120.1050
101.43120.1090
101.43120.1110
101.43120.1210
101.43120.1220
101.43120.1250
101.43120.1310
101.43120.1420
101.43120.1520
$250,260
$1,500
$0
$0
$16,500
$500
$0
$0
$16,800
$16,665
$3,900
$50,905
$0
$0
101.43120.2065
101.43120.2111
101.43120.2120
101.43120.2130
101.43120.2150
101.43120.2199
101.43120.2210
101.43120.2211
101.43120.2220
101.43120.2230
101.43120.2240
101.43120.2250
101.43120.2260
101.43120.2299
101.43120.2999
$1,000
$600
$30,000
$100
$0
$18,000
$7,500
$7,500
$1,000
$500
$10,000
$3,000
$2,500
$500
$0
101.43120.2410
101.43120.2440
101.43120.2460
101.43120.2471
101.43120.2472
101.43120.2499
$500
$0
$0
$0
$0
$0
2007 BUDGETXLS:Gen Fund-PW Streets & Alley:1/8/2007
58
GENERAL FUND
2007 Budget
PW/Streets & Alleys
Services & Char es
Maintenance A reements
Misc Professional Services
T ele hone
DeliveMail Service UPS
T ravel Ex ense
Conferences & Schools
General Public Information
Repair & Maintenance - Machiner & E uipment
Repair & Maintenance - Vehicles
Re air & Maintenance - Other
Equipment Rental
Machiner Rental
Uniform Rental
Licenses & Permits
Misc Other Ex ense
101.43120.3190
101.43120.3199
101.43120.3210
101.43120.3240
101.43120.3310
101.43120.3320
101.43120.3520
101.43120.4044
101.43120.4050
101.43120.4099
101.43120.4150
101.43120.4160
101.43120.4170
101.43120.4370
101.43120.4399
$0
$5,000
$1,500
$0
$1,000
$1,500
$500
$1,500
$1,500
$0
$1,000
$1,000
$3,700
$300
$2,000
Capital Outla
Improvements
Motor Vehicles
Office Equipment
Other Equi ment
101.43120.5301
101.43120.5501
101.43120.5701
101.43120.5801
COMMENTS:
Salaries:
90% T.Moores, J. Eisele & T. Barnes,Mike R, Mike H & Roger H
Imorovements: Sealcoating Program
$35,000
Other EQuioment: Sweeper Replacement (2nd of 3 yr budget)
(Previously budgeted $60,000)
1987 Ford tractor/mower replacement
(Previously budgeted $50,000 - Balance of Purchase)
$60,000
$28,750
2007 BUDGET.xLS:Gen Fund-PW Streets & Alley: 1/8/2007
59
GENERAL FUND
2007 Budget
PWllce & Snow
Personal Services
Salaries, Full-Time - Re
Salaries, Full-Time - OT
Salaries, Part-Time - Reg
Salaries, Part-Time - OT
Sularies, Temporary - Re
Salaries, Tem ora - OT
Salaries, Other
Severance Pa
PERA Contributions
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
Flex Benefits
U.C. Benefit Pa ment
Worker's Com Benefit Pa ment
101.43125.1010
101.43125.1020
101.43125.1030
101.43125.1031
101.43125.1040
101.43125.1050
101.43125.1090
101.43125.1110
101.43125.1210
101.43125.1220
101.43125.1250
101.43125.1310
101.43125-1315
101.43125.1420
101.43125.1520
$32,435
$6,000
$0
$0
$0
$0
$0
$0
$2,400
$2,385
$560
$3,735
$50
$0
$0
Su plies
Sand
Mic Operating Supplies
Equi ment Repair Parts
Vehicle Repair Parts
Plowin Su plies
Mise Re air & Maintenance Su plies
101.43125.2170
101.43125.2199
101.43125.2210
101.43125.2211
101.43125.2245
101.43125.2299
$13,500
$12,000
$1,000
$1,000
$1,000
$250
Small Tools and Equi ment
Small Tools/Mise
T&E/Machiner
T&E/Furniture
T&E/Office Equi ment
T&E/Com uter E uipment
T &E/Other
101.43125.2410
101.43125.2440
101.43125.2460
101.43125.2471
101.43125.2472
101.43125.2499
$0
$0
$0
$0
$0
$0
Services & Char es
Mise Professional Services
Repair & Maintenance - Machine
2007 BUDGET.xLS:Gen Fund-PW Ice & Snow:1/8/2007
60
GENERAL FUND
2007 Budget
PW/lce & Snow
101.43125.5401
101.43125.5501
101.43125.5801
COMMENTS:
Salaries:
10% of Tom M., AI G., Jim E., T. Barnes, Mike R, Mike H. & Roger H.
Motor Vehicles: Plow/Hook Truck (Balance)
Previously budgeted $132,500
2007 BUDGET.XLS:Gen Fund-PW Ice & Snow:1/8/2007
61
GENERAL FUND
2007 Budget
PW/Shop & Garage
101.43127.1010
101.43127.1020
101.43127.1030
101.43127.1031
101.43127.1040
101.43127.1050
101.43127.1090
101.43127.1110
101.43127.1210
101.43127.1220
101.43127.1250
101.43127.1310
101.43127.1420
101.43127.1520
$44,660
$500
$13,750
$0
$6,500
$0
$0
$0
$4,090
$4,055
$950
$6,395
$0
$0
Supplies
Safet Supplies
Cleanin Supplies
Clothin Supplies
Motor Fuels
Lubricants & Additives
Sho Materials
Paint Sup lies
Welding Supplies
Chemical Products
Mise 0 eratin Su lies
Equi ment Repair Parts
Vehicle Repair Parts
Buildin Repair Supplies
Mise Repair & Maintenance Su
101.43127.2065
101.43127.2110
101.43127.2111
101.43127.2120
101.43127.2130
101.43127.2150
101.43127.2151
101.43127.2152
101.43127.2160
101.43127.2199
101.43127.2210
101.43127.2211
101.43127.2230
101.43127.2299
$500
$1,000
$250
$0
$2,000
$2,500
$500
$500
$2,000
$22,000
$1,500
$1,500
$2,000
$250
Small Tools and Equi ment
Small Tools/Mise
T&E/Machine
T&E/Furniture
T&E/Office Equipment
T&E/Computer Equi ment
T&E/Other
101.43127.2401
101.43127.2440
101.43127.2460
101.43127.2471
101.43127.2472
101.43127.2499
$4,500
$0
$0
$0
$0
$600
2007 BUDGET.XLS:Gen Fund-PW Shop & Garage:1/8/2007
62
GENERAL FUND
2007 Budget
PW/Shop & Garage
Services & Char es
Maintenance A reements
Misc Professional Services
Radio Units
Conference and Schools
Misc Printing
Electric
Gas
Re air & Maintenance - Buildin s
Re air & Maintenance - Machiner & Equipment
Equi ment Rental
Uniform Rental
Misc Rentals
Books & Pam phlets
Licenses & Perm its
Misc Other Expense
101.43127.3190
101.43127.3199
101.43127.3230
101.43127.3320
101.43127.3599
101.43127.3810
101.43127.3830
101.43127.4010
101.43127.4044
101.43127.4150
101.43127.4170
101.43127.4199
101.43127.4350
101.43127.4370
101.43127.4399
$1,500
$1,500
$1,000
$250
$0
$11,000
$30,000
$5,000
$500
$0
$0
$0
$0
$450
$250
101.43127.5201
101.43127.5301
101.43127.5601
101.43127.5701
101.43127.5801
$0
$12,500
$3,000
$0
$10,000
COMMENTS:
Salaries:
90% AI G.
Salaries: Part-time: Bill Ross, Custodian
Improvements: Balance of heating system in conf. room/lunch room
Enlarge parking lot
$3,500
$9,000
$12,500
F & F: Pallet Racking
Other Equipment: Welding Air Vent System
$10,000
2007 BUDGET.xLS:Gen Fund-PW Shop & Garage:1/8/2007
63
GENERAL FUND
2007 Budget
PW/Parking Lots
Small Tools and Equi ment
Small Tools/Mise
T &E/Machiner
T &E/Furniture
T&E/Office E uipment
T&E/Computer Equi ment
T&E/other
101.43140.2410
101.43140.2440
101.43140.2460
101.43140.2471
101.43140.2472
101.43140.2499
$0
$0
$0
$0
$0
$0
Services and Char es
Electric
Mise Other Expense
2007 BUDGET.XLS:Gen Fund-PW Parking Lots:1/B/2007
64
GENERAL FUND
2007 Budget
PW/Street Lighting
Small Tools and E uipment
Smalls Tools/Misc.
T &E/Machiner
T &E/Furniture
T&E/Office Equipment
T&E/Ccomputer Equipment
T &E/Other
101.43160.2410
101.43160.2440
101.43160.2460
101.43160.2471
101.43160.2472
101.43160.2499
I ':1: J I i 'i t I :' ,:' ~
TO'
Services & Char es
Mise Professional Services
Electric
Re air & Maintenance - Machine
Repair & Maintenance ~ Other
E ui ment Rental
101.43160.3199
101.43160.3810
101.43160.4044
101.43160.4099
101.43160.4150
$100,000
$123,000
$10,000
$2,000
$0
COMMENTS:
Misc. Professional Services: Add (30) new lights in residential areas
and replace (20) leased lights
& (10) divided Hwy lights
$100,000
2007 BUDGETXLS:Gen Fund-PW Street Lighting: 1/8/2007
65
GENERAL FUND
2007 Budget
Refuse Collection
Personal Services
Salaries, Full-Time ~ Re
Salaries, Full-Time - OT
Salaries, Part-Time - Re
Salaries, Part-Time - OT
Salaries, T em orar - Re
Salaries, Tem ora - OT
Salaries, Other
Severance Pa
PERA Contributions
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
101.43230.1010
101.43230.1020
101.43230.1030
101.43230.1031
101.43230.1040
101.43230.1050
101.43230.1090
101.43230.1110
101.43230.1210
101.43230.1220
101.43230.1250
101.43230.1310
$2,000
$4,500
$0
$0
$3,700
$0
$0
$0
$635
$630
$150
$0
101.43230.2030
101.43230.2099
101.43230.2199
101.43230.2299
ment
101.43230.2410
101.43230.2411
101.43230.2440
101.43230.2460
101.43230.2471
101.43230.2472
101.43230.2499
$0
$3,500
$0
$0
$0
$0
$0
S &Ch
ervlces arges
Professional Services - Legal Fees 101.43230.3040 $0
Professional Services - Data Processi~ 101.43230.3090 $0
Software 101.43230.3091 $0
Professional Services ~ Refuse Collection 101.43230.3100 $166,200
Professional Services - Recycling Contract 101.43230.3101 $93,300
Professional Services - Landfill Charges 101.43230.3102 $176,410
Maintenance Agreements 101.43230.3190 $0
Professional Services - Newsletter 101.43230.3195 $0
Misc Professional Services 101.43230.3199 $9,000
Postage 101.43230.3220 $900
Delivery Mail Service 101.43230.3240 $0
2007 SUDGET.XLS:Gen Fund-Refuse Collection: 1/8/2007
66
Travel Ex ense
Conferences & Schools
Advertisin
General Public Information
Ordinance Publication
Mise Printin
Sales Tax
Dues, Membershi s & Subscri tions
Licenses & Permits
Rec din Prizes
Mise Other Expense
GENERAL FUND
2007 Budget
Refuse Collection
101.43230.3310
101.43230.3320
101.43230.3499
101.43230.3520
101.43230.3530
101.43230.3599
101.43230.3720
101.43230.4330
101.43230.4370
101.43230.4390
101.43230.4399
$0
$300
$0
$500
$0
$500
$33,400
$0
$0
$0
$450
101.43230.5701
101.43230.5702
101.43230.5801
COMMENTS:
Salaries:
PW Dept salaries for (3) leaf pickups & Junk Amnesty Day
Misc. Operatinq Supplies: 200 carts
Misc. Prof Services: Junk Amnesty Day
2007 BUDGET.XLS:Gen Fund-Refuse Collection: 1/8/2007
67
GENERAL FUND
2007 Budget
Community Celebrations
Communit Celebrations
Riverfest
Pro"ect "Take Pride"
Pathwa "Walk & Roll"
Christmas Decorations
Other Celebrations
101.45130.4410
101.45130.4412
101.45130.4414
101.45130.4425
101.45130.4429
$0
$0
$4,200
$5,000
$1,500
2007 BUDGET.XLS:Community Celebrations:1/8/2007
68
GENERAL FUND
2007 Budget
Chamber Building
Personal Services
Salaries, Full-Time - Re
Salaries, Full-Time - aT
Salaries, Part-Time - Re
Salaries, Part-Time - aT
Salaries, Tempora ~ Re
Salaries, Tem ora - aT
Salaries, Other
PERA Contributions
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
101.45172.1010
101.45172.1020
101.45172.1030
101.45172.1031
101.45172.1040
101.45172.1050
101.45172.1090
101.45172.1210
101.45172.1220
101.45172.1250
101.45172.1310
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
2007 BUDGET.XLS:Gen Fund-Chamber Bldg:1f8f2007
69
GENERAL FUND
2007 Budget
Senior Center
Personal Services
Salaries, full-Time - Re
PERA Contributions
FICA Contributions
Medicare Contributions
101.45175.1010
101.45175.1210
101.45175.1220
101.45175.1250
$1,500
$95
$95
$25
Services & Char es
Senior Center Contribution
General Liability Insurance
Electric
Gas
Bid /Room Rental
101.45175.3136
101.45175.3610
101.45175.3810
101.45175.3830
101.45175.4210
$47,850
$370
$5,750
$2,900
$34,480
Salaries:
Comm. Ctr. Staff maintenance allocation
Senior Ctr Contribution - 4% increase in annual contribution
2007 BUDGET.XLS:Gen Fund-Senior Center:1/8/2007
70
GENERAL FUND
2007 Budget
Community Education
Services & Char es
Misc Professional Services
COMMENTS;
Misc Professional Services:
Annual contribution toward Summer Recreation Program.
(Based on 72.8% of school district assessed valuation being in the City)
2007 BUDGET.XLS:Gen Fund-Community Education:1/8/2007
71
GENERAL FUND
2007 Budget
Y.M.C.A.
Services & Char es
Misc Professional Services
Misc. Prof. Servo
Annual contribution to YMCA Detached Worker Programs
(Based on the City being 72.8% of school district assessed valuation)
2007 BUDGETXLS:Gen Fund-YMCA:1/8/2007
72
GENERAL FUND
2007 Budget
TRANSIT - RIVER RIDER
Services & Char es
Misc Professional Services
Comments: River Rider Contract
2007 BUDGET:XLS:Gen Fund-River Rider: 1/8/2007
73
GENERAL FUND
2007 Budget
SWAN RIVER SCHOOL
2007 BUDGET.XLS:Gen Fund-Swan River School:1/8/2007
74
GENERAL FUND
2007 BUDGET
ICE ARENA
Services & Char es
Ice Arena Contribution
Ice Arena: 4th year of 10 year commitment
2007 BUDGET.xIS:2007Budget-1.xIS:1/8/2007
75
GENERAL FUND
2007 Budget
Economic Development
Personal Services
Salaries, Full-Time - Re
Salaries, Full-Time - aT
Salaries, Part-Time - Re
Salaries, Part.Time - aT
Salaries, Tempora - Re
Salaries, Tem ora - aT
Salaries, Other
Severance Pa
PERA Contributions
FICA Contributions
Medicare Contributions
Health/Dental/life Insurance
Flex Benefits
101.46501.1010
101.46501.1020
101.46501.1030
101.46501.1031
101.46501.1040
101.46501.1050
101.46501.1090
101.46501.1110
101.46501.1210
101.46501.1220
101.46501.1250
101.46501.1310
101.46501.1315
$26,820
$0
$0
$0
$0
$0
$0
$200
$1,675
$1,665
$390
$1,870
$50
ment
101.46501.2410
101.46501.2440
101.46501.2460
101.46501.2471
101.46501.2472
101.46501.2499
$0
$0
$0
$0
$0
$0
101.46501.2030
101.46501.2099
101.46501.2199
101.46501.2260
101.46501.3040
101.46501.3135
101.46501.3199
101.46501.3210
101.46501.3310
101.46501.3320
101.46501.3330
101.46501.3510
101.46501.3520
101.46501.3560
101.46501.4330
101.46501.4350
101.46501.4399
101.46501.5601
101.46501.6512
$0
$0
$0
$0
$0
$0
$5,000
$350
$700
$500
$0
$0
$3,000
$33,000
$3,250
$0
$600
$0
$0
2007 BUDGET.XLS:Gen Fund-Economic Develop:1/8/2007
76
GENERAL FUND
2007 Budget
Economic Development
Other Finance Uses
Transfer to Debt SeNice Fund
COMMENTS:
Salaries: 40% Ollie
Dues
Wright County Econ. Development Ptnr
RotaryClub
Misc: Chamber Dues
Misc.
$2, 1 00
$250
$650
$250
$3,250
$3,000
General Public Information: Community Guide Pub.
2007 BUDGET.xLS:Gen Fund-Economic Develop:1/8/2007
77
GENERAL FUND
2007 Budget
Unallocated
Personal Services
Severance Benefits
Misc Other Expense
COMMENTS:
Severence Benefits:
Represents funding for employee vacation and sick leave accruals earned in 2007.
2007 BUDGETXLS:Gen Fund-Unallocated:1/8/2007
78
GENERAL FUND
2007 Budget
Insurance.. Unallocated
Personal Services
Worker's Com Insurance Premiums
Services & Char es
General Liabilit Insurance
Pro ert Insurance
Vehicle Insurance
Misc General Insurance
101.49240.3610
101.49240.3620
101.49240.3630
101.49240.3699
$64,465
$32,980
$11,075
$1,500
2007 BUDGET.xLS:Gen Fund-Insurance Unalloc.:1/8/2007
79
SPECIAL REVENUE FUND
2007 Budget
UDAG Fund
REVENUE
....--..._-...~---...._-....-........-....._-........-........_--..............-.........--...-....
EXPENDITURES
2007 BUDGETXLS:Spec Revenue Fund-UDAG Fund:1/8/2007
80
SPECIAL REVENUE FUND
2007 Budget
Library Fund
REVENUE
--------....---IIIIIIIIIIII~_....____......__...IIiiIIIi~______...........____...
EXPENDITURES
Personal Services
Salaries, Full-time - Re
Salaries, Part-time - Re
PERA Contributions:
FICA Contributions:
Medicare Contributions:
Health/Dental/Life Insurance:
211.45501.1010
211.45501.1030
211.45501.1210
211.45501.1220
211.45501.1250
211.45501.1310
$6,000
$2,345
$520
$520
$120
$260
211.45501.2020
211.45501.2030
211.45501.2065
211.45501.2099
211.45501.2110
211.45501.2199
211.45501.2230
211.45501.2299
$0
$100
$700
$400
$0
$1,350
$0
$300
Small Tools and Equi ment
Small Tools/Mise
T&E/Machine
T &E/Furniture
T&E/Office Equipment
T&E/Com uter Equipment
T &E/Other
211.45501.2410
211.45501.2440
211.45501.2460
211.45501.2471
211.45501.2472
211.45501.2499
$0
$0
$0
$0
$0
$0
S &Ch
ervlces arges
Professional Services -Library PrOQrams 211.45501.3015 $6,700
Professional Services - Lawn Service 211.45501.3105 $500
Professional Services - Custodial: 211.45501.3110 $0
Maintenance Agreements: 211.45501.3190 $0
2007 BUDGET.XLS:Spec Revenue Fund-Library Fund:1/8/2007
81
Misc Professional Services:
Telephone:
Posta e
Travel Expense:
Conference & Schools:
General Public Information:
General Liabilit Insurance:
Pro ert Insurance:
Electric:
Gas:
Re air & Maintenance-Buildin s:
Re air & Maintenance-Machine & E ui ment:
Books & Pamphlets:
Misc Other Expenses:
Furniture & Fixtures
SPECIAL REVENUE FUND
2007 Budget
Library Fund
211.45501.3199
211.45501.3210
211.45501.3220
211.45501.3310
211.45501.3320
211.45501.3520
211.45501.3610
211.45501.3620
211.45501.3810
211.45501.3830
211.45501.4010
211.45501.4044
211.45501.4350
211.45501.4399
211.45501.5601
$300
$0
$50
$0
$0
$150
$0
$815
$9,100
$5,500
$1,100
$500
$0
$1,000
$0
COMMENTS:
Salaries: Comm Ctr Maint Staff allocated to Library maintenance
Part~time Salaries: Public Works staff and outside maintenance
2007 BUDGETXLS:Spec Revenue Fund-Library Fund:1/8/2007
82
SPECIAL REVENUE FUND
2007 BUDGET
STREET RECONSTRUCTION FUND
Revenue
Current Ad Valorem Taxes:
Street, Sidewalk, Curb Repair
Fennin Ave Reconstruction
Cit -Stub Street
Hau & 95th Streets
85th Ave Reconstruction
Fallon Avenue Reconstruction
Edmonson Avenue/CR 117
Sandber Road
Interest Earnin s
212.31011
212.34301
212.36101
212.36103
212~361 05
212.36107
212.36109
212.36111
212.36113
212.36210
$562,020
$0
$8,024
$295
$101
$8,860
$9,311
$12,919
$1 ,795
$4,725
-..........-...._I!-._...__...._______......................................._..._..._....._______
EXPENDITURES
Services & Char es
Prof Services - Construction Cost
Prof Services - En ineerin Fees
Le al Notice Publication
Land
212.43121.3025
212.43121.3030
212.43121.3510
212.43121.5101
$0
$0
$0
$0
Other Finance Uses
Transfer to Other Funds
Fifth year of program
(Previously budgeted $2,337,000)
$1,250,000
2007BUDGET:XLS:Spec Revenue Fund-Street Recon:1/8/2007
83
SPECIAL REVENUE FUND
2007 Budget
HRA Fund
REVENUE
Current Ad Valorem Taxes:
TIF #2 - Metcalf & Larson:
TIF #5 ~ Construction 5:
TIF #6 - Raindance:
TIF #9 - Tapper:
TIF #10 - Remmele:
TIF #11 ~ Marties Farm Service:
TIF #12 - Aroplax:
TIF #13 - Standard Iron:
TIF #14 - Suburban Machine:
TIF #15 ~ Custom Cano :
TIF #16 - Pol cast:
TIF #17 - Fa Mar Fabricators:
TIF #18 - River Mill:
TIF #19 - Mississi i Shores:
TIF #20 - Prairie West
TIF #21 - Lake Tool
TIF #22 - CCDlDowntown
TIF #23 - Midwest Gra hics
TIF #24 ~ St. Benedict's Center
TIF #25 - Blue Chip Development
TIF #26 ~ Twin Cit Die Castin s
TIF #28 - IRTI
TIF #29 - Front Porch
TIF #30 - CMHP
TIF #31 - U.M.C.
TfF #33 - Ta per's Holdin s
TIF #36 - Dahlheimer Dist
TIF # 22.5 ~ CCD/Amoco
Interest Earnin s:
213.31011
213.31052
213.31055
213.31056
213.31059
213.31060
213.31061
213.31062
213.31063
213.31064
213.31065
213.31066
213.31067
213.31068
213.31069
213.31070
213.31071
213.31072
213.31073
213.31074
213.31075
213.31076
213.31078
213.31079
213.31080
213.31081
213.31083
213.31086
213.31105
213.36210
$0
$48,000
$50,000
$40,000
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$30,000
$25,000
$0
$295,000
$36,000
$47,500
$8,850
$38,000
$6,500
$28,000
$10,000
$75,500
$1,500
$65,000
$10,000
$38,860
....._-.---------....._----...._....._-------~-_...._--....._.....-
EXPENDITURES
Personal Services
Salaries, Full-time - Re :
PERA Contributions:
FICA Contributions:
Medicare Contributions:
Health/Dental/Life Insurance:
Flex Benefits
213.46301.1010
213.46301.1210
213.46301.1220
213.46301.1250
213.46301.1310
213.46301.1315
$40,230
$2,515
$2,495
$585
$2,805
$25
2007 BUDGET.XLS:Spec Revenue Fund-HRA Fund:1/8/2007
84
SPECIAL REVENUE FUND
2007 Budget
HRA Fund
213.46301.3040
213.46301.3091
213.46301.3199
213.46301.3310
213.46301.3320
213.46301.3510
213.46301.3710
213.46301.3830
213.46301.4399
$3,000
$300
$5,000
$0
$450
$500
$0
$200
$500
Capital Outla
Land
Debt Service Princi al - Otter Creek
SA Prine; al Pa able - Land for Resale
Debt Service Interest - Otter Creek
SA Interest Pa able. Land for Resale
213.46301.5101
213.46301.6030
213.46301.6050
213.46301.6130
213.46301.6150
$0
$100,000
$125,000
$40,500
$75,000
Other Finance Uses
Transfer to Debt Service:
...._---....._--.....-...._--~_...._~-~-........._---_....._~....-...._~....-
TAX INCREMENT SURPLUS
TAX INCREMENT DISTRICT EXPENDITURES
TIF #15 - CUSTOM CANOPY
TIF Payback Installments:
2007 BUDGET.XLS:Spec Revenue Fund-HRA Fund:1/8/2007
85
SPECIAL REVENUE FUND
2007 Budget
HRA Fund
TIF #17 - FAY MAR FABRICATOR
TIF Pa back Installments
TIF #20 - PRAIRIE WEST
Debt Service - Principal Short Term
Debt Service - Interest Short Term
TIF Payback Installments:
213.46520.6030
213.46520.6130
213.46520.6511
$8,500
$4,500
$10,000
TIF #21 - LAKE TOOL
Debt Service - Principal Short Term
Debt Service w Interest Short Term
TIF #22 - DOWNTOWN REDEVELOPMENT
Debt Service - Princi al Short Term
Debt Service - Interest Short Term
TIF Payback Installments;
Transfer to Debt Service Fund:
213.46522.6030
213.46522.6130
213.46522.6511
213.46522.7205
$0
$0
$0
$0
TIF #23 - ALLIED COMPANIES
Debt Service Interest - Short Term
2007 BUDGET.XLS:Spec Revenue Fund-HRA Fund:1/8/2007
86
SPECIAL REVENUE FUND
2007 Budget
HRA Fund
TIF #25 - BLUE CHIP DEVELOPMENT
TIF Pa back Installment
TIF #26 - TWIN CITY DIE CASTINGS
Debt Service ~ Princi al Short Term
TIF Pa back Installment
TIF #22.1 - FLUTH/CUB FOODS
TIF Pa back Installment
TIF #30 - CMHP
Debt Service Prinicipal ~ Short Term
Debt Service Interest - Short Term
TIF Pa back Installments
213.46530.6130
213.46530.6030
213.46530.6511
TIF #33 - TAPPER'S HOLDINGS
TIF Pa back Installments
2007 BUDGET.xLS;Spec Revenue Fund-HRA Fund:1/8/2007
87
SPECIAL REVENUE FUND
2007 Budget
HRA Fund
COMMENTS:
Salaries: 60% Ollie
Transfers:
Downtown
$137,900
Debt Service: Principal - Contract for Deed payment of $1 00 , ODD/year for industrial
park land acquisition
2007 BUDGET.xLS:Spec Revenue Fund-HRA Fund:1/8/2007
88
SPECIAL REVENUE FUND
2007 Budget
ENVIRONMENTAL CLEAN UP
REVENUE
DTEDllnvesti ative Grant ~ Ruff
DTED/Clean U Grant - Ruff
Other Mise Rev w DTED/Ruff
216.33430
216.33431
216.36299
$0
$0
$0
--....._--....-.......-.........._~--~....._~....._~....._~--....._....-......---....._-
EXPENDITURES
2007 BUDGET/EXCEL:Spec Revenue Fund - Environment:1/8/2007
89
SPECIAL REVENUE FUND
2007 BUDGET
MNINVESTMENTFUND
REVENUE
Interest Earnin s
Interst Earnin s - TC Die Castin s
Interest Earnin s - UMC
--....._---........_------~---~...._---~--..,--...._-_...._~....
EXPENDITURES
2007 BUDGET.xLS:Spec Revenue Fund-Mn Inv:1/8/2007
90
SPECIAL REVENUE FUND
2007 Budget
SCERG (Economic Recovery Grant)
REVENUE
Grant Administration Fee:
Interest Earnin s - Aroplax:
--..............-------.....---.....-.....----I!IIIIIIII...___illll.-_____..........__1iIIiIIII
2007 BUDGET.XLS:Spec Revenue Fund-SCERG:1/8/2007
91
SPECIAL REVENUE FUND
2007 Budget
CMIF (Central Minnesota Initiative Fund)
REVENUE
Grant Administrative Fee:
Interest Earnin s:
--------.-.....-.....-....--~----....._IIiIIIIi___~__.....___...._IIiIIIiI__
EXPENDITURES
2007 BUDGET.XLS:Spec Revenue Fund-CMIF:1/8/2007
92
SPECIAL REVENUE FUND
2007 Budget
Shade Tree Fund
REVENUE
Current Ad Valorem Taxes
Tree & Brush Removal:
SA Principal - Count :
Interest Earnin s:
224.31011
224.34305
224.36101
224.36210
EXPENDITURES
Personal Services
Salaries, Full-time-Re :
Salaries, Full-time-OT:
Salaries, Tem orar -Re :
PERA Contributions:
FICA Contributions:
Medicare Contributions:
Health/Dental/Life Insurance:
224.46102.1010
244.46102.1020
224.46102.1040
224.46102.1210
224.46102.1220
224.46102.1250
224.46102.1310
$14,240
$300
$300
$930
$920
$215
$3,010
224.46102.2065
224.46102.2099
224.46102.2111
224.46102.2120
224.46102.2130
224.46102.2199
224.46102.2210
224.46102.2211
224.46102.2299
$100
$50
$300
$0
$0
$600
$400
$600
$1,500
Small Tools and Equi ment
Small Tools & Equipment
T&E/Machiner
T &E/Furniture
T&E/Office Equipment
T&E/Computer Equipment
T &E/Other
224.46102.2410
224.46102.2440
224.46102.2460
224.46102.2471
224.46102.2472
224.46102.2499
2007 BUDGET.xLS:Spec Revenue Fund~Shade Tree:1/8/2007
93
SPECIAL REVENUE FUND
2007 Budget
Shade Tree Fund
Services & Char es
Misc Professional Services:
Conference & Schools:
General Public Information:
Re air & Maintenance: Mach. & E ui
E ui ment Rental
Dues, Membership & Subscri tions
Tree Re lacement:
Misc Other Expense:
224.46102.3199
224.46102.3320
224.46102.3520
224.46102.4044
224.46102.4150
224.46102.4330
224.46102.4391
224.46102.4399
$5,000
$1,000
$600
$400
$0
$0
$6,000
$0
COMMENTS:
Salaries:
10% Seth, Tom G, and Leo S
2007 BUDGETXLS:Spec Revenue Fund-Shade Tree:1/8/2007
94
SPECIAL REVENUE FUND
2007 Budget
Park Fund
REVENUE
2006
2007
Current Ad Valorem Taxes 225.31011 $780,125 $805,545
Delinquent Ad Valorem Taxes 225.31021 $0 $0
Mobile Home Tax 225.31031 $0 $0
Pen & Int - Ad Valorem Taxes 2225.31910 $0 $0
Team Fees 225.34770 $500 $5,000
Field/Tournament Fees 225.34771 $500 $3,000
Park Rental Fees 225.34780 $3,200 $4,000
Concession Revenue 225.34772 $3,500 $0
Other Charges for Services 225.34999 $0 $0
Interest Earnings 225.36210 $7,500 $12,960
Refunds/Reimbursements In 225.36290 $0 $0
Other Miscellaneous Revenue 225.36299 $100 $100
Transfer from General Fund 225.39201 $0 $0
Transfer from Other Funds 225.39203 $0 $0
\, ~ A J , , I ' '" J, I," , . J ~ L'J " !!')...;-:; i; ;;;\ ~1h,
" .
.---~---"""""-~---""''''-----------~-~''''--'''''___IIIIIWI''''__''''''''__
EXPENDITURES
225.45201.1010
225.45201.1020
225.45201.1030
225.45201.1031
225.45201.1040
225.45201.1050
225.45201.1090
225.45201.1110
225.45201.1210
225.45201.1220
225.45201.1250
225.45201.1310
225.45201.1420
225.45201.1520
$205,870
$3,000
$0
$0
$68,000
$0
$0
$2,500
$16,615
$17,165
$4,015
$35,260
$0
$0
$213,920
$2,600
$0
$0
$65,000
$0
$0
$500
$17,595
$17,455
$4,080
$39,155
$500
$0
Supplies
Printed Forms & Paper 225.45201.2030 $0 $0
Safety Supplies 225.45201.2065 $2,600 $2,600
Misc Office Supplies 225.45201.2099 $150 $150
CleaninQ Supplies 225.45201.2110 $850 $1 ,000
Clothing Supplies 225.45201.2111 $700 $500
Motor Fuels 225.45201.2120 $23,000 $30,000
Lubricants & Additives 225.45201.2130 $4,200 $1,000
Chemical Products 225.45201.2160 $10,000 $12,000
2007 BUDGET.XLS:SpecRevParksWkst: 1 /8/2007
95
SliT I
dE'
t
SPECIAL REVENUE FUND
2007 Budget
Park Fund
225.45201.2199
225.45201.2210
225.45201.2211
225.45201.2220
225.45201.2230
225.45201.2250
225.45201.2299
$18,000
$6,400
$4,000
$1,500
$4,500
$12,000
$15,000
$20,000
$6,400
$4,000
$1,500
$3,000
$15,000
$15,000
ma 00 s an :qUlpmen
Small Tools/Mise 225.45201.2410 $1,500 $2,000
T &E/Machinery 225.45201.2440 $2,500 $2,000
T &E/Furniture 225.45201.2460 $0 $0
T &E/Equipment $8,500 $0
T&E/Office Equipment 225.45201.2471 $0 $0
T&E/Computer Equipment 225.45201.2472 $0 $0
T&E/Other 225.45201.2499 $2,500 $0
, I 1 " 'I ill! I' ,,' I lJ -1'1-'1 "11' ..
: ~\I . 1 :~ 1 \'J / I :: . , \ \J : ~ I' 11 ('" J. \ I ~ tl j '1 ,;" ". IJ.I' ~ ' ,"~ Olil~,
Services and Char es
Professional Services - Custodial
Maintenance A reements
Misc Professional Services
Telephone
Travel Expense
Conference & Schools
Frei ht
Advertisin
General Public Information
Vehicle Insurance
Electric
Gas
Repair & Mtc - Buildin s
Re air & Mtc - Mach & Equipment
Re air & Mtc - Vehicles
Adopt-A-Park Maint/Ex ense
Pathwa Maintenance
Repair & Maintenance - Other
Equi ment Rental
Uniform Rental
Mise Rentals
Dues/Mem berships/Subscriptions
Books & Pam hlets
Towin Char es
Licenses & Permits
Prizes
Tree Replacement
Mise Other Ex ense
2007 BUDGETXLS:SpecRevParksWkst:1/8/2007
225.45201.3110
225.45201.3190
225.45201.3199
225.45201.3210
225.45201.3310
225.45201.3320
225.45201.3330
225.45201.3499
225.45201.3520
225.45201.3630
225.45201.3810
225.45201.3830
225.45201.4010
225.45201.4044
225.45201.4050
225.45201.4090
225.45201.4091
225.45201 .4099
225.45201 .4150
225.45201.4170
225.45201.4199
225.45201.4330
225.45201.4350
225.45201.4360
225.45201.4370
225.45201.4390
225.45201.4391
225.45201.4399
$0
$0
$5,500
$2,850
$450
$2,400
$0
$600
$600
$0
$6,500
$1,600
$3,300
$5,000
$2,200
$2,000
$3,500
$2,000
$1 ,400
$0
$0
$400
$150
$0
$0
$0
$0
$6,000
$0
$0
$3,000
$3,000
$450
$2,500
$0
$600
$600
$0
$7,000
$1,600
$6,000
$5,000
$2,000
$3,000
$4,000
$2,000
$1,000
$2,100
$0
$400
$150
$0
$0
$0
$0
$5,000
96
SPEC~LREVENUEFUND
2007 Budget
Park Fund
225.45201.5301
225.45201.5501
225.45201.5601
225.45201.5801
Parksllm rovements
Misc 0 eratin Sup lies
T&E Other
Misc Professional Services
Park Tree Replacement
Swan River Park Viewin Deck
Sunset Ponds Recreation Equipment
West/East Brid e Park Improvements
4th Street Park Improvement
Ellison Park Restrooms
Count Club Park 1m rovements
Hillcrest Park Improvements
Bui/din s
1m rovements
Recreation Equi ment
225.45202.2199
225.45202.2499
225.45202.3199
$6,000
$6,500
$0
$0
$0
$0
$0
$0
$0
$0
$0
$75,000
$150,000
$0
$6,000
$4,200
$0
$5,000
$0
$0
$0
$0
$0
$0
$0
$75,000
$53,000
$92,000
225.45202.5201
225.45202.5301
225.45202.5805
NSP Ballfields
Safe!y SUJlPlies 225.45203.2065 $150 $100
Cleaning Suppies 225.45203.2110 $150 $150
Motor Fuels 225.45203.2120 $0 $0
Lubricants 225.45203.2130 $250 $100
General Operating Supplies 225.45203.2199 $600 $600
Equipment Repair Parts 225.45203.2210 $0 $200
Vehicle Repair Parts 225.45203.2211 $0 $100
Building Repair Supplies 225.45203.2230 $0 $300
Landscaping Materials 225.45203.2250 $0 $400
Misc. R~air/Maint. SupJ'lies 225.45203.2299 $3,400 $5,000
Small Tools Mise 225.45203.2410 $0 $0
T&E Machinery 225.45203.2440 $0 $0
T&E Other 225.45203.2499 $0 $2,000
Misc. Professional Services 225.45203.3199 $2,000 $2,000
Telephone 225.45203.3210 $0 $0
Advertisil}9 225.45203.3499 $0 $0
Electrici!y 225.45203.3810 $7,000 $7,600
Repair/Maint - Bui/dil}9s 225.45203.4010 $0 $0
Repair/Maint - Machin~E~uipment 225.45203.4044 $0 $0
Repair/Maint - Parks & Recreation 225.45203.4080 $0 $0
Repair/Maint - Other 225.45203.4099 $0 $0
Misc. Other Expense 225.45203.4399 $0 $500
Improvements 225.45203.5301 $6,500 $0
2007 BUDGET.XLS:SpeCRevParksWkst: 1/8/2007
97
Other Equipment
Transfer to Other Funds
SPECIAL REVENUE FUND
2007 Budget
Park Fund
225.45203.5801
225.45203.7203
~., w " i. ~ ,. " ,.' ,. "1 .,
...'t~ I ~p-. "~.i. . ~ 'fit:::., 'p. j l
COMMENTS:
Salaries: 100% Tom P., 90% Seth, Leo & Tom G, 85% John L
Capital BuildinQs: Ellison Park Restrooms
$75,000
$5,000
$15,000
$10,000
$3,000
$20.000
$53,000
$52,000
$40.000
$92,000
Capital Improvements: 4th St Hardcourt
Swan Park Viewing Deck
West Bridge Park Shelter
Backstop for Country Club Park
4th St Parking Lot Overlay
Recreation Equipment: Sunset Ponds
Hillcrest Park
2007 BUDGETXLS:SpecRevParksWksl:1/8/2007
98
SPECIAL REVENUE FUND
2007 Budget
Community Center
REVENUE
Current Ad Valorem Taxes
Delin uent Ad Valorem Taxes
Mobile Home Tax
Penalt & Interest - Ad Valorem Taxes
Homestead Credit
State Grants & Aids - Other
Room/S ace Rental
Kitchen Rental
Cha el Rental
NSF Fee
Concessions
Ballfield Concessions
Part Room Rental
User Fees
Membershi s
Pro ram Activit Fees
Other Char es for Services
Interest Earnin s
Rental of E ui ment
Contributions - Private
Other Misc Revenue
Transfers from General Fund
Transfer from Li uor Fund
226,31011
226,31021
226,31031
226,31910
226,33402
226.33429
226,34101
226,34102
226,34104
226.34198
226,34740
226,34772
226.34755
226.34790
226,34791
226,34792
226,34999
226,36210
226,36221
226,36230
226,36299
226,39201
226,39207
EXPENDITURES
2006
$908,895
$0
$0
$0
$0
$0
$137,000
$0
$0
$0
$89,500
$0
$33,700
$52,000
$500,000
$65,000
$10,000
$3,000
$500
$3,000
$500
$0
$250,000
2007
$1,246,570
$0
$0
$0
$0
$0
$150,000
$0
$15,000
$500
$90,000
$22,500
$38,000
$52,000
$545,000
$70,000
$8,000
$8,945
$300
$0
$0
$0
$250,000
226.45122.1010
226.45122,1020
226.45122,1030
226.45122,1031
226.45122.1040
226.45122.1050
226.45122.1090
226.45122.1110
226.45122.1210
226.45122.1220
226.45122.1250
226.45122.1310
226.45122,1420
226.45122.1520
$309,150
$6,500
$330,000
$250
$0
$0
$0
$0
$34,370
$40,045
$9,365
$77,930
$0
$0
S I'
$296,000
$4,500
$320,000
$500
$0
$0
$0
$5,000
$27,660
$38,500
$9,005
$57,405
$0
$0
upp 105
Printed Forms & Paper 226.45122.2030 $1,000 $1,000
Proqram OperatinQ Costs 226.45122.2065 $0 $0
Misc Office Supplies 226.45122.2099 $4,500 $3,000
Cleaninq Supplies 226.45122.2110 $8,000 $8,000
Clothing Supplies 226.45122.2111 $4,000 $4,000
Motor Fuels 226.45122.2120 $0 $100
Lubricants & Additives 226.45122.2130 $0 $0
Chemical Products 226.45122.2160 $11,000 $11,000
Pool Maintenance Supplies 226.45122.2161 $5,000 $6,200
Misc Operatinq SUpplies 226.45122.2199 $21,720 $22,000
Equipment Repair Parts 226.45122.2210 $6,000 $7,500
2076 BUDGET.XLS:Spec Revenue Fund-Comm, Ctr.:1/8/2007
99
SPECIAL REVENUE FUND
2007 Budget
Community Center
226.45122.2211
226.45122.2220
226.45122.2230
226.45122.2250
lies 226.45122.2299
226.45122.2410
226.45122.2440
226.45122.2460
226.45122.2471
226.45122.2499
$0
$0
$4,000
$2,000
$12,000
$2,500
$3,000
$2,000
$2,500
$4,000
Services & Charges
Professional Services - Manaqement Fee 226.45122.3070 $400 $1,800
Professional Services - Data Processing 226.45122.3090 $4,000 $5,000
Professional Services - Software/Proqramminq 226.45122.3091 $0 $500
Professional Services - Website/E-mail 226.45122.3092 $4,000 $0
Professional Services - Custodial 226.45122.3110 $1,000 $1,000
Professional Services - Laundrv 226.45122.3111 $3,000 $2,500
Professional Services - BldQ/Equipment 226.45122.3112 $6,500 $9,000
Maintenance Aqreement 226.45122.3190 $10,000 $10,000
Professional Services - Newsletter 226.45122.3195 $0 $1,000
Misc Professional Services 226.45122.3199 $6,000 $5,000
Telephone 226.45122.3210 $12,000 $11,000
Postaqe 226.45122.3220 $1,000 $500
Cable/Network Services 226.45122.3250 $2,500 $1,500
Travel Expense 226.45122.3310 $900 $1,000
Conferences & Schools 226.45122.3320 $6,000 $3,000
Expo Exhibitor Admission 226.45122.3490 $4,500 $1,500
Advertising 226.45122.3499 $12,000 $10,000
General Public Information 226.45122.3520 $1,000 $500
Brochures 226.45122.3560 $7,200 $3,000
General Liability Insurance 226.45122.3610 $29,715 $19,095
Propertv Insurance 226.45122.3620 $8,500 $10,515
Misc General Insurance (Work Comp) 226.45122.3699 $13,670 $18,160
Electric 226.45122.3810 $74,000 $95,000
Gas 226.45122.3830 $77,000 $120,000
Repair & Maintenance - Buildinq 226.45122.4010 $5,000 $93,000
Repair & Maintenance - Machinery & Equipment 226.45122.4044 $6,000 $62,500
Repair & Maintenance - Pool 226.45122.4050 $0 $13,500
Repair & Maintenance - Other 226.45122.4099 $2,000 $1,500
Equipment Rental 226.45122.4150 $12,000 $14,000
Uniform Rental 226.45122.4170 $1,500 $1,000
Towel Rental 226.45122.4171 $1,100 $1,500
Dues,Memberships & Subscriptions 226.45122.4330 $1,800 $1,000
Towinq Charges 226.45122.4360 $0 $0
Licenses & Permits 226.45122.4370 $700 $500
Customer Discounts 226.45122.4379 $0 $0
Prizes 226.45122.4390 $0 $100
Bank Chames 226.45122.4398 $7,000 $15,000
Misc Other Expense 226.45122.4399 $300 $300
o enin Celebration Ex ense 226.45122.4429 $0 $0
2076 BUDGETXLS:Spec Revenue Fund-Comm. Ctr.:1/8/2007
100
SPECIAL REVENUE FUND
2007 Budget
Community Center
Salaries: Full-time: Kitty, Sara, Brian, Tricia, (3) custodians
226.45122.5201
226.45122.5301
226.45122.5501
226.45122.5601
226.45122.5701
226.45122.5702
226.45122.5801
$5,600
$67,900
$0
$18,950
$0
$0
$0
226.45127.2075
226.45127.2099
226.45127.2145
226.45127.2146
226.45127.2147
226.45127.2171
226.45127.2172
226.45127.2173
226.45127.2174
226.45127.2175
226.45127.2176
226.45127.2177
226.45127.2198
226.45122.2445
226.45122.2460
226.45122.2490
226.45127.2499
226.45127.2541
226.45127.2542
226.45127.2549
226.45127.3012
226.45127.3013
226.45127.3199
226.45127.3499
226.45127.4150
226.45127.4330
226.45127.4390
$2,000
$0
$3,000
$6,200
$0
$1,000
$500
$500
$1,000
$2,500
$1,000
$250
$6,000
$14,900
$6,500
$3,200
$0
$56,000
$0
$2,000
$1,000
$2,000
$1,200
$2,000
$1,000
$0
$1,200
$3,500
$0
$2,500
$8,000
$500
$1,200
$1,000
$700
$1,000
$4,000
$500
$300
$6,000
$0
$3,000
$2,000
$9,800
$60,000
$27,350
$3,000
$1,000
$1,000
$4,000
$2,500
$500
$0
$500
Transfer Out: Transfer to Debt Service to cover payment due on Community Center Bond
2076 BUDGETXLS:Spec Revenue Fund-Comm. Ctr.:1/8/2007
101
SPECIAL REVENUE FUND
2007 Budget
Park/Pathway Dedication Fund
REVENUE
Park Dedication Fees 229.34950 $35,000
Pathway Fees 229.34952 $16,000
S A County 21116-4 Groveland) 229.36107 $0
S A County 21111~0 Klein Farms 6th) 229.36108 $0
S A County 21119~0 River Forest II 229.36110 $0
S A County 21118-4 Rolling Woods 229.36111 $60
S A County 21118-4 Rolling Woods~Path) 229.36113 $25
S A County 231112-Gillard Path) 229.36115 $1,784
S A County 231111-Fair Ret. Wall) 229.36117 $195
S A County 235113 - Morning Glory - Park 229.36119 $0
S A County 235113 - Morning Glory ~ Path 229.36121 $0
S A County 235114 - Timber Ridge Path) 229.36123 $1,077
S A County 235114 - Timber Ridae - Park 339.36125 $4,087
S A County 235115 - Vine Place Path 229.36127 $214
S A County 235115 - Vine Place Park) 229-36129 $406
S A County 221110 - Klein Farms 7th Park 229.36131 $0
S A County 221111-Klein Farms Est 2nd Park) 229.36133 $0
S A County 221112 ~ Klein Farms Est 4th Park) 229.36135 $0
S A County 225110 - Monticello Village) 229.36137 $6,075
S A County 36139 - Autumn Ridge II ~ Park) 229.36139 $0
S A County 36139 - Autumn RidQe II - Path) 229.36141 $0
S A County 201110 MMC/Riverview 229.36143 $914
S A County 2004-17C Timber RidQe 3rd Park) 229.36145 $1,382
S A County 2004-17C Timber Ridge 3rd Path) 229.36147 $274
S A County 2003-8P Parkside 2nd Park) 229.36149 $3,859
S A County 2003-8P Parkside 2nd Path) 229.36151 $1 ,122
S A County 2003-12P Hillside Farms Park 229.36153 $119
S A County 2003-12P Hillside Farms Path 229.36156 $33
S A County 2003-15P Sunset Ponds Park 229.36157 $44
S A County 2003-15P Sunset Ponds Path 229.36159 $2
S A County 2003-16P Spirit Hills Park 229.36161 $1,576
S A County 2003-16P Spirit Hills Path 229.36163 $608
S A County 2004-8P Hillside 2nd Park 229.36165 $116
S A County (2004~8P Hillside 2nd Path 229.36166 $34
S A County 2004-16P Carlisle Village Park) 229.36169 $13,503
S A County 2004-16P Carlisle Village Path 229.36171 $148
S A County 2002-09C - Groveland 4th 229.36193 $0
S A County Hunters Crossing Park 229.36173 $1,507
S A County Hunters Crossing Path) 229.36175 $712
S A County Carlisle Village 4th Path 229.36179 $1,817
S A County Sunset Ponds 2nd Park 229.36181 $6,620
S A County Sunset Ponds 2nd Path 229.36183 $3,708
S A County Timber Ridge 2nd Park 229.36185 $10,103
S A County Timber Ridae 2nd Path) 229.36187 $1,670
2006 BUDGET .XLS:SpecRevFunds-ParksPathway: 1 /8/2007
102
SPECIAL REVENUE FUND
2007 Budget
Park/Pathway Dedication Fund
Nathan Court Park 229.36189
Nathan Court Path 229.36191
Hunters Crossin 2nd Park 229.36195
S A Count Hunters Crossin 2nd Path 229.36197
Interest Earnin s 229.36210
$718
$142
$4,616
$1,820
$23,275
..........~-....-.........-...._----........--.-........._---....._--.....---~--.......~...................
229.45202.3030
229.45202.5102
229.45202.5391
COMMENTS:
Park Land: Future ballfields site reserve
Mise Professional Services: YMCA Task Force negotiations
2006 BUDGET.XLS: SpecRevFunds-ParksPalhway: 1/8/2007
103
SPECIAL REVENUE FUND
2007 Budget
OAA Fund
REVENUE
Current Ad Valorem Taxes:
Local Government Aid:
Interest Earnin s:
Other Miscellaneous Revenue
230.31011
230.33401
230.36210
230.36299
$650
$0
$0
$15,050
--.........---~....._............._-...._~-..._............._....~_...__..._----------
EXPENDITURES
Personal Services
Salaries ~ Other:
Professional Services - Le al Fees
Services & Char es
OM Contract Pa ment:
Misc Professional Services:
Travel Expense:
General Liabilit Insurance
230.46401.3130
230.46401.3199
230.46401.3310
230.46401.3610
Contract Payments: Real Estate Tax Reimbursement to Township for Annexations.
2007 BUDGET.XLS:Spec Revenue Fund-OM Fund:1/8/2007
104
SPECIAL REVENUE FUND
2007 Budget
Capital Improvement Revolving Fund
REVENUE
240.31011
240.39460
240.36101
240.36105
240.36107
240.36117
240.36119
240.36121
240.36123
240.36127
240.36129
240.36131
240.36151
240.36161
240.36163
240.36165
240.36171
240.36181
240.36191
240.36210
240.36220
240.36240
$0
$595,000
$0
$8,409
$4,043
$2,101
$52,253
$192
$0
$4,416
$1,390
$999
$3,348
$0
$0
$0
$3,150
$1,252
$3,185
$56,175
$0
$0
EXPENDITURES
240.49201.5101
240.49201.5201
240.49201.5301
240.49201.5401
240.49201.5501
240.49201.5601
240.49201.5801
$0
$0
$2,215,000
$0
$0
$0
$0
Debt Service
Transfer to Other Funds
2007 BUDGETXLS:Spec Revenue Fund-Cap. Imp. Rev:1/8/2007
105
SPECIAL REVENUE FUND
2007 Budget
Capital Improvement Revolving Fund
COMMENTS:
Improvements: Otter Creek Grading
Cedar SUDundas Rd
Dalton Ave/School Blvd
$365,000
$850,000
$1,000,000
$2,215,000
Misc Professional Services: Consulting Engineering Fees that are
reimbursable from developers/projects
2007 BUDGET.xLS:Spec Revenue Fund-Cap. Imp. Rev;1/8/2007
106
SPECIAL REVENUE FUND
2007 Budget
Economic Development Authority
REVENUE
Initiation/Application Fee:
Interest Earnin s:
Interest Earnin s - Aro lax:
Interest Earnin s - Custom Canop :
Interest Earnin s - Standard Iron:
Interest Earnin s - Vector Tool:
Interest Earnin s -Tapper's # 011:
Interest Earnin s - Standard Iron # 013:
Interest Earnin s - T J Martin #014:
Interest Earnin s - Mainline #015
Interest Earnin s - Aroplax #016
Interest Earnin s - TC Die Castin s
Interest Earnin s - IRTI #018
Interest Earnin s - EDMA #019
Interest Earnin s - Ta er's #021
Interest Earnin s - UMC #022
Interest Earnin s - WSIIND #023
Interest Earnin s - Ta er's #024
Interest Earnin s - DMRF-111 Visicom
250.34109
250.36210
250.36214
250.36215
250.36216
250.36217
250.36218
250.36219
250.36220
250.36311
250.36312
250.36313
250.36314
250.36315
250.36317
250.36318
250.36319
250.36320
250.36601
$200
$24,305
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$940
$4,560
$6,320
$6,620
$0
EXPENDITURES
Services & Char es
Misc. Professional Services: Legal
Mise Professional Services:
Loan Servicin Fee:
Grant Appropriations
250.46501.2040
250.46501.3199
250.46501.4397
250.46501.4340
$1,000
$0
$0
$0
Debt Service
Grant Reimbursement:
2007 BUDGET.XLS:Spec Revenue Fund-Econ Dev Auth:1/8/2007
107
SPECIAL REVENUE FUNDS
2007 Budget
Sanitary Sewer Access Fund
REVENUE
S&W Access - Basic: 262.34110 $0
S&W Access ~ WWTP: 262.34111 $740,000
Trunk Line Area Charge: 262.34115 $180,000
Lift Station Hookup Charge: 262.34120 $0
SA Principal ~ County: '2031130 RV FORfTRK) 262.36101 $0
SA Principal - County:( 21111- KF 6TH) 262.36108 $0
SA Principal - County: 96-13P KJELLBERG) 262.36111 $3,475
SA Principal - County: (21118-4 ROLL WD) 262.36113 $115
S. A Principal - County: 21112-0 WWR) 262.36115 $0
SA Principal - County: 21113-0 WWR 2) 262.36117 $0
SA Principal ~ County: 201121 ST HENRYITRK) 262.36119 $2,306
SA Principal - County: 21115-2 METH CH) 262.36121 $794
SA Principal - County: 21115-1 MASTERS) 262.36123 $253
SA Principal ~ County: 21115-0 RV CTRfTRK) 262.36125 $473
SA Principal - County: 21115-6 AROPLAX) 262.36127 $134
SA Principal - County: 991111 OLSON/SW) 262.36129 $0
SA Principal - County: 237116 KJELL W TRNK) 262.36131 $10,425
SA Principal - County: 225110 MONT VILLAGE) 262.36133 $832
SA Principal - County ( 2003-2C MO BYPASS) 226.36135 $21,324
SA Principal - County: 234111 VAUGHN) 262.36137 $528
SA Principal - County: 234112 TRINITY LUTH) 262.36139 $237
SA Principal ~ County C21118-0 MASTER SWR) 262.36141 $1,536
SA Principal - County: 201110 MMC/R/VERW) 262.36143 $523
S. A Principal - County: 2001-03C GR BELT SF) 262.36145 $110,105
SA Principal ~ County: 234113 GOULDS) 262.36149 $1,274
SA Principal ~ Coun!y: 211150 RV CTR SEWER) 262.31510 $765
SA Principal- County: 234114 GROVELAND CT) 262.36153 $0
SA Principal- County: 235112 UMC/TOMANN) 262.36155 $275
SA Principal - County: 235113 MORNING GLORY) 262.36157 $0
SA Principal - County: 235114 TIMBER RIDGE) 262.36159 $1,665
SA Principal - County: 235115 VINE PLACE). 262.36161 $358
SA Principal - County: 221110 KF 7TH) 262.36163 $0
SA Principal - County: 221111 KFE 2ND) 262.36165 $0
SA Principal - County: 221112 KRE 4TH) 262.36167 $0
SA Principal - County: 222112 EDMA) 262.36169 $343
SA Principal - County: 222113 INTEG RECYCL) 262.36171 $504
SA Principal - County: 222114 MONT DODGE) 262.36173 $0
SA Principal ~ County: 222115 MONT AUTOBODY) 262.36175 $194
SA Principal- County: 222116 MONT FORD) 262.36177 $686
SA Principal - County: 222117 WILLI HAHN) 262.36179 $245
SA Principal - County: 222118 ATTIC MINI) 262.36181 $162
SA Principal - County: 222119 AMAX STORAGE) 262.36183 $755
SA Principal - County: 225111 SUNNY FRESH) 262.36185 $155
SA Principal - County: 242112 MONT MARKET) 262.36187 $483
2007 BUDGET.xLS:Special Rev Fund-San Sewer:1/8/2007
108
SPECIAL REVENUE FUNDS
2007 Budget
Sanitary Sewer Access Fund
262.36189
262.36191
262.36193
262.36195
262.36197
262.36210
262.36701
262.36703
262.36705
262.36707
262.36709
262.36711
262.36713
262.36715
262.36717
262.36721
262.36723
262.36725
262.36727
262.36729
262.37631
262.36733
262.36735
262.36737
262.39310
$0
$288
$0
$0
$370
$239,050
$5,077
$128
$3,261
$122
$1,979
$3,403
$523
$580
$85
$4,191
$8,065
$5,769
$2,469
$1 ,185
$501
$1,113
$576
$6,321
$6,000,000
--_....._~____________......~____...IIIiIiII~IIiIIIIIIMiIIiIr.....illlllltlllllllllllllillllilllilll........illlllililllllill_
EXPENDITURES
Capital Outlay
Buildings
1m rovements
Motor Vehicles:
Other E ui ment:
262.49201.5201
262.49201.5301
262.49201.5501
262.49201.5801
$290,000
$8,200,000
$0
$0
Transfer
Transfer to Other Funds
Transfer to WWTP
Transfer to Trunk Fees
262.49201.7205
262.49201.7207
262.49201.7208
$0
$0
$1,082,300
2007 BUDGET.XLS:Special Rev Fund-San Sewer:1/8/2007
109
SPECIAL REVENUE FUNDS
2007 Budget
Sanitary Sewer Access Fund
COMMENTS:
Capital Improvements:
Bldgs: Vehicle storage bldg at WWTP
Biosolids dryer bldg/equip
$290,000
$8,200,000
2007 BUDGET.xLS:Special Rev Fund-San Sewer:1/8/2007
110
SPECIAL REVENUE FUNDS
2007 Budget
Storm Sewer Access Fund
REVENUE
Trunk line area charQe: 263.34115 $200,000
SA Principal - CounfY<20113-0 Riv For/Trk) 263.36101 $0
SA Principal - County 21111-0 KF 6th) 236.36108 $0
SA Principal - County 21118-3 parkside) 236.36109 $0
SA Principal - County 993110 Res Church) 236.36111 $3,830
SA Prinicpal - County 21118-4 Roll Wd) 236.36113 $129
SA Principal - County 21112-0 WWR) 236.36115 $0
SA Principal - County 21113-0 WWR2) 263.36117 $0
SA Principal- County 201120 St Henry/Trk) 263.36119 $6,227
SA Principal - County 21115-2 Meth Ch) 263.36121 $2,117
SA Principal- County 21115-1 Masters) 263.36123 $771
SA Principal - County 99110 Mont BI Hosp) 263-36125 $0
SA Principal - County 21115-6 AroplaX) 263.36127 $384
SA Principal- County, 21115-4 Ford) 263.36129 $501
SA Principal - County 21115-7 Thein Trk) 263.36131 $1,332
SA Principal - County 21115-5 Danner Trk) 263.36135 $406
SA Principal - County 234111 Vauqhn) 263.36137 $1.388
SA Principal - County 234112 Trinity Luth) 263.36139 $723
SA Principal - County 235111 Tappers) 263.36141 $1,342
SA Principal - County 201110 MMC/Riverview) 263.36143 $1,587
SA Principal - County 222111 Michaelis Oif) 263.36145 $1,153
SA Principal - County 222110 Ultra Lube) 263.36147 $428
SA Principal - County 234113 Gould's) 263.36149 $3,894
SA Principal - County 235114 Timber Ridqe/RR) 263.36151 $15,723
SA Principal - County 234114 Groveland Ctr 263.36153 $0
SA Principal - County 235112 UMC/Tomann) 263.36155 $795
SA Principal - County 235113 Morning Glory) 263.36157 $0
SA Principal - County 235114 Timber Ridge) 263.36159 $3,912
SA Principal - County 235115 Vine Place) 263.36161 $849
SA Principal - County 221110 KF 7th) 263.36163 $0
SA Principal - County 221111 KFE 2nd) 263.36165 $0
SA Principal - County 221112 KFE 4th) 263.36167 $0
SA Principal - County 222112 EDMA) 263.36169 $996
SA Principal - County 222113 Inteq Recyc) 263.36171 $1 ,458
SA Principal - County 222114 Mont Dodge) 263.36173 $0
SA Principal - County (222115 Mont AutobodY) 263.36175 $594
SA Principal - County 222116 Mont Ford) 263.36177 $2,078
SA Principal - County I 222117 Willi Hahn) 263.36179 $2,226
SA Principal - County 222118 Attic Mini St) 263.36181 $468
SA Principal- County 222119 Amax Storage 263.36183 $877
SA Principal - County 225111 Sunny Fresh) 263.36185 $469
SA Prinicpal- County, 242112 Mont Market) 263.36187 $1 ,4 73
SA Principal - County Krutzig-Bus Ctr 2) 263.36189 $0
2007 BUDGET.xLS;Special Rev - Storm Sewer;1/8/2007
111
SPECIAL REVENUE FUNDS
2007 Budget
Storm Sewer Access Fund
263.36191
263.36193
263.36195
263.36196
263.36210
263.36701
263.36703
263.36705
263.36707
263.36709
263.36712
263.36713
263.36715
263.36717
263.36721
263.36723
263.36725
263.26726
263.36729
263.36731
263.36733
263.36735
263.36737
263.36791
263.36793
263.36792
$832
$0
$0
$1,020
$75,250
$10,585
$121
$3,475
$251
$3,330
$10,910
$1,678
$1,758
$272
$6,012
$19,298
$12,993
$6,300
$1,280
$1,606
$3,397
$1,663
$13,718
$115
$8,659
$3,092
EXPENDITURES
Transfers
Transfer Out - Debt Service
2007 BUDGETXLS:Special Rev - Storm Sewer:1/8/2007
112
SPECIAL REVENUE FUNDS
2007 Budget
Water Access Fund
REVENUE
S & W Hookup Charges: 265.34110 $154,000
Trunk Line Area Charge: 265.34115 $120,000
SA Principal - County(20113-0 Riv For/Trk 265.36101 $0
SA Principal - Direct(21111-0 KF 6th) 265.36104 $0
SA Principal- County(21111-0 KF 6th) 265.36108 $0
SA Principal ~ County(2003-12P Hillside) 265.36111 $78
SA Principal - County 21118-4 Roll Wd) 265.36113 $60
SA Principal - County, 21112-0 WWR) 265.36115 $0
SA Principal - County 21113-0 WWR 2) 265.36117 $0
SA Principal - County (201122 St Henry Trk) 265.36119 $1,153
SA Principal - County (21115~2 Meth Ch) 265.36121 $397
SA Principal - County (21115-1 Masters) 265.36123 $127
SA Principal - County 21115-0 RV Ctr Trk) 265.36125 $250
SA Principal - County 21115-6 Aroplax) 265.36127 $64
SA Principal - County 233110 Meth Ch 99-10) 265.36129 $2,902
SA Principal - County 233110 Meth Ch 88-06) 265.36131 $1,168
SA Principal - County 225110 Mont Village) 265.36133 $422
SA Principal - County 234111 Vaughn) 265.36137 $416
SA Principal - County 234112 Trinity Luth) 265.36139 $186
SA Principal - County 242111 Mielke Util) 265.36141 $9,589
SA Principal - County 201110 MMC/Riverview) 265.36143 $263
SA Principal - County 223110 NeerQaard) 265.36145 $0
SA Principal - County 234113 Gould's) 265.36149 $1,004
SA Principal - County 21115 RV Ctr/W Acc 265.36151 $62
SA Principal - County 234114 Groveland Ctr 265.36153 $0
SA Principal - County 235112 UMC/Tomann 265.36155 $217
SA Principal - County 235113 Morning Glory) 265.36157 $0
SA Principal - County 235114 Timber Ridge 265.36159 $1,312
SA Principal - County 235115 Vine Place) 265.36161 $282
SA Principal - County 22111 0 KF 7th) 265.36163 $0
SA Principal - County 221111 KFE 2nd) 265.36165 $0
SA Principal - County 221112 KFE 4th) 265.36167 $0
SA Principal - County 222112 EDMA) 265.36169 $272
SA Principal ~ County 222113 Integ Recyc 265.36171 $397
SA Principal - County 222114 Mont Dodge) 265.36173 $0
SA Principal - County 222115 Mont Autobody) 265.36175 $153
SA Principal - county 222116 Mont Ford) 265.36177 $352
SA Principal - County 222117 Willi Hahn) 265.36179 $126
SA Principal - County 222118 Attic Mini St) 265.36181 $82
SA Principal ~ County 222119 Amax Stora~ e 265.36183 $596
SA Principal - County 225111 Sunny Fresh 265.36185 $80
SA Principal - County 242112 Mont Market) 265.36187 $380
SA Principal - County Krutzig/Bus Ctr 2) 265.36189 $0
SA Prinicipal ~ County UMC/Comrc Ctr 6th) 265.36191 $227
2007 BUDGET.XLS:Special Rev Fund - Water Access: 1/8/2007
113
SPECIAL REVENUE FUNDS
2007 Budget
Water Access Fund
265.36193
265.36195
265.36197
265.36210
265.36701
265.36703
265.36705
265.36707
265.36709
265.36711
265.36713
265.36715
265.36717
265.36721
265.36723
265.36725
265.36727
265.36729
265.36731
265.36733
265.36735
265.36737
$0
$0
$291
$30,975
$3,995
$71
$2,563
$96
$1,557
$2,676
$411
$456
$67
$1,604
$6,341
$4,536
$1,940
$933
$394
$875
$453
$4,149
..._~----......_IIIIIIiIt_______IIIIIiIIII""____""__""'''''______'''''_1IIIIIIIIII
EXPENDITURES
Capital Outla s
Land
Buildin
Improvements
Motor Vehicles
Other Equipment
265.49201.5101
265.49201.5201
265.49201.5301
265.49201.5501
265.49201.5801
$0
$0
$0
$0
$0
Transfers
Transfer to General Fund
Transfer to Other Funds
Transfer to Debt Service 2005A Bond)
265.49201.7201
265.49201.7203
265.49201.7205
2007 BUDGETXLS:Special Rev Fund - Water Access: 1/8/2007
114
SPECIAL REVENUE FUNDS
2007 Budget
Transportation Fund
REVENUE
Replacement Aid/Ad Valorem Taxes
Local Government Aid:
State Grants - Transit
Interest Earnin s
Contributions - Private
Transit S stem Revenues:
Advertisin
610.31011
610.33401
610.33465
610.36210
610.36230
610.38010
610.38050
EXPENDITURES: TRANSIT/OPERATIONS
610.49801.2120
610.49801.2472
610.49801.2499
610.49801.3060
610.49801.3061
$0
$0
$0
$0
$0
EXPENDITURES: TRANSIT/ADMINISTRATION
Personal Services
Salaries, Full-time-Re :
Salaries, Part-time-Re
PERA Contributions:
FICA Contributions:
Medicare Contributions:
Health/Dental/Life Insurance:
610.49804.1010
610.49804.1030
610.49804.1210
610.49804.1220
610.49804.1250
610.49804.1310
$0
$0
$0
$0
$0
$0
610.49804.2030
610.49804.2099
610.49804.2199
2007 BUDGETIXLS:2007Budget-1.xls:1/B/2007
115
SPECIAL REVENUE FUNDS
2007 Budget
Transportation Fund
Services & Char es
Misc Professional Services:
Travel Ex ense
Conference & Schools
Advertisin
General Public Information:
Dues, Membershi & Subscri tions:
610.49804.3199
610.49804.3310
610.49804.3320
610.49804.3499
610.49804.3520
610.49804.4330
2007 BUDGET/XLS:2007Budget_1 .xls:1/8/2007
116
SUMMARY
Debt Service Funds
2007 Budget Forecast
REVENUE
2006
2007
$523,600
$184,720
$1,083,865
$169,725
$669,950
$500,000
$1,308,700
$0
$0
$0
$0
$158,100
$1,526,883
$137,900
$857,750
$1,082,293
$1,292,905
$300,000
$400,300
$267,000
----.....IIIIIIiII________~....._________IIMIIIIIII..........._________________,
EXPENDITURES
2006
2007 *
$3,206,726
$2,213,715
$5,777
$0
$3,708,382
$2,175,272
$5,139
$0
All Other Debt
Comm Ctr Bond
*Scheduled Levy
Less: (1) yr reduction because of bond fund surplus
2000 B Bond
$1,773,793
$857,750
($24,200)
$1,749,593
Less: Transfer From Sewer Access for WWTP Note
($1,082,293)
$667,300
($400,300)
($267,000)
$0
Sub-Total
Less: Transfer from Sewer Fund Revenues
Transfer from Water Fund Revenues
TOTAL LEVY
$857,750
$857,750
2007 BUDGETXLS:Debt Service Fund-Forecast:1/8/2007
117
DEBT SERVICE
2007 Budget
1994A G.O. Refunding Bond Fund
REVENUE
328.31011
328.36101
328.36111
328.36210
.........---.................----....--....---........--.........~-~..........--............_t............_
EXPENDITURES
328.47001.6010
328.47001.6110
328.47001.6201
2007 BUDGET.XLS:Debt Service-1994 GO Refunding:1/8/2007
118
DEBT SERVICE
2007 Budget
1995A G.O. Bond Fund
REVENUE
329.31011
329.36101
329.36121
329.36141
329.36151
329.36161
329.36171
32,936,210
$0
$0
$0
$0
$0
$0
$0
$0
---...----~-----_IIII.-_---_........_--_....._-~...._--~-_...
EXPENDITURES
Bond Principal
Bond Interest
Fiscal A ents Fees
329.47001.6010
329.47001.6110
329.47001.6201
2007 BUDGET:XLS:Debt Service-1995A GO Bond:1/B/2007
119
DEBT SERVICE
2007 Budget
1996A G.O. Improvement Bond
REVENUE
330.31011
330.36101
330.36111
330.36121
330.36131
330.36210
_...-....-.....__....---~_....------_....-........._-~_....---~_.....-~_-..!
EXPENDITURES
Bond Princi al
Bond Interest
Fiscal A ents Fees
Interest Expense - Fund Deficits
330.47001.6010
330.47001.6110
330.47001.6201
330.47001.6202
2007 BUDGET:XLS:Debt Service-1996A GO Gond:1/8/2007
120
DEBT SERVICE
2007 Budget
1997 A G.O. Improvement Bond
REVENUE
Current Ad Valorem Ta>..<os
SA - Count 97-04C Klein Farms 4th
Interest Earnin s:
...._-........_~........-............._.........-........_-~--_...-..._--...-_~---
EXPENDITURES
332.47001.6010
332.47001.6110
332.47001.6201
332.47001.6202
2007 BUDGET.XLS:Debt Service-1997A GO Imp Bond:1/8/2007
121
DEBT SERVICE
2007 BUDGET
2002 G.O. BOND FUND
REVENUE
EXPENDITURES
336.31011
336.36101
336.36103
336.36105
336.36111
336.36123
336.36126
336.36210
336.39203
$0
$5,691
$43,896
$86,658
$0
$18,084
$7,875
$15,150
$174,600
2007 BUDGETIXLS:Debt SelVice-2002 GO Bond:1/8/2007
122
DEBT SERVICE
2007 BUDGET
2003A G.O. BOND
REVENUE
337.31011
337.36101
337.36103
337.36210
$0
$140,437
$49,164
$36,100
EXPENDITURES
337.47001.6010
337.47001.6110
337.47001.6201
337.47001.6202
$215,000
$73,045
$455
$0
2007 BUDGET/XLS:Debl Service-2003A GO Bond:1/8/2007
123
DEBT SERVICE
2007 BUDGET
2005A G.O. BOND
REVENUE
338.31011
338.36101
338.36103
338.36210
338.36293
338.39205
$0
$23,787
$0
$1,000
$300,000
$1,470,105
EXPENDITURES
338.47001.6010
338.47001.6110
338.47001.6201
338.47001.6202
$1,430,000
$1,061,163
$637
$0
2007 Budgetlxl:Debt Service-2005A GO Bond:1/8/2007
124
DEBT SERVICE
2007 Budget
Consolidated Bond Fund
REVENUE
-~---~---""'--~---_~__~""_______WIIIIII""_____IiiIIIIIj_
EXPENDITURES
2007 BUDGET.XLS:Debt Service-Consolidated Bond:1/8/2007
125
DEBT SERVICE
2007 Budget
WWTP Note
REVENUE
Current Ad Valorem Taxes:
Interest Earnin s:
Transfer from Other Funds:
Tranfer from Debt Service
358.31011
358.36210
358.39203
358.39205
$0
$3,000
$1,082,293
$0
....-........__...._~-~~--~---_IIII.-_-~--------..._-....._.....-
EXPENDITURES
2007 BUDGETXLS:Debt Service-WWTP Note:1/8/2007
126
DEBT SERVICE
2007 Budget
1996C Sewer Interceptor Refund Bond
REVENUE
Current Ad Valorem Taxes:
Interest Earnings:
Transfer from Other Funds
360.31011
360.36210
360.39205
--....-.........~........._~--IIII.-......_---...._--~........---....__...----....__.....-
EXPENDITURES
Bond Princi a/:
Bond Interest:
Fiscal A ents Fees:
360.47001.6010
360.47001.6110
360.47001.6201
20076 BUDGET.XLS:Debt Service-1996C Interceptor:1/8/2007
127
DEBT SERVICE
2007 Budget
1998B G.O. WATER SYSTEM REFUNDING BOND
REVENUE
Current Ad Valorem Taxes:
Interest Earnin s:
Transfer from Other Funds
361.31011
361.36210
361.39205
$0
$0
$0
-__IIIIIIIIW_~__~__~........___............__~_...~_..._.-_................____~_
EXPENDITURES
Bond Princi al:
Bond Interest:
Fiscal A ents Fees:
361.47001.6010
361.47001.6110
361.47001.6201
2007 BUDGET.xLS:Debt Service-198B Water System :1/8/2007
128
DEBT SERVICE
2007 Budget
1999 G.O. IMPROVEMENT BOND
REVENUE
363.31011
363.36101
363.36109
363.36111
363.36113
363.36119
363.36121
363.36123
363.36215
363.36131
363.36133
363.36135
363.36141
363.36210
363.39203
$0
$50,862
$13,443
$0
$32,561
$1,580
$0
$88
$71
$0
$3,596
$1,671
$37,847
$500
$182,200
EXPENDITURES
-----~--....._--_IIII.-........-~--...-.....-~...._oIIIII_..........~~........................
Bond Prine; al:
Bond Interest:
Fiscal A ents Fees:
Interest Expense ~ Fund Deficits
363.47001.6010
363.47001.6110
363.47001.6201
363.47001.6202
2007 BUDGET.xlS:Debt Service--1999 GO Bond:1/8/2007
$305,000
$44,301
$499
$0
129
DEBT SERVICE
2007 BUDGET
2000 G.O. IMPROVEMENT BOND
REVENUE
364.31011
364.36101
364.36105
364.36107
364.36121
364.36122
364.36123
364.36210
364.39203
$0
$5,966
$14,054
$7,174
$32,047
$11,902
$1,335
$6,550
133300
...-....----....-~-....-----........-----.....---..........-............__IWIIII....
EXPENDITURES
Bond Prine; al:
Bond Interest
Fiscal A ents Fees
364.4 7001.6010
364.4 7001.6110
364.47001.6201
2007 BUDGET.xLS:Debt SeNice-2000 GO Bond:1/8/2007
130
DEBT SERVICE
2007 BUDGET
2000A MCC/PUBLIC PROJECT REVENUE BOND
REVENUE
Interest Earnin s
Transfer from Other Funds
Transfer from T.I.F.lHRA
365.36210
365.39203
365.39204
$100
$857,750
$0
___________.....__________IIIIiIIII....~~______..._!~_
EXPENDITURES
Bond Principal
Bond Interest
Fiscal A ents Fees
365.4 7001.6010
365.47001.6110
365.47001.6201
2007 BUDGET.XLS:Debt Service-2000A Rev Bond: 1/8/2007
131
DEBT SERVICE
2007 BUDGET
2000B G.O. Improvement Bond
REVENUE
..._-.........-..._------....._-....._----.....-....._~-...._...._~_....-.....
EXPENDITURES
Bond Princi al:
Bond Interest
Fiscal A ents Fees
366.4 7001.6010
366.47001.6110
366.47001.6201
2007 BUDGET.XLS:Debt Service-2000B GO Bond:1/8/2007
132
DEBT SERVICE
2007 Budget
TIF (Veit) Bond Fund
REVENUE
------.............~.....~-..........._-~-..._.....~--............_--......._--.............
EXPENDITURES
Bond Principal:
Bond Interest:
Fiscal A ents Fees:
377.47001.6010
377.47001.6110
377.47001.6201
2007 BUDGET.xLS:Debt Service-TIF (Veit) Bond:1/B/2007
133
DEBT SERVICE
2007 Budget
TIF 1989 (Elderly) Bond Fund
REVENUE
...._-~----................._.........-...........----~....._---............_-..._~-~--........
EXPENDITURES
Bond Principal:
Bond Interest:
Fiscal A ents Fees:
380.47001.6010
380.4 7001.6110
380.47001.6201
2007 BUDGET.xlS:Debt Service-TIF 1989 (Elderly):1/8/2007
134
DEBT SERVICE
2007 BUDGET
2004A TAXABLE TIF BOND
REVENUE
EXPENDITURES
Misc. Professional Services
Bond Principal:
Bond Interest:
Fiscal A ents Fee:
Interest Ex ense - Fund Deficits
387.47001.3199
387.47001.6010
387.47001.6110
387.47001.6201
387.47001.6202
$100,000
$37,232
$568
$0
$0
2007 BUDGET/EXCEL:2007Budget-1.xls:1/8/2007
135
ENTERPRISE FUNDS
2007 BUDGET
Water Fund
REVENUE
: RV Ctr
601.32216
601.32232
601.34204
601.36107
601.36210
601.36241
601.36249
601.37110
601.37112
601.37150
601.37155
601.37160
601.37170
$8,000
$6,000
$6 000
$10
$46,375
$60,000
$1,000
$712,000
$1,000
$300
$25,000
$3,500
$200
EXPENDITURES
._~_________""_______IIIIIIIIIiIII______""'___________
Personal Services
Salaries, Full-time - Re :
Salaries, Full-time - aT:
Salaries, Tern ora - Re :
Salaries, Other
Severance Pa
Severance Benefits
PERA Contributions:
FICA Contributions:
Medicare Contributions:
Health/Dental/Life Insurance:
601.49440.1010
601.49440.1020
601.49440.1040
601.49440.1090
601.49440.1110
601.49440.1111
601.49440.1210
601.49440.1220
601.49440.1250
601.49440.1310
$107,910
$3,000
$6,000
$22,415
$5,600
$0
$8,710
$8,640
$2,020
$28,815
601.49440.2030
601.49440.2065
601.49440.2099
601.49440.2110
601.49440.2111
601.49440.2120
601.49440.2130
601.49440.2160
601.49440.2199
601.49440.2210
601.49440.2211
601.49440.2220
601.49440.2230
601.49440.2270
601.49440.2271
601.49440.2274
601.49440.2277
601.49440.2299
$5,000
$400
$200
$200
$500
$9,700
$150
$40,000
$2,500
$4,000
$1,000
$500
$1,500
$10,000
$60,000
$2,200
$6,000
$5,000
2007 BUDGETXLS:Enterprise fund-Water Fund:1/8/2007
136
ENTERPRISE FUNDS
2007 BUDGET
Water Fund
ment
601.49440.2410
601.49440.2440
601.49440.2460
601.49440.2471
601.49440.2472
601.49440.2499
$300
$0
$0
$0
$0
$0
601.49440.3091
601.49440.3190
601.49440.3199
601.49440.3210
601.49440.3220
601.49440.3240
601.49440.3310
601.49440.3320
601.49440.3510
601.49440.3520
601.49440.3610
601.49440.3620
601.49440.3630
601.49440.3699
601.49440.3810
601.49440.3830
601.49440.4010
601.49440.4044
601.49440.4170
601.49440.4210
601.49440.4211
601.49440.4330
601.49440.4370
601.49440.4375
601.49440.4399
$1,000
$1,800
$20,000
$2,300
$2,800
$50
$50
$500
$500
$1,500
$4,855
$3,090
$750
$6,015
$65,000
$0
$500
$5,000
$1,500
$0
$447,645
$700
$10,000
$27,000
$0
.5
TRANSFERS
Transfer to Debt Service Fund
2007 BUDGET.XLS:Enterprise fund-Water Fund:1/8/2007
137
ENTERPRISE FUNDS
2007 BUDGET
Water Fund
COMMENTS:
Salaries:
60% Matt and Dan, 55% Sean W., 40% Jerod R; 50% Pat K
Other Eauioment: Replace (300) water meters with radio read
Lower (30) hydrants
$65,000
$11,000
$230,000
Imorovements: Paint Monte Hill Water Tower
2007 BUDGETXLS:Enterprise fund-Water Fund:1/8/2007
138
ENTERPRISE FUNDS
2007 Budget
Sewer Fund
REVENUE
602.34204
602.36210
602.36220
602.37210
602.37215
602.37255
602.37260
602.37265
$12,000
$54,250
$22,140
$1,342,300
$0
$100
$8.900
$0
o
2007 BUDGET.XLS:Enterprise Fund-Sewer Fund:1/8/2007
139
ENTERPRISE FUNDS
2007 Budget
Sewer Fund
EXPENDITURES - PLANT & LABIWWTP
Personal Services
Salaries, Full-time: Re
PERA Contributions
FICA Contributions
Medicare Contributions
Health/Dental/Life Insurance
602.49480.1010
602.49480-121 0
602.49480.1220
602.49480.1250
602.49480.1310
$1,000
$60
$65
$15
$100
Services & Char es
Professional Services - PSG, Inc:
Misc Professional Services:
General Liabilit Insurance:
Pro ert Insurance:
Vehicle Insurance:
Misc General Insurance
Propert Taxes:
Electric
Re air & Maintenance - Buildin s:
Re air & Maintenance - Machine & E
De reciation - Acquired
Licenses & Permits:
Biosolids Farm Ex enses:
Misc Other Expense
602.49480.3080
602.49480.3199
602.49480.3610
602.49480.3620
602.49480.3630
602.49480.3699
602.49480.3710
602.49480.3810
602.49480.4010
602.49480.4044
602.49480.4210
602.49480.4370
602.49480.4385
602.49480.4399
$642,300
$20,000
$0
$23,900
$1,745
$300
$5,500
$100
$2,500
$15,000
$500,765
$6,200
$3,000
$600
Capital Outla
Improvements
Motor Vehicles
Computer Equipment
Other
Interest Expense - Fund Deficits
602.49480.5301
602.49480.5501
602.49480.5702
602.49480.5801
602.49480.6202
$5,000
$0
$0
$0
$0
I
"0
COMMENTS:
Misc. Professional Services
Braun Water Testing @biosolids farm, pro ag consultant
contract mowing @ WWTP
$20,000
2007 BUDGET.XLS:Enterprise Fund-(Sewer) WWTP:1/8/2007
140
ENTERPRISE FUNDS
2007 Budget
Sewer Fund
EXPENDITURES - COLLECTIONS/GEN OPERATING
Personal Services
Salaries, Full-time - Re :
Salaries, Full-time - aT:
Salaries, Tern ora - Re :
Severance
PERA Contributions:
FICA Contributions:
Medicare Contributions:
Health/Dental/Life Insurance:
ui ment
602.49490.1010
602.49490.1 020
602.49490.1040
602.49490.1110
602.49490.1210
602.49490.1220
602.49490.1250
602.49490.1310
$90,715
$3,200
$6,000
$22,415
$7,645
$7,585
$1,775
$25,720
602.49490.2030
602.49490.2111
602.49490.2120
602.49490.2130
602.49490.2160
602.49490.2199
602.49490.2210
602.49490.2211
602.49490.2230
$3,000
$500
$12,000
$300
$1,000
$2,500
$4,000
$2,800
$0
602.49490.2410
602.49490.2440
602.49490.2460
602.49490.2465
602.49490.2471
602.49490.2472
602.49490.2499
$500
$0
$0
$200
$0
$0
$0
Services & Charges
Prof Service - Maint Aqreement 602.49490.3190 $500
Misc professional services: 602.49490.3199 $4,000
Telephone: 602.49490.3210 $2,700
Postaqe: 602.49490.3220 $2,600
Travel Expense: 602.49490.3310 $0
Conference & Schools: 602.49490.3320 $500
General Liabilitv Insurance: 602.49490.3610 $0
Property Insurance: 602.49490.3620 $175
Vehicle Insurance: 602.49490.3630 $1,850
2007 BUDGET.XLS:Enterprise Fund (Sewer) Admin: 1/8/2007
141
ENTERPRISE FUNDS
2007 Budget
Sewer Fund
602.49490.3810
602.49490.4044
602.49490.4170
602.49490.4210
602.49490.4211
602.49490.4381
602.49490.4399
$5,000
$1,500
$2,000
$0
$510,035
$500
$0
Salaries:
40% Matt and Dan,45% Sean W., 60% Jerod R; 50% Pat K
Capital Improvement: Overlay parking lot & driveway @ WWTP balance
(Previously budgeted $35,000)
$5,000
Other Capital Eauipment: For jet 700' - 1" hose
$3,200
2007 BUDGETXLS:Enterprise Fund (Sewer) Admin: 1/8/2007
142
ENTERPRISE FUNDS
2007 Budget
Liquor Fund
REVENUE
NSF Fee
Interest Earnin s:
Other Miscellaneous Revenue
Li uor Sales:
Beer Sales:
Wine Sales:
Misc Sales - Taxable:
Misc Sales - Nontaxable:
S ecial Events Revenue
Cash Over w Off Sale:
609.34198
609.36210
609.36299
609.37811
609.37812
609.37813
609.37815
609.37816
609.37821
609.37841
EXPENDITURES - PURCHASING
Su lies
Li uor:
Beer:
Wine:
Misc Taxable:
Misc. Non-taxable
S ecial Events Products
609.49750.2510
609.49750.2520
609.49750.2530
609.49750.2540
609.49750.2550
609.49750.2555
609.49750.3330
609.49750.3340
609.49750.3399
EXPENDITURES - OPERATIONS
Personal Services
$200
$3,500
$20
$1.069.800
$1,997,845
$459,400
$61,900
$38,900
$6,400
$900
$716.692
$1,600,236
$341,940
$53,800
$26,287
$4,900
Salaries, Full-time-Reg: 609.49754.1010 $204,825
Salaries, Full-time-OT: 609.49754.1020 $14,800
Salaries. Part-time-Re~r 609.49754.1030 $90,580
Salaries, Part-time-OT: 609.49754.1031 $3,650
Severance Pay 609.49754.1110 $5,000
PERA Contributions: 609.49754.1210 $19,616
FICA Contributions: 609.49754.1220 $19,459
Medicare Contributions: 609.49754.1250 $4,551
2007 BUDGETXLS:Enterprise Fund-Liquor Fund:1/8/2007
143
ENTERPRISE FUNDS
2007 Budget
Liquor Fund
609.49754.1310
609.49754.1315
609.49754.1420
609.49754.2020
609.49754.2030
609.49754.2099
609.49754.2110
609.49754.2111
609.49754.2140
609.49754.2199
609.49754.2230
609.49754.2299
609.49754.2410
609.49754.2472
$0
$170
$620
$450
$750
$300
$8,000
$400
$725
$400
$11,550
2007 BUDGETXLS:Enterprise Fund-Liquor Fund:1/8/2007
609.49754.3010
609.49754.3090
609.49754.3092
609.49754.3105
609.49754.3190
609.49754.3199
609.49754.3210
609.49754.3250
609.49754.3310
609.49754.3320
609.49754.3499
609.49754.3610
609.49754.3620
609.49754.3699
609.49754.3810
609.49754.3820
609.49754.3830
609.49754.4010
609.49754.4044
609.49754.4099
609.49754.4210
609.49754.4310
609.49754.4330
609.49754.4370
609.49754.4398
609.49754.4399
$0
$300
$1,250
$1.110
$12,750
$2,950
$4.050
$500
$150
$300
$3,500
$0
$1,650
$14,930
$18,705
$400
$3,553
$5,000
$5,000
$1,200
$56,100
$1,600
$650
$250
$46,000
$10,225
144
ENTERPRISE FUNDS
2007 Budget
Liquor Fund
609.49754.5301
609.49754.5702
609.49754.5801
Other Finance Uses
Transfer to Other Funds:
COMMENTS:
Transfers:
Annual transfer to Community Center Debt Services
$250,000
T&E Computer EQuipment:
Hand held scanner
Color printer
Copier
Computer
$2,600
$4,200
$2,750
$2,000
$11,550
145
2007 BUDGETXLS:Enterprise Fund-Liquor Fund:1/8/Z007
ENTERPRISE FUNDS
2007 Budget
Riverside Cemetery
REVENUE
651 .33626
651.34941
651.34942
651.34943
651.34944
651.34947
651.34949
651.36210
651.36211
651.36299
$1,500
$15,000
$12,000
$600
$850
$400
$2,600
$2,625
$0
$0
_....~.....~----_...-....-_.....~_..._.............---_....-~---_..........---
EXPENDITURES
Personal Services
Salaries, Full-time-Re :
Salaries, Full-time aT:
Salaries, T em ora - Re
PERA Contributions
FICA Contributions
Medicare Contributions
HealthlDentallLife Insurance
651.49010.1010
651.49010.1020
651.49010.1040
651.49010.1210
651.49010.1220
651.49010.1250
651.49010.1310
$2,800
$150
$500
$215
$215
$50
$500
651.49010.2199
651.49010.2250
651.49010.2299
651.49010.2575
651.49010.3105
651.49010.3110
651.49010.3115
651.49010.3199
651.49010.3499
651.49010.3510
651.49010.3520
651.49010.4210
651.49010.4399
$7,600
$3,000
$12,000
$1,000
$0
$0
$100
$1,930
$200
146
2007 BUDGETXLS:Enterprise Fund-Cemetery:1/8/2007
ENTERPRISE FUNDS
2007 Budget
Riverside Cemetery
651.49010.5301
651.49010.5360
651.49010.5950
651.49010.5960
$2,000
$0
$0
$2,000
2007 BUDGETXLS:Enterprise Fund-Cemetery:1/8/2007
147
UJ
:E
w
t:
I-
Z
w
:E
D..
5
t-.O
ow
~0/5
I-
w
UJ
~
...I
~
ii:
~
-
'E
a>
E
,9-
:J
0'
W
~
(fl
"8
t:-
o
o
l!5
fF(
o
00
oll)
0EA-
. C
~1Il
ffi~
~~
(fl (fl
E E
~2
I
(fl (fl
Q5Q)
lZ lZ
<(<(
UJ (ij =
w~w
I- a. co!l
oar-
z
eX)
'<t
>.
.!!l
~ (ij "S ~
..... a ~
a> ~ = a>
C . . J9 C ·
aJ a> I- a>
Cl Cl '5. Cl
ro
U
0000 00 0 0 00 0 Oll) 0 0 0
0000 00 0 0 00 0 ll)0) 0 0 ll)
0ll)ll)0 ll)CO ll) 0 o co 0 t-.N 0 0_ t-.
l!5EA-t-.l!5 C'i": EA- ai tiS 0 tiS EA- - l!5 a:i
t-. 0
..... N EA- EA- EA- EA- eX) EA- ..... C") co N
EA- ..... EA- EA- EA- EA- EA-
EA-
a>
i::
a>
(fl
a>
0:::
'E
a>
E
(flO' a>
,2 g 1il
~..: 0..
o:::~ &.
N II .>t!.
I(j) U
::?: a 2
OU..... I-
~2i~~
I ro a.. U
(ijE......Q~
'E~.Q(ij~
~~8:StI
.....
a>
.J::.
i5
w
~
I-
.....
a>
"S
a......
E i:! (fl
a...... a>
uau
WWE
co!lco!la>
1-1->
~
u:
a>
C
E
U
ro
~
><
ro
LL.
I:: (fl
a> a
"5. '5
a ro
UO:::
a.
'S
0'
W
a>
U
IE
a
W
~
I-
aJ
(fl
C
~
a>
o
';;:
G
.....
a>
'E
";::
a..
.$
:J
a.
E
a
U
W
~
I-
C
'E
-0
<(
~
a..
a>
"'5
-0
a
::?:
0)
C
'2
C
ro
1i:
-0
aJ
(fl
ro
III
a
w
Cl
C
2
'5
~
Q)
C
:g
'S
III
a>
0)
~
S
f/)
Q.a>
a>_
~:2
lJ;~
.....
a>
.J::.
i5
(fl (fl
a> Q)
_ C
U ,-
,- -0
.J::.:=
a> :J
> III
0)
C
'c
~
C
"2
C
ro
c:
(fl
C
a
U
a>
a.
(fl
C
0)
C
:g
"S
III
.$
C
a>
E
a>
U
ro
0..
a>
0:::
1Il
.....
I-
0-
:J
(fl.>t!.
a> U
a. ,-
roa..
I- .....
..... a>
a> 0)
~ C
a>&
f/)-o
..... .....
.E a
(flLL.
.....t-.
~9>
.!!l a>
a.. U
ro
0-
> g-
oo:::
.....
a>
"5
a.
E (fl
a a>
u-
U
WE
oo!J a>
1->
1Il
C
a
~
0-
(fl
C
aJ
~
I-
~
a..
......
C
aJ
E
~
ro
0.. 0"'0
ro~ ~.E
:JaJ ......-
Co.-~lIl
ca>~a>5
<( a> 0 C ,-
'~N""'[)
g' I ,f;; ~.....
~tuO~O
aa>g:sg
U >. __ _
(ij-og:gg
J.l~eiLEA-
ffi
~~
Em
'E
aJ
E
0-
0- '5
EJr
192
'5. "5.
ro ro
uu
~
~
U5
r--
o
o
~
;g
(ri
E
~
>,
'"
'S
o
]j
"5.
'"
()
U:i
...J
><
tij
C.9
o
:::>
ell
r--
o
o
l'j
U)
::Ii
w
~
I-
Z
w
::Ii
a..
5
......0
ow
~oa
I-
W
U)
~
...J
;:!:
~
u
,
Ul Ul
Q)Q)
Ul Ul
Ul Ul
<(<(
U) 15 ·
w:!:W
I- c. o,j
Orol-
O'
Z
---
-
e:
Q)
E
c.
'5
0-
W
o,j
Ul
'0
~
o
o
u'"i
~
o
00
01.0
o~
- e:
~lB
ffi~
i)~
Ul Ul
E E
~2
....
Q)
c:
Q)
o
~-
e: -
:::l
E
E
o
o
0000000000
0000000000
001.0001.000000
C"iNN.,f05t-:cOC"iNO'l
~~(fl~CIO""",,,,"(fl(fl(fl
(fl (fl (fl
. .
.s
Ul li5 Q)
e: E-~
~ ~ li5 l5
- UlO) roE-
e: ro - c. (J)
Q) .... .!; c.._ ~
E Q):= Q):::lo
C. E Q) c:: 0- Q)
.- ro 0 .... W 0 lfi
:::lQ)O .....Q)e:- "0
0'"::0 Ul o~ 0 ~ ro
Wro.z:.15.Qo:;::;Q) ..c:
15 I- .-= 0 LL .3 ro .::.: (J)
>'OBOE -:gg ~
EOoQ) I >'~ro-1UlO
Q)c..(J)E<.90Cl)Q)'::':-o
..... Ul_Q)Oe:
c:: ~ ~ Jl;! ~ li5 0 >.$:;:
~roro<(ro"Oo.QLL.>
o 0.. 0.. Q) 0.. e: a.. c. Q) 0
e: /8 /8 .!::: /8 R > E ~ 0
(J)LL.LL.LLLL........=>Wl:Oa..
c.
~ Q) .~
~5w c:
:E :g ~ ffi 'ffi
~5[i:;=E
:2: LL 0 0 '15
WWWwc.
o,jo,jo,jo,j/8
I-I-I-I-LL.
c.
Q) .-
.... :::l
:::l 0-
:!:wffi
E ~..c:
~C::O
UJUJW
o,jo,jo,j
1-1-1-
ffi
c:
Q)
U
.z:.
'E
:::l
E
E
o
U
0000
0000
01.001.0
oC"io)C"i
.- (fl (fl (fl
(fl
E
8
c::
..c:
o
e:
:::l
-1
e:
0)'-
.!; E
322
Q) ~
~(J)15
'U-1
E> 0)
Q) <( e: 0)
1il I :.i2 .!;
>...... .... .::.:
(J)Oroo
_Q)a..ro
Ula"OC::
:::le:e:-
roroQ)JQ
f.i"ffix15
UJl:OWc..
lE
c. .... c..i3
E Q) E 'E
_J::_L...
150"ffi~
- -
'5.w'5.w
roo,jroo,j
UI-UI-
Q)
0)
~
ro
<.9
0..
o
..c:
CI)
o 0
o 0
0_ 0
o 0
""" 0
(fl .-
(fl
15
-1
0)
e:
:.i2
....
ro
a..
-
:::l
e:
15
~
"E
C')
ts
:::l
....
1il
e:
o
~
c::
c.
E
]j
'5.
ro
U
Ul
'5
-1
0)
e:
:.i2
m
c..
OJ
"""
.-
i:
ro =
c..
~
....
ro =
c..
0000
0000
0000
u'"iu'"iu'"io
...... (fl .- .-
~ (fl (fl
.s
..r::.
~
o
C')
Q)
"0
~
0)
C.
:::l
"0
e:
ro
Ul
.:E
g
o
C')
"0
"0
<(
~ ....
Ul ~ ~
~tO~
g :::l O)(J)
- 0 .!; i:
lfi.g~ro
c::m5c..
i:I.::.:Q)
ro-....."O
c.. lB ro .-=
e:'::;c..l:O
g(J)~1il
=..r::.~Q)
i:iJ~(J)~
c.
E
Ul
O)c.c.
32 E E
l:O__
15"ffi"ffi
- --
'5.'5. '5.
ro ro ro
UUU
]j
'5.
ro
o
0)
e:
:;::;
..r::.
0)
::J
Q)
lEOi/5
~
o
~
iri
E
:m
,.,
.!!l
"S
o
Jij
'0.
ell
o
Uj
..J
X
tij
C!)
o
:::l
aJ
~
o
N
Ul Ul
~ .::.:
.... .....
ro ro
a.. c..
CI)
:i
w
!::
....
z
w
:!:
D..
5
.....0
ow
~o/:I
I-
W
CI)
~
~
~
u
en en
IDa>
en en
en en
<C<c
CI) ro ;
w::::w
I- a.~
O CO I-
0;
Z
,-..
c
0)
E
a.
'5
Cf'
W
~
en
o
o
t:-
o
o
Ll'i
f/)
,
o
00
010
of/)
Ll'iij5
f/)O)
Q;~
~~
en en
E E
0) 0)
~~
000000
000000
000000
ciciciciciC'i
.....NN('I)"<t1O
f/)f/)f/)f/)f/)f/)
c
0)
E
a.
C '5
0) 0-
EW
.9- c
::J 0
0-:;:;
W m
c .....
.Q lrl
coO:::
0) en
.....-0
lrl C
0::: 0
~0)0)0)1iic...
......b~~O)ID
(/) c.. c.. 5 ~
~~~~0
C
en 0)
0) E
u,Q.
:c ::J
0) 0-
>W
roro
..... .....
'5. '5.
co III
00
~
0)
c ;
0)
c.?
000000
000000
......0.00.......0.
............;('I)NIO
~f/)f/)f/)f/)~
l!!
0)
"5
a.
E
o
o Q;
,-..~
N 0)
s(/)
c
co
a::
en..... c
Q; S! .Q
~lrl 10.
O)'~ -
(/)e....ij5
.....c...cE
o III 0)
......- E 2
a. -0 a. a.
~ ~ '5 .E
..):::: I C"~
u E W -6'
CO::l- ::J
al;:2roU5
0)03:,
a. 0) (/)
III 0 .!::: ;;:i
I-...JLLv
.....
$
::J
a.
E
o
o
W
~
I-
0>
C
'w
en
~
o
.....
c...
III
ro
o
o
10
.....
o
o
o
Ll'i
.....
f/)
00000
00000
100101010
C'iciC'iC'i.......
f/)Nf/)f/)f/)
f/)
c c
,g 0
:;:;
'6 co
~ u
<;::
'6
>. 2 0
0> ;:2
-0 ::J .!;;;
::l .t:J <C
U5 :O"'C
en= 0>0
en 0) ::J ,!;;; <C
Q; >al
.S:2 t5 .... -0'
0. :0 c=..:.::
2 ._ ::l_
0 C Oallll
..... III 1ii a...... 3:
0) I c ..:.:: c 0)
.t:J ,!::: 0 U .- -0
u:: ::J CO .-
<CO I-c...(/)
~
.3
'2 en
.....
::J 0>
LL C
UJ ~
~ ::J
I-al
I"-
8
N
..... ~
~ ....
1ii u;
E
en 'a, f!
.S:! ~
0. >-
0 ~ .!!l
"5
..... ::J 0
0) a.
.t:J 0) ~
u:: 0 'is.
III
(,)
iJj
5<!
tij
C,9
0
=>
co
I"-
0
g:
(I)
:e
w
!::
~
z
w
:e
0.
5
~a
ow
~oa
~
w
UJ
~
~
~
u
c
OJ
E
c.
'3
0'
UJ
~
III
(5
o
t:-
o
o
lfi
~
o
00
01.0
o~
. c:
1.0 OJ
~OJ
lii~
[;2
III III
E E
~~
I I
mm
~ ~
<l::<l::
UJ(ij<
w:t:::UJ
O~ g-~
()-
z
15
...J
Ol
c:
:s2
ro
a.
~-
OJC'\l
'- '-'
o '-
U5 ~
E c:
OJ (l;l '-
t5cX.Q
>- "C 0
(f)_() .....
.2:' OJ I .$
"C I ..... '- ;:J
OJ OJ c.
B -g c '15. E
OJ C\3 'C 0 0
(f)I 0. ()()
L()
.,...
c: III
0
~ l3
(J '- ..... (J
'i5 .$ 0) (J
OJ C\3 < < ~ <l::
D ~ '-
(f) 0)
.::.t. ~
.....
(l;l (f)
0.
0 000 0 0 00
0 000 0 0 00
0 000 0 N 00
g Lri'''''':o' lfi c<l 0'0'
(0.,...(") ~ 00)
~ ~~N NN
~ a:i~
~
c:
o
..
'w
'3
0'
(J
<l::
"C
c:
C\3
...J
~
;:J
"S
u..
~
"C
c:
(l;l
...J
2
'15.
C\3
()
c
0)
Ec.Ol
,Q. E ]2
;:J_lD
0'_ _
W22
UJ '15."15.
~C\3C\3
I-()()
"C
c:
;:J
u..
c:
o
~
(J
'i5
OJ
D
.::.t.
ro
0.
'-
0)
ro
~
0.
I-
~
~
>-
C\3
"C
OJ
o
(5 0)
...J III
Cl 0
c:-I
:s2~.....
'-00)
&N:g
..... c: 0
000::
~ 0 0)
c: 0_....,
J!!~o
~ ~12
c.
E
2
"15.
C\3
()
'-
0)
3:
OJ
(f)
....
c:
OJ
E
c.
'3
0'
UJ
UJ
~
"C
c:
;:J
u..
III
III
~
(J
<l::
'-
0)
3:
OJ
(f)
....
o
o
!:'!
~
iri
E
~
>-
ell
:g
o
]i
"0.
ell
(,)
en
-'
><
tii
'"
o
=>
a)
....
o
o
C"l
......
o
o
N
"
o
LL
Z-
0'"
_ C
.... B
::>> ...
~~
,,~
....aJ
~-
c
~
<(
...J
<(
tJ')
#.#.
00
(j) (j)
#. #.
o 0
(j) 0
.....
#.#.#.#.
01,()00
(0 I,() (O.qo
#.#.#.#.
o I,() 0 0
'<:t"'<:t".qo(O
~
o
o
o
.....
#.#.cF-
000
..... ..... .....
-;fl.';!!"#.
000
(j)(j)(j)
#.#.#.
000
..... ..... .....
cF-cF-#.
000
(j)(j)(j)
c
Q)
C Q)
:.i2 '@ c ~ -g
1Il 1Il 1Il ~ I- c 1Il m C Q) 'c :J
~ .!; ~ ID a.. ~ .!Q ~ <5 0 -g 1Il -
o ~... 3: .'- Q) 0 :J 1Il ... 1Il 0 ro
o~~ci3rogJ~~""a:::ID-5e:c.9ro
:2 .- a.. 0 I- ID "'0 Z C/'J c.9 ... u.. I
E c W "'0 E a::: - c .- 0 ..c E Q) Q) Q)
Q)E"'O _-roc..._O ~~
o = 0 0 = ro Q) ro Q) Q) Q) 0 0 .- .-
1-<{:::;I-I-lJ):2C/'JO...,C/'J....JI-a::::2~
..c
u
ro
~
:J
....J
cO
..cO
~::E
~
o
I,()
.....
cft"#.#
I,() 0 0
0000
..... ...--
...
~
ID
c :J Q)
o E 1Il
~ C 1Il
Q) ~ ~
"'0 U C
C ro Q)
<{:CI
ro5"""i
c.9a:::O
N
I,()
.....
I"-
o
~
~
T""
.....
c:
~
~
~
c
o
'5
.r>
~
i5
c:-
CIl
(ij
(f)
~
~
(9
o
=>
[l)
r-
o
o
N
......
o
o
N
0:::
o
LL
Z
o
i= (.)
=> ...
En Q)
-0..
0:::>.
I-m
en_
-
c
~
<(
..J
<(
en
~
o
o
LO
~
o
o
LO
rfl.~
00
00
".... "....
~
o
o
o
"....
~
o
o
o
"....
~
o
o
o
"....
C
o
(f)
ell .- -g -B
Q)offi~.!:.2l/)
(f) E Q) :J .~ Q)
o .- L- ~ > 0 s:
lllUJ<9cOIQ)
EC.!:Q):::,c:::Q)o
o-amCaro32
I-...,lll:::,c:::a......,lll
~
o
o
(t)
~
o
o
o
"....
#<F-#<F-
0000
0"....00
".... ".... "....
~
o
o
o
"....
~#?f.
000
000
".... ".... "....
~
o
o
(t)
~
o
o
o
"....
~
o
o
o
"....
~
o
o
(t)
L-
Q)
::t:-
ell
.!:
U
e
~
~
6
C
ell
E
L-
(t)
LO
"....
t'-
o
o
N
~
.......
~
~
Q)
0.
~
c-
.2
"S
.J:>
~
is
~
m
ro
(f)
ci:i
>t
tii
(9
o
:J
lI)
t'-
o
o
N
......
o
o
N
~
o
LL.
Z_
Ot:
i= B
=>> ~
~~
~~
t-m
en_
-
c
~
~
or:(
en
~ c!- ~ c!- ~ ~
0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
T""" T""" T""" T""" T""" T"""
~ :J!. ~ :J!. :J!. :J!. :J!. ~
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
T""" T""" T""" T""" T""" T""" T""" T"""
I Ii Q) Q)
() ~ c.9 ~ $: E ,g u.. ID (lI E
ID I ~ "0 ~ ~
I~ (lI ..l<: ..c C I Q) C
... C u en (lI E 1::: Q) ..l<: ...... ~ Q) 1:::
~ (lI ~ ~ ".:; ";:: (lI 0 ~ (lI ..c (lI
C/) I- ID '=) a.. ..., ~ ID () a..
;7;
T"""
,....
o
o
N
~
C
~
8-
>-
.D-
C:
o
+>
::J
.D-
E
tJl
is
[:>
'"
(ij
In
Uj
...J
X
~
w
(!)
o
::J
llJ
,....
o
o
N
tJ)
:E
0:::
w
l-
e
W
1-0;
00)
W-c
...J ~
~aJ
u.1"--
og
>N
0:::
<C
tJ)
tJ)
o
...J
C)
::t::
ro
......
(/)
"'0
o C
...... ro
"'0 (/)
Q) ro
(/) .-
O 0 .
u:::: (/)
a. q::: Q)
a. 0 .-
00:5
(/) ...... "'0
ro..........
c .-
C Q) Q)
:8E~
ro Q) 0>
(/) (/) C
C .... .-
Q) ::J E
a...o ....
E .5 .g
8 ~ Q)
_~o.
o Q) C
> .-
1::ro"'O
~~ ~
.... ....
ro 0 ::J
(/) ...... 0
ro C .S
"'0 Q) (/)
.- E Q)
ro Q) (/)
a.(/)C
Q) .... Q)
0)::Ja.
ro ..0 x
Q) E Q)
== ._ L...
:2:~.8
(/)
Q)
o
c
ro
~
.Q
<(
u:i
......
ro
..c
"'0
....
ro
..c
......
ro
Q)
0)
~
..E
ro
(/)
......
ro
Q)
0)
C
.~
(/)
......
(/)
Q)
>
en
~
o
en
(/)
E
....
.8
'c
=>
(/)
.Q2
C
:c
......
o
o
~
Q)
0)
ro
a.
a>
0)
ro
......
(/)
o
a.
a>
C
o
..c
a.
Q)
~
C
o
~
'c
::J
E
E
o
o
~en
"'0 . (ii
o C
o "
t;:: (/)
~~
Q).9-
c....o
roQ)O
Q) a. 1O
(3rof::lt
"'0 a. C
C_"ro
roQ)..c
Q)......
(/) ...... (/)
...... (/) (/)
Q)c . Q)
Q)-
~ .~ E
(/)2:2
" Q) .-
(/) (/) ....
;!;;: .... Q)
OQ)o.
..o..cQ)
<<S .~ ::J
::J-
(/) 0) >ro
...... C
::J ._ '-'
C >< .
enQ).B
"'0 Q) Q)
e ~ en
0) "::Q
C (/) ::J
:.aE..o
-0......
Q)0..c
$ .0 .!2'
o
~
Q)
C
Q)
(?
<<S
(/)
Q)
C
8
"'0
C
ro
c:
~
...... a.
Q) 06 .;::
ro (/) h
Q) -
(/) 0) ~
":'::~1::
o .-
ro en-o
........ "
o Q) (/)
~..ct5-
C (/) .- 0
.- ro a. 0
~;:;::: h 1O
- (/) f:I7
......>Q)c
Q) (/) ..:.:: ro
~(/)~..c
......ro ......
(/) - en (/)
" 0 - (/)
lB-:~Q)
"'0 ro 0
'0 'C ..c E
.- Q) (/) Q)
..0...... ......
.... ro <<S .-
~E(/)Ii;
_..cEO.
.$.B0Q)
(/) ro e ::J
o a...o ro
a." >
-o(/)en'-'
c Q)...... .
"" "'0 ..c 0
w ro 0)......
(/)o=Q)
c .;::..c "
O)L...(/)"'O
.- ro ro 0
(J)..ot;::(/)
.$
Q)
~
......
(J)
(/)
.Q2
o
m
L...
Q)
C
Q)
(?
.$ c
Q) ro
..o..c
......
en(/)
1:: (/)
ro.!l2
C:E
~2
Q) .-
~ Ii;
a.
"iQ)
.- ::J
ro-
o.ro
->
(/)'-'
Q) .
.- (/)
.... E
~ 0
ro 0
..0 L...
..0
enc
...... .-
..c ro
.!2' E
" -0
(/) C
Q) co
"'0
ro ......
- Q)
..0......
......
" ::J
~O)
::l h
- (/)
0.0)
..:.::c_
.... .;:: 0
co roo
a.Q)1O
(J)..of:17
(/)
.Q2
w
......
o
Q)
o
c
ro
c
2
C
'(ii
:2:
Ji
"'ij)
..0
~
Q)
......-
~o
" 0
Q)1O
. = f:I7
~ C
- co
Q)..c
a. ......
.s (/)
(/)
- Q)
(/)-
~ E
::J Q)
'+-:!:::
en....
o.Q)
E a.
ro Q)
- ::J
"'Om
co>
Q)-
.c. .
......
" c
(/) .-
Q) co
"'0 a.
ro "
- (/)
..00)
" C
(/) .-
0)....
::J ro
- Q)
0....0
(/)
.Q2
:::s
(J)
Q)
(3
:.E
~
'0
~
c
co
C
Q)
......
c
'(ii
:2:
......
c
Q)
E
::J
W
....
o
c
~
--
(/)
o
o
?-
m
E
(J)
10
10
.......
E
:m
....
Q)
a.
o
o
o
1O
f:I7
o
......
o
o
1O
f:I7
......
o
Q)
::J
~
ro
..c
......
'3:
......
c
Q)
E
a.
'5
0-
Q)
"'0
C
ro
(/)
o
o
I-
r---
o
o
N
~
......
~
ro
Vl
Vl
o
c:5
if)
...J
X
~
w
(!)
o
::J
OJ
r---
o
o
N