Hello Everyone Can EArned Value be caluclated for Manhours and Then can we forecast the expected manhours to complete. I made a table to put those thing to get a forecasted manhours which is based on Productivity which is same as CPI. Please comment and let me know your ideas to make it better,
I have put an example by putting Project Managers to Claculate the Forecast at completion.
And please do let us know if there are other ways too.
If the above one is not Clear as it is from Excel here is the cut and paste but without the shades below,
| C = A X B | F = D X E | J = A X H | K = J / D | L = N - D | M = L X E | N = A / K | P = N X E | Q = J - D | R = A - N | |||||||
| Discipline | Budget | Actual | G - Planned % | H - Actual % | J - Earned Man-hours | K - Productivity | Forecasted | Forecasted Total | Variance | |||||||
| A - Man-hours | B - Unit Rate | C - Total Cost | D - Man-hours | E - Unit Rate | F - Total Cost | L - Man-hours | M - Cost | N - Man-hours | P - Cost | Q - Till to date | R - Overall | |||||
| Project Manager | 100 | 6 | 600 | 18 | 6 | 108 | 20.0% | 15.0% | 15.00 | 0.83 | 102 | 120 | -3.00 | -20 | ||
Regards
Jithin