Product Pricing Calculator

Step 1. 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.

Step 2. 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.

Step 3. 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.

Step 4. 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.

Step 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.