Hello,
I have a little issue in order to calculate if the stock is covered or not for the next order(purchase).
In the Excel sheet attached.
Column A are the references.
Column B is the stock level
Column C are the next order (purchase) coming for the next 3 hours.
Column D should be my % of coverage.
I 'm lost in the calculation
the first expression is to sum the stock column B, the second to sum the next order column C.
the third expression in column D is to calculate the coverage pourcentage. This doen't work.
If my stock is higher than the order, I should see 100% because I'm cover.
My orders have a lead time of 4 hours. Nice to have if possible the coverage per hours .
the data with the hours received are in a different table (join in the discussion too)
thanks you so much
Regards
Fab