BUSINESS PROFIT CALCULATOR
| Item | Input / Formula | Value |
|---|---|---|
| Inputs | ||
| Item Price ₱/unit | ₱0 | |
| Cost of GOODS ₱/unit | ₱0 | |
| Parcels Orders | 0 | |
| Days for KPI only | 0 | |
| ORDERS CANT BE FULLFILED ₱ | ₱0 | |
| RTS Rate % | 0% | |
| Shipping per Parcel ₱ | ₱0 | |
| Platform Fee % | 0% | |
| COD Fee % | 0% | |
| Ad Spend ₱ | ₱0 | |
| Ad VAT % | 0% | |
| Computed Sales Flow | ||
| Gross Sales | = Price × Parcels | ₱0 |
| Net After ODZ/INC | = Gross − ODZ/INC | ₱0 |
| Collected (After RTS) | = After ODZ × (1 − RTS%) | ₱0 |
| Net Parcels | = Parcels × (1 − RTS%) | 0 |
| Expenses (from Collected / Net Parcels) | ||
| Platform Fees | = Collected × Platform% | ₱0 |
| COD Fees | = Collected × COD% | ₱0 |
| Shipping Total | = Ship per Parcel × Net Parcels | ₱0 |
| COG Total | = Cost of goods × Net Parcels | ₱0 |
| Ad Spend + VAT | = Ad Spend + (Ad Spend × Ad VAT%) | ₱0 |
| Results | ||
| Total Expenses | = Platform + COD + Shipping + COG + Ad + VAT | ₱0 |
| Net Profit | = Collected − Total Expenses | ₱0 |
| Profit Margin | = Net Profit ÷ Collected | 0% |
| ROAS (Actual) | = Collected ÷ Ad Spend | 0.00× |
| Parcels / Day | = Parcels ÷ Days | 0.0 |
| COG % of Collected | = COG Total ÷ Collected | 0% |