Dashboard Reporting 3

Document Sample
Dashboard Reporting 3 Powered By Docstoc
					Excellence In Excel By AASIM
SALES REPORT
S.No    PRODUCT      Jan       Feb       Mar       Apr      May        Jun       Jul       Aug       Sep
 1     LAPTOP        34,848    19,216    43,925    15,016    16,518    20,477    27,849    41,628    13,390
 2     DESKTOP       31,044    39,628    32,968    31,795    10,509    24,937    40,804    22,922    43,675
 3     SPEAKER       27,929    12,262    17,099    39,887    41,133    13,007    44,305    25,971    20,167
 4     MOUSE         15,097    23,008    13,813    41,919    45,568    27,015    20,017    13,304    16,437
 5     PRINTER       32,707    36,721    28,128    16,373    42,010    10,764    36,776    39,430    47,375
 6     DVD           44,098    30,965    15,568    36,200    42,904    34,232    18,135    28,350    11,330
 7     PROJECTOR     11,202    16,926    38,241    44,134    46,006    23,059    29,267    15,564    25,104
 8     SCANNER       32,951    48,249    41,983    49,710    22,509    28,808    39,800    48,456    29,705
 9     LCDS          23,504    29,547    20,265    20,431    16,377    46,596    43,423    41,226    41,863
 10    MONITORS      32,171    14,699    41,841    30,983    42,890    22,355    44,055    14,789    15,057
 11    CASSING       38,135    24,303    44,293    34,756    10,034    47,781    27,908    26,548    28,321
 12    KEYBOARDS     31,086    29,168    46,181    12,583    48,629    48,358    47,185    48,758    27,159
 13    MOUSE         20,030    41,333    45,475    25,542    43,599    41,080    23,172    48,028    13,937
 14    CABLES        17,170    31,897    23,867    39,363    35,638    26,258    46,608    21,852    34,496
 15    SWITCH        31,347    30,176    14,767    44,870    32,396    43,061    31,915    44,361    44,567
 16    STABILIZER    47,630    41,958    16,781    49,000    47,241    22,246    37,077    49,268    42,009
 17    PROCESSOR     12,849    40,183    44,736    46,599    36,012    47,767    42,692    21,852    36,825
 18    MODEM         10,939    42,314    44,294    36,981    16,530    26,122    37,882    32,018    17,327
 19    RAM           42,570    31,659    13,592    29,428    43,540    36,243    33,632    43,357    42,766
 20    M. Board      13,915    43,750    12,444    26,412    21,958    48,870    49,438    43,420    20,740
 21    CD - ROM      46,879    12,476    11,924    10,787    38,888    37,548    42,157    13,130    31,433
 22    CDS           40,457    20,501    32,387    40,639    23,210    14,669    18,764    23,643    27,524
 23    POUCH         30,053    25,190    29,896    36,563    38,453    21,786    12,850    38,071    35,207
 24    UPS           26,200    10,873    20,383    24,657    18,505    25,282    15,501    24,734    34,406
 25    P. SUPPLY     26,298    11,322    48,083    10,587    32,099    23,232    49,008    26,399    32,150

       TOTAL        721,109   708,324   742,934   795,215   813,156   761,553   860,220   797,079   732,970
 Oct       Nov       Dec      TOTAL       % Of total
 23,663    16,446    11,288     284,264         3.14%
 20,986    21,464    30,696     351,428         3.88%
 19,673    38,485    39,537     339,455         3.75%
 22,628    10,856    15,594     265,256         2.93%
 33,215    34,009    44,244     401,752         4.43%
 34,007    10,295    37,685     343,769         3.79%
 17,607    48,838    45,586     361,534         3.99%
 43,406    37,169    43,820     466,566         5.15%
 15,502    16,922    21,426     337,082         3.72%
 11,943    31,714    14,271     316,768         3.50%
 43,193    17,745    12,115     355,132         3.92%
 43,527    37,954    17,863     438,451         4.84%
 36,570    43,368    22,301     404,435         4.46%
 28,632    40,530    24,747     371,058         4.10%
 10,495    29,582    23,675     381,212         4.21%
 11,251    46,118    28,253     438,832         4.84%
 31,261    27,846    35,162     423,784         4.68%
 34,811    32,424    40,109     371,751         4.10%
 32,084    21,184    14,605     384,660         4.25%
 35,344    27,923    30,444     374,658         4.14%
 18,724    27,202    27,591     318,739         3.52%
 17,025    40,883    28,473     328,175         3.62%
 38,957    37,511    29,500     374,037         4.13%
 19,227    16,760    48,011     284,539         3.14%
 22,590    44,576    16,827     343,171         3.79%

