PRODUCT

Project Manager Excel Template

PURPOSE

The purpose of the template is to plan and manage a project effectively and efficiently from start to finish. The template takes as input the scope of work and builds out the schedule. It incorporates cost management and resource management all into one solution.

  • To achieve our goal of simple and effective project management, the template presents a comprehensive approach by incorporating planning and management in one application. We can set a baseline plan and then as we update actual work performed, it allows us to compare current plan vs baseline at any time.
  • It includes an automatic scheduling engine. The engine takes as input the list of tasks, work required for each task, assignment of resource to each task and resource availability. Using that, it calculates which resource works on which task for how many hours on a given day. The template builds 2 schedules, one for baseline plan and one for current plan. These schedules work as foundation for all the calculations of relevant metrics throughout the template.
  • The reporting is very comprehensive and interactive, including a customizable Gantt chart.
  • The template has actionable triggers and visual feedback that enable the user take actions to improve the management of project.

REQUIREMENTS

Microsoft Excel – Compatible versions are

  • Windows: Microsoft Excel 2010 and above
  • Mac: Microsoft Excel 2011 and above

PRODUCT TOUR VIDEO

FEATURES

  • Plan and Manage
    • Create baseline plan and lock
    • Track actual progress
    • Compare Plan Vs Baseline & Actual Vs Plan
  • Automatic Scheduling
    • Automatically creates schedule
    • Schedule updates with actual progress
  • Automated Reporting
    • Project report with relevant metrics
    • Detailed Task level report
    • Resource Summary Report
    • Customizable Gantt Chart
    • Cost calculation (Earned Value, Planned Value)
    • Burn Down (Hours) Chart
  • Resource Management
    • Supports flexible resource availability
    • Supports vacation/overtime
    • Calculates Resource Utilization Rates
  • Smart Actionable Data
    • Identify tasks that will not complete
    • Identify tasks that are behind schedule
    • Identify resources underutilized
  • Practical Functionality
    • Up to 2 Predecessors per task
    • Prioritize tasks
    • Milestones
    • Supports company Holidays
    • Ready to export as PDF

 

Read more about the Project Management Framework used

HIGHLIGHTS

PLAN AND MANAGE

The template is a comprehensive solution which we can use to plan our project ahead of project start and then manage it to completion effectively and efficiently. We can create a baseline plan and lock it before project work begins. After the project work starts, as we input actual work performed, the current plan is updated instantly. We can then evaluate if the current plan has deviated from the baseline. We can also compare actual progress with baseline plan to identify if the project (or any task) is on track, ahead or late.

Baseline Plan Vs Current Plan
Baseline Plan Vs Current Plan

 

AUTOMATIC SCHEDULING

One of the key benefits of the template is that it will automatically create the schedule. Once provided inputs on resources (standard availability, vacation/overtime and company holidays) and tasks (hours required, resource assignment, start date constraint, predecessors), the scheduling engine will crunch through the inputs and create a schedule that specifies who works for how many hours on what task on a given day. This greatly saves time compared to a person (in PM role) manually calculating this level of detail. (Article on Automatic Scheduling)

Project Management - Automatic Scheduling Engine
Project Management – Automatic Scheduling Engine

 

Video on Automatic Scheduling (YouTube)

 

The template creates two schedules, one for baseline plan and one for current plan. The current plan’s schedule updates constantly with any changes in the actual work performed. These schedules drive all the reporting (which we will discuss further below).

In addition, a 7-day schedule is also displayed at a task level.

Project Manager Excel Template - Task Schedule
Project Manager Excel Template – Task Schedule
Project Manager Excel Template - Schedule Legend
Project Manager Excel Template – Schedule Legend

 

This also allows us to clearly see if there are days when a resource is unutilized or underutilized.

 

AUTOMATED REPORTING

Another place where we will save a lot of time is calculation of all the relevant metrics and reports. The template comes with Project Report, Task Report, Resource Report and Gantt Chart.

Project report

Relevant information about the project plans are calculated for us. Status of project, start and finish dates, hours scheduled, cost and resource utilization rate are listed for both baseline and current plans. In addition, we can also see the comparison of Current plan vs Baseline Plan.

Project Manager Excel Template - Plan Summary
Project Manager Excel Template – Plan Summary

 

We can also view the actual progress of the project as of the status date (which can be modified).

Project Report - Actual
Project Report – Actual

 

BURN DOWN CHART

Project Manager Excel Template - Burn Down Chart
Project Manager Excel Template – Burn Down Chart

 

