G
Guest
Hi,
I'm trying to create a formula based on a minium order qty (MOQ)
for example cell a1 would have the MOQ figure, b1 would have an opening
stock figure, c1, d1, & e1 would have forecast figures.
I would like it to calculate an order figure based on the 3 forecasts, minus
the current stock holding and rounding it based on the moq
Hope thats clear !!!!!
Thanks very much in advance
Dave
I'm trying to create a formula based on a minium order qty (MOQ)
for example cell a1 would have the MOQ figure, b1 would have an opening
stock figure, c1, d1, & e1 would have forecast figures.
I would like it to calculate an order figure based on the 3 forecasts, minus
the current stock holding and rounding it based on the moq
Hope thats clear !!!!!
Thanks very much in advance
Dave