Project planner excel download how to#

Keep your stakeholders happy and ensure you don’t miss out on potential business by predicting demand accurately and adjusting your delivery in real-time to match it. If you have extra capacity, you might want to add another project to make the most of your resources.Ĥ Reasons Why Capacity Planning is importantĬapacity planning is advantageous for everyone involved in the project, including the project manager, the project team, and the business. If your team is at capacity and unable to take on any additional work, then you will need to find more people as soon as possible to help complete the project.

Project planner excel download how to#

Look at the capacity gap that was already found and figure out how to use the current and available capacity in the best way to bring things back into balance. Measure how your current resources stack up against the expected demand based on how much capacity a project needs. If a person can work an average of 30 hours per week and is currently engaged in projects, you can determine how many hours they can work in a week by deducting their current workload from the average. Make sure your staff has the ability to manage the added workload before adding additional projects to avoid burnout. Determine the current team’s resource capacity.

Determine the necessary capacity.ĭetermine the amount of capacity you’ll need to complete the task you planned in the previous step based on your initial assumptions, as shown in the following template.

This estimate will help you figure out how much capacity you need to finish the project and gives you a chance to compare it to your current capacity (as shown in the next template). If you are aware of an upcoming project, make a realistic estimate of how much work it will require. The capacity planning process may vary from one organization to the next, but there are a few basic steps that will always happen.