Skip to Content
0
Former Member
Apr 20, 2010 at 08:59 PM

Logic for calculating Handling Unit qty

311 Views

Hi all,'

I ahve to calulate the value for a fied "Handling Unit quantity" based on the foll formula:

No of handling Units = No of labels

No of labels calculated as follows: Item Quanity/Starp quantity

e,g, 5/3 = 1.67 (rounded to next no) i.e. "2".

Now No of Handling units for the above example would be 2.Hence Qty for handling Unit 1 would 2 and handling Unit 2 would be "3".

Similarly if no oflabels is calculated as follows:

e.g. 10/3 = 3.33 (rounded to next no) so "4".

So # of handlng units will be 4 and ratio for the quanityies would be 3:3:3:1.

However im not able to develop a logic so tha I can obtain the quanities for each of the handling units.can someone help me ?

Thanks.