Explore BrainMass
Share

Seasonally Adjusted Forecast

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

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

© BrainMass Inc. brainmass.com October 25, 2018, 4:20 am ad1c9bdddf
https://brainmass.com/statistics/multivariate-time-series-and-survival-analysis/seasonally-adjusted-forecast-375386

Solution Summary

This solution is comprised of detailed step-by-step calculation of the given problem in EXCEL and provides students with a clear perspective of the underlying concepts.

$2.19
See Also This Related BrainMass Solution

Seasonally Adjusted Forecast

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

View Full Posting Details