Spreadsheet-CompensationModelForCallCenterReps

Document Sample
Spreadsheet-CompensationModelForCallCenterReps Powered By Docstoc
					                                                            FILE = e79fa221-ee37-4b28-b5cc-b7f0a1a70a3b.xls
TheSmallBusinessOwnersManual.com          Thursday      Friday   Monday    Tuesday Wednesday    Thursday      Friday     Monday    Tuesday Wednesday     Thursday
                            Date            1-Sep       2-Sep     5-Sep     6-Sep      7-Sep      8-Sep       9-Sep     12-Sep     13-Sep     14-Sep     15-Sep
                           Business Day         1           2         3         4          5          6           7          8          9         10         11
Hours per day                    4              4          4          4         4         4           4          4           4          4          4           4
Calls per hour                  10             10         10         10        10        10          10         10          10         10         10          10
Calls per day                                  40         40         40        40        40          40         40          40         40         40          40
Find and s/w the X               5              8          8          8         8         8           8          8           8          8          8           8
   - NO                       75%               6          6          6         6         6           6          6           6          6          6           6
   = New Prospects            25%               2          2          2         2         2           2          2           2          2          2           2
Cumulative prospects           0%               2          4          2         4         2           4          2           4          2          4           2
  Lose                        75%               0          3          0         3         0           3          0           3          0          3           0
  Win                         25%               0          1          0         1         0           1          0           1          0          1           0
Prospects Out                                   0         -4          0        -4         0          -4          0          -4          0         -4           0
Follow up calls to each prospect3               3          3          3         3         3           3          3           3          3          3           3
Total prospect follow up calls                  6          6          6         6         6           6          6           6          6          6           6
Total calls today                              46         46         46        46        46          46         46          46         46         46          46

Number of units per deal                                  500                   40                  500                     500                   600

Daily P&L
Revenues                        $12.50       0.00    6,250.00      0.00    500.00       0.00   6,250.00        0.00    6,250.00      0.00    7,500.00       0.00
Direct Expenses                  $7.00       0.00    3,500.00      0.00    280.00       0.00   3,500.00        0.00    3,500.00      0.00    4,200.00       0.00
Gross Margin                     $5.50       0.00    2,750.00      0.00    220.00       0.00   2,750.00        0.00    2,750.00      0.00    3,300.00       0.00

G&A Expenses
 Hourly (Draw)        $17.50               70.00        70.00     70.00     70.00     70.00       70.00      70.00        70.00     70.00       70.00     70.00
 Taxes                  21%                14.70        14.70     14.70     14.70     14.70       14.70      14.70        14.70     14.70       14.70     14.70
 Med Insurance       $400.00               19.51        19.51     19.51     19.51     19.51       19.51      19.51        19.51     19.51       19.51     19.51
 Parking              $77.00                3.76         3.76      3.76      3.76      3.76        3.76       3.76         3.76      3.76        3.76      3.76
 Office/Telephone/PC $500.00               24.39        24.39     24.39     24.39     24.39       24.39      24.39        24.39     24.39       24.39     24.39
 Commissions            20%                 0.00       550.00      0.00     44.00      0.00      550.00       0.00       550.00      0.00      660.00      0.00
 Draw Repmt                                 0.00      -140.00      0.00    -44.00      0.00     -236.00       0.00      -140.00      0.00     -140.00      0.00
Total G&A Expenses                        132.36       542.36    132.36    132.36    132.36      446.36     132.36       542.36    132.36      652.36    132.36

Rep Compensation
 Draw Acc Balance (end)                    70.00         0.00     70.00     96.00    166.00        0.00       70.00        0.00     70.00        0.00     70.00
 Pay to Rep Today (hourly
 +commission+draw repmt)                   70.00      480.00      70.00     70.00     70.00      384.00       70.00      480.00      70.00     590.00      70.00
 Cumulative Paid to Rep                    70.00      550.00     620.00    690.00    760.00    1,144.00    1,214.00    1,694.00   1,764.00   2,354.00   2,424.00
 Cumulative Hours Worked                       4           8         12        16        20          24          28          32         36         40         44
 Hourly Rate                               17.50       68.75      51.67     43.13     38.00       47.67       43.36       52.94      49.00      58.85      55.09


    Printed 8/22/2012, 3:53 AM                                                                                                                    Page 1 of 10
                                                FILE = e79fa221-ee37-4b28-b5cc-b7f0a1a70a3b.xls


