Question

Please show code if you use excel thank you. Project A has a first cost of...

Please show code if you use excel thank you.

Project A has a first cost of $3,500, annual operating and maintenance costs of $1,900, annual savings of $2,300, and a salvage value of $1,800 at the end of its 5 year useful life.

Project B has a first cost of $6,000, annual operating and maintenance costs of $1,600, annual savings of $2,500, and a salvage value of $2,000 at the end of its 7 year useful life.

Using a MARR of 5%, answering the following questions:

What is the equivalent uniform annual worth (EUAW) of project A?

What is the equivalent uniform annual worth (EUAW) of project B?

Assuming a project will be replaced with an identical project at end of life, which project should be adopted by the company?

Notes:

Enter your answer as 12345

Round your answer. Do not use a dollar sign ("$"), any commas (",") or a decimal point (".").

0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Please show code if you use excel thank you. Project A has a first cost of...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • A project has a first cost of $113,164, will produce a $65,390 net annual benefit

    A project has a first cost of $113,164, will produce a $65,390 net annual benefit, and has annual maintenance costs of $25,793 over its 25-year life. It has a salvage value of $36,264 at the end of its life. Using a MARR of 2%, what is the benefit-cost ratio of the project? Enter your answer as: 1.23 (Calculate to 2 decimal places only.)

  • selected? urm is considering three mutually exclusive alter- atives as part of a production improvement program....

    selected? urm is considering three mutually exclusive alter- atives as part of a production improvement program. The alternatives are as follows: First cost $15,000 Maintenance 1,600 and operating Annual benefit 8,000 Salvage value 3,000 Useful life, in years4 Installed cost Uniform annual benefit Useful life, in years A B C $10,000 $15,000 $20,000 1.625 1.625 1,890 10 20 For each alternative, the salvage value at the end of useful life is zero. At the end of 10 years, Alt. A...

  • Two investment opportunities are as follows А $150 B $100 22.25 First cost Initial investment) Uniform...

    Two investment opportunities are as follows А $150 B $100 22.25 First cost Initial investment) Uniform annual benefit End-of-useful-life salvage value Useful life, in years 20 15 10 At the end of 10 years, Alt. B is not replaced. Thus, the comparison is 15 years of A versus 10 years of B. If the MARR is 10%, which alternative should be selected?

  • The answer is shown in the picture, i want to know how they got it, please show all your work and if you are using excel please show your formulas, Thank You and good luck. Toll lanes on a section of...

    The answer is shown in the picture, i want to know how they got it, please show all your work and if you are using excel please show your formulas, Thank You and good luck. Toll lanes on a section of the 1-40 freeway are being considered in order to reduce traffic congestion and travel times Since this is a government project, the B-C ratio method must be applied in the evaluation. Construction costs of the project are estimated to...

  • Margaret has a project with a $30,000 first cost that returns $5,600 per year over its...

    Margaret has a project with a $30,000 first cost that returns $5,600 per year over its 10-year life. It has salvage value of $3,800 at the end of 10 years. If the MARR is 15 %. (Use 5 significant figures for your calculations, and round your answers to the nearest dollar. Indicate losses as a negative value.) (a) What is the present worth of this project? (b) What is the annual worth of this project? (c) What is the future...

  • Fresh Foods is considering the purchase of a new packaging system. The system costs $218,071. The...

    Fresh Foods is considering the purchase of a new packaging system. The system costs $218,071. The company plans to borrow three-quarters (3/4) of the purchase price from a bank at 9% per year compounded annually. The loan will be repaid using equal, annual payments over a 6-year period. The payments will be made at the end of each year for the life of the loan, with the first payment occurring at the end of year 1. The system is expected...

  • 5.(20 pts) A special power tool for plastic products is classified $6,500, has a salvage value...

    5.(20 pts) A special power tool for plastic products is classified $6,500, has a salvage value of $800 when sold at the end of 5 years, uniform annual end-of-ycar benefits (before tax) of $3,500 per year, and uniform annual operating and maintenance costs (before tax) of $1,200 per year. Compute the after-tax present worth (for an MARR of 10% ) , based on MACRS depreciation and a 34% corporate income tax rate. (MACRS percentages for a three-year property are 33.33%,...

  • Please don't use excel and show all work. Consider two alternatives: B A $300 $500 $75...

    Please don't use excel and show all work. Consider two alternatives: B A $300 $500 $75 Cost $75 Uniform annual benefit X Infinity Useful life, in years Assume that Alt. B is not replaced at the end of its useful life. If the MARR is 10%, what must be the useful life of B to make Alternatives A and B equally desirable?

  • Use Excel. AEW-UEL Your company have three mutually exclusive projects which are explained in the table...

    Use Excel. AEW-UEL Your company have three mutually exclusive projects which are explained in the table below. You are an engineer and your supervisor asks for your opinion. What is your recommendation and why? What project(s) would you recommend? Initial Investment Annual savings salvage value project life MARR Project A $ 15,000 $ 2,050 $ 3,000 Project B $ 10,000 $ 1,900 $ 2,300 5 6% Project C $ 11,000 $ 1,000 $ 5,000 15 6%| 6%

  • Fresh Foods is considering the purchase of a new packaging system. The system costs $215,594. The...

    Fresh Foods is considering the purchase of a new packaging system. The system costs $215,594. The company plans to borrow three-quarters (3/4) of the purchase price from a bank at 8% per year compounded annually. The loan will be repaid using equal, annual payments over a 7-year period. The payments will be made at the end of each year for the life of the loan, with the first payment occurring at the end of year 1. The system is expected...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT