A manufacturing firm has received an offer for a particular component according to the following discount pricing schedule provided by the supplier :
1–199 ₹ 66 per unit
200–599 ₹ 60 per unit
600+ ₹ 55 per unit
The firm uses 800 components annually. The annual carrying cost is ₹ 15 per unit. The ordering cost is ₹ 300 per order.
Determine the amount the firm should order.
15 marks · directive: Determine
The core of a good answer
The firm should order 600 units at a time (at ₹55 each), which gives the lowest total annual cost of ₹48,900, against ₹50,700 for 200 units and about ₹55,483 for the EOQ of 179 units at ₹66.
An outline written by upsc.help, not an official UPSC answer; every fact checked by a separate review. How we work
What the question asks
This is the EOQ model with all-units quantity discounts. Compute the EOQ, adjust it to the nearest feasible quantity in each price band, and compare total annual cost (purchase + ordering + carrying) at each candidate quantity.
Answer outline
Introduction
Given: annual demand D = 800 units, ordering cost S = ₹300 per order, carrying cost H = ₹15 per unit per year (constant across prices), price bands ₹66 (1 to 199), ₹60 (200 to 599) and ₹55 (600 and above).
Step 1: EOQ
- EOQ = √(2DS/H) = √(2 × 800 × 300 / 15) = √32,000 ≈ 178.9 units.
- Since H does not depend on price, the EOQ is 178.9 in every band; it is feasible only in the ₹66 band.
Step 2: Candidate quantities
- ₹66 band: Q = 178.9 (feasible).
- ₹60 band: EOQ below 200, so raise Q to the price break 200.
- ₹55 band: EOQ below 600, so raise Q to 600.
Step 3: Total cost TC = DP + (D/Q)S + (Q/2)H
- Q = 178.9 at ₹66: 52,800 + 1,341.64 + 1,341.64 = ₹55,483.28
- Q = 200 at ₹60: 48,000 + 1,200 + 1,500 = ₹50,700
- Q = 600 at ₹55: 44,000 + 400 + 4,500 = ₹48,900
Step 4: Choose the minimum
- Lowest TC is ₹48,900 at Q = 600.
- Saving over the EOQ policy at ₹66 = 55,483.28 - 48,900 = ₹6,583.28 a year; saving over Q = 200 = ₹1,800.
Conclusion
Order 600 units per order (about 1.33 orders a year, one every nine months or so). Check: the extra carrying cost of the bigger lot (₹4,500 against ₹1,500) is far smaller than the purchase saving of ₹4,000 (₹5 × 800) plus lower ordering cost. All figures recomputed in Python.
Examples and data to cite
- If carrying cost were a percentage of price, the EOQ would differ in each band and should be recomputed for each price.
Facts to remember
- EOQ (Harris, 1913) = √(2DS/H).
- At the EOQ, annual ordering cost equals annual carrying cost (₹1,341.64 each here).
- All-units discount procedure: compute EOQ for each price; if infeasible, move up to the lowest quantity of that band; compare total costs including purchase cost.
- Total annual cost = purchase cost DP + ordering cost (D/Q)S + carrying cost (Q/2)H.