Title card reading Product Pricing Calculator, Materials and labor time turn into a price, beside a tablet showing the Price Sheet chart.
  • Title card reading Product Pricing Calculator, Materials and labor time turn into a price, beside a tablet showing the Price Sheet chart.
  • The Price Sheet tab with four cards, a stacked column chart of where the price goes for each product and a table of cost, fees, profit and price.
  • The Products tab: one row per product with batch size, labor minutes, costs, target price, rounded price, margin and a status such as Below target.
  • The Materials tab listing soy wax, fragrance oil, wick and other materials with supplier, pack price, pack amount, waste percent and cost per unit.
  • The Build List tab: rows pairing each product with a material, an amount for the batch, a unit, a cost per unit and a line cost.
  • The Setup tab with labor rate per hour, target margin, marketplace and payment percentages, fixed fee, overhead, rounding and wholesale discount.
  • A card listing the Example and Blank .xlsx files and the tabs Start Here, Setup, Materials, Build List, Products and Price Sheet with row limits.
  • A card describing how the file was tested: six sets of test data recalculated in LibreOffice and compared with Python, with no differences found.

Product Pricing Calculator

Makers often price from gut feel. This file prices from what the materials cost, how long the work takes and the fees. On the Materials tab, enter the price of a pack and the amount in it, so 12.00 for 16 oz becomes a cost per oz. The Build List tab says which material goes into which product, for a whole batch. On the Products tab add batch size, labor minutes and packaging, then read cost per unit, a target price, fees and your margin. Type the price you charge now and the row says whether it is under your cost, under your target or on target. Setup holds your labor rate and fees, which you copy from your marketplace's fee page. The Example file is filled with 8 made-up products. The Blank file starts empty.

$5.99 on Etsy

From our listing records. Etsy shows the current price and your local currency at checkout.

Buy on Etsy

An .xlsx file with ordinary formulas and no macros. A script recalculated it in Excel for Mac and LibreOffice. Excel for Windows and Google Sheets have not been tried.

Instant download from Etsy · nothing shipped

What's included

  • Product-Pricing-Calculator-Example.xlsx, filled in with made-up products
  • Product-Pricing-Calculator-Blank.xlsx, for your own products
A card listing the Example and Blank .xlsx files and the tabs Start Here, Setup, Materials, Build List, Products and Price Sheet with row limits.

How it works

  1. The Price Sheet tab with four cards, a stacked column chart of where the price goes for each product and a table of cost, fees, profit and price.
    Read the Price Sheet Every product's cost, fees, profit, rounded price, margin and wholesale price on one tab, with a chart of where the price goes.
  2. The Products tab: one row per product with batch size, labor minutes, costs, target price, rounded price, margin and a status such as Below target.
    Fill in Products Batch size, labor minutes and packaging per product. Target price comes from your margin and fees. Type your current price to compare.
  3. The Materials tab listing soy wax, fragrance oil, wick and other materials with supplier, pack price, pack amount, waste percent and cost per unit.
    Enter materials Pack price and pack amount give a cost per unit, with a waste allowance. A Check column flags problems.
  4. The Build List tab: rows pairing each product with a material, an amount for the batch, a unit, a cost per unit and a line cost.
    Build each product One row per material per product, for a whole batch. The line cost is worked out from the Materials tab.
  5. The Setup tab with labor rate per hour, target margin, marketplace and payment percentages, fixed fee, overhead, rounding and wholesale discount.
    Set rate and fees Your labor rate, target margin, marketplace and payment fees, overhead, rounding and wholesale discount.

Compatibility and file formats

An .xlsx workbook with ordinary formulas. No macros and no add-ins. A script recalculated it in LibreOffice 26.8 and compared the results with a separate Python calculation. Another script confirmed it uses no LAMBDA, LET, XLOOKUP or spill formulas. A script also opened this file in Microsoft Excel for Mac 16.114.3 and ran a full recalculation: every cell matched the values stored in the file, with no error cells. That test did not type new data into Excel or look at the screen. Excel for Windows and Google Sheets have not been tried.

Instant download from Etsy · nothing shipped.

Video

Questions

What does margin mean here?

Profit after fees, divided by the selling price. Labor counts as a cost, so profit is what is left after paying yourself the rate on Setup.

Why does Target price say Not possible?

Your target margin and percentage fees add up to 100% or more, so no price can reach that margin.

Does the price include shipping?

Only if you add it in Other cost per unit on the Products tab.

Are the marketplace fees built in?

No. You type them on Setup. The fees in the Example are made up.

The prices are arithmetic on the numbers you type. It does not say what a market will pay, and it gives no financial advice. License: for your personal use only. No resale or sharing of this file. AI helped write the listing text, the how-to text and the code that builds this file. Scripts tested: cost per unit, line cost, target and rounded price, fees, profit, margin, status and the Price Sheet, on 6 sets of test data including batches, a product's own margin, a price below cost, margin and fees reaching 100%, no rounding, build rows with a missing material and full tables. No person is claimed to have checked it unless stated here.