Menu Mix

The Menu Mix data set enables you to build tabs to view your key item and category sales data elements, such as Item Sales, Item Count, Item Price, and Item Cost. Menu Mix contains the standard ‘group by levels’, such as Area, Region, and Store, with additional ‘group by levels’ to group your data by Category and Item and drill all the way down to the check detail level.

When viewing Menu Mix drilldown pages at the Category level, you can include non-sales categories, denoted with an asterisk. If you include non-sales categories, the item sales totals displayed on the Dynamic Drilldown Viewer page may be incorrect. When viewing non-sales categories, items may be included in the calculations more than once.

		Figure 9 Include Non-Sales Categories

When viewing a Menu Mix drill down page at the Item level, you have the option to include item modifiers in the view.

		Figure 10 Show Item Modifiers Enabled

Menu Mix Data Elements

Data Element	Definition	Group By Levels
All Item Count	The count of all items sold on a check.	Check
All Item Sales	The price sum of all items sold on a check.	Check
Check Number	The check ID number.	Check
Close Time	The time when the check was closed.	Check, Check Detail
Comp Count	The total count of all comps.	Check, Check Detail
Comp Dollars	The total dollar amount of all comps.	Check, Check Detail
Employee ID	The employee identification number, as configured in Aloha Manager.	Check Detail
Employee Name	The name of the selected employee, as configured in Aloha Manager. (last, first)	Check, Check Detail
Gross Sales	The total amount of item sales including order mode charges, surcharges, and all taxes.	Check, Check Detail
Guest Count	The total number of guests during the specified period.	Check, Check Detail
Item Cost	The cost of the items, as defined in Aloha Manager.	Region, Area, Store Group, Store, Category, Sales Item, Revenue Center, Date of Business, Day Part, Order Hour, Order Mode, Check, Check Detail
Item Cost Percent of Sales	The item cost divided by item sales.	Region, Area, Store Group, Store, Category, Sales Item, Revenue Center, Date of Business, Day Part, Order Hour, Order Mode, Check, Check Detail
Item Count	The total count of all menu items sold.	Region, Area, Store Group, Store, Category, Sales Item, Revenue Center, Date of Business, Day Part, Order Hour, Order Mode, Check, Check Detail
Item Count Percent	The item count divided by total item count.	Region, Area, Store Group, Store, Category, Sales Item, Revenue Center, Date of Business, Day Part, Order Hour, Order Mode, Check
Item ID	The menu item identification number.	Check Detail
Item Name	The menu item name, as configured in Aloha Manager.	Check Detail
Item Price	The price of the item on the check.	Check Detail
Item Sales	The price of the item only, which includes inclusive taxes. Item sales does not include exclusive taxes, promos, and comps.	Region, Area, Store Group, Store, Category, Sales Item, Revenue Center, Date of Business, Day Part, Order Hour, Order Mode, Check
Item Sales Average	The item sales divided by item count.	Region, Area, Store Group, Store, Category, Sales Item, Revenue Center, Date of Business, Day Part, Order Hour, Order Mode, Check
Item Sales Percent	The item sales divided by total item sales.	Region, Area, Store Group, Store, Category, Sales Item, Revenue Center, Date of Business, Day Part, Order Hour, Order Mode, Check
Net Sales	The total amount of item sales including order mode charges, less surcharges, inclusive tax, comps, and promos. NOTE: The formula can be changed by including or excluding comps and promos in Company Setup.	Check, Check Detail
Open Time	The time when the check was opened.	Check, Check Detail
Order Mode Charges	The surcharge collected for a certain order mode, such as delivery charges.	Check, Check Detail
Order Time	The time when the item was ordered on the check.	Check Detail
Percent Net Sales	The percentage of net sales from the selected group by to the grand total net sales. As an example, if “Area” is the selected group by, then net sales from the stores in each area will be divided by the net sales from all stores.	Check
Percent Straight To Net Sales	The percent of straight sales to the check net sales. Straight Sales / Check total Net Sales.	Check Detail
PPA	The per person average dollar amount based on the “PPA Method” selected from Company Setup in Aloha Insight divided by the number of guests.	Check, Check Detail
Promo Count	The total count of all promotions.	Check, Check Detail
Promo Dollars	The total dollar amount of all promotions.	Check, Check Detail
Straight Sales	The total dollar amount of items sold, including inclusive taxes and refunds.	Check, Check Detail
Surcharge Dollars	The additional service charges collected from the customer.	Check, Check Detail
Tax Dollars	The tax dollar amount collected from the customer; this amount is included in gross sales and excluded from net sales.	Check, Check Detail
Tender Type	The name of the tender, as defined in Aloha Manager. Example: Cash, Visa, MC	Check Detail