Cost Build Up Template: Version Control

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 14

Cost Build Up Template

This template was provided by a Local Government at the beginning of this process. It was included in the set of templa
temporary exemption.

This version has been developed further, based on feedback provided. It can be used by Local Governments to to estima
when looking to make a WANDRRA claim. The cost estimate sheet aligns with the cost estimate template in the set of d
WANDRRA claim.

Please note it is work in progress. Comments and feedback are very welcome . Please note this is not mandatory. If Loca
templates and processes that provide the necessary supporting information then they can be used during this time.

Please contact the WANDRRA team if you have any queries or comments. Email: [email protected]

Version Control
May-17 Initial template provided by local government and included on the website for additional information, i
14-Jul-17 Revised cost build up template with significant changes to the format of the template and layout.
ded in the set of templates to support the day labour

overnments to to estimate their recovery and repair works


template in the set of documents required to make a

s not mandatory. If Local Governments have their own


ed during this time.

m.wa.gov.au

dditional information, if local governments required it.


plate and layout.
WANDRRA CLAIM - Estimate of Asset Restoration Cost
(To pre-existing standard)
Date of Event:
AGRN:
Event Name: SLK Reference:
Name of Local Government: Local Government Number: xyz
Road Name: Road Number: xzy
Cost Estimate Status: Revision 0 - Initial Assessment Estimate Date 10-Apr-15
ATTACHMENT <X> - COST ESTIMATE FOR THIS SUBMISSION

Item Description Labour Total Plant Total Materials Total Amount ($) Notes/Comments

1.00 General Items


1.1 1. Supervision $ 40.61 $ 90.00 $ 20.00 $ 150.61
1.2 2. Survey & Setting Out $ 237.01 $ 161.36 $ 80.00 $ 478.37
1.3 3. Mobilisation/ Demobilisation $ 259.65 $ 306.00 $ - $ 565.65
1.4 4. Other General Items $ - $ 182.00 $ - $ 182.00
Supervision Cost (if applicable) 0% $ - $ - $ - $ -
Sub-total ($) $ 537.28 $ 739.36 $ 100.00 $ 1,376.64
2.00 Earthworks
2.1 Clearing $ 40.61 $ - $ - $ 40.61
2.2 Topsoil Removal & Respread $ 121.83 $ 42.00 $ 20.00 $ 183.83
2.3 Embankment Foundation $ - $ 42.00 $ 40.00 $ 82.00
2.4 Embankment Construction $ 103.86 $ 126.00 $ 60.00 $ 289.86
2.5 Subgrade Preparation $ - $ - $ - $ -
2.6 Forming & Shaping (Unsealed Roads Only) $ - $ 324.00 $ 80.00 $ 404.00
2.7 Scour repair $ 200.59 $ - $ 80.00 $ 280.59
Supervision Cost (if applicable) 15% $ 70.03 $ 80.10 $ 42.00 $ 192.13
Sub-total ($) $ 536.93 $ 614.10 $ 322.00 $ 1,473.03
3.00 Pavement & Surfacing
3.1 Gravel Sheeting (Unsealed Roads Only) $ 121.83 $ 42.00 $ 20.00 $ 183.83
3.2 Sub-base $ - $ 42.00 $ 40.00 $ 82.00
3.3 Basecourse $ 103.86 $ 126.00 $ 60.00 $ 289.86
3.4 Extra over for Cement Stabilisation $ - $ - $ - $ -
3.5 Prime $ - $ 168.00 $ 80.00 $ 248.00
3.6 Primerseal $ - $ - $ 100.00 $ 100.00
3.8 First Coat Seal $ - $ - $ - $ -
3.8 Second Coat Seal (For Reseal & Final Seal) $ - $ - $ - $ -
3.9 Asphalt $ - $ - $ - $ -
3.10 Microsurfacing $ - $ - $ - $ -
3.11 White Lining - Initial SACRIFICIAL ONLY treatment $ - $ - $ - $ -
3.12 White Lining - re-instatement of existing lining $ - $ - $ 80.00 $ 80.00
Supervision Cost (if applicable) 15% $ 33.85 $ 56.70 $ 57.00 $ 147.55
Sub-total ($) $ 259.55 $ 434.70 $ 437.00 $ 1,131.25
4.00 Drainage
4.1 Diversion & Cut-off Drains $ 121.83 $ 42.00 $ 20.00 $ 183.83
4.2 Culvert Inlet and Outlet Drains $ - $ 42.00 $ 40.00 $ 82.00
4.3 Levees $ 103.86 $ 126.00 $ 60.00 $ 289.86
4.4 Table Drain Blocks $ - $ - $ - $ -
4.5 Corrugated Steel Pipe Culverts $ - $ 168.00 $ - $ 168.00
4.6 Reinforced Concrete Pipe Culverts $ - $ - $ - $ -
4.8 Reinforced Concrete Box Culverts $ - $ - $ - $ -
4.8 Culvert End Treatments $ - $ - $ - $ -
4.9 Drainage Pits $ - $ - $ - $ -
4.10 Rock Protection $ - $ - $ - $ -
4.11 Kerbing $ - $ - $ - $ -
4.12 Concrete Wall $ - $ - $ 80.00 $ 80.00
Supervision Cost (if applicable) 15% $ 33.85 $ 56.70 $ 30.00 $ 120.55
Sub-total ($) $ 259.55 $ 434.70 $ 230.00 $ 924.25
5.00 Miscellaneous and Safety Devices

5.1 Sign replacement (Regulatory, Warning, Guide) $ 40.61 $ - $ - $ 40.61


5.2 Guide Posts $ 121.83 $ 42.00 $ 20.00 $ 183.83
5.3 Stock Grids $ - $ 42.00 $ 40.00 $ 82.00
5.4 Safety Barrier $ 103.86 $ 126.00 $ 60.00 $ 289.86
5.5 RRPM (retro raised pavement marker) $ - $ - $ - $ -
5.6 Traffic Management $ - $ 168.00 $ - $ 168.00
5.7 Service Re-locations (e.g. Telstra, Western Power) $ - $ - $ 80.00 $ 80.00
Supervision Cost (if applicable) 15% $ 39.95 $ 56.70 $ 30.00 $ 126.65
Sub-total ($) $ 306.25 $ 434.70 $ 230.00 $ 970.95

Estimate - General Summary

