COGS Worksheet

This is a super simple COGS Worksheet.

COGS Stands for cost of goods sold, and if you sell things, you need to know how to figure your COGS. You can read all about the creation of this COGS worksheet on my blog here: http://sundayafternoonhousewife.com/a-really-simple-way-to-figure-your-cogs/

So how does it work?

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.

So, how do you get your worksheet? It's simple. Add it to your cart, check out via PayPal, and your worksheet is automatically emailed to you. It's like interwebs magic.