Product Pricing Calculator Spreadsheet, Materials, Labor Time and Margin for Makers, Excel

For people who make what they sell. List your materials, say how much goes into a product and how long it takes, and the file gives a price for the margin you want.

Setup tab: your labor rate per hour, target margin, marketplace and payment percentages, fixed fee per sale, overhead percentage, price rounding and wholesale discount. You type the fees from your marketplace's current fee page.

Materials tab: what you paid and how much you got. 12.00 for 16 oz gives 0.75 per oz, plus a waste allowance if you set one. It holds 120 materials.

Build List tab: which material goes into which product and how much, for a whole batch. It holds 600 rows.

Products tab: batch size, labor minutes for the batch, packaging and other costs per unit, up to 40 products. It shows materials, labor, overhead and total cost per unit, target price, rounded price, fees, profit and margin. Type your current price to see the profit and margin you get now, marked Below cost, Below target or At or above target.

Price Sheet tab: all of that on one page, with wholesale prices and a stacked chart of where the price goes.

The Example file has 8 made-up products. The Blank file has none.

WHAT'S INCLUDED
- Product-Pricing-Calculator-Example.xlsx, filled in with made-up products
- Product-Pricing-Calculator-Blank.xlsx, for your own products

Tabs in each: Start Here, Setup, Materials, Build List, Products, Price Sheet. Digital download. Nothing is shipped.

COMPATIBILITY
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, and the menu steps below have not been tried in Excel or Google Sheets.

QUESTIONS AND HOW-TO
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.

Using this file in Excel

Open the .xlsx file. If a yellow bar says Protected View, click Enable Editing.

Type only in the colored input cells. The other cells hold formulas and are locked so they don't get overwritten by accident.

The Example file has made-up entries so you can see how it fills in. Start your own work in the Blank file.

Before you type anything, use File > Save As and give the Blank file a new name. That keeps a clean copy for next time.

To change a locked cell, go to Review > Unprotect Sheet. There is no password. If you edit a formula, the totals may stop being right.

Copying this file to Google Sheets

Open Google Sheets in a browser and start a blank spreadsheet.

Go to File > Import, choose the Upload tab and select the .xlsx file.

Under Import location choose Replace spreadsheet, then click Import data.

Your copy now lives in your own Google Drive. Name it with File > Rename.

Sheets may not keep the locks from the Excel file, so type only in the colored input cells.

HOW AI WAS USED
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.

PLEASE NOTE
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.