A Gantt chart is a horizontal bar chart showing the start and end dates of each task within a project. It shows the tasks on the vertical axis and time on the horizontal axis. The tasks are shown sequentially. It can have many other pieces but these are the basic building blocks. Gantt Chart Example 1 Here is a Gantt chart that was created with Microsoft … [Read more...]
How to Create a Gantt Chart in Excel
Believe it or not, gantt charts can be created relatively painlessly in Microsoft Excel. A simple one will take about 10 minutes with only a basic knowledge of Excel, and I'm going to show you how. Step 1: Enter the Task data The first step is to enter your tasks in table form in Excel. The following four pieces of data are the minimum requirement for a gantt chart, so … [Read more...]
Budget at Completion (Earned Value Analysis)
The Budget at Completion (BAC) is a value used in earned value management, a division of project management. It represents the original project budget. For example, if a project has a budget of $10,000, BAC = $10,000 Therefore, there is no other formula or calculation for this metric. The BAC is often compared to the Estimate at Completion (EAC) which … [Read more...]
The Triple Constraint
In project management, like most things in life, there is no free lunch. If you want to finish sooner, you will have to cut the project scope. If you want lower costs, you have to cut expenses. If you want higher quality, you have to pay more. This constant tug of war is called the Triple Constraint, also known as the Project Management Triangle, or the Iron … [Read more...]
10 Gantt Chart Templates: Beautiful, Professional, and Free
Sometimes the easiest way to create a Gantt chart is by starting from a template and customizing it to your project. To that end, we present the following 10 templates, which have been designed to be easily customized to your project. Using only basic Excel skills, you should be able to complete your own Gantt chart in 10 minutes or less. Template 1: Build a … [Read more...]
The Complete Guide to Gantt Charts
A Gantt Chart is to a project manager like a hammer is to a carpenter. It is the project manager's most used tool. It is used to convey the most critical information. And it plays an outsized role in project success. Since a project is by definition temporary, the completion date is a critical item in virtually every project. The gantt chart is used during project … [Read more...]
Task Completion Criteria
It's a surprisingly common occurrence that a project manager specifies a task as complete only to see more time, materials, and expenses charged to it the next week. Naturally, this is a frustrating situation. Of course, we want the task to be complete and we thus are motivated to check it off a soon as possible. There are often administrative and closing tasks that … [Read more...]
Reporting Earned Value
Earned value results are very easy to report to senior management or other stakeholders. Generally the recipient needs some basic training regarding the meaning of the numbers, but this is not a major undertaking. We break down the typical reporting methods into three categories: Small projects Medium-size projects Large projects Small Projects For small … [Read more...]
Variance at Completion (Earned Value Analysis)
The VAC is a forecast of what the variance, specifically the Cost Variance (CV), will be upon the completion of the project. It is the size of the expected cost overrun or underrun. In many situations the project manager must request additional funding as early as possible, or at least report the potential for an overrun. The VAC represents the size of this … [Read more...]
TCPI (Earned Value Analysis)
The To-Complete Performance Index represents the efficiency level, specifically the CPI (Cost Performance Index) that will make the project finish on time. It can be a powerful indicator because it is generally easy to ascertain if your people will be as productive as the indicator tells you. There are two ways to calculate the TCPI: To achieve the original … [Read more...]