Calculate the balance for each leave type as of the following dates if the DOJ is 31-03-2016, considering no leave has been taken, and all leaves are carried forward. Please provide the calculations in an Excel sheet along with the final balances.
Leave Type:
- Casual Leave
- Sick Leave
- Earned Leave
Annual Allotment:
- Casual Leave: 24
- Sick Leave: 18
- Earned Leave: 24
Pro-rata:
- Casual Leave: Yes
- Sick Leave: Yes
- Earned Leave: Yes
From:
- Casual Leave: DOJ
- Sick Leave: DOJ
- Earned Leave: DOJ
Accrual:
- Casual Leave: Quarterly
- Sick Leave: Monthly
- Earned Leave: Bi-annually
From:
- Casual Leave: Beginning of quarter
- Sick Leave: End of month
- Earned Leave: Beginning of half-year
Leave Cycle:
- Casual Leave: Financial year
- Sick Leave: Financial year
- Earned Leave: Calendar year
Date:
- Balance - C/L
- Balance - S/L
- Balance - E/L
7/8/2017
25-12-2017
16-01-2018
5/5/2018
12/6/2018
19-07-2018
15-03-2019
From India, Bangalore
Acknowledge(0)
Amend(0)
Leave Type:
- Casual Leave
- Sick Leave
- Earned Leave
Annual Allotment:
- Casual Leave: 24
- Sick Leave: 18
- Earned Leave: 24
Pro-rata:
- Casual Leave: Yes
- Sick Leave: Yes
- Earned Leave: Yes
From:
- Casual Leave: DOJ
- Sick Leave: DOJ
- Earned Leave: DOJ
Accrual:
- Casual Leave: Quarterly
- Sick Leave: Monthly
- Earned Leave: Bi-annually
From:
- Casual Leave: Beginning of quarter
- Sick Leave: End of month
- Earned Leave: Beginning of half-year
Leave Cycle:
- Casual Leave: Financial year
- Sick Leave: Financial year
- Earned Leave: Calendar year
Date:
- Balance - C/L
- Balance - S/L
- Balance - E/L
7/8/2017
25-12-2017
16-01-2018
5/5/2018
12/6/2018
19-07-2018
15-03-2019
From India, Bangalore
Acknowledge(0)Amend(0)
Can someone help me with the calculations mentioned in the above thread.
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
I need an answer for this problem. Calculate the balance for each leave type on the following dates if the DOJ is 31-03-2016, considering he has not taken any leave and all leaves are carried forward. Please share the calculations in an Excel sheet along with the final balances.
Leave Type
Annual Allotment Pro-rata From Accrual
From Leave Cycle Date 07-08-2017 25-12-2017 16-01-2018 05-05-2018 12-06-2018 19-07-2018 15-03-2019
Casual Leave
24
Yes
DOJ Quarterly Beginning of quarter Financial Year Balance - C/L
Sick Leave
18
Yes
DOJ Monthly End of month Financial Year Balance - S/L
Earned Leave
From India
Acknowledge(0)Amend(0)
Leave Type
Annual Allotment Pro-rata From Accrual
From Leave Cycle Date 07-08-2017 25-12-2017 16-01-2018 05-05-2018 12-06-2018 19-07-2018 15-03-2019
Casual Leave
24
Yes
DOJ Quarterly Beginning of quarter Financial Year Balance - C/L
Sick Leave
18
Yes
DOJ Monthly End of month Financial Year Balance - S/L
Earned Leave
From India
Acknowledge(0)Amend(0)Gathering data for an AI comment.... Sending emails to relevant members...
Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
LEAVE ENCASHMENT NOT INCLUDED IN WAGES FOR P. F. CALCULATION.pdf
Why did this talented employee leave.doc
MASTER- LEAVE sheet.xls