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: 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

Looking for someone to do my assignment below You will prepare a distribution improvement strategy for the Hunt Company.  Recently, the company began

Looking for someone to do my assignment below You will prepare a distribution improvement strategy for the Hunt Company.  Recently, the company began outsourcing its manufacturing to overseas companies.  Due to this recent change, they have suffered various issues and problems with their distribution processes.   Instructions:  Read the Hunt Company case

Prepare a 7-page demand management plan, including a forecasting, inventory management, and scheduling analysis, as well as recommendations, for a

Prepare a 7-page demand management plan, including a forecasting, inventory management, and scheduling analysis, as well as recommendations, for a provided scenario or a business of your choice. Collapse AllIntroduction This portfolio work project, a demand management plan, will help you demonstrate competency in forecasting, inventory management, and scheduling. Scenario

Prepare a 7-page demand management plan, including a forecasting, inventory management, and scheduling analysis, as well as recommendations, for a

Prepare a 7-page demand management plan, including a forecasting, inventory management, and scheduling analysis, as well as recommendations, for a provided scenario or a business of your choice. Collapse AllIntroduction This portfolio work project, a demand management plan, will help you demonstrate competency in forecasting, inventory management, and scheduling. Scenario