5.2 Economic Order Quantity & Bulk Purchase Discounts

Economic Order Quantity & Bulk Purchase Discounts

Core Principle: Inventory management involves balancing opposing economic forces: placing large, infrequent orders drives down administrative procurement costs but increases warehouse holding expenses. The Economic Order Quantity (EOQ) identifies the order size that achieves the lowest total inventory cost, while quantity discount evaluations determine whether vendor price reductions justify exceeding this baseline.

---

1. The Cost Components of Inventory

Managing inventory incurs three primary categories of expenditure, each exhibiting distinct cost behaviours:

                         ┌─────────────────────────────────┐
                         │   Total Annual Inventory Cost   │
                         └────────────────┬────────────────┘
                                          │
          ┌───────────────────────────────┼───────────────────────────────┐
          ▼                               ▼                               ▼
┌───────────────────┐           ┌───────────────────┐           ┌───────────────────┐
│   Purchase Cost   │           │   Ordering Cost   │           │   Holding Cost    │
│ • Unit price × D  │           │ • Purchase orders │           │ • Capital cost    │
│ • Bulk discounts  │           │ • Goods receiving │           │ • Warehouse rent  │
│ • Freight-in      │           │ • Invoice matching│           │ • Insurance & loss│
└───────────────────┘           └───────────────────┘           └───────────────────┘

1. Purchase Costs

The direct invoice expenditure incurred to acquire raw materials from external suppliers:

$$\text{Annual Purchase Cost} = D \times P$$

Where $D$ is the total annual demand in units, and $P$ is the purchase price per unit. If no quantity discounts exist, annual purchase cost is fixed regardless of order batch size.

2. Ordering (Procurement) Costs ($C_o$)

Fixed administrative and handling costs incurred every time a purchase order is placed, irrespective of order size. Ordering costs include:

• Administrative time spent preparing, authorizing, and dispatching the purchase order.
• Receiving bay staff time spent inspecting, counting, and unloading the delivery.
• Quality assurance lab testing and certification fees.
• Accounts payable clerical processing (matching purchase orders, GRNs, and supplier invoices).

If order quantity is $Q$ units, the number of orders placed annually is $D / Q$:

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

Cost Behaviour: As order size $Q$ increases, fewer orders are placed, causing total annual ordering costs to fall hyperbolically.

3. Holding (Carrying) Costs ($C_h$)

Costs incurred to store, safeguard, and maintain one unit of inventory in stock for a full year. Holding costs comprise:

• Opportunity Cost of Capital: The financial interest foregone or borrowing costs incurred on working capital locked up in inventory (frequently calculated as an interest rate percentage $r \times P$). This represents the single largest component of holding cost.
• Warehouse Storage Costs: Rent, rates, heating, refrigeration, and warehouse racking depreciation.
• Stores Personnel & Handling: Storekeeper wages, forklift truck maintenance, and material handling expenses.
• Insurance & Security: Premiums paid to protect inventory against fire, theft, and water damage.
• Deterioration, Evaporation & Obsolescence: Physical decay of perishable stock or loss of market value due to technical obsolescence.

Assuming constant demand and uniform stock usage with zero safety stock, inventory drops linearly from $Q$ to 0, giving an average inventory level of $Q / 2$:

$$\mathbf{\text{Annual Holding Cost} = \left(\frac{Q}{2}\right) \times C_h}$$

Cost Behaviour: As order size $Q$ increases, average inventory rises proportionally, causing total annual holding costs to rise linearly from the origin.

4. Stockout Costs and Buffer Stock

Costs incurred when inventory is completely depleted before replenishment arrives:

• Loss of immediate customer sales contribution and profit margins.
• Loss of customer goodwill and risk of permanent defection to competitors.
• Disruption to manufacturing schedules, leading to idle machine time and idle direct labour wages.
• Emergency expedited freight charges and spot-market purchasing premiums.

To protect against stockouts caused by unexpected demand surges or supplier delivery delays, organizations hold a permanent buffer stock (safety stock), denoted as $B$. When safety stock is maintained, average inventory becomes $(Q / 2) + B$:

$$\text{Annual Holding Cost with Safety Stock} = \left(\frac{Q}{2} + B\right) \times C_h$$

---

2. Mathematical Derivation of the Economic Order Quantity (EOQ)

The Economic Order Quantity (EOQ) is the order size $Q$ that minimizes the sum of annual ordering and holding costs:

$$\text{Total Cost } (TC) = \left(\frac{D}{Q}\right) C_o + \left(\frac{Q}{2}\right) C_h$$

Taking the first derivative of total cost with respect to order quantity $Q$, and setting it to zero to locate the mathematical minimum:

