The Schedule Variance report is an analysis tool that compares the forecasted and actual sales, scheduled and worked hours, projected and actual cost, projected and actual labour percent, and projected and actual SPLH Sales Per Labour Hour. It is the total sales for the period divided by the number of labour hours logged for the same period. (Sales per Labour Hour).

The Schedule Variance page may be reached through:

Click here to learn how to set up the report settings in Schedule - Reporting.

TO VIEW THE VARIANCE IN SCHEDULE FOR A PERIOD:

  1. Open the Schedule Variance page.

  2. Select the Area* and Store for which you want to view the report from the drop-down list(s).

  3. Select the Period for which you want to view the report from the drop-down list.

  4. Select the specifics of the period* (Date*, Year*, Schedule Week Ending*) from the drop-down list(s).

  5. Click on the Go button.

  6. Select the period for which you want to Include Forecast and Schedule for:

    1. Entire Period will include the forecasted amounts for all time periods, regardless if there were actual sales that happened during the period.

    2. Matching Sales Period will remove forecasted amounts for time periods that reported zero sales.

Summary

The following information is displayed in the Summary tab for the Area*, Store and Period selected using the filters Drop-down boxes that let you select from the options available. at the top of the page:

Use the *Show Summary View* or *Show Detailed View* link in the top-left corner of the report to switch between the summary and detailed report.

  • The detailed view of the report includes the figures used to calculate the variance.

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

  • The store(s) for which the report was generated is displayed in the first column of the report.

    • Click on to view the breakdown of the figures by SPLH jobs and Non-SPLH jobs.

    • Click on next to SPLH or Non-SPLH to view the breakdown of the figures by each job in that category.

  • Sales:

    • Forecast*: The forecasted sales for the period.

    • Actual*: The actual sales for the period.

      Where Actual is the Adjusted Gross or Net Sales, determined by the POS Period Sales Method.

      Click here to learn how to view which sales amount is used in the report in Point of Sale Details.

    • Variance: The difference between the actual and forecasted sales for the period.

      Sales Variance = Sales Actual - Sales Forecast

  • Hours:

    • Scheduled*: The total labour hours scheduled for the period.

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

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

    • Worked*: The total labour hours worked by employees during the period.

    • Breaks*: The total time spent in breaks during the period.

    • Total Paid*: The total labour hours that were paid for the period.

      The total paid hours may or may not include breaks depending on the Default Breaks control and the Payable box on individual time cards.

      Click here to learn how to change whether breaks are payable by default in Time Card Reporting.

    • Variance: The difference between the total paid labour hours and the scheduled labour hours.

      Hours Variance = Hours Total Paid - Hours Scheduled.

  • Cost:

    • Forecast*: The projected cost of labour based on the scheduled hours.

    • Actual*: The actual cost of labour for the period based on time cards recorded.

    • Variance: The difference between the actual and forecasted cost of labour.

      Cost Variance = Cost Actual - Cost Forecast

  • Labour Percent:

    • Forecast*: The projected cost of labour as a percent of sales.

      Labour Percent Forecast = Cost Forecast / Sales Forecast

    • Actual*: The actual cost of labour as a percent of sales.

      Labour Percent Actual = Cost Actual / Sales Actual

    • Variance: The difference between the actual cost of labour as a percent of sales and that projected.

      Labour Percent Variance = Labour Percent Actual - Labour Percent Forecast

  • SPLH:

Report links:

TO VIEW THE VARIANCE IN SCHEDULE BROKEN DOWN BY PERIODS:

  1. Open the Schedule Variance page.

  2. Select the Area* and Store for which you want to view the report from the drop-down list(s).

  3. Select the Period for which you want to view the report from the drop-down list.

  4. Select the specifics of the period* (Date*, Year*, Schedule Week Ending*) from the drop-down list(s).

  5. Click on the Go button.

  6. Click on the Variance by Period tab.

  7. Select the type of periods for which you want to view the report from the Show information in ___ increments drop-down list.

  8. Select the period for which you want to Include Forecast and Schedule for:

    1. Entire Period will include the forecasted amounts for all time periods, regardless if there were actual sales that happened during the period.

    2. Matching Sales Period will remove forecasted amounts for time periods that reported zero sales.

Variance by Period

The following information is displayed in the Variance by Period tab for the Area*, Store and Period selected using the filters Drop-down boxes that let you select from the options available. at the top of the page:

Use the *Show Summary View* or *Show Detailed View* link in the top-left corner of the report to switch between the summary and detailed report.

  • The detailed view of the report includes the figures used to calculate the variance.

Associated Settings

*optional section or field that may or may not be visible depending on the settings selected, whether the supplier is integrated or not, etc.