Docstoc

Affinity

Document Sample
Affinity Powered By Docstoc
					     Top 20                                    $ 8,346,531
     product     PRODUCT_NAME                ann. sales         units avgprice custmrs
 1   19768SABMUSOMUSLIN SOFA AND SLIP        $      642,968       359     1790       378
 2   30000021    ARABESQUE 46 X 80 COPPER TOP$      581,339       357     1628       454
 3   40RIALARM   RIALTO ARMOIRE              $      509,307       255     1997       309
 4   30REFWAL    WALNUT REFECTORY TABLE      $      500,675       300     1668       347
 5   30DELSIDE2  DELANO SIDE CHAIR           $      478,886       980      488       238
 6   30MORBS     MORAVIAN DINING BASE        $      474,110       955      496      1117
 7   55BENEXDESK BENTLEY EXECUTIVE DESK      $      458,840       388     1182       433
 8   30TUSTRSKT TUSCANY TRESTLE TABLE        $      447,784       183     2446       197
 9   30COLSIDEL  COLETTE LEATHER SIDE CHAIR $       423,102       790      535       227
10   30CAPBLACK BLACK CAPRI CHAIR            $      413,561     1,821      227       443
11   753RAL-A    SLIPPED R-ARM LOVE GRD A    $      392,867       303     1296       191
12   A2231LAF-F  FITTED L-ARM LOVESEAT GRD F $      376,916       147     2564       163
13   B2231RAF-F  FITTED R-ARM LOVESEAT GRD F $      365,676       147     2487       162
14   30000057    CANYON LAKE BLACK SIDE CHAIR$      351,318     1,322      265       346
15   30VERSTBL   VERSAILLES REFECTORY TABLE $       347,783       184     1890       211
16   30CAPBROWN BROWN CAPRI CHAIR            $      344,175     1,525      225       388
17   19971SABSO  FITTED SOFA                 $      316,430       184     1719       199
18   30SMARABBS SMALL ARABESQUE BASE         $      316,333       509      621       638
19   55BENBS     BENTLEY EXECUTIVE DESK BASE$       304,147       393      773       436
20   30000077    ARABESQUE 48" COPPER TOP    $      300,314       255     1177       311

        30000021 ARABESQUE 46 X 80 COPPER TOP
2 product         PRODUCT_NAME                ann. sales        units avgprice custmrs
 1   30000021     ARABESQUE 46 X 80 COPPER TOP$      581,339      357     1628       454
 2   30SMARABBS SMALL ARABESQUE BASE          $      218,450      352      620       419
 3   30000057     CANYON LAKE BLACK SIDE CHAIR$      106,282      396      268        92
 4   30000083     ARABESQUE 52 X 90 COPPER TOP$       33,994       15     2266        24
 5   30VIRGSIDE2 VIRGINIA SIDE CHAIR          $       28,885       81      356        16
 6                COBRIZO SIDEBOARD
     COBRIZOSIDEBOARD                         $       26,963       21     1283        31
 7   30CAFEST     CAFE 30" BARSTOOL           $       25,634       66      388        27
 8   30000058     CANYON LAKE BLACK ARM CHAIR $       25,347       77      329        47
 9   30COLSIDEL   COLETTE LEATHER SIDE CHAIR $        25,219       51      494        17
10   30CAPBLACK BLACK CAPRI CHAIR             $       22,798      105      217        25
11   COBRIZOLARGE COBRIZO 3 DRAWER SIDEBOARD$         19,119       12     1593        12
12   30DELSIDE2   DELANO SIDE CHAIR           $       18,705       34      550         8
13   40RIALARM    RIALTO ARMOIRE              $       16,371        8     2046        10
14   30BLACKBUF ZOE BLACK BUFFET              $       14,045       15      936        18
15   F003BLKS     ZONA BLACK SIDE CHAIR       $       13,774       53      259        14
16   30000077     ARABESQUE 48" COPPER TOP    $       12,323       12     1026        15
17   19768SABMUSOMUSLIN SOFA AND SLIP         $       11,202        7     1600         6
18   30COLSIDELSO LEATHER SIDE CHAIR          $       11,171       22      507         6
19   45ZARAK      ZARA KING BED               $       10,615        7     1516         7
20   LUCA-BLACK LUCA BLACK BUCKET CHAIR       $       10,510       32      328         8

     30REFWAL     WALNUT REFECTORY TABLE
4 product         PRODUCT_NAME                 ann. sales       units avgprice custmrs
 1 30REFWAL       WALNUT REFECTORY TABLE       $      500,675     300     1668       347
 2 30ZONAWALS     ZONA WALNUT SIDE CHAIR       $      239,011     934      255       192
 3   30WALNCAB   WALNUT DINING CABINET      $         120,553     49      2460       54
 4   30ZONAWALA ZONA WALNUT ARM CHAIR       $          62,217    172       361       99
 5   30WALNBUF   WALNUT BUFFET              $          18,368     11      1669       13
 6   30DELSIDE2  DELANO SIDE CHAIR          $          16,085     32       502        8
 7   30MONTSIDE MONTEREY SIDEBOARD          $          12,219      4      3054        6
 8   30CAPBROWN BROWN CAPRI CHAIR           $          11,581     54       214        9
 9   30VERSBUF   VERSAILLES BUFFET          $           8,562      3      2854        3
10   F003BLKS    ZONA BLACK SIDE CHAIR      $           7,796     34       229        8
11   32008SO-QS  CORTLAND CHAIR--QUICK SHIP $           7,795      5      1559        3
12   40CRAWBK    CRAWFORD BOOKCASE          $           7,192      8       899        7
13   30DELARM2   DELANO ARM CHAIR           $           7,128     12       594        6
14   30ZONACHYS ZONA ANTIQUE CHY SIDE CHAIR $           6,782     18       376        6
15   30TUSCBUF   TUSCANY GRAND BUFFET       $           6,763      3      2254        4
16   30COLARMFSO ARM CHAIR                  $           6,608     12       550        8
17   30DORIACHSO S.O. DORIA SIDE CHAIR      $           6,436     14       459        3
18   FABCOATDC   FABCOAT FOR DINING CHAIR   $           6,178    662         9      114
19   30COLSIDEL  COLETTE LEATHER SIDE CHAIR $           5,708     10       570        8
20   31600SO-4   LEATHER RECLINER GRD 4     $           5,539      3      1846        3

     30MORBS       MORAVIAN DINING BASE
6 product         PRODUCT_NAME                 ann. sales       units avgprice custmrs
 1   30MORBS      MORAVIAN DINING BASE         $      474,110     955      496      1117
 2   30000077     ARABESQUE 48" COPPER TOP     $      247,388     207     1195       240
 3   30SNAKE60    SNAKESKIN 60" ROUND TOP      $      219,832     187     1175       222
 4   30000079     ARABESQUE 60" COPPER TOP     $      213,301     119     1792       149
 5   30SNAKE54    SNAKESKIN 54" ROUND TOP      $      121,140     125      969       152
 6   30COLSIDEL   COLETTE LEATHER SIDE CHAIR $        101,189     182      555        47
 7   3060RDMOS    ITALIAN MOSAIC 60" ROUND TOP $       94,970      84     1130       106
 8   30CAPBLACK BLACK CAPRI CHAIR              $       93,971     417      225        97
 9   30000057     CANYON LAKE BLACK SIDE CHAIR $       90,042     337      267        80
10   30CAPBROWN BROWN CAPRI CHAIR              $       81,690     362      225        81
11   3054RDMOS    ITALIAN MOSAIC 54" ROUND TOP$        70,518      71      993        92
12   300239DO-DC DOUGLAS CAMEL SIDE CHAIR      $       66,224     145      456        39
13   LUCA-BLACK LUCA BLACK BUCKET CHAIR        $       56,800     161      352        46
14   300239DOSO   SIDE CHAIR                   $       56,296     118      477        30
15   B2231RAF-F   FITTED R-ARM LOVESEAT GRD F $        52,785      18     2932        17
16   A2231LAF-F   FITTED L-ARM LOVESEAT GRD F $        46,785      18     2599        17
17   LUCA-BROWN LUCA BROWN BUCKET CHAIR        $       41,706     113      369        33
18   30VIRGSIDE2 VIRGINIA SIDE CHAIR           $       37,986     108      351        25
19   FIRENZEDININGFIRENZE 48" JADE DINING TOP $        32,514      35      928        37
20   30CAPSIDEBL CAPRI BLACK SIDE CHAIR        $       30,500     132      231        39

     30TUSTRSKTTUSCANY TRESTLE TABLE
