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 $
A second hand boiler is purchase in the amount of ₱ 210,000 with a useful life of 5 years and asalvage value of ₱ 20,000, compute its capitalized cost if interest is 15% compounded annually.
Problem 8. Compute the future worth in year 10 at i = 12% per year for the cash flow shown below. 9 10 Year
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