{"id":2323,"date":"2016-03-24T13:26:56","date_gmt":"2016-03-24T18:26:56","guid":{"rendered":"http:\/\/flevy.com\/blog\/?p=2323"},"modified":"2016-02-24T20:37:34","modified_gmt":"2016-02-25T01:37:34","slug":"inventory-management-how-to-do-it-right","status":"publish","type":"post","link":"https:\/\/flevy.com\/blog\/inventory-management-how-to-do-it-right\/","title":{"rendered":"Inventory Management.  How to Do It Right."},"content":{"rendered":"<p><em>Editor\u2019s Note: Vishnu Rayapeddi is a recognized pioneer of Lean Management and founder of Productivity Solutions.\u00a0 \u00a0You can view all of his\u00a0<a style=\"color: #001a66;\" href=\"https:\/\/flevy.com\/author\/vcharan\">Supply Chain training materials on Flevy here<\/a>.<\/em><\/p>\n<p style=\"text-align: center;\"><em>* * * *<\/em><\/p>\n<p><img decoding=\"async\" class=\"alignright size-medium wp-image-2324\" src=\"https:\/\/flevy.com\/blog\/wp-content\/uploads\/2016\/02\/FEMA_-_24316_-_Photograph_by_Liz_Roll_taken_on_05-11-2006_in_Texas-300x200.jpg\" alt=\"FEMA_-_24316_-_Photograph_by_Liz_Roll_taken_on_05-11-2006_in_Texas\" width=\"300\" height=\"200\" srcset=\"https:\/\/flevy.com\/blog\/wp-content\/uploads\/2016\/02\/FEMA_-_24316_-_Photograph_by_Liz_Roll_taken_on_05-11-2006_in_Texas-300x200.jpg 300w, https:\/\/flevy.com\/blog\/wp-content\/uploads\/2016\/02\/FEMA_-_24316_-_Photograph_by_Liz_Roll_taken_on_05-11-2006_in_Texas-1024x685.jpg 1024w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>For accountants \u201cinventory is an asset\u201d and it is shown that way on balance sheets! Is inventory really an asset?<\/p>\n<p>Inventory is an \u201cidle resource\u201d and takes up space, consumes money and needs a lot of time to manage it! In Lean thinking, inventory is categorised as a \u201cwaste\u201d and is depicted with a \u201ctomb stone\u201d icon in Value Stream Mapping by Toyota!<\/p>\n<p>But, as a matter of fact, inventory is required in most businesses to satisfy their customers. So, the question is how much to keep? The answer depends on the type of industry you are in and what level of customer service level (DIFOT) you would like to achieve. Is 100% DIFOT practical? May be or may be not! Again it depends on the type of industry you are in. But, surely you would the DIFOT to be closer to 100%. The more inventory you keep, the better is the customer service level. In essence it is a balancing act.<\/p>\n<p>The question as to how much inventory to keep also depends on the type of environment your business works in, i.e., \u201cMake to Stock,\u201d \u201cMake to Order,\u201d \u201cAssemble to Order,\u201d and \u201cEngineered to Order\u201d and the expected Lead Times by your customers.<\/p>\n<p>Inventory Management and Inventory Control are the most widely discussed topics globally. Though businesses have been using computerised systems such as MRP, we still seem to get it wrong even today with advanced technology and ERP systems. The reason is simple&#8230;we don\u2019t stick to the basics!<\/p>\n<p>The fundamentals of MRP haven\u2019t changed in decades and MRP is still the heart of every ERP system along with many added bells and whistles.<\/p>\n<h2><strong>How does MRP work? <\/strong><\/h2>\n<p>The inputs to MRP are:<\/p>\n<ol>\n<li>Stock on Hand,<\/li>\n<\/ol>\n<ol start=\"2\">\n<li>Forecasts or Customer Orders,<\/li>\n<\/ol>\n<ol start=\"3\">\n<li>Master Data and Inventory Parameters such as<\/li>\n<\/ol>\n<ul>\n<ul>\n<li>Bills of materials<\/li>\n<li>Economic Order Quantities<\/li>\n<li>Lead Times<\/li>\n<li>Minimum Maximum Stock Levels<\/li>\n<li>Safety Stock and<\/li>\n<li>Re-order Point<\/li>\n<\/ul>\n<\/ul>\n<p>The outputs of MRP are:<\/p>\n<ol>\n<li>What to Order<\/li>\n<\/ol>\n<ol start=\"2\">\n<li>When to Order<\/li>\n<\/ol>\n<ol start=\"3\">\n<li>How much to order<\/li>\n<\/ol>\n<p>Doesn\u2019t it look very straight forward? If it is so straight forward, why do we get it wrong? That\u2019s because we lack discipline! Just the way we need to maintain our body on a regular basis with food, water and exercise, we need to maintain the computer system.\u00a0 What it means is that we need to ensure that the data is accurate, which means we need to review it on a regular basis and make amendments as required as everything around us keeps changing.<\/p>\n<h2><strong>10\u00a0 Tips for Your Inventory Control and Management<\/strong><\/h2>\n<ol>\n<li>Work on getting the end-to-end \u201cVisibility\u201d in your supply chain;<\/li>\n<\/ol>\n<ol start=\"2\">\n<li>If making to forecasts, ensure that the forecasts are as accurate as possible with input from your sales &amp; marketing teams;<\/li>\n<\/ol>\n<ol start=\"3\">\n<li>To ensure the \u201cStock On Hand\u201d is accurate, introduce Cycle Counts and make sure the book \/ system stock and physical stock match within a +\/- 2% accuracy;<\/li>\n<\/ol>\n<ol start=\"4\">\n<li>Ensure stock rotation is done. In many businesses the raw materials and finished goods have certain shelf-life. To ensure you are using the correct shelf-life materials, use FIFO (First In First Out) or the items which are expiring first;<\/li>\n<\/ol>\n<ol start=\"5\">\n<li>Ensure that all your Bills of Materials are accurate and if you are using \u201cback flush\u201d function, make sure you add a small \u201cwastage %\u201d;<\/li>\n<\/ol>\n<ol start=\"6\">\n<li>Ensure that the inventory parameters (items 3b to 3f in the inputs to MRP above) are reviewed and adjusted at least every 6 months;<\/li>\n<\/ol>\n<ol start=\"7\">\n<li>Conduct an ABC Analysis and manage your inventory accordingly, i.e., keep a close eye on the A items, have less stock of them and procure frequently as they cost a lot to keep in inventory;<\/li>\n<\/ol>\n<ul>\n<ul>\n<li>A inventory accounts for about 20% of the items and 80% of the dollar usage;<\/li>\n<li>B inventory accounts for about 30% of the items and 15% of the dollar usage;<\/li>\n<li>C inventory accounts for about 50% of the items and 5% of the dollar usage;<\/li>\n<\/ul>\n<\/ul>\n<ol start=\"8\">\n<li>Store the materials as per ABC categories, i.e., Here the ABC\u2019s refer to Fast Moving, Medium Moving and Slow Moving. Keep the A\u2019s closer to the exit to reduce transportation and minimise damages and C at the far end of the warehouse;<\/li>\n<\/ol>\n<ol start=\"9\">\n<li>Introduce 5S in the warehouse and implement \u201cA Place for Everything and Everything in it\u2019s Place\u201d. In case your computer determines randomly the storage area, ensure that the records are accurate, i.e., if you physically move the items ensure to make amendments to your system. This would reduce your searching time hugely and increases productivity;<\/li>\n<\/ol>\n<ol start=\"10\">\n<li>Introduce Kanban systems where appropriate.<\/li>\n<\/ol>\n<h2><strong>The Important KPIs \/ Metrics for Inventory Management<\/strong><\/h2>\n<ol>\n<li>Inventory Turns (Cost of Goods Sold \/ Average Inventory Value)<\/li>\n<\/ol>\n<ol start=\"2\">\n<li>Stock accuracy<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Editor\u2019s Note: Vishnu Rayapeddi is a recognized pioneer of Lean Management and founder of Productivity Solutions.\u00a0 \u00a0You can view all of his\u00a0Supply Chain training materials on Flevy here. * * * * For accountants \u201cinventory is an asset\u201d and it is shown that way on balance sheets! Is inventory really an asset? Inventory is an&hellip;&nbsp;<a href=\"https:\/\/flevy.com\/blog\/inventory-management-how-to-do-it-right\/\" rel=\"bookmark\"><span class=\"screen-reader-text\">Inventory Management.  How to Do It Right.<\/span><\/a><\/p>\n","protected":false},"author":71,"featured_media":2324,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[82],"tags":[1070,1071,510,1069],"class_list":["post-2323","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-operations","tag-difot","tag-inventory-control","tag-inventory-management","tag-mrp"],"_links":{"self":[{"href":"https:\/\/flevy.com\/blog\/wp-json\/wp\/v2\/posts\/2323","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/flevy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/flevy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/flevy.com\/blog\/wp-json\/wp\/v2\/users\/71"}],"replies":[{"embeddable":true,"href":"https:\/\/flevy.com\/blog\/wp-json\/wp\/v2\/comments?post=2323"}],"version-history":[{"count":1,"href":"https:\/\/flevy.com\/blog\/wp-json\/wp\/v2\/posts\/2323\/revisions"}],"predecessor-version":[{"id":2325,"href":"https:\/\/flevy.com\/blog\/wp-json\/wp\/v2\/posts\/2323\/revisions\/2325"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/flevy.com\/blog\/wp-json\/wp\/v2\/media\/2324"}],"wp:attachment":[{"href":"https:\/\/flevy.com\/blog\/wp-json\/wp\/v2\/media?parent=2323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/flevy.com\/blog\/wp-json\/wp\/v2\/categories?post=2323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/flevy.com\/blog\/wp-json\/wp\/v2\/tags?post=2323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}