HomeMy WebLinkAboutResolutions - 1999.08.19 - 25604August 19, 1999
REPORT MR #99185
BY: PERSONNEL COMMITTEE, THOMAS A. LAW, CHAIRPERSON
RE: Information Technology / Telephone Communications - Replacement of Centrex System With Private
Branch Exchange (PBX)
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
The Personnel Committee having reviewed the above referenced resolution on August 11, 1999, recommends
to the Oakland County Board of Commissioners the resolution be adopted.
Chairperson, on behalf of the Personnel Committee, I move the acceptance of the foregoing report.
PERSONNEL COMMITTEE
Personnel Committee Vote:
Motion carried on unanimous roll call vote.
d
MISCELLANEOUS RESOLUTION 199185 August 5, 1999
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: INFORMATION TECHNOLOGY / TELEPHONE COMMUNICATIONS - REPLACEMENT OF
CENTREX SYSTEM WITH PRIVATE BRANCH EXCHANGE (PBX)
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
WHEREAS Oakland County currently subscribes to Ameritech Centrex Service
which provides approximately 4,000 telephone lines throughout Oakland County's
Pontiac service complex and other County locations; and
WHEREAS the current telephone switching equipment is owned and operated by
Ameritech which, under the terms of the current Centrex contract, costs the
County approximately $921,000 annually; and
WHEREAS Plante & Moran, LLP, a consulting firm with expertise in
telecommunications, was engaged by the County to assess the cost and feasibility
of replacing Centrex with a County-owned Private Branch Exchange (PBX) telephone
system, commonly referred to as Customer Premise Equipment (CPE); and
WHEREAS PBX system specifications are being prepared for release in the
form of a Request for Quotation; and
WHEREAS based on technical capabilities and relative costs, the recommended
alternative is acquisition of a Meridian SL-100 Digital Switching Centralized PBX
System; and
WHEREAS the costs associated with owning a PBX system are exceeded by the
cost of continuing the leased Centrex arrangement beginning in the fourth year
of operation; and in each successive year, a PBX solution saves approximately
$600,000 per year over Centrex (beginning after the fourth year), accumulating
to $3.6 million savings over a ten year period; and
WHEREAS the foregoing savings takes into consideration $309,355 costs
related to termination of the current Centrex contract on March 30, 2000 rather
than March 30, 2002, as well as establishment of one (1) new Network Systems
Analyst I position to support County telecommunications requirements; and
WHEREAS the purchase cost of a Centralized PBX system is $2,300,000 with
annual maintenance costs of approximately $70,000 following the two year warranty
period; and
WHEREAS funding is available from two sources, both provided for in the
FY2000-2001 County Executive Budget Recommendation: first, an Operating Transfer
of $890,000 from the Office Equipment Fund to the Telephone Communications Fund
and, second, the balance from accumulated Retained Earnings in the Telephone
Communications Fund; and
WHEREAS the Manager-Data Center Operations has requested that the Personnel
Department review the salary range of the Data Processing Equipment Supervisor
and, after review of salary survey and position responsibilities, the Personnel
Department has determined that a salary adjustment is warranted.
WHEREAS the County Executive recommends adoption of this resolution.
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners
authorizes the acquisition and installation of a Meridian SL-100 Digital
Switching Centralized PBX System.
BE IT FURTHER RESOLVED that funding for the aforementioned system be
derived from the Telephone Communications Fund, supplemented by an Operating
Transfer of $890,000 from the Office Equipment Fund.
BE IT FURTHER RESOLVED that a new unit titled "PBX Telephone" be
established in the Technical Systems & Networking Division.
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote.
BE IT FURTHER RESOLVED that the following staffing changes be made:
1. One (1) PR position of Network Systems Analyst I be created in the
PBX Telephone unit.
2. The current Telecommunications Network Specialist position be
retitled to a new overtime exempt classification of
Telecommunications Network Supervisor at salary grade 14, and
transferred from the Data Center Operations Division to PBX
Telephone Unit in the Technical Systems & Networking Division per
the attached current and proposed organization charts.
3. That the salary range for the Data Processing Equipment Operator
Supervisor classification be increased to:
Base 1 Year 2 Year 3 Year 4 Year 5 Year
$47,083 $50,016 $52,952 $55,884 $58,818 $61,755
BE IT FURTHER RESOLVED that the FY 1999 Budget has sufficient funds for the
remainder of the year and Budget amendments for FY 2000 and FY 2001 will be
recommended during the Finance Committee's budget review process.
Chairperson, on behalf of the Finance Committee, I move adoption of the
foregoing resolution.
FINANCE COMMITTEE
Resolution #99185 August 5, 1999
The Chairperson referred the resolution to the Personnel Committee. There
were no objections.
PLANTE&MORAN LLr December 1998
Oakland County
C.entrearP8X Cost Analysis Page 14
The proposals show the distributed design (Non& Option 81C) to carry a lower purchase cost
by an average of over $800,000 compared to the centralized design (Nortel SL-100). System
maintenance costs for the SL-100 were in two cases (GTE and Williams) less than or equal to
the Option 81C plus the SL-100 came with a two year warranty through both Ameritech and
GTE. Maintenance costs were averaged across the three vendors in the final cost analysis (see
Appendices D, E, and F). The table below details the actual maintenance costs quoted by the
three vendors as identified below:
MAINTENANCE COSTS - SL-100
AMERITECH GTE WILLIAMS
,
Year 1 Warranty Warranty Warranty
Year 2 Warranty Warranty $119,400 !.
Year 3 $67,355 $75,000 $119,400
Year 4 $69,998 $77,250 $121,788
[Year 5 $72,798 $79,567 $124,223 ,
Totals $210,151 $231,817 $484,811
The average maintenance cost for the SL-100 was calculated in Appendix E as follows:
$210,151 + $231,817 + 484,811 = $926,779
10 years of maintenance payments across the three vendors
$926,779/10 = $92,678/year (average annual maintenance payment)
$92,678 x 1/3 = $30,893 (cost of year 2 maintenance since only one vendor assessed it)
MAINTENANCE COSTS - OPTION 81C
AMERITECH GTE WILLIAMS
Year 1 Warranty Warranty Warranty
Year 2 $58,061 $133,000 $119,400
. Year 3 $60,826 $137,000 $119,400
Year 4 $63,590 $141,000 $121,788
Year 5 $66,355 $145,000 $124,223
Totals $248,832 $656,000 $484,811
The average maintenance cost for the Option 81C was calculated in Appendix F as follows:
$248,832 + $556,000 + $484,811 = $1,289,643
12 years of maintenance payments across the three vendors
$1,289,643/12 = $107,470/year (average annual maintenance payment)
TECHNICAL SY
REC
STEMS & NETWO
TOT
FY 00 I FY 01
6
18
24
RKING
MANAGER -- TECHNICAL SYSTEMS
8 NETWORKING
Gen Fund/Gen Purpose
Special RiVenue
Proprietary
Total Positions
CP
REO
18
24
18
24
AO1ANISTRATION
Mensper Technrcal Systems & Networking
Total Positions
GFP PR REQ 1 AEC FY CO FY 4)1
CURRENT
SR PR REO REC FY 00 FY 01 TECHNICAL SERVICES
1 1 1 Chief — Technical Services
4 5 5 Systems Software Specialist (c)
1 3 3 NitWork Systems Specialist (d)
2 1 3 3 Networi Sirilemi Analyst 11(d)
5 7 12 12 Total Paskions
GF/GP PR REO AEC FY 00 FY 01 NETWORK TECHNOLOGY
1 ' . I 1 Supv — Distributed CoMputing Tacna:dopy
1 1 1 Applications AnalysliProwammer 1
1 1 1 Network Systems Analyst II
1 -----. I I Istddrint Encirriaer (a)
1 Student
5 6 SToILPoUion.- '
SR FR REO NEC FY 00 FY 01 DATA BASE ADMINISTRATION
1 i 1 Sunervloot 11- 1ntonnel1on Tecteloinvy .7.7 -
I 4 6 6 rm. Bess Administrator (b? —
I 5 5 8 Total Pusltions
(a) Position funded 1,000 hr/yr. PTNE, and transferred from System Development/Law Enforcement Unit, per Misc. Res. #990414, effective 2)19/99.
(b) includes one (1) Systems Software Specialist position transferred from Systems Development/Law Enforcement and reclassified to Data Base Administrator,
and one (1) SR position created per Misc. Res. #99044, effective 2/19/911
(c) includes one (1) SR position created per Misc. Res. #99044, effective 2/19/99.
(d) Includes two (2) SR positions created per Misc. Res. #99044, effective 2/19/99.
Prepared by Pommel Dept 711195
• FY 00
**FY DI
4. NETWORKING
Wtiriteie
61*..irRemonoi
lAr.Y . Total Poellione
FY00
20
26
FY 01
26
CF
REC PVT* FY 01 --PR SIFIGP IWO
PROPOSED
REO
TECHNICAL sysTaks I NETWORKING
REC r TOT —1-11ANAGER - TECHNICAL SYSTEMS
ADMINISTRATION
14ITIEw TtIchnic.! 8710.0!", & Not?1,.fil-^2
Total Poeltlons
SR PR REa REC FY 00 FY 01 TECHNICAL SERVICES
1 - ---- - - .- i - - -1
- ' • tl - -6 Si:Mei: It-o&-i-iii SiNclehet 11c)
3 3Nitweil yet-41-m Spi-aialim (d)
- 3 ---3 MilmdEgi-ii&m. klejiet 6 (ay
-12 -it l'I -TraiiiitIone — -
SR PR RBI REc Fs(*) FY 01 DATA SASE ADISIMSTRATion
i I t Supervisor N . Inkemation Technology
4 6 6 ben Saw MrtlInkbvIor (b)
6 6 -----1 Tote Positions
OF/OF FR RECI RECFY CS - FY 01' ETWORK TECHNOIOGY ,.
I -- only, -- Disiiiiited-Cithiu114 Technology
i -I i ApplIcsiliqii Ana I irm/Froorammer
i ------1 Niit-yort 61ye1arns Ansifer )2 _ 1 -----f siaidi ffiiie-Tret iitil - - '
1 % Student
6 6 II Total Fooklons
. Ill PR ,
RECIREC - PYIX) FY01 Pa TELEPHONE (6)
1 Talicommunicadone Netwotk Sti—peryisor— #1 - -
1 1 NeemoliWetents Anidyst rtg) -
'2 2 ,Tofilkillkei.-- , . 2
(a) Position funtirsd 1,000 hr /yr. PTNE, and transferred from System Development/Law Enforcement Unk, per Misc. Rea. 099044, effectkwe 2/19/99.
(b) includes one (I) Systems Software Specialist poskion transferred from Systems Development/Law Enforcement and reclassified to Data Base Adrrinistrator,
and one (1) SR position created per Misc. Res. 099044, effective 2/19/99.
10
c) Includes one (1) SR position created per Misc. Res. $99044, effective 2/19/99.
d) Includes two (2) SR positions c.roated per Misc. Res. 099044, effective 2119/99.
e) Proposed now unit.
Proposed position reclassification from Tebsconsnunications Network Specialist, and transferred from Data Center Operations/Communications.
g) Requested position.
• FY CO
• FY 01
Prepared by Personnel Dept 7 /72461
(4A
REG
FY 00 FY 01
DATA CENTER
REC
FY00 FY 01
OPERATIONS
TOT
FY 00 FY 01
1
36
37
MANAGER -- DATA
CENTER OPERATIONS
Gen FundiGii, PurLoose -
Special Flowers —
PfoPfle!ort . . Total Poallions
CURRENT
CP
1
36
37
1
37
GIMP PR REQ REC FY 00 FY 01 ADMINISTRATION
_ _ 1 1 1 Manaipt -- ass Center Operations _ .
1 1 i Cnisf-T$013.11Orms Communications (a)
2 2 2 AeCeptioniat/Clark (a)
. .. ____ ._ __
4 4 4 Total Positions
illFrOP - PR RIO : ItEC FY 00 F7 01 1.1Ei-P DESK
1
1
1 1 Cuetynsr Servius Technician II
1 1 1 Total Positions
OF/OP PR REQ REC ' FY 00 FY 01 COMPUTER OPERATIONS
1 1 I Data Processing Equipment Operator Supervisor
a 2 2 Data Prociiiille Equipment Operator III
4 4 4 Diti ProCaliON Equipment 0i:orator II
7 ?Obi-Positions
OF/OP PR REQ REC FY 00 FY 01 DATA I1TR
1 1 1 Deli Entry optflaDI ili
I 1 1 Data Entry Operator 5
2 2 2 Total Posilons I
OF/GP PR REQ REC FY 00 FY 01 PRODUCTION SERVICES
I1 I Supervisor Production Service&
1 1 Productfal SChidu- ka
2 2 2 Priliiudieri CinkAlkiatietill
2 2 2 Piocii-O-n- '11.4-iliautlyeir li
I —1 CieTli ilThilive—F—yperson -
- 1 Slaked. — ' a TO-Cal-PoiKon-s- — -
-SR PR REQ REC FY 00 FY 01 COMMUNICATIONS (c)
- - 1 - 1 1 InstallatIon-Coord (b)
1 1 Telecornm. Nel. Spec. (a)
1 1 Customer Svc Tech. 11(b)
2 2 Tel Comm. Tech.' (a)
4 5 5 Tol Positions'
GF/GP PR REQ REC FY 00 FY 01 USTOMER SERVICES
t ---- — — - — 1 1 Ciii1Oriiiiiliiilie SUPervisot
I - -- — 1 1 Cuilomir-Seriicrii Technician III
3 3 3 CrilemlieSiniliii Tiihnician II
2 2 2 CU-rime-7r Siiiiiii TiOhnician I
2 2 2 Curitomei SeiVICiTainician Trek».
1 1 1 Sadent Enoiniiiiii (d)
10 .10 10 Total Poellioni • '
(a) Position(e) transferred from FM10(Telephone Exchange end paid from the Telephone COITIMUNClitiOns Fund, per Miec Res. 099052. effective 3/12/99
(b) Poellico kansferred from Cuslomer Services per Misc. Res. 099044, effective 2/19/99.
K) New Unit created per Misc. Res /1199044, effective 2119/99.
(d) Position funded 1.000 hr./yr. PTNE.
• FY 00
FY 01
Prepared by Personnel Dept. 712199
CF
REG)
FY 00 FY 01
PROPOSED
DATA CENTER OPERATIONS
REC
FY 00 FY 01
TOT MANAGER - DATA '
FY OD FY 01 CENTER OPERATIONS
[ - Gan FtTaklen--ic7—coit 1 L----i' Sti-icrol Revenue ___ _ Vil 33 Frwlstalv
34 Si Total Positions
OFA3P PR REO REC FY 00 FY 01 ADMINISTRATION
I 1 1 Manadv - Data Cantor Oatkatrona
I 1 1 Chrot-Tarophona Commuhkaliona 00
2 2 Receptionist/C*4a DO
4 4 4 Troal Positrons
I. GFA3P PR REO REC FY 00 FY 01 HELP DESk
1 —
.
1-.---- 1 CUBLONIer Unice Technn H I
1 Total Poeidone
OF FOP PR REO REC FY 00 FY 01 -t014PUTER OPERATIONS
1
p
I I "aria 5-roceer- rd °Fda on Stylreleor
2 Data „II Ocsrabariil
4 at. rooming EquNimarst Operator II
1 , 1 ro-hal Posroons
GF/f3P PR RECI PEE FY 00 FY 01 DATA ENTRY
1 1 1 Data Entrt Operator III
1 i 1 Data Entry Operator II
2 2_ 2 Total Peakions
°POP PR RE21 /tEb SY bo ' FY 01 PRO010110N SERIACES
1 1 1 SupendeoThroduchon Sonic..
- i i 1 Production fichodulor
2 2 Production Control Analyst NI
2 ' ---2 -Production Conifol Moot N
1 I 1 Cierk N / Dedroryporaon
1 i---ia-id
a A TWPaellbna
OR PR REO REC ' FY 00 FY01 COSSALINICATiON:#1oL__
1
1 -1 I Installation Coord --(1)
f t ustorsat eN-Clao IN--
I
0 1
2 TaJ±Vcznm. Tech (a)
1
2 4 tote
F/GP PR - REO - REC FY 00 IN 61 CUSTOMER SERVICES
- ---1
I
- i - --1 turita--That A4-i-o -------"-- - - -- - -
1 1 CtrottiroN manrolan --- — -----
i S 3 ',8o ----iii&Wtochillelon 11
2 2 2 Cuolornor &mice tochnIcron I 2 --2 Cariboo*: Unto TochiTilinii----
-16. 16 it) T
(a) Poosion(o)Inumoknoci from Fm&OiTmophorwr Echarup end pale from Ina Telophana Communicabane Fund, par Ric. Nye 000002, effectna 3/12419
(h) Poston tranatarrod from Cuatomar Union par Misc. Rro. 441444, •ffirodro 2/10/49.
(C) Niw Una created per Laic Res 0Ien044, 'Recta" 2119430
(d) Positron lundod LOCO hr PINE.
Prepared by Personnel Dept. 7122199
• FY 00
-• FY 01
Resolution #99185 August 19, 1999
Moved by Douglas supported by Causey-Mitchell the Personnel Committee
Report be accepted.
A sufficient majority having voted therefor, the report was accepted.
Moved by Douglas supported by Causey-Mitchell the resolution be adopted.
AYES: Coleman, Devine, Dingeldey, Douglas, Galloway, Garfield, Gregory,
JenSen, Law, McCulloch, McPherson, Melton, Millard, Moffitt, Obrecht, Palmer,
Patterson, Schmid, Sever, Suarez, Taub, Amos, Causey-Mitchell, Colasanti. (24)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolution was adopted.
I HERE: • - HE Fr)c'r""-""" LU r.ist
L Evoke P - son. County Executive DM*
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, G. William Caddell, Clerk of the County of Oakland, do hereby certify that the
foregoing resolution is a true and accurate copy of a resolution adopted by the
Oakland County Board of Commissioners on August 19, 1999 with the original record
thereof now remaining in my office.
In Testimony Whereof, : have hereunto set my hand and affixed the seal of the
County of Oakland at Pontiac, Michigan this 4..7th dWof August, 1999.
G. William Caddell, County Clerk