Solved

What Formula Should Go in Cell H3 of the Following

Question 8

Multiple Choice

What formula should go in cell H3 of the following spreadsheet to compute Crash Cost Per Day?
A B C D EFGH1 Normal  Crash  Allowable  Crash  Cost 2 Activity  Description  Time  Cost  Time  Cost  Crash Days  Per  Day 3 A412000214000210004 B  - 360002650015005 C  - 218000119000110006 D  - 714000420000320007E235001400015008F2600017500115009 G 3900011200021500 COSTS \begin{array}{|c|c|c|c|c|c|c|c|c|}\hline & \mathrm{A} & \text { B } & \mathrm{C} & \text { D } & E & F & \mathrm{G} & \mathrm{H} \\\hline 1 & & & \text { Normal } & & \text { Crash } & & \text { Allowable } & \begin{array}{c}\text { Crash } \\\text { Cost } \\\end{array} \\\hline 2 & \text { Activity } & \text { Description } & \text { Time } & \text { Cost } & \text { Time } & \text { Cost } & \text { Crash Days } & \begin{array}{l}\text { Per } \\\text { Day }\end{array} \\\hline 3 & \mathrm{~A} & - & 4 & 12000 & 2 & 14000 & 2 & 1000 \\\hline 4 & \text { B } & \text { - } & 3 & 6000 & 2 & 6500 & 1 & 500 \\\hline 5 & \text { C } & \text { - } & 2 & 18000 & 1 & 19000 & 1 & 1000 \\\hline 6 & \text { D } & \text { - } & 7 & 14000 & 4 & 20000 & 3 & 2000 \\\hline 7 & E & - & 2 & 3500 & 1 & 4000 & 1 & 500 \\\hline 8 & F & - & 2 & 6000 & 1 & 7500 & 1 & 1500 \\\hline 9 & \text { G } & - & 3 & 9000 & 1 & 12000 & 2 & 1500 \\\hline & \text { COSTS } & & & & & & & \\\hline\end{array}


A) =C3-E3) /F3-D3)
B) =F3-D3) /C3-E3)
C) =F3) /C3-E3)
D) =F3-D3) /E3)

Correct Answer:

verifed

Verified

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

Related Questions