Sunday, July 14, 2024

Building and Using A Practical Portfolio Benefits-Realization Plan with MS Project (Part - 2)


In the earlier part, we understood the fundamentals and importance of a Portfolio Benefits-Realization Plan. We also took a number of steps to build this plan. In this part, we will conclude and give a finishing touch to the plan, followed-up with a video and concluding remarks.

This series: Part – 1

Step – 6: Segregation of Components and Strategic Objectives

As the portfolio components are all blue color-coded, the distinction among components in the graphical side of the plan is not very clearclear. Hence, our next step is to segregate the components with the help of additional custom fields. For our plan, we will have three Boolean custom fields:

  • IsProgram: A Boolean flag indicating the component is a program.
  • IsOps: A Boolean flag indicating the component is an operation.
  • IsStrObj: A Boolean flag indicating the organizational strategic objective. 

Again, to create these custom fields, go to Gantt Chart Tools > Format tab > Columns group > Custom Fields command and add three Boolean flags as shown below. 

Next, we need have to change the conditions associated with these three flags. Whenever a new portfolio component or a new strategic objective is added, the respective bar in the Gantt Chart view will display the requisite color.  For this, go to Gantt Chart tools > Bar Styles group > Format drop down menu and choose the Bar Styles command. We will add the following tasks with respective conditions:

  • Program Task: N It’ll be a normal, active task with the ‘isProgram’ flag applied.
  • Ops Task: NIt’ll be a normal, active task with the ‘isOps’ flag applied.
  • Strategic Obj task: NIt’ll be a normal, active task with the ‘isStrObj’ flag applied.

To add these new tasks, simply use the functionalities available in the Bar Styles dialog box such as Insert Row, Cut Row, and Paste Row.  

As shown above, we have four task types, including the default task type for the component projects represented with a blue bar.

Next, we willhave to apply them in the Gantt Chart view in the following manner:

  • Set ‘isProgram’ field “Yes” for the component programs.
  • Set ‘isOps’ field “Yes” for the component operations.
  • Set isStrObj’ field “Yes” for the strategic objectives.

When you have all the respective fields set for the component projects, programs, operations as well as the strategic objectives, we will have the following view.  

As shown, the component programs (e.g., Program 1), component projects (e.g., Project 3), and component operations (e.g., Operational Work 1) are shown in green, blue, orange colors, respectively. On the other hand, the strategy and objective (e.g., Organizational Strategy and Objective I) is shown with red color coding.

As you present this bBenefits-realization plan or share with your stakeholders, you may want to just show the minimal fields. Additionally, based on your need, you can also add the component names in the graphical side of the Gantt Chart view. This is depicted in the below figure. 

As shown above, we now have complete Portfolio Benefits Realization as documented in PMI’s Standard for Portfolio Management. If you have business proposals (or cases) as another portfolio component class, you can exactly follow the same previous steps with a new custom Boolean flag, conditions,  and a separate color.

Video – Demonstration of Portfolio Benefits-Realization Plan 
*** NEW ***

I’ve put together a video depicting a portfolio benefits-realization plan. In addition, I've some more explanation with respect to this plan. My video [duration: 4m:26s] shows all the components in the plan, which we recently learned in the article. They are demonstrated with different color coding for the individual components.



Conclusion

Finally, you might be wondering,  can someone add the benefits accrued from the components into the portfolio benefits-realization plan? 

Yes, you can! But do ensure the linking and dependencies are properly managed. 

However, the PMI-SPfM puts the portfolio components, benefits, and strategic objectives, along with the benefits realization based on schedule and number of other parameters in a separate portfolio report called portfolio performance variance report. As you manage your portfolios, along with key deliverables such as portfolio roadmap, portfolio reports play a significant role. Hence, while doing portfolio management and sharing the status with your stakeholders, you can use both the portfolio benefits-realization plan and the portfolio performance variance report.

Many perceive and/or believe that MS Project software tool can’t be used to create a Portfolio Benefits-Realization Plan! As we just learned, you can certainlydefinitely build one and dynamically change the plan as per your needs. 

This series is concluded. I welcome your thoughts, reviews, and feedback in the comment section below.

This series: Part – 1

--

This article was first published by MPUG.com on 5th December, 2023. The current one has been updated with content and video.


References

[1] NEW Book - I Want To Be A PfMP, The Plain and Simple Way, by Satya Narayan Dash

[2] Article – Benefits Realization Management for Projects, by Satya Narayan Dash

[3] The Standard for Portfolio Management, by Project Management Institute (PMI)



Friday, July 05, 2024

Building and Using A Practical Portfolio Benefits-Realization Plan with MS Project (Part - 1)


Bugs smell, features tell, benefits sell.

-    From the book, I Want To Be A PfMP, the Plain and Simple Way

Portfolios fundamentally exist in an organization to achieve organizational strategies and objectives. One or more strategic objectives of an organization flow into the portfolio strategic plan. After the identification, categorization, evaluation, prioritization, and authorization of portfolio components, their execution begins and benefits are delivered. This, which in turn, helps in achieving the organization’s strategic objectives.

