60.1K

Verified Solution

Link Copied!

anyone good at excel?? please help

component, so no-one else can produce it without the company's permission, and therefore, it is one of the most profitable products that the firm sells, providing SSM in annual revenues for the firm. Recently, however, the firm made certain improvements to the alloy used in the production of the part, something the engineers considered necessary to ensure the part meets new safety standards. Without certain modifications, the existing equipment used in the production of the part in question would not be able to handle the new alloy. In choosing how to address the problem, the company has three alternatives. All alternatives will be able to use the new alloy, will result in the same quality of finished produce, satisfying the company's and its customer's demands, but differ in annual maintenance costs, initial price, and longevity. The first alternative is to keep existing equipment, but update it to handle the new alloy. The old equipment was bought three years ago, at the price of USSI.8M and is being depreciated on the straight-line basis over 8-year useful life to its expected salvage value of zero. In fact, the old equipment is already worthless on the market, because moving it somewhere else costs as much as other firms are willing to pay for it. The necessary updates, which need to be depreciated over 3 years, will not prolong the life of the equipment, but will allow to increase the quality of finished product to the necessary level. The expected cost of the necessary updates is S500K. The old equipment requires $600,000 in annual maintenance expense. The second alternative is to replace the old equipment with new one. The new equipment would cost US$1,000,000 to buy and install, requires 500,000 in annual maintenance expense, but has a useful life of 5 years. It is also depreciated using straight-line method but has a salvage value of $200,000 at the end of its life. The third alternative is to outsource the production of the part to an external contractor. The management expected that external contractors would charge $800K per year to produce the required quantity of the product, at the required quality, using the newly-developed alloy. What alternative would be the least costly for the company and what alternative should the company choose? The company's weighted average cost of capital is 10% and its marginal rate of income tax is 21%

Answer & Explanation Solved by verified expert

See Answer