Manufacturing, Supply Chain & Logistics
Advanced Analytics
Value Reporting for Fortune 100 International Snacking Company
- $25.5 billion in revenue
- $65 billion in assets
- 100K employees across 127 countries and 6 continents
Business Need
- Regulatory and audit reporting accuracy
- Timely reports for monthly, quarterly, and annual close
- Accuracy, especially around multiple versions of the truth, simplified auditing
- Multiple source integration
- Chart of accounts (M&A)
- ERPs, EDWs, reports, etc.
- Standardize KPI structure across multiple platforms
- Foundation for data-driven actions
- Reduce cost
- Consistent, standardized set of data points
Challenge
- Quality and quantity of required reports delaying business decisions
- Reporting 150-page documents across 5 business lines; executives review monthly, 15 days after month-end closing
- Multiple ways to factor KPIs from acquisition growth (8 ways to calculate GM, multiple CoAs)
- 8 different ERPs driving inaccurate reporting
- Auditing accuracy, timeliness, cost of execution
- Enterprise reactive and unable to make proactive decisions
- High cost to manage financial reporting
- Lack of data governance and inconsistent data rules and definitions
Solution & Results
- Reduced dashboard delivery from 360 hours (15 days) to 24 hours, enabling real-time dashboarding as a service (RaaS) for CFO’s office
- 8 ERPs, multiple CoAs, and 3 EDWs curated into single data lake supporting 127 countries and 100,000 employees
- Enabled regulatory reporting, signoff, and decision making, consolidating reporting into 4 dashboards; answering 95% of financial and tax questions
- Qualified tax exposure, enabling analysis through dashboarding
- Automated and simplified auditing with detailed lineage, reducing time by 18% and consultant’s cost
- Standardized metrics and CoAs across the organization, increasing budget to plan accuracy and business understanding to enable proactive decisioning