Appendix C UKSPF Expenditure Spreadsheet
Argyll and Bute Council · 11 August 2022
Back to Policy and Resources Committee — 11 August 2022 and its agenda
Text extracted from the council's PDF. Layout and reading order may differ from the original.
Page 1
Version 2 Funding Profile: Funding Sources 2022-23 2023-24 2024-25 Total UKSPF Allocation excluding Multiply £451,343 £902,686 £2,365,038 £3,719,067 Multiply Allocation £234,698 £270,806 £270,806 £776,310 Total UKSPF Allocation £686,041 £1,173,492 £2,635,844 £4,495,377 Please complete the funding profile for the three years. The funding profile total should correspond with your expenditure profile (Table B) totals. Appendix C - UKSPF Expenditure SpreadsheetTable A - Funding Profile
Page 2
Expenditure Profile Investment Priority Intervention UKSPF Allocation % of Total UKSPF Allocation 2022-23 2023-24 2024-25 Annual Expenditure Totals Capital 22/23 Revenue 22/23 Capital 23/24 Revenue 23/24 Capital 24/25 Revenue 24/25 Capital/Revenue Totals Supporting comments relating to expenditure Communities & Place S1: Place based investments, regen & town centre improvements 0% £0 £0 Communities & Place S2: Support/improve community assets & infrastructure projects 0% £0 £0 Communities & Place S3: Improvements to the natural environment, green & open space 0% £0 £0 Communities & Place S4: Design & management of the built & landscaped environment 0% £0 £0 Communities & Place S5: Support sport, arts, cultural, heritage & creative activities 0% £0 £0 Communities & Place S6: Active travel enhancements & small scale transport projects 0% £0 £0 Communities & Place S7: Campaigns to encourage visiting & exploring the local area £163,991 4% £55,000 £50,000 £50,000 £155,000 £0 £55,000 £0 £50,000 £0 £50,000 £155,000 Communities & Place S8: Impactful volunteering and/or social action projects £68,991 2% £20,000 £20,000 £20,000 £60,000 £20,000 £0 £15,000 £5,000 £15,000 £5,000 £60,000 Communities & Place S9: Investment in capacity building & resilience for local groups £328,244 9% £2,000 £57,359 £250,903 £310,262 £0 £0 £57,359 £0 £250,903 £0 £308,262 Communities & Place S10: Community measures to reduce the cost of living £416,991 11% £0 £0 £480,000 £480,000 £0 £0 £0 £0 £0 £408,000 £408,000 Communities & Place S11: Relevant feasibility studies 0% £0 £0 Communities & Place S12: Digital infrastructire for local community facilities £90,741 2% £20,000 £30,875 £30,875 £81,750 £0 £20,000 £0 £30,875 £0 £30,875 £81,750 Communities & Place S13: Linking communities with employment opportunities - decarbonisation £148,991 4% £0 £70,000 £70,000 £140,000 £0 £0 £0 £70,000 £0 £70,000 £140,000 Communities & Place Total for 'On-menu' Interventions £1,217,949 32% £97,000 £228,234 £901,778 £1,227,012 £20,000 £75,000 £72,359 £155,875 £265,903 £563,875 £1,153,012 Communities & Place Insert Bespoke Intervention 0% £0 £0 Communities & Place Insert Bespoke Intervention 0% £0 £0 Communities & Place Insert Bespoke Intervention 0% £0 £0 Communities & Place Insert Bespoke Intervention 0% £0 £0 Communities & Place Insert Bespoke Intervention 0% £0 £0 Communities & Place C&P Bespoke Interventions Total £0 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 Communities & Place Communities & Place Interventions Total £1,217,949 32% £97,000 £228,234 £901,778 £1,227,012 £20,000 £75,000 £72,359 £155,875 £265,903 £563,875 £1,153,012 Local Business S14: Development & promotion of the visitor economy £53,991 1% £10,000 £15,000 £20,000 £45,000 £0 £10,000 £0 £15,000 £0 £20,000 £45,000 Local Business S15: SME development grants & support. £308,891 8% £35,800 £100,000 £164,100 £299,900 £10,000 £25,800 £0 £100,000 £0 £164,100 £299,900 Local Business S16: R&D grants supporting innovative product & services £108,991 3% £20,000 £40,000 £40,000 £100,000 £0 £20,000 £0 £40,000 £0 £40,000 £100,000 Local Business S17: Development & support of appropriate innovation infrastructure 0% £0 £0 Local Business S18: Investing in enterprise infrastructure, site development projects 0% £0 £0 Local Business S19: Strengthening local entrepreneurial ecosystems 0% £0 £0 Local Business S20: Expert business advice & support programmes, local & regional 0% £0 £0 Local Business S21: Bid for & host international business events 0% £0 £0 Local Business S22: Growing the local social economy. £80,145 2% £0 £35,577 £35,577 £71,154 £0 £0 £0 £35,577 £0 £35,577 £71,154 Local Business S23: Develop angel investor networks nationwide 0% £0 £0 Local Business S24: Export grants to support businesses to grow overseas trading 0% £0 £0 Local Business S25: Developing existing or emerging local strengths - low carbon & climate 0% £0 £0 Local Business S26: Business support measures to drive employment growth £188,991 5% £30,000 £75,000 £75,000 £180,000 £0 £30,000 £0 £75,000 £0 £75,000 £180,000 Local Business S27: Support relevant feasibility studies 0% £0 £0 Local Business S28: Business resilience & Covid-19 recovery 0% £0 £0 Local Business S29: Business support aligned with local, regional & Scottish policy £462,991 12% £0 £95,897 £358,103 £454,000 £0 £0 £28,769 £67,128 £142,431 £215,672 £454,000 Local Business S30: Investment to protect from natural hazards, flooding & coastal erosion 0% £0 £0 Local Business Total for 'On-menu' Interventions £1,204,000 32% £95,800 £361,474 £692,780 £1,150,054 £10,000 £85,800 £28,769 £332,705 £142,431 £550,349 £1,150,054 Local Business Insert Bespoke Intervention 0% £0 £0 Local Business Insert Bespoke Intervention 0% £0 £0 Local Business Insert Bespoke Intervention 0% £0 £0 Local Business Insert Bespoke Intervention 0% £0 £0 Local Business Insert Bespoke Intervention 0% £0 £0 Local Business LB Bespoke Interventions Total £0 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 Local Business Local Business Interventions Total £1,204,000 32% £95,800 £361,474 £692,780 £1,150,054 £10,000 £85,800 £28,769 £332,705 £142,431 £550,349 £1,150,054 People & Skills S31: Employment support for economically inactive people £254,720 7% £36,630 £76,818 £123,291 £236,739 £0 £36,630 £0 £76,818 £0 £123,291 £236,739 People & Skills S32: Courses including basic skills for those not economically inactive 0% £0 £0 People & Skills S33: Enrichment & volunteering activities £620,858 17% £132,167 £115,116 £346,602 £593,885 £15,940 £116,227 £12,708 £102,408 £12,808 £333,794 £593,885 People & Skills S34: Increase levels of digital inclusion, essential digital skills 0% £0 £0 People & Skills S35: Employability programmes & advice - No One Left Behind agenda etc £452,597 12% £71,692 £84,938 £277,985 £434,615 £0 £71,692 £0 £84,938 £0 £277,985 £434,615 People & Skills S36: Local areas to fund local skills needs 0% £0 £0 People & Skills S37: Green skills courses 0% £0 £0 People & Skills S38: Support local digital skills 0% £0 £0 People & Skills S39: Education & skills targeting the vulnerable leaving school 0% £0 £0 People & Skills S40: Support for community learning & development 0% £0 £0 People & Skills S41: New partnership & project-based entrepreneurial learning 0% £0 £0 People & Skills Total for 'On-menu' Interventions £1,328,175 35% £240,489 £276,872 £747,878 £1,265,239 £15,940 £224,549 £12,708 £264,164 £12,808 £735,070 £1,265,239 People & Skills Insert Bespoke Intervention 0% £0 £0 People & Skills Insert Bespoke Intervention 0% £0 £0 People & Skills Insert Bespoke Intervention 0% £0 £0 People & Skills Insert Bespoke Intervention 0% £0 £0 People & Skills Insert Bespoke Intervention 0% £0 £0 People & Skills P&S Bespoke Interventions Total £0 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 People & Skills People & Skills Intervention Total £1,328,175 35% £240,489 £276,872 £747,878 £1,265,239 £15,940 £224,549 £12,708 £264,164 £12,808 £735,070 £1,265,239 Multiply S42: Courses designed to increase confidence with numbers 0% £0 £0 Multiply S43: Courses for parents wanting to increase numeracy skills 0% £0 £0 Multiply S44: Courses for prisoners, those recently released or on temporary licence 0% £0 £0 Multiply S45: Courses aimed at encouraging people to upskill to access jobs/careers 0% £0 £0 Multiply S46: Additional relevant maths modules in vocational courses 0% £0 £0 Multiply S47: Innovative programmes delivered with employers 0% £0 £0 Multiply S48: Intensive& flexible courses targetted at those without Level 5 maths 0% £0 £0 Multiply S49: Courses designed to help people use numeracy to manage money 0% £0 £0 Multiply S50: Courses for 19s or over leaving or just left the care system 0% £0 £0 Multiply S51: Provision developed in partnership with community organisations 0% £0 £0 Multiply Total for 'On-menu' Interventions £0 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 Multiply Insert Bespoke Intervention 0% £0 £0 Multiply Insert Bespoke Intervention 0% £0 £0 Multiply Insert Bespoke Intervention 0% £0 £0 Multiply Insert Bespoke Intervention 0% £0 £0 Multiply Insert Bespoke Intervention 0% £0 £0 Multiply Multiply Bespoke Interventions Total £0 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 Multiply Multiply Interventions Total £0 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £3,750,124 100% £433,289 £866,580 £2,342,436 £3,642,305 £45,940 £385,349 £113,836 £752,744 £421,142 £1,849,294 £3,568,305Allocation Totals UKSPF Allocation Annual Expenditure UKSPF Allocation Capital/Revenue Split (£) The table below should be completed by intervention. Enter the amount of the UKSPF allocation you are assigning to each intervention in column C then provide an annual expenditure profile within columns E to G for each Financial Year. Capital and revenue amounts (£) should be entered for each intervention by financial year in columns I to N (please see minimum capital % for each financial year in the guidance to support your calculations). Interventions must be completed by March 2025 as detailed in Section 7 of the Prospectus. Table B - Expenditure Profile
Page 3
Communities & Place C&P Bespoke C&P Totals Local Businesses LB Bespoke LB Totals People & Skills P&S Bespoke P&S Totals Multiply Multiply Bespoke Multiply Totals £ Fund Total % Fund Total Cap% Rev% Cap% Rev% Cap% Rev% Cap% Rev% 1 £97,000 £0 £97,000 £95,800 £0 £95,800 £240,489 £0 £240,489 £0 £0 £0 £433,289 12% 20.62% 77.32% 10.44% 89.56% 6.63% 93.37% 10.60% 88.94% 2 £228,234 £0 £228,234 £361,474 £0 £361,474 £276,872 £0 £276,872 £0 £0 £0 £866,580 24% 31.70% 68.30% 7.96% 92.04% 4.59% 95.41% 13.14% 86.86% 3 £901,778 £0 £901,778 £692,780 £0 £692,780 £747,878 £0 £747,878 £0 £0 £0 £2,342,436 64% 29.49% 62.53% 20.56% 79.44% 1.71% 98.29% 17.98% 78.95% £3,642,305 100% For Internal Use Only LB Revenue/Capital P&S Revenue/Capital Total Revenue/Capital £1,265,239 £0 Excluding Multiply 2023/24 2024/25 IP Totals £1,227,012 £1,150,054 Funding Period: 2022/23 Allocation Summary UKSPF Allocation Total Expenditure by Investment Priority C&P Revenue/Capital Table C - Allocation Summary