How to calculate the numerical characteristic of the degree of delay of tasks?

Question

Mathematics

There is a list of tasks. Each task must be completed a few days before the start of the event (for example, 10 days, 8 days, etc.). Each task has priorities 1, 2, 3, respectively, low (can be done later), medium (better done on time), high (must be done on time) and the percentage of completion for a particular activity. It is possible that tasks are not completed on time. Let's say we have the following set of tasks:

Name	A priority	...
Task_1	one	...
Task_2	one	...
Task_3	3	...

and the following task overdue situations:
Situation #1:
Task_1 priority: 1 , percentage complete: 90% , days overdue: 1
Task_2 priority: 1 , percentage complete: 90% , days overdue: 1
Task_3 priority: 3 , percentage complete: 20 % , days overdue: 1
Situation #2:
Task_1 priority: 1 , completion percentage: 20% , days overdue: 2
Task_2 priority: 1 , completion percentage: 20% , days overdue: 2
Task_3 priority:3 , percentage of completion: 90% , overdue days: 1
I.e. as a result, you need to get a numerical characteristic of the degree of delay in tasks, which would show:
1. that in situation No. 1 the state of affairs is bad, because the high priority task has a low percentage of completion and is overdue by 1 day, despite the fact that there are two low priority tasks with a high percentage of completion and a delay of 1 day.
2. that in situation No. 2 the state of affairs is still tolerable, because the high priority task has a high percentage of completion and is overdue by 1 day, despite the fact that there are two low priority tasks with a low percentage of completion and a delay of 2 days.
Tell me which way to go when calculating the numerical characteristics.

Answer 1

Move delays up, highlight in red, sort by delay in days. A 90% completed task is not done at all. The case is not closed. Dot.

Answer 2

expectedPercent Complete=(Days elapsed)*100/(totalDays/priority)
expectedDelayDays=Days-totalDays elapsed/priority
If the difference between expected and actual is >0, turn on the alert.