How do I view hourly sales & labor in the Labor SvA report?

This article provides steps to locate the hourly breakdown in our Labor SvA report.

Overview

Decision Logic provides users an hourly breakdown of labor and sales in our Labor SvA report to support operators in analyzing sales forecasting and scheduling.

Users can view how each hour of the day contributes to overall labor.

Video

Check out this short video for Single-Store Users or keep scrolling to read all the details!

Best Practice

To gain the most insight and accuracy to hourly Labor SvA reporting, Decision Logic recommends that users:

Create and use hourly labor templates, including managers' hours if applicable.
Schedule employees through our Labor Scheduler.
Forecast sales when creating schedules.

Table of Contents

1 Overview
2 Video
3 Best Practice
4 View Report
5 Sales Category & Calculations
6 Hours Category & Calculations
7 Labor % Category & Calculations
8 Accumulated View

For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Service Center.

View Report

Begin by logging into the Decision Logic web application and navigating to:

Reports > Labor > Labor SvA

Select the Company, Region, and Area.
Select one Store. Only one store can be selected when intended to view data by the hour.
Select View by Hour from the dropdown.
1. Users can toggle Include All Jobs if they want to include them in the results.
Select a single Date.
1. Un-toggle Enforce Weeks to select an individual date.
2. The green dot under a date represents the beginning of a store’s labor calendar.
3. Period Start is the beginning of that store’s period.
Click Apply.

Data is categorized into three main sections:

Sales
Hours
Labor %

Sales Category & Calculations

The sales category provides data for forecasted sales, actual sales, and the variance between forecasted and actual sales. The data is then broken down by the hour when selected "View By Hour." Sales will change throughout the day as more people purchase at the selected store.

Additionally, the side panel shows an overview of that day's total forecasted and actual sales.

Column Title	Calculation
Forecasted	No calculation. The prediction of sales displayed by the hour.
Actual	No calculation. The actual sales at that particular store are displayed by the hour.
Variance	Difference between forecasted sales and actual sales.

Hours Category & Calculations

The ‘hours' category provides data on scheduled hours, actual hours, ideal hours, scheduled variance, and ideal variance. Each column displays data for each hour of sales. Hours will change throughout the day as employees clock in and out of their shifts. The side panel will provide a total for each column within the Hours section and users can toggle between Hours and Dollars. The default is 'Hours.’

Brands will need to utilize hourly labor templates for the Ideal column to populate. Include all jobs if you want that data displayed. By default, only jobs marked “include” in POS Admin will be shown.

Ideal labor hours based on what is defined in Labor Templates.

Labor % Category & Calculations

The labor % category provides data in percentages for scheduled, actual, and variance between scheduled and actual. The side panel will provide a total for each column within the Labor % section and includes Overtime displayed in Hours and Dollars. The default is ‘Hours.’

Column Title	Calculation
Scheduled	Forecasted sales ($) / scheduled labor dollars ($)
Actual	Actual sales ($) / actual labor dollars ($)
Variance	Difference between scheduled and actual labor %.

Accumulated View

Users can see an accumulated view, or rollup, of sales, hours, and labor % throughout the day. Simply toggle “View by Accumulated.”