Spreadsheet: 696472d1600846308-count-formula-to-support-multiple-conditions-sample-register
Sheet: findings

Serial n. | Finding n. (from report) | Date | Process audited | Audit report | Audit rating | Description of audit finding | Recommendation/Action | Person responsible | Non Conformance | Status | Due date | Overdue n. of days (since due date) | Remarks
52 | S.1.2 | 2020-09-14 00:00:00 | TOPS V3 | TOPS GAP ANALYSIS SEC. 1-12 |  | A documented organisational structure chart must be in place showing management responsibilities and authority. | Action: •	Update the organisational structure chart. Completed and closed out. State "Yes", but not seen + Does not mention names. | [NAME] Hilst | Minor | Open | 2020-03-30 00:00:00
53 | S.1.2 | 2020-09-14 00:00:00 | TOPS V3 | TOPS GAP ANALYSIS SEC. 1-12 |  | Details of deputising cover for personnel with responsibility for legal, safety and quality issues must be documented. | Action: •	Erwin to describe who is responsible in a document Completed and closed out. | [NAME] Hilst | Minor | Open | 2020-08-30 00:00:00
54 | s.1.4 | 2020-09-14 00:00:00 | TOPS V3 | TOPS GAP ANALYSIS SEC. 1-12 |  | Management Notification The site must have systems in place to ensure that the relevant Tesco Technical contact is notified of any safety, legality and quality issues that are identified with product, that directly affect or may have the potential to affect Tesco product. The Tesco Technical contact must be involved in the final decision for handling affected Tesco product. | •	To be clarified with Flamingo | [NAME] Hilst | Major | Closed | 2020-10-30 00:00:00
55 | s.1.4 | 2020-09-14 00:00:00 | TOPS V3 | TOPS GAP ANALYSIS SEC. 1-12 |  | The Tesco Technical contact must be informed as soon as possible, of any enforcement notices, pending prosecutions, judgements, or approaches from the media etc., where there may be an impact on Tesco product, our reputation or the site’s ability to supply. | •	To be clarified with Flamingo | [NAME] Hilst | Major | Closed | 2020-10-30 00:00:00
56 | S.1.6 | 2020-09-14 00:00:00 | TOPS V3 | TOPS GAP ANALYSIS SEC. 1-12 |  | Key Performance Indicators The management team must measure key performance indicators and establish actions to improve performance, following regular analysis in key areas. | •	Create KPI’s and set up regular analysis of them.  •	No formal KPIs in place | [NAME] Hilst | Major | Closed | 2020-10-30 00:00:00
57 | s2.1 | 2020-09-14 00:00:00 | TOPS V3 | TOPS GAP ANALYSIS SEC. 1-12 |  | Quality Management System The site must have a Quality Management System (QMS), which is maintained, documented and regularly reviewed, annually as a minimum. | •	QMS annual review scheduled (October 2020). QMS to be part of/explained in the quality manual. | [NAME] | Major | In progress | 2020-10-30 00:00:00
58 | s2.6 | 2020-09-14 00:00:00 | TOPS V3 | TOPS GAP ANALYSIS SEC. 1-12 |  | Internal Audits Frequency and Scheduling The frequency of audits must be determined by risk assessment, annually as a minimum, and completed to a schedule. | •	Risk analysis performed as part of annual review on HACCP. •	Annual internal audit schedule in place and approved. | [NAME] | Major | In progress | 2020-10-30 00:00:00
59 |  | 2020-09-14 00:00:00 | TOPS V3 | TOPS GAP ANALYSIS SEC. 1-12