Libro 1

15
numero Salario basico Comiciones Horas extras Aux. Trasporte 1 700000 100000 50000 63600 2 650000 250000 250000 63600 3 658000 115000 75000 63600 4 450000 30000 350000 63600 5 700000 90000 100000 63600 6 650000 105000 50000 63600 7 853500 60000 600000 63600 8 705000 468000 157000 63600 9 750000 25000 80000 63600 10 450000 20000 0 63600 11 850000 0 500000 63600 12 300000 85000 90000 63600 13 900000 80000 450000 63600 14 699000 25000 580000 63600 15 500000 100000 25000 63600 16 180000 0 125000 63600 17 750000 250000 150000 63600 18 800000 300000 10000 63600 19 550000 250000 0 63600 20 860000 120000 5000 63600 21 600000 300000 45000 63600 22 450000 150000 25000 63600 23 980000 52000 5000 63600 24 350000 850000 90000 63600 25 700000 250000 50000 63600 26 750000 0 0 63600 27 800000 85000 80000 63600 28 855000 25000 450000 63600 29 500000 500000 450000 63600 30 1850000 0 25000 63600

description

TRABAJO DE EXCEL

Transcript of Libro 1

Page 1: Libro 1

numero Salario basico Comiciones Horas extras Aux. Trasporte Total debengado1 700000 100000 50000 63600 9136002 650000 250000 250000 63600 12136003 658000 115000 75000 63600 9116004 450000 30000 350000 63600 8936005 700000 90000 100000 63600 9536006 650000 105000 50000 63600 8686007 853500 60000 600000 63600 15771008 705000 468000 157000 63600 13936009 750000 25000 80000 63600 918600

10 450000 20000 0 63600 53360011 850000 0 500000 63600 141360012 300000 85000 90000 63600 53860013 900000 80000 450000 63600 149360014 699000 25000 580000 63600 136760015 500000 100000 25000 63600 68860016 180000 0 125000 63600 36860017 750000 250000 150000 63600 121360018 800000 300000 10000 63600 117360019 550000 250000 0 63600 86360020 860000 120000 5000 63600 104860021 600000 300000 45000 63600 100860022 450000 150000 25000 63600 68860023 980000 52000 5000 63600 110060024 350000 850000 90000 63600 135360025 700000 250000 50000 63600 106360026 750000 0 0 63600 81360027 800000 85000 80000 63600 102860028 855000 25000 450000 63600 139360029 500000 500000 450000 63600 151360030 1850000 0 25000 63600 1938600

Page 2: Libro 1

Sueldo base salud 4% salud 8.5% pencion 12% A.R.L Prima de servicios850000 34000 34000 72250 102000 443700 76102.88

1150000 46000 46000 97750 138000 600300 101092.88848000 33920 33920 72080 101760 442656 75936.28830000 33200 33200 70550 99600 433260 74436.88890000 35600 35600 75650 106800 464580 79434.88805000 32200 32200 68425 96600 420210 72354.38

1513500 60540 60540 128647.5 181620 790047 131372.431330000 53200 53200 113050 159600 694260 116086.88855000 34200 34200 72675 102600 446310 76519.38470000 18800 18800 39950 56400 245340 44448.88

1350000 54000 54000 114750 162000 704700 117752.88475000 19000 19000 40375 57000 247950 44865.38

1430000 57200 57200 121550 171600 746460 124416.881304000 52160 52160 110840 156480 680688 113921.08625000 25000 25000 53125 75000 326250 57360.38305000 12200 12200 25925 36600 159210 30704.38

1150000 46000 46000 97750 138000 600300 101092.881110000 44400 44400 94350 133200 579420 97760.88800000 32000 32000 68000 96000 417600 71937.88985000 39400 39400 83725 118200 514170 87348.38945000 37800 37800 80325 113400 493290 84016.38625000 25000 25000 53125 75000 326250 57360.38

