| ||||||||
| ||||||||
|
A few months ago we published an article entitled "Trimming Inventory While Maintaining a High Level of Customer Service." In that article, we suggested that you "micro-manage" your fast-moving products by ensuring that forecasts are accurate and that the "safety stock" is monitored. In this article, I am advising you to reevaluate the Economic Order Quantity (EOQ) and the order-cycle quantities for your high-cost items with recurring usage that are supplied by a reliable vendor. The EOQ is that quantity of a product that will minimize your total cost of inventory per piece. The EOQ is typically applied to items with recurring usage that are items sold or used on a regular basis. It "balances" the three costs you incur as you buy and maintain the stock of a product in your warehouse:
There are many versions of the EOQ formula. All of them are designed to maximize profitability. However, in today's economy we see many companies emphasizing "cash flow management" over profitability that is, they are willing to sacrifice some profit dollars in order to invest smaller amounts in inventory. If you find yourself in this situation, closely examine the EOQ quantities calculated by your computer system in terms of the day's supply of inventory it represents:
The monthly forecast is divided by 30 to calculate an approximate forecast per day. For example:
Monthly Forecast = 45 60 ÷ (45 ÷ 30) 60 ÷ 1.5/Day = 40-Day Supply A monthly forecast of 45 pieces is about 1.5 pieces per day. The EOQ of 60 represents a 40-day supply (60 ÷ 1.5/day). Compare the results to the value of the product sold or used during the order cycle for each supplier. The order cycle (also known as the review cycle) is the typical length of time between replenishment shipments being received from the vendor. For example, you may receive shipments from the primary vendor for this line every 10 days. If you include this item on each order, you can order a ten-day supply (10 Days x 1.5/Day = 15 pieces). Compare the value of the EOQ and order cycle replenishment quantities. This particular product costs $7.50 per piece:
Order Cycle Quantity Value = 10 x $7.50 = $75 This lower 10-day reorder quantity of this product results in buying $375 less inventory and would not affect either anticipated lead-time usage or safety-stock quantity. These are elements of the minimum or "order point" quantity which will ensure that you reorder the product at the "right" time in order to avoid a stockout. As a result:
©2009 Effective Inventory Management, Inc. All rights reserved. This article may not be distributed, reprinted, or reproduced, in whole or in part, without the expressed written permission of Effective Inventory Management, Inc.
|
||||||||
[ Home | About EIM | EIM Store
| Seminars | CD | Book ]
[ Spreadsheets | Services
| Articles | Links
| Email ]
Effective Inventory Management, Inc.
215 South Denton Tap Road, Suite 230
Coppell, TX 75019
(972) 304-3325
Fax: (972) 393-1310
Email: info@effectiveinventory.com