|
![,](/web/20071212130534im_/http://www.tbs-sct.gc.ca/cioscripts/images/Spacer14px.gif) |
Free and Open Source Software - Cost Comparison Model![,](/web/20071212130534im_/http://www.tbs-sct.gc.ca/cioscripts/images/line450x1.gif)
Summary
This Spreadsheet allows organisations to compare the cost of proprietary and
OSS installations. It is not intended to be a Total Cost of Ownership model. Only
those costs which are likely to be significantly different between the two
installations are included. The comparison is made over a five year period with
one assumed upgrade of the proprietary installation.
Please read the notes to understand how this model works, the
assumptions it is based on and its limitations.
N.B. The spreadsheets contain input fields on the OSS,
proprietary and variables sheets as well.
Number of Internal Desktops
|
3,500
|
Enter the total number of desktop machines connected to the
Administration's network behind firewalls.
|
No of Remote /Home Desktops
|
100
|
Enter the total number of desktops machines which are connected via a WAN
|
Total Number of users
|
4,000
|
Enter the total number of users both internal and remote
|
No of sites
|
10
|
Enter the number of sites with server installations.
|
Year of Proprietary Upgrade
|
3
|
Enter the year in which the proprietary software is assumed to be
upgraded.
|
|
YEAR
|
1
|
2
|
3
|
4
|
5
|
Cost of Proprietary
|
Hardware
|
1,333,754
|
1,333,754
|
2,365,754
|
618,129
|
1,449,379
|
Software
|
1,224,400
|
1,224,400
|
3,258,100
|
1,244,231
|
1,244,231
|
People
|
4,113,582
|
4,113,582
|
4,159,255
|
4,069,712
|
4,111,779
|
|
Total
|
6,671,735
|
6,671,735
|
9,783,108
|
5,932,071
|
6,805,388
|
Cost of FOSS
|
Hardware
|
1,153,407
|
1,153,407
|
1,153,407
|
1,153,407
|
1,153,407
|
Software
|
0
|
0
|
0
|
0
|
0
|
People
|
1,798,185
|
1,798,185
|
1,798,185
|
1,798,185
|
1,798,185
|
|
Total
|
2,951,592
|
2,951,592
|
2,951,592
|
2,951,592
|
2,951,592
|
Cost of Migration
|
Hardware
|
109,250
|
14,250
|
14,250
|
14,250
|
14,250
|
Software
|
2,480,000
|
0
|
0
|
0
|
0
|
People
|
1,605,000
|
20,000
|
20,000
|
20,000
|
20,000
|
|
Total
|
4,194,250
|
34,250
|
34,250
|
34,250
|
34,250
|
Payback Period
|
1 Year 6 Months
|
Open Source Software (OSS) Installation
Internal Desktop
Note No. |
|
Costs per Desktop |
Initial |
Annual Maintenance/ Licence |
Annual Internal Support |
Total Annual Expenditure |
7 |
Desktop Type |
1 |
8 |
Setup Time (hrs) |
0.50 |
8 |
|
9 |
Hardware |
675 |
75 |
84 |
159 |
10
|
Operating System |
0
|
0
|
34
|
34
|
10
|
Office Productivity tools
|
0
|
0
|
202
|
202
|
11
|
Client Access Licences
|
0
|
0
|
0
|
0
|
10
|
Anti – Virus/Spam
|
0
|
0
|
17
|
17
|
|
TOTALS |
683
|
|
|
412
|
Internal Desktop Summary
( Costs per Desktop )
|
Initial
|
Annual
|
Total Hardware
|
675
|
75
|
Total Software
|
0
|
0
|
Total People
|
8
|
337
|
TOTALS
|
683
|
412
|
Remote Desktop – Homeworker
Note No.
|
|
|
Costs per Desktop
|
Initial
|
Annual Maintenance/ Licence
|
Annual Internal Support
|
Total Annual Expend- iture
|
7
|
Desktop Type
|
2
|
8
|
Setup Time (hrs)
|
3
|
50
|
|
|
|
9
|
Hardware
|
860
|
80
|
84
|
164
|
10
|
Operating System
|
0
|
0
|
34
|
34
|
10
|
Office Productivity tools
|
0
|
0
|
329
|
329
|
11
|
Client Access Licences
|
0
|
0
|
0
|
0
|
10
|
Anti – Virus/Spam
|
0
|
0
|
17
|
17
|
12
|
Virtual Private Network
|
0
|
0
|
17
|
17
|
13
|
Firewall
|
0
|
0
|
50
|
50
|
|
TOTALS
|
910
|
|
611
|
Remote Desktop Summary
( Costs per Desktop )
|
Initial
|
Annual
|
Total Hardware
|
860
|
80
|
Total Software
|
0
|
0
|
Total People
|
50
|
531
|
TOTALS
|
910
|
611
|
Servers
Note No.
|
|
23
|
Number of Severs per Systems Administrator
|
20
|
24
|
Average life of a server
|
7
|
Note No.
|
|
Server Type
|
Concur- rent
users per
server
|
One server
per site
|
No of servers
required
|
Hard- ware
Initial
|
Hard- ware
Annual
|
Soft- ware
Initial
|
Soft- ware
Annual
|
25
|
Web Services
|
3
|
5,000
|
0
|
1
|
5,000
|
750
|
0
|
0
|
25
|
Mail and Group- ware Services
|
3
|
5,000
|
0
|
1
|
5,000
|
750
|
0
|
0
|
25
|
File Servers
|
1
|
4,000
|
1
|
10
|
95,000
|
14,250
|
0
|
0
|
25
|
Printer Services
|
2
|
1,000
|
1
|
10
|
75,000
|
11,250
|
0
|
0
|
25
|
Office Software Server
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
25
|
Remote Display Server
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
25
|
Client Access Licences
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
25
|
Anti – Virus/ Spam
|
1
|
50
|
1
|
80
|
760,000
|
114,000
|
0
|
0
|
25
|
Virtual Private Network
|
1
|
50
|
1
|
80
|
760,000
|
114,000
|
0
|
0
|
25
|
Firewall
|
2
|
300
|
1
|
14
|
105,000
|
15,750
|
0
|
0
|
|
TOTALS
|
|
1,805,000
|
270,750
|
0
|
0
|
Server Summary
( Total Costs for all users )
|
Initial
|
Annual
|
Total Hardware
|
1,805,000
|
270,750
|
Total Software
|
0
|
0
|
Total People
|
0
|
558,600
|
Totals
|
1,805,000
|
829,350
|
Base Data
Note No.
|
|
20
|
Annual cost of employing a systems support person
|
35,000
|
21
|
Annual cost of employing a systems administrator
|
57,000
|
|
Licence
|
Annual Update Support
|
Initial
|
Annual
|
Note No.
|
Server
|
Per User
|
|
27
|
Web Servers
|
0.00
|
0.00
|
0.00
|
27
|
Mail and Groupware
|
0.00
|
0.00
|
0.00
|
27
|
File Servers
|
0.00
|
0.00
|
0.00
|
27
|
Print Servers
|
0.00
|
0.00
|
0.00
|
28
|
Office Software Server
|
0.00
|
0.00
|
0.00
|
29
|
Remote Display Server
|
0.00
|
0.00
|
0.00
|
18
|
Client Access Licences
|
0.00
|
0.00
|
0.00
|
27
|
Anti-Virus/Spam
|
0.00
|
0.00
|
0.00
|
27
|
Virtual Private Network
|
0.00
|
0.00
|
0.00
|
27
|
Firewall
|
0.00
|
0.00
|
0.00
|
14
|
Desktop
|
Per Desktop
|
|
15
|
Operating System
|
0.00
|
0.00
|
0.00
|
2.00
|
16
|
Office Productivity Tools
|
0.00
|
0.00
|
0.00
|
12.00
|
15
|
|
Office
|
0.00
|
0.00
|
0.00
|
3.00
|
15
|
Mail / Groupware
|
0.00
|
0.00
|
0.00
|
2.00
|
15
|
Personal Database
|
0.00
|
0.00
|
0.00
|
5.00
|
15
|
Browser
|
0.00
|
0.00
|
0.00
|
2.00
|
17
|
Client Access Licences
|
0.00
|
0.00
|
0.00
|
0.00
|
15
|
Anti-Virus/Spam
|
0.00
|
0.00
|
0.00
|
1.00
|
15
|
Virtual Private Network
|
0.00
|
0.00
|
0.00
|
1.00
|
15
|
Remote Firewall
|
0.00
|
0.00
|
0.00
|
3.00
|
Proprietary Installation
Internal Desktop
Note No.
|
|
Costs per Desktop
|
Current Environment
|
Initial
|
Annual Maintenance/ Licence
|
Annual Internal Support
|
Total Annual Expenditure
|
7
|
Desktop Type
|
3
|
8
|
Setup Time (hrs)
|
4
|
48
|
|
|
|
9
|
Hardware
|
850
|
125
|
60
|
185
|
10
|
Operating System
|
100
|
10
|
24
|
34
|
10
|
Office Productivity Tools
|
250
|
30
|
144
|
174
|
10
|
Client Access Licences
|
0
|
0
|
0
|
0
|
10
|
Anti – Virus/Spam
|
20
|
6
|
901
|
907
|
|
TOTALS
|
1,268
|
|
1,301
|
19
|
Maximum age of desktops kept at upgrade
|
2
|
NOTE - This is only used if the desktop type changes
|
|
Costs per Desktop
|
Note No.
|
After Upgrade
|
Initial
|
Annual Maintenance/ Licence
|
Annual Internal Support
|
Total Annual Expenditure
|
7
|
Desktop Type
|
4
|
8
|
Setup Time (hrs)
|
4
|
48
|
|
|
|
9
|
Hardware
|
950
|
140
|
60
|
200
|
10
|
Operating System
|
100
|
10
|
24
|
34
|
10
|
Office Productivity Tools
|
250
|
30
|
144
|
174
|
10
|
Client Access Licences
|
0
|
0
|
0
|
0
|
10
|
Anti – Virus/Spam
|
20
|
0
|
901
|
901
|
|
TOTALS
|
1,368
|
|
1,310
|
Internal Desktop Summary
|
Current Environment
|
After Upgrade
|
( Costs per Desktop )
|
Initial
|
Annual
|
Initial
|
Annual
|
Total Hardware
|
850
|
125
|
950
|
140
|
Total Software
|
370
|
46
|
370
|
40
|
Total People
|
48
|
1,130
|
48
|
1,130
|
TOTALS
|
1,268
|
1,301
|
1,368
|
1,310
|
Internal Desktop Summary
Note No.
|
|
Costs per Desktop
|
Current Environment
|
Initial
|
Annual Maintenance/ Licence
|
Annual Internal Support
|
Total Annual Expenditure
|
7
|
Desktop Type
|
5
|
8
|
Setup Time (hrs)
|
6
|
72
|
|
|
|
9
|
Hardware
|
1,035
|
130
|
60
|
190
|
10
|
Operating System
|
100
|
10
|
24
|
34
|
10
|
Office Productivity Tools
|
250
|
30
|
144
|
174
|
10
|
Client Access Licences
|
0
|
0
|
0
|
0
|
10
|
Anti – Virus/Spam
|
20
|
6
|
901
|
907
|
12
|
Virtual Private Network
|
200
|
180
|
12
|
192
|
13
|
Firewall
|
10
|
5
|
12
|
17
|
|
TOTALS
|
1,687
|
|
1,515
|
19
|
Maximum age of desktops kept at upgrade
|
1
|
NOTE - This is only used if the desktop type changes
|
|
Costs per Desktop
|
|
After Upgrade
|
Initial
|
Annual Maintenance/ Licence
|
Annual Internal Support
|
Total Annual Expenditure
|
7
|
Desktop Type
|
6
|
8
|
Setup Time (hrs)
|
6
|
72
|
|
|
|
9
|
Hardware
|
1,135
|
145
|
60
|
205
|
10
|
Operating System
|
100
|
10
|
24
|
34
|
10
|
Office Productivity Tools
|
250
|
30
|
144
|
174
|
10
|
Client Access Licences
|
0
|
0
|
0
|
0
|
10
|
Anti – Virus/Spam
|
20
|
6
|
901
|
907
|
12
|
Virtual Private Network
|
200
|
180
|
12
|
192
|
13
|
Firewall
|
10
|
5
|
12
|
17
|
|
TOTALS
|
1,787
|
|
1,530
|
Remote Desktop Summary
|
Current Environment
|
After Upgrade
|
( Costs per Desktop )
|
Initial
|
Annual
|
Initial
|
Annual
|
Total Hardware
|
1,035
|
130
|
1,135
|
145
|
Total Software
|
580
|
231
|
580
|
231
|
Total People
|
72
|
1,154
|
72
|
1,154
|
TOTALS
|
1,687
|
1,515
|
1,787
|
1,530
|
Servers
Note No.
|
|
23
|
Number of Severs per Systems Administrator
|
15
|
24
|
Average life of a server
|
7
|
|
Server Type |
Concur- rent users per server |
One server per site |
No of servers required |
Hard- ware Initial |
Hard- ware Annual |
Software Initial |
Software Annual |
|
Current Environment |
25 |
Web Services
|
3 |
2,500 |
0
|
2
|
10,000
|
1,500
|
0
|
40,000
|
25
|
Mail and Groupware Services |
3
|
2,500
|
0
|
2
|
10,000
|
1,500
|
0
|
60,000
|
25
|
File Servers |
1
|
300
|
1
|
14
|
133,000
|
19,950
|
0
|
0
|
25
|
Printer Services |
2
|
230
|
1
|
18
|
135,000
|
20,250
|
0
|
20,000
|
25
|
Other Services |
3
|
1,000
|
1
|
10
|
50,000
|
7,500
|
1,250
|
300
|
25
|
Client Access Licences |
0
|
0
|
0
|
0
|
0
|
0
|
500,000
|
120,000
|
25
|
Remote Display Servers (e.g.TSE/ Citrix) |
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
25
|
Office Software Server |
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
25
|
Anti – Virus/ Spam |
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
25
|
Virtual Private Network |
0
|
0
|
0
|
0
|
0
|
0
|
0
|
400,000
|
25
|
Firewall |
3
|
1,000
|
1
|
10
|
50,000
|
7,500
|
800,000
|
400,000
|
|
TOTALS
|
|
388,000
|
58,200
|
1,301,250
|
1,040,300
|
|
Server Type
|
Concur- rent users per server
|
One server per site
|
No of servers required
|
Hard- ware Initial
|
Hard- ware Annual
|
Soft- ware Initial
|
Soft- ware Annual
|
|
After Upgrade
|
25
|
Web Services
|
3
|
2,500
|
0
|
2
|
10,000
|
1,500
|
0
|
0
|
25
|
Mail and Groupware Services
|
3
|
2,500
|
0
|
2
|
10,000
|
1,500
|
0
|
0
|
25
|
File Servers
|
1
|
300
|
1
|
14
|
133,000
|
19,950
|
0
|
0
|
25
|
Printer Services
|
2
|
230
|
1
|
18
|
135,000
|
20,250
|
0
|
0
|
25
|
Other Services
|
3
|
1,000
|
1
|
10
|
50,000
|
7,500
|
0
|
0
|
25
|
Client Access Licences
|
0
|
0
|
0
|
0
|
0
|
0
|
500,000
|
304,000
|
25
|
Remote Display Servers (e.g.TSE/ Citrix)
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
25
|
Office Software Server
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
25
|
Anti – Virus/ Spam
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
25
|
Virtual Private Network
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
400,000
|
25
|
Firewall
|
3
|
1,000
|
1
|
10
|
50,000
|
7,500
|
800,000
|
400,000
|
|
TOTALS
|
|
388,000
|
58,200
|
1,300,000
|
1,104,000
|
Server Summary
|
Current Environment
|
After Upgrade
|
( Total Costs for all users )
|
Initial
|
Annual
|
Initial
|
Annual
|
Total Hardware
|
388,000
|
58,200
|
388,000
|
58,200
|
Total Software
|
1,301,250
|
1,040,300
|
1,300,000
|
1,104,000
|
Total People
|
0
|
174,333
|
0
|
174,333
|
TOTALS
|
1,689,250
|
1,272,833
|
1,688,000
|
1,336,533
|
Base Data
Note No.
|
|
20
|
Annual cost of employing a systems support person
|
25,000
|
21
|
Annual cost of employing a systems administrator
|
40,000
|
22
|
Annual cost of managing licences
|
25,000
|
|
Current Environment
|
After Upgrade
|
Licence
|
Annual Update Support
|
Licence
|
Annual Update Support
|
|
Server
|
Per User
|
Initial
|
Annual
|
Initial
|
Annual
|
27
|
Web Servers
|
0.00
|
0.00
|
10.00
|
0.00
|
0.00
|
0.00
|
27
|
Mail and Groupware
|
0.00
|
0.00
|
15.00
|
0.00
|
0.00
|
0.00
|
27
|
File Servers
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
27
|
Print Servers
|
0.00
|
0.00
|
5.00
|
0.00
|
0.00
|
0.00
|
26
|
Other Services
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
16
|
Client Access Licences
|
125.00
|
0.00
|
30.00
|
125.00
|
46.00
|
30.00
|
18
|
|
Operating System
|
25.00
|
0.00
|
10.00
|
25.00
|
13.00
|
10.00
|
18
|
Mail / Groupware
|
60.00
|
0.00
|
15.00
|
60.00
|
13.00
|
15.00
|
18
|
Remote Display
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
18
|
SQL
|
40.00
|
0.00
|
5.00
|
40.00
|
20.00
|
5.00
|
18
|
Other
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
25
|
Remote Display Server
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
28
|
Office Software Server
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
27
|
Anti-Virus/Spam
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
27
|
Virtual Private Network
|
0.00
|
100.00
|
0.00
|
0.00
|
100.00
|
0.00
|
27
|
Firewall
|
200.00
|
100.00
|
0.00
|
200.00
|
100.00
|
0.00
|
|
Current Environment
|
After Upgrade
|
Licence
|
Annual Update Support
|
Annual Internal Support (hrs)
|
Licence
|
Annual Update Support
|
Annual Internal Support (hrs)
|
14
|
Desktop
|
Per Desktop
|
Initial
|
Annual
|
Initial
|
Annual
|
15
|
Operating System
|
100.00
|
0.00
|
10.00
|
2.00
|
100.00
|
0.00
|
10.00
|
2.00
|
16
|
Office Productivity Tools
|
250.00
|
0.00
|
30.00
|
12.00
|
250.00
|
0.00
|
30.00
|
12.00
|
15
|
|
Office
|
250.00
|
0.00
|
30.00
|
3.00
|
250.00
|
0.00
|
30.00
|
3.00
|
15
|
Mail / Groupware
|
0.00
|
0.00
|
0.00
|
2.00
|
0.00
|
0.00
|
0.00
|
2.00
|
15
|
Personal Database
|
0.00
|
0.00
|
0.00
|
5.00
|
0.00
|
0.00
|
0.00
|
5.00
|
15
|
Browser
|
0.00
|
0.00
|
0.00
|
2.00
|
0.00
|
0.00
|
0.00
|
2.00
|
16
|
Client Access Licences
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
17
|
|
Windows
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
17
|
Exchange
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
17
|
Windows TSE
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
17
|
SQL
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
17
|
CORE
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
17
|
Citrix
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
15
|
Anti-Virus/ Spam
|
20.00
|
6.00
|
0.00
|
75.00
|
20.00
|
6.00
|
0.00
|
75.00
|
15
|
Virtual Private Network
|
200.00
|
180.00
|
0.00
|
1.00
|
200.00
|
180.00
|
0.00
|
1.00
|
15
|
Remote Firewall
|
10.00
|
5.00
|
0.00
|
1.00
|
10.00
|
5.00
|
0.00
|
1.00
|
Migration Costs
Initial Costs
Note No.
|
|
Number of people, templates etc
|
Cost per person, template etc
|
Total Cost
|
30
|
Training
|
|
33
|
|
User
|
4,000
|
300.00
|
1,200,000
|
34
|
Sysadmins
|
5
|
1,000.00
|
5,000
|
34
|
System Support
|
35
|
10,000.00
|
350,000
|
35
|
Programmers
|
30
|
1,000.00
|
30,000
|
31
|
Conversion
|
|
36
|
|
Templates
|
600
|
300.00
|
180,000
|
36
|
Macros
|
500
|
400.00
|
200,000
|
32
|
Application Rewrites
|
|
37
|
|
TSE/Citrix
|
50
|
10,000.00
|
500,000
|
38
|
Application Porting
|
20
|
20,000.00
|
400,000
|
38
|
Complete Rewrites
|
4
|
300,000.00
|
1,200,000
|
Annual Costs
|
Server Type
|
Concur- rent users per server
|
One server per site
|
No of servers required
|
Hard- ware Initial
|
Hard- ware Annual
|
Soft- ware Initial
|
Soft- ware Annual
|
|
Migration Specific
|
40
|
Remote Display
|
1
|
1,000
|
1
|
10
|
95,000
|
14,250
|
0
|
0
|
|
TOTALS
|
|
95,000
|
14,250
|
0
|
0
|
Migration Summary
|
Initial
|
Annual
|
Total Hardware
|
95,000
|
14,250
|
Total Software
|
2,480,000
|
0
|
Total People
|
1,585,000
|
20,000
|
TOTALS
|
4,160,000
|
34,250
|
Variables used in the model
Note No.
|
|
1
|
Desktop Description
|
Type
|
Initial Cost
|
Annual Maint
|
Annual Support (hrs)
|
Life (Yrs)
|
2
|
Type 1 - OSS internal desktop
|
1
|
675.00
|
75.00
|
5.00
|
4.00
|
2
|
Same as Type 1 but includes cost of connection
equipment - modems etc
|
2
|
860.00
|
80.00
|
5.00
|
4.00
|
2
|
Type 3 - Internal Proprietary desktop before upgrade
|
3
|
850.00
|
125.00
|
5.00
|
4.00
|
2
|
Type 4 - Internal Proprietary desktop after upgrade
|
4
|
950.00
|
140.00
|
5.00
|
4.00
|
2
|
Same as Type 3 but includes cost of connection
equipment - modems etc
|
5
|
1,035.00
|
130.00
|
5.00
|
4.00
|
2
|
Same as Type 4 but includes cost of connection
equipment - modems etc
|
6
|
1,135.00
|
145.00
|
5.00
|
4.00
|
3
|
Server Description
|
TYPE
|
INITIAL COST
|
ANNUAL MAINT
|
|
|
4
|
Null Server for use where where cost is included in
total package eg firewall or for shared services.
|
0
|
0.00
|
0.00
|
|
|
4
|
1.5 GHz Quad processors 2 Gb RAM, Dual power supplies,
dual network controllers, rack mounted
|
1
|
9,500.00
|
1,425.00
|
|
|
4
|
2.4 GHz Dual processors 1 Gb RAM, Dual power supplies,
dual network controllers, rack mounted
|
2
|
7,500.00
|
1,125.00
|
|
|
4
|
650 MHz Quad processors, 4 Gb RAM, Dual power supplies,
dual network controllers, rack mounted
|
3
|
5,000.00
|
750.00
|
|
|
4
|
|
4
|
|
|
|
|
4
|
|
5
|
|
|
|
|
4
|
|
6
|
|
|
|
|
5
|
Number of working days in a year
|
260.00
|
6
|
Number of working hours per day
|
8.00
|
Notes
The model is to help produce a cost comparison between OSS and
proprietary installations. The OSS architecture assumes a network centric
model where user authentication is done by a server, user files are held on
a central file server and emails on an email server. The proprietary model
tries to provide options to cover all scenarios. This means that many of the
fields may need to be set to zero for any one particular case.
|
There are a number of simplifying assumptions. For instance no attempt is
made to model the accounting policies relating to depreciation or the
effects of taxation. The model is intended to give managers a feel for where
the major costs and cost differences lie.
|
Notes
|
1
|
This is a list of desktop types referred to in the model. Change the
details as appropriate. If inserting a new row make sure the desktops data
range which covers the whole table still does so.
|
2
|
Enter the details as shown by the headings. The Desktop Description is
not used elsewhere and so is just a convenient marker. The Type must be a
unique number and is used as an index. The initial cost should not include
the operating system. The annual support is an estimate of the support
required for the hardware not the software installed on it. The number of
desktops replaced every year is calculated as TOTAL/LIFE(YRS).
|
3
|
This is a list of server types referred to in the model. Change the
details as appropriate. If inserting a new row make sure the servers data
range which covers the whole table still does so.
|
4
|
Enter the details as shown by the headings. The Server Description is not
used elsewhere and so is just a convenient marker. The Type must be a unique
number and is used as an index. The annual support is an estimate of the
support required for the hardware not the software installed on it.
|
5
|
This is used to calculate the daily cost of an Administration support
person. All such people are assumed to work the same number of days.
Strictly the number should not include holidays.
|
6
|
This is used to calculate the hourly cost of an Administration support
person. All such people are assumed to work the same number of hours.
|
7
|
The Desktop type is a pointer to the list of desktops in the variables
sheet. If an appropriate desktop is not defined then set up a new one.
|
8
|
This is the length of time required to set up the hardware and software
on a typical desktop. It is assumed that the person doing this is a systems
support person.
|
9
|
The details of the hardware is found from the list of desktops in the
variables sheet by using the desktop type entered.
|
10
|
The details are found from the Base Data at the bottom of the sheet.
|
11
|
This is intended to show the cost of supporting thin client/remote
display applications already deployed in the proprietary installation.
Remote display applications created as part of the migration are shown on
the migration sheet. The details are found from the Base Data at the bottom
of the sheet.
|
12
|
This assumes that the remote desktop uses a VPN. If not then set the Base
Data at the bottom of the sheet to contain whatever additional software is
required over an internal desktop to allow connection to be made.
|
13
|
This assumes that because the desktop is isolated then some sort of
firewall protection is required on it . The details are found from the Base
Data at the bottom of the sheet.
|
14
|
Insert details of the relevant software here. If a particular group is
not used then insert zeros. The costs are assumed to be per desktop and not
per potential user.
|
15
|
Enter the details under the appropriate heading. If the feature is not
used or available enter zero. The licence is able to have both an initial
and an annual component. If both are entered then both are assumed payable
in the first year. The annual update is provided in case this is a
separately chargeable item. The annual support is the time taken by internal
support people to manage the software once installed, including help desks.
|
16
|
This line is the total of the office items below. IT IS NOT AN INPUT
FIELD.
|
17
|
Enter the details of any user based client access licences that will be
needed for applications which were already thin client/remote display in the
proprietary installation. If there are none enter zeros.
|
18
|
Enter the details of any server based client access licences that will be
needed for applications which were already thin client/remote display in the
proprietary installation. If there are none enter zeros.
|
19
|
The age distribution of the desktops is assumed to be uniform and so the
same proportion is replaced each year. However when the installation
upgrades it could be assumed that all desktops are immediately replaced. The
is probably unreasonable and this parameter allows the newer ones to be
retained with only the older ones replaced. Also this parameter is only used
if the desktop type changes at upgrade.
|
20
|
This is the cost of a typical systems support person. Such a person would
be a help desk operator, a hardware support engineer etc. This should be the
cost to the Administration of employing him/her and so should include costs
other than just salary. For instance pension contributions and additional
employer taxes.
|
21
|
This is the cost of a typical systems administration person. Such a
person would be someone responsible for maintaining one or more server
types. They are likely to be more qualified than the systems support person.
This should be the cost to the Administration of employing him/her and so
should include costs other than just salary. For instance pension
contributions and additional employer taxes.
|
22
|
This is the annual cost of managing licences. This could on fact be zero
but most organisations ought to attend to their compliance with licence
conditions and this will incur a cost. This number is just included as a
flat annual charge in the comparison.
|
23
|
The number of systems administrators is calculated by dividing the total
number of servers by this parameter.
|
24
|
The cost of servers is spread over the number of years specified here.
Hence in any year a charge is made of the annual amount plus the initial
amount divided by this parameter.
|
25
|
Enter the server type, the number of concurrent users for the particular
service and the per site indicator. The server types are in the variables
sheet. There is a null server type with zero hardware costs to allow for the
situation where physical boxes may provide multiple services. In this case
set one of the services to the real server type and the others to the null
type. The number of servers required is calculated as one per site ( if the
one per site indicator is set to 1 ) together with what is needed to server
the remaining number of users. The cost of each service is based on the
details in the Base Data at the bottom of the sheet. The number of users is
that input to the Summary sheet. The number of mail users could be
considerably different if virtual users are allowed. The comparison doesn't
support this difference at the moment.
|
26
|
These services are assumed to be Domain Controllers and other network
services etc.
|
27
|
Enter the cost of software for each service under the relevant heading.
All costs are per user and each user in the total number of users in the
summary is assumed to make use of the service. The cost should include the
operating system as well as the specific service software. Where physical
servers provide multiple services then the cost of the operating system will
need to be included in only one of the services sharing the machine to stop
double counting. If a particular service is not used then insert zeros.
|
28
|
This service is to allow for the continuation of a Unix style centralised
office server displaying on the desktop in a thin client environment.
|
29
|
This service is to allow for the continuation of remote display thin
client applications which were available before the migration.
|
30
|
This section allows estimates of the training costs to be entered. Only
the training required to bring people up to their current level of
capability in the proprietary installation should be included. Training for
new employees for instance should not be included if that level of training
would have been given in the proprietary installation as well.
|
31
|
Conversion costs should be for a like for like conversion. However
Administrations may take the opportunity to upgrade their code and this cost
should be removed if possible.
|
32
|
Application rewrite costs should be on a like for like basis. However
Administrations may take the opportunity to upgrade their code and this cost
should be removed if possible.
|
33
|
User training may be needed to familiarise the users with a different
user interface and possibly also a different system architecture and
security model.
|
34
|
Systems staff will need comprehensive training if the proprietary
installation is not UNIX like.
|
35
|
If the Administration has its own programming staff then they will need
to be trained in the new environment if the current one is not UNIX like.
|
36
|
The cost of converting templates and macros will depend on their
complexity. Only after a thorough inspection will Administrations be able to
put reasonably accurate estimates for their own site here. A pilot study
would provide a good start.
|
37
|
This is for applications that have to be converted to a remote display
architecture in order to migrate them. It is not the cost of applications
which were already in this format unless they need changing because they do
not work for some reason under the new environment.
|
38
|
The costs of legacy applications being ported or rewritten are
significantly different. Care has to be taken to make sure that only those
costs incurred because of a migration are included. A complete rewrite may
well significantly improve the functionality of an application and the cost
should only be allowed if not including these improvements would not
significantly alter the cost. Porting is likely to be a few changes to
detail whereas a rewrite may be in a completely different programming
language.
|
39
|
This is to cover estimates of the excess costs of running an OSS
environment not covered elsewhere. They could be for example higher initial
user training because OSS not widely used. Any amount in here is likely to
be very subjective until sufficient long term experience is available. The
parameter is included for completeness.
|
40
|
This is for servers required to run remote display applications which
have been written as part of the migration. The costs here may get mixed up
with existing remote display servers and it may be difficult to obtain
accurate input.
|
|