Woodworking Pricing Calculator

What it does

• Materials: enter each wood, sheet good, finish, hardware and packaging item once with what you pay and how many board feet, square feet, ounces or pieces you get. The cost per unit calculates
• Recipes: one row per material in a product. Pick the product and the material from drop-downs, type how much one piece uses (for example 2.5 board feet of walnut, 2 oz of glue and 4 rubber feet), and the material cost adds up by itself
• Products: labour minutes at your hourly rate, overhead per item, packaging, shipping you pay and other costs give the total cost of one item
• Price for your target margin: the price that covers every cost and the marketplace fees and still leaves the margin you set
• Wholesale price: total cost times your wholesale markup
• Profit check at your current price: fees, profit per sale and margin. Products below your target turn amber, products losing money turn red
• Settings: hourly rate, overhead, transaction and payment fee percentages, fixed fees per order, target margin and wholesale markup. Change one and every price updates
• Room for 200 materials, 200 products and 1,000 recipe lines. Works in board feet, square feet, ounces or pieces and any currency

What you get

• XLSXWoodworking-Pricing-Calculator.xlsx (blank)
• XLSXWoodworking-Pricing-Calculator-with-Sample-Data.xlsx (a filled-in small woodshop: 14 materials, 5 projects, including a walnut cutting board that loses money at its current price)
• PDFQuick-start guide (PDF)

Good for

Hobby and side-business woodworkers who sell cutting boards, shelves, signs, coasters and other wood projects online or at markets and want prices that cover lumber, finish, fees and shop time instead of guessing.