• Home
  • /
  • Topic
  • /
  • Finance
  • /
  • Forecasting
  • /
  • Forecasting Approach Using Exponential Smoothing Moving Average and Weighted Moving Average Term Paper
Verified Document

Forecasting Approach Using Exponential Smoothing Moving Average And Weighted Moving Average Term Paper

Related Topics:

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

Parts of this document are hidden

View Full Document
svg-one

However, exponential smoothing having ? = 0.60 is the best forecasting method because its MAPE (Mean absolute percentage error) is lower…

Sources used in this document:
Reference

Lucey, T. (2002). Quantitative Techniques (Sixth Edition).UK. Cengage Learning EMEA.
Cite this Document:
Copy Bibliography Citation

Related Documents

Forecasting the Current Forecasting System
Words: 1153 Length: 3 Document Type: Essay

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
Words: 454 Length: 2 Document Type: Essay

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

Forecasting Methods There Are Various
Words: 987 Length: 3 Document Type: Term Paper

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 -
Words: 726 Length: 2 Document Type: Essay

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
Words: 540 Length: 2 Document Type: Essay

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 a Modern Corporation Include Qualitative Quantitative...
Words: 597 Length: 2 Document Type: Essay

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

Sign Up for Unlimited Study Help

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