Page 9 - Graficas Diarias
P. 9

45,000  Botellon
    Categoria  10#Botellon                                        Botellon
    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
       40,000
    PPTO                 37,712                 35,996                 31,991                 29,140                 23,715                 40,737                 39,962                 37,690                 34,971                 35,420                 32,409                 38,223                 36,504                 37,713                 32,452                 33,898                 29,798                 35,932                 35,128                 30,434                 29,880                 30,868                 26,982                 35,022                 35,895                      719,704              34,272
    2018                 32,522                 33,951                 28,452                 26,410                 19,535                 37,946                 38,230                 36,821                 34,221                 37,376                 32,198                 37,773                 35,007                 34,855                 31,711                 35,100                 28,892                 38,976                 35,839                 36,962                 33,585                 34,943                      741,305              33,696                 741,305                      876,088
    2017   35,000                 36,847                 35,170                 31,257                 28,471                 23,171                 39,802                 39,045                 36,825                 34,168                 34,607                 31,665                 37,346                 35,666                 36,848                 31,707                 33,120                 29,114                 35,107                 34,322                 29,736                 29,194                 30,160                 26,363                 34,218                 35,071                      703,188
    Var  -             4,325   -             1,219   -             2,805   -             2,061   -             3,636   -             1,856   -                815  -                    4                    53               2,769                   533             37,773   -             2,339   -                811  -             5,137                3,393   -             4,228                9,862                   732               2,640                3,849                5,749   -           30,160   -           26,363   -           34,218   -           35,071                     38,117                   211  -
    Var%   -12%  -3%  -9%  -7%  -16%  -5%  -2%  0%  0%  8%  2%  #DIV/0!  -6%  -2%  -14%  11%  -13%  34%  2%  8%  13%  20%  -100%  -100%  -100%  -100%  5%  1%  -11%  5%
       30,000
       25,000
       20,000
       15,000
       10,000                                                                                                                PPTO
                                                                                                                             2018
       5,000
                                                                                                                             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               37,712               35,996               31,991               29,140               23,715               40,737               39,962               37,690               34,971               35,420               32,409               38,223               36,504               37,713               32,452               33,898               29,798               35,932               35,128               30,434               29,880               30,868               26,982               35,022               35,895                    719,704            34,272               848,471                    848,471
    2018               32,522               33,951               28,452               26,410               19,535               37,946               38,230               36,821               34,221               37,376               32,198               37,773               35,007               34,855               31,711               35,100               28,892               38,976               35,839               36,962               33,585               34,943  #N/A  #N/A                    741,305            33,696               741,305                    876,088
    2017               36,847               35,170               31,257               28,471               23,171               39,802               39,045               36,825               34,168               34,607               31,665               37,346               35,666               36,848               31,707               33,120               29,114               35,107               34,322               29,736               29,194               30,160               26,363               34,218               35,071                    703,188            33,485               829,000                    829,000
    Var  -          4,325   -          1,219   -          2,805   -          2,061   -          3,636   -          1,856   -              815  -                  4                  53             2,769                533           37,773  -          2,339   -              811  -          5,137              3,393  -          4,228              9,862                732             2,640             3,849             5,749                  38,117                 211  -               87,695                  47,088
    Var%  -11.7%  -3.5%  -9.0%  -7.2%  -15.7%  -4.7%  -2.1%  0.0%  0.2%  8.0%  1.7%  #DIV/0!  -6.3%  -2.3%  -13.9%  10.7%  -12.8%  33.9%  2.1%  7.7%  12.9%  19.7%  5.4%  0.6%  -10.6%  5.7%
    %Ppto  -13.8%  -5.7%  -11.1%  -9.4%  -17.6%  -6.9%  -4.3%  -2.3%  -2.1%  5.5%  -0.7%  #DIV/0!  -8.4%  -4.5%  -15.9%  8.2%  -14.8%  30.8%  -0.3%  5.2%  10.4%  16.9%  3.0%  3.3%
                                                                                                        MTD 18            741,305
                                                                                                        MTD 17            703,188
                                                                                                        VAR            38,117
    Mensual                                                                                             % MTD  5.4%
                                              Botellon
     1,200,000
     1,000,000
     800,000
     600,000
     400,000
     200,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               813,656               824,701           1,638,357               950,203               916,170           1,866,373            1,052,175                966,714           2,018,889               920,390               991,334           1,911,724               943,015               848,471               800,605               792,567            8,378,357
     2018               762,439               799,756           1,562,195               898,541               972,033           1,870,574            1,000,018                922,676           1,922,694               946,749               972,180           1,918,929               914,010  #N/A  #N/A  #N/A            8,188,402
     2017               795,951               806,739           1,602,690               928,915               894,186           1,823,101            1,029,418                945,725           1,975,143               898,989               969,054           1,868,043               922,263               829,000               782,945               682,062            8,191,240
     Var  -          33,512   -            6,983   -          40,495   -          30,374              77,847             47,473   -          29,400   -          23,049   -          52,449              47,760                3,126             50,886   -            8,253   -283800%
     % AA  -4.2%  -0.9%  -2.5%  -3.3%  8.7%  2.6%  -2.9%  -2.4%  -2.7%  5.3%  0.3%  2.7%  -0.9%   0%
     % PPTO  -6.3%  -3.0%  -4.6%  -5.4%  6.1%  0.2%  -5.0%  -4.6%  -4.8%  2.9%  -1.9%  0.4%  -3.1%  -2%
                                                                  ACUM SEP
                                                         PPTO             8,378,357
                                                         2018             8,188,402
                                                         2017             8,191,240
                                                          Var    -               2,838
                                                         % AA      0.0%
                                                         % PPTO    -2.3%
   4   5   6   7   8   9   10   11   12   13   14