Skip to content
LunithLabs
Offer Math: the "Example 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

A list price worked out after fees and costs.

$19 one-time

One-time purchase · no subscription. The file is yours to keep.

Sold and delivered by LunithLabs. Files arrive as soon as your payment clears. Support: support@lunithlabs.com.

All sales final. If something is broken, email us.

You get the files as soon as your payment clears, so all sales are final. What we promise instead: it works as described.

If anything is broken, unclear or missing, email support@lunithlabs.com. We aim to fix it within 3 to 7 business days of having the details we need to reproduce it, free of charge. We read every message, and when a fix changes the product it ships as an update to everyone who bought.

You can ask us for a written copy of this policy. Your legal rights are not affected.

Read the policy

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: the workbook uses only functions both support. The guide opens in any PDF reader.
Delivery
Delivered by us as soon as your payment clears: a download link on your order page and in your order email.
License
One purchase covers your business and everyone who works for it. Share the file inside your business, including on its own shared drive (such as Google Drive or OneDrive), and print as many copies as you need. Don't resell or redistribute it, post it publicly, or share it with other businesses or clients.

Overview

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

For anyone setting a price on something they sell. Offer Math works out three minimum prices: your cost plus a markup, the price that leaves you the net or margin you want, and the lowest of up to five competitor prices you type in. It suggests the highest of the three, rounded up the way you choose. Type up to three tier prices and it shows what you keep on each; type a launch spend and it shows how many units cover it. You type each channel's fees and the date you read them; nothing is looked up for you. If fees and ad fees would take the whole price, sheet 05 warns you. Two worked examples are included: a download and a candle.

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. Add comparable prices on 05, tier prices on 06 and a launch spend on 07. 05 then shows the three minimum prices 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.

Sell in more than one place? Save a copy of the workbook for each storefront, fill 03 with that storefront's fees, and compare the suggested prices side by side. Pricing a digital product across more than one storefront walks through why they differ.

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 goods and shipping lines that go into 04.

What's inside

  • Offer-Math.xlsx: the workbook
    1. 01 Start Here
    2. 02 Assumptions
    3. 03 Fee inputs
    4. 04 Cost inputs
    5. 05 Price scenarios
    6. 06 Offer tiers
    7. 07 Break-even
    8. 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 minimum prices: why the highest of the three is suggested
  • Guide, pages 7–8, Two examples, 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, Using it with the OS: where each number goes, teams, support
  • README.txt: printing and license

In the download

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

Related

  • Notion, dark theme: the Platforms database, Money by channel view. Seven example channels with gross revenue, fees paid and net revenue; Example: Shopify $430.62, $24.19, $393.44. The sums: $1,565.52, $169.14, $1,353.42.

    Money · Runs in Notion

    Lunith Commerce OS

    A business operating system that runs in Notion. See what every sale kept. One-time purchase · no subscription.

  • 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"

    Optional extra · Spreadsheet

    Unit Cost Sheet

    What one finished unit costs you, line by line.

    Price: $19.00

    One-time purchase · no subscription