Loading...
HomeMy WebLinkAboutAgenda Report - March 2, 2022 H-01AGENDA ITEM H am I CITY OF LODI COUNCIL COMMUNICATION TM AGENDA TITLE: Adopt Resolution Approving Fiscal Year 2021/22 Mid -Year Budget Adjustments MEETING DATE: PREPARED BY March 2, 2022 Budget Manager RECOMMENDED ACTION: Adopt resolution approving the Fiscal Year 2021/22 Mid -Year Budget Adjustments. BACKGROUND INFORMATION: The City Council adopted the Fiscal Year 2021/22 Budget on June 2, 2021. The budget sets the priorities for funding services within the City of Lodi for the fiscal year. A mid -year review of revenue and expenditure projections was conducted and staff present the following recommended budget adjustments and staffing changes. General Fund Revenues: General Fund revenues are coming in very close to original projections with the exception of sales tax estimates. The City's sales tax consultants, HdL Companies, is projecting strong growth in several business group categories, in particular General Consumer Goods, Autos/Transportation and Restaurants/Hotels that is driving sales tax estimates up. Their estimates for General Sales tax is $2,290,760 higher than originally projected and Measure L sales tax is $1,199,280 higher. Additional revenue will be received as reimbursement for the final weeks of the Great Plates program that fell in the month of July. The current revenue budget is $$67,074,130 with a mid -year revenue projection of $70,699,130 for a year end projection increase of $3,625,000. The major category changes in projected revenues are summarized in Table 1. Table 1 Revenue Category Revised Budget Mid -Year Proj +/- Sales/Use Tax 21,775,960 25,265,000 3,489,040 Reimbursable Charges 5,000 245,000 240,000 General Fund Expenditures: The overall General Fund expenses are projected to be $458,320 lower than the current revised budget of $67,836,955. This is primarily due to staff vacancies. Non -Department is projecting an increase due to the final weeks of the Great Plates project and recommended mid -year budget adjustments discussed later in this report. Table 2 shows the General Fund expenditure projections compared to budget by department. APPROVED: Steve S- wabauer(Feb 18, 202208:19 PST) Stephen Schwabauer, City Manager Table 2 Department Revised Budget Mid -Year Projection +/- City Attorney 706,690 638,670 (68,020) City Clerk 704,500 703,240 (1,260) City Manager 810,290 801,170 (9,120) Code Enforcement 539,741 511,540 (28,201) Economic Development 528,490 514,450 (14,040) Fire Department 16,392,350 16,306,240 (86,110) Internal Services 5,799,340 5,641,400 (157,940) Non -Departmental 12,522,500 12,832,800 310,300 Police Department 26,657,739 1 26,294,480 (363,259) Public Works 3,175,320 1 3,134,650 (40,670) Total 67,836,960_1_67,378,640 (458,320) Electric Utility Electric Utility anticipates an increase in revenue of approximately $1,795,670, primarily attributed to an estimated increase in Greenhouse Gas proceeds. Other revenue projected increases are in Work for Others and City Accounts. The department anticipates a net decrease in expenses of approximately $1,554,840, which is a combination of increased generation costs and changes in scope of several capital improvement projects. Table 3 summarizes the requested changes to current capital projects. Table 3 Project Current Project Budget Requested Change Revised Project Budget 12KV Overhead 2,542,778 1,050,774 (1,492,004) 12kV Underground 165,000 465,000 300,000 60 kv Breaker Replace 2,000,000 - (2,000,000) 1267 Feeder Extension 403,199 650,000 246,801 Henning Feeder Extension 1,075,000 - (1,075,000) Total 6,185,977 2,165,774 (4,020,203) The Electric Utility Department continues to face challenges with long lead times in procurement. Purchasing heavy equipment can have a year or more build times. Staff is recommending increases to the Machinery/Equipment and Vehicle budgets for the following items so that purchases orders can be placed as soon as possible. ■ Replacement of Hogg and Davis Puller Trailer for pulling cable: $210,000 • Replacement of Digger Derrick Line Truck #001-14: $325,000 • Replacement of Troubleshooter Bucket Truck # 09-077: $200,000 Streets Fund Operating revenues are projected at a $1,112,240 increase due to reimbursement for prior year's capital projects. Expenditures are trending at budget. Parks, Recreation and Cultural Services Fund Revenues and expenditures are trending on budget. In addition to staff request discussed later in this report, staff are recommending the purchase of two maintenance trucks for a cost of $120,000. Additional Mid -Year Adjustments Self -Insurance Fund: An adjustment of $260,000 in General Liabilities and $625,000 in Worker's Compensation that reflects claim settlements and increased costs. Transit Fund: An adjustment of $56,270 in expenses for a grant received in the LCTOP program for student bus fares and longer Saturday hours. Community Grants: Corrections in HEAP and PLHA grant awards and capital expenses reflected in prior Council action that were not included on the adopted resolution. Personnel Adjustments Staff is recommending the addition of nine full time positions and the reclassification of one position as indicated in Table 4: Table 4 New Positions Department Annual Cost Mid -Year Est. Police Lieutenant Police Department 260,000 68,000 Reclass (1) Officer to Corporal Police Department 16,000 4,000 Jr. Engineer Public Works Engineering 103,500 28,380 City Planner* Community Development 190,000 - Administrative Clerk Community Development 86,000 21,500 Park Maintenance Worker 1/11 Parks, Rec., & Cultural Srvs 90,000 22,500 Park Maintenance Worker 1/II Parks, Rec., & Cultural Srvs 90,000 22,500 Street Superintendent Streets 206,480 51,620 Street Maintenance Worker 1/11 Streets 89,440 22,360 Street Maintenance Worker 1/11 Streets 89,440 22,360 * Community Development is requesting authorization of the position and recruitment for a start date July 1st or later; therefore, no funding is being requested for FY 22 ■ Police Lieutenant — to supervise the patrol unit of the Police Department. Adding this position will bring the department back up to the Lieutenant level of 2012/13. • Reclass (1) Police Officer to Police Corporal — to provide assistance in new programs such as the Mobile Field Force, Project Lifesaver and Health and Wellness. This position will assist in training new employees. • Jr. Engineer — to help the Public Works Engineering Division address increased development and appropriately distributing the workload with the Development Services Division; delivering capital improvement projects; and providing support for additional State regulations associated with stormwater compliance. • City Planner — this position has been in an unfunded status for several years. The department has been using contractual services for long-term planning and project development review. The department is requesting the authorization of the position and approval to move forward with the recruitment process for a start date of July 1, 2022 or later. Funding would be included in the FY 23 budget. ■ Administrative Clerk — the Community Development Department has experienced a steady increase in the amount of clerical duties needed to support the busy department. The transfer of Code Enforcement to the department has also increased the need to clerical support. • (2) Park Maintenance Worker 1/II — The Parks, Recreation and Cultural Services Department is requesting the addition of two Park Maintenance 1/11 positions in their efforts to address restoring a park maintenance workforce necessary to provide safe open spaces in Lodi. The park system has seen an increase of 71 park acres over the past 25 years and a decrease in full-time maintenance staff. These will be funded with a transfer from the General Fund and a partial offset of part-time hours in the Parks Division. Street Superintendent — This position has been unfunded since 2013 and duties transferred to the Utilities Superintendent. The city has grown in this time and the workload exceeds the current staffing level. This position is needed to maintain existing service levels and meet the demands of the city. This position is to be funded 50% by the Wastewater Storm Drain Division. (2) Street Maintenance Worker 1/II — The Streets Maintenance Division saw a decrease in staff with the recession of 2008. Some maintenance activities have been accomplished with maintenance contracts; however with the growth of the city since 2014, the city has added 15 miles of new streets and infrastructure to maintenance. Staff is requesting these positions to maintain an acceptable level of service, keep existing programs and demands of the city. Attachment A to this report specifies the line item budget adjustments needed for all the above staff recommendations. FISCAL IMPACT Revenue and expenditure budget adjustments per attachment A to address staff recommendations. Andrew K� 15, M 2 11:05 PST) Andrew Keys, Deputy City Manager Attachment Exhibit A Mid -Year Adjustments FY 2021-22 Current Mid -Year Revised Account Number Account Description Budget Adjustment Budget Mid -Year Ammendments 100 -103 General Fund $ Revenue Adjustment $ 10095000.51031 Sales Tax 10095000.55020 Reimburseable Charges 10300000.51031 Sales Tax Total Revenue Adjustments $ Expense Adjustment $ 10032000.71001 Personnel 10032000.72359 Small Tools/Equipment 10050500.71001 Personnel 10050500.72359 Small Tools/Equipment 10095000.76220 Transfer Out 10095000.72355 General Supplies Total Expense Adjustments 3,000 200 Parks, Recreation and Cultural Services 4,750 Revenue Adjustment $ 20000000.50001 Transfer In Total Revenue Adjustments $ 23,000 Expense Adjustment 3,000 20072202.71001 Personnel 20072202.71003 PT Personnel 20072202.77040 Vehicles Total Expense Adjustments $ - 270 Community Development 240,000 Expense Adjustment 240,000 27080000.71001 Personnel Total Expense Adjustments $ $ 14,035,240 $ 2,289,760 $ 16,325,000 $ 5,000 $ 1,199,280 $ 1,204,280 $ 7,740,720 $ 240,000 $ 7,980,720 $ 21,780,960 $ 3,729,040 $ 25,510,000 $ 6,470,330 $ 69,000 $ 6,539,330 $ 1,750 $ 3,000 $ 4,750 $ 1,477,240 $ 25,880 $ 1,503,120 $ 23,000 $ 3,000 $ 26,000 $ 9,025,320 $ 156,320 $ 9,181,640 $ - $ 240,000 $ 240,000 $ 16,997,640 $ 497,200 $ 17,494,840 $ 5,237,580 $ 156,320 $ 5,393,900 $ 5,237,580 $ 156,320 $ 5,393,900 $ 624,180 $ 45,180 $ 669,360 $ 245,090 $ (8,860) $ 236,230 $ - $ 120,000 $ 120,000 $ 869,270 $ 156,320 $ 1,025,590 $ 447,000 $ 21,500 $ 468,500 $ 447,000 $ 21,500 $ 468,500 301-307 Streets Revenue Adjustment 30300000.51033 Street Maint. Measure K $ 1,200,000 $ 225,000 $ 1,425,000 30300000.56037 Measure K Reimbursement $ - $ 547,530 $ 547,530 30700000.56402 Other Federal Grants $ - $ 639,930 $ 639,930 Total Revenue Adjustments $ 1,200,000 $ 1,412,460 $ 2,612,460 Expense Adjustment 30156001.71001 Personnel $ 899,870 $ 96,340 $ 996,210 30156001.71188 Personnel Recovery $ (1,319,870) $ (48,170) $ (1,368,040) Total Expense Adjustments $ (420,000) $ 48,170 $ (371,830) 355 Community Grants Revenue Adjustment 35500000.56005 State Grants $ 800,000 $ 522,660 $ 1,322,660 35500000.56007 County Grants $ 132,470 $ 2,800,000 $ 2,932,470 Total Revenue Adjustments $ 932,470 $ 3,322,660 $ 4,255,130 Expense Adjustment 35084000.77020 Capital Projects $ 382,215 $ (336,265) $ 45,950 Page 1 of 2 Exhibit A Mid -Year Adjustments FY 2021-22 Account Number Account Descri Mid -Year Ammendments Current Mid -Year Budeet Adiustment Revised 35085000.77020 Capital Projects $ 1,674,110 $ 336,270 $ 2,010,380 Total Expense Adjustments $ 2,056,325 $ 5 $ 2,056,330 500 -508 Electric Utility Revenue Adjustment 50000000.55301 50000000.58822 50800000.59541 Total Revenue Adjustments Expense Adjustment 50060500.72901 50199000.77020 50199000.77030 50199000.77040 50465300.72450 50465300.72921 50599000.77020 50862500.72901 Total Expense Adjustments Work for Others 505,000 $ 95,000 $ 600,000 City Accounts 1,379,490 $ 500,560 $ 1,880,050 Greenhouse Gas 2,100,030 $ 1,199,970 $ 3,300,000 $ 3,984,520 $ 1,795,530 $ 5,780,050 Generation Capital Projects Machinery and Equipment Vehicles Misc. Professional Services Lodi CARE Program Capital Projects Generation - Greenhouse 530-531 Wastewater Utility Expense Adjustment 53053005.71189 Personnel Transfer Total Expense Adjustments $ 30,734,130 $ 1,949,400 $ 32,683,530 $ 10,286,302 $ (3,192,002) $ 7,094,300 $ 562,100 $ 210,000 $ 772,100 $ 903,019 $ 525,001 $ 1,428,020 $ 338,635 $ (212,435) $ 126,200 $ 283,308 $ (233,308) $ 50,000 $ 1,928,199 $ (828,199) $ 1,100,000 $ 1,144,400 $ 355,600 $ 1,500,000 $ 46,180,093 $ (1,425,943) $ 44,754,150 $ 300,000 $ 48,170 $ 348,170 $ 300,000 $ 48,170 $ 348,170 600 Transit Expense Adjustment 60454108.72499 Misc. Contract Services $ 60,000 $ 56,270 $ 116,270 Total Expense Adjustments $ 60,000 $ 56,270 $ 116,270 660-655 Self Insurance Expense Adjustment 66025000.72399 66025000.72990 66525100.72990 66525100.74031 Total Expense Adjustments Supplies and Services $ 625,000 $ 175,000 $ 800,000 Special Payments $ 640,000 $ 85,000 $ 725,000 Special Payments $ 700,000 $ 220,000 $ 920,000 Workers Compensation $ 1,545,000 $ 405,000 $ 1,950,000 $ 3,510,000 $ 885,000 $ 4,395,000 Page 2 of 2 Capital Improvement Program - Maintenance FY 2021-2022 Maintenance Project Title: 12 kV Overhead Maintenance I Munis Project Code: EUCP-21002 #43 Section I:Description District Nos: Citywide Project Length Ongoing lPriority High Maintenance and improvements associated with the 12 kV overhead distribution system. Justification/factor driving project These ongoing efforts include replacement of annealed copper conductors with aluminum conductor steel reinforced (ACSR). Whereas copper is notoriously brittle and prone to breakage with age, ACSR offers optimal strength for ovehead line design. Additional activities include replacement of poles, transformers, switches, and/or capacitor banks as needed as well as inspection of overhead infrastrucutre, and pole test, treat and stubbing efforts. Additional Information As of FY 22 midyear review, FY 21 actuals have been updated as well as the the FY 22 budget to include previous year rollover and current/anticipated spending levels. Future year budgets will be updated as part of the FY 23 budget planning process. Section II Estimated Project Costs Expenditure Prior Years FY 20/21 Estimate Internal Staff $ - $ 326,638 $ Miscellaneous $ - $ 285,300 $ FY 21122 Budget 644,116 394,805 FY 22/23 FY 23/24 FY 24/25 $ 1,343,000 $ 846,200 $ 846,200 $ FY 25/26 846,200 Future Yrs NIA $ Total 4,852,354 $ 1,017,000 $ 685,800 $ 685,800 $ 685,800 NIA $ 3,754,505 Contracts $ - $ 307,309 $ 11,853 $ 50,000 $ 50,000 $ 35,000 $ 35,000 NIA $ 489,162 Total Capital Costs $ - $ 919,247 $ 1,050,774 $ 2,410,000 $ 1,582,000 $ 1,567,000 $ 1,567,000 NIA $ 9,096,021 Section III Funding Sources/Methods of Financing Funding Source(s) Prior Years FY 20121 Estimate 501 - EU Outlay Capital Reserve Fund $ $ 919,247 $ Total Project Financing $ - $ 919,247 $ FY 21122 Budget 1,050,774 1,050,774 FY 22/23 FY 23124 FY 24125 $ 2,410,000 $ 1,582,000 $ 1,567,000 $ 2,410,000 $ 1,582,000 $ 1,567,000 $ $ FY 25/26 1,567,000 1,567,000 Future Yrs N/A NIA $ $ Total 9,096,021 9,096,021 Section IV I Operating Budget Impact Operating Cost or (savings) Prior Years FY 20121 Estimate Personnel $ - Other Operating Costs $ - Total Operating Impact $ - $ - $ FY 21/22 Budget FY 22/23 FY 23124 FY 24/25 FY 25/26 1 Future Yrs $ Total - $ - j $ - $ j $ - $ - $ - $ - Capital Improvement Program - Maintenance FY 2021-2022 Maintenance Project Title: 12 W Underground Maintenance Munis Project Code: EUCP-21006 #44 Section I:Description District Nos: Citywide Project Length Ongoing jPriority I High Inspection and replacement of 12 W underground infrastructure and other underground electric infrastructure maintenance as needed. Justification/factor driving project These ongoing maintenance efforts include, but are not limited to, replacement of failed/end-of-life cable; replacement of cable due to engineering study of predictive failure; installation/replacement of subsurface equipment with pad -mounted equipment to increase operability and reliability and other underground electric infrastructure maintenance as needed. Additional Information As of FY 22 midyear review, FY 21 actuals have been updated as well as the the FY 22 budget to include previous year rollover and additional monies based on year to date spending. Future year budgets will be updated as part of the FY 23 budget planning process. Section II Estimated Project Costs Expenditure Internal Staff Prior Years FY 20121 FY 21122 Actuals Budget $ $ 217,666 $ 145,000 FY 22123 FY 23124 FY 24125 $ 25,000 $ 25,000 $ 25,000 $ FY 25126 25,000 Future Yrs N/A Total $ 462,666 Miscellaneous $ - $ 539,166 $ 220,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 N/A $ 919,166 Contracts $ - $ 572,665 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 N/A $ 1,072,665 Total Capital Costs $ - $ 1,329,497 $ 465,000 $ 165,000 $ 165,000 $ 165,000 $ 165,000 NIA $ 2,454,497 Section III Funding Sources/Methods of Financing Funding Source(s) 501 - ELI Outlay Capital Reserve Fund Total Project Financing Prior Years $ - $ - FY 20121 FY 21122 Actuals Budget $ 1,329,497 $ 465,000 FY 22123 FY 23124 FY 24125 $ 165,000 $ 165,000 $ 165,000 $ FY 25126 165,000 Future Yrs Total N/A $ 2,454,497 $ 1,329,497 $ 465,000 $ 165,000 $ 165,000 1 $ 165,000 $ 165,000 NIA $ 2,454,497 Section IV , Operating Budget Impact Operating Cost or (savings) Personnel Other Operating Costs Total Operating Impact Prior Years $ - $ - $ - FY 20121 FY 21122 Estimate Budget FY 22/23 FY 23124 FY 24125 FY 25126 Future Yrs Total $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Capital Improvement Plan FY 2021-2022 Project Title: 1267 Feeder Extension Project Munis Project Code: EUCP-20001 #48 Section I: Description District Nos: 3,5 Project Length 7/18-6/22 Priority High The 1267 feeder circuit from the Industrial Substation currently ends at Reynolds Ranch Parkway. The scope of this project is to extend this circuit to the west along Harney Lane in order to serve upcoming new developments in the southwest part of Lodi. This project also includes extending the Henning Substation feeder 1247 towards east on Century Blvd. and connecting it to the extended 1267 feeder from Industrial substation. Justification/factor driving project The southwest part of Lodi is served by several feeder circuits from the Henning Substation. However, all of the exiting Henning circuits have reached their contingency capacity. Therefore, in order to serve a portion of the growing load in a reliable manner, extension of the 1267 circuit from the Industrial Substation to the southwest part of Lodi is needed. 600 amp backbone infrastructure is needed to support the growing residential and commercial load in the South-West part of Lodi. This will extend the 600 amp backbone infrastructure to the south- west corner of Lodi. Additional Information As of FY 22 midyear review, the FY 22 budget includes a revised budget which combines it with the 1247 Henning Feeder Extension Project which has been eliminated as the combined project presented herein will include a tie in of both the 1247 and 1267 Feeder Extensions. FY 21 actuals have also been updated to reflect the project in its entirety. Section II: Estimated Project Costs Expenditure Prior Years FY 20121 FY 21122 FY 22123 FY 23124 FY 24125 FY 25126 Future Yrs Total Actuals Budget Internal Staff $ 47,169 $ 20,140 $ 95,000 $ 162,309 Miscellaneous $ 274,184 $ 38,625 $ 275,000 $ 587,809 Contracts $ 66,413 $ - $ 280,000 $ 346,413 Total Capital Costs $ 387,766 $ 58,765 $ 650,000 $ - $ - $ - $ - $ - $ 1,096,531 Section III: Funding Sources/Methods of Financing Funding Source(s) Prior Years FY 20121 FY 21122 FY 22123 FY 23124 FY 24125 FY 25126 Future Yrs Total Actuals Budget 505 - EU Substation & Trans - IMF $ 387,766 $ 58,765 $ 650,000 $ 1,096,531 Total Project Financing $ 387,766 $ 58,765 $ 650,000 $ - $ - $ - $ - $ - $ 1,096,531 Section IV Operating Budget Impact Operating Cost or (savings) Prior Years FY 20121 FY 21122 FY 22123 FY 23124 FY 24125 FY 25126 Future Yrs Total Estimate Budget Personnel $ $ - Other Operating Costs $ - $ - Total Operating Impact $ - $ - $ - $ - $ - $ - $ - $ - $ - Capital Improvement Plan FY 2020-2021 Project Title: Homeless Emergency Aid Progr (HEAP) Munis Project Code: HEAP -20001 #84 Section I Description Project Length 05/01/19-06/30/21 Priority High Purchase of land, development and installation of Tiny Homes to assist the local unsheltered persons in permanent supportive housing. Grant awarded $1,250,000 plus any interest earned, and $150,000 in General Fund for Acquisition. Justification/factor driving project The City of Lodi is experiencing a crisis with its homeless population. Over the last few years, the City has seen an increase in the number of sheltered and unsheltered homeless individuals. Many of those in temporary shelters have difficulty finding affordable and safe permanent housing. Additional Information When the San Joaquin Continuum of Care announced HEAP notice of funding availability, the Lodi Improvement Committee members reviewed and evaluated, along with input from the town hall meeting and several homeless service providers, potential projects that would assist Lodi's homeless population while fitting within the grant guidelines. The Committee recommended that the City pursue a tiny -homes permanent supportive housing project now known as Harmony Homes. Section II Estimated Project Costs Expenditure Prior Years FY 19/20 FY 20/21 FY 21/22 FY 22/23 FY 23/24 FY 24/25 Future Yrs. Total Estimate Budget Contracts $ $ 1,250,000 $ 221,312 $ 445,950 $ 1,917,262 $ Total Capital Costs $ - $ 1,250,000 $ 221,312 $ 445,950 $ $ - $ - $ - $ 1,917,262 Section III Funding Sources/Methods of Financing Funding Source(s) Prior Years FY 19/20 FY 20/21 FY 21/22 FY 22/23 FY 23/24 FY 24/25 Future Yrs. Total Estimate Budget 355 - HEAP Grant $ $ 1,250,000 $ 71,312 $ 45,950 $ 1,367,263 431 - Capital Outlay/General Fund $ $ 150,000 $ 150,000 355 - HHAP $ $ 400,000 $ 400,000 Total Project Financing $ - $ 1,250,000 $ 221,312 $ 445,950 $ - $ - $ $ 1,917,263 Section IV Operating Budget Impact Operating Cost or (savings) Prior Years FY 19/20 FY 20/21 FY 21/22 FY 22/23 FY 23/24 FY 24/25 Future Yrs. Total Estimate Budget Personnel $ $ Other Operating Costs $ $ Total Operating Impact $ - $ - $ - $ - $ - $ - $ - $ - $ Capital Improvement Plan FY 2021-2022 Project Title: 1247 Henning Feeder Extension I Munis Project Code: EUCP-21005 #122 Section I: Description District Nos: 3 Project Length 7/20-6/22 Priority High Extend Henning Substation feeder 1247 towards east on Century Blvd. and connect it to the extended 1267 feeder from Industrial substation. Justification/factor driving project 600 amp backbone infrastructure is needed to support the growing residential and commercial load in the South-West part of Lodi. This will extend the 600 amp backbone infrastructure to the south-west corner of Lodi. Additional Information As of FY 22 midyear review, the FY 22 budget includes rollover of FY 21 funds; however, this specific CIP project has been eliminated and combined with the existing 1267 Feeder Extension Project as the project in its entirely will include a tie in of both the 1247 and 1267 Feeder Extensions. The total project cost has also been updated as part of the 1267 Feeder Extension Project. Section II: Estimated Project Costs Expenditure Prior Years FY 20121 FY 21122 FY 22123 FY 23124 FY 24125 FY 25126 Future Yrs Total Actual Budget Internal Staff $ - $ - $ - $ - Miscellaneous $ $ - $ - $ - Contracts $ $ - $ $ - Total Capital Costs $ - $ - $ - $ - $ - $ - $ - $ - $ - Section III: Funding Sources/Methods of Financing Funding Source(s) Prior Years FY 20121 FY 21122 FY 22123 FY 23124 FY 24125 FY 25126 Future Yrs Total Actual Budget 505 - EU Substation & Trans - IMF $ - $ - $ - $ - Total Project Financing $ - $ - $ - $ - $ - $ - $ - $ - $ - Section IV Operating Budget Impact Operating Cost or (savings) Prior Years FY 20121 FY 21122 FY 22123 FY 23124 FY 24125 FY 25126 Future Yrs Total Estimate Budget Personnel $ - $ - Other Operating Costs $ $ - Total Operating Impact $ - $ - $ - $ - $ - $ - $ - $ - $ - Capital Improvement Plan FY 2020-2021 Project Title: Emergency Shelter Munis Project Code: PLHA-21001 169 Section I Description Project Length 10/01/2020-6/30/2023 JPriority I High Emergency Shelter: PLHA funds will be used for capital costs for a permanent emergency homeless shelter, including predevelopment, infrastructure and site improvements. Permanent Supportive Housing: PLHA funds will also be used for capital costs for development and construction of four units of permanent supportive housing for homeless individuals and families or those at risk of homelessness. Justificationifactor driving project The City of Lodi is experiencing a crisis with its homeless population. Over the last few years, the City has seen an increase in the number of sheltered and unsheltered homeless individuals. Many of those in temporary shelters have difficulty finding affordable and safe permanent housing. Additional Information Lodi does not currently have a permanent shelter for people experiencing homelessness. The Lodi Committee on Homelessness, in collaboration with several local and regional homeless experts, has determined that a low -bar shelter with supportive services is critical to assisting the city's unsheltered homeless population. The proposed emergency shelter facility will provide temporary emergency shelter for individuals and families that are typically at or below 30 percent of Area Median Income. The emergency shelter will serve as an interim step in assisting the unsheltered homeless population in securing long-term housing. Section II Estimated Project Costs Expenditure Prior Years FY 19120 FY 20121 FY 21122 FY 22/23 FY 23124 FY 24125 Future Yrs Total Estimate Budget Contracts $ $ 1,431,325 $ 336,265 $ 1,767,590 $ 150,000 Miscellaneous $ $ 150,000 Internal Staff $ $ 100,000 $ 100,000 Total Capital Costs $ - $ - $ 1,681,325 $ 336,265 $ $ - $ $ - $ 2,017,590 Section III Funding Sources/Methods of Financing Funding Source(s) Prior Years FY 19120 FY 20/21 FY 21122 FY 22/23 FY 23/24 FY 24125 Future Yrs Total Estimate Budget 355 - Permanent Local Housing Allocation $ $ 1,681,325 $ 336,265 $ 2,017,590 Total Project Financing $ $ $ 1,681,325 $ 336,265 1 $ $ $ $ - $ 2,017,590 Section IV Operating Budget Impact Operating Cost or (savings) Prior Years FY 19120 FY 20121 FY 21/22 FY 22/23 FY 23124 FY 24125 Future Yrs Total Estimate Budget Personnel $ $ - Other Operating Costs $ $ - $ - $ - $ - Total Operating Impact $ - $ - $ - $ $ - $ - Capital Improvement Plan FY 2021-2022 Project Title: 60 kv Breaker Replacement I Munis Project Code: EUCP-22001 #195 Section I: Description District Nos: 3,4,5 Project Length 7/21-6/22 Priority High At Industrial substation: Replace fourteen (14) SF6 insulated 60 kv breakers with vaccum breakers. Install one (1) new 60 kv vacuum breaker. At Killelea substation: replace two (2) oil insulated 60 kV breakers with vacuum breakers. At Henning substation: replace two (2) oil insulated 60 kV breakers with vacuum breakers. Justification/factor driving project SF6 has been identified as a greenhouse gas and its release is regulated by the California Air Resources Board. While LEU meets the current standards for SF6 gas release, the requirements continue to be reviewed and there are regulation changes on the horizon that will require that SF6 for the 60 kV application be phased out completely by January 1, 2025. The 60 kv oil breakers at Henning and Killelea are old and prone to abrupt failures. Additional Information As of FY 22 midyear review, due to updated regulations, this project has been eliminated from the proposed CIP at this time. A long-term maintenance program will instead be established as part of the Fiscal Year 2022123 planning process to address these breakers. Section II: Estimated Project Costs Expenditure Prior Years FY 20121 FY 21122 FY 22123 FY 23124 FY 24125 FY 25126 Future Yrs Total Actual Budget Contracts $ - $ - $ - Total Capital Costs $ - $ - $ - $ - $ - $ - $ - $ - $ - Section III: Funding Sources/Methods of Financing Funding Source(s) Prior Years FY 20121 FY 21122 FY 22123 FY 23124 FY 24125 FY 25126 Future Yrs Total Actual Budget 501 - EU Outlay Capital Reserve Fund $ - $ -� $ - Total Project Financing $ - $ - $ - $ - $ - $ - $ - $ - $ - Section IV Operating Budget Impact Operating Cost or (savings) Prior Years FY 20121 FY 21122 FY 22123 FY 23124 FY 24125 FY 25126 Future Yrs Total Estimate Budget Personnel $ - I $ - Other Operating Costs $ - $ - p 9 Total Operating Impact $ - $ - $ - $ - $ - $ - $ - $ - $ - RESOLUTION NO. 2022-62 A RESOLUTION OF THE LODI CITY COUNCIL AMENDING THE CITY OF LODI FISCAL YEAR 2021-22 BUDGET; APPROVING THE ADDITION OF ONE POLICE LIEUTENANT, ONE JUNIOR ENGINEER, ONE CITY PLANNER, ONE ADMINISTRATIVE CLERK, TWO PARK MAINTENANCE WORKERS 1/11, ONE STREET SUPERINTENDENT, AND TWO STREET MAINTENANCE WORKERS 1/11; AND APPROVING THE RECLASSIFICATION OF ONE POLICE OFFICER TO POLICE CORPORAL WHEREAS, the City Council adopted the Fiscal Year 2021/22 Budget on June 2, 2021; and WHEREAS, the 2021/22 Financial Plan and Budget was prepared in accordance with the City Council's goals, budget assumptions, and policies; and WHEREAS, the budget Resolution requires a mid -year update which was presented to City Council at its regularly -scheduled meeting on March 2, 2022; and WHEREAS, revisions to the budget are necessary to address circumstances unknown at the time of the budget adoption. NOW, THEREFORE BE IT RESOLVED that the Lodi City Council does hereby approve: 1) All budget amendments to Fiscal Year 2020/21 Budget as outlined on Exhibit A; and 2) The addition of one Police Lieutenant and reclass of one Police Officer to Police Corporal in the Police Department; and 3) The addition of one Junior Engineer in Public Works Engineering Division; and 4) The addition of one City Planner and one Administrative Clerk position in the Community Development Department; and 5) The addition of two Park Maintenance Worker 1/11 positions in the Parks, Recreation and Cultural Services Department; and 6) The addition of one Street Superintendent and two Maintenance Worker 1/11 positions in the Public Works Streets Division. BE IT FURTHER RESOLVED, pursuant to Section 6.3q of the City Council Protocol Manual (Res. No. 2019-223), the City Attorney is hereby authorized to make minor revisions to the above -referenced document(s) that do not alter the compensation or term, and to make clerical corrections as necessary. Dated: March 2, 2022 ------------------------------------------------------------------------ ------------------------------------------------------------------------ I hereby certify that Resolution No. 2022-62 was passed and adopted by the City Council of the City of Lodi in a regular meeting held March 2, 2022 by the following vote: AYES: COUNCIL MEMBERS — Hothi, Khan, Kuehne, Nakanishi, and Mayor Chandler NOES: COUNCIL MEMBERS — None ABSENT: COUNCIL MEMBERS — None ABSTAIN. COUNCIL MEMBERS — None l rn PAMELA M. FARRIS Assistant City Clerk 2022-62 Exhibit A Mid -Year Adjustments FY 2021-22 Account Number Account Description Mid -Year Ammendments 100 -103 General Fund 14,035,240 Revenue Adjustment $ 16,325,000 10095000.51031 Sales Tax 10095000.55020 Reimburseable Charges 10300000.51031 Sales Tax Total Revenue Adjustments $ 7,980,720 Expense Adjustment 21,780,960 10032000.71001 Personnel 10032000.72359 Small Tools/Equipment 10050500.71001 Personnel 10050500.72359 Small Tools/Equipment 10095000.76220 Transfer Out 10095000.72355 General Supplies Total Expense Adjustments $ 4,750 200 Parks, Recreation and Cultural Services Revenue Adjustment 20000000.50001 Transfer In Total Revenue Adjustments Expense Adjustment 20072202.71001 Personnel 20072202.71003 PT Personnel 20072202.77040 Vehicles Total Expense Adjustments 270 Community Development Expense Adjustment 27080000.71001 Personnel Total Expense Adjustments Current Mid -Year Budget Adjustment Revised $ 14,035,240 $ 2,289,760 $ 16,325,000 $ 5,000 $ 1,199,280 $ 1,204,280 $ 7,740,720 $ 240,000 $ 7,980,720 $ 21,780,960 $ 3,729,040 $ 25,510,000 $ - $ 547,530 $ 547,530 $ 6,470,330 $ 69,000 $ 6,539,330 $ 1,750 $ 3,000 $ 4,750 $ 1,477,240 $ 25,880 $ 1,503,120 $ 23,000 $ 3,000 $ 26,000 $ 9,025,320 $ 156,320 $ 9,181,640 $ - $ 240,000 $ 240,000 $ 16,997,640 $ 497,200 $ 17,494,840 $ 5,237,580 $ 156,320 $ 5,393,900 $ 5,237,580 $ 156,320 $ 5,393,900 $ 624,180 $ 45,180 $ 669,360 $ 245,090 $ (8,860) $ 236,230 $ - $ 120,000 $ 120,000 $ 869,270 $ 156,320 $ 1,025,590 $ 447,000 $ 21,500 $ 468,500 $ 447,000 $ 21,500 $ 468,500 301-307 Streets Revenue Adjustment 30300000.51033 Street Maint. Measure K $ 1,200,000 $ 225,000 $ 1,425,000 30300000.56037 Measure K Reimbursement $ - $ 547,530 $ 547,530 30700000.56402 Other Federal Grants $ • $ 639,930 $ 639,930 Total Revenue Adjustments $ 1,200,000 $ 1,412,460 $ 2,612,460 Expense Adjustment 30156001.71001 Personnel 30156001.71188 Personnel Recovery Total Expense Adjustments 355 Community Grants Revenue Adjustment 35500000.56005 State Grants 35500000.56007 County Grants Total Revenue Adjustments Expense Adjustment 35084000.77020 Capital Projects $ 899,870 $ 96,340 $ 996,210 $ (1,319,870) $ (48,170) $ (1,368,040) $ (420,000) $ 48,170 $ (371,830) $ 800,000 $ 522,660 $ 1,322,660 $ 132,470 $ 2,800,000 $ 2,932,470 $ 932,470 $ 3,322,660 $ 4,255,130 $ 382,215 $ (336,265) $ 45,950 Page 1 of 2 Exhibit A Mid -Year Adjustments FY 2021-22 Account Number Account Description Mid -Year Ammendments 35085000.77020 Capital Projects Total Expense Adjustments 500 -508 Electric Utility 1,674,110 Revenue Adjustment 336,270 50000000.55301 Work for Others 50000000.58822 City Accounts 50800000.59541 Greenhouse Gas Total Revenue Adjustments 505,000 Expense Adjustment 95,000 50060500.72901 Generation 50199000.77020 Capital Projects 50199000.77030 Machinery and Equipment 50199000.77040 Vehicles 50465300.72450 Misc. Professional Services 50465300.72921 Lodi CARE Program 50599000.77020 Capital Projects 50862500.72901 Generation - Greenhouse Total Expense Adjustments 30,734,130 530-531 Wastewater Utility Expense Adjustment 53053005.71189 Personnel Transfer Total Expense Adjustments Current Mid -Year Revised Budget Adjustment Budget $ 1,674,110 $ 336,270 $ 2,010,380 $ 2.,056.325 $ 5 $ 2,056,330 66525100.74031 505,000 $ 95,000 $ 600,000 $ 1,950,000 1,379,490 $ 500,560 $ 1,880,050 2,100,030 $ 1,199,970 $ 3,300,000 $ 3,984,520 $ 1,795,530 $ 5,780,050 $ 30,734,130 $ 1,949,400 $ 32,683,530 $ 10,286,302 $ (3,192,002) $ 7,094,300 $ 562,100 $ 210,000 $ 772,100 $ 903,019 $ 525,001 $ 1,428,020 $ 338,635 $ (212,435) $ 126,200 $ 283,308 $ (233,308) $ 50,000 $ 1,928,199 $ (828,199) $ 1,100,000 $ 1,144..400 $ 355,600 $ 1,500,000 $ 46,180,093 $ (1,425,943) $ 44,754,150 $ 300,000 $ 48,170 $ 348,170 $ 300,000 $ 48,170 $ 348,170 600 Transit Expense Adjustment 60454108.72499 Misc. Contract Services $ 60,000 $ 56,270 $ 116,270 Total Expense Adjustments $ 60,000 $ 56,270 $ 116,270 660-655 Self Insurance 625,000 Expense Adjustment $ 800,000 66025000.72399 Supplies and Services 66025000.72990 Special Payments 66525100.72990 Special Payments 66525100.74031 Workers Compensation Total Expense Adjustments 1,545,000 $ 625,000 $ 175,000 $ 800,000 $ 640,000 $ 85,000 $ 725,000 $ 700,000 $ 220,000 $ 920,000 $ 1,545,000 $ 405,000 $ 1,950,000 $ 3,510,000 $ 885,000 $ 4,395,000 Page 2 of 2 Fiscal Year 2021/22 Budget Mid Year Report • All fund have been reviewed for both revenue and expenditure needs • The mid -year presentation and requested budget adjustment reflect only those funds that need to be adjusted; unmentioned funds are trending at budget levels Revenue Adopted Budget Revised Budget Year-End Projection* Revenue Over/(Under) Projection General Fund 5913161630 6710741130 7016991130 316251000 Electric Utility 811728,390 81,991,390 83,787,060 11795,670 Street Fund 7,635,050 7,635,050 8,7471290 111121240 Parks, Rec & Cultural Srvs Fund 71435,130 71443,930 7,569,290 125,360 Community Improvement Grants 1,855,140 2,687,610 6,019,980 3,332,370 * Includes all recommended budget adjustments Expenditures Adopted Budget Revised Budget Year -End Projection* Expenditure Over/(Under) Projection General Fund 6710741130 6718361,955 671,3781-640 (458,315) Electric Utility 85,326,720 91,485,083 8919301-240 (1,554,843) Wastewater Utility 19,471,630 24,712,138 24,656,440 (55,698) Transit Fund 12,612,620 13,081,255 13,104,930 23,675 Streets Fund 6,228,250 9,071,154 9,073,020 1,866 Community Development Fund 2,947,940 2,947,940 2,945,210 (2,730) Parks, Rec & Cultural Srvs Fund 9,480,710 9,489,510 9,506,130 161620 Self Insurance Fund 610481360 610481360 6,915,640 8671280 * Includes all recommended budget adjustments New Positions Department Annual Cost Mid -Year Est. Police Lieutenant Police Department 2601000 68,000 Reclass (1) Officer to Corporal Police Department 16,000 4,000 Jr. Engineer Public Works Engineering 103,500 28,380 City Planner* Community Development 190,000 - Administrative Clerk Community Development 86,000 21,500 Park Maintenance Worker 1/11 Parks, Rec., & Cultural Srvs 90,000 22,500 Park Maintenance Worker 1/11 Parks, Rec., & Cultural Srvs 901000 22,500 Street Superintendent Streets 2061480 511620 Street Maintenance Worker 1/11 Streets 891440 22,360 Street Maintenance Worker 1/11 Streets _T 891440 22,360 * Community Development is requesting authorization of the position and recruitment for a start date July 1st or later; therefore, no funding is being requested for FY 22 General Fund Requests: Police Lieutenant 68,000 Police Corporal reclass 4,000 Jr. Engineer 281880 Transfer to PRCS for (2) Maintenance Staff 1441320 Transfer to PRCS for (2) Trucks 120,000 Final Great Plates Program Costs 240,000 Electric Utility Requests: Power Generation 21305,000 Reduce Capital Projects (4,020,200) Reduction to CARES Program (445,743) Replacement of Puller Trailer 210,000 Replacement of Digger Derrick Line Truck 325,000 Replacement of Bucket Truck 200,000 Streets Fund Request: Street Superintendent 25,810 (2) Street Maintenance Workers 22,360 Wastewater Utility Request Share of Street Superintendent 25,810 Share of (2) Street Maintenance Workers 22,360 Parks, Rec & Cultural Srvs Fund Request (2) Parks Maintenance Workers 36,320 (2) Maintenance Trucks 120,000 Transit Request: LCTOP Program 56,270 Community Development Request: Administrative Clerk 21,500 Self -Insurance Fund Request General Liability - Settled Claims 260,000 Worker's Compensation - Settled Claims 220,000 Worker's Compensation - Increased Costs 405,000 • Adopt resolution adjusting appropriations in various funds to address FY 2021/22 needs, approving the addition of (1) Police Lieutenant; (1) Jr. Engineer; (1) City Planner; (1) Administrative Clerk; (2) Park Maintenance Worker 1/11; (1) Street Superintendent; (2) Street Maintenance Worker 1/11; and approving reclassification of (1) police officer to police corporal Questions ? __