8 product          PRODUCT_NAME               ann. sales        units avgprice custmrs
 1   30TUSTRSKT    TUSCANY TRESTLE TABLE      $      447,784      183     2446       197
 2   30TUSTRSBS    REVISED TUSCANY TABLE BASE $      235,848      183     1288       197
 3   30TUSTRSTP    REVISED TUSCANY TRESTLE TOP$      211,784      183     1157       197
 4   30TUSCBUF     TUSCANY GRAND BUFFET       $      110,867       49     2262        53
 5   30TUSCSIDE2   TUSCANY SIDE CHAIR         $      102,079      203      502        36
 6   30DELSIDE2    DELANO SIDE CHAIR          $       94,784      202      469        42
 7   30TUSCHUT    TUSCANY HUTCH TOP           $       65,274     31      2105       35
 8   30063100     TUSCANY SIDE CHAIR          $       48,905    124       394       30
 9   30DELARM2    DELANO ARM CHAIR            $       32,448     53       612       30
10   30MONTSIDE MONTEREY SIDEBOARD            $       31,905     10      3190       12
11   30TUSCARM    TUSCANY ARM CHAIR           $       29,906     66       453       34
12   30TUSCARM2 TUSCANY ARM CHAIR             $       23,682     42       563       25
13   30COLSIDEL   COLETTE LEATHER SIDE CHAIR $        17,404     30       580        6
14   30PARKSIDESO PARK AVENUE SIDE CHAIR      $       12,466     46       271        8
15   3553-CS      HARMAN SIDE CHAIR           $        7,875     17       463        8
16   A2231LAF-F   FITTED L-ARM LOVESEAT GRD F $        7,472      3      2490        3
17   B2231RAF-F   FITTED R-ARM LOVESEAT GRD F $        7,472      2      3736        3
18   30CAPBROWN BROWN CAPRI CHAIR             $        7,170     30       239        5
19   300239DOSO   SIDE CHAIR                  $        6,978     12       581        2
20   743LO-3                                  $
                  LEATHER ARMLESS LOVESEAT GRD 3       6,277      3      2092        3

     30CAPBLACKBLACK CAPRI CHAIR
10 product       PRODUCT_NAME                 ann. sales       units avgprice custmrs
 1   30CAPBLACK BLACK CAPRI CHAIR             $      413,561   1,821      227       443
 2   30MORBS     MORAVIAN DINING BASE         $       41,842      85      492        97
 3   30000021    ARABESQUE 46 X 80 COPPER TOP $       35,876      22     1630        24
 4   30000077    ARABESQUE 48" COPPER TOP     $       32,851      27     1216        32
 5   30SNAKE60   SNAKESKIN 60" ROUND TOP      $       26,708      23     1161        26
 6   4072MOS     ITALIAN MOSAIC 40X72 TOP     $       24,884      24     1036        31
 7   30ATLAS     ATLAS DINING TABLE           $       23,695      23     1030        27
 8   30MOSBS     ITALIAN RECTANGLE IRON BASE $        23,360      37      631        42
 9   30SNAKE54   SNAKESKIN 54" ROUND TOP      $       22,092      21     1052        22
10   30CORWALSP CORTONA TABLE WITH SPLAYED $  LEG     20,929      27      775        28
11   30CAPBROWN BROWN CAPRI CHAIR             $       19,050      87      218        24
12   30SMARABBS SMALL ARABESQUE BASE          $       18,455      29      636        32
13   30SNAKEREC SNAKESKIN RECTANGLE TOP       $       18,369      18     1020        21
14   LUCA-BLACK LUCA BLACK BUCKET CHAIR       $       16,071      44      365        21
15   COBRIZOLARGECOBRIZO 3 DRAWER SIDEBOARD$          14,485       9     1609         8
16   30SNAKE48   SNAKESKIN 48" ROUND TOP      $       14,469      17      851        22
17   30BLKBAR30 BLACK 30" CAPRI BARSTOOL      $       14,265      49      291        24
18   30ITALBS    ITALIAN ROUND DINING BASE    $       13,709      29      472        37
19   30BLKBAR24 BLACK 24" CAPRI BARSTOOL      $       13,443      48      280        23
20   3060RDMOS   ITALIAN MOSAIC 60" ROUND TOP $       12,629      11     1148        14
                MUSLIN SOFA AND SLIP
     19768SABMUSO
