All Collections
SPLH: Sales based Scheduling
SPLH: Sales based Scheduling

Reduce manual admin work generating SPLH reports

StaffAny avatar
Written by StaffAny
Updated over a week ago

Contents of this article are applicable to the following users


Platform: Mobile/Web

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.

Estimated SPLH

Target Sales / Scheduled Hours

Target SPLH

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

  1. In the Web App, go to “Reports” > Sales vs Labour Hours > “ Mass Update Sales

  2. 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.

  1. In the Web App > go to “Schedule”

  2. 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:

  1. In the web app, go to “Schedule” > Change the view to “ Day View”

  2. Click on "Show" at the bottom of the page

Example of how the graph looks like

Graph Legend

  1. Area chart for number of staff working (Translucent Green)

  2. Target Sales (dotted orange line)

  3. 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.

Checking Report

To access the SPLH reports,

  1. 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 -

Column Name



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

Total Hrs

Actual Labour Hours

Sched Hrs

Scheduled Labour Hours

Labour Variance

Total Hrs - Sched Hrs


Actual Sales / Total Hrs

Target SPLH

A target that you key in for SPL

Did this answer your question?