Showing posts with label inventory. Show all posts
Showing posts with label inventory. Show all posts

Wednesday, November 19, 2014

How to make bookkeeping and taxes FUN!

Carol Dekle-Foss
Ok yes, that was just a ploy to get you to read this post, but stay with me!  I'm going to review an indispensable software program called Jewelry Designer Manager by Barbara Carleton. It's not only amazing for keeping track of finished jewelry, but it's also great for keeping track of handmade components as well.

I have been using it for 3 years now and absolutely love it! There are just so many unique ways you can utilize the program. I'll be honest though, you have to enter all you data and that can be a bit time consuming. But once that's done, you have a powerful tool that can track and manage every aspect of your business. Seriously, this program rocks! 

Ok, so here are the top reasons I use this software.

NUMBER ONE. Inventory! This is where the genius comes in. You input your beads and other components into the Jewelry Parts section, and then when you make a piece of jewelry, you build your piece in Jewelry Assembly. (See next pic)  You select the parts that are included in the finished jewelry piece and the program adds up the total cost of materials. 

NUMBER TWO. Pricing.  Basically the program does this all for you. It takes into consideration all your raw materials, your labor and any other costs, and recommends the price according to the mark-up options you have set up. It helps you calculate your prices so you get paid for what you are worth, and also so you are charging a fair price to your customers.

So now, not only do you have raw inventory data for all your beads and components, you also have finished pieces data. This comes in very handy during the dreaded tax season when you are calculating your COGS. Now that's fun stuff!

NUMBER THREE: Keeps track of customer purchases. The above pic is the field where you enter customer data. Below is the invoice field.

You can also print detailed invoices to send to a customer.

NUMBER FOUR: Lastly, the software creates comprehensive reports. Being a detailed person, ok, obsessive, I like to track things. You can manage your sales, parts, customers, create PDF catalogs to send to customers via email, and create professional labels.

This program keeps me organized and on top of things so I can then spend more time in the studio. Well that's the theory anyway. Now if I could get it to feed my animals and do the laundry that would be great! 

Check out the program for yourself here and see if it's right for you!

I would love to know how you track your inventory. What works for you, do you use spreadsheets or Craftybase? 

Here's a collage of some of my recent studio creations.

 I hope you have a wonderful and safe holiday!

Thursday, July 12, 2012

The Dirty M Word Part 2: How to use your average item price

Good Morning Class! Did you all complete your homework?

If you didn't, perhaps go back to this post and see how to figure out your average item price.

So let's discuss some questions you may have about how your average item price may/may not affect your sales.

1) How does my average item price affect my sales?

In short, it doesn't. What it does affect, is the type and quantity of work you make. It is merely an means, or production strategy to your end result, or your sales number.


2) My average item price is very low. How do I change it?

There are two ways to raise your average item price. The first is to make more product. This is a double edge sword because you'll have to make much more product. Let's take a look at the example I used last time, where our average item price was $10 and our sales were $1000.

Remember: SALES = Quantity(Average Item Price)

$1000=100(10)

That meant, you would have to sell 100 pairs of earrings with an AIP of $10 to have $1000 in sales. Let's say you adjust your inventory to your next show so your AIP is $20:

100(20)= $2000

Let's look at the ways we can increase our AIP:

a) Make MORE product of a higher price point. While a piece of jewelry that is lower priced may sell easier, you have to make a least twice or more of it to equal the same as selling one piece that  is more expensive.

b) Use more expensive/exclusive materials that can demand a higher price point. If you're producing in a large quantity, you can often buy more expensive materials in bulk without deeply cutting into your profit margin, but the market will dictate a higher price because you've used more costly or precious materials.

c) Check your inventory to make sure it is well rounded. Your average item price could be low because you've overproduced your more inexpensive items and overlooked more expensive items.

3)Should you always try to raise your AIP?

No, it may not always be to your benefit to raise your AIP. As an artist, you should look at all of the shows and sales you make and analyze both the sales, the show, and the type of customers that not only attend but also PURCHASE. If you sell at mostly church bazaars and small local shows, it may not be in your benefit to RAISE your AIP, because those shows may not bear the weight of a higher AIP. In contrast, those types of shows may also not have the SALES or Customers to justify the QUANTITY of a lower AIP.

DO YOU FIND THIS TYPE OF ANALYSIS HELPFUL? 


What questions do you have about SALES that I can help answer???

Tuesday, July 3, 2012

The dirty M word



The dirty M word.....

....Do I have your attention now? :)

Well, for all intense purposes, the dirty M word today is MATH. If you were thinking that it was MONEY, well they are bedfellows but today let's talk a little about MATH and a simple equation to help keep you on track preparing for shows.


As I prepare inventory for BeadFest in Philadelphia in August, a question that's often raised to me in conversation is, "How do you know how many beads to make?" The short answer, since it is my first time there, is that, "I don't."  Now, there's all kinds of equations I could use to try and figure it out but the one that I'm finding most helpful to keep me on track with production and keep my momentum going is this:


SALES = QUANTITY(AVERAGE ITEM PRICE)

Let's break it down:

Sales: Since I don't know what my sales will be, this number is the most enigmatic. I have nothing to base this number on in reality. I do have an approximate idea of what my budget and expenses will be and I do know how many other vendors as well as a round figure of attendees. So, this number is the variable. It could be low and it could be high....I won't know until after the show.


Quantity: This is the number I can most control. The number of beads I make has a direct impact, in terms of production anyway, that will determine my sales.


Average Item Price: This might be the most confusing part. Do you know your average item price? Your average item price is the median price point of what you are selling. If you add up the retail cost of all of your items (beads, in my case) and divide it by the number of items, you will have your average item price. 


For simplicity sake, if you sell earrings, some may be as high as $50 and some may be as low as $15.  If you add up the retail value of all of your earrings, we'll say $1000 and divide it by the number of earrings you have, let's say 100 items, you average item price is $10.




Let's plug that number in to our formula:

SALES =  100(10). So in this case, if you sold all 100 pairs, your sales would be $1000.




So, I'm giving you homework~


For next Thursday's post, I want you to find out the Average Item Price of what you make....and we'll discuss how we can impact our sales but increasing/decreasing our Average Item Price...and how you can use this number to help you plan your inventory for shows!






 
face
Related Posts Plugin for WordPress, Blogger...