ROI GIRI 2025 2 Master - Please Make a Copy

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1
2
3	Change the blue Numbers to calculate your personal GIRI ROI
4
5
6
7	Basic data
8		Gross annual salary	Social charges (example Germany 21%)	Overhead (typically 20%)	Annual salary + wage + overhead	Approx yearly working hours	Total Cost per hour
9	Country specific Values		24%	20%		2016
10	Costs of Expert	€ 75,000	€ 18,000	€ 15,000	€ 108,000		€ 54
11	Cost of Worker	€ 40,000	€ 9,600	€ 8,000	€ 57,600		€ 29
12	Number of Workers	150
13	Newly Created Work instructions / year	100
14
15
16
17	Summary of current annual savings ( based on your values)
18	€3,649,186
19
20
21
22	Calculation
23	Activities and Processes					Old Activity with old Results							New Activity with new Results
24	Situation	Old Activity	Old Result	New Activity	New Result	Comment on calculations	How often per year / per Worker	Calculation per incident				Sum old way	How often per year / per Worker	Calculation per incident				Sum new way	Savings
25	Situation	Old Activity	Old Result	New Activity	New Result	Comment on calculations	How often per year / per Worker	Working hours Worker/Trainee	Workinghours Expert	Other Costs	Sum per incident	Sum old way	How often per year / per Worker	Working hours Worker/Trainee	Workinghours Expert	Other Costs	Sum per incident	Sum new way	Savings
26	Qualification of Workers - Every Day	Long procedures SOP that are not read. Repeatedly having to explain/train workers in 1:1 trainings.	Requires expert time. Inconsistent training quality. Training not executed.	Worker scans a QR code to self-qualify for any task.	No expert needed for training. Instant qualification possible.	calculation based on less experts needed for training	100	1.00	2.50		€163	€2,437,500	100	1.00	0.00		€29	€428,571	€2,008,929
27	Workers Do the Same Thing Day In, Day Out	Due to lack of training capacity, workers can only perform limited tasks.	Inflexible workforce. Unmotivated workforce. Not easy to attract new talents.	Worker scans a QR code to self-qualify for any task.	Highly flexible workforce. Highly motivated workforce.	overtime hours because i have not enough talented workers - calculated as 5% overtime	101				€2,880	€432,000	0	0.00	0.00		0	€0	€432,000
28	Creation of Work instructions	Your Experts, who already have a high workload create the instructions	Very time consuming. No time to keep them up to date.	Employees create/update work instructions with their smartphone directly at the assembly line.	High chance for work instructions to be up to date.	number of newly created instructions	100	0.50	16.00		€871	€87,143	100	0.10	0.00		€3	€286	€86,857
29	Errors	No time for training.	Badly trained workers produce on average 1000€ error cost monthly.	Training with Augmented Reality.	62.3% fewer errors.		12			1,000	€1,000	€1,800,000	12			377	€377	€678,600	€1,121,400
30												€4,756,643							€3,649,186
31																			€3,649,186
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100