JEDOX SUCCESS STORY · FOOD & BEVERAGE

Getränke Hoffmann manages stores with daily updated SAP data

Kybos - The Jedox Professionals. Financial planning and analysis solutions.

600

cost centres in the planning model

15-month

rolling forecast

Daily

SAP data updates

Getränke Hoffmann logo

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

Getränke Hoffmann – Jedox customer success story

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

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.