excel

1
CANTIDAD DESCRIPCION PRECIO TOTAL 10 COMPUTADORES $1.500.000 $15.000.000 5 MUEBLES PARA COMPUTADOR $150.000 $750.000 6 ESTANTES METALICOS $250.000 $1.500.000 5 MUEBLES RIMAX $160.000 $800.000 30 LAPICEROS $500 $15.000 5 REXMAS CARTA $9.500 $47.500 10 TORRES CD $58.500 $585.000 23 MANUALIDADES EXCEL $15.000 $345.000 SUBTOTAL $19.042.500 IVA 16% TOTAL PRODUCTOS ENERO FEBRERO MARZO TOTAL PORCENTAJE CHEVROLET $75.536,40 $57.311,31 $81.514,07 $214.361,78 18,16% GMC $54.443,28 $45.219,55 $55.507,07 $155.169,90 13,15% Ford $92.374,36 $84.413,95 $98.282,31 $275.070,62 23,30% Volvo $51.304,80 $39.263,52 $54.305,05 $144.873,37 12,27% Honda $75.604,92 $63.522,77 $81.545,92 $220.673,61 18,70% BMW $58.022,91 $51.302,99 $60.844,06 $170.169,96 14,42% TOTAL $407.286,67 $341.034,09 $431.998,48 $1.180.319,24 100,00% CANTANTES VALOR RECOLECTADO % DESCUENTO GOBIERNO TOTAL DESCUENTO TOTAL RECOLECTADO SHAKIRA $63.250.000 7% $4.427.500 $58.822.500 JUANES $69.850.200 7% $4.889.514 $64.960.686 CARLOS VIVES $63.200.000 8% $5.056.000 $58.144.000 FONSECA $42.000.000 5% $2.100.000 $39.900.000 SILVESTRE DANGOND $45.000.000 5% $2.250.000 $42.750.000 $18.723.014 $264.577.186 $264.577.186 FUNDACION VALOR DONADO %PARA LA FUNDACION TOTAL PORCENTAJE VALOR PARA DISTRIBUIR INTEGRANTES VALOR CORRESP. BENEFICIARIO FUNDACION LA LUZ $52.915.437 3% 925 FUNDACION PIES DESCALZOS $52.915.437 2% 815 FUNDACION CARDIOINFANTIL $52.915.437 3% 450 FUNDACION DIVINO NIÑO $52.915.437 4% 850 FUNDACION CAMINO DE DIOS $52.915.437 4% 950

Upload: roajuanita

Post on 19-Dec-2015

10 views

Category:

Documents


0 download

DESCRIPTION

EXCEL

TRANSCRIPT

Page 1: EXCEL

CANTIDAD DESCRIPCION PRECIO TOTAL

10 COMPUTADORES $1.500.000 $15.000.000

5 MUEBLES PARA

COMPUTADOR $150.000 $750.000

6 ESTANTES

METALICOS $250.000 $1.500.000

5 MUEBLES RIMAX $160.000 $800.000

30 LAPICEROS $500 $15.000

5 REXMAS CARTA $9.500 $47.500

10 TORRES CD $58.500 $585.000

23 MANUALIDADES

EXCEL $15.000 $345.000

SUBTOTAL $19.042.500

IVA 16%

TOTAL

PRODUCTOS ENERO FEBRERO MARZO TOTAL PORCENTAJE

CHEVROLET $75.536,40 $57.311,31 $81.514,07 $214.361,78 18,16%

GMC $54.443,28 $45.219,55 $55.507,07 $155.169,90 13,15%

Ford $92.374,36 $84.413,95 $98.282,31 $275.070,62 23,30%

Volvo $51.304,80 $39.263,52 $54.305,05 $144.873,37 12,27%

Honda $75.604,92 $63.522,77 $81.545,92 $220.673,61 18,70%

BMW $58.022,91 $51.302,99 $60.844,06 $170.169,96 14,42%

TOTAL $407.286,67 $341.034,09 $431.998,48 $1.180.319,24 100,00%

CANTANTES

VALOR

RECOLECTADO

% DESCUENTO

GOBIERNO

TOTAL

DESCUENTO

TOTAL

RECOLECTADO

SHAKIRA $63.250.000 7% $4.427.500 $58.822.500

JUANES $69.850.200 7% $4.889.514 $64.960.686

CARLOS VIVES $63.200.000 8% $5.056.000 $58.144.000

FONSECA $42.000.000 5% $2.100.000 $39.900.000

SILVESTRE

DANGOND $45.000.000 5% $2.250.000 $42.750.000

$18.723.014 $264.577.186 $264.577.186

FUNDACION

VALOR

DONADO

%PARA LA

FUNDACIONTOTAL

PORCENTAJE

VALOR PARA

DISTRIBUIR INTEGRANTESVALOR CORRESP.

BENEFICIARIO

FUNDACION LA LUZ $52.915.437 3% 925

FUNDACION PIES

DESCALZOS $52.915.437 2% 815

FUNDACION

CARDIOINFANTIL $52.915.437 3% 450

FUNDACION

DIVINO NIÑO $52.915.437 4% 850

FUNDACION

CAMINO DE DIOS $52.915.437 4% 950