But then following questions come -up:

  • How do you ensure strategies are fulfilled in order to meet the strategic goals?
  • How do you find out that the portfolio components authorized earlier are actually delivering the benefits?
  • How to plan for, measure, and monitor the organization’s (business) value achievement?

The answers to above questions lie with portfolio benefits management. The Standard for Portfolio Management (SPfM®), clubs benefit management under Portfolio Performance Management. Benefits and their subsequent realization are extremely important in portfolio management. And as the opening quote tells, it's only benefit that sells! 

In this article, we will understand portfolio benefits, the benefits dependency map, and above all, how to build a benefits-realization plan with the MS Project software tool. The portfolio benefits-realization plan will be based on the template provided by SPfM from Project Management Institute (PMI®).

This series: Part – 2

Portfolio Benefits

Portfolio benefits are first identified during the definition stage of the portfolio and documented in the portfolio strategic plan (PfSP). These benefits will flow into the Portfolio Performance Management Plan (PfPMP) and are documented in the Benefits Realization section of the PfPMP. 

Benefits can be qualitative or quantitative, tangible or intangible, financial or non-financial, short- or long-term. Irrespective of the type of portfolio benefits, they need to be clearly defined and documented in the PfPMP.

The portfolio benefits actually come from the portfolio components. These benefits are aggregated at the portfolio level. The benefits in turn help achieve the strategic objectives of the organization. To understand it graphically, you need to be aware of another fundamental concept, the benefits dependency map (BDM).

Benefits Dependency Map

A simplified benefits dependency map is shown below.  

As shown in the above BDM, moving from left to right of the map, we have organizational vision (and mission) translated to strategic objectives. These objectives, in turn, translate to benefits, and then to outcome to outputs (or results). In other words, moving from left to right we are asking – “How the strategic objectives are finally executed to give results/outcomes/output”? On the other hand, moving from right to left we are asking – “Why this portfolio component (e.g., project), which is giving this result (or service or product) is undertaken in the first place?” 

As you can see, we are moving from strategic objectives at the level of portfolio to benefits at the level of portfolio components. With these fundamentals, let’s see how to build the benefits-realization plan. 

A Practical Benefits-realization plan

We will take a step-by-step approach to build the Portfolio Benefits-realization plan with MS Project software. Along the way, we will do a few customizations and apply them to the software tool. 

Step – 1: Add A ‘Portfolio’ Custom Field 

To add a custom fieldle, go to Gantt Chart Tools > Format tab > Columns group > Custom Fields command and add a Text custom field “Portfolio”. Under this custom field we will have various portfolios undertaken by the portfolio manager. 

Next, add three portfolios under this custom field – Portfolio I, Portfolio II and Portfolio III. For each portfolio we will have a number of components and we will add them shortly.  

Step – 2: Rename ‘Task Name’ Column to ‘Portfolio Component’ *** UPIDATED ***

Before adding the components, rename the Task Name the column to Portfolio Components. This can be done by right clicking on the Task Name column and choosing Field Settings option.

When you have both the Portfolio custom field showing having the above three portfolios and the renamed column of Portfolio Component, you will have the following figure. 

For the time being, do not worry about the start and finish dates for the portfolios. Abecause after we add the portfolio components and strategic objectives, we will get those dates. 

Step – 3: Add the Portfolio Components and Strategic Objectives

In our next step, we will add the portfolio components and the strategic business objectives, which will be met when the benefits delivered by portfolio components are realized. 

To add the portfolio components, fyou just have to fill -up the line entries under the Portfolio Components column with respective component projects, programs, operations, and strategic objectives. This is very much like adding the task names in a normal MS Project plan. After you add the entries, you will have the following plan.    


This is the first -cut of our Portfolio Benefits-Rrealization Pplan, which we are going to refine as we proceed. As shown above, for Portfolio I:

  • There are three component projects - Project 1, Project 2, and Project 3 - and also Component Program 1.
  • Organizational Strategy and Objective I will succeed the completion of the project and program components. 

Similarly, we have components, including operations, for other portfolios such as Portfolio II and Portfolio III in the evolving plan. 

Step – 4 (mini one): Ensure Proper Timescale

Did you notice on the right side of the above figure that the timescale has changed?! This is important because, without proper timescale adjustment, you won’t be able to visualize the long running portfolio components such as a program or a long-term project. 

In our case, I’ve used the below timescale customization.  

As shown above, we have:

  • Two tiers – Middle Tier and Bottom Tier.
  • For the middle tier, Units used is Years, whereas for the Bottom Tier, Units used is Quarter.
  • The Preview is shown belowbelow, and the exact same view is available in the previous figure.

Step – 5: Build the Dependencies

Now that we have the right time-scaling, we must ensure the dependencies between the portfolio components and the strategic objectives which will be met when they are complete. 

