-
Excel workbook preview
HACCP Plans and Records (Codex, USDA FSIS, FDA)
CCP Determination Worksheet (Codex Decision Tree)
3 downloads per free account, no card needed.
Who this is for
A HACCP team leader who must show an auditor why each step is or is not a critical control point.
What is inside
- Q1 to Q4 of the 2022 Codex decision tree as Yes/No dropdowns per significant hazard
- Outcome formula: CCP, not a CCP (PRP, later step) or modify the process, with prompts for missing answers
- 10 worked rows from a cooked chicken line, including one 'modify the process' case
- CCP outcomes highlighted amber and modify outcomes red for review
- Decision tree sheet with the four questions and their Yes and No routes in plain words
- Justification column and 20 blank rows for your own hazards
How to use it: Copy each significant hazard from your hazard analysis, answer the questions in order and write the reason for each answer next to it.
Files & formats
- XLSXccp-determination-worksheet-template.xlsx11 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves. These templates are original working documents built on the public law or guidance named here. They are not legal advice and are not endorsed by the regulator or publisher.



