A Company Wants to Use PERT to Manage a Project

question 41

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?
$\begin{array}{|c|c|c|c|c|c|c|c|c|c|c|c|c|}\hline& \text { A } & \text { B } & \text { C } & \text { D } & \text { E } & \text { F } & \text { G } & \text { H } & \text { I } & \text { J } & \text { K } & \text { L } \\\hline 1 & \text { Time } & & & & \text { Random } & \text { Activity } & & & & & &\\&\text {Estimates }\\\hline 2 & \text { Act } & \mathrm{a} & \mathrm{m} & \mathrm{b} & \text { Number } & \text { Time } & \text { EST } & \text { EFT } & \text { LST } & \text { LFT } & \text { SLACK } & \\\hline 3 & \text { A } & 8 & 10 & 14 & 0.73 & 11.46 & 0 & 11.462 & 0.00 & 11.46 & 0.00 & * * \\\hline 4 & \text { B } & 2 & 3 & 4 & 0.19 & 2.62 & 11.462 & 14.081 & 12.90 & 15.52 & 1.44 & \\\hline 5 & \text { C } & 3 & 4 & 5 & 0.56 & 4.06 & 11.462 & 15.521 & 11.46 & 15.52 & 0.00 & * * \\\hline 6 & \mathrm{D} & 5 & 8 & 12 & 0.94 & 10.72 & 15.521 & 26.24 & 15.52 & 26.24 & 0.00 & * * \\\hline 7 & \mathrm{E} & 1 & 2 & 4 & 0.35 & 2.03 & 26.24 & 28.272 & 28.08 & 30.11 & 1.84 & \\\hline 8 & \mathrm{~F} & 3 & 5 & 7 & 0.09 & 3.87 & 26.24 & 30.109 & 26.24 & 30.11 & 0.00 & * * \\\hline 9 & \mathrm{G} & 1 & 2 & 3 & 0.59 & 2.09 & 30.109 & 32.202 & 30.11 & 32.20 & 0.00 & * * \\\hline&&\mathrm{M} \\&&\mathrm{O} \\&&\mathrm{D} \\&&\mathrm{E} \\&&\mathrm{L}\\\hline\end{array}$

• A)=IFE3?C3-E3)/D3-B3),D3-SQRTD3-B3)*D3-C3)*1-E3)),B3+SQRTD3-E3)*C3-B3)*E3))
• B)=IFE3?D3-B3)/C3-E3),B3+SQRTD3-E3)*C3-B3)*E3),D3-SQRTD3-B3)*D3-C3)*1-E3)))
• C)=IFE3?C3-E3)/D3-B3),B3-SQRTD3-E3)*C3-B3)*E3),D3+SQRTD3-B3)*D3-C3)*1-E3)))
• D)=PsiTriangularB3,C3,D3)

---

Definitions:

Multi-national Group

An organization or collection of individuals from multiple countries who work together toward a common goal or are part of the same corporation operating in various nations.

Effective Listening

The skill of attentively hearing and understanding what someone else is communicating, critically assessing, and responding thoughtfully.

Communication Skill

Communication skill encompasses the ability to effectively convey and receive information, ideas, and emotions through verbal, non-verbal, written, and digital means.

Training

The act of providing individuals with the knowledge and skills needed to perform specific tasks or jobs effectively.