Reporting status on multiple projects

This forum is for members to share and gain knowledge of Project Management. Got a question about project management? Need help with a problem? Wish to offer tips and advice? Post here.
Post Reply
rosslyn46
New Member
New Member
Posts: 3
Joined: Thu 12 Sep 2013 3:53 pm

Hi,

I manage a team of PMs that cover 35 projects. I have to report to the board on the 35 projects each week. Does anyone have any ideas or an Excel template they could share.

Thanks
NickC
Senior Member
Senior Member
Posts: 34
Joined: Fri 09 Mar 2012 8:45 am

Quick question first of all.
Are you aware of what information your board would like to review and to what depth?

We have created several versions of a 'Project Dashboard' but the board often comment that it doesn't tell them what they need to know.
Mohamed.Benmerikhi
Expert Member
Expert Member
Posts: 57
Joined: Thu 20 Sep 2012 10:19 am
Location: France

Hi Nick,
I guess in this situation, it would depend a great deal on the type of information that the board is keen on tracking on a continuous basis. For example, if the board must report to stakeholders such as funding authorities, then perhaps more financial information should be included. So, identifying the types of information required is paramount.
Mohamed Benmerikhi
rosslyn46
New Member
New Member
Posts: 3
Joined: Thu 12 Sep 2013 3:53 pm

It would need to display:
  • Budget
  • Planned Spend to Date
  • Actual Spend to Date
  • Forecast to complete
  • Forecast Total (Actual + Forecast)
  • Variance
  • Planned Day Rate
  • Planned Spend to Date
  • Actual Spend to Date
  • Forecast to complete
  • Total (Actual + Forecast)
  • Variance
  • Efficiency based against sold day rate
Chris_R
Full Member
Full Member
Posts: 5
Joined: Tue 01 Oct 2013 11:19 am

Hi,

Since you are handling multiple projects at one time so it would be best for you to go for a project management tool as it will help you a lot not only in reporting but also in collaborating and communicating for each project. I also handle multiple projects and for it I use ProofHub, in its dashboard current status of each and every project is visible thus helping me in reporting to my clients.
Post Reply