Purchase Solution

Regression - 3 period moving average, and forecasting

Not what you're looking for?

Ask Custom Question

1. The chart below gives sales data (in dollars) for McTeale, small auto-parts supplier.

JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
2000 414 482 396 530 551 396 365 415 424 485 684 802
2001 457 432 465 598 632 424 392 476 489 555 768 883
2002 505 477 534 636 696 466 442 506 531 610 825 973

i. Plot the sales data in a chart in Excel.
a. Add trend line to the chart
b. Create a separate chart with a 3-period moving average.

ii. Use Excel's regression function to estimate the trend line and produce a forecast for four periods ahead.

iii. What do these charts indicate about the firm's sales over the past 3 years and expected sales for the next four periods?

iv. What do the forecasted values calculated in part ii tell you about the limitations of this type of modeling?

See attached file for full problem description.

Attachments
Purchase this Solution
Solution Preview

1. The chart below gives sales data (in dollars) for McTeale, small auto-parts supplier.

JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
2000 414 482 396 530 551 396 365 415 424 485 684 802
2001 457 432 465 598 632 424 392 476 489 555 768 883
2002 505 477 534 636 696 466 442 506 531 610 825 973

i. Plot the sales data in a chart in Excel.
a. Add trend line to the chart

I put the data in an Excel file, then made a chart and added a trend line to the chart:

b. Create a separate chart with a 3-period moving average.

I made a separate column with the 3-period ...

Purchase this Solution
Free BrainMass Quizzes
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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Analysis on 4 forecasting models using Excel

    ., which model provides the greatest degree of forecasting accuracy)? • 3-Month Moving Average Model • 3-Month Weighted Moving Average Model • Exponential Smoothing Model • Regression Model 3.

  • Quantitative analysis questions

    270 5 280 6 300 Compute a 3-period moving average for period 4. 12.

  • Forecasting using different methods

    a. 3 month moving average b. 2 month moving average c. linear regression d. exponential smoothing (.3) e. exponential smoothing (.8) Identify the MSE and the next period forecast. Hi Here is the solution. Hope its useful.

  • Mean Absolute Deviation

    These include: 1)Simple Moving Average 2)Weighted Moving Average 3)Exponential Smoothing 4)Linear Regression 5)Seasonal Forecasting via Regression (i.e., linear trends with multiplicative seasonality or nonlinear trends with multiplicative

  • Time Series Forecasting Models

    b) What is the forecast for year 13 based on the 5-year weighted moving average? c) What is the MAD for the moving average forecast? d) What is the MAD for the weighted moving average forecast? e) Which forecasting model is better?

  • Multiple choice questions

    Longer-period moving average b. Shorter-period moving average c. Moving average d. weighted moving average A 9. ___________ is a measure of the strength of the relationship between independent and dependent variables. a.

  • Operations management - job forecasting firm's sales

    What is the forecast for period #11 using the following methods: a. Naïve Forecast b. 3-period moving average c. 3-period moving average, using weights of .5, .3 and .2 d.

  • Forecasting

    The solution contains several forecasting problems using moving average method and regression analysis.

  • Mean Absolute Percent Error

    What is the projected demand for the equipment for time period 25 based upon using a 3-month moving average forecast model? Projected demand for period 25: (64+70+72)/3=68.67 2.

  • What is the linear regression and 5-month moving average forecast for the sales data?

    Even moving average can be complicated using an exponential moving average instead of simple moving average. All these forecasting techniques work in tandem and no one is better than the other.

View More Related Solutions