Shifts/day	Saving/year	Probability	Useful Life (years)	Probability
1	$15,000	0.3	3	0.6
2	30,000	0.5	5	0.4
3	45000	0.2

a) What are the expected savings per year, life, and the corresponding present worth for the expected values?

b) Compute the present worth for each combination of savings per year and life. What is the expected present worth?

c) Do the answers for (a) and (b) match? Why or why not?

Please use Excel to complete the problem and show your formula

(Use cell references for all calculations, discrete numbers are not allowed in calculations)