Contents 1. Executive Summary -03 2. Introduction -03 3. Objective of study -06 4. Research Methodology -06 5. Analysis and interpretation of data -07-13 6. Conclusion -13 7. References -15 EXECUTIVE SUMMARY Inventory management is big issue today, it gives one company competitive edge over other companies.

The word inventory refers to any kind of resource having economic value and is maintained to fulfill the present and future needs of an organization. Fred hansman defined inventory as an idle resource of any kind provided such a resource has economic value.

Don't use plagiarized sources. Get Your Custom Essay on

Economic Order Quantity

Just from $13,9/Page

Inventory of resources is held to provide desirable service to customers and to achieve sales turnover target. Investment in large inventories adversely affects firm’s cash flow and working capital as investment in inventory represents substantial portion of total capital investment in any business.

It is in therefore essential to balance the advantage of having inventory of resources and the cost of maintain it so as to determine an optimal level of inventory of each resource so that total inventory cost is minimum.

Holding of stock is expensive so controls are needed to ensure that stock level remains as low as possible. Stocks should be controlled using rational policies to balance between holding cost and demand. One such policy is ordering ECONOMIC ORDER QUQNTITY for stock replenishment at this point holding cost reduces significantly and total annual inventory cost is lowest.

Though maintaining exact EOQ is sometime not possible working in the vicinity of it results in lower total annual inventory cost. Holding cost is straight line that is it directly varies with ordering quantity (according to classic EOQ model) is fairly true if product is non perishable, but in real life situation and specially in the case of perishable item it is a curve, we will see it through data provided by Spenser’s mall through examples and regression analysis. This happens because in case of perishable items holding cost is not constant again threat of spoilage forces companies to adopt mark down policy.

We will check through linear regression the relation of holding cost with time and quantity that it is a curve in case of perishable items. Introduction In the era of recession every firm is trying to cut their cost and inventory cost plays a vital role in this. Managing inventory properly is an important means of controlling costs and, thereby, improving the profitability of firm. Since a higher quantity is not best … and a lower quantity is not best … there must be some “Economic order quantity (EOQ)” which minimizes the total variable costs of inventory.

Total variable costs are usually computed on an annual basis and include two components, the costs of ordering and holding inventory. Annual ordering cost is the number of orders placed times the marginal or incremental cost incurred per order. This incremental cost includes several components: – The costs of preparing the purchase order, paying the vendor’s invoice, and inspecting and handling the material when it arrives. It is difficult to estimate these components precisely but a ballpark figure is good enough. The holding costs used in the EOQ should also be marginal in nature.

Holding costs include insurance, taxes, and storage charges, such as depreciation or the cost of leasing a warehouse. Some of the firms also include the interest cost of the money tied up in inventory. In classic EOQ model as the quantity increases holding cost increases proportionally i. e. it remains linear to the function of time but in real life the cumulative holding cost is a convex function of time curve because the handling and holding costs together increases with cumulative increase in cost per day because of wastage, pilferage and obsolescence.

This happens in the case of perishable goods, such as milk and produce, sold in small to medium size grocery stores, because these products are perishable, meeting a constant demand over time with an aging product may require markdowns in their prices or removal of spoiled products. The use of either practice can be molded as convex holding costs with time. Objective of study: To develop EOQ model ,calculate EOQ of an item and show that at this point total annual inventory cost is minimum and to show that holding cost is not constant it varies with time in case of perishable items that is it is not straight line but a curve.

METHODOLOGY We visited Spencer’s mall. We find out economic order quantity by classic EOQ model. EOQ provides information about how much to order, it is the point where trade off between annual holding cost and annual order cost and total inventory cost is minimum. In real life holding cost in not constant as assumed by classic EOQ model where it is a straight line, it is actually a curve. We show through regression analysis the dependability of holding cost on number of days. Elements of Inventory Cost:- Many inventory decision rules involve economic criteria.

Thus, it is very important to understand the cost of inventory, which may be broken down into the following details. Item Cost – This is the cost of buying/producing the individual inventory items. Item cost may be lowered by mass production due to the economies of large scale. Item cost of a bulk purchase is often lowered by a bulk (trade) discount. Cash (settlement) discounts may not be taken into account because an early payment decision is usually not within the inventory management system. Freight cost (also import duties and so on) may be part of the item cost if t varies with the number of items purchased. The item cost can usually be estimated, with good accuracy, directly from historical records. Ordering/Setup cost – The ordering cost is associated with ordering a batch or lot of items. Ordering cost does not depend on the number of items ordered; it is assigned to the entire batch. This cost includes: typing cost and postage of the purchase order, bank charges on letter of credit and bill process, expediting the order, receiving and inspection costs, and so on. Transportation cost and handling charges may be included if they are fixed per order of purchase.

