Preview

Forecasting: Moving Average and Exponential Smoothing Tool

Good Essays
Open Document
Open Document
421 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Forecasting: Moving Average and Exponential Smoothing Tool
Forecasting In order for a business to be successful it must come up with the most accurate forecast possible so they can plan for the demands. There are forecasting tools that assist with making calculations to receive the best outcome by your company’s needs. The tools are moving average, weighted moving average and exponential smoothing. The moving average takes the total of actual demand for previous months then divides by the number of months added. The number of months that is used can be predefined such as using the previous three months. This is the simplest and easiest calculation but often is not accurate since it can have a lag in spotting trends (Murphy). The weighted moving average is similar to the moving average but it places weights on each period usually with more recent periods weighing more. For example if you are averaging the past three months with the most recent month being the most valuable you would multiply the last month by .3 and then month before that at .2 and then the first month by .1 then by adding them together you would get the average with more of an emphasis on the month with the most weight (Career Education Corporation, 2010). Lastly there is the exponential smoothing tool. The exponential smoothing tool is a moving average which is ideal for forecasting smaller items. It uses the most recent demand along with the most recent forecast using a weight between 0 and 1 (Bozarth, 2011). In other words the forecast is the current forecast plus an adjustment for the error rate. This tool is very useful to take in considerations trends occurring. Before a company selects a forecasting technique it should consider that what every technique used can be implemented correctly and maintained. Then the company should adjust parameters so that they match the company’s situations. As well as continually monitoring the forecast for accuracy, if the forecast being calculated is way off it may be best to implement a


References: Bozarth, C. (2011). Exponential Smoothing: Approaches to Forecasting: A Tutorial. Retrieved from http://scm.ncsu.edu/scm-articles/article/exponential-smoothing-approaches-to-forecasting-a-tutorial Career Education Corporation. (2010). The narrative essay [Multimedia]. Retrieved from https://mycampus.aiu-online.com/Classroom/Pages/multimediacoursetext.aspx?classid=395140&tid=250&uid=436769&HeaderText=Course Materials: MGMT411-1301B-01 : Operations Manage Murphy, C. (n.d.). Moving Average. Retrieved from http://www.investopedia.com/university/movingaverage/

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Forecasting Hsm 260

    • 505 Words
    • 3 Pages

    For moving averages and weighted moving averages, use only the data for the past three fiscal years: Moving Averages…

    • 505 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    The ideal philosophy of forecasting is to create the best one possible and have a defense in place by maintaining flexibility in the system to account for any forecast errors (Chase, Jacobs, & Aquilano, 2006).…

    • 1558 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    Hcs 405 Wk4

    • 561 Words
    • 3 Pages

    |Forecast |Forecast is a tool or method by using old and |Forecast is very important to all organizations. Management need |…

    • 561 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Case Study: Nordstrom

    • 612 Words
    • 3 Pages

    According to Schermerhorn (2013), “forecasting is the ability to predict the future” (pg.123) which means that the process of forecasting can become an important tool to quantify the proper balance between supply and demand. Likewise, in order to maximize sales and its effectiveness, businesses have to work in predict the future customer demand and use this information to lead the business operations to distribution effectively. However, inaccurate forecasts happen and along with them there is a cost.…

    • 612 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    BankUSA

    • 277 Words
    • 1 Page

    A moving average (MA) forecast is an average of the most recent “k” observations in a time series. I think this forecast model would work best to forecast the short-term demand of the bank. MA methods work best for short planning horizons when there is no major trend, seasonal, or business cycle patterns, that is, when demand is relatively stable and consistent. The moving average provides you with a straight forward calculation of the trends for a given period of time.…

    • 277 Words
    • 1 Page
    Satisfactory Essays
  • Powerful Essays

    Business Forecasting

    • 3629 Words
    • 15 Pages

    It is the fundamental process that to find out trend-cycle and seasonality, in order to create a certain model for further forecasting. Two approaches can be used to examine the data: analysing the time series plot or ACF plot.…

    • 3629 Words
    • 15 Pages
    Powerful Essays
  • Satisfactory Essays

    Alecia, businesses can determine which forecasting technique is best for their company. The decision-making process should be will planned out before implementing a plan. Depending on the type of business, each technique plays a different role in the decision making process and the also on how the company can predict the future of the business.…

    • 55 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    City Cicles

    • 488 Words
    • 2 Pages

    4.47 City Cycles has just started selling the new Z-10 mountain bike, with monthly sales as show in the table. First, co-owner Amit wants to forecast by exponential smoothing by initially setting February’s forecast equal to January’s sales with α=1. Co-owner Barbara wants to use a three-period moving average.…

    • 488 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Choose one of the forecasting methods and explain the rationale behind using it in real life.…

    • 607 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Fhe Service

    • 640 Words
    • 3 Pages

    (c) Repeat the forecast for Week 4, 5, and 6 by using the weighted moving average method with n = 3 and weights of 0.50, 0.30, and 0.20 with 0.50 applying to the most recent demand.…

    • 640 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Forecasting Best Practices

    • 2091 Words
    • 9 Pages

    To find the "best practices" for forecasting, our team researched many cases of forecasting success, and found five companies with a common theme. Rayovac, the Coca-Cola Bottling Company, AAi. FosterGrant, the Sara Lee Corporation, and the Scotts Company all had major problems with forecasting, some of them very similar. To address and solve these problems each of these companies made major improvements to their forecasting systems. Although some used similar methods and others very different, these companies found that the right people, process and information technology was the key to efficient and accurate forecasting.…

    • 2091 Words
    • 9 Pages
    Better Essays
  • Powerful Essays

    There are many ways to create a forecast for a certain goods that a planner can use just one or combine many methods together. According to Chopra and Meindl define these methods as follows:…

    • 1296 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    Walgreen's Billing Error

    • 681 Words
    • 3 Pages

    Forecasting is a preparation tool that helps a company figure out what might happen in the future; and to do so, the company will primarily rely on data from both the past and present to figure out possible trends. Forecasts can be made in short term, medium term or long term. When it comes to forecasting it is important for a company to look at all possible factors including fluctuation of prices and the market, possible declines in the economy, technological errors and so much more. In 2014 the well known pharmaceutical company Walgreens prepared to forecast the companies earning up to the year 2016. However, somewhere during their process an error occurred resulting in the company suffering from a billion dollar cut.…

    • 681 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Sanders, N. (1992). Managing the forecasting function. (95 ed., Vol. 4). Wembley: Emerald Group Publishing, Limited.…

    • 1653 Words
    • 7 Pages
    Powerful Essays
  • Better Essays

    Forecasting involves using past data to generate a number, set of numbers, or scenario that corresponds to a future occurrence. It is absolutely essential to short-range and long-range planning.…

    • 1499 Words
    • 6 Pages
    Better Essays