Docstoc

Migration

Document Sample
Migration Powered By Docstoc
					Cost Comparison Model                                                                                                                                 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.




               The green boxes are input fields. There are input fields on the OSS, proprietary and variables sheets as well.



                                                                                   Enter the total number of desktop machines connected to the
                    Number of Internal Desktops               3,500
                                                                                   Administration's network behind firewalls.
                                                                                   Enter the total number of desktops machines which are
                   No of Remote /Home Desktops                 100
                                                                                   connected via a WAN

                       Total Number of users                  4,000                Enter the total number of users bothe internal and remote

                             No of sites                        10                 Enter the number of sites with server installations.

                                                                                   Enter the year in which the proprietary software is assumed to
                    Year of Proprietary Upgrade                 3
                                                                                   be upgraded.




                                            YEAR                1                  2                 3                  4                    5




                                           Hardware         1,333,754        1,333,754           2,365,754           618,129              1,449,379

                 Cost of Proprietary       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




                                           Hardware         1,153,407        1,153,407           1,153,407          1,153,407             1,153,407

                    Cost of FOSS           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




                                           Hardware          109,250           14,250             14,250             14,250                14,250

                  Cost of Migration        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




                                                                    Page 1 of 11
Cost Comparison Model                                                                                                          Open Source Software (OSS)



                        Internal Desktop


                                                                                       Costs per Desktop
                        Note
                        No.
                                                                                          Annual
                                                                                                      Annual
                                                                                         Maintena               Total Annual
                                                                         Initial                     Internal
                                                                                         nce/Licen              Expenditure
                         7       Desktop Type           1                                            Support
                                                                                            ce

                         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
                                                                                       Costs per Desktop

                                                                                          Annual
                                                                                                      Annual
                                                                                         Maintena               Total Annual
                                                                         Initial                     Internal
                                                                                         nce/Licen              Expenditure
                         7       Desktop Type           2                                            Support
                                                                                            ce

                         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




                                                                        Page 2 of 11
Cost Comparison Model                                                                                                                                Open Source Software (OSS)



                        Servers



                        Note
                        No.


                               Number of Severs per Systems
                         23                                          20
                                      Administrator

                         24       Average life of a server            7




                                                                               Concurrent    One       No of
                                                                                                                Hardware    Hardware   Software   Software
                                                                 Server Type    users per server per servers
                                                                                                                  Initial    Annual     Initial    Annual
                                                                                 server      site    required


                         25            Web Services                   3          5,000        0         1         5,000       750         0          0


                         25    Mail and Groupware 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




                                                                                Page 3 of 11
Cost Comparison Model                                                                                                                   Proprietary Installation



                        Internal Desktop



                                                                                             Costs per Desktop
                        Note
                        No.
                                   Current Environment                                          Annual       Annual         Total
                                                                         Initial              Maintenanc     Internal      Annual
                         7      Desktop Type           3                                       e/Licence     Support     Expenditure


                         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


                                      After Upgrade                                             Annual       Annual         Total
                                                                         Initial              Maintenanc     Internal      Annual
                         7      Desktop Type           4                                       e/Licence     Support     Expenditure


                         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




                                                                          Page 4 of 11
Cost Comparison Model                                                                                                                   Proprietary Installation


                        Remote Desktop – Homeworker



                                                                                             Costs per Desktop
                        Note
                        No.
                                  Current Environment                                           Annual       Annual         Total
                                                                         Initial              Maintenanc     Internal      Annual
                         7      Desktop Type           5                                       e/Licence     Support     Expenditure


                         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                                             Annual       Annual         Total
                                                                         Initial              Maintenanc     Internal      Annual
                         7      Desktop Type           6                                       e/Licence     Support     Expenditure


                         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




                                                                          Page 5 of 11
Cost Comparison Model                                                                                                                                             Proprietary Installation


                        Servers




                        Note
                        No.


                                 Number of Severs per
                         23                                         15
                                 Systems Administrator

                         24      Average life of a server            7




                                                                              Concurrent    One          No of
                                                                                                                   Hardware    Hardware   Software    Software
                                                                Server Type    users per server per     servers
                                                                                                                     Initial    Annual     Initial     Annual
                                   Current Environment                          server      site       required


                         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

                                 Remote Display Servers
                         25                                          0            0           0           0            0          0          0           0
                                    (e.g.TSE/Citrix)

                         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




                                                                              Concurrent    One          No of
                                                                                                                   Hardware    Hardware   Software    Software
                                                                Server Type    users per server per     servers
                                                                                                                     Initial    Annual     Initial     Annual
                                      After Upgrade                             server      site       required


                         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

                                 Remote Display Servers
                         25                                          0            0           0           0            0          0          0           0
                                    (e.g.TSE/Citrix)

                         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




                                                                                 Page 6 of 11
      Cost Comparison Model                                                                 Migration Costs
                                      Number of     Cost per
