Forecast Tools

From your

Applies to , ,

Overview

Get more insight into your budget using the forecast tools. Use forecast tools while scheduling to ensure you have the right coverage and are within your labor budget.

Use the forecast data import function to quickly enter forecast information across time.

Considerations

  • By default, supervisors can view and edit projected sales and hours budgets but cannot view daily labor cost. To let a supervisor to see labor costs, allow the supervisor to view employee wages.
  • Overtime wages are not calculated into the labor budget. Overtime wages must be calculated manually.

Sales forecasting

View how much is being spent on labor costs as you schedule. Input projected sales to get a labor expenses to projected sales ratio. If you’re working in a past week, Sales Budget become Actual Sales.

  1. Click Calendar Scheduler.

  2. Switch on Forecast Tools on the left side of the scheduler. Alternatively, click the hour totals below an employee’s name on the left side of the schedule.
  3. Click the Forecast By menu, then select ‘Sales’.
  4. For current and future weeks, enter your Sales Budget and Labor % Target. Your sales budget and labor costs calculate your Assigned Labor.
    1. Sales Budget: Your daily predicted revenue. The weekly total sales budget appears when entering your daily totals.
    2. Labor % Target: Your target percentage of labor/wages compared to your sales budget. Your weekly average appears based on the daily percentages that are entered.
    3. Assigned Labor: The actual percentage of labor/wages compared to your sales budget. The difference between the target percentage and assigned percentage displays in dollars.

Weekly projections

As you enter your sales figures into the forecast tool, your Weekly Projections are calculated.

View labor costs for individual employees

  1. Click Calendar Scheduler.

  2. Switch on Forecast Tools on the left side of the scheduler. Alternatively, click the hour totals below an employee’s name on the left side of the schedule.
    Each individual employee’s labor costs appear below their names.

Forecast by hours

View whether or not you are over or under your labor budget based scheduled hours. If you’re working in a past week, Weekly Hours Budget becomes Actual Budget.

  1. Click Calendar Scheduler.

  2. Switch on Forecast Tools on the left side of the scheduler. Alternatively, click the hour totals below an employee’s name on the left side of the schedule.
  3. Click the Forecast By menu, then select ‘Hours’.
  4. For current and future weeks, enter your Hours Budget.

    1.  Hours Budget: The budgeted number of total scheduled hours per day. The weekly hours budget is calculated as daily hours budget is entered.
    2. Combined Hours: The actual total hours of the published and unpublished shifts in the scheduler. The difference between the daily hours budgeted and the actual scheduled hours displays.

Weekly hours variance

As you enter your hours budget into the tool, your Hours Variance is calculated.

Forecast by custom units

Create a custom unit to forecast the shift or hours needs for your organization. Custom forecast units calculate the number of shifts or hours to target while scheduling.

Add custom units

  1. Click Calendar Scheduler.

  2. Switch on Forecast Tools on the left side of the scheduler. Alternatively, click the hour totals below an employee’s name on the left side of the schedule.
  3. Click the Forecast By menu, then select ‘+ Add Custom Unit’.
    The custom unit configuration screen appears.
  4. Enter a unit name.
  5. Choose how to track coverage:

    • By number of shifts per position
    • By number of hours per position
  6. Enter the units and shifts or hours to convert your unit to the desired number of shifts or hours by position.NOTE: When ‘by number of shifts per position’ is selected, rounding options for calculating coverage appears. Choose to round up, round to nearest, or round down. Hours will always be rounded to 2 decimal places.
  7. (Optional) Click ‘+ Add Another Position’ to add additional positions for the set units.
  8. Click Save to save the custom unit.

Forecast by units

  1. Click Calendar Scheduler.

  2. Switch on Forecast Tools on the left side of the scheduler. Alternatively, click the hour totals below an employee’s name on the left side of the schedule.
  3. Click the Forecast By menu, then select your custom unit.
  4. For current and future weeks, enter your Projected Units.
  5. If forecasting by number of shifts per position:
    1. Projected Units: Your projected units entered calculates how many shifts are required per position.
    2. Position Name: The position row displays scheduled shifts over the total shifts per projected units.
  6. If forecasting by number of hours per position:
    1. Projected Units: Your projected units entered calculates how many hours are required per position.
    2. Position Name: The position row displays scheduled hours over the total hours per projected units.

Import forecast data

Import your sales and hours data into the forecast tool.

  1. Click Calendar Scheduler.

  2. Switch on Forecast Tools on the left side of the scheduler. Alternatively, click the hour totals below an employee’s name on the left side of the schedule.
  3. Click Import Forecast Data.
  4. Click Download our Template. Enter dates, sales and hours information into the template.
    NOTE: Values need to be entered as integers and can include decimals. Sales values can include dollar signs and commas.
  5. Click Upload File. Select and upload your spreadsheet file.
  6. Match the spreadsheet fields then click Continue.
  7. Resolve any errors. An error message displays in the following cases:
    • File size exceeds 8 MB
    • File is not CSV, XLS and XLSX
    • Uploading more than one file at a time

    If needed, click Upload New File to choose a new file.

  8. Click Import.
Updated on May 4, 2022

Was this article helpful?

Related Articles

Still Need Help?

Open a ticket with our customer care team.

Submit a Ticket