Kenneth

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