Working on a dashboard of sorts, that essentially is a variant of 'earned v. burned'.
Goal: GIve executive management a general view into whether our overall portfolio is on track.
Calculate total of all project days elapsed, as of "today" / total of all project durations (yields a %)
Calculate total of all project actual hours worked / total of all project allocated hours (yields a %)
If % ~match, in aggregate all projects have the amount of work expended expected within the time elapsed
What does the audience think of this method and have you used other methods?
I can get the project elapsed days and durations for the first calculation.
For the second calculation, I can get actual hours. But, I'm not sure how to easily get or calculate the number of hours *allocated* (not assigned nor ETC) for all our *active* projects.
Ideas from the experts?