Untitled

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 39

Capacidad de carga: 11 ton

24 estibas

POLITICA INVENTARIO
Marcas mayoritarias: 8 días
Otras Marcas: 15 días
Tiempo vida útil cerveza: 6 meses
Cerveza barril: 45 días

MARCA Barranquilla Bogotá Bucaramanga Medellín


CLUB COLOMBIA 300 cc 52.2 44.8 29.8 29.8
CLUB COLOMBIA NR 300 cc 33.0 22.0 11.0 10.0
CLUB COLOMBIA 350 cc 61.5 32.0 9.0 9.5
COSTEÑA 300 cc 12.0 25.0 9.8 7.0
COSTEÑA NR 300 cc 4.2 12.0 2.8 2.5
COSTEÑA 350 cc 31.8 1,331.0 650.0 9.5
POKER 300 cc 455.8 1,365.0 245.0 45.8
POKER NR 300 cc 69.0 1,200.0 750.0 54.0
POKER 350 cc 49.0 978.0 122.0 46.0
AGUILA 300 cc 603.0 1,300.0 432.0 122.0
AGUILA NR 300 cc 144.0 238.0 54.0 38.0
AGUILA 350 cc 95.0 145.0 45.0 28.0
PILSEN 300 cc 302.0 253.0 105.0 1,256.0
PILSEN NR 300 cc 119.0 104.0 98.0 1,130.0
PILSEN 350 cc 56.0 64.0 45.0 987.0
CLARITA 175 cc 345.0 0.0 0.0 1,230.0
COSTEÑITA 175 cc 789.0 25.0 345.0 122.0
CLUB LATA 10 Oz 33.6 34.0 46.0 25.0
CLUB LATA 8 Oz 21.8 78.0 16.0 12.0
AGUILA 8 Oz 296.0 345.0 145.0 67.0
AGUILA 10 Oz 275.0 546.0 134.0 79.0
COSTEÑA 10 Oz 12.0 123.0 23.0 14.0
PILSEN 10 Oz 189.0 187.0 124.0 320.0
PILSEN 8 Oz 122.0 105.0 97.0 365.0
POKER 10 Oz 131.0 456.0 102.0 34.0
CLUB BARRIL 30 l (Dec) 1.3 1.8 0.8 0.3
CLUB BARRIL 50 l (Dec) 2.8 4.2 1.0 0.8
POKER BARRIL 30 l (Dec) 0.0 3.0 1.3 0.0
POKER BARRIL 50 l (Dec) 0.0 5.0 1.8 0.0
AGUILA BARRIL 30 l (Dec) 2.3 4.0 2.0 1.0
AGUILA BARRIL 50 l (Dec) 4.5 5.0 2.3 1.9
PILSEN BARRIL 30 l (Dec) 0.0 0.0 0.0 3.8
PILSEN BARRIL 50 l (Dec) 0.0 0.0 0.0 4.7
COSTEÑA BARRIL 50 l (Dec) 0.0 2.3 0.5 0.0

VENTAS POR ZONAS


CD Bquilla CD Bogotá CD B/manga CD Medellín
CLUB COLOMBIA 40% 40% 12% 8%
AGUILA 50% 25% 20% 5%
POKER 14% 70% 9% 7%
PILSEN 10% 10% 2% 78%
COSTEÑA 8% 85% 3% 4%
COSTEÑITA 65% 6% 25% 4%
CLARITA 12% 2% 4% 82%
Capacidad de carga: 3,1 ton

12 estibas
MARCA Barranquilla Bogotá Bucaramanga Medellín
CLUB COLOMBIA 61.5 32.0 9.0 9.5
AGUILA 350 cc 95.0 145.0 45.0 28.0
MARCA Barranquilla
CLUB COLOMBIA 350 cc 1,537.5
AGUILA 350 cc 2,375.0
Bogotá BucaramangaMedellín
800.0 225.0 237.5
3,625.0 1,125.0 700.0
DEMANDA (miles Dec)
MARCA ENERO FEBRERO MARZO ABRIL MAYO JUNIO
CLUB COLOMBIA 300 cc 5,670.0 6,237.0 4,252.5 4,536.0 5,783.4 6,350.4
CLUB COLOMBIA NR 300 cc 1,270.0 1,397.0 952.5 1,016.0 1,295.4 1,422.4
CLUB COLOMBIA 350 cc 2,340.0 2,574.0 1,755.0 1,872.0 2,386.8 2,620.8
COSTEÑA 300 cc 12,500.0 13,750.0 9,375.0 10,000.0 12,750.0 14,000.0
COSTEÑA NR 300 cc 875.0 962.5 656.3 700.0 892.5 980.0
COSTEÑA 350 cc 1,210.0 1,331.0 907.5 968.0 1,234.2 1,355.2
POKER 300 cc 17,320.0 19,052.0 12,990.0 13,856.0 17,666.4 19,398.4
POKER NR 300 cc 2,650.0 2,915.0 1,987.5 2,120.0 2,703.0 2,968.0
POKER 350 cc 1,870.0 2,057.0 1,402.5 1,496.0 1,907.4 2,094.4
AGUILA 300 cc 22,920.0 25,212.0 17,190.0 18,336.0 23,378.4 25,670.4
AGUILA NR 300 cc 5,480.0 6,028.0 4,110.0 4,384.0 5,589.6 6,137.6
AGUILA 350 cc 3,620.0 3,982.0 2,715.0 2,896.0 3,692.4 4,054.4
PILSEN 300 cc 19,250.0 21,175.0 14,437.5 15,400.0 19,635.0 21,560.0
PILSEN NR 300 cc 4,530.0 4,983.0 3,397.5 3,624.0 4,620.6 5,073.6
PILSEN 350 cc 2,130.0 2,343.0 1,597.5 1,704.0 2,172.6 2,385.6
CLARITA 175 cc 10,230.0 11,253.0 7,672.5 8,184.0 10,434.6 11,457.6
COSTEÑITA 175 cc 24,500.0 26,950.0 18,375.0 19,600.0 24,990.0 27,440.0
CLUB LATA 10 Oz 1,280.0 1,408.0 960.0 1,024.0 1,305.6 1,433.6
CLUB LATA 8 Oz 830.0 913.0 622.5 664.0 846.6 929.6
AGUILA 8 Oz 11,250.0 12,375.0 8,437.5 9,000.0 11,475.0 12,600.0
AGUILA 10 Oz 10,450.0 11,495.0 7,837.5 8,360.0 10,659.0 11,704.0
COSTEÑA 10 Oz 8,300.0 9,130.0 6,225.0 6,640.0 8,466.0 9,296.0
PILSEN 10 Oz 9,520.0 10,472.0 7,140.0 7,616.0 9,710.4 10,662.4
PILSEN 8 Oz 4,650.0 5,115.0 3,487.5 3,720.0 4,743.0 5,208.0
POKER 10 Oz 8,780.0 9,658.0 6,585.0 7,024.0 8,955.6 9,833.6
CLUB BARRIL 30 l (Dec) 51.0 56.1 38.3 40.8 52.0 57.1
CLUB BARRIL 50 l (Dec) 102.0 112.2 76.5 81.6 104.0 114.2
POKER BARRIL 30 l (Dec) 21.0 23.1 15.8 16.8 21.4 23.5
POKER BARRIL 50 l (Dec) 57.0 62.7 42.8 45.6 58.1 63.8
AGUILA BARRIL 30 l (Dec) 67.0 73.7 50.3 53.6 68.3 75.0
AGUILA BARRIL 50 l (Dec) 125.0 137.5 93.8 100.0 127.5 140.0
PILSEN BARRIL 30 l (Dec) 30.0 33.0 22.5 24.0 30.6 33.6
PILSEN BARRIL 50 l (Dec) 108.0 118.8 81.0 86.4 110.2 121.0
COSTEÑA BARRIL 50 l (Dec) 124.0 136.4 93.0 99.2 126.5 138.9

10 Onz=300 cc
8 Onz= 250 cc
1 Estiba= 72 cajas (300/350)
1 caja 300/350= 30 unidades
1 caja NR= 24 unidades
1 Estiba Barril= 9 barriles
es Dec)
JULIO AGOSTOSEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE
6,066.9 5,953.5 3,402.0 6,520.5 6,804.0 7,087.5
1,358.9 1,333.5 762.0 1,460.5 1,524.0 1,587.5
2,503.8 2,457.0 1,404.0 2,691.0 2,808.0 2,925.0
13,375.0 13,125.0 7,500.0 14,375.0 15,000.0 15,625.0
936.3 918.8 525.0 1,006.3 1,050.0 1,093.8
1,294.7 1,270.5 726.0 1,391.5 1,452.0 1,512.5
18,532.4 18,186.0 10,392.0 19,918.0 20,784.0 21,650.0
2,835.5 2,782.5 1,590.0 3,047.5 3,180.0 3,312.5
2,000.9 1,963.5 1,122.0 2,150.5 2,244.0 2,337.5
24,524.4 24,066.0 13,752.0 26,358.0 27,504.0 28,650.0
5,863.6 5,754.0 3,288.0 6,302.0 6,576.0 6,850.0
3,873.4 3,801.0 2,172.0 4,163.0 4,344.0 4,525.0
20,597.5 20,212.5 11,550.0 22,137.5 23,100.0 24,062.5
4,847.1 4,756.5 2,718.0 5,209.5 5,436.0 5,662.5
2,279.1 2,236.5 1,278.0 2,449.5 2,556.0 2,662.5
10,946.1 10,741.5 6,138.0 11,764.5 12,276.0 12,787.5
26,215.0 25,725.0 14,700.0 28,175.0 29,400.0 30,625.0
1,369.6 1,344.0 768.0 1,472.0 1,536.0 1,600.0
888.1 871.5 498.0 954.5 996.0 1,037.5
12,037.5 11,812.5 6,750.0 12,937.5 13,500.0 14,062.5
11,181.5 10,972.5 6,270.0 12,017.5 12,540.0 13,062.5
8,881.0 8,715.0 4,980.0 9,545.0 9,960.0 10,375.0
10,186.4 9,996.0 5,712.0 10,948.0 11,424.0 11,900.0
4,975.5 4,882.5 2,790.0 5,347.5 5,580.0 5,812.5
9,394.6 9,219.0 5,268.0 10,097.0 10,536.0 10,975.0
54.6 53.6 30.6 58.7 61.2 63.8
109.1 107.1 61.2 117.3 122.4 127.5
22.5 22.1 12.6 24.2 25.2 26.3
61.0 59.9 34.2 65.6 68.4 71.3
71.7 70.4 40.2 77.1 80.4 83.8
133.8 131.3 75.0 143.8 150.0 156.3
32.1 31.5 18.0 34.5 36.0 37.5
115.6 113.4 64.8 124.2 129.6 135.0
132.7 130.2 74.4 142.6 148.8 155.0
MARCA ENERO FEBRERO MARZO ABRIL MAYO JUNIO
CLUB COLOMBIA 300 5,670.0 6,237.0 4,252.5 4,536.0 5,783.4 6,350.4
CLUB COLOMBIA NR 1,270.0 1,397.0 952.5 1,016.0 1,295.4 1,422.4
CLUB COLOMBIA 350 2,340.0 2,574.0 1,755.0 1,872.0 2,386.8 2,620.8
COSTEÑA 300 cc 12,500.0 13,750.0 9,375.0 10,000.0 12,750.0 14,000.0
COSTEÑA NR 300 cc 875.0 962.5 656.3 700.0 892.5 980.0
COSTEÑA 350 cc 1,210.0 1,331.0 907.5 968.0 1,234.2 1,355.2
POKER 300 cc 17,320.0 19,052.0 12,990.0 13,856.0 17,666.4 19,398.4
POKER NR 300 cc 2,650.0 2,915.0 1,987.5 2,120.0 2,703.0 2,968.0
POKER 350 cc 1,870.0 2,057.0 1,402.5 1,496.0 1,907.4 2,094.4
AGUILA 300 cc 22,920.0 25,212.0 17,190.0 18,336.0 23,378.4 25,670.4
AGUILA NR 300 cc 5,480.0 6,028.0 4,110.0 4,384.0 5,589.6 6,137.6
AGUILA 350 cc 3,620.0 3,982.0 2,715.0 2,896.0 3,692.4 4,054.4
PILSEN 300 cc 19,250.0 21,175.0 14,437.5 15,400.0 19,635.0 21,560.0
PILSEN NR 300 cc 4,530.0 4,983.0 3,397.5 3,624.0 4,620.6 5,073.6
PILSEN 350 cc 2,130.0 2,343.0 1,597.5 1,704.0 2,172.6 2,385.6
CLARITA 175 cc 10,230.0 11,253.0 7,672.5 8,184.0 10,434.6 11,457.6
COSTEÑITA 175 cc 24,500.0 26,950.0 18,375.0 19,600.0 24,990.0 27,440.0
CLUB LATA 10 Oz 1,280.0 1,408.0 960.0 1,024.0 1,305.6 1,433.6
CLUB LATA 8 Oz 830.0 913.0 622.5 664.0 846.6 929.6
AGUILA 8 Oz 11,250.0 12,375.0 8,437.5 9,000.0 11,475.0 12,600.0
AGUILA 10 Oz 10,450.0 11,495.0 7,837.5 8,360.0 10,659.0 11,704.0
COSTEÑA 10 Oz 8,300.0 9,130.0 6,225.0 6,640.0 8,466.0 9,296.0
PILSEN 10 Oz 9,520.0 10,472.0 7,140.0 7,616.0 9,710.4 10,662.4
PILSEN 8 Oz 4,650.0 5,115.0 3,487.5 3,720.0 4,743.0 5,208.0
POKER 10 Oz 8,780.0 9,658.0 6,585.0 7,024.0 8,955.6 9,833.6
CLUB BARRIL 30 l (D 51.0 56.1 38.3 40.8 52.0 57.1
CLUB BARRIL 50 l (D 102.0 112.2 76.5 81.6 104.0 114.2
POKER BARRIL 30 l 21.0 23.1 15.8 16.8 21.4 23.5
POKER BARRIL 50 l 57.0 62.7 42.8 45.6 58.1 63.8
AGUILA BARRIL 30 l 67.0 73.7 50.3 53.6 68.3 75.0
AGUILA BARRIL 50 l 125.0 137.5 93.8 100.0 127.5 140.0
PILSEN BARRIL 30 l 30.0 33.0 22.5 24.0 30.6 33.6
PILSEN BARRIL 50 l 108.0 118.8 81.0 86.4 110.2 121.0
COSTEÑA BARRIL 50 124.0 136.4 93.0 99.2 126.5 138.9
JULIO AGOSTOSEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE
6,066.9 5,953.5 3,402.0 6,520.5 6,804.0 7,087.5
1,358.9 1,333.5 762.0 1,460.5 1,524.0 1,587.5
2,503.8 2,457.0 1,404.0 2,691.0 2,808.0 2,925.0
13,375.0 13,125.0 7,500.0 14,375.0 15,000.0 15,625.0
936.3 918.8 525.0 1,006.3 1,050.0 1,093.8
1,294.7 1,270.5 726.0 1,391.5 1,452.0 1,512.5
18,532.4 18,186.0 10,392.0 19,918.0 20,784.0 21,650.0
2,835.5 2,782.5 1,590.0 3,047.5 3,180.0 3,312.5
2,000.9 1,963.5 1,122.0 2,150.5 2,244.0 2,337.5
24,524.4 24,066.0 13,752.0 26,358.0 27,504.0 28,650.0
5,863.6 5,754.0 3,288.0 6,302.0 6,576.0 6,850.0
3,873.4 3,801.0 2,172.0 4,163.0 4,344.0 4,525.0
20,597.5 20,212.5 11,550.0 22,137.5 23,100.0 24,062.5
4,847.1 4,756.5 2,718.0 5,209.5 5,436.0 5,662.5
2,279.1 2,236.5 1,278.0 2,449.5 2,556.0 2,662.5
10,946.1 10,741.5 6,138.0 11,764.5 12,276.0 12,787.5
26,215.0 25,725.0 14,700.0 28,175.0 29,400.0 30,625.0
1,369.6 1,344.0 768.0 1,472.0 1,536.0 1,600.0
888.1 871.5 498.0 954.5 996.0 1,037.5
12,037.5 11,812.5 6,750.0 12,937.5 13,500.0 14,062.5
11,181.5 10,972.5 6,270.0 12,017.5 12,540.0 13,062.5
8,881.0 8,715.0 4,980.0 9,545.0 9,960.0 10,375.0
10,186.4 9,996.0 5,712.0 10,948.0 11,424.0 11,900.0
4,975.5 4,882.5 2,790.0 5,347.5 5,580.0 5,812.5
9,394.6 9,219.0 5,268.0 10,097.0 10,536.0 10,975.0
54.6 53.6 30.6 58.7 61.2 63.8
109.1 107.1 61.2 117.3 122.4 127.5
22.5 22.1 12.6 24.2 25.2 26.3
61.0 59.9 34.2 65.6 68.4 71.3
71.7 70.4 40.2 77.1 80.4 83.8
133.8 131.3 75.0 143.8 150.0 156.3
32.1 31.5 18.0 34.5 36.0 37.5
115.6 113.4 64.8 124.2 129.6 135.0
132.7 130.2 74.4 142.6 148.8 155.0
COCIMIENTO
ACME MEURA
Hl calientes 1000 1000
Hl frios 960 960
Tiempo coc (h) 4.5 4.5
Aseo semanal (h) 16 16
Aseo c/2 coc (h) 0.5 0.5

FERMENTACION - MADURACION
UNIPROCESO FERMENTADOR MADURADOR
N° 10 8 8
CAPACIDAD (Hl) 10000 2300 2300
Tiempo ocup (dias) 13 6 7
Aseo requerido(h) 8 5 5

FILTRACION - DILUCION
US FILTER STEINECKER
CAPACIDAD Hl/h) 600 600
EFICIENCIA (%) 80 80
CICLO (h) 18 18
FACTOR DILUCION 1.46
ASEO 4 4

ENVASADO BOTELLAS
TREN 1 TREN 2 TREN 4 TREN 6
CAPACIDAD (Dec/h) 6000 7200 7800 4800
EFICIENCIA (%) 85 86 85 75
ASEO SEMANAL (h) 16 16 16 8
TURNOS (8 h) 3 3 3 2
TIPO ENVASE 175 300/350 300/350 TODOS

ENVASADO LATAS Y BARRILES


TREN LATAS BARRILES
CAPACIDAD (Dec/h) 6000 4
EFICIENCIA (%) 92 75
ASEO SEMANAL (h) 8 8
TURNOS (8 h) 1 1
TIPO ENVASE TODOS 50 l/ 30 l

Personal/turno
Cocimiento 7
Fermentación/Maduración 3
Filtración 2
Envase T1 15
Envase T2 18
Envase T4 18
Envase T6 9
Envase T Latas 6
Envase Barriles 2
COCIMIENTO
ACME ACME
Hl calientes 1200 1200
Hl frios 1152 1152
Tiempo coc (h) 4.5 4.5
Aseo semanal (h) 16 16
Aseo c/2 coc (h) 0.5 0.5

FERMENTACION - MADURACION
UNIPROCESO
N° 30
CAPACIDAD (Hl) 12000
Tiempo ocup (dias) 13
Aseo requerido(h) 8

FILTRACION - DILUCION
STEINECKER STEINECKER
CAPACIDAD Hl/h) 1200 600
EFICIENCIA (%) 85 85
CICLO (h) 20 18
FACTOR DILUCION 1.46
ASEO 4 4

