Supply chain analysis
Product type
All
Power BI Desktop
SUPPLY CHAIN ANALYSIS
November 2024
Total Revenue
$174K
$578K
skincare
haircare
1292
Total Orders
$162K
1228
1141
899
5K
…
k
n
U
cosmetics
o
N
n…
Fe
…
m
M
e
l
a
Total Stocks
…
k
l
Ko
16.23
Carrier B
u…
M
…
g
n
Ba
Inspection Results For Available Products
Air
18.32
Carrier A
Road
2K
(40.56%)
$20…
Route A
Route C
2K (38.04%)
$22…
Route B
Pending
Fail
Pass
-
Products With The Most Revenue
Costs By Routes
SKU51
4840
2.11
Rail
20.13
Supplier 3
1K (21.4%)
i
h
l
e
D
Avg Defect rate
17.14
Carrier C
18.55
Supplier 2
…
e
h
C
733
Sea
18.06
Supplier 5
769
Avg Lead Time byTransportation Mode
15.22
Supplier 4
Cutting costs is an effective way of growing revenue,
stakeholders should consider using Route C more often.
Avg Lead Time by Shipping Carrier
14.78
Supplier 1
103.54%
-
5K
Our Inventory has produced a total of 56,784 products, 100 customers across 4 states
placed a total of 4922 orders which falls in the category of 3 distinct product types.
Avg Lead Time by Suppliers
Location
All
Stockturnover
1590
$242K
$10…
$9.9K
SKU38
$9.7K
SKU31
$9.7K
SKU90
$9.6K
SKU2
$9.6K
SKU32
$9.6K
SKU67
$9.5K
SKU88
$9.4K
SKU52
$9.4K
SKU18
$9.4K
Power BI Desktop
SUPPLY CHAIN ANALYSIS
November 2024
Product type
All
Location
All
Products
Products Breakdown
Breakdown
Product
results
Manufacturing
cost
Products
sold
Price
Revenue
generated
ProductProduct
Product type
typeSupplier
Supplier name
nameLocation
LocationInspection
Inspection
results
Manufacturing
cost
Products
sold
Price
Revenue
generated
SKU9
SKU10
SKU98
SKU94
SKU80
SKU9
SKU46
SKU36
SKU99
SKU37
SKU84
SKU11
SKU33
SKU78
SKU34
SKU40
SKU21
SKU44
SKU41
SKU91
SKU73
SKU98
skincare
skincare
skincare
cosmetics
skincare
skincare
haircare
skincare
haircare
skincare
haircare
skincare
cosmetics
haircare
skincare
skincare
cosmetics
cosmetics
skincare
cosmetics
ti
ki
Supplier
Supplier 25
Supplier
Supplier 52
Supplier
Supplier 32
Supplier
Supplier 32
Supplier
Supplier 23
Supplier
Supplier 52
Supplier
Supplier 55
Supplier
Supplier 11
Supplier
Supplier 52
Supplier
Supplier 44
SS
lili 45
Chennai
Kolkata Pending
Pass
Chennai
Pending
Delhi
Pass
Chennai
Chennai Fail
Pending
Chennai
Pending
Delhi
Fail
Chennai
Kolkata Fail
Pending
Chennai
Kolkata Pass
Pending
Chennai
Mumbai Fail
Pending
Chennai
Kolkata Pass
Pending
Chennai
Pending
Delhi
Fail
Chennai
Fail
Delhi
Pending
Ch
ii F Pil di
Ch
Avg Defect Rate by Location
Delhi
$4,971
$2,331
$8,526
$7,888
$8,652
$4,971
$2,557
$7,573
$9,185
$2,438
$2,048
$6,100
$5,150
$1,292
$9,062
$5,725
$7,087
$7,152
$5,521
$1,935
$7$-
Total Products Sold by Product Type
Carrier A
-
Mumbai
2.12
Bangalore
2.09
Locations and their shipping times
980
996$64
$-$20$-$91
$-$27
$-$69
$-$89
$-$65$-$37
$-$85
$-$99
$-$84
$20
Shipping Costs
Chennai
Kolkata
$48.0
$96.5
$5.6
$60.4
$77.0
$48.0
$77.3
$45.5
$38.1
$34.3
$33.8
$27.6
$23.9
$71.1
$10.8
$88.2
$61.7
$22.6
$95.3
$39.8
$46$5
96
Highest Revenue: SKUS1--$9866
Lowest Revenue : SKUS9--$1062
Most Expensive: SKU14--$8654
Cheapest: SKU5--$2
Most Sold: SKU10--996
Top Manufacturer: KolKota--25 Products
High Cost: Bangalore--$1116 in total
Low Cost: Delhi--$773 in total
20.…
$155.5
Sum of Shipping costs
Carrier B
13.…
$236.9
Sum of Shipping costs
11.…
Carrier C
$162.4
Sum of Shipping costs
skincare
Location
haircare
cosmetics
Location Max Shipping Average Shipping
Bangalore
Kolkata
Chennai
Mumbai
Delhi
Chennai
10
6.00