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:

Sanitization

The process of cleaning and disinfecting a surface or environment to reduce the quantity of pathogens to safe levels.

Sterilization

A method of killing or removing all forms of life, including microorganisms, from a surface, fluid, or medication.

Consumable Supply

Items that are intended to be used up and replaced in a short amount of time, such as food, medical supplies, or office materials.

Biological Agents

Microorganisms or biologically-derived substances used in healthcare or industry, potentially including bacteria, viruses, or biological toxins.