Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Copy of RESIT-BA_Mohit

VIEWS: 3 PAGES: 13

									  Q.2.


                                                           moving    Central avg
           Year   Quarters Quarters Revenue   Commission   avg rev      Rev
                    1         3     £58,839     £15,587
                    2         4     £62,712     £16,554    £60,259
           1999     3         1     £61,249     £17,787    £59,435     £59,847
                    4         2     £58,236     £17,654    £58,735     £59,085
                    5         3     £55,543     £16,539    £58,377     £58,556
                    6         4     £59,910     £16,097    £58,500     £58,439
           2000     7         1     £59,820     £17,784    £58,174     £58,337
                    8         2     £58,727     £17,100    £58,145     £58,160
                    9         3     £54,239     £16,521    £57,764     £57,954
                    10        4     £59,794     £16,401    £56,957     £57,360
           2001     11        1     £58,294     £17,306    £56,644     £56,801
                    12        2     £55,502     £16,853    £56,123     £56,383
                    13        3     £52,985     £16,064    £56,027     £56,075
                    14        4     £57,711     £16,300    £55,894     £55,960
           2002     15        1     £57,908     £17,176    £55,980     £55,937
                    16        2     £54,970     £16,960    £55,748     £55,864
                    17        3     £53,332     £16,728    £55,464     £55,606
                    18        4     £56,781     £15,485    £55,332     £55,398
           2003     19        1     £56,773     £17,098    £54,799     £55,065
                    20        2     £54,441     £17,033    £54,195     £54,497
                    21        3     £51,200     £16,456    £53,977     £54,086
                    22        4     £54,364     £15,519    £53,623     £53,800
           2004     23        1     £55,901     £15,995    £53,282     £53,452
                    24        2     £53,026     £16,075    £53,597     £53,439
                    25        3     £49,837     £12,855    £53,637     £53,617
                    26        4     £55,623     £15,070    £53,966     £53,801
           2005     27        1     £56,060     £13,748    £54,615     £54,291
                    28        2     £54,345     £13,394    £55,232     £54,923
                    29        3     £52,432     £12,966    £55,781     £55,506
                    30        4     £58,089     £14,517    £56,442     £56,111
           2006     31        1     £58,257     £14,527    £57,057     £56,749
                    32        2     £56,989     £14,171    £57,636     £57,346
                    33        3     £54,891     £13,454    £58,381     £58,008
                    34        4     £60,407     £15,180    £58,951     £58,666
           2007     35        1     £61,235     £14,867    £59,623     £59,287
                    36        2     £59,270     £14,862    £60,237     £59,930
                    37        3     £57,581     £14,549    £60,815     £60,526
                    38        4     £62,863     £15,472    £61,482     £61,149
           2008     39        1     £63,547     £15,631    £62,023     £61,753
                    40        2     £61,936     £15,003    £62,676     £62,349
                    41        3     £59,747     £15,065    £63,370     £63,023
                    42        4     £65,472     £16,662                £63,476
           2009     43        1     £66,326     £16,220                £64,073
 1st not            44        2     £15,361     £15,986                £15,815
forecast            45        3     £62,148     £15,417                £65,265
start                 46           4       £67,547       £16,087               £65,861
here    2010          47           1       £68,295       £16,604               £66,457
                      48           2       £66,640       £16,480               £67,054
                      49           3       £64,522       £15,943               £67,650
                      50           4       £69,953       £16,695               £68,246




                                           % commission
           120%

           100%
                                                                                R² = 0.0002
               80%

               60%                                                     % commission

               40%                                                     Linear (% commission)

               20%

               0%
                     1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49
                           1st not         1st not         1st imp
                                                          with graph