Construction Costs
1.00 General Items $ 537.28 $ 739.36 $ 100.00 $ 1,376.64
2.00 Earthworks $ 536.93 $ 614.10 $ 322.00 $ 1,473.03
3.00 Pavement & Surfacing $ 259.55 $ 434.70 $ 437.00 $ 1,131.25
4.00 Drainage $ 259.55 $ 434.70 $ 230.00 $ 924.25
5.00 Miscellaneous and Safety Devices $ 306.25 $ 434.70 $ 230.00 $ 970.95
WANDRRA CLAIM - Estimate of Asset Restoration Cost
(To pre-existing standard)
Date of Event:
AGRN:
Event Name: SLK Reference:
Name of Local Government: Local Government Number: xyz
Road Name: Road Number: xzy
Cost Estimate Status: Revision 0 - Initial Assessment Estimate Date 10-Apr-15
ATTACHMENT <X> - COST ESTIMATE FOR THIS SUBMISSION

Item Description Labour Total Plant Total Materials Total Amount ($) Notes/Comments
Subtotal (Construction costs) $ 1,899.55 $ 2,657.56 $ 1,319.00 $ 5,876.11

Escalation 0.00% $ - $ - $ - 0.00%

Total Project Cost (excl. GST) $ 1,899.55 $ 2,657.56 $ 1,319.00 $ 5,876.11


1. GENERAL ITEMS - WANDRRA WORKS

Edit cells in orange


Do not edit greyed cells

Road Labour overhead 60% EXAMPLE ONLY - INSERT OVERHEAD PERCENTAGE

LABOUR COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4
Mobilisation
Other
Labour Hrly 2. Survey & 3. Mobilisation/ 4. Other General Wage per Overhead Survey & / TOTAL
Surname Given Allow Rate Description 1. Supervision TOTAL Hours Supervision General
Code Rate Setting Out Demobilisation Items hour Cost Setting Out Demobilisati COST
Items
on
WN01 Machine operator 1 MO1 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ -
WO02 Machine operator 2 MO2 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ -
WP04 Machine operator 3 MO3 $ 24.69 $ 0.69 1 2 3 $ 25.38 $ 15.23 $ 40.61 $ 81.22 $ - $ - $ 121.83
WJ07 Machine operator 4 MO4 $ 27.16 $ 5.29 3 5 8 $ 32.46 $ 19.47 $ - $ 155.79 $ 259.65 $ - $ 415.44
WG02 Machine operator 5 MO5 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ -
WG04 Machine operator 6 MO6 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ -
WG05 Machine operator 7 MO7 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ -
WG07 Machine operator 8 MO8 $ 23.92 $ 0.69 0 $ 24.61 $ 14.77 $ - $ - $ - $ - $ -
WD06 Machine operator 9 MO9 $ 28.21 $ 2.11 0 $ 30.32 $ 18.19 $ - $ - $ - $ - $ -
WA01 Machine operator 10 MO10 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ -
WW03 Machine operator 11 MO11 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ -
WT07 Machine operator 12 MO12 $ 23.92 $ 0.69 0 $ 24.61 $ 14.77 $ - $ - $ - $ - $ -
$ 40.61 $ 237.01 $ 259.65 $ - $ 537.28
PLANT COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4
Mobilisation
Other
DETAIL IF Hours Depn Hrs 2. Survey & 3. Mobilisation/ 4. Other General Overhead (If Survey & / TOTAL
Plant Code Description Description 1. Supervision Total Hours Plant Rate Supervision General
REQUIRED Rate Rate Setting Out Demobilisation Items applicable) Setting Out Demobilisati COST
Items
on
502 Cherry Picker $ 35.00 7.0000 0 $ 42.00 $ - $ - $ - $ - $ -
503 Graders $ 38.00 7.0000 2 2 $ 45.00 $ 90.00 $ - $ - $ - $ 90.00
505 Backhoe $ 32.00 8.3400 4 4 $ 40.34 $ - $ 161.36 $ - $ - $ 161.36
506 Loader $ 43.00 8.0000 6 6 $ 51.00 $ - $ - $ 306.00 $ - $ 306.00
508 Mower/Slasher $ 24.00 2.0000 7 7 $ 26.00 $ - $ - $ - $ 182.00 $ 182.00
509 STEEL ROLLER $ 28.00 5.0000 0 $ 33.00 $ - $ - $ - $ - $ -
511 MULTI TYRE ROLLER $ 28.00 9.0000 0 $ 37.00 $ - $ - $ - $ - $ -
512 ROAD SWEEPER $ 45.00 14.0000 0 $ 59.00 $ - $ - $ - $ - $ -
513 TRACTORS $ 22.00 2.0000 0 $ 24.00 $ - $ - $ - $ - $ -
514 TIP TRUCKS $ 48.00 7.2500 0 $ 55.25 $ - $ - $ - $ - $ -
515 SMALL TRUCKS $ 16.00 6.0000 0 $ 22.00 $ - $ - $ - $ - $ -
516 TREE PLANTER $ 9.00 1.0000 0 $ 10.00 $ - $ - $ - $ - $ -
521 Water Cart Truck $ 35.00 4.0000 0 $ 39.00 $ - $ - $ - $ - $ -
522 Woodchippper $ 35.00 4.0000 0 $ 39.00 $ - $ - $ - $ - $ -
523 Medium Truck(6 Tonne) $ 16.00 3.0000 0 $ 19.00 $ - $ - $ - $ - $ -
524 Skid Steer Loader $ 24.00 5.4400 0 $ 29.44 $ - $ - $ - $ - $ -
525 Supervisors Ute 0 $ - $ - $ - $ - $ - $ -
526 Work Ute 0 $ - $ - $ - $ - $ - $ -
527 Contract side tippers 0.0000 0 $ - $ - $ - $ - $ - $ -
528 Specialised hire equipment 0.0000 0 $ - $ - $ - $ - $ - $ -
$ 90.00 $ 161.36 $ 306.00 $ 182.00 $ 739.36

