what you have to do is make order decisions based on the sales, stock, and delivery cycle of each item.
You are making decisions of marking orders from suppliers, and they will deliver the item next Wednesday or Friday with a certain quantity.
Basically, you need to fill up the columns in yellow. The information in the other columns is for the reference.


https://docs.google.com/spreadsheets/d/1sZUaLyxBGG9Is36qp0lXzo5s0oGS95nn/edit?usp=sharing&ouid=102692193513404980477&rtpof=true&sd=true

 

this the link above will take you to the file it open for you to edit