Free Essay

The Eoq Formula

In:

Submitted By sunshine98
Words 1199
Pages 5
The EOQ formula can be modified to determine production levels or order interval lengths, and is used by large corporations around the world, especially those with large supply chains and high variable costs per unit of production. ("Economic order quantity," 2010) Inventory is held to avoid the nuisance, the time and the cost etc. of constant replenishment. However, to replenish inventory only infrequently would necessitate the holding of very large inventories. It is therefore apparent that some balance or trade-off or compromise is needed in deciding how much inventory to hold, and therefore how much inventory to order. There are costs of holding inventory and there are costs of re-ordering inventory and these two costs need to be balanced. The purpose of the EOQ model is to minimise the total costs of inventory. The important costs are the ordering cost, the cost of placing an order, and the cost of carrying or holding a unit of inventory in stock. All other costs such as, for example, the purchase cost of the inventory itself, are constant and therefore not relevant to the model. ("Economic order quantity," 2009)
What creates the cost components are annual usage/demand, order cost, and carrying costs. Annual usage and demand is expressed in units this is generally the easiest part of the equation. You simply input your forecasted annual usage. Order costs also known as purchase cost or set up cost, this is the sum of the fixed costs that are incurred each time an item is ordered. These costs are not associated with the quantity ordered but primarily with physical activities required to process the order. For purchased items these would include the cost to enter the Purchase Order and/or Requisition, any approval steps, the cost to process the receipt, incoming inspection, invoice processing and vendor payment, and in some cases a portion of the inbound freight may also be included in order cost.
It is important to understand that these are costs associated with the frequency of the orders and not the quantities ordered. For example in your receiving department the time spent checking in the receipt, entering the receipt and doing any other related paperwork would be included while the time spent repacking materials, unloading trucks, and delivery to other departments would likely not be included. If you have inbound quality inspection where you inspect a percentage of the quantity received you would include the time to get the specs and process the paperwork and not include time spent actually inspecting, however if you inspect a fixed quantity per receipt you would then include the entire time including inspecting, repacking, etc. In the purchasing department you would include all time associated with creating the purchase order, approval steps, contacting the vendor, expediting, and reviewing order reports, you would not include time spent reviewing forecasts, sourcing, getting quotes (unless you get quotes each time you order), and setting up new items. ("Economic order quantity," 2010)
In manufacturing the Order cost would include the time to initiate the work order, time associated with picking and issuing components excluding time associated with counting and handling specific quantities, all production scheduling time, machine set up time, and inspection time. Production scrap directly associated with the machine setup should also be included in order cost as would be any tooling that is discarded after each production run. There may be times when you want to artificially inflate or deflate set up costs. If you lack the capacity to meet the production schedule using the EOQ you may want to artificially increase set up costs to increase lot sizes and reduce overall set up time. If you have excess capacity you may want to artificially decrease set up costs, this will increase overall set up time and reduce inventory investment. The idea being that if you are paying for the labor and machine overhead anyway it would make sense to take advantage of the savings in reduced inventories.For the most part Order cost is primarily the labor associated with processing the order however you can include the other costs such as the costs of phone calls, faxes, postage, envelopes, etc.
Carrying cost also known as inventory holding costs is the cost associated with having inventory on hand. It is primarily made up of the costs associated with the inventory investment and storage cost. For the purpose of the EOQ calculation, if the cost does not change based upon the quantity of inventory on hand it should not be included in carrying cost. In the EOQ formula, carrying cost is represented as the annual cost per average on hand inventory unit. Below are the primary components of carrying cost.
Interest.
If you had to borrow money to pay for your inventory, the interest rate would be part of the carrying cost. If you did not borrow on the inventory however have loans on other capital items, you can use the interest rate on those loans since a reduction in inventory would free up money that could be used to pay these loans. If by some miracle you are debt free you would need to determine how much you could make if the money was invested.Insurance. Since insurance costs are directly related to the total value of the inventory, you would include this as part of carrying cost. Taxes. If you are required to pay any taxes on the value of your inventory they would also be included. ("Economic order quantity," 2009)
Storage Costs. Mistakes in calculating storage costs are common in EOQ implementations. Generally companies take all costs associated with the warehouse and divide it by the average inventory to determine a storage cost percentage for the EOQ calculation. This tends to include costs that are not directly affected by the inventory levels and does not compensate for storage characteristics. Carrying costs for the purpose of the EOQ calculation should only include costs that are variable based upon inventory levels. ("Economic order quantity," 2010)
If you are running a pick/pack operation where you have fixed picking locations assigned to each item where the locations are sized for picking efficiency and are not designed to hold the entire inventory, this portion of the warehouse should not be included in carrying cost since changes to inventory levels do not effect costs here. Your overflow storage areas would be included in carrying cost. Operations that use purely random storage for their product would include the entire storage area in the calculation. Areas such as shipping/receiving and staging areas are usually not included in the storage calculations, however if you have to add an additional warehouse just for overflow inventory then you would include all areas of the second warehouse as well as freight and labor costs associated with moving the material between the warehouses.