MATERIAL COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
Code
Overhead (If TOTAL
(if Description Detail Unit Unit Cost Explanations #1 #2 #3 #4 Unit Rate #1 #2 #3 #4
applicable) applicable) COST
Mobilisation each 0 $ - $ - $ - $ - $ - $ -
Formation Layer m3 $ 20.00 0 $ 20.00 $ - $ - $ - $ - $ -
Sub base formation m3 $ 20.00 0 $ 20.00 $ - $ - $ - $ - $ -
Gravel m3 $ 20.00 1 1 $ 20.00 $ 20.00 $ - $ - $ - $ 20.00
Water kl $ 20.00 0 $ 20.00 $ - $ - $ - $ - $ -
Stabilisation m2 $ 20.00 4 4 $ 20.00 $ - $ 80.00 $ - $ - $ 80.00
Chemical Stabilisation kg $ 20.00 0 $ 20.00 $ - $ - $ - $ - $ -
Drainage m $ 20.00 0 $ 20.00 $ - $ - $ - $ - $ -
Bitumen m2 $ 20.00 0 $ 20.00 $ - $ - $ - $ - $ -
1. GENERAL ITEMS - WANDRRA WORKS

Edit cells in orange


Do not edit greyed cells

Road Labour overhead 60% EXAMPLE ONLY - INSERT OVERHEAD PERCENTAGE


Asphalt m2 $ 20.00 0 $ 20.00 $ - $ - $ - $ - $ -
Guide Posts each $ 20.00 0 $ 20.00 $ - $ - $ - $ - $ -
Culverts m $ 20.00 0 $ 20.00 $ - $ - $ - $ - $ -
Concrete m3 $ 20.00 0 $ 20.00 $ - $ - $ - $ - $ -
Reinforcing t $ 20.00 0 $ 20.00 $ - $ - $ - $ - $ -
Job specific 0 $ - $ - $ - $ - $ - $ -
$ 20.00 $ 80.00 $ - $ - $ 100.00

Labour $ 537.28
Plant $ 739.36
Material $ 100.00

Sub Total $ 1,376.64


UPDATE WITH ANY LG SUPERVISION PERCENTAGE OR LEAVE BLANK Supervision Overhead 0%
Supervision $ -

Total $ 1,376.64

Funding
Own Resources
Other
2. EARTHWORKS COST BUILD UP - WANDRRA WORKS

Edit cells in orange


Do not edit greyed cells

Road Labour overhead 60% EXAMPLE ONLY - INSERT OVERHEAD PERCENTAGE

LABOUR COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4 5 6 7
2. Topsoil Topsoil
Labour Hrly 3. Embankment 4. Embankment - 5. Subgrade 6. Forming and Wage per Overhead Embankment Embankment Subgrade Forming and TOTAL
Surname Detail Allow Rate 1. Clearing Removal & 7. Scour Repair TOTAL Hours Clearing Removal & Scour Repair
Code Rate - Foundation Construction Preparation Shaping hour Cost Foundation Construction Preparation Shaping COST
Respread Respread
WN01 Machine operator 1 MO1 $ 24.69 $ 0.69 1 0 $ 25.38 $ 15.23 $ 40.61 $ - $ - $ - $ - $ - $ - $ 40.61
WO02 Machine operator 2 MO2 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ -
WP04 Machine operator 3 MO3 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ -
WJ07 Machine operator 4 MO4 $ 27.16 $ 5.29 2 2 $ 32.46 $ 19.47 $ - $ - $ - $ 103.86 $ - $ - $ - $ 103.86
WG02 Machine operator 5 MO5 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ -
WG04 Machine operator 6 MO6 $ 24.69 $ 0.69 3 3 $ 25.38 $ 15.23 $ - $ 121.83 $ - $ - $ - $ - $ - $ 121.83
WG05 Machine operator 7 MO7 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ -
WG07 Machine operator 8 MO8 $ 23.92 $ 0.69 0 $ 24.61 $ 14.77 $ - $ - $ - $ - $ - $ - $ - $ -
WD06 Machine operator 9 MO9 $ 28.21 $ 2.11 0 $ 30.32 $ 18.19 $ - $ - $ - $ - $ - $ - $ - $ -
WA01 Machine operator 10 MO10 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ -
WW03 Machine operator 11 MO11 $ 24.69 $ 0.69 3 3 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ 121.83 $ 121.83
WT07 Machine operator 12 MO12 $ 23.92 $ 0.69 2 2 $ 24.61 $ 14.77 $ - $ - $ - $ - $ - $ - $ 78.76 $ 78.76
$ 40.61 $ 121.83 $ - $ 103.86 $ - $ - $ 200.59 $ 466.90
PLANT COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4 5 6 7
2. Topsoil Topsoil
Detail (if Hours Depn Hrs 3. Embankment 4. Embankment - 5. Subgrade 6. Forming and Wage per Overhead Embankment Embankment Subgrade Forming and TOTAL
Plant Code Description 1. Clearing Removal & 7. Scour Repair TOTAL Hours Clearing Removal & Scour Repair
required) Rate Rate - Foundation Construction Preparation Shaping hour Cost Foundation Construction Preparation Shaping COST
Respread Respread
502 Cherry Picker $ 35.00 7.0000 1 1 3 4 9 $ 42.00 $ - $ 42.00 $ 42.00 $ 126.00 $ - $ 168.00 $ - $ 378.00
503 Graders $ 38.00 7.0000 0 $ 45.00 $ - $ - $ - $ - $ - $ - $ - $ -
505 Backhoe $ 32.00 8.3400 0 $ 40.34 $ - $ - $ - $ - $ - $ - $ - $ -
506 Loader $ 43.00 8.0000 0 $ 51.00 $ - $ - $ - $ - $ - $ - $ - $ -
508 Mower/Slasher $ 24.00 2.0000 0 $ 26.00 $ - $ - $ - $ - $ - $ - $ - $ -
509 STEEL ROLLER $ 28.00 5.0000 0 $ 33.00 $ - $ - $ - $ - $ - $ - $ - $ -
511 MULTI TYRE ROLLER $ 28.00 9.0000 0 $ 37.00 $ - $ - $ - $ - $ - $ - $ - $ -
512 ROAD SWEEPER $ 45.00 14.0000 0 $ 59.00 $ - $ - $ - $ - $ - $ - $ - $ -
513 TRACTORS $ 22.00 2.0000 0 $ 24.00 $ - $ - $ - $ - $ - $ - $ - $ -
514 TIP TRUCKS $ 48.00 7.2500 0 $ 55.25 $ - $ - $ - $ - $ - $ - $ - $ -
515 SMALL TRUCKS $ 16.00 6.0000 0 $ 22.00 $ - $ - $ - $ - $ - $ - $ - $ -
516 TREE PLANTER $ 9.00 1.0000 0 $ 10.00 $ - $ - $ - $ - $ - $ - $ - $ -
521 Water Cart Truck $ 35.00 4.0000 4 4 $ 39.00 $ - $ - $ - $ - $ - $ 156.00 $ - $ 156.00
522 Woodchippper $ 35.00 4.0000 0 $ 39.00 $ - $ - $ - $ - $ - $ - $ - $ -
523 Medium Truck(6 Tonne) $ 16.00 3.0000 0 $ 19.00 $ - $ - $ - $ - $ - $ - $ - $ -
524 Skid Steer Loader $ 24.00 5.4400 0 $ 29.44 $ - $ - $ - $ - $ - $ - $ - $ -
525 Supervisors Ute 0 $ - $ - $ - $ - $ - $ - $ - $ - $ -
526 Work Ute 0 $ - $ - $ - $ - $ - $ - $ - $ - $ -
527 Contract side tippers 0.0000 0 $ - $ - $ - $ - $ - $ - $ - $ - $ -
528 Specialised hire equipment 0.0000 0 $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ 42.00 $ 42.00 $ 126.00 $ - $ 324.00 $ - $ 534.00