ENVASADO BOTELLAS
TREN 1 TREN 2 TREN 3
CAPACIDAD (Dec/h) 7200 7800 12000
EFICIENCIA (%) 85 86 85
ASEO SEMANAL (h) 16 16 16
TURNOS (8 h) 3 3 3
TIPO ENVASE 300/350 300/350 300/350

ENVASADO LATAS Y BARRILES


TREN LATAS BARRILES
CAPACIDAD (Dec/h) 6000 8
EFICIENCIA (%) 90 80
ASEO SEMANAL (h) 8 8
TURNOS (8 h) 3 2
TIPO ENVASE TODOS 50 l/30 l

Personal/turno
Cocimiento 7
Fermentación/Maduración 3
Filtración 3
Envase T1 16
Envase T2 18
Envase T3 20
Envase T Latas 6
Envase Barriles 2
COCIMIENTO
ACME ACME
Hl calientes 1200 1200
Hl frios 1152 1152
Tiempo coc (h) 4.5 4.5
Aseo semanal (h) 16 16
Aseo c/2 coc (h) 0.5 0.5

FERMENTACION - MADURACION
UNIPROCESO
N° 30
CAPACIDAD (Hl) 12000
Tiempo ocup (dias) 13
Aseo requerido(h) 8

FILTRACION - DILUCION
STEINECKER STEINECKER
CAPACIDAD Hl/h) 1200 600
EFICIENCIA (%) 85 85
CICLO (h) 20 18
FACTOR DILUCION 1.46
ASEO 4 4

