ITEM 1 2016 Budget10
otS11.1:
O
MINNESOTA
MEMORANDUM
TO: Mayor and City Council
FROM: Lori Johnson, City Administrator
DATE: May 21, 2015
SUBJECT: 2016 Budget
The main purpose of this initial budget meeting is to both give staff an opportunity to provide
information to the Council on staff priorities and plans for 2016 and to get feedback, input, and direction
from the Council on your goals and expectations for 2016. In order to present a draft budget that meets
the Council's 2016 objectives, we need to know your 2016 program and project priorities, desired
changes, if any, in the services the City provides or the level of service provided. Additionally, the
Council should provide general direction on the tax levy. There is plenty of time to refine the levy before
it is set in September; thus, a ballpark number is fine. The one action item requested at the meeting is
to set the 2016 budget calendar.
Tax Levy:
The annual property tax levy set by the City Council includes amounts that are discretionary such as the
General Fund and reserve levies and amounts that are not discretionary such as debt service and tax
abatement levies. Below is an overview of the proposed 2016 levy:
In 2016, the tax abatement levy will increase almost $66,000, a 286% increase. This is due to the second
phase of the Gateway North tax abatement coming on line in 2016. The final payment on this
abatement is in 2022. At that time, unless new tax abatement projects are approved, all current tax
abatement projects will be closed and no levy will be required. A summary of the existing tax
abatement projects is attached.
Last year the debt levies were reviewed and discussed at length after which the Council directed staff to
"ladder the levies to reduce the initial increase impact on the levy." The debt levies in the draft 2016
levy options document attached reflect that direction. Based on those numbers, the 2016 debt levy will
increase $30,000 or 4.9%. We are currently reviewing debt service funds again to determine if
additional levies are necessary in 2016.
The Reserve levies are included at the amounts discussed when reserve funds were reviewed with the
Council last year. These levies may need to be adjusted if there are significant alterations to the CIP.
The spreadsheet attached shows three levy options. The options are for discussion purposes only. The
first column increases the General Fund levy by 3% with the other levies as discussed above. The second
option is the same levy but with a different tax capacity estimate. This shows how much the tax rate will
change depending upon the tax capacity estimate. The third option (far right column) shows, roughly,
how much the levy could increase without increasing individual property tax on existing parcels. The
additional amount is included in the General Fund levy for illustration purposes only; it could be used for
any purpose. Obviously, the levy will be adjusted as the Council determines appropriate to fund City
needs. Further, the tax capacity used to calculate the tax rate in these levy options is a very rough
estimate based on the data provided by the Wright County Assessor. An actual estimate should be
available from the County in August. The property value used in the spreadsheet is not what the actual
value will be and should not be used for anything other than preliminary discussion. These options
simply are a starting point for discussion to give the Council an idea of how various levy changes may
impact property owners.
Property Values:
The property values provided by the County assessor at the 2015 Board of Equalization indicated that
the market value is increasing 13.84%. However, it is impossible to determine the actual increase in tax
capacity based on the information currently available because tax capacity is a calculation resulting from
applying various class rates to each property depending upon its classification. Therefore, in order to
make an estimate, without knowing the amount of change in each classification, I applied a 1% class rate
to the entire market value increase of 160,863,244 with the exception of the new commercial
construction, which is at a rate of 2%. The resulting number is $13,233,754 or an increase of 16%. That
increase seems high, but it is the best estimate available until the County provides their estimated tax
capacity in August. As the Assessor stated, there was a total of $66,224,500 of new construction value
added in 2015 which far exceeds the new value added in recent years. That value does not include full
value for Room and Board and BluDot.
Council Directives Goals, and Priorities for 2016:
After reviewing 2016 department goals and priorities in very broad terms with each department, it
appears that there will be no significant changes proposed in the 2016 budget with the exception of
increased staff in a couple departments being requested to maintain existing service levels. Population
growth and development activity increase demands for service with more miles of streets, more use of
parks, and more requests for service from staff in many areas, as you are well aware.
Council direction is requested if you want to add, delete, or change programs and services currently
provided or if you want to alter the level of service the City provides in any area. Your input on 2016
expectations, goals, and priorities will help direct the City's limited resources appropriately in the draft
budget.
Budget Schedule:
A Proposed 2016 Budget Calendar was distributed prior to the April 27 Council meeting. The budget
calendar wasn't adopted at that meeting pending review of individual Council member and Council
meeting schedules. In addition to the budget work sessions, there are several other work session items
that need to be scheduled; however, those won't be scheduled until after the budget calendar is
adopted. A copy of the proposed 2016 Budget Calendar is attached for your review.
In conclusion, all department heads will be at Tuesday's budget meeting to hear the Council's input on
2016 goals and priorities before beginning to draft their budget requests for submission in June and to
answer any questions you have about staff's priorities going into the 2016 budget.
2
Attachments:
• Proposed 2016 Budget Calendar
• Market Value Data from Wright County
• Sample Preliminary Tax Levy Options — For Discussion Only
• Tax Abatement Summary Data
• Combined Cash Investment Report — March 31, 2015
• Revenue and Expenditure with Comparison to Budget Report— March 31, 2015
Proposed 2016 Budget Calendar
May 26
Kick-off budget meeting with City Council. Begin discussion of Council
priorities for tax -supported programs.
Present to June 30
Payroll projections, insurance, utility, audit, and internal charges
calculated for budget by Administration/Finance
June 8 - 26
Department heads prepare and submit draft budgets including all detail
documentation.
June 8 - 26
Department heads prepare and submit draft CIP requests including all
detail documentation
June 29 - July 3
Compilation of draft budget submissions
July 6 -22
Budget meetings held with City Administrator and department head to
review draft budgets. City Administrator reviews reserve and debt service
fund budgets to make levy recommendations. All budget data entry
completed to produce draft budget document.
July 27 following regular meeting
Council work session to review tax levy projections: General Fund,
Reserve Funds, and Debt Service
August 7
Distribute draft budget to City Council.
August 10 following regular
Council Budget Work Session
meeting
August 24 following regular
Council Budget Work Session
meeting
August 31
Council Budget Work Session
September 8, following regular
Council Budget Work Session
meeting
September 14
Council Budget Work Session review of previously presented department
requests; Council direction to staff with Council changes to draft budget
and proposed tax levy
September 28
Adopt proposed levy and certify to Wright County
October
Utility budgets due.
November
City Council work sessions to review utility budgets, CIP, and to review
previously presented General, Reserve, and Debt fund budgets and tax
levies.
December 7 Optional
Council Budget and CIP Work Session if needed
December 14
Hold public input budget meeting. Adopt final tax levy, all budgets and
CIP.
5/21/2015
General Fund Revenue; Finance, IT;
Planning; HPC, Building Safety
Public Safety (Police, Fire, Emergency
Management); Administration
Park Maintenance; Recreation;
Prairie Center
Streets; Fleet Maintenance;
Engineering; Facilities (City Hall and
Old City Hall)
Review of all departments
'01117V
M
Gregory A. Kramber
Wright County Assessor
Wright County Government Center
10 2nd Street NW,, Room 209
Buffalo, MN 55313-1183
Phone: (763) 682-7367 / (763) 682-7368
1 (800) 362-3667
FAX.- (763) 684-4553
www.co.wright.mn.us
2015 City of Otsego Assessment
Residential land and buildings increased approximately 9.13% throughout Otsego. The property value
increases are the result of 174 "qualified" sales used in the residential sales ratio study. (Assessed value
divided by sale price equals sales ratio). The state time adjusted sales ratio for the City of Otsego came in at
86.73% before any changes were made. After the changes were made the final ratio is 94.83%.
Median appraised value for 2013
$175,500
Median sale price paid in 2013
$196,100
Median appraised value for 2014
$185,000
Median sale price paid in 2014
$212,000
Commercial & industrial values increased by approximately 3.19%
Agricultural land values changed as follows:
Ag land outside the sewer district was unchanged at $9,000/Ac
Ag land inside the sewer district was changed from $9,500 to $10,000/Ac
Exception -Ag land in commercial areas along Hwy 19 was reduced to $10,000/Ac.
Exception -Ag along Parrish Ave and along 101 was raised to $15,000/Ac.
Agricultural land increased approximately 3.98%
Total dollar value of new construction for 2014(residential): $ 41,355,000
Total dollar value of new construction for 2014(commercial): $ 24,869,500
Total dollar value of new construction for 2014(agricultural): $ 0
Total $ 66,224,500
History of Otsego City yearly value total:
YEAR
1 2012
2013
2014
2015
VALUE $994,506,100
$1,032,807,000
$1,162,481,900
$1,323,345,144
-8.45%
+5.64%
+12.56%
+13.84%
Sincerely,
Conrad Anderson and Mike Vanderlinden
Wright County Assessor's Office
c
O
C
O
rA
7
U
0
O
LL
4141
10
E
LA
W
LO
C
E
a`
C
O 0 0 0 0 0 0
0
O O O
O V
V- O o
0 p
Ln OOO Ln OM
V'
M C) CDC)
-1
O O W
N Ln
f� OO N!V C LQC
0
n 00 ' 1 '
O Ol
LD C ,-1
O-0kDOO
OLn OI Ln OJ V'N
Ol
)M
C7 Ln Ln
O co
Ol 00
O a) -O
1-1 Ln Nm N Lo Ln
Lo
CO -i N
[Y co
O O I-1
N
Ol -1
O O
4- N
LO
V; Ln
C:) n
M
OO
V
N
Ln
�
a
O .--1
1-1
IT N N N l0 Ln
N
2
O
M
N
CO
CO
X
Nru
M 1-1
n
O
d- N
O O 00000
Q
O 00
O d-
d- —O
ra
Ln O O Ln O cn
O oOooOoo
Ol O O
O o0
o v-
V- V-0
Ln oOOLnCDM
V-
M oO
o -4
O CD -4
I� OO N N O LQC
M Ln Ol O -1
I; OO ' '
C OZ
LO LO OI
M 'O M
co O Ln Oi Ln W V"
N
C7 LO Ln
O OJ
(71 M V'
C:)
,-i Ln N M N LO Ln
LO
co -1 N
V" W
O N
N
+--I M +�
n
.--1 V" N
Lo
0)
NCL
M
V
Ln
O OOooOOO
O >
O CD CD
O d
V vo
�
Ln oOOLnoOld
a a
M C) CDC:)
.-1
O o.4
�
r� OONNOLQC
C
wo
0-.2 0 0 0 0
0
0 0 0
0 0
0 p
O
o N
.� MOOCD
O
O O
-4 NO
N Ln
+� O Ln
O0000
0
I
O V- O O O O O
Lo
M N Ln
Ol +�
Ol
)M
O O
O
M Mo LD-1uiri
j
ryi 4�
d
C C '
C
C
O
C
O O
coU
M
Ill Ln O Ln OM
U
n
OO
N N
N
La
�
a
O .--1
1-1
IT N N N l0 Ln
N
2
O
M
N
CO
CO
X
Nru
M 1-1
n
O
d- N
O O 00000
O
O 00
O d-
d- —O
ra
Ln O O Ln O cn
T
Ol O O
O
O 01 M
O NNO LQC
I 00
O
L O Cn
C
M Ln Ol O -1
V-
M Ln Ln
O Ln
M 'O M
Ol .�
MM
NM
Lo
N U
Q L
U
x
o d
n
Ln
O OOooOOO
O CD CD
O d
V vo
�
Ln oOOLnoOld
(1
M C) CDC:)
.-1
O o.4
�
r� OONNOLQC
I" 00 ' ' '
C OZ
L LO QI
07 CD Ln OI Ln CO V'N
-1
O Ln Ln
O rb
M M
LnO
.-i Ln N O Ln
M N L
Lo
W -4 N
V' OO
O N
N
+� M
fu
N
Lo
M N
E m
M
o
V
�
d
O
N SOF
J J
N i 'O 'O 'D
�
�
CL a
ow
E m m en
C
O
0 0 0 0 0 0
0
O
O O
M O V"
O
O
O
O
O O
0000000
0000000
O
0 0 0 0 0 0
0
O
O O
O
O
O
O
O
O O
O
C
C C C C C 0
C
O
C C '
C
C
O
C
O O
-0 Ln
M
Ill Ln O Ln OM
W
n
OO
N N
O
M
O
Od-
O .--1
1-1
IT N N N l0 Ln
N
V'
T O
M
N
CO
CO
a
d-
M 1-1
n
O
d- N
O
M
V
V
C
o
Ill W Ol
n O0 .-4
M
M
. o _
Nw
M O V"
LO
Q O
wv
L!'1
0000000
0000000
Ln O
-
Ln
-A
LnOOO
CO
000
Ln
W
O
O
O
O
Oo
MM
f�
0000000
O
n
N'
000
N
O
C
OIC
M
Ln Ln O Ln O M
W
.--1
O
C.Ln O
Ln
M
O
N N
� N
V'NNN to InN
M
O
O
OI,On
N
O
N
M
U
>
O
N
1-1 ri
d-
ra
Ln
,--1
H
C
o
Ill W Ol
n O0 .-4
M
M
. o _
Nw
M O V"
LO
Q O
wv
Ln
C) Ln 0000
OLOOOOOLo
Ln O
-
O 0000
0 oOOO
O
O
O
O
r
O
,-1
OI"OOOOIIz.
O�
O ' 0000
O
O
Cl
M
M
.-i
C7 I, O Ln Ln Ln
V' Ln O N N N
N Ln
N M
O O Ln O
Ln O n O
Ln n
N .--1
n
n
n
r�
N
o
M V"
LO
w v
M M
N
1
� N
41
J
M
v � v
M
IF
V
K a
U
>
E
ttr
ra
w - v
c a m
H
CL rev
m
o d
n
Ln
CL .n
L
�
(1
Ol O
.-j
�
m
y C fa
O a
D
-1
-1
L`aa -
�' °'
41
O y
ami
C)
fu
Li
LT
E m
o
�
V A
N SOF
J J
N i 'O 'O 'D
�
�
m
__ V
ow
E m m en
O L
a
ECT Epp
E
m �+m
U
E
al al c '�
cn
m
cr O i ami ami
C7 ac
J
J Q7 a1 L7
O Q
.5 Q N d
O c
Q
� N
O p
m O- i 0-0
E
p
�
3 +� = Q a
Ln I-
p N n n n
E E E
Ln
M
(n V) ,(2w ra
��
E ° cUn
oom��
Q
C
a)
(V p> i n -12
+--1 .-i 0 0 0
X
a)
C9
y, La ra T
iL Ln a amU n.
O O O O O
NNNNN
La
IT
M
o
Ill W Ol
n O0 .-4
M
M
. o _
Nw
M O V"
LO
Q O
M
o
a �
mo�x
,M-1
U > j n
r, O Ln
o
ro
E 3
a
LO N
V' o O o
Ln o rn
M
o
M V"
LO
w v
M M
N
1
� N
v � v
U
>
E
ttr
w - v
c a m
L, o M o
Lo LO
rl Ol
O
00 Mr�
W N W
o
U
'd)-eweJ(
LL C W
r, O Ln
o
LO N
N
[\ d- O
.--1
M
ri
tfT
Ln o LO o
LD n d- O
rl.Ln -4 LO
0)O LO
O
O
1-
i,9 -
OO o LO
E 3 0
= o
C)
0
u` o
OL � a
U �
I
U
O
I_ F. F IT
CD
0
ti
Ln
Z0
El
+
O
O
O
O
O
O
O
O
D W
W
O
O
O
E E
O
v
O
O
•X �
ri
N
W
t
N
r -i
M
c
SZ
SZ
A
Q
co
>
t11
Ol
I�
N
ci
c -I
c -I
N
EO
(U
O
O
O
L
N
N
N
N
a1
M
'cl'
00
l0
X
O
a i
ri
O
r -I
o
O
O
O
O
m
N
N
N
N
Ln
7
v
C
a1
N
SZ
SZ
A
co
>
L
a)
O
O
O
O
(U
Y
C
D
D
ci
E
f6
V
N
v
p
Z
L
p
Z
ate+
(0
-0
Q
X
O
�I
>
O
X
m
o
ON
m
N
fd
C7
00
I—
Ln
l0
I-
00
N
-i
L.O
00
W
t/}
t4
O
u'1
M
00
O
Lo
m
rn
-1
Ln
00
�
�
ONI
Q
N
L/1
Lr
N
ci
N
t/) -
Ln
v
a1
N
SZ
A
co
>
L
a)
ri
N
J
F-
Y
C
D
D
ci
E
f6
V
N
v
p
Z
L
p
Z
ate+
(0
-0
Q
X
O
N
>
>
X
m
o
m
LL
fd
C7
C6
l7
I—
CITY OF OTSEGO
COMBINED CASH INVESTMENT
MARCH 31. 2015
COMBINED CASH ACCOUNTS
001-10000 CASH & INVESTMENTS
001-11111 UTILITY CASH CLEARING
TOTAL COMBINED CASH
001-10100 CASH ALLOCATED TO OTHER FUNDS
TOTAL UNALLOCATED CASH
CASH ALLOCATION RECONCILIATION
101 ALLOCATION TO GENERAL FUND
201 ALLOCATION TO STREET PAVEMENT MANAGEMENT
202 ALLOCATION TO TRAIL PAVEMENT MANAGEMENT
203 ALLOCATION TO PARK DEVELOPMENT
204 ALLOCATION TO INSURANCE RESERVE
205 ALLOCATION TO PARK EQUIPMENT CAPITAL FUND
206 ALLOCATION TO CAPITAL EQUIPMENT REVOLVING
208 ALLOCATION TO COMMUNITY FACILITIES FUND
209 ALLOCATION TO COLLECTOR STREET RECONSTRUCTIO
214 ALLOCATION TO FIRE CAPITAL RESERVE FUND
220 ALLOCATION TO STORMWATER (OUT OF DISTRICT)
222 ALLOCATION TO STORMWATER (IN DISTRICT)
225 ALLOCATION TO STREET LIGHT UTILITY FEE
255 ALLOCATION TO DEVELOPMENT LOAN FUND
350 ALLOCATION TO 2003A IMPROVEMENT BONDS
360 ALLOCATION TO WEST W&S DEBT SERVICE FUND
361 ALLOCATION TO SEWER DEBT (REPORTING ONLY)
365 ALLOCATION TO QUADAY DEBT SERVICE -2004 BOND
375 ALLOCATION TO WATERFRONT EAST & MISSISSIPPI
380 ALLOCATION TO 206 STREET IMPROVEMENT
385 ALLOCATION TO 2007 PUBLIC WORKS FACILITY
395 ALLOCATION TO QUANTRELLE & 88TH STREET DEBT
399 ALLOCATION TO GO EQUIPMENT C OF 1
403 ALLOCATION TO COLLECTOR ROADS FUND
405 ALLOCATION TO NO MISSISSIPPI WATERSHED
406 ALLOCATION TO LEFEBVRE WATERSHED
408 ALLOCATION TO OTSEGO CREEK WATERSHED
410 ALLOCATION TO CROW RIVER WATERSHED
413 ALLOCATION TO 1998 ODEAN PROJECT
414 ALLOCATION TO REVOLVING CAPITAL IMPROVEMENTS
431 ALLOCATION TO SLAB TOWN W & S
441 ALLOCATION TO OTSEGO MUNICIPAL BUILDING FUND
480 ALLOCATION TO 194/CSAH 37/19 & KADLER
499 ALLOCATION TO WELLHEAD PROTECTION PROJECT
601 ALLOCATION TO WATER FUND
602 ALLOCATION TO SEWER FUND
701 ALLOCATION TO DEVELOPMENT ESCROWS FUND
702 ALLOCATION TO BUILDERS ESCROW FUND
24,752,891.18
765.21
24,753,656.39
( 24,753,656.39)
.00
2,720,792.32
299,395.93
2,993.98
723,049.10
101, 832.70
127,119.79
441, 876.75
471,197.69
443,207.48
1,738,093.22
73,487.80
19,397.08)
98,836.51
290,800.80
3,492.12)
3,154, 082.84
4,481,054.83
157,674.91)
683,516.17
1,443, 709.41
403, 590.60
122,691.98)
102,660.98)
127,262.77
307,222.32)
16, 377.21)
692,528.99
11, 991.04)
5,425.32)
302,368.34
7,417.47
37,325.05
.35
5,158.89)
3,442,909.61
2,378,917.27
633,650.16
184,730.31
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 27/21/2015 04:27PM PAGE: 1
CITY OF OTSEGO
COMBINED CASH INVESTMENT
MARCH 31, 2015
TOTAL ALLOCATIONS TO OTHER FUNDS 24,753,656.39
ALLOCATION FROM COMBINED CASH FUND - 001-10100 ( 24,753,656.39)
ZERO PROOF IF ALLOCATIONS BALANCE .00
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 27/21/2015 04:27PM PAGE: 2
CITY OF OTSEGO
REVENUES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
GENERALFUND
BUDGET YTD ACTUAL PERIOD ACTUAL VARIANCE PCNT
TAXES
101-31010
CURRENT AD VALOREM TAXES
3,319,000.00
.00
.00
3,319,000.00
.0
101-31900
PENALTIES AND INTEREST
15,000.00
.00
.00
15,000.00
.0
TOTAL TAXES
3,334,000.00
.00
.00
3,334,000.00
.0
LICENSES AND PERMITS
101-32100
BUSINESS LICENSES/PERMITS
600.00
1,180.98
.00 (
580.98)
196.8
101-32130
FIRE INSPECTIONS
1,000.00
.00
.00
1,000.00
.0
101-32140
RENTAL INSPECTION FEES
29,000.00
8,160.00
1,950.00
20,840.00
28.1
101-32150
PUBLIC UTILITIES ROW PERMITS
2,500.00
8,200.00
2,600.00 (
5,700.00)
328.0
101-32180
OTHER LICENSES/PERMITS
.00
710.00
510.00 (
710.00)
.0
101-32190
FENCING PERMITS
1,750.00
50.00
50.00
1,700.00
2.9
101-32210
LIQUOR LICENSES
33,850.00
2,375.00
.00
31,475.00
7.0
101-32250
SIGN PERMIT
300.00
100.00
.00
200.00
33.3
101-32260
BUILDING PERMITS
400,000.00
192,228.05
55,449.42
207,771.95
48.1
101-32261
PLUMBING PERMITS
52,000.00
14,875.00
5,020.00
37,125.00
28.6
101-32262
MECHANICAL PERMITS
58,000.00
14,700.00
3,710.00
43,300.00
25.3
101-32270
SEPTIC SYSTEM PERMITS
3,000.00
300.00
150.00
2,700.00
10.0
101-32999
ASSESSORS FEE
10,000.00
2,050.00
600.00
7,950.00
20.5
TOTAL LICENSES AND PERMITS
592,000.00
244,929.03
70,039.42
347,070.97
41.4
INTERGOVERNMENTAL REVENUES
101-33403
LOCAL GOVERNMENT AID
123,947.00
.00
.00
123,947.00
.0
101-33405
POLICE AID
46,375.00
.00
.00
46,375.00
.0
101-33406
MSA MAINTENANCE
152,800.00
91,037.50
.00
61,762.50
59.6
TOTAL INTERGOVERNMENTAL REVENUES
323,122.00
91,037.50
.00
232,084.50
28.2
CHARGES FOR SERVICES
101-34050
ADMINISTRATIVE FEES
250.00
3,900.00
3,900.00 (
3,650.00)
1560.0
101-34103
ZONING AND SUBDIVISION FEES
5,000.00
.00
.00
5,000.00
.0
101-34107
ASSESSMENT SEARCH FEES
2,500.00
315.00
35.00
2,185.00
12.6
101-34207
REIMBURSABLE EXPENSE MOWING
2,000.00
.00
.00
2,000.00
.0
101-34320
STREET LIGHT OF
1,800.00
.00
.00
1,800.00
.0
101-34330
GRADING REVIEWS
4,000.00 (
62.50) (
62.50)
4,062.50
( 1.6)
101-34700
RECREATION FEES BUDGET
.00
12,524.00
9,525.00 (
12,524.00)
.0
101-34710
RECREATION FEES
22,000.00
565.18
319.31
21,434.82
2.6
101-34740
SPORT FIELD USE
3,500.00
.00
.00
3,500.00
.0
101-34750
PRAIRIE CENTER
6,000.00
1,624.14
654.97
4,375.86
27.1
101-34760
OTSEGO FESTIVAL VENDORS
3,650.00
.00
.00
3,650.00
.0
TOTAL CHARGES FOR SERVICES
50,700.00 18,865.82
14,371.78
31,834.18 37.2
FOR ADMINISTRATION USE ONLY
25 % OF THE FISCAL YEAR HAS ELAPSED
05/21/2015
04:42PM PAGE: 1
CITY OF OTSEGO
REVENUES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
GENERALFUND
BUDGET YTD ACTUAL PERIOD ACTUAL VARIANCE PCNT
INTEREST, ASSESSMENTS & OTHER
101-36200 MISCELLANEOUS REVENUES
101-36210 INTEREST EARNINGS
TOTAL INTEREST, ASSESSMENTS & OTHER
OTHER REVENUE SOURCES
101-38020 DONATIONS/CONTRIBUTIONS
101-38050 CABLE TV FRANCHISE FEES
TOTAL OTHER REVENUE SOURCES
OTHER FINANCING SOURCES
101-39200 INTERFUND OPERATING TRANSFERS
TOTAL OTHER FINANCING SOURCES
TOTAL FUND REVENUE
.00
95,000.00
651.00
43,686.72
451.00 (
7,239.44
651.00)
51,313.28
.0
46.0
95,000.00
44,337.72
7,690.44
50,662.28
46.7
1,000.00
105,000.00
5,000.00
32,641.37
.00 (
.00
4,000.00)
72,358.63
500.0
31.1
106,000.00
37,641.37
.00
68,358.63
35.5
148, 047.00
.00
.00
148, 047.00
.0
148, 047.00
.00
.00
148, 047.00
.0
4,648,869.00
436,811.44
92,101.64
4,212,057.56
9.4
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:42PM PAGE: 2
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
GENERALFUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
101-41100-104
PART-TIME EMPLOYEES REGULAR
30,000.00
7,675.00
5,090.00
22,325.00
25.6
101-41100-122
FICA AND MEDICARE
2,295.00
587.19
389.39
1,707.81
25.6
101-41100-150
WORKERS COMPENSATION
102.00
28.22
.00
73.78
27.7
101-41100-320
TELEPHONE
2,520.00
420.12
210.06
2,099.88
16.7
101-41100-321
MILEAGE/TRAVEL
200.00
.00
.00
200.00
.0
101-41100-355
DUES & MEMBERSHIPS
200.00
.00
.00
200.00
.0
101-41100-360
EDUCATION/TRAINING/CONFERENCES
2,000.00
278.01
62.47
1,721.99
13.9
101-41100-801
CONTINGENCY
45,000.00
111.40
.00
44,888.60
.3
101-41400-206
TOTAL CITY COUNCIL
82,317.00
9,099.94
5,751.92
73,217.06
11.1
ADMINISTRATION
101-41400-101
FULL-TIME EMPLOYEES REGULAR
226,970.00
54,646.58
26,716.80
172,323.42
24.1
101-41400-104
PART-TIME - EMPLOYEES REGULAR
29,120.00
869.00
132.00
28,251.00
3.0
101-41400-121
PERA
19,207.00
3,990.77
1,335.84
15,216.23
20.8
101-41400-122
FICA AND MEDICARE
19,591.00
4,028.04
1,959.37
15,562.96
20.6
101-41400-123
HEALTH
.00
3,295.41
1,235.15 (
3,295.41)
.0
101-41400-130
OTHER EMPLOYER PAID INS
22,069.00
573.28
143.32
21,495.72
2.6
101-41400-150
WORKERS COMPENSATION
1,335.00
449.95
.00
885.05
33.7
101-41400-201
OFFICE SUPPLIES AND EXPENSES
8,500.00
2,387.74
1,355.55
6,112.26
28.1
101-41400-206
POSTAGE
4,000.00
.00
.00
4,000.00
.0
101-41400-210
OPERATING SUPPLIES
1,250.00
.00
.00
1,250.00
.0
101-41400-320
TELEPHONE
1,450.00
607.73
276.21
842.27
41.9
101-41400-321
MILEAGE/TRAVEL
1,100.00
83.45
83.45
1,016.55
7.6
101-41400-340
RECORDING FEES
1,000.00
138.00
.00
862.00
13.8
101-41400-347
NEWSLETTER
15,972.00
4,283.42
4,283.42
11,688.58
26.8
101-41400-350
PRINT & PUBLISHING
4,690.00
1,302.50
510.50
3,387.50
27.8
101-41400-355
DUES & MEMBERSHIPS
12,159.00
155.00
.00
12,004.00
1.3
101-41400-360
EDUCATION/TRAINING/CONFERENCES
2,081.00
782.50
.00
1,298.50
37.6
101-41400-361
LIABILITY AND PROPERTY INSURAN
21,929.00
15,423.28
.00
6,505.72
70.3
101-41400-390
CONTRACTED SERVICES
10,450.00
5,614.00
.00
4,836.00
53.7
101-41400-410
RENTALS
12,400.00
4,261.43
2,189.69
8,138.57
34.4
TOTAL ADMINISTRATION
415,273.00
102,892.08
40,221.30
312,380.92
24.8
ELECTIONS
101-41410-210
OPERATING SUPPLIES
700.00
696.46
.00
3.54
99.5
101-41410-321
MILEAGE/TRAVEL
45.00
.00
.00
45.00
.0
101-41410-350
PRINT & PUBLISHING
.00
168.00
.00 (
168.00)
.0
TOTAL ELECTIONS
745.00
864.46
.00 (
119.46)
116.0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:42PM PAGE: 3
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
GENERALFUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
ASSESSOR
101-41550-390 CONTRACTED SERVICES
TOTALASSESSOR
101-41600-101
FULL-TIME EMPLOYEES REGULAR
101-41600-104
WAGES - PT EMPLOYEES
101-41600-121
PERA
101-41600-122
FICA AND MEDICARE
101-41600-123
HEALTH
101-41600-130
OTHER EMPLOYER PAID INS
101-41600-150
WORKERS COMPENSATION
101-41600-201
OFFICE SUPPLIES AND EXPENSES
101-41600-304
ACCOUNTING & AUDITING
101-41600-321
MILEAGE/TRAVEL
101-41600-350
PRINT & PUBLISHING
101-41600-355
DUES & MEMBERSHIPS
101-41600-360
EDUCATION/TRAINING/CONFERENCES
101-41600-390
CONTRACTED SERVICES
24,086.95
TOTAL FINANCE
1,100.00
INFORMATION TECHNOLOGY
101-41650-206
OPERATING SUPPLIES
101-41650-315
GIS SERVICES
101-41650-360
EDUCATION/TRAINING/CONFERENCES
101-41650-390
CONTRACTED SERVICES
30,435.00
TOTAL INFORMATION TECHNOLOGY
101-41700-301 LEGAL SERVICES
TOTAL LEGAL SERVICES
74,700.00 .00 .00 74,700.00 .0
74,700.00 .00 .00 74,700.00 .0
153,940.00
35,779.03
17,872.81
118,160.97
23.2
74,380.00
9,000.00
5,148.01
65,380.00
12.1
16,553.00
2,805.73
893.64
13,747.27
17.0
17,466.00
3,412.60
1,701.21
14,053.40
19.5
.00
6,074.17
2,002.50 (
6,074.17)
.0
24,619.00
532.05
133.01
24,086.95
2.2
1,100.00
427.80
.00
672.20
38.9
5,200.00
286.96
35.60
4,913.04
5.5
30,435.00
850.00
850.00
29,585.00
2.8
440.00
.00
.00
440.00
.0
1,000.00
.00
.00
1,000.00
.0
640.00
60.00
60.00
580.00
9.4
4,430.00
987.50
425.00
3,442.50
22.3
12,500.00
5,456.80
1,872.60
7,043.20
43.7
342,703.00
65,672.64
30,994.38
277,030.36
19.2
6,000.00
118.93
118.93
5,881.07
2.0
16,000.00
.00
.00
16,000.00
.0
2,400.00
.00
.00
2,400.00
.0
41,900.00
4,675.30
4,386.05
37,224.70
11.2
66,300.00
4,794.23
4,504.98
61,505.77
7.2
82,000.00
22,130.20
10,264.00
59,869.80
27.0
82,000.00
22,130.20
10,264.00
59,869.80
27.0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:42PM PAGE: 4
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
GENERALFUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
101-41940-104
PART-TIME - EMPLOYEES REGULAR
4,000.00
.00
.00
4,000.00
.0
101-41940-122
FICA AND MEDICARE
306.00
.00
.00
306.00
.0
101-41940-150
WORKERS COMP
50.00
.00
.00
50.00
.0
101-41940-201
OFFICE SUPPLIES AND EXPENSES
500.00
.00
.00
500.00
.0
101-41940-202
FUEL
1,000.00
.00
.00
1,000.00
.0
101-41940-210
OPERATING SUPPLIES
3,000.00
1,378.97
1,078.59
1,621.03
46.0
101-41940-220
REPAIR/MAINT SUPPLY
5,000.00
19.27
.00
4,980.73
.4
101-41940-322
UTILITIES
11,140.00
1,376.58
1,196.62
9,763.42
12.4
101-41940-325
GARBAGE SERVICE
1,680.00
156.46
.00
1,523.54
9.3
101-41940-361
LIABILITY AND PROPERTY INSURAN
1,236.00
869.31
.00
366.69
70.3
101-41940-389
CLEANING SERVICES
3,000.00
.00
.00
3,000.00
.0
101-41940-390
CONTRACTED SERVICES
4,710.00
2,139.53
582.71
2,570.47
45.4
TOTAL PRAIRIE CENTER
35,622.00
5,940.12
2,857.92
29,681.88
16.7
CITY HALL/PW BUILDING
101-41945-201
OFFICE SUPPLIES AND EXPENSES
100.00
.00
.00
100.00
.0
101-41945-202
FUEL
2,000.00
.00
.00
2,000.00
.0
101-41945-210
OPERATING SUPPLIES
4,300.00
592.63
542.03
3,707.37
13.8
101-41945-220
REPAIR/MAINT SUPPLY
3,500.00
.00
.00
3,500.00
.0
101-41945-320
TELEPHONE
3,200.00
537.46
179.26
2,662.54
16.8
101-41945-322
UTILITIES
28,000.00
11,447.59
3,749.36
16,552.41
40.9
101-41945-325
GARBAGE SERVICE
5,000.00
176.36
.00
4,823.64
3.5
101-41945-361
LIABILITY AND PROPERTY INS
6,463.00
4,545.61
.00
1,917.39
70.3
101-41945-389
CLEANING SERVICES
11,000.00
2,475.00
1,650.00
8,525.00
22.5
101-41945-390
CONTRACTED SERVICES
15,500.00
2,378.70
1,252.74
13,121.30
15.4
TOTAL CITY HALL/PW BUILDING
79,063.00
22,153.35
7,373.39
56,909.65
28.0
OLD TOWN HALL SITE
101-41950-210
OPERAT SUPPLIES OLD TOWN HALL
1,000.00
.00
.00
1,000.00
.0
101-41950-322
UTILITIES
500.00
138.41
48.36
361.59
27.7
101-41950-361
INSURANCE - OLD TOWN HALL
500.00
.00
.00
500.00
.0
101-41950-390
CONTRACTED SERVICES
1,000.00
.00
.00
1,000.00
.0
TOTAL OLD TOWN HALL SITE 3,000.00 138.41 48.36 2,861.59 4.6
POLICE SERVICES
101-42100-390 CONTRACTED SERVICES
941,700.00 234,103.43
78,475.00
707,596.57 24.9
TOTAL POLICE SERVICES
941,700.00 234,103.43
78,475.00
707,596.57 24.9
FOR ADMINISTRATION USE ONLY
25 % OF THE FISCAL YEAR HAS ELAPSED
05/21/2015
04:42PM PAGE: 5
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
GENERALFUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
POLICE COMMISSION
101-42150-104 PART-TIME EMPLOYEES REGULAR 750.00 .00 .00 750.00 .0
101-42150-210 OPERATING SUPPLIES 600.00 .00 .00 600.00 .0
TOTAL POLICE COMMISSION 1,350.00 .00 .00 1,350.00 .0
FIRE PROTECTION
101-42200-390 CONTRACTED SERVICES
TOTAL FIRE PROTECTION
BUILDING INSPECTION SERVICES
454,560.00 125,205.17 .00 329,354.83 27.5
454,560.00 125,205.17 .00 329,354.83 27.5
101-42410-101
FULL-TIME EMPLOYEES REGULAR
50,066.00
12,108.08
5,894.40
37,957.92
24.2
101-42410-121
PERA
3,630.00
879.19
294.72
2,750.81
24.2
101-42410-122
FICA AND MEDICARE
3,830.00
882.76
432.28
2,947.24
23.1
101-42410-123
HEALTH
9,264.00
1,969.83
613.87
7,294.17
21.3
101-42410-130
OTHER EMPLOYER PAID INS
.00
161.48
40.37 (
161.48)
.0
101-42410-150
WORKERS COMPENSATION
356.00
96.67
.00
259.33
27.2
101-42410-201
OFFICE SUPPLIES AND EXPENSES
2,200.00
403.46
403.46
1,796.54
18.3
101-42410-202
FUEL
4,500.00
.00
.00
4,500.00
.0
101-42410-302
ENGINEERING FEES
4,000.00
.00
.00
4,000.00
.0
101-42410-303
PLANNING FEES
6,500.00
700.00
.00
5,800.00
10.8
101-42410-320
TELEPHONE
1,800.00
392.69
131.19
1,407.31
21.8
101-42410-336
ASSESSOR FEE -NEW CONSTRUCTION
10,000.00
.00
.00
10,000.00
.0
101-42410-350
PRINT & PUBLISHING
.00
150.00
150.00 (
150.00)
.0
101-42410-355
DUES & MEMBERSHIPS
275.00
175.00
.00
100.00
63.6
101-42410-360
EDUCATION/TRAINING/CONFERENCES
232.00
292.50
.00 (
60.50)
126.1
101-42410-390
CONTRACTED SERVICES
124,800.00
17,790.00
8,450.00
107,010.00
14.3
101-42410-410
RENTALS
4,270.00
633.18
633.18
3,636.82
14.8
101-42410-501
EQUIPMENT
4,000.00
.00
.00
4,000.00
.0
TOTAL BUILDING INSPECTION SERVICES
229,723.00
36,634.84
17,043.47
193,088.16
16.0
EMERGENCY MANAGEMENT
101-42500-210
OPERATING SUPPLIES
2,500.00
.00
.00
2,500.00
.0
101-42500-322
UTILITIES
450.00
63.86
22.17
386.14
14.2
101-42500-360
EDUCATION/TRAINING/CONFERENCES
2,500.00
.00
.00
2,500.00
.0
101-42500-390
CONTRACTED SERVICES
2,000.00
.00
.00
2,000.00
.0
TOTAL EMERGENCY MANAGEMENT
7,450.00
63.86
22.17
7,386.14
.9
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:42PM PAGE: 6
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
GENERALFUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
101-42710-390 CONTRACTED SERVICES 11,300.00 2,160.00 2,160.00 9,140.00 19.1
TOTAL ANIMAL CONTROL 11,300.00 2,160.00 2,160.00 9,140.00 19.1
STREETS
101-43100-101
FULL-TIME EMPLOYEES REGULAR
297,128.00
93,437.51
25,252.81
203,690.49
31.5
101-43100-102
FULL-TIME - OVERTIME
8,000.00
746.74
.00
7,253.26
9.3
101-43100-104
PART-TIME - EMPLOYEES REGULAR
52,268.00
9,560.04
5,072.59
42,707.96
18.3
101-43100-121
PERA
26,805.00
4,301.12
1,490.66
22,503.88
16.1
101-43100-122
FICA AND MEDICARE
27,341.00
7,484.63
2,119.71
19,856.37
27.4
101-43100-123
HEALTH
.00
7,185.32
515.56 (
7,185.32)
.0
101-43100-130
OTHER EMPLOYER PAID INS
37,910.00
713.98
197.49
37,196.02
1.9
101-43100-150
WORKERS COMPENSATION
20,200.00
7,991.21
.00
12,208.79
39.6
101-43100-201
OFFICE SUPPLIES AND EXPENSES
500.00
.00
.00
500.00
.0
101-43100-210
OPERATING SUPPLIES
3,265.00
1,620.83
582.83
1,644.17
49.6
101-43100-220
REPAIR/MAINT SUPPLY
4,690.00
20.00
.00
4,670.00
.4
101-43100-225
UNIFORMS/CLOTHING ALLOWANCE
3,940.00
1,208.00
1,208.00
2,732.00
30.7
101-43100-227
SAFETY SUPPLIES
1,875.00
.00
.00
1,875.00
.0
101-43100-234
BLACKTOP SUPPLIES
15,000.00
125.00
.00
14,875.00
.8
101-43100-240
SMALL TOOLS/EQUIPMENT
9,380.00
1,352.85
1,267.17
8,027.15
14.4
101-43100-270
SAND AND GRAVEL
20,000.00
.00
.00
20,000.00
.0
101-43100-272
SALT AND SAND
75,000.00
26,652.79
8,585.04
48,347.21
35.5
101-43100-293
SIGN/SIGNAL MATERIAL PURCHASED
12,800.00
18.82 (
45.89)
12,781.18
.2
101-43100-302
ENGINEERING FEES
.00
215.00
215.00 (
215.00)
.0
101-43100-320
TELEPHONE
5,040.00
1,105.29
502.49
3,934.71
21.9
101-43100-322
UTILITIES
1,200.00
356.52
146.90
843.48
29.7
101-43100-325
GARBAGE SERVICE
500.00
.00
.00
500.00
.0
101-43100-350
PRINT & PUBLISHING
.00
264.00
264.00 (
264.00)
.0
101-43100-355
DUES & MEMBERSHIPS
500.00
186.67
.00
313.33
37.3
101-43100-360
EDUCATION/TRAINING/CONFERENCES
7,577.00
918.75
.00
6,658.25
12.1
101-43100-361
LIABILITY AND PROPERTY INSURAN
24,154.00
16,985.37
.00
7,168.63
70.3
101-43100-390
CONTRACTED SERVICES
5,000.00
1,824.39
1,599.39
3,175.61
36.5
101-43100-410
RENTALS
5,750.00
.00
.00
5,750.00
.0
101-43100-436
DUSTCOATING
15,300.00
.00
.00
15,300.00
.0
TOTAL STREETS
681,123.00
184,274.83
48,973.75
496,848.17
27.1
ENGINEERING
101-43150-302
ENGINEERING FEES
85,000.00
11,321.60
11,321.60
73,678.40
13.3
TOTAL ENGINEERING
85,000.00
11,321.60
11,321.60
73,678.40
13.3
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:42PM PAGE: 7
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
GENERALFUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
Gg7�i�i�[el:l�:
101-43160-322
UTILITIES
.00
26,890.67
8,938.79 (
26,890.67)
.0
101-43160-350
UTILITIES
114,100.00
.00
.00
114,100.00
.0
TOTAL STREET LIGHTS
114,100.00
26,890.67
8,938.79
87,209.33
23.6
FLEET MANAGEMENT
101-43240-101
FULL-TIME EMPLOYEES REGULAR
53,581.00
14,683.52
6,307.20
38,897.48
27.4
101-43240-121
PERA
3,885.00
943.53
315.36
2,941.47
24.3
101-43240-122
FICA AND MEDICARE
4,099.00
1,036.60
445.35
3,062.40
25.3
101-43240-123
HEALTH
.00
2,451.36
817.12 (
2,451.36)
.0
101-43240-130
OTHER EMPLOYER PAID INS
9,118.00
169.32
42.33
8,948.68
1.9
101-43240-150
WORKERS COMPENSATION
2,163.00
759.23
.00
1,403.77
35.1
101-43240-202
FUEL
64,034.00
9,724.07
184.68
54,309.93
15.2
101-43240-210
OPERATING SUPPLIES
15,800.00
5,233.15
2,029.75
10,566.85
33.1
101-43240-220
REPAIR/MAINT SUPPLY
22,000.00
4,404.23
1,274.47
17,595.77
20.0
101-43240-225
UNIFORMS/CLOTHING ALLOWANCE
1,500.00
528.40
214.43
971.60
35.2
101-43240-240
SMALL TOOLS/EQUIPMENT
2,500.00
413.65
413.65
2,086.35
16.6
101-43240-360
EDUCATION/TRAINING/CONFERENCES
1,080.00
206.25
.00
873.75
19.1
101-43240-361
LIABILITY AND PROPERTY INS
.00
5,732.25
.00 (
5,732.25)
.0
101-43240-390
CONTRACTED SERVICES
7,500.00
.00
.00
7,500.00
.0
TOTAL FLEET MANAGEMENT
187,260.00
46,285.56
12,044.34
140,974.44
24.7
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 8
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31. 2015
GENERALFUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
PARK MAINTENANCE
101-45200-101
FULL-TIME EMPLOYEES REGULAR
84,148.00
19,150.75
10,457.27
64,997.25
22.8
101-45200-102
OVERTIME
.00
310.05
.00 (
310.05)
.0
101-45200-104
PART-TIME - EMPLOYEES REGULAR
52,126.00
.00
.00
52,126.00
.0
101-45200-121
PERA
6,101.00
1,505.41
493.17
4,595.59
24.7
101-45200-122
FICA AND MEDICARE
10,425.00
1,414.18
743.74
9,010.82
13.6
101-45200-123
HEALTH
.00
495.17
129.77 (
495.17)
.0
101-45200-130
OTHER EMPLOYER PAID INS
3,674.00
249.20
62.30
3,424.80
6.8
101-45200-150
WORKERS COMPENSATION
2,771.00
1,393.99
.00
1,377.01
50.3
101-45200-201
OFFICE SUPPLIES AND EXPENSES
230.00
951.66
52.00 (
721.66)
413.8
101-45200-210
OPERATING SUPPLIES
37,970.00
355.45
355.45
37,614.55
.9
101-45200-220
REPAIR/MAINT SUPPLY
15,500.00
1,800.64
1,800.64
13,699.36
11.6
101-45200-225
UNIFORMS/CLOTHING ALLOWANCE
1,430.00
224.00
.00
1,206.00
15.7
101-45200-227
SAFETY SUPPLIES
1,200.00
331.96
331.96
868.04
27.7
101-45200-240
SMALL TOOLS/EQUIPMENT
5,000.00
256.58
6.95
4,743.42
5.1
101-45200-320
TELEPHONE
2,850.00
996.06
319.76
1,853.94
35.0
101-45200-322
UTILITIES
29,086.00
3,237.52
1,671.83
25,848.48
11.1
101-45200-325
GARBAGE SERVICE
1,200.00
680.31
680.31
519.69
56.7
101-45200-355
DUES & MEMBERSHIPS
600.00
165.00
.00
435.00
27.5
101-45200-360
EDUCATION/TRAINING/CONFERENCES
3,509.00
942.71
277.00
2,566.29
26.9
101-45200-361
LIABILITY AND PROPERTY INSURAN
36,411.00
25,608.88
.00
10,802.12
70.3
101-45200-390
CONTRACTED SERVICES
34,500.00
478.40
239.20
34,021.60
1.4
101-45200-410
RENTALS
2,000.00
.00
.00
2,000.00
.0
101-45200-501
EQUIPMENT
13,120.00
11,239.64
.00
1,880.36
85.7
TOTAL PARK MAINTENANCE 343,851.00 71,787.56 17,621.35 272,063.44 20.9
RECREATION
101-45250-101
FULL-TIME EMPLOYEES REGULAR
40,235.00
10,989.49
4,734.72
29,245.51
27.3
101-45250-104
PART-TIME EMPLOYEES REGULAR
20,779.00
8,134.34
4,092.58
12,644.66
39.2
101-45250-121
PERA
4,088.00
1,037.59
370.96
3,050.41
25.4
101-45250-122
FICA AND MEDICARE
4,314.00
1,414.64
654.50
2,899.36
32.8
101-45250-123
HEALTH
.00
1,405.57
445.00 (
1,405.57)
.0
101-45250-130
OTHER EMPLOYER PAID INS
3,050.00
114.48
28.62
2,935.52
3.8
101-45250-150
WORKERS COMPENSATION
1,834.00
110.91
.00
1,723.09
6.1
101-45250-201
OFFICE SUPPLIES AND EXPENSES
210.00
20.50
20.50
189.50
9.8
101-45250-210
OPERATING SUPPLIES
10,820.00
.00
.00
10,820.00
.0
101-45250-225
UNIFORMS
300.00
.00
.00
300.00
.0
101-45250-320
TELEPHONE
2,300.00
70.02
35.01
2,229.98
3.0
101-45250-350
PRINT & PUBLISHING
6,000.00
939.95
900.00
5,060.05
15.7
101-45250-360
EDUCATION/TRAINING/CONFERENCES
1,732.00
.00
.00
1,732.00
.0
101-45250-390
CONTRACTED SERVICES
7,600.00
.00
.00
7,600.00
.0
101-45250-440
RECREATION PROGRAMMING
.00
1,114.86
345.20 (
1,114.86)
.0
101-45250-445
COMMUNITY EVENTS
23,650.00
2,503.34
1,858.31
21,146.66
10.6
TOTAL RECREATION 126,912.00 27,855.69 13,485.40 99,056.31 22.0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 9
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
GENERALFUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
450.00
HERITAGE PRESERVATION COMMISSI
101-45300-104
PART-TIME EMPLOYEES REGULAR
101-45300-201
OFFICE SUPPLIES AND EXPENSES
101-45300-360
EDUCATION/TRAINING/CONFERENCES
455.20
TOTAL HERITAGE PRESERVATION COMMISSI
300.00
PLANNING COMMISSION
101-46530-104
PART-TIME EMPLOYEES REGULAR
101-46530-210
OPERATING SUPPLIES
101-46530-360
EDUCATION/TRAINING/CONFERENCES
1,205.20
TOTAL PLANNING COMMISSION
5,000.00
CITY PLANNER
101-46570-303
PLANNING FEES
.0
TOTAL CITY PLANNER
9,677.10
ECONOMIC DEVELOPMENT
101-46580-201
OFFICE SUPPLIES AND EXPENSES
101-46580-350
DUES & MEMBERSHIPS
101-46580-360
EDUCATION/TRAINING/CONFERENCES
101-46580-380
MARKETING
101-46580-390
CONTRACTED SERVICES
23.0
TOTAL ECONOMIC DEVELOPMENT
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
450.00
.00
.00
450.00
.0
500.00
44.80
44.80
455.20
9.0
300.00
.00
.00
300.00
.0
1,250.00
44.80
44.80
1,205.20
3.6
1,500.00
.00
750.00
.00
12.00
.00
.00
.00 (
.00
1,500.00
12.00)
750.00
.0
.0
.0
2,250.00
12.00
.00
2,238.00
.5
65,000.00
12,700.00
6,177.50
52,300.00
19.5
65,000.00
12,700.00
6,177.50
52,300.00
19.5
200.00
.00
.00
200.00
.0
3,300.00
9,027.10
6,250.00 (
5,727.10)
273.6
600.00
.00
.00
600.00
.0
5,000.00
650.00
650.00
4,350.00
13.0
5,000.00
.00
.00
5,000.00
.0
14,100.00
9,677.10
6,900.00
4,422.90
68.6
4,448,652.00
1,022,702.54
325,224.42
3,425,949.46
23.0
200,217.00 (
585,891.10) (
233,122.78)
786,108.10
(292.6)
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 10
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
STREET PAVEMENT MANAGEMENT
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
STREETS
201-43100-302 ENGINEERING FEES
TOTALSTREETS
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
.00
107.50
107.50 (
107.50) .0
.00
107.50
107.50 (
107.50) .0
.00
107.50
107.50 (
107.50) .0
.00 (
107.50) (
107.50)
107.50 .0
FOR ADMINISTRATION USE ONLY 26 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 11
CITY OF OTSEGO
REVENUES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
PARK DEVELOPMENT
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
MISC REVENUES
203-36240 PARK DEDICATION FEES .00 2,635.00 .00 ( 2,635.00) .0
TOTAL MISC REVENUES .00 2,635.00 .00 ( 2,635.00) .0
TOTAL FUND REVENUE .00 2,635.00 .00 ( 2,635.00) 0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 12
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
PARK DEVELOPMENT
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
DEPARTMENT 210
203-45210-302 ENGINEERING FEES .00
TOTAL DEPARTMENT 210 .00
TOTAL FUND EXPENDITURES .00
NET REVENUE OVER EXPENDITURES .00
96.50
96.50 (
96.50) .0
96.50
96.50 (
96.50) .0
96.50
96.50 (
96.50) .0
2,538.50 (
96.50) (
2,538.50) .0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 13
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
CAPITAL EQUIPMENT REVOLVING
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
206-43100-501 EQUIPMENT
TOTAL DEPARTMENT 100
DEPARTMENT 240
206-43240-501 EQUIPMENT
TOTAL DEPARTMENT 240
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
.00 21,375.12 2,607.68 ( 21,375.12) .0
.00 21,375.12 2,607.68 ( 21,375.12) .0
.00 87,645.92
.00 (
87,645.92) .0
.00 87,645.92
.00 (
87,645.92) .0
.00 109,021.04
2,607.68 (
109,021.04) .0
.00 ( 109,021.04) ( 2,607.68) 109,021.04 .0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 14
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
COMMUNITY FACILITIES FUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
RECREATION
208-45210-302 ENGINEERING FEES
TOTAL RECREATION
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
.00 430.00
.00 430.00
00 430.00
.00 ( 430.00)
430.00 (
430.00)
.0
430.00 (
430.00)
.0
430.00 (
430.00)
.0
430.00)
430.00
.0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 15
CITY OF OTSEGO
REVENUES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
STORMWATER (IN DISTRICT)
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
MISC REVENUES
222-36100 SPECIAL ASSESSMENTS
.00
389.08
389.08 (
389.08)
.0
TOTAL MISC REVENUES
.00
389.08
389.08 (
389.08)
.0
PROPRIETARY FUND REVENUES
222-37500 STORMWATER UTILITY CHARGES
.00
3,757.71
1,245.07 (
3,757.71)
.0
TOTAL PROPRIETARY FUND REVENUES
.00
3,757.71
1,245.07 (
3,757.71)
.0
TOTAL FUND REVENUE
.00
4,146.79
1,634.15 (
4,146.79)
.0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 16
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
STORMWATER (IN DISTRICT)
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
STORMWATER MAINTENANCE
222-49490-302 ENGINEERING FEES
222-49490-322 UTILITY
222-49490-355 DUES & MEMBERSHIPS
TOTAL STORMWATER MAINTENANCE
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
.00
2,028.13
2,028.13 (
2,028.13) .0
.00
402.95
135.16 (
402.95) .0
.00
760.00
760.00 (
760.00) .0
.00
3,191.08
2,923.29 (
3,191.08) .0
.00
3,191.08
2,923.29 (
3,191.08) .0
.00
955.71 (
1,289.14) (
955.71) .0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 17
CITY OF OTSEGO
REVENUES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
STREET LIGHT UTILITY FEE
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
TAXES
225-31900 PENALTIES AND INTEREST .00 658.43
TOTAL TAXES .00 658.43
CHARGES FOR SERVICES
225-34320 STREET LIGHT OP .00 6,049.68
TOTAL CHARGES FOR SERVICES .00 6,049.68
TOTAL FUND REVENUE .00 6,708.11
226.76 ( 658.43) .0
226.76 ( 658.43) .0
2,016.56 ( 6,049.68) .0
2,016.56 ( 6,049.68) .0
2,243.32 ( 6,708.11) .0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 18
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
STREET LIGHT UTILITY FEE
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
225-43160-322 UTILITIES
.00
2,983.60
1,080.59 (
2,983.60) .0
TOTAL DEPARTMENT 160
.00
2,983.60
1,080.59 (
2,983.60) .0
TOTAL FUND EXPENDITURES
.00
2,983.60
1,080.59 (
2,983.60) .0
NET REVENUE OVER EXPENDITURES
.00
3,724.51
1,162.73 (
3,724.51) 0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 19
CITY OF OTSEGO
REVENUES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
DEVELOPMENT LOAN FUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
CHARGES FOR SERVICES
255-34110 APPLICATION FEE
TOTAL CHARGES FOR SERVICES
TOTAL FUND REVENUE
NET REVENUE OVER EXPENDITURES
.00 5,000.00 5,000.00 ( 5,000.00) .0
.00 5,000.00 5,000.00 ( 5,000.00) .0
.00 5,000.00 5,000.00 ( 5,000.00) .0
.00 5,000.00 5,000.00 ( 5,000.00) .0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 20
CITY OF OTSEGO
REVENUES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
WEST W&S DEBT SERVICE FUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
CHARGES FOR SERVICES
360-34406 WATER AVAILABILTY CHARGE .00 61,329.00 17,376.00 ( 61,329.00) .0
360-34407 SEWER AVAILABILITY CHARGE .00 215,754.50 58,897.50 ( 215,754.50) .0
TOTAL CHARGES FOR SERVICES .00 277,083.50 76,273.50 ( 277,083.50) .0
TOTAL FUND REVENUE .00 277,083.50 76,273.50 ( 277,083.50) .0
NET REVENUE OVER EXPENDITURES .00 277,083.50 76,273.50 ( 277,083.50) .0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 21
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
206 STREET IMPROVEMENT
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
DEBT SERVICE
380-47000-601 BOND PRINCIPAL
380-47000-602 BOND INTEREST
TOTAL DEBT SERVICE
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
.00 360,000.00
.00 72,432.50
.00 ( 360,000.00)
.00 ( 72,432.50)
.0
.0
.00 432,432.50
.00 ( 432,432.50)
.0
.00 432,432.50
.00 ( 432,432.50)
.0
.00 ( 432,432.50) .00 432,432.50 .0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 22
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
COLLECTOR ROADS FUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
STREETS
403-43100-302 ENGINEERING FEES
TOTALSTREETS
TOTAL FUND EXPENDITURES
NET REVENUE OVER EXPENDITURES
.00
656.13
656.13 (
656.13) .0
.00
656.13
656.13 (
656.13) .0
.00
656.13
656.13 (
656.13) .0
.00 (
656.13) (
656.13)
656.13 .0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 23
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
REVOLVING CAPITAL IMPROVEMENTS
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
PRAIRIE CENTER BUILDING
.00
66.75
66.75 (
66.75) .0
414-41940-525 BUILDING IMPROVEMENTS
.00
4,935.47
4,935.47 (
4,935.47) .0
TOTAL PRAIRIE CENTER BUILDING
.00
4,935.47
4,935.47 (
4,935.47) .0
CITY HALL/PW BUILDING
.00 (
11,597.22) (
11,597.22)
11,597.22 .0
414-41945-390 CONTRACTED SERVICES
.00
6,595.00
6,595.00 (
6,595.00) .0
TOTAL CITY HALL/PW BUILDING
.00
6,595.00
6,595.00 (
6,595.00) .0
414-43100-302 ENGINEERING FEES
.00
66.75
66.75 (
66.75) .0
TOTAL DEPARTMENT 100
.00
66.75
66.75 (
66.75) .0
TOTAL FUND EXPENDITURES
.00
11,597.22
11,597.22 (
11,597.22) .0
NET REVENUE OVER EXPENDITURES
.00 (
11,597.22) (
11,597.22)
11,597.22 .0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04 43P PAGE: 24
CITY OF OTSEGO
REVENUES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
WATER FUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 25
TAXES
601-31900
PENALTIES AND INTEREST
35,000.00
6,160.89
2,001.23
28,839.11
17.6
TOTAL TAXES
35,000.00
6,160.89
2,001.23
28,839.11
17.6
SALES
601-34109
OTHER ADMINISTRATIVE CHARGES
.00
1,125.00
225.00 (
1,125.00)
.0
601-34302
WATER METERS
68,000.00
17,608.87
7,108.17
50,391.13
25.9
TOTAL SALES
68,000.00
18,733.87
7,333.17
49,266.13
27.6
WATER REVENUES
601-37150
WATER SALES
1,052,500.00
175,180.90
57,520.68
877,319.10
16.6
TOTAL WATER REVENUES
1,052,500.00
175,180.90
57,520.68
877,319.10
16.6
OTHER PROPRIETARY FUND REVENUE
601-38990
OTHER MISCELLANEOUS
.00
416.05
.00 (
416.05)
.0
TOTAL OTHER PROPRIETARY FUND REVENUE
.00
416.05
.00 (
416.05)
.0
TOTAL FUND REVENUE
1,155,500.00
200,491.71
66,855.08
955,008.29
17.4
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 25
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
WATER FUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
WATER OPERATIONS
601-49400-101
FULL-TIME EMPLOYEES REGULAR
47,720.00
11,927.23
3,357.51
35,792.77
25.0
601-49400-102
WAGES - FT OVERTIME
1,100.00
864.69
71.51
235.31
78.6
601-49400-104
WAGES - PT EMPLOYEES
300.00
1,560.21
.00 (
1,260.21)
520.1
601-49400-121
PERA
3,662.00
2,125.09
697.98
1,536.91
58.0
601-49400-122
FICA AND MEDICARE
3,758.00
955.91
250.42
2,802.09
25.4
601-49400-123
HEALTH
8,679.00
3,197.05
1,011.77
5,481.95
36.8
601-49400-130
OTHER EMPLOYER PAID INS
.00
367.04
91.76 (
367.04)
.0
601-49400-150
WORKERS COMPENSATION
2,142.00
378.54
.00
1,763.46
17.7
601-49400-201
OFFICE SUPPLIES AND EXPENSES
10,000.00
2,083.83
620.86
7,916.17
20.8
601-49400-202
FUEL
6,833.00
.00
.00
6,833.00
.0
601-49400-206
POSTAGE
6,600.00
1,500.00
.00
5,100.00
22.7
601-49400-210
OPERATING SUPPLIES
107,110.00
26,480.86
22,396.50
80,629.14
24.7
601-49400-220
REPAIRS/MAINT SUPPLIES
14,820.00
4,113.74
.00
10,706.26
27.8
601-49400-225
UNIFORMS/CLOTHING ALLOWANCE
1,100.00
270.72
3.00
829.28
24.6
601-49400-227
SAFETY SUPPLIES
1,000.00
655.00
.00
345.00
65.5
601-49400-240
SMALL TOOLS/EQUIPMENT
500.00
.00
.00
500.00
.0
601-49400-298
W/S FLEET EXPENSES
2,600.00
4.19
.00
2,595.81
.2
601-49400-301
LEGAL SERVICES
500.00
.00
.00
500.00
.0
601-49400-302
ENGINEERING FEES
15,000.00
6,822.06
6,596.56
8,177.94
45.5
601-49400-303
PLANNING FEES
500.00
.00
.00
500.00
.0
601-49400-306
PERMITS & FEES
29,000.00
11,436.58
.00
17,563.42
39.4
601-49400-315
GIS SERVICES
3,000.00
.00
.00
3,000.00
.0
601-49400-320
TELEPHONE
2,301.00
862.68
297.82
1,438.32
37.5
601-49400-322
UTILITIES
57,000.00
14,194.33
7,108.88
42,805.67
24.9
601-49400-350
PRINT & PUBLISHING
300.00
.00
.00
300.00
.0
601-49400-355
DUES & MEMBERSHIPS
340.00
68.33
.00
271.67
20.1
601-49400-360
EDUCATIONITRAINING/CONFERENCES
2,859.00
823.19
.00
2,035.81
28.8
601-49400-361
LIABILITY AND PROPERTY INSURAN
.00
4,408.46
.00 (
4,408.46)
.0
601-49400-390
CONTRACTED SERVICES
58,600.00
2,636.61
2,482.23
55,963.39
4.5
601-49400-420
DEPRECIATION
502,200.00
.00
.00
502,200.00
.0
601-49400-602
BOND INTEREST
424,914.00
.00
.00
424,914.00
.0
601-49400-720
OPERATING TRANSFERS
56,638.00
.00
.00
56,638.00
.0
TOTAL WATER OPERATIONS
1,371,076.00
97,736.34
44,986.80
1,273,339.66
7.1
TOTAL FUND EXPENDITURES
1,371,076.00
97,736.34
44,986.80
1,273,339.66
7.1
NET REVENUE OVER EXPENDITURES
( 215,576.00) 102,755.37 21,868.28 ( 318,331.37) 47.7
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 26
TAXES
602-31900 PENALTIES AND INTEREST
TOTAL TAXES
CHARGES FOR SERVICES
602-34000 CHARGES FOR SERVICES
TOTAL CHARGES FOR SERVICES
SEWER REVENUES
602-37200 SEWER SALES
TOTAL SEWER REVENUES
TOTAL FUND REVENUE
CITY OF OTSEGO
REVENUES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
SEWER FUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
40,000.00 10,905.05 3,637.32 29,094.95 27.3
40,000.00 10,905.05 3,637.32 29,094.95 27.3
7,000.00 4,128.96 1,032.24 2,871.04 59.0
7,000.00 4,128.96 1,032.24 2,871.04 59.0
1,240,995.00
330,987.08
113,869.54
910,007.92
26.7
1,240,995.00
330,987.08
113,869.54
910,007.92
26.7
1,287,995.00
346,021.09
118,539.10
941,973.91
26.9
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:43PM PAGE: 27
CITY OF OTSEGO
EXPENDITURES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
SEWER FUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
SEWER OPERATIONS
602-49450-101
FULL-TIME EMPLOYEES REGULAR
143,161.00
32,595.59
19,025.77
110,565.41
22.8
602-49450-102
WAGES - FT OVERTIME
3,300.00
1,518.48
405.15
1,781.52
46.0
602-49450-104
WAGES - PT EMPOYEES
1,350.00
1,560.21
.00 (
210.21)
115.6
602-49450-121
PERA
10,985.00
2,125.09
697.98
8,859.91
19.4
602-49450-122
FICA AND MEDICARE
12,914.00
2,911.91
1,419.02
10,002.09
22.6
602-49450-123
HEALTH
26,038.00
2,873.54
1,011.76
23,164.46
11.0
602-49450-130
OTHER EMPLOYER PAID INS
.00
367.03
91.76 (
367.03)
.0
602-49450-150
WORKERS COMPENSATION
7,360.00
2,145.00
.00
5,215.00
29.1
602-49450-201
OFFICE SUPPLIES AND EXPENSES
8,000.00
2,083.54
620.56
5,916.46
26.0
602-49450-202
FUEL
6,833.00
.00
.00
6,833.00
.0
602-49450-206
POSTAGE
6,600.00
1,504.65
.00
5,095.35
22.8
602-49450-210
OPERATING SUPPLIES
43,337.00
7,999.30
3,385.62
35,337.70
18.5
602-49450-220
REPAIRS/MAINT SUPPLIES
80,700.00
6,259.51
492.27
74,440.49
7.8
602-49450-225
UNIFORMS/CLOTHING ALLOWANCE
1,250.00
270.71
3.00
979.29
21.7
602-49450-227
SAFETY SUPPLIES
1,000.00
128.06
29.28
871.94
12.8
602-49450-240
SMALL TOOLS/EQUIPMENT
500.00
169.81
84.81
330.19
34.0
602-49450-298
W/S FLEET EXPENSES
2,600.00
.00
.00
2,600.00
.0
602-49450-301
LEGAL SERVICES
1,000.00
.00
.00
1,000.00
.0
602-49450-302
ENGINEERING FEES
10,000.00
3,380.98
102.38
6,619.02
33.8
602-49450-303
PLANNING FEES
1,000.00
.00
.00
1,000.00
.0
602-49450-306
PERMIT & FEES
7,700.00
7,350.00
7,350.00
350.00
95.5
602-49450-315
GIS SERVICES
4,000.00
.00
.00
4,000.00
.0
602-49450-320
TELEPHONE
2,301.00
862.64
297.79
1,438.36
37.5
602-49450-322
UTILITIES
160,000.00
36,540.13
13,959.04
123,459.87
22.8
602-49450-325
GARBAGE SERVICE
6,851.00
1,826.78
1,227.10
5,024.22
26.7
602-49450-350
PRINT & PUBLISHING
200.00
.00
.00
200.00
.0
602-49450-355
DUES & MEMBERSHIPS
340.00
83.33
.00
256.67
24.5
602-49450-360
EDUCATION/TRAINING/CONFERENCES
2,859.00
1,002.15
.00
1,856.85
35.1
602-49450-361
LIABILITY AND PROPERTY INSURAN
.00
14,495.59
.00 (
14,495.59)
.0
602-49450-390
CONTRACTED SERVICES
83,714.00
17,603.21
7,876.98
66,110.79
21.0
602-49450-419
SLUDGE HAULING
60,000.00
.00
.00
60,000.00
.0
602-49450-420
DEPRECIATION
860,117.00
.00
.00
860,117.00
.0
602-49450-610
BOND INTEREST
755,400.00
.00
.00
755,400.00
.0
602-49450-720
OPERATING TRANSFERS
56,638.00
.00
.00
56,638.00
.0
TOTAL SEWER OPERATIONS
2,368,048.00
147,657.24
58,080.27
2,220,390.76
6.2
TOTAL FUND EXPENDITURES
2,368,048.00
147,657.24
58,080.27
2,220,390.76
6.2
NET REVENUE OVER EXPENDITURES ( 1,080,053.00) 198,363.85 60,458.83 ( 1,278,416.85) 18.4
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:44PM PAGE: 28
CITY OF OTSEGO
REVENUES WITH COMPARISON TO BUDGET
FOR THE 3 MONTHS ENDING MARCH 31, 2015
BUILDERS ESCROW FUND
BUDGET YTD ACTUAL PERIOD ACTUAL UNEXPENDED PCNT
OTHER REVENUE
702-38090 ESCROW DEPOSIT
TOTAL OTHER REVENUE
TOTAL FUND REVENUE
NET REVENUE OVER EXPENDITURES
.00 60,000.00 17,500.00 ( 60,000.00) .0
.00 60,000.00 17,500.00 ( 60,000.00) .0
.00 60,000.00 17,500.00 ( 60,000.00) .0
.00 60,000.00 17,500.00 ( 60,000.00) .0
FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 05/21/2015 04:44PM PAGE: 29