Solved

A Company Wants to Use PERT to Manage a Project

Question 17

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 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<font face= symbol ></font>(C3-E3) /(D3-B3) ,D3-SQRT((D3-B3) *(D3-C3) *(1-E3) ) ,B3+SQRT((D3-E3) *(C3-B3) *E3) )  B)  =IF(E3<font face= symbol ></font>(D3-B3) /(C3-E3) ,B3+SQRT((D3-E3) *(C3-B3) *E3) ,D3-SQRT((D3-B3) *(D3-C3) *(1-E3) ) )  C)  =IF(E3<font face= symbol ></font>(C3-E3) /(D3-B3) ,B3-SQRT((D3-E3) *(C3-B3) *E3) ,D3+SQRT((D3-B3) *(D3-C3) *(1-E3) ) )  D)  =PsiTriangular(B3,C3,D3)


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:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions