Daily Operations Date Comparison (Table Service Restaurant, Add-On Tax)

Comparison report that shows sales and operating metrics for two dates or date ranges.

Description

The Daily Operations Date Comparison report consists of stacked bar charts, a bar chart, and grids that show sales and operational KPIs between two dates or date ranges 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-1 Total Revenue Variance by Sales Metrics

Category	Data Format	Description
Total Revenue	Currency	Net sales, service charges, and taxes on the Y axis
Business Dates	Date	Date selection 1 and 2 on the X axis

Total Revenue Variance by Operating Metrics

Visualization: Stacked bar chart.

Permission: Sales and Operations.

Table 5-2 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
Business Dates	Date	Date selection 1 and 2 on the X axis

Guest Count Variance

Visualization: Bar chart.

Permission: Sales and Operations.

Table 5-3 Guest Count Variance

Category	Data Format	Description
Guest Count	Integer	Number of guests for date selection on the Y axis
Business Date	Date	Date selection 1 and 2 on the X axis

Check Count Variance

Visualization: Bar chart.

Permission: Sales and Operations.

Table 5-4 Check Count Variance

Category	Data Format	Description
Check Count	Integer	Number of checks for date selection on the Y axis
Business Date	Date	Date selection 1 and 2 on the X axis

Daily Operations Comparison by Date

Visualization: Multi-grid.

Permission: Sales and Operations.

Table 5-5 Sales Metrics

Category	Date Selection 1 Data Format	Date Selection 2 Data Format	Variance Data Format	Description
Total Revenue	Currency	Currency	Currency and percent	Total revenue shown for date selection 1 and date selection 2. Total revenue and variance percent shown for the variance between the dates.
Net Sales	Currency and percent	Currency and percent	Currency and percent	Net sales amount and percent of revenue shown for date selection 1 and date selection 2. Net sales amount and variance percent shown for the variance between the dates.
Gross Sales	Currency	Currency	Currency and percent	Gross sales shown for date selection 1 and date selection 2. Gross sales and variance percent shown for the variance between the dates.
Discount Total	Currency	Currency	Currency and percent	Discount total amount shown for date selection 1 and date selection 2. Discount total amount and variance percent shown for the variance between the dates.
Service Charge Total	Currency and percent	Currency and percent	Currency and percent	Service charge total amount and percent of revenue shown for date selection 1 and date selection 2. Service charge total amount and variance percent shown for the variance between the dates.
Tax Total	Currency and percent	Currency and percent	Currency and percent	Tax total amount and percent of revenue shown for date selection 1 and date selection 2. Tax total amount and variance percent shown for the variance between the dates.

Table 5-6 Operating Metrics

Category	Date Selection 1 Data Format	Date Selection 2 Data Format	Variance Data Format	Description
Total Revenue	Currency	Currency	Currency and percent	Total revenue shown for date selection 1 and date selection 2. Total revenue and variance percent shown for the variance between the dates.
Total Operating Cost	Currency	Currency	Currency and percent	Total operating cost shown for date selection 1 and date selection 2. Total operating cost and variance percent shown for the variance between the dates.
Cost of Goods Sold	Currency and percent	Currency and percent	Currency and percent	Cost of goods sold and percent of net sales shown for date selection 1 and date selection 2. Cost of goods and variance percent shown for the variance between the dates.
Labor Cost	Currency and percent	Currency and percent	Currency and percent	Labor cost amount and percent of net sales shown for date selection 1 and date selection 2. Labor cost and variance percent shown for the variance between the dates.
Total Operating Margin	Currency	Currency	Currency and percent	Total operating margin shown for date selection 1 and date selection 2. Total operating margin and variance percent shown for the variance between the dates.

Table 5-7 Tender Media

Category	Date Selection 1 Data Format	Date Selection 2 Data Format	Variance Data Format	Description
Payment Total	Currency	Currency	Currency and percent	Payment totals shown for date selection 1 and date selection 2. Payment total and variance percent shown for variance between the dates.
Paid In	Currency	Currency	Currency and percent	Paid in totals shown for date selection 1 and date selection 2. Payment total and variance percent shown for variance between the dates.
Paid Out	Currency	Currency	Currency and percent	Paid out totals shown for date selection 1 and date selection 2. Payment total and variance percent shown for variance between the dates.

Table 5-8 Operations

Category	Date Selection 1 Data Format	Date Selection 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