The template determines if and when projects will complete given each project's tasks, task duration, resource availability and project priority. The template identifies if the project will complete by due date (if available), resource utilization, opportunities for re-assignment to improve project completions, and hours of work still pending after the planning period is over, so that you can request more resources. The template creates printable project (Gantt chart) and resource schedules, along with a summary report. The following are some of its key features. The template can help in planning up to 25 projects at a time and a total of 150 tasks. Up to 15 resources can be included in planning. Each task is assigned to one and only one resource. A project can have multiple tasks and hence multiple resources.Project Start Dates can be restricted (optional). Project due dates can be input to compute if projects complete on time. Planning period is 60 working days from planning period start date. Only workdays are included (Weekends are not in the plan). Takes into account up to 10 holidays (optional). Planning is done at the granular unit of hours. Resource can be assigned to multiple tasks on the same day. Hours available to work per day (for the duration of the planning period) is customizable for each resource. Projects need to be prioritized and prioritization is followed when resources are assigned. All the tasks within a project inherit project's priority. Each task can have up to two predecessors (dependencies). They can be within project or from other projects. A task can begin only the day after its predecessors have completed. PTOs can be accommodated by creating one separate project with the priority 1 and adding all PTOs as tasks. The template does not have any macros.
Requirements:
Excel 2010
Comments not found