Monthly capacity planning

Resource Management

Anonymous

In our company, we are planning the manhours for the current as well as future projects in Excel worksheet. Is it the best way to do that. Are there any other ways to do this job.

Currently, the manhours planning for next month is done on every 3rd week of current month by putting the done manhours from mid of previous month to mid of current month.

Also, the manhour utilization of the current month is calculated w.r.t to consumed hours for mid of previous and mid of current month. Is it the correct way.
I think it is not , because we are not able to analyse the planned vs consumed manhours for every month and then forecast how can we fill the gap if the difference between the two is huge.

Please help in understanding.

Posted: Dec 12, 2018 1:34 AM

Sort By:

< 1 2 >

Anonymous

Dec 12, 2018 10:27 AM

Replying to Kevin Gardner

...

It depends on how well you manage your way around excel. The only reason to work with a different program is if it is more user friendly to you. If you are struggling to manage your manhours efficiently through excel then it would be beneficial to do a quick internet search on other scheduling management software. Look at reviews and analyze how other users' experience might relate to your current goals

Thank you for suggestions.

Posted: Dec 13, 2018 11:14 PM

Ajay Dixit Sr. Project Manager| Excelsoft Technologies Pvt. Ltd. Bangalore, Karnataka, India

Well, you need to use an application for managing this e.g. TFS, JIRA, MS Project, etc. With Excelsheet it is cumbersome but can be achieved. Beauty of other apps is that it is centralized server where data will be hosted and you can access anything from there any time. Create tasks, assign to users, ask them to mark complete (or any other status, whichever is applicable), enter hours worked etc. This will give you all the tasks and the actual time spent on every task then you can take your standard rates, costing, and expenditures to perform the other calculations and generate reports.

Posted: Dec 14, 2018 4:41 AM

< 1 2 >

Please login or join to reply

Monthly capacity planning

Sponsors

Vendor Events

Guessing is not a strategy: How to build decision velocity with AI and real-time data

Newsletters