Formula of Calculating Economy Order Quantity (EOQ Formula & Example)




There are different ways to use variables in order to calculate the economic order quantity for an inventory. In order to calculate the formula of EOQ lets assume the following parameters:-
Q= the Order Quantity
Q* = the optimal or economic order quantity
D = Annual Demand of the Material
S = Fixed Cost associated with each order
H = Annual holding cost associated with the each unit of the order
In the above mentioned parameters the fixed costs are the costs that remain constant such as shipping cost, cost of handling the goods and delivery cost of the goods. The actual production cost of the goods is not included in the fixed costs.
Now we can find out the Total cost associated with each item of the order
Total Cost = Purchase cost of the order + Ordering cost + handling cost of the order
Where,
Purchase Cost = it is the variable cost that is associated with each unit of the order. It can be calculated as under:-
Purchase cost= unit purchase price x the annual demand quantity of the order
PC= P X D
Ordering cost is the cost that associated with placing the orders. As we know that each order has a fixed cost S associated with it. The number of orders we need to place per year are demand of the order divided by the order quantity. So ordering cost can be calculated as under
Ordering Cost = Fixed Cost x Demand / Order Quantity
OC = SD/Q
Now the last cost is the holding cost and it is the cost associated with holding the average order in the inventory for a specific period of time.
                Holding Cost = HQ/2
Now,
The Total Cost associated with the order = PD + SD/Q + HQ/2
Now assume that price and demand are constant and set to zero. In order to calculate the minimum point of the curve of cost we differentiate the total cost with respect to Q and set its value equals to zero. The resultant equation will be:-
                0= - DS/Q2 + H/2
                Q* = 2DS/H
                Q^2={\frac{2DS}{H}}
Example:-
Annual required quantity = 1000 units
Cost associated with each order = $2 per order
Cost per unit = $8
Holding cost per order = $0.16
Economic Order Quantity =   2Q x CO / CU x CC%
Economic Order Quantity =           2x 10000x 2/ 8 x 0.02
Economic Order Quantity = 500 units



Posted in | Leave a comment

Disadvantages of EOQ Analysis




One of the major disadvantages of the economic of quantity modal is that it involves tough and complex mathematical calculations. In order to calculate the EOQ modal a person must have significant knowledge of algebra and related concepts. It is not an appropriate method for the small business owners that are lacking skills in math and algebra. It also requires detailed data from various sources of the company to calculate the end result. For example it requires annual demands of the order, holding cost of the order, ordering cost of the order and the fixed cost of the order to calculate EOQ. 

Another drawback of this modal is that is solely based on assumptions. It assumes that the demand of the order will remain constant through out the year. Moreover it assumes that the purchase price of the order will not change over the year. It also assumes that there will be no change in fixed cost, holding cost and the ordering cost for the time period of a year. Another drawback is that it is limited to the one product business and can not calculate EOQ for the inventories dealing in multiple products. 

If high seasonality is involved in the consumption of the order the EOQ modal is unable to produce a satisfactory result. Moreover it proves beneficial if it is applied to a higher volume of the order that are going to be stored in the inventory.

Posted in | Leave a comment

Search Examples and Formula's

Advertisement

Join Us on Facebook

Accounting for Management - Accounting theme from Business Law.