How would I go about figuring the weeks of supply of inventory.
I have PN's listed in a2:a10,inventory in b2:b10, weeks listed in c1:bb1, and the weekly demands of each pn are in c2:bb10. I need to know for each part what the weeks of supply are. My issue is that the week where sum of demands is great than inventory level varies based on inventory number.
any ideas?
I have PN's listed in a2:a10,inventory in b2:b10, weeks listed in c1:bb1, and the weekly demands of each pn are in c2:bb10. I need to know for each part what the weeks of supply are. My issue is that the week where sum of demands is great than inventory level varies based on inventory number.
any ideas?