Excel Analysis and 4-page paper reportTackle the business situation in the attached scenario. Use attached excel for scenario and data set. Perform a

Excel Analysis and 4-page paper reportTackle the business situation in the attached scenario. Use attached excel for scenario and data set. Perform a decision tree analysis and recommend a solution. This recommendation will be included in a report that you will write, summarizing the key details of your analysis.

A.  Describe a business question that could be answered by applying decision tree analysis and is derived from the scenario in the attached “Decision Tree Analysis Resources.”

B.  Identify the relevant data values required for your decision tree analysis, including the following:

•   probabilities

•   payoffs

•   profits

•   demand

C.  Report how you analyzed the data using decision tree analysis by doing the following:

1.  Complete a decision tree diagram, including each of the following: 

•   state-of-nature nodes

•   calculated payoffs, each expressed out to two decimal places

•   expected values, each expressed out to two decimal places

2.  Justify why decision tree analysis is the appropriate analysis technique, including relevant details from the scenario to support your justification.

D.  Summarize the implications of your decision tree analysis by doing the following:

1.  Explain the role of probabilities and the role of demand for each branch.

2.  Explain how the expected value of each node is determined based on payoffs.

3.  Discuss one limitation of each of the following:

•   the data elements

•   the decision tree analysis

E.  Recommend a course of action that addresses the business question from part A and is based on the results of your decision tree analysis.

F.  Acknowledge sources, using in-text citations and references, for content that is quoted, paraphrased, or summarized.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Discussion Thread: Setting Direction, Advantages / Disadvantages, and Decision Models Strategy is critical to the process of charting a company’s

Discussion Thread: Setting Direction, Advantages / Disadvantages, and Decision Models Strategy is critical to the process of charting a company’s direction in the business environment. When evaluating strategic choices, it is important to understand key advantages and disadvantages of the various options under consideration. Decision models continue to impact strategy

REPLIES: INSTRUCTIONSThe student must reply to at least two classmates’ threads by 11:59 p.m. (ET) Sunday of theassigned Module: Week. Your replies must

REPLIES: INSTRUCTIONSThe student must reply to at least two classmates’ threads by 11:59 p.m. (ET) Sunday of theassigned Module: Week. Your replies must include meaningful and substantive contributions tothe discussion, and ideally provoke and challenge the thinking of your colleagues. Each replymust be 200-300 words.Replies: Specific Reference RequirementsFor Discussion Replies:

Discussion Thread: Exploring Employee Engagement, Globalization, and Christian Worldview Thread: Specific Reference RequirementsFor Discussion Thread:

Discussion Thread: Exploring Employee Engagement, Globalization, and Christian Worldview Thread: Specific Reference RequirementsFor Discussion Thread: Introducing HR and Christian Worldview and Discussion Thread: Shapingthe Future of HR, include a references section, and be sure to have in-text citations for thefollowing sources:• At least 2 citations from Valentine: Human Resource Management.•

Discussion Thread: Strategy Development, Strategy Decisions, and Decision ModelsDeveloping strategy begins with thinking strategically and knowing what

Discussion Thread: Strategy Development, Strategy Decisions, and Decision ModelsDeveloping strategy begins with thinking strategically and knowing what the key decisions are. Thedecision models that you employ will directly impact the quality of the decisions you make sounderstanding them is critical.Minimum of 500 words in the body.Minimum of 2 sources from

REPLIES: INSTRUCTIONSThe student must reply to at least two classmates’ threads by 11:59 p.m. (ET) Sunday of theassigned Module: Week. Your replies must

REPLIES: INSTRUCTIONSThe student must reply to at least two classmates’ threads by 11:59 p.m. (ET) Sunday of theassigned Module: Week. Your replies must include meaningful and substantive contributions tothe discussion, and ideally provoke and challenge the thinking of your colleagues. Each replymust be 200-300 words.Replies: Specific Reference RequirementsFor Discussion Replies:

Discussion Thread: Introducing HR and Christian Worldview Keller’s big-picture thinking relative to work in God’s world (Chapters 1–4) can be interpreted

Discussion Thread: Introducing HR and Christian Worldview Keller’s big-picture thinking relative to work in God’s world (Chapters 1–4) can be interpreted as follows: Design —God designed humans to work; Dignity —work gives humans dignity; Cultivation —God continues to “create” through the work of humans; Service —humans love God and neighbor