
JEDOX SUCCESS STORY · FOOD & BEVERAGE
Getränke Hoffmann manages stores with daily updated SAP data
Getränke Hoffmann is Germany’s largest specialist drinks chain, with around 600 stores. Growing fast through acquisitions, it replaced Excel with an integrated Jedox planning system fed by daily SAP data, moving from top-down to bottom-up planning across 600 cost centres.
600
cost centres in the planning model
15-month
rolling forecast
Daily
SAP data updates

About Getränke Hoffmann
Getränke Hoffmann is Germany’s largest specialist drinks chain, with about 600 stores and a range of 7,700 products. It employs about 1,500 people in administration, logistics and stores, alongside around 300 independent retail partners. The company is part of the Radeberger Group, which belongs to the Dr. Oetker Group, and grows mainly through acquisitions across three legal entities.
Challenge
Fast growth that outpaced Excel
Getränke Hoffmann employs about 1,500 people in administration, logistics and stores, alongside around 300 independent retail partners, and offers 7,700 products. It is part of the Radeberger Group, which belongs to the Dr. Oetker Group.
The company grows quickly, mostly through acquisitions, runs three legal entities and regularly adds new stores. Sales fluctuate with the seasons, weather, day of the week and sporting events, which makes store forecasting difficult. Excel could no longer cope.
It sought adaptable planning, forecasting and reporting software on a shared database, choosing Jedox for its flexibility, Excel-like interface and SAP integration. Controller Constanze Perlberg also wanted her team to manage the solution independently and expand it step by step.
Solution
Daily SAP data through Snowflake
Jedox partner HICO-Group built a BI architecture and integrated corporate planning system. Data from SAP, including store till data and merchandise management, flows via a Snowflake data warehouse covering several SAP accounting areas, mapped to business units, cost centres, branches and departments. Users work in Jedox Web and the Jedox Excel Add-in, with Microsoft Power BI planned as a future front end.
Jedox’s financial models for P&L, balance sheet and cash flow, plus an HR planning model, were extended into a company-specific model. Cost centres grew to 600 and cost planning became more detailed.
P&L planning is the core, built from daily branch sales, FTE and capacity planning, branch openings and closures, cost centre planning and investment and project planning. Balance sheet, cash flow and a multi-level group cost allocation with contribution margins and branch-level P&L are derived from it. The company produces an annual budget, a 15-month rolling forecast and monthly reporting for the Radeberger Group, and has trialled Jedox AIssisted Planning: cost extrapolation proved more accurate than sales forecasting, which was affected by industry outliers.
“We opted for Jedox because of its similarities with Excel and the flexibility of the system.”
Constanze Perlberg
Senior Controller
Getränke Hoffmann GmbH

Outcome
Bottom-up planning across 600 cost centres
Getränke Hoffmann now has an adaptable system that grows with the business and can be configured without programming. New branches integrate easily and appear separately in group benchmarks.
The shift from top-down Excel planning to bottom-up planning is complete, with automated allocation distributing costs and results to branches. Daily SAP imports enable faster, more flexible analysis, planning changes are immediately visible to everyone, and errors from Excel and copying have fallen. Drill-through gives departments more transparency on costs, and new requirements can be implemented quickly.
The solution is being extended step by step to sales, marketing, IT and purchasing.
Jedox in use at Getränke Hoffmann
- Integrated corporate planning
- P&L, balance sheet and cash flow models
- HR planning model
- Jedox Web
- Jedox Excel Add-in
- Jedox AIssisted Planning (trial)
- SAP integration
- Snowflake data warehouse
- Microsoft Power BI (planned)
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
- Andros: Fresh food sales planning on a day-to-day basis for Andros
- Bell Food Group: Bell Food Group streamlines sustainability indicator monitoring with Jedox
Want results like Getränke Hoffmann?
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.
