For this course work, very good excel skills are needed. As well as a good understanding and application of strategic business tools like BCG Matrix, Trend analysis, McKinsey Matrix and cost structure analysis.
The whole course work can be done in an Excel file. Two sentences per answer are enough. It is more important to build the correct excel tables, matrix and graphs to support the answers.
a. Do you think the proposed SBUs make sense? If you do not follow this recommendation, which SBUs do you think should be created? Would the formation of strategic groups in addition to customer groups and product technologies also make sense after the product functions? Give reasons for your remarks.
b. BCG Matrix: In the event that you have decided to change the SBUs, perform a market growth/market share portfolio analysis for the years 2014 to 2016. This also applies to an unchanged takeover of the SBUs. Display your results in tabular and graphical form in individual matrices. In addition, you should also present the appropriate contribution margin pro rata in the individual SBUs. Provide an initial estimate of the cost structure.
