ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Price Calculator for products & formula for product
4
Use this worksheet to calculate your retail price for products
5
Single items such as glass jars, signs, wreath forms, etcGrey areas are locked
6
Item #/UPC CodeItem DescriptionItem ColorStoreNotesQty Cost/Item Total Cost
(cost x qty)
7
Example:KKKKKKGlass Jar Clear Bulk Apothocary1 $ 1.00 $ 1.00
8
11 $ 15.00 $ 15.00 Add items that are sold by the piece
9
2 $ - $ -
10
3 $ - $ -
11
4 $ - $ -
12
5 $ - $ -
13
6 $ - $ -
14
7 $ - $ -
15
8 $ - $ -
16
9 $ - $ -
17
10 $ - $ -
18
Total Cost
$ 15.00
19
Florals or greenery
20
Item #/UPC CodeItem DescriptionItem ColorStoreQtyStem or bush Cost/Item Total Cost
(cost x qty)
21
Example:5555555Sun daisy purple Michael's1bush $ 3.15 $ 3.15
22
1Sun daisy $ - $ -
23
2 $ - $ -
24
3 $ - $ -
25
4 $ - $ -
26
5 $ - $ -
27
6 $ - $ -
28
7 $ - $ -
29
8 $ - $ -
30
9 $ - $ -
31
10 $ - $ -
32
11 $ - $ -
33
Total Cost Flowers
$ -
34
Items purchased in volume such as ounces
35
Item #/UPC CodeItem DescriptionStore
Total item quantity in Volume
Total ounces usedTotal Price Cost/Item Total Cost
(cost x qty)
36
Example:SugarGrocery8085 $ 0.50 $ 4.00 16 Ounces per pound
37
1 $ - $ -
Example in cell G enter the total volume i.e. 5 lb bag would be
38
2 $ - $ -
80 ounces (5lbs * 16 ounces per pound)
39
3 $ - $ -
40
4 $ - $ -
41
5 $ - $ -
42
6 $ - $ -
43
7 $ - $ -
44
8 $ - $ -
45
9 $ - $ -
46
10 $ - $ -
47
Total Cost
$ -
48
Ribbons or items sold by the yard
49
Item #/UPC CodeItem DescriptionStoreTotal YardsTotal PriceCost per yard/ft Total yards/feet used Total Cost
(cost x yrds)
50
Example:0.462.5" Quatrefoil Print
Simspotteryinc.com
508.90.185 $ 0.89 12 feet in every yard
51
10.00 $ -
52
20.00 $ - Inch to yard Converter
53
30.00 $ -
54
40.00 $ -
55
50.00 $ -
56
60.00 $ -
57
70.00 $ -
58
80.00 $ -
59
90.00 $ -
60
100.00 $ -
61
Total Cost Ribbons
$ -
69
Shipping supplies such as box, label, paper and packing bubbles
70
Item #/UPC CodeItem DescriptionStoreNotes Quantity Cost/ItemTotal Cost
71
Example:DG1523424x24x12 boxAmazobCut box to 8 in1 $ 2.50 $ 2.50
Make sure to record your box size so you know for future
72
1 $ - $ - Do not forget tape and labels
73
2 $ - $ -
74
3 $ - $ -
75
4 $ -
76
5 $ -
77
6 $ -
78
7 $ -
79
8 $ -
80
9 $ -
81
10 $ -
82
Total Cost Supplies
$ -
83
84
 Total Cost $ 15.00
85
86
Enter your mark-up %100%When starting out double your cost
87
 Cost + Mark UP $ 30.00
88
Enter labor percentage if any0% $ -
89
Credit card fees, Etsy fees, etc Merchant Fees 5.00% $ 1.50
90
Handling Fees $ - Fees added for handling
91
Total Retail Price $ 31.50
92
93
Profit $ 16.50
94
Enter discount % Here10% $ 28.35 Use this for sales
95
Profit After Discount $ 13.35 This is price to list your item for
96
97
98
99
Inches used
Converted to yards
100
 6.00 0.17
Enter the calculated inches from below to convert to yards
Go back to price calculator
101
102
Inches used
103
Ribbon Streamer length
104
0Enter the length of ribbon streams
105
Total number of ribbons
106
0
Enter the total number of streamers used
107
Total Inches used