Calculation

[martinainscough]

Hi All

I am calculating a stock replenishment value for a stock system. I have calcualted the required stock needed but require that this number be a multiple of a economic order qty field. Is there any fuction that can be used to calculate this figure and make sure that it would round up in every case instead of round down.

If anyone could help it would be much appreciated

Thanks

Martin

 

[KenHigg]

Can you post an example of the actual math and where the problem is, and what you need it to do?

 

[martinainscough]

I have calcualted the required stock for each product that we need to buy

For example we stock a paintbrush and want to keep 4 weeks stock and as a result we need to order 437 to keep this number of weeks stock based on average sales. However there is an economic order qty from the supplier of 36. Therefore it would be better for us to buy in 36's. the result would then be to buy 468 (13 boxes of 36).

I have the required qty and the economic order qty in a field but would like a function to calculate the final order value based on these two fields as described above.

I hope i have described this okay

Many Thanks

Martin

 

[KenHigg]

psuedo code:

orderQty(ReqQTY, EOQty)

if (ReqQTY/EOqty)-Int(ReqQTY/EOqty) <> 0 then
orderQTY = Int(ReqQTY/EOqty) + EOQty
else
orderQTY = (ReqQTY/EOqty)
end if

end function

Would this work?

 

[martinainscough]

That will do nicely!

Many Thanks

Martin