Economic order quantity (eoq). (2009). Retrieved from http://www.accountingformanagement.com/economic_order_quantity

Economic order quantity (eoq). (2010). Retrieved from http://www.inventoryops.com/economic_order_quantity

Economic order quantity. (2010). Retrieved from http://www.investopedia.com/terms/e/economicorderquantity.asp

Economic order quantity (eoq). (2009). Retrieved from http://en.wikipedia.org/wiki/Economic_order_quantity

Economic order quantity (eoq). (2008). Retrieved from http://scm.ncsu.edu/public/inventory/6eoq.html

Similar Documents

Premium Essay

Economic Order Quantity

...Economic Order Quantity (EOQ) Economic order quantity (EOQ) is the order quantity of inventory that minimizes the total cost of inventory management. Two most important categories of inventory costs are ordering costs and carrying costs. Ordering costs are costs that are incurred on obtaining additional inventories. They include costs incurred on communicating the order, transportation cost, etc. Carrying costs represent the costs incurred on holding inventory in hand. They include the opportunity cost of money held up in inventories, storage costs, spoilage costs, etc. Ordering costs and carrying costs are quite opposite to each other. If we need to minimize carrying costs we have to place small order which increases the ordering costs. If we want minimize our ordering costs we have to place few orders in a year and this requires placing large orders which in turn increases the total carrying costs for the period. We need to minimize the total inventory costs and EOQ model helps us just do that. Total inventory costs = Ordering costs + Holding costs | By taking the first derivative of the function we find the following equation for minimum cost EOQ = SQRT(2 × Quantity × Cost Per Order / Carrying Cost Per Order) | Example ABC Ltd. is engaged in sale of footballs. Its cost per order is $400 and its carrying cost unit is $10 per unit per annum. The company has a demand for 20,000 units per year. Calculate the order size, total orders required during a year, total...

Words: 1326 - Pages: 6

Premium Essay

Case 3 B&L Inc.

...November  3,  2011         MGMT  3624  -­‐  Case  3:    B&L  Inc.     Assignment   1) What  do  you  think  of  the  quote  from  Mayes?     • How  would  you  respond?     • What  information  would  you  request?   2) Can  Brian  Wilson  use  the  EOQ  formula  here  to  establish  the  lot  size?     • Do  all  of  the  EOQ  assumptions  hold  here?   3) Do  you  think  B&L  should  outsource  the  bracket?     • Why  or  why  not?   4) What  would  you  say  to  the  plant  manager?   5) Is  the  cost  savings  sufficient  enough  to  move  the  business  to  Mayes?   Assume  that  you  were  in  the  position  of  Brian  Wilson:   What  would  be  your  analysis  of  the  opportunity  to  outsource  the  outrigger   bracket?   B. If  B&L  was  to  outsource  the  outrigger  bracket  to  Mayes,  what  lot  sizes  would   you  specify  and  why?  (Note:  You  must  address  this  question,  regardless  of   your  response  to  Question  A.)   A.     MGMT  3624  Case  3:    B&L  Inc....

