Graficos de excel

Preview:

DESCRIPTION

graficos

Citation preview

INGRESOS

Enero Febrero Marzo

Producto 1 S/. 1,511.00 S/. 4,910.00 S/. 7,340.00

Producto 2 S/. 8,552.00 S/. 11,689.00 S/. 1,523.00

Producto 3 S/. 14,596.00 S/. 4,693.00 S/. 1,755.00

Producto 4 S/. 3,795.00 S/. 1,743.00 S/. 4,494.00

Producto 1 Producto 2 Producto 3 Producto 4 S/.-

S/.1,000.00 S/.2,000.00 S/.3,000.00 S/.4,000.00 S/.5,000.00 S/.6,000.00 S/.7,000.00 S/.8,000.00 S/.9,000.00

S/.10,000.00 S/.11,000.00 S/.12,000.00 S/.13,000.00 S/.14,000.00 S/.15,000.00

INGRESOS

SOLES

Producto 1 Producto 2 Producto 3 Producto 4 S/.-

S/.1,000.00 S/.2,000.00 S/.3,000.00 S/.4,000.00 S/.5,000.00 S/.6,000.00 S/.7,000.00 S/.8,000.00 S/.9,000.00

S/.10,000.00 S/.11,000.00 S/.12,000.00 S/.13,000.00 S/.14,000.00 S/.15,000.00

INGRESOS

SOLES

PACIENTES

Medicina Interna 103

Pediatria 154

Oncologia 198

Oftalmologia 120

Radiografia 128

Medicina Externa 177

Radiografia 126

10%15%

20%12%

13%

18%

13%

PACIENTES

Medicina Interna

Pediatria

Oncologia

Oftalmologia

Radiografia

Medicina Externa

Radiografia

10%15%

20%12%

13%

18%

13%

PACIENTES

Medicina Interna

Pediatria

Oncologia

Oftalmologia

Radiografia

Medicina Externa

Radiografia

VENTAS

Inicio S/. -

Octubre S/. 84,296.05

Noviembre ###

Diciembre ###

Enero ###

Febrero ###

Marzo ###

S/.-

S/.100,000.00

S/.200,000.00

S/.300,000.00

S/.400,000.00

S/.500,000.00

S/.600,000.00

S/.700,000.00

S/.800,000.00

S/.900,000.00

VENTAS

VENTAS

S/.-

S/.100,000.00

S/.200,000.00

S/.300,000.00

S/.400,000.00

S/.500,000.00

S/.600,000.00

S/.700,000.00

S/.800,000.00

S/.900,000.00

VENTAS

VENTAS

VENTASPREVISTO ACTUAL

Inicio S/. - S/. -

Octubre S/. 84,296.05 S/. 135,533.97

Noviembre S/. 286,615.00 S/. 300,681.67

Real S/. 402,845.00 S/. 381,763.00

Enero S/. 499,345.00 S/. 460,383.00

Febrero S/. 576,885.00 S/. 563,063.00

Marzo S/. 661,445.00 S/. 563,063.00

Inicio Octubre Noviembre Real Enero Febrero Marzo S/.-

S/.100,000.00

S/.200,000.00

S/.300,000.00

S/.400,000.00

S/.500,000.00

S/.600,000.00

S/.700,000.00

S/.800,000.00

S/.900,000.00

S/.-

S/.84,296.05

S/.286,615.00

S/.402,845.00

S/.499,345.00

S/.576,885.00

S/.661,445.00

S/.-

S/.135,533.97

S/.300,681.67

S/.381,763.00

S/.460,383.00

S/.563,063.00 S/.563,063.00

VENTAS

VENTAS PREVISTO

ACTUAL

Inicio Octubre Noviembre Real Enero Febrero Marzo S/.-

S/.100,000.00

S/.200,000.00

S/.300,000.00

S/.400,000.00

S/.500,000.00

S/.600,000.00

S/.700,000.00

S/.800,000.00

S/.900,000.00

S/.-

S/.84,296.05

S/.286,615.00

S/.402,845.00

S/.499,345.00

S/.576,885.00

S/.661,445.00

S/.-

S/.135,533.97

S/.300,681.67

S/.381,763.00

S/.460,383.00

S/.563,063.00 S/.563,063.00

VENTAS

VENTAS PREVISTO

ACTUAL

VENDEDORESVENTAS

ZONA 1 TRIM

BLANCO RONDON GABRIEL ISAAC A S/. 1,659.50

CALDERON RICAZA ANTONIO GERARDO B S/. 1,998.30

COLQUICOCHA JAIMES JUAN EDMUNDO A S/. 1,642.30

GUERRA LA BARRERA CARLOS GERMAN B S/. 1,035.70

MENDOZA LLANOS GERMAN B S/. 1,518.70

MOGOLLON GARCIA MARIO ALBERTO A S/. 1,481.70

