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
Q13: Exhibit 14.13
The following questions use the information
Q23:
The following questions employ the AON network
Q28: Exhibit 15.2
The following questions employ the AON
Q28: Which activities are critical in the following
Q28:
The following questions employ the AON network
Q30: What formula should go in cell I5
Q31: Which activities have slack in the following
Q35: What formula should go in cell H3
Q43: Exhibit 15.2
The following questions employ the AON
Q57: Exhibit 15.2
The following questions employ the AON
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents