Skip to content
LunithLabs
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"

Image 1 of 6

Spreadsheet

Unit Cost Sheet

What one finished unit costs you, line by line.

$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 (Unit-Cost-Sheet.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

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

For anyone who makes, packs or posts what they sell. List what you buy and what each pack cost, with the date you checked it, and the sheet works out the cost per gram, millilitre, centimetre or piece. Add what goes into one unit, then packing, shipping and an allowance for scrap and failed units. You get what one finished unit costs you, with its breakdown, and the figure to type into Lunith Commerce OS. Two worked examples are included: a candle, and a download sent with a printed card. Count your own time too: add it as a line in the bill of materials, hours times what an hour is worth to you.

Open Unit-Cost-Sheet.xlsx. Fill 02 with what you buy and what the pack cost, 03 with what goes into one unit, 04 with the packing and shipping, and 05 with any scrap. 06 gives the full unit cost, the unit cost without shipping for Lunith Commerce OS, and shipping per unit for Offer Math, with the breakdown and room for the SKU name, the date and a note. The last page of the guide says where each one goes.

It does not track stock counts, reorder points or purchase orders over time: it costs one unit. It does not log sales or work out what a channel kept. It does not sync to shops or accounting software, and it is not tax advice. Once you have the number, Offer Math turns it into a list price after fees.

What's inside

  • Unit-Cost-Sheet.xlsx: the workbook
    1. 01 Start Here
    2. 02 Materials library
    3. 03 BOM or recipe
    4. 04 Pack and ship
    5. 05 Scrap and yield
    6. 06 Unit cost out
    7. 07 Worked examples
  • Unit-Cost-Sheet-LETTER.pdf and Unit-Cost-Sheet-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 seven sheets: what you type and what each returns
  • Guide, page 5, Materials library: pack price to cost per base unit
  • Guide, page 6, BOM or recipe: one unit, line by line
  • Guide, page 7, Packing, shipping, scrap: why only the making cost is divided by yield
  • Guide, pages 8–9, Two examples, worked: a candle, and a download with a posted card
  • Guide, page 10, Using it with the OS: where the numbers go, teams, support
  • README.txt: printing and license

In the download

Pages
10 pages, in the main PDF
Files
  • Unit-Cost-Sheet-LETTER.pdfPDF, US Letter · 1.1 MB
  • Unit-Cost-Sheet-A4.pdfPDF, A4 · 1.1 MB
  • Unit-Cost-Sheet.xlsxExcel workbook (.xlsx) · 32 KB
  • README.txtREADME (.txt): printing and license · 3 KB
  • Unit-Cost-Sheet.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.

  • Offer Math: the "Example B, a candle, worked" page of the pack under a title band reading "Fee-Aware Price Tiers, Break-Even"

    Optional extra · Spreadsheet

    Offer Math

    A list price worked out after fees and costs.

    Price: $19.00

    One-time purchase · no subscription