Daily Operations Location Comparison (Table 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 table service restaurants with add-on taxes.

Permission: Sales and Operations.

Report Tags

Simphony, RES 3700, e7, Add On Tax, and Table Service.

Total Revenue Variance by Sales Metrics

Visualization: Stacked bar chart.

Permission: Sales and Operations.

Table 5-33 Total Revenue Variance by Sales Metrics

Category	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-34 Total Revenue Variance by Operating Metrics

Category	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

Guest Count Variance

Visualization: Bar chart.

Permission: Sales and Operations.

Table 5-35 Guest Count Variance

Category	Data Format	Description
Guest Count	Integer	Number of guests for location on the Y axis
Location	String	Location selection 1 and 2 on the X axis

Check Count Variance

Visualization: Bar chart.

Permission: Sales and Operations.

Table 5-36 Check Count Variance

Category	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

Daily Operations Comparison by Location

Visualization: Multi-grid.

Permission: Sales and Operations.

Table 5-37 Sales Metrics

Category	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-38 Operating Metrics

Category	Location 1 Data Format	Location 2 Data Format	Variance Data Format	Description
Total Revenue	Currency	Currency	Currency and percent	Total revenues shown for location 1 and location 2. Total revenue and variance percent shown for the variance between the locations.
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-39 Tender Media

Category	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-40 Operations

Category	Location 1 Data Format	Location 2 Data Format	Variance Data Format	Description
Guests	Integer and currency	Integer and currency	Integer and currency	Number of guests and average spend of guests
Checks	Integer and currency	Integer and currency	Integer and currency	Number of checks and average spend per check
Table Turns	Integer and currency	Integer and currency	Integer and currency	Number of table turns and average spend per table turn
Average Dining Time	Time	Time	Time	Average dining time
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