Cumulative -
 Wins                                   0        1        1         2         2          3          3          4          4          5          5
 Units Sold                     0       0        0        0         0         0          0          0          0          0          0          0
 Hourly (Draw)                      70.00   140.00   210.00    280.00    350.00     420.00     490.00     560.00     630.00     700.00     770.00
 Gross Commissions                   0.00   550.00   550.00    594.00    594.00   1,144.00   1,144.00   1,694.00   1,694.00   2,354.00   2,354.00
 Commissions After Draw              0.00   410.00   340.00    314.00    244.00     724.00     654.00   1,134.00   1,064.00   1,654.00   1,584.00




   Printed 8/22/2012, 3:53 AM                                                                                                      Page 2 of 10
                                                     FILE = e79fa221-ee37-4b28-b5cc-b7f0a1a70a3b.xls
  Sunday     Monday    Tuesday Wednesday       Thursday     Sunday     Monday    Tuesday Wednesday     Thursday      Friday    Saturday     Sunday     Monday
 18-Sep     19-Sep     20-Sep       21-Sep     22-Sep      25-Sep     26-Sep     27-Sep     28-Sep     29-Sep      30-Sep        1-Oct       2-Oct      3-Oct
     12         13         14           15         16          17         18         19         20         21          22           23          24         25
      4          4          4            4           4          4          4          4          4           4          4            4          4          4
     10         10         10           10          10         10         10         10         10          10         10           10         10         10
     40         40         40           40          40         40         40         40         40          40         40           40         40         40
      8          8          8            8           8          8          8          8          8           8          8            8          8          8
      6          6          6            6           6          6          6          6          6           6          6            6          6          6
      2          2          2            2           2          2          2          2          2           2          2            2          2          2
      4          2          4            2           4          2          4          2          4           2          4            2          4          2
      3          0          3            0           3          0          3          0          3           0          3            0          3          0
      1          0          1            0           1          0          1          0          1           0          1            0          1          0
     -4          0         -4            0          -4          0         -4          0         -4           0         -4            0         -4          0
      3          3          3            3           3          3          3          3          3           3          3            3          3          3
      6          6          6            6           6          6          6          6          6           6          6            6          6          6
     46         46         46           46          46         46         46         46         46          46         46           46         46         46

      10                      10                   500                     10                    10                     10                     400



 125.00       0.00     125.00         0.00    6,250.00       0.00     125.00        0.00    125.00        0.00     125.00         0.00    5,000.00      0.00
  70.00       0.00      70.00         0.00    3,500.00       0.00      70.00        0.00     70.00        0.00      70.00         0.00    2,800.00      0.00
  55.00       0.00      55.00         0.00    2,750.00       0.00      55.00        0.00     55.00        0.00      55.00         0.00    2,200.00      0.00


  70.00      70.00      70.00        70.00       70.00      70.00      70.00      70.00      70.00      70.00       70.00       70.00        70.00     70.00
  14.70      14.70      14.70        14.70       14.70      14.70      14.70      14.70      14.70      14.70       14.70       14.70        14.70     14.70
  19.51      19.51      19.51        19.51       19.51      19.51      19.51      19.51      19.51      19.51       19.51       19.51        19.51     19.51
   3.76       3.76       3.76         3.76        3.76       3.76       3.76       3.76       3.76       3.76        3.76        3.76         3.76      3.76
  24.39      24.39      24.39        24.39       24.39      24.39      24.39      24.39      24.39      24.39       24.39       24.39        24.39     24.39
  11.00       0.00      11.00         0.00      550.00       0.00      11.00       0.00      11.00       0.00       11.00        0.00       440.00      0.00
 -11.00       0.00     -11.00         0.00     -398.00       0.00     -11.00       0.00     -11.00       0.00      -11.00        0.00      -440.00      0.00
 132.36     132.36     132.36       132.36      284.36     132.36     132.36     132.36     132.36     132.36      132.36      132.36       132.36    132.36


 129.00     199.00     258.00       328.00        0.00      70.00     129.00     199.00     258.00     328.00      387.00      457.00       87.00     157.00

   70.00      70.00      70.00        70.00     222.00       70.00      70.00      70.00      70.00      70.00       70.00       70.00       70.00      70.00
