SERVER Trading House: procurement and sales process optimization on the Qlik Sense platform

About Server

Server Trading House supplies materials and components for modular furniture production. Throughout its existence, Server Trading House has become one of the largest suppliers for several hundred furniture manufacturers in most Russian regions.

The product range of the company consists of more than 5000 items, from chipboard to fasteners, and includes materials and components necessary for modular furniture production.

Implementation effects

The company decided to adopt modern analytical technologies. Server Trading House opted for Novo BI company for two reasons: the company's specialists have extensive experience in the field and offer systems based on the Qlik Sense modern analytics platform.

The project meant to ensure: 

  • The increase in sales planning accuracy;
  • High level of product availability for customers, while controlling stocks and losses;
  • The increase in logistics and procurement efficiency, with the increasing number of commodity items;
  • Real-time data transparency across the supply chain.

The use of Qlik Sense allowed to merge data from different sources and create Decision-making Center, single analytics and monitoring center for all employees of Server Trading House.

Within the project, the following solutions have been implemented: 

  • Sales plan analysis;
  • ABC-analysis with the possibility to adjust parameters;
  • Analysis and comparison of prices, goods in transit, future balances, and prices by item, supplier, warehouse and other available categories;
  • Product profitability assessment by price;
  • Current back up stock margin estimation;
  • Analysis of indicators for order generation (analysis by product – price, cost, margin, logistics parameters, sales, stock balance, stock, overstock, payment, stock %);
  • Regular customer analysis;
  • Sales analysis;
  • Highly detailed dynamic LFL analysis, which determines the reasons for the growth and fall in sales (by number of customers, by average order value, by average SKU per customer);
  • Sales ratings by product, taking into account margin, working time, work regularity, number of regular customers, average order value by regular customers;
  • Baseline reports on products, customers, employees;
  • Automatic ordering – order calculation, taking into account the sales plans, logistics restrictions, stock balance, goods in transit for the selected period.

“The provided solutions allowed us to significantly speed up decision-making and make a qualitative leap in our daily work. As a result, we calculate and make decisions on an order much quicker, the service level has increased, and the number of suppliers per manager has multiplied. We have also expanded the product range without increasing personnel costs and accelerate the company's growth. The implementation cost paid off in a few months of operating the solutions”

Vitaly Vorobyov, Server Trading House General Director
Contact us

+7 (495) 215 10 82
This email address is being protected from spambots. You need JavaScript enabled to view it.

 

Исследования осуществляются Novo BI при грантовой поддержке Фонда «Сколково» 121205, Russia, Moscow, territory of the SKOLKOVO innovation center, 42 Bolshoy Boulevard, p. 1, floor 3, office 1131

 

Russian (RU)    English (UK)