Erick Simpson’s Project Manager and Coordinator Capacity Planning and Hiring Calculator helps you determine when to hire your first dedicated, or additional Project Managers and Coordinators based on the number of projects on your calendar and the duration of each project. This effective calculator also takes into account the number of hours available to your project resources to work on projects. It provides you a clear color-coded “over/under” status that tells you if you are understaffed or overstaffed and by how many resources. Never make an untimely hiring decision again with this awesome capacity planning tool.

Instructions:

*Shaded cells are calculated fields – beware of changing them

1. Review/Modify all white cells in the Availability Section
2. Review/Modify all white cells in the Project Forecast Section
3. Review/Modify all white cells in the Project Staffing Section

Over/Under Capacity = Green when properly staffed,

Red when Overstaffed, Blue when Understaffed