BCGBC4005A Produce labour and material schedules for ordering

Track suppliers

Contract rates

Apply contract rates to schedules
You have been put in charge of entering nominated suppliers onto the schedules. You are given two business cards and other documents. The first business card contains the following information:
Tom Carrick 
Mobile: 0455 334 997 
Jack's Excavation Pty Ltd 
ABN: 55 478 146 481 34 
Doncaster Road 
SUNSHINE   VIC   3020
Below the business card is a table showing the dates of when corresponding tasks need to be completed. There is no heading for the first column and it lists the following activities: 
•	Base stage
•	Water tap in
•	Clear block
•	Temporary power pole
•	Temporary toilet
•	Set out construction and earthworks
•	Bulk excavation and fill
•	Prepare drive access
•	Excavate footings
•	Prepare and pour footing system
•	Lay base brickwork
•	Excavate stump foundations
•	Install and level stumps
•	Install and level bearers
•	Install and level joists
•	Suspend sewer and stormwater under floor
•	Install ducts
•	Install sheet flooring.

Columns two to eleven show headings with weekdays dated from  Monday 15 November to Friday 26 November.
Question 1
Which task would Jack's Excavation Pty Ltd be doing?
A. 	Lay base brickwork
B. 	Bulk excavation and fill
C. 	Install and level joists
The correct answer is B - Bulk excavation and fill.
A drop down menu appears next to 'Bulk excavation and fill' with a list of the following suppliers: Carpenters R Us, Hire Me, Melbourne Temp Fencing, Paul's Plumbing, Ely's Electrical, Timber Specialists, Jack's Excavation, The Brick Experts, and The Brick Specialist.
Question 2
Which supplier from the list should be assigned to the task 'Bulk excavation and fill'?
The correct answer is Jack's Excavation.
The table with dates and tasks to be completed is shown with three menu tabs labelled 'File', 'Edit' and 'View'. Under the 'View' heading are two options 'Resource' and 'Resource usage'.
Question 3
Which option should be chosen to enter the contract details?
A. 	Resource
B. 	Resource usage
The correct answer is A - Resource.
Next a provisional cost table from the contract is shown with five column headings as follows: 
1.	Description of provisional sum item
2.	Estimated quantity of components or materials
3.	Builder's allowance (including labour for each component of unit of material)
4.	Total provisional sum allowance for labour and materials
5.	Builder's % margin on excess. 

The entry in row one lists these details under the respective headings: 
1.	Landscaping
2.	Trees x 5
3.	$60
4.	=300
5.	20%. 
The entry in row two lists these details: 
1.	Excavation
2.	1 x excavator
3.	$10,200
4.	$10,200 
5.	20%.
Below the provisional cost table is a resource table with six column headings as follows: Resource name, Group, Maximum units, Standard rate, Overtime rate and Cost/use.
This table shows 'The Landscapers' in the first row. Under the heading Group, labour is listed. Under the heading 'Maximum units' the quantity required is five trees. Under the heading 'Cost/use' the cost per item is $60.
'The Brick Experts' is in the second row. Under the heading Group, material is listed. Under the heading 'Maximum units' the quantity required is 1600 bricks. Under the heading 'Cost/use' the cost per item is $0.80.
Jack’s Excavation is in the third row with blanks boxes under column headings Group, Maximum units and Cost/use.
Question 4
What information should go in the blank boxes under the headings Group, Maximum units and Cost/use for Jack’s Excavation?
The correct answer is 'Labour', '1' and '$10,200'.
The next business card contains the following information:
Hayden Tyrell 
Sales Phone: 9584 4547 Fax: 9584 4561 
Timber Specialists Pty Ltd 
ABN: 47 120 111 354 190 
Canterbury Road 
MITCHAM   VIC   3132
Below the business card is the same table with dates and tasks to be completed.

Question 5
Which task would Timber Specialists Pty Ltd be doing?
A. 	Set out construction and earthworks
B. 	Prepare drive access
C. 	Install sheet flooring
The correct answer is C - Install sheet flooring.
A drop down menu appears next to 'Install sheet flooring' with a list of the following suppliers: Carpenters R Us, Hire Me, Melbourne Temp Fencing, Paul's Plumbing, Ely's Electrical, Timber Specialists, Jack's Excavation, The Brick Experts, and The Brick Specialist.
Question 6
Which supplier from the list should be assigned to the task ‘Install sheet flooring’?
The correct answer is Timber Specialists.
The table with dates and tasks to be completed is shown with the menu tabs labelled 'File', 'Edit' and 'View'. Under the 'View' heading are two options 'Resource' and 'Resource usage'.
Question 7
To enter the contract details which option should be chosen?
A.	Resource
B.  	Resource usage
The correct answer is A - Resource.
Next a prime cost sum table is shown with five column headings as follows:
1.	Description of each prime cost item
2.	Builder's supply allowance per item
3.	Quantity of components or materials
4.	Prime cost item allowance 
5.	Builder's % margin on excess. 
The entries in rows one to three list the following under the respective headings:
•	row one – 1. Bricks, 2. $0.80, 3. 1600, 4. 1280 5. +20%
•	row two – 1. 145 mm x 19 mm strip flooring (140 mm cover), 2. $3.00, 3. 1063, 4. $3189, 5. 20%
•	row three – 1. Toilet, 2. $300, 3. 1, 4. $300, 5. 20%

Below the prime cost table is a resource table with six column headings as follows is: Resource name, Group, Maximum units, Standard rate, Overtime rate and Cost/use.
The table shows 'The Landscapers' in the first row. Under the heading 'Group', Labour is listed. Under the heading 'Maximum units' the quantity required is five trees. Under the heading 'Cost/use' the cost per item is $60.
'The Brick Experts' is in the second row. Under the heading 'Group', Material is listed. Under the heading 'Maximum units' the quantity required is 1600 bricks. Under the heading 'Cost/use' the cost per item is $0.80.
'Jack's Excavation' is in the third row. Under the heading 'Group' Labour is listed. Under the heading 'Maximum units' 1 excavator is required. Under the heading 'Cost/use' is $10,200.
'Timber Specialists' is in the third row with blank boxes under column headings Group, Maximum units and Cost/use.
Question 8
What information should go in the blank boxes under the headings Group, Maximum units and Cost/use for Timber Specialists?
The correct answer is 'Material', '1063' and '$3.00'.
The contract rates are added to items on a schedule. The rates would appear in an estimated cost table with the following four headings: Resource name, Cost, Actual cost and Variance. The Resource name and Cost columns contain the following information:
•  	The Landscapers, $300
•   	The Brick Experts, $1280
•  	Jack's Excavation, $10,200
•  	Timber Specialists, $3189.
This table can be used to monitor costs for the project to ensure there are enough funds to pay labour and material suppliers.
The first table containing the dates and activities is shown again. Next to the Activity 'Bulk Excavation' and fill the cell under the date Wednesday 17 November is shaded.  Next to the shaded area is the contractor name Jack's Excavation. Next to the activity 'Install sheet flooring' the date Thursday 25 November is shaded. Next to the shaded area is the material supplier name Timber Specialists.

© Copyright Commonwealth of Australia 2007