--- name: working-capital-optimization description: Optimize working capital through DSO, DPO, and DIO management, cash conversion cycle improvement, working capital facilities, and liquidity management. Analyze working capital trends, identify improvement opportunities, and design working capital targets. Triggers on phrases like "working capital optimization", "cash conversion cycle", "DSO reduction", "DPO extension", "DIO improvement", "working capital facility", "revolver", "overdraft", "working capital target", "CCC improvement", "net working capital", "liquidity management", "trade finance", "supply chain finance". --- # Working Capital Optimization Optimize working capital through accounts receivable, accounts payable, and inventory management to minimize cash conversion cycle and maximize liquidity. ## Workflow ### 1. Working Capital Components Analysis ``` WORKING CAPITAL TRIANGLE ═══════════════════════════════════════ Component Metric Current Industry Gap $ Impact (Days) (Days) Benchmark ───────────────────────────────────────────────────────────────────────────── Accounts Receivable DSO 62 days 45 days +17 ($13.5M) Inventory DIO 45 days 35 days +10 ($4.2M) Accounts Payable DPO 55 days 60 days -5 $6.8M ───────────────────────────────────────────────────────────────────────────── CASH CONVERSION CCC 52 days 20 days +32 ($10.9M) CYCLE CCC = DSO + DIO - DPO Current CCC: 62 + 45 - 55 = 52 days Target CCC: 45 + 35 - 60 = 20 days REVENUE BASE: $450M annualized Daily revenue: $1,233,000 Daily COGS: $875,000 WORKING CAPITAL INVESTED: ═══════════════════════════════════════ Component Days Daily Rate Total Invested ───────────────────────────────────────────────────────────── Accounts Receivable 62 $1,233,000 $76,446,000 Inventory 45 $875,000 $39,375,000 Accounts Payable 55 $875,000 ($48,125,000) ───────────────────────────────────────────────────────────── NET WORKING CAPITAL: $67,696,000 TARGET WORKING CAPITAL: ═══════════════════════════════════════ Component Target Days Daily Rate Target Invested ───────────────────────────────────────────────────────────────── Accounts Receivable 45 $1,233,000 $55,485,000 Inventory 35 $875,000 $30,625,000 Accounts Payable 60 $875,000 ($52,500,000) ───────────────────────────────────────────────────────────────── TARGET NWC: $33,610,000 CASH RELEASE POTENTIAL: $67,696,000 - $33,610,000 = $34,086,000 ``` ### 2. DSO Improvement Strategies ``` DSO OPTIMIZATION — Current: 62 days → Target: 45 days ═══════════════════════════════════════ AGING ANALYSIS: ═══════════════════════════════════════ Bucket Amount % of Total Trend Risk ──────────────────────────────────────────────────────────── Current $30,000K 39% → LOW 1-30 days $18,000K 24% → LOW 31-60 days $12,000K 16% ↑ MEDIUM 61-90 days $9,000K 12% ↑ HIGH 91-180 days $5,000K 7% ↑ HIGH 180+ days $2,446K 3% → VERY HIGH ──────────────────────────────────────────────────────────── TOTAL: $76,446K 100% TOP 10 CUSTOMERS (by overdue balance): ═══════════════════════════════════════ Rank Customer AR Balance Overdue Avg Age Collection Effort ────── ────────── ─────── ─────── ────────────────── 1 Customer A $5,200K $3,800K 85 days Assigned to manager 2 Customer B $4,100K $2,900K 72 days Weekly follow-up 3 Customer C $3,500K $2,100K 95 days Disputed invoice 4 Customer D $2,800K $1,600K 68 days Standard collection 5 Customer E $2,200K $1,400K 110 days Skip traced DSO IMPROVEMENT INITIATIVES: ═══════════════════════════════════════ Initiative Impact (Days) Investment Timeline Confidence ───────────────────────────────────────────────────────────────────────────── Electronic invoicing -5 days $150K 60 days HIGH Early payment discount (2/10) -3 days $500K cost 30 days HIGH Automated dunning emails -3 days $50K 30 days HIGH Credit hold enforcement -2 days $0 Immediate MEDIUM Customer payment portal -2 days $100K 90 days MEDIUM Factoring program -4 days $75K fees 60 days HIGH ───────────────────────────────────────────────────────────────────────────── TOTAL IMPROVEMENT: -19 days (to 43 days — exceeds target) FINANCIAL IMPACT: ═══════════════════════════════════════ Early payment discount cost analysis: → 2% discount for payment within 10 days → Estimated uptake: 30% of receivables = $22.9M → Discount cost: $22.9M × 2% = $458,000 → Cash released: $16.5M (from DSO reduction) → Cost of capital (5%): $16.5M × 5% = $825,000 annual savings → Net benefit: $825K - $458K = $367K annually ✓ Factoring program: → Factor rate: 1.5% of factored amount (90-day financing) → Factoring $30M: Annual cost = $30M × 1.5% × 4 = $1.8M → Cash released: $30M (immediate) → Alternative: DSO reduction initiatives cost $850K total → Recommendation: Implement DSO initiatives first; use factoring as backup ``` ### 3. DPO Optimization ``` DPO OPTIMIZATION — Current: 55 days → Target: 60 days ═══════════════════════════════════════ VENDOR PAYMENT ANALYSIS: ═══════════════════════════════════════ Vendor Tier AP Balance Avg Terms Avg Payment Opportunity ────────── ──────── ───────── ───────────── Strategic (A) $15,000K Net 30 Day 28 -2 days (early) Major (B) $12,000K Net 45 Day 42 -3 days (early) Standard (C) $8,000K Net 60 Day 58 -2 days (early) Small (D) $5,000K Net 30 Day 35 +5 days (late) ────────────────────────────────────────────────────────────────── TOTAL: $40,000K DPO IMPROVEMENT INITIATIVES: ═══════════════════════════════════════ Initiative Impact (Days) Cost Timeline ───────────────────────────────────────────────────────────────────── Negotiate longer terms +3 days $0 90 days (A and B tier vendors) Optimize payment timing +2 days $0 30 days (pay on last day, not early) Supply chain finance +5 days $100K/yr 120 days (vendor early payment program) AP automation +1 day $200K 60 days (eliminate processing delays) ───────────────────────────────────────────────────────────────────── TOTAL IMPROVEMENT: +11 days (to 66 days) SUPPLY CHAIN FINANCE PROGRAM: ═══════════════════════════════════════ Program: Vendor Early Payment Program (VEPP) How it works: → Bank provides early payment to vendors → Company pays on original terms (Net 60) → Vendor receives discount (typically 0.5-1.5% annualized) → Company extends effective payment period Financial impact: → AP eligible: $35,000K (all vendors except strategic) → Vendor participation: 60% = $21,000K → Effective DPO extension: +5 days → Cash benefit: $21,000K × 5/365 = $288K (already captured in DPO) → Program cost: $100,000/year → Vendor discount on $21M: ~$250K/year (benefit to vendors) → Win-win: Vendors get better rates than their own cost of capital RISK CONSIDERATIONS: → Maintain vendor relationships (don't push too hard) → Strategic suppliers: Keep payment terms competitive → Never pay late on strategic vendors (supply chain risk) → Monitor vendor financial health (early payment can help struggling vendors) ``` ### 4. Inventory Optimization ``` INVENTORY OPTIMIZATION — Current DIO: 45 days → Target: 35 days ═══════════════════════════════════════ INVENTORY ANALYSIS: ═══════════════════════════════════════ Category Value % of Total Turnover DIO Status ───────────────────────────────────────────────────────────────────── Raw Materials $15,000K 38% 16x/yr 23d GOOD ✓ WIP $10,000K 25% 10x/yr 36d FAIR Finished Goods $14,375K 37% 8x/yr 45d POOR ⚠ ───────────────────────────────────────────────────────────────────── TOTAL: $39,375K 100% 10x/yr 36d TARGET: 35d ABC ANALYSIS: ═══════════════════════════════════════ Class SKUs % of SKUs % of Value Strategy ───────────────────────────────────────────────────── A 150 15% 70% Tight control, JIT B 300 30% 20% Standard control C 550 55% 10% Minimize, automate reorder SLOW-MOVING/Obsolete Inventory: ═══════════════════════════════════════ SKU Value Last Move Age Disposition Recovery ────────────────────────────────────────────────────────────────── SKU-1001 $500K 18 months 3 yrs Liquidate 40% ($200K) SKU-1002 $350K 24 months 4 yrs Scrap 10% ($35K) SKU-1003 $250K 12 months 2 yrs Discount sell 70% ($175K) ────────────────────────────────────────────────────────────────── TOTAL: $1,100K Write-off: $690K DIO IMPROVEMENT INITIATIVES: ═══════════════════════════════════════ Initiative Impact (Days) Savings Timeline ───────────────────────────────────────────────────────────────────── Liquidate slow-moving -5 days $1,100K 90 days Implement JIT for A items -3 days $450K 60 days Vendor-managed inventory -2 days $200K 120 days Demand forecasting improvement -2 days $150K 120 days ───────────────────────────────────────────────────────────────────── TOTAL IMPROVEMENT: -12 days (to 33 days — exceeds target) ``` ### 5. Working Capital Dashboard ``` WORKING CAPITAL OPTIMIZATION TRACKER ═══════════════════════════════════════ Metric Baseline Q1 Actual Q2 Target Q3 Target Annual Target ────────────────────────────────────────────────────────────────────────────────── DSO 62 days 58 days 52 days 48 days 45 days DIO 45 days 43 days 40 days 38 days 35 days DPO 55 days 57 days 60 days 62 days 65 days CCC 52 days 44 days 32 days 24 days 15 days ────────────────────────────────────────────────────────────────────────────────── NWC $67.7M $60.2M $50.8M $42.3M $34.1M Cash released $0 $7.5M $16.9M $25.4M $33.6M INITIATIVES STATUS: ═══════════════════════════════════════ Initiative Status Q1 Impact Q2 Planned Completion ──────────────────────────────────────────────────────────────────────────────── Electronic invoicing IN PROGRESS -1 day -2 days 70% Early payment discount COMPLETE -2 days -1 day 100% Automated dunning COMPLETE -1 day -1 day 100% Supply chain finance PLANNED $0 +2 days 10% Inventory liquidation IN PROGRESS -2 days -3 days 40% TOTAL CASH RELEASE: $34.1M IMPROVED CCC: 52 days → 15 days ROI: Cost of capital on $34.1M × 5% = $1.7M/year savings (vs $1.2M investment) ``` ## Edge Cases - **Seasonality**: Working capital needs fluctuate; use seasonal averages for targets - **Growth phase**: Rapid growth increases working capital needs (revenue growth = more AR) - **Negative working capital**: Possible with strong supplier/customer terms (Amazon model) - **Cross-border**: FX risk on working capital; hedge or local currency financing - **Supply chain disruption**: Buffer inventory may increase DIO temporarily ## Integration Points - **ERP**: SAP, Oracle (AR, AP, inventory modules) - **Collections systems**: HighTouch, Collectify (AR automation) - **AP automation**: Bill.com, Coupa, Tipalti (AP processing) - **Inventory systems**: Blue Yonder, Manhattan (inventory optimization) - **Cash management**: Treasury management systems (TMS) - **Trade finance**: Bank platforms, supply chain finance programs ## Output ### Working Capital Summary ``` WORKING CAPITAL OPTIMIZATION REPORT ═══════════════════════════════════════ Current CCC: 52 days → Target: 15 days (37-day improvement) NWC reduction: $67.7M → $34.1M ($33.6M cash release) Key initiatives: → DSO reduction: -17 days ($13.5M) → DIO reduction: -10 days ($4.2M) → DPO extension: +10 days ($8.8M) Annual savings: $1.7M (cost of capital on released cash) Implementation cost: $1.2M Payback period: 8 months ```