Daily Operations Location Comparison (Quick Service Restaurant, Add-On Tax)

Comparison report that shows sales and operating metrics for two locations.

Description

The Daily Operations Location Comparison report consists of stacked bar charts, a bar chart, and grids that show sales and operational KPIs between two locations and calculates the variance. This report is for quick service restaurants with add-on 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, Add On Tax, and Quick Service.

Total Revenue Variance by Sales Metrics

Visualization: Stacked bar chart.

Permission: Sales and Operations.

Table 5-49 Total Revenue Variance by Sales Metrics

Metric	Data Format	Description
Total Revenue	Currency	Net sales, service charges, and taxes on the Y axis.
Locations	String	Location selection 1 and 2 on the X axis.

Total Revenue Variance by Operating Metrics

Visualization: Stacked bar chart.

Permission: Sales and Operations.

Table 5-50 Total Revenue Variance by Operating Metrics

Metric	Data Format	Description
Total Revenue	Currency	Operating margin, labor cost, and cost of goods sold on the Y axis.
Locations	String	Location selection 1 and 2 on the X axis.

Check Count Variance

Visualization: Bar chart.

Permission: Sales and Operations.

Table 5-51 Check Count Variance

Metric	Data Format	Description
Check Count	Integer	Number of checks for location on the Y axis.
Location	String	Location selection 1 and 2 on the X axis.

Average Speed of Service Variance

Visualization: Bar chart.

Permission: Sales and Operations.

Table 5-52 Average Speed of Service Variance

Metric	Data Format	Description
Average Speed of Service	Time Duration	Sum of expediter station times ÷ sum of service rounds. Average speed of service on the Y axis.
Location	String	Location selection 1 and 2 on the X axis.

Daily Operations Comparison by Location

Visualization: Multi-grid.

Permission: Sales and Operations.

Table 5-53 Sales Metrics

Metric	Location 1 Data Format	Location 2 Data Format	Variance Data Format	Description
Total Revenue	Currency	Currency	Currency and percent	Total revenue shown for location 1 and location 2. Total revenue and variance percent shown for the variance between the locations.
Net Sales	Currency and percent	Currency and percent	Currency and percent	Net sales amount and percent of revenue shown for location 1 and location 2. Net sales amount and variance percent shown for the variance between the locations.
Gross Sales	Currency	Currency	Currency and percent	Gross sales shown for location 1 and location 2. Gross sales and variance percent shown for the variance between the locations.
Discount Total	Currency	Currency	Currency and percent	Discount total amount shown for location 1 and location 2. Discount total amount and variance percent shown for the variance between the locations.
Service Charge Total	Currency and percent	Currency and percent	Currency and percent	Service charge total amount and percent of revenue shown for location 1 and location 2. Service charge total amount and variance percent shown for the variance between the locations.
Tax Total	Currency and percent	Currency and percent	Currency and percent	Tax total amount and percent of revenue shown for location 1 and location 2. Tax total amount and variance percent shown for the variance between the locations.

Table 5-54 Operating Metrics

Metric	Location 1 Data Format	Location 2 Data Format	Variance Data Format	Description
Total Operating Cost	Currency	Currency	Currency and percent	Total operating cost shown for location 1 and location 2. Total operating cost and variance percent shown for the variance between the locations.
Cost of Goods Sold	Currency and percent	Currency and percent	Currency and percent	Cost of goods sold and percent of net sales shown for location 1 and location 2. Cost of goods and variance percent shown for the variance between the locations.
Labor Cost	Currency and percent	Currency and percent	Currency and percent	Labor cost amount and percent of net sales shown for location 1 and location 2. Labor cost and variance percent shown for the variance between the locations.
Total Operating Margin	Currency	Currency	Currency and percent	Total operating margin shown for location 1 and location 2. Total operating margin and variance percent shown for the variance between the locations.

Table 5-55 Tender Media

Metric	Location 1 Data Format	Location 2 Data Format	Variance Data Format	Description
Payment Total	Currency	Currency	Currency and percent	Payment totals shown for location 1 and location 2. Payment total and variance percent shown for variance between the locations.
Paid In	Currency	Currency	Currency and percent	Paid in totals shown for location 1 and location 2. Payment total and variance percent shown for variance between the locations.
Paid Out	Currency	Currency	Currency and percent	Paid out totals shown for location 1 and location 2. Payment total and variance percent shown for variance between the locations.

Table 5-56 Operations

Metric	Location 1 Data Format	Location 2 Data Format	Variance Data Format	Description
Checks	Integer and currency	Integer and currency	Integer and currency	Number of checks and average spend per check.
Parked Cars	Integer	Integer	Integer	Number of parked cars.
Average Speed of Service	Time	Time	Time	Sum of expediter station times ÷ sum of service rounds.
Returns	Currency and integer	Currency and integer	Currency and integer	Return monetary amount and count.
Voids	Currency and integer	Currency and integer	Currency and integer	Void monetary amount and count.
Cancels	Currency and integer	Currency and integer	Currency and integer	Cancels monetary amount and count.
Error Corrects	Currency and integer	Currency and integer	Currency and integer	Error corrects monetary amount and count.
Regular Pay	Currency and time	Currency and time	Currency and time	Regular pay monetary amount and hours.
Overtime Pay	Currency and time	Currency and time	Currency and time	Overtime pay monetary amount and hours.
Sales per Labor Hour	Currency	Currency	Currency	Sales per labor hour monetary amount.
Average Hourly Pay	Currency	Currency	Currency	Average hourly pay monetary amount.