Ejercicio Repaso

Cédula

Apellido1

77287259 Correa 38116972 Salazar 58210093 Sepúlveda 39393623 Gómez 46713657 Arango 68621220 Castaño 93900215 Sandoval 89303653 Vargas 74099942 Monsalve 89762571 García 59504273 Ospina 60730707 Aristizabal 58646130 Arango 36672687 Marín 39119428 Galeano 68635730 Salazar 83601635 Sánchez 77606220 Castaño 40363111 Cardona 94357033 Aristizábal 66842136 López 79446662 Carmona 82592656 Gómez 42702775 Cardona 66415048 López 57448806 Zuluaga 76289808 Morales 52085441 Gutiérrez 78590593 Correa 73346727 Noreña 53697593 Aristrizábal 51608669 Medina 52021388 Alzate 73040298 Monsalve 58193914 Giraldo 61101862 Jaramillo 91641986 González 81042918 Ciro 71852510 Jaramillo 56410067 Muñoz 94439310 Pérez 94401757 Quintero 41955498 Sandoval 77734950 Moreno 75333344 Alzate 32964907 Vahos 68944217 Arango 44628974 López 50022035 García

Apellido2

Nombre

Isaza Noreña Giraldo Duque Zuluaga Ospina Giraldo Agudelo Vasco Vásquez Holguin Rincón Gómez López Giraldo Salazar Cano Vasco Osorio Ortega Giraldo Correa Ortega Yepes Gildardo Giraldo Arango Goméz Arboleda García Acosta Salazar Sierra Cardona Morales Quintero Jaramillo Arboleda González Alvarez Gómez Noreña López Duque Arango Giraldo Acosta Goméz Jaramillo

Manuel María Nora María Mario Roberto Luz Horacio Jesús Jesús Reinaldo Ofelia Ricardo Teresita Alejandrino Emilio Pedro Elias Emilio Elvia Ivan Emilia Antonio Antonio Dilia Nicolás Rafael Edilma Ramiro Elvira Emilio María Eva Pascual Eduardo Isaac Claver León Ovidio Alfonso María Arturo Mary Angel Eduardo Alberto Benjamín Rigoberto Nicolás

DATOS Ventas Prestamo Cali 6,940,000 3,083,250 Cali 5,690,000 4,981,608 Pereira 4,830,000 5,651,088 Medellín 5,570,000 1,952,185 Medellín 4,670,000 470,193 Pereira 7,570,000 314,214 Barranquilla 6,510,000 2,233,147 Barranquilla 3,080,000 2,244,608 Cali 6,670,000 3,668,596 Pereira 9,640,000 6,522,279 Bogotá 3,450,000 513,254 Medellín 7,060,000 1,710,922 Medellín 6,180,000 2,632,092 Barranquilla 5,580,000 2,791,692 Barranquilla 9,800,000 3,046,264 Medellín 9,290,000 800,476 Bogotá 7,870,000 3,001,259 Cali 8,090,000 3,544,389 Bogotá 1,720,000 5,146,511 Barranquilla 1,380,000 1,931,673 Bogotá 3,320,000 6,119,803 Barranquilla 4,310,000 1,218,997 Barranquilla 2,970,000 2,817,566 Bogotá 5,770,000 129,618 Bogotá 2,280,000 1,207,601 Cali 1,130,000 3,283,919 Barranquilla 9,960,000 1,358,471 Bogotá 8,580,000 2,857,448 Barranquilla 3,800,000 4,149,537 Cali 7,620,000 2,753,844 Pereira 2,640,000 3,181,374 Medellín 7,100,000 2,063,672 Cali 4,200,000 1,448,741 Barranquilla 4,690,000 1,071,858 Bogotá 5,470,000 3,132,480 Medellín 1,400,000 850,446 Barranquilla 7,940,000 2,122,431 Barranquilla 5,090,000 3,712,178 Cali 1,990,000 2,972,333 Cali 2,430,000 922,837 Pereira 7,740,000 1,979,654 Bogotá 9,000,000 2,536,656 Pereira 9,760,000 5,613,092 Barranquilla 3,220,000 297,748 Medellín 6,390,000 1,683,819 Barranquilla 5,220,000 447,137 Medellín 5,830,000 5,040,009 Medellín 6,790,000 3,326,986 Pereira 1,730,000 3,577,610 Ciudad

