How Project Progress is Calculated
Project managers use the Progress infolet from the Project Management Dashboard to compare the target and actual percentage of work completed on the projects they own.
Projects with maximum variance between actual and target percent complete appear topmost. Projects with same variance between actual and target percent complete are sorted in the reverse order of number of exceptions. If no effort is planned for a project, then the infolet displays zero percent complete. As soon as the team members start entering progress for tasks, the actual percent is calculated. From the Progress infolet, you can drill down to the Manage Project Plan and Manage Task Exceptions pages to view the details.
Settings That Affect Project Progress
Values in the Progress infolet are derived from the Manage Project Plan page. The project progress depends on the following values of a project:
-
Current date
-
Planned start date
-
Planned finish date
-
Planned effort in hours
-
Current effort in hours
-
Actual hours
Formulas to Calculate Project Progress
Here are the formulas to calculate the target and actual percent complete of a project:
-
target percent complete = (expected hours / planned effort in hours) * 100
-
expected hours = (expected duration * planned effort in hours) / planned duration
-
expected duration = current date - planned start date + 1
-
planned duration = planned finish date - planned start date + 1
-
-
actual percent complete = (actual hours / current effort in hours) * 100
Note: The actual percent complete is the rolled up percent complete of the project.
This table shows the values used to calculate target and actual percent complete for Project 1. Assume the current date is 2-Jun-2017, the calendar is 5 days a week with no holidays, and a workday contains 8 hours.
|
Name |
Planned Effort in Days |
Planned Start Date |
Planned Finish Date |
Planned Effort in Hours |
Actual Hours |
Remaining Hours |
Current Effort in Hours |
Expected Hours |
|---|---|---|---|---|---|---|---|---|
|
Project 1 |
57 |
22-May-2017 |
30-Jun-2017 |
456 |
120 |
336 |
456 |
160 |
|
Task 1 |
10 |
22-May-2017 |
02-Jun-2017 |
80 |
40 |
40 |
80 |
(10 * 80) / 10 = 80 |
|
Task 2 |
7 |
01-Jun-2017 |
09-Jun-2017 |
56 |
16 |
40 |
56 |
(2 * 56) / 7 = 16 |
|
Task 3 |
20 |
05-Jun-2017 |
30-Jun-2017 |
160 |
0 |
160 |
160 |
0 |
|
Task 4 |
20 |
24-May-2017 |
20-Jun-2017 |
160 |
64 |
96 |
160 |
(8 * 160) / 20 = 64 |
This table shows the values used to calculate target and actual percent complete for Project 2. Assume the current date is 2-Jun-2017, the calendar is 5 days a week with no holidays, and a workday contains 8 hours.
|
Name |
Planned Effort in Days |
Planned Start Date |
Planned Finish Date |
Planned Effort in Hours |
Actual Hours |
Remaining Hours |
Current Effort in Hours |
Expected Hours |
|---|---|---|---|---|---|---|---|---|
|
Project 2 |
16 |
29-May-2017 |
14-Jun-2017 |
128 |
48 |
72 |
128 |
48 |
|
Task 1 |
5 |
29-May-2017 |
02-Jun-2017 |
40 |
40 |
0 |
40 |
(5 * 40) / 5 = 40 |
|
Task 2 |
3 |
02-Jun-2017 |
06-Jun-2017 |
24 |
8 |
16 |
24 |
(1 * 24) / 3 = 8 |
|
Task 3 |
8 |
05-Jun-2017 |
14-Jun-2017 |
64 |
0 |
64 |
64 |
0 |
The project progress is determined as follows:
-
If target percent complete is greater than actual percent complete then your project is behind schedule.
-
If target percent complete is less than actual percent complete then your project is ahead of schedule.
-
If target percent complete is equal to actual percent complete then your project is on schedule.
This table shows the calculation of target percent complete and actual percent complete for Project 1 and Project 2 and their progress results. For Project 1, the planned and current effort are same. For Project 2, the current effort is less than the planned effort.
|
Project |
Expected Hours |
Actual Hours |
Target Percent Complete |
Actual Percent Complete |
Progress |
|---|---|---|---|---|---|
|
Project 1 |
160 |
120 |
(160 / 456) * 100 = 35 |
(120 / 456) * 100 = 26 |
9 percent behind schedule |
|
Project 2 |
48 |
48 |
(48 / 128) * 100 = 37.5 |
(48 / 128) * 100 = 37.5 |
On schedule |