jagomart
digital resources
picture1_Excel Report Format Template 32373 | Copy Of Hanson Cor Audit Master Version Date 20 July 20111


 225x       Filetype XLSX       File size 0.12 MB       Source: cdn-s3-nrspp-2020.s3.ap-southeast-1.amazonaws.com


File: Excel Report Format Template 32373 | Copy Of Hanson Cor Audit Master Version Date 20 July 20111
sheet 1 instructions carriersupplier cor compliance review instructions to auditor 1 contact company to be audited make appointment for audit and send pre audit checklist to nominee 2 open master ...

icon picture XLSX Filetype Excel XLSX | Posted on 09 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: instructions
Carrier/Supplier COR Compliance Review
Instructions to Auditor
1 contact company to be audited; make appointment for audit and send pre audit checklist to nominee
2 open master copy and save file with name of audited company and date
3 open "report" tab and complete all cells highlighted in green - details will then be copied to other sheets
4 determine if containers are used - use macro button if containers not used
5 determine if contractors are used - use macro button if contractors not used
6 determine if Driver Fatigue Management plans are required - i.e. trips greater than 500k are completed, or drivers travel more than 500k in a 24 hour period - use macro button if DFMP's not required
7 reset buttons available for above macros if error made - scroll to right of macro buttons for reset buttons
8 open "tool" and carry out audit - mark appropriate column "not compliant", "improvement req", or "compliant".
9 complete comment under "non conformance / improvement note raised" Tool will add comment if criteria not addressed
10 open "report" and check all questions answered - sheet will highlight any section incomplete
11 complete any incomplete questions within "tool"
12 agree with auditee on close off dates for NCN and improvements and enter dates in "report"
13 print "report" as summary
14 print "tool" pages as detailed report
15 open "non conformance note" - hit macro button - sheet will infill with summary of NCN and print. Auditee to use this report to notify auditor when required corrective action implemented
16 open "improvement note" - hit macro button - sheet will infill with summary of improvements required and print. Auditee to use this report to notify auditor when corrective action implemented
17 sign audit report pages
18 open "exec summary ncn" - hit macro button - sheet will infill details of NCN and print. Auditor to forward this part of report to his Regional Manager as high level summary report
19 open "exec summary imp req" - hit macro button - sheet will infill details of improvements required and print. Auditor to forward this part of report to his Regional Manager as high level summary report


Primary purpose of audit is to build risk based profile on Carrier/Supplier and drive improvements as required
Auditor should schedule a reaudit within an agreed timeframe if a number of key criteria are not compliant or need improvement.

Sheet 2: pre audit list
Carrier/Supplier COR Compliance Review


Documentation / systems / procedures that may be required to be viewed by, or demonstrated to, auditor


OH&S OH&S Management System

Systems and procedures to support above Management System

Minutes of safety team meetings and timing of meetings

Examples of communication of safety issues

Lost time injury rate and target

First aid injury rate and target

Total injury rate and target

MVA rate

Incident reporting and investigation system


CoR CoR Management System

Systems and procedures to support above Management System

Examples of communication of CoR issues

Training records

Breach reports


Accreditation Mass Management accreditation

Maintenance Management accreditation

Fatigue Management accreditation

List of accreditation non conformances over past 3 years - audit results


Employee Training CoR training program

OH&S training program

Fatigue Management training program

Mass and Dimension training program

Maintenance Management training program

Load Restraint training program

Environmental Compliance training program

Speeding Compliance training program

Driver Fatigue Management Plans training program if drivers travel >500k in 24 hour period


Contractor Training CoR training program

OH&S training program

Fatigue Management training program

Mass and Dimension training program

Maintenance Management training program

Load Restraint training program

Environmental Compliance training program

Speeding Compliance training program

Driver Fatigue Management Plans training program if contractors travel >500k in 24 hour period


Risk Assessments Risk Assessment register

Risk Assessment procedure

Risk Assessment monitoring


Inductions Employee Induction

