Hi,, To calculate mandays, 1.No. of days work in the month Except Weekly off and Paid Holday( declared by company) 2.No. of working days for the month 2.
From India, New Delhi
From India, New Delhi
Dear seniors
I will give one example. Please calculate manpower utilisation in %
Category I work Mandays in month for 31 days 286 mandays
Category II work Mandays in month for 27 (without sundays) 486 mandays
In category I, per day 10 manpower are supposed to deploy for 31 full days
In category II, per day 20 manpower are supploed to deploy for 27 days (sundays not working)
I request to calculate manpower utilisation in %.
The result may in excel sheets.
M Srinivas
From India, Hyderabad
I will give one example. Please calculate manpower utilisation in %
Category I work Mandays in month for 31 days 286 mandays
Category II work Mandays in month for 27 (without sundays) 486 mandays
In category I, per day 10 manpower are supposed to deploy for 31 full days
In category II, per day 20 manpower are supploed to deploy for 27 days (sundays not working)
I request to calculate manpower utilisation in %.
The result may in excel sheets.
M Srinivas
From India, Hyderabad
1 No Of Empolyee Empolyee work Day Mandays Manger/ Supervisor Other Empolyee Regular worker M/F
Apr-13 33 25 7 14 12
May-13 31 27 7 11 13
Jun-13 31 26 7 12 12
Jul-13 33 26 7 13 13
Aug-13 29 26 6 11 12
Sep-13 29 25 6 10 13
Oct-13 28 25 6 11 11
Nov-13 29 24 6 11 12
Dec-13 29 26 6 11 12
Jan-14 25 25 6 10 9
Feb-14 23 24 4 10 9
Mar-14 24 25 4 9 11
From India, Shimla
Apr-13 33 25 7 14 12
May-13 31 27 7 11 13
Jun-13 31 26 7 12 12
Jul-13 33 26 7 13 13
Aug-13 29 26 6 11 12
Sep-13 29 25 6 10 13
Oct-13 28 25 6 11 11
Nov-13 29 24 6 11 12
Dec-13 29 26 6 11 12
Jan-14 25 25 6 10 9
Feb-14 23 24 4 10 9
Mar-14 24 25 4 9 11
From India, Shimla
For calculating total man days of the month of any of the employee/worker is to be considered as total present of the month. R N KHOLA
From India, Delhi
From India, 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.