2018-2022 Financial Plan

PWDS – OPERATIONS CENTRE

Financial Plan – Sewer Utility All figures represent $’000 (thousands)

2016 Actuals

2017 Actuals

2017 Budget

2018 Budget

Budget ∆ $

Budget ∆ %

2019 Budget

2020 Budget

2021 Budget

2022 Budget

Revenue Contributions from Others (60000-4820)

-

-

-

-

-

-

-

-

-

Investment Interest (60000-4295)

- 148

- 168

- 63

- 63

-

0%

- 63

- 63

- 63

- 63

Parcel Charges (61000-4420)

- 891

- 905

- 893

- 919

- 26

3%

- 933

- 947

- 961

- 975

Private Service Connections (multiple)

- 201

- 84

- 54

- 54

- 0

0%

- 54

- 54

- 54

- 54

Sale of Service (61000-4600)

- 299

- 285

- 326

- 302

24 -7%

- 313

- 324

- 336

- 348

Sales (61000-4510)

- 8,970 - 9,499 - 9,241 - 9,969 - 729

8% - 10,483 - 11,024 - 11,592 - 12,189

Total Revenue

- 10,510 - 10,942 - 10,576 - 11,307 - 731

7% - 11,846 - 12,411 - 13,006 - 13,630

Expense Admin Fees (61000-101-6005)

-

-

-

-

-

-

-

-

-

Appropriation of Surplus (61000-9010)

1,520

499

446

- 837 - 1,283 -288% - 2,810

376

1,003

1,275

Contract (64000-7007)

5,661

6,224

6,228

6,784 557

9% 7,510

8,089

8,663

8,975

Contribution to own Reserves (64000-9020)

581

1,282

-

-

-

-

-

-

-

Insurance (61000-6210)

48

50

57

64

7 12%

64

64

64

64

Maintenance - Buildings (62000-8060)

498

473

366

416

50 14%

449

457

466

475

Maintenance - General (62000/63000-8056)

465

480

416

692 276 66%

540

557

575

594

Other (multiple)

58

26

69

70

1

2%

71

72

74

75

Private Connections - Preservice (61000-8011)

21

11

14

14

0

0%

14

14

14

15

Salaries (61000-5500/5100)

141

166

333

338

5

1%

345

353

361

370

Salary Transfers (61000-5450)

683

721

709

736

27

4%

751

767

783

799

Service Severance Costs (60000-5150)

10

11

9

11

2 22%

11

11

11

11

Small Tools & Equipment (61000-7390)

18

31

12

12

0

2%

12

12

13

13

Special Projects (61000-6385)

234

210

275

745 470 171%

355

310

285

285

Total Expense

9,937 10,185

8,934

9,045 111

1% 7,312 11,083 12,313 12,952

Transfers Transfer to Capital Funds (multiple)

246

329

1,562

2,182 620 40% 4,453

1,248

613

598

Transfers Out (multiple)

74

64

80

80

-

0%

80

80

80

80

Total Transfers

320

394

1,642

2,262 620 38% 4,533

1,328

693

678

TOTAL SEWER UTILITY

- 253

- 363

- 0

-

-

0%

-

-

-

-

Financial Plan – Water Utility All figures represent $’000 (thousands)

2016 Actuals

2017 Actuals

2017 Budget

2018 Budget

Budget ∆ $

Budget ∆ %

2019 Budget

2020 Budget

2021 Budget

2022 Budget

Revenue Fines (71000-4240)

- 36

- 41

- 18

- 18

-

0%

- 18

- 18

- 18

- 18

Investment Interest (70000-4295)

- 194

- 234

- 80

- 80

-

0%

- 80

- 80

- 80

- 80

Parcel Charges (71000-4420)

- 140

- 131

- 128

- 131

- 2

2%

- 137

- 143

- 149

- 156

Private Connections (multiple)

- 469

- 566

- 495

- 495

- 0

0%

- 496

- 498

- 498

- 498

Permits (71000-4445)

- 3

- 2

-

-

-

-

-

-

-

Sale of Service (71000-4600)

- 3,931 - 4,169 - 3,651 - 4,024 - 373 10% - 4,205

- 4,394

- 4,591

- 4,798

Sales (71000-4510)

- 11,106 - 11,811 - 12,054 - 12,517 - 463

4% - 13,277 - 14,082 - 14,937 - 15,843

Total Revenue

- 15,879 - 16,954 - 16,426 - 17,264 - 839

5% - 18,212 - 19,215 - 20,273 - 21,393

Expense Appropriation of Surplus (71000-9010)

2,261

1,163

1,178

- 78 - 1,256 -107% 1,471

2,415

1,948

3,551

Contribution to own Reserves (74000-9020)

246

2,587

-

-

-

-

-

-

-

Contribution to Self-Insurance (74000-9021)

7

7

7

7

-

0%

7

7

7

7

Debt - Interest (multiple) Debt - Principal (multiple)

-

-

175

200

25 14%

200

200

200

200

-

-

130

650 520 400%

650

650

650

650

Insurance (71000-6210)

42

45

41

50

9 22%

50

50

50

50

Insurance-Adj Fee / Deductible (71000-6211)

-

-

5

5

-

0%

5

5

5

5

Maintenance - General (70000/72000-8056)

1,682

2,015

1,538

1,757 219 14% 1,852

1,899

1,947

1,997

Meter Reading (71000-8049)

20

22

16

16

0

2%

16

17

17

17

Other Outside Services (71000-7051)

3

3

5

5

-

0%

5

5

5

5

Private Connections - Preservice (71000-8011)

51

102

21

21

0

0%

21

21

21

21

Purchases (71000-7380)

7,420

8,005

8,237

8,433 196

2% 8,830

9,430 10,024 10,696

Radio & Communications (71000-6340)

27

27

32

32

0

1%

32

33

33

33

Salaries (71000/72000-5500)

312

320

589

595

6

1%

606

618

630

643

Salary Transfers (71000-5450)

963

1,009

997

1,031

34

3% 1,054

1,077

1,101

1,125

Service Severance Costs (70000-5150)

- 18

8

11

8

- 3 -26%

8

8

8

8

Small Tools & Equipment (71000-7390)

33

36

30

30

1

2%

31

32

33

33

Special Projects (71000-6385)

433

98

125

415 290 232%

25

25

15

15

Total Expense

13,481 15,444 13,136 13,177

42

0% 14,863 16,490 16,694 19,057

Transfers Borrowing Proceeds

-

-

- 6,000 - 7,000 - 1,000 17%

-

-

-

-

Transfer to Capital Funds (multiple)

1,993

1,135

3,204

4,686 1,481 46% 3,923

3,299

4,143

2,900

Transfers In/Out DCC

- 323

- 48

6,000

6,315 315

5%

- 660

- 660

- 650

- 650

Transfers Out (multiple)

95

98

86

86

-

0%

86

86

86

86

Total Transfers

1,764

1,184

3,290

4,087 797 24% 3,349

2,725

3,579

2,336

TOTAL WATER UTILITY

- 635

- 326

0

0

- 0

0%

0

0

0

0

Page 149 of 234