Optibelt
Case Study
-min.jpg)
Rolling sales planning
The Arntz OPTIBELT Group (OPTIBELT) is one of the world's leading manufacturers of high-performance drive belts. The group is characterized by continuous international growth. With increasing size, manual reporting in Excel or via lists from the ERP system AS/400 proved to be no longer practicable.
Generating detailed information or performing a plan/actual comparison was now only possible with a great deal of effort. The manual merging and preparation of data inevitably led to a high susceptibility to errors.
The facts at a glance
Branch:
Industrial production
Subject:
Rolling sales planning
Software:
Board
Requirement:
With increasing size, manual reporting in Excel or via lists from the ERP system AS/400 proved to be no longer practicable.
Implementation:
After setting up a central data warehouse, a comprehensive reporting and planning solution as well as scenario environment could be created in Board. Around 150 sales employees worldwide plan the expected sales in local currency for approximately 11,000 customers.
Advantages and benefits
- Up-to-the-minute information on sales down to the lowest level of detail
- Keeping an eye on current trends and developments through rolling forecast
- Defined release workflow ensures reconciled data and reliable forecasts
- Automated calculation of average prices
- Inventory and purchasing analyses enable optimal stock levels
Corporate success is controllable. Only those who know their business and have an eye on market developments can be successful in the long term. The prerequisite for this is coordinated and up-to-date reporting. In order to be able to recognize additional trends, past data must be made usable by transferring it into a corresponding forecast and planning and enriching it there.