ENVASADO BOTELLAS
TREN 1 TREN 2 TREN 3
CAPACIDAD (Dec/h) 7200 7800 7200
EFICIENCIA (%) 85 86 85
ASEO SEMANAL (h) 16 16 16
TURNOS (8 h) 3 3 2
TIPO ENVASE 300/350 300/350 300/350

ENVASADO LATAS Y BARRILES


BARRILES
CAPACIDAD (Dec/h) 6
EFICIENCIA (%) 80
ASEO SEMANAL (h) 8
TURNOS (8 h) 2
TIPO ENVASE 50 l/30 l

Personal/turno
Cocimiento 7
Fermentación/Maduración 3
Filtración 3
Envase T1 16
Envase T2 18
Envase T3 16
Envase T Latas 6
Envase Barriles 2
COCIMIENTO
MEURA ACME
Hl calientes 1000 1000
Hl frios 960 960
Tiempo coc (h) 4.5 4.5
Aseo semanal (h) 16 16
Aseo c/2 coc (h) 0.5 0.5

FERMENTACION - MADURACION
UNIPROCESO UNIPROCESO
N° 16 4
CAPACIDAD (Hl) 10000 4500
Tiempo ocup (dias) 13 13
Aseo requerido(h) 8 6

FILTRACION - DILUCION
STEINECKER US FILTER
CAPACIDAD Hl/h) 1200 500
EFICIENCIA (%) 85 80
CICLO (h) 20 18
FACTOR DILUCION 1.46
ASEO 4 4

ENVASADO BOTELLAS
TREN 1 TREN 2 TREN 3
CAPACIDAD (Dec/h) 7200 7800 6000
EFICIENCIA (%) 85 86 85
ASEO SEMANAL (h) 16 16 16
TURNOS (8 h) 3 3 2
TIPO ENVASE 300/350 300/350 175

ENVASADO LATAS Y BARRILES


BARRILES
CAPACIDAD (Dec/h) 6
EFICIENCIA (%) 85
ASEO SEMANAL (h) 8
TURNOS (8 h) 1
TIPO ENVASE 50 l/30 l

