Maximizing Warehouse Efficiency

[excelnoob.]

Hi!

I'm new here, but I'm hoping someone can help me out...

Essentially, we want to optimize our warehouse usage by determining which line number is open for what period of time based on several date frames. For example: Line 1 has a project running from 10/5/2020-10/7/2020. Yet, another project doesn't start on line 1 until 10/20/2020 we'd like to identify that opportunity and use it to be the most efficient possible. We have 18 lines and would like to be able to identify open areas to consolidate the most efficient way possible. I've attached a snippet file we use to help aid. As you see there are several projects with several lines. Again would like to identify open lines at any given time. We have 18 production lines within our warehouse, all being used simultaneously.

I'm not sure how to attach the file we use on here but I'm open to any suggestions, it would be GREATLY appreciated.

[Logit]

.
TO attach a file, Click on GO ADVANCED, then MANAGE ATTACHMENTS.

[alansidman]

Please read the yellow banner at the top of this page on how to attach a file.