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 utilization in %.
Category I work Mandays in the month for 31 days 286 mandays.
Category II work Mandays in the month for 27 days (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 supposed to deploy for 27 days (Sundays not working).
I request to calculate manpower utilization in %. The result may be in Excel sheets.
M. Srinivas
srisu2412@rediffmail.com
From India, Hyderabad
I will give one example. Please calculate manpower utilization in %.
Category I work Mandays in the month for 31 days 286 mandays.
Category II work Mandays in the month for 27 days (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 supposed to deploy for 27 days (Sundays not working).
I request to calculate manpower utilization in %. The result may be in Excel sheets.
M. Srinivas
srisu2412@rediffmail.com
From India, Hyderabad
No. Employee Count Employee Work Days Mandays Manager/Supervisor Other Employees Regular Workers 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
Ensure there is a single line break between the paragraphs.
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
Ensure there is a single line break between the paragraphs.
From India, Shimla
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.