Monitoring the Cost per Unit in realtime could perhaps have been a decision support tool to highlight what action to take and when to take it.
Cost per Unit is easy to calculate. Just divide the total costs with the number of units produced. But that merely shows the volatility of the cost level, that can be used to set the Profit Margin. Identifying Min/Max periods and the fluctuation is a help though.
Grouping the costs gives a better indication. Ingredient costs and Energy costs are volatile market prices and something you are not in direct control of. We call this Volatile Cost per Unit. To level it with the overall Cost per Unit, we include the yearly average of the other costs.
Salaries, Equipment and SG&A is something you can control directly and change. We call this Fixed Cost per Unit – we know they aren’t fixed per se. And again, we include the yearly average of the volatile costs to keep it in level. This is the graph it produces:
Everything looks well balanced beginning of year. The Volatile Cost Per Unit is well aligned with the overall Cost per Unit. When the equipment was getting upgraded the Fixed Cost per Unit peak.
It clearly shows in April that the margin would be very low as the gap of the cost price and retail price is low. We would of course know that in advance when the equipment order was made. The volatile cost went under the radar here.
In July you can see the grey curve is now the main driver of your expenses. This is a strong hint you should monitor and prepare a contingency plan. The volatile Cost per Unit was higher than the overall Cost per Unit! In August it had been for 3 months straight.
A price increase could have been introduced at that time. Instead price was increased in november but the increase was too small to withstand the increase in energy costs as well. The best scenario could have been raising the retail price to 5.6 in August and again to 5.7 in November to secure Profit Margin.
The Cost per Unit calculations can show many different scenarios including the impact of Downtime. Planned as well as Unplanned.
If you have Planned downtime, you are in control and know when the impact comes and can adjust accordingly. You know the decrease in output albeit the Fixed costs remain the same.
Unplanned downtime can be calculated the same way. The time period, the cost in that period and the output in that period. This can be aligned in the total Cost per Unit and give a strong indication early on, on what this means to the margin. It allows other departments to adjust, ex. adjust the discount levels, retail price and/or start negotiating new deals in the supply chain.
Everyone working for the company should know the Cost Per Unit and how they can affect it positively. But in a time of inflation volatility is the problem, and best to be prepared for it.
Graph Details
You can clearly see the Volatile Cost per Unit (grey) is above the total Cost per Unit (red) already in June, well before we saw the Profit Margin drop in October. When both Volatile and Fixed Cost per Unit are higher than the total Cost per Unit, trouble is a brewing!