HomeMy WebLinkAbout08/13/2012 Council Packett
WORK SESSION AGENDA
CITY OF LINO LAKES
Monday, August 13, 2012
CITY COUNCIL BUDGET WORK SESSION
Council Work Room (not televised)
7:30 P.M.
1. Budget Gap Analysis (Al Rolek)
2. Projected Voting Equipment System Costs
3. Potential Revenue Sources
4. Transfer of Expenses from Utilities (e.g. motor fuels, repairs)
5. Positions Eliminated 2010 -2012
6. Future Tax Cap
7. Council Direction
8. Adjournment
• as
' Jean Viger
From: Cindy Reichert <Cindy.Reichert @co.anoka.mn.us>
Sent: Monday, August 06, 2012 4:56 PM
To: AMY OEHLERS; Barb Held; Barb Nelson; Cathy Sorensen; CORRIE LADOUCER; DEB
SKOGEN; DORIS NIVALA; Elizabeth Mursko; EMMY ROBINSON; GINGER BERG; JANE
CROSS; Jean Viger; JO THIELING; JUDY HANNA; LINDA PITCHFORD; Mary Vinzant;
MICHELLE HARTNER; PATTY MUSCOVITZ; PEGGY BAUMAN; RUTH NELSEN; SHARON
AYSHFORD; SHERRY FISKEWOLD ( SFISKEWOLD @CI.OAK- GROVE.MN.US); TERESA
BENDER; Wanda Brown; Wendy Warren
Subject: Projected Voting Equipment System Costs
Attachments: Book1.xlsx
Attached are the mot current projections for cost of the voting equipment system for years 2013 and beyond. I had
passed these out some time ago, but a couple of you have asked for the "most recent" so here is another copy. If it is
changed from the last figures I gave you, the change should be minimal.
We are so close to next Tuesday's election, I really don't have time to be more elaborate in this message. Feel free to
call with any questions you have, but I plan on getting back to this after the primary.
Thanks for your patience!
NOTICE: Unless restricted by law, email correspondence to and from Anoka County government offices may
be public data subject to the Minnesota Data Practices Act and /or may be disclosed to third parties.
1
w
FA CO In CO IN ri In m n Q In 00 00 et In 00 Q ti 01 m m
n Q ID ri m n 0 O1 M 10 IN .- I ri IN O- N CO IN ri rV
IN IN ' ID N Q IN O CO ID O N Al N Al O N N Q l0 Q N
01 0 01 0.1. Q' C 00 ID Q 01 M mi. n Q Q n y7 V 00 10 Ill 01 m
U 0 Q Al 01 tel 0 l0 N Al m 3-4 N
O N
0.
✓ T V1 an OF V1 to 01 ,n 1n .n in UT an UT Oman UT an +n V1 UT N
Q 01 Al ID - O - l0 1n 0 el n 00 N In Q Q 01 00 l0 N In M
Ip C Q ri 0 CO l0 O CO M n 01 r1 N 0 Al Al ID Al N N n O1 e-I
4)00 n .M O al 01 00 n ri Q In n 00404110.40003-400
Y • O1 00 .-1 O1 00 .-i .I1 00 00 me r-1 V ri 41 1/1 r-1 O a0 m 41 l0 40
O 0 tD m N N Q M N ID Al Q ri ri ri In Al Q
,..I d .-1 e-I n
10 e
0 0
I-- u
U T UT UT V1 UT VT an an. UT VT UT UT UT UT .n Ut VT VT UT VT 1n an
CO 111 N CO 01 e•■ 01 0 N In N 0 O1 M N m N ■•1 l0 ri n LO
IL N 01 01 N ,--■ Q M n CO 01 0 I -I M 00 r-I l0 CO .--1 ri N LO O 01
E l0 N .-I M 01 N 00 CA Al Cl CO 00 N LA O Al ri 0 01 In CO 00
N to N n < r. .-1 O 131 - N lO m VI a-i e-1 N Ill ti N AI
n
I as
3 i
>
tA 1/T a/T V1 1/T VT N VF VT UT 14 ul u< UN N N VT OF V} UT VT UT
l0 Vl O m N al CO N IN .•-I l0 01 In Q 00 01 N M LO N Q O
01 N - Al N 341 M O 00 LO O 1n 00 In 00 0 10 LA 01 n ei m n 0
E In N .-i 0 01 N n 01 r✓- 00 40 n ri In O1 N 0 01 00 Y1 n m
1s-' t N IN C et 4 R N r. l0 ,I. Q .--i r-1 e•1 N .4 r1 W
O
IA 0.
-7 >-
VI 1/T UT VT UT 14-14 UT (4 In UT VT UT VT UT 1M W 7n VT Vl UT UT VT
01 b1 CO .-i CO r1 O 00 •i 0 O 1n M l0 n .-1 40 11 Al 0 01 l0
N o 0 LO ri In r1 01 Al Q al ri 01 0 00 O1 al Q n Q m .••I Q m
E Q - r-I CO 01 r-I n 01 00 -00 In n e-I Q CO Al 0 01 n 111 n rti
2.' u. N N Q nM-I` ei V 'Q-I N .0 m Q .-1 ri r-1 u1 .-1 ri 0
▪ O
IA a 0
7 Y
N VT 01 UT VT uF UT UT N UT UT UT 1/1 VT UT UT UT UT UT UT UT UT 1R
M 01 LO 01 N 01 Q rt 01 O1 0 n 01 IN n CO IN 0 00 .N IN Q
N 00 n n .-1 al 0 lD m m ei LA n M n 00 0 ri an rti N 00 - n
N 0 .-I In Cr, e-1 30 01 l0 n Q LO .--I Q CO N O 01 CO Q n IO
Y t• o N n D emi ri Q e ▪ N l0 m Q .-1 r-I ri IIl ri rl 00
O
IA O. m
7 Y
w N N VT VT 14 VT UT VT VT VT VT VT UT UT 14 N 14 VT VT to UT 1n
N N Q n 01 Al 00 CO Al O 01 l0 n O O ri N M Q1 Al N l0
00 01 0 n N ei 0 00 1n t0 ri ri N n 00 n 00 et O Q CO Q LO 01 l0
E N O ei Q 00 r-1 In 01 Q n M In AL Q n Al 0 00 Ill Q ID 1n
• t N . Q rm-1, .-? V ti N IDD rr1 Q ri r-1 - LA' 00 r-I' At-
0. W
I' Y
n
VF V} iR W VT W al}- VT UT LA. V! VT iA VT VT a/T N VT UT VT V! W
N al N LO M N lD .-I Q r1 Q Al Q Al Q O Al 01 D1 V1 N Al
01 Q Q .-1 ID n rr1 CO 0 In n 10 N n n +n CO N Q Q FA ID n
E O 01 .-1 ei 00 .-i Q 01 - LO Al In .-i Q l0 3 O 00 Q Q IO ri
ice-' to N n rl1 .m1` ri Q .Q-I` N l0 m Q r-1 ei N LA .-1 ri l0
O
IAo.
0.. 001
O }
In V• VT VT UT V} VT ut UT 01 UT VT 1n N UT N ur an UT an N UT
in 111 3i Q r-■ n Cr ON CO Q n Al r•1 N O Al Dl M Q 1n 01 n
Q al ri 00 LO ri N 00 Ill m n N. -n LO 01 ID 0- N n r•1 m .-1
E . N 01 a0 ri 01 a0 .-1 Q 00 01 l0 .-i Q .-1 Q In ri O 00 m Q ID ri
N t N LD FA .N-I ri Q 01 N LO m Q r•1 .-i r-1 In •-■ •-1- n
11, IA 0. W
O )-
U1 VT VT 4.4 VI- VT 01 VT VT 01 N UT 14 N VT in VT VT VT N VT 01. i/T
N LO 01 In l0 IN ID m ■i CO CO Al CO n 01 m ei r-I 01 O O. O
01 In N N 0 In Q 01 Q n r-I 00 10 ei LO Ill 0 Q 01 Cr, n 01 :-■ 01
E LL r.1 00 00 r1 n 00 o m 00 r In O Q r•1 Q Il) ri Ol n N m lD n
y t+ N 10 rt1 IN 9-1 Q rm-1 N l0 re Q e•I r-I V1 e-1 r-i n
O
IA 0. v
r
to 1n UT VT UT N in UT V} 14 VT VT UT VT UT UT
N Q
01 n 0 CO M CO 00 LO N 1n 00 l0 LID V1 Q
E LL ..{- n n ,-1 In a0 0 N 00 Y1 Ill 01 m .-1 Q Q
i t+ N lO m .N -I N Q • N IIT M Q
IA C W
a r
01 .L4-4/1. to U?. N 44
N DO 1.11
N n l0 O n 00 00
1-1 01 IN Al M In n
N l H r1 N
VT UT VT N VT 1" UT UT 14 UT VT V1 UT UT VT VT UT UT VT UT UT
% oo ri ri N ul O .rl 0 01 m O1 0 0 0 0 0 l0 I11 m n n
C LL n ti n n V1 N In r.1.-, 0 01 00 m H O lD to Ill n ID ei 1n m
CC Q U1 m In n co In O to O1 N ti M 01 n ID r1 Q 01 O Q
N t N V N 00 N 01 .-1 t1.1 N N r1 .1.■ ti 0
O
,O O. w
LA • T VT UT VT in N VT VT N VT uti VT VT VT VT u! VT VT VT an N 1n UT
Gg************ e. g e e. . e
C In o0 1l1 CO In 01 01 CO 00 1-1 N N Al Al Al In Q m In CO CO 0
C O N e-1 ri N e-I Q 00 ei In V1 N l0 N ID ri V/ Al Q rt CO .-i O
0 •0 01 1n 0 n ri r-I In r1 00 m 00 Q O O ID e-1 ri N n .-i N 00
't m .4 r-
D 3 ri
0. a
D D
er-
a.
IN M 00 l0 N CO LO ti ID M CO ID Q 01 LO M CO ri CO Q 01 Q
10 C 00 In 00 00 01 r, 00 n 0 0 al Il1 Q .-i N Q en l0 M ei Q
O In .-i Q re n 01 Q 01 err 40 N AI n O N .-i Q O l0 N a0
C O n n M Q 01 Al r-1 n In N O In Q CO Al ID n O
01 j0 M ti to N ID N Al N N Al 311
U
o 0.
ri 0
ND
7% of Revenue
O N'
N
LC) '1'
O
CO
6)
co-
(Amt collected in 2007)
5% of Revenue
O
Tr-
O
3% of Revenue
O CO
Cr) Cr)
LO
N cc
O N
co
O
ti
N
CO
O
O
co
1% of Revenue
O -CO
LC) M
N O Cr) )
O
N
O
L()
Total Revenue
O CO
CO
N O
Natural Gas
CenterPoint
Natural Gas
Natural Gas
N
d
O
0
0
Centennial Utilities has 7% and 3% (for interruptible systems) franchise fees which result in an overall fee rate of 5.88%
12 months, etc.
Positions Eliminated 2010 -2012
Year
Position
Last Employee
in Position
Department
FTE
2010
General Maintenance
Joe Johnsonl
Public Services
1.0
2010
Admin. Sec. /Receptionist
Carol Danielson
Administration
1.0
2010
Building Inspector
Patrick Moonen2
Community Development
1.0
2010
Building Inspector
Vern Rylander3
Community Development
0.5
2010
Secretary B
Lisa Hogstad4
Community Development
0.5
2010
PT Utility Billing Clerk
Mary Burnside
Finance
0.5
2010
PT CSO
Matt Paulson5
Police
0.5
2011
Police Officer
Dale Hager6
Police
1.0
2011
Police Officer
Joel Martin
Police
1.0
2011
Environmental Specialist
Tim Payne8
Community Development
1.0
2011
Sr. Center Coordinator
Peg Smith (retired)
Administration
0.625
2011
PT CSO
Jon Gray
Police
0.5
2011
Custodian-
Kay Stansberry
Public Services
1.0
2011
Senior Planner
Jeff Smyser
Community Development
1.0
2011
Director of Administration
Dan Tesch
Administration
1.0
2012
Community Relations Coord.
Karen Anderson
Police
0.75
Total FTE's
12.8759
'Died as a result of a workplace accident
2 Promoted to Building Official; position eliminated
3 Position went from full -time to part-time
4 Position went from full -time to part-time; moved to Administration in 2012
5 Promoted to police officer in 2010
6 Promoted to sergeant — police officer position was not filled; position was eliminated in 2011 budget
7 Resigned Sept. 2010; position was eliminated in 2011 budget
8 Moved to new Streets Supervisor position after the retirement of Tom DeWolfe, Public Works Supt.
9 Administration (2.125), Community Development (4.5), Finance (0.5), Police (3.75), Public Services (2)
s- h- tbi-atJe) g113
City of Lino Lakes
2013 Capital Equipment Replacement
Department Description
12 LU k. css,0,1
Amount
Police (4) Squad Cars & Equipment $144,000
Fire
Fleet
Capital Equipment 85,250
Single Axle Dump Truck w/ Plow 145,000
Tractor and Broom Attachment 60,000
3/4 Ton Pickup w/ Plow 45,000
Total Fleet 250,000
Total $479,250
Equipment Levy 325,000
Capital Improvement Fund 4,250
Certificates to be Issued $150,000
City of Lino Lakes
2013 Capital Equipment Replacement
Future Levy Impact: 2012 Certificates
1% Total w /5%
Principal Interest Total Overlevy
2012 Certificates Issued
2013 49,000 2,875 51,875 54,469
2014 50,000 1,010 51,010 53,561
2015 51,000 510 51,510 54,086
Totals 150,000 4,395 154,395 162,115
Balance
150,000
101,000
51,000
0
City of Lino Lakes
2013 Capital Equipment Replacement
Future Levy Impact: 2012 Certificates
1%
Principal Interest Total Overlevy
2012 Certificates Issued
2013 49,000 2,875 51,875 54,469
2014 50,000 1,010 51,010 53,561
2015 51,000 510 51,510 54,086
Totals 150,000 4,395 154,395 162,115
Total w15%
Balance
150,000
101,000
51,000
0
2009 Certificate
2010 Certificate
2011 Certificate
2012 Certificate
2013 Certificate
Debt Levy
Equip Levy
Total Levy
CITY OF LINO LAKES
2012 -2016 Financial Plan
Capital Equipment Replacement Financing Schedule
Police, Fire, Public Works & Parks
2012 2013 2014
127,617
64,617
43,365
64,890
42,851
54,469
43,481
53,561
54,469
2015 2016
54,086
53,561 54,086
235,599 162,209 151,510
250,000 325,000 375,000
485,599 487,209 526,510
Annual Change in Levy 12,919 1,610 39,301
New Certificates Issued
150,000 150,000
107,646 54,086
450,000 500,000
557,646 554,086
31,136 (3,561)
Equipment Replacement Fund
Balance 1/1
Certificates /Levy
Unused 5% Overlevy
Scheduled Purchases
Public Services
Police
Fire
Sale of Used Vehicles (Salvage)
Interest Income @ 1%
2012 2013 2014
166,589 20,385 40,258
400,000 475,000 375,000
11,219 7,724 7,215
(343,000) (250,000) (209,000)
(144,000) (144,000) (108,000)
(86,625) (85,250) (87,000)
16,000 16,000 12,000
202 399 305
2015 2016
30,777 40,302
450,000 500,000
5,126 2,576
(275,000) (155,000)
(96,000) (120,000)
(87,000) (87,000)
12,000 16,000
399 1,969
Balance 12/31
20,385 40,258 30,777
71
40,302 198,847