Inventory & Production Management: Models, Costs & Trade-offs

TAKEAWAYS:

• Inventory costs (ordering, holding, stockout) determine optimal order quantities via the EOQ model—balance these to minimize total cost.
• ABC analysis prioritizes inventory items by value (A=highest, C=lowest) to focus control efforts where it matters most.
• Just-in-Time (JIT) and Material Requirements Planning (MRP) are production strategies that reduce waste but require precise demand forecasting.
• Cash Conversion Cycle (CCC) ties inventory management to working capital: shorter CCC = faster cash flow (critical for firms like NTC or Daraz).
• Safety stock acts as a buffer against uncertainty—calculate it using demand variability and lead time.
• Perpetual vs. periodic inventory systems differ in tracking frequency and cost trade-offs (real-time vs. batch updates).

---

1. Inventory Management: Definitions and Objectives

Inventory refers to raw materials, work-in-progress, and finished goods held by a business to support operations and sales. Effective inventory management aims to:

• Minimize costs (ordering, holding, stockout).
• Ensure product availability to meet customer demand.
• Optimize cash flow by balancing inventory levels.

Why does this matter? Poor inventory management leads to overstocking (high holding costs) or stockouts (lost sales/reputation). For example, Daraz’s warehouses must balance fast-moving electronics (high turnover) with seasonal items (like festival gifts).

---

---

2. Inventory Costs: The Three Key Components

Inventory costs are categorized into three types, visualized below:

• Holding Costs: Storage, insurance, depreciation, and opportunity cost of capital tied up in inventory. Example: A Kathmandu retail shop spends Rs 500/month to rent a warehouse for 100 boxes of biscuits (Rs 5/box/month).
• Ordering Costs: Administrative expenses (purchase orders, transportation, receiving). Example: NTC incurs Rs 2,000 per order to procure new SIM cards from suppliers.
• Stockout Costs: Lost sales, rush orders, or production delays. Example: Pathao’s delivery drivers face delays if spare batteries aren’t stocked (stockout cost = lost deliveries).

---

3. Inventory Valuation Methods

How inventory is valued affects financial statements and tax liabilities. Three common methods:

Worked Example: Kathmandu Biscuit Factory (FIFO vs. LIFO) Assume the factory buys biscuits in three batches:

• Jan: 100 boxes @ Rs 100/box
• Feb: 200 boxes @ Rs 120/box
• Mar: 150 boxes @ Rs 130/box Sold 250 boxes in March.

Key Takeaway:

• FIFO reports higher profit (lower COGS) in inflationary periods.
• LIFO saves on taxes but may misrepresent actual costs.

---

4. Economic Order Quantity (EOQ): The Optimal Order Size

The EOQ model determines the optimal order quantity that minimizes total inventory costs (holding + ordering). The formula is:

$$EOQ=\sqrt{\frac{2DS}{H}}$$ Where:

• $D$ = Annual demand (units)
• $S$ = Ordering cost per order
• $H$ = Holding cost per unit per year

Worked Example: Nanglo Bread Company

• Annual demand (D): 100,000 bags of wheat.
• Ordering cost (S): Rs 480 per order.
• Holding cost (H): 10% of purchase price = 10% × Rs 25/kg × 50 kg/bag = Rs 12.50/bag/year.
• Purchase price: Rs 25/kg (irrelevant for EOQ).

Calculation: $$EOQ=\sqrt{\frac{2\times 100,000\times 480}{12.50}}=\sqrt{768,000}\approx 876\text{ bags per order}$$

Total Cost Analysis:

Optimal Order Quantity: 876 bags minimizes total cost to Rs 60,269/year.

---

---

5. ABC Analysis: Prioritizing Inventory

Not all inventory items require equal attention. ABC analysis classifies items based on annual consumption value (not quantity):

Example: Daraz Warehouse

• Class A: Smartphones (high value, low quantity).
• Class B: Accessories (moderate value).
• Class C: Packaging materials (low value, high quantity).

Why it works:

• Focuses resources on high-value items (e.g., NTC’s SIM cards vs. stationery).
• Reduces over-management of low-value items (e.g., Daraz’s plastic wraps).

---

6. Production Management: JIT vs. MRP

Two contrasting approaches to production planning:

Worked Example: Kathmandu Retail Shop (JIT for Perishables)

• Scenario: The shop orders fresh milk daily (JIT) instead of weekly (MRP).
• Benefits:
  • Reduces spoilage (holding cost).
  • Matches demand exactly (no overstock).
• Challenge:
  • Requires reliable suppliers (e.g., a local dairy with same-day delivery).

---

7. Cash Conversion Cycle (CCC): Linking Inventory to Cash Flow

The CCC measures how long cash is tied up in operations:

$$CCC=\text{Inventory Period}+\text{Receivables Period}-\text{Payables Period}$$

Example: Kathmandu Biscuit Factory

• Inventory Turnover: 6 times/year → Inventory Period = 365/6 = 61 days.
• Receivables Collection Period: 70 days.
• Payables Deferral Period: 40 days.
• CCC = 61 + 70 - 40 = 91 days.

Interpretation:

• A shorter CCC means faster cash conversion (better for liquidity).
• Actionable Insight: The factory could:
  1. Reduce inventory period (e.g., switch to JIT for packaging).
  2. Speed up collections (offer discounts for early payments).
  3. Negotiate longer payables terms (e.g., 60 days instead of 40).

---

---

8. Safety Stock: Managing Uncertainty

Safety stock is extra inventory held to prevent stockouts due to:

• Demand fluctuations.
• Lead time variability.
• Supplier delays.

