AGENCIA REGIONAL ADUANERA S.A.S.

INFORME CONSOLIDADO DE IMPORTACIONES

ELABORADO EN MAYO 31 DE 2016

Código TRANSPORTE BANDERA Vr Importación PORCENTAJE

A19 BUQUE PORTA CONTENEDOR 4 COSTA RICA 6,480,000 1%
A23 BUQUE DE TRANSBORDO RODADO 4 ALBANIA 7,890,000 17%
B32 BUQUE GRANELERO 4 COLOMBIA 7,888,000 7%
C44 BUQUE GRANELERO 10 U.S.A. 6,478,000 5%
D56 BUQUE TANQUE 2 COSTA RICA 4,650,000 10%
E45 BUQUE TANQUE 8 FRANCIA 6,530,114 9%
E56 BUQUE DE CARGA GENERAL3 PANAMA 9,800,000 15%
F55 BUQUE GRANELERO 7 GRECIA 4,780,950 6%
F67 BUQUE TANQUE 3 COLOMBIA 7,890,000 10%
G71 BUQUE TANQUE 9 U.S.A. 1,460,000 8%
G78 BUQUE TANQUE 4 ALEMANIA 4,890,000 10%
H98 BUQUE TANQUE 5 PANAMA 4,650,000 9%
J34 BUQUE TANQUE 10 ECUADOR 1,450,000 8%
J64 BUQUE TANQUE 6 GRECIA 11,230,560 9%
L79 BUQUE PORTA CONTENEDOR 2 ALBANIA 2,466,000 3%
L96 BUQUE TANQUE 7 ESPAÑA 4,890,000 9%
M70 BUQUE GRANELERO 2 UCRANIA 4,890,000 7%
M99 BUQUE GRANELERO 9 FRANCIA 2,350,000 5%
N83 BUQUE GRANELERO 3 COSTA RICA 10,450,000 7%
O44 BUQUE PORTA CONTENEDOR 3 UCRANIA 5,489,000 3%
P11 BUQUE DE TRANSBORDO RODADO 3 ECUADOR 7,444,000 18%
Q10 BUQUE PORTA CONTENEDOR 5 ALEMANIA 4,350,000 1%
Q24 BUQUE DE CARGA GENERAL1 COLOMBIA 5,000,000 20%
R67 BUQUE DE CARGA GENERAL4 PORTUGAL 8,790,000 15%
S14 BUQUE PORTA CONTENEDOR 6 COLOMBIA 7,400,000 1%
S33 BUQUE PORTA CONTENEDOR 1 ECUADOR 7,420,000 3%
S45 BUQUE TANQUE 1 UCRANIA 5,600,000 18%
T78 BUQUE DE CARGA GENERAL5 ESPAÑA 5,640,800 20%
UI9 BUQUE DE TRANSBORDO RODADO 2 U.S.A. 8,650,000 17%
V43 BUQUE GRANELERO 5 ALEMANIA 6,480,000 6%
V99 BUQUE GRANELERO 1 ALBANIA 4,560,000 8%
W35 BUQUE DE CARGA GENERAL2 ALEMANIA 2,500,000 20%
X54 BUQUE GRANELERO 6 PANAMA 11,230,000 6%
Y89 BUQUE DE TRANSBORDO RODADO 1 FRANCIA 5,645,000 15%
Z21 BUQUE GRANELERO 8 ESPAÑA 8,555,460 5%
 3.0% FECHA HOY

PRODUCTO FECHA LLEGADA PROVEEDOR NUEVO IMPUESTO MARCA DIA DE LLEGADA

