Hi,
I need to calculate a backlog for per product per day.
I have a module with Factory open days and closed days and a module with lead times by product.
Volume gets sent to production (factory) and then I need to take a lead time calc for the products.
The trick is that to work out how many future days in a row the factory is open (these can change depending if the factory open boolean is ticked) to see when the product will get produced and by equal to or more than the lead times.
E.g: the factory could be open Monday Thursday Friday. If the volume came in on Monday (with a 3 day lead time) then the backlog would get recognised on the Friday. The lead times and the factory open days can differ. Also the lead times can cross over days, weeks, months and years.
I have booleans for open days per factory and a count for the days open.
I also have lead times by month by product.
Hope this enough information?
Adrian