Business analyst, bsc, strategy

Job ID: 39033023

Budget: €8 – €30 EUR

More details:

What is the primary focus of the business analysis?
- Operational analysis

Which areas of operations do you want to focus on?
- Balanced scorecard (BSC) of the given company based on template -> Pepsi.co

Which perspectives do you want to include in the balanced scorecard?
- Financial, Customer, Internal processes, Learning and development perspective

Extended description of the task:
Describe the vision, mission, goals and strategies of Pepsi.co in Excel

1. Describe the financial perspective of the company selected in point 1), taking into account the following indicators: profitability (2-3 indicators, e.g. ROA, ROE), debt (1-2 indicators, e.g. total debt ratio), liquidity (1-2 indicators, e.g. current liquidity), cash conversion period (1 indicator) and risk management (1-2 indicators).

2. Describe the perspective of the customer selected in point 1), taking into account market segmentation and the following indicators: market share (1 indicator), customer retention (1-2 indicators), customer acquisition (1-2 indicators), customer satisfaction (1-2 indicators) and customer profitability (1 indicator).

3. Describe the perspective of internal processes of the company selected in point 1), taking into account innovation processes and the following measures: product development (1-2 measures), operational processes (2-3 measures) and after-sales service (1-2 measures).

4. Describe the development perspective of the company selected in point 1), taking into account the following measures: personnel measures (2-3 measures) and learning (1-2 measures).

5. Propose a system for implementing a scorecard for the company selected in point 1).