Transportation & Logistics
MERU CASE STUDY
Fully automated FP&A reporting for a $350 million waste management company
COMPANY OVERVIEW
- Waste management company in California with 5 different business lines
- Annual revenue between $300-350 million
- The Company’s business lines operated as individual entities, and each had their own ERP and accounting systems, making P&L reporting highly manual and error prone
- Due to the disparate systems, senior management was unable to see drivers of profitability in real time to make day-to-day decisions
- Not being able to report on waste allocation posed a regulatory risk that could result in large fines from the state of California
OUR APPROACH
- Conducted 4-week data maturity assessment and built an FP&A reporting solution
- Visited all facilities to understand operational processes and identify pain points due to a lack of reporting capabilities
- Recommended an optimal data architecture to enable data integration for real-time analytical reporting
- Automated P&L reporting from 5 disparate accounting systems into one consolidated suite of dashboards
OUR IMPACT
MERU’s FP&A reporting solution automated 2 FTEs worth of effort and reduced the time to report from 1 week to 60 minutes, which in turn reduced the monthly time to close.
The solution eliminated manual excel reporting, reducing user errors, greatly improving financial data quality and reducing regulatory and audit risk.
MERU designed the data infrastructure for the company using a Modern Data Stack approach to create a cost-effective yet scalable data warehouse to integrate all company data in one location for consolidated reporting.