The marketing report ABC Analysis allows you to see the ratio of profitability from dish (menu item) sales and the demand for these dishes (menu items). The report is built based on expenditure delivery notes.
All dishes (menu items) are distributed into groups depending on their profitability and demand level. Dishes (menu items) with maximum profitability belong to group A. Dishes (menu items) with average profitability belong to group B. Dishes (menu items) with minimum profitability make up group C.
Within a group, dishes (menu items) are distributed by numbers depending on demand. The maximum number in the group is indicated after a slash.
The user independently defines the percentage boundaries for splitting groups on the ABC scale.

ABC Analysis - Filter

The filter for the ABC Analysis report:

The filter parameters "Report from ... to...", "Departments", "Legal Entities", "Enterprises", "Goods Groups", "Category", "Acct. Category", "Type of Alcoholic Products", "Correspondents", "Report Currency" are filled in using standard methods.

After filling out the filter, to generate the ABC analysis, click the [Apply] button.



ABC Analysis - Content

The table of the ABC Analysis report without grouping:

In the upper part of the window, the percentage boundaries for splitting groups on the ABC scale are indicated. They can be entered using the keyboard or selected from two standard options by calling the context menu from the gray field at the top of the window.

Code – this field displays the goods code.
Goods – this field displays the goods item name.
Quantity (Порция - Portion) – this field displays the quantity of the product (portions) in expense invoices according to the values selected in the report filter.
Purchase Price (Порция - Portion) – purchase price of the product (portion).
Sales Price (Порция - Portion) – sales price of the product (portion).
Purchase sum i/t – purchase amount including taxes.
Sales amount with taxes – sales amount including taxes.
Margin – the difference between the price and cost of the goods.
In the columns Group: Quantity (Порция - Portion), Group: Purchase sum i/t, Group: Sales amount with taxes, Group: Margin, it is indicated to which group the product belongs based on the specified characteristics according to the indicated percentage boundaries for splitting groups on the ABC scale.

The report columns Quantity (Порция - Portion)/Purchase Price (Порция - Portion)/Sales Price (Порция - Portion) are filled in the units of measurement "for the recipe norm". By default, such a unit in the system is "portion" ("порция"). The name of the unit of measurement "for the recipe norm" is indicated in parentheses.
This unit of measurement must be in the list of units of measurement of the products displayed in the report.
If the required unit of measurement is not in the product's list of units of measurement, the fields for the columns Quantity (Порция - Portion)/Purchase Price (Порция - Portion)/Sales Price (Порция - Portion) will not be filled.