MATERIAL COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4 5 6 7
Code 2. Topsoil Topsoil
3. Embankment 4. Embankment - 5. Subgrade 6. Forming and Overhead Embankment Embankment Subgrade Forming and TOTAL
(if Description Detail Unit Unit Cost 1. Clearing Removal & 7. Scour Repair TOTAL Hours Unit Cost Clearing Removal & Scour Repair
applicable) - Foundation Construction Preparation Shaping Cost Foundation Construction Preparation Shaping COST
Respread Respread
Mobilisation each $ 10.00 0 10.00 $ - $ - $ - $ - $ - $ - $ - $ -
Formation Layer m3 $ 20.00 1 2 3 4 4 14 20.00 $ - $ 20.00 $ 40.00 $ 60.00 $ - $ 80.00 $ 80.00 $ 280.00
Sub base formation m3 $ 30.00 0 30.00 $ - $ - $ - $ - $ - $ - $ - $ -
Gravel m3 $ 40.00 0 40.00 $ - $ - $ - $ - $ - $ - $ - $ -
Water kl $ 50.00 0 50.00 $ - $ - $ - $ - $ - $ - $ - $ -
Stabilisation m2 $ 60.00 0 60.00 $ - $ - $ - $ - $ - $ - $ - $ -
Chemical Stabilisation kg $ 70.00 0 70.00 $ - $ - $ - $ - $ - $ - $ - $ -
Drainage m $ 80.00 0 80.00 $ - $ - $ - $ - $ - $ - $ - $ -
Bitumen m2 $ 90.00 0 90.00 $ - $ - $ - $ - $ - $ - $ - $ -
Asphalt m2 $ 100.00 0 100.00 $ - $ - $ - $ - $ - $ - $ - $ -
Guide Posts each $ 110.00 0 110.00 $ - $ - $ - $ - $ - $ - $ - $ -
Culverts m $ 120.00 0 120.00 $ - $ - $ - $ - $ - $ - $ - $ -
Concrete m3 $ 130.00 0 130.00 $ - $ - $ - $ - $ - $ - $ - $ -
Reinforcing t $ 140.00 0 140.00 $ - $ - $ - $ - $ - $ - $ - $ -
Job specific $ 150.00 0 150.00 $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ 20.00 $ 40.00 $ 60.00 $ - $ 80.00 $ 80.00 $ 280.00

Labour $ 466.90
Plant $ 534.00
Material $ 280.00

Sub Total $ 1,280.90


<UPDATE WITH ANY LG SUPERVISION PERCENTAGE OR LEAVE BLANK> Supervision Overhead 15%
Supervision $ 192.13
Total $ 1,473.03

Funding
Own Resources
Other
3. PAVEMENT AND SURFACING - WANDRRA WORKS COSTS

Edit cells in orange


Do not edit greyed cells

Road Labour overhead 60% EXAMPLE ONLY - INSERT OVERHEAD PERCENTAGE

LABOUR COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4 5 6 7 8 9 10 11 12
White Lining -
1. Gravel 11. White Lining - Gravel Second Coat White Lining -
4. Extra over for 8. Second Coat 12. White Lining - Extra over for Initial
Labour Hrly Sheeting 10. Initial Wage per Overhead Sheeting First Coat Seal (For Microsurfacin re-instatement TOTAL
Surname Detail Allow Rate Description 2. Sub-base 3. Basecourse Cement 5. Prime 6. Primerseal 7. First Coat Seal Seal (For Reseal 9. Asphalt re-instatement of TOTAL Hours Sub-base Basecourse Cement Prime Primerseal Asphalt SACRIFICIAL
Code Rate (Unsealed Microsurfacing SACRIFICIAL hour Cost (Unsealed Seal Reseal & g of existing COST
Stabilisation & Final Seal) existing lining Stabilisation ONLY
Roads Only) ONLY treatment Roads Only) Final Seal) lining
treatment
WN01 Machine operator 1 MO1 $ 24.69 $ 0.69 1 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WO02 Machine operator 2 MO2 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WP04 Machine operator 3 MO3 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WJ07 Machine operator 4 MO4 $ 27.16 $ 5.29 2 2 $ 32.46 $ 19.47 $ - $ - $ 103.86 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 103.86
WG02 Machine operator 5 MO5 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WG04 Machine operator 6 MO6 $ 24.69 $ 0.69 3 3 $ 25.38 $ 15.23 $ 121.83 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 121.83
WG05 Machine operator 7 MO7 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WG07 Machine operator 8 MO8 $ 23.92 $ 0.69 0 $ 24.61 $ 14.77 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WD06 Machine operator 9 MO9 $ 28.21 $ 2.11 0 $ 30.32 $ 18.19 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WA01 Machine operator 10 MO10 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WW03 Machine operator 11 MO11 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WT07 Machine operator 12 MO12 $ 23.92 $ 0.69 0 $ 24.61 $ 14.77 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 121.83 $ - $ 103.86 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 225.69
PLANT COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4 5 6 7 8 9 10 11 12
White Lining -
1. Gravel 11. White Lining - Gravel Second Coat White Lining -
4. Extra over for 8. Second Coat 12. White Lining - Extra over for Initial
Detail (if Hours Depn Hrs Sheeting 10. Initial Wage per Overhead Sheeting First Coat Seal (For Microsurfacin re-instatement TOTAL
Plant Code Description Description 2. Sub-base 3. Basecourse Cement 5. Prime 6. Primerseal 7. First Coat Seal Seal (For Reseal 9. Asphalt re-instatement of TOTAL Hours Sub-base Basecourse Cement Prime Primerseal Asphalt SACRIFICIAL
required) Rate Rate (Unsealed Microsurfacing SACRIFICIAL hour Cost (Unsealed Seal Reseal & g of existing COST
Stabilisation & Final Seal) existing lining Stabilisation ONLY
Roads Only) ONLY treatment Roads Only) Final Seal) lining
treatment
502 Cherry Picker $ 35.00 7.0000 1 1 3 4 9 $ 42.00 $ 42.00 $ 42.00 $ 126.00 $ - $ 168.00 $ - $ - $ - $ - $ - $ - $ - $ 378.00
503 Graders $ 38.00 7.0000 0 $ 45.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
505 Backhoe $ 32.00 8.3400 0 $ 40.34 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
506 Loader $ 43.00 8.0000 0 $ 51.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
508 Mower/Slasher $ 24.00 2.0000 0 $ 26.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
509 STEEL ROLLER $ 28.00 5.0000 0 $ 33.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
511 MULTI TYRE ROLLER $ 28.00 9.0000 0 $ 37.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
512 ROAD SWEEPER $ 45.00 14.0000 0 $ 59.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
513 TRACTORS $ 22.00 2.0000 0 $ 24.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
514 TIP TRUCKS $ 48.00 7.2500 0 $ 55.25 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
515 SMALL TRUCKS $ 16.00 6.0000 0 $ 22.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
516 TREE PLANTER $ 9.00 1.0000 0 $ 10.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
521 Water Cart Truck $ 35.00 4.0000 0 $ 39.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
522 Woodchippper $ 35.00 4.0000 0 $ 39.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
523 Medium Truck(6 Tonne) $ 16.00 3.0000 0 $ 19.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
524 Skid Steer Loader $ 24.00 5.4400 0 $ 29.44 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
525 Supervisors Ute 0 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
526 Work Ute 0 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
527 Contract side tippers 0.0000 0 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
528 Specialised hire equipment 0.0000 0 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 42.00 $ 42.00 $ 126.00 $ - $ 168.00 $ - $ - $ - $ - $ - $ - $ - $ 378.00

