Budget and Forecast Metrics Comparison (Quick 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 quick service restaurants with inclusive taxes.

Permission: Sales and Operations.

Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.

Report Tags

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

Budget Variance Totals

Visualization: Multi-KPI tile.

Permission: Sales and Operations.

Table 4-16 Budget Variance Totals

Metric	Data Format	Description
Sales Net VAT Percent	Percent	Budget sales net VAT percent.
Check Count Percent	Percent	Budget check count percent.

Forecast Variance Tools

Visualization: Multi-KPI tile.

Permission: Sales and Operations.

Table 4-17 Forecast Variance Tools

Metric	Data Format	Description
Sales Net VAT Percent	Percent	Forecast sales net VAT percent.
Check Count Percent	Percent	Forecast check count percent.

Budget Comparison by Location, Revenue Center, and Business Date

Visualization: Table.

Permission: Sales and Operations.

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

Metric	Data Format	Description
Total Row	Variable	The top row of the table shows totals for each metric.
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.

Forecast Comparison by Location, Revenue Center, and Business Date

Visualization: Table.

Permission: Sales and Operations.

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

Metric	Data Format	Description
Total Row	Variable	The top row of the table shows totals for each metric.
Name	String	Name of location, revenue center, or business date.
Sale 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.

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.