Clock Card Report - What each column means

This guide provides a detailed explanation of the columns in the Clock Card Report, helping you interpret the data and assess technician performance, productivity, and attendance accurately.

Column Breakdown

1. Technician Name:

   • The name of the technician whose data is being reported.

2. Br (Branch No):

   • The branch number where the technician is assigned.

3. Invoiced Date:

   • The date when the job was invoiced.

4. Hours On Jobs:

   • The total time (in hours) the technician spent working on jobs.

5. Non-Prod. Time:

   • The total hours clocked to non-productive jobs, such as waiting or admin tasks.

6. Hours Attended:

   • The total hours the technician was clocked in, calculated as the difference between clock-in and clock-out times for the day.

7. Hours Absent:

   • The total time booked to absence, such as holidays or training, which is removed from the diary.

8. Absent Type:

   • The specific type of absence booked (e.g., Holiday, Training, Sickness).

9. Gross Hours Attended:

   • The total hours the technician was present, including both productive and non-productive time.

10. WIP Adj.:

• The Work In Progress Adjustment:
  • This is the net difference between:
    • Time taken on jobs invoiced today but worked on previous days.
    • Hours clocked today for jobs not yet invoiced.

11. Hours Scheduled:

• The total time allocated to job lines for the technician.

12. Hours Taken:

• The actual time (in hours) the technician spent completing the allocated job(s).

13. Variance:

• The difference between hours scheduled and hours taken:
  Variance = Hours Taken - Hours Scheduled.

14. Utilisation %:

• A measure of how much attended time was spent productively on jobs, calculated as:
  (Hours on Jobs ÷ Hours Attended) × 100.

15. Efficiency %:

• A measure of how efficiently the technician worked, calculated as:
  (Hours Scheduled ÷ Hours Taken) × 100.

16. Prod. Eff %:

• Productivity Efficiency: A measure of how much of the technician’s gross attended time was utilised productively, calculated as:
  (Hours Scheduled ÷ Gross Hours Attended) × 100.

Key Insights

• Performance Metrics: Use columns like Utilisation %, Efficiency %, and Prod. Eff % to evaluate technician productivity and overall effectiveness.
• Attendance Analysis: Assess attendance patterns using Hours Attended, Hours Absent, and Absent Type to identify trends or gaps.
• WIP Adjustments: Monitor the WIP Adj. column to track discrepancies between time worked and invoiced, ensuring accurate accounting.
• Variance Insights: The Variance column helps pinpoint discrepancies between planned and actual job times, providing a basis for improving scheduling accuracy.