Gantt charts, resource histograms and levellingAQA A-Level Further Maths: Revision notes
Section 1
Cascade (Gantt) diagrams
A cascade diagram (Gantt chart) shows each activity as a horizontal bar against a time axis, so you can see what is happening on any given day. To construct one, first carry out a forward and backward pass on the activity network and find the float of every activity.
- Draw the critical activities first (on one line, or the top lines), each starting at its earliest start time. They have no float, so they form an unbroken chain from time 0 to the minimum completion time.
- Draw every other activity as a bar from its earliest start time, and show its float after the bar (usually shaded or dashed), so that the bar plus float ends at the latest finish time.
- Show the order of activities with their precedences, so an activity never starts before its predecessors' bars end.
Reading the chart: the bar for an activity gives its earliest start and finish, the float tells you how far it can slip without delaying the project, and drawing a vertical line at any time shows which activities are running then.
Float is the length of the shaded gap after a non-critical bar, so a bar plus its float should end exactly at the latest finish time.
Starting a non-critical bar after its latest start, or drawing a bar before a predecessor has finished.
Section 2
Resource histograms
A resource histogram is a bar chart of the number of workers (or other resource) needed in each time period. To construct one from a cascade diagram, draw a vertical line at each unit of time and add up the workers for every activity running in that period.
- Work out the demand period by period. If P needs 2 workers from day 0 to day 3 and Q needs 3 workers from day 0 to day 4, the demand on days 0 to 3 is . If R (2 workers) starts on day 3, the demand from day 3 to day 4 is .
- The peak of the histogram is the largest number of workers needed at any time.
- The total number of worker-days is the sum over all activities of (duration workers), which equals the area under the histogram.
Reading a histogram tells you whether the available workforce is enough, and which periods are overloaded.
Counting an activity in a period it is not running in, or adding the workers of activities that do not overlap in time.
Section 3
Resource levelling
Resource levelling smooths the histogram so that the demand is as even as possible, or never exceeds a limit, without making the project later. There is no algorithm that always gives the best answer, so a heuristic procedure is used:
- Draw the cascade diagram with every activity at its earliest start and the resource histogram below it.
- Find the periods where demand is too high.
- Delay non-critical activities that run in those periods, using their floats, until the demand is acceptable. Delaying a critical activity delays the whole project.
- Redraw the histogram, check the precedences, and check that no new peak has been created.
A delayed activity uses up some of its float and may also reduce the float of activities that follow it, so recalculate. If the limit cannot be met without moving critical activities, the project must be extended.
Using B's float and D's float separately when D follows B: they are shared, so check D's latest start after moving B.
Move the activity with the most float first, and check the whole project still finishes on time.
Section 4
Scheduling with a restricted number of workers
When each activity needs one worker and the number of workers is limited, ask two questions.
- Lower bound: the minimum number of workers needed to finish in the minimum time is at least , rounded up to the next integer.
- Schedule: build a schedule (a list of what each worker does and when) to show that this number really is enough. Start critical activities at their earliest time, then use free workers on non-critical activities, respecting precedences.
Example: X takes 3 days (no predecessor), Y takes 4 days (no predecessor), Z takes 2 days (after X), W takes 5 days (after Y and Z). The minimum time is days, with X, Z, W critical. Total duration is , and , so at least 2 workers. Worker 1 does X, Z, W and worker 2 does Y (days 0 to 4), which works.
If there are fewer workers than the lower bound, the project takes longer than the minimum time.
Stopping after the lower bound. It is only a minimum; you must still show a schedule that works, because precedences may force extra workers.
Always round the lower bound up, never to the nearest integer: 1.4 workers means 2.
That's the notes covered.
Carry on to the next subtopic.
Exam questions on Gantt charts, resource histograms and levelling
- A project has seven activities. Activity A takes 4 days and has no predecessor. B takes 3 days and has no predecessor. C takes 5 days and follows A. D takes 2 days and follows both A and B. E takes 6 days and follows C. F takes 3 days and follows D. G takes 2 days and follows both E and F.A cascade (Gantt) diagram is drawn with every activity starting as early as possible. For activity F, state the day on which its bar ends and the length of the float drawn after it.2 marks
- A project is planned with every activity starting at its earliest time. P runs from day 0 to day 3 and needs 2 workers. Q runs from day 0 to day 4 and needs 3 workers. R runs from day 3 to day 5 and needs 2 workers. S runs from day 4 to day 7 and needs 4 workers. T runs from day 5 to day 7 and needs 2 workers. Each worker is paid for every day on which they are needed.The firm employs only 5 workers. State the period during which the schedule needs more than 5 workers, and by how many it is short.2 marks
- A project consists of seven activities, each needing one worker. Durations are in days. A takes 5 days and has no predecessor. B takes 3 days and has no predecessor. C takes 4 days and follows A. D takes 6 days and follows A. E takes 2 days and follows B. F takes 3 days and follows both C and E. G takes 4 days and follows both D and F.Find the minimum completion time and list the critical activities.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).