5.3 Economic Batch Quantity & Inventory Reorder Levels

Economic Batch Quantity & Inventory Reorder Levels

Core Principle: When an organization manufactures components internally, units enter inventory gradually over a production run rather than arriving instantaneously in a single external delivery. The Economic Batch Quantity (EBQ) accounts for this gradual replenishment, while statistical inventory control levels (Reorder Level, Minimum Level, and Maximum Level) maintain buffer protection under variable lead times and consumption rates.

---

1. Internal Batch Production & Gradual Replenishment

In an external purchasing scenario (EOQ), inventory replenishment is assumed to arrive in a single delivery batch, causing stock levels to jump vertically from zero to $Q$. However, in internal manufacturing, production and consumption occur simultaneously over the duration of the manufacturing run.

                    EOQ vs. EBQ Inventory Profiles
                    
   Instantaneous Replenishment (EOQ)       Gradual Replenishment (EBQ)
   
   Stock Level                            Stock Level
   │                                      │
  Q├───\                                  │         /\ Max Stock = Q(1 - D/R)
   │    \                                 │        /  \ (Production ends;
   │     \                                │       /    \ consumption only)
   │      \                               │      /      \
   │       \                              │     /        \
  0└──────────Time                        │    / (Replenishment R \
                                         0└───/──& Demand D)───────\── Time
                                              |◄─ Run ─►|

Production Rate ($R$) versus Consumption Rate ($D$)

• Annual Demand / Consumption Rate ($D$): The rate at which the completed product is used, assembled, or sold over the year.
• Annual Production / Replenishment Rate ($R$): The manufacturing capacity of the plant if it ran continuously throughout the entire year producing this specific component.
• Mandatory Operational Condition: $R > D$. The production rate must exceed the demand rate; otherwise, inventory would never build up and production would be unable to satisfy demand.

Maximum and Average Stock Under Gradual Replenishment

During a production run of batch size $Q$, the time required to complete the run is $Q / R$ years. During this same time, units are simultaneously being consumed at rate $D$, meaning $Q \times (D / R)$ units are consumed before the run finishes. Therefore, the peak inventory level reached is:

$\mathbf{\text{Maximum Inventory Level} = Q \left(1 - \frac{D}{R}\right)}$

$\mathbf{\text{Average Inventory Level} = \frac{Q}{2} \left(1 - \frac{D}{R}\right)}$

Because $(1 - D/R)$ is less than 1, the average inventory held under gradual replenishment is substantially lower than the average inventory held under instantaneous delivery ($Q/2$).

---

2. The Economic Batch Quantity (EBQ) Model

The Economic Batch Quantity (EBQ) determines the optimal production batch size that balances machine setup costs ($C_o$) against inventory holding costs ($C_h$):

• Setup Cost per Batch ($C_o$): Machine changeover, tooling replacement, calibration, testing runs, and supervisor machine setup wages incurred each time a new production batch begins.
• Holding Cost per Unit per Annum ($C_h$): The carrying cost of storing a completed component in finished stores for one year.

Equating annual setup costs with annual holding costs yields the EBQ formula:

$\mathbf{\text{Annual Setup Cost} = \left(\frac{D}{Q}\right) C_o}$

$\mathbf{\text{Annual Holding Cost} = \frac{Q}{2} \left(1 - \frac{D}{R}\right) C_h}$

$\mathbf{EBQ = \sqrt{\frac{2 C_o D}{C_h \left(1 - \frac{D}{R}\right)}}}$

Key Conceptual Differences: EBQ versus EOQ

---

3. Comprehensive Worked Numerical Example: EBQ Calculation

Precision Components Ltd manufactures sub-assembly Unit-X internally. The production parameters are:

• Annual demand ($D$): 24,000 units
• Annual production capacity ($R$): 60,000 units
• Machine setup cost per batch ($C_o$): $600
• Holding cost per unit per annum ($C_h$): $3.00

Step 1: Calculate the Consumption Ratio and Denominator Factor

$\frac{D}{R} = \frac{24,000}{60,000} = 0.40$

$\left(1 - \frac{D}{R}\right) = 1 - 0.40 = 0.60$

$\text{Adjusted Holding Factor} = C_h \left(1 - \frac{D}{R}\right) = \$3.00 \times 0.60 = \$1.80$

Step 2: Calculate the Economic Batch Quantity (EBQ)

$\text{EBQ} = \sqrt{\frac{2 \times C_o \times D}{C_h \left(1 - \frac{D}{R}\right)}} = \sqrt{\frac{2 \times \$600 \times 24,000}{\$1.80}} = \sqrt{\frac{\$28,800,000}{\$1.80}} = \sqrt{16,000,000} = \mathbf{4,000 \text{ units}}$

Step 3: Verify Cost Equivalence at EBQ

• Number of Production Runs per Year: $\text{Number of Setups} = \frac{D}{\text{EBQ}} = \frac{24,000}{4,000} = 6 \text{ production runs per year}$
• Annual Setup Cost: $\text{Annual Setup Cost} = 6 \times \$600 = \mathbf{\$3,600}$
• Maximum Inventory Level: $\text{Max Stock} = \text{EBQ} \times \left(1 - \frac{D}{R}\right) = 4,000 \times 0.60 = \mathbf{2,400 \text{ units}}$
• Average Inventory Level: $\text{Average Stock} = \frac{\text{Max Stock}}{2} = \frac{2,400}{2} = \mathbf{1,200 \text{ units}}$
• Annual Holding Cost: $\text{Annual Holding Cost} = 1,200 \text{ units} \times \$3.00 = \mathbf{\$3,600}$
• Total Annual Inventory Cost: $$3,600 + $3,600 = \mathbf{$7,200}$

Comparison with EOQ: Had the entity ignored gradual replenishment and applied simple EOQ, the calculated batch size would have been $\sqrt{(2 \times 600 \times 24,000)/3.00} = \sqrt{9,600,000} = 3,098$ units. The EBQ of 4,000 units is larger because concurrent consumption suppresses peak inventory accumulation, allowing the company to run longer batches and save on setup costs.

---

4. Inventory Control Levels Model

When lead times and daily material consumption fluctuate, organizations cannot rely solely on the EOQ formula. To maintain continuous factory operations without holding excessive inventory, organizations establish inventory control levels:

                      Inventory Control Levels Saw-Tooth Chart
                      
   Stock Units
        │
 Max ───┼──────────/\─────────────────────────/\────────── Maximum Level
        │         /  \                       /  \
        │        /    \                     /    \
 ROL ───┼───────/──────\──────▲────────────/──────\─────── Reorder Level (Order Placed)
        │      /        \     │           /        \
        │     /          \    │ Lead     /          \
        │    /            \   │ Time    /            \
 Min ───┼───/──────────────\──▼────────/──────────────\─── Minimum Level (Safety Buffer)
        │  /                \         /                \
        │ /                  \       /                  \
      0 └/────────────────────\─────/────────────────────\── Time

1. Reorder Level (ROL)

The inventory count at which an order requisition must be placed with suppliers to trigger replenishment. It is calibrated to ensure that even if the worst-case scenario occurs (consumption is at its maximum and the supplier takes the maximum delivery time), stock will not run out before goods arrive:

$\mathbf{ROL = \text{Maximum Usage} \times \text{Maximum Lead Time}}$

2. Minimum Level (Buffer Stock / Safety Stock Warning Level)

The inventory buffer threshold below which stock should not fall under normal operational conditions. If physical stock drops below this level, an emergency alert is triggered to investigate consumption spikes or vendor delivery delays:

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

Conceptual Rationale: If an order is triggered at ROL and operations proceed under normal, average conditions, $(Average \times Average)$ units will be consumed before the delivery arrives. The stock balance remaining upon receipt is the Minimum Level.

3. Maximum Level

The upper ceiling that inventory should not exceed under normal operating conditions. It acts as an operational brake to prevent over-stocking, which ties up excessive working capital, strains warehouse capacity, and increases the risk of stock deterioration:

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

Conceptual Rationale: The maximum stock condition occurs if an order is placed at the ROL, replenishment arrives in the shortest possible time (Minimum Lead Time), and factory consumption during that window is at its absolute minimum. When the delivery batch (Reorder Quantity) is unloaded, stock hits this theoretical ceiling.

4. Average Inventory Level Formulas

Depending on the availability of specific safety stock data, average inventory is determined using one of two standard ACCA formulas:

$\mathbf{\text{Standard ACCA Formula: Average Inventory} = \text{Safety Stock (Minimum Level)} + \frac{\text{Reorder Quantity}}{2}}$

$\mathbf{\text{Mid-Point Formula: Average Inventory} = \frac{\text{Minimum Level} + \text{Maximum Level}}{2}}$

Exam Trap: When an ACCA question asks for "Average Inventory" and provides the safety stock (or minimum level) and the reorder quantity, standard exam practice requires using $\text{Safety Stock} + (Q / 2)$. Use the mid-point formula $(\text{Min} + \text{Max}) / 2$ only if the question explicitly requests the mid-point of the control limits or if safety stock cannot be determined directly.

---

5. Comprehensive Worked Multi-Level Inventory Example

Delta Manufacturing Ltd monitors Component SKU-104 for its heavy machinery line. Operational records show the following usage and lead-time parameters:

The established Reorder Quantity (ROQ) is 4,000 units.

Calculation 1: Reorder Level (ROL)

$\text{ROL} = \text{Maximum Usage} \times \text{Maximum Lead Time} = 900 \text{ units/week} \times 5 \text{ weeks} = \mathbf{4,500 \text{ units}}$ (When physical inventory drops to 4,500 units, an order for 4,000 units is triggered).

Calculation 2: Minimum Inventory Level (Buffer Stock)

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

$\text{Minimum Level} = 4,500 - (600 \text{ units/week} \times 3 \text{ weeks}) = 4,500 - 1,800 = \mathbf{2,700 \text{ units}}$

Calculation 3: Maximum Inventory Level

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

$\text{Maximum Level} = 4,500 + 4,000 - (400 \text{ units/week} \times 2 \text{ weeks}) = 8,500 - 800 = \mathbf{7,700 \text{ units}}$

Calculation 4: Average Inventory Level

• Standard Formula: $\text{Average Inventory} = \text{Safety Stock} + \frac{\text{ROQ}}{2} = 2,700 + \frac{4,000}{2} = 2,700 + 2,000 = \mathbf{4,700 \text{ units}}$
• Mid-Point Formula: $\text{Average Inventory} = \frac{\text{Minimum Level} + \text{Maximum Level}}{2} = \frac{2,700 + 7,700}{2} = \frac{10,400}{2} = \mathbf{5,200 \text{ units}}$