Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Select the parameter to analyze. Assume independence with other parameters. Select the probable range and increment. Select the measure of worth. Calculate the measure of

  1. Select the parameter to analyze. Assume independence with other parameters.
  2. Select the probable range and increment.
  3. Select the measure of worth.
  4. Calculate the measure of worth values.
  5. Interpret the results. Graph measure vs. parameter for better understanding.

For this activity, use your model from 5.5 Assignment: Mutually Exclusive Projects Model and perform a sensitivity analysis by changing the estimated savings for the second filter (Clean Air Filter). The savings are potentially an issue, and your experience with similar systems indicates the decrease in savings could range from $96 to $104 ($100 was previously modeled). Using 2 dollar increments, calculate the breakeven ROR (i*) for the incremental model. Generate a graph of decrease in annual savings for filter 2 (Clean Air Filter) vs. ROR. Identify the decrease in savings amount where the ROR = MARR. On the graph, identify the region where you would select Clean Air Filter and where you would select Sweet Air Filter.

Tab 1 should be as described above. Tab 2 should be a ready-to-use generic version of the model that can be used for similar analysis. Make sure your model includes instructions and clearly identifies where users would provide inputs.

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

Step: 3

blur-text-image

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

More Books

Students also viewed these Finance questions