+ 61 3 9020 2085 info@parityanalytic.com.au


Share this article

The Brief

Our client is a leading manufacturer with 85% market share in their sector in Australia and NZ.

The client was looking to develop a model to help assess manufacturing constraints under different operating and demand scenarios.  The model was required at a corporate level to help understand and optimise operational constraints, as well as assisting with the development of business cases for improvement and expansion capex. The key requirements were:

  • Ability to calculate demand and throughput down to a site and process level, on a monthly basis
  • Allow the business to test the capacity of the existing facilities to handle abnormal demand, and to identify process bottlenecks 
  • Importation of 18 month forecast base level demand data for each product, by month
  • For each demand scenario, and for each process stage, the reporting of total throughput, capacity utilisation, and hours runtime

Our Approach

Parity worked closely with the operations planning team to develop an understanding of the manufacturing processes at each site. This was mapped out in a process flow diagram, which included rated capacities and manufacturing constraints for each process stage.  A separate mapping exercise was then applied to the client’s product range to understand the process path and throughput for each.  A capacity planning tool was developed using Microsoft Excel, with Power Query used to import demand data from the client’s business system.  A scenario planner was developed to allow the client to easily test the impact of abnormal demand, and to mitigate by either shifting production, adding shifts, or investing in additional capacity.  The tool was built flexibly to be easily modified for new products or processes.  The core output was via a heatmap, which allowed the business to quickly identify bottleneck ‘hotspots’ for various process stages over time.


The capacity management tool provided the operations team with visibility as to potential future capacity issues. The team now has a quick and simple way to:

  • Identify periods where demand exceeds capacity
  • Re-organise operations to meet this demand
  • Plan major capital investment in new machinery as it becomes required

“The core output was via a heatmap, which allowed the business to quickly identify bottleneck ‘hotspots’ for various process stages over time.”

Share this article
Project Financing

Project Financing

Our client is a leading Australian independent school that regularly places in the top 10 schools for academic results in Victoria. The client needed various…

Fund Modelling

Fund Modelling

The trustee to one of the leading industry super funds in Australia was evaluating alternative strategies to reduce costs to its members, including the option…

Inventory Management

Inventory Management

Our client is a specialist whisky distillery which distributes in North America, Europe and Australia. Known for its distinct brands, they have rapidly grown off…


+ 61 3 9020 2085

Level 19, 15 William Street,
Melbourne VIC 3000

Home                    Careers

About Us               Contact Us

Our Work              Privacy