Personal/turno
Cocimiento 7
Fermentación/Maduración 3
Filtración 3
Envase T1 16
Envase T2 18
Envase T3 15
Envase T Latas 6
Envase Barriles 2
COCIMIENTO : 1 HL
ÁCIDO FOSFÓRICO: 6.5 g
SULFATO DE CALCIO(YESO): 13.5 g
SULFATO DE ZINC: 25 g
TIERRA DIATOMÁCEA: 1.8 g
TRITURADO DE ARROZ 5 Kg
CEBADA MALTEADA 16 Kg
JARABE DE ALTA MALTOSA 3 Kg
EXTRACTO DE LUPULO 0.01 Kg
LUPULO PELLETS 0.05 Kg
c ENERO FEBRERO MARZO ABRIL MAYO
CLUB COLOMBIA 300 cc 5,670.0 6,237.0 4,252.5 4,536.0 5,783.4
CLUB COLOMBIA NR 300 cc 1,270.0 1,397.0 952.5 1,016.0 1,295.4
CLUB COLOMBIA 350 cc 2,340.0 2,574.0 1,755.0 1,872.0 2,386.8
COSTEÑA 300 cc 12,500.0 13,750.0 9,375.0 10,000.0 12,750.0
COSTEÑA NR 300 cc 875.0 962.5 656.3 700.0 892.5
COSTEÑA 350 cc 1,210.0 1,331.0 907.5 968.0 1,234.2
POKER 300 cc 17,320.0 19,052.0 12,990.0 13,856.0 17,666.4
POKER NR 300 cc 2,650.0 2,915.0 1,987.5 2,120.0 2,703.0
POKER 350 cc 1,870.0 2,057.0 1,402.5 1,496.0 1,907.4
AGUILA 300 cc 22,920.0 25,212.0 17,190.0 18,336.0 23,378.4
AGUILA NR 300 cc 5,480.0 6,028.0 4,110.0 4,384.0 5,589.6
AGUILA 350 cc 3,620.0 3,982.0 2,715.0 2,896.0 3,692.4
PILSEN 300 cc 19,250.0 21,175.0 14,437.5 15,400.0 19,635.0
PILSEN NR 300 cc 4,530.0 4,983.0 3,397.5 3,624.0 4,620.6
PILSEN 350 cc 2,130.0 2,343.0 1,597.5 1,704.0 2,172.6
CLARITA 175 cc 10,230.0 11,253.0 7,672.5 8,184.0 10,434.6
COSTEÑITA 175 cc 24,500.0 26,950.0 18,375.0 19,600.0 24,990.0
CLUB LATA 10 Oz 1,280.0 1,408.0 960.0 1,024.0 1,305.6
CLUB LATA 8 Oz 830.0 913.0 622.5 664.0 846.6
AGUILA 8 Oz 11,250.0 12,375.0 8,437.5 9,000.0 11,475.0
AGUILA 10 Oz 10,450.0 11,495.0 7,837.5 8,360.0 10,659.0
COSTEÑA 10 Oz 8,300.0 9,130.0 6,225.0 6,640.0 8,466.0
PILSEN 10 Oz 9,520.0 10,472.0 7,140.0 7,616.0 9,710.4
PILSEN 8 Oz 4,650.0 5,115.0 3,487.5 3,720.0 4,743.0
POKER 10 Oz 8,780.0 9,658.0 6,585.0 7,024.0 8,955.6
CLUB BARRIL 30 l (Dec) 51.0 56.1 38.3 40.8 52.0
CLUB BARRIL 50 l (Dec) 102.0 112.2 76.5 81.6 104.0
POKER BARRIL 30 l (Dec) 21.0 23.1 15.8 16.8 21.4
POKER BARRIL 50 l (Dec) 57.0 62.7 42.8 45.6 58.1
AGUILA BARRIL 30 l (Dec) 67.0 73.7 50.3 53.6 68.3
AGUILA BARRIL 50 l (Dec) 125.0 137.5 93.8 100.0 127.5
PILSEN BARRIL 30 l (Dec) 30.0 33.0 22.5 24.0 30.6
PILSEN BARRIL 50 l (Dec) 108.0 118.8 81.0 86.4 110.2
COSTEÑA BARRIL 50 l (Dec) 124.0 136.4 93.0 99.2 126.5
JUNIO JULIO AGOSTOSEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE
6,350.4 6,066.9 5,953.5 3,402.0 6,520.5 6,804.0 7,087.5
1,422.4 1,358.9 1,333.5 762.0 1,460.5 1,524.0 1,587.5
2,620.8 2,503.8 2,457.0 1,404.0 2,691.0 2,808.0 2,925.0
14,000.0 13,375.0 13,125.0 7,500.0 14,375.0 15,000.0 15,625.0
980.0 936.3 918.8 525.0 1,006.3 1,050.0 1,093.8
1,355.2 1,294.7 1,270.5 726.0 1,391.5 1,452.0 1,512.5
19,398.4 18,532.4 18,186.0 10,392.0 19,918.0 20,784.0 21,650.0
2,968.0 2,835.5 2,782.5 1,590.0 3,047.5 3,180.0 3,312.5
2,094.4 2,000.9 1,963.5 1,122.0 2,150.5 2,244.0 2,337.5
25,670.4 24,524.4 24,066.0 13,752.0 26,358.0 27,504.0 28,650.0
6,137.6 5,863.6 5,754.0 3,288.0 6,302.0 6,576.0 6,850.0
4,054.4 3,873.4 3,801.0 2,172.0 4,163.0 4,344.0 4,525.0
21,560.0 20,597.5 20,212.5 11,550.0 22,137.5 23,100.0 24,062.5
5,073.6 4,847.1 4,756.5 2,718.0 5,209.5 5,436.0 5,662.5
2,385.6 2,279.1 2,236.5 1,278.0 2,449.5 2,556.0 2,662.5
11,457.6 10,946.1 10,741.5 6,138.0 11,764.5 12,276.0 12,787.5
27,440.0 26,215.0 25,725.0 14,700.0 28,175.0 29,400.0 30,625.0
1,433.6 1,369.6 1,344.0 768.0 1,472.0 1,536.0 1,600.0
929.6 888.1 871.5 498.0 954.5 996.0 1,037.5
12,600.0 12,037.5 11,812.5 6,750.0 12,937.5 13,500.0 14,062.5
11,704.0 11,181.5 10,972.5 6,270.0 12,017.5 12,540.0 13,062.5
9,296.0 8,881.0 8,715.0 4,980.0 9,545.0 9,960.0 10,375.0
10,662.4 10,186.4 9,996.0 5,712.0 10,948.0 11,424.0 11,900.0
5,208.0 4,975.5 4,882.5 2,790.0 5,347.5 5,580.0 5,812.5
9,833.6 9,394.6 9,219.0 5,268.0 10,097.0 10,536.0 10,975.0
57.1 54.6 53.6 30.6 58.7 61.2 63.8
114.2 109.1 107.1 61.2 117.3 122.4 127.5
23.5 22.5 22.1 12.6 24.2 25.2 26.3
63.8 61.0 59.9 34.2 65.6 68.4 71.3
75.0 71.7 70.4 40.2 77.1 80.4 83.8
140.0 133.8 131.3 75.0 143.8 150.0 156.3
33.6 32.1 31.5 18.0 34.5 36.0 37.5
121.0 115.6 113.4 64.8 124.2 129.6 135.0
138.9 132.7 130.2 74.4 142.6 148.8 155.0
Materiales ENERO FEBRERO MARZO ABRIL
CLUB COLOMBIA 300 cc 170,100.0 187,110.0 127,575.0 136,080.0
CLUB COLOMBIA NR 300 cc 38,100.0 41,910.0 28,575.0 30,480.0
CLUB COLOMBIA 350 cc 70,200.0 77,220.0 52,650.0 56,160.0
COSTEÑA 300 cc 375,000.0 412,500.0 281,250.0 300,000.0
COSTEÑA NR 300 cc 26,250.0 28,875.0 19,687.5 21,000.0
COSTEÑA 350 cc 1,240.0 1,361.0 937.5 998.0
POKER 300 cc 519,600.0 571,560.0 389,700.0 415,680.0
POKER NR 300 cc 79,500.0 87,450.0 59,625.0 63,600.0
POKER 350 cc 56,100.0 61,710.0 42,075.0 1,526.0
AGUILA 300 cc 687,600.0 756,360.0 515,700.0 550,080.0
AGUILA NR 300 cc 164,400.0 180,840.0 123,300.0 131,520.0
AGUILA 350 cc 108,600.0 119,460.0 81,450.0 86,880.0
PILSEN 300 cc 577,500.0 635,250.0 433,125.0 462,000.0
PILSEN NR 300 cc 135,900.0 149,490.0 101,925.0 108,720.0
PILSEN 350 cc 2,160.0 2,373.0 1,627.5 1,734.0
CLARITA 175 cc 179,025.0 196,927.5 134,268.8 143,220.0
COSTEÑITA 175 cc 428,750.0 471,625.0 321,562.5 343,000.0
CLUB LATA 10 Oz 38,400.0 42,240.0 28,800.0 30,720.0
CLUB LATA 8 Oz 830.0 913.0 622.5 664.0
AGUILA 8 Oz 11,250.0 12,375.0 8,437.5 9,000.0
AGUILA 10 Oz 313,500.0 344,850.0 235,125.0 250,800.0
COSTEÑA 10 Oz 249,000.0 273,900.0 186,750.0 199,200.0
PILSEN 10 Oz 285,600.0 314,160.0 214,200.0 228,480.0
PILSEN 8 Oz 4,650.0 5,115.0 3,487.5 3,720.0
POKER 10 Oz 263,400.0 289,740.0 197,550.0 210,720.0
CLUB BARRIL 30 l (Dec) 153.0 168.3 114.8 122.4
CLUB BARRIL 50 l (Dec) 306.0 336.6 229.5 244.8
POKER BARRIL 30 l (Dec) 63.0 69.3 47.3 50.4
POKER BARRIL 50 l (Dec) 171.0 188.1 128.3 136.8
AGUILA BARRIL 30 l (Dec) 201.0 221.1 150.8 160.8
AGUILA BARRIL 50 l (Dec) 375.0 412.5 281.3 300.0
PILSEN BARRIL 30 l (Dec) 90.0 99.0 67.5 72.0
PILSEN BARRIL 50 l (Dec) 324.0 356.4 243.0 259.2
COSTEÑA BARRIL 50 l (Dec) 372.0 409.2 279.0 297.6
MAYO JUNIO JULIO AGOSTOSEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE
173,502.0 190,512.0 182,007.0 178,605.0 102,060.0 195,615.0 204,120.0 212,625.0
38,862.0 42,672.0 40,767.0 40,005.0 22,860.0 43,815.0 45,720.0 47,625.0
71,604.0 78,624.0 75,114.0 73,710.0 42,120.0 80,730.0 84,240.0 87,750.0
382,500.0 420,000.0 401,250.0 393,750.0 225,000.0 431,250.0 450,000.0 468,750.0
26,775.0 29,400.0 28,087.5 27,562.5 15,750.0 30,187.5 31,500.0 32,812.5
1,264.2 1,385.2 1,324.7 1,300.5 756.0 1,421.5 1,482.0 1,542.5
529,992.0 581,952.0 555,972.0 545,580.0 311,760.0 597,540.0 623,520.0 649,500.0
81,090.0 89,040.0 85,065.0 83,475.0 47,700.0 91,425.0 95,400.0 99,375.0
1,937.4 2,124.4 2,030.9 1,993.5 1,152.0 2,180.5 2,274.0 2,367.5
701,352.0 770,112.0 735,732.0 721,980.0 412,560.0 790,740.0 825,120.0 859,500.0
167,688.0 184,128.0 175,908.0 172,620.0 98,640.0 189,060.0 197,280.0 205,500.0
110,772.0 121,632.0 116,202.0 114,030.0 65,160.0 124,890.0 130,320.0 135,750.0
589,050.0 646,800.0 617,925.0 606,375.0 346,500.0 664,125.0 693,000.0 721,875.0
138,618.0 152,208.0 145,413.0 142,695.0 81,540.0 156,285.0 163,080.0 169,875.0
2,202.6 2,415.6 2,309.1 2,266.5 1,308.0 2,479.5 2,586.0 2,692.5
182,605.5 200,508.0 191,556.8 187,976.3 107,415.0 205,878.8 214,830.0 223,781.3
437,325.0 480,200.0 458,762.5 450,187.5 257,250.0 493,062.5 514,500.0 535,937.5
39,168.0 43,008.0 41,088.0 40,320.0 23,040.0 44,160.0 46,080.0 48,000.0
846.6 929.6 888.1 871.5 498.0 954.5 996.0 1,037.5
11,475.0 12,600.0 12,037.5 11,812.5 6,750.0 12,937.5 13,500.0 14,062.5
319,770.0 351,120.0 335,445.0 329,175.0 188,100.0 360,525.0 376,200.0 391,875.0
253,980.0 278,880.0 266,430.0 261,450.0 149,400.0 286,350.0 298,800.0 311,250.0
291,312.0 319,872.0 305,592.0 299,880.0 171,360.0 328,440.0 342,720.0 357,000.0
4,743.0 5,208.0 4,975.5 4,882.5 2,790.0 5,347.5 5,580.0 5,812.5
268,668.0 295,008.0 281,838.0 276,570.0 158,040.0 302,910.0 316,080.0 329,250.0
156.1 171.4 163.7 160.7 91.8 176.0 183.6 191.3
312.1 342.7 327.4 321.3 183.6 351.9 367.2 382.5
64.3 70.6 67.4 66.2 37.8 72.5 75.6 78.8
174.4 191.5 183.0 179.6 102.6 196.7 205.2 213.8
205.0 225.1 215.1 211.1 120.6 231.2 241.2 251.3
382.5 420.0 401.3 393.8 225.0 431.3 450.0 468.8
91.8 100.8 96.3 94.5 54.0 103.5 108.0 112.5
330.5 362.9 346.7 340.2 194.4 372.6 388.8 405.0
379.4 416.6 398.0 390.6 223.2 427.8 446.4 465.0
CIEMBRE
s
0.2
Meses AT FT ERROR /ERROR/ ERROR 2 /ERROR/ / AT
1 313500 316373.75 -2873.75 2873.75 8258439.0625 0.00916666667
2 344850 315799.00 29051 29051 843960601 0.08424242424
3 235125 321609.20 -86484.2 86484.2 7479516849.64 0.36782222222
4 250800 304312.36 -53512.36 53512.36 2863572672.77 0.21336666667
5 319770 293609.89 26160.112 26160.112 684351459.853 0.08180915033
6 351120 298841.91 52278.0896 52278.0896 2732998652.23 0.14888952381
7 335445 309297.53 26147.4717 26147.4717 683690275.256 0.07794861059
8 329175 314527.02 14647.9773 14647.9773 214563240.27 0.04449905778
9 188100 317456.62 -129356.618 129356.618 16733134652.7 0.68770131911
10 360525 291585.29 68939.7055 68939.7055 4752682994.45 0.19122031898
11 376200 305373.24 70826.7644 70826.7644 5016430555.39 0.18826891122
12 391875 319538.59 72336.4115 72336.4115 5232556431.61 0.18459052382
88160.6039 88160.6039 7772292083.47 2.27952539543

