Gantt Chart Progress Tracking: Planned Cost vs. Duration

The Gantt chart feature allows you to manage the progress rate of each job and the overall project. You can choose between two calculation methods for the progress rate: "Planned Cost" and "Duration".

Planned Cost: The overall project progress is displayed based on the planned cost of each process.

Duration: The overall project progress is displayed based on the duration of each process.

With Planned Cost, you can input and manage the costs associated with the project, while Duration allows you to check the current progress against the planned timeline.

Note: Only one calculation method can be selected, and once chosen, it cannot be changed later. Please be cautious when making your selection.

This is an optional feature. If you wish to use this feature, please contact your representative.

 

Please refer to this page to learn about the "Summary Function"

 

Creating a Gantt chart

1. Open the project for which you want to create a new Gantt chart from the "Projects" menu

 

2. Click on [Gantt Chart]

 

3. Click on [Create New Gantt Chart] or [Create New from Gantt Chart Template]

 

4. Select either [Calculate based on Planned Cost] or [Calculate based on Duration]

 

Please refer to the following based on the selected calculation method.

 

 

Note: The calculation method for the overall progress rate differs between [Planned Cost] and [Duration].
Note: If the summary feature is not enabled, please enable it before use. For details on enabling the summary feature, please check here.

 

Updating progress rate using Planned Cost

1. Select [Calculate based on Planned Cost] and click [Create]

The overall progress rate is calculated by multiplying the planned cost of each job by its progress rate, summing them up, and dividing the total by the planned cost of the entire project.

 

2. Input the [Start Date - End Date (Plan)]

Clicking on each case will display the edit screen on the right side of the screen.

Click on the [Start Date - End Date (Planned)] column for each job to display the editing screen on the right. For sub projects with sub-sub projects, the start and end dates will be automatically filled in when you input the dates for the sub-sub projects

 

3. Input the [Planned Cost]

Click on the [Planned Cost] column for each project to display the editing screen on the right.

 

4. The [Weighted Cost] and [Planned Progress] will be displayed

 

5. Enter the [Actual Cost].

When you enter the actual cost, the difference from the planned cost is displayed.

 

6. Enter the [Actual Progress] rate.

 

7. Completion 

Once data is entered for all items, the [Overall project progress (Planned/Actual)] rate and [Cost & Value] overview will be calculated.

Note: The [Overall project progress (Planned/Actual)] rate is calculated based on the "Planned Cost" selected in Step 1.

 

 


Updating progress rate using duration

1. Select [Calculate based on duration] and click [Create]

 

2. Input the [Start Date - End Date (Plan)]

Click on the [Start Date - End Date (Plan)] column for each sub project to display the editing screen on the right. For sub-projects with sub-sub projects, the start and end dates will be automatically reflected in the sub-projects when you input the dates for the sub-sub projects.

 

3. Enter the [Actual Cost]

When you enter the Actual Cost, the difference from the Planned Cost will be displayed.

 

4. Enter the [Actual Progress] rate.

 

5. Completion

Once data is entered for all items, the [Overall project progress (Planned/Actual)] rate and [Cost & Value] will be calculated.

Note: The Overall project progress (Planned/Actual) rate is calculated based on the "duration" selected in Step 1.

 

 

 

Export as Excel

You can export the Gantt chart created by KANNA in Excel from [Export as Excel] in the upper right corner.

You can view the Gantt chart on the application (smartphone) by converting the Excel output to PDF and uploading it to the documents folder in the project.

For details on how to upload documents, please click here.

 

1. Click [Export as Excel].

 

2. Select the Output period and click [Export].

Check the items you want to output in Excel under “Actual Date,” “Cost / Value,” and “Progress.”

 

3. Click [Start].

Gantt chart for up to two years can be exported.
A download URL will be sent to your KANNA registered address by e-mail, Please download the Excel file from there.

 

4. Completion

Was this article helpful?
0 out of 0 found this helpful