Spend $50 on your first-ever purchase and get $10 towards your next one. Ends 12/12. A welcome gift: Spend $50 or more on your first-ever purchase and get $10 towards your next one. Ends 12/12. See details

Whoa! You can't favorite your own shop.

Whoa! You can't buy your own item.

Whoa! You can't favorite your own item.

Whoa! You can't add your own item to a list.

Add this item to a treasury!

Close
You don't have any treasuries yet. Enter a title below to create one.
Close

This item has been added.

View your treasury.

Like this item?

Add it to your favorites to revisit it later.
This is an Excel file. So you must have Excel, or access to Excel, for the pricing calculator to work.

you don't, however, need knowledge of Excel. The only thing you'll be doing is opening the file and filling in the three high-lighted cells with the answers to the following questions:

Hours you spent on the piece
How much you pay yourself per hour
How much was the cost of the materials in the piece

The file does the rest, giving you the overhead price, the profit price and filling in wholesale and retail prices for seven different calculation scenarios.

Why seven different scenarios? Because not every jewelry creation can be pigeon-holed into one formula, IMO. Sometimes I use really expensive lampwork beads in a simple bracelet that takes less than 30 minutes to make... whereas other times I might spend five hours wire-wrapping a pendant whose materials cost is less than $10.

I like to plug in my three items (hours, pay scale, materials) and look over the results of the pricing calculator before settling on my asking price.

And when worse comes to worse (gotta pay the bills but haven't had any sales lately), you can see what is the absolute bottom price you can sell your item for without taking a loss.

I realize that most people who sell this type of item (pricing calculators, tutorials, etc) don't offer returns, but I only want happy and satisfied customers. So if you purchase this and don't like it for any reason, you have two weeks to let me know and ask for a refund (which will be given in full).

For those who end up liking it, I think you'll find that the $5 investment was well worth it for something you'll use over and over for years to come.

The file arrives within 24 hours via email (although usually much, much soon), so make sure to give me your preferred email address (one that allows attachments) when making your payment.

Thanks!

Frequently asked questions about BrackenDesigns

Do not bend any metal components back and forth repeatedly; they will eventually crack.

Metal may darken or dull over time. To restore shine, use a specially treated cloth like a “Sunshine cloth” (a sample is included with most orders). Don’t use silver “dips” or other similar metal cleaners as these etch away the metal, which increases tarnish.

Most metal pieces suffer little damage with brief exposure to tap water (showers, etc), but saltwater (the ocean), bleach, and pool chemicals can be harsh to metal so remove jewelry before pool or ocean water exposure and before using bleach. Avoid water near Mood stones (the acrylic color-changing stones).
Yes. If you are not happy with your purchase, you will receive a full refund once the item is returned to me in the same condition in which it was sent. The piece must be returned within two weeks of customer having received it.
Each jewelry piece arrives in a gift box. Upon request I can also mail jewelry to gift recipients, adding a notecard from the buyer.
Yes. But please familiarize yourself with your country’s import duties and/or tax fees as the buyer is responsible for these. I report the full purchase price on the customs form when I ship.

And contrary to any wording Etsy puts on my listings about the VAT being included in the purchase price, this is not true. There is no VAT charged to you at the time of sale.

VAT and import fees are solely the customer's responsibility.

Jewelry Pricing Formula Calculator - 7 Scenarios - Easy to Use

Overview