Storekeeping & Warehouse Operations

Chapter 7
Inventory Control, Records and Stock Accuracy

Post Graduate Programme in Materials Management
Storekeeping & Warehouse Operations   •   Post Graduate

Inventory Control, Records and Stock Accuracy

Introduction

Inventory control is the systematic planning, ordering, receiving, storing, issuing, recording and reviewing of materials so that the required item is available in the required quantity and condition, at the required time, while total cost and operational risk remain acceptable. In a store or warehouse, inventory is not merely a physical collection of goods. It is also a data system: every receipt, movement, adjustment and issue must be represented accurately in records.

Poor inventory control creates two apparently opposite problems. Excess stock ties up capital, occupies space, increases deterioration and may become obsolete. Insufficient stock causes production stoppages, emergency purchases, customer-service failures and reputational damage. Stock accuracy connects physical control with financial control, procurement and operational continuity.

This chapter integrates quantitative inventory models—economic order quantity (EOQ), reorder levels and safety stock—with selective inventory classification using ABC, VED, FSN, HML and SDE analyses. It also explains perpetual records, cycle counting, reconciliation and root-cause analysis as parts of one control system rather than isolated techniques.

Learning objectives

After studying this chapter, the learner should be able to:

  1. Explain the purpose and logic of inventory control and perpetual records.
  2. Calculate and interpret EOQ, reorder level and safety stock under stated assumptions.
  3. Apply ABC, VED, FSN, HML and SDE classifications and combine them for differentiated control.
  4. Design cycle-counting and reconciliation procedures that improve stock accuracy.
  5. Diagnose inventory discrepancies using root-cause analysis.
  6. Evaluate the managerial, technological, ethical and governance implications of inventory decisions.

1. Inventory control as an integrated system

Inventory control seeks a balance among service, cost, risk and information quality. Its principal decisions are:

  • What to stock: item identification, specification, approved alternatives and criticality.
  • How much to stock: order quantity, minimum and maximum levels, and safety stock.
  • When to replenish: reorder point and review frequency.
  • How to control it: authorization, location discipline, preservation, records and verification.
  • How to improve it: performance measurement, exception management and corrective action.

The basic inventory cycle is:

Demand or issue → stock depletion → reorder signal → purchase or production → receipt and inspection → put-away → record update → subsequent issue.

A control system is effective only when the physical and informational cycles agree. A perpetual inventory system updates the recorded balance after each transaction. A periodic system determines stock only at scheduled counts. Perpetual records provide timely visibility, but they do not guarantee accuracy: an incorrectly posted receipt produces a precise-looking but false balance.

Important records include the item master, stock ledger, bin card, goods-receipt note, inspection report, material issue voucher, transfer note, return note, adjustment authorization and purchase-order file. The item master should include a unique stock-keeping unit (SKU), description, unit of measure, specifications, approved suppliers, lead time, classification codes and control parameters.

Stock accuracy and the inventory record

Stock accuracy may be expressed as the proportion of checked records that agree with physical quantities:

Stock accuracy (%) = (Number of records within the approved tolerance ÷ Total records checked) × 100

The formula is meaningful only when the tolerance, counting method and population are defined. A financial accuracy measure may instead compare the value of correctly recorded stock with total stock value; this can conceal numerous errors in low-value items. Consequently, organizations should use both quantity-based and value-based measures, supplemented by service and discrepancy measures.

Common causes of disagreement include unposted receipts, incorrect units of measure, duplicate item codes, picking errors, unrecorded returns, unauthorized access, damage, counting mistakes, location errors and timing differences between physical movement and system posting.

2. Quantitative inventory control

2.1 Economic order quantity

The classical EOQ model identifies the order quantity that minimizes the sum of ordering and holding costs when demand is reasonably stable.

Q* = √(2DS ÷ H)

Here, Q* is the economic order quantity in units per order, D is annual demand in units per year, S is ordering or setup cost per order, and H is annual holding cost per unit per year. Unit consistency requires D and Q* to be in the same units and S and H to be monetary amounts in the same period.

The model assumes relatively constant demand, known ordering and holding costs, instantaneous replenishment, no stockouts, and no quantity discounts. It is a benchmark, not an automatic purchasing instruction. Quantity discounts, capacity constraints, shelf-life, supplier minimums and variable demand may require a modified decision.

Annual relevant cost under the basic model is:

TC(Q) = (D ÷ Q)S + (Q ÷ 2)H

The first term is annual ordering cost and the second is annual cycle-stock holding cost. Purchase cost is omitted when unit price does not vary with order quantity. At EOQ, ordering cost and cycle-stock holding cost are equal under the model assumptions.

Worked example. Annual demand is 12,000 units, ordering cost is ₹600 per order, and annual holding cost is ₹24 per unit. Therefore:

Q* = √[(2 × 12,000 × 600) ÷ 24]
Q* = √600,000 ≈ 774.6 units

The practical order quantity is approximately 775 units, subject to packaging, supplier and storage constraints. The number of orders per year is approximately 12,000 ÷ 774.6 = 15.5, and average cycle stock is approximately 387 units, excluding safety stock.

2.2 Reorder point and lead-time demand

A reorder point is the inventory position at which replenishment should be initiated. With constant demand and lead time:

ROP = dL

d is demand per time period and L is replenishment lead time in the same time unit. If safety stock is maintained:

ROP = dL + SS

SS is safety stock. The calculation must use inventory position—not merely on-hand stock—when outstanding orders and backorders are material:

Inventory position = On-hand stock + On-order stock − Backorders

Example. Average daily demand is 40 units, lead time is 7 days and safety stock is 60 units. Then:

ROP = (40 × 7) + 60 = 340 units

An order signal is generated when the inventory position reaches approximately 340 units, subject to the organization’s review and authorization process.

2.3 Safety stock

Safety stock protects against uncertainty in demand, lead time or both. Its calculation should reflect the selected service objective and the quality of demand and lead-time data.

If demand during a fixed lead time is approximately normally distributed and lead time is constant, a common approximation is:

SS = zσL

z is the standard-normal service factor, and σL is the standard deviation of demand during lead time. If daily demand has standard deviation σd and lead time is L days, independent daily demand gives:

σL = σd√L

Thus:

SS = zσd√L

The assumptions are independent demand observations, stable variance, constant lead time and an approximately normal distribution. These assumptions are often weak for intermittent demand, seasonal demand or highly variable lead times.

When both daily demand and lead time vary independently, with average daily demand d̄, average lead time L̄, daily-demand standard deviation σd and lead-time standard deviation σL, a widely used approximation is:

σDL = √(L̄σd² + d̄²σL²)

and:

SS = zσDL

This approximation ignores the interaction term and assumes independence. For correlated demand and lead time, or for non-normal and intermittent demand, empirical lead-time-demand distributions, simulation or specialized forecasting methods are preferable.

A service factor must be interpreted carefully. A higher z reduces the probability of a stockout during the protection period under the model, but increases holding cost. “95% service level” can mean cycle service level, fill rate or another metric; these are not interchangeable.

3. Inventory classification and differentiated control

No organization should control every item identically. Classification directs managerial attention according to financial impact, operational criticality, movement and procurement difficulty.

ABC analysis

ABC analysis ranks items by annual consumption value:

Annual consumption value = Annual demand × Unit price

A common policy is that A items represent a relatively small percentage of items but a large percentage of value; B items have intermediate significance; C items are numerous but low in annual value. The boundaries are managerial conventions, not universal laws. A typical policy might place approximately 70–80% of cumulative value in A, the next 15–25% in B and the remainder in C.

A items require accurate records, close forecasting, senior review, frequent cycle counting and supplier performance monitoring. C items may use simpler controls, larger order quantities or two-bin systems, provided their operational criticality is not high.

