Business Case Best Buy

Document Sample
Business Case Best Buy Powered By Docstoc
					Customer Data Integration Business Case Calculator
This calculator has been developed by Data Connects and RSe Consulting to establish the business case for Customer Data Integration (CDI) in a
local authority environment.

It is designed to support local authorities in assessing the impact Customer Data Integration could have on their business and calculates
the business case based on best practice assumptions whilst allowing for context specific customisation.

If you make use of this calculator or would like to find out more about Customer Data Integration or Master Data Management, we'd be delighted to
hear from you. Please email your thoughts, completed calculator outputs or any other CDI related material to info@rseconsulting.co.uk
or veni.kotak@brent.gov.uk.

Background to Customer Data Integration
Instructions on how to use the calculator


Background to Customer Data Integration

In the past decade local authorities have become increasingly dependent upon new IT systems to deliver Value for Money services. However,
these systems are limited as customer data is usually fragmented, often riddled with data quality problems and plagued by the absence of a
 'single version of the truth'.

Private sector companies, and now some local authorities, are addressing these issues through customer data management, often using
Customer Data Integration (CDI) systems.

CDI is often talked about alongside 'Master Data Management' or MDM. The objective of MDM is to provide and maintain a consistent view of
an organisation’s core business entities, which may involve data that is scattered across a range of application systems. The type of data
involved in this process varies by industry and organisation, but examples include customers, suppliers, products, employees and finances. CDI
is a type of MDM because it concentrates on customer data specifically.

We define CDI as:
"the combination of process and technology used to manage customer information from all sources available to the enterprise and ensure that
the most current and comprehensive view of customer data is available enterprise-wide."

In practice this means collecting customer data from a number of systems and using matching techniques to identify common individuals
and organisations. The combined customer knowledge can be applied to:
1. Improve data quality
2. Give a cross-service single customer view
3. Rationalise and improve security / storage

                                                                  People

                                                            Children    Libraries    Customer   Schools &        LLPG
                                     Benefits    Housing
                                                           & Families   & Cultural   Services   Education
                                                                         Services



                                     Electoral   Council     Adult
                                                                        Registrars   Parking
                                        Roll      Tax        Social
                                                            Services




                                                                                                                                   Staff


                                                            CDI Technology                                  Single Customer View
Instructions on how to use the calculator

The calculator is structured in terms of input sheets (project summary, input, qualitative impact and project risks sheets), outcome sheets
(headline and results) and methodology sheets (benefits and costs).

Users must fill in the project summary tab for the calculator to work; the other blue input sheets are optional

Project summary - This sheet must be filled in by all users as it determines which service areas are ruled in and out
of the business case calculations. It asks users to answer basic questions such as authority name, type and
scope of project.

Input - This sheet is optional but we recommend that users fill it in as accurately as possible. It asks users specific
questions about the service areas that will be affected by the solution. If you do not know the answer to a specific
question a default figure will be auto populated from the calculator's bank of assumptions.

Qualitative impact - This has been pre-populated based on interviews with service area representatives. It has been
sub-divided into general benefits and service area specific benefits, and each one has been assigned a ranking. If you
disagree with the assessment you may amend the impact and/or ranking on this sheet. If you think there are additional
 qualitative benefits (general or specific) you may also add these to the sheet.

Project risks - This has been pre-populated based on interviews with service area representatives. You may add to it if
you believe there are further project risks associated with the project or you disagree with the assessment of likelihood
and impact.

Headline - This sheet gives a snapshot picture of the financial benefits, project risks and qualitative impact of the
project. It is designed to be used as a single page introduction to a potential CDI project and therefore stands alone.

Results - This sheet gives a more detailed analysis of the financial business case, project risks and qualitative
impact of the project, with breakdowns of types across years.

Benefits - This sheet shows the working for the benefits calculations and contains any assumptions used. It is based on
best practice research and the answers provided in the input sheet. If you believe there are further benefits you may add
these at the bottom of the table.

Costs - This sheet shows the working for the costs calculations and contains any assumptions used. It is based on
best practice research and the answers provided in the input sheet.

Please navigate between sections using the tabs at the bottom of the workbook.
Project summary
This section records basic information about the project. Your answers will determine the assumptions the calculator uses to establish the impact of the project on
your authority. Subsequent sections ask more detailed questions to develop a more accurate picture.
Note: You must answer the blue boxes in A1, A2, A3 and A4 fully for the calculator to work.

Key

         Input estimates in blue boxes

         Write any comments qualifying your answer in the green boxes

         Leave cell blank

