Item 10 Appendix 5
West Dunbartonshire Council · 30 August 2023
Back to West Dunbartonshire Council — 30 August 2023 and its agenda
Text extracted from the council's PDF. Layout and reading order may differ from the original.
Page 1
APPENDIX 5 WEST DUNBARTONSHIRE COUNCIL HRA CAPITAL PROGRAMME OVERALL PROGRAMME SUMMARY MONTH END DATE PERIOD 12 Spend to Date Spend to Date £000 £000 Red 19 70.4% 29,615 84.8% 19 70.4% 29,615 84.8% Amber 6 22.2% 5,314 15.2% 6 22.2% 5,314 15.2% Green 2 7.4% - 0.0% 2 7.4% - 0.0% 27 100% 34,929 100% 27 100% 34,929 100% Budget Spend to Date Forecast Spend Forecast Variance Budget Spend to Date Actual Spend Actual Variance Reprofiled Over/ (Under) £000 £000 £000 £000 £000 £000 £000 £000 £000 £000 189,926 29,615 198,219 8,293 59,543 29,615 29,615 (29,927) (38,184) 8,257 25,333 5,314 25,565 231 5,827 5,314 5,314 (513) (780) 268 860 0 626 (234) 234 0 0 (234) 0 (234) 216,120 34,929 224,410 8,290 65,604 34,929 34,929 (30,674) (38,965) 8,290 216,120 34,929 224,410 (8,290) 65,604 34,929 34,929 30,674 0 0 0 0 0 0 0 0 Projects are on target both in relation to overall budget and the forecast stages in the project life cycle and no issues are anticipated at this time 31 March 2023 Project Status Analysis Project Life Status Analysis Current Year Project Status Analysis Number of Projects at RAG Status % Projects at RAG Status % Project Spend at RAG Status Number of Projects at RAG Status % Projects at RAG Status % Project Spend at RAG Status Red Projects are forecast to be overspent and/or experience material delay to completion Amber Projects are either at risk of being overspent and/or delay in completion (although this is unquantifiable at present) or the project has any issues that require to be reported at this time Green Project Status Analysis Project Life Financials Current Year Financials Red TOTAL RESOURCES NET EXPENDITURE Projects are forecast to be overspent and/or significant delay to completion Amber Projects are either at risk of being overspent and/or delay in completion (although this is unquantifiable at present) or the project has any issues that require to be reported at this time Green Projects are on target both in relation to overall budget and the forecast stages in the project life cycle and no issues are anticipated at this time TOTAL EXPENDITURE
Page 2
WEST DUNBARTONSHIRE COUNCIL APPENDIX 5 HRA CAPITAL PROGRAMME ANALYSIS OF RED PROJECTS MONTH END DATE PERIOD 12 Budget Forecast/ Actual Spend £000 £000 % £000 £000 % 1 Project Life Financials 2,266 1,580 70% 3,415 1,149 51% Current Year Financials 431 1,580 367% 1,580 1,149 267% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 2 Project Life Financials 271 30 11% 212 (59) -22% Current Year Financials 185 30 16% 30 (155) -84% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 3 Project Life Financials 170 0 0% 170 0 0% Current Year Financials 40 0 0% 0 (40) -100% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 31 March 2023 Budget Details Project Life Financials Spend to Date Variance Main Issues / Reason for Variance Budget is overspent due to costs and demand for budget being higher than anticipated at time of budget setting. Mitigating Action None available at this time. Anticipated Outcome Project to complete over budget. Capitalised minor works This is a budget to undertake specific minor ad hoc capital projects that arise on demand Planned End Date Forecast End Date QL Development This budget relates to the costs associated with the development of the Integrated Housing Management System Anticipated Outcome Element of budget required to be rephased to 2023/24. Gypsy Travellers Site Gypsy/ Traveller Site improvements Planned End Date Forecast End Date Planned End Date Forecast End Date Main Issues / Reason for Variance Development of QL system continues through 2022/23. It was anticipated that two fixed term posts would be appointed to support the ongoing development, however these posts have not yet been filled and this element of the budget will be required to be reprofilled to 2023/24. Mitigating Action None available at this time. Main Issues / Reason for Variance The planned site improvement works were to be complimentary to a current live bid to the Scottish Government's Gypsy Traveller Accommodation Fund, that application is still being assessed by the Scottish Governement and to avoid abortive works site improvements planned were put in abeyance until we asceratin if the bid has been successful. We plan to reengage withe the community of receipt of the outcome of the bid and agree wider site improvements to be delivered in 2023/24. Mitigating Action None required Anticipated Outcome Full budget spend in 2023/24.
Page 3
WEST DUNBARTONSHIRE COUNCIL APPENDIX 5 HRA CAPITAL PROGRAMME ANALYSIS OF RED PROJECTS MONTH END DATE PERIOD 12 Budget Forecast/ Actual Spend £000 £000 % £000 £000 % 31 March 2023 Budget Details Project Life Financials Spend to Date Variance 4 Project Life Financials 17 0 0% 17 0 0% Current Year Financials 17 0 0% 0 (17) -100% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 5 Project Life Financials 36 0 0% 36 0 0% Current Year Financials 36 0 0% 0 (36) -100% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 6 Project Life Financials 192 0 0% 192 0 0% Current Year Financials 192 0 0% 0 (192) -100% Project Description Project Lifecycle 31-Mar-23 31-Mar-24 Community Safety Projects Community Safety Projects Planned End Date Forecast End Date Main Issues / Reason for Variance Budget not spent as anticipated, protracted issues with owners and commencement of works, to continue into 2023/24 for completion. Planned End Date Forecast End Date Main Issues / Reason for Variance A longer than expected procurment process and prioritisation of resources in the Housing Service meant 5 redeployable cameras could not be purchased as orginally planned before the end of 2022/23. This has however been completed in early 2023/24. Budget required to be carried forward to the new financial year to off-set with the spend incurred in 2023/24. Mitigating Action None required Mitigating Action None required Anticipated Outcome Full budget spend in 2023/24. Redeployable CCTV Cameras Purchase of 5 redeployable CCTV cameras for Housing use Main Issues / Reason for Variance The GAA have still to publish their Noise Insulation Scheme which was scheduled for Autumn 2022, the scheme would detail funding arrangements for those properties both commercial and residential that fall within the scope of the scheme. The delay to the publication has negated the opportunity to commence this project in 2022/23. Officers are pressing the GAA for an update in terms of their timescales, however it has now been reprofilied to 2023/24, where it is hopeful the project will progress. Mitigating Action Officers liasing with GAA Anticipated Outcome Budget to be rephased to 2023/24 Anticipated Outcome Full budget spend in 2023/24. Airport Noise Noise Insulation Project Planned End Date Forecast End Date
Page 4
WEST DUNBARTONSHIRE COUNCIL APPENDIX 5 HRA CAPITAL PROGRAMME ANALYSIS OF RED PROJECTS MONTH END DATE PERIOD 12 Budget Forecast/ Actual Spend £000 £000 % £000 £000 % 31 March 2023 Budget Details Project Life Financials Spend to Date Variance 7 Project Life Financials 19,841 5,328 27% 20,714 873 4% Current Year Financials 4,455 5,328 120% 5,328 873 20% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 8 Project Life Financials 17,607 2,397 14% 17,607 0 0% Current Year Financials 4,955 2,397 48% 2,397 (2,558) -52% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 Mitigating Action None required Anticipated Outcome Full budget spend Roof Coverings Building external component renewals, roofs/chimneys/flashings/fascias/gutters/svp Targeted SHQS /EESSH compliance works This budget is to focus on work required to maintain the SHQS compliance and energy efficiency with WDC housing stock. Planned End Date Forecast End Date Main Issues / Reason for Variance Budget overspent in 2022/23 due to a combination of increased costs and a higher number of completions. £0.054m of Energy Efficiencey unspent as all major efficiency works are charged to EESSH so this partially offsets part of the overspend. Anticipated Outcome Full budget will not be spent and balance to carry into 2023-24 Planned End Date Forecast End Date Main Issues / Reason for Variance Budget not fully spent as anticipated, many tiled roof blocks have owner involvment delaying the works due to protracted engagement, these will continue into 2023/24 for completion. Additional metal roofing anticiptated to continue into 2023/24. Reamining budget to be re-phased to 2023/24. Mitigating Action Officer and contracts team working to maximise progress where possible to increase completions and spend.
Page 5
WEST DUNBARTONSHIRE COUNCIL APPENDIX 5 HRA CAPITAL PROGRAMME ANALYSIS OF RED PROJECTS MONTH END DATE PERIOD 12 Budget Forecast/ Actual Spend £000 £000 % £000 £000 % 31 March 2023 Budget Details Project Life Financials Spend to Date Variance 9 Project Life Financials 10,963 1,494 14% 10,963 0 0% Current Year Financials 2,500 1,494 60% 1,494 (1,006) -40% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 10 Project Life Financials 566 146 26% 604 38 7% Current Year Financials 108 146 135% 146 38 35% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 11 Project Life Financials 5,092 3,197 63% 7,320 2,228 44% Current Year Financials 969 3,197 330% 3,197 2,228 230% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 Doors/window component renewals Doors/Windows Component Renewals Planned End Date Forecast End Date Main Issues / Reason for Variance Officers working to meet revised targets. Additional external support was programmed in from August 2022 onwards to assist with window installs, feedback from officers have highlighted challenges with resource levels from back-up contractor. Internal resources were maximised to increase installs where possible, however £1.006m will need to reprofiled into 2023/24. Mitigating Action Building Services actively redeploying internal resurces to assist with installs and working with external support to maximise contribution. Anticipated Outcome Anticipated to meet reduced forecast spend balance to be re-phased into future years. Main Issues / Reason for Variance Project has exceeded budget in 2023/24, this was necessary work to meet demand and comply with legislation. Mitigating Action None available. Anticipated Outcome Budget to overspend. Statutory/regulatory compliance works (lifts/electrical/legionnella/fire etc) This budget will be used to upgrade / replace components / installations in order to comply with the relevant standards / legislation / health and safety in relation to housing stock. Planned End Date Forecast End Date Mitigating Action None available since essential spend. Anticipated Outcome Budget to overspend. Heating improvement works Carry out works to renew inefficient boilers/full systems as identified from the stock condition survey and renewal of obsolete/damaged boilers. Planned End Date Forecast End Date Main Issues / Reason for Variance An overspend has been incurred on this budget, as experienced in recent years as demand has exceeded expectations. Due to the nature of this project (ensuring heating and hot water availability) there is no option for a conscious reduction of installs, resulting in the overspend.
Page 6
WEST DUNBARTONSHIRE COUNCIL APPENDIX 5 HRA CAPITAL PROGRAMME ANALYSIS OF RED PROJECTS MONTH END DATE PERIOD 12 Budget Forecast/ Actual Spend £000 £000 % £000 £000 % 31 March 2023 Budget Details Project Life Financials Spend to Date Variance 12 Project Life Financials 5,293 2,100 40% 6,357 1,065 20% Current Year Financials 1,036 2,100 203% 2,100 1,065 103% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 13 Project Life Financials 103 0 0% 103 0 0% Current Year Financials 103 0 0% 0 (103) -100% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 14 Project Life Financials 8,384 5,087 61% 11,471 3,087 37% Current Year Financials 2,000 5,087 254% 5,087 3,087 154% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 15 Project Life Financials 3,637 688 19% 3,637 0 0% Current Year Financials 887 688 78% 688 (199) -22% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 Modern facilities and services New Kitchens, Bathrooms and Showers Planned End Date Forecast End Date Improvement works (Risk St) Risk Street Over clad Planned End Date Forecast End Date Main Issues / Reason for Variance Budget not spent, roofing work instruction has been issued and contractor is arranging access and commencement. Budget to re-phase into 2023/24 for completion. Main Issues / Reason for Variance Budget overspent in 2023/24 as expected, due to costs and demand for budget being higher than anticipated at time of budget setting. Mitigating Action None available at this time. Anticipated Outcome Project to complete over budget. Planned End Date Forecast End Date Main Issues / Reason for Variance Void works continued in 2022/23 to bring void properties up to a lettable standard. The high number of voids has led to a higher than expected demand for this budget, resulting in an overspend in 2022/23. Mitigating Action None available at this time Mitigating Action None available at this time Anticipated Outcome Full budget spend potential for budget to re-phase into 2023/24 Void house strategy programme Spend on Void Properties to bring them up to letting standard Anticipated Outcome Void properties to be brought up to lettable standard, budget to overspend. Mitigating Action Contracts team working to maximise progress and outturn where able to. Anticipated Outcome Full spend unlikely to met and balance to carry forward to 2023/24 Defective structures/component renewals Defective structures Planned End Date Forecast End Date Main Issues / Reason for Variance Project ran slightly behind schedule in 2022/23, remaining balance to be reprofiled to 2023/24.
Page 7
WEST DUNBARTONSHIRE COUNCIL APPENDIX 5 HRA CAPITAL PROGRAMME ANALYSIS OF RED PROJECTS MONTH END DATE PERIOD 12 Budget Forecast/ Actual Spend £000 £000 % £000 £000 % 31 March 2023 Budget Details Project Life Financials Spend to Date Variance 16 Project Life Financials 5,092 1,639 32% 5,762 670 13% Current Year Financials 969 1,639 169% 1,639 670 69% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 17 Project Life Financials 1,135 301 27% 1,221 86 8% Current Year Financials 215 301 140% 301 86 40% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 18 Project Life Financials 2,378 0 0% 2,378 0 0% Current Year Financials 800 0 0% 0 (800) -100% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 Environmental renewal works, paths/fences/walls/parking area's Environmental renewal works, paths/fences/walls/parking areas Anticipated Outcome Full budget spend, with overspend anticipated. Asbestos management works This budget is to fund work associated with the management of current asbestos legislation and Planned End Date Forecast End Date Planned End Date Forecast End Date Main Issues / Reason for Variance An overspend was incurred in 2022/23 due to level of demand and a number of larger projects than anticipated together with material costs being higher than expected at time of budget setting. Mitigating Action None available at this time. Multi Story Flats ( including Fire Risk Assessment Works) High Rise Fire Safety Measures Planned End Date Forecast End Date Main Issues / Reason for Variance Our new Multi Storey enhanced living startegy was approved by the Housing and Communities Committee on 3rd May 2023, this was to allow significant consultation with existing tenants and to allow them to articulate where the clear spend prioritiies were. This will allow us to implement the strategy in a holistic manner and the allocated funding in 2022/23 will be reprofild to accelerate the delivery of the strategy in 2023/24. Main Issues / Reason for Variance Budget overspend was incurred in 2022/23 due to costs and demand being higher than expected at the time of budget setting. Mitigating Action None required Anticipated Outcome Full budget spend Mitigating Action None required Anticipated Outcome Full budget spend
Page 8
WEST DUNBARTONSHIRE COUNCIL APPENDIX 5 HRA CAPITAL PROGRAMME ANALYSIS OF RED PROJECTS MONTH END DATE PERIOD 12 Budget Forecast/ Actual Spend £000 £000 % £000 £000 % 31 March 2023 Budget Details Project Life Financials Spend to Date Variance 19 Project Life Financials 106,883 5,628 5% 106,039 (844) -1% Current Year Financials 39,645 5,628 14% 5,628 (34,017) -86% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 Variance to 22/23 Budget Site/ Spend £000 Overspend Underspend Reprofiling Aitkenbar Primary School (374) (374) Clydebank East (15,112) (15,112) Queens Quay Site B (573) (573) Queens Quay Site C (2,675) (2,675) Pappert (4,977) (4,977) Bank Street (1,240) (1,240) Willow Park Phase 1 (2,334) (2,334) Mount Pleasant (2,417) (2,417) Future New build sites budget (3,471) (3,471) Haldane Primary School 1 1 Creveul Court 2 2 Dumbarton Harbour Ph 3 1 1 St Andrews School (345) (345) General Homeloss & Disturbance 36 36 Fees, Staffing Costs, contingency (538) (538) TOTAL OF ALL PROJECTS (34,017) 40 (883) (33,173) Main Issues / Reason for Variance The £34.014m variance is made up of £0.040m overspend, £0.880m underspend, and reprofiling of £33.174m into 2023/24 onwards . Summary of reprofiled sites together with site specific updates as follows:- Clydebank East - 88 units to be completed on the site. Works commenced on this development on 23rd January 2023, the revised costs were reported to the Housing and Communities Committee in November 2022 and the initial programme will see the remedial works and external drainage programme, a construction site start is programmed for July 2023. The total programme for the works will now be 116 weeks. The development at Clydebank East will see the completion of a major housing led regeneration of a key priority area identified in the Local Housing Strategy and will be the Council’s first fully zero carbon housing development and marks a significant milestone in our transition to net zero approved at the August 2022 meeting of the Housing and Communities Committee. Queens Quay Site B - 29 units now completed on the site, and let by tenants. Retention figure was budgeted to be paid out in 2022/23, but will now be reprofiled to be paid in 2023/24 to allow time to finalise account. Queens Quay Site C – 20 units to be completed on site. Project spend now requires to be reprofiled. The budget provision is to acquire additional land within Queens Quay to enhance the Site C proposals, the discussions with CRL/Rydens have been protracted but we intend to make an offer shortly subject to a revised DV valuation being received. This will be reprofiled into 2023/24 (£1.878m). Affordable Supply Programme Affordable Housing Supply Programme Planned End Date Forecast End Date Variance Category Aitkenbar - Fully complete and final retention paid out in 2022/23.
Page 9
WEST DUNBARTONSHIRE COUNCIL APPENDIX 5 HRA CAPITAL PROGRAMME ANALYSIS OF RED PROJECTS MONTH END DATE PERIOD 12 Budget Forecast/ Actual Spend £000 £000 % £000 £000 % 31 March 2023 Budget Details Project Life Financials Spend to Date Variance TOTAL OF ALL PROJECTS Project Life Financials 189,926 29,615 16% 198,219 8,293 4% Current Year Financials 59,543 29,615 50% 29,615 (29,927) -50% Pappert - 26 units to be completed on site . Projects spend now requires to be reprofiled. The anticipated site start of October 2022 was not be realised due to a number of factors that have caused the project to miss a number of milestones, notably a longer than anticipated procurement process and the subsequent delay in developing a contract/tender preparation forced us to miss a pricing window from the contractor, we now have a new cost price and this project was recently in receipt of an additional £1.25m form the Scottish Government Vacant and Derelict Land Fund which willl be received in 2023/24 and 2024/25. It is expected to start onsite in January 2024. Future New Build gap sites – Project spend now requires to be reprofiled. Ongoing work to acquire private and Council owned sites to finalise wider strategy. Anticipated Outcome Project will still complete and will meet revised spend profiles . Bank Street - 22 units to be completed on the site. Project spend needs reprofiled due to wider strategic reasons and potential reprovisioning of sheltered accommodation which will require consultative exercise . Revised estimated start date May 2024, estimated completion May 2025. Project is currently at feasibility stage. Willox Park Phase1 - 17 units to be completed on site. Project spend now requires to be reprofiled. Pre planning discussions were more involved than anticipated and required some re designing and procurement delays to assemble a full design time which has resulted in delay to estimated start date from January 2023 to March 2024 with estimated completion March 2025. Officers ready to submit to for full planning. Tender application expected to go out summer 2023. Mount Pleasant - 19 units to be completed on site. Project spend now requires to be reprofiled. Unanticipated longer time frame for demolition (9 months) has delayed this project by 6 months, now estimating a March 2024 site start. Bonhill Gap Site - 34 units to be completed on site. The project is currently at design stage with, estimated start date May 2024 and estimated completion May 2025. Mitigating Action Staff will work closely with all stakeholders to try and ensure timely resolutions of issues as they arise. Haldane Primary School - complete Creveul Court - complete Dumbarton Harbour Ph 3 - complete St Andrews School - complete
Page 10
WEST DUNBARTONSHIRE COUNCIL APPENDIX 5 HRA CAPITAL PROGRAMME ANALYSIS OF AMBER PROJECTS MONTH END DATE PERIOD 12 Budget Forecast/ Actual Spend £000 £000 % £000 £000 % 1 Project Life Financials 2,487 532 21% 2,545 59 2% Current Year Financials 474 532 112% 532 59 12% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 2 Project Life Financials 1,557 355 23% 1,557 0 0% Current Year Financials 664 355 54% 355 (308) -46% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 3 Project Life Financials 257 81 32% 263 6 2% Current Year Financials 75 81 109% 81 6 9% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 31 March 2023 Budget Details Project Life Financials Spend to Date Variance Special needs adaptations None available at this time Anticipated Outcome Full budget spend. Adaptations to Housing for Special Needs Planned End Date Forecast End Date Main Issues / Reason for Variance Overspend incurred in 2022/23 due to price increases and demand levels rising. Mitigating Action Better Homes Priority Budget Priority projects as prioritised by the Better Homes Group Planned End Date Forecast End Date Main Issues / Reason for Variance A number of priority initiatives, supported by the Better Homes Project Board are being progressed and will have positive impact on the current council housing stock and budget, these works will complete in 2023/24. Mitigating Action None required Anticipated Outcome Full budget spend Mitigating Action None required Anticipated Outcome Full budget spend External stores/garages/bin stores/drainage component renewals This budget is to focus on external stores/garages/bin stores etc. component renewals as identified and recommended from the housing stock condition survey. Planned End Date Forecast End Date Main Issues / Reason for Variance Works complete as expected, with small overspend incurred.
Page 11
WEST DUNBARTONSHIRE COUNCIL APPENDIX 5 HRA CAPITAL PROGRAMME ANALYSIS OF AMBER PROJECTS MONTH END DATE PERIOD 12 Budget Forecast/ Actual Spend £000 £000 % £000 £000 % 31 March 2023 Budget Details Project Life Financials Spend to Date Variance 4 Project Life Financials 273 100 37% 282 9 3% Current Year Financials 91 100 110% 100 9 10% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 5 Project Life Financials 7,729 1,584 20% 7,729 0 0% Current Year Financials 2,019 1,584 78% 1,584 (435) -22% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 Secure entry component renewals This budget is to focus on secure door entry component renewals as identified and recommended from the housing stock condition survey and appropriate council officer referrals. Anticipated Outcome Anticipated not to meet full spend despite best efforts. Planned End Date Forecast End Date Main Issues / Reason for Variance Budget overspent in 2022/23 as able to complete a higher number of installations than expected due to protracted time to gain owner agreement. Mitigating Action Officers continue to liaise with owners to encourage agreement for install. Buy Backs This is a budget to undertake specific projects that will deliver housing policies/strategies, example: Ex local authority and mortgage to rent buy-back scheme Anticipated Outcome Budget spend anticipated, should criteria be met. Planned End Date Forecast End Date Main Issues / Reason for Variance The main objective of the Buy Back Scheme is to bring former council properties that were sold through the RTB scheme, back into council use. These properties must assist the council with reducing housing need on the waiting list and where appropriate assist with external capital works. For these reasons, any purchase is subject to stringent criteria to ensure accountability and value for money for existing tenants. Spend in 2022/23 has therefore be dependent on these factors. 16 homes have been purchased during 2022/23, with the remaining budget required to be re-profiled to 2023/24 to continue the buyback scheme. Mitigating Action None required.
Page 12
WEST DUNBARTONSHIRE COUNCIL APPENDIX 5 HRA CAPITAL PROGRAMME ANALYSIS OF AMBER PROJECTS MONTH END DATE PERIOD 12 Budget Forecast/ Actual Spend £000 £000 % £000 £000 % 31 March 2023 Budget Details Project Life Financials Spend to Date Variance 6 Project Life Financials 13,031 2,661 20% 13,189 157 1% Current Year Financials 2,504 2,661 106% 2,661 157 6% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 TOTAL OF ALL PROJECTS Project Life Financials 25,333 5,314 21% 25,565 231 1% Current Year Financials 5,827 5,314 91% 5,314 (513) -9% Main Issues / Reason for Variance Budget utilised for salaries and support of the HRA capital programme. Mitigating Action None required Anticipated Outcome Full budget spend Salaries/central support/offices Allocation of costs from other WDC services who support the HRA capital programme Planned End Date Forecast End Date
Page 13
WEST DUNBARTONSHIRE COUNCIL APPENDIX 5 HRA CAPITAL PROGRAMME ANALYSIS OF GREEN PROJECTS MONTH END DATE PERIOD 12 Budget Forecast/ Actual Spend £000 £000 % £000 £000 % 1 Project Life Financials 280 0 0% 226 (54) -19% Current Year Financials 54 0 0% 0 (54) -100% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 2 Project Life Financials 581 0 0% 400 (181) -31% Current Year Financials 181 0 0% 0 (181) -100% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 TOTAL OF ALL PROJECTS Project Life Financials 860 0 0% 626 (234) -27% Current Year Financials 234 0 0% 0 (234) -100% 31 March 2023 Budget Details Project Life Financials Spend to Date Variance Planned End Date Forecast End Date Main Issues / Reason for Variance All major energy efficiency work is done on the SHQS/ EESH programme. Budget not required to be rephased. Mitigating Action None required Energy improvements/energy efficiency works Energy improvements/ efficiency works (e.g. loft insulation, pipe/tank insulation, draught exclusion) Anticipated Outcome Project works to be completed Contingencies This is a contingent budget for unforeseen matters which may arise during the year. Planned End Date Forecast End Date Main Issues / Reason for Variance Contingent budget held for unplanned spend. Mitigating Action None at this time Anticipated Outcome Spend as required
Page 14
WEST DUNBARTONSHIRE COUNCIL APPENDIX 5 HRA CAPITAL PROGRAMME ANALYSIS OF RESOURCES MONTH END DATE PERIOD 12 Budget Forecast/ Actual Spend £000 £000 % £000 £000 % 1 Project Life Financials (48,826) (4,018) 8% (48,826) 0 0% Current Year Financials (30,006) (4,018) 13% (4,018) 25,988 -87% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 2 Project Life Financials (42,531) 0 0% (36,816) 5,715 -13% Current Year Financials (9,215) (3,500) 38% (3,500) 5,715 -62% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 3 Project Life Financials (124,667) (26,835) 22% (124,667) 0 0% Current Year Financials (26,286) (26,835) 102% (26,835) (549) 2% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 Due to spend being later than anticiapted , receipt of grant will also be later than budgeted. Mitigating Action Income budget wil be reprofiled to match reprofiled spend Anticipated Outcome Income will be received when due Main Issues / Reason for Variance 31 March 2023 Budget Details Project Life Financials Spend to Date Variance New Build Grant Grant to facilitate new build housing Planned End Date Forecast End Date CFCR This is capital spend which is funded by revenue budgets Planned End Date Forecast End Date Main Issues / Reason for Variance Income from Revenue reduced to offset adverse varainces in HRA revenue Mitigating Action None required Anticipated Outcome Reduced CFCR Prudential Borrowing Prudential borrowing is long term borrowing from financial institutions that has been approved for the purposes of funding capital expenditure Planned End Date Forecast End Date Main Issues / Reason for Variance Prudential borrowing is impacted by programme delivery, and contributing CFCR from revenue, therefore due to reprofiling and CFCR being lower than anticipated, this increases the balance for borrowing in 2022/23. Mitigating Action None available at this time. Anticipated Outcome Prudential borrowing requirement slightly higher than anticipated.
Page 15
WEST DUNBARTONSHIRE COUNCIL APPENDIX 5 HRA CAPITAL PROGRAMME ANALYSIS OF RESOURCES MONTH END DATE PERIOD 12 Budget Forecast/ Actual Spend £000 £000 % £000 £000 % 31 March 2023 Budget Details Project Life Financials Spend to Date Variance New Build Grant 4 Project Life Financials (96) (576) 600% (672) (576) 600% Current Year Financials (96) (576) 600% (576) (480) 500% Project Description Project Lifecycle 31-Mar-27 31-Mar-27 TOTAL RESOURCES Project Life Financials (216,120) (31,429) 15% (210,981) 5,139 -2% Current Year Financials (65,604) (34,929) 53% (34,929) 30,675 -47% Other Capital Income Other Income to capital Planned End Date Forecast End Date Main Issues / Reason for Variance £0.096m estimated income from Glasgow Airport Authority will now not be received in 2022/23 as works have not progressed, however £0.575mm Scottish Governmant Grant income in relation to buy backs has been received in 2022/23. Mitigating Action None available Anticipated Outcome Income will be received when due
Page 16
WEST DUNBARTONSHIRE COUNCIL APPENDIX 5 HRA CAPITAL PROGRAMME ANALYSIS OF AFFORDABLE HOUSING SUPPLY PROGRAMME MONTH END DATE PERIOD 12 Budget Spend to Date Forecast Spend £000 £000 £000 £000 % RAG Status St Andrews School 636 291 291 345- -54% Haldane Primary School 148 149 149 1 1% Aitkenbar Primary School 652 278 652 - 0% Clydebank East 26,474 3,642 26,474 - 0% Creveul Court 58 60 60 2 4% Dumbarton Harbour Ph 3 - 1 1 1 #DIV/0! Queens Quay Site B 1,259 554 1,259 - 0% Queens Quay Site C 6,198 3 6,198 - 0% Pappert 7,332 3 7,332 - 0% Lilac Avenue 2,676 - 2,676 - 0% Bank Street 4,674 0 4,674 - 0% Clydebank Health Centre 6,930 14 6,930 - 0% Willox Park Phase1 3,817 56 3,817 - 0% Willox Park Phase2 6,300 - 6,300 - 0% Mount Pleasant 4,200 103 4,200 - 0% Silverton 2,100 - 2,100 - 0% Fees, Staffing Costs, contingency 4,005 299 3,503 502- -13% Gap sites Bonhill Gap Site 420 175 420 - 0% - Future New build sites 16,823 1 16,823 - 0% Total Expenditure 94,702 5,628 93,859 (844) 31 March 2023 Site Project Life Financials Variance