2,494.00   2,564.00   2,634.00     2,704.00   2,926.00    2,996.00   3,066.00   3,136.00   3,206.00   3,276.00    3,346.00    3,416.00    3,486.00   3,556.00
      48         52         56           60         64          68         72         76         80         84          88          92          96        100
   51.96      49.31      47.04        45.07      45.72       44.06      42.58      41.26      40.08      39.00       38.02       37.13       36.31      35.56


 Printed 8/22/2012, 3:53 AM                                                                                                                    Page 3 of 10
                                                  FILE = e79fa221-ee37-4b28-b5cc-b7f0a1a70a3b.xls



       6          6          7          7          8          8          9          9         10         10         11         11         12         12
       0          0          0          0          0          0          0          0          0          0          0          0          0          0
  840.00     910.00     980.00   1,050.00   1,120.00   1,190.00   1,260.00   1,330.00   1,400.00   1,470.00   1,540.00   1,610.00   1,680.00   1,750.00
2,365.00   2,365.00   2,376.00   2,376.00   2,926.00   2,926.00   2,937.00   2,937.00   2,948.00   2,948.00   2,959.00   2,959.00   3,399.00   3,399.00
1,525.00   1,455.00   1,396.00   1,326.00   1,806.00   1,736.00   1,677.00   1,607.00   1,548.00   1,478.00   1,419.00   1,349.00   1,719.00   1,649.00




 Printed 8/22/2012, 3:53 AM                                                                                                              Page 4 of 10
                                                     FILE = e79fa221-ee37-4b28-b5cc-b7f0a1a70a3b.xls
 Thursday      Friday    Saturday     Sunday     Monday    Thursday      Friday    Saturday     Sunday     Monday    Thursday      Friday    Saturday     Sunday
   6-Oct       7-Oct       8-Oct       9-Oct     10-Oct     13-Oct      14-Oct      15-Oct      16-Oct     17-Oct     20-Oct      21-Oct      22-Oct      23-Oct
      26          27          28          29         30         31          32          33          34         35         36          37          38          39
       4          4            4          4          4           4          4            4          4          4           4          4            4          4
      10         10           10         10         10          10         10           10         10         10          10         10           10         10
      40         40           40         40         40          40         40           40         40         40          40         40           40         40
       8          8            8          8          8           8          8            8          8          8           8          8            8          8
       6          6            6          6          6           6          6            6          6          6           6          6            6          6
       2          2            2          2          2           2          2            2          2          2           2          2            2          2
       4          2            4          2          4           2          4            2          4          2           4          2            4          2
       3          0            3          0          3           0          3            0          3          0           3          0            3          0
       1          0            1          0          1           0          1            0          1          0           1          0            1          0
      -4          0           -4          0         -4           0         -4            0         -4          0          -4          0           -4          0
       3          3            3          3          3           3          3            3          3          3           3          3            3          3
       6          6            6          6          6           6          6            6          6          6           6          6            6          6
      46         46           46         46         46          46         46           46         46         46          46         46           46         46

     500                     600                     80                    200                     200                   100                     100



