Average score
3.9
Preferred suppliers
1
Needing review
3
Supplier Performance Scorecard
Quarterly weighted supplier scores on quality, delivery, price, responsiveness and compliance, with ratings, quarter-on-quarter trend and review flags.
12 free operations supply chain management templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 12 spreadsheets from Warehouse Management, Inventory & Stock Management and Suppliers & Vendors. Start with Supplier Performance Scorecard, Order Fulfilment Board and Vendor Master List: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Average score
3.9
Preferred suppliers
1
Needing review
3
Quarterly weighted supplier scores on quality, delivery, price, responsiveness and compliance, with ratings, quarter-on-quarter trend and review flags.
Open orders
8
Late
8
At risk
0
Orders from received to delivered with ship-by SLAs, late and at-risk flags, days to ship, and performance by channel and stage.
Suppliers
6
Annual spend
$193,900
Need attention
3
One list of approved suppliers with contacts, terms, spend, documents on file and review dates.
Stock value
$894
Items to reorder
4
Out of stock
1
Stock on hand from a movements log, with reorder points from real usage, lead time and safety stock, days of cover and a ready-made reorder list.
Lines counted
93%
Count accuracy
54%
Net variance value
-$67
Count stock by location against system quantities, with variance by units and value, recount flags, count accuracy and results by location.
Items
10
Annual usage value
$102,618
A items
3
Rank every item by annual usage value and class it A, B or C so you know where control matters most.
Stock value
$8,664
Items to reorder
1
Log every receipt, issue and adjustment and see the running quantity on hand for each item.
Stock value
$27,060
Overall turnover
4.7
Slow or dead value
$14,060
Value stock by category and see turnover and days on hand so slow movers stand out.
Bins
8
Space used
71%
Empty bins
2
Where every item lives: zone, aisle, rack and bin, with capacity used and empty locations.
Lines received
6
Received complete
33%
Lines with a problem
4
Check each delivery against its order: quantities, damage and shortages, with supplier accuracy.
Items checked
18
Pass rate
67%
High-risk failures open
2
Inspect racking, forklifts, docks, exits, fire, electrical and hazmat with pass/fail results, risk ratings and tracked corrective actions.
Inventory accuracy
80%
Net variance value
-$303
Gross variance value
$303
Schedule counts by ABC class, record counted versus system quantity, and see variance in units, value and percent with inventory accuracy.