CASE STUDY

 • 

September 26, 2023

October 25, 2023

Spend Data Analysis: Teignbridge District Council

Helping three councils to analyse their unstructured financial data to optimise spend, drive collaboration and measure sustainability performance

Local Government
Commercial, Spend & Impact

Challenge

We partnered with Ignite Procurement - our partner for spend management and intelligence - to conduct a rapid spend data discovery to clean, analyse and enrich disparate financial data across the councils to build a clear picture to inform decisions. We analysed a wide range of factors, like categories of spend, supplier consolidation, opportunities for joining up across the council, levels of local spend, and GHG emissions associated with spend and contracts. We did this by cleaning raw data taken from the council financial systems, and enriching them with a wide range of different datasets within the Ignite platform.

Approach

We partnered with Ignite Procurement - our partner for spend management and intelligence - to conduct a rapid spend data discovery to clean, analyse and enrich disparate financial data across the councils to build a clear picture to inform decisions. We analysed a wide range of factors, like categories of spend, supplier consolidation, opportunities for joining up across the council, levels of local spend, and GHG emissions associated with spend and contracts. We did this by cleaning raw data taken from the council financial systems, and enriching them with a wide range of different datasets within the Ignite platform.

Impact

We were able to help the councils to take their unstructured data, and turn it into powerful insights to inform decision-making. This includes:

  • Identifying opportunities for consolidating spend in the tail across more than 4000 suppliers and to the tune of tens of millions of pounds.
  • Identified specific contracts and vendors where the three councils could explore joint procurement or services.
  • Established a comprehensive carbon footprint baseline covering £138m of spend, allowing for emissions reduction target setting.
  • Showed that some spend across current contracts was going to high-risk suppliers, enabling targeted risk mitigation.
  • Uncovered that 66% of spend was with SMEs, highlighting strong local performance and opportunities to further social value goals.

Reach out to the team

Photo by the author

Johnny Hugill

Co-Managing Director

Explore more insights

Stay in the loop!

Sign up to our monthly newsletter to get a snapshot of PUBLIC’s impact across the public sector, thought-leadership from our experts, and opportunities to get involved!