Page 1 of 3 123 LastLast
Results 1 to 10 of 23

Thread: Pricing Spreadsheet from etsy

  1. #1
    Join Date
    Mar 2011
    Location
    Brighton, United Kingdom
    Posts
    266

    Default Pricing Spreadsheet from etsy

    Does anyone here use the Chris Perry pricing spreadsheet? I'm just trying to start figuring out prices for a few of the things I make to list them on etsy and I got this to make it easier but the prices I get back are scary espeically if you give yourself a decent hourly rate and profit! I understand the reason for those prices but I just don't feel most of my stuff is worth that... Should it be a case of dropping stuff that you can't sell at that price and only listing fancier stuff that can justify the labour costs or is ok to have a few items you don't make much on? Or maybe wait to start selling till the quality and complexity of my stuff can justify the prices?

    Since this isn't needed to pay the bills (aside from the jewellery related ones) I guess I could just go for high prices and see what happens but I know I'd end up offering mates rates all the time since I can't see strangers finding me to buy the stuff in the first place!

    Anyway I'm basically looking for people's opinions.

    Kat

  2. #2
    Join Date
    Jul 2009
    Location
    Romsey
    Posts
    5,256

    Default

    Tangentially - why do you feel your work isn't worth the prices being fed back? What are you comparing them against?

  3. #3
    Join Date
    Mar 2011
    Location
    Brighton, United Kingdom
    Posts
    266

    Default

    Quote Originally Posted by ps_bond View Post
    Tangentially - why do you feel your work isn't worth the prices being fed back? What are you comparing them against?
    I'm quite lucky where I live in that I can look in lots of shops that sell handmade silver jewellery and the prices in these retail outlets are lower than what I'm getting out of the spreadsheet for simpler things to make. My more complicated designs may be compare but they come out even higher. I'm talking £100 for the simplest necklace I'm currently making at £5.00 an hour with 20% profit while necklaces seem to vary between £90-£150 in most of these places. I am new to this as well I've only been making stuff for 2 years so I'm not exactly experienced.

  4. #4
    Join Date
    Jul 2009
    Location
    Romsey
    Posts
    5,256

    Default

    £5/hour is not exactly a lot... Can you show a worked example?

  5. #5
    Join Date
    Feb 2011
    Posts
    1,743

    Default

    I think pricing spreadsheets work fine if you are a competent and experienced jeweller. If you are self taught or learning as you go they are pretty meaningless. I priced my stuff up at a comparable price to similar hand made items and whilst my labour rate was initially around 70p/hour, it is happily now up to around £7 an hour. I'm hoping to get to the point where I'm getting about £10-15 per hour which I think is sufficient.

  6. #6
    Join Date
    Jul 2009
    Location
    Romsey
    Posts
    5,256

    Default

    Quote Originally Posted by medusa View Post
    I think pricing spreadsheets work fine if you are a competent and experienced jeweller. If you are self taught or learning as you go they are pretty meaningless.
    Out of interest - why? I may be taking a simplistic approach on modifying the hourly rate to compensate for learning/working slower than an experienced jeweller. Overheads are pretty similar, materials costs are roughly the same.

  7. #7
    Join Date
    Mar 2011
    Location
    Brighton, United Kingdom
    Posts
    266

    Default

    Quote Originally Posted by ps_bond View Post
    £5/hour is not exactly a lot... Can you show a worked example?
    I've just used this spreadsheet I'll see if I can output the numbers for you when I get home. It does include things like the cost of replacing stuff postage etc... but I've put in really low figures in those.

  8. #8
    Join Date
    Mar 2011
    Location
    Brighton, United Kingdom
    Posts
    266

    Default

    Not sure how this will look since I copied it off the spreadsheet:

    labour per hour d1 £5.00

    Your raw material cost for this item are £19.00

    Your indirect costs per creative hour are…………… f1 £2.62 (this was got from saying that I have around £2000 worth of equipment could this be the bad bit?)

    Total time spent 3.00 hours (or this bit I need to get faster at clean up! buy chain for the extender and not include a weight)

    This is your ABSOLUTE MINIMUM WHOLESALE price……………………… h1 £41.85

    Profit 20.00%

    Wholesale £50.22

    If a retailer now buys your item they will typically want to make 100% profit £100.44

    Since that is a high figure for a relatively easy piece although with a necklace and chain extender and weight. I'm considering dropping the profit or retail markup or anything to make it seem more in line with the end product. Or sell the chain separately? Seems a shame to do the latter since I can't imagine buying a pendant without the chain.

  9. #9
    Join Date
    Jul 2009
    Location
    Romsey
    Posts
    5,256

    Default

    Quote Originally Posted by Kathryn Harrison View Post
    Since that is a high figure for a relatively easy piece although with a necklace and chain extender and weight. I'm considering dropping the profit or retail markup or anything to make it seem more in line with the end product. Or sell the chain separately? Seems a shame to do the latter since I can't imagine buying a pendant without the chain.
    I don't see a problem with the way the numbers are used; 20% profit is not unreasonable. It's almost identical to how I calculate costs - (labour * hourly rate + materials) * 1.2 for wholesale.

    Do your raw material costs factor in consumables at all? And postage to get the items to you?
    I admit I'm slack on indirect costs, I just factor it into the hourly rate.
    There's nothing in there for assay costs (which should include postage again)...?

    I've sold the occasional pendant without a chain, but not offered it as such.

  10. #10
    Join Date
    Feb 2011
    Posts
    1,743

    Default

    Quote Originally Posted by ps_bond View Post
    Out of interest - why? I may be taking a simplistic approach on modifying the hourly rate to compensate for learning/working slower than an experienced jeweller. Overheads are pretty similar, materials costs are roughly the same.
    Because they are all predicated on an hourly labour charge. Which means that if you are like me (or were like me, I'm better and faster now ) then your hourly rate is going to be in the pence per hour and not £ per hour. So basically if everything takes 20 times longer because of lack of experience, then the reality is that you are selling for the cost of materials plus a bit extra.

    It's really difficult to decide, as a beginner, what your price per hour should be. As an example, using the most basic formulas I've seen which are similar to the one Kathryn showed, my collars, if I was charging even just £1 per hour, would have been selling for well over £250. Yes, I was that rubbish then! Which made me think that I'd charge cost of materials (including hallmarking consumables etc) plus 100% which came out at about £100. Which was way below what anyone else was charging for similar items (though there wasn't much to compare it to). So I took the kind of prices that people were paying for similar items in terms of them being custom made and with similar amounts of work in them and used those as a guide price.

    The pricing must be fairly ok because I get regular orders (even though my etsy, website and social media sites all say I'm not taking on new work and have to turn some commissions down).

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •