Food Fraud Advisors values your feedback

To access this content, please purchase the full version of the Vulnerability Assessment Helper.

The Raw Material Report page and the Supplier Report page each contain a special excel feature called a pivot table. The pivot table allows results to be filtered, organised and printed. The pivot tables on these pages are designed to produce a list of information about individual materials and suppliers. The pivot tables draw data from an inaccessible area of the spreadsheet file.

Users have full editing rights to the pivot tables on these pages. The pivot table features, filters and criteria can be customised to suit your needs.

If you want to learn more about pivot tables and how to use them, there are hundreds of free resources on the internet to help you learn pivot tables, including this one.

Help with the Supplier Assessment section of the Vulnerability Assessment Helper.

Supplier name

There is no need to enter information about a supplier more than once.

1. If you are using the spreadsheet as a starting point for a complete supply chain map you should add supplier names for every raw material or ingredient.  You only need to add the name a second and subsequent time, there is no need to enter all the information more than once.
2. If you do not intend to create a complete supply chain map then just enter the name and details of each supplier once.

The summary sheet will tabulate the results for each supplier in a sortable and printable format.

Likelihood

This column is populated with the results of the raw material assessment.  If a raw material is very unlikely to be affected by adulteration or substitution you may wish to give the suppliers of that material a lower priority and assess  suppliers of more vulnerable ingredients first.

Supplier Risk Profile

The supplier risk profile is calculated from the information added to this table and from the user estimate of risk.  The results are presented on the left hand side of the table to make it easy to find later.   The result returned here is either the calculated risk profile or the manually entered risk profile if one has been entered.  The user estimate always overrides the automatic calculation.

When it comes to supplier risk, no matter what answer the Helper calculates, you should seek advice from other experts within the business and together you should carefully consider the vulnerabilities and strengths of each supplier, and make your own estimate of risk.

Broker or Trader

A broker or trader is a person or business who purchases large lots of materials on the open market and sells them to many purchasers.  Brokers and traders often do not handle the actual materials at all.  Prices of good purchased from brokers and traders typically experience larger and more frequent variations than those from other supplier types.

Transport and Storage

Answer ‘yes’ to these questions if the supplier is using transport and storage facilities that contain only their products and are not used to transport or store products that belong to other businesses.

Food Safety Management Systems

Does the supplier have a certified food safety program? And does the scope include all relevant ingredients?

1. Answer ‘yes’ if your business has a copy of the supplier’s food safety management system certificate and it is current and has been verified as valid.  The facility address on the certificate should match the site from which your materials are shipped.

Does the supplier’s food safety program include vulnerability assessments and fraud/tampering prevention?

1. Answer ‘yes’ if the food standard to which the supplier conforms includes requirements to assess vulnerabilities and to take action to prevent and mitigate risks associated with deliberate tampering, adulteration, substitution and dilution, whether economically motivated or otherwise.
2. Answer ‘no’ if the supplier is operating a food safety management system that does not include vulnerability assessments and fraud/tampering prevention.
3. Answer ‘not applicable’ if there is no food safety management system or if the scope of such does not include the material being purchased or if the system is not currently certified.

Have you reviewed the food safety program and/or the audit report and is the program robust and implemented properly with respect to the supplied ingredient/s?

1. Answer ‘yes’ if someone from your business has reviewed the supplier’s food safety management system or a recent audit report from the food safety management system certification body.  Also answer ‘yes’ if your business has conducted a supplier audit.  Choose ‘yes reviewed and robust’ if the program is satisfactory, seems to be implemented well and includes good materials traceability and measures to prevent and mitigate fraud and malicious tampering.  Choose ‘yes reviewed but not completely satisfactory’ if the program and its implementation require improvements or the program does not include robust traceability of materials and measures to prevent and mitigate fraud and malicious tampering.
2. Answer ‘no not reviewed’ if the supplier has a certified food safety management system but your business has not reviewed the system or a recent audit report.
3. Answer ‘not applicable no program’ if the supplier does not have a certified food safety program.

Other certifications

Answer ‘yes’ here if there are special criteria for this raw material or ingredient such as halal, organic, non-GMO, grass-fed, free-range and if the supplier has provided valid certifications for such.  Answer ‘no’ if the supplier is providing a material that has a special criteria but no certification for such.  Answer ‘not applicable’ if this material does not have any special criteria.

Likelihood Rating – Raw Material or Ingredient (Calculated)

A result is calculated by the Vulnerability Assessment Helper using the answers that you provide in the raw materials and ingredients table. The result returned is an indicator of how likely it is that the raw material or ingredient will be affected by economically motivated adulteration, substitution or dilution.

This calculated result does not consider the characteristics of the supplier(s) of this raw material or ingredient.  After you have completed the supplier assessment for all the suppliers of this material you can add your own estimate of likelihood based on the Vulnerability Assessment Helper’s calculated result plus the results of the supplier assessment(s).   If every supplier of that material is low risk you may wish to downgrade the likelihood rating for the material.

Likelihood Rating – Raw Material or Ingredient (User Rating)

No matter what likelihood the Helper calculates, you should seek advice from other experts within the business and together you should carefully consider the information and make your own estimate of vulnerability for each material.  Add your estimate to the ‘User rating’ column.  The results table on the Results (printable) page is populated with the user rating of likelihood if one has been entered.