Posted: April 7th, 2023

Each student will receive from the instructor an excel file with a different dat

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

Each student will receive from the instructor an excel file with a different dataset for payoffs (A to I) and probabilities (x,y,z, i,k,d,e,f,g,h,n). Students have to prepare and submit a managerial report and answer the questions:
1. Which one of the three development projects should be selected?
2. Should the company use the probabilities provided by the business analyst?
I have calculated the data and need you to write a report corresponding to the data.
Submission Requirements
Task 2-0 （1pt）(one grading point): Students should structure and present their Assignment 2 as a Managerial Report. The expected length of the main body (tasks 2-1 to 2-4) is up to 3 pages in APA format, excluding the cover page, table of content, executive summary (Task 2-5), and appendices (screenshots of the Payoff Table, EMV Table, Sensitivity Analysis Diagram, Tree Plan Diagram of the Decision Tree). Students must submit two documents: (i) a Managerial Report (word file) and (ii) an excel file with completed worksheets for each one of the tasks below.
Task 2-1 （2pt）(two grading points): Prepare payoff tables and develop a sketch of a decision tree for this problem (identify the events and decision nodes; don’t show probabilities and EMVs on your drawing of the decision tree).
Task 2-2 （2pt）(two grading points): Given the probability of all three economic conditions and using expected monetary values (EMVs), calculate EMVs for each node and answer the questions: (i) What’s the EMV for not hiring a business analyst and the EMV for hiring a business analyst? (ii) What is your recommendation for the final decision: to consider or not the probabilities, as given by the business analyst?
Task 2-3（2pt） (two grading points): Use sensitivity analysis to define how sensitive your decision is to the probability range concerning the survey results, positive and negative, which might affect the decision already made in Task 2-2. Draw the sensitivity chart, and find the probability for the cross point between the decision option (i) to use only the possibilities, as defined by the management of the real estate company, or (ii) to accept the probabilities of survey results positive and survey results negative, as given by the business analyst.
Task 2-4（2pt） (two grading points): Apply the software application Excel Add-Ins TreePlan (use one of the V-PCs of the MET V-LABs) to construct a decision tree with payoffs, probabilities, and EMVs.
Task 2-5（1pt） (one grading point): Prepare an executive summary. Hint: complete this task after completing tasks 2-1 to 2-4.

For This or a Similar Paper Click To Order Now