Outdoors
Sponsored by

Inventory Counting project - need some help finding what i need

4,703 Views | 69 Replies | Last: 3 yr ago by highvelocity
highvelocity
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
3:34p, 1/19/21
AG
I started a rifle sling company last year and things are starting to take off a lot faster than anticipated. I have 100,000 feet of material coming in and i'm trying to figure out the best way to keep track of material inventory. Back in my oilfield days we had chemical fluid counters to tell us how many gallons were used during a frac stage - i'm wanting to do the same idea here with my inventory where a roll of inventory has a counter on it and as its used it tells me how much material has been used out of the roll

we are not to the point where i want to implement an ERP system and from what i've seen the above idea will be the best manual solution for now

any ideas would be greatly appreciated.

if you want the website link, shoot me a message. didnt want to get in trouble for advertising

Thank you!
Owner of Texas Strap Company use code TEXAGS for 15% off
www.txstrapco.com

Sales Director for BCA Firearms
www.bcafirearmstx.com
Reply Quote
AgEng06
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
3:40p, 1/19/21
AG
I don't have any ideas on your question, but I sent you a PM on the slings.
Reply Quote
3
highvelocity
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to AgEng06 • 3:43p, 1/19/21
AG
just as good in my book! let me know if you have any questions on anything or any feedback!
Owner of Texas Strap Company use code TEXAGS for 15% off
www.txstrapco.com

Sales Director for BCA Firearms
www.bcafirearmstx.com
Reply Quote
DeWrecking Crew
User Profile Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
3:46p, 1/19/21
We used to use an Olympic Instruments Cable Measurer 1700, I'm sure they have other models that would fit your need

Edit: I just looked on their website, checkout the Model 1900-3
Reply Quote
4
1 edit
Mathguy64
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
3:46p, 1/19/21
AG
Assuming your material is in a roll, rest something like this on top.

Reply Quote
9
MrWonderful
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
3:47p, 1/19/21
AG
Have no prior experience, but something like this?

https://www.globalindustrial.com/p/storage/bulk-rack/reel/global-heavy-duty-wire-meter-1-capacity

Reply Quote
2
A.G.S.
User Profile Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to highvelocity • 3:47p, 1/19/21
AG
If ya have the capex to invest, you could get something like the following:
rope meter

Unless you get a counter for every roll though, it would require manually updating tallies though, and would most likely be only slightly faster than doing manual measurements.

Alternatively, if your BOM's are fairly well defined, and if you can streamline manufacturing by having a few standard lengths that you cut the cordage to, you could precut them in batches, and store them as units of "EA" instead of units of "IN" or "FT". Your order volume would determine whether or not that is an efficient strategy though, as it could lead to waste if certain color combos don't get ordered as much.

Edited to add: If you dont have one yet, I highly recommend a heated cutter like the following:
https://www.mcmaster.com/cord-cutters

helps make clean cuts that won't fray as much on 550 cord and nylon webbing, without having to do a follow up step with a heat source.
Reply Quote
11
1 edit
highvelocity
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to A.G.S. • 4:09p, 1/19/21
AG
that cutter looks awesome and thank you for the advice, that is helpful!
Owner of Texas Strap Company use code TEXAGS for 15% off
www.txstrapco.com

Sales Director for BCA Firearms
www.bcafirearmstx.com
Reply Quote
AtlAg05
User Profile Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
4:15p, 1/19/21
AG
Is it one roll of 100K? Or broken up into smaller rolls?
Reply Quote
highvelocity
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to AtlAg05 • 4:19p, 1/19/21
AG
smaller rolls, its about 20 different colors of material broken up into equal lengths.

im thinking building a rack of some kind for reach roll then feed into its own counter kinda deal
Owner of Texas Strap Company use code TEXAGS for 15% off
www.txstrapco.com

Sales Director for BCA Firearms
www.bcafirearmstx.com
Reply Quote
O.G.
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
4:36p, 1/19/21
Reply Quote
textar4404
User Profile Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
4:47p, 1/19/21
If you want a rough measurement, you can always use a simple calculation based on material thickness, inner roll diameter, and outer roll diameter.