$$\frac{dTC}{dQ} = -\frac{D \times C_o}{Q^2} + \frac{C_h}{2} = 0$$ $$\frac{C_h}{2} = \frac{D \times C_o}{Q^2}$$ $$Q^2 \times C_h = 2 \times D \times C_o$$ $$Q^2 = \frac{2 \times C_o \times D}{C_h}$$ $$\mathbf{EOQ = \sqrt{\frac{2 C_o D}{C_h}}}$$

Where:

• $D = \text{Annual demand for the item (in units)}$
• $C_o = \text{Cost of placing one purchase order}$
• $C_h = \text{Cost of holding one unit of inventory for one year}$

The Fundamental EOQ Identity

Notice that at the minimum point of the total cost curve:

$$\text{Annual Ordering Cost} = \left(\frac{D}{Q}\right) C_o = \left(\frac{Q}{2}\right) C_h = \text{Annual Holding Cost}$$

Core Principle: At the basic Economic Order Quantity, total annual ordering cost exactly equals total annual holding cost. If these two cost calculations do not produce identical numbers, an error was made in solving for EOQ.

Underlying Assumptions of the Classical EOQ Model

1. Annual demand ($D$) is known, constant, and evenly distributed across the year.
2. The purchase price per unit ($P$) is constant and independent of order size (no bulk discounts initially).
3. Order cost ($C_o$) and holding cost per unit ($C_h$) are known and remain constant.
4. Replenishment lead time is zero (or constant and predictable), and orders arrive in a single batch.
5. No stockouts are permitted ($B = 0$).

---

3. Calculating Total Annual Inventory Costs at EOQ: Worked Example

A manufacturing enterprise consumes 12,000 components annually. The procurement department incurs an administrative cost of $60 to place each purchase order. The raw material purchase price is $25 per unit, and annual holding costs are estimated at 16% of purchase price per unit per year.

Step 1: Calculate the Holding Cost per Unit ($C_h$)

$$C_h = 16\% \times \$25.00 = \$4.00 \text{ per unit per year}$$

Step 2: Calculate the Economic Order Quantity (EOQ)

$$\text{EOQ} = \sqrt{\frac{2 \times C_o \times D}{C_h}} = \sqrt{\frac{2 \times \$60 \times 12,000}{\$4.00}} = \sqrt{\frac{\$1,440,000}{\$4.00}} = \sqrt{360,000} = \mathbf{600 \text{ units}}$$

Step 3: Compute the Cost Components at EOQ

• Number of Orders Placed Annually: $$\text{Number of Orders} = \frac{D}{\text{EOQ}} = \frac{12,000}{600} = 20 \text{ orders per year}$$
• Annual Ordering Cost: $$\text{Annual Ordering Cost} = 20 \text{ orders} \times \$60 = \mathbf{\$1,200}$$
• Average Inventory Level: $$\text{Average Inventory} = \frac{\text{EOQ}}{2} = \frac{600}{2} = 300 \text{ units}$$
• Annual Holding Cost: $$\text{Annual Holding Cost} = 300 \text{ units} \times \$4.00 = \mathbf{\$1,200}$$ (Note: Annual Ordering Cost = Annual Holding Cost = $1,200, confirming the EOQ identity).
• Annual Purchase Cost: $$\text{Annual Purchase Cost} = 12,000 \text{ units} \times \$25.00 = \mathbf{\$300,000}$$
• Total Annual Inventory Cost at EOQ: $$\text{Total Cost} = \text{Purchases} + \text{Ordering} + \text{Holding} = \$300,000 + \$1,200 + \$1,200 = \mathbf{\$302,400}$$

---

4. Evaluating Bulk Purchase (Quantity) Discounts

Suppliers frequently offer quantity discounts (price breaks) to incentivize customers to place larger, less frequent orders. Because ordering above EOQ increases inventory holding costs while reducing unit purchase costs and annual ordering expenses, management must determine whether accepting the discount lowers overall costs.

The Step-by-Step Decision Algorithm

                         Quantity Discount Decision Flow
                                        │
                                        ▼
          ┌───────────────────────────────────────────────────────────┐
          │ Step 1: Calculate basic EOQ using undiscounted price      │
          └─────────────────────────────┬─────────────────────────────┘
                                        │
                                        ▼
          ┌───────────────────────────────────────────────────────────┐
          │ Step 2: Calculate Total Annual Cost at EOQ                │
          │ (Purchases + Ordering + Holding)                          │
          └─────────────────────────────┬─────────────────────────────┘
                                        │
                                        ▼
          ┌───────────────────────────────────────────────────────────┐
          │ Step 3: Identify minimum order size required for discount │
          └─────────────────────────────┬─────────────────────────────┘
                                        │
                                        ▼
          ┌───────────────────────────────────────────────────────────┐
          │ Step 4: Recalculate Total Annual Cost at discount quantity│
          │ • Updated purchase price P_disc                           │
          │ • Updated ordering cost (fewer orders)                    │
          │ • Updated holding cost (larger average inventory)         │
          └─────────────────────────────┬─────────────────────────────┘
                                        │
                                        ▼
          ┌───────────────────────────────────────────────────────────┐
          │ Step 5: Compare Total Costs:                              │
          │ If Total Cost (Discount) < Total Cost (EOQ) ⟹ ACCEPT     │
          │ If Total Cost (Discount) ≥ Total Cost (EOQ) ⟹ REJECT     │
          └───────────────────────────────────────────────────────────┘

Crucial Examination Rule: Always evaluate the discount at the minimum order quantity necessary to secure the discount price tier. Ordering more than the minimum discount threshold increases holding costs without providing any additional price reduction per unit.

---

5. Comprehensive Worked Numerical Example: Quantity Discounts

Omega Ltd uses 10,000 units of raw material Alpha annually. The basic purchase price is $20.00 per unit. The cost of placing an order is $100. Holding costs are estimated at 10% of unit purchase price per annum.

The supplier introduces the following tiered bulk discount schedule:

Step 1: Evaluate Total Cost at the Basic EOQ

$$\text{EOQ} = \sqrt{\frac{2 \times C_o \times D}{C_h}} = \sqrt{\frac{2 \times \$100 \times 10,000}{\$2.00}} = \sqrt{\frac{\$2,000,000}{\$2.00}} = \sqrt{1,000,000} = \mathbf{1,000 \text{ units}}$$

Cost breakdown at $Q = 1,000$ units:

• Purchase Cost: $10,000 \times \text{\textdollar}20.00 = \text{\textdollar}200,000$
• Ordering Cost: $(10,000 / 1,000) \times \text{\textdollar}100 = 10 \times \text{\textdollar}100 = \text{\textdollar}1,000$
• Holding Cost: $(1,000 / 2) \times \text{\textdollar}2.00 = 500 \times \text{\textdollar}2.00 = \text{\textdollar}1,000$
• Total Annual Cost at EOQ: $\text{\textdollar}200,000 + \text{\textdollar}1,000 + \text{\textdollar}1,000 = \mathbf{\text{\textdollar}202,000}$

Step 2: Evaluate Total Cost at the 2% Discount Tier ($Q = 2,000$ units)

To secure the 2% discount, order size must increase to 2,000 units. The new purchase price is $19.60, and $C_h$ drops to $1.96 per unit per year ($10\% \times \text{\textdollar}19.60$):

• Purchase Cost: $10,000 \times \text{\textdollar}19.60 = \text{\textdollar}196,000$ (Purchase saving: $4,000)
• Ordering Cost: $(10,000 / 2,000) \times \text{\textdollar}100 = 5 \times \text{\textdollar}100 = \text{\textdollar}500$ (Ordering saving: $500)
• Holding Cost: $(2,000 / 2) \times \text{\textdollar}1.96 = 1,000 \times \text{\textdollar}1.96 = \text{\textdollar}1,960$ (Holding increase: $960)
• Total Annual Cost at 2,000 units: $\text{\textdollar}196,000 + \text{\textdollar}500 + \text{\textdollar}1,960 = \mathbf{\text{\textdollar}198,460}$
• Net Annual Saving compared to EOQ: $\text{\textdollar}202,000 - \text{\textdollar}198,460 = \mathbf{\text{\textdollar}3,540}$

Step 3: Evaluate Total Cost at the 5% Discount Tier ($Q = 4,000$ units)

To qualify for the 5% discount, order size must expand to 4,000 units. The purchase price becomes $19.00, and $C_h$ falls to $1.90 ($10\% \times \text{\textdollar}19.00$):

• Purchase Cost: $10,000 \times \text{\textdollar}19.00 = \text{\textdollar}190,000$ (Purchase saving: $10,000)
• Ordering Cost: $(10,000 / 4,000) \times \text{\textdollar}100 = 2.5 \times \text{\textdollar}100 = \text{\textdollar}250$ (Ordering saving: $750)
• Holding Cost: $(4,000 / 2) \times \text{\textdollar}1.90 = 2,000 \times \text{\textdollar}1.90 = \text{\textdollar}3,800$ (Holding increase: $2,800)
• Total Annual Cost at 4,000 units: $\text{\textdollar}190,000 + \text{\textdollar}250 + \text{\textdollar}3,800 = \mathbf{\text{\textdollar}194,050}$
• Net Annual Saving compared to EOQ: $\text{\textdollar}202,000 - \text{\textdollar}194,050 = \mathbf{\text{\textdollar}7,950}$

Summary Decision Matrix

Managerial Decision: Omega Ltd should accept the supplier's 5% discount offer and place orders in batches of 4,000 units. The $10,000 saving in direct purchase costs and $750 reduction in ordering expenses far outweigh the $2,800 increase in annual inventory holding costs, producing an overall annual profit improvement of $7,950.