HomeMy WebLinkAbout11 01 10 City Council work session4646 Dakota Street SE
Prior Lake, MN 55372
Date: November 1, 2010
To: Mayor Myser and City Council
From: Frank Boyles, City Manager
Jerilyn Erickson, Finance Director
Re: 2011 Budget Adjustments
Introduction
The last page of this memo provides a budget by budget recommendation for expenditure and
revenue adjustments. Council members may find it useful to refer to these totals now and then as
you proceed to read this detailed report and the attachment entitled "City of Prior Lake -Possible
2011 Budget Adjustments."
On September 7, 2010 the City Council adopted a preliminary tax levy which would raise the tax
levy by just less than $35,000 resulting in a modest tax decrease in the city portion of the taxes
fora $288,800 average-valued residential property. To achieve this objective, I recommended
the use of $350,000 from the General Fund reserve. All of the other funds reflected a planned
use of reserves. Our reserves in various funds have been consciously and carefully set aside over
time for the purpose of meeting expenditure needs that are planned to fluctuate from one year to
the next depending primarily on major capital purchases and/or improvements scheduled.
The budget that was adopted on September 7 was a "preliminary"budget. From September
through November, it is generally expected that staff will continue to analyze resource needs
based on historical and current information available and current service priorities pretty much
right up to the date of budget adoption on December 20. The purpose of this report, in
accordance with City Council direction, is to review with the Council those adjustments which
staff has identified that could be made to the 2011 preliminary budget and the anticipated
impacts of each.
At the October 18, 2010 work session, most Council members concurred that they wanted less
reserve money used to support the 2011 General Fund budget. The amount seemed to vary from
one Council member to the next. One Councilmember appeared comfortable with no
adjustment; two seemed to be comfortable with $75,000 - $100,000 reduction, one for $150,000
and one for $250,000. Council members also did not specify whether their focus for reductions
was limited to the General Fund or to all funds.
2011 Budget Adiustment Report
The attached report (Possible 2011 Budget Adjustments) identifies adjustments to both
expenditures and revenues across all funds. The adjustments listed exceed any amounts
identified by Council members in an effort to provide some flexibility in deciding those items to
be adjusted. Many of the proposed adjustments are based on analysis of historical and current
Phone 952.447.9800 /Fax 952.447.4245 / www.cityofpriorlake.com
information available relating to consumption, pricing, ete. that would justify a decrease or an
increase. Staff would be recommending these .adjustments regardless of the Council directive
because they are financially-responsible decisions. Anticipated impacts are identified for each of
the adjustments.
The report also identifies adjustments associated with the new Council initiatives: economic
development resources and water quality. Both of these initiatives impact the use of fund
balance reserves. If the water quality initiative is eliminated, the associated grant revenue would
go away, also.
A report regarding the Well #10 water supply options will be,presented by Staff at the Council
meeting later this evening. Direction on this particular adjustment should be delayed until the
report has been presented and discussed.
The net impact of all of these expenditure and revenue adjustments is reflected in the "Change in
Fund Balance" section of the 2011 Budget Adjustment Report.
Budget Comparison
Also included with this packet is a line item budget with a comparison to the 2010 budget. The
information is based on the "preliminary" budget adopted in September. The adjustments shown
in the Possible 2011 Budget Adjustments report have not been incorporated into the line item
budget. Staff will incorporate changes discussed today into. the final report to be considered by
Council in December.
There are certain line items that seem to be an on-going target of scrutiny. One such account is
referred to as "Travel and Conferences." As part of the 2010 budget process (and carried
forward with the 2011 budget), we made some reductions and removed virtually every out-of-
state conference from all budgets. However, I will allow attendance at anout-of--state (national
conference) if the employees pay airfare, hotel, meals and entertainment. The City will pay for
the registration just as we do for in-state conferences which are deemed to be of value to the
City. The purpose is to have employees think twice about going to out-of--state conferences
when the same information can be obtained locally. Not all training is available in Minnesota. I
evaluate those requests on a case-by-case basis. This line item has also been reduced by
focusing on those areas where an employee needs educational credits to retain a license or
certification required by his/her position. This account also reflects safety training that is
required for OSHA and other training seminars to provide up-to-date information for staff to
deliver services. Consequently, the description of this account was changed to "Certification and
Training" to more accurately reflect the majority of expenditures being charged to this account.
One expense that has historically -been recorded in this account is the Council workshop meals.
The $3,000 expense has not been included in the 2011 budget adjustments report because I
believe we should provide some nutritional sustenance to staff and Council members when they
are required to be in attendance for the Council workshop and the Council meeting which may
last until 11:00 pm. In short, to me this is an unavoidable cost of doing business.
Another line item often mentioned is Dues and Subscriptions. The total budgeted for this
purpose across all budgets for 2011 is approximately $41,000. The majority of this expense is
comprised of memberships with the Association of Metropolitan Municipalities ($7,300) and the
League of Minnesota Cities ($14,900). There are many benefits from being members of these
two organizations such as having representation with the legislature on any changes that may
impact cities. As an member, we are able to purchase property, liability and auto insurance from
the League. Certain memberships are required to operate a domestic water system and sanitary
sewer operation or mandated to be a police officer in the State of MN, etc. Certainly there are
memberships that are more discretionary but have been identified as providing sufficient benefit
to justify the cost of membership. Memberships .also offer training opportunities and access to
information. Other items reflected in this account include trade journals, Minnesota Statutes,
building code and. engineering manuals. These expenditures are reviewed on an annual basis to
determine if the benefits of membership still exceed the cost. The description of this account
was also updated from "Miscellaneous Expense -Dues and Subscriptions" to "Dues and
Subscriptions."
.Because it is such a large portion of the budget, personnel services are another target. As the
Council is aware, positions at the City typically go through an evolution before becoming full
time. First, we may share a position with another city. Then-the. position might become
temporary or seasonal. If the need for the position continues to increase, the position may be
hired as regular part-time (less than 32 hours per week, year-around with very limited benefits).
Only if the job demonstrates that there is an ongoing full time need will I recommend a full time
position. Conversely, if a service is eliminated or changed in some manner, the position
providing that service will also be impacted. I regularly evaluate the current and near-future
needs of the City based on service priorities and make what I believe are the necessary changes.
The fact that we have altered our organization twelve times during my tenure is testimony to this
fact. Since 2008, two building inspectors, maintenance positions, an economic development
position and numerous part time and temporary positions no longer exist for an 11% FTE
reduction.
For the 2011 budget, we are again shifting some responsibilities around to maximize our
investments in personnel to meet tomorrow's needs. The Chief Building Official currently
spends about 30% of his time on building maintenance related work. The volume of building
permits necessitates additional time being dedicated to the inspection function. To meet our
increased needs for building inspection, we will reassign the building maintenance related duties
to Al Friedges who has extensive building construction, operation and maintenance knowledge.
In doing so we wilL•
• Provide greater inspection resources in the field without adding personnel.
• Centralize building maintenance functions to consolidate purchasing, improve oversight
and develop management information to reduce utility costs associated with operating
our buildings.
2010 Yearend Proiections
As was reported in the third quarter financial report approved by the City Council on October 18,
2010, the General Fund is experiencing higher revenues for building permits, plan check fees,
tower leases, fire aid and interest earnings and lower revenues for police aid, facility rentals,
court fines and prosecution restitution. The State increased the amount of Market Value
Homestead Credit Aid that the City will not receive from $227,000 to $257,000. In addition, the
City received an additional $57,000 in fiscal disparities revenue from Scott County as a
correction for 2009. At this point in time, we reasonably expect revenues to be at or slightly
below the original budget for 2010.
On the expenditure side, significant savings are expected in the areas of fuel, electrical and gas
across all departments 0$130,000), general liability and property insurance premiums due to
good experience ratings ($30,000), lower prosecution costs ($65,000) which correlates to
lower prosecution restitution revenues, and the contingency account which has only been
partially dedicated ($30,000) in 2010.
Staff reasonably expects that 2010 revenues will exceed expenditures by approximately
$250,000. This amount may increase or decrease depending on revenue and expenditure activity
during the last three months of the year. Projection updates will be provided when the monthly
financial report is distributed to the Council Members.
The Bottom Line
If the City Council approves the adjustments I am recommending, the results are as follows:
General Fund Manager City Council
Expenditures ($254,800) $
Revenues $ 16,340 $
This means that the $350,000 reserve usage is reduced to $78,860. The reserve may increase by
as much as $250,000 based upon 2010 yearend projections.. While this would increase the
reserve beyond 45%, we expect to make a request for a major upgrade in our finance software
which would substantially reduce that balance.
Debt Service Manager
Expenditures $ 0
Revenues $400,000
Revolving Equipment Manager
Expenditures $ 0
Revenues $ 0
Water
Expenditures
Revenues.
Manager
($192,600)
$0
Sewer
Expenditures
Revenues
Water Quality
Expenditures
Revenues
Transit
Expenditures
Revenues
Manager
($166,500)
$0
Manager
$1,000
$ 0
Manager
($100)
$ 0
City Council
City Council
City Council
City Council
City Council
City Council
Many of these adjusts would have been submitted to the City Council as part of our ongoing
budget preparation process. To systemize the City Council's approach, I thought it would be
worthwhile to categorize the adjustments so each could be addressed separately.
Future Meetings
Monday, December 6, 2010 -Truth in Taxation Hearing
Monday, December 20, 2010 -Continuation of Truth in Taxation Hearing (if needed)
Adopt 2011 Budget and Property Tax Levy
Council Direction
City staff is seeking direction on the adjustments provided in the Possible 2011 Budget
Adjustments report. Adjustments supported by the majority of the Council Members will be
incorporated into the final budget document to be considered for approval by the City Council in
December.
m_
N
m
n
5'
m
m
~,
m
n~
fD
N
m
a
c
n
O
Iv rn
o m I m
~ Q
~ m m
IN m m
I m m
O. O.
7 7
o ~
v o
o °
3 N
N ~
O
m'
°
O
1
II,
I
i ~
I
I'in o
0 0
0 0
0 0
I
CT O
O O
O O
O O
i
i
~ i
~ w
T
N ~ TT
~ N Z
m v,
° m
Q" m
w
3 ~
o v ~o ~
° ~ ~ ° ~
tv fD
' N O
p
O (~
C
°
n ~ .
• ~,
~ ~ v
L1F
.y. 7
~ ~ 7
N
O
~ I
3 n n
O N ~< 1
~ ~
O
m
~ I °
3 ~ I a
y
gy i
S
~ li
' (
p
O
'
V ^
~
p I, (Q
~,
1
(D ~ ~, CO
~
`< O 7
m <
~
c
n ~ ~ ~
~° ~
o
cQ ~' ~ o
l'D
?
~w
~ ~f
~ O
3 1
O Oo
o w
0 0
o o
~~
O ~
O N
O O
~ O
i i~
O
O
i
m
N
z
0
C
°
o'
7
l J
O
O
W
0
N
O
l
I
_o
0
0
i
I
'o
p
10
!O
m
m
~•
~'
v
m
m
A
O
7
O
n
m
°
0
c
N
O
O ~
i
Ip
O
!III p ~ i~ ~ ~ I~ ~ O p lip
~
I ' ' c
I ~
I
,~ ~ j. j. I , I~ ~ ~ °O ~ I.
m
~ m
~ m Im
~
O (O I p
m s n
n a i
0
c' c' ~ ' ~ ~
°. ~ ~
3
3 v °
v~ °
im m m m ?
~ ~ C7 v
.
•. m
O
~ O
l `< N O
~ /•~
`/ 7
1
O
O
~• m ~ ~_ m
1
~' Q
m
m
`G _
(D
..
O ~_
i11 ~ O
7 V1 N
O. -.~ (D
cn o
!, ~ ~
m I
m
i
T i
I
'~ y I
'~
~.
~.,,
~~„
',.
;~
,
~ '~
III
I
A
~(n v N
o o in o
0 0 0 0
o
I~ to o ,o
,...
I
~ =.
OD N A
O (1~ O
O O O
~
' O
I
I
',~ O
I
,' O
I
'
~,
i
li
Ut
~
I
I
cn ~^'
O ~O I
O O
I
O O i
, II
I
N ~
~ ~
° I
O
c
m ~ ~ ~
<°-v~
~_ C7 ~ p'
° `< fD 4=i
N o 0
Q. A ~
~ ~
fD 7 fD
(Q ~
N ~ ~•
mZr•
3 m ~
In .< .p..
C _
lp 7 ~
~ p)
•~• <
S -~ lD
(fl n.1 O
O O
O Q'
~p ~ fD
v~~
~ ~
~ y. n
O ~ j
r. °
m ~,• ~
° °
fA
lD Q Q
.n-. ~ (D
~ n
~ (D
C .~•.
Q .C
n O
~',
~ "vi t
~o °
v -o cn rv m o D g n ~' n '~ v W W II v~ ~ n~ ~ ~ -a n ~° -a o 2~ ~ v~~ w~ m p~
o ~ ° v n a ° ~ ~° ~ to y Iy ''~° ~ I~ v°', ° ~ ° ° 3,<~ m~.w ~ ° Qm ~ m o Dm c
~-a°-° I>>='• ~~' fD3~~va ~a ~~~~ ~41in~ ~~~vv~.v,s~o~~po ~~~~:
~ N O Q y O !p p. ~. N fD ~. - O- _ _ i ~ C
N ~ ~-.< 1~ 3 v ~ ~ ~ ?.m ai ~ ~ I-n6y m > > o m o~ m ~`~ ~i~ o ~ °°-v v°~,~ o i
O ~ 3 ~ lD "O N In ~ fD v lD ~ lD I O fD = O ~ ~ ~ N ~ 7 O to ~ ~. ~ Q 7 7 L C N ~ ~ E
~. iU fD ~` ' N ~' O ~ fD • "° N O Q n O n O ~ "6 ~ N ~ ~1 Q N O ~
<~ fD ~' N O O ~ O N fD (Q ~ p ~. O N n 7 ~ -~ _ N 7 ~. O N
~ (D ~. .n-. O 7 ~ r: Q 7 ~' ~ ~ N ~ O Q O 7 O ~. ~. - 7 Q W -° f7 ~ O O -~ O ~-- ~ .n-. -i C7
n O O Q I C O N y O C~ ~~ Iv O O- ~ n fD ~ C7 O V1 ~ ~. O -' N N -° ~_ ~ n~ Q ~i ~ n Q.
- N Q (~ N fD O LU fD fD l/i -, O " fD ~ fD p fD
moo v '~D ~ o y m cQ~ II o v m m 3 0 ~'~w ~I ~ m ~ o~ ~-m', 3~'0° 'I 9'~ m
~ ~ ~ -a ; m -- cn v ~ c. j ~, l o' ~ Q- -- v ~. 0 0 ~ - 3 I o (n < 3 0
n (D ~ „~~. ~ (D N fD n N 6 ~ it (j O f-zD ~ ~, N .~. N f7 ~ (<p ~• 0 ~ Q O 3 N CO N ~~ (OA fD "°
fA 'O O ~ I ~. ~ O M Q " (D 7 ~ C C) ~ O ~' (D c0 ~ n fD 'O ~ O ', ~• o ~ ~ ICI N ~ (D
~ .~ n y (D fD r; ~' 7 Q !n 7 p Q _ O O to - O p~ O (Q \ n : O
~ O 4~1 (D ~G ~ ,~ ~ 7 ~ ~ -~ 3 Q ~ ~ O = -+ ~ S ~ f<D '6 Vi pOj ~ "3' p ~ ~ ~ ~ (D
(U ~ j ~` 7 C 7 ~ ~ I Q O (~D 'O •-• N .~ 7 fn ~ (D n (fl 'G L2 n n• I N N N ~ O ~ 'a
(D ~ ° O_ ~ Q ~ it O Q. .~ j v ~ O O fD V1 O (D (D ? O ~ ~ < O '~ ~ 7 0 (D
cn'~ ~ ~QC om o° v Q' .n~o~' -a~ ~ ~~, ~~n~C c3n
m~Q~ c~'~ ~~' ~~ o co ~~~ N~~~_ m~'~Q'~°~I, 3 0~ ~m~
ovo~. vov ~, ~~ ~~ n °~ fDQV ~D,<c~° o~°mv,'3~~ ~mv,'~ - C~a,
°'~°'~ ~~, ao ~ owl ~ om v~.~' ! -°~~i~;fD~m °°~ ov
<-•°o ... Im< I ov o !, -,~ a~ v,mo°1Do can moo. ~ •<~~
. •7. O N N N N Q a ~p ~ N cQ p cD to ~ `< ~ 7~ c N
.+ O In Q ~ N ~ "06 O N ~, ~ ~ N .O-. N I < ~ (D c0 ~• ~ .•. (D N ?~. (D ~
~ 3 ~ ~• ~ ~• 3 (D fD 7c 3• ~ N O O N lD `< O O ~ ~• N N
(D O, N ° ~ fD I N O ~ n _3 3 ~ ~ ~ (O ~ U1
O ~, i fA' 0 `'G y I j ~, y (fl
_ _ _ _ _
C~Ti iv N A Cn O O ~O W ~ _t~)1 ~
c
O ~ O ~ (T O O O O ~ O i 00 W O
O O ;O O O O O O O O O
O iO O O O O 10 ~O O O O
i 1
~ 1
I
I ~' ~ I i
I ~ II i I c
i
n~
f t~
L ~
fD
~ ~
f ~
L ~
C7
fD
m ~
~ °
~ C, ~
-p O
~ ~ <
~ _.
~ (a
i
L ~
~ ~
CD
S
L ~
n ~ ~
i °1
i~ ~
n ~
:n~
s ~
i °
r.
3
0 °~
~ ~
CO
fD
CITY
Q~
ro
N
09 ~~
Hx~
O
y
y~
<D ~
N O
O ~
i r
W
C.
r'
D
Y
N
r~
3
c~
N
O
C
O
y
O
N
O
O
m
m
N
O
W
m ~,~m m ~~Im m m m m 'm
I, Im
I m
y
cir
W N ~ O O O !v O ICJt ? W
o
a n ~ 'D ~ ~ m ~ n o 3 ~a m ~< m ~ m ~ ~ ~ .,
o m ; Q- m O m o ~ ~ m o ' v, m v o M
N ~ l 6 y (~ ~ ~ ~ Q '! ~ ~p f7 O O ~ 7 Q. 7 y y 9 ~O
m m
~ m w
3 o
~ p ~ 3
.-. ~~
-, v o~~
~. y a
a m ~, m O
~. m
m
! ` ~ ~ 7 "~ O z O.
a
N ~
y~ ~
~ ~
~ i7 ~
~p N n';N O
y ~ , 7 ~ ! 7
N ! 7
N cn
fD C ~
N ~
~ ~
O O N I
O
.n•. , O i N
N ~ y y z ~
fD U! 0
o v o m ~' .~ ~ ,
~ p ' ~
~ ' m
I m n' D a ~+
c
m ~, ~ ~ ~ -o cQ ,
~ ~ ', ~ I ~ y ~' ~p ~
v ~ w o I
~
~,
!I~ I~
. 3
l i
~~
~ ~ n~
~ o.
~°
~
~',~ c
n
o ~
o n
~
m O
~ D
~
~N o
~ y
%y j
=
I ~
,
~.y~m
o
0
0• r
~
o m 'o Icoi i ~
~ ~# I ~ m co cfl ~ li ~ !3 W ~
f7
I ' y v O i O Q 6 7 O i Q ~, Q.
I
'd
y
j
~ ~ C C (D
lD O
a ~
~ .n•. ' .O•~
'!
C
~ p (
~ 7 t
D
~ N
°
', ~
~ o'
• '
m w
° I y
~ ~, j C.
I I ~ I ~
I ~ I I ~ rt
I I
W I 1 N I I
I O ~
O W ~ o CNJ1 O !~ ~ CJi O II W d rt
o in o 0 0 0 '0
' 0 0 0 !o y
0 0 0 0 0 0 o 0 0 o 0
~o to o ° ° ° ° ° '° j° °
t I I I
i I ~
W ~
~J I i h
~
~ T1 fD
C 7
O W i O I O A CJ1 O W O CD
to v, °o ° ° ° o
I o a d
IoO °o o ~ o
o o
o o
o ~
O
to O
0
~ ' ' v
, , I p
I ' -n Q.
I c N
~
!
~ ~
a
I
I
ii ~
y
i i i ~~~ I II ~ n
i i i Ali i i iii Ali fD
I I I i m~
I
~, I ~ ~
„ c <
.
c-o
o
I I ~ ~ <
Q
I
I ~ _.
, ~ ~ I ~
I
~~
~
I~'
I
~ ~
'' ~cc
I ~ ~ N ~~~ ~
!
I ~
~
O p
O
' i
~
~ ,d.'
° ~ ° !° I ~ ' a o
-,
o
o ~ o
!° ' o
'o ~ ! ' ' ~ j
I III
j
-,
I
m
~ ~ ~~ ~ ~i ~ I c
~
I O O ~ I Q fD
O O
I ~
~~O i O Ii i li Iii i
I
i ! l
I
I
~'
i ~ '~ c d
d
~,
',~
.
~
~
I
I.
~
I~
'
I ~
a
I I
l ~ j j ~
c w
i
i
~ ~
'
i ~
II
I >
Q y
':
0 O I
'O ~ O O 0
0 (D a ~ N ~ 3 ~N d y t
n ~ N: Q ~ ~ ~ l,`G y. 7 ~ ~ m• ~ O' ~ y < (D ~ y
p
< .y. 6 A ~,
° ~ fD
Q (D y rt
o ~ p
~ N 6
m O
fl- I .
o
~' ^!
~-.
'o y ' SU (O (Q
a
~ lD O
~
~ I fA Q
3 (D ~
~ N ~. ~.
C
~
(D ~
~ 7' ~ .- N ~ cp
, ~ 7 ~ ° ~
Q lD O i
7 O .
7 v •
O ~
y
O Q a .
Q
~ - Im
~ m
N ~ z y < <
fD 7 t-
~
N ~ =' O O' ~
7 N n ~ 7 ~ y
0 3 .~.
O O 7 ' (p
y 7 ~
~ ~. C7 ~ N ~. (D
(
l (D O ~
N .
O 7 N
~ n (D
3 y Q
a 3 7
7 ~
y N
~ (D
y f%
a
a ~ fD O
s O
'~ O
~. Q
I_. N y D
y ~
y~ N ~
~ f
D ?
(n U1 ~
a (D cQ
a 0
n O
y O
~
` =n a
~ ,
~ O O N v
.O 0
I ~ (D 3
~' ~ c
fD O .- ~ N
~ >
= y
~ (D p O <
p
j ~ ~ _
,
~ . ~ (D ~ fD
fD (D y '~ ? ~ ~ -~ O ~ (7 ~ Q. Q Q N N N ~ N
i ~ O N ~ N ,. O ~ a
N Z•
7 7 .n+
• , y
n
a O j N
~
C•
~~~<
~
~•
~
0--.
O 7
~
y I
N lD
00
7 Q (D
fD _
n~ (
lD •+
fD
~ Q
Q Q
`< • (D
3 ~. `G fD C 7 fD y N ~.
o O .
N ~~ 7 7• ,~ .
•.
N y O ~ (a -
~ c~ y '0 f1 Q ~ O C ~.
m o m
y
~ -
Q' 1 1' ~ .6
0 y
6
~ m ~ ' ~. m
-~ m < v m
fD i O m o
~ I
! w a
O fD fl- ~
~ O ~°
O A
F
p
(D
v j
• N N 0
~ 0 0
~
D ~ < ~• ~ ~
3 ~
N 00 O
3 O
D y ~ N N
~ -
O i ?
Q <
(D n 3
O
~' d 7 a ~ (
~ to d
I
O
~,
Q- I
! 7c 7
p f
.fl v "' .
+
O .y-. - t
~
~ C
~ 7
~ y
O - N fD
cn ~ n (Q ? ~ ~. 7 ~ fD I (D 7 O C ~ ~ N
Q .O•. ~ N
~ I _
~ O ~p fl1 ~ Q ~
6~
C~ ~• >?~ ~ Q O ~ 3 N '•' n
O y
.. 6
7
f~
O
O ~ cQ a n O ~. O. ~1
E N O lD (D I (OD ~ y~ n ~< ~ .
7 f7 C ~ O I = fD O W N i C 7 j .O-. > _
y O.
~ Q , y 7 ' to n ~ O (D I ~ v fD ~ ~ Q r: ~ ~ n f~ t ~- 7 i ~ 3 pyj 7
i ~ 7 N O `G ? >' fD
y ~ N L I 7 ~ N ~ 'O-.: iU fD ° C 3 cn N O fD lD fD
~
m
~m~~ .
.
~cn~o
~
-aa
D
I
o Q
mo
Iy
~ ~v y
omc
sc
', Q N
.
•
N~
,
a m m o ~• I ~~ v v I ~
O I '-' I ~' ~ v o o- ' ,
~,
~ m . c
y
~ Q Q O ~ '
U Q
N
3 N Q' Q
-
m
~
n ' s fD
v ~. C ~.
cp ~ (D y ~
cn c O y
~ 3~ j N
y
• O
3
• m~
v
mv I
!
I r
~
~
i
o~ c
3~
v
y
~
~'O ~
my ~ y
ma
~
n~'c
.
~a ~I n.$
o
3i° I n
. , N <° ,
~ m ,
~ I fD
~ 3
°' ' ~ ~ j ny O
~
m j ~
1 3 ~ I ~
~
~ I
' ~
a ~ ~ m
~
1
~ , _
a p
~
~. ~ ~ ~
Qom ~
o
m
a
-~ . ~
~ oa p
-•y~
sNO <
.y
~a
(D
f7
~ lD 7
~ fD
7 O
~ 7
(D y N
X ~, ~ ~ ,~ fQ n
O i I ! ~'
' '~~ '~ ~
I '~ 2
I 3
~
I N I ~ d C
W ~
~ Iv
; O N
U1 O
O
~
'
W ~ O
C1 ~ C
~
i <n O O O O ' O ~ ~ i ~ O y
O
O O
O f0
;O O
O O
O 10
~O I
~ O
O ~ _
I O
'I ~ I a
i n ..
I ~ '~ ~
i I ~ ! I I , I o
!
~
N
' ~ ~ ~ o
I
,
m
w
0
w
g ~
c ~
y ~.
~ ~.
a
n
N C7
(~ N
~. ca
~ m
~ _.
fl. c
~~
N ~'
v W
~ ~
m ~
;(7 N
tin Z]
fD fD
N
fD
~ Z
fD
W ?
~1 ?
N O
O A
W O
O W
W CW77
W O
00 O
O O
W V
W W i
~ ~
O O
~ ~
N N ~
ww
~~
~~
rnrn
OD O
~l V I
OD O
W CD ~
W W
O W
v ~
O O t
CT N
~ ~ S
~ ....
~ ~
cn ~
io m ~
00
rnrn
1 ~ •
Q ~
CO O ~
0
W ~
o_ O~
V W
O ?
rn o
W W
A ~
.Op .OA
O O
~ ~
U
7
n
3
z
A
u
u
7
D
1
n ~
7 fD
2 ~
v
m
n ~
z ~
i ~
n
cD
m ~
~ ~
n~•~
= ~ o
s ~ ~
i ~
~ in
n ~
m
7 ~
1 ~
n ~
_ ~p
S
i ~
n A ~
c ~
~ m
1 ~ ~
n
1 N
1
QI~
~' 3
~ ~.
Q ~
17
~1
7 <
m ~
~ ~
O ~
v ~
~ o
v
N N
N ~
N OD W
OD CO (O
U1 W N
Cfl CJ1 ~
~I V O
N N
o
CO O
00 O V
~I W O
W CO O
O O O
w w
N N O
A ? O
CJ1 U1 O
CO CO O
W W O
v v
00
00
00
00
NIN
V V
N N
O O i
W W
~ O
~ ~
~ w I~ ~
p j
3 ~ Q
• n 'a v ~J
~ a
o~ ~
~ c m
~ m• ~~
cn n - o ~p
U '~ D N
C ~• ~ y O ~
r:' Q
• fD (D ~ O a.
~
ofQ
~• ~
cn~
Imp
o-a cQ ~m ~ ~ m
mr: ~• imp ~
3Q°
~
~'
c3 ~
my
y ~ ~
i ,
i7 ~
~a ~ V1 ~
v
~ ~
(D
I ~ cn c
n N O O
N
6
fD ~
N C•
C O
m
N
~~
III
W
O N
~ _ O
10 N
O
W O O O
~ O 'O O
!O O O O
W N N ~
O ~ O
W ~
P O O
O O O
I A
0 i
0 i
I~ O i
0
I O I
~I
Iii ~
~~
i i
II
II
III
rn rn
O O
N N ~ ~
CJ1 U1
O O
cnicn
o~o ~~ A
olo
0 0
1
N N
N ~
W 00 ~
f0 W W
W O W
CO C7~ .A
~ v o
N N
~ ~
O W
O O
W W
O O ~
1
~
I< I° m m ?
~ I X p m c
~ v m ~ cn•
~ ' y ~ ~ ~
<
vm
~ ~
~m
'
~
I Q- ~ i
~m.
~
~ ~ N N ~
Vl
~
N
I I CD ~ ~ -' 3 ~ ~
to
Q I
~ •~. 'p
I ~
~ ~ V1 N
i N 00 ~ Q~
fD ~ fD O
~j ]• O p N O~~
q
~(n 7 ,
~I ~ U ~ Q ~ C N•
O ~ Q ~ j N `G
(Q ~
_ ~
fD v
'O ~ N (D ~
~
•
N
I
C C
O
(~• ,~• ~
~ 7
~ ~
~ ~ ~ .
C Q Q
a
m
ma
nm Qm
a ~
~' ~
a ~ ~,
~~~~ ~ o;~ ~ ~a
~
~ Q n 7 (~D .~
N
~ ~ ~
c~ lD
~ Q Q
~`
N O ~ "
6 ~ ~
O N ~ 3 I ~ Q
O O n Q
7 I ~
~
o cQ
a r
~ ~
cn ~
m ~ ~ ~, ~
I
A
'
IW i O N j
O i O O ~
W ~ O O
~ O o
0
I, 0 0
~; ,
n
n
n ~
7 fD
1 ~
d
v
n ~
i ~
1 ~
7
n
fD
m ~
~ ~
n ~
-a' o
~ ~ <
i ~ _.
~ ~
n ~
7
1 ~
n ~
- cp
7 ~2
2 ~
n Q ~
3 ~ m
1 ~ ~
n
S
Z N•
r-'
3
0 ~
41
CC
CITY
`~, O~
N
09 ~0
axd'~
O ~
y
N O
~ ~
ID ~
N O
O ~
s r
=o
Q.
rt
D
c
N
rt
3
n
0
O
y
a°
O
v
N
O
r
O
OF p~O~P
F
City of Prior Lake
Council Workshop 11.01.2010
~
u ~ 2011 Requested Budget Based on preliminary budget approved 09.07.2010
Expenditure Details
~fi5°S*
2010 2011 2070 2011
2010 2011 $ Change % Change % of % of % of % of
Adopted Proposed 10 - 79 10 -11 Subtotal Subtotal Total Total
WATER QUALITY FUND
49420 Water Quality
101 Full Time Employees Regular 103,076 161,293 58,217 56.48% 23.25% 17.79%
102 Full Time Employees Overtime - 11,508 11,508 0.00% 0.00% 1.27%
104 Temporary Employees Regular 17,640 17,640 0 0.00% 3.98% 1.95%
113 Sick Leave 832 1,241 410 0.00% 0.19% 0.14%
121 PERAContributions 7,565 12,528. 4,963 65.60% 1.71% 1.38%
122 FICA Contributions 7,536 11,884 4,348 57.70% 1.70% 1.31%
123 MEDICARE Contributions 1,762 2,779 1,017 57.70% 0.40% 0.31%
131 Health Insurance 9,198 19,472 10,273 111.69% 2.07% 2.15%
132 Dental Insurance 627 1,099 472: 75.36% 0.14% 0.12%
133 Life Insurance 146 232 86' 58.92% 0.03% .0.03%
151 Workers Comp -Insurance 559 997 438 78.27% 0.13% 0.11
100 Severance Compensation Funding - 806 806. 0.00% 0.00% 0.09%
201 Office Supplies 500 500 0 0.00% 0.11% 0.06%
203 Office Supplies -Printed Forms 2,000 2,000 0 0.00% 0.45% 0.22%
210 Operating Supplies-General 1,000 1,000 0 0.00% 0.23% 0.11%
224 Repair & MaintSup -General 500 500 0 0.00% 0.11 % 0.06%
314 Professional Service -General 25,625 25,625 0 0.00% 5.78% 2.83%
331 Training & Certification 1,000 1,000 0 0.00% 0.23% 0.11%
412 Repair & Maint Service -General 37,800 123,800 86,000 227.51 % 8.53% 13.65%
437 Misc Expense -General 1,000 1,000 0 0.00% 0.23% 0.11%
5301mprovements 225,000 510,000 285,000 126.67% 50.75% 56.24%
443,367 906,906 463,539 104.55% 100.00% 100.00% 100.00% 100.00%
WATER QUALITY FUND TOTAL 443,367 906,906 463,539 104.55% 100:00% 100.00% 100.00% 100.00%
TRANSIT FUND
49804 Transit
101 Full Time Employees Regular 70,691 76,990 6,299' 8.91 % 6.18% 9.04%
113 Sick Leave 1,715 1,715 0 0.00% 0.15% 0.20%
121 PERA Contributions 4,948 5,582 633 12.80% .0.43% 0.66%
122 FICA Contributions 4,657 4,880 223 4.79% 0.41% 0.57%
123 MEDICARE Contributions 1,089 1,141 52 4.79% 0.10% 0.13%
131 Health Insurance 4,131 4,545 414 10.02% 0.36% 0.53%
132 Dental Insurance 229 229 0 0.00% 0.02% 0.03%
133 Life Insurance 68 68 0 0.00% 0.01% 0.01%
135 Health Savings Plan 225 225 0 0.00% 0.02% 0.03%
151 Workers Comp -Insurance 565 547 (18) -3.10% 0.05% 0.06%
100 Severance Compensation Funding - 371 371 0.00% 0.00% 0.04%
201 Office Supplies 500 500 0 0.00% 0.04% 0.06%
203 Office Supplies -Printed Forms 9,000 7,500 (1,500) -16.67% 0.79% 0.88%
314 Professional Service -General 25,200 25,500 300 1.19% 2.20% 2.99%
321 Communications 1,620 600 (1,020) -62.96% 0.14% 0.07%
331 Training & Certification 2,000 2,000 0 0.00% 0.17% 0.23%
334 Car Allowance 2,700 - (2,700) -100.00% 0.24% 0.00%
412 Repair & Maint Service -General 20,000 20,000 0 0.00% 1.75% 2.35%
418 Facility Rental 29,000 34,000 5,000 17.24% 2.53% 3.99%
425 Transit Contract Service 681,000 661,000 (20,000) -2.94% 59.50% 77.59%
433 Dues & Subscriptions 500 500 0 0.00% 0.04% 0.06%
437 Misc Expense -General 4,000 4,000 0 0.00% 0.35% 0.47%
530lmprovements 280,636 - (280,636) -100.00% 24.52% 0.00%
1,144,473 851,893.- (292,$81) -25.56% 100.00% 100.00% 100.00% 100.00%
TRANSIT FUND TOTAL 1,144,473 851,893 (292,581) -25.56% 100.00% 100.00% 100.00% 100.00%
GRAND TOTAL -ALL BUDGETED FUNDS 19,285,121 25,939,463 6,654,342 34.51%
Page 14 of 14
OF YRIp~
~ ~~
'•rvNfi50'~P
City of Prior Lake
2071 Requested Budget
Expenditure Details
406 Repair & Maint Service -Cleaning
407 Software Service Contract
412 Repair & Maint Service -General
415 Rentals -Heavy Equipment
433 Dues & Subscriptions
530 Improvements
580 General Equipment
Council Workshop :11.01.2010.
Based on preliminary budget approved 09.07.2010
2010 2017 2010 2011
2010 ; 2011 $ Change % Change % of % of % of % of
dopted Proposed 10 -17 10 -11 Subtotal Subtotal Total Total
12,690 12,690 0 0.00% °0.63% 0.44%
17,230 18,280 1,050 6.09% -0.86% 0.63%
93,400 119,400 26,000 27.84% 4.64% 4:10%
25,000 25,000 0 0.00% 1.24% 0.86%
5,025 5,025 0 0.00% 0.25% 0.17%
475,000 1,283,000 808,000 170.11% 23.59% 44.04%
20,000 20,000 0 0.00% 0.99% 0:69%
:,013,522 2,913,229 .899,708 44.68% 100:00% 100.00% 36.11% 43:14%
49450 Sewer
101 Full Time Employees Regular 330,120 335,693 5,573 1.69% 14.77% 12.82%
102 FuII Time Employees Overtime 23,000 23,000. 0 0.00% 1:03% 0:88%
103 Part Time Employees -Regular 27,375 78,472 51,097 0.00°/a 1:23% 3.00%
104 Temporary Employees Regular 42,240 7,920 (34,320) -81.25% 1.89% 0.30%
113 Sick Leave 5,019. 4,728 (291) =5.81% 0.22% .0.18%
121 PERAContributions 27,434" 31,695. 4,261, 15.53% 1.23% 1.21%
122 FICA Contributions 26,577 27,888 1,312 4.94% 1.19% 1:07%
123 MEDICARE Contributions 6,215 6,522 307 4.94% 0.28% 0.25%
131 Health Insurance 37,395 44,556 7,161 19:15% ..1.67% 1..70%
132 Dental Insurance 2,224 2,311 87 3.93% 0.10% 0.09%'
133 Life Insurance 542 533 (9) -1.66% 0:02% 0.02%
135 Health Savings Plan 525 375 (150). -28.57% 0.02% 0.01%
151 Workers Comp -Insurance 33,120 27,389' (5,731) -17.30% 1:48% 1.05%
100 Severance Compensation Funding. - 1,815 1,815 0:00% 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.1.2% 0.10%
210 Operating Supplies -:General 7,000 7,000 0 0.00% D.31% 0.27%
212 Operating Supplies -Fuel 34,860 34,860. 0 0.00% 1.56% 1.33%
217 Operating Supplies -Uniforms 2,600- 2,600 0 0.00% 0.12% 0.10%
224 Repair & Maint Sup -General 84,000 84,000 0 0.00% 3:76% 3.21
240 Small Tools & Equipment 5,500 5,500 0 0.00% 0.25% 0.21
241 Computer/Data Services 6,500 6,500 0 0.00% 0.29% 0.25%
303 Professional Service -Engineering 12,500 40,000 27,500 220.00% 0.56% 1.53%
321 Communications 14,810 15,770 960 6.48% 0.66% 0.60%
331 Training & Certification 15,650 16,650 1,000 6.39% A:70% 0.64%
334 Car Allowance 900 - (900) -1.00.00% 0:04% 0.00%
363 Insurance -Auto 3,550 3,550 0 0.00% '0:16% 0:14%
381 Utilities -Electric 45,000 45,000 0 0:00% 2.01% 1.72%
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.21%
412 Repair & Maint Service -General 124,500 147,500 23,000 18.47% 5.57% 5.63%
415 Rentals -Heavy Equipment 10,500 .10,500 0 0.00% 0.47% 0.40%
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% 43.92%
530lmprovements 140;000 440,000. 300,000 214:29% 6:27% 16.80%
580 General Equipment 4,000 4,000 0 0.00% 0:18% 0.15%
2,234,546 2,618,269 383,722 17:17% 100.00% . .100.00% 40:07% 38.77%
49005 CIPP Slip Lining
501 Contract Vouchers 150,000 - (150,000) -100.00% .100.00% 0.00%
150,000 - (150,000) -100:00%- 100.00% - 0.00% 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.12%
WATER FUND & SEWER FUND COMBINED TOTAL 5,576,734. 6,752,517 1,175,783 21.08% 100:00°/n 100:00% 100.00%' 100.00%
o~ Y~O$
,, City of Prior Lake
2011 Requested Budget
Expenditure Details
~fi5°2p
WATER FUND & SEWER FUND COMBINED
41520 Finance
101 Full Time Employees Regular
102 Full Time Employees Overtime
103 Part Time Employees -Regular
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
203 Office Supplies -Printed Forms
316 BankService Charges
322 Communications -Postage
331 Training & Certification
407 Software Service Contract
Council Workshop 11.01.2010
Based on preliminary budget approved 09.07.2010
2010 2011 2010 2011
2010 2011. $ Change % Change % of % of % of % of
Adopted Proposed 10 -11 10'-11 Subtotal Subtotal Total Total
45,736 .49,622. 3,885 0.00% 0.00% 37.54%
- 1,000 1,000 0.00% 0.00% 0.76%
23,484 24,909 1,425 0.00% 0.00% 18.84%
5,001 5,403 403 0.00% 0.00% 4.09%
4,292 4,683 391 0.00% 0.00% 3.54%
1,004 1,095 92 0.00% 0.00% 0.83%
10,500 11,244 744 0.00% 0.00% 8.51%
480 480 0 0.00% 0.00% 0.36%
88 88 0 0.00% 0.00% 0.07%
540 544 4 0.00% 0.00% 0.41
- 373 373 0.00% 0.00% 0.28%
3,020 3,020 0 0.00% 0.00% 2.28%
7,000 7,000 0 0.00% 0.00% 5.30%
15,876 15,876 0 0.00% 0.00% 12.01%
100 100 0 0.00% 0.00% 0.08%
6,750 6,750 0 0.00% 0.00% 5.11%
123,870 132,186 8,316 0.00% .0.00% 100.00% 2.22% 1.96%
49400 Water
101 Full Time Employees Regular 353,901 346,524 (7,376) -2.08% 17.58% 11.89%
102 Full Time Employees Overtime 23,000 23,000 0 0.00% 1.14% 0.79%
103 Part Time Employees -Regular - 15,689 15,689. 0.00% 0.00% 0.54%
104 Temporary Employees Regular 38,820 46,490 7,670 19.76% 1.93% 1.60%
113 Sick Leave 4,175 3,884 (291) -6.98% 0.21% 0.13%
121 PERA Contributions 27,206 27,928 722 2.65% 1.35% 0.96%
122 FICA Contributions 26,818 27,006 188 0.70% 1.33% 0.93%
123 MEDICARE Contributions 6,272 6,316 44 0.70% 0.31% 0.22%
131 Health Insurance 47,895 55,800 7,905 16.50% 2.38% 1.92%
132 Dental Insurance 1,919 2,006 87 4.56% 0.10% 0.07%
133 Life Insurance 557 548 (9) -1.62% 0.03% 0.02%
135 Health Savings Plan 525 375 (150) -28.57% 0.03% 0.01
151 Workers Comp -Insurance 16,159 14,535 (1,624) -10.05% 0.80% 0.50%
100 Severance Compensation Funding - 1,728 1,728. 0.00% 0.00% 0.06%
201 Office Supplies 1,000 1,000 0 0.00% 0.05% 0.03%
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.23%
210 Operating Supplies -General 8,000 8,000 0, 0.00% 0.40% 0.27%
212 Operating Supplies -Fuel 34,860 34,860 0 0.00% 1.73% 1.20%
216 Operating Supplies -Chemicals 125,000 125,000 0 0.00% 6.21 % 4.29%
217 Operating Supplies -Uniforms 3,000 3,000 0 0.00% 0.15% 0.10%
221 Repair & Maint Sup -Equipment 3,500 8,500 5,000. 142.86% 0.17% 0.29%
223 Repair & Maint Sup - Bldgs 19,000 19,000 0 0.00% 0.94% 0.65%
224 Repair & Maint Sup -General 77,700 77,700 0 0.00% 3.86% 2.67%
240 Small Tools & Equipment 5,000 5,000 0 0.00% 0.25% 0.17%
241 Computer/Data Services 6,500 6,500 0 0.00% 0.32% 0.22%
260 Water Meters 47,450 54,325 6,875 14.49% 2.36% 1.86%
261 Pressure Reducers 10,900 10,900 0 0.00% 0.54% 0.37%
303 Professional Service -Engineering 27,500 63,000. 35,500 129.09% 1.37% 2.16%
312 Professional Service -Water Samples 22,700 24,500 1,800 7.93% 1.13% 0.84%
321 Communications 21,415 23,515 2,100 9.81% 1.06% 0.81%
322 Communications -Postage 4,200 4,200 0 0.00% 0.21% 0.14%
325 Communications -Utility Locations 9,394 9,594 200 2.13% 0.47% 0.33%
331 Training & Certification 16,350 17,350 1,000 6.12% 0.81% 0.60%
334 Car Allowance 900 - (900) -100.00% 0.04% 0.00%
354 Public Information 9,000 9,000 0 0.00% 0.45% 0.31
363 Insurance -Auto .3,550 3,550 0 0.00% 0.18% 0.12%
381 Utilities-Electric 221,600 221,600. 0 0.00% 11.01% 7.61%
383 Utilities -Gas 64,000 64,000 0 0.00% 3.18% 2.20%
384 Refuse Disposal 13,540 2,040 (11,500) -84.93% 0.67% 0.07%
401 Repair & Maint Service -Bldg 52,790 52,790 0' 0.00% 2.62% 1.81
404 Repair & Maint Service -Equip 1,850 1-,850 0 0.00% 0.09% 0.06%
Page 12 of 14
O~ PWpB
City of Prior Lake
F
Council W
orkshop 1
1.01.2010
~
v`~ 2011. Requested Budget Based on preliminarybudgetepproved 09.07.2010
Expenditure Details
,{.,
2010 2011 2010 .2071
2010 2011 $ Change. % Change % of % of %pf %of
Adopted Proposed 10 -11 10 -11 Subtotal Subtotal Total Total
DEBT SERVICE FUNDS
47000 Debt - 4,278,001 4,278,001 0.00% 0.00% 100.00%
DEBT SERVICE FUNDS TOTAL - 4,278,001 4,278,001 0.00% 0.00%. ...100.00% A.00% 100.00%
REVOLVING EQUIPMENT FUND
Police - 73,500 73,500 0.00% 0.00% 10.59%
Fire - 90,000 90,000 0.00% 0.00% 12.97%
Public Works - 530,256 530,256 0.00% 0.00% 76.43%
- 893,756 693,756 0.00% 0.00% 100.00% 0.00% 100.00%
REVOLVING EQUIPMENT FUND TOTAL - 693,756 693,756 0.00% 0.00% 100.00% 0.00% 1.00.00%
Page i i of 14
04 p~~$
,,
City of Prior Lake
2011 Requested Budget
Expenditure Details
~5°SP
Council Workshop 11.01.2010
Based on preliminary budget approved 09.07,2010
2010 2011 2010 2011
2010 2011 $ Change % Change % of % of % of % of
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.51
415 Rentals -Heavy. Equipment 16,675 16,675 0 0.00% 1.27% 1.25%
433 Dues & Subscriptions 700 700 0 0.00% 0.05% 0.05%
5301mprovements 120,000 110,000 (10,000) -8.33% 9.16% 8.23%
1,310,084 1,337,029 26,945 2.06% 100.00% 100.00% 10.81% 10.73%
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 8 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.39%
2,220 2,220 0 0.00% 2.44% 2.44%
27,000 27,000 0 0.00% 29.65% 29.65%
24,000 24,000 0 0.00% 26.35% 26.35%
1,327 1,327 0 0.00% 1.46% 1.46%
21,700 21,700 0 0.00% 23.83% 23.83%
10,820 10,820 0 0.00% 11.88% 11.88%
91,067 91,067 0 0.00% 100.00% 100.00% 0.75% '0.73%
1,804,653 1,830,888 26,235 1.45% 100.00% 100.00% 14.89% 14.70%
- 83,302 83,302 0.00% 0.00% 55.17%
- 6,039 6;039 0.00% 0.00% 4.00%
- 5,165 5,165 0.00% 0.00% 3.42%
- 1,208 1,208 0.00% 0.00% 0.80%
11,244 11,244 0.00% 0.00% 7.45%
- 480 480 0.00% 0.00% 0.32%
- 106 106 0.00% 0.00% 0.07%
- 300 300 0.00% 0.00% 0.20%
- 2,732 2,732 0.00% 0.00% 1.81
- 417 .417• 0.00% 0.00% 0.28%
1,000. 1,000 0 0.00% 2.25% 0.66%
15,000 15,000 0 0.00% 33.78% 9.93%
14,325. 10,350 (3,975) -27.75% 32.26% 6.85%
500 500 0 0.00% 1.13% 0.33%
1,610 1,650 40 2.48% 3.63% 1.09%
11,966 11,504 (462) -3.86% 26.95% 7.62%
44,401 150,996 106,595 240.07% 100.00% 100.00% 0.37% 1.21
44,401 150,996 106;595 240.07% 100.00% 100.00% 0.37% ' 1.21.%
1,780,600 1,763,565 (17,035) -0.96% 100.00% 100.00% 14.69% 14.16%
49999 Contingency reserve 69,000 (69,000) -100.00% 100.00% 0.00% 0.57% 0.00%
GENERAL FUND TOTAL 12,120,546 12,456,390 335,843 2.77% 100.00% 100.00% 100.00% 100.00%
Page 10 of 14
04 PRf0~
F City of Prior Lake
~ ~ 2011 Requested Budget
Expenditure Details
S°~P
Culture/Recreation
45100 Recreation
101 Full Time Employees Regular
103 Part Time Emlpoyees -Regular
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
135 HCSP Contributions
151 Workers Comp -Insurance
100 Severance Compensation Funding
201 Office Supplies -General
202 Office Supplies - Dup & Copy
203 Office Supplies -Printed Forms
207 Playground
220 Operating Supplies -Playground
259 Concessions
308 Instructor's Fees
321 Communications
331 Training & Certification
334 Car Allowance
404 Repair & Maint Service -Equipment
406 Repair & Maint Service -Clean
417 Community Events
433 Dues & Subscriptions
437 Misc Expense -General
45200 Parks
101 Full Time Employees Regular
102 Full Time Employees Overtime
103 Part Time Employees -Regular
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
135 HCSP Contributions
151 Workers Comp -Insurance
153 Mn Unemployment Insurance
100 Severance Compensation Funding
201 Office Supplies -General
210 Operating Supplies -General
212 Operating Supplies -Fuel
215 Operating Supplies -Shop Material
217 Operating Supplies -Uniforms
223 Repair & Maint Sup - Bldgs
224 Repair & Maint Sup -General
240 Small Tools & Equipment
313 Professional Services -Consultant
321 Communications
331 Training & Certification
343 Sign Advertising
363 Insurance -Auto
381 Utilities -Electric
383 Utilities -Gas
384 Refuse Disposal
387 Park Lighting
401 Repair & Maint Service - Bldgs
402 Repair. & Maint Service -Trails
Council.Workshop 11.01.2010
Based on preliminary budget. approved .09.07.2010
2010 2011 2070 2011
2010 2011 $ Change % Change % of % of % of % of
Adopted Proposed 10 -11 10 -11 Subtotal Subtotal Total Total
63,895 70,396 6,501 .10.17% 15.84% 17.48%
83,438 86,959 3,521 4.22% 20.68% 21.59%
89,697 80,300 (9,397) -10.48% 22.23% 19.94%
488 488 0 .0.00% 0.12% 0.12%
10,313. 11,408 1,095 10.62% 2.56% 2.83%
14,949 14,765 (184) -1.23% 3.70% 3.67%
3,496 3,453 (43) -1.23% 0.87% 0.86%
10,500 11,244 744 7.09% 2.60% 2:79%
480 480 0 0.00% 0.12% 0.12%
106 106 0 0.00% 0.03% 0.03%
.300 300 0 0.00% 0.07% 0.07%
7,604 6,930 (674). -8.87% 1.88% 1.Z2%
- 769' 769 0.00% 0.00% 0.19%
1,000 1,000 0 0.00% 0.25% 025%
250 250 0 0.00% 0.06% 0.06%
2,000 2,000 0 0.00% 0.50% 0.50%
15,000 10,000 (5,000) -33.33% 3.72% 2.48%
45,000 45,000 0 0.00% 11.15% 11.17% "
10,000 10,000 0 0.00% 2.48% 2.48%
15,000 15,000 0 0.00% 3.72% 3.72%
2,280 2,340 60 2.63% 0.57%. 0.58%
1,100 .1,100 0 0.00% 0.27% 0.27%
3,600 - (3,600) -100.00% 0.89% 0.00%
1,800 1,800 0 0.00% 0.45% 0:45%
1,955 1,955 0 0.00% 0.48% 0.49%
17,900 24,400 6,500 36.31% 4.44% 6.06%
350 350 0 ..0.00% 0.09% 0.09%
1,000 - (1,000) -100.00% 0.25% 0.00%
403,502 402,792 (709) -0.18% 900.00% 100.00% 3.33% 3.23%
416,688 447,501 30,813 7.39% 31.81% 33.47%
20,000 20,000 0 0.00% 1.53% 1-.50%
41,490 42,334 844 2.03% 3.17% 3.17%
171,190 171,190 0 0.00% 13.07% 12.80%
1,034 1,034 0 0.00% 0.08% 0.08%
34,413 36;963 2;550 7.41% 2:63% 2.76%
40,325 42,288 1;963 4.87% 3.08% 3.16%
9,431. 9,890 459 4.87% 0.72% 0.74%
64,032 69,216 5,184 8.10% 4.89% 5.18%
2,965 2,965 0 0.00% ' 0.23% 0.22%
706 706 0 0.00% 0.05% 0.05%
600 600 0 0.00% 0.05% 0.04%
22,988 22,338 (650). -2.83% 1.75% 1.67%
17,500 2,500 (15,000) 0.00% 1.34% 0.19%
- 2,449 2,449 0.00% 0.00% 0.18%
1,000 1,000 0 0.00% 0.08% 0.07%
47,500 47,500. 0 0.00% 3.63% 3.55%
65,300 65,300 0 0.00% 4.98% 4.88%
2,000 2,000 0 0.00% 0.15% 0.15%
6,330 4,555 (1,775) -28:04% 0.48% 0.34%
5,000 .5,000 0 0.00% 0.38% 0.37%
67,000 67,000 0 0.00% .5.11% 5.01%
5,000 5,000 0 0.00% 0.38% 0.37%
3,000 3,000 0 0.00% 0.23% 0.22%
4,200 2,808 (1,392) -33.14% 0.32% 0.21%
6,100 6,100 0 0.00% 0.47% 0.46%
7,850 7,850 0 .0.00% .0.60% 0.59%
4,545 4,545 0 0.00% 0.35% 0.34%
11,000 11,000 0 0.00% 0.84% 0.82%
8,000 8,000 0 0.00% 0.61% 0.60%
2,022 13,522 11,500 568.74% 0.15% 1.01%
38,000 38,000 0 0.00% 2.90% 2.84%
2,000 2,000 0 0.00% 0.15% 0.15°/a
10,000. 10,000 0 0.00% 0.76% 0.75%
Page 9 of 74
04 Y~~+P
,,
City of Prior Lake
2011 Requested Budget
Expenditure Details
~{~~
~650'~A
43400 Central Garage
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 -General
203 Office Supplies -Printed Forms
210 Operating Supplies -General
215 Operating Supplies -Shop Material
217 Operating Supplies -Uniforms
240 Small Tools & Equipment
331 Training & Certification
384 Refuse Disposal
412 Repair & Maint Service -General
433 Dues & Subscriptions
437 Misc Expense -General
451 Repair Sup -Parts (P/S)
452 Repair Sup -Parts (P/K)
453 Repair Sup -Parts (P/W)
454 Repair Sup -Parts (S/W)
461 Repair Sup -Equip (P/S)
462 Repair Sup -Equip (P/K)
463 Repair Sup -Equip (PlVV)
464 Repair Sup -Equip (S/W)
471 Batteries & Tires (P/S)
472 Batteries & Tires (P/K)
473 Batteries & Tires (P/VV)
474 Batteries & Tires (S/W)
481 Minor Serv -Contract (P/S)
482 Minor Serv -Contract (P/K)
483 Minor Serv -Contract (P/W)
484 Minor Serv -Contract (S/W)
491 Major Serv -Contract (P/S)
492 Major Serv -Contract (P/K)
493 Major Serv -Contract (P/W)
494 Major Serv -Contract (S/VV)
Total Public Works
Council Workshop 11.01.2010
Based on preliminary budgetapproved 09.07.2010
2010 2011 2010 2011
2010 2011 $ Change: % Change % of % of % of % of
Adopted .Proposed 10 -11 10 -11 Subtotal Subtotal Total Total
102,159 110,650 8,490 8.31% 30.96% 31.79%
3,026 3,026 0 0.00% 0.92% 0.87%
9,600 9,600 0 0.00% 2.91 % 2.76%
213 213 0 0.00% 0.06% .0.06%
7,710 8,241 531 6.89% 2.34% 2.37%
7,130 7,656 526 7.38% 2.16% 2.20%
1,667 1,791 123 7.38% 0.51% 0.51%
21,000 22,488 1,488 7.09% 6.36% 6.46%
960 960 0 0.00% 0.29% 0.28%
175 175 0 0.00% 0.05% 0.05%
7,452 3,976 (3,476) -46.64% 2.26% .1.14%
- 553 553 0.00% 0.00% 0.16%
500 500 0 0.00% 0.15% 0.14%
300 300 0 0.00% 0.09% 0.09%
6,000 6,000 0 0.00% 1.82% 1.72%
4,000 4,000 0 0.00% 1.21 % 1.15%
1,500 1,500. 0 0.00% 0.45% 0.43%
6,500 6,500 0 0.00% 1.97% 1.87%.
4,000 4,000 0 0.00% 1.21 % 1.15%
500 500 0 0.00% 0.15% 0.14%
1,600 1,600 0 0.00% 0.48% 0.46%
2,900 2,900 0 0.00% 0.88% 0.83%
900 900 0 0.00% 0.27% 0.26%
11,000 11,000 0 0.00% 3.33% 3.16%
9,500 15,000 5,500 .57.89% 2.88% 4.31%
11,500 11,500 0 0.00% 3.48% 3.30%
2,000 2,000 0 0.00% 0.61% 0.57%
8,300 7,000 (1,300) -15.66% _ 2.52% 2.01%
22,000 22,000 0 0.00% 6.67% 6.32%
27,300 30,000 2,700 9.89% 8.27% 8.62%
4,500 .7,400- 2,900 64.44% 1.36% 2.13% '
9,000 9,000 0 0.00% 2.73% 2.59%
8,500 8,500 0 .0.00% 2.58% 2.44%
7,500 7,500 0 0.00% 2.27% 2.15%
2,000 2,000 0 0.00% 0.61% 0.57%
4,000 4,000 0 0.00% 1.21% 1.15%
1,700 1,700 0 0.00% 0.52% 0.49%
2,200 2,200 0 0.00% 0.67% 0.63%
1,000 1,000 0 0:00% 0.30% 0.29%
4,700 4,700 0 0.00% 1.42% 1.35%
1,500 1,500 0 0.00% 0.45% 0.43%
1,000 1,000 0 0.00% 0.30% 0.29%
1,000 1,000 0 0.00% 0.30% 0.29%
329,994 348,030 18,037 5.47% 100.00% 100.00% 2.72% 2.79%
1,737,675 1,826,962 89,287 5.14% 100.00% 100.00% 14.34% 14.67%
Page 8 of 74
. 04 YRip~
,,
City of Prior Lake
Council Workshop 11.01.2010
~~ 2011 Requested Budget Based on preliminary budget approved 09.07.2010
Expenditure Details
~850~r
2010 2011 2010 2011
2010 2011 $ Change % Change % of % of % of % of
Adopted Proposed 10 -17 10 -11 Subtotal Subtotal Total Total
~-
Public Works
43050 Engineering
101 FuII Time Employees Regular 228,596 .263,500 34,904 15.27% 60.96% 62.90%
102 Full Time Employees Overtime 1,500 5,000 3,500 233.33% 0.40% 1:19%
103 Part Time Employees -Regular 27,375 28,289. 914 3.34% 7.30% 6.75%
113 Sick Leave 4,610 4,610 0 0.00% 1.23% 1.10%
121 PERA Contributions 18,336 21,517 3,181. 17.35% 4.89% 5.14%
122 FICA Contributions 16,584 18,687 2,103 12.68% 4.42% .4:46%
123 MEDICARE Contributions 3,878 4,370 492 12:68% 1.03% 1.04%
131 Health Insurance 26,250 35,032 8,782 33.46% 7.00% 8.36%°
132 Dental Insurance 1,353 1,519 166 .12.28% 0.36% 0.36%
133 Life Insurance 290 320 30 10.46% D.08% 0.08%
135 HCSP Contributions 450 450 0 0.00% 0.12% 0.11
151 Workers Comp -Insurance 1,295 1,597 302 23.32% 0.35% 0.38%
100 Severance Compensation Funding - 1,432 1,432 0:00% -0.00% 0.34%
201 Office Supplies -General 3,250 3,250 0 0.00% 0.87% O.Z8%
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.64%
212 Operating Supplies -Fuel 3,000 3,000 0 0.00% 0.80% .0.72%
303 Professional Service -Engineering 17,500 11,000 (6,500) - -37.14% 4.67% 2.63%
321 Communications 2,160 2,160 0 0.00% 0.58% 0.52%
331 Training & Certification 2,600 2,600 0 0.00% 0.69% 0.62%
334 Car Allowance 5,400 - (5,400) -1.00.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:48%
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
375,022 418,92$ 43,906 11.71% 900.00% 100:00% 3.09% 3:$6%
43100 Street
101 Full Time Employees Regular 142,058 135,544 (6,514) -4.59% 13.76% 12:79%
102 Full Time Employees Overtime 23,000 23,000 0 0.00% 2.23% 2.17%
104 Temporary Employees -Regular. - 10,000 10,000 0.00% 0.00% 0.94%
113 Sick Leave 410 - (410) -100.00% 0:04% 0.00%
121 PERAContributions 12,038 11,494 (543) -4.51% 1:.17% 1:08%
122 FICA Contributions 10,259 10,450 191 1.86% 0.99% 0.99%
123 MEDICARE Contributions 2,399 2,444 45 1.86% 0'.23% 0.23%
131 Health Insurance 23,334 23,364 30 0.13% 2'.26% 2.20%
132 Dental Insurance 1,248 1,090 (158) -1.2.69% 0.12% .0.10%
133 Life Insurance 292 263 (29) -9.91% -0.03% 0.02%
151 Workers Comp -Insurance 13,817 11,950 {1,867) -13.51% 1.34% 1.13%
100 Severance Compensation Funding - 678 678 .0.00% 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 58,100 0 0.00% 5:63% 5.48%
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.25%
219 Operating Supplies -Snow & Ice 67,340 67,261 (79) -0.12% 6.52% .:6.35%
223 Repair&MaintSup-Bldgs 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.38%
240 Small Tools & Equipment 4,000 4,000 0 0.00% 0.39% 0.38%
303 Professional Service - 6,000 6,000 0.00% `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.33%
381 Utilities -Electric 1,900 1,900 0 0.00% 0.18% 0.18%
384 Refuse Disposal 900 900 0 0.00% 0.09% 0:08%
386 Street Lighting 190,500 190,500 0 0.00% 18.45% 17.97%
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.30%
415 Rentals -Heavy Equipment 12,640 12,640 0 0.00% 1.22% 1:19%
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,06Q,003 27,344 2.65% 100.00% 100.00% 8.52% 8.51%
Page 7 of 14
OF P~~$
F
City of Prior Lake
Council Workshop 11.01,2010
v' ~~ 2011 Requested Budget Based on preliminary budget approved 09.07.2010
Expenditure Details
,y,
'~rvNfiS°~P
2010 2011 2010 2011
2010 2011 $ Change % Change % of % of % of % of
Adopted Proposed 10 -11 10 -11 Subtotal Subtotal Total Total
212 Operating Supplies -Fuel
217 Operating Supplies -Uniforms
218 Operating Supplies -Medical
221 Repair & Maint Sup -Equipment
223 Repair & Maint Sup - Bldgs
240 Small Tools & Equipment
306 Training Expenses
321 Communications
331 Training & Certification
354 Public Information
363 Insurance Auto
381 Utilities -Electric
383 Utilities -Gas
384 Refuse Disposal
401 Repair & Maint Service - Bldgs
404 Repair & Maint Service -Equipment
406 Repair & Maint Service -Clean
433 Dues & Subscriptions
437 Misc Expense -General
520 Buildings & Structures
580 General Equipment
42400 Building Inspection
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 HCSP Contributions
151 Workers Comp -Insurance
100 Severance Compensation Funding
201 Office Supplies -General
203 Office Supplies -Printed Forms
210 Operating Supplies -General
212 Operating Supplies -Fuel
217 Operating Supplies -Uniforms
240 Small Tools & Equipment
321 Communications
331 Training & Certification
334 Car Allowance
363 Insurance -Auto
433 Dues & Subscriptions
437 Misc Expense -General
42500 Emergency Management
306 Training Expenses
381 Utilities -Electric
404 Repair & Maint Service - Bidgs
42700 Animal Control
311 Animal Control Contract
Total Public Safety
15,000 10,200 (4,800) -32.00% 1.74% 1.18%
21,500 27,500 6,000. 27.91% 2.49% 3.18%
1,800 1,800 0 0.00% 0.21% 0.21%
5,400 -8,000 2,600 48.15% 0.63% 0.93%
9.,000 9,000 0 0.00% 1.04% 1.04%
5,400 6,000 600 11.11% 0.63% 0.69%
20,000 20,000 0 0.00% 2.32% 2.31%
8,860 10,080 1,220 13.77% 1.03% 1.17%
4,950 4,950 0 0.00% 0.57% 0.57%
5,850 6,500 650 11.11% 0.68% 0.75%
18,340 18,340 0 0.00% 2.13% 2.12%
30,000 32,000 ' 2,000 6.67% $.48% 3.70%
37,800 28,000 (9,800) -25.93% 4.38% 3.24%
927 1,100 173 18.66% 0.11% 0.13%
40,620 35,345 (5,275) -12.99% 4.71% 4.09%
11,610 13,500 1,890 16.28% 1.35% 1.56%
8,000 6,000 (2,000).. -25.00% 0.93% 0.69%
1,500 1,500 0 0.00% 0.17% 0.17%
9,000 7,000 (2,000) -22.22% 1.04% 0.81%
50,000 43,000 (7,000). -14.00% 5.80% 4.97%
15,000 15,000. 0 0.00% 1.74% 1.73%
862,159 864,725 2,566 0.30% 100.00% 100.00% 7.11% 6.94%
268,497 291,940 23,442 8.73% 73.80% 74.79%
2,067 2,067 0 0.00% 0.57% 0.53%
19,359 21,166 1,807 9.33% 5.32% 5.42%
17,054 18,228 1,174 6.89% 4.69% 4.67%
3,988 4,263 275 6.89% 1.10% 1.09%
33,393 36,123 2,730. 8.18% 9.18% 9.25%
1,821 1,821 0 0.00% 0.50% 0.47%
375 375 0 0.00% 0.10% 0.10%
375 375 0 0.00% 0.10% 0.10%
1,471 1,655 184. 12.49% 0.40% 0.42%
- 1:,437 1,437 0.00% 0.00% 0.37%
1,500 1,500 0 0.00% 0.41% 0.38%
1,000 1,000 0 0.00% 0.27% 0.26%
700 500 (200) -28.57% 0.19% 0.13%
4,050 3,000 (1,050) -25:93% 1.11% 0.77%
100 200 100 100.00% 0.03% 0.05%
500 400 (100) -20.00% 0.14% 0.10%
720 720 0 0.00% 0.20% 0.18%
900 900 0 0.00% 0.25% 0.23%
4,500 - (4,500) -100.00% 1.24% 0.00%
525 525. 0 0.00% 0.14% 0.13%
900 900 0 0.00% 0.25% 0.23%
- 1,250 1,250 0.00% 0.00% 0.32%
363,796 390,345 26,549 7.30% 100.00% 100.00% 3.00% '3.13%
500 500 0 0.00% 6.67% 6.67%
1,500. 1,500 0 0.00% 20.00% 20.00%
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%
35,844 25,650 ' (10,194) -28.44% 100.00% 100.00% 0.30% 0.21%
4,341,613 4,427,862 86,249 1.99% 100.00% 100.00% 35.82% 35.55%
Page 6 of 14
p4 YRtp$ s•5~~
F~t+l
"MV66°t~
Public Safety
Council Workshop 11.01.2010
Based on preliminaryrbudgetapproved 09.07.2010
.2010 2011 2010 2011
2010 2011 $ Change % Change % of % of % of % of
Adopted Proposed 10 -11 10 - 71 Subtotal Subtotal Total Total
42100 Police
101 Full Time Employees Regular 1,735,332 1,838,669 103,337 5.95%°- 56.48% 58.56°/a
102 Full Time Employees Overtime 132,418 132;418 0 0.00% 4.31 % 4.22%
103 Part Time Employees Regular 96,462 101,779 5,317. 5.51%° 3.14% 3.24%
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.80%
113 Sick Leave 13,608 13,608 0 0:00% 0.44% 0.43%
114 Educational Reimbursement 15,000 15,000 0 0.00% 0.49% 0.48%
119 Clothing Allowance 18,690 18.,543 (147) -0.79% 0.61% 0.59%
121 PERA Contributions 273,316 285372 12,056 4.41% 8.90% 9:09%
122 FICA Contributions 13,886 14,867 981 7.07% 0.45% 0:47%
123 MEDICARE Contributions 29,154 30,628 1,474 5.06% 0.95% 0.98%
131 Health Insurance 188,136 204,216 16,080 8.55% 6.12% 6.50%
132 Dental Insurance 10,206 10,206 0 0.00% 0.33% 0.33%
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.09%
151 Workers Comp -Insurance 72,490 62,970 (9,521) -13.13% 2.36% 2.01%
100 Severance Compensation Funding - 10,103 . 10,103 0.00% 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. 58,400- 0 0.00% 1.90% 1.86%
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.33%
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 1`1,265 0 0.00% 0.37°/u 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 .34,000 0 0.00% 1.11 % 1.08%
383 Utilities -Gas 28,000- 28,000 0 0.00% 0.91 % 0.89%
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.40% '..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,439,642 67,327 2.49% 100:00% 100.00% 25.35% 25.21%
42200 Fire
101 Full Time Employees Regular 83,048 89,982 6,934 8.35% 9:63% 10.41%
117 Volunteer Compensation 174,210 174,210 0 0.00% 20.21 % 20.15%
121 PERA Contributions 11,710 12,957 1,248. 10.65% .1.36% 1.50%
122 FICA Contributions 10,801 10,801 0 0.00% 1.25% 1.25%
123 MEDICARE Contributions 3,730 3,831 101 2.70% 0.43% 0.44%
124 Pension Contribution 98,000 100,105 2,105 2.15% 11.37% 11.58%
125 Insurance Premium Contribution 123,000 423,000 0 0.00% 14.27% 14.22%
131 Health Insurance 10,500 11,244 744 7.09% 1.22% 1.30%
132 Dental Insurance 480 480 0 0.00% 0.06% 0.06%
135 HCSP Contributions 75 300 225 300.00% 0.01 % 0.03%
151 Workers Comp -Insurance 18,703 25,1:65 6,462 34.55% 2.17% 2.91%
100 Severance Compensation Funding - 450 450 0.00% 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.78%
Page 5 of 74
City of Prior Lake
2011 Requested Budget
Expenditure Details
04 PR(p~ '.
,, City of Prior Lake
~ ~ 2011 Requested Budget
Based Council Workshop 11,01.2010
on preliminary budget approved 09.07.2010
Expenditure Details
5°2P
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.38%
321 Communications 15,300 15,300 0 0.00% 3.48% 3.51%
322 Communications -Postage 19,350 19,350 0 0.00% 4.41% 4.44%
361 Insurance -Liability 95,200 88,873 (6,327) -6.65% 21.68% 20.37%
362 Insurance -Property 128,000 .130,359 2,359 1.84% 29.15% 29.88%
381 Utilities -Electric 50,000 50,000 0 0.00% 11.39% 11.46%
383 Utilities -Gas 52,000 52,000 0 0.00% 11.84% 11.92%
384 Refuse Disposal 1,327 1,327 0 0.00% 0.30% 0.30%
401 Repair & Maint Service - Bldgs 22,824 26,672 3,848 16.86% 5.20% 6.11
404 Repair & Maint Service -Equipment 11,205 8,405 (2,800) -24.99% 2.55% 1.93%
406 Repair & Maint Service -Clean 22,555 22,555 0 0.00% 5.14% 5.17%
413 Rentals -Office Equipment 5,365 5,365 0 0.00% 1.22% 1.23%
570 Office Equipment & Furnishings 10,000 10,000 0 0.00% 2.28% 2.29%
439,126 436,206 (2,920) -0.66% 100.00% 100.00% 3.62% 3.50%
Total Generaf Government 2,342,604 2,456,117 113,573 4.85% 100.00% 100.00% 19.33% 19.72%
Page 4 of 14
~ City of Prior Lake Council W orkshop 11.01.2010
C ~~ i 2011: Requested Budget Based on preliminary budget approved 09.07.2010
Expenditure Details
~fi5°SA
.2010 2011 2010 `2011
2010 2011 $ Change % Change % of % of % of % of
Adopted Proposed 10 -11 10 -11 Subtotal Subtotal Total Total
41830 Communications
101 Full Time Employees Regular 59,401 63,098 3,697 6.22% 55.32% 55.80%
103 Part Time Employees Regular 5,344 6,460 1,116 20.88% 4.98% 5.71%
121 PERA Contributions 4,158 4,575 417 10.02% 3.87% 4.05%
122 FICA Contributions 4.,089 4,313 224 5.48% 3.81 % - 3.81
123 tv1EDiCARE Contributions 956 1,009- 52 5.48% 0.89% 0.89%
131 Health Insurance 5,508 6,060 552 10.02% 5.13% 5.36%
132 Dental Insurance 305 305 0 0.00% 0.28% 0.27%
133 Life Insurance 106 106 0 0.00% 0.10% 0.09%
135 HCSP Contributions 300 .300 0 0.00% 0.28% 0.27%
151 Workers Comp -Insurance 505 492 (13) -2.54% 0.47% -0.44%
100 Severance Compensation Funding: - 309 309 0.00% A.00% 0.27%
201 Office Supplies -General 500 • 500 0 0.00% 0.47% 0.44%
203 Office Supplies -Printed Forms 1,000 1,500 500 .50.00% .0.93% 1.33%
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.33%
334 Car Allowance 1,200 - (1,200) -100.00% 1.12% 0.00%
354 Public Information 18,000 18,000 0 0.00% 16.76% 15.92%
404 Repair & Maint Service -Equipment 1,000 1,000 0 0.00% 0.93% 0.88%
433 Dues & Subscriptions 510 550 40 7.84% 0.47% 0.49%
437 Misc Expense -General 2,500 2,000 (500) -20.00% 2.33% 1.77%
107,382 113,076 5,695 5.30% 100.00% ` 100.00% 0.89% 0.91
41910 Comm Development/Natural Res
101 Full Time Employees Regular 181,602 200,489 18,888 10.40% 71.90% 72.60%
121 PERA Contributions ?3,033 14,535- 1,503 11.53% 5.16% 5.26%
122 FICA Contributions 11,483 12,430 948 8.25% 4.55% 4.50%
123 MEDICARE Contributions 2,685 2,907 222 8.25% 1.06% 1.05%
131 Health Insurance 26,508 28,548 2,040 .7.70% 10.50% 10.34%
132 Dental Insurance 1,090 1,090 . 0 0.00% 0.43% 0.39%
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 Workers Comp -Insurance 1,137 1,235 98 8.61% 0.45% 0.45%
100 Severance. Compensation. Funding. - 984 984 0.00% 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% 020% 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.54%
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.6~%
437 Misc Expense -General 250 250 0 0.00% 0.10% 0.09%
252,563 276,166 23,603 9.35% 100.00% 100.00% 2.08% 2.22%
41920 Technology
210 Operating Supplies -General 2,065 2,065 0 0.00% 1.41 % 1.33%
306 Training Expenses 5,000 4,000 (1,000) -20.00% 3.41% 2.57%
309 Software Design 28,200 19,700 (8,500) -30.14% 19.24% 12.68%
313 Professional Services-Consultant 41,800 61,800 20,000 47.85% 28.51% 39.78%
321 Communications 2,702 1,080 (1,622) -60.03% 1,84% 0.70%
407 Software Service Contract 27,855 28,775 920 3.30% 19.00% 18.52%
408 Hardware Service Contract 5,000 3,500 (1,500) -30.00% 3.41% 2.25%
580 General Equipment 33,975 34,420 445 1.31 % 23.18% 22.16%
146,597 $55,340 8,743 5.96%_ 100.00% 100.00% 1,21% 1.25%
Page 3 of 14
O~ PWp~
F City of Prior Lake
Council W
orkshop 11.01.2010
~~ 2011 Requested Budget Based on preliminary budget approved 09.07.2010
Expenditure Details
5°tP
2010 2011 2010 2011
2010 2011- $ Change % Change % of % of % of % of
Adopted Proposed 10 -11 70 -11 Subtotal Subtotal Total Total
41520 Finance
101 Full Time Employees Regular 209,609 225,046 15,437 7.36% 69.79% 72.74%
104 Temporary Employees Regular 5,535 5,500 (35) 0.00% 1.84% 1.78%
113 Sick Leave 1,113 1,113 0 0.00% 0.37% 0.36%
121 PERA Contributions 14,828 16,316 :1,488 10.03% 4.94% 5.27%
122 FICA Contributions 13,705 14,363 657 4.80% 4.56% 4.64%
123 MEDICARE Contributions 3,205. 3,359 154 4.80% 1.07% 1.09%
131 Health Insurance 21,516 23,364. 1,848 8.59% 7.16% 7.55%
132 Dental Insurance 1,090 1,090 0 0.00% 0.36% 0.35%
133 Life Insurance 299 299 0 0.00% 0.10% 0.10%
135 HCSP Contributions 600 600 0 0.00% 020% 0.19%
151 Workers Comp -Insurance 1,687 1,633 (53) -3.17% 0.56% 0.53%
100 Severance Compensation Funding - 1,101 1,101 0.00% 0.00% 0.36%
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.60%
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) 0.00% 4.16% 2.42%
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 260 20 8.33% 0.08% 0.08%
437 Misc Expense -General 1,500 1,275 (225) -15.00% 0.50% 0.41%
300,327 309,379 9,052 3.01 % 100.00% ~ 100.00% 2.48% ' 2.48%
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.95%
41610 Legal
304 Legal Fees 199,000 199,000 0 0:00% 51.69% 51.69%
305 Prosecution .186,000 186,000 0 0.00% 48.31% 48.31%
385,000 385,000 0 0.00% 100.00% 100.00% 3.18% 3.09%
41820 Personnel
101 Full Time Employees Regular 82,425 89,042 6,617 8.03% 62.66% 61.12%
113 Sick Leave 2,000 2,000. 0 0.00% 1.52% 1.37%
121 PERA Contributions 5,770 6,456 686 11.89% 4.39% 4.43%
122 FICA Contributions 5,458 5,645 187 3.43% 4.15% 3.87%
123 MEDICARE Contributions 1,276 1,320 44 3.43% 0.97% 0.91%
131 Health Insurance 5,508 16,060 10,552 191.58% 4.19% 11.02%
132 Dental Insurance 305 305 0 0.00% .0.23% 0.21%
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 630 (29) -4.39% 0.50% 0.43%
100 Severance Compensation Funding - 427 427 0.00% 0.00% 0.29%
201 Office Supplies -General 500 500 0 0.00% 0.38% 0.34%
314 Professional Services -General .12,500 11,500 (1,000) -8.00% 9.50% 7.89%
321 Communications 350 350 0 0.00% 0.27% 0.24%
331 Training & Certification 800 1,050 250 31.25% 0.61% 0.72%
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.43%
437 Misc Expense -General 5,000 5,000 0 0.00% 3.80% 3.43%
131,540 145,674 14,134. 10.75% 100.00% 100.00% 1.09% '1.17%
Page 2 of 14
04 PR7p~
~ City of Prior Lake
D ~ 2011 Requested Budget
Expenditure Details
~N650~*
GENERAL FUND
General Government
41110 Mayor 8~ Council
65,453 67,365 1,912 2.92%- 100.00% 100.00% 0:54% 0.54%
5,000 5,000 0 0:00% 71.43% 71.43%
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%
176,463 189,722 13,259 7.51% 50.19% 47.38%
36,496 44,806 8,310 22.77% 10.38% 11.19%
16,209 19,477 3,268 20.16% 4.61 % 4.86%
2,770 2,770 0 0.00% 0.79% 0.69%
16;034 18,417 2,383- 14:86% 4.56% 4.60%
12,995 13,705 710 5.47% 3.70% 3.42%
3,518 3,784 266 7.57% 1.00% .0.95%
4,097 4,220 123 3.00% 1.17% 1'.05%
16,008 17,304 1,296. 8:10% 4.55% 4.32%
960 960 0 0.00% 0.27% 0.24%
1,906 1,906 0 0.00% 0.54% 0.48%
600 600 0 0.00% 0.17% 0.15%
1 841 1 832 (9) -0 51% 0 52°/ 0' 46°/
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 0.00% 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%
41130 Ordinance
351 Legal Notice
352 Ordinance Publication
47320 Administration
101 Full Time Employees Regular
103 Part Time Employees Regular
112 Longevity
113 Sick Leave
121 PERA Contributions
122 FICA Contributions
.123 MEDICARE Contributions
126 Deferred Comp Contribution
131 Health Insurance
132 Dental Insurance
133 Life Insurance
135 HCSP Contributions
151 Workers Comp -Insurance
100 Severance Compensation Funding
201 Office Supplies -General
202 Office Supplies - Dup & Copy
203 Office Supplies -Printed Forms
314 Professional Services -General
321 Communications
331 Training & Certification
334 Car Allowance
433 Dues & Subscriptions
437 Misc Expense -General
570 Office Equipment & Furnishings
41330 Boards & Commissions
115 EDA/Planning Commission
121 PERA Contributions
122 FICA Contributions
123 MEDICARE Contributions
151 Workers Comp -Insurance
331 Training & Certification
41410 Elections
116 Election Judge Salaries
210 Operating Supplies -General
331 Training & Certification
Council Workshop 11.01.2010
Based on preliminary budget approved 09.07.2010 ,
2010 2011 2010. .2071
2070 2011 $ Change % Change % of % of % of % of
Adopted. Proposed 10 -11 10 -11 Subtotal Subtotal Total Total
,..
-
1;258
1,258' o
0.00% o.
-0.00% o
0:31
1,000 1,000 0 0.00% 0.28% 0.25%
2,710' 2,710. 0 0.00% 0.77% 0.68%
365 300 (65) -17.81% 0.90% 0.07%
21,780 41,780 20,000. 91.83% 6.19% 10.43%
900 900 0 0.00% 0.26% 0.22%
1,250 1,250 0 0.00% 0:36% 0.31%
6,600 5,400 (1;200) -18.18% 1.88% 1'.35%
25,575 21,863 (3,712) -14.51% 7.27% 5:46%
1,500 - (1,500) -100.00% 0.43% 0.00%
- 4,500 4,500. 0.00%. 0:00% 1.12%
351,576 400,463 48,887 13:91% 100.00% 100.00% 2.90% 3.21%
11.,025 12,000 975 8.84% 88.39% 89.23%
101 101 0 0.00% 0.81 % 0.75%
684 684 0 0.00% 5.48% 5.08%
160 160 0 0.00% 128% 1.19%
4 4 1 0.00% 0.03% 0.03%
500 .500 0 0.00% 4:01% 3.72%
12,474 .13,449 976 7.82% 100:00% 140.00% 0.10% 0.11
3,787 (3,787) -100.00% 52.84% 0.00%
3,080 - (3,080) -100.00% 42.97% 0.00%
300 (300) -100.00% 4.19% 0.00%
7,167 (7,167) -100.00% 100.00% 0.00% 0.06% 0.00%
Page 1 of 14