Author Topic: Components inventory/order lists?  (Read 819 times)

Beedoola

  • Solder Ninja
  • ****
  • Posts: 309
    • View Profile
Components inventory/order lists?
« on: May 29, 2021, 01:05:42 PM »
I have a box of resistors and caps that I have organized and use for builds but I haven't ordered anything on a large scale in years and need to replenish my stock.

Does anyone have a document/list they use as a reference for what to order?

If so, you mind sharing it? If it includes switches and stuff like that, that is awesome.

gordo

  • Electron Doctor
  • *****
  • Posts: 3230
    • View Profile
    • Project Website
Re: Components inventory/order lists?
« Reply #1 on: May 29, 2021, 02:08:49 PM »
Geez I wish this were a magic bullet.  I have a pretty decent stock and just order as my bins get low, but 100% of the time I miss something.  I've noticed that lately a lot of vendors have holes in their stock and long lead times so I'm hoping it's not due to a chill with China, lack of transportation options, or lack of raw materials.  Or all of the above.

One thing that has helped me over the last number of years is that I've pretty much switched over to 1/8 watt resistors and buy in quantities of 100 regardless of value.  It's so cheap that I can cover a lot of ground.  I haven't noticed any sonic difference (regardless of who you believe with thermal noise) and the accuracy tends to be a bit more accurate.
Gordy Power
Vaxed, boosted, ready to rock...

peAk

  • Electron Doctor
  • *****
  • Posts: 1548
  • Justin - Houston, TX
    • View Profile
Re: Components inventory/order lists?
« Reply #2 on: May 29, 2021, 02:21:49 PM »
  I've noticed that lately a lot of vendors have holes in their stock and long lead times so I'm hoping it's not due to a chill with China, lack of transportation options, or lack of raw materials.  Or all of the above.


I talked to Lawrence at BLMS about this and he pretty much confirmed this is an issue.


alanp

  • Electron Doctor
  • *****
  • Posts: 6266
  • Aotearoa
    • View Profile
    • http://alanp.info/
Re: Components inventory/order lists?
« Reply #3 on: May 29, 2021, 04:12:58 PM »
It's because a lot of factories stopped production during covid lockdowns. A *lot* of factories. Plus, of course, shipping went to hell between the Suez Canal, ports enforcing distancing, anti-covid measures, and other complications.

I'm picking that, as things start rolling again, the big contracts (Apple, etc) will be fulfilled first, and smalltime hobbyists later.
"A man is not dead while his name is still spoken."
- Terry Pratchett
My OSHpark shared projects
My website

PapaKev

  • Stompbox Star
  • ***
  • Posts: 140
    • View Profile
Re: Components inventory/order lists?
« Reply #4 on: May 29, 2021, 07:41:28 PM »
I have a box of resistors and caps that I have organized and use for builds but I haven't ordered anything on a large scale in years and need to replenish my stock.

Does anyone have a document/list they use as a reference for what to order?

If so, you mind sharing it? If it includes switches and stuff like that, that is awesome.

I use this. Some stuff is probably miss-labeled. Sometimes I add to inventory and forget to list it. I also don't keep track of how many I have as I always order 4-10 of each item and 100 when getting resistors. Feel free to download and manipulate anyway you want. Hope it helps!

 https://docs.google.com/spreadsheets/d/1tiNpswrtv-JnjNdOrMbEzZcQcaOH9uUEpKo3CxA6u4s/edit?usp=sharing

If you don't have excel, you can use this free program. http://www.openoffice.org/?lang=en-US
« Last Edit: May 30, 2021, 07:27:36 AM by PapaKev »

CodeMonk

  • Transistor Tickler
  • **
  • Posts: 86
  • Rob - Wadsworth, Nevada, USA
    • View Profile
Re: Components inventory/order lists?
« Reply #5 on: May 31, 2021, 03:31:16 AM »
This is what I use.
Its an Open Office Calc file .ODS.

Anyone that wants it, its attached.




EDIT: Updated zip file "Parts_List_BOM_2.zip" has Excel 97/2000/XP .xls file added.
Scroll bars are a bit funky.
« Last Edit: May 31, 2021, 04:46:04 AM by CodeMonk »
My friends call me Rob

Affiliations :
Dalton Jones Electronics: Chief Tinkerer