N 12
ECM
MAD
PEMA
PME

0.8
Meses AT FT ERROR /ERROR/ ERROR 2 /ERROR/ / AT
1 313500 316373.75 -2873.75 2873.75 8258439.0625 0.00916666667
2 344850 314074.75 30775.25 30775.25 947116012.563 0.08924242424
3 235125 338694.95 -103569.95 103569.95 10726734543 0.44048888889
4 250800 255838.99 -5038.99 5038.99 25391420.2201 0.02009166667
5 319770 251807.798 67962.202 67962.202 4618860900.69 0.21253464052
6 351120 306177.56 44942.4404 44942.4404 2019822949.11 0.12799738095
7 335445 342131.512 -6686.51192 6686.51192 44709441.6563 0.01993325857
8 329175 336782.302 -7607.30238 7607.30238 57871049.5616 0.02311020698
9 188100 330696.46 -142596.46 142596.46 20333750540.5 0.75808857244
10 360525 216619.292 143905.708 143905.708 20708852767.5 0.39915597505
11 376200 331743.858 44456.1416 44456.1416 1976348524.26 0.11817156188
12 391875 367308.772 24566.2283 24566.2283 603499573.683 0.06268893988
88235.0054 88235.0054 7785416181.64 2.28067018275

N 12
ECM
MAD
PEMA
PME
0.5
ERROR /AT Meses AT FT ERROR /ERROR/ ERROR 2
-0.00916667 1 313500 316373.75 -2873.75 2873.75 8258439.06
0.08424242 2 344850 314936.875 29913.125 29913.125 894795047
-0.36782222 3 235125 329893.438 -94768.4375 94768.4375 8981056746
-0.21336667 4 250800 282509.219 -31709.2188 31709.2188 1005474554
0.08180915 5 319770 266654.609 53115.3906 53115.3906 2821244721
0.14888952 6 351120 293212.305 57907.6953 57907.6953 3353301176
0.07794861 7 335445 322166.152 13278.8477 13278.8477 176327795
0.04449906 8 329175 328805.576 369.423828 369.423828 136473.965
-0.68770132 9 188100 328990.288 -140890.288 140890.288 1.985E+10
0.19122032 10 360525 258545.144 101979.856 101979.856 1.04E+10
0.18826891 11 376200 309535.072 66664.928 66664.928 4444212622
0.18459052 12 391875 342867.536 49007.464 49007.464 2401731527
-0.27658835 104868.786 104868.786 1.0997E+10

