Project Estimate Template Excel Best Case Worst Case by cwk80254

VIEWS: 488 PAGES: 30

More Info
									                                                                                                  [Enter Project Title and Report Phase Here]- PDT Risk Register (Draft)
                                                                                                                                                                              Overall Project Scope
Very Likely
Likely
Unlikely
Very Unlikely
Negligible

Marginal
Significant
Critical
Crisis                                                                                                                                                                        Cost Impacts
Low                                                                                                                                                                           For the [Enter Project Title Here] Project, any cost impact of $ Million or higher should be considered at least "S
Moderate                                                                                                                                                                      Anything over $ Million should be considered at least "Marginal."
High
                                                                                                                                                                              Schedule Impacts
                                                                                                                                                                              For the [Enter Project Title Here] Project, any schedule impact of months or greater should be considered at lea
                                                                                                                                                                              Anything over months should be considered at least "Marginal."

                                                                                                                                                           Project Cost                                        Project Schedule

                                                                                                                                                                              Rough Order                                               Rough Order Variance
Risk No.       Risk/Opportunity Event                      Concerns                                    PDT Discussions                    Likelihood*   Impact*   Risk Level*  Impact ($) Likelihood*        Impact*      Risk Level*   Impact (mo) Distribution


                  Contract Risks (Internal Risk Items are those that are generated, caused, or controlled within the PDT's sphere of influence.)

              PROJECT & PROGRAM
              MGMT


 PPM-1                                                                                                                                                                    0                                                    0



 PPM-2                                                                                                                                                                    0                                                    0



 PPM-3                                                                                                                                                                    0                                                    0



 PPM-4                                                                                                                                                                    0                                                    0



 PPM-5                                                                                                                                                                    0                                                    0



 PPM-6                                                                                                                                                                    0                                                    0



 PPM-7                                                                                                                                                                    0                                                    0


              CONTRACT ACQUISITION
              RISKS


  CA-1                                                                                                                                                                    0                                                    0



  CA-2                                                                                                                                                                    0                                                    0



  CA-3                                                                                                                                                                    0                                                    0



  CA-4                                                                                                                                                                    0                                                    0
CA-5                         0   0



CA-6                         0   0



CA-7                         0   0



       TECHNICAL RISKS


TL-1                         0   0



TL-2                         0   0



TL-3                         0   0



TL-4                         0   0



TL-5                         0   0



TL-6                         0   0



TL-7                         0   0


       LANDS AND DAMAGES
       RISKS


LD-1                         0   0



LD-2                         0   0



LD-3                         0   0



LD-4                         0   0



LD-5                         0   0



LD-6                         0   0



LD-7                         0   0


       REGULATORY AND
       ENVIRONMENTAL RISKS


RE-1                         0   0



RE-2                         0   0
RE-3                           0   0



RE-4                           0   0



RE-5                           0   0



RE-6                           0   0



RE-7                           0   0



        CONSTRUCTION RISKS


CON-1                          0   0



CON-2                          0   0



CON-3                          0   0



CON-4                          0   0



CON-5                          0   0



CON-6                          0   0



CON-7                          0   0


        ESTIMATE AND
        SCHEDULE RISKS


EST-1                          0   0



EST-2                          0   0



EST-3                          0   0



EST-4                          0   0



EST-5                          0   0



EST-6                          0   0



EST-7                          0   0


        [ENTER FEATURE LEVEL
        TITLE] RISKS
   FL-1                                                                                                                                                                          0                                                            0



   FL-2                                                                                                                                                                          0                                                            0



   FL-3                                                                                                                                                                          0                                                            0



   FL-4                                                                                                                                                                          0                                                            0



   FL-5                                                                                                                                                                          0                                                            0



   FL-6                                                                                                                                                                          0                                                            0



   FL-7                                                                                                                                                                          0                                                            0



                   Programmatic Risks (External Risk Items are those that are generated, caused, or controlled exclusively outside the PDT's sphere of influence.)


  PR-1                                                                                                                                                                           0                                                            0



  PR-2                                                                                                                                                                           0                                                            0



  PR-3                                                                                                                                                                           0                                                            0



  PR-4                                                                                                                                                                           0                                                            0



  PR-5                                                                                                                                                                           0                                                            0



  PR-6                                                                                                                                                                           0                                                            0



  PR-7                                                                                                                                                                           0                                                            0
*Likelihood, Impact, and Risk Level to be verified through market research and analysis (conducted by cost engineer).
1. Risk/Opportunity identified with reference to the Risk Identification Checklist and through deliberation and study of the PDT.
2. Discussions and Concerns elaborates on Risk/Opportunity Events and includes any assumptions or findings (should contain information pertinent to eventual study and analysis of event's impact to project).
3. Likelihood is a measure of the probability of the event occurring -- Very Unlikely, Unlikely, Moderately Likely, Likely, Very Likely. The likelihood of the event will be the same for both Cost and Schedule, regardless of impact.
4. Impact is a measure of the event's effect on project objectives with relation to scope, cost, and/or schedule -- Negligible, Marginal, Significant, Critical, or Crisis. Impacts on Project Cost may vary in severity from impacts on Project Schedule.
5. Risk Level is the resultant of Likelihood and Impact Low, Moderate, or High. Refer to the matrix located at top of page.
6. Variance Distribution refers to the behavior of the individual risk item with respect to its potential effects on Project Cost and Schedule. For example, an item with clearly defined parameters and a solid most likely scenario would probably follow a triangular or normal distribution. An risk item for wh
probability of modeling with respect to effects on cost or schedule (i.e. "anyone's guess") would probably follow a uniform or discrete uniform distribution.
7. The responsibility or POC is the entity responsible as the Subject Matter Expert (SME) for action, monitoring, or information on the PDT for the identified risk or opportunity.
8. Correlation recognizes those risk events that may be related to one another. Care should be given to ensure the risks are handled correctly without a "double counting."
9. Affected Project Component identifies the specific item of the project to which the risk directly or strongly correlates.
10. Project Implications identifies whether or not the risk item affects project cost, project schedule, or both. The PDT is responsible for conducting studies for both Project Cost and for Project Schedule.
11. Results of the risk identification process are studied and further developed by the Cost Engineer, then analyzed through the Monte Carlo Analysis Method for Cost (Contingency) and Schedule (Escalation) Growth.
                                                                                    Construction
                                                                                    Contracting                  Project Cost
                                                                                    Cost Engineering             Project Cost & Schedule
                                                                                    District Management          Project Schedule
                                                                                    Electrical Design            Contract Cost
                                                                                    Environmental                Contract Cost & Project Schedule
                                                                                    Geotechnical/Civil Design

                                                                                    Hydrology/Hydraulic Design   Binomial
                                                                                    Mechanical Design            Uniform
                                                                                    N/A                          Normal
                                                                                    Office of Counsel            Triangular
Million or higher should be considered at least "Significant."                      Operations                   Yes-No
                                                                                    Project Manager              Discrete Uniform
                                                                                    Project Sponsor(s)           Min. Extreme
                                                                                    Real Estate                  Max. Extreme
of months or greater should be considered at least "Significant."                   Resource Management          Custom
                                                                                    Resource Providers
                                                                                    Structural Design
                                                                                    TASB

                      Correlation                                Affected Project
                      to Other(s)    Responsibility/POC            Component        Technical Lead
a triangular or normal distribution. An risk item for which the PDT has little data or
                                                                     Contingency on Base Estimate                                                                                                               80% Confidence Project Cost
                                                                            Baseline Estimate Cost (Most Likely) ->
                                                                       Baseline Estimate Cost Contingency Amount ->                                                                                                               $0
                                                          Baseline Estimate Construction Cost (80% Confidence) ->                                                                                                                 $0

                                                                       Contingency on Schedule                                                                                                                80% Confidence Project Schedule
                                                                        Project Schedule Duration (Most Likely) ->                                                                                                      0.0 Months
                                                                                  Schedule Contingency Duration ->                                                                                                      0.0 Months
                                                                    Project Schedule Duration (80% Confidence) ->                                                                                                       0.0 Months
                                                        Project Schedule Contingency Amount (80% Confidence) ->                                                                                                           #DIV/0!

                                                                          Project Contingency                                                                                                                   80% Confidence Project Cost
                                                                 Project Contingency Amount (80% Confidence) ->                                                                                                           #DIV/0!
                                                              Project Contingency Percentage (80% Confidence) ->                                                                                                          #DIV/0!


                                                                                                               Project Cost (80% Confidence) ->                                                                                 #DIV/0!



                                  - PROJECT CONTINGENCY DEVELOPMENT -



         Contingency Analysis                                                                         Project Cost Contingency Analysis
  Most Likely              $0
 Cost Estimate

Confidence Level   Value        Contingency
      0%             #DIV/0!      #DIV/0!      0
      5%             #DIV/0!      #DIV/0!      0
      10%            #DIV/0!      #DIV/0!      0
                                                     $10,000,000
      15%            #DIV/0!      #DIV/0!      0                                                                                                                                                                          Project Cost
      20%            #DIV/0!      #DIV/0!      0                                                                                                                                                                         based at 80%
                                                                                                                                              Corresponding Contingency                                                 Confidence Level
      25%            #DIV/0!      #DIV/0!      0                                                                                                       Amount
                                              Cost




      30%            #DIV/0!      #DIV/0!      0
      35%            #DIV/0!      #DIV/0!      0
      40%            #DIV/0!      #DIV/0!      0
     45%             #DIV/0!      #DIV/0!      0
     50%             #DIV/0!      #DIV/0!      0
     55%             #DIV/0!      #DIV/0!      0
     60%             #DIV/0!      #DIV/0!      0                                                                                                                                                  "Most Likely"
                                                                                                                                                                                                  Project Cost
     65%             #DIV/0!      #DIV/0!      0
     70%             #DIV/0!      #DIV/0!      0
     75%             #DIV/0!      #DIV/0!      0
      80%            #DIV/0!      #DIV/0!      0
     85%             #DIV/0!      #DIV/0!      0
                                                             $0
     90%             #DIV/0!      #DIV/0!      0




                                                                                                                                                                                                                                                   100%
                                                                                                                                                                                                    50%
                                                                     0%




                                                                            10%




                                                                                                                 20%




                                                                                                                                   30%




                                                                                                                                                                                        40%




                                                                                                                                                                                                                60%



                                                                                                                                                                                                                          70%




                                                                                                                                                                                                                                       80%




                                                                                                                                                                                                                                             90%
     95%             #DIV/0!      #DIV/0!      0
     100%            #DIV/0!      #DIV/0!      0                                                                                     Confidence Levels




                                      - BASE CONTINGENCY DEVELOPMENT -


         Contingency Analysis                                      Base Estimate Cost Contingency Analysis (Does not Include Escalation)
  Most Likely              $0
 Cost Estimate

Confidence Level   Value        Contingency
       0%                         #DIV/0!      0
       5%                         #DIV/0!      0
      10%                         #DIV/0!      0
      15%                         #DIV/0!      0 $20,000,000
      20%                         #DIV/0!      0
                                                                                                                                                                                                              Project Cost based at
      25%                         #DIV/0!      0                                                                    Corresponding Contingency                                                                 80% Confidence Level
      30%                         #DIV/0!      0                                                                             Amount
                                              Cost




      35%                         #DIV/0!      0
      40%                         #DIV/0!      0
      45%                         #DIV/0!      0
      50%                         #DIV/0!      0
      55%                         #DIV/0!      0
      60%                         #DIV/0!      0
      65%                         #DIV/0!      0
                                                                                                                                                                                              "Most Likely"
      70%                         #DIV/0!      0                                                                                                                                              Project Cost
      75%                         #DIV/0!      0
       80%                        #DIV/0!      0
      85%                         #DIV/0!      0
                                                          $0
      90%                         #DIV/0!      0
                                                                                                                                   30%
                                                                     0%




                                                                            10%




                                                                                                                 20%




                                                                                                                                                                                        40%




                                                                                                                                                                                                    50%




                                                                                                                                                                                                                60%



                                                                                                                                                                                                                          70%




                                                                                                                                                                                                                                       80%




                                                                                                                                                                                                                                             90%




                                                                                                                                                                                                                                                   100%




      95%                         #DIV/0!      0
      100%                        #DIV/0!      0                                                                                     Confidence Levels

                                                                                  Corresponding Contingency
                                                                                   Corresponding Contingency
                                                                                                                             Corresponding Likely" Projectbasedbased"Most Likely"Durationbased on
                                                                                                                       Corresponding "Most Likely"Corresponding80%
                                                                                                                            Corresponding Likely" Corresponding
                                                                                                                  "Most Likely "
                                                                                                                   "Most Likely
                                                                                                                              "
                                                                                                                                     "Most ProjectProjectCost on Likely" Project Likely"Cost
                                                                                                                                                     Cost Cost on
                                                                                                                                         "Most Likely"
                                                                                                                                      "Most Project Cost based basedon
                                                                                                                                                              "Most on          Project
                                                                                                                                                                            "Most Project Cost based
                                                                                                                                          Project Cost based 80% Confidence Level
                                                                                                                                         Project Cost based onon 80% Confidence Level
                    - SCHEDULE CONTINGENCY (DURATION) DEVELOPMENT -



         Contingency Analysis
  Most Likely           0.0 Months                                                   Schedule Contingency (Duration) Analysis
   Schedule

Confidence Level   Value         Contingency
      0%           0.0 Months      #DIV/0!       0
      5%           0.0 Months      #DIV/0!       0
      10%          0.0 Months      #DIV/0!       0
      15%          0.0 Months      #DIV/0!       0
      20%          0.0 Months      #DIV/0!       0 20.0 Months
                                                                                                                                                              Project Duration at
      25%          0.0 Months      #DIV/0!       0                                                                     Corresponding Variance                  80% Confidence
      30%          0.0 Months      #DIV/0!       0                                                                            Duration                              Level
                                               Duration
      35%          0.0 Months      #DIV/0!       0
      40%          0.0 Months      #DIV/0!       0
     45%           0.0 Months      #DIV/0!       0
     50%           0.0 Months      #DIV/0!       0
     55%           0.0 Months      #DIV/0!       0
     60%           0.0 Months      #DIV/0!       0                                                                                    Current Project
     65%           0.0 Months      #DIV/0!       0                                                                                       Duration
     70%           0.0 Months      #DIV/0!       0
     75%           0.0 Months      #DIV/0!       0
      80%          0.0 Months      #DIV/0!       0
     85%           0.0 Months      #DIV/0!       0 0.0 Months
     90%           0.0 Months      #DIV/0!       0
                                                                          0%




                                                                                                    20%




                                                                                                                                               50%
                                                                                     10%




                                                                                                                 30%




                                                                                                                               40%




                                                                                                                                                        60%




                                                                                                                                                                  70%




                                                                                                                                                                            80%




                                                                                                                                                                                     90%




                                                                                                                                                                                           100%
     95%           0.0 Months      #DIV/0!       0
     100%          0.0 Months      #DIV/0!       0                                                                 Confidence Levels




                      - SCHEDULE CONTINGENCY (AMOUNT) DEVELOPMENT -



         Contingency Analysis
  Most Likely
                                                                                           Project Schedule Contingency Analysis
                            $0
 Cost Estimate

Confidence Level   Value         Contingency
      0%              #DIV/0!      #DIV/0!       0
      5%              #DIV/0!      #DIV/0!       0
      10%             #DIV/0!      #DIV/0!       0
      15%             #DIV/0!      #DIV/0!       0
                                                          $100,000
      20%             #DIV/0!      #DIV/0!       0
                                                                                                                                                     Project Cost Plus Schedule
      25%             #DIV/0!      #DIV/0!       0                                                                                                   Contingency based at 80%
                                                                                                          Corresponding Schedule                          Confidence Level
      30%             #DIV/0!      #DIV/0!       0                                                              Contingency
                                                                                                                  Amount
      35%             #DIV/0!      #DIV/0!       0
                                               Cost




      40%             #DIV/0!      #DIV/0!       0
      45%             #DIV/0!      #DIV/0!       0
      50%             #DIV/0!      #DIV/0!       0
      55%             #DIV/0!      #DIV/0!       0
      60%             #DIV/0!      #DIV/0!       0
      65%             #DIV/0!      #DIV/0!       0
      70%             #DIV/0!      #DIV/0!       0
      75%             #DIV/0!      #DIV/0!       0                                                                                   "Most Likely"
                                                                                                                                     Project Cost
      80%             #DIV/0!      #DIV/0!       0
      85%             #DIV/0!      #DIV/0!       0
      90%             #DIV/0!      #DIV/0!       0             $0
                                                                     0%




                                                                               10%




                                                                                              20%




                                                                                                           30%




                                                                                                                         40%




                                                                                                                                         50%




                                                                                                                                                     60%




                                                                                                                                                                70%




                                                                                                                                                                           80%




                                                                                                                                                                                    90%




                                                                                                                                                                                           100%




     95%              #DIV/0!      #DIV/0!       0
     100%             #DIV/0!      #DIV/0!       0                                                               Confidence Levels
Boiler Plate - Cost Risk Analysis
                                                               Boiler Plate - Schedule Risk Analysis Model
                                                                                                                                                           Crystal Ball Simulation                    Crystal Ball Simulation
                                                                   Project Cost                                                                            Expected Values (mos.)                     Expected Values (%s)

                                                                                                       Variance                                                                                                                           Percentages are calculated as the
   Risk No.         Risk/Opportunity Event       Likelihood*      Impact*         Risk Level*         Distribution         Correlation to Other(s)   Low         Most Likely         High   Low            Most Likely          High      variance from the assumption value to
                                                                                                                                                                                                                                          facilitate iteration of the model should
                                                                                                                                                                                                                                          the cost values change throughout the
Internal Risks (Internal Risk Items are those that are generated, caused, or controlled within the PDT's sphere of influence.)
                                                                                                                                                                                                                                          project phases. Uniform distribution
                                                                                                                                                                                                                                          percentages reflect variation from the
PROJECT & PROGRAM MGMT                                                                                                                                                                                                                    total project cost.


     PPM-1                                                                                                                                                                                  #DIV/0!           #DIV/0!           #DIV/0!



     PPM-2                                                                                                                                                                                  #DIV/0!           #DIV/0!           #DIV/0!



     PPM-3                                                                                                                                                                                  #DIV/0!           #DIV/0!           #DIV/0!



     PPM-4                                                                                                                                                                                  #DIV/0!           #DIV/0!           #DIV/0!



     PPM-5                                                                                                                                                                                  #DIV/0!           #DIV/0!           #DIV/0!



     PPM-6                                                                                                                                                                                  #DIV/0!           #DIV/0!           #DIV/0!



     PPM-7                                                                                                                                                                                  #DIV/0!           #DIV/0!           #DIV/0!



CONTRACT ACQUISITION RISKS


     CA-1                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



     CA-2                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



     CA-3                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



     CA-4                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



     CA-5                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



     CA-6                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



     CA-7                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



TECHNICAL RISKS


      TL-1                                                                                                                                                                                  #DIV/0!           #DIV/0!           #DIV/0!



      TL-2                                                                                                                                                                                  #DIV/0!           #DIV/0!           #DIV/0!



      TL-3                                                                                                                                                                                  #DIV/0!           #DIV/0!           #DIV/0!



      TL-4                                                                                                                                                                                  #DIV/0!           #DIV/0!           #DIV/0!



      TL-5                                                                                                                                                                                  #DIV/0!           #DIV/0!           #DIV/0!



      TL-6                                                                                                                                                                                  #DIV/0!           #DIV/0!           #DIV/0!



      TL-7                                                                                                                                                                                  #DIV/0!           #DIV/0!           #DIV/0!



LANDS AND DAMAGES RISKS


     LD-1                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



     LD-2                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



     LD-3                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



     LD-4                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



     LD-5                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



     LD-6                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



     LD-7                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



REGULATORY AND ENVIRONMENTAL RISKS


     RE-1                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



     RE-2                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



     RE-3                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!



     RE-4                                                                                                                                                                                   #DIV/0!           #DIV/0!           #DIV/0!
    RE-5                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



    RE-6                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



    RE-7                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



CONSTRUCTION RISKS


   CON-1                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



   CON-2                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



   CON-3                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



   CON-4                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



   CON-5                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



   CON-6                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



   CON-7                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



ESTIMATE AND SCHEDULE RISKS


    EST-1                                                                                                                                                                                                        #DIV/0!   #DIV/0!   #DIV/0!



    EST-2                                                                                                                                                                                                        #DIV/0!   #DIV/0!   #DIV/0!



    EST-3                                                                                                                                                                                                        #DIV/0!   #DIV/0!   #DIV/0!



    EST-4                                                                                                                                                                                                        #DIV/0!   #DIV/0!   #DIV/0!



    EST-5                                                                                                                                                                                                        #DIV/0!   #DIV/0!   #DIV/0!



    EST-6                                                                                                                                                                                                        #DIV/0!   #DIV/0!   #DIV/0!



    EST-7                                                                                                                                                                                                        #DIV/0!   #DIV/0!   #DIV/0!



FEATURE LEVEL RISKS


    FL-1                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



    FL-2                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



    FL-3                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



    FL-4                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



    FL-5                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



    FL-6                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



    FL-7                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



                      Programmatic Risks (External Risk Items are those that are generated, caused, or controlled exclusively outside the PDT's sphere of influence.)


    PR-1                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



    PR-2                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



    PR-3                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



    PR-4                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



    PR-5                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



    PR-6                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!



    PR-7                                                                                                                                                                                                         #DIV/0!   #DIV/0!   #DIV/0!
                                                                                                                                                                                         Not Part of Study -
                                                                                                                                                                                       Placeholder for Project
                                                                                                                                                                         0.0 Months   Summation Purposes Only
                                                                                                                                                                        0.0 Months



              PROJECT SCHEDULE                Percentile      Baseline Schedule Duration            Contingency        Baseline w/ Contingency            Contingency
                                                   0%                     0.0 Months                                             0.0 Months                   #DIV/0!
                CONTINGENCY                        5%                     0.0 Months                                             0.0 Months                   #DIV/0!
                  (BASELINE)                      10%                     0.0 Months                                             0.0 Months                   #DIV/0!
                                                  15%                     0.0 Months                                             0.0 Months                   #DIV/0!
                                                  20%                     0.0 Months                                             0.0 Months                   #DIV/0!
                                                  25%                     0.0 Months                                             0.0 Months                   #DIV/0!
                                                  30%                     0.0 Months                                             0.0 Months                   #DIV/0!
                                                  35%                     0.0 Months                                             0.0 Months                   #DIV/0!
                                                  40%                     0.0 Months                                             0.0 Months                   #DIV/0!
                                                  45%                     0.0 Months                                             0.0 Months                   #DIV/0!
 50%   0.0 Months   0.0 Months   #DIV/0!
 55%   0.0 Months   0.0 Months   #DIV/0!
 60%   0.0 Months   0.0 Months   #DIV/0!
 65%   0.0 Months   0.0 Months   #DIV/0!
 70%   0.0 Months   0.0 Months   #DIV/0!
 75%   0.0 Months   0.0 Months   #DIV/0!
 80%   0.0 Months   0.0 Months   #DIV/0!
 85%   0.0 Months   0.0 Months   #DIV/0!
 90%   0.0 Months   0.0 Months   #DIV/0!
 95%   0.0 Months   0.0 Months   #DIV/0!
100%   0.0 Months   0.0 Months   #DIV/0!
                                             Boiler Plate - Schedule Risk Analysis Model
Enter Estimated Total Project Cost (Price Level)
       Max. Anticipated Annual Amount               #DIV/0!
      Enter Current OMB Escalation Rate              1.80%
Enter Current Project Location Escalation Rate
          Enter Assumed Hotel Rate


                                                     Date      Escalation Delta Amount   Hotel Amount   Total Schedule Contingency
          Enter Current Project Start
      Enter Baseline Project Completion                                 $0.00                                     $0.00
     Project Completion at 0% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
     Project Completion at 5% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 10% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 15% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 20% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 25% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 30% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 35% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 40% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 45% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 50% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 55% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 60% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 65% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 70% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 75% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 80% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 85% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 90% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 95% Confidence            0-Jan-00            $0.00              #DIV/0!               #DIV/0!
    Project Completion at 100% Confidence           0-Jan-00            $0.00              #DIV/0!               #DIV/0!

                   Entry Required

                  Do Not Overwrite

          Summary Data -- Do Not Overwrite
                                          Boiler Plate - Schedule Risk Analysis Model



 Risk Refer No.                     Risk Event                          Low         Most Likely         High




Notes:            This item captures the risk that [enter risk event title here] will cause a variance from the
                  current baseline schedule.
Likely            Likely assumes no change from the baseline schedule.
Low

                  Low assumes [enter best case development assumptions and discussion here].
High

                  High assumes [enter worst case development assumptions and discussion here].




Assumption:                                                     0
  Percentile                   Assumption values
      0%
     10%
     20%
     30%
     40%
     50%
     60%
     70%
     80%
     90%
    100%
                                          Boiler Plate - Schedule Risk Analysis Model



 Risk Refer No.                     Risk Event                          Low         Most Likely         High




Notes:            This item captures the risk that [enter risk event title here] will cause a variance from the
                  current baseline schedule.
Likely            Likely assumes no change from the baseline schedule.
Low

                  Low assumes [enter best case development assumptions and discussion here].
High

                  High assumes [enter worst case development assumptions and discussion here].




Assumption:                                                     0
  Percentile                   Assumption values
      0%
     10%
     20%
     30%
     40%
     50%
     60%
     70%
     80%
     90%
    100%
                                          Boiler Plate - Schedule Risk Analysis Model



 Risk Refer No.                     Risk Event                          Low         Most Likely         High




Notes:            This item captures the risk that [enter risk event title here] will cause a variance from the
                  current baseline schedule.
Likely            Likely assumes no change from the baseline schedule.
Low

                  Low assumes [enter best case development assumptions and discussion here].
High

                  High assumes [enter worst case development assumptions and discussion here].




Assumption:                                                     0
  Percentile                   Assumption values
      0%
     10%
     20%
     30%
     40%
     50%
     60%
     70%
     80%
     90%
    100%
                                          Boiler Plate - Schedule Risk Analysis Model



 Risk Refer No.                     Risk Event                          Low         Most Likely         High




Notes:            This item captures the risk that [enter risk event title here] will cause a variance from the
                  current baseline schedule.
Likely            Likely assumes no change from the baseline schedule.
Low

                  Low assumes [enter best case development assumptions and discussion here].
High

                  High assumes [enter worst case development assumptions and discussion here].




Assumption:                                                     0
  Percentile                   Assumption values
      0%
     10%
     20%
     30%
     40%
     50%
     60%
     70%
     80%
     90%
    100%
                                          Boiler Plate - Schedule Risk Analysis Model



 Risk Refer No.                     Risk Event                          Low         Most Likely         High




Notes:            This item captures the risk that [enter risk event title here] will cause a variance from the
                  current baseline schedule.
Likely            Likely assumes no change from the baseline schedule.
Low

                  Low assumes [enter best case development assumptions and discussion here].
High

                  High assumes [enter worst case development assumptions and discussion here].




Assumption:                                                     0
  Percentile                   Assumption values
      0%
     10%
     20%
     30%
     40%
     50%
     60%
     70%
     80%
     90%
    100%
                                          Boiler Plate - Schedule Risk Analysis Model



 Risk Refer No.                     Risk Event                          Low         Most Likely         High




Notes:            This item captures the risk that [enter risk event title here] will cause a variance from the
                  current baseline schedule.
Likely            Likely assumes no change from the baseline schedule.
Low

                  Low assumes [enter best case development assumptions and discussion here].
High

                  High assumes [enter worst case development assumptions and discussion here].




Assumption:                                                     0
  Percentile                   Assumption values
      0%
     10%
     20%
     30%
     40%
     50%
     60%
     70%
     80%
     90%
    100%
                                          Boiler Plate - Schedule Risk Analysis Model



 Risk Refer No.                     Risk Event                          Low         Most Likely         High




Notes:            This item captures the risk that [enter risk event title here] will cause a variance from the
                  current baseline schedule.
Likely            Likely assumes no change from the baseline schedule.
Low

                  Low assumes [enter best case development assumptions and discussion here].
High

                  High assumes [enter worst case development assumptions and discussion here].




Assumption:                                                     0
  Percentile                   Assumption values
      0%
     10%
     20%
     30%
     40%
     50%
     60%
     70%
     80%
     90%
    100%
                                          Boiler Plate - Schedule Risk Analysis Model



 Risk Refer No.                     Risk Event                          Low         Most Likely         High




Notes:            This item captures the risk that [enter risk event title here] will cause a variance from the
                  current baseline schedule.
Likely            Likely assumes no change from the baseline schedule.
Low

                  Low assumes [enter best case development assumptions and discussion here].
High

                  High assumes [enter worst case development assumptions and discussion here].




Assumption:                                                     0
  Percentile                   Assumption values
      0%
     10%
     20%
     30%
     40%
     50%
     60%
     70%
     80%
     90%
    100%
                                          Boiler Plate - Schedule Risk Analysis Model



 Risk Refer No.                     Risk Event                          Low         Most Likely         High




Notes:            This item captures the risk that [enter risk event title here] will cause a variance from the
                  current baseline schedule.
Likely            Likely assumes no change from the baseline schedule.
Low

                  Low assumes [enter best case development assumptions and discussion here].
High

                  High assumes [enter worst case development assumptions and discussion here].




Assumption:                                                     0
  Percentile                   Assumption values
      0%
     10%
     20%
     30%
     40%
     50%
     60%
     70%
     80%
     90%
    100%
                                          Boiler Plate - Schedule Risk Analysis Model



 Risk Refer No.                     Risk Event                          Low         Most Likely         High




Notes:            This item captures the risk that [enter risk event title here] will cause a variance from the
                  current baseline schedule.
Likely            Likely assumes no change from the baseline schedule.
Low

                  Low assumes [enter best case development assumptions and discussion here].
High

                  High assumes [enter worst case development assumptions and discussion here].




Assumption:                                                     0
  Percentile                   Assumption values
      0%
     10%
     20%
     30%
     40%
     50%
     60%
     70%
     80%
     90%
    100%
                                          Boiler Plate - Schedule Risk Analysis Model



 Risk Refer No.                     Risk Event                          Low         Most Likely         High




Notes:            This item captures the risk that [enter risk event title here] will cause a variance from the
                  current baseline schedule.
Likely            Likely assumes no change from the baseline schedule.
Low

                  Low assumes [enter best case development assumptions and discussion here].
High

                  High assumes [enter worst case development assumptions and discussion here].




Assumption:                                                     0
  Percentile                   Assumption values
      0%
     10%
     20%
     30%
     40%
     50%
     60%
     70%
     80%
     90%
    100%
                                          Boiler Plate - Schedule Risk Analysis Model



 Risk Refer No.                     Risk Event                          Low         Most Likely         High




Notes:            This item captures the risk that [enter risk event title here] will cause a variance from the
                  current baseline schedule.
Likely            Likely assumes no change from the baseline schedule.
Low

                  Low assumes [enter best case development assumptions and discussion here].
High

                  High assumes [enter worst case development assumptions and discussion here].




Assumption:                                                     0
  Percentile                   Assumption values
      0%
     10%
     20%
     30%
     40%
     50%
     60%
     70%
     80%
     90%
    100%
                                          Boiler Plate - Schedule Risk Analysis Model



 Risk Refer No.                     Risk Event                          Low         Most Likely         High




Notes:            This item captures the risk that [enter risk event title here] will cause a variance from the
                  current baseline schedule.
Likely            Likely assumes no change from the baseline schedule.
Low

                  Low assumes [enter best case development assumptions and discussion here].
High

                  High assumes [enter worst case development assumptions and discussion here].




Assumption:                                                     0
  Percentile                   Assumption values
      0%
     10%
     20%
     30%
     40%
     50%
     60%
     70%
     80%
     90%
    100%
                                          Boiler Plate - Schedule Risk Analysis Model



 Risk Refer No.                     Risk Event                          Low         Most Likely         High




Notes:            This item captures the risk that [enter risk event title here] will cause a variance from the
                  current baseline schedule.
Likely            Likely assumes no change from the baseline schedule.
Low

                  Low assumes [enter best case development assumptions and discussion here].
High

                  High assumes [enter worst case development assumptions and discussion here].




Assumption:                                                     0
  Percentile                   Assumption values
      0%
     10%
     20%
     30%
     40%
     50%
     60%
     70%
     80%
     90%
    100%
                                          Boiler Plate - Schedule Risk Analysis Model



 Risk Refer No.                     Risk Event                          Low         Most Likely         High




Notes:            This item captures the risk that [enter risk event title here] will cause a variance from the
                  current baseline schedule.
Likely            Likely assumes no change from the baseline schedule.
Low

                  Low assumes [enter best case development assumptions and discussion here].
High

                  High assumes [enter worst case development assumptions and discussion here].




Assumption:                                                     0
  Percentile                   Assumption values
      0%
     10%
     20%
     30%
     40%
     50%
     60%
     70%
     80%
     90%
    100%

								
To top