Inventory Turns, Days of Supply, and Performance Metrics

Inventory Performance Metrics: Inventory Turns, Days of Supply & Key Performance Indicators for CPIM

Introduction to Inventory Performance Metrics

Inventory performance metrics are fundamental tools used by supply chain and operations professionals to evaluate how effectively an organization manages its inventory. For CPIM candidates, mastering these metrics is not just about passing the exam—it is about understanding the language of inventory management that drives real-world decision-making. These metrics help organizations balance the competing goals of high customer service levels and low inventory carrying costs.

Why Are Inventory Performance Metrics Important?

Inventory often represents one of the largest assets on a company's balance sheet. Poorly managed inventory leads to:

• Excess carrying costs – warehousing, insurance, obsolescence, and opportunity costs
• Stockouts and lost sales – eroding customer satisfaction and revenue
• Cash flow problems – capital tied up in slow-moving or dead stock
• Operational inefficiencies – difficulty in planning production and procurement

Performance metrics provide visibility into how well inventory is being managed. They allow managers to set targets, benchmark against industry standards, identify trends, and take corrective actions. Without these metrics, organizations are essentially flying blind.

From a CPIM exam perspective, inventory performance metrics appear across multiple modules, particularly in the areas of inventory planning, master scheduling, and execution and control. Questions may be conceptual, formula-based, or scenario-driven.

What Are the Key Inventory Performance Metrics?

The three most critical metrics you must master for the CPIM exam are:

1. Inventory Turns (Inventory Turnover)
2. Days of Supply (DOS)
3. Other Performance Metrics (Fill Rate, Service Level, Carrying Cost %, Accuracy Metrics)

Let's explore each in detail.

---

1. INVENTORY TURNS (INVENTORY TURNOVER)

Definition: Inventory turns measure how many times inventory is sold and replaced over a given period (typically one year). It indicates the velocity of inventory movement through the supply chain.

Formula:

Inventory Turns = Cost of Goods Sold (COGS) / Average Inventory Value

Alternatively:
Inventory Turns = Annual Usage (at cost) / Average Inventory (at cost)

Example:
If a company has a COGS of $10,000,000 and an average inventory value of $2,000,000:

Inventory Turns = $10,000,000 / $2,000,000 = 5 turns per year

Interpretation:
• A higher number of turns generally indicates more efficient inventory management—inventory is moving quickly.
• A lower number of turns may suggest overstocking, obsolete inventory, or weak sales.
• However, extremely high turns could indicate insufficient inventory, potentially leading to stockouts.

Key Points for CPIM:
• Always use cost values (not retail/selling prices) for both numerator and denominator to ensure consistency.
• Average inventory is typically calculated as: (Beginning Inventory + Ending Inventory) / 2, or as a rolling average of periodic inventory values.
• Inventory turns vary significantly by industry. Grocery retailers may have 20+ turns, while aerospace companies may have 2-4 turns.
• Turns can be calculated for total inventory or for specific categories (raw materials, WIP, finished goods).

---

2. DAYS OF SUPPLY (DOS)

Definition: Days of Supply measures the number of days the current inventory will last based on the average daily usage or demand rate. It is essentially the inverse of inventory turns, expressed in days.

Formulas:

Days of Supply = Average Inventory Value / (Annual COGS / 365)

Or equivalently:
Days of Supply = 365 / Inventory Turns

Or in unit terms:
Days of Supply = On-Hand Inventory (units) / Average Daily Demand (units)

Example:
Using our previous example where Inventory Turns = 5:

Days of Supply = 365 / 5 = 73 days

This means the company holds approximately 73 days' worth of inventory at any given time.

Interpretation:
• A lower DOS indicates lean inventory management and faster inventory movement.
• A higher DOS suggests the company is holding more inventory relative to demand, which increases carrying costs.
• DOS is particularly useful for comparing inventory levels across products, locations, or time periods because it normalizes for differences in demand rates.

