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) =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)

---

Definitions:

Cross-cultural Teamwork

Involves team members from diverse cultural backgrounds working together, which can offer creative solutions but may also present challenges in communication and collaboration.

Collectivism

A social theory prioritizing group goals over individual ones, emphasizing cooperation and team harmony.

Social Group

A collection of individuals who interact with each other, share similar characteristics, and collectively have a sense of unity or belonging.

Group Goals

Collective objectives or outcomes that a team or group aims to achieve through collaboration.