6,250.00       0.00     7,500.00       0.00    1,000.00       0.00    2,500.00        0.00    2,500.00      0.00    1,250.00       0.00     1,250.00       0.00
3,500.00       0.00     4,200.00       0.00      560.00       0.00    1,400.00        0.00    1,400.00      0.00      700.00       0.00       700.00       0.00
2,750.00       0.00     3,300.00       0.00      440.00       0.00    1,100.00        0.00    1,100.00      0.00      550.00       0.00       550.00       0.00


   70.00      70.00        70.00      70.00      70.00      70.00        70.00      70.00        70.00     70.00       70.00      70.00        70.00      70.00
   14.70      14.70        14.70      14.70      14.70      14.70        14.70      14.70        14.70     14.70       14.70      14.70        14.70      14.70
   19.51      19.51        19.51      19.51      19.51      19.51        19.51      19.51        19.51     19.51       19.51      19.51        19.51      19.51
    3.76       3.76         3.76       3.76       3.76       3.76         3.76       3.76         3.76      3.76        3.76       3.76         3.76       3.76
   24.39      24.39        24.39      24.39      24.39      24.39        24.39      24.39        24.39     24.39       24.39      24.39        24.39      24.39
  550.00       0.00       660.00       0.00      88.00       0.00       220.00       0.00       220.00      0.00      110.00       0.00       110.00       0.00
 -227.00       0.00      -140.00       0.00     -88.00       0.00      -192.00       0.00      -140.00      0.00     -110.00       0.00      -110.00       0.00
  455.36     132.36       652.36     132.36     132.36     132.36       160.36     132.36       212.36    132.36      132.36     132.36       132.36     132.36


    0.00      70.00         0.00      70.00      52.00     122.00         0.00      70.00         0.00     70.00      30.00      100.00       60.00      130.00

  393.00       70.00      590.00       70.00      70.00      70.00       98.00       70.00      150.00      70.00      70.00       70.00       70.00       70.00
3,949.00    4,019.00    4,609.00    4,679.00   4,749.00   4,819.00    4,917.00    4,987.00    5,137.00   5,207.00   5,277.00    5,347.00    5,417.00    5,487.00
     104         108         112         116        120        124         128         132         136        140        144         148         152         156
   37.97       37.21       41.15       40.34      39.58      38.86       38.41       37.78       37.77      37.19      36.65       36.13       35.64       35.17


 Printed 8/22/2012, 3:53 AM                                                                                                                       Page 5 of 10
                                                  FILE = e79fa221-ee37-4b28-b5cc-b7f0a1a70a3b.xls



      13         13         14         14         15         15         16         16         17         17         18         18         19         19
       0          0          0          0          0          0          0          0          0          0          0          0          0          0
1,820.00   1,890.00   1,960.00   2,030.00   2,100.00   2,170.00   2,240.00   2,310.00   2,380.00   2,450.00   2,520.00   2,590.00   2,660.00   2,730.00
3,949.00   3,949.00   4,609.00   4,609.00   4,697.00   4,697.00   4,917.00   4,917.00   5,137.00   5,137.00   5,247.00   5,247.00   5,357.00   5,357.00
2,129.00   2,059.00   2,649.00   2,579.00   2,597.00   2,527.00   2,677.00   2,607.00   2,757.00   2,687.00   2,727.00   2,657.00   2,697.00   2,627.00




 Printed 8/22/2012, 3:53 AM                                                                                                              Page 6 of 10
                                                     FILE = e79fa221-ee37-4b28-b5cc-b7f0a1a70a3b.xls
  Monday    Thursday      Friday    Saturday     Sunday     Monday    Thursday      Friday    Saturday     Sunday     Monday    Thursday      Friday    Saturday
  24-Oct     27-Oct      28-Oct      29-Oct      30-Oct     31-Oct      3-Nov       4-Nov       5-Nov       6-Nov      7-Nov     10-Nov      11-Nov      12-Nov
      40         41          42          43          44         45         46          47          48          49         50         51          52          53
      4           4          4            4          4          4           4          4            4          4          4           4          4            4
     10          10         10           10         10         10          10         10           10         10         10          10         10           10
     40          40         40           40         40         40          40         40           40         40         40          40         40           40
      8           8          8            8          8          8           8          8            8          8          8           8          8            8
      6           6          6            6          6          6           6          6            6          6          6           6          6            6
      2           2          2            2          2          2           2          2            2          2          2           2          2            2
      4           2          4            2          4          2           4          2            4          2          4           2          4            2
      3           0          3            0          3          0           3          0            3          0          3           0          3            0
      1           0          1            0          1          0           1          0            1          0          1           0          1            0
     -4           0         -4            0         -4          0          -4          0           -4          0         -4           0         -4            0
      3           3          3            3          3          3           3          3            3          3          3           3          3            3
      6           6          6            6          6          6           6          6            6          6          6           6          6            6
     46          46         46           46         46         46          46         46           46         46         46          46         46           46

     500                    500                     600                   600                     500                    500                    200



