R-1574 - 06/14/2016 - DU PAGE COUNTY - Resolutions Supporting Documents ITEM 9.A.2)
BOARD OF TRUSTEES MEETING
VILLAGE OF SAMUEL E. DEAN BOARD ROOM
OAK B R BUTLER GOVERNMENT CENTER
t_9
ikj1200 OAK BROOK ROAD
OAK BROOK, ILLINOIS
630-368-5000
AGENDA ITEM
Regular Board of Trustees Meeting
of
June 14, 2016
SUBJECT: DuPage Justice Information System Participation and Letter of Intent
FROM: James R. Kruger, Chief of Police "
BUDGET SOURCE/BUDGET IMPACT: 151-72500, $349,859 over five years, 2018
to 2023 (see attachment)
RECOMMENDED MOTION: I move that the Village Board authorize the Village
President to sign the letter of intent to the DuPage Justice Information System and the
Emergency Telephone System Board for participation in the new law enforcement
records system.
Background/History:
Over the last five years, the DuPage County law enforcement community has been
working in conjunction with DuPage County for a replacement Computer Aided Dispatch
and Law Enforcement Records Management System. Early on, the County received a
$500,000 grant from the Federal Government for project management and design to
develop a completely integrated system that would link Police, Fire, Courts, Clerk, States
Attorney, and Jail into one seamless system and serve as a template for the entire country.
The major reason for the need to replace the current system is that it has been determined
to be obsolete and will not be supported going forward. The system originally procured
from Motorola has been plagued with problems and the ability to get meaningful data out
of it has been well documented. After these many years, DuPage County is now ready to
go to implementation after going through the RFP process last Summer. This new
system will be state of the art and serve the County for many years to come. The County
and ETSB is now asking all municipalities to sign the letter of intent to move forward to
implementation so that the new system would go on line in 2018. Attached to this memo
is the breakdown of costs associated with the project for all municipalities. Currently we
pay approximately $8,000 for NetRMS maintenance costs. This new project will require
the Village to pay $349,859 in specific increments 2018 through 2023. The reason the
municipalities have to pay rather than ETSB for these costs is that records management i
I
BOT AGENDA Page 1
costs are outside the statutory limits of the 911 surcharge monies. Those funds will pay
for the new CAD portion of the project. Also attached to this memo are documents from
DuPage County and ETSB further explaining the program and the project costs. There is
a new cost that ETSB is passing on to the municipalities related to connectivity.
Currently all communities are linked together by means of a Sonet Ring or synchronous
optical network that was installed to most agencies in 2004. Part of the plan is to also
replace the SONET with a new fiber optic sustem.
Recommendation:
Staff recommends the Village Board authorize the Village President to sign the letter of
intent to participate in the joint law enforcement records system as part of the overall new
criminal justice data system encompassing computer aided dispatch, law enforcement
records, court clerk, jail and state's attorney as well as a new fiber optic connectivity
system throughout the county.
BOT AGENDA
Page 2
I
RESOLUTION 2016-ETSB-CAD-R-1574
A RESOLUTION AUTHORIZING THE EXECUTION OF A LETTER OF INTENT
TO PARTICIPATE IN THE DUPAGE JUDICIAL INFORMATION SYSTEM (DUJ1S)
WHEREAS,the County of DuPage, Illinois in collaboration with its Emergency Telephone
System Board (ETSB), is prepared to implement an integrated justice system known as DuJIS
which will allow participating police and fire departments to exchange information with and
between the County's court and correctional entities; and
WHEREAS, the County intends DuJIS will replace the ETSB's existing Computer Aided
Dispatch (CAD) system; and
WHEREAS, County intends DuJIS will replace the existing incident Report Management
System(RMS) used throughout the County; and
WHEREAS, the Village of Oak Brook has reviewed materials prepared by the ETSB which
detail DuJIS°s estimated costs, organization, and functionality, and such documents are
incorporated in this resolution as if fully set forth herein; and
WHEREAS,the Village President and Board of Trustees desires to participate in the DuJIS
System.
NOW THEREFORE, BE IT RESOLVED BY THE PRESIDENT AND BOARD OF
TRUSTEES OF THE VILLAGE OF OAK BROOK, DU PAGE AND COOK COUNTIES,
ILLINOIS THAT the Village President shall be and hereby is directed to execute the attached Letter
of Intent directed to the State's Attorney and the Chairman of the ETSB; and further
BE IT RESOLVED, that the Village Clerk shall transmit copies of this Resolution to the
State's Attorney and the Chairman of the Emergency Telephone System Board forthwith; and
further
BE IT RESOLVED, that the V i I I a g e President is authorized to withdraw the Letter of
Intent if the ETSB determines that the estimated cost to the Village of Oak Brook will increase
by more than ten(10) percent beyond the projection supplied by the ETSB; and
BE IT FURTHER RESOLVED, this Resolution shall be in full force and effect upon
passage and approval in the manner provided by law.
APPROVED TITS l Oth day of May, 2016.
Gopal G. Lalmalani
Village President
PASSED THIS 14th day of June, 2016.
Ayes:
Nays:
Absent:
ATTEST:
Charlotte K. Pruss
Village Clerk
t OF r,A4. �, June 14,2016
§� 0
Hon. Robert B. Berlin Hon, Crary Grasso, Chairman
DuPage County State's Attorney Board (ETSB) Emergency Telephone System
$F 00 1', 421 N. Count Farm Rd.
503 N. County Farm Rd. y
Village of Wheaton, Illinois 60187 Wheaton,Illinois 60187
Oak Brook
1200 OakBrook Road
Oak Brook,IL 60523-2255 Dear State's Attorney Berlin and Chairman Grasse
WebSite
wivvv,oak-brook.org This letter is to confirm the intention of the Board of Trustees of the 'Village of
Administration Oak Brook to participate in the DuPage County Judicial Information System
630.369.5000 (DuJIS). I am advising you that the Board of Trustees authorized me to execute
FAX 6310.369.5045 letter on its behalf in accordance with the .resolution which I have attached. The
Board of Trustees makes this representation after its review of the following
Communitv documents provided by the ETSB on May 27, 2016 and which were incorporated
Development
630,368.5101 in the resolution:
FAX 630.368.5128
• Fetter of Intent
Engineering
Department • Organizational Structure
630.368.5130
FAX 630.368,5128 0 Financial Overview(to date)
Fire,Department • Agency Estimated Costs(to date)
630.368,5200
FAX 630.368.5251 0 Report Management System(RIVIS) Staffing Overview
Police Department s Additional Costs Summary
630.368.8700
FAX 630.368.8739 • CIS Work Flow and Addressing Ordinance
Publ cwurks The Board of Trustees understands and acknowledges that the ETSB will rely on
Department this commitment in determining the final cost for the projections of the'DuJIS
630.368.5270' Project and in determining whether to proceed with contract award. The
FAX 630368.5295
Board of Trustees understands and expects that the ETSB will notify it prior to
contract award if the estimated cost to the Village of Oak Brook increases by
Oak Drom
Public lAbna more than ten (10)percent:
Sincerely,
600 Oak Brook 60 Raid VILLAGE OF OAK BROOK
Oak I3r€�nl;,,Tin 60.523-220f1
630.369,7700
FAX 630.368.7704
Copal Cr. Lalmalani
C}itit Brcxak Qt►rt t nr President
Bath&"Tennis Club
700 Oak Brook Road
Oak Brook,,IL 60523.4600 Enclosure
FAX 630.368.6439
Gulf Club
2:606 York Road
Oak Brook,IL 60523-4602
630.368.6400
FAX 630.3681.64 t 9
[Date]
Hon. Robert B. Berlin Hon. Gary Grasso, Chairman
DuPage County State's Attorney Emergency Telephone System Board (ETSB)
503 N County Farm Rd. 421 N County Farm Rd.
Wheaton, Illinois 60187 Wheaton, Illinois 60187
Dear State's Attorney Berlin and Chairman Grasso:
This letter is to confirm the intention of the [City Council/Board of Trustees] of the [Municipality
or Fire Protection District] to participate in the DuPage County Judicial Information System
(DuJIS). I am advising you that the [City Council/Board of Trustees] authorized me to execute
letter on its behalf in accordance with the resolution which I have attached. The [City
Council/Board of Trustees] makes this representation after its review of the following documents
provided by the ETSB on May x, 2016 and which were incorporated in the resolution:
• Letter of Intent
• Organizational Structure
• Financial Overview (to date)
• Agency Estimated Costs (to date)
• Report Management System (RMS) Staffmg Overview
• Additional Costs Summary
• GIS Work Flow and Addressing Ordinance
[The City Council/Board of Trustees] understands and acknowledges that the ETSB will rely on
this commitment in determining the final cost for the projections of the DuJIS Project and in
determining whether to proceed with contract award. The [City Council/Board of Trustees]
understands and expects that the ETSB will notify it prior to contract award if the estimated cost
to the [Municipality or Fire Protection District] increases by more than ten (10)percent.
Sincerely,
[Mayor/President]
[Municipality or Fire Protection District]
Enclosure
i
i
RESOLUTION
AUTHORIZING THE EXECUTION OF A LETTER OF INTENT
TO PARTICIPATE IN THE DUPAGE JUDICIAL INFORMATION SYSTEM (DUJIS)
WHEREAS,the County of DuPage,Illinois in collaboration with its Emergency Telephone
System Board (ETSB), is prepared to implement an integrated justice system known as DuJIS
which will allow participating police and fire departments to exchange information with and
between the County's court and correctional entities; and
WHEREAS, the County intends DuJIS will replace the ETSB's existing Computer Aided
Dispatch (CAD) system; and
WHEREAS, County intends DuJIS will replace the existing incident Report Management
System (RMS) used throughout the County; and
WHEREAS, [this unit of government] as reviewed materials prepared by the ETSB which
detail DuJIS's estimated costs, organization, and functionality, and such documents are
incorporated in this resolution as if fully set forth herein; and
WHEREAS, [this unit of government] desires to participate in the DuJIS System;
NOW THEREFORE BE IT RESOLVED THAT the [President/Mayor] shall be and hereby
is directed to execute the attached Letter of Intent directed to the State's Attorney and the Chairman
of the ETSB; and further
BE IT RESOLVED, that the [Clerk/Secretary] shall transmit copies of this Resolution to
the State's Attorney and the Chairman of the Emergency Telephone System Board forthwith; and
further
BE IT RESOLVED, that the [President/Mayor] is authorized to withdraw the Letter of
Intent if the ETSB determines that the estimated cost to the [Municipality or Fire Protection
District] will increase by more than ten(10)percent beyond the projection supplied by the ETSB;
I
i
I
TO: DuPage Justice Information System Participants (DuJIS)
FROM: States Attorney Robert Berlin and Gary Grasso
DuJIS Chairman DuPage ETSB Chairman
DATE: May 27, 2016
SUBJECT: DuPage Justice Information System Letter of Intent and Next Steps
Thank you for your interest in participating in the DuPage Integrated Justice Information System
(DuJIS) project. The purpose of this memorandum is to provide an overview of the next steps and to
seek participation from DuPage municipal and fire protection district agencies, in the form of a Letter of
Intent, in order to finalize the contract with Intergraph, the vendor to which the Emergency Telephone
System Board (ETSB) is preparing to award the contract for this project.
In order for the ETSB to properly price the contract, it requests that you present the enclosed
"Letter of Intent" to your governing board for its approval. Please include the actual handouts as shown
in the sample as part of your resolution. We have enclosed included a five-year cost projection to assist
you in your decision.
The Law Enforcement Report Management System (LE RMS) cost projection includes the portion
of the capital investment your agency will be responsible for as well as for its share of the ongoing
maintenance, staffing (four IT professionals for LE RMS), and equipment replacement costs based on
the number of users your agency would have in the system today. We have calculated this based on a
cost-per-user basis. We have included an equipment replacement contribution so that the LE RMS
system can be self-sustaining and allow for available funding for the upgrade or replacement of law
enforcement report writing software in the future. DuPage ETSB NetRMS participants may already be
familiar with equipment replacement cost preparation from your cost sharing experiences with that
system. While this is not a new approach for the ETSB, it was not part of the cost projections that the
manager for the initial stages of the project, Mr. David Usery, shared with you last Fall. Because we
believe it is important to set aside funds for the eventual upgrade or replacement of the system in the
years ahead, we have revised those projections to account for equipment replacement.
The DuJIS project is a very complex project with many interfaces to various technologies. To that
end, the ETSB will only permit cost-sharing for common expenses. If an agency requires additional
interfaces with the RMS or CAD to their unique software applications, it will need to obtain them through
Intergraph the cost of which will be the responsibility of the impacted agency as included in the contract.
Neither the ETSB nor the County will be responsible for the costs of interfaces to agency-specific
software. Agency specific interfaces will be configured after the core systems are deployed,
approximately 24 months from date of contract. Itemized cost projections per agency are included with
this document. This information will allow participants with agency specific interfaces the opportunity to
decide whether or not to move to one of the core shared applications versus paying for a specific
interface.
We have made every effort to determine the five-year cost for this system including an equipment
replacement contribution.
We ask that you present the Letter of Intent as is to your agency's corporate authorities, and upon
its approval, execute the letter on your letterhead and return it to DuPage ETSB at 421 County Farm
Road, Wheaton, IL 60187 by June 25, 2016. If some agencies elect not to participate and that reduction
changes the costs to any agency by more than ten percent (10%), we will notify each agency that has
executed the letter of intent of this change in costs and to allow it the opportunity to reassess its intention
to participate.
The ETSB presently anticipates letting the contract before the end of the second quarter, 2016.
The next ETSB Committee of the Whole Meeting is Wednesday, June 1 at 8:30am in the County Board
Room at 421 County Farm Road, Wheaton. This is a two hour time block the ETSB intends to convene
this additional Committee of the Whole for the exclusive purpose of reviewing the details of the contract
before its final approval before the end of June. The ETSB will provide notice for those interested in
attending.
Following the approval of the contract, the ETSB will request the County Board enter into
intergovernmental agreements (IGAs) on the ETSB's behalf with each of the various Public Safety
Answering Points (PSAPs) whose members will participate in DuJIS. The IGAs will outline the
organization of the system and the respective duties of the ETSB and each PSAP. The IGAs will require
each PSAP pass its obligations through to its participating member agencies. Each PSAP will be
responsible for collecting an annual per capita assessment for DuJIS from its member agencies and for
paying those assessments to the County and to the ETSB.
We are providing the following attachments to assist Agencies in making their decision regarding
participation in the DuJIS Project:
• Letter of Intent and Resolution language with requested return attachments
• Steering Committee Structure
• DuPage Customer Pricing Overview (to date)
• Agency Cost Projections Summary (to date)
• Law Enforcement Report Management System (LE RMS) Staffing Overview
• Additional Costs Summary
• GIS Work Flow
Letter of Intent:
As we explained previously, the ETSB has requested that each prospective DuJIS participant present a
letter of intent to its corporate authorities. The ETSB will use each agency's commitment to determine
the total number of participants in the system as well as final pricing. After your agency has completed
its due diligence and approved the letter of intent's execution, please return it to DuJIS Project, c/o
DuPage ETSB 421 County Farm Road, Wheaton, IL 60187. If the number of participants changes the
cost per agency by an increase of more than ten percent(10%), agencies that have indicated participation
will be notified. Once a sufficient number of agencies approve the Letter of Intent, the State's Attorney,
in collaboration with the attorneys for each of the participating PSAPs, will develop a standardized IGA
to implement the system. As noted previously, we anticipate the PSAPs will serve as "contractual
conduit" to help facilitate project implementation and to help manage the flow of responsibilities between
the agencies, the ETSB, and the County in much the same way they did during the implementation and
eventual operation of the radio project.
We ask that you present the resolution authorizing the execution of the letter of Intent to your board or
council at your earliest opportunity and include the backup materials we are providing as attachments to
the resolution.
Organizational Structure:
Upon project commencement, the County will retain a Report Management System (RMS) Manager
though it's Human Resources Department for LE RMS. While the County's Director of Information
Technology and the ETSB's Executive Director will jointly make the final selection, a small panel
representing various LE RMS user groups will participate in the selection process and screen the
applicants.
Though initially an ETSB position, the RMS Manager will transition to the County's IT Department
beginning with FY2017 when the project is under contract and intergovernmental agreements have been
executed with participants. These instruments will obligate the funds necessary for the County to proceed
with increasing its headcount for this project and completing the staffing transfer.
The ETSB will formalize the existing staff work groups which have provided valuable guidance in the
vendor selection process into standing ETSB committees and subcommittees. Once established, these
bodies will proceed through the existing Policy Advisory Committee (PAC), which the ETSB will
restructure to allow for this expanded role. These work groups will also identify, draft and recommend
policy to the ETS Board through the PAC for DuJIS for, but not limited to, standardization of data bases
and mapping/addressing.
Representatives of the County of DuPage, the State's Attorney, the Sheriff, the Clerk of the Circuit Court,
the DuPage Mayors and Managers Conference, the DuPage County Chiefs of Police, the DuPage County
Fire Chiefs Association, the ETSB, and the City of Naperville have and will continue to collaborate on a
consensus-based model to facilitate project implementation. While the ultimate authority for project
management will be coordinated by the County's IT Department (LE RMS) and the ETSB (CAD), the
members of this collaborative will ensure that the entities or elected officials they represent are fully
informed about project goals, development, and the implementation timeline. In this way, as opposed to
the creation of a formalized and rigid governance structure, each entity or elected official retains their
autonomy and must independently exercise their respective functions related to project implementation.
As of the Spring of 2016, State's Attorney Berlin serves as the coordinator of this loose collaborative,
sometimes referred to as "governance" or a "steering committee."
Financial Overview:
We have provided the Intergraph financial cost sheet for your review. This document contains the costs
to date for the system and four years of maintenance. The estimated total cost for the Intergraph contract
is approximately $12M. The coding on this sheet represents CAD (ETSB cost), RMS (Agency cost) and
COM (cost attributed to both CAD and RMS which are split between these two systems). These codes
were utilized to determine the agency share for reimbursement.
The ETSB will advance the initial financing for the entire project. The Agency Estimated Costs which are
shown to the right of the pricing information on the spreadsheet, show the reimbursement required by
Agencies to ETSB. When you met with Mr. David Usery, he provided you with cost estimates for LE
RMS based upon common interfaces. These projections did not include costs for interfaces necessary
to allow RMS to communicate with any additional systems your agency may have elected to utilize (such
as Lexis/Nexis, Livescan, Beast, etc.), maintenance over the life of the contract, personnel or equipment
replacement. For this reason, the numbers you are seeing now are somewhat larger than those you
reviewed in the Fall.
Agency Estimated Costs:
This attachment details the estimated costs each agency can expect to pay for system access. It is
similar in format to the current NetRMS annual billing where the RMS costs are determined per user.
Please be aware that the new system will assign each user a unique sign on and will not support collective
access to the system for a records or investigations department. For this reason, it is critical that you
verify the number of users your agency will have on the system.
When you met with Mr. Usery in the Fall, he provided you with cost estimates for LE RMS acquisition
based entirely on the costs of project acquisition. As was the case with hardware replacement,
subsequent discussions led to the recognition that existing County and ETSB staff could not satisfy the
staffing requirements Intergraph proposed were necessary to properly and effectively maintain a modern
LE RMS. After a thorough review of the proposed requirements, technical experts from the County's IT
Department, the ETSB, user groups, and Intergraph reached a consensus recommendation that requires
the County to increase its existing staff by four (4) full time equivalent positions ("FTEs"). Based on the
County's Human Resources' current salary matrix for the relevant job descriptions, the staff increase will
represent an annual estimated cost of$425,000, including employee benefits.
As is the case with the RMS Manager, all initial staff will be hired through the ETSB's existing budget and
under its headcount allocation. At the start of FY18 (December 1, 2018 for DuPage County), staff
positions dedicated to RMS administration will transition from the ETSB to County IT.
This form also includes costs for participants that have agency specific interfaces. There is an overall
cost sheet and subsequent worksheets which provide greater detail as to how these costs were
calculated. It should be noted that the results are based on information provided by participants. You
should check your agency specific categories with internal staff to ensure it is correct.
RMS Staffing Overview:
This worksheet will provide additional detail for the staffing positions based on Intergraph
recommendations and DuPage County Human Resources'job descriptions and salary matrix.
Additional Costs Summary:
We have attempted to account for any additional costs that may be incurred by participants. To date,
these include CPU/Mobile hardware that does not meet the specifications required for this system,
replacement of the SONET network to a new network to support 911 systems, wireless technology for
mobile terminals and fire station alerting. The attachment provided will contain more detailed information.
GIS Work Flow and Addressing Ordinance:
Mapping is a critical function of the new CAD system which will require standardization. Participants are
encouraged to have an addressing ordinance to facilitate standardization. There is also a flow chart to
outline the process for address changes.
4
PE
DuPage Digital Justice Information System
Project Work Team
Legal Counsel: Rick Veenstra
Governance Advisory Committee:
Bob Berlin, Chairman DuPage States Attorney
Mark Baloga DMMC
Robert Marshall Naperville Police
Andy Bonomo DuPage Fire Chiefs
Tom Cuculich DuPage County
Don Carlsen County Information Officer
Dewey Hartman DuPage Circuit Clerk
Bill Hayden DuPage Chiefs of Police
Jim Kruse DuPage Sheriffs Office
Paul Rafac County Finance Officer
Linda Zerwin DuPage ETSB
TBD Probation
Project Manager: Deltawrx, LLC — Report to ETSB/Linda Zerwin
Finance/Legal Team:
Paul Rafac, Lead County Finance
Don Carlsen County IT
Bill Hayden DuPage Police Chiefs /Village of Addison grant
Jim Kruse DPSO
Jim Jackson DuPage Fire Chief Association
Rick Veenstra SAO
Linda Zerwin ETSB
Rebecca Cussans County Procurement
Tech Team:
Matt Baarman, Lead DU-COMM
Scott Klein DU-COMM
David Jordan DPSO
Wendy Wagner County IT
Eric Sherpan County IT
Jerry Furmanski ETSB
Jason Arres Naperville
Jason Snow Naperville
Mike Sampey ACDC
GIS Team
Tom Ricker, Lead County GIS
Mike DiGiannantonio ETSB
Mike Chastain DU-COMM
Jason Snow Naperville
Law Enforcement RMS Team:
Law Enforcement Executive Team
Dave Anderson Lisle PD, LE
Tom Kammerer Naperville PD, LE
Greg Vesta Wood Dale, LE
Sworn LE Executive DuPage Sheriff's Office, LE
User Group Team
Patti Taves, Lead Glen Ellyn PD
Mike Tierney Addison PD
Tracy Adams Downers Grove PD
Mike Novak Hanover Park PD
Jan Barbeau Wheaton PD
Diane Schlake Naperville PD
Mike DiGiannantonio ETSB
Tom Brown DPSO
CAD Team:
Jennifer Rizzo, Lead Downers Grove PD
Heather Lippe Downers Grove PD
Delores Temes ACDC
Brandon Hurd ACDC
Ron Gross DU-COMM
Jenny Bostick DPSO
David Jordan DPSO
Kalah Considine Naperville
Jerry Furmanski ETSB
Mike DiGiannantonio ETSB
ETSB Deputy Director ETSB
Fire Team:
Dan Anderson Roselle FD
John Sullivan Addison FPD
Andy Bonomo York Center FPD
Steve Riley Westmont FD
Eric Kramer Addison FPD
Amy Schelier Naperville FD
Jim Halik Westmont FD
CAD/Mobile(WebRMSTBR M US$ us$
iw
Production Eavironweot Beat Servers
Dell PowerEdge 8630-Two 22-Core Rceaaanrs;384GB RAM',vSphem EnterprisePlus v6.x(Q2);Dual
Internal SD Cards for OS,DVD-ROM Combo Dnve;Quad Pon 1GB NIC.HBA,Dual Redundant Power Production Emhonmwt Host Servers COM 6 $ 33.750 S 202,500
Supplies;6 veer Pre-Paid ProSUppon and bhssioa Critical Package(4-hours 7,24 on-site support)
Microsoft W ivdows Server 2012 R2 Damcemer Production Emiromnent(Base) COM 6 S 5.816 $ 34.896
GAD Wtaba.S.-err#?
Microsoft SQL Server 2012 ENT Edmon RUNTIME-2 core pack(7LQ-()OOl) CAD Database Server#I COM 6 $ 790(, $ 47 400 $ 8,064
IBxcetmve Ffgh Availability,(IPSOOOIHA) Monitors CAD system transactions- CAD 1 $ 73,459 S 73,459 $ 16,800
Includes ANUALI
CAD Database Server#2
Microsoft SQL Server 2012 ENT Edition RUNTIME-2 core pack CAD Database Server 92 COM 6 $ 7.900 $ 47.4(KI $ 8.064
Microsoft Visual Studio Frofess1om12012 COM I S 580 $ 580 $ 139
CAD Archive/ire its/Web Server
Microsoft SQL Sarver 2012 ENT Edition RUNTDAE-2 core pack(7LQ-00001) CAD Archive/Reports/Web Server COM 6 $ 7900 $ 47,400 $ 8,064
IBackup-No Cost License(IPS0035NC) Facituar es backup of the CAD CAD 1 Included min additional cost
database to this tertiary server
GAD Web S.-
1/NetVrewer-200 users CAD 1 $ 171,959 S 171959 $ 35.544
I/Ne Dispatcher-25 concurrent users(IPS0045b CAD 1 S 111,300 S 111,300 S 23,004
Business Intelligence Direct-:Server
BIDneet for mPURSUFr WebRMS(inrludes 20 CC User Licenses)(SBND3090L) PRMS I $ 24000 $ 24.000 S 5.904
SAP BwOBJ Intl Plat for Direct-20 CC-Comp(IPS21183C) PRMS 1 $ 17,400 S 11.400 S 2,820
Business maclia erm Direct for CAD Bundle-10 NUL(SBND3081L) CAD I $ 18.000 $ 18.000 $ 4296
SAP BusOBJ Intl Plat for Direct-10 NUL-Comp(IPS21006C) CAD 1 $ 8,700 $ &700 $ 2.052
Business lnteHi nce'Direct WebRMS Database Server
Microsoft SQL Server 2012 ENT Edition RUNTIME 2 core pack(7LQ-00001) Business Intelligence Direct WebRMS Database Server COM 6 S 7900 $ 47.400 $ 8,064
lmerface/Communications Load Balanced Servers#1-3
Araomatic Nwnber Idermfcaamr/Amoomm,Location CAD I Included at no additional cost
AM-AL](Included with UExecudve) Identification
Master Clock Interface CAD 1 Included at no additional post
PrcQA Interface Mcluded with I/Di archer) CAD 1 hlchded at no additioml cos;
Ulnformer(/PS0004) CAD 1 S 24.486 S 24.486 $ 5.064
Custom Services for 1/1.1opper to Smte aM LEADS/NCIC Message Switch(IPSCADCUST-IPSOOO'AD_,q_ external interfaces CAD 1 S 2&888 $ 28888 S 5,778
A) 9uem
Custom Services for I/Imminner to ICLEAR(IPSCADCUST4PS0004-B) CAD 1 S NA44 S 14.444 $ 2.889
Custom Services for I/Infonner to DMV Image Support(IPSCADCUST-IPSO(KN-C) CAD 1 I S 21.666 $ 21.666 $ 4.333
Cmsmm Services for Ulnformer to FIREHOUSE F-RMS(JPSCADCUST-IPSOOOaE) CAD 1 S 7.222 S 7.222 S 1,444
Create.Services for additional I/Informer Queries to Smte Message Switch(CQH.CQR,Hanmmp Assmnes one Legacy RMS System Database CAD 1 S 28,888 S 28,888 $ 5,778
Placard,aM FOID and to support name soublex)(IPSCADCUST-IPS0004-F1
Custom Services for lMfonner to OdeaderWatch Svnan(IPSCADCUST-IPS0004-G1 CAD 1 $ 14.444 $ 14.444 $ 1889
Informer Transactions for Mobile Res nder(IPSCADCUST-7 CAD 1 -$$ 7„1.22 S 1444
Uhtformer Nested Queies(IPSCADCUST-22) CAD 1 S 26.664 S 26664 S 5.33'
for W ebRMS NL(IPS00 4WR) CAD 1 Included at no additional post
E eFrontier Runtimee Engine IP53041) CAD 1 $ 2(.000 $ 20.000 S 4.800
CAD Edy&mmer Custom Interface for Alerts and Flags requirements support(IPSCADCUST--3) CAD 1 S 14,444 $ 14.444 $ 2,859
CAD EdgeRreame,Custom Interface for Call S /Qce- Su (IPSCADCUST-4) CAD I $ 4,333 $ 4.333 S 867
I/P e(IPS0012) CAD 1 $ 22.260 $ 22,260 $ 4.596
I/relephen,Device for Deaf-Zetron(IPS0018 CAD 1 $ 114130 $ 11.130 $ 2.304
UFRMS-CADlink(IPS0048-1) FnoHouse F-RMS PRMS 1 $ 11.130 $ 11.130 $ 23CN
I/Fmc Station,Alert (IPS0052) Station Aleman System CAD I S 11.130 $ 11,130 $ 2.304
UDeccan LrveNfUM lntcrfer,(IPS(M)65) CAD 1 $ 5.565 $ 5.565 $ 1.332
Smarr 911 Interface(IPSCADCUST-6) CAD 1 I$ 2L666 S 21.666 S 4333
Per additional erdp ima third-pans,database Assumpoon:
FFRMSLmk for Firehouse-Per additional endpodthhod-pans database(IPSCADCUST-9) All are w the same protocol and each agency derabase ADD 26 $ 1 444 $ 37,554
has its owv CAD Monitor from FIREHOUSE.
Custom Services for IMformer to FIREHOUSE FimRMS-Per additioml ages matabase ADD 26 $ L4" S 37,554
(IPSCADCUST-11)
Smart 911 hterface-Peraddibonm PSAP/Conuweuon(IPSCADCUST-101 Per additioml PSAP/Connection - CAD 4 S 16250 $ 64098 S 13_000
Interface/Commanicati-Load Balanced Rednodw Servers#1-3(hot faitoven)
AM-ALI(included with IBxcentive)(AM-ALI) CAD 1 Included atno additioml coat
Masser Clock.Interface(XNTP) CAD 1 I Included at no additional post
PmQA Interface(Included with I/Di tcher I(PQA) CAD 1 Included at no additioml cost
k/nronner-Redundant License(IPSCADCUST-IPSOOCi4RDT) CAD I S 17,140 S 17,140 S 3,540
I/Inf reser for W ebRMS NL-Redundant License(IPS0004WRRDT) CAD I Included at no additional cost
EdgeFrocalber Runtime agame-Redundant License(IPS3042-RDT) CAD 1 S 14.000 1 S 14.0(0 S 3.360
I/P e-Redundant License(IPS0012RDT) CAD i S li58 2 S 15.592 $ 3.216
I/'fele hom Devicefor Denf-Zerron-Redundant Liceme,OPS0018RDT) CAD 1 $ 7.791 1 S 7.791 S 1,608
Standard and Custom Interfaces-Test,Training_Redundant and Backup Copies of proposed interfaces
vailable for all Interface Server,however,implementation is subject to the customer's ability-to
provide wmwtion to the applicable watere
Mobile Data Server#1
I/MObde Data Terminal(1PS0009) CAD $ 48.972 S 48.972 S 10.128
f/fracker(IPSOOIS) CAD 1 $ 27.825 $ 27.825 $ 5,724
Mobile Data Server 92(Load Balanced)
I/ .pole Data Tenmiml(IPS0009) CAD 1 S 48.972 $ 48.972 $ 10.128
I/fracker(TPS00151 CAD 1 I$ 27.82 5 $ 27.8125 $ 5.724
Mobile Data Se-#3
I/Mobile,Dam Terminal(IPS(009) CAD 1 S 4897? $ 48972 S 10.728
I/Iracker OPS0015) CAD 1 $ 27.825 $ 27.825 $ 5.724
meerpa h Mobile Responder Server(251-750 Users)Bundle(SBND32071-) CAD 1 S 40.000 S 40.000 S 9,144
WehRMS Database Server#1
Microsoft SQL Server 2012 ENT Edition RUNTIME-2 core park(7L(i-00001) WebRMS Daum-Server#1 COM 6 S 7.W, S 47.400 S .8.064.
WebRMS Database Se p 412
Microsoft SQL Server 2012 ENT Edition RUNTIME-2 core Fack(7LQ-00001) WebRMS Database Server#2 COM 6 $ 7.900 S 47.400 $ 8164
WebRMS Applicatim Claatered Se-r#1 thru#4
WebRMS Server Lt.-(RMSO0)61 WebRMS Emironmtent Server License to be iasmlled on PRMS I S 87,000 $ S-1 $ 20.820
applicable WebRMS Production AppImap-Servers
Apache Tomcat 6(Free DOWNoad, COM included m er additioml cost
Crystal Reports for E.Imse, COM - included st no admnomi cost
WebRMS A heation Clnaered:Reduadaet Server:('#5)
WebRMS Server License-Redundant La-(RMS0016RDT PRMS I S 60.900 $ 60!900 S 14,590
WebRMS Iaterfaee Loud Baaaced Servers:#1-3
Edgel'one rRuntime En e('IP53(02� PRMS I $ 20!000 1 S 20.000 S 4800
Intergraph WebRMS Connect for F eFrontier IPS2043 PRMS 1 Included aino additioml wst
RMS EemeFpcomer Cuttomvanon for BEAST interface(RMS)(IPSRMSCUST) B,-I),--1 PRMS 1 $ 7,220 S 27220 S 444
RMS EdgeFmntier C--n-for APS Virtual Partner 2imerface MMS)(IPSRMSCUST-1) 1--Import PRMS 1 1 23311 1 1 23.311 1 4,666
RMS EdgeFrotmer Customization for Motorola OffeMeumk interface(RMS)(IPSRMISCUST-4) Bi-Directional(Sherif]'a Office) PRMS I S 31,108 $ 31,108 $
RMS EdgeFuuma,Customs lion for LiveScm interface(RMS)(IPSRMSCUST-5) Bi-Dhxtional PRMS 1 $ 15.554 S 15,554 $ 3,117
RMS FdgeFrontra,Customization for L-Sean intetface(RMS)GPSRMSCUST-5-1) Bi-DUecuoml ADD 4 $ 15,554 $ 62216 S 12,443
RMS Fd eFrontier Cmanumaum for OffenderWauh lnmrfam(RMS)(IPSRMSCUST-6) 1-Export(ShanfFs Office) PRMS 1 $ 23,331 S 23,331 S 4,666
RMS EdgeFrormer C Wotnvation for Slate's Attorney's Office(SOP)juterfece(RMS)(IPSRMSCUST- I way Export PRMS 1 S 29,164 S 29,164 $ 5.833
71
RMS EdgeFrontier Customization for DuPage Court System(DUCS)interface(RMS)(IPSRMSCUST-8)Br-DUectioml PRMS I $ 93324 S 93,324 S 18,665
Ca ion Case Probation Management monfam(RMS)(IPSRMSCUST-13) Vendor View PRMS 1 $ 7.777 S 7-777 $ 1,555
FBUNIBRSSubmiwxm(RMS)(IPSRMSCUST-]4l _ PRMS 1 S 4.666 $ 4,666 S 933
RMS to M foumer for LEADS/NCIC Quenee(IPSRMSC(JST-I 6) PRMS I S 7.777 $ 7.777 $ 1,555
RMS to 1/lnformer for ICLEAR Quenes(IPSRMSCUST-17) PRMS 1 $ 7-777 S 7.777 $ 1,555
RMS EdgeFrmmer Customization for BEAST Interface(RMS)-for Each additional code table Per each additional code table configuration Assumption:
configurmon(IPSRMSCUST-20) the data format to and from all BEAST systems is the ADD 24 $ 7,575 S 181,800
Per each addim mat Protocol/FormaL Assume an report
m matelupdate an arrest and booking record and link the
RMS EdgeFronuer Customization for Liv.Scan Interface(RMS)-for Each Additional ProrecoVFormat. two. App 27 $ 7,777 S 209,979
(IPSRMSCUST-21) M--ue that all Livescan vendors will push dam to
Intergraph web service and push the data to Intergraph
preferred XML format.
WebRMS Interface Redundant Load Balanced Seruers#1-3
eFronner Runvme inc-Redo da,License(IPS3042 RDt) PRMS 7 I S 14,0001$ 14.00(1 $ 3,360
Imer h WebRMS Cornea f u .Frontier-RDT(IPS2(143RDT) PRMS 7 I hxluded at no addiuoml cost
FBR for WebRMS Application Servers A and#2
FBR for WebRMS Err-mamma Server License to be
WabRMS FBR Server(RMS0028) installed on applicable FBR Production Application PRMS I $ 29,000 $ 29DOG $ 6,972
Servers
Microsoft SQL Server 2012 R2 Express(Downlmd) COM 2 Included at no addiuoml cost
FBR FO,-WebRMS Redundant Sewer(0).
WebRMS FBR Server-Redundant License PRMS 1 S 20.3. $ 20,300 $ 4.884
Microsoft SQL Server 2012 RI-Express(Download) COM 1 Included at no additional cost
,Center Server(Prodsctian Fmvironment
Microsoft SQL Server 2012 R Express(Download) COM 1 hsluded nt no addammal cost
VM-ne vCenter Server Standard for vSphme 5-(v.5)-license-1 instance(eludes 5 veers prepaid Production Em%uoum®t(Be.) CAM 1 $ 12,620 $ 12,620
VM-ne Support and Subsea-prom Technical Suppoil
...
CAD Database J-.taterfam/{omrmnitations Test Server
Microsoft SQL Server 2012 ENT Edition RUNTIME-2 core pack CAD Database/Interface/Communications Test Server COM 4 S 7,900 $ 31.600 % 5376
AM-ALI(Included with nxeeutive)(ANI-ALD CAD 1 Included m e additional cost
Master Clock In erface(XNTP) CAD I Included at m additional cost
ProQA Interface eluded with LTh tcher A) CAD 1 hreluded at no additional cost
VExecutiee Ifigh Availabiho-Test Licence CAD 1 Included at no addmorm]coat
I/NetViewer-5 concurrent users-Test License CAD 1 Included at no additional cost
UNetDi dhm.5 concurent users-Test Licarse CAD I Included at no additional cost
Vlnformer-Test License(IPBCADCUST-IPS0004TST) CAD I lnciuded at no additional cost
eFmmier Runtime ImEma-Test License 53042-TST CAD I Included at no additional cost
.Frontier Dcvelo e IPS3042DEV CAD 1 $ 15000 $ 15-000 $ 1600
UM.mle Data Temuml-Test Llama.(TPS0009TST) CAD 1 ]mlW d at no addiuoml coat
IfFracker-Test License IPS.ISTST CAD 1 Included at no addiuoml cost
Standard and Custom Interfaces-Test,Trai^g,Redundant and Backup Copies of proposed ro-faces
arc vailable for all Interface Serves,however,implementation is subject to the cor Omer s abilm•to 1
provide connection to the applicable water.
WARMS Database(Application/Interface/FBR Test'Server
Microsoft SQL Server 2012 ENT Edition RUNTIME-2 core pack(7LQ-00001) WebRMS Database/Appumuon/Interface/FBR Teat COM 4 $ 7.900 $ 31,600 S 5,376
Sery
WabRMS FBR Server-Test License PRMS 1 Included at no addiuond cost
W&RMS Server License-Test License PRMS 1 hrcludedatnoaddiumalcost
Apache Tomcat 6(Free Download) COM I Included at no addiuoml cost
Crvsral Repom for Ecu w COM 1 meWd d at no addiuoml con
Standard and Custom Interfaces-Ten,Tmuung,Redundant and Backup Copies of proposed maerfaces
are available for all Interface Server,however,unplemenum is subject to the customer's ability to 7
provide co action m the appbe.ble aysrem.
EdgeFronuer Runtime Engm,-Test License(IPS3042-TST) PRMS 1 lncluded at no addiuoml cost
to h WebRMS Councct for EdgeFrmtier-TST(IPS2043TST) PRMS I Included at no additional cost
DOOTM
'VERY;* ��
Backup Bavir aveat Hust Servers
Dell P-Edge R630-Two 22-Core Processors;384GB RAM:vSphere EmcrprisePlus v6.x(Q2);Dual
Internal SD Cards for OS.DVD-ROM Combo Drive,Quad Port 1 GB NIC;HBA;.Dual Redundant Power Disaster Recovery Emironment(Base) COM 5 $ 33,750 $ 168.750
Supplies.6 yea Pre-Peed ProSupport and Mission Critical Package(4-hours 7x24 on-sire support)
Dell P-Edge R630-Two 22-Core Processors;3 940 RAM',vSphere Emcrp-Plm v6.x(Q2);Dual
buornal SD Cards for OS;DVD-ROM Combo Dnve,Qued Pon IGB MC;HBA;Deal Redundant Power Disaster Recover Environment(Rase) ADD I $ 33,750 $ 33,750
Supplies;6 vea Pre-Paid PwSupport and Nfnasiou Cnucal Package(4-houns 7x24 on-sim support)
Microsoft Windows Server 2012 R2 Datua emer Disaster Recover-Em'uomnent Base COM 6 $ 5,816 $ 34.896
CAD Database Load Balanced Disaster Recavery Servers#1-3(cold standby)
Microsoft SQL Server 2012 ENT Edition RUNTIME-2 core k -00001) CAD Database Diaaata Race en'Server a I(cold
pack(7LQ atadbvl COM 6 S 7.900 S 47,400 S 8,064
VExecmive Hgh Availabillh-Backup License CAD I 7 Included at no additional cost
CAD.Database Load Balanced RedundaatlDisaster Rec' Serve s NI-I(cold standby)
1,6-ft SQL Server 2012 ENT Edition RUNTAAE-2 core Pa ck(7L 000011 CAD Dumb-Disaster Recover Server 42(cold
smndbv) COM 6 $ 7,900 S 47,4. $ 8,064
Microsoft Vemal Studio Profesdoml 2012 COM 7 S 580 $ 580 $ 139
CAD Arekive I Jkeports 7 Web Disaster Reeovery Server'<
Microsoft SQL Server 2012 ENT Edition RUNTBv1E-2 core pack(71.Q-00001) CAD Arcmve/Reports/Web Di.-Recn-Server COM 6 $ 7,900 $ 47,400 $ 8,064
I/NetViewer-100 concurrmt users-Backup License(IPSO(N2CBCK) CAD ] Included at no additional cost
I/NetDi anther-25 concurent users-Backup Licence(IPS0045FBCK) CAD ] I hicluded at no addiuoml coat
:BusiaesslateHi es.Direct Disaster Recovery Server
BI-Direct for CAD-Baeku I,-(SPR) CAD 1 Included at no addiuoml cost
BI--Direct for WebRMS-Backup License(SPR) PRMS 1 Included at no addiuoml cost
CAD Interface I Communications Disaster Reto Server#1(said standby)
ANI-ALI(Included with VE.e.ve,(ANI-ALI, CAD I lneluded at no addiuoml con
Master Clock Interface CAD 1 hcluded at no addiuoml oust
ProQA Interface(Included with tcher)(PQA) CAD I Included at no additional cost
I/m o met-Backe License(IPSCADCUST-IPS0004BCK CAD 1 lmluded aI..adduoml coat
Edgel',comer Runtime En e-Backup Lieemse(IPS3042-BCK) CAD 1 Included at no addiuoml cost
VP e-Baeku License(IPSOMBCK) CAD I 1 memd d at no addiuoml coat
Irl.i hone Device for Deal-Z.-.-Backe License(IPS.I 8BCK) CAD 1 Included at no additional cost
Standard and Ctaon Interfaces-T.I T.n.^.Redundant and Backup Copies of proposed interfaces
vailable for all Interface Server,however,implementation is subject to the customer s ability m I
pmvide connection w the applicable aystem.
CAD Interface/Communications Disasieriitecove Server#2(cold standby)
. .
It '
MPS Workflow and Configuration Workshop I(IPST2502) CAD $ 23.028 $ 46.056
MPS Workflow and C-fi tint Worksh B(IPST2502) CAD 2 $ 11,514 $ 23,028
MPS Workflow and C ifi tim Worksho BI(IPST2502) CAD 2 $ 11.514 S 23028
MPS for Trainers(IPST2503) CAD 4 $ 6-969 S 27.876
I/Im,dmt Aut lest Covfi lion aad Administration(IPST6001) CAD I $ 11-514 $ 11.514
111-dent Aralvsl User Tmrniv (IPST6002) CAD I $ 8,494 $ 8,494
81 Direct far CAD-System Admuust ao,Tmmm IPST7008) CAD I $ 5-454 S 5454
BI Direct for CAD-User Training(IPS17009) Uw n^8 tra,ng Inducted the same v k as Sirs Admen CAD t $ 4,545 $ 4,545
BI Direct for WebRMS-User T (IPST3300) PRMS 1 $ 5.454 S 5.454
Bl Direct fm WebRMS-Sv9mh Administrator Tmmmg(IPST3301) User trammg conducted the same week as Svs Admm PRMS 1 $ 4.545 $ 4,545
T-g for BI
WebRMS Syslcm Overview&Cotifigurbut,Tmuung_ (IPST3501) PRMS I $ 9.999 $ 9,999
FBR for WebRMS SvA=IT Admm-ve T ST4010) PRMS 1 $ 9,999 $ 9,999
FBR Svslem Overview and Configunition T - (IPST4011) PRMS 1 $ 9.990 $ 9.999
WebRMS System Admwsti -T Comse(IPST3502) PRMS I $ 9.999 $ 9.999
WebRMS Trani-The-TrimcrT raining(IPST3503) PRMS 4 $ 11.514 $ 46.056
FBR for WebRMS Train-The-Tramer Training(IPST4012) PRMS 4 $ 9,999 $ 39,996
WebRMS Repers and Deplovioent(IPST35(W PRMS 1 $ 9.999 $ 9.999
Ed,,Frontier Develeper Tra COM 1 $ 20.050 S 20,050
Shipping,Installation,Bonds;Escrow,insurance,Watirainly
SluppuW and Insurance COM I $ 6.914 $ 6.914
Escrow Admimsfration fee COM I $ 500 $ 500 $ 500
Bnsin,,ss Intelli enm software ywananly dmg rm lamentation period COM I $ 7.788 $ _7m788
Hardware SLgmg&Installation Services COM t $ 63A38 $ 63A38
Hardware Smgmg&losmllatim Services ADD I $ 14-987 $ 14.987
TOTAL SYSTEM BASE PRICE-
Sub-Total Exclusive of Discount,Extended Warranty,Maintenanre,Options&Taxes Is 10,246,874 S 1,351,463
(-Toum DismmP f r iuh.t rmchase onb DL 1 $ 0606--;95
Sub-Total Exclusive of Extended Warranty,Maintenance.Options;&Taxes -':S -6;649,479 S .1;351;463
First Year m h Maintenance.(Extended Software Wmranly) 1 $ 1251,505
Disarmtan Fiml Sear lvmrmaoh Maintenance DISM 1 $ 118'726
First Yem Third Pam Maintenance(Extended Software Warrant,) 1 $ 99958
Grand Total Exclosiveof Taxes Tax Exempmon assmned >$ 7;804,216
Second Year 3rd Pam'Software Maintenance after wursnt, COM 1 S 104,956
Second Yen Inner h Software Maintenium after warrants COM 1 $ 1.116968
Mamteumce Year 2-Upgde Pro am -U ade-histallmmt 1 of 3) CAD 1 $ 100,000
Third Yem 3rd Pam Software Mamwm= COM I $ 110204
Third Year Software Maintenance COM 1 $ 1,1718)(3
Hardware Stage&Imstahaum Services for Bud-Refresh durig amterance COM I $ 34.596
Monuenance Year 3-Upgrade Progmm ffu Upgrade-Lusubment 2 of 3) CAD 1 $ 100.000
Fourth Year 3rd Pam Software Mamterur- COM I $ 1 I�714
Fourth Year Software Mamterance COM 1 $ 1231.457
Mu rr ee Yem 4-Uplmde Program(First.Upgmde-1-11mene 3 of 3) CAD t $ 100,000
Fifth Year 3rd Pan,Software Maintenance COM I S 121500
Fifth Year Software Maintenance COM 1 $ 1293 030
Total for Additional Four Years'Maiatenanee after Extended Warran $' 5,601.241
CAD Sub-System CAD 1 $ ✓4,288,020 S 1719.736
Police RMS Sab-Sysmm PRMS 1 $ 2.901,736 $ 519,326
Additi onal Ageaey Costs ADD t $ 1,013,206 $ 11443
Common Items (PM Services,Eserow,S m.Third Pant-,etc.) COM I $ 1043912 S 99.958
Svst,,m Di-- DIS 1 $
(3,606395) S (197,726)
Total Price for Complete System $ 6,640,479 S 1;163,737'
fP�mugsnttsrxrm reaar BdWN W iyleaeaMiaxrri�.aheahma4.8ffid.Prrrlrm4aR Faam
aft Ve94 bt^ a64Nx daiW�rVMa IbemavKatletlN.
,D ...i mee Sevrces:
CAD Fit&Gap CAD 1 $ 98.071 $ 98-071
CAD Re uiremenm Aralems.D-gr CAD I $ 147-359 S 147.359
WebRMS Fit&G A 1-, PRMS 1 $ 35.754 $ 35.754
WebRMS R --u Analysis.Den PRMS t $ 61358 $ 61358
CAD Resident Systems Amivst(Year 1) CAD 1 $ 245-174 $ 245.174
RMS Resident Systems Anelvst(Year 1) PRMS 1 $ 245.174 $ 245.174
O p"eaal In SYaadard Prddaetsaad 1.w faces
UFRMS-CADtnk(IPS0048 2) Fire Progreris FueRMS CAD 1 $ 11.130 $ 11,130 $ 1104
1/CADLmk IORMS(IPS0051-1) ICLEAR CAD I $ 11I30 $ 11.730 $ 13(14
I/CADLink m RMS(IPSW51) hna eT e d CAD I $ 117130 $ 11 130 $ 2304
UFRMS-CADIivk(IPS0048) yoll FueRM_c CAD 1 $ 11.130 $ 11.130 S 2304
I/FRMSLink for Zoh-Per additional end mt/thud- dambase(IPSCADCUST-12) ADD t S L444 $ 1 444
O 'n-llmu, De%d, l-f-
CAD EdgeFoeuber Cusom mtef ce for False Alirm iffitd a Atanv Billing dam transfer from CAD to CAD 1 $ 74,444 S ]4,444 $ 2,689
WebRMS(IPSCADCUST-51
RMS ,,Frontier Customveuon for DACRA interface(RMS)(IPSRMSCUST-2) 1-wa,hn n PRMS 1 $ 23,331 S 23331 S 4.666
RMS EdgeFrontier Cuoorn-lion for Trimble-Visual 3mtement interface(RMS)(IPSRMSCUST-3) 1-wan Import PRMS 1 $ 23331 $ 23 331 $ 4566
RMS ,,Frontier Cusmmvaton for Co Logic Interface(IPSRMSCUST-10) 1-war'I.P- PRMS 1 $ 21331 $ 23.331 S 4666
1-wan accident Import from multiple agency/databases.
Assume that Lem,-Nexus vendor will push dam to
RMS EdgeFronuer Customizatim for Levis-Nexus Interface(RMS) (IP9RMSCUST-7 8) Intergaph web service and pucb the data to Intergraph PRMS I $ 58,328 $ 58328 $ 11.666
preferred XMI,to-,
1-wan accident import from muhuue agen-M-b-s.
RMS EdgeFronbe Customization for APPRISS mtmfaw(RMS) (IPSRMSCUST-19) Assume that APPRISS vendor will push dam to PRMS 1 S 58,328 $ 58328 S 11,666
mtergraph web servhce and push the dam m Intergmph
preferred XML.to-.
RAIDS ONme mterface(RMS)(IPSRMSCUST-12) PRMS 1 $ 1889 $ 3.889 S 778
RMS Eep Frontier C-mvaton for Import Interface for Pawn hdormauon from Lead,onhr, 1_wan Import PRMS 1 $ 23,331 $ _3331 S 4666
(IPSRMSCUST-11) - -
Custom Services fo,Ifh fomher Quen-Interface for L.&Online(IPSCADCUST-IPSW(9-D1 Quern Interface CAD 1 $ 43.332 $ 4333' $ 8666
RMS Ctammir -for IU-Smte Specific UCR Reports (IPSRMSCUST-11-1) UCR Federal Smndard would be delivered as the COTS PRMS I $ 62,216 $ 62,216 $ 12,443
form of the UCR utilin
RMS ,Fromer Cr iomiretm far N-Dex submission port(IPSRMSCUST-9) I-via,E.Pon PRMS I $ 38.885 $ 38.885 $ 7.777
CAD htterface m NICE(Vendor View)(IPSCADCUST) Consulting services w assist third pant with accessing CAD 1 $ 1444 $ 1,444
CAD Vendor View
IDOTlnterfwe(RMS)(IPSRMSCUST-I5-i
PRMS 1 $ 62.276 1$ 62216 $ 12.443
CAD EdgeFrontier Custom Interface to Smunn Inf rmauon Svstems(SIS)Alarm Svsrem CAD 1 $ 14.444 $ 14444 $ 2.889
(IPSCADCUST-1)
CAI)EdgeFroutier C-interface m Smoro,Information Systems ISIS)Alain System-Per additional Per additioual ageoev/dambae mstance ADD $ 7.792 $ 3375 $ 4 675
agenev/dambase instance(IPSCADCUST-8) -
:O 'naa1 CADM1VebRMS Tnrm E-iron-at
AM-ALI(Imluded with I/Exeoume)(ANI-ALL CAD I Included at m additional cost
Master Clock mtertuo,(XNTP) CAD I Included at no addluoral-
YroQA htterface(hhckuded with I/Di teher)(PQA CAD Included at no ed bu.-I-
UExectmve Hi Availabian-
Training Licence CAD $ 36.729 $ 36 729 $ 16.800
1/N.V,--5conctarentruers-T. Licrnse CAD 1 $ 5565 $ 556i S 2304
I/Nctl)i atcher-5 concurrent users-I License CAD 1 $ 13.91-31$ 13-913 1 8 5 724
eFronuer Resume Engwe-Trai Limasc(IPS3042-TRN) CAD 1 S 10.W0 S 10.000 S 4.800
Irmormer-Trainn License(HISCADCUST-IPS0004TRN) CAD 1 $ 12.243 $ 12243 S 5.064
I/M.lule Dam Ic—inal-Tra- 'License(IPS0009TRN) CAD 1 S 24.486 $ 24,486 $ 10,128
Irrracker-Tra License(IP50015TRN) CAD 1 $ 13,913 R 13913 $ 5-724
WcbRMS Server License-Imuun Liczase PRMS 1. $ 435W $ 43500 $ 20.820
W'ebRMS FBR Server-Ira Livens PRMS I S 14.500 $ 14500 $ 6.972
Apache Tomcat 6(Free Download) COM 1 Included at no additional cost
Cn•stal Re r1s for Ecli se COM 1 included at no additional cost
E eFron[ier Runtime e-Tra License(IPS3042-TRN) PRMS 1 $ 10,000 S 10.000 $ 4.800
Intergraph W'ebP-MS Connect for eFronuer-TRN(IPS2043TRN) PRMS 1 included...additional cost
.Standard and Custom Interfaces—Test Training.Redumdant and Backup Copies of proposed interfaces
available fm all interface Server,however.ouplemenmuon is subject to the etutomer biht to 1
provide comreebon to the applicable s•stem- -
Microsok SQL Server 2012 ENT Edition RUNTAAE-2 core pack(7LQ-000011 WebRMS Database/Application/IntMacc/FBR COM 4 $ 7,900 $ 31,600 S
5 376
Training Server
Microsoft SQL Server 2012 ENT Edition RUNTIME-2 core pack CAD Database/Interface/Communications Tcoanag COM 4 $ 7,900 $ 31 600 $ 5,376
Sery
A5 ti...I Itsterwpit Mobile SnImmas
a
Ime h Mobile Re ender Client-100 Tablet CAL,(IP532(4B) CAD 1 $ 22500 $ 22.500 $ M24"4,&56
tote[ a h Mobile R ender Client-500 Tablet CALs(IP53204D) CAD 1 $ 101,250 $ 1 07250 $
lore[ h Mobile Re ndtr Gien1-100 Smartphonre CAI.a 53205B) CAD I $ 15.000 $ 15.000 $
Into h Mobile Res ouder Chem-5w Sma hone CALs(IPS3205D) CAD 1 S 67,500 $ 67,500 $to
caul Tra
UCAD Ecsenualsfor Urem(TI'U)(IPST20(ki CAD 1 $ 11,514 S 11,514
I/CAD Trainer ConsW (T7T)(Q'ST2010, Custom T Documents CAD I $ 19.089 S )9,089
UCAD Tainer Consult (Tra)(IPST2010', Reftasher Tra- CAD 1 $ 71.57 4 $ 11514
WebRMS Customized Trainin (IPST40W-Six Man,ReGesher PRMS 7 S 9.090 $ 9,090
Total Pricefor AIPO linos i`S i,s58,585 S
Notes:
L An overall system disco..,has been provided for this opportunih'.This discount is applicable ooh to Intergraph Products and Services,Third-Park,content is not
dise...ted Changes to scope of the final contract ma}change the discamnt amount Also,anv credits given for tine items as part of a Change Order will include a
reduction for the line prorated amount of the o.e•fime systam discount Items removed after co.tr.ct signing will result in a contract credit for future Intergraph
software and services beiag established,out a contract red.etio..This discount is based on the meepeame -'Intergraph's standard Terms and Conditions.
2 Unless otherwise meed,project management services,impkmeetafio.services sod software mat......c ARE NOT included in.pit..pricing.Intergraph services are
vafid for 6 mo.tbs a.d Intergraph product pricing is slid for one year after contract signing.Pricing for optional third parr'products aad services are valid for
90 days from the date o.this pricing proposal Intergraph can provide a fixed quote when optional items are selected.
I Standard ad Custom Interfaces—Test,Training,Redundant end Backup Copies of proposed umed.—are available for all Interface Server,however,implementation
subject to the customer's abilih to provide connection to the applioable.systam.
4.Intergraph has based its WebRMS Items.offering up..the following ass.mphons:The.umber of users indicated as"mrl.g RMS aecess(2,000)is the total.umber of
users.The C...t'would have no more than 113 of its total.umher of users logged on to RMS workstations at any one time for purpoms tadmdt.g,but not limited W
records in—g—ml,mporfi g,and crime—ism,The qua.fin and price of client user licenses will be adjusted to reflect actual usage at time of contract
negotiation.
5.Saks tax is not included in this quote.Final cads as billed will reflect the applicable tax rates at fime of sale as required by law.
6.EdgeFroufier Developer Lim...ca,be installed on up to two separate servers for use in the development of CAD and RMS laterfaces.The Developer instance of the
ticease is—,113 installed o.the Test Interface Server.
Estimated Fiscal Years FY16 FY17 FY1S FY18 FY19 FY20 FY21 FY22 FY23
Total Equipment
ESTIMATED PROJECT New RMS Agency Specific Replacement
AGENCY COST SUMMARY June 1 2016 TOTAL FY16 NetRM5 FY17 NetRMS FY18 NetRMS New RMS Capital Yrl Vr 2 Yr3 Vr4 Vr5 Interfaces Fiber Network Cost II Users %Total Contribution
.. Cast Per User $ 138.24.. $ ' q,48.$ 5233 $ 1,118:43 $ :747,91 $ 718.251 $ 733,12 $ 748,61 $ 764.75, $, 3,000,000.00.'
BARTLETT POLICE $ 642 354,76 $ 14,930.40 $ $5,449.61 $ 6,192 OS $ 120,790.03 $ 76,453 97 $ 77,570.66 $ 79,176 96 $ 80,849 94 $ 82,592 87 $ 1-0,291 $ 38,064 108 5433 $ 160,000 00
$ -?'
BENSENVILLE POLICE $ 329,710.10 $ 7,465 20 $ 2,724.80 $ 3,096.02 $ 60,395.01 $ 38,226.99 $ 38,785.43 $ 39,568.48 $ 40,424.97 $ 41,296.44 $ 19,643 $ 38,064 54 2.67 $ 80,000.00
BLOOMINGDALE POLICE $ 118,151.95 $ 1,658.93 50551 $. 68801...$ 13,421.11 $.. .8,49489 $ 6,618.98 $ 8,797.44. $ .8,983.33 $ ,9,176.99 $ 19,643 $ 38,064 12 0.59 $ 17,777.78'.
BURR RIDGE POLICE $ 217,818.91 $ $ $ $ 39,144 92 $ 24,776 75 $ 25,138 70 $ 25,659.20 $ 26,201 37 $ 26,766.21 $ 12,068 $ 38,064 35 1.73 $ 51,851.65'
CAROL STREAM POLICE $ 475 785.97 $ [ 11,474.29;. $ 4,18612 $ 4,758 70 ,$ 92,829.37 $ 58,756 29 $ '; 59,614 64, $ 60,848.96. $ 62,134 68 $: ...63;474.15 $ 19,643 $ 38;064 83 : 4.10 $ : 122,962,96
CLARENDON HILLS POLICE $ 121,997.68 $ - $ - $ - $ 16,776.39 $ 10,616461 $ 10,773.73 $ 10,996.80 $ 11,229.16 $ 11,471.23 $ 12,068 $ 38,064 15 0.74 $ 22,222.22
COLLEGE OF DU.PAGE POLICE $ - $ $ - $ :,.. $ $ $ .. $ $ $ $ _$
DARIEN POLICE $ 279,339.11 $ 6,082.76 $ 2,220.21 $ 2,52169 $ 49,210.75 $ 31,147.92 $ 31,602.94 $ 32,257.28 $ 32,938.87 $ 33,648.95 $ 19,643 $ 38,064 44 2.17 $ 65,185.19
DOWNERS GROVE POLICE ,: S $ 527;230.78 $ $ $ - $ 109,605.76 $ 69;37490 $ $ 71,84576 $ 73,363,84. $ $ ..19,643 $,_ ..38,064 98 ..4.84 $ 145,185.19<
DU PAGE FOREST PRESERVE POLICE $ 146,868.87 $ 4,009.09 $ 1,463.32 $ 1,662.68 $ 32,434.36 $ 20,529.31 $ 20,829.21 $ 21,260.48 $ 21,709.71 $ 22,177.72 $ - $ 793 29 1.43 $ 42,962496
DU PAGE SHERIFF OFFICE : $ 1,589,584.67 $ 38,846 69: $ :14,179.07 $ ::.16,110.79 $ 314,277.75 $ 198,921 91 S 201,827.89. $ 206,006 72 $ 210,359.57 $< 214,894 41 $ 136,096 :,$ 36,064 281 13488 $ 416,296.30:..
DU PAGE STATES ATTORNEY $ 73,439.30 $ 414.73 $ 151.38 $ 172.00 $ 3,355.28 $ 2,123.72 $ 2,154.75 $ 2,19936 1$ 2,245.83 $ 2,294.25 $ 58,328 1 3 0.15 $ 4,444.44
DU PAGE CIRCUIT CLERK $ 186,648 00 $ 186,648
DU PAGE COUNTY PROBATION $ 15,554.00 $ 15,554
ELMHURST POLICE $ 651,342.46 $ 13,547.96:. $ 4,945 01 $_.. 5,618.71.. $ 109,605 76 $ 69,374.90 $ 70,388 37', $ 71,845 76 $ ...73,363.84 $: 74,945.38 $ 19,643 $ 38,064 98 ? 4.84 $ 145,185.19
GLEN ELLYN POLICE $ 354,895 60 S 8,156.42 $ 2,977.10 $ 3,382.69 S 65,987.14 $ 41,766.52 $ 42,376.67 $ 43,254.08 $ 44,168.02 $ 45,120.18 $ 19,643 $ 38,064 59 2.91 $ 87,407.41
GLENDALE HEIGHTS POLICE. $ 455.637 58 $ 10,92131; $ 3;986.29 $ 4,52937;. $ 88,355.67 $ .:.55,924.67 $ 56,741.65.. $ 57,916,48 $ $ 60,415.16 $ ,19,643 $ 38,064 79 ` 190 $ 117,037 04'
HANOVER PARK POLICE $ 538,528.36 $ 13,409.71 $ 4,894.55 $ 5,561.37 $ 108,487.34 $ 68,666.99 $ 69,670.13 $ 71,112.64 $ 72,615.23 $ 74,180.63 $ 11,866 $ 38,064 97 4.79 $ 143,703.70
HINSDALE POLICE $ 234,005.22 $ 56.. $ 1,766.08 $ 2,006 68 $. 39,144.92 $ 24;776.75 $._ 25,138.70 $ 25,659 20 $ :26,201 37 $_: 26,76fi 21 $ 19,643 $ 38,064 35 1.73 $ 51,851.85':
ITASCA POLICE $ 223,931.02 $ 4,562 07 $ 1,665.16 $ 1,892.01 $ 36,908406 $ 23,360.94 $ 23,702421 $ 24,192.96 $ 24,704.15 $ 25,236.71 $ 19,643 $ 38,064 33 1.63 $ 48,888.89
LISLE POLICE:.. $ 314,598.81 $ 7,050.47;, $.. 2,573.43 $ 2,924.02.. $. 57,039.73 $ 36,103 27 $ 36,630.68, $ 37,389 11 $ .:38,179.14,$; 39,002 19 $ 19,643 1$ 38,064 51 2.52 $ 75,555.56
LOMBARD POLICE $ 77,855.15 $ 552.98 $ 201484 $ 229.34 $ 4,473.70 $ 2,831.63 $ 2,872.99 $ 2,932.48 $ 2,994.44 $ 3,059.00 $ 19,643 $ 38,064 4 0.20 9 5,925.93
NAPERVILLE POLICE $ 1,042,145.96 $ ;: $ $ - $. 240,461.53 $ 152,200.04 $ 1541423.47. $ 157,520.50 $ 150,951 27 $: 164,420 99 $ 12,068 : 215 10.62 $ 318,518.52.
OAK BROOK POLICE $ 349,858.50 $ 8,o18.18 $ 2,926 64 $ 3,325436 $ 64,868.72 $ 41,058 62 $ 41,658.43 $ 42,520 96 $ 43,419 41 $ 44,355 43 $ 19,643 $ 38,064 58 2.86 5 85,925.93
OAKBROOK TERRACE POLICE: $ 213,856.83 $ 4,285+58 1,564424 $ 1,777 35. $ 34,671.21 $ 21,945.12 $ 22,265.71....$ 22,726.72 $ 23,206.93 $ 21 $ :. 19,643 $ 38,064. 31,. 1.53 $ 45,925;93
ROSELLE POLICE $ 279,339.11 $ 6,082.76 $ 2,220.21 $ 2,522.69 $ 49,210.75 $ 31,147.92 $ 31,602.94 $ 32,257.28 $ 32,938.87 $ 33,648.95 $ 19,643 $ 38,064 44 2.17 $ 65,185.19
VILLA PARK POLICE $ 349,858.50 $ 8,018.18.. S 2,926.64 $ 3,325.36 64,868.72 $ 41,058 62 $ 41,658.43. $ 42,520.96 S 43,419 41 $', 44,355 43 $ _.19,643 $ ,... 36,064 58 2.86 $ 85,925.93:.
WARRENVILLE POLICE $ 244079.42 $ 5,115.04 $ 1,667.00 $ 2,12135 $ 41,381.77 $ 26,192.56 $ 26,575,20 $ 27,125.44 $ 27,698.59 $ 28,295.71 $ 19,643 $ 38,064 .37 1.83 $ 54,814.81
WEST CHICAGO:POLICE ;$. 334,506,50 $ 8,018.18. S 2,926.64 $ 9,325.36:..$ 64,868,72 $ .41,058.62 $ 41,658.43, $ 42,520.96 $ 43,419.41 $ 44,355.43 $ „4,291 $ 38,064. 58 2.86 $,.: $5,925.99
WESTMONT POLICE $ 313,640.14 $ - $ - $ - $ 61,513.44 $ 38,934.89 $ 39,503.68 $ 40,321.60 $ 41,173.58 $ 42,061.18 $ 12,068 $ 38,064 55 2.72 $ 81,481.48
WHEATON POLICE $: 521,119.66 $ : 12,718.49 $ 4,64226 $... 5,27471 $ 102,89521 $ 65,127.46 $ 66,07888; $ 67,44704 $ 68,87217 $,.. 70,35689 $ 19,643 $ 38,0641 ;92 1 4,54 $ 136;296.30
WILLOWBROOK POLICE $ 184,281.48 $ - $ $ - $ 31,315.93 $ 19,62140 $ 20,110.96 $ 20,527.36 $ 20,961.10 $ 21,412.97 $ 12,068 $ 38,064 28 1.38 $ 41,481.48
WINFIELD POLICE $ . 145,836.64 $ 2,626,64 $ 958.73 $ 1,089 34 $ 21,250.10 $ 13z4S0.24 $. 13,646 73.'.$ 13,929 28 $ 14,223.60. $ 14,530,23 $ 12,068 $ 38,064 19. 0.94 $ 28,148,15
WOOD DALE POLICE $ 304,524.61 $ 6,773.98 $ 2,472.51 $ 2,809.35 $ 54,802.88 $ 34,687.45 1 35,194.19 $ 35,922.88 $ 36,681.92 $ 37,472.69 $ 19,643 $ 38,064 49 2.42 $ 72,592.59
WOODRIDGE.POLICE $ 375,043.99 $ 8,709.40:.. $ .3,178.94 $ 3,612403 $. 70,460.85 $ 4459915 $ ,. 45,249467_ $ 46,18656 $ 47,16247 $3, 48,17917 $ 19,643 is 38,064 63 311 S 93,33333?.
Total $ 12,135,083416 $ 216,288.00 $ 79,675.28 $ 90,530400 $ 2,264,813.00 5 1,433,512.00 $ 1,454,453.64 $ 1,484,567.98 $ 1,515,936.42 1$ 1,548,616432 $ 901,977.52 $ 1,142,713.00 2025 100.00
Total Equipment
Agency Specific Replacement
FIRE AGENCY Total Interfaces Fiber Network Cost #Users %Total Contribution
ADDISON FPO:.. >..$ 117;08000 $ 2,88800 $ 114,19200
BARTLETT FPD $ 117,080.00 $ 2,888.00 $ 114,192.00
BLOOMINGDALE FPD $ 117,080 00 $ 2,888 00 $ 114,192 00
BENSENVILLE FPD $ 76,128.00 $ - $ 76,128.00
CAROLSTREAM FPD $ 117,080.00 $ 2,888 00 $
CLARENDON HILLS FPD $ 40,952.00 $ 2,888.00 $ 38,064.00
DARIEWWOOD.RIDGE FPD $ ....40,95200 $ ..2,88800 $
DOWNERS GROVE FD $ 155,144.00 $ 2,888.00 $ 152,256.00
ELMHURST FD : $ ;79,01600 $ 2,88800 $
GLENN ELLYN VFC $ 79,016.00 $ 2,888.00 $ 76,128.00
GLENSIDE FPD $ 40,952.00 $.. 2,88800. $ 38,064.00
HANOVER PARK FD $ 79,016.00 $ 2,888.00 $ 76,128.00
HINSDALE FD $ 40,95200 $ 2,888.00 $
ITASCA FPD $ 40,952.00 $ 2,888.00 $ 38,064.00
LISLEWOODRDIGE FPD $ 193,20800 $ .2,88800 $ 190,32000
LOMBARD FD $ 79,016,00 $ 2,888.00 $ 76,128.00
NAPERVILLE FD $ 2,88800 $ 2,88800
OAK BROOK FD $ 79,016.00 $ 2,888.00 $ 76,128.00
OAK13ROOK TERRACE FPD $ 38,064.00 $ $ 38,064.00
PLEASANTVIEW FPD $ 79,01600 $ 2,888.00 $ 76,128.00
ROSELLE FD $ 40,952 00 $ 2,888 00 $ 38,064.00
TRI-STALE FPD $ 79,016.00 $ 2,888.00 $ 76,128.00
VILLA PARK FD. 2,888.00 $.:, 76,128.00
WARRENVILLE FPD $ 79,016.00 $ 2,888.00 $ 76,128.00
WEST CHICAGO FD $ 155;14400 $ 2,88800. $.:. 152,256.00
WESTMONT FD $ 79,016.00 $ 2,888.00 $ 76,128.00
WHEATON FD $ 117,08000 $ .2,888.00 $ 114,192.00
WINFIELD FPD $ 76,128.00 $ - $ 76,128.00
WOODDALE FPD,. $ ..:79,016.00 $ 2,888.00 $ 76,128.00
YORK CENTER FPD I$ 40,952.00 $ 2,888.00 $ 38,064.00
Total Equipment
New RMS Agency Specific Replacement
FIRE AGENCY Total FY16 NetRMS FY17 NetRMS FY18 NetRMS New RMS Capital Yrl Yr 2 Yr3 Yr4 Yr5 Interfaces Fiber Network Cost #Users %Total Contribution
ACDC $ - $ -
DOWNERS GROVE PSAP $ 37,819.00 $ 37,819
DUCOMM $ 37,819.00 $ .37,819
DSO PSAP $
NAPERVILLE PSAP $ 362,760.00 $ ..362,760
$
ETSR $
4 p`
� - 3
DuPage Digital Justice Information System
RMS Staffing Overview
This document describes the recommended staffing for RMS based on Intergraph recommendations and DuPage
County Human Resource job descriptions and salary matrix.
It is anticipated that these positions will be hired near the mid-range of the matrix. This could be adjusted up if the
candidate has substantial experience in the Intergraph product.
Salary Salary Range
Position Grade Low Mid High
RMS Manager 315 $71,821 $95,760 $119,700
Data Base Administrator 314 $62,305 $83,075 $103,843
Report Writing Specialists 2 312 $48,137 $64,184 $80,228
The dollars included in the A enc Estimated Costs is:
Salary Salary Range
Position Grade Salary Benefit (40%) Total
RMS Manager 315 $100,000 $40,000 $140,000
Data Base Administrator 314 $80,000 $32,000 $112,000
Report Writing Specialists 2 312 $60,000 $24,000 $84,000
The salary calculations included in the Agency Cost Estimate include forty percent (40%) for benefits. In addition
a two percent (2%) COLA has been added to each year of the program. Although not guaranteed, this COLA is
consistent with DuPage County past practice and is only included to allow you budget appropriately.
It is important to remember that these are estimates based on known practices and information. It is possible that
these costs could be lower.
RMS Manager:
The employee in this class is responsible for implementing, planning, managing and directing the DuPage County
Justice Information System Law Enforcement Records Management System ("Records Management System")
Employee manages the appropriate relationships, budget, projects and staffs within the department. Work
requires the ability to exercise a high degree of technical expertise and competency in order to effectively
research, recommends and implement a records management system that successfully meets the needs of all
Elected Officials, Municipal Governments, County Departments, and Quasi-Governmental Organizations.
Administrative direction is received from the Chief Information Officer. Management direction is provided to
subordinate manager/supervisors.
As project manager for this system, this position will be responsible for overseeing all on-site project related
activities and for assisting the Intergraph Project Manager in developing and managing implementation schedules
and coordinating activities and personnel.
Data Base Manager:
The use of the system administration tools within the applications is included in training. However, this position
should be filled by resources fully trained in database management and system maintenance. This position
reports to the RMS Manager.
Report Writing Specialists:
Ability and background to create custom reports based on defined content provided by administrative and
supervisory personnel. Report Writing Specialists should be familiar with the database structure. Knowledge of
SQL would be a definite advantage. This position reports to the RMS Manager.
s
DuPage Digital Justice Information System
Additional Cost Worksheet
As stated in the cover letter, DuPage ETSB will be providing the CAD system including the mobile
software/interface and the initial funding (with a reimbursement schedule) for RMS and interfaces
("Friends of CAD") not specific to the delivery of 911 services. The following additional costs have also
been identified:
CPU/Mobile Hardware:
In order to operate properly with the new CAD system. Hardware that does not meet the specifications
below will not be allowed on the system. Hardware should have the following specifications:
Mobile Computers: WebRMS Workstations (desk tops) or CPUs:
Windows 7 Pro, 64 bit 13 or greater processor Windows 7 Pro, 64 bit
4GB RAM
80 GB HD
1,024x768 resolution
Centronics port for printing (if appropriate)
Network connection (if to be docked on the network)
Touch Screen Preferred.
DuPage ETSB will do an RFP for hardware to facilitate a purchasing contract for equipment. Each
agency will be responsible to fund any replacement hardware for mobile or desk top computers. The
goal would be to receive all of the equipment so that tech personnel can load and configure the
hardware properly prior to deployment/implementation. The letter of intent will have a handout that
asks for the number of devices you would be replacing in order to provide a range for the RFP. This
RFP will be let as soon as data is collected.
Network:
The Technology Team for this project is working on a RFP to replace the SONET. CAD and Friends of
CAD as well as Customer Premise Equipment (CPE-the 911 call handling devices) will run on this
network. DuPage ETSB will pay for the connections between the PSAPs (with the exception of
Naperville). Connectivity in the network for RMS and any other interfaced systems will be the
responsibility of user agency. The RFP was let and returned May 31, 2016. The RFP will ask for
several connectivity options. User agencies will have the opportunity to select their preferred network
connection. This information is provided to user participants to assist with overall costs. It is an option
and participant users may do their own connection but it will have to be approved by ETSB before it can
connect into the system or a PSAP. This approval is only to ensure network system capacity and
stability.
Wireless Network for Mobile Terminals:
DuPage ETSB will continue to fund the cost of the wireless interface. This RFP will be for air cards (or
wireless activation assuming mobiles have internal wireless capability). While user agencies may
currently have their own contracts for this service, the hope is that a county-wide contract may reduce
the cost to the user agencies.
Fire Station Alerting:
DuPage ETSB is working with the Fire work group and will let an RFP to determine the feasibility of an
updated, interoperable fire station alerting system.
A
4.s-rte � � AYE � � �; ..., -- °-- _•-:. �-� �.i i ,y �
DuPage Digital Justice Information System
Address Point File Workflow Description
The new CAD system will be XN coordinate driven. For this reason the GIS map will be a critical piece of the
core data base. This document will describe the workflow steps for updating the countywide address point file
that will be used by E911 and other taxing organizations within DuPage County.
Municipal and County Input:
To create the new GIS map, agency participants that have address point data in either ESRI Geodatabase or
ESRI shapefile should submit these files via etsb911(cDducomm.org. This would also be the time to update
any boundaries, police beats/zones, fire beats/zones. If you do not have this data, please submit a Trakit
ticket, indicating this so that the GIS team can work with you to ensure your information is ready for the new
system.
Once the system is implemented, each agency participant will be submitting their address point file updates
through a web based GIS application. The users will be able to add their address updates through a map
interface. Update and edit tools will be provided within the application. A workflow map is provided.
Address Update &Approval to E911:
Once the updated address points are complete an email and or other form of notification will be sent to ETSB
GIS staff. At this step, the tentative point address will be reviewed and cross referenced by the MSAG data. If
the address does not meet the standard needed for E911, the ETSB GIS staff will work with the respective
municipality,to correct and workout any issues that have arisen in the data review.
If the address does not meet the business rules established by the Tech Committee based on software
capability, a respective municipal entity or the County may be asked to make a requested correction due to a
discrepancy in the addressing. It is important that participants work with the GIS Team prior to annexations to
avoid unnecessary delays in the annexation process or 911 mapping entry for an address within our service
area.
When an address or corrected address is complete, another review will take place by ETSB GIS staff. Once
the address is reviewed, approved and posted, this address point data will be uploaded to the Intergraph CAD
system and also be available to others for their various address mapping needs.
Various Types of Data:
There is a county-wide address point file. We have completed all the unincorporated areas within DuPage
County and we are currently obtaining address point data from all of the County's incorporated municipal
governments. To date, 16 out of the 32 municipal entities address data here in DuPage County and are
currently appending them to the county wide address point file. Once we have the county address point file
appended and completed with all of the address data, we will be able to share this data back to those entities
that did not have a GIS format.
Recommendation:
One of the greatest challenges to any GIS map and CAD software is the alpha numeric address (i.e.
21W241). Going forward we would recommend that participants adopt ordinances to eliminate this type of
addressing.
{
X31�
i
�t
r ARE
DuPage Digital Justice Information System
Agency Cost Explanation
Every effort has been made to identify costs to the agency participants for this project. Please review
the tab worksheets carefully to ensure we have captured all of your costs accurately.
The excel spreadsheet is set up in the following manner:
Agency Cost Summary
This worksheet lists all of the participating agencies and the costs as a summary. The first column is
the estimated total for the project. Category costs are detailed in the subsequent worksheets of the
workbook. There is a break per agency of the capital equipment replacement contribution. Law
Enforcement is listed first, then fire and finally PSAP.
Network
There were two bidders for this project. The bids still have to be vetted, the highest submitted numbers
have been used for this worksheet so it is a worst case scenario. Final numbers will provided as soon
as a contract has been selected. It is important to keep in mind that ETSB has bid connections, but you
do not have to participate in this contract. If you select a different path, it will require ETSB approval to
ensure network system capacity and stability.
Agency Specific Interfaces
This section requires a thorough review by each participant. The system allows for one connection
(typically the highest number of users). It will be approximately 24 months from date of contract before
these interfaces are seamless to the overall core system. This gives participants an opportunity to
decide if they would like to utilize the one provided system/interface or continue to pay their own way.
Budget Detail for NetRMS
An explanation of how costs are determined.
NetRMS FY16 Costs
Break outs of costs for this fiscal year. This is a typical set up. Keep in mind that personnel is limited
so costs are atypically low.
NetRMS FY17 Costs
Break outs of costs for this fiscal year. This is a typical set up. Personnel costs for this year have been
transferred to the New RMS Estimate Capital.
NetRMS FY18 Costs
Break outs of costs for this fiscal year. This is a typical set up. Personnel costs for this year have been
transferred to the New RMS Estimate Capital. This year will be necessary due to the length of the
project.
New RMS Estimate Capital
Capital costs and personnel for FY 17 and FY 18.
New RMS Estimate Operational (5 work sheets yrs 1-5)
Estimated costs for personnel/benefits, maintenance equipment replacement contribution.