I face a recurrent issue where actual work done for my projects by team constantly surpasses the planned work for the same. Primary reason being scope changes that leads to inclusion of new requirements.
I'm able handle this in terms of execution but of course it eventually leads to delays in subsequent planned projects.
My question is how can I keep track of all this to monitor the risks and for presentation/evidence later in case there are questions from higher management. I'm looking for a representation/tool to record this data (planned v/s actual time) for myself and project stakeholders. Or may be if you could just share how do you keep track of this?
I'm presently planning to use graphs (in Excel) comparing planned and actual work by manually taking data but it's a bit time consuming.
PS: I'm using Microsoft Project for planning but I'm not an expert in it. The solution doesn't needs to be restricted to Microsoft Project.