Business Challenge

• Merging Business Units – Organization was preparing for merging of multiple business units, requiring a singular interface and EPM solution across teams
• Disconnected Planning Applications – Planning process consisted of multiple indirect & direct planning applications that had to be manually consolidated for separate business units
• Inconsistent Processes – Users had differing planning processes and calculations to derive forecasted values, making it challenging to understand variances and inconsistencies

Solution

• Streamlined Budgeting and Forecasting – Designed, developed and deployed a planning solution that leverages Hyperion Planning. Automated data integration and integrated rate & allocation calculations
• Established Consistent Processes – Established a consistent solution to budget and forecast financial and FTE information, with streamlined dimensionality and calculations
• Automation – Developed automated metadata and data integration processes to load latest information

Impact

• Centralized Systems – Established a centralized repository of financial and operational data, reducing manual consolidation and reconciliation effort and ensuring one version of the truth
• Transparency – Centralized, connected systems provide visibility into different levels of the calculation and planning process
• “What-If” Analysis – More frequent allocation and rate calculations, providing faster what-if modeling and detailed forecast modeling
• Increased Knowledge Sharing – Foster cross business-unit data sharing and relationships in preparation for future merging of chart of accounts