The Product ABC Analysis groups your products into three categories – A, B, and C – according to their share of your overall revenue. Products assigned to category ‘A’ have the biggest impact on your revenue (70%) and are reflected in green. Products in category ‘B’ are reflected in yellow and have a 20% impact and ‘C ‘ are reflected in red and have the least impact on revenue (10%) .
This report may be filtered by Org. Unit, Assortment, Date, and Assortment Products status. Your options are All Products or Only listed Products.
Make all of the desired selections and click Update at the top of the page. Once the report loads 2 Graph circles are presented. Below the graph is a list of all products. Included are the Net Revenue (total revenue from sales) and Net Yield (total Profit after losses are accounted for). Clicking on the different colors within the graphs will refresh the product results with the desired categories.
Across from each product, a category is listed for net and yield revenue. If a product is not doing well in both revenues, it will fall within the ‘C’ category and a recommendation to “Delist” will reflect.
If category ‘A’ is listed for Net Revenue and category ‘C’ for Net Yield, this entails that the products are doing well in revenue, however, are less then 10% of the profit margin. A recommendation for those products should appear to “Increase Price”.
If category ‘C’ is listed for Net Revenue and Category ‘A’ is listed for Net Yield, a recommendation to “Lower Price” will appear as the net revenue for these items are low, however, profits are at 70% or more.
Additionally, You may apply a tag to all listed products within the selected categories simply by clicking “Add Tag” and selecting a tag from the drop-down menu.
Note* These tags will need to be prerecorded. to learn more please visit our Product Tag Setup manual page.
Selecting one of the listed products will give an option for Analysis. This will redirect you to a more detailed ABC Analysis report. You may filter by Date range. Once you have made your selection click Update.
The first line graph you see on the left-hand side represents Revenue (Yellow) and Net yield (Green) margins with according to dates. Below, is a Quantities (yellow) and Stock (Green) line Graph also with the corresponding dates.
An accumulation of Gross revenue, Net Yield, Quantity, And Stocks are listed on the right-hand side. All of the corresponding dates are listed below for each category.
List View Report
Clicking on List View Will take you to a listed view of the report that may be exported. This report may be filtered by Org. Unit, Assortment, Date, and Assortment Products.
Finally, you may export the report via PDF or Excel simply by selecting one from the top of the screen.