40139064 Zuluaga 90013486 Jaramillo 85907204 Cardona 60456569 Sandoval 52315312 Salazar 78892420 Gómez 41122227 Gil 64428281 Yepes 45749024 Cardona 73099008 Palacio 76067448 Zuluaga 71926555 Quintero 70183384 Sierra 80546907 Mejía 60891804 García 36168074 Cardona 95042741 Botero 88316473 Parra 57869600 Salazar 84302140 Noreña 48372156 Isaza 60840015 Mejía 60604213 Goméz 47593548 Díaz 58723409 Arbeláez 68415010 Restrepo 58359749 Salazar 73909003 Sandoval 71514866 Ortega 60222055 Arboleda 86562308 Gildardo 41443183 Osorio 80746640 Gómez 65293849 González 73753791 Rincón 50131941 Lozano 70354094 Zuluaga 55270538 Serna 76148378 Cifuentes 75252456 Muñoz 84392653 Muñoz 51746191 Quintero 40714413 Duque 88692472 Alvarez 93261546 Cano 59515448 Correa 34157007 Ramírez 73170142 Yepes 97062249 Agudelo 46426932 Duque 85472120 Montoya

Ospina Gutiérrez Jaramillo Isaza Cardona Agudelo Arango Cano Arango Gutiérrez Vásquez Arboleda Arango Castaño García Salazar Cifuentes Yepes Gildardo González Parra Monsalve Aristizabal Alvarez Agudelo Osorio Aristizábal García Noreña Agudelo Salazar Cano Duque Salazar Aristizábal Isaza Correa González Díaz Holguin Agudelo García Zuluaga Goméz Giraldo Salazar Gómez Sierra Quintero Zuluaga Salazar

Ramón Adriana Raimundo William Neira César Emilio Jesús Jesús Beatriz Octavio Lucia Jairo Jacob Pablo Javier Nolasco Patricia Rosa Patricia Alonso Alberto Ramón Yaneth Emilio Robeiro Elena Sergio Alfonso Dario José Antonio Humberto Raúl Hurtado León Ruben Hernán Erasmo Antonio Eugenia Jesús Andrea Raúl Dario Dario Elena Pedro Jesús María Ofelia

Bogotá Bogotá Barranquilla Cali Medellín Cali Pereira Bogotá Cali Pereira Medellín Cali Bogotá Barranquilla Bogotá Medellín Barranquilla Pereira Bogotá Pereira Medellín Bogotá Barranquilla Barranquilla Bogotá Medellín Cali Bogotá Bogotá Pereira Bogotá Bogotá Barranquilla Cali Pereira Medellín Bogotá Bogotá Cali Barranquilla Medellín Barranquilla Medellín Bogotá Medellín Pereira Bogotá Medellín Barranquilla Barranquilla Bogotá

9,640,000 8,390,000 6,510,000 5,920,000 6,720,000 5,980,000 5,070,000 4,830,000 9,800,000 8,430,000 7,520,000 6,680,000 1,880,000 3,860,000 5,710,000 3,970,000 3,800,000 3,570,000 4,940,000 2,020,000 1,560,000 9,610,000 4,410,000 4,090,000 5,260,000 4,970,000 7,420,000 5,100,000 7,160,000 2,530,000 3,570,000 8,920,000 5,120,000 6,310,000 4,230,000 8,490,000 4,000,000 5,110,000 1,740,000 8,450,000 8,920,000 5,880,000 5,050,000 1,350,000 6,020,000 2,410,000 6,700,000 5,500,000 8,520,000 6,920,000 3,270,000

1,110,821 716,060 1,888,455 2,087,909 2,457,527 6,179,754 1,873,955 3,018,855 2,448,352 3,009,077 2,938,499 6,187,221 2,200,825 966,815 2,691,014 2,538,564 3,196,356 740,795 5,665,499 4,988,451 2,167,048 3,163,843 475,009 324,327 5,388,431 2,438,062 1,611,989 230,959 4,988,368 6,189,400 2,125,348 685,498 3,706,078 736,415 1,192,283 4,193,769 3,036,913 5,074,018 813,234 1,631,615 248,694 2,000,992 658,419 802,672 1,319,676 4,323,564 3,999,061 1,402,350 3,917,554 4,424,377 95,415

34691441 Escobar 86783164 Muñoz 93410665 Acosta 43120364 Gil 58267064 Acosta 62000815 Gómez 65212938 Agudelo 93427054 Arango 51932438 Agudelo 43921780 Jaramillo 74779319 Giraldo 94205343 Agudelo 62150219 Fernández 96850239 Goméz 71164873 Holguin 33633607 Agudelo 61907908 Jaramillo 39885031 Giraldo 57451132 Vásquez 59951581 Cuartas 59611799 Duque 39588425 Vasco 94375356 Salazar 54721930 Jiménez 72901182 Sandoval

Aristizabal Monsalve Cardona Morales Salazar Vahos Arango Aristizabal Cardona Alvarez Aristrizábal Zuluaga Correa Zuluaga Correa Correa Vahos Muñoz Vasco Noreña Salazar López Cifuentes Díaz Gildardo

Andrea Herminia José Violeta Mario Hugo Adolfo Pablo Antonio Helena Gorethy Piedad Paulina Anibal Tulio Milena Adela Antonio León Ibel Esther Otilia Nolasco Ovidio Joao

Cali Cali Cali Medellín Pereira Cali Barranquilla Bogotá Bogotá Medellín Bogotá Bogotá Barranquilla Cali Pereira Cali Pereira Cali Pereira Bogotá Cali Bogotá Cali Barranquilla Cali

7,110,000 9,480,000 6,260,000 5,940,000 1,450,000 7,950,000 8,890,000 5,120,000 8,960,000 3,580,000 10,000,000 5,900,000 8,540,000 5,340,000 8,820,000 1,860,000 3,970,000 5,260,000 6,260,000 6,130,000 5,850,000 7,980,000 1,630,000 1,010,000 7,220,000

704,300,000

2,965,495 1,636,393 1,210,492 1,726,151 3,736,500 3,323,915 2,942,700 5,729,764 4,352,551 60,040 1,607,016 1,768,377 1,624,407 2,835,197 339,953 5,005,291 3,174,958 2,880,421 990,722 2,313,337 4,725,693 486,230 487,889 1,156,790 80,128

xcxcx xcx

Salario Basico 647,000 1,317,000 1,406,000 948,000 1,372,000 1,277,000 1,023,000 1,034,000 1,031,000 1,435,000 678,000 1,321,000 548,000 721,000 860,000 1,069,000 826,000 1,181,000 1,068,000 1,279,000 1,384,000 1,336,000 946,000 1,254,000 1,024,000 733,000 716,000 1,384,000 1,245,000 1,061,000 1,206,000 789,000 1,458,000 981,000 1,171,000 808,000 634,000 1,137,000 1,457,000 515,000 1,015,000 626,000 1,247,000 1,116,000 698,000 1,133,000 1,022,000 1,468,000 1,122,000

Tiene prestamo No Si Si No No Si No Si No Si No No No No No Si No Si No Si Si Si No Si No Si No Si Si No No Si No No Si No No Si Si Si No Si No No No No No No Si

DEVENGADO Auxilio de transporte Bonificacion comisión 59000 138,800 5% 0 113,800 5% 0 96,600 3% 59000 111,400 5% 0 93,400 3% 0 151,400 5% 0 130,200 5% 0 61,600 3% 0 133,400 5% 0 192,800 5% 59000 69,000 3% 0 141,200 5% 59000 123,600 5% 59000 111,600 5% 59000 196,000 5% 0 185,800 5% 59000 157,400 5% 0 161,800 5% 0 34,400 3% 0 27,600 3% 0 66,400 3% 0 86,200 3% 59000 59,400 3% 0 115,400 5% 0 45,600 3% 59000 22,600 3% 59000 199,200 5% 0 171,600 5% 0 76,000 3% 0 152,400 5% 0 52,800 3% 59000 142,000 5% 0 84,000 3% 59000 93,800 3% 0 109,400 5% 59000 28,000 3% 59000 158,800 5% 0 101,800 5% 0 39,800 3% 59000 48,600 3% 0 154,800 5% 59000 180,000 5% 0 195,200 5% 0 64,400 3% 59000 127,800 5% 0 104,400 5% 0 116,600 5% 0 135,800 5% 0 34,600 3%

834,000 1,462,000 1,461,000 896,000 1,321,000 1,439,000 639,000 1,013,000 996,000 1,415,000 722,000 1,300,000 1,111,000 853,000 1,344,000 733,000 994,000 1,009,000 1,220,000 1,167,000 974,000 660,000 659,000 694,000 1,154,000 576,000 821,000 1,128,000 1,234,000 1,456,000 1,130,000 1,353,000 770,000 1,172,000 607,000 850,000 1,102,000 1,312,000 963,000 660,000 861,000 1,122,000 986,000 1,063,000 1,279,000 1,256,000 1,003,000 692,000 1,275,000 1,444,000 978,000

Si Si No Si Si No Si No Si No No No No Si Si No Si No Si Si No Si No Si No Si Si No No No Si No No No Si No Si Si No No No No No No No Si Si Si No No No

59000 0 0 59000 0 0 59000 0 59000 0 59000 0 0 59000 0 59000 59000 0 0 0 59000 59000 59000 59000 0 59000 59000 0 0 0 0 0 59000 0 59000 59000 0 0 59000 59000 59000 0 59000 0 0 0 0 59000 0 0 59000

192,800 167,800 130,200 118,400 134,400 119,600 101,400 96,600 196,000 168,600 150,400 133,600 37,600 77,200 114,200 79,400 76,000 71,400 98,800 40,400 31,200 192,200 88,200 81,800 105,200 99,400 148,400 102,000 143,200 50,600 71,400 178,400 102,400 126,200 84,600 169,800 80,000 102,200 34,800 169,000 178,400 117,600 101,000 27,000 120,400 48,200 134,000 110,000 170,400 138,400 65,400

5% 5% 5% 5% 5% 5% 5% 3% 5% 5% 5% 5% 3% 3% 5% 3% 3% 3% 3% 3% 3% 5% 3% 3% 5% 3% 5% 5% 5% 3% 3% 5% 5% 5% 3% 5% 3% 5% 3% 5% 5% 5% 5% 3% 5% 3% 5% 5% 5% 5% 3%

896,000 513,000 502,000 864,000 765,000 1,109,000 613,000 1,168,000 1,041,000 1,107,000 989,000 513,000 1,271,000 1,478,000 984,000 1,385,000 731,000 1,069,000 714,000 816,000 1,265,000 637,000 1,026,000 1,337,000 851,000

Si No No Si No No No Si Si No No No Si Si No Si No Si Si No No No No No Si

59000 59000 59000 59000 59000 0 59000 0 0 0 59000 59000 0 0 59000 0 59000 0 59000 59000 0 59000 0 0 59000

142,200 189,600 125,200 118,800 29,000 159,000 177,800 102,400 179,200 71,600 200,000 118,000 170,800 106,800 176,400 37,200 79,400 105,200 125,200 122,600 117,000 159,600 32,600 20,200 144,400

5% 5% 5% 5% 3% 5% 5% 5% 5% 3% 5% 5% 5% 5% 5% 3% 3% 5% 5% 5% 5% 5% 3% 3% 5%

DEDUCIDO Total devengado Seguridad social Cuota prestamo Total deducido neto 844,800 44,643 10,093 54,736 790,064 1,430,800 0 20,545 20,545 1,410,255 1,502,600 0 21,934 21,934 1,480,666 1,118,400 0 14,789 14,789 1,103,611 1,465,400 0 21,403 21,403 1,443,997 1,428,400 0 19,921 19,921 1,408,479 1,153,200 0 15,959 15,959 1,137,241 1,095,600 0 16,130 16,130 1,079,470 1,164,400 0 16,084 16,084 1,148,316 1,627,800 0 22,386 22,386 1,605,414 806,000 46,782 10,577 57,359 748,641 1,462,200 0 20,608 20,608 1,441,592 730,600 37,812 8,549 46,361 684,239 891,600 49,749 11,248 60,997 830,603 1,115,000 59,340 13,416 72,756 1,042,244 1,254,800 0 16,676 16,676 1,238,124 1,042,400 56,994 12,886 69,880 972,520 1,342,800 0 18,424 18,424 1,324,376 1,102,400 0 16,661 16,661 1,085,739 1,306,600 0 19,952 19,952 1,286,648 1,450,400 0 21,590 21,590 1,428,810 1,422,200 0 20,842 20,842 1,401,358 1,064,400 0 14,758 14,758 1,049,642 1,369,400 0 19,562 19,562 1,349,838 1,069,600 0 15,974 15,974 1,053,626 814,600 50,577 11,435 62,012 752,588 974,200 49,404 11,170 60,574 913,626 1,555,600 0 21,590 21,590 1,534,010 1,321,000 0 19,422 19,422 1,301,578 1,213,400 0 16,552 16,552 1,196,848 1,258,800 0 18,814 18,814 1,239,986 990,000 54,441 12,308 66,749 923,251 1,542,000 0 22,745 22,745 1,519,255 1,133,800 0 15,304 15,304 1,118,496 1,280,400 0 18,268 18,268 1,262,132 895,000 55,752 12,605 68,357 826,643 851,800 43,746 9,890 53,636 798,164 1,238,800 0 17,737 17,737 1,221,063 1,496,800 0 22,729 22,729 1,474,071 622,600 35,535 8,034 43,569 579,031 1,169,800 0 15,834 15,834 1,153,966 865,000 43,194 9,766 52,960 812,040 1,442,200 0 19,453 19,453 1,422,747 1,180,400 0 17,410 17,410 1,162,990 884,800 48,162 10,889 59,051 825,749 1,237,400 0 17,675 17,675 1,219,725 1,138,600 0 15,943 15,943 1,122,657 1,603,800 0 22,901 22,901 1,580,899 1,156,600 0 17,503 17,503 1,139,097

1,085,800 1,629,800 1,591,200 1,073,400 1,455,400 1,558,600 799,400 1,109,600 1,251,000 1,583,600 931,400 1,433,600 1,148,600 989,200 1,458,200 871,400 1,129,000 1,080,400 1,318,800 1,207,400 1,064,200 911,200 806,200 834,800 1,259,200 734,400 1,028,400 1,230,000 1,377,200 1,506,600 1,201,400 1,531,400 931,400 1,298,200 750,600 1,078,800 1,182,000 1,414,200 1,056,800 888,000 1,098,400 1,239,600 1,146,000 1,090,000 1,399,400 1,304,200 1,137,000 861,000 1,445,400 1,582,400 1,102,400

57,546 0 0 61,824 0 0 44,091 0 0 0 49,818 0 0 58,857 0 50,577 0 0 0 0 0 45,540 45,471 47,886 0 39,744 56,649 0 0 0 0 0 53,130 0 41,883 58,650 0 0 0 45,540 59,409 0 0 0 0 0 0 47,748 0 0 0

13,010 22,807 22,792 13,978 20,608 22,448 9,968 15,803 15,538 22,074 11,263 20,280 17,332 13,307 20,966 11,435 15,506 15,740 19,032 18,205 15,194 10,296 10,280 10,826 18,002 8,986 12,808 17,597 19,250 22,714 17,628 21,107 12,012 18,283 9,469 13,260 17,191 20,467 15,023 10,296 13,432 17,503 15,382 16,583 19,952 19,594 15,647 10,795 19,890 22,526 15,257

70,556 22,807 22,792 75,802 20,608 22,448 54,059 15,803 15,538 22,074 61,081 20,280 17,332 72,164 20,966 62,012 15,506 15,740 19,032 18,205 15,194 55,836 55,751 58,712 18,002 48,730 69,457 17,597 19,250 22,714 17,628 21,107 65,142 18,283 51,352 71,910 17,191 20,467 15,023 55,836 72,841 17,503 15,382 16,583 19,952 19,594 15,647 58,543 19,890 22,526 15,257

1,015,244 1,606,993 1,568,408 997,598 1,434,792 1,536,152 745,341 1,093,797 1,235,462 1,561,526 870,319 1,413,320 1,131,268 917,036 1,437,234 809,388 1,113,494 1,064,660 1,299,768 1,189,195 1,049,006 855,364 750,449 776,088 1,241,198 685,670 958,943 1,212,403 1,357,950 1,483,886 1,183,772 1,510,293 866,258 1,279,917 699,248 1,006,890 1,164,809 1,393,733 1,041,777 832,164 1,025,559 1,222,097 1,130,618 1,073,417 1,379,448 1,284,606 1,121,353 802,457 1,425,510 1,559,874 1,087,143

1,097,200 761,600 686,200 1,041,800 853,000 1,268,000 849,800 1,270,400 1,220,200 1,178,600 1,248,000 690,000 1,441,800 1,584,800 1,219,400 1,422,200 869,400 1,174,200 898,200 997,600 1,382,000 855,600 1,058,600 1,357,200 1,054,400

61,824 35,397 34,638 59,616 52,785 0 42,297 0 0 0 0 35,397 0 0 0 0 50,439 0 49,266 56,304 0 43,953 0 0 58,719

13,978 8,003 7,831 13,478 11,934 17,300 9,563 18,221 16,240 17,269 15,428 8,003 19,828 23,057 15,350 21,606 11,404 16,676 11,138 12,730 19,734 9,937 16,006 20,857 13,276

75,802 43,400 42,469 73,094 64,719 17,300 51,860 18,221 16,240 17,269 15,428 43,400 19,828 23,057 15,350 21,606 61,843 16,676 60,404 69,034 19,734 53,890 16,006 20,857 71,995

1,021,398 718,200 643,731 968,706 788,281 1,250,700 797,940 1,252,179 1,203,960 1,161,331 1,232,572 646,600 1,421,972 1,561,743 1,204,050 1,400,594 807,557 1,157,524 837,796 928,566 1,362,266 801,710 1,042,594 1,336,343 982,405

EN LA HOJA VENDEDORES PUNTO 1 La cantidad de vendedores por ciudad en el siguiente cuadro Ciudad Medellín Cali Pereira Bogotá Barranquilla

Total 22 26 18 32 27

PUNTO 2 Grafique los sueldos mayores a 1'000.000 Grafique la ventas de los empleados de pereira PUNTO 3

- Si el salario basico es mayor de 400.000 pero menor a 1'000.000 el auxilio de transporte es de 59000 de lo contrario 0 - La cuota constante para el préstamo para cada vendedor, si la tasa de interés es del 1,56% mensual, sobre el salario basic - Promedio de ventas de la compañía - Hallar el numero de empleados - Hallar las ventas menores a 5000.000

PUNTO 4

- Si elsalario esta entre 300.000 y 500.000 la segurida social es del 3,3%, si el salario basico es mayor que 500.000 y menor 6,9% al resto de 8,5% - Si las ventas totales de la compañía superan los 700 millones, todos los vendedores reciben una bonificación del 2% sobre sus ventas, de lo contrario la bonificación es cero - La comisión es del 5% (sobre ventas) para quienes vendieron más de 5 millones y del 3% (sobre ventas) para los demás - Hallar el neto a pagar - Hallar mayor y menor el neto a pagar - realizar formulario

ventas menores 5000000 empleados menor neto mayor neto promedio ventas

46 125 1606993 579031 5634400

9000 de lo contrario 0 sual, sobre el salario basico

ayor que 500.000 y menor a 900.000 la seguridad social es de

CEDULA:

APELLIDO:

TOTAL DUCIDO:

NOMBRE:

39393623

14788.89

María

Gómez

NETO:

CIUDAD:

Medellín