Ejercicio 1NOMBRESEXOEDAD (aos)ESTATURA (cms)PAISCINDYF17161VENEZUELACAROLINAF18163BRASILRODRIGOM19178ECUADORMONICAF22162BRASILSONIAF23164EL SALVADORNURIAF24163NICARAGUARODOLFOM24183MEXICOKAROLINEF25159EL SALVADORMIRELLAF25162USAROXANAF25160EL SALVADORTERESAF25173EL SALVADORMARCELAF26163VENEZUELAVANESSAF26157ARGENTINAMONICAF27174ECUADORJHONM27186USAJUANM27170NICARAGUAFABIOLAF28160ECUADORKARLAF28174VENEZUELASAULM28166GUATEMALAMAURICIOM29190GUATEMALALORENAF30167BRASILVALERIAF30170MEXICOLUISM30178GUATEMALAMARCOM32175EL SALVADORMABELF34168ARGENTINAMICHAELM34187USASARAF35160EL SALVADORMIGUELM35175NICARAGUAMOISESM36180ECUADORRONALDOM38180GUATEMALAKATHERINF45158EL SALVADORMATILDEF45160EL SALVADORRAULM45173GUATEMALAFRANCISCOM50178GUATEMALADOMINGOM55165NICARAGUA

Ejercicio 2NOMBREPAISSEXOEDAD (aos)ESTATURA (cms)CAROLINABRASILF18163CINDYVENEZUELAF17161DOMINGONICARAGUAM55165FABIOLAECUADORF28160FRANCISCOGUATEMALAM50178JHONUSAM27186JUANNICARAGUAM27170KARLAVENEZUELAF28174KAROLINEEL SALVADORF25159KATHERINEL SALVADORF45158LORENABRASILF30167LUISGUATEMALAM30178MABELARGENTINAF34168MARCELAVENEZUELAF26163MARCOEL SALVADORM32175MATILDEEL SALVADORF45160MAURICIOGUATEMALAM29190MICHAELUSAM34187MIGUELNICARAGUAM35175MIRELLAUSAF25162MOISESECUADORM36180MONICAECUADORF27174MONICABRASILF22162NURIANICARAGUAF24163RAULGUATEMALAM45173RODOLFOMEXICOM24183RODRIGOECUADORM19178RONALDOGUATEMALAM38180ROXANAEL SALVADORF25160SARAEL SALVADORF35160SAULGUATEMALAM28166SONIAEL SALVADORF23164TERESAEL SALVADORF25173VALERIAMEXICOF30170VANESSAARGENTINAF26157

Ejercicio 3NOMBREPAISSEXOEDAD (aos)ESTATURA (cms)CAROLINABRASILF18163CINDYVENEZUELAF17161DOMINGONICARAGUAM55165FABIOLAECUADORF28160FRANCISCOGUATEMALAM50178JHONUSAM27186JUANNICARAGUAM27170KARLAVENEZUELAF28174KAROLINEEL SALVADORF25159KATHERINEL SALVADORF45158LORENABRASILF30167LUISGUATEMALAM30178MABELARGENTINAF34168MARCELAVENEZUELAF26163MARCOEL SALVADORM32175MATILDEEL SALVADORF45160MAURICIOGUATEMALAM29190MICHAELUSAM34187MIGUELNICARAGUAM35175MIRELLAUSAF25162MOISESECUADORM36180MONICAECUADORF27174MONICABRASILF22162NURIANICARAGUAF24163RAULGUATEMALAM45173RODOLFOMEXICOM24183RODRIGOECUADORM19178RONALDOGUATEMALAM38180ROXANAEL SALVADORF25160SARAEL SALVADORF35160SAULGUATEMALAM28166SONIAEL SALVADORF23164TERESAEL SALVADORF25173VALERIAMEXICOF30170VANESSAARGENTINAF26157

Ejercicios 4zonavendedor1 Trimestre2 Trimestre3 Trimestre4 TrimestreSubtotalIVAVenta TotalComisinCENTRALJuan$1,200.00$1,300.00$1,400.00$1,500.00ORIENTALRoxana$800.00$900.00$850.00$950.00OCCIDENTALMarcos$700.00$1,200.00$850.00$750.00CENTRALLaura$1,000.00$900.00$875.00$900.00CENTRALSofia$1,200.00$1,000.00$800.00$950.00CENTRALKaren$900.00$1,000.00$1,200.00$800.00ORIENTALPablo$1,000.00$1,500.00$1,300.00$950.00IVA13%

Tabla 1aZonaTipoEneroFebreroMarzoTotal 1er Trim.AbrilMayoJunioTotal 2do Trim.OrientalNissan$50,000.00$60,000.00$55,000.00$150,000.00$200,000.00$400,000.00occidentalToyota$75,000.00$76,000.00$75,500.00$250,000.00$350,000.00$250,000.00OrientalToyota$80,000.00$81,000.00$80,500.00$70,000.00$350,000.00$125,000.00occidentalNissan$100,000.00$100,000.00$100,000.00$50,000.00$375,000.00$325,000.00CentralHyundai$75,000.00$76,000.00$75,500.00$80,000.00$450,000.00$275,000.00OrientalHyundai$80,000.00$81,000.00$80,500.00$150,000.00$400,000.00$300,000.00occidentalHyundai$60,000.00$61,000.00$60,500.00$300,000.00$325,000.00$425,000.00CentralNissan$60,000.00$61,000.00$60,500.00$350,000.00$500,000.00$400,000.00CentralToyota$70,000.00$71,000.00$70,500.00$475,000.00$625,000.00$200,000.00

Ejercicio 6Fecha de ordenVendedorStatusEmpresaTotalDescuentoMonto a PagarSe asigna un descuento especial a clientes Nuevos o recurrente si cumples:1. El status es Nuevo el descuento otorgado sera del 12%2. El status es Recurrente y el total mayor o igual a $1,000.00, el descuento otorgado sera del 8.5%3. Si no cumple con ninguna de las anteriores se asigna 0 descuento.

6/5/06Francisco ChavesRecurrenteZ$2,300.006/5/06Francisco ChavesRecurrenteY$7,000.004/5/06Francisco ChavesRecurrenteY$205.003/10/06Francisco ChavesRecurrenteBB$13,810.002/6/06Francisco ChavesRecurrenteD$188.004/5/06Francisco ChavesEventualesZ$1,435.251/15/06Francisco ChavesEventualesAA$1,705.005/11/06Francisco ChavesNuevoBB$235.004/7/06Francisco ChavesNuevoD$96.004/22/06Francisco ChavesNuevoAA$963.006/5/06Humberto AcevedoRecurrenteI$196.504/5/06Humberto AcevedoEventualesA$3,790.00Monto a pagar= Total Facturado - Descuento4/3/06Jess EscolarRecurrenteF$127.504/25/06Jess EscolarNuevoC$1,000.004/25/06Jess EscolarNuevoD$380.006/23/06Jess EscolarRecurrenteF$2,490.004/30/06Juan Carlos RivasRecurrenteH$1,442.00`4/8/06Juan Carlos RivasRecurrenteF$4,500.006/8/06Juan Carlos RivasEventualesF$810.001/30/06Juan Carlos RivasEventualesBB$326.003/6/06Luis BonifazRecurrenteF$692.005/9/06Luis BonifazNuevoF$750.006/7/06Mara GonzlezRecurrenteBB$270.004/5/06Mara GonzlezRecurrenteCC$1,418.004/7/06Mara GonzlezRecurrenteBB$1,442.503/24/06Mara GonzlezEventualesJ$562.005/24/06Mara GonzlezNuevoA$736.005/24/06Mara GonzlezNuevoK$800.005/24/06Mara GonzlezNuevoJ$52.503/24/06Mara GonzlezNuevoA$1,674.753/24/06Mara GonzlezNuevoK$219.503/24/06Mara GonzlezNuevoG$13,800.006/5/06Mara GonzlezRecurrenteCC$1,760.006/5/06Mara Jess CuestaRecurrenteH$560.005/24/06Mara Jess CuestaRecurrenteJ$209.004/25/06Mara Jess CuestaRecurrenteC$627.003/24/06Mara Jess CuestaRecurrenteK$607.002/23/06Mara Jess CuestaRecurrenteC$1,937.001/22/06Mara Jess CuestaRecurrenteAA$1,195.004/5/06Mara Jess CuestaEventualesH$1,280.004/22/06Mara Jess CuestaNuevoL$84.004/22/06Pilar Pinilla GallegoRecurrenteD$3,525.003/22/06Pilar Pinilla GallegoRecurrenteH$1,280.002/10/06Pilar Pinilla GallegoRecurrenteCC$134.501/20/06Pilar Pinilla GallegoRecurrenteCC$870.004/12/06Pilar Pinilla GallegoEventualesCC$456.005/24/06Pilar Pinilla GallegoNuevoH$50.00