Do part a).

Question 2 (50%) The management of a company is considering replacing a number of old looms in the mill's weave room. The looms to be replaced are two 220-cm President looms, sixteen 135-cm President looms, and twenty-two 185-cm Draper X-P2 looms. The company may either replace the old looms with new ones of the same kind or buy 21 new shutterless Pignone looms. The first alternative requires the purchase of 40 new President and Draper looms and the scrapping of the old looms. The second alternative involves scrapping the 40 old looms, relocating 12 Picanol looms, and constructing a concrete floor, plus purchasing the 21 Pignone looms and various related equipment Following are the revenue and expense predictions: Description Machinery/related equipment Annual revenues due to the new looms Annual labour cost Annual O&M cost CCA Rate Project life Salvage value Alternative 1 $2,000,000 $2,100,000 $190,000 $1,050,000 33% 4 years $110,000 Alternative 2 $1,000,000 $1,630,000 $380,000 $750,000 33% 4 years $65,000 Page 2 of 3 The corporate executives feel that various investment opportunities available for the mill will guarantee a rate of return on investment of at least (MARR) 12%. The mill's marginal tax rate is 40%. Due to uncertainty, the following variabilities in estimates should be considered: revenues 25%, labour cost 30%, and annual O&M cost 10%. Assume that each of these variables can independently deviate from its base value For Alternative 1 only perform the following: a) Assuming that uncertain variables change once at a time, use NPW to conduct sensitivity analysis. Ideally, you should plot the relationship between percentage change in a variable and NPW. For Alternatives 1 and 2 perform the following: b) Now consider that each variable can take only three possible outcomes within the range of possible outcome: lowest value, base value, and highest value. Each outcome can happen with a probability as follows: Revenues Base Case OX Probability 0.75 labour cost Lowest Case -25% Probability 0.15 -30% Probability 0.10 -10% Probability 0.05 03 Highest Case +25% Probability 0.10 +30% Probability 0.10 +10% Probability 0.15 Probability 0.80 annual O&M cost 0% Probability 0.80 Considering the distributions of the three uncertain variables, predict the probability distribution of NPW for each alternative. There is a total of 27 possible NPW outcomes (3x3x3). You need to calculate the probability and value of each NPW outcome. Assume all uncertain input variables to be statistically independent. c) If Alternative 1 is chosen over Alternative 2, what is the probability that this decision is correct? Hints: do not forget to calculate income taxes and disposal tax effects (taxes or refund when asset is sold) - You can use spreadsheet applications (eg, Excel) to do repeated calculations in this question. This is permitted only if you communicate your solution in a way which enables the teaching assistant to independently replicate your final answer. You can show sample calculations as a way to communicate with the teaching assistant Please assume that the given MARR is market interest rate and all dollars are current