Inventory Aging, Dead Stock and Slow-Moving Inventory: Complete Guide for Indian Manufacturers [2026]

What Is Inventory Aging and Why Should Manufacturers Care?

Inventory aging measures how long each item in your warehouse has been sitting without being consumed in production or dispatched against a customer order. It is the simplest and most powerful diagnostic tool for manufacturing inventory health.

For most Indian MSME manufacturers, inventory is the single largest current asset on the balance sheet, representing 25 to 40 percent of total assets. That means the quality of your inventory directly determines the quality of your balance sheet and the health of your cash flow. Yet most factories have no systematic way to answer a basic question: how old is my stock?

An inventory aging report answers this by categorising every stocked item into time buckets based on the date of last movement. The standard buckets used in manufacturing are:

Without this analysis, you are flying blind. You might know your total inventory value from your accounting system, but you have no idea how much of that value is actually usable and how much is slowly rotting on your shelves.

Dead Stock vs. Slow-Moving Inventory: Know the Difference

These two terms are often used interchangeably, but they require very different responses.

Slow-moving inventory is stock that still has some consumption, but the rate of usage has dropped significantly below what was expected when it was purchased. For example, a raw material that used to be consumed at 500 kg per month but is now moving at 50 kg per month because the product using it has lower demand. The material is not dead. It still has a purpose. But at the current consumption rate, you have 10 months of supply sitting in the warehouse, tying up cash and occupying space.

Dead stock is inventory with zero movement for an extended period, typically 12 months or more. It has no confirmed production demand, no pending customer orders, and no realistic expectation of being consumed through normal operations. Common examples in Indian manufacturing include raw materials purchased for a product line that was discontinued, excess stock bought against a large order that was cancelled, materials that have been superseded by an engineering change (the BOM now calls for a different grade or specification), and items that have degraded in quality due to improper storage (rusted steel, expired chemicals, moisture-damaged packaging materials).

Why the Distinction Matters

The distinction matters because the response is different. Slow-moving inventory can often be addressed by adjusting reorder points, reducing safety stock levels, consolidating purchase orders, or accelerating production of products that consume the material. Dead stock, on the other hand, requires a disposition decision: return it, sell it, scrap it, or write it off. Treating dead stock as slow-moving (hoping it will eventually get used) just extends the carrying cost burden without solving the problem.

The True Cost of Holding Excess Inventory

Most factory owners underestimate inventory carrying cost because they only think about the purchase price. But holding inventory costs real money every single month, whether or not you use it.

Carrying cost has four components:

Let that number sink in. If your factory has INR 50 lakh of inventory and 20 percent of it (INR 10 lakh) is dead or slow-moving, you are paying INR 1.8 to 2.5 lakh per year just to store items that are generating zero revenue. Over three years, the carrying cost alone exceeds half the original purchase value of that dead stock.

For Indian MSMEs operating on working capital loans at 12 to 14 percent interest, this is especially painful. The bank charges you interest on the loan that funded the purchase of materials that are now sitting idle. You are literally paying interest on dead weight.

Why Indian Manufacturers Accumulate Dead Stock

Dead stock does not appear overnight. It accumulates gradually through a series of well-intentioned decisions that lack data backing. Here are the most common causes in Indian manufacturing factories.

1. Purchasing Based on Gut Feel, Not Production Demand

The most common cause of excess inventory in Indian factories is procurement that is disconnected from production planning. The purchase manager buys based on past experience, supplier availability, or anticipated demand rather than confirmed production orders. Without an MRP system connecting BOMs to purchase orders, there is no way to calculate exactly how much material is needed and when.

2. Supplier Minimum Order Quantities (MOQs)

Many raw material suppliers in India enforce minimum order quantities that are significantly higher than what a small factory needs. If your monthly consumption of a specialty steel grade is 200 kg but the supplier MOQ is 1,000 kg, you are forced to buy five months of supply at once. If demand drops or the customer cancels, you are stuck with excess stock.

3. Engineering Changes Without Inventory Cleanup

When the design team changes a material specification (for example, moving from EN8 to EN24 steel for a particular component), the BOM gets updated, but nobody checks whether the old material still has stock in the warehouse. The superseded material quietly becomes dead stock because no current BOM calls for it.

4. Customer Order Cancellations

In the Indian auto parts and OEM supply chain, order cancellations and volume reductions are common. When a customer cancels a 5,000-piece order after you have already procured the raw material, that material stays in your warehouse. If the material is customer-specific (a particular alloy or specification used only for that customer's parts), it may never get consumed through other orders.

5. Fear-Based Hoarding

Many Indian manufacturers hoard raw materials in anticipation of price increases, supply shortages, or long supplier lead times. While strategic buffer stock has its place, hoarding without data often results in excess stock that ties up cash. The price increase may not materialise, or the hoarded quantity may far exceed what is needed.

6. No Regular Inventory Reviews

In factories that manage inventory on registers or spreadsheets, there is no automated mechanism to flag items that have not moved. The storekeeper knows the fast-moving items by heart but has no visibility into the hundreds of line items that sit quietly in the back racks. By the time someone notices, the material has been sitting for 12 to 18 months.

How to Run an Inventory Aging Analysis

A proper inventory aging analysis is not just a report. It is a monthly discipline that turns data into decisions. Here is the step-by-step process.

Step 1: Categorise Your Inventory

Manufacturing inventory falls into three categories, and each needs separate aging analysis:

• Raw Materials: Steel, aluminium, plastics, fasteners, chemicals, and other inputs. Age is measured from the date of GRN (Goods Receipt Note) or the date of last issue to production, whichever is more recent.
• Work-in-Progress (WIP): Partially completed parts sitting on the shop floor or between operations. Age is measured from the work order start date. WIP aging over 30 days usually signals a production bottleneck or a stalled order.
• Finished Goods: Completed products waiting for dispatch. Age is measured from the date of production completion. Finished goods aging over 15 to 30 days in a make-to-order factory suggests dispatch delays or customer acceptance issues.

Step 2: Apply the Aging Buckets

For each item, calculate the number of days since last movement (last receipt, last issue, or last dispatch) and assign it to the appropriate bucket: 0 to 30 days, 31 to 90 days, 91 to 180 days, 181 to 365 days, or over 365 days. The bucket thresholds can be adjusted based on your industry. For example, a food processing factory might use 7, 15, 30, 60, and 90 day buckets because materials have shorter shelf lives.

Step 3: Layer on ABC Classification

Combine the aging analysis with ABC classification based on annual consumption value. This tells you not just how old the stock is, but how important it is financially.

An A-item with 90-day aging is a much bigger problem than a C-item with 90-day aging, simply because of the capital involved. Your review process should prioritise accordingly.

Step 4: Calculate the Financial Impact

For each item in the slow-moving or dead stock bucket, calculate:

• Current value: Quantity on hand multiplied by the current replacement cost (not the original purchase price).
• Carrying cost incurred: Current value multiplied by carrying cost rate multiplied by the number of months the item has been sitting.
• Estimated recovery value: What you can realistically get by returning it to the supplier, selling it as scrap, or using it in an alternative product.
• Net loss: Original cost minus estimated recovery value, plus carrying costs already incurred.

Step 5: Make Disposition Decisions

For every item in the 91-day-plus bucket, assign a disposition action with a deadline and an owner. The four standard disposition options are:

• Consume: Find an open production order or upcoming job that can use this material, possibly by substituting it for a similar specification.
• Return: Negotiate with the supplier for a credit note, exchange, or return. This works best within the first 6 months and with suppliers you have ongoing relationships with.
• Liquidate: Sell through scrap dealers, surplus material platforms, or to other manufacturers who can use the material. Accept a loss on the purchase price to recover partial value.
• Write off: If the material has no recovery value (damaged, expired, or no buyer), write it off in your accounting books. This clears the inventory and stops carrying cost accumulation.

7 Strategies to Prevent Dead Stock in Your Factory

Cleaning up existing dead stock is important, but preventing new dead stock from accumulating is what delivers long-term results. Here are seven strategies that work for Indian manufacturing factories.

1. Use MRP-Driven Procurement

The single most effective way to prevent excess inventory is to connect your purchasing to your production demand through Material Requirement Planning (MRP). MRP takes your confirmed sales orders, explodes them through the BOM, checks current stock levels, and generates purchase orders only for the quantity and timing that production actually needs. This eliminates the guesswork that leads to over-purchasing.

2. Set and Monitor Reorder Points and Safety Stock

Every item should have a calculated reorder point and safety stock level based on actual consumption data, not gut feel. Review these levels quarterly and adjust them when demand patterns change. Items whose demand has dropped should have their safety stock reduced proportionally.

3. Negotiate Flexible MOQs with Suppliers

Work with your key suppliers to reduce minimum order quantities for items with variable or declining demand. Offer longer-term rate contracts in exchange for smaller per-order quantities. Consolidate orders across multiple items from the same supplier to meet their minimum value threshold without over-ordering any single item.

4. Link Engineering Changes to Inventory Disposition

Whenever an engineering change notice (ECN) supersedes a material, the change process should include a mandatory step to check the inventory of the old material and create a disposition plan. This prevents superseded materials from silently becoming dead stock.

5. Implement First-In-First-Out (FIFO) Consumption

Enforce FIFO at the stores level so that older stock is always issued first. This is especially critical for materials with shelf life limitations (adhesives, chemicals, rubber compounds) but is good practice for all materials. FIFO ensures that no batch sits at the back of the rack indefinitely while newer receipts get consumed.

6. Run Monthly Aging Reviews

Schedule a monthly inventory review meeting with the purchase manager, production manager, and stores in-charge. Review the aging report, discuss items that have crossed the 90-day threshold, and assign actions. This 30-minute meeting, done consistently, prevents small problems from becoming large write-offs.

7. Set Automatic Alerts for Aging Thresholds

Configure your inventory system to send automatic email or dashboard alerts when any item crosses a predefined aging threshold. For example, an alert at 60 days gives you a 30-day window to act before the item enters the slow-moving bucket. Without automation, these alerts simply do not happen in a busy factory.

Managing Inventory Aging: Excel vs. ERP

Many Indian manufacturers attempt to track inventory aging using Excel spreadsheets. While Excel is better than no tracking at all, it has fundamental limitations that make it unreliable for ongoing inventory management.

How ERPDrive Solves Inventory Aging and Dead Stock

ERPDrive is built for Indian manufacturers and includes a complete set of tools to identify, prevent, and manage inventory aging across raw materials, WIP, and finished goods.

Real-Time Inventory Aging Dashboard

ERPDrive generates a real-time inventory aging report that categorises every stocked item by age bucket. You can filter by warehouse location, material category, ABC class, or supplier. The dashboard highlights the total value trapped in each aging bucket so you can see the financial impact at a glance.

Automatic Aging Alerts

Configure threshold-based alerts that notify the purchase manager and stores in-charge when any item crosses a predefined age limit. For example, set an alert at 60 days for A-items and 90 days for B and C items. The system sends email notifications and highlights flagged items on the dashboard.

MRP-Driven Purchase Suggestions

ERPDrive's MRP engine calculates material requirements from confirmed sales orders and planned production orders, checks current stock and pending purchase orders, and generates purchase suggestions for only the quantity needed. This eliminates the guesswork that leads to over-purchasing and is the most effective single feature for preventing dead stock.

ABC Analysis with Consumption Trends

The system automatically classifies items into A, B, and C categories based on consumption value and updates the classification as patterns change. Items that shift from A to C category (declining consumption) are flagged for review, helping you catch slow-moving trends before the stock becomes dead.

Engineering Change Integration

When a BOM is updated through an engineering change order, ERPDrive automatically checks the current stock of superseded materials and creates a disposition task. The old material does not silently become dead stock because the system forces a decision at the time of the change.

FIFO Batch Tracking

ERPDrive tracks every material batch with its receipt date and enforces FIFO by suggesting the oldest batch first when materials are issued to production. This prevents old batches from accumulating at the back of the warehouse while newer receipts are consumed.

Disposition Workflow

For items that have entered the slow-moving or dead stock zone, ERPDrive provides a structured disposition workflow. Each flagged item can be assigned an action (consume, return, liquidate, or write off), an owner, and a deadline. The system tracks disposition progress and escalates overdue items.

Real-World Impact: What Happens When You Fix Inventory Aging

Consider a typical 30-person CNC machining factory in Pune with INR 80 lakh of total inventory. Before implementing ERP-driven inventory controls, the factory's inventory profile looked like this:

That is INR 28 lakh of working capital trapped in stock that is not actively supporting production. At a 20 percent carrying cost, that dead and slow-moving inventory costs INR 5.6 lakh per year just to hold.

After six months of ERP-driven inventory management (MRP procurement, monthly aging reviews, automatic alerts, and disposition workflows), the same factory's inventory profile improved to:

The factory freed INR 19 lakh of working capital (from INR 28 lakh to INR 9 lakh of aged stock), reduced total inventory from INR 80 lakh to INR 60 lakh without any stock-outs, and saved approximately INR 3.8 lakh per year in carrying costs. The freed-up cash was used to negotiate better payment terms with suppliers and invest in a new VMC machine.

GST and Accounting Treatment for Dead Stock Write-Offs

When you write off dead stock in India, there are GST implications that manufacturers need to handle correctly.

Under GST law, if you claimed Input Tax Credit (ITC) on raw materials that are subsequently written off, destroyed, or disposed of as scrap, you are required to reverse the ITC proportionally. Section 17(5)(h) of the CGST Act covers this. The reversal applies to goods that are written off or disposed of by way of gift or free samples.

For scrap sales, GST is applicable on the sale value at the applicable rate. Issue a proper tax invoice for the scrap sale and collect GST. This is different from a write-off where no sale occurs.

From an accounting perspective, dead stock write-offs should be recorded as an expense (typically under "Inventory Write-Off" or "Abnormal Loss") and the corresponding inventory value should be reduced. Maintain proper documentation including the aging report, management approval, and physical verification records to support the write-off during audits.

ERPDrive handles the accounting entries and GST ITC reversal calculations automatically when you process a dead stock write-off through the disposition workflow.

Frequently Asked Questions

What is inventory aging and why does it matter for manufacturers?

Inventory aging measures how long items have been sitting in your warehouse without consumption or dispatch. It matters because aged inventory ties up working capital, incurs carrying costs of 18 to 25 percent per year, occupies storage space, and risks obsolescence. For Indian MSME manufacturers where inventory is 25 to 40 percent of total assets, regular aging analysis is essential for cash flow health.

What is dead stock and how is it different from slow-moving inventory?

Dead stock has zero movement for over 12 months and no realistic prospect of being consumed. Slow-moving inventory still has some consumption, but at a rate far below what justifies the capital tied up in it. Slow-moving stock may recover with demand changes. Dead stock almost always requires liquidation, return, or write-off. The distinction drives different corrective actions.

How do I calculate inventory carrying cost for my factory?

Add up four components: capital cost (10 to 14 percent, based on your working capital loan rate), storage cost (2 to 5 percent for warehouse rent, electricity, and labour), risk cost (2 to 4 percent for obsolescence, damage, and shrinkage), and service cost (1 to 2 percent for insurance and management). The total for most Indian manufacturers is 18 to 25 percent of average inventory value per year.

What causes dead stock in Indian manufacturing factories?

The most common causes are: procurement disconnected from production demand (no MRP), supplier MOQ pressure forcing over-purchasing, engineering changes that supersede materials without inventory cleanup, customer order cancellations after raw material procurement, fear-based hoarding ahead of anticipated price increases, and lack of regular inventory reviews. Factories without automated aging alerts catch these problems months too late.

How does ABC analysis help reduce dead stock?

ABC analysis classifies items by annual consumption value. A items (top 15 to 20 percent, representing 70 to 80 percent of value) get weekly reviews. B items get monthly reviews. C items get quarterly reviews, with any C item showing zero movement for 90 days flagged immediately. This ensures your review effort is proportional to the financial risk.

How can ERP software prevent dead stock?

ERP software like ERPDrive prevents dead stock through MRP-driven procurement (buying only what production needs), automatic aging alerts, dynamic ABC classification, engineering change integration (flagging stock of superseded materials), FIFO batch enforcement, and structured disposition workflows. Factories implementing ERP-driven inventory controls typically reduce dead stock by 40 to 60 percent within six months.

What should I do with dead stock already in my warehouse?

Follow a structured process. Classify items by condition: usable (consume in alternative production), returnable (negotiate supplier credit), saleable (sell as scrap or surplus), or valueless (write off). For each item, assign an action owner and a deadline. Act quickly because every month of delay adds 1.5 to 2 percent in carrying costs. Process the accounting entries and GST ITC reversals properly for write-offs.

Conclusion: Stop Paying to Store Stock You Will Never Use

Dead stock and slow-moving inventory are silent cash drains in Indian manufacturing factories. They do not cause dramatic production shutdowns or customer complaints. They just quietly tie up 15 to 25 percent of your working capital, cost you 18 to 25 percent per year in carrying charges, and occupy warehouse space that could hold materials you actually need.

The fix is not complicated. It starts with a monthly inventory aging report that categorises every item by how long it has been without movement. Layer on ABC classification to prioritise by financial impact. Use MRP to connect procurement to actual production demand. Set automatic alerts at aging thresholds so problems are caught early. And run a structured disposition process for items that have crossed into the slow-moving or dead stock zone.

A cloud manufacturing ERP like ERPDrive automates all of this. Real-time aging dashboards, automatic alerts, MRP-driven purchase suggestions, FIFO enforcement, engineering change integration, and disposition workflows in one connected system. Factories that implement these controls typically free 10 to 15 percent of working capital and reduce dead stock by 40 to 60 percent within six months.

If your warehouse has materials that have been sitting untouched for months and you do not have a system to tell you about them, book a free demo with ERPDrive. See exactly where your working capital is trapped and how to free it.