Too much inventory cost? Track your stock with these 7 metrics
“Knowing what you’ve got, knowing what you need, knowing what you don’t – that’s inventory control.”
The quote from the movie “Revolutionary Road” aptly describes the concept of inventory management.
1. Monthly Inventory Value
Inventory cost is deﬁned as assets that are intended for sale, or are in the process of being produced for sale, or are to be used in producing goods. Every factory must track their inventory values on a monthly basis.
The following equation expresses how a company’s inventory is determined. All the calculations are focused mainly on store room inventory.
Ending Inventory = Beginning Inventory + Purchases – Sold or Issued
There are three inventory-costing methods that are widely used by both public and private companies.
- FIFO (First in, First out): The ﬁrst unit brought in the inventory is the ﬁrst to be sold or issued.
- LIFO (Last in, First out): The last unit brought in the inventory is the ﬁrst to be sold or issued.
- Average cost: It takes the weighted average of all units available for sale during the accounting period and then uses that average cost to determine the value of goods sold and ending inventory.
If inﬂation was nonexistent and prices were same, then all three of the inventory valuation methods would produce the exact same results. Most garment factories that buy fabric on order basis may use average cost method as the prices do not vary much in a small span of time. Factories that buy fabrics for stock, need to decide on the method based on their accounting principles.
2. Inventory Turnover
The inventory turnover ratio is a common measure of the ﬁrm’s operational efﬁciency in the management of its assets. Inventory turnover is best thought of as the number of times that an inventory “turns over” or cycles through the warehouse in a year. Inventory turnover of 12 means the average inventory moves through the warehouse once per month; inventory turnover of 6 times means the average inventory circulates through the facility every two months.
Since inventories represent a sizable investment of company funds, and larger inventories mean higher carrying costs (space, insurance, taxes, capital costs, etc.), a common inventory management goal focuses on improving inventory turnover. Low inventory turnover means that you are carrying too much inventory, thereby unnecessarily restricting your company’s access to cash that it could be using to invest in proﬁt-generating activities.
Inventory turnover = (Cost of goods sold)/ (Average inventory)
- COGS (Cost Of Goods Sold): This is the cost of the amount of inventory sold and can be deduced from software or book records. This can also be deduced from the following formula.
- Cost of goods sold = Beginning inventory + Inventory purchases – End inventory
- Average Inventory: The average inventory is calculated on a monthly basis. Company can prefer to have a weekly or daily average for more accurate results. Both COGS and average inventory calculations should use same inventory valuation method to get accurate results LIFO, FIFO or weighted average.
3. Obsolete Inventory or Dead Stock
This means, materials that have not been used for a signiﬁcant amount of time and cannot be sold anymore. This material has either gone out of fashion or was bought more than what was required or is damaged and cannot be used. In most cases, this inventory must be liquidated at a reduced price, or sold as scrap.
The store room should be monitored at regular intervals to identify obsolete inventory and take proactive actions. If possible, offer it to the buyers at a discounted rate or else dispose it of instead of spending time and money in further storing it. This metric is used to highlight inventory management practices and effectiveness of the forecasting team. Regular monitoring may be able to reduce the losses occurring due to obsolescence.
The best way to identify obsolete inventory is by checking the last used tag. If the item has not been used for a long time (say a year or 6 months), the items may be considered as obsolete, however the decision to determine an inventory item as obsolete should be taken in consultation with merchandising, production, purchasing and stores manager.
Obsolete inventory % = [(Value of obsolete inventory) / (Value of total inventory)] X 100
Each organization has to devise its own methods of determining obsolescence and the percentage obsolete inventory that is acceptable.
4. Inventory Accuracy
Inventory accuracy is a measure of how closely ofﬁcial inventory records match the physical inventory. The units of measurement are either dollar based or count based. These two bases have different purposes and may give widely differing results.
Accountants and ﬁnancial auditors prefer dollar-based measurements of accuracy. Their concern is to ensure that the inventory value stated on books and tax returns is accurate at an aggregate level. Discrepancies on individual items hold little concern provided that positive and negative discrepancies are roughly equal and the total value is the same.
Operations and material management people have a stronger interest in the accuracy of individual items as shortage can result in major production breaks or emergency buying and an excess can result in obsolete inventory.
Accuracy = [(Total accurate records) / (Total inventory records checked)] x 100
There can be many reasons for inaccuracy such as improper data entry, incorrect unit used for calculation, poorly trained employees, stealing and supplier errors.
Physical inventory count should be done every few months and in a periodic cycle count to ensure that correct inventory records are maintained. Any value less than 95% should be a cause of concern. Accuracy may also be calculated in terms of actual quantity or value of the stock items.
5. Average Days of Inventory in Hand
This KPI measures the average number of days a product or line of products spend in inventory. The time period for which we hold the inventory before selling or producing the product is called average days of inventory on hand. It is also called inventory conversion period. If average days of inventory in hand are small, the organization requires less working capital to invest in inventory. Saved working capital can be utilized for other purposes.
Average days of inventory in hand = 365 / (Inventory turnover ratio)
For garment industry the average days of inventory on hand from fabric in-house to PCD (Planned Cut Date) should be an important number to chase. For manufacturers who buy stock fabrics also need to monitor this number to ensure a healthy cash ﬂow.
The article “Six Sigma Initiative at Brandix Casualwear – Reduce Fabric Inventory Days to Realize Savings” (published in March 2009 issue of StitchWorld) stated that the company achieved a reduction of 7% of the monthly average value of fabric stock holding time from fabric in-house to PCD each month. They managed to render cash ﬂow savings and savings on the interest cost as well. Forward thinking companies are already trying to manage these KPIs.
6. Inventory Carrying Cost
This is the cost a company incurs over a certain period of time, to hold and store its inventory. There is a daily cost of holding inventory. The best way to reduce these costs is to ensure that inventory is sold as soon as it becomes obsolete. A number of companies simply do not let go off the dead stock. They allow the original purchase price of the inventory to compromise their decision to liquidate it. They keep trying to generate proﬁt off the original purchase price.
The likelihood that a company will be able to recoup the full value of the dead stock declines every day as they choose not to liquidate it and further accumulate carrying costs. There is a window of opportunity here. The moment stock becomes slow moving or outdated, it needs to be sold immediately. The faster the company sells it, the better its chances are of recouping the full value.
The cost of carrying inventory is expressed as a percentage of each dollar carried on the average in inventory throughout a full year.
Cost of carrying inventory = Total annual cost / Average inventory value
Total annual cost comprises of the following entities:
- Warehouse space: The actual monthly rental or monthly rental equivalent of the space as per local real estate standards. Insurance and taxes for warehouse space.
- Taxes: Taxes paid on inventory as per local laws as mentioned in company accounts records.
- Obsolescence and shrinkage: Inventory shrinkage refers to the amount of inventory that exists in accounts records but no longer exists in actual records. This can happen due to theft, vendor fraud or administrative errors. The inventory that was not found (inventory shrinkage), damaged and obsolete inventory needs to be written off from inventory records at the year end. Writing off inventory means removing some or all of the cost of an inventory items from the accounting records. The amount to be written off should be the difference between the book value (cost) of the inventory and the amount of cash that can be obtained by disposing of this inventory.
- Material Handling: This is the cost of employees in the warehouse/store and equipment used to receive, put away, move, check and count inventory.
- Cost of money invested: This is prime rate (interest rate on borrowed money) multiplied by value of average inventory.
7. (Out-Of-Stock) / Part & Raw Material Usage
For any business having too many occurrences of out-of-stock incidences is damaging to business.
Deciding on inventory levels is a delicate balance between not having too much and also avoiding stock out situations. One simple stock out situation can have huge cascading effect on costs and these should be tracked to control inventory levels. In situations where a stock out situation occurs, the company always prefers to expedite the raw material than to lose an order from a customer.
Loss of an order is deﬁnitely a loss of trust of the customer and in extreme cases may result in loss of a customer as well. The delay due to stock out and further expediting the raw material and processes may result in various other costs.
- The raw material vendor may charge a rush fee if they have to expedite a raw material delivery.
- There will be increased freight cost to expedite raw material in the store.
- The planned production processes will be disrupted resulting in loss of efﬁciency.
- The delay may further result in air freight to deliver the goods to the customer
Apart from the above there is loss of trust and reputation of the company.
One of the biggest reasons why companies are unaware of these costs is because they are very cumbersome and a lot of discipline is required to properly track them back to their source.
However, even a basic count of number of times the production process is disrupted due to some out of-stock incidences with responsible department and basic costs incurred, will give a decent picture of the situation.
The measurement factors are pillars of support for good management of the factory. In order to use these performance measurement tools in the correct light one should take help from trained IE professionals or consultants.