Month: November 2020

How is Holding Cost Calculated?

Posted on by Talbot Smith
Holding Cost =
+ Cost of Money
+ Property Taxes
+ Insurance
+ Obsolescence
+ Shrinkage
+ Physical Storage

It’s universally agreed that there is cost to holding inventory, but very few companies have a good understanding of what that cost really is.  Optimizing inventory implies a trade off between the cost of carrying inventory with some benefit, such as being able to meet customer expectations, or a reduction in operating costs.  However, it’s often easier to articulate the benefits vs. the cost of the inventory, leading companies to carry more than they should.  Similarly, I have seen many business cases for inventory reduction that were fundamentally flawed in the way they addressed inventory related costs.

The goal of this article then is to demystify the concept of holding costs and get you asking the right questions to be able to use this concept in business decisions

Holding costs are usually expressed as a percentage of the inventory value.  This can be helpful as most inventory decisions are on a margin basis, i.e., adding or reducing a certain amount of inventory.  I’m not sure where this practice originated, but it may come from the simple fact that many components of the holding cost are also typically expressed as percentages.

Holding cost should include all of the costs related to financing, storing, and disposing of inventory.  Typically it consists of the following components:

  • The cost of the money that is tied up in inventory
  • Where applicable, the cost of property taxes paid on inventory
  • The cost of insuring inventory or accepting the risk of loss
  • The cost of obsolescence, including both the cost of the inventory itself and the cost of disposal
  • The cost of physically storing the inventory

Each of these is discussed in turn below.  I leave the physical storage costs for last because these are the most problematic.

Cost of Money

The cost of money addresses the cash that is tied up in inventories. Inventory is a key component of working capital and consumes cash that could be used elsewhere: to pay down debt, to invest in a new business , to finance new capital equipment, to dividend to shareholders, etc.  As such, the cost of money should be viewed as an opportunity cost.  What else could I do with this cash if it wasn’t tied up in inventory?

Some companies use the company’s marginal, short term borrowing rate as the cost of money.  Today (in late 2020), that number is likely to be only a few percentage points.  I personally believe that this approach significantly understates the cost as it implies that the company has nothing better to do with extra cash than pay down short term debt.

Cost of Money

A better approach is to use what is know as the Weighted Average Cost of Capital, or WACC.  The WACC represents the average return expected across all of a company’s sources of cash, weighted by the amount of cash from each source.  It incorporates not only the cost of short and long term borrowing, but also the return expected by shareholders.  In my experience, even with low borrowing costs it is common for WACC to be in the 9-12% range depending largely on a company’s size and ownership structure. 

Many companies publish their WACC for use in internal business cases, either as the discount rate for Net Present Value (NPV) calculations or as the expected minimum return or ‘hurdle rate’ for investments.  If your company does not publish a rate you can usually get it from Finance and particularly the Treasury department.

WACC (Weighted Average Cost of Capital)
Property Taxes
Property Taxes

The second element of holding cost is property tax. Some tax jurisdiction will assess property tax on the value of inventory.  Of course if you operate in multiple locations you may pay property tax in some and not others, and when you do pay the rates will almost certainly be different.  For simplicity, I recommend computing an average rate and using that.  Your company Tax team within the Finance organization can help you understand total annual inventory related taxes and you can divide this by the average inventory balance to get a percentage.

Insurance

Insurance is the next component.   Most companies will carry insurance against the risk of catastrophic loss.  The trick here is to identify all of the relevant insurance costs (don’t forget insurance for goods in transit) and separate out the portion that relates to the inventory from that which relates to liability or replacement cost of buildings.  Treasury is usually responsible for managing the insurance policies or you may want to contact your corporate Risk group.

Taxes and insurance can be a bit of work and it’s common to add 1% to cover both of these.  Not that that number has an particular scientific basis or validity.  If you want to be precise, the actual numbers should be easily available.

Insurance
Obsolescence
Obsolescence

Inevitably, at some point you will make or buy too much of something and it will sit in inventory (and sit, and sit).  When it’s clear that there is no more demand for a product or material, accounting principles require that a reserve account be setup to reduce the value of the inventory to zero.  What’s important in determining obsolescence cost is not the value in the reserve account, but the annual amount that is added to the account.  For example, a company may have $ 100 million in inventory and an inventory reserve of $15 million.  Each year the company charges (as an expense) $5 million to the reserve account and removes a similar amount as inventory is scrapped.  The number we want is the average amount added to the reserve annually.  Take this as a percentage of total inventory (in this example, $5m / $100m = 5%) as the holding cost due to obsolescence

Shrinkage

Another basic fact of inventory is that things disappear.  They get lost, or damaged, or worse pilfered.  Regardless of the reason, the result is the same: the lost inventory must be written off as an expense and removed from inventory.  To compute the shrinkage component of holding cost, take the annual cost of shrinkage and divide by the average inventory balance to get a percentage.

Shrinkage
Physical Storage
Physical Storage

