Description
This report allows you to create your own product mix report layouts with custom product groups to track sales e.g. for tracking promotions, menu sales, add-on sales, etc. The report also allows you to consolidate sales by time period and restaurants.
Each user can create their own PMX layouts and these can also be shared with other users. A layout consists of freely selectable sections, product groups and products.
By unfolding the sections, the created product groups and products can be viewed.
Row Details
| Name | Unit | Description |
|---|---|---|
| Code | Integer | Menu item product code |
| Price In | Decimal, Currency | Price In is the average of Gross Price In |
| Price Out | Decimal, Currency | Price Out is the average of Gross Price Out |
| Price Delivery | Decimal, Currency | Price Delivery is the average of Gross Price Other |
| Total | # | Total is computed as sum of UnitsSoldIn + UnitsSoldOut + UnitsSoldOther + UnitsRegularCustomerDiscountIn + UnitsRegularCustomerDiscountOut + UnitsRegularCustomerDiscountOther + UnitsRegularPromoIn + UnitsRegularPromoOut + UnitsRegularPromoOther + UnitsGMALPromoIn + UnitsGMALPromoOut + UnitsGMALPromoOther + UnitsWaste + UnitsEmployee + UnitsGMALCustomerDiscountIn + UnitsGMALCustomerDiscountOut + UnitsGMALCustomerDiscountOther + UnitsManager |
| Sold In | # | Sold In is the number of units sold in |
| Sold Out | # | Sold Out is the number of units sold out |
| Sold Delivery | # | Sold Delivery is the number of units sold other |
| Total Units Sold | # | Total Units Sold is computed as UnitsSoldIn + UnitsSoldOut + UnitsSoldOther - UnitsRefund |
| Sales % | % | Sales % is computed as a percentage of Total Units Sold from UnitsTotal |
| Discount In | # | Discount In is UnitsRegularCustomerDiscountIn + UnitsGMALCustomerDiscountIn |
| Discount Out | # | Discount Out is UnitsRegularCustomerDiscountOut + UnitsGMALCustomerDiscountOut |
| Discount Other | # | Discount Other is UnitsRegularCustomerDiscountOther + UnitsGMALCustomerDiscountOther |
| Promo Units | # | Promo Units is computed as UnitsRegularPromoIn + UnitsRegularPromoOut + UnitsRegularPromoOther + UnitsGMALPromoIn + UnitsGMALPromoOut + UnitsGMALPromoOther |
| Promo % | % | Promo % is computed as a percentage of Promo Units from UnitsTotal |
| Waste Units | # | Waste Units |
| Waste % | % | Waste % is computed as a percentage of Waste Units from UnitsTotal |
| Employee Units | # | Employee Units is UnitsEmployee + UnitsManager |
| Employee % | % | Employee % is computed as a percentage of Employee Units from UnitsTotal |
| Refund Units | # | Refund Units |
| Grp % | % | Share of current item Gross Sales from the Gross Sales of entire group |
| Tot % | % | Share of current item Gross Sales from the Gross Sales of entire report |
| Gross Sales | Decimal | Gross Sales |
| LC Grp % | % | Share of current item TotalUnitsSold from the TotalUnitsSold of entire group |
| LC Tot % | % | Share of current item TotalUnitsSold from the TotalUnitsSold of entire report |
| Sales Units Per 1000 Guests | Decimal, Currency | Sales Units Per 1000 Guests is computed as Total Units Sold divided by the total number of guests, multiplied by 1000 |
| Total Units Per 1000 Guests | Decimal, Currency | Total Units Per 1000 Guests is computed as Total divided by the total number of guests, multiplied by 1000 |
| Net Sales | Decimal, Currency | Net Sales if available in the Pmx table otherwise is computed from the PmxCosts NetSalesIn + NetSalesOut + NetSalesOther |
| Food Cost Sold | Decimal, Currency | Food Cost Sold is computed with the costs from PmxCosts table and the sold units from the Pmx table FoodCostIn * UnitsSoldIn + FoodCostOther * UnitsSoldOut + FoodCostOut * UnitsSoldOther |
| Food Cost % | % | Food Cost % is computed as the percentage of the Food Cost from the Net Sales |
| GMAL Customer Discount In | # | GMAL Customer Discount In units |
| GMAL Customer Discount Out | # | GMAL Customer Discount Out units |
| GMAL Customer Discount Other | # | GMAL Customer Discount Other units |
| Regular Promo In | # | Regular Promo In units |
| Regular Promo Out | # | Regular Promo Out units |
| Regular Promo Other | # | Regular Promo Other units |
| Total Regular Promo | # | Sum of Regular Promo In, Out and Other units |
| GMAL Promo In | # | GMAL Promo In units |
| GMAL Promo Out | # | GMAL Promo Out units |
| GMAL Promo Other | # | GMAL Promo Other units |
| Total GMAL Promo | # | Sum of GMAL Promo In, Out and Other units |
| Manager Units | # | Manager Units |