Filter
By analysis area and review status.
Deadstock concentration in legacy hydraulic spare parts
210 SKUs (4.4% of the assortment) had no outbound movement for more than 180 days while standing reorder rules kept replenishing them.
inventory_master_2026.csv — 4,812 SKUs analysed, 210 without movement >180d, €620,400 stock value bound.
Freeze reorder rules for the 210 SKUs and start a phased liquidation with the sales team.
On-time delivery decline at IronPro GmbH
IronPro on-time delivery dropped from 91% to 78% within two quarters, driving buffer stock and expedited freight.
supplier_performance.xlsx — 3,204 purchase orders, promised vs. received date delta, Q3/2025 vs. Q1/2026.
Escalate with structured OTD scorecard and agree a recovery plan with penalty clause.
SLA breaches on oversized freight lanes
24.1% of oversized shipments miss the agreed delivery window on the Dachser and Raben lanes.
transport_2026.csv — 9,140 shipments, agreed vs. actual transit time per lane.
Re-tender the three worst lanes and introduce monthly SLA scorecards.
Return root causes not consistently categorised
38% of return records carry free-text reasons instead of a category code, blocking root-cause analysis.
returns_2026.csv — 2,760 returns, 1,049 without category code, 3 of 5 warehouses affected.
Enforce a mandatory reason-code list in the returns intake mask.
Picking backlog peaks every Monday
Monday order backlog is 2.3x the weekly average, pushing 11% of orders past the cut-off promise.
orders_2026.csv — 48,200 order lines, backlog per weekday, Jan–Jun 2026.
Shift 1.5 FTE from Thursday to Monday early shift for a 6-week pilot.
Safety stock parameters not updated since 2023
Safety stock levels for 1,140 SKUs still use 2023 demand variance, overshooting current demand by 22%.
inventory_master_2026.csv + demand history — parameter change log empty since 11/2023.
Recalculate safety stock quarterly and assign ownership to planning.