3.1 Material Costs and Inventory Valuation

3.1 Material Costs and Inventory Valuation

Materials constitute a major proportion of total production expenditure in manufacturing, retail, and construction businesses. Effective material management ensures that production operations run smoothly without interruption, while preventing excessive working capital from being tied up in stock. In the AAT Level 3 Management Accounting Techniques (MATS) syllabus, candidates must understand material procurement procedures, calculate key inventory control levels, determine the Economic Order Quantity (EOQ), and accurately value inventory using the FIFO and AVCO methods assessed under Q2022.

---

The Material Procurement and Control Cycle

To safeguard company assets, material procurement follows a structured documentation process that creates a clear accounting audit trail:

1. Material Requisition Note: Issued by a production department supervisor to request raw materials from the central storehouse.
2. Purchase Requisition Note: Sent by the storekeeper to the purchasing/procurement department when stock falls to the Reorder Level.
3. Purchase Order (PO): Sent by purchasing to an approved external supplier, specifying material descriptions, quantities, agreed prices, and delivery terms.
4. Goods Received Note (GRN): Completed by the goods receiving department upon delivery, confirming physical quantities and inspecting item condition.
5. Goods Delivery Note (GDN) / Delivery Advice: Supplied by the vendor; checked against the GRN and Purchase Order.
6. Invoice Matching: The finance department matches the supplier invoice against the PO and GRN before authorizing payment.
7. Materials Issued Note: Documents the transfer of materials from the storehouse to specific production jobs or cost centres.

---

Inventory Control Levels

Management accountants establish predefined control levels to balance the risk of stockouts (running out of raw materials) against the high costs of holding excess inventory (storage rent, insurance, deterioration, obsolescence, and tied-up capital).

  +-------------------------------------------------------------+  <-- Maximum Stock Level
  |                                                             |
  |   ~~~~~~~~~~~~~~~~ Usage During Lead Time ~~~~~~~~~~~~~~~   |
  |                                                             |
  +-------------------------------------------------------------+  <-- Reorder Level (ROL)
  |                                                             |
  |   ================ Safety / Buffer Stock ================   |
  |                                                             |
  +-------------------------------------------------------------+  <-- Minimum Stock Level
  |                                                             |  <-- Zero Stock (Stockout)

Core Control Level Formulas

$\text{Buffer Inventory} = \text{Re-order Level} - (\text{Average Usage} \times \text{Average Lead Time})$ $\text{Re-order Level (ROL)} = (\text{Average Usage} \times \text{Average Lead Time}) + \text{Buffer Inventory}$ $\text{Maximum Inventory Level} = \text{Buffer Inventory} + \text{Maximum Re-order Quantity}$ $\text{Maximum Re-order Quantity} = \text{Maximum Inventory Level} - \text{Buffer Inventory}$ $\text{Minimum Re-order Quantity} = \text{Average Usage} \times \text{Average Lead Time}$ $\text{Average Inventory Level} = \text{Buffer Inventory} + \left(\frac{\text{Re-order Quantity}}{2}\right)$

AAT Q2022 assessment rule: These are the inventory control formulas printed in the AAT unit specification. In the assessment you will be given either the buffer inventory or the re-order level (and either the maximum inventory level or the maximum re-order quantity) and asked to derive the other value.

• Lead Time: The time delay between placing a purchase order with a supplier and receiving the physical materials in the storehouse.
• Reorder Quantity (ROQ): The standard batch quantity ordered each time a purchase order is raised.

---

Economic Order Quantity (EOQ)

Setting the reorder batch size requires balancing two opposing categories of costs:

• Ordering Costs ($C_o$): Fixed costs incurred every time an order is placed (e.g., administrative processing, transport, inspection costs). Total annual ordering costs decrease as order batch size increases.
• Holding Costs ($C_h$): Costs of storing inventory per unit per year (e.g., warehouse rent, insurance, heating, security, deterioration, cost of capital). Total annual holding costs increase as order batch size increases.

The Economic Order Quantity (EOQ) is the exact purchase order quantity that minimizes the total annual cost of ordering and holding inventory.

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

Where:

• $D$ = Annual Demand in units
• $C_o$ = Fixed Cost per Purchase Order
• $C_h$ = Holding Cost per Unit per Annum

Total Annual Inventory Cost Equation

$\text{Total Annual Cost} = \text{Annual Purchase Cost} + \text{Annual Ordering Costs} + \text{Annual Holding Costs}$ $\text{Total Annual Cost} = (D \times P) + \left(\frac{D}{Q} \times C_o\right) + \left(\frac{Q}{2} \times C_h\right)$ (where $P$ = purchase price per unit, $Q$ = batch order quantity)

Worked Example: EOQ and Control Levels

Scenario: Apex Engineering consumes 12,000 units of Component X per year. Fixed cost per order is £50, and annual holding cost is £3 per unit. Component usage ranges from 200 to 300 units per week, and supplier lead time ranges from 2 to 4 weeks. (Assume 50 working weeks per year; Average usage = 240 units/week; Average lead time = 3 weeks; Buffer inventory = 480 units).

Calculations:

1. EOQ: $EOQ = \sqrt{\frac{2 \times 50 \times 12,000}{3}} = \sqrt{\frac{1,200,000}{3}} = \sqrt{400,000} = 632.46 \approx 632 \text{ units}$
2. Re-order Level (ROL): $\text{ROL} = (\text{Average Usage} \times \text{Average Lead Time}) + \text{Buffer} = (240 \times 3) + 480 = 720 + 480 = 1,200 \text{ units}$
3. Maximum Inventory Level (using EOQ as the maximum re-order quantity = 632 units): $\text{Maximum Level} = \text{Buffer} + \text{Max ROQ} = 480 + 632 = 1,112 \text{ units}$
4. Minimum Re-order Quantity: $\text{Minimum ROQ} = \text{Average Usage} \times \text{Average Lead Time} = 240 \times 3 = 720 \text{ units}$

---

Inventory Valuation Methods (FIFO and AVCO)

When units of raw materials are purchased at varying prices over time, management accountants must determine which price to assign to materials issued to production, and which price to assign to closing inventory remaining in stores.

Note on LIFO: Last-In-First-Out is prohibited for statutory financial reporting under IAS 2 / FRS 102 and was removed from the AAT syllabus under Q2022 — only FIFO and AVCO are assessed in MATS.

Worked Example: Perpetual Inventory Valuation

Transactions for Item Z during August:

• Aug 1: Opening balance 100 units @ £10/unit (£1,000)
• Aug 5: Purchased 200 units @ £12/unit (£2,400)
• Aug 12: Issued 150 units to production
• Aug 20: Purchased 100 units @ £15/unit (£1,500)
• Aug 25: Issued 120 units to production

1. FIFO Method Calculation

• Aug 12 Issue (150 units): 100 units @ £10 (£1,000) + 50 units @ £12 (£600) = £1,600.
  • Remaining stock: 150 units @ £12 (£1,800).
• Aug 20 Receipt: 100 units @ £15 (£1,500).
  • Remaining stock: 150 units @ £12 + 100 units @ £15 = 250 units (£3,300).
• Aug 25 Issue (120 units): 120 units @ £12 = £1,440.
  • Remaining closing stock: 30 units @ £12 (£360) + 100 units @ £15 (£1,500) = 130 units valued at £1,860.
• Total Material Issue Cost: £1,600 + £1,440 = £3,040.

2. Continuous AVCO Method Calculation

• Aug 1: 100 units @ £10.00 = £1,000.
• Aug 5 Receipt: Add 200 units @ £12.00 (£2,400). Total = 300 units @ £3,400. New average rate = $\frac{\pounds 3,400}{300} = \mathbf{\pounds 11.3333/unit}$.
• Aug 12 Issue (150 units): 150 units @ £11.3333 = £1,700.
  • Remaining stock: 150 units @ £11.3333 = £1,700.
• Aug 20 Receipt: Add 100 units @ £15.00 (£1,500). Total = 250 units @ £3,200. New average rate = $\frac{\pounds 3,200}{250} = \mathbf{\pounds 12.80/unit}$.
• Aug 25 Issue (120 units): 120 units @ £12.80 = £1,536.
  • Remaining closing stock: 130 units @ £12.80 = £1,664.
• Total Material Issue Cost: £1,700 + £1,536 = £3,236.

---

AAT Exam Traps and Practical Decision Rules

Exam Trap 1 — Mixing Lead Time Units: Always verify whether lead time and material usage are stated in days, weeks, or months. If usage is per week, lead time must be expressed in weeks.

Exam Trap 2 — Periodic vs Perpetual AVCO: Under perpetual AVCO (the standard for AAT assessment), the weighted average price is recalculated immediately after each new purchase receipt. Do not wait until month-end to calculate a single periodic average unless explicitly directed.

Exam Trap 3 — Holding Cost Bases: Holding cost ($C_h$) is often given as a percentage of purchase price (e.g., 15% of £20/unit = £3.00/unit/year). Make sure to convert percentages into absolute monetary figures per unit per year before substituting into the EOQ formula.