A B C D E F G
1 Updated Energy Finanical Model BAWC- 12 Months Operation        
3   Units Business as Usual (BAU) Model-
(Gas boiler and chiller)
(March 2021)
Heat Pump and TES Model (March 2021) Actual Operation at 12 months (October 2022- September 2023) BAU Reference Scenario (Actual consumption, in the scenario that the plant was built to BAU specs with gas boiler and chiller) Comments- Actual vs BAU comparison Scenarios
For this high-level financial assessment, a BAU reference scenario with traditional gas boilers was modelled, based on the actual energy consumption (thermal and electrical) of BAWC.
4 Natural Gas Tarrif Rate AU$/GJ $12 $12 $28.14 $19 Brimbank City Council's large site gas contract was $28.14/GJ in 2023. Contract update for 2024-2026 at Year 1: $16.00GJ, Year 2: $16.83/GJ, Year 3: $16.84/GJ. Beyond this contract the price is unknown. This models assumes an average of 2023-2026 prices.
5 Electrictiy- Off Peak Tarrif Rates AU$/kWhe 0.129 0.129 0.129   As per the current electricity bills
6 Electrictiy- Peak Tarrif Rates AU$/kWhe 0.227 0.227 0.227   As per the current electricity bills
7 Electricty Blended Tarrif Rate         0.157 The effective rate based on the electricity costs to run the facility from 10/22 - 9/23. Total Electricity Cost divided by Total Electricity (kWhe) consumed. The blended rate is used to calculate the eletricity cost in the BAU Reference Scenario with the assumption that the ratio of peak to off-peak power is the same in both scenarios.
8 Annual Gas Consumption kWht     7179417 7,179,417 This is the sum of the thermal energy output of all heat pumps, which would need to be provided via the gas boilers in the BAU scenario
9   GJ 21,501 0 N/a 32,307 kWht converted to GJ
10 Boiler system efficiency [-]       0.8  
11 Global COP for all Heat Pumps kWhe       3.2 The global Coefficient of Performance is the effective annual average COP representing all heat pumps. As an actual COP is not available due to metering limitations, this number is used as a conservative industry average.
12 Estimated Electricty input of the heat pumps kWhe     2,243,567.81   Estimated electricity consumption of all heat pumps in the facility based on the selected global COP. Annual Gas Consumption [kWht]/COP
13 Annual Grid Electricity Consumption kWhe 1,171,789.00 2,442,219.00 4,048,537.21 1,804,969.40 BAU Grid Electricity = Actual Grid electricity consumption MINUS estimated electricity input of the heat pumps
14              
15 Annual Gas Cost $ $ 258,012.00 0 $ 9,325.78 $628,378  
16 Annural Grid Electicity Cost $ $ 127,473.00 $ 307,957.00 $ 633,956.87 $ 282,638.57  
17 Total Annual Energy Costs AU$ $ 385,485.00 $ 307,957.00 $ 643,282.65 $ 911,017.04  
18 Difference / Annual Savings       $ 267,734.39   This is the annual savings between the Actual Scenario and the BAU Reference Scenario
19 Cost premium (compared to BAU)   N/a $ 870,000.00 $1,122,000 N/a $1.1M figure represents the actual centre all-electric plant capital works cost for of $2.1m - $1m assumed potential cost of a BAU scenario.
20 HP+ TES Simple Payback period (annual energy costs and capital cost compared to BAU Model) Years N/a 11.2 4.2 N/a The original energy financial model provided in 2021 found that an all-electric centre with heat pumps and thermal energy storage, would have had a payback period of 11.2 years, compared to a business as usual design with gas boiler and chiller (BAU). This updated energy financial model shows the centre actual consumption after 12 months (Column E) and compares it with the cost of this actual consumption in the scenario that a BAU centre was built (Column F). The actual consumption has been influenced by higher than expected attendance levels (resulting in higher domestic hot water use and air conditioning needs in the gym) as well as a rise and then moderate fall in gas prices since 2021, resulting in a revision to the estimated payback period to 4.2 years.

  B C D
2 Inverter export from the SunGrow Portal 17/11/23
4 2022 Sept 32.07
5 2022 Oct 24.02
6 2022 Nov 53.51
7 2022 Dec 87.048
8 2023 Jan 79.476
9 2023 Feb 67.608
10 2023 Mar 54.635
11 2023 Apr 37.949
12 2023 May 30.576
13 2023 Jun 24.795
14 2023 Jul 29.714
15 2023 Aug 36.444
16 2023 Sep 21.19

  A B C D E F G H I J K M N
2 Thermal meter export from the EMS 21/11/23            
4 SALC                        
5 from 01/10/2022 until 30/09/2023                  
6 Timestamp TM-07 CU1 Heat (kWh) TM-01 DHW Pre Heat TM-02 DHW 2 Heat (kWh) TM-03 DHW 3 Heat (kWh) TM-04 DHW 4 Heat (kWh) TM-05 DHW 5 Heat (kWh) TM-06 DHW 6 Heat (kWh) TM-08 CU2 Heat (kWh) TM-09 CU3 Heat (kWh) TM-10 CU4 Heat (kWh) Total  
7       kWht kWht kWht kWht kWht kWht kWht kWht    
8 Oct-22 163989.99   5,081 41,857 14,671 3,056 4,956 117,370 167,190 46,480    
9 Nov-22 174039.978 5,780 37,401 16,037 3,416 5,643 80,130 108,030 39,770    
10 Dec-22 150640.015 5,159 8,131 13,458 3,178 4,970 48,590 109,720 35,780    
11 Jan-23 144890.015 4,794 0 10,634 2,983 4,514 31,500 93,370 25,550    
12 Feb-23 138059.998 3,967 0 7,899 2,127 3,803 34,400 89,870 14,700    
13 Mar-23 153169.922 4,220 0 8,762 2,234 3,973 44,140 117,050 15,720    
14 Apr-23 156160.034 5,796 0 11,447 3,709 5,337 69,120 131,650 20,040    
15 May-23 188910.034 6,571 0 12,685 3,480 6,184 152,190 125,280 20,800    
16 Jun-23 198069.946 6,835 0 4,081 4,088 6,562 148,210 147,500 20,210    
17 Jul-23 211280.029 7,288 0 0 4,669 6,821 151,620 139,020 22,560    
18 Aug-23 207329.956 6,668 100,001 0 4,180 6,239 148,370 113,040 22,930    
19 Sep-23 4402589.844 6,784 0 0 3,654 6,004 2,224,160 1,817,840 23,730    
21 Sub-Total     68,943 187,390 99,674 40,774 65,006 3,249,800 3,159,560 308,270 7,179,417 kWht
22                       25,846 GJ

  A B C D E F
1 BAWC usage and cost actuals Electricity   Gas    
2   Use kWh cost $ Use MJ Cost $ Gas bill timing rounding
4 Oct-22 355,137.21 $ 53,707.43 7,487.50 $231.85 13 October - 7 December bill is $462.57, 14975 MJ. October and Nov included.
5 Nov-22 302,599.65 $47,458.12 7,487.50 $231.85  
6 Dec-22 265,062.93 $45,770.68 15,173.66 $458.02 8 Dec to 17 Feb $1374.08, 45521 MJ. Dec, Jan, Feb included.
7 Jan-23 259,920.67 $45,157.58 15,173.66 $458.02  
8 Feb-23 241,974.68 $41,449.57 15,173.66 $458.02  
9 Mar-23 288,873.99 $49,298.51 5,187.00 $208.81 18 Feb to 18 April. March April included here. $417.62, 10,375 MJ
10 Apr-23 334,587.89 $50,376.59 5,187.00 $208.81  
11 May-23 400,840.74 $59,993.66 47,738.50 $974.36 19 April to 20 June. $1948.72, 95,477 MJ. May June included.
12 Jun-23 425,165.45 $62,913.93 47,738.50 $974.36  
13 Jul-23 433,412.31 $63,921.00 61,806.00 $2,136.84 21 June to 14 Aug. $4,273.68, 123,612 MJ. July Aug included.
14 Aug-23 403,951.52 $61,163.41 61,806.00 $2,136.84  
15 Sep-23 337,010.17 $52,746.39 23,964.50 $848.00 15 Aug- 11 October. Divided by 2 for September. $1696.09, 47929 MJ
18 Total actual first 12 months 4,048,537.21 $633,956.87 313,923.48 $9,325.78