2006
1
3721

2
2988

3
4115
4712.375
4686.0749999999998
0.8781336192869299

4
7547
4870.375
4890.5874999999996
1.5431683821217799

2007
5
4678
5056.625
5095.1000000000004
0.91813703362053734

6
3295
5332
5299.6124999999993
0.62174357087428567

7
5298
5504.125

8
8567
5708.6374999999998

2008
9
5329
5913.15
5429.0820003532799

10
3992
6117.6625000000004

11
6065
6322.1749999999993

12
10509
6526.6875

2009
13
6633
6731.2

14
5380
6935.7124999999996

15
4074
7140.2250000000004

16
12750
7344.7374999999993

2010
17
6976
7549.25

18
5732
7753.7624999999998

19
7494
7958.2749999999996

20
14135
8162.7875000000004

2011
21
8367.2999999999993

22
8571.8125

23
8776.3249999999989

24
8980.8374999999996

2012
25
9185.35

26
9389.8624999999993

27
9594.375

28
9798.8874999999989

2013
29
10003.4

30
10207.9125

31
10412.424999999999

32
10616.9375

2014
33
10821.449999999999

34
11025.9625

35
11230.475

36
11434.987499999999

2015
37
11639.5

38
11844.012499999999

39
12048.525

40
12253.0375

Year
Quarter
Num
I
II
III
IV
Demand
MA
Trend
Seasonal Factor
Forecast

On the Data sheet is the historical demand for the last 5 years (2006-2010). Based on this data, develop a demand forecast for the next 5 years (2011-2015).
There is a feeling among many in the company that demand is beginning to slow. Thus, two forecasts are desired. One in which the historical growth is extended out over the next five years, i.e., no change in growth rate. The second forecast should use the current growth rate for the next two years (through the 4th quarter of 2012). However, over the final three years (beginning with the first quarter of 2013), the growth rate should decrease by 30% from the current growth rate. Identify a single cell to specify this reduced growth rate. Then the growth rate for years 2013 through 2015 can then be changed by changing the value in this cell.
Comment on any assumptions you made as you developed your forecasts. For…