Words: 3917 - Pages: 16

Premium Essay

Retailing

...104 2. The BOM inventory for July is: 3202146.922 3. Monthly reductions for September in dollars are: 631736.68 4. Monthly additions for October are: 4465620.22 5. EOM inventory for September is: 3202146.922 Part II: Solve the problems below related to chapter 16. This is also on the video. 1. What should be the initial markup percent in a department having the following figures? (Formula page 412 – required initial markup percentage). Net sales = $150,000 Profit = $7,000 Expenses = $45,000 Reductions = $12,000 Initial markup percentage = 640000/162000 = 39.5% 2. What should be the Reductions in a department having the following figures? (Formula page 412 – required initial markup percentage). Net sales = $150,000 Profit = $6,000 Expenses = $60,000 Initial markup percentage = 52.33% Reductions = 26211.45 3. Given the following information, calculate open to buy at retail and cost (formula page 411. You will have to calculate planned purchases first using the formula on the same page and then use the formula for open to buy) Sales = $30,000 Reductions (markdowns)= $2,000 EOM inventory = $30,000 BOM inventory = $36,000 Purchase commitments (on order) = $6,000 Cost complement (cost as % of selling price) = 60% PLANNED PUR =30000+2000+30000-36000 =26000 OTB(RETAIL) = 26000-6000 = 20000 OTB(COST)= 20000 * 60% =12000...

Words: 415 - Pages: 2

Premium Essay

The Eoq Model

...THE EOQ MODEL Name: Course: Tutor: Date: The EOQ Model The types of costs minimized by the EOQ formula The first one is the inventory holding cost, which is a representative of the capital cost incurred by the management. This covers all the costs spent on units, the space the units consume, deductions on inventory, and the desuetude allowances. These costs are measured as a product of unit and time, which define the rate of demand. The other cost is the cost on fixed orders. This represents all costs incurred in order placements but excludes the unit costs. Thus, this costs accounts for the costs incurred in the receiving and the placing of an order. When it comes to the case of manufacturing, it accounts for the costs of putting in place the necessary equipment in the production of order-quantity. These costs are very significant and must thus, be accounted for in any company (Schwarz, 2008). The difference between the POQ model and the EOQ model The EOQ model considers a tradeoff between the cost of ordering and the storage cost when choosing the amount to use in the replenishment of item inventories. The quantity of order is quite affected by the ordering frequency and this extends to affect the cost of ordering. Holding a larger inventory in average increases the storage costs in that particular month. On the other hand, the POQ model considers one product at any particular time. This is because the materials for production...

Words: 641 - Pages: 3

Premium Essay

Simulation of Inventory System

...University of Dhaka Department of Management Information systems MBA (Evening) Program Semester : Summer, 2015 Course Name : Simulation and System Modeling (EMIS 521) Instructor : Dr. K. M. Salah Uddin Designation : Associate Professor Prepared by a group consisting of following members: Name | ID No. | Nakib H. Khan | :17-030 | Rokshana Akter | :17-018 | Taslima Parvin | :19-059 | Rezaul Hasan Bhuiyan | :19-075 | Md Anisur Rahman | :20-021 | Md Shahriar Shaon | :21-071 | Date of Submission and Presentation: August 30, 2015 Letter of Transmittal August 30, 2015 Dr. K. M. Salah Uddin Associate Professor Department of Management Information Systems University of Dhaka MBA (Evening) Program Subject: Term Paper on Simulation of Inventory System. Dear Sir, As this term paper is an inseparable part of our Simulation and System Modeling course, we were asked to prepare a term paper on “Simulation of Inventory System”. We devoted our skills and knowledge to efficiently and effectively handle this task. While preparing the term paper, we utilized what we have learnt throughout the semester in this course and capitalized on this opportunity to acquire some in-depth knowledge regarding “Simulation of Inventory System”. We are pleased to we submit hereby the term paper for your kind evaluation. We are always available if it is necessary for any query. Sincerely yours, Md Anisur Rahman ID # 20- 021 In favor of the group ...

