Using Excel:

An Engineering & Tech firm is evaluating four projects A, B, C and D that have risks in terms of probabilities associated with the annual net benefits (i.e., EUAWs) as shown in the table below. Determine the expected EUAW of each project. Based on this, which project is the best alternative?

Project A		Project B		Project C		Project D
EUAW	Prob.	EUAW	Prob.	EUAW	Prob.	EUAW	Prob.
$1,500	0.3	$3,500	0.5	$5,500	0.2	-$1,600	0.2
$2,000	0.4	-$2,000	0.2	$3,000	0.6	$2,800	0.5
$3,000	0.3	$2,500	0.3	-$3,800	0.2	$4,500	0.3