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)

Question

Quizplus · Accepted Answer

The Answer of 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)

A Company Wants to Use PERT to Manage a Project