Solved

Exhibit 15 -Refer to Exhibit 15

Question 38

Essay

Exhibit 15.4
The following questions are based on the information below.
A company needs to manage a project which consists of the following set of activities:
 Activity  Days  Required  Predecessar  Activties  A 1 B 4 A  C 3B D 3C E 2B F 4EG2D.F\begin{array} { c c c } \text { Activity } & \begin{array} { c } \text { Days } \\\text { Required }\end{array} & \begin{array} { c } \text { Predecessar } \\\text { Activties }\end{array} \\\hline \text { A } & 1 & - \\\text { B } & 4 & \text { A } \\\text { C } & 3 & B \\\text { D } & 3 & \mathrm { C } \\\text { E } & 2 & B \\\text { F } & 4 & E \\G & 2 & D . F\end{array}
-Refer to Exhibit 15.4. The following spreadsheet was developed to determine the earliest start times and latest start times for the project. What formulas should go into cells E2:E8 to calculate Earliest Start Times?
 A  B  C DEFGHI1 Activity  Description  Predlecessor  Time  EST  EFT  LST  LFT  Slack 2 A  Activity A 1010103 B  Activity B  A 4151504 C  Activity C  B 3585805 D  Activity D  C 381181106 E  Activity E  B 2575707 F  Activity F  E 471171108 G  Activity G  D, F 2111311130\begin{array}{|c|c|c|c|c|c|c|c|c|c|}\hline & \text { A } & \text { B } & \text { C } & \mathrm{D} & \mathrm{E} & \mathrm{F} & \mathrm{G} & \mathrm{H} & \mathrm{I} \\\hline 1 & \text { Activity } & \text { Description } & \text { Predlecessor } & \text { Time } & \text { EST } & \text { EFT } & \text { LST } & \text { LFT } & \text { Slack } \\\hline 2 & \text { A } & \text { Activity A } & & 1 & 0 & 1 & 0 & 1 & 0 \\\hline 3 & \text { B } & \text { Activity B } & \text { A } & 4 & 1 & 5 & 1 & 5 & 0 \\\hline 4 & \text { C } & \text { Activity C } & \text { B } & 3 & 5 & 8 & 5 & 8 & 0 \\\hline 5 & \text { D } & \text { Activity D } & \text { C } & 3 & 8 & 11 & 8 & 11 & 0 \\\hline 6 & \text { E } & \text { Activity E } & \text { B } & 2 & 5 & 7 & 5 & 7 & 0 \\\hline 7 & \text { F } & \text { Activity F } & \text { E } & 4 & 7 & 11 & 7 & 11 & 0 \\\hline 8 & \text { G } & \text { Activity G } & \text { D, F } & 2 & 11 & 13 & 11 & 13 & 0 \\\hline\end{array}

Correct Answer:

verifed

Verified

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

Related Questions