Loading...
HomeMy Public PortalAbout13) 9A FY Mid-Year Budget ReviewAGENDA ITEM 9.A. ADMINISTRATIVE SERVICES DEPARTMENT MEMORANDUM DATE: February 18 , 2020 TO: The Honorable City Council FROM : Bryan Cook , City Manager V ia : Susan Paragas , Administrative Services Director By : Lee Ma , Accountant SUBJECT : FISCAL YEAR (FY) 2019-20 MID-YEAR BUDGET REVIEW , TREASURER'S REPORT, REVENUE, EXPENDITURE AND CAPITAL PROJECT SUMMARY REPORTS RECOMMENDATION: The City Council is requested to : 1. Receive the FY 2019-20 Mid-Year Budget Review and related reports ; 2 . Authorize staff to revise revenue estimates as indicated in Attachment "A "; and 3 . Authorize staff to revise expenditure estimates as indicated in Attachment "B". BACKGROUND: 1. On June 18, 2019 , the C ity Council approved the FY 2019-20 budget for all funding sources in the amount of $25 ,800,010 (excludes transfers out). 2 . On June 18 , 2019 , the City Council adopted Resolution No . 19-5405 adopti ng the FY 2020 Statement of Investment Pol icy . 3 . On June 18 , 2019 the City Council also adopted Resolution No . 19-5404, to include and reappropriate any funds for all pre vious app roved projects that have no t been in it iated or completed (Section 3). The Primrose Park and Parking Lot Project was not completed in FY 2018-19 , therefore , a reapprop ria tion in the amount of $113 ,890 from the General Fund was made in FY 2019-20 . 4. On July 16, 2019 , the City Council approved an add itional $20,000 for profess ional services with R3 Consulting Group from the General Fund . City Council February 18 , 2020 Page 2 5 . On August 6, 2019 , the City Coun c il approved $26,400 from the General Fund for necessary bui ld in g improvements associated w ith the Temple City Chamber of Commerce re location to the City's Council Chambers building on Kauffman Avenue . 6 . On August 20 , 2019 , the City Counci l approved $10,000 from the General Fund for the Coyote Man agement Implementation Plan with t he San Gabriel Valley Council of Governme nts . 7. On November 19 , 2019 , the City Council appropriated an additiona l $8 ,000 from the Parks Acquisition Fund for the roofing project. The City Council also authorized the use of $122 ,500 of the Lighting and Landscape District Fund and $52 ,500 of the General Fund for the purchase of a replacement wheel loader. 8. On December 3, 2019 , the City Council approved $6 ,370 from the General Fund for adopting salary ranges for unrepresented part-time class ifications implementing the minimum wage effective on January 1, 2020 . ANALYSIS : The FY 2019-20 Mid -Year Budget review process provides the City Council with an opportunity to review and adjust original revenue projections and budgeted appropriations based on six months of actual activity. Adjustments can result from changes i n revenue projections based on actual revenue received from July 1, 2019 through December 31 , 2019 , as well as unanticipated expenditures due to information that was not previously available . It is through sign if ica nt diligence on the part of staff by finding cost-cutti ng strategies that the City has been able to preserve its financial health without elim i nating services . 1. FY 20 19-20 GENERAL FUND REVENUES After a careful and thorough review of the FY 2019-20 Gene ral Fund (GF ) revenues , staff is making recommendations for re visions to some estimates , as outlined in Attachment "A" for a total increase of $72,000. A review of th e City's majo r revenue sources is provided : • Prope rty Tax : Property taxes continue to be one of the City's strongest revenue sources. Under Proposition 13, property is generally re assessed only when there is a change in ownership . After which , its assessed value is adjusted annually by an infl ation factor not to exceed two percent. Temple City's assessed valuations co nt i nue to increase and the median home prices have exceeded the pre-recession level s of 2007. As of December 31 , 2019 , property tax collections are $86 ,160 higher than last year, FY 2018 -19. The current budget was adjusted to reflect the estimated increase from last year. No adjustment is recommended at this time . • Sales Tax : Sa les ta x decreased $20 ,000 from the second quarte r in FY 2019-20 over the same quarter in FY 2018 -19 . However, the current budget was decreased City Council February 18 , 2020 Page 3 from FY 2018-19 actual sale tax revenues . No adjustment is recommended at this time . • Other Taxes : Other tax revenues include franc hise fees , transient occupancy tax and real estate tran sfe r tax . Franchise fees are fees collected from service providers , who provide ut il ity services to the res ide nts, such as A thens Services, The Gas Company , Southern California Edison and cab le te levision. 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 transfe r tax is a tax that is collected when there is a change in ownership of all real properties . No adjustments are recommended at this time as the revenue collected are within their budgeted amounts . • License & Perm its : License & perm its include building perm its , bus iness license fees , ani ma l license fees , parking permit fees, impound fees , temporary parking permits , code enforcement fees and temporary parking permit fees . Based on the first six months of License & Permit revenues received in FY 2019-20 , staff is recomme ndi ng a reduction of $28 ,000 for Encroachment Permit Fees as it is trending lower t han pri or year's revenues (see Attachment "A "). • Mot or Vehicle in-lieu fee (VLF): VLF was established in 1935 as a uniform statewide tax , the V LF is a tax on the ownership of a registered vehicle i n p lace of taxing vehicles as personal property. By law, all revenues from the VLF fund c ity and county services , bu t the state legislature controls the tax rate and the allocation among local governments . In 2004 , the Legislature permanent ly reduced the VLF tax rate and el iminated state general fund backfill to cities and counties . Instead , cit ies and counties now receive additional transfers of property tax revenues in li eu of VLF . No adjustment is recommended at t his time . • Ch a rges fo r Serv ices : Charges for services are revenues received from recreation fees , facility rental fees , zoning fees and plan check fees. These revenues are reflected w hen services , classes or events are provided . Based on the current reven ues , a total budget increase of $100 ,000 is recommended as the revenues are tracking lower than estimates (see Attachment "A "): o Engineering Fees (-$40 ,000)-Based on current revenue col lected , the fees are projected to be lower than prior year's activities . o Plan Check Fees (+$60 ,000)-Revenues are tracking highe r than budgeted as there is an inc rease in activities . o Zoni ng Fees (+$80 ,000)-Activities are higher this f irst ha lf of FY 2019-20 and has already met 85 % of the budgeted amount of $1 7 0,000 . • Court Fines : Court Fines are revenues collected from citations written f rom both the Los Ange les Coun ty She riff's Department and authorized City staff. Based on current City Council February 18 , 2020 Page4 activity, no adjustment is recommended at this time . • 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 Loca l Agency Investment Fund (LAIF ); Certificates of Deposit (C D); the Los Angeles County Investment Poo l (LACIP) and other various Federal notes and agencies . Based on current activity, no adjustment is recommended at this time . • Other Revenues : Other revenues include recyclable revenue , renta l inc ome , sales of City property , donations and reimbursements . No adjustment is recommended at this time . 2. FY 2019-20 OTHER FUND REVENUES After reviewing other City funds , t here are no adjustments recommended at th is t ime as the revenue collections are tracking within their budgeted amounts . 3. FY 2019-20 GENERAL FUND AND OTHER FUND EXPENDITURES The adopted FY 2019-20 City Budget totaled $25 .8 million in Operating Expenditures , One-T ime Expenditures and Capital Improvement Projects . Recommendat ions for the mid-year budget adjustments are presented in Attachment "B". The recommended total GF net reduction is $380 ,335 in the follow ing expend itures : o City Manager/Special Contract Services (+$22 ,685) -Add ition al printing costs for CONNECT maga zine . o Community Development-Planning/Contract Services (+$20 ,000) - Creation of a traffic model due to SB 743 where the City needs to adopt a vehicle miles trave led traffi c threshold of significance when the City performs a California Environmenta l Quality Act review. o Elections/Los Angeles County Reg istrar ( -$107 ,250) -Cancellation of City Co un cil election . o Ge neral Government Buildings/Overtime (+$8 ,000) -Increase due to additional ass igned projects for staff. o Parking Facilities/Capital Improvements (-$40 ,000) -Re-al location of Electric Veh icle (EV) c harging station to the AQMD fund . o Purchas i ng /Special Contract Services ( +$13 ,1 00) -Re -allocat ion of three non -pl ug-in hybrid Parking Enforcement veh icle leases from AQMD . City Council February 18 , 2020 Page 5 o Purchas in g/Special Contract Services (+$60 ,000) -Down payments for three (3) Parking Enforcement vehicles . o Purchasing/Special Contract Services ( +$23 , 130) -Additional cost of internet services due to delay of internet service provider change over. o Transfers Out (-$380 ,000)-El imination of Lighting and Landscape District (L LD ) subsidy due to passage of Senate Bill 324 (see descri ption under Section 5. Recommendations for net expenditure adjustments of $561 ,900 in non-GF funds : o AQMD-Park ing Facilities (+$40 ,000)-Re-allocat ion of EV charging station from the GF . o AQMD-Special Contract Services (-$13,1 00)-Re-allocation of three non - plug-in hybrid Parking Enforcement vehicle leases to GF . o AQMD-Special Contract Services (+$14 0 ,000)-Down payments for seven (7) plug-in hybrids for replacement of currently leased veh icles . o LLD-Transfers In (-$380,000)-El imination of subsidy from GF due to SB 324 (see description under Section 5). o Park Acquisition Fund -Striping/Pavement (+$15 ,000) -Repaving of Live Oak Park jogging/walking path . 4. GENERAL FUND CAPITAL IMPROVEMENT PROJECTS (CIP) With the adoption of FY 2019-20 C ity Budget, the City Council approved and funded $5.32 million in CIP expend iture budge t , of wh ich 9.4 %, or $500 ,000 , are funded by the General Fund . However, with budget adjustments through the past six months, the total CIP budget is $5.44 million of wh ich is 11.3%, or $613 ,890 funded by the GF . No adjustment is recommended at this time . 5. FUND BALANCE ANALYSIS (GENERAL FUND) Attachment "C" prov ides an analysis of the GF Ba lance . Estimated GF Balances at June 30 , 2020 , are provided : • At July 1, 2019 , when the FY 2019-20 City Budget was adopted ; • At December 31 , 2019, which includes actual GF Balance at Ju ly 1, 2019 , is now available due to completion of the audited Comprehensive Annual Financial Report (CAFR) and budget adjustments for the first six months of operations ; City Council February 18 , 2020 Page 6 and • Estimated GF Balance at June 30 , 2020 , is presented assuming the recom mended adjustments in this report are approved and implemented . The recommendations consist of a GF Fund total increase of $72 ,000 in estimated operating revenue budget and a total decrease of $335 from the operating expenditure budget. In addition , the transfer out to subsidize the LLD operations of $380 ,000 was eliminated due to the Ca li fornia State Senate's passage of Senate Bill 324 . The bill authorized the LLD to perform maintenance and improvements pursuant to the Landscape and Lighting Act of 1972 (1972 Act) and authorize funds le vied under The Street Lighting Act of 1919 (1919 Act) to be used by the District as allowed under the 1972 act. Therefore , the adjusted GF operating surplus is increased from $107 ,375 to $523 ,270. The analysis further shows the resources that are available in accordance w ith the City's adopted Budget Reserve Policy . It is anticipated the City w i ll be mov ing in to the FY 2020-2021 City Budget process with a GF fund balance of $18 .3 million which i ncludes an unassigned balance of over $4 .3 million . Committed and Assigned Reserves for restricted purposes have a balance of just over $14 .0 million . One item that will need to be monitored is the Measure W funds, the Safe Clean Water Act parcel tax . As of now, cities have not been received the remittance in FY 2019-20 . Cities , including the City , have spent against this revenue stream to pay for infrastructure , and programs to capture , tre at, and recycle rainwater. At t he end of December 31 , 2019 , the City has spen t almost $64 ,000 . The FY 2019-20 GF surplus could possibly be used to fund the expenditures in the Measure W fund should the City not receive the Measure W revenues in FY 2019-20 . However, staff w ill look into an option of using Measure W revenues to reimburse the GF once funding is received . 6. 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 info rmation regarding investment and deposits to the leg is lative 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 balance as of December 31 , 2019 . 7. REVENUE SUMMARY REPORT This report (Attachment "E") is a summary of actual revenues for the period of July 1, 2019 to December 31 , 2019 . By the end of the second quarter the percent of revenue received is generally 50 %, except for those types of revenues that are received annually such as business licenses , animal licenses , parking permits and franchise fees . Further, the major revenues, such as property tax and VLF , are not received equally over a 12 City Counci l February 18 , 2020 Page 7 month peri od , thus prov id ing a skewed percentage of actual receipts collected to date. Detailed discussions about revenue collections year to date have been addressed earlier in this report . 8. EXPENDITURE SUMMARY REPORT (INCLUDING EQUIPMENT REPLACEMENT) This report is a summary of actual expenditures for the per iod of July 1, 2019 to December 31 , 2019 (Attachment "F"). By the end of the second quarter the percen t expended is generally 50 %. 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 in invoicing the City. 9. CAPITAL IMPROVEMENT FINANCIAL STATUS REPORT The second quarter expenditures (Attachment "G") reflect costs for three projects : Primrose Park and Park in g Lot ; Rosemead Boulevard Resurfacing and the Pavement Management Street Resurfacing for a total of $507 ,291 . 10. TRANSPORTATION FUNDS STATUS REPORT Whil e not usually addressed in the mid-year report, an update of the transportation funds is d iscussed here . The City receives five (5) Local Retu rn Program (LRP ) revenue allocations . Four of the LRP is distributed by Los Angeles County fo r the deve lopment and improvement of local public transit , paratransit and transportation infrastructure and help ease traffic congesti on : Measure M, Measure R, Propos it ion A and Proposition C . The other LRP , the Transit Development Act (TDA), Article 3 , is distributed by the state for bicycle and pedestrian facilities/projects . Measure M and Measure R funds are to be used to augment existing City revenues used for tra nsportation purposes . The el ig ible uses are for major street resurfacing , rehabilitation and reconstructi on such as : • Streets and Roads • Traffic Control Measures • Bik eways and Pedestrian Improvements • Public Transit Services • Public Transit Capital • Transportation Marketing • Planning , Engineering and/or Study , Congestion Management Program • Transportation Administration • Local Funding Contribution Proposition A is to be used exclusively to benefit public transit such : • Fixed Route and Paratransit Services City Council February 18 , 2020 Page 8 • Transportation Demand Management • Transit Systems Management • Fare subsidy programs (exclusively benefits transit) Propos itio n C are to be used the same way as Proposition A with the additional uses : • Congestion Management Programs • Commuter Bikeways and Bike Lanes • Street Improvements (supporting public transit service) • Pavement Management System projects TDA Article 3 are used for: • Engineering Expenses (leading to construction ) • Right-of-Way Acquisition • Construction and Reconstruction • Retrofitting Existing Bicycle and Pedestrian Facilities • Route Improvements • Purchase and Installation of Bicycle Facilities The City used and continue to use the funding received from the LRPs . The last 5 years ' projects , current planned projects , annual 5-year average allocations, annual 5-year average expenditures , and estimated fund balances for June 30 , 2020 are below : PROGRAM PROJECTS-LAST 5 YEARS CURRENT PLANNED PROJECTS Measure M • Street Repaving/ • Pavement Mgt Street Resurfacing Resurfacing -Las Tunas MeasureR • Street Repaving/ • Pavement Mgt Street Resurfacing Resurfacing Prop A • Dial -A-Ride • Dial -A-Ride • Recreation Excursions • Recreation Excursions • Bus Shelter Maint. • Bus Shelter Maint. • Lyft Prop C • Redesign & Construction -• Las Tunas Resurfacing Las Tunas • Traffic Signal Upgrades TDA Article 3 • Rosemead Blvd • Sidewalk and Curb Ramps- Improvement ADA Improvements City Council February 18 , 2020 Page 9 PROGRAM Measure M MeasureR Prop A Prop C TDA Article 3 ANNUAL 5-YEAR AVERAGE ALLOCATIONS $448 ,000 (2 yrs) $418 ,000 $672 ,000 $557 ,000 N/A CITY STRATEGIC GOALS: ANNUAL 5-YEAR AVERAGE EXPENDITURES $ 95 ,000 $ 798 ,000 $ 672 ,000 $ 147,000 $ 60 ,500 FY 2019-2020 ESTIMATED BUDGETED FUND BALANCE, EXPENDITURES 06 /30 /2020 $ 800 ,000 $ 424 ,000 $ 750 ,000 $ 737 ,000 $ 939 ,735 $1 ,015 ,000 $1 ,200 ,000 $1 ,157 ,000 $ 71 ,000 $ 27 ,500 The City Council is requested to receive the Mid-Year Budget Report and Financ ial Status Reports at the close of the second quarter of FY 2019-20 and authorize the M id-Year Budget adjustments . This action will further the City's Strategic Goal to promote Good Governance . FISCAL IMPACT: If the City Council approves the above -mentioned FY 2019-20 Mid-Year Revenue and Expenditure adjustments , as listed in Atta c hment "A " and Attachment "B", General Fund operating revenues will be revised from $15 ,118 ,945 to $15 ,190 ,945 and operating expenditures from $14 ,688 ,510 to $14 ,688,175. This resu lts i n a FY 2019-20 estimated operating surplus of $523 ,270 which includes a transfer in the amount of $20 ,500 . ATTACHMENTS: A. FY 2019-20 Mid-Year General Fund Revenue Adjustments B . FY 2019-20 Mid-Year General Fund Expenditure Adjustments C. FY 2019-20 Fund Balance Analysis D. City Treasurer's Report E. Revenue Summary Report F. Expenditure Summary Report G. Capital Project Financia l Status Report ,..---------~---~ ATTAC HMENT A CITY OF TEMPLE CITY FY 2019-2020 REVENUE ADJUSTMENTS GENERAL FUND REVENUES E ncroachm ent Pe rm its Engineerin g Fees P lan Check Fees Zoning Fees TOTALGFBUDGETADJUSTMENTS-REVENUES FY 2019-20 Bud et $160,000 80,000 500,000 170 ,000 Proposed Ad·ustment ($28 ,000 ) (40 ,000) 60 ,000 80 ,000 $72,000 Rev i sed Bud et $132,000 40 ,000 560,000 250 ,000 ATTACHMENT B CITY OF TEMPLE CITY FY 2019-2020 EXPENDITURE BUDGET ADJUSTMENTS GENERAL FUND Orig i nal Budget Proposed Revised Budget DepartmenVProgram Amount Adjustments Amount Explanation Administrative Services Purchasing-Special Contract Services / $69,180 $73,100 $142 ,280 Re-allocate 3 vehicle leases ($1 3 ,100) 01-920-49 4231 and 3 down payments from AQMD ($60,000) -Park1ng Enforcement. Purcha sing-Office Eq uipment Ma intenance/01-39,775 23 ,130 62 ,905 Cost of TpX in ternet service due to delay 920-49 4520 of cha nge over b etween internet service providers . Community_ Develoement General Government Bu ildin gs -Overtime/ 20,000 8,000 28 ,000 Due to additional ass1gned projects such 01-970-81 4020 as concrete repairs . Parking Facil ities/01-980-82 6010 40,000 (40 ,000) 0 Re-allocate EV charging station to AQ MD (ProJect #P20-13). Planning-Prv/Special Contract Services/ 37 ,000 20 ,000 57 ,000 Creation of traffic model due to SB 743. 01 -930-53-4 231 Management Servtces Elect1ons-LA County Registrar/ 107 ,250 (107 ,250) 0 Cancellation of C1ty Council e lection. 01 -910-44 4218 City Manager-Prv/Special Contract 317 ,700 22 ,685 340,385 Additional p rint ing costs for CO NN ECT Services/01-910-42 4231 magazine. Transfers OuV01-990-90-9120 380,000 (38 0,000) 0 Elimination of Landscape and Lighting Dis trict subsi dy du e to SB 324 . Total General Fund Expenditure Adj . ($380 ,335) Page 1 of 2 ATTACHMENT B NON-GENERAL FUND Origi nal Budget Proposed Revised B udget Department/Program Am o unt Adjustments A mount Explanation AQ MD-Purchasing-Special Co ntra ct SeNices/ $34 ,300 $126 ,900 $161 ,200 Re-allocate veh icle leases (3) to Gene ral 29-920-49-4231 Fund-Purchasing (Park ing Enforcement) (-$13,095) and add down payments for 7 plug-in hybrids ($140,000). LLD-Tra nsfe rs ln/47-990-90 9005 (380 ,000) 380 ,000 0 El imin ation of La ndscape and Lig hting Dis trict su bsidy due to SB 324 . Parking Facilities/29-980-82 6010 0 40 ,000 40,000 Re-allocate EV charg ing station from GF (Project #P20-13). Parks Acquisition/Special Contract SeNices/ 0 15 ,000 15,000 Repavi ng of Live Oak Park 46-980-59 4231 jogging/wa lking path. Total Non-General Fund Expenditure Adj . $561,900 Page 2 of 2 ATTACHMENT C General Fund Budget Summary Adopted Net Adjusted Mid-Year Revised Budget Revisions Budget Revisions EstimateS FY 1920 Operating Revenue Budget $15,118,945 $0 $15,118 ,945 $72 ,000 $15,190 ,945 FY 1920 Operating Ex pend iture Budget (14,65 2,07 0) (36,440) (14 ,688,51 0 ) 335 (1 4 ,688, 175) Transfers ln/(Out) (3 59 ,500) 0 (359,500 ) 380 ,000 20 ,500 FY 1920 Estimated Operating Surplus/(Deficit) $107 ,375 ($36,440) $70,935 $452 ,335 $523,270 FY 1920 One-Time Ex pend iture ($1 ,545 ,000 ) ($78 ,900) ($1 ,623,900) $0 ($1 ,623 ,900) FY 1920 Cap ital Improvement Budget ($500,000) ($113 ,890) ($6 13 ,890) $0 ($61 3,890 ) FY 1819 Fund Balance (Audited ) $20 ,04 3,987 $0 $20,043,987 $0 $20,043 ,987 Net FY 1920 Budget Balance (1 ,937 ,625) (22 9,230) (2 , 166,855) 452 ,335 (1 ,714 ,520) June 30, 2020 Estimated Fund Balance $18,106 ,362 ($229 ,230) $17 ,877 ,132 $452 ,335 $18,329 ,467 '. CITY OF TEMPLE CITY TREASURER'S REPORT December 31 , 2019 COST VALUE Cas h in Bank Wells Fargo Bank-Checking 2,365,9 19.81 -Me rchant Card 45,416.41 US Bank -Checking 797 ,700.98 Camell ia Fund East West Bank -Monthly Market Account 160 ,000.00 Wells Fargo Bank-Checking 13,462.38 Petty Cash 2 ,100.00 LA IF Effective Quarter to Da te Yield 12/31/19 2.11 % 4 ,652 ,655.99 Mutual Securities Certificates of Deposit Weighted Average to Date Yield 12/31/19 2.041% 750,000 .00 Government Securities Weighted Average to Date Yield 12/31/191.731% 5,450 ,000 .00 Fixe d Income Weigh ted Average to Date Yield 12/31/19 2.378% 2 ,4 87,967.99 Money Marke t 15 ,615.42 US Bank* Certificates of Deposit Weighted Average to Date Yield 11/30/19 2.2 59 % 6 ,590 ,000.00 Government Securities Weighted Average to Date Yield 11/30/19 1.750% 1,474,071.20 Los Angeles County Pool Investment Fund 4 ,864 ,107.82 As of 12/31/19 1.92% SUB TOTAL $ 29 ,669 ,018 .00 OPEB Investment -Restrict ed 1 '1 00 ,000.00 As of 12/31/19 TOTAL $ 30 ,769 ,018 .00 PRIOR MONTH STATUS To t al $ 29 ,365 ,923.84 ATTACHMENT D MARKET VALUE 2,365,919 .81 45,416.41 797,700 .98 160,000.00 13,462.38 2,1 00.00 4 ,660,300.30 752 ,617.50 5,445 ,985.00 2,504 ,593.62 15,615.42 6 ,598,486.86 1,478,631.24 4 ,872 ,267.42 $ 29 ,713,096 .94 1 ,631,4 45.51 $ 31,344 ,542.45 $ 29 ,917 ,628.85 All investments are p laced in accordance with the City of Temp le City's Investmen t Policy . The above summary provides sufficient cash now liquidity to meet the next six month's estimated expenditures . This report i s in accordance with Government Code Section 53646. *No transactions in December 2019, no statement generated for December 2019. ATTACHMENT E CITY OF TEMPLE CITY REVENUE SUMMARY REPORT -ALL FUNDS PERIOD ENDING DECEMBER 31 , 2019 2018-19 2019-20 2018-19 YEAR TO DATE 2019-20 YEAR TO DATE PERCENT BUDGET JUL-DEC BUDGET JUL-DEC RECEIVED Taxes $ 6 ,329 ,700 $ 2 ,260 ,876 $ 6,423 ,690 $ 2 ,324 ,574 36% Licenses and Permits 1,661 ,000 812 ,703 1,561 ,000 784 ,903 50 % Intergovernmental 4 ,632 ,600 0 4 ,817,905 0 0% Charges for Services 1 ,398 ,650 615 ,142 1,383,350 708 ,829 5 1% Fines , Forfeitures, & Penalities 475 ,000 251 ,528 500 ,000 235 ,082 47 % Use of Money and Property 240 ,000 106,103 215,000 94 ,153 44 % Miscellaneous 213 ,000 108,491 218,000 94 ,855 44 % Total General Fund Revenue 14,949 ,950 4 ,154,843 15,118,945 4 ,242 ,396 28% T otal Special Revenue F unds 5 ,882 ,437 2 ,3951621 7 ,228 ,080 2 ,721,479 38% TOTAL REVENUE $ 20,832,387 $ 6 ,550,464 $ 22,347,025 $ 6 ,963,875 31 % Page 1 of 1 --------------------------------------------------------- ATTACHMENT F CITY OF TEMPLE CI TY EXPENDITURE SUMMARY REPORT-ALL FUNDS PERIOD ENDING DECEMBER 31 ,2019 2018-19 2019-20 2018-19 YEAR TO DATE 2019-20 YEAR T O DATE PERCENT BUDGET JUL-DEC BUDGET JUL-DEC EXPENDED MAN AG E MENT SERVICES DEPARTMENT City Council $ 180,870 $ 64 ,977 $ 194,190 $ 80,184 4 1% City Manager 1,005,045 468 ,093 1,035,480 531 ,582 51 % City Manager (Library Project) 0 0 1,500 ,000 1,500 ,227 100% City Attorney 320 ,000 99 ,159 320,000 130,355 41 % Elections 0 0 11 6 ,800 2 ,044 2% City Clerk 333 ,553 180 ,204 358,489 185,103 52 % Tota l-Management Services Depa rt ment $ 1,839,468 $ 812,433 $ 3 ,524 ,959 $ 2,429,495 69 % PUBLIC SAFETY DIVISION Law Enforcement $ 4 ,6 31,600 $ 1,864 ,249 $ 4 ,860,069 $ 1,967 ,172 40 % Traffi c Engineering 37 ,763 6 ,916 38 ,114 23 ,922 6 3% Emergency Services 160,010 83 ,759 164 ,744 94 ,167 57 % Parking Admini stration 341 558 139 ,745 3 17 ,4 34 125 ,100 39% T ota i-P ublic Safety D ivision $ 5,170,931 $ 2 ,094 ,669 $ 5 ,380 ,361 $ 2 ,210 ,361 41 % ADM I NI STRATIVE SERVICES DEPARTMENT Support Services/Human Resources $ 15 3,405 $ 53 ,358 $ 143,019 $ 7 3 ,977 52 % Personnel/R isk Management 1,081 ,042 769,498 73 1,614 577 ,728 79 % Accounting 617 ,013 321 ,706 644 ,584 317 ,215 49 % Purchasing 316 ,690 189 ,396 332 ,120 352 ,510 106% Total-Admin istrative Servi ces Department $ 2 ,168,150 $ 1,333 ,958 $ 1,851 ,337 $ 1,321,430 7 1% PARKS & RECREAT ION DEPARTMENT Recreation/Human Servic es $ 1,319 ,345 $ 585 ,05 3 $ 1 ,40 5,039 $ 572 ,723 41 % Public Transportation 778,483 298 ,304 939 ,739 297 ,305 32 % Parks -Maintenance/Faci lities 1,15 1,835 536 ,695 1 ,210 ,7 59 656 ,278 54 % Trees & Parkways 690,885 256,254 724 ,939 386 ,169 53 % Total-Parks & Recreation Department $ 3,940,548 $ 1,676,306 $ 4 ,280,476 $ 1,912,475 45% Page 1 o f 3 ATTACHMENT F CITY OF TEMPLE CITY EXPENDITURE SUMMARY REPORT -ALL FUNDS PERIOD ENDING DECEMBER 31, 2019 2018-19 2019-20 2018-19 YEAR TO DATE 2019-20 YEAR TO DATE PERCENT BUDGET JUL-DEC BUDGET JUL-DEC EXPENDED COMMUNITY DEVELOPMENT DEPARTMENT COMMUNITY ENHANCEMENT DIVISION Planning $ 828 ,375 $ 340,967 $ 743 ,774 $ 455,335 61% Bu ild ing 727 ,898 258,693 723 ,854 285 ,719 39% Housing 184,845 17,375 558 ,504 103,481 19% Community Preservation 541 ,180 251 ,510 620 ,369 314,646 51 % Total-Community Enhancement Division $ 2 ,282,298 $ 868 ,545 $ 2,646,501 $ 1,159,181 44 % INFRASTRUCTURE & MAINTENANCE DIVI SION Administration & Engineering $ 707 ,291 $ 267 ,096 $ 672,549 $ 288 ,993 43 % Traffic Signal Maintenance 156,500 37 ,653 156,500 53 ,772 34% Traffic Signs & Strip Maint. 105,430 53 ,242 119,369 56,454 47 % Street and Sidewalk Maintenance 378 ,200 102,700 396,000 148,434 37% Solid Waste Management 9 ,000 1,093 9,000 1,877 21% Street Lighting 375,216 113,920 374 ,074 132,428 35% General Government Buildings 281 ,089 145,443 329 ,504 180 ,792 55% Parking Facilities 103,550 55 ,324 110,984 56 ,650 51% Total -Infrastructure & Maintenance Division $ 2 ,116,276 $ 776,471 $ 2 ,167,980 $ 919,400 42 % SUB TOTAL PROGRAM EXPENDITURES $ 17,517,671 $ 7 ,562 ,382 $ 19 ,851 ,6 14 $ 9 ,952 ,342 50% Page 2 of 3 ATTACHMENT F CITY OF TEMPLE CITY EXPENDITURE SUMMARY REPORT-ALL FUNDS PERIOD ENDING DECEMBER 31 , 2019 2018 -19 2019-20 2018-19 YEAR TO DATE 2019-20 YEAR TO DATE PERCENT BUDGET JUL-DEC BUDGET JUL-DEC EXPENDED SU B TOTAL PROGRAM EXPENDITURES $ 17,517,671 $ 7 ,562,382 $ 19,851 ,614 $ 9,952 ,342 50% CAPITAL IMPROVEMENT FUND 2 ,840,000 36,514 5,437 ,890 507 ,290 9% EQU IPMENT REPLACEMENT 107 ,000 0 240,000 0 0% TRUST FUND 0 260 0 0 0% TOTAL EXPENDITURES $ 20,464,671 $ 7 ,599,156 $ 25,529,504 $ 10,459,632 41 % CDBG LOAN REPAYMENT $ 8 ,287 _$.:..__ _ __;;;;2;.;.J9 ''-'-87.;....;9~ 0 $ 35 ,000 0 % GRAND TOTAL $ 20 ,472 ,958 =$====7=,6=2=9,=03=5= $ 25,529,504 $ 10,494,632 41 % P age 3 of 3 CAPITAL IMPROVEMENT PROGRAM PROJECT DETAIL No. Project P19-01 Live Oak Park Community Center, Phase I Improvements P19-04 Temple City Park Pavillion Roofing P19-14 Primrose Park and Parking Lot Project P20-01 Live Oak Park Community Center, Phase II Improvements P20-02 Live Oak Park Fa cilities Master Plan , Phase II Improvements P20-03 Replace Conduit and Wiring Temple City Park Recap of Funding Sources CITY OF TEMPLE CITY PRELIMINARY FINANCIAL STATUS REPORT JUL 19-DEC 19 Funding Source Budget (R) General Fund* $30,000 Measure A * 150,000 Total LO P , Phase I 180,000 (E) Park Acquisition ** 28 ,000 (N) General Fund* 113 ,890 (R) Measure A 75,000 (R) Measu re A 200 ,000 (N) Park Acquisition 15,000 General Fund $143,890 Measure A 425 ,000 Park Acquisition 43,000 TOTAL CIP -PARKS MAINTENANCE I FACILITIES $611,890 • Reapproprialions from FY 2018-19 to FY 2019-20 .. Reapproprialions from FY 2018-19 to FY 2019-20 and ne w adopted budget and budget amendment (E) = Essential (N) = Necessary (M ) = Mandated (R) = Routine Page 1 of 4 ATTACHMENT G PARKS -MAINTENANCE/FACILITIES ACCT. NO. XX-980-59-6010 Year To Date Expenditure Balance $0 $30 ,000 0 150 ,000 0 180 ,000 0 28 ,000 16,884 97 ,006 0 75 ,000 0 200 ,000 0 15,000 $16 ,884 $127,006 0 425,000 0 43,000 $16 ,884 $595,006 (D) = Discretionary CAPITAL IMPROVEMENT PROGRAM PROJ ECT DETAIL No . Project P18-06 Rosemead Boulevard Resurfacing Project P19-05 Safe C lean Water Program (Green Street lmpr) P19 -07 Pavement Management Street Resurfacing P19-08 Sidewalks and Cub Ramps ADA Improvements P19-1 0 Banner and City Limit Signs P20-04 Bridge Re pai r a nd Maintenance P20-05 Las Tunas Drive Resurfacing P20-06 Rosemead Boulevard Median Irrigation Retrofit • Reappropriations from FY 2018-19 to FY 2019-20 (E) = Essentia l (N) = Necessary CITY OF TEMPLE CITY PRELIMINARY FINANCIAL ST ATUS REPORT JUL 19 ·DEC 19 Funding Source Budget (E) General Fund • $105,000 RMRA • 420,000 Tota l Rosemead Bou levard 525,000 (M) General Fund • 40,000 Measure W 76,000 Tota l Safe Clean Water 116,000 (E) General Fund • 105,000 MeasureR • 750,000 Road Maintenance and Repa ir Act • 356 ,000 Measure M • 400,000 Total Pavement Managemen1 1,611 ,000 (M) Transportation Development 71 ,000 Account* (D) General Fund • 75,000 (E) Road Mai ntenance and 125,000 Repair Act (E) General Fund 105,000 Proposition C 1,200,000 Road Maintenance and Repair Act 483,000 Measure M 400 ,000 Total Las Tunas Drive 2 ,188,000 (N) Lighting/Landscape 75 ,000 District (M) = Mandated (R) = Routine Page 2 or 4 ATTACHMENT G STREET CONSTRUCTION ACCT. NO. XX -980-75-6010 Yea r To Date Expenditure Balance $37 ,324 $67,676 420,000 0 457 ,324 67 ,676 0 40 ,000 0 76 ,000 0 116 ,000 0 105,000 0 750 ,000 0 356 ,000 33 ,083 366,917 33 ,083 1 ,577 ,917 0 71 ,000 0 75 ,000 0 .125 ,000 0 105 ,000 0 1,200 ,000 0 483 ,000 0 400 ,000 0 2,188,000 0 75 ,000 (D) = Discretionary CAPITAL IMPROVEMENT PROGRAM PROJECT DETAIL Rec ap of Funding Sourc es TOTAL CIP-STREET CONSTRUCTION (E) = Essential (N) = Necessary CITY OF TEMPLE CITY PRELIMINARY FINANCIAL STATUS REPORT JUL19-DEC 19 General Fund $430,000 Lignti ng/Landscape District 75,000 Measure M 800,000 MeasureR 750,000 Measure W 76 ,000 Propo sition C 1,200,000 Road Ma int enance and Repair Act 1,384 ,000 Transportation Development Account 71 ,000 $4,786,000 (M) = Mandated (R) = Routine Page 3 of 4 ATTACHMENT G STREET CONSTRUCTION ACCT. NO. XX-980-75-6010 $37,324 $392 ,676 0 75 ,000 33 ,083 766,917 0 750,000 0 76 ,000 0 1,200,000 420 ,000 964,000 0 71,000 $490 ,407 $4 ,295 ,593 (D) = Discretionary CAPITAL IMPROVEMENT PROGRAM PROJ ECT DETAIL No . Project P20-07 City Hall and Live Oak Park EV Charging Station s Recap of Funding Sources TOTAL CIP-PARKING FACILITIES (E) = Essential (N) = Ne cessary CITY OF TEMPLE CITY PRELIMINARY FINANCIAL STATUS REPORT JUL 19 ·DEC 19 Funding Source Budget (N) General Fund $40,000 General Fund $40 ,000 $40 ,000 (M) = Mandated (R) = Routine GRAND TOTAL $5 ,437 ,890 Page 4 of 4 ATTACHMENT G PARKING FACILITIES ACCT. NO. XX-980-82 -6010 Year To Date Expenditure Balance $0 $40 ,000 $0 $40,000 $0 $40 ,000 (D) = Discretionary $507,291 $4,930 ,599