weight tracker excel spreadsheet microsoft

The final step is to play around with some pricing options. This is so that you can compare different pricing scenarios side by side. Notice that there is more than one row for this. Next you’ll need to add in the amount of time you spent working on the project. Here you will see the total yardage used in your project, as well as the total cost of that yardage. The purple section will automatically calculate. If you don’t have the exact weight information, feel free to leave the ending weight blank, and the calculator will use the entire skein for your calculation. Next you’ll need to enter in the details of your yarn in the pink section. Insert your hourly rate in the designated box. This may change for you over time, or even based on the project.įor this example, I’m going to use $12 for my hourly rate. Your first step to using the crochet pricing calculator is to first decide what your ideal hourly wage is. Using my crochet pricing calculator, we will take the same details in scenario 1 above, and see what price we come up with. This sounds like it would work out in theory, provided you set the per stitch rate appropriately however, I don’t want to try to do the math on how many stitches are in a project, especially for something like an amigurumi project! Profitable Crochet Pricing Calculator Method I’ve seen others suggest pricing per stitch. If you just want to cover the cost of your yarn and make a few dollars to purchase more yarn, this might be the right fit for you. I will say that if you do not have any intentions of crocheting for a profit, this 3x materials method make work out for you. ExceptionsĪs with everything, there are exceptions to every rule. I don’t know about you, but I think that my time is worth more than that. If this amigurumi took me 5 hours to make, I’m only making $3.19 per hour! Not to mention that amigurumi is generally always more time consuming. However, this doesn’t factor in the cost of safety eyes, stuffing, and anything else that might be used. Using this pricing method, that means I should charge $23.94, and would only have a profit of $15.96. I purchased 2 skeins of Brava Worsted yarn, for a total of $7.98. In this example, let’s say I’m making an amigurumi that only requires 2 colors of worsted weight yarn. That means I’m only making $3.99 per hour! Scenario 2 However, this hat took me 2 hours to make. Using this pricing method, I should charge $11.97 for this hat, which leaves me a profit of $7.98. The total cost in yarn for this hat is then $3.99. I purchased one skein of Brava Worsted yarn, which is only $3.99 per skein, with a total of 218 yards. It requires about 110 yds of yarn, which is usually less than one skein. Let’s say that I’m making a hat in one solid color using a worsted weight yarn. If you’ve ever seen a pricing post in a crochet Facebook group, I’m sure that you’ve seen well-meaning people suggesting to charge the cost of your materials, multiplied by 3.įirst, let me explain why this method is not the best choice if you are truly trying to earn a profit and create a sustainable business. Other Pricing Methods 3x Cost of Materials

Weight tracker excel spreadsheet microsoft