Project reporting shouldn’t be “green side up”

Following on from my post on watermelon reporting, I wanted to share another, related, phenomenon with you – “green side up” reporting. This describes the phenomenon where the health of programmes and portfolios is reported more favourably the higher up the organisation the reports are circulated; that is to say that in the project world everything looks green when viewed from above.

As with watermelon reporting, it’s not my expression but I can’t remember where I heard it.

So what are the factors that might lead to this progressive greening of status?

  • Programme Managers want to be perceived as being in control of their programmes, so although the programme may contain one or two amber or even red projects, they want to avoid the unwelcome attention of the CxOs, and so they report the programme as green overall;
  • The amber or red status of one project is diluted by the green status of other projects in the programme: if a programme comprises say ten projects, how many of these need to be amber or red before the programme overall is considered amber or red?
  • As with watermelon reporting, the problem probably really should have been reported (perhaps as amber) some time ago, and to report it as red now would expose that it wasn’t as amber reported before;
  • Also as with watermelon reporting, there’s still an opportunity to turn it around before the next report and due and then no-one will need to know anything was ever red, will they?

Leaving aside factors shared with watermelon reporting, which I have covered in a separate post, Green Side Up reporting is a Bad Idea because:

  • The organisation’s executives (CxOs) will think that everything is always green (in the same way that VIPs and Royals think that the whole world smells of fresh paint all the time!). This could mean that CxOs only become aware of problems when it is already too late to do anything about them;
  • The organisation’s executives (CxOs) will not believe the reports they are receiving.

So what are the alternatives? Here are a few possibilities:

  • The RAG status of programmes could be calculated based on some sort of average of the contents (the calculation of which only the PMO will understand, and which in any case will result in all programmes and projects being amber all the time instead of green or red, which doesn’t really help the CxOs);
  • The status of programmes and portfolios could be reported in the form of a “RAG pie”, with slices showing the proportions of red, amber and green (more accurate, but not exactly simple!);

    Pie chart showing the percentage of projects that are Red, Amber and Green
    Pie chart showing the percentage of projects that are Red, Amber and Green
  • The health status of programmes and portfolios could still be based on the assessment of the programme managers (because they are paid to manage programme-level problems), but the Portfolio PMO could add an exception reporting mechanism that exposes any red projects and provides more detail on these separately so that the CxOs can dig into this if need be.

I think the last one is probably the most practical and pragmatic. What do you think? Have you seen Green Side Up reporting? How is the health of your programmes related to the health of their constituent projects? Do you have any options to add to my list? How do your CxOs stay informed about the real health of their programmes? Let me know in the comments.

Watch out for watermelons in project reports

How do watermelons get into project reports? and why should you watch out for them?

Watch out for watermelons

“Watermelon reporting” describes the phenomenon where things appear to be green on the outside (i.e. the project’s status reports say it is green, with no issues), but if you delve a little deeper and look inside, it’s actually red right through (i.e. there are serious issues). I can’t take the credit for coining this expression but I can’t remember where I heard it either [14Jul 16 update – I’ve found a 2011 article on DZone, so it would seem that the credit for coining the phrase is due to Marc Löffler].

So what are the factors that might lead a PM to report a project as green when it’s really red?

  • It’s embarrassing for a PM to admit that “their” project is not going as well as it could/should be;
  • It increases the risk that the project will be cancelled (and we all know what happens to a PM whose projects get cancelled…);
  • The problem really should have been reported (perhaps as amber) some time ago, and to report it as red now would expose that it wasn’t reported amber before;
  • There’s still an opportunity to turn it around before the next report is due and then no-one will need to know it was ever red, will they?
  • “We don’t have red projects in this organisation” (oh yes you do!)

Looking at these reasons, you can see that most of them come from the assumption that red is a Bad Thing, and that this is the PM’s Fault – i.e. the organisation has a “blame” culture. Unfortunately, concealing red status inside a green status report is seldom a good idea, for the following reasons:

  • The sooner a problem is identified, the cheaper it is to rectify;
  • The sooner the PM escalates problems to the Sponsor, the more likely it is that the Sponsor will hear about it from the PM (rather than from another senior stakeholder with an axe to grind, for example!);
  • The sooner the Sponsor hears about the problem, the more time they have to perhaps mobilise resources to help, pave the way for a resolution, or manage the message;
  • The consequences of the concealment being discovered get worse the longer the concealment persists (and this is more a case ofwhen rather than if, a bit like when children lie to their parents)
  • If the project really is red enough to be cancelled, then doing this would be in the interests of the organisation, and no PM will win friends by keeping a bad project going longer than it should be.

