Untitled
Untitled
Untitled
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
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
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
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
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
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