Calculating remaining funding

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

Apps: Apprenticeships

AEB: Adult Education Budget

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

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.

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