Docstoc

Bi-weekly Signing - EditGrid

Document Sample
Bi-weekly Signing - EditGrid Powered By Docstoc
					                                                            Monthly Sales Report (Sep 2008)
                                                                     Confirmed Accounts

   Sales Name              Account Name                 Product        Signing Type




                SUBTOTAL
Heidy LEUNG     Q3

                SUBTOTAL
Mandy CHEE      Q3
                Blackrock                                MICE           Cross-sell
                Robert Half International HK             T&E              New
                ARINC                                    T&E              New
                Wings Travel                             T&E              New
                Mega Export                              T&E              New

                SUBTOTAL
Carrie CHAN     Q3
                HOK International                        T&E               Exp



                SUBTOTAL
Peter LEUNG     Q3
                Pacific Aviation Marketing Ltdbv         T&E               New
                E & J Galo HK Ltd                        T&E               New
                Manpower Hong Kong Ltd                   T&E               New
                Ricardo Lighting                         T&E               New
                Manner Hong Kong Ltd                     T&E               New

                SUBTOTAL
                TEAM TOTAL


                                                   Hot Accounts (potential for next or the followin

   Sales Name              Account Name                 Product        Signing Type




Heidy LEUNG     Q3

                SUBTOTAL
Mandy CHEE      Q3
               Stella Int'l Holdings                           T&E           New


               SUBTOTAL
Carrie CHAN    Q3
               IPC Information System                          T&E           New
               CAAC Holidays                                   T&E           New
               Latitude Advisors                               T&E           New
               Time Concept Group                              T&E           New
               HOK                                             BTA           New
               Q4
               Digital Marketing Group                         T&E           New
               Pfizer HK Services Co.                          T&E           Exp
               Chanel                                          T&E           New
               SUBTOTAL
Peter LEUNG    Q3
               Morning Star Travel                             T&E           New
               Electronic Art                                  T&E           New
               Profit Travel Agency Co. Ltd                    T&E           New
               Granada International Media                     T&E           New


               SUBTOTAL
               TEAM TOTAL

Summary of Product / Signing Mix
     Product                Total Amount                % of Total
T&E                                        $2,090,000           62%
BTA                                          $300,000            9%
CPS                                                $0            0%
CMC                                        $1,000,000           29%
TOTAL                                      $3,390,000                 100%
     Signing                Total Amount                % of Total
NewNew                                     $1,940,000                  57%
Expansion                                    $450,000                  13%
Cross-sell                                 $1,000,000                  29%
TOTAL                                      $3,390,000                 100%
Sales Report (Sep 2008)
onfirmed Accounts
                    Declared             MyClient
                  Amount (USD)       (Declared or not)   Cycle   Travel Agent's Name




                        $0


                        $0

                    $10,000,000            Yes             6         SKY Travel
                      2000000              Sep             6     Sunpac Tour & Travel
                        10000              Sep             6         BCD Travel
                       100000              Sep             6
                       130000              Sep             6

                    $12,240,000

                     $450,000               No             6            Fcm



                     $450,000

                    $300,000                No             6
                    $200,000                No             6
                    $100,000                No             6
                    $100,000                No             6
              ####################          No             6

              ####################
              ####################


tial for next or the following months)
                     Declared          Month to be
                     Amount             Declared         Cycle   Travel Agent's Name




                        $0
 200000        Oct       5   Many Way Travel


$200,000

 $500,000    Sep / Oct   5
 $300,000    Sep / Oct   6
 $100,000      Oct       5        FAE
 $100,000    Sep / Oct   5
$1,000,000     Oct       5        FCM

 $500,000      Nov       6
 $150,000      Nov       6       Jebsen
 $500,000      Oct       4       Travelex
$4,600,000

$1,000,000   Oct / Nov   5
 $600,000    Oct / Nov   5
 $500,000    Oct / Nov   4
 $150,000       No       6


$2,250,000
$7,050,000
    Your Name           Account Declared   Jan - Aug 2008 Billing   Expected
                                                   (USD)          Monthly Billing
                                                                     (USD)




Heidy Leung
                SAC Capital Advisors LLC   $                261   $          -
                Inform Advertising         $             13,900   $       13,000
                Harry Winston              $                162
                Total (USD) - Heidy        $             14,323   $       13,000

Mandy Chee      H C Patterson              $          1,653,661   $      333,333
                Nan Hwa Travel             $            266,155   $       33,333
                PCCW Global                $            442,131   $       66,667
                Golden Golf                $              8,649   $        4,167
                Ample Finance              $                222   $       16,667
                Destination Travel         $             93,689   $       16,667
                Merix Asia (BTA)           $             33,059   $       37,500
                Merix Asia (CC)            $              3,355   $       18,333
                RMJM                       $             22,012   $      153,846
                Blackrock (MICE)           $                363   $       83,333
                Total (USD) - Mandy        $          2,370,818   $      837,511

