Actual costing

Actual costing is used for measuring the actual cost of a batch and the average actual cost of making a specific product.

In this post, I will explain why you need actual costing, and how to calculate it.

What is actual costing?

We calculate the real cost that we spend on doing every batch by itself. We take the actual cost per batch, and we calculate it per product/per KG or any other unit we use.

Differences between actual costing and regular costing

1. Different purpose – The regular costing is used to calculate the cost of a product, so we will make sure the sale price will allow us to make a profit. The regular costing is made usually in the beginning of a product life in order to decide on a sale price. The regular costing is updated once in a while, usually a long while. Actual costing calculates the real cost of each batch, and therefore we always know what the real cost of production for each batch and each product is.Actual costing - cost per 1000 units

2. Assumptions – Regular costing assume ideal production cost or average production cost, while actual costing is taking the real cost of a batch. For example: Regular costing might assume 2% scrap while in actual batch production we might get only 1% or even 5%. We can see it in the following figure: Regular costing assume that 1000 units will cost 3000$ to produce, but each batch has a different cost. Sometimes more and sometimes less.

3. Actual ver. assumptions – We calculate the  regular costing in order to find the right sale price and to make sure we will make a profit. Actual costing allows us to know just how much profit we made for each customer order.

4. Find production problems/opportunities – Actual costing will sort out the problematic production costs /shipping costs /support costs that we did not take into consideration in the regular costing we did in the past. On the other end of the scale, we will find the products that we are producing in a much cheaper way than we predicted in the regular costing that is based on averages.

Who needs actual costing?

First and foremost, the production people need it. The actual costing will easily show us product that needs a cost reduction process.

The result of the cost reduction process could be:

1. Change the default machine that produces the product to a faster or slower and cheaper machine.

2. Improve the tolerances of the expensive materials so you will use them as little as the spec allows you.

3. Reducing set up time for a product (see the following post)

4. Find the sources of waste and try to eliminate them or reduce them.

5. Use larger batches in each production and/or change the finish goods inventory level.

6. Much more

Actual costing will also find many products that we know how to produce with less cost than we anticipated. From those products, we can learn a lot. If we find out why they cost less, we can

In those cases where we have no success in reducing high and unplanned costs, we need to update the regular costing, so the product will get the right price. In any case, there is no point in producing products that have negative “contribution” (I will explain about contribution later or in another post).

Another solution that I used when we found a high-cost product, and we couldn’t reduce the costs, was to go back to R&D and reconstruct the product so it will take into consideration the production constraints. Usually, this is easy, and all we need is just to ask for it. We saved millions like that.

On the other hand, when we do better than regular costing we need to update the costing so the sales can offer a reduced price to special customers. If we keep the information and don’t share, we might lose a lot of easy sales.

As a summary, I will say that actual costing is used by production people, but people from R&D and management will also have great value in understanding the numbers.

How to calculate actual costing

Calculating the actual costing is a little bit lengthy and requires patience. If you don’t understand something, just send me an email to: theplanningmaster@gmail.com

Costing is based on 3 elements:Costing elements

  1. Direct cost – All costs that will change if we produce one more product or one more KG of product.
  2. Indirect costs of productionFor example: production labor cost. If we produce fewer products this month, we usually pay the same to the production employees.
  3. Indirect costs of the rest of the organization – CEO wages, sales salaries, and everything that is not related to production.

The result of the costing is a cost per product or a cost per KG or any other unit that sales use to sell our products. For the purpose of this post, I will use cost per product unit, but you can do the same with any other units that your organization is using.

Direct costs

These are the easiest costs to calculate. We only take into consideration costs that will change due to the number of units we want in a specific batch. These costs usually are made of:

1. Material cost – We should take the whole amount of material that we consume for the batch including all the waste and defects. You can calculate it like this:

Amount consume = Amount of raw material taken from the warehouse for this batch – Amount of raw material returned to the warehouse for this batch

We do the above calculation for every raw material. Then we multiply it by standard cost or purchase cost of raw material. We can now know the raw material of the whole batch by adding every cost.