CONTAINER FEU 6/12/2016 C1 194,400 CARRIER Sunday
VEHICULO GRAL 6/7/2016 D1 236,700 THERMOKING Tuesday
CEREALES 6/12/2016 C1 236,640 DAIKIN Sunday
CEREALES 6/7/2016 D1 194,340 STAR COOL Tuesday
QUIMICOS 6/6/2016 A1 139,500 MAERSK Monday
QUIMICOS 6/9/2016 B1 195,903 CARRIER Thursday
VERDURAS 6/12/2016 C1 294,000 THERMOKING Sunday
MINERALES 6/10/2016 A1 143,429 DAIKIN Friday
GAS LICUADO 6/4/2016 B1 236,700 STAR COOL Saturday
GAS LICUADO 6/8/2016 C1 43,800 MAERSK Wednesday
VERDURAS 6/12/2016 C1 146,700 CARRIER Sunday
QUIMICOS 6/2/2016 D1 139,500 THERMOKING Thursday
QUIMICOS 6/7/2016 D1 43,500 DAIKIN Tuesday
GAS LICUADO 6/1/2016 E1 336,917 STAR COOL Wednesday
CONTAINER FEU 6/6/2016 A1 73,980 MAERSK Monday
VERDURAS 6/10/2016 A1 146,700 CARRIER Friday
CEREALES 6/6/2016 A1 146,700 THERMOKING Monday
MINERALES 6/8/2016 C1 70,500 DAIKIN Wednesday
MINERALES 6/4/2016 B1 313,500 STAR COOL Saturday
CONTAINER TEU 6/4/2016 B1 164,670 MAERSK Saturday
TRACTORES 6/8/2016 C1 223,320 CARRIER Wednesday
CONTAINER TEU 6/2/2016 D1 130,500 THERMOKING Thursday
ACEITES 6/6/2016 A1 150,000 DAIKIN Monday
LACTEOS 6/2/2016 D1 263,700 STAR COOL Thursday
CONTAINER FEU 6/1/2016 E1 222,000 MAERSK Wednesday
CONTAINER TEU 6/6/2016 E1 222,600 CARRIER Monday
PETROLEO 6/6/2016 E1 168,000 THERMOKING Monday
CARNES 6/1/2016 E1 169,224 DAIKIN Wednesday
CAMIONES 6/9/2016 B1 259,500 STAR COOL Thursday
MINERALES 6/2/2016 D1 194,400 MAERSK Thursday
MINERALES 6/6/2016 E1 136,800 CARRIER Monday
LICORES 6/4/2016 B1 75,000 THERMOKING Saturday
CEREALES 6/1/2016 E1 336,900 DAIKIN Wednesday
AUTOMOVILES 6/10/2016 A1 169,350 STAR COOL Friday
CEREALES 6/9/2016 B1 256,664 MAERSK Thursday
 11/2/2019

FECHA QUE ZARPA DIAS QUE TARDA CARGA TONELADAS

4/16/2016 57 25
3/23/2016 76 60
4/6/2016 67 64
4/12/2016 56 33
3/25/2016 73 75
3/31/2016 70 67
3/17/2016 87 75
4/9/2016 62 43
3/26/2016 70 55
4/1/2016 68 110
3/27/2016 77 56
3/28/2016 66 79
4/2/2016 66 82
3/29/2016 64 96
4/14/2016 53 97
3/30/2016 72 35
4/4/2016 63 91
4/11/2016 58 74
4/5/2016 60 78
4/15/2016 50 88
3/22/2016 78 99
4/17/2016 46 100
3/15/2016 83 50
3/18/2016 76 79
4/18/2016 44 71
4/13/2016 54 54
3/24/2016 74 80
3/19/2016 74 80
3/21/2016 80 95
4/7/2016 56 53
4/3/2016 64 89
3/16/2016 80 65
4/8/2016 54 115
3/20/2016 82 85
4/10/2016 60 91
AGENCIA REGIONAL ADUANERA S.A.S.
INFORME CONSOLIDADO DE IMPORTACIONES
ELABORADO EN MAYO 31 DE 2016

Código TRANSPORTE BANDERA Vr Importación PORCENTAJE

