Business Challenges
- Limited Analytical Flexibility – Environment did not allow for analysis across all customers and products
- Inefficient Allocations Process – Required to execute every two hours during month-end with an average run-time of 1.5 hours
- Inadequate Visibility – Concerns with allocations process created a significant amount of non-value added effort to decompose, validate, and correct logic
Solution
- Profitability and Cost Management Cloud Service (PCMCS) – Replaced on-premise Hyperion planning allocation solution with the highly scalable PCMCS cloud offering
- Advanced Allocation Approach – Updated processes and allocation approach provides ability to conduct analysis for 1,000 customers, 100 products per customer, and 30 drivers
- Validation and Visibility – Provided validations, traceability, and increased visibility into the allocations using out-of-the-box functionality
Impact
- Streamlined Allocation Process – Improved process and simplified user interface allowed for quicker response time to business requests as well as greater confidence from the finance team and administrator when discussing required changes
- Improved Allocation Performance by 80% – Reduced allocation calculation time from 1.5 hours to 15 minutes
- Established a Flexible Platform – Solution set to easily scale profitability analysis during continued global growth
- Enhanced Visibility – Faster process validation, issue resolution, and what-if analysis