Key Points for CPIM:
• Days of Supply and Inventory Turns are inversely related. If turns go up, DOS goes down, and vice versa.
• The number of working days used (365, 360, 250, or 252) may vary depending on the context. The CPIM exam will typically specify. If 365 is used, it accounts for calendar days. If 250 or 252 is used, it reflects working days only.
• DOS is extremely practical for planners because it communicates inventory levels in a timeframe that is easy to understand and act upon.

The Relationship Between Turns and DOS:

Inventory Turns × Days of Supply = Number of Days in the Period

For example: 5 turns × 73 days = 365 days. This reciprocal relationship is a favorite testing point on the CPIM exam.

---

3. OTHER KEY PERFORMANCE METRICS

a) Fill Rate

Fill Rate = (Number of Units Shipped / Number of Units Ordered) × 100%

• Measures the percentage of customer demand that is met immediately from stock.
• Can be measured at the line level, order level, or unit level.
• Line fill rate: percentage of order lines filled completely.
• Order fill rate: percentage of orders filled completely (all lines). This is always ≤ line fill rate.
• A 95% line fill rate does NOT mean a 95% order fill rate. If an order has 10 lines and each has a 95% probability of being filled, the order fill rate is approximately 0.95^10 = 59.9%.

b) Customer Service Level

• Often used interchangeably with fill rate, but can also refer to the probability of not stocking out during a replenishment cycle.
• Expressed as a percentage (e.g., 98% service level).
• Higher service levels require disproportionately more safety stock. Moving from 95% to 99% service level requires significantly more inventory than moving from 90% to 95%.

c) Inventory Carrying Cost (as a percentage)

Carrying Cost % = Total Annual Carrying Costs / Average Inventory Value × 100%

• Components include: capital costs (opportunity cost of money), storage costs, risk costs (obsolescence, damage, shrinkage, insurance), and taxes.
• Typical carrying costs range from 20% to 35% of average inventory value per year.
• This metric is critical for EOQ calculations and trade-off analysis.

d) Inventory Record Accuracy (IRA)

IRA = (Number of Accurate Records / Total Number of Records Counted) × 100%

• A tolerance (e.g., ±2%) may be applied when determining if a record is accurate.
• High IRA (typically 95%+ for most items, 99%+ for A items) is essential for MRP system integrity.
• Cycle counting is the primary method for maintaining and improving IRA.

e) Gross Margin Return on Inventory Investment (GMROII)

GMROII = Gross Margin / Average Inventory Cost

• Measures the profitability of inventory investment.
• Combines margin performance with inventory turn performance.

f) Dead Stock / Slow-Moving Inventory Percentage

• Percentage of inventory with no movement over a defined period (e.g., 12 months).
• High percentages indicate poor inventory management or demand forecasting issues.

---

How Do These Metrics Work Together?

These metrics do not exist in isolation. Effective inventory management requires balancing multiple metrics simultaneously:

• Increasing inventory turns (reducing DOS) typically reduces carrying costs but may increase the risk of stockouts, potentially lowering fill rates.
• Improving fill rates often requires more safety stock, which decreases turns and increases DOS and carrying costs.
• Improving inventory accuracy enables better planning, which can simultaneously improve turns AND fill rates by reducing the need for excess safety stock.

The goal is to find the optimal balance where total cost is minimized while customer service targets are met. This is a central theme in CPIM.

---

Exam Tips: Answering Questions on Inventory Turns, Days of Supply, and Performance Metrics

Tip 1: Know the Formulas Cold
• Inventory Turns = COGS / Average Inventory
• Days of Supply = 365 / Inventory Turns (or Average Inventory / Daily Usage)
• Turns × DOS = Period Length (365 days typically)
• Fill Rate = Units Shipped / Units Ordered × 100%
Practice these until they are automatic. Many exam questions are straightforward calculations.

Tip 2: Watch for Consistency in Units
• Ensure both numerator and denominator are in the same terms (cost vs. cost, units vs. units).
• If COGS is given at cost, average inventory must also be at cost.
• Never mix selling price with cost values—this is a common trap.