Carrie Chan     Wincastle Travel (USD)     $            171,993   $       42,998
                Wincastle Travel (HKD)     $             82,604   $       20,651
                Sofamark Ltd.              $             11,886   $        5,943
                Tung Hing Yip Investment   $             18,266   $        6,088
                The World Jwellery         $             35,800   $       17,899
                K. Aloomall                $                295   $          -
                Ropes & Gray               $             13,816   $        6,908
              Descartes Group             $       -     $       -
              ANCO China                  $    10,426   $     5,213
              Total (USD) - Carrie        $   320,844   $    93,579

Peter Leung   Southsea Tours Ltd          $   158,000   $    91,000
              Himmy Jewellery             $    40,160   $     8,333
              David Yurman Retail (T&E)   $     5,300   $     8,333
              David Yurman Retail (CPS)   $     3,400   $     4,166
              Zetland Financial           $    25,040   $    25,000
              Total (USD) - Peter         $   231,900   $   136,832

Total
Bill-able months   Estimated Year End    Best Estimate Monthly
remaining (Incl.      Billing (USD)         Billing Senario
      Sept)




       5
       5           $            52,000
       5
                   $            52,000

       4           $         2,986,993
       4           $           399,487
       4           $           708,799
       4           $            25,317
       0           $               222
       4           $           160,357
       4           $           183,059
       4           $            76,687
       4           $           637,396
       4           $           333,695
                   $         5,512,012

       4           $           343,986
       4           $           165,209
       4           $            35,659
       4           $            40,620
       4           $           107,399
       0           $               295
       4           $            41,450
4   $        -
4   $     31,279
    $    693,168

4   $    522,000
4   $     73,492
4   $     38,632
4   $     21,340
4   $    125,040
    $    780,504

    $   7,037,684
Note




2.2M USD (YTD)


Cards issued in late July therefore estimation stated here might not be accurate

Cards issued in late July therefore estimation stated here might not be accurate
TEAM (Declared Wins)                                Jan-08
Declared Wins                                   $        3,560,000
Monthly Wins Target (Based on 9 months)         $        8,909,821
Monthly % Target Achieved (Based on 9 months)                  40%


TEAM (Billings)                                     Jan-08
Monthly New Billngs                             $            96,346
YTD New Billings                                $            96,346
YTD Billings Target (New New)                   $                 -
% YTD Target Achieved                                        #DIV/0!
Monthly Incremental Billings
Monthly % Target Required                                        0%
Monthly % Target Achieved                                        0%


                                                    Jan-08
Declared Wins
Monthly Wins Target (Based on 9 months)         $        1,781,964
Monthly % Target Achieved (Based on 9 months)                   0%

Monthly New Billings
YTD New Billings
YTD Billings Target (New New)                   $                 -
% YTD Target Achieved                                        #DIV/0!
Monthly Incremental Billings
Monthly % Target Required                                        0%
Monthly % Target Achieved                                        0%


CARRIE CHAN                                         Jan-08
Declared Wins
Monthly Wins Target (Based on 9 months)         $        1,781,964
Monthly % Target Achieved (Based on 9 months)                   0%

Monthly New Billings
YTD New Billings
YTD Billings Target (New New)                   $                 -
% YTD Target Achieved                                        #DIV/0!
Monthly Incremental Billings
Monthly % Target Required                                        0%
Monthly % Target Achieved                                        0%

MANDY CHEE                                          Jan-08
Declared Wins
Monthly Wins Target (Based on 9 months)         $        1,781,964
Monthly % Target Achieved (Based on 9 months)                   0%

Monthly New Billings
YTD New Billings
YTD Billings Target (New New)                   $                 -
% YTD Target Achieved                                        #DIV/0!
Monthly Incremental Billings
Monthly % Target Required                                        0%
Monthly % Target Achieved                                        0%

PETER LEUNG                                         Jan-08
Declared Wins
Monthly Wins Target (Based on 9 months)         $        1,781,964
Monthly % Target Achieved (Based on 9 months)                   0%

Monthly New Billings
YTD New Billings
YTD Billings Target (New New)                   $                 -
% YTD Target Achieved                                        #DIV/0!
Monthly Incremental Billings
Monthly % Target Required                                       0%
Monthly % Target Achieved                                       0%


HEIDY LEUNG                                         Jan-08
Declared Wins                                   $                -
Monthly Wins Target (Based on 9 months)         $        1,781,964
Monthly % Target Achieved (Based on 9 months)                   0%

