The original sheet, rebuilt. Same rows in the same order. Rows marked corrected had a defect in the source. Everything recalculates as you type, and each product keeps its own saved figures.
Green cells = Meeting or exceeding KPIs
Red cells = Below target KPIs
1. Pick a product above — each keeps its own saved figures
2. Enter data in the blue input cells
3. All calculations update automatically as you change inputs
4. Green cells indicate you're meeting KPI targets
5. Red cells indicate areas that need improvement
6. Rows marked corrected had a defect in the source sheet
| Front-End Product Price | ฿ | ||
| Cost of Goods Sold (COGS) | ฿ | Group cost, not the PBB transfer price. Robots from the Maytronics PO +20% landed; the rest buy at ≈JD cost already. | |
| Shipping Cost | ฿ | ฿60 to 24.9kg, ฿150 to 49.9kg, ฿400 over — what the customer is charged. What the carrier bills PBB is unverified. | |
| Estimated AOV (Average Order Value) | ฿ | The single revenue base. | |
| Estimated CAC (Customer Acquisition Cost) | ฿ | Placeholder — paid has never run here. This is the figure to solve for, not one to trust. | |
| Total Ad Spend | ฿ | ||
| Estimated Conversion Rate (%) | % | Home & Garden median on Meta. A planning basis, not a measured rate — paid has never run here. Vary it to test sensitivity. | |
| Estimated CPC | ฿ | Checked against the affordable bid. | |
| Payment Processing Fee | % | 1.65% Omise PromptPay + 1% Shopify. Cards 4.65%. | |
| Payment Fee, Fixed | ฿ | ||
| VAT Rate | % | Prices are quoted VAT-inclusive. | |
| Price Basis | N | ||
| QR / PromptPay Fee | % | 1.65% Omise + 1% Shopify. | |
| Orders Paid by QR | % | Measured: every order since 2024 is Omise PromptPay QR, not cards. | |
| Refund / Cancellation Rate | % | Measured: ฿5,143 refunded of ฿1,154,219 across 135 orders. Goods return; carriage and fee do not. | |
| Orders per Customer per Year | N | Store-wide repeat is 1.48, but follow-up orders average 29% of the first — the second buy is chemicals, not another robot. So 1 + 0.48 × 0.29. |
| Total Product Cost (COGS + Shipping) | ฿ | — | |
| VAT on the Order | ฿ | — | Remitted, never earned. |
| Net Revenue (ex-VAT) | ฿ | — | The margin base. |
| Payment Processing Fee Per Order | ฿ | — | |
| Gross Profit per Unit | ฿ | — | |
| Gross Margin % | % | — | Source divided cost by price: 41.01% where the truth was 58.99%. |
| Break-even CAC | ฿ | — | Above this, the first order loses money. |
| Break-even CAC per Customer | ฿ | — | |
| Break-even ROAS | N | — | |
| ROAS (Return on Ad Spend) | N | — | Green when it clears break-even. |
| AOV:CAC Ratio | N | — | Target ≥ 2.0. |
| Net Profit per Order | ฿ | — | |
| Estimated Orders | N | — | Ad spend ÷ CAC × repeat. |
| Estimated Revenue | ฿ | — | One figure. The source had two, ฿50,000 apart. |
| Estimated Profit | ฿ | — | |
| Estimated Profit % | % | — | On net revenue. Target ≥ 20%. |
| Estimated ROAS | N | — | |
| Max Affordable CPC | ฿ | — |
Only KPI rows are judged. The other eleven are reference quantities — break-even ROAS is the line ROAS is measured against, so colouring it would be circular.
—
Recalculates locally. Nothing leaves this browser.