Showing posts with label spreadsheets. Show all posts
Showing posts with label spreadsheets. Show all posts

April 3, 2012

April 2, 2012


I've been beating myself over the head lately for not accomplishing all my goals by the end of the four months. I didn't loose weight (meh), I didn't finish my brochure or packaging, I didn't learn my CAD program well enough to use it exclusively for my designs and more, but I don't want to bore you too much. But I have to stop that now, because I've already done more than half of what I set out to accomplish.

Yesterday, I sold another set of brooches on my Artfire shop. In the beginning of the four months, I sat down and examined my product line. I thought to myself, what would the average buyer want. I thought I had a unique product, and I did. My asymmetrical three flower necklaces, while beautiful, are not for everyone. I thought that I should add single flower necklaces, bracelets, hairbands and brooches.

Not sure that I could make a decent profit on the new offerings, I made spreadsheets of cost of materials and time involved to make. It turned out that the cost of materials for the headbands and brooches, made them very profitable, and the labor was really not that bad. It's actually the cost of chain  and findings that is the highest, even though assembly is pretty quick.

I also noticed with my Apron shop, that your sales increase on Artfire, after you reach a certain number of sales. It's actually about 80, but recently my sales have doubled there, and I've done some off line selling. My goal is to wholesale, but adding a website and offering more product has done wonders. I've also done a little off site advertising (free) and will continue to find more venues and blogs to make offers to.

What I'm suggesting is, that if you are not doing as well as you expect, take a good hard look at your product. Sit down, have a glass of wine, take a bath, visualize your product and what you could offer. Look at what other sellers are doing. I see so many beautiful elegant earrings on Etsy that have the wrong earwires on them. It just takes a little effort to finds a simple clean elegant earwire to raise your beautiful earrings up a notch or two. You can even make your own, fairly easily, or buy from another crafter.

I was shocked at how my efforts have paid off. I've been on Artfire for almost 2 years and was about to give up and close the shop. Last month I sold twice as much jewelry as I sold Aprons/bowties on my other shop. It's a little bit of work and planning, but after all, we're not just crafters and artists, we're entrepreneurs.

March 25, 2012

March 24, 2012

Ack! I think the whole point of this diary was to DECIDE between my flower jewelry and my lighting design work. Well I failed miserably at two things so far. I haven't been tracking my goals and I really haven't lost weight. Considering I was pretty sick for almost two months of this thing, I did pretty well.

I was dressing to go out to a family dinner tonight and the bulging gut was very disappointing. I've decided that I really have to get rid of the heart attack fat, if nothing else. I've been walking more, but not as much. I plan on getting that fishing license and walking to the park across the street to fish. maybe I'll take some of my money and buy a bike, that will be good too. If I get any good at it, I can even bike to the Post Office, but I'd have to be really good, because we have a LOT of packages to take in. Our Post office will not pick up packages where we live.

I checked my spreadsheet of things I needed to accomplish and the dates. I did NOT do a good job. I am very behind. I should have my design website finished and my brochures made by now. The logo is holding me up. I really need to either get it or do without. I have to decide. I may do without and use the logo on my images only if I ever get it. I think I have to decide on that one this week, I need my covers printed.

I have a lot to do this week, good I'm healthy again. I'll post my progress, as usual.

March 9, 2012

March 8, 2012

I have a plan, I work hard at it, and it works. Now that's a rare thing. I am a fairly organized person. I make spreadsheets of everything. Well not everything, but if I have comparisons to make I do. I'll make cost spreadsheets, accounting spreadsheets, product dimension spreadsheets, etc. I have a spreadsheet on all of my flowers and their cut sizes so I make them all pretty similar. So a 3 flower necklace has the chain type, and each flower size and color.

I recently made spreadsheets on the new product with time and cost so I could analyze the dollar per hour of each. I did that to see if wholesaling was a viable option and it was. Nice to know. I know most crafters don't really do that. Most just see the money coming in and don't realize what is going on until they do taxes at the end of the year. I know a lot are loosing money instead of making a profit. If they took the time to do a cost analysis, they could see which items make more and focus on those. Of course you have to sell them too.

So the plan is working, really. So far this month I had a bulk sale in my flower shop (the first at this shop) and I sold 7 product designs. This month I increased my income by just under $400, and the designs have the potential of making much more money in the future, with commission. I am so very pleased. And that is for March alone. The month isn't even half over. I have more design commissions in March that will bring income in April.

I was hoping that my plan would work, but it's really amazing how well it has. I have blogged more, designed a nice website, redesigned my blog, made updates on linked in, and made more Facebook and Twitter posts. I've also posted a few items on Pinterest, but not sure I really want to go there. I might be removing most of my boards and only posting things I am sure people want reposted. I love Pinterest, but the thought of getting sued scares me.