fbpx

Stellar & OJI Fibre Solutions

Case study

Oji Fibre Solutions is a leading producer of market pulp, paper and fibre based packaging in New Zealand. Like the parent company from Japan, Oji Fibre Solutions is an organisation focused on the future. They are committed to delivering innovative, environmentally sustainable products, and working collaboratively to develop solutions that enhance the competitiveness of their customers.

https://www.ojifs.com/


The challenge

OJI Fibre Solutions (OjiFS) packaging division was looking to improve its corporate reporting solutions by replacing old technology and multiple data sources with a central user-friendly environment. They were also keen to move to a governed solution for their specific business needs and needed a strategy and framework to take them forward.

Stellar was engaged to work closely with OjiFS to design a BI roadmap, identify opportunities and create a program of work.

The following reports were initially selected:

  • Reporting tools review of using SAP Analytics Cloud (SAC) and Microsoft Power BI (PBI)
  • Manufacturing margin and profitability
  • Plant operational reporting
  • Plant maintenance costs and scheduling
  • Investment management and project reporting

The solution

Tools reviews

In the first project, Stellar undertook a toolset analysis of using SAC and PBI, including features and benefits comparison. We provided a proof of concept design with both tools delivered for business reviews.

Margin and Profitability

The margin analysis for the Australian manufacturing plant projects involved detailed analysis of source systems and business requirements definition. We designed a data extraction process from the Kiwiplan ERP solution and transformed the data, that enabled comparisons between planned and actual production costs to be analysed. This also provided a view of customer profitability, with a drill down to production order level.

Plant Operational Reporting

Packaging manufacturing plants in New Zealand had been using a manual extract and load process that required many days of manual analysis by three individual plants, to prepare the data from sixteen source systems. The summarised data was then sent by the CSV file for consolidation. The data consisted of financial and non-financial information. Stellar replaced the legacy system and delivered a suite of queries to support business analysis. Most of the data could be then automatically extracted from the source systems and consolidated into a single reporting model.

Plant Maintenance

Stellar provided SME and technical support on the extraction and transformation of key SAP data to release one of the plant maintenances projects and will continue to do so for the next release packages.

Investment Management

Stellar currently provides SME and technical support on the extraction and transformation of key SAP data to the investment management project. This encompasses providing datasets to fulfill the requirements for three different types of reporting for Engineers, Capex Forecasting and Project Managers.

BAU and SME Advice

Stellar provided business as usual support for the SAP BW solution. We added best practice advice and documentation standards, as well as design and release processes, and system monitoring and performance reporting.

“Stellar was initially engaged for their thought leadership and Quality Assurance. Since this initial engagement, they have consistently delivered on the Digital Transformation project I have been running and have on more than one occasion exceeded my expectations.”

Graham​ Plowman, PMO Manager for Oji Fibre Solutions

Business benefits

  • Improved cost management and visibility of customer profitability by market segment
  • Significant reduction in manual processing
  • A new consistent method of calculation and user flexibility on reporting structures
  • An improved solution to monitor plant maintenance costs, planning and reporting
  • Automated project and investment reporting, saving data collection time, improved frequency, and accuracy of data and its presentation
  • Enhanced accuracy and improved efficiency with a simple, sound, and scalable governance structure that meets the business needs and support teams’ requirements

 

 

Download Case Study as a PDF

CLICK HERE