Here's an example of an online calculator that will give you the length that is left on the spool.

https://wieland-metalservices.com/coil-calculator/

Just put in any random material and with of strip. The only pieces of data that you really need are material thickness (assuming it is uniform), the inner diameter of the roll, and the outer diameter of the roll. This will then calculate and give you the length of material still on the roll.


Edit to add: Best part of this method is you don't have to buy anything other than a tape measure.
Reply Quote
5
1 edit
will.mcg
User Profile Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
4:56p, 1/19/21
AG
why not have a tag on each roll? Every time you cut a length deduct it from the total.
Reply Quote
2
highvelocity
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to will.mcg • 5:28p, 1/19/21
AG
this will be the last ditch effort. with the magnitude of orders coming in, i dont want to have to keep track of the number of slings that came from each roll that particular day.
Owner of Texas Strap Company use code TEXAGS for 15% off
www.txstrapco.com

Sales Director for BCA Firearms
www.bcafirearmstx.com
Reply Quote
O.G.
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to highvelocity • 5:29p, 1/19/21
highvelocity said:
this will be the last ditch effort. with the magnitude of orders coming in, i dont want to have to keep track of the number of slings that came from each roll that particular day.
So pardon my ignorance, but how do I find your company?
Reply Quote
1
A.G.S.94
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to highvelocity • 5:44p, 1/19/21

We sell fluid hose assemblies where we cut various hose types to length. Even though we do have an MRP that allows us to set up rudimentary assembly BOMs, we still have to do cycle counts every few weeks

That said, I may be oversimplifying (I am no sling expert), but I would think for each specific part number (which would capture things like color, material type, hardware type, etc.) you would have a specific material sling material length.

If you set those attributes up against a given part number in a simple spreadsheet, you could get a pretty accurate estimate of the length of material used over a given time frame. The benefit is you could run quick reports on which slings are selling the most while you wait to set up your ERP/MRP.
Reply Quote
1
will.mcg
User Profile Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to highvelocity • 5:58p, 1/19/21
AG
Yeah it's simple but somewhat tedious. What about those little clickers Home Depot uses to measure feet when you buy a length of bulk rope?
Reply Quote
Aggiemike96
User Profile Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
6:19p, 1/19/21
AG
1. Measure diameter of roll.
2. Measure diameter of core.
3. Subtract #2 from #1 = amount of material.
4. Periodically repeat #1 and #3 to estimate how much material was used and how much remains.
5. Profit???

This isn't exact, but will give you an idea of usage.
Reply Quote
2
RK
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to A.G.S. • 6:23p, 1/19/21
AG
A.G.S. said:
If ya have the capex to invest, you could get something like the following:
rope meter

Unless you get a counter for every roll though, it would require manually updating tallies though, and would most likely be only slightly faster than doing manual measurements.

Alternatively, if your BOM's are fairly well defined, and if you can streamline manufacturing by having a few standard lengths that you cut the cordage to, you could precut them in batches, and store them as units of "EA" instead of units of "IN" or "FT". Your order volume would determine whether or not that is an efficient strategy though, as it could lead to waste if certain color combos don't get ordered as much.

Edited to add: If you dont have one yet, I highly recommend a heated cutter like the following:
https://www.mcmaster.com/cord-cutters

helps make clean cuts that won't fray as much on 550 cord and nylon webbing, without having to do a follow up step with a heat source.


We used similar measuring/cutting/heating devices when I worked at REI back in high school for climbing rope, webbing, and cord. Worked well.
Reply Quote
1
BCStalk
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
6:29p, 1/19/21
We typically do weight on rolls of materials. If it's on a spool, we subtract the spool weight or use a blank to zero the scale. To cut rolled materials, we get equipment from these guys. It auto feeds and cuts to length.

