Forecast Tools

From your

Applies to , ,

Overview

Get more insight into your budget while scheduling using the forecast tools. Track the sales and hours budget for your schedules to ensure you have the right coverage and are within your labor budget.

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

This feature is being rolled out to eligible accounts over time. Contact us with questions.

Considerations

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. Weekly 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 Total: 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.

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: Hours and sales 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 November 20, 2019

Was this article helpful?

Related Articles

Still Need Help?

Open a ticket with our customer care team.

Submit a Ticket