construdata - copia.xlsx

SALARIO 2020 Sub Transporte 2020 SALARIO TOTAL ANUAL SUBSIDIO TRANSP TOTAL ANUAL SALARIO+SUBSIDIO ANUAL SALARIO+SUBSIDIO

Views 221 Downloads 2 File size 29KB

Report DMCA / Copyright

DOWNLOAD FILE

Recommend stories

Citation preview

SALARIO 2020 Sub Transporte 2020 SALARIO TOTAL ANUAL SUBSIDIO TRANSP TOTAL ANUAL SALARIO+SUBSIDIO ANUAL SALARIO+SUBSIDIO MENSUAL SALARIO+SUBSIDIO DIARIO FACTOR SMMLV 2020 CONCEPTO (anualizado) SALARIO NOMINAL Salario anual (360 dias) Subsidio de transporte PRESTACIONES SOCIALES Cesantias anuales Intereses sobre cesantias Prima - 30 dias Vacaciones - 15 dias SEGURIDAD SOCIAL Pensiones Salud Riesgos laborales (ARL) APORTES PARAFISCALES SENA ICBF CCF FIC DOTACIÓN Vestido y zapatos de labor SEGURIDAD INDUSTRIAL Indumentaria SISO

$ 877,803.00 $ 102,854.00 $ 10,533,636.00 $ 1,234,248.00 $ 11,767,884.00 $ 980,657.00 $ 32,688.57 AYUDANTE OFICIAL 1,6 1,59 1 1.8 $ 17,100,120.01 $ 30,780,216.03 $ 11,767,884.00 $ 21,182,191.20 $ 10,533,636.00 $18,960,544.80 $ 1,234,248.00 $2,221,646.40 $ 2,635,058.63 $4,743,105.53 $ 1,176,788.40 $2,118,219.12 $ 141,214.61 $254,186.29 $ 877,803.00 $1,580,045.40 $ 439,252.62 $790,654.72 $ 1,997,177.39 $3,594,919.29 $ 1,264,036.32 $2,275,265.38 $ $0.00 $ 733,141.07 $1,319,653.92 $ 684,686.34 $1,232,435.41 $ $0.00 $ $0.00 $ 421,345.44 $758,421.79 $ 263,340.90 $474,013.62 $ 600,000.00 $1,080,000.00 $ 600,000.00 $1,080,000.00 $ 100,000.00 $180,000.00 $ 100,000.00 $180,000.00

SALARIO REAL DIARIO SALARIO REAL MENSUAL

$ $

32,688.57 980,657.00

$58,839.42 $1,765,182.60

0:1 0:2 0:3 0:4 0:5 0:6 0:7 0:8 0:9 1:0 1:1 1:2 1:3 1:4 1:5 1:6 1:7 1:8 1:9 2:0 2:1 2:2 2:3 2:4 2:5 2:6 2:7 2:8 2:9 3:0

año $ 17,100,120.01 $ 34,200,240.03 $ 51,300,360.04 $ 68,400,480.06 $ 85,500,600.07 $ 102,600,720.09 $ 119,700,840.10 $ 136,800,960.12 $ 153,901,080.13 $ 30,780,216.03 $ 47,880,336.04 $ 64,980,456.06 $ 82,080,576.07 $ 99,180,696.09 $ 116,280,816.10 $ 133,380,936.12 $ 150,481,056.13 $ 167,581,176.15 $ 201,781,416.17 $ 61,560,432.05 $ 62,985,442.05 $ 64,410,452.06 $ 65,835,462.06 $ 67,260,472.06 $ 68,685,482.06 $ 70,110,492.06 $ 71,535,502.06 $ 72,960,512.06 $ 74,385,522.06 $ 92,340,648.08

mes $ 1,425,010.00 $ 2,850,020.00 $ 4,275,030.00 $ 5,700,040.00 $ 7,125,050.01 $ 8,550,060.01 $ 9,975,070.01 $ 11,400,080.01 $ 12,825,090.01 $ 2,565,018.00 $ 3,990,028.00 $ 5,415,038.00 $ 6,840,048.01 $ 8,265,058.01 $ 9,690,068.01 $ 11,115,078.01 $ 12,540,088.01 $ 13,965,098.01 $ 16,815,118.01 $ 5,130,036.00 $ 5,248,786.84 $ 5,367,537.67 $ 5,486,288.50 $ 5,605,039.34 $ 5,723,790.17 $ 5,842,541.01 $ 5,961,291.84 $ 6,080,042.67 $ 6,198,793.51 $ 7,695,054.01

