CONSUMOS VALORIZADOS EXPLOSIVOS AL
9/1/2015
SOFYA
DESCRIPCION
005011
MECHA DE SEGURIDAD
FULMINANTE COMUN # 8
BOOSTER PENTOLITA 1 LIBRA
CORDON DETONANTE 5P
RETARDO BIDIRECCIONAL 25ms
RETARDO BIDIRECCIONAL 35ms
RETARDO BIDIRECCIONAL 42ms
DETONADOR NO ELECTRICO EXEL N 24 X 8MTS 800MS
DETONADOR NO ELECTRICO EXEL N 24
NITRATO DE AMONIO
EMULSION MATRIZ
016811
RETARDO CTD 100 MS
016812
RETARDO CTD 0 MS
019004
CONECT UNIDIR CONECTADET 7.3 65 MS
019609
RETARDO CTD 109 MS
019001
RETARDO BIDIRECCIONAL 75ms
016814
DETONADOR NO ELECTRICO EXEL DUAL 800X17X15. MTS
004980
004981
004978
004971
004987
004988
009039
009489
009010
005026
U.M.
COSTO
UNITARIO $
CONSUMO
DEL MES
TOTAL
$
MTS
UND
PZA
MTS
PZA
PZA
PZA
PZA
PZA
KGS
KGS
PZA
PZA
PZA
PZA
PZA
PZA
0.144
0.130
4.050
0.189
2.479
2.479
2.479
2.045
1.785
0.580
0.580
2.859
2.859
2.701
2.665
2.808
5.765
2,000.00
Err:509
1,101.00
0.00
0.00
0.00
0.00
0.00
19.00
79,300.00
0.00
Err:509
39.00
19.00
30.00
Err:509
Err:509
288.00
Err:509
4,459.05
0.00
0.00
0.00
0.00
0.00
33.91
45,994.00
0.00
Err:509
111.50
51.32
79.95
Err:509
Err:509
TOTAL $
Err:509
09/01/2015
CONTROL DE EXPLOSIVOS AGOSTO 2015. (INTERNO)
ALERTA
URGENTE
SOFYA
DESCRIPCION
2014
Cons.Prom
COSTO
Actual
SALDO. DEL MES STOCK TOTAL
INGRESOS
413,000
CONSUMOS DIARIO AGOSTO 2015
U.M.
UNITARIO $
1
270,800.0
0.0
4,944.0
21,640
DETONADOR ELECTRICO FANEL DUAL 800/17MS X14MTS
002822
DETONADOR ELECTRICO FANEL DUAL 800/17 X15MTS
4,375
PZA
64
000000
DETONADOR ELECTRICO DUAL 800/25MS X11MTS
1,000
5.765
2,959.0
2,639.0
PZA
272
43
000340
BOOSTER PENTOLITA 1 LIBRA
4,375
4.050
10,345.0
9,244.0
PZA
332
35
000000
MECHA EMSAMBLADA X 03 METROS
20
0.189
2.0
0.0
UND
004591
CONECT UNIDIR CONECTADET 7.3 65 MS X 9 MTS (RETARDO)
40
002825
CONECT UNIDIR CONECTADET 7.3 42 MS X 9 MTS (RETARDO)
57
004590
CONECT UNIDIR CONECTADET 7.3 35 MS X 9 MTS (RETARDO)
100
002824
CONECT UNIDIR CONECTADET 9.3 25 MS X 9 MTS (RETARDO)
227
2.665
002823
CONECT UNIDIR CONECTADET 7.3 0 MS X 9MTS (RETARDO)
2.701
KGS
KGS
PZA
000000
5,738.0
207,900
0
NITRATO DE AMONIO
EMULSION MATRIZ
DETONADOR ELECTRICO DUAL 17/800MS X15.2MTS (exsa)
10
142,200.0
0.0
0.0
003608
000343
000000
4,375
0.781
0.580
PZA
254.0
PZA
PZA
20
PZA
1,275.0
288.0
170
2.859
615.0
001165
LINEA SILENCIOSA RLLO X 500 MTS. C/U.
4,500
0.144
14,500.0
004499
LINEA SILENCIOSA RLLO X 100 MTS. C/U.
600
0.480
3,200.0
001161
FULMINANTE PARTIDOR , BALISTICO
24
0.001
80.0
002407
CORDON DETONANTE 5P
2,000
2.380
0.0
CONSUMO
9
10
11
12
dias
STOCK
13
CONSUMO
cubiertos
VALORIZADO $
43,000
13,700
79,300.00
0.00
0.00
0.00
0.0
20
#DIV/0!
0
0
433
297
794.00
4,944.0
35
0.00
320.00
2,639.0
82
1,844.80
302
1,101.00
9,244.0
66
4,459.05
PZA
134.0
126.0
960
432
270,800.0
0.0
0.0
61,945.98
0.00
0.00
0.00
0.00
2.0
1.00
133.0
103
0.00
19.00
235.0
128
51.32
20
53.00
73.0
23
0.00
18
30.00
258.0
35
79.95
0.00
PZA
15
10
39.00
576.0
105
111.50
MTS
500
500
500
500
2,000.00
12,500.0
86
288.00
MTS
100
300
100
100
600.00
2,600.0
134
76.0
UND
4.00
76.0
98
0.00
0.0
MTS
0.00
0.0
0.00
12,500.0
file:///var/www/apps/conversion/tmp/scratch_4/282503665.xlsx
RATIOS DE CONSUMO INSUMOS CRITI
CONSUMO AGENTES DE
50,000
45,000
43
40,000
35,000
KG
30,000
25,000
21,640
20,000
15,000
10,000
5,000
0
960
1
DIAS
NITRATO DE AMONIO
TOTAL NITRATO
TOTAL EMULSION
EMULSION
OS DE CONSUMO INSUMOS CRITICOS DE OPERACIN
ONSUMO AGENTES DE VOLADURA
43,000
13,700
960
6
TRATO DE AMONIO
DIAS
EMULSION MATRIZ
79,300.00 KG
0.00 KG
10
11
12
13
13
SIMULACION DESPACHOS NITRATO DE AMONIO Y EMULSION DICIEMBRE 2009
005026
NITRATO DE AMONIO
FECHA DE INGRESO
DOCUMENTO
207,900
NUMERO GUIA
CANTIDAD
UM
12/16/2009
GR
29,700.00
KG
12/16/2009
GR
29,700.00
KG
12/18/2009
GR
59,400.00
KG
12/21/2009
GR
59,400.00
KG
12/23/2009
GR
29,700.00
KG
12/28/2009
GR
59,400.00
KG
12/30/2009
GR
59,400.00
KG
GR
KG
TOTAL INGRESADO
005011
326,700.00
EMULSION MATRIZ
FECHA DE INGRESO
DOCUMENTO
KG
0
CANTIDAD
UM
12/16/2009
GR
047-0007802
NUMERO
21,220.00
KG
12/16/2009
GR
047-0007801
20,540.00
KG
12/18/2009
GR
40,000.00
KG
12/23/2009
GR
40,000.00
KG
12/28/2009
GR
40,000.00
KG
4/30/2010
GR
KG
TOTAL INGRESADO
161,760.00
KG
CUADRO DE RESUMEN INGRESOS DEL MES VALORIZADOS
CANTIDAD
UM
VALORIZADO
NITRATO
326,700.00
KG
$212,355.000
EMULSION
161,760.00
KG
$105,144.000
TOTAL $
EMULSION DICIEMBRE 2009
COSTO X KG
TOTAL POR DESPACHO
$0.650
$19,305.00
$0.650
$19,305.00
$0.650
$38,610.00
$0.650
$38,610.00
$0.650
$19,305.00
$0.650
$38,610.00
$0.650
$38,610.00
$0.650
TOTAL VALORIZADO
$0.00
$212,355.00
COSTO X KG
TOTAL POR DESPACHO
$0.650
$13,793.00
$0.650
$13,351.00
$0.650
$26,000.00
$0.650
$26,000.00
$0.650
$26,000.00
$0.650
TOTAL VALORIZADO
VALORIZADO
$212,355.000
$105,144.000
$317,499.000
$0.00
$105,144.00
005026
NITRATO DE AMONIO
FECHA DE INGRESO
DOCUMENTO
cantidad
NUMERO GUIA
Jumbos
X jumbo
8/2/2015
GUIA
016-0011115 OC 3344
27
1100
8/2/2015
GUIA
016-0011116 OC3344
27
1100
8/6/2015
GUIA
016-0011117 OC 3345
27
1100
8/6/2015
GUIA
016-0011118 OC 3345
27
1100
8/6/2015
GUIA
016-0011119 OC 3345
27
1100
8/8/2015
GUIA
016-00111120 OC 3345
27
1100
8/8/2015
GUIA
016-00111121 OC 3345
27
1100
TOTAL ORDEN COMPRA 3344-3345
GUIA
1100
GUIA
1100
GUIA
1100
TOTAL ORDEN COMPRA 3247
GUIA
1100
GUIA
1100
GUIA
1100
1100
1100
TOTAL ORDEN COMPRA 3212
1100
1100
1100
TOTAL ORDEN COMPRA 3212
1100
1100
TOTAL ORDEN COMPRA 2919
TOTAL ORDEN COMPRA 21629
TOTAL INGRESADO
RESUMEN DE INGRESO DE MATERIAL VALORIZA
ORDENES DE COMPRA X RECOGER
O/c
cantidad
TOTAL
207,900
CANTIDAD
INGRESO
UM
29,700.00
29,700
29,700
29,700
29,700
29,700
KG
$0.645
$19,156.50
RD-1111
KG
$0.645
$19,156.50
RD-1111
KG
$0.645
$19,156.50
RD-1111
KG
$0.645
$19,156.50
RD-1111
KG
$0.645
$19,156.50
RD-1111
148,500.00
KG
$0.645
95,783
29,700
29,700
0
0
0
KG
$0.645
$19,156.50
RD-511
KG
$0.645
$19,156.50
RD-511
KG
$0.645
$0.00
RD-511
KG
$0.645
$0.00
RD-511
KG
$0.645
$0.00
RD-511
KG
$0.645
38,313
KG
$0.645
$0.00
RD-1111
KG
$0.645
$0.00
RD-1111
KG
$0.645
$0.00
RD-1111
KG
$0.645
$0.00
KG
$0.645
$0.00
KG
$0.645
KG
$0.645
KG
$0.645
KG
$0.645
KG
$0.645
KG
$0.645
KG
$0.645
KG
$0.645
$0.00
KG
$0.645
$0.00
KG
$0.645
$0.00
KG
$0.645
$0.00
KG
$0.645
$0.00
KG
$0.645
$0.00
KG
$0.645
$0.00
KG
$0.645
$0.00
KG
$0.645
$0.00
29,700.00
29,700.00
29,700.00
29,700.00
148,500
29,700.00
29,700.00
0.00
0.00
0.00
59,400
0
0
0
0
0
0.00
0.00
0.00
0.00
0.00
0
0
0
0
0.00
0.00
0.00
0
0
0
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0
0
0
0
0
0
0
COSTO X KG
TOTAL POR DESPACHO
OBS.
0
207,900.00
KG
TOTAL VALORIZADO
#REF!
SO DE MATERIAL VALORIZADO A MINA 2015
JUMBOS
RECIBIDO
PRECIO UNIT.
TOTAL COSTO S/IGV
TOTAL COSTO C/IGV
CODIGO
DESCRIPCION
2014
UNIDAD
SALDO
MEDIDA
Actual
003608
NITRATO DE AMONIO
KG.
85,000
000343
EMULSION MATRIZ
KG.
000000
DETONADOR NO ELECTRICO DUAL 17/800MS X15.2MTS
PZA
4,550
000000
DETONADOR ELECTRICO FANEL DUAL 800/17MS X14MTS
PZA
952
002822
DETONADOR ELECTRICO FANEL DUAL 800/17 X15MTS
PZA
2,658
000000
DETONADOR ELECTRICO DUAL 800/25MS X11MTS
PZA
5,126
000340
BOOSTER PENTOLITA 1 LIBRA
PZA
10,725
003401
CORDON DETONANTE 5P
PZA
002825
CONECT UNIDIR CONECTADET 7.3 42 MS (RETARDO)
PZA
002824
CONECT UNIDIR CONECTADET 9.3 25 MS (RETARDO)
PZA
002823
CONECT UNIDIR CONECTADET 7.3 0 MS (RETARDO)
PZA
497
001165
LINEA SILENCIOSA
PZA
4,000
001161
FULMINANTE NO ELECTRICO
PZA
100
MECHA LENTA
MTS
500
ATENCION DE EXPLOSIVOS 2009
SOFYA
DESCRIPCION
U.M.
OC
ATENDIDO
OC
ATENDIDO
OC
ATENDIDO
OC
ATENDIDO
2009
TOTAL
ATENDIDO
0.00
004980
MECHA DE SEGURIDAD
MTS
004981
FULMINANTE COMUN # 8
UND
7455
004978
BOOSTER PENTOLITA 1 LIBRA
PZA
7455
20000
9003
32880
52,880.00
004971
CORDON DETONANTE 5P
MTS
7455
162000
9474
70000
232,000.00
004987
RETARDO BIDIRECCIONAL 25ms
PZA
7931
2040
2,040.00
004988
RETARDO BIDIRECCIONAL 35ms
PZA
7931
2040
2,040.00
009039
RETARDO BIDIRECCIONAL 42ms
PZA
7931
4080
005026
NITRATO DE AMONIO
KGS
7435
297000
7839
772200
8601
1455300
005011
EMULSION MATRIZ
KGS
7435
480970
7839
451860
8601
821840
016811
RETARDO CTD 100 MS
PZA
8898
2200
016812
RETARDO CTD 0 MS
PZA
8898
200
016813
DETONADOR NO ELECTRICO EXEL DUAL 800X42X18 MTS
PZA
8898
5000
016817
DETONADOR NO ELECTRICO EXEL DUAL 600X42X18 MTS
PZA
8898
10000
016818
DETONADOR NO ELECTRICO EXEL DUAL 500X42X18 MTS
PZA
8898
5000
500
500.00
4,080.00
9467
326700
2,851,200.00
1,754,670.00
2,200.00
200.00
9504
240
9504
2280
5,240.00
10,000.00
7,280.00
