Analytical ATK solution for category management
ATK
Cross-industry
Assortment analysis
Acknowledgment of ATK's expertise:
Platforms:
Solution Functionality:
Comparison of actual sales with planned indicators, with sales data of previous periods (with any necessary detail - hour, day, week, month, quarter, year); Comprehensive like-for-like (L4L) analysis by stores, divisions, categories, customers (new and lost), sales volume, managers, etc..; Detailed performance and variances from previous year or any period to SKU, category, manager, supplier, brand, etc.; Execution of the planned assortment matrix, plans for novelties, products-drivers by stores, regions, categories Rating of category managers in terms of assortment matrix plan fulfillment, profitability
Comprehensive analytics on plan execution
Planning of assortment matrix by price ranges based on the fact of sales Forecasting of category sales taking into account seasonality, based on various statistical methods Profitability of category manager's pricing policy, taking into account discounts and marketing promotions and their impact on sales volume Impact of marketing promotions on category profitability (ROI) Analysis of price ranges for marketing promotions, novelties ROI dynamics by category, subcategory, SKU, store, region Life cycle analysis of category products Distribution of category revenues by price ranges by stores, regions Analysis and planning of the share of novelties and driver products by category, in total turnover Combined ABC-analysis of categories and products in the category by sales volume and profitability
Assortment matrix management
Interactive analysis of stock balances (in rubles, units, days of sales) to maintain the necessary category inventory Estimation of lost profit due to out-of-stock (out-of-stocks) Ranking of category items by group based on turnover, shortage, sales per period Analysis of the number and percentage of days of out-of-stock/in-store days to normalize the %OOS indicator Control of efficiency of replenishment of RCs, warehouses, stores by the most critical product categories, groups, SKUs Identification of SKUs that sell well in some stores but not in others (with additional analytics on stock availability)
Turnover, residuals, out-of-stock
Analysis of key KPIs for suppliers (sales volume, turnover, margin, product balances, profitability of sales, retro bonuses, service level including under-deliveries, over-deliveries, out-of-stocks) Rating of suppliers' profitability taking into account retro bonuses, Efficiency of work with suppliers in the context of price ranges Assessment of supplier's product portfolio by ABC, XYZ, ABC-XYZ classifications
Vendor analysis
Screenshots of the solution:
Implementation results:
-
Obtaining all KPIs for category manager and effective assortment planning in a single interactive application, with the ability to drill down to any detail of analysis, flexible selection of periods;
-
No resource costs for consolidation of reporting on sales, finance, merchandising, suppliers;
-
Assortment planning support
-
Improved quality of sales forecasts by category and product groups
-
Minimize shortages and missed sales due to out-of-stocks
-
Increase inventory turnover
-
Reduction of SKU overstocks, minimization of "overstocking" of the warehouse
-
Increased efficiency of work with suppliers
-
Convenient tool for analyzing LTV, product life cycle and making decisions on product exclusion from the assortment matrix
This solution is complemented well:
.png)
Sales analysis
Marketing Analysis
.png)
.png)
Analysis of finances
HR analysis
Mascotte
-
QlikView is a unified analytical tool of the company, which contains all the main analytical indicators for decision-making on assortment, goods, marketing campaigns.
-
A pilot project to analyze sales data for 4 seasons was completed in 2 days
BNS
-
QlikView interactive analytics for top management, brand managers, commercial department analysts, finance, sales and purchasing employees
-
More than 50 employees use Qlik for their daily work
-
Qlik analytics helped to reduce losses on sales
All solutions Goods movement
.png)
QlikView in "Pharmstandard"
+7 (495) 134-32-92
consult@atkcg.ru
Russia, 121467, Moscow,
Istrinskaya str. 4, Office 1
Company News
subscribe to our newsletter
