POLITECNICO GRANCOLOMBIANO
MODULO HERRAMIENTAS PARA LA PRODUCTIVIDAD
SUBGRUPO 15
INTEGRANTES
1
2 SONIA ISABEL SUAREZ MONROY CODIGO 100394298
3 MARYI LORENA MOYA PULIDO
4 JORGE LUIS BOTERO PAEZ CODIGO 100391351
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community
Ask the community for help and clear up your study doubts
University Rankings
Discover the best universities in your country according to Docsity users
Free resources
Our save-the-student-ebooks!
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Productivity Tools for Business: A Case Study of Sales Data Analysis, Lab Reports of Structures and Materials
A case study of sales data analysis using various productivity tools. It showcases how these tools can be applied to analyze sales performance across different stores and time periods. Examples of functions like round, concatenate, transpose, and if, demonstrating their practical application in data manipulation and analysis. It also includes a table summarizing key sales metrics and a chart visualizing sales trends.
Typology: Lab Reports
2023/2024
1 / 10
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Productivity Tools for Business: A Case Study of Sales Data Analysis and more Lab Reports Structures and Materials in PDF only on Docsity!
POLITECNICO GRANCOLOMBIANO
MODULO HERRAMIENTAS PARA LA PRODUCTIVIDAD
SUBGRUPO 15
INTEGRANTES
2 SONIA ISABEL SUAREZ MONROY CODIGO 100394298
3 MARYI LORENA MOYA PULIDO
4 JORGE LUIS BOTERO PAEZ CODIGO 100391351
VENTAS
TIENDAS ENERO FEBRERO MARZO
UNICENTRO CALI $ 60,567,658.00 $ 32,754,676.00 $ 35,566,677.
EL TESORO $ 78,298,348.00 $ 87,675,698.00 $ 5,857,889.
BUENA VISTA $ 16,828,293.00 $ 7,868,878.00 $ 78,567,753.
CARIBE PLAZA $ 26,377,883.00 $ 78,679,858.00 $ 45,332,567.
FONTANAR $ 72,749,494.00 $ 7,767,689.00 $ 76,478,889.
SANTA FE $ 102,876,746.00 $ 99,787,477.00 $ 5,789,988.
GRAN ESTACION $ 90,678,787.00 $ 91,018,937.00 $ 12,467,889.
CAÑAVERAL $ 57,886,756.00 $ 8,098,773.00 $ 6,335,778.
LOS MOLINOS $ 88,987,678.00 $ 1,103,979.00 $ 5,433,246.
JARDIN PLAZA $ 78,989,900.00 $ 24,156,388.00 $ 86,754,568.
TOTAL $ 674,241,543.00 $ 438,912,353.00 $ 358,585,244.
UNICENTRO CALI
EL TESORO
BUENA VISTA CARIBE PLAZA
FONTANAR^ SANTA FE
GRAN ESTACION
CAÑAVERAL LOS MOLINOS JARDIN PLAZA
Chart Title ENERO FEBRERO MARZO
14%^ 11%
PORCENTAJE DE VENTAS POR TIENDA
UNI
EL T
BUE
CAR
FON
SAN
GRA
CAÑ
LOS
JAR
UNICENTRO CALI
EL TESORO
BUENA VISTA CARIBE PLAZA
FONTANAR^ SANTA FE
GRAN ESTACION
CAÑAVERAL LOS MOLINOS JARDIN PLA
VENTAS DEL PRIMER TRIMESTRE POR TIENDA
ENERO FEBRERO MARZO
TIENDAS
VENTAS EN MILLONES
NTAS POR TIENDA
UNICENTRO CALI
EL TESORO
BUENA VISTA
CARIBE PLAZA
FONTANAR
SANTA FE
GRAN ESTACION
CAÑAVERAL
LOS MOLINOS
JARDIN PLAZA
NTANAR SANTA FE
GRAN ESTACION
CAÑAVERAL LOS MOLINOS JARDIN PLAZA
MESTRE POR TIENDA
RO MARZO
NDAS
SI: Como función lógica de comparación sirve para consultar si el valor es idéntico al valor esperado, o no, solo si
esta consulta es cierta podrá ocurrir un determinado evento. si la comparación es incorrecta se desencadena
otra acción.
ejemplo si =SI(E4=100000;"SI";"NO") en cambio si =SI(E5=87675698;"SI";"NO") ambas arrojan resultado
diferentes determinando la variable que se les determine como referencia para cumplimiento de dicha
condicional. resultado del ejemplo guía celdas (Q4 , Q5).
5% (^) FUNCIONES VALOR MAXIMO VALOR MINIMO BUSCARV 8.76% $ 6,444,450.55 42,963,003.67 60,567,658.00 32,754,676.00 6,444,450.55 0. 11.68% $ 8,591,596.75 57,277,311.67 87,675,698.00 5,857,889.00 8,591,596.75 1. 7.02% $ 5,163,246.20 34,421,641.33^ 78,567,753.00^ 7,868,878.00^ 5,163,246.20^ 0. 10.22% $ 7,519,515.40 50,130,102.67^ 78,679,858.00^ 26,377,883.00^ 7,519,515.40^ 1. 10.67% $ 7,849,803.60 52,332,024.00 76,478,889.00 7,767,689.00 7,849,803.60 0. 14.16% $ 10,422,710.55 69,484,737.00 102,876,746.00 5,789,988.00 10,422,710.55 0. 13.19% $ 9,708,280.65 64,721,871.00 91,018,937.00 12,467,889.00 9,708,280.65 1. 4.91% $ 3,616,065.35 24,107,102.33^ 57,886,756.00^ 6,335,778.00^ 3,616,065.35^ 0. 6.49% $ 4,776,245.15 31,841,634.33 88,987,678.00 1,103,979.00 4,776,245.15 1. 12.90% $ 9,495,042.80 63,300,285.33 86,754,568.00 24,156,388.00 9,495,042.80 1. 100.00% $ 73,586,957.
pecifica
REFERENCIA
ABSOLUTA
PORCENTAJE
DE VENTAS
TOTALES
COMISIONES
EMPLEADOS SOBRE
VENTAS
PROMEDIO DE
VENTA TIENDA
TRIMESTRAL Y - FUNCION LÓGICA
, si la celda I4 contiene
4.450,60 se aplica esta
e convierta en el
a sumatoria completa
r ejemplo hacer
a fórmula quedaría:
de un documento a otro
ctura desde el
o destino presionamos
ft + F10 o haz clic con el
FUNCIONES CONCATENAR FUNCION SI CONTAR TRANSPONER RAFAELCASTRO NO 6,444,450.60 6 12,467,889. NELLYHURTADO SI 8,591,596.80 6 6,335,778. ISABELLASUAREZ NO 5,163,246.20 6 5,433,246. PATRICIAFRANCO SI 7,519,515.40 6 86,754,568. FRANCISCOPEREZ NO 7,849,803.60 6 45,332,567. DIEGOGUTIERREZ SI 10,422,710.60 6 88,987,678. MANUELBELTRAN NO 9,708,280.70 6 78,989,900. GONZALOLEON NO 3,616,065.40 6 674,241,543. CAMILOLEYTON SI 4,776,245.20 6 88,987,678. SILVIAMARQUEZ NO 9,495,042.80 6 78,989,900.