Monthly New Billings                            $                 -
YTD New Billings                                $                 -
YTD Billings Target (New New)                   $                 -
% YTD Target Achieved                                        #DIV/0!
Monthly Incremental Billings
Monthly % Target Required                                       0%
Monthly % Target Achieved                                       0%
    Feb-08              Mar-08            Apr-08          May-08            Jun-08
$      1,100,000 $       1,860,000        #REF!           #REF!             #REF!
$      8,909,821 $       8,909,821 $        8,909,821   $ 8,909,821       $ 8,909,821
             12%               21%        #REF!           #REF!             #REF!


    Feb-08              Mar-08            Apr-08          May-08            Jun-08
$         63,662    $       65,641    $       467,355   $   567,580       $ 1,150,384
$        160,008    $       65,641    $       532,996   $ 1,100,576       $ 2,250,858
$        561,319    $    1,403,297    $     2,525,934   $ 3,929,231       $ 5,613,187
             29%                5%                21%           28%               40%
$        (32,684)   $        1,979    $       401,714   $   100,225       $   582,804
              2%                5%                 9%           14%               20%
              1%                 0%                2%                4%                8%


    Feb-08              Mar-08            Apr-08            May-08            Jun-08
                                                                          $     100,000
$      1,781,964 $       1,781,964 $        1,781,964 $     1,781,964     $   1,781,964
              0%                0%                 0%              0%                6%



$        112,264 $         280,659 $          505,187 $      785,846 $        1,122,637
              0%                0%                 0%             0%                 0%
$              - $               - $                - $            - $                -
              2%                5%                 9%            14%                20%
              0%                0%                 0%             0%                 0%


    Feb-08              Mar-08            Apr-08            May-08      Jun-08
$              - $          60,000                      $   2,050,000 $         -
$      1,781,964 $       1,781,964 $        1,781,964   $   1,781,964 $ 1,781,964
              0%                3%                 0%            115%          0%

$              -                      $         2,356   $     36,202      $      89,661
$              -                      $         2,356   $     38,558      $     128,219
$        112,264 $         280,659    $       505,187   $    785,846      $   1,122,637
              0%                0%                 0%             5%                11%
$              - $               - $            2,356   $     33,846      $      53,459
              2%                5%                 9%            14%                20%
              0%                0%                 0%             1%                 2%

    Feb-08              Mar-08            Apr-08        May-08      Jun-08
$              - $       2,600,000 $          250,000 $ 3,250,000 $ 2,212,000
$      1,781,964 $       1,781,964 $        1,781,964 $ 1,781,964 $ 1,781,964
              0%              146%                14%        182%        124%

$              -    $       65,641    $       463,106   $     519,237     $     964,190
                    $       65,641    $       528,747   $   1,047,984     $   2,012,174
$        112,264    $      280,659    $       505,187   $     785,846     $   1,122,637
              0%               23%               105%            133%              179%
$              - $          65,641    $       397,465   $      56,131     $     444,953
              2%                5%                 9%             14%               20%
              0%                1%                 9%             19%               36%

    Feb-08              Mar-08            Apr-08            May-08            Jun-08
$              - $     1,000,000                                   $        500,000
$      1,781,964 $     1,781,964 $       1,781,964 $     1,781,964 $      1,781,964
              0%             56%                0%              0%              28%

$             -   $            -   $         1,893   $     12,141     $      96,431
                                   $         1,893   $     14,034     $     110,465
$       112,264 $        280,659   $       505,187   $    785,846     $   1,122,637
             0%               0%                0%             2%               10%
$             - $              - $           1,893   $     10,248     $      84,290
             2%               5%                9%            14%               20%
             0%               0%                0%             0%                2%


    Feb-08            Mar-08           Apr-08            May-08           Jun-08
$              - $             -
$      1,781,964 $     1,781,964 $       1,781,964 $     1,781,964 $      1,781,964
              0%              0%                0%              0%               0%

$             -   $            - $              -    $            -   $        102
$             -   $            -
$       112,264   $      280,659 $         505,187 $      785,846 $       1,122,637
             0%               0%                0%             0%                0%
$             -   $            - $               - $            - $             102
             2%               5%                9%            14%               20%
             0%               0%                0%             0%                0%



                                       HKD                USD
             US Dollar Converter        $0                 $0
    Jul-08            Aug-08            Sep-08          Oct-08         Nov-08
    #REF!             #REF!             #REF!           #REF!          #REF!
$   8,909,821     $     8,909,821   $    8,909,821
    #REF!             #REF!             #REF!


    Jul-08            Aug-08            Sep-08          Oct-08         Nov-08
