Product Pricing Calculator

Follow the screens at your own pace. Replace fictional examples with your own information.

STEP 1 OF 5

Start with the batch

Hi, I'm Alex. Save a separate copy for each product. Open Cost Breakdown and replace the samples with materials, labour and other costs for the entire batch.

Enlarge the screenshot

STEP 2 OF 5

Enter quantities and rates

Enter quantity, unit and tax-exclusive rate for each line. For labour, use hours and your hourly cost. Leave the calculated batch-cost column intact. Add packaging and other fixed costs without counting them twice.

Enlarge the screenshot

STEP 3 OF 5

Set your assumptions

Open Pricing Calculator. Enter the product name, units made per batch and any additional cost per unit. Set the target margin, discount and tax rate. Enter percentages with a percent sign.

Enlarge the screenshot

STEP 4 OF 5

Compare your price

Read the suggested list price for your target margin. Then enter your chosen list price excluding tax and compare profit per unit and margin. The dashboard charts show cost composition and the price comparison.

Enlarge the screenshot

STEP 5 OF 5

Check before quoting

Margin is profit divided by net sales; markup is profit divided by cost. Keep your tax basis consistent. This workbook does not model percentage selling fees. Review the assumptions and save the product's working copy.

Enlarge the screenshot

These instructions cover the workbook version shown. Check the product listing for included formats. Google Sheets import and feature compatibility have not been independently verified for these versions.