Inventory Turnover Definition - Inventory Optimization Software - Lokad

Loading...
Blog

+1 (716) 989 6531

Home

Request Demo

[email protected]

Features

Resources

Customers

Pricing

Login

Technology

Knowledgebase

Language

More

INVENTORY TURNOVER (INVENTORY TURNS) Home » Knowledgebase » Here By Nathanael Mion, Joannes Vermorel, February 2012

Supply chain topics

The inventory turnover is the number of times the inventory must be replaced during a given period of time, typically a year. It is one of the most commonly used ratio in inventory management, as it reflects the overall efficiency of the supply chain, from supplier to customer. This ratio can be computed for any type of inventory (materials and supplies, work in progress, finished products or all combined), and it can be used for retail as well as manufacturing.

ABC analysis

Turnover formula

Fill Rate

The ratio is computed by dividing the cost of good sold (COGS) by the average aggregate inventory value (AAIV):

Inventory accuracy

Backorders Container shipments Economic order quantity Financial impact of accuracy Inventory control

Inventory turnover = COGS / AAIV

Inventory costs (carrying costs)

The Cost of Goods Sold (COGS), sometimes referred to as cost of revenue, is the annual cost for a company to deliver goods sold to customers. However, this cost includes neither the selling nor the administrative expenses. The Average aggregate inventory value (AAIV) is the value of all items held in inventory for the company, valued at cost. Companies also frequently express their inventory as days or weeks of supply. The main benefit of this approach is that it produces values that are rather intelligible and provides an immediate point of comparison with the lead time. In this case, another ratio, derived from the first, indicates how many days worth of inventory is available in the system - or how many days will it takes to sell the inventory. Days of supply = (AAIV/COGS) x 365 days = 365 / turnover When this ratio is applied to invidual products, it is frequently called the stock cover.

Inventory turnover Lead time Lead demand Min/Max Planning Minimal Order Quantities (MOQ) Multichannel Order Management Optimal service level formula Perpetual Inventory Phantom Inventory Prioritized Ordering Product life-cycle

Example: If the cost of goods sold during the year has been $1 million and the average inventory value for the year has been $100,000, then the inventory turns is 10. It takes 365/10= 36,5 days on average to cycle the whole inventory.

Reorder point Replenishment Safety stock Service level Stock-keeping unit (SKU)

FIFO assumption An underlying assumption, when computing inventory turnover, is the use of the "First-in, first-out" method (FIFO ) to value inventory. This method considers that the first unit arriving in the inventory is the first to be sold or processed. The value of the average inventory used in the ratio varies accordingly. The use of the ending balance instead of the average inventory may lead to misleading ratios (under or over estimating storage needs) and should be avoided.

Forecasting topics Backtesting Continous Ranked Probability Score Cross-entropy Data preparation Forecasting accuracy

Performance metric

Forecasting methods

Turnover is one of the most commonly used metric of supply chain efficiency.

Obfuscation Overfitting

Low inventory turnover is frequently associated with excess inventory, overstocking and the presence of dead inventory (non-moving inventory). Low turns also entails liquidity problems, with increased pressure on working capital. High inventory turnover is generally positive as it indicates goods are being sold rapidly. It may result from good inventory management, but may also hint at insufficient safety stock. Strategic sourcing decisions such as choosing close or distant suppliers have a massive impact on turnover, as the turnover is typically highly correlated to the lead time.

Pinball loss function Probabilistic forecasting Quantile regression Seasonality Time-series

Antipatterns topics

Variation between industries

Supply Chain Antipatterns

Grocery chains, who sell perishable goods, typically have very high inventory turnovers, around 100, for those goods. Products have to be sold quickly, as they expire rapidly. Write-offs caused by expired products can incur significant costs. See the discussion about Perishable food on our article about service level.

The Non-Euclidian Horror

Devil's advocate

On the other hand, manufacturing firms have much lower turnover values, between 5 and 10. As their products can be stored longer, a low inventory turnover does not necessarily point at inadequate inventory management: a car does not become obsolescent when stored for 2 months. A company must thus benchmark its inventory turnover by comparing it with its industry's standards, in order to make sense of this indicator.

Limits of turnover as a static indicator Inventory turnover is an average. It does not necessarily reflect the fluctuations of inventory and activity during a year, or over several years. For instance, in prevision of seasonal sales peaks, high inventory levels can be built up. Such pattern inflates annual inventory turnover, however it's necessary in order to avoid stock-outs during the peak.

The 100% service level The Jedi initiation

Pricing topics Bundle Pricing Competitive Pricing Cost-Plus Pricing Decoy Pricing Long-term maintenance agreement pricing Long-term pricing strategies Odd Pricing

Over longer periods, inventory turnover is most useful as a trend indicator. An increasing trend indicates that less money is required per dollar of cost of goods sold, i.e. the supply chain efficiency is improving. However, this is only true if this increase is not mitigated by an corresponding increase of stock-outs.

Penetration Pricing

How to improve inventory turnover?

Repricing software (Repricer)

The three main levers to improve turnover are:

Price Elasticity of Demand Price Skimming Styling Prices for Retail

Sourcing, by choosing new suppliers that offer shorter lead time, or by *negotiating* shorter lead time with existing suppliers. Service level, by tuning the acceptable frequency of stock-outs (zero stock-out is not a reasonable option for most industries). Forecasting, by refining the accuracy of the demand forecasts, so that safety stock can be lowered without increasing stock-outs.

Lokad's gotcha Of all the options to improve turnover, we believe that forecasting is typically a quick-win for most companies. Improving forecasts require no heavy investments, no revision of the sourcing strategy, and no extra risk when opting for more stock-outs. In particular, we have developed an inventory optimization app that delivers optimized reorder points based our forecasting technology.

VERTICALS



Ecommerce



Retail Networks

Spare Parts



Fashion

Fresh Food



Manufacturing

Contact Us | Terms of Service ©2007-2018, Lokad. All rights reserved.

Edit | History | Admin | Files | Login

Aerospace

INTEGRATIONS Brightpearl



Linnworks

Magento



QuickBooks

Shopify



SkuVault

TradeGecko



Unleashed Software

Vend



Stitch Labs

Loading...

Inventory Turnover Definition - Inventory Optimization Software - Lokad

Blog +1 (716) 989 6531 Home Request Demo [email protected] Features Resources Customers Pricing Login Technology Knowledgebase Lang...

114KB Sizes 3 Downloads 19 Views

Recommend Documents

No documents