| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||
2 | |||||||||
3 | Echometer's ROI for {company} | ||||||||
4 | |||||||||
5 | Input variables | ||||||||
6 | For Part 1: Existing agile teams (that are running retrospectives) | For Part 2: Additional teams that could start retrospectives using Echometer | |||||||
7 | # of teams | 31 | # of teams | 50 | |||||
8 | # of employees | 250 | # of employees | 450 | |||||
9 | # retros / month | 2 | # retros / month | 2 | |||||
10 | € average wage per hour | 52 € | € average wage per hour | 52 € | |||||
11 | Coaching ratio (an agile coach joins retro every X time) | 2 | |||||||
12 | |||||||||
13 | Costs of agile coaching / Scrum Master | Organizational data | |||||||
14 | € Coaching cost per hour | 52 € | Current profitability | 8% | |||||
15 | % Yearly employee turnover (firing & quiting) | 6% | |||||||
16 | Subscription | Pro (Annually) | Costs per employee turnover (Hiring & onboarding of new employee) in EUR | 15.000 € | |||||
17 | |||||||||
18 | |||||||||
19 | Part 1 | ||||||||
20 | ROI of optimizing existing retrospectives If you use Echometer in teams that are already running retrospectives. | ||||||||
21 | Monthly Echometer Subscription fee in EUR | 899 € | |||||||
22 | Your total monthly benefit in EUR | 13.335 € | |||||||
23 | Echometer's ROI for existing retros | 1.383% | |||||||
24 | |||||||||
25 | Open the group after row 26 to see detailed calculation. | ||||||||
26 | |||||||||
27 | Assumptions: Time savings per retrospective | ||||||||
28 | Today | with Echometer | |||||||
29 | hours | costs in EUR | hours | costs in EUR | |||||
30 | Preparation | Manual research based on observation | 1 | 52 € | Easily customize the automatic rotation of topics | 0,17 | 9 € | ||
31 | Retrospective | Manual team workshop facilitation | 1,5 | 707 € | Less admin through straight forward guidance with upfront feedback | 1,2 | 566 € | ||
32 | Follow-up | Documenting and communicating results | 0,75 | 39 € | Summary is sent automatically & todos are on resubmission | 0,17 | 9 € | ||
33 | Total costs | 798 € | 583 € | ||||||
34 | |||||||||
35 | Calculating your benefit | ||||||||
36 | Benefit per retrospective | 215 € | |||||||
37 | Benefit per month & team | 430 € | |||||||
38 | Benefit per month (all existing teams) | 13.335 € | |||||||
39 | |||||||||
40 | Part 2 | ||||||||
41 | ROI of a roll-out across teams If you scale retrospectives with Echometer in your organization | ||||||||
42 | Monthly recurring investment for rolling out retrospectives | 2.349 € | |||||||
43 | Monthly recurring benefits | 145.846 € | |||||||
44 | Echometer's ROI when scaling retros | 6.109% | |||||||
45 | |||||||||
46 | Open the group after row 47 to see detailed calculation. | ||||||||
47 | |||||||||
48 | Did you know that running team retrospectives and the resulting high engagement level in teams has the proven benefit to... | ||||||||
49 | increase employee loyality by | 25% | "24-59%", Source: Gallup Q12 Meta Analysis | ||||||
50 | increase productivity by | 20% | "20-25%", Source: Tannenbaum & Cerasoli, 2013 | ||||||
51 | |||||||||
52 | Well, let's check what this means for a potential roll-out scenario in which you introduce retrospectives to new teams using Echometer: | ||||||||
53 | |||||||||
54 | Calculating your internal costs per retrospective | ||||||||
55 | hours | costs in EUR | |||||||
56 | Time investment of a team (based on average team size of 9) | 10,8 | 562 € | ||||||
57 | Coaching (based on assumption that a coach joins every 2. retro) | 0,7666666667 | 40 € | ||||||
58 | Total internal costs per retrospective | 11,56666667 | 601 € | ||||||
59 | |||||||||
60 | Caclulating your total costs per month | ||||||||
61 | costs in EUR | ||||||||
62 | Internal costs per retrospective | 601 € | |||||||
63 | Total internal costs (for 100 additional retrospectives) per month | 60.147 € | |||||||
64 | Echometer subscription fee for rollout (700 users in 81 teams) | 2.349 € | |||||||
65 | Total costs per month | 62.496 € | |||||||
66 | |||||||||
67 | Calculating your total monthly benefits | ||||||||
68 | in EUR | ||||||||
69 | Increased profitability due to productivity improvement | 64.846 € | |||||||
70 | current monthly salaries | 4.052.880 € | |||||||
71 | current return on salary | 324.230 € | |||||||
72 | increased return on salary with Echometer | 389.076 € | |||||||
73 | Less hiring costs due to increased loyalty | 81.000 € | |||||||
74 | current monthly hiring & onboarding costs | 405.000 € | |||||||
75 | Total monthly benefits | 145.846 € | |||||||
76 | |||||||||
77 | |||||||||
78 | |||||||||
79 | Data for graphs (doesn't need to be printed, but must not be deleted) | ||||||||
80 | Data for graph 1 | Data for graph 2 | |||||||
81 | Status quo: Current monthly costs of retros | 49.478 € | Monhtly internal costs | -60.147 € | |||||
82 | Echometer subscription | 899 € | Echometer subscription | -2.349 € | |||||
83 | Time savings in retro | -8.767 € | Productivity benefit | 64.846 € | |||||
84 | Time savings preparation & followup | -4.567 € | TRUE | Loyalty benefit | 81.000 € | ||||
85 | Costs with Echometer | 37.042 € | |||||||
86 | |||||||||
87 | |||||||||
88 | |||||||||
89 | |||||||||
90 | |||||||||
91 | |||||||||
92 | |||||||||
93 | |||||||||
94 | |||||||||
95 | |||||||||
96 | |||||||||
97 | |||||||||
98 | |||||||||
99 | |||||||||
100 | |||||||||