Skip to content
Lunith Commerce OS
Offer Math: the "Sample B, a candle, worked" page of the pack under a title band reading "Fee-Aware Price Tiers, Break-Even"

Image 1 of 6

Spreadsheet

Offer Math

Your list price, worked out after the fees rather than before them.

$29.00USD

Sold direct: we deliver the files the moment payment clears, and support is us, by email.

Digital products are not refunded. If something you bought does not work, or is not what its page describes, we fix it, and every piece of feedback goes into the LunithLabs software we are building next. Your legal rights are not affected. Refunds and fixes

Format
Excel workbook (Offer-Math.xlsx) with a 10-page PDF guide in US Letter and A4
Works with
Excel 2007 or later, or Google Sheets: every function in the workbook works in both. The guide opens in any PDF reader.
Delivery
Delivered by us the moment payment clears: a download link on the confirmation page and in your order email.
License
Use it yourself, or inside one household, business or team; print as many copies as you need; do not resell or share the files.

Overview

Your list price, worked out after the fees rather than before them.

Three floors side by side: cost-plus, target net, competitor floor. The suggested list price is the highest of the three, rounded up. Good, Better and Best, each with its net at your own fee rates. Break-even units for a launch spend you type. Every fee typed and dated by you; nothing is looked up. Two worked examples, a download and a candle, labelled sample.

Open Offer-Math.xlsx and fill 02, 03 and 04: your targets, one channel's fees with the date you read them, and what one unit costs. 05 then shows the three floors and the suggested list price, 06 the net of each tier and 07 the units to break even. The last page of the guide says where each number goes in Lunith Commerce OS, if you use it; you copy them across by hand.

It does not log sales, work out the fees on orders you have taken, or show what each channel kept over time. It does not sync to any shop, ads account or bank. It is not tax, legal or financial advice, and it does not promise revenue. For a physical product, Unit Cost Sheet works out the unit cost that goes into 04.

What's inside

  • Offer-Math.xlsx — the workbook; its tabs: 01 Start Here, 02 Assumptions, 03 Fee inputs, 04 Cost inputs, 05 Price scenarios, 06 Offer tiers, 07 Break-even, 08 Worked examples
  • Offer-Math-LETTER.pdf and Offer-Math-A4.pdf — 10 pages each, US Letter and A4, the guide to the workbook
  • Guide, page 3 — Where it stops: who it is for, and what it does not do
  • Guide, page 4 — The eight sheets: what you type and what each returns
  • Guide, page 5 — Fees, typed and dated: nothing is looked up
  • Guide, page 6 — Three floors: why the highest of the three is suggested
  • Guide, pages 7–8 — Two samples, worked: a download and a candle, read off 08
  • Guide, page 9 — Tiers and break-even: implied net per tier, units to cover a launch
  • Guide, page 10 — Into Lunith Commerce OS: where each number goes, by hand
  • README.txt — printing and licence

In the download

Pages
10 pages, in the main PDF
Files
  • Offer-Math-LETTER.pdfPDF, US Letter · 1.0 MB
  • Offer-Math-A4.pdfPDF, A4 · 1.0 MB
  • Offer-Math.xlsxExcel workbook (.xlsx) · 20 KB
  • README.txtREADME (.txt): printing and licence · 1 KB
  • Offer-Math.zipEverything in one zip · 2.0 MB

Related

  • Unit Cost Sheet: the "One unit, line by line" page of the pack under a title band reading "Cost Of One Unit Line By Line"

    Money · Spreadsheet

    Unit Cost Sheet

    What one finished unit costs you, worked out line by line.

    Price: $29.00

  • The Platforms database in Notion, Money by channel view: five example storefronts with gross revenue, fees paid, net revenue, profit after ads, ledger profit, profit after ads with goods and effective fee rate. The Example: Etsy row reads $471.45 gross, $74.62 in fees, $376.85 net revenue, $351.85 profit after ads, a $39.62 ledger profit, $351.85 after ads with goods, and a 15.83% effective fee rate; the Own website row, which sold one physical order, reads $36.99 after ads and $28.79 once its goods and shipping are taken off. The sums along the bottom read $508.44, $74.62, $413.84 and $388.84.

    Money · Notion template

    Lunith Commerce OS

    Ten related databases for a small business that sells, under one home page

    Price: $59.99

New tools and articles, by email

An email when we publish a new tool or article. You confirm your address first, and every email has a one-click unsubscribe.