MATERIAL COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4 5 6 7 8 9 10 11 12
White Lining -
1. Gravel 11. White Lining - Gravel Second Coat White Lining -
Code 4. Extra over for 8. Second Coat 12. White Lining - Extra over for Initial
Sheeting 10. Initial Overhead Sheeting First Coat Seal (For Microsurfacin re-instatement TOTAL
(if Description Detail Unit Unit Cost Description 2. Sub-base 3. Basecourse Cement 5. Prime 6. Primerseal 7. First Coat Seal Seal (For Reseal 9. Asphalt re-instatement of TOTAL Hours Unit Cost Sub-base Basecourse Cement Prime Primerseal Asphalt SACRIFICIAL
applicable) (Unsealed Microsurfacing SACRIFICIAL Cost (Unsealed Seal Reseal & g of existing COST
Stabilisation & Final Seal) existing lining Stabilisation ONLY
Roads Only) ONLY treatment Roads Only) Final Seal) lining
treatment
Mobilisation each $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Formation Layer m3 $ 20.00 1 2 3 4 10 20.00 $ 20.00 $ 40.00 $ 60.00 $ - $ - $ - $ - $ - $ - $ - $ - $ 80.00 $ 200.00
Sub base formation m3 $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Gravel m3 $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Water kl $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Stabilisation m2 $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Chemical Stabilisation kg $ 20.00 4 5 9 20.00 $ - $ - $ - $ - $ 80.00 $ 100.00 $ - $ - $ - $ - $ - $ - $ 180.00
Drainage m $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Bitumen m2 $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Asphalt m2 $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Guide Posts each $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Culverts m $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Concrete m3 $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Reinforcing t $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Job specific $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 20.00 $ 40.00 $ 60.00 $ - $ 80.00 $ 100.00 $ - $ - $ - $ - $ - $ 80.00 $ 380.00

Labour $ 225.69
Plant $ 378.00
Material $ 380.00

Sub Total $ 983.69


<UPDATE WITH ANY LG SUPERVISION PERCENTAGE OR LEAVE BLANK> Supervision Overhead 15%
Supervision $ 147.55

Total $ 1,131.25

Funding
Own Resources
Other
4. DRAINAGE - WANDRRA WORKS COSTS
Edit cells in orange
Do not edit greyed cells

Road Labour overhead 60% EXAMPLE ONLY - INSERT OVERHEAD PERCENTAGE

LABOUR COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4 5 6 7 8 9 10 11 12
2. Culvert Inlet 5. Corrugated 6.Reinforced 7. Reinforced Culvert Inlet Corrugated Reinforced Reinforced
Labour Hrly 1. Diversion & 4. Table Drain 8. Culvert End 10. Rock Wage per Overhead Diversion & Table Drain Culvert End Rock TOTAL
Surname Detail Allow Rate Description and Outlet 3. Levees Steel Pipe Concrete Pipe Concrete Box 9. Drainage Pits 11. Kerbing 12. Concrete Wall TOTAL Hours and Outlet Levees Steel Pipe Concrete Pipe Concrete Box Drainage Pits Kerbing Concrete Wall
Code Rate Cut-off Drains Blocks Treatments Protection hour Cost Cut-off Drains Blocks Treatments Protection COST
Drains Culverts Culverts Culverts Drains Culverts Culverts Culverts
WN01 Machine operator 1 MO1 $ 24.69 $ 0.69 1 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WO02 Machine operator 2 MO2 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WP04 Machine operator 3 MO3 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WJ07 Machine operator 4 MO4 $ 27.16 $ 5.29 2 2 $ 32.46 $ 19.47 $ - $ - $ 103.86 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 103.86
WG02 Machine operator 5 MO5 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WG04 Machine operator 6 MO6 $ 24.69 $ 0.69 3 3 $ 25.38 $ 15.23 $ 121.83 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 121.83
WG05 Machine operator 7 MO7 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WG07 Machine operator 8 MO8 $ 23.92 $ 0.69 0 $ 24.61 $ 14.77 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WD06 Machine operator 9 MO9 $ 28.21 $ 2.11 0 $ 30.32 $ 18.19 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WA01 Machine operator 10 MO10 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WW03 Machine operator 11 MO11 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
WT07 Machine operator 12 MO12 $ 23.92 $ 0.69 0 $ 24.61 $ 14.77 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 121.83 $ - $ 103.86 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 225.69
PLANT COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4 5 6 7 8 9 10 11 12

