Money · Spreadsheet
Unit Cost Sheet
What one finished unit costs you, worked out line by line.
Price: $19.00
Image 1 of 6
Spreadsheet
Offer Math
Your list price, worked out after the fees rather than before them.
$19.00USD
One-time payment. The file is yours to keep.
Sold direct by LunithLabs. Your files arrive as soon as your payment clears, and support@lunithlabs.com reaches the people who made them.
Built right, kept right.
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 and we'll fix it within 3 to 7 business days. We read every message, and fixes ship as updates to everyone who bought.
You can ask us for a written copy of this policy. Your legal rights are not affected.
- 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 samples 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. 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.
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 unit cost that goes into 04. Type percentages with the % sign (6.5%). If you use the OS, leave shipping out of the unit cost: the OS adds it on each sale.
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 license
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 license · 1 KB
- Offer-Math.zipEverything in one zip · 2.0 MB
Related
Money · Built in Notion
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.