What is the percentage of npv being greater than initially

Assignment Help Operation Management

Reference no: EM132279867

Use the attached file answer the following questions.

1. Use 2.5% as the average inflation rate and 14% as the hurdle rate, please obtain the NPV (net present value) of this sourcing project. Is this project worth doing? Why so?

2. Assuming inflows of 2028-2030 are not certain but will follow distributions below, please re-evaluate the Lorain Location. What is the percentage of NPV being greater than the initially obtained value in step 1 (not zero). (hint: set your lower threshold value to the previous NPV, see what is the percentage greater than that value.)

Year	Inflow Distribution
2028	T(50000, 120000, 180000)
2029	N(130000, 4000)
2030	U(60000, 120000)

Triangular distribution(lowest possible, most likely, highest possible value)

Normal distribution(average, standard deviation)

Uniform distribution(lowest possible, highest possible)

Submission Requirements:

Please submit the work in one single Excel file.
For problem 1, please leave your comments beneath the NPV value.
Copy the spreadsheet as a new spreadsheet and start to work on question #2. Please screen capture the final result (e.g., the blue distribution dialog box), then paste within the worksheet.

Attachment:- Decision Analysis.rar

Reference no: EM132279867

Questions Cloud

What are your overall comments about the statement : Many athletes are involved in a sport where body weight or overall physique is important....gymnastics, running, wrestling, and others. When working with these.

What you think will happen to mike po2 levels : Predict what you think will happen to Mike's PO2 levels, PCO2 levels, BP, pulse, and pH before and after treatment with albuterol.

How are z and t confidence intervals different : In describing confidence intervals on a mean, z and t intervals are frequently mentioned. How are z and t confidence intervals different?

Discuss the sacral nerve plexus : Discuss the sacral nerve plexus and discuss its location, innervation pattern and functional significance.

What is the percentage of npv being greater than initially : Assuming inflows of 2028-2030 are not certain but will follow distributions below, please re-evaluate the Lorain Location.

Explain the symptoms of the disorder : Explain the symptoms of the disorder. Describe how the diagnosis is made (e.g., findings on brain imaging, laboratory testing, etc.).

Respiratory surface and the rate of gas exchange : What is the relationship between the area of the respiratory surface and the rate of gas exchange?

Why do these plants tend to live in nutrient poor realms : why do carnivorous plants use insects to supplement their photosynthetic efforts. Why do these plants tend to live in nutrient poor realms?

Create business process model swimlane diagram : Create a Business Process Model "swimlane" diagram using basic BPMN for the order-to-cash processes for 1-888-Junk Van.

User Account

All Pages