Basic questions
A1     Write in local authority name
A2     Select authority type
A3     Type of solution                                                                                         (For a detailed description of 'type of solution, follow the hyperlink to the left)

A4     Select the service areas you think will use the CDI solution:                                            Notes

       Customer Services
       Benefits (Housing and Council Tax)
       Housing
       Revenues (Council Tax)
       Childrens and Families
       Adults Social Services
       Schools & Education
       Libraries and Cultural Services
       Electoral Roll
       Registrars
       Parking
       Other please specify:


A5     Your contact details:

       Name
       Telephone number / extension
       Email


Type of solution

We see CDI solutions in terms of three levels, as outlined in the diagram below. At each level the application of the integrated data gets deeper.


                                                                               Collation and
                                                                                                        Single Customer
                                                             Level 1       matching of Customer
                                                                                                              View
                                                                                   Data
                                       Greater Integration




                                                                            Feedback of single
                                                                            point customer data           Improved Data
                                                             Level 2        changes to all LoB               Quality
                                                                                  systems




                                                                              Systems access
                                                                                                          Rationalisation
                                                             Level 3         common customer
                                                                                                           and Security
                                                                                master data



At each level the costs will also increase. However, greater benefits will accrue as well. Owing to the current complexity of local authority application estates, Level 3 CDI is unlikely
to be achieved and the associated costs and benefits have not been assessed or included within this calculator.

The first level involves the collation and matching of Customer Data into a central information hub. This step leads to the 'Single Customer View', whereby the complete
history of a customer's interaction with the authority can be seen at a glance. The extent to which it is complete will however depend on the service areas involved.

The second level is the feedback of this 'single customer view' to service areas within a local authority. Rather than an ad hoc looking up of data from the hub, updates are
automatically fed through to service area systems. This results in a significant improvement of data quality.

The final, third level, is the point at which existing service area systems are rationalised.


End                                                                                                                                                                                  Top
Time and money input sheet
This section asks specific questions about the benefits and costs to the service areas impacted by the project. Use the key below to fill in the correct boxes.
Key

           Input estimates in blue boxes.                                                                            Write any comments qualifying your answer in the green boxes

           Use default values pre-populated in the yellow boxes if you cannot make estimates                          Leave cell blank


Overall contents
Benefits
Costs


Benefits
Contents

Generic
Customer services
Benefits (Housing and Council Tax)
Housing
Revenues (Council Tax)
Childrens Social Services
Adults Social Services
Schools and education
Libraries and Cultural Services
Electoral Roll
Registrars
Parking

Generic                                                                                                            Your estimate              Value used                Comments

A1      Total number of outbound calls per month from all service areas

Customer services

B1      Number of logged calls per month in customer services system

Benefits (Housing and Council Tax)

C1      Amount of overpaid benefits per year

C2      Number of deceased customers per year
C3      Number of applications involving incorrect data per week
C4      Number of people claiming 'right to buy' benefit

C5      Proportion of those claiming 'right to buy' benefit that don't declare asle inside period

Housing

D1      Number of visits made by repairs team per year

D2      Proportion of aborted visits by repairs team

D3      Number of placements made per year

D4      Percentage of placements that fail

D5      Percentage of failed placements that could succeed with access to correct information

D6      Number of households in local authority accomodation

D7      Number of deceased customers living in council accomodation per year

Revenues (Council tax)

E1      Amount of Single Person Discount claimed per year

E2      Proportion of Single Person Discount being incorrectly claimed per year

E3      Number of properties declared empty

E4      Average council tax per year

E5      Number of changes in occupancy per year

E6      Number of customers who have not paid council tax within 9 months of being issued notice

Childrens and Families

No evidence for quantifiable benefits was identified in Childrens and Families Social Services

Adults Social Services

No evidence for quantifiable benefits was identified in Adults Social Services

Schools & Education

No evidence for quantifiable benefits was identified in Schools and Education

Libraries and Cultural Services

No evidence for quantifiable benefits was identified in Libraries and Cultural Services

Electoral roll

No evidence for quantifiable benefits was identified in Electoral Roll

Registrars

No evidence for quantifiable benefits was identified in Registrars

Parking

L1      No of PCNs issued

L2      Average value of PCN
L3      Percentage of PCNs not recovered
Qualitative Input
This sheet captures the non-financial impact of your CDI project. It has been sub-divided between generic and service specific benefits and is based on RSe best practice research. Assessments of impact and ranking have
been pre-populated based on this research. You may rank your top five benefits by filling the relevant blue boxes. Note: If you to choose to rank your top five benefits, you must provide a ranking for 5
benefits, otherwise the calculator will not work.

Key

      Input estimates in blue boxes.                                                                               Write any comments qualifying your answer in the green boxes

      Use default values pre-populated in the yellow boxes where you cannot make estimates                         Leave cell blank



Each section has 'other' categories, for you to use if the project will have qualitative benefits that do not fit into the preset categories.

Contents

Generic benefits
Customer services
Benefits (Housing and Council Tax)
Housing
Revenues (Council Tax)
Childrens Social Services
Adults Social Services
Schools and education
Libraries and Cultural Services
Electoral Roll
Registrars
Parking
                                                                                                                             Default
Generic benefits                                                                                         Impact      Ranking Impact             Benefit type used            Level             Comments

A1 Improved customer profiling to offer more personalised service                                                                         4     Service planning             Level 1: SCV

A2 More consistent service                                                                                                                4     Customer                     Level 2: DQ

A3 Speedier service delivery from access to complete customer record                                                                      4     Customer                     Level 1: SCV

A4 More proactive service from identifying changes in circumstance                                                                        4     Customer                     Level 1: SCV

A5 Improves NI 14 figure (reducing avoidable contact) as don't need to repeat information                                                 3     Performance indicator        Level 2: DQ

A6 Helps keep customers well informed about available services                                                                            3     Customer                     Level 1: SCV

A7 More accurate population data                                                                                                          1     Service planning             Level 1: SCV

A8 Provides platform for future transformation                                                                                            2     Customer                     Level 2: DQ

A9 Directing services towards neglected groups                                                                                            4     Customer                     Level 1: SCV

A10Other , please specify

A11Other , please specify



Customer services

B1 Speedier service delivery from access to complete customer record                                                                      3     Customer                     Level 1: SCV

B2 Better tailoring of contact to customer circumstance from better customer data                                                         2     Customer                     Level 2: DQ

B3 Other, please specify

B4 Other, please specify

Benefits (Housing and Council Tax)

C1 Inform clients about benefits they are eligible for but not claiming                                                                   5     Customer                     Level 1: SCV

C2 Identifying change of circumstances known to Council but not Benefits                                                                  3     Customer                     Level 2: DQ

C3 Reducing disruption caused by cross service queries and validation                                                                     4     Internal service user        Level 1: SCV

C4 Flagging more potentially fraudulent cases to the Audit and Investigation Team                                                         3     Staff                        Level 1: SCV

C6 Other, please specify

C7 Other, please specify

Housing

D1 Avoiding aborted visits to tenants by confirming appointments by telephone                                                             2     Staff                        Level 2: DQ

D2 Reminding customers about overdue rent arrears through preferred access channel                                                        3     Customer                     Level 2: DQ

D3 Improved ability to track cases of customers sub-letting council properties                                                            2     Service planning             Level 1: SCV

D4 Placing customers in more suitable housing                                                                                             2     Customer                     Level 1: SCV

D6 Other, please specify

D7 Other, please specify


Revenues (Council tax)

E1 Proactive contact with new residents to inform of requirement to pay Council Tax                                                       1     Customer                     Level 1: SCV

E2 Provide Direct Debit statements through preferred customer access channels                                                             2     Customer                     Level 2: DQ

E3 More intelligent chasing of outstanding debtors based on their profile                                                                 4     Service planning             Level 1: SCV

E4 Other, please specify

E5 Other, please specify


Childrens and Families
F1 Identifying children potentially at risk who are not known to Childrens & Families   5   Customer                Level 1: SCV

F2 Personalised service reflecting change of circumstances                              3   Customer                Level 1: SCV

F3 More joined up working between teams in department                                   3   Internal service user   Level 1: SCV

F4 Other, please specify

F5 Other, please specify

Adults Social Services

G1 Increasing awareness and take up of freedom passes                                   3   Customer                Level 1: SCV

G2 Verifying information obtained in home care assessments                              3   Internal service user   Level 1: SCV
G3 Reducing fraudulent disability grant claims                                          1   Service planning        Level 1: SCV

G4 Maintaining accurate list of people who do not want to be contacted by council       2   Customer                Level 2: DQ
G5 Reducing time spent verifying if a customer is receiving benefits                    3   Internal service user   Level 1: SCV

G3 Other, please specify

G4 Other, please specify

Schools & Education

H1 Identifying children who are playing truant                                          1   Performance indicator   Level 1: SCV

H2 Increasing take up of free school meals                                              2   Customer                Level 1: SCV

H3 Verfiying school applications                                                        3   Staff                   Level 1: SCV

H4 Other, please specify

H5 Other, please specify

Libraries and Cultural Services

I1 Improving quality of service by contacting customers via preferred channel           1   Customer                Level 2: DQ

I2 Personalising library services to specific groups based on increased knowledge       2   Service planning        Level 1: SCV

I3 Improving library take up through more effective marketing and customer knowledge    3   Performance indicator   Level 1: SCV

I4 Other, please specify

I5 Other, please specify

Electoral roll

J1 Improving accuracy and coverage of Electoral Roll                                    4   Performance indicator   Level 1: SCV   Leads to improved turnout

J2 Personalising service reflecting change of circumstances                             3   Customer                Level 1: SCV

J3 Increased trust between customer and Council                                         2   Customer                Level 1: SCV

J5 Other, please specify

J6 Other, please specify

Registrars

K1 Improving sharing between Registrars and other service areas                         3   Internal service user   Level 1: SCV   Data protection issues

K2 Reducing amount of information request calls between service areas                   4   Staff                   Level 1: SCV

K3 Other, please specify

K3 Other, please specify

Parking

L1 Improved ability to detect blue badge misuse                                         1   Customer                Level 1: SCV

L2 Faster processing of permits applications and renewals                               3   Customer                Level 1: SCV

L3 Other, please specify

L4 Other, please specify




M1 Other, please specify

M2 Other, please specify

M3 Other, please specify

M4 Other, please specify




End                                                                                                                                                         Top
Risks

Use this page to think about what risks the project involves. List each risk in the 10 boxes below and record each risk's likelihood
and impact. There are some typical risks with CDI which have been listed below. Update the likelihood and impact boxes or add or
remove risks. Note that this sheet does not cover the risks of not carrying out a CDI project.

Rate each risk you have identified on a scale of 1 - 5 for how likely it is to be a problem (1 = very unlikely, 5 = almost certain). Also
rate each risk on a scale of 1 - 5 according to how serious the problem would be (1 = low impact, 5 = critical impact).



            Short description            Likelihood      Impact           Notes

                                                                          More staff will have access to more information about a
 E1. A      Data security                            3               5    customer; this raises data protection and data privacy issues

                                                                          Staff need to be comfortable with using new applications
                                                                          otherwise they will not use it. Service areas need to trust the
 E2. B      Staff buy-in                             3               5    data from the CDI solution.

            Technology                                                    Council needs to procure software that fits their needs,
 E3. C      specification fit                        2               5    avoiding a systems led approach

                                                                          Data can be collected only opportunistically, not
                                                                          systematically, because many customers do not want to
            Customers do not want                                         provide information that will be used for services they have
 E4. D      to provide data                          2               4    not asked for
 E5. E      Funding not available                    3               5    High likelihood that funding will not be available

            Change management                                             BPI will probably be necessary to implement CDI solution
 E6. F      not carried out properly                 2               3    correctly

            Ownership of data can                                         Ensuring that there is collective responsibility about data,
 E7. G      be unclear                               2               1    not just IT thing

            Lack of clear senior                                          Service areas may not want to provide data. Management
            management buy-in to                                          and elected members need to be behind the project over a
            cross council data                                            long period (i.e. even when new people and/or parties are
 E8. H      sharing                                  3               4    elected).


                                                                          Lack of clarity about existing data quality and the investment
                                                                          needed to improve it may affect the return on investment.
                                                                          Also, some service areas will contain a large mass of low
            Uncertainties in                                              quality data. Matching this against high quality data may
 E9.    I   existing data quality                    3               4    result in a large mass of unmatched data.

E10.   J
E11. K



End                                                                                                                                  Top
 Customer Data
 Integration
Headline results

Business case for CDI at
Financial Impact

Based on information provided by ,supported by best practice research by RSe Consulting and Data Connects the cashable Return on Investment from
a CDI project should be £0,000 over five years. The table and graph below provides detail of how this is broken down. All figures are in £1,000s.


               Set up costs £             -                     Benefits                                               £0
              Ongoing costs £             -                     Costs                                                  £0




                                                                                                             £1,000s
                                                                                                                       £0
           Cashable benefits £            -                     Cumulative payback
                                                                                                                       £0
                                                                                                                       £0
             5 Year Payback £             -                                                                            £-
                       NPV £              -                                                                                    Year 1      Year 2     Year 3       Year 4   Year 5
        Non cashable impact £             -




The calculations are based on a project.
Altering the scope of the project will impact on both costs and benefits. Customer data will be collated and matched in a central hub and a single
The costs and benefits calculations are based on the following services making use of the CDI solution:
Customer Services                             Childrens Social Services                                                               Electoral Roll
Benefits (Housing And Council Tax)            Adults Social Services                                                                  Registrars
Housing                                       Schools & Education                                                                     Parking
Revenues (Council Tax)                        Libraries

Qualitiative benefits
The generic benefits of a CDI project are that customers receive a more proactive service based on their needs. This service is quicker, consistent and
uses more accurate information.
The top 5 service area specific benefits identified are:                                                                                             Service
   - Directing services towards neglected groups                                                                                                     Generic
   - Speedier service delivery from access to complete customer record                                                                               Generic
   - More proactive service from identifying changes in circumstance                                                                                 Generic
   - Improved customer profiling to offer more personalised service                                                                                  Generic
   - Helps keep customers well informed about available services                                                                                     Generic

The table and graph below separate out the type of qualitative benefits and their impact.
                                    0 to +5

               Customer          No impact

                   Staff         No impact

 Internal service users          No impact

        Service planning         No impact

 Performance indicator           No impact

                                                   0            +1                   +2                 +3                        +4                   +5
Risks


9 project risks have been identified. The three most
serious are:                                                                                     People
Risk                           Likelihood       Impact                                     Children                     Customer        Schools &
                                                                Benefits    Housing
                                                                                                       Libraries                                            LLPG
                                                                                          & Families   & Cultural       Services        Education
Funding not available              3/5            5/5                                                   Services
Staff buy-in                       3/5            5/5
Data security                      3/5            5/5
                                                                Electoral   Council         Adult
                                                                                                       Registrars           Parking
                                                                   Roll      Tax            Social
                                                                                           Services



About CDI

Customer Data Integration is about collecting customer
data from a number of systems and using matching                                                                                                                                     Staff
techniques to identify common individuals and
organisations. The combined customer knowledge can
be applied to:                                                                             CDI Technology                                           Single Customer View
1. Improve data quality
2. Give a cross-service single customer view
3. Rationalise and improve security / storage

Contact
The CDI business case calculator was completed by who can be reached on or e-mail
If you would like to find out more about the business case for Customer Data Integration or best practice in local authority implementations
please contact Tony Ellis, chair of Data Connects at tony.ellis@brent.gov.uk. Alternatively, you may contact RSe Consulting at
info@rseconsulting.co.uk for more information.


End                                                                                                                                                                                     Top
Financial breakdown
This page shows more detailed analysis of the inputs on the financial costs and benefits pages. All of the results on this page account
for an annual increase in prices (inflation) of 0%.

Contents of this page
Summary of costs and benefits (cashable)
Costs - broken down by type
Benefits - broken down by type


Summary of costs and benefits                                                    (cashable)                                                                                                     Top


This section shows the impact that the project will have on the organisation's budget. Costs that can be covered in existing capacity
and 'non-cashable' benefits are summarised in the costs, benefits and cashflow sections below.

                                     (£000's)                                 Year 1             Year 2               Year 3                 Year 4              Year 5            Total
                                      Costs                    £                  - £                  - £                  - £                  - £                 - £               -
                                    Benefits                        FALSE                   FALSE                FALSE               FALSE                 FALSE       £               -

                                   Cashflow                    £                  - £                  - £                  - £                  - £                 - £               -
                       Cumulative payback                      £                  - £                  - £                  - £                  - £                 -

                                                               £0
                                                               £0
                                                                £                 - £                  - £                  - £                  - £                 -
                                                               £0
         Benefits                                              £0
                                                               £0
                                                £1,000s




         Costs
                                                               £0
         Cumulative payback                                    £0
                                                               £0
                                                               £0
                                                               £0
                                                               £-
                                                                                 Year 1               Year 2                Year 3                    Year 4              Year 5




Costs - broken down by type                                                                                                                                                                     Top


This sections shows the costs each year, broken down by type. It also shows the costs that won't affect your budget (e.g. staff time
that doesn't involve new hires, temps or overtime).

                                     (£000's)                                 Year 1             Year 2               Year 3                 Year 4              Year 5                        Total
                              Cost: payable                    £                 -      £             -      £              -   £               -      £            -                      £       -
                 Cost: from existing capacity                  £                 -      £             -      £              -   £               -      £            -                      £       -
                                      Level 1                  £               517      £           148      £            123   £             123      £          123                      £   1,033
                                      Level 2                  £               301      £            42      £             42   £              42      £           42                      £     469


                                                                               Breakdown of costs by type (£000's)
    Cost: payable
                                                           £
                                                           £
                                                           £
                                                           £
                                           £1,000s




    Cost: from existing capacity                           £
                                                           £
                                                           £
                                                           £
                                                           £
                                                           £
                                                          £-
                                                                               Year 1               Year 2                Year 3                 Year 4                  Year 5



                                                                          Breakdown of costs by Level (£000's)


                                                                                £900
       Level 2        Level 1                                                   £800
                                                                                £700
                                                                                £600
                                                                    £1,000s




                                                                                £500
                                                                                £400
                                                                                £300
                                                                                £200
                                                                                £100
                                                                                  £-
                                                                                             Year 1              Year 2             Year 3              Year 4            Year 5
Benefits - broken down by type                                                                                                                                                             Top


This section shows the benefits each year, broken down by type. It also shows that benefits that won't affect your budget, which are
called 'non-cashable' benefits. Non-cashable benefits include staff time that can't be redeployed and avoided costs.

                                     (£000's)                                   Year 1                    Year 2            Year 3            Year 4                Year 5                Total   No show
                        Benefit: cashable                               FALSE                      FALSE               FALSE             FALSE              FALSE                     £       -
                    Benefit: non-cashable                           £                   -    £                -    £            -    £            -    £                -             £       -
                       Level 1: Cashable                            £                   -    £                -    £            -    £            -    £                -             £       -
                       Level 2: Cashable                            £                   -    £                -    £            -    £            -    £                -             £       -
                       Customer Services                            £                   -    £                -    £            -    £            -    £                -             £       -
       Benefits (Housing and Council Tax)                           £                   -    £                -    £            -    £            -    £                -             £       -   £         -
                                  Housing                           £                   -    £                -    £            -    £            -    £                -             £       -   £         -
                  Revenues (Council Tax)                            £                   -    £                -    £            -    £            -    £                -             £       -   £         -
                   Childrens and Families                           £                   -    £                -    £            -    £            -    £                -                         £         -
                     Adult Social Services                          £                   -    £                -    £            -    £            -    £                -             £       -   £         -
                     Schools & Education                            £                   -    £                -    £            -    £            -    £                -             £       -   £         -
           Libraries and Cultural Services                          £                   -    £                -    £            -    £            -    £                -             £       -   £         -
                             Electoral Roll                         £                   -    £                -    £            -    £            -    £                -             £       -   £         -
                                Registrars                          £                   -    £                -    £            -    £            -    £                -             £       -   £         -
                                   Parking                          £                   -    £                -    £            -    £            -    £                -             £       -   £         -
                                     Total                          £                   -    £                -    £            -    £            -    £                -             £       -


                                                                        Breakdown of cashable and non cashable benefits (£000's)

                 Benefit: cashable
                                                                                        £
                                                                                        £
                                                                                        £
                                                                                        £
                                                                             £1,000s




                 Benefit: non-cashable                                                  £
                                                                                        £
                                                                                        £
                                                                                        £
                                                                                        £
                                                                                        £
                                                                                       £-
                                                                                                     Year 1            Year 2            Year 3             Year 4           Year 5




                                                                                                 Breakdown of type of benefit (£000's)

                                                                        £
                   Level 2: Cashable                                    £
                                                                        £
                                                                        £
                                                                        £
                                                          £1,000s




                   Level 1: Cashable
                                                                        £
                                                                        £
                                                                        £
                                                                        £
                                                                        £
                                                                        £-
                                                                                            Year 1                 Year 2            Year 3                Year 4            Year 5




                                                                                                 Service area benefit breakdown: total (£000's)

                                                                                             £0
                                                                                             £0
                                                                                             £0
                                                                                             £0
                                                                                             £0
                                                £1,000s




                                                                                             £0
                                                                                             £0
                                                                                             £0
                                                                                             £0
                                                                                             £0
                                                                                             £0
    Discounted cash flow and Net Present Value                                                                                                                 Top       Top


    Discounting is a technique used to compare costs and benefits that occur at different points in time. It is based on the principle that people and organisations have a
    preference for consuming goods and services sooner and paying for them later. This preference is reflected in a discount rate.


    Discounting a cost or benefit gives its present value. The project's Net Present Value is the sum the present values of all cash movements related to the project.

    The Treasury recommends that public sector bodies use an annual discount rate of 3.5%. You can alter the annual discount rate used by the model in the box below.
    This does not affect any of the other results sections.

                                 Annual discount rate:

                                                     £000's   Year 1     Year 2         Year 3           Year 4          Year 5                       NPV
                                                 Cashflow          -           -              -                 -                -
                                 Present value of cashflow         -           -              -                 -                -                        -




    Qualitative impacts                                                                                                                                        Top

    This section breaks down the qualitative benefits across type and ranks the most important.

    The generic benefits identified through RSe best practice research and estimates provided by are:
           1 Improved customer profiling to offer more personalised service
           2 More consistent service
           3 Speedier service delivery from access to complete customer record
           4 More proactive service from identifying changes in circumstance

    The top 5 service area specific benefits are:
            1 Directing services towards neglected groups (Generic)
            2 Speedier service delivery from access to complete customer record (Generic)
            3 More proactive service from identifying changes in circumstance (Generic)
            4 Improved customer profiling to offer more personalised service (Generic)
            5 Helps keep customers well informed about available services (Generic)

    The graph below separates benefits for external service users, staff, internal service users, service planning and performance indicators.
    It shows the average impact that CDI will have on these types being affected.


                                      0 to +5'

                     Customer       No impact                                 0

                         Staff      No impact                                 0

 Internal Service users             No impact                                 0

      Service planning              No impact

Performance indicators              No impact

                                                     0            +1          +2                  +3                    +4               +5




    Risks                                                                                                                                                      Top




             5                          C        E, B, A
                                                                                                  Risk (likelihood, impact)
                                                                                          E       Funding not available (3, 5)
             4                          D            I, H                                B        Staff buy-in (3, 5)
                                                                                          A       Data security (3, 5)
                                                                                          I       Uncertainties in existing data quality (3, 4)
        Likelihood




             3                          F                                                H        Lack of clear senior management buy-in to cross council data sharing (3, 4)
                                                                                         C        Technology specification fit (2, 5)
                                                                                         D        Customers do not want to provide data (2, 4)
             2                                                                            F       Change management not carried out properly (2, 3)
                                                                                         G        Ownership of data can be unclear (2, 1)


             1                          G


                           1            2                3    4         5
                                            Impact


    End                                                                                                                                                       Top
Benefits
This worksheet contains the behind-the-scences detail of the calculator. Listed below are the calculations for every benefit as well as each associated assumption.
If you wish to amend these assumptions, please enter your new figure in the 'specified data' column (column P).
Assumptions highlighted in yellow are ones that have been asked in the input sheet.

If you can think of further quantifiable benefits, you can add these at the bottom of the table. You will need to think about what calculation is needed as well as the associated variables.

                General assumptions                                      Figure                             Unit
                Number of months worked per year                                                       12   months
                Number of days worked per year                                                        220   days
                Number of weeks worked per year                                                        43   weeks
                Number of hours in day                                                                  7   hours
                Number of minutes in hour                                                              60   minutes
                Salary with oncosts (London borough estimate)                                       118%
                London weighting for average salary                                                 120%
                Ratio of first year benefits: full year of benefits                                  0.44

                                                                                                                                                     Default Data                                   Default Data (non-         Default Data                                                                                          Specified Data                                                                                                                                     Value in 1 full
Benefit #       Service                Type of saving     Phase          Description                        Variable                                 (District)               Default Data (County) London unitary)            (London Unitary)         Confidence level   Default Data source         Specified data   Confidence   source           Used           Saving status   %age in year 2   %age in year 3   %age in year 4   %age in year 5   Calculation                    year               Year 1 value        Year 2 value        Year 3 value        Year 4 value        Year 5 value
                                                                                                                                                                                                                                                                                                                                                                                                                                                         Total number of outbound
                                                                                                                                                                                                                                                                                                                                                                                                                                                         telephone calls to
                                                                                                                                                                                                                                                                                                                                                                                                                                                         customers per month x no
                                                                                                                                                                                                                                                                                                                                                                                                                                                         of months in year x
                                                                                                                                                                                                                                                                                                                                                                                                                                                         percentage of calls where
                                                                                                                                                                                                                                                                                                                                                                                                                                                         caller struggled to find
                                                                                                                                                                                                                                                                                                                                                                                                                                                         correct number x staff
                                                                                                                                                                                                                                                                                                                                                                                                                                                         time lost per call x
                                                                                                                                                                                                                                                                                                                                                                                                                                                         average salary of council
                                                                         Reduced staff time searching                                                                                                                                                                      Average of 3 London                                                                                                                                                           stafff per minute x
                                                                         for correct customer telephone     Total number of outbound telephone                                                                                                                             local authorities                                                                                                                                                             proportion CDI could
            1   Generic                Non Cashable       Level 2        number                             calls per month across council                   172,000 calls            301,000 calls           344,000 calls           430,000 calls     Low                (London figure)                                                                   FALSE   Steady                                                                              reduce this by                               £0                  £0                  £0                  £0                  £0                  £0
                                                                                                                                                                                                                                                                           RSe - Data Connects
                                                                                                            Percentage of calls to customer                            30%                       30%                   30%                        30% Low                  assumption                                                                        FALSE
                                                                                                            Percentage of calls where caller
                                                                                                            struggled to find correct telephone                                                                                                                            RSe - Data Connects
                                                                                                            number lost per case where
                                                                                                            Staff time                                                 20%                       20%                   20%                        20% Low                  assumption                                                                        FALSE
                                                                                                            number struggles to be found                                                                                                                                   RSe - Data Connects
                                                                                                            (minutes)                                                1 mins                 1 mins                  1 mins                   1 mins     Low                assumption                                                                        FALSE
                                                                                                                                                                                                                                                                           London local authority
                                                                                                                                                                                                                                                                           and 2002 London
                                                                                                            Average salary of council staff (with                                                                                                                          Assembly Report on
                                                                                                            oncosts)                                                £24,178                £24,178                 £24,178                 £29,014      Low                London Weighting                                                                  FALSE
                                                                                                                                                                                                                                                                           RSe - Data Connects
                                                                                                            Proportion CDI could reduce this by                        30%                      30%                    30%                        30%   Low                assumption                                                                        FALSE
                                                                                                                                                                                                                                                                                                                                                                                                                                                         No of customer changes x
                                                                                                                                                                                                                                                                                                                                                                                                                                                         (average no of systems
                                                                                                                                                                                                                                                                           ONS website:                                                                                                                                                                  where change is made - 1
                                                                                                                                                                                                                                                                           http://www.london.gov.u                                                                                                                                                       remaining system) x time
                                                                         Reduced time re-keying                                                                                                                                                                            k/gla/publications/factsa                                                                                                                                                     taken by staff to input
                                                                         information into more than one                                                                                                                                                                    ndfigures/dmag-                                                                                                                                                               change into 1 system x
            2   Generic                Non Cashable       Level 2        system                             Average population turnover per year                       14%                       16%                   18%                        23% Low                  briefing-2008-10.pdf                                                              FALSE   Reducing                 100%              80%              60%              40%    average staff salary                         £0                  £0                  £0                  £0                  £0                  £0
                                                                                                                                                                                                                                                                           RSe - Data Connects
                                                                                                            Average population                              80,000 people          120,000 people           160,000 people          200,000 people      Low                assumption                                                                        FALSE
                                                                                                            Average number of systems where
                                                                                                            change is made to a customer                                                                                                                                   RSe - Data Connects
                                                                                                            record as a result                                  4 systems                4 systems               4 systems                4 systems Low                    assumption                                                                        FALSE
                                                                                                                                                                                                                                                                           London local authority
                                                                                                                                                                                                                                                                           and 2002 London
                                                                                                                                                                                                                                                                           Assembly Report on
                                                                                                            Average staff salary                                    £24,178                £24,178                 £24,178                 £29,014      Low                London Weighting                                                                  FALSE
                                                                                                            Time taken in one system per                                                                                                                                   RSe - Data Connects
                                                                                                            change                                                   1 mins                 1 mins                  1 mins                   1 mins     Low                assumption                                                                        FALSE

                                                                                                                                                                                                                                                                                                                                                                                                                                                         No of calls logged per
                                                                                                                                                                                                                                                                                                                                                                                                                                                         month x no of months in
                                                                                                                                                                                                                                                                                                                                                                                                                                                         year x average duration of
                                                                                                                                                                                                                                                                                                                                                                                                                                                         customer search x
                                                                                                                                                                                                                                                                                                                                                                                                                                                         percentage quicker
                                                                                                                                                                                                                                                                                                                                                                                                                                                         search because of CDI x
                                                                         Finding customers more                                                                                                                                                                                                                                                                                                                                                          average salary of
                                                                         quickly because of fewer                                                                                                                                                                                                                                                                                                                                                        customer services staff /
            2   Customer Services      Non Cashable       Level 2        duplicates in system               No of logged calls per month                         800 calls              1,400 calls             1,600 calls              2,000 calls    Low                London local authority                                                            FALSE   Reducing                  95%              80%              60%              40%    minute                                       £0                  £0                  £0                  £0                  £0                  £0
                                                                                                            Average duration of customer                                                                                                                                   Data Connects - RSe
                                                                                                            search (minutes)                                         1 mins                 1 mins                  1 mins                   1 mins     Low                assumption                                                                        FALSE
                                                                                                            Percentage quicker search because                                                                                                                              Data Connects - RSe
                                                                                                            of CDI                                                     20%                      20%                    20%                        20%   Low                assumption                                                                        FALSE
                                                                                                                                                                                                                                                                           Data Connects - RSe
                                                                                                            Scaling factor for staff downtime                         110%                      110%                 110%                     110%      Low                assumption                                                                        FALSE
                                                                                                            Average salary of customer services
                                                                                                            staff                                                   £24,178                £24,178                 £24,178                 £29,014      Low                London local authority                                                            FALSE
                                                                                                                                                                                                                                                                                                                                                                                                                                                         No of logged calls per
                                                                                                                                                                                                                                                                                                                                                                                                                                                         month x no of months in
                                                                                                                                                                                                                                                                                                                                                                                                                                                         year x average duration of
                                                                                                                                                                                                                                                                                                                                                                                                                                                         call x percentage of
                                                                                                                                                                                                                                                                                                                                                                                                                                                         logged calls that are
                                                                                                                                                                                                                                                                                                                                                                                                                                                         duplicates x percentage
                                                                         Reduced time entering              Percentage of logged calls that are                                                                                                                            Data Connects - RSe                                                                                                                                                           this reduced by because
            3   Customer Services      Non Cashable       Level 2        duplicates onto system             duplicates                                                 10%                      10%                    10%                        10%   Low                assumption                                                                        FALSE   Reducing                  95%              90%              85%              80%    of CDI x average salary                      £0                  £0                  £0                  £0                  £0                  £0
                                                                                                            Percentage duplicated reduced by
                                                                                                            because of CDI                                             50%                      50%                    50%                        50%   Low                London local authority                                                            FALSE
                                                                                                                                                                                                                                                                           London LA distributes
                                                                                                                                                                                                                                                                           £290,000,000 in                                                                                                                                                               Amount of overpaid
                                                                                                                                                                                                                                                                           benefits per year. DwP                                                                                                                                                        benefits per year x
                                                                         Recovering more money                                                                                                                                                                             Report (2005) says 5%                                                                                                                                                         percentage that CDI could
                                                                         through detecting more cases                                                                                                                                                                      of benefits are overpaid                                                                                                                                                      recover through access to
            4                         Council Tax)
                Benefits (Housing andCashable             Level 1        of overpayment                     Amount of overpaid benefits per year               £8,700,000                          £0          £11,600,000             £14,500,000      Low                per year.                                                                         FALSE   Steady                                                                              correct customer details                     £0                  £0                  £0                  £0                  £0                  £0
                                                                                                            Percentage that CDI could recover
                                                                                                            through access to correct customer                                                                                                                             Data Connects - RSe
                                                                                                            details                                                     1%                        0%                    1%                        1%    Low                assumption                                                                        FALSE
                                                                                                                                                                                                                                                                                                                                                                                                                                                         No of deceased clients
                                                                                                                                                                                                                                                                                                                                                                                                                                                         per year x Proportion of
                                                                                                                                                                                                                                                                                                                                                                                                                                                         deceased clients who
                                                                                                                                                                                                                                                                                                                                                                                                                                                         continue to receive benefit
                                                                                                                                                                                                                                                                                                                                                                                                                                                         x Average value of benefit
                                                                         Preventing distribution of                                                                                                                                                                        London borough death                                                                                                                                                          x Proportion that CDI
            5                         Council Tax)
                Benefits (Housing andCashable             Level 1        benefit to deceased customers      No of deceased customers per year              600 customers                customers          1,200 customers         1,500 customers      Low                certificates issued                                                               FALSE   Reducing                 100%              60%              30%              20%    would pick up                                £0                  £0                  £0                  £0                  £0                  £0
                                                                                                            Proportion of deceased clients who                                                                                                                             Data Connects - RSe
                                                                                                            continuevalue of benefit before
                                                                                                            Average to receive benefit                                 10%                        0%                   10%                        10%   Low                assumption                                                                        FALSE
                                                                                                            Council realises customer is                                                                                                                                   Data Connects - RSe
                                                                                                            deceased                                                  £120                         £0                 £160                     £200     Low                assumption                                                                        FALSE
                                                                                                                                                                                                                                                                           Data Connects - RSe
                                                                                                            Proportion that CDI would pick up                          50%                        0%                   50%                        50%   Low                assumption                                                                        FALSE
                                                                                                                                                                                                                                                                                                                                                                                                                                                         No of inaccurate
                                                                                                            No of housing applications per week                                                                                                                                                                                                                                                                                                          applications x amount of
                                                                         Verifying client details at the    involving inaccuracies or errors that                                                                                                                          Data Connects - RSe                                                                                                                                                           staff time taken up by
            6                         Council Tax)
                Benefits (Housing andNon Cashable         Level 1        start of the application process   take up time later in the process               3 applications                                   3 applications           3 applications    Low                assumption                                                                        FALSE   Steady                                                                              application x staff salary                   £0                  £0                  £0                  £0                  £0                  £0
                                                                                                            Amount of staff time taken to deal                                                                                                                             Data Connects - RSe
                                                                                                            with inaccurate application (minutes)                   30 mins                     mins               30 mins                 30 mins      Low                assumption                                                                        FALSE
                                                                                                            Average staff salary                                    £24,178                       £0               £24,178                 £29,014      Low                London local authority                                                            FALSE
                                                                                                                                                                                                                                                                                                                                                                                                                                                         No of housing
                                                                                                                                                                                                                                                                                                                                                                                                                                                         applications x amount of
                                                                                                                                                                                                                                                                                                                                                                                                                                                         staff time taken up by
                                                                         Reducing time spent validating                                                                                                                                                                                                                                                                                                                                                  application x staff salary x
                                                                         addresses (specifically) for       No of applications per week that                                                                                                                               Data Connects - RSe                                                                                                                                                           proportion CDI could
            7                         Council Tax)
                Benefits (Housing andNon Cashable         Level 1        housing applications               require specific validation of address       180 applications                                  240 applications        300 applications     Low                assumption                                                                        FALSE   Steady                                                                              reduce this by                               £0                  £0                  £0                  £0                  £0                  £0
                                                                                                            Amount of staff time taken to deal                                                                                                                             Data Connects - RSe
                                                                                                            with inaccurate application (minutes)                    4 mins                     mins                4 mins                   4 mins     Low                assumption                                                                        FALSE
                                                                                                                                                                                                                                                                           Data Connects - RSe
                                                                                                            Percentage CDI could reduce this by                        50%                                            50%                     50%                          assumption                                                                        FALSE
                                                                                                            Average staff salary                                    £24,178                        £0              £24,178                 £29,014      Low                London local authority                                                            FALSE
                                                                                                                                                                                                                                                                                                                                                                                                                                                         No of people claiming
                                                                                                                                                                                                                                                                                                                                                                                                                                                         'right to buy' x Proportion
                                                                                                                                                                                                                                                                                                                                                                                                                                                         of those claiming RTB
                                                                                                                                                                                                                                                                                                                                                                                                                                                         that are claiming housing
                                                                                                                                                                                                                                                                                                                                                                                                                                                         benefit x Average amount
                                                                                                                                                                                                                                                                                                                                                                                                                                                         council provides to
                                                                         Reducing fraud where person                                                                                                                                                                                                                                                                                                                                                     household claiming RTB
                                                                         on housing benefit is claiming     No of people claiming 'right to buy'                                                                                                                           Data Connects - RSe                                                                                                                                                           x proportion that CDI
            7                         Council Tax)
                Benefits (Housing andCashable             Level 1        'right to buy' council property    discount                                        10 customers                customers            30 customers             40 customers      Low                assumption                                                                        FALSE   Steady                                                                              would pick up                                £0                  £0                  £0                  £0                  £0                  £0
                                                                                                            Proportion of those claiming RTB                                                                                                                               Data Connects - RSe
                                                                                                            that are claiming housing benefit                          10%                        0%                   10%                        10%   Low                assumption                                                                        FALSE
                                                                                                            Average amount council provides to                                                                                                                             London Borough
                                                                                                            household claiming RTB                                  £10,000                        £0              £30,000                 £40,000      Low                website                                                                           FALSE
                                                                                                                                                                                                                                                                           Data Connects - RSe
                                                                                                            Proportion that CDI would pick up                          20%                        0%                   20%                        20%   Low                assumption                                                                        FALSE

                                                                                                                                                                                                                                                                                                                                                                                                                                                         No of people claiming
                                                                                                                                                                                                                                                                                                                                                                                                                                                         'right to buy' x Proportion
                                                                                                                                                                                                                                                                                                                                                                                                                                                         of those claiming RTB
                                                                                                                                                                                                                                                                                                                                                                                                                                                         that are claiming housing
                                                                         Reducing fraud where person                                                                                                                                                                                                                                                                                                                                                     benefit x Average amount
                                                                         claiming 'right to buy' discount                                                                                                                                                                                                                                                                                                                                                council provides to
                                                                         sells property within discount     Proportion of those claiming 'Right                                                                                                                                                                                                                                                                                                          household claiming RTB
                                                                         period and does not lose           to buy' that sell within discount                                                                                                                              Data Connects - RSe                                                                                                                                                           x proportion that CDI
            8                         Council Tax)
                Benefits (Housing andCashable             Level 1        discount                           period without declaring                                   10%                        0%                   10%                        10%   Low                assumption                                                                        FALSE   Steady                                                                              would pick up                                £0                  £0                  £0                  £0                  £0                  £0
                                                                                                            Average amount council provides to                                                                                                                             Data Connects - RSe
                                                                                                            household claiming RTB                                  £10,000                        £0              £30,000                 £40,000      Low                assumption                                                                        FALSE
                                                                                                                                                                                                                                                                           Data Connects - RSe
                                                                                                            Proportion that CDI would pick up                          20%                        0%                   20%                        20%   Low                assumption                                                                        FALSE
                                                                                                                                                                                                                                                                                                                                                                                                                                                         Standard charge for
                                                                                                                                                                                                                                                                                                                                                                                                                                                         repairs visit x No of visits
                                                                                                                                                                                                                                                                                                                                                                                                                                                         made by repairs team x
                                                                                                                                                                                                                                                                           Data Connects - RSe                                                                                                                                                           Proportion of aborted
                                                                                                                                                                                                                                                                           assumption based on                                                                                                                                                           visits by repairs team x
                                                                         Reduced number of aborted                                                                                                                                                                         interview with London                                                                                                                                                         Proportion CDI could
            9   Housing                Non Cashable       Level 1        repairs visits                     Standard charge for repairs visit                          £60                         £0                   £60                    £100 Medium                 local authority                                                                   FALSE   Steady                                                                              reduce this by                               £0                  £0                  £0                  £0                  £0                  £0
                                                                                                                                                                                                                                                                           Data Connects - RSe
                                                                                                            No of visits made by repairs team                  1,200 visits                     visits          1,600 visits            2,000 visits    Low                assumption                                                                        FALSE
                                                                                                                                                                                                                                                                           Data Connects - RSe
                                                                                                            Proportion of aborted visits by                                                                                                                                assumption verified by
                                                                                                            repairs team                                               20%                        0%                   20%                        20% Low                  London Borough                                                                    FALSE
                                                                                                                                                                                                                                                                           Data Connects - RSe
                                                                                                                                                                                                                                                                           assumption verified by
                                                                                                            Proportion CDI could reduce this by                        30%                        0%                   30%                        30%   Low                London Borough                                                                    FALSE

                                                                                                                                                                                                                                                                                                                                                                                                                                                         Length of time to process
                                                                                                                                                                                                                                                                                                                                                                                                                                                         placement x Average
                                                                                                                                                                                                                                                                                                                                                                                                                                                         salary of person doing
                                                                                                                                                                                                                                                                                                                                                                                                                                                         this x Number of
                                                                                                                                                                                                                                                                                                                                                                                                                                                         placements per year x
                                                                                                                                                                                                                                                                                                                                                                                                                                                         percentage of placements
                                                                                                                                                                                                                                                                                                                                                                                                                                                         that fail x percentage of
                                                                         Reducing time spent re-                                                                                                                                                                           Data Connects - RSe                                                                                                                                                           placements that could
                                                                         placing people in suitable         Length of time to process placement                                                                                                                            assumption verified by                                                                                                                                                        succeed with access to
        10      Housing                Non Cashable       Level 1        housing                            (minutes)                                         30 minutes                   minutes              30 minutes              30 minutes      Low                London Borough                                                                    FALSE   Reducing                  95%              90%              85%              80%    the correct information                      £0                  £0                  £0                  £0                  £0                  £0
                                                                                                            Average salary of person doing this                   £23,600                       £0                  £23,600                 £29,014     Low                London local authority                                                            FALSE
                                                                                                            Number of placements per year               1,800 placements               placements         2,400 placements        3,000 placements                         London local authority                                                            FALSE
                                                                                                                                                                                                                                                                           Data Connects - RSe
                                                                                                                                                                                                                                                                           assumption verified by
                                                                                                            Percentage of placements that fail                         25%                        0%                   25%                        25%   Low                London Borough                                                                    FALSE
                                                                                                            Percentage of failed placements that
                                                                                                            could succeed with access to                                                                                                                                   Data Connects - RSe
                                                                                                            correct information                                        10%                        0%                   10%                        10%   Low                assumption                                                                        FALSE
                                                                                                                                                                                                                                                                                                                                                                                                                                                         Monthly value of housing
                                                                                                                                                                                                                                                                                                                                                                                                                                                         rent subsidy x No of
                                                                                                                                                                                                                                                                                                                                                                                                                                                         households in local
                                                                                                                                                                                                                                                                                                                                                                                                                                                         authority accomodation x
                                                                                                                                                                                                                                                                                                                                                                                                                                                         percentage of occupants
                                                                         Reducing fraud due to                                                                                                                                                                             Data Connects - RSe                                                                                                                                                           not entitled to this rent
                                                                         duplicates and inaccuracies in     Monthly value of housing rent                                                                                                                                  assumption verified by                                                                                                                                                        subsidy x percentage CDI
        11      Housing                Cashable           Level 1        system                             subsidy                                                   £100                         £0                 £100                     £200     Low                London Borough                                                                    FALSE   Steady                                                                              could reduce this by                         £0                  £0                  £0                  £0                  £0                  £0
                                                                                                            No of households in local authority
                                                                                                            accomodation                              11,400 households                households        15,200 households      19,000 households       Low                London local authority                                                            FALSE
                                                                                                            Percentage of occupants not entitled
                                                                                                            to this rent subsidy due to duplicates                                                                                                                         Data Connects - RSe
                                                                                                            and inaccuracies in system                                  1%                        0%                    1%                        1%    Low                assumption                                                                        FALSE
                                                                                                                                                                                                                                                                           Data Connects - RSe
                                                                                                            Percentage CDI could reduce this by                        20%                        0%                   20%                        20%   Low                assumption                                                                        FALSE
                                                                                                                                                                                                                                                                                                                                                                                                                                                          No of deceased
                                                                                                                                                                                                                                                                                                                                                                                                                                                          customers with council
                                                                                                                                                                                                                                                                                                                                                                                                                                                          house per year x
                                                                                                                                                                                                                                                                                                                                                                                                                                                          Proportion of deceased
                                                                                                                                                                                                                                                                                                                                                                                                                                                          people with council house
                                                                                                                                                                                                                                                                                                                                                                                                                                                          whose house not
                                                                                                                                                                                                                                                                                                                                                                                                                                                          returned to council x
                                                                                                                                                                                                                                                                                                                                                                                                                                                          Average length of time for
                                                            Reducing fraud where a                                                                                                                                                                                                                                                                                                                                                                        which house not returned
                                                            deceased person's council                                                                                                                                                                                                                                                                                                                                                                     x Average value of council
                                                            house is not returned to           No of deceased customers living in                                                                                                                          London local authority                                                                                                                                                                         property to council x
        12   Housing             Cashable         Level 1   council housing stock              council accomodation per year                  24 customers               customers            48 customers             60 customers     Low                figure                                                                                  FALSE           Steady                                                                                 Proportion that CDI would                   £0                  £0                  £0                  £0                  £0                  £0
                                                                                               Proportion of deceased customers
                                                                                               with council house whose house not                                                                                                                          Data Connects   - RSe
                                                                                               returned to council                                      5%                      0%                      5%                        5%    Low                assumption                                                                              FALSE
                                                                                               Average length of time for which                                                                                                                            Data Connects   - RSe
                                                                                               house not returned                                 3 months                  months                3 months                 3 months                        assumption                                                                              FALSE
                                                                                               Average value of council property to                                                                                                                        Data Connects   - RSe
                                                                                               council per year                                      £2,600                      £0                  £3,640                   £4,160    Low                assumption                                                                              FALSE
                                                                                                                                                                                                                                                           Data Connects   - RSe
                                                                                               Proportion that CDI would pick up                       50%                      0%                     50%                        50%   Low                assumption                                                                              FALSE
                                                                                                                                                                                                                                                                                                                                                                                                                                                          Amount of SPD being
                                                                                                                                                                                                                                                                                                                                                                                                                                                          claimed x Proportion that
                                                                                                                                                                                                                                                                                                                                                                                                                                                          is incorrectly applied x
                                                                                                                                                                                                                                                                                                                                                                                                                                                          Percentage that could be
                                                            Reducing Single Person             Amount of Single Person Discount                                                                                                                                                                                                                                                                                                                           detected through CDI
        15   Revenues (CTax)     Cashable         Level 1   Discount                           distributed                                       £4,280,000                      £0              £8,560,000             £10,700,000     Low                London local authority                                                                  FALSE           Reducing                    100%              60%              30%              20%    solution                                    £0                  £0                  £0                  £0                  £0                  £0
                                                                                               Proportion of SPD being incorrectly                                                                                                                         Data Connects - RSe
                                                                                               applied                                                 10%                      0%                     10%                        10%   Low                assumption                                                                              FALSE
                                                                                               Percentage of SPD cases that could                                                                                                                          Data Connects - RSe
                                                                                               be detected through CDI solution                        25%                      0%                     25%                        25%   Low                assumption                                                                              FALSE
                                                                                                                                                                                                                                                                                                                                                                                                                                                          No of properties declared
                                                                                                                                                                                                                                                                                                                                                                                                                                                          empty x percentage of
                                                                                                                                                                                                                                                                                                                                                                                                                                                          these properties
                                                            Reducing lost revenue through                                                                                                                                                                                                                                                                                                                                                                 containing residents x
                                                            not claiming money from                                                                                                                                                                                                                                                                                                                                                                       average monthly council
                                                            properties declared empty, but                                                                                                                                                                                                                                                                                                                                                                tax x proportion that CDI
        13   Revenues (CTax)     Cashable         Level 1   with residents                     No of properties declared empty              1,240 properties             properties         2,480 properties         3,100 properties   Low                London borough                                                                          FALSE           Steady                                                                                 solution would pick up                      £0                  £0                  £0                  £0                  £0                  £0
                                                                                               Percentage of properties that are                                                                                                                           Data Connects - RSe
                                                                                               declared empty but contain residents                     5%                      0%                      5%                        5%    Low                assumption                                                                              FALSE
                                                                                                                                                                                                                                                           Guardian article (March
                                                                                                                                                                                                                                                           2007) estimating
                                                                                               Average council tax per year                            £660                      £0                    £880                   £1,100    Low                2007/8 average                                                                          FALSE
                                                                                               Proportion of cases that CDI                                                                                                                                Data Connects - RSe
                                                                                               solution would pick up                                  30%                      0%                     30%                        30%   Low                assumption                                                                              FALSE

                                                                                                                                                                                                                                                                                                                                                                                                                                                          No of changes in
                                                                                                                                                                                                                                                                                                                                                                                                                                                          occupancy per year x
                                                                                                                                                                                                                                                                                                                                                                                                                                                          Percentage where true
                                                                                                                                                                                                                                                                                                                                                                                                                                                          moving in date not
                                                                                                                                                                                                                                                                                                                                                                                                                                                          declared x Average cost to
                                                                                                                                                                                                                                                                                                                                                                                                                                                          council per person not
                                                            Increasing collection of council                                                                                                                                                                                                                                                                                                                                                              paying council tax per year
                                                            tax from people who have                                                                                                                                                                                                                                                                                                                                                                      x proportion that CDI
        14   Revenues (CTax)     Cashable         Level 1   moved into borough                 No of changes in occupancy per year           5,000 changes                 changes           4,000 changes           20,000 changes     Low                London borough                                                                          FALSE           Reducing                     90%              80%              70%              70%    would pick up                               £0                  £0                  £0                  £0                  £0                  £0
                                                                                               Percentage where true moving in                                                                                                                             Data Connects - RSe
                                                                                               date not declared                                       10%                      0%                     10%                        10%   Low                assumption                                                                              FALSE
                                                                                                                                                                                                                                                           Data Connects - RSe
                                                                                               Proportion that CDI would pick up                       10%                      0%                     10%                        10%   Low                assumption                                                                              FALSE
                                                                                               Average cost to council per person
                                                                                               not paying council tax for a period                                                                                                                         Data Connects - RSe
                                                                                               after moving in                                         £165                      £0                    £220                     £275    Low                assumption                                                                              FALSE

                                                                                                                                                                                                                                                                                                                                                                                                                                                          Average value of Council
                                                                                                                                                                                                                                                                                                                                                                                                                                                          Tax x Number of
                                                                                                                                                                                                                                                                                                                                                                                                                                                          customers who have not
                                                                                                                                                                                                                                                                                                                                                                                                                                                          paid CT within 9 months
                                                                                                                                                                                                                                                                                                                                                                                                                                                          of being issued notice x
                                                                                                                                                                                                                                                                                                                                                                                                                                                          (Proportion that would
                                                                                                                                                                                                                                                                                                                                                                                                                                                          probably pay if picked up
                                                            Increased likelihood of                                                                                                                                                                                                                                                                                                                                                                       within 3 months -
                                                            payment because people who         Number of customers who have not                                                                                                                                                                                                                                                                                                                           Proportion that would
                                                            have not paid CT are picked up     paid council tax within 9 months of                                                                                                                         Data Connects - RSe                                                                                                                                                                            probably if pay picked up
        15   Revenues (CTax)     Cashable         Level 1   earlier                            being issued notice                            90 customers               customers           120 customers            150 customers     Low                assumption                                                                              FALSE           Reducing                    100%              60%              30%              20%    within 9 months)                            £0                  £0                  £0                  £0                  £0                  £0
                                                                                               Proportion that would probably pay                                                                                                                          Data Connects - RSe
                                                                                               picked up within 3 months                               20%                      0%                     20%                        20%   Low                assumption                                                                              FALSE
                                                                                               Proportion that would probably pay                                                                                                                          Data Connects - RSe
                                                                                               picked up within 9 months                                5%                      0%                      5%                        5%    Low                assumption                                                                              FALSE
                                                                                                                                                                                                                                                                                                                                                                                                                                                          No of duplicate records
                                                                                                                                                                                                                                                                                                                                                                                                                                                          cleaned per week x no of
                                                                                                                                                                                                                                                                                                                                                                                                                                                          minutes spent cleaning
                                                                                                                                                                                                                                                                                                                                                                                                                                                          record x staff salary x
                                                            Reducing time spent cleaning       No of duplicate records cleaned per                                                                                                                         London local authority                                                                                                                                                                         percentage CDI could
        16   Adult Social Services Non Cashable   Level 2   up duplicate data                  week                                             150 records             150 records             150 records              150 records    Low                assumption                                                                              FALSE           Reducing                    100%              60%              30%              20%    reduce this by                              £0                  £0                  £0                  £0                  £0                  £0
                                                                                               Average amount of time spent
                                                                                               identifying, cleaning and merging                                                                                                                           London local authority
                                                                                               duplicate record                                  11 minutes             11 minutes               11 minutes               11 minutes    Low                assumption                                                                              FALSE
                                                                                                                                                                                                                                                           Data Connects - RSe
                                                                                               Average staff salary                                                        £24,178                  £24,178                  £29,014    Low                assumption                                                                              FALSE
                                                                                                                                                                                                                                                                                                                                                                                                                                                          Total no of PCNs x
                                                                                                                                                                                                                                                                                                                                                                                                                                                          Percentage unrecovered x
                                                            Amount of extra income                                                                                                                                                                                                                                                                                                                                                                        percentage of these
                                                            received through successful                                                                                                                                                                                                                                                                                                                                                                   recovered with CDI x
        17   Parking             Cashable         Level 1   chasing of PCNs                    No of PCNs issued                              12,500 PCNs                    PCNs             45,000 PCNs             220,000 PCNs      Low                London local authority                                                                  FALSE           Steady                                                                                 average value of PCN                        £0                  £0                  £0                  £0                  £0                  £0
                                                                                               Percentage not recovered                               17%                                             17%                      17%      Medium             London local authority                                                                  FALSE
                                                                                               Percentage of these recovered due                                                                                                                           Data Connects - RSe
                                                                                               to CDI                                                  20%                     20%                     20%                        20%   Low                assumption                                                                              FALSE
                                                                                                                                                                                                                                                           Data Connects - RSe
                                                                                               Average value of PCN                                    £100                   £100                     £100                     £100    Medium             assumption                                                                              FALSE


Additional Benefits (optional)

If you would like to add further benefits to the calculator, please use the table below. Hover the cursor over the red flags to view instructions.
                                                                                                                                      Default Data                                   Default Data (non-        Default Data                                                                                                Specified Data                                                                                                                                               Value in 1 full
Benefit #    Service             Type of saving   Phase     Description                        Variable                               (District)               Default Data (County) London unitary)           (London Unitary)         Confidence level   Default Data source       Specified data           Confidence   source           Used                   Type of variable   %age in year 2   %age in year 3   %age in year 4   %age in year 5   Calculation                   year               Year 1 value        Year 2 value        Year 3 value        Year 4 value        Year 5 value
                                                            reducing amount of time spent
       20    Planning            Cashab le        Level 2   on contractors                     no of contractors type 1               N/A                      N/A                    N/A                      N/A                                         N/A                                        20000                                                20000   Steady                                                                                                                      £20,200             £8,935             £20,200             £20,200             £20,200             £20,200
                                                                                               no of contrator type 2                 N/A                      N/A                    N/A                      N/A                                         N/A                                           10                                                   10
                                                                                               amount per contractor type 1           N/A                      N/A                    N/A                      N/A                                         N/A                                           £1                                                    1
                                                                                               amount per contractor type 2           N/A                      N/A                    N/A                      N/A                                         N/A                                          £20                                                   20
                                                                                                                                      N/A                      N/A                    N/A                      N/A                                         N/A                                                                                                 0
                                                                                                                                      N/A                      N/A                    N/A                      N/A                                         N/A                                                                                                 0
                                                                                                                                      N/A                      N/A                    N/A                      N/A                                         N/A                                                                                                 0
                                                                                                                                      N/A                      N/A                    N/A                      N/A                                         N/A                                                                                                 0
                                                                                                                                      N/A                      N/A                    N/A                      N/A                                         N/A                                                                                                 0
                                                                                                                                      N/A                      N/A                    N/A                      N/A                                         N/A                                                                                                 0
                                                                                                                                      N/A                      N/A                    N/A                      N/A                                         N/A                                                                                                 0
                                                                                                                                      N/A                      N/A                    N/A                      N/A                                         N/A                                                                                                 0
                                                                                                                                      N/A                      N/A                    N/A                      N/A                                         N/A                                                                                                 0
                                                                                                                                      N/A                      N/A                    N/A                      N/A                                         N/A                                                                                                 0
                                                                                                                                      N/A                      N/A                    N/A                      N/A                                         N/A                                                                                                 0



End                                                                                                                           Top
Service area                         Service area ruled in?       Year 1          Year 1          Year 1          Year 1              Year 1              Year 1              TOTAL BENEFITS
                                                                  Cashable        Cashable        Cashable        Non Cashable        Non cashable        Non Cashable
                                                                  Level 1         Level 2         Total           Level 1             Level 2             Total
Generic                              Yes                                     £0              £0              £0                  £0                  £0                  £0                    £0
Customer Services                                             0              £0              £0              £0                  £0                  £0                  £0                    £0
Benefits (Housing and Council Tax)                            0              £0              £0              £0                  £0                  £0                  £0                    £0
Housing                                                       0              £0              £0              £0                  £0                  £0                  £0                    £0
Revenues (CTax)                                               0              £0              £0              £0                  £0                  £0                  £0                    £0
Childrens Social Services                                     0              £0              £0              £0                  £0                  £0                  £0                    £0
Adult Social Services                                         0              £0              £0              £0                  £0                  £0                  £0                    £0
Schools & Education                                           0              £0              £0              £0                  £0                  £0                  £0                    £0
Libraries                                                     0              £0              £0              £0                  £0                  £0                  £0                    £0
Electoral Roll                                                0              £0              £0              £0                  £0                  £0                  £0                    £0
Registrars                                                    0              £0              £0              £0                  £0                  £0                  £0                    £0
Parking                                                       0              £0              £0              £0                  £0                  £0                  £0                    £0
                   0                                          0              £0              £0              £0                  £0                  £0                  £0                    £0
TOTAL                                                                        £0              £0              £0                  £0                  £0                  £0


Service area                         Service area ruled in?       Year 2          Year 2          Year 2          Year 2              Year 2              Year 2              TOTAL BENEFITS
                                                                  Cashable        Cashable        Cashable        Non Cashable        Non cashable        Non Cashable
                                                                  Level 1         Level 2         Total           Level 1             Level 2             Total
Generic                              Yes                                     £0              £0              £0                  £0                  £0                  £0                    £0
Customer Services                                             0              £0              £0              £0                  £0                  £0                  £0                    £0
Benefits (Housing and Council Tax)                            0              £0              £0              £0                  £0                  £0                  £0                    £0
Housing                                                       0              £0              £0              £0                  £0                  £0                  £0                    £0
Revenues (CTax)                                               0              £0              £0              £0                  £0                  £0                  £0                    £0
Childrens Social Services                                     0              £0              £0              £0                  £0                  £0                  £0                    £0
Adult Social Services                                         0              £0              £0              £0                  £0                  £0                  £0                    £0
Schools & Education                                           0              £0              £0              £0                  £0                  £0                  £0                    £0
Libraries                                                     0              £0              £0              £0                  £0                  £0                  £0                    £0
Electoral Roll                                                0              £0              £0              £0                  £0                  £0                  £0                    £0
Registrars                                                    0              £0              £0              £0                  £0                  £0                  £0                    £0
Parking                                                       0              £0              £0              £0                  £0                  £0                  £0                    £0
                   0                                          0              £0              £0              £0                  £0                  £0                  £0                    £0
TOTAL                                                                        £0              £0              £0                  £0                  £0                  £0


Service area                         Service area ruled in?       Year 3          Year 3          Year 3          Year 3              Year 3              Year 3              TOTAL BENEFITS
                                                                  Cashable        Cashable        Cashable        Non Cashable        Non cashable        Non Cashable
                                                                  Level 1         Level 2         Total           Level 1             Level 2             Total
Generic                              Yes                                     £0              £0              £0                  £0                  £0                  £0                    £0
Customer Services                                             0              £0              £0              £0                  £0                  £0                  £0                    £0
Benefits (Housing and Council Tax)                            0              £0              £0              £0                  £0                  £0                  £0                    £0
Housing                                                       0              £0              £0              £0                  £0                  £0                  £0                    £0
Revenues (CTax)                                               0              £0              £0              £0                  £0                  £0                  £0                    £0
Childrens Social Services                                     0              £0              £0              £0                  £0                  £0                  £0                    £0
Adult Social Services                                         0              £0              £0              £0                  £0                  £0                  £0                    £0
Schools & Education                                           0              £0              £0              £0                  £0                  £0                  £0                    £0
Libraries                                                     0              £0              £0              £0                  £0                  £0                  £0                    £0
Electoral Roll                                                0              £0              £0              £0                  £0                  £0                  £0                    £0
Registrars                                                    0              £0              £0              £0                  £0                  £0                  £0                    £0
Parking                                                       0              £0              £0              £0                  £0                  £0                  £0                    £0
                   0                                          0              £0              £0              £0                  £0                  £0                  £0                    £0
TOTAL                                                                        £0              £0              £0                  £0                  £0                  £0


Service area                         Service area ruled in?       Year 4          Year 4          Year 4          Year 4              Year 4              Year 4              TOTAL BENEFITS
                                                                  Cashable        Cashable        Cashable        Non Cashable        Non cashable        Non Cashable
                                                                  Level 1         Level 2         Total           Level 1             Level 2             Total
Generic                              Yes                                     £0              £0              £0                  £0                  £0                  £0                    £0
Customer Services                                             0              £0              £0              £0                  £0                  £0                  £0                    £0
Benefits (Housing and Council Tax)                            0              £0              £0              £0                  £0                  £0                  £0                    £0
Housing                                                       0              £0              £0              £0                  £0                  £0                  £0                    £0
Revenues (CTax)                                               0              £0              £0              £0                  £0                  £0                  £0                    £0
Childrens Social Services                                     0              £0              £0              £0                  £0                  £0                  £0                    £0
Adult Social Services                                         0              £0              £0              £0                  £0                  £0                  £0                    £0
Schools & Education                                           0              £0              £0              £0                  £0                  £0                  £0                    £0
Libraries                                                     0              £0              £0              £0                  £0                  £0                  £0                    £0
Electoral Roll                                                0              £0              £0              £0                  £0                  £0                  £0                    £0
Registrars                                                    0              £0              £0              £0                  £0                  £0                  £0                    £0
Parking                                                       0              £0              £0              £0                  £0                  £0                  £0                    £0
                   0                                          0              £0              £0              £0                  £0                  £0                  £0                    £0
TOTAL                                                                        £0              £0              £0                  £0                  £0                  £0


Service area                         Service area ruled in?       Year 5          Year 5          Year 5          Year 5              Year 5              Year 5              TOTAL BENEFITS
                                                                  Cashable        Cashable        Cashable        Non Cashable        Non cashable        Non Cashable
                                                                  Level 1         Level 2         Total           Level 1             Level 2             Total
Generic                              Yes                                     £0              £0              £0                  £0                  £0                  £0                    £0
Customer Services                                             0              £0              £0              £0                  £0                  £0                  £0                    £0
Benefits (Housing and Council Tax)                            0              £0              £0              £0                  £0                  £0                  £0                    £0
Housing                                                       0              £0              £0              £0                  £0                  £0                  £0                    £0
Revenues (CTax)                                               0              £0              £0              £0                  £0                  £0                  £0                    £0
Childrens Social Services                                     0              £0              £0              £0                  £0                  £0                  £0                    £0
Adult Social Services                                         0              £0              £0              £0                  £0                  £0                  £0                    £0
Schools & Education                                           0              £0              £0              £0                  £0                  £0                  £0                    £0
Libraries                                                     0              £0              £0              £0                  £0                  £0                  £0                    £0
Electoral Roll                                                0              £0              £0              £0                  £0                  £0                  £0                    £0
Registrars                                                    0              £0              £0              £0                  £0                  £0                  £0                    £0
Parking                                                       0              £0              £0              £0                  £0                  £0                  £0                    £0
                   0                                          0              £0              £0              £0                  £0                  £0                  £0                    £0
TOTAL                                                                        £0              £0              £0                  £0                  £0                  £0


                                     Service area ruled in?       TOTAL           TOTAL           TOTAL           TOTAL               TOTAL               TOTAL
                                                                  Cashable        Cashable        Cashable        Non Cashable        Non cashable        Non Cashable
                                                                  Level 1         Level 2         Total           Level 1             Level 2             Total
Generic                              Yes                                     £0              £0              £0                  £0                  £0                  £0
Customer Services                                             0              £0              £0              £0                  £0                  £0                  £0
Benefits (Housing and Council Tax)                            0              £0              £0              £0                  £0                  £0                  £0
Housing                                                       0              £0              £0              £0                  £0                  £0                  £0
Revenues (CTax)                                               0              £0              £0              £0                  £0                  £0                  £0
Childrens Social Services                                     0              £0              £0              £0                  £0                  £0                  £0
Adult Social Services                                         0              £0              £0              £0                  £0                  £0                  £0
Schools & Education                                           0              £0              £0              £0                  £0                  £0                  £0
Libraries                                                     0              £0              £0              £0                  £0                  £0                  £0
Electoral Roll                                                0              £0              £0              £0                  £0                  £0                  £0
Registrars                                                    0              £0              £0              £0                  £0                  £0                  £0
Parking                                                       0              £0              £0              £0                  £0                  £0                  £0
                   0                                          0              £0              £0              £0                  £0                  £0                  £0
Costs
This sheet calculates the costs associated with your CDI project. It is based on a series of assumptions made in consultation with Data Connects and
a number of London authorities. Adjustments have been made for different types of authorities.

We have split costs into the four main stages of a Customer Data Integration project. These are:

1. Scope project and define requirements (one-off / setup)
2. Procure software and services (one-off / setup)
2. Install and configure software & conduct initial matching (one-off / setup)
3. Ongoing maintenance (ongoing)

                                                                                                                Ongoing
                                               Set up period
                                                                                                                 period
     Stage




                          Stage 1                       Stage 2                        Stage 3                       Stage 4
                                                                                                                                               Note on integrating systems to CDI
                                                                                                                                               For the purposes of this ROI calculator it is assumed that
                                                                                                                                               the cost of integrating the business system datasets with
     Activity




                      Scope Project and                                           Install & Configure                                          the CDI solution is all incurred during the setup period.
                                                Procure Software &                                                Ongoing                      In practice, project teams should expect the cost to be
                           Define                                                Software & Conduct
                                                     Services                                                    Maintenance                   spread out over a longer period as services usually elect
                        Requirements                                                Initial Matching
                                                                                                                                               to join the 'hub' over time rather than all in one go.
                                                                                                                                               Project teams should also expect services outside the
                      Project manager             Project manager                 Project manager             Project manager                  initial scope to be interested in joining the project which
     Staff involved




                                                                                                                                               though it will mean incurring additional cost should also
                                                                                                                                               achieve additional benefits.
                       System owner              Programme board                    IT technician               Data stewards

                      Service area reps                                          Service staff users             IT technician

                      Programme board                                               Project board




The table below shows which staff would be involved in a typical project and what the cost of their time would be.

General assumptions
     Staff i
                    Service area reps             Service staff users                IT technician

                Programme board                         Project board




Who                  Number involved            Unit
Length of stage 1                          5    weeks
Length of stage 2                         12    weeks
Length of stage 3                         12    weeks
Length of set up                          29    weeks
period
Number of days                           220 days
worked per year
Number of service                          0 service areas
areas involved
Number of                                  2 representatives
representatives per
service area
Number of                                  1 member
programme board
members per
service area
Number of service                          -2 service areas
areas taken forward
to CDI application
stage
Salary with oncosts                     118%
Ratio of cost                            0.44
incurred in first 12
months: costs
incurred in ongoing
12 month period


Who                   Number involved           Average salary                 Unit                  Confidence   What they will do
Project manager /                          1                              £590 per day               Medium       Manage project and
Business analyst                                                                                                  undertake analysis
System owner /                             5                            £47,200 per annum            Medium       Provide input
experts
Service                                    0                            £47,200 per annum            Medium       Champion requirements of
representatives                                                                                                   their service area
Procurement board                          0                            £64,900 per annum            Medium       Select requirements for
/ Programme board                                                                                                 solution and choose
IT Technician                              1                            £29,500 per annum            Medium       Install software client in
                                                                                                                  services
Service staff                             50                            £29,500 per annum            Medium       Trained on CDI solution
Data stewards                              2                            £41,300 per annum            Medium       Ongoing data quality role
                                                                                                                  doing manual matching, data
                                                                                                                  cleansing etc.
Stage    Type of saving   Category   Description                    Variable                            Default data        Unit                   Confidence
                                     Project manager conducting     Number of days per service area                                                Medium
                                     interviews and writing up
                                     findings                                                                            2 days

        1 Cashable        Level 1
                                                                    Number of service areas involved                                               Medium
                                                                                                                         0 service areas

                                                                    Number of days to write up                                                     Medium
                                                                    findings                                             5 days

                                     System owner providing         Total number of days                                                           Medium
                                     technical details of system                                                         2 days
        1 Non Cashable    Level 1
                                     Service area representatives   Number of days per service area                                                Medium
                                     providing input to scope       representative
                                     interviews
                                                                                                                       0.25 days


        1 Non cashable    Level 1
                                                                    Number of service area                                                         Medium
                                                                    representatives                                      0 members

                                                                    Number of procurement board                                                    Medium
                                                                    members                                              0 members

                                     Programme board agreeing       Number of days per programme                                                   Medium
                                     scope                          board member                                        0.5 days
        1 Non cashable    Level 1
                                     Project manager drawing up     Total number of days (over all                                                 Medium
                                     specification                                                                       2 days
        1 Cashable        Level 1                                   of stage 1)
                                     Project manager writing        Total number of days writing                                                   Medium
                                     cabinet report                 cabinet report (over all of stage                    3 days
        1 Cashable        Level 1
                                     Project manager managing       1)
                                                                    Number of days per week spent                                                  Medium
                                     procurement and shortlisting doing this                                            1.5 days per week
        2 Cashable        Level 1
                                     software and services options Number of weeks spent doing                                                     Medium
                                                                   this                                                 12 weeks

                                     Programme board choosing       Number of days spent doing this                                                Medium
                                     software and services option   per board member over 3                              5 days
        2 Non cashable    Level 1
                                     IT technician installing CDI   months                                                                         Medium
                                                                    Number of days spent per
                                     client in service areas                                                             2 days per service area
        3 Non cashable    Level 1                                   service area
                                     Providing project              Number of days providing                                                       Medium
                                     management                     project management per week                          2 days
        3 Cashable        Level 1
                                                                    Number of service areas taken                                                  Low
                                                                    forward in project                                   -2 service areas

                                                                    Number of weeks providing                                                      Medium
                                                                    project management                                  24 weeks

                                     Project manager developing     Number of days to develop                                                      Medium
                                     and delivering training                                                             5 days
        3 Cashable        Level 1                                   training
                                                                 Number of days to deliver                                   Medium
                                                                 training                               10 days

                                 Service staff attending         Number of days training per                                 Medium
                                 training                                                                1 days
      3 Non cashable   Level 1                                   service staff member
                                                                 Number of staff attending                                   Low
                                                                                                        50 staff members
                                                                 training
                                 Project board monitoring and Number of days per month                                       Medium
                                 supervising project                                                    0.5 days per month
      3 Non cashable   Level 1
                                                                 Number of months providing                                  Medium
                                                                 monitoring and supervising              6 months

                                 Software, system installation   support
                                                                 Estimated cost                                              Medium
                                 & initial matching                                                £400,000
      3 Cashable       Level 1
                                 Adaptor                         Estimated cost of adaptor                                   Medium
                                                                                                    £60,000
      3 Cashable       Level 2
                                                                 Number of adaptors necessary                                Medium
                                                                 (estimated)                             2 adaptors

                                 Screenscraper                   Estimated cost of screenscraper                             Medium
                                                                                                    £50,000
      3 Cashable       Level 2
                                 Middleware                      Estimated cost of Middleware                                Medium
                                                                                                   £100,000
      3 Cashable       Level 2
                                 Measuring benefits              Number of days per week spent                               Medium
                                                                 doing this                             1.5 days
      4 Cashable       Level 1
                                                                 Number of weeks doing this for                              Medium
                                                                                                        52 weeks

                                 Data stewards manually          Number of FTEs needed to do                                 Medium
                                 matching data                                                           2 FTE
      4 Cashable       Level 1                                   this
                                 Maintenance support for         Percentage of initial cost of                               Medium
                                 software system                 software                             10% per year
      4 Cashable       Level 1
                                 Ongoing IT support              Cost of IT technician                                       Medium
      4 Cashable       Level 2                                                                           1 FTE
                                 Maintenance support for         Percentage of initial cost of                               Medium
                                 Screenscraper                   Screenscraper                        25% per year
      4 Cashable       Level 2




End
Type of cost   Year 1                Year 1                Year 1                Year 1                  Year 1            Year 1
               Cashable              Cashable              Cashable              Non Cashable            Non cashable      Non Cashable
               Level 1               Level 2               Total                 Level 1                 Level 2           Total
One off                   £474,045              £270,000              £744,045                  £6,597                  £0         £6,597
Steady                     £36,535               £30,740               £67,275                      £0                  £0             £0
TOTAL                     £510,580              £300,740              £811,320                  £6,597                  £0         £6,597




Type of cost   Year 2                Year 2                Year 2                Year 2                  Year 2            Year 2
               Cashable              Cashable              Cashable              Non Cashable            Non cashable      Non Cashable
               Level 1               Level 2               Total                 Level 1                 Level 2           Total
One off                    £25,665                    £0               £25,665                     £0                   £0             £0
Steady                    £122,600               £42,000              £164,600                     £0                   £0             £0
TOTAL                     £148,265               £42,000              £190,265                     £0                   £0             £0




Type of cost   Year 3                Year 3                Year 3                Year 3                  Year 3            Year 3
               Cashable              Cashable              Cashable              Non Cashable            Non cashable      Non Cashable
               Level 1               Level 2               Total                 Level 1                 Level 2           Total
One off                         £0                    £0                    £0                     £0                   £0             £0
Steady                    £122,600               £42,000              £164,600                     £0                   £0             £0
TOTAL                     £122,600               £42,000              £164,600                     £0                   £0             £0




Type of cost   Year 4                Year 4                Year 4                Year 4                  Year 4            Year 4
               Cashable              Cashable              Cashable              Non Cashable            Non cashable      Non Cashable
               Level 1               Level 2               Total                 Level 1                 Level 2           Total
One off                         £0                    £0                    £0                     £0                   £0             £0
Steady                    £122,600               £42,000              £164,600                     £0                   £0             £0
TOTAL                     £122,600               £42,000              £164,600                     £0                   £0             £0




Type of cost   Year 5                Year 5                Year 5                Year 5                  Year 5            Year 5
               Cashable              Cashable              Cashable              Non Cashable            Non cashable      Non Cashable
               Level 1               Level 2               Total                 Level 1                 Level 2           Total
One off                         £0                    £0                    £0                     £0                   £0             £0
Steady                    £122,600               £42,000              £164,600                     £0                   £0             £0
TOTAL                     £122,600               £42,000              £164,600                     £0                   £0             £0
Source                                                          Type of cost   Formula                        Year 1 value     Year 2 value   Year 3 value   Year 4 value   Year 5 value
                                                                                                                        £2,950
                                                                               Number of days x number
                                                                               of services + number of
                                                                               days to write up x project
RSe best practice assumption                                    One off        manager salary per day


RSe best practice assumption


RSe best practice assumption                                    One off
                                                                                                                         £429
                                                                               Number of days x salary
RSe best practice assumption                                    One off        per day
                                                                               Number of days x number                     £0
                                                                               of days per service area
                                                                               representative x number of
                                                                               service area representatives
                                                                               x salary of system owner
RSe best practice assumption                                    One off        per day
RSe best practice assumption
Assumed that there will be 2 representatives per service area
RSe best practice assumption
Assumed that there will be 1 board member per service area      One off        Number of days x number
                                                                               of days per procurement                     £0
RSe best practice assumption                                    One off        board representative x
                                                                               Number of days x salary of              £1,180
RSe best practice assumption                                    One off        project manager per day
                                                                               Number of days x salary of              £1,770
RSe best practice assumption                                    One off        Number of days per day
                                                                               project manager per week x
                                                                               number of weeks x salary               £10,620
RSe best practice assumption                                    One off        of project manager per day


RSe best practice assumption                                    One off        Number of board member
                                                                               days x salary of board                      £0
RSe best practice assumption                                    One off        member per day
                                                                               Number of days x salary of               -£536
RSe best practice assumption                                    One off        IT technician
                                                                               Number of days per week x
                                                                               number of weeks project                £28,320
RSe best practice assumption                                    One off        management needed x
RSe best practice assumption
Assumed that 2 original service areas are ruled out


RSe best practice assumption                                    One off        Number of days to develop
                                                                               training + number of days               £8,850
RSe best practice assumption                                    One off        to deliver training x salary
RSe best practice assumption   One off             Number of days training
                                                   per staff member x number         £6,705
RSe best practice assumption   One off             of staff attending training x


RSe best practice assumption   One off             Number of programme
                                                   board members x number               £0
RSe best practice assumption   One off             of days per month x


RSe best practice assumption   One off
                                                   Estimated cost of CDI           £400,000
Data Connects workshop         One off             solution
                                                   Estimated cost of adaptors      £120,000
Data Connects workshop         One off


Data Connects workshop         One off
                                                   Estimated cost of                £50,000
Data Connects workshop         One off             screenscraper
                                                 Estimated cost of                 £100,000
RSe best practice assumption   One off           Middleware
                                                 Number of days spent
                                         £46,020 measuring benefits per             £20,355   £25,665
RSe best practice assumption   One off           week x number of weeks in


N/a
                                         £82,600 Number of data stewards x          £36,535   £82,600   £82,600   £82,600   £82,600
RSe best practice assumption   Steady            salary of data steward
                                         £40,000                                    £17,692   £40,000   £40,000   £40,000   £40,000
RSe best practice assumption   Steady              Estimate
                                         £29,500                                    £13,048   £29,500   £29,500   £29,500   £29,500
Data Connects workshop         Steady              Estimate
                                         £12,500                                     £5,529   £12,500   £12,500   £12,500   £12,500
RSe best practice assumption   Steady              Estimate




                                                                                                                             Top
TOTAL Year 1


               £750,642
                £67,275
               £817,917




TOTAL Year 2


                £25,665
               £164,600
               £190,265




TOTAL Year 3


                     £0
               £164,600
               £164,600




TOTAL Year 4


                     £0
               £164,600
               £164,600




TOTAL Year 5


                     £0
               £164,600
               £164,600

				
DOCUMENT INFO
Description: Business Case Best Buy document sample