Sew and Sell - Pricing Tool.xlsx

	B	C	D	E	F	H	I	K	O
1	Make a copy to edit for use								1️⃣ Enter Your Materials In the Material Costs section, list every item you used. Add your cost per unit (per yard, spool, zipper, etc.) and the quantity used. The Total Cost column updates automatically. 💡 Tip: Don’t skip the small things like interfacing, labels, or packaging — they add up. 2️⃣ Record Your Labor In the Labor section, describe each task (cutting, sewing, finishing). Enter the time in minutes for each task. or you can make this general, like 30 mins to make boxy bag Your hourly rate (top-right corner) automatically applies to every row. The Cost column calculates your total labor expense. 💡 You can change the hourly rate anytime — for example, $25/hr instead of $20. 3️⃣ Review the Summary On the right side, you’ll see a live Summary Block: Materials Total Labor Total Total Cost (sum of all above) Set your Target Profit Margin (%) — try 40–50% to start. The Suggested Retail Price updates instantly. 💡 If your target price feels high, double-check your materials or time — not your worth. 4️⃣ Save & Reuse File → Make a Copy to create your own editable version. Rename the copy for each product type (e.g., “Boxy Bag Pricing”). Your formulas stay intact, so you only update numbers next time.
2	Sew and sell — Product Pricing Worksheet
3	Material Costs
4	Material Costs
5	Item	Cost per Unit	Unit	Qty Used	Total Cost	Summary
6	fabric	10	1	0.25	2.5	Materials Total	4.1
7	liner fabric	5	1	0.25	1.25	Labor Total	13.33333333
8	clasp	0.35	1	1	0.35	Total Cost	17.43333333
9
10						Target Profit Margin (%)	40	change to desired profit margin
11						Suggested Retail Price	29.05555556
12
13
14
15				Material Total	4.1
16	Labor					Hourly Rate ($/hr)	20	change hourly rate here
17	Task	Time (minutes)	Rate/hr	Cost
18	quilt main fabric	10	20	3.333333333
19	combine tote pieces	30	20	10
20			20
21			Labor Total	13.33333333
22
23
24
25
26
27
28
29
30
31
32
33
34
35	Overhead Total	0
36
37	Notes
38	• Enter material names, cost per unit, and quantity used. • Add your time in minutes; the hourly rate cell (top-right of the Labor section) applies to all rows. • Overhead can include packaging, marketplace fees, utilities, and machine maintenance. • Adjust Target Profit Margin in the Summary to see your suggested retail price update.
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100