Docstoc

Excel - ww2.justanswer.co.uk

Document Sample
Excel - ww2.justanswer.co.uk Powered By Docstoc
					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

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:53
posted:3/15/2011
language:English
pages:9