Power BI Desktop

Informe ejecutivo de gestión de negocios de la empresa

Compras

Producción

Almacén

Recursos Humanos

Ventas

Clientes

Datos actualizados
al
20/11/2022 17:40:22
 Power BI Desktop Datos actualizados al
Fecha
Menú 

Análisis de Gestión de Compras 30/06/2006  31/12/2014  20/11/2022 17:40:22

Proveedor 
Monto Pagado by Year and Month Monto Pagado by Proveedor
All 
Professional Athletic Consultants Promedio: $1.346.976,29 $6.117.549,90
$10M Vision Cycles, Inc. $6.096.321,00
Producto 
Chicago City Saddles $6.058.217,55
All  Proseware, Inc. $5.708.241,00
Sport Fan Co. $4.843.238,40
$0M
Superior Bicycles $4.555.897,50
Crowley Sport $4.475.601,90
4.012 Greenwood Athletic Company $4.475.601,90

Ordenes de Compra ($10M) Mitchell Sports $4.387.845,00

Jackson Authority $4.308.381,00
First Rate Bicycles $4.170.554,85
2012 2013 2014 2015
Signature Cycles $4.047.120,00

$115.839.961,03 Monto Pagado trended down, resulting in a 99,55% decrease between abril 2011 Electronic Bike Repair & Supplies $3.900.042,30
and septiembre 2014. West Junction Cycles $3.829.691,25
Monto Pagado
Vista Road Bikes $3.784.357,50
Monto Pagado started trending down on mayo 2014, falling by 99,99% ( Victory Bikes $3.462.574,50
$10.236.917,72) in 4 months.
Hill's Bicycle Service $2.891.057,40
Competition Bike Training Systems $2.886.345,00
Monto Pagado was trending up between abril 2013 and abril 2014 with a rise of
$1.124.659,82 $8.532.910,72 but had a significant change in trend and dropped by International Bicycles $2.876.331,15
Promedio mensual Monto $10.236.917,72 starting mayo 2014. Comfort Road Bicycles $2.863.372,05
Trikes, Inc. $2.491.912,50
Monto Pagado jumped from $1.188.032,17 to $9.720.942,90 during its steepest Hybrid Bicycle Center $2.296.705,95
incline between abril 2013 and abril 2014. Premier Sport, Inc. $2.155.807,50

97,76 % Expert Bike Co $2.093.313,09

American Bikes $2.080.524,60
InFull

InFull and OnTime by Proveedor InFull and OnTime by Producto

InFull OnTime InFull OnTime
100,00 %
OnTime G & K Bicycle Corp. Sport-100 Helmet, Black
International Sport Assoc. Sport-100 Helmet, Blue
Anderson's Custom Bikes Sport-100 Helmet, Red
OTIF Bicycle Specialists Metal Angle
Morgan Bike Accessories Metal Plate 3
Premier Sport, Inc. ML Mountain Seat/Saddle
Sport Playground Paint - Black

97,8 % 98,00 %
Allenson Cycles
Chicago Rent-All
Spokes
Front Derailleur Cage
0,00 % 100,00 %
Federal Sport Front Derailleur Linkage
First National Sport Co. Decal 2
Hill Bicycle Center LL Road Rim
Hybrid Bicycle Center ML Road Rim
99,98 % Inline Accessories Guide Pulley

Cumplimiento LeadTime Lakewood Bicycle HL Road Pedal

Varsity Sport Co. Touring Pedal
West Junction Cycles LL Road Tire
American Bikes LL Mountain Seat/Saddle
American Bicycles and Wheels LL Crankarm
Beaumont Bikes Touring Rim

0% 50 % 100 % 0% 50 % 100 %

Resumen por Productos

Descripcion ProductID Proveedor CantidadPedida CantidadRecibida CantidadRecibida by Fecha InFull Variacion Cantidad CantidadDevuelta CantidadDevuelta by Fecha

Adjustable Race 1 Litware, Inc. 154 153 98,04 % 1,00 153

All-Purpose Bike Stand 879 Green Lake Bike Company 400 400 100,00 % 0,00 400
AWC Logo Cap 712 Integrated Sport Products 630 630 100,00 % 0,00 630
Bearing Ball 2 Wood Fitness 150 150 100,00 % 0,00 150
Total 4.024.522 3.988.093 97,76 % 36.429,00 3.988.093
 Power BI Desktop Datos actualizados al
Menú Fecha 

30/06/2006  31/12/2014  20/11/2022 17:40:22

Análisis de Producción

Categoría  Productos Terminados by Year and Month Productos Terminados trended down, resulting in a 88,87% decrease between junio 2011
and junio 2014.
All 
Productos Terminados started trending down on marzo 2014, falling by 97,96% (46354) in
producto  100K
3 months.
All 
Productos Terminados was trending up between mayo 2013 and febrero 2014 with a rise
of 16975 but had a significant change in trend and dropped by 46354 starting marzo 2014.
Location 
Productos Terminados jumped from 22136 to 33733 during its steepest incline between
All 
50K mayo 2012 and septiembre 2012.

1.422.627
Productos Terminados

0K
jul 2011 ene 2012 jul 2012 ene 2013 jul 2013 ene 2014 jul 2014

Productos en proceso trended down, resulting in a 100,00% decrease between junio 2011
$21.073.339,04 Productos en proceso by Year and Month and junio 2014.
Costo de Producción
Productos en proceso started trending down on octubre 2012, falling by 14,44% (13) in 14
200 months.

$37.265.038,84 Productos en proceso dropped from 13 to 7 during its steepest decline between junio 2011
and marzo 2012.
Valor de Produccion
100

Productos en proceso by Categoría

43,45 %
Front Derailleur 348
Rentabilidad Esperada 0
LL Fork 280
ML Crankset 225
ene 2012 ene 2013 ene 2014 ene 2015 LL Road Handlebars 189
2.796 ML Headset 154
Productos en proceso by Location
Productos en proceso HL Mountain Handlebars 138
1.827 LL Bottom Bracket 107
Rear Derailleur 105
ML Mountain Front Wheel
7 Touring Rear Wheel 87
100

Locaciones de Fabricas HL Fork 76

HL Bottom Bracket 75
ML Road Handlebars 69
HL Mountain Frame 60
55 567
ML Road Rear Wheel 58
Categorias de Productos HL Road Handlebars 54
ML Road Frame-W 54
194 168 Road-650 52
20 14 6 LL Road Rear Wheel 47
140 Touring Front Wheel 47
Frame Frame Debur and Paint Specialized Subassembly Final
Variedad de Productos ML Fork 42
Forming Welding Polish Paint Assembly

ProductModel producto Productos % del Total Productos Terminados by Fecha Productos Productos en Costo de Producción Valor de Produccion Rentabilidad Esperada
Terminados en proceso proceso by Fecha

Front Derailleur Front Derailleur 181.814 12,78% 348 $89.773,74 $202.192,90 55,60 %
HL Bottom Bracket HL Bottom Bracket 23.010 1,62% 75 $58.472,69 $131.695,16 55,60 %
HL Crankset HL Crankset 14.555 1,02% 13 $128.747,97 $289.972,84 55,60 %
HL Fork HL Fork 96.986 6,82% 76 $224.981,07 $506.713,92 55,60 %
HL Headset HL Headset 14.169 1,00% 41 $39.652,15 $89.306,68 55,60 %
Total 1.422.627 100,00% 2.796 $21.073.339,04 $37.265.038,84 43,45 %
 Power BI Desktop Fecha Datos actualizados al
Menú 

Análisis de Gestión de Compras 30/06/2006  31/12/2014  20/11/2022 17:40:22

producto 
Ventas by Year and Month Ventas by Region
All  $6M

Region 
$4M
All 

vendedor  $2M

All 

$0M ©
© 2023
2023 Microsoft
Microsoft Corporation
Corporation

Ventas by vendedor
$80,49M 2012 2013 2014 2015

Linda Mitchell $10.367.007,43

Ventas Monto Pagado trended down, resulting in a 99,55% decrease between abril 2011
and septiembre 2014. Jillian Carson $10.065.803,54
Michael Blythe $9.293.903,00
Monto Pagado started trending down on mayo 2014, falling by 99,99% ( Jae Pak $8.503.338,65
$10.236.917,72) in 4 months.
4.012 Tsvi Reiter $7.171.012,75

Transacciones Monto Pagado was trending up between abril 2013 and abril 2014 with a rise of Shu Ito $6.427.005,55

$8.532.910,72 but had a significant change in trend and dropped by $10.236.917,72 José Saraiva $5.926.418,36
starting mayo 2014. Ranjit Varkey Chudukatil $4.509.888,93
David Campbell $3.729.945,35
Monto Pagado jumped from $1.188.032,17 to $9.720.942,90 during its steepest
$20.061,74 incline between abril 2013 and abril 2014.
Garrett Vargas $3.609.447,21

Ventas Promedio Pamela Ansman-Wolfe $3.325.102,59

Tete Mensa-Annan $2.312.545,69
Rachel Valdez $1.827.066,71
Lynn Tsoflias $1.421.810,92

53,47 Resumen por Productos

Cantidad Media producto ID Transacciones Cantidad Vendida Ventas Ventas by Fecha Ventas Promedio Rotación Mensual

