Spreadsheet: 857741d1706671275-solve-for-multiple-objective-cells-in-solver-sff-2024-solver-copy
Sheet: Building Data

Items | Qty | Unit | Rate ($) | Value ($) | Next Due | Total Life | Comments
Building Data List
Items | Qty | Unit | Rate ($) | Value ($) | Next Due | Total Life | Comments
1. COMMON BUILDING EXTERIORS
Repaint building exteriors | 90 | m2 | 36.05 | 3245 | 1 | 8 | Ongoing painting program
Repaint fascia and gutter - common property infrastructure | 45 | lm | 25.75 | 1159 | 1 | 8 | Ongoing painting program
Inspect and repair fascia and gutter (total: 2300 lm) | 230 | lm | 56.65 | 13030 | 1 | 5 | Inspect and repair as required - units
Repaint downpipes | 13 | lm | 18.54 | 241 | 1 | 8 | Ongoing painting program
Repair or replace downpipes (total 1300 lm) | 130 | lm | 36.05 | 4687 | 1 | 5 | Inspect and repair as required
Repaint door face – one side | 5 | ea | 89.61 | 448 | 1 | 8 | Includes architrave
Replace roof tiles (total: 42 m2) | 8 | m2 | 66.95 | 536 | 4 | 6 | Replace as required
Re-bed and re-point ridge caps | 10 | lm | 113.3 | 1133 | 4 | 16 | Inspect and repair as required
Repair metal roof | 6 | m2 | 88.58 | 531 | 4 | 7 | Repair as required
2. EXTERNAL WALKWAYS
Maintain concrete pathways | 151 | m2 | 10.3 | 1555 | 1 | 5 | Clean and repair as required
3. DRIVEWAY
Maintain concrete driveway and car park areas | 918 | m2 | 4.12 | 3782 | 1 | 5 | Clean and repair as required
Repaint line marking | 154 | lm | 12.36 | 1903 | 1 | 5 | Repaint as required
Maintain paving (total: 1431 m2) | 122 | m2 | 89.61 | 10932 | 5 | 6 | Repair as required
Replace paved driveways - 60% 5 year replacement program (Year 4 of project) | 1 | Item | 34941.72 | 34942 | 1 | 0 | Repair as required
Replace paved driveways - 60% 5 year replacement program (Year 5 of project) | 1 | Item | 34941.72 | 34942 | 2 | 0 | Repair as required
Topcoat bitumen driveway | 2077 | m2 | 36.05 | 74876 | 3 | 12 | Reseal as required
Topcoat bitumen driveway | 2077 | m2 | 36.05 | 74876 | 5 | 12 | Reseal as required
Topcoat bitumen driveway | 2077 | m2 | 36.05 | 74876 | 7 | 12 | Reseal as required
Repair bitumen driveway (total: 6232 m2) | 100 | m2 | 154.5 | 15450 | 7 | 2 | Repair damaged sections
Replace plastic wheel stops (total: 17) | 2 | ea | 190.55 | 381 | 2 | 3 | Replace as required - accumulative
Replace timber bollards (total: 15) | 5 | ea | 113.3 | 567 | 2 | 5 | Replace as required
Repair concrete kerbing (total: 1944 lm) | 97 | lm | 56.65 | 5495 | 1 | 5 | Repair damaged sections
Replace curved stainless safety mirror | 2 | ea | 669.5 | 1339 | 10 | 10 | Replace as required
Highlight speed bumps | 12 | ea | 118.45 | 1421 | 1 | 5 | Highlight as required
Replace stormwater grates (total: 20) | 6 | ea | 138.02 | 828 | 2 | 5 | Replace as required
4. TOILETS
Repaint ceilings | 8 | m2 | 28.84 | 231 | 1 | 8 | Ongoing painting program
Repaint walls | 80 | m2 | 29.87 | 2390 | 1 | 8 | Ongoing painting program
Repaint door face – one side | 2 | ea | 97.85 | 196 | 1 | 8 | Includes architrave
Replace taps | 2 | sets | 154.5 | 309 | 5 | 15 | Replace as required
Replace floor tiles (total: 8 m2) – 30% | 2 | m2 | 169.95 | 340 | 3 | 5 | Repair as required
Replace toilet cisterns and seats | 2 | m2 | 309 | 618 | 5 | 15 | Replace as required
5. SWIMMING POOL/SPA
Repair pool fencing (total: 42 lm) | 4 | lm | 113.3 | 453 | 4 | 5 | Repair as required
Replace pool surface | 56 | m2 | 216.3 | 12113 | 6 | 18 | Replace as required - quotation required
Replace pump | 1 | ea | 1648 | 1648 | 2 | 8 | Replace as required
Replace chlorination unit | 1 | ea | 1442 | 1442 | 5 | 6 | Replace as required
Replace sand filter | 1 | ea | 2060 | 2060 | 10 | 12 | Replace as required
Replace pool cover | 1 | ea | 1133 | 1133 | 4 | 8 | Replace as required
Replace sail shades | 1 | Item | 6499 | 6499 | 9 | 10 | Replace as required
Replace sail shade posts | 1 | Item | 1030 | 1030 | 1 | 15 | Allowance
6. FIXTURES AND FITTINGS
Replace letterboxes | 90 | ea | 133.9 | 12051 | 5 | 15 | Replace as required
Repaint light poles | 85 | lm | 54.59 | 4640 | 6 | 8 | Repaint as required
Move handrails for emergency vehicle access / maintain after | 1 | Item | 2060 | 2060 | 1 | 10 | Replace as required - estimate only - quotation required
Replace television (MATV) antenna and boosters | 1 | Item | 515 | 515 | 3 | 3 | Replace as required - subject to quote and servicing load
7. BUILDING SIGNAGE
Replace community signage including building name | 1 | Item | 1236 | 1236 | 1 | 6 | Replace as required
8. [NAME]
Repair or replace timber fence | 10 | lm | 139.05 | 1391 | 1 | 3 | Repair or replace as required
(total: 97 lm – rate 100%)
Repair or replace timber fence | 60 | lm | 87.55 | 5253 | 1 | 3 | Repair or replace as required
(total: 600 lm – rate 50%)
Repair or replace colorbond fence | 24 | lm | 113.3 | 2719 | 10 | 6 | Repair or replace as required
(total: 475 lm – rate 100%)
Replace timber retaining walls with concrete | 1 | Item | 3527.75 | 3528 | 1 | 0 | Provision towards replacement
Maintain concrete retaining walls | 1 | Item | 4120 | 4120 | 4 | 10 | Provision towards replacement
9. ELECTRICAL
Maintain community lighting | 1 | Item | 1545 | 1545 | 1 | 3 | Repair or replace as required
Maintain electrical switchboards and RCDs | 1 | Item | 5150 | 5150 | 1 | 2 | Requires quotes - switchboard hardware and insulation issues
Items | Qty | Unit | Rate ($) | Value ($) | Next Due | Total Life | Comments
10. SEWERAGE AND STORMWATER
Plumbing allowance - ongoing pipe work and pit replacement / refurbishment | 1 | Item | 12360 | 12360 | 1 | 1 | Repair as required - ongoing
11. SPECIAL EXPENDITURE
Cleveland Terrace Project - tree removal | 1 | Item | 11495 | 11495 | 1 | 0 | Quote provided by BC
Cleveland Terrace Project - replanting garden | 1 | Item | 36000 | 36000 | 1 | 0 | Quote provided by BC
Cleveland Terrace Project - roadworks | 1 | Item | 42669 | 42669 | 1 | 0 | Quote provided by BC
Units feeding from Unit 49 power junction | 1 | Item | 25750 | 25750 | 1 | 5 | Ongoing issues around the complex