Similarly, for a manufacturing concern, setup cost is those costs associated with placing an order of a batch of items to be produced irrespective of the number of items in the batch. It includes: paperwork of the production order, costs required to set up the production machine for a run, chasing the order, and so on. The ordering/setup cost can also be determined from company records. However, difficulties are sometimes encountered in separating fixed and variable cost components. The ordering cost should include only the fixed costs for each order irrespective of its size for decision making purposes. Holding (or Carrying) Cost –

The holding cost is associated with keeping items in inventory for a period of time. It is typically charged as a percentage of the item cost per unit time. The holding cost usually consists of three components: (a) Opportunity cost of capital – When items are carried in inventory, the capital invested is not available for other purposes. (b) Cost of storage – This cost includes variable space cost, insurance, wages, protective clothing/containers, and so on. In theory, only variable costs are included because fixed costs remain unchanged for different sizes of reorder quantity when we, say, consider the economic order quantity. c) Costs of obsolescence, deterioration and loss – Obsolescence costs, including possible rework or scrapping, should be assigned to items which have a high risk of becoming out of fashion. Perishable goods should be charged with deterioration costs which include costs of preventing deterioration. The costs of loss include pilferage and breakage costs associated with holding items in inventory. The holding cost is more difficult to determine accurately. The opportunity cost of capital cannot be directly derived from historical records but may only be estimated on the basis of current financial considerations.

Costs of storage, obsolescence and etc can be estimated from company records plus special cost studies; however, it is difficult to separate the fixed and variable components and only to include those variable ones into the holding cost. The effect of price level changes is the most difficult one for estimation. Stockout Cost – It reflects the economic consequences of running out of stock. There are two cases here. First, items are backordered. Second, the sales are lost. In cases, the cost of administration on backorders, the loss of profit from the sales forgone, and the savings on holding less inventory may be calculated.

However the loss of goodwill or future business associated with both cases is very difficult to calculate and is often handled indirectly by specifying an acceptable stockout risk level. EOQ MODEL: – The economic order quantity model is a classic independent demand inventory system that provides many useful ordering decision . the basic question the correct order size to minimize total inventory cost . this issue revolves around the trade off between annual holding cost and annual order cost . the EOQ model seeks to determine an optimal order quantity where the sum of annual order cost and the annual inventory holding cost is minimized .

Assumptions of the economic order quantity model 1 the demand is known and constant. 2 delivery times is known and constant 3 replenishment is instantaneous 4 prices is constant 5 the holding cost is known as constant 6 ordering cost is known and constant 7 stock outs are not allowed Derivation of EOQ: The economic order quantity can be can be derived easily from the total annual inventory cost formula using simple calculus the total inventory cost is the sum of the annual purchase cost , the annual holding cost and the annual order cost. The formula can be shown as Q=EOQ=22ABC Where A=Annual reqt.

B=Total Ordering Cost. C=Total Carrying Cost. LET us take an example Annual requirement(A) =7200 units Order cost (B) =100 per order Carrying cost (C) =50 per unit. Then, EOQ=2(2*7200*100)/50 =169. 7 units We consider a variation of the economic order quantity (EOQ) model where cumulative holding cost is a nonlinear function of time. we here show how it is an approximation of the optimal order quantity for perishable goods, such as milk, and produce, where there are delivery surcharges due to infrequent ordering, and managers frequently utilize markdowns to stabilize demand as the product’s expiration date nears.

We show how the holding cost curve parameters can be estimated via a regression approach from the product’s usual holding cost (storage plus capital costs), lifetime, and markdown policy. The model is a variation of the economic order quantity (EOQ) model where cumulative holding cost is a convex function of time; this is in contrast with the classic EOQ model where holding cost is a linear function of time. CONCLUSION: Every store wants to minimize its inventory cost . inventory is necessary to provide expected level of customer service ,lack of inventory can will result in lost sale which will reduce profit.

But inventory blocks working capital at the same time perishable item will be spoiled and causes loss. If inventory is high it blocks cash flow and working capital. inventory cost has three components material cost ,holding cost and order cost, high inventory results in higher holding cost (specially in case of perishable materials) and lower order cost, if inventory is low it reduces holding cost and increases ordering cost ,ramification is increased total inventory cost. ECONOMIC ORDER QUANTITY is that point at which trade off between inventory holding cost and annual order cost occur and total annual inventory cost is minimum.

In this report we have shown that how EOQ gives minimum inventory cost (for a non perishable item). Classic economic order quantity theory assumes constant holding cost but in a real life holding cost is not constant for perishable goods it increases commutatively and we have shown that its plot is a curve due to its nature through linear regression y and other factors can be calculated and economic order quantity can be found which results in lower total annual inventory cost. Reference: i TECHNIQUES: J K SHARMA 2. http://en. wikipedia. org/wiki/EOQ