No Tags Found!


suhaskhambe
121

Dear All,
we pray to god that no accidents should happen in any factories. no people/ employee suffer due to that. no one dies.
but if unfortunately somebody dies due to accident then???????
i have attached excel sheet for calculating compensation in that case...

From India, Mumbai
Madhu.T.K
4193

Suhas, it is a good initiative. But please note that the minimum compensation for death cases is Rs 120000 and the maximum salary for the purpose of compensation is Rs 8000. Therefore, you have to take 50% of the maximum salary, that is the maximum salary factor will be Rs 4000, ie, 50% of 8000. In your sheet we get less than 120000 when we enter less salary and we are able to enter salary of more than Rs 8000,which should be restricted. Please put both the caps in your excel calculation so that it can be used by HR persons.
Regards,
Madhu.T.K

From India, Kannur
suhaskhambe
121

Dear Madhu Sir, Thanks for your reply. I have ammended the file as per your valuable suggestions. looking for your veiws for any further modifications.
From India, Mumbai
Akhil.Gupta
137

Dear Suhas,

Kindly Cross check the relevant factor as for age 52 it is Rs. 146.20 but your sheet is showing Rs. 166.29.

Completed years of age on the last birthday of the workman immediately preceding the date on which the compensation fell due-



Age Factor

Not more than 16 . . . 228.54

17 . . . . . . 227.49

18 . . . . . . 226.38

19 . . . . . . 225.22

20 . . . . . . 224.00

21 . . . . . . 222.71

22 . . . . . . 221.37

23 . . . . . . 219.95

24 . . . . . . 218.47

25 . . . . . . 216.91

26 . . . . . . 215.28

27 . . . . . . 213.57

28 . . . . . . 211.79

29 . . . . . . 209.92

30 . . . . . . 207.98

31 . . . . . . 205.95

32 . . . . . . 203.85

33 . . . . . . 201.66

34 . . . . . . 199.40

35 . . . . . . 197.06

36 . . . . . . 194.64

37 . . . . . . 192.14

38 . . . . . . 189.56

39 . . . . . . 186.90

40 . . . . . . 184.17

41 . . . . . . 181.37

42 . . . . . . 178.49

43 . . . . . . 175.54

44 . . . . . . 172.52

45 . . . . . . 169.44

46 . . . . . . 166.29

47 . . . . . . 163.07

48 . . . . . . 159.80

49 . . . . . . 156.47

50 . . . . . . 153.09

51 . . . . . . 149.67

52 . . . . . . 146.20

53 . . . . . . 142.68

54 . . . . . . 139.13

55 . . . . . . 135.56

56 . . . . . . 131.95

57 . . . . . . 128.33

58 . . . . . . 124.70

59 . . . . . . 121.05

60 . . . . . . 117.41

61 . . . . . . 113.77

62 . . . . . . 110.14

63 . . . . . . 106.52

64 . . . . . . 102.93

65 or more . . . . .99.37

Subs. by Act 22 of 1984, sec. 7, for Schedule IV (w.e.f. 1-7-1984).

From India, Kota
suhaskhambe
121

Dear AKKI79, first up all thanks for identifying error with the formula. I have rectified the error. Hope this is correct this time. Waiting for your feedback.
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls Compensation for deceased Employee.xls (24.5 KB, 3591 views)

suhaskhambe
121

Hi Dear,
Multiplication factor is based on loss of anticipated income if the person was alive.
This factor is given in Schedule IV as per section 4 of Employee's Compensation Act 1923.
Please read section 4 of the act.

From India, Mumbai
suhaskhambe
121

Dear All, Compensation calculator for all type of Injuries partial disablement, perment disablement and death. Please give your comments.
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls Compensation for permanent, patial disablement and death of Employee_Ammended.xls (55.0 KB, 3030 views)

ashama87
11

Dear all
I am very new to this calculation of compensation in case of deceasd employee so please help me learn by answering some of my questions-
As madhu sir said that the maximum salary for the purpose of compensation is Rs 8000. Therefore, you have to take 50% of the maximum salary, that is the maximum salary factor will be Rs 4000, ie, 50% of 8000,then why the excel sheet salary component is accepting 5000,6000,7000 and 8000 also.
Please clarify.

From India, Ghaziabad
suhaskhambe
121

Dear Excel sheet will accept any figure you enter but it will calculate on basis of 8,000 as maximum salary.(it will auto consider) you can verify by calculating on calculator. it will auto give result as 120000 as minimum compensation.
Try it out. best luck.

From India, Mumbai
swarnalata.rokkam
1

Dear Madhu Sir,
sorry iam sending this query to this thread however it was urgent.
i want some clarification on OT payments under factory act:
1. is it mandatory that OT is payable on Gross with all allowances like Cony Allow, CCA, Washing Allow etc.
2. is it mandatory that OT is payable double on gross
3. If OT is paid double on gross then is it mandatory to pay night allow also.
pl guide.
regards,
Swarnalata

From India, New Delhi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.