Budget and Forecast Metrics Comparison (Table Service Restaurant, Inclusive Tax)

Operations performance report that shows sales and operating metrics.

Description

The Budget and Forecast Metrics Comparison report is an operations performance report that consists of multi-KPI tiles and a table that compare sales and operating metrics with uploaded budget and forecast tools. This report is for table service restaurants with inclusive taxes.

Permission: Sales and Operations.

Report Tags

Simphony, RES 3700, e7, Inclusive Tax, and Table Service.

Budget Variance Totals

Visualization: Multi-KPI tile.

Permission: Sales and Operations.

Table 4-8 Budget Variance Totals

Category	Data Format	Description
Sales Net VAT Percent	Percent	Budget sales net VAT percent
Check Count Percent	Percent	Budget check count percent
Guest Count Percent	Percent	Budget guest count percent
Table Turns Percent	Percent	Budget table turns percent

Forecast Variance Tools

Visualization: Multi-KPI tile.

Permission: Sales and Operations.

Table 4-9 Forecast Variance Tools

Category	Data Format	Description
Sales Net VAT Percent	Percent	Forecast sales net VAT percent
Check Count Percent	Percent	Forecast check count percent
Guest Count Percent	Percent	Forecast guest count percent
Table Turns Percent	Percent	Forecast table turns percent

Budget Comparison by Location, Revenue Center, and Business Date

Visualization: Table.

Permission: Sales and Operations.

Table 4-10 Budget Comparison by Location, Revenue Center, and Business Date

Category	Data Format	Description	Drill-Down Report
Total Row		The top row of the table shows totals for each category
Name	String	Name of location, revenue center, or business date
Sales Net VAT	Currency	Sales net VAT	Total drills down to Sales Net VAT
Budgeted Sales Net VAT	Currency	Budgeted sales net VAT
Sales Net VAT Variance Percent	Percent	Percent of variance between actual sales net VAT and budgeted sales net VAT
Check Count	Integer	Actual number of checks	Total drills down to Checks
Budgeted Check Count	Integer	Budgeted number of checks
Check Count Variance Percent	Percent	Percent of variance between actual check count and budgeted check count
Guest Count	Integer	Actual number of guests	Total drills down to Guests
Budgeted Guest Count	Integer	Budgeted number of guests
Guest Count Variance Percent	Percent	Percent of variance between actual guest count and budgeted guest count
Table Turns	Integer	Actual number of table turns	Total drills down to Tables
Budgeted Table Turns	Integer	Budgeted number of table turns
Table Turns Variance Percent	Percent	Percent of variance between actual table turns and budgeted table turns

Forecast Comparison by Location, Revenue Center, and Business Date

Visualization: Table.

Permission: Sales and Operations.

Table 4-11 Forecast Comparison by Location, Revenue Center, and Business Date

Category	Data Format	Description	Drill-Down Report
Total Row		The top row of the table shows totals for each category
Name	String	Name of location, revenue center, or business date
Sales Net VAT	Currency	Sales net VAT	Total drills down to Sales Net VAT
Forecasted Sales Net VAT	Currency	Forecasted sales net VAT
Sales Net VAT Variance Percent	Percent	Percent of variance between actual sales net VAT and forecasted sales net VAT
Check Count	Integer	Actual number of checks	Total drills down to Checks
Forecasted Check Count	Integer	Forecasted number of checks
Check Count Variance Percent	Percent	Percent of variance between actual check count and forecasted check count
Guest Count	Integer	Actual number of guests	Total drills down to Guests
Forecasted Guest Count	Integer	Forecasted number of guests
Guest Count Variance Percent	Percent	Percent of variance between actual guest count and forecasted guest count
Table Turns	Integer	Actual number of table turns	Total drills down to Tables
Forecasted Table Turns	Integer	Forecasted number of table turns
Table Turns Variance Percent	Percent	Percent of variance between actual table turns and forecasted table turns

Report Notes

Variance calculations do not take into account missing or partial days.

Requires data to be uploaded via the Budget Upload Interface and Forecast Upload Interface.