Economic order quantity

Economic order quantity (EOQ), also known as financial purchase quantity or economic buying quantity,^{[ citation needed ]} is the order quantity that minimizes the total holding costs and ordering costs in inventory management. It is one of the oldest classical production scheduling models. The model was developed by Ford W. Harris in 1913, but the consultant R. H. Wilson applied it extensively, and he and K. Andler are given credit for their in-depth analysis. ^[1]

Overview

The EOQ indicates the optimal number of units to order to minimize the total cost associated with the purchase, delivery, and storage of a product.

EOQ applies only when demand for a product is constant over a period of time (such as a year) and each new order is delivered in full when inventory reaches zero. There is a fixed cost for each order placed, regardless of the quantity of items ordered; an order is assumed to contain only one type of inventory item. There is also a cost for each unit held in storage, commonly known as holding cost, sometimes expressed as a percentage of the purchase cost of the item. Although the EOQ formulation is straightforward, factors such as transportation rates and quantity discounts factor into its real-world application.

The required parameters to the solution are the total demand for the year, the purchase cost for each item, the fixed cost to place the order for a single item and the storage cost for each item per year. Note that the number of times an order is placed will also affect the total cost, though this number can be determined from the other parameters.

Variables

• ${\displaystyle T}$ = total annual inventory cost
• ${\displaystyle P}$ = purchase unit price, unit production cost
• ${\displaystyle Q}$ = order quantity
• ${\displaystyle Q^{*}}$ = optimal order quantity
• ${\displaystyle D}$ = annual demand quantity
• ${\displaystyle K}$ = fixed cost per order, setup cost (not per unit, typically cost of ordering and shipping and handling. This is not the cost of goods)
• ${\displaystyle h}$ = annual holding cost per unit, also known as carrying cost or storage cost (capital cost, warehouse space, refrigeration, insurance, opportunity cost (price x interest), etc. usually not related to the unit production cost)

Total cost function and derivation of EOQ formula

The single-item EOQ formula finds the minimum point of the following cost function:

Total Cost = purchase cost or production cost + ordering cost + holding cost

Where:

• Purchase cost: This is the variable cost of goods: purchase unit price × annual demand quantity. This is ${\displaystyle P\times D}$.
• Ordering cost: This is the cost of placing orders: each order has a fixed cost ${\displaystyle K}$, and we need to order ${\displaystyle D/Q}$ times per year. This is ${\displaystyle KD/Q}$
• Holding cost: the average quantity in stock (between fully replenished and empty) is ${\displaystyle Q/2}$, so this cost is ${\displaystyle hQ/2}$

${\displaystyle T=PD+K{\frac {D}{Q}}+h{\frac {Q}{2}}}$.

To determine the minimum point of the total cost curve, calculate the derivative of the total cost with respect to Q (assume all other variables are constant) and set it equal to 0:

${\displaystyle {0}=-{\frac {DK}{Q^{2}}}+{\frac {h}{2}}}$

Solving for Q gives Q* (the optimal order quantity):

${\displaystyle Q^{*2}={\frac {2DK}{h}}}$

Therefore:

Economic Order Quantity

${\displaystyle Q^{*}={\sqrt {\frac {2DK}{h}}}}$

Q* is independent of P; it is a function of only K, D, h.

The optimal value Q* may also be found by recognizing that

${\displaystyle T={\frac {DK}{Q}}+{\frac {hQ}{2}}+PD={\frac {h}{2Q}}(Q-{\sqrt {2DK/h}})^{2}+{\sqrt {2hDK}}+PD,}$

where the non-negative quadratic term disappears for ${\textstyle Q={\sqrt {2DK/h}},}$ which provides the cost minimum ${\displaystyle T_{min}={\sqrt {2hDK}}+PD.}$

Example

• Annual requirement quantity (D) = 10000 units
• Cost per order (K) = 40
• Cost per unit (P)= 50
• Yearly carrying cost per unit = 4
• Market interest = 2%

Economic order quantity = ${\displaystyle {\sqrt {\frac {2D\cdot K}{h}}}}$${\displaystyle ={\sqrt {\frac {2\cdot 10000\cdot 40}{4+50\cdot 2\%}}}={\sqrt {\frac {2\cdot 10000\cdot 40}{5}}}}$ = 400 units

