This inventory system was created specifically for the handmade maker and seller. The great thing about this system is that several of my templates that were previously stand alone are now linked together, saving you time and keeping you on top of your inventory and pricing needs. Once you mark an item as made and/or sold, your inventory will automatically update by removing the raw materials that were used in that item. The template is set up so you can price and track up to 1,000 finished products, and up to 100,000 raw materials.
See a demonstration of this template in use:
This excel template consists of several worksheets in 1 file-
1st sheet – a place to enter all you raw materials purchased
2nd sheet – a place to price all your finished items. This will include listing out the raw materials used in your finished items and entering the time you invest. You can enter your hourly rate at the top and it will calculate the cost of your time spent on each item, into the recommended retail price.
4th picture/page – Summary of Finished Inventory & COGS – This page will automatically populate a row for each finished item that has been priced in the previous spreadsheet. You’ll enter the # made and # sold next to the Item Name & Item ID. You will be able to search for your Items by name or ID using the filters function (directions are included).
1st picture- Raw materials summary – Everything in this page will calculate automatically based on the other worksheets (after clicking a refresh button when new data is entered). As your raw materials are used up in projects, the total materials available will be updated, helping you keep track of when you’re running low on a particular supply. The last 2 columns will calculate the price of all materials that are unsold (whether they have been used in a finished product and unsold or not).
All of my templates come with detailed directions with pictures and are designed to be easy to use. If you have any questions, please feel free to contact me.
The spreadsheets are designed in MS Excel. You will need Excel 2007 or newer to use this particular template, although I have other templates that will work with excel 2003. You can purchase the individual templates (not linked together) and those are compatible with earlier versions of excel and Open Office.
Click here for more templates.