Yan Wo
Stainless
- Joined
- Jan 22, 2014
- Location
- Highland, Utah, USA
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
A difficult photo to read. Do all the drawer labels really say MISC?
George
You could also do what a lot of parts stores do and put several different things in one drawer/bin. Your spreadsheet will tell you which to look in and it saves a lot of space compared to dedicated one of drawers/bins.Here's my solution: designate each cabinet by letter and number the drawers in each cabinet. So I have A1 through A36 in the first cabinet, B1 through B36 in the second cabinet, etc., then make a spreadsheet that lists the description and location of every part.
Now when I want a 6-32 x 1/2" stainless steel button head cap screw, I can have Excel search the spreadsheet and show me its location, C13, in seconds.
This scheme allows me to use all my storage drawers and add or remove parts easily. Another advantage to this system is it can accommodate any type or size of storage container. For example, I have lots of 3" gold screws. They are in a separate location from the 3/4, 1, 1 1-4, 1 1-2 and 2 inch similar screws, which fit in the small drawers I showed above.
We will see how it goes.
Yan,
How has your inventory system been working? I ask because I'm considering doing something very similar.
-Ryan
Yan,
How has your inventory system been working? I ask because I'm considering doing something very similar.
-Ryan
Notice
This website or its third-party tools process personal data (e.g. browsing data or IP addresses) and use cookies or other identifiers, which are necessary for its functioning and required to achieve the purposes illustrated in the cookie policy. To learn more, please refer to the cookie policy. In case of sale of your personal information, you may opt out by sending us an email via our Contact Us page. To find out more about the categories of personal information collected and the purposes for which such information will be used, please refer to our privacy policy. You accept the use of cookies or other identifiers by closing or dismissing this notice, by scrolling this page, by clicking a link or button or by continuing to browse otherwise.