Inventory Turnover Ratio: Lagerumschlaeufigkeit berechnen und optimieren

Inventory Turnover Ratio: Lagerumschlaeufigkeit berechnen und optimieren

Imagine a hardware retailer in Stuttgart with €150,000 sitting on shelves—screwdrivers, power tools, hinges, paint cans. Every euro tied up in inventory is a euro not generating returns. Every week a product sits unsold, its opportunity cost accumulates. The same retailer could instead stock faster-moving items, turn inventory twice as quickly, and free up €75,000 for operations or growth.

This is what inventory turnover ratio measures: how efficiently you convert inventory into sales. For German Mittelstand retailers, manufacturers, and distributors, this metric directly impacts profitability and cash flow. A seemingly small improvement—from 4 turns per year to 5 turns—can free up hundreds of thousands of euros in working capital.

What Is Inventory Turnover Ratio?

Inventory Turnover Ratio measures how many times a company sells and replaces its inventory during a period (typically one year). It answers: How efficiently are you converting raw materials and purchased goods into sales?

Formula: Inventory Turnover Ratio = COGS / Average Inventory

• COGS = Cost of Goods Sold (the cost of products you actually sold)
• Average Inventory = (Beginning Inventory + Ending Inventory) / 2

In German accounting (HGB), inventory is tracked as Vorraete (assets) and cost of sales is Herstellungskosten or Wareneinsatz.

Example 1: German Einzelhandel (Retail)

Company: Home & Hardware Cologne (Eisenwaren-Einzelhandel)

2025 Financials:

• Beginning inventory (Jan 1): €120,000
• Ending inventory (Dec 31): €135,000
• Average inventory: (€120,000 + €135,000) / 2 = €127,500
• COGS (cost of products sold): €850,000

Calculation: €850,000 / €127,500 = 6.67 times per year

This retailer turns inventory 6.67 times annually, or approximately once every 54 days (365 / 6.67 = 54.7 days). This is solid for German hardware retail, where typical turnover is 5-7x annually.

Days Inventory Outstanding (DIO): The Flip Side

While turnover ratio answers "how many times," Days Inventory Outstanding answers "how long does inventory sit." These are inverse metrics.

Formula: DIO = 365 / Inventory Turnover Ratio

For Home & Hardware Cologne:

DIO = 365 / 6.67 = 54.7 days

On average, they hold inventory for 55 days before sale. This is the "inventory age"—useful for cash flow planning.

Example 2: Manufacturing (Produktion)

Company: Kunststoff-Verarbeiter Dresden (plastic components manufacturer)

2025 Financials:

• Raw materials inventory (Jan): €50,000
• Raw materials inventory (Dec): €48,000
• Work-in-progress (WIP) inventory: €80,000 average
• Finished goods inventory (Jan): €120,000
• Finished goods inventory (Dec): €115,000
• Total average inventory: €50,000 + €80,000 + €117,500 = €247,500
• COGS: €1,450,000

Calculation: €1,450,000 / €247,500 = 5.86 times per year

DIO = 365 / 5.86 = 62.3 days average inventory on hand

This manufacturer has inventory sitting for ~62 days on average—split between raw materials (quick turnover), WIP (transformation time), and finished goods. For plastic manufacturing, 5-6x turnover is typical.

Inventory Turnover Benchmarks by Industry

Faster-moving retailers (grocery, e-commerce) target high turnover (8-12x). Capital-intensive manufacturers and furniture dealers accept lower turnover (3-4x) because the products are expensive and demand varies.

Why Inventory Turnover Matters for Your Business

1. Working Capital Management (Betriebskapitalmanagement)

Inventory ties up working capital. The formula is simple:

Working Capital Required = Average Inventory × Time to Turn (DIO)

Practical example: Your retailer has €127,500 average inventory. If you improve turnover from 6.67x to 8x (reducing DIO from 54.7 to 45.6 days), you free up:

€127,500 × (54.7 − 45.6) / 365 = €4,455 in freed-up cash per year

This doesn't sound massive for one retailer, but scale it: if the German hardware retail sector collectively improved turnover by 1 turn, it would free up billions in working capital across the industry. On an individual business basis, these improvements compound year after year.

2. Cash Flow Impact

