W15_WRP_Problem Focus Using Pareto Analysis

  1. Problem Definition

An oil and gas company is reviewing the problems that leading to over budget and on-stream delay. They need to do pareto analysis for lesson learned for the next big project, on what problem that they need to be more focus on.

2. Identify the Feasible Alternative

Using 20 years data during the exploitation period, they found top 10 problems that contribute to the over budget and delay of the projects. They are:

  1.  Insufficiently defined FEED
  2. Inaccurate prediction of oil and gas production profile
  3. Inaccurate cost estimates by the contractor due to inadequate FEED definition
  4. Ambiguity of the contract documents, leading to disputes over technical specification requirements
  5. Inadequate documentation to support positions and resolve issues that develop during the execution of the project or retrospectively when large claims develop at the end of the project.
  6. Multiple change orders are approved during the project or remain unresolved until the end of project
  7. Insufficient management of multiple prime contractor design and construction interfaces
  8. Owners often do not have a sufficient number of experienced personnel to manage the technical aspects of a project.
  9. Inadequate baseline schedule development and updating by contractors, leading to unreliable progress measurement, uncertain critical paths, and inability to mitigate delay.
  10. Owners do not develop a sufficient master project schedule that results from pulling together the work activities from multiple prime contractors.

3. Development of the Outcome for Alternative

A Pareto chart will be generated for analyzing what problems need first attention.

Pareto Analysis is a statistical technique in decision-making used for the selection of a limited number of tasks that produce significant overall effect. It uses the Pareto Principle (also known as the 80/20 rule) the idea that by doing 20% of the work you can generate 80% of the benefit of doing the entire job.

Here, they will identify the problems which have the greatest cumulative effect on project delays and over budget using Pareto chart as a vertical bar graph in which values are plotted in decreasing order of relative frequency from left to right.

Table 1. Top 10 problems that leading to delays and over budget in last 10 years

Table-1 Count Pareto

  1. Selection Criteria

The company prefer to focus only at 20% of the significant problems which will cover minimal 80% of the problem.

  1. Analysis and Comparison of the Alternative

Fig1 Pareto Chart

Figure 1. Pareto chart analysis

Figure 1 shows that the most problems that causing cost overrun and company shall pay attention to is insufficiently defined FEED.

  1. Selection of the Preferred Alternative

According to figure 1, the company should focus only on top 5 below complaint categories:

Table-2 Count Pareto2

If the company can handle the above top 5 problems, it means they have solved almost  80% of the overall problems.

  1. Performance Monitoring and the Post Evaluation of Result

After knowing the top 5 significant categories to focus on, the company needs to do several actions to solve the problems. Then they should monitor the result on quarterly basis whether a significant improvement has been achieved.


  1. Bassard, Michael & Riter, Diane (2010). The Memory Jogger 2nd Edition, Canada, GOAL/QPC
  2. McDonough, Michele (2012). Creating Pareto Chart with Microsoft Excel. Retrieved from: http://www.brighthubpm.com/templates-forms/8708-creating-pareto-charts-with-microsoft-excel/
  3. Laksono, Andhy (AACE Kristal 2014). W16_AL_Pareto Chart. Retrieved from: https://kristalaace2014.wordpress.com/2014/06/17/w16_al_pareto-chart/
  4. Haughey, Duncan (2014). Pareto Analysis Step by Step. Retrieved from: https://www.projectsmart.co.uk/pareto-analysis-step-by-step.php
This entry was posted in Tak Berkategori. Bookmark the permalink.

One Response to W15_WRP_Problem Focus Using Pareto Analysis

  1. drpdg says:

    Awesome Pak Wilson…….

    You can do all this so maybe you can pass? Let’s discuss your strategy next week….

    Dr. PDG, Jakarta


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s