Reporting Explained: Product Mix
The Product Mix report displays sales data for POS items associated with a recipe or item in Yellow Dog.
By default, the report includes only mapped POS items. Items that are not mapped to a recipe or item appear in the report only when Include Unmapped Sales is selected.
You can generate the report in multiple formats:
-
Itemized
-
By COGS Account
-
By COGS Account & Day
-
By Day
-
By Item & Day
Generate the report
Go to Reports > Standard Reports.
Select F&B > Sales > Product Mix.
Configure the required filter.
Apply optional filters if needed.
Run the report.
Required filter
Date/Time – Select the reporting period.
Optional filters
Stores – Includes all stores by default.
COGS Accounts – Includes all accounts by default.
Event Tags – No tags selected by default.
Note: Event tags are not associated with the concessions workflow.
Combine Stores – Consolidates results across selected stores.
Include Ignored – Includes items marked as Ignored in the POS Item Map.
Include Unmapped Sales – Includes POS items that are not mapped to a recipe or item.
|
Column |
Description |
|
POS Item |
Item name provided by the point-of-sale system. |
|
Total Retail |
Quantity sold × retail price recorded on the sales check. |
|
Total Discount |
Quantity sold × item discount recorded on the sales check. |
|
Total Net Retail |
Total Retail − Total Discount. |
|
Total Cost |
Quantity sold × calculated cost at the time of sale. |
|
Net Profit |
Total Net Retail − Total Cost. |
|
Net Cost Percent |
Total Cost ÷ Total Net Retail. |
|
Assigned To |
Recipe or item associated with the POS item in Yellow Dog. |