Loading...
HomeMy WebLinkAbout6144RESOLUTION NO. 6144 A RESOLUTION APPROVING A CONTRACT BETWEEN THE CITY OF PUEBLO, A MUNICIPAL CORPORATION, AND THE COLORADO STATE DEPARTMENT OF HIGHWAYS DIVISION OF HIGHWAY SAFETY CONCERNING CENTRALIZED TRAFFIC DATA AND AUTHORIZING THE PRESIDENT OF THE COUNCIL TO EXECUTE SAME. BE IT RESOLVED BY THE CITY COUNCIL OF PUEBLO, COLORADO, THAT: SECTION 1. The contract between the City of Pueblo, a Municipal Corporation, and the Colorado State Department of Higways, Division of Highway Safety, relating to the acceptance of $14,400 in grant monies is hereby approved. Grant monies will be used to centralize traffic data entry and develop a data base of traffic violations and accidents transferrable to micro - computers. SECTION 2. The City of Pueblo's share of the project, in the amount of $16,977, is available in and is hereby transferred from accounts 001 -0100- 109 - 0 - 010 - 0104, 001- 0100 - 109 -0 020 - 0004, 001 - 0100 - 109 -0 020 - 0008, 001 - 0100 - 109 -0 020 - 0009, and 001 -0100- 109 -0 030 - 0011. SECTION 3. The President of the City Council is hereby authorized to execute this contract for and on behalf of the City and the City Clerk is authorized and directed to attest same and affix the seal of the City thereto. `_ ATTEST: Introduced February 8 , 1988 Michael A. Occhiato Councilman APPROV r sident of the Council 7 r � Cit Clerk COLORADO DEPARTMENT OF HIGHWAYS- DIVISION OF HIGHWAY SAFETY TRAFFIC SAFETY PROJECT APPLICATION 1. Proposed Activity: Centralized Traffic Data Entry 2. Applicant Agency City of Pueblo, Data Processing Department. Mailing Address 150 Central Main Street Pueblo, Colorado 81003 3. Policy and Budget Authority: Lewis Quigley, City Manager 4. Proposed Period: (mo) (day) (yr) (mot taay) tyrt From 1 1 88 To 8 31 88 5. Signature (see additional certifications on next page): (type name and title) 6. Date Submitted: 12 -15 -87 7. PRELIMINARY APPROVAL (Policy and Budget Authority): Signature: !� (type name and title) Lewis Quigley, City Manager For: )Agency) City of Pueblo Date: December 15, 1987 NOTE. Refer to Section 11, Colorado Division of Highway Safety Contract Management Manual for instructions in the preparation of this application. rnnu c........ DHS Previous eamon■ ars aosms.. -au -, ­ . - - - -. --- i ADDITIONAL REQUIRED CERTIFICATIONS 1. AFFIRMATIVE ACTION: . (use one of the two following statements) NOTE: If an affirmative action plan is required, but has not been previously approved, it should accompany this application at the time of submission. I certify an affirmative action plan, meeting the requirements of Title VI of the Civil Rights Act of 1964, 78 Stat. 252, (42 U.S.C. 200d -d4) has been approved by and is on file with, the Colorado Department of Highways Equal Employment Opportunity Office. Signature J`�l J W✓ .0 (type name and title) Lewis Quigley, City Manager I certify an affirmative action plan, meeting the requirements of Title VI of the Civil Rights Act of 1964, 78 Stat. 252, (42 U.S.C. 2000d -d4) is not required for this agency. Signature (type name and title) 2. PROJECT CONTINUATION: I certify it is intended to continue any highway safety- funded project activities to a point in the future substantially beyond the project expiration date without any material reduction In the level or thrust of the efforts. STRIKE OUT ANY OF THE FOLLOWING NON - APPLICABLE STATEMENTS. QAc�adtaXipaoXOCacatDt�erx�4# isc3�xitxxm 'leatKklW�atOtagxMols�c�ft . 6II��bG�6J�ldX�i10RX�XUC�f 1�d g �(YD�da76D(�iK)C)0�(UCVVQ4?4 ft(?tF�m}� 7 � X ((7E<1F�k�(�( u X�C �$ck����k>�d�t6l �xaoA�] a�Cat�iK�iaQ1XQl�rl%�C14��y�1]4 �1�tPtxd ��`1�14�da1 �lit4�6tI�1�4J�yX�f�� ftxxicsck( �AcaiQxr ore�a ►t?gcacge�a�c�C>�at�}ax�xDC� t4t<gV�v���1St4i��y�E i� l4m���Sd�d�4?4�P4r�t`c�a'ti4�S� wok l� a �i oa � ix�tic�c#�r�aaig�c � ►`altf c � �i �ifl�f�r�tX� x �i dit�g � YsXy� Signature (type name and title) Lewis Quigley, City Manager OHS -10 cuum Form page 2 I PART A - PROBLEM STATEMENT (1) Describe the situation. Include data and any other information to establish the existing conditions. (2) State why this situation is undesirable. (3) What are the causes? (4) Identify changes needed to resolve the identified problem(s). When the computerized record - keeping system was developed in -house for the Pueblo Police Department eight years ago, the decision was made to omit traffic records from the system. That decision was based upon three pertinent facts. First, on -line storage was limited and traffic records would require a great deal of disk space. Second, all necessary information was at that time being collected and made available on -line through the STEP/MIS program and to include traffic information in the Pueblo system would be a duplication of records. Finally, one full -time employee was responsible for data entry into the STEP/MIS system, and it was considered an unnecessary duplication of effort to repeat the process for the Pueblo system. In March of 1986, the STEP/MIS program was decentralized through a system of microcomputers, and traffic information was no longer collected or available through the on -line system. Although disk storage space was no longer a problem, the need for on -line records and centralized data entry still existed, and traffic records were assimilated into the Pueblo records system. One of the two Zenith microcomputers provided by the Division of Highway Safety was placed in the Police Department's Traffic office and the other in the City Traffic Engineer's office, where STEP/MIS information pertinent to each office could be collected and necessary reports generated. Unfortunately, funds were not available for the newly acquired data entry functions in the two City departments, and now while traffic records are available through the on -line records system, STEP/MIS information is gathered and reports generated only when manpower is available for data entry in either of the two departments. Both the Police Department and the Traffic Engineer agree that valuable statistical information is to be had through the STEP/MIS programs developed to run under REVELATION software on the Zenith computers, however, neither department considers it cost efficient to duplicate the data entry process on the mainframe and on the microcomputers. The City's Data Processing Department has offered a centralized data entry solution based on the collection of data through the mainframe and the transferral of that data to the microcomputers. A programmer who has interned for the Data Processing Department for two years was hired on a temporary basis in June, 1987, to begin work on the solution. Analysis of the system requirements has been completed and program design has begun, however, funding for the programmer will run out December 31, 1987. To complete the process will require the modification of certain programs now running on the mainframe, the development of new mainframe programs focusing on traffic records, and the development of microcomputer programs to convert the raw data to REVELATION format. 1988 budgeted staffing for, the Data Processing Department is not adequate to complete these tasks on a timely basis, and funding of the temporary programmer is needed for the remaining eight months of the project. CDOH Form a PART B - PROPOSED ACTIVITIES GOAL To centralize the data entry function for the City of Pueblo's traffic incident records and provide for the transfer of necessary data from the mainframe to the microcomputer -based STEP/MIS system. TASKS: State what is to be accomplished and when. 1. Modify existing mainframe programs to separate traffic - related incidents from criminal incidents by March 1, 1988. 2. Generate new mainframe programs to add, modify, and query traffic- related incidents by May 1, 1988. 3. Install, test, and debug completed on -line system by June 1, 1988. 4. Generate, test, and debug data transfer programs by July 1, 1988. 5. Train users, document, and install completed system by September 1, 1988. PART C - CAPITAL EQUIPMENT What equipment, if any, will be purchased to meet the needs of this project? NOTE: Items previously purchased with highway safety funds are not eligible for replacement with highway safety funds. NONE DHS -10 l.Uu rorm p:. 4 PART D- EVALUATION AND MONITO (1) State how success or failure of the project will be determined. Administrative, Performance or Impact measures can be used (See Project Evaluation in Contract Management Manual). Success or failure of the project will be determined by the following administrative criteria: 1. Is the traffic system completely compatible with the current , on -line system and the STEP/4IS microcomputer system? 2. Is the system user friendly both from the data entry /retrieval standpoint and from the operational standpoint? 3. Is the system reliable and completely debugged? 4. Are resultant reports correct in both content and format, and do they meet the needs of the users? (2) State how the Contract Director will monitor project activity and progress during the contract period. The Contract Director will monitor project activity through the use of weekly status reports and time sheets required of project participants. TI>ese reports include progress made during the reporting period, problems encountered, and percent of completion. The forms are part of a standard procedure within the Data Processing Department. coon Form DHS -10 page 5 PART E - BUDGET PERSONAL SERVICES DHS Use Only (1) Salaries HSP Task Number Name or Position Base Pay ($) Benefits (S) Monthly Weekly Etc. No. of Mos. Total (S) DHS Share (S) Agem Shar (S) David Van Dyke 10.00 -0- Hourly 8 14,400 14,400 -0- _ Programmer 2212 500 Monthly 4 10,848 -0- 10,84E Jr. Programmer 1900 500 Monthly 2 4,800 -0- 4,80( SUBTOTALS — SALARIES 30,048 14,400 15,6 (2) Overtime HSP Task Number Name Overtime Rate ($) No. of Units Total Cost ($) DHS Share ($) Agenc Shari (S) SUBTOTALS - OVERTIME (3) Contractual Services HSP Task Number Contractor Dates of Contract Rate ($) No. of Units (Indicate H,D,M,FP) Total Cost ($) DHS Share ($) Agen( Share ($) SUBTOTALS - CONTRACTUAL SERVICES DHS Share Agency Shar TOTAL - PERSONAL SERVICES $ 30,048 $ 14,400 $ 15,648 48 % 52 DHS -10 CDOH Form pago 6 PART E - 'BUDGET (continued) OHS Use Only OPERATING EXPENSES HSP Task Number Description Number of Units Cost per Unit (sl Total Cost (sl DHS Share (S) Agenc Share (s) Computer Paper 10 Cases 28.00 280.00 280.0( Printer Ribbons 2 Each 26.00 52.00 52.0( Backup Tapes - Mainframe 12 Each 16.00 192.00 192.0( Diskettes 100 Each 1.50 150.00 150.0( Removable Hard Disks (pc) 5 75.00 375.00 375.0( Telephone Charges - Long Distance 10 5.00 50.00 50.0( Consultation Fees / Hour 2 65.00 130.00 130.0( Basic Compiler 1 100.00 100.0( DHS Share Agency Shz TOTAL OPERATING EXPENSE $ 1329.00 -0- 1329.00 -0- % 100 DHS -10 PART E —BUDGET (continued) DHS Use Only TRAVEL AND SUBSISTENCE HSP Task Number Description In State (S) Out of State (S) Total (S) DHS Share (S) Agem Shar (S) DHS Share Agency SK TOTAL TRAVEL AND SUBSISTENCE $ _p_ $ $ DHS use Only CAPITAL EQUIPMENT HSP Task Number Descriptlon N or R No. of Units Cost per Unit ($) Total ($) DHS Share ($) Agenc Share ( S) DHS Share Agency Sh. TOTAL CAPITAL EQUIPMENT $ - o - $ $ o� DHS -10 %.utin row page a PART E - BUDGET (continued) BUDGETSUMMARY (from pages 6 through 8) DHSSHARE AGENCYSHARE Personal Services $ 14,400 $ 15,648 Operating Expenses $ -0- $ 1,329 Travel and Subsistence $ -0- $ - Capital Equipment $ -0- $ -0- SUBTOTALS $ 14,400 $ 16,977 Percent of Total 46 54 PROPOSED PROJECT TOTAL $ 31,377 DHS-10 n q n q PART F - PROPOSED PROJECT CONTINUATION AND PLANNED ASSUMPTION OF COSTS 1. PROJECTED FUNDING FY 1989 A. Describe objective, activities, and proposed funding source: The costs associated with this project will be absorbed within the Data Processing Department's budget once the system is installed and debugged. Activities will be limited to program maintenance and system enhancement on an as requested basis. B. PROJECTED BUDGET SUMMARY Personal Services $ Operating Expenses $ Travel and Subsistence $ Capital Outlay $ TOTAL $ 2. PROJECTED FUNDING FY A. Describe objective, activities, and proposed funding source: B. PROJECTED BUDGET SUMMARY Personal Services $ Operating Expenses $ Travel and Subsistence $ Capital Outlay $ TOTAL $ CDO14 Form q nNS -1Q -- t;+ PART'G ANFORMATION FOR PROJECT CONTACTS 1. CONTRACT DIRECTOR 3. PROJECT COORDINATOR NAME Judy Leach, Director of Data Processing NAME Judy Leach, Director of Data Processing ADDRESS 150 Central Main Street ADDRESS 150 Central Main Street Pueblo, Colorado 81003 Pueblo, Colorado 81003 TELE N 303) 542 -2491 TELE NO. (303) 542 -2491 2. ACCOUNTING RECORDS: 4. MAIL PROJECT PAYMENTS TO: NAME Billy G. Martin, Director of Finance NAME Billy.G. Martin, Director of Finance ADDRESS #1 City Hall Place ADDRESS #1 City Hall Place Pueblo, Colorado 81003 Pueblo, Colorado 81003 TELE NO. (303) 543 -1041 TELE NO. (303)543 -1041 PART H - PROJECT APPROVAL Director, Division of Highway Salety Date CDOH Form #1 DHS-10 page 11 Form 6 A(' -02A I 5195) CONTRACT UFPARI NII-N [OR AGLN('Y NUMB LR oNTR.%cI RUUI°IN(; Nt!%16FR THIS CONTRACT, made this day of 198 __._ . by and between the Starr of Colorado for the use and benefit of tile Ikpartment of ' _ Highways, Division of High waY Safet hereinafter referred to as the State, and * Th City of Pueb 0 o�e US@ an befit of the Da ta Processing Department hereinafter referred to as the contractor, WHEREAS, authority exists in the Law and Funds have been budgeted, appropriated and otherwise made available and a sufficient unencumbered balance thereof remains available for payment in Fund Number 2001 G/L Account Number 55616 , Contract Encumbrance Number 98923 ; and WHEREAS, required approval, clearance and coordination has been accomplished from and with appropriate aoencies: and WHEREAS, the State has received approval and funding for implementation of its FY 1988 Highway Safety Plan (HSP) from the U.S. Department of Transportation, National Highway Traffic Safety Administration and Federal Highway Administration; and WHEREAS, the HSP contains programs and activities designed to reduce traffic crashes or improve the operational efficiency of existing programs; and WHEREAS, the State is responsiale for the overall administration of the HSP within the State of Colorado; and WHEREAS, certain programs and activities in the HSP can only be accomplished by other State agencies and local agencies; and WHEREAS, the State determines which agencies would be most appropriate in completing the objectives and conducting the activities and services required by the HSP; and WHEREAS, the Contractor has the technical ability to properly complete the objectives and activities described in Attachment A of this Contract; and WHEREAS, it has been determined no State agency can reasonably provide the activities and services required of the Contractor; and WHEREAS, this Contract is executed by the State under authority of Sections 43 -5 -401 and 24 -42 -101, C.R.S., as amended, and is executed by the Contractor under authority of Section 29 -1 -203, C.R.S., as amended, and as authorized by the formal resolution attached hereto as Exhibit A. NOW THEREFORE, it is hereby agreed as follows: 1. The Contractor shall carry out the program and conduct all the activities and provide the services described in Attachment A. attached hereto and incorporated herein. 2. The Contractor shall comply with all the administrative procedures and contract requirements contained in the July 1, 1987 Colorado Highway Safety Contract Management Manual issued by the State. Such procedures and requirements are conditions of this contract. The above - referenced document is incorporated herein and made part hereof by reference. By signature on this contract, Contractor acknowledges receipt of this document and is aware of its content. 3. The Contractor shall submit quarterly and final reports to the State according to the reporting criteria set forth in page two of Attachment A. attached hereto and incorporated herein. 39J530'F1014 Page I of 3 I,at;e, *I ti,.�, •�t tf r�i .. 1 , ,,P. nn f••�Cf v' �n.f t,�:•'.) 4. The budget for this contract is set forth in page 3 of Attachment A attached hereto and incorporated herein. Contractor shall comply with this budget. 5. The maximum total amount of this Contract is $31,377, with the State and Contractor participating as follows: A. State share $14,400 B. Contractor's share $16,977 Total $31,377 The total amount of this Contract shall not be exceeded without the benefit of a supplemental contract executed prior to the performance of additional activities or the incurring of additional costs. 6. The State shall reimburse the Contractor for the accomplishment of this Contract with funds available under the Highway Safety Act, Title 23, U.S.C. Section 402. Such reimbursement shall be only as provided in the July 1, 1987 Colorado Highway Safety Contract Management Manual. 7. The term of this contract shall begin on the effective date and shall terminate on September 30, 1988. The effective date of this contract shall be the date the required signature approval of the State Controller is obtained, as evidenced by the date first appearing above, as filled in by the State Controller. Contractor agrees that any contract work performed prior to the effective date shall not be compensated under the terms of this contract. 8. The contractor agrees any subcontract entered into under this contract must be approved by the Director. Division of Highway Safety. prior to execution. 9. The Special Provisions attached hereto are hereby made a part hereof. Page 2 of 3 pages IN WITNESS WHEREOF. the parties hereto have caused the foregoing contract to be executed by their duly authorized officers the day and year first above written. ATTEST Chief Clerk Highway Department STATE OF COLORADO ROY ROMER, GOVERNOR By A. RAY CHAMBERLAIN EXECUTIVE DIRECTOR DEPARTMENT OF HIGHWAYS JOHN E. CONGER, DIRECTOR DIVISION OF HIGHWAY SAFETY ATTEST By Tit State Controller By JAMES A. STROUP By DUANE WOODARD Attorney General BARRY B. RYAN Assistant Attorney General Natural Resources Section Page 3 of 3 pages City of Pueblo Title _ S /SENT OF 7 0 C) MAzell- APPROVALS COLORADO DEPARTMENT OF HIGHWAYS DIVISION OF HIGHWAY SAFETY CONTRACT OBJECTIVE PLAN State Program: Public Ways Contracting Agency: City of Pueblo. Data Pro cess. e t. State Sub - Program: Project Coordinator: Highway Safety Judy Leach Problem Solution Plan: Contract Period: 3/1/88 - 9/30/88 Project # HSP # Task # Objective: Develop system designs and related programs necessary to integrate the STEP /MIS program into the City of Pueblo's Central Computerized Recordkeeping system by September 30, 1988. Task Activity # Activity Description 43- 01.2.1 Modify existing mainframe programs to seperate traffic - related incidents by May 1, 1988. 43- 01.2.2 Generate new mainframe programs to add, modify, and query traffic related incidents by May 1, 1988. 43- 01.2.3 Install, test, and debug completed on -line systems by June 1, 1988. 43- 01.2.4 Generate, test, and debug data transfer programs by July 1, 1988. 43- 01.2.5 Train users, document and install completed system by September 1, 1988. 43- 01.2.6 Provide final report and system demonstration to DHS personnel by September 30, 1988. DHS -23A Previous editions are obsolete and may not be used coo" Form irllue 6/87 Attachment A , page 1 of 3 ADO DEPARTMENT OF HIGHWAYS N OF HIGHWAY SAFETY TRACT EVALUATION DATA E Project # HSP# Task # 88 -04 43 -01.2 Task Activity # EVALUATION DESCRIPTION Type of Evaluation Report Timeframe 43- 01.2.1 Were mainframe programs modified as required? Performance Quarterly Describe modifications. 43- 01.2.2 Describe programs generated to add, modify Performance Quarterly and query traffic related incidents. - -43- 01.2.3 Was on -line system installed in a timely Performance Quarterly manner? 43- 01.2.4 Were data transfer programs generated? Performance Quarterly Describe operation. 43- 01.2.5 Were users trained? How many? What Performance Quarterly agencies? Was completed system installed? 43- 01.2.6 Submit final report including narrative Performance Final description of: • Compatibility of traffic, on -line and STEP /MIS systems. • User friendliness of systems. • Reliability of system • Reports generated • System operation D H S -23B Previous eamons are oosomm ano may not oe uses Guun corm in lur 8/87 Attachment A , page 2 of COLORADO DEPARTMENT OF HIGHWAYS DIVISION OF HIGHWAY SAFETY CONTRACT FINANCIAL BUDGET Total Project # 23 -88 HSP # 88 -04 Personal Services $14,400 Source of Distribution of Task K Total Funds DHS Funds (Benefit of) 1,329 Cost - 100% DHS State Agency Other State Local Capital Equipment - 43-01.2.1 $31,377 $14,400 - $16,977 $14,400 $16,977 $14,400 Totals $31,377 $14,400 $16,977 $14,400 BUDGET ALLOCATION Category DHS Share Agency Share Total DHS /o Agency io Personal Services $14,400 $15,648 $30,048 48% 52% Operating Expense - 1,329 1,329 - 100% Travel Expense - - - - - Capital Equipment - - - - - TOTAL BUDGET $14,400 $16,977 $31,377 46% 54% DHS -23C Previous editions are obsolete and may not be used CDOH Form 01108 6/87 Attachment A , page —3— of 3 Form s- AC-02B SPECIAL PROVISIONS CONTROLLER'S APPROVAL 1. This contract shall not be deemed valid until it shall have been approved by the Controller of the State of Colorado or such assistant as he may designate. This provision is applicable to any contract involving the pay- ment of money by the State. FUND AVAILABILITY 2. Financial obligations of the State payable after the current fiscal year arc contingent upon funds for that purpose being appropriated, budgeted and otherwise made available. BOND ' REQUIREAIENT 3. If this contract involves the payment of more than fifty thousand dollars for the construction, erection, repair, maintenance, or improvement of any building, road, bridge, viaduct, tunnel, excavation or other public works for this State, the contractor shall, before entering the performance of any such work included in this con- tract, duly execute and deliver to and file with the official whose signature appears below for the State, a good and sufficient bond or other acceptable surety to be approved by said official in a penal sum not less than one - half of the total amount payable by the terms of this contract. Such bond shall be duly executed by a qualified corporate surety, conditioned for the due and faithful performance of the contract, and in addition, shall provide that if the contractor or his subcontractors fail to duly pay for any labor, materials, team hire, sustenance, pro- visions, provendor or other supplies used or consumed by such contractor or his subcontractor in perfornlance of the work contracted to be done, the surety will pay the same in an amount not exceeding the sum specified in the bond, together with interest at the rate of eight per cent per annum. Unless such bond, when so required, is executed, delivered and filed, no claim in favor of the contractor arising wider this contract shall be audited. allowed or paid. A certified or cashier's check or a bank money order payable to the Treasurer of the Stale of Colorado may be accepted in lieu of a bond. This provision is in compliance with 38 -26 -106 CRS, as amended. LN DEMNIFICATION 4. To the extent authorized by law, the contractor shall indemnify, save and hold harmless the State, its employees and agents, against any and all claims, damages, liability and court awards including costs, expenses, and attorney fees incurred as a result of any act or omission by the contractor, or its employees, agents, subcon- tractors, or assignees pursuant to the terms of this contract. DISCRIMINATION AND AFFIRMATIVE ACTION 5. The contractor agrees to comply with the letter and spirit of the Colorado Antidiscrimination Act of 1957, as amended, and other applicable law respecting discrimination and unfair employment practices (24 -34 -402. CRS 1982 Replacement Vol.), and as required by Executive Order, Equal Opportunity and Affirmative Action, dated April 16, 1975. Pursuant thereto, the following provisions shall be contained in all State contracts or sub - contracts. During the performance of this contract, the contractor agrees as follows: (1) The contractor will not discriminate against any employee or applicant for employment because of race, creed, color, national origin, sex, marital status, religion, ancestry, mental or physical handicap, or age. The contractor will take affirmative action to insure that applicants are employed, and that employees are treated during employment, without regard to the above mentioned characteristics. Such action shall include, but not be limited to the following: employment, upgrading, demotion, or transfer, recruitment or recruitment advertising; lay -offs or terminations; rates of pay or other forms of compensation; and sclec- tion for training, including apprenticeship. The contractor agrees to post in conspicuous places, available to employees and applicants for employment, notices to be provided by the contracting officer setting forth provisions of this non - discrimination clause. (2) The contractor will, in all solicitations or advertisements for employees placed by or on behalf of the contractor, state that all qualified applicants will receive consideration for employment without regard to race, creed, color, national origin, sex, marital status, religion, ancestry, mental or physical handicap, or age. (3) The contractor will send to each labor union or representative of workers with which he has collective bargaining agreement or other contract or understanding, notice to be provided by the contracting officer, advising the labor union or workers' representative of the contractor's committment under the Executive Order, Equal Opportunity and Affirmative Action, dated April 16, 1975, and of the rules, regulations, and relevant Orders of the Governor. (4) The contractor and labor unions will furnish all information and reports required by Executive Order, Equal Opportunity and Affirmative Action of April 16, 1975, and by the rules, regulations and Orders of the Governor, or pursuant thereto, and will permit access to his books, records, and accounts by the con- tracting agency and the office of the Governor or his designee for purposes of investigation to ascertain compliance with such rules, regulations and orders. (5) A labor organization will not exclude any individual otherwise qualified from full membership rights in such labor organization, or expel any such individual from membership in such labor organization or dis- criminate against any of its members in the full enjoyment of work opportunity. because of race, creed, color, sex, national origin, or ancestry. (6) A labor organization, or the employees or members thcreol' will not aid, abet, incite, compel or coerce the doing of any act defined in this contract to lie discriminatory or obstruct or prevent any person from complying with the provisions of this contract or any order issued thereunder: or attempt, either directly or indirectly, to commit any act defined in this contract to be discriminatory. .55 -501 122 3 -0 ,95- 3- 1 • 0 page .A.— of I'nues Form 6- AC -02C (7) In the event of the contractor's non- comp' ;ancc with i •,: non - discrimination clauses of this con- tract or with any of such rules, regulations, or orders, this contract may be cancelled, terminated or sus- pended in whole or in part and the contractor may be declared ineligible for further State contracts in accordance with procedures, authorized in Executive Order, Equal Opportunity and Affirmative Action of April 16, 1975 and the rules, regulations, or orders promulgated in accordance therewith, and such other sanctions as may be imposed and remedies as may be invoked as provided in Executive Order, Equal Opportunity and Affirmative Action of April 1.6, 1975, or by rules, regulations, or orders promulgated in accordance therewith, or as otherwise provided by law. (8) The contractor will include the provisions of paragraph (1) through (8) in every sub - contract and subcontractor purchase order unless exempted by rules, regulations, or orders issued pursuant to Executive Order, Equal Opportunity and Affirmative Action of April 16, 1975, so that such provisions will be binding upon each subcontractor or vendor. The contractor will take such action with respect to any sub - contracting or purchase order as the contracting agency may direct, as a means of enforcing such provisions, including sanctions for non- compliance; provided, however, that in the event the con- tractor becomes involved in, or is threatened with, litigation with the subcontractor or vendor as a result of such direction by the contracting agency, the contractor may request the State of Colorado to enter into such litigation to protect the interest of the State of Colorado. COLORADO LABOR PREFERENCE 6 a. Provisions of 8 -17 -101 & 102, CRS for preference of Colorado labor are applicable to this contract if public works within the State are undertaken hereunder and are financed in whole or in part by State funds. b. When a construction contract for a public project is to be awarded to a bidder, a resident bidder shall be allowed a preference against a non - resident bidder from a state or foreign country equal to the preference given or required by the state or foreign country in which the non - resident bidder is a resident. If it is determined by the officer responsible for awarding the bid that compliance with this subsection .06 may cause denial of federal funds which would otherwise be available or would otherwise be inconsistent with requirements of federal law, this sub- section shall be suspended, but only to the extend necessary to prevent denial of the moneys or to eliminate the inconsistency with federal requirements (section 8 -19 -101 and 102, CRS). GENERAL 7. The laws of the State of Colorado and rules and regulations issued pursuant thereto shall be applied in the interpretation, execution and enforcement of this contract. Any provision of this contract whether or not incor- porated herein by reference which provides for arbitration by any extra- judicial body or person or which is other- wise in conflict with said laws, rules and regulations shall be considered null and void. Nothing contained in any provision incorporated herein by reference which purports to negate this or any other special provision in whole or in part shall be valid or enforceable or available in any action at law whether by way of complaint, defense or other- wise. Any provision rendered null and void by the operation of this provision will not invalidate the remainder of this contract to the extent that the contract is capable of execution. 8. At all times during the performance of this Contract, the Contractor shall strictly adhere to all applicable federal and state laws, rules and regulations that have been or may hereafter be established. 9. The signatories hereto aver that they arc familiar with 18 -8 -301, et. seq., (Bribery and Corrupt Influences) and 18 -8 -401, et. seq., (Abuse of Public Office), CRS 1978 Replacement Vol., and that no violation of such pro- visions is present. Paa• 'L rh,ch n the 1­& d Z paKes 10. The signatories aver that to their knowledge, no state employee has a personal or beneficial interest what- soever in the service or property described herein: BACKGROUND PAPER DATA PROCESSING DEPARTMENT February 8, 1988 ISSUE Should the City Council approve a contract with the State of Colorado Highway Department, Division of Highway Safety concerning centralized traffic data entry? RECOMMENDATION It is recommended that City Council approve the contract. BACKGROUND /ANALYSIS When the computerized record - keeping system was developed in -house for the Pueblo Police Department eight years ago, the decision was made to omit traffic records from the system. That decision was based upon three pertinent facts. First, on -line storage was limited; second, all necessary information was at that time being collected and made available on -line through the Selective Traffic Enforcment Program (STEP) on the CBI computer; and finally, one full -time employee was responsible for data entry into the STEP system, and it was considered an unnecessary duplication of effort to repeat the process for Pueblo's system. In March of 1986, the state sponsored STEP program was decentralized through a system of microcomputers, and traffic information was no longer collected or available through the CBI computer. Since disk storage space was no longer a problem and the need for on -line records and centralized data entry still existed, the traffic records were assimilated into the Pueblo records system. One of the two microcomputers provided by the Division of Highway Safety was placed in the Police Department's Traffic office and the other in the City Traffic Engineer's office, where traffic data pertinent to each operation could be collected and necessary reports generated. Both the Police Department and the Traffic Engineer agree that valuable statistical information is to be had through the micro - computer programs developed by the State of Colorado, however, neither department considers it cost efficient to duplicate the data entry process. The Data Processing Department has offered a centralized data entry solution based on the collection of data through the mainframe and the transferral of that data to the microcomputers. A temporary programmer was hired in June, 1987, to begin work on the solution. Analysis of the system requirements has been completed and program design has begun, however, funding for the programmer ran out December 31, 1987. To complete the process requires the modification of certain programs now running on the mainframe, the development of new mainframe programs, and the development of microcomputer programs to convert the raw data to micro - computer format. 1988 budgeted staffing for the Data Processing Department is not adequate to complete these tasks on a timely basis; the $14,400 Highway Safety Grant will fund the temporary programmer for the remaining eight months of the project. The City's share of the project, $16,977, is included in the 1988 Data Processing budget and will consist of programminq support from two other staff members and necessary operating supplies. CULOHADU Utt'AM I NIMN t wr TRAFFIC SAFETY PROJECT APPLICATION 1. Proposed Activity: Centralized Traffic Data Entry 2. Applicant Agency: City of Pueblo, Data Processing Department. Mailing Address 150 Central Main Street Pueblo, Colorado 81003 3. Policy and Budget Authority: Lewis Quigley, City Manager 4. Proposed Period: (onto) (day) (yr) tmol (day) 31 1 1 88 To 8 31 88 From 5. Signature (see additional certifications on next page): (type name and title) 6. Date Submitted: 12 -15 -87 7. PRELIMINARY APPROVAL (Policy and Budget Authority): Signature: - (type name and ptle) Lewis Quigley, City Manager For: {Agency) City of Pueblo Date: December 15, 1987 NOTE: Refer to Section ll, Colorado Division of Highway Safety Contract Management Manual for instructions in the preparation of this application. n.....e CDOH Forr. OHS -10 r—.va..a...v... w... ..._ _.._ .. -• - rev ✓ v.�.�... ..�.... v...a..✓ vv,.... .v.-.. .... .... 1. AFFIRMATIVE ACTION: (use one of the two following statements) NOTE: If an affirmative action plan is required, but has not been previously approved, it should accompany this application at the time of submission. I certify an affirmative action plan, meeting the requirements of Title VI of the Civil Rights Act of 1964, 78 Stat. 252, (42 U.S.C. 200d -d4) has been approved by and is on file with, the Colorado Department of Highways Equal Employment Opportunity Office. Signature vv (type name and title) Lewis Quigley, City Manager I certify an affirmative action plan, meeting the requirements of Title VI of the Civil Rights Act of 1964, 78 Stat. 252, (42 U.S.C. 2000d -d4) is not required for this agency. Signature (type name and title) 2. PROJECT CONTINUATION: I certify it is intended to continue any highway safety- funded project activities to a point in the future substantially beyond the project expiration date without any material reduction in the level or thrust of the efforts. STRIKE OUT ANY OF THE FOLLOWING NON - APPLICABLE STATEMENTS. ¢ Acxaimipimaaxaaa4tterx> �i�cS�4xhwtlrrteaKOttd {�xDtagx6ols�c�xcitt . Rvtaba6)e)dx1kjvlo xrxmf j d aN Ayaar&OK XXiXMUIXWftUtM 9 *VA)dxfc 4tsct��15����t� xa�Af;ad�fcoa�dK�ca�dx���l4�tvy �>`tx� c��?S�g�dl �Witf�6t�g�►'4J�yKi� ftxxi�sck�AcaiQx roa�exa►a�gcacgesaa>;�C �lax� xDCa IoXV��� �Sg�ty�f �?4 mK ���d��V�i�'+?i4PS r�a�9t�e't �k b�a�d��Dt�c�ci> ntrat> gx�► �Gcttc��Pd����r�tX4 '�x�idf>'kg�tsxy� Signature (type name and title) Lewis Quigley, City Manager DHS -10 r.;uum Corm page 2 VAK 1 H- rnvoL-F- 'J i r I �' -- . (1) Describe the situation. Include data and any other information to establish the existing conditions. (2) State why this situation is undesirable. (3) What are the causes? (4) Identify changes needed to resolve the identified problem(s). When the computerized record - keeping system was developed in -house for the Pueblo Police Department eight years ago, the decision was made to omit traffic records from the system. That decision was based upon three pertinent facts. First, on -line storage was limited and traffic records would require a great deal of disk space. Second, all necessary information was at that time being collected and made available on -line through the STEP/MIS program and to include traffic information in the Pueblo system would be a duplication of records. Finally, one full -time employee was responsible for data entry into the STEP/MIS system, and it was considered an unnecessary duplication of effort to repeat the process for the Pueblo system. In March of 1986, the STEP/MIS program was decentralized through a system of microcomputers, and traffic information was no longer collected or available through the on -line system. Although disk storage space was no longer a problem, the need for on -line records and centralized data entry still existed, and traffic records were assimilated into the Pueblo records system. One of the two Zenith microcomputers provided by the Division of Highway Safety was placed in the Police Department's Traffic office and the other in the City Traffic Engineer's office, where STEP/MIS . information pertinent to each office could be collected and necessary reports generated Unfortunately, funds were not available for the newly acquired data entry functions in the two City departments, and now while traffic records are available through the on -line records system, STEP/MIS information is gathered and reports generated only when manpower is available for data entry in either of the two departments. . Both the Police Department and the Traffic Engineer agree that valuable statistical information is to be had through the STEP/MIS program developed to run under REVELATION software on the Zenith computers, however, neither department considers it cost efficient to duplicate the data entry process on the mainframe and on the microcomputers. The City's Data Processing Department has offered a centralized data entry solution based on the collection of data through the mainfraie- and the transferral of that data to the microcomputers. A prograrm)er who has interned for the Data Processing Department for two years was hired on a temporary basis in June, 1987, to begin work on the solution. Analysis of the system requirements has been completed and program design has begun, however, funding for the programmer will run out December 31, 1987. To complete the process will require the modification of certain programs now running on the mainframe, the development of new mainframe programs focusing on traffic records, and the development of microcomputer programs to convert the raw data to REVELATION format. 1988 budgeted staffing for, the Data Processing Department is not adequate to complete these tasks on a timely basis, and funding of the temporary programmer is needed for the remaining eight months of the protect. cuun rom relic to j GOAL: To centralize the data entry function for the City of Pueblo's traffic incident records and provide for the transfer of necessary data from the mainframe to the microcomputer -based STEP/MIS system. TASKS: State what is to be accomplished and when. 1. Modify existing mainframe programs to separate traffic - related incidents from criminal incidents by March 1, 1988.. 2. Generate new mainframe programs to add, modify, and query traffic - related incidents by May 1, 1988. 3. InLstall, test, and debug completed on -line system by June 1, 1988. 4. Generate, test, and debug data transfer programs by July 1, 1988. 5. Train users, document, and install completed system by September 1, 1988. PART C - CAPITAL EQUIPMEN What equipment, If any, will be purchased to meet the needs of this project? NOTE: Items previously purchased with highway safety funds are not eligible for replacement with highway safety funds. NONE DHS -10 CDOH Form p:. •, ) 4 r- (1) State how success or failure of the project will be determined. Administrative, Performance or Impact measures can be used (See Project Evaluation in Contract Management Manual). Success or failure of the project will be determined by the following administrative criteria: 1. Is the traffic system completely compatible with the current 1 on -line system and the STEP/MIS microcomputer system? 2. Is the system user friendly both from the data entry /retrieval standpoint and from the operational standpoint? 3. Is the system reliable and completely debugged? 4. Are resultant reports correct in both content and format, and do they met the needs of the users? (2) State how the Contract Director will monitor project activity and progress during the contract period. The Contract Director will monitor project activity through the use of weekly status reports and time sheets required of project participants. These reports include progress made during the reporting period, problems encountered, and percent of completion. The forms are part of a standard procedure within the Data Processing Department. CDOH Fc DHS -10 patio 5 r M,A 1 L - uv v - - , PERSONAL SERVICES DHS Use 1 ,., omy HSP Task Number 11/ ..,o. °...... Name or_Position Base Paa, Benefits ($) Monthly Weekly Etc. No. of Mos. Total (S) DHS Share (S) Ager Sha IS _ David Van Dyke 10.00 -0- Hourly 8 114,400 14,400 -C Programmer 2212 500 Monthly 4 1 10,848 -0- 10,84 Jr. Programmer 1900 500 Monthly 2 4,800 -0- 4,8C SUBTOTALS — SALARIES 1 30,048 1 14,400 15,E mmmmwmmmm (2) Overtime HSP Task Number Name Overtime Rate ($) No. of Units Total Cost ($) DHS Share ($) Ager Sha (S SUBTOTALS - OVERTIME (3) Contractual Services HSP Task Number Contractor Dates of Contract Rate ($) No. of Units (Indicate H,D,M,FP) Total Cost ($) DHS Share ($) Age Sha (S) SUBTOTALS - CONTRACTUAL SERVICES DHS Share Agency Sh . TOTAL - PERSONAL SERVICES $ 30 X 048 $ 14,400 15,648 48 Rio 52 pHs -lo pogo 6 PART E - BUDGET (continued) DHS Use Only OPERATING EXPENSES HSP Task Number Description Number of Units Cost per Unit (S) Total Cost (S) DHS Share (S) Agenc Share (S) Computer Paper 10 Cases 28.00 280.00 280.0 Printer Ribbons 2 Each 26.00 52.00 52.0 Backup Tapes - Mainframe 12 Each 16.00 192.00 192.0 Diskettes 100 Each 1.50 150.00 150.0 Removable Hard Disks (pc) 5 75.00 375.00 375.0 Telephone Charges - Long Distance 10 5.00 50.00 50.0 Consultation Fees / Hour 2 65.00 130.00 130. Basic Compiler 1 100.00 100.( DHS Share Agency St TOTAL OPERATING EXPENSE $ 1329.00 -0- 1329.00 -0- % 100 nHS -10 DHS TRAVEL AND SUBSISTENCE Only ly HSP Task Number Description In State (S) Out of State (S) Total (s) OHS Share (S) Age! Sha (S DHS Share Agency S, TOTAL TRAVEL AND SUBSISTENCE $ _p_ $ $ OHS CAPITAL EQUIPMENT Only ly HSP Task Number Description N or R No. of Units Cost per Unit ($) Total ($) DHS Share ($) Age Sha: (S DHS Share Agency S TOTAL CAPITAL EQUIPMENT $ -0- $ $ DHS -10 page 8 PART E - LSUUUt i tconunueu) BUDGETSUMMARY (from pages 6 through 8) DHSSHARE AGENCYSHARE Personal Services $ 14,400 $ 15,648 Operating Expenses $ -0- $ 1,329 Travel and Subsistence $ -0- $ -0- Capital Equipment $ -0- $ -0- SUBTOTALS $ 14,400 $ 16,977 Percent of Total 46 54 PROPOSED PROJECT TOTAL $ 31,377 CDOH For DHS-10 nip. 9 PART F - PROPOSED PROJECT CONTINUAL IUN ANU PLANNED ASSUMPTION OF COSTS 1. PROJECTED FUNDING FY 1989 A. Describe objective, activities, and proposed funding source: The costs associated with this project will be absorbed within the Data Processing Department's budget once the system is installed and debugged. Activities will be limited to program maintenance and system enhancement on an as requested basis. B. PROJECTED BUDGET SUMMARY Personal Services $ Operating Expenses $ Travel and Subsistence $ Capital Outlay $ TOTAL $ 2. PROJECTED FUNDING FY A. Describe objective, activities, and proposed funding source: B. PROJECTED BUDGET SUMMARY Personal Services $ Operating Expenses $ Travel and Subsistence $ Capital Outlay $ TOTAL $ CDOH For; Il141;_ln n,'. I,., 1. CONTRACT DIRECTOR 3. PROJECT COORDINATOR NAME NAME Judy Leach, Director of Data Processing Judy Leach, Director of Data Processing ADDRESS ADDRESS 150 Central Main Street_ 150 Central _Main Street Pueblo, Colorado 81003 Pueblo, Colorado -81003 TELE N TELE NO. 542 -2491 (303) 542 -2491 2. ACCOUNTING RECORDS: 4. MAIL PROJECT PAYMENTS TO: NAME NAME Billy G. Martin, Director of Finance Billy.G. Martin, Director of Finance ADDRESS ADDRESS #1 City Hall Place #1 City Hall Place Pueblo, Colorado 81003 TELE NO. Pueblo, Colorado 81003 TELE NO. ( 303) 543 -1041 (303) 543 -1041 PART H - PROJECT APPROVAL oua Director. Division of Highway Salaly CDOH Form HS-10 Pa9a 11 RESOLUTION NO. A RESOLUTION APPROVING A CONTRACT BETWEEN THE CITY OF PUEBLO, A MUNICIPAL CORPORATION, AND THE COLORADO STATE DEPARTMENT OF HIGHWAYS DIVISION OF HIGHWAY SAFETY CONCERNING CENTRALIZED TRAFFIC DATA AND AUTHORIZING THE PRESIDENT OF THE COUNCIL TO EXECUTE SAME. BE IT RESOLVED BY THE CITY COUNCIL OF PUEBLO, COLORADO, THAT: SECTION 1. The contract between the City of Pueblo, a Municipal Corporation, and the Colorado State Department of Higways, Division of Highway Safety, relating to the acceptance of $14,400 in grant monies is hereby approved. Grant monies will be used to centralize traffic data entry and develop a data base of traffic violations and accidents transferrable to micro- computers. SECTION 2. The City of Pueblo's share of the project, in the amount of $16,977, is available in and is hereby transferred from accounts 001 - 0100 - 109 -0- 010 -0104, 001- 0100 - 109 -0- 020 -0004, 001 -0100- 109 -0- 020 -0008, 001- 0100 - 109 -0 - 020 - 00099 and 001 -0100- 109 - 0 - 030 - 0011. SECTION 3. The President of the to execute this contract for and on Clerk is authorized and directed to the City thereto. City Council is hereby authorized behalf of the City and the City attest same and affix the seal of Introduced MM Councilman . 1988 APPROVED_ President of the Council ATTEST: City Clerk Form 6 AC-02A IR 5IN5I UPI', \H'I \1FN 1 OR AGF•N(•Y NL' \11lLR ('ON tKAI'f H4U fINt1 Nt' \16FR CONTRACT TIIIS CONTRACT, made this day of 198 _ . by and between the State of Colorado for the use and benefit of tite D iiartment of 't Highways, Division of hereinafter referred to as the State. and .2 hereinafter referred to as the contractor, WHEREAS, authority exists in the Law and Fund% have been budgeted, appropriated and otherwise made available and a sufficient unencumbered balance thereof remains available for payment in Fund Number 2001 GIL Account Number 55616 , Contract Encumbrance Number 98923 ; and WHEREAS, required approval, clearance and coordination has been accomplished from and with appropriate agencies; and WHEREAS, the State has received approval and funding for implementation of its FY 1988 Highway Safety Plan (HSP) from the U.S. Department of Transportation, National Highway Traffic Safety Administration and Federal Highway Administration; and WHEREAS, the HSP contains programs and activities designed to reduce traffic crashes or improve the operational efficiency of existing programs; and WHEREAS, the State is responsible for the overall administration of the HSP within the State of Colorado; and WHEREAS, certain programs and activities in the HSP can only be accomplished by other State agencies and local agencies; and WHEREAS, the State determines which agencies would be most appropriate in completing the objectives and conducting the activities and services required by the HSP; and WHEREAS, the Contractor has the technical ability to properly complete the objectives and activities described in Attachment A of this Contract; and WHEREAS, it-has been determined no State agency can reasonably provide the activities and services required of the Contractor; and WHEREAS, this Contract is executed by the State under authority of Sections 43 -5 -401 and 24 -42 -101, C.R.S., as amended, and is executed by the Contractor under authority of Section 29 -1 -203, C.R.S., as amended, and as authorized by the formal resolution attached hereto as Exhibit A. NOW THEREFORE, it is hereby agreed as follows: 1. The Contractor shall carry out the program and conduct all the activities and provide the services described in Attachment A. attached hereto and incorporated herein. 2. The Contractor shall comply with all the administrative procedures and contract requirements contained in the July 1, 1987 Colorado Highway Safety Contract Management Manual issued by the State. Such procedures and requirements are conditions of this contract. The above - referenced document is incorporated herein and made part hereof by reference. By signature on this contract, Contractor acknowledges receipt of this document and is aware of its content. 3. The Contractor shall submit quarterly and final reports to the State according to the reporting criteria set forth in page two of Attachment A. attached hereto and incorporated herein. 395-5:W1.1014 fuse I of 3 pace. • 11••. •v,rrn t•..n. .. , r... r•r..� r.t 1 r.t p'. •.1 4. The budget for this contract is set forth in page 3 of Attachment A attached hereto and incorporated herein. Contractor shall comply with this budget. 5. The maximum total amount of this Contract is $31,377, with the State and Contractor participating as follows: A. State share $14,400 B. Contractor's share $16,977 Total $31,377 The total amount of this Contract shall not be exceeded without the benefit of a supplemental contract executed prior to the performance of additional activities or the incurring of additional costs. 6. The State shall reimburse the Contractor for the accomplishment of this Contract with funds available under the Highway Safety Act, Title 23, U.S.C. Section 402. Such reimbursement shall be only as provided in the July 1, 1987 Colorado Highway Safety Contract Management Manual. 7. The term of this contract shall begin on the effective date and shall terminate on September 30, 1988. The effective date of this contract shall be the date the required signature approval of the State Controller is obtained, as evidenced by the date first appearing above, as filled in by the State Controller. Contractor agrees that any contract work performed prior to the effective date shall not be compensated under the terms of this contract. 8. The contractor agrees any subcontract entered into under this contract must be approved by the Director, Division of Highway Safety, prior to execution. 9. 'The Special Provisions attached hereto are hereby made a part hereof. Page 2 of 3 pages IN WITNESS WHEREOF. the parties hereto have caused the foregoing contract to be executed by their duly authorized officers the day and year first above written. ATTEST Chief Clerk Highway Department ATTEST By Title State Controller By STATE OF COLORADO ROY ROMER. GOVERNOR By A. RAY CHAMBERLAIN EXECUTIVE DIRECTOR DEPARTMENT OF HIGHWAYS JOHN E. CONGER. DIRECTOR DIVISION OF HIGHWAY SAFETY City of Pueblo By Title APPROVALS DUANE WOODARD Attorney General By JAMES A. STROUP BARRY B. RYAN Assistant Attorney General Natural Resources Section Page 3 of 3 pages COLORADO DEPARTMENT OF HIGHWAYS DIVISION OF HIGHWAY SAFETY CONTRACT OBJECTIVE PLAN State Program: Public Ways Contracting Agency: City of Pueblo Data Process. State Sub - Program: Project Coordinator: Highway Safety Judy Leach Problem Solution Plan: Contract Period: 3/1/88 - 9/30/88 Project # J HSP # Task # Objective: Develop system designs and related programs necessary to integrate the STEP /MIS program into the City of Pueblo's Central Computerized Recordkeeping system by September 30, 1988. Task Activity # Activity Description 43- 01.2.1 Modify existing mainframe programs to seperate traffic - related incidents by May 1, 1988. 43- 01.2.2 Generate new mainframe programs to add, modify, and query traffic related incidents by May 1, 1988. 43- 01.2.3 Install, test, and debug completed on -line systems by June 1, 1988. 43- 01.2.4 Generate, test, and debug data transfer programs by July 1, 1988. 43- 01.2.5 Train users, document and install completed system by September 1, 1988. 43- 01.2.6 Provide final report and system demonstration to DHS personnel by September 30, 1988. DHS -23A Previous editions are obsolete and may not be used CDOH Form #1106 6/67 Attachment A , page 1 of 3 COLORADO DEPARTMENT OF HIGHWAYS DIVISION OF HIGHWAY SAFETY CONTRACT EVALUATION DATA Project # HSP# Task # 23-88 1 88 -04 43 -01.2 Task Activity # EVALUATION DESCRIPTION Evaluation Repo Timef ame 43- 01.2.1 Were mainframe programs modified as require it? Performance Quarterly Describe modifications. 43- 01.2.2 Describe programs generated to add, modify Performance Quarterly and query traffic related incidents. 43- 01.2.3 Was on -line system installed in a timely Performance Quarterly manner? 43- 01.2.4 Were data transfer programs generated? Performance Quarterly Describe operation. 43- 01.2.5 Were users trained? How many? What Performance Quarterly agencies? Was completed system installed? 43- 01.2.6 Submit final report including narrative Performance Final description of: • Compatibility of traffic, on -line and STEP /MIS systems. • User friendliness of systems. • Reliability of system • Reports generated • System operation OHS -238 Previous ea,hons are obsolete and may not be used CDOH Form 11107 6/87 Attachment A . page 2 of COLORADO DEPARTMENT OF HIGHWAYS DIVISION OF HIGHWAY SAFETY CONTRACT FINANCIAL BUDGET Total Project a 23 -88 HSP a 88 -04 Personal Services $14,400 Source of Distribution of Task If Total Funds DHS Funds (Benefit of) 1,329 Cost — 100% DHS State Agency Other State Local Capital Equipment — 43-01.2.1 $31,377 $14,400 — $16,977 $14,400 $16,977 $14,400 Totals $31,377 $14,400 $16,977 $14,400 BUDGET ALLOCATION Category DHS Share Agency Share Total DHS % Agency % Personal Services $14,400 $15,648 $30,048 48% 52% Operating Expense — 1,329 1,329 — 100% Travel Expense — — — — — Capital Equipment — — — — — TOTAL BUDGET $14,400 $16,977 $31,377 46% 54% UNS -131. Previous editions ore obsolete and may not be used CDOH Form tr11os 6187 Attachment A . page —2 of 3_ Form 6- AC -02U SPECIAL PROVISIONS CONTROLLER'S APPROVAL I. This contract shall not be deemed valid until it shall have been approved by the Controller of the State of Colorado or such assistant as he may designate. This provision is applicable to any contract involving the pay- ment of money by the State. FUND AVAILABILITY 2. Financial obligations of the State payable after the current fiscal year arc contingent upon funds for that purpose being appropriated, budgeted and otherwise made available. BOND REQUIREMENT 3. If this contract involves the payment of more than fifty thousand dollars for the construction, erection, repair, maintenance, or improvement of any building, road, bridge, viaduct, tunnel, excavation or other public works for this State, the contractor shall, before entering the performance of any such work included in this con- tract, duly execute and deliver to and file with the official whose signature appears below for the Slate, a good and sufficient bond or other acceptable surety to be approved by said official in a penal sum not less than one - half of the total amount payable by the terms of this contract. Such bond shall be duly executed by n qualified corporate surety, conditioned for the due and faithful performance of the contract, and in addition, shall provide that if the contractor or his subcontractors fail to duly pay for any labor, materials, learn hire, sustenance, pro- f visions, provendor or other supplies used or consumed by such contractor or his subcontractor in performance of the work contracted to be done, the surety will pay the same in an amount not exceeding the son specified in the bond, together with interest at the rate of eight per cent per annum. Unless such bond, when so required, is executed, delivered and filed, no claim in favor of the contractor arising larder this contract shall be audited. allowed or paid. A certified or cashier's check or a bank money order payable to the Treasurer of the Slate of Colorado may be accepted in lieu of a bond. This provision is in compliance with 38 -26 -106 CRS, as amended. INDEMNIFICATION 4. To the extent authorized by law, the contractor shall indemnify, save and hold harmless the State, its employees and agents, against any and all claims, damages, liability and court awards including costs, expenses, and attorney fees incurred as a result of any act or omission by the contractor, or its employees, agents, subcon- tractors, or assignees pursuant to the terms of this contract. DISCRIMINATION AND AFFIRbIATIVE ACTION 5. The contractor agrees to comply with the letter and spirit of lltc Colorado Antidiscrimination Act of 1957, as amended, and other applicable law respecting discrimination and unfair employment practices (24 -34 -402. CRS 1982 Replacement Vol.), and as required by Executive Order, Equal Opportunity and Affirmative Action, dated April 16, 1975. Pursuant thereto, the following provisions shall be contained in all State contracts or sub - contracts. During the performance of this contract, the contractor agrees as follows: (I) The contractor will not discriminate against any employee or applicant for employment because of race, creed, color, national origin, sex, marital status, religion, ancestry, mental or physical handicap, or age. The contractor will take affirmative action to insure that applicants are employed, and that employees are treated during employment, without regard to the above mentioned characteristics. Such action shall include, but not be limited to the following: employment, upgrading, demotion, or transfer, recruitment or recruitment advertising; lay -offs or terminations; rates of pay or other forms of compensation; and sclec- tion for training, including apprenticeship. The contractor agrees to post in conspicuous places, available j to employees and applicants for employmifit, notices to be provided by the contracting officer setting forth provisions of this non - discrimination clause. - (2) The contractor will, in all solicitations or advertisements for employees placed by or on behalf of the contractor, state that all qualified applicants will receive consideration for employment without regard to race, creed, color, national origin, sex, marital status, religion, ancestry, mental or physical handicap, or age. (3) The contractor will send to each labor union or representative of workers with which he has collective bargaining agreement or other contract or understanding, notice to be provided by the contracting officer, advising the labor union or workers' representative of the contractor's committmcnt under the Executive Order, Equal Opportunity and Affirmative Action, dated April 16, 1975, and of the rules, regulations, and relevant Orders of the Governor. (4) The contractor and labor unions will furnish all information and reports required by Executive Order, Equal Opportunity and Affirmative Action of April 16, 1975, and by the rules, regulations and Orders of the Governor, or pursuant thereto. and will permit access to his books, records, and accounts by the con - tracting agency and the office of the Governor or his designee for purposes of investigation to ascertain compliance with such rules, regulations and orders. f (5) A labor organization will not exclude any individual otherwise qualified from full membership rights in such labor organization, or expel any such individual from membership in such labor organizatimt or dis- criminate against any of its members in the full enjoyment of work opportunity, because of race, creed, , color, sex, national origin, or ancestry. (6) A labor organization, or the employees or members thereof will not aid, abet, incite, compel or coerce the doing of any act defined in this contract to he discriminatory or obstruct or prevent any person from complying with the provisions of this contract or any order issued thereunder, or attempt, either directly or indirectly, to commit any act defined in this contract to be discriminatory. ii, i 395 -53 -01 -1022 Revised 11 -35 Page —1— of _ Z_ pages Form 6- AC -02C 'i .i i' (7) In (tic event of dhc contractor's non -comp %rice with c a non- discrimination clauses of this con- tract or with any of such rules. regulations, or orders, this contract may be cancelled, terminated or sus- pended in whole or in part and the contractor may be declared ineligible for further State contracts in accordance with procedures, authorized in Executive Order, Equal Opportunity and Affirmative Action of April 16, 1975 and the rules, regulations, or orders promulgated in accordance therewith, and such outer sanctions as may be imposed and remedies as may be invoked as provided in Executive Order, Equal Opportunity and Affirmative Action of April 16, 1975, or by rules, regulations, or orders promulgated in accordance therewith, or as otherwise provided by law, (8) The contractor will include the provisions of paragraph( 1) through (8) in every sub - contract and subcontractor purchase order unless exempted by rules, regulations, or orders issued pursuant to Executive Order, Equal Opportunity and Affirmative Action of April 16, 1975, so that such provisions will be binding upon each subcontractor or vendor. The contractor will take such action with respect to any sub - contracting or purchase order as the contracting agency may direct, as a means of enforcing such provisions, including sanctions for non - compliance; provided, however, that in the event the con- tractor becomes involved in, or is threatened with, litigation with the subcontractor or vendor as a result of such direction by the contracting agency, the contractor may request the State of Colorado to enter into such litigation to protect the interest of the State of Colorado. COLORADO LABOR PREFERENCE ' 6a. Provisions of 8 -17 -101 & 102, CRS for preference of Colorado labor are applicable to this contract ifpublic works within the State are undertaken hereunder and are financed in whole or in part by State funds. b. When a construction contract for a public project is to be awarded to a bidder, a resident bidder shall be allowed a preference against a non - resident bidder from a state or foreign country equal to the preference given or required by the state or foreign country in which the non - resident bidder is a resident. If it is determined by the officer responsible for awarding the bid that compliance with this subsection .06 may cause denial of federal funds which would otherwise be available or would otherwise be inconsistent with requirements of federal law, this sub- section shall be suspended, but only to the extend necessary to prevent denial of the moneys or to eliminate the inconsistency with federal requirements (section 8 -19 -101 and 102, CRS). GENERAL 7. The laws of the State of Colorado and rules and regulations issued pursuant thereto shall be applied in the interpretation, execution and enforcement of this contract. Any provision of this contract whether or not incor- porated herein by reference which provides for arbitration by any extra - judicial body or person or which is other- wise in conflict with said laws, rules and regulations shall be considered null and void. Nothing contained in any provision incorporated herein by reference which purports to negate this or any other special provision in whole or in part shall be valid or enforceable or available in any action at law whether by way of complaint, defense or other- wise. Any provision rendered null and void by the operation of this provision will not invalidate the remainder of this contract to the extent that the contract is capable of execution. 8. At all times during the performance of this Contract, the Contractor shall strictly adhere to all applicable federal and state laws, rules and regulations that have been or may hereafter be established. 9. The signatories hereto aver that they are familiar with 18 -8 -301, et. seq., (Bribery and Corrupt Influences) and 18 -8 -401, et. seq., (Abuse of Public Office), CRS 1978 Replacement Vol., and that no violation of such pro- visions is present. 10. The signatories aver that to their knowledge, no state employee has a personal or beneficial interest what- soever in the service or property described herein: NESS WHEREOF, the parties hereto have executed this Contract on the day first above [(5Fu]1Lcga c) STATE: O F COLORADO RICHARD D. LAMM, GO ZNOR By •5 EXECU1111C UIRECTOR. Position (Title) DEPAR' 'NT 5u 1 S,curny Nu 4, ,u Fcdpal 1.0. N—N, OF - (If Corporation:) Attest (Seal) B ('npware Secnury. w F:Vm. alen,. r„.d' X'­' 0"k APPROVALS ATTORNEY RAL CONTROLLER By— By 1 . Pap 2 •aKa n w rau N 2 Daaca D vh1 B 9 - 9 5 - SUPPLEMENTAL CONTRACT THIS SUPPLEMENTAL CONTRACT, made this 1.574 day of OGlo6s.,— 1988, by and between the State of Colorado for the use and benefit of the Department of Highways, Division of Highway Safety hereinafter referred to as the State, and the City of Pueblo for the use and benefit of the Data Processing Department hereinafter referred to as the contractor. WHEREAS, authority exists in the Law and Funds have been budgeted, appropriated and otherwise made available and a sufficient unencumbered balance thereof remains available for payment in Fund Number 2001, G/L Account Number 55616, Contract Encumbrance Number 98923; and WHEREAS, required approval, clearance and coordination has been accomplished from and with appropriate agencies; and WHEREAS, the State and Contractor entered into a contract dated March 1, 1988 hereinafter referred to as the basic contract; and WHEREAS, the State is desirous of continuing implementation of its FY 1988 Highway Safety Plan (HSP); and WHEREAS, the Contractor has available the technical ability to properly complete the objectives stated; and WHEREAS, the Contractor is not able to complete contract performance by the scheduled September 30, 1988 termination date of the original contract; and WHEREAS, the parties agree that this lack of timely performance did not materially breach the contract, and that performance can be completed if the original contract is extended to December 31, 1988 at no additional cost; and WHEREAS, the parties have the authority to extend the original contract term; and WHEREAS, the parties hereto desire to amend the basic contract in relation to time of completion. NOW, THEREFORE, it is agreed that: A. The basic contract, unless specifically revised or amended herein, shall be and remain in full force and effect with respect to the contractual relationship between the parties hereto. B. The parties do hereby ratify and confirm all actions which have taken place prior to the date this supplemental contract has been executed and which are in accordance with the terms hereof. C. The effective date of this supplemental contract shall be the date the required signature approval of the State Controller is obtained as evidenced by the date first appearing above, as filled in by the Controller. D. Paragraph 7 of the basic contract shall be amended by deleting the phrase "September 30, 1988" and substituting therefore the phrase "December 31, 1988. E. The Special Provisions (Revised 3/86) attached hereto are hereby made a part of this supplemental contract and all subsequent supplements unless modified by a supplemental contract. IN WITNESS WHEREOF, the parties hereto have caused the foregoing contract to be executed by their duly authorized officers the day and year first above written. ATTEST STATE OF COLORADO ROY RC I ER, GOVERNOR B Chief C * CHAMBEIRLAIN Highway Department EXEdUtIVE DIRECTOR DEPA TMENT OF IGHWAYS Y J O GE RECTOR IVISION OF HIGHW SAFETY ATTEST By City of Pueblo Title &.i; & By �. APPROVALS DUANE WOODARD Attorney General State Controller By BY 6" i�� JAMES E. STROUP BARV B. RY N Assistant Mttorney General JAMTES A. STROUP Natural Resources Section Page 2 of 2 pages Form 6- AC -02B SPECIAL PROVISIONS CONTROLLER'S APPROVAL 1. This contract shall not be deemed valid until it shall have been approved by the Controller of the State of Colorado or such assistant as he may designate. This provision is applicable to any contract involving the pay- ment of money by the State. FUND AVAILABILITY 2. Financial obligations of the State payable after the current fiscal year are contingent upon funds for that purpose being appropriated, budgeted and otherwise made available. BOND REQUIREMENT 3. If this contract involves the payment of more than fifty thousand dollars for the construction, erection, repair, maintenance, or improvement of any building, road, bridge, viaduct, tunnel, excavation or other public works for this State, the contractor shall, before entering the performance of any such work included in this con- tract, duly execute and deliver to and file with the official whose signature appears below for the State, a good and sufficient bond or other acceptable surety to be approved by said official in a penal sum not less than one- half of the total amount payable by the terms of this contract. Such bond shall be duly executed by a qualified corporate surety, conditioned for the due and faithful performance of the contract, and in addition, shall provide that if the contractor or his subcontractors fail to duly pay for any labor, materials, team hire, sustenance, pro- visions, provendor or other supplies used or consumed by such contractor or his subcontractor in performance of the work contracted to be done, the surety will pay the same in an amount not exceeding the sum specified in the bond, together with interest at the rate of eight per cent per annum. Unless such bond, when so required, is executed, delivered and filed, no claim in favor of the contractor arising under this contract shall be audited, allowed or paid. A certified or cashier's check or a bank money order payable to the Treasurer of the State of Colorado may be accepted in lieu of a bond. This provision is in compliance with 38 -26 -106 CRS, as amended. INDEMNIFICATION 4. To the extent authorized by law, the contractor shall indemnify, save and hold harmless the State, its employees and agents, against any and all claims, damages, liability and court awards including costs, expenses, and attorney fees incurred as a result of any act or omission by the contractor, or its employees, agents, subcon- tractors, or assignees pursuant to the terms of this contract. DISCRIMINATION AND AFFIRMATIVE ACTION 5. The contractor agrees to comply with the letter and spirit of the Colorado Antidiscrimination Act of 195 7, as amended, and other applicable law respecting discrimination and unfair employment practices (24 -34 -402. CRS 1982 Replacement Vol.), and as required by Executive Order, Equal Opportunity and Affirmative Action, dated April 16, 1975. Pursuant thereto, the following provisions shall be contained in all State contracts or sub - contracts. During the performance of this contract, the contractor agrees as follows: (1) The contractor will not discriminate against any employee or applicant for employment because of race, creed, color, national origin, sex, marital status, religion, ancestry, mental or physical handicap, or age. The contractor will take affirmative action to insure that applicants are employed, and that employees are treated during employment, without regard to the above mentioned characteristics. Such action shall include, but not be limited to the following: employment, upgrading, demotion, or transfer, recruitment or recruitment advertising; lay -offs or terminations; rates of pay or other forms of compensation; and selec- tion for training, including apprenticeship. The contractor agrees to post in conspicuous places, available to employees and applicants for employment, notices to be provided by the contracting officer setting forth provisions of this non - discrimination clause. (2) The contractor will, in all solicitations or advertisements for employees placed by or on behalf of the contractor, state that all qualified applicants will receive consideration for employment without regard to race, creed, color, national origin, sex, marital status, religion, ancestry, mental or physical handicap, or age. (3) The contractor will send to each labor union or representative of workers with which he has collective bargaining agreement or other contract or understanding, notice to be provided by the contracting officer, advising the labor union or workers' representative of the contractor's committment under the Executive Order, Equal Opportunity and Affirmative Action, dated April 16, 1975, and of the rules, regulations, and relevant Orders of the Governor. (4) The contractor and labor unions will furnish all information and reports required by Executive Order, Equal Opportunity and Affirmative Action of April 16, 1975, and by the rules, regulations and Orders of the Governor, or pursuant thereto, and will permit access to his books, records, and accounts by the con- tracting agency and the office of the Governor or his designee for purposes of investigation to ascertain compliance with such rules, regulations and orders. (5) A labor organization will not exclude any individual otherwise qualified from full membership rights in such labor organization, or expel any such individual from membership in such labor organization or dis- criminate against any of its members in the full enjoyment of work opportunity, because of race, creed, color, sex, national origin, or ancestry. (6) A labor organization, or the employees or members thereof will not aid, abet, incite, compel or coerce the doing of any act defined in this contract to be discriminatory or obstruct or prevent any person from complying with the provisions of this contract or any order issued thereunder; or attempt, either directly or indirectly, to commit any act defined in this contract to be discriminatory. 395 -53 -01 -1022 page of pages Revised 11 -85 Form 6- AC -02C (7) In the event of the contractor's non - compliance with the non - discrimination clauses of this con- tract or with any of such rules, regulations, or orders, this contract may be cancelled, terminated or sus- pended in whole or in part and the contractor may be declared ineligible for further State contracts in accordance with procedures, authorized in Executive Order, Equal Opportunity and Affirmative Action of April 16, 1975 and the rules, regulations, or orders promulgated in accordance therewith, and such other sanctions as may be imposed and remedies as may be invoked as provided in Executive Order, Equal Opportunity and Affirmative Action of April 16, 1975, or by rules, regulations, or orders promulgated in accordance therewith, or as otherwise provided by law. (8) The contractor will include the provisions of paragraph (1) through (8) in every sub - contract and subcontractor purchase order unless exempted by rules, regulations, or orders issued pursuant to Executive Order, Equal Opportunity and Affirmative Action of April 16, 1975, so that such provisions will be binding upon each subcontractor or vendor. The contractor will take such action with respect to any sub - contracting or purchase order as the contracting agency may direct, as a means of enforcing such provisions, including sanctions for non - compliance; provided, however, that in the event the con- tractor becomes involved in, or is threatened with, litigation with the subcontractor or vendor as a result of such direction by the contracting agency, the contractor may request the State of Colorado to enter into such litigation to protect the interest of the State of Colorado. COLORADO LABOR PREFERENCE 6 a. Provisions of 8 -17 -101 & 102, CRS for preference of Colorado labor are applicable to this contract if public works within the State are undertaken hereunder and are financed in whole or in part by State funds. b. When a construction contract for a public project is to be awarded to a bidder, a resident bidder shall be allowed a preference against a non - resident bidder from a state or foreign country equal to the preference given or required by the state or foreign country in which the non - resident bidder is a resident. If it is determined by the officer responsible for awarding the bid that compliance with this subsection .06 may cause denial of federal funds which would otherwise be available or would otherwise be inconsistent with requirements of federal law, this sub- section shall be suspended, but only to the extent necessary to prevent denial of the moneys or to eliminate the inconsistency with federal requirements (section 8 -19 -101 and 102, CRS). GENERAL 7. The laws of the State of Colorado and rules and regulations issued pursuant thereto shall be applied in the interpretation, execution and enforcement of this contract. Any provision of this contract whether or not incor- porated herein by reference which provides for arbitration by any extra judicial body or person or which is other- wise in conflict with said laws, rules and regulations shall be considered null and void. Nothing contained in any provision incorporated herein by reference which purports to negate this or any other special provision in whole or in part shall be valid or enforceable or available in any action at law whether by way of complaint, defense or other- wise. Any provision rendered null and void by the operation of this provision will not invalidate the remainder of this contract to the extent that the contract is capable of execution. 8. At all times during the performance of this Contract, the Contractor shall strictly adhere to all applicable federal and state laws, rules and regulations that have been or may hereafter be established. 9. The signatories hereto aver that they are familiar with 18 -8 -301, et. seq., (Bribery and Corrupt Influences) and 18 -8 -401, et. seq., (Abuse of Public Office), CRS 1978 Replacement Vol., and that no violation of such pro- visions is present. 10. The signatories aver that to their knowledge, no state employee has a personal or beneficial interest what- soever in the service or property described herein: WITNESS WHEREOF, the parties hereto have executed this Contract on the day first abo writ Contract (Full Legal STATE OF COLORADO ROY ROMER, GOVER By *5 EXECUTIVE DIRECTO Position (Title) DEP ENT Social Security Number or Federal I.D. Number O (If Corporation:) Attest (Seal) By<< Corporate Secretary. or Equivalent, To y /County Clerk APPROVALS ATTORNEY RAL CONTROLLER By By Page which is the last of pages 395 -53 -01 -1030 (Revised 3/86) *See instructions on reverse side. DC -10- 2494 -86