Loading...
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