We will create a table of annual cost savings with a 5% increase
each year. Then we will calculate the PW by discounting it with
MARR which is given as 18%.
The next step is calculating the expected value and then summing to
get the total expected value.
Year | Cost Saving | ||
Optimistic | Most Likely | Pessimistic | |
1 | 65000.00 | 42500.00 | 17000.00 |
2 | 68250.00 | 44625.00 | 17850.00 |
3 | 71662.50 | 46856.25 | 18742.50 |
4 | 75245.63 | 49199.06 | 19679.63 |
5 | 79007.91 | 51659.02 | 20663.61 |
PW @ 18% | PW @ 18% | PW @ 18% | |
1 | 55084.75 | 36016.95 | 14406.78 |
2 | 49016.09 | 32048.98 | 12819.59 |
3 | 43616.01 | 28518.16 | 11407.26 |
4 | 38810.86 | 25376.33 | 10150.53 |
5 | 34535.08 | 22580.63 | 9032.25 |
PW | 221062.78 | 144541.05 | 57816.42 |
Probability | 0.20 | 0.60 | 0.20 |
Expected Value | 44212.56 | 86724.63 | 11563.28 |
Total E(PW) | 142500.47 | ||
Initial Cost | 130000.00 | ||
Net Value | 12500.47 |
The expected PW of the new equipment is $142500.47
The cost of the new equipment is $130000
142500.47 - 130000 = 12500.47
The net benefit of the new equipment is $12500.
Option B is correct.
New equipment used to control the thickness of fibre cement sheet cladding is being developed. It...
An improved design of a computerized piece of continuous quality measuring equipment used to control the thickness of rolled sheet products is being developed. It is estimated to sell for $125,000 more than the current design. Based on present test data, however, the typical user has the following probabilities of achieving different performance results and cost savings (relative to the current unit) in the first year of operation (assume these annual cost savings would escalate 5% per year thereafter; a...
I am having a hard time understanding the formula used to calculate the NPV. I see the answer, but can't back into the answer. I see the formula PV(rate,nper, pmt, (fv), [type]), for each of the NPV values, but I need help understanding what each number means. Thanks Problem statement below The RW Company is proposing to replace its old welt-making machinery with more modern equipment. The new equipment costs $9 million (the existing equipment has zero salvage value). The...
Because of its inability to control film and personnel costs in its radiology department, Sanger General Hospital wants to replace its existing picture archive and communication (PAC) system with a newer version. The existing system, which has a current book value of $2,250,000, was purchased three years ago for $3,600,000 and is being depreciated on a straight-line basis over an eight-year life to a salvage value of $0. This system could be sold for $800,000 today. The new PAC system...
TORENTO CONSTRUCTION: ETHICAL CONTRACTING On December 27, 2010, Cary Holmes, manager of the Supply Chain Management (SCM) group at Torento Construction Inc. (NCG), was in his office in Torento, Ontario, trying to organize the thoughts running through his head as a result of a recent bidding to save operating costs at NCG. There was no problem in terms of the final outcome; in fact, the bid was going to result in cost savings of 25 per cent, which was exactly...
How can we assess whether a project is a success or a failure? This case presents two phases of a large business transformation project involving the implementation of an ERP system with the aim of creating an integrated company. The case illustrates some of the challenges associated with integration. It also presents the obstacles facing companies that undertake projects involving large information technology projects. Bombardier and Its Environment Joseph-Armand Bombardier was 15 years old when he built his first snowmobile...