7. How to Schedule Using Forecasts
Video Transcript
If you’ve input your Forecast Sales, your Labour Sales % targets, and your Forecast Hour targets, you can start using them together to help control your labour costs on the Schedule.
If you’re on the Schedule page, there are a number of tools to help you view and control costs as you assign shifts for the week.
To the right of the Schedule we can view the total amount of hours worked per employee. This can be switched to view employee cost by clicking on “Total” and selecting “Employee Cost” from the dropdown.
More cost controls can also be found at the bottom of the Schedule.
Here is the Labour Sales % for the schedule, the labour cost, the scheduled sales per labour hour, the labour hours, and the labour volume, which can all help with managing and controlling labour spend.
If you click into the Labour Sales % tab, you can see forecast or predicted sales for the week. You can also see the Forecast Labour Sales %, both of which come from the Forecast sections where they have been entered previously.
The Sales Forecast and Forecast Labour Sales % numbers are both used to create an Allowed Spend for each day of the week.
And below this you can see the actual costs for the current Schedule as it’s being built.
This number is generated by the hourly pay rates per employee, the hours they have scheduled to work, plus an extra percentage to account for paid time off, PRSI, National Insurance contributions or any other potential costs.
If you wish, you can edit this added on percentage in your Company settings.
Using the Allowed Spend, the Schedule Costs and lastly the Scheduled Labour Sales %, you can see how the current schedule is either meeting or exceeding the required targets for controlling costs.
The next tab underneath the Schedule is the Labour Cost tab. In here you can see a breakdown of how the Schedule cost is made up of hourly and salary staff for each day, and the total for the week. If there are any Overtime hours they will feed in here as well.
The next tab is the Scheduled Sales Per Labour Hour tab. You can see how the target for these numbers are calculated here, from the Gross Sales Forecast and the Hours Forecast that we have for each day.
The numbers at the bottom indicate on which days the current schedule is matching or exceeding these targets, and on which days the current schedule will not meet the target.
So it is clear then on which days the Schedule is working with too many hours of labour. Specifically, we can see Tuesday and Thursday are in the red. So knowing that, and with the information from the Labour Sales % tab as well, it appears likely that we should reduce the hours currently scheduled for those two days.
We can also get similar information if we look at the Labour Hours tab.
We can see clearly here the differences in hours between the Forecast and the current Schedule.
This confirms there are more hours currently scheduled on Tuesday and Thursday than the targets set in the Forecast.
To get more information on where the labour hours can be attributed, click this icon to view a breakdown and comparison of hours per position.
In this example view, we can see the difference between the Forecast and current labour hours, and the attribution of hours to each position. On Tuesday it appears that we have a lot of “Team Member” hours.
To get more information, click into the Labour Volume tab. This shows a view of how many people are working for each hour of the day in each position.
From this view, I may conclude that I should reduce the hours for Team Members between the hours of 10 and 5pm on Tuesday.
If you want to reduce hours on the Schedule, you can choose to delete shifts, or you can click into a shift and change the start or end time. Once you make edits, you will see the numbers will update in each of these tabs.
As a manager, you can change and edit the Schedule many times as you’re building it, and can keep referencing these tabs at the bottom to help you with cost controls.