Of course the PM should not be flagging every little issue and running to the sponsor every half hour (they are paid to sort most things out) but they should be flagging the project as red when any of the constraints (i.e. budget, schedule, quality, benefits) are seriously threatened, and feeling no shame in doing so.

Red should not be seen as an indicator that there is (or should be!) blood on the corporate carpet; instead red should be seen as the colour of the distress flare that the PM is effectively launching to alert stakeholders to the fact that there is trouble, and some tough decisions may need to be taken.

As a PMO, wherever I see watermelon reporting, I encourage the PM to be brave and honest enough to ask for help. Have you seen watermelon reporting? Do your project managers “keep calm and report it as green“? If so, how have you dealt with it? Let me know in the comments.

If you would like to have the benefits of an approach like this but prefer not to have to worry about this sort of stuff, why not talk to us about taking care of it all for you on your next big project or programme?

Project data in, portfolio insight out

How do you give senior management a “helicopter view” of all the change that is going on in an organisation, so that they can make informed decisions on how to spend their change budget? Here’s how I tackled it…

Data in insight out

What I found…

I came to a new Portfolio Management Office (PfMO) in which status was being reported in various formats. Reports were consolidated but this was based on low-value-add copying and pasting of information into lengthy reports. Pretty much every project proposal was being approved, with no view of the organisation’s capacity to implement them. This resulted in projects getting in each other’s way, competing for resources and overloading Subject Matter Experts (SMEs*).

The Goal

The COO tasked me with developing an integrated view of the portfolio to enable sensible prioritisation decisions to be made, and with developing a resource view looking up to one year ahead.

There was neither the appetite nor the budget to invest in a software tool, so the solution needed to be home-grown.

What I did

Standardise and integrate

I ensured that project data was being collected in a standardised way to enable automated collation into a portfolio view by developing an integrated “Project Status Workbook”. This is effectively a multi-page spreadsheet combining RAG Status reports, Risk, Issue, Dependency and Change Registers into a single recording and reporting document for each project, with a stakeholder dashboard showing key pieces of information in a simple graphical format.

Then I developed a consolidating spreadsheet, using VBA macros to collate project data in various categories.

Analyse and interpret

I analysed the data to provide management information to the Portfolio Board (e.g. % of Projects Red/Amber/Green; % of projects Delivered on Time/to Budget; Portfolio focus on Run/Grow the Business, etc.).

I charted trends to provide insight into project management effectiveness.

I introduced simple Demand Management, using a simple spreadsheet to compare resource demand (from active and proposed projects, on a FTEs per month basis) with planned supply in various categories (PMs, BAs, Developers, BAU SMEs, etc.) to enable the Portfolio Board (C-Level executives) to assess the viability of the planned project portfolio within the prevailing (tight!) resource constraints.

Whenever a new project request was received, I added in the forecast resource demand to show the effect on the “deliverability” of the portfolio as a whole.

I used a derivative of this approach when carrying out the annual financial planning exercise. This started with the annual portfolio budget figure, and showed how the projects (prioritised by the portfolio board using a weighted scoring approach covering factors such as complexity, benefits, risk, strategic alignment, etc.) chip away at the portfolio budget until it runs out at “The Cut”, beyond which lower priority projects would need to be put on hold, delayed, rejected or stopped.

I overlaid the resource view onto the financial view to see how the scheduling of the chosen projects affected the resource demand.

…and the result?

The Project Portfolio Board received a concise, consistent and informative view of Portfolio Status, and were able to consider project proposals against the context of the organisation’s capacity to implement them. Projects were better prioritised and scheduled so that difficulties related to resource bottlenecks were reduced.

So that’s my approach to generating portfolio insights, learned through the experience of getting it wrong and coming up with a better way. It this approach useful to you? Let me know in the comments.

If you would like to have the benefits of an approach like this but prefer not to have to worry about this sort of techy stuff, why not talk to us about taking care of it all for you?


*I use the term SMEs to mean people from the operational business who are subject matter experts in the processes or business areas that are to be changed. They do not necessarily contribute to the change itself or form part of the core project team, but their contribution is invaluable in shaping the changes that are made and how they are to be made.