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?
#1
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!
 Reply
#2
Me too!
 Reply
#3
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
Candice
Nail Tech/Owner
http://www.PanacheNailStudio.com
 Reply

Possibly Related Threads...
Thread
Author
  /  
Last Post
Replies: 2
Views: 151
09-27-2017, 01:13 PM
Last Postbevlnt
Replies: 2
Views: 2,057
05-06-2015, 12:43 PM
Last PostLOZLOSA
Replies: 0
Views: 1,183
02-02-2015, 04:58 PM
Last Postnails by Judy
Replies: 1
Views: 1,304
02-02-2014, 01:55 PM
Last PostColleenNY
Replies: 3
Views: 2,517
01-30-2014, 11:02 AM
Last Postyou'vegotnail!
Replies: 3
Views: 2,382
01-23-2014, 03:30 PM
Last Postlovethosetoes
Replies: 1
Views: 1,331
01-11-2014, 09:46 AM
Last PostDarcy
Replies: 8
Views: 5,943
10-21-2013, 07:56 PM
Last Postkspeth
Replies: 2
Views: 2,419
07-19-2013, 06:58 PM
Last PostNails4ever
Replies: 0
Views: 1,676
03-30-2013, 11:24 AM
Last Postlmgray46

 
Forum Jump:


Users browsing this thread: 1 Guest(s)