1 product           PRODUCT_NAME           ann. sales      units avgprice custmrs
 1   19768SABMUSO   MUSLIN SOFA AND SLIP   $     642,968    359      1790       378
 2   39768CABMUSO                          $
                    MUSLIN CHAIR W/SLIPCOVER     141,092    124      1137       132
 3   49768OSBMUSO                          $
                    MUSLIN OTTOMAN W/SLIPCOVER 43,844         91      481       101
 4   29768LABMUSO                          $
                    MUSLIN LOVESEAT W/SLIPCOVER35,521         20     1776        26
 5   79768PABMUSO                          $
                    MUSLIN APT SOFA W/SLIPCOVER 18,387        10     1838        10
 6   39947CABMUSO   SLIPCOVERED CHAIR      $      17,318      18      962        19
 7   FABCOATS       FABCOAT FOR SOFA       $      13,395    241         55      216
 8   3861SO-A       GLIDER/ROCKER GRD A $          9,507       9     1056         7
 9   19768SACSLIP   SOFA SLIPCOVER         $       9,009      15      600        19
10   30000021                              $
                    ARABESQUE 46 X 80 COPPER TOP 8,468         6     1411         6
11   40RIALARM      RIALTO ARMOIRE         $       7,791       4     1947         5
12   30063100       TUSCANY SIDE CHAIR     $       7,594      16      474         3
13   19769SABSO     FITTED SOFA            $       6,888       4     1722         7
14   3802SO-3                              $
                    LEATHER CHAIR W/ NAIL GRD 3    6,836       4     1709         1
15   31600RCL-QS                           $
                    AVELINE RECLINER--QUICK SHIP 6,562         3     2187         3
16   SPECIAL        SPECIAL ORDER          $       6,402       9      711        25
17   30000065       TUSCANY GRAND BUFFET $         6,034       3     2011         3
18   35COBCOF       COBRIZO COFFEE TABLE $         5,960       5     1192         5
19   30000057       CANYON LAKE BLACK SIDE$ CHAIR 5,925       25      237         7
20   697962OBMUSO                          $
                    SLIPCOVERED STORAGE OTTOMAN1/2 5,812       9      645        12

     40RIALARM      RIALTO ARMOIRE
3 product         PRODUCT_NAME           ann. sales        units avgprice custmrs
 1   40RIALARM    RIALTO ARMOIRE         $     509,307      255      1997       309
 2   40RIALTOP    RIALTO ARMOIRE TOP     $     256,841      256      1003       309
 3   40RIALBOT    RIALTO ARMOIRE BOTTOM$       254,215      256       993       309
 4   B2231RAF-F                          $
                  FITTED R-ARM LOVESEAT GRD F 28,620          11     2601        11
 5   A2231LAF-F                          $
                  FITTED L-ARM LOVESEAT GRD F 28,619          11     2601        11
 6   30000021                            $
                  ARABESQUE 46 X 80 COPPER TOP  14,643         9     1627        11
 7   30COLSIDEL                          $
                  COLETTE LEATHER SIDE CHAIR 10,931           20      546         5
 8                                       $
     3802MERLOT-QSMERLOT CHAIR--QUICK SHIP      10,829         7     1547         6
 9   30063100     TUSCANY SIDE CHAIR     $       9,269        18      514         3
10   753RAL-A     SLIPPED R-ARM LOVE GRD$ A      7,800         6     1300         5
11   55JACQUES    JACQUES LIBRARY DESK $         7,738         2     3869         2
12   55JACQTP                            $
                  JACQUES LIBRARY DESK TOP       7,736         2     3868         2
13                BRIARWOOD CHOCOLATE SOFA 7,699
     1859BRIARWOOD-CH                    $                     5     1539         5
14   30COLARML                           $
                  COLETTE LEATHER ARM CHAIR      7,590        10      759         5