VED analysis

VED classifies criticality:

  • Vital: non-availability can stop operations or create serious safety consequences.
  • Essential: non-availability reduces performance or causes significant inconvenience.
  • Desirable: non-availability has limited immediate effect.

VED is particularly useful for maintenance, repair and operating supplies. A low-value vital spare must not be treated as a low-priority C item merely because its annual consumption value is small.

FSN analysis

FSN classifies items by movement:

  • Fast-moving: issued frequently.
  • Slow-moving: issued occasionally.
  • Non-moving: no issue for a defined period.

The time threshold should reflect the item’s demand pattern and life cycle. Non-moving does not automatically mean unnecessary: emergency spares may be intentionally held. FSN analysis should therefore be combined with VED and engineering review.

HML analysis

HML classifies unit price:

  • High-cost: expensive per unit and requiring strong authorization.
  • Medium-cost: intermediate unit cost.
  • Low-cost: inexpensive per unit.

HML supports security, approval and issue controls, whereas ABC focuses on annual consumption value. An item may be low in annual usage but high in unit price.

SDE analysis

SDE classifies procurement difficulty:

  • Scarce: difficult to obtain, imported, capacity-constrained or subject to long lead times.
  • Difficult: available only from limited or specialized sources.
  • Easy: readily available from several sources.

SDE helps set sourcing strategies, qualify alternatives and determine whether additional protection against supply disruption is justified.

Combined interpretation

The classifications answer different questions. ABC asks, “Where is the annual monetary exposure?” VED asks, “What is the consequence of non-availability?” FSN asks, “How frequently does it move?” HML asks, “How costly is one unit?” SDE asks, “How difficult is replenishment?”

A practical matrix may identify an A–V–S item as requiring senior oversight, robust specifications, high record accuracy, approved substitutes and contingency sourcing. A C–D–E item may be controlled through periodic review, standardization and economical replenishment. These are starting policies, not rigid rules.

4. Perpetual records and transaction discipline

The stock ledger records receipts, issues, transfers, returns, adjustments, balance quantity, unit cost and value. A bin card normally records physical quantity at the storage location. In a mature system, the two should agree after timing differences are resolved.

Every transaction should have:

  1. a source document and authorized originator;
  2. a unique item code and correct unit of measure;
  3. quantity, date, location and batch or serial information where applicable;
  4. a clear status—available, quarantined, rejected, damaged or reserved;
  5. prompt posting and an auditable user trail.

The unit-of-measure problem is especially serious. If purchasing uses cartons, receiving uses boxes and issuing uses pieces, conversion factors must be controlled in the item master. Unapproved manual conversions generate systematic discrepancies.

A perpetual system should not permit negative stock without an approved exception process. Negative balances often indicate late posting, wrong location, duplicate codes or unauthorized issues. However, blocking all transactions without an operational contingency can encourage workarounds. Governance must combine system controls with practical escalation procedures.

5. Cycle counting, reconciliation and stock accuracy

Cycle counting

Cycle counting is the planned counting of selected items throughout the year rather than relying only on one annual physical inventory. Selection may be based on ABC class, VED criticality, discrepancy history, risk, value or random sampling.

A differentiated schedule might count A or vital items monthly, B items quarterly and C items semi-annually or annually. This is illustrative; the correct frequency depends on risk, transaction volume and accuracy history. Counters should, where possible, use blind counts that do not display the book balance. Independent recounts are needed for differences exceeding tolerance.

A sound cycle-count procedure is:

  1. freeze or identify transactions at the location and time of count;
  2. verify item identity, unit, location, condition and batch or serial number;
  3. count without relying on the displayed balance;
  4. recount significant differences;
  5. compare physical and recorded quantities;
  6. investigate before adjustment;
  7. authorize and post the correction;
  8. record the cause and monitor recurrence.

Reconciliation

