Legislation Details

File #: HIST-6767    Version: 1 Subject:
Type: Historical Status: Action Item
In control: City Council Meeting Agenda
On agenda: 11/14/2007 Final action: 11/14/2007
Title: Approval of a Contract with New World Systems to Provide Software (Computer Aided Dispatch, Fire/Police Records Management, Fire Emergency Medical Services and Mobile Technology) and Implementation Services to Support and Enhance Public Safety Operations; and Approval of a Budget Amendment to Provide Funding for this Project.
Attachments: 1. Approval of a Contract with New World Systems to P - A-2__07-11-14_FirePDIT_Public Safety Software Replacement - FINAL.doc, 2. Approval of a Contract with New World Systems to P - A-2__07_11_14-FirePDIT-Software Replacement Attachments.pdf
City of Culver City, California City Council Agenda Item Report RECOMMENDATION: Staff recommends the City Council: 1. Approve a contract with New World Systems (Troy, Michigan) to obtain Public Safety Software (Computer Aided Dispatch, Fire/Police Records Management, Fire Emergency Medical Services and Mobile Technology) and implementation services to support and enhance Public Safety Operations. 2. Approve a budget amendment to provide funding for this project. (This budget amendment requires a 4/5 th vote of the City Council.) BACKGROUND: In October 1998, City Council approved the purchase of public safety software from either Synergetic Systems or VisionAir Inc (attachment 1). The vendor selection was constrained for budget reasons to the amount of available funding ($410,000) from the Asset Seizure Forfeiture Fund. Shortly after City Council’s approval, staff’s first choice vendor (Synergetic Systems) went out of business. Staff proceeded to Meeting Date: 11/14/07 Item Number: A-2 AGENDA ITEM: Approval of a Contract with New World Systems to Provide Software (Computer Aided Dispatch, Fire/Police Records Management, Fire Emergency Medical Services and Mobile Technology) and Implementation Services to Support and Enhance Public Safety Operations; and Approval of a Budget Amendment to Provide Funding for this Project. Contact Person/Dept.: Captain Tom Murphy (Fire) Officer Marc Young (Police) Michele Williams (IT) Phone Number: 310.253.6840 310.253.6256 310.253.5959 Fiscal Impact: Yes [X] No [] General Fund: Yes [X] No [] Public Hearing: [ ] Action Item: [X] Attachments: [X] Public Notification: E-mail Master Notification List on 11/07/07, New World Systems on 11/01/07 Department Approval: Jeff Eastman 11/01/07 Don Pedersen 11/01/07 John Richo 11/01/07 City Attorney Approval: Carol Schwab (by H. Iker) (11/06/07) Fiscal Impact Review: Marlee Chang (by M. Noller) (11/08/07) City Manager Approval: Jerry B. Fulwood (11/08/07) City of Culver City, California City Council Agenda Item Report contract with and install software from VisionAir. The application included computer aided dispatch (CAD) for Fire and Police and a Police records management system (RMS). While staff have made the system work, the VisionAir software (mainly the reporting module) has numerous technical issues which have not been resolved. The system is built on older technology and as a result, is unstable and prone to introducing program errors when hardware or software is updated. The system also does not provide much flexibility for customization. As a result, staff must perform many manual tasks to ensure compliance with reporting standards such as Uniform Crime Reporting (UCR). The Fire Department uses software from another vendor (LANCET) for their records management however, there is no integration between the Fire CAD calls and Fire RMS which results in duplicate data-entry. Additional quality control efforts have also been introduced to ensure that data between the systems remains in-sync and consistent across the various softwares. Additionally, the lack of an integrated public safety system has impacted the Fire and Police Departments’ ability to efficiently implement technology which would enhance operations such as mobile computing. Approximately two years ago, IT began working with Police to develop a Police RMS which would interface with the CAD system. After a year of in-house development, the project was abandoned due to a lack of IT programming resources. DISCUSSION: In July 2007, a project team was established which included staff from Fire, Police and Information Technology Departments to determine a course of action. The team evaluated options for replacing the City’s public safety software components. Three options were identified:  Resume developing a solution in-house using IT programming staff  Upgrade the current system (retain current vendor)  Select another vendor to replace the existing software Resuming in-house development was quickly eliminated as an option due to the fact that the necessary IT resources would not be available in the foreseeable future. It should also be noted that a completely integrated solution would be an extraordinary lengthy and complex project requiring additional IT resources. Vendor Assessments City of Culver City, California City Council Agenda Item Report The project team established a plan to identify a vendor that supplied an integrated public safety solution which would meet the City’s requirements. Five vendors were identified: VisionAir (current software vendor), Intergraph, New World Systems, Spillman Technologies, and Versaterm. These vendors were invited to provide staff with a half-day presentation of their respective software solution. One vendor, Versaterm, declined to provide a presentation. Staff from various operational areas of Fire and Police attended the demonstrations. Each vendor was evaluated by staff in the following areas:  Software User Interface (appeared intuitive and user friendly)  Ability to meet City’s operational public safety requirements  Ability to comply with regulatory reporting requirements  Flexibility for interfacing with third-party software  Quality of presentation  Responsiveness to staff questions Staff’s re-examination of VisionAir determined that while the vendor had made significant improvements in their product it was not in the City’s best interest to continue this relationship for the following reasons:  VisionAir’s Fire EMS product did not meet the City’s requirements  Vendor does not offer various ancillary components such as a police property module, fire hazardous materials tracking, and false alarm billing  Ongoing concerns regarding the vendor’s commitment to California public safety installations (The vendor has not sold their product to a California site in over eight years).  Ongoing concerns related to limited customer support The results of the evaluation (attachment 2) revealed that New World Systems offered the most suitable solution. Staff began taking a closer look at the software solution offered by New World Systems. Numerous meetings were held to examine the software and to determine if the solution met the City’s requirements. New World Systems also held an advantage over the other vendors with their strong California public safety presence. They have a total of 22 installations and four regional offices in California. Below is a list of their Southern California installations:  Downey  Whittier  Montebello  Monterey Park  Bell Gardens  Viejas Tribal Security Additionally, the City of Berkeley recently awarded a contract to New World Systems to support their public safety operations (attachment 3). City of Culver City, California City Council Agenda Item Report The City of Berkeley released a RFP for an integrated public safety solution with operational requirements very similar to Culver City. That competitive bid resulted in four responses from the following vendors:  Intergraph  Motorola  New World Systems  Tiburon (Compudyne Systems) The contract for services was awarded to New World Systems in September 2007. Berkeley’s selection criteria were based on RFP responses, on-site demonstrations, vendor references, and site visits. In all areas New World Systems far exceeded the other vendors. Staff obtained references from agencies using New World and all of the responses have been very positive. A site visit to Bell Gardens was conducted to obtain their experience with the New World Product. Bell Gardens has been using New World Systems’ software for over four years. They are very pleased with the product and find the most useful module is field reporting using the mobile technology. Staff from Fire and IT also participated in a site visit to Troy, Michigan to assess New World’s corporate facilities. Additionally, a user site visit was made to the City of Flint, Michigan to view their installation of CAD, RMS and Mobile. Police staff were scheduled to attend this site visit but due to personal impacts from the recent California Fires, had to cancel. Again, the references and reports from this visit were very positive. Sole Source Contract Award Staff’s research has revealed that there are very few vendors who offer a fully integrated public safety solution. Staff has performed due diligence to identify a vendor that offers a solution that will meet the City’s needs. It has been determined that New World Systems is the only vendor that provides a solution which meets the operating requirements of the Police and Fire Departments. Of most concern was EMS for the Fire Department because there are very few vendors that offer this module. Throughout the demonstrations it was noted that most vendors have a strong focus on law enforcement but have deficiencies in the area of Fire EMS reporting. Of the four vendors demonstrating their product, New World Systems was the only vendor who captured inherently in their product all but nine of the required EMS reporting fields. New World Systems also agreed to modify their Fire EMS product to accommodate these additional fields. Staff recommends that City Council approve a sole source contract award to New World Systems. to provide an integrated public safety solution that will service the City of Culver City, California City Council Agenda Item Report operational requirements of Fire and Police. The following primary modules will be supplied:  Computer Aided Dispatch (CAD)  Police Records Management  Fire Records Management and EMS  Mobile Data Software New World Systems is a privately owned corporation based in Troy, Michigan. They have been providing application software for local government and public safety agencies since 1981. The corporation is very stable and has never been acquired or merged. New World Systems employs about 300 employees with regional offices throughout the US. They are also a certified Microsoft Gold Partner and an ESRI (leading GIS software provider) partner. Mobile data terminals (MDTs) in public safety response vehicles will provide staff with quick access to critical information such as response plans and historical records. Mobile data also facilitates field data queries which provide alerts and supplemental information that can be invaluable while in the field. Mobile technology also expands public safety operations by offering the opportunity to complete incident reports while in the vehicle keeping officers in the field. It is estimated that the cost of the terminal and installation would be between $5,000 and $7,000 per vehicle. Fire and Police estimate a combined vehicle fleet of 58 units which would require mobile installations. Staff had hoped that a formal quote for the Mobile Data hardware component would be available for this report. However, the staff member who is taking the lead in obtaining the quote was diverted by tasks related to the recent fires. We do have an estimate of $400,000 that would cover Mobile Data Terminals for the city’s fleet of 58 public safety vehicles. We have included this amount in the budget for this project. We are requesting budget appropriation for this expenditure. Staff will return to Council for approval of the vendor contract after completing the purchasing process required by the Municipal Code. Positive Impacts and Efficiencies of New Public Safety System  The Police Department anticipates with officers writing reports in the field rather than responding to the station, there will be a decrease in overtime. The Police Department already decreased its overtime budget by $50,000 in FY 07-08 and has committed to cut the overtime budget by an additional $50,000 in FY 08-09 in anticipation of obtaining this system.  It is anticipated this system will decrease the police response time. By allowing officers to remain in the field and do most of the work on MDTs rather than inside the station, officers will be able to respond more quickly, thus reducing response time. City of Culver City, California City Council Agenda Item Report  It is also anticipated there will be a much greater amount of visibility of marked police units in the field as officers will be able to write reports and do criminal investigations from their patrol unit rather than the police station.  The CAD system in conjunction with MDTs will cut down on unnecessary "air- time" making records and warrants checks more efficient and effective.  This system will eliminate the duplication of data entry by police officers, dispatchers and records technicians. With one person inputting information all fields and reports will be populated as opposed to the current method of each section inputting identical information.  The information retrieved will be more accurate. This will allow for more accurate and timely reporting of various statistics to state and federal entities. It will also allow investigators to do more thorough and timely investigations as they will readily be able to extract information from the records management system.  This system will allow police officers to share confidential information without transmitting that information over the radio.  MDTs will allow for greater safety to the public and the officers. Officers will be able to instantly acquire information regarding wanted persons, access building plans and blueprints of buildings and instantly check the status of a vehicle or person. The public will realize greater safety with increased visibility, faster response times and with officers having the information they need to quickly assess a situation i.e.- an active shooter at a school, the officers will be able to have blue prints of the school's layout and quickly develop a tactical deployment.  The system will improve speed and accuracy in dispatching. Along with voice notification, the new CAD system will print out incident response information at a designated printer at the fire station (Rip ‘n Run), and also prominently display the information on the MDT screen in the fire engines and paramedic rescue vehicles.  Fire personnel will have improved response information for buildings/structures. The Pre-fire Plans currently carried on the apparatus is in a hard copy format. Through CAD and Fire RMS, pre-fire plans would be displayed on the MDT screen, giving accurate and high quality data on the business/building. City of Culver City, California City Council Agenda Item Report  Incident reporting through the field reporting system at the fire stations would greatly enhance the efficiency of data entry. Currently, incident data entered into LANCET has to be done manually, as there is no connection to the current CAD. This means that incident number, incident times, personnel, locations, etc. all have to be entered by the firefighter. With CAD, all of the specific incident data would be pre-populated into the appropriate fields, leaving only the details of the incident that needs to be entered (reducing incident data entry by ~50%).  The Fire department currently uses a myriad of unrelated software programs for all of its RMS needs, e.g. Lancet (incident reporting), Firehouse (training and activity records), Permits Plus (business/occupancy info., hydrant info.), Excel spread sheets (fire hose records), Word docs (apparatus inventories), and Telestaff (staffing/personnel). Implementing an integrated system would eliminate the need for the above mentioned software (with the exception of Telestaff). Generating comprehensive staff/city/department reports from our current RMS is impossible. Because the new RMS combines all of these databases into one, our ability to generate meaningful reports will be greatly increased. FISCAL ANALYSIS: The authorization to contract with New World Systems (Troy, Michigan) to obtain public safety software components would result in an expenditure of $1,187,098. Additionally staff recommends the authorization of an expenditure not to exceed $35,000 for server hardware to support fault tolerant/redundancy specifications that are required for a critical public safety system. The estimate for mobile data terminals is $400,000. The authorization to initiate this project would result in a total expenditure not to exceed $1,622,098. Description Amount New World Systems Software and Implementation (attachment 4) $1,187,098 Server Hardware to Support Fault Tolerant / Redundancy Specifications $ 35,000 Mobile Data Terminals (Hardware and Installation) $ 400,000 Total Project Expenditure $1,622,098 The need for this project was brought to the attention of the City Manager and City Council during the budget sessions. However, at that time, staff had not completed City of Culver City, California City Council Agenda Item Report enough research to provide a required funding estimate. Staff was advised to provide a report/recommendation to City Council before mid-fiscal year. Staff requests that Council approve a budget transfer from the General Fund Unappropriated Reserve to a Capital Improvement Project (to be determined 42000XXX) in the amount of $1,622,098 to provide funding for this project. This is a budget amendment and requires a 4/5 vote of City Council. Future Budget Year Impacts Software support annual maintenance fees are included in the purchase for the first year. Beginning in fiscal year 2008-09, annual maintenance fees would be $135,500. New World Systems has agreed to lock this annual maintenance fee at this price without increase for five (5) years. Additionally, the City would incur annual maintenance fees for the mobile data terminals which are estimated at $54,000 per year. Funding in the amount of $184,025 was approved in the fiscal year 2008-09 Police Department budget for the purchase of mobile data terminals. This funding could be used to off-set the maintenance fees in fiscal year 2008-09. The annual maintenance fees for the existing CAD system are $20,000. Once the new system has been implemented, these fees could be applied to the maintenance fees for the new system. It is anticipated that the system would be operational within 9-12 months. ATTACHMENTS: 1. City Council Staff Report of October 12, 1998 2. On-site Demonstration Evaluation Results 3. Press Release – City of Berkeley Selects New World Systems to Provide Public Safety Software 4. New World Systems Quote MOTION: That the City Council: 1. Authorize a budget transfer from the General Fund Unappropriated Reserve to a Capital Improvement Project (to be determined - 42000XXX) in the amount of City of Culver City, California City Council Agenda Item Report $1,622,098 to provide funding the public safety software replacement project (This budget amendment requires a 4/5 vote of the City Council.); 2. Approve the sole source contract with New World Systems to provide an integrated public safety software for an expenditure not to exceed $1,187,098; 3. Authorize the City Attorney to review/prepare the appropriate documents and the City Manager to execute such documents on behalf of the City. MEETING DATE: 11/14/07 AGENDA ITEM: Authorization to Contract with New World Systems to Provide Software (Computer Aided Dispatch, Fire/Police Records Management, Fire Emergency Medical Services and Mobile Technology) and Implementation Services to Support and Enhance Public Safety Operations. ATTACHMENTS Pages 1. City Council Staff Report of October 12, 1998 1-4 2. On-site Demonstration Vendor Evaluation Results 5 3. Press Release – City of Berkeley Selects New World Systems To Provide Public Safety Software 6-7 4. New World Systems Quotation to Culver City 8-17 Page 1 of 17Page 2 of 17Page 3 of 17Page 4 of 17Public Safety Software Replacement Project Vendor Software Evaluation Intergraph New World Spillman Vision Overall quality of presentation 3.3 5.0 4.7 3.0 Responsive to staff questions and ability to adequately answer questions 4.7 5.0 4.8 3.3 Software User Interface - (Appeared to be intuitive and user friendly) 3.0 4.7 4.3 3.3 Demonstrated ability to meet overall operational requirements for the department's operations (Fire or Police) 3.3 4.3 4.2 3.3 Demonstrated ability to comply with regulartory reporting requirements (e.g. UCR, NFIRS / LA County EMS) 4.5 5.0 4.2 3.3 Demostrated flexibility for interfacing with third-party software 4.0 5.0 3.3 2.7 Evaluation of how well you believe the product will meet Culver City's Public Safety Requirments 4.0 5.0 4.2 3.0 Total Average Score 3.8 4.9 4.2 3.1 October 4, 2007 Page 5 of 17Page 6 of 17Page 7 of 17New World Software and Services A. Application Software $627,066 1) CAD 158,000 2) Law Enforcement Records 189,700 3) Fire Records 109,500 4) Additional Software Modules 100,500 5) Mobile Management Software 357,016 6) Aegis Justice Link 15,000 7) Hand Held Mobile 35,000 8) Demonstration Site Discount (337,651) B. Support Services 234,400 1) Project Management 2) Installation and Training 3) Hardware Assurance 4) Interface Installation Fees 5) GEO File Implementation 6) Data Conversion Analysis & Assessment C. Third Party Costs 106,882 1) GIS Software (ESRI) 40,700 3) Hardware, System Software & Services (estimate) 47,400 4) Diagramming Software 7,532 5) AVL Hardware 8,700 6) Rip-N-Run Printers 2,550 D. Other Costs 218,750 1) Data File Conversion (estimate) 63,750 2) Custom Software 60,400 3) Application Software Modifications (estimate) 19,600 4) Travel and Living Expenses (estimate) 75,000 TOTAL ONE TIME COST $1,187,098 Maintenance E. 1) Standard Software Maintenance Agreement (SSMA) (Annual Cost) Includes Emergency 24/7 Maintenance for CAD only Warranty Period 365 days Year 1 Cost: $135,500 Year 2 Cost: $135,500 Year 3 Cost: $135,500 Year 4 Cost: $135,500 Year 5 Cost: $135,500 Total Cost Summary - Budgetary Culver City Police/Fire Departments, CA October 16, 2007 This assumes you are purchasing this directly through New World and not thru an RFP procurement procedure. NOTE: New World's cost is based on all of the proposed products and services being obtained from New World. Should significant portions of the products or services be deleted, New World reserves the right to adjust its prices accordingly. CONFIDENTIAL AND PROPRIETARY Page 8 of 17A. STANDARD APPLICATION SOFTWARE 1,2,3,4 INVESTMENT CAD (Users included in CAD Base - 8) 1. Aegis/MSP Combined Multi-Jurisdiction LE/Fire/EMS CAD $101,000 - Call Entry - Call Control Panel - Unit Recommendations - Unit Status and Control Panel - Call Stacking - CAD Messaging - Call Scheduling - Dispatch Questionnaire - Geo-File Verification - Hazard and Location Alerts - Hydrant Inventory - Access to Aegis/MSP LE Records - Access to Aegis/MSP Fire Records - Note Pads - Rip-N-Run Remote Printing - Run Cards - Tone Alerts 2. Additional Aegis/MSP Software for Computer Aided Dispatch|1010| - CAD Mapping 10,000 - CAD Auto Routing 9,000 3. Aegis/MSP Third Party CAD Interface Software|1010| - CAD Pager Interface 10,000 - E-911 Interface|1010|10,000 - Priority Dispatch ProQA for EMD Interface 10,000 4. Cost for Additional CAD Users - 8 view/inquiry users at $1,000 per user 8,000 CULVER CITY POLICE/FIRE DEPARTMENT, CA Budgetary Proposal Summary October 16, 2007 ITEM DESCRIPTION Culver City CA Pricing V7 wo.xls ______________________________ Culver City, CA Proposal Summary NEW WORLD SYSTEMS' Aegis PUBLIC SAFETY SOFTWARE CONFIDENTIAL AND PROPRIETARY Page 2 Page 9 of 17LAW ENFORCEMENT RECORDS (Users included in LE Records Base - 35) 5. Aegis/MSP Single Jurisdiction Base Law Enforcement Records 73,700 - Accidents - Arrest - Business Registry - Case Processing - Computer Aided Investigations - Federal Reports (UCR/IBR) - Geo-File Verification - Impounded Vehicles - Incident Tracking - Jacket Processing - Personnel/Education - Property - Traffic Tickets and Citations - Wants and Warrants 6. Aegis/MSP Federal and State Compliance Reporting for LE Records 18,000 - Federal UCR/IBR 7. Additional Aegis/MSP Software for Law Enforcement Records - Alarm Tracking and Billing 9,000 - Bookings 13,500 - Case Management 9,000 - Field Investigations 9,000 - Property Room Bar Coding 9,000 - Activity Reporting and Scheduling 9,000 - Equipment Tracking 13,500 - Narcotics Management 13,500 8. Aegis/MSP Third Party LE Records Interface Software|1010| - Livescan Interface (Identix) 10,000 9. Cost for Additional Law Enforcement Records Users - 5 view/inquiry users at $500 per user 2,500 FIRE RECORDS (Users included in Fire Records Base - 12) 10. Aegis/MSP Fire Records Software Base Package 47,000 - Activity Reporting and Scheduling - Investigations - Business Registry - Hazardous Materials - Geo-File Verification - Hydrant Inventory and Inspections - Incident Tracking - Inspection Tracking - Personnel/Education - Pre-plans - Station Activity Log - BLS/ALS 11. Federal and State Compliance Reporting for Fire Records 20,000 - State/NFIRS 5.0 Electronic Reporting Culver City CA Pricing V7 wo.xls ______________________________ Culver City, CA Proposal Summary NEW WORLD SYSTEMS' Aegis PUBLIC SAFETY SOFTWARE CONFIDENTIAL AND PROPRIETARY Page 3 Page 10 of 1712. Additional Aegis/MSP Software for Fire Records 13,500 - Fire Permits 13,500 - Vehicle Tracking and Maintenance 13,500 13. Cost for Additional Fire Records Users - 4 view/inquiry users at $500 per user 2,000 ADDITIONAL PUBLIC SAFETY SOFTWARE 14. Aegis/MSP Public Safety State/NCIC Interface Software|1010| - Aegis/MSP State/NCIC Interface 14,500 Includes 12 - 15 screens On-Line Modules - Includes 4 state inquiry screens - On-Line CAD Interface to State/NCIC 10,000 - On-Line Global Subjects Interface to State/NCIC 10,000 15. Aegis/MSP Data Analysis/Crime Mapping/Management Reporting - Base with Three Applications (CAD, LE RMS, Fire RMS) 41,000 16. Aegis/MSP Imaging Software - Public Safety Line Ups/Mug Shots 8 25,000 - Digital Imaging |10 10|MOBILE SOFTWARE MOBILE SOFTWARE ON THE RS/6000 10 17. 60,000 18. - New World CAD Interface for Aegis MSP (51-100 units) 15,000 - Mobile Upload Software (51-100 units) 11 39,000 - AVL Interface (51-100 units) 12 15,000 MOBILE SOFTWARE ON THE MSP Server 19. Aegis® Mobile Integration Software - MDT/MCT Base CAD/RMS Interface (51-100 units) 12,000 - AVL CAD Interface (51-100 units) 12 15,000 MOBILE MANAGEMENT SERVER 20. N/C - Field Reporting 15,000 - Field Reporting Data Merge 4,000 Aegis/MSP Mobile Management Server Software (51-100 users) - Base CAD/NCIC/Messaging - Equipment Tracking and Maintenance Additional Aegis® Software for RS/6000 Message Switch Base Message Switch to State/NCIC (51-100 units) - Base Message Switch for MDT/MCT - State/NCIC Interface Culver City CA Pricing V7 wo.xls ______________________________ Culver City, CA Proposal Summary NEW WORLD SYSTEMS' Aegis PUBLIC SAFETY SOFTWARE CONFIDENTIAL AND PROPRIETARY Page 4 Page 11 of 17CLIENT SOFTWARE 21. Aegis ® Law Enforcement Mobile Unit Software LE State/NCIC via Switch (35 units) |1010|$550 ea. $19,250 LE CAD via Switch (35 units) $850 ea. 29,750 LE Field Reporting (Federal Standards) (35 units) $1,100 ea. 38,500 The following 4 New World Reports are included: - Incident (1 form) - Case (1 form) - Arrest (1 form) - Supplement (1 form) LE Field Reporting Compliance (35 units) $225 ea. 7,875 LE Accident Field Reporting (28 units) $1,100 ea. 5,500 The following New World Report is included: - Accident (1 form) LE Accident Field Reporting Compliance (28 units) $350 ea. 1,750 Mobile Upload of Field Reports (28 units) $675 ea. 18,900 Mugshot Image Download (28 units) $225 ea. 6,300 Drivers License Mag Strip Reader Interface (28 units) 13 $225 ea. 6,300 In-Car Mapping (58 units) $450 ea. 26,100 In-Car Routing (58 units) $350 ea. 20,300 New World AVL (58 units) $350 ea. 20,300 22. Aegis ® Fire Mobile Unit Software (23 Units) Fire CAD via Switch $850 ea. 19,550 Fire Field Reporting (NFIRS Standards)** $550 ea. 12,650 Includes NFIRS Incident (1 form) IN-STATION CLIENT SOFTWARE 23. Aegis ® Law Enforcement In-Station Unit Software LE Field Reporting (Federal Standards) (30 units) $1,100 ea. 33,000 The following 4 New World Reports are included: - Incident (1 form) - Case (1 form) - Arrest (1 form) - Supplement (1 form) LE Field Reporting Compliance (30 units) $225 ea. 6,750 LE Accident Field Reporting (5 units) $1,100 ea. 5,500 The following New World Report is included: - Accident (1 form) LE Accident Field Reporting Compliance (5 units) $350 ea. 1,750 AEGIS JUSTICE LINK (AJL) OPTIONS 15,16 1. 15,000 Aegis Justice Link Interface Server at a New World Site (MSP) - One AJL Interface Server can support multiple GJXML interfaces, except for Consolidated Searches. Culver City CA Pricing V7 wo.xls ______________________________ Culver City, CA Proposal Summary NEW WORLD SYSTEMS' Aegis PUBLIC SAFETY SOFTWARE CONFIDENTIAL AND PROPRIETARY Page 5 Page 12 of 17HANDHELD MOBILE 14,15,16 24. 13,000 - State/NCIC - NWS RMS - Names Inquiry - NWS RMS - Property Inquiry (Release 2) - NWS RMS - Vehicle Inquiry (Release 2) 25. MSP Database Server Software Database Server Manager 9,000 26. Client (Handheld Unit) Licenses (10 Units) - State/NCIC Inquiries and NWS RMS Inquiries $450 ea. 4,500 - CAD/Messaging Integration $675 ea. 6,750 - Photo Download $175 ea. 1,750 ** Denotes software to be released 12 months+ TOTAL SOFTWARE LICENSE FEE 17,18 $627,066 Network Server Software Base* - have existing NWS Mobile Culver City CA Pricing V7 wo.xls ______________________________ Culver City, CA Proposal Summary NEW WORLD SYSTEMS' Aegis PUBLIC SAFETY SOFTWARE CONFIDENTIAL AND PROPRIETARY Page 6 Page 13 of 17B. INVESTMENT 1. $65,000 2. 134,400 3. 5,000 4. Interface Installation Service Fees: In-Field Support (includes set-up and training): 18,000 - 911 Interface 3,000 - CAD Pager Interface 4,000 - ProQA for EMD Interface 5,000 - Visionics (DBI)/Identix/Comnetix 3,000 - State/NCIC 5,000 - New World Mug Shots/Imaging 3,000 5. GEO File Implementation 20 - New World Implementation Services 7,000 6. Data Conversion Analysis and Assessment 5,000 TOTAL SUPPORT SERVICES $234,400 ITEM Windows 2003/Operating System Assurance and Software Installation: - Install and set-up Application/Database server(s) - Consult on connectivity to new or existing 2003 environment - Verify 2003 and SQL Server configuration compatibility - Verify 2000/XP Workstation and personal computer configuration compatibility 960 hours of Implementation and Training Services to include, as required: - Software Tailoring and Set Up - User Education and Training - Other Technical Support SUPPORT SERVICES 19 Project Management Services as Required: - Project Management - Overall consultation and communication - Monthly status reports and project updates throughout the duration of the project - Implementation Plan DESCRIPTION Culver City CA Pricing V7 wo.xls ______________________________ Culver City, CA Proposal Summary NEW WORLD SYSTEMS' Aegis PUBLIC SAFETY SOFTWARE CONFIDENTIAL AND PROPRIETARY Page 7 Page 14 of 17C. THIRD PARTY COSTS INVESTMENT 1. ESRI 21,22,23 $40,700 GIS Software $25,000 - Mobile In-Car Mapping (58 units) 100 ea. 5,800 - Mobile In-Car Routing (58 units) 150 ea. 8,700 GEO-File Maintenance Software 1,200 THIRD PARTY HARDWARE 2. Hardware, System Software & Services (see attached pricing detail) 47,400 Application/Database/Test/Training Servers 26,650 Message Switch 12,550 Mobile Management Server 4,550 Bar Coding Hardware 3,650 3. Diagramming Software (Scene PD) 28 users @ $269 each 7,532 4. AVL Hardware (58 units) 8,700 USGlobalSat MR-350 External Mount GPS Receiver 5. Rip-N-Run Printer (3) Rip-N-Run Printers 2,550 TOTAL THIRD PARTY COSTS $106,882 D. INVESTMENT 1. DATA FILE CONVERSIONS Data File Conversion Pricing Estimates $40,000 Master Files: - Master Name (Jackets) 8,500 - Master Property 3,250 - Master Gun 3,250 - Master Vehicle 3,250 - Statutes 3,250 Police CAD / Records Management System: - CAD Incident / Call for Service 10,250 - Cases 13,500 - Accidents 8,000 - Tickets/Citations 8,000 - Narrative 5,400 Fire/EMS: - Incidents (Lancet's SQL database) 14,000 - Hydrants (Permits Plus database) 3,250 - Pre-plans 3,250 - Inspections 3,250 OTHER COSTS (ESTIMATES) DESCRIPTION ITEM DESCRIPTION ITEM Culver City CA Pricing V7 wo.xls ______________________________ Culver City, CA Proposal Summary NEW WORLD SYSTEMS' Aegis PUBLIC SAFETY SOFTWARE CONFIDENTIAL AND PROPRIETARY Page 8 Page 15 of 172. CUSTOM SOFTWARE/CUSTOM SOFTWARE INTERFACES 25 $60,400 a) LACRIS Interface $12,400 b) Interface to Lancet Technology Fire Records (one-way interface; CAD closed incidents) 5,000 c) Interface from New World CAD to Telestaff 15,000 d) 11,200 e) 8,400 f) 8,400 3. APPLICATION SOFTWARE MODIFICATIONS 19,600 Modification in Rip & Run to include map directions (40 hours) 5,600 Modification in Scheduling and Reporting to allow for 9-day shift rotations to include colors for shifts 11,200 Include missing 8 fields in EMS from Culver City EMS report 2,800 4. TRAVEL AND LIVING EXPENSES (Estimate) Estimated 50 trips at $1,500 per trip. 75,000 TOTAL OTHER COSTS $218,750 TOTAL ONE TIME COST $1,187,098 E. MAINTENANCE INVESTMENT 1. Warranty Period 365 days Year 1 SSMA $135,500 Year 2 SSMA $135,500 Year 3 SSMA $135,500 Year 4 SSMA $135,500 Year 5 SSMA $135,500 COMBINED STANDARD SOFTWARE MAINTENANCE AGREEMENT (SSMA) (Per Year Cost) Interface from TurboData SQL database of parking citation writer (vehicle) - assumes basic data import. Additional functionality (i.e. vehicle checks, etc.) will require additional fees Data File Conversion Estimates are based on the specified data files and the Hourly Service Rate quoted; additional hours may be needed to complete the quoted conversions. Conversion of additional data files that are not included with this proposal will require an additional estimate/quote. If required, travel and expenses are billed at actual cost. Interface to dump Alarm data to JD Edwards billing application - assumes data is passed using NIEM 2.0 (GJXDM 3.0.3) standards Interface from Berendo Solutions SQL database citation writer (jacket/vehicle) - assumes basic data import. Additional functionality (i.e. vehicle checks, etc.) will require additional fees Based on a 5-year plan; SSMA to begin at the end of the warranty period. Includes 24/7 Support for CAD. (Includes Exhibit A ESRI Integration for the ESRI software that is part of Exhibit A Licensed Standard Software.) PRICING VALID THROUGH DECEMBER 31, 2007. ITEM DESCRIPTION Culver City CA Pricing V7 wo.xls ______________________________ Culver City, CA Proposal Summary NEW WORLD SYSTEMS' Aegis PUBLIC SAFETY SOFTWARE CONFIDENTIAL AND PROPRIETARY Page 9 Page 16 of 171|1010101010101010 10 10|11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Custom interface will be operational with existing third party software. Any subsequent changes to third party applications may require additional services. Price includes 30 days of unlimited technical support; 1-year support can be provided at an additional cost. Prices assume that all software is licensed. Prices are quoted as preliminary estimates only and are subject to further clarification and confirmation. Customer must provide magnetic stripe encoding format. Also, pricing does not include required 3rd party equipment or hardware. New World's GIS/Geofile implementation services are to assist and train customers in preparing their GIS data for use within the Aegis/MSP software. The Aegis/MSP software requires specific GIS data layers; the customer is responsible for providing a street centerline layer and an address point layer if applicable with the required data elements. GIS/Geofile implementation services will also provide assistance in developing additional required data layers such as police beats, fire quadrants, EMS Districts etc. The GIS data provided by the customer must be in industry standard ESRI format. If some of the required data elements are not included in the provided GIS data, New World will work with the customer to create these data elements as appropriate. The GIS/Geofile implementation packet goes into more specific detail as to the required GIS data elements. Requires JRun 3.1 license. The on-going SSMA cost is required for any Aegis software changes related to integration with ESRI software. Maintenance for ESRI's ArcView for maintaining GIS data will be contracted separately with ESRI. If a new release of ArcGIS is incorporated into the Aegis software, an associated upgrade fee may be required for the new ESRI software. All Aegis/MSP Customers are required to use ESRI's ArcGIS Suite to maintain GIS data. All maintenance, training and on- going support of this product will be contracted with and conducted by ESRI. (This software must be installed on a non- Aegis workstation.) Customer is responsible for providing GIS data to New World in industry standard ESRI format. Requires Compaq IPAQ with CDPD modem and PC Expansion Pack and wireless Internet access. Personal Computers must meet the minimum hardware requirements for New World Systems' MSP product. Microsoft Windows 2000 or XP is the required operating system for all client machines. Windows 2000/2003 Server and SQL Server 2000 are required for the Application and Database Server(s). New World Systems MSP product requires Microsoft Windows 2000/2003 Server and SQL Server 2000 including required Client Access Licenses (CALs) for applicable Microsoft products. Servers must meet minimum hardware requirements provided by New World Systems. Customer is responsible for obtaining the necessary State approval and any non-New World hardware and software. New World Systems MSP product requires Microsoft Word and Excel. The Mobile Upload software provides for the automated upload of New World's Law Enforcement Field Reporting data over Customer's mobile data network. Customer is responsible for obtaining from their mobile vendor, the written definition and documentation of the optimal (mobile message) record size to upload laptop data over the mobile network to be used. This definition must be received within thirty (30) days of this Agreement being executed. Currently supporting Motorola, Data Radio (DMP & IP), CDPD, EDACS, CDMA, GPRS, 802.11 and Electrocom Mobile Communication solutions only. Requires NCIC connection through New World Systems software to add NCIC to search results. Requires 3rd party GPS hardware. Requires Pentium PC, Twain 32 Compliant flatbed scanner supplied by Customer. Training and Support Services are billed hourly as used. Travel and expenses are not included as they are billed at actual cost. Any taxes or fees imposed are the responsibility of the purchaser and will be remitted when imposed. MSP ENDNOTES May require a "Serial-to-Ethernet" converter for multiple PSAPs (not included in this proposal). Suggested minimum: 100MB Ethernet Network. 10MB CAT5 Ethernet Network may have less than adequate response time. Further consultation would be required to assess your network. Does not include any required third party hardware or software unless specified in Section C of this proposal. Requires Pentium PC, Twain 32 Compliant Digital Freeze Frame Video Camera or Digital Camera supplied by Customer. Culver City CA Pricing V7 wo.xls ______________________________ Culver City, CA Proposal Summary NEW WORLD SYSTEMS' Aegis PUBLIC SAFETY SOFTWARE CONFIDENTIAL AND PROPRIETARY Page 10 Page 17 of 17