Multiple Choice
A company wants to use PERT to manage a project. They have developed the following spreadsheet for the problem. If The Risk Solver Platform (RSP) is used, what formula should go in cell F3 of the spreadsheet to compute the Activity Time when simulating a PERT analysis?
A) =IF(E3(C3-E3) /(D3-B3) ,D3-SQRT((D3-B3) *(D3-C3) *(1-E3) ) ,B3+SQRT((D3-E3) *(C3-B3) *E3) )
B) =IF(E3(D3-B3) /(C3-E3) ,B3+SQRT((D3-E3) *(C3-B3) *E3) ,D3-SQRT((D3-B3) *(D3-C3) *(1-E3) ) )
C) =IF(E3(C3-E3) /(D3-B3) ,B3-SQRT((D3-E3) *(C3-B3) *E3) ,D3+SQRT((D3-B3) *(D3-C3) *(1-E3) ) )
D) =PsiTriangular(B3,C3,D3)
Correct Answer:

Verified
Correct Answer:
Verified
Q9: Exhibit 15.2<br>The following questions employ the AON
Q15: Exhibit 15.6<br>The following questions use the
Q19: Exhibit 15.3<br>The following questions are based
Q21: What is the latest finish time for
Q28: Exhibit 15.2<br>The following questions employ the AON
Q39: Exhibit 15.6<br>The following questions use the information
Q40: Exhibit 15.2<br>The following questions employ the AON
Q52: Exhibit 15.2<br>The following questions employ the AON
Q63: What is the formula for the earliest
Q79: Exhibit 15.2<br>The following questions employ the AON