Meridian Industrial Supply Co. | Rolling 90-Day Period Ending Apr 30, 2024
| Vendor | Current | 1-30 Days | 31-60 Days | 61-90 Days | 90+ Days | Total Open | Status |
|---|---|---|---|---|---|---|---|
| Acme Industrial Parts | $142,800 | $28,400 | $12,100 | $3,200 | $8,400 | $194,900 | Review |
| Global Supply Chain Ltd | $218,300 | $41,200 | $6,700 | $0 | $0 | $266,200 | OK |
| Delta Manufacturing Co | $98,700 | $19,400 | $14,300 | $7,200 | $5,100 | $144,700 | Review |
| Omega Logistics Group | $167,200 | $22,800 | $4,100 | $0 | $0 | $194,100 | OK |
| Horizon Equipment Rental | $54,200 | $18,900 | $21,400 | $11,200 | $14,600 | $120,300 | Urgent |
| Zenith Packaging Solutions | $89,100 | $12,300 | $2,800 | $0 | $0 | $104,200 | OK |
| Premier Tech Services | $123,400 | $34,700 | $8,900 | $2,100 | $0 | $169,100 | OK |
| Velocity Distribution Inc | $76,800 | $15,200 | $9,700 | $6,300 | $3,800 | $111,800 | Review |
| Metric | Current | Target | Variance | Trend (QoQ) | Status |
|---|---|---|---|---|---|
| Straight-Through Processing Rate | 68.4% | 74.0% | -5.6 pp | +3.2% | Action |
| Invoice Cycle Time (Avg Days) | 4.7d | 3.8d | +0.9d | +0.3d | Action |
| Exception Rate | 14.2% | 11.0% | +3.2 pp | +2.1% | Urgent |
| PO Three-Way Match Rate | 81.6% | 85.0% | -3.4 pp | +1.8% | Action |
| Approval Escalation Rate | 8.3% | 6.0% | +2.3 pp | +0.7% | Action |
| OCR Accuracy Rate | 94.8% | 96.0% | -1.2 pp | +1.2% | On Track |
| Duplicate Detection Rate | 99.4% | 99.5% | -0.1 pp | +0.2% | On Track |
| Processor Throughput (Inv/FTE/Day) | 48.2 | 52.0 | -3.8 | -1.4 | Action |
| Invoice Aging >30 Days (% Open) | 18.7% | 15.0% | +3.7 pp | +1.2% | Action |
| Cost per Invoice Processed | $4.37 | $3.80 | +$0.57 | -$0.19 | Action |