I have a dataset (attached) of suppliers and components that gives me a current picture of my Production status for a part and supplier by week. I want to dynamically calculate how many parts will be needed to meet the target inventory, this is the QUANTITY TO MEET TARGET Column
The way the target works is a week is equal to 5 days; therefore, if I have a negative PARTS AVAILABLE at the week of my TARGET INVENTORY, then my target is not met. To calculate the QUANTITY TO MEET INVENTORY column, I just need to check how many parts are in negative at the WEEK NUMBER of my TARGET INVENTORY or check the ORDER column for the target value and see how many parts are negative
THE CURRENT COVER Column just shows how many weeks of cover I have based on my PARTS available column and it is calculated by checking the weeks that we have positive PARTS available
THE TARGET INVENTORY column is the target of days I am trying to meet and 1 week = 5 days
COMPLIANCE column is a column that shows my compliance against the target inventory days which is calculated by subtracting the CURRENT COVER from the TARGET INVENTORY
QUANTITY TO MEET TARGET- How many parts will needed to meet my target and I need to calculate it dynamically
