{"id":308,"date":"2007-01-23T12:18:05","date_gmt":"2007-01-23T19:18:05","guid":{"rendered":"https:\/\/staging.opexlearning.com\/resources\/308\/forecasting-unweighted-and-weighted-moving-average-model"},"modified":"2014-09-25T08:57:48","modified_gmt":"2014-09-25T13:57:48","slug":"forecasting-unweighted-and-weighted-moving-average-model","status":"publish","type":"post","link":"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/","title":{"rendered":"Weighted Moving Average Forecasting Methods: Pros and Cons"},"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>In a previous article, I provided an <a title=\"introduction to business forecasting and 4 laws to always remember\" href=\"https:\/\/staging.opexlearning.com\/resources\/introduction-to-forecasting\/307\/\">introduction to business forecasting<\/a>. In this article, we will discuss 2 types of forecasting models &#8211; the weighted and unweighted moving average model. I&#8217;ll also discuss Measure of Forecasting Accuracy. In another article, I showed how to conduct a <a title=\"regression on service level in a call center\" href=\"https:\/\/staging.opexlearning.com\/resources\/applied-regression-analysis\/192\/\">regression analysis in a call center<\/a>.<\/p>\n<h2><strong>Unweighted Moving Average<\/strong><\/h2>\n<p>The Moving Average model is in class of &#8220;naive&#8221; models, because it takes a data set with variation and creates another data set with less variation, or a smoothed data set. The Moving Average model takes the average of several periods of data; the result is a dampened or smoothed data set; use this model when demand is stable and there is no evidence of a trend or seasonal pattern.<\/p>\n<p style=\"text-align: center;\">\n<p>Moving average routines may be designed to remove the seasonal and random noise variation within a time series. If the moving average routine is used repeatedly on each newly-generated series, it may succeed in removing most of any cyclical variation present. What is left of the original series after early smoothings to remove seasonal and random or irregular components is a successor series retaining some combination of trend and cyclical behavior. If no trend or cyclical behavior are present in the time series, the smoothings may leave a successor series which plots as a nearly horizontal line against time on the horizontal axis. Assuming the presence of trend and cyclical behavior in the original series, the moving average process provides a method of isolating it.<\/p>\n<p>The smoothing effect of the moving average model provides for a &#8220;cleaner&#8221; data set, which may or may not help in estimating the future level of a variable.<\/p>\n<p>The formula for the Moving Average Model is below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14931\" src=\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2007\/01\/weighted-moving-average-calculation.png\" alt=\"calculation for weighted moving average\" width=\"418\" height=\"339\" srcset=\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2007\/01\/weighted-moving-average-calculation.png 418w, https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2007\/01\/weighted-moving-average-calculation-300x243.png 300w\" sizes=\"(max-width: 418px) 100vw, 418px\" \/><\/p>\n<div style=\"text-align: center;\"><\/div>\n<p style=\"text-align: center;\">\n<p>Let&#8217;s suppose the data set below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14932\" src=\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2007\/01\/accurate-weighted-moving-average-forecast.png\" alt=\"accurate weighted moving average calculations in a table\" width=\"514\" height=\"303\" srcset=\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2007\/01\/accurate-weighted-moving-average-forecast.png 514w, https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2007\/01\/accurate-weighted-moving-average-forecast-300x176.png 300w\" sizes=\"(max-width: 514px) 100vw, 514px\" \/><\/p>\n<p>The Month and Demand columns shows the time series for the month. The 3rd column shows the 3 period moving average, calculated as follows:<\/p>\n<blockquote><p>((119 + 72 + 113) \/ 3 = 101)<\/p><\/blockquote>\n<p>Following the same formula above, walk across the time series in 3 week periods in order to build the smoothed series, the new time series with less variation.<\/p>\n<h2>Forecasting Measures of Accuracy<\/h2>\n<p>The 4th column shows an Error column calculated as follows:<\/p>\n<blockquote><p>((Demand &#8211; 3 Week MA) = Error)<\/p><\/blockquote>\n<p>The 5th column shows the Absolute Error, which is just the absolute number of the items in the Error column.<\/p>\n<p>The 6th column shows a Mean Forecast Error, or MFA. This shows the direction of the forecasting error. The rule here is that if the number is negative, the the model tends to <em>over-forecast<\/em>. If the number is positive, then the model tends to <em>under-forecast<\/em>. The MFA is calculated as follows:<\/p>\n<blockquote><p>Sum of Error \/ N = MFA<\/p><\/blockquote>\n<p>Using the data set above,<\/p>\n<blockquote><p>[((-19 + -7 + 39 + 13 + 8 + -30 + -10 + -12 + -1) \/ 9) = -2]<\/p><\/blockquote>\n<p>Since the MFA is negative, then this tells us that the direction of the forecast error; in this case, the data and using this model tends to over-forecast.<\/p>\n<p>The last column shows a Mean Absolute Deviation, which gives us an indication of the size of the error. In other words, since MFE for our data set is negative, pointing to an over-forecast, the MAD tells us that the average size of that over-forecast is ~15. To calculate MAD, do the following:<\/p>\n<blockquote><p>Absolute Error \/ N = MAD<\/p><\/blockquote>\n<p>In other words,<\/p>\n<blockquote><p>[((19 + 7 + 39 + 13 + 8 + 30 + 10 + 12 + 1) \/ 9) = 15]<\/p><\/blockquote>\n<p>The smoothed time series above coupled with MFA and MAD gives us more context around our point estimates and forecast accuracy. This enables the firm to better plan for the future and form strategies around labor, capacity, inventory, service levels, and other pertinent items important to the firm.<\/p>\n<h2>Weighted Moving Average<\/h2>\n<p>Follow the steps for the Moving Average model above. Weights on this model indicates the subjective importance we wish to place on past or recent data. Weights can be from 0.0 to 1.0; the higher the weight, then the higher importance we are placing on more recent data; similarly, for lower weights.<\/p>\n<p>In forming your moving average time series, just add a weight multipier to form the new, smoothed-out time series. All remaining steps in the Moving Average Model are the same.<\/p>\n<div align=\"center\"><object width=\"640\" height=\"480\"><param name=\"movie\" value=\"\/\/www.youtube.com\/v\/DVEbZ__FNRg?hl=en_US&amp;version=3&amp;rel=0\" \/><param name=\"allowFullScreen\" value=\"true\" \/><param name=\"allowscriptaccess\" value=\"always\" \/><embed src=\"\/\/www.youtube.com\/v\/DVEbZ__FNRg?hl=en_US&amp;version=3&amp;rel=0\" type=\"application\/x-shockwave-flash\" width=\"640\" height=\"480\" allowscriptaccess=\"always\" allowfullscreen=\"allowfullscreen\" \/><\/object><\/div>\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>In a previous article, I provided an introduction to business forecasting. In this article, we will discuss 2 types of forecasting models &#8211; the weighted and unweighted moving average model. I&#8217;ll also discuss Measure of Forecasting Accuracy. In another article, I showed how to conduct a regression analysis in a call center. Unweighted Moving Average [&hellip;]<\/p>\n","protected":false},"author":12327,"featured_media":9817,"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":[9],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Weighted Moving Average Forecasting Methods: Pros and Cons<\/title>\n<meta name=\"description\" content=\"Weighted Moving Average Forecasting Methods are common in modeling demand. Learn the pros and cons of technique.\" \/>\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=\"Weighted Moving Average Forecasting Methods: Pros and Cons\" \/>\n<meta property=\"og:description\" content=\"Weighted Moving Average Forecasting Methods are common in modeling demand. Learn the pros and cons of technique.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/\" \/>\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=\"2007-01-23T19:18:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-09-25T13:57:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2007\/01\/weighted-moving-average-details.png\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/\",\"url\":\"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/\",\"name\":\"Weighted Moving Average Forecasting Methods: Pros and Cons\",\"isPartOf\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2007\/01\/weighted-moving-average-details.png\",\"datePublished\":\"2007-01-23T19:18:05+00:00\",\"dateModified\":\"2014-09-25T13:57:48+00:00\",\"author\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/#\/schema\/person\/9335b5223b67189b35bda7d6be11c3fd\"},\"description\":\"Weighted Moving Average Forecasting Methods are common in modeling demand. Learn the pros and cons of technique.\",\"breadcrumb\":{\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/#primaryimage\",\"url\":\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2007\/01\/weighted-moving-average-details.png\",\"contentUrl\":\"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2007\/01\/weighted-moving-average-details.png\",\"width\":400,\"height\":300,\"caption\":\"forecasting weighted moving average\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/staging.opexlearning.com\/resources\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Operations Management\",\"item\":\"https:\/\/staging.opexlearning.com\/resources\/operations\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Weighted Moving Average Forecasting Methods: Pros and Cons\"}]},{\"@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<meta property=\"og:video\" content=\"https:\/\/www.youtube.com\/embed\/DVEbZ__FNRg\" \/>\n<meta property=\"og:video:type\" content=\"text\/html\" \/>\n<meta property=\"og:video:duration\" content=\"3528\" \/>\n<meta property=\"og:video:width\" content=\"480\" \/>\n<meta property=\"og:video:height\" content=\"360\" \/>\n<meta property=\"ya:ovs:adult\" content=\"false\" \/>\n<meta property=\"ya:ovs:upload_date\" content=\"2007-01-23T19:18:05+00:00\" \/>\n<meta property=\"ya:ovs:allow_embed\" content=\"true\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Weighted Moving Average Forecasting Methods: Pros and Cons","description":"Weighted Moving Average Forecasting Methods are common in modeling demand. Learn the pros and cons of technique.","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":"Weighted Moving Average Forecasting Methods: Pros and Cons","og_description":"Weighted Moving Average Forecasting Methods are common in modeling demand. Learn the pros and cons of technique.","og_url":"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/","og_site_name":"OpEx Learning","article_publisher":"https:\/\/www.facebook.com\/get.shmula","article_published_time":"2007-01-23T19:18:05+00:00","article_modified_time":"2014-09-25T13:57:48+00:00","og_image":[{"width":400,"height":300,"url":"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2007\/01\/weighted-moving-average-details.png","type":"image\/png"}],"author":"Uday Kawar","twitter_card":"summary_large_image","twitter_creator":"@shmula","twitter_site":"@shmula","twitter_misc":{"Written by":"Uday Kawar","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/","url":"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/","name":"Weighted Moving Average Forecasting Methods: Pros and Cons","isPartOf":{"@id":"https:\/\/staging.opexlearning.com\/resources\/#website"},"primaryImageOfPage":{"@id":"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/#primaryimage"},"image":{"@id":"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/#primaryimage"},"thumbnailUrl":"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2007\/01\/weighted-moving-average-details.png","datePublished":"2007-01-23T19:18:05+00:00","dateModified":"2014-09-25T13:57:48+00:00","author":{"@id":"https:\/\/staging.opexlearning.com\/resources\/#\/schema\/person\/9335b5223b67189b35bda7d6be11c3fd"},"description":"Weighted Moving Average Forecasting Methods are common in modeling demand. Learn the pros and cons of technique.","breadcrumb":{"@id":"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/#primaryimage","url":"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2007\/01\/weighted-moving-average-details.png","contentUrl":"https:\/\/staging.opexlearning.com\/resources\/wp-content\/uploads\/2007\/01\/weighted-moving-average-details.png","width":400,"height":300,"caption":"forecasting weighted moving average"},{"@type":"BreadcrumbList","@id":"https:\/\/staging.opexlearning.com\/resources\/forecasting-unweighted-and-weighted-moving-average-model\/308\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/staging.opexlearning.com\/resources\/"},{"@type":"ListItem","position":2,"name":"Operations Management","item":"https:\/\/staging.opexlearning.com\/resources\/operations\/"},{"@type":"ListItem","position":3,"name":"Weighted Moving Average Forecasting Methods: Pros and Cons"}]},{"@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"}]},"og_video":"https:\/\/www.youtube.com\/embed\/DVEbZ__FNRg","og_video_type":"text\/html","og_video_duration":"3528","og_video_width":"480","og_video_height":"360","ya_ovs_adult":"false","ya_ovs_upload_date":"2007-01-23T19:18:05+00:00","ya_ovs_allow_embed":"true"},"_links":{"self":[{"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/posts\/308"}],"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=308"}],"version-history":[{"count":0,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/posts\/308\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/media\/9817"}],"wp:attachment":[{"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/media?parent=308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/categories?post=308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/staging.opexlearning.com\/resources\/wp-json\/wp\/v2\/tags?post=308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}