The Schedule Variance Report - Details page is reached by clicking on a store name in the Schedule Variance report.

The following information is displayed on the page for the Area*, Store, Period, Job, Employee and Filter selected:

• Missed Shift: The number of shifts scheduled but not clocked by the scheduled employee, during the report period. The brackets contains the total number of hours that were scheduled in the missed shifts.

  • Click on Missed Shift and then on Filter By from the drop-down list, to display only missed shifts in the report.

  • Click on Missed Shift and then on Recommended to view the Missed Shift - Recommended Report. Depending on the time card entry system that you use and your employee schedule, CLEARVIEW can determine shifts that were missed and recommend them for creation.

• Unscheduled Shifts: The number of shifts clocked by an employee, but not scheduled, during the report period. The brackets contains the total number of hours that were clocked but not scheduled.

  Click on Unscheduled Shifts and then on Filter By from the drop-down list, to display only unscheduled shifts.

• Scheduled Hours: The total number of hours scheduled during the period.

  Scheduled Hours will not include unpaid breaks if the Unpaid break adjustment is set to Yes.

  Click here to learn how to include or exclude unpaid breaks in scheduled hours, in Schedule - Reporting.

• Actual Hours: The total number of labour hours clocked by employees during the period.

• Variance: The difference between the total number of labour hours clocked by employees and the total number of scheduled hours.

  Variance = Actual Hours - Scheduled Hours

  Click on Variance and select an option from the drop-down list to filter Drop-down boxes that let you select from the options available. the report:

  • Variance in hours will display only records that have a variance in the hours clocked.

  • Variance in cost will display only records that have a variance in the employee cost.

  • Variance in hours/cost will display only records have a variance in either the hours or employee cost.

• Est. Cost: The estimated employee cost for the scheduled hours based on the pay rate for each job scheduled.

• Actual Cost: The actual employee cost for the hours clocked based on the pay rate for the jobs clocked.

• Variance: The difference between the estimated employee cost for the scheduled hours and the actual employee cost for the hours clocked.

  Variance = Actual Cost - Est. Cost

• Punch In: Early lists the number of time cards that clocked-in The recorded time at which an employee started work. earlier than the tolerance set, while Late lists the number of time cards that clocked-in The recorded time at which an employee started work. later than the tolerance set

  Click on Punch In and select an option from the drop-down list to filter Drop-down boxes that let you select from the options available. the report:

  • Filter by punch in Variance limit will display only time cards that exceeded the punch in variance limit.

  • Filter by punch out Variance limit will display only time cards that exceeded the punch out variance limit.

  • Filter by punch in/out Variance limit will display only time cards that exceeded either the punch in or punch out variance limit.

• Punch Out: Early lists the number of time cards that clocked-out The recorded time at which an employee ended work. earlier than the tolerance set, while Late lists the number of time cards that clocked-out The recorded time at which an employee ended work. later than the tolerance set

  Click on Punch Out and select an option from the drop-down list to filter Drop-down boxes that let you select from the options available. the report:

  • Filter by punch in Variance limit will display only time cards that exceeded the punch in variance limit.

  • Filter by punch out Variance limit will display only time cards that exceeded the punch out variance limit.

  • Filter by punch in/out Variance limit will display only time cards that exceeded either the punch in or punch out variance limit.

• Reporting from/to: The period for which the report was generated.

• Job: The job that the employee was scheduled for.

• Scheduled:

  Unscheduled shift appears across the Scheduled columns if there's a time card clocked for an employee, but no shift scheduled for that employee.

  • Start: The time at which the employee was scheduled to start their shift.

    A next to the start time indicates that the time listed is actually the start of the period for which the report was generated, and the shift was scheduled to start before the start time indicated.

    Hover over Place the cursor over. to view the scheduled shift start time.

  • End: The time at which the employee was scheduled to end their shift.

    A next to the end time indicates that the time listed is actually the end of the period for which the report was generated, and the shift was scheduled to end after the end time indicated.

    Hover over Place the cursor over. to view the scheduled shift end time.

  • Paid Hours: The total work hours scheduled for the shift, less unpaid breaks, during the report period.

    Scheduled Paid Hours = Schedule End - Schedule Start - any unpaid breaks

    • Figures in orange indicate that unpaid breaks have been deducted from the Scheduled Paid Hours.

    • Hover over Place the cursor over. orange figures to view the length of unpaid breaks.

  • Est. Cost: The projected cost of labour for the shift, based on the scheduled hours.

    Scheduled Est. Cost = Scheduled Total Hours x pay rate for the job for the employee assigned to the shift

    • Figures in orange indicate that unpaid breaks have not been included in the Est. Cost.

    • Hover over Place the cursor over. orange figures to view the length of unpaid breaks.

  • Assigned To: The employee assigned to the shift.

• Actual:

  • Missed Shift appears across the Actual columns if an employee was scheduled for a shift but no time card was clocked for the employee.

  • Click on Missed Shift to create or make changes to the missed shift.

  • Worked By: The employee that worked the shift.

  • Start: The time at which the employee clocked-in The recorded time at which an employee started work. for the shift.

    A next to the start time indicates that the time listed is actually the start of the period for which the report was generated, and the employee clocked-in The recorded time at which an employee started work. before the start time indicated.

    Hover over Place the cursor over. to view the time at which the employee clocked-in The recorded time at which an employee started work..

  • End: The time at which the employee clocked-out The recorded time at which an employee ended work. for the shift.

    A next to the end time indicates that the time listed is actually the end of the period for which the report was generated, and the employee clocked-out The recorded time at which an employee ended work. after the end time indicated.

    Hover over Place the cursor over. to view the time at which the employee clocked-out The recorded time at which an employee ended work..

  • Paid Hours: The total hours clocked for the shift, for the report period.

    Actual Paid Hours = Actual End - Actual Start

    • Figures in orange indicate that unpaid breaks have been deducted from the Actual Paid Hours.

    • Hover over Place the cursor over. orange figures to view the length of unpaid breaks.

  • Act. Cost: The actual cost of labour for the shift, based on the clocked hours.

    Actual Act. Cost = Actual Total Hours x pay rate for the job for the employee assigned to the shift

    • Figures in orange indicate that the Actual Act. Cost includes overtime.

    • Hover over Place the cursor over. orange figures to view the it broken down to regular and overtime.

• Variance:

  • Hours: The difference between the actual hours clocked and the scheduled hours.

    Variance Hours = Actual Total Hours - Scheduled Total Hours

  • Cost: The difference between the actual and scheduled cost of labour for the shift.

    Variance Cost = Actual Act. Cost - Scheduled Est. Cost

  • Punch In: The difference between the time at which the employee clocked-in The recorded time at which an employee started work. and the time that the employee was scheduled to start the shift, in minutes.

    Variance Punch In = Actual Start - Scheduled Start

    Figures in red indicate that the Variance Punch In is more than the Clock Tolerance set when generating the report.

  • Punch Out: The difference between the time at which the employee clocked-out The recorded time at which an employee ended work. and the time that the employee was scheduled to end the shift, in minutes.

    Variance Punch Out = Scheduled End - Actual End

    Figures in red indicate that the Variance Punch In is more than the Clock Tolerance set when generating the report.