2 Parcial Costos

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 3

Cedula No. 1 Cedula No. 2 Cedula No.

3
Materiales indirectos Mano de Obra Indirecta Pago de Seguro
Departamento Total Total Inversion Factor Total
A Q 4,000.00 Q 3,600.00 Q 15,000.00 0.304 Q 4,560.81
B Q 4,800.00 Q 3,500.00 Q 14,000.00 0.304 Q 4,256.76
C Q 4,100.00 Q 3,400.00 Q 6,000.00 0.304 Q 1,824.32
D Q 4,800.00 Q 3,800.00 Q 8,000.00 0.304 Q 2,432.43
Mantenimiento Q 4,200.00 Q 3,700.00 Q 7,000.00 0.304 Q 2,128.38
Aire acondicionado Q 4,900.00 Q 3,500.00 Q 5,600.00 0.304 Q 1,702.70
Calefaccion Q 3,200.00 Q 3,500.00 Q 3,600.00 0.304 Q 1,094.59
Total Q 30,000.00 Q 25,000.00 Q 59,200.00 Q 18,000.00

CEDULA 4 CEDULA 5
Seguro de Accidentes Pago de Alumbrado
Trabajadores Factor Total Kwh. Factor Total
15 223.881 Q 3,358.21 600 5.1282051282051 Q 3,076.92
13 223.881 Q 2,910.45 500 5.1282051282051 Q 2,564.10
11 223.881 Q 2,462.69 400 5.1282051282051 Q 2,051.28
9 223.881 Q 2,014.93 300 5.1282051282051 Q 1,538.46
8 223.881 Q 1,791.04 250 5.1282051282051 Q 1,282.05
7 223.881 Q 1,567.16 180 5.1282051282051 Q 923.08
4 223.881 Q 895.52 110 5.1282051282051 Q 564.10
67 Q 15,000.00 2340 Q 12,000.00

Cedula No. 6 Cedula No. 7 Cedula No. 8


Pago de Energia Electrica Combustibles y lubricantes Rep. Maquinaria
Departamento H.P, hora Factor total
A 3600 1.23 Q 4,438.36 Total Total
B 1500 1.23 Q 1,849.32
C 900 1.23 Q 1,109.59
D 600 1.23 Q 739.73
Mantenimiento 400 1.23 Q 493.15 Q 6,000.00
Aire acondicionado 200 1.23 Q 246.58 Q 8,000.00
Calefaccion 100 1.23 Q 123.29
Total 7300 Q 9,000.00 Q 8,000.00 Q 6,000.00

Cedula No. 9 Cedula No. 10 Cedula No. 11


Depre. Maquinaria Pago de Alquileres Prestaciones Laborales
Valor Maq. Factor Total Mts 2 Factor Total Salarios Factor Total
Q 15,000.00 0.10 Q 1,520.27 300 3.86 Q 1,158.30 Q 10,000.00 42.59% Q 4,258.67
Q 14,000.00 0.10 Q 1,418.92 250 3.86 Q 965.25 Q 9,000.00 42.59% Q 3,832.80
Q 6,000.00 0.10 Q 608.11 108 3.86 Q 416.99 Q 7,000.00 42.59% Q 2,981.07
Q 8,000.00 0.10 Q 810.81 210 3.86 Q 810.81 Q 5,000.00 42.59% Q 2,129.34
Q 7,000.00 0.10 Q 709.46 60 3.86 Q 231.66 Q 4,000.00 42.59% Q 1,703.47
Q 5,600.00 0.10 Q 567.57 52 3.86 Q 200.77 Q 6,000.00 42.59% Q 2,555.20
Q 3,600.00 0.10 Q 364.86 56 3.86 Q 216.22 Q 3,000.00 42.59% Q 1,277.60
Q 59,200.00 Q 6,000.00 1036 Q 4,000.00 Q 44,000.00 Q 18,738.15
DEPARTAMENTOS
Aire
A B C D Mantenimiento Calefaccion Total
concepto Acondicionado
Jornada de trabajo 1 1 1 1 1 1 1
No. de personal 15 13 11 9 8 7 4 67
KWH 600 500 400 300 250 180 110 2340
HP. H 3600 1500 900 600 400 200 100 7300
Inversion. M Q 15,000.00 Q 14,000.00 Q 6,000.00 Q 8,000.00 Q 7,000.00 Q 5,600.00 Q 3,600.00 Q 59,200.00

Distribucion primaria
M. Indirecto Q 4,000.00 Q 4,800.00 Q 4,100.00 Q 4,800.00 Q 4,200.00 Q 4,900.00 Q 3,200.00 Q 30,000.00
Salarios Q 15,000.00 Q 14,000.00 Q 6,000.00 Q 8,000.00 Q 7,000.00 Q 5,600.00 Q 3,600.00 Q 59,200.00
Mano de Obra Indirecta Q 3,600.00 Q 3,500.00 Q 3,400.00 Q 3,800.00 Q 3,700.00 Q 3,500.00 Q 3,500.00 Q 25,000.00
Seguro de Inc. M. Q 4,560.81 Q 4,256.76 Q 1,824.32 Q 2,432.43 Q 2,128.38 Q 1,702.70 Q 1,094.59 Q 17,999.99 Q 132,741.59
Seguro Acc. Q 3,358.21 Q 2,910.45 Q 2,462.69 Q 2,014.93 Q 1,791.04 Q 1,567.16 Q 895.52 Q 15,000.00 0.327337272365
Alumbrado Q 3,076.92 Q 2,564.10 Q 2,051.28 Q 1,538.46 Q 1,282.05 Q 923.08 Q 564.10 Q 11,999.99 0.291383280854
Ener. Elec. Q 4,438.36 Q 1,849.32 Q 1,109.59 Q 739.73 Q 493.15 Q 246.58 Q 123.29 Q 9,000.02 0.183408530815
Combustible Q 8,000.00 Q 8,000.00 0.197870915965
Man. Maq Q 6,000.00 Q 6,000.00
Alquileres Q 1,158.30 Q 965.25 Q 416.99 Q 810.81 Q 231.66 Q 200.77 Q 216.22 Q 4,000.00 4737.00 9556.77206196
Pres. Lab. Q 4,258.67 Q 3,832.80 Q 2,981.07 Q 2,129.34 Q 1,703.47 Q 2,555.20 Q 1,277.60 Q 18,738.15 4216.70 8507.07766235
Total Q 43,451.27 Q 38,678.68 Q 24,345.94 Q 26,265.70 Q 28,529.75 Q 29,195.49 Q 14,471.32 Q 204,938.15 2654.16 5354.70192734
2863.45 5776.93834836

Distribucion Secundaria 9338.850546257


Calefaccion 4737 4216.7 2654.16 2863.46 -14471.32 0
Aire acondicionado Q 9,556.77 Q 8,507.08 Q 5,354.70 Q 5,776.94 -29195.49 Q -
Mantenimiento Q 9,338.85 8313.09 5232.60 5645.21 -28529.75 -Q 0.00
TOTAL Q 67,083.89 Q 59,715.55 Q 37,587.40 Q 40,551.31 Q 204,938.15

You might also like