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

    Forecasting is an important part of any planning; in the short term forecasting is used to predict materials, products, services, or other resources. This will allow schedule and labor changes for that of the demand. In the long term forecasting is used as a basis for strategic changes such as developing new markets, products, services, or for expanding or creating new facilities.…

    • 1558 Words
    • 7 Pages
    Powerful 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

    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

    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

    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

    I would choose to use the exponential smoothing forecast method. Exponential smoothing method is an average method that reacts more strongly to recent changes in demand than to more distant past data. Using this data will show how the forecast will react more strongly to immediate changes in the data. This is good to examine when dealing with seasonal patterns and trends that may be taking place. I would find this information very useful when examining the increased production of a product that appears to be higher in demand in the present than in the past Taylor (2011). For example, annual sales of toys will probably peak in the months of March and April, and perhaps during the summer with a much smaller peak. This pattern is likely to repeat every year, however, the relative amount of increase in sales during March may slowly change from year to year. During the month of march the sales for a particular toy may increase by 1 million dollars every year. We could add to our forecasts for every March the amount of 1 million dollars to account for this seasonal fluctuation.…

    • 607 Words
    • 3 Pages
    Good 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
  • 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
  • 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
  • Powerful Essays

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

    • 1653 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    A possible solution for Yankee Fork and Hoe Company would be the simple mean or average. This is the average for the set of data. This would not be recommended because it does not recognize the fluctuation of demand due to the constant changes that the data implies. Another possible solution is the forecast trend solution. This method computes the forecast when data displays a clear trend over time. But the error resulting in this method is too high to accept in priority. Another option is the seasonal index method.…

    • 572 Words
    • 3 Pages
    Good 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
  • Better Essays

    To use this model you look at several historical periods and choose a method that minimises a chosen measure of error. Then use that method to predict the future. To do this you use detailed data by SKU's (Stock Keeping Units) which are readily available.…

    • 1499 Words
    • 6 Pages
    Better Essays