2017-01-30 Finance Committee Agenda Packet - Open SessionCity of Saint John
Finance Committee - Open Session
AGENDA
Monday, January 30, 2017
4:30 pm
8th Floor Boardroom, City Hall
1. Call to Order
Pages
1.1 Approval of Minutes
1.1.1 Minutes of November 17, 2016 1 -3
1.1.2 Minutes of December 8, 2016 4 - 5
1.2 Asset Management Update 6-24
1.3 Long -Term Financial Planning 25-46
1.4 Continuous Improvement Update 47-62
1.5 Water and Sewerage Accounts Receivables Update -December 2016 63-64
1 Poeta Sy:1
rIN.
m
MINUTES - OPEN SESSION FINANCE COMMITTEE MEETING
NOVEMBER 17, 2016 AT 4:30 PM
Stn FLOOR BOARDROOM, CITY HALL
Present: Mayor D. Darling
Councillor D. Merrithew
Councillor D. Reardon
Councillor G. Sullivan
Councillor G. Norton
Councillor S. Casey
Also
Present: City Manager J. Trail
Commissioner of Finance and Treasurer K. Fudge
Comptroller C. Graham
Senior Manager Financial Planning H. Nguyen
Commissioner of Transportation & Environment Services M. Hugenholtz
Commissioner Saint John Water B. McGovern
Commissioner Growth and Community Development J. Hamilton
Deputy Fire Chief J. Armstrong
Administrative Officer R. Nichol
Assistant Comptroller Finance C. Lavigne
Administrative Assistant K. Tibbits
1. Meeting Called To Order
Councillor Merrithew called the Finance Committee open session meeting to order.
Moved by Councillor Reardon, seconded by Councillor Norton:
RESOLVED that the agenda for the open session meeting of the Finance Committee be
approved.
MOTION CARRIED.
1.1 Approval of Minutes — November 8, 2016
Moved by Mayor Darling, seconded by Councillor Reardon:
RESOLVED that the minutes of November 8, 2016 be approved.
MOTION CARRIED.
1.2 Service Audit Plan presented by Deloitte
(Mr. J. Cochrane and Mr. J. Maillais entered the meeting)
approach and the scope of the audit for 2016. The audit is conducted on the consolidated statements in
accordance with public sector accounting standards. Mr. Cochrane asked that if anyone is aware of any
fraudulent activity, to bring it forward to the auditors.
Responding to a comment regarding the utilization of one firm for all audits in order to reduce costs and
drive efficiencies, Mr. Fudge commented that the competitive bidding process comes into play as well as
the fact that the ABCs have the autonomy to choose their own auditors. The possibility of seeking
voluntary compliance with the ABCs and tendering the audit process as a single package was discussed.
Moved by Councillor Reardon, seconded by Mayor Darling:
RESOLVED that the submitted report by Deloitte LLP entitled, "2016 Audit Service Plan", be received for
information.
(Mr. Cochrane and Mr. Maillais withdrew from the meeting)
1.3 2nd Draft General Operating Budget to Finance Committee (Recommend the 2nd Draft Budget to
Council for Information on November 28th)
Mr. Fudge provided an overview of the operating budget and responded to questions. The provincial
tax information is not yet available but staff is recommending that the budget be sent to Council for
review at the next Council meeting. This will be Council's first formal opportunity to review the material
and provide feedback.
The budget is a 0.96% increase over the 2016 budget and the 9th straight budget without a property tax
rate increase. It consists of flat revenue growth and expenditure cuts to goods and services. The budget
was framed in context to Council's priorities. The budget includes $12,519,000 in revenue which is an
increase of 9Y2% over the 2016 budget primarily due to building permit revenue. Salaries and benefits
account for approximately 58% of the overall budget.
(Councillor Casey entered the meeting)
Mr. Trail, responding to a comment, stated that there has been considerable scrutiny put into the
budget. All service areas were challenged on their 2017 budget submissions.
Referring to service levels, Mr. Fudge commented that moving from a one year budget projection to a
five year outlook and long-term financial planning will help facilitate discussions of service levels and
assist in dealing with some of the systemic issues.
Ms. Nguyen noted that the budget does not include potential increases in salaries for Mayor and council
members. The Hay Consulting Group is expected to address Council in open session on November 28tH
Responding to a comment regarding the procurement process, Mr. Trail stated that there is a process
underway with Saint John, Moncton and Fredericton to identify common areas and a review of contracts
and vendors to identify opportunities for savings.
Moved by Councillor Sullivan, seconded by Councillor Reardon:
RESOLVED that the Finance Committee recommend the 2017 General Operating Budget be referred to
Common Council at the meeting of November 28, 2016 with a recommendation to receive for
information.
MOTION CARRIED.
Moved by Councillor Reardon, seconded by Councillor Sullivan:
RESOLVED that the request from the Imperial Theatre, referred by Council on September 6th, be added
to the agenda as item 1.4.3.
MOTION CARRIED.
1.4 Grant Reauests
Moved by Councillor Norton, seconded by Councillor Reardon:
RESOLVED that the requests from the Saint John Community Arts Board, Ellipsis Productions, and
Imperial Theatre be referred to the Community Grants Evaluation Committee.
It was noted that the Arts and Cultural board is currently being recommended for $35,000 in funding in
the operating budget, outside of the budget for grants. The mover and seconder agreed to withdraw
the original motion in order to consider this request at the Finance committee level.
Moved by Councillor Sullivan, seconded by Councillor Reardon:
RESOLVED that the requests from Ellipsis Productions and the Imperial Theatre be referred to the
Community Grants Evaluation committee for consideration.
MA relffeWN
Moved by Councillor Reardon, seconded by Councillor Sullivan:
RESOLVED that the Finance Committee recommends that the allotment given to the Saint John
Community Arts Board be increased from $35,000 to the requested $70,000 and that staff be directed
to recommend an offsetting adjustment in the operating budget.
AR •►
1.5 Capital Budget
Referring to the capital budget, Mr. Fudge noted that adjustments were made to the deferred list as a
result of feedback from Council.
Moved by Councillor Reardon, seconded by Mayor Darling:
RESOLVED that the Finance Committee approve the 2017 General Fund Capital Budget and recommend
for approval at the November 28th Council meeting.
MOTION CARRIED with Councillor Sullivan voting nay.
1.6 Pavment in Lieu of Tax (PIL
Ms. Graham commented on the PILT program. The City receives funding from the federal government
for the property it owns within the municipality, based on the property tax rate. The federal
government has its own assessors but the assessed value is in the vincinty of 99% of the value assessed
by SNB.
Moved by Councillor Reardon, seconded by Councillor Sullivan:
RESOLVED that the verbal update regarding Payment in Lieu of Tax (PILT), be received for information.
MOTION CARRIED.
Adjournment
Moved by Councillor Sullivan, seconded by Councillor Reardon:
RESOLVED that the Finance Committee open session meeting held on Thursday, November 17, 2016 be
adjourned.
MOTION CARRIED.
The Finance Committee meeting held on November 17, 2016 was adjourned at 6:50 p.m.
rIN.
m
MINUTES - OPEN SESSION FINANCE COMMITTEE MEETING
DECEMBER 8, 2016 AT 4:30 PM
Stn FLOOR BOARDROOM, CITY HALL
Present: Mayor D. Darling
Councillor D. Merrithew
Councillor D. Reardon
Councillor G. Sullivan
Councillor G. Norton
Councillor S. Casey
Also
Present: City Manager J. Trail
Deputy City Manager N. Jacobsen
Commissioner of Finance and Treasurer K. Fudge
Comptroller C. Graham
Senior Manager Financial Planning H. Nguyen
Commissioner of Transportation & Environment Services M. Hugenholtz
Commissioner Saint John Water B. McGovern
Commissioner Growth and Community Development J. Hamilton
City Solicitor J. Nugent
Fire Chief K. Clifford
Administrative Assistant K. Tibbits
1. Meeting Called To Order
Councillor Merrithew called the Finance Committee open session meeting to order.
Moved by Councillor Reardon, seconded by Mayor Darling:
RESOLVED that the agenda for the open session meeting of the Finance Committee be
approved.
MOTION CARRIED.
1.1 2016 Year End Forecast for the General and Utilitv Operating Funds
Mr. Fudge stated that as of October 31, 2016 there is a projected surplus for the general operating fund
and the utility operating fund. There is a high degree of variability in many of the surplus areas which
are vulnerable to unforeseen events, unknown risks, and inclement weather. Mr. Fudge commented on
the sustainability of the surpluses, mitigation strategies and variability with respect to long term fiscal
stability. Projections could change prior to year end depending on weather or other unforeseen events.
The forecasted surplus in the general operating fund is approximately $2.9M which represents a budget
variance of 1.9%.
There are risks in the budget including stagnant growth, variability of interest rates, significant debt
of long term financial health and sustainability, there is need for more revenue from the City's own
sources and growth in the tax base. The grant is not a guaranteed revenue source for the City of Saint
John.
Mr. Fudge commented on the "Reserve Fund Regulation" which allows a municipality, by resolution of
Council, to contribute to a general operating reserve for operating expenses, the amount of which
cannot exceed 5% of the total operating budget. The reserve is managed by Council and used to
mitigate unexpected fluctuations in the budget. Staff is recommending that of the $2.9M projected
surplus, that an operating reserve be established of $2M.
Moved by Councillor Reardon, seconded by Councillor Sullivan:
RESOLVED that the Finance Committee recommend to Common Council that it establish a General
Operating Reserve Fund and authorize the transfer of $2M from the projected General Operating Fund
surpluses to the Reserve Fund.
MA relffeWN
Ms. Graham reviewed the submitted presentation entitled, "2016 Year End Projections Saint John
Water". As of October 31St, there is a projected surplus of approximately $808,000. A surplus
associated to fiscal charges accounts for approximately $700,000 of the overall projected surplus. The
surplus is not sustainable and can be negatively impacted by increased interest rates, increased debt
balances, infrastructure deficits, unforeseen weather events and consumption by industrial commercial
users.
Ms. Graham noted that there is a reserve in place for the safe clean drinking water project to help offset
the upcoming substantial completion payment. The City can only fund a portion of that through other
government sources and over $40M will be required in borrowing, even after an estimated $18M in the
reserve fund is accounted for.
Commenting on the Reserve Fund Regulation, Ms. Graham explained that Saint John Water is not
restricted by the 5% of budget rule that can be put into the reserve. Staff is recommending that
$500,000 of the approximately $800,000 projected surplus, be allocated to a reserve fund, in addition to
the $2.3M that is in the 2016 utility operating budget.
Moved by Councillor Reardon, seconded by Mayor Darling:
RESOLVED that the Finance Committee recommend to Common Council that $500,000 of the projected
surplus be transferred to the Safe Clean Drinking Water reserve fund in 2016, in addition to the
$2,355,000 approved in the 2016 Utility Operating Budget.
MOTION CARRIED.
Adjournment
Moved by Councillor Norton, seconded by Councillor Sullivan:
RESOLVED that the Finance Committee open session meeting held on Thursday, December 8, 2016 be
adjourned.
MOTION CARRIED.
The Finance Committee meeting held on December 8, 2016 was adjourned at 6:05 p.m.
In
■
Q
z
W
Q
s
V
L
m
L
M
�+ V1
�+
+� E
V �
•� V
om O
�
m E
•O E
V E
� O
� V
om
� Q
rl N
r.
ca
O
O
O
N
E
c/1
a�
E
N
�
fa
t�A
U
U
�
�
•
ca
O
O
a-
2
2
2
Q
Q
Q
r.
O
c/1
N
U
U
fa
s
�
O
�
O
N
•rbn
co
•�
N
C
�n
p
2
aco
L
• U
a--+
O
O
>
W
Ln
MA
Ln
c%
V�
Q
i
4
O
Q
a
Q
z
M
Ln
r.
0
0
0
0
N
-0
a)
LL
0
. . . ...... ..... ........ -
...... . . ...... . ..
O
4-j
0
c;1-0,14,09
LLJ
z
uj
0
rt
S.
0
0=0
0
N
-0
a)
LL
0
O
4-j
LM
ru
ru
mip
LL
>
c;1-0,14,09
LLJ
z
uj
0
rt
S.
0
0=0
uvumuu,ulll
'III Vuuuuuuuuun
uuvuvulillV
LM
m
LM
(U
ME=
uull��
IUIIIpuIIIU
uill�lll�ll��
4 IVuuuuuuuuu
uuvuvlvilV
uullll
lllllummuuuuuuulll�
z
W
m
~•UD
au
H
m
C
�a
_
ncu
E
a
m
c
C
cv
E
E
o
m
V
°)
to
CSA E
M
a
4-0
M1.
m (U
V)
r�
4- v
Q
N
Q
a
m
c
cv
E
o
m
V
c_
M
a
r�
Q
m
uu,ulll
II IIIII��
uulllllllua
VIII, IIII��
II
41Vuuuuuuuuu
uullll
lllllummuuuuuuulll�
uvumullllllll
'III Vuuuuuuuuun
wuvuuu811m
LMm
III
II IIIII�I
IIIIIIIIII,IIIII
IIIII��
II
4 IVuuuuuuuuu
uu.iIV
uullll
lllllummuuuuuuulll�
YII
.N
s
�
V
N
M
�
O
O
O
0'u
o
r.
V
4mJ
M
O
u
W
�
oov
Q
O
Om
via
Om
Q
Q
�.�
V
O
O
N
M
O
O
O
0'u
o
r.
V
4mJ
M
O
u
W
�
Q
O
Om
Om
Q
II11111111
II 11111�I
IIIIIIIIII,IIIII
I1111��
11
41Vuuuuuuuuu
uu1111
lllllummuuuuuuulll�
Q
aoCL. a�.•-
Z3V . v
v\Q v - v
a •� v � Q.
Z
ay.� aaa�
r.
O
CL
a)
cc
E
W
4mJ
�
fB
W
Q
L
0
ullllllll
41 IIIIII�I
IIIIIIIIII,IIIII
IIIII��
II
41Vuuuuuuuuu
uullll
lllllummuuuuuuulll�
m
m
O
m
.N
m
s
�v
o
.�
oma,
a
0
o
v
a
�Qvo
Qj
Qj
Qj
O
�•�Q
�
vvas
.�
oma,
a
�Qvo
Qj
o
�
vvas
a 4-1
Z .W
o� I;
Its
0Its
+-+ Its
v a C: a
C: 0 � a)
ai o i
4--+
E o Nt
0j ;"
0 4-J III 11I
A O VCID
I„w
•� —
bn
a
• ` � vii v V . � � �If„ a
CIO
Q
i U O
fP
0
[ice] 1 r
W a
Q �; ].
^0^ 4.J
�..LVbn CIO
d �;
�..LCIO
L
co
0
111161 1- i'u
FS
•C: CIO .O
Z (/') 0 W;
tib �;
uuuuu
umui
I umoi
O
m
• • •
•
aA
U
O
U
Q
C6
�
-0
aA
U
O
ca
Q0
O
N
cn
a--+
C:
CL
U
U
OO
•
•i
•E
>CL
i
LL
N
C�0
N
a--+
U
ate.,
cn
N
N
a..,
Q
i
N
O_
cn
-0
OO
+�
•�
•>
J
cn
•N
N
0
N
O
N
�
N
.�
'—
O
—
N
1
>
U
=3cn
O
N
a -J
N
O
U
• i
4-J
0
cn
U
N
N
O
O
•E
_
aA
O
>
O
i.�
Q—
O•
U
i.�
E
L
Q
U
Q
=3L.L
G
-0
•
0
L
Q
N
E
t�A
m
ix
W m
a
0
420001
C:
O
o
m
c
-
L4-0
w
0
L
Q
N
E
t�A
m
ix
W m
a
0
420001
C:
O
w
cn
•�
�
O
4-0
(D
U
N
0
O
ateJ
�
U
�
IIU
J
2
a -J
LM
Q
Q
�
a -J
C:
0
L
Q
N
E
t�A
m
ix
W m
a
O
C6
tZA }'
i C6
O _0
_0 _0
+j +j
N N
w CLO
L.L L.L
.e
Irm
1
° o
m
m
4-0
4-0
O
C6
tZA }'
i C6
O _0
_0 _0
+j +j
N N
w CLO
L.L L.L
.e
Irm
.... . ....... . . ......
O
r4
.. .. .. . .. .. . . .. .. .. ..
r4
0
r4
Ulllllll'��l
CL
ro
r�,
ro
u
0
CL
0
ro
o
(N
(N
<
Lo,
41
DC
u
"
ru
o
a)
4-
N
E
(N
o
F4
<
x
E
-o
cu
z
0
'E
E
0
Q)
U
(N
11111
Ln
01
IIII'°"lu
E
umui ,
uuvuvlulllV
"M
IN
w
O
CL
I
i
Q
i
O
Q
C6cn
`
O
Ln.�
a)
fu
0
Q
},
E—
a--+
�
U
a�
U
O
N�
0
O
i
aA
•�
cn
�
U
•i
i
N
i
�-+
a�
+j
N
N
N
i
o
N
.V
ate-+
• i
cNn
Q
(6
aA
a--+
L
Ln
C6
0
a--+
+-'
E
O
E
G
4-J
N
ate-+
U
I
01
IIII'°"lu
E
umui ,
uuvuvlulllV
"M
IN
w
O
CL
ml
ra,q
N
i
Q
i
O
Q
C6cn
`
O
Ln
fu
L�
0
Q
},
E—
a--+
fu�
U
a�
U
O
N�
'•�
0
O
i
aA
•�
fu
cn
�
U
•i
i
N
i
�-+
a�
'•�
+j
N
N
N
i
o
N
.V
ate-+
• i
ca
Q
(6
aA
a--+
fu
�,
L
Ln
C6
0
a--+
+-'
fu
i
E
O
E
CC
G
4-J
N
ate-+
u
�
CD
a-
a
w
U
Q
a-
a -
ml
ra,q
N
IN
•
I
N
N
�U
�
�
C6
O
O
Q
Q
N
N
U
U
N
N
N
L
�
L
4-J
-
a --i
N
M
E
.0
fa
O
C:
O
Ln
LL
Ln
.�
�
•Q
C6
C6
L
C6
C6
Q
Q
�
Q
Q
Q
J
•
I
i
>
i
f6
U
(1)
m C
0 O
Q
O
U
Owl"
U
L
0.-
h�
.�
E
0 _N
cB ,N
0
N
U
Qi
i Q
E
>�
LL
U
OA
O —
i�
Q +
Q
cn
(10
O N
LL
LL
C
LL
U
C
U
�
o Y
c
cr
76
C N N
N
Q
U a
C6
W
U `.ti
O
N U
o J o
N
+-+
c�
d1
O
V a, C
cn
c c
= Q w
N
+� N
m
O
�
E
aM�
i
Q
N
�
O
O
c
ca
�
c
�
Q
i
GJ
N
O
c -C3 =
u
>'
03
c
U
N
E v° g
tin
ami E
V
Q
0+�c
U
N N
a 'i
>�
a
CL �
J
U
v
2-1
aQi �
J
L
76
U 6) O
U>,
O m C
E N
Q f6
a W f6
-a s
s 5
a
c
U Q
a
Q
Owl"
U
L
0.-
h�
E
/R
/� ,
E
�
4-jC
P1
Owl"
U
E
co
Zu
co
RM
Sc
I
V
N
4-J
CO
w
#;
#'
•
!,
SEEM
asom
;>
•;
MEN=
#
,,,
A
m
o,� ,
um
um
V
N
I
m
•V
'v
O
.�
•C
>co
i
o
N
VN-0
C:cn
a-+
:
C:
O
m
..
0
O
LL
V
V
V
.-
C
m
E
w
_
ca
0.
O
Oco
E
p
ca
.N
E
LM
•V
U
—
U
�
W
•
•
0
0
I
m
j//ii
fir`
woo
rylJ%ric ro GpWiY11N4
�,
%rl%1ni�r� ,�7rrrff��i��io���trrr�' �'f ��t 11tt1�%
fir/ X11
i��rfj�itlr
CIER
co
N
•
tw•
•
IM
..
rr.
1
a.
•41
0
•
0
m
• E
V)
co
E
U
41
Ln
co
a
U
N
E
bA
C:
ate-+
E
�
0
O
t
O
O
O
�
i
H
C:
aA
Ov
EO
v
+-+
_
C
p
4-J
i
U
bA
!E
'—
O
_
;
cn
N-
0
W-0
(A
w
0
0
UO
Q)
U
IF-)
U
r
a--)
UO
Q)
m
a --j
Q)
E
Q)
O
,A
0/1
19
�
5
„
I]
w
*
!
•*
•
•
••
•
�'
•
•
•
*
L-
0
!
•
w
0
!
!
•
••
•
•'
••
bn
•
••,
l
•
•n
-�
<
!
.,.
*....
*
•
0
4--)
(O
D
V)
0 AN
Liiii
Qj
i�uuuumuum m1m
m�m� uuu m
um
mu mm mummuuuuuu
mummuu�
mu mlu m,m�, d�ryry''
mu mm mummuuuu� mu�uuum
iimr, mmr mmrvmuuuuuu mu
Eli
mm m�muuuuuu m, �
�, mwm ���� mm mummuuuuuu
mum muuuuuu,,,,,,,,,u mumOM
muuuuuuuuuum
mm mummuuu,,,,,i mummuu� �ry'
uuuuuuu umuumu
m umCOD
to d�ryry'' uuuuuu
mud N
uu mummi uuu m mummi uuu m um
mm mummuuu,,,,,i mummi uuuuuuum
u um um mmmmuu�
uuuuuu
a mes,
. u mmu�mmmmum
,,,
0 co
0 +
mummuuuuuuuuuum) ii mu mmuu
uum°u �' um
uuumu m, mm mummuuu°uu mu
uuuuuu mini mem ��,� � �
uu°u mummuuuuuuuuuum
uuuuuu mummuuuuuuuuuum
mummuuuuuuuuuum mm mummuuuuuu
mummuumuuuum mmumuuu
@ mummoMM ku C)
tj Lf mm mummuu=�mu�,
um um mummlllllumnliu
mu mu um
C mummiuuuu mummuuuuuuuuuum
u,u co
mummuuuuuuuuuum mu
m mcoo coo
N
rl
•.
Qj
-`
CL Qj
®Qj
MUM CLs
4-1
. . ® 4s j -13
V)®o
4-1 Qj CN
4,j
s,
Ll- t3
Qj
ys.
+J
• ••
Qj
CA 4-1 Qj
IIIIIIU , •
t A Qj
tw.11,111,111,11
k
C- k
mmoiii uu uumm •L.+Qj s•.
Qj4.j
QJ 4-1QJ Z-
4
iu uu a°°°° uu uuuuu Wuu 4-+ a—+ S„ Q
Qj
Qj
s`
Qj
CL Q'S E•-- s•,
IIIIIIIIIIIIIIIIIU uuuuuuulllU uuuuuuulllU u�uuuuuu
15
mi
mwm uil�
mummuuuuuuuuuum
um
mu
mi
mwm uil�
uuuuuuu
um
mu
mmr mummuuuuuu
uuumu
uuumu
uuuu
mmr mummuuuuuu
mummuuuuuuuuuum
uuuuu uuumu
El
W
C
uaw mummuumuum
mmmn�llllluum�
mummuuuuuuuuuum
mummuuuuuuuuuum
uqw mummuuuuuu
i
2
a a
m� manmuuuuuu
m� manmuuuuuu
mummuuuuuuuuuum
mummuuuuuuuuuum
uqw mummuuuuuu
um
i
um
DA
V
Lli
r -I
m
UA
W
UA
IVA
bo
W
um
mu
LA
LA
C:
mm mmnmuuuuuu
W
(3)
(3)
ku
4'
Liiiiiiiiii,
0
_0
Uiiim
IQD
OW
0
Ul
smul
Lu
4a
mm m
(3)
mmnmuuuuumuumm
Clipmu
u
mu
Cl.
0
cu
mmnmuuuuumuuuuu
x
1101111111111
U
1:
C :
fu
W
Z
um
mi
E
u
0
uuumuvcumu
(3)
(3)
L4F_
mmnmm
mm
—
0
Ic
A
>
Go
>
-bill"
.0um
mu
um
cc)
LLJ
111Z
m
ITI
r*_
r -i
u
o
u
0-
_0
co
LL
co
4-J
N
ITI
r*_
r -i
uuuuu uuuum
mummuu�
um
m�mum
m
wu
��uum�uuuu�
CL
w
w
•
.1
w
•
1
•
r
'
1
•
1
•
.
•1
•1
•
•
3
•�
•
r
r
CL
•,
'
coCL
•
rl
1'
�
1
1
�
�
•
•1
�
CL
N
E-
C"?- -c-
CL
coCL
rl
'T
■
C
2
m
r -I
0
N
u
>
E
VII)
0
tw00MI1114%
o
(A
>
(A
&\0
smillillillill
m
>
tw
E
ca
^�
r
E
,
\
0
0
\
smillillillill
.
�
`
�
�
� \
_
`
/
� \
�\
LL
LLIiiiiiiiiiiiiiiiiiiiiiiiip
0
N
2N
ko
N
N
A
ko
Un
o
C:
V)
C:
0
0 •-+ O
'O
0 N O
E m
CL
O
C:
E O
w O
ru o
C:
ru
2
L
m i/? 41 C Ln O (6 dA (6 O
O N O U
O E O
O N 00 N -(n
a
C
N
N
b.0
N
b.0
.
O
C:N
.N
O
cV
ON
Em
o�
LU
0
-cn-
z
o
Le
u
ol
n
0
0
0 41.
Ln
N
aA
C6
N
•
Lei
u
ate-+
U
N
0
U
K•,11
O O O O O O O
l!7 Lf1 IZI- M N r -I
LO
(spuesnoqi)
sSuines pa10a[oad pue palewIls3
>+.,
0
o
0
N
d
U
F
O
u�
0
4-j
O
cn
Q
f6
O
n
Lbn
L>
>
N
N a--+
N
f6
cn
p
>
N
i
C2A
f J
N
�
N
N
l�A
a..,
ate-+
N
cn
L
Ua
bn
i
O
N
O
O
O
,>
(/)
W
U
L
U
N
O O O O O O O
l!7 Lf1 IZI- M N r -I
LO
(spuesnoqi)
sSuines pa10a[oad pue palewIls3
I
m
0
0
0
U
I
t
+� w
E `�° n b
H u
� �
O
c
O
�
Om
t u
N v
�°
ca
L
E
0 L�O
0
c�
C t
v
O
U
t
+� w
E `�° n b
H u
N
ateJ
N
0
N
Q
N
0
L
N
a -J
C6
N
FO
U
O
L
Q
N
ca
+-+
�
N
ca
a--'
cti
te
}'
•>
a J
c6
O
N
�
�
N
.E
•�
>
E
0
+-j
Q
U
•E
U
_0
C6
U
aJ
U
.2
u
H
U
Q
-0GJ
,U
3
O
�
ateJ
N
0
N
Q
N
0
L
N
a -J
C6
N
FO
N
U
ro
4-J
4-J
O
U
C6
N
a -J
CC:
roG
^L
W
V
0
O
O
O
r -I
ryry
r -I
Ql L
LO
00
NNNN �
41
NNNNNNNN o
�
,`o_
IIIIIIIIIII
',
Ln
N..............
�L
111„ryII111I
IIID
(',.
cri
I
�LO
IIIIIIIIIIII� �NN� NNNNNNNNNNNNNNNN
W II NMY�IIIIIIIIIIIIIIII N
0
lid
O
In
M
O
O
M
O O O O O O
Ln O Ln O Ln O
N N rl i --I
(W)q) a3uelsia
U
4-
O
2O
0 >
a� o
C:
:
�
�
E 0
N
+
: - O -0 -0
-0
C:
o
0L> C:
� 4-J° M:��
I
i
N
c.n
J
U
N
N
E
E
0
o
>
0
4—j
•
aJ
L
Ln
o
0–
aN-+
(6
I
E
N
i
,_
0
cn
0
oC
N
LL
L
U
-
i
N
c.n
Ur.
O
O
O
O
O
OLn
O
O
O0
2
O
2
+-j
N
2
v
O
+-+
O
L
O
}'
O
N
U
N
Ur.
I
a
FINANCE COMMITTEE REPORT
Report Date January 17, 2017
Meeting Date January 30, 2017
Chairman Councillor Merrithew and Members of Finance Committee
SUBJECT: Water and Sewerage Accounts Receivables — December 2016
OPEN OR CLOSED SESSION
This matter is to be discussed in open session of Finance Committee.
AUTHORIZATION
Primary Author
Commissioner/Dept. HeadCity
Manager
Cathy Graham
Kevin Fudge
Jeff Trail
RECOMMENDATION
It is recommended that this report be received and filed.
EXECUTIVE SUMMARY
The purpose of this report is to provide the Finance Committee with the aged
accounts receivable balances for Saint John Water meter and flat rate customers
as of December 31St
PREVIOUS RESOLUTION
At the Finance Committee meeting of November 8t" 2016, the Water and
Sewerage Accounts Receivable as of October 31St 2016 was received for
information.
STRATEGIC ALIGNMENT
This report aligns with being fiscally responsible by reporting to the Finance
Committee the aging of receivables for Saint John Water accounts in a timely
manner. It allows Finance to report on the management of the collection efforts,
that money is being received in a timely fashion and provides an opportunity to
provide the Finance Committee updated performance metrics.
W
-2 -
REPORT
As of December 31St, 2016, Water and Sewerage account receivable balances
were as follows:
Current:
$16,989
Over 30:
$489,835
Over 60:
$1,953,145
Over 180:
$1,325,360
Total:
$3,785,329
• Meter rate billing totaling $2,268,290 was billed November 21St with a
due date of December 23rd
• Flat rate billing totaling $9,885,317 was billed on August 31St, with a due
date of October 5th
• Of this balance, there are currently $1,177,496 in pending payments for
4,845 customer accounts that are set up on pre authorized payments
plans. This represents 31% of the outstanding balance.
• Of this balance, there are currently 523 accounts that have a negotiated
payment plan for a total of $291,852.
• Accounts with balance over 180 days represent 3.02% of the 2016
operating budget ($43,947,000).
• Account Receivable Balance for December 31St, 2016 is approximately
441K less than it was December 31St, 2015.
SERVICE AND FINANCIAL OUTCOMES
N/A
INPUT FROM OTHER SERVICE AREAS AND STAKEHOLDERS
N/A
ATTACHMENTS
N/A
AElI