Jewelry Production Inventory
I ran into one problem with this jewelry stuff.....
Keeping track of it!
It was raining outside today anyway. I live in the boonies, and my only internet option is satellite, which doesn't work so well when it's raining.
So I sat down at the computer this morning. I don't need internet to make an Excel sheet.
I have always kept a sheet, and a tally, when I make or build things. Normally, when I am in the wood shop making something, I need to make notes on a specific product. I depend on those notes when I get back to the office to remind me of the details. I have been using this for years in my Rustic Woodworking business. I simply used my normal sheets and made it into an Excel workbook. I am still tweaking it. Let me know what you think.
Anybody just starting out in not only the jewelry business, but any home based craft business, might find this workbook helpful. I don't have it finalized yet, but here's a screen shot of what I have so far. I'm still working on some of the formulas for the back-end pages so that the tally page gets populated automatically.
The little yellow right-hand corner gets cut off and is filed with the product. The actual printed page is filed wherever you want, like in a ring binder. Since it is an Excel file, you can also fill it in on your computer and file one for each item you want to keep track of. I am going to get rid of some of the blue background to save on printer ink.