Spreadsheet: 752299d1634695982-using-sumifs-on-an-offset-range-of-cells-plastik-mac-mto-workbook
Sheet: 3.0 Quote Sheet

Project Name |  | Date:
Contact |  | Author
Phone |  | Quote #
[NAME]
Hours Per Day | 12 | Labour |  | Equipment |  | Materials |  |  |  |  |  |  |  |  |  | Cost |  |  |  | Sell |  |  |  | %GM
 | Day effective hrs = 9 | Man Days | Type | Days | Type | Qty | UOM | Item | Size | Rating | Description | Unit Cost | %GM |  |  | Materials | Labour | Equipment | TOTAL | Materials | Labour | Equipment | TOTAL |  |  | Man Hours
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indirect | Direct |  | Summary Totals | Rate
1 | Preliminaries |  |  |  |  |  |  |  |  |  |  |  |  | Labour Cost ea | Equip Cost ea
2 | Design |  |  |  |  |  |  |  |  |  |  |  |  | Labour Cost ea | Equip Cost ea
3 | Mobilisation/ Site Establishment |  |  |  |  |  |  |  |  |  |  |  |  | Labour Cost ea | Equip Cost ea
 |  |  |  |  |  | 4 | ea |  |  |  | Flights Perth - Newman | 500 | 0.15
 |  |  |  |  |  | 1 | lot |  |  |  | Temp Fence - Onsite | 2645.5 | 0.15
 |  |  |  |  |  | 1 | lot |  |  |  | [NAME] | 1500 | 0.15
4 | Project Management |  |  |  |  |  |  |  |  |  |  |  |  | Labour Cost ea | Equip Cost ea
5 | Supply 0.7m3/hr Bore Pump & install |  |  |  |  |  |  |  |  |  |  |  |  | Labour Cost ea | Equip Cost ea
 |  |  |  |  |  |  | ea |  |  |  | Headworks Concrete Blocks 400 x  600 x 150 | 200 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | Solar bore Pump HR-04H, Headworks Powerpack | 11200.5 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | Post for [NAME] (with cap) | 50 | 0.15
 |  |  |  |  |  | 9 | ea |  |  |  | 20kg Quickset Concrete | 10 | 0.15
 |  |  |  |  |  | 2 | ea |  |  |  | 25mm Orange conduit | 6.5 | 0.15
 |  |  |  |  |  | 2 | ea |  |  |  | 25mm Orange elbows | 3.8 | 0.15
6 | Task Description |  |  |  |  |  |  |  |  |  |  |  |  | Labour Cost ea | Equip Cost ea
 |  |  |  |  |  | 1 | ea |  |  |  | DN32 [NAME] | 30 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | DN32 Table E Backing Rings | 13 | 0.15
 |  |  |  |  |  | 4 | ea |  |  |  | M12 x 40mm Galv bolts/ washers | 0.8 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | Victaulic Style 741 DN150 flange adapter | 122.1 | 0.15
 |  |  |  |  |  | 2 | ea |  |  |  | DN160 Flange Stubs | 30 | 0.15
 |  |  |  |  |  | 2 | ea |  |  |  | DN160 Table E backing ring | 26.03 | 0.15
 |  |  |  |  |  | 2 | ea |  |  |  | DN160 90Deg elbows | 35 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | DN150 Gasket | 15 | 0.15
 |  |  |  |  |  | 8 | ea |  |  |  | M20x90 galv bolts nnuts | 1.65 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | [NAME], DN160/90 | 42 | 0.15
 |  |  |  |  |  | 2 | ea |  |  |  | [NAME], DN90/50 | 9.57 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | [NAME], DN50/32 | 6 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | CS-F4-3 Surface Pump + Powerpack | 9865.28 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | for mounting Pump | 200 | 0.15
 |  |  |  |  |  | 4 | ea |  |  |  | Chemset bolts | 8 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | Chemset Tube | 40 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | Post for [NAME] (with cap) | 50 | 0.15
 |  |  |  |  |  | 10 | ea |  |  |  | 20kg Quickset Concrete | 10 | 0.15
 |  |  |  |  |  | 2 | ea |  |  |  | 25mm Orange conduit | 6.5 | 0.15
 |  |  |  |  |  | 2 | ea |  |  |  | 25mm Orange elbows | 3.8 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | DN50 table E HDPE Flange stub | 20 | 0.15
7 | Task Description |  |  |  |  |  |  |  |  |  |  |  |  | Labour Cost ea | Equip Cost ea
 |  |  |  |  |  | 1 | ea |  |  |  | DN110 x 100m roll PN10 White | 988.05 | 0.15
 |  |  |  |  |  | 2 | ea |  |  |  | DN110 [NAME] | 9.85 | 0.15
 |  |  |  |  |  | 2 | ea |  |  |  | DN110 Backing ring | 13.51 | 0.15
 |  |  |  |  |  | 16 | ea |  |  |  | M16 x 70 8.8 Bolts/ N/ W | 0.8 | 0.15
 |  |  |  |  |  | 2 | ea |  |  |  | DN110 Gasket | 8.74 | 0.15
 |  |  |  |  |  | 3 | ea |  |  |  | DN110 90 deg elbow PN10 | 26.95 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | Victaulic Type 741 [NAME], 110mm | 75 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | DN110/ 50 reducer | 30 | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.15