$     373,699         #REF!             #REF!           #REF!          #REF!
$   2,624,659         #REF!             #REF!           #REF!          #REF!
$   7,155,884 $        10,222,692 $     13,847,100 $    18,029,111 $   22,768,722
          37%               #REF!            #REF!           #REF!          #REF!
$    (776,685)        #REF!                             #REF!          #REF!
          25%                 36%                49%           64%            81%
             9%             #REF!           #REF!           #REF!          #REF!


    Jul-08            Aug-08            Sep-08          Oct-08         Nov-08
                  $     1,100,000 $        750,000
$   1,781,964     $     1,781,964 $      1,781,964
           0%                 62%              42%

                  $     3,371,705
                  $     3,371,705
$   1,431,177     $     2,044,538 $      2,769,420 $     3,605,822 $    4,553,744
           0%                165%               0%              0%             0%
$           - $        (3,371,705) $    (3,371,705) $            - $            -
          25%                 36%              49%             64%            81%
           0%                 60%               0%              0%             0%


    Jul-08            Aug-08            Sep-08          Oct-08         Nov-08
$   1,330,000 $           650,000 $        450,000
$   1,781,964 $         1,781,964 $      1,781,964
          75%                 36%              25%

$      54,486     $       161,953
$     182,705     $       344,658
$   1,431,177     $     2,044,538 $      2,769,420 $     3,605,822 $    4,553,744
          13%                 17%               0%              0%             0%
$     (35,175)    $      (344,658) $      (344,658) $            - $            -
          25%                 36%              49%             64%            81%
           3%                  6%               0%              0%             0%

    Jul-08            Aug-08            Sep-08          Oct-08         Nov-08
$           - $           150,000 $      1,440,000
$   1,781,964 $         1,781,964 $      1,781,964
           0%                  8%              81%

$     260,195     $       404,153
$   2,272,369     $     2,676,522 $      2,676,522 $     2,676,522 $    2,676,522
$   1,431,177     $     2,044,538 $      2,769,420 $     3,605,822 $    4,553,744
         159%                131%              97%             74%            59%
$    (703,995)    $             - $              - $             - $            -
          25%                 36%              49%             64%            81%
          40%                 48%              48%             48%            48%

    Jul-08            Aug-08            Sep-08          Oct-08         Nov-08
                                 $      750,000
$   1,781,964 $        1,781,964 $    1,781,964
           0%                 0%            42%

$      44,620    $        76,815
$     155,085    $       231,900
$   1,431,177    $     2,044,538 $    2,769,420 $    3,605,822 $   4,553,744
          11%                11%             0%             0%            0%
$     (51,811)   $      (231,900) $    (231,900) $           - $           -
          25%                36%            49%            64%           81%
           3%                 4%             0%             0%            0%


    Jul-08           Aug-08           Sep-08         Oct-08        Nov-08

$   1,781,964 $        1,781,964 $    1,781,964
           0%                 0%             0%

$      14,398 $          (14,500)
$      14,500
$   1,431,177 $        2,044,538 $    2,769,420 $    3,605,822 $   4,553,744
           1%                 0%             0%             0%            0%
$      14,296 $                - $            - $            - $           -
          25%                36%            49%            64%           81%
           0%                 0%             0%             0%            0%
    Dec-08       2008 YTD
    #REF!         #REF!
                $ 80,188,385
                  #REF!


    Dec-08      2008 YTD
    #REF!        #REF!
    #REF!        #REF!
$   28,065,935 $ 28,065,935
         #REF!        #REF!
    #REF!
          100%
        #REF!            #REF!


    Dec-08          2008 YTD

                $    16,037,677
                             0%

                $     3,371,705

$   5,613,187 $       5,613,187
           0%                0%
$           -
         100%
           0%               0%


    Dec-08          2008 YTD
                $     4,540,000
                $    16,037,677
                            28%

                $      344,658

$   5,613,187 $       5,613,187
           0%
$           -
         100%
           0%               0%

    Dec-08          2008 YTD
                $     9,902,000
                $    16,037,677
                            62%

              $       2,676,522
$   2,676,522
$   5,613,187 $       5,613,187
          48%
$           -
         100%
          48%               0%

    Dec-08          2008 YTD
             $      2,250,000
             $     16,037,677
                          14%

             $       231,900

$   5,613,187 $     5,613,187
           0%              0%
$           -
         100%
           0%             0%


    Dec-08        2008 YTD
             $              -
             $     16,037,677
                           0%

             $               -

$   5,613,187 $     5,613,187
           0%              0%
$           -
         100%
           0%             0%

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:4/19/2013
language:Unknown
pages:98