Tarea de evaluacion si anidado

CODIG O DESCRIPCION MARCA PRECIO 1 PRECIO 2 CANTIDAD SUBTOTA L 1 SUBTOTA L 2 DESCUENT O 1 DESCUENT O 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 ART2 AIRE 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,0 PROMEDIO 826,0 1.117,5 55,4 46.580, 0 63.230, 0 3.169,5 11.112,4 7.587,6 56.535,7 VALOR 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,0 VALOR MINIMO 70,0 95,0 30,0 3.500,0 4.750,0 105,0 475,0 570,0 4.740,0 VALOR 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,5 VALOR REPETIDO #N/A #N/A 50,0 #N/A #N/A #N/A #N/A #N/A #N/A

Upload
keniautm
Category

Education
view
22
download
8

Embed Size (px):

Transcript of 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%