How do I enable Activity Based Forecasting for labor scheduling?
This article provides recommendations to managers on forecasting schedules and labor.
Overview
Activity-Based Forecasting allows managers to base their Labor % on projected sales for their specific department sales and allows for a per-schedule analysis to cut labor expenses. For example, this would be useful if you were writing a Back-of-House (BOH) schedule and wanted to see the generated sales projections, which would only reflect the Food departments.
Activity-Based Forecasting helps managers have the right people on staff, calculate an accurate server-to-customer ratio, and analyze the anticipated sales for each department. Forecasted sales can be displayed as Net Sales (same as gross sales) or Net-Net Sales (traditional net sales view).
Enable Activity Based Forecasting
Managers can enable sales departments on each employee schedule to allocate which sales will impact the projections of those schedules when creating a schedule.
Begin by navigating to:
Operations > Labor Scheduling > Labor Setup
Click the Activity Based Forecasting tab.
Select a Store if you have access to multiple locations.
Select a Schedule Type.
Select a Sales Type. This is how labor projections will be taken into account and displayed on the projections table.
Check the box by clicking the Sales Department(s) that will impact the selected Schedule Tyype.
Uncheck the box to remove or disable the sales department.
Labor Forecasting
The projections table appears on the Labor Scheduler feature at the bottom of the schedule. As shifts are added or edited, the projections table updates for each schedule type to the appropriate sales department.
Updating the Targeted Sales on the Sales Forecasting page will affect all schedules. When a Target Sales value is set for a day (Monday, Tuesday, etc.), a “Department Sales Override” value is created for each department (food, liquor, etc.).
This generated amount is proportional to the percent that the department sales make of the store’s total sales. For example, if Food Department is initially projected to be 60% of sales, then when the sales projection is overwritten, the food department will be calculated to still be 60% of 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 the 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 |
Scenario Example
© 2023 Knowledge Management Systems, LLC. Decision Logic. All Rights Reserved.
Table of Contents
For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Service Center.