Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

pertcalc.xls - Krypton

VIEWS: 6 PAGES: 2

									                                          PERT ANALYSIS CALCULATOR
                                USER SUPPLIED ESTIMATES
                        OPTIMISTIC         TYPICAL   PESSIMISTIC
Critical Path Tasks
MARK UTILITIES                  1             3           5
DIG HOLES                       2             4           7
PLANT TREES                     1             3           6
PLANT FLOWERS                   1             3           5
INSTALL EDGING                  1             2           4

                                                         SUM

Enter Desired Completion Time       >>>      15        Probability of Completion      >>>>>



(Sample project - change task names & number of tasks as necessary - be sure to adjust formula
SIS CALCULATOR
                 PERT
               EXPECTED         Std. Deviation      Variance
               DURATION
                  3.00              0.667             0.444
                  4.17              0.833             0.694
                  3.17              0.833             0.694
                  3.00              0.667             0.444
                  2.17              0.500             0.250

                 15.50                                2.528

Probability of Completion      >>>>>                37.66%


s necessary - be sure to adjust formulae to reflect the number of tasks)

								
To top