This is topic Counting vinyl inventory in forum Letterhead/Pinstriper Talk at The Letterville BullBoard.


To visit this topic, use this URL:
http://www.letterville.com/ubb/ultimatebb.php/topic/1/62225.html

Posted by Duncan Wilkie (Member # 132) on :
 
Gack it's year end again.
There's got to be an easy way to determine approximately how many yards are left on a roll of vinyl. Has anyone made or bought a gauge that indicates approximately how much vinyl is on a roll. The cores are all standard. Obviously the thickness of the vinyl varies from vinyl to vinyl ie: cast or calendared, reflective or translucent. As long as it is within 5 yards, that would be close enough.
Depending on the diameter of the roll, that should be consistent throughout the vinyl type.
 
Posted by Dave Sherby (Member # 698) on :
 
My accountant told me not to bother with taking inventory. It's not like we have retail store amounts of inventory. We use the majority of what we buy on most projects. Even if I have a boat load of paint and vinyl, my account told me it will all come out in the end, to just take inventory when I close or sell the business. Now if you do have thousands and thousands in inventory, it might make a difference, but for a few hundred dollars worth of paint & vinyl... I don't bother. But if you really need to, just estimate it. The inventory amount is going to change drastically by the time an audit might possibly hit you.

[ December 02, 2014, 05:18 PM: Message edited by: Dave Sherby ]
 
Posted by Brad Ferguson (Member # 33) on :
 
This calculator works.

Roll Calculator

Of course, the thickness of the material would include the backing paper thickness, and also how tightly wound the roll is.

But you can take a new 50 yard roll and use the calculator to get a thickness factor. Then use the thickness in the calculator to calculate length.
 
Posted by Chuck Churchill (Member # 68) on :
 
Take a known quantity put it on a scale and note the weight (y). Take an empty core and weigh it (z). 1 yard weighs (y-z)/ known quantity. With a known ounce per yard you can figure out how many yards on a roll by weighing the roll. you will need a scale that can weigh up to 20 lbs in 10th of a lb. We rented one for a day from a scale supplier.

We use to do this every year...then we hired Dave's accountant! Now we use an educated guess for the yearly accounting.
 
Posted by Dave Grundy (Member # 103) on :
 
Duncan..My accountant told me the same thing as Dave's...Just do an honest evaluation...

I just stated the same inventory every year. (Obviously I'd be high one year and low the next....it all averages out)

Nobody is gonna throw you in jail or fine you for an error of a couple of hundred bucks of inventory.
 
Posted by Duncan Wilkie (Member # 132) on :
 
That's a clever idea Chuck. I know and educated guess is close enough, but it would be interesting to know how many yards you have on a roll just by measuring the diameter. Someone must have figured this out. Suppliers have partial rolls, and come year end they must account for this as their inventories are in the tens of thousands. I'm going to do more research, 'cause now I just have to know. [Smile]
 
Posted by old paint (Member # 549) on :
 
i worked at NAPA auto parts .....and pulling an inventory in there is a nightmare!!!!! brass fittings, furrules, washers, nuts and bolts.....was the worst!!!! like most other have said a good honest "guestamation" is all you need......its not gona be the big problem if you get audited......and that is the last thing they would......AUDIT for.

[ December 03, 2014, 02:24 PM: Message edited by: old paint ]
 
Posted by Shirley Carron (Member # 2446) on :
 
Duncan,
Why not just ask your vinyl suppliers how they calculate the amount of vinyl on a roll?
 
Posted by Kissymatina (Member # 2028) on :
 
I've seen people keep a note on the roll & as they use it, subtract it. I do something similiar, mostly so I know if I have enough for a job.
 
Posted by Rodger MacMunn (Member # 4316) on :
 
I like Kissy's method.
 
Posted by Duncan Wilkie (Member # 132) on :
 
Thanks for all the good replies. One of the girls did check with our main vinyl supplier. They gave her a complicated formula. So we did our own guideline.
This is for 2mil vinyl, but is close enough for inventory purposes.
Here's how it works.
Do not include the cardboard core in measuring as the thickness of these varies considerably.
Measure the thickness of the vinyl on the roll only. Disclaimer, this is not scientifically tested, and rounded to the nearest 1/8" but good enough for this purpose. If you want accurate call Sheldon Cooper from BBTheory.
1" = 50Yd, 7/8" = 40Yd, 5/8" = 30Yd, 1/2" = 20Yd, 1/8" = 5Yd.
 


Powered by Infopop Corporation
UBB.classic™ 6.7.2