Faster inventory turnover accelerates cash inflows. Slower turnover ties up cash.

Example with real euros:

• Slow retailer: €200,000 inventory, 4x turnover = 91 days DIO. Cash tied up for 91 days on average.
• Fast retailer: €200,000 inventory, 8x turnover = 45 days DIO. Cash tied up for 45 days on average.
• Difference: 46 days of cash flow acceleration

If that €200,000 in inventory represents €500,000 in annual sales, the fast retailer converts sales to cash 46 days earlier. This is pure cash flow advantage requiring zero additional capital investment.

3. Obsolescence and Dead Stock Risk

Products sitting on shelves for 180+ days risk obsolescence, damage, and shrinkage. In Germany, Lagerverluste (inventory losses) are tax-deductible but represent pure waste. Faster turnover reduces this risk dramatically.

4. Financing Costs

If you financed inventory with debt at 5% annual interest:

€200,000 inventory × 5% = €10,000 annual financing cost

Reducing inventory to €100,000 saves €5,000 in financing costs annually—directly improving your bottom line.

How to Calculate Current Inventory Turnover

Step 1: Find your COGS on the income statement (Gewinn- und Verlustrechnung) for the period. This is "Herstellungskosten der verkaeutfen Leistungen" in HGB format.

Step 2: Find beginning and ending inventory on your balance sheet (Bilanz). Typically listed as "Vorraete" under current assets (Umlaufvermoegen).

Step 3: Calculate average inventory: (Beginning + Ending) / 2

Step 4: Divide: COGS / Average Inventory = Turnover Ratio

Step 5 (optional): Calculate DIO: 365 / Turnover Ratio

How to Improve Inventory Turnover

Strategy 1: Demand Forecasting (Bedarfsprognose)

Many retailers and manufacturers overstock because they guess at demand. Improving forecasting accuracy reduces safety stock waste.

• Use historical sales data to predict patterns
• Account for seasonality (winter/summer in German retail, harvest seasons in food production)
• Collaborate with sales teams to understand customer demand trends
• Implement simple forecasting tools (Excel, dedicated inventory software)

Example: A clothing retailer realizes 40% of annual sales happen Sept-Dec (back-to-school + holiday). By shifting inventory purchases to align with actual demand, they reduce peak inventory from €200k to €140k—improving turnover.

Strategy 2: Just-in-Time (JIT) Inventory

Originally developed by Toyota, JIT stock arrives exactly when needed—no earlier, no excess.

Benefits: Minimal inventory holding, maximum turnover, rapid response to demand changes.

Challenges: Requires reliable suppliers, tight supply chain coordination, inflexibility to demand shocks.

German automotive manufacturers (VW, Daimler, BMW) perfected JIT, achieving inventory turnover of 20-30x annually. For most Mittelstand, full JIT isn't feasible, but JIT principles (smaller, more frequent orders) improve turnover significantly.

Strategy 3: ABC Inventory Analysis

Not all inventory is equal. 20% of products often represent 80% of sales value (Pareto principle).

Categorize inventory:

• A items: High value, fast-moving. Stock aggressively. Review weekly.
• B items: Medium value, moderate movement. Stock moderately. Review monthly.
• C items: Low value, slow-moving. Stock minimally. Review quarterly.

Example (Hardware retailer):

A items: Screws (massive assortment, €50,000 inventory, 18x turnover)

B items: Power tools (€30,000 inventory, 8x turnover)

C items: Specialty hinges (€5,000 inventory, 2x turnover)

By focusing inventory investment on A items (where the money is), you improve overall turnover. C items can be drop-shipped or ordered on demand.

Strategy 4: Pricing and Promotions

Slow-moving inventory needs velocity. Strategic discounting accelerates turnover.

Example: Furniture retailer has €100,000 in slow-moving inventory (2x annual turnover = 182 days DIO). A 15% discount clearance sale converts €50,000 of that inventory in 30 days instead of 182. The margin hit is offset by freed-up capital and reduced carrying costs.

Strategy 5: Supply Chain Optimization

Longer lead times force larger safety stocks. Shorter lead times reduce inventory needs.

