3. (15 points) For the alternatives show below, only one can be chosen. The first and...

Question

Question

3. (15 points) For the alternatives show below, only one can be chosen. The first and annual costs are estimated. Both option

business finance

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Select Robot X based on rate of return which is higher in this case

Year	Robot X	Robot Y
0	-84000	-146000
1	65000	91000
2	65000	91000
3	105000	138000

Rate of return	67.85%	47.78%

Workings

oso Book1 - Excel File Home Insert Page Layout Formulas Data Review View Help General Calibri 11 A À O BI U - - DA Paste Clip

Add a comment

Answer 2

Similar Homework Help Questions

3. (15 points) For the alternatives show below, only one can be chosen. The first and...

3. (15 points) For the alternatives show below, only one can be chosen. The first and annual costs are estimated. Both options are expected to have a 3-year useful life. If the MARR is 20% per year, determine which alternative should be selected based on rate of return. Calculate by hand or use spreadsheet. Robot X First Cost, $ Maintenance & Operations, $/year Salvage Value, $ Revenue, $/year Life -84,000 -31,000 40,000 96,000 Robot Y -146,000 -28,000 47,000 119,000 3...
A process control manager is considering two robots to improve materials-handling capacity in the production of...

A process control manager is considering two robots to improve materials-handling capacity in the production of rigid shaft couplings that make dissimilar drive components. Robot X has a first cost of $92,000, an annual M&O cost of $31,000, and $44,000 salvage value, and it will improve revenues by $96,000 per year. Robot Y has a first cost of $146,000, an annual M&O cost of $28,000, and $47,000 salvage value, and it will increase revenues by $129,000 per year. The company's...
A process control manager is considering two robots to improve materials-handling capacity in the production of...

A process control manager is considering two robots to improve materials-handling capacity in the production of rigid shaft couplings that make dissimilar drive components. Robot X has a first cost of $94,000, an annual M&O cost $31,000, and $35,000 salvage value, and it will improve revenues by $96,000 per year. Robot Y has a first cost of $146,000, an annual M&O cost of $28,000, and $47,000 salvage value, and it will increase revenues by $125,000 per year. The company's MARR...

Please write neatly. DO NOT USE EXCEL! Thank you. Question #4 (25 Points) Three alternatives are...

Please write neatly. DO NOT USE EXCEL! Thank you. Question #4 (25 Points) Three alternatives are being considered. The table below shows the associated cash flows with each alternative The company uses MARR of 20% per year Alternative A $40,000 $38,000 $25,000 $10,000 6 vears 26% Alternative BAlternative C Capital investment Annual Revenu Annual Cost Salvage value Useful life IRR $60,000 $53,000 $30,000 $10,000 6 years 3390 $30,000 $28,000 $16,000 $10,000 6 vears 35% Using incremental analysis, determine which is...
Either of the cost alternatives shown below can be used in a chemical refining process. If the company’s MARR is 15% per year, determine which should be selected on the basis of an incremental ROR ana...

Either of the cost alternatives shown below can be used in a chemical refining process. If the company’s MARR is 15% per year, determine which should be selected on the basis of an incremental ROR analysis. A B First cost ,$ − 40,000 − 61,000 Annual cost, $/year − 25,000 − 19,000 Salvage value, $ 8,000 11,000 Life, years 5 5 5 - A. B. C. D. E. F. The incremental rate of return computed using a present worth analysis...
1) Consider these two machines (alternatives): (12 Points) B A $5000 $1750 $700 $8200 $1850 $500...

1) Consider these two machines (alternatives): (12 Points) B A $5000 $1750 $700 $8200 $1850 $500 First Cost Uniform annual benefit Salvage Value Useful Life, in Years 4 If the MARR (minimum attractive rate of return) -7 % , which alternative should be selected? Use the Present worth Analysis method. 1) Consider these two machines (alternatives): (12 Points) B A $5000 $1750 $700 $8200 $1850 $500 First Cost Uniform annual benefit Salvage Value Useful Life, in Years 4 If the...

Consider the following EOY cash flows for two mutually exclusive alternatives (one must be chosen). The...

Consider the following EOY cash flows for two mutually exclusive alternatives (one must be chosen). The MARR is 5% per year. I need the PW of the Lead Acid and Lithium Ion. Problem 6-28 (algorithmic) EQuestion Help Consider the following EOY cash flows for two mutually exclusive alternatives (one must be chosen) The MARR is 5% per year ead Acid $7,000 thium lon Capital investment Annual expenses Useful life Market value at end of useful life $13,000 $2.500 $2,750 12...
0.6. Consider the following EOY cash flows for two mutually exclusive alternatives (one must be chosen):...

0.6. Consider the following EOY cash flows for two mutually exclusive alternatives (one must be chosen): Solar Panel A Solar Panel B Capital investment, $ 7,000 13.000 Annual operating expenses, SL 2.200 2.000 Market value, $ 1.000 2.30) Useful life, years 12 The MARR is 12% per year. Determine (using FW method) which alternative should be selected if the analysis period is 18 years, the repeatability assumption does not apply, and a solar panel can be leased for $6,000 per...
Rad oNI.Y) to do this. Show all your work. Print the spread sheet showing data and all your Analy...

Use excel and show how formulas and such work. please follow every steps thorougly rad oNI.Y) to do this. Show all your work. Print the spread sheet showing data and all your Analyses. your company is considering one of three alternatives to move part of their operations overseas. The company uses a MARR of 1 5%. Options 1: Equipment cost now- $1,000,000 l equipment purchase at the end of year 2 $500,000 Annual operation and maintenance (M & O)-$85,000 Life...

Consider the following EOY cash flows for two mutually exclusive alternatives (one must be chosen). The...

Consider the following EOY cash flows for two mutually exclusive alternatives (one must be chosen). The MARR is 12% per year. Capital Investment Annual expenses Useful life Market value at end of useful life Lead Acid $8,000 $2,250 12 years $0 Lithium lon $13,000 $2,300 18 years $2,800 Click the icon to view the interest and annuity table for discrete compounding when /= 12% per year. (a) Determine which altemative should be selected based on the PW method. Assume repeatabllity...

3. (15 points) For the alternatives show below, only one can be chosen. The first and...

Homework Answers