May 8, 2011 8:21 AM Subscribe
Help designing a small business inventory system. Super extra difficulty inside, treat it like a logic puzzle!
posted by lazaruslong to Work & Money (10 answers total) 6 users marked this as a favorite
Okay. So I am trying to figure out an inventory management solution for the small business I manage. Cost is an issue, no software that is thousands of dollars please!
1. The things we need to inventory are disparate. We have the Front of House of the bricks and mortar business, which needs to be able to track foodstuffs, dry goods, and equipment.
2. Also have the back-of-house production kitchen, which needs to track foodstuffs, dry goods, and equipment.
3. Also have an online sales component, which needs to track foodstuffs and merchandise.
4. Our foodstuffs by in large DO NOT have barcodes. We have over 80 different local vendors for foodstuffs and they don't come boxed up and barcoded, they come in a bag handed to us by a farmer. Dry stock could potentially be barcoded, provided blackberries support it.
5. Needs to be a system that lower level management / employees can interface with easily.
6. I would like to be able to input cost information that would allow us to value inventory at any given moment as well as allow us to do analysis to project cost savings with different inventory strategies.
Something that might make it easier is that the system would NOT need to interface with sales and auto-update. Right now we use a perpetual inventory system done only by me in excel / word. We would need to continue in the perpetual inventory system, as our product sample / loss is such that POS updating would be inaccurate, and would not apply to 2/3rds of the inventory control needed sectors.