Number of orders per year (based on EOQ) ${\displaystyle ={\frac {10000}{400}}=25}$

Total cost ${\displaystyle =P\cdot D+K(D/EOQ)+h(EOQ/2)}$

Total cost ${\displaystyle =50\cdot 10000+40\cdot (10000/400)+5\cdot (400/2)=502000}$

If we check the total cost for any order quantity other than 400(=EOQ), we will see that the cost is higher. For instance, supposing 500 units per order, then

Total cost ${\displaystyle =50\cdot 10000+40\cdot (10000/500)+5\cdot (500/2)=502050}$

Similarly, if we choose 300 for the order quantity, then

Total cost ${\displaystyle =50\cdot 10000+40\cdot (10000/300)+5\cdot (300/2)=502083.33}$

This illustrates that the economic order quantity is always in the best interests of the firm.

Extensions of the EOQ model

Quantity discounts

An important extension to the EOQ model is to accommodate quantity discounts. There are two main types of quantity discounts: (1) all-units and (2) incremental. ^{[2] [3]} Here is a numerical example:

• Incremental unit discount: Units 1–100 cost $30 each; Units 101–199 cost $28 each; Units 200 and up cost $26 each. So when 150 units are ordered, the total cost is $30*100 + $28*50.
• All units discount: an order of 1–1000 units costs $50 each; an order of 1001–5000 units costs $45 each; an order of more than 5000 units costs $40 each. So when 1500 units are ordered, the total cost is $45*1500.

In order to find the optimal order quantity under different quantity discount schemes, one should use algorithms; these algorithms are developed under the assumption that the EOQ policy is still optimal with quantity discounts. Perera et al. (2017) ^[4] establish this optimality and fully characterize the (s,S) optimality within the EOQ setting under general cost structures.

Design of optimal quantity discount schedules

In presence of a strategic customer, who responds optimally to discount schedules, the design of an optimal quantity discount scheme by the supplier is complex and has to be done carefully. This is particularly so when the demand at the customer is itself uncertain. An interesting effect called the "reverse bullwhip" takes place where an increase in consumer demand uncertainty actually reduces order quantity uncertainty at the supplier. ^[5]

Backordering costs and multiple items

Several extensions can be made to the EOQ model, including backordering costs ^[6] and multiple items. In the case backorders are permitted, the inventory carrying costs per cycle are: ^[7]

${\displaystyle IC\int \limits _{0}^{T_{1}}(Q-s-\lambda t)\,dt={\frac {IC}{2\lambda }}(Q-s)^{2},}$

where s is the number of backorders when order quantity Q is delivered and ${\displaystyle \lambda }$ is the rate of demand. The backorder cost per cycle is:

${\displaystyle \pi s+{\hat {\pi }}\int \limits _{0}^{T_{2}}\lambda tdt=\pi s+{\frac {1}{2}}{\hat {\pi }}\lambda T_{2}^{2}=\pi s+{\frac {{\hat {\pi }}s^{2}}{2\lambda }},}$

where ${\displaystyle \pi }$ and ${\displaystyle {\hat {\pi }}}$ are backorder costs, ${\displaystyle T_{2}=T-T_{1}}$, T being the cycle length and ${\displaystyle T_{1}=(Q-s)/\lambda }$. The average annual variable cost is the sum of order costs, holding inventory costs and backorder costs:

${\displaystyle {\mathcal {K}}={\frac {\lambda }{Q}}A+{\frac {1}{2Q}}IC(Q-s)^{2}+{\frac {1}{Q}}[\pi \lambda s+{\frac {1}{2}}{\hat {\pi }}s^{2}]}$

To minimize ${\displaystyle {\mathcal {K}}}$ impose the partial derivatives equal to zero:

${\displaystyle {\frac {\partial {\mathcal {K}}}{\partial Q}}=-{\frac {1}{Q^{2}}}\left[{\lambda }A+{\frac {1}{2}}IC(Q-s)^{2}+\pi \lambda s+{\frac {1}{2}}{\hat {\pi }}s^{2}\right]+{\frac {IC}{Q}}(Q-s)=0}$

${\displaystyle {\frac {\partial {\mathcal {K}}}{\partial s}}=-{\frac {IC}{Q}}(Q-s)+{\frac {1}{Q}}\pi \lambda +{\frac {1}{Q}}{\hat {\pi }}s=0}$

