Spreadsheet: 857741d1706671275-solve-for-multiple-objective-cells-in-solver-sff-2024-solver-copy
Sheet: 2 SFF 2024 deferred resurfacing

Expenditure Item | Current Cost | Allowance Year 1 (2023) | Actuals  EXCL GST  Year 1 (2023) | Actuals    Year 1 (2023) | Year 2 (2024) | Year 3 (2025) | Year 4 (2026) | Year 5 (2027) | Year 6 (2028) | Year 7 (2029) | Year 8 (2030) | Year 9 (2031) | Year 10 (2032) | Year 11 (2033) | Year 12 (2034) | Year 13 (2035) | Year 14 (2036) | Year 15 (2037)
1. COMMON BUILDING EXTERIORS
Repaint building exteriors | 3245 | -3245 |  | - | 871 |  | - | - | - | - | - |  | - | 4111 | - | - | - | -
Repaint fascia & gutter - common property infrastructure | 1159 | 1159 |  | - | - | - | - | - | - | - | - | 1468 | - | - | - | - | - | -
Inspect & repair fascia & gutter (Total 2300 lm) | 13030 | 13030 |  | - | - | - | - | - | 15105 | - | - | - | - | 17511 | - | - | - | -
Repaint downpipes | 241 | 241 | 1230 |  | - | - | - | - | - | - | - | 305 | - | - | - | - | - | -
Repair/replace downpipes (total 1300 lm) | 4687 | -4687 |  | - |  |  |  |  | 5434 | - | - | - | - | 6299 | - | - | - | -
Replace/repair doors etc | 448 | 448 |  | - | 2915 | - | - | - | - | - | - | 568 | - | - | - | - | - | -
Replace roof tiles (total 42 sqm) | 536 | - |  | - | - | - | 586 | - | - | - | - | - | 699 | - | - | - | - | -
Re-bed & re-point ridge caps | 1133 | - |  | - | - | - | 1238 | - | - | - | - | - | - | - | - | - | - | -
Repair metal roof | 531 | - |  | - | - | - | 580 | - | - | - | - | - | - | 714 | - | - | - | -
Replace garden sculpture |  | - |  | - | 1000
Replace termite bait stations |  | - | 640 |  | 750 | 750 | 750 | 800 | 800 | 850 | 850 | 900 | 900 | 950 | 950 | 1000 | 1000 | 1000
Sub Total (incl GST)
 |  |  |  | -
2. EXTERNAL WALKWAYS |  |  |  | -
Maintain concrete pathways | 1555 | 1555 |  | - | 290 | - | - | - | 1803 | - | - | - | - | 2090 | - | - | - | -
Sub Total (incl GST) |  |  |  | - | 290 |  |  |  |  |  |  | 0
 |  |  |  | -
3. DRIVEWAYS |  |  |  | -
Maintain concrete driveway & car park areas | 3782 | -3782 | 1650 |  | - | 3782 | - | - | 4384 | - | - | - | - | 5083 | - | - | - | -
Repaint line marking | 1903 | 6500 | 7296 |  | 0 | - | - | - | 2206 | - | - | - | - | 2557 | - | - | - | -
Maintain paving (Total 1431 sqm) | 10932 | - |  | - | 10932 | - | - | 12304 | - | - | - | - | - | 14692 | - | - | - | -
Replace paved driveways - 60% 5 year replacement program (Yr 4 of project) | 34942 | 34942 |  | - | 0 | - | - | - | - | - | - | - | - | - | - | - | - | -
Replace paved driveways - 60% 5 year replacement program (Yr 5 of project) | 34942 | - |  | - | 35990 | - | - | - | - | - | - | - | - | - | - | - | - | -
[NAME] bitumen roadway | 74876 | - |  | - | 0 | - | - | - | - |  | - | - | - | - | - | - | - | -
[NAME] bitumen roadway | 74876 | - |  | - | 0 | - | - |  | - | - | - | - | - | - |  | - | - | -
[NAME] bitumen roadway | 74876 | - |  | - | 0 | - | - | - | - |  | - | - | - | - | - | - | -
Repair bitumen driveway (total 6232 sqm) | 15450 | - |  | - |  | - | - | 18797 | - | - | - | - | 22870 | - | - | - | - | 27824 | - | 27824
Replace plastic wheel stops (total 17) | 381 | - |  | - | - | - | - | 429 | - | - | 469 | - | - | 512 | - | - | 560 | -
Replace timber bollards (total 15) | 567 | 2000 |  | - | - | - | - | - | - | 677 | - | - | - | - | 785 | - | - | -
Repair concrete kerbing (total 1944 lm) | 5495 | 5495 |  | - | 0 | - | - | - | 6370 | - | - | - | - | 7385 | - | - | - | -
Replace curved stainless steel safety mirror | 1339 | - |  | - | 0 | - | - | - | - | - | - | - | 1747 | - | - | - | - | -
Highlight speed bumps | 1421 | 1421 |  | - | 0 | - | - | - | 1647 | - | - | - | - | 1910 | - | - | - | -
Replace stormwater grates (total 20) | 828 | - |  | - | - | - | - | - | - | 989 | - | - | - | - | 1146 | - | - | -
Sub Total (incl GST)
 |  |  |  | -
4. TOILETS |  |  |  | -
Repaint ceilings | 231 | -231 |  | - | - | - | 235 | - | - | - | - | 293 | - | - | - | - | - | -
Repaint walls | 2390 | -2390 |  | - | - | - | 2500 | - | - | - | - | 3028 | - | - | - | - | - | -
Repaint door face - one side | 196 | -196 |  | - | - | - | 200 | - | - | - | - | 248 | - | - | - | - | - | -
Replace taps | 309 | - |  | - | - | - | - | 348 | - | - | - | - | - | - | - | - | - | -
Replace floor tiles (total 8 sqm) - 30% | 340 | - |  | - | - | 361 | - | - | - | - | 418 | - | - | - | - | 485 | - | -
Replace toilet cisterns and seats | 618 | - |  | - | - | - | - | 696 | - | - | - | - | - | - | - | - | - | -
Sub Total (incl GST) |  | 0 |  | - | 0
 |  |  |  | -
5. SWIMMING POOL |  |  |  | -
Repair pool fencing (total 42 lm) | 453 | - |  | - | - | - | 495 | - | - | - | - | 574 | - | - | - | - | 665 | -
Replace pool surface | 12113 | - |  | - | - | 12113 | - | - | - | - | - | - | - | - | - | - | - | -
Replace pump | 1648 | - |  | - | - | - | - | - | - | - | - | - | 2150 |  | - | - | - | -
Replace chlorinator | 1442 | - |  | - | - | - | - | 1623 | - | - | - | - | - | 1938 |  | - | - | -
Replace sand filter | 2060 | - |  | - | - | - | - | - | - | - | - | - | 2688 |  | - | - | - | -
Replace pool cover | 1133 | - |  | - | - | - | - | - | - | - | - | - | - | - | 1568 |  | - | -
Replace shade sails | 6499 | - |  | - | - | - | - | - | - | - | - | 8233 | - | - | - | - | - | -
Replace shade sail posts | 1030 | -1030 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Install security grille door & window |  | 2000 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Install & Maintain Heat Exchange Pump |  | 5000 |  | - | 12000
Sub Total (Incl GST) |  |  |  | -
 |  |  |  | -
6. FIXTURES AND FITTINGS |  |  |  | -
Replace letterboxes | 12051 | - |  | - | - | - | 13564 | -13564 | - | - | - | - | - | - | - | - |  | -
Repaint light poles | 4640 | - |  | - | - | - | - | - | 5379 | - | - | - | - | - | - | - | 6814 | -
Repair signage |  | - | 260
Move handrails for emergency vehicle access/maintain after | 2060 | 2060 |  | - | 290 | - | - | - | - | - | - | - | - | 2768 | - | - | - | -
Replace TV antennae and boosters | 515 | 500 |  | - | - | 546 | - | - | 597 | - | - | 652 | - | - | 713 | - | - | 779
Sub Total (incl GST)
 |  |  |  | -
7. BUILDING SIGNAGE |  |  |  | -
Replace community signage incl building name | 1236 | -1236 |  | - | 242 | - | - | - | - | 1476 | - | - | - | - | - | 1762- | - | -
Sub Total (incl GST) |  | 0 | 0 | - |  | 0 | 0 | 0 | 0 | 1476 | 0 | 0 | 0 | 0 | 0 | 1762 | 0 | 0
 |  |  |  | -
8. [NAME] |  |  |  | -
Repair or replace timber fence (total 97 lm) - rate 100% | 1391 | 1391 |  | - | - | - | 1520 | - | - | 1661 | - | - | 1815 | - | - | 1983 | - | -
Repair or replace timber fence (total 600 lm) - rate 50% | 5253 | 5253 |  | - | 5253 | - | 5740 | - | - | 6272 | - | - | 6854 | - | - | 7490 | - | -
Repair or replace colorbond fence (total 475 lm) - rate 100% | 2719 | - |  | - | - | - | - | - | - | - | - | - | 3548 | - | - | - | - | -
Replace timber retaining walls with concrete | 3528 | -3528 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Maintain concrete retaining walls | 4120 | - |  | - | - | - | 4502 | - | - | - | - | - | - | - | - | - | 6050 | -
Sub Total (incl GST) |  |  |  | - |  | 0
 |  |  |  | -
9. ELECTRICAL |  |  |  | -
Maintain community lighting | 1545 | 1545 | 2374 |  | 16970 | - | 1688 | - | - | 1845 | - | - | 2016 | - | - | 2203 | - | -
Maintian electrical switchboards & RCDs | 5150 | 5150 |  | - | 1734
Update main DB
Sub Total (incl GST)
 |  |  |  | -
10. SEWERAGE AND STORMWATER |  |  |  | -
Plumbing allowance - ongoing pipe work and pit replacement/refurbishment | 12360 | 12360 | 8730 |  | 12731 | 13113 | 13506 | 13911 | 14329 | 14758 | 15201 | 15657 | 16127 | 16611 | 17109 | 17622 | 18151 | 18696
Sub Total (incl GST)
 |  |  |  | -
11. SECURITY |  |  |  | -
Pump room door grille |  | 2625 |  | -
Pump room window grille |  | 1114 |  | -
CCTV installation/replacement/maintenance |  | tbc |  | - | tbc | tbc | tbc | tbc | tbc | tbc | tbc | tbc | tbc | tbc | tbc | tbc | tbc | tbc
Light pole rewiring |  | 4131 |  | -
Sub Total (incl GST) |  |  |  | -
 |  |  |  | -
GENERAL [NAME] (incl GST)
 |  |  |  | -
12. SPECIAL EXPENDITURE | CTP and BTP |  |  | -
Cleveland Terrace Project - tree removal | 11495 | 11495 | 20000 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Cleveland Terrace Project - replanting garden | 36000 | 36000 | 28840 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Cleveland Terrace Project - roadworks | 42350 | 42350 | 59780 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
[NAME] (incl GST) |  |  |  |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Units feeding from Unit 49 power junction | 25750 | -25750 |  | - |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 34606 | 0 | 0 | 0 | 0
Turf aeration & preparation |  |  | 3050 |  |  | 3774 |  | 4082 |  | 4415 |  | 4776 |  | 5166 |  | 5588 |  | 6044
Sub Total (incl GST)
 |  |  |  | -
13. SPECIAL EXPENDITURE - STAGE TWO |  |  |  | -
[NAME] removal |  | - |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
[NAME] garden |  | - |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
[NAME] (incl in Stg One) |  | - |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  |  |  | -
Grand Total (incl GST)
10% Contingency Allowance (incl GST)
Grand Total Expenses (incl Contingency Allowance & incl GST)
Grand Total Exp incl contingency but EXCL GST - (to transfer to Adj CF Tracking Sheets)