The purpose of this assignment is to show how business decisions can be made by using rigorous decision-making techniques.Using specified data files, chapter example files, and templates from the “Topic 8 Student Data, Template, and Example Files” topic material, complete Chapter 6, Problems 2, 31 (part a), 32, and 33 from the textbook. Use Microsoft Excel to complete Problem 2. Use the Palisade DecisionTools software to complete Problems 31, 32, and 33, and ensure that all Palisade software output is included in your files. The Palisade DecisionTools Excel software needs to be used to create the decision trees.Problem #2:For the decision problem in Figure 6.1, use data tables to perform the following sensitivity analyses. The goal in each is to see whether decision 1 continues to have the largest EMV. In each part, provide a brief explanation of the results.a. Let the payoff from the best outcome, the value in cell A3, vary from $30,000 to $50,000 in increments of $2500. b. Let the probability of the worst outcome for the first decision, the value in cell B5, vary from 0.7 to 0.9 in increments of 0.025, and use formulas in cells B3 and B4 to ensure that they remain in the ratio 1 to 2 and the three probabilities for decision 1 continue to sum to 1. c. Use a two-way data table to let the inputs in parts a and b vary simultaneously over the indicated ranges.Problem #31a:Carlisle Tire and Rubber, Inc., is considering expanding production to meet potential increases in the demand for one of its tire products. Carlisle’s alternatives are to construct a new plant, expand the existing plant, or do nothing in the short run. The market for this particular tire product may expand, remain stable, or contract. Carlisle’s marketing department estimates the probabilities of these market outcomes to be 0.25, 0.35, and 0.40, respectively. The file P06_31.xlsx contains Carlisle’s payoffs and costs for the various combinations of decisions and outcomes. a. Use PrecisionTree to identify the strategy that maximizes this tire manufacturer’s expected profit.Problem #32:A local energy provider offers a landowner $180,000 for the exploration rights to natural gas on a certain site and the option for future development. This option, if exercised, is worth an additional $1,800,000 to the landowner, but this will occur only if natural gas is discovered during the exploration phase. The landowner, believing that the energy company’s interest in the site is a good indication that gas is present, is tempted to develop the field herself. To do so, she must contract with local experts in natural gas exploration and development. The initial cost for such a contract is $300,000, which is lost forever if no gas is found on the site. If gas is discovered, however, the landowner expects to earn a net profit of $6,000,000. The landowner estimates the probability of finding gas on this site to be 60%. a. Use PrecisionTree to identify the strategy that maximizes the landowner’s expected net earnings from this opportunity. b. Perform a sensitivity analysis on the optimal decision, letting each of the inputs vary one at a time plus or minus 25% from its base value, and summarize your findings. Which of the inputs appears to have the largest effect on the best solution?Problem #33:Techware Incorporated is considering the introduction of two new software products to the market. The company has four options regarding these products: introduce neither product, introduce product 1 only, introduce product 2 only, or introduce both products. Research and development costs for products 1 and 2 are $180,000 and $150,000, respectively. Note that the first option entails no costs because research and development efforts have not yet begun. The success of these software products depends on the national economy in the coming year. The company’s revenues, depending on its decision and the state of the economy, are given in the file P06_33.xlsx. The probabilities of a strong, fair, or weak economy in the coming year are assessed to be 0.30, 0.50, and 0.20, respectively. a. Use PrecisionTree to identify the strategy that maximizes Techware’s expected net revenue. b. Perform a sensitivity analysis on the optimal decision, letting each of the inputs vary one at a time plus or minus 25% from its base value, and summarize your findings. Which of the inputs appears to have the largest effect on the best solution?To receive full credit on the assignment, complete the following.Ensure that the Palisade software output is included with your submission.Ensure that Excel files include the associated cell functions and/or formulas if functions and/or formulas are used.Include a written response to all narrative questions presented in the problem by placing it in the associated Excel file.Place each problem in its own Excel file. Ensure that your first and last name are in your Excel file names.APA style is not required, but solid academic writing is expected.

Assignment: Creating Team Cohesion Diversity of a group makes interactions more complex and impacts the results of the group’s interactions. In this scenario you read about a diverse group’s interactions and apply conflict resolution strategies to enhance the team’s cohesion and collaboration. Cast: Sara (from Bon, Germany office) Tai (from the Montreal, Canada office) Peter (Minneapolis office) Scenario: The Meeting takes place in Minneapolis, Minnesota. The Vice President (V. P.) of the Consulting Division (Seth) convened a small team of three to decide how the new consulting staff to be hired for the new divisional offices in Puerto Rico will be trained. This small team will meet virtually using conferencing software since the three team members are in separate locations. They are to decide the process and steps involved in the training for finalized submission to executive management in two weeks’ time. V. P. at the initial meeting before departing: “I leave this self-managed team in charge of providing me with succinct recommendations for the process and steps to be used in the training of this new division of employees. I look forward to the results in a presentation in two weeks by noon Central Time.” Upon the V.P.’s departure the following conversation between the three team members takes place: Sara starts: Well all, can we agree that we are going to do a PowerPoint presentation and just brainstorm the process first? Peter: Well, shouldn’t we address who will be in this training first? Tai: Can we just introduce ourselves first? I am not too clear on who you all are and why I am here. Peter: That’s a good point. Let’s introduce ourselves. Sara: I am a Human Resource Benefits Manager. Peter: Thanks Sara, and you Tai? Tai: I am a Consulting Services Manager for the Northwestern region of the U.S. and Canada. Peter: Nice to have you Tai. I am one of three the North American Customer Service Division Managers. Sara: Can we share a screen to see what our agenda is? Peter sheepishly: Right, I should have sent this out earlier but there was too little time. Sara: If you want I would be glad to come up with the training process and send it to you all. Tai: I am really pressed for time; that sounds like a plan. Peter: Hold on guys, I think we need to take this one step at a time. Sara: Well that sounds nice, but I don’t think we really have time for that. Peter realizes that things have started off badly and he wonders what went wrong. Checklist: Explain the team’s problems in terms of their interactions evidenced in the scenario.Then provide the conflict resolution steps and strategies to address the problems.Explain how the conflict resolution strategies you suggest will improve group cohesion and collaboration.