• Work with suppliers to reduce minimum order quantities
• Negotiate shorter lead times (shorter production or shipping times)
• Use multiple suppliers to create competition and flexibility
• For international suppliers: Use air freight for fast-moving items, sea freight for slow-movers

A German manufacturing company importing components from Asia might reduce DIO by 10-15 days simply by switching from quarterly sea freight orders to monthly air freight orders—worth thousands in freed-up capital.

Inventory Turnover Case Study: Real Business

Company: Mueller Elektro (industrial electrical supplies distributor in Munich)

Situation (Year 1):

• Annual COGS: €2,400,000
• Average inventory: €500,000
• Turnover: 4.8x
• DIO: 76 days
• Working capital tied up in inventory: €500,000

Problem: Cash flow is tight. They're financing inventory with a €500,000 bank line at 4.5%, costing €22,500 annually.

Intervention: They implement ABC analysis + demand forecasting

• A items (fast cable, connectors): Increase stock, reduce stockouts
• B items (standard transformers): Reduce by 20%, implement 2x monthly orders instead of quarterly
• C items (specialty products): Switch to drop-ship, eliminate €30,000 inventory

Results (Year 2):

• Annual COGS: €2,500,000 (slight growth)
• Average inventory: €420,000 (reduction from €500,000)
• Turnover: 5.95x (improvement from 4.8x)
• DIO: 61 days (improvement from 76)
• Working capital freed up: €80,000
• Financing cost saved: €3,600 annually
• Stockout incidents: Down 40% (A items over-stocked, C items eliminated)

Long-term impact: With €80,000 freed-up capital, they can either reduce debt or invest in growth. The €3,600 annual savings funds the tool cost for better inventory management. Over 5 years, this improvement compounds.

Seasonal Inventory Management

German retail experiences seasonal demand variations. Your turnover ratio should account for this.

Example (Garden Center in Berlin):

• January inventory: €50,000 (winter lows)
• April inventory: €120,000 (spring peak)
• July inventory: €100,000 (summer sales)
• October inventory: €200,000 (fall/winter preparation)
• December inventory: €180,000 (holiday shopping)

Average inventory: €130,000

Annual COGS: €600,000

Turnover: 4.6x

But the monthly picture is different—turnover is 12x in May-June, and 2x in January. Understanding this seasonality helps you plan inventory purchases and avoid tying up excessive capital in off-season months.

Connection to Working Capital and Cash Conversion Cycle

Inventory turnover is part of the Cash Conversion Cycle (CCC)—the number of days between paying for inventory and collecting cash from customers.

Formula: CCC = DIO + DSO − DPO

• DIO (Days Inventory Outstanding) = inventory age
• DSO (Days Sales Outstanding) = time to collect from customers
• DPO (Days Payable Outstanding) = time before paying suppliers

Example (Distributor):

DIO: 60 days (inventory sits 60 days before sale)

DSO: 45 days (customers pay in 45 days)

DPO: 40 days (you pay suppliers in 40 days)

CCC = 60 + 45 − 40 = 65 days

You need €65 days worth of working capital to fund operations. Reducing DIO by 10 days (improving inventory turnover) cuts CCC to 55 days—a 16% improvement in working capital efficiency.

Common Inventory Mistakes to Avoid

• Over-ordering: Buying in bulk for discounts creates excess inventory and poor turnover. Calculate true costs.
• Ignoring slow-movers: That €20,000 of dead stock costs you €900/year in financing. Liquidate it.
• Lack of forecast: Flying blind creates boom-bust cycles in inventory.
• High shrinkage: Theft, damage, and waste silently destroy margins. Implement controls.
• Seasonal blindness: Carrying peak-season inventory year-round kills turnover.
• Single-supplier dependency: Forces you to accept large MOQs and long lead times

Key Takeaways

• Inventory Turnover = COGS / Average Inventory; higher is better
• Days Inventory Outstanding (DIO) = 365 / Turnover; represents inventory age in days
• Benchmarks vary by industry: retailers 4-12x, manufacturers 3-7x, e-commerce 6-12x
• Improving turnover by 1x frees up millions in working capital across whole industries
• ABC analysis focuses inventory investment on high-velocity items
• JIT, demand forecasting, and supply chain optimization improve turnover
• Seasonal variations require dynamic inventory planning