Understanding Scorecard Summary
The tables in this topic contain the summary information for the KPIs that make up the Supplier Rating – Buyer and Supplier Scorecards. In addition to the KPI description and related critical success factor, these summary tables include the dimension or object type, perspective, and KPI calculation definition.
Reduce Purchasing Cost KPIs
This table contains the summary information for KPIs for which critical success factor is Reduce Purchasing Cost.
|
KPI Name |
Dimension (Object Type) |
Perspective |
KPI Calculation |
|---|---|---|---|
|
% Freight ($) |
Supplier |
Internal |
The % of freight value associated with a purchase order (PO) last period. |
|
% Ordered ($) Under Contract |
Supplier |
Internal |
The % of value of units ordered on a PO for which a contract exists last period. |
|
% Change in Average PO Price |
Supplier |
Internal |
The % difference in the average PO price between this period and last period. |
|
Average PO Price Variance |
Supplier |
Internal |
The difference between average PO price between this period and last period. |
|
Freight ($) |
Supplier |
Internal |
The freight value associated with a PO. |
|
Ordered ($) |
Supplier |
Internal |
The value of units ordered on a PO. |
|
Ordered ($) Under Contract |
Supplier |
Internal |
The value of units ordered on a PO for which a contract exists. |
|
Average PO Price ($) |
Supplier |
Internal |
The average PO price for a supplier for that period. |
|
Average PO Price ($) (Last) |
Supplier |
Internal |
The average PO price for a supplier for that period (last period). |
Reduce Lead Time Variability KPIs
This table contains the summary information for KPIs for which critical success factor is Reduce Lead Time Variability.
|
KPI Name |
Dimension (Object Type) |
Perspective |
KPI Calculation |
|---|---|---|---|
|
% of Rcpts (receipts) On-Time |
Supplier |
Internal |
The % of supplier PO shipments for which delivery status = On Time' |
|
% of Rcpt Qty (quantity) Correct |
Supplier |
Internal |
The % of the value of the units shipped against a PO for which the completion status = Correct. |
|
# of Rcpts |
Supplier |
Internal |
The number of supplier PO shipments for the period. |
|
# of Rcpts Early |
Supplier |
Internal |
The number of supplier PO shipments for which delivery status = Early. |
|
# of Rcpts Late |
Supplier |
Internal |
The number of supplier PO shipments for which delivery status = Late. |
|
# of Rcpts On-Time |
Supplier |
Internal |
The number of supplier PO shipments for which delivery status = On Time. |
|
% of Rcpts Early |
Supplier |
Internal |
The % of the number of supplier PO shipments for which delivery status = Early. |
|
% of Rcpts Early (% Chg [change]) |
Supplier |
Internal |
The % change of the number of supplier PO shipments since last period for which delivery status = Early. |
|
% of Rcpts Late |
Supplier |
Internal |
The % of the number of supplier PO shipments for which delivery status = Late. |
|
% of Rcpts Late (% Chg) |
Supplier |
Internal |
The % change of the number of supplier PO shipments since last period for which delivery status = Late. |
|
% of Rcpts On-Time (% Chg) |
Supplier |
Internal |
The % change of the number of supplier PO shipments since last period for which delivery status = On Time. |
|
Average # of days early |
Supplier |
Internal |
The average number of days that a supplier's shipments arrived early. |
|
# of Rcpt Qty |
Supplier |
Internal |
The number of units received from a supplier for a period. |
|
# of Overshipped Qty |
Supplier |
Internal |
The number of units received on a PO for which completion status = Overshipped. |
|
# of Rcpt Qty Correct |
Supplier |
Internal |
The number of units shipped against a PO for which the completion status = Correct. |
|
# of Rcpts On-Time and Correct |
Supplier |
Internal |
The number of supplier PO shipments for which delivery status = On Timeand for which completion status = Correct. |
|
# of Undershipped Qty |
Supplier |
Internal |
The number of units received on a PO for which completion status = Undershipped. |
|
% Overshipped Qty |
Supplier |
Internal |
The % of the number of units received on a PO for which completion status = Overshipped. |
|
% Overshipped Qty (% Chg) |
Supplier |
Internal |
The % change of the number of units received on a PO since last period for which completion status = Overshipped. |
|
% Qty Correct (% Chg) |
Supplier |
Internal |
The % change of the value of the units shipped against a PO since last period for which the completion status = Correct. |
|
% On-Time and Correct |
Supplier |
Internal |
The % difference in the number of supplier PO shipments for which delivery status = On Time and for which completion status = Correct and the number of supplier purchase order shipments. |
|
% On-Time and Correct (% Chg) |
Supplier |
Internal |
The % change in the number of supplier PO shipments for which delivery status = On Time and for which completion status = Correct since last period. |
|
% Undershipped Qty |
Supplier |
Internal |
The % of the number of units received on a PO for which completion status = Undershipped. |
|
% Undershipped Qty (% Chg) |
Supplier |
Internal |
The % change of the number of units received on a PO since last period for which completion status = Undershipped. |
|
# of Rcpts (Last) |
Supplier |
Internal |
The number of supplier PO shipments for the period (last period). |
|
# of Rcpts Early (Last) |
Supplier |
Internal |
The number of supplier PO shipments for which delivery status = Early (last period). |
|
# of Rcpts Late (Last) |
Supplier |
Internal |
The number of supplier purchase order shipments for which delivery status = Late (last period). |
|
# of Rcpts On-Time (Last) |
Supplier |
Internal |
The number of supplier purchase order shipments for which delivery status = On Time (last period). |
|
# of Rcpt Qty (Last) |
Supplier |
Internal |
The number of units received from a supplier for a period (last period). |
|
# of Overshipped Qty (Last) |
Supplier |
Internal |
The number of units received on a PO for which completion status = Overshipped (last period). |
|
# of Rcpt Qty Correct (Last) |
Supplier |
Internal |
The number of units shipped against a PO for which the completion status = Correct (last period). |
|
# of Rcpts On-Time & OK (Last) |
Supplier |
Internal |
The number of supplier PO shipments for which delivery status = On Time and for which completion status = Correct and the number of supplier PO shipments (last period). |
|
# of Undershipped Qty (Last) |
Supplier |
Internal |
The number of units received on a PO for which completion status = Undershipped (last period). |
|
Average # of days late |
Supplier |
Internal |
The average number of days that a supplier's shipments arrived late. |
Improve Invoice Accuracy KPIs
This table contains the summary information for KPIs for which critical success factor is Improve Invoice Accuracy.
|
KPI Name |
Dimension (Object Type) |
Perspective |
KPI Calculation |
|---|---|---|---|
|
% Invoiced Correctly |
Supplier |
Internal |
The % of vouchers for which PO price and voucher price are the same. |
|
% Over Invoiced ($) |
Supplier |
Internal |
The % difference in the value of units on a voucher for which voucher price is less than the PO price and the value of units on a voucher. |
|
% Under Invoiced ($) |
Supplier |
Internal |
The % difference in the value of units on a voucher last period for which voucher price is less than the PO price and the value of units on a voucher. |
|
Purchase Price Variance ($) |
Supplier |
Internal |
The sum of over invoiced ($) and under invoiced ($). |
|
# of Vouchers Over Invoiced |
Supplier |
Internal |
The number of vouchers for which the PO unit price is less than the voucher unit price. |
|
Invoiced Correctly ($) |
Supplier |
Internal |
The number of vouchers for which PO price and voucher price are the same. |
|
Over Invoiced ($) |
Supplier |
Internal |
The sum of the difference in the value of units on a voucher and value of units on a PO for which voucher price is more than the PO price. |
|
Under Invoiced ($) |
Supplier |
Internal |
The sum of the difference in the value of units on a voucher and value of units on a PO for which voucher price is less than the PO price. |
|
# of Vouchers Under Invoiced |
Supplier |
Internal |
The number of vouchers for which the voucher unit price is less than the PO unit price. |
Improve Supplier Quality KPIs
This table contains the summary information for KPIs for which critical success factor is Improve Supplier Quality.
|
KPI Name |
Dimension (Object Type) |
Perspective |
KPI Calculation |
|---|---|---|---|
|
% of Rcpt Qty Accepted |
Supplier |
Internal |
The % of the number of units accepted against a PO for which accepted quantity is the quantity remaining after rejects and returns. |
|
# of Rcpt Qty Accepted |
Supplier |
Internal |
The number of units accepted against a PO for which accepted quantity is the quantity remaining after rejects and returns. |
|
# of Rcpt Qty Rejected |
Supplier |
Internal |
The number of units rejected against a PO. |
|
# of Rcpt Qty Returned |
Supplier |
Internal |
The number of units returned against a PO. |
|
% of Rcpt Qty Accepted (% Chg) |
Supplier |
Internal |
The % change of the number of units accepted against a PO since last period for which accepted quantity is the quantity remaining after rejects and returns. |
|
% of Rcpt Qty Rejected |
Supplier |
Internal |
The % of the number of units rejected against a PO. |
|
% of Rcpt Qty Rejected (% Chg) |
Supplier |
Internal |
The % change of the number of units rejected against a PO since last period. |
|
% of Rcpt Qty Returned |
Supplier |
Internal |
The % of the number of units returned against a PO. |
|
% of Rcpt Qty Returned (% Chg) |
Supplier |
Internal |
The % change of the number of units returned against a PO since last period. |
|
# of Rcpt Qty Accepted (Last) |
Supplier |
Internal |
The number of units accepted against a purchase order for which accepted quantity is the quantity remaining after rejects and returns (last period). |
|
# of Rcpt Qty Rejected (Last) |
Supplier |
Internal |
The number of units rejected against a PO (last period). |
|
# of Rcpt Qty Returned (Last) |
Supplier |
Internal |
The number of units returned against a PO (last period). |
Buyer Feedback Ratings KPIs
This table contains the summary information for KPIs for which critical success factor is Buyer Feedback Ratings.
|
KPI Name |
Dimension (Object Type) |
Perspective |
KPI Calculation |
|---|---|---|---|
|
Quality of Customer Service |
Supplier |
Internal |
N/A |
|
Quality of Relationship |
Supplier |
Internal |
N/A |
|
Responsiveness to Changes |
Supplier |
Internal |
N/A |
|
Responsiveness to Problems |
Supplier |
Internal |
N/A |
|
Timely Issue Notification |
Supplier |
Internal |
N/A |
|
Value to our Company |
Supplier |
Internal |
N/A |
|
Value to the Supplier |
Supplier |
Internal |
N/A |
Supplier Financial Ratings KPIs
This table contains the summary information for KPIs for which critical success factor is Supplier Financial Ratings.
|
KPI Name |
Dimension (Object Type) |
Perspective |
KPI Calculation |
|---|---|---|---|
|
Credit Score |
Supplier |
Internal |
SRM - Dun & Bradstreet credit score for the Supplier Rating System. |
|
Current Paydex |
Supplier |
Internal |
SRM - Dun & Bradstreet payed score for the Supplier Rating System. |
|
Current Ratio |
Supplier |
Internal |
Measure of short-term solvency. The ability of the supplier to pay its liabilities on time. |
|
Dun & Bradstreet Rating |
Supplier |
Internal |
SRM - Dun & Bradstreet rating for the Supplier Rating System. |
|
Debt to Equity Ratio |
Supplier |
Internal |
Total Debt / Net Worth.
|
|
Financial Stress Percentile |
Supplier |
Internal |
Financial Stress %. |
|
Fin. Stress % - Average (Avg) Incidence |
Supplier |
Internal |
Financial Stress % - Average. |
|
Fin. Stress % - Industry |
Supplier |
Internal |
Financial Stress Industry. |
|
Fin. Stress % - Ind. Incidence |
Supplier |
Internal |
Financial Stress % - Industry. |
|
Fin. Stress % - National |
Supplier |
Internal |
Financial Stress National. |
|
Financial Stress Score |
Supplier |
Internal |
Financial Stress Score. |
|
Net Sales to Assets |
Supplier |
Internal |
Sales Volume / Total Assets.
|
|
Supplier Evaluation Risk Score |
Supplier |
Internal |
Dun & Bradstreet global failure risk score.
|
|
Working Capital to Assets |
Supplier |
Internal |
(Current Assets - Current Liability) / Total Assets |