4.1 Inventory Records and Control Procedures

4.1 Inventory Records and Control Procedures

Key Concept: Inventory is frequently the single largest current asset appearing on an organization's Statement of Financial Position. Effective inventory control requires robust record-keeping systems, continuous physical verification, and mathematical replenishment controls to ensure production operations run uninterrupted while minimizing the costs of holding stock.

In both manufacturing environments (which manage raw materials, work-in-progress, and finished goods) and retail operations (which purchase finished merchandise for resale), managing inventory represents a fundamental operational challenge. An enterprise that holds excessive inventory locks up cash flow, occupies expensive warehouse space, and risks physical deterioration, theft, or obsolescence. Conversely, an enterprise that holds insufficient inventory faces stockouts, catastrophic assembly line shutdowns, lost commercial sales, and emergency replenishment at premium spot prices.

To balance these competing risks, cost accountants design and operate structured inventory control systems governed by rigorous documentation, clear segregation of duties, and systematic replenishment levels.

---

1. Strategic Role of Inventory Control

Inventory control is the systematic management of the ordering, storage, and consumption of goods. The overarching financial objective is to minimize total inventory-related expenditure while guaranteeing adequate material availability.

Total inventory expenditure consists of three competing cost categories:

1. Holding (Carrying) Costs: The cumulative expenditure incurred by retaining unsold or unconsumed items in storage over time. These include warehouse rent, municipal business rates, climate control and lighting, security personnel, handling labour, insurance premiums, physical deterioration, product obsolescence, and the opportunity cost of capital tied up in stock (interest foregone or overdraft interest paid).
2. Ordering (Procurement) Costs: The administrative and logistical expenses incurred each time a purchase order is placed with a supplier. These include purchase requisition processing, vendor negotiation, purchase order generation, clerical invoice verification, delivery transport charges, goods receiving dock labour, and quality inspection testing.
3. Stockout (Depletion) Costs: The financial penalties suffered when inventory is exhausted. In manufacturing, a stockout causes idle production workers, machine downtime, disrupted production schedules, and contractual delivery penalties. In retail, it causes immediate lost profit margins and enduring brand damage when frustrated customers migrate to competitors.

+-------------------------------------------------------------+
|                 THE INVENTORY BALANCING ACT                 |
+------------------------------+------------------------------+
|     RISKS OF OVER-STOCKING   |    RISKS OF UNDER-STOCKING   |
+------------------------------+------------------------------+
| - High warehouse storage rent| - Production line stoppages  |
| - Working capital locked up  | - Idle factory operatives    |
| - Increased insurance costs  | - Lost sales and client trust|
| - Spoilage and evaporation   | - Premium spot-order charges |
| - Obsolescence and scrap     | - Expensive rush freight fees|
+------------------------------+------------------------------+

---

2. Bin Cards vs Stores Ledger Accounts

Section 2.3 compares the two records in detail. In short, the bin card is kept in the stores by the storekeeper and records quantities only, while the stores ledger account is kept by the costing or finance team and records quantities and values, priced using FIFO, LIFO or AVCO (Sections 4.2 and 4.3). Because different people keep them, comparing the two records with each other, and with a physical count, is a basic control over inventory:

• A difference between the bin card and the physical count points to a physical problem, such as theft, damage or an unrecorded issue.
• A difference between the bin card and the stores ledger account points to a recording problem, such as a missed or misposted document.
• Keeping the two records with different people (segregation of duties) means one person cannot both remove inventory and hide the loss in the records.

---

3. Stocktaking Procedures: Periodic vs Perpetual Inventory

To ensure that recorded inventory balances correspond to physical reality, organizations conduct physical stock checks (stocktaking). The two primary methodologies are periodic inventory counting and perpetual inventory counting.

Periodic Inventory Count

A periodic inventory count involves counting, weighing, or measuring every item of inventory held across the organization at a single, designated point in time—typically on the final day of the financial accounting year or quarter:

• Operational Disruption: Conducting a periodic stocktake usually requires halting factory production and closing warehouse dispatch operations for one or two full days. Staff spend long shifts counting thousands of physical items.
• Limitations: Periodic stocktaking creates significant operational bottlenecks. Because counting occurs only once or twice a year, inventory discrepancies (such as theft, shrinkage, or clerical mispostings) remain undetected for months. Furthermore, if discrepancies are discovered at year-end, it is almost impossible to identify the root cause or pinpoint when the loss occurred.

Perpetual Inventory (Continuous Stocktaking)

A perpetual inventory system is a method of continuous counting where stocktaking is performed on an ongoing basis throughout the working year. Rather than counting everything at once, warehouse staff count a predetermined selection of inventory items every day or week:

