AR Collections Velocity

Cash Flow Acceleration View | Meridian Industrial Supply Co.

DSO
43.2
+4.1 days vs PY
CEI
87.3%
+2.1% MoM
Cash Collected Variance
-2.4%
$14.2M collected WTD
Promise-to-Pay Fulfillment
73.8%
-3.4% vs target
Dispute Exposure
$3.7M
14 open disputes
WACP (Weighted Avg)
81.2%
$61.4M total AR

Cash Collected vs Forecast — 13 Week Rolling

AR Aging Distribution

WACP Trend (12 Weeks)

DSO Trend (12 Months)

Collector Productivity Index

Sarah Chen
142
Marcus Rodriguez
128
Aisha Patel
119
David Kim
111
Emma Thompson
98
Index = ($ Collected / $ Assigned) × 100, rolling 4 weeks

Payment Behavior Clusters

Dispute Resolution Cycle

Avg Resolution Time 18.4 days
Open >30 days 6 ($2.8M)
Resolved This Month 11 ($1.2M)
Escalated to Legal 2 ($1.9M)
Top Dispute Category
Pricing Discrepancy
$2.4M exposure

Early Pay Discount ROI

Utilization Rate 22.7%
Avg Discount Granted 1.8%
DSO Reduction (EPD Accts) -12.3 days
Discount Cost $186K
Working Capital Savings $412K
Net Benefit
$226K

AR Aging Detail — Top 10 At-Risk Accounts

Customer Name Account # Total AR 0-30 31-60 61-90 90+ WACP Risk Collector
Cascade LLC AR-10429 $1,947,200 $0 $0 $47,200 $1,900,000 34% Critical Legal
Harbor Tech Industries AR-10381 $724,300 $0 $24,300 $700,000 $0 48% High S. Chen
Precision Metalworks AR-10512 $612,800 $112,800 $500,000 $0 $0 72% Medium M. Rodriguez
Apex Manufacturing AR-10298 $487,500 $0 $137,500 $350,000 $0 61% Medium A. Patel
Northern Supply Chain AR-10634 $394,200 $94,200 $300,000 $0 $0 84% Low D. Kim
Titan Fabrication AR-10445 $368,900 $168,900 $200,000 $0 $0 89% Low E. Thompson
Redstone Industrial AR-10573 $321,400 $21,400 $0 $300,000 $0 68% Medium S. Chen
Skyline Components AR-10691 $287,600 $287,600 $0 $0 $0 96% Low M. Rodriguez
Delta Engineering AR-10522 $264,800 $64,800 $200,000 $0 $0 82% Low A. Patel
Vanguard Systems AR-10408 $241,900 $0 $41,900 $200,000 $0 65% Medium D. Kim

Promise-to-Pay Fulfillment Timeline — 8 Week Forward

Bad Debt Reserve Status

Reserve Balance $2,847,000
90+ DPD Exposure $1,947,000
Coverage Ratio 146%
YTD Write-offs $421,000
Write-off Rate 0.12%
Reserve Adequacy
Sufficient
Target: 125% of 90+ DPD