posted
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
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 ]
-------------------- Dave Sherby "Sandman" SherWood Sign & Graphic Design Crystal Falls, MI 49920 906-875-6201 sherwoodsign@sbcglobal.net Posts: 5396 | From: Crystal Falls, MI USA | Registered: Apr 1999
| IP: Logged |
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.
-------------------- Brad Ferguson See More Signs 7931 Wornall Rd Kansas City, MO 64111 signbrad@yahoo.com 816-739-7316 Posts: 1230 | From: Kansas City, MO, USA | Registered: Nov 1998
| IP: Logged |
posted
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.
-------------------- Chuck Churchill, It's A Good Sign Inc. 3245 Harvester Rd, U-12 Burlington, Ont. Phone: 905-681-8775 Fax: 905-681-8945 Posts: 633 | From: Burlington, Ontario, Canada | Registered: Nov 1998
| IP: Logged |
posted
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.
-------------------- Dave Grundy retired in Chelem,Yucatan,Mexico/Hensall,Ontario,Canada 1-519-262-3651 Canada 011-52-1-999-102-2923 Mexico cell 1-226-785-8957 Canada/Mexico home
posted
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.
posted
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 ]
-------------------- joe pribish-A SIGN MINT 2811 longleaf Dr. pensacola, fl 32526 850-637-1519 BEWARE THE TRUTH.....YOU MAY NOT LIKE WHAT YOU FIND Posts: 11582 | From: pensacola, fl. usa | Registered: Nov 1998
| IP: Logged |
posted
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.
![[Smile]](smile.gif)
Printer-friendly view of this topic