Upload
yenifersanchez
View
5
Download
1
Embed Size (px)
DESCRIPTION
TALLER #9 INSERTAR FORMULAS EN EXCEL YENIFER SANCHEZ 8 °A
Citation preview
ARTICULO VALOR UNIDADES
GUANTES DE PORTERO $ 48,000 12
UNIFORME DE NIÑO REAL MADRIL NEGRO $ 135,000 12
GUAYOS ADIDA MESSI $ 126,000 12
GORRA JAMES RODRIGUEZ $ 25,000 12
BALON BRAZUCA $ 90,000 12
MEDIAS LARGAS NIKE PARA FUTBOL $ 32,000 12
TOTAL
TOTAL
$ 576,000
$ 1,620,000
$ 1,512,000
$ 300,000
$ 1,080,000
$ 384,000
$ 5,472,000
VENDEDOR MIGUEL GARCIA $ 15,000,000 $ 20,000,000 $ 18,500,000 $ 20,100,000 SANTANDER FERNANDEZ $ 12,000,000 $ 13,040,000 $ 17,500,000 $ 17,200,000 GLORIA VELASQUEZ $ 14,600,000 $ 17,000,000 $ 19,000,000 $ 16,400,000 SERGIO HENAO $ 11,000,000 $ 10,600,000 $ 16,400,000 $ 17,000,000 RAFAEL COTEZ $ 18,500,000 $ 12,000,000 $ 15,700,000 $ 10,800,000 GUILLERMO BUITRIAGO $ 17,500,000 $ 15,000,000 $ 12,100,000 $ 20,000,000
VENTAS TOTALES POR TRIMESTRE $ 88,600,000 $ 87,640,000 $ 99,200,000 $ 101,500,000
PROMEDIO VENTAS POR TRIMESTRE $ 14,766,667 $ 14,606,667 $ 16,533,333 $ 16,916,667 }
TRIMESTRE 1 TRIMESTRE 2 TRIMESTRE 3 TRIMESTRE 4
$ 73,600,000 $ 18,400,000 $ 59,740,000 $ 14,935,000
$ 133,340,000 $ 16,750,000 $ 55,000,000 $ 13,750,000 $ 57,000,000 $ 14,250,000
$ 112,000,000 $ 16,150,000
$ 376,940,000 $ 94,235,000
$ 81,780,000 $ 15,705,833
VENTAS TOTALES POR VENDEDOR
PROMEDIO POR VENDDOR