4.012
AWC Logo Cap 712 4.012 6.121 $31.541,35 $7,86 59,43
Bike Wash - Dissolver 877 4.012 2.411 $11.188,37 $2,79 23,41
636 Cable Lock 843 4.012 1.087 $16.240,22 $4,05 10,55
Clientes que compraron
Total 4.012 214.516 $80.487.704,18 $20.061,74 2.082,68

Transacciones and Ventas by CustomerID

CustomerID (Blank) 29484 29485 29486 29487 29488 29489 29490 29491
$1,0M
Ventas

$0,5M

$0,0M
3K 4K 5K
Transacciones
 Power BI Desktop Datos actualizados al
Fecha
Menú 

Análisis de Almacén 30/06/2006  31/12/2014  20/11/2022 17:40:22

Categoria  Producto  Location 

All  All  All 

2.796
Productos en proceso

Quantity by Year
Existencia de insumos
29.666 Year 2011 2012 2013 2014 Total
producto May Total April Total April Total July August Total

All-Purpose Bike Stand 144 144 144

AWC Logo Cap 288 288 288

21.690 Bike Wash - Dissolver 36 36 36

Cable Lock 252 252 252

Chain 589 589 589

17.820
Classic Vest, L 252 252 252

Classic Vest, M 216 216 216

Classic Vest, S 180 180 180

Fender Set - Mountain 108 108 108

Front Brakes 767 767 767

8.642
Front Derailleur 853 853 853

Full-Finger Gloves, L 144 144 144

Full-Finger Gloves, M 108 108 108

Full-Finger Gloves, S 72 72 72

Half-Finger Gloves, L 36 36 36

Half-Finger Gloves, M 0 0 0

Half-Finger Gloves, S 324 324 324

2011 2012 2013 2014 Total 8.642 8.642 29.666 29.666 21.690 21.690 989 16.831 17.820 77.818

Entrada de productos terminados 1.422.627

Productos Terminados

Flujo de productos terminados al almacén

Year 2011 2012
producto June July August September October November December Total January February March April May June July August September October November Dec

All-Purpose Bike Stand 8.677 19.526 14.747 12.934 29.055 22.478 12.059 119.476 25.109 19.322 14.273 28.848 22.136 42.692 60.093 46.959 33.733 51.913 39.530

AWC Logo Cap 8.677 19.526 14.747 12.934 29.055 22.478 12.059 119.476 25.109 19.322 14.273 28.848 22.136 42.692 60.093 46.959 33.733 51.913 39.530

Bike Wash - Dissolver 8.677 19.526 14.747 12.934 29.055 22.478 12.059 119.476 25.109 19.322 14.273 28.848 22.136 42.692 60.093 46.959 33.733 51.913 39.530

Cable Lock 8.677 19.526 14.747 12.934 29.055 22.478 12.059 119.476 25.109 19.322 14.273 28.848 22.136 42.692 60.093 46.959 33.733 51.913 39.530

Chain 8.677 19.526 14.747 12.934 29.055 22.478 12.059 119.476 25.109 19.322 14.273 28.848 22.136 42.692 60.093 46.959 33.733 51.913 39.530

Classic Vest, L 8.677 19.526 14.747 12.934 29.055 22.478 12.059 119.476 25.109 19.322 14.273 28.848 22.136 42.692 60.093 46.959 33.733 51.913 39.530

Classic Vest, M 8.677 19.526 14.747 12.934 29.055 22.478 12.059 119.476 25.109 19.322 14.273 28.848 22.136 42.692 60.093 46.959 33.733 51.913 39.530

Classic Vest, S 8.677 19.526 14.747 12.934 29.055 22.478 12.059 119.476 25.109 19.322 14.273 28.848 22.136 42.692 60.093 46.959 33.733 51.913 39.530

Fender Set - Mountain 8.677 19.526 14.747 12.934 29.055 22.478 12.059 119.476 25.109 19.322 14.273 28.848 22.136 42.692 60.093 46.959 33.733 51.913 39.530

Front Brakes 8.677 19.526 14.747 12.934 29.055 22.478 12.059 119.476 25.109 19.322 14.273 28.848 22.136 42.692 60.093 46.959 33.733 51.913 39.530

Front Derailleur 8.677 19.526 14.747 12.934 29.055 22.478 12.059 119.476 25.109 19.322 14.273 28.848 22.136 42.692 60.093 46.959 33.733 51.913 39.530

Full-Finger Gloves, L 8.677 19.526 14.747 12.934 29.055 22.478 12.059 119.476 25.109 19.322 14.273 28.848 22.136 42.692 60.093 46.959 33.733 51.913 39.530

Full-Finger Gloves, M 8.677 19.526 14.747 12.934 29.055 22.478 12.059 119.476 25.109 19.322 14.273 28.848 22.136 42.692 60.093 46.959 33.733 51.913 39.530

