{"id":170,"date":"2006-08-14T14:57:25","date_gmt":"2006-08-14T21:57:25","guid":{"rendered":"https:\/\/staging.opexlearning.com\/resources\/170\/queueing-theory-part-3"},"modified":"2014-10-03T10:25:49","modified_gmt":"2014-10-03T15:25:49","slug":"queueing-theory-part-3","status":"publish","type":"post","link":"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/","title":{"rendered":"Queueing Theory Calculations and Examples"},"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>I previously wrote on Queueing Theory and titled those posts as <a title=\"queueing theory\" href=\"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-1\/91\/\" target=\"_blank\">Queueing Theory: Part 1<\/a> and Queueing Theory: Part 2. You 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>Today, I&#8217;ll briefly explain how to set-up a model in Microsoft Excel to simulate a Single-Server Queue. These Queueing Theory Calculations can then be used in various settings. Entirely up to you.<\/p>\n<p>Queueing Theory shows the interplay between the arrival rate and the service rate, which both reveal the characteristics of the queue and, ultimately the customer experience. The items in parenthesis below are the cell\/row numbers in my example image (see below).<\/p>\n<ol>\n<li><em><strong>Arrival Rate<\/strong><\/em>: Set-up a field to accept the <strong>Customers Per Hour<\/strong> (B5); Followed by a field to accept the <strong>Average Minutes Between Arrivals<\/strong> (60\/B5).<\/li>\n<li><em><strong>Service Rate<\/strong><\/em>: Next, we need to set-up the Service Rate. To do this, create a field that will accept <strong>Customers Per Hour<\/strong> (B7). This is followed by a field to accept <strong>Average Service Time in Minutes<\/strong> (60\/B7).<\/li>\n<\/ol>\n<p>Now, we can learn about the characteristics of the queue and also how the customer might experience the queue:<\/p>\n<ol>\n<li><em><strong> Average Server Utilization<\/strong><\/em>: Create a field to calculate the Average Server Utilization (B5\/B7).<\/li>\n<li><strong><em>Average Number of Customers in the Line<\/em><\/strong>: Set-up a field to calculate the Average Number of Customers in the Line (B5^2\/(B7*(B7-B5))).<\/li>\n<li><em><strong>Average Number of Customers in the System<\/strong><\/em>: Now, create a field to calculate the <strong>Average Number of Customers in the System<\/strong> (B5\/(B7-B5)).<\/li>\n<li><em><strong>Average Waiting Time in the Line<\/strong><\/em>: Now, we can determine how long it is, on average, for a customer to <strong>Wait in the Line<\/strong> in hours (B5\/(B7*(B7-B5)) and in minutes ((B5\/(B7*(B7-B5)))*60).<\/li>\n<li><em><strong>Average Time in the System<\/strong><\/em>: System here is defined the cumulative time of (Waiting in the Line + Being Served). For <strong>Hours<\/strong>, create a field that will calculate the following (1\/(B7-B5)) and for <strong>Minutes<\/strong> ((1\/(B7-B5)*60).<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9555\" src=\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/08\/queueing-theory-excel.jpg\" alt=\"queueing theory calculation\" width=\"500\" height=\"246\" srcset=\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/08\/queueing-theory-excel.jpg 500w, https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/08\/queueing-theory-excel-300x147.jpg 300w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/p>\n<p>That&#8217;s it. With a few simple calculations we can determine the the load of a system the how long it is on average for a customer to wait for service. Queueing Theory is very pragmatic, applicable, and fairly easy to do. There&#8217;s a lot of quant-jock mystique around it, but it&#8217;s really not difficult to understand and it can really impact how companies conduct business. Where can you apply this?<\/p>\n<p>Any business process where lines are a matter of fact &#8212; this means:<\/p>\n<ul>\n<li>Emergency or Doctor&#8217;s offices<\/li>\n<li>Restaurants<\/li>\n<li>Server Load in a network environment<\/li>\n<li>Fulfillment\/Distribution Center or Warehousing<\/li>\n<li>Project Management<\/li>\n<li>Call Centers<\/li>\n<li>Software Engineering<\/li>\n<li>etc&#8230;<\/li>\n<\/ul>\n<p>Queueing Theory isn&#8217;t used enough, in my experience. More businesses could stand to benefit from its use and application. At the end of the day, simply learning about how long a customer might wait in line will help a business better design their service to provide more value-add to the customer experience.<\/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>I previously wrote on Queueing Theory and titled those posts as Queueing Theory: Part 1 and Queueing Theory: Part 2. You can also view all 40+ articles on Queueing Theory. Today, I&#8217;ll briefly explain how to set-up a model in Microsoft Excel to simulate a Single-Server Queue. These Queueing Theory Calculations can then be used [&hellip;]<\/p>\n","protected":false},"author":12327,"featured_media":9555,"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":[641,643,642,640],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Queueing Theory Calculations and Examples<\/title>\n<meta name=\"description\" content=\"Article shows Queueing Theory Calculations and examples taken from the world of business, healthcare, and transactional environments\" \/>\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=\"Queueing Theory Calculations and Examples\" \/>\n<meta property=\"og:description\" content=\"Article shows Queueing Theory Calculations and examples taken from the world of business, healthcare, and transactional environments\" \/>\n<meta property=\"og:url\" content=\"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/\" \/>\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=\"2006-08-14T21:57:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-10-03T15:25:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/08\/queueing-theory-excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"246\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/\",\"url\":\"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/\",\"name\":\"Queueing Theory Calculations and Examples\",\"isPartOf\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/08\/queueing-theory-excel.jpg\",\"datePublished\":\"2006-08-14T21:57:25+00:00\",\"dateModified\":\"2014-10-03T15:25:49+00:00\",\"author\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/#\/schema\/person\/9335b5223b67189b35bda7d6be11c3fd\"},\"description\":\"Article shows Queueing Theory Calculations and examples taken from the world of business, healthcare, and transactional environments\",\"breadcrumb\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/#primaryimage\",\"url\":\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/08\/queueing-theory-excel.jpg\",\"contentUrl\":\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/08\/queueing-theory-excel.jpg\",\"width\":500,\"height\":246,\"caption\":\"queueing theory calculation\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/#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\":\"Queueing Theory Calculations and Examples\"}]},{\"@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":"Queueing Theory Calculations and Examples","description":"Article shows Queueing Theory Calculations and examples taken from the world of business, healthcare, and transactional environments","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":"Queueing Theory Calculations and Examples","og_description":"Article shows Queueing Theory Calculations and examples taken from the world of business, healthcare, and transactional environments","og_url":"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/","og_site_name":"OpEx Learning","article_publisher":"https:\/\/www.facebook.com\/get.shmula","article_published_time":"2006-08-14T21:57:25+00:00","article_modified_time":"2014-10-03T15:25:49+00:00","og_image":[{"width":500,"height":246,"url":"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/08\/queueing-theory-excel.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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/","url":"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/","name":"Queueing Theory Calculations and Examples","isPartOf":{"@id":"https:\/\/staging.opexlearning.com\/resources\/#website"},"primaryImageOfPage":{"@id":"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/#primaryimage"},"image":{"@id":"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/#primaryimage"},"thumbnailUrl":"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/08\/queueing-theory-excel.jpg","datePublished":"2006-08-14T21:57:25+00:00","dateModified":"2014-10-03T15:25:49+00:00","author":{"@id":"https:\/\/staging.opexlearning.com\/resources\/#\/schema\/person\/9335b5223b67189b35bda7d6be11c3fd"},"description":"Article shows Queueing Theory Calculations and examples taken from the world of business, healthcare, and transactional environments","breadcrumb":{"@id":"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/#primaryimage","url":"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/08\/queueing-theory-excel.jpg","contentUrl":"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2006\/08\/queueing-theory-excel.jpg","width":500,"height":246,"caption":"queueing theory calculation"},{"@type":"BreadcrumbList","@id":"https:\/\/staging.opexlearning.com\/resources\/queueing-theory-part-3\/170\/#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":"Queueing Theory Calculations and Examples"}]},{"@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\/170"}],"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=170"}],"version-history":[{"count":0,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/posts\/170\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/media\/9555"}],"wp:attachment":[{"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/media?parent=170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/categories?post=170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/tags?post=170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}