Share
Explore BrainMass

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

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