Jenny Rollinson

TTO and P/T hours - calculating extended duration and OTJ hrs

Created

None

Good afternoon, is there a formula for calculating term time only extended duration and planned OTJ hours?  I also have part time hours in this scenario for some learners.  A couple of examples; 

Learner 1 works TTO (39 weeks) and working 22 hours per week

Learner 2 works TTO (39 weeks) and working 38 hours per week

The standard duration for the apprenticeship is 18 months

Would appreciate some guidance

Many thanks

Replies

No one has replied to this post.


Phil Dawe

Hi Jenny,

P51 of funding rules says:

To be eligible for government funding at least 20% of the apprentice’s normal
working hours, over the planned duration of the apprenticeship practical period must
be spent on off-the-job training.

We take this to mean that every 1 in 5 hours should be OTJ.

Although calculating total hours worked in any 18 month period for TTO it is not as simple as:

Weekly hours * 0.2 (OTJ) * 39 weeks * 1.5 (18 month duration)

as you also have to consider Annual Leave entitlement and the Apprenticeship Start Date - an apprenticeship over 18 months that starts in September could contain more 'Term time' weeks than one that starts in May for example.

We look at the employers timetable and manually count the number of 'term-time'/working weeks included within the duration of the apprenticeship adjust for annual leave, check that this meets the overall expected duration for the delivery of the apprenticeship then we do the OTJ calc. Not forgetting to record all the detail of the calculation in the Commitment statement.

Phil

Steve Hewitt

They are an absolute pain! :)

I made a calculator (caveat emptor, no liability accepted etcetc) for TTO that's here https://drive.google.com/file/d/1_Kbfvp9CmKjsiaisE_W9W9FlNATfYni3/view?usp=sharing that might help?

basically you need to stretch their TTO hours out as though they were employed all the time, so your 22 hr/wk learner is 18.5 hr/wk over a whole year...

Jenny Rollinson

Thank you both for your replies - very helpful!  I will give your calculator a go, Steveh!

Having just tried to open the spreadsheet on the link it is saying it is view only - can you let me have editing rights, Steveh so I can enter data in the yellow boxes? Thanks, Jenny

(Edited)

Kay Mellanby

So if I have a learner working 37 hours a week but only 40 weeks a year term time then I would calculate this as 939 hours for a 3 year programme?

Steve Hewitt

Ah, the thing is, 37 hours per week for 40 weeks is still more than 30 hours a week on average (I make it 31.9), so isn't "part time" per se, so no need to calculate anything differently from anyone on a full year contract.

Obviously if this is a starter after 1 August, it's six hours a week regardless if they're not part time so 6hrs x (156weeks-16.8 weeks leave) = 835.2 hours?

(Edited)

Kay Mellanby

Thanks Steven, I suspected this would be the case!