How Late Is That Task
Autor: Joshua • February 16, 2018 • 1,484 Words (6 Pages) • 408 Views
...
The following equation is used for determining how much work should have been completed and is delineated by the status. If the task is complete then this is equal to actual work. If the task is on schedule, then the number of days the task has been active divided by the duration and multiplied by the work is calculated to determine how much work should have been accomplished. The derivation of the equation discounts future work. If the task is not complete and the task’s finish date is prior to the status date, then this is equal to the planned work. If the task is not complete and the task’s finish date is after the status date, the same calculation for when the task is on schedule is performed.
If Status is Complete then
Expected_Completed_Work = Actual_Work
else if Status is On Schedule then
Expected_Completed_Work = (Status_Date - Start_Date) / Duration * Work
else if Status is Future then
Expected_Completed_Work = 0
else if Finish_Date is before Status_Date and not Complete then
Expected_Completed_Work = Planned_Work
else if Finish Date is after Status Date and not Complete then
Expected_Completed_Work = (Status_Date - Start_Date) / Duration * Work
The next equation is how much work should be remaining.
Expected_Remaining_Work = Work – Expected_Completed_Work
The last equation is if there is remaining work, then the difference between how much work should have been accomplished and how much work was actually accomplished.
If Remaining_Work then
Work_Lag = Expected_Completed_Work – Actual_Work
The schedule example below uses these equations with the Status Date of 08/02/2016. Summarizing, the overall the project is ~798 hours behind schedule equating to 5.43 person-months behind schedule. This is based upon 7.0 hours per day and 21 days per month equating to 147 hours/month for resource work. Note that Task B work delta is -15.11 hours which signifies that specific task is ahead of schedule.
1
2
3
4
5
6
7
8
9
10
11
12
Task
Duration
% Work Comp
Actual Work
Work
Remaining Work
Status
Start
Finish
How many hours should be accomplished.
How many hours should remain.
Work Delta (col10-col4)
A
20 d
100 %
288 h
288 h
0 h
Complete
5/1/16
5/29/16
288 h
0 h
0 h
B
195 d
99 %
99 h
100 h
1 h
On Sched
12/10/15
09/16/16
83.89 h
16.11 h
-15.11 h
C
35 d
0%
0 h
756 h
756 h
Late
7/5/16
8/23/16
442.35 h
313.65 h
442.35 h
D
169 d
10%
80 h
800 h
720 h
Late
5/2/16
12/29/16
309.83 h
490.17 h
229.83 h
E
47 d
30%
203.03 h
676.8 h
473.77 h
Late
6/29/16
9/2/16
344.3 h
332.5 h
141.27 h
F
7 d
...