6,250.00       0.00    6,250.00        0.00    7,500.00      0.00    7,500.00        0.00    6,250.00       0.00    6,250.00       0.00    2,500.00        0.00
3,500.00       0.00    3,500.00        0.00    4,200.00      0.00    4,200.00        0.00    3,500.00       0.00    3,500.00       0.00    1,400.00        0.00
2,750.00       0.00    2,750.00        0.00    3,300.00      0.00    3,300.00        0.00    2,750.00       0.00    2,750.00       0.00    1,100.00        0.00


   70.00     70.00        70.00      70.00        70.00     70.00       70.00      70.00        70.00      70.00       70.00     70.00        70.00      70.00
   14.70     14.70        14.70      14.70        14.70     14.70       14.70      14.70        14.70      14.70       14.70     14.70        14.70      14.70
   19.51     19.51        19.51      19.51        19.51     19.51       19.51      19.51        19.51      19.51       19.51     19.51        19.51      19.51
    3.76      3.76         3.76       3.76         3.76      3.76        3.76       3.76         3.76       3.76        3.76      3.76         3.76       3.76
   24.39     24.39        24.39      24.39        24.39     24.39       24.39      24.39        24.39      24.39       24.39     24.39        24.39      24.39
  550.00      0.00       550.00       0.00       660.00      0.00      660.00       0.00       550.00       0.00      550.00      0.00       220.00       0.00
 -200.00      0.00      -140.00       0.00      -140.00      0.00     -140.00       0.00      -140.00       0.00     -140.00      0.00      -140.00       0.00
  482.36    132.36       542.36     132.36       652.36    132.36      652.36     132.36       542.36     132.36      542.36    132.36       212.36     132.36


    0.00     70.00         0.00      70.00         0.00     70.00        0.00      70.00         0.00      70.00        0.00     70.00         0.00      70.00

  420.00      70.00      480.00       70.00      590.00      70.00     590.00       70.00      480.00       70.00     480.00      70.00      150.00       70.00
5,907.00   5,977.00    6,457.00    6,527.00    7,117.00   7,187.00   7,777.00    7,847.00    8,327.00    8,397.00   8,877.00   8,947.00    9,097.00    9,167.00
     160        164         168         172         176        180        184         188         192         196        200        204         208         212
   36.92      36.45       38.43       37.95       40.44      39.93      42.27       41.74       43.37       42.84      44.39      43.86       43.74       43.24


 Printed 8/22/2012, 3:53 AM                                                                                                                      Page 7 of 10
                                                  FILE = e79fa221-ee37-4b28-b5cc-b7f0a1a70a3b.xls



      20         20         21         21         22         22         23         23         24         24         25         25         26         26
       0          0          0          0          0          0          0          0          0          0          0          0          0          0