At last we come to the physical storage costs, and this is where things get interesting.  Physical storage, and how you should think about it, is highly situational. Particularly if you are working on a business case for inventory reduction.  Let’s look at some possible situations as examples:

  1. Your inventory is held in a shared warehouse where you pay a fixed fee per pallet per month for storage
  2. Your inventory is held in a warehouse that you own or lease with 80% of the available pallet positions occupied
  3. Your inventory is held primarily in a a warehouse that you own or lease, but the warehouse is completely full and 1,000 pallets are stored at a second warehouse where you lease space

These situations are not mutually exclusive.  Indeed I once worked at a company where all three situations existed at the same time but for different warehouses.

Situation #1 is the simplest in the context of holding cost as there is a very clear cost that is tied directly to the amount of inventory on hand.  In this case, simply take the annual cost per pallet and divide by the average value of a pallet to get a percentage.

Situation #2 is a bit more tricky.  For longer term, strategic decisions about inventory it would be appropriate to take the annual facility costs (not including labor) and divide by the average inventory value to get the holding cost percentage.  But here’s the catch: if you reduce inventory you won’t save any of this cost.  The warehouse is still there, it’s just less full.  The reduction in inventory hasn’t saved you a penny on the physical storage costs.  This is no good if you are trying to make a business case on inventory reduction!  From a business case perspective, you may still be able to make a case on cost avoidance.  For example, the inventory reduction prevents you from having to go out and lease more space next year as volumes increase (if that is actually true).  If there is another use for the space or the potential to lease less space going forward, then you can also apply an opportunity cost.  But if it’s just a simple case of inventory reduction your business case may be out of luck here.

Situation #3 is better, because the cost reduction opportunity is clear.  If you can reduce inventory by 1,000 pallets, you can eliminate the cost associated with the second warehouse.  And if this is strictly an overflow warehouse, you can eliminate the labor at that site and the cost of trucking material back and forth at the same time.  As with Situation #2, if you are looking to calculate a holding cost for strategic decisions (or, say to use in inventory optimization decisions) you can roll up all the facility costs and divide by the average inventory value to get a percentage cost for physical storage.  If you’re trying to make a business case for inventory reduction, you can build that case on the elimination (or downsizing) of the secondary warehouse as these are very real costs that can be eliminated if inventories can be reduced to the point that they fit in the primary warehouse.

As a final thought in this section, there is no physical storage cost for inventory in-transit.  Business cases that deal with reducing inventory by reducing transit time would not have a physical storage component to holding cost for in-transit inventory — though it would still be appropriate to apply physical storage costs to any resulting reduction in warehouse inventory due to the reduced lead times.

Financial vs. Operational Inventory

Posted on by Talbot Smith
Operational Inventory ≠ Financial Inventory

When measuring inventory levels it’s important to make a distinction between two different views: Financial, or what appears on financial statements, and Operational, what your planning team uses to make decisions.  Managers should understand the differences and be able to translate their operational decisions and actions to the balance sheet.

Operational inventory is simply what is visible in your company’s planning system (sometimes this is called Gross Inventory).  Generally speaking, this will be the quantity physically on hand.  There are of course exceptions to this as detailed below.  Operational inventory is valued at cost and so the total value of operational inventory is simply (quantity on hand) x cost.  Operational Inventory is important because it is what is used as the input to planning production and purchases.

Operational Inventory Value = Sum(Quantity on Hand x Cost)

What cost to use?  Every company has an established way of costing material in inventory, although one company may use different methods for different types of materials.  There are basically two approaches in common use: standard costing and average costing.  Standard costs are typically determined once a year determined during the annual budget process.  The standard cost represents what the company expects to pay for each unit of inventory.  ‘Expects’ being the operative word.  This can be very simple (e.g., the supplier contract price for the next year) or the result of complex calculations (e.g., for a manufactured item).  The important thing is that it’s a fixed number that typically only changes once per year.

Average costing seeks to compute the average cost for the items in inventory and is frequently used for spare parts and materials that are not end products or components of end products (otherwise known as indirect materials).  The average most often assumes FIFO, or First In, First Out, inventory movement, though other assumptions are possible (LIFO or Last In First Out, etc.).  Under this approach, if you have 97 units in inventory and a FIFO assumption of how inventory moves, the cost would be the average cost of the last 97 units to arrive.

Once you understand how your company handles costs, you should also get clarity of exactly what is included in Quantity ‘On Hand’.  If you work in a small company with only one location, it’s pretty safe to assume that ‘On Hand’ only includes the inventory that is physically present.  Larger companies, particularly those with more sophisticated ERP systems such as SAP, may also track inventory that is:

  • In transit between company locations
  • In the hands of suppliers (e.g., when a production step is outsourced)
  • Inbound from suppliers (less common as it requires data integration with the supplier)

To make thing even more complicated, what is considered On Hand may vary by location, particularly if different systems are used.  Be sure to understand what the rules are for each location in your company.

