Hello,

I want to make resource planning for the company ( say 500 people). We execute the projects on task force (projectized) and non task force concept. However, there are more frequent shifting of resource (person) from one project to other (meaning resouces shared). We execute Detail engineering projects.

I face problem in making overall organization resource plan, and finding resource gaps.

could anyone can help me in this? Any specific excel template or any softwares available?

Many thanks,

Girish

P6 is considered the best software for this purpose. Further you need to consider making resource dependent schedules considering availability of key resources govern your project schedule, instead of task dependent schedules. Have a comprehensive production rate analysis ready (key design resources in your case) for your programme development purpose, and utilize the resource balancing capabilities that P6 provides you for conducting various what if case scenarios with minimal effort,when compared to other softwares. 

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------