15   52113SO-F    FITTED CHAIR-1/2 GRD F $       7,544         3     2514         2
16   55SIENBASE   SIENNA LIBRARY BASE    $       7,388         4     1847         4
17   30TUSTRES    TUSCANY TRESTLE DINING$TABLE 6,997           3     2332         4
18   30TUSTOP     TUSCANY TRESTLE TOP $          6,994         3     2331         4
19   19768SABMUSO MUSLIN SOFA AND SLIP   $       6,985         5     1397         6
20   12113SO-QS                          $
                  CHATEAU SOFA--QUICK SHIP       6,775         2     3387         2

     30DELSIDE2 DELANO SIDE CHAIR
5 product           PRODUCT_NAME         ann. sales        units avgprice custmrs
1 30DELSIDE2        DELANO SIDE CHAIR    $     478,886      980       488       238
2 30VERSTBL                              $
                    VERSAILLES REFECTORY TABLE 156,015        79     1974        86
 3   30DELARM2     DELANO ARM CHAIR       $   142,075      234       607      132
 4   30TUSTRSKT    TUSCANY TRESTLE TABLE $     95,295       39      2443       42
 5   30VERSBUF     VERSAILLES BUFFET      $    77,908       29      2686       35
 6   30TUSTRSBS                           $
                   REVISED TUSCANY TABLE BASE 51,335        39      1316       42
 7   30TUSTRSTP                           $
                   REVISED TUSCANY TRESTLE TOP43,928        39      1126       42
 8   30TUSCBUF     TUSCANY GRAND BUFFET $      38,767       16      2422       17
 9   30MONTSIDE    MONTEREY SIDEBOARD $        31,519       10      3151       10
10   30TUSTRES     TUSCANY TRESTLE DINING$TABLE30,830       14      2202       19
11   30TUSTOP      TUSCANY TRESTLE TOP $       30,819       14      2201       19
12   30TUSCHUT     TUSCANY HUTCH TOP      $    24,624       11      2238       11
13   30TUSCSIDE2   TUSCANY SIDE CHAIR     $    15,496       30       516        5
14   30REFWAL      WALNUT REFECTORY TABLE $    13,257        8      1657        8
15   30000021                             $
                   ARABESQUE 46 X 80 COPPER TOP10,086        6      1681        8
16   300239DOSO    SIDE CHAIR             $     9,847       18       547        3
17   A2231LAF-F                           $
                   FITTED L-ARM LOVESEAT GRD F 9,741         4      2435        4
18   B2231RAF-F                           $
                   FITTED R-ARM LOVESEAT GRD F 9,741         4      2435        4
19   30PARKTBL     PARK AVENUE TABLE      $     8,841        4      2210        6
20   30TUSRNDLG                           $     8,414
                   TUSCANY 60" ROUND DINING TABLE            5      1682        5

               BENTLEY EXECUTIVE DESK
     55BENEXDESK
7 product      PRODUCT_NAME           ann. sales          units avgprice custmrs
 1 55BENEXDESK BENTLEY EXECUTIVE DESK $     458,840        388      1182       433
 2 55BENBS                            $
               BENTLEY EXECUTIVE DESK BASE  302,868        388       780       433
 3 55BENTP                            $
               BENTLEY EXECUTIVE DESK TOP 156,252          389       401       433
 4 55BEN4FILE                         $
               BENTLEY 4 DRAWER FILE CABINET102,792        143       718       150
 5 55BENTALLW                         $
               BENTLEY TALL WIDE BOOKCASE 84,865             83     1022       104
 6 55BENCRED                          $
               BENTLEY 2 DRAWER CREDENZA 75,334            129       583       141
 7 55BENLOWBK BENTLEY LOW BOOKCASE $         69,901        100       699       104
 8 55BENTALLN                         $
               BENTLEY TALL NARROW BOOKCASE  68,641        101       679        72
 9 30VERSTBL                          $
               VERSAILLES REFECTORY TABLE 21,882             11     1989         9
10 55BEN2D                            CASTORS
               BENTLEY 2 DRWR FILE ON $      15,659          47      333        46
11 45BENT6D                           $
               BENTLEY 6 DRAWER DRESSER 13,353               13     1027        16
12 40BENTVBK   BENTLEY BROWN BOOKCASE $      12,804          25      512        17
13 55SULLBR                           $
               SULLIVAN BROWN DESK CHAIR 11,927               9     1325        12
14 35BENTVCOF  BENTLEY BROWN COFFEE $ TABLE11,146            19      586        19
15 45BENTNT    BENTLEY NIGHTSTAND     $      11,092          37      299        29
16 55BEN48     BENTLEY 48" DESK       $      10,251          17      603        21
17 30MONTSIDE  MONTEREY SIDEBOARD $           9,267           3     3089         3
18 30DELSIDE2  DELANO SIDE CHAIR      $       8,354          16      522         2
19 30FRCHYCAB  FRENCH CHERRY CABINET  $       8,187           3     2729         3
20 45BENTWARD BENTLEY WARDROBE        $       7,916           8      989        11

     30COLSIDEL COLETTE LEATHER SIDE CHAIR
9 product          PRODUCT_NAME           ann. sales      units avgprice custmrs
1    30COLSIDEL                           $
                   COLETTE LEATHER SIDE CHAIR 423,102      790       535       227
2    30COLARML                            $
                   COLETTE LEATHER ARM CHAIR 59,133          84      703        57
3    4072MOS                              $
                   ITALIAN MOSAIC 40X72 TOP      27,456      28      980        34
4    30MORBS       MORAVIAN DINING BASE $        21,114      48      439        46
5    30MOSBS                              BASE 19,577
                   ITALIAN RECTANGLE IRON $                  31      631        39
6    30000021                             $
                   ARABESQUE 46 X 80 COPPER TOP  17,909      14     1279        17
 7   A2231LAF-F                            $
                    FITTED L-ARM LOVESEAT GRD F 17,771         7      2538        6
 8   B2231RAF-F                            $
                    FITTED R-ARM LOVESEAT GRD F 17,769         7      2538        6
 9   30TUSTRSKT     TUSCANY TRESTLE TABLE $     14,949         6      2491        6
10   30PARKTBL      PARK AVENUE TABLE      $    14,434         6      2405        6
11   30COLSIDELSO   LEATHER SIDE CHAIR     $    12,280        21       584        7
12   30SNAKE60      SNAKESKIN 60" ROUND TOP$    11,965        10      1196       11
13   30VERSTBL                             $
                    VERSAILLES REFECTORY TABLE 11,694          6      1949        7
14   30REFWAL       WALNUT REFECTORY TABLE $    10,194         6      1699        8
15   SPECIAL        SPECIAL ORDER          $    10,095         8      1261        8
16   30000083                              $
                    ARABESQUE 52 X 90 COPPER TOP10,061         5      2012        8
17   30SNAKE54      SNAKESKIN 54" ROUND TOP$     9,347        12       778       12
18   30000079                              $
                    ARABESQUE 60" COPPER TOP     9,023         5      1804        6
19   55SIENDESK     SIENNA LEATHER TOP DESK$     8,897         3      2965        3
20   3060RDMOS                             $
                    ITALIAN MOSAIC 60" ROUND TOP 8,623         9       958        9

     753RAL-A       SLIPPED R-ARM LOVE GRD A
11 product          PRODUCT_NAME            ann. sales      units avgprice custmrs
 1   753RAL-A       SLIPPED R-ARM LOVE GRD$  A    392,867    303      1296       191
 2   753LAC-A                               $
                    SLIPPED L-ARM CHAIR GRD A     178,066    140      1271       161
 3   42157SO-QS     GRETA OTTO--QUICK SHIP $       19,135      34      562        42
 4   753LAL-A       SLIPPED L-ARM LOVE GRD $A      17,815      13     1370        13
 5   42157SO-A                              $
                    SLIPPED RD OTTO W/KPS GRD A 16,350         30      545        39
 6   FABCOATSEC     FABCOAT FOR SECTIONAL $        15,001    106       141       120
 7   753EE-A        SLIPPED CORNER W/ SKIRT $      14,524      13     1117        14
 8   753CO-A                                $
                    SLIPPED ARMLESS CHAIR W/ SKIRT 13,213      12     1101        16
 9   753LC-A                                SKIRT 12,365
                    SLIPPED L-ARM CHAISE W/ $                  10     1236        13
