JEDOX SUCCESS STORY · FOOD & BEVERAGE
Fresh food sales planning on a day-to-day basis for Andros
Andros Germany, part of the family-owned French Andros Group, produces fruit, vegetable and fresh food products under brands including Bonne Maman and Odenwald. Working with partner HRCIE, it replaced a legacy reporting system with Jedox, creating daily-updated, SAP-integrated sales planning with a 99-week rolling forecast for 60 users.
99 weeks
covered in the detailed rolling forecast
60
users across sales, marketing, controlling and supply chain
Daily
SAP actuals updates, with nightly forecast sync to SAP Demand Planning
About Andros
Andros Germany is part of the Andros Group, a family-owned company based in Biars-sur-Cère, France. Located in the Odenwald region, it employs around 175 people and produces fruit, vegetable and fresh food products under brands including Bonne Maman, Odenwald, natreen, Libby’s and Spreewaldhof. Its business is split into a Chilled unit and an Ambient unit.
Challenge
Replacing an outdated reporting system
As the business grew, Andros Germany needed to replace an outdated legacy reporting system. SAP had to remain the main data source, and sales planning was to be organised around rolling forecasts.
Its two business units have very different needs: the Chilled unit requires decisions at short notice, while the Ambient unit needs longer-term procurement planning and medium-term production and logistics data. Jedox was chosen for its SAP planning capabilities, cloud readiness, multidimensional analysis, simple departmental application design and mobile access.
Solution
Daily SAP data, nightly forecasts
SAP data is integrated into a Microsoft SQL Server staging area via an interface built with Microsoft SSIS and Theobald software; the same data also feeds the French parent group’s BI system. HRCIE built a separate interface for the new group reporting structure.
SAP actuals and structures are updated in Jedox every day. Forecasts are entered through online input screens, and advertising, logistics and German recycling-scheme costs are allocated automatically by customer, item, month and quarter. The latest forecast, covering 99 weeks in detail, is sent to SAP Demand Planning each night.
An agile project covered sales forecasting, production demand planning, sales reporting, operating results, month-end closing and group reporting structures. Andros formed an interdisciplinary BI team, trained power users in each department and ran change management, with most work done remotely during COVID-19.
Fresh food sales planning on a day-to-day basis for Andros
Andros
Outcome
One data pool for 60 users
A central data pool now feeds both German sales planning and group reporting. Around 60 users in sales, marketing, controlling and supply chain management work in the system.
Delivery quotas can be planned more accurately and the business can respond quickly to short-term market changes. The platform also scaled to integrate Spreewaldhof following its acquisition.
Jedox in use at Andros
- Sales planning / Sales Performance Management
- Rolling forecasting
- Strategic sales planning
- Standard reporting and analysis cockpits
- DB3 analysis
- SAP integration (incl. SAP Demand Planning)
- Microsoft SQL Server / SSIS
- Theobald software
Read more Jedox success stories, or find out about Jedox implementation in the UK & Ireland.
More food & beverage success stories
- AgReliant Genetics: AgReliant Genetics increased scenario planning frequency 3x within months
- Agrogen: Agrogen achieves 50% faster budget cycles with secure, integrated planning
- Bell Food Group: Bell Food Group streamlines sustainability indicator monitoring with Jedox
- Clean Seas: Clean Seas C-suite utilizes Jedox’s powerful self-service capabilities daily
Want results like Andros?
Kybos is the UK & Ireland’s only dedicated Jedox partner. Our accountancy-qualified consultants will show you what Jedox could do for your finance team.