• Routine Integration: Specialized inventory counting staff systematically count several product lines each morning. Over the course of the year, every stock item is physically counted at least once, and high-value items are counted multiple times.
• Operational Continuity: Production and warehouse dispatch operations proceed uninterrupted. There is no need for costly factory shutdowns.
• Rapid Discrepancy Detection: Differences between the physical count and the book balance are identified immediately, allowing management to investigate losses, update security, and correct administrative errors in real time.

The ABC Inventory Classification System

To optimize perpetual stocktaking effort, organizations apply the Pareto Principle (80/20 rule) through ABC Analysis, categorizing inventory items based on their annual monetary usage value (Annual Quantity × Unit Cost):

+-------------------------------------------------------------+
|                      ABC CLASSIFICATION                     |
+-------------------------------------------------------------+
| [Class A Items: 10% of items, 75% of value] -> Strict Daily |
| [Class B Items: 25% of items, 15% of value] -> Monthly Check|
| [Class C Items: 65% of items, 10% of value] -> Annual Check |
+-------------------------------------------------------------+

---

4. Inventory Discrepancies and Control Procedures

When a physical count is conducted, the quantity physically counted must be compared against the recorded book balance in the stores ledger and bin card. When the two figures diverge, an inventory discrepancy exists.

Common Causes of Inventory Discrepancies

