Paul Neville

Calculating remaining funding

Created

Hi,

I've been asked by a provider to give details of the remaining potential earned cash by using the Main Occupancy report.

To calculate the remaining funding, could I use total of the column "Aim Value" minus the total of "Total earned cash"?

And to calculate the remaining achievement money to earn, can I use "Achievement element (potential or actual earned cash)" minus "Total aim achievement earned cash"?

Or are the any extra steps I should be taking?

Thanks

Paul

Replies

No one has replied to this post.


Kelly Knights

Is this apps or AEB funding ?

Paul Neville

Hi Kelly,

I'm not sure what those mean. I work for a local authority where a couple of external providers send an ILR to me, and we add this to the in house information. I then submit this to the ESFA.

If that doesn't help, can you give me some more info on what apps and AEB refers to?

Thanks

Paul

Kelly Knights

Apps: Apprenticeships

AEB: Adult Education Budget

Are they on your ILR or is your organisation a subcontractor?

(Edited)

Paul Neville

Thanks Kelly - it's Adult Education Budget.

The subcontractor sends in an ILR which I then add to our in house one and another subcontractor. I've downloaded reports and isolated the correct subcontractors learners within the main occupancy report. My question is then how to calculate the remaining potential funding they could get from current learners, as they don't want to go over budget.

Kelly Knights

Hi Paul,

So you could calculate the way you suggested of subtracting the total earned from the Aim value. However the aim value is worked on the assumption the learner is fully funded, if any are co-funded (meaning you only receive around 50% of the full funding) that wont be accounted for in that amount. You're need to look for the value in the 'Non-public-funded contribution' column and subtract that from the unit price, this will give you the expected co-funded value

Check the Learning delivery funding and monitoring type - full or co funding indicator' column and this will tell you if they are co-funded/fully funded, 1 is for fully funded and 2 for co-funded.

Bear in mind, this all only works if their planned end is in 21/22. If they are due to complete in 22/23 you're need to work out the spilt across years