Graficos de excel
-
Upload
johanaalfaro -
Category
Documents
-
view
237 -
download
2
description
Transcript of 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
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