The suggested approach to this assignment.
Develop your issue tree to identify the root cause and do some basic analysis (Excel) to understand the core problems.
This will involve not just doing an issue tree, but using Excel to understand the implications around your initial analysis. The high-level financial analysis and high-level root analysis will help your team understand the core issues when we seek to understand the core problem.
In this case, do a basic analysis to understand where the company needs to improve. Start with the issue tree and then identify where you need to conduct some basic financial analysis.
Build a simple Excel model to figure out what the firm should focus on. Excel can also be helpful when looking at the financial implications for the firm. The core problems identified through your analysis is what will be graded, not the tree itself or the Excel used to understand the problem. Scope document; identify the core problem(s) in the case that needs to be addressed by the team.
The core problem is something that has to be addressed for the firm to be successful; try to boil down to the most important, high-level issue(s). It will be easy to list all the problems. Instead, push yourself to identify the core problems—the ones that will have the greatest impact.
