The Location Comparison report compares the performance of multiple restaurant locations based on selected operational values. This report allows restaurant owners and managers to analyze various key performance indicators (KPIs), such as gross or net sales, guest counts, and labor hours across locations. The purpose of this report is to identify which locations are performing well and which may need improvement. By comparing locations, managers can pinpoint best practices, address underperforming areas, and make data-driven decisions to optimize operations and drive business success. Cells highlighted in yellow indicate that a location is performing below average.
.png "image(666).png")
Navigation
In the Reports section of the left navigation pane, select My Reports.
The My Reports screen appears.At the top of the My Reports screen, select Op.Analysis.
The screen generates a list of reports in alphabetical order.Locate the Location Comparison report.
Select Customize to adjust the report parameters and run the report.
Report Parameters
.png "image(663).png")
Field | Description | |
|---|---|---|
1 | Value (Limit 3) | Allows the user to select up to three sales and/or labor values to compare against other locations. |
2 | Date Range | If set to Yes, the user can select a Start and End date to create a date range for the report. If set to No, the user can select an As Of date to set a specific date for which to run the report. |
3 | As Of / Start / End | Dates for which to run the report. If Date Range is set to Yes, the Start and End date fields appear, allowing the user to run the report for a range of dates. If Date Range is set to No, only the As Of field appears, allowing the user to select a specific date for the report. |
4 | Filter By | A list of all filter categories. Filter categories will vary based by report. |
5 | Filter | A list of filter options, determined by the 'Filter By' category selected (#1). |
6 | Time Frame | Allows the user to run the report by day, week, period, quarter, or year. |
7 | Compare Value | Depending on the selection, the report compares data based on actuals, variances, or variance percentages. |
8 | Subtotal By | |
9 | View options | This section provides options to select, save, edit, or delete a report view. |
10 | Run | Generates the report. Click the down arrow to the right of the Run button to export, email, or print the report. |
Report Columns
.png "image(665).png")
Column | Description |
|---|---|
Value | Each box compares each location’s performance metrics for the selected value. The box header, highlighted in blue, shows which value is represented. |
Location | Name of the location for which data appears across the row. |
Current | This column displays each location’s metrics for the selected day, week, period, quarter, or year, based on the selected Compare Value (actuals, variances, or variance percentages). |
Prior | This column displays each location’s metrics the previous day, week, period, quarter, or year, based on the selected Compare Value (actuals, variances, or variance percentages). |
Prior Yr | This column displays each location’s metrics the for the same day, week, period, quarter, or year of the previous year, based on the selected Compare Value (actuals, variances, or variance percentages). |
Email, Export, or Print the Report
This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.