Rank: New forum user
|
Morning, could somebody please urgently assist me in the calculation for MAT's? I have been searching all over the web for an easy to understand method for working out RIDDOR and MAT's.
Thanks,
|
|
|
|
Rank: Super forum user
|
Hallam,
I'll try. Remember that MATs are a way of trying to smooth out month on month fluctuations.
On 1st Jan the MAT is the total of the past 12 months i.e. Jan to Dec of the previous year. At the end of Jan you deduct the total for Jan of the previous year and add the total for the month of Jan that has just finished. You still have a total of 12 monthly figures comprising Feb to Dec of previous year plus Jan of this year.
At the end of Feb you deduct the Feb figure from the previous year and add in the total for Feb of this year. And so on....
Hope this helps, Phil
|
|
|
|
Rank: New forum user
|
Thanks Phil,
The client has asked for the MAT for AFR's. How is this calculated? Do you do the same ie total for 12 months then go through each month and calculate RIDDOR/hours x 100,000 etc?
Thanks for your help with this.
|
|
|
|
Rank: Super forum user
|
Now there's a question... I'm not 100% sure .
However, the general rule is that you can't add up indices, percentages etc. So I woudl guess that you will need to add up the two componeents separately. Thus generate a MAT for reportable accidents, then a MAT for the manhours and divide one by the other to calculate your AFR.
Perhaps someone else will confirm..
Phil
|
|
|
|
Rank: Forum user
|
MAT for accident frequency rate is basically the average accident rate over the last 52 weeks. You can put together your own spread sheet to calculate this for you. is it all accidents? RIDDOR ones? stats are very often what you want or your boss want them to look like.
|
|
|
|
Rank: Super forum user
|
However, Phil is right, the average annual rate isn't the same as the average of the monthly rates over the year. To find the average of X/Y, you have to divide the total X by the total Y over the whole period. So in this case the number of accidents over the twelve months, by the number of hours worked (and stick in whatever multipliers you are using). A spreadsheet would still be the easiest way to do it though - add up the figures for the monthly periods, then divide them.
|
|
|
|
Rank: Super forum user
|
For any pedants, I know I worded that a bit wrong :-)
The point I was trying to get over is that the totalling has to be done before the dividing.
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.