Spreadsheet: 118642d1313821119-shorten-formula-to-avoid-maxing-of-cpu-master-budget
Sheet: Practical Completion

CODE | ITEM | Supplier | 0 | COST |  | ACTUAL COST | INC B/M | GST Amt | TOTAL INC GST | CODE TOTAL
52250 | PAINTER | Painter | 1 | 21000 | quote
52253 | SANDING AND POLISHING
52253 |  |  |  | 14 | m2
52253 |  |  | 0 | 30 | m2
52253 |  |  | 0 | 30 | tread
52253 |  |  | 0 | 30 | tread
52254 | SUNDRY FLOOR COVERINGS
52254 | carpet |  | 152 | 25 | m2
52254 | Vinyl |  | 0 | 58 | m
52254 | [NAME] |  | 0 | 75 | m2
52254 | Parquetry Floor Complete |  | 0 | 75 | m2
52254 |  |  | 0 | 60 | m3
52255 | CLEANING
51650 | Progressive Site Clean |  | 0 | 80 | hour
52255 | Final Internal House Clean |  | 1 | 1000 | proj
52255 | Final External House Clean |  | 1 | 500 | proj
51660 | DRIVEWAY
51660 | Concrete Driveway & Paths |  | 35 | 90 | m2
51660 | Carport Grate |  | 0 | 41 | Lm
51660 | [NAME] |  | 0 | 110 | m2
51660 | Linemarking (car space) |  | 0 | 10 | space
56000 | Minimum Cartage |  | 0 | 43.85 | m2
 | Landscaping Allowance
51660 | Retaining Wall |  | 0 | 90 | m2
51660 | Socked Aggi pipe |  | 0 | 5 | Lm
51660 | Fence (CCA HWD 1800*3 Rail) |  | 0 | 60 | Lm
51660 | Gates |  | 0 | 120 | each
51660 | Turf 2nd Grade |  | 0 | 2 | m2
51660 | Plants |  | 0 | 5 | each
51660 | Pine Bark |  | 0 | 26 | m3
51660 | Landscape Soil Mix |  | 0 | 30 | m2
51660 | Sleepers CCA Treated 200*50(Building grade) |  | 0 | 11.35 | Lm
51660 | Sleepers CCA Treated 200*50 |  | 0 | 6.75 | Lm
51660 | Sleepers CCA Treated 200*75 |  | 0 | 8.5 | Lm
51660 | Pavers |  | 0 | 30 | m2
52257 | [NAME] |  | 0 | 1 | 0
52257 | Labour |  | 0 | 25 | hour
52257 | Pool pebble crete |  | 0 | 4500 | quote
51670 | HARDWARE
 | General [NAME]
51670 | [NAME] |  | 6 | 25 | box
51670 | Chipboard screws (1000) |  | 4 | 33 | box
51670 | DA21 50mm Gal Finish |  | 1 | 39 | box
51670 | DA17 38mm Gal Finish |  | 1 | 30 | box
51670 | Chemset dual pack |  | 1 | 65 | 5kg
51670 | Tripple grip |  | 0 | 0.5 | 2kg
51670 | [NAME] |  | 30 | 10.87 | 5kg
51670 | Coil nails |  | 25 | 6.46 | 5kg
51670 | Charges for powergun |  | 5 | 19.96 | 5kg
51670 | drive pins |  | 1 | 36.51 | box
51670 | Deliverys |  | 5 | 54.55 | each
51670 | 75*3.15 B/Head [NAME] |  | 0 | 30 | box
51670 | 75*3.75 B/H Galv |  | 0 | 40 | 5kg
51670 | 30*2.8 Clouts |  | 1 | 35 | 2kg
51670 | Joist [NAME] 38*139 |  | 0 | 1.5 | each
51670 | Joist [NAME]*70 |  | 0 | 3.45 | each
51670 | Joist [NAME]*70 Top Mount |  | 0 | 4.65 | each
51670 | Triple Grips LH |  | 50 | 0.45 | each
51670 | Triple Grips RH |  | 50 | 0.45 | each
51670 | Multi Grips |  | 0 | 0.38 | each
51670 | T17 14*75 [NAME] |  | 0 | 85 | box
51670 | 75mm gal [NAME] |  | 0 | 0.24 | each
51670 | 100mm  [NAME] |  | 0 | 0.26 | each
51670 | 10mm*150 [NAME] |  | 0 | 13 | each
51670 | Sikabond |  | 0 | 11 | each
51670 | [NAME] 1/8 |  | 2 | 12.5 | each
51670 | [NAME] Pk5 |  | 0 | 6.72 | pkt
51670 | 230*25 C.O Wheels |  | 0 | 13.5 | each
51670 | 4" Metal Cut Off |  | 20 | 2.9 | each
51671 | Sabre Saw Blades |  | 0 | 8.5 | each
51670 | 4" Metal Grind |  | 0 | 2.9 | each
51670 | Builders Cement |  | 0 | 12 | bag
51670 | Yellow Crayons x 12 |  | 2 | 15 | pack
51670 | Pencils |  | 25 | 2 | each
51670 | [NAME] x 5 |  | 2 | 10 | pack
51670 | Liquid Nails |  | 0 | 4 | tube
51670 | Silcone |  | 0 | 6.75 | tube
51670 | Sikaflex |  | 0 | 22 | tube
51670 | Turpentine 4 Lt |  | 1 | 12 | each
51670 | Foam Fire Retardant |  | 0 | 20 | each
 | Wall Framing Hardware |  | 0
