Hi-Tech Business Analysis
Country
All
HI-TECH BUSINESS PERFORMANCE ANALYSIS
Sales Performance
Customer Insight
Profitability & Expansion
Analysis
Inventory Optimization
Customer Sector
All
Average Sales by Quarter, Month and Product Category
Sales Amount by
Region
£28K
North America
Jan
Feb
Mar
Apr
£53M
£252M
Jul
Aug
Sep
Oct
3
Nov
60.8%
Sensor
Robotics
Microchip
Sensor
Robotics
Microchip
Sensor
Robotics
Microchip
Sensor
Robotics
Microchip
Sensor
Robotics
Microchip
Sensor
Robotics
Microchip
Sensor
Robotics
Jun
2
Asia-Pacific
Europe
19.7%
19.5%
Dec
4
Total Sales Amount by Month
Sales by Top 5 Customers
£23.2M
£22.0M
Total Sales Amount
Microchip
Sensor
May
1
Sum of Profit
Robotics
Microchip
Sensor
Robotics
Microchip
Sensor
Robotics
Microchip
Sensor
Robotics
501K
Microchip
Total Quantity Sold
Sensor
£22K
Robotics
500
£24K
Microchip
No. of Customers
£26K
£22.4M
£22.2M
£21.6M
£21.3M
£21.0M
£20.5M
£1.6M
Customer_95
£1.4M
Customer_96
£1.2M
Customer_98
£21.1M
£19.5M
Average Sales
£25.24K
£1.0M
Customer_93
£19.0M
Jan
Feb
Mar
Apr
£18.7M
May
Customer_99
Jun
Jul
Aug
Sep
Oct
Nov
Dec
£0.5M
Country
All
HI-TECH BUSINESS PERFORMANCE ANALYSIS
Customer Insight
Sales Performance
Customer Sector
All
Profitability & Expansion
Analysis
Inventory Optimization
Quantity Sold by Sector and Product Category
Industrial
Sales by Customer Sector
38%
32%
30%
No. of Customers
500
31.2%
Consumer Electronics
40%
30%
35.4%
30%
33.4%
Total Quantity Sold
Automotive
501K
37%
33%
Microchip
Robotics
Sum of Profit
Customer Sector
£53M
Industrial
Total Sales Amount
£252M
Average Sales
£25.24K
Profit Generated
£53,094,315
×
30%
Sensor
Region
Industrial
×
Country
North America
Industrial
£19,951,459
North America
£12,743,104
USA
£5,353,487
Consumer Electronics
£16,873,719
Europe
£3,818,421
China
£4,049,898
Automotive
£16,269,137
Asia-Pacific
£3,389,934
Japan
£3,339,719
×
Consumer Electronics
Automotive
Transactions by Customer Sector
35%
Industrial
33%
Consumer
Electronics
32%
Automotive
Country
All
HI-TECH BUSINESS PERFORMANCE ANALYSIS
Sales Performance
Customer Sector
All
Profitability & Expansion
Analysis
Inventory Optimization
Customer Insight
Average Production Cost Vs Average Sales
No. of Customers
500
Total Quantity Sold
Jan
Feb
1
Mar
501K
Sum of Profit
£53M
Total Sales Amount
£252M
Average Sales
£25.24K
Apr
May
2
Jun
Jul
Average Production Cost
Aug
3
Sep
Oct
Nov
4
Dec
Average Sales
Product Category Microchip
Robotics
Sensor
Month
Sum of Unit Price Sum of Production Cost Sum of Unit Price Sum of Production Cost Sum of Unit Price Sum of Production Cost
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Total
£167,985
£141,643
£143,820
£180,745
£154,098
£163,043
£171,181
£167,239
£146,525
£170,206
£164,129
£177,623
£136,375
£112,757
£121,506
£141,093
£124,744
£132,440
£131,654
£124,292
£116,764
£124,609
£124,477
£139,038
£123,071
£120,690
£125,140
£147,268
£112,047
£138,856
£137,777
£142,476
£152,230
£119,220
£145,767
£132,151
£100,353
£94,253
£107,873
£110,055
£95,078
£103,004
£104,964
£113,456
£104,837
£95,225
£112,450
£107,545
£122,955
£117,131
£116,735
£127,221
£128,186
£123,260
£143,881
£138,158
£126,946
£127,751
£120,897
£132,187
£94,447
£92,696
£93,468
£95,963
£103,352
£101,699
£111,239
£107,616
£104,344
£100,238
£101,756
£105,176
£1,948,237
£1,529,749
£1,596,693
£1,249,093
£1,525,308
£1,211,994
HI-TECH BUSINESS PERFORMANCE ANALYSIS
Sales Performance
Customer Sector
All
Customer Insight
Top 10 Average Profit Margin by
Product Name
Increase
Bottom 10 Average Profit Margin by
Product Name
Decrease
Increase
37.6%
30.6%
-3.01
-3.16
30.9%
0.30
-3.28
501K
0.28
Microchip
-3.38
0.27
Sum of Profit
Robotics
31.8%
Sensor
Industrial
Consumer Electronics
Automotive
Sales by Country
-3.85
0.24
£53M
-3.91
0.24
-4.06
0.23
Total Sales Amount
Germany
USA
0.23
-4.64
China
Japan
0.22
Product_1389
Product_1032
Product_1010
Product_1148
Product_1500
Product_1099
Product_1165
Product_1486
Product_1088
Product_1388
Product_1022
Product_1260
Product_1253
Product_1464
Product_1062
Product_1481
-4.80
Product_1196
£25.24K
39.6%
29.5%
0.36
Total Quantity Sold
Average Sales
Profit by Customer Sector
-2.97
500
£252M
Profit by Product Category
Decrease
0.48
No. of Customers
Profitability & Expansion…
Inventory Optimization
Product_1328
Product_1163
All
Product_1019
Country
South Korea
©
©- TomTom,
TomTom, ©
©- Microsoft
Microsoft Corporation,
Corporation, ©
© OpenStreetMap
OpenStreetMap