Managerial accounting, commercial department analytics system
Client: Pharmacy chain (109 locations) + online pharmacy
Problem: declining sales, large inventory levels, lack of available funds for purchasing, owner does not understand the issue
Solution:
1. Conducted an audit of analytics capabilities:
1.1. state of the product directory
1.2. analytics capabilities in terms of product groups, suppliers, retail locations, seasonality, etc.
1.3. ability to generate reports on assortment management effectiveness, supplier relationships
1.4. presence of product matrices for each location and their relevance
1.5. ability to compare internal analytics with market analytics by product category
1.6. planning capability and effectiveness
1.7. pricing control and management capabilities
1.8. order/supply control capabilities
2. Reports were generated and an analysis of the situation's causes was conducted, revealing:
2.1. excessive purchases of slow-moving products
2.2. shortage of fast-moving products
2.3. chaotic purchases of the same product under different brands, resulting in loss of purchasing power for the supplier/manufacturer, lack of strategy for price segments
2.4. mismatch between orders and deliveries
2.5. product turnover by category and retail locations, comparison with sales rankings of medications in the country
2.6. absence of product matrices
3. Necessary control points for the owner of the commercial structure to manage the situation and indicators of process and manager effectiveness were identified
4. A reporting system was developed in Excel format with subsequent automation in 1C:
4.1. analysis of inventory turnover
4.2. order/supply analysis
4.3. stockout analysis
4.4. financial results analysis
5. A technical task was written for software developers
6. Support of the commercial structure's operations with Excel reports until automation
7. Automated analytics system of the commercial structure was implemented in 1C
Outcome:
1. Sales decline and product shortages were halted
2. Overdue debt to suppliers of 10 million UAH was repaid
3. Sales growth year over year +10%
4. Efficient planning system, financial results management for business and commercial structure were implemented
Problem: declining sales, large inventory levels, lack of available funds for purchasing, owner does not understand the issue
Solution:
1. Conducted an audit of analytics capabilities:
1.1. state of the product directory
1.2. analytics capabilities in terms of product groups, suppliers, retail locations, seasonality, etc.
1.3. ability to generate reports on assortment management effectiveness, supplier relationships
1.4. presence of product matrices for each location and their relevance
1.5. ability to compare internal analytics with market analytics by product category
1.6. planning capability and effectiveness
1.7. pricing control and management capabilities
1.8. order/supply control capabilities
2. Reports were generated and an analysis of the situation's causes was conducted, revealing:
2.1. excessive purchases of slow-moving products
2.2. shortage of fast-moving products
2.3. chaotic purchases of the same product under different brands, resulting in loss of purchasing power for the supplier/manufacturer, lack of strategy for price segments
2.4. mismatch between orders and deliveries
2.5. product turnover by category and retail locations, comparison with sales rankings of medications in the country
2.6. absence of product matrices
3. Necessary control points for the owner of the commercial structure to manage the situation and indicators of process and manager effectiveness were identified
4. A reporting system was developed in Excel format with subsequent automation in 1C:
4.1. analysis of inventory turnover
4.2. order/supply analysis
4.3. stockout analysis
4.4. financial results analysis
5. A technical task was written for software developers
6. Support of the commercial structure's operations with Excel reports until automation
7. Automated analytics system of the commercial structure was implemented in 1C
Outcome:
1. Sales decline and product shortages were halted
2. Overdue debt to suppliers of 10 million UAH was repaid
3. Sales growth year over year +10%
4. Efficient planning system, financial results management for business and commercial structure were implemented
Odessa 
Available for hire