trabajo numero 3 de excel

8
TOR CODIGO EMPLEADO N°IDENTIDAD 305-an2 acosta bernal nory yuerli 1000345900 356-aa2 agudelo ripe ashly paola 1000262694 240-ak3 agudelo ripe kevin andres 1000853638 366-bk2 barreto rincon karol stephy 1003510264 398-bn2 beltran sanchez natalia 1000001769 254-bj3 bravo acevedo juan camilo 1000328082 354-cc2 castillo hernandez cildana vanesa 1050072022 300-cb2 cocoma cardona breidy Carolain 1002596704 201-ca3 correa jaime hactor alveiro 1000225343 369-cm2 cortes gasca maria camila 1007437275 377-co2 cuervo olivar julieth 1000701829 259-ds3 devia gomez sergio esteban 1000603762 321-fk2 fonseca valero karol daniela 1003036262 333-ga2 gomez pedreros andrea natalyd 1000685977 255-gd3 guasca buitrago diego andrey 1005395480 262-hc3 hernandes tovar cristian javier 1000809700 210-mj3 mejia coronado jose avelino 1000235784 301-md2 mendez santos nicol daniela 1000787628 333-mb2 marales parra brenda alejandra 1003691204 323-ma2 moreno aguilar angela isabel 1002395490 226-mj3 murcia mahecha jeonel esteban 1000589275 303-pa2 parra morera angie carolina 1001332067 311-py2 penagos sanchez yensi tatiana 1000324035 351-pl2 perez rueda luz yarnedy 1001187813 365-pk2 pico luna karen tatiana 1007354520 222-pv3 puin medina victor alejandro 1000589297 203-rj3 reyes alvarez jeferson stiven 1003596323 299-rb3 rincon espinel brayan stiven 1000324034 397-rk2 rincon gaitan karen milena 1000323482 278-rj3 rodriges herrera carlos javier 1003519515 295-rk3 rodrigez nieto kevin estevan 1002325520 211-rd3 rojas rey deison julian 1003586648 319-sl2 sanchez carranza laura vanessa 1193105840 245-ss3 serrano sanabria santiago 1003533060 232-sy3 suarez baron yulius stiven 1193573286

Upload: angela-isabel-aguilar

Post on 12-Jan-2016

29 views

Category:

Documents


0 download

DESCRIPTION

formulas y otros

TRANSCRIPT

Page 1: Trabajo Numero 3 de excel

TORTAS FONDANT

CODIGO EMPLEADO N°IDENTIDAD305-an2 acosta bernal nory yuerli 1000345900356-aa2 agudelo ripe ashly paola 1000262694240-ak3 agudelo ripe kevin andres 1000853638366-bk2 barreto rincon karol stephy 1003510264398-bn2 beltran sanchez natalia 1000001769254-bj3 bravo acevedo juan camilo 1000328082354-cc2 castillo hernandez cildana vanesa 1050072022300-cb2 cocoma cardona breidy Carolain 1002596704201-ca3 correa jaime hactor alveiro 1000225343369-cm2 cortes gasca maria camila 1007437275377-co2 cuervo olivar julieth 1000701829259-ds3 devia gomez sergio esteban 1000603762321-fk2 fonseca valero karol daniela 1003036262333-ga2 gomez pedreros andrea natalyd 1000685977255-gd3 guasca buitrago diego andrey 1005395480262-hc3 hernandes tovar cristian javier 1000809700210-mj3 mejia coronado jose avelino 1000235784301-md2 mendez santos nicol daniela 1000787628333-mb2 marales parra brenda alejandra 1003691204323-ma2 moreno aguilar angela isabel 1002395490226-mj3 murcia mahecha jeonel esteban 1000589275303-pa2 parra morera angie carolina 1001332067311-py2 penagos sanchez yensi tatiana 1000324035351-pl2 perez rueda luz yarnedy 1001187813365-pk2 pico luna karen tatiana 1007354520222-pv3 puin medina victor alejandro 1000589297203-rj3 reyes alvarez jeferson stiven 1003596323299-rb3 rincon espinel brayan stiven 1000324034397-rk2 rincon gaitan karen milena 1000323482278-rj3 rodriges herrera carlos javier 1003519515295-rk3 rodrigez nieto kevin estevan 1002325520211-rd3 rojas rey deison julian 1003586648319-sl2 sanchez carranza laura vanessa 1193105840245-ss3 serrano sanabria santiago 1003533060232-sy3 suarez baron yulius stiven 1193573286

Page 2: Trabajo Numero 3 de excel

245-rf3 torres fonseca brandon stick 1106273231288-vj2 valencia sanchez juan camilo 1193419118369-va2 vera montolla angie tatiana 1001328478388-vp2 vivas rodrigez paula alejandra 1007703451253-vb3 vizcaino vizcaino brayan camilo 1002846560222-za3 zarate aperador cristian andres 98061355049

Page 3: Trabajo Numero 3 de excel

TORTAS FONDANTTel: 8949528

Ciudad: mosquera Cel: 3142809375

INGRESOSCARGOS SALARIO SUBSIDIO DSUBSIDIO DSUBCIDIO Fmesclador 1 700,000 74,000 42,600 25,000mesclador 2 750,000 74,000 42,600 25,000merclador 3 800,000 74,000 42,600 25,000celadora 1 644,350 74,000 42,600 50,000moldeador 1 700,100 74,000 42,600 50,000moldeador 2 700,500 74,000 42,600 50,000moldeador 3 800,000 74,000 42,600 50,000celadora 2 644,350 74,000 42,600 25,000empacador1 750,000 74,000 42,600 50,000empacadora 2 985,500 74,000 42,600 50,000empacadora 3 985,000 74,000 42,600 25,000conductor1 750,150 74,000 42,600 50,000secretaria 1 985,150 74,000 42,600 50,000empacadora1 995,100 74,000 42,600 50,000mesclador 4 750,640 74,000 42,600 50,000empacador 4 950,456 74,000 42,600 25,000moldeador 4 750,504 74,000 42,600 50,000empacadora 10 800,555 74,000 42,600 25,000empacadora 985,000 74,000 42,600 25,000JEFE 3,000,000 100,000 60,000 50,000conductor 3 755,000 74,000 42,600 50,000empacadora 5 800,000 74,000 42,600 25,000empacadora8 855,600 74,000 42,600 50,000moldeadora 5 780,900 74,000 42,600 50,000empacador 9 807,700 74,000 42,600 25,000mesclador 5 780,550 74,000 42,600 25,000empador 6 800,000 74,000 42,600 25,000mesclador 6 950,500 74,000 42,600 25,000ADMINISTRADORA 1,000,000 85,000 50,000 25,000mesclador 6 800,500 74,000 42,000 50,000empacador 7 755,000 74,000 42,000 25,000GERENTE 900,000 74,000 42,000 25,000secretaria 2 700,500 74,000 42,000 50,000aceador 3 850,000 74,000 42,000 25,000emparacador 12 985,900 74,000 42,000 50,000

Nit: 08300544052 

Page 4: Trabajo Numero 3 de excel

mesclador 7 754,000 74,000 42,000 25,000mesclador 8 856,100 74,000 42,000 50,000mescladora 7 750,000 74,000 42,000 50,000aceadora2 875,055 74,000 42,000 50,000aceador 1 980,560 74,000 42,000 50,000empacador 3 800,000 74,000 42,000 50,000

Page 5: Trabajo Numero 3 de excel

TORTAS FONDANT

INGRESOS EGRESOSTOTAL DEV APORTE A S APORTE A P REFERENTETOTAL DE E NETO A PAGAR

841,600 $ 28,000 $ 28,000 $ 56,000 $ 785,600 891,600 $ 30,000 $ 30,000 $ 60,000 $ 831,600 941,600 $ 32,000 $ 32,000 $ 64,000 $ 877,600 810,950 $ 25,774 $ 25,774 $ 51,548 $ 759,402 866,700 $ 28,004 $ 28,004 $ 56,008 $ 810,692 867,100 $ 28,020 $ 28,020 $ 56,040 $ 811,060 966,600 $ 32,000 $ 32,000 $ 64,000 $ 902,600 785,950 $ 25,774 $ 25,774 $ 51,548 $ 734,402 916,600 $ 30,000 $ 30,000 $ 60,000 $ 856,600

1,152,100 $ 39,420 $ 39,420 $ 78,840 $ 1,073,260 1,126,600 $ 39,400 $ 39,400 $ 78,800 $ 1,047,800

916,750 $ 30,006 $ 30,006 $ 60,012 $ 856,738 1,151,750 $ 39,406 $ 39,406 $ 78,812 $ 1,072,938 1,161,700 $ 39,804 $ 39,804 $ 79,608 $ 1,082,092

917,240 $ 30,026 $ 30,026 $ 60,051 $ 857,189 1,092,056 $ 38,018 $ 38,018 $ 76,036 $ 1,016,020

917,104 $ 30,020 $ 30,020 $ 60,040 $ 857,064 942,155 $ 32,022 $ 32,022 $ 64,044 $ 878,111

1,126,600 $ 39,400 $ 39,400 $ 78,800 $ 1,047,800 3,210,000 $ 120,000 $ 120,000 $ 240,000 $ 2,970,000

921,600 $ 30,200 $ 30,200 $ 60,400 $ 861,200 941,600 $ 32,000 $ 32,000 $ 64,000 $ 877,600

1,022,200 $ 34,224 $ 34,224 $ 68,448 $ 953,752 947,500 $ 31,236 $ 31,236 $ 62,472 $ 885,028 949,300 $ 32,308 $ 32,308 $ 64,616 $ 884,684 922,150 $ 31,222 $ 31,222 $ 62,444 $ 859,706 941,600 $ 32,000 $ 32,000 $ 64,000 $ 877,600

1,092,100 $ 38,020 $ 38,020 $ 76,040 $ 1,016,060 1,160,000 $ 40,000 $ 40,000 $ 80,000 $ 1,080,000

966,500 $ 32,020 $ 32,020 $ 64,040 $ 902,460 896,000 $ 30,200 $ 30,200 $ 60,400 $ 835,600

1,041,000 $ 36,000 $ 36,000 $ 72,000 $ 969,000 866,500 $ 28,020 $ 28,020 $ 56,040 $ 810,460 991,000 $ 34,000 $ 34,000 $ 68,000 $ 923,000

1,151,900 $ 39,436 $ 39,436 $ 78,872 $ 1,073,028

Page 6: Trabajo Numero 3 de excel

895,000 $ 30,160 $ 30,160 $ 60,320 $ 834,680 1,022,100 $ 34,244 $ 34,244 $ 68,488 $ 953,612

916,000 $ 30,000 $ 30,000 $ 60,000 $ 856,000 1,041,055 $ 35,002 $ 35,002 $ 70,004 $ 971,051 2,298,310 $ 39,222 $ 39,222 $ 78,445 $ 2,219,865

966,000 $ 32,000 $ 32,000 $ 64,000 $ 902,000