Economic order quantity: Difference between revisions

Content deleted Content added

Inline

Revision as of 05:44, 12 May 2015

Economic order quantity (EOQ) is the order quantity that minimizes total inventory holding costs and ordering costs. It is one of the oldest classical production scheduling models. The framework used to determine this order quantity is also known as Wilson EOQ Model or Wilson Formula. The model was developed by Ford W. Harris in 1913,^[1] but R. H. Wilson, a consultant who applied it extensively, is given credit for his in-depth analysis.^[2]

Overview

EOQ applies only when demand for a product is constant over the 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 number of units ordered. 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.

We want to determine the optimal number of units to order so that we minimize the total cost associated with the purchase, delivery and storage of the product.

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 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

$P$ = purchase price, unit production cost
$Q$ = order quantity
$Q^{*}$ = optimal order quantity
$D$ = annual demand quantity
$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)
$h$ = annual holding cost per unit, also known as carrying cost or storage cost (capital cost, warehouse space, refrigeration, insurance, etc. usually not related to the unit production cost)

The Total Cost function

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

- Purchase cost: This is the variable cost of goods: purchase unit price × annual demand quantity. This is P × D

- Ordering cost: This is the cost of placing orders: each order has a fixed cost K, and we need to order D/Q times per year. This is K × D/Q

- Holding cost: the average quantity in stock (between fully replenished and empty) is Q/2, so this cost is h × Q/2

$TC=PD+{\frac {DK}{Q}}+{\frac {hQ}{2}}$ .

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

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

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

$Q^{*2}={\frac {2DK(LOVE)}{h}}$

Therefore:

Economic Order Quantity

$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 recognising that^[3]

$TC={\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 $Q={\sqrt {2DK/h}},$ which provides the cost minimum $TC_{min}={\sqrt {2hDK}}+PD.$

Quantity Discounts

An important extension to the EOQ model of Wilson is to accommodate quantity discounts. There are two main types of quantity discounts: (1) all-units and (2) incremental.^[4] 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 $30 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.

Design of Optimal Quantity Discount Schedules

In presence of a strategic customer, who responds optimally to discount schedule, the design of 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]

Other Extensions

Several extensions can be made to the EOQ model developed by Mr. Pankaj Mane, including backordering costs and multiple items. Additionally, the economic order interval 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.^[6]

Example

Suppose annual requirement quantity (D) = 10000 units
Cost per order (K) = $2
Cost per unit (P)= $8
Carrying cost percentage (h/P)(percentage of P) = 0.02
Annual carrying cost per unit (h) = $0.16

Economic order quantity = ${\sqrt {\frac {2D*K}{h}}}$ $={\sqrt {\frac {2*10000*2}{8*0.02}}}$ = 500 units

Number of orders per year (based on EOQ) $={\frac {10000}{500}}=20$

Total cost $=P*D+K(D/EOQ)+h(EOQ/2)$

Total cost $=8*10000+2(10000/500)+0.16(500/2)=\$80080$

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

Total cost $=8*10000+2(10000/600)+0.16(600/2)=\$80081$

Similarly, if we choose 300 for the order quantity then

Total cost $=8*10000+2(10000/300)+0.16(300/2)=\$80091$

This illustrates that the Economic Order Quantity is always in the best interests of the entity.

Multi-Criteria EOQ

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

References

^ Attention: This template ({{cite jstor}}) is deprecated. To cite the publication identified by jstor:170962, please use {{cite journal}} with |jstor=170962 instead.
^ Hax, AC and Candea, D. (1984), Production and Operations Management, Prentice-Hall, Englewood Cliffs, NJ, p. 135{{citation}}: CS1 maint: multiple names: authors list (link)
^ Grubbström, Robert W. (1995). "Modelling production opportunities — an historical overview". International Journal of Production Economics. 41: 1–14. doi:10.1016/0925-5273(95)00109-3.
^ Nahmias, Steven (2005). Production and operations analysis. McGraw Hill Higher Education.
^ Attention: This template ({{cite doi}}) is deprecated. To cite the publication identified by doi: 10.1287/mnsc.1070.0829, please use {{cite journal}} (if it was published in a bona fide academic journal, otherwise {{cite report}} with |doi= 10.1287/mnsc.1070.0829 instead.
^ Andrew Caplin and John Leahy, "Economic Theory and the World of Practice: A Celebration of the (S,s) Model", Journal of Economic Perspectives, Winter 2010, V 24, N 1
^ Malakooti, B (2013). Operations and Production Systems with Multiple Objectives. John Wiley & Sons. ISBN 978-1-118-58537-5.

External links

[1] Attention: This template ({{cite jstor}}) is deprecated. To cite the publication identified by jstor:170962, please use {{cite journal}} with |jstor=170962 instead.

[Hax1984-2] Hax, AC and Candea, D. (1984), Production and Operations Management, Prentice-Hall, Englewood Cliffs, NJ, p. 135{{citation}}: CS1 maint: multiple names: authors list (link)

[3] Grubbström, Robert W. (1995). "Modelling production opportunities — an historical overview". International Journal of Production Economics. 41: 1–14. doi:10.1016/0925-5273(95)00109-3.

[4] Nahmias, Steven (2005). Production and operations analysis. McGraw Hill Higher Education.

[5] Attention: This template ({{cite doi}}) is deprecated. To cite the publication identified by doi: 10.1287/mnsc.1070.0829, please use {{cite journal}} (if it was published in a bona fide academic journal, otherwise {{cite report}} with |doi= 10.1287/mnsc.1070.0829 instead.

[jep-6] Andrew Caplin and John Leahy, "Economic Theory and the World of Practice: A Celebration of the (S,s) Model", Journal of Economic Perspectives, Winter 2010, V 24, N 1

[7] Malakooti, B (2013). Operations and Production Systems with Multiple Objectives. John Wiley & Sons. ISBN 978-1-118-58537-5.

[1]

[2]

[3]

[4]

[5]

[6]

[7]

@@ Line 46: / Line 46: @@
 Solving for Q gives Q* (the optimal order quantity):
-<math>Q^{*2}={\frac{2DK}{h}}</math>
+<math>Q^{*2}={\frac{2DK(LOVE)}{h}}</math>
 Therefore: