The client
Rohm and Haas Company, a world leader in electronic materials and process technology development. As part of the $1 billion Rohm and Haas Company Electronic Materials Business Group, Rohm and Haas delivers exceptionally innovative technologies across a broad range of applications.
The brief
Create links to the BI solution to allow analysis of Rohm and Haas's sales against budget and forecast. This system, known as the Value Forecast Tool (VFT) within Rohm and Haas, takes volume forecasts, pricing contracts, cost information and currency rates from the various transaction systems and the Rohm and Haas Data Warehouse, enabling Rohm and Haas to value the forecast.
The forecast value can then be increased or decreased by specific customer or product, by salesman, by sales manager or for the whole company. Multiple iterations of a forecast can be worked on at one time allowing up-side and down-side forecasts to be prepared.
The outcome
Data is stored in SQL Server, manipulated using custom software designed and written by Altimus. The system utilises Microsoft Analysis Services to generate analysis cubes and ProClarity as the software for the end user to explore the data.
The system is in use by business and financial analysts and demand planners in Europe and the US. The use of the award-winning ProClarity software gives great flexibility in analysing trends and finding where markets, customers and products are changing. Quick follow up to the analysis ensures that underlying assumptions can be validated to further inform the decision making process.
The benefits to Rohm and Haas are:
- A centralised tool and process for budget and forecast
- One forecast for both volume and value for Sales and Operations Planning and for Financial Forecasting
