Kasper Devald
New Member
Hi all,
I have an excel sheet that help us calculate hove many days we have on stock for a specific component and return the date we run out of stock. The calculation contains the current stock level, different phase out day for for each product the specific component is a part of and usage per day for each product.
I have attached a small sample of the calculation i use. My question is if it's possible to incorporate all the "End of stock" calculations I have marked in one formula?
I hope you can help ;-)
BR Kasper
I have an excel sheet that help us calculate hove many days we have on stock for a specific component and return the date we run out of stock. The calculation contains the current stock level, different phase out day for for each product the specific component is a part of and usage per day for each product.
I have attached a small sample of the calculation i use. My question is if it's possible to incorporate all the "End of stock" calculations I have marked in one formula?
I hope you can help ;-)
BR Kasper