You are not logged in or registered. Please login or register to use the full functionality of this board...
Hello There, Guest!

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Spreadsheet for tracking inventory & supplies?
Does anyone have a spreadsheet for tracking inventory and supply levels? I know how to make them, I just am not sure how I should be organizing it and wondered if someone already had a template. TIA!
Me too!
I don't really track inventory, because I have things stored together pretty much, so I can see at a glance what I am getting low on. When it comes to supplies (vs. product) I order in bulk, so that makes it easy. For example, nail wipes I buy a case of 5,000 - so when I'm down to my last four packs or so it's time to reorder, and to keep things simple I will stock up on anything else that I buy from that supplier so that I save on shipping, plus I save time receiving and putting away product. For most products I buy, I only have to purchase them once or twice a year (saving time and money dealing in bulk). Some items I may buy more frequently, but not many. Other things like Footsie Bath liners, I will order a case of 100 when I get down to about two weeks worth left (and again will re-stock anything else I use that comes from that vendor), but I watch for sales and will purchase sooner to catch a good deal. Doing it this way makes it almost a no-brainer, which is why I (spreadsheet geek) don't have a spreadsheet for inventory.

Are you looking to just do a straight inventory? To me that means listing all products, the cost and quantity you purchase them in, then the on-hand amount, and determining your reorder level. That's pretty straightforward. Or, are you looking to track how much you're using in services? That's a whole different ball game! Smile
Nail Tech/Owner

Possibly Related Threads...
Last Post
Replies: 2
Views: 2,235
09-27-2017, 01:13 PM
Last Postbevlnt
Replies: 2
Views: 3,380
05-06-2015, 12:43 PM
Replies: 0
Views: 1,833
02-02-2015, 04:58 PM
Last Postnails by Judy
Replies: 1
Views: 2,125
02-02-2014, 01:55 PM
Last PostColleenNY
Replies: 3
Views: 4,327
01-30-2014, 11:02 AM
Last Postyou'vegotnail!
Replies: 3
Views: 4,378
01-23-2014, 03:30 PM
Last Postlovethosetoes
Replies: 1
Views: 2,238
01-11-2014, 09:46 AM
Last PostDarcy
Replies: 8
Views: 9,674
10-21-2013, 07:56 PM
Last Postkspeth
Replies: 2
Views: 3,827
07-19-2013, 06:58 PM
Last PostNails4ever
Replies: 0
Views: 2,205
03-30-2013, 11:24 AM
Last Postlmgray46

Forum Jump:

Users browsing this thread: 1 Guest(s)