First Quantum Uses Advanced Analytics to Predict COVID-19-Related Supply Shocks

By Preferred Strategies  |  September 9, 2020

Share this post:

First Quantum Minerals Ltd. (TSX:FM) is a global copper company that operates long life mines in several countries and employs approximately 20,000 people world-wide. First Quantum has an effective 90% ownership of Cobre Panama.

Using Data & Analytics to Proactively Manage the Supply Chain

The COVID-19 pandemic has brought a tremendous amount of uncertainty to businesses and supply chains around the world. To mitigate that uncertainty, the Information and Communications Technology team at Cobre Panama jumped into action. “We did something cool today—we created a live model that looks at possible supply shock risks as a result of COVID-19,” said Mario Romera, ICT Superintendent, Cobre Panama.

Their algorithm is based on the following reasoning:

  • Supply shocks are most likely in jurisdictions experiencing a rapid rise in new COVID-19 cases
  • The stock of inventory is weighted by where it is sourced from, with a five-day moving average of new cases per stock line item
  • The above assumption is then cross-referenced with current shipping restrictions and limitations due to COVID-19
  • The resulting algorithm is:
    [Stock at Risk] = [Qty on Hand] – [60 Day Average Consumption]-[Reorder Point] (Indicated where stock will fall below the reorder point in 60 days time, weighted for the COVID-19 Risk Factor)

The procurement and warehouse teams are using this model to explore and drill down to individual stock line items, by supplier and region. One use is to apply the algorithm to the most critical line items and contact the applicable suppliers to make contingency arrangements — before they become a problem.

The JD Edwards data required for this analysis is obtained from the Preferred Strategies QuickLaunch Enterprise Data Warehouse (EDW). First Quantum implemented the QuickLaunch EDW in early 2019 when they undertook an enterprise-wide data and analytics infrastructure upgrade. At the time they considered building their own EDW, however selected the QuickLaunch product with Microsoft® Power BI when they realized they could be up and running in just a few months, as opposed to the year or more that a completely internal project could take. QuickLaunch demystifies cryptic JDE data values and seamlessly connects that data to analytics tools such as Power BI—all under a secure and governed environment.

Enabling Self-Service Analytics for the Commercial Team

In addition to their timely application of predictive analytics to the supply chain, the team has also recently created a whole data suite for the commercial area, including procurement, sales and warehouse. “The commercial area went from having no visibility into their JD Edwards data to having full control over what is happening,” said Romera. This triggered a major working capital project that will use machine learning techniques to optimize inventory management as a first step. Now business analysts have easy access to data—and a better understanding of the potential of the EDW—and advanced users are even better equipped to get the best out of the tabular model and data warehouse.

Image 2: Decomposition of Inventory drill-down analysis

Contact: Mario Romera, ICT Superintendent, Cobre Panama

About the Author

Preferred Strategies

Preferred Strategies is helping hundreds of JD Edwards and Viewpoint Vista customers to realize the full potential of their ERP data through the innovative Preferred Strategies QuickLaunch product.

Related Articles

July 07, 2021
Power BI Updates for QuickLaunch Customers: Q2 2021

The Power BI team has been releasing new features in full force. Q2 has seen a steady stream of updates to all areas of the platform.

Read More >
March 23, 2021
Power BI Updates for QuickLaunch Customers: Q1 2021

Power BI was named a leader in the Gartner magic quadrant again this year. (Be sure to check out our interactive analysis of the Magic quadrant here.) A major factor of Power BI’s success has been the dedication by Microsoft to continuously improve the Power BI product suite with updates that are demand-driven and consistent.

Read More >
March 08, 2021
Interactive Gartner Magic Quadrant for Analytics Trend Analysis

In this article we showcase an interactive version of the Gartner Magic Quadrant for Analytics and Business Intelligence (ABI) built using Microsoft’s Power BI platform. Using this interactive view of the data, you can see how vendors have trended over the past 11 years.

Read More >