8 | Task Description |  |  |  |  |  |  |  |  |  |  |  |  | Labour Cost ea | Equip Cost ea
 |  |  |  |  |  | 1 | ea |  |  |  | 3" [NAME], female BSP | 40 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | [NAME] Valve | 120 | 0.15
 |  |  |  |  |  | 1 | ea | DN90/50 Reducer |  | HDPE | [NAME], DN90/50 | 9.57 | 0.15
 |  |  |  |  |  | 1 | ea | DN50/32 [NAME] |  | HDPE | [NAME], DN50/32 | 6 | 0.15
 |  |  |  |  |  | 2 | ea |  |  |  | DN110 90 deg elbow PN10 | 26.95 | 0.15
 |  |  |  |  |  | 1 | ea | DN32 |  | HDPE | DN32 [NAME] | 30 | 0.15
 |  |  |  |  |  | 1 | ea | DN32 |  | Steel | DN32 Table E Backing Rings | 13 | 0.15
 |  |  |  |  |  | 4 | ea | M12 x 40 | for 32[NAME] flanges |  | M12 x 40mm Galv bolts/ washers | 0.8 | 0.15
 |  |  |  |  |  | 1 | ea | 40 x 40 |  |  | Unistrut Channel | 88 | 0.15
 |  |  |  |  |  | 1 | ea | 110mm |  |  | Unistrut 110 Pipe Clamp & Bolts | 20 | 0.15
 |  |  |  |  |  | 2 | ea |  |  | 20kg | 20kg Rapid Set Concrete | 10 | 0.15
 |  |  |  |  |  | 3 | ea |  |  |  | DN110 [NAME] | 9.85 | 0.15
 |  |  |  |  |  | 3 | ea |  |  |  | DN110 Backing ring | 13.51 | 0.15
 |  |  |  |  |  | 24 | ea |  |  |  | M16 x 70 8.8 Bolts/ N/ W | 0.8 | 0.15
 |  |  |  |  |  | 3 | ea |  |  |  | DN110 Gasket | 8.74 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | Flange DN100 Table E, 3" Male Spigot | 80 | 0.15
 |  |  |  |  |  | 2 | m3 |  |  |  | River Sand | 90 | 0.15
9 | Task Description |  |  |  |  |  |  |  |  |  |  |  |  | Labour Cost ea | Equip Cost ea
 |  |  |  |  |  | 1 | ea |  |  |  | Supply & Install 130kl Tank | 30300 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | Dn150 B/fly Valve Table E | 143 | 0.15
 |  |  |  |  |  | 8 | ea |  |  |  | M20 x 65 Bolt/ nut/ washer 8.8 | 1.5 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | DN160 Gasket Table E | 14.26 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | Victaulic Type 741 [NAME], 150mm | 122.1 | 0.15
10 | Task Description |  |  |  |  |  |  |  |  |  |  |  |  | Labour Cost ea | Equip Cost ea
 |  |  |  |  |  | 1 | lot |  |  |  | 6m x 6m Fence, 1 x 3m gate | 9594 | 0.15
11 | Task Description |  |  |  |  |  |  |  |  |  |  |  |  | Labour Cost ea | Equip Cost ea
 |  |  |  |  |  | 1 | lot |  |  |  | 12m x 12m, 2 x 3m gates. 1 x PA gate | 18820 | 0.15
12 | Task Description |  |  |  |  |  |  |  |  |  |  |  |  | Labour Cost ea | Equip Cost ea
 |  |  |  |  |  | 1 | roll |  |  |  | DN50 Blueline HDPE ACU-Water PN12.5 | 184.38 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | DN50 Rural compression tee | 53.15 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | DN50 rural compression male 2"bsp | 40 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | 50mm Ball valve SS flanged | 212.5 | 0.15
 |  |  |  |  |  | 1 | ea |  |  |  | DN50 Blind flange Table E, 50mm socket | 80 | 0.15
 |  |  |  |  |  | 2 | ea |  |  |  | DN50 table E gaskets | 10 | 0.15
 |  |  |  |  |  | 8 | ea |  |  |  | M12 x 40 8.8 [NAME]/n/w | 4 | 0.15
13 | Task Description |  |  |  |  |  |  |  |  |  |  |  |  | Labour Cost ea | Equip Cost ea
 | Allow for 1 day to commission the Bore and Pump | 1 | Leading Hand | 1.5 | Light Vehicle 4 WD
 | Allow half day for training | 0.5 | Leading Hand
14 | Task Description |  |  |  |  |  |  |  |  |  |  |  |  | Labour Cost ea | Equip Cost ea
 | De-Mobilisation: 6 hrs flights | 0.6 | Welders | 2 | Prime Mover/Trailer/Extendable | 5 | ea |  |  |  | Flights Perth - Newman | 500
 |  | 0.6 | Leading Hand
 |  | 2 | Plant Operators
 |  | 0.6 | Electrician
 | Site Clean up | 0.5 | Welders |  | Skid Steer Loader c/w Auger
 |  |  | Leading Hand |  | Light Vehicle 4 WD
 |  |  | Plant Operators
15 | Task Description |  |  |  |  |  |  |  |  |  |  |  |  | Labour Cost ea | Equip Cost ea