Wrench Solutions - Project Management Information System
MENUMENU
  • Solutions
        • By Modules
          • EDMS
          • Project Scheduling and Forecasting
          • Engineering Deliverable Management
          • Procurement Management
          • Construction Monitoring & Control
          • Project Control System
          • Quality Management
          • Quality & Safety
          • Cost Control & Cashflow Management
          • Risk Management
          • Safety Management
          • Snagging and Project Closure
          • Integrated Project Management System
        • By Firms
          • Owner
          • PMC
          • Engineering Consultant
          • Contractors
        • By Industries
          • Infrastructure
          • Construction
          • Energy
  • Customers
    • Customers List
    • Projects
    • Testimonials
    • Case Studies
  • Resources
    • Resource Centre
    • Blog
    • Support
    • Whitepaper
    • Webinar
    • Wrench Academy
    • Certifications
    • Integrations
  • Company
    • About Us
    • Partners
    • Careers
    • News
    • FAQ
    • Contact Us
  • Request Demo
CONTACT USREQUEST DEMO
  • Blog
  • 20 Nov 2019

EVM Progress monitoring using S Curves and histograms of engineering deliverables

EVM Progress monitoring using S Curves and histograms of engineering deliverables

One of the biggest problems facing project managers is the lack of on-time project progress data. By the time progress information reaches them on a weekly or monthly basis, a lot of precious time has already been wasted, and project management decisions were not made optimally.

This post explores a solution to the problem, using EVM-based real-time progress monitoring for engineering deliverables.

Figure 1: S Curve

Figure 1 compares the planned progress of project over a month with the actual progress during that month. For example, in the second week of Jan 2019, 10% progress had to be completed but only 8% progress was achieved. Planned vs actual progress curves (called ‘S’ curves because they look like the letter ‘S’) help decipher the schedule and cost performance of the project.

Initiating a project requires a lot of resources and time for mobilizing and startup, but the progress percentage remains stagnant at this initial stage. Once the initial planning and mobilization is complete the project progress picks up and a flurry of activity begins, usually with exponential progress. (This is the most productive period.) In later stages of the project there are lots of activities which need more time and more effort. That is the rationale behind the S curve, the start and the completion of the project stagnates, the middle area is where the % progress accelerates.

Progress monitoring: Planned Vs Actual

For progress monitoring, first the planned progress with respect to time needs to be fixed, and then the actual progress needs to be measured and charted.

For estimating the planned progress for the project:

  1. Each deliverable should have estimated/ budgeted man hours so that the weightage of the deliverable with respect to the project can be calculated.
  2. Each deliverable should have its component milestones defined.
  3. Each deliverable should have defined rules of credit which indicates the % progress gained on achieving the milestone.
  4. Each deliverable should have planned dates for each milestone

For estimating the actual progress monitoring for the deliverable:

  1. The % progress and the corresponding dates need to be recorded.
  2. The weightage of the deliverables (or the budgeted man hours) should be known.
  3. If the actual percentages are to be updated based on milestones the milestones need to be achieved for the actual percentage to be gained. If not, for each deliverable the actual percentage progress should be updated by the user.

Below is an example in which a deliverable is mapped against milestones and each milestone is assigned a planned progress percentage.

Figure 2: Milestones and Progress

The planning department prepares the dates in which these milestones are planned for completion.

S.NoMilestonePlanned DatesPlanned ProgressPlanned Cumulative ProgressPlanned Manhour consumedPlanned Cumulative manhours consumed
1Start12-01-20195%5%1515
2Checking31-01-201925%40%95110
3Inter departmental check05-02-201920%60%85195
4Submission for Review06-02-201920%80%160255
5Receive Client Comments15-02-20195%85%115370
6Submission for Approval20-02-20195%90%15385
7Submission for Construction01-03-201910%100%30415

In other words, the planning department at the start of the project prepares an engineering drawings/ document( EDDR) register which becomes the master plan for each document containing all the above information.

Based on this information a table can be created which has the cumulative percentage for the specific deliverable for each week.

Sl .noWeek NoIncremental Percentage progressCumulative Percentage progress
1Week 15%5%
2Week 20%5%
3Week 335%40%
4Week 40%40%
5Week 50%40%
6Week 60%40%
7Week 725%60%
8Week 80%60%
9Week 920%80%
10Week 1010%90%
11Week 120%90%
12Week 130%90%
13Week 1410%100%

The progress percentage for the project is the weighted average of the progress for each deliverable.

This is a milestone-based plan, so on completing each milestone the deliverable is credited with actual progress and it becomes possible to compare the actual vs planned per milestone per deliverable. (If the progress measurement is not through measurable milestones as shown above, the planners would have to approach department heads or users to get the progress recorded for each deliverable, which obviously would drain time as well as being unreliable as the users tend to update progress without clear evidence).

