Engineering economicsAlfredo Auto Parts has two options for increasing efficiency. It can expand the current buildingor keep the same building but remodel the inside layout. For a five-year study period, the cashflows for the two options are shown below. Construct a spreadsheet that will calculate thepresent worth for each option with a variable MARR. By trial and error, determine the MARR atwhich the present worths of the two options are equivalentExpansion OptionYear012345Disburse-ments$850 00025 00030 00035 00040 00045 000Net CashFlowReceipts$ 0 - $850 000175 000195 000215 000235 000255 000200 000225 000250 000275 000300 000Remodelling OptionDisburse-ments$230 000900011 70015 21019 77325 705Net CashFlowReceipts$ 0 - $230 00080 00071 00080 00068 30080 00064 79080 00060 22780 00054 295

By trial and error, the MARR at which the NPV is equal for both options is 6.29%

Answered: Alfredo Auto Parts has two options for…

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Similar questions

An indium-gallium-arsenide-nitrogen alloy developed at Sandia National Laboratory is said to have potential uses in electricity-generating solar cells. The new material is expected to have a longer life, and it is believed to have a 40% efficiency rate, which is nearly twice that of standard silicon solar cells. The useful life of a telecommunications satellite could be extended from 10 to 15 years by using the new solar cells. What rate of return could be realized if an extra investment now of $900,000 would result in extra revenues of $450,000 in year 11, $500,000 in year 12, and amounts increasing by $50,000 per year through year 15? The rate of return that could be realized was
A manufacturer offers an inventor the choice of two contracts for the exclusive right to manufacture and market the inventor's patented design. Plan 1 calls for an immediate single payment of $52,343. Plan 2 calls for an annual payment of $2,273 plus a royalty of $1.72 for each unit sold. The remaining life of the patent is 10 years. MARR is 10% per year. What must be the uniform annual sales to make Plan 1 and Plan 2 equally attractive? Round your answer. Enter your answer as: 12345
After you have conducted a future worth comparison of alternatives, what do you multiply the FW values by in order to obtain the AW values of the alternatives?
Rent-A-Wreck car rental agency has a contract with PM Warranty, Inc. to do major repairs for $700 per car. The car rental agency estimates that it could repair its own cars for $300 each if it acquires a facility for $300,000 now. A salvage value of $40,000 after 15 years is estimated for the facility. What is the minimum number of cars that must be repaired each year to make the acquisition attractive at an interest rate of 10% per year?
Using AW analysis. Texas Popcorn Corporation is planning to fully automate it process. The company CEO is currently looking into three options. Options A costs $450,000, AOC of $55,000, and salvage value of $85,000 after 3 years. Option B will cost $720,000 with an AOC of $68,000 and salvage of $95,000 after 4 years. Option C cost $800,000 with an AOC of $95,000 and salvage of $125,000 after 6 years. Which machine should the company select at an interest rate of 10% per year? Assume the project service life is 12 years.
Maintenance costs for a new system are estimated to be $250,000 in year 3 and $175,000/year in years 4 to 10 of an expected 10-year life system. If similar systems will replace the current one, determine the equivalent annual maintenance cost at i = 8% per year.
An indium-gallium-arsenide-nitrogen alloy developed at Sandia National Laboratory is said to have potential uses in electricity- generating solar cells. The new material is expected to have a longer life, and it is believed to have a 40% efficiency rate, which is nearly twice that of standard silicon solar cells. The useful life of a telecommunications satellite could be extended from 10 to 15 years by using the new solar cells. What rate of return could be realized if an extra investment now of $940,000 would result in extra revenues of $450,000 in year 11, $500,000 in year 12, and amounts increasing by $50,000 per year through year 15? The rate of return that could be realized was %.
Any help would be appreciated, thank you!
The PW-based relation for the incremental cash flow series to find 4/"between the lower first-cost alternative X and alternative Y has been developed. 0=-22,000+ 9000(P/A,4,10)+(-4000(P/F,A*,10)) Determine the highest MARR value for which Y is preferred over X. Any MARR value greater than % favors Y.
Certain parts for NASA’s reusable space exploration vehicle can either be anodized (A) or powder coated (P). Some of the costs for each process are shown in the table below. The incremental cash flow future worth equation associated with (P – A) is: 0 = −53,000(F∕P,i*P – A,5) + 21,000(F∕A,i*P – A,5) + 8000 Determine the following: (a) first cost for P; (b) M&O for A; and (c) resale value of P. Process Anodize, A Powder Coated, P First cost, $ −30,000 ? M&O, $/year ? −11,000 Resale value, $ 4000 ? Life, years 5 5
A manufacturing company is proposing two new methods to enhance and increase the production line of the company. Method A is expected to cost $1000 while method B is expected to cost $2400. The maintenance cost of the production line will increase to $800 per year if method A is applied and $650 per year with method B, which one of the two proposed methods is more economical based on a future worth analysis at an interest rate of 10% per year? Assume a 15-year life for the production line.
A new biomaterial used for prosthetic devices was developed by engineers in the laboratory that requires production equipment to start manufacturing. Two different equipment are considered. Equipment A will have an initial cost of $125,000 and annual cost of $55,000. Equipment B will have an initial cost of $175,000 and an annual cost of $35,000. For 20% MARR which process should be selected. What is the incremental rate of return?

SEE MORE QUESTIONS

Recommended textbooks for you

ENGR.ECONOMIC ANALYSIS

Economics

ISBN:

9780190931919

Author:

NEWNAN

Publisher:

Oxford University Press

Principles of Economics (12th Edition)

Economics

ISBN:

9780134078779

Author:

Karl E. Case, Ray C. Fair, Sharon E. Oster

Publisher:

PEARSON

Engineering Economy (17th Edition)

Economics

ISBN:

9780134870069

Author:

William G. Sullivan, Elin M. Wicks, C. Patrick Koelling

Publisher:

PEARSON

ENGR.ECONOMIC ANALYSIS

Economics

ISBN:

9780190931919

Author:

NEWNAN

Publisher:

Oxford University Press

Principles of Economics (12th Edition)

Economics

ISBN:

9780134078779

Author:

Karl E. Case, Ray C. Fair, Sharon E. Oster

Publisher:

PEARSON

Engineering Economy (17th Edition)

Economics

ISBN:

9780134870069

Author:

William G. Sullivan, Elin M. Wicks, C. Patrick Koelling

Publisher:

PEARSON

Principles of Economics (MindTap Course List)

Economics

ISBN:

9781305585126

Author:

N. Gregory Mankiw

Publisher:

Cengage Learning

Managerial Economics: A Problem Solving Approach

Economics

ISBN:

9781337106665

Author:

Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor

Publisher:

Cengage Learning

Managerial Economics & Business Strategy (Mcgraw-…

Economics

ISBN:

9781259290619

Author:

Michael Baye, Jeff Prince

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS