Purchase Solution

Forecasting and Seasonality

Not what you're looking for?

Ask Custom Question

I need to forecast out 12 months using 3 different techniques, and then decide which one is best based on MAD (mean absolute deviation).

Using some historical data for the past 40 periods (see attachment) I need to make a forecast for the next 12 periods (periods 41 thru 52) using 3 of the simple forecasting techniques we have covered so far in our 2nd year class. These include: 1)Simple Moving Average 2)Weighted Moving Average 3)Exponential Smoothing 4)Linear Regression 5)Seasonal Forecasting via Regression, if we determine it is subject to seasonality (i.e., linear trends with multiplicative seasonality or nonlinear trends with multiplicative seasonality, and linear trends with additive seasonality or nonlinear trends with additive seasonality)

Using Excel or the Excel add-in Crystal Ball (we may NOT use Minitab, SAS, JMP, or any other packages), we need to investigate AT LEAST 3 different ways to forecast this data, and present the MAD (mean absolute deviation) and parameter values of each technique we tried. And then pick whatever is the "best forecast" based on the MAD...

I do not know how to do this. I think seasonality may be one technique we need to look at, because the prof mentioned it would be one to look out for...but how do we know if demand is affected seasonally???

Attachments
Purchase this Solution
Solution Preview

Using Excel, this assignment should be relatively straight-forward. I would suggest trying each of the models you've learned (if for no other reason then to get practice with each). Start with the easiest, simple moving average. If you wanted a 3-period moving average, for example, you'd start forecasting at period 4: find the average of the actual demand from the previous 3 quarters. (Set up the equation in the square next to the "Demand" for pd 4, then copy & paste all the way down the line to 1 period after the data ends.) In the next column, find the error for each period. Put the absolute value of each error in the next column and use that to determine the MAD value. You could use any # of periods to do the forecasting that you want, but I suggest using whatever your prof used as an example in class.
<br>
<br>Then use the equations for the weighted avg and exponential smoothing models. You would need to make an assumption about the ...

Purchase this Solution
Free BrainMass Quizzes
Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

View More Free Quizzes
Related BrainMass Solutions

  • Time Series Analysis

    or nonlinear trends with multiplicative seasonality, and linear trends with additive seasonality or nonlinear trends with additive seasonality) We need to investigate at least three differnt ways to forecast this data, and present the MAD (mean absolute

  • Forecasting

    14538 Forecasting Using Excel; Seasonality??

  • Time Series

    Winters' method takes exponential smoothing and adds in trends and seasonality factors. Answer: Simple exponential smoothing This solution analyzes which time series forecasting method would not be used to forecast seasonal data.

  • Mean Absolute Deviation

    seasonality, and linear trends with additive seasonality or nonlinear trends with additive seasonality) We need to investigate at least three different ways to forecast this data, and present the MAD (mean absolute deviation) and parameter values

  • Forecasting Demand with Seasonality and Growth

    Thanks The solution shows a step by step demand forecasting method with seasonality and expected growth. It also provides a power point presentation for students require detail explanation.

  • Forecasting problem: Comparing methods of forecasting

    190211 Forecasting / Seasonality, mean absolute deviation 1. Which gives a better prediction of the sales: 3MA, 6MA, exp 0.2, or exp 0.8 Why? Use MAD to explain, and show all work.

  • Widget sales - regressions. forecasting.

    Q5 : Take your understanding of seasonality from Question 1 and use this understanding to employ a 3-month moving average to capture the seasonality present in the data.

  • Forecasting problem:Seasonality incorporated

    This posting contains solution to following timeseries forecasting problem with seasonality.

  • Utilizing Statistics in Demand Forcasts

    A theoretical question about forecasting methods and tools.

View More Related Solutions