Explore BrainMass
Share

Regression - 3 period moving average, and forecasting

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com October 24, 2018, 8:49 pm ad1c9bdddf
https://brainmass.com/statistics/regression-analysis/regression-3-period-moving-average-and-forecasting-108804

Attachments

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

$2.19
See Also This Related BrainMass Solution

This is a graduate level mathematic/accounting question for an operations management class

Historical demand for a product is

DEMAND
January 12
February 11
March 15
April 12
May 16
June 15

a. Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast.

b. Using a simple three-month moving average, find the July forecast.

c. Using single exponential smoothing with α = 0.2 and a June forecast = 13, find the July forecast. Make whatever assumptions you wish.

d. Using simple linear regression analysis, calculate the regression equation for the preceding demand data.

e. Using the regression equation in d, calculate the forecast for July.

Thanks

View Full Posting Details