Download xlsx - Trabajo Excel 3

Transcript
Page 1: Trabajo Excel 3

CHOCOLATES RICOS

CODIGOS EMPLEADOS N.IDENTIDAD01-80210 Nory Yuberly Acosta Bernal 100098562302-80211 Ashly Paola Agudelo Ripe 100026269403-80212 kevin estebas agudelo ripe 100032476504-80213 karol estephy barreto rincon 100935228605-80214 natalia beltran sanchez 100213265406-80215 juan camilo bravo acevedo 100232657407-80216 sildana vanessa castillo hernadez 100398742308-80217 breidy carolain cocoma cardona 100326549709-80218 hector albeiro jaime correa 100032968710-80219 maria camila gasta cortez 100031049511-80220 julieth cuervo olivar 100322654712-80221 sergio esteban devia gomez 100398745213-80222 carol daniela fonseca valero 100034587914-80223 andrea nataly gomez pedreros 100325478915-80224 gisselle andrea gongora hernandez 100324789616-80225 diego andrey guasca buitrago 100326547917-80226 cristian javier hernandez tovar 100032567518-80227 jose avelino mejia coronado 100369542220-80229 angela isabel moreno aguilar 100239549021-80230 leonel esteban murcia maecha 103698854722-80231 anguie carolina para morera 100133206723-80232 yensi tatiana penagos sanchez 100369854724-80233 luz yarnedy perez rueda 100118781325-80234 karen tatiana pico luna 100735452026-80235 victor alejandro puin medina 100396975827-80236 jeferson reyes alvarez 100032697428-80237 brayan estiven rincon espinel 100382478529-80238 karen milena rincon gaitan 100028210330-80239 carlos javier rodriguez herrera 100369857431-80240 kevin esteban rodriguez nieto 100013151232-80241 dieison julian rojas rey 100098652133-80242 laura vanessa sanchez carranza 119310584034-80243 santiago serrano sanabria 1000328749

Page 2: Trabajo Excel 3

35-80244 yulius esteben suares baron 100032405236-80245 brandon stick torres forero 123652347237-80246 juan camilo valencia sanchez 100326565438-80247 angie tatiana vera montaya 112396698539-80248 paula alejandra vivas rodriguez 100032678940-80249 brayan camilo vizcaino vizcaino 113963814541-80250 cristian andres zarate aperador 1003459897

Page 3: Trabajo Excel 3

CHOCOLATES RICOS CUIDAD:MOSQUERANIT: 811.036.030-9

INGRESOSCARGO SUELDO SUBSIDIO DE SUBSIDIO DE SUBSIDIO F

auxiliar logistica 650,000 74,000 42,600 25,000recepcion 650,000 74,000 42,600 25,000bodega 650,000 74,000 42,600 25,000cobros y pagos 650,000 74,000 42,600 25,000selección del personal 650,000 74,000 42,600 25,000auxiliar logistica 650,000 74,000 42,600 25,000facturacion 650,000 74,000 42,600 25,000politica salarial 650,000 74,000 42,600 25,000bodega 650,000 74,000 42,600 25,000facturacion 650,000 74,000 42,600 25,000politica salarial 650,000 74,000 42,600 25,000relacion con clientes y proveedores 650,000 74,000 42,600 25,000recepcion 650,000 74,000 42,600 25,000cobros y pagos 650,000 74,000 42,600 25,000auxiliar logistica 650,000 74,000 42,600 25,000contabilidad 650,000 74,000 42,600 25,000bodega 650,000 74,000 42,600 25,000gestion de los RRHH 650,000 74,000 42,600 25,000recepcion 650,000 74,000 42,600 25,000gestion de los RRHH 650,000 74,000 42,600 25,000recepcion 650,000 74,000 42,600 25,000selección del personal 650,000 74,000 42,600 25,000cobros y pagos 650,000 74,000 42,600 25,000recepcion 650,000 74,000 42,600 25,000auxiliar logistica 650,000 74,000 42,600 25,000contabilidad 650,000 74,000 42,600 25,000bodega 650,000 74,000 42,600 25,000subjerente 650,000 74,000 42,600 25,000supervisor 650,000 74,000 42,600 25,000auditoria interna 650,000 74,000 42,600 25,000bodega 650,000 74,000 42,600 25,000facturacion 650,000 74,000 42,600 25,000auditoria interna 650,000 74,000 42,600 25,000

