Homework answers / question archive / HROM530 After completing the decision tree anatysis and reporting to senior management, it is determined that a more dynamic and more robust view of the decision environment is necessary

HROM530 After completing the decision tree anatysis and reporting to senior management, it is determined that a more dynamic and more robust view of the decision environment is necessary

Management

Share With

---

HROM530 After completing the decision tree anatysis and reporting to senior management, it is determined that a more dynamic and more robust view of the decision environment is necessary. You decide that the way to do this is to carry out a Monte-Carlo analysis using the mean revenue by location, the projected high, average, and low scenarios, and accompanying probabilities. In this assignment, you will:

 

1. Begin with the decision tree data in the International Expansion spreadsheet (xlsx). 1 This time, instead of the Decision Tree tab, select the Mante-Carlo tab to perform the analysis.

 

2. Carry out a minimum of 50 trials selecting high. average. and low values using the assigned probabilities of each (refer to the readings and resources in this module to identify how to perfarm these tasks in Excel).

 

3. Compare your findings with the decision-tree results you arrived at in Module 4.

 

4. Create a report on your findings with your recommendations on the best possibility for international expansion.

 

§. Include in your report a tornado diagram sensitivity analysis comparing casts with revenue for each of the identified events that could impact revenue and cost (Airline merger. New competitor. Product problem, Strike, Recession). Document your observations. Feel free to use the tornado diagram template for this purpose. Tornado-Chart-Excel-Template.xisx +

 

6. Assume that you manage this organization and are committed to HRO principles. What action do the data and analysis suggest that you take with respect to international expansion?