10   753RAC-A                               $
                    SLIPPED R-ARM CHAIR GRD A       8,640       8     1080        12
11   40RIALARM      RIALTO ARMOIRE          $       7,811       4     1952         5
12   30VERSTBL                              $
                    VERSAILLES REFECTORY TABLE 7,706            4     1926         2
13   1753SO-A                               $
                    SLIPPED SOFA W/ SKT GRD A       7,043       4     1760         6
14   30TUSTRES      TUSCANY TRESTLE DINING$TABLE 6,697          3     2232         3
15   30TUSTOP       TUSCANY TRESTLE TOP $           6,694       3     2231         3
16   30DORIACHSO    S.O. DORIA SIDE CHAIR   $       6,682      14      477         2
17   753RAL-B       SLIPPED R-ARM LOVE GRD$  B      5,151       4     1287         2
18   30063100       TUSCANY SIDE CHAIR      $       4,971      10      497         2
19   30FRCHYCAB     FRENCH CHERRY CABINET   $       4,635       2     2317         2
20   753LO-A                                $
                    SLIPPED ARMLESS LOVE W/ SKIRT 4,390         4     1097         6
    "Affinity" is short for "also bought", i.e, "people who bought X also bought Y, Z, W, etc."

    The Affinity sheet lets you examine these patterns by entering products under the PRODUCT column of the GREEN box
                   ||         Yellow boxes show the products also bought when items in the green box were purchased, ther
                   ||                                   Every box has 20 lines (Top 20 - get it?) and there are 11 yellow bo
                   ||                                   one for each of the first 11 lines of the green box. These are the lin
                   ||                                   enter product id-s: green line 1 produces yellow box 1, line 2, box 2
                   V
           Top 20                                         $ 1,805,644
           product      PRODUCT_NAME              ann. sales       units   avgprice custmrs
         1 19768SABMUSO MUSLIN SOFA AND SLIP $            642,968      359     1790      378
         2 30000021                               $
                        ARABESQUE 46 X 80 COPPER TOP      581,338      355     1637      454
||========>>            <<====|| enter product id-s in this column
…………
…………
                30000021 ARABESQUE 46 X 80 COPPER TOP
        2 product            PRODUCT_NAME         ann. sales                units   avgprice custmrs
        1 30000021                                $
                             ARABESQUE 46 X 80 COPPER TOP581,338                355     1637      454

    You click the REFRESH TOP 20 button to fill the green box from the last 12 months top sellers or enterproduct id-s yours
    Clicking the REFRESH of a yellow box 2 will get the affinity data for the product named in line 2 in the GREEN box.
    It's simpler than it sounds, give it a try (in the Affinity sheet - the buttons here don't wotk)


    Field names:             ann. sales                                               the net sales dollars for the item for the r
                                                                                      the total sales dollars to customers buyin

                             units                                                    the number of units of the item that were

                             avgprice                                                 the calculated average price - total sales

                             customers                                                the number of customers buying the item
                                                                                      this number is highest for the affinity roo
UCT column of the GREEN box.
 reen box were purchased, there is one yellow box for each green box line item
  ?) and there are 11 yellow boxes,                    ||
 e green box. These are the lines you                  ||
 ces yellow box 1, line 2, box 2, etc.                 V

                                      MUSLIN SOFA AND SLIP
                            19768SABMUSO
                          1 product    PRODUCT_NAME         ann. sales                      units    avgprice custmrs
                                       MUSLIN SOFA AND SLIP $
                          1 19768SABMUSO                        642,968                          359     1790      378
                                       MUSLIN CHAIR W/SLIPCOVER41,092
                          2 39768CABMUSO                    $   1                                124     1137      132



                     The YELLOW boxes show the items ALSO BOUGHT
                     by purchasers of the item displayed ON TOP of the yellow box



ellers or enterproduct id-s yourself and click the REFRESH MANUAL button
 line 2 in the GREEN box.



 les dollars for the item for the rolling 12 months
 ales dollars to customers buying the "Top 20" item

er of units of the item that were sold

ated average price - total sales dollars divide by total units sold

er of customers buying the item
er is highest for the affinity root item and is usually, but not always, in the first (No. 1) line displayed

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:61
posted:3/4/2010
language:English
pages:8