Worksheet: How to price your listings (Optional calculator)

	B	C	D	F
1	How to price your listings
2	This worksheet is meant to help you develop prices that work for your goals. There is no single, right answer here,
3	so use this template to test different values, experiment and learn, and improve and optimize. For more guidance,
4	read Etsy's Ultimate Guide to Pricing in the Seller Handbook.
5
6	To use: First, download your own copy of this worksheet by going to File > Download. Then, edit the blue cells with your own items and associated costs.
7
8	1. Add up your production costs
9	Materials	Cost per year		Consider: What do you need to produce your items?
10	Material 1	$17.00		- What materials do you use? How much does each material cost per item?
11	Material 2	$5.00		- If you're a vintage or supplies seller, what was the cost of the original item?
12	Material 3	$0.00		- What's the cost of your shipping materials?
13	Material 4	$0.00
14	Material 5	$0.00
15	Yearly production cost	$22.00
16	/ # of items produced per year	75
17	Total production cost		$0.29
18
19	2. Add up your yearly overhead costs			Consider: What are your business expenses, aside from wage and supplies?
20	Overhead item	Cost per year		- Do you rent a studio or office space?
21	Overhead item 1	$600.00		- Do you pay someone to help you?
22	Overhead item 2	$0.00		- Do you plan to make other investments this year (such as product development or research)?
23	Overhead item 3	$0.00		- Do you have to replace tools throughout the year?
24	Overhead item 4	$0.00		- Does your machinery require maintenance or cleaning?
25	Overhead item 5	$0.00		- Do you pay for monthly subscriptions for a selling-related service?
26	Yearly overhead costs	$600.00
27	/ # of items produced per year	75
28	Overhead cost per item		$8.00
29
30	3. Add up your marketing costs			Consider: What do you spend to promote your shop?
31	Marketing item	Cost per year		- How much will you spend on advertising (such as Etsy Ads) during the year?
32	Marketing cost 1	$54.00		- How much will you spend on offering discounts?
33	Marketing cost 2	$0.00		- Do you offer promo codes or targeted offers?
34	Marketing cost 3	$0.00		- How much do you spend on offering competitive or free shipping?
35	Marketing cost 4	$0.00
36	Marketing cost 5	$0.00
37	Yearly marketing costs	$54.00
38	/ # of items sold per year	75
39	Marketing cost per item		$0.72
40
41	4. Account for your labor			Consider: What are the tasks required to produce an item? How long do they take?
42	Task	Hours		- How much time does it take to purchase, source, or design your items?
43	Task 1	2		- How much effort does it take to prepare, clean, or ready your items?
44	Task 2	0		- What is the time effort for fulfillment? (This includes packaging orders and going to the post office.)
45	Task 3	0		- What would be a fair wage?
46	Task 4	0
47	Task 5	0
48	Total hours spent	2
49	x Your hourly rate	$20.00
50	Total labor cost		$40.00
53
54	5. Estimate your fees for selling			Determining an average commission rate can help you set a consistent price across the places you sell. You can also update this with your different commission rates to set different prices per platform.
55	Fee	Percentage cut
56	Average commission fee across all the places where you sell	6.50%
57	Total estimated fee percentage		6.50%
58
59	Desired additional profit margin (%)		20%
62	Your price		$63.79
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
101
102
103
104