Get documents about "Excel - ww2.justanswer.co.uk
Document Sample
Month Year 1 Year 2 Year 3 Year 4 Average
1 18,000 45,100 59,800 35,500 39,600.00
2 19,800 46,530 30,740 51,250 37,080.00
3 15,700 22,100 47,800 34,400 30,000.00
4 53,600 41,350 73,890 68,000 59,210.00
5 83,200 46,000 60,200 68,100 64,375.00
6 72,900 41,800 55,200 61,100 57,750.00
7 55,200 39,800 32,180 62,300 47,370.00
8 57,350 64,100 38,600 66,500 56,637.50
9 15,400 47,600 25,020 31,400 29,855.00
10 27,700 43,050 51,300 36,500 39,637.50
11 21,400 39,300 31,790 16,800 27,322.50
12 17,100 10,300 31,100 18,900 19,350.00
Total 457,350.00 487,030.00 537,620.00 550,750.00 508,187.50
Average of Monthly Averages 42,348.96
Month Average Index
1 39,600.00 0.935088
2 37,080.00 0.875582
3 30,000.00 0.708400
4 59,210.00 1.398145
5 64,375.00 1.520108
6 57,750.00 1.363670
7 47,370.00 1.118564
8 56,637.50 1.337400
9 29,855.00 0.704976
10 39,637.50 0.935973
11 27,322.50 0.645175
12 19,350.00 0.456918
Month 1 2 3 4 5 6 7 8 9
Year 1 18,000 19,800 15,700 53,600 83,200 72,900 55,200 57,350 15,400
Year 2 45,100 46,530 22,100 41,350 46,000 41,800 39,800 64,100 47,600
Year 3 59,800 30,740 47,800 73,890 60,200 55,200 32,180 38,600 25,020
Year 4 35,500 51,250 34,400 68,000 68,100 61,100 62,300 66,500 31,400
Year Average Demand Average Demand
1 38,112.50
2 40,585.83 50,000.00
45,000.00
3 44,801.67
40,000.00
4 45,895.83
35,000.00
30,000.00
38,214.08 25,000.00
20,000.00
15,000.00
10,000.00
5,000.00
-
0 0.5 1 1.5 2 2.5 3 3.5
The trendline equation computed by Excel is: y = 2756.6x + 35458
Forecast for year 5 is: y = 2756.6*5 + 35458 = 49,241
10 11 12 Average
27,700 21,400 17,100 38,112.50
43,050 39,300 10,300 40,585.83
51,300 31,790 31,100 44,801.67
36,500 16,800 18,900 45,895.83
Demand
y = 2756.6x + 35458
Average Demand
3.5 4 4.5
The trendline equation is: y = 2756.6x + 35458
Forecast for year 5 is: y = 2756.6*5 + 35458 = 49,241
Month Average Index Forecast
1 39,600.00 0.935088 46,044.67 Monthly Forecast for Year
2 37,080.00 0.875582 43,114.55
80,000.00
3 30,000.00 0.708400 34,882.32
70,000.00
4 59,210.00 1.398145 68,846.08
5 64,375.00 1.520108 74,851.65 60,000.00
6 57,750.00 1.363670 67,148.47 50,000.00
7 47,370.00 1.118564 55,079.19 40,000.00
8 56,637.50 1.337400 65,854.92 30,000.00
9 29,855.00 0.704976 34,713.72 20,000.00
10 39,637.50 0.935973 46,088.27
10,000.00
11 27,322.50 0.645175 31,769.07
12 19,350.00 0.456918 22,499.10 -
1 2 3 4 5 6 7
ly Forecast for Year 5
Forecast
7 8 9 10 11 12
Month Year 1 Year 2 Year 3 Year 4
1 18,000 45,100 59,800 35,500
2 19,800 46,530 30,740 51,250
3 15,700 22,100 47,800 34,400
4 53,600 41,350 73,890 68,000
5 83,200 46,000 60,200 68,100
6 72,900 41,800 55,200 61,100
7 55,200 39,800 32,180 62,300
8 57,350 64,100 38,600 66,500
9 15,400 47,600 25,020 31,400
10 27,700 43,050 51,300 36,500
11 21,400 39,300 31,790 16,800
12 17,100 10,300 31,100 18,900
Total Four Year Demand by Month)
300,000
250,000
200,000
150,000
100,000
50,000
0
1 2 3 4 5 6 7 8 9 10
Year 4
Year 3
Year 2
Year 1
11 12
Month 1 2 3 4 5 6 7
Year 1 18,000 19,800 15,700 53,600 83,200 72,900 55,200
Year 2 45,100 46,530 22,100 41,350 46,000 41,800 39,800
Year 3 59,800 30,740 47,800 73,890 60,200 55,200 32,180
Year 4 35,500 51,250 34,400 68,000 68,100 61,100 62,300
Maximum value 59,800.00 51,250.00 47,800.00 73,890.00 83,200.00 72,900.00 62,300.00
3rd Quartile 48,775.00 47,710.00 37,750.00 69,472.50 71,875.00 64,050.00 56,975.00
Median 40,300.00 38,635.00 28,250.00 60,800.00 64,150.00 58,150.00 47,500.00
1st Quartile 31,125.00 28,005.00 20,500.00 50,537.50 56,650.00 51,850.00 37,895.00
Minimum Value 18,000.00 19,800.00 15,700.00 41,350.00 46,000.00 41,800.00 32,180.00
160%
140%
120%
100%
80%
60%
40%
20%
0%
1 2 3 4 5 6 7 8
8 9 10 11 12
57,350 15,400 27,700 21,400 17,100
64,100 47,600 43,050 39,300 10,300
38,600 25,020 51,300 31,790 31,100
66,500 31,400 36,500 16,800 18,900
66,500.00 47,600.00 51,300.00 39,300.00 31,100.00
64,700.00 35,450.00 45,112.50 33,667.50 21,950.00
60,725.00 28,210.00 39,775.00 26,595.00 18,000.00
52,662.50 22,615.00 34,300.00 20,250.00 15,400.00
38,600.00 15,400.00 27,700.00 16,800.00 10,300.00
8 9 10 11 12
