Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone.
I have two tables: 1) Actual Stock; 2) Demand forecast by month. As below.
I need to now:
- how long stock cover demand.
- if it's over demand
- if don't have demand
How to do this set analysis?
Thanks in advance.
Marcelo.
What is the logic to get the result column?
How do you get 3.6 for material A?
Hi
I just noticed that B result is wrong in my example. It's not 4, the right answer is 7, from July until February.
I'll edit the post to correct it.
I am still confuse. How it is from July untill Feb for material B. I can see it starts from 9/2019 which is sepatember
Considering the actual month of analysis.