Inventory and Materials Management: A Complete Guide with Formulas and Examples
Learn how organisations plan, buy, store, track and control materials and stock. Covers types of inventory, EOQ, reorder point, safety stock, ABC analysis, FIFO vs LIFO, MRP, KPIs and technology, with worked examples for students and practitioners in the USA, UK, Canada and Australia.
Introduction: Why Inventory and Materials Management Matter
Inventory is money sitting on a shelf. Too little, and customers go unserved and production lines stop. Too much, and cash is trapped, storage costs climb and stock goes obsolete. Inventory management and materials management exist to find the balance between these two failures.
Inventory often represents one of the largest current assets on a balance sheet, so improving it affects service levels, working capital and profit at the same time. This guide explains the core concepts from first principles and includes worked calculations you can reuse in assignments, exams and real projects.
- What is inventory management?
- What is materials management?
- Types of inventory
- Inventory costs
- The materials management cycle
- Key formulas with examples
- ABC analysis
- Inventory valuation: FIFO, LIFO, average
- Control systems and cycle counting
- MRP, JIT, kanban and VMI
- Warehouse basics
- Inventory KPIs
- Technology and SAP MM
- USA, UK, Canada and Australia
- Mini case study
- Common mistakes
- FAQ
- Study questions and glossary
1. What Is Inventory Management?
Inventory management is the practice of deciding what to stock, how much to hold, when to reorder and where to keep it, then tracking and controlling stock accurately. Its goals are high service levels, low total cost and reliable records.
Service
Availability of items when customers or production need them.
Cost
Balance of ordering, holding and shortage costs.
Accuracy
System records that match physical stock.
2. What Is Materials Management? How Is It Different?
Materials management manages the whole flow of materials: forecasting needs, purchasing, receiving, inspection, storage, issuing to production and disposal. Inventory management is one part of it.
| Feature | Inventory management | Materials management |
|---|---|---|
| Scope | Stock levels, records, replenishment | Planning, buying, storage, movement, control |
| Main question | How much do we hold and when do we reorder? | How do materials flow efficiently to where they are needed? |
| Typical tools | EOQ, reorder point, ABC, cycle counts | MRP, procurement, logistics, warehouse systems |
| Example | Setting reorder points for 5,000 SKUs | Coordinating suppliers, receiving and production issues for a plant |
3. Types of Inventory
| Type | Meaning | Example |
|---|---|---|
| Raw materials | Inputs not yet processed | Steel coil, flour |
| Work in process (WIP) | Partly finished goods | Unassembled engines |
| Finished goods | Completed products ready to sell | Packaged bread |
| MRO supplies | Maintenance, repair and operating items | Bearings, lubricants, gloves |
| Cycle stock | Stock from ordering in batches | A pallet received weekly |
| Safety stock | Buffer against variability | Extra units held for late deliveries |
| Anticipation stock | Built ahead of known peaks | Holiday toys, seasonal goods |
| Pipeline stock | Goods in transit | Containers at sea |
4. Inventory Costs You Must Understand
Ordering cost (S)
Cost of placing and receiving an order: admin, transport, inspection.
Holding cost (H)
Capital, storage, insurance, handling, shrinkage and obsolescence. Often estimated at roughly 20-30% of inventory value per year.
Stockout cost
Lost sales, expediting, line stoppages and damaged customer trust.
Purchase cost
Unit price paid, including any quantity discounts.
5. The Materials Management Cycle
Plan requirements
Forecast demand and calculate material needs using sales plans, bills of materials and MRP.
Source and purchase
Select suppliers, negotiate, and place purchase orders.
Receive and inspect
Check quantity and quality against the PO and delivery note, then record the goods receipt.
Store and protect
Put away stock in the right location and condition, with traceability by batch or serial number.
Issue and move
Pick and issue materials to production or customers, updating records at each movement.
Control and improve
Run counts, review KPIs, handle excess and obsolete stock, and refine parameters.
6. Key Inventory Formulas with Worked Examples
6.1 Economic Order Quantity (EOQ)
D = annual demand, S = cost per order, H = holding cost per unit per year
EOQ = √(2 × 24,000 × 75 / 5) = √720,000 ≈ 849 units.
Orders per year ≈ 28.3. Annual ordering cost ≈ $2,121 and holding cost ≈ $2,121, so total relevant cost ≈ $4,243. At the EOQ, ordering and holding costs are equal.
Limits: EOQ assumes constant demand and costs. Adjust for discounts, minimum order quantities and variability.
6.2 Safety Stock
Z = service-level factor (1.65 for about 95%), σd = standard deviation of daily demand, L = lead time in days
Safety stock = 1.65 × 8 × √7 ≈ 1.65 × 8 × 2.646 ≈ 35 units.
6.3 Reorder Point (ROP)
ROP = (40 × 7) + 35 = 315 units. When stock on hand plus on order falls to 315, place a new order.
6.4 Inventory Turnover and Days of Inventory
Days of inventory = 365 / turnover
Turnover = 6 times a year; days of inventory = 365 / 6 ≈ 61 days. Raising turnover to 8 cuts average inventory to $300,000 and frees $100,000 in cash.
6.5 Service Level and Fill Rate
Cycle service level is the probability of not stocking out in an order cycle. Fill rate is the share of demand met from stock (for example, 970 of 1,000 units shipped from stock = 97%).
7. ABC Analysis: Focus on What Matters
ABC analysis applies the Pareto principle: a small share of items drives most of the value. Rank items by annual usage value (annual demand × unit cost) and group them.
| Class | Share of items | Share of usage value | Control approach |
|---|---|---|---|
| A | about 10% | about 70% | Tight control, frequent counts, accurate forecasts |
| B | about 20% | about 20% | Moderate control, periodic review |
| C | about 70% | about 10% | Simple rules, bulk buying, two-bin systems |
8. Inventory Valuation: FIFO, LIFO and Weighted Average
| Method | Cost of goods sold | Ending inventory (50 units) |
|---|---|---|
| FIFO | 100 × $10 + 50 × $12 = $1,600 | 50 × $12 = $600 |
| LIFO | 100 × $12 + 50 × $10 = $1,700 | 50 × $10 = $500 |
| Weighted average ($11) | 150 × $11 = $1,650 | 50 × $11 = $550 |
9. Inventory Control Systems and Cycle Counting
| System | How it works | Best for |
|---|---|---|
| Continuous (Q) system | Order a fixed quantity when stock hits the reorder point | High-value or critical items |
| Periodic (P) system | Review at fixed intervals and order up to a target level | Many low-value items, grouped orders |
| Min-max | Reorder up to a maximum when stock falls to a minimum | MRO and spare parts |
| Two-bin | Reorder when the first bin empties | Low-cost C items |
Perpetual inventory updates records with every transaction (usually barcode or RFID driven). Periodic inventory relies on physical counts. Cycle counting counts a few items every day, with A items counted most often, instead of a once-a-year shutdown count. Investigate every variance for its root cause, not just the adjustment.
10. MRP, JIT, Kanban and VMI
Material Requirements Planning (MRP)
MRP converts a master production schedule into time-phased material needs using the bill of materials (BOM), inventory records and lead times.
Net requirement = 500 − 200 − 100 = 300 units. With a 2-week lead time, release the order in week 1.
Just-in-time (JIT)
Receive materials only as needed to cut inventory. Needs reliable suppliers and short lead times.
Kanban
Visual pull signals (cards or bins) that trigger replenishment only when material is consumed.
Vendor-managed inventory
The supplier monitors and replenishes the buyer's stock against agreed min and max levels.
Consignment stock
Supplier owns the stock at the buyer's site until it is used.
After recent supply disruptions, many firms blend lean methods with extra buffers for critical items, sometimes called just-in-case inventory.
11. Warehouse and Storage Basics
- Receiving: verify against the PO, inspect, label and record.
- Put-away and slotting: place fast movers near dispatch, heavy items low, hazardous items per regulations.
- Picking methods: discrete, batch, zone and wave picking.
- Storage conditions: temperature, humidity, security and batch or serial traceability.
- Dispatch and returns: accurate documentation and clear returns handling.
- Safety and compliance: follow OSHA (US), HSE (UK), CCOHS (Canada) or Safe Work Australia guidance.
12. Inventory KPIs to Track
Inventory turnover
COGS divided by average inventory.
Days of inventory
How many days current stock would last.
Inventory accuracy
Share of locations where the record matches the count.
Fill rate and stockouts
Demand met from stock and frequency of shortages.
Excess and obsolete (E&O)
Value of slow or dead stock as a percentage of total.
Carrying cost %
Annual holding cost relative to inventory value.
Shrinkage
Loss from theft, damage or error.
Perfect order rate
Orders delivered complete, on time, undamaged and documented correctly.
13. Technology, ERP and SAP MM
- Barcode, QR and RFID capture movements in real time.
- Warehouse management systems (WMS) direct put-away, picking and counts.
- ERP systems integrate inventory with purchasing, production and finance.
- Demand forecasting and AI improve safety stock and reorder parameters.
- IoT sensors monitor condition and location of stock.
In SAP Materials Management (MM), the material master holds item data, and goods receipts, goods issues and transfer postings update stock. For a deeper walkthrough, see the SAP Supply Chain Management guide. Note that older SAP material may reflect SAP R/3-era processes, so check current S/4HANA documentation before applying it.
14. Terminology in the USA, UK, Canada and Australia
| Concept | USA | UK | Canada | Australia |
|---|---|---|---|---|
| Stock held | Inventory | Stock | Inventory | Stock / inventory |
| Physical count | Physical inventory | Stocktake | Inventory count | Stocktake |
| Warehouse worker | Warehouse associate | Warehouse operative | Warehouse associate | Storeperson |
| Accounting basis | US GAAP (LIFO allowed) | IFRS / UK GAAP | IFRS (ASPE for private firms) | AASB (IFRS-based) |
| Professional bodies | ASCM, ISM | CIPS, CILT | SCMA | CIPS, SCLAA |
15. Mini Case Study: Rescuing a Spare-Parts Warehouse
Actions: ABC and criticality analysis, reorder points for A items, min-max for MRO, a vendor-managed arrangement for consumables, cycle counts, and a plan to dispose of obsolete stock.
Illustrative result: fewer stoppages, stock value down about 15%, and record accuracy above 98%.
Student takeaway: combine classification, replenishment rules and record accuracy before buying software.
16. Common Inventory Management Mistakes
- Treating every item the same instead of classifying by value and criticality
- Using stale forecasts and static reorder points
- Ignoring supplier lead time variability
- Letting records drift from physical stock
- Not managing excess and obsolete stock until write-off time
- Cutting inventory without checking service level impact
- Working in silos between procurement, operations, sales and finance
17. Frequently Asked Questions
What is inventory management?
Inventory management is the process of ordering, storing, tracking and controlling stock so an organisation can meet demand at the lowest total cost without running out or overstocking.
What is materials management?
Materials management is the planning, procurement, receiving, storage, movement and control of materials from supplier to point of use. Inventory management is one core part of it.
What is the difference between inventory management and materials management?
Inventory management focuses on stock levels and control. Materials management is broader and also covers planning, purchasing, logistics and material flow.
What is the formula for reorder point?
Reorder point = average daily demand × lead time in days + safety stock.
What is EOQ?
Economic order quantity is the order size that minimises total ordering and holding cost: EOQ = √(2DS / H).
What is ABC analysis in inventory?
ABC analysis ranks items by annual usage value. A items are few but high value, B items are moderate, and C items are many but low value, so control effort is focused on A items.
What is a good inventory turnover ratio?
It depends on the industry. Grocery retailers turn stock many times a year, while heavy equipment makers turn it only a few times. Compare against your own sector and track the trend.
What is the difference between FIFO and LIFO?
FIFO assumes the oldest stock is sold first; LIFO assumes the newest is sold first. LIFO is allowed under US GAAP but not under IFRS.
18. Study Questions and Glossary
2. Compute safety stock and ROP for 95% and 99% service levels (Z = 2.33). What is the extra inventory cost of the higher service level?
3. Rank 10 items by annual usage value and assign ABC classes. Which control rules would you apply to each?
4. Using the valuation example, explain how rising prices affect profit under FIFO vs LIFO.
5. A firm moves from JIT to a hybrid model for critical parts. Discuss the cost and risk trade-offs.
| Term | Meaning |
|---|---|
| BOM | Bill of materials: components needed to make a product |
| COGS | Cost of goods sold |
| E&O | Excess and obsolete inventory |
| FEFO | First expired, first out |
| MRO | Maintenance, repair and operations supplies |
| ROP | Reorder point |
| SKU | Stock keeping unit: a unique item code |
| WIP | Work in process |
Conclusion and Key Takeaways
- Inventory management controls stock; materials management controls the whole material flow.
- Balance ordering, holding and stockout costs rather than minimising any one.
- Use EOQ, safety stock and reorder points, then adjust for real-world variability.
- Classify with ABC analysis to focus effort where value sits.
- Keep records accurate with cycle counts and clear processes.
- Track turnover, accuracy, fill rate and E&O to prove improvement.
Related reading: our Procurement articles, the SAP Supply Chain Management guide and the Inventory Management in SAP article.
inventory managementmaterials managementtypes of inventoryeconomic order quantityreorder point formulasafety stock formulaABC analysisFIFO vs LIFOinventory turnover ratiocycle countingMRPjust in timekanbanvendor managed inventorywarehouse management