Indzara - Simple and Effective Templates | Project Management tool - Capacity Planning Template - Excel @indzara | Uploaded 10 months ago | Updated October 03 2023
Simplify Project Planning using this Microsoft Excel template.
Download: https://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
Simplify Project Planning using this Microsoft Excel template.
Download: https://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