RSTS2 25 year whole life spreadsheets
| Authority | Manx Utilities Authority |
|---|---|
| Date received | 2017-07-06 |
| Outcome | Some information sent but not all held |
| Outcome date | 2017-07-28 |
| Case ID | 355725 |
Summary
A request was made for 25-year whole life spreadsheets regarding regional sewage works options for Peel, St Johns, and Central Valley. Manx Utilities Authority released some information but withheld specific budget estimates citing commercial and economic interest exemptions.
Key Facts
- The request concerned the Regional Sewage Treatment Strategy-Phase 2 (RSTS2).
- Manx Utilities is currently undertaking speculative negotiations with land owners for the project.
- Disclosure of budget estimates was refused to prevent unfair competitive advantage in land acquisition and tendering.
- The authority concluded that the risk of harm to the infrastructure programme outweighs the public interest in disclosure.
- The response was issued on 28 July 2017 following a request received on 6 July 2017.
Data Disclosed
- 25 year
- 6 July 2017
- 28 July 2017
- IM94201I
- 30(2)(b)
- 30(1)(a)
- 687687
- IM99 1PS
Exemptions Cited
- Section 30(2)(b) of the Freedom of Information Act 2015 (prejudice to commercial interests)
- Section 30(1)(a) of the Freedom of Information Act 2015 (prejudice to economic interests of the island)
Data Tables (6)
| Region: West Catchment: Peel STW in field |
|---|
| Option: 1 Discount Rate: 6.0% |
| ESTIMATED DISCOUNTED CASH FLOW | |||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cost Element | Pre Year0 | 0 2019 (£) | 1 2020 (£) | 2 2021 (£) | 3 2022 (£) | 4 2023 (£) | 5 2024 (£) | 6 2025 (£) | 7 2026 (£) | 8 2027 (£) | 9 2028 (£) | 10 2029 (£) | 11 2030 (£) | 12 2031 (£) | 13 2032 (£) | 14 2033 (£) | 15 2034 (£) | 16 2035 (£) | 17 2036 (£) | 18 2037 (£) | 19 2038 (£) | 20 2039 (£) | 21 2040 (£) | 22 2041 (£) | 23 2042 (£) | 24 2043 (£) | 25 Residual Value (£) | ||
| Capital Costs | |||||||||||||||||||||||||||||
| Asset | |||||||||||||||||||||||||||||
| Life (Yrs) | |||||||||||||||||||||||||||||
| Capital Construction Cost | |||||||||||||||||||||||||||||
| Fees, 3rd Parties, Planning Costs | |||||||||||||||||||||||||||||
| Land cost | |||||||||||||||||||||||||||||
| Heavy M&E Plant (MCC, pumps & Screens) | 20 | 116,000.00 | 98,600.00 | ||||||||||||||||||||||||||
| Light M&E Plant (odour control, PLC, instru | ments, be1a0rings) | 59,000.00 | 59,000.00 | 41,300.00 | |||||||||||||||||||||||||
| Light wearing M&E Components (seals) | 5 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | -1,000.00 | |||||||||||||||||||||||
| Total Lifetime Capital Costs | 5,000.00 | 64,000.00 | 5,000.00 | 180,000.00 | 138,900.00 | ||||||||||||||||||||||||
| Operating Costs | |||||||||||||||||||||||||||||
| Annual | |||||||||||||||||||||||||||||
| Growth | |||||||||||||||||||||||||||||
| STW and PS Labour Costs | 2.0% | 47,640.00 | 48,592.80 | 49,564.66 | 50,555.95 | 51,567.07 | 52,598.41 | 53,650.38 | 54,723.39 | 55,817.85 | 56,934.21 | 58,072.89 | 59,234.35 | 60,419.04 | 61,627.42 | 62,859.97 | 64,117.17 | 65,399.51 | 66,707.50 | 68,041.65 | 69,402.48 | 70,790.53 | 72,206.34 | 73,650.47 | 75,123.48 | 76,625.95 | |||
| STW Power costs | 2.0% | 10,310.20 | 10,516.40 | 10,726.73 | 10,941.27 | 11,160.09 | 11,383.29 | 11,610.96 | 11,843.18 | 12,080.04 | 12,321.64 | 12,568.08 | 12,819.44 | 13,075.83 | 13,337.34 | 13,604.09 | 13,876.17 | 14,153.69 | 14,436.77 | 14,725.50 | 15,020.01 | 15,320.41 | 15,626.82 | 15,939.36 | 16,258.15 | 16,583.31 | |||
| STW Telephone & telemetry Costs | 2.0% | 1,500.00 | 1,530.00 | 1,560.60 | 1,591.81 | 1,623.65 | 1,656.12 | 1,689.24 | 1,723.03 | 1,757.49 | 1,792.64 | 1,828.49 | 1,865.06 | 1,902.36 | 1,940.41 | 1,979.22 | 2,018.80 | 2,059.18 | 2,100.36 | 2,142.37 | 2,185.22 | 2,228.92 | 2,273.50 | 2,318.97 | 2,365.35 | 2,412.66 | |||
| STW Engineering Maintenance Costs | 2.0% | 3,000.00 | 3,060.00 | 3,121.20 | 3,183.62 | 3,247.30 | 3,312.24 | 3,378.49 | 3,446.06 | 3,514.98 | 3,585.28 | 3,656.98 | 3,730.12 | 3,804.73 | 3,880.82 | 3,958.44 | 4,037.61 | 4,118.36 | 4,200.72 | 4,284.74 | 4,370.43 | 4,457.84 | 4,547.00 | 4,637.94 | 4,730.70 | 4,825.31 | |||
| STW Sludge Disposal Costs | 2.0% | 117,357.23 | 119,704.38 | 122,098.47 | 124,540.43 | 127,031.24 | 129,571.87 | 132,163.31 | 134,806.57 | 137,502.70 | 140,252.76 | 143,057.81 | 145,918.97 | 148,837.35 | 151,814.10 | 154,850.38 | 157,947.38 | 161,106.33 | 164,328.46 | 167,615.03 | 170,967.33 | 174,386.68 | 177,874.41 | 181,431.90 | 185,060.53 | 188,761.75 | |||
| STW Consumable Costs | 2.0% | 3,000.00 | 3,060.00 | 3,121.20 | 3,183.62 | 3,247.30 | 3,312.24 | 3,378.49 | 3,446.06 | 3,514.98 | 3,585.28 | 3,656.98 | 3,730.12 | 3,804.73 | 3,880.82 | 3,958.44 | 4,037.61 | 4,118.36 | 4,200.72 | 4,284.74 | 4,370.43 | 4,457.84 | 4,547.00 | 4,637.94 | 4,730.70 | 4,825.31 | |||
| STW UV Costs | 2.0% | 2,141.73 | 2,184.57 | 2,228.26 | 2,272.82 | 2,318.28 | 2,364.65 | 2,411.94 | 2,460.18 | 2,509.38 | 2,559.57 | 2,610.76 | 2,662.98 | 2,716.23 | 2,770.56 | 2,825.97 | 2,882.49 | 2,940.14 | 2,998.94 | 3,058.92 | 3,120.10 | 3,182.50 | 3,246.15 | 3,311.07 | 3,377.30 | 3,444.84 | |||
| Peel PS to new STW pumping costs | 2.0% | 3,097.50 | 3,159.45 | 3,222.64 | 3,287.09 | 3,352.83 | 3,419.89 | 3,488.28 | 3,558.05 | 3,629.21 | 3,701.79 | 3,775.83 | 3,851.35 | 3,928.37 | 4,006.94 | 4,087.08 | 4,168.82 | 4,252.20 | 4,337.24 | 4,423.99 | 4,512.47 | 4,602.72 | 4,694.77 | 4,788.67 | 4,884.44 | 4,982.13 | |||
| Peel PS to outfall (storm costs) | 2.0% | 276.55 | 282.09 | 287.73 | 293.48 | 299.35 | 305.34 | 311.45 | 317.67 | 324.03 | 330.51 | 337.12 | 343.86 | 350.74 | 357.75 | 364.91 | 372.21 | 379.65 | 387.24 | 394.99 | 402.89 | 410.95 | 419.16 | 427.55 | 436.10 | 444.82 | |||
| Total Effect on Operating Costs | 188,323.22 | 192,089.68 | 195,931.47 | 199,850.10 | 203,847.11 | 207,924.05 | 212,082.53 | 216,324.18 | 220,650.66 | 225,063.68 | 229,564.95 | 234,156.25 | 238,839.37 | 243,616.16 | 248,488.48 | 253,458.25 | 258,527.42 | 263,697.97 | 268,971.93 | 274,351.37 | 279,838.39 | 285,435.16 | 291,143.86 | 296,966.74 | 302,906.08 | ||||
| Total Lifetime Operational Costs | 6,032,049.05 | ||||||||||||||||||||||||||||
| Net Cash Flow | |||||||||||||||||||||||||||||
| 192,089.68 | 195,931.47 | 199,850.10 | 203,847.11 | 207,924.05 | 217,082.53 | 216,324.18 | 220,650.66 | 225,063.68 | 229,564.95 | 298,156.25 | 238,839.37 | 243,616.16 | 248,488.48 | 253,458.25 | 263,527.42 | 263,697.97 | 268,971.93 | 274,351.37 | 279,838.39 | 465,435.16 | 291,143.86 | 296,966.74 | 302,906.08 | 138,900.00 | |||||
| Discounted cost at discount rate of: | 6.0% | 181,216.68 | 174,378.31 | 167,798.00 | 161,466.00 | 155,372.94 | 153,034.62 | 143,867.93 | 138,438.96 | 133,214.84 | 128,187.87 | 157,064.99 | 118,695.85 | 114,216.76 | 109,906.70 | 105,759.27 | 103,736.59 | 97,928.04 | 94,232.64 | 90,676.70 | 87,254.93 | 136,910.27 | 80,793.91 | 77,745.08 | 74,811.30 | 32,363.51 | |||
| Net Present Value (£): |
| Discounting Calculation | |||
|---|---|---|---|
| Region: | West | Catchment: | St Johns |
| Option: | 1 | St Johns STW | |
| Discount Rate: | 3.5% | Inflation Rate: | 2.0% |
| ESTIMATED DISCOUNTED CASH FLOW | |||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cost Element | Pre Year0 | 0 2019 (£) | 1 2020 (£) | 2 2021 (£) | 3 2022 (£) | 4 2023 (£) | 5 2024 (£) | 6 2025 (£) | 7 2026 (£) | 8 2027 (£) | 9 2028 (£) | 10 2029 (£) | 11 2030 (£) | 12 2031 (£) | 13 2032 (£) | 14 2033 (£) | 15 2034 (£) | 16 2035 (£) | 17 2036 (£) | 18 2037 (£) | 19 2038 (£) | 20 2039 (£) | 21 2040 (£) | 22 2041 (£) | 23 2042 (£) | 24 2043 (£) | 25 Residual Value (£) | ||
| Capital Costs | |||||||||||||||||||||||||||||
| Asset | |||||||||||||||||||||||||||||
| Life (Yrs) | |||||||||||||||||||||||||||||
| Capital Construction Cost | |||||||||||||||||||||||||||||
| Fees, 3rd Parties, Planning Costs | |||||||||||||||||||||||||||||
| Land cost | 0.00 | ||||||||||||||||||||||||||||
| Heavy M&E Plant (MCC, pumps & Screens) | 20 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 100,000.00 | 85,000.00 | |||||||||||||||||||
| Light M&E Plant (odour control, PLC, instruments, bearings) | 10 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 50,000.00 | 50,000.00 | 35,000.00 | ||||||||||||||||||
| Light wearing M&E Components (seals) | 5 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | -1,000.00 | |||||||||||||||||
| 0.00 | |||||||||||||||||||||||||||||
| Total Lifetime Capital Costs | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 55,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 155,000.00 | 0.00 | 0.00 | 0.00 | 119,000.00 | |||
| Operating Costs | |||||||||||||||||||||||||||||
| Annual | |||||||||||||||||||||||||||||
| Growth | |||||||||||||||||||||||||||||
| STW and PS Labour Costs | 2.0% | 14,460.00 | 14,749.20 | 15,044.18 | 15,345.07 | 15,651.97 | 15,965.01 | 16,284.31 | 16,609.99 | 16,942.19 | 17,281.04 | 17,626.66 | 17,979.19 | 18,338.78 | 18,705.55 | 19,079.66 | 19,461.26 | 19,850.48 | 20,247.49 | 20,652.44 | 21,065.49 | 21,486.80 | 21,916.54 | 22,354.87 | 22,801.96 | 23,258.00 | |||
| STW Power costs | 2.0% | 4,102.52 | 4,184.57 | 4,268.26 | 4,353.63 | 4,440.70 | 4,529.51 | 4,620.10 | 4,712.51 | 4,806.76 | 4,902.89 | 5,000.95 | 5,100.97 | 5,202.99 | 5,307.05 | 5,413.19 | 5,521.45 | 5,631.88 | 5,744.52 | 5,859.41 | 5,976.60 | 6,096.13 | 6,218.05 | 6,342.41 | 6,469.26 | 6,598.65 | |||
| STW Telephone & telemetry Costs | 2.0% | 1,500.00 | 1,530.00 | 1,560.60 | 1,591.81 | 1,623.65 | 1,656.12 | 1,689.24 | 1,723.03 | 1,757.49 | 1,792.64 | 1,828.49 | 1,865.06 | 1,902.36 | 1,940.41 | 1,979.22 | 2,018.80 | 2,059.18 | 2,100.36 | 2,142.37 | 2,185.22 | 2,228.92 | 2,273.50 | 2,318.97 | 2,365.35 | 2,412.66 | |||
| STW Engineering Maintenance Costs | 2.0% | 9,942.02 | 10,140.86 | 10,343.68 | 10,550.55 | 10,761.56 | 10,976.80 | 11,196.33 | 11,420.26 | 11,648.66 | 11,881.64 | 12,119.27 | 12,361.65 | 12,608.89 | 12,861.07 | 13,118.29 | 13,380.65 | 13,648.27 | 13,921.23 | 14,199.66 | 14,483.65 | 14,773.32 | 15,068.79 | 15,370.16 | 15,677.57 | 15,991.12 | |||
| STW Sludge Disposal Costs | 2.0% | 23,020.07 | 23,480.47 | 23,950.08 | 24,429.09 | 24,917.67 | 25,416.02 | 25,924.34 | 26,442.83 | 26,971.68 | 27,511.12 | 28,061.34 | 28,622.57 | 29,195.02 | 29,778.92 | 30,374.50 | 30,981.99 | 31,601.63 | 32,233.66 | 32,878.33 | 33,535.90 | 34,206.62 | 34,890.75 | 35,588.56 | 36,300.34 | 37,026.34 | |||
| STW Consumable Costs | 2.0% | 1,500.00 | 1,530.00 | 1,560.60 | 1,591.81 | 1,623.65 | 1,656.12 | 1,689.24 | 1,723.03 | 1,757.49 | 1,792.64 | 1,828.49 | 1,865.06 | 1,902.36 | 1,940.41 | 1,979.22 | 2,018.80 | 2,059.18 | 2,100.36 | 2,142.37 | 2,185.22 | 2,228.92 | 2,273.50 | 2,318.97 | 2,365.35 | 2,412.66 | |||
| STW UV Costs | 2.0% | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
| Total Effect on Operating Costs | 0.00 | 54,524.61 | 55,615.11 | 56,727.41 | 57,861.96 | 59,019.20 | 60,199.58 | 61,403.57 | 62,631.64 | 63,884.28 | 65,161.96 | 66,465.20 | 67,794.50 | 69,150.39 | 70,533.40 | 71,944.07 | 73,382.95 | 74,850.61 | 76,347.62 | 77,874.58 | 79,432.07 | 81,020.71 | 82,641.12 | 84,293.94 | 85,979.82 | 87,699.42 | |||
| Total Lifetime Operational Costs | 1,746,439.72 | ||||||||||||||||||||||||||||
| Net Cash Flow | |||||||||||||||||||||||||||||
| 0.00 | 2,441,564.61 | 55,615.11 | 56,727.41 | 57,861.96 | 59,019.20 | 60,199.58 | 66,403.57 | 62,631.64 | 63,884.28 | 65,161.96 | 66,465.20 | 122,794.50 | 69,150.39 | 70,533.40 | 71,944.07 | 73,382.95 | 79,850.61 | 76,347.62 | 77,874.58 | 79,432.07 | 81,020.71 | 237,641.12 | 84,293.94 | 85,979.82 | 87,699.42 | 119,000.00 | |||
| Discounted cost at discount rate of: | 3.5% | 0.00 | 2,441,564.61 | 53,734.40 | 52,955.64 | 52,188.17 | 51,431.82 | 50,686.43 | 54,019.35 | 49,227.90 | 48,514.46 | 47,811.35 | 47,118.43 | 84,107.57 | 45,762.58 | 45,099.35 | 44,445.74 | 43,801.60 | 46,050.32 | 42,541.18 | 41,924.64 | 41,317.04 | 40,718.24 | 115,391.61 | 39,546.56 | 38,973.42 | 38,408.59 | 50,354.49 | |
| Net Present Value (£): |
| Discounting Calculation | |||
|---|---|---|---|
| Region: | Central Valley | Catchment: | Ballagarey, Crosby & Glen Vine |
| Option: | 1B | New STW at Ballagarey & Crosby with GV flows transferred to Crosby | |
| Discount Rate: | 3.5% | Inflation Rate: | 2.0% |
| ESTIMATED DISCOUNTED CASH FLOW | |||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cost Element | Pre Year0 | 0 2019 (£) | 1 2020 (£) | 2 2021 (£) | 3 2022 (£) | 4 2023 (£) | 5 2024 (£) | 6 2025 (£) | 7 2026 (£) | 8 2027 (£) | 9 2028 (£) | 10 2029 (£) | 11 2030 (£) | 12 2031 (£) | 13 2032 (£) | 14 2033 (£) | 15 2034 (£) | 16 2035 (£) | 17 2036 (£) | 18 2037 (£) | 19 2038 (£) | 20 2039 (£) | 21 2040 (£) | 22 2041 (£) | 23 2042 (£) | 24 2043 (£) | 25 Residual Value (£) | ||
| Capital Costs | |||||||||||||||||||||||||||||
| Asset | |||||||||||||||||||||||||||||
| Life (Yrs) | |||||||||||||||||||||||||||||
| Capital Construction Cost | |||||||||||||||||||||||||||||
| Fees, 3rd Parties, Planning Costs | |||||||||||||||||||||||||||||
| Land cost | |||||||||||||||||||||||||||||
| Heavy M&E Plant (MCC, pumps & Screens) | 20 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 170,000.00 | 144,500.00 | ||||||||||||||||||||
| Light M&E Plant (odour control, PLC, instruments, bearings) | 10 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 50,000.00 | 50,000.00 | 35,000.00 | |||||||||||||||||||
| Light wearing M&E Components (seals) | 5 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 | -1,000.00 | ||||||||||||||||||
| 0.00 | |||||||||||||||||||||||||||||
| Total Lifetime Capital Costs | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 55,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 225,000.00 | 0.00 | 0.00 | 0.00 | 178,500.00 | |||
| Operating Costs | |||||||||||||||||||||||||||||
| Annual | |||||||||||||||||||||||||||||
| Growth | |||||||||||||||||||||||||||||
| STW and PS Labour Costs | 2.0% | 16,704.00 | 17,038.08 | 17,378.84 | 17,726.42 | 18,080.95 | 18,442.57 | 18,811.42 | 19,187.65 | 19,571.40 | 19,962.83 | 20,362.08 | 20,769.32 | 21,184.71 | 21,608.41 | 22,040.57 | 22,481.38 | 22,931.01 | 23,389.63 | 23,857.43 | 24,334.57 | 24,821.27 | 25,317.69 | 25,824.04 | 26,340.53 | 26,867.34 | |||
| STW Power costs | 2.0% | 10,984.67 | 11,204.36 | 11,428.45 | 11,657.02 | 11,890.16 | 12,127.96 | 12,370.52 | 12,617.93 | 12,870.29 | 13,127.70 | 13,390.25 | 13,658.06 | 13,931.22 | 14,209.84 | 14,494.04 | 14,783.92 | 15,079.60 | 15,381.19 | 15,688.81 | 16,002.59 | 16,322.64 | 16,649.10 | 16,982.08 | 17,321.72 | 17,668.15 | |||
| STW Telephone & telemetry Costs | 2.0% | 1,000.00 | 1,020.00 | 1,040.40 | 1,061.21 | 1,082.43 | 1,104.08 | 1,126.16 | 1,148.69 | 1,171.66 | 1,195.09 | 1,218.99 | 1,243.37 | 1,268.24 | 1,293.61 | 1,319.48 | 1,345.87 | 1,372.79 | 1,400.24 | 1,428.25 | 1,456.81 | 1,485.95 | 1,515.67 | 1,545.98 | 1,576.90 | 1,608.44 | |||
| STW Engineering Maintenance Costs | 2.0% | 14,684.10 | 14,977.78 | 15,277.34 | 15,582.88 | 15,894.54 | 16,212.43 | 16,536.68 | 16,867.41 | 17,204.76 | 17,548.86 | 17,899.83 | 18,257.83 | 18,622.99 | 18,995.45 | 19,375.36 | 19,762.86 | 20,158.12 | 20,561.28 | 20,972.51 | 21,391.96 | 21,819.80 | 22,256.19 | 22,701.32 | 23,155.34 | 23,618.45 | |||
| STW Sludge Disposal Costs | 2.0% | 30,467.74 | 31,077.10 | 31,698.64 | 32,332.61 | 32,979.27 | 33,638.85 | 34,311.63 | 34,997.86 | 35,697.82 | 36,411.77 | 37,140.01 | 37,882.81 | 38,640.47 | 39,413.27 | 40,201.54 | 41,005.57 | 41,825.68 | 42,662.20 | 43,515.44 | 44,385.75 | 45,273.46 | 46,178.93 | 47,102.51 | 48,044.56 | 49,005.45 | |||
| STW Consumable Costs | 2.0% | 1,000.00 | 1,020.00 | 1,040.40 | 1,061.21 | 1,082.43 | 1,104.08 | 1,126.16 | 1,148.69 | 1,171.66 | 1,195.09 | 1,218.99 | 1,243.37 | 1,268.24 | 1,293.61 | 1,319.48 | 1,345.87 | 1,372.79 | 1,400.24 | 1,428.25 | 1,456.81 | 1,485.95 | 1,515.67 | 1,545.98 | 1,576.90 | 1,608.44 | |||
| STW UV Costs | 2.0% | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
| Total Effect on Operating Costs | 0.00 | 74,840.51 | 76,337.32 | 77,864.07 | 79,421.35 | 81,009.78 | 82,629.97 | 84,282.57 | 85,968.22 | 87,687.59 | 89,441.34 | 91,230.17 | 93,054.77 | 94,915.86 | 96,814.18 | 98,750.47 | 100,725.47 | 102,739.98 | 104,794.78 | 106,890.68 | 109,028.49 | 111,209.06 | 113,433.24 | 115,701.91 | 118,015.95 | 120,376.27 | |||
| Total Lifetime Operational Costs | 2,397,164.02 | ||||||||||||||||||||||||||||
| Net Cash Flow | |||||||||||||||||||||||||||||
| 0.00 | 76,337.32 | 77,864.07 | 79,421.35 | 81,009.78 | 82,629.97 | 89,282.57 | 85,968.22 | 87,687.59 | 89,441.34 | 91,230.17 | 148,054.77 | 94,915.86 | 96,814.18 | 98,750.47 | 100,725.47 | 107,739.98 | 104,794.78 | 106,890.68 | 109,028.49 | 111,209.06 | 338,433.24 | 115,701.91 | 118,015.95 | 120,376.27 | 178,500.00 | ||||
| Discounted cost at discount rate of: | 3.5% | 0.00 | 73,755.87 | 72,686.94 | 71,633.51 | 70,595.34 | 69,572.22 | 72,631.43 | 67,570.25 | 66,590.97 | 65,625.88 | 64,674.78 | 101,409.48 | 62,813.73 | 61,903.39 | 61,006.24 | 60,122.09 | 62,134.29 | 58,392.05 | 57,545.79 | 56,711.79 | 55,889.88 | 164,333.34 | 54,281.62 | 53,494.93 | 52,719.64 | 75,531.74 | ||
| Net Present Value (£): |
Full Response Text
Manx Utilities • PO Box 177 • Douglas • Isle of Man • IM99 1PS e: foi@manxutilities.im • t: 687687 • www.manxutilities.im
REFERENCE NUMBER IM94201I
REQUEST UNDER THE FREEDOM OF INFORMATION ACT 2015 (“the Act”)
Thank you for your online application dated 6 July 2017 requesting the following information
‘Copies o f t he 25 y ear w hole l ife s preadsheets r elating t o each e lement of a ll regional sewage works options to provide sewage treatment provision at Peel, St Johns and Central Valley’
Our aim is to provide information whenever possible and the information we are able to provide is appended to this letter. In this instance, some of the information is exempt from disclosure under sections 30(2)(b) and 30(1)(a) of the Act as its disclosure would prejudice the commercial interests of Manx Utilities and would be likely to prejudice the economic interests of the island.
Assessment of 30(2)(b)
A disclosure under the Act is deemed to be a disclosure to the world rather than a disclosure to an individual requestor.
Manx Utilities is currently undertaking speculative negotiations with land owners in order to acquire land which is crucial to the implementation of the Regional Sewage Treatment Strategy-Phase 2 (RSTS2) as set out in the Programme for Government.
Following a successful land acquisition process, future tender exercises with contracted service providers will be undertaken, which are also required for the successful implementation of the RSTS2 programme.
The commercial sensitivity of these processes requires a c autious approach. Disclosure of budget estimates relating to capital purchases will prejudice the commercial interest of Manx Utilities in that it would provide unfair competitive advantage to people with an interest in selling their land and to potential contracted service providers. This will limit the ability to achieve cost effective solutions.
Assessment of 30 (1)(a)
The most appropriate financial outcome for Manx Utilities ultimately presents the most appropriate financial outcome for Manx Utilities customers i.e. Island residents. Inability to achieve this is likely to be of detriment to Island residents as additional costs would have to be passed on to the end user.
These exemptions are qualified exemptions, and as such, are subject to the public interest test. The public interest must be something that is of serious concern and benefit to the public at large and not merely something of individual interest.
Public Interest Test
Factors in favour of disclosing the information include:
• To promote transparency of decision making in Government and the reasoning behind any decisions which are taken. • To scrutinise the actions of Government and be able to hold Government to account for its decision making. • Securing the best use of public resources.
Factors in favour of maintaining the exemptions include:
• The underlying purpose of these exemptions is to protect the economy and commercial interests. • Disclosure of t his information c ould be used to achieve individual competitive advantage. • The disclosure of this information is likely to prejudice the acquisition of land which is necessary for the successful implementation of RSTS2. • The disclosure of this information is likely to prejudice the success of future tendering processes, which are necessary for the successful implementation of RSTS2. • Progression of the RSTS2 programme has reached a critical stage and the immediate nature o f t he c ommercial s ensitivity as sociated wi th t he tendering p rocesses outweigh public interest. • Disclosure o f this i nformation wi ll not only affect M anx Utilities b ut also Island residents. • This information will ultimately reside in the public domain, at which point, it will be open to public scrutiny. • There is no evidence to suggest that disclosure of this information will serve a wider public interest.
In assessing the weight to be attributed to each aspect of these arguments, Manx Utilities has considered that disclosure of the information subject to the prejudice based qualified exemptions has the potential to cause harm to a crucial Island infrastructure programme and the associated commercial sensitivities.
Manx Utilities concludes that the risk of harm from disclosure outweighs any benefit that could be gained by the general public as a result of the information being disclosed.
Taking these considerations into account Manx Utilities has determined that t he factors in favour of mai ntaining the e xemptions o utweigh t he fac tors i n favour of d isclosing the information. Your right to request a review
If you are unhappy with this response to your Freedom of Information request, you may ask us to carry out an internal review of the response, by completing a complaint form and submitting it electronically or by delivery/post at the address or email below. An electronic and paper version of our complaint form can also be found on our website. If you would like a paper version of our complaint form sent to you by post, please don’t hesitate to let us know. Your review request should explain why you are dissatisfied with this response, and should be made as soon as practicable. We will respond as soon as the review has been concluded.
If you are not satisfied with the result of the review, you then have the right to appeal to the Information Commissioner for a decision on:
- Whether we have responded to your request for information in accordance with Part 2 of the Freedom of Information Act 2015; or
- Whether we are justified in refusing to give you the information requested.
In response to an application for review, the Information Commissioner may, at any time, attempt t o r esolve a matter b y n egotiation, conciliation, me diation or an other fo rm o f alternative dispute resolution and will have regard to any outcome of this in making any subsequent decision.
More detailed information on your rights to review is on the Information Commissioner’s website a t: www.inforights.im. Should y ou h ave an y q ueries, p lease d o n ot h esitate t o contact us.
IRIS Regional Sewage Treatment Strategy
Whole-Life Costing
PERCENTAGE SPLIT TABLE
Discounting Calculation
Region:
Option:
Discount Rate:
Note:
25
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Residual
Cost Element
Pre Year0
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
2041
2042
2043
Value
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
Capital Costs
Asset
Life (Yrs)
Capital Construction Cost
Fees, 3rd Parties, Planning Costs
Land cost
Heavy M&E Plant (MCC, pumps & Screens)
20
116,000.00
98,600.00
Light M&E Plant (odour control, PLC, instru
10
59,000.00
59,000.00
41,300.00
Light wearing M&E Components (seals)
5
5,000.00
5,000.00
5,000.00
5,000.00
-1,000.00
Total Lifetime Capital Costs
5,000.00
64,000.00
5,000.00
180,000.00
138,900.00
Operating Costs
Annual
Growth
STW and PS Labour Costs
2.0%
47,640.00
48,592.80
49,564.66
50,555.95
51,567.07
52,598.41
53,650.38
54,723.39
55,817.85
56,934.21
58,072.89
59,234.35
60,419.04
61,627.42
62,859.97
64,117.17
65,399.51
66,707.50
68,041.65
69,402.48
70,790.53
72,206.34
73,650.47
75,123.48
76,625.95
STW Power costs
2.0%
10,310.20
10,516.40
10,726.73
10,941.27
11,160.09
11,383.29
11,610.96
11,843.18
12,080.04
12,321.64
12,568.08
12,819.44
13,075.83
13,337.34
13,604.09
13,876.17
14,153.69
14,436.77
14,725.50
15,020.01
15,320.41
15,626.82
15,939.36
16,258.15
16,583.31
STW Telephone & telemetry Costs
2.0%
1,500.00
1,530.00
1,560.60
1,591.81
1,623.65
1,656.12
1,689.24
1,723.03
1,757.49
1,792.64
1,828.49
1,865.06
1,902.36
1,940.41
1,979.22
2,018.80
2,059.18
2,100.36
2,142.37
2,185.22
2,228.92
2,273.50
2,318.97
2,365.35
2,412.66
STW Engineering Maintenance Costs
2.0%
3,000.00
3,060.00
3,121.20
3,183.62
3,247.30
3,312.24
3,378.49
3,446.06
3,514.98
3,585.28
3,656.98
3,730.12
3,804.73
3,880.82
3,958.44
4,037.61
4,118.36
4,200.72
4,284.74
4,370.43
4,457.84
4,547.00
4,637.94
4,730.70
4,825.31
STW Sludge Disposal Costs
2.0%
117,357.23
119,704.38
122,098.47
124,540.43
127,031.24
129,571.87
132,163.31
134,806.57
137,502.70
140,252.76
143,057.81
145,918.97
148,837.35
151,814.10
154,850.38
157,947.38
161,106.33
164,328.46
167,615.03
170,967.33
174,386.68
177,874.41
181,431.90
185,060.53
188,761.75
STW Consumable Costs
2.0%
3,000.00
3,060.00
3,121.20
3,183.62
3,247.30
3,312.24
3,378.49
3,446.06
3,514.98
3,585.28
3,656.98
3,730.12
3,804.73
3,880.82
3,958.44
4,037.61
4,118.36
4,200.72
4,284.74
4,370.43
4,457.84
4,547.00
4,637.94
4,730.70
4,825.31
STW UV Costs
2.0%
2,141.73
2,184.57
2,228.26
2,272.82
2,318.28
2,364.65
2,411.94
2,460.18
2,509.38
2,559.57
2,610.76
2,662.98
2,716.23
2,770.56
2,825.97
2,882.49
2,940.14
2,998.94
3,058.92
3,120.10
3,182.50
3,246.15
3,311.07
3,377.30
3,444.84
Peel PS to new STW pumping costs
2.0%
3,097.50
3,159.45
3,222.64
3,287.09
3,352.83
3,419.89
3,488.28
3,558.05
3,629.21
3,701.79
3,775.83
3,851.35
3,928.37
4,006.94
4,087.08
4,168.82
4,252.20
4,337.24
4,423.99
4,512.47
4,602.72
4,694.77
4,788.67
4,884.44
4,982.13
Peel PS to outfall (storm costs)
2.0%
276.55
282.09
287.73
293.48
299.35
305.34
311.45
317.67
324.03
330.51
337.12
343.86
350.74
357.75
364.91
372.21
379.65
387.24
394.99
402.89
410.95
419.16
427.55
436.10
444.82
Total Effect on Operating Costs
188,323.22
192,089.68
195,931.47
199,850.10
203,847.11
207,924.05
212,082.53
216,324.18
220,650.66
225,063.68
229,564.95
234,156.25
238,839.37
243,616.16
248,488.48
253,458.25
258,527.42
263,697.97
268,971.93
274,351.37
279,838.39
285,435.16
291,143.86
296,966.74
302,906.08
Total Lifetime Operational Costs
6,032,049.05
Net Cash Flow
192,089.68
195,931.47
199,850.10
203,847.11
207,924.05
217,082.53
216,324.18
220,650.66
225,063.68
229,564.95
298,156.25
238,839.37
243,616.16
248,488.48
253,458.25
263,527.42
263,697.97
268,971.93
274,351.37
279,838.39
465,435.16
291,143.86
296,966.74
302,906.08
138,900.00
Discounted cost at discount rate of:
6.0%
181,216.68
174,378.31
167,798.00
161,466.00
155,372.94
153,034.62
143,867.93
138,438.96
133,214.84
128,187.87
157,064.99
118,695.85
114,216.76
109,906.70
105,759.27
103,736.59
97,928.04
94,232.64
90,676.70
87,254.93
136,910.27
80,793.91
77,745.08
74,811.30
32,363.51
Net Present Value (£):
Electricity power cost is based on 6p per Kwh increasing by 2% per annum from year one, all
other costs are also based on an annual 2% uplift
ESTIMATED DISCOUNTED CASH FLOW
West
Catchment:
Peel
1
STW in field
6.0%
Inflation Rate:
2.0%
Page 1 of 1
PERCENTAGE SPLIT TABLE
Discounting Calculation
Region:
Option:
Discount Rate:
Note:
25
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Residual
Cost Element
Pre Year0
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
2041
2042
2043
Value
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
(£)
Capital Costs
Asset
Life (Yrs)
Capital Construction Cost
Fees, 3rd Parties, Planning Costs
Land cost
0.00
Heavy M&E Plant (MCC, pumps & Screens)
20
0.00
0.00
0.00
0.00
0.00
0.00
0.00
100,000.00
85,000.00
Light M&E Plant (odour control, PLC, instruments, bearings)
10
0.00
0.00
0.00
0.00
0.00
0.00
0.00
50,000.00
50,000.00
35,000.00
Light wearing M&E Components (seals)
5
0.00
0.00
0.00
0.00
0.00
0.00
5,000.00
5,000.00
5,000.00
5,000.00
-1,000.00
0.00
Total Lifetime Capital Costs
0.00
0.00
0.00
0.00
0.00
0.00
5,000.00
0.00
0.00
0.00
0.00
55,000.00
0.00
0.00
0.00
0.00
5,000.00
0.00
0.00
0.00
0.00
155,000.00
0.00
0.00
0.00
119,000.00
Operating Costs
Annual
Growth
STW and PS Labour Costs
2.0%
14,460.00
14,749.20
15,044.18
15,345.07
15,651.97
15,965.01
16,284.31
16,609.99
16,942.19
17,281.04
17,626.66
17,979.19
18,338.78
18,705.55
19,079.66
19,461.26
19,850.48
20,247.49
20,652.44
21,065.49
21,486.80
21,916.54
22,354.87
22,801.96
23,258.00
STW Power costs
2.0%
4,102.52
4,184.57
4,268.26
4,353.63
4,440.70
4,529.51
4,620.10
4,712.51
4,806.76
4,902.89
5,000.95
5,100.97
5,202.99
5,307.05
5,413.19
5,521.45
5,631.88
5,744.52
5,859.41
5,976.60
6,096.13
6,218.05
6,342.41
6,469.26
6,598.65
STW Telephone & telemetry Costs
2.0%
1,500.00
1,530.00
1,560.60
1,591.81
1,623.65
1,656.12
1,689.24
1,723.03
1,757.49
1,792.64
1,828.49
1,865.06
1,902.36
1,940.41
1,979.22
2,018.80
2,059.18
2,100.36
2,142.37
2,185.22
2,228.92
2,273.50
2,318.97
2,365.35
2,412.66
STW Engineering Maintenance Costs
2.0%
9,942.02
10,140.86
10,343.68
10,550.55
10,761.56
10,976.80
11,196.33
11,420.26
11,648.66
11,881.64
12,119.27
12,361.65
12,608.89
12,861.07
13,118.29
13,380.65
13,648.27
13,921.23
14,199.66
14,483.65
14,773.32
15,068.79
15,370.16
15,677.57
15,991.12
STW Sludge Disposal Costs
2.0%
23,020.07
23,480.47
23,950.08
24,429.09
24,917.67
25,416.02
25,924.34
26,442.83
26,971.68
27,511.12
28,061.34
28,622.57
29,195.02
29,778.92
30,374.50
30,981.99
31,601.63
32,233.66
32,878.33
33,535.90
34,206.62
34,890.75
35,588.56
36,300.34
37,026.34
STW Consumable Costs
2.0%
1,500.00
1,530.00
1,560.60
1,591.81
1,623.65
1,656.12
1,689.24
1,723.03
1,757.49
1,792.64
1,828.49
1,865.06
1,902.36
1,940.41
1,979.22
2,018.80
2,059.18
2,100.36
2,142.37
2,185.22
2,228.92
2,273.50
2,318.97
2,365.35
2,412.66
STW UV Costs
2.0%
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total Effect on Operating Costs
0.00
54,524.61
55,615.11
56,727.41
57,861.96
59,019.20
60,199.58
61,403.57
62,631.64
63,884.28
65,161.96
66,465.20
67,794.50
69,150.39
70,533.40
71,944.07
73,382.95
74,850.61
76,347.62
77,874.58
79,432.07
81,020.71
82,641.12
84,293.94
85,979.82
87,699.42
Total Lifetime Operational Costs
1,746,439.72
Net Cash Flow
0.00
2,441,564.61
55,615.11
56,727.41
57,861.96
59,019.20
60,199.58
66,403.57
62,631.64
63,884.28
65,161.96
66,465.20
122,794.50
69,150.39
70,533.40
71,944.07
73,382.95
79,850.61
76,347.62
77,874.58
79,432.07
81,020.71
237,641.12
84,293.94
85,979.82
87,699.42
119,000.00
Discounted cost at discount rate of:
3.5%
0.00
2,441,564.61
53,734.40
52,955.64
52,188.17
51,431.82
50,686.43
54,019.35
49,227.90
48,514.46
47,811.35
47,118.43
84,107.57
45,762.58
45,099.35
44,445.74
43,801.60
46,050.32
42,541.18
41,924.64
41,317.04
40,718.24
115,391.61
39,546.56
38,973.42
38,408.59
50,354.49
Net Present Value (£):
Electricity power cost is based on 6p per Kwh increasing by 2% per annum from year one, all
other costs are also based on an annual 2% uplift
ESTIMATED DISCOUNTED CASH FLOW
West
Catchment:
St Johns
1
St Johns STW
3.5%
Inflation Rate:
2.0%
PERCENTAGE SPLIT TABLE
Discounting Calculation
Region:
Option:
Discount Rate:
Note:
25
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
[Response truncated — full text is 18,996 characters]