Formula: $$\text{Safety Stock}=(Z\times {\sigma }_d\times \sqrt{L})+(D\times L)$$ Where:

• $Z$ = Z-score (e.g., 1.65 for 95% confidence).
• ${\sigma }_d$ = Standard deviation of daily demand.
• $L$ = Lead time (days).
• $D$ = Average daily demand.

Example: Star Toys Company (Dolls’ Flesh-Colored Cloth)

• Annual demand: 2,500,000 sq. yards.
• Daily demand (D): 2,500,000 / 365 ≈ 6,850 sq. yards.
• Lead time (L): 10 days.
• Standard deviation (${\sigma }_d$): 500 sq. yards (estimated).
• Z-score: 1.65 (95% confidence).

Calculation: $$\text{Safety Stock}=(1.65\times 500\times \sqrt{10})+(6,850\times 10)\approx 67,000\text{ sq. yards}$$

Why it matters:

• Without safety stock, Star Toys risks production halts if cloth deliveries are delayed.
• Trade-off: Higher safety stock reduces stockout risk but increases holding costs.

---

9. Inventory Systems: Perpetual vs. Periodic

When to Use Which?

• Perpetual: High-value items (e.g., Ncell’s SIM cards).
• Periodic: Low-value, bulk items (e.g., NTC’s office supplies).

---

In the Real World

1. Daraz (Nepal)

   • Idea Used: ABC Analysis + EOQ
   • How: Daraz classifies inventory into A (electronics), B (clothing), C (packaging). For A-items (e.g., smartphones), it uses EOQ to minimize ordering costs while ensuring stock availability during festivals like Dashain.

2. NTC (Nepal Telecom)

   • Idea Used: Safety Stock + JIT
   • How: NTC maintains safety stock of SIM cards during peak subscription periods (e.g., new academic year). However, it uses JIT for spare parts (e.g., network cables) to avoid obsolescence.

3. Kathmandu Retail Shops (Local Businesses)

   • Idea Used: Cash Conversion Cycle (CCC)
   • How: A typical Kathmandu shop might have:
     • Inventory Period: 30 days (fresh produce).
     • Receivables Period: 15 days (customers pay on delivery).
     • Payables Period: 30 days (suppliers give credit).
     • CCC: 30 + 15 - 30 = 15 days.
   • Problem: If CCC exceeds 30 days, the shop may face cash flow crises during slow seasons (e.g., monsoon).

---

Exam Tip

1. Numerical Questions (50% Weight)

   • Always show calculations step-by-step (e.g., EOQ, safety stock, CCC).
   • Assume missing data if not provided (e.g., "holding cost is 20% of inventory value").
   • Units matter: Answer in Rs, days, or units as asked (e.g., "EOQ = 500 bags" not "500").

2. Conceptual Questions (30% Weight)

   • Define key terms (e.g., "EOQ is the order quantity that minimizes total inventory costs").
   • Compare methods (e.g., "JIT reduces holding costs but requires supplier reliability").
   • Link to real-world examples (e.g., "Like Daraz, firms use ABC analysis to prioritize high-value items").

3. Short-Answer Tips (20% Weight)

   • Bullet points work for pros/cons (e.g., "Advantages of FIFO: matches physical flow, higher profit in inflation").
   • Use diagrams for processes (e.g., CCC flowchart) or classifications (e.g., ABC table).
   • Memorize formulas:
     • EOQ = √(2DS/H)
     • CCC = Inventory Period + Receivables Period - Payables Period
     • Safety Stock = Z × σ × √L + (D × L)

4. Common Pitfalls to Avoid

   • Ignoring units: Forgetting to annualize daily/weekly data (e.g., converting demand from monthly to yearly).
   • Misapplying LIFO: LIFO is not allowed in Nepal’s accounting standards for income tax purposes (use FIFO or weighted average).
   • Overcomplicating: Stick to one model per question (e.g., don’t mix EOQ and MRP in the same answer unless asked).

---

Final Worked Example: Koshi Chemical Fertilizer Centre (KCFC) Question: KCFC sells 3,380,000 bags of fertilizer annually. Fixed ordering cost = Rs 480/order. Cost per bag = Rs 600. Holding cost = 15% of inventory value. Calculate: a) EOQ. b) Total annual inventory cost at EOQ. c) Reorder point if lead time = 10 days and daily demand = 9,260 bags.

Solution: Given:

• $D=3,380,000$ bags/year.
• $S=Rs480$/order.
• $H=15\%\times Rs600=Rs90$/bag/year.
• Lead time = 10 days.
• Daily demand = 3,380,000 / 365 ≈ 9,260 bags/day.

a) EOQ: $$EOQ=\sqrt{\frac{2\times 3,380,000\times 480}{90}}=\sqrt{37,066,667}\approx 6,090\text{ bags}$$

b) Total Annual Cost:

• Ordering Cost: $(3,380,000/6,090)\times 480=Rs266,667$.
• Holding Cost: $(6,090/2)\times 90=Rs274,050$.
• Total Cost: $266,667+274,050=Rs540,717$.

c) Reorder Point: $$\text{Reorder Point}=\text{Daily Demand}\times \text{Lead Time}=9,260\times 10=92,600\text{ bags}$$ Interpretation:

• KCFC should place an order when inventory drops to 92,600 bags.
• Order quantity: 6,090 bags (EOQ).
• Total cost at EOQ: Rs 540,717/year.

---

Why This Matters for KCFC:

• Reduces waste: Avoids overstocking (holding cost) or stockouts (lost sales).
• Improves cash flow: Lower inventory levels free up working capital.
• Scalable: Works for seasonal demand (e.g., higher sales before monsoon planting).