51670 | Epoxy Chemical set tube |  | 2 | 45 | each
51670 | Anchor swiftscrew 12mm x 80 mm |  | 0 | 2.5 | each
51670 | Galv rod for  Chemset |  | 0 | 30 | item
51670 | Hoop Iron Straps 50m*30mm |  | 0 | 35 | roll
51670 | Viscourse 300mm Polycourse |  | 0 | 0.5 | Lm
51670 | Std Framing Bracket 150*150*6 |  | 0 | 8.5 | each
51670 |  |  | 0 | 0.85 | m
51670 | Starter Bars 100*150 |  | 0 | 1.55 | each
51670 | M12 Cyclone Rods (2.4) |  | 0 | 5 | each
51670 | M12 Cyclone Rods (2.7) |  | 0 | 5.5 | each
51670 | M12 Cyclone Rods (3.0) |  | 120 | 5.9 | each
51670 | M12 Cyclone Rods (3.6) |  | 0 | 6.8 | each
51670 | [NAME] (3.0) |  | 0 | 27 | each
51670 | M20 Cyclone Rods (3.0) |  | 0 | 39 | each
51670 | Connector [NAME] 12mm ZP |  | 50 | 0.98 | each
51670 | Connector [NAME] 16mm ZP |  | 0 | 0.8 | each
51670 | Square Washers 50*50*3 ZP 12mm |  | 100 | 0.59 | each
51670 | Hex Nuts 12mm ZP |  | 100 | 0.18 | each
51670 | Hex Nuts & washer 16mm ZP |  | 0 | 0.6 | each
51670 | Round Washers 12mm ZP |  | 0 | 0.2 | each
51670 | Bolts General Allowance |  | 0 | 500 | item
51670 | Dyna Screw 10*100 |  | 0 | 4.15 | each
51670 | Dyna Screw 12*100 |  | 0 | 5 | each
51670 | Coach Screws General Allowance |  | 0 | 500 | item
51670 | [NAME] 100mm |  | 0 | 0.19 | each
51670 | Red Charges (100 per box) |  | 0 | 22 | each
51670 | Ramset Gun Nails (100 per box) |  | 0 | 45 | each
51670 | [NAME] to Slab |  | 0 | 2.2 | m
51670 | Coil Nails |  | 0 | 9 | roll
51670 | Structural Ply |  | 0 | 3 | m2
51670 | Ply Brace 3000*1200 |  | 15 | 32 | sheet
51670 | Ply Brace 3000*900 |  | 0 | 25 | sheet
51670 | Ply Brace 2700*900 |  | 0 | 20 | sheet
51670 | Ply Brace 2700*1200 |  | 0 | 26 | sheet
51670 | Ply Brace 2400*1200 |  | 0 | 22 | sheet
51670 | Ply Brace 2400*900 |  | 0 | 16 | sheet
51670 | T Nails |  | 0 | 25 | box
51670 | Decking Nails |  | 0 | 65 | box
51670 | 3 Tread Steel Stringers |  | 0 | 180 | pair
51670 | 5 Tread Steel Stringers |  | 0 | 225 | pair
51670 | 6 Tread Steel Stringers |  | 0 | 240 | item
51670 | 7 Tread Steel Stringers |  | 0 | 260 | item
51670 | 8 Tread Steel Stringers |  | 0 | 10 | item
51670 |  |  | 0 | 9 | item
57000 | HIRE EQUIPMENT
57000 | Secret [NAME] |  | 0 | 55 | day
57000 | [NAME] |  | 0 | 12 | day
57000 | Straight Drop Chemical Toilet |  | 23 | 30 | week
57000 | -  Pump out fee |  | 10 | 60 | time
57000 | - Pick up and delivery |  | 1 | 40 | time
57000 | Tresells (per week) |  | 0 | 42 | pair
57000 | Fencing (p w) 2.4 bay |  | 13 |  | each
57000 | Planks (p w) |  | 0 | 25 | each
57000 | Scaffold |  | 0 | 75 | item
57000 | Hammer Drill |  | 0 | 80 | item
57000 | Sundry Hire |  | 0 | 350 | item
57000 | Mobile [NAME] |  | 0 | 180 | week
51640 | WHITE GOODS |  |  |  | PC
51640 | Rangehood |  | 0 | 1500 | each
51640 | Oven |  | 0 | 1800 | each
51640 | Cookcop |  | 0 | 1100 | each
51640 | Dishwasher |  | 0 | 1600 | each
51640 |  |  | 0 | 0 | each
51640 | SPECIFIED ITEMS
51640 | TV Antenna UHF & VHF & Pay TV |  | 1 | 500 | each
51640 | Paraline Washing Line |  | 0 | 140 | each
51640 | Effluent System |  | 0 | 9500 | each
51640 | Skylite Vented 600*600 |  | 0 | 1 | each
51640 | [NAME] |  | 0 | 1572 | each
51640 | [NAME] |  | 0 | 300 | each
51640 | Fireplaces x 2 |  | 0 | 5025 | quote
51640 | Security System |  | 0 | 1500 | item
51640 | Drying Courtyard |  | 0 | 890 | item
51640 | [NAME] |  | 1 | 40 | each
51640 | Pest Control |  | 0 | 120 | item
51640 | Telstra Connection |  | 0 | 500 | item
51640 | Water Tank 10000g Concrete |  | 0 | 4500 | each
51640 | Tank Excavation |  | 0 | 720 | each
51640 | Davey XJ Ultra Pressure Pump |  | 0 | 850 | each
51640 |  |  | 0 | 550 | each
52225 | Supply & Fit Air Conditioning |  | 0
52225 | [NAME] |  | 0 | 1500 | each
52225 |  |  | 0 | 1 | each
52227 | SUPERVISION
52227 | Supervision of Project |  | 0 | 40 | hour
52227 | Final Handover |  | 10 | 42 | hour
52227 | Six Monthly Maintenance |  | 10 | 42 | hour
 | Practical Completion Totals
NOTES
1