Delivery Margin Calculator

How to use (30 minutes)

Fill in one row per channel (GrabFood / foodpanda / direct).
Enter your real promo split (platform-funded vs merchant-funded).
Review the True margin % and apply the decision rules.

Channel inputs (fill-in)

Channel	Gross sales (S$)	Commission %	Other fees (S$)	Merchant-funded promos (S$)	Platform-funded promos (S$)	Refunds/adjustments (S$)	Packaging cost (S$)	COGS (S$)	Packing labour (S$) (opt.)
GrabFood
foodpanda
Direct (website/WhatsApp)

Results (auto-calc)

Channel	Net sales after fees/promos (S$)	Contribution after COGS (S$)	Contribution after packaging (S$)	True margin %

Formulas (for spreadsheet)

Net sales = Gross sales − (Commission % × Gross sales) − Other fees − Merchant-funded promos − Refunds
Contribution after COGS = Net sales − COGS
Contribution after packaging = Contribution after COGS − Packaging cost − Packing labour
True margin % = Contribution after packaging ÷ Gross sales

Decision rules (fix in this order)

✔

1) Remove/replace unprofitable items (worst offenders first)
2) Fix packaging + portioning (plate cost + breakage)
3) Reduce merchant-funded promos (or narrow to profitable items)
4) Adjust prices (delivery vs dine-in pricing may differ)
5) Negotiate terms (commissions, promo requirements, ads)

What to investigate (prompts)

If margin is low on EVERY channel

Plate costs wrong / portion drift?
Too many merchant-funded promos?
Packaging too expensive?
Refund rate too high (missing items, quality, timing)?

If margin is low on ONE channel

Higher commission/fees?
Forced promo spend?
Different customer basket (more low-margin items)?

Action plan (premium)

Problem	Fix	Owner	Due date	How we’ll measure

Start here (2 minutes)

🎯

Objective: calculate true margin by channel after commissions, packaging, merchant-funded promos and refunds. Find the leaks. Fix them in the right order.

⏱️

Reading time: 12 minutes. First calculation: 30 minutes once you have the data.

📌

Why this matters: headline delivery revenue hides everything. A S$20 order on a platform might leave you with S$6 after fees, packaging and a partly merchant-funded promo. Run this once and you'll know which channels are actually profitable and which are buying you turnover at a loss.

What you'll need

Input	Where to get it	Notes
Gross sales per channel (last 30 days)	Platform merchant dashboards (GrabFood, foodpanda) + direct	Use the same window for every channel
Commission % per channel	Latest signed agreement / merchant statement	Watch for tiered rates
Merchant-funded vs platform-funded promo split	Platform statements (usually itemised)	This is the silent margin killer
Refunds and missing-item adjustments	Platform statements	Pull total S$ value, not count
Packaging cost per order	Supplier invoices ÷ orders fulfilled	Average is fine for first pass
Food cost per order (COGS)	Plate cost from menu engineering or stock movement	Use a blended channel average