Uploaded August 2023 | Updated September 2026, 2 weeks ago

---

Simplify Project Planning using this Microsoft Excel template.
Download: indzara.com/product/project-management-excel-templates/resource-capacity-planner-lite-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