Explore BrainMass

Explore BrainMass

    Seasonally Adjusted Forecast

    This content was COPIED 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 June 4, 2020, 12:01 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

    ADVERTISEMENT