You may find questions on the image of the part. You should answer as below, 1) Revenue=20000E, Variable Cost=20000E, Fixed cost=20000E, EBITDA margin(E)=20000E, EBITDA margin/\%]= 50\% 2) Product 5, Contribution margin (E)=20000, Contribution E/pieces(unit)=20, Contribution margin ( % ) =50% 3) KPI_1 =Customer complaint rate KFI1 Calculation= number of customer complaints per month Case: A Food Manufacturing company has 3 different Food categories and 2023 financial performance of the categories stated in figure 1. In addition to that you may see high level operating model from supply to delivery of the company in figure 2. Hint: Using Excel would help you to get answers Top management asks questions below; 1. What would be EBITDA margin percentage in 2024 if volume of product 3 increases 10% from 2023 volume while all other parameter values stay same in 2024 ? - Please write 2024 revenue, variable cost, fixed cost and EBITDA margin in terms of and finally indicate EBITDA \% - Hint: You my recall EBITDA margin calculation from table and should be careful about costs as well as revenue calculation for requested scenario 2. What is the most profitable product that the firm could want to sell 1000 pieces more based on 2023 figures? And what is contribution margin percentage of the product in 2023 ? - Please indicate the most profitable product and contribution margin in terms of and / pieces (unit) and finally indicate Contribution Margin \% of the product 3. Identify KPIs for the departments. - Depending on operating model example in figure 2 , assign 2 smart KPIs to departments of the firm in total. KPIs should measure performance of the department. So please indicate how to calculate the KPI that you identified. You may select one single department or more than one to assign 2KPI in total. You may find questions on the image of the part. You should answer as below, 1) Revenue=20000E, Variable Cost=20000E, Fixed cost=20000E, EBITDA margin(E)=20000E, EBITDA margin/\%]= 50\% 2) Product 5, Contribution margin (E)=20000, Contribution E/pieces(unit)=20, Contribution margin ( % ) =50% 3) KPI_1 =Customer complaint rate KFI1 Calculation= number of customer complaints per month Case: A Food Manufacturing company has 3 different Food categories and 2023 financial performance of the categories stated in figure 1. In addition to that you may see high level operating model from supply to delivery of the company in figure 2. Hint: Using Excel would help you to get answers Top management asks questions below; 1. What would be EBITDA margin percentage in 2024 if volume of product 3 increases 10% from 2023 volume while all other parameter values stay same in 2024 ? - Please write 2024 revenue, variable cost, fixed cost and EBITDA margin in terms of and finally indicate EBITDA \% - Hint: You my recall EBITDA margin calculation from table and should be careful about costs as well as revenue calculation for requested scenario 2. What is the most profitable product that the firm could want to sell 1000 pieces more based on 2023 figures? And what is contribution margin percentage of the product in 2023 ? - Please indicate the most profitable product and contribution margin in terms of and / pieces (unit) and finally indicate Contribution Margin \% of the product 3. Identify KPIs for the departments. - Depending on operating model example in figure 2 , assign 2 smart KPIs to departments of the firm in total. KPIs should measure performance of the department. So please indicate how to calculate the KPI that you identified. You may select one single department or more than one to assign 2KPI in total