Reference no: EM132043117

Using only excel solve the following: The parking superintendent is responsible for snow removal at his parking garage. The probabilities for the number of days per year requiring snow removal are shown in the chart below.

These probabilities are independent from year to year. The superintendent can contract for snow removal at a cost of $500 per day.

Alternatively, he can purchase a snow-removal machine for $40,000. It is expected to have a useful life of 10 years and no salvage value at that time.

Annual costs for operating and maintaining the machine are estimated to be $14,000. MARR (Minimum attractive rate of return) is 10% per year.

Number of Days per Year Probability 20 0.15 40 0.15 60 0.35 80 0.30 100 0.05 For the following questions, determine an analytical solution:

a)Determine the mean and standard deviation of the present worth of the savings resulting from purchasing the snow-removal machine.($)

b)Assuming the present worth is normally distributed, what is the probability of a positive present worth of the savings resulting from purchasing the machine?(%)

c)For the following questions, determine a simulation solution using @RISK:

d)Using a Latin hypercube simulation with 10,000 iterations, estimate the mean and standard deviation of present worth and the probability of positive present worth.

e)Using a Monte Carlo simulation with 10,000 iterations, estimate the mean and standard deviation of present worth and the probability of positive present worth.