quincena $ 712,505.00 $ 1,425,010.00 $ 2,137,515.00 $ 2,850,020.00 $ 3,562,525.00 $ 4,275,030.00 $ 4,987,535.00 $ 5,700,040.00 $ 6,412,545.01 $ 1,282,509.00 $ 1,995,014.00 $ 2,707,519.00 $ 3,420,024.00 $ 4,132,529.00 $ 4,845,034.00 $ 5,557,539.00 $ 6,270,044.01 $ 6,982,549.01 $ 8,407,559.01 $ 2,565,018.00 $ 2,624,393.42 $ 2,683,768.84 $ 2,743,144.25 $ 2,802,519.67 $ 2,861,895.09 $ 2,921,270.50 $ 2,980,645.92 $ 3,040,021.34 $ 3,099,396.75 $ 3,847,527.00

dia $ 47,500.33 $ 95,000.67 $ 142,501.00 $ 190,001.33 $ 237,501.67 $ 285,002.00 $ 332,502.33 $ 380,002.67 $ 427,503.00 $ 85,500.60 $ 133,000.93 $ 180,501.27 $ 228,001.60 $ 275,501.93 $ 323,002.27 $ 370,502.60 $ 418,002.93 $ 465,503.27 $ 560,503.93 $ 171,001.20 $ 174,959.56 $ 178,917.92 $ 182,876.28 $ 186,834.64 $ 190,793.01 $ 194,751.37 $ 198,709.73 $ 202,668.09 $ 206,626.45 $ 256,501.80

hora $ 5,937.54 $ 11,875.08 $ 17,812.63 $ 23,750.17 $ 29,687.71 $ 35,625.25 $ 41,562.79 $ 47,500.33 $ 53,437.88 $ 10,687.58 $ 16,625.12 $ 22,562.66 $ 28,500.20 $ 34,437.74 $ 40,375.28 $ 46,312.83 $ 52,250.37 $ 58,187.91 $ 70,062.99 $ 21,375.15 $ 21,869.95 $ 22,364.74 $ 22,859.54 $ 23,354.33 $ 23,849.13 $ 24,343.92 $ 24,838.72 $ 25,333.51 $ 25,828.31 $ 32,062.73

3:1 3:2 3:3 3:4 3:5 3:6 3:7 3:8 3:9 4:0 4:1 4:2 4:3 4:4 4:5 4:6 4:7 4:8 4:9

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

93,765,658.08 95,190,668.08 96,615,678.08 98,040,688.08 99,465,698.09 100,890,708.09 102,315,718.09 103,740,728.09 105,165,738.09 123,120,864.11 124,545,874.11 125,970,884.11 127,395,894.11 128,820,904.11 130,245,914.11 131,670,924.11 133,095,934.12 134,520,944.12 135,945,954.12

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

7,813,804.84 7,932,555.67 8,051,306.51 8,170,057.34 8,288,808.17 8,407,559.01 8,526,309.84 8,645,060.67 8,763,811.51 10,260,072.01 10,378,822.84 10,497,573.68 10,616,324.51 10,735,075.34 10,853,826.18 10,972,577.01 11,091,327.84 11,210,078.68 11,328,829.51

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

3,906,902.42 3,966,277.84 4,025,653.25 4,085,028.67 4,144,404.09 4,203,779.50 4,263,154.92 4,322,530.34 4,381,905.75 5,130,036.00 5,189,411.42 5,248,786.84 5,308,162.25 5,367,537.67 5,426,913.09 5,486,288.50 5,545,663.92 5,605,039.34 5,664,414.75

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

260,460.16 264,418.52 268,376.88 272,335.24 276,293.61 280,251.97 284,210.33 288,168.69 292,127.05 342,002.40 345,960.76 349,919.12 353,877.48 357,835.84 361,794.21 365,752.57 369,710.93 373,669.29 377,627.65

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

32,557.52 33,052.32 33,547.11 34,041.91 34,536.70 35,031.50 35,526.29 36,021.09 36,515.88 42,750.30 43,245.10 43,739.89 44,234.69 44,729.48 45,224.28 45,719.07 46,213.87 46,708.66 47,203.46