Kasper Devald
New Member
Hello,
I have for quite some time tried to make an excel solution that should provide an overview for a certain component, on hove many days we have on stock and what date the stock run out! This should be based on multiple products where the component is a part of and the obsolete date of the specific product.
My challenge is the obsolete date on the products and that the usage will drop over time and therefore making it very difficult for me to calculate an exact date when we have no more on stock. If we have enough on stock the cell should show “OK”.
I have attached a excel sheet that shows my question.
I hope that I have explained my challenge well enough but please write if you need additional information.
Thank you very much for your help in advance.
I have for quite some time tried to make an excel solution that should provide an overview for a certain component, on hove many days we have on stock and what date the stock run out! This should be based on multiple products where the component is a part of and the obsolete date of the specific product.
My challenge is the obsolete date on the products and that the usage will drop over time and therefore making it very difficult for me to calculate an exact date when we have no more on stock. If we have enough on stock the cell should show “OK”.
I have attached a excel sheet that shows my question.
I hope that I have explained my challenge well enough but please write if you need additional information.
Thank you very much for your help in advance.
Attachments

12.5 KB Views: 6