NEYRA LINO EUSEBIO NEMESIO B S/. 1,633.70

OCAMPO HUANCHO JULIO B S/. 1,922.50

OSTOS ZAPANA YOLANDA VIDALINA B S/. 1,336.40

RAMOS RODRIGUEZ JULIO ABEL B S/. 1,415.50

A B A B B A B B B BBLANCO RONDON GABRIEL ISAAC

CALDERON RICAZA ANTONIO GERARDO

COLQUICOCHA JAIMES JUAN EDMUNDO

GUERRA LA BARRERA CARLOS GERMAN

MENDOZA LLANOS GERMAN

MOGOLLON GARCIA MARIO ALBERTO

NEYRA LINO EUSEBIO NEMESIO

OCAMPO HUANCHO JULIO

OSTOS ZAPANA YOLANDA VIDALINA

RAMOS RODRIGUEZ JULIO ABEL

S/.-

S/.200.00

S/.400.00

S/.600.00

S/.800.00

S/.1,000.00

S/.1,200.00

S/.1,400.00

S/.1,600.00

S/.1,800.00

S/.2,000.00

S/.2,200.00

S/.2,400.00

S/.2,600.00

S/.2,800.00

S/.3,000.00

VENTAS TRIMESTRALES

VENTAS 1 TRIM

2 TRIM

3 TRIM

4 TRIM

VENDEDORES

INGRESOS

A B A B B A B B B BBLANCO RONDON GABRIEL ISAAC

CALDERON RICAZA ANTONIO GERARDO

COLQUICOCHA JAIMES JUAN EDMUNDO

GUERRA LA BARRERA CARLOS GERMAN

MENDOZA LLANOS GERMAN

MOGOLLON GARCIA MARIO ALBERTO

NEYRA LINO EUSEBIO NEMESIO

OCAMPO HUANCHO JULIO

OSTOS ZAPANA YOLANDA VIDALINA

RAMOS RODRIGUEZ JULIO ABEL

S/.-

S/.200.00

S/.400.00

S/.600.00

S/.800.00

S/.1,000.00

S/.1,200.00

S/.1,400.00

S/.1,600.00

S/.1,800.00

S/.2,000.00

S/.2,200.00

S/.2,400.00

S/.2,600.00

S/.2,800.00

S/.3,000.00

VENTAS TRIMESTRALES

VENTAS 1 TRIM

2 TRIM

3 TRIM

4 TRIM

VENDEDORES

INGRESOS

VENTAS

2 TRIM 3 TRIM 4 TRIM

S/. 1,689.50 S/. 1,194.90 S/. 1,359.50

S/. 1,904.10 S/. 1,463.30 S/. 1,746.40

S/. 1,323.30 S/. 1,329.90 S/. 1,310.20

S/. 1,816.70 S/. 1,679.80 S/. 1,915.00

S/. 1,984.60 S/. 1,994.20 S/. 1,918.20

S/. 1,432.40 S/. 1,441.30 S/. 1,589.30

S/. 1,684.60 S/. 1,209.70 S/. 1,274.50

S/. 1,018.30 S/. 1,750.20 S/. 1,840.60

S/. 1,528.40 S/. 1,938.70 S/. 1,835.20

S/. 1,157.30 S/. 1,224.10 S/. 1,690.60

A B A B B A B B B BBLANCO RONDON GABRIEL ISAAC

CALDERON RICAZA ANTONIO GERARDO

COLQUICOCHA JAIMES JUAN EDMUNDO

GUERRA LA BARRERA CARLOS GERMAN

MENDOZA LLANOS GERMAN

MOGOLLON GARCIA MARIO ALBERTO

NEYRA LINO EUSEBIO NEMESIO

OCAMPO HUANCHO JULIO

OSTOS ZAPANA YOLANDA VIDALINA

RAMOS RODRIGUEZ JULIO ABEL

S/.-

S/.200.00

S/.400.00

S/.600.00

S/.800.00

S/.1,000.00

S/.1,200.00

S/.1,400.00

S/.1,600.00

S/.1,800.00

S/.2,000.00

S/.2,200.00

S/.2,400.00

S/.2,600.00

S/.2,800.00

S/.3,000.00

VENTAS TRIMESTRALES

VENTAS 1 TRIM

2 TRIM

3 TRIM

4 TRIM

VENDEDORES

INGRESOS

A B A B B A B B B BBLANCO RONDON GABRIEL ISAAC

CALDERON RICAZA ANTONIO GERARDO

COLQUICOCHA JAIMES JUAN EDMUNDO

GUERRA LA BARRERA CARLOS GERMAN

MENDOZA LLANOS GERMAN

MOGOLLON GARCIA MARIO ALBERTO

NEYRA LINO EUSEBIO NEMESIO

OCAMPO HUANCHO JULIO

OSTOS ZAPANA YOLANDA VIDALINA