Contractor Induction


Communications Public complaints handling

Communicating to drivers

Safety communications


Load Restraint Load Restraint Management System

Systems and procedures to support above Management System

Load restraint techniques

Load restraint equipment specification or standards

Load restraint Maintenance schedule

Non conformance procedure


Fatigue Management Fatigue Management Management System

Systems and procedures to support above Management System

System to determine safe transit times

Roster and scheduling system / procedure

Review of actual transit times

Procedure to consult with driver as to whether they are fit for duty


Mass & Dimension Mass Management Management System

Systems and procedures to support above Management System

Process to check that axle weights and GVM are within limits

Process if axle or GVM limits exceeded.

Container weight declarations (if applicable)


Speed Compliance Speed Compliance Management System

Systems and procedures to support above Management System

Action taken if employee or contractor exceeds speed limit


Pre loaded trailers Process to ensure preloaded trailers are loaded safely and legally


Equipment Daily inspection procedure and records

R&M process and system


Fitness for work Drug and Alcohol Management System

Driver health and fitness assessment Management System


Non Conformance System to deal with non conformance


Environmental Environmental Management System

Systems and procedures to support above Management System

National Greenhouse & Energy Reporting registration

Current major environmental drive within company

Sheet 3: report
Carrier/Supplier COR Compliance Review

































Auditor's name

Date:


no contractors used either as hire, or to haul product in or out
















Auditor Company





















no preloaded containers hauled

Auditee

























Location Audit Conducted



no trips over 500k in any 24 hr period
















Auditee contact name






























Auditee contact position




no trailers are preloaded by others and picked up by or behalf of company
















Contact phone number
mobile
office

























Contact email































Score Card










































Section 1 Occupational Health and Safety Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Section 2 Chain of Responsibility Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Section 3 Accreditation Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Section 4a Employee Training and Education Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Section 4b Contractor Training and Education Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Section 5 Risk Assessment Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Section 6 Induction Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Section 7 Communication Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Section 8 Load Restraint Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Section 9 Fatigue Management Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Section 10 Vehicle Mass and Dimension Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Section 11 Speed Compliance Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Section 12 Preloaded Trailer Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Section 13 Equipment Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Section 14 Fitness for Work Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Section 15 Non Conformance System Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Section 16 Environmental System Questions not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0% 0%





















Overall







not evident imp req compliant score








Auditor's Comments
0 0 0 0%








0% 0% 0%









key criteria 50








not evident imp req compliant score








0 0 0 0

















0% 0% 0% 0%






























Follow Up Actions










































Key Criteria not addressed

0

















Evidence of correction action/s required to be forwarded - close off date








































date above evidence received by auditor



signature
































Key Criteria requiring improvement to process or procedure




0














Evidence of correction action/s required to be forwarded - close off date








































date above evidence received by auditor



signature
































Number of criteria not addressed

0

















Evidence of correction action/s required to be forwarded - close off date








































date above evidence received by auditor



signature
































Number of improvements req

0

















Evidence of correction action/s required to be forwarded - close off date








































date above evidence received by auditor



signature
































Is re audit required?
yes / no


















Date required








































Auditors signature



date































Auditee's contact signature



date











The words contained in this file might help you see if this file matches what you are looking for:

...Sheet instructions carriersupplier cor compliance review to auditor contact company be audited make appointment for audit and send pre checklist nominee open master copy save file with name of date quot report tab complete all cells highlighted in green details will then copied other sheets determine if containers are used use macro button not contractors driver fatigue management plans required ie trips greater than k completed or drivers travel more a hour period dfmp s reset buttons available above macros error made scroll right tool carry out mark appropriate column compliant improvement req comment under non conformance note raised add criteria addressed check questions answered highlight any section incomplete within agree auditee on close off dates ncn improvements enter print as summary pages detailed hit infill this notify when corrective action implemented sign exec forward part his regional manager high level imp primary purpose is build risk based profile drive should sched...

no reviews yet
Please Login to review.