Machining Center Design Options Option 1 Option 2 Option 3 Investment: Total investment $230,000 $280,000 $210,000 Annual benefits: Year1 Year1: Net revenues $40,000 $60,000 $30,000 Year2-5: Net revenues Constant Constant =13% per year Market value in year 5 $100,000 $120,000 $90,000 If the MARR=15%, which option would be selected? On the same excel spreadsheet use excel functions to: a- Calculate the Present Worth of each option and choose the best alternative b- Calculate the Annual Worth of each option and choose the best alternative c- Calculate the IRR of each option and choose the best alternative

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter11: Strategic Cost Management
Section: Chapter Questions
Problem 4CE: Kagle design engineers are in the process of developing a new green product, one that will...
icon
Related questions
Question
100%
Staunch company is considering expanding its range of industrial machinery products by
manufacturing machine tables, saddles, machine bases, and other similar parts. Several
combinations of new equipment and personnel could serve to fulfill this new function.
Optionl: New machining center with three operators
Option 2: New machining center with an automatic pallet changer and three operator
Option3 :New machining center with an automatic pallet changer and two-sharing operators
Staunch company has estimated the investment costs and additional revenues in the following
table.
Machining Center Design Options
Option 1
Option 2
Option 3
Investment:
Total investment
$230,000
$280,000
$210,000
Annual benefits: Year1
Year1: Net revenues
$40,000
$60,000
$30,000
Year2-5: Net revenues
Constant
Constant
=13% per year
Market value in year 5
$100,000
$120,000
$90,000
If the MARR=15%, which option would be selected?
On the same excel spreadsheet use excel functions to:
a- Calculate the Present Worth of each option and choose the best alternative
b- Calculate the Annual Worth of each option and choose the best alternative
c- Calculate the IRR of each option and choose the best alternative
Transcribed Image Text:Staunch company is considering expanding its range of industrial machinery products by manufacturing machine tables, saddles, machine bases, and other similar parts. Several combinations of new equipment and personnel could serve to fulfill this new function. Optionl: New machining center with three operators Option 2: New machining center with an automatic pallet changer and three operator Option3 :New machining center with an automatic pallet changer and two-sharing operators Staunch company has estimated the investment costs and additional revenues in the following table. Machining Center Design Options Option 1 Option 2 Option 3 Investment: Total investment $230,000 $280,000 $210,000 Annual benefits: Year1 Year1: Net revenues $40,000 $60,000 $30,000 Year2-5: Net revenues Constant Constant =13% per year Market value in year 5 $100,000 $120,000 $90,000 If the MARR=15%, which option would be selected? On the same excel spreadsheet use excel functions to: a- Calculate the Present Worth of each option and choose the best alternative b- Calculate the Annual Worth of each option and choose the best alternative c- Calculate the IRR of each option and choose the best alternative
Expert Solution
steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Knowledge Booster
Financial Planning Model
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning