Client reference
Ahorn
Ahorn is the largest Czech manufacturer of slatted bed bases and mattresses, producing in Vlkoš near Hodonín. Sales, purchasing, production and HR now run in a single system built by SBID.
Problem
Company agendas scattered across spreadsheets and paper
Solution
A business CRM on Power Platform and reporting on ERP data
320+
Hours saved every month
6 areas
Sales, purchasing, production, assets, HR and documentation
80+
Report pages built on ERP data
1 system
Instead of dozens of spreadsheets and paper forms
A manufacturer shipping around 180,000 slatted bed bases a year ran much of the company in spreadsheets and paper forms. SBID built a complete business CRM on Power Platform and added reporting on ERP data in Power BI. Over 320 hours of manual work saved every month, and management and operations now work with the same numbers.
Problem: every agenda somewhere else
Sales cases lived in one spreadsheet, purchase requests travelled by e-mail, machine and asset records had a life of their own, and directives sat on a shared drive. Numbers for management were assembled from the ERP by hand, so by the time they reached the table they were out of date.
Solution 1: a business CRM built to fit
The Power Platform application covers agendas that used to live apart:
- Sales from opportunity through the sales case to order lines
- Purchasing including requests and their approval
- Records of machines, their maintenance and fixed assets
- HR from recruitment through employment to training
- Controlled documentation with directives, versions and checklists
- Tasks, meetings and projects in one place
Solution 2: reporting on ERP data
Six reports are built on one shared data model, so sales, finance and production all count with the same numbers.
- Sales: revenue, orders and plan fulfilment by salesperson and product
- Profit and loss plus a management P&L covering production, sales and overheads
- Production: machine efficiency, cost performance and standards fulfilment
- Inventory: stock value, turnover and development over time
- Cash flow: receivables, payables and account balances in two currencies
Result: the whole company in one system
- 320+ hours saved every month across all agendas
- Sales, purchasing, production, assets and HR all run in one CRM
- Management sees sales, finance and production numbers in one place
- Approving a purchase request or issuing a directive follows a clear flow
- Reports draw on the same model, so the numbers never contradict each other
What we used on this project
