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 0(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
Q44:
The following questions are based on the
Q48:
The following questions are based on the
Q49:
The following questions are based on the
Q50:
The following questions are based on the
Q51:
The following questions are based on the
Q52:
The following questions are based on the
Q63: Exhibit 15.4
The following questions are based on
Q68: Exhibit 15.3
The following questions are based on
Q72: Exhibit 15.4
The following questions are based on
Q80: Exhibit 15.5
The following questions use the information
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