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???

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>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
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Introduction to Finance

This quiz test introductory finance topics.


This tests some key elements of major motivation theories.