Excel Costing & Pricing Tool for Handmade Products – Materials-Based Calculator

Accurate pricing for handmade products — finally simplified. This Excel tool helps crafters, artists, and microbrands calculate the true cost of their creations and determine the ideal selling price with confidence.

The app is built around 3 smart, interactive sheets:

🧾 Materials Costing Sheet

List every raw material used in your products. Enter quantity, buying unit, purchase price, and how it’s used (e.g., per piece, inch, or use). The app calculates precise per-unit cost automatically — even when the purchase and usage units differ. ✔ Supports complex cases like materials measured in yards but used in inches ✔ Allows multiple entries for the same material with different units or suppliers ✔ Automatic updates when base prices or units change

🎯 Product Costing Sheet

Build each product’s full costing by selecting materials, adding labor time, and estimating annual fixed costs (tools, rent, etc.). ✔ Supports markup-based pricing ✔ One-click save to database for future editing ✔ Auto-updates when material data changes

📂 Product Database Sheet

Stores and organizes all your saved product costings in one place. ✔ Easily re-open and edit costings ✔ Tracks all pricing dynamically based on updated costs