2,800.00   2,870.00   2,940.00   3,010.00   3,080.00   3,150.00   3,220.00   3,290.00   3,360.00   3,430.00   3,500.00   3,570.00   3,640.00   3,710.00
5,907.00   5,907.00   6,457.00   6,457.00   7,117.00   7,117.00   7,777.00   7,777.00   8,327.00   8,327.00   8,877.00   8,877.00   9,097.00   9,097.00
3,107.00   3,037.00   3,517.00   3,447.00   4,037.00   3,967.00   4,557.00   4,487.00   4,967.00   4,897.00   5,377.00   5,307.00   5,457.00   5,387.00




 Printed 8/22/2012, 3:53 AM                                                                                                              Page 8 of 10
                                                     FILE = e79fa221-ee37-4b28-b5cc-b7f0a1a70a3b.xls
  Sunday     Monday    Thursday      Friday    Saturday     Sunday     Monday   Thursday      Friday   Saturday     Sunday
  13-Nov     14-Nov     17-Nov      18-Nov      19-Nov     20-Nov      21-Nov    24-Nov      25-Nov    26-Nov       27-Nov
      54         55         56          57          58         59          60        61          62        63           64
      4          4           4          4            4          4          4          4          4           4          4
     10         10          10         10           10         10         10         10         10          10         10
     40         40          40         40           40         40         40         40         40          40         40
      8          8           8          8            8          8          8          8          8           8          8
      6          6           6          6            6          6          6          6          6           6          6
      2          2           2          2            2          2          2          2          2           2          2
      4          2           4          2            4          2          4          2          4           2          4
      3          0           3          0            3          0          3          0          3           0          3
      1          0           1          0            1          0          1          0          1           0          1
     -4          0          -4          0           -4          0         -4          0         -4           0         -4
      3          3           3          3            3          3          3          3          3           3          3
      6          6           6          6            6          6          6          6          6           6          6
     46         46          46         46           46         46         46         46         46          46         46

     200                   200                     300                    300                   300                    300



2,500.00      0.00    2,500.00       0.00     3,750.00       0.00    3,750.00      0.00    3,750.00       0.00    3,750.00
1,400.00      0.00    1,400.00       0.00     2,100.00       0.00    2,100.00      0.00    2,100.00       0.00    2,100.00
1,100.00      0.00    1,100.00       0.00     1,650.00       0.00    1,650.00      0.00    1,650.00       0.00    1,650.00


   70.00     70.00       70.00      70.00        70.00      70.00       70.00    70.00        70.00     70.00        70.00
   14.70     14.70       14.70      14.70        14.70      14.70       14.70    14.70        14.70     14.70        14.70
   19.51     19.51       19.51      19.51        19.51      19.51       19.51    19.51        19.51     19.51        19.51
    3.76      3.76        3.76       3.76         3.76       3.76        3.76     3.76         3.76      3.76         3.76
   24.39     24.39       24.39      24.39        24.39      24.39       24.39    24.39        24.39     24.39        24.39
  220.00      0.00      220.00       0.00       330.00       0.00      330.00     0.00       330.00      0.00       330.00
 -140.00      0.00     -140.00       0.00      -140.00       0.00     -140.00     0.00      -140.00      0.00      -140.00
  212.36    132.36      212.36     132.36       322.36     132.36      322.36   132.36       322.36    132.36       322.36


    0.00     70.00        0.00      70.00         0.00      70.00        0.00    70.00         0.00     70.00         0.00

  150.00      70.00     150.00       70.00      260.00       70.00    260.00     70.00    260.00     70.00    260.00
9,317.00   9,387.00   9,537.00    9,607.00    9,867.00    9,937.00 10,197.00 10,267.00 10,527.00 10,597.00 10,857.00
     216        220        224         228         232         236       240       244       248       252       256
   43.13      42.67      42.58       42.14       42.53       42.11     42.49     42.08     42.45     42.05     42.41


 Printed 8/22/2012, 3:53 AM                                                                                                  Page 9 of 10
                                                  FILE = e79fa221-ee37-4b28-b5cc-b7f0a1a70a3b.xls



      27         27         28         28         29         29        30        30        31        31        32
       0          0          0          0          0          0         0         0         0         0         0
3,780.00   3,850.00   3,920.00   3,990.00   4,060.00   4,130.00 4,200.00 4,270.00 4,340.00 4,410.00 4,480.00
9,317.00   9,317.00   9,537.00   9,537.00   9,867.00   9,867.00 10,197.00 10,197.00 10,527.00 10,527.00 10,857.00
5,537.00   5,467.00   5,617.00   5,547.00   5,807.00   5,737.00 5,997.00 5,927.00 6,187.00 6,117.00 6,377.00




 Printed 8/22/2012, 3:53 AM                                                                                         Page 10 of 10

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:1
posted:8/22/2012
language:
pages:10
Description: docs