Contents of this article are applicable to the following users
Tier: GROWTH, SCALE
Access Level: Owner, Manager
This article is about using actual or target sales (a.k.a predicted sales) and the Sales Per Labour Hour (SPLH) to optimise manpower planning according to store demand. With this tool, you can reduce and save on extra labour costs!
This guide will cover the following:
1. Terms & Definitions
Actual Sales / Total Hrs
SPLH (Sales per Labour Hour) is a measure of how productive your staff is. StaffAny can help you align your time and save time to plan against SPLH targets, and report on SPLH goals.
Target Sales / Scheduled Hours
User defined target
2. Inputting Actual & Target Sales
There are 4 methods to input sales figures.
Method 1: Using CSV to mass upload
You can choose to input sales data in 30-minute intervals or Day intervals through the "Mass Update" Button.
To mass upload using CSV
In the Web App, go to “Reports” > Sales vs Labour Hours > “ Mass Update Sales”
Select either '30 min-intervals' or 'day level intervals'
After downloading the file, input your actual & target sales data in the columns > save > upload the file
Note: We currently support mass update in 30 min intervals only, as it is most beneficial for optimizing schedules. However if you wish to input only day level intervals, you may still do so from the main reports page (see method 2).
Method 2: Adding from the Reports Page
You can directly input your sales values straight from the Reports Page. Only Actual Sales, Target Sales and Target SPLH columns are editable.
Click on the highlighted portions to update
Note: Day level values will be parked under the 12:00 PM mark on the day.
For example, if you add $1000 as the day value, it will be stored as $1000 at the 12:00 PM mark. (check the image below to visualise)
In order to correctly spread it throughout the day, you need to input in 30-min intervals. (see below image)
Note: When modifying the day level value, we divide and spread the new value across the existing 30 min intervals. (check the image below to visualise)
Method 3: Adding SPLH in Schedule Page
You can plan an estimated SPLH and compare that against a target SPLH goal on the Web App Scheduler.
In the Web App > go to “Schedule”
open the SPLH footer > key in the Target Sales to get your estimated SPLH
After keying in Target sales, the Estimated SPLH per day will be automatically computed on the SPLH footer.
This cell indicates the weekly estimate SPLH
This cell indicates the daily estimated SPLH
You can also set target SPLH goals in the SPLH footer.
If the daily estimated SPLH is green, you have hit your labour productivity goals (Estimated SPLH > Target SPLH)
If the daily estimated SPLH is red, it means you have missed your labour productivity goal (Estimated SPLH < Target SPLH) and you have to either schedule less staff or hit more sales.
Break time affecting SPLH
SPLH can also be affected by the break times. Staff who are on break will not be reflected in the SPLH footer since they are not on duty for that break period.
This correlates with the decrease wages and staff hours for the given period.
The manpower area chart will also be affected when staff goes on break.
During the periods where staff is scheduled for break, the area chart would reflect a dip. Similarly, there would also be a dip in the line graphs representing actual sales and target sales.
Method 4: Add Actual Sales from Mobile App
You can also key in your Actual Sales figures via the Mobile App on the "Store" page.
Note: On Mobile App, you can only add and edit the Actual Sales, you will need to access our Web App to add or amend any other fields.
3: Scheduling with Sales Data
The sales values that we just input are displayed in a graph
To view this graph:
In the web app, go to “Schedule” > Change the view to “ Day View”
Click on "Show" at the bottom of the page
Example of how the graph looks like
Area chart for number of staff working (Translucent Green)
Target Sales (dotted orange line)
Actual Sales (solid green line)
Hovering over the graphs will show a tooltip with more details.
From these visuals, you can also run a comparison between actual and target sales and how well the outlet performed.
Example: the following image shows that throughout the day, the outlet is not hitting its targets.
Example: the following image shows that throughout the day, the outlet is hitting its targets.
4. Viewing Sales and SPLH reports
You can also generate reports on your actual SPLH. To do so, you must get labour hour attendance data and sales data into the system.
Getting Attendance Data
Ensure that staff are scheduled and clock in and out of their shifts to get labour hour figures. Find out more here.
Getting Sales Data
Ensure that you have input actual sales data.
To access the SPLH reports,
Go to “Reports” > “Sales vs Labour Hours” > Select Date and Section > “ Export”
The report will reflect results based on the date range and section selected.
Example of how the report would look like:
Refer to the below table for an in-depth explanation of each column -
Date for SPLH report
Actual Sales ($)
Actual Sales for this section for this date
Target Sales ($)
Target Sales for this section for this date
Sales Variance ($)
Actual Sales - Target Sales
Actual Labour Hours
Scheduled Labour Hours
Total Hrs - Sched Hrs
Actual Sales / Total Hrs
A target that you key in for SPL