This sheet displays margins between release dates and first use dates per lot, i.e. release to first usage margins.
The Gantt chart displays the margins for each lot (one box = one margin for one lot) per product (column on the left ). Selecting a lot highlights its input(s) and output(s) lot(s) and to which study it is allocated.
Hovering on a box in the Gantt gives more specific information about lots (manufacturing start and end dates, release date, release to first usage margin, minimum expiry) and studies (study, first and last demand dates, minimum remaining shelf-life).
You can filter the chart and the table per product/lot/stage and the filters apply to both. Selecting a specific lot in the Gantt chart filters the table and conversely.
This sheet can help you answer the following questions:
-
What are the inputs/outputs of a specific lot?
-
To which study is a specific lot and/or its output products allocated?
-
Could a specific lot manufacturing date be moved and by how many days, considering the manufacturing date of the next lot in the chain?