Production costings & Master data
Most operational management members in the meat or food industry have a view on how a product should be costed because they understand the raw material and the flow of the product. Nearly all accountants have a view on how a product should be costed as they understand the numbers. However, to build meat industry master data you need to be able to understand:
The list continues. AFSI can help you set up your production data, so your operational variance is accurately reflecting what you are seeing in production. AFSI will help you set up a master data structure that ensures that standards are at a level that ensures profitability and accuracy as well as setting up operations
Why is it important to know the cost of a product? A product should be sold at the value it can achieve – not cost plus margin.
Why sell a product at less than the market is willing to pay? Selling below market value may be a good idea, if the margins still enables a profit, as it could grow market share. However, not knowing the product cost is comparable to driving blind.
Looking at a market price and then undercutting the cost, will inevitably result in sales, but if the product is sold at less than cost, then an enormous sales turnover is not good for business.
Understanding the costs of production enables a more comprehensive understanding of all the elements of you business. How can a commercial margin be derived if the cost of the product is not accurately defined? It cannot, so if cost is not understood neither is commercial margin.
How is a product costed?
In an assembly business, calculating the cost of the material is straight forward. Each raw material will have a procurement price, and a volume will be required of each component. Times the volume with the cost for each component, add the cost of loss, and add it all up to arrive at the aggregated material cost.
Component = c
Volume = v
Procurement price = p
In the primary meat industry where one unit is disassembled and then becomes several subcomponents, the calculation is less objective, as the price will have to be defined for some of the subcomponents to enable a calculation. If it’s a premium raw material, it must also be decided which components are to recover the premium.
One method is to fix the by-product costs at the cost the by-product can achieve in the market and then balance the remaining cost back on the product that is being priced. (Also called return calculation)
The by-products are given a price and the prices are then multiplied with the expected percentile outcome of the by-product in relation to total batch size.
This is done for each by-product component and the remaining percentage of product will then be the main product. All the by-product values are then subtracted from the raw material cost which will equate to the material cost of the main product per unit* (Example 1). The calculation can also be executed with the total volume prices (Example 2).
*The unit can represent kg, lbs., metric tonnes or whatever measure is relevant for the context of the calculation.
See examples below:
How is yield & cost price defined?
Calculating the yield is essentially dividing the individual components, derived from disassembly, with the originating batch weight to identify how large a percentile proportion the component has returned. The difference between the total volume of subcomponents and the raw material volume is the loss. Whether it is a good or a bad yield, depends on the standard and the standard depends on the quality attributes that the product will be measured against.
In the meat industry the volume is, predominantly, expressed in weight when yields are calculated, but which weight do we choose for batch weight? When is the product finished? Where and how should costs be attributed?
The original product in the meat industry is an animal. The animal will go through various stages to become a finished meat product. Each process has a cost associated with it and the process is often defined by the arrival at inventory and the cost is evaluated after inventory to account for any evaporation or drip loss.
In the abattoir, the process is completed at the end of the chilling process. Defining the direct cost per unit is relatively straight forward at this stage, despite some disassembly taking place, the unit is still a carcass.
Arriving at the cost value* is done by: adding all direct, variable and fixed overheads costs to the product, subtracting any revenue stream directly generated in the abattoir, and then adding the cost of chill and process loss. See example below:
*Cost value, in this context, is product (animal) procurement costs – revenue + process cost (incl. overheads) + cost of chill and process loss. Commercial value is cost value + margin. Cost price ≠ commercial price
Mapping out overheads
From a pure cost perspective, most of the costs can be accurately identified. There will be indirect costs that can be directly associated with the abattoir process.
The utilities costs can be obtained by sub metering in the department, so the exact cost of liquid petroleum gas (LPG), electricity, water, or any other utility can be obtained. Depreciation of any equipment that is directly associated with the process in the abattoir is an abattoir cost, any salaries that are directly associated with the abattoir can be directly attributed to the abattoir process cost.
However, there are also costs that are more difficult to attribute directly to a process. E.g., rents and rates, senior management, functions that service the whole of the process from intake to dispatch, depreciation, or the whole of the building and so on.
The distribution of these more general overheads calls for political intervention, as there is a business choice to make. A distribution key based on machine hours, labour hours, square meters, or whatever the chosen metric might be, could be used for the cost allocation. It could be argued that more than one distribution key is required to make sense of the distribution. If the distribution keys make mathematical sense, then they will enable a more accurate approximation of the final cost price.
Ensure overhead recovery
Distributing overheads on all the products can be a disadvantage if all the products don't go through all the processes. For example, if the product is sold as a carcass and the cost recovery model is recovering the generic overheads in the butchery process, not all the overheads will be recovered.
If a carcass is sold, rather than processed within the confines of the original business, then the commercial margin or the cost price has to ensure that the procurement cost that the procuring companies can secure the product at, is high enough for them not to take away business from the originating business’s butchery or further processing.
Some companies load all their costs onto the first point of sale, e.g., a carcass, and some companies just divide their total overheads with the total units sold and then call that overhead per unit. Mathematically neither model reflects the accurate cost of the product, but the former is more likely to ensure that all costs are recovered than the latter. One way to ensure that the overheads are recovered is that any overhead cost that cannot be "turned off with the process" is recovered at the first point of sales. i.e., If butchery is not producing one day, there will be no consumption of utilities, but rent and indirect salaries would still have to be paid.
Perhaps, a hybrid of overhead costs directly associated with the process and a recovery of the generic overheads at the first point of sale would make most business sense, though some frozen products may end up struggling to recover their costs on their own. The purest form mathematically would be to show the costs where they belong and then adjust the desired market impacts in the commercial margin. Though understanding the cost of the product will enable shrewder business decision, some costs are inevitable and some political re-balancing of the values is required for it to make sense from a business perspective.
Once an overhead model has been chosen, the costing of the product continues through each stage, and at each stage the entry weight is the volume which the yields are measured against. Standards for labour, yield and overheads, as per the previous example, will have to be established at each process step. Thought there may not be a sale in the department, the understanding of the cost at each process enables a procurement cost price for the following department. The cost needs to include any process loss, so the final product cost price is transferred to the following department at a cost that accurately reflects the value added to the product.
So, to return to the question about which weight is used for batch weight and which is used for finished product; the finished product yield is when it’s sold. The finished units that the customer is paying for is the finished yield. i.e. how much of your original material has been converted to saleable product. Any yields measured between procurement and sales are a cost price value and a process control step.
In theory, the abattoir hot scale weight could be utilised for all the batch weights once standards have been accurately set throughout all the processes. It wouldn’t be very logical to do so, but if the mathematics throughout the processes are accurate, it is possible. However, the more processes there are in between the start weight and the finished yield weight, the harder it would become to identify a process defect. What is a more logical and conventional approach, would be to use the batch weight from exit of the previous inventory. So, for primal break it would be the exit of the carcass chillers, for butchery it would be the exit of primal break*, for packing it would be the exit of butchery, dispatch loss would be measured against finished packing inventory and so on.
Not all ID or inventory steps are strictly necessary. It depends to which extent the measurement of production is required or desired. The logic of inventory loss follows through for each subsequent inventory step.
*There may not be a physical inventory step between all the departments, but to obtain yields a registration of weight between the departments is needed. Where there are no changes to the product, e.g., between butchery and packing, the department yields could be combined, but any loss would then also be combined.
Many factories have their butchery lines in-line with cutting and the inventory step is therefore only a gathering of the primal weights. The gathering of weights at this point is crucial as the different primals will be given different prices, corresponding with market value. It could be argued that the cost of the different primals at the stage of entry to butchery are the same, from a cost per weight unit perspective, which would be correct mathematically and could essentially be used for measuring cost performance, but if the cost price doesn’t reflect market price, it could end up driving undesired behaviours in production. This is where carcass modelling adds further subjectivity to the primary costing process, as the cost of the carcass would have to be distributed between the primals, proportionately reflecting what is believed to be obtainable in the market. What is meant by proportionality reflecting market values is that the cost prices are only to reflect the proportionate differentiation in the market. It’s not a full market price. It is still a cost balancing exercise where e.g., the shoulder, the belly and the leg cost prices are set and the balance of the cost is put on the loin.
Pricing butchered products
Once the price is set for each primal the same costing process is repeated for each individual finished product. Costs are attributed to the product as per example 1 & 2, but as the disassembly now takes place, which products should the cost be attributed to?
Once again, some business choices must be made. All the costs could be distributed onto all components at a level proportionate to the amount they make up of the batch. This would make mathematical sense. However, there will be some components that don’t attract enough premium in the market to be able to carry the cost of labour, overheads and so on.
If the raw material is a premium raw material, not all the by-products may be able to attract the premium either. It therefore makes sense to attribute the costs to the target product of the process. If a rare breed animal is bought, the whole of the animal attracts a premium, but once converted into products, it might be hard to attract the same premium for fat, trim or bones in the market. Therefore, loading the costs onto the main product makes sense. There would be no point in processing a premium animal if there is no customer willing to pay the premium for the finished product. As such, the main product can be whatever part of the primal desired, if it can carry the cost. Conventionally it is the larger muscles that attracts the premium and are the target for the production run. Anything that is not the main product will be a by-product and the costs need to be established for each component. If a by-product then needs further processing, for example, a collar has to be butterflied and trimmed to a fixed weight, the collar would then be the raw material for the calculation and therefore will be attracting the additional costs. This cost would be loaded into the product code for the by-product that has been subject to further processing.
Cost of packing & inventory
Once the butchery process has been completed, there are no more changes to the product during processing, however, the product can still be subject to change if it waits in inventory.
75% of muscle is water and following the butchery process, where muscles have been opened, lacerations and cut surfaces reduce the water holding capacity of the meat, the drip loss (exudate) is exacerbated. It’s therefore important to understand the impact of inventory on the product before it’s packed and sold.
Blue leg muscles can lose and average of up to 0.71% of weight for every 24 hours despite being held at a low temperature, and not under compression from the weight of other products. Though decelerated, evaporation will still occur unless the product is frozen so the cost of inventory can have a hight impact on the packed yield if not managed.
If the process dictates that the product must be held in inventory, then the loss should be costed into the finished cost price of the product. The products behave very differently. A bone in loin would lose a lot less than trim.
Time, temperature, humidity will all impact on the loss. The most accurate way of representing the loss would be per SKU averaging over a period that includes any extended shutdown periods, as across the weekend.
At the packing stage other elements are added to the direct cost in form of packaging, which would also have to be represented in the final cost price. If the packed product is going to be frozen, the associated overheads would have to be allocated to the frozen products. Transport, shipping, or any other cost incurred before the product is handed over the customer will also have to included in the cost price.
Commercial and operational standards
Once the costing exercise is finished, the commercial margin can then be added or subtracted depending on the product.
If the product is going to secondary processing within the same company, it can be handed over to the internal customer at cost price and the costing of secondary processing can commence.
There are several other factors that must be considered before agreeing a non-standard product with a customer. Raw material availability, volume impacts on overhead recovery models, supply chain setup – pipeline timings, cash tied up in inventory or transit, to mention a few. There are also more nuances to primary costing as e.g. carcass selection, carcass genetics, labour modelling, ID points, downgrades, product cross over from premium to standard due to lack of process control etc.
The balance between a hard standard target and the total return of the product will also have to be considered. If the operational standards are unattainable, it will erode the overall product margin but, on the other hand, if they are too easily attained the overall product price will be uncompetitive, unless the commercial margin is sacrificed.
Master data & code ideology
Depending on the context of the costing and the scale of the business, business process management (BPM) systems and the associated code structures could be a consideration.
In a large scale industrial manufacturing setup; Enterprise resource planning systems (ERP), manufacturing operation management systems (MOM), supervisory control and data acquisition systems, (SCADA) etc., are made use of.
The ERP and MOM rely on the data set up in the costings to measure operational variance in the accounts. It is therefore crucial that the data is as clean an accurate as it can be.
Different companies have different elements within their final codes that links the cost prices of that particular product to that particular code. The ERP would hold all the associated costs and sales information and can therefore be used to execute transactions.
The costs for the products is held in a bill of materials (BOM), which has all the direct cost listed. Raw material cost, labour cost, packaging cost, ingredients or whatever else is used to build up the final product. However, in the meat industry there can be variations to how a product is created, that will still give you the same final product, which is shipped to the customer on the same ERP code.
This is where the MOM comes in play. Variation in raw material (product code variation), or variation in residual specification (recipe variation*) can be handled in the MOM.
*An example of a recipe variation could be that that the standard is expecting a wide collar to be removed from a shoulder specification, but the by-product specification is a narrow collar, which will result in less collar and more shoulder volume when producing this recipe.
To make the most of the raw material procured, the raw material generating the least waste to manufacture the final product should be used. However, if the demand for that specific product is higher than the availability of the best suited raw material, a more expensive raw material may be substituted. This will generate an operational variance which would have to be quantified if the operational accounts are to be accurate. This can also be handled in the MOM system.
In an abattoir different size, quality, and maybe even breeds, of animals arrive. Depending on the quality of the animal, a price per kg is paid. Logically, the better quality the animal is, the higher the price is. Subsequent to slaughter, the animals are segregated and allocated to grades with other animals of the same quality parameters. To ensure that the premium for the grade is recovered these animals are processed separately under a unique product code.
At this point the carcass holds the latent cost & revenue of the onwards process, the actual cost of the animal and the cost of the slaughter process. The product will, most likely, have a cost of the raw material unique to the corresponding grade allocated at this point.
Radio frequency identification tags (RFID) can be used in the gambrels to identify the carcasses at an induvial level which is below the level of the product code. The product codes for the individual grades are known by the ERP, but the individual RFID information is not relevant to the ERP and therefore held in the MOM.
The MOM will have recorded all the information, relevant to the individual carcasses, e.g., weight, lean meat percentage, origin, rectification information or any other information pertinent to the carcass the RFID has been allocated to.
The product information is used by the warehouse system, which is also a part of the MOM, to allocate the carcass to the predetermined grades. If following steps are not continuous, i.e. primal break and butchery are not inline, then further selection of the carcasses based on the RFID information can take place at the point of cutting.
Once the carcass has been divided into primals, the primals are booked out on a new product code and this logic follows through until the point of despatch. Every time anything is booked out of a process, the weight and product type is recorded.
When the products are booked into butchery the MOM knows what product is being released into the process. The more detailed the information about the raw material is, the more accurately the yields of the butchery process can be forecasted.
When butchering there are variations in the products that will require identification, so the yields can be captured correctly, but a proliferation of the ERP codes needs to be avoided. This can be done with a recipe variation in the MOM, as described before with the narrow collar example.
Before despatch the product is packed. The same raw material can have a variety of packing formats. In the case of the collar, it could be individually vacuum packed, packed in bulked bags, bulked packed in a container, clipped, frozen, flushed or something different. Each of these packing formats will have a different cost and will therefor need unique ERP codes.
Having accuracy in the codes and in the standards is an absolutely crucial part of understanding the performance of the operations. For each step of the process the performance needs to be measured in order to understand the overall performance. Understanding costs in detail also provides more information about the commercial performance of the individual products.