Mannington Mills Transforms Their Financial Consolidation Planning and Reporting.

Mannington Mills in Salem, New Jersey, is a leading provider of flooring solutions to both the commercial and residential markets.    Mannington’s residential products include sheet vinyl, engineered hardwood, laminate, carpet, and residential LVT (luxury vinyl tile) and their commercial products include sheet vinyl, LVT, carpet, and rubber flooring and accessories.  Mannington’s international division, Amtico International, provides LVT products in both residential and commercial markets primarily in the U.K. and Europe.

Assessment of Legacy Financial Systems with Newcomp

Through their growth and global expansion in the mid 2010’s, Mannington was increasingly frustrated with their existing planning and analytics solutions. Originally implemented in 2008, Mannington’s legacy system built inside of IBM Cognos TM1 (now rebranded as IBM Planning Analytics with Watson) was overly complex and could not efficiently and effectively meet the business requirements. Joe Andronowitz, VP of Finance at Mannington Mills explains, “The legacy system included several unused data cubes, inconsistent master data and was labour intensive to support. End users were frustrated and needed to rely on manual excel spreadsheets to consolidate and report our financial results. We had just enough bandwidth to keep the lights on and keep the system running; we needed a technical partner to pursue our financial transformation projects.”
In an effort to improve the efficiency of their legacy system, Mannington turned to Newcomp Analytics to diagnose and identify the system’s pain points and propose a remediation plan. Although the initial analysis completed by Newcomp led to some quick wins and fixes on the legacy system, the final recommendation was to implement a new solution based on best practices. Joe explains, “The conclusion based on the study of the legacy system was that the design was so poor that it couldn’t be remediated or meet our new business requirements.”

“The legacy system included several unused data cubes, inconsistent master data, and was labour intensive to support. End users were frustrated and needed to rely on manual excel spreadsheets to consolidate and report our financial results. We had just enough bandwidth to keep the lights on and keep the system running; we needed a technical partner to pursue our financial transformation projects.”
– Joe Andronowitz, VP of Finance at Mannington Mills

Implementation of Consolidation and Planning Solutions Based on Best Practices

Expanding on their recommendation, Newcomp proposed developing two new solutions to replace Mannington’s legacy system. The first was a financial consolidation and reporting system, which included legal and management consolidation. The consolidation system needed to be able to produce U.S. GAAP financial statements, including balance sheets, income statements, shareholder’s equity, and cash flow statements for Mannington’s multiple legal and management entities across the U.S. and in the U.K. and Europe. 
The second solution was designed to replace Mannington’s legacy planning system and enable planning at the business unit, profit center and channel levels. In order to help Mannington achieve their planning goals, the new system needed to provide business performance and profitability details at the business unit, product group, product line and channel level. 
Newcomp worked closely with the team at Mannington to successfully implement the financial consolidation and reporting system and then rolled out the new planning system shortly after. Joe was impressed with Newcomp’s ability to adapt the project scope during the implementation process. Joe says, “Newcomp’s flexibility helped them develop and deliver solutions that really fit our business which is constantly undergoing change, from evolving market strategies to the addition of new acquisitions.” 
The solutions were designed using best practices, leveraging master data from Mannington’s SAP ERP system, automated daily loads, and standardized consolidation processes and reporting.

NEWCOMP'S APPROACH

Implementation of Consolidation and Planning Solutions Based on Best Practices

Newcomp proposed developing two new solutions to replace Mannington’s legacy system:
Step 1 – A financial consolidation and reporting system, which included lefal and management consolidation.
Step 2 – A new system to provide business performance and profitability details at the business unit, product group, product line, and channel level.
 Throughout the project, Mannington appreciated Newcomp’s efforts to minimize costs. Joe Andronowitz, VP of Finance at Mannington Mills explains, ”Newcomp effectively leverages technology to work remotely with a very limited need to work onsite, minimizing travel and entertainment costs that are typically associated with onsite consultancy.”
 Mannington believes Newcomp’s unique approach helps set them apart from other analytics consultants. Joe adds, “I partnered with many consultants in my professional career, and Newcomp stands out as a firm that provides both the technical and functional finance expertise cost-effectively.”
Team icon

Reduced Cycle Time for Financial Consolidation and Real-Time Access to Financial Results

By designing and developing using a “no touch data integration approach” from Mannington’s SAP environment into TM1, Newcomp was able to deliver a financial con- solidation and reporting system that reduces consolidation cycle times and provides easy access to up-to-date financial reporting. Joe says, “We report our Business Unit profitability daily and report consolidated financial results on day six of our close, across all entities in U.S. dollars and different functional currencies. It’s helped us drive effectiveness and efficiency in our financial consolidation and reporting. It used to take up to six minutes to open the legacy excel based financial consolidation, and now, reporting is essentially on demand, and analysis occurs in real time.”
With jobs now running overnight, information is refreshed each morning, providing Mannington with current financial and reporting data throughout the day. Having quick access to updated financial information has allowed Mannington to focus on common KPIs across the businesses and automate their cash flow planning to drive consistency along all product lines and business units. Joe adds, “Business Unit partners receive accurate and timely financial performance reporting to optimize business decisions and improve our financial performance.”
The newly implemented planning system has enabled Mannington to improve their planning for future growth opportunities by giving them the ability to truly understand product and channel profitability as well as cash flow and return on capital. Joe says, “It has really helped us deeply understand the profitability by product line, channel and in some cases by customer. That has helped us understand where we want to invest resources and where we might pull back.”
The consolidation and planning solutions delivered by Newcomp have also helped to increase the visibility of important metrics for key Mannington stakeholders. “We are able to leverage the solution to easily deliver common and consistent reporting for our senior leadership team, board members, and lenders. We can produce a common book that highlights the same P&L, cash flow, and return on invested capital across all the businesses every month.”

The Outcome

01

Common & consistent reporting

02

Automated cash flow planning

03

Effective & efficient financial planning

04

Increased visibility of important metrics

05

Current financial & reporting data

06

Understand profitability & return on capital

Newcomp Analytics Logo
IBM logo

REVOLUTIONIZING BUSINESS THROUGH ANALYTICS

We partnered with IBM because we know you’d rather have deeper insights in hours than weeks. IBM empowers organizations to make smarter decisions through every stage, spanning every kind of industry. With a portfolio that covers the entire ecosystem of data, IBM provides analytics solutions that fuel digital transformation. Available on the cloud, on premises or in hybrid deployments, IBM provides flexible offerings to answer the toughest business questions, uncover patterns and pursue breakthrough ideas.