Note
                                       people,      person,      Total Cost
No.
                                    templates etc template etc


 30           Training


 33                        User        4,000         300.00      1,200,000


 34                   Sysadmins          5          1,000.00       5,000

                         System
 34                                      35        10,000.00      350,000
                         Support

 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

                      Application
 38                                      20        20,000.00      400,000
                       Porting
                         Complete
 38                                      4        300,000.00     1,200,000
                         Rewrites




Annual Costs


 39         Miscellaneous              20,000




                                                  Concurrent                    No of
                                                                 One server              Hardware   Hardware   Software
                                    Server Type    users per                   servers
                                                                  per site                Initial    Annual     Initial
          Migration Specific                        server                    required


 40        Remote Display                1           1,000           1          10        95,000     14,250       0


              TOTALS                                                                      95,000     14,250       0




                                                        Page 7 of 11
Cost Comparison Model                              Migration Costs

  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




                                    Page 8 of 11
                                                          Variables




Variables used in the model.


Note
 No


                                                                                                             Annual
 1                       Desktop Description                          TYPE   INITIAL COST   ANNUAL MAINT                   LIFE (YRS)
                                                                                                           Support (hrs)


 2                  Type 1 - OSS internal desktop                      1        675.00          75.00          5.00           4.00



           Same as Type 1 but includes cost of connection
 2                                                                     2        860.00          80.00          5.00           4.00
                     equipment - modems etc



 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



           Same as Type 3 but includes cost of connection
 2                                                                     5       1,035.00        130.00          5.00           4.00
                     equipment - modems etc


           Same as Type 4 but includes cost of connection
 2                                                                     6       1,135.00        145.00          5.00           4.00
                     equipment - modems etc




 3                       Server Description                           TYPE   INITIAL COST   ANNUAL MAINT


       Null Server for use where where cost is included in total
 4                                                                     0         0.00           0.00
              package eg firewall or for shared services.


          1.5 GHz Quad processors 2 Gb RAM, Dual power
 4                                                                     1       9,500.00       1,425.00
          supplies, dual network controllers, rack mounted


          2.4 GHz Dual processors 1 Gb RAM, Dual power
 4                                                                     2       7,500.00       1,125.00
          supplies, dual network controllers, rack mounted


         650 MHz Quad processors, 4 Gb RAM, Dual power
 4                                                                     3       5,000.00        750.00
         supplies, dual network controllers, rack mounted



 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




                                                           Page 1
Cost Comparison Model                                                                                                                                              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.



              Note

                          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
               1
                          desktops data range which covers the whole table still does so.
                          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 operatingsystem. The annual
               2
                          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).
                          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
               3
                          servers data range which covers the whole table still does so.
                          Enter the details as shown by the headings. The Server Description is not used elsewhere and so is just a convenient marker.
               4          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.
                          This is used to calculate the daily cost of an Administration support person. All such people are assumed to work the same
               5
                          number of days. Strictly the number should not include holidays.
                          This is used to calculate the hourly cost of an Administration support person. All such people are assumed to work the same
               6
                          number of hours.
                          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
               7
                          new one.
                          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
               8
                          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.
                          This is intended to show the cost of supporting thin client/remote display applications already deployed in the proprietary
              11          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.
                          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
              12
                          additional software is required over an internal desktop to allow connection to be made.
                          This assumes that because the desktop is isolated then some sort of firewall protection is required on it . The details are found
              13
                          from the Base Data at the bottom of the sheet.
                          Insert details of the relevant software here. If a particular group is not used then insert zeros. The costs are assumed to be per
              14
                          desktop and not per potential user.
                          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
              15
                          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.
                          Enter the details of any user based client access licences that will be needed for applications which were already thin
              17
                          client/remote display in the proprietary installation. If there are none enter zeros.
                          Enter the details of any server based client access licences that will be needed for applications which were already thin
              18
                          client/remote display in the proprietary installation. If there are none enter zeros.
                          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
              19
                          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.
                          This is the cost of a typical systems support person. Such a person would be a help desk operator, a hardware support engineer
              20          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 contricutions and additional employer taxes.
                          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
              21
                          Administration of employing him/her and so should include costs other than just salary. For instance pension contricutions and
                          additional employer taxes.
                          This is the annual cost of managing licences. This could on fact be zero but most organisations ought to attend to their
              22          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.
                          The cost of servers is spread over the number of years specified here. Hence in any year a charge is made of the annual
              24
                          amount plus the initial amount divided by this parameter.
                          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
              25          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.




                                                                    Page 2 of 11
Cost Comparison Model                                                                                                                                     Notes

                    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
              27    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.
                    This service is to allow for the continuation of a Unix style centralised office server displaying on the desktop in a thin client
              28
                    environment.
              29    This service is to allow for the continuation of remote display thin client applications which were available before the migration.




                                                              Page 3 of 11

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:11/25/2011
language:English
pages:11