ASSESSMENT TASK 1
PRODUCE LABOUR & MATERIALS SCHEDULE
Refer to the attached copy of a Bill of Quantities and the attached pages
describing how to prepare a Bar Chart/Schedule/Program
Prepare a Schedule to Order the Labour, Materials, Goods and Services for the
project set out in the Bill of Quantities ATTACHED FILE
The Schedule must be in the form of an Excel spread sheet Bar Chart.
Support the Schedule with a written description/explanation of each stage of the
Schedule – noting not only what needs to be purchased, or who needs to be
engaged but include the critical timelines for the goods and services to be
ordered and delivered to site.
Assume you will be on holidays and your Supervisor will be responsible for
ordering and acquiring all the building materials, labour, sub-contractors,
services etc for the new project.
Set out the description/explanation in words that are easy to understand and in
a format that your Supervisor will be able to read and implement your directions
without having to constantly come to you to clarify each section. DO NOT just
copy the words in the text or copy the example forms provided in the text – use
the text words and forms as a guide to design your own. You will be penalised if
you just copy the text documents.
BAR CHARTS
(Source TAFEPLUS)
When the drawings for a building project have been completed, it is helpful to present it in a
format which is easily understood and may be used by all personnel on a building job.
Bar Charts are drawn up with the activities shown down the left-hand side and the time
periods shown horizontally.
Often the activities are shown only as a number or coded letters but most often by the full
name of the activity.
Times to complete each activity are shown by means of bars, which may be open or
coloured in. Often the bar charts are coloured in to show the work completed to that date
also indicating the percentage of work completed, this allows the actual progress of the job to
e compared to the scheduled program.
For larger projects there are more than one bar chart. There is a chart for each section of the
project and a master program is drawn up to co-ordinate all sections of the job.
A typical bar chart, as shown in our example, should include:
* Expected start, duration and completion dates.
* A method of controlling or monitoring the progress.
This can be achieved in the suggestions listed below:
* Colouring in the bars.
* Drawing parallel bars.
* Coloured pins.
* Highlight markers etc.
There is no set design of a bar chart, however a chart should include the minimum
information as set out below:
* Project name.
* Time scale (e.g. daily, weekly, monthly etc).
* Dates.
* Activity description (in order of progress on site).
* Activity to activity which supports each other or is.
dependant on each other.
* Method of showing the time elapsed.
* Method of recording the progress of each activity.
* Completion date (contract date/established date of completion).
In the second example a chart is drawn up using the method of working days only, omitting
weekends yet showing all holidays.
The time estimated to complete a specific activity or trade on the site is marked in either line
or box section (see third example), starting from when the activity starts to when it is finished.
Using an example of three activities or trades which must be ca
ied out in sequence, and
the duration times are
â–ª Trade/Activity A, 1 day
â–ª Trade/Activity B, 1 day
â–ª Trade/Activity C, 2 days
This would be shown on the chart as our third example demonstrates.
This shows quite clearly how work should progress. Note that the lines of
dependency/support show the inte
elationship of the trades, for example...
Trade B cannot commence until Trade A has been completed.
Likewise Trade C follows Trade B.
Taking the example further, if the project has been running for three weeks (15 working days)
and the bar chart has been used to monitor progress then it may look like the fourth example
shown on the following pages.
The information may be extracted from the bar chart includes.
â–ª Activity A should be complete, and is complete;
â–ª Activity B should be complete, and is complete;
â–ª Activity C should be complete, and is complete;
â–ª Activity D should be complete, and is complete;
â–ª Activity E should be complete, and is complete;
â–ª Activity F should be complete, and is complete;
â–ª Activity G is only 60% complete but should be complete;
â–ª Therefore, as Activity G is on the critical path the project may be seen to be behind by
two working days
The job of the site foreman/supervisor is now to determine what action needs to be taken to
ing the project back on schedule.
To be realistic a construction program is only as good as:
â–ª The initial intent of the planners
â–ª The accuracy of information available
â–ª The knowledge of the contract drawings & documents
â–ª The experience of the team
â–ª The number of updates that the program undergoes
â–ª The lines of communication.
© Copyright by Back to Basics Business Training Pty Ltd – National Training Provider Number 4346
Date of Revision:
Code:
Course:
Module:
Assessment:
June 2018
CIVCA
CPC40208 Certificate IV in Building and Construction (Contract Administration)
2 Tendering & Procurement
1 Produce Labour & Materials Schedule Page 10 of 12
Tendering & Procurement
Example 1
Time Schedule MONTH MAY JUNE JULY AUGUST SEPT OCT NOVEMBER DECEMBER JANUARY
OPERATION DATE
A CLEAR & LEVEL SITE
D CONCRETE FRAME
E EXTERNAL BRICKWORK
F ROOF CONSTRUCTION
G ROOF PLUMBING
EXCAVATE FOR FOOTING B
Scheduled
Work
Percentage of Work
Completed
Actual Time
Worked
CONCRETE FLOORING C
© Copyright by Back to Basics Business Training Pty Ltd – National Training Provider Number 4346
Date of Revision:
Code:
Course:
Module:
Assessment:
June 2018
CIVCA
CPC40208 Certificate IV in Building and Construction (Contract Administration)
2 Tendering & Procurement
1 Produce Labour & Materials Schedule Page 11 of 12
No.
A
B
Description
Establish Site
Set Out
C Footings
D Drains
E Brickwork Order Deliver
F Bearers &
Joists
G Wall Frame
Tendering & Procurement
Example 2
PROJECT NAME Contact No.
Date XXXXXXXXXX26 29
Working Day XXXXXXXXXX
0
1
1
1
2
1
3
1
4
1
5
1
6
1
7
1
8
1
9
2
0
2
1
2
2
No
.
Descriptio
n
A Establish
Site
B Set Out
C Footings
D Drains
E Brickwork
F Bearers &
Joists
G Wall
Frame
Example 3
PROJECT NAME Contact No.
Date XXXXXXXXXX26 29
Working Day XXXXXXXXXX
0
1
1
1
2
1
3
1
4
1
5
1
6
1
7
1
8
1
9
2
0
2
1
2
2
No
.
Descriptio
n
A Establish
Site
B Set Out
C Footings
D Drains