Case Studies

Blue-chip ASX-listed mining company
Mining processing plant

Global Tax Model Optimisation

The ASX-listed Mining Company initiated the Global Tax Model Optimisation Project to enhance the accuracy, efficiency, and compliance of its financial modelling across global operations.

Objectives

  1. Enhance Precision: Improve accuracy and consistency of Excel models for tax management.
  2. Standardise Practices: Implement best practices for uniformity and operational efficiency.
  3. Prevent Inaccuracies: Ensure no material revisions are needed in financial reporting.

Key Deliverables

  1. Risk Assessment Framework: Evaluate financial risk and model quality.
  2. Enhancement Procedure: Guide model owners through structured improvements.
  3. Training Modules: Train stakeholders on new standards and methodologies.
  4. External Remediation: Remediate high-risk models using best practices.
  5. Performance Tracking: Monitor progress with detailed performance reviews.

Approach

  1. Performance Monitoring: Conducted a model risk assessment for each model and combined results using a risk heatmap for visual comparison and quick identification of high-risk models.
  2. Risk and Compliance: Developed a comprehensive framework to identify and mitigate risks.

Outcomes

  • Improved Accuracy: Improved accuracy/consistency of financial models.
  • Increased Stakeholder Confidence: Enhanced stakeholder confidence through effective risk management.
  • Improved Procedures: Standardised practices helping to ensure compliance and effectiveness.
  • Continuous Improvement: Established a robust framework for ongoing enhancements, including a structured change management procedure for updating financial models.
Global resources leader
Aerial view of resources operation

Strategic HR and Optimisation Tool

The Global Resources Leader required a Shutdown Optimisation Strategy Tool to be developed, aimed at ensuring operational efficiency and maintaining a base minimum of 300 maintenance staff during shutdowns.

Objectives

  1. Optimise Staffing: Maintain a base minimum of 300 maintenance staff.
  2. Streamline Operations: Enhance efficiency in maintenance scheduling and resource allocation.

Key Deliverables

  1. Optimisation Tool: Develop a tool to streamline shutdown processes and resource allocation.
  2. Integration Support: Ensure seamless integration with existing systems.
  3. Training and Support: Provide training for effective use of staff.

Approach

  1. Detailed Analysis: Conducted an in-depth analysis of existing shutdown processes to identify inefficiencies.
  2. Best Practice Modelling: Applied best practice principles to develop a robust, adaptable tool.

Outcomes

  • Enhanced Operational Efficiency: Significant improvements in scheduling and resource allocation.
  • Optimal Staffing Levels: Maintained a base minimum of 300 maintenance staff effectively.
  • Cost Savings: Reduced downtime and operational disruptions, leading to cost savings.
  • Improved Productivity: Streamlined maintenance operations, enhancing overall productivity.
  • Collaborative Development: Worked to ensure that the tool could be converted into software post adoption.
Premier ASX-listed energy company
LNG trucking operations

Trucking Advisory Model

Redeveloped the Trucking Model in preparation for customer negotiations. This project involved creating a joint venture (JV) 3-way model and a summary model to support strategic decision-making.

Objectives

  1. Improve Data Analysis: Increase the model's capability to receive and analyse data.
  2. Enhance Adaptability: Ensure the model is adaptable for future requirements.
  3. Facilitate Negotiations: Provide a robust tool to aid in customer negotiations.

Key Deliverables

  1. Model Enhancement: Redesign the model to improve data handling and adaptability.
  2. Summary Model: Develop a summary model for ease of reference during negotiations.
  3. 3-Way JV Model: Integrate 3-way JV model.
  4. Integration: Ensure seamless integration with the Company's existing systems.

Approach

  1. Diagnostic Assessment: Conducted a thorough review of the existing model.
  2. Best Practice Modelling: Applied best practice principles to enhance the model's structure and functionality.
  3. Stakeholder Engagement: Collaborated closely with the Company's team to align the model with strategic objectives and operational needs.
  4. Iterative Development: Used an iterative approach to continuously refine the model based on feedback and testing.

Outcomes

  • Enhanced Accuracy: Improved the usability and reliability of the trucking model.
  • Increased Efficiency: Streamlined the modelling process, reducing the time required for analysis.
  • Improved Adaptability: Ensured the model can easily adapt to future changes and requirements.
  • Strategic Tool: Provided the Company with a robust tool to support customer negotiations.
Blue-chip ASX-listed mining company
Mining operations workforce

Treasury/M&A Model Redevelopment

Redevelop the existing Treasury Moody's/S&P Credit Rating Model, used at the board level for decision-making, to improve adaptability, scenario selection/analysis and M&A activity.

Objectives

  1. Increased Reliability: Through aligning S&P/Moody's ratings with the internal metrics of the business inside a more transparent model.
  2. Improve Adaptability: Enhance the model's ability to receive and analyse data.
  3. Incorporate M&A Analysis: Add functionality for M&A analysis.
  4. Increase Auditability: Ensure the model is transparent and easily auditable.
  5. Streamline Processes: Reduce process time and improve efficiency.

Key Deliverables

  1. M&A Functionality: Integrate M&A analysis capabilities into the model.
  2. Improved Accuracy: Identify and improve accuracies in the existing model.
  3. Model Enhancement: Redesign the model to improve data handling and adaptability.
  4. Auditability: Implement best practices to ensure the model is easily auditable.
  5. Process Streamlining: Simplify and accelerate the modelling process.

Approach

  1. Diagnostic Assessment: Reviewed the existing model to identify areas for improvement.
  2. Best Practice Modelling: Applied best practice principles to enhance the model's structure and functionality.
  3. Stakeholder Engagement: Collaborated with the Company's team to align the model with strategic objectives and operational needs.
  4. Iterative Development: Used an iterative approach to continuously refine the model based on reconciliation with previous dataset, stakeholder feedback and testing.

Outcomes

  • Enhanced Accuracy: Improved usability, precision and reliability of the Model.
  • Increased Efficiency: Streamlined the modelling process, reducing the time required for analysis.
  • Improved Auditability: Ensured the model is transparent and easy to audit, increasing trust within the business.
  • Strategic Capabilities: Added functionality for M&A/scenario analysis, enhancing strategic decision-making.
  • Stakeholder Confidence: Strengthened confidence in the model's results and its integration into the business's financial planning process.

A note on names: client names are withheld for confidentiality purposes.

Start with the free assessment

Under 5 minutes, no obligation.

Take the free assessment