Tip 3: Understand the Inverse Relationship
• If a question gives you inventory turns and asks for days of supply (or vice versa), remember they are inversely related.
• If turns increase, DOS decreases. If turns = 12, DOS = 365/12 ≈ 30.4 days.
• Questions may test this conceptually: "If a company wants to reduce days of supply from 60 to 30, what happens to inventory turns?" Answer: Turns double from about 6 to about 12.

Tip 4: Pay Attention to the Time Period
• If the question specifies annual figures, use 365 (or 360 or 252 if specified).
• If monthly data is given, adjust accordingly. Monthly turns × 12 = annual turns.
• Some questions may provide quarterly data—multiply turns by 4 for annual equivalents.

Tip 5: Distinguish Between Line Fill Rate and Order Fill Rate
• This is a frequently tested concept. Order fill rate is always equal to or lower than line fill rate.
• If given individual line fill rates and asked for order fill rate, multiply the probabilities: (Line Fill Rate)^(Number of Lines).
• Example: 3 lines at 90% each → Order fill rate = 0.9 × 0.9 × 0.9 = 72.9%.

Tip 6: Remember That Higher Is Not Always Better
• Very high inventory turns could signal understocking and poor service levels.
• Very high service levels (e.g., 99.9%) come at exponentially increasing inventory costs.
• The exam may present scenarios asking you to evaluate trade-offs—think about the total cost perspective.

Tip 7: Connect Metrics to ABC Classification
• A items (high value, high volume) should be monitored more closely and typically have higher turn targets.
• C items (low value, low volume) may have lower turns but require less management attention.
• IRA targets are typically highest for A items.

Tip 8: Know What Drives Improvement
• Reducing lead times → enables lower DOS and higher turns
• Improving forecast accuracy → reduces need for safety stock → improves turns
• Improving inventory accuracy → better MRP execution → fewer stockouts and less excess
• Reducing lot sizes → faster flow → higher turns
• Eliminating obsolete/dead stock → immediate improvement in turns

Tip 9: Use Process of Elimination on Conceptual Questions
• If a question asks which action would MOST improve inventory turns, eliminate options that would increase inventory (like buying in bulk to get discounts) and focus on options that reduce average inventory or increase throughput.
• If a question asks what happens when safety stock increases, recognize that turns decrease and DOS increases.

Tip 10: Practice Scenario-Based Questions
• The CPIM exam increasingly features scenario-based questions. Practice interpreting data tables showing inventory levels, demand rates, and cost figures.
• Be prepared to calculate turns for a specific product, compare performance across products or time periods, and recommend actions based on the metrics.

Tip 11: Understand the Carrying Cost Components
• Capital cost (cost of money/opportunity cost) is typically the largest component.
• Storage, handling, insurance, taxes, obsolescence, and shrinkage are the other key components.
• Know that carrying cost as a percentage is used in the EOQ formula and in make-vs-buy and lot-sizing decisions.

Tip 12: Remember the Impact of Inventory Valuation Methods
• FIFO, LIFO, and weighted average methods affect the reported value of average inventory, which in turn affects calculated turns and DOS.
• The exam may ask about this conceptually rather than requiring you to perform complex accounting calculations.

---

Quick Reference Summary Table

Metric → Formula → What Higher Values Mean

• Inventory Turns → COGS / Avg Inventory → Faster inventory movement (generally good)
• Days of Supply → 365 / Turns → More inventory relative to demand (generally less desirable)
• Fill Rate → Units Shipped / Units Ordered × 100 → Better customer service (good, but costly at extremes)
• Carrying Cost % → Annual Carrying Costs / Avg Inventory × 100 → Higher cost of holding inventory
• IRA → Accurate Records / Total Records × 100 → Better data integrity (always good)

---

Final Thought

Inventory performance metrics are the scoreboard of inventory management. For the CPIM exam, you need to be able to calculate these metrics, interpret what they mean, understand the trade-offs between them, and recommend appropriate actions based on the results. Master the formulas, understand the relationships, and always think about the bigger picture of balancing cost and service. This holistic understanding will serve you well on exam day and throughout your career in supply chain management.