Gantt charts and schedulingEdexcel International A Level Maths: Revision notes
Section 1
Cascade (Gantt) charts
A Gantt chart (also called a cascade chart) shows when each activity takes place. Time runs along a horizontal axis, and each activity has its own row. The standard way of drawing one:
- draw each activity as a bar from its earliest start time to its earliest finish time ( to );
- the critical activities have no float, and are often drawn first (or at the top) as a continuous chain of bars;
- show each non-critical activity's float as a dotted or lighter line after its bar, extending to its latest finish time;
- draw an arrow, or order the rows, so that an activity starts only after all its predecessors have finished. The chart is built from the precedence table and the earliest and latest times found by forward and backward passes.
Find earliest start, latest finish and float for every activity in a small table before drawing; it makes the chart quick and error-free.
Section 2
Reading information from a chart
A cascade chart lets you read:
- the minimum completion time: the finish of the last critical activity;
- the critical activities: those with no float line;
- the float on each activity: the length of its float line, or latest finish minus earliest finish;
- which activities are in progress at any time, by drawing a vertical line at that time (the activities it crosses) and counting. Example: with A 0 to 4, B 0 to 3, C 4 to 9 and D 4 to 10, at time 5 the activities in progress are C and D, so at least two workers are needed then. If an activity is delayed by up to its float, nothing else changes; a delay greater than its float delays the project by the excess.
Counting an activity that finishes at exactly the given time as still in progress. A bar covers the interval from its start up to (not including) its finish.
Section 3
Scheduling: the idea
Scheduling means deciding which worker does which activity and when, so that the project is completed in a given time, subject to precedence. The usual assumptions are that each worker does one activity at a time, an activity cannot be interrupted or shared, and workers are equally skilled. Because the critical path decides the minimum time, a schedule can never be shorter than it, however many workers there are. Workers can be idle at times (for example while waiting for a predecessor), so more workers than the lower bound may be needed.
Splitting one activity between two workers or interrupting it. Each activity is done by one worker, without a break.
Section 4
Lower bound for the number of workers
If the total of all activity durations is and the project must be completed in time (usually the minimum completion time), the number of workers needed is at least that is, rounded up to the next whole number. Example: durations and give , so at least 2 workers. It is only a lower bound: the real number may be larger because precedence prevents the work being shared evenly. To prove 2 workers are not enough, show that the activities left for the second worker cannot all fit in the time available.
Round up, never down: 1.69 workers means 2 workers.
Section 5
Constructing a schedule
- Find earliest and latest times, the critical activities and the minimum time.
- Give the critical activities to one worker, at their earliest times, since they have no float.
- Allocate the remaining activities to other workers, respecting precedence: an activity starts only after all its predecessors are finished, and when its worker is free.
- Use float to fit activities in. Do the activities with the least float first.
- Check every precedence relationship and the final completion time. If the target time cannot be met, say which activity is delayed and by how much. Example: critical tasks B, D, F (0 to 5, 5 to 11, 11 to 14) for one worker; A (0 to 3), C (3 to 7), E (7 to 9) for the other. Task E needs A and B finished, and F needs C, D, E finished, so the schedule is valid.
Starting an activity before one of its predecessors has finished because the worker is free. Check every predecessor.
That's the notes covered.
Carry on to the next subtopic.
Exam questions on Gantt charts and scheduling
- A project has seven activities. Their durations in days and immediate predecessors are: A (4 days, none); B (3 days, none); C (5 days, A); D (6 days, A); E (4 days, B and C); F (2 days, D); G (3 days, E and F). A cascade (Gantt) chart is to be drawn with every activity starting at its earliest start time.Calculate the total float of activity D, and state the latest time at which D can start without delaying the project.2 marks
- A project has six activities. Their durations in days and immediate predecessors are: P (5 days, none); Q (3 days, none); R (4 days, P); S (5 days, P); T (2 days, Q and R); U (3 days, S and T). Every activity starts at its earliest start time, and the minimum completion time is 14 days.Show that at least 2 workers are needed to complete the project in the minimum time.2 marks
- A workshop job has six tasks. Their durations in hours and immediate predecessors are: A (3 hours, none); B (5 hours, none); C (4 hours, A); D (6 hours, B); E (2 hours, A and B); F (3 hours, C, D and E). Each task is done by one worker without interruption, and a worker can do only one task at a time.Find the minimum time in which the job can be completed with as many workers as are needed, and a lower bound for the number of workers needed to complete it in that time.3 marks
Written by the Exaim team, led by Shaun Daswani (Head of Upper Secondary, Improve ME Institute; MSc Financial Mathematics, Imperial College London; BSc, UCL) and Jason Daswani (operational lead, Improve ME Institute; LSE).