We use cookies to collect
information about how you use ‘Get help with DfE services’. We use this information to make the
website work as well as possible and improve government services.
You will be able to post, reply and subscribe once DfE approves your account for this community.
Ryan Wiseman
Change of Employer Calculator
Created
None
Hi all,
Would anyone mind sharing their process of when a change of employer happens?
Currently, these types of requests come to our MIS email and we 'manually' work it out by looking at the start date/planned end date/end date (change of employer date) to alongside the TNP.
Which I believe this to be the correct calculation - but my question is does anyone have a spreadsheet that would calculate this for you if you populate the appropriate start date/planned end date/end date (to determine duration) and then the TNP1 and TNP2 to determine the remaining price?
Ideally, I would like to pass this task back to the Apprenticeship team & if I give them a calculator I am confident they will get this right, without I think it would be safer to keep within MIS.
I would also be interested in this. We do a manual calculation too.
We do this by using actual funding received to calculate the residual price, through our MIS system (PICs) and the Apps Monthly Payment reports from Submit Learner Data.
Ryan Wiseman
Change of Employer Calculator
Created
Hi all,
Would anyone mind sharing their process of when a change of employer happens?
Currently, these types of requests come to our MIS email and we 'manually' work it out by looking at the start date/planned end date/end date (change of employer date) to alongside the TNP.
Which as an example:
TNP1 - £5000
TNP2 - £1000
TNP - £6000
Duration - 18 months
Months with 1st employer - 9 months & remaining months 9 months.
£6000 * 0.8 = £4800
£4800/18 = £266.66667
£266.66667*9 = £2400 - Total Funding Received
Residual Price:
TNP3: £2600
TNP4: £1000
Remaining Price - £3600
Which I believe this to be the correct calculation - but my question is does anyone have a spreadsheet that would calculate this for you if you populate the appropriate start date/planned end date/end date (to determine duration) and then the TNP1 and TNP2 to determine the remaining price?
Ideally, I would like to pass this task back to the Apprenticeship team & if I give them a calculator I am confident they will get this right, without I think it would be safer to keep within MIS.
If you do - I would very much appreciate it & my email is rwiseman@sparsholt.ac.uk