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.