16794111 Trabajo Practico 1 Excel Computacion Jcg
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View 16794111 Trabajo Practico 1 Excel Computacion Jcg as PDF for free.
More details
- Words: 585
- Pages: 9
Tipo de gastos Alquiler Instalaciones Suministros Equipos Comiciones Viajes Otros
Otoño $ 800.00 $ 1,572.00 $ 1,748.00 $ 924.00 $ 1,534.00 $ 4,500.00 $ 274.00
Invierno $ 438.00 $ 3,513.00 $ 2,045.00 $ 1,245.00 $ 1,930.00 $ 2,440.00 $ 451.00
Primavera $ 270.00 $ 2,463.00 $ 4,060.00 $ 1,245.00 $ 2,038.00 $ 3,027.00 $ 1,020.00
Verano $ 914.00 $ 4,762.00 $ 695.00 $ 3,542.00 $ 2,453.00 $ 2,454.00 $ 985.00
TOTAL PORCENTAJE PROMEDIO Max Min Gasto
$ 11,352.00 21% $ 1,621.71 $ 4,500.00 $ 274.00 Excesivo
$ 12,062.00 23% $ 1,723.14 $ 3,513.00 $ 438.00 Excesivo
$ 14,123.00 26% $ 2,017.57 $ 4,060.00 $ 270.00 Excesivo
$ 15,805.00 30% $ 2,257.86 $ 4,762.00 $ 695.00 Excesivo
4.54% 5.12% 23.08%
23.29%
16.02%
14.91% 13.04%
Alquiler Otros
Instalaciones
Suministros
Equipos
Comiciones
Viajes
$ 13,000.00 $ 12,000.00 $ 11,000.00 $ 10,000.00 $ 8,000.00 $ 6,000.00 $ 4,000.00 $ 2,000.00
s tro O
es Vi aj
s ne ici o
C om
Eq ui po
s
s in is tro
Su m
cio ne s la
In s
ta
Al qu ile r
$-
$ 6,000.00 $ 4,000.00 $ 2,000.00
Marca de auto Peugeot BMW Toyota Fiat
1er semestre
Total Porcentaje
Invierno
Primavera
MARCAS DE AUTOS X 2do semestre Total
s tr o
Verano
Porcentaje
561 784 654 456
357 968 429 753
918 1752 1083 1209
2455 49%
2507 51%
4962 100%
autos20% Promedio max min
O
ici o
Vi aj
ne
es
s
s C om
Su m Otoño
Eq ui po
in is t
ro
s
es io n ac
In
st
al
Al qu ile r
$-
Estado
19% revisar 35% ok 22% revisar 24% ok 100%
241.8 1240.5 1752 918
1000
Total
900 800 700 600
BMW 35.31%
500 400 300 200
Toyota 21.83%
100 0 Peugeot
BMW 1er semestre
Toyota 2do semestre
Fiat
TIPO DE HABITACION Prsidencial 2000$ Nupcial 1500$ Triple 850$ Doble 600$ Single 350$ Total Porcentaje Importe
DIA 1
DIA 2
DIA 3
DIA 4
DIA 5
2 3 6 8 5
5 2 2 7 8
2 1 5 6 3
7 4 4 3 6
9 6 5 4 11
24 19% 33400
24 19% 42900
17 14% 22350
24 19% 43200
35 28% 66650
11550
16800 50000
20.0
18700
8.0 24000 Prsidencial 2000$ Single 350$
70000 65000 60000 55000 50000 45000
Nupcial
1500$
Triple
850$
Doble
66650
42900
43200
600$
70000 65000 60000 55000 50000 45000 40000 35000 30000 25000 20000 15000 10000 5000 0
66650
43200
42900 33400 22350
Row 128 DIA 1
DIA 2
1T
DIA 3
DIA 4
2T
DIA 5
GASTOS sueldos luz gas tel Alquiler bancos
3T
$1,348.00 $7,942.00 $55,555.00 $2,785.00 $1,000.00 $2,458.00
$36,715.00 $4,823.00 $54,646.00 $60,000.00 $46,565.00 $500,000.00
total de gastos Porcentaje
$71,088.00 3%
$702,749.00 $1,182,900.00 34% 57%
max Min Promedio
$55,555.00 $1,000.00 $11,848.00
$500,000.00 $4,823.00 $117,124.83
$51,035.00 $343.00 $546,546.00 $34,945.00 $546,546.00 $3,485.00
$546,546.00 $343.00 $197,150.00
4T $678.00 $456.00 $987.00 $61,545.00 $44,444.00 $15,786.00
TOTAL ANUAL $89,776.00 $13,564.00 $657,734.00 $159,275.00 $638,555.00 $521,729.00
$123,896.00 $2,080,633.00 6% 100%
$61,545.00 $456.00 $20,649.33
os
Total $ 2,422.00 $ 12,310.00 $ 8,548.00 $ 6,956.00 $ 7,955.00 $ 12,421.00 $ 2,730.00 $ 53,342.00 100% $ 7,620.29
Porcentaje 5% 23% 16% 13% 15% 23% 5%
os
Total
Peugeot 18.50% Fiat 24.37%
TOTAL 25 16 22 28 33
PORCENTAJE IMPORTES 20% 50000 13% 24000 18% 18700 23% 16800 27% 11550
124 100%
100%
Ocupacion 8.00%
20.00%
36.00%
8.00%
28.00% DIA 1
DIA 2
DIA 3
DIA 4
DIA 5
PORCENTAJE DEL TRIMESTRE 4% 1% 32% 8% 31% 25% 100%
Tomas Meloni.doc
Otoño $ 800.00 $ 1,572.00 $ 1,748.00 $ 924.00 $ 1,534.00 $ 4,500.00 $ 274.00
Invierno $ 438.00 $ 3,513.00 $ 2,045.00 $ 1,245.00 $ 1,930.00 $ 2,440.00 $ 451.00
Primavera $ 270.00 $ 2,463.00 $ 4,060.00 $ 1,245.00 $ 2,038.00 $ 3,027.00 $ 1,020.00
Verano $ 914.00 $ 4,762.00 $ 695.00 $ 3,542.00 $ 2,453.00 $ 2,454.00 $ 985.00
TOTAL PORCENTAJE PROMEDIO Max Min Gasto
$ 11,352.00 21% $ 1,621.71 $ 4,500.00 $ 274.00 Excesivo
$ 12,062.00 23% $ 1,723.14 $ 3,513.00 $ 438.00 Excesivo
$ 14,123.00 26% $ 2,017.57 $ 4,060.00 $ 270.00 Excesivo
$ 15,805.00 30% $ 2,257.86 $ 4,762.00 $ 695.00 Excesivo
4.54% 5.12% 23.08%
23.29%
16.02%
14.91% 13.04%
Alquiler Otros
Instalaciones
Suministros
Equipos
Comiciones
Viajes
$ 13,000.00 $ 12,000.00 $ 11,000.00 $ 10,000.00 $ 8,000.00 $ 6,000.00 $ 4,000.00 $ 2,000.00
s tro O
es Vi aj
s ne ici o
C om
Eq ui po
s
s in is tro
Su m
cio ne s la
In s
ta
Al qu ile r
$-
$ 6,000.00 $ 4,000.00 $ 2,000.00
Marca de auto Peugeot BMW Toyota Fiat
1er semestre
Total Porcentaje
Invierno
Primavera
MARCAS DE AUTOS X 2do semestre Total
s tr o
Verano
Porcentaje
561 784 654 456
357 968 429 753
918 1752 1083 1209
2455 49%
2507 51%
4962 100%
autos20% Promedio max min
O
ici o
Vi aj
ne
es
s
s C om
Su m Otoño
Eq ui po
in is t
ro
s
es io n ac
In
st
al
Al qu ile r
$-
Estado
19% revisar 35% ok 22% revisar 24% ok 100%
241.8 1240.5 1752 918
1000
Total
900 800 700 600
BMW 35.31%
500 400 300 200
Toyota 21.83%
100 0 Peugeot
BMW 1er semestre
Toyota 2do semestre
Fiat
TIPO DE HABITACION Prsidencial 2000$ Nupcial 1500$ Triple 850$ Doble 600$ Single 350$ Total Porcentaje Importe
DIA 1
DIA 2
DIA 3
DIA 4
DIA 5
2 3 6 8 5
5 2 2 7 8
2 1 5 6 3
7 4 4 3 6
9 6 5 4 11
24 19% 33400
24 19% 42900
17 14% 22350
24 19% 43200
35 28% 66650
11550
16800 50000
20.0
18700
8.0 24000 Prsidencial 2000$ Single 350$
70000 65000 60000 55000 50000 45000
Nupcial
1500$
Triple
850$
Doble
66650
42900
43200
600$
70000 65000 60000 55000 50000 45000 40000 35000 30000 25000 20000 15000 10000 5000 0
66650
43200
42900 33400 22350
Row 128 DIA 1
DIA 2
1T
DIA 3
DIA 4
2T
DIA 5
GASTOS sueldos luz gas tel Alquiler bancos
3T
$1,348.00 $7,942.00 $55,555.00 $2,785.00 $1,000.00 $2,458.00
$36,715.00 $4,823.00 $54,646.00 $60,000.00 $46,565.00 $500,000.00
total de gastos Porcentaje
$71,088.00 3%
$702,749.00 $1,182,900.00 34% 57%
max Min Promedio
$55,555.00 $1,000.00 $11,848.00
$500,000.00 $4,823.00 $117,124.83
$51,035.00 $343.00 $546,546.00 $34,945.00 $546,546.00 $3,485.00
$546,546.00 $343.00 $197,150.00
4T $678.00 $456.00 $987.00 $61,545.00 $44,444.00 $15,786.00
TOTAL ANUAL $89,776.00 $13,564.00 $657,734.00 $159,275.00 $638,555.00 $521,729.00
$123,896.00 $2,080,633.00 6% 100%
$61,545.00 $456.00 $20,649.33
os
Total $ 2,422.00 $ 12,310.00 $ 8,548.00 $ 6,956.00 $ 7,955.00 $ 12,421.00 $ 2,730.00 $ 53,342.00 100% $ 7,620.29
Porcentaje 5% 23% 16% 13% 15% 23% 5%
os
Total
Peugeot 18.50% Fiat 24.37%
TOTAL 25 16 22 28 33
PORCENTAJE IMPORTES 20% 50000 13% 24000 18% 18700 23% 16800 27% 11550
124 100%
100%
Ocupacion 8.00%
20.00%
36.00%
8.00%
28.00% DIA 1
DIA 2
DIA 3
DIA 4
DIA 5
PORCENTAJE DEL TRIMESTRE 4% 1% 32% 8% 31% 25% 100%
Tomas Meloni.doc
Related Documents
Trabajo Practico N12 Computacion
June 2020 3
Trabajo Practico (planilla Excel) Terminado
April 2020 10
Trabajo Practico 6 Excel (maia)
June 2020 6
Trabajo Practico De Informatica- Excel
May 2020 4