Menu item sales summarized and enhanced with detailed financial information (net totals, comps, discounts, tax) per item sold. Menu items are grouped by sales category for selected site(s) within a specified business date range.
Steps:
- Select Site(s) and/or Group(s)
- Set date range for report
- Click Refresh Report
Collapsed view: Shows summarized information for each Sales Category
Image Added
Expanded view: Shows expanded menu item details for the items within each sales category.
Image Added
| 1 | Site(s), Group(s) and Business Date | |
specify date range for report |
| 2 | Sales Category | Sales categories |
configured in ECM | for items sold (Only sales categories with item sales for the site/date range |
will be | are reported); column can be filtered |
| 3 | Quantity | Total quantity of items sold in sales category |
| 4 | Cover Count | Total number of cover counts applied to items in sales category; column can be filtered |
| 5 | Net |
Sales| Sales | Net Sales of sales category (Net sales = Gross |
Sales | sales - Comps - Discounts); column can be filtered |
5| 6 | Comp | Total dollar amount compensated for sales |
category 6 | Discount | category; column can be filtered |
| 7 | Discount | Total discounts applied for sales category |
| 7 | Tax | Total taxes for sales category |
8 | Total | Total dollar amount for items sold in sales category | ; column can be filtered |
| 8 | Gross Sales | Total sales including discounts and comps; column can be filtered |
| 9 | Percentage |
Percentage | Sales Category percentage of total sales |
this category contributes to the total sales | ; column can be filtered |
| 10 | Export Report | Save file in Excel, PDF |
, EXCEL or CSV format - PDF will appear in either expanded or collapsed view, depending on the view shown before exporting to PDF
|
| 11 |
Item | Items sold within the selected category | | 12 | External ID | External code number for Item |
| 13 | Quantity | Quantity of items sold |
| 14 | Net Sales | Net Sales total of item |
| 15 | Comp | Total dollar amount compensated for item |
| 16 | Discount | Total discounts applied to item |
| 17 | Tax | Total taxes for item |
| 18 | Total | Total dollar amount for each item sold |
| 19 | Percentage | Percentage of sales this menu item contributed to the sales category total |
...
| Expand All/Collapse All | Expands or collapses all sales categories to display item detail information or the summarized sales category information |
| Expanded View |
|
| Item | Name of menu item sold |
| External Code | External code for menu item |