N 12
ECM
MAD
PEMA
PME

ERROR /AT
-0.00916667
0.08924242
-0.44048889
-0.02009167
0.21253464
0.12799738
-0.01993326
-0.02311021
-0.75808857
0.39915598
0.11817156
0.06268894
-0.26108834
/ERROR/ / ATERROR /AT
0.00916667 -0.00916667
0.08674242 0.08674242
0.40305556 -0.40305556
0.12643229 -0.12643229
0.16610498 0.16610498
0.16492281 0.16492281
0.03958577 0.03958577
0.00112227 0.00112227
0.74901801 -0.74901801
0.28286487 0.28286487
0.17720608 0.17720608
0.12505892 0.12505892
2.33128065 -0.24406441
MARCA ENERO FEBRERO MARZO ABRIL MAYO JUNIO
AGUILA 10 Oz 313500 344850 235125 250800 319770 351120
PMS 2 329175 289988 242963 285285
PMS3 297825 276925 268565
PMS4 286069 287636
PMS5 292809
PMP2 335445 268043 246098 299079
PMP3 283718 264908 282150
PMP4 271178 284658
PMP5 287041
SE 0,2 316374 315799 321609 304312 293610 298842
SE 0,5 316374 314937 329893 282509 266655 293212
SE 0,8 316374 314075 338695 255839 251808 306178
JULIO AGOSTO SEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE Enero
335445 329175 188100 360525 376200 391875
335445 343283 332310 258638 274313 368363 384038
307230 335445 338580 284240 292600 308275 376200
289204 314284 333878 300960 303311 313500 329175
300333 298452 317262 304722 312873 317889 329175
341715 340148 331056 230423 308798 371498 387173
321651 337013 335445 259892 302528 333878 380903
310052 328548 334505 276194 300020 329175 360525
307073 318516 328548 286069 303782 325382 350493
309298 314527 317457 291585 305373 319539
322166 328806 328990 258545 309535 342868
342132 336782 330696 216619 331744 367309
MARCA ENERO FEBRERO MARZO ABRIL MAYO
AGUILA 10 Oz 313500 344850 235125 250800 319770
PMS 2 329175 289988 242963
PMS3 297825 276925
PMS4 286069
PMS5
PMP2 335445 268043 246098
PMP3 283718 264908
PMP4 271178
PMP5
SE 0,2 316374 315799 321609 304312 293610
SE 0,5 316374 314937 329893 282509 266655
SE 0,8 316374 314075 338695 255839 251808