Now we will divide the total cost by the amount of GOOD units we produce, that way the GOOD units take into consideration the cost of all the defects.

Material cost per unit = Total cost of raw material per batch / Number of Good units per batch

2. Energy costs – We need to quantify the amount of energy that we use in each batch. energy

If you have electricity meter in front of your tool, then you can take the information from there. If we don’t have that, we can calculate the amount of energy we use per tool hour. We can take it from the tool book or calculate it like this:

Energy cost per tool hour = cost of electricity per hour X (electricity use per month or year / number of working hours)

Energy cost per batch = number of working hours per batch X Energy cost per tool hour

Energy cost per unit = Energy cost per batch / Good units

3. Direct labor cost – We only take costs that can be connected directly to the amount of product that we produce. For example: The tool operator will get almost the same salary if he produces X amount of units or 2X amount of units. Even if the tool does not work, he will still get his salary. On the other hand, if you have a packaging contractor, he will get his money only if there are products for packaging. His payment is a direct cost that depends on the units produced. So in this section, we will only have people that get money only when we actually produce. Possible calculation if the packing workers are getting paid by the hour goes like this:

Direct labor cost per unit = (Number of packing hours in the batch X number of workers X Hourly payment) / Good units

4. Packing materialsthe cost of  materials used for the batch / Good units

 

Indirect production costs

This is the hardest part to calculate since it requires a lot of thinking on which cost should we take and how to distribute it. The regular costing will take all the costs and distribute it equally upon units/KG/working hours or any other unit. We will do almost the same but with a small change and a big impact. For example, we will calculate the average cost of a working tool hour, and then we will multiply it by actual working hours instead of an average number of hours we use in the regular costing. That will show us exactly when we did have a more expensive batch and less expensive one. Wait… let’s start from the beginning…

Elements we will take into accounting: Every production cost that have no direct link to a batch but have a connection to the volume of production. For example: Cost of labor; we will pay the workers their salaries if we are producing a lot or less in the short term, but the number of workers is connected to the volume of production (less volume usually means fewer workers in the long term). Also included are the warehouse personnel, the production control, energy and water that were not included in the direct cost. What’s not to include: IT cost, COO salary, property taxes, etc. Those expenses will go to the fixed costs section.

If we have only one production phase that is similar among the products, then we can just sum all the annual expenses and divide it by the number of good units we produce in a year. The result will be added to each unit.

In many cases, we will have a different and more complex production. We might have more than one step production. Each step will have tool hours or working hours. Let’s assume we will take the working hours of the people that worked on the batch.

Example:Production and packing

Assumptions:

1. The organization has 30 million USD costs in indirect production costs a year.

2. The production is based on 2 steps: Production and packing (no packing contractor).

3. We have 150 workers in the factory that works 300,000* hours a year.

Let’s calculate:

1 Worker hour = 30,000,000/300,000 = 100 USD (that is not his salary; it is the cost of all indirect production costs that is divided to working hours).

Cost per batch:

A. Let’s assume we had 2 tool operators that worked on this batch for 10 hours and 6 packaging workers that worked 5 hours each on this batch.

B. Total hours per batch = 2*10+6*5=50 hours

C. Indirect production costs per batch = 50 hours * 100 USD (cost per hour) = 5,000 USD

D. Let’s assume we produce 1000 units in this batch:

Indirect production cost per unit = 5000 USD / 1000 units = 5 USD per unit

So, 5 USD is what we need to add to each unit. Please notice that we picked worker hours as the unit that we distribute the costs. We assume that salaries are the largest cost in the production. If the machines cost is larger than workers cost, use tool hours instead.

*Remarks –

1. The total working hours is not the actual “working hours” that we pay the workers, but it is the sum of all the hours that the workers are actually working on the batches (We don’t take into consideration holidays, sick days, happy hours…)

2. In case there are special skills people in each phase that have very different wages then we will have a different distribution of the indirect costs (send me a mail, and I will explain).

Indirect costs of the rest of the organization

All other costs that we did not take in the last 2 sections, we will take them now. We will divide the annual costs per good unit/KG that we produce. That will be our indirect cost per unit. This value will be the same as the regular costing so instead of calculating it just take in from your financial department.

