How to Build a Supplier Scorecard for CPG Brands
Your supplier's on-time delivery rate, quality rejection rate, and price variance history tell you more about your supply chain risk than any contract does. Here is how to track them.
Most CPG brands evaluate suppliers at the time of onboarding: they review the spec sheet, check the COA, get a sample, and place an order. After that, supplier performance is tracked informally — you notice when something goes wrong, but you do not have a systematic way to measure whether a supplier is getting better or worse over time.
A supplier scorecard changes that. It gives you a quantitative view of each supplier's performance across the metrics that matter most: delivery reliability, quality consistency, documentation compliance, and price stability. With a scorecard, you can identify deteriorating supplier performance before it causes a production stoppage, and you have objective data to support renegotiations or supplier transitions.
The Five Metrics Every CPG Supplier Scorecard Should Track
1. On-Time Delivery Rate (OTDR)
OTDR measures the percentage of purchase orders delivered within the agreed delivery window. OTDR = (Orders Delivered On Time / Total Orders) × 100. A supplier with a 95% OTDR is delivering on time 19 out of 20 orders. A supplier at 80% is late one in five orders, which means you need significantly more safety stock to avoid production stoppages.
Define "on time" clearly: is it the requested delivery date, a ±3 day window, or the confirmed ship date? The definition matters for consistency. Track OTDR monthly and by delivery type (domestic vs. international, full container vs. LCL).
2. Quality Acceptance Rate (QAR)
QAR measures the percentage of lots received that pass your incoming quality inspection. QAR = (Lots Accepted / Total Lots Received) × 100. A lot rejection means the shipment does not meet your specifications and cannot be used in production. Rejections cause production delays, require return shipping, and often require emergency sourcing from an alternative supplier at a premium price.
Track QAR by rejection reason: out-of-spec moisture content, failed microbial testing, wrong particle size, incorrect labeling, damaged packaging. The rejection reason tells you whether the problem is systemic (the supplier consistently fails on moisture) or random (one bad batch).
3. Certificate of Analysis (COA) Compliance Rate
COA compliance rate measures whether the supplier provides a COA with every lot, whether the COA is complete (all required parameters tested), and whether the COA results match your incoming test results. For organic and certified products, the COA must also include the relevant certification documentation.
A supplier with a 100% QAR but an 80% COA compliance rate is a compliance risk. If you are audited by USDA Organic or an SQF auditor and cannot produce COAs for your ingredients, you have a serious problem regardless of whether the product was actually in spec.
4. Price Variance
Price variance measures the difference between the quoted price and the actual invoiced price. Price Variance % = (Actual Price − Quoted Price) / Quoted Price × 100. Positive variance means the supplier invoiced more than quoted. Track this metric because it reveals suppliers who systematically invoice above quoted prices, which inflates your COGS relative to your BOM estimates.
5. Lead Time Variance
Lead time variance measures the difference between the promised lead time and the actual lead time. Lead Time Variance = Actual Lead Time − Promised Lead Time (in days). A supplier who consistently delivers 5 days later than promised requires you to carry 5 extra days of safety stock, which has a real carrying cost.
The Scorecard Template
| Metric | Weight | Green (≥) | Yellow | Red (<) | Supplier A | Supplier B |
|---|---|---|---|---|---|---|
| On-Time Delivery Rate | 30% | 95% | 85-94% | 85% | 97% | 82% |
| Quality Acceptance Rate | 30% | 99% | 95-98% | 95% | 100% | 96% |
| COA Compliance Rate | 20% | 100% | 95-99% | 95% | 100% | 88% |
| Price Variance | 10% | <1% | 1-3% | >3% | 0.5% | 2.1% |
| Lead Time Variance | 10% | <2 days | 2-5 days | >5 days | 1 day | 7 days |
| Weighted Score | 98.5 — Green | 87.4 — Yellow |
How to Use the Scorecard
Run the scorecard quarterly for all active suppliers. Share the results with suppliers during quarterly business reviews. Suppliers in the Yellow zone should receive a written improvement plan with specific targets and a timeline. Suppliers in the Red zone should trigger a sourcing review: either the supplier commits to a corrective action plan with measurable milestones, or you begin qualifying an alternative supplier.
The scorecard also informs your safety stock calculations. A supplier with a 95% OTDR and a 5-day average lead time variance requires more safety stock than a supplier with a 99% OTDR and a 1-day variance. Quantifying supplier reliability allows you to set safety stock levels based on actual data rather than intuition.
Frequently Asked Questions
How many suppliers should I be scoring?
Score all suppliers that provide ingredients or packaging that are critical to your production. For most CPG brands, this is 5-15 suppliers. You do not need to score one-time or spot-buy suppliers, but any supplier you rely on for regular production runs should be in the scorecard.
Should I share the scorecard with my suppliers?
Yes. Sharing the scorecard creates accountability and gives suppliers clear targets to improve against. Most suppliers respond positively to objective performance data. It also signals that you are a sophisticated buyer who tracks performance, which often results in better service.
How does supplier quality affect my COGS?
A supplier with a 95% QAR means 5% of lots are rejected. Rejected lots have to be returned, disposed of, or reworked. The cost of a rejection includes the product cost, return shipping, disposal fees, and the cost of emergency sourcing to replace the rejected lot. These costs should be tracked and included in the true cost of that supplier relationship.
What is the relationship between supplier scorecard and safety stock?
Safety stock should be calculated based on supplier lead time variability and demand variability. A supplier with high lead time variance requires more safety stock to maintain the same service level. The scorecard quantifies lead time variance, giving you the data to set safety stock levels scientifically rather than by gut feel.
Slater built Guidance after running Claros Farm, a certified organic CPG brand sourcing ingredients from 14 countries. He wrote Guidance to solve the operations problems he could not find software for.
Know which suppliers are putting your production at risk.
Guidance tracks on-time delivery, quality acceptance, COA compliance, and price variance for every supplier automatically, giving you a live scorecard without any manual data entry.
Get Early Access