Activity-Based Scheduling gives managers the ability to base their Labor % on projected sales for their specific department sales and allows for a per schedule analysis to cut labor expense. For example, this would be useful if you were writing a BOH schedule and wanted to only see the generated sales projections, which would only reflect the Food departments.
Activity-Based Scheduling allows the manager more control of having the right people on staff, to calculate an accurate server to customer ratio, and to analyze the anticipated sales, down to each department.
Schedule Forecasts
Consider the scenario where a manager wants the Kitchen and Server schedules to be based on different department sales.
- The table below lists three departments, the department sales, and an “X“ indicating if that department will be included in a schedule’s projection metrics.
- The sum of all department sales will equal the total sales for the entire store.
- Each schedule sales value will be less than or equal to the store-wide sales.
Department | Department Sales | Kitchen Schedule | Server Schedule |
|---|---|---|---|
Food | $1000 | X | X |
Liquor | $500 | X | |
Catering | $250 | X | |
Total Sales | $1750 | $1250 | $1500 |
- Instead of using department sales directly, our system calculates averages over 6 weeks, ending with the last date of recorded sales.
- An average is calculated for each day of the week. For example, an average will be calculated for 6 Mondays in a row.
- For each day of the week grouping, we remove outliers that are more than one standard deviation away from our mean.
Labor Departments
The departments are configured using the Labor Setup page in Decision Logic:
- Once these departments are configured in Labor Setup, it’s time to create a schedule.
- When a new schedule is created, the projections panel at the bottom of the page will then display the Schedule Sales.
- These are the sum of the sales that are determined by how the Labor schedule's departments have been set up.
- Toggling the “All Schedules” switch will display the store-wide sales instead.
If you do not want to manually update the Sales Forecasts, then you can select Generate sales, and all projected sales will be used.
Labor Forecasting:
- Updating the Targeted Sales on the Sales Forecasting page will affect all schedules.
- When a Target Sales value is set for a day, a department sales override value is created for each department.
- This generated amount is proportional to the percent that the department sales make of the store’s total sales.
Department | Department Sales | Department Sales Override |
|---|---|---|
Food | $1000 | (1000 / 1750) * 2000 = $1142.86 |
Liquor | $500 | (500 / 1750) * 2000 = $571.43 |
Catering | $250 | (250 / 1750) * 2000 = $285.71 |
Total Sales | $1750 | $2000 |
When viewing the Projections section at the bottom of Labor Scheduler, the Schedule Sales values will update accordingly:
Department | Department Sales Override | Kitchen Schedule | Server Schedule |
|---|---|---|---|
Food | $1142.86 | X | X |
Liquor | $571.43 | X | |
Catering | $285.71 | X | |
Total Sales | $2000 | $1428.57 | $1714.29 |
Table of Contents
For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Help Center.