Inventory
Register

Welcome to the Prepper Forum / Survivalist Forum.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Inventory

This is a discussion on Inventory within the Prepper Tools forums, part of the Survivalist, Prepper, Bushcrafter, Forest Rangers category; I think this is the right sub section to post this. I have a question about inventory. I haven't been very good about it over ...

Page 1 of 3 1 2 3 LastLast
Results 1 to 10 of 21
Like Tree29Likes

Thread: Inventory

  1. #1
    Member


    Join Date
    Nov 2018
    Location
    East Coast
    Posts
    83

    Inventory

    I think this is the right sub section to post this.

    I have a question about inventory. I haven't been very good about it over the last couple of years, relying more on remembering in my head what preps I have bought and what I need to work on. After the first of the year I made myself go through everything I have and write it all down, count it etc.

    Left me with two thoughts- Number 1, I still have a ways to go. Doing the inventory really called out holes that I didn't realize I had in my preps.

    Number 2, there has to be a better way to keep track of things then writing them down in a notebook which is my current tactic.

    I guess I am looking for ideas on inventory control or tools used to keep track of inventory. How you guys keep track of everything? Do you write it down in a book? Use a spreadsheet? I really want to stay on top of things better than I have in the past.
    Denton, Slippy and Prepared One like this.
    "Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety." Benjamin Franklin

  2. #2
    Super Moderator


    Join Date
    Sep 2012
    Posts
    21,338
    Quote Originally Posted by Green Lilly View Post
    I think this is the right sub section to post this.

    I have a question about inventory. I haven't been very good about it over the last couple of years, relying more on remembering in my head what preps I have bought and what I need to work on. After the first of the year I made myself go through everything I have and write it all down, count it etc.

    Left me with two thoughts- Number 1, I still have a ways to go. Doing the inventory really called out holes that I didn't realize I had in my preps.

    Number 2, there has to be a better way to keep track of things then writing them down in a notebook which is my current tactic.

    I guess I am looking for ideas on inventory control or tools used to keep track of inventory. How you guys keep track of everything? Do you write it down in a book? Use a spreadsheet? I really want to stay on top of things better than I have in the past.
    I use a tabbed notebook so that I can categorize the items. I also have to annotate where the items are.
    Green Lilly and SOCOM42 like this.
    "Reality is almost always wrong."
    Dr. Gregory House

  3. #3
    Senior Member


    Join Date
    Nov 2012
    Location
    NORTHEAST USA
    Posts
    7,417
    Quote Originally Posted by Denton View Post
    I use a tabbed notebook so that I can categorize the items. I also have to annotate where the items are.
    Roughly about the same method, no computer stuff at all.
    Denton likes this.

  4. Remove Advertisements
    PrepperForums.net
    Advertisements
     

  5. #4
    Senior Member


    Join Date
    Nov 2013
    Location
    Wherever won't get me hit.
    Posts
    19,018
    Great question. Here's what we do to help inventory control. We are not perfect but it works pretty good on most items.

    Have a Designated Area for Certain Items;

    For example FOOD--Short Term Food goes in the cabinets and pantry. Medium Term Food is in the Basement Left Hand Side of Stairs on Shelves. Long Term Food is in the Basement on Right Hand Side of Stairs in Shelves. New purchases go either in the Medium Term Location or Long Term Loactionand rotated up to the pantry when necessary. Totes and 5 Gal Buckets are labeled with Best Used By Dates. Rotate regularly. We haven't had a need to write things down in many years due to habit AND more importantly we throw away very little bad food due to mistakes.

    Medical--Medical items are stored in two locations. Items with EXP DATES are in a cabinet specifically for MEDS and Long Term Items that you can keep forever are in some 5 gallon buckets near Long Term Food Storage. Short Term Med Cabt is reviewed maybe every other month or so. Items that we use regularly are replenished regularly.

    Fuel Cans; Get filled and put in the barn, when one runs out the empty can is put in the garage. Whether its LP Gas, Diesel or Gasoline, me and Mrs S know that if we have 3 or 4 empty cans in the garage, one of us takes them to get refilled.

    Defense/Shelter/Transportation items-- you get the gist of the process so no reason to go on and on. Just know what it takes to run your house without going into debt and without having too much of one thing...(Creamy Peanut Butter! Damnit, Mrs S eats creamy, I eat crunchy and she rarely eats creamy and I eat a lot of crunch so we are always out of crunchy and have too much creamy peanut butter! )

    It helps to have a "Mrs Slippy" who is a Habitual Purchaser of certain items that we use regularly. She knows if she is in a Sporting Goods store to buy a box of .45ACP or 9mm or .357 REM MAG etc regularly, just like she knows to buy a box of Ibuprofen or a case of Canned Spinach, or a roll or 2 of duct tape...you know things that you don't want to run out of and don't mind having an extra one around. I try to keep her in check when she gets out of whack with certain items.

    Also, we don't give birthday or Christmas gifts "per se" much anymore, but we take the time semi anually to sit down and talk about things we NEED for our little homestead. I'm constantly losing Tape Measures or the cheap ones break so its nice to get a few 25' tape measures in my stocking. Or a pair of silk boxers because it just makes a guy feel pretty!





    Quote Originally Posted by Green Lilly View Post
    I think this is the right sub section to post this.

    I have a question about inventory. I haven't been very good about it over the last couple of years, relying more on remembering in my head what preps I have bought and what I need to work on. After the first of the year I made myself go through everything I have and write it all down, count it etc.

    Left me with two thoughts- Number 1, I still have a ways to go. Doing the inventory really called out holes that I didn't realize I had in my preps.

    Number 2, there has to be a better way to keep track of things then writing them down in a notebook which is my current tactic.

    I guess I am looking for ideas on inventory control or tools used to keep track of inventory. How you guys keep track of everything? Do you write it down in a book? Use a spreadsheet? I really want to stay on top of things better than I have in the past.
    Last edited by Slippy; 01-13-2020 at 12:11 PM.
    Green Lilly and Prepared One like this.

  6. #5
    Senior Member


    Join Date
    Dec 2019
    Posts
    1,116
    I use an Excel spreadsheet to track our inventory of ammo. Everything else is in my head right now. I just haven't gotten around to getting it on the computer. If you do use a spreadsheet, don't forget to print it out regularly (a) so your significant other can look at it on paper and (2) so that you have a copy if the computers get fried.
    paraquack likes this.

  7. #6
    Senior Member


    Join Date
    Nov 2013
    Location
    Wherever won't get me hit.
    Posts
    19,018
    Quote Originally Posted by paulag1955 View Post
    I use an Excel spreadsheet to track our inventory of ammo. Everything else is in my head right now. I just haven't gotten around to getting it on the computer. If you do use a spreadsheet, don't forget to print it out regularly (a) so your significant other can look at it on paper and (2) so that you have a copy if the computers get fried.
    Woman, you be wasting your time with an Excel Spreadsheet for Ammo! Ammo is the easiest thing to inventory, get you a bunch of Metal or Plastic 50 Cal Ammo Cans and fill those suckers up with the calibers that pertain to the guns that you own, shoot and plan on using post SHTF. When you fill them up get you a couple of Medium to Large Gun Safes and fill those up too!

    Then start over and do it again...

  8. #7
    Senior Member


    Join Date
    Dec 2019
    Posts
    1,116
    Quote Originally Posted by Slippy View Post
    Woman, you be wasting your time with an Excel Spreadsheet for Ammo! Ammo is the easiest thing to inventory, get you a bunch of Metal or Plastic 50 Cal Ammo Cans and fill those suckers up with the calibers that pertain to the guns that you own, shoot and plan on using post SHTF. When you fill them up get you a couple of Medium to Large Gun Safes and fill those up too!

    Then start over and do it again...
    Hahahaha! I wouldn't do it if I didn't like running it through my hands and counting it. It's also an easy way to keep track of how much we've paid for it. The Handsome Husband likes to know if a sale is really a sale.
    Slippy likes this.

  9. #8
    Senior Member


    Join Date
    Jun 2017
    Location
    Pensacola, Florida
    Posts
    294
    This is how our 50 person group retreat does it.

    We have designated storage places in the barn. There is a place for each of our Focus Groups, or area of concerns: Health, Morale, Nourishment, Planning, Physical and Security.

    We rely on spreadsheets for each area.

    If we pack food stocks in large containers we label the contents on the container.
    We learned the hard way to record purchase dates of stored fuel.

    All food contributed by others is recorded on a spreadsheet for them so If they leave they can get their food.
    Last edited by jimcosta; 01-13-2020 at 12:56 PM.
    paulag1955 and Green Lilly like this.
    Our Survival Group Website: Hidden Content

  10. #9
    Member


    Join Date
    Dec 2019
    Posts
    96
    We use boxes or plastic bins for most of the "deep storage" goods/supplies. I try to group the contents in general categories, personal hygiene, medical, communications, etc. Each box gets a designation, the first a character for it's location (A for attic, B for basement) and a unique number. A handwritten listing of the contents of each box/bin gets placed on a clipboard and a second photocopy of it placed in the box itself. Works well enough for us.
    Green Lilly likes this.

  11. #10
    Senior Member


    Join Date
    May 2019
    Location
    Mississippi
    Posts
    464
    I guess I am looking for ideas on inventory control or tools used to keep track of inventory.
    This is a big thing with us, especially for food. We are math geeks so we do use spreadsheets for some things. And before I go any further, if you go this route, do NOT upload 'em to the cloud! Do a monthly backup onto an external hard drive or to another devise. And what Paulag said-- print 'em out on a regular basis.

    In particular, John has a spreadsheet for the meat in his deep freezer, I have some for what's in my freezer, etc.

    We do a weekly menu. Except for veggie night it's based on the what's "coming up next" on the meat spreadsheet. The columns are item (whole chicken), size/pounds, date (sell-by). Each individual package of meat gets its own row.

    From that is generated a shopping list. The first thing we do is shop the pantry (& storeroom) and the item gets a "replace" next to it on the list. (I do NOT have a spreadsheet for the pantry. More below.) At the store, John does the meat shopping and looks for bargains. As soon as stuff is put away, he updates his spreadsheet and puts stuff in the freezer. He even has a system for how his freezer is organized, oldest to newest.

    His spreadsheet for meat, poultry, etc. also includes leftovers we may freeze, sausage we make, and stuff like that. Everything is categorized. As he's making the menu, he removes what we'll use that week from the spread sheet.

    My strategy in the pantry and storeroom is different. I use an idea I picked up in retailing back in the olden days. Set Point (or "in the hole"). (This is what I do for ammo, too.) How much X do I need to have on-hand to last me short term (whatever that means to you)? That's what goes into the pantry.

    Inventory-img_0168.jpeg

    So everything takes up some space. Sometimes we wind up making something unexpectedly (or John will decide to have beans for breakfast) in which case it may not be added to the grocery list. BUT a simple visual inspection shows me where the holes are. It's also a great system for FIFO-- first in, first out. Everything is arranged by date and it makes rotating easy.

    Inventory-img_0169.jpeg

    We put all of the canned goods we're using this week on a couple of shelves in the front of the pantry.

    I did start out with a spreadsheet for the pantry but for me this way works out better. I can also adapt it to changing circumstances.

    Storeroom has longer term preps but I do it the same way.

    Ammo I do like the pantry, except I have a spreadsheet which not only has on-hand, but the set points which we keep moving up.

    My freezer has mostly stuff from the garden. So when we put up tomato sauce, those quantities go in. That also serves as a resource when garden planning.

    For the stuff on the spreadsheets, once or twice a year we'll do a physical inventory and then reconcile. We usually do my freezer (veggies) before I start spring planting and when it's nearly empty.

 

 
Page 1 of 3 1 2 3 LastLast

Sponsored Links

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Back to Top