Overview of Calculated Metrics
The RTO Profit Simulator calculates seven key metrics based on your inputs. Each metric provides critical insights into your business performance and RTO impact. This guide explains each metric in detail based on the calculation logic insrc/utils/calculations.js.
All metrics are calculated for monthly view by default. Toggle to Annual Projection to see metrics multiplied by 12 for yearly planning.
Input Parameters
Before diving into calculated metrics, let’s understand the input parameters that drive all calculations:Core Business Inputs
Monthly Orders
Monthly Orders
What it is: Total number of orders you process per month across all payment methods.Default: 10,000 ordersHow to determine yours:
- Check your e-commerce dashboard
- Use average from last 3 months for consistency
- Exclude cancelled orders (only count dispatched orders)
Average Order Value (AOV)
Average Order Value (AOV)
What it is: The average value of each order placed.Default: ₹1,500Calculation: Total Revenue / Total OrdersHow to determine yours:Example: If you made ₹50,00,000 from 5,000 orders:
COD Percentage
COD Percentage
What it is: Percentage of total orders placed with Cash on Delivery payment method.Default: 60%How to determine yours:
Industry benchmarks:
- Tier 1 cities: 30-50% COD
- Tier 2/3 cities: 60-80% COD
- Rural areas: 80-90% COD
RTO Percentage
RTO Percentage
What it is: Percentage of COD orders that result in Return to Origin (not delivered).Default: 30%How to determine yours:Get this data from:
- Shipping partner dashboard
- Logistics reports (look for “RTO”, “Failed Delivery”, or “Returned” status)
- Your order management system
Forward Shipping Cost
Forward Shipping Cost
What it is: Cost to ship each order from your warehouse to the customer.Default: ₹60 per orderHow to determine yours:
- Check your logistics partner rate card
- Use average if you have zone-based pricing
- Include pickup charges if applicable
Return Shipping Cost
Return Shipping Cost
What it is: Cost charged by logistics partner to return the product from delivery location back to your warehouse.Default: ₹60 per RTOHow to determine yours:
- Check your logistics contract for RTO charges
- Often equal to or slightly less than forward shipping
- Some partners charge flat RTO rates
Many logistics partners charge higher RTO rates as a penalty/deterrent. Negotiate this rate down as part of your logistics contract.
Product Cost per Order
Product Cost per Order
What it is: The cost of the product being sold (COGS - Cost of Goods Sold).Default: ₹500 per orderHow to determine yours:
- For single-product businesses: Your product manufacturing/purchase cost
- For multi-product: Average product cost across your catalog
- Include: Raw materials, manufacturing, packaging
- Product blocked in logistics cycle (couldn’t sell to others)
- Potential damage during forward + return journey
- Repackaging costs to make resaleable
- For perishables/fashion: May become unsellable (100% loss)
Calculated Metrics Explained
1. Total Revenue
Formula (fromsrc/utils/calculations.js:12):
- This is your gross revenue if all orders were successfully delivered
- Represents the maximum possible revenue
- Does NOT account for RTO losses or costs
This is an aspirational number. Your actual realized revenue will be lower due to RTOs. The gap between Total Revenue and Realized Revenue shows the direct revenue loss from failed deliveries.
2. COD Orders
Formula (fromsrc/utils/calculations.js:14):
- Absolute number of orders placed with COD payment method
- This is your high-risk order pool (where RTO can occur)
- Prepaid orders = Total Orders - COD Orders
The higher your COD order count, the higher your exposure to RTO risk. This metric helps you understand the scale of orders that need monitoring, verification, and RTO prevention efforts.
3. RTO Orders
Formula (fromsrc/utils/calculations.js:17):
- Absolute number of orders that failed delivery and returned
- Each of these orders costs you money in three ways (forward + return shipping + product cost)
- Successfully delivered COD orders = COD Orders - RTO Orders = 4,200
4. Total RTO Loss
Formula (fromsrc/utils/calculations.js:20-24):
- Direct monetary loss due to RTO
- This money is completely unrecoverable (pure loss)
- Does not include indirect costs (customer service, warehouse operations, etc.)
| Cost Component | Per RTO Order | Monthly (1,800 RTOs) | Annual |
|---|---|---|---|
| Forward Shipping | ₹60 | ₹1,08,000 | ₹12,96,000 |
| Return Shipping | ₹60 | ₹1,08,000 | ₹12,96,000 |
| Product Cost | ₹500 | ₹9,00,000 | ₹1,08,00,000 |
| TOTAL | ₹620 | ₹11,16,000 | ₹1,33,92,000 |
5. Realized Revenue (Net Realized Revenue)
Formula (fromsrc/utils/calculations.js:26-27):
- Actual revenue from successfully delivered orders
- Money you actually received (prepaid) or will receive (delivered COD)
- This is not profit - costs still need to be deducted
Realized Revenue is your real top-line. The gap between Total Revenue and Realized Revenue shows the opportunity cost of RTO - revenue you should have earned but didn’t due to failed deliveries.In this example, 18% of potential revenue is lost to RTO.
6. Net Profit After RTO
Formula (fromsrc/utils/calculations.js:29-35):
- Net revenue after accounting for RTO losses
- This is not true “profit” in accounting terms (doesn’t deduct all operational costs)
- Better termed as “Revenue minus RTO Impact”
This metric shows the financial impact of RTO specifically. It does NOT include:
- Product costs for delivered orders
- Forward shipping for delivered orders
- Other operational costs (rent, salaries, marketing, etc.)
7. Break-Even RTO Percentage
Formula (fromsrc/utils/calculations.js:38-44):
- The maximum sustainable RTO rate before you start losing money
- At this RTO percentage, profit from successful orders exactly equals loss from RTO orders
- Above this percentage: Net loss (unsustainable business)
- Below this percentage: Net profit (sustainable business)
- Green zone (Current RTO < Break-Even): “Within safe profitability range”
- Red zone (Current RTO > Break-Even): “Current RTO exceeds sustainable threshold”
| Scenario | Current RTO | Break-Even RTO | Status | Interpretation |
|---|---|---|---|---|
| Healthy | 20% | 60.3% | ✅ Green | 40.3% safety buffer |
| Risky | 50% | 60.3% | ⚠️ Yellow | Only 10.3% buffer |
| Default | 30% | 60.3% | ✅ Green | 30.3% buffer |
| Critical | 65% | 60.3% | 🚨 Red | Operating at loss |
Higher Product Cost → Lower Break-Even RTO
Higher Product Cost → Lower Break-Even RTO
If product cost increases to ₹800:Result: Break-even drops from 60.3% to 41% - less tolerance for RTO.
Higher AOV → Higher Break-Even RTO
Higher AOV → Higher Break-Even RTO
If AOV increases to ₹2,500:Result: Break-even increases to 75.8% - can absorb higher RTO due to better margins.
Lower Shipping Costs → Higher Break-Even RTO
Lower Shipping Costs → Higher Break-Even RTO
If shipping costs drop to ₹40 each:Result: Break-even increases slightly to 62.3% - shipping optimization helps RTO tolerance.
How Metrics Relate to Each Other
The RTO Impact Chain
Key Metric Relationships
Revenue Gap = Total Revenue - Realized Revenue
Revenue Gap = Total Revenue - Realized Revenue
RTO Loss % of Total Revenue
RTO Loss % of Total Revenue
Effective RTO % (of all orders)
Effective RTO % (of all orders)
Delivery Success Rate
Delivery Success Rate
Using Metrics for Business Decisions
Decision 1: Should I Invest in RTO Reduction?
Use the Simulation Section
Model a 10% RTO reduction (from 30% to 20%):
- Potential monthly savings: ₹3,72,000
- Annual savings: ₹44,64,000
Decision 2: Should I Reduce COD Percentage?
Use Prepaid Comparison Section
Model reducing COD to 50%:
- New COD orders: 5,000
- RTO orders: 1,500 (down from 1,800)
- RTO savings: ₹1,86,000/month
Decision 3: Am I at Risk?
Current RTO (30%) is below Break-Even RTO (60.3%) ✅
RTO Loss is 7.44% of revenue (acceptable) ✅
Net Profit After RTO is positive (₹11.84L/month) ✅
AI-Powered Insights Explained
The simulator includes an AI Insights section that automatically analyzes your metrics and provides recommendations. Here’s how it works (based onsrc/components/AIInsights.jsx):
Insight 1: RTO Rate Assessment
Critical RTO Alert (RTO > 25%)
Critical RTO Alert (RTO > 25%)
Trigger: Your RTO percentage exceeds 25%Message:
Your RTO rate is 30%, which is dangerously high. It is significantly eating into your margins, costing you ₹11,16,000 monthly.Action: Immediate intervention required - implement verification systems.
Healthy RTO Rate (RTO ≤ 15%)
Healthy RTO Rate (RTO ≤ 15%)
Trigger: Your RTO percentage is 15% or belowMessage:
Your RTO rate of 12% is well within the healthy industry benchmark (< 20%). Keep it up!Action: Maintain current processes, focus on scaling.
Insight 2: Unprofitable Operation Alert
Above Break-Even Warning
Above Break-Even Warning
Trigger: Current RTO > Break-Even RTOMessage:
Your current RTO (35%) exceeds your break-even RTO (30.5%). Every RTO order is causing a net loss per processed order. Immediate intervention required.Action: CRITICAL - Your business model is unsustainable at current RTO levels.
Insight 3: Partial COD Suggestion
High COD + High RTO Combination
High COD + High RTO Combination
Trigger: COD > 40% AND RTO > 15%Message:
Since 60% of your orders are COD, consider charging a small non-refundable advance (Partial COD) for high-risk pin codes. Also, implement NDR management with OTP verification.Action: Implement partial COD (10-20% advance) and NDR processes.
Insight 4: Prepaid Incentive Opportunity
Prepaid Conversion Potential
Prepaid Conversion Potential
Trigger: COD > 20%Calculation: Simulates 10% COD reduction and calculates profit improvementMessage:
If you offer a 5% discount on prepaid orders and successfully convert 10% of COD orders to prepaid, your Net Profit increases by ₹89,000 due to reduced RTO volume.Action: Design prepaid incentive program (discounts, cashback, faster delivery).
Key Takeaways
Focus on RTO Orders
This absolute number shows scale of the problem - every RTO is a failed transaction
Monitor Total RTO Loss
Direct monthly/annual cash loss - should be your primary cost-reduction KPI
Respect Break-Even RTO %
Your profitability threshold - never let current RTO exceed this
Track Realized Revenue
Your actual earning power after RTO impact - use for realistic forecasting
Next Steps
Learn Optimization Strategies
Now that you understand the metrics, discover practical strategies to improve them