Thread: Calculating number of labels left on a reel

1. Calculating number of labels left on a reel

I have had a look on the forums and couldn't find this question answered in a way i understood. I apologise in advance it is a repeat question.

At work we use reels of wine labels in a production environment. Every reel has a different starting quantity (fresh out of the box) and different labels have different width,height...

The problem we have is estimating the quantity of labels left on each reel once production has used some of them.

I understand the VERY BASICS of what i need to do but have been unable to find a formula that works this far.

SO as i understand it i need to know:

diameter of the core
diameter of the reel
width of the label
width of the space between each label
thickness of the label and backing paper combined

Any help would be greatly appreciated, my math skills are limited so simplicity would be great.
and if the was a formula available that could be used in execl it would make my life a whole lot easier.
Many Thanks

2. Re: Calculating number of labels left on a reel

Circumference of first layer pi*(diameter of core)
Circumference of 2nd layer pi*(diameter of core + 2 thickness of label and backing)
Circumference of 3nd layer pi*(diameter of core + 4 thickness of label and backing)
etc.

Add up a bunch and see what happens.

3. Re: Calculating number of labels left on a reel

if you want a simple and easy to understand formula, you may find it easier to weigh the reels, subtract the weight of the core (i assume this is constant for all reels), and divide by the weight of 1 sticker (and its backing, allowing for the distance between stickers on one end).

although you probably dont have scales accurate enough to weigh one sticker, you could estimate the value by weighing a known number (say 1000) and dividing the answer appropriately. or you can calculate it from the starting quantity on a real fresh out of the box.

4. Re: Calculating number of labels left on a reel

Originally Posted by SpringFan25
if you want a simple and easy to understand formula, you may find it easier to weigh the reels, subtract the weight of the core (i assume this is constant for all reels), and divide by the weight of 1 sticker (and its backing, allowing for the distance between stickers on one end).

although you probably dont have scales accurate enough to weigh one sticker, you could estimate the value by weighing a known number (say 1000) and dividing the answer appropriately.
i can see this been a good idea for a few reel but the problem is we r using maybe upto 20 reels a day and would require something a bit quicker, once perfected of course

5. Re: Calculating number of labels left on a reel

Calculate Number of Laps, n

$\displaystyle n = \frac{DiameterOfReel - DiameterOfCore}{2\cdot (ThicknessOfLabelAndBacking)} + 1$

Calculate Total Length Wrapped around the core, TL

$\displaystyle TL = \pi\cdot n \cdot \left[(DiameterOfReel) + ((ThicknessOfLabelAndBacking)\cdot(n - 1))\right]$

Calculate Number of Labels

$\displaystyle \frac{TL}{(LabelLength) + (SpaceBetweenLabels)}$

Measure the reel diameter conservatively and you should be close. Depending on the stiffness of your backing, there is another small tweak.

Disclaimer: I did not spend a whole lot of time checking this out. I didn't make any mistakes on purpose, but I'd check it out before I relied on it for business purposes. Remember, you get what you pay for!