Dear Pankaj, We have devised a simple worksheet that categorizes the work performed by employees into daily, weekly, monthly, quarterly, half-yearly, and annual.
We advise employees to list their activities and key in the time in the Excel sheet appended. This gives the time the employee spends each day. The available time for a person in a day is 60 minutes x 8 hours = 480 minutes. If the work content is equivalent to or less than 450 minutes in a day, then recruitment is not needed. However, if it exceeds 450 minutes and is almost 50-60% higher than 450 minutes, then recruitment may be needed. Even in such instances, we can track employees who perform work below 300 minutes and reassign activities for work balancing.
Yet another feature that can be utilized may be Mean Time Between Leave (MTBL). The MTBL is the frequency at which employees avail leave. For example, in January, the number of working days is 25 days, and the employee has availed leave on 3 different days (do not consider the duration of leave), only consider the number of times he has availed leave. Then the MTBL will be 25/3 = 8.33. If this value is less month after month, then it indicates that the employee avails leave quite frequently. It may be an indicator that he has less work. On the other hand, if the value is high month after month, it could indicate that he is unable to avail leave due to his work pressure. Though MTBL is not a direct measure, it may give you a clue of the work content in the department. If the absenteeism % (Number of days leave availed during the period/ the working days x 100) is high and the MTBL is low, then it may be an indicator that the work content for the employee is less. A comparison of the work content sheet indicated in the previous paragraph will also shed some light.
Trust this information will be useful.
Regards, M.V. Kannan