Do you organize or inventory your spare parts? How?
#2978962
10/27/21 03:31 PM
10/27/21 03:31 PM
|
Joined: Jan 2003
Posts: 7,545 Albany, NY
67SATisfaction
OP
The member whose name is actually Art
|
OP
The member whose name is actually Art
Joined: Jan 2003
Posts: 7,545
Albany, NY
|
Hey, just curious,
Do any of you keep track of your spare parts, like an inventory, that you refer to before going looking for the part on your shelf somewhere, or do you just rely on memory, keep them all in the same place, to find where you left it?
I've got a good amount of useful spare parts for our Satellites. I've got them in boxes, shelves, cabinets in the garage, or basement, or at the warehouse - it's a little mixed up so sometimes I don't find stuff anymore. I'm thinking simplest approach is to just gather and organize it all in one place.. then I just have one place to search for stuff.. I keep filters, fluids and other consumables close by in my garage, then the spare parts can go elsewhere.
Do any of you keep a spreadsheet of what you've got? Any advice that works for you?
Cheers, - Art
65 Satellite hardtop 361/4bbl console 727 2.76 67 Satellite convert 383/2bbl column 727 3.23 67 Lancia Fulvia Sport 1.3 Zagato. Alloy body, 1.3L V4 DOHC 4-spd 67 Lancia Fulvia Rallye 1.3. Alloy panel, 1.3L V4 DOHC 4-spd 71 Alfa Romeo GT Junior 1300 Zagato, 1.3L 4cyl DOHC hemi 5-spd 82 Alfa Romeo GTV6 2.5L SOHC hemi V6 5-spd transaxle 75 Maserati Bora US spec 4.9L DOHC hemi V8 5-spd ZF 77 Maserati Khamsin Euro spec 4.9L DOHC hemi V8 5-spd ZF 07 Aston Martin DB9 6.0L DOHC V12 6spd transaxle
|
|
|
Re: Do you organize or inventory your spare parts? How?
[Re: IMGTX]
#2978991
10/27/21 05:29 PM
10/27/21 05:29 PM
|
Joined: Jan 2003
Posts: 10,757 North Dakota
6PakBee
I Live Here
|
I Live Here
Joined: Jan 2003
Posts: 10,757
North Dakota
|
Out of desperation I've been doing a combination of what you guys are. I write a number on a box and then list the number, location, and contents on a handwritten list. Plan is to transfer the list to a worksheet but I haven't gotten that far.
"We live in a time when intelligent people are being silenced so that stupid people won't be offended".
|
|
|
Re: Do you organize or inventory your spare parts? How?
[Re: 6PakBee]
#2978998
10/27/21 06:27 PM
10/27/21 06:27 PM
|
Joined: Aug 2007
Posts: 603 Mass
charge70
mopar
|
mopar
Joined: Aug 2007
Posts: 603
Mass
|
Out of desperation I've been doing a combination of what you guys are. I write a number on a box and then list the number, location, and contents on a handwritten list. Plan is to transfer the list to a worksheet but I haven't gotten that far. This is what I did.I transfered everything into a spread sheet program.I was then able to print out a compete list of what I have and where it is.It's nice to be able to bring a copy with me to the shows so I know what I have and how many I have.It took awhile,but it was worth it.
1970 Dodge Charger R/T S.E.
1969 Dodge Dart GTS 440 M-Code
1970 Dodge Charger 500 383/4-speed w/A.C.
|
|
|
Re: Do you organize or inventory your spare parts? How?
[Re: charge70]
#2979018
10/27/21 07:44 PM
10/27/21 07:44 PM
|
Joined: Jan 2003
Posts: 10,634 Freeport IL USA
poorboy
I Live Here
|
I Live Here
Joined: Jan 2003
Posts: 10,634
Freeport IL USA
|
What you guys are doing is much better then what I used to do.
I did the shelf/pile inventory method. If I thought something was worth saving, it got stuck on a shelf, that is until the shelves got too full, then it sort of fell off the shelf and onto a pile. Back in the 80s & 90s that worked pretty well, I had space, and I sold a lot of stuff. Back then, not much stayed here very long, which helped a lot. When I wanted something I thought should be on the shelf/pile, I would dig through the pile. My success rate in the early years was quite high, but as the years passed, the success rate dropped to about 50% on finding a part I thought should have been there. As a side note, several times I found stuff I was looking for before...
About 20 years ago I pretty much quit collecting parts that were not for a specific project, and the parts for that project were all grouped together. Over the years I've managed to use up, or get rid of the earlier piles/shelves of stuff. About the only stuff here anymore is what is left from the nearly completed project, and what will be needed in the near future for that or a different project. I can actually see what I have now! Gene
|
|
|
Re: Do you organize or inventory your spare parts? How?
[Re: AndyF]
#2979057
10/27/21 09:39 PM
10/27/21 09:39 PM
|
Joined: Aug 2003
Posts: 3,509 Eyewa
330Scott
master
|
master
Joined: Aug 2003
Posts: 3,509
Eyewa
|
I highly recommend these steel shelving units from Whalen Furniture. 24" deep x 77" wide x 72" tall with wire decking. Use the interlocking feature & you can build three units out of two. Think I paid ~$160 each at Costco a few years ago. Most of my stuff is stored in bankers boxes, copy paper boxes and plastic tubs that I have tagged but that is about as far as I have gone with keeping an actual inventory. I would like to find similar shelving in 12"x36"x36"/48"/72". Anyone know of any industrial shelving these sizes?
|
|
|
Re: Do you organize or inventory your spare parts? How?
[Re: 67SATisfaction]
#2979084
10/27/21 10:51 PM
10/27/21 10:51 PM
|
Joined: Jan 2003
Posts: 1,767 Windsor, ON, Canada
Diplomat360
top fuel
|
top fuel
Joined: Jan 2003
Posts: 1,767
Windsor, ON, Canada
|
Ohh....this is so up my alley I am nearly giddy!!! So look, way back when (circa 1995) when I bought my '80 Diplomat coupe, as I started to take it apart I thought to myself: aha, need to label and record everything...otherwise there is no way I can put all this stuff back together. I tossed all this into a spreadsheet, which has now gone through numerous enhancements, and today is my 'Mopar Inventory' tracker. Where possible, I include a reference to the Mopar Parts Book (so section, etc.), or if it's an Aftermarket part I toss a URL link to either the manufacturer's Part page, or the reseller's page (typically Summit Racing, or Jegs), the QTY, the purchase price, date, source and possibly some remarks. Take a peek at the attachment screenshot...for the most part, super easy to find just about anything I can think of, meaning: "hhmm...I could have sworn I had this...or bought that...let me check"! I also maintain separate Project Spreadsheets, where I track all the project details. So my current 408 W2 stroker build has all the parts info and assembly specs & blueprint details captured in it.
|
|
|
Re: Do you organize or inventory your spare parts? How?
[Re: Diplomat360]
#2979087
10/27/21 11:06 PM
10/27/21 11:06 PM
|
Joined: Jan 2003
Posts: 7,545 Albany, NY
67SATisfaction
OP
The member whose name is actually Art
|
OP
The member whose name is actually Art
Joined: Jan 2003
Posts: 7,545
Albany, NY
|
Ohh....this is so up my alley I am nearly giddy!!! ... I tossed all this into a spreadsheet, which has now gone through numerous enhancements, and today is my 'Mopar Inventory' tracker. Where possible, I include a reference to the Mopar Parts Book (so section, etc.), or if it's an Aftermarket part I toss a URL link to either the manufacturer's Part page, or the reseller's page (typically Summit Racing, or Jegs), the QTY, the purchase price, date, source and possibly some remarks. Take a peek at the attachment screenshot...for the most part, super easy to find just about anything I can think of, meaning: "hhmm...I could have sworn I had this...or bought that...let me check"! I also maintain separate Project Spreadsheets, where I track all the project details. So my current 408 W2 stroker build has all the parts info and assembly specs & blueprint details captured in it. So - when you look up whether you have a part or not, and see the ones you are looking for - how do you track where they are located.. ? That's definitely an amazing spreadsheet - and I see the Tabs for each category of parts.. super thorough. Definitely something for those with lots of flow-through, sellers or those who build a lot.. In those circumstances, like selling, any estimate of how much time you spend updating it? Per week, or per month? I've settled - at least initially - on the "Put it all in labeled boxes and cluster them on shelving" approach.. I have hand-written lists I think I'll enter into a basic spreadsheet to make it searchable and easier to verify what parts I have.. Cheers, - Art
Last edited by 67SATisfaction; 10/27/21 11:09 PM.
65 Satellite hardtop 361/4bbl console 727 2.76 67 Satellite convert 383/2bbl column 727 3.23 67 Lancia Fulvia Sport 1.3 Zagato. Alloy body, 1.3L V4 DOHC 4-spd 67 Lancia Fulvia Rallye 1.3. Alloy panel, 1.3L V4 DOHC 4-spd 71 Alfa Romeo GT Junior 1300 Zagato, 1.3L 4cyl DOHC hemi 5-spd 82 Alfa Romeo GTV6 2.5L SOHC hemi V6 5-spd transaxle 75 Maserati Bora US spec 4.9L DOHC hemi V8 5-spd ZF 77 Maserati Khamsin Euro spec 4.9L DOHC hemi V8 5-spd ZF 07 Aston Martin DB9 6.0L DOHC V12 6spd transaxle
|
|
|
Re: Do you organize or inventory your spare parts? How?
[Re: 67SATisfaction]
#2979129
10/28/21 05:51 AM
10/28/21 05:51 AM
|
Joined: Dec 2016
Posts: 1,115 Usa
A39Coronet
super stock
|
super stock
Joined: Dec 2016
Posts: 1,115
Usa
|
At work we would take photos of everything in the box and tape it to the outside. Made it easier for us before we had to get a forklift.
I just recently got finished completely sorting nuts, nuts, fasteners, cap screws, Oe fasteners, fine thread, etc into a dedicated toolbox. I had bags and bags of anything and everything, it's an amazing feeling when you can open a drawer and have some guidance on looking for something.
For car parts I have my own system on memory, but it's really only for one car so it's not bad. If you have too much to memorize, consider selling for the next generation to utilize.
Last edited by A39Coronet; 10/28/21 05:57 AM.
|
|
|
Re: Do you organize or inventory your spare parts? How?
[Re: 67SATisfaction]
#2979207
10/28/21 10:56 AM
10/28/21 10:56 AM
|
Joined: Jan 2003
Posts: 1,767 Windsor, ON, Canada
Diplomat360
top fuel
|
top fuel
Joined: Jan 2003
Posts: 1,767
Windsor, ON, Canada
|
So - when you look up whether you have a part or not, and see the ones you are looking for - how do you track where they are located.. ?
That's definitely an amazing spreadsheet - and I see the Tabs for each category of parts.. super thorough. Definitely something for those with lots of flow-through, sellers or those who build a lot.. In those circumstances, like selling, any estimate of how much time you spend updating it? Per week, or per month?...
Well, I'm no seller of any sorts. Just a DIY guy who happens to be an IT guy by profession, so this sort of stuff comes really easily to me. I spent a few years developing big database programs, so doing a spreadsheet seemed like an easy way to get to a manageable way of tracking things. Heck, to tell you how old the darn thing is, it's actually a Lotus 1-2-3 spreadsheet, which means anything other than Lotus 1-2-3 trying to open it today has a bit of a problem...LOL, so I need to start thinking about "migration". Anyways, for what it's worth, I took a quick pass through this you guys and got an Excel version of it crafted. Some tiny clean-up (you know, to protect the "innocent", so I got rid of the private stuff, like Invoice #s, etc.). The move to Excel format dropped all the 'Product Page' URL links, which sucks...but if you want to bring that back just query it up and update the cell, easy to do. Take a look at the attachment, if you can use it, by all means have a go at it. I did leave all the information in there, so for what it's worth there is a quick way to see how the prices have gone up over the years. Keep in mind that this is all specific to my 1980 Dodge Diplomat (or similar years F/M/J-body cars), while the engine is all small block stuff. The actual parts that sit on my storage shelves are categorized per the spreadsheet TABs, each box and/or bag has a PART# printed. That way whatever I drag out, I just punch in the number into the spreadsheet search to see the details.
|
|
|
Re: Do you organize or inventory your spare parts? How?
[Re: 330Scott]
#2979209
10/28/21 10:59 AM
10/28/21 10:59 AM
|
Joined: Jan 2003
Posts: 1,767 Windsor, ON, Canada
Diplomat360
top fuel
|
top fuel
Joined: Jan 2003
Posts: 1,767
Windsor, ON, Canada
|
Very, very nice Diplomat360. Spreadsheets are my favorite software pkg. You dun good. 25 years of tracking parts and especially prices is impressive. Plus I would think that it would force you to stay organized, too.
At one point I took a Microsoft Access database class with the intent of using my parts for the data to learn the program. Problem was that I could never get past the concept of a database being anything other than a flat file. You bet, thanks! The benefit here is that at least I can always account for a cost of any particular project/change I'm working through on the car. Adding items today is a slow trickle kind of a thing anyways, so this doesn't take much time.
|
|
|
Re: Do you organize or inventory your spare parts? How?
[Re: Diplomat360]
#2979214
10/28/21 11:13 AM
10/28/21 11:13 AM
|
Joined: Jan 2003
Posts: 4,158 Canada -- Posts: 4034 -Registe...
5thAve
Doesn't care what this says anyway
|
Doesn't care what this says anyway
Joined: Jan 2003
Posts: 4,158
Canada -- Posts: 4034 -Registe...
|
Diplomat360's spreadsheet is pretty impressive!! I only have stuff stashed away in boxes and shelves. I know what I have and usually where it is. I'd rather not know how much I spent on things My worst habbit is keeping fasteners in ice cream containers. It used to be easy when it was only mopar but now they're other makes involved and they're all mixed together so it's gone from knowing what nut, bold or clip is for what to more of a trial and error thing.. the mopar stuff I can still usually pick out pretty easily for the older cars anyway.
|
|
|
Re: Do you organize or inventory your spare parts? How?
[Re: moparx]
#2979326
10/28/21 05:42 PM
10/28/21 05:42 PM
|
Joined: Jan 2004
Posts: 4,580 Motor City
6PKRTSE
master
|
master
Joined: Jan 2004
Posts: 4,580
Motor City
|
All of my extra parts are in storage totes and labeled. Larger parts like deck lids, doors, dashes etc are upstairs in the rafters.
1963 Belvedere 440 Max Wedge Tribute 1970 Charger R/T S.E. 440 Six Pack 1970 Challenger R/T, 528 Hemi 1970 Charger 500 S.E. 440 4 BBL 1970 Plymouth Road Runner 383 1974 Chrysler New Yorker 440 1996 2500 RAM 488 V-10 4X4 2004 3500 Dually Cummins 4x4 2012 Challenger R/T Classic.
|
|
|
Re: Do you organize or inventory your spare parts? How?
[Re: larrymopar360]
#2979364
10/28/21 07:31 PM
10/28/21 07:31 PM
|
Joined: Jun 2005
Posts: 5,112 Western Md.
skicker
"The Champ"
|
"The Champ"
Joined: Jun 2005
Posts: 5,112
Western Md.
|
Most things that will fit in totes are in totes...
I have tape on the totes with the contents and what car they are for...
This having parts for multiple cars is becoming a pita...
Longer or bigger and sometimes heavy items are just stored where the totes for the rest of that car are...
I made specific shelves behind the base cabinets for all trim and long items...
Everything in the basement was designed around having simple easy to get to storage for parts of the cars I'm working on...
Most of my items for Carlisle are stored in totes marked with the car they were removed from...in storage and not at my garage...
...FAFO...
|
|
|
Re: Do you organize or inventory your spare parts? How?
[Re: 67SATisfaction]
#2979368
10/28/21 07:41 PM
10/28/21 07:41 PM
|
Joined: Aug 2003
Posts: 43,292 Bend,OR USA
Cab_Burge
I Win
|
I Win
Joined: Aug 2003
Posts: 43,292
Bend,OR USA
|
I try and keep parts that are alike like cam and lifters together in one cabinet and bearings, oil pumps and timing sets in another cabinet. Gaskets sets, intake manifolds and carbs. in the center part of the shop where I can store 4 cars inside, two on lifts with two underneath them when I add another lift in their :soon luck: Bigger parts like blocks, radiators, brakes, starters, headers parts and alternator in another part of the shop storage area. You all know the old adage that a man can never have enough money, sex, HP, traction, race cars and race car parts and so on, correct BTW, I hate looking for a part I just set down and then can't find it 5 minutes later That has been happening way to much lately, the last ten or so years
Last edited by Cab_Burge; 10/28/21 07:43 PM.
Mr.Cab Racing and winning with Mopars since 1964. (Old F--t, Huh)
|
|
|
|
|