MARCA ENERO FEBRERO MARZO ABRIL MAYO


AGUILA 10 Oz 313500 344850 235125 250800 319770
AGUILA 300 cc 687600 756360 515700 550080 701352
AGUILA 350 cc 126700 139370 95025 101360 129234
AGUILA 8 Oz 281250 309375 210937.5 225000 286875
AGUILA BARRIL 30 l (Dec) 201 221.1 150.75 160.8 205.02
AGUILA BARRIL 50 l (Dec) 625 687.5 468.75 500 637.5
AGUILA NR 300 cc 164400 180840 123300 131520 167688
CLARITA 175 cc 179025 196927.5 134268.75 143220 182605.5
CLUB BARRIL 30 l (Dec) 153 168.3 114.75 122.4 156.06
CLUB BARRIL 50 l (Dec) 510 561 382.5 408 520.2
CLUB COLOMBIA 300 cc 170100 187110 127575 136080 173502
CLUB COLOMBIA 350 cc 81900 90090 61425 65520 83538
CLUB COLOMBIA NR 300 cc 38100 41910 28575 30480 38862
CLUB LATA 10 Oz 38400 42240 28800 30720 39168
CLUB LATA 8 Oz 20750 22825 15562.5 16600 21165
COSTEÑA 10 Oz 249000 273900 186750 199200 253980
COSTEÑA 300 cc 375000 412500 281250 300000 382500
COSTEÑA 350 cc 42350 46585 31762.5 33880 43197
COSTEÑA BARRIL 50 l (Dec) 620 682 465 496 632.4
COSTEÑA NR 300 cc 26250 28875 19687.5 21000 26775
COSTEÑITA 175 cc 428750 471625 321562.5 343000 437325
PILSEN 10 Oz 285600 314160 214200 228480 291312
PILSEN 300 cc 577500 635250 433125 462000 589050
PILSEN 350 cc 74550 82005 55912.5 59640 76041
PILSEN 8 Oz 116250 127875 87187.5 93000 118575
PILSEN BARRIL 30 l (Dec) 90 99 67.5 72 91.8
PILSEN BARRIL 50 l (Dec) 540 594 405 432 550.8
PILSEN NR 300 cc 135900 149490 101925 108720 138618
POKER 10 Oz 263400.00 289740.00 197550.00 210720.00 268668.00
POKER 300 cc 519600.00 571560.00 389700.00 415680.00 529992.00
POKER 350 cc 65450.00 71995.00 49087.50 52360.00 66759.00
POKER BARRIL 30 l (Dec) 63.00 69.30 47.25 50.40 64.26
POKER BARRIL 50 l (Dec) 285.00 313.50 213.75 228.00 290.70
POKER NR 300 cc 79500.00 87450.00 59625.00 63600.00 81090.00
JUNIO JULIO AGOSTO SEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE Enero
351120 335445 329175 188100 360525 376200 391875
285285 335445 343283 332310 258638 274313 368363 384038
268565 307230 335445 338580 284240 292600 308275 376200
287636 289204 314284 333878 300960 303311 313500 329175
292809 300333 298452 317262 304722 312873 317889 329175
299079 341715 340148 331056 230423 308798 371498 387173
282150 321651 337013 335445 259892 302528 333878 380903
284658 310052 328548 334505 276194 300020 329175 360525
287041 307073 318516 328548 286069 303782 325382 350493
298842 309298 314527 317457 291585 305373 319539
293212 322166 328806 328990 258545 309535 342868
306178 342132 336782 330696 216619 331744 367309

JUNIO JULIO AGOSTO SEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE


351120 335445 329175 188100 360525 376200 391875
770112 735732 721980 412560 790740 825120 859500
141904 135569 133035 76020 145705 152040 158375
315000 300937.5 295312.5 168750 323437.5 337500 351562.5
225.12 215.07 211.05 120.6 231.15 241.2 251.25
700 668.75 656.25 375 718.75 750 781.25
184128 175908 172620 98640 189060 197280 205500
200508 191556.75 187976.25 107415 205878.75 214830 223781.25
171.36 163.71 160.65 91.8 175.95 183.6 191.25
571.2 545.7 535.5 306 586.5 612 637.5
190512 182007 178605 102060 195615 204120 212625
91728 87633 85995 49140 94185 98280 102375
42672 40767 40005 22860 43815 45720 47625
43008 41088 40320 23040 44160 46080 48000
23240 22202.5 21787.5 12450 23862.5 24900 25937.5
278880 266430 261450 149400 286350 298800 311250
420000 401250 393750 225000 431250 450000 468750
47432 45314.5 44467.5 25410 48702.5 50820 52937.5
694.4 663.4 651 372 713 744 775
29400 28087.5 27562.5 15750 30187.5 31500 32812.5
480200 458762.5 450187.5 257250 493062.5 514500 535937.5
319872 305592 299880 171360 328440 342720 357000
646800 617925 606375 346500 664125 693000 721875
83496 79768.5 78277.5 44730 85732.5 89460 93187.5
130200 124387.5 122062.5 69750 133687.5 139500 145312.5
100.8 96.3 94.5 54 103.5 108 112.5
604.8 577.8 567 324 621 648 675
152208 145413 142695 81540 156285 163080 169875
295008.00 281838.00 276570.00 158040.00 302910.00 316080.00 329250.00
581952.00 555972.00 545580.00 311760.00 597540.00 623520.00 649500.00
73304.00 70031.50 68722.50 39270.00 75267.50 78540.00 81812.50
70.56 67.41 66.15 37.80 72.45 75.60 78.75
319.20 304.95 299.25 171.00 327.75 342.00 356.25
89040.00 85065.00 83475.00 47700.00 91425.00 95400.00 99375.00

También podría gustarte