2. Culvert Inlet 5. Corrugated 6.Reinforced 7. Reinforced Culvert Inlet Corrugated Reinforced Reinforced
Detail (if Hours Depn Hrs 1. Diversion & 4. Table Drain 8. Culvert End 10. Rock Wage per Overhead Diversion & Table Drain Culvert End Rock TOTAL
Plant Code Description Description and Outlet 3. Levees Steel Pipe Concrete Pipe Concrete Box 9. Drainage Pits 11. Kerbing 12. Concrete Wall TOTAL Hours and Outlet Levees Steel Pipe Concrete Pipe Concrete Box Drainage Pits Kerbing Concrete Wall
required) Rate Rate Cut-off Drains Blocks Treatments Protection hour Cost Cut-off Drains Blocks Treatments Protection COST
Drains Culverts Culverts Culverts Drains Culverts Culverts Culverts

502 Cherry Picker $ 35.00 7.0000 1 1 3 4 9 $ 42.00 $ 42.00 $ 42.00 $ 126.00 $ - $ 168.00 $ - $ - $ - $ - $ - $ - $ - $ 378.00
503 Graders $ 38.00 7.0000 0 $ 45.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
505 Backhoe $ 32.00 8.3400 0 $ 40.34 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
506 Loader $ 43.00 8.0000 0 $ 51.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
508 Mower/Slasher $ 24.00 2.0000 0 $ 26.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
509 STEEL ROLLER $ 28.00 5.0000 0 $ 33.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
511 MULTI TYRE ROLLER $ 28.00 9.0000 0 $ 37.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
512 ROAD SWEEPER $ 45.00 14.0000 0 $ 59.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
513 TRACTORS $ 22.00 2.0000 0 $ 24.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
514 TIP TRUCKS $ 48.00 7.2500 0 $ 55.25 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
515 SMALL TRUCKS $ 16.00 6.0000 0 $ 22.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
516 TREE PLANTER $ 9.00 1.0000 0 $ 10.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
521 Water Cart Truck $ 35.00 4.0000 0 $ 39.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
522 Woodchippper $ 35.00 4.0000 0 $ 39.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
523 Medium Truck(6 Tonne) $ 16.00 3.0000 0 $ 19.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
524 Skid Steer Loader $ 24.00 5.4400 0 $ 29.44 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
525 Supervisors Ute 0 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
526 Work Ute 0 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
527 Contract side tippers 0.0000 0 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
528 Specialised hire equipment 0.0000 0 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 42.00 $ 42.00 $ 126.00 $ - $ 168.00 $ - $ - $ - $ - $ - $ - $ - $ 378.00

MATERIAL COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4 5 6 7 8 9 10 11 12
Code 2. Culvert Inlet 5. Corrugated 6.Reinforced 7. Reinforced Culvert Inlet Corrugated Reinforced Reinforced
1. Diversion & 4. Table Drain 8. Culvert End 10. Rock Overhead Diversion & Table Drain Culvert End Rock TOTAL
(if Description Detail Unit Unit Cost Description and Outlet 3. Levees Steel Pipe Concrete Pipe Concrete Box 9. Drainage Pits 11. Kerbing 12. Concrete Wall TOTAL Hours Unit Cost and Outlet Levees Steel Pipe Concrete Pipe Concrete Box Drainage Pits Kerbing Concrete Wall
applicable) Cut-off Drains Blocks Treatments Protection Cost Cut-off Drains Blocks Treatments Protection COST
Drains Culverts Culverts Culverts Drains Culverts Culverts Culverts
Mobilisation each 0 0.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Formation Layer m3 $ 20.00 1 2 3 4 10 20.00 $ 20.00 $ 40.00 $ 60.00 $ - $ - $ - $ - $ - $ - $ - $ - $ 80.00 $ 200.00
Sub base formation m3 0 0.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Gravel m3 0 0.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Water kl 0 0.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Stabilisation m2 0 0.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Chemical Stabilisation kg 0 0.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Drainage m 0 0.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Bitumen m2 0 0.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Asphalt m2 0 0.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Guide Posts each 0 0.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Culverts m 0 0.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Concrete m3 0 0.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Reinforcing t 0 0.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
Job specific 0 0.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 20.00 $ 40.00 $ 60.00 $ - $ - $ - $ - $ - $ - $ - $ - $ 80.00 $ 200.00

Labour $ 225.69
Plant $ 378.00
Material $ 200.00

Sub Total $ 803.69


UPDATE WITH ANY LG SUPERVISION PERCENTAGE OR LEAVE BLANK Supervision Overhead 15%
Supervision $ 120.55

Total $ 924.25

Funding
Own Resources
Other
5. MISCELLANEOUS AND SAFETY DEVICES COST BUILD UP - WANDRRA WORKS
Edit cells in orange
Do not edit greyed cells

Road Labour overhead 60% EXAMPLE ONLY - INSERT OVERHEAD PERCENTAGE

