Consolidating Financial & Operating Reporting
The Situation
A light manufacturer of shelters and canopies had recently acquired a steel-storage manufacturer along with two smaller tuck-in acquisitions. The company wanted to automate and integrate the reporting and analyze various drivers of profitability on a granular level (e.g. channel, segment and product views). Accordion was brought on board to analyze and cleanse historical data, link disparate data systems (multiple systems in US and China), eliminate manual processes and develop a reporting tool to view granular data.
Services
Actionable Business Analytics
Stakeholder Reporting & Strategic KPI Enhancement
The Execution
- Partnered with the CFO and her team to aggregate and cleanse historical data (using advanced data analytics tools, analyzed and organized over 1,500,000 lines of data.)
- Integrated the data into a model encompassing all four companies allowing for consolidated views.
- Developed a reporting tool with outputs for key areas, such as financial performance variance and trends, monthly unit economics (including underlying production economics in China), customer scorecards & trends, segment analysis, FX calculations, multiple cost center reports etc. (total of more than 120 analytic outputs were created.)
- Created various methodologies for manipulating the data in the various systems to create analytics that addressed key questions such as the ‘true’ profitability of US vs China manufacturing, breakdowns of materials costs, labor and overhead.
Results
Ultimately, our team developed fully integrated operating and financial models across four previously separate entities. This enabled granular reporting and saved considerable time and expense that would have been involved in installing a new ERP system.