Spreadsheet: 697281d1601296756-if-and-and-formula-using-a-table-test-procurement
Sheet: BalanceScoreCard

Supplier Excellence Scorecard
 |  |  |  |  |  |  |  |  | Calculation Sheet
Supplier |  |  |  | Total Points Earned |  | Overall Score
Scorecard Date |  |  |  | 0.99 |  |  |  |  |  |  |  |  |  | Want to automatically state the overall weighting grade LETTER from Table below (column G-H , Row 42-47) , based on the the total points earned in( column E F Rows 5-12 )shows the % in Box G-H
Region/ Area
Reviewed By
[NAME]
Category 1: Supplier Capability Performance |  |  |  |  |  |  |  |  | 1 | 0.8 | 0.5 | 0.3 | 0
Item | Description | Weight % | A | B | C | D | E | Your Score | A | B | C | D | E
Area of Experties | Power, Gas, Water & Telecoms | 0.1 | All Four Areas  (P,G W & T) | Three Areas | Two Areas | One Area | NONE | a
No of delivered projects | Successful delivered projects | 0.05 | More than 50 + | Between 30- 49 Projects | Between 29- 15 projects | Between 5- 14 Projects | Less than 5 Projects | a
No of Employees | No of Employees acorss different utilities | 0.05 | Enough Capabilites for all areas | Enough Capabilites for 3 areas | Enough Capabilites for 2 areas | Enough Capabilites for 1 areas | Use Subscontractors | a
Design Capailities | In house Design teams | 0.05 | 100% Design Capabilityes | 75% Design Capabilities | 50% Design Capabilities | 25% Design Capabilities | No Design Capabilities | a
Accrediations | GIRS, WIRS & NERS | 0.05 | ALL 3 Accrediations | 2 Accrediations | 1 Accrediation | Need / Can apply for Accrediation | NONE | a
Health & Saftey | Current Health and Safety methods | 0.05 | 100% match Match with BB H&S Procedures *Excellent records | 75% match [NAME] with BB H&S Procedures *Good Records | 50% match Match with BB H&S Procedures *Average | 100% match Match with BB H&S Procedures *Fair | 100% match Match with BB H&S Procedures *Poor / Bad | a
Total % Available in this Category |  |  | Total % Supplier Earned in this Category
Category 2: Supplier Price Performance |  |  |  |  |  |  |  |  | 1 | 0.8 | 0.5 | 0.3 | 0
Item | Description | Weight % | A | B | C | D | F | Your Score | A | B | C | D | E
Pricing | Supplier price relative to competitors | 0.15 | 10%+ Below average |  | Average |  | 10%+Above Average | a
Discounts | Does supplier provide bundling discounts? | 0.1 | 6%+ Discount | 5% Discount | 2% Discount | 1% Discount | No Discount | a
[NAME] Around | How quickly does supplier return RFQs? | 0.05 | On time | 1-2 Days Late | 3-5 days late | 5-7 days late | 7-14 days late | a
Clarity of Quotes | Are quotes clear and easy to understand? | 0.05 | 100% clear | 75% clear | 50% Clear | 25% Clear | Not Clear | a
Quote Validity Time | How long are quotations valid? | 0.05 | 6months | 5 months | 4 months | 3months | 2months | a
Total % Available in this Category |  |  | Total % Supplier Earned in this Category
Category 3: Supplier Commercial Performance |  |  |  |  |  |  |  |  | 1 | 0.8 | 0.5 | 0.3 | 0
Item | Description | Weight % | A | B | C | D | F | Your Score | A | B | C | D | E
Framework agreed rates used | Agree a framework agreed rates for fixed duration . i.e 18- 24 months | 0.1 | YES 100% agreed Price | YES 75% agreed Price | YES 50% agreed Price | YES 25% agreed Price | NO | a
Prefered contract method | Option A, E/ C etc… | 0.05 | Option A |  |  |  | Option C/E | a
Agreed Payment schedule & Delay damages | Payment Schedule & delay damages-  Time and Cost agreed | 0.03 | Agreed DD -Cover all liabilities | Agreed DD -Cover 75% liabilities | Agreed DD -Cover 50% liabilities | Agreed DD -Cover 25% liabilities | NONE | a
Supplier Liability duration | Supplier total liability Duration to the Client for all matters arising or in connection with the contract | 0.05 | 5 years Cover | 4 years Cover | 3 years Cover | 2 years Cover | 1=<1 years Cover | a
Insurances | Based on the value of the project the supliers insurance cover. | 0.02 | Available insurance |  |  |  | NONE | a
Total % Available in this Category |  |  | Total % Supplier Earned in this Category
 |  |  | Score Weighting |  |  | Overall [NAME]
 |  |  | A | 1 |  | 0-50% | E
 |  |  | B | 0.8 |  | 51-60% | D
 |  |  | C | 0.5 |  | 61-70% | C
 |  |  | D | 0.3 |  | 71-89% | B
 |  |  | E | 0 |  | 90% and above | A