Words: 5908 - Pages: 24

Premium Essay

Medical Laser Equipment

...propose a new modeling scenario. As a fact, most of the popular statistical techniques assume that studied data are normally distributed under certain conditions. Therefore, a normality test was performed to: Test if demand is well-modeled by a normal distribution or not. Find out descriptive statistics about the demand distribution such as mean, standard deviation and P-value. Test result revealed that the demand is normally distributed with: Mean = 0.664 Standard Deviation = 0.776 P-Value < 0.005 Below are graphical presentations for test results. USED FORMULAS AND ABBREVIATIONS Before starting our calculation of the current situation and the proposed models, we will present the used formulas and abbreviations: EOQ= √((2*D* C_P)/C_H ) TBO= EOQ/d TARGET=d [∑_(t=1)^(Z-1)▒〖t+(TBO-Z)*Z 〗] TC = (C_P*q)+( ( I ) ̅* C_H) ROP = Averager DDLT + SS SS=Z √L* σ_d EOQ = Economic Order Quantity D = Annual Demand C_P= Order Cost...

Words: 1165 - Pages: 5

Premium Essay

Three Jays Coorpoation Case Studa

...objectives of the company. Current Situation Three Jays, as I have learned, is a company which produces and distributes organic jams and jellies. To sustain the growth rate of the last three years, it is necessary to launch a marketing campaign, which would have an estimated return of 20%. However, it is not possible to do so unless the current inventory levels of finished goods are reduced. Updating the EOQ/ROP procedure I began my work by updating the EOQs (Economic Order Quantities) and ROPs (Reorder Points) for the five different SKUs (Stock-keeping Units) scheduled to be produced in the last week of June (see Annex 1 for nomenclature of the different SKUs). This update was necessary in order to account for the increase in demand in the last year. The requirement to produce a given amount of a SKU is generated each time the stock level for that SKU falls bellow its ROP, which equals three weeks of inventory for each SKU based on average weekly demand, as determined by the sales for the company's first full year of operations. The result was a higher EOQ and ROP for every single SKU (see Annex 1), which would mean that the company would need a greater inventory level, which is contrary to the goals which they are currently trying to...

Words: 2106 - Pages: 9

Premium Essay

Operations Management

...unit cost into yearly sales. SP stands for total cost. * The Column F stands for the demands per week which is calculated by the division of last 12 month sales by 52 weeks * The Column G stands for the whole number. * The column H stands for the Reorder units * The column I stands for inventory in last year end * The column J stands for total inventory which is an addition of reorder units and inventory in year end * The column K determines the stock cover for every item * The column L stands for stock turn * The column M stands for stock for 52 weeks * The column N stands for stock week for 10 weeks * The column O and the column P shows the ABC analysis * The column Q determines the EOQ for A items * The values are categorized by their catalogue reference number....

Words: 1122 - Pages: 5

Premium Essay

Nothing to Say

