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. |
Related Articles
Reporting Explained: Actual Vs Theoretical By Level By Department, Sub Department
Business Need: This report is helpful for users who want a report to show the actual cost during a time period versus the theoretical cost. This report is summarized by sub department rather than by individual item or department. This report also ...Reporting Explained: ReOrder
Reporting Explained: Re-Order Business Need: This report will show items that are either at or below the re-order point assigned, and include the quantities needed to bring the items back up to Par. How it works: To best utilize this report users ...Reporting Explained: Summary By Period
The Inventory Summary by Period report provides an overview of inventory activity for a selected date and time range. It shows the starting inventory cost, all inventory movements during the period, and the ending inventory cost. Reports > Standard ...Reporting Explained: Invoice Records
Use the Invoice Records report to review all invoices within a selected time period. The report helps your team verify invoice status, quantities, and costs. Reports > Standard Reports > Purchasing > Invoice Records The Invoice Records report lists ...Reporting Explained: Sales By Day
Business Need: This report is helpful for users who want a summary of sales by location over a period. How it Works: A Sales>By Item report shows a summary of sales for your stores in Yellow Dog. Generating the Report: Go to the Standard Reports ...
Popular Articles
How To: Find Your Yellow Dog Inventory Version
Understanding which version of Yellow Dog Inventory you're using is essential when exploring new features, as some enhancements and functionalities are specific to certain versions. All client types can benefit from knowing their Yellow Dog Inventory ...Feature Overview: Par & Re-Order Points
Par levels and reorder points help streamline purchasing in Yellow Dog. Par level is the ideal quantity to keep on hand. Reorder point is the minimum quantity that triggers reordering. You can update par and reorder points in the following locations: ...Tips & Tricks: How do I download and install drivers for my Zebra Printer?
**As a note: Admin rights will be required to complete this task. If you do not have admin rights on your PC, please contact your IT for assistance** ZD410 Desktop Printer Support Site 1. Navigate to Drivers: 2. Select Zdesigner V. 5 Driver for ...How To: Swap the On-Hand/Parent Size (Edit Base Unit)
When managing items with multiple sizes, it’s essential to configure them correctly. The on-hand/parent size should always represent the base unit or smallest measurement, while additional sizes should be created for purchasing or counting sizes. If ...FAQs: What are Bins?
Question: What are Bins? Answer: Bins are optional location identifiers that specify exactly where an item is stored. You don’t need to create bins in advance. You can assign them: In the Stores tab of the item editor Through a Balto import Bins ...