omni_ecommerce_return_reserve
Calculate GAAP/IFRS-aligned e-commerce return reserve funds, net leakage, and daily cash escrow from revenue, return rate, recovery rate, and return window to prevent cash flow shortfalls.
Instructions
E-Commerce Return Reserve & Allowance Fund Calculator. Calculate GAAP/IFRS compliant return allowance reserves to prevent unexpected cashflow shortfalls and comply with financial reporting standards. Discipline: ECOMMERCE. Governing mathematical model / formula: Reserve Balance = Gross Revenue × Historical Return Rate % × (1 - Recovery Rate %).
USAGE GUIDELINES:
WHEN TO USE: Invoke for deterministic calculation of recommended_return_reserve (Recommended Return Reserve Fund), net_unrecoverable_leakage (Net Unrecoverable Cash Leakage), daily_reserve_escrow (Daily Cash Flow Escrow Withholding), risk_tier_category (Balance Sheet Return Risk Tier) using trailing_monthly_gross_revenue (Monthly Gross Sales Revenue in $), historical_return_frequency_pct (Historical Return Rate (%) in %), inventory_resale_recovery_pct (Inventory Resale Recovery Rate (%) in %), return_window_days (Store Return Policy Window (Days) in days). Guarantees exact machine floating-point precision, eliminating LLM arithmetic mistakes and formula hallucinations.
WHEN NOT TO USE: Do not use for qualitative evaluations or unquantified reasoning. All input parameters must be valid numerical values.
DISAMBIGUATION & BOUNDARIES:
Use this dedicated specialist tool for 'E-Commerce Return Reserve & Allowance Fund Calculator' rather than generic dispatchers like omni_universal_query.
For multi-calculation chained jobs, use 'omni_batch_calculate'.
To inspect schema fields, see 'omni_describe_solver'.
BEHAVIOR & SAFETY:
Pure deterministic computation with machine floating-point precision.
Read-only, idempotent, and stateless. Zero side effects or persistent state mutations.
Input validation: All arguments are validated against physical and domain bounds. Out-of-bounds inputs return a safe diagnostic error status without throwing runtime exceptions.
RETURNS:
Structured JSON object containing:
status (string): "success" on valid execution or "error" if validation fails
calculator (string): "ecommerce-return-reserve"
category (string): "ecommerce"
name (string): "E-Commerce Return Reserve & Allowance Fund Calculator"
formula (string): Governing mathematical formula string
inputs (object): Echoed input parameter dictionary with applied defaults
metrics (object): Dictionary of computed outputs:
metrics.recommended_return_reserve (Recommended Return Reserve Fund): Formatted display string (e.g. '$32,200')
metrics.net_unrecoverable_leakage (Net Unrecoverable Cash Leakage): Formatted display string (e.g. '$11,270 / mo')
metrics.daily_reserve_escrow (Daily Cash Flow Escrow Withholding): Formatted display string (e.g. '$1,073 / day')
metrics.risk_tier_category (Balance Sheet Return Risk Tier): Formatted display string (e.g. 'Moderate Apparel / Goods Risk')
execution_time_ms (number): Latency in milliseconds.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "omni_ecommerce_return_reserve"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| return_window_days | No | Store Return Policy Window (Days) (days). Allowable customer return duration. Default: 30. Min: 14. Max: 90. | |
| inventory_resale_recovery_pct | No | Inventory Resale Recovery Rate (%) (%). Percentage of returned goods successfully resold at full or clearance price. Default: 65. Min: 0. Max: 100. | |
| trailing_monthly_gross_revenue | No | Monthly Gross Sales Revenue ($). Gross credit card billings prior to refunds. Default: 280000. Min: 10000. Max: 10000000. | |
| historical_return_frequency_pct | No | Historical Return Rate (%) (%). Average return rate over the trailing 12 months. Default: 11.5. Min: 1. Max: 40. |