supply chain

Supply Chain Summary (Post-Cleanup)

After cleaning the data (duplicates, missing values, date issues), here are the key takeaways:

Main Highlights:

Strong Growth:

Revenue is up 8% to $87M, and orders increased by 7.7%.

Supplier Imbalance:

Top suppliers (e.g., Faulkner-Howard) are performing well, while others lag behind.

Customer Drop:

Annual growth is +4%, but there’s a 7.55% decline since July 2024 — needs investigation.

“Wear” Product:

Highest in revenue ($810K), but also leads in cancellations (43) and shipping costs.

Order Cancellations:

A staggering 25% of orders are canceled — this is a serious issue.

Shipping Inefficiency:

“Wear” makes up <1% of inventory but over 8% of shipping costs.

️ Recommendations:

Urgently investigate the 25% cancellation rate.

Deep dive into “Wear” — assess quality, pricing, and shipping.

Support low-performing suppliers to close performance gaps.

Focus on existing customers, and increase their order values.

Review shipping strategy, especially for costly products like “Wear”.