4.3 AVCO Inventory Valuation and Method Comparison

4.3 AVCO Inventory Valuation and Method Comparison

Key Concept: The Weighted Average Cost (AVCO) method eliminates the extremes of FIFO and LIFO by recalculating a blended, weighted unit cost whenever new inventory is delivered. It smooths price volatility, avoids tracking multiple discrete price batches, and complies fully with statutory accounting standards.

While FIFO and LIFO represent chronological extremes—assuming either the oldest or newest stock is consumed first—the Average Cost (AVCO) method adopts an egalitarian approach. It assumes that once goods are placed into stores, they merge into an undifferentiated pool of resources. Every unit drawn from that pool carries an identical, average cost.

AVCO is particularly prevalent in modern computerised ERP environments where continuous recalculation is automated, and in process industries (such as oil refining, chemical production, brewing, and grain storage) where physical batches literally blend together.

---

1. Continuous (Cumulative) Weighted Average Cost Mechanics

In perpetual stores ledger accounting, the standard method examined is the Continuous (Cumulative) Weighted Average. Under this method, a new weighted average unit rate is calculated immediately after each new delivery of stock.

+-------------------------------------------------------------+
|                 CONTINUOUS AVCO GOLDEN RULE                 |
+-------------------------------------------------------------+
| - The average unit cost changes ONLY when a NEW DELIVERY    |
|   arrives at a different purchase price.                    |
| - ISSUES to production do NOT change the unit cost!         |
|   Issues simply reduce quantity and total value at the      |
|   prevailing average rate.                                  |
+-------------------------------------------------------------+

The Weighted Average Cost Formula

Whenever a new delivery arrives, the new unit cost is established as follows:

$\text{New Weighted Average Unit Cost} = \frac{\text{Monetary Value of Stock on Hand} + \text{Monetary Value of New Delivery}}{\text{Physical Quantity of Stock on Hand} + \text{Physical Quantity of New Delivery}}$

Rounding Conventions

Weighted average unit costs often produce recurring decimals (such as £10.6666...). Always follow the rounding instruction in the task:

• Unit prices are typically rounded to two decimal places (e.g., £10.67) or four decimal places (e.g., £10.6667) for intermediate calculations.
• In stores ledger tables, the final closing monetary balance is reconciled to prevent cumulative rounding discrepancies.

---

2. Comprehensive Worked Stores Ledger Account: Pennine Precision Engineering Ltd (AVCO)

To allow a direct, seamless comparison with FIFO and LIFO, we apply the Continuous AVCO method to the exact same dataset for Pennine Precision Engineering Ltd (Component Batch RM-40) from Section 4.2:

• Oct 1: Opening Balance: 100 units @ £10.00 = £1,000.00
• Oct 5: Purchase (GRN-401): 200 units @ £11.00 = £2,200.00
• Oct 10: Issue to Production (SR-210): 150 units
• Oct 18: Purchase (GRN-442): 250 units @ £12.00 = £3,000.00
• Oct 24: Issue to Production (SR-255): 200 units

The AVCO Stores Ledger Table

Detailed Mathematical Commentary

1. Oct 5 Purchase Recalculation:
   • Value on hand before delivery: £1,000.00 (100 units)
   • Value of new delivery: £2,200.00 (200 units)
   • Combined value = £1,000.00 + £2,200.00 = £3,200.00
   • Combined quantity = 100 + 200 = 300 units
   • New Weighted Average Rate: $\frac{£3,200.00}{300 \text{ units}} = \mathbf{£10.6667 \text{ per unit}}$ (or £10.67 rounded).
2. Oct 10 Issue (150 units):
   • Issued at the prevailing weighted average rate of £10.6667.
   • Issue cost = $150 \times £10.666667 = \mathbf{£1,600.00}$.
   • Remaining balance = $150 \text{ units} \times £10.666667 = \mathbf{£1,600.00}$. Notice that the unit price remains unchanged at £10.6667.
3. Oct 18 Purchase Recalculation:
   • Value on hand before delivery: £1,600.00 (150 units)
   • Value of new delivery: £3,000.00 (250 units)
   • Combined value = £1,600.00 + £3,000.00 = £4,600.00
   • Combined quantity = 150 + 250 = 400 units
   • New Weighted Average Rate: $\frac{£4,600.00}{400 \text{ units}} = \mathbf{£11.50 \text{ per unit}}$ exactly.
