Agile Project Status Report Excel Template

Agile management is a method of managing projects that aim to provide new products or services. The management style is highly flexible, and focuses on short iterations (called “sprints”) that have one feature as a goal and usually take 2-4 weeks.

Agile Project Status Report Excel Template
Agile Project Status Report Excel Template

Some Basic Agile Concepts

  • A project is made up of any number of sprints, depending on the required features. This method is usually used on innovative short-term projects where TTM (Time to Market) is crucial.
  • Each feature entails many iterations, and the customers’ feedback is needed after each one. This process is called a “sprint”.
  • This method differs from the traditional waterfall approach in the following key areas –
  • Focuses on delivering working products / services rather than documenting the work done.
  • Frequent collaboration with the key stakeholders rather than status updates once every few weeks.
  • Constant change of the tasks rather than scope freeze.
  • Prefer communication with the stakeholders over rigid procedures.

Risk Rating Matrix
Risk Rating Matrix

KPI (Key Performance Indicator) for Agile Projects

  • Budget used (%) vs. sprint completion (%): This KPI measures the percent of budget that was utilized in order to complete the sprint versus the percent of the sprint (or the work) that was completed. The desired outcome is that the sprint completion percentage is higher than the budget spent percentage.
  • Overall remaining days vs. planned days to date: Each sprint is assigned a due date, and from this date a duration for each sprint is calculated. This KPI measures the overall days left to complete the sprint versus the overall estimated days the team think that they need in order to complete the sprint. The desired outcome is that the estimated duration is less than or equal to the remaining days.
  • Bugs to fix vs. resolved bugs: This KPI on its own doesn’t give a full picture of the status, but paired with KPI #2 it has value. It measures the overall known bugs that need to be fixed versus the ones that were fixed. Ideally the number of bugs that have yet to be resolved will diminish over time, and only a handful will be left a few days before the sprint due date.

  • Overall Earned Value (EV): The most important KPI which measures how much was earned vs. how much was spent. This is basically the bottom line. The desired outcome of course is that the cumulative earned will be higher than the cumulative spent budget.
  • Risk Matrix: This KPI measures the risks severity by multiplying the Impact of the risk should it come to fruition, by the likelihood that it will occur. The Impact and Likelihood are estimated by the team and management, and are marked between 1 (low impact and highly unlikely) to 5 (major impact and very likely). The result is a number between 1 and 25. The higher the number the more attention and mitigation it requires. The desired outcome is to move the risks from the higher number to the lower ones as the project progresses and materializes. 



Swapnil Wale

Written by

Swapnil Wale is an IT Professional based in Sydney, Australia with over 10 years of experience in technology and project management. He is a passionate blogger and focuses on project management and BRMS articles.

0 comments:

Post a Comment

 

© 2013 Techno-PM. All rights resevered. Designed by Templateism

Back To Top
Real Time Web Analytics