A proprietary financial and analytical system built from scratch inside a major wine import company. Replaced manual, disconnected processes with a unified, formula-driven toolkit, bringing pricing discipline, promotion analysis, and supplier reporting under one roof for the first time.
Before this system existed, the company had no unified tool for pricing or promotion analysis. Every decision required manual lookups across disconnected files. Monthly supplier reports, up to 70 per cycle, were each built from scratch by pulling data from 1C (ERP), reformatting it, and populating individual Excel files by hand. The process took 2 full weeks every month and left no time for actual analysis.
There was no way to quickly answer: Is this promotion profitable? What's our margin after the retailer retro-bonus? How are depletions trending across channels?
A multi-layered Excel financial model covering every cost variable in the wine import P&L. For each SKU and each promotion scenario, the model computed the full margin stack in real time.
A centralized Excel database that aggregated all data exports from 1C (the company's ERP) and fed 40–70 individual supplier reports semi-automatically each month.
The price list alone covered thousands of SKUs across dozens of suppliers and countries. Every formula had to work correctly at full scale: a single broken reference cascaded across hundreds of rows.
The financial model pulled live data from 4 separate reference files simultaneously. Any structural change in one file could break downstream calculations. The architecture had to be resilient to routine updates.
Promotion profitability calculations accounted for 8+ simultaneous cost layers, including VAT-adjusted KU, multi-type retro bonuses, and mechanic-specific free goods costs, while enforcing margin floors and flagging invalid pricing in real time.
Each supplier had unique SKU groupings, price tiers, and channel structures. The unified base had to normalize all of this into consistent output formats, without hardcoding supplier-specific logic that would break at scale.
need analytics
or a reporting system
for your business?