Manpower Planning & Budgeting Format

Hi !

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.

Thanks,

Subuzz

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

Dear Subbuz

Attached wherewith is teh manpower budgeting file..used for my organisation.

Hope it helps

Attached Files

Manpower Planning Sheet.xls (21.0 KB, 1851 views)

Hai,

I Am Trainee Hr, Can U Please Explain The Excel Sheet

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

regard
R devarajan

Dear Rashmi,

Can you please send me the manpower planning & Budgeting format at

Thank you,

please share with me

very truely

sovan lenka

9861263455

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?

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.

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