Download - Tarea de evaluacion si anidado

Transcript
Page 1: Tarea de evaluacion si anidado

CODIGO DESCRIPCION MARCA PRECIO 1 PRECIO 2 CANTIDAD SUBTOTAL

1SUBTOTA

L 2DESCUENTO

1DESCUENTO

2 IVA 12 % TOTAL A PAGAR

ART1 REFRIGERADORA INDURAMA 1.300,0 1.500,0 50 65.000,0 75.000,0 4.550,0 13.500,0 9.000,0 65.950,0

ART2AIRE ACONDICIONADO LG 1.100,0 1.800,0 68 74.800,0 122.400,0 5.236,0 22.032,0 14.688,0 109.820,0

ART3 MICROHONDAS INDURAMA 350,0 650,0 30 10.500,0 19.500,0 420,0 2.340,0 2.340,0 19.080,0

ART4 LAPTOP SONY 1.200,0 1.700,0 75 90.000,0 127.500,0 6.300,0 22.950,0 15.300,0 113.550,0

ART5 LICUADORA OSTER 80,0 120,0 90 7.200,0 10.800,0 216,0 1.188,0 1.296,0 10.692,0

ART6 TELEVISOR SONY 1.500,0 2.200,0 48 72.000,0 105.600,0 5.040,0 19.008,0 12.672,0 94.224,0

ART7 OLLA ARROCERA OSTER 70,0 95,0 50 3.500,0 4.750,0 105,0 475,0 570,0 4.740,0

ART8 DVD SAMSUNG 140,0 160,0 30 4.200,0 4.800,0 126,0 480,0 576,0 4.770,0

ART9 LAVADORA LG 1.120,0 1.300,0 70 78.400,0 91.000,0 5.488,0 16.380,0 10.920,0 80.052,0

ART10 COCINA INDURAMA 1.400,0 1.650,0 43 60.200,0 70.950,0 4.214,0 12.771,0 8.514,0 62.479,0

TOTALES GENERALES 8.260,0 11.175,0 554,0 465.800,0 632.300,0 31.695,0 111.124,0 75.876,0 565.357,0PROMEDIO 826,0 1.117,5 55,4 46.580,0 63.230,0 3.169,5 11.112,4 7.587,6 56.535,7VALOR MAXIMO 1.500,0 2.200,0 90,0 90.000,0 127.500,0 6.300,0 22.950,0 15.300,0 113.550,0VALOR MINIMO 70,0 95,0 30,0 3.500,0 4.750,0 105,0 475,0 570,0 4.740,0VALOR MEDIANO 1.110,0 1.400,0 50,0 62.600,0 72.975,0 4.382,0 13.135,5 8.757,0 64.214,5VALOR REPETIDO #N/A #N/A 50,0 #N/A #N/A #N/A #N/A #N/A #N/A

Tabla de DescuentosVALOR DESCUENTO 1 DESCUENTO 210000 3% 10%15000 4% 11%20000 5% 12%25000 6% 15%

>25000 7% 18%

MARCASOSTER 2INDURAMA 3SONY 2SAMSUNG 1LG 2

IVA12%