HomeMy WebLinkAboutResolutions - 1999.08.05 - 25636August 5, 1999
REPORT (Misc. #99184)
BY: GENERAL GOVERNMENT COMMITTEE -Shelley G. Taub, Chairperson
RE: DEPARTMENT OF INFORMATION TECHNOLOGY AND OAKLAND COUNTY CLERK/REGISTER OF
DEEDS - PURCHASE OF HARDWARE, SOFTWARE AND SYSTEM SUPPORT FOR IMPLEMENTATION OF
AN ELECTION RESULTS MANAGEMENT SYSTEM (ERMS)
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
The General Government Committee having reviewed the above mentioned resolution on July 26, 1999,
recommends to the Oakland County Board of Commissioners the resolution be adopted.
Chairperson, on behalf of the General Government Committee. I move the acceptance of the foregoing report.
GENERAL GOVERNMENT COMMITTEE
General Government Committee Vote:
Motion carried on a unanimous roll call vote with Dingeldey absent.
MISCELLANEOUS RESOLUTION #99184 August 5, 1999
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY AND OAKLAND COUNTY CLERK/REGISTER or
DEEDS - PURCHASE OF HARDWARE, SOFTWARE AND SYSTEM SUPPORT FOR IMPLEMENTATION OF
AN ELECTION RESULTS MANAGEMENT SYSTEM (ERNS)
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS the Clerk/Register of Deeds - Election Division has identified the
need for automating election night reporting and the canvass of votes to expedite
both processes and reduce the potential for human error; and
WHEREAS the current systems, which are primarily manual, have a number of
deficiencies including:
1. Transmission of results relies on phone calls and fax
transmissions from local jurisdictions; and
2. All results are manually entered on election night; and
3. The canvass of votes is an extensive, hand-written book which
requires manual computation; and
WHEREAS the Election Results Management System would accomplish the
following:
1. Standardize the ballot coding for all Oakland County jurisdictions;
and
2. Improve the speed and accuracy of unofficial election night
reporting and subsequent official canvass, while reducing labor
costs; and
3. Improve existing distribution methods (such as Internet reporting);
and
4. Replace an obsolete existing system, FutureCalc, which is no longer
supported by the vendor with newer, less risky technology; and
WHEREAS the Department of Information Technology and the Clerk/Register of
Deeds - Election Division have identified Election Systems and Software of Omaha,
Nebraska to supply the election night reporting system and customized software
for the canvass automation to meet the Election Division requirements; and
WHEREAS the contract with Election Systems and Software has been approved
by the County Clerk/Register of Deeds, Department of Information Technology and
Corporation Counsel; and
WHEREAS the estimated capital cost to develop the Election Night Report
Application and customized software for the Canvass of Votes to meet the Election
Division requirements is approximately $364,482; and
WHEREAS funding for this one-time expense is available from anticipated
increased volume of forfeited bonds; and
WHEREAS the County Executive recommends approval of this resolution.
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners
approves the acquisition of the Election Results Management System and directs
the Clerk/Register to sign the contract with Election Systems and Software.
BE IT FURTHER RESOLVED the FY 1999 Budget be amended as follows:
CLERK/REGISTER OF DEEDS
Revenue FY 1999
21-120100-01000-0529 Forfeiture of Bonds $364,482
Expenditures
21-330100-01000-8001 Operating Transfer - Out 355,494
21-230100-01000-6636 I.T. Operations-Elections 8.988
$364.482
S_ -0-
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote.
INFORMATION TECHNOLOGY FUND
Revenue
18-636113-10000-1701 Operating Transfer - In
18-636111-10000-0737 O.C. Depts. - Operations
Expenditures
18-636142-15000-3596 Software
18-636142-15000-3348 Professional Services
18-636142-15000-3900 Depreciation
18-636113-10000-8005 Changes in Fund Equity
$355,494
8,988
$364,482
$ 13,975
242,400
74,972
$331,347
$ 33,135
Chairperson, on behalf of the Finance Committee, I move the adoption of the
foregoing resolution.
FINANCE COMMITTEE
Election Systems and Software, Inc. Election Management Software Group and
The County of Oakland/Clerk/Register of Deeds-Election Division
ELECTION RESULTS MANAGEMENT SYSTEM
PRODUCTS AND SERVICES LICENSE AGREEMENT
This agreement is entered into effective the I bf day of 004leit, 1999, by and between Election Systems and
Software, Inc. Election Management Software Group located in Chicago, Illinois (hereinafter referred to as
"ES&S") and the COUNTY OF OAKLAND, a Michigan Constitutional Corporation, whose principal offices are
located at 1200 North Telegraph Road, Pontiac, MI. 48341, (hereinafter referred to as "County"). ES&S agrees to
provide Election Management System(s) products and services as identified in this agreement and the County agrees
to pay for such system products and related services, as specified in this Agreement, subject to the terms and
conditions set forth herein.
TERMS AND CONDITIONS
1. LICENSE. ES&S hereby grants to the County a perpetual, non-exclusive license (the "License" ), to use
the Documentation and the Election Results Management System(s) ( the "Software" ) specified in
Schedule A of this agreement for the fees and charges also specified in Schedule B of this Agreement. The
license is subject to any terms, conditions, exclusions, and constraints as detailed in Schedule A. This is
not a third party or subcontractor license and the County shall use the Software provided for under this
agreement only for internal business purposes. The County shall not utilize software in a service bureau for
third parties or otherwise make documentation or programs available to a third party. The schematics,
component descriptions, software and data bases are property of ES&S and may be retrieved by ES&S any
reasonable time after this Agreement has been terminated,
2. COPYRIGHT. ES&S retains all right, title and interest in and to the Software and the Documentation
including all copyrights. The Software and related Documentation are protected by the copyright laws of
the United States and international treaty provisions. There are severe penalties, both civil and criminal, for
copyright infringement. The County may transfer the Software to a hard disk(s) and keep up to three
copies of the Software, including the original copy, solely for back-up or archival purposes. The County
may not copy the Documentation except for internal use.
3. PRODUCTS AND SERVICES TO BE PROVIDED. (a) ES&S shall provide support to install, integrate,
and make operational the hardware and software they supply, wherever appropriate, in the network
operating environment at Oakland County, which consists of a Novell 4.11 (soon to be 4.12) network
running TCP/IP, with client workstations running Windows NT 4.0/SP4. (b) ES&S shall provide, at a
minimum, helpline support from 8:30 AM to 8:30 PM eastern standard time Monday through Friday except
national holidays other than election day for all systems installed under this agreement; (c) ES&S may,
from time to time as it deems appropriate, provide modifications and enhancements for any systems
installed under this agreement. ES&S reserves the right to discontinue support on prior system versions 180
days after the County receives a new version of the software. (d) ES&S will assign Mary Kay Lindmeier as
the ES&S project manager for the duration of the agreement(s) with Oakland County. In the event that a
replacement project manager needs to be assigned, Oakland County will have the right of approval before
assignment is made.
1
4. CLIENT DATA INPUT. The County is responsible for providing all input data for the Election Results
Management System(s) to be utilized under this Agreement in the manner, form and format specified for
the system(s) being utilized. ES&S shall not be responsible for errors in data entry or other services,
programs, hardware, data files, or output provided to the County hereunder resulting from errors in the
County's input data or from the County's failure to comply with the provisions of this paragraph. The
database designs and layouts are the property of ES&S and shall remain so upon termination of this
Agreement. Any modifications or attempts by the County to view, manipulate, or extract information from
or about these databases shall, at the option of ES&S, void any warranties either in writing or implied and
ES&S shall not be obligated to make any corrections or modifications resulting from those actions by the
County.
5. CONFIDENTIALITY. All disclosure of data and information shall be governed by the statutes of the
State of Michigan. ES&S will treat all non-publicly available data furnished by the County as the
confidential data of the County and ES&S. The County will use reasonable measures to prevent disclosure
to third persons without the prior written consent of ES&S, of such programs, documentation, systems,
techniques, and know-how of ES&S. The obligations of the Parties under this paragraph shall survive
termination of this Agreement.
6. PROPRIETARY RIGHTS. County shall obtain no proprietary rights in the designs, programs, or
documentation provided by ES&S under this agreement, whether such are developed specifically for
performance of this Agreement or otherwise. County acknowledges that all designs, documentation, and
programs relating to the Software provided hereunder, and all tangible and intangible property rights
related thereto are the sole and exclusive property of ES&S. County acknowledges that ES&S may use any
publicly available data provided by the County to ES&S in other aspects of ES&Ss business without
notification.
7. MODIFICATION AND ENHANCEMENTS. The designs, documentation and programs provided under
this agreement consist entirely of proprietary products of ES&S. Any modifications made by the County
shall, at the option of ES&S, void any warranties either in writing or implied and ES&S shall not be
obligated to make any corrections or modifications resulting from those actions by the County. The County
may not modify, reverse engineer, decompile or disassemble the Software.
8. WARRANTY.
(A) OWNERSHIP. ES&S is the owner of the System or otherwise has the right to grant to the County the
license to use same set forth in the Agreement without violating any rights of any third party, and there
is currently no actual or threatened suit by any such third party based on an alleged violation of any
such right by ES&S.
(B) BUSINESS REQUIREMENTS. ES&S is fully aware of the County's business requirements and
intended uses for the Software as set forth in the Schedule A and warrants that the System shall satisfy
such requirements and is fit for such intended uses.
(C) YEAR 2000 WARRANTY. ES&S warrants that all software acquired hereunder by the County
includes or shall include, at no added cost to the County, capabilities to ensure Year 2000
compatibility. The Vendor warrants that no software abnormality and/or generation of incorrect results
shall occur due to date oriented processing. The software design shall ensure Year 2000 compatibility
and shall minimally include data structures, databases, common data files, etc. that provide four digit
date century, stored data that contains date/century recognition including, but not limited to, data
stored in databases and hardware device internal systems dates, calculations and program log logic,
including sort routines, calendar generation, event recognition and all processing actions that use or
produce date values. The system shall accommodate same century and multi-century formulas and
date values and interfaces that supply data to and receive data from, other systems or organizations to
ensure date compliant integrity. The system shall also ensure that all logic will accommodate leap
year.
2
9. LIMITATION OF LIABILITY. THE WARRANTIES IN THIS AGREEMENT ARE GIVEN IN LIEU
OF ALL OTHER WARRANTIES, EXPRESSED AND IMPLIED, INCLUDING BUT NOT LIMITED
TO WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, AND
ARE THE SOLE WARRANTIES MADE BY ES&S WITH RESPECT TO THE SYSTEM. ES&S
SHALL HAVE NO LIABILITY FOR CONSEQUENTIAL, EXEMPLARY, OR INCIDENTAL
DAMAGES.
10. INDEMNIFICATION. ES&S shall indemnify and hold the County harmless from any and all actions,
liabilities, claims, loss and damage (including costs of litigation, actual attorney fees, paralegal, expert
witness fees, and costs incurred in the settlement or avoidance of any such claim) alleged to have been
caused by, or to have arisen, directly or indirectly, from the acts, performances, negligence, malpractice,
errors or omissions of ES&S or ES&S's assistants, employees or agents, including without limitation, all
claims relating to injury or death of any person or damages to any property.
10a. COPYRIGHT, PATENT AND TRADE SECRET INDEMNIFICATION. ES&S agrees to
indemnify and hold the County harmless from all claims from a third party arising out of any legal action or
suit based on any claim that the Software infringes upon a patent, copyright or third party trade secret,
provided, however, that the County shall have notified ES&S promptly of the claim underlying said action
and of the action itself and ES&S shall have full control of the defense of and/or agree to any settlement of
any action to which the indemnity relates.
10b. INDEMNIFICATION FROM ES&S CUSTOMERS. ES&S agrees to indemnify and hold the
County harmless against any and all losses, liabilities, awards and costs (including legal fees and expenses)
arising out of or related to any third-party claim resulting from the use of the Software by other licensees of
ES&S.
11. LIMITED WARRANTY. ES&S warrants that each system installed under this agreement will
substantially perform in accordance to the Documentation for a period of 1 year after installation. ES&S
will, if all other terms and conditions of this agreement are met, make those corrections and modifications
necessary to fulfill this warranty. This Limited Warranty is void if failure of the Software has resulted
from accident, abuse or misapplication.
12. EXCUSABLE NONPERFORMANCE. The obligations of the parties hereunder shall be suspended to
the extent that they are hindered or prevented from complying therewith because of labor disturbances
(including strikes or lockouts), war, acts of God, fires, storms, accidents, governmental regulations, or any
other cause whatsoever beyond either of the parties' control.
13. TERM. This Agreement shall be effective when signed by a duly authorized agent of the Parties and shall
continue in force for the initial term of one year if the system/Software is purchased. Unless the County
gives 90 days prior written notice of its desire not to renew this Agreement at the expiration of any term,
this Agreement shall be automatically renewed for successive periods of one year each. Notwithstanding
the term and payment obligations imposed by this agreement it shall be governed by any governmental
non-appropriation statutes that apply to the County.
14. PRELIMINARY ACCEPTANCE. Upon written notification of completion of development, installation
and system testing by the Vendor, the County shall have a period of thirty (30) days to accept or reject the
System. The Vendor shall promptly rectify any defect or variance from the Functional Specifications or
Detailed Design Specifications. "Preliminary Acceptance" shall be deemed to occur when the County
notifies the Vendor in writing that the system has been preliminarily accepted. Any extension of the thirty
(30) day period for Preliminary Acceptance must be agreed to in writing by the Parties.
15. FINAL ACCEPTANCE. After preliminary acceptance, the System shall be used by the County for
processing of live data for a period of thirty (30) days. Upon completion of processing during such thirty
3
(30) day period without any unresolved or uncorrected material problem or program errors, the System
shall be used for live processing of County data in a production environment for an additional period of
thirty (30) days. The successful completion of such additional thirty (30) day period in which the system
shall meet or exceed the specifications set forth in Schedule A and during which there shall be no
unresolved or uncorrected material problems or system errors under the control of the ES&S, shall be
deemed to be a "Final Acceptance" with respect to the System. A "Final Acceptance" shall be deemed to
occur when the County notifies ES&S in writing that the System has been accepted. Any extension of the
time periods for Final Acceptance must be agreed to in writing by the Parties.
16. INSURANCE. ES&S agrees to obtain the following insurance coverage:
a. Commercial General Liability in the minimum amount of $1,000,000 Combined Single Limit with
the following requirements:
Products and completed operations
Broad form property damage
Premises/Operations
Independent Contractors
(Blanket) Broad form Contractual
Personal Injury—delete contractual exclusion "A" and employee exclusion "C"
Additional Insureds—the County of Oakland, and employees and elected and appointed
officials of Oakland County
b. Workers' Compensation as required by law if applicable:
$500,000 Employers' Liability if applicable
c. $1,000,000 Combined Single Limit Automobile Liability, including hired and leased vehicles, and
owned and non-owned autos:
No Fault coverage as required by law
d. Professional Liability/Errors and Omissions coverage for Computer Programming and Software
Development in the minimum amount of $1,000,000 per occurrence.
Certificates of Insurance All Certificates of Insurance, Self-Insurance, Bonds, or other applicable or
required documents, are to provide thirty (30) days notice of material change or cancellation. These
Certificates must be provided to the following County Agents, the Oakland County Risk Management &
Safety Division and the Oakland County Purchasing Division, before the effective date of this Contract, and
at anytime thereafter, upon reasonable request. Insurance carrier(s), coverage(s), and policy limits are also
subject to the approval of these County Agents as to conformity with the requirements of this Contract.
17. FEES AND CHARGES. Fees and charges to be paid for each system installed under this agreement consist
of a purchased system cost and an annual maintenance and license fee for each year each system is used
beyond the first year of installation. The fees and charges for all products and services to be provided under
this agreement are identified in Schedule B.
18. PAYMENT SCHEDULE. The schedule for payment of all charges for the Election Results Management
System is that they are to be paid as invoiced.
4
19. OTHER SERVICE COSTS. Service costs incurred for the Election Results Management Systems
purchased will be charged per the following schedule. All shipping costs will be FOB-Destination Point.
All other service costs are payable forty-five (45) days after invoice for service is presented.
20. TERMINATION. (a) If either Party defaults in a material obligation under this Agreement and continues
in default for a period of ten days after notice of default is received by the other, the other may terminate this
Agreement by notice effective on the date of receipt by the defaulting Party of such termination notice or on
such future date as is specified in such notice.(b) Upon termination of this Agreement, data contained in the
databases shall be provided, if requested within 30 days after termination, to the party in a Standard Data
Format (SDF) at a reasonable cost to the party. (c) The County has the right to terminate the Software
Service and Support portion of this contract, for any reason, upon thirty (30) days written notice. The
County's obligation in the event of termination is for payment of actual services rendered until ES&S is
notified of termination, or for services actually rendered during the period of notice after notice is served. In
the event of termination, the County is not obligated for any payment during the term of the Agreement
unless such term is less than thirty (30) days after the time notice of termination is given.
21. NOTICE. Whenever in this Agreement notice is called for, a party shall give notice to the other in writing
by first-class mail certified, return receipt requested, addressed to the address of the recipient stated in this
Agreement (or to such address as the recipient, by notice, shall designate).
22. SOFTWARE ESCROW. ES&S shall place in escrow with its designated third party escrow agent copies
of all schematics, component descriptions and software source code for all Election Results Management
System(s) provided to the County under this agreement. Should ES&S cease operations or otherwise
become unable or unwilling to, in accordance with the terms and conditions of this agreement, maintain
and support the software installed then in such case the County shall have the right of access to such
materials retained by the escrow agent to the extent required to properly maintain and utilize said software.
The schematics, component descriptions and software source code will become the property of the County
and shall be provided to the extent required to properly maintain and utilize said software by the County
under section One (1) of this Agreement. The schematics, component descriptions and software source
code may not be used, in whole or in part, for sale or use in another application whether for internal or
external business purposes.
23. ASSIGNMENT. This Agreement shall be binding upon the successors and assigns of both parties,
provided, however, that no assignment, delegation or other transfer shall be made by either party without
the prior written approval of the other, which approval shall not be unreasonably withheld. ES&S may not
subcontract any obligations under this Agreement without prior written consent of the County and ES&S
remains primarily liable for all work provided by the subcontractor.
24. RELATIONSHIP OF THE PARTIES. The parties agree that nothing in this Agreement is intended to
establish an employer-employee relationship between the County and ES&S. ES&S's relationship to the
County is that of an Independent Contractor. This Agreement shall not imply or result in any County
liability for or to ES&S or any of its employees or agents for the accrual of and/or any liability for any
benefits such as, but not limited to, worker's compensation, retirement, pension, vacation pay, sick pay,
merit increases, annual leave days, promotion, disability pay, insurance of any kind, or any other rights or
liabilities arising out of or in connection with this Agreement or any alleged employer-employee
relationship between the County and ES&S agents or employees.
25. CONFLICT OF INTEREST. Pursuant to the provision of Public Act 317 or 1968, as amended (MCL
15.321, et seq.), no contracts shall be entered into between the County including all agencies and
departments thereof, and any employee or officer of the County. To avoid any real or perceived conflict of
interest, ES&S shall identify any relative or relative of the ES&S's employees and subcontractor who are
presently employed by the County. Nothing contained in this provision limits or is intended to limit in any
way ES&S's right to offer and provide its services to the general public or other business entities,
municipalities or governmental agencies, during or after the term of this agreement, or from working for
more than one firm, entity or agency during the term of this Agreement. ES&S may provide services to
others during the periods when ES&S is not engaged in performing services for the County. This
5
Agreement is a non-exclusive agreement, and the County may engage other independent contractors to
perform the same work which ES&S performs.
26. AUDIT. ES&S shall allow the County's Auditing division to perform financial and compliance audits as
appropriate with the authority to access all pertinent records and interview any of ES&S's employees
throughout the term of the Agreement and for a period of three years after final payment to ensure a
complete post-evaluation of services.
27. NON-DISCRIMINATION. In connection with the performance of work under this contract, ES&S
agrees not to discriminate against any employee or applicant for employment because of sex, race, religion,
color, national origin, or handicap. The aforesaid provision shall include, but not be limited to the
following: recruitment or recruitment advertising; employment, upgrading, demotion or transfer; layoff and
selection for training, including apprenticeship, in accordance with rules and regulations promulgated by
the Federal (Compliance Responsibility for Equal Employment Opportunity—Chapter 60, 60-1, 4, No. 1-7)
and State (Standards and Procedures for Executive Directive 1975-6, Section II-C, IV-C, and V-A&B)
agencies and related Federal and State laws and regulations.
28. NONWAIVER. Either Party's failure at any time to require strict performance by the other of any of the
provisions hereof shall not waive or diminish that party's rights thereafter to demand strict compliance
therewith or with any other provision. Waiver by either Party of any default by the other shall not waive
any other or similar defaults by the other.
29. ENTIRE AGREEMENT. This Agreement and additional Schedules constitute the sole and complete
Agreement between the Parties concerning the matters addressed herein and supersedes all prior proposals,
RFP responses, Agreements, representations, warranties, conditions, or understandings between the Parties,
whether written or oral, regarding such matters. If any provision of this Agreement is invalid under any
applicable statute or rule of law, it is to that extent to be deemed omitted. The remainder of the Agreement
shall be valid and enforceable to the maximum extent possible.
30. TITLES. Paragraph titles contained herein are for convenience only and shall not govern, limit, modify, or
affect the scope, meaning, or intent of the provisions of this Agreement.
31. MODIFICATION. No modification to this Agreement shall be effective unless it is in writing signed by
duly authorized representatives of both Parties.
32. GOVERNING LAW. This Agreement shall be governed by the laws of the State of Michigan. Subject to
any applicable Michigan or United States statute or court rule prohibiting same the Parties agree that the
sole and exclusive jurisdiction venue for any litigation arising from or relating to this Agreement or the
subject matter thereof shall be appropriate in the State of Michigan located in Oakland County.
6
FOR THE VENDOR:
Sin
BY:
)1N.rkt, Subscribed and sworn to before me on the, )t) — day of
BY:
Oakland County Clerk/Register of Deeds
7
For and in consideration of the mutual assurances, promises, acknowledgments, warrants, representations, and
agreements set forth in this Agreement, and for other good and valuable consideration, the receipt and adequacy of
which is hereby acknowledged, the undersigned hereby execute this Agreement on behalf of the County and the
Vendor, and by doing so legally obligate and bind the County and the Vendor to the terms and conditions of this
Agreement.
DATE: --- 3 fr. '5
that: behalf of the Vendor and acknowledged to me under oath at:
appeared in person before this date 01 e cuted this Agreement on
kn -\1-• i IC _ has taken all
actions and secured any and all necessary approvals and authorizations and has the requisite authority from the
Vendor to fully and completely obligate and bind the Vendor e terms and cgif ns of this Agreement and any
and all other documents incorporated herein by reference. T. also acknowledged
before me having been provided with copies and having read and reviewed all Agreement documents incorporated
herein.
, 1999.
1C 1-1\AMa(NC\WQA`/- CLA)
COOK MNotary Public
Cou
, ,
nty,4eitigan 11 t)‘
My Commission Expires: Fray I () 3,003
OFFICIAL SEAL
RHONDA HELENE ARST
NOTARY PUBLIC STATE OF ILLINOIS
MY COMMISSION EXP. FEB. 172003
FOR OAKLAND COUNTY:
DATE: ktZtIRAJ 11
'9
Schedule A
Oakland County, Michigan
ELECTION REPORTING MANAGEMENT SYSTEM & CANVASS
The following details the components of the Proposal.
Hardware and Software Installation — Item 5
A member of our staff will be on-site for the installation and set-up of EMS and AERO.
A thorough system test will be conducted with all equipment that will be used election
day. The network configuration, phone lines, site preparation and cabling is the
responsibility of the County and must be done prior to our staff being on-site for
installation.
Election Support — Item 7
Two staff members will be on-site for the three Year 2000 elections. The staff members
will be on-site for two days each election. One staff member will be a technician and
the second staff member will be a support person.
Election Night Report Application (ENRA) Template — Item 8
This is a database reporting tool created in MicroSoft Access97. It was demonstrated
to show Oakland County that an off-the-shelf tool can be used to create reports after
importing the results data from the EMS ASCII results file. It is likely, that this reporting
will need modifications for each election as well as testing of results / output. This is
more like a spreadsheet model using a common tool, in this case MS-Access97, for
data formatting and report generation. This is not a standard product for ES&S, thus
ES&S will not support on an on-going basis. However, we will sell the model or
template and Oakland County can maintain it from then on using MS-Access97.
The cost includes two days on-site delivery, set-up and one-time training. Oakland
County must supply MS-Access97 and a person knowledgeable with MS-Access97.
Test Election On-Site Support — Item 9
An ES & S staff member will be on-site for two days for each test election. Three test
elections have been planned: October Test of the 1999 Special February Primary and
March General elections; November Test of an August Primary; and an April 2000 test
of a November General will be conducted.
Project Management! Training — Item 10
Project management and training covers the cost of staff involved with the planning and
implementation of this project. This item includes past and a future meeting (planned
for September) by an ES&S staff member for discussion and review of the project with
Oakland County jurisdictions. Travel expenses are also included in this amount.
Item Quantity Cost @ Extended Cost Line
7
8
9
16 Total Project Costs $ 115,475.00
SCHEDULE B
Election Reporting Management System & Canvass
Election Management Software (EMS) - Version # 3.53 1 n/c
Automatic Election Returns Operation (AERO) Version # 3,53 1 n/c n/c
1 ES&S Memory Pack Receiver (MPR) (Item No. 30400-00) 1 $ 6,000.00 $ 6,000.00
2 R/M Cobol - 20 User Runtime - Version #6.10.01 1 $ 980.00 $ 980,00
3 SPR Host Software - Version #1.354 1 $ 2,500.00 $ 2,500.00
4 Retro-fit Eagle with Modem - Modem Dependant (33.6 - 56K) 1 $ 500.00 $ 500.00
Hardware & Software installation support at $250 per hr (Travel 5 40 $ 250.00 $ 10,000.00 included)
6 Network Expenses
On-Site support for first three elections in 2000 (2 persons for
2 days) (Travel included)
Election Night Report Application (ENRA-MS ACCESS
template)
Test Election On-site Support - Three test elections - Oct, Nov
& April (One person for 2 days) (Travel included)
10 Project Management, Consulting and Related Expenses
$ 19,980.00
12 $ 1,500.00 $ 18,000.00
1 $ 3,495.00 $ 3,495.00
6 $ 1,500.00 $ 9,000.00
1 $ 5,000.00 $ 5,000.00
11 Cost for On-site Support, Project Mgmnt and Reports $ 35,495.00
On-site county-wide coding charge - February 22 Presidential
Primary
13 On--site county-wide coding charge - August 8 Primary
14 On-site county-wide coding charge - November 7 General
12 1 $10,000.00 $ 10,000.00
1 $25,000.00 $ 25,000.00
1 $25,000.00 $ 25,000.00
15 Annual Coding Costs for 2000 $ 60,000.00
oalclandshrt.xls Phase II 09/2911999 8:49 AM Page 1
FOREGOING RE/SOL,UTIC),‘,
arson, County Executive NINeour . Date
HEREBY
Brook
ogPRo
Resolution #99184 August 5, 1999
Moved by Douglas supported by McPherson the General Government Committee
Report be accepted.
A sufficient majority having voted therefor, the report was accepted.
Moved by Douglas supported by McPherson the resolution be adopted.
AYES: Causey-Mitchell, Colasanti, Coleman, Douglas, Garfield, Gregory,
Jensen, Law, McCulloch, McPherson, Melton, Millard, Obrecht, Palmer, Patterson,
Schmid, Sever, Suarez, Taub, Amos, Appel. (21)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolution was adopted.
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, G. William Caddell, Clerk of the County of Oakland, do hereby certify that the
foregoing resolution is a true and accurate copy of a resolution adopted by the
Oakland County Board of Commissioners on August 5, 1999 with the original record
thereof now remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the
County of Oakland at Pontiac, Michigan this 5th day q; August, 1999.
G.tWilliam Caddell, County Clerk