Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Conduct the following sensitivity analysis, using the project s ANNUAL WORTH. Create a table where you vary the following variables, one at a time: the

Conduct the following sensitivity analysis, using the projects ANNUAL WORTH. Create a table where you
vary the following variables, one at a time: the contribution margin per unit, the annual number of units sold,
the annual fixed cost, and the machines salvage value at the end of the project. Create a table, starting with
a Percent Change in its first column, with the following values: -50%,-40%,-30%,-20%,-10%,0,10%,20%,
30%,40%, and 50%. Follow with each variable and an Annual Worth column, corresponding to each of the
variables you vary. You can use the Excel example file posted under Week 7 as your guide (your tables and
set up will be slightly different, but similar). Vary each of the variables ranging from -50% to 50%, one at a
time, while keeping all of the other variables at their baseline values, recomputing the projects annual
worth each time. Insert a chart with the percent change on the horizontal axis, and the contribution margin,
number of units, fixed cost, and salvage value on the vertical axis. Comment on the sensitivity of the projects
annual worth to changes in each of the four variables, and the implications for accepting or rejecting the
project.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Operations Management Creating Value Along the Supply Chain

Authors: Roberta S. Russell, Bernard W. Taylor, Ignacio Castillo, Navneet Vidyarthi

1st Canadian Edition

978-1-118-3011, 1118942051, 1118942055, 978-1118301173

More Books

Students also viewed these General Management questions

Question

What are the major inputs into physical database design?

Answered: 1 week ago