I am attempting to create a spreadsheet that will tell me when to order a part in a manufacturing operation based on current inventory and usage one year ago. I have a list of the number of bottles used in each week of last year. My bottle usage is consistent year to year, but it changes at different times of the year. What I am looking for is for example; let's say that the date is July 1 and I have 5000 bottles in inventory and it takes 10 weeks to get more bottles - I need the spreadsheet to look at the listed data for weekly usage one year ago on July 1 and for the next 10 weeks. It will then look at that total number of bottles used one year ago to determine if I need to order yet. As today's date changes, It would look at the same starting date one year ago. I have numerous parts that I am looking at and they will all have different inventories and different lead times to get more stock.
Thank you for helping! This is my first post, so I apologize if I have made any errors.
Bookmarks