Jewelry and Craft Pricing Calculator - Easy to Use (Excel File)

Sold by BrackenDesigns
(61)

This is a digital file

$4.99
Get Shipping Estimate
$4.99
In stock
Digital download

Features
Digital
Made in Loomis, California

Item details

Previous Customers: If you already purchased this file from me, the upgrade is free. Please send me a convo for instructions.

This is an Excel file. So you must have Excel, or access to Excel, for the pricing calculator to work. (You may also be able to find free programs obtainable online that include Excel or emulate Excel, such as OpenOffice.)

Although this program was originally created to calculate the costs for jewelry makers, it can be used for any craft, hobby, or trade.

This is a file to help you calculate pricing. It is NOT a file to store your inventory.

All you have to do to get the suggested retail and wholesale price of any item is to type in:
-- The time it took to make the item
-- What you pay yourself (or someone else) per hour for the labor of making the item
-- What your materials cost

The program automatically calculates your total materials cost, labor costs, overhead and profit margin, giving you both retail and wholesale prices to work with.

There are five popular pricing models to choose from. You may want to see all the options when your work swings from costly materials with little labor to inexpensive materials with intensive labor. Sometimes just having ONE pricing scenario doesn't work for all fabrication scenarios.

This file includes two bonus pages:
-- A worksheet to calculate the cost of wire used in your design.
-- A worksheet to calculate Etsy/Paypal fees or consignment store fees

Be sure you download the Instructions (PDF file).

There are 3 files total. One is the aforementioned PDF of instructions, the other two are the imperial version (inches) and the metric version.

If you purchase this and don't like it for any reason, you have one week 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 formulas and templates are locked so there is no need to worry you might accidentally mess up the file.

After purchasing this tutorial, you’ll see a link to the Downloads page. Here, you can download the files. Downloads are available once your payment is confirmed. If you paid with PayPal or a credit card on Etsy, confirmation may take a few minutes. You’ll see a notice at the top of the page, if your payment is still processing. Etsy will also send you a download notification email separate from any transaction notification emails. To access your digital file(s), visit your “Purchases” page and look for the order. To the right of the order, click Files Ready to Download. This goes to the Downloads page for all the files attached to your order. There are generally no limits for when or how many times you can download a file. In most cases you can access a file any time on your Purchases page, provided the transaction hasn't been canceled or removed. If your payment is still processing, the Files Ready to Download button will be grey.

If you can't access the file via the Etsy download system, send me a convo or email to LauraBrackenOnline “at” gmail.com and I'll send the file via email.

Convo me if you have any questions about or problems with the file.


FAQs

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.

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.



    Reviews
    Average review
    (61)
    May 21, 2018 by MarikaO
    Why didn't I find this years ago! What a simple worksheet for pricing, thank you :)
    Mar 19, 2017 by Leann Schroder
    Easy to use; complete with inventory page options for items and supplies. Not just a pricing calculator. Complete and well done.
    Mar 11, 2017 by Cindy
    Thanks, good calculator working well.
    May 24, 2016 by Belinda Sims
    nice spreadsheet, easy to use
    Jan 3, 2016 by Pam Hurst

More from this seller

Digital downloads
File delivery
Your files will be available to download once payment is confirmed. Here's how.

Payments

I charge sales tax on shipments to California.

International customers please be aware your country may charge additional customs duty and/or import taxes.


Returns & exchanges
I gladly accept returns and exchanges
Contact me within: 5 days of delivery
Ship items back within: 7 days of delivery
I don't accept cancellations
But please contact me if you have any problems with your order.
The following items can't be returned or exchanged
Because of the nature of these items, unless they arrive damaged or defective, I can't accept returns for:
  • Custom or personalized orders
  • Perishable products (like food or flowers)
  • Digital downloads
  • Intimate items (for health/hygiene reasons)
Conditions of return
Buyers are responsible for return shipping costs. If the item is not returned in its original condition, the buyer is responsible for any loss in value.
Additional return information
You may return your item within 7 days of receiving it for a full refund if you find the item not as described in the listing (must be in same condition as when sold).

You may return your item within 7 days of receiving it for a partial refund (I will not refund shipping costs) if you merely don't want the item (must be in same condition as when sold).

Please send an email or convo me prior to return shipping.

Refunds will be sent after return receipt of the product.

Additional policies

I pride myself on customer service. If you have a problem with an item purchased from me, please contact me so we can resolve the issue. Thanks!