Item 14 - Appendix 6
West Dunbartonshire Council · 16 August 2023
Back to Corporate Services Committee — 16 August 2023 and its agenda
Text extracted from the council's PDF. Layout and reading order may differ from the original.
Page 1
WEST DUNBARTONSHIRE COUNCIL GENERAL SERVICES CAPITAL PROGRAMME ANALYSIS OF PROJECTS MASTER LIST PERIOD END DATE PERIOD 10 Budget Forecast Spend £000 £000 % £000 £000 % 1 Project Life Financials 15 6 38% 16 1 4% Current Year Financials 2 2 119% 2 0 19% Project Description Project Manager Russell Hewton Chief Officer Russell Hewton Project Lifecycle 31-Mar-23 31-Mar-24 2 Project Life Financials 10 20 199% 20 10 99% Current Year Financials 0 0 0% 10 10 13594% Project Description Project Manager Karen Shannon Chief Officer Laurence Slavin Project Lifecycle 31-Mar-24 31-Mar-24 3 Project Life Financials 50 51 101% 51 1 1% Current Year Financials 7 0 0% 8 1 10% Project Description Project Manager Karen Shannon Chief Officer Laurence Slavin Project Lifecycle 31-Mar-23 31-Mar-24 31 January 2023 Budget Details Project Life Financials Spend to Date Variance Valuation Joint Board - Requisition of ICT Equipment Main Issues / Reason for Variance Budget was rephased to 2022-2023 as version upgrade of the Council's cash receipting system is required beforehand and is currently underway. The Module for this has been secured and anticipated timescales for Go Live is May 2023. Mitigating Action None required at this time. Anticipated Outcome Upgraded version with PCI compliant telephone payment system. None required at this time. Anticipated Outcome Requisition of ICT Equipment. Payment Card Industry Data Security Standard (PCIDSS) Module would ensure that WDC were compliant with the current requirements of PCIDSS for card payments without the need for numerous costly workarounds Planned End Date Forecast End Date Requisition ICT Equipment. Planned End Date Forecast End Date Main Issues / Reason for Variance Replacement of laptops, monitors and other ICT equipment. No further spend anticipated. Mitigating Action Mitigating Action None required at this time. Anticipated Outcome Upgraded Electronic Insurance System. Electronic Insurance System Acquisition of a claims/incident management system supported by an electronic document management system. Planned End Date Forecast End Date Main Issues / Reason for Variance The various claim forms and departmental reports have been reviewed and updated and the relevant online request forms were submitted to the Digital Sub-Group to be converted to Online Achieve Forms. The various claim forms and departmental reports have now been converted to Online Achieve Forms and are in the process of being tested. Once complete, the supplier will take matters forward with their design team. An anticipated timeline for completion of the project, taking into account the various stages i.e. development, testing, going live etc. will be drawn up in conjunction with the supplier at that time. Budget spend anticipated in 2023/2024. APPENDIX 6
Page 2
WEST DUNBARTONSHIRE COUNCIL GENERAL SERVICES CAPITAL PROGRAMME ANALYSIS OF PROJECTS MASTER LIST PERIOD END DATE PERIOD 10 Budget Forecast Spend £000 £000 % £000 £000 % 31 January 2023 Budget Details Project Life Financials Spend to Date Variance Valuation Joint Board - Requisition of ICT Equipment 4 Project Life Financials 40 40 100% 40 (0) 0% Current Year Financials 35 0 0% 35 0 0% Project Description Project Manager Karen Shannon Chief Officer Laurence Slavin Project Lifecycle 30-Sep-23 30-Nov-23 5 Project Life Financials 30 30 100% 30 0 0% Current Year Financials 23 0 0% 23 0 0% Project Description Project Manager Adrian Gray Chief Officer Laurence Slavin Project Lifecycle 31-Mar-27 31-Mar-27 6 Project Life Financials 5 5 100% 5 0 0% Current Year Financials 5 0 0% 5 0 0% Project Description Project Manager Jackie Nicol Thomson Chief Officer Laurence Slavin Project Lifecycle 31-Mar-23 31-Mar-24 Planned End Date Forecast End Date Main Issues / Reason for Variance Budget has been reprofiled to Financial Year 2023-2024. Version 2 of the upgrade was completed Jan 2023. Currently working on Call Secure Module with an anticipated go live late Autumn 2023. Mitigating Action None required at this time. Enhancements to Cash Receipting System To enhance the cash receipting system in the way payments are made and allocated to back office by increasing the level of security that is required for online payments made by customers IFRS 16 Database This is a system which will ensure that WDC has the correct level of information and adheres to correct reporting of IFRS16 - Leasing. Planned End Date Forecast End Date Main Issues / Reason for Variance IFRS16 has been postponed and is due for implementation this financial year. It is anticipated that full spend will be incurred by 31 March 2024 Main Issues / Reason for Variance Work done during May and June, plus ongoing. Not invoiced until July. Mitigating Action None required Anticipated Outcome Anticipate completion of upgrade during 23-24 financial year. Anticipated Outcome Enhancements to the cash receipting system including PCI compliant telephone payment system. Agresso development The purpose of this project is to carry out an upgrade of the Agresso Finance System which was last upgraded in 2015. The requirement to upgrade is to maintain a level of support available from Unit 4 who have advised that support for older versions of the system is being reduced. Planned End Date Forecast End Date Mitigating Action None available at this time. Anticipated Outcome Completion of project by 31 March 2024
Page 3
WEST DUNBARTONSHIRE COUNCIL GENERAL SERVICES CAPITAL PROGRAMME ANALYSIS OF PROJECTS MASTER LIST PERIOD END DATE PERIOD 10 Budget Forecast Spend £000 £000 % £000 £000 % 31 January 2023 Budget Details Project Life Financials Spend to Date Variance Valuation Joint Board - Requisition of ICT Equipment 7 Project Life Financials 33 33 100% 33 0 0% Current Year Financials 33 0 0% 33 0 0% Project Description Project Manager Alan Douglas Chief Officer Alan Douglas Project Lifecycle 31-Mar-24 31-Mar-24 8 Project Life Financials 2,749 2,762 100% 2,762 13 0% Current Year Financials 814 (248) -30% 814 0 0% Project Description Project Manager Sarah Christie/Michelle Lynn Chief Officer Amanda Graham Project Lifecycle 31-Mar-23 31-Mar-24 9 Project Life Financials 60 60 100% 60 0 0% Current Year Financials 10 0 0% 10 0 0% Project Description Project Manager James Gallacher Chief Officer Victoria Rogers Project Lifecycle 31-Oct-22 31-Mar-24 Legal Case Management System Legal Case Management System Planned End Date Forecast End Date Main Issues / Reason for Variance Budget has been repahsed from 2022/23. Project was originally delyaed due to COVID19 restrictions and a decision was made to resume project once mocrosoft 365 was implemeted. It is anticipated that the project will complete by 31 March 2024 Mitigating Action None available at this time. Anticipated Outcome Project will be delivered on budget Anticipated Outcome Projects delivered on budget Planned End Date Forecast End Date Main Issues / Reason for Variance The original projected spend has been affected by internal and external delays due to the Covid 19 recovery, a reduction in the scope of the Clydebank Town Hall project, a change in the delivery date for the Clydebank Museum at Clydebank Library during the contract award stage, while the new Dalmuir Library and Gallery had to be rescheduled for approval in August 2021. Officers are now making progress to get projects back on track, projects will still be delivered in full. Mitigating Action None avaialble at this time Heritage Capital Fund Heritage Capital Fund. Mitigating Action None available at this time. Anticipated Outcome Technical aspect of the project is complete and WDC assisting with user testing. Delayed but on budget. Internet of Things Asset Tracking Asset Tracking. Planned End Date Forecast End Date Main Issues / Reason for Variance Technical aspect of the project is complete and WDC are assisting with user testing. Delayed but on budget. This is funded by Scottish Government budget.