666,321   757,804   703,823   9,060,508      100.00%
Excellence In Excel By AASIM
SALES REPORT

S.No   PRODUCT       TOTAL CHART    AVG     CHART    MAX      MIN     Chart
  1    LAPTOP       284,264        23,689           43,925   11,288
  2    DESKTOP      351,428        29,286           43,675   10,509
  3    SPEAKER      339,455        28,288           44,305   12,262
  4    MOUSE        265,256        22,105           45,568   10,856
  5    PRINTER      401,752        33,479           47,375   10,764
  6    DVD          343,769        28,647           44,098   10,295
  7    PROJECTOR    361,534        30,128           48,838   11,202
  8    SCANNER      466,566        38,881           49,710   22,509
  9    LCDS         337,082        28,090           46,596   15,502
 10    MONITORS     316,768        26,397           44,055   11,943
 11    CASSING      355,132        29,594           47,781   10,034
 12    KEYBOARDS    438,451        36,538           48,758   12,583
 13    MOUSE        404,435        33,703           48,028   13,937
 14    CABLES       371,058        30,922           46,608   17,170
 15    SWITCH       381,212        31,768           44,870   10,495
 16    STABILIZER   438,832        36,569           49,268   11,251
 17    PROCESSOR    423,784        35,315           47,767   12,849
 18    MODEM        371,751        30,979           44,294   10,939
 19    RAM          384,660        32,055           43,540   13,592
 20    M. Board     374,658        31,222           49,438   12,444
 21    CD - ROM     318,739        26,562           46,879   10,787
 22    CDS          328,175        27,348           40,883   14,669
 23    POUCH        374,037        31,170           38,957   12,850
 24    UPS          284,539        23,712           48,011   10,873
 25    P. SUPPLY    343,171        28,598           49,008   10,587
       TOTAL        9,060,508
       Excellence In Excel By AASIM
       SALES REPORT                                                                                                                   Select Month
   1                                 Select Month          Amount <=20000 is in Red & >20000 is in Blue Color
   1     S.No   Product                 May           ▲
   1      16    STABILIZER                   47,241                                                                 47,241

   1      17    PROCESSOR                    36,012                                                    36,012

   1      18    MODEM                        16,530                         16,530

   1      19    RAM                          43,540                                                             43,540

   1      20    M. Board                     21,958                             21,958

   1      21    CD - ROM                     38,888                                                       38,888

   1      22    CDS                          23,210                                  23,210

   1      23    POUCH                        38,453                                                      38,453

   1      24    UPS                          18,505                           18,505

   1      25    P. SUPPLY                    32,099                                             32,099

   1
                Scroll To Change Product
 ◄                                                    ►                                                                           PARETO CHART
  18                    MODEM
S.No    Month         Amount     Cummulative %                                                                                       MODEM
  1      Jan              10,939         2.94%            50,000
                                                                                              44,294
                                                                                42,314
  2      Feb              42,314       14.32%
                                                          40,000                                           36,981
  3      Mar              44,294       26.24%
  4      Apr              36,981       36.19%
                                                          30,000
  5      May              16,530       40.63%                                                                                      26,122
                                                                                                                                   47.66%
                                                                                                                         40.63%
  6      Jun              26,122       47.66%                                                              36.19%
                                                          20,000                                                         16,530
  7      Jul              37,882       57.85%                                                 26.24%
                                                                   10,939
  8      Aug              32,018       66.46%                                   14.32%
                                                          10,000
  9      Sep              17,327       71.12%                      2.94%

  10     Oct              34,811       80.49%                  0
  11     Nov              32,424       89.21%                       Jan          Feb           Mar          Apr          May        Jun

  12     Dec              40,109      100.00%                                                                                         Months
        Total           371,751.00
                     Scroll To See Top 1 - 10 Products
    Select Month     Oct                                     60,000 7
       S.No      Products            Top 7 Product(s)
             1      Keyboards                     43,527     50,000
                                                                                43,527    43,406    43,193
             2      Scanner                       43,406                                                      38,957
                                                             40,000                                                    36,570
             3      Cassing                       43,193
             4      Pouch                         38,957     30,000
             5      Mouse                         36,570
             6      M. Board                      35,344     20,000
             7      Modem                         34,811     10,000
                       #N/A                #N/A
                       #N/A                #N/A                      0
                                                                              Keyboards   Scanner   Cassing   Pouch    Mouse
                       #N/A                #N/A




PARETO CHART
   MODEM                                                   100.00%

                                                  89.21%
                                                                         100%

                                      80.49%                             90%
                                                           40,109
          37,882            71.12%                                       80%
                   66.46%              34,811
                   32,018                         32,424                 70%
          57.85%
                                                                         60%
 47.66%
                                                                         50%
                            17,327                                       40%
                                                                         30%
                                                                         20%
                                                                         10%
                                                                         0%
           Jul     Aug       Sep        Oct       Nov       Dec

    Months
36,570    35,344    34,811




Mouse    M. Board   Modem
Excellence In Excel By AASIM

  S.No      Product               Qtr 1          Qtr 2         Qtr 3           Qtr 4      Total
    4       MOUSE                  51,918          114,502         49,758        49,078   469,078
    5       PRINTER                97,556           69,147     123,581          111,468   531,468
    6       DVD                    90,631          113,336         57,815        81,987   501,987
    7       PROJECTOR              66,369          113,199         69,935       112,031   532,031
    8       SCANNER               123,183          101,027     117,961          124,395   544,395
Scroll To Change Products


560,000
                                                                            124,395
                        111,468                           112,031
                                          81,987                                           Qtr 4
              49,078
420,000
                        123,581                                             117,961

                                                          69,935                           Qtr 3
              49,758                      57,815
280,000

              114,502                     113,336         113,199
                                                                            101,027
                        69,147                                                             Qtr 2
140,000
                                                                            123,183
                        97,556            90,631
                                                          66,369                           Qtr 1
              51,918
        0
              MOUSE     PRINTER            DVD           PROJECTOR      SCANNER
51,918          114,502        49,758 49,078                                      469,078
   97,556          69,147             123,581             111,468                 531,468
  90,631             113,336           57,815       81,987                        501,987

 66,369           113,199           69,935         112,031                        532,031
    123,183                 101,027             117,961             124,395       544,395
                              Qtr 1      Qtr 2        Qtr 3       Series
                                                                   Qtr 4
                                                              0             0         0
  560,000
                                                              0       20000      20000
                                                                                              124,395
                                                111,468       0       40000      40000
                                                                                   112,031              Qtr 4
                                                              0      81,987
                                                                      60000      60000
                          49,078                              0       80000      80000
  420,000
                                                              0     100000      100000
                                                123,581                                       117,961
                                                              0     120000      120000                  Qtr 3
                                                              0     140000            0
                                                                                    69,935
                          49,758                                     57,815
                                                              0     160000       20000
  280,000
                                                              0     180000       40000
                          114,502                             0     200000
                                                                    113,336      60000
                                                                                   113,199
                                                                                              101,027   Qtr 2
                                                69,147
                                                              0     220000       80000
                                                              0     240000      100000
  140,000
                                                              0     260000      120000
                                                              0     280000            0       123,183
                                                97,556               90,631                             Qtr 1
                                                              0     300000       20000
                                                                                    66,369
                          51,918                              0     320000       40000
            0
                          MOUSE                 PRINTER       0     340000
                                                                      DVD        60000
                                                                                  PROJECTOR   SCANNER
                                                              0
                                                              0     360000
                                                                    380000       80000
                                                                                100000
                                                              0     400000      120000
                                                              0     420000           0
                                                              0     440000       20000
                                                              0     460000       40000
                                                              0     480000       60000
                                                              0     500000       80000
                                                              0     520000      100000
                                                              0     540000      120000

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:11/5/2012
language:Unknown
pages:8