Our client is a leading manufacturer in the Agribusiness sector with facilities in Australia and New Zealand, and a key supplier to local and Asian markets.
Our client initiated a Cost-to-serve project, the objective of which was to allow it to understand the profitability of each customer account, as well as each product, based on the actual business activities and overhead costs incurred. To support this, they required a process driven costing tool, the key requirements of which were:
- Development of a data repository and calculation engine
- Linking of the tool to the existing business systems
- Cost allocations based on key activities as well as customer behaviours
- Flexible drill-down capability including customer, product, sales representative and market segment
- The tool needed to be simple to update and user friendly, in order to be easily used by personnel across the business
Parity worked closely with the finance team, as well as key personnel in key departments including sales, customer service, planning, logistics and manufacturing. We conducted interviews across the business to understand the key cost drivers and available data in addition to working with the business to define the key activities to be considered by the model. Based on this we developed an analysis structure and cost allocation methodologies.
The Cost-to-serve model was developed using Microsoft BI tools including Power Query and Power Pivot and validated against known costs and the general ledger.
The Cost-to-serve model was used by several departments within the business. It allowed the client to understand the total contribution to the bottom line by customer and product, as well as how specific customer demands impact cost and profitability. The model facilitates this through a cube-type functionality that allows data drill-down for both standardized reporting and ad hoc analysis.
“Parity worked closely with the finance team, as well as key personnel in key departments including sales, customer service, planning, logistics and manufacturing.”
Through the insights gathered from the model, the business implemented a number of initiatives which included the development of a logistics costing tool and the redesigning of their quoting process to improve pricing outcomes.
Melbourne, 31 March 2022: Parity Analytic, a leading Analytic Consulting and Financial Modelling firm in Melbourne, has merged with local firm Delineo Financial in a move towards further growth.
Brownlow Medal 2021 Prediction Share this articlelinkedintwitterWith the AFL confirming the Brownlow Medal ceremony is to be held on Sunday, 19th September we dug out our trusted Brownlow Medal machine learning model to see if we could predict the 2021 winner.Last...
Brownlow Medal Prediction Using Excel Based Machine LearningShare this articlelinkedintwitterA spreadsheet-based regression model using Neural Networks to rank this year’s medal contendersBy Stephen Huppert and Jack LanghammerIt may not be September, and the finals...