ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
CIBECS RETURN ON INVESTMENT MODEL
2
This sheet calculates based on averages & estimates only.
3
All entries to be done in the RED TEXT sections on the Detailed Services Items ROI sheet
4
5
ASSUMPTIONS
6
 Number of Desktops & Laptops 500
Ave. support events / PC p.a
 2
Cibecs Annual License Cost / User
 $ 60.00
7
Ave. Technician's cost per hr $ 35.00
% Support events incl. data
25.00%
Implementation & Other Cost
15%
8
Desktop refresh cycle3 yearsAnnual Increase5%
9
10
PROJECTED TECHNICAL COST SAVING PER EVENT
11
12
 Annual Saving across all users Allocation of savings per device / month Priority Adjusted allocation saving per device / month
13
Business Continuity & Disaster Recovery
 $ 6,125.00 $ 1.02 $ 1.08
14
Data Retention $ 1,545.83 $ 0.26 $ 0.25
15
Ransomware Attacks
 $ 11,028.50 $ 1.84 $ 2.57
16
Device Refresh & Migration
 $ 52,500.00 $ 8.75 $ 8.75
17
Device & User Management & Visibility
 $ 23,030.00 $ 3.84 $ 3.29
18
Compliance $ 8,820.00 $ 1.47 $ 2.06
19
20
TOTAL $ 103,049.33 $ 17.17 $ 18.00
21
22
RETURN ON INVESTMENT MODEL
23
24
YEAR 1YEAR 2YEAR 3YEAR 4YEAR 5
25
26
Total License Cost $ 30,000.00 $ 31,500.00 $ 33,075.00 $ 34,728.75 $ 36,465.19
27
Total Other Costs $ 4,500.00 $ 4,725.00 $ 4,961.25 $ 5,209.31 $ 5,469.78
28
TOTAL COST $ 34,500.00 $ 36,225.00 $ 38,036.25 $ 39,938.06 $ 41,934.97
29
30
TOTAL SAVINGS (Based on Priority Adjusted Savings)
 $ 108,019.57 $ 113,420.55 $ 119,091.57 $ 125,046.15 $ 131,298.46
31
32
TOTAL RETURN ON INVESTMENT $ 73,519.57 $ 77,195.55 $ 81,055.32 $ 85,108.09 $ 89,363.49
33
213%213%213%213%213%
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