1037000 41480 41480 88145 124440 541314 91679.981290000 51600 51600 109650 154800 673380 112754.881000000 40000 40000 85000 120000 522000 88597.88750000 30000 30000 63750 90000 391500 67772.88965000 38600 38600 82025 115800 503730 85682.38

1330000 53200 53200 113050 159600 694260 116086.881450000 58000 58000 123250 174000 756900 126082.881875000 75000 75000 159375 225000 978750 161485.38

pension 4%

Page 3: Libro 1

Cesantrias 0,833% interes sobre censatias 0,417 Vacasiones Caja de compensacion 4%76102.88 76102.88 29190 34000

101092.88 0.0834 27105 4600075936.28 0.1251 27438.6 3392074436.88 0.1668 18765 3320079434.88 0.2085 29190 3560072354.38 0.2502 27105 32200

131372.43 0.2919 35590.95 60540116086.88 0.3336 29398.5 5320076519.38 0.3753 31275 3420044448.88 0.417 18765 18800

117752.88 0.4587 35445 5400044865.38 0.5004 12510 19000

124416.88 0.5421 37530 57200113921.08 0.5838 29148.3 5216057360.38 0.6255 20850 2500030704.38 0.6672 7506 12200

101092.88 0.7089 31275 4600097760.88 0.7506 33360 4440071937.88 0.7923 22935 3200087348.38 0.834 35862 3940084016.38 0.8757 25020 3780057360.38 0.9174 18765 2500091679.98 0.9591 40866 41480

112754.88 1.0008 14595 5160088597.88 1.0425 29190 4000067772.88 1.0842 31275 3000085682.38 1.1259 33360 38600

116086.88 1.1676 35653.5 53200126082.88 1.2093 20850 58000161485.38 1.251 77145 75000

Page 4: Libro 1

I.C.B.F 3% SENA 2% Total debengado salud pension Neto a pagar25500 17000 913600 36544 36544 84051234500 23000 1213600 48544 48544 111651225440 16960 911600 36464 36464 83867224900 16600 893600 35744 35744 82211226700 17800 953600 38144 38144 87731224150 16100 868600 34744 34744 79911245405 30270 1577100 63084 63084 145093239900 26600 1393600 55744 55744 128211225650 17100 918600 36744 36744 84511214100 9400 533600 21344 21344 49091240500 27000 1413600 56544 56544 130051214250 9500 538600 21544 21544 49551242900 28600 1493600 59744 59744 137411239120 26080 1367600 54704 54704 125819218750 12500 688600 27544 27544 6335129150 6100 368600 14744 14744 339112

34500 23000 1213600 48544 48544 111651233300 22200 1173600 46944 46944 107971224000 16000 863600 34544 34544 79451229550 19700 1048600 41944 41944 96471228350 18900 1008600 40344 40344 92791218750 12500 688600 27544 27544 63351231110 20740 1100600 44024 44024 101255238700 25800 1353600 54144 54144 124531230000 20000 1063600 42544 42544 97851222500 15000 813600 32544 32544 74851228950 19300 1028600 41144 41144 94631239900 26600 1393600 55744 55744 128211243500 29000 1513600 60544 60544 139251256250 37500 1938600 77544 77544 1783512

Page 5: Libro 1

za

Page 6: Libro 1

Cargo sueldo basico horas extras Extras x horas diurnas Asistente 650000 2708.333333333 0

Aux. contabilidad 800000 3333.333333333 33333.3333333333operaria maquina plana 650000 2708.333333333 0

Adm de la empresa 1090000 0 0

Page 7: Libro 1

Extras x horas nocturnas horas extras por hora salud 4% pension 4% total debengado0 0 26000 26000 7020000 0 32000 32000 897333.33333333

176041.666666667 2640625 26000 26000 33426250 0 43600 43600 1177200

Page 8: Libro 1

Nombre de los trabajadores Salario basico Subidio trans. Horas normalEDNA 450000 63600 $1,875

CLAUDIA 17000000 63600 $70,833ERIKA 650000 63600 $2,708LINDA 900000 63600 $3,750KELLY 850000 63600 $3,542