After you add the dependencies, the view will come as shown below. For an in-depthTo understanding of know in-details about dependencies, lead, and lag, , you can use this course.

 
Interpreting the above figure and dependencies, one can say:
  • Component Program 1 has finish-to-finish (FF) dependency with Component Project 1 and Component Project 2. 
  • Organizational Strategy and Objective I has FF dependency with Component Project 3 and Component Program 1. 
  • Organizational Strategy and Objective I also has FF dependency with Component Project 3 and Component Program 1.
In other words, you can say that Organizational Strategy and Objective I will be achieved when component Project 1, Project 2, Project 3, and Program 1 are completed and associated benefits are realized. This is important to understand.

Similarly, as you can see in the above plan, other organizational strategic objectives are associated with other portfolio component projects, programs,  and operations.

In the next part, we will follow few more steps such as seggregating the components based on their classes or categories. We will conclude with a video demonstration.

This series: Part – 2





Wednesday, June 26, 2024

Practical Risk Management with Primavera Risk Analysis – Working with An Oil and Gas Industry Project


The Practical RMP with Primavera Risk Analysis course is used by risk management practitioners around the world, including PhD candidates pursuing their doctorates. Professionals from construction, software, EPC (engineering, procurement and construction), space and other industries use this course.

Currently, I received questions on its usage on in the oil and gas (O&G) industry. The question is on practical applicability in that industry. The Practical RMP course is industry transparent and uses its own project and builds-up step-by-step from risk planning, identification to risk monitoring and tracking. Along with the theory, you will learn to do risk management in a practical, hands-on manner. The later part, hands-on, is crucial. Above all, you can apply your learning in any industry.

Coming to the Oil and Gas industry, the Practical RMP course can be used and the risk management concepts can definitely be applied. For this article, I’m going to take a sample risk management plan. This is a .plan file as called in Primavera Risk Analysis (PRA) software tool. 

The .PLAN file

This plan is taken from the provided sample plans available in PRA tool. When imported to the software, it pops-up a message about cost uncertainty in this oil and gas project. 

Uncertainties can come in various ways:

  • Duration uncertainty
  • Cost uncertainty
  • Network uncertainty, among others.

You can learn more on these uncertainties in this article. All these uncertainties can be modelled

Analyzing the .PLAN file 

Now that we have imported this file, we need to have a quick look on the plan, which is shown below. 

As shown:

  • We have a number of activities under the heading “A” such as Civils, Buildings, Structural Steel & Painting, Mechanical Equipment Supply etc.
  • Each of these activities have the cost shown – minimum fixed cost, maximum fixed cost and most likely fixed cost.
  • For example, the ‘Structural Steel & Painting’ activity has minimum fixed cost of $900,000, maximum fixed cost of $1,100,000 and most likely fixed cost of $1,300,000.

The resources are fixed cost for these activities and the cost uncertainty has been shown for each. The default probability distribution has been used for them. 

The overall project statistics is shown below. This is can be seen by going to Plan menu > Plan Information … > Statistics tab.  


As you can see, the total planned cost is $19.123 M (million) and the planned finish is 31 October, 2025. I’ve changed the date of the plan. Also, you would have noticed that there are 7 resources, in total, for this cost plan.

Risks as Part of the .PLAN file

This plan is somewhat different compared to the other sample plans available. This is because the risks are added as part of this cost plan

The risks have probabilities associated, along with modelling numbers. This is because only risk can have uncertainties as they are in the future and they are uncertain. Activities are planned and will be executed. But they do have uncertainties and hence the modelling.

The risks associated with this cost plan along with the probabilities are shown in the below figure. 

As shown above three risks are directly plan of the plan, not the risk register! There are:

  • Material supply problems with 10% chance.
  • Key personal availability with 25% chance.
  • Design complexity underestimated with 20% chance.

In addition, each of these risks has minimum, most likely and maximum fixed cost. 

Running the Cost Analysis

Next, with this available plan (I’ve made some changes), we will run the risk analysis with respect to cost. This can be done by going to Risk menu > Run Risk Analysis … option. We will use the default parameters while going through analysis and will use the Monte Carlo simulation.

Post analysis, the Latin-Hypercube simulation (a modified version of Monte Carlo), we have the following representation.  

Analyzing the above report, one can say the following:

  • The chance of meeting the estimated planned budget of $19.123 is hardly 11%.
  • To have a 50% chance the budget has to go up and it has to be $19,679 M. In order to have 100% chance, the budget has to be $22, 249 M.
  • Do note that the risks are included in the analysis and they are also impacting the final cost.

Conclusion

As we just learned, any kind of O&G project can be used for risk analysis using the Primavera Risk Analysis software tool. This is a special and advanced project with only the cost aspects. For duration too, the PRA software can be used.

You need not have any apprehension about it. If you are keen to learn detailed and end-to-end risk management with a software tool, then Practical RMP course is the right fit for you.


References

[1] Online Course: Practical RMP with Primavera Risk Analysis, by Satya Narayan Dash. 

[2] eBook: I Want To Be A RMP, 2nd Edition (Updated), by Satya Narayan Dash.