1. Physical Shrinkage and Evaporation: Natural loss of volume or weight in commodities such as volatile chemicals, fuel, timber seasoning, or grain.
2. Deterioration and Spoilage: Perishable food ingredients or temperature-sensitive chemicals that degrade past their expiry date and are discarded without formal recording.
3. Theft and Pilferage: Unauthorized removal of high-value, portable components or tools by staff or external intruders.
4. Clerical and Misposting Errors: Recording an issue against the wrong stock code (e.g., issuing component SKU #104 but recording SKU #105), duplicating a Goods Received Note, or transposing digits (e.g., recording 48 units instead of 84).
5. Unrecorded Issues or Transfers: Urgent factory requisitions taken from stores during night shifts without completing a formal Stores Requisition Note.
6. Mismatched Units of Measure: Receiving goods in bulk boxes of 50 units but recording them in stores as individual units.

Accounting Treatment of Discrepancies

Discrepancies cannot simply be ignored; accounting standards require the book balance to be adjusted to reflect the verified physical reality:

1. Investigation: Discrepancies exceeding a defined materiality threshold are investigated by checking recent delivery notes, requisitions, and bin cards for arithmetic errors.
2. Inventory Adjustment Note: An authorized Inventory Adjustment Note is raised to document the write-off or write-on.
3. Ledger Adjustment (Shortage): If a physical shortage exists (physical count < book balance):
   • Credit: Stores Ledger Control Account (reducing the inventory asset balance).
   • Debit: Inventory Shrinkage / Write-Off Account (expensed as a production overhead if normal shrinkage, or charged to profit or loss as an abnormal loss if catastrophic theft or flood damage).
4. Ledger Adjustment (Surplus): If a physical surplus exists (physical count > book balance):
   • Debit: Stores Ledger Control Account (increasing the inventory asset balance).
   • Credit: Inventory Adjustment / Overheads Account.

---

5. Inventory Control Levels and Mathematical Formulas

To prevent both stockouts and excessive inventory accumulation, cost accountants establish predetermined inventory control levels. PCTN tasks normally give you these levels as company policy. Knowing how they are set helps you judge whether the policy has been followed (Section 6 below). These mathematical limits act as automated triggers for warehouse and procurement staff.

Inventory (Units)
  ^
  |    [MAXIMUM LEVEL] ---------------------------- (Ceiling limit)
  |
  |
  |    [REORDER LEVEL] ---------------------------- (Place new order)
  |         \        /
  |          \      /
  |           \    /
  |    [MINIMUM LEVEL] ---------------------------- (Buffer / Safety Stock)
  |            \  /
  |             \/
  |    [ZERO STOCK]   ---------------------------- (Stockout Danger)
  +--------------------------------------------------------> Time

Key Operational Variables

Calculating inventory control levels requires four foundational operational parameters:

• Maximum Usage: The highest number of units consumed by operations in a single day or week.
• Minimum Usage: The lowest number of units consumed by operations in a single day or week.
• Average Usage: The normal, expected rate of consumption per period: $\frac{\text{Maximum Usage} + \text{Minimum Usage}}{2}$.
• Maximum Lead Time: The longest anticipated delivery period between placing an order with a supplier and the goods arriving in stores.
• Minimum Lead Time: The quickest delivery time under ideal vendor conditions.
• Average Lead Time: The normal, expected delivery period: $\frac{\text{Maximum Lead Time} + \text{Minimum Lead Time}}{2}$.
• Reorder Quantity (ROQ): The fixed, pre-agreed batch quantity ordered each time replenishment is triggered.

The Formulas

1. Reorder Level (ROL)

The inventory level at which a new purchase order must be placed. It is set prudently so that if usage is at its maximum and the supplier takes the maximum delivery time, stock will not run out before the new delivery arrives:

$\text{Reorder Level (ROL)} = \text{Maximum Usage} \times \text{Maximum Lead Time}$

2. Minimum Level (Buffer Stock / Safety Stock)

The lowest operational threshold below which stock should not normally fall. It acts as an emergency safety cushion protecting against unexpected demand surges or delivery delays:

$\text{Minimum Level} = \text{Reorder Level} - (\text{Average Usage} \times \text{Average Lead Time})$

3. Maximum Level

The upper ceiling threshold above which inventory must not rise. Exceeding this level signals wasteful over-ordering, excessive storage costs, and tied-up working capital:

$\text{Maximum Level} = \text{Reorder Level} + \text{Reorder Quantity (ROQ)} - (\text{Minimum Usage} \times \text{Minimum Lead Time})$

4. Average Inventory Level

The normal, expected quantity of inventory residing in the business throughout the year:

$\text{Average Inventory} = \text{Minimum Level} + \frac{\text{Reorder Quantity}}{2}$

(Alternatively, in certain assessments: $\frac{\text{Minimum Level} + \text{Maximum Level}}{2}$).

---

6. Checking Compliance with an Inventory Control Policy

The PCTN specification (learning outcome 2.1.3) asks you to analyse and report on inventory control policy compliance, including buffer stocks and reorder quantities and timings. In these tasks the organisation's policy is given to you. Your job is to check the inventory record against it and report what went wrong, not to invent new control levels.

Worked Example: Moorland Paints Ltd

Moorland Paints Ltd's policy for tin lids is:

• Buffer stock (minimum level): 400 lids must always be held.
• Reorder level: an order must be placed on the same day that inventory falls to 1,000 lids or below.
• Reorder quantity: 1,500 lids per order.

The inventory record for May shows:

Analysis Against Each Part of the Policy

Report to the stores or purchasing manager: the late order on 13 May is the likely reason inventory fell below the buffer on 18 May, which put production at risk of a stockout. Orders must be raised on the day the reorder level is reached. The reorder quantity was correct.

---

7. Background Beyond PCTN: The Economic Order Quantity (EOQ)

When determining the Reorder Quantity (ROQ), management seeks an order size that minimizes total inventory costs. This optimal replenishment batch is known as the Economic Order Quantity (EOQ).

The Cost Trade-off

As the size of each replenishment order increases:

• Total Annual Ordering Costs Decrease: Fewer orders are placed per year (Annual Demand $\div$ Order Size), reducing purchase order administration, transport, and delivery dock processing.
• Total Annual Holding Costs Increase: Larger orders mean higher average inventory held in the warehouse, increasing storage, insurance, and interest costs.

Annual Cost (£)
  ^
  |        \                                 /  Total Inventory Cost
  |         \     Total Annual Cost         /   (Holding + Ordering)
  |          \            __--*--__        /
  |           \       _--'         '--_   /
  |            \   _--                 --/
  |             \-'                       /-- Annual Holding Cost
  |             /\                       /    (Rises with order size)
  |            /  \                     /
  |           /    \                   /
  |          /      \_                /
  |         /         '--__          /  Annual Ordering Cost
  |        /               '--______/   (Falls with order size)
  +-------+-------------------------+-------------------------> Order Size (Q)
          |                         |
          0                        EOQ (Costs Intersect & Total Minimized)

The EOQ Formula

Mathematically, the total cost curve reaches its absolute minimum at the exact point where Total Annual Holding Costs equal Total Annual Ordering Costs:

$\text{EOQ} = \sqrt{\frac{2 \times C_o \times D}{C_h}}$

Where:

• $D$ = Annual Demand for the inventory item (units per annum)
• $C_o$ = Fixed Cost of placing one replenishment order (£ per order)
• $C_h$ = Cost of holding one unit in inventory for one full year (£ per unit per year)

---

8. Worked Example: Calculating Control Levels at Pennine Hydraulic Components Ltd

To see these control principles in practice, consider Pennine Hydraulic Components Ltd, a precision engineering firm based in Sheffield manufacturing hydraulic cylinders. The firm uses a specialized brass valve component (Component C-82). The cost accounting records reveal the following operating parameters:

• Maximum daily usage: 140 units
• Minimum daily usage: 60 units
• Average daily usage: 100 units
• Maximum supplier lead time: 15 business days
• Minimum supplier lead time: 5 business days
• Average supplier lead time: 10 business days
• Reorder Quantity (ROQ): 1,200 units
• Annual Demand ($D$): 25,000 units
• Cost per order ($C_o$): £60.00
• Holding cost per unit per year ($C_h$): £3.00

Step 1: Calculate Reorder Level (ROL)

$\text{ROL} = \text{Maximum Usage} \times \text{Maximum Lead Time} = 140 \text{ units/day} \times 15 \text{ days} = \mathbf{2,100 \text{ units}}$ Interpretation: When the physical stock in the Sheffield warehouse falls to 2,100 units, the storekeeper raises an immediate purchase requisition for replenishment.

Step 2: Calculate Minimum Level (Buffer Stock)

$\text{Minimum Level} = \text{ROL} - (\text{Average Usage} \times \text{Average Lead Time})$ $\text{Minimum Level} = 2,100 - (100 \times 10) = 2,100 - 1,000 = \mathbf{1,100 \text{ units}}$ Interpretation: In a normal delivery cycle, 1,000 units will be consumed during the 10-day lead time. The remaining 1,100 units act as an emergency cushion against delivery delays or production spikes.

Step 3: Calculate Maximum Level

$\text{Maximum Level} = \text{ROL} + \text{ROQ} - (\text{Minimum Usage} \times \text{Minimum Lead Time})$ $\text{Maximum Level} = 2,100 + 1,200 - (60 \times 5) = 3,300 - 300 = \mathbf{3,000 \text{ units}}$ Interpretation: If stock hits 2,100 units, an order of 1,200 units is placed. In the best-case scenario (minimum usage of 60 units/day and fastest lead time of 5 days), only 300 units are consumed before delivery arrives. Physical inventory will reach 3,000 units. Any level above 3,000 indicates over-stocking.

Step 4: Calculate Average Inventory Level

$\text{Average Inventory} = \text{Minimum Level} + \frac{\text{ROQ}}{2} = 1,100 + \frac{1,200}{2} = 1,100 + 600 = \mathbf{1,700 \text{ units}}$

Step 5: Evaluate the Economic Order Quantity (EOQ)

Management wishes to assess whether the existing ROQ of 1,200 units is financially optimal:

$\text{EOQ} = \sqrt{\frac{2 \times 60 \times 25,000}{3.00}} = \sqrt{\frac{3,000,000}{3.00}} = \sqrt{1,000,000} = \mathbf{1,000 \text{ units}}$

Financial Comparison:

• Existing Policy (ROQ = 1,200 units):
  • Annual Ordering Cost: $\frac{25,000}{1,200} \times £60 = 20.833 \times £60 = £1,250.00$
  • Annual Holding Cost: $\frac{1,200}{2} \times £3.00 = 600 \times £3.00 = £1,800.00$
  • Total Annual Cost: £1,250.00 + £1,800.00 = £3,050.00
• Optimal Policy (EOQ = 1,000 units):
  • Annual Ordering Cost: $\frac{25,000}{1,000} \times £60 = 25 \times £60 = £1,500.00$
  • Annual Holding Cost: $\frac{1,000}{2} \times £3.00 = 500 \times £3.00 = £1,500.00$
  • Total Annual Cost: £1,500.00 + £1,500.00 = £3,000.00

Notice that at the EOQ of 1,000 units, annual holding cost equals annual ordering cost (£1,500 = £1,500), saving Pennine Hydraulic Components £50.00 per year while reducing working capital commitment.

---

9. Common Exam Pitfalls and Technical Traps

AAT's review of the October 2023 examiner reports listed labour and inventory calculations among the weaker PCTN tasks. Watch out for these traps:

• Trap 1: Confusing Bin Cards with Stores Ledger Accounts. Remember that bin cards are kept in the warehouse and record physical quantities only (never monetary pounds and pence). Stores ledger accounts are kept in the finance office and record both quantities and values.
• Trap 2: Mixing Up Usage and Lead Time Parameters.
  • For Reorder Level, always multiply Maximum usage by Maximum lead time.
  • For Minimum Level, always deduct Average usage multiplied by Average lead time from ROL.
  • For Maximum Level, always deduct Minimum usage multiplied by Minimum lead time from (ROL + ROQ).
• Trap 3: Forgetting to Add the ROQ in the Maximum Level Formula. A common error is calculating $\text{ROL} - (\text{Min Usage} \times \text{Min Lead Time})$ and forgetting to add the incoming replenishment batch (ROQ).
• Trap 4: Recalculating Instead of Checking the Policy. PCTN compliance tasks give you the policy (buffer stock, reorder level, reorder quantity). Test each order against that policy, covering whether it was placed on time and for the right quantity and whether the buffer was breached, rather than inventing new control levels.