...Operations Management I 73-331 Winter 2012 Odette School of Business University of Windsor Midterm Exam II Solution Saturday, March 24 Education Building Room ED 1101 Aids Permitted: Calculator, straightedge. Time available: 1 hour 20 min Instructions: 0 This exam has 12 pages including this cover page and excluding 5 pages of formula and table. 1 Please be sure to put your name and student ID number on each odd numbered page. 2 Show your work. 3 State results up to four decimal places. 4 Do not return tables and formula. Grading: Question Marks: 1 /10 2 /15 3 /15 4 /10 5 /15 Total: /65 Question 1: (10 points) Circle the most appropriate answer 1.1 Which of the following is a type I error? a. Process is in-control, but the sample measurement lies outside limit b. Process is out-of-control, but the sample measurements lie within the limit c. Process is in control, and the sample measurements lie within the limit d. Process is out-of-control, and the sample measurement lies outside limit 1.2 Which of the following control charts is the cheapest a. X char b. R chart c. p chart d. 3 sigma chart 1.3 Type II error increases if a. sample size increases c. control limits are narrower d. control limits are wider 1.4 If EF=12 and LF=12 for the same activity, then a. Slack time of the activity is 12 b...

Words: 1582 - Pages: 7

Free Essay

Bp Cheatsheet

...Waiting Time Formula, Multi Parallel Resources (Servers) Utilization, u = (1/a)/(m x 1/p) = p/am Tq = (p/m) x (u^[√(2(m+1)-1)-1]/(1-u) x (CVa2+CVp2)/2 Iq = (1/a)*Tq Ip = u*m = (1/a)*p I = Iq + Ip Flow Time = Tq + p Waiting Time Formula, Multi Parallel Resources (Servers) Utilization, u = (1/a)/(m x 1/p) = p/am Tq = (p/m) x (u^[√(2(m+1)-1)-1]/(1-u) x (CVa2+CVp2)/2 Iq = (1/a)*Tq Ip = u*m = (1/a)*p I = Iq + Ip Flow Time = Tq + p Waiting Time Formula, Single Server Utilization, u = Flow Rate/Capacity = (1/a)/(1/p) = p/a Inventory Related Measures Iq = (1/a) x Tq Ip = u I = Iq + Ip Time in queue, Tq = Activity Time (p) x (u)/(1-u) x (CVa2+CVp2)/2 Flow Time = Tq + p Waiting Time Formula, Single Server Utilization, u = Flow Rate/Capacity = (1/a)/(1/p) = p/a Inventory Related Measures Iq = (1/a) x Tq Ip = u I = Iq + Ip Time in queue, Tq = Activity Time (p) x (u)/(1-u) x (CVa2+CVp2)/2 Flow Time = Tq + p Inter-Arrival Time, a = amount of time between two arrivals to a process Arrival process is Stationary over a period of time if the number of arrivals on any sub interval depends only on length of interval, not on when interval starts a = average inter-arrival time (IAi+1 – IAi) Sa = standard deviation (absolute measure of variability) CVa = Standard deviation/average inter-arrival time (Sa/a) – relative variability CVp = Standard deviation/Average activity time (Sp/p) Abnormal peaks of processing time Would be more efficient to automate...

Words: 1446 - Pages: 6

Premium Essay

Accounting Information System

...system (AIS). There are some complicated issues regarding the inventory and the AIS contributes a lot to the solutions for these problems. Among those issues, to determine the correct quantity to have on hand should be paid attention to, because the effective management of the inventory’s quantity can lead to a cost-saving effect. First of all, one question will be asked: what does the “correct” quantity mean? Actually, based on the effects mentioned above, the correct quantity is closely related with an economic level of inventory. There are a few formulas and concepts of the quantity and cost of inventory. Maximum inventory level Maximum inventory level equals the sum of the economic order quantity (EOQ) and the safety stock. The EOQ refers to the optimum order size when the holding costs and the ordering costs are equal with the assumption that no seasonality in sales exist. During the process of determine the EOQ, a corporation need to balance the cost of holding merchandise and the cost of ordering merchandise. (1) The cost of holding: 1) Lead-time: the period of time between the ordering of product and its receipt from a vendor 2) Lead-time stock: the amount of stock necessary to cover sales during lead-time without dipping into safety stock 3) Reorder point: the sum of the safety stock and the lead-time stock (2) The cost of ordering mainly involves the creation of purchase order (PO), sending PO to the vendor, handling the merchandise when received...