Let’s sum it all:

Let’s calculate the cost of a batch:

Direct cost (Material+packaging materials+energy+direct labor force)

+

Indirect production cost =Number of working hours X the value we calculated as indirect cost per hour.

+

Indirect costs of the rest of the organization = Number of units X constant indirect cost per product

The total cost will be the cost of producing the batch !

What to do with the result?

  1. Calculate the profit per batch: Batch Profit = Sales revenue by batch* – actual costing of production per batch.
  2. Sort the batches from very profitable to the least profitable. I can guess you will find some batches will have negative profit.
  3. Anyway, look at the batches list from the top and from the bottom. You will find batches that are very profitable, try to understand why and apply the reason to other products.
  4. Check the losing batches and try to understand what happened there. What happened to that specific batch and how you can avoid it in the future?
  5. Now try to sum all the batches per product and see which product is very profitable and which one loses money. Show it to sales and see how it will help them be more competitive in the profitable products and try less on the losing (or much less profitable) products.

*Remark: In case you have inventory left from the batch, subtract the cost of that units from the profit calculation so you will get the actual profit of the batch. If you disregard this, you will get funny results 🙂

Contribution

Contribution is the amount we actually profit from each additional unit. The contribution is not taking into consideration any indirect cost that we will pay no matter if we produce one more unit or not.

Contribution = Sales price – Direct cost

This is a very important part of costing and what to do with it, so I will write a post that will only deal with contribution.

Summery

Actual costing is one of the strongest tools we have for a production organization. The amount of information that we can get out of it is enormous. It is one of the strongest tool I use, and I was the one that introduced it to the organization and made it a working tool.

The actual costing reveals problems that the production people are already aware of, but they don’t understand the monetary impact.

This tool also has a huge impact on sales and R&D since they try to develop more complex products, but they don’t really know how much it cost to produce it.

If this is the first time you’re introducing actual costing to your organization, you will find out that some products are not producing any money.

I will really appreciate if you leave me a comment.

You can also contact me at:

Gal Merom:  theplanningmaster@gmail.com

