Costos de Merma
Costos de Merma
Costos de Merma
S/ 29,606,229.91
A 58.9%
S/ 16,086,596.94
A 32.0%
S/ 2,166,214.25
B 4.3%
S/ 1,437,377.99
C 2.9%
C 0.8% S/ 396,370.59
C 0.4% S/ 219,661.73
C 0.4% S/ 189,099.77
C 0.2% S/ 120,501.60
C 0.1% S/ 29,368.13
C 0.0% S/ 17,623.32
S/ 11,550.24
C 0.0%
C 0.0% S/ 7,450.85
C 0.0% S/ 6,320.86
S/ 5,487.77
C 0.0%
S/ 940.50
C 0.0%
S/ 484.56
C 0.0%
S/ 150.60
C 0.0%
C 0.0% S/ 145.39
S/ 50,301,574.99
FAMILIA VENTAS ANUALES FAMILIA
SOLDADURA
CALAMINA
ACCESORIOS TECHO
YESO
PLANCHA
SERVICIO BOMBEO
CONCRETO
TUBOS
ALAMBRON
ANGULOS
REDONDOS
CUADRADOS
TOTAL
Item PRODUCTO VENTAS ANUALES
1458 15340
69 131
3410 1667
1205 1357
3464 4311
57 -223
1150 147
5698 936
PRODUCTO COSTO DE COMPRA STOCK DE SEGURIDAD STOCK ACTUAL
Costo de
S/. 0.63 S/. 2,649,410.59
Almacenamiento
Mantenimiento de
Unidades S/. 164,400.00
Perdidadas de materiales S/. 44,469.19
Ahorro / Inversión
COSTO DE
UNIDADES COSTO DE UNIDADES
UNIDADES SOBRANTES UNIDADES
FALTANTES FALTANTES SOBRANTES
Mantenimiento de
164,400.00 S/. 49,200.00
Unidades
44,469.19 Perdidadas de materiales -S/. 8,893.84
de Costo Logistico
Si el BC es mayor a 1, se
1.96
aprueba el proyecto
MERMA 5 % COSTO DE MERMA
INVERSION
5S S/. 33,000.00
Sotware de
automatización de S/. 1,089,000.00
procesos (BIZAGI)
S/. 187,520.48
6.12253132277803
inver/ igual5mese
JIT
Meses
Número de colaboradores Salario
Operativos
5S
Meses
Número de colaboradores Salario
Operativos
Ing encargado de la
1 S/. 2,500.00 2
implementación
Conductor de
1 S/. 2,000.00 2
maquinaria
ABC
Meses
Número de colaboradores Salario
Operativos
Ing encargado de la
1 S/. 2,500.00 1
implementación
Meses de
Capacitación y Inversión Total
seguimiento
S/. 2,400.00
3 S/. 15,000.00
S/. 17,400.00
Meses de
Capacitación y Inversión Total
seguimiento
S/. 10,000.00
3 S/. 15,000.00
S/. 8,000.00
S/. 33,000.00
Meses de
Capacitación y Inversión Total
seguimiento
S/. 1,200.00
3 S/. 7,500.00
S/. 8,700.00
1,148,100.93 0.51021136
2,250,245.74
3,061,007.93 957,619.05
3.19647769
FERRONOR SAC Fecha : 4/5/2021
Pag: 001
Costo de
Cantidad Promedio Precio Costo de producto sin
DESCRIPCION DEL ITEM Ventas totales Stock Real
Total Mensual Unitario Compra movimiento de
stock
LINEA: MATERIAL DE CONSTRUCCIÓN
SUBLINEA: ALAMBRE Y CLAVOS SUBLINEA
GRUPO/TIPO: CLAVOS
CLAVO CALAMINA 2 1/2" ROKI 6.00 0.50 2.60 S/ 15.61 S/ 1.36 21.00 S/ 28.59
CLAVO CALAMINA 2 1/2" ORE 87.00 7.25 2.33 S/ 202.90 S/ 1.09 54.00 S/ 58.98
CLAVO 1 1/2" PRODAC 150.00 12.50 2.60 S/ 390.08 S/ 1.36 39.00 S/ 53.06
CLAVO 1" PRODAC 155.00 12.92 2.33 S/ 360.64 S/ 1.09 420.00 S/ 456.41
CLAVO 1/2" 79.00 6.58 2.24 S/ 177.00 S/ 1.00 308.00 S/ 308.15 S/ 1,421.49
CLAVO ACERO 2 ½" X (CAJA 1/2 KG) 13.00 1.08 2.88 S/ 37.44 S/ 1.64 1.00 S/ 1.64
CLAVO ACERO 2" X (CAJA 1/2 KG) 34.00 2.83 3.31 S/ 112.64 S/ 2.07 961 S/ 1,991.34
CLAVO ACERO 3 " X (CAJA 1/2 KG) 39.00 3.25 3.21 S/ 125.19 S/ 1.97 377 S/ 742.30
SUBLINEA: CALAMINA
GRUPO/TIPO: CALAMINA
CALAMINA 0.14 X 1.80 TIONALE 6.00 0.50 5.06 S/ 30.35 S/ 3.82 15340.00 S/ 58,568.12
CALAMINA 0.20 X 1.80 SIDER PERU 60.00 5.00 11.75 S/ 705.00 S/ 9.51 769.00 S/ 7,313.19
CALAMINA 0.20X0.80X1.80 IMP SIDER 72.00 6.00 11.64 S/ 837.98 S/ 9.40 39.00 S/ 366.55
CALAMINA 0.14X1.80 PRODAC 2.00 0.17 10.50 S/ 21.00 S/ 8.26 123.00 S/ 1,015.98
CALAMINA 0.14X3.60 MIRO 453.00 37.75 15.11 S/ 6,845.87 S/ 12.87 38.00 S/ 489.15
CALAMINA 0.22X3.60 MIRO 111.00 9.25 20.43 S/ 2,267.91 S/ 18.19 1342.00 S/ 24,413.13
CALAMINA 0.14X3.60 ACEROS AREQUIPA 854.00 71.17 16.00 S/ 13,660.41 S/ 13.76 9078.00 S/ 124,875.15
CALAMINA 0.22 X 3.60 ACEROS 406.00 33.83 15.58 S/ 6,325.72 S/ 13.34 15850.00 S/ 211,448.51
AREQUIPA
SUBLINEA: CEMENTO
GRUPO/TIPO: CEMENTO
CEMENTO TIPO V PACASMAYO X 42.5KG 1,000.00 83.33
18.67 S/ 18,669.00 S/ 16.43 2.00 S/ 32.86
S/ 0.00
GRUPO/TIPO: CONCRETO S/ 0.00
CONCRETO PRE-MEZCLADO 210 KG/CM2 15.00 1.25 13.56 S/ 203.40 S/ 11.32 182.00 S/ 2,060.24
T.M.S. H67 A4-6" S/ 0.00
CONCRETO PRE-MEZCLADO 210 KG/CM2 182.00 15.17 14.58 S/ 2,653.56 S/ 12.34 1,103.00 S/ 13,611.02
T.M.S. H57 A4-6" S/ 0.00
CONCRETO PRE-MEZCLADO 210 KG/CM2 86.00 7.17 13.96 S/ 1,200.56 S/ 11.72 754.00 S/ 8,836.88 S/ 6,320.86
T.I. H67 A4-6" S/ 0.00
CONCRETO PRE-MEZCLADO 210 KG/CM2 59.00 4.92 15.89 S/ 937.51 S/ 13.65 2,507.00 S/ 34,220.55
T.M.S. H57 A3-5" S/ 0.00
CONCRETO PRE-MEZCLADO 175 KG/CM2 40.00 3.33 17.8 S/ 712.00 S/ 15.56 3,227.00 S/ 50,212.12
T.I. H67 A4-6" S/ 0.00
CONCRETO PRE-MEZCLADO175 KG/CM2 37.00 3.08 16.59 S/ 613.83 S/ 14.35 166.00 S/ 2,382.10
/T MS / H 57/ A 4"-6" S/ 0.00
S/ 0.00
SUBLINEA: FIERRO INDUSTRIAL S/ 0.00
GRUPO/TIPO: ÁNGULOS S/ 0.00
ANGULO 1 1/2" X 1 1/2" X 1/8" X 6MM 1.00 0.08 14.58 S/ 14.58 S/ 12.34 2,507.00 S/ 30,936.38
V.AA S/ 0.00
ANGULO 1 1/2"X1 1/2" X 3/16 X 20 V.AA 4.00 0.33 13.25 S/ 53.00 S/ 11.01 3,227.00 S/ 35,529.27
ANGULO 20MM X 20MM X2.5MM X 6MM 2.00 0.17 11.26 S/ 22.52 S/ 9.02 1,103.00 S/ 9,949.06
AA S/ 0.00
ANGULO 2.0 MM X 20 MM X 6 MT COM 1.00 0.08 12.58 S/ 12.58 S/ 10.34 912.00 S/ 9,430.08
ANGULO 2.5 M X 25 MM X 6 MT(1") COM 6.00 0.50 16.36 S/ 98.16 S/ 14.12 -18.00 -S/ 254.16 S/ 484.56
ANGULO 2.5 M X 30 MM X 6 3.00 0.25 13.5 S/ 40.50 S/ 11.26 8,807.00 S/ 99,166.82
MT(1.1/4"FN)COM S/ 0.00
ANGULO 3.0 M X 25 MM X 6 MT(1") 8.00 0.67 12.69 S/ 101.52 S/ 10.45 308.00 S/ 3,218.60
COM.A S/ 0.00
ANGULO 3.0 M X 30 MM X 6 MT(1.1/4") 7.00 0.58 11.58 S/ 81.06 S/ 9.34 4,460.00 S/ 41,656.40
COM. 0.00 S/ 0.00
ANGULO 4.5 M X 25 MM X 6 MT(3/16X1) 2.00 0.17 10.96 S/ 21.92 S/ 8.72 1,196.00 S/ 10,429.12
COM S/ 0.00
ANGULO 3/32" X 1.1/2" X 6 MT COM.ACER 4.00 0.33 9.68 S/ 38.72 S/ 7.44 2,507.00 S/ 18,652.08
S/ 0.00
GRUPO/TIPO: CUADRADOS
S/ 0.00
CUADRADOS 12MM X 6 MT COM. ACERO 31.00 2.58 4.69 S/ 145.39 S/ 2.45 11.00 S/ 26.95 S/ 145.39
S/ 0.00
GRUPO/TIPO: REDONDOS S/ 0.00
REDONDO LISO 3/8" X 6MT CM 4.00 0.33 24.9 S/ 99.60 S/ 22.66 420.00 S/ 9,517.20
COM.ACERO S/ 150.60
REDONDO LISO 1/2" X 6MT CM 2.00 0.17 25.5 S/ 51.00 S/ 23.26 15.00 S/ 348.90
COM.ACERO
GRUPO/TIPO: TUBOS
TUB ELEC.CUA 5/8" X 0.9 X 6MT C.ACERO 12.00 1.00 12.78 S/ 153.36 S/ 10.54 1,365.00 S/ 14,387.10
TUB ELEC.CUA 3/4" X 0.8 X 6MT C.ACERO 7.00 0.58 12.54 S/ 87.78 S/ 10.30 997.00 S/ 10,269.10
TUB ELEC.CUA 3/4" X 0.9 X 6MT C.ACERO 47.00 3.92 13.89 S/ 652.83 S/ 11.65 182.00 S/ 2,120.30
TUB ELEC.CUA 7/8" X 0.9 X 6MT C.ACERO 10.00 0.83 14.2 S/ 142.00 S/ 11.96 1,103.00 S/ 13,191.88
TUB ELEC.CUA 1" X 0.9 X 6MT C.ACERO 25.00 2.08 11.8 S/ 295.00 S/ 9.56 23.84 S/ 227.86
TUB ELEC.CUA 1.1/4" X 0.9 X 6MT 15.00 1.25 10.25 S/ 153.75 S/ 8.01 2.08 S/ 16.66
C.ACERO
TUB ELEC.CUA 1.1/2" X 0.9 X 6MT 2.00 0.17 9.56 S/ 19.12 S/ 7.32 11.13 S/ 81.46
C.ACERO
TUB ELEC.REC 2" X 1"X 1.2" X 6MT 24.00 2.00 14.58 S/ 349.92 S/ 12.34 1.00 S/ 12.34
C.ACERO
TUB ELEC.RED 1/2" X 0.8 X 6MT C.ACERO 4.00 0.33 17.52 S/ 70.08 S/ 15.28 3,227.00 S/ 49,308.56
TUB ELEC.RED 1" X 0.9 X 6MT 4.00 0.33 14.65 S/ 58.60 S/ 12.41 3,192.00 S/ 39,612.72
COM.ACERO S/ 0.00
TUB ELEC.RED 1.1/2 X 0.9X 6MT 4.00 0.33 15.25 S/ 61.00 S/ 13.01 43.00 S/ 559.43
COM.ACERO S/ 0.00
TUB ELEC.RED 7/8" X 0.8X 6MT 5.00 0.42 17.58 S/ 87.90 S/ 15.34 1,923.00 S/ 29,498.82 S/ 5,487.77
COM.ACERO
S/ 0.00
TB.NEGR.LAC CUAD. 25 X 1.8 X 6 2.00 0.17 11.54 S/ 23.08 S/ 9.30 -150.00 -S/ 1,395.00
COM.ACERO S/ 0.00
TB.NEGR.LAC CUAD. 25 X 2.0 X 6 4.00 0.33 13.25 S/ 53.00 S/ 11.01 1,746.00 S/ 19,223.46
COM.ACERO S/ 0.00
TB.NEGR.LAC CUAD. 30 X 1.8 X 6 5.00 0.42 9.58 S/ 47.90 S/ 7.34 1,202.00 S/ 8,822.68
COM.ACERO S/ 0.00
TB.NEGR.LAC CUAD. 30 X 2.0 X 6 10.00 0.83 5.69 S/ 56.90 S/ 3.45 1,481.00 S/ 5,109.45
COM.ACERO S/ 0.00
TB.NEGR.LAC CUAD. 38 X 1.8 X 6 11.00 0.92 12.69 S/ 139.59 S/ 10.45 282.00 S/ 2,946.90
COM.ACERO S/ 0.00
TB.NEGR.LAC CUAD. 38 X 2.0 X 6 10.00 0.83 19.32 S/ 193.20 S/ 17.08 9,403.00 S/ 160,603.24
COM.ACERO S/ 0.00
TB.NEGR.LAC CUAD. 50 X 1.8 X 6 19.00 1.58 12.58 S/ 239.02 S/ 10.34 11,672.00 S/ 120,688.48
COM.ACERO S/ 0.00
TB.NEGR.LAC CUAD. 50 X 2.0 X 6 5.00 0.42 14.56 S/ 72.80 S/ 12.32 -281.00 -S/ 3,461.92
COM.ACERO
S/ 0.00
TB.NEG.RECT.LAC 40 X 60 X 2.0 X 6 46.00 3.83 12.96 S/ 596.16 S/ 10.72 18,812.90 S/ 201,674.29
COM.ACERO S/ 0.00
TB.NEG.RECT.LAC 40 X 80 X 2.0 X 6 45.00 3.75 12.69 S/ 571.05 S/ 10.45 339.00 S/ 3,542.55
COM.ACERO S/ 0.00
TB.NEG.LAC.RED 1" X 2.0 X 6.00 8.00 0.67 14.51 S/ 116.08 S/ 12.27 8,807.00 S/ 108,061.89
COM.ACERO S/ 0.00
TB.NEG.LAC.RED 1.1/4 X 1.8 X 6.00 1.00 0.08 15.98 S/ 15.98 S/ 13.74 100.00 S/ 1,374.00
COM.ACERO S/ 0.00
TB.NEG.LAC.RED 1.1/2 X 1.8 X 6.00 2.00 0.17 11.78 S/ 23.56 S/ 9.54 182.00 S/ 1,736.28
COM.AC S/ 0.00
TB.NEG.LAC.RED 1.1/2 X 2.0 X 6.00 8.00 0.67 13.36 S/ 106.88 S/ 11.12 280.00 S/ 3,113.60
COM.ACERO S/ 0.00
TB.NEG.LAC.RED 2" X 2.0 X 6.00 26.00 2.17 14.58 S/ 379.08 S/ 12.34 278.00 S/ 3,430.52
COM.ACERO
S/ 0.00
TB.NEG.LAC.RED 3"X2,0MM X 6,OMT 15.00 1.25 14.65 S/ 219.75 S/ 12.41 260.00 S/ 3,226.60
TB.NEG.LAC.REC(2"X4")50 X 100 X 2,0MM 13.00 1.08 18.5 S/ 240.50 S/ 16.26 182.00 S/ 2,959.32
X6,OMT S/ 0.00
TB.NEG.LAC.REC 40X60X2,5MMX 6,OMT 10.00 0.00 13.65 S/ 136.50 S/ 11.41 1,103.00 S/ 12,585.23
TB.NEG.LAC.REC (2"X4")50X100X2,5MM X 10.00 1.00 12.54 S/ 125.40 S/ 10.30 754.00 S/ 7,766.20
6,OMT S/ 0.00
S/ 0.00
SUBLINEA: LADRILLO S/ 0.00
GRUPO/TIPO: LADRILLO S/ 0.00
LADRILLO HUECO 12 ITAL PERU 621.00 51.75 1.75 S/ 1,084.14 S/ 0.88 -37.00 -S/ 32.40
LADRILLO PANDERETA ITAL PERU 404.00 33.67 1.31 S/ 529.24 S/ 0.44 1894.00 S/ 833.36 S/ 1,613.38
S/ 0.00
SUBLINEA: ND S/ 0.00
GRUPO/TIPO: YESO S/ 0.00
YESO BOLSA 14 KG. 697.00 58.08 3.07 S/ 2,137.56 S/ 2.04 -83.00 -S/ 169.05
S/ 0.00
SUBLINEA: TIPOS DE TECHO S/ 0.00
GRUPO/TIPO: PLANCHA S/ 0.00
PLANCHA SVP 10 DE 2.40 X 1.20 X 2" 51.00 4.25 5.39 S/ 274.81 S/ 3.15 39.00 S/ 122.79 S/ 274.81
S/ 1,634,141.40 15898.8576
MERMA 2% COSTO DE MERMA
0.42 0.571746
1.08 1.179576
0.78 1.06119
8.4 9.12828
CLAVOS 6.16 6.16308
0.02 0.0328
19.214 39.8267792
7.536 14.84592
0 0
0 0
0 0
306.8 1171.3624
15.38 146.2638
0.78 7.330908
2.46 20.3196
0.76 9.782948
26.84 488.262544
181.56 2497.503048
317 4228.9702
0 0
0 0
0 0
0 0
0.04 0.65716
0 0
0 0
3.64 41.2048
0 0
22.06 272.2204
0 0
CONCRETO 15.08 176.7376
0 0
50.14 684.411
0 0
64.54 1004.2424
0 0
3.32 47.642
0 0
0 0
0 0
0 0
50.14 618.7276
0 0
64.54 710.5854
22.06 198.9812
0 0
18.24 188.6016
ANGULOS -0.36 -5.0832
176.14 1983.3364
0 0
6.16 64.372
0 0
89.2 833.128
0 0
23.92 208.5824
0 0
50.14 373.0416
0 0
0 0
CUADRADOS 0.22 0.539
0 0
0 0
8.4 190.344
REDONDOS 0 0
0.3 6.978
0 0
0 0
0 0
27.3 287.742
19.94 205.382
3.64 42.406
22.06 263.8376
0.4767 4.557252
0.0416 0.333216
0 0
0.22256 1.6291392
0 0
0.02 0.2468
0 0
64.54 986.1712
63.84 792.2544
0 0
0.86 11.1886
0 0
TUBOS 38.46 589.9764
0 0
-3 -27.9
0 0
34.92 384.4692
0 0
24.04 176.4536
0 0
29.62 102.189
0 0
5.64 58.938
0 0
188.06 3212.0648
0 0
233.44 2413.7696
0 0
-5.62 -69.2384
0 0
376.258 4033.48576
0 0
6.78 70.851
0 0
176.14 2161.2378
0 0
2 27.48
0 0
3.64 34.7256
0 0
5.6 62.272
0 0
5.56 68.6104
0 0
5.2 64.532
3.64 59.1864
0 0
22.06 251.7046
15.08 155.324
0 0
0 0
0 0
0 0
-0.74 -0.648092
LADRILLO 37.88 16.6672
0 0
0 0
0 0
-1.66 -3.381088
0 0
0 0
0 0
PLANCHA 0.78 2.455752
32682.8279184