172-2001 LTC
....... ,
CITY OF MIAMI BEACH
Office of the City Manager
Letter to Commission No. j12~2tJ/J 1
.
~
To:
Mayor Neisen O. Kasdin and
City Commissioners
Date: July 23, 2001
From: Jorge M. Gonzalez Q ~
City Manager U . ()
Subject: CYBORG PAYROLL\HUMAN RESOURCES SYSTEM COST BREAKDOWN
As an additional means of understanding the cost implications of the KPMG, LLB, report
on the City's Cyborg Payroll\Human Resources System, two spreadsheets have been
prepared for your review. These spreadsheets cover the period 1999 - 2006.
. The first spreadsheet is two pages in length and has been divided into Expenses to
Date and Future Expenses for Software, Training, and Maintenance categories. Each
of the modules has been given a specific color, Le., Software Expenses are blue,
Training Expenses are red, and Maintenance Expenses are green.
. The second spreadsheet is one page in length, follows the same color coding as the
first spreadsheet, and is a summary of the Software Expenses, Training Expenses and
Maintenancl:) Expenses with subtotals for both Expenses to Date and Future Expenses.
These statistics will provide a clearer means of assessing the City's continuing financial
role in supporting their payroll system.
There will be an on-going annual maintenance commitment beyond the year 2006 for
approximately $75,000.00 plus CPI increases per year.
JMG:PDW:M,
~
M:\$cmbltemp\cyborgexpensesltc.doc
"
~ falfa fa ~!~I~I~rll~rl~' ~ ~!I6;~lj6; 6;1-S;> ~~I ! I' I .,-S;>I 16;-S;>fl;-S;>! li6: 6; 6;T-S;>-S;>I~-S;>~I!~
0.,'-11>> "' _ -.,-tICll Cll Cll " " a a o,e- ....0"1 I" 0" 0" a. a a!l';'. O"'t/> 0"-
"'" -< 1-.< -< g g gl::hi:::!!,:::!l ~ ct. -< Q c: '0 I ' 0 0;:::;: 0 0 0 ~ v
::O)>)>)>::J :::J :::J lutlUT en ~Ig <D I~ ;rj.I<C ::u !~ I ..2ca IcO ~r ~:~cC cO 8" cO ~
~ a. a. a.;s:;s: ;s:1)>1)>')> r < "'1<0 '"',e m 100' ,0" ....ie: ",", ,"' al3"i3 00 fIl
~~. '22. m Q) Q) a. a.lo.l~ Cirl~lm ml;g ml :.'cn~' 1~.DJ'm 1)>- m:m Q!-c ()!~O tl!
o ::J :::J :J :::J :J :::J 13 3 3 '<0 .c: ..... I a. -I'" >< C ~ (C < -.."
:J (j)' iii l<ii' ~ I~ ~ S'ls' 5'ICD < a. CD =10) "'0 !5l"3ro -t:~:" alJJ =;; ~ iCD3 l:^, -I
UI S,SS'(D CD CDI~I~I~~Cll::O(J)'f!Js::,g.lmZI 0 '(I)-"go..,!(I) ,3:::";::::;, (") ~ 0
~~~333~~'- I ,,-0 I ";s:lc!!!' ""c;S:OO!:;'Cll><"Cll'
g g a:lm (I) CD a 9l 9l ;. -g l:g:g 9- g>lfR file: I !!..:~. 5t;g'l~ ~:'E 8.;~ ~:(C s-;~ ~'i
:J:::J:::J aa3.6 o'c)";I.,d:O 0 :::!lg"C'" 3:1:::1 0,(0"'0(0 g,:::;.:ln.o ct.!~. 1____
a a """,,,;:l., "0 V' (Il "I-"Cll .. -'I"' "' i 0 "'" ~
, ala.." 0'<0 ;:l. 0 ~ -. ~.. '" ._,0 _''''"I. '" ". m
:gl~O!" .,a,ai Cll ,Q'!g;:l. o~ "I - 't/> "'0'0 <0
__ :::J I (1) 10' C I' ..., :::)' I S' ~....I : CD Cbo g :::J:J , (J):
'~o (I)~S ,::):(1) 1!C1cnIO" -I, ,::I 0'. Cf) Ii "t/> t/> 0
;:::::;= 3: S 3 :00:6'! .'< ,"" )It :11'0>1=' WI,' ""I
1-'._'1 ,_. ,C 3 C" '() r-' --, ~
~tl I~ilii~ i-I' i il 11'1 ~l ~I i~' 11~1'~ 'i
Cll 1il t/> )(" ~'< Z"eo" "
:J ! :J I "i t/) 2!. I (D I fA Cb CIt
m ~'i:J gUl m;\ i i
t/> t/> m' .,,,, ,g' ~:::: ::
'" ~ 0........ ....
- .'. --=- .fi"'f'!- -1~ .it Ji ~~ i
g>g>g>g>g>g>g>g>g>g>g>fIlg>OOOOOO ;s: ........-1 OOfIlOOOOfIlOOOO
~ ~ ~ ~ ~ ~ ~ ~ ~ ~~1!~.1.11Ii ~~: ~j 1111111
D>Q)Q)Q)Q,lwQ)wmmD>Q)mmmm 1m ::J:J:J D>Q)IDQ)Q)mm
, 'ITi': "j'f1 t tt,'i'Tt ~I'~ -, _-LI~',~..._ '<O~IIE 'I":~:: ~
I ......mGl 1(00)(",)001
[I I 1 j j J I~ ~ ~ I ~~ ~ ~ ~ ~
~c 1IIIItt IlTII-I~IIIJ~tl' - ~ Illllc
1111 II II Illi'l~ ~ ~~ l~ l~ II I
I . I .11 n H 1;1"I;j,,h 1_\ jE~I~I~ "I:::: iii I
III It II, 1.1. II lili.~.I~! ! I~I .,~I'.'.-~I',-~.I;:.. I~.. ~..II, .1. I I, II ~
- - -' -r -+ -+ I-t ". - 818,8,1.81. ! Iii 1~IOO.:;:I.al~._I_+~ -~-t It t1l t- ~
1 ~ ~ ~ ~ ~ ;'1 I , I , I I I I I I I I II I I I ! I
~ ~ ~ ~ ~ ~ I II I i, 11S1 ! I I I I I I I I I I I ~
_.~- -
~~~ III ~lll, 111I III III IIII
~ ~ ~ ' I I I I ~I I I I I ~l . ' I I . I
00~-++1:1 rj~-lh+IT~H++-
\ III~IIIIIIII~ III \ II I
. t-t- L-~ 1-H-~g - +1
I i \ II~I
; I II I I I
I ~ II II Igll 11111111 \ 1111 g
- tlt~-Ol j 11-1 f~1 !_1 r-I r-I j-1HT :
'" "'I'" '" '" "'1"'1 I "'1"'11 "'1...1 I I~II 1...1", "'1",1." ." ~ ."1.,, ." ." ." ." ~ II!
~~~~~fJl~~I~~fJfJ~~_~I~IDI II~' -;'1~~~~I~~~~~_~~J2~~ d
~ ~i~l~ ~I~I~ gl~!~I~I~I~llgl~i~11 I I~II 1~1~1~1~1* ~ ~ ~ ~ ~ ~I~ ~ ~I I ~
8818188',888 81818!:5 818i818i,~1 ~.ool~I~\8 8 cil~ 8 ~ ~ig 81811 fIl
-
'" ." '"
~"''''
<Xl"'....
ceo,
000
000
000
OO~
'"
<0
It-~ -+-
I I
c
m
fIl
o
;Ill
~
6
Z
::;!
"V
m
o
-<
lD
o
;Ill
G)
fIl
-<
~
m
J:
z
!"l
~
-<
;Ill
o
....
2~
!(~
,!:lz
...;IIl
gm
...fIl
o
e:
;Ill
o
m
fIl
fIl
~
m
iI:
~
m
Z
ce~
;Ill
Cl
...
co
co
co
...
o
o
o
...
o
o
...
...
~
...
o
o
Cll
~
!
CIl'
c::
m
-I
0,
~I
r-!
-II 51
0: ~
~. $
r- m
~ I~
I~f
, I
I--~
I
""
i
t;
...
...
....
':...Ii
~I
1-;1
::
Co
..
Cll
iG
..
...
W
W
Cll'
o
g
o
_0
... ...
... ...
.... ....,
N N
W W
o 0
00
o ,0
~ 10
... ...
~! ~I
Ni Ni
'N' N
g ~
o 0
i Ii
b ,'0
!1!'
... ,...
i Ii
,
...
...
Co
....
...
<It
,...
1-
Ij,
U. 01
U) ,0
w 0
~ 18
:
10,)> !CIl"'lllDrl'zOCll)> I~mmmm""o
!'<'CD ImoCDO'<OCD :::J::I::::J:JQ)Q)Q)Q)m
:,0- (') Dr (JJ ::l :J C" C () :::r:::r:::r::r CTO 0'0 0' 0' CIl
o . ~CDIO_ Q)Q)Q)Q) 00
,'" m ,-< cf ~: -I ..., 0' () :J::J:J:J""''''''''''''' n
,lO" ')>" iitenlO ",< 0 0 0 ol;u;u;u;u;U
i en:J'" I ,0 -< 0" CD CD CD (1) I CD CD CD i CD -
1,< l1) 10. ,S::)>:::r CDr< 0' (J) a. 0. 0.'- - _1- "U
en fa. g I~' ~: ~ ~ ~ ~. to CD en en rJJ ~ ~,~ ~ ~
c: en3 CD :2'IQ) -. m m -Ii g:~ ~ ~ g g'g g 0
.,. ,3 I !1!.!lO ~. ~ " ;u en " ! c: c: c: "' "' "' "' Z
S' s: CD en 01, 3 !a. m, a. CD g. g' ~ :1. :1, ,i:::::!. () () m ()
lliI'!!1,;:l. c: gen iil 5.'-115 " !i O.:;t.:;t,.:;t 0 c: m 0
I:;; ~,s: ~I," ;:l. g c::!il. g.'~' Q.,g ~ f]i~ iil 6- 0 iil
Ie ::::l'~';rCiC:J 0;:!.CQ -lU'U) m:J o.~3 3~
.... Q)i~ _:01", c en);:] Ie -Ie ;:::;1,"' C:,-' -. ',-'
c: "ICD ,CD CD (h'""\CO C,CfJ "TI,;::;:::rc _:J N"'2.,:J.
,; 0 :J I "" ~ I"" CD' --l (f) i CD c! 3" QO' a:: CD ,co ~ CD!ID i
,,'CDIQ)'S.~-I""--t,DL i~I""--t2'lO UlI'tSrno'3!m
ai '::I C!m m :5"j ----.l.., '!J m x ::I,CD')(
!!" ~ ~13'-'m -'1 ~Q)!CD >< ~m ,"'0 (f)'a-o
::I ID _.,':J -'I:J J cu -. "C I CD x CD Q) CD
..i -II:J! 3',~. co,, -. :!.(tn CD !-rT"'O :::J Q: :J
CD ! il co 'CO:J I ::!.::::J 0 ::::J ,"< (1) VI '0 UJ
~! I, lO ",lOfUJ-::::Ji (1) ::::J(1)
II' is': , co: CD 3 UJ' UJ (I),
:::I _,' 1 ' UJ "C CD !
n :::I I ~ I CD UJ
CD a:l CD, 3
ii ~'i 'I li~ '
~ :::I I :::1-'
"... .. 0
I i I I "
:;;i::s:' -I--t--t--t-l=t:::j~iUl(J)CIl(J)Ul(J)(J)Ul-l
m m m m m,m m m mOo 0 0 0 0 0 0 ~
m CD: ::::J::::J::::J::::J::::J::::J::::J' m m m m m m m m
~~I (C(C(C(C(C(C(C rommrommmro
H~~_ . t ' {
J 1-
III I~
,~!----+-~, ~
t
,
N
-:~
:
...,
o
'0
o
<It
...,
CD:
o
~I
,!I
w,
w,
Cll'
o
g
8
i~il ~~I i i.,. ~- '~ '
1m ,00 N ~'~ 0 I
1'0' l'o~1 ~ 0 I N
0: 00- 00 c
~i I~~ . i~~~'~I'~-,~
1~lr'~': ~~~:~~'=
1~1.-001i~oOO ~ ~"""-I _"""-I,_U'J J1) J:D......
_ _ (.u U'JiO WI<O 0
000 Cll 0 010 Ol~ 0
0"0001 000000
! 8i~ .8: 8j ___ _ ~!.g, g~I~._~j
_tfl~_ ; 1 tA; '.
......l:lo.NN tA ~-'o. :0)
WU'JOOCD i-" """-IU'J 'ce)
i!II'~,~I~' ~ ,II! . ,!
.... "'iN N.,.' .,.r~ '0
W,01jOO ~~' """-I.U'J N
Cioo~"i\J 0,'0 0.
gig 8 gig ,g g 8i
0660'0 00 g I
l-tAtA- ~ itft 'tA
~~'~~~il' ~ig ~ '~~~~I
0000' 00 C U'JOOO1N
g[;[;lg -LJ[;~ g I [;~[;[;g
;;1;;' III:~-,-';:'~~'~ ~!~ 2~,~
:i ~g'~li~ : I:~lgl tll'~ ~ ~ ~ '~N
~ 9,~ ~.' 99',!=, 9 9 9 9 i 0
g_8 8g+t -~r g 88 8 :5 ~~~
,t:I~,~'~' I '.,..,..,.:.,. . !.,. ;
;:J~~:_~J~ ~ ~ ~f;. ~ ~i~~~.~ Y. ~ ~ ~ ~ y. ~ a
0;/,00 C;!f'\) (.oJ W,O 0 W co co 01 0 I\) 01...... (,J1 0 I\) ~
000 m'!o 0 0:0 0 0 c.n <II 0 ~10 0 01 0 0 0'1 )it
';~ g,~:~I~ ~igl'~ ~Ig gi~ g ~Ig gi~ 8ig'g t;
~-~- - c-
1
N
. :S
--'-f!'>
lif
llN
, g
, c'"
...
...
I
o
i:i
o
~
CIl
~
iiI
-~
z
p
~
~
t..~
C::C::
!(~
J:lz
N;U
om
OCll
"'0
c::
;u
o
m
CIl
CIl
~
iiI
~
m
><
"U
m
Z
o
~
;u
m
CIl
N
g
...
N
i~
I\J
"'m-l I ."men c
c x ~. ex 0 m
12"~ -'1 2"~;:l! en
;~~', I ;'I~..~ ~
enl ,~ 0 I.:~ oS
.~ en' I~ *'~I I~,*I /z
lil~ '~I I
1:' 'g. &
I!!. !!ol _I I
-ll lal -l' en,
0" ~ 0"
~I ~ - i
)Ii 1:1 :. II'
~I lal' I leSl I Ii: II I'
'il ~ 1 ' m I I m' I
i Iii 1 II I 111 ' 1 II 111 III
en -~I L 1[-1 =11 r II "=1 t-r-f-:
i I I~ I I <n I It ~. I
~ I~I' ~I~II jilIFlil, /j ~I ~
~f 8 8r8 t 8rr8! I ~ ~ :g
~ ~ 1-lgll lei I i1l;/1 i I! I
; i: I~~I_II~II~I~III!! IJ~1111l
~ Igll~I&11 I~I I~ISII I~II~I~I
tl I~ Igl~II' I~I Igl~1 I' I:::llgbl 18
OOf 100 ,000 G> ,0 <Jl .... ol./> ___ ...
~I [~II~'I I , ':1 I~ I j~I' I~ I II
en Co> '" 1 I 01 Oll I ....,.......1 I
~ I~I 1'81~ I I~I' !~! I I~ 1'8 I I~
: g 1~:81 18 j8! I 181 .81 -t ~
~I ~I i~1 I inl I~I I I :1 I~
~I Ji I~I'" lil' I~ I Ii 'I~I I N
~ ~ Ig gl '8 gj I I ~I gt 8
~I : :_10 i 1"'11:' ! I I; I'~ Co>
0...... IN'" 00
8 8 t88[ i8 8f 18t- 8H ~
~l--r~ --'I~I -I I 'nl t~1 I ;:'1 - I~ I
~ Ii ,il~ I Iii' I~ I I~, Iii I I ~
o 0 0 01 ' 0 0 I '01 0 0
~ I~ Igl~1 II~LI~I II~ ~ I 8
: .8 i8fl --18 18~1 ~ 8 ~
- tol '" r /'" I'" II !I~- I",,,, I:
~ !i ~I~ I II rg ~I I t I~ ~ I a
'" g: "0 '" ;.. 10 "./> 1"'1 '" '" ;!
g ~ ~I~ I t~i j~l~lIAtg, f ·
I 1III11I i i I I
Q
(II
o
~
~
-l
m
I:
Z
!"l
Cii "II
o :!(
f ~
i r-
_ r-
-l<-:I:
~l=c:
3' 0( ~
:i' tf z
a:I -
_N::U
I:om
lIoen
-. - 0
~ c:
CD ::u
:I 0
II m
il en
CD en
- 0(
!!l
m
I:
~
"II
m
z
c
::j
c:
::u
m
en
-