Loading...
HomeMy Public PortalAbout12) 10B Fiscal Year 2018-19 Mid-Year Budget Review and Summary ReportsAGENDA ITEM 10 .8. ADMINI S TRATIVE SERVI CES DEPA RTM ENT DATE: TO: FROM :· MEMORANDUM February 19, 2019 The Honorable City Council . B!)'an Cook, City Manager h4 · Via : Susan Paragas, Administrative Services Directo r 'f By: Lee Ma , Accountant SUBJECT: . FISCAL YEAR (FY) 2018 -19 MID-YEAR BUDGET REVIEW, TREASURER'S REPORT, REVENUE, EXPENDITURE AND CAPITAL PROJECT S UMMARY REP ORTS RECOMMENDATION: The City Council is requested to : 1. Receive the FY 2018-19 Mid-Year Budget Review and related reports ; 2 . Authorize staff to revise revenue estimates as indicated in Attachment "A"; 3. Authorize staff to revise expenditure estimates as indicated in Attachment "B". BACKGROUND: 1. On June 19, 2018 , the City Council approved the Fiscal Year 2018-19 (FY 2019) Operating Budget for all funding source in the amount of $20,505,665 . 2 . On June 19, 2018, the City Council adopted Resolution No. 18-5333 adopting the FY 2019 Statement of Investment Policy. 3 . On August 7, 2018, the City Council adopted Resolution No. 18-5351 appropriated $40,000 from General Fund Reserve to implement provisions of MOU between the City and the City Employees Association from July 1, 2018 to June 30, 2019 . 4. On September 4, 2018, the City Council adopted Resolution No . 18-5358 appropriated $10,150 from the General Fund, Proposition A, and Lighting/Landscape District Funds for the eight Non-represented Management Employees. City Council February 19, 2019 Page 2 of7 5. On November 6, 2018, the City Council approved $20,000 for participation in the Ring Rebate Program, $20,000 for the Waste Hauling Consultant Contract, and $8,287 for the CDBG loan repayment and remittance. ANALYSIS: The FY 2018-19 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 in revenue projections based on actual revenue received from July 1, 2018 through December 31, 2018, as well as unanticipated expenditures due to information that was not previously available. It is through significant diligence on the part of staff by finding cost-cutting strategies that the City has been able to preserve its financial health without eliminating services. 1. FY 2018-19 GENERAL FUND REVENUES After a careful and thorough review of the FY 2018-19 General Fund revenues, staff is making recommendations for revisions to some estimates, as outlined in Attachment "A" for a total reduction of $148,000. However, several of the revenue reductions are offset with a decrease in their corresponding expenditures (see Attachment "B"). 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. 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. Temple City's assessed valuations continue to increase and the median home prices have exceeded the pre- recession levels of 2007. December 2018 property tax collections are $63,700 higher than last year. The current budget was adjusted to reflect the estimated increase. No adjustment is recommended at this time. • Sales Tax: Sales tax decreased $11,000 from the second quarter in FY 2018-19 over the same quarter in FY 2017-18. This is mainly due to the new software system glitches the California Department of Tax and Fee Administration which prevented some businesses to enter and remit the sales tax collected on time. No adjustment is recommended at this time. • Other Taxes: Other tax revenues include franchise fees, transient occupancy tax and real estate transfer tax. 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 City Council February 19, 2019 Page 3 of7 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. No adjustments are recommended at this time. • 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 first six months of revenues received in FY 2018-19, staff is recommending a total reduction of $22,000 in revenues (see Attachment "A"): o Building Permits (-$50,000) -Activity not tracking to estimated budget even though revenues are $37,700 higher than last year; and o Temporary Parking Permits (+$28,000) -Revenue collections are at a pace to be higher than budgeted mainly due to increased parking enforcement. • 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 eliminated state general fund backfill to cities and counties. Instead, cities and counties now receive additional transfers of property tax revenues in lieu of VLF. The City does not receive these funds until in the second half of the fiscal year. No adjustment is recommended at this time. • 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 the current revenues received, a total budget reduction of $161,000 is recommended as the some of the revenues are tracking lower than estimates (see Attachment "A"): o Engineering Fees (+$13,000) -Collections are better than projected budget and is $25,100 higher than prior year's activities; o Plan Check Fees (-$114,000)-Revenues are not on pace with budgeted revenues due to a slowdown in activity; and o Recreation Fees (-$60,000)-Lower youth program registrations are the main cause for revenues not meeting estimates. • Court Fines: Court Fines are revenues collected from citations written from both City Council February 19, 2019 Page 4 of7 the Los Angeles County Sheriff's Department and authorized City staff. Based on current activity, an increase of $25,000 is recommended as current receipts are tracking slightly higher than estimates (see Attachment "A"). • 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, there are no adjustments recommended. • Other Revenues: Other revenues include recyclable revenue, rental income, sales of City property, donations and reimbursements. The recommended budget amendment is an increase of $10,000 for rental income due to an underestimated budget (see Attachment "A"). 2. FY 2018-19 OTHER FUND REVENUES After reviewing other City funds, the only recommended revision is in the Community Development Block Grant ("CDBG") Loan Repayment revenues (+$21,713) due to unanticipated loan repayments from borrowers (see Attachment "A"). 3. FY 2018-19 GENERAL FUND AND OTHER FUND EXPENDITURES The adopted FY 2018-19 City Budget totaled $20.5 million in Operating Expenditures, Vehicle/Equipment Outlay and Capital Improvement Projects. Recommendations for the mid-year budget adjustments are presented in Attachment The recommended total General Fund net reduction of $144,000 in expenditures, (Attachment "B") are primarily due to lower revenues in Recreation's youth program registrations and decreased revenue activities in building permits and plan checks, thus, are offset with the recommended revenue reductions (Attachment "A"). • Salaries-Part-Time-Recreation (-$44,000) -Lower youth programs held due to lower registrations; • Salaries-Part-Time-Parks (-$10,000)-Reduction in staff availability; • Code Enforcement-Community Preservation (+$20,000)-Due to increased activity; • Special Contract Services-Building Permits (-$60,000) -Reduction in required contracted services due to lower building permit revenue activity; and City Council February 19, 2019 Page 5 of? • Special Contract Services-Plan Check (-$50,000) -Reduction in required contract services due to lower plan check revenue activity. Here are the recommendations for a net expenditure adjustment of $21,713 in other funds: • CDBG-Loan Repayments (+$21 ,713) -Return of Unanticipated loan repayments; • Prop A-Dial-A-Ride (-$260,000)-Transfer costs to Prop C, see explanation below; and • Prop C-Diai-A-Ride (+$260,000)-Transfer costs from Prop A to meet Prop C's expenditure timeline requirements. 4. EQUIPMENTNEHICLE REPLACEMENT The City adopted a budget for EquipmentNehicle Replacement of $107,000. No adjustment is recommended at this time. 5. GENERAL FUND CAPITAL IMPROVEMENT PROJECTS (CIP) With the adoption of FY 2018-19 City Budget, the City Council approved $2.84 million in CIP expenditures, of which 27.25% of the total budgeted expenditures, or $774,000, are funded by the General Fund. No adjustment is recommended at this time. 6. FUND BALANCE ANALYSIS (GENERAL FUND) Attachment "C" provides an analysis of the General Fund Balance. Estimated General Fund Balances at June 30, 2019, are provided: • At July 1, 2018, when the FY 2018-19 City Budget was adopted; • At December 31, 2018, which includes actual Fund Balance at July 1, 2018 that is now available due to completion of the audited Comprehensive Annual Financial Report (CAFR) and budget adjustments for the first six months of operations; and • Estimated General Fund Balance at June 30, 2019, is presented assuming the recommended adjustments in this report are approved and implemented. With the recommended reduction of $148,000 in estimated operating revenues and a reduction of $144,000 in estimated operating expenditures, the adjusted operating City Council February 19, 2019 Page 6 of 7 surplus has a small decrease of $4,000, from $257,960 to $253,960. The analysis further articulates the resources that are available in accordance with the City's adopted Budget Reserve Policy. It is anticipated the City will be moving into the FY 2019-20 City Budget process with an unassigned Fund Balance of almost $4.2 million. Committed and Assigned Reserves for restricted purposes have a balance of just under $14.1 million. 7. 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 market value balance of slightly under $29 million as of December 31, 2018. The balance includes a restricted amount of $1.4 million for other post-employment benefits. 8. REVENUE SUMMARY REPORT This report (Attachment "E") is a summary of actual revenues for the period of July 1, 2018 to December 31, 2018. 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 month period, thus providing a skewed percentage of actual receipts collected to date. Detailed discussions about revenue collections year-to-date have been addressed earlier in this report. 9. EXPENDITURE SUMMARY REPORT (INCLUDING EQUIPMENT REPLACEMENT) This report is a summary of actual expenditures for the period of July 1, 2018 to December 31, 2018 (Attachment "F"). By the end of the second quarter the percent 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. 10. CAPITAL IMPROVEMENT FINANCIAL STATUS REPORT The mid-year expenditures (Attachment "G") reflect the budgets and costs for six projects: Live Oak Park Irrigation System Modifications; Live Oak Park and Temple City Park Lighting Upgrades; Citywide Upgrade Traffic Street Signage; Rosemead Boulevard Resurfacing Project; Pavement Management Street Resurfacing Project; and Primrose Properties Demolition. City Council February 19, 2019 Page 7 of 7 CITY STRATEGIC GOALS: The City Council is requested to receive the Mid-Year Budget Report and Financial Status Reports at the close of the second quarter of FY 2018-19 and authorize the recommended mid-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 2018-19 Mid-Year Revenue and Expenditure adjustments, as listed in Attachment "A" and Attachment "B", General Fund revenues will be revised from $14,949,950 to $14,801,950 and operating expenditures from $14,811,855 to $14,667,855. This results in a FY 2018-19 estimated operating surplus of $253,960 which includes a transfers-in amount of $119,865. ATTACHMENTS: A. FY 2018-19 Mid-Year General Fund Revenue Adjustments B. FY 2018-19 Mid-Year General Fund Expenditure Adjustments C. FY2018-19 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 2018-19 MID-YEAR REVENUE ADJUSTMENTS General Fund (GF) FY2018-19 Proposed Budget Adjustment Building Permits $ 950,000 $ (50,000) Temp Parking Permit 142,000 28,000 Engineering Fees 67,000 13,000 Plan Check Fees 570,000 (114,000) Recreation Fees 566,300 (60,000) Court Fines 475,000 25,000 Rental Income 24,000 10,000 Totai-GF Revenue Adj. $ (148,000) Revised GF Oper. Revenue Budget-12/31/2018 Mid-Year GF Proposed Adjustments Totai-GF Proposed Revenues Community Development Block Grant (CDBG) FY2018-19 Proposed Budget Adjustment $ $ $ Revised Estimate 900,000 170,000 80,000 456,000 506,300 500,000 34,000 14,949,950 (148,000) 14,801,950 Revised Estimate Explanation Due to Building activity slowdown. Due to increase in parking enforcement. Due to higher activities. Plan Check activity is lower than estimated. Due to reduction in program registration-Youth Programs Citations are higher than anticipated. Annual rental income is tracking higher. Loan Repayment $ 8,287 $ 21,713 $ 30,000 Due to unanticipated loan repayments. Totai-CDBG Revenue Adj. $ 8,287 $ 21,713 $ 30,000 Revised CDBG Revenue Budget-12/31/2018 $ 187,287 Mid-Year CDBG Proposed Adjustments __ ---=.212 ,7:..1:..:3_ Totai-CDBG Proposed Revenues $ 209,000 ATTACHMENT B CITY OF TEMPLE CITY FY 2018-19 MID-YEAR EXPENDITURE ADJUSTMENTS General Fund (GF) Department/Program Original Budget Amount Proposed Adjustments Revised Budget Amount Explanation Parks and Recreation Salaries Part-Time-Recreation $ 394,920 $ (44,000) $ 350,920 Due to reduction in program Salaries Part-Time-Parks Communitv Development Code Enforcement-Community Preservation Special Contract Services-Building Special Contract Services-Planning 245,940 7,000 360,000 175,000 (10,000) 20,000 (60,000) (50,000) registration -Youth Programs 235,940 Due to reduction in staffing availability- Park Patrol 27,000 Due to increase in activity. 300,000 Due to reduction in contracted services as a result of lower building permit activities. 125,000 Due to reduction in contracted services as a result of lower plan check activities. Totai-GF Expenditure Adj. $1,182,860 $ (144,000) $1,038,860 Revised GF Oper. Expenditure Budget-12/31/2018 $14,811,855 Mid-Year GF Proposed Adjustments (144,000) Totai-GF Proposed Oper. Expenditures $14,667,855 Community Development Block Grant (CDBG) Revised Original Budget Proposed Budget Deeartment/Program Amount Adjustments Amount Exelanation CDBG Loan Repayment $ 8,287 $ 21,713 $ 30,000 Due to unanticipated loan repayments. Totai-CDBG Expenditure Adj. $ 8,287 $ 21,713 $ 30,000 Revised CDBG Expenditure Budget-12/31/2018 $ 187,287 Mid-Year CDBG Proposed Adjustments __ ...c2=.1:.z.,7:...1.:..;3:... Totai-CDBG Proposed Expenditures =$;:;,..,.,;;20;;;9;J,O;;;O;;;O;,. 1 of 2 Proposition A (Prop A) Original Budget Proposed Revised Budget Total-Prop A Expenditure Adj. $ $ (260,000) $ (260,000) Revised Prop A Expenditure Budget-12/31/2018 Mid-Year Prop A Proposed Adjustments (260,000) Total-Prop A Proposed Expenditures $ (260,000) Proposition C (Prop C) Original Budget Proposed DepartmenUProgram Amount Adjustments Proposition C-Diai-A-Ride $ 260,000 Revised Budget Amount Explanation $ 260,000 Transferring costs from Proposition A. Total-Prop C Expenditure Adj. $ $ 260,000 $ 260,000 Revised Prop C Expenditure Budget-12/31/2018 Mid-Year Prop C Proposed Adjustments 260,000 Total-Prop C Proposed Expenditures $ 260,000 2 of2 ATTACHMENT C CITY OF TEMPLE CITY FY 2018-19 MID-YEAR GENERAL FUND BALANCE ANALYSIS Budget Amendments (Jul -Jan) and FY 2018-19 Actual Fund Balance FY 2018-19 Mid-Year Adopted Budget (6-30-18) Budget Review Fund Balance July 1, 2018 Non spendable $ -$ 128,670 $ 128,670 Committed 3,500,000 3,500,000 3,500,000 Assigned 11,104,372 10,589,004 10,589,004 Unassigned 3,483,926 4,713,137 4,713,137 Total Fund Balance July 1, 2018 $ 18,088,298 $ 18,930,811 $ 18,930,811 Revenues $ 14,949,950 $ 14,949,950 $ 14,801,950 Transfers In $ 447,965 $ 119,865 $ 119,865 Estimated Expenditures $ (15,385,525) $ (14,811 ,855) $ (14,667,855) Operating Surplus/Deficit $ 12,390 $ 257,960 $ 253,960 CIP/Transfers Out $ (774,000) $ (774,000) $ (774,000) Surplus (Deficit) $ (761,610) $ (516,040) $ (520,040) Estimated Fund Balance June 30, 2019 $ 17,326,688 $ 18,414,771 $ 18,410,771 • Estimated Fund Balance at June 30, 2019 Nonspendable $ 128,670 Committed Emergency/Disasters $ 50,000 Liquidity $ 2,000,000 Local Economic Uncertainty $ 1,450,000 $ 3,500,000 Assigned Fleet Management $ 400,000 Facilities Management $ 3,540,000 Technology Replacement $ 40,792 Economic Development $ 2,254,473 Opportunitues for One-Time Expenditures $ 4,353,739 $ 10,589,004 Unassigned $ 4,193,097 Estimated Fund Balance, June 30, 2019 $ 18,410,771 CITY OF TEMPLE CITY TREASURER'S REPORT December 31, 2018 Cash in Bank Wells Fargo Bank-Checking 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 12/31/18 2.210% Morgan Stanley Smith Barney Certificates of Deposit Weighted Average to Date Yield 12/31/18 2.157% Government Securities Weighted Average to Date Yield 12/31/18 1.052% Corporate Fixed Income Weighted Average to Date Yield 12/31/18 2.372% Money Market Mutual Securities Government Securities Weighted Average to Date Yield 12/31/18 1.383% Money Market US Bank Certificates of Deposit Weighted Average to Date Yield 12/31/18 1.845% Government Securities Weighted Average to Date Yield 12/31/18 1.584% Los Angeles County Pool Investment Fund As of 12/31/18 2.060% SUB TOTAL OPEB Investment-Restricted As of 12/31/18 TOTAL PRIOR MONTH STATUS Total $ $ $ COST VALUE 1 ,267,184.08 25,482.38 442,871.47 160,000.00 11,029.98 2,100.00 3,323,971.26 2,830,000.00 1 ,200,000.00 1,988,774.40 13,290.02 6,500,000.00 6,250.28 2,981,000.00 2,196,393.03 4,762,933.13 27,711,280.03 1 '1 00,000.00 28,811,280.03 27,214,566.49 ATTACHMENT D $ $ $ MARKET VALUE 1,267,184.08 25,482.38 442,871.47 160,000.00 11,029.98 2,100.00 3,320,816.81 2,785,402.28 1 '187,544.00 1,977,218.55 13,290.02 6,419,100.00 6,250.28 2,981,000.00 2,199,309.64 4,770,444.03 27,569,043.62 1,391 '795:82 28,960,839.34 27,350,666.83 All investments are placed in accordance with the City of Temple City's Investment Policy. The above summary provides sufficient cash flow l!quidity to meet t e next six month's estimated expenditures. This feport is in accordance wilh Government Code Section 53646. ATTACHMENT E CITY OF TEMPLE CITY REVENUE SUMMARY REPORT -ALL FUNDS PERIOD ENDING DECEMBER 31, 2018 2017-18 2018-19 2017-18 YEAR TO DATE 2018-19 YEAR TO DATE PERCENT BUDGET JUL-DEC BUDGET JUL-DEC RECEIVED - Taxes $ 6,060,000 $ 2,211,601 $ 6,329,700 $ 2,260,876 36% Licenses and Permits 1,535,000 767,618 1,661,000 812,703 49% Intergovernmental 4,300,000 0 4,632,600 0 0% Charges for Services 1,474,260 807,710 1,398,650 615,142 44% Fines, Forfeitures, & Penalities 475,000 222,948 475,000 251,528 53% Use of Money and Property 200,000 69,169 240,000 106,103 44% Miscellaneous 220,000 99,703 213,000 108,491 51% Total General Fund Revenue 14,264,260 4,178,749 14,949,950 4,154,843 28% Total Special Revenue Funds 4,977,620 2,315,493 5,882,437 2,395,621 41% - TOTAL REVENUE $ 19,241,880 $ 6,494,242 $ 20,832,387 $ 6,550,464 31% ATTACHMENT F CITY OF TEMPLE CITY EXPENDITURE SUMMARY REPORT -ALL FUNDS PERIOD ENDING DECEMBER 31,2018 2017-18 2018-19 2017-18 YEAR TO DATE· 2018-19 YEAR TO DATE PERCENT BUDGET JUL-DEC BUDGET JUL-DEC EXPENDED MANAGEMENT SERVICES DEPARTMENT City Council $ 179,790 $ 73,767 $ 180,870 $ 64,977 36% City Manager 953,735 489,152 1,005,045 468,093 47% City Manager (Library Project) 1,500,000 0 0 0 0% City Attorney 362,000 103,014 320,000 99,159 31% Elections 0 0 0 0 0% City Clerk 327,560 160,268 333,553 180,204 54% Total-Management Services Department $ 3,323,085 $ 826,201 $ 1,839,468 $ 812,433 44% PUBLIC SAFETY DIVISION Law Enforcement $ 4,469,620 $ 1,456,133 $ 4,631,600 $ 1,864,249 40% Traffic Engineering 37,310 4,278 37,763 6,916 18% Emergency Services 153,540 67,873 160,010 83,759 52% Parking Administration 319,985 136,11§ 341,558 139,745 41% Total-Public Safety Division $ 4,980,455 $ 1,664,400 $ 5,170,931 $ 2,094,669 41% ADMINISTRATIVE SERVICES DEPARTMENT Support Services $ 137,180 $ 88,672 $ 153,405 $ 53,358 35% Insurance/Benefits 974,230 769,049 1,081,042 769,498 71% Accounting 624,580 323,501 617,013 321,706 52% Purchasing 295,450 193,186 316,690 189,396 60% Total-Administrative Services Department $ 2,031,440 $ 1,374,408 $ 2, 168,150 $ 1,333,958 62% PARKS & RECREATION DEPARTMENT Recreation/Human Services $ 1,310,860 $ 572,553 $ 1,319,345 $ 585,053 44% Public Transportation 758,970 329,895 778,483 298,304 38% Parks-Maintenance/Facilities 1,094,460 536,870 1,151,835 536,695 47% Trees & Parkways 672,390 349,758 690,885 256,254 37% Total-Parks & Recreation Department $ 3,836,680 $ 1,789,076 $ 3,940,548 $ 1,676,306 43% Page 1 of 3 CITY OF TEMPLE CITY EXPENDITURE SUMMARY REPORT -ALL FUNDS PERIOD ENDING DECEMBER 31,2018 2017-18 2018-19 2017-18 YEAR TO DATE 2018-19 YEAR TO DATE PERCENT BUDGET JUL-DEC BUDGET JUL-DEC EXPENDED COMMUNITY DEVELOPMENT DEPARTMENT COMMUNITY ENHANCEMENT DIVISION Planning $ 918,730 $ 381,550 $ 828,375 $ 340,967 41% Building 715,790 286,771 727,898 258,693 36% Housing 233,870 27,097 184,845 17,375 9% Community Preservation 532,500 269,019 541,180 251,510 46% Total-Community Enhancement Division $ 2,400,890 $ 984,437 $ 2,282,298 $ 868,545 38% INFRASTRUCTURE & MAINTENANCE DIVISION Administration & Engineering $ 690,420 $ 313,590 $ 707,291 $ 267,096 38% Traffic Signal Maintenance 156,500 40,299 156,500 37,653 24% Traffic Signs & Strip Main!. 147,460 62,390 105,430 53,242 50% Street and Sidewalk Maintenance 443,000 140,096 378,200 102,700 27% Solid Waste Management 10,110 2,280 9,000 1,093 12% Street Lighting 359,930 155,073 375,216 113,920 30% General Government Buildings 269,900 175,994 281,089 145,443 52% Parking Facilities 100,630 50,_81~-103,550 55,324 53% Total-Infrastructure & Maintenance Division $ 2,177,950 $ 940,538 $ 2,116,276 $ 776,471 37% SUB TOTAL PROGRAM EXPENDITURES $ 18,750,500 $ 7,559,060 $ 17,517,671 $ 7,562,382 43% Page 2 of 3 CITY OF TEMPLE CITY EXPENDITURE SUMMARY REPORT -ALL FUNDS PERIOD ENDING DECEMBER 31,2018 2017-18 2018-19 2017-18 YEAR TO DATE 2018-19 YEAR TO DATE PERCENT BUDGET JUL-DEC BUDGET JUL-DEC EXPENDED SUB TOTAL PROGRAM EXPENDITURES $ 18,750,500 $ 7,559,060 $ 17,517,671 $ 7,562,382 43% CAPITAL IMPROVEMENT FUND 5,275,615 1,884,395 2,840,000 36,514 1% EQUIPMENT REPLACEMENT 57,555 17,804 107,000 0 0% TRUST FUND 0 250 0 260 0% - TOTAL EXPENDITURES $ 24,083,670 $ 9,461,509 $ 20,464,671 $ 7,599,156 37% CDBG LOAN REPAYMENT $ 4,000 $ 7,400 $ 8,287 $ 29,879 361% GRAND TOTAL $ 24,087,670 $ 9,468,909 $ 20,472,958 $ 7,629,035 37% Page 3 of3 CAPITAL IMPROVEMENT PROGRAM PROJECT DETAIL No. Project P19-01 Live Oak Park Community Center, Phase I Improvement P19-02 Live Oak Park Irrigation System Modifications P19-03 Live Oak Park and Temple City Park Lighting Upgrades P19-04 Temple City Park Pavillion Roofing Recap of Funding Sources CITY OF TEMPLE CITY PRELIMINARY FINANCIAL STATUS REPORl JUL 18-DEC 18 Funding Source Budget (R) Measure A 180,000 (R) Park Acquisition 21,000 (R) Park Acquisition 15,000 (E) Park Acquisition 10,000 Measure A 180,000 Park Acquisition 46,000 TOTAL CIP-PARKS MAINTENANCE I FACILITIES 226,000 (E) = Essential (N) = Necessary (M) = Mandated (R) = Routine Page 1 of4 ATTACHMENT G PARKS-MAINTENANCE/FACILITIES ACCT. NO. XX-980-59-6010 Year To Date Expenditure Balance 180,000 703 20,297 1,837 13,163 -10,000 180,000 2,540 43,460 2,540 223,460 (D) = Discretionary CAPITAL IMPROVEMENT PROGRAM PROJECT DETAIL No. Project P12-04 Citywide Upgrade Traffic Street Signage P18-06 Rosemead Boulevard Resurfacing Project P19-05 Green Street Improvements P19-06 Rio Hondo I Eaton Wash TMDL LRS Project P19-07 Pavement Management Street Resurfacing P19-08 Sidewalks and Cub Ramps ADA Improvements P19-09 Las Tunas Drive Entry Monument P19-10 Banner Replacements Recap of Funding Sources TOTAL CIP-STREET CONSTRUCTION *FY 2017-18 carried forward amount. (E) = Essential (N) = Necessary CITY OF TEMPLE CITY PRELIMINARY FINANCIAL STATUS REPORT JUL 18-DEC 18 Funding Source Budget (M) General Fund - (E) General Fund RMRA Total Rosemead Boulevard (M) General Fund 50,000 (M) General Fund 234,000 (E) General Fund 105,000 MeasureR 750,000 Road Maintenance and Repair Act 604,000 Measure M 400,000 Total Pavement Managemenl 1,859,000 (M) Transportation Development 86,000 Account (D) General Fund 40,000 (D) General Fund 75,000 General Fund 504,000 Transportation Development Account 86,000 MeasureR 750,000 Road Maintenance and Repair Act 604,000 Measure M 400,000 2,344,000 (M) = Mandated (R) = Routine Page 2 of4 STREET CONSTRUCTION ACCT. NO. XX-980-75-6010 Year To Date Expenditure Balance 3,665 . (3,665) - 11,356 • (11 ,356) 11,356 (11 ,356) 50,000 234,000 -105,000 -750,000 604,000 1,607 398,393 1,607 1,857,393 86,000 40,000 75,000 3,665 500,335 86,000 11,356 738,644 -604,000 1,607 398,393 16,628 2,327,372 (D) = Discretionary CAPITAL IMPROVEMENT PROGRAM PROJECT DETAIL No. Project P19-11 City Hall Sewer Lateral Modification Recap of Funding Sources TOTAL CIP-GEN GOV'T BLDGS (E) = Essential (N) = Necessary CITY OF TEMPLE CITY PRELIMINARY FINANCIAL STATUS REPORl JUL 18-DEC 18 Funding Source Budget (N) General Fund 45,000 General Fund 45,000 45,000 (M) = Mandated (R) = Routine Page 3 of4 GENERAL GOVERNMENT BUILDINGS ACCT. NO. XX-980-81-6010 Year To Date Expenditure Balance -45,000 45,000 -45,000 (D) = Discretionary CAPITAL IMPROVEMENT PROGRAM PROJECT DETAIL No. Project P19-12 Downtown Parking Lots Study P19-13 Primrose Properties Demolition Recap of Funding Sources TOTAL CIP-GEN GOV'T BLDGS (E) = Essential (N) = Necessary CITY OF TEMPLE CITY PRELIMINARY FINANCIAL STATUS REPORl JUL 18-DEC 18 Funding Source Budget (D) General Fund 50,000 (N) General Fund 175,000 General Fund 225,000 225,000 (M) = Mandated (R) = Routine Page 4 of4 PARKING FACILITIES ACCT. NO. XX-980-82-6010 Year To Date Expenditure Balance 50,000 17,347 157,653 17,347 207,653 17,347 207,653 (D) = Discretionary