HomeMy WebLinkAbout8A - Proposed 2011 City Budgets and Property Tax LevysPRIO�
U
4646 Dakota Street SE
\ '- ' 1 VNESO, V Prior Lake, MN 55372
CITY COUNCIL AGENDA REPORT
MEETING DATE: DECEMBER 6, 2010
AGENDA #: 8A
PREPARED BY: FRANK BOYLES, CITY MANAGER
JERILYN ERICKSON, FINANCE DIRECTOR
PRESENTER: FRANK BOYLES
AGENDA ITEM: PUBLIC HEARING FOR PROPOSED 2011 CITY BUDGETS AND
PROPERTY TAX LEVIES
DISCUSSION: Introduction
The 2009 Legislature made some significant changes to the Truth in
Taxation (TNT) process for 2010 and beyond. At the September 7, 2010
meeting during which the City Council adopted a proposed 2011 budget and
tax levy, the Council was required to announce the time and place of the
council meeting at which the 2011 budget and levy would be discussed and
which would allow for citizen input. It was announced and included in the
meeting minutes that a public hearing on the proposed 2011 budget would
take place on Monday, December 6, 2010 at 6:00 pm.
The requirement for publishing a TNT notice was repealed. In lieu of
publication, the announcement of the time and place of the public hearing
was required. Of course, each Truth in Taxation notice received by City
residents also includes the time, date and location of the truth in taxation
hearing.
The Truth in Taxation notice received by each resident reflects the estimated
2011 property taxes based on the proposed property tax levy that was
adopted on September 7, 2010. The Council may consider a final tax levy
either at the same amount adopted in September or a lesser amount; the
property tax levy cannot be increased. Therefore, the TNT notice reflects the
maximum property tax impact for each property owner.
The purpose for the public hearing tonight is to provide information to the
public regarding the City's proposed 2011 operating budgets and the amount
of property taxes that the City proposes to collect in 2011. Also, it is
important to give the residents the opportunity to express their opinions on
the budget and those services that are important to them. A PowerPoint
presentation will be provided and the City Council will have an opportunity to
ask questions, after which the Truth -in- Taxation hearing should be opened.
Any written comments submitted prior to the hearing are to be entered into
the official record. Staff will provide a presentation with respect to the
proposed 2011 budgets for the General Fund, Debt Service Funds,
Equipment Revolving Fund, Water Fund, Sewer Fund, Water Quality Fund,
and the Transit Fund that were adopted by the City Council on September 7,
2010.
If all public comments and concerns cannot be addressed tonight, the public
hearing could be continued until 6:00 p.m. Monday, December 20, 2010.
The final budgets and property tax levy would then be considered for
approval by the City Council at its regularly scheduled meeting on Monday,
December 20, 2010. By Minnesota Statute the final property tax levy amount
must be certified to the Scott County Auditor's Office no later than 5 working
days after December 20 (December 28, 2010).
Included with this agenda report are updated proposed budget reports.
These reports reflect the changes recommended by the City Council from the
November 1, 2010 workshop and some additional changes recommended by
staff.
ALTERNATIVES: The following alternatives are available to the City Council:
1. If all questions have been answered, close the public hearing and
direct the Staff to place this item on the December 20, 2010 City
Council agenda for final action.
2. Continue the public hearing until December 20, 2010 at 6:00 p.m. if
there are questions that cannot be answered on December 6.
RECOMMENDED Motion to either close the public hearing or continue the hearing to 6:00 P.M.,
MOTION: Monday December 20, 2010. If the hearing is adjourned then the date, time
and place for the levy and budget adoption meeting (Monday 6:00 p.m.
,December 20, 2010) must be announced.
Re 'e ed
Frank Bo es, Manager
O
N
O
N
Of
C
z
d
m
wry
J
r
0 LL
a` L m
c a rn
r 3
V N m
y ,�ICfi
0 0
h
W�
't•LIJ
00 aOM Lo
v
V M O V 0v0000 CA
M
F
'O
fD CO N O O tO N M CO N
r`
r.- 't 0 0 h 0 0 00 O O t0 O O
n
Cn
y
P- C Or000 OCON OOM
el'
OCA 000 O x 000 ' OM
0
st
rte+
y'C
000Gov NO 00 vM McoO
coOvvN 000000M 000
N
Im
OOOI- CAM ONN h
to
V OMN N MO0000 rl CM
O
CA
C
OrvMNr CA CO Cl) P- f- m
Cl)
It 00 CA CTr Mr r- Nr
N
00
3 L
Or r(Q r
N
oO CO r C6 r fit`
N
N
m
(fl
fA
EA Efl to ff3
69
64
CO co O
CD
O O O O O d' CA O M
0)
m
C)
m
0 0 0 0 C.
r
V N O 1- 0 0 0 0 0 M
O
N
U)
Oc r C
O
c N O O O O r C ap
CA
W
y
• p,
f`stO
N
v It v v OOOOO 00
C8, M co CO O 00
N
a)
O
00
C
N
W
CA
A Cl) O
O
O
Ha 0
C LL
O
O
rM rf` r
O
N
w
Cf3
CA
EA Ci9 H9 CA
-
CA
DO °O
�
n
=
coo
co O C
c oo
ao
Lo D O �
ao to v
v
O
H D
OOO
O
LO C) CO
CO
O
c c
L
CD 0 r
O
n
to
a) 00 n
CD r-
r-
r`
O
LL
ea
En
is 64 v> rfl
69
va
O O O
O
n N 0 0 O
0
O
O q
O
C v_ q v
v_
v
O
M
co
CY O
I
LO
N- O m
m
L
of LL
N
3
6-1
6r� t, to
61,
to
0 0
O
0 IT 0 0 v O N O N
C O
C O
00
O
CA 00001- ON O N
0)
0
N C '
N
M 00 O O Cl O W ' O ' ' ' ' M
O
_
m C
7
O) O
(D C)i
rfl C O M 04 C 0) C0O M
LCI
D
D
N LL
N
r
r N
69
Cfl
CA CA to b9
ff!
to
000
00
NN O V ONOO r
O
r
Cl) p i i i
Cr
C M' O M CA_ t ONO � O ' ' ' i O
4
COO
N O
N
O O 0 h tV 00 O 00
O
n
m y
c
00
O
r-
CO rnrn c2 rnm0 r-
O r O h v n
n
O
ao
3 '
LL
N
N
r r N
M
VJ
CA
60 EA CA Cfl
ca
fR
NN v00 DONCl) OrN
O
000 sr' 00 fD
O
O
CO CD NO O r-CM 0) CO N
O
NNO O C) co O(O
P-
n
C
hMOrGpO COIN OOM
f�r 0 ' Cn ' OLc) ' OCn
' ' '
O
(q
q y
00OCDv NC) C70M MOO CD
M
CD O a0 OM 00
O
O
O O O f- CA M CO 0 r-
V
O O N O r�
CO
C£ C
OrvMNr M V N r�r-M
It
WN0) _ h NO
r
rz
ai r r r r
CD
Cp M r er CO
n
LL
r
O
to
69
Cf) EH Cfl to
6s
W
M ' 0 0
M
i n
0 V
co
E C
COO V)
N
C)
O 0. 7
O CD
CO
N
> 7 LL
Q
w
CH
CR
ER to Cf) C%
609
6s
O
N
d
O
0 t O O
r�
' ' ' ' ' ' ' ' ' ' O O
C
O M M r` O 0
CA
N N
N
M
at LL
r r
M
IT
N
fA
ff3
to CA d9 Efl
(fl
to
OO wNO CD CD
O
OC70O 00 C) LO O
M
M
CO tO N O 1- M O O O
M
N N CA v O O CO
CO
Comm) ' 000 C0�0 ' 00
M
h1�N ' r ' ' 00 ' ' Cn
M
O
m C
O00 NO O O O r r
W O O M M W O O
N
N
CO CO V O M M
0 N N O t0
co
00
O
O
C 7
LO Nr Mvr rr
r
C) 't n
r
LL
r r r r
N
-N
C O co O r r
EA
b9
d9 Efl to N3
ER
E9
N
y y
N
U
fA �. c
y
m
d
c
y
�
y
�.
C
ti
C
>
C N C y
C
CU
•V 7 LL
N
y 'O LL C
c
x
LLI
y
M C Q1 L_ -p
d w 'O m N 7 N LL
t
y
O
y y
7 y C y C d N LL 7
~
_ 'O N L_ lL C C 7-
y txp r
Q a) •N a)
O
tp
d y
N
U) N H w t) � E LL LL
x and E c T
y N N 0 0 N C CJ N
- �� E E CD
ww
~ 4 a jQ wLL N a �' ( D 3
a d i 0 (D a r Ma y Z
>
C �JJ� CO >C�
C CA
O
typ y O7m� H�
C y :6 .@. y �� H wdO
o o c w? , A
x E :3ccccc 0(D
a>i
of a fnJLL �UOF -
w wUUU H Uo
J
K
d
Q.
V
CL
ca
E
CL
r
O
N
Cl) O
M o
0
coM
(Do
CD o
O
nN
00
ODM
'G
N
MI
H
0�
000
G1 0
N�
O7
a , a
NO
I- CD
LL
LO
CD O
=
LO
N
M
�a
0
y
N
�
0c0
v
N N
0 L
(Cj0
O
MO.- On
OO OVi
(OM
d'0
0(A
C
m
N
M
U
m
N
C
m LL
o
M N
3
N Lo
M co
. �C
O 1!
CA
•�
CV
CO (DN
'-t
o
(C)O Or-
Mr
0c0
Q
C
C14 'r l
0c0
M
O�
or`
0�
0)
F �LL
Co
00n
O�
LL
N
co
0
O
w
CA
W
N N
W
00
00
J
K
d
Q.
V
CL
ca
E
CL
r
O
N
0
N
a
0 0 r 0
C 0
0
coM
OR W n O
O 0
O
NCO
W V MM
ODM
�(O
y o
O N -It (M
O —
O
r
c
Lo
n v
n
r V
C
to C?
v
LL
- nr
� LL
�a
m
° vcn
0c0
C
(0000
M00
MO.- On
OO OVi
(OM
d'0
C
co O
00 2
sP
M
U
V
N
C
m LL
Q
3
Ef? Efl
fA
CA
n 0OON
(D C, CD
CV
CO (DN
'-t
o
(C)O Or-
Mr
0c0
nM
0c0
M
3=
(oN(nl.o
0)
3 c
a
(A CO�NO
N U
N
co
0
O
EA 60).
CA
W
N N
(MO�On
00
00
O o
O O O
O O n Cl
co 0
N M
O o
C
O O 06 C
-w
W
O
N00000
COn
V ccc
N
C (D — N
M 0
0
n —7
o 11
O
(»
N c
3 LL
LO co
M N
-
c
_ 3 LL
v
c
�
U
LL
J
O
0
m c
�
o
LL
H
LL
•
G N
vo
CM CO
no
N
C
CL
o
(Q U(
d
>
LL '
�
CO CO
C
a
c c c Ill
>
) > >._
Cv
Q. E'
a
(
x
p
c ca>
N
O
as
F
a) a) a) N
O
w O
y
J
J
O
a
c
0
N
a
co M
0o
coM
In o
r
O n
NCO
O n
�(O
y o
v
C
r
c
Lo
n v
n
co C?
m
C
to C?
v
LL
- nr
� LL
° vcn
0c0
It ccn
O c
Cli CN
O V O
CY CN
�0
m LL
m LL
3
3
cnc
�co
o
�00
0c0
nM
0c0
M
3=
c 't
0)
3 c
a
rn M
N U
LL
cq
N N
�m
N N
O O
O o
O O
O o
LqO
V ccc
WiO
c
I
N
M N
N c
3 LL
LO co
M N
-
c
_ 3 LL
L co
M N
C
3
LL
•
O(O
vo
CM CO
no
o
(Q U(
d
Mini
CO CO
C
C
E 9( 0 DN
Cv
Q. E'
a
(
~ m LL
N
O
� m LL
N N
O
w O
0
m c�
c
C
r
r-
O
O pl C
0 0 .
C
> E '°
rn
a)
d £ y
o
0 O. C
CO
CD
M
> 7 LL
c > 7 LL
W
W
v
0
d
0
m
C)
O
O
O CD
O O
N m
v
O
O
2 0
C
w o
r
Z V)
o
N
N
y C
y C
LL.
a LL
Cl) (D
n o
f.7
(M CD
n o
M
� LO
K
M
r- LO
io
' m C
000_
(D
r- r.. m C
0 N_
(
c LL
N N
CO LL
N N
i
I
N
L
cc
{
CL
E
co fn
a) a)
O
a) a)
d
1m
e d
i
7
V
7 7
C C
N N
m
C C
O O
N N
j
n a)
o o
o o
Cp
n
L� ul
o 0
o 0
N N
CC
C
O O
N CD a
04
00
I-1-
rn�
wo
C C
N N
U U
V-
N N
U U
r
1
O
1
N
0
N
a
O
N
tz
O
C
I
d
m =
3
J9 Z' LL
J d
O E
• L Ql
a
oam
r O
V N Z
10
m i
Of to
C
7 �
m LL
C
O
Z
N N E Cn 0 V o m 0 N
'a
It 0 (D of O et Q1 0 C) Lo O
M
Q1
a
CO CON OCO NM w N
t`
t vU)O C� 0 00000 00
r
O
C v
w C
P Cl) CC) W OU70N V) Cl)
O
0
U o 00(C) 00 at . 0 ' OM
O)
C7
0
y
000NO CD --t Cl) Cl) 00o
004vN (f)(C)00 o o Cl) Coo
N
CO
m
CL
CL
00 LOa)Cl) Cn NN Oh
f9
fMN N MOto c) V) r'. c)
(3) 0 M- V � h N-
N
0
O C
O - vN - M CDM Ih I-M
O O
��
N
7
LL
(3) c- CO
N
0 f0 - 0 r
N
w
Cn
fp
ffl
N9 Cfl 69 fig
69
U)
(D
64
w
NNQ(O Ov o 0 N
v
V a) C) It O.70o0 C0 O
M
H •p LL
w � C � C
Qi
000N OCO N (3) (D N
h
1 I�r(00 C- Ov0OO CO 00
r-
x
w
M
y
t`M LQ O0 CDN Vf (I
V
CC)0o0 U7 0(q -00 ' OM
c'
V
H
00 CC) 0 N O W V M M W O
N lA d: ` O � E LL
Z
0 0�'t N 0 0 co CD O M co O
N
a)
0 H = od o E w j c
�a )
m•p
OO LO Mv0NN n
0
-TCMN N CM CO 00(n C.M
N
LO
N
4) m m >
OJJ� 6
�� Ch
M
00
C
Ct C4 O) O M C I- Cl)
M
X 00 0) cn
c E1
> a a) (D m L C
m o �c s
a a` a'a c a
x E�mm 2 oa)
-CO r
N
00 CD X00 V P-
N
W W UUU H U�
N
LL
m
V9
H9
6a f19 fA 69
fA
to
m i
Of to
C
7 �
m LL
C
O
Z
O
i i i i i p i
LO
Cfl
O
p
CD
0
E19
i i i i i i i i i
ff) f!9 69 V9
V3
O
0
O
(D
Ei9
a
o
i i i i i
0 0
0
CD
C v
w C
O
Cn
O
0
C7
0
LL
� LL
m
CL
CL
f9
fA W fr> 69
W!>
69
E
7
O O
w
N
to
C
7
j
�
w
Cn
a)
a) N
U)
(D
O
w
o
cc
7 LL
a)
H •p LL
w � C � C
N
m
a> 0) a�
_ a) t
Ua) y
a
m
d y wv mid
E
x
w
c
o
m(' Oova
O N X N D C N N LL C 7
p
0) $? E m> 8ZELL
.0 N L LL. C C '= C
O
LL
C
+ y,.
� XH L)CL EU m o @ LL L
LL
~
N lA d: ` O � E LL
Z
~
a)
0 H = od o E w j c
�a )
w a) j O c c m '� -�
> O �0mdcma)�a
m
_
4) m m >
OJJ� 6
�� Ch
N O N•.m -•.m -• ( W d � CU)
U
c E1
> a a) (D m L C
m o �c s
a a` a'a c a
x E�mm 2 oa)
d JLL. cUGH
W W UUU H U�
L
M
to
w
x Ui
a7 L
a)
U
w O
O �
h
y G
'
G ~
N �
O)
a >
°c w
.3 3
� o
t h
m
C G
e
0
M
h O
O
ac
Q)
0 p ' u O�P City of Prior Lake TNT Hearing 12.06.2010
ti 2011 Preliminary Budget
Revenue Summary
"'�nres�
2010 2011
2010 2011 $ Change % Change % of % of
General Fund Adopted Requested 10-11 10-11 Total Total
Taxes 8,482,856 8,428,405 (54,451) -0.64% 69.99% 69.53%
Licenses and permits 269,975 292,815 22,840 8.46% 2.23% 2.42%
Intergovernmental 1,327,667 1,310,678 (16,989) -1.28% 10.95% 10.81%
Charges for services 1,382,131 1,480,432 98,301 7.11% 11.40% 12.21%
Fines and forfeitures 182,000 130,000 (52,000) - 28.57% 1.50% 1.07%
Interest on investments 90,000 90,000 0 0.00% 0.74% 0.74%
Other 60,917 55,000 (5,917) -9.71% 0.50% 0.45%
Transfers from other funds 325,000 335,000 10,000 3.08% 2.68% 2.76%
Total General Fund 12,120,546 12,122,330 1,784 0.01% 100.00% 100.00%
Debt Service Funds
Taxes - 1,157,195 1,157,195 n/a n/a 29.44%
Special assessments - 374,184 374,184 n/a n/a 9.52%
Interest on investments - 31,945 31,945 n/a n/a 0.81%
Transfers from other funds - 2,367,398 2,367,398 n/a n/a 60.23%
Total Debt Service Funds - 3,930,722 3,930,722 n/a n/a 100.00%
Revolving Equipment Fund
Taxes - 270,000 270,000 n/a n/a 68.12%
Interest on investments - 26,348 26,348 n/a n/a 6.65%
Transfers from other funds - 100,000 100,000 n/a n/a 25.23%
Total Revolving Equipment Fund - 396,348 396,348 n/a n/a 100.00%
Water Fund
Charges for services - water 2,702,938 2,702,938 0 0.00% 98.18% 98.18%
Interest on investments 50,000 50,000 0 0.00% 1.82% 1.82%
Total Water Fund 2,752,938 2,752,938 0 0.00% 100.00% 100.00%
Sewer Fund
Charges for services - sewer 1,916,250 1,916,250 0 0.00% 97.46% 97.46%
Interest on investments 50,000 50,000 0 0.00% 2.54% 2.54%
Total Sewer Fund 1,966,250 1,966,250 0 0.00% 100.00% 100.00%
Water Quality Fund
Charges for services - storm water 425,000 425,000 0 0.00% 100.00% 81.42%
Intergovernmental revenues - 87,000 87,000 n/a 0.00% 16.67%
Interest on investments - 10,000 10,000 n/a 0.00% 1.92%
Total Water Qualitv Fund 425,000 522,000 97,000 22.82% 100.00% 100.00%
Transit Fund
Charges for services - transit revenue 534,661
660,886
126,225
23.61% 100.00% 98.51%
Interest on investments -
10,000
10,000
n/a 0.00% 1.49%
Total Transit Fund 534,661
670,886
136,225
25.48% 100.00% 100.00%
GRAND TOTAL 17,799,395
22,361,474
4,562,079
25.63%
Page 1 of 20
p4 P WpP
City of Prior Lake
TNT Hearing 12.06.2010
D� 2011 Preliminary Budget
11,905
-
0.00%
0.90%
0.91%
33416 State aid - police training
8,855
Revenue Details
(609)
-6.88%
0.67%
0.63%
33418 State road & bridge aid
230,000
230,000
�+Mnsot�
0.00%
17.32%
17.55%
33420 State fire aid - ins premium
123,000
123,000
-
0.00%
9.26%
9.38%
33421 State police aid - ins premium
155,000
2010
2011
2010 2011
11.67%
2010
2011
$ Change
% Change
% of
% of
% of % of
0.00%
Adopted
Proposed
10-11
10-11
Subtotal
Subtotal
Total Total
General Fund
54,042
40,535
(13,507)
- 24.99%
4.07%
3.09%
33631 Payment in lieu of taxes
Property taxes
380,000
-
0.00%
28.62%
28.99%
33700 Miscellaneous grants
3,000
31010 Current taxes
7,952,993
7,929,520
(23,473)
-0.30%
93.75%
94.08%
1 310 678
31012 Market value credit aid
(227,546)
(258,524)
(30,978)
13.61%
- 2.68%
-3.07%
31040 Fiscal disparities
757,409
757
-
0.00%
8.93%
8.99%
34760 Facility rental
8,482,856
8 428 405
(54
-0.64%
100.00%
100.00%
69.99% 69.53%
Licenses & permits
15,000
15,000
0.00%
1.09%
1.01%
32100 Business licenses
1,300
900
(400)
- 30.77%
0.48%
0.31%
32110 Liquor licenses
57,000
57,000
-
0.00%
21.11%
19.47%
32160 Refuse haulers
3,875
3,875
-
0.00%
1.44%
1.32%
32161 Plumbing registrations
875
875
-
0.00%
0.32%
0.30%
11.40% 12.21%
32170 Outdoor concert permits
1,100
1,100
-
0.00%
0.41%
0.38%
32180 Cigarette licenses
3,250
3,250
-
0.00%
1.20%
1.11%
32210 Building permits
166,750
187,000
20,250
12.14%
61.76%
63.86%
32215 Mechanical permits
14,900
16,395
1,495
10.03%
5.52%
5.60%
1.50% 1.07%
32230 Plumbing permits
12,425
13,920
1,495
12.03%
4.60%
4.75%
32231 Sewer/water inspection
2,500
2,500
-
0.00%
0.93%
0.85%
32240 Animal licenses
3,750
3,750
-
0.00%
1.39%
1.28%
32260 Burning permits
2
2,250
-
0.00%
0.83%
0.77%
269
292,815
22
8.46%
100.00%
100.00%
2.23% 2.42%
Intergovernmental revenue
33401 Local government aid
11,905
11,905
-
0.00%
0.90%
0.91%
33416 State aid - police training
8,855
8,246
(609)
-6.88%
0.67%
0.63%
33418 State road & bridge aid
230,000
230,000
-
0.00%
17.32%
17.55%
33420 State fire aid - ins premium
123,000
123,000
-
0.00%
9.26%
9.38%
33421 State police aid - ins premium
155,000
155,000
-
0.00%
11.67%
11.83%
33610 County /city aids & grants
13,800
-
(13,800)
- 100.00%
1.04%
0.00%
33620 Township fire & rescue aid
348,065
361,992
13,927
4.00%
26.22%
27.62%
33621 Liaison aid
54,042
40,535
(13,507)
- 24.99%
4.07%
3.09%
33631 Payment in lieu of taxes
380,000
380,000
-
0.00%
28.62%
28.99%
33700 Miscellaneous grants
3,000
-
(3,000)
-100.00%
0.23%
0.00%
2.03%
1,327,667
1 310 678
(16,989)
-1.28%
100.00%
100.00% 10.95% 10.81%
Charges for services
34103 Zoning & subdivision fees
7,810
7,810
-
0.00%
0.57%
0.53%
34104 Plan check fees
83,250
96,350
13,100
15.74%
6.02%
6.51%
34105 Sale of maps /publications
2,500
2,500
-
0.00%
0.18%
0.17%
34107 Assessment searches
400
400
-
0.00%
0.03%
0.03%
34109 Project admin /eng fees
348,553
376,000
27,447
7.87%
25.22%
25.40%
34203 Accident/warrant reports
300
300
-
0.00%
0.02%
0.02%
34303 Franchise fees
537,000
540,000
3,000
0.56%
38.85%
36.48%
34304 PEG access fees
36,000
36,000
-
0.00%
2.60%
2.43%
34731 Softball fees
28,000
28,000
-
0.00%
2.03%
1.89%
34735 Recreation program fees
56,000
56,000
-
0.00%
4.05%
3.78%
34740 Beach concessions
13,000
13,000
-
0.00%
0.94%
0.88%
34760 Facility rental
68,166
63,667
(4,499)
-6.60%
4.93%
4.30%
34761 Studio /pavilion rental
15,000
15,000
0.00%
1.09%
1.01%
34762 Park shelter rental
7,000
7,000
-
0.00%
0.51%
0.47%
34765 Tower leases
150,152
209,405
59,253
39.46%
10.86%
14.14%
34780 Park admission fees
29,000
29,000
-
0.00%
2.10%
1.96%
1,382,131
1,480432
98
7.11%
100.00%
100.00%
11.40% 12.21%
Fines & forfeitures
35101 County court fines
115,000
85,000
(30,000)
- 26.09%
63.19%
65.38%
35104 Prosecution restitution
67,000
45,000
(22,000)
- 32.84%
36.81%
34.62%
182,000
130
(52,000)
- 28.57%
100.00%
100.00%
1.50% 1.07%
Miscellaneous revenues
36210 Interest earnings
90,000
90,000
-
0.00%
62.07%
62.07%
36212 Miscellaneous revenue
30,000
30,000
-
0.00%
20.69%
20.69%
36230 Contributions & donations
25
25,000
-
0.00%
17.24%
17.24%
145
145,000
-
0.00%
100.00%
100.00%
1.20% 1.20%
Other financing sources
39102 Sale of property
5,917
-
(5,917)
- 100.00%
1.79%
0.00%
39203 Transfers from other funds
325,000
335
10,000
3.08%
98.21%
100.00%
330
335
4,083
1.23%
100.00%
100.00%
2.73% 2.76%
GENERAL FUND TOTAL
12 120,546
12,122,330
1,784
0.01%
100.00%
100.00%
100.00% 100.00%
Page 2 of 20
pQ YR1pA
City of Prior Lake
270,000
2011 Pre liminary Budget
n/a
Revenue Details
h �NN¢SO t �
450,000
DEBT SERVICE FUNDS
Property taxes
31010 Current taxes
Miscellaneous revenues
36210 Interest earnings
Other financing sources
36102 Special Assessments
39203 Transfers from other funds
TNT Hearing 12.06.2010
2010 2011 2010 2011
2010 2011 $ Change % Change % of % of % of % of
Adopted Proposed 10-11 10-11 Subtotal Subtotal Total Total
1.157,195 1,157,195 n/a n/a 100.00%
1,157,195 1,157,195 n/a n/a 100.00% n/a 29.44%
31,945 31,945 n/a n/a 100.00%
31,945 31,945 n/a n/a 100.00% n/a 0.81%
374,184 374,184 n/a n/a 13.65%
2 2,367 n/a n/a 86.35%
2,741,582 2,741.582 n/a n/a 100.00% n/a 69.75%
DEBT SERVICE FUNDS TOTAL 3,930,722 3,930,722 n/a n/a 100.00% n/a 100.00%
EQUIPMENT REVOLVING FUND
Property taxes
31010 Current taxes
270,000
270,000
n/a
n/a
100.00%
37110 Capital facility revenue
450,000
450,000.00
270,000
270
n/a
n/a
100.00%
n/a
68.12%
Miscellaneous revenues
0.33%
37160 Penalties
70,963
70,963.00
0.00%
2.63%
2.63%
36210 Interest earnings
26,348
26,348
n/a
n/a
100.00%
37175 Pressure reducers
8,225
8
26,348
26,348
n/a
n/a
100.00%
n/a
6.65%
Other financing sources
100.00% 98.18% 98.18%
Miscellaneous revenues
39203 Transfers from other funds
100,000
100,000
n/a
n/a
100.00%
50,000
50,000
100
100
n/a
n/a
100.00%
n/a
25.23%
EQUIPMENT REVOLVING FUND TOTAL
396,348
396,348
n/a
n/a
100.00%
n/a
100.00%
WATER FUND
Charges for services
37100 Water utility revenue
2,138,750
2,138,750
0.00%
79.13%
79.13%
37110 Capital facility revenue
450,000
450,000.00
0.00%
16.65%
16.65%
37150 Disconnect charges
9,000
9,000.00
0.00%
0.33%
0.33%
37160 Penalties
70,963
70,963.00
0.00%
2.63%
2.63%
37170 Water meters
26,000
26,000.00
0.00%
0.96%
0.96%
37175 Pressure reducers
8,225
8
0.00%
0.30%
0.30%
2,702,938
2,702,938
0.00%
100.00%
100.00% 98.18% 98.18%
Miscellaneous revenues
36210 Interest earnings
50,000
50,000
0.00%
100.00%
100.00%
50,000
50,000
0.00%
100.00%
100.00% 1.82% 1.82%
WATER FUND TOTAL
2,752,938
2,752,938
0.00%
100.00%
100.00% 100.00% 100.00%
SEWER FUND
Charges for services
37102 City sewer utility revenue 997,500 997,500 0.00% 52.05% 52.05%
37104 Met council sewer utility revenue 918,750 918 0.00% 47.95% 47.95%
1 1,916.250 0.00% 100.00% 100.00% 97.46% 97.46%
Miscellaneous revenues
36210 Interest earnings 50 50 0.00% 100.00% 100.00%
50,000 50,000 0.00% 100.00% 100.00% 2.54% 2.54%
SEWER FUND TOTAL 1,966,250 1,966,250 0.00% 100.00% 100.00% 100.00% 100.00%
Page 3 of 20
04 rxtoR
City of Prior Lake
D 2011 Preliminary Budget
Revenue Details
4 �NNH5��
WATER QUALITY FUND
Charges for services
37120 Storm water revenue
Intergovernmental revenue
XXXXX Grant revenue
Miscellaneous revenues
36210 Interest earnings
TNT Hearing 12.06.2010
2010 2011 2010 2011
2010 2011 $ Change % Change % of % of % of % of
Adopted Proposed 10-11 10-11 Subtotal Sub total Total Total
425,000 425 0.00% 100.00% 100.00%
425,000 425 0.00% 100.00% 100.00% 100.00% 81.42%
87 87,000 n/a n/a 100.00%
87 87,000 n/a n/a 100.00% 0.00% 16.67%
10 10,000 n/a n/a 100.00%
10,000 10 n/a n/a 100.00% 0.00% 1.92%
WATER QUALITY FUND TOTAL 425,000 522,000 97,000 22.82% 100.00% 100.00% 100.00% 100.00%
TRANSIT FUND
Intergovernmental revenue
38422 State transit aid
444,661
560
116,225
26.14%
100.00%
100.00%
444,661
560,886
116,225
26.14%
100.00%
100.00%
83.17%
83.60%
Charges for services
38400 Bus fares
90
100,000
10
11.11%
100.00%
100.00%
90,000
100
10
11.11%
100.00%
100.00%
16.83%
14.91%
Miscellaneous revenues
36210 Interest earnings
-
10,000
10,000
n/a
n/a
100.00%
10,000
10,000
n/a
n/a
100.00%
0.00%
1.49%
TRANSIT FUND TOTAL
534,661
670,886
136,225
25.48%
100.00%
100.00%
100.00%
100.00%
GRAND TOTAL - ALL BUDGETED FUNDS 17,799,395 22,361,474 4,562,079 25.63%
Page 4 of 20
of p p City of Prior Lake
2011 Preliminary Budget
Fund/Department Expense Summary
TNT Hearing 12.06.2010
2010 2011
2010 2011 $ Change % Change %, of % of
General Fund
Adopted
Proposed
10-11
10-11
Subtotal
Subtotal
41110
Mayor & Council
65,453
67,365
1,912
2.92%
0.54%
0.55%
41130
Ordinance
7,000
7,000
0
0.00%
0.06%
0.06%
41320
Administration
351,576
371,884
20,307
5.78%
2.90%
3.05%
41330
Boards & Commissions
12,474
13,575
1,101
8.83%
0.10%
0.11%
41410
Elections
7,167
-
(7,167)
- 100.00%
0.06%
0.00%
41520
Finance
300,327
312,967
12,640
4.21%
2.48%
2.57%
41540
Internal Auditing
28,200
28,200
0
0.00%
0.23%
0.23%
41500
Assessing
108,200
118,800
10,600
9.80%
0.89%
0.97%
41610
Legal
385,000
309,000
(76,000)
- 19.74%
3.18%
2.54%
41820
Personnel
131,540
140,248
8,708
6.62%
1.09%
1.15%
41830
Communications
107,382
113,956
6,575
6.12%
0.89%
0.93%
41910
Community Dev /Natural Resources
252,563
276,354
23,791
9.42%
2.08%
2.27%
41920
Technology
146,597
135,340
(11,257)
-7.68%
1.21%
1.11%
41940
Buildings & Plant
439,126
410,206
(28,920)
- 6.59%
3.62%
3.37%
42100
Police
3,072,315
3,122,509
50,194
1.63%
25.35%
25.62%
42200
Fire
862,159
851,139
(11,019)
-1.28%
7.11%
6.98%
42400
Building Inspection
363,796
398,004
34,209
9.40%
3.00%
3.27%
42500
Emergency Management
7,500
7,500
0
0.00%
0.06%
0.06%
42700
Animal Control
35,844
25,650
(10,194)
- 28.44%
0.30%
0.21%
43050
Engineering
375,022
416,046
41,024
10.94%
3.09%
3.41%
43100
Street
1,032,659
1,054,352
21,693
2.10%
8.52%
8.65%
43400
Central Garage
329,994
346,903
16,909
5.12%
2.72%
2.85%
45100
Recreation
403,502
390,860
(12,642)
-3.13%
3.33%
3.21%
45200
Parks
1,310,084
1,326,359
16,275
1.24%
10.81%
10.88%
45500
Libraries
91,067
85,067
(6,000)
- 6.59%
0.75%
0.70%
46500
Economic Development
44,401
95,464
51,063
115.00%
0.37%
0.78%
47000
Debt Service
1,680,600
1,713,565
32,965
1.96%
13.87%
14.06%
49999
Contingency
69,000
-
(69,000)
- 100.00%
0.57%
0.00%
49303
Transfers
100,000
50,000
(50
- 50.00%
0.83%
0.41%
Total General Fund
12,120 546
12 188,313
67,767
0.56%
100.00%
100.00%
Debt Service Funds
,evolving Equipment Fund
Police
- 90,000
90,000
n/a
0.00%
12.97°
Fire
- 73,500
73,500
n/a
0.00%
10.59;
Public Works
- 530,256
530,256
n/a
0.00%
76.43`,
Total Revolving Equipment Fund
- 693,756
693,756
n/a
0.00%
100.00°
Vater Fund
Finance
61,935
65,690
3,755
6.06%
2.26%
41520 Finance
61,935
65,690
3,755
6.06%
2.19%
1.84°
49400 Water
2,013,522
2,726,244
712,722
35.40%
71.10%
76.36°
49303 Transfers
756,393
778,511
22,118
2.92%
26.71%
21.80
11,918
Total Water Fund 2,831,850
3 570,445
738,595
26.08%
100.00%
100.00
lnwcr Fund
41520
Finance
61,935
65,690
3,755
6.06%
2.26%
2.31
49005
CIPP Pipe Slip Lining
150,000
-
(150,000)
- 100.00%
5.46%
0.00
49450
Sewer
2,234,545
2,461,584
227,039
10.16%
81.41%
86.75
49303
Transfers
298,404
310,322
11,918
3.99%
10.87%
10.94
Total Sewer Fund
2,744,884
2,837,596
92,712
3.38%
100.00%
100.00
Fund
Transit Fund
GRAND TOTAL 19,285,120 25,252,973 5,967,853 30.95%
Page 5 of 20
p4 YWp�
City of Prior Lake
2011 Preliminary Budget
TNT Hearing 12.06.2010
Expenditure Details
111 Council Salaries
51,680
51,680
0
2010 2011 2010 2011
78.96%
76.72%
2010 2011 $ Change % Change % of % of % of % of
2,584
2,584
Adopted ProDosed 10-11 10-11 Subtotal Subtotal Total Total
GENERALFUND
General Government
41110 Mayor & Council
111 Council Salaries
51,680
51,680
0
0.00%
78.96%
76.72%
121 PERA Contributions
2,584
2,584
0
0.00%
3.95%
3.84%
122 FICA Contributions
3,204
3,204
0
0.00%
4.90%
4.76%
123 MEDICARE Contributions
749
749
0
0.00%
1.14%
1.11%
151 Workers Comp - Insurance
136
147
12
8.67%
0.21%
0.22%
201 Office Supplies - General
500
500
0
0.00%
0.76%
0.74%
321 Communications
3,500
3,000
(500)
- 14.29%
5.35%
4.45%
331 Training & Certification
1,750
5,250
3,500
200.00%
2.67%
7.79%
361 Insurance - General Liability
1,100
-
(1,100)
- 100.00%
1.68%
0.00%
437 Misc Expense - General
250
250
0
0.00%
0.38%
0.37%
331 Training & Certification
65,453
67,365
1,912
2.92%
100.00%
100.00% 0.54% 0.55%
41130 Ordinance
7,167
-
(7,167)
- 100.00%
100.00%
n/a 0.06% 0.00%
351 Legal Notice
5,000
5,000
0
0.00%
71.43%
71.43%
352 Ordinance Publication
2,000
2,000
0
0.00%
28.57%
28.57%
7,000
7,000
0
0.00%
100.00%
100.00% 0.06% 0.06%
41320 Administration
101 Full Time Employees Regular
176,463
181,678
5,215
2.96%
50.19%
48.85%
103 Part Time Employees Regular
36,496
45,003
8,507
23.31%
10.38%
12.10%
112 Longevity
16,209
19,099
2,890
17.83%
4.61%
5.14%
113 Sick Leave
2,770
2,770
0
0.00%
0.79%
0.74%
121 PERA Contributions
16,034
17,815
1,781
11.10%
4.56%
4.79%
122 FICA Contributions
12,995
13,699
704
5.42%
3.70%
3.68%
123 MEDICARE Contributions
3,518
3,664
146
4.14%
1.00%
0.99%
126 Deferred Comp Contribution
4,097
4,138
41
1.00%
1.17%
1.11%
131 Health Insurance
16,008
17,796
1,788
11.17%
4.55%
4.79%
132 Dental Insurance
960
960
0
0.00%
0.27%
0.26%
133 Life Insurance
1,906
1,906
0
0.00%
0.54%
0.51%
135 HCSP Contributions
600
600
0
0.00%
0.17%
0.16%
151 Workers Comp - Insurance
1,841
1,811
(30)
-1.65%
0.52%
0.49%
100 Severance Compensation Funding
-
1,244
1,244
n/a
0.00%
0.33%
201 Office Supplies - General
1,000
1,000
0
0.00%
0.28%
0.27%
202 Office Supplies - Dup & Copy
2,710
2,710
0
0.00%
0.77%
0.73%
203 Office Supplies - Printed Forms
365
300
(65)
-17.81%
0.10%
0.08%
314 Professional Services - General
21,780
21,780
0
0.00%
6.19%
5.86%
321 Communications
900
900
0
0.00%
0.26%
0.24%
331 Training & Certification
1,250
1,250
0
0.00%
0.36%
0.34%
334 Car Allowance
6,600
5,400
(1,200)
- 18.18%
1.88%
1.45%
433 Dues & Subscriptions
25,575
21,863
(3,712)
- 14.51%
7.27%
5.88%
437 Misc Expense - General
1,500
-
(1,500)
- 100.00%
0.43%
0.00%
570 Office Equipment & Furnishings
-
4,500
4,500
n/a
0.00%
1.21%
351,576
371,884
20,307
5.78%
100.00%
100.00% 2.90% 3.05%
41330 Boards & Commissions
115 EDA/Planning Commission
11,025
12,000
975
8.84%
88.39%
88.40%
121 PERA Contributions
101
150
49
48.15%
0.81%
1.11%
122 FICA Contributions
684
744
60
8.84%
5.48%
5.48%
123 MEDICARE Contributions
160
174
14
8.85%
1.28%
1.28%
151 Workers Comp - Insurance
4
7
3
71.43%
0.03%
0.05%
331 Training & Certification
500
500
0
0.00%
4.01%
3.68%
12,474
13,575
1,101
8.83%
100.00%
100.00% 0.10% 0.11%
41410 Elections
116 Election Judge Salaries
3,787
-
(3,787)
- 100.00%
52.84%
n/a
210 Operating Supplies - General
3,080
-
(3,080)
- 100.00%
42.97%
n/a
331 Training & Certification
300
-
(300)
- 100.00%
4.19%
n/a
7,167
-
(7,167)
- 100.00%
100.00%
n/a 0.06% 0.00%
Page 6 of 20
pF P1Vp$
City of Prior Lake
TNT
Hearing 12.06.2010
2011 Preliminary Budget
Expenditure Details
~ MIY85���
2010
2011
2010 2011
2010
2011
$ Change
% Change
% of
% of
% of % of
Adopted
Proposed
10-11
10-11
Subtotal
Subtotal
Total Total
41520 Finance
101 Full Time Employees Regular
209,609
223,508
13,900
6.63%
69.79%
71.42%
104 Temporary Employees Regular
5,535
5,500
(35)
-0.63%
1.84%
1.76%
113 Sick Leave
1,113
1,113
0
0.00%
0.37%
0.36%
121 PERA Contributions
14,828
16,204
1,376
9.28%
4.94%
5.18%
122 FICA Contributions
13,705
14,267
562
4.10%
4.56%
4.56%
123 MEDICARE Contributions
3,205
3,337
131
4.10%
1.07%
1.07%
131 Health Insurance
21,516
24,348
2,832
13.16%
7.16%
7.78%
132 Dental Insurance
1,090
1,180
90
8.25%
0.36%
0.38%
133 Life Insurance
299
299
0
0.00%
0.10%
0.10%
135 HCSP Contributions
600
900
300
50.00%
0.20%
0.29%
151 Workers Comp - Insurance
1,687
1,622
(64)
-3.82%
0.56%
0.52%
100 Severance Compensation Funding
-
1,094
1,094
n/a
0.00%
0.35%
201 Office Supplies - General
1,150
1,000
(150)
- 13.04%
0.38%
0.32%
203 Office Supplies - Printed Forms
3,500
1,850
(1,650)
- 47.14%
1.17%
0.59%
240 Small Tools & Equipment
250
250
0
0.00%
0.08%
0.08%
314 Professional Services - General
1,600
1,900
300
18.75%
0.53%
0.61%
316 BankService Charges
12,500
7,500
(5,000)
- 40.00%
4.16%
2.40%
321 Communications
350
350
0
0.00%
0.12%
0.11%
331 Training & Certification
1,250
1,210
(40)
- 3.20%
0.42%
0.39%
334 Car Allowance
4,800
-
(4,800)
- 100.00%
1.60%
0.00%
433 Dues & Subscriptions
240
4,260
4,020
1675.00%
0.08%
1.36%
437 Misc Expense - General
1,500
1,275
(225)
- 15.00%
0.50%
0.41%
300,327
312,967
12,640
4.21%
100.00%
100.00%
2.48% 2.57%
41540 Internal Auditing
301 Audit
28,200
28,200
0
0.00%
100.00%
100.00%
0.23% 0.23%
41550 Assessing
310 Property Assessing
105,000
116,300
11,300
10.76%
97.04%
97.90%
314 'Professional Services - General
3,200
2,500
(700)
- 21.88%
2.96%
2.10%
108,200
118,800
10,600
9.80%
100.00%
100.00%
0.89% 0.97%
41610 Legal
304 Legal Fees
199,000
193,000
(6,000)
-3.02%
51.69%
62.46%
305 Prosecution
186,000
116,000
(70,000)
- 37.63%
48.31%
37.54%
385,000
309,000
(76,000)
- 19.74%
100.00%
100.00%
3.18% 2.54%
41820 Personnel
101 Full Time Employees Regular
82,425
88,213
5,788
7.02%
62.66%
62.90%
113 Sick Leave
2,000
2,000
0
0.00%
1.52%
1.43%
121 PERA Contributions
5,770
6,395
626
10.84%
4.39%
4.56%
122 FICA Contributions
5,458
5,593
136
2.49%
4.15%
3.99%
123 MEDICARE Contributions
1,276
1,308
32
2.49%
0.97%
0.93%
131 Health Insurance
5,508
11,552
6,044
109.73%
4.19%
8.24%
132 Dental Insurance
305
350
45
14.74%
0.23%
0.25%
133 Life Insurance
90
90
0
0.00%
0.07%
0.06%
135 HCSP Contributions
300
300
0
0.00%
0.23%
0.21%
151 Workers Comp - Insurance
659
624
(35)
-5.30%
0.50%
0.44%
100 Severance Compensation Funding
-
423
423
n/a
0.00%
0.30%
201 Office Supplies - General
500
500
0
0.00%
0.38%
0.36%
314 Professional Services - General
12,500
11,500
(1,000)
- 8.00%
9.50%
8.20%
321 Communications
350
350
0
0.00%
0.27%
0.25%
331 Training & Certification
800
1,050
250
31.25%
0.61%
0.75%
334 Car Allowance
3,600
-
(3,600)
- 100.00%
2.74%
0.00%
354 Public Information
5,000
5,000
0
0.00%
3.80%
3.57%
437 Misc Expense - General
5,000
5,000
0
0.00%
3.80%
3.57%
131,540
140,248
8,708
6.62%
100.00%
100.00%
1.09% 1.15%
Page 7 of 20
rnro�
Technology
101 Full Time Employees Regular
oe
City of Prior Lake
2011 Preliminary Budget
200,038
18,436
10.15%
71.90%
72.38%
TNT
Hearing 12.06.2010
Expenditure Details
1,470
11.28%
5.16%
5.25%
122 FICA Contributions
11,483
12,402
'•NNES�
8.01%
4.55%
4.49%
123 MEDICARE Contributions
2,685
2,901
215
8.01%
1.06%
1.05%
131 Health Insurance
26,508
2010
2011
2010 2011
10.50%
2010
2011
$ Change
% Change
% of
% of
% of % of
0.47%
Adopted
Proposed
10-11
10-11
Subtotal
Subtotal
Total Total
41830 Communications
300
300
0
0.00%
0.12%
0.11%
151 WorkersComp - Insurance
101 Full Time Employees Regular
59,401
62,798
3,397
5.72%
55.32%
55.11%
-
103 Part Time Employees Regular
5,344
6,460
1,116
20.88%
4.98%
5.67%
1,750
121 PERA Contributions
4,158
4,553
395
9.49%
3.87%
4.00%
0
122 FICA Contributions
4,089
4,294
205
5.02%
3.81%
3.77%
0.00%
123 MEDICARE Contributions
956
1,004
48
5.02%
0.89%
0.88%
0.10%
131 Health Insurance
5,508
11,244
5,736
104.14%
5.13%
9.87%
0.33%
132 Dental Insurance
305
350
45
14.74%
0.28%
0.31%
321 Communications
133 Life Insurance
106
106
0
0.00%
0.10%
0.09%
500
135 HCSP Contributions
300
300
0
0.00%
0.28%
0.26%
-
151 Workers Comp - Insurance
505
490
(15)
-2.97%
0.47%
0.43%
2,215
100 Severance Compensation Funding
-
308
308
n/a
0.00%
0.27%
-4.65%
201 Office Supplies - General
500
500
0
0.00%
0.47%
0.44%
0.71%
203 Office Supplies - Printed Forms
1,000
1,500
500
50.00%
0.93%
1.32%
0.09%
210 Operating Supplies - General
1,000
1,000
0
0.00%
0.93%
0.88%
314 Professional Services - General
1,000
1,500
500
50.00%
0.93%
1.32%
334 Car Allowance
1,200
-
(1,200)
- 100.00%
1.12%
0.00%
354 Public Information
18,000
17,550
(450)
-2.50%
16.76%
15.40%
404 Repair & Maint Service - Equipment
1,000
-
(1,000)
- 100.00%
0.93%
0.00%
433 Dues & Subscriptions
510
-
(510)
- 100.00%
0.47%
0.00%
437 Misc Expense - General
2,500
-
(2
- 100.00%
2.33%
0.00%
107,382
113,956
6,575
6.12%
100.00%
100.00%
0.89% 0.93%
41910 Comm Development/Natural Res
Technology
101 Full Time Employees Regular
181,602
200,038
18,436
10.15%
71.90%
72.38%
121 PERA Contributions
13,033
14,503
1,470
11.28%
5.16%
5.25%
122 FICA Contributions
11,483
12,402
920
8.01%
4.55%
4.49%
123 MEDICARE Contributions
2,685
2,901
215
8.01%
1.06%
1.05%
131 Health Insurance
26,508
29,040
2,532
9.55%
10.50%
10.51%
132 Dental Insurance
1,090
1,310
220
20.17%
0.43%
0.47%
133 Life Insurance
281
281
0
0.00%
0.11%
0.10%
135 HCSP Contributions
300
300
0
0.00%
0.12%
0.11%
151 WorkersComp - Insurance
1,137
1,233
96
8.41%
0.45%
0.45%
100 Severance Compensation Funding
-
982
982
n/a
0.00%
0.36%
201 Office Supplies - General
1,750
1,750
0
0.00%
0.69%
0.63%
202 Office Supplies - Dup & Copy
500
500
0
0.00%
0.20%
0.18%
203 Office Supplies - Printed Forms
100
100
0
0.00%
0.04%
0.04%
210 Operating Supplies - General
250
250
0
0.00%
0.10%
0.09%
240 Small Tools & Equipment
500
900
400
80.00%
0.20%
0.33%
314 Professional Services - General
920
920
0
0.00%
0.36%
0.33%
321 Communications
205
205
0
0.00%
0.08%
0.07%
331 Training & Certification
500
500
0
0.00%
0.20%
0.18%
334 Car Allowance
3,600
-
(3,600)
- 100.00%
1.43%
0.00%
404 Repair & Maint Service - Equipment
2,025
4,240
2,215
109.38%
0.80%
1.53%
413 Rentals- Office Equipment
2,045
1,950
(95)
-4.65%
0.81%
0.71%
433 Dues & Subscriptions
1,800
1,800
0
0.00%
0.71%
0.65%
437 Misc Expense - General
250
250
0
0.00%
0.10%
0.09%
252,563
276,354
23,791
9.42%
100.00%
100.00% 2.08% 2.27%
41920
Technology
210
Operating Supplies - General
2,065
2,065
0
0.00%
1.41%
1.53%
306
Training Expenses
5,000
4,000
(1,000)
- 20.00%
3.41%
2.96%
309
Software Design
28,200
19,700
(8,500)
- 30.14%
19.24%
14.56%
313
Professional Services - Consultant
41,800
41,800
0
0.00%
28.51%
30.89%
321
Communications
2,702
1,080
(1,622)
- 60.03%
1.84%
0.80%
407
Software Service Contract
27,855
28,775
920
3.30%
19.00%
21.26%
408
Hardware Service Contract
5,000
3,500
(1,500)
- 30.00%
3.41%
2.59%
580
General Equipment
33,975
34,420
445
1.31%
23.18%
25.43%
146,597
135,340
(11,257)
-7.68%
100.00%
100.00% 1.21% 1.11%
Page 8 of 20
oQ earok
City of Prior Lake
TNT
Hearing 12.06.2010
2011 Preliminary Budget
Expenditure Details
'•MVfiS��
2010
2011
2010 2011
2010
2011
$ Change
% Change
% of
% of
% of % of
Adopted
Proposed
10-11
10-11
Subtotal
Subtotal
Total Total
41940 Buildings & Plant
223 Repair & Maint Supplies - Bldgs
6,000
6,000
0
0.00%
1.37%
1.46%
321 Communications
15,300
15,300
0
0.00%
3.48%
3.73%
322 Communications - Postage
19,350
19,350
0
0.00%
4.41%
4.72%
361 Insurance - Liability
95,200
88,873
(6,327)
-6.65%
21.68%
21.67%
362 Insurance - Property
128,000
130,359
2,359
1.84%
29.15%
31.78%
381 Utilities - Electric
50,000
46,000
(4,000)
- 8.00%
11.39%
11.21%
383 Utilities - Gas
52,000
30,000
(22,000)
-42.31%
11.84%
7.31%
384 Refuse Disposal
1,327
1,327
0
0.00%
0.30%
0.32%
401 Repair & Maint Service - Bldgs
22,824
26,672
3,848
16.86%
5.20%
6.50
404 Repair & Maint Service - Equipment
11,205
8,405
(2,800)
- 24.99%
2.55%
2.05%
406 Repair & Maint Service - Clean
22,555
22,555
0
0.00%
5.14%
5.50%
413 Rentals - Office Equipment
5,365
5,365
0
0.00%
1.22%
1.31%
570 Office Equipment & Furnishings
10,000
10,000
0
0.00%
2.28%
2.44%
439,126
410,206
(28,920)
- 6.59%
100.00%
100.00%
3.62% 3.37%
Total General Government 2,342,604 2,304,895 (37,709) -1.61% 100.00% 100.00% 19.33% 18.91%
Page 9 of 20
oQ rnroP
City of Prior Lake
2011 Preliminary Budget
TNT Hearing 12.06.2010
Expenditure Details
101
Full Time Employees Regular
1,735,332
2010 2011 2010 2011
100,290
5.78%
2010 2011 $ Change % Change % of % of % of % of
58.79%
102
Adopted Proposed 10-11 10-11 Subtotal Subtotal Total Total
Public Safety
42100
Police
101
Full Time Employees Regular
1,735,332
1,835,622
100,290
5.78%
56.48%
58.79%
102
Full Time Employees Overtime
132,418
132,418
0
0.00%
4.31%
4.24%
103
Part Time Employees Regular
96,462
101,337
4,876
5.05%
3.14%
3.25%
106
Training Overtime
9,211
9,211
0
0.00%
0.30%
0.29%
112
Longevity
84,877
87,985
3,108
3.66%
2.76%
2.82%
113
Sick Leave
13,608
13,608
0
0.00%
0.44%
0.44%
114
Educational Reimbursement
15,000
9,000
(6,000)
- 40.00%
0.49%
0.29%
119
Clothing Allowance
18,690
18,543
(147)
-0.79%
0.61%
0.59%
121
PERA Contributions
273,316
285,013
11,697
4.28%
8.90%
9.13%
122
FICA Contributions
13,886
14,743
857
6.17%
0.45%
0.47%
123
MEDICARE Contributions
29,154
30,577
1,423
4.88%
0.95%
0.98%
131
Health Insurance
188,136
212,580
24,444
12.99%
6.12%
6.81%
132
Dental Insurance
10,206
10,790
584
5.73%
0.33%
0.35%
133
Life Insurance
2,632
2,632
0
0.00%
0.09%
0.08%
135
HCSP Contributions
2,970
2,970
0
0.00%
0.10%
0.10%
151
Workers Comp - Insurance
72,490
59,328
(13,162)
- 18.16%
2.36%
1.90%
100
Severance Compensation Funding
-
10,086
10,086
n/a
0.00%
0.32%
201
Office Supplies - General
7,750
7,750
0
0.00%
0.25%
0.25%
202
Office Supplies - Dup & Copy
1,000
1,000
0
0.00%
0.03%
0.03%
203
Office Supplies - Printed Forms
2,000
2,000
0
0.00%
0.07%
0.06%
210
Operating Supplies - General
7,000
7,000
0
0.00%
0.23%
0.22%
212
Operating Supplies - Fuel
58,400
54,000
(4,400)
-7.53%
1.90%
1.73%
217
Operating Supplies - Uniforms
10,950
9,500
(1,450)
- 13.24%
0.36%
0.30%
221
Repair & Maint Sup - Equipment
2,000
2,000
0
0.00%
0.07%
0.06%
223
Repair & Maint Sup - Bldgs
1,500
3,500
2,000
133.33%
0.05%
0.11%
228
Repair & Maint Sup - Vehicles
4,000
4,000
0
0.00%
0.13%
0.13%
240
Small Tools & Equipment
12,000
12,000
0
0.00%
0.39%
0.38%
306
Training Expenses
10,500
10,500
0
0.00%
0.34%
0.34%
314
Professional Services - General
25,120
25,120
0
0.00%
0.82%
0.80%
321
Communications
11,000
11,000
0
0.00%
0.36%
0.35%
324
Communications - Ticketwriter
5,165
5,665
500
9.68%
0.17%
0.18%
325
Communications - State Terminal
1,080
1,080
0
0.00%
0.04%
0.03%
326
Communications - Computer
11,265
11,265
0
0.00%
0.37%
0.36%
331
Training & Certification
2,150
2,150
0
0.00%
0.07%
0.07%
334
Car Allowance
7,800
-
(7,800)
- 100.00%
0.25%
0.00%
363
Insurance - Auto
6,200
6,200
0
0.00%
0.20%
0.20%
381
Utilities - Electric
34,000
33,000
(1,000)
- 2.94%
1.11%
1.06%
383
Utilities - Gas
28,000
21,000
(7,000)
- 25.00%
0.91%
0.67%
384
Refuse Disposal
1,500
1,500
0
0.00%
0.05%
0.05%
401
Repair & Maint Service - Bldgs
12,500
14,518
2,018
16.14%
0.41%
0.46%
404
Repair & Maint Service - Equipment
6,039
6,039
0
0.00%
0.20%
0.19%
406
Repair & Maint Service - Clean
8,140
8,140
0
0.00%
0.26%
0.26%
421
Special Response Team SRT
12,865
12,865
0
0.00%
0.42%
0.41%
433
Dues & Subscriptions
3,080
2,900
(180)
-5.84%
0.10%
0.09%
437
Misc Expense - General
2,000
2,000
0
0.00%
0.07%
0.06%
550
Motor Vehicles
72,000
-
(72,000)
- 100.00%
2.34%
0.00%
580
General Equipment
6,925
8,375
1,450
20.94%
0.23%
0.27%
3,072,315
3,122,509
50,194
1.63%
100.00%
100.00% 25.35% 25.62%
Page 10 of 20
PRtp�
p4
F City of Prior Lake
2011 Preliminary Budget
TNT
Hearing 12.06.2010
Expenditure Details
'
2010
2011
2010 2011
2010
2011
Change
% Change
% of
% of
% of % of
Adopted
Proposed
10-11
10-11
Subtotal
Subtotal
Total Total
42200 Fire
101 Full Time Employees Regular
83,048
89,108
6,060
7.30%
9.63%
10.47%
117 Volunteer Compensation
174,210
174,210
0
0.00%
20.21%
20.47%
121 PERA Contributions
11,710
12,832
1,122
9.58%
1.36%
1.51%
122 FICA Contributions
10,801
10,801
0
0.00%
1.25%
1.27%
123 MEDICARE Contributions
3,730
3,818
88
2.36%
0.43%
0.45%
124 Pension Contribution
98,000
100,105
2,105
2.15%
11.37%
11.76%
125 Insurance Premium Contribution
123,000
123,000
0
0.00%
14.27%
14.45%
131 Health insurance
10,500
11,244
744
7.09%
1.22%
1.32%
132 Dental Insurance
480
480
0
0.00%
0.06%
0.06%
135 HCSP Contributions
75
300
225
300.00%
0.01%
0.04%
151 Workers Comp - Insurance
18,703
21,796
3,093
16.54%
2.17%
2.56%
100 Severance Compensation Funding
-
446
446
n/a
0.00%
0.05%
201 Office Supplies - General
450
450
0
0.00%
0.05%
0.05%
202 Office Supplies - Dup & Copy
145
185
40
27.59%
0.02%
0.02%
210 Operating Supplies -General
6,750
6,750
0
0.00%
0.78%
0.79%
212 Operating Supplies - Fuel
15,000
12,000
(3,000)
- 20.00%
1.74%
1.41%
217 Operating Supplies - Uniforms
21,500
27,500
6,000
27.91%
2.49%
3.23%
218 Operating Supplies - Medical
1,800
1,800
0
0.00%
0.21%
0.21%
221 Repair & Maint Sup - Equipment
5,400
8,000
2,600
48.15%
0.63%
0.94%
223 Repair & Maint Sup - Bldgs
9,000
9,000
0
0.00%
1.04%
1.06%
240 Small Tools & Equipment
5,400
6,000
600
11.11%
0.63%
0.70%
306 Training Expenses
20,000
20,000
0
0.00%
2.32%
2.35%
321 Communications
8,860
10,080
1,220
13.77%
1.03%
1.18%
331 Training & Certification
4,950
4,950
0
0.00%
0.57%
0.58%
354 Public Information
5,850
6,500
650
11.11%
0.68%
0.76%
363 Insurance Auto
18,340
18,340
0
0.00%
2.13%
2.15%
381 Utilities - Electric
30,000
28,000
(2,000)
-6.67%
3.48%
3.29%
383 Utilities - Gas
37,800
21,000
(16,800)
- 44.44%
4.38%
2.47%
384 Refuse Disposal
927
1,100
173
18.66%
0.11%
0.13%
401 Repair & Maint Service - Bldgs
40,620
35,345
(5,275)
- 12.99%
4.71%
4.15%
404 Repair & Maint Service - Equipment
11,610
13,500
1,890
16.28%
1.35%
1.59%
406 Repair & Maint Service - Clean
8,000
6,000
(2,000)
- 25.00%
0.93%
0.70%
433 Dues & Subscriptions
1,500
1,500
0
0.00%
0.17%
0.18%
437 Misc Expense - General
9,000
7,000
(2,000)
- 22.22%
1.04%
0.82%
520 Buildings & Structures
50,000
43,000
(7,000)
- 14.00%
5.80%
5.05%
580 General Equipment
15,000
15,000
0
0.00%
1.74%
1.76%
862,159
851,139
(11,019)
-1.28%
100.00%
100.00%
7.11% 6.98%
Page 11 of 20
p4 YRtp$
F � City of Prior Lake
D� 2011 Preliminary Budget
TNT Hearing 12.08.2010
Expenditure Details
2010
2011
2010 2011
2010
2011
$ Change
% Change
% of
% of
% of % of
Adopted
Proposed
10-11
10-11
Subtotal
Subtotal
T otal Total
42400 Building Inspection
101 Full Time Employees Regular
268,497
290,826
22,329
8.32%
73.80%
73.07%
104 Temporary Employees Regular
-
7,200
7,200
n/a
0.00%
1.81%
113•Sick Leave
2,067
2,067
0
0.00%
0.57%
0.52%
121 PERA Contributions
19,359
21,085
1,726
8.92%
5.32%
5.30%
122 FICA Contributions
17,054
18,606
1,552
9.10%
4.69%
4.67%
123 MEDICARE Contributions
3,988
4,351
363
9.10%
1.10%
1.09%
131 Health Insurance
33,393
37,230
3,837
11.49%
9.18%
9.35%
132 Dental Insurance
1,821
1,878
56
3.09%
0.50%
0.47%
133 Life Insurance
375
375
0
0.00%
0.10%
0.09%
135 HCSP Contributions
375
375
0
0.00%
0.10%
0.09%
151 Workers Comp - Insurance
1,471
1,685
214
14.56%
0.40%
0.42%
100 Severance Compensation Funding
-
1,432
1,432
n/a
0.00%
0.36%
201 Office Supplies - General
1,500
1,500
0
0.00%
0.41%
0.38%
203 Office Supplies - Printed Forms
1,000
1,000
0
0.00%
0.27%
0.25%
210 Operating Supplies - General
700
500
(200)
- 28.57%
0.19%
0.13%
212 Operating Supplies - Fuel
4,050
3,000
(1,050)
- 25.93%
1.11%
0.75%
217 Operating Supplies - Uniforms
100
200
100
100.00%
0.03%
0.05%
240 Small Tools & Equipment
500
400
(100)
- 20.00%
0.14%
0.10%
321 Communications
720
720
0
0.00%
0.20%
0.18%
331 Training & Certification
900
900
0
0.00%
0.25%
0.23%
334 Car Allowance
4,500
-
(4,500)
- 100.00%
1.24%
0.00%
363 Insurance - Auto
525
525
0
0.00%
0.14%
0.13%
433 Dues & Subscriptions
900
900
0
0.00%
0.25%
0.23%
437 Misc Expense - General
-
1,250
1,250
n/a
0.00%
0.31%
363,796
398,004
34,209
9.40%
100.00%
100.00%
3.00% 3.27%
42500 Emergency Management
306 Training Expenses
500
500
0
0.00%
6.67%
6.67%
381 Utilities - Electric
1,500
1,500
0
0.00%
20.00%
20.00%
404 Repair & Maint Service - Bldgs
5,500
5,500
0
0.00%
73.33%
73.33%
7,500
7,500
0
0.00%
100.00%
100.00%
0.06% 0.06%
42700 Animal Control
311 Animal Control Contract
35,844
25,650
(10,194)
- 28.44%
100.00%
100.00%
0.30% 0.21%
Total Public Safety 4,341 613 4,404 802 63,189 1.46% 100.00% 100.00% 35.82% 36.14
Page 12 of 20
YRIp$
pF
City of Prior Lake
2011 Preliminary Budget
TNT Hearing 12.06.2010
Expenditure Details
228,596
262,077
33,481
14.65%
60.96%
62.99% '
2010 2011 2010 2011
1,500
5,000
2010 2011 $ Change % Change % of % of % of % of
233.33%
0.40%
Adopted Proposed 10-11 10-11 Subtotal Subtotal Total Total
Public Works
27,375
28,030
43050 Engineering
101 Full Time Employees Regular
228,596
262,077
33,481
14.65%
60.96%
62.99% '
102 Full Time Employees Overtime
1,500
5,000
3,500
233.33%
0.40%
1.20%
103 Part Time Employees - Regular
27,375
28,030
655
2.39%
7.30%
6.74%
113 Sick Leave
4,610
4,610
0
0.00%
1.23%
1.11%
121 PERA Contributions
18,336
21,395
3,059
16.69%
4.89%
5.14%
122 FICA Contributions
16,584
18,582
1,999
12.05%
4.42%
4.47%
123 MEDICARE Contributions
3,878
4,346
467
12.05%
1.03%
1.04%
131 Health Insurance
26,250
35,278
9,028
34.39%
7.00%
8.48%
132 Dental Insurance
1,353
1,541
189
13.95%
0.36%
0.37%
133 Life Insurance
290
320
30
10.46%
0.08%
0.08%
135 HCSP Contributions
450
450
0
0.00%
0.12%
0.11%
151 Workers Comp - Insurance
1,295
1,588
293
22.60%
0.35%
0.38%
100 Severance Compensation Funding
-
1,424
1,424
n/a
0.00%
0.34%
201 Office Supplies - General
3,250
3,250
0
0.00%
0.87%
0.78%
202 Office Supplies - Dup & Copy
850
850
0
0.00%
0.23%
0.20%
205 Drafting Supplies
750
750
0
0.00%
0.20%
0.18%
210 Operating Supplies - General
2,700
2,700
0
0.00%
0.72%
0.65%
212 Operating Supplies - Fuel
3,000
2,200
(800)
- 26.67%
0.80%
0.53%
303 Professional Service - Engineering
17,500
11,000
(6,500)
- 37.14%
4.67%
2.64%
321 Communications
2,160
2,160
0
0.00%
0.58%
0.52%
331 Training & Certification
2,600
2,200
(400)
- 15.38%
0.69%
0.53%
334 Car Allowance
5,400
-
(5,400)
- 100.00%
1.44%
0.00%
363 Insurance - Auto
525
525
0
0.00%
0.14%
0.13%
404 Repair & Maint Service - Equipment
2,025
2,025
0
0.00%
0.54%
0.49%
407 Software Service Contract
1,200
1,200
0
0.00%
0.32%
0.29%
413 Rentals - Office Equipment
2,545
2,545
0
0.00%
0.68%
0.61%
409 Dust Control
375,022
416,046
41,024
10.94%
100.00%
100.00% 3.09% 3.41%
43100 Street
101 Full Time Employees Regular
142,058
135,846
(6,212)
-4.37%
13.76%
12.88%
102 Full Time Employees Overtime
23,000
23,000
0
0.00%
2.23%
2.18%
104 Temporary Employees - Regular
-
10,000
10,000
n/a
0.00%
0.95%
113 Sick Leave
410
-
(410)
- 100.00%
0.04%
0.00%
121 PERA Contributions
12,038
11,516
(521)
-4.33%
1.17%
1.09%
122 FICA Contributions
10,259
10,468
209
2.04%
0.99%
0.99%
123 MEDICARE Contributions
2,399
2,448
49
2.04%
0.23%
0.23%
131 Health Insurance
23,334
24,348
1,014
4.35%
2.26%
2.31%
132 Dental Insurance
1,248
1,310
62
4.93%
0.12%
0.12%
133 Life Insurance
292
263
(29)
-9.91%
0.03%
0.02%
151 Workers Comp - Insurance
13,817
11,346
(2,470)
- 17.88%
1.34%
1.08%
100 Severance Compensation Funding
-
679
679
n/a
0.00%
0.06%
210 Operating Supplies -General
2,750
2,750
0
0.00%
0.27%
0.26%
212 Operating Supplies - Fuel
58,100
54,000
(4,100)
-7.06%
5.63%
5.12%
215 Operating Supplies - Shop Material
4,000
4,000
0
0.00%
0.39%
0.38%
217 Operating Supplies - Uniforms
2,700
2,700
0
0.00%
0.26%
0.26%
219 Operating Supplies - Snow & Ice
67,340
67,261
(79)
-0.12%
6.52%
6.38%
223 Repair & Maint Sup - Bidgs
1,100
1,100
0
0.00%
0.11%
0.10%
224 Repair & Maint Sup - General
100,080
110,080
10,000
9.99%
9.69%
10.44%
240 Small Tools & Equipment
4,000
4,000
0
0.00%
0.39%
0.38%
303 Professional Service
-
6,000
6,000
n/a
0.00%
0.57%
331 Training & Certification
3,000
3,000
0
0.00%
0.29%
0.28%
363 Insurance - Auto
3,550
3,550
0
0.00%
0.34%
0.34%
381 Utilities - Electric
1,900
1,400
(500)
- 26.32%
0.18%
0.13%
384 Refuse Disposal
900
900
0
0.00%
0.09%
0.09%
386 Street Lighting
190,500
188,500
(2,000)
-1.05%
18.45%
17.88%
409 Dust Control
6,000
6,000
0
0.00%
0.58%
0.57%
412 Repair & Maint Service - General
343,000
353,000
10,000
2.92%
33.22%
33.48%
415 Rentals - Heavy Equipment
12,640
12,640
0
0.00%
1.22%
1.20%
433 Dues & Subscriptions
745
745
0
0.00%
0.07%
0.07%
437 Misc Expense - General
500
500
0
0.00%
0.05%
0.05%
580 General Equipment
1,000
1,000
0
0.00%
0.10%
0.09%
1,032,659
1,054,352
21,693
2.10%
100.00%
100.00% 8.52% 8.65%
Page 13 of 20
YRIO$
04
F , City of Prior Lake
7® 2011 Preliminary Budget
TNT Hearing 12.06.2010
Expenditure Details
~ MNe6�'
2010
2011
2010 2011
2010
2011
$ Change
% Change
% of
% of
% of % of
Adopted
Proposed
10-11
10-11
Subtotal
Subtotal
Total Total
43400 Central Garage
101 Full Time Employees Regular
102,159
109,699
7,540
7.38%
30.96%
31.62%
102 Full Time Employees Overtime
3,026
3,026
0
0.00%
0.92%
0.87%
104 Temporary Employees Regular
9,600
9,600
0
0.00%
2.91%
2.77%
113 Sick Leave
213
213
0
0.00%
0.06%
0.06%
121 PERA Contributions
7,710
8,173
462
5.99%
2.34%
2.36%
122 FICA Contributions
7,130
7,597
467
6.56%
2.16%
2.19%
123 MEDICARE Contributions
1,667
1,777
109
6.56%
0.51%
0.51%
131 Health Insurance
21,000
22,488
1,488
7.09%
6.36%
6.48%
132 Dental Insurance
960
960
0
0.00%
0.29%
0.28%
133 Life Insurance
175
175
0
0.00%
0.05%
0.05%
151 Workers Comp - Insurance
7,452
3,946
(3,506)
- 47.05%
2.26%
1.14%
100 Severance Compensation Funding
-
549
549
n/a
0.00%
0.16%
201 Office Supplies - General
500
500
0
0.00%
0.15%
0.14%
203 Office Supplies - Printed Forms
300
300
0
0.00%
0.09%
0.09%
210 Operating Supplies - General
6,000
6,000
0
0.00%
1.82%
1.73%
215 Operating Supplies - Shop Material
4,000
4,000
0
0.00%
1.21%
1.15%
217 Operating Supplies - Uniforms
1,500
1,500
0
0.00%
0.45%
0.43%
240 Small Tools & Equipment
6,500
6,500
0
0.00%
1.97%
1.87%
331 Training & Certification
4,000
4,000
0
0.00%
1.21%
1.15%
384 Refuse Disposal
500
500
0
0.00%
0.15%
0.14%
412 Repair & Maint Service - General
1,600
1,600
0
0.00%
0.48%
0.46%
433 Dues & Subscriptions
2,900
2,900
0
0.00%
0.88%
0.84%
437 Misc Expense - General
900
900
0
0.00%
0.27%
0.26%
451 Repair Sup - Parts (P /S)
11,000
11,000
0
0.00%
3.33%
3.17%
452 Repair Sup - Parts (P /K)
9,500
15,000
5,500
57.89%
2.88%
4.32%
453 Repair Sup - Parts (P/W)
11,500
11,500
0
0.00%
3.48%
3.32%
454 Repair Sup - Parts (S/W)
2,000
2,000
0
0.00%
0.61%
0.58%
461 Repair Sup - Equip (P /S)
8,300
7,000
(1,300)
- 15.66%
2.52%
2.02%
462 Repair Sup - Equip (P /K)
22,000
22,000
0
0.00%
6.67%
6.34%
463 Repair Sup - Equip (P/W)
27,300
30,000
2,700
9.89%
8.27%
8.65%
464 Repair Sup - Equip (SNV)
4,500
7,400
2,900
64.44%
1.36%
2.13%
471 Batteries & Tires (P /S)
9,000
9,000
0
0.00%
2.73%
2.59%
472 Batteries & Tires (P /K)
8,500
8,500
0
0.00%
2.58%
2.45%
473 Batteries & Tires (P/W)
7,500
7,500
0
0.00%
2.27%
2.16%
474 Batteries & Tires (S/W)
2,000
2,000
0
0.00%
0.61%
0.58%
481 Minor Sery - Contract (P /S)
4,000
4,000
0
0.00%
1.21%
1.15%
482 Minor Sery - Contract (P /K)
1,700
1,700
0
0.00%
0.52%
0.49%
483 Minor Sery - Contract (P/W)
2,200
2,200
0
0.00%
0.67%
0.63%
484 Minor Sery - Contract (S/W)
1,000
1,000
0
0.00%
0.30%
0.29%
491 Major Sery - Contract (P /S)
4,700
4,700
0
0.00%
1.42%
1.35%
492 Major Sery - Contract (P /K)
1,500
1,500
0
0.00%
0.45%
0.43%
493 Major Sery - Contract (P/W)
1,000
1,000
0
0.00%
0.30%
0.29%
494 Major Sery - Contract (S/W)
1,000
1,000
0
0.00%
0.30%
0.29%
329,994
346,903
16,909
5.12%
100.00%
100.00%
2.72% 2.85%
Total Public Works 1,737 676 1,817,301 79,627 4.68% 100.00% 100.00% 14.34% 14.91%
Page 14 of 20
OF PRIO+P
City of Prior Lake TNT Hearing 12.06.2010
2011 Preliminary Budget
Expenditure Details
2010 2011 2010 2011
2010 2011 $ Change % Change % of % of % of % of
Adopted Proposed 10-11 10-11 Subtotal Subtotal Total Total
Culture /Recreation
45100 Recreation
101 Full Time Employees Regular
63,895
70,071
6,176
9.67%
15.84%
17.93%
103 Part Time Emlpoyees - Regular
83,438
86,871
3,433
4.11%
20.68%
22.23%
104 Temporary Employees - Regular
89,697
70,300
(19,397)
- 21.63%
22.23%
17.99%
113 Sick Leave
488
488
0
0.00%
0.12%
0.12%
121 PERA Contributions
10,313
11,378
1,065
10.33%
2.56%
2.91%
122 FICA Contributions
14,949
14,119
(830)
-5.55%
3.70%
3.61%
123 MEDICARE Contributions
3,496
3,302
(194)
-5.55%
0.87%
0.84%
131 Health Insurance
10,500
11,244
744
7.09%
2.60%
2.88%
132 Dental Insurance
480
480
0
0.00%
0.12%
0.12%
133 Life Insurance
106
106
0
0.00%
0.03%
0.03%
135 HCSP Contributions
300
300
0
0.00%
0.07%
0.08%
151 Workers Comp - Insurance
7,604
6,238
(1,366)
- 17.96%
1.88%
1.60%
100 Severance Compensation Funding
-
767
767
n/a
0.00%
0.20%
201 Office Supplies - General
1,000
1,000
0
0.00%
0.25%
0.26%
202 Office Supplies - Dup & Copy
250
250
0
0.00%
0.06%
0.06%
203 Office Supplies - Printed Forms
2,000
2,000
0
0.00%
0.50%
0.51%
207 Playground
15,000
10,000
(5,000)
- 33.33%
3.72%
2.56%
220 Operating Supplies - Playground
45,000
45,000
0
0.00%
11.15%
11.51%
259 Concessions
10,000
10,000
0
0.00%
2.48%
2.56%
308 Instructor's Fees
15,000
15,000
0
0.00%
3.72%
3.84%
321 Communications
2,280
2,340
60
2.63%
0.57%
0.60%
331 Training & Certification
1,100
1,100
0
0.00%
0.27%
0.28%
334 Car Allowance
3,600
-
(3,600)
- 100.00%
0.89%
0.00%
404 Repair & Maint Service - Equipment
1,800
1,800
0
0.00%
0.45%
0.46%
406 Repair & Maint Service - Clean
1,955
1,955
0
0.00%
0.48%
0.50%
417 Community Events
17,900
24,400
6,500
36.31%
4.44%
6.24%
433 Dues & Subscriptions
350
350
0
0.00%
0.09%
0.09%
437 Misc Expense - General
1,000
-
(1,000)
- 100.00%
0.25%
0.00%
381 Utilities - Electric
403,502
390,860
(12,642)
-3.13%
100.00%
100.00% 3.33% 3.21%
45200 Parks
101 Full Time Employees Regular
416,688
445,804
29,116
6.99%
31.81%
33.61%
102 Full Time Employees Overtime
20,000
20,000
0
0.00%
1.53%
1.51%
103 Part Time Employees - Regular
41,490
42,482
991
2.39%
3.17%
3.20%
104 Temporary Employees - Regular
171,190
171,190
0
0.00%
13.07%
12.91%
113 Sick Leave
1,034
1,034
0
0.00%
0.08%
0.08%
121 PERA Contributions
34,413
36,851
2,437
7.08%
2.63%
2.78%
122 FICA Contributions
40,325
42,192
1,867
4.63%
3.08%
3.18%
123 MEDICARE Contributions
9,431
9,867
437
4.63%
0.72%
0.74%
131 Health Insurance
64,032
71,184
7,152
11.17%
4.89%
5.37%
132 Dental Insurance
2,965
3,190
225
7.58%
0.23%
0.24%
133 Life Insurance
706
706
0
0.00%
0.05%
0.05%
135 HCSP Contributions
600
600
0
0.00%
0.05%
0.05%
151 Workers Comp - Insurance
22,988
21,064
(1,924)
-8.37%
1.75%
1.59%
153 Mn Unemployment Insurance
17,500
2,500
(15,000)
- 85.71%
1.34%
0.19%
100 Severance Compensation Funding
-
2,441
2,441
n/a
0.00%
0.18%
201 Office Supplies - General
1,000
1,000
0
0.00%
0.08%
0.08%
210 Operating Supplies -General
47,500
47,500
0
0.00%
3.63%
3.58%
212 Operating Supplies - Fuel
65,300
60,000
(5,300)
-8.12%
4.98%
4.52%
215 Operating Supplies - Shop Material
2,000
2,000
0
0.00%
0.15%
0.15%
217 Operating Supplies - Uniforms
6,330
4,555
(1,775)
- 28.04%
0.48%
0.34%
223 Repair & Maint Sup - Bldgs
5,000
5,000
0
0.00%
0.38%
0.38%
224 Repair & Maint Sup - General
67,000
67,000
0
0.00%
5.11%
5.05%
240 Small Tools & Equipment
5,000
5,000
0
0.00%
0.38%
0.38%
313 Professional Services - Consultant
3,000
-
(3,000)
- 100.00%
0.23%
0.00%
321 Communications
4,200
2,808
(1,392)
- 33.14%
0.32%
0.21%
331 Training & Certification
6,100
6,100
0
0.00%
0.47%
0.46%
343 Sign Advertising
7,850
7,850
0
0.00%
0.60%
0.59%
363 Insurance - Auto
4,545
4,545
0
0.00%
0.35%
0.34%
381 Utilities - Electric
11,000
13,500
2,500
22.73%
0.84%
1.02%
383 Utilities - Gas
8,000
4,000
(4,000)
- 50.00%
0.61%
0.30%
384 Refuse Disposal
2,022
13,522
11,500
568.74%
0.15%
1.02%
387 Park Lighting
38,000
38,000
0
0.00%
2.90%
2.86%
401 Repair & Maint Service - Bldgs
2,000
2,000
0
0.00%
0.15%
0.15%
402 Repair & Maint Service - Trails
10,000
10,000
0
0.00%
0.76%
0.75%
Page 15 or 20
pQ YRfp�
,�
City of Prior Lake
0
2011 Preliminary Budget
4.39%
Expenditure Details
�N65�
2010
TNT Hearing 12.06.2010
45500 Libraries
223 Repair & Maint Sup - Bldgs
321 Communications
381 Utilities - Electric
383 Utilities - Gas
384 Refuse Disposal
401 Repair & Maint Service - Bldgs
406 Repair & Maint Service - Clean
Total Culture /Recreation
Urban & Economic Development
46500 Economic Development
101 Full Time Employees Regular
121 PERA Contributions
122 FICA Contributions
123 MEDICARE Contributions
131 Health Insurance
132 Dental Insurance
133 Life Insurance
135 HCSP Contributions
151 Workers Comp - Insurance
100 Severance Compensation Funding
203 Office Supplies - Printed Forms
313 Professional Services - Consultant
314 Professional Services - General
331 Training & Certification
433 Dues & Subscriptions
437 Misc Expense - General
Total Urban /Economic Dev
49303 Transfers to other funds
4,000
4,000
0
0.00%
4.39%
2010
2011
2010
2011
0.00%
2010
2011
$ Change
% Change
% of
% of
% of
% of
24,000
Adopted
Proposed
10-11
10-11
Subtotal
Subtotal
Total
Total
403 Repair & Maint Service - Parks
33,500
33,500
0
0.00%
2.56%
2.53%
23.83%
25.51%
415 Rentals - Heavy Equipment
16,675
16,675
0
0.00%
1.27%
1.26%
85,067
(6,000)
433 Dues & Subscriptions
700
700
0
0.00%
0.05%
0.05%
0.00%
1.42%
530 Improvements
120,000
110,000
(10,000)
-8.33%
9.16%
8.29%
1,000
0
0.00%
1,310,084
1,326,359
16,275
1.24%
100.00%
100.00%
10.81%
10.88%
45500 Libraries
223 Repair & Maint Sup - Bldgs
321 Communications
381 Utilities - Electric
383 Utilities - Gas
384 Refuse Disposal
401 Repair & Maint Service - Bldgs
406 Repair & Maint Service - Clean
Total Culture /Recreation
Urban & Economic Development
46500 Economic Development
101 Full Time Employees Regular
121 PERA Contributions
122 FICA Contributions
123 MEDICARE Contributions
131 Health Insurance
132 Dental Insurance
133 Life Insurance
135 HCSP Contributions
151 Workers Comp - Insurance
100 Severance Compensation Funding
203 Office Supplies - Printed Forms
313 Professional Services - Consultant
314 Professional Services - General
331 Training & Certification
433 Dues & Subscriptions
437 Misc Expense - General
Total Urban /Economic Dev
49303 Transfers to other funds
4,000
4,000
0
0.00%
4.39%
4.70%
2,220
2,220
0
0.00%
2.44%
2.61%
27,000
27,000
0
0.00%
29.65%
31.74%
24,000
18,000
(6,000)
- 25.00%
26.35%
21.16%
1,327
1,327
0
0.00%
1.46%
1.56%
21,700
21,700
0
0.00%
23.83%
25.51%
10,820
10,820
0
0.00%
11.88%
12.72%
91,067
85,067
(6,000)
-6.59%
100.00%
100.00% 0.75% 0.70%
-
1,353
1,353
n/a
0.00%
1.42%
1,804,653
1,802,286
(2,366)
-0.13%
100.00%
100.00% 14.89% 14.79%
49999 Contingency reserve 69,000 (69,000) - 100.00% 100.00% n/a 0.57% 0.00%
GENERAL FUND TOTAL 12,120,546 12,188,313 67,767 0.56% 100.00% 100.00% 100.00% 100.00%
Page 16 of 20
41,247
41,247
n/a
0.00%
43.21%
-
2,990
2,990
n/a
0.00%
3.13%
-
2,557
2,557
n/a
0.00%
2.68%
-
598
598
n/a
0.00%
0.63%
5,622
5,622
n/a
0.00%
5.89%
-
480
480
n/a
0.00%
0.50%
-
106
106
n/a
0.00%
0.11%
-
300
300
n/a
0.00%
0.31%
-
1,353
1,353
n/a
0.00%
1.42%
-
206
206
n/a
0.00%
0.22%
1,000
1,000
0
0.00%
2.25%
1.05%
15,000
15,000
0
0.00%
33.78%
15.71%
14,325
10,350
(3,975)
- 27.75%
32.26%
10.84%
500
500
0
0.00%
1.13%
0.52%
1,610
1,650
40
2.48%
3.63%
1.73%
11,966
11,504
(462)
-3.86%
26.95%
12.05%
44,401
95,464
51,063
115.00%
100.00%
100.00% 0.37% 0.78%
44,401
95,464
51,063
115.00%
100.00%
100.00% 0.37% 0.78%
1,780,600
1,763,565
(17,035)
-0.96%
100.00%
100.00% 14.69% 14.47%
49999 Contingency reserve 69,000 (69,000) - 100.00% 100.00% n/a 0.57% 0.00%
GENERAL FUND TOTAL 12,120,546 12,188,313 67,767 0.56% 100.00% 100.00% 100.00% 100.00%
Page 16 of 20
PRIO'P
OQ
r: City of Prior Lake
c7 2011 Preliminary Budget
TNT
Hearing 12.06.2010
Expenditure Details
MNNeso'
2010
2011
2010
2011
2010
2011
$ Change
% Change
% of
% of
% of
% of
Adopted
Proposed
10-11
10-11
Subtotal
Subtotal
Total
Total
DEBT SERVICE FUNDS
47000 Debt
4,278,001
4,278,001
n/a
n/a
100.00%
-
4,278,001
4,278,001
n/a
n/a
100.00%
n/a
100.00%
DEBT SERVICE FUNDS TOTAL -
4,278,001
4,278,001
n/a
n/a
100.00%
n/a
100.00%
REVOLVING EQUIPMENT FUND
Police -
73,500
73,500
n/a
n/a
10.59%
Fire -
90,000
90,000
n/a
n/a
12.97%
Public Works
530,256
530,256
n/a
n/a
76.43%
693,756
693,756
n/a
n/a
100.00%
n/a
100.00%
REVOLVING EQUIPMENT FUND TOTAL -
693,756
693,756
n/a
n/a
100.00%
n/a
100.00%
Page 17 of 20
p4 YRrp$
City of Prior Lake
2011 Preliminary Budget
TNT Hearing 12.06.2010
Expenditure Details
MMUSSO
41520 Finance*
353,901
320,071
(33,829)
2010 2011 2010 2011
17.58%
11.74%
2010 2011 $ Change % Change % of % of % of % of
45,736
49,150
Adopted Proposed 10-11 10-11 Subtotal Subtotal Total Total
WATER FUND & SEWER FUND COMBINED
41520 Finance*
353,901
320,071
(33,829)
-9.56%
17.58%
11.74%
101 Full Time Employees Regular
45,736
49,150
3,414
7.47%
36.92%
37.41%
102 Full Time Employees Overtime
-
1,000
1,000
n/a
0.00%
0.76%
103 Part Time Employees - Regular
23,484
24,686
1,202
5.12%
18.96%
18.79%
121 PERA Contributions
5,001
5,353
352
7.04%
4.04%
4.07%
122 FICA Contributions
4,292
4,640
348
8.11%
3.46%
3.53%
123 MEDICARE Contributions
1,004
1,085
81
8.11%
0.81%
0.83%
131 Health Insurance
10,500
11,244
744
7.09%
8.48%
8.56%
132 Dental Insurance
480
480
0
0.00%
0.39%
0.37%
133 Life Insurance
88
88
0
0.00%
0.07%
0.07%
151 Workers Comp - Insurance
540
539
(1)
-0.20%
0.44%
0.41%
100 Severance Compensation Funding
-
369
369
n/a
0.00%
0.28%
203 Office Supplies - Printed Forms
3,020
3,020
0
0.00%
2.44%
2.30%
316 BankService Charges
7,000
7,000
0
0.00%
5.65%
5.33%
322 Communications - Postage
15,876
15,876
0
0.00%
12.82%
12.08%
331 Training & Certification
100
100
0
0.00%
0.08%
0.08%
407 Software Service Contract
6,750
6,750
0
0.00%
5.45%
5.14%
210 Operating Supplies - General
123,870
131,380
7,510
6.06%
100.00%
100.00% 2.22% 2.05%
Finance department will be split 50150 between the Water and Sewer Funds.
34,860
12,000
(22,860)
- 65.58%
49400 Water
101 Full Time Employees Regular
353,901
320,071
(33,829)
-9.56%
17.58%
11.74%
102 Full Time Employees Overtime
23,000
23,000
0
0.00%
1.14%
0.84%
103 Part Time Employees - Regular
-
15,613
15,613
n/a
0.00%
0.57%
104 Temporary Employees Regular
38,820
46,490
7,670
19.76%
1.93%
1.71%
113 Sick Leave
4,175
3,884
(291)
-6.98%
0.21%
0.14%
121 PERA Contributions
27,206
26,005
(1,202)
-4.42%
1.35%
0.95%
122 FICA Contributions
26,818
25,362
(1,457)
-5.43%
1.33%
0.93%
123 MEDICARE Contributions
6,272
5,931
(341)
-5.43%
0.31%
0.22%
131 Health Insurance
47,895
51,285
3,390
7.08%
2.38%
1.88%
132 Dental Insurance
1,919
1,868
(51)
- 2.68%
0.10%
0.07%
133 Life Insurance
557
504
(53)
-9.48%
0.03%
0.02%
135 Health Savings Plan
525
375
(150)
- 28.57%
0.03%
0.01%
151 Workers Comp - Insurance
16,159
14,323
(1,837)
- 11.37%
0.80%
0.53%
100 Severance Compensation Funding
-
1,596
1,596
n/a
0.00%
0.06%
201 Office Supplies
1,000
1,000
0
0.00%
0.05%
0.04%
202 Office Supplies - Dup & Copy
530
530
0
0.00%
0.03%
0.02%
203 Office Supplies - Printed Forms
6,700
6,700
0
0.00%
0.33%
0.25%
210 Operating Supplies - General
8,000
8,000
0
0.00%
0.40%
0.29%
212 Operating Supplies - Fuel
34,860
12,000
(22,860)
- 65.58%
1.73%
0.44%
216 Operating Supplies - Chemicals
125,000
180,000
55,000
44.00%
6.21%
6.60%
217 Operating Supplies - Uniforms
3,000
3,000
0
0.00%
0.15%
0.11%
221 Repair & Maint Sup - Equipment
3,500
8,500
5,000
142.86%
0.17%
0.31%
223 Repair & Maint Sup - Bldgs
19,000
19,000
0
0.00%
0.94%
0.70%
224 Repair & Maint Sup - General
77,700
77,700
0
0.00%
3.86%
2.85%
240 Small Tools & Equipment
5,000
5,000
0
0.00%
0.25%
0.18%
241 Computer /Data Services
6,500
6,500
0
0.00%
0.32%
0.24%
260 Water Meters
47,450
54,325
6,875
14.49%
2.36%
1.99%
261 Pressure Reducers
10,900
10,900
0
0.00%
0.54%
0.40%
303 Professional Service - Engineering
27,500
88,000
60,500
220.00%
1.37%
3.23%
312 Professional Service - Water Samples
22,700
24,500
1,800
7.93%
1.13%
0.90%
321 Communications
21,415
23,515
2,100
9.81%
1.06%
0.86%
322 Communications - Postage
4,200
4,200
0
0.00%
0.21%
0.15%
325 Communications - Utility Locations
9,394
9,594
200
2.13%
0.47%
0.35%
331 Training & Certification
16,350
17,350
1,000
6.12%
0.81%
0.64%
334 Car Allowance
900
-
(900)
- 100.00%
0.04%
0.00%
354 Public Information
9,000
9,000
0
0.00%
0.45%
0.33%
363 Insurance - Auto
3,550
3,550
0
0.00%
0.18%
0.13%
381 Utilities - Electric
221,600
200,000
(21,600)
-9.75%
11.01%
7.34%
383 Utilities -Gas
64,000
55,000
(9,000)
- 14.06%
3.18%
2.02%
384 Refuse Disposal
13,540
2,040
(11,500)
- 84.93%
0.67%
0.07%
401 Repair & Maint Service - Bldg
52,790
72,790
20,000
37.89%
2.62%
2.67%
404 Repair & Maint Service - Equip
1,850
1,850
0
0.00%
0.09%
0.07%
406 Repair & Maint Service - Cleaning
12,690
12,690
0
0.00%
0.63%
0.47%
407 Software Service Contract
17,230
18,280
1,050
6.09%
0.86%
0.67%
412 Repair & Maint Service - General
93,400
134,400
41,000
43.90%
4.64%
4.93%
415 Rentals - Heavy Equipment
25,000
25,000
0
0.00%
1.24%
0.92%
Page 18 of 20
04 YR708
City of Prior Lake
TNT
Hearing 12.06.2010
330,120
2011 Preliminary Budget
Expenditure Details
(21,260)
-6.44%
14.77%
12.55%
102 Full Time Employees Overtime
23,000
23,000
0
0.00%
1.03%
0.93%
103 Part Time Employees - Regular
27,375
78,304
50,929
186.04%
1.23%
3.18%
104 Temporary Employees Regular
42,240
7,920
(34,320)
2010
2011
2010
2011
5,019
2010
2011
$ Change
% Change
% of
% of
% of
% of
2,303
Adopted
Proposed
10-11
10-11
Subtotal
Subtotal
Total
Total
433 Dues & Subscriptions
5,025
5,025
0
0.00%
0.25%
0.18%
0.28%
0.25%
530 Improvements
475,000
1,090,000
615,000
129.47%
23.59%
39.98%
132 Dental Insurance
2,224
580 General Equipment
20,000
-
(20,000)
- 100.00%
0.99%
0.00%
489
(53)
- 9.75%
2,013,522
2,726,244
712,723
35.40%
100.00%
100.00%
36.11%
42.54%
49450 Sewer
101 Full Time Employees Regular
330,120
308,860
(21,260)
-6.44%
14.77%
12.55%
102 Full Time Employees Overtime
23,000
23,000
0
0.00%
1.03%
0.93%
103 Part Time Employees - Regular
27,375
78,304
50,929
186.04%
1.23%
3.18%
104 Temporary Employees Regular
42,240
7,920
(34,320)
- 81.25%
1.89%
0.32%
113 Sick Leave
5,019
4,728
(291)
-5.81%
0.22%
0.19%
121 PERA Contributions
27,434
29,737
2,303
8.40%
1.23%
1.21%
122 FICA Contributions
26,577
26,214
(362)
-1.36%
1.19%
1.06%
123 MEDICARE Contributions
6,215
6,131
(85)
-1.36%
0.28%
0.25%
131 Health Insurance
37,395
51,285
13,890
37.14%
1.67%
2.08%
132 Dental Insurance
2,224
2,218
(6)
-0.29%
0.10%
0.09%
133 Life Insurance
542
489
(53)
- 9.75%
0.02%
0.02%
135 Health Savings Plan
525
375
(150)
- 28.57%
0.02%
0.02%
151 Workers Comp - Insurance
33,120
27,133
(5,986)
- 18.07%
1.48%
1.10%
100 Severance Compensation Funding
-
1,680
1,680
n/a
0.00%
0.07%
201 Office Supplies
1,000
1,000
0
0.00%
0.04%
0.04%
203 Office Supplies - Printed Forms
2,600
2,600
0
0.00%
0.12%
0.11%
210 Operating Supplies - General
7,000
7,000
0
0.00%
0.31%
0.28%
212 Operating Supplies - Fuel
34,860
12,000
(22,860)
- 65.58%
1.56%
0.49%
217 Operating Supplies - Uniforms
2,600
2,600
0
0.00%
0.12%
0.11%
224 Repair & Maint Sup - General
84,000
84,000
0
0.00%
3.76%
3.41%
240 Small Tools & Equipment
5,500
5,500
0
0.00%
0.25%
0.22%
241 Computer /Data Services
6,500
6,500
0
0.00%
0.29%
0.26%
303 Professional Service - Engineering
12,500
60,000
47,500
380.00%
0.56%
2.44%
321 Communications
14,810
15,770
960
6.48%
0.66%
0.64%
331 Training & Certification
15,650
16,650
1,000
6.39%
0.70%
0.68%
334 Car Allowance
900
-
(900)
- 100.00%
0.04%
0.00%
363 Insurance - Auto
3,550
3,550
0
0.00%
0.16%
0.14%
381 Utilities - Electric
45,000
42,000
(3,000)
-6.67%
2.01%
1.71%
404 Repair & Maint Service - Equip
2,000
2,000
0
0.00%
0.09%
0.08%
407 Software Service Contract
4,450
5,500
1,050
23.60%
0.20%
0.22%
412 Repair & Maint Service - General
124,500
147,500
23,000
18.47%
5.57%
5.99%
415 Rentals - Heavy Equipment
10,500
10,500
0
0.00%
0.47%
0.43%
433 Dues & Subscriptions
325
325
0
0.00%
0.01%
0.01%
437 Misc Expense - General
500
500
0
0.00%
0.02%
0.02%
440 MCES Installment
1,150,016
1,150,016
0
0.00%
51.47%
46.72%
530 Improvements
140,000
314,000
174,000
124.29%
6.27%
12.76%
580 General Equipment
4,000
4,000
0
0.00%
0.18%
0.16%
2,234,546
2,461,584
227,038
10.16%
100.00%
100.00% 40.07% 38.41%
49005 CIPP Slip Lining
501 Contract Vouchers
150,000
-
(150,000)
- 100.00%
100.00%
n/a
150,000
-
(150,000)
- 100.00%
100.00%
n/a 2.69% 0.00%
49303 Transfers to other funds
1,054,796
1,088 833
34,037
3.23%
100.00%
100.00% 18.91% 16.99%
VATER FUND & SEWER FUND COMBINED TOTAL 5,576,734 6,408,041 831,307 14.91% 100.00% 100.00% 100.00% 100.00%
Page 19 or 20
City of Prior Lake
2011 Preliminary Budget
0 Expenditure Details
WATER QUALITY FUND
49420 Water Quality
101 Full Time Employees Regular
102 Full Time Employees Overtime
104 Temporary Employees Regular
113 Sick Leave
121 PERA Contributions
122 FICA Contributions
123 MEDICARE Contributions
131 Health Insurance
132 Dental Insurance
133 Life Insurance
151 Workers Comp - Insurance
100 Severance Compensation Funding
201 Office Supplies
203 Office Supplies - Printed Forms
210 Operating Supplies - General
224 Repair & Maint Sup - General
314 Professional Service - General
331 Training & Certification
412 Repair & Maint Service - General
437 Misc Expense - General
530 Improvements
TNT Hearing 12.06.2010
2010 2011 2010 2011
2010 2011 $ Change % Change % of % of % of % of
Adopted Proposed 10-11 10-11 Subtotal Subtotal Total Total
103,076
161,698
58,622
56.87%
23.25%
17.80%
-
11,508
11,508
n/a
0.00%
1.27%
17,640
17,640
0
0.00%
3.98%
1.94%
832
1,241
410
49.25%
0.19%
0.14%
7,565
12,557
4,992
65.99%
1.71%
1.38%
7,536
11,909
4,373
58.03%
1.70%
1.31%
1,762
2,785
1,023
58.03%
0.40%
0.31%
9,198
20,456
11,257
122.39%
2.07%
2.25%
627
1,144
517
82.54%
0.14%
0.13%
146
232
86
58.92%
0.03%
0.03%
559
999
440
78.65%
0.13%
0.11%
-
808
808
n/a
0.00%
0.09%
500
500
0
0.00%
0.11%
0.06%
2,000
2,000
0
0.00%
0.45%
0.22%
1,000
1,000
0
0.00%
0.23%
0.11%
500
500
0
0.00%
0.11%
0.06%
25,625
25,625
0
0.00%
5.78%
2.82%
1,000
1,000
0
0.00%
0.23%
0.11%
37,800
123,800
86,000
227.51%
8.53%
13.63%
1,000
1,000
0
0.00%
0.23%
0.11%
225,000
510,000
285,000
126.67%
50.75%
56.14%
443,367
908,404
465,037
104.89%
100.00%
100.00% 100.00% 100.00%
49303 Transfers to other funds 0 n/a n/a n/a 0.00% 0.00%
WATER QUALITY FUND TOTAL 443,367 908,404 465,037 104.89% 100.00% 100.00% 100.00% 100.00%
TRANSIT FUND
49804 Transit
101 Full Time Employees Regular
113 Sick Leave
121 PERA Contributions
122 FICA Contributions
123 MEDICARE Contributions
131 Health Insurance
132 Dental Insurance
133 Life Insurance
135 Health Savings Plan
151 Workers Comp - Insurance
100 Severance Compensation Funding
201 Office Supplies
203 Office Supplies - Printed Forms
314 Professional Service - General
321 Communications
331 Training & Certification
334 Car Allowance
412 Repair & Maint Service - General
418 Facility Rental
425 Transit Contract Service
433 Dues & Subscriptions
437 Misc Expense - General
530 Improvements
70,691
76,269
5,577
7.89%
6.18%
9.82%
1,715
1,715
0
0.00%
0.15%
0.22%
4,948
5,529
581
11.74%
0.43%
0.71%
4,657
4,835
178
3.83%
0.41%
0.62%
1,089
1,131
42
3.83%
0.10%
0.15%
4,131
4,914
783
18.95%
0.36%
0.63%
229
263
34
14.74%
0.02%
0.03%
68
68
0
0.00%
0.01%
0.01%
225
225
0
0.00%
0.02%
0.03%
565
542
(23)
-4.02%
0.05%
0.07%
-
368
368
n/a
0.00%
0.05%
500
500
0
0.00%
0.04%
0.06%
9,000
7,500
(1,500)
- 16.67%
0.79%
0.97%
25,200
25,500
300
1.19%
2.20%
3.28%
1,620
600
(1,020)
- 62.96%
0.14%
0.08%
2,000
2,000
0
0.00%
0.17%
0.26%
2,700
-
(2,700)
- 100.00%
0.24%
0.00%
20,000
20,000
0
0.00%
1.75%
2.58%
29,000
38,000
9,000
31.03%
2.53%
4.89%
681,000
586,000
(95,000)
- 13.95%
59.50%
75.47%
500
500
0
0.00%
0.04%
0.06%
4,000
-
(4,000)
- 100.00%
0.35%
0.00%
280,636
-
(280,636)
- 100.00%
24.52%
0.00%
1,144,473
776 458
(368,015)
- 32.16%
100.00%
100.00% 100.00% 100.00%
711 Assets to Enterprise Fund - - 0 n/a n/a n/a 0.00% 0.00%
TRANSIT FUND TOTAL 1,144,473 776,458 (368,016) - 32.16% 100.00% 100.00 100.00% 100.00%
GRAND TOTAL - ALL BUDGETED FUNDS 19,285,120 25,252,973 5,967,853 30.95%
Page 20 of 20