Hr & Administration Specialist
R Devarajan
Human Resources Manager
+7 Others

Thread Started by #Subuzz

Hi !:icon10:
Can anyone help me with manpower planning and budgeting format. I recently joined a new manufacturing company with branches more than 10 branches. I need a reliable format which can help me keep the record of current manpower, future requirement and total payroll cost current and fore casted.
2nd January 2009 From Nepal, Kathmandu
How has the company been doing it untli now ?
is there any historical data available ?
Please post some dummy data in the format you have I'm sure I can come up with something to help.
Also let me know of any specific needs you have
8th January 2009 From India, Mumbai
Dear Subbuz Attached wherewith is teh manpower budgeting file..used for my organisation. Hope it helps :)
28th February 2009 From India, Mumbai

Attached Files
Membership is required for download. Create An Account First
File Type: xls Manpower Planning Sheet.xls (21.0 KB, 28718 views)

hi mani
the excel sheet shows only the additional manpower required and the summarized head count of the each department. You can prepare in the excel sheet department wise strength details based on the approval of the manpower in your organisation.
hope this gives you a very clear picture of the format
R devarajan
1st March 2009 From India, Madras
Hi. I hava joind a company which newly formed. i am heading a Department. now i have to give projection of Manpower requirement for my deptt. can anyone please help me to make the requirement?
12th June 2009 From India, Delhi
Well you need to conduct a workload analysis for your department and on the basis to arrive at the manpower required for your present work load. Then you need to have a look at your department mission/goal for the next year and anticipate (using historical data) on how much work load will increase if you are to achieve your goals. Then conduct again work load analysis to get what staffing you need in ur department. e.g. if u r in a packaging department and you pack 1000 pack a day and on avg one pack takes 1 min. (u have to have this bench mark for all types of work u do such as packing, assembling etc) then total time req. to pack 1000 packs is 1000 min or 16 hours approx. and if ur working hours are 6 hrs/day then u need only 3 persons to complete this assingment daily. similarly if ur goal is to increase this to 2000 packs a day, u will need 6 persons using the same formula. Hopes this helps.
12th June 2009 From Pakistan, Islamabad
I got an assignment in the office to do analysis and design for Manpower budgeting and planning. Im confused whether it is only head counts estimate or financial impact too. If financial impact too, then how ? Plz help me at
22nd June 2009 From Pakistan, Karachi
for MPP you need to analyse your work/production on monthly basis and validated your manpower with process. After that make the requirement on monthly basis and skill basis. accordingly make budget for the same and take monthly expense of the required + available manpower and compare with last data of the same month and volume wise.
25th June 2009 From India, Delhi
I am not able to understand the excel sheet.kindly explain the points like additional,replacement,total headcount and total manpower approved. anima Rani executive Hr
5th February 2010 From India, Faridabad
help, i’ve downloaded the file but when i tried to open it there was an error message : File Corrupted
22nd September 2010 From Indonesia, Surabaya
Hi there Jalil
ofcoure when doing manpower budgeting & Planning the financial implication is most importatnt
How much salaires the organisation is paying for the existing employees (annually)
How much increment they are planning to pay for the existing employees
how much bonuses to be paid
how much annual employee insurance is being paid
How much training is the company going to invest in (to include travel expenses, accomodation,training fees)
this is only for existing Now you do the same as above but estimated for budgted manpower to be recruited
its alot of work and sounds easy but beleive me its not and for the estimated part you try to keep it as realistic as possible
All the above is much easier with comprate companies i.e. companies expecting Return On Investment (ROI) cause the company is generating money
but its not easy for Government organisations as they depend on Government Funds.
22nd September 2010 From Oman, Muscat
Hi friends, Please find the excel which is helpful in manpower planning and budgeting.
13th August 2013 From India, New Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: xls Manpower Planning Budget for all Divisions.xls (130.0 KB, 5775 views)

Can anyone help me with a question that i faced during interview "A marketing manager comes to you with the complete requirement/JD and number of subordinates required by him at different regions " , how HR can contribute through Manpower Planning to cut the number of employees required and satisfy the Marketing manager.......
Please help as i could not answer this .....
13th March 2015
Can any one help out PPT of Manapower budget and vacancy plan
27th March 2017 From India, Hyderabad
Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2017 Cite.Co™