SANDRA 2000000 63600 $8,333FELIPE 1000000 63600 $4,167

SANTIAGO 350000 63600 $1,458DIEGO 2800000 63600 $11,667

CARLOS 3000000 63600 $12,500LUBY 9500000 63600 $39,583

FRANCY 600000 63600 $2,500JOSE 2300000 63600 $9,583

PAOLA 2100000 63600 $8,750PILAR 2600000 63600 $10,833

NAYIBER 2300000 63600 $9,583MAGALY 1800000 63600 $7,500

Page 9: Libro 1

Horas extras d Hora extras diurnas 0,125 horas extras H. Ex Noturnas 1.50% Horas extras$8 $56,250 $39 $2,813 $28,125

$295 $2,125,000 $1,476 $106,250 $1,062,500$11 $81,250 $56 $4,063 $40,625$16 $112,500 $391 $5,625 $56,250$15 $106,250 $74 $5,313 $53,125$35 $250,000 $174 $12,500 $125,000$17 $125,000 $87 $6,250 $62,500$6 $43,750 $30 $2,188 $21,875

$49 $350,000 $243 $17,500 $175,000$52 $375,000 $260 $18,750 $187,500

$165 $1,187,500 $825 $59,375 $593,750$10 $75,000 $52 $3,750 $37,500$40 $287,500 $200 $14,375 $143,750$36 $262,500 $182 $13,125 $131,250$45 $325,000 $226 $16,250 $162,500$40 $287,500 $200 $14,375 $143,750$31 $225,000 $156 $11,250 $112,500

Page 10: Libro 1

Festivos y o dominicales nocturnos 1.75% horas extras$3,281 $32,813

$123,958 $1,239,583$4,740 $47,396$6,563 $78,750$6,198 $61,979

$14,583 $145,833$7,292 $72,917$2,552 $25,521

$20,417 $204,167$21,875 $218,750$69,271 $692,708$4,375 $43,750

$16,771 $167,708$15,313 $153,125$18,958 $189,583$16,771 $167,708$13,125 $131,250

Page 11: Libro 1

festivos yo dominicales noturno 2,75 Horas Extras Total hora Extras salud 4% Pension$5,156 $51,563 $792,539 $680,000 $18,000

$194,792 $1,947,917 $425,295 $26,000 $108$7,448 $74,479 $16,261 $36,000 $150

$10,313 $206,250 $22,516 $34,000 $142$9,740 $97,396 $21,265 $80,000 $333

$22,917 $229,167 $50,035 $40,000 $167$11,458 $114,583 $25,017 $14,000 $58$4,010 $40,104 $8,756 $112,000 $467

$32,083 $320,833 $70,049 $120,000 $500$34,375 $343,750 $75,052 $380,000 $1,583

$108,854 $1,088,542 $237,665 $24,000 $100$6,875 $68,750 $15,010 $92,000 $383

$26,354 $263,542 $57,540 $84,000 $350$24,063 $240,625 $52,536 $104,000 $433$29,792 $297,917 $65,045 $92,000 $383$26,354 $263,542 $57,540 $72,000 $300$20,625 $206,250 $45,031 $0 $0

Page 12: Libro 1

Total debengado Retencion de fuente Neto a pagar$1,940,539 $0 $1,940,539

$17,451,403 $5,000 $17,446,403$702,411 $0 $702,411$956,657 $0 $956,657$951,598 $0 $951,598

$2,090,201 $0 $2,090,201$1,039,076 $0 $1,039,076$471,223 $0 $471,223

$2,990,549 $5,000 $2,985,549$3,456,635 $5,000 $3,451,635$9,761,765 $5,000 $9,756,765$707,394 $0 $707,394

$2,441,890 $5,000 $2,436,890$2,256,970 $5,000 $2,251,970$2,757,428 $5,000 $2,752,428$2,429,840 $5,000 $2,424,840$1,845,031 $0 $1,845,031