EGF - Stage 1 - 091 - H&I Shared Payroll - Bid

DescriptionSTATUS - UNSUCCESSFUL - To fund a re-implementation of the Resourcelink Payroll and HR systems currently in use within the four councils.
ISBN
Official Print Publication DateJuly 2005
Website Publication DateMarch 14, 2006

    Listen

    This document is also available in pdf format (114k)

    EFFICIENT GOVERNMENT FUND BID
    "SHARED PAYROLL SYSTEM"

    EFFICIENT GOVERNMENT FUND

    Stage 1 application - expression of interest

    Part 1: Summary Table

    Bid number (for EG use)

    EGF/1/3/091

    Lead bidder

    Argyll and Bute Council.

    Brief description of the aims of the project

    To establish a shared payroll and HR system within Argyll and Bute Council, Highland Council, Orkney Islands Council and Western Isles Council and to standardise payment methods within the Councils.

    Clear description of what the EGF money would be used to buy

    The EGF money will be used to fund a re-implementation of the Resourcelink Payroll and HR systems currently in use within the four Councils. This will involve the hiring of consultants and the backfilling of staff from the four Councils who will form the Project Team.

    EGF money will also be used to fund a compensation package that will allow the payroll periods within the Councils to be standardised on to monthly payments

    Partners to the project likely to commit resources

    Highland Council
    Western Isles Council
    Orkney Islands Council

    Names of other organisations with whom the project has been discussed (to assist the introductions process)

    Shetland Islands Council

    Evidence that suggested approach has been deployed successfully elsewhere

    Are there any restrictions to enlargement of the project (i.e. number of partners)

    No, in theory there is no reason why the whole of the Scottish local government sector should not make use of the same payroll implementation - there is still scope for local conditions within this

    Benefits projected from the project

    • Shared procurement - licencing costs
    • Shared systems admin
    • Shared Development
    • Rationalisation of pay periods
    • Specialisation on HR
    • Standardisation of data sets for comparisons - trends etc
    • Increased resiliance

    Estimated financial projections

    Total

    2006/7

    2007/8

    2008/9

    2009/10

    Overall project cost

    2.15m

    2.03m

    0.12m

    0

    0

    Estimated projected benefits

    3.13m

    0

    1.03m

    1.05m

    1.05m

    Is a pilot required - see guidance notes

    No, the software is already proven within each of the Councils currently using this payroll and HR system. This is basically a standardisation and sharing of best practice. The move to single monthly payroll is an ambition of most local authority HR managers. The savings are reasonably transparent.

    Additionally: why is EG funding required

    The funding for the shared implementation cannot be met from Council's current budgets as each Council's system is at different stages of its life cycle. Highland Council, Orkney Islands and Western Isles have relatively recent implementations while Argyll and Bute Council's is more mature.

    If Council's are to move staff from weekly or fortnightly payments on to monthly then they will need to provide a compensation package to allow the more frequently paid staff (often the lowest paid employees of the Council) to make the adjustment in their family budgets.

    Does this project complementary in anyway to other EG work

    This project will release real savings in back office staff and the shared data set will allow the Council's a platform to compare their HR trends and identify areas of best practice.

    Part 2: Narrative Bid

    Background

    Each local authority has their own payroll system, individually implemented to suit their own needs. Argyll and Bute, Highland and Western Isles and Orkney Islands Councils all run on ResourceLink but have been implemented separately and in different ways. Orkney Islands Council currently use the Highland Council implementation. Smaller Councils in particular use a disproportionate amount of their resources on systems administration and development work. It is often the case also that the skills to undertake this work are shared between very few staff in an authority and the departure or absence of those staff can cause severe disruption to the smooth running of the system.

    Most Councils have staff on a range of inherited conditions of service. While payroll systems can cope with an almost limitless variety of terms and allowances, dealing with numerous payruns for staff paid on different periods is particularly labour intensive within payroll sections. To be simplistic, paying staff on a weekly basis is four to five times more expensive administratively than making the same payments on a monthly basis, in terms of payroll staff, payslip generation and distribution etc. The cost of subsidising the transition for staff on weekly pays in particular has meant that Councils have not on the whole tackled this issue.

    Objectives of the Proposal

    The objectives of the proposal are to re-implement the payroll systems for four Councils using the existing software package all four are familiar with. At the same time the Councils will begin standardising their terms and conditions by addressing the issue of pay periods within the Councils which is the most administratively expensive.

    The proposal impacts on three of the Efficient Government themes;

    1. Procurement - The four Councils acting together will be able to negotiate a more favourable licence arrangement with the software vendor. There should also be significant economies in scale from engaging a single consultant to carry out the joint implementation.
    2. Support Service Reform (Human Resources) - Although the immediate and significant impact of this proposal in terms of support services will be within the payroll sections the opportunities for genuine reform are with the Human Resources sections of Councils involved. While the shared data set will not give officials access to each other's data it will provide a standard for benchmarking and will give a broader base for any statistical analysis. There will also be opportunities for sharing expertise within the HR sections in different Councils. This will lead to a sharing of best practice and a rationalisation of terms and practices.
    3. Transactional Processing - the move to monthly payrolls will result in a substantial saving in transactions processed, both by staff within individual services and staff within payroll. There will also be a reduction in the number of payslips produced and distributed to employees.

    Areas for Inclusion in the Project

    The project will embrace payroll and human resource functions across the Councils involved.

    Project Costs

    The overall project cost is estimated to be in the region of £2,150,049

    2006/07

    £2,030,049

    2007/08

    £120,000

    The costs comprise;

    • The re-implementation costs of the payroll system
    • Subsidising the transition costs of employees from weekly and fortnightly pays to monthly pay.

    Estimated Projected Benefits

    2006/07

    2007/08

    2008/09

    2009/10

    Shared Systems Admin

    15,000

    15,000

    Shared Development

    10,000

    10,000

    Payroll Staffing

    170,914

    170,914

    170,914

    Service Dept Staffing

    133,567

    133,567

    133,567

    Payslip Gen. & Dist.

    45,448

    45,448

    45,448

    Compensation payback

    676,683

    676,683

    676,683

    Conclusion

    The project does not rely on unproven technology but instead is based on standardising the use of a system, which is already in operation within each of the partner authorities. By building on the experience each authority has in implementing and using the system the new implementation should be better than the best of the three at present. There is little doubt that the joint system will be more cost effective to administer than the three separate systems currently in use.

    By moving to a single monthly pay period the authorities can make substantial savings in the staff administering the payroll system.

    APPENDIX 1

    CALCULATIONS AND ASSUMPTIONS

    COSTS

    1. Subsidising the transition of staff from weekly and fortnightly to monthly pay.

    This is based on Argyll and Bute Council payroll values, taking one weeks pay for weekly paid staff - with two weeks lying time this should be sufficient to bridge the gap from the last weekly pay to the first monthly pay. For fortnightly paid staff allowance has been made for an additional two weeks pay to bridge the gap until the first month's pay is due.

    Normal payroll totals are as follows;

    PAYRUNPAYS/YEARSTAFF NOSPAYRUN VALUE

    Pay01

    50

    2034

    307,000

    Pay06

    26

    235

    167,000

    Pay09

    26

    36

    14,000

    Pay15

    26

    286

    48,000

    TOTAL

    536,000

    Argyll and Bute Council Total

    536,000

    Populations; Argyll and Bute Council

    91,300

    Highland Council

    209,080

    Western Isles Council

    26,100

    Orkney Islands Council

    19,310

    Total

    345,790

    Total Estimated Cost across three Councils

    536,000 *345,790/91,300

    =£2,030,049

    2. The cost of re-implementation of Resourcelink to give standard data sets for the three Councils covering Payroll and HR. This assumes no change in licencing numbers (currently 112 in Argyll and Bute) and no additional hardware costs or server consolidation. The cost estimated is that for consultancy and data migration for the three Councils and is based on forty days consultancy for each Council at £1,000 per day.

    £120,000

    Benefits

    1. By standardising on a monthly pay period for all staff, probably based across two payruns in a month, one for teaching staff and one for all others, the payroll sections involved can make the following savings;

    Staff - saving of one Senior Payroll Assistant (GS3)

    15,063

    Saving of 1.5 Payroll Assistants (GS1-2)

    21,330

    Indirect Staffing Costs (Emp NI, Pension etc)

    8,734

    Total Payroll Staffing for Argyll and Bute

    45,127

    To estimate for four Councils (345,790/91,300)

    170,914

    2. Departmental Staff Savings - due to the decentralised collection and administration of timesheets these savings should be classed as time releasing rather than cashable

    Community Services (1 FTE)

    14,220

    Operational Services (1 FTE)

    14,220

    Indirect Staffing Costs

    6,826

    Total Dept Staffing for Argyll and Bute

    35,266

    To estimate for three Councils (345,790/91,300)

    133,567

    3. Payroll Generation and Distribution

    (50% of Argyll and Bute costs for posting etc)

    Total for Argyll and Bute

    12,000

    To estimate for three Councils (345,790/91,300)

    45,448

    4. Systems Admin and Development savings are a notional figure representing the minimum the three Councils should be able to save on an annual basis by sharing these functions.

      Page updated: Thursday, February 23, 2006