A19 BUQUE PORTA CONTENEDOR 4 COSTA RICA 6,480,000 1%
A23 BUQUE DE TRANSBORDO RODADO 4 ALBANIA 7,890,000 17%
B32 BUQUE GRANELERO 4 COLOMBIA 7,888,000 7%
C44 BUQUE GRANELERO 10 U.S.A. 6,478,000 5%
D56 BUQUE TANQUE 2 COSTA RICA 4,650,000 10%
E45 BUQUE TANQUE 8 FRANCIA 6,530,114 9%
E56 BUQUE DE CARGA GENERAL3 PANAMA 9,800,000 15%
F55 BUQUE GRANELERO 7 GRECIA 4,780,950 6%
F67 BUQUE TANQUE 3 COLOMBIA 7,890,000 10%
G71 BUQUE TANQUE 9 U.S.A. 1,460,000 8%
G78 BUQUE TANQUE 4 ALEMANIA 4,890,000 10%
H98 BUQUE TANQUE 5 PANAMA 4,650,000 9%
J34 BUQUE TANQUE 10 ECUADOR 1,450,000 8%
J64 BUQUE TANQUE 6 GRECIA 11,230,560 9%
L79 BUQUE PORTA CONTENEDOR 2 ALBANIA 2,466,000 3%
L96 BUQUE TANQUE 7 ESPAÑA 4,890,000 9%
M70 BUQUE GRANELERO 2 UCRANIA 4,890,000 7%
M99 BUQUE GRANELERO 9 FRANCIA 2,350,000 5%
N83 BUQUE GRANELERO 3 COSTA RICA 10,450,000 7%
O44 BUQUE PORTA CONTENEDOR 3 UCRANIA 5,489,000 3%
P11 BUQUE DE TRANSBORDO RODADO 3 ECUADOR 7,444,000 18%
Q10 BUQUE PORTA CONTENEDOR 5 ALEMANIA 4,350,000 1%
Q24 BUQUE DE CARGA GENERAL1 COLOMBIA 5,000,000 20%
R67 BUQUE DE CARGA GENERAL4 PORTUGAL 8,790,000 15%
S14 BUQUE PORTA CONTENEDOR 6 COLOMBIA 7,400,000 1%
S33 BUQUE PORTA CONTENEDOR 1 ECUADOR 7,420,000 3%
S45 BUQUE TANQUE 1 UCRANIA 5,600,000 18%
T78 BUQUE DE CARGA GENERAL5 ESPAÑA 5,640,800 20%
UI9 BUQUE DE TRANSBORDO RODADO 2 U.S.A. 8,650,000 17%
V43 BUQUE GRANELERO 5 ALEMANIA 6,480,000 6%
V99 BUQUE GRANELERO 1 ALBANIA 4,560,000 8%
W35 BUQUE DE CARGA GENERAL2 ALEMANIA 2,500,000 20%
X54 BUQUE GRANELERO 6 PANAMA 11,230,000 6%
Y89 BUQUE DE TRANSBORDO RODADO 1 FRANCIA 5,645,000 15%
Z21 BUQUE GRANELERO 8 ESPAÑA 8,555,460 5%

COSTA RICA 21,580,000

