
Blogs
See how an FMCG distributor modernized FP & A with Jedox implementation—integrated sales & inventory forecasting, reporting automation, and executive dashboards—delivering connected planning across ERP, CRM, and van sales operations.
For a geographically distributed FMCG business, Jedox’s ability to standardize planning templates, embed business drivers, and automate consolidation was key
A leading FMCG wholesale distributor in the Middle East—representing 25+ agencies, 5,000+ SKUs, 10+ warehouses, 50+ van sales routes, and 2,000+ B2B customers—struggled with fragmented sales planning, manual consolidation, and unpredictable inventory. Although the organization ran a robust SAP ERP for operations, it lacked an integrated Enterprise Performance Management (EPM) process to connect sales, inventory, purchasing, OPEX/CAPEX, incentives, rebates, and finance into one planning and reporting ecosystem. Finlytyx was selected as the client’s Jedox partner to implement an end to end integrated financial planning and analytics solution. We combined driver based planning, seasonality profiles, and historical trend models to forecast demand down to the SKU and territory level. The platform automated FP&A, financial reporting, executive dashboards, and rolling forecasts, with tight SAP integration for master data and actuals. The result: a unified planning process that improved confidence, transparency, accountability, and decision speed across the enterprise—from van sales teams to executive leadership.
The Backstory: Growth Outpaced the Planning Model The company’s business model was both broad and deep:
• Wholesale distribution for 25+ agencies across food and non food categories
• Multiple territories and distribution centers/warehouses across the Middle East
• Direct wholesale to hypermarkets, supermarkets, and export centers
• Van sales distribution servicing small groceries and convenience stores
• Direct B2B supply to hotels and food outlets on order This diversity—by channels, territories, product categories, and customer segments—generated high-volume, high variance operations.
Demand fluctuated with seasonality, market trends, and competitor actions. Local sales units relied on experience and memory to craft projections. Those projections, usually in spreadsheets or emails, were then consolidated manually into inventory requirements, purchase requisitions, and eventually production forecasts shared with agencies.
The result? Unpredictability, bias, and misalignment:
• Finance lacked a data driven basis to set targets by region, product family, or customer segment.
• Inventory teams had incomplete or delayed signals, causing stock outs in fast movers and overstock/expiry risk in slower lines.
• Management struggled to challenge assumptions or trace ownership down to entity, region, product, SKU, customer, and sales unit.
Core questions went unanswered:
- Which strategic accounts were we losing or under serving?
- How are we growing each key account?
- Are we acquiring new customers at the expected pace?
- Are we meeting market benchmarks and internal growth targets?
The ERP was solid—it kept operations running. But EPM was missing: no connected planning, no standardized drivers, no clear performance analytics. The organization needed a way to harmonize planning and performance across sales, inventory, purchasing, and finance—without adding operational friction. The Mandate: Connected Planning That Everyone Trusts The leadership’s objective was explicit: “Turn isolated forecasts into one truth across Sales, Supply Chain, and Finance—so we plan proactively, act faster, and improve profitability.”
They envisioned a future state with:
Why Jedox (and Why Now) The client selected Jedox for its strength in integrated planning and analytics, Excel friendly UI for finance teams, robust modeling for driver based forecasting, and connectivity with core systems like SAP. For a geographically distributed FMCG business, Jedox’s ability to standardize planning templates, embed business drivers, and automate consolidation was key. Finlytyx partnered as the Jedox implementation lead, bringing FP&A automation consultants, data engineering expertise, and financial reporting services together under one program.
1) Integrated Data Model (Designed for FMCG Reality) We designed a unified dimensional model that reflects how the business is run and measured:
• Dimensions: Entity, Region, Territory, Channel (Wholesale, Van Sales, B2B/HORECA), Customer, Agency, Brand, Product, SKU, Sales Unit/Rep, Warehouse/DC, Time (Month, Quarter, Year), Scenario (Actual, Budget, Forecast), Version, Currency
• Measures: Volume, Net Sales, Gross Margin, A&P, Discounts, Rebates, Incentives, COGS, Inventory, Days Inventory, AR/DSO, Opex, Capex
• Master Data Sync from SAP ensured consistent hierarchies and codes across all modules. This foundation enabled drill down navigation from executive KPIs to SKU-level performance—the backbone of any credible executive dashboard.
2) Sales & Inventory Forecasting (SKU Level, Driver Based) To replace guesswork with evidence, we implemented a multi-layer forecasting approach:
• Seasonal curves at SKU × Region × Channel based on historical sales
• Trend adjustments to account for market growth/decline and promotional cycles
• Channel/Customer mix to reflect differences between hypermarkets, van sales, and HORECA
• New product introduction (NPI) templates with proxy curves and analog SKUs
• Override controls so sales leaders can adjust forecasts and leave a justification trail These forecasts cascade into:
• Inventory plans (safety stock, reorder points)
• Purchasing plans (supplier lead times, MOQ, agency SLAs)
• Receivables forecasts (credit terms by customer segment)
This is where Jedox shines: one change in demand updates inventory, purchasing, and cash impacts.
3) FP&A Automation (Budgets, Forecasts, and Consolidation) Using Jedox, we automated core FP&A cycles:
• Budgeting & Reforecasting with rolling horizons
• Opex/Capex planning—with driver linkages to sales, operations, and expansion initiatives
• Consolidation across entities, with currency handling and intercompany considerations
• Allocations (e.g., A&P expenses and trade promotions) using transparent rules Top down and bottom up workflows with approval stages and audit trails This FP&A automation replaced disjointed spreadsheets and shortened cycle times while improving consistency and traceability.
4) Commercial Levers: Incentives, A&P, and Rebates We embedded commercial driver models to reflect real world FMCG dynamics:
• Sales team incentives linked to targets, collections, and mix quality
• A&P (Advertising & Promotion) budgets tied to brands/markets, with ROI tracking against incremental sales
• Rebates both receivable (from agencies) and payable (to modern trade), with accrual logic and settlement visibility By modeling these levers in Jedox, finance can anticipate P&L impacts and steer trade spend more effectively.
5) Financial Reporting Services & Executive Dashboards We delivered executive dashboards and management reports with:
• Revenue, margin, and volume KPIs
• Forecast vs. actual vs. plan views at entity/region/product/customer
• Inventory health (days, aging, stock out risks, expiry exposure)
• Customer performance (acquisition, retention, growth)
• Sales unit/rep scorecards with contribution and efficiency metrics
• Cash & working capital signals driven by receivables/inventory plans Each dashboard supports drill down to the lowest level—making it easy to validate numbers and challenge assumptions in cross functional reviews.
6) SAP ERP Integration (The Backbone of Trust) We integrated SAP ERP with Jedox for: Dimensions & master data (customers, SKUs, hierarchies, warehouses, sales orgs)
• Actuals & historicals (sales, inventory, AR/AP, GL)
• Automated refresh schedules with data quality checks
• Versioning so planners can compare Actual vs. Budget vs. Forecast consistently This closed the loop between operations and planning, ensuring the plan always references the single source of operational truth.
Implementation Approach: Collaborative and Phased To minimize risk and maximize adoption, we followed a structured, sprint based delivery:
1.Discover & Align o Process mapping across Sales, Supply Chain, and Finance oKPI alignment with leadership
- Current state diagnostics (data, systems, teams)
2.Design & Prototype o Driver models, dimensions, and planning forms o Initial dashboard mockups and validation cycles with key users
3.Build & Integrate
- Jedox cubes, rules, and workflows o SAP connectors and data pipelines
- Security & roles
4.UAT & Training o Scenario testing (seasonal peaks, promotions, NPI)
- Train the trainer sessions for planners, analysts, and managers
5.Go Live & Hypercare
What Changed: The Before/After View Before (Fragmented):
• Localized, memory based sales forecasts
• Manual consolidations and conflicting versions
• Inventory plans reactive to demand shocks
• Finance targets decoupled from market reality
• Limited ability to challenge and trace assumptions
• After (Integrated with Jedox):
• Driver based forecasts down to SKU × Territory × Channel
• Automated FP&A with rolling reforecasts and transparent approvals
• Unified reporting and executive dashboards with drill down clarity
• Aligned commercial levers (incentives, A&P, rebates) with measurable P&L impacts
• Seamless SAP integration for reliable master data and actuals
• Enterprise performance management embedded into daily decisions While we won’t share sensitive metrics, leadership reported greater forecast confidence, faster planning cycles, and tighter working capital discipline—with teams now speaking the same data language.
What Made It Work
• Start with reality, not theory. We modeled the business as it is—van sales nuances, channel behaviors, territory hierarchies, and agency terms.
• Design for drill down. Executives could challenge a number and trace it to SKU-level drivers credibility matters.
• Keep humans in the loop. Driver models produce smart baselines; sales leaders apply judgment with accountability.
• Automate the routine. FP&A automation freed analysts to focus on insights, not reconciling spreadsheets.
• Own the data lifecycle. SAP–Jedox integration ensured plans and actuals speak to each other—continuously.