Spreadsheet: 86937d1286892319-lookup-table-and-if-statement-contractor-evaluation-22sept10
Sheet: Evaluation

 | Contractor Performance Evaluation
CONTRACTOR:
PROJECT:
CONTRACT No.:
AWARD VALUE: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Score | Sub-weight sw | Sub-prod score * sw
COMMENCEMENT/COMPLETION DATES: |  |  |  |  |  | U | I | ME | EE | EX | N/A
A. | SAFETY STANDARDS AND REGULATIONS |  |  |  | sub-score | 1.333333333333333 |  |  | Weight |  | 0.2608695652173913
1 | Did the contractor comply with OHSA requirements? |  |  |  |  | ü |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 1 | 0.5 | 0.5
2 | Did the contractor meet the environmental and safety regulatory requirements of the contract? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.3333333333333333 | 0.3333333333333333
3 | Did the contractor take adequate precautions with any hazardous and materials and designated substances? |  |  |  |  |  |  | ü |  |  |  |  |  |  |  |  | 3 | 0.1666666666666667 | 0.5
B. | QUALITY OF WORK AND COMPLIANCE WITH STANDARDS AND SPECIFICATIONS |  |  |  | sub-score | 1.8 |  |  | Weight |  | 0.2173913043478261
1 | Did the contractor comply with standards and specifications in the contract? |  |  |  |  |  | ü |  |  |  |  |  |  |  |  |  | 2 | 0.3 | 0.6
2 | Were the material quality and workmanship in compliance with the contract documents? |  |  |  |  |  | ü |  |  |  |  |  |  |  |  |  | 2 | 0.3 | 0.6
3 | Did the contractor demonstrate the importance of delivering high-quality services and products? |  |  |  |  |  | ü |  |  |  |  |  |  |  |  |  | 2 | 0.2 | 0.4
4 | Did the contractor promptly correct defective work as the project progressed? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.2 | 0.2
C. | TEAMWORK AND SERVICE FOCUS |  |  |  | sub-score | 1 |  |  | Weight |  | 0.04347826086956522
1 | Did the contractor communicate with the contract administrator in accordance with the contract documents? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.3333333333333333 | 0.3333333333333333
2 | Was the contractor cooperative with the City and contract administrator? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.3333333333333333 | 0.3333333333333333
3 | Did the contractor collaborte and work in partnership with the project team? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.3333333333333333 | 0.3333333333333333
D. | ORGANIZATION AND MANAGEMENT |  |  |  | sub-score | 1.52 |  |  | Weight |  | 0.1304347826086956
1 | Did the contractor submit a satisfactory baseline schedule? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.1 | 0.1
2 | Did the contractor commence the work on time? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.06 | 0.06
3 | Did the contractor submit schedule updates in accordance with the contract? |  |  |  |  |  |  | ü |  |  |  |  |  |  |  |  | 3 | 0.02 | 0.06
4 | Did the contractor adequately staff and resource the project? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.18 | 0.18
5 | Did the contractor provide adequate site supervision? |  |  |  |  |  |  | ü |  |  |  |  |  |  |  |  | 3 | 0.16 | 0.48
6 | Did the contractor effectively coordinate and manage the work of its subcontractors? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.18 | 0.18
7 | Did a person with decision-making authority represent the contractor at pay/progress meetings? |  |  |  |  |  |  | ü |  |  |  |  |  |  |  |  | 3 | 0.02 | 0.06
8 | Did the contractor submit timely RFI's as needed? |  |  |  |  |  | ü |  |  |  |  |  |  |  |  |  | 2 | 0.12 | 0.24
9 | Were shop drawings submitted according to shop drawing schedule and in compliance with the contract? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.16 | 0.16
E. | WORK PERFORMANCE |  |  |  | sub-score | 1.307692307692307 |  |  | Weight |  | 0.2173913043478261
1 | Did the contractor follow the approved schedule? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.02787068004459308 | 0.02787068004459308
2 | Did the contractor provide effective quality assurance and quality control? |  |  |  |  |  | ü |  |  |  |  |  |  |  |  |  | 2 | 0.0334448160535117 | 0.06688963210702341
3 | Did the contractor keep the site clean and free of trash and debris? |  |  |  |  |  |  |  |  | ü |  |  |  |  |  |  | 5 | 0.005574136008918617 | 0.02787068004459308
4 | Did the contractor comply with change orders, change directives, site instructions, and RFQs? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.03901895206243032 | 0.03901895206243032
5 | Did the contractor have authorization to perform additional work? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.005574136008918617 | 0.005574136008918617
6 | Did the contractor adequately address disputes and claims with subcontractors and third parties? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.03901895206243032 | 0.03901895206243032
7 | Did the contractor address City requests promptly and effectively? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.01114827201783723 | 0.01114827201783723
8 | Was the quality and submission timelines of the following items acceptable? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n/a
9 | ● | two week look ahead schedule |  |  |  |  | ü |  |  |  |  |  |  |  |  |  | 2 | 0.01114827201783723 | 0.02229654403567447
10 | ● | accurate and complete record documents (as-builts) |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.01114827201783723 | 0.01114827201783723
11 | ● | Complete operations and maintenance manuals and closeout documents |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.01114827201783723 | 0.01114827201783723
12 | ● | Startup testing and commissioning reports |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.01114827201783723 | 0.01114827201783723
13 | ● | Training plan and manuals |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.01114827201783723 | 0.01114827201783723
F. | CONTRACTOR PERFORMANCE AND DILIGENCE |  |  |  | sub-score | 1.71875 |  |  | Weight |  | 0.1304347826086956
1 | Did the contractor actively work to respond to project problems in a timely fashion. |  |  |  |  |  | ü |  |  |  |  |  |  |  |  |  | 2 | 0.09375 | 0.1875
2 | Did the contractor suggest solutions to project problems and display initiative to implement solutions? |  |  |  |  |  |  | ü |  |  |  |  |  |  |  |  | 3 | 0.125 | 0.375
3 | Did the contractor demonstrate accountability for problems for which they where responsible? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.1875 | 0.1875
4 | Did the contractor submit accurate, complete invoices? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.03125 | 0.03125
5 | Did the contractor provide competitive change order pricing? |  |  |  |  |  | ü |  |  |  |  |  |  |  |  |  | 2 | 0.1875 | 0.375
6 | Did the contractor accept financial responsibility for the scope and extents of the contract? |  |  |  |  |  | ü |  |  |  |  |  |  |  |  |  | 2 | 0.1875 | 0.375
7 | Did the contractor coordinate to minimize disruption of  operations with the City and customers? |  |  |  |  | ü |  |  |  |  |  |  |  |  |  |  | 1 | 0.1875 | 0.1875
 |  |  |  |  | Total Score | 1.489335284280936
 |  | Name |  | Signature |  | Date
Project Manager:
Manager:
Director:
 | version 1.0 - 22/09/10