15 comments

  1. I want to have knowledge on how to price items of bridge repairs eg. Skin repairs, beams replacement, foundation defects etc

    1. Hi Umar,
      The prices that you are looking for should be calculated like the following:

      Price of a job = Price of materials + Price of work + Price of overhead + profit

      Price of materials = The cost of the materials you need for the job including materials that you will throw away (For example if you cut a steel sheet you will have scrap that you will throw away, but you should include the whole steel sheet cost in your calculation).

      Price of work = the number of man-hours you need times the number of people you need. You need to take the whole time they work on the project including lunch, travel to the site ext.

      Price of overhead = This is a little tricky. You need to take the cost of your business, not including the direct man work and the cost of materials and divide it something like man-hours, number of projects or just a fixed cost that you put on every project. That is the cost of your manager’s salary, the office rent, taxes, and all “the rest of your expenses”.

      Profit = that is what you want to profit from every project, it can be fixed or as a percentage of the costs.

      I hope I answered your question.
      you can send me more questions to Theplanningmaster@gmail.com

  2. hi, i want to know about how we calculate actual per unit cost of product if the company starts production on half of the year (6th month) in different cases but, it has a full year cost like, salary for prodaction, wage and salary for admin, bank loan and interest, depreciation, rent, amortization, transportation and other expenses.
    We consider only costs that are incured on the last 6 months or all annual costs to calculate actual per unit cost of product?
    thank you for all.

    1. Hi Erste,
      Thank you for your question’ and sorry for the late response.
      When calculating the cost per unit we take into consideration the direct costs (raw materials, energy…) that will always be the costs we use to produce this batch.
      Then we have the indirect production costs, which will also be a cost that we did during the current month or so.
      Your examples refer to the indirect part of the calculations. In this, you need to divide the costs by production units or weight or hours.
      Of course, you should not put all the indirect costs on the production batches that you did yesterday, you need to put it on all the units you will produce during the lifetime of the cost.
      Let me explain it by example:
      Let’s say that your factory is producing 10,000 units every month.
      You took a bank loan and you pay interest of 240,000$ a year.
      Your indirect costs should be:
      Cost per unit = 240,000/(12*10,000)=2$
      You make the calculation at the beginning of production or every few months.
      Then for every batch, you multiply this value by the number of products in the batch.
      So if you made a batch of 200 units, you should add 2$ to the unit cost or 400$ to the cost per batch.
      This is not a perfect calculation since you don’t know exactly how many units you will produce each year (it is only an assumption), but it is OK.
      The indirect costs shouldn’t be a large part of your costs (unless you have a huge huge R&D and almost no production).
      The reason we don’t divide the 12-month costs by a six-month production is that we don’t want to falsely make a higher cost per unit.
      We always need to divide the same period by the same period.
      So if you have a once a year cost, then divide it by the number of units you will do in a year.
      In your case (you only work X months in the year), take the number of units you produce, divide it by X (number of months you are producing) and multiply it by 12, which will give you the number of units you might produce during the year.
      I hope I answered your question, You are welcome to ask more questions.
      Gal

      P.S.
      Can I ask you where are you from?

  3. Hi. I would like to understand better the costing process in a poultry abattoir. We slaughter live chicken and pack into different chicken portions.

    1. Hi Dimakatso,
      Although the subject is a bit disturbing, I will try to answer without using too many colorful words.
      So, costing is always the same, just like in your case.
      Look at the end product. You have x kg of material entered into each package. Since you but the whole animal by weight, you should also consider weight as the measurement for calculating the material costs.
      Then you have the time needed to “process” the meat and pack it. Take the amount of time needed for the “processing” and multiply it by the cost per hour of each worker. That will give you the direct labor costs.
      Then take all the other workers in “production” and divide their monthly salary by the monthly “production” weight. That will be the indirect production costs.
      Then take all other yearly costs that are not “production” and divide them by the annual “production” in kg. That is the overhead costs.
      Make sure you do all the calculations in cost per kg. Now add them for each “product,” and you will have the cost per kg “processed” product.

      I hope I have helped you. If not, don’t hesitate to write back so I can explain
      Gal

  4. Hi! This is Surya, I would like to know what are all the costs to be taken to arrive at actual production cost of a product

    1. Hi Surya, We want to take all the costs of the organization and divide them per product. The direct cost is related to the relevant product. The other production expenses are shared between the products that are produced and the non-production costs also are shared in a different way. you can read all about it in the following post:
      https://theplanningmaster.com/costing/actual-costing/

    1. Hi Margarito,
      The costs of cabinets are determined by the costs of material, labor, and overhead, just as I explained in the post above.
      If you want to do something more specific, please send me an email with a longer description of the problem.
      theplanningmaster@gmail.com

  5. I want to calculate the new selling price for gold plating services. Cost of gold is 60% of selling price. Cost of gold increase from 152000 to 172000. As the profit margin and other cost % are not defined. Now the company decided to set a margin at 20% now tell me how to calculate the accurate new selling price for a gold plating services.

    1. cost of gold = X
      Selling price = X /0.6
      Margins = Selling price * 20% = (X/0.6) * 0.2
      Other costs = 100% of selling cost – 60% cost of gold – 20% Margins = 20%
      Other costs = Selling price * 20% = (x/0.6) * 0.2

      That is how you calculate each element.
      I am not sure what you are looking for because your question suggests that the cost of gold is 60% of the selling cost then you can take the gold price and divide it by 60%.

      But I think that you might want to keep the “other costs” as a constant and then recalculate the selling price, so let’s do the following calculation:
      Xold = Old Price of gold (152000)
      Xnew = New price of gold (172000)

      Constant Other costs = Selling price * 20% = (Xold /0.6) * 0.2 = 50,666

      New selling price = (Xnew+Constant Other costs) * 1.2 = (172,000+50,666)*1.2 = 267,199

      So assuming your “other costs” are constant when you want to calculate the new selling price, use the following calculation:
      New price = (New price of gold + 50,666) * 1.2

      I hope that answers your question

Please leave a reply