IBM Cognos Planning sweetens the budgeting process at Heidi Chocolat

Published on 23-Aug-2010

Customer:
Heidi Chocolat

Industry:
Consumer Products, Industrial Products

Deployment country:
Romania

Solution:
Business Analytics, Business Intelligence

IBM Business Partner:
S&T

Overview

The company already had IBM Cognos PowerPlay in place, and needed a reliable planning solution to easily integrate with it.

Business need:
To improve the planning process to address changes in the product portfolio, time lags in master data, overall visibility issues, a complex discount system, and to facilitate comparisons to actual data reported from IBM Cognos PowerPlay.

Solution:
The IBM Cognos Planning solution enables a flexible and transparent process of forecast, while integrating with the in-place IBM PowerPlay solution.

Benefits:
Logical and reliable planning, quick and easy adjustment of the planning process, a more structured process, access to detailed data as well as the comparison against actuals.

Case Study

Since 1994 Heidi Chocolat has brought to Romania the highest standards of the Swiss Läderach Group: a constant concern for continuous innovation, quality control and consistent customer orientation, along with a unique and varied choice of products. At present, Heidi Chocolat is one of the top chocolate brands in Romania, with a strong and increasing presence in foreign markets, most of which are located in Central and South-Eastern Europe. Presently, the company employs 320 people and is preparing for expansion to accommodate increased production and distribution, and is enhancing its IT operation to support its fast-paced business.

Challenges faced
Heidi Chocolat’s quickly increasing number of customers and growing premium product portfolio introduced the need to have a more accurate, reliable and enforceable forecasting process.

The Heidi Chocolat needed a tool to replace their existing Microsoft® Excel® to provide better planning and visibility to help them with process support and presentations. They needed a system that could address challenges associated with changes to their product portfolio and time lags in master data. They also needed a solution that could handle their complex discount system. The planning process results also had to be compared to the actual data reported using IBM® Cognos® PowerPlay®.

Faced with increasing complexity and frequency in planning, budgeting and forecasting processes, Heidi Chocolat decided to dedicate resources to this part of their operation. With a need to plan ahead and report effectively to its parent company, Heidi Chocolat decided to move away from their existing spreadsheet based approach, which involved cumbersome and inaccurate calculations. While addressing these challenges, Heidi Chocolat was given the opportunity to review its forecasting process, and implement a solution to better suit their needs.

Strategy followed
Based on its previous experience with IBM reporting tools, Heidi Chocolat began the evaluation of IBM’s planning and budgeting software, along with consultancy support. A vital selection criterion was that services associated with the project should be carried out using a professional and rapid application development approach. In the spring of 2009, a decision was made to implement the IBM Cognos Planning solution. The implementation would be performed by S&T Romania, a certified IBM Business Partner.

Assessing planning needs
Before the implementation, demonstration sessions were held in which the IBM Cognos Planning architecture and its applications were presented to representatives from Heidi Chocolat’s finance, sales and management areas. High-level planning requirements and volumes were also defined and the required level of detail identified according to Heidi Chocolat needs. The detailed analysis gave Heidi Chocolat the opportunity to review and align its forecasting procedure along the different business areas: product, customer, finance and management.

Benefits realised
As a result of this highly efficient project, some of the benefits that were achieved included:

• logical and reliable planning
• quick and easy adjustment of the planning process, planned product portfolio and planned customers
• use of automated forecasting functions
• a structured, transparent, role-based process
• access to both granular and overview data
• improved data quality
• efficient reporting and comparison against actuals

The planning model was developed for 10+ indicators, for more than 400 customers, the entire product portfolio (over 120), for a time period of at least one year. The model included complex discount calculations, multiple versions of the forecasting process and the export of budget versus actuals.

The implementation was also aimed to enable features and intermediate forecasting process steps that were reconsidered as essential during the implementation phase. This was achieved by inserting interactive presentation sessions as the planning process was shaped within the planning tool. Thus, a much faster acceptance of the implemented process and of the technology led to a successful project. IBM Cognos 8 Planning, provided Heidi Chocolat with more accurate and in-depth analysis of operations and revenue cycle data, taking into consideration its customer and products base, and it helped them to better plan an expansion of both product and their customer base. Business decisions regarding production and featured customers can now be taken much faster, reducing the time lag.

Furthermore, by integrating with the existing IBM Cognos PowerPlay solution, Heidi Chocolat can automatically create reports to assess the accuracy of the planning data versus actual data.

About IBM Business Analytics
IBM Business Analytics solutions deliver world-leading enterprise planning, consolidation and BI software, support and services to help companies plan, understand and manage financial and operational performance. IBM Business Analytics solutions bring together technology, analytical applications, best practices, and a broad network of partners to give customers an open, adaptive and complete performance solution. Over 23,000 customers in more than 135 countries around the world choose IBM Business Analytics solutions.

Products and services used

IBM products and services that were used in this case study.

Software:
Cognos PowerPlay, Cognos Planning

Legal Information

3755 Riverside Drive Ottawa ON K1G 4K9 Canada Produced in Canada June 2010 All Rights Reserved IBM, the IBM logo, Cognos, TM1 and ibm.com are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both. If these and other IBM trademarked terms are marked on their first occurrence in this information with a trademark symbol (® or ™), these symbols indicate U.S. registered or common law trademarks owned by IBM at the time this information was published. Such trademarks may also be registered or common law trademarks in other countries. A current list of IBM trademarks is available on the Web at “Copyright and trademark information” at: ibm.com/legal/copytrade.shtml. Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both. Other product, company or service names may be trademarks or service marks of others. References in this publication to IBM products or services do not imply that IBM intends to make them available in all countries in which IBM operates. Any reference in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is at your own risk.