Explore BrainMass
Share

Explore BrainMass

    Forecasting Demand with Seasonality and Growth

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

    Develop and justify a forecasting method taking into consideration seasonal trends, stability for repeat customers and anticipating growth of repetitive customers. Then forecast aggregate demand for 2008 using the following sales (in thousands):

    Month 2003 2004 2005 2006 2007
    Jan 2 3 2 5 5
    Feb 3 4 5 4 2
    Mar 3 3 5 4 3
    Apr 3 5 3 2 2
    May 4 5 4 5 7
    Jun 6 8 6 7 6
    Jul 7 3 7 10 8
    Aug 6 8 10 14 10
    Sep 10 12 15 16 20
    Oct 12 12 15 16 20
    Nov 14 16 18 20 22
    Dec 8 10 8 12 8

    © BrainMass Inc. brainmass.com October 9, 2019, 11:09 pm ad1c9bdddf
    https://brainmass.com/business/business-management/forecasting-demand-with-seasonality-and-growth-246577

    Attachments

    Solution Preview

    Dear Student,
    I have provided the solution in the attached spreadsheet. For the 2008 demand forecast I have used the following steps:

    Step 1. Identify seasonality. The first chart shows you that there is seasonality in January and November. Sales peaks in November and ...

    Solution Summary

    The solution shows a step by step demand forecasting method with seasonality and expected growth. It also provides a power point presentation for students require detail explanation.

    $2.19