Ruth Canham-James

OTJ Hours Calculation for Part Time

Edited

Hello,

I have a really straightforward calculation for increasing minimum duration for Part Time Apprentices, and an easy calculation for working out OTJ taking into account statutory 28 days leave, but I'm struggling with working out the minimum OTJ for PT. The guidance just says;

P46 When calculating the required amount of off-the-job training, the apprentice’s statutory leave entitlement must be deducted. Employees who work a 5-day week receive at least 28 days paid annual holiday (this is the statutory leave entitlement referred to in this paragraph and is the equivalent of 5.6 weeks of holiday). You must pro-rata this for part time workers.

Pro-rata how? We have an apprentice that does 21 hours a week over 4 days. Do we assume 80% as she works 4 days out of 5, or 70% as that’s the percentage of the full time minimum of 30?

 

Hours a week = 21

Days a week = 4

Hours a day = 5.25

Duration in weeks = 78

Days worked = 312

Hours worked = 1,638

Statutory holiday if full time = 42

Statutory holiday pro rata at 80% = 33.6

Statutory holiday pro rata at 70% = 29.4

 

312 – 33.6 = 278.4

312 – 29.4 = 282.6

 

278.4 x 5.25 = 1,461.6

282.6 x 5.25 = 1,483.65

 

1,461.6 / 5 = 292.32

1,483.65 / 5 = 296.73

 

I'm really struggling to get my head around this one.

Replies

No one has replied to this post.


Steveh

Cripes...

My spreadsheet does it as [duration in weeks]/52*5.6 rather than thinking about how many days a week they work... So would be 8.4 weeks for a 78 week duration.

So my calc would be:

([duration in weeks] - [leave in weeks]) x ([hours per week] x 0.2)

(78-8.4) x (21 x 0.2) = 292.32

 

 

(Edited)

Martin West

The calculation for the holiday entitlement is in hours and you deduct this from the total hours, 20% of this is the minimum OTJ hours required.

holiday entitlement= Statutory Annual Leave Entitlement (Wks)* Apprentice normal working hours per week (Hrs) *(Weeks On Programme (Wks) (Duration)/52)

Total hrs less holiday entitlement 176=1461 hrs x 20% = 292.3

You will note the holiday entitlement calculation does not include the number of days they work but it is pro rata already as the days/Wk they work is derived.

HTH

(Edited)

Ruth Canham-James

Thanks Martin West and Steveh, that does make sense. I wish they'd just say that explicitly in the rules rather than just "pro-rata". The thing we've discovered in all this is that average weekly hours needs recording in our data. Our software doesn't have a place for this, as it's not an ILR field, but it's critical for getting calculations right. It's especially important for term time only, who always end up being part time. We still have to calculate the average weekly hours manually for TTO, but that's straightforward.