Forecasting Techniques Using Moving Average, Exponential Smoothing, and Weighted Moving Average
Forecasting is an attempt to predict the future using either quantitative or qualitative technique. Forecasting is an integral part of human activity, however, businesses are increasingly using the forecasting technique to predict sales, demand planning, cost projection, inventory control, corporate planning, advertising planning, production planning and investment cash flow. (Lucey, 2002). While there are different strategies that can be used for the forecasting, however, the time-series analysis is one of the effective strategies that businesses use for the forecasting. The time series analysis is a form of the statistical or mathematical technique using the past data to forecast the future. The benefit of the time series analysis is the simplicity. The examples of the time series analysis are the moving average, weighted moving average and exponential smoothing.
The objective of the study is to use the moving average, weighted moving average and exponential smoothing to forecast the demand for the next three-quarter.
Moving Average Forecast
The study uses the data in Table 1 to calculate the moving average for the demand of the next three-quarter.
Table 1: Actual Demand Data
Quarter
Forecast
Actual Demand
4Q 2008
1Q 2009
2Q 2009
3Q 2009
4Q 2009
1Q 2010
2Q 2010
3Q 2010
4Q 2010
1Q 2011
Table 2: Three --Quarter Moving Average
Quarter
Forecast
Actual Demand
Error
Calculation
3-Quarter Moving Average
4Q 2008
1Q 2009
2Q 2009
3Q 2009
(220+215+210)/3
4Q 2009
(215+210+220)/3
1Q 2010
(210+220+225)/3
2Q 2010
(220+225+240)/3
3Q 2010
228,333
(225+240+255)/3
4Q 2010
231,111
(240+255.260)/3
1Q 2011
233,148
(255+260+270)/3
Exponential Smoothing Forecast
Quarter
Forecast
Actual Demand
Calculation
Forecast using Exponential Smoothing with Value 0.6
4Q 2008
(220+215+210+220+225+240)/6
1Q 2009
211.67+0.6 *(220-211.67)
2Q 2009
220.67+0.6 *(215-220.67)
3Q 2009
217.27+0,6*(210-217.27)
4Q 2009
212.91+0,6*(220-212.91)
1Q 2010
217.16+0,6*(225-217.16)
2Q 2010
221.87+0,6*(240-221.87)
3Q 2010
232.75+0,6*(255-232.75)
4Q 2010
246.10+0,6*(260-246.10)
1Q 2011
254.44+0,6*(270-254.44)
Weighted Moving Average
Quarter
Forecast
Actual Demand
Calculation
Forecasting with 3 WMA (0.50, .35, 0.15)
4Q 2008
1Q 2009
2Q 2009
3Q 2009
The distributor would as such be able to identify the new needs of the customers and the suppliers, and will be able to serve them in quick and efficient manner, by delivering results before the competition even becomes aware of the existence of the changes incurred. In other words, competitive advantages would be created (Royer, 2005). Within the longer term, a suggestion is made in the combination of qualitative
Forecasting Indices The following figure is taken from sales data of sporting goods, graphed over the last four years, showing worldwide demand for wave and ski boards combined. Each line on the graphic shows combined sales of wave and ski boards. The significant ramp in sales throughout March and April are attributable to the launch of each seasons' new wave boards. The spoke in sales in October are attributable to ski
The information is then collected and summarized and presented to the experts. The experts can then reconsider their answers and adjust them. This process can continue as required, with the intention being for a general consensus to emerge. The purpose of the technique is to utilize a range of experts, but in a way where each gives their opinion independently. The main difference between this method and other forecasting
Forecasting Operations Management Managers Module 3 - SLP Forecasting Consider organization selected previous SLP papers. Integrate concepts operations management principles 've studying module turn page paper addressing questions (remember references): 1) How forecasting carried organization ( level discussing)? 2) How relate product development services offers? 3) What difficulties organization faces coming accurate forecasts? Could improve forecasts methods? SLP Assignment Expectations: Research organization information find internet resources find . Forecasting: Wal-Mart Q1, How is
Forecasting The type of forecasting that should be in place at an insurance company is time series analysis, as it is through this approach to forecasting that prior demands are used to predict future demands (Chase et al. 2005). At the particular insurance corporation in question, this is precisely the type of forecasting that is in place; the number of claims expected in a given period of time is based on
Forecasting Methods There are three basic forecasting methods namely the time series methods, the regression methods, and qualitative methods. Qualitative methods use management judgment, expertise, and opinion to make forecasts. These methods are most commonly used in long-term strategic planning process bearing in mind there are individuals within an organization whose judgment and opinion are very integral in the running of search organizations (Brown, 1959). In fact their opinions count more
Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.
Get Started Now