Substituting the second equation into the first gives the following quadratic equation:

${\displaystyle [{\hat {\pi }}^{2}+{\hat {\pi }}IC]s^{2}+2\pi {\hat {\pi }}\lambda s+(\pi \lambda )^{2}-2\lambda AIC=0}$

If ${\displaystyle {\hat {\pi }}=0}$ either s=0 or ${\displaystyle s=\infty }$ is optimal. In the first case the optimal lot is given by the classic EOQ formula, in the second case an order is never placed and minimum yearly cost is given by ${\displaystyle \pi \lambda }$. If ${\displaystyle \pi >{\sqrt {\frac {2AIC}{\lambda }}}=\delta }$ or ${\displaystyle \pi \lambda >K_{w}}$${\displaystyle s^{*}=0}$ is optimal, if ${\displaystyle \pi <\delta }$ then there shouldn't be any inventory system. If ${\displaystyle {\hat {\pi }}\neq 0}$ solving the preceding quadratic equation yields:

${\displaystyle s^{*}=[{\hat {\pi }}+IC]^{-1}\left(-\pi \lambda +\left[(2\lambda AIC)\left(1+{\frac {IC}{\hat {\pi }}}\right)-{\frac {IC}{\hat {\pi }}}(\pi \lambda )^{2}\right]^{1/2}\right)}$

${\displaystyle Q^{*}=\left[{\frac {{\hat {\pi }}+IC}{\hat {\pi }}}\right]^{1/2}\left[{\frac {2\lambda A}{IC}}-{\frac {(\pi \lambda )^{2}}{IC({\hat {\pi }}+IC)}}\right]^{1/2}}$

If there are backorders, the reorder point is: ${\displaystyle r_{h}^{*}=\mu -mQ^{*}-s^{*}}$; with m being the largest integer ${\displaystyle m\leq {\frac {\tau }{T}}}$ and μ the lead time demand.

Additionally, the economic order interval ^[8] can be determined from the EOQ and the economic production quantity model (which determines the optimal production quantity) can be determined in a similar fashion.

A version of the model, the Baumol-Tobin model, has also been used to determine the money demand function, where a person's holdings of money balances can be seen in a way parallel to a firm's holdings of inventory. ^[9]

Malakooti (2013) ^[10] has introduced the multi-criteria EOQ models where the criteria could be minimizing the total cost, Order quantity (inventory), and Shortages.

A version taking the time-value of money into account was developed by Trippi and Lewin. ^[11]

Imperfect quality

Another important extension of the EOQ model is to consider items with imperfect quality. Salameh and Jaber (2000) were the first to study the imperfect items in an EOQ model very thoroughly. They consider an inventory problem in which the demand is deterministic and there is a fraction of imperfect items in the lot and are screened by the buyer and sold by them at the end of the circle at discount price. ^[12]

Criticisms

The EOQ model and its sister, the economic production quantity model (EPQ), have been criticised for "their restrictive set[s] of assumptions. ^[13] Guga and Musa make use of the model for an Albanian business case study and conclude that the model is "perfect theoretically, but not very suitable from the practical perspective of this firm". ^[14] However, James Cargal notes that the formula was developed when business calculations were undertaken "by hand", or using logarithmic tables or a slide rule. Use of spreadsheets and specialist software allows for more versatility in the use of the formula and adoption of "assumptions which are more realistic" than in the original model. ^{[15] [ self-published source ]}

See also

• Reorder point
• Safety stock
• Economic production quantity
• Newsvendor model
• Dynamic lot size model
• Economic lot scheduling problem

References

