Loading...
HomeMy WebLinkAbout19-09 CC Resolution RESOLUTION NO. 19-09 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF TEMECULA, AMENDING THE FISCAL YEAR 2018-19 ANNUAL OPERATING BUDGET THE CITY COUNCIL OF THE CITY OF TEMECULA DOES HEREBY RESOLVE AS FOLLOWS: Section 1. The purpose of this review is to conduct an analysis of revenues and expenditures to ensure that the City maintains a prudent and healthy fiscal position. Section 2. That each year a mid-year review is conducted of City operating budgets. Section 3. That the mid-year review has been completed and the recommended adjustments are reflected in the attached schedules for the City's General Fund, Special Revenue, Debt Service and Internal Services Funds. Section 4. That the Fiscal Year 2018-19 General Fund and Measure S Fund Annual Operating Budgets are hereby amended in accordance with the attached Exhibit A, General Fund Fiscal Year 2018-19 Mid-Year Budget. Section 5. That the Fiscal Year 2018-19 Special Revenue and Debt Service Funds Annual Operating Budgets are hereby amended in accordance with the attached Exhibit B — Special Revenue and Debt Service Funds Fiscal Year 2018-19 Mid-Year Budget. Section 6. That the Fiscal Year 2018-19 Internal Services Funds Annual Operating Budgets are hereby amended in accordance with the attached Exhibit C, Internal Services Funds Fiscal Year 2018-19 Mid-Year Budget. Section 7. That Fund 335: Support Services Replacement Fund be established to account for the accumulation of resources necessary to replace the City's duplicating and printing equipment at the end of the equipment's useful life. Section 9. The City Clerk shall certify adoption of the resolution. 1 PASSED, APPROVED, AND ADOPTED by the City Council of the City of Temecula this 26th day of February, 2019. Michael S. Naggar, Mayor ATTE : Randi o , ity Clerk [SEAL] 2 STATE OF CALIFORNIA ) COUNTY OF RIVERSIDE ) ss CITY OF TEMECULA ) I, Randi Johl, City Clerk of the City of Temecula, do hereby certify that the foregoing Resolution No. 19-09 was duly and regularly adopted by the City Council of the City of Temecula at a meeting thereof held on the 26th day of February, 2019,by the following vote: AYES: 5 COUNCIL MEMBERS: Edwards, Rahn, Schwank, Stewart NOES: 0 COUNCIL MEMBERS: None ABSTAIN: 0 COUNCIL MEMBERS: None ABSENT: 0 COUNCIL MEMBERS: None Randi Johl, City Clerk 3 EXHIBIT A City of Temecula Cle---;":""4-° � fiscal Year 2018-19 R Mid-Year Adjustments Fund: 001 GENERAL FUND %Change 2018-19 Year to Date 2018-19 From 2017-18 Current Actuals Revised Increase/ Current Description Actuals Budget 12-31-18 Budget (Decrease) Budget Revenues by Category Taxes and Franchises 53,392,601 53,586,778 18,102,385 53,363,005 (223,773) -0.4% Licenses,Permits and Service Charges 4,417,404 4,065,593 3,091,351 5,265,552 1,199,959 29.5% Fines and Forfeitures 756,471 732,879 313,421 831,823 98,944 13.5% Use of Money and Property 148,560 399,322 209,890 477,606 78,284 19.6% Intergovernmental Revenues 7,899,231 8,112,645 - 8,166,963 54,318 0.7% Reimbursements 2,395,733 3,017,919 642,105 3,031,210 13,291 0.4% Operating Transfers In 6,621,202 8,292,796 2,125,816 7,889,472 (403,324) -4.9% Miscellaneous Revenue 259,655 151,546 109,832 182,451 30,905 20.4% Total Operating Revenues 75,890,856 78,359,478 24,594,799 79,208,082 848,604 1.1% Expenditures by Department City Council 392,479 523,065 173,545 523,065 - 0.0% Community Support 107,000 125,000 21,400 125,000 - 0.0% City Manager 1,428,765 1,441,146 598,586 1,441,146 - 0.0% Economic Development 1,291,888 1,500,799 695,117 1,513,299 12,500 0.8% Emergency Management 124,536 254,186 117,398 254,186 (0) 0.0% City Clerk 1,104,483 1,390,869 487,251 1,390,869 0 0.0% City Attorney 977,221 780,300 392,671 942,300 162,000 20.8% Finance 2,327,775 2,582,167 1,037,002 2,582,167 - 0.0% Human Resources 979,538 1,102,016 477,132 1,187,016 85,000 7.7% Planning 2,057,156 2,518,897 837,420 2,523,885 4,988 0.2% Building&Safety 2,457,644 3,070,140 1,282,891 3,070,140 - 0.0% Land Development 1,666,614 1,761,657 642,288 1,761,657 0 0.0% Public Works 5,119,183 6,111,409 2,183,929 6,134,747 23,338 0.4% CIP Admin 1,861,739 2,506,192 899,781 2,506,192 0 0.0% Parks Maintenance 3,790,123 3,939,777 1,838,044 4,006,777 67,000 1.7% Police 31,061,517 34,720,354 11,077,915 34,720,354 - 0.0% Fire 7,607,685 9,882,553 2,256,780 9,509,368 (373,185) -3.8% Animal Control 460,280 425,572 243,858 425,572 (0) 0.0% Non Departmental: Property Tax Admin 69,628 83,852 - 83,852 - 0.0% Audi Reimbursement 285,393 - - - - 0.0% Retiree Medical Contribution 3,329,927 1,627,325 385,019 1,627,325 - 0.0% PERs Replacement Benefit 112,962 97,484 - 97,484 - 0.0% Staffing Continuity Reserve 39,827 100,000 - 100,000 - 0.0% Total Operating Expenditures 68,653,362 76,544,760 25,648,027 76,526,401 (18,359) 0.0% Excess of Revenues Over(Under)Expenditures 7,237,494 1,814,718 (1,053,228) 2,681,681 866,963 0.0% Fund Description The General Fund is the main operating fund for the City of Temecula. It is used to account for all financial resources for the City that are not restricted to a special purpose and otherwise required to be accounted for in another fund. The General fund provides the resources necessary to sustain the day-to-day activities and pays for all administrative and operating expenditures. a City of Temecula C .--;---itzle/1 '4,75( Fiscal Year 2018-19 Mid-Year Adjustments Fund: 001 GENERAL FUND %Change 2018-19 Year to Date 2018-19 From 2017-18 Current Actuals Revised Increase/ Current Description Actuals Budget 12-31-18 Budget (Decrease) Budget Excess of Revenues Over(Under)Expenditures 7,237,494 1,814,718 (1,053,228) 2,681,681 866,963 0.0% Operating Transfers Out/One Time Payments Capital Improvement Fund (2,730,036) (2,730,036) (3,130,036) (400,000) 14.7% 2018 Financing Lease(Civic Center) (2,135,231) (2,132,450) (1,044,800) (2,081,891) 50,559 -2.4% 2018 Financing Lease(MRC) - (367,233) (139,951) (416,855) (49,622) 13.5% Section 115 Pension Trust (8,000,000) (1,404,941) (1,404,941) (1,404,941) 0.0% Information Technology Fund (77,028) - - - 0.0% Technology Replacement Fund - (125,000) (125,000) (125,000) Total Transfers Out/One Time Payments (10,212,259) (6,759,660) (5,444,728) (7,158,723) (399,063) 5.9% Fund Balance,Beginning of Year 33,702,744 30,727,979 30,727,979 - 0.0% Fund Balance,End of Year 30,727,979 25,783,037 26,250,937 467,900 1.8% Detail of Fund Balance Nonspendable: Inventory 3,058 3,058 3,058 0.0% Deposits 1,325 1,325 1,325 0.0% Committed To: - 0.0% Economic Uncertainty Reserve(20%) 13,730,672 15,308,952 15,305,280 (3,672) 0.0% Secondary Reserve(5%) 3,432,668 3,827,238 3,826,320 (918) 0.0% Pechanga IGA 332,647 362,694 362,694 - 0.0% Assigned To: Capital Projects - - 200,000 200,000 0.0% Unassigned: 13,227,608 6,279,770 6,552,260 272,489 4.3% 30,727,979 25,783,037 26,250,937 467,900 0.0% A-= City of Temecula C.:.;----;4 I Fiscal Year 2018-19 � Mid-Year Adjustments FUND: 002 MEASURE S FUND %Change 2018-19 Year to Date 2018-19 From 2017-18 Current Actuals Revised Increase/ Current Description Actuals Budget 12-31-18 Budget (Decrease) Budget Revenues by Source Taxes and Franchises Transactions and Use Tax 27,197,565 25,200,000 9,103,097 27,200,000 2,000,000 7.9% Use of Money and Property Investment Interest 37,672 17,676 7,171 37,000 19,324 109.3% Total Revenues and Other Sources 27,235,237 25,217,676 9,110,267 27,237,000 2,019,324 8.0% Expenditures by Category Operating Transfers Out-General Fund 4,994,180 5,296,813 2,648,407 5,296,813 0 0.0% Operating Transfers Out-Vehicle Replacement 650,000 1,150,000 575,000 1,150,000 - 0.0% Operating Transfers Out-Information Technology 175,251 - - 450,000 450,000 0.0% Operating Transfers Out-Tech Replacement 55,000 500,000 250,000 500,000 - 0.0% Operating Transfers Out-TCSD 5,341,503 6,033,431 3,016,716 6,211,702 178,271 3.0% Operating Transfers Out-Service Level B 360,251 62,661 62,661 62,661 (0) 0.0% Operating Transfers Out-Library 770,734 662,527 331,264 662,527 - 0.0% Operating Transfers Out-CIP 8,443,728 13,235,084 13,235,084 13,461,084 226,000 1.7% Operating Transfers Out-Facility Replacement 500,000 250,000 500,000 - 0.0% Operating Transfers Out-Street Maintenance - 1,400,000 700,000 1,400,000 - 0.0% Total Expenditures and Other Financing Uses 20,790,647 28,840,516 21,069,131 29,694,787 854,271 3.0% Excess of Revenues Over(Under)Expenditures 6,444,590 (3,622,840) (11,958,863) (2,457,787) 1,165,053 -32.2% Fund Balance,Beginning of Year 236,202 6,680,792 6,680,792 - 0.0% Fund Balance,End of Year 6,680,792 3,057,952 4,223,005 1,165,053 38.1% Fund Description Measure S,approved by the voters on November 8,2016,established a one-cent Transactions and Use Tax for the City. The measure was approved based on the commitment to maintain 9-1-1 emergency response times,prevent cuts to local paramedic/police/fire protection,school safety patrols,youth/after- school,senior and disabled services;improve freeway interchanges/reduce traffic and provide for other general services. EXHIBIT B City of Temecula Cr-e01:--i� � Fiscal Year 2018-19 Q Mid-Year Adjustments FUND: 100 GAS TAX FUND 2018-19 Year to Date 2018-19 2017-18 Current Actuals Revised Increase/ %Change From Description Actuals Budget 12-31-18 Budget (Decrease) Current Budget Revenues by Source Taxes and Franchises Gas Tax 2,324,482 2,805,983 763,266 2,400,359 (405,624) -14.5% Use of Money and Property Investment Interest 2,767 4,000 546 5,500 1,500 37.5% Total Revenues and Other Sources 2,327,249 2,809,983 763,812 2,405,859 (404,124) -14.4% Expenditures by Category Equipment - - 0.0% Operating Transfers Out-General Fund 1,127,249 2,809,983 559,911 2,405,859 (404,124) -14.4% Operating Transfers Out-CIP 1,200,000 - - - - 0.0% Total Expenditures and Other Financing Uses 2,327,249 2,809,983 559,911 2,405,859 (404,124) -14.4% Excess of Revenues Over(Under)Expenditures - - 203,901 - - 0.0% Fund Balance,Beginning of Year - - - - 0.0% Fund Balance,End of Year - - - - 0.0% Fund Description This fund was established to account for the tax per gallon on the purchase of motor vehicle fuel imposed by the State of California.A portion is allocated to the City of Temecula as specified in the California Streets and Highways Code (SHC) (Sections 2013, 2105, 2107 and 2107.5). Gas Tax monies are restricted to the repair,maintenance and upkeep of City streets and roads,and the purchase of equipment used to maintain roads. £ City of Temecula 1 Crei;:e-Gtqalf Fiscal Year 2018-19 Mid-Year Adjustments FUND:102 ROAD MAINTENANCE REHAB ACCOUNT(RMRA)FUND 2018-19 Year to Date 2018-19 2017-18 Current Actuals Revised Increase/ %Change From Description Actuals Budget 12-31-18 Budget (Decrease) Current Budget Revenues by Source Taxes and Franchises Gas Tax 2031(RMRA) 511,782 1,843,670 832,135 1,794,713 (48,957) -2.7% Use of Money and Property Investment Interest 1,215 - 948 2,500 2,500 0.0% Total Revenues and Other Sources 512,997 1,843,670 833,083 1,797,213 (46,457) -2.5% Expenditures by Category Operations and Maintenance - - - 0.0% Operating Transfer Out CIP - 2,476,861 1,251,263 2,310,210 (166,651) -6.7% Total Expenditures and Other Financing Uses - 2,476,861 1,251,263 2,310,210 (166,651) -6.7% Excess of Revenues Over(Under)Expenditures 512,997 (633,191) (418,180) (512,997) 120,194 -19.0% Fund Balance,Beginning of Year - 512,997 512,997 - 0.0% Fund Balance,End of Year 512,997 (120,194) - 120,194 -100.0% Fund Description This fund is to account for gasoline and vehicle registration taxes pursuant to the Road Repair and Accountability Act of 2017(SB1 Beall). Monies are collected by the State of California and allocated to local agencies for streets and roads projects and other transportation uses. 1, City of Temecula C7;"'"--;'ed"fe4f-s -Year Year 2018-19 Mid year Adjustments FUND:103 STREET MAINTENANCE FUND 2018-19 Year to Date 2018-19 2017-18 Current Actuals Revised Increase/ %Change From Description Actuals Budget 12-31-18 Budget (Decrease) Current Budget Revenues by Source Operating Transfer In Measure 5 1,400,000 350,000 1,400,000 - 0.0% Use of Money and Property Investment Interest - - 133 5,000 5,000 0.0% Total Revenues and Other Sources - 1,400,000 350,133 1,405,000 5,000 0.4% Expenditures by Category Operations and Maintenance - - - - 0.0% Operating Transfer Out - - - - 0.0% Total Expenditures and Other Financing Uses - - - - 0.0% Excess of Revenues Over(Under)Expenditures 1,400,000 1,405,000 5,000 0.4% Fund Balance,Beginning of Year - - - 0.0% Fund Balance,End of Year 1,400,000 1,405,000 5,000 0.4% Fund Description This fund was established to accumulate resources for the future replacement of streets and roads throughout the City. City of Temecula I `Cr:1:::e-C414 Fiscal Year 2018-19 Mid-Year Adjustments FUND: 120 DEVELOPMENT IMPACT FEES FUND 2018-19 Year to Date 2018-19 2017-18 Current Actuals Revised Increase/ %Change From Description Actuals Budget 12-31-18 Budget (Decrease) Current Budget Revenues by Source Taxes and Franchises DIE Fees 2,707,880 3,893,968 621,863 3,893,968 - 0.0% Quimby Fees 20,770 675,343 4,836 675,343 - 0.0% Use of Money and Property Investment Interest 66,009 70,000 9,274 70,000 - 0.0% Total Revenues and Other Sources 2,794,659 4,639,311 635,974 4,639,311 - 0.0% Expenditures by Category Operations and Maintenance 11,790 - - 0.0% Operating Transfer Out-CIP 3,123,748 8,173,855 2,873,795 8,173,855 - 0.0% Total Expenditures and Other Financing Uses 3,135,538 8,173,855 2,873,795 8,173,855 - 0.0% Excess of Revenues Over(Under)Expenditures (340,879) (3,534,544) (2,237,821) (3,534,544) - 0.0% Fund Balance,Beginning of Year 4,336,041 3,995,162 3,995,162 - 0.0% Adjustment to Fund Balance - - - Fund Balance,End of Year 3,995,162 460,618 460,618 - 0.0% Fund Description This fund accounts for the development impact fees received as a result of development activity within the City. The fees are primarily used to fund Capital Improvement Projects designed to mitigate the impacts of development projects. L City of Temecula l ,+% Fiscal Year 2018-19 menu C /f Mid Year Adjustments FUND: 125 PUBLIC,EDUCATION&GOVERNMENT(PEG)FEES 2018-19 Year to Date 2018-19 2017-18 Current Actuals Revised Increase/ %Change From Description Actuals Budget 12-31-18 Budget (Decrease) Current Budget Revenues by Source Taxes and Franchises PEG Fees 253,263 224,323 31,676 226,939 2,616 1.2% Use of Money and Property Investment Interest 4,675 3,000 840 5,000 2,000 66.7% Total Revenues and Other Sources 257,938 227,323 32,517 231,939 4,616 2.0% Expenditures by Category Operations and Maintenance 210,490 364,995 127,643 364,995 0 0.0% Total Expenditures and Other Financing Uses 210,490 364,995 127,643 364,995 0 0.0% Excess of Revenues Over(Under)Expenditures 47,448 (137,672) (95,126) (133,056) 4,616 -3.4% Fund Balance,Beginning of Year 309,909 357,357 357,357 0.0% Fund Balance,End of Year 357,357 219,685 224,301 4,616 2.1% Fund Description This fund was established to account for Public Education and Government(PEG)fees.Fees received from local cable operators for the sole purpose of supporting the access facilities and activities within the City. 1?s. City of Temecula cr,..... 1 ' ier Fiscal Year 2018-19 Mid-Year Adjustments FUND: 140 COMMUNITY DEVELOPMENT BLOCK GRANT(CDBG)FUND 2018-19 Year to Date 2018-19 2017-18 Current Actuals Revised Increase/ %Change From Description Actuals Budget 12-31-18 Budget (Decrease) Current Budget Revenues by Source Intergovernmental Revenues Community Development Block Grant 955,537 1,036,090 - 1,036,090 - 0.0% Total Revenues and Other Sources 955,537 1,036,090 - 1,036,090 - 0.0% Expenditures by Category Personnel 103,054 109,385 52,640 109,385 - 0.0% Operations and Maintenance 140,974 113,880 41,312 113,880 - 0.0% Operating Transfers Out-CIP 711,509 812,825 - 812,825 - 0.0% Total Expenditures and Other Financing Uses 955,537 1,036,090 93,952 1,036,090 - 0.0% Excess of Revenues Over(Under)Expenditures - - (93,952) - - 0.0% Fund Balance,Beginning of Year - - - - 0.0% Fund Balance,End of Year - - - - 0.0% Fund Description This fund was established to account for grants received from the U.S.Department of Housing and Urban Development(HUD).The grants are used for the redevelopment of a viable community by providing decent housing,a suitable living environment,and for expanding opportunities,principally for persons of low and moderate income. City of Temecula Lil Cr--'.efte-�7 4 Fiscal Year 2018-19 Mid-Year Adjustments FUND:145 TEMECULA ENERGY EFFICIENCY ASSET MANAGEMENT(TEEM)FUND 2018-19 Year to Date 2018-19 2017-18 Current Actuals Revised Increase/ %Change From Description Actuals Budget 12-31-18 Budget (Decrease) Current Budget Revenues by Source Use of Money and Property Investment Interest 2,576 2,000 455 3,000 1,000 50.0% Total Revenues and Other Sources 2,576 2,000 455 3,000 1,000 50.0% Expenditures by Category Operations and Maintenance - 0.0% Operating Transfers Out-CIP 10,000 - - - - 0.0% Total Expenditures and Other Financing Uses 10,000 - - - - 0.0% Excess of Revenues Over(Under)Expenditures (7,424) 2,000 455 3,000 1,000 50.0% Fund Balance,Beginning of Year 197,698 190,274 190,274 - 0.0% Fund Balance,End of Year 190,274 192,274 193,274 1,000 0.5% Fund Description This fund was established to capture energy efficiency rebates and reimbursements as well as expenditure savings resulting from energy efficiency projects completed at various City facilities. Revenue collected in this fund will be utilized on future energy efficiency projects. City of Temecula L. Fiscal Year 2018-19 - / � Mid-Year Adjustments FUND: 150 AB 2766 MOTOR VEHICLE SUBVENTION FUND 2018-19 Year to Date 2018-19 2017-18 Current Actuals Revised Increase/ %Change From Description Actuals Budget 12-31-18 Budget (Decrease) Current Budget Revenues by Source Intergovernmental Revenues AB2766 Motor Vehicle Subvention Revenues 140,467 144,430 36,705 146,230 1,800 1.2% Use of Money and Property Investment Interest 959 300 250 1,300 1,000 333.3% Total Revenues and Other Sources 141,426 144,730 36,955 147,530 2,800 1.93% Expenditures by Category Operations and Maintenance 10,000 10,000 10,000 10,000 - 0.0% Operating Transfers Out-CIP 135,000 226,353 - 226,353 - 0.0% Total Expenditures and Other Financing Uses 145,000 236,353 10,000 236,353 - 0.0% Excess of Revenues Over(Under)Expenditures (3,574) (91,623) 26,955 (88,823) 2,800 -3.1% Fund Balance,Beginning of Year 136,167 132,593 132,593 - 0.0% Adjustment to Fund Balance Fund Balance,End of Year 132,593 40,970 43,770 2,800 6.8% Fund Description This fund was established to account for State funds that are used to implement programs and projects that reduce air pollution from motor vehicles.This fund is used for Capital projects and the City's share of WRCOG's Clean Cities Coalition. City of Temecula ...--',z,i4 Fiscal Year 2018-19 Mid-Year Adjustments FUND: 160 SUPPLEMENTAL LAW ENFORCEMENT SERVICES(SLESF)FUND 2018-19 Year to Date 2018-19 2017-18 Current Actuals Revised Increase/ %Change From Description Actuals Budget 12-31-18 Budget (Decrease) Current Budget Revenues by Source Intergovernmental Revenues SLESF Grant Revenue 236,073 186,000 107,805 186,000 0.0% Use of Money and Property Investment Interest 383 - 47 800 800 0.0% Total Revenues and Other Sources 236,456 186,000 107,852 186,800 800 0.4% Expenditures by Category Operating Transfers Out-General Fund 236,456 186,000 91,253 186,800 800 0.4% Total Expenditures and Other Financing Uses 236,456 186,000 91,253 186,800 800 0.4% Excess of Revenues Over(Under)Expenditures - - 16,599 - - 0.0% Fund Balance,Beginning of Year - - - - 0.0% Fund Balance,End of Year - - - - 0.0% Fund Description This fund was established to account for the Supplemental Law Enforcement Services grant monies from the State of California which are provided to assist cities in delivering front line law enforcement services. These monies supplement existing services and may not be used to supplant any existing funding for law enforcement services provided by the City. City of Temecula (747-;(414d Fiscal Year 2018-19 Mid-Year Adjustments FUND:161 TEMECULA MAJOR CRIMES REWARD FUND 2018-19 Year to Date 2018-19 2017-18 Current Actuals Revised Increase/ %Change From Description Actuals Budget 12-31-18 Budget (Decrease) Current Budget Revenues by Source Use of Money and Property Investment Interest 350 300 62 400 100 33.3% Total Revenues and Other Sources 350 300 62 400 100 33.3% Expenditures by Category Operations and Maintenance - - - - - 0.0% Total Expenditures and Other Financing Uses - - - - - 0.0% Excess of Revenues Over(Under)Expenditures 350 300 62 400 100 33.3% Fund Balance,Beginning of Year 25,662 26,012 26,012 - 0.0% Fund Balance,End of Year 26,012 26,312 26,412 100 0.4% Fund Description This fund was established to account for a reward for information that leads to the capture and conviction of the person(s)responsible for the murder of Larry Robinson and Justin Triplett. The General Fund contributed $25,000 and the public can also contribute to this fund.The fund was established in accordance with Resolution Nos. 13-25 and 15-37. In April of 2018, Council adopted Resolution No. 18-24 for the continuation of the reward for an additional three years to assist the Sherriff in the investigation since no person has been arrested for the Larry Robinson murder. 1_- City of Temecula C(/;;--;_e1 Fiscal Year 2018-19 Mid-Year Adjustments FUND: 165 AFFORDABLE HOUSING FUND 2018-19 Year to Date 2018-19 2017-18 Current Actuals Revised Increase/ %Change From Description Actuals Budget 12-31-18 Budget (Decrease) Current Budget Revenues by Source Use of Money and Property Residual Receipt Distribution 25,973 37,222 - 37,222 - 0.0% Investment Interest 9,877 9,000 1,958 12,000 3,000 33.3% Loan Interest 987 597 304 597 - 0.0% Reimbursements - - 1,500 1,500 1,500 0.0% Rental Income 29,224 122,593 - 122,593 - 0.0% Forgivable Loan Repayment 31,075 - 198 198 198 0.0% Intergovernmental Revenues Agency Trust Contributions 250,000 250,000 - 250,000 - 0.0% Total Revenues and Other Sources 347,136 419,412 3,959 424,110 4,698 1.1% Expenditures by Category Personnel 180,681 260,716 115,511 260,716 0.0% Operations and Maintenance 122,865 252,407 37,440 252,407 - 0.0% Insurance 7,861 8,065 1,982 8,065 - 0.0% Information Technology 18,036 15,183 3,539 15,183 - 0.0% Support Services 2,109 250 13 250 0.0% Facilities 7,751 9,004 2,420 9,004 - 0.0% Total Expenditures and Other Financing Uses 339,303 545,625 160,904 545,625 - 0.0% Excess of Revenues Over(Under)Expenditures 7,833 (126,213) (156,945) (121,515) 4,698 -3.7% Fund Balance,Beginning of Year 10,811,805 10,819,638 10,819,638 - 0.0% Fund Balance,End of Year 10,819,638 10,693,425 10,698,123 4,698 0.0% Detail of Fund Balance Nonspendable: Land Held for Resale 4,400,388 4,400,388 4,400,388 - 0.0% Notes and Loans 345,817 345,817 345,817 - 0.0% Advances to Successor Agency 5,250,954 5,250,954 5,250,954 - 0.0% Restricted For: Community Development Projects 822,479 696,266 700,964 4,698 0.7% 10,819,638 10,693,425 10,698,123 4,698 0.0% Fund Description The Affordable Housing fund contains the assets as well as loan and rental income which have been transferred to the City of Temecula from the former Redevelopment Agency. City of Temecula LLL I� Fiscal Year 2018-19 Mid-Year Adjustments FUND:170 MEASURE A FUND 2018-19 Year to Date 2018-19 2017-18 Current Actuals Revised Increase/ %Change From Description Actuals Budget 12-31-18 Budget (Decrease) Current Budget Revenues by Source Use of Money and Property Investment Interest 33,825 40,000 7,201 60,000 20,000 50.0% Reimbursements Miscellaneous 35,483 - - - - 0.0% Intergovernmental Revenues Measure A Revenue 3,173,344 3,184,000 1,146,870 3,184,000 - 0.0% Total Revenues and Other Sources 3,242,652 3,224,000 1,154,071 3,244,000 20,000 0.6% Expenditures by Category Operations and Maintenance 795,372 2,008,540 1,156,918 2,008,540 - 0.0% Operating Transfers Out-CIP 4,455,221 4,057,668 1,000,000 4,057,668 - 0.0% Total Expenditures and Other Financing Uses 5,250,593 6,066,208 2,156,918 6,066,208 - 0.0% Excess of Revenues Over(Under)Expenditures (2,007,941) (2,842,208) (1,002,847) (2,822,208) 20,000 -0.7% Fund Balance,Beginning of Year 6,251,531 4,243,590 4,243,590 - 0.0% Fund Balance,End of Year 4,243,590 1,401,382 1,421,382 20,000 1.4% Fund Description This fund was established to account for the City's allocation of the County of Riverside's additional one-half percent sales tax for transportation. These monies are restricted for use on local streets. In 2002, Measure A was extended by Riverside County voters. Measure A will continue to fund transportation improvements through 2039. City of Temecula 1 Ci—iht"------e-Gtqc Fiscal Year 2018-19 Mid-Year Adjustments Fund: 198 PUBLIC ART 2018-19 Year to Date 2018-19 2017-18 Current Actuals Revised Increase/ %Change From Description Actuals Budget 12-31-18 Budget (Decrease) Current Budget Revenues by Source Operating Transfers In Public Art Revenues 38,566 73,511 7,564 73,511 - 0.0% Use of Money and Property Investment Interest 997 1,000 70 1,000 - 0.0% Total Revenues and Other Sources 39,563 74,511 7,634 74,511 - 0.0% Expenditures by Category Operations and Maintenance - 4,026 4,026 4,026 - 0.0% Operating Transfer Out 82,200 - - - - 0.0% Total Expenditures and Other Financing Uses 82,200 4,026 4,026 4,026 - 0.0% Excess of Revenues Over(Under)Expenditures (42,637) 70,485 3,609 70,485 - 0.0% Fund Balance,Beginning of Year 68,605 25,968 25,968 - 0.0% Fund Balance,End of Year 25,968 96,453 96,453 - 0.0% Fund Description This fund was established pursuant to Temecula Municipal Code Section 5.08.040,whereby the fund serves a a depository for the fees paid in lieu of art as well as monetary donations for public art. The Public Art In Lieu fee is one-tenth of one percent of an eligible development project in excess of$100,000. Eligble uses of this fund include the design,acquisition,installation,improvement,maintenance and insurance of public artwork;offering of performing arts programs on City property for the community;and art education programs on City property for the community. City of Temecula 1 1C7---eifi.--; 4 Fiscal Year 2018-19 Mid-Year Adjustments FUND:395 2018 FINANCING LEASE(Civic Center) 2018-19 Year to Date 2018-19 2017-18 Current Actuals Revised Increase/ %Change From Description Actuals Budget 12-31-18 Budget (Decrease) Current Budget Revenues by Source Operating Transfers In General Fund 2,135,231 2,132,450 1,044,800 2,081,891 (50,559) -2.4% Total Revenues and Other Sources 2,135,231 2,132,450 1,044,800 2,081,891 (50,559) -2.4% Expenditures by Category Debt Service Interest 746,231 693,450 332,800 642,891 (50,559) -7.3% Debt Service Principal 1,389,000 1,439,000 712,000 1,439,000 - 0.0% Total Expenditures and Other Financing Uses 2,135,231 2,132,450 1,044,800 2,081,891 (50,559) -2.4% Excess of Revenues Over(Under)Expenditures - - - (0) (0) 0.0% Fund Balance,Beginning of Year - - - - 0.0% Fund Balance,End of Year - - (0) (0) 0.0% Fund Description This fund was established to account for the payment of interest and principal of the refunding of the 2001 and 2008 Certificates of Participation(COPs). The 2001 COPs were originally issued to finance the construction of the Community Recreation Center and the 2008 COPs were originally issued to finance the construction of the Civic Center. In Fiscal Year 2018-19,the terms of the lease were refinanced,lowering the interest rate from 3.75%to 3.42%. The term of the lease expires September 1,2033. �7 City of Temecula /'� Fiscal Year 201Adju -19 stments C // Mid Year Adjustments FUND:396 CAPITAL FINANCING(MRC) 2018-19 Year to Date 2018-19 2017-18 Current Actuals Revised Increase/ %Change From Description Actuals Budget 12-31-18 Budget (Decrease) Current Budget Revenues by Source Operating Transfers In General Fund - 367,233 138,952 416,855 49,622 13.5% Use of Money and Property 2018 Financing Lease MRC - 100,000 95,000 100,000 - 0.0% Total Revenues and Other Sources - 467,233 233,952 516,855 49,622 10.6% Expenditures by Category Cost of Issuance 95,000 95,000 95,000 - 0.0% Debt Service Interest - 313,742 56,193 165,208 (148,534) -47.3% Debt Service Principal - 53,491 82,759 251,647 198,156 370.4% Total Expenditures and Other Financing Uses - 462,233 233,952 511,855 49,622 10.7% Excess of Revenues Over(Under)Expenditures - 5,000 - 5,000 (0) 0.0% Fund Balance,Beginning of Year - - - - 0.0% Fund Balance,End of Year - 5,000 5,000 (0) 0.0% Fund Description This fund was established to account for the payments of interest and principal related to the financing of capital projects,including the acquistion of the City's sreetlights from Southern California Edison. As of Fiscal Year 2018-19,a total of$5,682,489 remains outstanding on the streetlight acquisition loan and is expected to be fully paid by December 1,2033. EXHIBIT C f_ City of Temecula Fiscal Year 2018-19 � / %11 -s _- Mid-Year Adjustments FUND:300 INSURANCE FUND %Change 2018-19 Year to Date 2018-19 From 2017-18 Current Actuals Revised Increase/ Current Description Actuals Budget 12-31-18 Budget (Decrease) Budget Revenues by Source Licenses,Permits and Service Charges Charges For Services 1,172,356 992,137 243,866 992,137 - 0.0% Miscellaneous Miscellaneous - 157,788 157,788 157,788 0.0% Use of Money and Property Investment Interest 4,537 3,000 578 4,600 1,600 53.3% Total Revenues and Other Sources 1,176,893 995,137 244,444 996,737 1,600 0.2% Expenses by Category Personnel 29,740 35,642 17,676 35,642 - 0.0% Operations and Maintenance 1,400,391 959,495 412,560 959,495 - 0.0% Total Expenses and Other Financing Uses 1,430,131 995,137 430,236 995,137 - 0.0% Excess of Revenues Over(Under)Expenses (253,238) - (185,792) 1,600 1,600 0.0% Net Position,Beginning of Year 305,196 51,958 51,958 - 0.0% Adjustment to Net Position - - Net Position,End of Year 51,958 51,958 53,558 1,600 3.1% Fund Description The Insurance Fund was established to account for the City's liability and property insurance costs. Net Position is a combination of both spendable and non spendable assets.These costs are allocated to each department based on the total number of Full Time Equivalent positions assigned to those departments. The City has a Self-Insured Retention(SIR)of$150,000 per incident,and strives to maintain a Net Position equal to two times the SIR. t_ City of Temecula (7----.1"11 ° -‘ Fiscal Year 2018-19 R Mid-Year Adjustments FUND:305 WORKERS'COMPENSATION FUND %Change 2018-19 Year to Date 2018-19 From 2017-18 Current Actuals Revised Increase/ Current Description Actuals Budget 12-31-18 Budget (Decrease) Budget Revenues by Source Licenses,Permits and Service Charges Charges for Services 693,485 690,333 202,616 690,333 - 0.0% Use of Money and Property Investment Interest 13,733 11,000 3,200 20,000 9,000 81.8% Total Revenues and Other Sources 707,218 701,333 205,816 710,333 9,000 1.3% Expenses by Category Personnel 113,885 35,642 16,936 35,642 - 0.0% Operations and Maintenance 137,209 387,135 70,510 387,135 - 0.0% Total Expenses and Other Financing Uses 251,094 422,777 87,446 422,777 - 0.0% Excess of Revenues Over(Under)Expenses 456,124 278,556 118,370 287,556 9,000 3.2% Net Position,Beginning of Year 930,498 1,386,622 1,386,622 - 0.0% Net Position,End of Year 1,386,622 1,665,178 1,674,178 9,000 0.5% Fund Description The Workers' Compensation Fund was established in Fiscal Year 2014-15 as the City transitions to a self-insured status for Workers' Compensation liabilities. Departments are charged based on each position allocated on a Full Time Equivalent basis,with a cost assigned to each position based on job duties and potential for risk. The desired Net Position for this fund is$1.5 million,which represents three-times the City's Self-Insured Retention amount of$500,000. City of Temecula Fiscal Year 2018-19 R Mid-Year Adjustments FUND:310 VEHICLES AND EQUIPMENT FUND %Change 2018-19 Year to Date 2018-19 From 2017-18 Current Actuals Revised Increase/ Current Description Actuals Budget 12-31-18 Budget (Decrease) Budget Revenues by Source Licenses,Permits and Service Charges Charges for Services 64,204 347,426 24,089 347,426 - 0.0% Use of Money and Property Investment Interest 24,392 20,000 5,421 35,000 15,000 75.0% Operating Transfers In Measure S 650,000 1,150,000 287,500 1,150,000 - 0.0% Total Revenues and Other Sources 738,596 1,517,426 317,010 1,532,426 15,000 1.0% Expenses by Category Operations and Maintenance 81,660 - - - - 0.0% Capital Outlay - 858,125 119,534 858,125 Total Expenses and Other Financing Uses 81,660 858,125 119,534 858,125 - 0.0% Excess of Revenues Over(Under)Expenses 656,936 659,301 197,475 674,301 15,000 2.3% Net Position,Beginning of Year 1,930,757 2,587,693 2,587,693 - 0.0% Adjustment to Net Position - - -Net Position,End of Year 2,587,693 3,246,994 3,261,994 15,000 0.5% Fund Description The Vehicles and Equipment Fund was established to account for the depreciation of vehicles and capital equipment over their estimated useful lives, and to accumulate resources for the purchase of future replacement vehicles and equipment. Net Position is a combination of both spendable and non spendable assets.Departments are charged based on the replacement costs for each asset benefitting the department. L City of Temecula Fiscal Year 2018-19 geg,e.cti,411 Mid-Year Adjustments FUND:320 INFORMATION TECHNOLOGY FUND %Change 2018-19 Year to Date 2018-19 From 2017-18 Current Actuals Revised Increase/ Current Description Actuals Budget 12-31-18 Budget (Decrease) Budget Revenues by Source Licenses,Permits and Service Charges Charges for Services 3,088,791 3,497,594 826,434 3,497,594 - 0.0% Miscellaneous Miscellaneous - 45,000 45,000 45,000 0.0% Use of Money and Property Investment Interest 3,969 1,000 500 2,000 1,000 100.0% Operating Transfers In General Fund 77,028 - - - - 0.0% Measure S 230,251 - - 450,000 450,000 0.0% Total Revenues and Other Sources 3,400,039 3,498,594 871,934 3,994,594 496,000 14.2% Expenses by Category Personnel 1,756,077 1,877,011 876,826 1,877,011 0 0.0% Operations and Maintenance 1,410,194 1,945,368 937,462 2,415,368 470,000 24.2% Total Expenses and Other Financing Uses 3,166,271 3,822,379 1,814,288 4,292,379 470,000 12.3% Excess of Revenues Over(Under)Expenses 233,768 (323,785) (942,355) (297,785) 26,000 -8.0% Net Position,Beginning of Year 238,971 472,739 472,739 - 0.0% Adjustment to Net Position - - - - Net Position,End of Year 472,739 148,954 174,954 26,000 17.5% Fund Description The Information Technology Fund was established to fund and account for computer and telephone system operating and maintenance expenses. Net Position is a combination of both spendable and non spendable assets. Adjustments are made to Net Position to include additional spendable resources available for expenditure. Departments are charged based on the number of electronic devices assigned. The Ronald H.Roberts Temecula Public Library facility is charged directly for all IT expenditures and personnel costs related to the facility. i_ City of Temecula lFiscal Year 2018-19 q-e.'17-.1"----"74-41 Mid-Year Adjustments FUND:325 TECHNOLOGY REPLACEMENT FUND %Change 2018-19 Year to Date 2018-19 From 2017-18 Current Actuals Revised Increase/ Current Description Actuals Budget 12-31-18 Budget (Decrease) Budget Revenues by Source Licenses,Permits and Service Charges Charges for Services 213,932 400,723 72,070 400,723 - 0.0% Operating Transfer In Operating Transfer In - 125,000 125,000 125,000 - 0.0% Measure S Fund - 500,000 125,000 500,000 - 0.0% Use of Money and Property Investment Interest 11,848 7,000 1,642 11,000 4,000 57.1% Total Revenues and Other Sources 225,780 1,032,723 323,712 1,036,723 4,000 0.4% Expenses by Category Operations and Maintenance 254,801 - 885 - - 0.0% Capital Outlay - 310,000 115,952 310,000 - 0.0% Total Expenses and Other Financing Uses 254,801 310,000 116,837 310,000 - 0.0% Excess of Revenues Over(Under)Expenses (29,021) 722,723 206,876 726,723 4,000 0.6% Net Position,Beginning of Year 1,278,467 1,249,446 1,249,446 - 0.0% Adjustment to Net Position - - - - Net Position,End of Year 1,249,446 1,972,169 1,976,169 4,000 0.2% Fund Description The Technology Replacement Fund was established in Fiscal Year 2014-15 in order to accumulate resources for computer and telephone equipment and software to fund future equipment replacement. Net Position is a combination of both spendable and non spendable assets. Contributions to this fund are made by departments utilizing the assets in an amount equivalent to the estimated cost to replace the item at the end of its useful life. gell-":"44-411 L_ City of Temecula Fiscal Year 2018-19 1 Mid-Year Adjustments FUND:330 SUPPORT SERVICES FUND %Change 2018-19 Year to Date 2018-19 From 2017-18 Current Actuals Revised Increase/ Current Description Actuals Budget 12-31-18 Budget (Decrease) Budget Revenues by Source Licenses,Permits and Service Charges Charges for Services 344,267 403,381 84,539 362,965 (40,416) -10.0% Use of Money and Property Investment Interest 5,465 5,000 846 6,000 1,000 20.0% Total Revenues and Other Sources 349,732 408,381 85,385 368,965 (39,416) -9.7% Expenses by Category Personnel 205,989 224,438 108,203 224,438 - 0.0% Operations and Maintenance 166,768 172,542 63,582 144,527 (28,015) -16.2% Operating Transfer Out 444,102 444,102 0.0% Total Expenses and Other Financing Uses 372,757 396,980 171,784 813,067 416,087 104.8% Excess of Revenues Over(Under)Expenses (23,025) 11,401 (86,399) (444,102) (455,503) -3995.3% Net Position,Beginning of Year 467,127 444,102 444,102 - 0.0% Adjustment to Net Position - - -Net Position,End of Year 444,102 455,503 - (455,503) -100.0% Fund Description The Support Services Fund was established as a cost center for the City's central receptionist,duplicating, printing, and mailing activities. Net Position is a combination of both spendable and non spendable assets. Departments are charged based on a count of copies made in the previous fiscal year. In FY2018-19, the assets and available balance in this fund was transferred to establish Fund 355 - Support Services Replacement Fund,in order to accumulate resources for the future replacement of the City's duplicating and printing equipment. i_ City of Temecula C7 ----e-:C/4- Fiscal Year 2018-19 G{ Mid-Year Adjustments FUND:335 SUPPORT SERVICES REPLACEMENT FUND %Change 2018-19 Year to Date 2018-19 From 2017-18 Current Actuals Revised Increase/ Current Description Actuals Budget 12-31-18 Budget (Decrease) Budget Revenues by Source Licenses,Permits and Service Charges Charges for Services 7,260 38,015 38,015 0.0% Operating Transfer In Operating Transfer In 444,102 444,102 0.0% Use of Money and Property Investment Interest - - 0.0% Total Revenues and Other Sources - - 7,260 482,117 482,117 0.0% Expenses by Category Operations and Maintenance 18,378 18,378 18,378 0.0% Total Expenses and Other Financing Uses - - 18,378 18,378 18,378 0.0% Excess of Revenues Over(Under)Expenses - - (11,118) 463,739 463,739 0.0% Net Position,Beginning of Year - - - - 0.0% Adjustment to Net Position - - -Net Position,End of Year - - 463,739 463,739 0.0% Fund Description The Support Services Replacement Fund was established in Fiscal Year 2018-19 in order to accumulate resources for the future replacement of the City's duplicating and printing equipment. Net Position is a combination of both spendable and non spendable assets. Contributions to this fund are made by departments utilizing the assets in an amount equivalent to the estimated cost to replace the item at the end of its useful life. i_ City of Temecula /7% I ' Fiscal Year 2018-19 (/ G{ Mid-Year Adjustments FUND:340 FACILITIES FUND %Change 2018-19 Year to Date 2018-19 From 2017-18 Current Actuals Revised Increase/ Current Description Actuals Budget 12-31-18 Budget (Decrease) Budget Revenues by Source Licenses,Permits and Service Charges Charges for Services 1,251,887 1,328,888 360,896 1,328,888 0.0% Use of Money and Property Investment Interest 5,650 5,000 1,066 7,000 2,000 40.0% Total Revenues and Other Sources 1,257,537 1,333,888 361,962 1,335,888 2,000 0.1% Expenses by Category Personnel 394,348 395,628 187,097 395,628 0 0.0% Operations and Maintenance 839,589 944,516 435,709 956,516 12,000 1.3% Total Expenses and Other Financing Uses 1,233,937 1,340,144 622,806 1,352,144 12,000 0.9% Excess of Revenues Over(Under)Expenses 23,600 (6,256) (260,844) (16,256) (10,000) 159.8% Net Position,Beginning of Year 497,452 521,052 521,052 - 0.0% Adjustment to Net Position - - - - Net Position,End of Year 521,052 514,796 504,796 (10,000) -1.9% Fund Description The Facilities Fund was established to account for the cost of the Civic Center, Former City Hall Facility, City Maintenance Facility, Field Operations Center,and Civic Center Parking Structure operations and maintenance. Net Position is a combination of both spendable and non spendable assets.Departments are charged based on square footage allotted as well as full time staff equivalents assigned. ��'"� L__ City of Temecula Fiscal Year 2018-19 G{ Mid-Year Adjustments FUND: 350 FACILITY REPLACEMENT FUND %Change 2018-19 Year to Date 2018-19 From 2017-18 Current Actuals Revised Increase/ Current Description Actuals Budget 12-31-18 Budget (Decrease) Budget Revenues by Source Licenses,Permits and Service Charges Charges for Services 39,725 10,097 39,725 0.0% Use of Money and Property Investment Interest - - 28 1,000 1,000 0.0% Operating Transfer In Transfer In Measure S - 500,000 125,000 500,000 - 0.0% Total Revenues and Other Sources - 539,725 135,097 539,725 - 0.0% Expenses by Category Operations and Maintenance - - - 0.0% Capital Outlay - 362,336 51,500 362,336 - 0.0% Operating Transfers Out - 143,664 143,664 143,664 - 0.0% Total Expenses and Other Financing Uses - 506,000 195,164 506,000 - 0.0% Excess of Revenues Over(Under)Expenses - 33,725 (60,067) 33,725 - 0.0% Net Position,Beginning of Year - - - - 0.0% Net Position,End of Year - 33,725 33,725 - 0.0% Fund Description This fund was established to accumulate resources for the future replacement of equipment,systems and fixtures within City-owned facilites.