Reconciliation explains differences; adjustment merely changes the record. The reconciliation process should compare receiving, inspection, put-away, issue, transfer, return, scrap and system-posting timestamps. It should also reconcile sub-ledgers with the general ledger where inventory value is financially material.

A quantity discrepancy can be represented as:

Discrepancy = Physical quantity − Recorded quantity

A positive result indicates excess physical stock; a negative result indicates a shortage. If valuation is required and unit cost is appropriate and stable:

Inventory variance value = Discrepancy × Approved unit cost

For items with multiple costs, batch valuation, standard cost or moving-average rules must be applied consistently with the organization’s accounting policy.

Accuracy metrics should include record accuracy by class, count completion, adjustment value, aged discrepancies, negative-stock incidents, order-fill performance and stockout frequency. A single accuracy percentage can create perverse incentives if employees avoid counting difficult locations or conceal discrepancies.

6. Root-cause analysis and continuous improvement

A discrepancy is a symptom, not a cause. Root-cause analysis should distinguish immediate error, contributing condition and system weakness. Useful methods include the five whys, fishbone diagrams, Pareto analysis and process mapping.

A five-whys investigation may proceed as follows:

  • Why was the system balance higher than physical stock? An issue was not posted.
  • Why was it not posted? The material was issued during a production emergency.
  • Why was the emergency process used? The normal issue authorization was too slow.
  • Why was the process too slow? Approval required an unavailable supervisor.
  • Why was no alternative approval defined? The procedure lacked an escalation design.

The corrective action is therefore not simply “remind the storekeeper.” It may require delegated authority, mobile posting, segregation of emergency stock and daily exception review.

Root causes commonly fall into six categories: people, process, technology, data, material and environment. Corrective actions should have an owner, due date, evidence of completion and effectiveness check. For recurring errors, preventive action should modify the process or control, not merely retrain staff.

7. Applied case: maintenance spares at Meridian Components

The following is an illustrative case.

Background

Meridian Components operates a continuous-process plant. Its stores contained 8,400 SKUs. The annual physical count reported 91% quantity accuracy, but production experienced repeated stockouts of inexpensive maintenance spares. At the same time, obsolete bearings and imported control modules occupied substantial space.

Problem

The organization used a perpetual enterprise system, but receipts were sometimes posted after items had been issued. Engineering descriptions created duplicate item codes, and cycle counting was based only on annual consumption value. Consequently, low-value vital spares were counted infrequently.

Analysis

A combined analysis classified items by ABC, VED, FSN, HML and SDE. The review found:

  • several C–V items with frequent emergency issues;
  • A–S imported modules with long and variable lead times;
  • HML-high items stored in unsecured locations;
  • non-moving items that were technically obsolete but still shown as available;
  • discrepancies concentrated in one receiving zone and one shift.

Transaction-timestamp analysis showed that 62% of large discrepancies involved a receipt or issue posted more than one working day after physical movement. Interviews identified an emergency issue procedure that bypassed the system and was not reconciled consistently.

Approach and solution

Meridian introduced the following controls:

  1. a governed item master and duplicate-code review;
  2. VED overrides so vital items received frequent counts regardless of value;
  3. monthly counts for A and vital items, quarterly counts for B items and risk-based counts for C items;
  4. barcode scanning at receipt, put-away and issue;
  5. a controlled emergency-issue transaction with next-shift reconciliation;
  6. reorder points based on lead-time demand and safety stock for critical spares;
  7. SDE review of imported modules and approved substitute specifications;
  8. quarantine locations for uninspected and rejected stock;
  9. root-cause dashboards by location, process and shift;
  10. disposal and reclassification review for obsolete stock.

Outcome

After six months, quantity accuracy rose from 91% to 98.4%, emergency purchases declined, and the receiving-zone discrepancy rate fell sharply. The improvement did not result from counting more frequently alone. It arose from combining classification, transaction discipline, technology, governance and corrective action.

Learning points

