taller

Post on 21-Dec-2015

13 Views

Category:

Documents

0 Downloads

Preview:

Click to see full reader

DESCRIPTION

EXCEL

TRANSCRIPT

TABLA 2

1 POR 2 ES IGUAL 22 POR 2 ES IGUAL 43 POR 2 ES IGUAL 64 POR 2 ES IGUAL 85 POR 2 ES IGUAL 106 POR 2 ES IGUAL 127 POR 2 ES IGUAL 148 POR 2 ES IGUAL 169 POR 2 ES IGUAL 18

10 POR 2 ES IGUAL 20

Construccions ¡ promocions DATOS DEL CLIENTEC/Sa Murada , 3

Maho´n _MenorcaTEL: 971 36 41 55

CODIGO NOMBRE CANTIDAD PRECIO TOTAL

8001 Gravilla 0 200 10000

8300 Baldosa M3E 2345 3224

9001 Cemento Porlant c50 4555 233

9554 Toxos 4567 23

4002 Boques 345 324

3002 Biguetas 40*50 3897 23345

2000 Diversos 765 2345

SUMA 39494

GASTOS FAMILIARES DEL AÑO 2003

ENERO FEBRERO MARZO 1,TRIMESTRELUZ 32.56 43.63 48.84 125.03AGUA 23.54 31.54 35.31 90.39GAS 36.06 48.32 54.09 138.47TELEFONO 76.87 103.01 115.305 295.185CREDITO 546.78 732.69 820.17 2099.64COMIDA 607.64 814.24 911.46 2333.34VARIOS 155.67 208.6 233.505 597.775

TOTALES 1479.12 1982.03 2218.68 5679.83

1256

ENCUESTA

NOMBRE ESTATURAN° HERMANOS N° HER. PADRE N° HER MADRETalia 1.72 3 3 3lorena 1.7 6 0 6karen 1.68 0 0Fernanda 1.65 6 0 6Elianis 1.59 1 1 1Camila 1.55 2 2 2

4 PUNTO6 8.7225 3.22

25.7 1.24498996 1.665

CANTIDADDESCRIPCION PRECIO TOTAL

10 COMPUTADORES $1,500,000 $15,000,000

5 MUEBLES PARA COMPUTADOR $150,000 $750,0006 ESTANTES METALICOS $250,000 $1,500,0005 MUEBLES DE EIMAX $160,000 $800,000

30 LAPICEROS $500 $15,0005 RESMA CARTA $9,500 $47,500

10 TORRES CD $58,500 $585,00023 MANUALES EXCEL $15,000 $345,000

SUBTOTAL $19,042,500IVA 16% $3,046,800TOTAL $22,089,300

PRODUCTOS ENERO FEBRERO MARZO TOTAL

CHEVROLET $75,536.40 $57,311.31 $81,514.07 $214,361.78

GMC $54,443.28 $45,219.55 $55,507.07 $155,169.90

FORD $92,374.36 $84,413.95 $98,282.31 $275,070.62

VOLVO $51,304.80 $39,263.52 $54,305.05 $144,873.37

HONDA $75,604.92 $63,522.77 $81,545.92 $220,673.61

BMW $58,002.91 $51,302.99 $60,844.06 $170,149.96

TOTAL $407,266.67 $341,034.09 $431,998.48 $1,180,299.24

PORCENTAJE

18.16% $214,361.78

13.15% $155,169.90

23.31% $275,070.62

12.27% $144,873.37

18.70% $220,673.61

14.42% $170,149.96

100.00% $1,180,299.24

CANTANTES VALOR RECOLECTADO

SHAKIRA $63,250,000.00

JUANES $69,850,200.00

CARLOS VIVES $63,200,000.00

FONSECA $42,000,000.00

SILVESTRE DONGOND $45,000,000.00

$283,300,200.00

FUNDACION VALOR DONADO

FUNDACION LA LUZ $52,915,437.20

FUNDACION PIES DESCALZOS $52,915,437.20

FUNDACION CARDIOINFANTIL $52,915,437.20

FUNDACION DIVINO NIÑO $52,915,437.20

FUNDACION CAMINO DE DIOS $52,915,437.20

% DESCUENTO GOBIERNO TOTAL DESCUENTO TOTAL RECOLECTADO

7% $4,427,500.00 $58,822,500.00

7% $4,889,514.00 $64,960,686.00

8% $5,056,000.00 $58,144,000.00

5% $2,100,000.00 $39,900,000.00

5% $2,250,000.00 $42,750,000.00

TOTAL $18,723,014.00 $264,577,186.00

% PARA LA FUNDACION TOTAL DE PORCENTAJEVALOR PARA DISTRIBUIR

3% $1,587,463.12 $51,327,974.08

2% $1,058,308.74 $51,857,128.46

5% $2,645,771.86 $50,269,665.34

3% $1,587,463.12 $51,327,974.08

4% $2,116,617.49 $50,798,819.71

INTEGRANTES VALOR

925 $55,489.70

815 $63,628.38

450 $111,710.37

850 $60,385.85

950 $53,472.44

top related