To sum up, the planning department makes a plan which contains the following:

  1. List of deliverables
  2. Estimated manhours for each deliverable.
  3. If possible each deliverable’s milestones and planned % progress to be achieved on reaching the milestone
  4. Planned progress s-curves, planned progress charts per week/ month.

On executing the project, the planning department measures the actual progress by;

  1. Getting the users to update the actual weekly progress and the actual milestones achieved
  2. Comparing the actual progress of the project with the planned progress i.e. what was achieved versus what should have been achieved
  3. Analyze the last week’s planned vs actual progress, and then analyze the project’s overall planned vs actual planned progress (so far).

Automating S-curves and histograms

The above steps takes a huge amount of time-spend in information gathering. For example, on projects which have 1000 deliverables and about 8 milestones for each task, there are about 8000 milestones to be planned i.e. about 8000 actual dates which need to be monitored and updated. This is a huge exercise.  Plus, as this information is being gathered, human error will inevitably creep in and so the authenticity of the information is constantly in doubt.

As a solution to this bottleneck let’s consider today’s systems which handle the planning and monitoring, namely project management systems like Primavera and Excel worksheets. The way these work are well known.

Now let’s consider a system that integrates and automates this entire setup. Here’s how that would work:

  1. The plans would get published to all (via the automated system)
  2.  The resources to initiate the work would get a to-do list with target dates
  3. The resources would complete their work and route it through an electronic workflow to the next user i.e. the next-in-line resource gets a personalized to-do list.
  4. The System would be able to automatically generate  actual progress percentage S-Curves and Histograms
  5. On updation, the progress percentage of the task would be updated back to tools like Primavera / MS Project.

The benefits of an automated system like the one shown above are:

  1. Effective early warning system for Project Managers and Clients to ensure that the ‘actuals’ match the ‘planned’.
  2. Target dates can be built for each user so that pressure is bottom-up and not top-down.
  3. If this information and progress measurement system is automated, the planners would be able to spend their precious time in expediting critical path tasks rather than in information collecting, which is a comparatively low-value task.
Share to social media
Varghese Daniel
Author
Varghese Daniel

Varghese Daniel is the co-founder and CEO of Wrench Solutions.

Related Posts

Implementing Agile Project Management in Engineering Projects
Blog

Implementing Agile Project Management in Engineering Projects

A quick look at the Top 3 global project management trends A project’s success criteria is being determined by ROI and ROCE rather than the traditional three-factor approach of Time, Cost and Scope. Projects are…

Abrachan Abrachan
  • 13 Sep 2020
Cash Flow Risk Factors in Construction Projects That Can Be Minimized with Technology | Part 2
Blog

Cash Flow Risk Factors in Construction Projects That Can Be Minimized with Technology | Part 2

In the previous blog post in this series, we talked about how the risk of delayed conditional payments can be minimized with better documentation management. Here we will focus on how an early-warning system can…

Abrachan Abrachan
  • 24 Aug 2020

Post a Comment

Featured Posts

Implementing Agile Project Management in Engineering Projects

Implementing Agile Project Management in Engineering Projects

  • September 13, 2020
  • [rt_reading_time postfix="mins read" postfix_singular="min read"]
Cash Flow Risk Factors in Construction Projects That Can Be Minimized with Technology | Part 2

Cash Flow Risk Factors in Construction Projects That Can Be Minimized with Technology | Part 2

  • August 24, 2020
  • [rt_reading_time postfix="mins read" postfix_singular="min read"]
Cash Flow Risk Factors in Construction Projects That Can Be Minimized with Technology | Part 1

Cash Flow Risk Factors in Construction Projects That Can Be Minimized with Technology | Part 1

  • August 12, 2020
  • [rt_reading_time postfix="mins read" postfix_singular="min read"]

Subscribe to Our Blog

Sign up for our regular updates on project productivity, delivered straight to your inbox

Archives

  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • September 2020
  • August 2020
  • June 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • April 2019
  • March 2019
  • December 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • January 2018
  • November 2017
  • October 2017
  • September 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017

Follow Us

Company

  • About us
  • News
  • Contact us
  • Careers

Solutions

  • EDMS
  • Engineering Deliverable Management
  • Project Control System
  • Procurement Management
  • Construction Management
  • Budget & Cashflow
  • Integrated Project Management System

Firms

  • Owner
  • PMC
  • Engineer
  • Contractor

Resources

  • Resource Centre
  • Blog
  • Case Studies
  • Projects

Contact

  • Icon [email protected]

Subscribe to our Newsletter

© 2021 Wrench Solutions. All rights reserved.

Acceptable Use Policy | Privacy Policy