Great tool, one question though, how to apply this on multiple SKUs, like 150 SKUs or products, the formulas are pretty locked to this range and must be changed one by one if applying on an array of SKUs!
Hey, I gave a try and couldn't make it that elastic because I'm lacking an extra dimension on the sheet to pack cumulative sales per item and week into one cell. What you can do though is to choose how many weeks before your stock ends you want to be notified. I'm sending you a link to such spreadsheet which is set for 5 weeks but you can obviously change that - this value is stored in 'Cumulative Sales X weeks' BC1 cell. The same logic if you wish to work on quantity instead of value. drive.google.com/file/d/1kgD6AhdnKCpfM_89AjGWm2m1qfG9oDmN/view?usp=sharing
Slawomir - this was an incredibly helpful video, both as it allowed for me to solve a current business problem and because through the video I've learned how to apply array formulas and the offset formula. Well done, friend, and thank you!
GREAT VIDEO. I have a question. What happens when the Inventory doesn't even reach the first month and the forward cover is "0". I tried it and the formula gives me #REF
Great tool Slawomir. I have just one question: If you have no sales in a few weeks ahead, and your stock reaches 0 in the meantime, the formula will count the weeks with no sales as 1 until sales happen again. Basically saying that your stock coverage is highe than the reality. Is there a way to overcome this in the formula?
As I'm looking into this over 3 years from recording this video I see it crashes when sales next week are greater than closing stock. This is just a basic concept that I wanted to make comprehensive as for the video because actually figuring this out took me months back then. We should build these formulas up with conditionals: IFs, IFERRORs to make them behave the right way in exceptions. I'm really happy that you found these bugs and invite you to craft the tool for your needs!
Unfortunately not. I am sure you'll find good guides elsewhere. Basically look at past data and overall trends but this subject deserves a longer speech! Thanks for the feedback!
Hello, great video thank you for posting! I have an exercise with stock coverage in Excel but I have some questions. I was wondering if you can help me out!:)
Great tool, one question though, how to apply this on multiple SKUs, like 150 SKUs or products, the formulas are pretty locked to this range and must be changed one by one if applying on an array of SKUs!
Hey, I gave a try and couldn't make it that elastic because I'm lacking an extra dimension on the sheet to pack cumulative sales per item and week into one cell. What you can do though is to choose how many weeks before your stock ends you want to be notified. I'm sending you a link to such spreadsheet which is set for 5 weeks but you can obviously change that - this value is stored in 'Cumulative Sales X weeks' BC1 cell. The same logic if you wish to work on quantity instead of value.
drive.google.com/file/d/1kgD6AhdnKCpfM_89AjGWm2m1qfG9oDmN/view?usp=sharing
Slawomir - this was an incredibly helpful video, both as it allowed for me to solve a current business problem and because through the video I've learned how to apply array formulas and the offset formula. Well done, friend, and thank you!
You're very welcome! I'm glad it helped :)
Thanks so much for this video! It helped me address a real business problem.
Great Video. It really helped me a lot. THANK YOU
thanks man!! very good explaining!!!
Super video! Thanks!
GREAT VIDEO.
I have a question. What happens when the Inventory doesn't even reach the first month and the forward cover is "0".
I tried it and the formula gives me #REF
Great tool Slawomir. I have just one question: If you have no sales in a few weeks ahead, and your stock reaches 0 in the meantime, the formula will count the weeks with no sales as 1 until sales happen again. Basically saying that your stock coverage is highe than the reality. Is there a way to overcome this in the formula?
As I'm looking into this over 3 years from recording this video I see it crashes when sales next week are greater than closing stock. This is just a basic concept that I wanted to make comprehensive as for the video because actually figuring this out took me months back then. We should build these formulas up with conditionals: IFs, IFERRORs to make them behave the right way in exceptions. I'm really happy that you found these bugs and invite you to craft the tool for your needs!
Excellent design.
Absolute love this video!!!! wow. Do you have a video on how to forecast?
Unfortunately not. I am sure you'll find good guides elsewhere. Basically look at past data and overall trends but this subject deserves a longer speech! Thanks for the feedback!
@@sawomirwojtas7428 Thanks! Just thought I'd try my luck. 🙂🙃
Thank you!
I watched this because I have an interview today for a retail chain
Good luck buddy!
Hello, great video thank you for posting! I have an exercise with stock coverage in Excel but I have some questions. I was wondering if you can help me out!:)
Thank you, I can try :) Please reach out to me directly using the email address from information card on my RUclips profile