COST MANAGEMENT (EARNED VALUE, PLANNED VALUE, COST PERFORMANCE INDEX)

Project Manager Excel Template - Cost Management
Project Manager Excel Template – Cost Management

 

TASK REPORT

While the Project Report summarizes the metrics at the project level, the Task Report provides the details for each task. This is immensely helpful to identify if there are any gaps or delays. The report shows the metrics for Baseline Plan, Current Plan and Actual separately.

Task Report - Baseline Plan
Task Report – Baseline Plan

 

Task Report - Current Plan
Task Report – Current Plan

 

Task Report - Actual
Task Report – Actual

RESOURCE REPORT

Resource report summarizes the performance measures for each resource. Once again, we see the measures broken down by Baseline Plan, Current Plan, and Actual.

Resource Report - Baseline Plan
Resource Report – Baseline Plan

 

Resource Report - Current Plan
Resource Report – Current Plan

 

Resource Report - Actual
Resource Report – Actual

 

You can also enter utilization rate threshold and the resources with utilization rates under the threshold will be highlighted immediately. This allows you to identify underutilized resources easily.

 

GANTT CHART

Gantt charts are commonly used to visualize project timelines. Here, we can customize the Gantt chart in many ways.

  • Period can be set as daily/weekly/ monthly
  • 4 views: Baseline plan, Current Plan, Actual, Current Plan Vs Baseline.
  • Filter: All Tasks/Tasks specific to one resource/Only milestones.
  • Gantt Chart displays 52 periods and we can modify the start date.
Gantt Chart Options
Gantt Chart Options

 

Gantt Chart - Compare Current Plan Vs Baseline
Gantt Chart – Compare Current Plan Vs Baseline

By default, the Gantt Chart displays 30 tasks. We can choose to scroll to another set of 30 tasks by entering a number (as shown below).

Gantt Chart - Scroll for tasks
Gantt Chart – Scroll for tasks

 

Learn more about Gantt Charts’ features and options

 

SMART ACTIONABLE DATA

There are calculations and visual feedback throughout the template that enable us to take action to improve our project.

  • As we saw already on the Task report, it is easy to identify tasks that will not complete and tasks that are behind schedule.
  • On the Task Schedule, we can visually see the unavailability of resource assigned to task.
  • Cost Performance Index calculation flags whether we are under planned cost or over planned cost.
  • Project Report displays the status of the project indicating whether the project will complete or not. It also displays a comparison of current plan vs baseline plan to make sure that we are aware of the deviations if any.
  • On the Resource report, it is easy to identify underutilized resources. We also can see the unutilized time for each resource.
Resource Report - Unutilized Time
Resource Report – Unutilized Time

 

PRACTICAL FUNCTIONALITY

FLEXIBLE RESOURCE AVAILABILITY

Project Manager Excel Template - Settings - Resources
Project Manager Excel Template – Settings – Resources

 

VACATION/OVERTIME

Project Manager Excel Template - Settings - Vacation/Overtime
Project Manager Excel Template – Settings – Vacation/Overtime

 

HOLIDAYS

Holidays
Holidays

 

PREDECESSORS AND START DATE CONSTRAINTS

Project Manager Excel Template – Tasks - Optional Fields
Project Manager Excel Template – Tasks – Optional Fields

 

PRIORITIZE TASKS AND SET MILESTONES

Prioritize Tasks and Set Milestones
Prioritize Tasks and Set Milestones

 

Project Report - Milestones
Project Report – Milestones

 

READY TO PRINT/ EXPORT AS PDF

The reports are set to be print-ready. We can print or export as PDF (Excel’s inbuilt export feature).

 

BUY

US$45 US$25

CUSTOMER RATING

100% SATISFACTION

If you are not satisfied with the product, please e-mail support@indzara.com and we will issue a full refund.

FILE DELIVERY PROCESS

You will be able to download the file immediately upon payment. You will also receive an e-mail immediately with the download link.

FREE UPGRADES

All future updates and upgrades are absolutely free.

LICENSE TERMS

PRODUCT SUPPORT

PRODUCT SUPPORT

OFFER

Offer Details

Special Offer - Buy One, Write Review, Get One Free

ADD A REVIEW

1 2 3 4 5

US$45 US$25

You may also like…

  • PM Toolkit - Product Logo

    Project Management Toolkit Excel Templates

    Rated 5.00 out of 5
    Sale! US$200 US$100
    Add to cart