Sunday Afternoon Housewife

Day 3 of pay-what-you-can week (or Get Back on Track week!) is here! This week I have offered my e-book, Blogging for Crafters, on a pay-what-you-can sale as well as my Consignment Tracking Spreadsheet. Both are available for a minimum price of $1.00 each all week long! Today I’m offering to you, for the same pay-what-you-can price, my Cost of Goods Sold, or COGS, Spreadsheet.

COGS Stands for cost of goods sold, and if you sell things, you need to know how to figure your COGS.

So, how do you use the worksheet?

The first half of the spread sheet (the orange lines) are where you enter in your material and labor costs. Now, for this spreadsheet to work for you, you do need to have your material costs at hand, and you need to know what you charge for labor and how long it takes to make something. So for a quick example, if you make a beaded necklace, you’d want to know that the beads you use cost, say, 25 cents per necklace, the cord 50 cents, and the clasp 30 cents. You’ll enter that into the material costs section. Now for labor, you’ll want to know what you pay yourself per hour for labor. If you pay yourself $15 an hour, and your necklace takes 30 minutes to make, then you’d put $7.50 in the labor line. The spreadsheet will give you a nice little total of labor and material costs.

Now, the bottom half of the spreadsheet is where the real magic happens. Once you’ve plugged in your material and labor costs, the spreadsheet is going to calculate your wholesale costs and retail costs based on the most commonly used calculations. You choose whether or not to add on the Etsy listing fee and percentage for when the item sells, and the spreadsheet adds the PayPal fees, too! And, if that weren’t awesome enough, you can also enter in your state’s sales tax and get a final retail price with tax figured in, which is really good to know for craft fairs.

This is an MS Excel Document and is sent to you as such.

This worksheet is a really great tool to make sure that you are making as much money as you should make when selling your handmade products. Whether you make them and sell them yourself at fairs or online, or on consignment in shops, you need to make sure you are making enough money for yourself and to help your business grow.

If you are ready to get the COGS worksheet, use the special “add to cart” link below. You can adjust the price and hit “update cart” to buy it at the price you can pay! The minimum is $1, but otherwise, simply pay what you can!

If you are interested in more Sunday Afternoon Housewife digital products at the pay-what-you-can price, don’t forget to check out my e-book, Blogging for Crafters, or my Consignment Tracker Spreadsheet!

Stay tuned for more items at a pay what you can price tomorrow! And don’t forget, you must use the special link at the end of each blog post to get the pay-what-you-can pricing!