moving avg Central avg   Variation in   Variations in
commission Commission     Revenue       Commission      % commission
                                                            26%
  £16,896                                                   26%
  £17,134    £17,015        £1,402           £773           29%
  £17,019    £17,076        -£849            £578           30%
  £17,019    £17,019       -£3,013          -£480           30%
  £16,880    £16,949        £1,471          -£852           27%
  £16,876    £16,878        £1,483           £906           30%
  £16,952    £16,914         £568            £187           29%
  £16,832    £16,892       -£3,715          -£371           30%
  £16,770    £16,801        £2,434          -£400           27%
  £16,656    £16,713        £1,494           £593           30%
  £16,631    £16,643        -£881            £210           30%
  £16,598    £16,615       -£3,090          -£551           30%
  £16,625    £16,612        £1,751          -£312           28%
  £16,791    £16,708        £1,971           £468           30%
  £16,587    £16,689        -£894            £271           31%
  £16,568    £16,578       -£2,274           £151           31%
  £16,586    £16,577        £1,383         -£1,092          27%
  £16,518    £16,552        £1,708           £546           30%
  £16,527    £16,522         -£56            £511           31%
  £16,251    £16,389       -£2,886            £67           32%
  £16,011    £16,131         £564           -£612           29%
  £15,111    £15,561        £2,449           £434           29%
  £14,999    £15,055        -£413           £1,020          30%
  £14,437    £14,718       -£3,780         -£1,863          26%
  £13,767    £14,102        £1,822           £968           27%
  £13,795    £13,781        £1,769           -£33           25%
  £13,656    £13,725        -£578           -£331           25%
  £13,851    £13,754       -£3,074          -£788           25%
  £14,045    £13,948        £1,978           £569           25%
  £14,167    £14,106        £1,508           £421           25%
  £14,333    £14,250        -£357            -£79           25%
  £14,418    £14,376       -£3,117          -£922           25%
  £14,591    £14,504        £1,741           £676           25%
  £14,865    £14,728        £1,948           £139           24%
  £14,938    £14,901        -£660            -£39           25%
  £15,129    £15,033       -£2,945          -£484           25%
  £15,164    £15,146        £1,715           £326           25%
  £15,293    £15,228        £1,795           £403           25%
  £15,590    £15,442        -£413           -£439           24%
  £15,738    £15,664       -£3,276          -£599           25%
  £15,983    £15,860        £1,996           £802           25%
             £15,682        £2,253           £423           24%
             £15,815        -£453            £172           104%
             £15,947       -£3,117          -£531           25%
                            £16,080          £1,685           £7             24%
                            £16,213          £1,838          £391            24%
                            £16,345          -£414           £135            25%
                            £16,478         -£3,127         -£535            25%
                            £16,611          £1,707           £85            24%




                       £80,000
                                                                                        R² = 0.0265
                       £70,000                                                          R² = 0.1491
        R² = 0.0002
                       £60,000

                       £50,000                                                     Revenue

inear (% commission)   £40,000                                                     Commission
                                                                                   Linear (Revenue)
                       £30,000
                                                                                   Linear (Commission)
                       £20,000

                       £10,000

                           £0
                                 1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49
          Revenue
                    R² = 0.0265   80000
£80,000
£70,000                           70000
£60,000                           60000
£50,000                           50000
£50,000                                                                               50000
£40,000                                                     Revenue                   40000
£30,000                                                                               30000
                                                            Linear (Revenue)
£20,000                                                                               20000
£10,000                                                                               10000
     £0                                                                                   0
          1 4 7 1013161922252831343740434649




                                Commission                             R² = 0.1491
£20,000
£18,000
£16,000
£14,000
£12,000
£10,000                                                         Commission
 £8,000
                                                                Linear (Commission)
 £6,000
 £4,000
 £2,000
     £0
          1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49
        Central avg Rev
80000                     R² = 0.044
70000
60000
50000
50000
40000                                                             Central avg Rev
30000                                                             Linear (Central avg Rev)
20000
10000
   0
         1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49




                           Central avg Commission
        18000
                                                                            R² = 0.2007
        16000
        14000
        12000
        10000                                                           Central avg Commission
         8000
         6000                                                           Linear (Central avg
                                                                        Commission)
         4000
         2000
            0
                1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49
Year   Quarters Revenue         Commissions
          1             £58,839               £15,587
          2             £62,712               £16,554
1999      3             £61,249               £17,787
          4             £58,236               £17,654
          5             £55,543               £16,539
          6             £60,010               £16,097
2000      7             £59,820               £17,784
          8             £58,727               £17,100
          9             £54,339               £16,521
         10             £59,794               £16,401
2001     11             £58,294               £17,306
         12             £55,502               £16,853
         13             £52,985               £16,064
         14             £57,711               £16,300
2002     15             £57,908               £17,176
         16             £54,970               £16,960
         17             £53,332               £16,728
         18             £56,781               £15,485
2003     19             £56,773               £17,098
         20             £54,441               £17,033
         21             £51,200               £16,456
         22             £54,464               £15,519
2004     23             £55,901               £15,995
         24             £53,026               £16,075
         25             £49,837               £12,855
         26             £55,623               £15,070
2005     27             £56,060               £13,748
         28             £54,345               £13,394
         29             £52,432               £12,966
         30             £58,089               £44,517
2006     31             £58,257               £14,527
         32             £56,989               £14,171
         33             £54,891               £13,454
         34             £60,407               £15,180
2007     35             £61,235               £14,867
         36             £59,270               £14,862
         37             £57,681               £14,549
         38             £62,863               £15,472
2008     39             £63,547               £15,631
         40             £61,936               £15,003
         41             £59,747               £15,065
         42             £65,572               £16,662
2009     43             £66,326               £16,220
Phone Sales Team Quarterly Revenue and Commis
evenue and Commissions

								
To top