Purchase Solution

Forecasting

Not what you're looking for?

Ask Custom Question

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 whatever is the best/most accurate 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 deivaiton) and parameter values of each technique we tried. And state why we ended up going with a particular method as the most accurate.

Attachments
Purchase this Solution
Solution Summary

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 whatever is the best/most accurate 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 deivaiton) and parameter values of each technique we tried. And state why we ended up going with a particular method as the most accurate.

Solution Preview

Hello:
<br>I used 3 methods to evaluate the data (as per your request). I started out by plotting the data values. Visual observation revealed cyclicity and a rising trend. So, I figured the best attack point would be a simple linear regression (leading up to ...

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

View More Free Quizzes
Related BrainMass Solutions

  • Appropriate Forecasting Technique for Aldi Foods

    (forecasting, n.d).

  • Planning tools for forecasting

    Forecasting Planning Tools 1. Quantitative Forecasting - This type of forecasting is a common method used in organizations. Quantitative predictions are generated by using past or historical data to forecast the future.

  • Developing a Financial Forecast for the Division

    Forecasting is an essential part of budgeting. Forecasting can be made by a firm for purpose other than budgeting whereas Budgeting makes by firm for purpose of forecasting (Kinney & Raiborn, 2008).

  • discussion on methodology of forecasting

    389756 Discussion on Methodology of Forecasting Provide an introduction and background discussion on methodology of forecasting. Give an example on forecasting. Forecasting is the practice of estimating future events.

  • Forecasting tools

    223236 Forecasting tools What criteria should an organization use in deciding what type of forecasting tools they should use? Criteria Used to Select Forecasting Tools Forecasting Tool is used to estimate the unknown events and situations.

  • Understanding Forecasting models as they apply to products

    houses can be forecasted by using linear regression model of forecasting-a quantitative method of demand forecasting.

  • Forecasting Methods used by Modern Corporations

    One of the newer forecasting techniques is called "scenario forecasting" (Dictionary of American History, 2003).

  • Types of demand forecasting

    This discusses the types of demand forecasting

  • The Challenges of Forecasting

    Consequences of under/over forecasting: • Under forecasting can result to opportunity cost of not being able to sell the product because no inventory exists • Under forecasting will result to lost commission for potential sales • Over forecasting

  • RevPAR and Forecasting

    409845 RevPAR and Forecasting Why is forecasting so important? How are RevPAR used for forecasting? Why is forecasting so important? How are RevPAR used for forecasting? Forecasting is important because it is less time consuming.

View More Related Solutions