Manpower Leveling (Plan Vs Actual Vs Forecast) Format

Farjad Hasan Project Controls & Risk Manager| Bin Quraya Company Ltd. Saudi Arabia

Hi all

I looking to consolidate manpower for all the projects, can anyone share the format which can reflect trade wise manpower with plan vs actual vs forecast.?

Posted: Aug 27, 2022 1:40 AM

Sort By:

Sergio Luis Conte Helping to create solutions for everyone| Worldwide based Organizations Buenos Aires, Argentina

I think this comment will not help you but we are using a combination between MS Project and MS Azure DevOps then we obtain this data from the tools including the detail for each person. As you know, it is not "magic". We need to work with availability, capacity and load for each ones.

...

1 reply by Farjad Hasan

Aug 28, 2022 6:46 AM

Farjad Hasan

...

Thanks Sergio

Posted: Aug 27, 2022 6:59 AM (Updated by author: Aug 27, 2022 6:59 AM)

Farjad Hasan Project Controls & Risk Manager| Bin Quraya Company Ltd. Saudi Arabia

Aug 27, 2022 6:59 AM

Replying to Sergio Luis Conte

...

Thanks Sergio

Posted: Aug 28, 2022 6:46 AM

Pravin Kumar Shrivastava Associate Vice President| Aithent Technologies Pvt Ltd Gurgaon, Haryana, India

Since you are consolidating the efforts from all projects, it looks like some kind of program effort status. Are you using any tool to track the milestones including the resources? If you are not using any tool then collect the data from each of the projects and do this kind of analysis by using Excel If you are using any Project management tool for all projects, then it will provide the reports.

Posted: Aug 28, 2022 7:50 AM

Abolfazl Yousefi Darestani Manager, Quality and Continuous Improvement| Hörmann-TNR Industrial Doors Newmarket, Ontario, Canada

It depends on your current provisions. That is why you likely need more than one tools to gather all required data and info. like what Sergio mentioned.

Posted: Aug 29, 2022 8:49 AM

Stéphane Parent Self Employed / Semi-retired| Leader Maker Prince Edward Island, Canada

Consolidating enterprise resources currently allocated across projects may involve data cleaning. Don't be surprised if resourcers are entered with diffferent names or attributes in different projects!

As suggested, try to do the consolidation in your portfolio project management tool. That way it will be easier to cascade the cleaned up resources down to the projects. It will also make it easier for new projects to start with the correct resources.

Posted: Aug 29, 2022 9:40 AM (Updated by author: Aug 29, 2022 9:41 AM)

Keith Novak Tukwila, Wa, United States

Generally, if comparing staffing levels (manpower), planned work, actual performance, and forecast (future expenditures), 2 views are used.

When comparing staffing to plans and actuals, it is a comparison of how many people are available, to the planned utilization and actual hourly expenditure converted to actual heads (people) or equivalent heads (2 people working 50% = 1 equivalent head). This can be done with a sandpile chart combining all the projects with reference lines for staffing levels and total charging for the projects in the organization.

Depending on your tools and data, there will often be lower level views such as by project or by team to provide more resolution to the data.

Forecast is usually financial data. You can convert plans and actuals into $, but total manpower in terms of cost is usually used at top organizational levels. Often that data is closely controlled so the PM would not be part of the discussion among executives. Comparing staffing to planned workload and past performance would be covered earlier in business plan reviews, and then a select few would discuss organizational cashflow later in the reviews.

Posted: Aug 29, 2022 11:18 AM (Updated by author: Aug 29, 2022 11:19 AM)

Please login or join to reply

Manpower Leveling (Plan Vs Actual Vs Forecast) Format

Sponsors

Vendor Events

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

Newsletters