actividad final
DESCRIPTION
costosTRANSCRIPT
9
9
COODIGONOMBRE VENTAS
ENERO FEBRERO MARZO ABRIL MAYO JUNIO TOTAL VENTAS SE MAXIMO MINIMO PROMEDIO Comision
1 ZENAIDA TORO $ 20,000 $ 25,000 $ 39,000 $ 80,500 $ 72,000 $ 13,000 $ 249,500 $ 80,500 $ 13,000 $ 41,583 $ -
2 MARCELINO RENTERIA $ 35,000 $ 35,000 $ 38,000 $ 20,500 $ 73,000 $ 42,000 $ 243,500 $ 73,000 $ 20,500 $ 40,583 $ -
3 NIDIA MENDEZ $ 28,000 $ 39,000 $ 40,000 $ 10,000 $ 45,000 $ 38,500 $ 200,500 $ 45,000 $ 10,000 $ 33,417 $ -
4 ALBERTO MURCIA $ 15,000 $ 85,000 $ 28,000 $ 18,000 $ 38,000 $ 49,800 $ 233,800 $ 85,000 $ 15,000 $ 38,967 $ -
5 MARITZA FERNANDEZ $ 30,000 $ 50,000 $ 35,000 $ 82,000 $ 49,000 $ 60,000 $ 306,000 $ 82,000 $ 30,000 $ 51,000 $ 6,120
6 MANUEL SUAREZ $ 50,000 $ 30,000 $ 25,000 $ 25,000 $ 49,000 $ 73,000 $ 252,000 $ 73,000 $ 25,000 $ 42,000 $ 5,040
7 BERTHA ORTIZ $ 80,000 $ 52,000 $ 90,000 $ 55,000 $ 56,000 $ 85,500 $ 418,500 $ 90,000 $ 52,000 $ 69,750 $ 8,370
8 ALFREDO DUARTE $ 42,000 $ 33,000 $ 65,000 $ 42,000 $ 80,200 $ 90,000 $ 352,200 $ 90,000 $ 33,000 $ 58,700 $ 7,044
9 PEDRO GOMEZ $ 35,000 $ 42,000 $ 15,000 $ 6,000 $ 45,000 $ 120,000 $ 263,000 $ 120,000 $ 6,000 $ 43,833 $ 5,260
10 JHON ORTIZ $ 32,000 $ 40,000 $ 28,000 $ 100,000 $ 22,000 $ 70,000 $ 292,000 $ 100,000 $ 22,000 $ 48,667 $ 5,840
VENTAS MENSUALES $ 367,000 $ 431,000 $ 403,000 $ 439,000 $ 529,200 $ 641,800
ENERO FEBRERO MARZO ABRIL MAYO JUNIO
EMPLEADO $ 80,000 $ 85,000 $ 90,000 $ 82,000 $ 80,200 $ 90,000
BERTHA ORTIZ 82000 80200
MAXIMA VENTA MENSUAL
ALBERTO MURCIA
BERTHA ORTIZ
ALFREDO DUARTE
9
9
ENERO FEBRERO MARZO ABRIL MAYO JUNIO
EMPLEADO $ 15,000 $ 25,000 $ 25,000 $ 10,000 $ 38,000 $ 13,000
MINIMA VENTA MENSUAL
ALBERTO MURCIA
ZENAIDA TORO
MANUEL SUAREZ
NIDIA MENDEZ
ALBERTO MURCIA
ZENAIDA TORO
9
9
VENTAS Bonificaci Sanción po Total empleado
$ - $ 249,375 $ 249,375 Felicitaciones
$ - $ 243,375 $ 243,375 Felicitaciones
$ - $ 200,375 $ 200,375 Felicitaciones
$ - $ 233,675 $ 233,675 Felicitaciones
$ 612 $ - $ 312,732 Felicitaciones
$ - $ 251,875 $ 256,915 Felicitaciones
$ 837 $ - $ 427,707 Felicitaciones
$ 704 $ - $ 359,948 Felicitaciones
$ - $ 262,875 $ 268,135 Felicitaciones
$ - $ 291,875 $ 297,715 Felicitaciones
Grafico ventas mes
Serie 1 EneroSerie 2 FebreroSerie 3 MarzoSerie 4 AbrilSerie 5 MayoSerie 6 Junio
ZENAIDA TORO
MARCELINO RENTERIA
NIDIA MENDEZ
ALBERTO M
URCIA
MARITZA FERNANDEZ
MANUEL SUAREZ
BERTHA ORTIZ
ALFREDO DUARTE
PEDRO GOMEZ
JHON O
RTIZ $-
$20,000
$40,000
$60,000
$80,000
$100,000
$120,000
$140,000
Venta por mes
Column C Column D Column E Column F Column G Column H
ZENAIDA TORO
MARCELINO RENTERIA
NIDIA MENDEZ
ALBERTO M
URCIA
MARITZA FERNANDEZ
MANUEL SUAREZ
BERTHA ORTIZ
ALFREDO DUARTE
PEDRO GOMEZ
JHON O
RTIZ $-
$20,000
$40,000
$60,000
$80,000
$100,000
$120,000
$140,000
Venta por mes
Column C Column D Column E Column F Column G Column H
Grafico Semestral
$20,000
$35,000
$28,000
$15,000
$30,000
$50,000 $80,000
$42,000
$35,000
$32,000
Participación venta semestral
$20,000
$35,000
$28,000
$15,000
$30,000
$50,000 $80,000
$42,000
$35,000
$32,000
Participación venta semestral
1 2 3 4 5 6 $-
$20,000 $40,000 $60,000 $80,000
$100,000 $120,000
JHON ORTIZ
1 2 3 4 5 6 $-
$20,000
$40,000
$60,000
$80,000
$100,000
ALFREDO DUARTE
1 2 3 4 5 6 $-
$20,000
$40,000 $60,000
$80,000 $100,000
BERTHA ORTIZ
1 2 3 4 5 6 $-
$10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000
MANUEL SUAREZ
1 2 3 4 5 6 $-
$10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000 $90,000
MARITZA FERNANDEZ
1 2 3 4 5 6 $-
$20,000
$40,000
$60,000
$80,000
$100,000
ALBERTO MURCIA
1 2 3 4 5 6 $-
$10,000 $20,000 $30,000 $40,000 $50,000
NIDIA MENDEZ
1 2 3 4 5 6 $-
$10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000
MARCELINO RENTERIA
1 2 3 4 5 6 $-
$20,000
$40,000
$60,000
$80,000
ZENAIDA TORO
1 2 3 4 5 6 $-
$10,000 $20,000 $30,000 $40,000 $50,000
NIDIA MENDEZ
1 2 3 4 5 6 $-
$10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000
MARCELINO RENTERIA
1 2 3 4 5 6 $-
$20,000
$40,000
$60,000
$80,000
ZENAIDA TORO