The case demonstrates that value-based prioritization is insufficient by itself. Criticality, supply difficulty and movement must influence control intensity. It also shows that automation improves visibility only when master data, procedures and accountability are sound.

8. Technology, governance and contemporary practice

Warehouse management systems, enterprise resource planning systems, barcode scanning, radio-frequency identification, handheld terminals and automated identification can reduce transcription and timing errors. RFID may improve visibility where tags can be read reliably, but metal, liquids, tag quality and process design can limit performance.

Artificial intelligence can support demand forecasting, anomaly detection, duplicate-item identification and risk-based cycle-count scheduling. Its outputs should remain subject to human review, data-quality checks and explainable rules. A forecast is not a substitute for engineering judgment about critical spares or safety consequences.

Governance requires segregation of duties: purchasing should not unilaterally receive goods, and the person approving an adjustment should not be the sole person who benefits from it. Access rights, audit trails, retention of source documents and periodic independent review protect both assets and employees. Ethical practice includes accurate reporting, no concealment of shortages, fair supplier treatment and transparent disposal of obsolete or hazardous materials.

Inventory decisions may also be affected by accounting standards, customs requirements, product traceability, health and safety rules, hazardous-material regulations and data-protection requirements. The exact legal obligations depend on jurisdiction and industry; organizations should consult applicable standards and professional advisers.

9. Limitations and managerial judgement

EOQ can produce false precision when demand, lead time or costs are unstable. Safety-stock formulas based on normality may be inappropriate for intermittent demand. ABC thresholds can ignore criticality. FSN can label an emergency spare as non-moving without recognizing its purpose. Perpetual records can create confidence without accuracy if transactions are delayed. Cycle counting can become ritualistic if discrepancies are adjusted without investigation.

Managers should therefore treat models as decision aids. Parameters should be reviewed after changes in demand, supplier performance, price, technology, product design or service requirements. The appropriate objective is not minimum inventory in isolation, but an economically and operationally defensible balance between availability, cost, risk and control effort.

Chapter Summary

Inventory control integrates physical handling, quantitative replenishment and reliable information. EOQ balances ordering and holding costs under clearly stated assumptions. The reorder point combines lead-time demand with safety stock, while safety-stock calculations must reflect uncertainty and service objectives. ABC, VED, FSN, HML and SDE classifications provide complementary views of value, criticality, movement, unit cost and supply difficulty; combined classifications support differentiated control.

Perpetual records require disciplined item masters, source documents, units of measure, prompt posting and audit trails. Cycle counting and reconciliation reveal discrepancies, but lasting improvement requires root-cause analysis and corrective action. Technology can reduce errors and improve visibility, yet governance, data quality and professional judgement remain essential. The central principle is that stock accuracy is a managed operational capability, not merely a counting result.

Key Terms

Inventory control: Coordinated planning and control of materials to meet demand at acceptable cost and risk.

Perpetual inventory: A system that updates inventory records after each authorized transaction.

Stock accuracy: Agreement between recorded and physically verified inventory within defined tolerance.

EOQ: Order quantity that minimizes relevant ordering and holding costs under specified assumptions.

Reorder point: Inventory position at which replenishment is initiated.

Safety stock: Additional inventory held to protect against uncertainty.

Lead time: Time between placing an order and its usable receipt.

Inventory position: On-hand stock plus on-order stock minus backorders.

ABC analysis: Classification by annual consumption value.

VED analysis: Classification by operational criticality.

FSN analysis: Classification by movement frequency.

HML analysis: Classification by unit price.

SDE analysis: Classification by procurement difficulty.

Cycle counting: Planned periodic counting of selected inventory items.

Reconciliation: Investigation and explanation of differences between records and physical stock.

Root-cause analysis: A structured method for identifying underlying causes of a problem.

SKU: A uniquely identified stock-keeping unit.

Inventory position: The replenishment-relevant balance including on-order and backordered quantities.

Fill rate: Proportion of demand quantity met immediately from available stock.