Financial Inventory =
+ Operational Inventory
+ Internal In-Transit
+ In the Hands of Suppliers
+ In-Transit from Suppliers
+ In-Transit to Customers
± Cost Variances
– Reserves
– Intercompany Profit

Believe it or not, valuing Operational Inventory is the easy part.  Financial Inventory starts with Operational Inventory and applies a number of adjusting entries to get to the amount that the company shows on its balance sheet.  Let’s look at each of these adjustments:

Internal In-Transit

If quantities in-transit between company locations (e.g., from a manufacturing site to a distribution center) are not visible in the company systems, then an accounting adjustment is needed to capture the value of this inventory.  There are multiple ways to do this, such as looking at quantities shipped and not yet received at month end.

In the Hands of Suppliers

Some companies will send inventory to suppliers to perform a process step or other activity.  Some examples are sending material to a supplier for sterilization (medical devices) or sending inventory to a co-packer to build store displays (consumer goods).  Regardless of the reason, if this inventory is not visible in the company systems then it needs to be added back via an accounting entry.  Typically this will cover the time from shipment to the supplier to receipt of the resulting item

In-Transit from Suppliers

It’s common for a company to take ownership of inventory before it is physically received.  If inventory is purchased from suppliers at any INCOTERM that does not include delivery (i.e., other than DAP or DDP), and transportation is anything less than instantaneous, it will be necessary to add an amount for in-transit inventory.  For example, let’s say your company purchases material from a supplier in China and the goods are shipped by sea to your location in California.  If the terms of the purchase are Ex-Works, then you take ownership as soon as the goods leave the suppliers location.  However, they may not be received and visible in your inventory for a month or more.  One way to value this is to look at inbound shipments for which you have received an invoice from the supplier or other indication of shipment such as an ASN (Advanced Ship Notice) and subtract what has been physically received.  There are other approaches and you should ask your Finance team how it’s done at your company.

In-Transit to Customers

Similarly, if you ship to customers using an INCOTERM that causes title to transfer somewhere after the goods leave your location (e.g., a delivered term) then it’s necessary to account for the inventory that is no longer on your system (having been shipped), but which you still technically own.

Cost Variances

Good news! If your company uses average costing, you can skip this section.  For companies that use standard costing however, it’s necessary to adjust the value of inventory by any variances from the standard.  This is perhaps best explained through an example.  Last year you set the standard cost for an item at $1.00.  However, your purchasing team was later able to negotiate a discounted price of $0.98.  You have 100 units in inventory currently.  If you value that inventory at the standard cost it is worth $100.  But you only paid $98 to obtain it.  To correct for this, an accounting entry is added to reduce the value of the inventory by the amount of this favorable variance.  So the value of the inventory is then 100 units x $1.00 standard cost – (100 units x $0.02 favorable variance) = $98. Most companies will capitalize both purchasing cost variances and production cost variances into a special inventory account to address this.  These variances may or may not be tied to the specific items that generated them.  Even if they are, the variance account may not be reduced at the same time that the inventory is consumed or shipped as many companies will transfer these variances into cost of goods sold (COGS) on a fixed schedule (e.g., variances go to the balance sheet for three months and are then amortized or transferred to costs).  Note that variances can be negative (favorable) as in the example above or positive (unfavorable) resulting in an increase in inventory.

Reserves

Accounting rules require a company to value inventory at the “lesser of cost or market”.  Consequently, if the Operational Inventory value exceeds what the inventory could reasonably be sold for, a reserve must be taken.  From an accounting perspective, the difference between book (Operational) value and fair market prices is written off as a cost and the value kept in a reserve account that acts as an offset, or negative, to inventory value.  Reserves may be taken for a variety of reasons:

  • Product cost exceeds selling price (i.e., a money losing product)
  • Obsolescence.  There is no longer a market or need for the item
  • Quality.  Items that failed quality inspection and are expected to be scrapped or that are otherwise unfit for use

The methodology for computing reserves can vary from simple to complex.  Best practice is to involve Planning in the identification and calculation of reserves, particularly for obsolescence.

Reserves may or may not be tied to the specific item(s) that caused them to be created.  Reserves are reduced by the value of inventory scrapped.

Intercompany Profit

If you work for a company that has more than one legal entity, then it’s necessary to adjust inventory to remove any internal profits.  Again, this is probably best explained via an example.  Your manufacturing site in the US produces a product at a cost of $100 per unit.  The US company then sells the product to your German subsidiary for $110.  The German company incurs $5 in freight cost and so the inventory in Germany reflects a cost of $115 per unit.  However, the actual cost to the company of the German inventory is only $105 (the original $100 manufacturing cost plus $5 in freight).  If we are going to aggregate total company inventory, we need to adjust the value of the German inventory to remove the $10 ($110 selling price – $100 cost) internal profit created by the sale between the two legal entities.  Companies that have this situation will typically capture the intercompany profit in an account that is an offset (negative) to inventory until the goods are sold to a customer outside the company.