Working Capital Optimizer
يستخدم المديرون الماليون ومديرو الخزينة وفرق التمويل التشغيلي هذا الموجه لتحديد وقياس فرص تحسين رأس المال العامل — مفيد بشكل خاص قبل إعادة التمويل أو ضائقة التدفق النقدي أو كجزء من خطة خلق القيمة بعد الاستحواذ.
الأوامر
You are a CFO-level working capital specialist analyzing the cash conversion cycle for [COMPANY NAME], a [INDUSTRY] business reporting in [CURRENCY]. The company generated [ANNUAL REVENUE] in annual revenue and [COGS] in cost of goods sold for the period ending [PERIOD]. I will provide the current working capital metrics. Current Working Capital Metrics: - Days Sales Outstanding (DSO): [DSO DAYS] - Days Inventory Outstanding (DIO): [DIO DAYS] - Days Payable Outstanding (DPO): [DPO DAYS] - Cash Conversion Cycle (CCC): [CCC DAYS] (= DSO + DIO − DPO) - Accounts Receivable balance: [AR BALANCE] [CURRENCY] - Inventory balance: [INVENTORY BALANCE] [CURRENCY] - Accounts Payable balance: [AP BALANCE] [CURRENCY] Industry benchmarks for [INDUSTRY]: - Benchmark DSO: [BENCHMARK DSO] days - Benchmark DIO: [BENCHMARK DIO] days - Benchmark DPO: [BENCHMARK DPO] days Using this data, provide a comprehensive working capital optimization analysis: 1. **Benchmark Gap Analysis** For each of DSO, DIO, and DPO, calculate the gap between [COMPANY NAME]'s current metric and the industry benchmark. Classify each as: Outperforming, In-line (within 5 days), or Underperforming. Explain the operational implication of each gap. 2. **Cash Flow Improvement Estimate** For each underperforming metric, calculate the [CURRENCY] cash flow improvement achievable by closing 50% and 100% of the gap to benchmark. Show the formula and working: - DSO improvement: (Gap in days / 365) × Annual Revenue - DIO improvement: (Gap in days / 365) × COGS - DPO improvement: (Gap in days / 365) × COGS Sum the total potential cash release across all three components. 3. **Root Cause Hypotheses** For each underperforming metric, list two to three likely operational root causes specific to a [INDUSTRY] business — e.g., billing cycle delays, customer payment terms, slow-moving SKUs, or weak supplier negotiation leverage. 4. **Optimization Action Plan** Provide a prioritized 90-day action plan with specific initiatives for each working capital lever. For each action: state the expected impact, the team responsible, and the implementation complexity (Low / Medium / High). 5. **Monitoring KPIs** Recommend a monthly working capital dashboard with four to six KPIs management should track to confirm improvement and catch regression. Present findings in a structured report with summary tables and a prioritized recommendation list.
متغيرات الأمر
استبدل كل عنصر نائب بمعلوماتك الخاصة:
[COMPANY NAME][INDUSTRY][CURRENCY][ANNUAL REVENUE][COGS][PERIOD][DSO DAYS][DIO DAYS][DPO DAYS][CCC DAYS][AR BALANCE][INVENTORY BALANCE][AP BALANCE][BENCHMARK DSO][BENCHMARK DIO][BENCHMARK DPO]ما ستحصل عليه
جدول فجوة المعايير المرجعية لـ DSO وDIO وDPO مع علامات الأداء؛ وحساب تحسين التدفق النقدي عند 50% و100% من إغلاق الفجوة؛ وفرضيات الأسباب الجذرية لكل فجوة؛ وخطة عمل ذات أولوية لـ 90 يومًا مع مسؤولية الفريق؛ ولوحة متابعة شهرية موصى بها.
💡 نصيحة خبير
أجرِ هذا التحليل كل ربع سنة وتتبع اتجاه CCC بمرور الوقت — الارتفاع غير المفسر في CCC هو أحد أبكر تحذيرات التدهور التشغيلي أو انخفاض جودة الائتمان للعملاء.
أدوات الذكاء الاصطناعي المتوافقة
Claude
Best for root cause analysis and narrative action plan. Provide all metrics as a structured list. Claude will perform the cash improvement calculations and produce a board-ready report.
ChatGPT
Effective for quantitative cash improvement calculations. Use Code Interpreter to input the metrics and industry benchmarks as a small dataset — ChatGPT will compute all gap and cash release figures with precision.
Microsoft Copilot
Best when working capital data lives in Excel. Copilot can compute DSO/DIO/DPO from balance sheet and income statement cell ranges and immediately run the benchmark gap analysis.
Gemini
Useful for Google Workspace teams. Reference your Google Sheets working capital tracker and ask Gemini to run the gap analysis and write the action plan inline.