Part management

Started by RamseyReelRepair, January 28, 2019, 03:25:49 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

RamseyReelRepair

Hey guys has anyone going a good computer program for keeping track of which parts they have?

Thanks
West
Check out the website and gallery!
😎http://www.ramseyreelrepair.com😎

Reel 224

West; Do you have MS office? If so you can find a good inventory program Windows for that. Or do a spread sheet. List parts by reel and part #0000.

You can also create a Invoice for customers and keep track of parts and cash flow.

Joe
"I don't know the key to success,but the key to failure is trying to please everyone."

festus

If you don't have Microsoft Office. which contains Excel, the spreadsheet software, try Kingsoft Spreadsheets Free. http://www.ksosoft.com/product/spreadsheets-free.html

RamseyReelRepair

Thanks guys I do have Excel. Does anyone have any good templates they would be willing to share?

West
Check out the website and gallery!
😎http://www.ramseyreelrepair.com😎

exp2000

#4
I feel that keeping an inventory for such would amount to far too much work.

Parts for reels that I commonly service are kept in utility drawers according to reel or series so it is pretty easy to monitor stock visually and order parts when stock becomes depleted.

Small parts are more difficult to keep track of so I catalogue these in individual plastic bags but plastic tubes are much easier to handle:

exp2000

#5
However, bearings are another matter as I order these by size and there are multiple suppliers.

It helps to be able to view supplier availability and pricing at a glance so I keep a stock inventory for these.

I created an excel spreadsheet to facilitate ordering as it can save a lot of repetitive lookup work when ordering:

RamseyReelRepair

Awesome thanks. Did you make the plastic bag dividers? Anyone have other thoughts?

Thanks
West
Check out the website and gallery!
😎http://www.ramseyreelrepair.com😎

Alto Mare

You're getting some great ideas West.
If you have the room, tall units with multiple drawers would be great. They do not need to be oak, as the ones I'm showing, plastic or steel would do just as good

Most of my drawers are for Penn parts, if you work on many different reels I recommend these Plano boxes

I got the idea from the Boss and have been working out great. You could even take them with you on the road, if you had too
I don't, but I've seen Alan do so.
A sticker on the top of the box with the reel manufacturer is all that would be needed.

Fred has some great storage compartments for reel parts, I'm sure he will chime in.


Sal
Forget about all the reasons why something may not work. You only need to find one good reason why it will.

exp2000

#8
Quote from: RamseyReelRepair on January 28, 2019, 03:44:14 PM
Awesome thanks. Did you make the plastic bag dividers?

Thanks
West

The divider trays are just plastic utility trays bought from the local hardware store.

I have cut the lid off and fitted them in drawers for quick and easy access.

They are a lot cheaper than buying from the tackle store.
~


RamseyReelRepair

Thanks for the great ideas guys I'll definitely give some of them a try. I'm moving it all out to the garage and putting a side door on the garage so people can come in that way. I want going to do that yet but I got a sudden influx after doing a couple of shows so now it's pressing. I got 8 on the bench and more on the way!

Thanks
West
Check out the website and gallery!
😎http://www.ramseyreelrepair.com😎

Alto Mare

#10
since you are remodeling, you might want to install a powder room as well, make sure if you do so to place it away from the parts.
When I get visitors and they want to use the bathroom, I tell them there a couple on the second floor.
Somehow they always like to use the one in the basement close to my part bins ;D

Good luck to you, looks like you're at a good start.

Sal
Forget about all the reasons why something may not work. You only need to find one good reason why it will.

Reel 224

Got that exact setup Sal. But the back room is getting to small for me, I have to make plains for moving in the basement and putting in another bathroom. The basement gives me 1,200 SF.

West: Take that advice when your planing, especially if you plain on machining. It takes up a lot of room.

Joe
"I don't know the key to success,but the key to failure is trying to please everyone."

RamseyReelRepair

I will keep all that in mind thanks guys.

West
Check out the website and gallery!
😎http://www.ramseyreelrepair.com😎