A Resource Planning Tool for a Charity

22. A Resource Planning Tool for a Charity.jpg

The Approach

The charity runs two literacy schemes amongst schools in London and Manchester. It has a range of staff working on the schemes from managers to volunteers, each with a unique salary and working pattern.

The volunteer analyst began by pulling the information together into a spreadsheet, allowing for both unique and average salaries, so that the key information could be extracted easily for reports to the Trustees. A tool was created that could conduct scenario analysis by varying the inputs (schools, pupils, staff). The tool had to be flexible to allow for different staff roles (and associated costs),  but with constraints to ensure there were enough staff to meet the staff to pupil ratio. This tool was used to generate new ideas and ways of working and create a budget plan for 2014/2015 academic year and beyond.

“Resource planning has been a stumbling block for Springboard for years. As a new CEO I know it’s important to enable innovation and growth at Springboard and a key part of that was re-thinking how we plan our services”

The Client

Springboard for Children works to change the effects of underachievement and social exclusion among children in deprived communities.

The Client's Problem

To develop a resource planning tool that can be used to examine different options together with a short report.

The Solution

  • Pulled together the key financial and staff information into one spreadsheet
  • Created a summary of key statistics that updates automatically as resources are adjusted
  • Created a user friendly tool to conduct scenario analysis on various resource options and allows the user to easily compare options

The Benefits

  • The charity was able to get a fresh perspective and benefit from an innovative solution in a short timescale
  • The volunteer enjoyed using her skills to improve processes within a charity that is working to improve the lives of children in deprived communities
  • Staff now have ownership of their planning and we have already generated some interesting new ideas to help more children