Analysing Production Targets Achieved Using Gantt Charts  

Below are the steps to use Gantt Chart feature to analyse production targets. 

For this simulation example, the annual coal production target is 3.2 million tons.  

1) Openthe Gantt Charts feature .

2) Right click on Gantt Charts—Select Settings—Results .

In the first line, create, for example: “coal target 3,2 Mt Hit” and in the second line, create Coal target not Hit, then choose reportinglevel yearly as seen on the screenshot below. 

3) In the coal target3,2 Mt Hit section, fill the field value expression with the following formula: 

if(Between(EndDate,#1 Jan 2022#,#1 Jan 2023#),if(ScheduleSum(SourceQuantity) >= 320000, SourceQuantity, 0), 

Between(EndDate,#1 Jan 2023#,#1 Jan 2024#),if(ScheduleSum(SourceQuantity) >= 320000, SourceQuantity, 0), 

Between(EndDate,#1 Jan 2024#,#1 Jan 2025#),if(ScheduleSum(SourceQuantity) >= 320000, SourceQuantity, 0), 

Between(EndDate,#1 Jan 2025#,#1 Jan 2026#),if(ScheduleSum(SourceQuantity) >= 320000, SourceQuantity, 0), 

if(ScheduleSum(SourceQuantity) >= 320000, SourceQuantity, 0))

4) In the coal target not hit section, fill the field value expression with the following formula: 

if(Between(EndDate,#1 Jan 2022#,#1 Jan 2023#),if(ScheduleSum(SourceQuantity) < 320000, SourceQuantity, 0), 

Between(EndDate,#1 Jan 2023#,#1 Jan 2024#),if(ScheduleSum(SourceQuantity) < 320000, SourceQuantity, 0), 

Between(EndDate,#1 Jan 2024#,#1 Jan 2025#),if(ScheduleSum(SourceQuantity) < 320000, SourceQuantity, 0), 

Between(EndDate,#1 Jan 2025#,#1 Jan 2026#),if(ScheduleSum(SourceQuantity) < 320000, SourceQuantity, 0), 

if(ScheduleSum(SourceQuantity) < 320000, SourceQuantity, 0))

The result is as follows:

From the Gantt Chart display above, the scheduler can easily analyse and correct which simulation year that has met or fail to meet the target.  

Related Articles

Build or extend your team with our experts!

Book a complimentary consultation with an experienced Australian-based professional. Schedule a meeting today.