TEL:3143586878

Page 4: Trabajo Excel 3

gestion de los RRHH 650,000 74,000 42,600 25,000auxiliar logistica 650,000 74,000 42,600 25,000supervisor 650,000 74,000 42,600 25,000relacion con clientes y proveedores 650,000 74,000 42,600 25,000cobros y pagos 650,000 74,000 42,600 25,000auxiliar logistica 650,000 74,000 42,600 25,000supervisor 650,000 74,000 42,600 25,000

Page 5: Trabajo Excel 3

CHOCOLATES RICOS INGRESOS EGRESOS

TOTAL DE VENGADO APORTE A SALUD APORTE A PENCION TOTAL DE EGRESOS NETO A PAGAR 30,664,000 $ 26,000 $ 26,000 $ 52,000 30,612,000 29,897,400 $ 26,000 $ 26,000 $ 52,000 29,845,400 29,130,800 $ 26,000 $ 26,000 $ 52,000 29,078,800 28,364,200 $ 26,000 $ 26,000 $ 52,000 28,312,200 27,597,600 $ 26,000 $ 26,000 $ 52,000 27,545,600 26,831,000 $ 26,000 $ 26,000 $ 52,000 26,779,000 26,064,400 $ 26,000 $ 26,000 $ 52,000 26,012,400 25,297,800 $ 26,000 $ 26,000 $ 52,000 25,245,800 24,531,200 $ 26,000 $ 26,000 $ 52,000 24,479,200 23,764,600 $ 26,000 $ 26,000 $ 52,000 23,712,600 22,998,000 $ 26,000 $ 26,000 $ 52,000 22,946,000 22,231,400 $ 26,000 $ 26,000 $ 52,000 22,179,400 21,464,800 $ 26,000 $ 26,000 $ 52,000 21,412,800 20,698,200 $ 26,000 $ 26,000 $ 52,000 20,646,200 19,931,600 $ 26,000 $ 26,000 $ 52,000 19,879,600 19,165,000 $ 26,000 $ 26,000 $ 52,000 19,113,000 18,398,400 $ 26,000 $ 26,000 $ 52,000 18,346,400 17,631,800 $ 26,000 $ 26,000 $ 52,000 17,579,800 16,865,200 $ 26,000 $ 26,000 $ 52,000 16,813,200 16,098,600 $ 26,000 $ 26,000 $ 52,000 16,046,600 15,332,000 $ 26,000 $ 26,000 $ 52,000 15,280,000 14,565,400 $ 26,000 $ 26,000 $ 52,000 14,513,400 13,798,800 $ 26,000 $ 26,000 $ 52,000 13,746,800 13,032,200 $ 26,000 $ 26,000 $ 52,000 12,980,200 12,265,600 $ 26,000 $ 26,000 $ 52,000 12,213,600 11,499,000 $ 26,000 $ 26,000 $ 52,000 11,447,000 10,732,400 $ 26,000 $ 26,000 $ 52,000 10,680,400 9,965,800 $ 26,000 $ 26,000 $ 52,000 9,913,800 9,199,200 $ 26,000 $ 26,000 $ 52,000 9,147,200 8,432,600 $ 26,000 $ 26,000 $ 52,000 8,380,600 7,666,000 $ 26,000 $ 26,000 $ 52,000 7,614,000 6,899,400 $ 26,000 $ 26,000 $ 52,000 6,847,400 6,132,800 $ 26,000 $ 26,000 $ 52,000 6,080,800

Page 6: Trabajo Excel 3

5,366,200 $ 26,000 $ 26,000 $ 52,000 5,314,200 4,599,600 $ 26,000 $ 26,000 $ 52,000 4,547,600 3,833,000 $ 26,000 $ 26,000 $ 52,000 3,781,000 3,066,400 $ 26,000 $ 26,000 $ 52,000 3,014,400 2,299,800 $ 26,000 $ 26,000 $ 52,000 2,247,800 1,533,200 $ 26,000 $ 26,000 $ 52,000 1,481,200 766,600 $ 26,000 $ 26,000 $ 52,000 714,600 -

Page 7: Trabajo Excel 3