Full-Finger Gloves, S 8.677 19.526 14.747 12.934 29.055 22.478 12.059 119.476 25.109 19.322 14.273 28.848 22.136 42.692 60.093 46.959 33.733 51.913 39.530

Half-Finger Gloves, L 8.677 19.526 14.747 12.934 29.055 22.478 12.059 119.476 25.109 19.322 14.273 28.848 22.136 42.692 60.093 46.959 33.733 51.913 39.530

Total 8.677 19.526 14.747 12.934 29.055 22.478 12.059 119.476 25.109 19.322 14.273 28.848 22.136 42.692 60.093 46.959 33.733 51.913 39.530 2
 Power BI Desktop Datos actualizados al
Menú Fecha 

30/06/2006  31/12/2014  20/11/2022 17:40:22

Analisis de la gestión del Talento Humano de la empresa
AdventureWorks de todas las gerenciasdel departamento
todos
Gerencia 

All  Contrataciones by Year and Month

Contrataciones by Gerencia
Departamento 
15 (5,07%) 60
All  19 (6,42%) Gerencia
28 Manufacturing
(9,46%)
Executive General a… 40
296
Sales and Marketing
Contrataciones
Inventory Manage…
20
36 Research and Deve…
(12,16%)
Quality Assurance
290
186 (62,84%) 0
Trabajadores Activos 2007 2008 2009 2010 2011 2012 2013

%GT Contrataciones by Grupo etareo Antiguedad promedio de activos by Gerencia

Contrataciones by Genero
6 39,53%
37,84% Quality Assurance 13,7
Trabajadores Retirados Femenino
87 (29,39%)
Manufacturing 13,7

2,03 %
Research and Development 13,6
Rotación de personal

14,53% Executive General and Adminis… 13,5

13,5 8,11% Inventory Management 13,1

Antiguedad promedio de activos
Masculino
209 (70,61%) Sales and Marketing 11,8

31-40 41-50 51-60 60 o más

2,1 0 10
Antiguedad promedio Retirados
Antiguedad promedio de activos by Departamento
Resumen por Productos
Cargo Contrataciones Trabajadores Activos Trabajadores Retirados Antiguedad promedio de activos Antiguedad promedio Retirados Engineering 13,9

Shipping and Receiving 13,9
Accountant 2 2 13,7
Human Resources 13,9
Accounts Manager 1 1 13,8
Information Services 13,9
Accounts Payable Specialist 2 2 13,8
Document Control 13,8
Accounts Receivable Specialist 3 3 13,9
Finance 13,8
Application Specialist 4 4 13,8
Research and Development 13,8
Assistant to the Chief Financial Officer 1 1 13,9
Production 13,7
Benefits Specialist 1 1 13,9 Quality Assurance 13,7
Buyer 9 9 13,0 Production Control 13,4
Chief Executive Officer 1 1 13,9 Marketing 13,3
Chief Financial Officer 2 1 1 9,0 4,8 Facilities and Maintenance 13,0
Control Specialist 2 2 13,8 Tool Design 12,8
Database Administrator 2 2 13,8 Purchasing 12,6

Design Engineer 3 3 13,9 Executive 11,4

Document Control Assistant 2 2 13,8 Sales 11,0

Total 296 290 6 13,5 2,1 0 10

 Power BI Desktop Datos actualizados al
Menú
20/11/2022 17:40:22

Resumen de la Cartera de Clientes rgistrados en el

Mundo

País 
Count of Cliente by CountryRegionName %GT Count of Cliente by Estado
All 
1,57K (8,49%) California 24,02%
7,84K
1,78K (9,62%) CountryRegionName Washington
(42,38%) 12,35%
United States England 10,34%
18.484 1,81K
Australia British Columbia 8,42%
(9,78%)
Clientes Registrados New South Wales 8,42%
United Kingdom
Oregon 5,80%
France
Victoria 4,83%
Germany Queensland 4,28%
1,91K
(10,34%) Canada Saarland 2,39%
Nordrhein-Westfalen 2,19%
3,59K (19,4%)
Seine (Paris) 2,09%
Hessen 2,04%
%GT Clientes Registrados by
Hamburg 1,60%
Ventas by City EmailPromotion
Seine Saint Denis 1,54%
60%
Nord 1,53%
55,89% South Australia 1,29%
Bayern 1,23%
Hauts de Seine 1,05%
40% Yveline 0,91%
Essonne 0,81%

25,25% Tasmania 0,57%

Loiret 0,32%
18,86%
20% Seine et Marne 0,32%
Moselle 0,30%
Brandenburg 0,16%
Garonne (Haute) 0,16%
Val de Marne 0,16%
0%
©
© 2023
2023 Microsoft
Microsoft Corporation
Corporation 0 1 2 Val d'Oise 0,16%
Somme 0,12%