Explore BrainMass
Share

Seasonally Adjusted Forecast

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

From the given data develop a seasonally adjusted forecast for 2006. (Use a linear trend line model to develop a forecast estimate for 2006.)

Year Quarter Ice cream sales (gal)

2003 1 350
2 510
3 750
4 420

2004 5 370
6 480
7 860
8 500

2005 9 450
10 550
11 820
12 570

© BrainMass Inc. brainmass.com October 25, 2018, 2:45 am ad1c9bdddf
https://brainmass.com/statistics/general-linear-model/seasonally-adjusted-forecast-313623

Solution Summary

This solution is comprised of detailed analysis and step-by-step calculations of Seasonally Adjusted Forecast in EXCEL. The solution provides students with a clear perspective of the various aspects of forecast analysis, e.g. calculation of Seasonal Indices, Linear Trendline, Prediction Value, etc.

$2.19
See Also This Related BrainMass Solution

Seasonally Adjusted Forecast

Small Wonder, an amusement park, experiences seasoned attendance. It has collected two years of quarterly attendance data and made a forecast of annual attendance for the upcoming year. Compute the seasonal indexes for the four quarters and generate quarterly forecasts for the coming year, assuming annual attendance for the coming year to be 1525.

Quarter Park Attendance Year 1 Park Attendance Year 2
Fall 352 391
Winter 156 212
Spring 489 518
Summer 314 352

View Full Posting Details