Exhibit 1 - Appropriations, Estimated Revenues, and Transfers Item Department Fund Amount Description
1 Community Services General Fund (110) 3,400 2021-2019 Housing Element Programs and Objectives 2 Community Services General Fund (110) 15,000 Historic Civic Center Centennial Celebration 3 Community Services General Fund (110) 48,860 Create Program Coordinator Position / Eliminate Assistant Recreation Coordinator Position (part-time) 4 Fire Department General Fund (110) 141,379 EMS Equipment, Training Personnel and Training Non-Personnel 4 Fire Department General Fund (110) 100,000 New Capital Improvement Project - Emergency Medical Services Skills Lab Tenant Improvements 5 General Government General Fund (110) 104,400 Special Tax Consulting Services 6 General Government General Fund (110) 214,361 Information Technology Cost Allocation / Migration to Microsoft E5 Licensing from E3 7 Human Resources General Fund (110) 20,000 Coastal Training Technologies Contract Cost Increase 8 Police Department General Fund (110) 1,856 FY 2023 Bulletproof Vest Partnership Grant Award 9 Police Department General Fund (110) 60,000 Shift Differential Budget per MOU 10 Public Works General Fund (110) 20,000 Canvas on the Curb Utility Box Art Program 11 Public Works General Fund (110) 11,748 Create Associate Engineer - Traffic Position / Eliminate Traffic Management Technician I FLEX Position 12 Public Works General Fund (110) 75,000 New Capital Improvement Project - Santa Ana River Trail General Fund (110) Total $816,004
13 Police Department Measure X Fund (120) 63,092 New Animal Control Truck 13 Police Department Measure X Fund (120) (63,092) New Animal Control Truck (Measure X Public Safety Reserve) 9 Police Department Measure X Fund (120) 10,000 Shift Differential Budget per MOU 14 Public Works Measure X Fund (120) 7,120 Office Space Expansion Cost Increase 15 Public Works Measure X Fund (120) 12,409 New 2024 Bucket Truck Cost Difference / 2023 Model No Longer Available Measure X Fund (120) Total $29,529
16 Police Department Temescal Canyon Law Enforcement Fund (208) 40,000 E-Bikes and Pedal Bikes for Bike Team Temescal Canyon Law Enforcement Fund (208) Total $40,000 6 Public Works Gas Tax Fund (222) 3,619 Information Technology Cost Allocation / Migration to Microsoft E5 Licensing from E3 11 Public Works Gas Tax Fund (222) 46,992 Create Associate Engineer - Traffic Position / Eliminate Traffic Management Technician I FLEX Position Gas Tax Fund (222) Total $50,611
5 Community Services CFD 2016-3, Zone 12 Fund (235) 1,168 Special Tax Consulting Services CFD 2016-3, Zone 12 Fund (235) Total $1,168
6 Public Works NPDES Fund (245) 1,853 Information Technology Cost Allocation / Migration to Microsoft E5 Licensing from E3 NPDES Fund (245) Total $1,853
17 Police Department Asset Forfeiture Fund (250) 55,000 Various Equipment Needs Asset Forfeiture Fund (250) Total $55,000
6 Public Works LMD 2003-1 Lighting Fund (252) 220 Information Technology Cost Allocation / Migration to Microsoft E5 Licensing from E3 LMD 2003-1 Lighting Fund (252) Total $220
6 Community Services CFD 2011-1 Landscape/Lighting Fund (253) 89 Information Technology Cost Allocation / Migration to Microsoft E5 Licensing from E3 CFD 2011-1 Landscape/Lighting Fund (253) Total $89
5 Community Services CFD 2016-3, Zone 24 Fund (270) 1,032 Special Tax Consulting Services CFD 2016-3, Zone 24 Fund (270) Total $1,032
6 Community Services Airport Fund (275) 265 Information Technology Cost Allocation / Migration to Microsoft E5 Licensing from E3 Airport Fund (275) Total $265
5 Community Services CFD 2016-3, Zone 32 Fund (280) 1,032 Special Tax Consulting Services CFD 2016-3, Zone 32 Fund (280) Total $1,032
5 Community Services CFD 2016-3, Zone 33 Fund (281) 1,032 Special Tax Consulting Services CFD 2016-3, Zone 33 Fund (281) Total $1,032
5 Community Services LMD 84-2, Zone 17 Fund (463) 15,000 Special Tax Consulting Services LMD 84-2, Zone 17 Fund (463) Total $15,000
5 Community Services LMD 84-2, Zone 18 Fund (464) 15,000 Special Tax Consulting Services LMD 84-2, Zone 18 Fund (464) Total $15,000
5 Community Services LMD 84-2, Zone 19 Fund (468) 47,563 Special Tax Consulting Services / General Benefit Contribution LMD 84-2, Zone 19 Fund (468) Total $47,563
6 Community Services Successor Agency Admin Fund (475) 22 Information Technology Cost Allocation / Migration to Microsoft E5 Licensing from E3 Successor Agency Admin Fund (475) Total $22
6 Utilities Reclaimed Water Utility Fund (567) 815 Information Technology Cost Allocation / Migration to Microsoft E5 Licensing from E3 Reclaimed Water Utility Fund (567) Total $815
6 Utilities Water Utility Fund (570) 34,511 Information Technology Cost Allocation / Migration to Microsoft E5 Licensing from E3 18 Utilities Water Utility Fund (570) 300,000 Booster Station Rehabilitation at Various Locations Project No. UT-2021-01 Water Utility Fund (570) Total $334,511
6 Utilities Sewer Utility Fund (572) 27,244 Information Technology Cost Allocation / Migration to Microsoft E5 Licensing from E3 Sewer Utility Fund (572) Total $27,244
6 Community Services Transit Service Fund (577) 220 Information Technology Cost Allocation / Migration to Microsoft E5 Licensing from E3 Transit Service Fund (577) Total $220
6 Utilities Direct Access Electric Utility Fund (576) 2,985 Information Technology Cost Allocation / Migration to Microsoft E5 Licensing from E3 Direct Access Electric Utility Fund (576) Total $2,985
Appropriations
City of Corona Page 1 Fiscal Year 2024 Quarter 1 Budgetary Adjustments Exhibit 1 - Appropriations, Estimated Revenues, and Transfers Item Department Fund Amount Description
Appropriations
6 Utilities Greenfield Electric Utility Fund (578) 4,122 Information Technology Cost Allocation / Migration to Microsoft E5 Licensing from E3 Greenfield Electric Utility Fund (578) Total $4,122
6 Information Technology Information Technology Fund (681) 290,326 Migration to Microsoft E5 Licensing from E3 Information Technology Fund (681) Total $290,326
19 Public Works Fleet Replacement Fund (684) 76,875 Replacement Vehicle Down Payments Fleet Replacement Fund (684) Total $76,875
Appropriations (All Funds) Total $1,812,518
Item Department Fund Amount Description
20 Community Services General Fund (110) 12,000 Historic Civic Center Centennial Celebration 21 Police Department General Fund (110) 1,856 FY 2023 Bulletproof Vest Partnership Grant Award General Fund (110) Total $13,856
22 Information Technology Information Technology Fund (681) 290,326 Information Technology Cost Allocation / Migration to Microsoft E5 Licensing from E3 Information Technology Fund (681) Total $290,326
23 Public Works Fleet Operations Fund (682) 3,202 New Animal Control Truck Motor Pool Fleet Operations Fund (682) Total $3,202
23 Public Works Fleet Replacement Fund (684) 21,768 New Animal Control Truck Motor Pool Fleet Replacement Fund (684) Total $21,768
Estimated Revenues (All Funds) Total $329,152
Item Project Fund Amount Description
Sherborn Street Improvements General Fund (110) (438,374.00) Magnolia Avenue Bridge and Roadway Widening General Fund (110) 438,374.00 Corona Mall BID Establishment General Fund (110) (115,220.00) Sixth Street Beautification and Revitalization General Fund (110) 115,220.00 Corona Mall Business Improvement District Corona Mall Business Improvement District Fund (218) (312,655.00) Sixth Street Beautification and Revitalization Corona Mall Business Improvement District Fund (218) 312,655.00 Timekeeping System Implementation General Fund (110) (327,239.00) Enterprise Resource Planning (ERP) System General Fund (110) 327,239.00 Timekeeping System Implementation Measure X Fund (120) (100,000.00) Enterprise Resource Planning (ERP) System Measure X Fund (120) 100,000.00 Open Air Stage at Circle City Center American Rescue Plan Act Fund (413) (5,639.00) Computer Equipment at Senior Center American Rescue Plan Act Fund (413) (3,539.00) Sixth Street Beautification and Revitalization American Rescue Plan Act Fund (413) 9,178.00 Transfers Total $0.00
At the Fall Policy Workshop on October 12, 2023, staff proposed transferring the remaining balance of two completed projects totaling $9,178 to the Sixth Street Beautification and Revitalization Capital Improvement Project.
The developer paid improvements for construction improvements on Sherborn Street south of Magnolia Ave, which is a part of the Magnolia Avenue Bridge and Roadway Widening Project.
Estimated Revenues
Transfers
24 25
26 27
The boundaries of Sixth Street and Main Street are within the Business Improvement Development to assist in funding all necessary costs associated with the Sixth Street Beautification and Revitalization Project.
Staff recommends to close the existing Timekeeping System Project and consolidate the funding with the ERP Project.
Additional funding for the ERP system will be requested once the vendor/system evaluation process is complete.
City of Corona Page 2 Fiscal Year 2024 Quarter 1 Budgetary Adjustments