SAP Analytics Cloud delivers new insights for AMC Group

AMC Metals
We can now provide the Board with insights into the Group’s performance at the click of a button.

Tulsi Shah

Group Reporting Manager, AMC

The Client

About
AMC Group

Amalgamated Metal Corporation Plc (AMC) is a non-ferrous metals company, involved in the recycling, trading, and upgrading of metals used in the electrification of the planet. AMC is a significant global player, ranging from trading to smelting to the manufacture of performance materials. Comprising over 45 reporting units in 10 countries globally, AMC has recorded a 30% annual growth rate over the past five years.

Understanding the Problem

The Challenge

With multiple business units operating in different local currencies, consolidating financial data and reporting is a complex requirement. To provide a true picture of the organisation’s performance at group and subsidiary level, AMC needs to standardise data, translate currencies and generate clear reports.

Until recently AMC used an end-of-life consolidation package and Excel-based processes to provide key month-end reporting, often resulting in inefficiencies. The business needed to modernise its processes and add intelligent analytic capabilities. It invited Codestone to showcase SAP Analytics Cloud (SAC). Based on the capabilities of the system and Codestone’s expertise, AMC selected it to implement the solution.

Our previous system provided no analysis capabilities and the consolidation process involved considerable manual intervention.

Tulsi Shah

Group Reporting Manager, AMC

metal shavings

The Solution

Making it Work

Codestone implemented a robust SAC solution for AMC’s monthly consolidation and reporting requirements, together with simple-to-use web-based data submission infrastructure. It developed standard templates and a web front end to enable entities within AMC to enter and submit data directly into SAC.

AMC can now easily perform key data calculations, including continuous revaluation from local currencies to GBP. The Group management team has an accurate source of truth from the single database within SAC that consolidates trial balance, profit and loss, actuals, budget and forecast data. In addition, reports that replicate existing formats used by AMC, produce PDF outputs detailing actuals, forecast and budgets at the click of a button for distribution to the management team.

Codestone provided enablement sessions to train AMC users in SAC empowering them to create their own custom reports, analysis and visual data representations to support quicker and more informed decision making. “We are now quite comfortable creating our own graphs and reports,” says Tulsi. “We can now provide the Board with insights into the Group’s performance at the click of a button.”

A challenging but very successful component of the solution was the creation of a highly bespoke cash flow statement. The nature of AMC’s business meant that detailed algorithms need to be incorporated for each line of the report. Tulsi explains, “This is a major win for us as the reports previously required considerable intervention to create the required output, but now those calculations are built into SAC.”

Using SAC’s analytics capability, the reporting team provides AMC management with a clear picture of the financial position across the business; by business unit, country, sector and individual units. “SAP Analytics Cloud enhances our strategic planning activities, and we are continuing to explore opportunities going forward with the insights it gives us. We were not specifically looking for time savings as an objective of the implementation, but we have streamlined our processes and the quality of our data has massively improved,” highlights Tulsi.

With the monthly reporting processes bedded down, AMC has recently engaged Codestone to help extend the solution to produce year end consolidation and reporting for the Group.

SAP Analytics Cloud enhances our strategic planning activities, and we are continuing to explore opportunities going forward with the insights it gives us. We were not specifically looking for time savings as an objective of the implementation, but we have streamlined our processes and the quality of our data has massively improved.

Tulsi Shah

Group Reporting Manager, AMC

Discover the Benefits

  • 24/7

    AMC has replaced out-of-date and labour-intensive processes by streamlining and enabling robust consolidation

  • cloud

    The resilient cloud solution provides access from any AMC location

  • chart

    Empowered AMC staff can build their own analysis graphs and reports

  • scale

    AMC can easily drill down to get cash flow data by country or legal entity

  • Support

    The business is fully supported with access to our experts

Codestone impressed us from the first demonstration and has supported us in transforming our consolidation and financial reporting at group level. We now have the skills to take the solution to the next level ourselves, gaining new insights by building analytics with SAC

Tulsi Shah

Group Reporting Manager, AMC

Cookie Consent with Real Cookie Banner