Product Cost Calculator: True Landed Cost Per Unit (Materials, Packaging, Labels, Batch Labor)

Product Cost Calculator: True Landed Cost Per Unit (Materials, Packaging, Labels, Batch Labor)

Calculate the true landed cost per unit by adding materials, packaging, labels, allocated batch labor, and inbound costs divided by finished units, so your Etsy prices and margins reflect reality.

TL;DR

True landed cost per unit is the per-item expense that includes materials, packaging, labels, the allocated share of batch labor, and inbound costs. It is what each finished unit actually costs you to produce and receive before marketplace fees and profit. Get these buckets right and your pricing and margins match reality.

Product Cost Calculator: True Landed Cost Per Unit (Materials, Packaging, Labels, Batch Labor)

The true landed cost per unit is the sum of per-unit material, packaging, and label costs plus the allocated share of batch labor and any inbound costs, divided by finished units. This is the baseline you must cover before marketplace fees and profit.

Landed cost for Etsy sellers means the full cost to make and receive one sellable unit. Include raw materials, components, packaging, labels, allocated batch labor, inbound shipping, duties, fees, and scrap or yield adjustments. Exclude marketplace fees, VAT you collect, the owner's salary beyond any batch labor allocation, and long-term fixed overhead unless you choose to allocate it separately.

Why calculating true landed cost matters for Etsy sellers

Underestimate landed cost and your margins lie to you. Accurate landed cost feeds your Etsy fee and profit calculations so you can tell whether a listing actually makes money after fees and your target profit.

The step-by-step inputs your product cost calculator needs

Collect these inputs for each product or batch:

• Materials cost per unit, or a per-item breakdown if there are multiple components, measured from invoices and receipts. For bulk purchases, divide total purchase cost by units in the lot and adjust for scrap or unusable pieces.
• Packaging cost per unit including boxes, mailers, inserts, tape, and protective materials. Use supplier invoices or purchase history.
• Label cost per unit, whether adhesive labels or printed hang-tags, computed from supplier cost divided by labels per sheet or roll.
• Batch labor total, recorded as hours times labor rate for the entire batch. You will allocate this across finished units (see next section).
• Inbound costs per batch, including shipping-in, import duties, brokerage, and any carrier or customs fees. Use the shipment invoice and allocate to units or SKUs on that shipment.
• Scrap or yield percentage, measured from production logs or a realistic estimate (for example 2% broken or 5% misprints). Adjust effective units accordingly.
• Units finished per batch, the actual sellable units produced after removing scrap.

Measure these from your records. If you need an estimate, use recent invoices, time logs, or a short trial batch to get baseline numbers. Avoid guesses without a data point.

How to allocate batch labor and variable overhead to per-unit cost

Allocate batch labor by dividing total batch labor cost by finished units. In formula form: batch labor cost per unit = (total hours x hourly rate) / finished units. Track time using a stopwatch, phone timer, or a basic timesheet for each batch and task. For mixed batches that produce multiple SKUs, record time per SKU if practical, or prorate by unit count or complexity-weighted units.

Include variable overhead such as packaging consumables and machine runtime that scales with production in landed cost. Exclude fixed overhead like rent, salaried management, or facility insurance unless you deliberately allocate them to per-unit product cost. If you include fixed overhead, document the method and list it as a separate "allocated fixed overhead" line so it remains visible and adjustable.

Worked example with a table (hypothetical/sample numbers only)

hypothetical/sample numbers only

Notes on the table: the scrap adjustment was handled by basing per-unit calculations on 100 finished units. If you ordered 105 units of material to yield 100 finishable pieces, the materials and label costs would already have been divided by the 100 usable units, so they implicitly absorb scrap. The final landed cost per unit in this example is $5.11. That is what you must cover before Etsy fees and profit.

Building this calculator in a spreadsheet and linking to Etsy fee + profit calculations

Essential spreadsheet layout and formulas:

• Inputs sheet (named Inputs)

  • B2: Materials total cost for batch
  • B3: Packaging total cost for batch
  • B4: Labels total cost for batch
  • B5: Batch labor hours
  • B6: Labor hourly rate
  • B7: Inbound costs for batch
  • B8: Units produced (gross)
  • B9: Scrap count or scrap % (optional)

• Calculations sheet (named Calc)

  • C2: Finished units = Inputs!B8 - Inputs!B9 (or =Inputs!B8*(1-Inputs!B9) if using percent)
  • C3: Materials per unit = Inputs!B2 / C2
  • C4: Packaging per unit = Inputs!B3 / C2
  • C5: Labels per unit = Inputs!B4 / C2
  • C6: Batch labor cost total = Inputs!B5 * Inputs!B6
  • C7: Batch labor per unit = C6 / C2
  • C8: Inbound per unit = Inputs!B7 / C2
  • C9: Landed cost per unit = SUM(C3:C5, C7, C8)

• Etsy Fee & Profit sheet

  • Link landed cost per unit cell to this sheet, call it "Cost of Goods Sold (COGS)". Example: E2 = Calc!C9
  • Add marketplace fee rows: listing fee, transaction fee %, payment processing, shipping you pay, etc. Use formulas to compute fees based on your sale price.
  • Profit row: Profit = Sale Price - (COGS + Marketplace Fees + Shipping Paid)

This layout keeps inputs editable, calculations transparent, and the Etsy fee and profit section responsive to landed cost changes.

Common pitfalls, checks, and optimization tips

Quick checklist:

• Remember scrap and yield. If you lose 5% in production, your per-unit material cost rises accordingly.
• Don’t split batch labor improperly. Track time and divide by finished units, not by ordered units.
• Update inbound costs after every shipment; they move often.
• Watch mixed-batch complexity. If one SKU takes twice as long, prorate by time or complexity units, not just count.

Practical optimization tips:

• Buy some materials in larger lots to reduce per-unit material cost, but only if cash flow and storage make sense.
• Improve time tracking for more accurate labor allocation. Measuring minutes per unit delivers the simplest ROI.
• Negotiate shipping-in or consolidate shipments to lower inbound per-unit costs.

FAQ

How often should I recalc landed cost for a product?

Recalc when a meaningful change happens, for example supplier price changes, shipping or duty rate changes, a change in batch size, or if your scrap rate shifts. A quarterly check is a reasonable minimum, with immediate recalculation after any supplier or process change.

Should I include fixed overhead (rent, utilities) in landed cost?

Generally exclude fixed overhead from basic landed cost. Include variable costs and direct labor. If you want full-cost pricing for business accounting, add a clearly labeled allocated fixed overhead line, calculated monthly as (monthly fixed overhead x percent of space/time used for production) allocated to products. Keep it separate so you can see the baseline product-level profitability.

How do I handle multi-SKU batches or kits?

Prorate costs by units or by weighted complexity. If a batch makes 60 small items and 40 large items, and large items take double time, allocate labor and shared consumables using complexity-weighted units (small = 1, large = 2), then divide costs by total weighted units and assign to each SKU accordingly. For kits, sum the component costs and add kit assembly labor allocated per kit.

What if inbound shipping covers multiple orders/deliveries?

Allocate inbound costs across the shipments or batches they served. Use a simple rule, for example apportioned by units received in each shipment, or by landed value if duties are value-based. Keep a running allocation if shipments are irregular, by adding inbound costs to a pool and dividing by units received in the same accounting period.

Can discounts or returns be factored into landed cost?

Yes. For discounts on purchases, reduce the material cost for the batch and recalc per-unit cost retroactively. For returns or refunds that affect sold units, you can track them separately and use a rolling average cost or post-period adjustment. Use a clear method so cost adjustments do not silently skew margins.