JEDOX SUCCESS STORY · MANUFACTURING
COLLONIL saves three weeks of planning preparation every year
COLLONIL, the Berlin-based leather and textile care brand produced by Salzenbrodt GmbH & Co. KG, replaced Excel-based sales and operations planning with Jedox integrated with SAP. The change saves three weeks of planning preparation every year and has introduced a quarterly rolling forecast.
3 weeks
of planning preparation saved every year
20+
manual SAP transactions eliminated
~3 months
to replace Excel planning
About Collonil
COLLONIL is a leather and textile care brand produced by Salzenbrodt GmbH & Co. KG in Berlin, where it has made care products since 1909. Its range includes high-tech care for sneakers, shoes, lifestyle and clothing, the Bleu hygiene and disinfection line and the STONE line. COLLONIL exports to 93 countries and has its own sales teams in Austria, Denmark, France and the United Arab Emirates.
Challenge
Three weeks to prepare plans
COLLONIL has produced care products in Berlin since 1909, including high-tech care for sneakers, shoes, lifestyle and clothing, plus its Bleu hygiene and disinfection line and the STONE line. It exports to 93 countries.
Sales and operations planning was carried out in Excel, with SAP as the data source. Preparing and emailing plan folders took three weeks, and data then had to be re-entered into SAP across more than 20 transactions. Planning happened only once a year, so data was often out of date, and Excel carried risks of errors and overproduction.
Solution
A three-stage workflow linked to SAP
Jedox replaced the Excel planning in about three months, implemented by partner Orise Digital. Its BI Ready-to-Run models provided SAP data extraction and standard reports.
The workflow is now three-stage: account managers plan at item level, sales managers review and controllers approve. Planning data flows automatically between Jedox and SAP, and a quarterly rolling forecast has been added.
“With sales planning in Jedox, we generate valid and market-oriented sales figures”
Sandra Richter
Finance & Sales Controller & Product Owner Jedox
COLLONIL / Salzenbrodt GmbH & Co. KG
Outcome
Three weeks saved every year
Planning now starts at the touch of a button, saving three weeks of preparation each year. More people take part, and the values are more realistic, seasonalised and up to date.
Next steps include sales volume planning, revenue planning linked to the P&L, and stakeholder-based management reporting.
Jedox in use at Collonil
- Sales planning
- Rolling forecast
- Reporting
- SAP integration (incl. SAP SD)
- Excel-like interface
- Orise Digital BI Ready-to-Run models
Read more Jedox success stories, see how Jedox supports manufacturing finance teams, or find out about Jedox implementation in the UK & Ireland.
More manufacturing success stories
- ALPLA Turkey: 2x faster planning & scenario analysis: Moving enterprise knowledge from Excel to Jedox
- Churchill China: From spreadsheets to strategy: Churchill China’s journey with Jedox
- Construction Forms: Unified, future-ready data strategy reduces close from 3 weeks to 7 days
- DyStar: Faster planning across 50 global offices with 80+ different currencies
Want results like Collonil?
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.