20
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 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 ING SOLES

Graficos de excel

Embed Size (px)

DESCRIPTION

graficos

Citation preview

Page 1: Graficos de excel

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

Page 2: Graficos de excel

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

Page 3: Graficos de excel
Page 4: Graficos de excel

PACIENTES

Medicina Interna 103

Pediatria 154

Oncologia 198

Oftalmologia 120

Radiografia 128

Medicina Externa 177

Radiografia 126

Page 5: Graficos de excel

10%15%

20%12%

13%

18%

13%

PACIENTES

Medicina Interna

Pediatria

Oncologia

Oftalmologia

Radiografia

Medicina Externa

Radiografia

Page 6: Graficos de excel

10%15%

20%12%

13%

18%

13%

PACIENTES

Medicina Interna

Pediatria

Oncologia

Oftalmologia

Radiografia

Medicina Externa

Radiografia

Page 7: Graficos de excel

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

Page 8: Graficos de excel

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

Page 9: Graficos de excel
Page 10: Graficos de excel

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

Page 11: Graficos de excel

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

Page 12: Graficos de excel
Page 13: Graficos de excel

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

Page 14: Graficos de excel

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

Page 15: Graficos de excel

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

Page 16: Graficos de excel

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

Page 17: Graficos de excel

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

Page 18: Graficos de excel

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

Page 19: Graficos de excel

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

Page 20: Graficos de excel

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