W9_Hilal_Estimating Cost at Completion (Part 2)

By -
Problem Recognition
In W8 Blog, I discussed about using IEACs method in order to forecast the possible progress for the coming weeks. In this blog, I will use the Monte Carlo Simulation in order to estimate the progress. I am going to use MS Excel to run the simulation.
Feasible alternative
The Guild of Project Controls Compendium and Reference suggest using three main furcating/ estimation techniques:
-       Independent estimate at completion (IEAC)
-       Monte Carlo Simulation
-       Best Fit
Analysis of Monte Carlo Simulation Alternative
The table below shows the current progress of the PMP course project:

Table 1: Up to W6 PMP Course Progress
Now we start with the original budget at completion and allow for 0.5% deviation from the original. Then, if the random number is higher than 0.5%, it will take the above number and add to it the 0.5% and if it is less it will take the above number again but subtract from it the 0.5%. In other words, we are using this function (=IF(RAND()>0.5,A1+(0.005*$A$1),A1-(0.005*$A$1)). The results can be shown below:

Table 2: MS Monte Carlo Simulation Resultes

Now we calculate the probabilities:

Table 3: Probabilities Calculations.

Figure 1: Distribution curve of the results.
Selection of Preferred Alternative

Since we are discussing which method to select, the preferred alternative will be selected once all the methods has been discussed in the future blogs.

Tracking/ reporting plan

The next step is to do the same analysis using different estimation methods (i.e. Best Fit). This method can then be applied to our forecasts of project completion and present this to the management based on the confidence level they choose.

References

Stephen, J. (2017).W10_SJP_Forecasts Part 5. Retrieved fromhttps://js-pag-cert-2017.com/w13_sjp_forecasts-part-5/ 

National Defense Industrial Association. (2014). A Guide to managing programs using predictive measures. Retrieved from http://www.earnedschedule.com/Docs/NDIA%20Predictive%20Measures%20Guide.pdf

Guild of Project Controls. 2015. Monte Carlo Simulation – Guild of project controls compendium and reference (CaR) | Project Controls – planning, scheduling, cost management and forensic analysis (Planning Planet). Retrieved from http://www.planningplanet.com/guild/gpccar/conducting-a-cost-risk-analysis

Comments

  1. Dr. PDGJanuary 1, 2018 at 2:58 PM

    Hi Hilal,
    In your introduction you make the statement "I will use the Monte Carlo Simulation in order to estimate the progress."

    Is that really what you are doing or are you FORECASTING the EAC time and/or cost?

    May seem to be a small point but important difference.......

    Other than that, you are in great shape as this is an incredibly important and USEFUL skill set to master for your real life projects.

    BR,
    Dr. PDG, Jakarta

    ReplyDelete

Post a Comment

Popular posts from this blog

W1_Thuraiya_Leadership Styles analysis Using Tuckman model

By -
Image
1-       Problem Recognition:          OPWP PMP team are currently at the stage of distance learning in the PMP course. The     team consist of 13 members and has started course from 29 th Oct and we’re aiming to be certified no later than 25 th Mar . During the current stage, every individual must submit a weekly blog related to a real work issue faced in the organization to determine the causes and the solutions. In  first blog Dr. Paul has requested  to measure the team development and behavior using   Tuckman’s Model. To insure the success of every project the  members must  understand the goals and the roles of each one to collaborate to achieve their goals. Further the team leader must understand his team behavior to know the most optimum leadership style must be adopted while managing the project.  2-      Identify the Feasible Alternative Tuckman m...
Read more
By -
Image
W1__Hamda__Tuckman Analysis Assignment__ 1-        Problem Definition After completion the first stage in PMP course which was conducted in Muscat from 29 th of October 2017 to 2 nd of November 2017 which was Face to Face stage, and following the formation of the OPWP-PMP team during this stage, the team is starting the second stage in this program which is the Distance Learning. Weekly Blog is one of the tasks in this stage. The first topic of the first weekly blog is suggested by Dr.Paul which is using Tuckman’s Model to know in which phase of this model the team is operated in and which style of leadership should be adopted in order to develop the team to achieve its goals. 2-        Identify the Feasible Alternative The Forming, Storming, Norming, and Performing model of group development was first proposed by Bruce Tuckman in 1965 who maintained that these phases are all necessary in order to develop...
Read more

W1_MA_Tuckman Analysis Assignment

By -
Image
Problem Definition Bruce Tuckman model used to identify the team status and the development phase of the project team. As the team go through these phases, different strategies should be implemented by the team leader and managers. This assessment will provide enough information for the team leader and even for the team members that would give a good understand the team performance.   Identify the Feasible Alternative There were 4 stages model of "forming, storming, norming, and performing" introduced by Bruce Tuckman in 1965. However, a fifth stage was added “adjourning” which describe the phase that the team go through after the achievement of project tasks and completion of the project. Figure 1 , development stages [2] In each phase, the leadership style should be in alignment with that specific phase which enhance the development of the team and improve the performance of the team as well. There are different styles that could be used by the team le...
Read more