HomeMy WebLinkAboutAGENDA REPORT 2019 0619 REG CCSA ITEM 10ICITY OF MOORPARK,
CALIFORNIA
City Council Meeting
of June 19, 2019
ACTION Approved Staff
Reco mmendation,
Including Adoption of
Resolution No. 2019-3827.
BY B.Garza
I. Consider Establishing an IT Equipment Replacement Fund (3008), Vehicle
Replacement Fund (3009) and Facilities Replacement (3010); and Resolution
Amending Fiscal Year 2018/2019 Budget to Fund the Replacement Reserves.
Staff Recommendation: Approve Resolution No. 2019 - ____ Authorizing the
creation of three new funds and amending the Fiscal Year 2018/2019 Budget to
approve appropriation adjustments and transfers of $1,644,095.65 from various
sources to fund equipment replacement requirement; and authorizing the
designation of additional fund balance for equipment replacement obligation in
certain restricted funds. ROLL CALL VOTE (Staff: Irmina Lumbad)
Item: 10.I.
MOORPARK CITY COUNCIL
AGENDA REPORT
TO: Honorable City Council
FROM: Irmina Lumbad, Interim Finance Director
DATE: 06/19/2019 Regular Meeting
SUBJECT: Consider Establishing an IT Equipment Replacement Fund (3008),
Vehicle Replacement Fund (3009) and Facilities Replacement (3010);
and Resolution Amending Fiscal Year 2018/2019 Budget to Fund the
Replacement Reserves
SUMMARY
At June 30, 2019, the projected book value of the City’s active capital machineries and
equipment is $7,017,075.83 (Attachment 1). Of this total, $4,145,810.81 has been
included in the calculation of replacement funding. Based on the useful life of these
assets, the City should have an aggregate replacement allowance of $2,975,860.37. At
year end, the estimated balance of reserves for equipment replacement in various funds
will total $2,437,747.58. The projected shortfall for equipment replacement across
various funds is $538,112.77.
BACKGROUND
In fiscal year (FY) 1985/86, the Equipment Replacement Fund 3003 (ERF) was
established to set-aside funds to replace various machineries and equipment as they
age and/or as the asset’s useful life has exhausted. The annual contribution to the ERF
is allocated to various sources that originally financed the acquisition of the asset and/or
its function, subject to availability of unreserved fund balance. The ERF fund balance
should equal the accumulated depreciation of capital asset plus the replacement cost of
non-capital assets due for replacement less the estimated revenue from investment
earnings and proceeds from asset disposal. From ERF inception to date, there have
been $3,979,208.95 contributions from various funds; $413,349.45 investment income
and proceeds from sale of assets; and $377,351.00 development fees from Pardee
Homes, specifically for replacement of park amenities at Mammoth Highlands Park.
The City would have expended $2,423,437.37 to replace aging or outdated equipment,
Item: 10.I.
731
Honorable City Council
06/19/2019 Regular Meeting
Page 2
including $940,997 currently appropriated. The fund balance net of $377,351.00 for
Mammoth Highlands Park is estimated to be about $1,969,121.03 at year end.
During the FY 2018/19 budget development, staff established the Public, Educational
and Governmental (PEG) Capital Fund 3006 to account for PEG Franchise fees
collected from State video franchise holders and used to support capital cost of PEG
channel access facilities. The book value of qualified equipment total $244,107.47 with
related accumulated depreciation of $181,446.65. PEG fund balance is projected to be
$25,000 at year end.
Certain Special Revenue funds with strict prohibition for comingling of monies did not
make contributions to ERF but a Reserve - Equipment Replacement account (33020)
was established. The reserve amounts are as follows:
Fund
Projected Balance
at 6/30/2019
AD 84-2 Steeple Hill (2302)$19,590.96
AD 84-2 Carlsberg (2312)$20,392.09
Country Club Estates (2315)$36,646.05
Moorpark Highlands (2322)$51,009.62
Gas Tax (2415)$315,987.83
TOTAL $443,626.55
DISCUSSION
The City has deferred the annual contribution equal to the assets’ depreciation expense
due to limited resources. The last contribution was made in FY 2016/17 for
$428,551.34 ($421,829.34 from General Fund). A “general” replacement fund may not
be the best approach, considering the capital assets’ useful life varies from 3 to 20
years. Creating specific replacement funds for certain categories may provide a better
mechanism to monitor use and prioritize financing. Thus, staff is proposing to add three
(3) new replacement funds: IT Equipment Replacement Fund 3008, Vehicle
Replacement Fund 3009 and Facilities Replacement Fund 3010. The starting fund
balance of these new funds will be allocated from ERF based on the accumulated
depreciation of the assets in the categories net of any amounts assigned to special and
capital funds.
The City’s capital machineries and equipment inventory has a total book value of
$8,095,550.32 at June 30, 2018. Of this amount only $4,145,810.81 is considered in
estimating the reserve requirement for equipment replacement by June 30, 2019.
732
Honorable City Council
06/19/2019 Regular Meeting
Page 3
EXCLUDED ASSETS
Categories
Book Value at
6/30/2018
Transit/ SARA/
Theater1
FY 2018/19
Program
Replacement
Other
Adjustments2
Net Book Value
at 6/30/2018
AUTO $146,539.97 ($35,032.49) ($35,755.94)$75,751.54
COMPUTER $1,059,684.90 ($25,920.78) ($16,813.80) ($572,172.82)$444,777.50
HVYTRUCK $229,672.75 ($25,405.17)$204,267.58
LGTTRUCK $349,578.48 ($71,127.20) ($2,712.09)$275,739.19
LICVEH $131,361.73 ($5,688.87)$125,672.86
MACH $31,102.50 $31,102.50
OFFEQUIP $330,205.71 ($70,000.00)($76,920.72)$183,284.99
OFFFURN $580,408.75 ($5,429.45)($23,860.88)$551,118.42
OTHEQUIP $932,761.22 ($173,824.59) ($61,686.83) ($145,589.60)$551,660.20
OTHVEH $246,044.07 $246,044.07
OUTDOOR $727,042.83 ($9,846.61)($102,686.71)$614,509.51
PLAYEQUP $1,171,726.12 ($216,756.81) ($113,086.86)$841,882.45
TRANSIT $2,159,421.29 ($2,159,421.29)$0.00
Grand Total $8,095,550.32 ($2,444,442.72) ($426,822.30) ($1,078,474.49)$4,145,810.81
Notes:
1 Includes Transit buses $2,159,421.29, Theater $95,384.04 and those items originally funded by Successor Agency $189,637.39.
2 Other Adjustments include certain assets acquired prior to 2005 ($235,217.51); costs below $5,000 capital threshold ($151,145.00);
items already replaced but retained in books ($224,341.90); and software and licenses ($467,770.08).
The accumulated depreciation of the net machineries and equipment noted in the table
above should equal the reserve for equipment replacement. The projected accumulated
depreciation of these assets at June 30, 2019 is $2,975,860.35.
FUND SOURCES
Categories
Accumulated
Depreciation,
Projectd
6/30/2019
ERF
3003
Sched A
PEG Capital
3006
Sched B
IT Equipment
3008
Sched C
Vehicle
Replace
3009
Sched D
Facilities
Replace
3010
Sched E
Others
Sched F
AUTO $72,023.93 $72,023.93
COMPUTER $413,704.90 $24,722.36 $343,346.30 $45,636.24
HVYTRUCK $204,267.58 $93,102.43
LGTTRUCK $178,441.61 $73,257.86
LICVEH $68,538.88 $68,538.88
MACH $3,340.63 $3,340.63
OFFEQUIP $174,970.81 $68,432.30 $89,733.33 $16,805.18
OFFFURN $436,966.96 $436,966.96
OTHEQUIP $310,912.53 $83,573.94 $66,990.96 $91,960.42 $22,323.00 $21,866.19
OTHVEH $228,525.44 $142,694.34
OUTDOOR $421,127.38 $93,792.95 $20,026.03 $93,795.40 $539,891.02
PLAYEQUP $463,039.70 $463,039.70
Grand Total $2,975,860.35 $708,838.89 $181,446.65 $452,111.90 $495,307.10 $598,264.79 $539,891.02
ERF Allocation
Basis $2,254,522.68 $708,838.89 $452,111.90 $495,307.10 $598,264.79
% of Allocation 31%20% 22% 27%
ERF available
fund balance $1,969,121.03 $610,427.03 $393,824.00 $433,207.00 $531,663.00
733
Honorable City Council
06/19/2019 Regular Meeting
Page 4
Assets were reviewed and assigned to the replacement funds based on their location,
function and/or useful life. The ERF available fund balance of $1,969,121.03 was
prorated to the 3 new funds using the accumulated depreciation of those assets
assigned to the funds. Staff is proposing to transfer $1,358,694.00 from the ERF to the
3 new funds: IT Equipment Replacement Fund 3008 - $393,824.00; Vehicle
Replacement Fund 3009 - $433,207.00; and Facilities Replacement Fund 3010 -
$531,663.00. ERF will have residual of about $610,427.03 plus $377,351.00 for
Mammoth Highlands Park.
The aggregate projected available fund balance of replacement funds total
$2,437,747.58. The unfunded reserve is about $538,112.77. However, staff is only
recommending contribution of $285,401.65 from the General Fund to fully support the
replacement requirement of ERF, IT Equipment, Vehicle and Facilities Replacement
Funds as presented below. For the Special Revenue funds, a total adjustment of
$44,525.35 is required to increase their respective Reserve for Equipment Replacement
Account (33020). The funds noted “No action” are expected to post deficit fund balance
at year end.
FUNDS
Fund Balance or
Reserve for
Equipment
Replacement,
Projected
6/30/2019
Required
Reserve per
Accumulated
Depreciation,
Projected
6/30/2019
Unfunded
Reserve
Requirement Recommended Actions
AD84-2 Steeple Hill (2302)$19,590.96 $22,322.96 ($2,732.00)No action
AD84-2 Pheasant Run (2305)$0.00 $6,211.05 ($6,211.05)No action
AD84-2 Mountain Meadows (2310)$0.00 $43,410.63 ($43,410.63)No action
AD84-2 Carlsberg (2312)$20,392.09 $19,777.53 $614.56 No action
Country Club Estates (2315)$36,646.05 $49,033.28 ($12,387.23)Increase Reserve
Moorpark Highlands (2322)$51,009.62 $57,766.91 ($6,757.29)Increase Reserve
Gas Tax (2415)$315,987.83 $341,368.66 ($25,380.83)Increase Reserve
Equipment Replacement (3003)$610,427.03 $708,838.89 ($98,411.86)*General Fund Contribution
PEG Capital (3006)$25,000.00 $181,446.65 ($156,446.65)No action
IT Equipment Replacement (3008)$393,824.00 $452,111.90 ($58,287.90)*General Fund Contribution
Vehicle Replacement (3009)$433,207.00 $495,307.10 ($62,100.10)*General Fund Contribution
Facilities Replacement (3010)$531,663.00 $598,264.79 ($66,601.79)*General Fund Contribution
TOTAL $2,437,747.58 $2,975,860.35 ($538,112.77)
Total General Fund contribution ($285,401.65)
Total Increase in Reserve ($44,525.35)
Total Unfunded ($208,185.77)
FISCAL IMPACT
A budget amendment of $285,401.65 from the General Fund (1000) is requested to fully
subsidize the reserve requirement for replacement in the Equipment Replacement Fund
(3003), IT Equipment Replacement Fund (3008), Vehicle Replacement Fund (3009),
734
Honorable City Council
06/19/2019 Regular Meeting
Page 5
and Facilities Replacement Fund (3010). The anticipated salary savings from various
vacancies should offset this contribution. There will be sufficient available fund balance
to cover the increased reserves in Country Club Estates Fund (2315), Moorpark
Highlands Fund 2322 and Gas Tax Fund (2415) as follows:
Fund
Available Fund
Balance,
Projected
6/30/2019
Reserve
Adjustment
Available Fund
Balance,
Projected
7/1/2019
Country Club Estates Fund (2315) $436,255.26 $12,387.23 $423,868.03
Moorpark Highlands Fund (2322) $96,245.84 $6,757.29 $89,488.55
Gas Tax Fund (2415)$158,822.45 $25,380.83 $133,441.62
TOTAL $691,323.55 $44,525.35 $646,798.20
STAFF RECOMMENDATION (Roll Call Vote Required)
Approve Resolution No. 2019-____ Authorizing the creation of three new funds
and amending the Fiscal Year 2018/2019 Budget to approve appropriation
adjustments and transfers of $1,644,095.65 from various sources to fund
equipment replacement requirement; and authorizing the designation of
additional fund balance for equipment replacement obligation in certain restricted
funds.
Attachments: 1 - Asset Listing
2 - Resolution No. 2019 - _____
735
Attachment 1
Schedule A
S:\Finance\Ron Folder\Fund Analysis\4003 Equipment Replacement Fund\FY18-19 ERF Report\Asset Search Results_as of 06302018/1718 Asset DATA/2/20/2019
OWN FUNCTION Asset Id Description DPT Category Acquisition
Date
Adjusted Cost 1718 Adjusted
Accum
Depreciation
18/19 EST
Depr
Accumulated
Depreciation
Projected
6/30/2019
RPLC
FUND
CITY PUB SVC 10CCHVAC01 HEAT/VENT AC #1 171 OFFEQUIP 8/13/2010 $10,963.79 $8,679.67 $1,096.38 $9,776.05 3003
CITY PUB SVC 10CCHVAC02 HEAT/VENT AC#9 171 OFFEQUIP 8/13/2010 $10,963.78 $8,679.66 $1,096.38 $9,776.04 3003
CITY PUB SVC 10CCHVAC03 HEAT/VENT AC#3 171 OFFEQUIP 8/13/2010 $10,963.79 $8,679.67 $1,096.38 $9,776.05 3003
CITY PUB SVC 10CCHVAC04 HEAT/VENT AC#4 171 OFFEQUIP 8/13/2010 $10,963.78 $8,679.66 $1,096.38 $9,776.04 3003
CITY PUB SVC 10CCHVAC05 HEAT/VENT AC#2 171 OFFEQUIP 8/13/2010 $10,963.79 $8,679.67 $1,096.38 $9,776.05 3003
CITY PUB SVC 10CCHVAC06 HEAT/VENT AC#8 171 OFFEQUIP 8/13/2010 $10,963.78 $8,679.66 $1,096.38 $9,776.04 3003
CITY PUB SVC 10CCHVAC07 HEAT/VENT ACT#10 171 OFFEQUIP 8/13/2010 $10,963.78 $8,679.66 $1,096.38 $9,776.04 3003
CITY PARKS 1352 THEATER SYSTEM, AVRC 521 OTHEQUIP 1/28/2007 $10,760.77 $10,760.77 $0.00 $10,760.77 3003
CITY PARKS 1403 PORTABLE COLD FOOD PAN UNIT 411 OTHEQUIP 10/3/2007 $5,562.58 $5,562.58 $0.00 $5,562.58 3003
CITY PARKS AVCP075 WELL#1 SUBMERSIBLE PUMP 541 OTHEQUIP 10/31/2008 $21,835.68 $14,105.27 $1,472.43 $15,577.71 3003
CITY GEN GOV 001595 FLOOR AUTOSCRUBBER 171 OTHEQUIP 11/30/2011 $5,614.21 $5,614.21 $0.00 $5,614.21 3003
CITY GEN GOV 001751 FLOOR AUTOSCRUBBER 172 OTHEQUIP 1/31/2014 $5,627.96 $5,627.96 $0.00 $5,627.96 3003
CITY PARKS 001783 IRRIG CONTROL PANEL SYS WELL#1 541 OTHEQUIP 6/13/2014 $25,225.00 $6,866.84 $1,681.68 $8,548.52 3003
CITY PARKS 001784 IRRIG CONTROL PANEL SYS WELL#3 541 OTHEQUIP 6/13/2014 $25,225.00 $6,866.84 $1,681.68 $8,548.52 3003
CITY PARKS 001785 VFD SEWER CONTROL PANEL 541 OTHEQUIP 6/13/2014 $25,600.00 $6,968.84 $1,706.64 $8,675.48 3003
CITY PARKS AVCP080 PUMP, SEWAGE SUBMERSIBLE #1 541 OTHEQUIP 6/13/2014 $10,800.00 $2,940.00 $720.00 $3,660.00 3003
CITY PARKS AVCP081 PUMP, SEWAGE SUBMERSIBLE #2 541 OTHEQUIP 6/13/2014 $10,800.00 $2,940.00 $720.00 $3,660.00 3003
CITY PUB SVC 001847 CONVECTION OVEN, GAS 411 OTHEQUIP 6/26/2015 $9,695.97 $1,946.96 $650.28 $2,597.24 3003
CITY GEN GOV 16EOCPHONE TELEPHONE SYSTEM, EOC 134 OTHEQUIP 6/30/2016 $13,442.28 $2,711.04 $1,355.52 $4,066.56 3003
CITY PARKS AVCP097 WELLHOUSE TIME CLOCK 541 OTHEQUIP 7/19/2017 $6,744.88 $337.20 $337.20 $674.40 3003
CITY PARKS MILLER005 SIGN, PARK W/LIGHTS 541 OUTDOOR 9/1/2000 $20,000.00 $17,833.30 $1,000.01 $18,833.30 3003
CITY PARKS MILLER018 TABLES, PICNIC 541 OUTDOOR 9/1/2000 $13,600.00 $12,126.70 $679.99 $12,806.70 3003
CITY PARKS COLVIEW040 PARK TABLES & BENCHES 541 OUTDOOR 7/30/2007 $6,917.63 $3,781.06 $348.48 $4,129.54 3003
CITY PARKS TIERRA059 PARK TABLES & BENCHES 541 OUTDOOR 8/6/2007 $10,376.44 $5,663.83 $518.83 $6,182.65 3003
CITY PARKS PECHILL054 PARK TABLES & BENCHES 541 OUTDOOR 8/13/2007 $14,988.19 $8,181.04 $749.40 $8,930.44 3003
CITY PARKS MAGNOL002 PARK BENCHES, TABLES 541 OUTDOOR 10/1/2007 $10,000.00 $5,375.08 $500.04 $5,875.12 3003
CITY PARKS CAMPUS031 PARK TABLES & BENCHES 541 OUTDOOR 4/14/2008 $9,625.47 $4,933.12 $481.32 $5,414.44 3003
CITY PARKS MTNMDW050 PARK TABLES & BENCHES 541 OUTDOOR 4/28/2008 $6,921.92 $3,523.64 $348.56 $3,872.20 3003
CITY PARKS GLENWD029 CONCRETE PARK TABLES 541 OUTDOOR 1/31/2009 $6,812.52 $3,212.07 $342.89 $3,554.97 3003
CITY PARKS 001626 IRRIGATION CONTROLLER 541 OUTDOOR 8/12/2011 $6,662.27 $4,608.11 $666.24 $5,274.35 3003
CITY PARKS 001644 IRRIGATION CONTROLLER 541 OUTDOOR 8/12/2011 $7,807.32 $5,400.03 $780.72 $6,180.75 3003
CITY PARKS 001645 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $8,919.50 $6,169.34 $891.96 $7,061.30 3003
CITY PARKS AVCP088 CARDIO STEPPER EXERCISE STATION 541 OUTDOOR 7/18/2017 $15,367.59 $768.36 $768.36 $1,536.72 3003
CITY PARKS AVCP089 CHEST/BACK PRESS EXERCISE STATIO541 OUTDOOR 7/18/2017 $11,914.66 $595.68 $595.68 $1,191.36 3003
CITY PARKS AVCP090 ELLIPTICAL EXERCISE STATION 541 OUTDOOR 7/18/2017 $17,578.56 $878.88 $878.88 $1,757.76 3003
CITY PARKS AVCP094 SQUAT PRESS EXERCISE STATION 541 OUTDOOR 7/18/2017 $11,914.66 $595.68 $595.68 $1,191.36 3003
CITY PARKS COMCNT014 PARK PLAYGROUND STRUCTURE 541 PLAYEQUP 12/27/2002 $40,843.37 $31,706.65 $2,068.68 $33,775.33 3003
CITY PARKS VILACMP010 PLAYWORLD INSTALLATION 541 PLAYEQUP 6/25/2004 $8,170.00 $5,727.60 $412.80 $6,140.40 3003
CITY PARKS MTNMDW049 PLAYGROUND STRUCTURE 541 PLAYEQUP 6/30/2006 $122,845.73 $73,810.74 $6,193.92 $80,004.66 3003
CITY PARKS VACLNY008 PLAYGROUND STRUCTURE 541 PLAYEQUP 6/30/2006 $55,135.91 $33,127.84 $2,779.92 $35,907.76 3003
736
Attachment 1
Schedule A
S:\Finance\Ron Folder\Fund Analysis\4003 Equipment Replacement Fund\FY18-19 ERF Report\Asset Search Results_as of 06302018/1718 Asset DATA/2/20/2019
OWN FUNCTION Asset Id Description DPT Category Acquisition
Date
Adjusted Cost 1718 Adjusted
Accum
Depreciation
18/19 EST
Depr
Accumulated
Depreciation
Projected
6/30/2019
RPLC
FUND
CITY PARKS TIERRA060 MEGATOWER SPACESHIP (5-12) 541 PLAYEQUP 6/8/2007 $78,817.80 $43,678.26 $3,940.92 $47,619.18 3003
CITY PARKS TIERRA061 PLAY SYSTEM (AGES 2-5) 541 PLAYEQUP 6/8/2007 $62,852.03 $34,830.41 $3,142.56 $37,972.97 3003
CITY PARKS TIERRA062 ARCH SWING FRAME DOUBLE BAY 541 PLAYEQUP 6/8/2007 $7,106.00 $3,937.95 $355.32 $4,293.27 3003
CITY PARKS TIERRA063 SUPERNOVA 541 PLAYEQUP 6/8/2007 $11,305.76 $6,265.35 $565.32 $6,830.67 3003
CITY PARKS TIERRA069 ROCK N' CROSS 541 PLAYEQUP 6/8/2007 $8,424.12 $4,668.37 $421.20 $5,089.57 3003
CITY PARKS MAGNOL004 PLAYGROUND EQUIPMENT 541 PLAYEQUP 10/1/2007 $50,794.08 $27,301.74 $2,539.68 $29,841.42 3003
CITY PARKS COLVIEW042 COL VIEW PLAYGROUND EQUIPMENT 541 PLAYEQUP 6/22/2010 $28,064.57 $11,242.73 $1,411.67 $12,654.41 3003
CITY PARKS PECHILL056 PLAYGROUND EQUIPMENT, XWAVE2 541 PLAYEQUP 6/22/2010 $6,698.00 $2,683.27 $336.91 $3,020.17 3003
CITY PARKS AVCP077 PLAYGROUND STRUCTURES 541 PLAYEQUP 7/2/2010 $147,068.84 $78,436.74 $9,804.60 $88,241.34 3003
CITY PARKS AVCP078 SWING SET, 4-SEAT 541 PLAYEQUP 9/30/2010 $17,931.59 $9,286.44 $1,206.30 $10,492.74 3003
CITY PARKS COLVIEW042-001PLAYGRD EQUIP, INSTALL COST 541 PLAYEQUP 9/30/2010 $34,485.39 $13,383.30 $1,734.39 $15,117.68 3003
CITY PARKS MAGNOL005 SWING SET; 2-SEATS 541 PLAYEQUP 9/30/2010 $13,747.67 $5,335.32 $691.44 $6,026.76 3003
CITY PARKS PECHILL056-001 PLAYGRD EQUIP INSTALL COST 541 PLAYEQUP 9/30/2010 $23,301.58 $9,043.05 $1,171.92 $10,214.97 3003
CITY PARKS PECHILL057 PLAYGROUND EQUIPMENT - 2013 541 PLAYEQUP 2/6/2013 $35,668.18 $9,660.20 $1,783.44 $11,443.64 3003
CITY PARKS POINDXR034 PLAYGROUND STRUCT W/ 3 SLIDES 541 PLAYEQUP 4/21/2015 $13,249.50 $2,103.69 $665.40 $2,769.09 3003
CITY PARKS POINDXR035 PLAYGROUND STRUCT W/ CLIMBWALL541 PLAYEQUP 4/21/2015 $8,624.76 $1,369.51 $433.20 $1,802.71 3003
CITY PARKS POINDXR037 BAY T SWING BELT SEATS 541 PLAYEQUP 4/21/2015 $5,624.76 $893.07 $282.48 $1,175.55 3003
CITY PARKS POINDXR040 PLAY STRUCT W/ 2 SLIDES 541 PLAYEQUP 4/21/2015 $34,869.21 $5,536.36 $1,751.16 $7,287.52 3003
CITY PARKS POINDXR041 CAROUSEL 541 PLAYEQUP 4/21/2015 $6,864.50 $1,089.95 $344.76 $1,434.71 3003
CITY PARKS POINDXR043 CLIMBING WALL 541 PLAYEQUP 4/21/2015 $7,046.74 $1,118.82 $353.88 $1,472.70 3003
CITY PARKS POINDXR040-001INSTALL COST 5-12 PLAY STRUCTU 541 PLAYEQUP 8/31/2015 $12,342.36 $1,779.87 $630.60 $2,410.47 3003
SUBTOTAL $1,274,970.00 $635,669.31 $73,169.60 $708,838.91
737
Attachment 1
Schedule B
S:\Finance\Ron Folder\Fund Analysis\4003 Equipment Replacement Fund\FY18-19 ERF Report\Asset Search Results_as of 06302018/1718 Asset DATA/2/20/2019
OWN FUNCTION Asset Id Description DPT Category Acquisition
Date
Adjusted Cost 1718 Adjusted
Accum
Depreciation
18/19 EST
Depr
Accumulated
Depreciation
Projected
6/30/2019
RPLC
FUND
CITY PARKS 1256 LACIE 1TB HD,MAGNIVEC,ESE QUAD 131 OFFEQUIP 8/10/2005 $38,162.43 $38,162.43 $0.00 $38,162.43 3006
CITY GEN GOV 1254 CITY HALL AUDIO SYSTEM 131 OFFEQUIP 8/11/2005 $32,128.91 $32,128.91 $0.00 $32,128.91 3006
CITY PARKS 1258 VIDEOROOM EQ 131 OFFEQUIP 9/1/2005 $14,371.68 $14,371.68 $0.00 $14,371.68 3006
CITY PARKS 1255 SABINE FEEDBACK & DIGITAL MIXR 131 OFFEQUIP 9/21/2005 $5,070.31 $5,070.31 $0.00 $5,070.31 3006
CITY GEN GOV 1269 LIGHTING SYSTEM 131 OTHEQUIP 1/4/2006 $47,595.57 $29,747.22 $2,379.78 $32,127.00 3006
CITY GEN GOV 1272 SPEAKERS, RACK AND MOUNT 131 OTHEQUIP 1/23/2006 $7,911.22 $4,918.42 $399.00 $5,317.42 3006
CITY PARKS 1423 PROJECTOR SYSTEM & INSTALL 131 OTHEQUIP 10/17/2007 $5,628.69 $5,628.69 $0.00 $5,628.69 3006
CITY GEN GOV 001795 CAMERA, VIDEO HD 134 OTHEQUIP 2/18/2015 $8,768.91 $2,939.92 $885.37 $3,825.28 3006
CITY GEN GOV 001796 CAMERA, VIDEO HD 134 OTHEQUIP 2/18/2015 $8,768.91 $2,939.92 $885.37 $3,825.28 3006
CITY GEN GOV 001797 CAMERA, VIDEO HD 134 OTHEQUIP 2/18/2015 $8,768.90 $2,939.91 $885.36 $3,825.27 3006
CITY GEN GOV 001798 CAMERA, VIDEO HD 134 OTHEQUIP 2/18/2015 $8,768.91 $2,939.92 $885.37 $3,825.28 3006
CITY GEN GOV 001799 CONTROLLER, REMOTE CAMERA 134 OTHEQUIP 2/18/2015 $5,428.89 $1,820.17 $548.16 $2,368.33 3006
CITY GEN GOV 001879 CONTROL PANEL 16-BUTTON MLE 131 OTHEQUIP 3/24/2016 $5,247.63 $1,189.83 $529.32 $1,719.15 3006
CITY GEN GOV 001865 SWITCHER FRAME MULTIMEDIA 131 OTHEQUIP 5/26/2016 $14,568.95 $3,059.97 $1,469.28 $4,529.25 3006
CITY PARKS 1307 INSCRIBER GENERATOR&MIXER 131 COMPUTER 9/26/2006 $21,068.98 $21,068.98 $0.00 $21,068.98 3006
CITY GEN GOV 001878 VIDEO SERVER/SYSTEM CONTROLLER131 COMPUTER 6/13/2016 $11,848.58 $2,468.50 $1,184.88 $3,653.38 3006
SUBTOTAL $244,107.47 $171,394.77 $10,051.88 $181,446.65
738
Attachment 1
Schedule C
S:\Finance\Ron Folder\Fund Analysis\4003 Equipment Replacement Fund\FY18-19 ERF Report\Asset Search Results_as of 06302018/1718 Asset DATA/2/20/2019
OWN FUNCTION Asset Id Description DPT Category Acquisition
Date
Adjusted Cost 1718 Adjusted
Accum
Depreciation
18/19 EST
Depr
Accumulated
Depreciation
Projected
6/30/2019
RPLC
FUND
CITY PUB SVC 001746 COPIER, COLOR DIGITAL 530 OFFEQUIP 6/9/2014 $5,069.27 $4,139.92 $929.35 $5,069.27 3008
CITY GEN GOV 001808 SCANNER FUJITSU 132 OFFEQUIP 4/20/2015 $5,845.97 $5,845.97 $0.00 $5,845.97 3008
CITY GEN GOV 001857 FUJITSU SCANNER 132 OFFEQUIP 1/20/2016 $5,889.93 $4,875.54 $1,014.39 $5,889.93 3008
CITY PARKS 1161-002 TELEPHONE, SYS CONSULTANT 151 OTHEQUIP 7/18/2001 $2,620.00 $2,620.00 $0.00 $2,620.00 3008
CITY PARKS 1161-003 TELEPHONE SYSTEM 151 OTHEQUIP 7/18/2001 $6,203.40 $6,203.40 $0.00 $6,203.40 3008
CITY PARKS 1161-004 TELEPHONE SYSTEM 151 OTHEQUIP 7/18/2001 $68,163.31 $68,163.31 $0.00 $68,163.31 3008
CITY PARKS 1164 SECURITY, VIDEO SYSTEM 211 OTHEQUIP 6/30/2002 $6,831.95 $6,831.95 $0.00 $6,831.95 3008
CITY PARKS 1165 SURVEILLANCE, VIDEO SYSTEM 211 OTHEQUIP 6/30/2002 $8,141.76 $8,141.76 $0.00 $8,141.76 3008
CITY PARKS 1239 HP DESIGNJET SCANNER 160 COMPUTER 6/30/2005 $17,695.18 $17,695.18 $0.00 $17,695.18 3008
CITY PARKS 1267 DELL SERVER POWEREDGE 850 132 COMPUTER 12/14/2005 $15,251.95 $15,251.95 $0.00 $15,251.95 3008
CITY PARKS 1293 DELL SERVER POWEREDGE 850 132 COMPUTER 12/14/2005 $15,251.95 $15,251.95 $0.00 $15,251.95 3008
CITY PARKS 1286 DUAL CORE XEON PROCESSOR 134 COMPUTER 6/11/2006 $6,956.25 $6,956.25 $0.00 $6,956.25 3008
CITY PARKS 1321 CISCO CATALYST, ANNEX BLDG 120 COMPUTER 1/22/2007 $5,232.73 $5,232.73 $0.00 $5,232.73 3008
CITY PARKS 1322 CISCO CATALYST, MPSF 311 COMPUTER 1/22/2007 $5,232.74 $5,232.74 $0.00 $5,232.74 3008
CITY PARKS 1360 WIRELESS CONTROLLER SYSTEM 134 COMPUTER 4/5/2007 $23,777.93 $23,777.93 $0.00 $23,777.93 3008
CITY PARKS 1422 CISCO CATALYST-WIFI@ CITY HALL 134 COMPUTER 9/18/2007 $5,271.34 $5,271.34 $0.00 $5,271.34 3008
CITY PARKS 1420 VMWARE INFRASTRUCTURE ACCE KIT 134 COMPUTER 6/16/2008 $6,943.37 $6,943.37 $0.00 $6,943.37 3008
CITY PARKS 1421 NEC VOICE SERVER UPGRADE 134 COMPUTER 6/26/2008 $5,413.59 $5,413.59 $0.00 $5,413.59 3008
CITY PARKS 1450 SERVER, QUAD CORE E5450 ESX2 134 COMPUTER 7/1/2008 $13,438.27 $13,438.27 $0.00 $13,438.27 3008
CITY PARKS 1451 SAN STORAGE UNIT SWITCH 134 COMPUTER 7/1/2008 $32,563.01 $32,563.01 $0.00 $32,563.01 3008
CITY PARKS 1452 SAN STORAGE UNIT SWITCH 134 COMPUTER 7/1/2008 $32,563.01 $32,563.01 $0.00 $32,563.01 3008
CITY PARKS 1478 DISK ARRAY ENCLOSURE 134 COMPUTER 1/28/2010 $7,651.75 $7,651.75 $0.00 $7,651.75 3008
CITY PARKS 1458 CISCO CATALYST NETWORK SWITCH 134 COMPUTER 3/30/2010 $7,031.92 $7,031.92 $0.00 $7,031.92 3008
CITY GEN GOV 001562 GRAPHIC SYS CHARACTE GENERATOR134 COMPUTER 7/1/2011 $11,761.25 $11,761.25 $0.00 $11,761.25 3008
CITY GEN GOV 001729 NEC SV8300 VOICE SERVER 134 COMPUTER 5/1/2013 $13,837.85 $8,936.92 $1,729.74 $10,666.66 3008
CITY GEN GOV 001744 SCANNER, FLATBED DUPLEX 132 COMPUTER 5/5/2014 $5,685.00 $5,685.00 $0.00 $5,685.00 3008
CITY GEN GOV 001743 SCANNER, FLATBED DUPLEX 160 COMPUTER 5/19/2014 $5,685.00 $5,685.00 $0.00 $5,685.00 3008
CITY PUB SFTY 001801 SMARTBOARD, INTERACTIVE DISPLA 212 COMPUTER 3/15/2015 $13,816.87 $13,816.87 $0.00 $13,816.87 3008
CITY PUB SFTY 001809 HP DESIGNJET PLOTTER 212 COMPUTER 4/22/2015 $9,913.70 $9,913.70 $0.00 $9,913.70 3008
CITY GEN GOV 001834 COMPELLENT STORAGE ARRAY 134 COMPUTER 6/22/2015 $37,504.54 $22,821.92 $7,660.50 $30,482.42 3008
CITY GEN GOV 001835 COMPELLENT STORAGE ARRAY 134 COMPUTER 6/22/2015 $36,096.15 $21,964.86 $7,372.83 $29,337.68 3008
CITY GEN GOV 001840 POWEREDGE R630 SERVER 134 COMPUTER 6/22/2015 $10,549.45 $6,419.46 $2,154.79 $8,574.24 3008
CITY GEN GOV 001841 POWEREDGE R630 SERVER 134 COMPUTER 6/22/2015 $10,549.45 $6,419.46 $2,154.79 $8,574.24 3008
CITY GEN GOV 001842 POWEREDGE R630 SERVER 134 COMPUTER 6/22/2015 $10,549.45 $6,419.46 $2,154.79 $8,574.24 3008
SUBTOTAL $474,989.29 $426,940.73 $25,171.17 $452,111.90
739
Attachment 1
Schedule D
S:\Finance\Ron Folder\Fund Analysis\4003 Equipment Replacement Fund\FY18-19 ERF Report\Asset Search Results_as of 06302018/1718 Asset DATA/6/12/2019
OWN FUNCTION Asset Id Description DPT Category Acquisition
Date
Adjusted Cost 1718 Adjusted
Accum
Depreciation
18/19 EST
Depr
Accumulated
Depreciation
Projected
6/30/2019
RPLC
FUND
CITY PARKS VEH061 TOYOTA PRIUS HYBRID 310 AUTO 6/15/2006 $25,990.56 $25,990.56 $0.00 $25,990.56 3009
CITY PARKS VEH065 07 ESCAPE HYBRID 222 AUTO 10/2/2006 $27,395.53 $27,395.53 $0.00 $27,395.53 3009
CITY PARKS VEH094 2014 CHEVY VOLT
LIC# 1308621
310 AUTO 1/13/2017 $22,365.45 $11,182.70 $7,455.14 $18,637.84 3009
CITY PARKS VEH011 TRUCK, STENCIL 310 HVYTRUCK 3/1/1994 $41,468.00 $41,468.00 $0.00 $41,468.00 3009
CITY PARKS VEH052 '02 CHEVY SILVERADO 541 HVYTRUCK 12/11/2002 $24,816.00 $24,816.00 $0.00 $24,816.00 3009
CITY PARKS VEH071 08 FORD E350 SUPER DUTY VAN 171 HVYTRUCK 5/14/2008 $26,818.43 $26,818.43 $0.00 $26,818.43 3009
CITY PARKS VEH060 FORD RANGER PU TRUCK 2006 521 LGTTRUCK 1/17/2006 $13,397.15 $13,397.15 $0.00 $13,397.15 3009
CITY PARKS VEH089 2012 TRUCK CHEVY SILVERADO1500 541 LGTTRUCK 10/4/2012 $26,348.34 $18,937.82 $3,293.52 $22,231.34 3009
CITY PUB SVC VEH102 2016 FORD F150 TRUCK 441 LGTTRUCK 2/29/2016 $35,699.40 $10,510.41 $4,511.45 $15,021.86 3009
CITY PUB SVC VEH103 2016 FORD F150 TRUCK 441 LGTTRUCK 2/29/2016 $35,699.40 $10,510.41 $4,511.45 $15,021.86 3009
CITY PUB SVC VEH104 2017 CHEVROLET COLORADO 311 LGTTRUCK 4/4/2017 $26,971.25 $4,214.25 $3,371.40 $7,585.65 3009
CITY PUB SFTY VEH078 MOTORCYCLE, 2010 HARLEY-DAVID 211 LICVEH 9/11/2009 $19,000.00 $19,000.00 $0.00 $19,000.00 3009
CITY PUB SFTY VEH090 MOTORCYCLE, BMW 2012 211 LICVEH 12/31/2012 $24,307.13 $16,825.85 $3,095.72 $19,921.57 3009
CITY PUB SFTY VEH100 MOTORCYCLE,HARLEY-DAVIDSON2016211 LICVEH 1/5/2016 $26,778.23 $8,368.20 $3,347.28 $11,715.48 3009
CITY PUB SFTY VEH101 MOTORCYCLE,HARLEY-DAVIDSON2016211 LICVEH 1/5/2016 $27,583.16 $8,619.71 $3,447.90 $12,067.61 3009
CITY PUB SFTY VEH105 2018 HARLEY-FLHTP MOTORCYCLE 211 LICVEH 1/17/2018 $28,004.34 $2,333.68 $3,500.54 $5,834.22 3009
CITY PARKS VEH106 TRAILER AERIAL LIFT (BOOM) - 2018 GE 541 MACH 2/20/2018 $31,102.50 $1,267.13 $2,073.50 $3,340.63 3009
CITY PUB SVC 1273 GENIE ONE MAN LIFT 171 OTHEQUIP 2/6/2006 $6,969.14 $4,326.75 $348.48 $4,675.23 3009
CITY PUB SVC 1409 PORTABLE MESSAGE SIGN 311 OTHEQUIP 12/5/2007 $19,144.13 $10,130.53 $957.24 $11,087.77 3009
CITY PARKS AERATOR-11 TURF AERATOR 541 OTHEQUIP 11/30/2011 $12,934.35 $5,690.72 $869.28 $6,560.00 3009
CITY PARKS 413 TRAILER W/SPRAYER TANK 310 OTHVEH 1/1/1990 $7,200.00 $7,200.00 $0.00 $7,200.00 3009
CITY PARKS VEH037 TRAILER W/SPRAY TANK 310 OTHVEH 1/1/1994 $8,500.00 $8,500.00 $0.00 $8,500.00 3009
CITY PARKS VEH040 TRAILER W/AIR COMPRESSOR 310 OTHVEH 3/1/1994 $10,528.00 $10,528.00 $0.00 $10,528.00 3009
CITY PARKS VEH017 TRACTOR/LOADER 310 OTHVEH 12/1/1997 $39,824.00 $39,824.00 $0.00 $39,824.00 3009
CITY PARKS VEH055 VERMEER 1000XL BRUSH CHIPPER 541 OTHVEH 10/29/2004 $26,146.48 $17,893.10 $1,320.54 $19,213.64 3009
CITY PARKS VEH062 MASS CASUALTY DISASTER TRAILER 212 OTHVEH 2/8/2006 $25,600.00 $25,600.00 $0.00 $25,600.00 3009
CITY PARKS VEH073 PRESSURE WASHER TRAILER&TANK 541 OTHVEH 9/30/2008 $4,606.39 $4,606.39 $0.00 $4,606.39 3009
CITY PUB SFTY VEH076 I2 SEGWAY BASE MODEL 211 OTHVEH 3/31/2009 $5,954.47 $5,954.47 $0.00 $5,954.47 3009
CITY PUB SFTY VEH077 I2 SEGWAY BASE MODEL 211 OTHVEH 3/31/2009 $5,954.47 $5,954.47 $0.00 $5,954.47 3009
CITY PARKS VEH083 LOADER/TRACTOR, JOHN DEERE4720 541 OTHVEH 11/9/2011 $17,658.07 $7,848.00 $1,177.20 $9,025.20 3009
CITY PARKS VEH088 ELECTRIC UTILITY CART W/AL BED 541 OTHVEH 11/30/2011 $8,241.09 $5,451.17 $837.00 $6,288.17 3009
CITY PARKS VEH084 LIGHT TOWER-4-6KW 541 OUTDOOR 3/14/2003 $7,495.32 $7,495.32 $0.00 $7,495.32 3009
CITY PARKS VEH085 LIGHT TOWER-4-6KW 541 OUTDOOR 3/14/2003 $7,495.32 $7,495.32 $0.00 $7,495.32 3009
CITY PARKS TOPDRESSER 2014 XL TOPDRESSER 541 OUTDOOR 10/24/2014 $16,119.63 $3,953.95 $1,081.44 $5,035.39 3009
CITY PUB SFTY VEH10X 2019 CHEVROLET EQUINOX 1 OF 2 211 LGTTRUCK 6/30/2018 $32,500.00 $0.00 $0.00 $0.00 3009
CITY PUB SFTY VEH10X 2019 CHEVROLET EQUINOX 2 OF 2 211 LGTTRUCK 6/30/2018 $32,500.00 $0.00 $0.00 $0.00 3009
SUBTOTAL $759,115.73 $450,108.02 $45,199.08 $495,307.10
740
Attachment 1
Schedule E
S:\Finance\Ron Folder\Fund Analysis\4003 Equipment Replacement Fund\FY18-19 ERF Report\Asset Search Results_as of 06302018/1718 Asset DATA/2/20/2019
OWN FUNCTION Asset Id Description DPT Category Acquisition
Date
Adjusted Cost 1718 Adjusted
Accum
Depreciation
18/19 EST
Depr
Accumulated
Depreciation
Projected
6/30/2019
RPLC
FUND
CITY PUB SVC 1305 CITY HALL FRONT COUNTER 171 OFFFURN 6/30/2006 $24,902.22 $14,962.22 $1,255.56 $16,217.78 3010
CITY PUB SFTY PDCTR001 FURNITURE, POLICE DEPARTMENT 120 OFFFURN 6/30/2006 $260,050.00 $156,248.60 $13,111.80 $169,360.40 3010
CITY PUB SVC LIBRARY002 LIBRARY FURNITURES 530 OFFFURN 1/15/2007 $58,173.81 $58,173.81 $0.00 $58,173.81 3010
CITY PUB SVC CIVIC024 CITYHALL EXPANSION,FURNISHINGS 160 OFFFURN 3/30/2007 $77,162.10 $77,162.10 $0.00 $77,162.10 3010
CITY PUB SVC MPSF003 MPSF FURNITURES 311 OFFFURN 4/5/2007 $97,154.08 $97,154.08 $0.00 $97,154.08 3010
CITY PUB SVC 1416 SHELVING SYSTEM & INSTALL 530 OFFFURN 11/26/2007 $18,282.21 $9,687.86 $920.87 $10,608.74 3010
CITY PUB SVC 1454 LIBRARY PANEL & SHELVING UNIT 530 OFFFURN 9/30/2008 $15,394.00 $7,515.10 $774.96 $8,290.06 3010
CITY PARKS 2014BCKBRD BACKBOARD, BASKETBALL 171 OTHEQUIP 9/10/2014 $17,975.23 $6,890.43 $1,797.49 $8,687.91 3010
CITY PARKS AVCP082 BLEACHERS, GYM TELESCOPIC 171 OTHEQUIP 1/22/2015 $50,088.00 $8,579.26 $2,515.68 $11,094.94 3010
CITY PARKS 2018 BROADBAN CENIC HIGH-CAPACITY FIBER NETWOR 530 OTHEQUIP 6/30/2018 $30,000.00 $583.33 $1,500.00 $2,083.33 3010
CITY PARKS CMPSCYN033 FENCE, REPLACE WROUGHT IRON 541 OUTDOOR 2/2/2000 $17,895.00 $16,478.28 $894.75 $17,373.02 3010
CITY PUB SVC PUBWRKS008 BUS SHELTERS 430 OUTDOOR 6/29/2005 $108,930.22 $64,697.09 $6,395.16 $71,092.25 3010
CITY PARKS 001905 BOOK/MEDIA DROP DEPOSITORY 60 C 171 OUTDOOR 9/5/2017 $8,465.53 $2,508.29 $2,821.84 $5,330.13 3010
CITY PARKS 1361 LIBRARY CONNECTIVITY SYSTEM 530 COMPUTER 1/9/2007 $19,822.39 $19,822.39 $0.00 $19,822.39 3010
CITY PARKS MPSF002 MPSF CONNECTIVITY SYSTEM 311 COMPUTER 4/30/2007 $25,813.85 $25,813.85 $0.00 $25,813.85 3010
SUBTOTAL $830,108.64 $566,276.69 $31,988.11 $598,264.79
741
Attachment 1
Schedule F
S:\Finance\Ron Folder\Fund Analysis\4003 Equipment Replacement Fund\FY18-19 ERF Report\Asset Search Results_as of 06302018/1718 Asset DATA/2/20/2019
OWN FUNCTION Asset Id Description DPT Category Acquisition
Date
Adjusted Cost 1718 Adjusted
Accum
Depreciation
18/19 EST
Depr
Accumulated
Depreciation
Projected
6/30/2019
RPLC
FUND
CITY PARKS VEH024 TRUCK, DUMP 310 HVYTRUCK 9/6/2000 $28,807.00 $28,807.00 $0.00 $28,807.00 2415
CITY PARKS VEH043 TRUCK, NO RACK 310 HVYTRUCK 11/7/2001 $24,734.28 $24,734.28 $0.00 $24,734.28 2415
CITY PUB SVC VEH063A 07 FORD F-650 SD 311 HVYTRUCK 7/31/2006 $57,623.87 $57,623.87 $0.00 $57,623.87 2415
CITY PARKS VEH058 TRUCK, F250 2006 311 LGTTRUCK 11/16/2005 $31,842.79 $31,842.79 $0.00 $31,842.79 2415
CITY PUB SVC VEH092 2014 FORD F250 W/ HARBOR CRANE 311 LGTTRUCK 10/8/2013 $35,030.77 $20,799.48 $4,378.84 $25,178.32 2415
CITY PUB SVC VEH093 2014 FORD F250 W/ UTILITY BED 311 LGTTRUCK 10/8/2013 $19,121.53 $11,353.34 $2,390.16 $13,743.50 2415
CITY PUB SVC VEH095 2014 FORD F150 TRUCK 311 LGTTRUCK 3/14/2014 $25,814.28 $13,982.77 $3,226.80 $17,209.57 2415
CITY PUB SVC VEH096 2014 FORD F150 TRUCK 311 LGTTRUCK 3/14/2014 $25,814.28 $13,982.77 $3,226.80 $17,209.57 2415
CITY PARKS 1140 GRINDER, STUMP/ROOT 311 OTHEQUIP 10/3/2001 $7,372.30 $7,372.30 $0.00 $7,372.30 2415
CITY PARKS 1141 STRIPER, 2 GUN 311 OTHEQUIP 4/17/2002 $6,192.62 $6,192.62 $0.00 $6,192.62 2415
CITY PUB SVC 1413 HOT WATER PRESSURE WASHER 311 OTHEQUIP 6/30/2008 $10,633.10 $10,633.10 $0.00 $10,633.10 2415
CITY PUB SVC VEH059 05 JOHN DEERE BACKHOE 311 OTHVEH 11/17/2005 $66,633.35 $66,633.35 $0.00 $66,633.35 2415
CITY PARKS VEH074 PORTABLE MESSAGE SIGN TRAILER 311 OTHVEH 12/31/2008 $19,197.75 $19,197.75 $0.00 $19,197.75 2415
CITY PARKS VEH086 LIGHT TOWER-4-6KW 541 OUTDOOR 3/14/2003 $7,495.32 $7,495.32 $0.00 $7,495.32 2415
CITY PARKS VEH087 LIGHT TOWER-4-6KW 541 OUTDOOR 3/14/2003 $7,495.32 $7,495.32 $0.00 $7,495.32 2415
CITY PARKS 001604 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $9,382.87 $6,489.82 $938.28 $7,428.10 2322
CITY PARKS 001605 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $8,270.24 $5,720.27 $827.04 $6,547.31 2322
CITY PARKS 001606 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $5,462.08 $3,778.00 $546.23 $4,324.24 2322
CITY PARKS 001608 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $5,233.40 $3,619.73 $523.32 $4,143.05 2322
CITY PARKS 001609 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $5,233.40 $3,619.73 $523.32 $4,143.05 2322
CITY PARKS 001611 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $5,004.73 $3,461.64 $500.47 $3,962.10 2322
CITY PARKS 001612 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $5,233.40 $3,619.73 $523.32 $4,143.05 2322
CITY PARKS 001613 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $5,004.72 $3,461.64 $500.47 $3,962.10 2322
CITY PARKS 001614 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $5,004.72 $3,461.64 $500.47 $3,962.10 2322
CITY PARKS 001615 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $5,233.39 $3,619.73 $523.32 $4,143.05 2322
CITY PARKS 001616 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $8,270.23 $5,720.26 $827.04 $6,547.30 2322
CITY PARKS 001618 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $10,131.54 $7,007.64 $1,013.16 $8,020.80 2315
CITY PARKS 001619 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $10,056.59 $6,955.81 $1,005.66 $7,961.47 2315
CITY PARKS 001620 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $10,285.27 $7,113.98 $1,028.52 $8,142.50 2315
CITY PARKS 001621 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $9,621.75 $6,655.03 $962.16 $7,617.19 2315
CITY PARKS 001622 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $7,347.47 $5,082.04 $734.76 $5,816.80 2315
CITY PARKS 001623 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $6,116.79 $4,230.73 $611.66 $4,842.39 2315
CITY PARKS 001624 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $8,377.52 $5,794.39 $837.73 $6,632.13 2315
CITY PARKS 001627 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $7,151.64 $4,946.60 $715.19 $5,661.78 2312
CITY PARKS 001628 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $7,845.50 $5,426.49 $784.56 $6,211.05 2305
CITY PARKS 001629 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $5,352.47 $3,702.09 $535.25 $4,237.35 2312
CITY PARKS 001630 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $7,125.48 $4,928.49 $712.56 $5,641.05 2312
CITY PARKS 001631 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $5,352.47 $3,702.09 $535.25 $4,237.35 2312
CITY PARKS 001634 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $9,539.48 $6,598.16 $953.93 $7,552.10 2310
CITY PARKS 001635 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $7,152.25 $4,946.94 $715.20 $5,662.14 2310
742
Attachment 1
Schedule F
S:\Finance\Ron Folder\Fund Analysis\4003 Equipment Replacement Fund\FY18-19 ERF Report\Asset Search Results_as of 06302018/1718 Asset DATA/2/20/2019
OWN FUNCTION Asset Id Description DPT Category Acquisition
Date
Adjusted Cost 1718 Adjusted
Accum
Depreciation
18/19 EST
Depr
Accumulated
Depreciation
Projected
6/30/2019
RPLC
FUND
CITY PARKS 001636 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $9,539.47 $6,598.15 $953.94 $7,552.09 2310
CITY PARKS 001637 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $13,954.64 $9,651.98 $1,395.48 $11,047.46 2310
CITY PARKS 001638 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $12,268.19 $8,485.50 $1,226.82 $9,712.32 2302
CITY PARKS 001640 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $9,543.41 $6,600.89 $954.36 $7,555.25 2302
CITY PARKS 001641 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $7,267.68 $5,026.77 $726.77 $5,753.55 2310
CITY PARKS 001642 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $7,380.92 $5,105.18 $738.12 $5,843.30 2310
CITY PARKS 001646 IRRIGATION CONTROLLER 542 OUTDOOR 8/12/2011 $6,385.76 $4,416.81 $638.58 $5,055.39 2302
CITY PARKS 001750 IRRIGATION CONTROLLER 542 OUTDOOR 4/20/2014 $8,581.65 $3,594.09 $867.36 $4,461.45 2322
SUBTOTAL $627,519.68 $501,288.11 $38,602.91 $539,891.01
743
ATTACHMENT 2
RESOLUTION NO. 2019-_____
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF
MOORPARK, CALIFORNIA, AUTHORIZING THE CREATION
OF AN IT EQUIPMENT REPLACEMENT FUND (3008),
VEHICLE REPLACEMENT FUND (3009) AND FACILITIES
REPLACEMENT FUND (3010); AND AMENDING THE FISCAL
YEAR 2018/2019 BUDGET BY APPROPRIATING
$1,644,095.65 AND AUTHORIZING THE TRANSFERS FROM
VARIOUS SOURCES TO FUND THE EQUIPMENT
REPLACEMENT REQUIREMENT; AND AUTHORIZING THE
DESIGNATION OF ADDITIONAL FUND BALANCE FOR
EQUIPMENT REPLACEMENT OBLIGATION IN CERTAIN
RESTRICTED FUNDS
WHEREAS, in Fiscal Year (FY) 1985/86 the City established the Equipment
Replacement Fund 3003 (ERF) to set-aside money to replace various machineries and
equipment as they age and/or as the asset’s useful life has exhausted; and
WHEREAS, on June 20, 2018, the City Council adopted the Operating and Capital
Improvement Budget for FY 2018/2019 which excludes any transfers to fund the reserve
for equipment replacement; and
WHEREAS, a staff report has been presented to the City Council summarizing the
challenges of one equipment replacement fund and recommending to establish three new
funds: IT Equipment Replacement (3008), Vehicle Replacement (3009) and Facilities
Replacement (3010) to provide a better system to address the disparities caused by
varying useful life of the capital equipment categories; to prioritize the financing of reserve;
and to monitor the utilization of the funds. The reserve requirements of the assets
covered by these new funds will allocated from the ERF. Accordingly, a transfer of
$1,358,694.00 from ERF to IT Equipment Replacement Fund (3008) - $393,824.00;
Vehicle Replacement Fund (3009) - $433,207.00; and Facilities Replacement Fund
(3010) - $531,663.00 is proposed; and
WHEREAS, the same staff report included a list of capital assets with a reported
book value of $4,145,810.81 as of June 30, 2018. The City’s replacement reserves should
equal the accumulated depreciation of these assets. The estimated accumulated
depreciation of these equipment on June 30, 2019 will be $2,975,860.35; while the
projected aggregate reserves for equipment replacement will be $2,437,747.58, resulting
in a $538,112.77 shortfall; and
WHEREAS, a budget amendment of $285,401.65 from the General Fund (1000) is
requested to fully subsidize the reserve requirement for replacement in the Equipment
Replacement Fund (3003), IT Equipment Replacement Fund (3008), Vehicle
Replacement Fund (3009), and Facilities Replacement Fund (3010). Accounting entries
totaling $44,525.35 – $25,380.83 from the Gas Tax Fund (2415), $12,387.23 from Country
744
Resolution No. 2019-____
Page 2
Club Estates (2315) and $6,757.29 from Moorpark Highlands (2322) are required to be
designated as additional obligation in Account 33020 – Reserve for Equipment
Replacement within the respective funds. The remaining $208,185.77 reserves assigned
to certain Landscape Maintenance Districts and PEG Capital Fund (3006) will deferred;
and
WHEREAS, Exhibits "A” and “B”, attached hereto and made a part hereof,
describes said budget amendments and the resultant impacts to the budget line items.
NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF MOORPARK DOES
HEREBY RESOLVE AS FOLLOWS:
SECTION 1. The creation of IT Equipment Replacement Fund (3008), Vehicle
Replacement Fund (3009), and Facilities Replacement Fund (3010); and designated for
future equipment replacement, is hereby approved.
SECTION 2. An aggregate budget amendment and fund transfer of
$1,644,095.65, as more particularly described in Exhibit "A", is hereby approved.
SECTION 3. The accounting entries totaling $44,525.35 to designate additional
fund balance reserve for equipment replacement as more particularly described in Exhibit
“B”, is hereby approved.
SECTION 4. That the deferral of the funding obligation for with aggregate total
of $208,185.77 is hereby approved.
SECTION 5. The City Clerk shall certify to the adoption of this resolution and
shall cause a certified resolution to be filed in the book of original resolutions.
PASSED AND ADOPTED this 19th day of June, 2019.
________________________________
Janice S. Parvin, Mayor
ATTEST:
____________________________________
City Clerk
Attachments:
Exhibit 'A'
Exhibit ‘B’
745
Resolution No. 2019-____
Page 3
Budget Amendment for
Various Funds for
Equipment Replacement Obligation
FY 2018/2019
A. Fund Allocation
Fund/Account No.Fund Description Amount
1000-000-00000-33990 General Fund $285,401.65
3003-000-00000-33990 Equipment Replacement Fund $1,260,282.14
3008-000-00000-33990 IT Equipment Replacement Fund ($452,111.90)
3009-000-00000-33990 Vehicle Replacement Fund ($495,307.10)
3010-000-00000-33990 Facilities Replacement Fund ($598,264.79)
Total $0.00
B. Revenue Budget Allocation
Fund/Account No.Current Budget Revision Amended Budget
3003-000-00000-49010 $0.00 $98,411.86 $98,411.86
3008-000-00000-49010 $0.00 $452,111.90 $452,111.90
3009-000-00000-49010 $0.00 $495,307.10 $495,307.10
3010-000-00000-49010 $0.00 $598,264.79 $598,264.79
Total $0.00 $1,644,095.65 $1,644,095.65
C. Expenditure Appropriation
Budget Number Current Budget Revision Revised Budget
1000-000-00000-59010 $0.00 $285,401.65 $285,401.65
3003-000-00000-59010 $0.00 $1,358,694.00 $1,358,694.00
Total $0.00 $1,644,095.65 $1,644,095.65
D. Interfund Transfer
Transfer FROM
TO 1000-000-00000-49010 3003-000-00000-49010 TOTAL
3003-000-00000-49010 $98,411.86 $0.00 $98,411.86
3008-000-00000-49010 $58,287.90 $393,824.00 $452,111.90
3009-000-00000-49010 $62,100.10 $433,207.00 $495,307.10
3010-000-00000-49010 $66,601.79 $531,663.00 $598,264.79
Total $285,401.65 $1,358,694.00 $1,644,095.65
Exhibit A
746
Resolution No. 2019-____
Page 4
Fund Balance Designation for Equipment Replacement Reserve
Fund Fund/Account From To
Gas Tax 2415-000-00000-33990 $25,380.83
2415-000-00000-33020 $25,380.83
Country Club Estates 2315-000-00000-33990 $12,387.23
2315-000-00000-33020 $12,387.23
Moorpark Highlands 2322-000-00000-33990 $6,757.29
2322-000-00000-33020 $6,757.29
TOTAL $44,525.35 $44,525.35
Exhibit B
747