Review Questions

Short Answer Questions

  1. What is the difference between a perpetual inventory system and a periodic inventory system?
  2. Define reorder point and explain why inventory position may be more useful than on-hand stock.
  3. What does VED analysis measure?
  4. State two assumptions of the classical EOQ model.
  5. Why is reconciliation more than merely posting an inventory adjustment?

Long Answer Questions

  1. Explain the EOQ model, its formula, assumptions, limitations and managerial interpretation.
  2. Discuss how ABC, VED, FSN, HML and SDE analyses can be combined to create differentiated inventory policies.
  3. Describe a complete cycle-counting and reconciliation process for a warehouse.
  4. Explain the role of item-master governance, units of measure and transaction discipline in stock accuracy.
  5. Evaluate the benefits and risks of barcode, RFID, warehouse-management systems and AI-supported inventory control.

Analytical / Application Questions

  1. Annual demand is 18,000 units, ordering cost is ₹450 per order and annual holding cost is ₹18 per unit. Calculate EOQ and explain two practical issues that should be reviewed before adopting the result.
  2. Average daily demand is 75 units, lead time is 6 days and safety stock is 250 units. Calculate the reorder point. Explain how the decision changes if lead time becomes highly variable.
  3. A low-value spare has no issue for 14 months but is required to restart a safety-critical machine. Recommend its likely classifications and control policy using at least three of the analytical frameworks in this chapter.

Multiple Choice Questions with Answers

Question 1

Which expression represents the classical economic order quantity?

A. √(2DS ÷ H)

B. D + S + H

C. dL − SS

D. (D ÷ Q) + (Q ÷ H)

Correct Answer: A. √(2DS ÷ H)

Question 2

Annual demand is 10,000 units, ordering cost is ₹200 and annual holding cost is ₹8 per unit. What is the approximate EOQ?

A. 250 units

B. 500 units

C. 707 units

D. 1,000 units

Correct Answer: C. 707 units

Question 3

Daily demand is 30 units, lead time is 5 days and safety stock is 40 units. What is the reorder point?

A. 110 units

B. 150 units

C. 190 units

D. 200 units

Correct Answer: C. 190 units

Question 4

Which classification focuses primarily on the consequence of non-availability?

A. ABC

B. VED

C. FSN

D. HML

Correct Answer: B. VED

Question 5

An item with no issue for a defined period is generally classified under which FSN category?

A. Fast-moving

B. Seasonal-moving

C. Non-moving

D. Essential-moving

Correct Answer: C. Non-moving

Question 6

Which statement about safety stock is correct?

A. It eliminates all stockout risk at zero cost.

B. It protects against uncertainty in demand or replenishment.

C. It is identical to cycle stock.

D. It is calculated only from unit price.

Correct Answer: B. It protects against uncertainty in demand or replenishment.

Question 7

What is the principal purpose of cycle counting?

A. To replace all receiving inspections

B. To verify selected inventory records throughout the year

C. To increase purchase prices

D. To classify suppliers by location

Correct Answer: B. To verify selected inventory records throughout the year

Question 8

Which formula expresses inventory position?

A. On-hand stock − on-order stock + backorders

B. On-hand stock + on-order stock − backorders

C. On-order stock − on-hand stock − backorders

D. On-hand stock + backorders − on-order stock

Correct Answer: B. On-hand stock + on-order stock − backorders

Question 9

A low-value item whose absence can stop production would most appropriately receive which criticality classification?

A. Desirable

B. Essential

C. Vital

D. Easy

Correct Answer: C. Vital

Question 10

What is the most appropriate response when a physical count differs from the book balance?

A. Immediately alter the record without investigation

B. Ignore the difference if the item is low value

C. Investigate, reconcile, authorize and then post the adjustment

D. Delete the item code

Correct Answer: C. Investigate, reconcile, authorize and then post the adjustment

Storekeeping & Warehouse Operations
Chapter 7 of 15