How do I work back from a supermarket retail price to the FOB ceiling on a diaper wholesale order?

Work backwards, not forwards. Take the shelf price the retailer will actually charge, subtract the retailer's margin, subtract your own distribution margin, then subtract freight, clearing, duty and irrecoverable VAT. What is left is the FOB ceiling your diaper wholesale order can support. On a 44-count pack selling at S$19.90 in Singapore, that sequence leaves about US$0.18 per piece of room — near the top of the US$0.10 to US$0.22 FOB band that quality tape baby diapers are quoted at, which tells you at a glance that this pack is priced for a premium position rather than a value one.

The order of operations matters more than the arithmetic. Importers who negotiate an FOB price first and then look for a shelf usually discover the shelf was never going to carry that price, and by then the container is booked. Running the sum in reverse costs twenty minutes and settles the question before a quotation exists.

What is the formula that runs from shelf price back to FOB?

Multiply the shelf price by one minus the retailer margin, then by one minus your own margin, then subtract the per-unit logistics, duty and irrecoverable tax load. The residue is the FOB ceiling.

1. Shelf price — the consumer price for one pack, tax inclusive in most Southeast Asian markets.
2. Retailer margin — the gross margin the account applies to the category, expressed on the retail price.
3. Distributor margin — your gross margin, which has to absorb warehousing, credit, returns and a sales team.
4. Logistics and tax — ocean freight and insurance per piece, clearing, duty if any, plus VAT or GST you cannot recover.

The result is a number you can hold a supplier to. Anything quoted above it is not a negotiation, it is a subsidy you are funding from working capital.

How much margin should you assume the retailer takes?

Ask the account for the gross margin it actually applies to the category, then plan with that number. Across Southeast Asian grocery accounts it usually lands between a quarter and two fifths of the shelf price, and it is a planning assumption to be verified account by account rather than a published rate. Modern trade tends to sit at the lower end of that range but recovers the difference through listing support, promotional funding and rebates, which is why a headline margin that looks modest can behave like a third more once the year closes.

Pharmacy and independent baby stores usually want more gross margin and give you something valuable in return: shelf depth, staff recommendation and less promotional pressure. Hypermarkets want less margin but want the supplier to fund volume. Neither is cheaper — they simply charge you in different currencies.

What does the distributor margin have to cover before it is profit?

A 15% to 25% gross distributor margin is the working range for this category, and almost none of it is profit. Warehouse space, inbound and outbound handling, credit terms extended to retailers, damaged and expired stock, sales representatives and the cost of holding safety stock all come out of that number.

The practical test is a simple one. If your distributor margin cannot absorb a 30-day credit extension and a 3% returns rate at the same time, the account is not profitable at that margin and the FOB ceiling needs to come down to create room — or the retail price needs to go up, which is a conversation with the retailer rather than with the supplier.

Where do freight, duty and VAT enter the reverse calculation?

Freight enters as a per-piece cost: take the all-in freight and insurance for the container and divide by the pieces inside it. A 20GP holds roughly 48,000 pieces of baby diapers, so a few hundred dollars of freight moves the per-piece FOB ceiling by a fraction of a cent — but a badly loaded container that ships 40,000 pieces moves it by much more.

Duty depends entirely on the HS code and the origin paperwork, so confirm the rate with your customs broker rather than from a blog. What matters for the calculation is the effective rate after any preferential treatment you can actually document; a form you cannot obtain is worth nothing. VAT and GST are different: if you are registered, import VAT is usually recoverable and should be excluded from the landed cost while still being budgeted as cash flow, because you pay it at the border and recover it weeks later.

Can you show a worked example on a 44-count pack?

Yes, and the sequence is the whole point. The figures below are a clearly labelled hypothetical for illustration, not a quotation.

• Shelf price: S$19.90 for 44 pieces, or S$0.452 per piece.
• Retailer margin 28%: your selling price to the retailer is S$14.33 per pack, or S$0.326 per piece.
• Distributor margin 20%: your landed cost ceiling is S$11.46 per pack, or S$0.260 per piece — around US$0.19, inside the usual US$0.18 to US$0.28 landed range.
• Freight, insurance and clearing S$0.70 per pack: the FOB ceiling is S$10.76 per pack, or S$0.244 per piece — roughly US$0.18.

That answer sits at the top of the viable FOB band, and it should change how you buy. There is no room to pay a premium for a mid-tier product and still fund a promotional calendar; either the specification is genuinely premium, or the pack count has to rise so the per-piece retail price falls without touching the shelf price.

Why does the same product give a different ceiling in each market?

Because four variables move independently: the shelf price the consumer accepts, the channel margin structure, the duty rate that applies to your HS code, and the standard VAT or GST rate. Thailand, Vietnam, Malaysia and Singapore each land in a different place on all four, and the differences are large enough to change the answer by 20% or more.

Two habits keep this manageable. Keep one spreadsheet per market with the four variables visible and dated, and re-run it whenever a retailer changes its margin ask or a freight quote expires. A ceiling you calculated last quarter is a guess, not a ceiling.

What do you do when the arithmetic leaves no room at all?

Change one variable deliberately rather than arguing about price. There are four levers, and only one of them is the FOB price.

1. Raise the pack count so the per-piece retail price falls while the shelf price holds.
2. Move the product to a channel that tolerates a higher retail price, such as pharmacy or a specialist baby store.
3. Ask for a volume price break at three containers or an annual commitment, which is a legitimate route to a lower diaper wholesale cost.
4. Walk away. A pack that only works at a negative distributor margin is a pack that will be delisted in two quarters anyway.

If the sum points to a viable order, the next step is a formal quotation against your own specification and volume, not a published list price. You can request pricing and free samples through our distributor application page, and the category economics behind the ceiling are set out in the wholesale price, MOQ and margin guide.

Frequently asked questions

Four questions come up in almost every pricing conversation with a new distributor.

Sources and further reading

• ASEAN Tariff Finder, ASEAN Secretariat — preferential and MFN duty rates by HS code (accessed 2026): tariff-finder.asean.org
• Statista, baby care and diaper retail price data for Southeast Asia (2025–2026): statista.com
• Freightos, container freight rate benchmarks used for per-piece logistics estimates (2026): freightos.com

Bottom line: the shelf price is the only fixed point in the chain, so build the FOB ceiling from it before you talk to any supplier. If the sum leaves no room for a sustainable distributor margin, the product is wrong for that channel — not the price. Every figure here is a planning range; formal pricing is quoted against your specification, volume and destination port.