| How to Complete the Consensus Evaluation Spreadsheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| This spreadsheet is designed to assist the evaluation panel's facilitator to input panel member's consensus scores for each Respondent |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Once the consensus scores have been agreed to, input these into the worksheet named Data Entry. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The workbook has been designed to extract and link information between each worksheet and to minimise duplication and repetitive actions (such as entering Respondent |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| names, Qualitative Requirements etc). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| As much of the information is driven from source cells in the Data Entry worksheet it is requested that cell data in the Score, Price and Ranking Table worksheet is not |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| altered as this may inadvertantly affect some of the linked information. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| By way of explanation on use of the spreadsheet: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1. Insert in the Data Entry worksheet the Qualitative Requirements and the Weighted % for each Requirement. This will also populate the Score, Price and Ranking Table |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| worksheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2. Insert in the Data Entry worksheet the Respondent's Legal Entity Name (also populates the Score, Price and Ranking Table worksheet) and complete the Compliance |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| and Disclosure Requirements as applicable (May not be required if Compliance and Disclosure Requirements completed in an Evaluation Handbook). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 3. Insert the evaluation panel's consensus score in the Data Entry worksheet for each Respondent (also populates the Score, Price and Ranking Table worksheet). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The weighted scores, total percentage scores and rankings will be automatically calculated in the Score, Price and Ranking Table worksheet. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4. Insert the Price, total cost of Imported Content (if applicable) and any Regional Price Preference (if applicable) in the Data Entry worksheet for each Respondent. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The Price with any Imported Content and/or Regional Price Preference costs will be automatically calculated in the Score, Price and Ranking Table worksheet to give |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| a Total Price and ranking for each Respondent. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 5. The Summary of Qualitative Scores and Evaluation Pricing table in the Score, Price and Ranking Table worksheet can be sorted by using the filter buttons. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 6. If the Request has more than one (1) category of products or services that needs to be evaluated, please utilise a separate spreadsheet for each category. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Please enter the Qualitative Requirements and Respondent's details before entering the scores. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Finance v 200616 |
Compliance (may not be required if a Evaluation Handbook is being used), Evaluation and Price Data Entry Worksheet
Follow the data entry instructions as required |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Request Number and Title: |
Enter Request Number and Title
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Respondent's Name |
Enter Respondent Name
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Qualitative Requirements |
Weighting |
Consensus Score |
Comments on Qualitative Requirements |
Consensus Score |
Comments on Qualitative Requirements |
Consensus Score |
Comments on Qualitative Requirements |
Consensus Score |
Comments on Qualitative Requirements |
Consensus Score |
Comments on Qualitative Requirements |
Consensus Score |
Comments on Qualitative Requirements |
Consensus Score |
Comments on Qualitative Requirements |
Consensus Score |
Comments on Qualitative Requirements |
Consensus Score |
Comments on Qualitative Requirements |
Consensus Score |
Comments on Qualitative Requirements |
Consensus Score |
Comments on Qualitative Requirements |
Consensus Score |
Comments on Qualitative Requirements |
Consensus Score |
Comments on Qualitative Requirements |
Consensus Score |
Comments on Qualitative Requirements |
Consensus Score |
Comments on Qualitative Requirements |
Enter Qualitative Requirements from Request
|
Enter Weightings from Request
|
Enter the consensus score for the qualitative requirement
|
Enter comments for the qualitative requirement, as required
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Price (inc GST) |
Enter the price from the Respondent's bid
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Cost of Imported Content
(20% of the Total Imported Content Cost is added to the Respondent's Price for evaluation purposes) |
If applicable, enter the total cost of the import content from the Respondent's bid
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Regional Business Offer Price OR Total Cost of Regional Content
(10% of the regional business offer price OR 10% of the total cost of regional content will be used to reduce the Respondent's Price for evaluation purposes) |
If applicable, enter the regional business offer price OR the total cost of regional content from the Respondent's bid
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Respondent details
|
Select Yes, No or N/A from the drop down list against each of the questions below
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Has the Respondent provided sufficient details regarding its identity? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Unless operation of the Procurement (Debarment of Suppliers) Regulations 2021 has been excluded, the Contract Authority or Customer must exclude from consideration any Offer received from a Respondent who is suspended or debarred, and any Offer which includes a subcontracting arrangement with a suspended or debarred subcontractor. Refer to the Western Australian Supplier Debarment Regime and the Excluded Suppliers page on Tenders WA for more information.
Ensure that you check the suspension and debarment status of all Respondents and named subcontractors on the Excluded Suppliers page before progressing to the Qualitative Assessment, finalising the Evaluation Report and prior to awarding the contract.
Is the Respondent a debarred or suspended supplier within the meaning of the Procurement (Debarment of Suppliers) Regulations 2021? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pre-Qualification Requirements [Delete if not applicable]
|
Select Yes, No or N/A from the drop down list against each of the questions below
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Does the Respondent meet the pre-qualification requirements? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| [State pre-qualification requirement] |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Compliance Requirements |
Select Yes, No or N/A from the drop down list against each of the questions below
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(i) Head Agreement Details
Does the Respondent agree to the Customer Contract? [Delete if not applicable] |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(ii) Customer Contract Details
Does the Respondent agree to the Customer Contract? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(iii) General Conditions and Schedules
Does the Respondent agree to the General Conditions and
Schedules? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| (iv) COVID-19 Coronavirus: Mandatory Vaccination [Delete if not applicable] |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| (v) Aboriginal Procurement Policy - Aboriginal Participation Requirements [Delete if not applicable.] |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| If yes, which Aboriginal participation requirement does the Respondent agree to comply with? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Disclosure Requirements |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(i) Participants (including subcontractors)
Is the Respondent acting as an agent or trustee for another person
or persons? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Is the Respondent acting jointly or in association with another
person or persons? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Has or does the Respondent intend to engage a subcontractor? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
If yes, does the Respondent’s Offer name a subcontractor that is a
debarred or suspended supplier within the meaning of the
Procurement (Debarment of Suppliers) Regulations 2021? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
If yes, has the Respondent warranted that they have obtained consent
from each subcontractor permitting them to receive information about
whether the subcontractor is suspended or debarred? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(ii) Criminal Conviction
Does the Respondent, or any of the Respondent's senior officers, or
any person nominated as Specified Personnel have a Criminal
Conviction? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(iii) Conflict of Interest
Does the Respondent have any actual, potential or perceived
Conflict of Interest? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(iv) Small Business, Australian Disability Enterprise
(ADE) and/or Aboriginal Business
(A) Is the Respondent a small business? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| (B) Is the Respondent a registered ADE? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| (C) Is the Respondent a registered Aboriginal Business? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(v) Credit Card/Purchasing Card Payment [Delete if not applicable]
Does the Respondent agree to receive credit card/purchasing
card payments? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(vi) Software Licence Agreements [Delete if not applicable]
Does the Respondent consent? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(vii) Competitive Neutrality [Delete if not applicable]
Has the Respondent included certification as required? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(viii) Professional Standards Scheme [Delete if not applicable]
Is the Respondent a member of an occupational association
for which a scheme has been approved? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Insurance Requirements |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Does the Respondent have the required insurances requested? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Public Liability [Include $ amount or Delete if not applicable] |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Public and Product Liability [Include $ amount or Delete if not applicable] |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Workers Compensation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Professional Indemnity [Include $ amount or Delete if not applicable] |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Was a Certificate of Currency Provided? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Will the Respondent obtain the required insurances prior to being awarded a contract? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago
