Upload
karo-valo-rose
View
216
Download
0
Embed Size (px)
DESCRIPTION
ESTADISTICA
Citation preview
ACTIVIDAD 2
1
108 72 99 81 360
49 32 44 37 162
38 25 35 28 126
21 15 20 16 72
1,451,516.02 967,677.35 1,330,556.35 1,088,637.02 4,838,386.74
1,079,303.83 719,535.89 989,361.85 809,477.88 3,597,679.45
372,212.19 248,141.46 341,194.50 279,159.14 1,240,707.29
10,000.00 10,000.00 10,000.00 10,000.00 40,000.00
3,628.79 2,419.19 3,326.39 2,721.59 12,095.97
22,000.00 22,000.00 22,000.00 22,000.00 88,000.00
261,272.88 174,181.92 239,500.14 195,954.66 870,909.61
296,901.67 208,601.12 274,826.53 230,676.26 1,011,005.58
75,310.52 39,540.34 66,367.97 48,482.88 229,701.71
2
Origen Cons Kw Costo Kh
Plata 8,187,805 573,146.35 $5,340.88Pozo 12,897,422 1,610,000.65 $15,002.83Total 21,085,227 2,183,147.00 $20,343.71
3
Total trimestral 1° 2° 3° 4° Total Anual
Unidades vendidas
Modelo 1
Modelo 2
Modelo 3
Ingreso por ventas
Costo de las ventas
Margen bruto
Personal ventas
comisión venta
Publicidad
Cotos fijos
Costo total
Beneficio
Margen beneficio 5,19% 4,09% 4,99% 4,45% 4,75%
suministro M3 mes
Plata Pozo
Column D 573,146.35 1,610,000.65
100,000
300,000
500,000
700,000
900,000
1,100,000
1,300,000
1,500,000
1,700,000
Consumo Kw
Axis Title
a 5X -4b 2
X Y-4 -18-3 -13-2 -8-1 -30 21 72 123 174 225 276 327 37
425 -7 -6 -5 -4 -3 -2-7 98 85 74 65 58 53-6 85 72 61 52 45 40-5 74 61 50 41 34 29-4 65 52 41 32 25 20-3 58 45 34 25 18 13-2 53 40 29 20 13 8-1 50 37 26 17 10 50 49 36 25 16 9 41 50 37 26 17 10 52 53 40 29 20 13 83 58 45 34 25 18 134 65 52 41 32 25 205 74 61 50 41 34 296 85 72 61 52 45 407 98 85 74 65 58 53
-6 -4 -2 0 2 4 6 8
-30
-20
-10
0
10
20
30
40
50
Y
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
0
10
20
30
40
50
60
70
80
90
100
Row 65Row 67
Row 69Row 71
Row 73Row 75
Row 77Row 79
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
0
10
20
30
40
50
60
70
80
90
100
Row 65Row 67
Row 69Row 71
Row 73Row 75
Row 77Row 79
1°
2°
3°
4°
0 20 40 60 80 100 120
Unidades Vendidas
Plata Pozo
Column D 573,146.35 1,610,000.65
100,000
300,000
500,000
700,000
900,000
1,100,000
1,300,000
1,500,000
1,700,000
Consumo Kw
Axis Title
1° 2° 3° 4°0
5
10
15
20
25
30
35
40
45
50
Total Ventas por Modelo
Modelo 1Modelo 2Modelo 3
Trimestre
-1 0 1 2 3 4 5 650 49 50 53 58 65 74 8537 36 37 40 45 52 61 7226 25 26 29 34 41 50 6117 16 17 20 25 32 41 5210 9 10 13 18 25 34 45
5 4 5 8 13 20 29 402 1 2 5 10 17 26 371 0 1 4 9 16 25 362 1 2 5 10 17 26 375 4 5 8 13 20 29 40
10 9 10 13 18 25 34 4517 16 17 20 25 32 41 5226 25 26 29 34 41 50 6137 36 37 40 45 52 61 7250 49 50 53 58 65 74 85
-6 -4 -2 0 2 4 6 8
-30
-20
-10
0
10
20
30
40
50
Y
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
0
10
20
30
40
50
60
70
80
90
100
Row 65Row 67
Row 69Row 71
Row 73Row 75
Row 77Row 79
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
0
10
20
30
40
50
60
70
80
90
100
Row 65Row 67
Row 69Row 71
Row 73Row 75
Row 77Row 79
1° 2° 3° 4°0
5
10
15
20
25
30
35
40
45
50
Total Ventas por Modelo
Modelo 1Modelo 2Modelo 3
Trimestre
7988574655853504950535865748598