Sales Mix Summary
The Sales Mix Summary provides a comprehensive breakdown of sales data across different breakdowns.
We have a breakdown of sales by:
Department — Displays sales categorised by departments (e.g., Pizza, Sides, Desserts).
Category — Displays sales categorised by food categories (e.g., Food, Drinks).
VAT Rate % — Displays sales categorised by applicable VAT rates.
Each breakdown contains:
Net VAT after Discounts
Gross before Discounts
Discounts
Gross after Discounts
Total VAT Amount
At the bottom, Adjustments information is displayed. This includes:
Delivery Charge
Processing Fee
Deposit Return Scheme
Meal Deal Attribution
When products are sold as part of a meal deal, sales are attributed proportionally based on the individual product's value outside of the meal.
The system adds up all the individual standalone prices of the meal components. Then calculates what portion of the meal deal price each component represents:
Product Price in Meal = ( Standalone Product Price ÷ Standalone Total Price ) × Meal Price
The product's Price in Meal is attributed to the respective departments and categories. This calculation method is also used for VAT attribution on meal deals.
VAT Calculation for Meal / Combo Products
For example:
Quarter Pounder Burger Meal — Meal Price: €12.50.
Quarter Pounder Burger
€1.00
€10.00
€7.35
Quarter Pounder Burger
€0.00
€9.00
Add Lettuce (topping)
€0.50
€0.50
Add Cheese (topping)
€0.50
€0.50
Regular Chips
€0.00
€4.50
€3.31
Fanta
€0.00
€2.50
€1.84
€17.00
€12.50
Discount Attribution
The system prioritises attributing discounts to food and drink.
Case 1: Discount Exceeds Food and Drink Value
Food and drink value: €12.50
Delivery charge: €5.00
Discount applied: 100% (€17.50 total discount)
In the Breakdown Report, the discount will show as €17.50. However, in the Sales Mix Summary, only the €12.50 discount attributed to food and drink will appear. The remaining discount which was applied beyond food and drink value is not displayed in the Sales Mix Summary tables.
Case 2: Discount Does Not Exceed Food and Drink Value
Food and drink value: €12.50
Delivery charge: €5.00
Discount applied: €5.00
Because the system prioritises attributing discounts to food and drink, the €5.00 discount will show up in the Sales Mix Summary tables.
Last updated