4. Oct 24 Issue (200 units):
   • Issued at the prevailing weighted average rate of £11.50.
   • Issue cost = $200 \times £11.50 = \mathbf{£2,300.00}$.
   • Remaining closing balance = $200 \text{ units} \times £11.50 = \mathbf{£2,300.00}$.
5. Oct 31 Final Reconciliation:
   • Total Cost of Issues: £1,600.00 + £2,300.00 = £3,900.00
   • Closing Inventory Valuation: 200 units @ £11.50 = £2,300.00
   • Total Value Accounted For: £3,900.00 + £2,300.00 = £6,200.00 (matches total goods available).

---

3. Continuous AVCO vs Periodic AVCO

It is essential to distinguish between Continuous AVCO (used in perpetual stores ledgers) and Periodic AVCO (sometimes used in periodic financial accounting).

The Periodic AVCO Method

In Periodic AVCO, no calculations take place during the month. Instead, management waits until the end of the accounting period, aggregates all receipts and opening stock, and calculates a single uniform weighted average unit cost across the entire period:

$\text{Periodic Average Rate} = \frac{\text{Opening Stock Value} + \text{Total Purchases Value}}{\text{Opening Stock Quantity} + \text{Total Purchases Quantity}}$

Applying Periodic AVCO to Pennine Precision's October figures:

• Total available quantity = 100 + 200 + 250 = 550 units
• Total available cost = £1,000 + £2,200 + £3,000 = £6,200.00
• Periodic Weighted Average Rate: $\frac{£6,200.00}{550 \text{ units}} = \mathbf{£11.2727 \text{ per unit}}$
• Cost of 350 units issued: $350 \times £11.2727 = \mathbf{£3,945.45}$
• Closing Inventory (200 units): $200 \times £11.2727 = \mathbf{£2,254.55}$

Key Procedural Contrast

In practical business, Continuous AVCO is overwhelmingly preferred because pricing an issue on 10 October using a purchase cost that was not agreed or delivered until 18 October is illogical and impractical for ongoing management decisions.

---

4. Comprehensive Comparative Synthesis: FIFO vs LIFO vs AVCO

Having calculated the exact figures for Pennine Precision Engineering Ltd across all three methods, we can now present the definitive comparative synthesis. This table summarises how the three methods compare:

+-------------------------------------------------------------+
|            INFLATIONARY IMPACT SPECTRUM (PRICES RISING)      |
+-------------------------------------------------------------+
| Cost of Issues:      FIFO (£3,800) < AVCO (£3,900) < LIFO (£4,050) |
| Closing Inventory:   LIFO (£2,150) < AVCO (£2,300) < FIFO (£2,400) |
| Reported Profit:     LIFO (Lowest) < AVCO (Medium) < FIFO (Highest) |
+-------------------------------------------------------------+

---

5. Management Decision Matrix

Why does a management accountant select one method over another for internal costing and pricing? The following decision matrix summarizes managerial selection criteria:

---

6. Common Exam Pitfalls and Calculation Traps

• Trap 1: Recalculating Unit Cost on an Issue. This is the single most common error in AVCO questions! An issue of inventory never changes the weighted average unit price. If you have 300 units @ £10.6667 and issue 150 units, the remaining 150 units are still valued at £10.6667. The unit price only changes when a new delivery arrives at a different price.
• Trap 2: Calculating a Simple Arithmetic Average. Never average the unit prices directly (e.g., $\frac{£10.00 + £11.00 + £12.00}{3} = £11.00$). You must calculate a weighted average based on the total monetary cost divided by the total physical units.
• Trap 3: Premature Rounding. If an intermediate unit cost produces a recurring decimal, keep at least four decimal places in your calculator or working memory. Rounding to two decimal places prematurely introduces substantial discrepancies in final inventory valuations.
• Trap 4: Forgetting that AVCO is Permitted Externally. Some candidates mistakenly believe that because AVCO recalculates costs continuously, it is an internal-only method. Both FIFO and AVCO are fully permitted and recognized under IAS 2 and FRS 102.