This item has been sold, but we found these similar items for you.

Request a similar item from BrackenDesigns.

Request Custom Order

"I want one too!"

Here are a few other shops with similar items

United States
487 Sold Items

United States
218 Sold Items

United States
0 Sold Items

Jewelry Pricing Formula Calculator for EXCEL

This Item Has Been Sold

Contact Seller

Accepted Payments
  • PayPal Acceptance Mark


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 extensive knowledge of Excel. The only thing you''''ll be doing is opening the file and filling in the 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, as well as giving you an average of all the scenarios combined.

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 have added two bonus pages to the file. One is a worksheet which calculates your materials cost. For example, if you pay 25 cents per headpin and your bracelet used 48 headpins, or if you used 43 Carnelian stones and they cost you 22 cents each, etc. you just plug that info in and the calculator gives you the total materials.

The other bonus feature is a page that calculates the cost of sterling silver or 14k gold-fill wire, both by the inch and by the foot. It can calculate the price when you tell it how much you paid per ounce or it can calculate the price based on the current rate of spot silver or solid gold.

The file arrives within 48 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.


Materials Used


More Info

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.

Product Attributes

Color: Green

More items on ArtFire