Solved

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?
 A  B  C  D  E  F  G  H  I  J  K  L 1 Time  Random  Activity Estimates 2 Act amb Number  Time  EST  EFT  LST  LFT  SLACK 3 A 810140.7311.46011.4620.0011.460.004 B 2340.192.6211.46214.08112.9015.521.445 C 3450.564.0611.46215.52111.4615.520.006D58120.9410.7215.52126.2415.5226.240.007E1240.352.0326.2428.27228.0830.111.848 F3570.093.8726.2430.10926.2430.110.009G1230.592.0930.10932.20230.1132.200.00MODEL\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)

Correct Answer:

verifed

Verified

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

Related Questions