Project Management tool - Capacity Planning Template - Excel

preview_player
Показать описание
Simplify Project Planning using this Microsoft Excel template.

00:00 Introduction to capacity planning & its objectives
00:44 Defining Settings for our project planning
01:37 Entering resource availability
02:38 Entering vacation / time off and Overtime
03:10 Entering Tasks (Demand) and assign to resource
04:20 How to identify gaps in planning and address them?
06:14 Dashboard - Assignment and Utilization metrics/KPIs
08:20 What if role/resource has deficit/surplus?
09:46 Project planning calendar
12:00 Project view (Gantt chart)
13:18 Resource View (Gantt chart)
14:08 Recap & Conclusion

#projectplanning #capacity #capacityplanning #projectmanagement #excel #template #utilization #assignment #tasks #demand
Рекомендации по теме
Комментарии
Автор

Is this template able to use man days instead of man hours?

vanniegarcia
Автор

this looks great but the download page doesnt seem to work

bernardtakala
Автор

What if the project end date gets extended? I may not want to change the projected end date. But I want to account for any hours spent past the due date. How could I manage that in this sheet?

tracies
Автор

Hi. How can we update the Calendar view so it starts 1/1/2024?

davidhunter