supply chain spend analytics dashboard overview





π Supply Chain / Spend Analytics Dashboard Overview
Focus Areas: Shipping Methods π | Product Categories π¦ | Supplier Performance π§Ύ
Period Covered: 2021β2023
βοΈ 1. Shipping Method Spend
- Air: $9.87M (highest spend)
- Ground: $8.48M
- Sea: $9.11M
π Insight:
Air shipping leads in spend but only slightly edges out sea and ground. Assess trade-offs: speed vs. cost. Air may offer speed, but is the premium worth it?
π¦ 2. Spend by Product Subcategory
- Top Subcategory: βQMβ β $2.1M π° (likely high-priority)
- Others: Range from $0.1Mβ$1.5M
π Insight:
βQMβ commands the largest share. Prioritize procurement optimization, supplier terms, and accurate demand forecasting here.
π§Ύ 3. Supplier Spend Analysis
- #1: C King-Rodriguez β $934.64K (9.47% of total) π₯
- Others: (e.g., Smith PLC, White and Sons): $400Kβ$600K (β4β6% each)
- Long Tail: Dozens of smaller suppliers contributing <5% individually
π Insight:
Consider supplier consolidation. Strengthening ties with high-spend partners may yield cost savings and improve operational synergy.
π¦π 4. Total Stock Received by Supplier
- Repetitive data labels suggest unclear correlation
- Spend vs. volume delivered needs clarity
π Action:
Correlate inventory volumes with spend. Spot mismatches like high spend/low volume (or vice versa) to fix overstocking or supplier inefficiencies.
π Key Recommendations
- π Optimize Shipping: Assess if air freight's premium brings enough value. Shift toward ground/sea where feasible.
- π€ Supplier Rationalization: Focus on key suppliers like C King-Rodriguez for volume leverage, better pricing, and streamlined onboarding.
- π― Product Subcategory Focus: Double down on βQMβ β deploy forecasting tools and dynamic reorder strategies to stay ahead.
- π Clarify Data Gaps: Refine metrics around stock received to ensure inventory aligns with actual spend and consumption.




















