With the Assortment Analysis analytical report, you can keep track of sold products and spare parts to better understand the volume of sales and which products are the most popular. This report will allow you to:
assess the prospects of a particular group of products;
reveal patterns of growth or decline in sales;
adjust the product promotion;
see the number of sold products / spare parts for each employee;
find out what profit the company makes for the products sold by each of the employees;
see the number of discounts given on products in work orders/sales and much more.
To generate a report, go to the Reports > Assortment Analysis page. Please note that this report is available from the Startup plan and higher.
First, set the parameters for generating the report.
1. Document types. Specify which documents you want to take data for analysis from:
All. All products sold in sales and work orders will be displayed;
Work Orders. Only products added to work orders will be displayed;
Sales. Only products added to sales will be displayed.
2. Period. Here you can select the period for which the turnover will be displayed: today, yesterday, this week, this month, last week, last month, or a custom time range.
3. Location. Analyze one / several / all locations (if there is more than one).
4. Category. Set up a specific category of products for analysis.
5. Group by. You can specify how to display the data in this field: by products, categories, or employees.
Thus, you can analyze:
particular products
types of products by category
employees who sell products or add them to work orders
After selecting the necessary parameters, click Apply.
The report will be displayed as a table with the following columns:
Name of Product / Category / Employee;
Quantity shows the number of products sold for the selected period;
Price (“by 1 item” and “Sum”) contains the amount per unit and the total amount received for the products sold;
Note: the amount per unit is the average amount including the number of items from each shipment.
Discount. The total amount of discount for the products;
Cost (“by 1 item” and “Total”). The cost price per unit and the total cost of products sold;
Note: unit cost is the average cost per unit, taking into account the number of products from each shipment.
Gross Profit. The total amount of profit for the products sold;
Gross Profit is calculated by the following formula: Price (total) - Discount - Cost (total).
Markup shows the total markup on the cost price in %.
The markup is a part of the price that we added to the cost price. Markup is calculated by the formula: Profit (total) / Cost price (total) * 100%.
The markup indicators are built with each other’s values. For better visualization of the report, the indicator is green when the value is positive, and red when the value is negative.
The values are formed relative to the maximum markup value of the products in the table. For the markup, they may be more than 100%. That is if you see a product with a 70% markup at the beginning and less than half of the indicator is green, it means that there are products with a markup much higher than 100% below.
Using data from this column you can adjust the pricing.
Pay attention to the products with a negative markup value. This means that the products are sold at a deficit and you may need to reconsider the pricing on the Settings > Prices and discounts page.
Margin is the part of the price that remains after deducting the cost price and is shown in %.
The margin is calculated by the formula: Profit (total) / Price (total) * 100%.
For margin, values will always be in the range from 0% to 100%, that is why this column shows the indicator in blue color. The higher the margin percentage, the more profitable the product or product category is. If you are looking at the employee report, you can use margin to see which employees are selling more profitable products.
At the bottom of the table, you can see the totals for all parameters for the selected period. For markup and margin, you’ll get the average value.
If necessary, you can change the position of columns, enable sorting by columns, add or remove columns using the table button.
When analyzing the assortment, we recommend looking at both Price and Margin to determine the demand and revenue from the products sold.