https://sheffieldcuttingequip.com/products/hot-cold/
Reply Quote
1
alvtimes
User Profile Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
6:45p, 1/19/21
Reply Quote
1 edit
agrams
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to highvelocity • 7:06p, 1/19/21
AG
got a link or sample pics? i'm curious what you have!
Reply Quote
highvelocity
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to agrams • 7:37p, 1/19/21
AG
A few for you





Owner of Texas Strap Company use code TEXAGS for 15% off
www.txstrapco.com

Sales Director for BCA Firearms
www.bcafirearmstx.com
Reply Quote
12
1 edit
bam02
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
7:40p, 1/19/21
AG
I had to buy a couple hundred feet of thin steel cable from HD recently and they have a hand-cranked machine that measured and spooked as it cranked. Just a thought. Didn't look too expensive.
Reply Quote
highvelocity
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to O.G. • 7:41p, 1/19/21
AG
Www.atxstraps.com
Owner of Texas Strap Company use code TEXAGS for 15% off
www.txstrapco.com

Sales Director for BCA Firearms
www.bcafirearmstx.com
Reply Quote
4
CactusThomas
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
8:38p, 1/19/21
AG
I don't know what to order
Reply Quote
AnScAggie
User Profile Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
8:38p, 1/19/21
AG
https://www.globaltestsupply.com/product/olympic-1430-wire-and-rope-measurer-feet-inches?gclid=EAIaIQobChMInpiC97yp7gIVlt7ICh3EqA33EAQYAiABEgKv2PD_BwE

Something like this is what you are looking for. Do I win a free sling?

ETA: Should have been the laughing emoji
Reply Quote
1 edit
TH36
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to highvelocity • 8:41p, 1/19/21
You make one that would be good for packing a rifle around in the mountains? Comfy in other words.
Reply Quote
highvelocity
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to TH36 • 8:48p, 1/19/21
AG
yes, it'll get released before the end of this month. i've been messing with it the past couple months to make sure its good to go. picture below of what it'll look like. very comfy





Owner of Texas Strap Company use code TEXAGS for 15% off
www.txstrapco.com

Sales Director for BCA Firearms
www.bcafirearmstx.com
Reply Quote
3
1 edit
highvelocity
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to CactusThomas • 8:56p, 1/19/21
AG
one of everything would be a good start
Owner of Texas Strap Company use code TEXAGS for 15% off
www.txstrapco.com

Sales Director for BCA Firearms
www.bcafirearmstx.com
Reply Quote
highvelocity
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to AnScAggie • 8:57p, 1/19/21
AG
yeah.. i like that. little pricey, but definitely seems like an excellent option
Owner of Texas Strap Company use code TEXAGS for 15% off
www.txstrapco.com

Sales Director for BCA Firearms
www.bcafirearmstx.com
Reply Quote
wtmartinaggie
User Profile Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
8:58p, 1/19/21
AG
You can put together a pretty workable system with excel in a few hours. I'd be willing to help you if you want.
Reply Quote
highvelocity
User Profile
Private Message
Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
In reply to wtmartinaggie • 9:23p, 1/19/21
AG
I have one started I'm gonna play with. What's your email? I'll send it to you for feedback
Owner of Texas Strap Company use code TEXAGS for 15% off
www.txstrapco.com

Sales Director for BCA Firearms
www.bcafirearmstx.com
Reply Quote
78_Pacecar
User Profile Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
7:21a, 1/20/21
AG
As stated earlier, if your BOM's are set you could start batch cutting the bulk rolls and then have an Ea. inventory part number. At that point a simple Kanban system would allow you to track you fast movers, as well as signal when more of a specific roll needs to be ordered.

Not sure where you're located, but I'd be willing to assist in setting something like this up. If you can set up a Kanban system then even the booger pickers off the street won't be able to mess up your inventory.
Reply Quote
jeremy360
User Profile Ignore User Stop Ignoring
How long do you want to ignore this user?
24 hours One week Permanently Cancel
7:48a, 1/20/21
Why not use a scale?
Reply Quote
Last Page
Page 1 of 3 ▼
 
×
subscribe Verify your student status
See Subscription Benefits
Trial only available to users who have never subscribed or participated in a previous trial.