RAMOS RODRIGUEZ JULIO ABEL

S/.-

S/.200.00

S/.400.00

S/.600.00

S/.800.00

S/.1,000.00

S/.1,200.00

S/.1,400.00

S/.1,600.00

S/.1,800.00

S/.2,000.00

S/.2,200.00

S/.2,400.00

S/.2,600.00

S/.2,800.00

S/.3,000.00

VENTAS TRIMESTRALES

VENTAS 1 TRIM

2 TRIM

3 TRIM

4 TRIM

VENDEDORES

INGRESOS

A B A B B A B B B BBLANCO RONDON GABRIEL ISAAC

CALDERON RICAZA ANTONIO GERARDO

COLQUICOCHA JAIMES JUAN EDMUNDO

GUERRA LA BARRERA CARLOS GERMAN

MENDOZA LLANOS GERMAN

MOGOLLON GARCIA MARIO ALBERTO

NEYRA LINO EUSEBIO NEMESIO

OCAMPO HUANCHO JULIO

OSTOS ZAPANA YOLANDA VIDALINA

RAMOS RODRIGUEZ JULIO ABEL

S/.-

S/.200.00

S/.400.00

S/.600.00

S/.800.00

S/.1,000.00

S/.1,200.00

S/.1,400.00

S/.1,600.00

S/.1,800.00

S/.2,000.00

S/.2,200.00

S/.2,400.00

S/.2,600.00

S/.2,800.00

S/.3,000.00

VENTAS TRIMESTRALES

VENTAS 1 TRIM

2 TRIM

3 TRIM

4 TRIM

VENDEDORES

INGRESOS

A B A B B A B B B BBLANCO RONDON GABRIEL ISAAC

CALDERON RICAZA ANTONIO GERARDO

COLQUICOCHA JAIMES JUAN EDMUNDO

GUERRA LA BARRERA CARLOS GERMAN

MENDOZA LLANOS GERMAN

MOGOLLON GARCIA MARIO ALBERTO

NEYRA LINO EUSEBIO NEMESIO

OCAMPO HUANCHO JULIO

OSTOS ZAPANA YOLANDA VIDALINA

RAMOS RODRIGUEZ JULIO ABEL

S/.-

S/.200.00

S/.400.00

S/.600.00

S/.800.00

S/.1,000.00

S/.1,200.00

S/.1,400.00

S/.1,600.00

S/.1,800.00

S/.2,000.00

S/.2,200.00

S/.2,400.00

S/.2,600.00

S/.2,800.00

S/.3,000.00

VENTAS TRIMESTRALES

VENTAS 1 TRIM

2 TRIM

3 TRIM

4 TRIM

VENDEDORES

INGRESOS

A B A B B A B B B BBLANCO RONDON GABRIEL ISAAC

CALDERON RICAZA ANTONIO GERARDO

COLQUICOCHA JAIMES JUAN EDMUNDO

GUERRA LA BARRERA CARLOS GERMAN

MENDOZA LLANOS GERMAN

MOGOLLON GARCIA MARIO ALBERTO

NEYRA LINO EUSEBIO NEMESIO

OCAMPO HUANCHO JULIO

OSTOS ZAPANA YOLANDA VIDALINA

RAMOS RODRIGUEZ JULIO ABEL

S/.-

S/.200.00

S/.400.00

S/.600.00

S/.800.00

S/.1,000.00

S/.1,200.00

S/.1,400.00

S/.1,600.00

S/.1,800.00

S/.2,000.00

S/.2,200.00

S/.2,400.00

S/.2,600.00

S/.2,800.00

S/.3,000.00

VENTAS TRIMESTRALES

VENTAS 1 TRIM

2 TRIM

3 TRIM

4 TRIM

VENDEDORES

INGRESOS

A B A B B A B B B BBLANCO RONDON GABRIEL ISAAC

CALDERON RICAZA ANTONIO GERARDO

COLQUICOCHA JAIMES JUAN EDMUNDO

GUERRA LA BARRERA CARLOS GERMAN

MENDOZA LLANOS GERMAN

MOGOLLON GARCIA MARIO ALBERTO

NEYRA LINO EUSEBIO NEMESIO

OCAMPO HUANCHO JULIO

OSTOS ZAPANA YOLANDA VIDALINA

RAMOS RODRIGUEZ JULIO ABEL

S/.-

S/.200.00

S/.400.00

S/.600.00

S/.800.00

S/.1,000.00

S/.1,200.00

S/.1,400.00

S/.1,600.00

S/.1,800.00

S/.2,000.00

S/.2,200.00

S/.2,400.00

S/.2,600.00

S/.2,800.00

S/.3,000.00

VENTAS TRIMESTRALES

VENTAS 1 TRIM

2 TRIM

3 TRIM

4 TRIM

VENDEDORES

INGRESOS