LABOUR COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4 5 6 7 Re-
Service
7. Service Re- RRPM (retro
5. RRPM (retro TRAFFIC locations (e.g.
Labour Hrly 1. Signs 6.TRAFFIC locations (e.g. Wage per Overhead Signs Safety raised TOTAL
Surname Detail Allow Rate 2. Guide Posts 3. Stock Grids 4. Safety Barrier raised pavement TOTAL Hours Guide Posts Stock Grids MANAGEME Telstra,
Code Rate WARNING MANAGEMENT Telstra, Western hour Cost WARNING Barrier pavement COST
marker) NT Western
Power) marker)
WN01 Machine operator 1 MO1 $ 24.69 $ 0.69 1 0 $ 25.38 $ 15.23 $ 40.61 $ - $ - $ - $ - $ - $ Power) - $ 40.61
WO02 Machine operator 2 MO2 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ -
WP04 Machine operator 3 MO3 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ -
WJ07 Machine operator 4 MO4 $ 27.16 $ 5.29 2 2 $ 32.46 $ 19.47 $ - $ - $ - $ 103.86 $ - $ - $ - $ 103.86
WG02 Machine operator 5 MO5 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ -
WG04 Machine operator 6 MO6 $ 24.69 $ 0.69 3 3 $ 25.38 $ 15.23 $ - $ 121.83 $ - $ - $ - $ - $ - $ 121.83
WG05 Machine operator 7 MO7 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ -
WG07 Machine operator 8 MO8 $ 23.92 $ 0.69 0 $ 24.61 $ 14.77 $ - $ - $ - $ - $ - $ - $ - $ -
WD06 Machine operator 9 MO9 $ 28.21 $ 2.11 0 $ 30.32 $ 18.19 $ - $ - $ - $ - $ - $ - $ - $ -
WA01 Machine operator 10 MO10 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ -
WW03 Machine operator 11 MO11 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ - $ - $ -
WT07 Machine operator 12 MO12 $ 23.92 $ 0.69 0 $ 24.61 $ 14.77 $ - $ - $ - $ - $ - $ - $ - $ -
$ 40.61 $ 121.83 $ - $ 103.86 $ - $ - $ - $ 266.30
PLANT COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4 5 6 7
Service Re-
7. Service Re- RRPM (retro
5. RRPM (retro TRAFFIC locations (e.g.
Detail (if Hours Depn Hrs 1. Signs 6.TRAFFIC locations (e.g. Wage per Overhead Signs Safety raised TOTAL
Plant Code Description 2. Guide Posts 3. Stock Grids 4. Safety Barrier raised pavement TOTAL Hours Guide Posts Stock Grids MANAGEME Telstra,
required) Rate Rate WARNING MANAGEMENT Telstra, Western hour Cost WARNING Barrier pavement COST
marker) NT Western
Power) marker)
$ 35.00 1 1 3 4 9 $ 42.00 $ - $ 42.00 $ 42.00 $ 126.00 $ - $ 168.00 $ Power) - $ 378.00
502 Cherry Picker 7.0000
503 Graders $ 38.00 7.0000 0 $ 45.00 $ - $ - $ - $ - $ - $ - $ - $ -
505 Backhoe $ 32.00 8.3400 0 $ 40.34 $ - $ - $ - $ - $ - $ - $ - $ -
506 Loader $ 43.00 8.0000 0 $ 51.00 $ - $ - $ - $ - $ - $ - $ - $ -
508 Mower/Slasher $ 24.00 2.0000 0 $ 26.00 $ - $ - $ - $ - $ - $ - $ - $ -
509 STEEL ROLLER $ 28.00 5.0000 0 $ 33.00 $ - $ - $ - $ - $ - $ - $ - $ -
511 MULTI TYRE ROLLER $ 28.00 9.0000 0 $ 37.00 $ - $ - $ - $ - $ - $ - $ - $ -
512 ROAD SWEEPER $ 45.00 14.0000 0 $ 59.00 $ - $ - $ - $ - $ - $ - $ - $ -
513 TRACTORS $ 22.00 2.0000 0 $ 24.00 $ - $ - $ - $ - $ - $ - $ - $ -
514 TIP TRUCKS $ 48.00 7.2500 0 $ 55.25 $ - $ - $ - $ - $ - $ - $ - $ -
515 SMALL TRUCKS $ 16.00 6.0000 0 $ 22.00 $ - $ - $ - $ - $ - $ - $ - $ -
516 TREE PLANTER $ 9.00 1.0000 0 $ 10.00 $ - $ - $ - $ - $ - $ - $ - $ -
521 Water Cart Truck $ 35.00 4.0000 0 $ 39.00 $ - $ - $ - $ - $ - $ - $ - $ -
522 Woodchippper $ 35.00 4.0000 0 $ 39.00 $ - $ - $ - $ - $ - $ - $ - $ -
523 Medium Truck(6 Tonne) $ 16.00 3.0000 0 $ 19.00 $ - $ - $ - $ - $ - $ - $ - $ -
524 Skid Steer Loader $ 24.00 5.4400 0 $ 29.44 $ - $ - $ - $ - $ - $ - $ - $ -
525 Supervisors Ute 0 $ - $ - $ - $ - $ - $ - $ - $ - $ -
526 Work Ute 0 $ - $ - $ - $ - $ - $ - $ - $ - $ -
527 Contract side tippers 0.0000 0 $ - $ - $ - $ - $ - $ - $ - $ - $ -
528 Specialised hire equipment 0.0000 0 $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ 42.00 $ 42.00 $ 126.00 $ - $ 168.00 $ - $ 378.00

MATERIAL COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4 5 6 7
Service Re-
7. Service Re- RRPM (retro
Code 5. RRPM (retro TRAFFIC locations (e.g.
1. Signs 6.TRAFFIC locations (e.g. Overhead Signs Safety raised TOTAL
(if Description Detail Unit Unit Cost 2. Guide Posts 3. Stock Grids 4. Safety Barrier raised pavement TOTAL Hours Unit Cost Guide Posts Stock Grids MANAGEME Telstra,
applicable) WARNING MANAGEMENT Telstra, Western Cost WARNING Barrier pavement COST
marker) NT Western
Power) marker)
Power)
Mobilisation each $ 10.00 0 10.00 $ - $ - $ - $ - $ - $ - $ - $ -
Formation Layer m3 $ 20.00 1 2 3 4 10 20.00 $ - $ 20.00 $ 40.00 $ 60.00 $ - $ - $ 80.00 $ 200.00
Sub base formation m3 $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ -
Gravel m3 $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ -
Water kl $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ -
Stabilisation m2 $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ -
Chemical Stabilisation kg $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ -
Drainage m $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ -
Bitumen m2 $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ -
Asphalt m2 $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ -
Guide Posts each $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ -
Culverts m $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ -
Concrete m3 $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ -
Reinforcing t $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ -
Job specific $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ 20.00 $ 40.00 $ 60.00 $ - $ - $ 80.00 $ 200.00

Labour $ 266.30
Plant $ 378.00
Material $ 200.00

Sub Total $ 844.30


UPDATE WITH ANY LG SUPERVISION PERCENTAGE OR LEAVE BLANK Supervision Overhead 15%
Supervision $ 126.65
Total $ 970.95

Funding
Own Resources
Other
6. CONSTRUCTION COST BUILD UP - WANDRRA WORKS
Edit cells in orange
Do not edit greyed cells

Road Labour overhead 60% EXAMPLE ONLY - INSERT OVERHEAD PERCENTAGE

