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:

Here's a video of how SPLH works:

There are 4 methods to input sales figures.

You can choose to input sales data in 30-minute intervals or Day intervals through the "Mass Update" Button.

To mass upload using CSV

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

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)

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)

You can plan an estimated SPLH and compare that against a target SPLH goal on the Web App Scheduler.

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.

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.

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.

The sales values that we just input are displayed in a graph

To view this graph:

Example of how the graph looks like

Graph Legend

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.

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.

Ensure that staff are scheduled and clock in and out of their shifts to get labour hour figures. Find out more here.

Ensure that you have input actual sales data.

To access the SPLH reports,

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 -