HomeMy Public PortalAbout08) 7F FY 2017-18 Fourth Quarter Preliminary Budget ReviewAGENDA
ITEM ?.F.
ADMINISTRATIVE SERVICES DEPARTMENT
MEMORANDUM
DATE: September 18, 2018
TO: The Honorable City Council
FROM: Bryan Cook , City Manager 1(J
Via : Susan Paragas, Administrative Services Director
By: Lee Ma, Accountant
SUBJECT: FISCAL YEAR (FY) 2017-18 FOURTH QUARTER PRELIMINARY BUDGET
REVIEW, TREASURER'S REPORT, REVENUE, EXPENDITURE AND
CAPITAL PROJECT SUMMARY REPORTS
RECOMMENDATION:
The City Council is requested to :
1. Receive the FY 2017-18 Fourth Quarter Budget Review and related reports ; and
2 . Authorize staff to revise budget estimates as indicated in Attachment "A " and
Attachment "B".
BACKGROUND:
1. On June 20 , 2017, the City Council approved the FY 2017-18 City Budget.
2. On August 1, 2017 , the City Council re-appropriated a total of $89 ,655 from FY 2016-
17 to FY 2017-18 for the Primrose Tenant Relocation and Assistance and related
services in the City Manager's Department.
3. On September 5, 2017 , the City Council approved $25,000 contractual first
amendment with Gonzalez Goodale Architects for additional on-call architectural
and urban design services.
4 . On September 19 ,2017 , the City Council approved $1 ,500 for the Taking Back Our
Community Coalition Membership funded by General Fund . The City Council also
added the Rosemead Boulevard Resurfacing as a new Capital Improvement Project
and approved a budget amendment to allocate $105,143 from the Unreserved
General Fund Balance for the required maintenance of effort and the $206,421 from
the Road Maintenance and Rehabilitation Account (RMRA) Fund .
City Council
September 18 , 2018
Page 2 of 7
5. On November 7, 2017, the City Council approved the following: $3,800 for the City
Manager's salary adjustment; $4 ,650 for the two Automated License Plate
Recognition (ALPR) Camera Systems and $20,000 for participation in the Ring
Rebate Program .
6. On November 21, 2017, the City Council approved the first quarter budget
amendments in the amounts of $1,050 appropriation from the General Fund;
$17 ,555 appropriation from the Air Quality Management District (AQMD) Fund ;
$8,000 from the Lighting/Landscape District Fund; $8,000 from the Park Acquisition
Fund ; and $4,000 homeowner loan payment and reimbursement to Community
Development Block Grant (CDBG) Fund .
7. On December 19, 2017, the City Council approved $63,200 and $30,000 to update
the Pavement Management Program and implement the traffic and pedestrian
safety measures respectively from the unallocated Gas Tax Fund .
8. On February 6, 2018, the City Council approved appropriations of $98,900 for various
contract services in the General Fund and $3,400 for an increase in the CDBG
Housing Loan Repayment program. The General Fund revenues were also reduced
by $105,000 based on the mid-year analysis of various fees.
ANALYSIS:
The FY 2017-18 Fourth Quarter Budget review process provides the City Council with an
opportunity to review and adjust original revenue projections and budgeted appropriations
based on 12 months of actual activity. Adjustments can result from changes in revenue
projections based on actual revenue received from July 1, 2017 through June 30, 2018 ,
as well as unanticipated expenditures due to information that was not previously
available .
1. FY 2017-18 GENERAL FUND AND OTHER REVENUES
After a careful and thorough review of the FY 2017-18 General Fund revenues, staff
is making recommendations for revisions to some estimates , as outlined in
Attachment "A". A review of the City's major revenue sources is provided:
• Property Tax: Property taxes continue to be one of the City's strongest revenue
sources at about 23% of General Fund budgeted revenues . Under Proposition
13, property is generally reassessed only when there is a change in ownership.
After which, its assessed value is adjusted annually by an inflation factor not to
exceed two percent. A budget amendment increase of $102 ,000 is included in
Attachment "A" as preliminary actual revenues received were higher than
budgeted . Unaudited receipts show $3.30 million in FY 2017-18 as compared to
$3 .04 million in FY 2016-17 . The primary cause of the growth is possibly due to
the increased assessed property valuation in the City .
City Council
September 18 , 2018
Page 3 of 7
• Sales Tax: Sales tax received is $65,000 over estimated budget. Thus, a request
for a budget amendment is included in Attachment "A". The total unaudited
receipts are $2.07 million which is an increase of $106,200 from the FY 2016-17
receipts . The increase may have resulted from a growth in taxable sales activities
in the City and/or one-time payments due to corrections in sales tax distributions.
• Other Taxes: Other tax revenues include franchise fees, transient occupancy tax
and real estate transfer tax ("RETT"). Franchise fees are fees collected from
service providers, who provide utility services to the residents, such as Athens
Services, The Gas Company, Southern California Edison and cable television . A
10% transient occupancy tax is collected from each guest that rents a room from
any hotel located within the City. The tax is remitted directly to the City by the
hotel owners on a monthly basis . Real estate transfer tax is a tax that is collected
when there is a change in ownership of all real properties.
Actual revenues for franchise fees and RETT were below the budgeted amounts ,
by $42,000 and $13,000, respectively , and budget reductions are recommended .
Lower revenues earned by the assessed companies could be a factor in not
meeting the City's targeted Franchise Fees budget. However, franchise fees for
FY 2017-18 are about $20,000 higher than last year.
The City's RETT revenues are affected by the number of real property sales and
the valuation of the real property sold. The actual revenue in FY 2017-18 is down
by $6,600 from prior year.
• License & Permits : License & permits include building permits, business license
fees, animal license fees, parking permit fees, impound fees , temporary parking
permits, code enforcement fees and temporary parking permit fees. Based on the
12 months of revenues received in FY 2017-18, staff is recommending a total of
$156,000 increase in budget adjustments. A majority of the collections ,
mentioned above, exceeded estimates, while a few of other fees were just below.
(see Attachment "A").
• Motor Vehicle In-Lieu Fee (VLF): VLF was established in 1935 as a uniform
statewide tax. The VLF is a tax on the ownership of a registered vehicle in place
of taxing vehicles as personal property. By law, all revenues from the VLF fund
city and county services, but the state legislature controls the tax rate and the
allocation among local governments . In 2004, the Legislature permanently
reduced the VLF tax rate and elim inated state general fund backfill to cities and
counties. Instead, cities and counties now receive additional transfers of property
tax revenues in lieu of VLF. An adjustment of $163,000 is recommended as the
unaudited actual revenues received were $4.463 million and the projected budget
was only $4.30 million .
• Charges for Services : Charges for services are revenues received from
recreation fees, facility rental fees , zoning fees and plan check fees. These
revenues are reflected when services, classes or events are provided . Based on
City Council
September 18 , 2018
Page 4 of 7
the current revenues, adjustments are recommended.
The most significant adjustments are in recreation fees and plan check fees . A
reduction in the budget for recreation fees is being recommended as actual
revenues did not meet the targeted budget. A number of recreation classes were
not offered due to the loss of use of a facility.
A budget amendment increase of $160,000 is recommended for plan check fees.
The City received a large , one-time , plan check fee collected for a development
on the old Albertson's site. Next year's baseline will have to be adjusted because
of the anticipated reduction in in the fees.
• Court Fines : Court Fines are revenues collected from citations written from both
the Los Angeles County Sheriff's Department and authorized City staff. Based on
the 12-month activities, a budget adjustment of $136,000 is recommended due to
a larger collection than estimated . However, the court fines received are less than
the prior year by $202,300.
• Interest on Investments: The City receives interest on various investments on a
monthly, quarterly, semiannually, or annual basis depending on the type of
investment. Currently the City invests with Local Agency Investment Fund (LAIF);
Certificates of Deposit (CD); the Los Angeles County Investment Pool (LACIP)
and other various Federal notes and agencies . Based on current activity, a
$46,000 budget adjustment is recommended. Interest rates have been increasing
which is the major reason interest income has also risen .
• Other Revenues : Other revenues include recyclable revenue, rental income,
sales of City property, donations and reimbursements . Budget adjustments are
recommended for recyclables at a reduction of $20 ,000 and an increase of
$27,000 for the sale of City vehicles. Estimates of recyclable revenues were
higher than collected. An unanticipated sale of seven (7) City vehicles were sold
for $27,000 .
• Other Fund Revenues: Other recommended budget adjustments in non-
General Fund revenues include increases in unanticipated higher revenues and
decreases in funds that did not receive a full 12-month allocation.
The funds with significant budget revisions include unexpected FY 2016 -17
reimbursements received from the Traffic Congestion Relief Grant Fund of
$41,000 and the Bicycle Transportation Account Fund of $197 ,000. The Lighting
and Landscape District received $122,000 more than budgeted. This increase
could be attributable to higher assessed property valuations .
There are two recommendations to reduce the revenue budgets, in the Road
Maintenance Rehabilitation ("RMR ") by $70 ,000 and Measure M by $16,000.
Their budgets were estimated on a 12-month basis, however, the RMR funds
received allocation only for six months beginning on January 2018 and Measure
City Council
September 18, 2018
Page 5 of 7
M was only for 10 months, commencing on September 2017.
2. FY 2017-18 GENERAL FUND AND OTHER EXPENDITURES
The adopted FY 2017-18 City Budget totaled $23.5 million in Operating
Expenditures, Vehicle/Equipment Outlay and Capital Improvement Projects . After a
careful and thorough review of the FY 2017-18 General Fund revenues, staff is making
recommendations for revisions to some estimates, as outlined in Attachment "B". A
review of the City's major expenditures is provided:
• Personnel Expenditures: These are costs related to employee compensation
such as salaries and benefits that include health insurance and pension costs. A
majority of the personnel expenditures in the General Fund are within the
budgeted amounts. One budget amendment recommendation is for an
unanticipated one-time expenditure related to a CaiPERS adjustment for certain
of the City's part-timers. A budget amendment is recommended at $36,000.
• Non-Personnel Operating Expenditures: These are costs related to supplies,
maintenance and services required to operate the City . For General Fund,
budget amendments totaling $292 ,100 is recommended in Attachment "B" that
include increased appropriations of $186,500 for contracted services . The
additional services needed include engineering and plan check services . These
increased costs are offset by the increase in plan check fee revenues .
• Non -General Fund Expenditures : The majority of actual expenditures in funds
other than the General Fund were within their estimated budgets. Only one
budget adjustment is recommended and is for the Lighting and Landscape District
in the amount of $62,000 due to additional repairs and maintenance to light poles
and traffic lights caused by accidents .
3. GENERAL FUND CAPITAL IMPROVEMENT PROJECTS (CIP)
Currently , the revised City CIP expenditure budget is $5 .3 million, of which 19.6% are
funded by the General Fund. The total expensed to date is $2.7 million of which
$314,000 is from the General Fund . No adjustment is recommended at this time .
4. FUND BALANCE ANALYSIS (GENERAL FUND)
Attachment "C" provides an analysis of the General Fund Balance . Estimated
General Fund Balances at June 30, 2018, are provided :
• At July 1, 2017, based on the June 30, 2017 Fund Balance reported in the
City's Comprehensive Annual Financial Report;
• Estimated General Fund Balance at June 30 , 2018 is presented using
preliminary actual FY 2017-18 balances .
The analysis further articulates the resources that are available in accordance with the
City Council
September 18, 2018
Page 6 of 7
City's adopted Budget Reserve Policy. It is anticipated the City will have an estimated
unassigned Fund Balance of almost $3.5 million which is an increase of $163 ,300
from FY 2016-17 . Committed and Assigned Reserves for restricted purposes remain
intact.
5. CITY TREASURER'S REPORT
The Treasurer or Chief Fiscal Officer is required to render an annual statement of
Investment Policy to the legislative body of the local agency and to render a monthly
report containing specific information regarding investment and deposits to the
legislative body and the Chief Administrative Officer. The attached Treasurer 's Report
(Attachment "D "), which is completed monthly and submitted to the City Council on a
monthly and quarterly basis , reflects the cash balances and investments of
$29,047,869 as of June 30, 2018. However, $1,460,161 of this amount is
restricted for the use towards Other Post-Employment Benefits .
6. REVENUESUMMARYREPORT
This report (Attachment "E") is a summary of actual revenues for the period of July 1,
2017 to June 30 , 2018. By the end of the fourth quarter, the percent of revenue
received is generally 100%. Further, the major revenues, such as property tax and
VLF , are not received equally over a 12-month period, thus providing a skewed
percentage of actual receipts collected to date .
7. EXPENDITURE SUMMARY REPORT (INCLUDING EQUIPMENT REPLACEMENT)
This report is a summary of actual expenditures for the period of July 1, 2017 to June
30, 2018 (Attachment "F") for all funds . By the end of the fourth quarter, the percent
expended is generally 1 00 %. As is the City 's policy , expenditures are kept to a
minimum . The programs that are contracted with Los Angeles County are generally a
month or two behind due to the County's timing invoicing the City .
8. CAPITAL IMPROVEMENT FINANCIAL STATUS REPORT
Attachment "G" reflects costs for thirteen (13) projects: Veteran's Monument; Senior
Master Plan ; Resurfacing of Tennis Courts at Live Oak Park ; Renovation of Live Oak
Park Community Center Office ; Update Traffic Signals on Temple City Boulevard and
other safety improvements ; Update Traffic Signals Citywide and installation of other
safety improvements ; Citywide Upgrade Traffic Street Signage ; Street Resurfacing
per Pavement Management Study (Phase 4); Rosemead Boulevard Resurfacing
Project; City Yard Building Roof; City Hall Interior Enhancement; Temple City
Boulevard Parking Lot Project; and City Parking Lots Landscape Enhancement.
CITY STRATEGIC GOALS:
The City Council is requested to receive the Budget Report and Financial Status Reports
at the close of the fourth quarter of FY 2017 -18 and authori ze the fourth quarter budget
City Council
September 18, 2018
Page 7 of 7
adjustments. This action will further the City's Strategic Goal to promote Good
Governance.
FISCAL IMPACT:
If the City Council approves the FY 2017-18 Fourth Quarter Budget adjustments listed in
Attachment A and Attachment B, General Fund revenues will be revised from $14.16
million to $14.88 million and expenditures will increase from $15 .92 million to $16.25
million. This reflects a deficit of $1 .37 million. Staff is currently reviewing the accounting
treatment of the budgeted library project funds of $1.50 million. However, using the
current actual activities, the estimated FY 2017-18 ending balance will have a surp lu s of
$162,800 .
ATTACHMENTS:
A. FY 2017-18 Fourth Quarter General Fund Revenue Adjustments
B . FY 2017-18 Fourth Quarter General Fund Expenditure Adjustments
C. FY 2017-18 Fund Balance Analysis
D. City Treasurer's Report
E. Revenue Summary Report
F. Expenditure Summary Report
G. Capital Project Financial Status Report
ATTACHMENT A
CITY OF TEMPLE CITY
FY 2017-18 FOURTH QUARTER BUDGET ADJUSTMENTS-REVENUES
Origi nal Budget Proposed Revised Budget
Revenue Descript ion Account Number Amount Adj ustment Amount Explanation
Rea l Estate T ransfe r Tax 01-810-32-3201 200,000 (13,000) 187,000 Revenue was lower than budget.
Sal es Tax 01-810-32-3205 2,000 ,000 65,000 2,065,000 Revenue exceeded budget.
Franchise Fees 01-810-32-3207 600,000 (42,000) 558,000 Revenue was l ower than budget.
Property Tax Allocation 01-810-32-3211 3,200,000 102,000 3,302,000 Revenue exceeded budget.
Business license Fees 01-820-33-3301 200,000 (5,000) 195,000 Revenue was lower than budget.
Building Permit Fees 01-820-33-3303 820,000 19,000 839,000 Higher than expected due to permit volume.
Pa rking Permit Fees 01-820-33-3305 80,000 3,000 83,000 More permit applications than expected.
Encroachment Permit Fees 01-820-33-3306 160,000 55,000 215,000 More permit applications than expected.
An imal license Fees 01-820-33-3307 45,000 (5,000) 40,000 Decrease in d og licenses.
Vehicle Impound Fees 01-820-33-3309 18,000 (4,000) 14,000 Revenue was lower than budget.
Temp Parki ng Perm it Fees 01-820-33-33 11 125,000 35,000 1 60,000 More overnight parking permits than expected .
Code Enforcement Fees 01-820-33-3313 50,000 58,000 108,000 More code vio lations resu lting in citations
In lieu VLF 01-830-34-3430 4,300,000 163,000 4,463,000 Revenue exceeded budget.
Zoning Fees 01-840-35-3503 110,000 38,000 148,000 More project applications than expected.
Recreation Fees 0 1-840-35-3505 615,000 (75,000) 540,000 City no longer use the Longden School Facil ity; Program adjustments
Plan Che ck Fees 01-840-35-3508 525,000 160,000 685,000 Due to large mixed-use proj ect required for plan checks.
Faci lity Renta l Fee s 01-840-35-3510 7 5,000 (26,000) 49,000 l ower group re servations for faci lity usage .
PW/Engineering Fees 01-840-35-3512 60,000 6,000 66,000 More applications than expected .
Court Fi nes 01-850-36-3601 4 7 5,000 136,000 611,000 Revenue exceeded budget.
Interest -CD Investm ent 01-860-37-3704 100,000 46,000 146,000 Re venue exceeded budget.
Recyclable Revenue 01-870-38-3809 50,000 (20,000) 30,000 Adjustment to Mid Year increa sed
Sa le of City Property 01-870-38-3813 27,000 27,000 Sale of seven City used veh icl es.
Total Gen era l Fund Re ven ue Adjustments 13,808,000 723,000 14,531,0 00
Pa ge 1 of 2
ATTACHMEN T A
CITY OF TEMPLE CITY
FY 2017-18 FOURT H QUARTER BUDGET ADJUSTMENTS -REVENUES
Original Budget Proposed Revised Budget
Revenue Description Account Number Amount Adjustment Amount Explanation
State COPS Grant (Brulte) 13-830-34-3402 115,000 24,000 139,000 Additional grant allocation to City.
Proposition A 15-830-34-3406 660,000 20,000 680,000 Revenue exceeded budget.
Proposition C 16-830-34-3407 540,000 26,000 566,000 Revenue exceeded budget.
Traffic Congestion Relief 22-830-34-3419 41,000 41,000 Grant reimbursement for prior year project.
MeasureR 30-830-34-3436 410,000 13,000 423,000 Revenue exceeded budget.
Sewer Reconstruction 33-840-35-3502 80,000 10,000 90,000 Revenue exceeded budget.
Road Maintenance Rehabilitation Account 40-830-34-3425 206,420 (70,000) 136,420 Revenue started in January 2018 (six months for this fiscal year).
Measure M 42-830-34-3416 400,000 {16,000) 384,000 Revenue started in September 2017 (10 months for this fiscal year).
Lighting/Landscape District 47-810-32-3214 990,000 122,000 1,112,000 Revenue exceeded budget.
Bicyc le Transportation Account 52-830-34-3445 197,000 197,000 Grant reimbursement for prior year project.
Total Special Revenue Adjustments 3,401,420 367,000 3,768,420
Page 2 of 2
Department/Program Reappropriations
Traffic Engineering
Traffi c Engineering
Traffic Surveys
Parking Administration
Legal Services
Personnel
PERS Portfolio Management Fees
Pu rchasing
Office Equipment Maintenance
Parks-Maintenance and Repa i r
Utilities
Buildings
Private/Special Contract Services
Commun ity Preservation
Memberships
Memberships
Memberships
Tra ining
Training
Administration and Engineering
Engineering Services
Gener al Government Buildings
Overtime
Utilit ies
Parking Facilities
Trai ning
Trai ning
Train ing
Total Gen eral Fund Appropriation Adjustments
Street Li ghting
Maintenance and Repair
Total Other Fund Appropriation Adjustment
Accou nt Number
01-9S0-62-4236
01-950-62-4237
01-910-46-4244
01-910-47-4342
0 1-920-49-4520
0 1-940-59-4435
01-930-54-4231
01-950-65-4425
01-930-53-4425
01-930-54-4425
01-950-65-4490
01-930-53-4490
01-96 0-71-4239
01-970-81-4150
01-970-81-4435
01-970-82-4490
01-930-53-4490
01-930-54-4490
47-960-78-4510
ATIAC HME NTB
CITY OF TEMPLE CITY
FY 2017-18 FOURTH QUART ER BUDGET ADJU STMENTS-EXPENDITURES
Original Budget
Amount
20,000
10,000
7,200
42,000
128,000
360,000
350
3,100
500
3,000
6,000
250,000
20,000
50,000
380
4,000
2,000
906,530
35,000
35,000
Prop osed
Adjustment
11,000
4,500
12,000
36,000
2 9,000
41,600
115,000
800
(500)
(300)
2,000
(2,000)
44,000
6,000
35,000
3,000
(2,000)
(1,000)
334,100
6 2,000
62,000
Page 1 of 1
Revised Budget
Amount Explanation
31,000 Increase request for traffic/pedestrian safety improvements.
14,500 Update to the expired engineering and traffic survey.
12,000 Special services.
43,200 Reappropriate rem aining unspent ba lance from FY 2016-17 to FY 2017-18 for
PERS part time employees retirement cost.
71,000 Account was under budget.
169,600 Due to increase of water usage from hot weather and cost.
475,000
1,150
2,600
200
5,000
4,000
Expenditure offset by plan check fee revenue.
Reappropriate from other program due to combining membe r ships.
Reappropriate to other program due to combining membersh ips.
Reappropriate to other program due to combining memb erships.
Reappropriate from other program due to combining training.
Reappropriate to oth er program due to combining training.
294,000 Expenditure offset by plan check fee r evenue.
26,000 Staff time needed to repair citywide br oken and lifted sidewalks.
85,000 Du e to increase of water usage from hot weather and cost.
3,380 Reapp ropri ate from other program .
2,000 Reappropriate to ot her p rogram.
1,000 Reappropriate to other p rogram.
1,240,630
97,000 Repair and maintain light poles and traffic lights due to accidents, bill
insurance when possible.
97,000
CITY OF TEMPLE CITY
FY 2017-18 GENERAL FUND BALANCE ANALYSIS-UNAUDITED
FY 2017-18
Actuals
Estimated Fund Balance July 1, 2017:
Designated
Nonspendable $ 480,576
Committed $ 3,500,000
Assigned $ 11,513,004
Unassigned $ 3,34 1,984
Total Fund Balance Before Reserves $ 18,835,564
Reserved (Internal Purposes)
City Loan (C hamber) $ 4 ,600
City Loans (Homeowners) $ 56,775
Total Fund Balance July 1, 2017 $ 18,896,939
Estimated FY 2017-18:
Revenues-FY 2017-18 $ 14,832,562
Expenditures -FY 2017-18 $ (14,393, 181)
Operating Surplus/Deficit * $ 439,381
EquipNehicle Replacement -Estimate $ (40,000)
CIPrrransfers Out-Estimate $ (236,589)
Surplus/Deficit $ 162,792
Estimated Fund Balance, June 30, 2018 $ 19,059,731
• Includes use of Unassigned Fund Balance (Reserves)
Es timated Fund Balance Designations at June 30, 2018, in accordance with the
General Fund Budget Reserve Policy
Nonspendable
Committed
Emergency/Disasters
Liquidity
Local Economic Uncertainty
Assigned
Fleet Management
Facilities Management
Techn ology Replacement
Economic Development
Opportunities for One-Time Expenditures
Unassigned
Interna l Reserves (C ity Loan s)
Estimated Fund Balance on June 30, 2018
Page 1 of 1
$ 50,000
$ 2,000,000
$ 1,450,000
$ 400,000
$ 3,540,000
$ 40,792
$ 2,254,473
$ 5 ,277,739
$
$
$
$
$
$
480,573
3,500,000
11,513,004
3,505,279
60,875
19,059,731
ATTACHMENT C
------·---
CITY OF TEMPLE CITY
TREASURER'S REPORT
June 30, 2018
Cash in Bank
Wells Fargo Bank-Checking
-Payroll
Merchant Card
US Bank -Checking
Camellia Fund
East West Bank-Monthly Market Account
Wells Fargo Bank-Checking
Petty Cash
LA IF
Effective Quarter to Date Yield 6/30/18 1. 760%
MorganStanley SmithBarney
Certificates of Deposit
Weighted Average to Date Yield 6/30/18 1.917%
Government Securities
Weighted Average to Date Yie ld 6/30/18 1.052%
Corporate Fixed Income
Weighted Average to Date Y ield 6/30/18 2 .372%
Money Market
Mutual Securities
Government Securities
Weighted Average to Date Yield 6/30/18 1.383%
Money Market
US Bank
Certificates of Deposit
Weigh ted Average to Date Yield 6/30/18 1.806%
Government Securities
Weighted Average to Date Yield 6/30/18 1.584%
Los Angeles County Pool Investment Fund
As of 6/30/18 1.870%
OPEB Investment
As of 6/30/18
TOTAL
PRIOR MONTH STATUS
Total
$
$
COST VALUE
2,679,534. 77
12,975 .61
9,945.44
152,207.72
160,000.00
11,046.63
2,100.00
1,661,496.95
3,280,000 .00
1,200,000.00
1,988,774.40
14,478.89
6,500,000.00
0.14
3,230,000.00
2,196,393.03
4,715,635.02
1 '1 00 ,000.00
28,914,588.60
29,342,194.26
$
$
ATTACHMENT D
MARKET VALUE
2,679,534.77
12,975.61
9,945.44
152,207.72
160,000.00
11,046.63
2,100.00
1,658,328.48
3,231,266.81
1,176,698.50
1,967,461.30
14,478.89
6,373,530.00
0.14
3,230,000.00
2,183,804.39
4,724,329.08
1,460,161.07 .
29,047,868.83
29,472,421.34
All in vestments are placed in accordance with the C ity of Temple City's Investment Policy . The above summary provides sufficient cash flow
liquidity to meet the next six month's estimated expenditures. This report Is in accordance with Governm ent Code Section 53646.
CITY TREASURER Page 1 of 1
ATIACHMENTE
CITY OF TEMPLE CITY
PRELIMINARY REVENUE SUMMARY REPORT-ALL FUNDS
QUARTER ENDING-JUNE 30, 2018
2016-17 2016-17 2017-18 2017-18 PERCENT
BUDGET YEAR TO DATE BUDGET YEAR TO DATE RECEIVED
JUL-JUN JUL-JUN
----------------------------------------
Taxes 5,827,000 5,238,907 6 ,060 ,000 6 ,173,067 102%
Licenses and Permits 1 ,677,000 1 ,767,407 1 ,498,000 1,653,939 110%
Intergovernmental 4 ,000,000 4,172,548 4,300,000 4,463,317 104%
Charges for Services 1 ,507,170 1 ,416,157 1,389,260 1,491 ,537 107%
Fines, Forfeitures , & Penalties 891 ,000 780,408 475 ,000 611 ,074 129%
Use of Money and Property
Interest Income 200,000 291,634 200,000 245,734 123%
Unrealized Gain (Loss) -(151 ,215) -{101 ,441}
200,000 140,419 200,000 144,293 72%
Miscellaneous 238,000 321 ,253 237,000 295,335 125%
-------------
Total General Fund Revenue 14,340,170 13,837,099 14,159,260 14,832,562 105%
Total Special Revenue Funds 6,405,580 4,591 ,539 4 ,981,020 5,123 ,307 103%
TOTAL REVENUE 20 ,745,750 18,428,638 19,140,280 19,955,869 104%
--------------------------------------------------------------------------------------------------------------------·------
Page 1 of 1
ATTACHMENT F
CITY OF TEMPLE CITY
PRELIMINARY EXPENDITURE SUMMARY REPORT-ALL FUNDS
QUARTER ENDING -JUNE 30, 2018
2016 -17 2016-17 2017-18 2017-18 PERCENT
BUDGET YEAR TO DATE BUDGET YEAR TO DATE EXPENDED
JUL-JUN JUL-JUN
-------
MANAGEMENT SERVICES
City Council 178,915 153,490 179,790 163,332 91%
City Manager 1,136,395 1,010 ,693 1,100,735 953,976 87%
City Manager (Library Project) 1,950,000 450,000 1,500,000 0 0%
City Attorney 382 ,000 353,163 362 ,000 285,350 79%
Elections 85 ,875 52,867 47 ,000 38 ,728 82%
City Clerk 324 ,825 306,542 327 ,560 323 ,907 99%
4 ,058,010 2 ,326,755 3 ,517 ,085 1 ,765,293 50%
PUBLIC SAFETY DIVISION
Law Enforcement 4 ,321,475 4 ,283,793 4,469 ,620 4,458,201 100%
Traffic Eng ineering 40,000 15,469 37 ,310 64,848 174%
Emergency Services 113,075 102,782 153,540 144,596 94%
Parking Administration 412,985 321 ,394 319 ,985 291,492 91%
4 ,887,535 4,723,438 4,980,455 4,959,137 100%
ADMINISTRATIVE SERVICES DEPARTMENT
Support Services 136,600 134,805 137,180 147,729 108%
Insurance/Benefits 1,045,285 1,089 ,663 974,230 1,000 ,818 103%
Accounting 611,510 611 ,075 624,580 591 ,241 95%
Purchasing 296,595 320 ,334 295,450 315 ,088 107%
2 ,089 ,990 2 ,155,877 2 ,031 ,440 2 ,054,876 101 %
PARKS & RECREATION DEPARTMENT
Recreation/Human Services 1 ,263,885 1 ,196,763 1,310,860 1 ,220,957 93%
Pub lic Transportatio n 852,830 665,300 758,970 747,536 98%
Parks -Maintenance/Facilities 1,078,840 1,078,206 1,094,460 1,098,329 100%
Trees & Parkways 691,690 599 ,585 672 ,390 637,199 95 %
-
3 ,887,245 3,539,854 3,836 ,680 3,704,021 97%
Page 1 of 3
CITY OF TEMPLE CITY
PRELIMINARY EXPENDITURE SUMMARY REPORT-ALL FUNDS
QUARTER ENDING -JUNE 30,2018
2016-17 2016-17 2017-18
BUDGET YEAR TO DATE BUDGET
JUL-JUN
---------------
COMMUNITY SERVICES DEPARTMENT
COMMUNITY ENHANCEMENT DIVISION
Planning 1,609 ,655 930,741 918,730
Bui ldi ng 927,410 953 ,000 7 15,790
Housing 439 ,600 308 ,971 233,870
Community Preservatio n 575,905 510 ,2 37 532,500
3,552 ,570 2 ,702,949 2,400,890
IN FRASTRUCTURE & MAINTENANC E DIVISION
Ad ministration & Engineering 480,550 476,380 690,420
T raffic Sig nal Maint enance 136,500 134,1 15 156,500
Traffic Sig ns & Strip Maint. 132,565 83,879 147,460
Street and Sidewa lk Maintenance 341 ,900 318,378 443,000
Solid Waste Management 10,115 8,195 10,110
Street Lighting 394,010 313 ,822 359,930
General Government Buildings 322,270 363,214 273,800
Parking Faci litie s 167,080 152,069 100,630
-------
1,984,990 1,850,052 2,181,850
SUB TOTAL PROGRAM EXPENDITURES 20,460,340 17,298,925 18,948,400
Page 2 of3
ATIACHM ENTF
2017-18 PERCENT
YEAR TO DATE EXPENDED
JUL-JUN
-------------------
762,040 83%
825,778 115%
164 ,959 71%
509 ,370 96%
2 ,262 ,147 94%
715,846 104%
114,074 73%
112,779 76%
379 ,853 86%
8,445 84%
356,083 99%
303,764 111 %
96,136 96%
2 ,086,980 96 %
16,832,454 89%
CITY OF TEMPLE CITY
PRELIMINARY EXPENDITURE SUMMARY REPORT -ALL FUNDS
QUARTER ENDING-JUNE 30 , 2018
2016-17
BUDGET
2016-17
YEAR TO DATE
JUL-JUN
2017-18
BUDGET
-------
SUB TOTAL PROGRAM EXPENDITURES 20,460 ,340 17,298 ,925 18 ,948 ,400
CAPITAL IMPROVEMENT FUND 5 ,540,640 1,868,212 5 ,27 5 ,615
EQUIPMENT REPLACEMENT 90 ,200 60,551 57 ,555
TRUST FUND 0 260 0
TOTAL EXPENDITURES 26,091 ,180 19,227,948 24,281 ,570
=========== =========================
CDBG LOAN REPAYMENT 2 5 ,000 25 ,000 7,400
GRAND TOTAL 26 ,116,180 19,252,948 24,288,970
=========== =========================
Page 3 of 3
2017-18
YEAR TO DATE
JUL-JUN
16,832,454
2 ,723,618
51 ,396
5 00
19,607,968
==============
7,400
19,615,368
----------------------------
ATTACHMENT F
PERCENT
EXPENDED
89%
52 %
89 %
81%
===========
100%
81%
===========
CAPITAL IMPROVEMENT PROGRAM
PROJECT DETAIL
No. Project
P16-02 Temple City Park Veteran's Monument
P17-02 Senior Master Plan
P18-01 Resurface Four Tennis Courts at Live Oak Par~
P18-02 Renovation of Live Oak Park Community Cente
Office
Recap of Funding Sources
CITY OF TEMPLE CITY
PRELIMINARY FINANCIAL STATUS REPORT
JUL 17-JUN 18
Funding Source Budget
(D) Park Acquisition 8,000
(D) General Fund 10,000
(D) Park Acquisition 15,000
(D) General Fund 35 ,000
General Fund 45,000
Park Acquisition 23,000
TOTAL CIP-PARKS MAINTENANCE I FACILITIES 68,000
(E) = Essential (N) = Necessary (M) = Mandated (R) = Routine
Page 1 of 5
ATTACHMENT G
PARKS-MAINTENANCE/FACILITIES
ACCT. NO. 60-980-59-4810
Year To Date
Expenditure Balance
8,000 -
12,551 (2 ,551)
13 ,650 1,350
26,159 8,841
60,360 7,640
(D) = Discretionary
CAPITAL IMPROVEMENT PROGRAM
PROJECT DETAIL
No . Project
P15-06 Update Traffic Signals on Temple City Blvd.
between El Camino Real Avenue and Ellis Lane,
and Other Safety Improvements
P15-07 Upgrade Traffic Signals Citywide and Install
Other Safety Improvements
Recap of Funding Sources
CITY OF TEMPLE CITY
PRELIMINARY FINANCIAL STATUS REPORT
JUL 17-JUN 18
Funding Source Budget
(N) Highway Safety 934 ,560
Improvement Program
Prop C 629 ,790
Surface Transportation 437,300
Program Local
2 ,001 ,650
(N) Highway Safety 262 ,900
Improvement Program
Prop C 629,790
Highway Safety 1 '197,460
Improvement Program
Surface Transportation 437,300
Program Local
TOTAL CIP-TRAFFIC SIGNAL MAINTENANCE 2,264,550
(E) = Essential (N) = Necessary (M) =Mandated (R) = Routine
Page 2 of 5
ATTACHMENT G
TRAFFIC SIGNAL MAINTENANCE
ACCT. NO. 60-980-73-4810
Year To Date
Expenditure Balance
1,267 ,186 734,464
180 ,607 82 ,293
1,447,793 816,757
(D) = Discretionary
CAPITAL IMPROVEMENT PROGRAM
PROJECT DETAI L
No . Project
P12-04 Citywide Upgrade Traffic Street Signage
P14-07 NPDES Storm Water Management Project
P17-03 Las Tunas Drive Study
P18-03 Street Resurfacing per Pavement Management
Plan (Phase 4)
P18-06 Rosemead Boulevard Resurfacing Project
Recap of Funding Sources
TOTAL CIP-STREET CONSTRUCTION
(E) = Essential (N) = Necessary
CITY OF TEMPLE CITY
PRELIMINARY FINANCIAL STATUS REPORT
JUL 17-JUN 18
Funding Source Budget
(M ) Genera l Fund 175,000
(E) General Fund 66,500
(D) General Fund-Economic 190,000
Development
(D) MeasureR 750 ,000
Measure M 400,000
PropC 600 ,000
1,750 ,000
(E) General Fund 105,145
RMRA 206,420
311 ,565
General Fund 346 ,645
General Fund-Economic 190,000
Development
Prop C 600 ,000
MeasureR 750,000
Measure M 400 ,000
Road Maintenance and 206,420
Repair Act
2,493,065
(M) = Mandated (R) = Routine
Page 3 of 5
ATTACHMENT G
STREET CONSTRUCTION
ACCT. NO. 60-980-75-4810
Year To Date
Ex penditure Balance
76 ,223 98 ,777
-66,500
-190,000
936 ,845 813,155
3 ,251 308 ,314
1,016,319 1,476,746
(D) = Discretionary
CAPITAL IMPROVEMENT PROGRAM
PROJECT DETAIL
No . Project
P14-11 Rebuild the Roof for the City Yard Buildings
P18-04 City Hall Interior Enhancement
Recap of Funding Sources
TOTAL CIP-GEN GOV'T BLDGS
(E) = Essential (N) = Necessary
CITY OF TEMPLE CITY
PRELIMINARY FINANCIAL STATUS REPORT
JUL 17-JUN 18
Funding Source Budget
(D) General Fund 55 ,000
(D) General Fund 80,000
General Fund 135 ,000
135,000
(M) = Mandated (R) = Routine
Page 4 of 5
ATTACHMENT G
GENERAL GOVERNMENT BUILDINGS
ACCT. NO. 60-980-81-4810
Year To Date
Expenditure Balance
47 ,506 7,494
81,385 (1 ,385)
128,891 6,109
(D) = Discretionary
CAPITAL IMPROVEMENT PROGRAM
PROJECT DETAIL
No. Project
P17-05 Temple City Blvd . Parking Lot Project
P18 -05 City Parking Lots Landscape Enhancement
Recap of Funding Sources
TOTAL CIP-GEN GOV'T SLOGS
(E) = Essential (N) = Necessary
CITY OF TEMPLE CITY
PRELIMINARY FINANCIAL STATUS REPORT
JUL 17-JUN 18
Funding Source Budget
(D) General Fund -Economic 300,000
Development
(D) General Fund 15,000
General Fund 15,000
General Fund -Economic 300 ,000
Development
315,000
(M) =Mandated (R) = Routine
GR~~ 5,275,615
ATTACHMENT G
PARKING FACILITIES
ACCT. NO. 60-980-82-4810
Year To Date
Expenditure Balance
69,134 230,866
1 '121 13,879
70,255 244,745
(D) = Discretionary
2,723,618 2,551 ,997