A supplier risk rating answers one question: which suppliers deserve most of your checking? A maker with six suppliers and one afternoon a month can't audit all of them, and shouldn't treat the pouch printer like the spice importer. The simplest rating that works scores two things from 1 to 3 and multiplies them: how bad is the hazard that has to be dealt with before the ingredient reaches you, and how has this supplier behaved. The product, 1 to 9, sorts suppliers into high, medium and low, and the rating sets how closely and how often you look. FDA's rule for plants with a supply-chain program uses the same two ideas: the hazard analysis and the supplier's performance are among the things it says must be considered. Below is a rating for a made-up granola maker, what each rating leads to, and a sheet. The scale is the example's own.
The short version
- Score severity 1 to 3: what's the worst hazard someone else controls before you get the ingredient?
- Score history 1 to 3: documents on time, lots refused, complaints, how they answer.
- Multiply. 6 or more is high, 3 or 4 medium, 1 or 2 low.
- Decide what each rating means in checks and how often, and write it down.
- Rate again when something changes: a new site, a recall, a late certificate.
- The rating points. It doesn't choose the check for you.
- TaroStack keeps each supplier's deliveries by lot, and what they promised against what happened. More below.
The scale
| Score | Severity: the hazard controlled before it reaches you | History: this supplier, with you |
|---|---|---|
| 1 | None that needs a control from the supplier, or packaging and other low-risk items | Documents arrive with every lot, nothing refused, quick answers |
| 2 | A hazard your own process also deals with | An occasional late document or short delivery, fixed when raised |
| 3 | A hazard that can cause serious illness and that only the supplier controls: a pathogen in something you don't cook, a toxin, a heavy metal, an undeclared allergen | Repeated late or missing documents, a refused lot, a recall, slow or evasive answers |
Severity is about the ingredient and what you do with it. Almonds that go into a granola baked to a validated step are a different risk from almonds sprinkled on after baking. History is about the supplier, and a new supplier with no history starts at 2.
Six suppliers, rated
| Supplier | Ingredient | Hazard controlled before we get it | Severity | History | Score | Rating |
|---|---|---|---|---|---|---|
| Valley Nut Co. | Almonds, raw | Salmonella: the supplier's pasteurization | 3 | 1 | 3 | MEDIUM |
| Riverbend Mills | Wheat flour | None needing a supplier's control: our bake step | 2 | 1 | 2 | LOW |
| Sunrise Spice Importers | Ground cinnamon | Lead; Salmonella: the supplier's treatment | 3 | 3 | 9 | HIGH |
| Hilltop Dairy | Butter | Pathogens: pasteurization | 3 | 1 | 3 | MEDIUM |
| Kettle Packaging | Pouches | Food-contact suitability | 1 | 2 | 2 | LOW |
| Greenfield Farm | Dried cranberries | None needing a supplier's control | 1 | 1 | 1 | LOW |
One high, and it isn't the biggest supplier. The cinnamon is a few pounds a month. It scores 9 because the hazard is serious, this maker adds it after baking, and the importer has been late with documents twice and had a lot refused. Most of this maker's checking belongs there.
Two mediums that are well behaved. The almonds and the butter carry serious hazards and come from suppliers with clean records. A serious hazard never rates low, however good the supplier: 3 times 1 is still 3.
The folder problem. Before the rating, every supplier had the same three documents on file. After it, the cinnamon has a test on every lot and the cranberries have a specification sheet, renewed every three years. The total work is about the same. It's in a different place.
What each rating leads to
This maker's own rules:
| Rating | What we do | How often |
|---|---|---|
| HIGH | A check on every lot: our own lab test, or the supplier's test result read against a limit. A document with every delivery, read before the lot is released | Every lot. Reviewed every 6 months |
| MEDIUM | An audit report or the supplier's food safety records reviewed. A certificate with each lot where the hazard calls for it | Yearly |
| LOW | Specification, allergen statement or letter of guarantee on file | Every 2 or 3 years, and on any change |
For a plant that has to have a supply-chain program, the rule names the kinds of verification to choose from: onsite audits, sampling and testing, review of the supplier's relevant food safety records, and other activities based on supplier performance and the risk of the ingredient. The rating doesn't replace reading that part of the rule: see supply chain program and supplier approval program template. This is general information, not legal advice.
When to rate again
- A change at the supplier: a new site, a new owner, a new source for the ingredient. The pouch printer's note in the example says it moved since its last letter, so the letter is asked for again.
- A change in your own process. Moving an ingredient from before the bake to after it changes its severity.
- An event: a refused lot, a recall, a complaint traced to an ingredient, an FDA warning letter to the supplier.
- The calendar: once a year, all of them, in one sitting.
The rating is one of several supplier tools. Day-to-day performance, delivery and price are in supplier scorecard. The questions to send a new supplier are in supplier questionnaire template, the list itself in approved supplier list, and keeping certificates in order in certificate of analysis tracking.
Get the sheet
Download the supplier risk rating sheet. One sheet and a read-me: a row for each supplier and ingredient, the two scores, and the score, rating, chosen check, frequency and date last done. HIGH rows are highlighted. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The "history" score is somebody's memory of the year. Was the cinnamon late twice or four times? Which lot was refused, and what happened to the granola made from the lot before it? A rating built on impressions drifts toward whoever was annoying most recently, and a spreadsheet can't tell you which batches a high-rated supplier's ingredient went into.
How TaroStack does it
TaroStack keeps the history as it happens.
Every delivery is a lot against its supplier, with the date, and your own fields for what arrived with it: certificate, test result, initials.
Lead times checked against reality: what a supplier promises against how long deliveries really take.
A price-creep report per supplier.
Holds: a lot waiting for its certificate or test is out of what can be used until you release it.
One report from a supplier's lot forward: the batches that used it and the customers who got them.
| The question | Spreadsheet | In TaroStack |
|---|---|---|
| How often was this supplier late | An impression | Promised against actual, by delivery |
| Did the certificate come with the lot | A folder | A field on the receipt |
| Is the untested lot being used | Trust | On hold until released |
| Where did that supplier's lot go | Batch sheets | One report |
TaroStack doesn't send questionnaires or approve suppliers: the rating and the decision stay yours. Suppliers, lots and holds are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
