Inventory Management Software Practices, Three Gurus Summarized

Title:	Inventory Management Solution
URL:	http://www.inventorymanagementgurus.info/
Cat:	Computers/Software/
Text:	inventory management software practices, gurus summarized inventory management software principles, gurus summarized management practices modern inventory management solutions began develop industrial revolution late s. soon inventory management training consultants developed programs educate distribution managers. software era paved road today inventory management consultants. graham videos books remain popular primers distribution inventory management companion volume, . views order history inventory management database brings power statistical analysis. methods coded wholesale distribution systems comprehensive inventory management software integrated erp package. bodenstab explains high practices book, . explains multiple techniques inventory management topic organized reference manual, third edition , schreibfeder continues improve revised editions. goal introduce techniques managers inventory management software resources learning. stock warehousing inventory management gurus provided , full service value added reseller infor industry leading distribution software. request . rule percent produces percent results applies inventory customers. develop authorized stock list warehouse procedures adding removing items. general, top selling inventory items stocked, slow movers special ordered. sales people confer best customers ensure needs stock items stocked. lesser customers special order look awhile. look opportunities drop ship. reduce damaged pilfered inventory, run clean, organized warehouse. establish cycle count schedule. forecasting replenishment system work quantities computer accurate. accuracy improved manual procedures scanners shipping receiving. branch locations business able price main location, branches so. items purchased competitive price consolidating orders company, slow moving items, purchased main location transferred branches. measuring forecasting demand sales history measure demand forecasting, requests demand data. adjust sales history exclude unusual orders. bodenstab recommends automatic filter sales history times mean average deviation forecast actual usage explained . graham offered forecast methods, non seasonal items season items. non seasonal items, simple average usage months. seasonal items, simple average months year ago adjust number estimate year vary year. bodenstab schreibfeder expand simple averages weighted averages exponential averages give greater weight to seasonally relevant demand. bodenstab continually refines forecast capturing forecast error month calculate actual mean average deviation. result filter sales history automatically. order consideration factors, optimal inventory level achieved ordering little possible. order placed day cover demand day inventory arrives. non seasonal items, however, factors consider. demand constant. costs associated processing orders. vendors sell case pallet quantities minimum order quantities total order. tiered price breaks best price freight rate combined orders fill truck container. result factors, producing good demand forecast calculating optimal order quantity. eoq economic order quantity eoq formula developed number variations abbreviations evolved. takes account costs associated placing, processing paying order. goal sweet spot reordering cost cost carrying cost cost , point referred lowest total cost inventory. carrying costs refer costs associated stocking inventory costs warehouse space, moving inventory warehouse, opportunity cost money purchase inventory, insurance taxes, inventory inventory shrinkage. inventory held year carrying costs usually percent. hand, stock ordered line item, lower reordering costs item. hand, stock ordered line item, lower carrying cost item. eoq calculations insure inventory making small portion sales attention ordered infrequently large quantities. inventory making large portion sales managed tightly ordered frequently small quantities. order point, safety stock, line point reorder target, minimums maximums order point daily usage rate times number days lead time plus safety stock accommodate unevenness demand. graham recommends putting safety stock additional percent. bodenstab recommends multiplying mean average deviation safety factor produce desired order fill rate. example, percent order fill rate mean average deviation multiplied . , percent . , percent . , percent . . key inventory items set higher target fill rates important inventory items. bodenstab calculation involves just lead time estimate order frequency. schreibfeder explains number methods determine safety stock. line point order point plus amount inventory expected sold order lead time. order placed, stock level line point ordered. bodenstab reorder target, similar concept line point, incorporates estimate order frequency equation. minimums maximums ways and, software systems, all. software systems minimum line point reorder target. items sporadic sales, minimum size typical order. maximum represents stock. price level discounts freight buying reduce purchase price freight cost negative effect increasing carrying costs. stocked year carrying cost percent, carrying cost stocked month carrying cost percent. optimal level sum purchase price freight cost plus carrying costs result lowest total cost inventory. example, price discount percent results extra month inventory ordered percent carrying cost good value. goal seeking software systems forecast demand, balance eoq line point equations, modify results fit price level goal full truck account case pallet quantities required vendor. controlling inventory levels order fill rates bringing inventory good management result inventory levels decrease order fill rates increase. however, cases, economic downturn, smart reduce inventory order fill rates. graham recommends reducing inventory higher number carrying cost, percent higher. bodenstab reduce target order fill rates. goal improved order fill rates, opposite measures called for. gmroi gross margin return inventory stock determined market forces described above. bean counter method validating market based decisions. learn visit definition . specialized topics interest inventory managers. familiar inventory management gurus provide ready reserve tools special situations.
Source:	ï»¿<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Inventory Management Software Practices, Three Gurus Summarized</title> <meta name="description" content="Inventory management software principles as recommended by Gordon Graham, Charles Bodenstab and Jon Schreibfeder. Links to software and more information." /> <link rel="stylesheet" type="text/css" href="style.css" /> </head> <body> <h1>Inventory Management Software Principles, Three Gurus Summarized</h1> <p>The management practices in modern inventory management solutions began to develop during the industrial revolution in the late 1800s. Soon after inventory management training consultants developed programs to educate distribution managers. In the software era <a href="http://www.thedistributionteam.com/index.php/Gordon-Graham-Distribution-Inventory-Management/About-The-Team-Home/cat_id/31246">Gordon Graham</a> paved the road for today's inventory management consultants. Graham's videos and books remain popular primers: <i>Distribution Inventory Management for the 1990s</i> (1987) and a companion volume, <i><a href="http://www.thedistributionteam.com/index.php/cat/Products-and-Services-Home/cat_id/31437">Distributor Survival in the 21st Century</a></i> (1992).</p> <p><a href="http://www.bodenstab.com/">Charles Bodenstab</a> views order history as an inventory management database and brings to it the power of statistical analysis. Many of his methods are coded into wholesale distribution systems and all of them into his own comprehensive <a href="http://www.bodenstab.com/software.asp">Mars-95</a> inventory management software that can be integrated to any ERP package. Bodenstab explains high-end practices in his book, <i><a href="http://www.bodenstab.com/books.asp">A New Era in Inventory Management for the Distribution Industry</a></i> (1993).</p> <p><a href="http://www.effectiveinventory.com/">Jon Schreibfeder</a> explains multiple techniques for each inventory management topic in a well-organized reference manual, <i><a href="http://www.effectiveinventory.com/book.html">Achieving Effective Inventory Management</a></i> (third edition 2005), which Schreibfeder continues to improve in revised editions. The goal here is to introduce the techniques managers will find in their inventory management software and these three resources for further learning.</p> <h1>What to Stock and Warehousing</h1> <div class="r"> Inventory Management Gurus is provided by <a href="http://www.multiportservices.com/">Multiport Services</a>, a full-service value added reseller of Infor's industry-leading distribution software. Request a free <a href="http://www.multiportservices.com/brochure.html">wholesale distribution software brochure</a>. </div> <p>The 80 / 20 rule -- 20 percent produces 80 percent of the results -- applies to inventory and to customers. Develop an authorized stock list for each warehouse and procedures for adding and removing items. In general, top selling inventory items are stocked, slow movers special ordered. Sales people should confer with the best customers to ensure their needs for in-stock items are stocked. Lesser customers can special order or even look elsewhere once in awhile. Look for opportunities to drop ship.</p> <p>To reduce damaged and pilfered inventory, run a clean, well-organized warehouse. Establish a cycle-count schedule. No forecasting and replenishment system will work well if the quantities in the computer are not accurate. Accuracy is improved over manual procedures by using scanners for shipping and receiving.</p> <p>When branch locations do enough business to be able to buy at the same price as the main location, then the branches should do so. For items that can only be purchased at a competitive price by consolidating orders across the company, like slow moving items, they should be purchased by the main location and transferred to the branches.</p> <h1>Measuring and Forecasting Demand</h1> <p>Use sales history to measure demand for forecasting, not item requests or demand data. Adjust sales history to exclude unusual orders. Bodenstab recommends an automatic filter on sales history of four times the mean average deviation between the forecast and actual usage (explained below).</p> <p>Graham offered two forecast methods, one for non-seasonal items and one for season items. For non-seasonal items, use a simple average of the usage for the last six months. For seasonal items, use a simple average of the next six months from a year ago and adjust the number with an estimate about how this year will vary from last year. Bodenstab and Schreibfeder expand simple averages with weighted averages (or exponential averages) to give greater weight to more recent or to more seasonally-relevant demand. Bodenstab continually refines the forecast by capturing the forecast error each month to calculate the actual mean average deviation. The result is also used to filter sales history automatically.</p> <h1>How Much to Order</h1> <p>Without consideration of other factors, the optimal inventory level is achieved by ordering as often and as little as possible. An order is placed every day to cover demand the day the inventory arrives. Even for non-seasonal items, however, there are other factors to consider. Demand is not constant. There are costs associated with processing orders. Vendors sell only in case or pallet quantities or have minimum order quantities for a total order. Then there are tiered price breaks or the best price or freight rate for combined orders that fill a truck or container. As a result of these and other factors, producing a good demand forecast is only the beginning of calculating an optimal order quantity.</p> <h1>EOQ (Economic Order Quantity)</h1> <p>Since the EOQ formula was developed in 1904 a number of variations and abbreviations have evolved. The idea takes into account the costs associated with placing, processing and paying for an order. The goal is to find the sweet spot between the reordering cost (R cost) and the carrying cost (K cost), a point referred to as the lowest total cost of inventory. Carrying costs refer to all the costs associated with stocking the inventory: the costs of warehouse space, of moving the inventory within the warehouse, of the opportunity cost of the money used to purchase the inventory, of insurance and taxes, of taking inventory and of inventory shrinkage. For inventory held for one year carrying costs are usually twenty-five to thirty-five percent. On the one hand, the more stock ordered per line item, the lower the reordering costs per item. On the other hand, the less stock ordered per line item, the lower the carrying cost per item. In use EOQ calculations insure inventory making up a small portion of sales will not get too much attention but be ordered infrequently in large quantities. Inventory making up a large portion of sales will be managed tightly and ordered frequently in small quantities.</p> <h1>Order Point, Safety Stock, Line Point and Reorder Target, Minimums and Maximums</h1> <p>The order point is the daily usage rate times the number of days lead time plus safety stock to accommodate unevenness in demand. Graham recommends putting the safety stock at an additional fifty percent. Bodenstab recommends multiplying the mean average deviation by a safety factor to produce a desired order fill rate. For example, for a 90 percent order fill rate the mean average deviation is multiplied by 1.6, for 95 percent by 2.0, for 97 percent by 2.4, and for 98 percent by 2.6. Key inventory items are set at higher target fill rates than less-important inventory items. Bodenstab's calculation involves not just lead time but also an estimate of order frequency. Schreibfeder explains a number of methods to determine safety stock.</p> <p>Line point is the order point plus the amount of inventory expected to be sold during the order lead time. When an order is being placed, any item whose stock level is below its line point should be ordered. Bodenstab's reorder target, a similar concept to the line point, again incorporates an estimate of order frequency into the equation.</p> <p>Minimums and maximums are used in many ways and, in some software systems, not at all. In some software systems the minimum is the same as -- or one more than -- the line point or reorder target. For items with sporadic sales, the minimum might be the size of a typical order. Maximum represents the most that should ever be in stock.</p> <h1>Price Level Discounts and Free Freight</h1> <p>Buying more of an item to reduce the purchase price or freight cost also has the negative effect of increasing the carrying costs. If an item stocked for a year has a carrying cost of twenty-four percent, then the carrying cost of an item stocked for a month has a carrying cost of two percent. The optimal level to buy is where the sum of the purchase price and freight cost plus the carrying costs result in the lowest total cost of inventory. For example, a price discount of three percent that results in an extra month of inventory being ordered at a two percent carrying cost is a good value.</p> <h1>Goal Seeking</h1> <p>Many software systems forecast demand, balance EOQ and line point equations, then modify the results to fit a price-level goal or a full truck while taking into account the case or pallet quantities required by the vendor.</p> <h1>Controlling Inventory Levels and Order Fill Rates</h1> <p>By bringing inventory under good management the result should be overall inventory levels decrease while order fill rates increase. However, in some cases, like an economic downturn, it might be smart to reduce both inventory and order fill rates. Graham recommends reducing the overall inventory by using a higher number for carrying cost, perhaps ten or even twenty percent higher. Bodenstab would reduce the target order fill rates. If the goal is improved order fill rates, then the opposite measures are called for.</p> <h1>GMROI (Gross Margin Return on Inventory)</h1> <p>What to stock should be determined by market forces as described above. There is a bean-counter method of validating these market-based decisions. To learn more visit the <a href="http://www.multiportservices.com/dictionary.gmr.html">GMROI</a> definition at the <a href="http://www.multiportservices.com/dictionary._.html">Multiport dictionary</a>. <p>There are many other specialized topics of interest to inventory managers. Becoming familiar with these three inventory management gurus will provide a ready reserve of tools for special situations.</p> </body> </html>

By wesece.com