ALBANIA 14,916,000
COLOMBIA 28,178,000
U.S.A. 16,588,000
FRANCIA 14,525,114
PANAMA 25,680,000
GRECIA 16,011,510 =[Link]($J$7:$J$41
ALEMANIA 18,220,000
ECUADOR 16,314,000
ESPAÑA 19,086,260
UCRANIA 15,979,000
PORTUGAL 8,790,000
=[Link]($C$7:$C$41;C43;$D$7:$D$41)
 cuente cuantas veces aparece cada porducto

cuente cuantas veces aparece cada dia de llegada

domingo 4
martes 0
lunes 0
jueves 0
viernes 0
sábado 0
miércoles 0
=[Link]($K$7:$K$41;C72)
 3.0% FECHA HOY

PRODUCTO FECHA LLEGADA PROVEEDOR NUEVO IMPUESTO MARCA DIA DE LLEGADA

CONTAINER FEU 6/12/2016 C1 194,400 CARRIER Sunday
VEHICULO GRAL 6/7/2016 D1 236,700 THERMOKING Tuesday
CEREALES 6/12/2016 C1 236,640 DAIKIN Sunday
CEREALES 6/7/2016 D1 194,340 STAR COOL Tuesday
QUIMICOS 6/6/2016 A1 139,500 MAERSK Monday
QUIMICOS 6/9/2016 B1 195,903 CARRIER Thursday
VERDURAS 6/12/2016 C1 294,000 THERMOKING Sunday
MINERALES 6/10/2016 A1 143,429 DAIKIN Friday
GAS LICUADO 6/4/2016 B1 236,700 STAR COOL Saturday
GAS LICUADO 6/8/2016 C1 43,800 MAERSK Wednesday
VERDURAS 6/12/2016 C1 146,700 CARRIER Sunday
QUIMICOS 6/2/2016 D1 139,500 THERMOKING Thursday
QUIMICOS 6/7/2016 D1 43,500 DAIKIN Tuesday
GAS LICUADO 6/1/2016 E1 336,917 STAR COOL Wednesday
CONTAINER FEU 6/6/2016 A1 73,980 MAERSK Monday
VERDURAS 6/10/2016 A1 146,700 CARRIER Friday
CEREALES 6/6/2016 A1 146,700 THERMOKING Monday
MINERALES 6/8/2016 C1 70,500 DAIKIN Wednesday
MINERALES 6/4/2016 B1 313,500 STAR COOL Saturday
CONTAINER TEU 6/4/2016 B1 164,670 MAERSK Saturday
TRACTORES 6/8/2016 C1 223,320 CARRIER Wednesday
CONTAINER TEU 6/2/2016 D1 130,500 THERMOKING Thursday
ACEITES 6/6/2016 A1 150,000 DAIKIN Monday
LACTEOS 6/2/2016 D1 263,700 STAR COOL Thursday
CONTAINER FEU 6/1/2016 E1 222,000 MAERSK Wednesday
CONTAINER TEU 6/6/2016 E1 222,600 CARRIER Monday
PETROLEO 6/6/2016 E1 168,000 THERMOKING Monday
CARNES 6/1/2016 E1 169,224 DAIKIN Wednesday
CAMIONES 6/9/2016 B1 259,500 STAR COOL Thursday
MINERALES 6/2/2016 D1 194,400 MAERSK Thursday
MINERALES 6/6/2016 E1 136,800 CARRIER Monday
LICORES 6/4/2016 B1 75,000 THERMOKING Saturday
CEREALES 6/1/2016 E1 336,900 DAIKIN Wednesday
AUTOMOVILES 6/10/2016 A1 169,350 STAR COOL Friday
CEREALES 6/9/2016 B1 256,664 MAERSK Thursday
35
CARRIER 58%
THERMOKING 87%
DAIKIN 72%
STAR COOL 78%
MAERSK 36%

[Link]($J$7:$J$41;F43;$E$7:$E$40)
sume los% de cada marca

productos
CONTAINER FEU 3
VEHICULO GRAL 1
CEREALES 5
 QUIMICOS 4
VERDURAS 3
MINERALES 5
GAS LICUADO 3
CONTAINER TEU 3
TRACTORES 1
ACEITES 1
LACTEOS 1
PETROLEO 1
CARNES 1
CAMIONES 1
LICORES 1
AUTOMOVILES 1
35
 11/2/2019

FECHA QUE ZARPA DIAS QUE TARDA CARGA TONELADAS

4/16/2016 57 25
3/23/2016 76 60
4/6/2016 67 64
4/12/2016 56 33
3/25/2016 73 75
3/31/2016 70 67
3/17/2016 87 75
4/9/2016 62 43
3/26/2016 70 55
4/1/2016 68 110
3/27/2016 77 56
3/28/2016 66 79
4/2/2016 66 82
3/29/2016 64 96
4/14/2016 53 97
3/30/2016 72 35
4/4/2016 63 91
4/11/2016 58 74
4/5/2016 60 78
4/15/2016 50 88
3/22/2016 78 99
4/17/2016 46 100
3/15/2016 83 50
3/18/2016 76 79
4/18/2016 44 71
4/13/2016 54 54
3/24/2016 74 80
3/19/2016 74 80
3/21/2016 80 95
4/7/2016 56 53
4/3/2016 64 89
3/16/2016 80 65
4/8/2016 54 115
3/20/2016 82 85
4/10/2016 60 91
CIFRA1 RPTA VALOR 1 VALOR 2 RESULTADO CANTIDAD1
8 0 0 0 0 0
5 0 0 1 0 6
9 0 0 0 1 0 2
-1 0
0 1 0
CANTIDAD2 RPTA
7
5
8