Anyone have experience managing inventory for a small business?
I've just started this year and am having a hell of a time getting it straight.
I've been using excel to track changes but haven't yet come up with a reliable structure to give summary totals, keep a running record of ingredient use and set reliable thresholds for reordering.
What tips can you offer from your experience?
We were using quickbooks before I got involved in the inventory process. It was just so poorly managed that it's more of a distraction now.
The owner won't even let me see the quickbooks program because it contains pricing information but he still wants me to figure out why quickbooks is wrong and justify why my numbers are right!
Something like this:
I usually just write something that does it, though. I'm trying to push family's business off of Quickbooks, but after years of using it, you kind of get locked in. Currently using their SDK to connect and get most of the data out of it and put it into my own database for the time being.
At my company, the warehouse guys input the data into a shared google docs file, that is then uploaded by someone at the office into LinnWorks.
I've seen other guys manage inventory through quickbooks for much smaller operations.