LABOUR COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4 5
5. Miscellaneous Miscellaneous
Labour Hrly 3. Pavement & Wage per Overhead Pavement & TOTAL
Surname Detail Allow Rate 1. General Items 2. Earthworks 4. Drainage and Safety TOTAL Hours General Items Earthworks Drainage and Safety
Code Rate Surfacing hour Cost Surfacing COST
Devices Devices
WN01 Machine operator 1 MO1 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ -
WO02 Machine operator 2 MO2 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ -
WP04 Machine operator 3 MO3 $ 24.69 $ 0.69 2 2 $ 25.38 $ 15.23 $ - $ 81.22 $ - $ - $ - $ 81.22
WJ07 Machine operator 4 MO4 $ 27.16 $ 5.29 4 4 $ 32.46 $ 19.47 $ - $ - $ - $ - $ 207.72 $ 207.72
WG02 Machine operator 5 MO5 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ -
WG04 Machine operator 6 MO6 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ -
WG05 Machine operator 7 MO7 $ 24.69 $ 0.69 3 3 $ 25.38 $ 15.23 $ - $ - $ - $ 121.83 $ - $ 121.83
WG07 Machine operator 8 MO8 $ 23.92 $ 0.69 0 $ 24.61 $ 14.77 $ - $ - $ - $ - $ - $ -
WD06 Machine operator 9 MO9 $ 28.21 $ 2.11 0 $ 30.32 $ 18.19 $ - $ - $ - $ - $ - $ -
WA01 Machine operator 10 MO10 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ -
WW03 Machine operator 11 MO11 $ 24.69 $ 0.69 0 $ 25.38 $ 15.23 $ - $ - $ - $ - $ - $ -
WT07 Machine operator 12 MO12 $ 23.92 $ 0.69 0 $ 24.61 $ 14.77 $ - $ - $ - $ - $ - $ -
$ - $ 81.22 $ - $ 121.83 $ 207.72 $ 410.78
PLANT COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4 7
5. Miscellaneous Miscellaneous
Detail (if Hours Depn Hrs 3. Pavement & Wage per Overhead Pavement & TOTAL
Plant Code Description 1. General Items 2. Earthworks 4. Drainage and Safety TOTAL Hours General Items Earthworks Drainage and Safety
required) Rate Rate Surfacing hour Cost Surfacing COST
Devices Devices
502 Cherry Picker $ 35.00 7.0000 0 $ 42.00 $ - $ - $ - $ - $ - $ -
503 Graders $ 38.00 7.0000 0 $ 45.00 $ - $ - $ - $ - $ - $ -
505 Backhoe $ 32.00 8.3400 0 $ 40.34 $ - $ - $ - $ - $ - $ -
506 Loader $ 43.00 8.0000 2 2 $ 51.00 $ - $ 102.00 $ - $ - $ - $ 102.00
508 Mower/Slasher $ 24.00 2.0000 0 $ 26.00 $ - $ - $ - $ - $ - $ -
509 STEEL ROLLER $ 28.00 5.0000 4 4 $ 33.00 $ - $ - $ - $ - $ 132.00 $ 132.00
511 MULTI TYRE ROLLER $ 28.00 9.0000 0 $ 37.00 $ - $ - $ - $ - $ - $ -
512 ROAD SWEEPER $ 45.00 14.0000 0 $ 59.00 $ - $ - $ - $ - $ - $ -
513 TRACTORS $ 22.00 2.0000 0 $ 24.00 $ - $ - $ - $ - $ - $ -
514 TIP TRUCKS $ 48.00 7.2500 0 $ 55.25 $ - $ - $ - $ - $ - $ -
515 SMALL TRUCKS $ 16.00 6.0000 0 $ 22.00 $ - $ - $ - $ - $ - $ -
516 TREE PLANTER $ 9.00 1.0000 3 3 $ 10.00 $ - $ - $ 30.00 $ - $ - $ 30.00
521 Water Cart Truck $ 35.00 4.0000 0 $ 39.00 $ - $ - $ - $ - $ - $ -
522 Woodchippper $ 35.00 4.0000 0 $ 39.00 $ - $ - $ - $ - $ - $ -
523 Medium Truck(6 Tonne) $ 16.00 3.0000 0 $ 19.00 $ - $ - $ - $ - $ - $ -
524 Skid Steer Loader $ 24.00 5.4400 0 $ 29.44 $ - $ - $ - $ - $ - $ -
525 Supervisors Ute 0 $ - $ - $ - $ - $ - $ - $ -
526 Work Ute 0 $ - $ - $ - $ - $ - $ - $ -
527 Contract side tippers 0.0000 0 $ - $ - $ - $ - $ - $ - $ -
528 Specialised hire equipment 0.0000 0 $ - $ - $ - $ - $ - $ - $ -
$ - $ 102.00 $ 30.00 $ - $ 132.00 $ 264.00

MATERIAL COSTS
UPDATE ALL RATES, CATEGORIES AND HOURS IN THIS SECTION TO MEET LG SPECIFICS DO NOT EDIT - CALCULATES ALL COSTS PER CATEGORY AS REQUIRED BY SUMMARY SPREADSHEET
HOURS PER CATEGORY 1 2 3 4 7
Code 5. Miscellaneous Miscellaneous
3. Pavement & Overhead Pavement & TOTAL
(if Description Detail Unit Unit Cost 1. General Items 2. Earthworks 4. Drainage and Safety TOTAL Hours Unit Cost General Items Earthworks Drainage and Safety
applicable) Surfacing Cost Surfacing COST
Devices Devices
Mobilisation each $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ -
Formation Layer m3 $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ -
Sub base formation m3 $ 20.00 4 4 20.00 $ - $ - $ - $ - $ 80.00 $ 80.00
Gravel m3 $ 20.00 2 2 20.00 $ - $ 40.00 $ - $ - $ - $ 40.00
Water kl $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ -
Stabilisation m2 $ 20.00 3 3 20.00 $ - $ - $ - $ 60.00 $ - $ 60.00
Chemical Stabilisation kg $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ -
Drainage m $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ -
Bitumen m2 $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ -
Asphalt m2 $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ -
Guide Posts each $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ -
Culverts m $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ -
Concrete m3 $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ -
Reinforcing t $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ -
Job specific $ 20.00 0 20.00 $ - $ - $ - $ - $ - $ -
$ - $ 40.00 $ - $ 60.00 $ 80.00 $ 180.00

$ 410.78
$ 264.00
$ 180.00

$ 854.78
<UPDATE WITH ANY LG SUPERVISION PERCENTAGE OR LEAVE BLANK> 15%
$ 128.22

$ 982.99

You might also like