Calculation of EOQ

SUPPLY CHAIN MANAGEMENT
1

1. Calculation of EOQ
EOQ = √2AO/C
In the given case
A= 2000 Kegs
O= $60 per order
C= $1 per year per keg space
Therefore,
EOQ = √(2*2000*60)/1
EOQ = 490 units approximately
We also have the following table:
Order
Quant
ity
Total number of
orders (Annual
demand/ order qty)
Ordering Cost
(number of
orders*order cost)
Carrying Cost (Average
annual demand*carrying
cost per unit)
Total Cost
(order cost +
carrying cost)
100 20 1,200 50 1,250
200 10 600 100 700
300 7 400 150 550
400 5 300 200 500
500 4 240 250 490
600 3 200 300 500
700 3 171 350 521
800 3 150 400 550
900 2 133 450 583
1000 2 120 500 620
1100 2 109 550 659
1200 2 100 600 700
1300 2 92 650 742
1400 1 86 700 786
1500 1 80 750 830
2

1600 1 75 800 875
1700 1 71 850 921
1800 1 67 900 967
1900 1 63 950 1,013
2000 1 60 1,000 1,060
Therefore we see that the economic order quantity is of approximately 490 unis.
2. We have the following:
Particulars Order
cost
Number of
order
Total order
cost
Total
Carrying cost
Total
Cost
750 or more kegs( assuming
750 kegs) - 3 - 750 750
249-749 kegs (assuming 490
kegs) 30 5 150 490 640
Less than 249 Kegs (assuming
249 kegs) 60 8 480 249 729
Therefore, we see that the EOQ is the one with the least total cost, which is the order quantity of
490 kegs (Atkinson, 2012).
3. The rent of the space as per point 1 is taken on number of units calculated as per EOQ.
The economic order quantity is of 490 kegs. Therefore, this indicates that that Low would
be required to rent the space for 490 kegs only throughout the year. This would result in
the rent expense of $490 per year.
If the rent is charged on average units throughout the year, the answer would not change,
as the economic order quantity is 490 units (Berry, 2009). This means that on an average
Low would be required to maintain 490 units.
4. Taking into consideration all the above policies, we would consider the option with
lowest cost. Since the option which results in lowest cost is the one with 490 kegs, we
3