Page 3 - Graficas Diarias
P. 3

3,000  Gatorade
    Categoria  03#Gatorade                                        Gatorade
    Descripcion  1   2   3   4   5   6   7   8   9   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   MTD   AVGTD   TTL   PY
    PPTO   2,500                   1,486                   2,692                   1,988                   2,230                   1,531                   1,138                   2,069                   2,054                   1,685                   1,556                   1,346                   1,259                   2,613                   2,030                   2,237                   1,406                   1,287                   1,621                   1,536                   1,022                   1,431                   1,409                   1,359                   1,652                   2,363
    2018                   1,110                   2,250                   2,254                   2,011                   1,173                   1,616                   1,646                   2,179                   1,685                   1,993                   1,740                   2,144                   1,748                   2,362                   2,182                   1,462                   1,640                   1,664                   2,106                   2,189                   1,826                   2,367                        41,346               1,879                    41,346
    2017                   1,392                   2,521                   1,861                   2,089                   1,434                   1,066                   1,938                   1,924                   1,578                   1,457                   1,261                   1,179                   2,447                   1,901                   2,095                   1,316                   1,206                   1,518                   1,438                     957                    1,340                   1,320                   1,273                   1,547                   2,213
    Var  -                282  -                271                  392  -                  78  -                261                  551  -                292                  256                  107                  536                  480               2,144                   570  -                  85                  281  -                633                  323                  458                  588                  751                  869               1,026   -             1,320   -             1,273   -             1,547   -             2,213                       7,429                  260
    Var%   -20%  -11%  21%  -4%  -18%  52%  -15%  13%  7%  37%  38%  #DIV/0!  48%  -3%  15%  -30%  25%  38%  39%  52%  91%  77%  -100%  -100%  -100%  -100%  22%  16%  3%  22%
       2,000
       1,500
       1,000
                                                                                                                             PPTO
        500                                                                                                                  2018
                                                                                                                             2017
        -
          1    2    3   4    5    6    7   8    9    10  11   12   13   14  15   16   17   18  19   20   21   22  23   24   25   26
         lun-01  mar-02  mié-03  jue-04  vie-05  lun-08  mar-09  mié-10  jue-11  vie-12  sáb-13  lun-15  mar-16  mié-17  jue-18  vie-19  sáb-20  lun-22  mar-23  mié-24  jue-25  vie-26  sáb-27  lun-29  mar-30  mié-31
    Dia Habil  1   2   3   4   5   6   7   8    9    10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   MTD   AVGTD   TTL   PY OCT
    PPTO                 1,486                 2,692                 1,988                 2,230                 1,531                 1,138                 2,069                 2,054                 1,685                 1,556                 1,346                 1,259                 2,613                 2,030                 2,237                 1,406                 1,287                 1,621                 1,536                 1,022                 1,431                 1,409                 1,359                 1,652                 2,363                      36,216              1,725                 43,000
    2018                 1,110                 2,250                 2,254                 2,011                 1,173                 1,616                 1,646                 2,179                 1,685                 1,993                 1,740                 2,144                 1,748                 2,362                 2,182                 1,462                 1,640                 1,664                 2,106                 2,189                 1,826                 2,367  #N/A  #N/A                      41,346              1,879                 41,346                      48,864
    2017                 1,392                 2,521                 1,861                 2,089                 1,434                 1,066                 1,938                 1,924                 1,578                 1,457                 1,261                 1,179                 2,447                 1,901                 2,095                 1,316                 1,206                 1,518                 1,438                    957                 1,340                 1,320                 1,273                 1,547                 2,213                      33,917              1,619                 40,271
    Var  -              282  -              271                392  -                78  -              261                551  -              292                256                107                536                480             2,144                570  -                85                281  -              633                323                458                588                751                869             1,026                    7,429                 260                   1,076                    8,593
    Var%  -20.3%  -10.8%  21.1%  -3.7%  -18.2%  51.7%  -15.1%  13.3%  6.8%  36.8%  38.0%  #DIV/0!  48.3%  -3.5%  14.8%  -30.2%  24.6%  38.0%  38.7%  52.2%  90.8%  76.6%  21.9%  16.0%  2.7%  21.3%
    %Ppto  -25.3%  -16.4%  13.4%  -9.8%  -23.4%  42.0%  -20.4%  6.1%  0.0%  28.1%  29.3%  #DIV/0!  38.9%  -9.6%  7.5%  -34.6%  16.6%  29.3%  29.9%  42.5%  78.7%  65.4%  14.2%  13.6%
                                                                                                        MTD 18              41,346
                                                                                                        MTD 17              33,917
                                                                                                        VAR              7,429
    Mensual                                                                                             % MTD  21.9%
                                             Gatorade
     70,000
     60,000
     50,000
     40,000
     30,000
     20,000
     10,000
      -
         ENE    FEB    MAR    ABR    MAY     JUN    JUL    AGO    SEP    OCT     NOV    DIC
                                            PPTO  2018  2017
            1    2        3    4         5    6        7    8        9    10       11   12
    DESCRIPCION  ENE  FEB  I BIM  MAR  ABR  II BIM  MAY  JUN  III BIM  JUL  AGO  IV BIM  SEP  OCT  V BIM  NOV  DIC  VI BIM  YTD
     PPTO                 33,500                 32,902                66,402                 38,835                 52,500                91,335                 58,876                 58,000              116,876                 56,000                 56,000              112,000                 56,000                 43,000                 36,000                 38,387               442,613
     2018                 28,018                 35,238                63,255                 56,276                 54,882              111,158                 59,143                 57,926              117,069                 60,755                 61,769              122,523                 66,224  #N/A  #N/A  #N/A               480,231
     2017                 31,738                 31,221                62,959                 37,193                 49,600                86,794                 56,792                 59,229              116,021                 52,322                 52,715              105,037                 59,639                 40,271                 31,750                 30,520               430,450
     Var  -            3,720                4,016                   296             19,083                5,282             24,365                2,351   -            1,303               1,048                8,433                9,054             17,486                6,585   4978083%
     % AA  -11.7%  12.9%  0.5%  51.3%  10.6%  28.1%  4.1%  -2.2%  0.9%  16.1%  17.2%  16.6%  11.0%  12%
     % PPTO  -16.4%  7.1%  -4.7%  44.9%  4.5%  21.7%  0.5%  -0.1%  0.2%  8.5%  10.3%  9.4%  18.3%  8%
                                                                  ACUM SEP
                                                         PPTO                442,613
                                                         2018                480,231
                                                         2017                430,450
                                                          Var                  49,781
                                                         % AA      11.6%
                                                         % PPTO    8.5%
   1   2   3   4   5   6   7   8