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!"

Jewelry Pricing Formula Calculator for EXCEL

This Item Has Been Sold

Contact Seller

Accepted Payments
  • PayPal Acceptance Mark
  • Money Order


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

  • Gold Pearl Tikka/Headpiece Tikka/Indian...
  • 14k Pink And White Gold Halo Diamond...
  • Don't Let Cancer Steal Second Base Tee Shirt
  • Disney Princesses Personalized Coloring...
  • Modern Abstract Floral Painting HD Print On...
  • soft and earthy green toned pendant necklace
    Green Art Pendant Necklace Earth Tones With...
  • Genuine Gold Plated Swarovski Crystal...
  • Bumble Bee Favor Tags
    Bumble Bee Favor Tags in Yellow Polkadot for...
  • Handmade Stretchable Black Pearl Bracelet...
  • 10Kt Yellow Gold 0.15 Ct Diamond Engagement...
  • Amaranth Oil – Organic Carrier Oil,...
  • Riyo Garnet Silver Stone Jewelry Ear Hook...
  • 10Kt Rose Gold Diamond Knot Ring (Size 8)
  • 8MM Dome Blue IP Multiple Green Lantern...
  • Mallard Duck Address
    Custom Address Stamp - Mallard Duck Address -...
  • Small Lapel Cotton Long Shirt Dress Long Sleeve
  • Sterling Silver Family Tree Bangle Bracelet,...
  • Fat Tire Chopper Metal Sign
  • Contemporary Home Decor Huge Wall Art Canvas...
  • Peridot Heart Bezel Bracelet .925 Sterling Silver
  • London Blue Topaz Heart & Pearl Pendant .925...
  • Swiss Women's Watch Cortebert 1950's/ Vintage...
  • 1.5 Ct Blue Topaz & Diamond Emerald Cut...
  • Everything Mala Vietnamese Rosewood Lava...