I have 3 teams within a group with each team working on different tasks assigned. I was given data of how each team performed in terms of the number of task completed each month and the average days taken to complete these task (cells O3,O5,O6). From this data, an overall group performance was generated, again based on the total tasks completed by the group and the total days used to arrive at an average days per task to complete (Cells N10).
We were given an improvement target to reduce the overall group average days per task by 30% in H1 of 2021 and then a further 30% by H2 based on the performance from last year. So a 30% reduction will result in a new target in cell "N11". My challenge is each team within the group works on different type of task with different degree of difficulty so i need to translate this new target (Cell N11) into 3 different new average days to complete for each different team.