Engineering economics Alfredo Auto Parts has two options for increasing efficiency. It can expand the current building or keep the same building but remodel the inside layout. For a five-year study period, the cash flows for the two options are shown below. Construct a spreadsheet that will calculate the present worth for each option with a variable MARR. By trial and error, determine the MARR at which the present worths of the two options are equivalent Expansion Option Year 0 1 2 3 4 5 Disburse- ments $850 000 25 000 30 000 35.000 40 000 45 000 Net Cash Flow 0 - $850 000 175 000 195 000 215 000 235 000 255 000 Receipts S 200 000 225 000 250 000 275 000 300 000 Remodelling Option Disburse- ments $230 000 9000 11 700 15 210 19 773 25 705 Receipts Net Cash Flow $0-$230 000 71 000 68 300 64 790 60 227 54 295 80 000 80 000 80 000 80 000 80 000

Engineering economics Alfredo Auto Parts has two options for increasing efficiency. It can expand the current building or keep the same building but remodel the inside layout. For a five-year study period, the cash flows for the two options are shown below. Construct a spreadsheet that will calculate the present worth for each option with a variable MARR. By trial and error, determine the MARR at which the present worths of the two options are equivalent Expansion Option Year 0 1 2 3 4 5 Disburse- ments $850 000 25 000 30 000 35.000 40 000 45 000 Net Cash Flow 0 - $850 000 175 000 195 000 215 000 235 000 255 000 Receipts S 200 000 225 000 250 000 275 000 300 000 Remodelling Option Disburse- ments $230 000 9000 11 700 15 210 19 773 25 705 Receipts Net Cash Flow $0-$230 000 71 000 68 300 64 790 60 227 54 295 80 000 80 000 80 000 80 000 80 000

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

Henry Mueller Supply Co. sells vibration control equipment for wind turbines exposed to harsh environmental factors. Annual cash flows for an 8-year period are shown in the table. Determine the future worth of the cash flows at an interest rate of 10% per year. Year 1 2 3 4 5 6 7 8 Revenue, $1000 200 200 200 200 200 200 200 200 Expenses, $1000 90 90 90 90 90 90 90 90
None
None
Charlie has $12,000 to invest for a period of 5 years. The following three alternatives are available to him: Account 1 pays 4.00% for year 1, 5.00% for year 2, 8.00% for year 3, 9.00% for year 4, and 12.00% for year 5, all with annual compounding. • Account 2 pays 12.00% for year 1, 9.00% for year 2, 8.00% for year 3,5.00% for year 4, and 4.00% for year 5, all with annual compounding. Account 3 pays interest at the rate of 7.56183% per year for all 5 years. Based on the available balance at the end of year 5, which alternative is Charlie's best choice? Year 5 Balance, Alternative 1: $ Year 5 Balance, Alternative 2: $ Year 5 Balance, Alternative 3: $ Carry all interim calculations to 5 decimal places and then round your final answer to the nearest dollar. The tolerance is £5.
Using Incremental with EUAW analysis find the best alternative, MARR = %10. should use Excel and show your equations seperately, see below example: [A Benefit - [IC (A/P, i%, n) - Salvage (A/F, i, n)] + A Cost+ G Cost (A/G, i, n)] Data B C A First Cost $2,300,000 $2,780,000 $2,540,000 Salvage Value $82,000 $118,000 $97,000 Annual Benefit $580,000 $670,000 $650,000 M&O $65,000 $78,000 $71,000 M&O Gradient $11,000 $15,000 $12,500 Useful Life, Years 9 9 9 You - ZOOM
show complete solution
Please no written by hand solution Assume that 25 years ago your dad invested $240,000, plus $31,000 in years 2 through 5, and $45,000 per year from year 6 on. Determine the annual retirement amount that he can withdraw forever starting next year (year 26), if the $45,000 annuity stopped at year 25. The interest rate being 12% per year. The annual retirement amount is determined to be $
The American Pharmaceutical Company (APC) has a policy that all capital investments must have a three-year or less discounted payback period in order to be considered for funding. The MARR at APC is 7% per year. Is the above project able to meet this benchmark for funding? Click the icon to view the interest and annuity table for discrete compounding when the MARR is 70er year. The payback period is years. (Round to the nearest whole number.) End of Year 1 2 3 4 5 6-8 Cash Flow - $275,000 - $25,000 $50,000 $180,000 $235,000 $330,000 $95,000
answer as soon as possible
Kim has $35057 to invest for 10 years. She has the following options: [A]term deposit at 5% compounded annually; [B] Shares, paying a rate of 4.98% per annum with dividend paid quarterly; and [C] A building society account, paying a return of 5.06% per annum with monthly rests. Advise Kim on which option to take if all the investments are equally secure. Calculate all the resulting values per situation
Lignin is a basic component of almost any plant that grows, so it is one of the most abundant organic compounds in the world. Almost anything derived from oil can be made out of lignin. The question is "can we do it cost-effectively and consistently?" A startup company has developed a process to derive plastics, carbon fiber and other advanced materials from lignin. The cash flow diagram for this process is shown below (in $ millions). If the company's hurdle rate (MARR) is 15% per year, is this a profitable undertaking? Click the icon to view the diagram for cash flows. Click the icon to view the interest and annuity table for discrete compounding when the MARR is 15% per year. The present worth of the venture is $ million. (Round to two decimal places.) According to the PW Decision Rule, the investment V economically justified.
Carlisle Company has been cited and must invest in equipment to reduce stack emissions or face EPA fines of $16,500 per year. An emission reduction filter will cost $75,000 and have an expected life of 5 years. Carlisle's MARR is 10%/year. Part a What is the future worth of this investment? $