Problem Statement: Development of a Generic Spreadsheet Tool ABC Manufacturing is considering investing in a new manufacturing facility. The company has identified three potential locations (A,B, and C) for the facility. Each location has a different probability of success and corresponding financial outcomes. The management wants to evaluate the financial feasibility of each location and make an informed decision based on a decision tree analysis. The following table provides the relevant data for each location: Note: The cash flows represent the expected annual cash flow for each location if the facility is successful. Hints: - Construct a decision tree to represent the decision-making process, starting from the decision node (choosing a location) to the chance nodes (probability of success) and the terminal nodes (financial outcomes). - Calculate the expected cash flows for each location by multiplying the probability of success with the expected cash flow. - Calculate the expected value for each decision branch by summing the product of the probability of reaching each node and the corresponding financial outcome. - Determine the location with the highest expected value to make the optimal decision. - You can use spreadsheet functions and formulas to perform calculations and analyze the decision tree efficiently. - Work on this problem diligently and apply the concepts and techniques we have learned throughout the course. Remember to show all your calculations and explain your reasoning and steps clearly