CALCULO PREST.SOCIALES
1
YESID OLIVARES BEDOYA ENERO FEBRERO MARZO ABRIL MAYO JUNIO JULIO AGOSTO ACUMULADO Sueldo $ 566,700.00 $ 566,700.00 $ 566,700.00 $ 566,700.00 $ 566,700.00 $ 566,700.00 $ 566,700.00 $ 566,700.00 Aux. transport $ 67,800.00 $ 67,800.00 $ 67,800.00 $ 67,800.00 $ 67,800.00 $ 67,800.00 $ 67,800.00 $ 67,800.00 Total devengad $ 634,500.00 $ 634,500.00 $ 634,500.00 $ 634,500.00 $ 634,500.00 $ 634,500.00 $ 634,500.00 $ 634,500.00 PROVISION PRESTACIONES SOCIALES Cesantias 8.33% $ 52,853.85 $ 52,853.85 $ 52,853.85 $ 52,853.85 $ 52,853.85 $ 52,853.85 $ 52,853.85 $ 52,853.85 $ 422,830.80 Int. Sobre cesantias $ 6,345.00 $ 6,345.00 $ 6,345.00 $ 6,345.00 $ 6,345.00 $ 6,345.00 $ 6,345.00 $ 6,345.00 $ 50,760.00 Primas de servicios 8.33% $ 52,853.85 $ 52,853.85 $ 52,853.85 $ 52,853.85 $ 52,853.85 $ 52,853.85 $ 52,853.85 $ 52,853.85 $ 422,830.80 Vacaciones 4.17% $ 23,631.39 $ 23,631.39 $ 26,458.65 $ 26,458.65 $ 26,458.65 $ 26,458.65 $ 26,458.65 $ 26,458.65 $ 206,014.68 total $ 135,684.09 $ 135,684.09 $ 138,511.35 $ 138,511.35 $ 138,511.35 $ 138,511.35 $ 138,511.35 $ 138,511.35 $ 1,102,436.28 PARAFISCALES Sena 2% $ 11,334.00 $ 11,334.00 $ 11,334.00 $ 11,334.00 $ 11,334.00 $ 11,334.00 $ 11,334.00 $ 11,334.00 $ 90,672.00 Icbf 3% $ 17,001.00 $ 17,001.00 $ 17,001.00 $ 17,001.00 $ 17,001.00 $ 17,001.00 $ 17,001.00 $ 17,001.00 $ 136,008.00 Cajas de Compensaci 4% $ 22,668.00 $ 22,668.00 $ 22,668.00 $ 22,668.00 $ 22,668.00 $ 22,668.00 $ 22,668.00 $ 22,668.00 $ 181,344.00 total $ 51,003.00 $ 51,003.00 $ 51,003.00 $ 51,003.00 $ 51,003.00 $ 51,003.00 $ 51,003.00 $ 51,003.00 $ 408,024.00 APROPIACIONES PARA SEG. SOCIAL Salud 8.5% $ 48,169.50 $ 48,169.50 $ 48,169.50 $ 48,169.50 $ 48,169.50 $ 48,169.50 $ 48,169.50 $ 48,169.50 $ 385,356.00 Arp 2% $ 13,804.81 $ 13,804.81 $ 13,804.81 $ 13,804.81 $ 13,804.81 $ 13,804.81 $ 13,804.81 $ 13,804.81 $ 110,438.50 Pension 12% $ 68,004.00 $ 68,004.00 $ 68,004.00 $ 68,004.00 $ 68,004.00 $ 68,004.00 $ 68,004.00 $ 68,004.00 $ 544,032.00 total $ 129,978.31 $ 129,978.31 $ 129,978.31 $ 129,978.31 $ 129,978.31 $ 129,978.31 $ 129,978.31 $ 129,978.31 $ 1,039,826.50 TOTALES $ 2,550,286.78
-
Upload
laura-patricia-escorcia-brochado -
Category
Documents
-
view
214 -
download
2
Transcript of CALCULO PREST.SOCIALES
Hoja1INDHIRA PIMIENTAMARZOABRILMAYOJUNIOJULIOAGOSTOSEPTIEMBREOCTUBRENOVIEMBREACUMULADO Sueldo$ 850,000.00$ 850,000.00$ 850,000.00$ 1,300,000.00$ 1,300,000.00$ 1,300,000.00$ 1,300,000.00$ 1,300,000.00$ 1,300,000.00Aux. transporte$ 67,800.00$ 67,800.00$ 67,800.00Total devengado$ 917,800.00$ 917,800.00$ 917,800.00$ 1,300,000.00$ 1,300,000.00$ 1,300,000.00$ 1,300,000.00$ 1,300,000.00$ 1,300,000.00PROVISION PRESTACIONES SOCIALESCesantias8.33%$ 76,452.74$ 76,452.74$ 76,452.74$ 108,290.00$ 108,290.00$ 108,290.00$ 108,290.00$ 108,290.00$ 108,290.00$ 879,098.22Int. Sobre cesantias 1%$ 9,178.00$ 9,178.00$ 9,178.00$ 13,000.00$ 13,000.00$ 13,000.00$ 13,000.00$ 13,000.00$ 13,000.00$ 105,534.00Primas de servicios8.33%$ 76,452.74$ 76,452.74$ 76,452.74$ 108,290.00$ 108,290.00$ 108,290.00$ 108,290.00$ 108,290.00$ 108,290.00$ 879,098.22Vacaciones4.17%$ 35,445.00$ 35,445.00$ 35,445.00$ 54,210.00$ 54,210.00$ 54,210.00$ 54,210.00$ 54,210.00$ 54,210.00$ 431,595.00total$ 197,528.48$ 197,528.48$ 197,528.48$ 283,790.00$ 283,790.00$ 283,790.00$ 283,790.00$ 283,790.00$ 283,790.00$ 2,295,325.44PARAFISCALESSena2%$ 17,000.00$ 17,000.00$ 17,000.00$ 26,000.00$ 26,000.00$ 26,000.00$ 26,000.00$ 26,000.00$ 26,000.00$ 207,000.00Icbf3%$ 25,500.00$ 25,500.00$ 25,500.00$ 39,000.00$ 39,000.00$ 39,000.00$ 39,000.00$ 39,000.00$ 39,000.00$ 310,500.00Cajas de Compensacion4%$ 34,000.00$ 34,000.00$ 34,000.00$ 52,000.00$ 52,000.00$ 52,000.00$ 52,000.00$ 52,000.00$ 52,000.00$ 414,000.00total$ 76,500.00$ 76,500.00$ 76,500.00$ 117,000.00$ 117,000.00$ 117,000.00$ 117,000.00$ 117,000.00$ 117,000.00$ 931,500.00APROPIACIONES PARA SEG. SOCIALSalud8.5%$ 72,250.00$ 72,250.00$ 72,250.00$ 110,500.00$ 110,500.00$ 110,500.00$ 110,500.00$ 110,500.00$ 110,500.00$ 879,750.00Arp2%$ 20,706.00$ 20,706.00$ 20,706.00$ 31,668.00$ 31,668.00$ 31,668.00$ 31,668.00$ 31,668.00$ 31,668.00$ 252,126.00Pension12%$ 102,000.00$ 102,000.00$ 102,000.00$ 156,000.00$ 156,000.00$ 156,000.00$ 156,000.00$ 156,000.00$ 156,000.00$ 1,242,000.00total$ 194,956.00$ 194,956.00$ 194,956.00$ 298,168.00$ 298,168.00$ 298,168.00$ 298,168.00$ 298,168.00$ 298,168.00$ 2,373,876.00TOTALES$ 5,600,701.44
YESID OLIVARES BEDOYAENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOACUMULADOSueldo$ 566,700.00$ 566,700.00$ 566,700.00$ 566,700.00$ 566,700.00$ 566,700.00$ 566,700.00$ 566,700.00Aux. transporte$ 67,800.00$ 67,800.00$ 67,800.00$ 67,800.00$ 67,800.00$ 67,800.00$ 67,800.00$ 67,800.00Total devengado$ 634,500.00$ 634,500.00$ 634,500.00$ 634,500.00$ 634,500.00$ 634,500.00$ 634,500.00$ 634,500.00
PROVISION PRESTACIONES SOCIALESCesantias8.33%$ 52,853.85$ 52,853.85$ 52,853.85$ 52,853.85$ 52,853.85$ 52,853.85$ 52,853.85$ 52,853.85$ 422,830.80Int. Sobre cesantias 1%$ 6,345.00$ 6,345.00$ 6,345.00$ 6,345.00$ 6,345.00$ 6,345.00$ 6,345.00$ 6,345.00$ 50,760.00Primas de servicios8.33%$ 52,853.85$ 52,853.85$ 52,853.85$ 52,853.85$ 52,853.85$ 52,853.85$ 52,853.85$ 52,853.85$ 422,830.80Vacaciones4.17%$ 23,631.39$ 23,631.39$ 26,458.65$ 26,458.65$ 26,458.65$ 26,458.65$ 26,458.65$ 26,458.65$ 206,014.68total$ 135,684.09$ 135,684.09$ 138,511.35$ 138,511.35$ 138,511.35$ 138,511.35$ 138,511.35$ 138,511.35$ 1,102,436.28PARAFISCALESSena2%$ 11,334.00$ 11,334.00$ 11,334.00$ 11,334.00$ 11,334.00$ 11,334.00$ 11,334.00$ 11,334.00$ 90,672.00Icbf3%$ 17,001.00$ 17,001.00$ 17,001.00$ 17,001.00$ 17,001.00$ 17,001.00$ 17,001.00$ 17,001.00$ 136,008.00Cajas de Compensacion4%$ 22,668.00$ 22,668.00$ 22,668.00$ 22,668.00$ 22,668.00$ 22,668.00$ 22,668.00$ 22,668.00$ 181,344.00total$ 51,003.00$ 51,003.00$ 51,003.00$ 51,003.00$ 51,003.00$ 51,003.00$ 51,003.00$ 51,003.00$ 408,024.00APROPIACIONES PARA SEG. SOCIALSalud8.5%$ 48,169.50$ 48,169.50$ 48,169.50$ 48,169.50$ 48,169.50$ 48,169.50$ 48,169.50$ 48,169.50$ 385,356.00Arp2%$ 13,804.81$ 13,804.81$ 13,804.81$ 13,804.81$ 13,804.81$ 13,804.81$ 13,804.81$ 13,804.81$ 110,438.50Pension12%$ 68,004.00$ 68,004.00$ 68,004.00$ 68,004.00$ 68,004.00$ 68,004.00$ 68,004.00$ 68,004.00$ 544,032.00total$ 129,978.31$ 129,978.31$ 129,978.31$ 129,978.31$ 129,978.31$ 129,978.31$ 129,978.31$ 129,978.31$ 1,039,826.50TOTALES$ 2,550,286.78
$ 1,242,000.00
Hoja2
Hoja3