1. Hax, AC; Candea, D. (1984), Production and Operations Management, Englewood Cliffs, NJ: Prentice-Hall, p. 135, ISBN   9780137248803
2. Nahmias, Steven (2005). Production and operations analysis. McGraw Hill Higher Education.^{[ page needed ]}
3. Zipkin, Paul H, Foundations of Inventory Management, McGraw Hill 2000^{[ page needed ]}
4. Perera, Sandun; Janakiraman, Ganesh; Niu, Shun-Chen (2017). "Optimality of (s,S) policies in EOQ models with general cost structures". International Journal of Production Economics. 187: 216–228. doi:10.1016/j.ijpe.2016.09.017.
5. Altintas, Nihat; Erhun, Feryal; Tayur, Sridhar (2008). "Quantity Discounts Under Demand Uncertainty". Management Science. 54 (4): 777–92. doi:10.1287/mnsc.1070.0829. JSTOR   20122426.
6. Perera, Sandun; Janakiraman, Ganesh; Niu, Shun-Chen (2017). "Optimality of (s,S) policies in EOQ models with general cost structures". International Journal of Production Economics. 187: 216–228. doi:10.1016/j.ijpe.2016.09.017.
7. T. Whitin, G. Hadley, Analysis of Inventory Systems, Prentice Hall 1963
8. Goyal, S.K. (1987). "A simple heuristic method for determining economic order interval for linear demand". Engineering Costs and Production Economics. 11: 53–57. doi:10.1016/0167-188X(87)90025-5.
9. Caplin, Andrew; Leahy, John (2010). "Economic Theory and the World of Practice: A Celebration of the (s, S) Model". The Journal of Economic Perspectives. 24 (1): 183–201. CiteSeerX   10.1.1.730.8784 . doi:10.1257/jep.24.1.183. JSTOR   25703488.
10. Malakooti, B (2013). Operations and Production Systems with Multiple Objectives. John Wiley & Sons. ISBN   978-1-118-58537-5.^{[ page needed ]}
11. Trippi, Robert R.; Lewin, Donald E. (1974). "A Present Value Formulation of the Classical Eoq Problem". Decision Sciences. 5 (1): 30–35. doi:10.1111/j.1540-5915.1974.tb00592.x.
12. Salameh, M.K.; Jaber, M.Y. (March 2000). "Economic production quantity model for items with imperfect quality". International Journal of Production Economics. 64 (1–3): 59–64. doi:10.1016/s0925-5273(99)00044-4. ISSN   0925-5273.
13. Tao, Z., A. L. Guiffrida, and M. D. Troutt, "A green cost based economic production/order quantity model", in Proceedings of the 1st Annual Kent State International Symposium on Green Supply Chains, Canton, Ohio, US, 29–30 July 2010
14. Guga, E. and Musa, O. (2015) in Inventory Management through EOQ Model, International Journal of Economics, Commerce & Management, Vol. III, Issue 12, December 2015, accessed 9 February 2024
15. Cargal, J. M. (2003), The EOQ Formula, Troy University, accessed 9 February 2024

Further reading

• Harris, Ford W. Operations Cost (Factory Management Series), Chicago: Shaw (1915)
• Harris, Ford W. (1913). "How many parts to make at once". Factory, the Magazine of Management. 10: 135–136, 152.
• Camp, W. E. "Determining the production order quantity", Management Engineering, 1922
• Wilson, R. H. (1934). "A Scientific Routine for Stock Control". Harvard Business Review. 13: 116–28.
• Plossel, George. Orlicky's Material Requirement's Planning. Second Edition. McGraw Hill. 1984. (first edition 1975)
• Erlenkotter, Donald (2014). "Ford Whitman Harris's economical lot size model". International Journal of Production Economics. 155: 12–15. doi:10.1016/j.ijpe.2013.12.008. S2CID   153794306.
• Perera, Sandun; Janakiraman, Ganesh; Niu, Shun-Chen (2017). "Optimality of (s,S) policies in EOQ models with general cost structures". International Journal of Production Economics. 187: 216–228. doi:10.1016/j.ijpe.2016.09.017.
• Perera, Sandun; Janakiraman, Ganesh; Niu, Shun-Chen (2018). "Optimality of (s, S) Inventory Policies under Renewal Demand and General Cost Structures". Production and Operations Management. 27 (2): 368–383. doi:10.1111/poms.12795. hdl: 2027.42/142450 .
• Tsan-Ming Choi (Ed.) Handbook of EOQ Inventory Problems: Stochastic and Deterministic Models and Applications, Springer's International Series in Operations Research and Management Science, 2014. doi : 10.1007/978-1-4614-7639-9.
• Ventura, Robert; Samuel, Stephen (2016). "Optimization of fuel injection in GDI engine using economic order quantity and Lambert W function". Applied Thermal Engineering. 101: 112–20. doi:10.1016/j.applthermaleng.2016.02.024.
• Renewal Demand and (s, S) Optimality by Perera, Janakiraman, and Niu

External links

• The EOQ Model
• Piasecki, D., Vol. III, Issue 12, December 2015