Hello,
I'm trying to calculate the number of deliveries based on demands per month. The minimum order is 1,5
I want to count months where demand is higher than 1,5. If it is not I want to sum two or more months (have to one after another) and then count them too. That will give me the number of orders I have to place in a certain year.
Example below:
demand
jan.21 feb.21 mar.21 apr.21 maj.21 jun.21 jul.21 avg.21 sep.21 okt.21 nov.21 dec.21
0,5 2 2,4 0,8 1 2,3 0,9 1,2 1,2 2 0,5 1,5
minimum order Q: 1,5
No of orders: X
Thanks
Bookmarks