{"id":9406,"date":"2011-10-31T05:56:41","date_gmt":"2011-10-31T11:56:41","guid":{"rendered":"https:\/\/staging.opexlearning.com\/resources\/?p=9406"},"modified":"2021-05-14T17:10:54","modified_gmt":"2021-05-14T22:10:54","slug":"just-in-time-inventory-variability-monte-carlo-simulation","status":"publish","type":"post","link":"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/","title":{"rendered":"Just in Time Simulation Using Monte Carlo Methods"},"content":{"rendered":"<div class=\"a296a24fa2fc69ef5487857f02f111e8\" data-index=\"9\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- Single Post readerboard -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:inline-block;width:728px;height:90px\"\r\n     data-ad-client=\"ca-pub-8207522353004717\"\r\n     data-ad-slot=\"1144967431\"><\/ins>\r\n<script>\r\n(adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p>This article looks at\u00a0Just in Time Simulation Using Monte Carlo Methods in Excel.<\/p>\n<p>We are pleased to bring you the second part of Cornelio Abellanas&#8217; first article on modeling the <a title=\"variability on processes\" href=\"https:\/\/staging.opexlearning.com\/resources\/modeling-the-impact-of-variability-with-monte-carlo-simulation\/9391\/\">impact of variability on systems and processes<\/a>. In the first article, Cornelio showed the impact of variability, in general, on processes as it relates to lead time, cycle time, work in process (WIP), and the impact to the customer. In this article, he applies the same approach, but with a focus on Just in Time Logistics.\u00a0You can also view all 40+ articles on <a title=\"articles on queueing theory\" href=\"https:\/\/staging.opexlearning.com\/resources\/queueing-theory\/\">Queueing Theory<\/a>.<\/p>\n<p>Enjoy this article and learn more about Cornelio at the end of this article.<\/p>\n<hr \/>\n<p>In the previous article we saw some effects of variability: accumulation of WIP before and after the high variability step and overall Lead Time increase.<\/p>\n<p>In a situation like this we might decide to apply Just-In-Time Inventory in order to reduce the excess inventory and in this way reduce Lead Time. We can try this with the Monte Carlo Simulator.<\/p>\n<p>We first reproduce the previous situation:<\/p>\n<ul>\n<li>Variation of step 2 = 40 and run for a while to reach stability and then apply JIT in the whole line by limiting Max queue in all steps to 200 (double the throughput of 100). This means that we are adding a constraint: each step will only process if there is room to store its output (output WIP + processed in next step \u00e2\u2030\u00a4 200).<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9407 size-full\" title=\"just in time simulation with monte carlo methods in excel\" src=\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2011\/10\/just-in-time-JIT-monte-carlo-simulation.jpg\" alt=\"just in time simulation using monte carlo methods\" width=\"627\" height=\"468\" srcset=\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2011\/10\/just-in-time-JIT-monte-carlo-simulation.jpg 627w, https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2011\/10\/just-in-time-JIT-monte-carlo-simulation-600x448.jpg 600w, https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2011\/10\/just-in-time-JIT-monte-carlo-simulation-300x223.jpg 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/p>\n<p>Analyzing the results we see we have achieved our objective of reducing excess WIP and Lead Time but have caused a bigger problem: Customer dissatisfaction due to a decrease in % On Time and average Thruput.<\/p>\n<p>By doing this we eventually eliminate the excess WIP which had accumulated before and after the high variability step (2). The elimination of the excess WIP After removes the protection it was providing to customer deliveries and therefore % On time drops: the customer is dissatisfied.<\/p>\n<p>Another consequence of this action is that thruput drops in every single step to around 90% of capacity. Notice that all this is due to the variability in step 2 combined with the application of JIT in the line.<\/p>\n<p>This drop in thruput starts in step 2 due to the fact that although its theoretical capacity is between 60 and 140, due to the JIT restriction, it will never receive more than 100 units from the previous step and will not be allowed to supply more than 100 to the next step this makes the effective capacity to vary from 60 to 100. Therefore this step has become a bottleneck for the whole line which explains why all steps downstream from 2 will be equally restricted.<\/p>\n<p>The amazing fact is that also the steps upstream are restricted by this bottleneck in step 2. The reason is that when step 2 processes only 60 units it leaves only 60 holes in the input buffer which allows the previous step to process only 60 units.<\/p>\n<p>So this variability bottleneck, combined with JIT, degrades the productivity of the whole line: both upstream and downstream.<\/p>\n<p>Imagine you go to the line in this situation: the cause of the problem will not be evident. If you try to convince step 2 that it is causing a problem to the whole line the reply might be: Why do you say that? I am producing on average like everyone else!<\/p>\n<p>This is again the Virus\u009d of variability at work.<\/p>\n<p>By applying JIT in this case we have therefore exposed the customer to all the variability of step 2 and dropped the productivity of the complete line: a complete disaster!<\/p>\n<p>Maybe you can work out alternative solutions to reduce WIP in this case of high variability and propose them in your comments.<\/p>\n<hr \/>\n<h2>About Cornelio Abellanas<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignright\" style=\"margin: 5px;\" title=\"foto_Cornelio_Abellanas\" src=\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2011\/10\/foto_Cornelio_Abellanas.jpg\" alt=\"cornelio abellanas, image\" width=\"198\" height=\"297\" \/>Has a PhD in Telecommunications Engineering degree from the University of Madrid and a Master of Science from the University of Kent at Canterbury (UK). He is a Lean Six Sigma Black Belt and EFQM (European Foundation for Quality Management) assessor.<\/p>\n<p>He has been Lean Six Sigma manager and a member of the Management Committee in Celestica Spain where he implemented 80 improvement projects per year with a total savings for the Company of 1% of the yearly revenue.\u00a0Improvement projects yielded these savings by reducing operator time, optimising plant layouts, reducing equipment setup time, reducing admin and production lead times, increasing equipment availability, reducing operator and equipment defect rate, reducing work-in-process and component inventory, reducing scrap and rework, improving on-time delivery, etc.<\/p>\n<p>He designed and implemented a line data collection system and real-time operator feedback which enabled self control in autonomous electronic board production cells.<br \/>\nHe performed internal audits and achieved success in external audits for the Company with standards ISO 9000: 2000, AS9100 (Aerospace), ISO\/TS 16949 (Automotive) and ISO 13485 (electro-medicine).\u00a0He has developed and maintained the Quality System: Quality Manual, Process Value Stream Maps, Procedures, Corrective actions, Suggestion program, etc. for Celestica Spain.\u00a0He has delivered EFQM training and assessment in companies Volvo Truck and Guzman.<\/p>\n<p>He currently delivers Lean and Six Sigma training and leads Kaizen workshops in companies around Europe: IBM, AT&amp;T, MSL, Philips, Volvo Truck, Ford, Celestica, IBC, Pt Pro, BP Solar, Italgres, PCS, General Dynamics, Telef\u00c3\u00b3nica International Wholesale Services, EMT Valencia, Importaco, Faurecia, Asac Pharma, etc. in France, Spain, Portugal, Belgium, Netherlands, Germany, Austria, Italy, Ireland, Greece, Switzerland, Sweden, etc.<\/p>\n<p>He lectures at MBAs in local Universities.<\/p>\n<p>He has managed and delivered courses at the IBM International Education Center in La Hulpe, Belgium on the topics: Total Quality Management, ISO 9000, EFQM, Stress Screening, Six Sigma, Statistical Process Control and Capability, Design of Experiments, Design for Manufacturability, Business Process Improvement, Lean Production, Kaizen, Theory of Constraints, etc.<\/p>\n<p>He managed an Independent Business Unit which was responsible for production of a tape drive unit designed in IBM Tucson, USA and manufactured in a local IBM Spain subcontractor.\u00a0He was Manufacturing Engineering Manager for banking control units in IBM Spain.\u00a0He designed a matrix ticket printer for British Railways in Ventek Ltd., London (Datapoint Computers representative for UK).\u00a0He worked as a Systems Engineer in logic design for Burroughs Machines Ltd. (now Unisys) in Cumbernauld (Scotland).<\/p>\n<p>Contact information:<br \/>\nPolyhedrika CB<br \/>\nValdelinares 2, 11a<br \/>\n46015 VALENCIA (Spain)<br \/>\nMobile: (34) 678464624<\/p>\n<!--CusAds0-->\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>This article looks at\u00a0Just in Time Simulation Using Monte Carlo Methods in Excel. We are pleased to bring you the second part of Cornelio Abellanas&#8217; first article on modeling the impact of variability on systems and processes. In the first article, Cornelio showed the impact of variability, in general, on processes as it relates to [&hellip;]<\/p>\n","protected":false},"author":12327,"featured_media":9408,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[29],"tags":[662],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Just in Time Simulation Using Monte Carlo Methods<\/title>\n<meta name=\"description\" content=\"Just in Time Simulation Using Monte Carlo Methods in excel. Watch how just in time enables smoother flow than batch manufacturing\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Just in Time Simulation Using Monte Carlo Methods\" \/>\n<meta property=\"og:description\" content=\"Just in Time Simulation Using Monte Carlo Methods in excel. Watch how just in time enables smoother flow than batch manufacturing\" \/>\n<meta property=\"og:url\" content=\"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/\" \/>\n<meta property=\"og:site_name\" content=\"OpEx Learning\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/get.shmula\" \/>\n<meta property=\"article:published_time\" content=\"2011-10-31T11:56:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-14T22:10:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2011\/10\/just-in-time-logistics-lean-toyota-pete-abilla.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"245\" \/>\n\t<meta property=\"og:image:height\" content=\"268\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Uday Kawar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@shmula\" \/>\n<meta name=\"twitter:site\" content=\"@shmula\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Uday Kawar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/\",\"url\":\"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/\",\"name\":\"Just in Time Simulation Using Monte Carlo Methods\",\"isPartOf\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2011\/10\/just-in-time-logistics-lean-toyota-pete-abilla.jpg\",\"datePublished\":\"2011-10-31T11:56:41+00:00\",\"dateModified\":\"2021-05-14T22:10:54+00:00\",\"author\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/#\/schema\/person\/9335b5223b67189b35bda7d6be11c3fd\"},\"description\":\"Just in Time Simulation Using Monte Carlo Methods in excel. Watch how just in time enables smoother flow than batch manufacturing\",\"breadcrumb\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/#primaryimage\",\"url\":\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2011\/10\/just-in-time-logistics-lean-toyota-pete-abilla.jpg\",\"contentUrl\":\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2011\/10\/just-in-time-logistics-lean-toyota-pete-abilla.jpg\",\"width\":245,\"height\":268,\"caption\":\"just in time inventory, pete abilla\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/staging.opexlearning.com\/resources\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Queueing Theory\",\"item\":\"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-posts\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Just in Time Simulation Using Monte Carlo Methods\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/#website\",\"url\":\"https:\/\/staging.opexlearning.com\/resources\/\",\"name\":\"OpEx Learning\",\"description\":\"Lean Six Sigma. Simplified.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/staging.opexlearning.com\/resources\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/#\/schema\/person\/9335b5223b67189b35bda7d6be11c3fd\",\"name\":\"Uday Kawar\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Just in Time Simulation Using Monte Carlo Methods","description":"Just in Time Simulation Using Monte Carlo Methods in excel. Watch how just in time enables smoother flow than batch manufacturing","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Just in Time Simulation Using Monte Carlo Methods","og_description":"Just in Time Simulation Using Monte Carlo Methods in excel. Watch how just in time enables smoother flow than batch manufacturing","og_url":"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/","og_site_name":"OpEx Learning","article_publisher":"https:\/\/www.facebook.com\/get.shmula","article_published_time":"2011-10-31T11:56:41+00:00","article_modified_time":"2021-05-14T22:10:54+00:00","og_image":[{"width":245,"height":268,"url":"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2011\/10\/just-in-time-logistics-lean-toyota-pete-abilla.jpg","type":"image\/jpeg"}],"author":"Uday Kawar","twitter_card":"summary_large_image","twitter_creator":"@shmula","twitter_site":"@shmula","twitter_misc":{"Written by":"Uday Kawar","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/","url":"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/","name":"Just in Time Simulation Using Monte Carlo Methods","isPartOf":{"@id":"https:\/\/staging.opexlearning.com\/resources\/#website"},"primaryImageOfPage":{"@id":"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/#primaryimage"},"image":{"@id":"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/#primaryimage"},"thumbnailUrl":"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2011\/10\/just-in-time-logistics-lean-toyota-pete-abilla.jpg","datePublished":"2011-10-31T11:56:41+00:00","dateModified":"2021-05-14T22:10:54+00:00","author":{"@id":"https:\/\/staging.opexlearning.com\/resources\/#\/schema\/person\/9335b5223b67189b35bda7d6be11c3fd"},"description":"Just in Time Simulation Using Monte Carlo Methods in excel. Watch how just in time enables smoother flow than batch manufacturing","breadcrumb":{"@id":"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/#primaryimage","url":"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2011\/10\/just-in-time-logistics-lean-toyota-pete-abilla.jpg","contentUrl":"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2011\/10\/just-in-time-logistics-lean-toyota-pete-abilla.jpg","width":245,"height":268,"caption":"just in time inventory, pete abilla"},{"@type":"BreadcrumbList","@id":"https:\/\/staging.opexlearning.com\/resources\/just-in-time-inventory-variability-monte-carlo-simulation\/9406\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/staging.opexlearning.com\/resources\/"},{"@type":"ListItem","position":2,"name":"Queueing Theory","item":"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-posts\/"},{"@type":"ListItem","position":3,"name":"Just in Time Simulation Using Monte Carlo Methods"}]},{"@type":"WebSite","@id":"https:\/\/staging.opexlearning.com\/resources\/#website","url":"https:\/\/staging.opexlearning.com\/resources\/","name":"OpEx Learning","description":"Lean Six Sigma. Simplified.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/staging.opexlearning.com\/resources\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/staging.opexlearning.com\/resources\/#\/schema\/person\/9335b5223b67189b35bda7d6be11c3fd","name":"Uday Kawar"}]}},"_links":{"self":[{"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/posts\/9406"}],"collection":[{"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/users\/12327"}],"replies":[{"embeddable":true,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/comments?post=9406"}],"version-history":[{"count":1,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/posts\/9406\/revisions"}],"predecessor-version":[{"id":32727,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/posts\/9406\/revisions\/32727"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/media\/9408"}],"wp:attachment":[{"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/media?parent=9406"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/categories?post=9406"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/tags?post=9406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}