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
icon
Related questions
Question
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
19773
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
Transcribed Image Text: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 19773 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
Expert Solution
steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Renewable And Exhaustible Natural Resources
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
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)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
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-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education