Attachment 1Almond Grove Funding Plan and Funding Schedule
ALMOND (;ROVE REHABUJTAT70N SCHM111.E: ASPHALT
umaaaaY.Rac6mau S
2- BR2.723 I _
- - ------
. _......,,
---
„ wvs-
Exwp Pmjen Bu1941
I
S 3,696.000 S
2,882,723
Tobl Foods Available
I
S
2 882 723
Tsa/Rn)v4a $
3.774,210
E--g Pmien Bidgn
S 813,277
5
Capizi PmjXU ReaAtcatira
S 2,132,700
813,277
S 1,500,000
(iF RMrv, 6r CWW
S 9QM0
5 940
FY 2014/15 Yc r-U i . ms
L
S 2.000,000
S 320,,933 933
TOW Fonda AVaaahle
S 3,774,210
LAto RW9,,/Alme.drs S
2,948,356
Caput Pro*,, Reaixaton
S 632,700
F)'2014/15 Y=-0Dd Fxc
3 1,479,Ofi7
5 637,700
(iF Reac.wt (F.xc,,a AM,e 23%)
S 2,020.178
S 861,731
S 1,453,925
Total Foods A-aaable,
WdderB,,au $
2340,084
S 2,948,356
IY 201411 S Yt Etd F =,n
S 617,336
EgwPraa ReFb,,.m
S 3<89.6R7
S
b 17,336
L FJLAF
S 770,000
S
590,435
Cotorw4aared Ahx.sss
S 3,281,656
S
304,205
S
589,316
OFAR Fwd lists.
S 438.792
S
438792
OF ResenLmed.� S 560,253 S 566,257
Deag.eted S' IMAD S 100,000
SPecdl St S 153,000
Post Rgie S 400 OW 153.000 5 4W.(,U0 AvaL6sbie 5:2,745319
Total R,,baWl"ti.. Cost S 16.110.145 S 3.964,772
Note: A similar table was provided in the September 15, 2015 staff report. The rehabilitation cost for
Broadway /Bachman has been updated from that table to remove the design costs of $25,000 for these
streets as staff has provided a solution that does not incur this cost.
ATTACHMENTI
Table D: Almond Grove Street
— Use of
c asn on tiami
Balance IIse oP1s
Balance
Existing Project Budget
$
3,696,000 $ 3,696,000 $
Capital Projects Reallocation
$
2,132,700 $ 2,132,700 $
Excess ERAF
$
330,000 S 329,205 $
795
Reserves '
GF Reserve for Capital
$
940,0001 $ 940,000 $
GFAR Fund Balance
$
438,792 1 $ 438,792 1 $
FY 2014/15 Year -End Excess
$
2,00 0001 $ 2,000,0001 $
GF Reserve (Excess Above 25 %)
$
10,800,000 1 $ 2,020,178 $ 8,779,822
Post Retirement Medical
$
400,000 $ 400,000 $
-
Reserve for Productivity & Special Studies
$
590,000 $ 253,000 $
337,000
Compensated Absences
(maintains 75 %fuodang)evel)
$
2,281,656 $ 589,316 $
1,692,340
Open Space Reserve
$
562,000 $ - $
562,000
Vasona ]and Sale
$
411,245 $ - $
411,245
Sustamablitylnitiatives
S
140,553 $ $
]40,553
InternaLSerwiee FWxh
Equipment R lacement
$
3,488,687 $ 590,435 $ 2,898,252
ABAG Self Insurance
$
974,063 $ - $
974,063
Worker's Comp Selflnsurance
$
666,785 $ $
666,785
Management Infomtatan System
$
2,488,868 $ $ 2,488,868
Stores
$
90,768 $ $
90,768
VehicleMauaenance
$
331,190 $ $
331,190
Faci&iesMamtenace
$
178,765 $ $
178.765
Under this scenario, staff recommends using only $590,000 from the equipment replacement
fund (the unallocated amount currently existing in the fund), $400,000 from the Post Retirement
Medical reserve and an additional $590,000 from the Compensated Absences reserve.
Almond Grove Funding Plan and Funding Schedule
ALMOND GROYEAENARIUTAnON SCHEDULE: CONCREFE
IT98al fi bn U.W. Cov S 10.953.1121 SId953112
Spi5B2016
I Spr*WI]
SpAM2019 Spr1od2019 $pdad2020
RthahRludon Cvar
FmdRWOn
- FY201YI6
FY2016/il
FY201 TAd
FY2Mdl19 .FY201f720
RreadraSBaeBmao
S
3391A39
E,C.Wp iul UUd,.
I
S 3.696.000
1
S 3.391 439
T9ul Fuv
Av.Wbk
S 3 9L439
l'a11Ba3vkr
S
4,440348
Fisud.Ymper DrdBm
5 306,561
S 709,561
C.,W Fm 1, R ka .wa
S 2.132700
S LSOO,OW
GF Rucne br CAPLN
S 940,DW
5 'NO,DW
F Y 2014115 Y., Foal F.,
s 2,OW.OW
3 1.5W,WD
GF R. 0= .c Ahne 25 %)
S ? 020.118
S 195,68]
TWI Fl."Aea0abk
5 4,44U14R
leP RldgclAbmrdn
5
3A68.45]
Cepul Pro2ccv Rmbcemv
5 631,100
$
015Yar -ibd Fxes
S ]W,OW
Gf Rac:9c (a4'444 Above 25 %)
s 1,824.491
D64&7,675W
GEAR Fwd wb.e
s 438,]92
S 153.000
foul Fwd)
A,W W
Nildtt/Reae
1
2.988333
Epupnce R4pb4wrm
S 3,488,687
S 1,488.697
GEAR Fwd Rebrc.
S 80330
5 80,330
F..-Renee Medeel
5 400,OW
S 400,OW
l ix wd YmdwrvuY
s IW,OW
S IW.OW
E. FRAF
S 330AM
5 330,000
(:9nrerwled A6 ra
�
Iw.w. 75% Gds, kml I
S 1281.656
8 589316
Toul Frodl
AVa ,
S 2,9U.333
Mss491M1iebPl.vv S
4,664,439
Nt Mlltvcm
5 ' 39
Toul
S 4.1164,439
IT98al fi bn U.W. Cov S 10.953.1121 SId953112
Table F: Almond Grove Rehabilitation: Concrete — Use of Funds
ash On RaM
Beginning Fund
Balance
Proposed Use
of -Fawls
.
F� iw�
Balance
Existing Project Budget
$
3,696,000
$
3,696,000
$
Capital Projects Realbcation
S
2,132,700
$
2,132,700
$
Excess ERAF
$
330,000
$
330,000
$
-
Reserves
GF Reserve for Capital
$
940,0001
$
940,0001
$
FY 2014/15 Year -End Excess
1 $
2,000,0001
$
2,000,000
1 $
-
GF Reserve (Excess Above 25 %)
$
10,800,000
$
2,020,178
$
8,779,822
GFAR Fund Balance
$
438,792
1 $
438,792
$
-
Post Retfrennent Medical
$
400,0001$
400,000
$
-
Reserve for Productivity & Special Studies
$
590,000
1 $
253,000
1 $
337,000
Conipersated Absences
(mardains 75% Sending level)
$
2,281,656
$
589,316
$
1,692,340
Open Space Reserve
$
562,000
$
$
562,000
Vasona Land Sale
$
411,245
$
-
$
411,245
SustaviabIry Initiatives
$
140,553
$
-
$
140,553
intettg a Service Fabds
Equipment Replacement
3,488,687 1
$
1,488,687 1
$
2,000,000
ABAG Self Insurance IS
974,063 1
$
- 1
$
974,063
Workers Comp Self Insurance 1
$
666,785 1
$
-
$
666,785
Management Information System
$
2,488,868
$
-
$
2,488,868
Office Stores
$
90,768
$
-
$
90,768
Vehicle Maauemme
$
331,190
$
-
$
331,190
Fac,laies Maintenance
$
178,765
$
-
$
178,765
T6hi
$
32,942,072
$
14,288 673
$
18,653,399
Under this scenario, staff recommends reallocating approximately $1.5 million from the
equipment replacement fund to the Almond Grove project. Of this amount, $590,000 is
currently unallocated to replacement of specific equipment and would be appropriate to use for
the almond grove project. The remaining $900,000 that is being recommended for reallocation is
currently assigned to future replacement of existing Town owned equipment. Use of these funds
will increase the Town's internal service expenditures in the future.