Words: 276 - Pages: 2

Premium Essay

Production Systems

...Production Systems Assumptions: * available set of machine technology is fixed (short term production control decisions) * organization of production has been determined Production system * collection of material, labour, capital, and knowledge that goes into manufacture of a product * how the collection of components is put together in a specific situation defines a particular system Taxonomy of Production Systems * by different criteria and meaningful analysis applied * by production flow characteristics Production processes can be either continuous or discrete (or one at a time fashion). Three Major Building Blocks in a Production System 1. Machine Technology Base (or the Tools for Production) * Sets boundaries on the processes that can be employed in converting inputs to finished products * Long term planning decisions * Major component of productivity improvement 2. Organization * Product layout * Organizes people and machines that is satisfactory for the production of a single product * Sequential operations * Flow line organization of a production * Process layout * According to the manufacturing process involved in the production of products * Machinery is grouped based on common purposes * When there are a large number of different products using the same machinery but not necessarily in the same order * Job shop ...

Words: 2454 - Pages: 10

Premium Essay

Inventory Management

...INVENTORY MANAGEMENT AND CONTROL* INVENTORY MANAGEMENT AND CONTROL concerns most managers of agricultural marketing and supply businesses, whether they are retail, wholesale, or service oriented. The value of a manager to an agricultural marketing and supply business depends on his ability to manage inventories effectively. The total cost of maintaining the desired inventory level must be held down to a reasonable figure, but the inventory must also be large enough to permit the company to effectively merchandise the products and services it sells. If the manager doesn't control his inventories to accomplish both of these objectives, the business may not be able to prosper or even to survive against competition. The information in this circular suggests to the manager ways on how best to do four things: Y How to control inventories. Y How to visualize the inventory costs to be included in determining how much inventories are costing the company. Y How to determine the level of inventory that is most profitable. * Y How to determine how much to order and how often to order. Controlling Inventories Purchase systematically. Place orders for materials long enough beforehand so there will not be a shortage between ordering and delivery. Let the inventory become relatively low before reordering but keep enough on hand to meet current needs. There are costs associated with keeping large inventories. Likewise, there are costs if you deplete your stock. Don't hold “dead” lines...

Words: 3513 - Pages: 15

Premium Essay

Economic Order Inventory Control Model

...the process of analyzing the company’s current forecasting model and recommending an inventory control model by ordering optimum units to help them solve their current issue. As a result, an Economic Order Quantity (EOQ) and a variable cost was recommended to help them reduce their product stock outs. The shortage of raw material for production always makes the process discontinuous and reduces the productivity. The ABC analysis technique for the inventory control system is first used to identify the most important multiple products and then the economic order quantity (EOQ) of each product is...

Words: 1213 - Pages: 5

Premium Essay

Very Important ...Term Paper

...indicated that the cost per unit could vary anything from Rs.70 to Rs.100 (a discrete uniform distribution with the average of Rs.85 and range of Rs.30). From the indications given by the bankers of the company, it is likely that the next year carrying cost as a percentage of Cost per Unit would follow normal distribution with mean of 4% and standard deviation of 1.5%. The cost of placing the order follows subjective normal probability distribution as follows:- Cost of Rs.10 15% Rs.15 30% Rs.20 40% Rs.25 10% Rs.30 5% Simulate the possibilities with 3,000 trials. The EOQ is given by EOQ = Where Q is the annual Demand, CO is ordering cost per order, CU is Cost per unit and CC% is carrying cost in percentage terms. The Uniform Distribution variable can be converted in Triangular Distribution variable by using the following Formula =IF(r<=(c-a)/(b-a), a+SQRT(r*(b-a)*(c-a)),b-SQRT((1-r)*(b-a)*(b-c)) Where ‘r, ‘a’, ‘b’ and ‘c’ having usual...

Words: 366 - Pages: 2