CALCULO PREST.SOCIALES
-
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