Share
Explore BrainMass

Forecasting Demand with Seasonality and Growth

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

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