4.1. ERMUSR 02-09-2010~j
Elk River
Municipal Utilities
13069 Orono Parkway • P.O. Box 430
Elk River, MN 55330-0430
February 4, 2010
To: Elk River Municipal Utilities commission
John Dietz
Jerry Gumphrey
Daryl Thompson
From: Theresa Slominski
Subject: 2009 Inventory
Phone: 763.441.2020
Fax: 763.441.8099
At the February 2009 commission meeting, the final draft policy for inventory was
approved. Throughout the rest of 2009, cycle counts were performed and ayear-end
count was performed involving all field staff for the electric, water, and security
departments. Throughout the year, everyone stepped up to take ownership of a
successful inventory accounting. Mike Thiry and Chris King made improvements in the
organization of the storage and shelving area of the electric inventory, and identified
different ways to accurately measure the wire inventory. Steve Ziemer fabricated
additional storage units and carts to help with reorganizing and maintaining the
inventory. Pete Nielson improved the organization of the storage and shelving area of the
water inventory. Lorrie Franz and Judy McSpadden worked together to coordinate the
preparation of, the reporting and reconciling of, and the actual physical inventory counts.
All staff worked hard to provide timely, accurate submission of inventory sheets for
updating purposes, and were key participants of the actual physical inventory counts.
I have provided a Year over Year Inventory Summary and Comparison that provides a
great synopsis of the improvements that have been made and associates them with a
percentage benchmark for each year. We have moved from a .55° o shortage/overage
range to .04%. This success has definitely been a team effort and could not have been
achieved without everyone's cooperation and participation.
C
O
U
L
a
c
N Y
U
c o
a~
E Y
E ~
U 1-
0
N j o
~ C O
(6 N
N >
> ~
O [1
NO
~ O
f6
O o
L N
N
N ~
7 O
N CA
(0
C N O
E ~ ~
O
~ ~ O
d (9 N
m ~
O C1
N O "'
N ~
~ M
N O
C d uNi
O
N ~ N
,. ~
°~ >o <»
z,
O
N N O
N ~ ~
N N
> J
J L
~ ~
M
N
C ~ N
O
N O
d ~
a ~ "'
E c
ij a N
'O
C (D ~ O
7 O '_
A ~ ~ N
>
L
ry > ~
~ <6 O
E s > U
O
~ ~
(0 M
N
r C N N
O
y 3 >
0 0
U ~ ~
'-
>
C m ~
U ~
N
10 L L
}
>
O d N
O
N fA
U
t0
d
> -
U
~
w
a
o
o~~
~~~
a~ E a
y c ~
0
~ E ~
°- .~' o
N O _N
L C d
C > 'C
C N
L ~ ~
H
wvf0
~o `0 3
~ N N
m ~
m 3 ~
C ~ N N
~ m Y c
o m ~
a~ ~° c ~
~ O N
0 0. U 3
~ E
U O d U
a ~ °r E=
(6 (V d N O
0 0
~ ~
C O
O O
N
'Q M
N tD
N ~
~_
~ V
~ O
N ~
f» »
N ~
M c0
O N
N
~ ~
V
W
O
fA fA
O
r r
~ O
OJ
m
~ ~
n
O
N
N
CO C ~
O '
~ N o
°D
m ~
y ~ m o
°
o
N ~ 3 0 ~ ~.
~ o 0 o g a
C O
U
~ Y ~ ~ o 0
V
~
C ~ ~ ~ "
~ .. N N O O
~ C '
>~ ~ O C N y
U U O N N
a
U U 7 7
E
~ ,~
~a~Hoo
Ll .>'- '.' V U
N .
N 'y c `o > >
m o ~ b
3a
m
~,
>>
~ ^ U O. ~ ~
U o E E 3 3
- N N
°
..
~a~.
N C C C ~ > >
O O (0 ~ ~
~ Z. ~ m E_
~ ~p O N in N
E ~ ~
o
.
o d a~
L
L
~
N
E
U -~
-
~t
a
i
0 0 0 0 0
O N j O c~D O O N d
O ~~ O O O O N Q
> ~ > G
O D. O ~
N O N C
~ O ~
C
O o C
O o
N N
~- N N u
~ f
O
O
00
V N
~
~ N
(0 > M W m
M ~- N
CA N (D
N ~ N r
m
r
O
~
C
t0 C N O ~ M 01 -
N E~ M I~ N M 16
'- ~
N C N N O
~n N •-
rn ~
Q G
N
N a
m ~ N
N M
N Q~
O ^ C
fA
CA ~ Q (fl 69 fA
.. ~ N EA
V N ~
O
O
rn ~
(D
C
O U O
OJ
~
M M
N O
m o
V M dV
O
O
~ ~
(0
C
O d
o L CA
~ m
~
~ L C
iav ~
Z ' --
~»
u> f»
<» a
Z
N o O N
O
CA
N N~
7 CA
N 'O
N O O W
cD I~
M V ~
v v (O
O
~
~ N d
~ C
N 2
N Q
> J ~ >
J L _J 1
t9
f~
Q1
O
O
ao ~ (n
~ ('n 69 fA
O C O
O O V
M N ~
M M N
m N m fA
N
~
m
o (~ (/
~
O ~ ^ ~
~ ~ S
co
N
C ~
N ~
O ~
N U
L
fA IfA
U) ~
>N
O
O
N
E
N
3
Y
O
Z
O
C
C
0 0 0
N W N
O M O
O a0 CA
~ N u'l
V N (O
~ t` r
~ O M
W N
~ ~ ~
~ r ~
O N O
M W
f~ O N
O V_ C
~ f` v
» fn r»
N C ~
CO N
u7 N N
M M .-
M O a0
M M N
V
EA EA fA
~ O CA
O O a0
M O O
~ v m
.~ ~
» » e»
MI
r
0 0 0
CA O
N ~
~ C
10 N ~
O O
M M
O
N >
> N
O Q
NO
~ O
(0
~
O
o
L N
N
O O O
O O O
~ N M
C N V
~ O
(9 aD 01
~
N 01
m (D V
~
Cl
O 7
C ~ •-
~p N
O >
N
O ~
V!
fA
EA
~ I~ O N
CA ~ V
(0 oD W
L O1
v N O
N
°~ r`
M V
O_
O ~.
O1 (D O>
N N M m
O CA
N ~
N r`
CA
r T '-
N
> J N
J
L ~.
_
~ ~ ~ ~
m V
M O
M ~
Ry O
O N
Oi I~
c0 V
O
~ M `~
3 ~ ~ ~
N
C
O ~ ~ cM0 ~_ O .O ~ O
fO N
7 fO N
~ (7 N
7
U
N E9
t0 V)
C
O fA
M fA
M > U
N fn
(D fA
M fA
.-.
O~ fA
O > U
N fA
OD fA
R
O 69
OI
~
C N
7>
U~ ~
N
~
r
~ ~
M
N
V (D
00
V
... N
~
O
~f1
~ CA
~
C N
7>
U~ M
M
~ O
O
O
V
v CO
O
cD
v M
u7
I~
o CA
~
C N
7>
V~ M
V
M
N
~ M
O
I~
~ O
V'
V
o
m
~ ~ m
m m
~ m
.
T O .N C
>~ O .N C
T O
a v t» ~ En E» d v F» » F» f» a ~ F» En ~
O
N
U
~
~
N O
N
U
~
~
N O
N
U
~'
~
U
N
w
~
~
N
3 ~
~
F- V
N
w
~
<n
(0
~ ~
Q
f- U
N
w
~
<n N
N
3
fA
Cf1
O
M
rn
MI
M
LL
m
O
~ X
M U
~ _
M U
O N
M ~
u~i o
a~
N
ea >
N
CA
~ N
d
H O