Loading...
FY20-2nd Quarter Budget Reports with CM Budget Reports as Backup _ W V, nL' W V J ■ � nL' W -0 U � N W :L L L J � O � O � 00 L v V) O 3v omoom k � m00NN W QJ m 00 N N x � m � � � 0 N ^♦ WrsI�t0m LL NOOOOf� IOm LL I y v ` ++ ul VJ 0) LnmHHN 0N0rsH I k X u1 � 111000 V) W KmNI�tI � I (0 01 w W � � 00m 3 H Ql 06 lO lO LL } {/} {/} {/} {/} LL VI 0) N N 00 00 00 3 — ♦�^/� 00 � m � c ^Vr aJ � ILn � No N 4, 4A4A4A0 N LL LL 0, 1 > 7 00 00 00 m q) 0omr10vN CV > M N H 0 0 C � NHr, M y O C J LL �I } LL (D L Q)E 4 +V += � =E > L Mo � 0 0 0 0 0 0 0 0 0 VJ ♦�L,J — M � v 3 c c c c c c c c +n 4-0U 3 � 0 0 0 0 0 0 0 3 � � 8 8 8 8 8 8 8 0 C �--+ o ui o ui o ui o ui U/ Q M m N N H H ill 0 '0 a a } a v0i MM LL L� O � � 10 3 . . H Ln Q Qm rl � (n > N N v, 0000 M 01 v LL 0 c 1 > O H a 0 Q LL 1/ ie W bA X 4 W p 3 � 00 � 41 L' N v0i b0A N 0) N Ix .x OOC m LL N N N U) 00 LL W , MLn 0 N � 41 W +3+ } � NM Q / Q LL } 00 m vi } ry 41 T 3 Ol C J mLL NN b�A W co 0 m 0 4-0 ECOCO W O y 00 00 00 00 00 00 in LL a 3 0 ; � o 0 0 0 0 0 1 V Q o0G w 0 °o °o °o °o °0 00 c u o ui o Ln o ui V 0 0 N N 0 0 Ln H H 0 -0 0 0 >. o Lnf1 LOf1 O LL U) 0 0 M M M to 3 0 N Q W QCO00 0 0 ^� N M vi LL W to 0 O 000� co c ■ 0— 7N HM v X QLL } O00 W w 0 m N co I bA N M H ' V♦ m LL co N N a) ilk ilk LL ^� 0 M W 0 0 3 > fOOI � NN u Q� u LL Q LL fy Q 0 � vi 0 v C H O MN y }` O N N W J y 7 LL 4) Cn Z 0 U) oEo o o o o o o o o o o > 0 0 0 0 0 0 0 0 0 0 0 Q� W c U. o 0 0 0 0 0 0 0 0 0 ■ }, V Q a 0 0 0 0 0 0 0 0 0 0 � x I 00 00 00 00 00 00 00 00 00 00 W 0 OG i li fV 0 00% W0% 1% N N eel eel eel eel eel 1A 0 1A 1A M 0 0 N H H o .0 LL N 00 G1 NOG — f0 bA010 41 w N Q Q m in/F in/F � 0 } 0 N 0 LL N y 7 N Q N N } 0 Q LL } l0 W v ^� T j oA W � 0 m 0 N v CV Hk Nlk^' +� W _ ' \ '0 } 0 N D CY) 0 0 LL 0. L - 4— W 00 r O . Ln 0 11 E LL C: Ln, 00 E ' J oN LL 01 ce 4- 0 p z ; '0 } No 0 � �^ Q 3 LL v J J bA Cu m W 0 Cu U) W 3 0 0 0 0 0 0 0 0 0 LL ^�.L 00 00 00 00 g g g g Xa Q' 00 00 00 00 00 00 00 00 3 W 0 0 0 0 0 0 0 0 l0 fV C 00 0 N 1 1 N 99 L- O U) M ^ 0 'G a a V^♦, LL M M V♦ ^� N 001 N o� W pp N +3+ 0— N0 a x Qm W 0 0 mN V) LL �00 mN p �► 0 41 " � Q LL } ri l0 wtio v 0 7 m Nn v � 41 m I a) v \ '> } N M � �3LL �► Ln 0 a) N ry 0 0 LL eel O A.-i C Q LL } n Q W i/F i/1 V v } a 3 c � a) Nm v LL 4-00 'G ++ ■ CV �Z � } � _ o � 0 � m LL M Q 3 � � a v 0 0 0 0 0 0 0 0 0 } p = = 0 0 0 0 0 0 0 0 LL C a 0 0 0 0 0 0 0 0 n, 0 w 0 0 0 0 0 0 0 0 O N 0 ao 0% a N co u0i o o +n +n +n +n Ln � � ^U) W O 'a o } N LL 0— Ln X Ln Was Ln +'+ O Q > 0 O N } 'w � LL �✓ 3 N QLL } Ln 3 ^/ m 0 O v mLL a N O LL LL A.—i Q O X W • _ a) LL ` Q Q4-a C\J o a m rcu �a J n LL VJ C.M J W \� W LL rl bA U •— � W E m �o v aLU U) U a) 0) H QV) W O O O O O O O 1h LL n, C O O O O O O O J 41 0 pO pO O O O O O ? W O O O 00 0% 1 N eel eel eel ih ih ih ih r n (n O V J L O V W Vv ' ) 1 n W f, V b� O W F,71 ■ Las Cruces Utilities FY20 Second Quarter Budget and Performance Review FY20 2QT Utility Operating Lines of Business Percent of Budget 100.00% 90.00% 80.00% 70.00% 60.00% 50.00% 40.00% 30.00% F1 20.00% 10.00% 0.00% a Gas Water Wastewater Solid Waste =Personnel Operating IIIIIIIIIIIIIIIIIIIIevenues Budget Par Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review CITY OF LAS CRUCES PEAK Highlights: 1.LOB: Office of the Director a. By January 1, 2020, 60% Las Cruces Utilities Department vacancies will be filled within six weeks of date of request. Currently, only 2% of vacancies are filled in less than 6 weeks. Currently, it takes an average of 27 weeks to fill an LCU position, with some highly specialized positions open for longer. b. By July 2019, a Human Resources function within the Las Cruces Utilities Department will be established. 60% complete. We have budgeted for the position in FY20 and remitted a PAQ to HR on 10/22/2019 and again on 1/7/2020. c. Beginning in 2019, 100% department employees will know what is expected of them and how they align and contribute to the goals of the department as evidenced by their annual work plans and performance conversations being aligned with the Department Strategic Business Plan. 95% of department employees have been trained and understand what is expected of them within the SBP. We have created a course in the new LMS system to ensure 100% receive this training and we can track completion in perpetuity. This course will become a part of our new-employee curriculum. d. By July 2019, 25% vehicles for regular Fleet preventative maintenance will be completed within three days. 93% of fleet vehicle preventive maintenance has been completed within 3 days. Program Budgets vs Actuals: Program Name: Administration Financials: 1. Salary expenditures are at 39.3%, which is 10.7% below budget. This is due to vacancies in the HR Coordinator (0%), OAS and Administrative Assistant positions; the latter of the two were filled in Q2. Also, the AUD did not start until the end of July. 2. Operating expenses are at 41.8%, which is 8.2% below budget due to: • We have not placed a supply replenishment orders in Q1 or Q2 and will realize those expenditures in later quarters. • Minor equipment expenses will occur FY20 Q2 and Q3. • No travel occurred in FY20 Q1 or Q2. • Technical services expenditures are well below budget but will increase as we move forward with Board review of rates, bond or debt reviews and the EAM project in the second half of the year. 3. Shared Services is primarily funded by transfers from Gas, Water, Wastewater, and Solid Waste via monthly entries at 1/12. 1 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review Narrative: Filling vacancies is one of our foremost and primary goals. We have changed the internal hiring process to better communicate with HR, to identify multiple candidates to fill positions in order to expedite offers and will be introducing better internal operational processes for recruitment, selection and document completion. We've also requested reclassification of 6 positions and will be reviewing all long-term vacancies for reclassification. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. 2 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review CITY OF LAS CRUCES PEAK Highlights: 2.LOB: Natural Gas Operations & Maintenance a. # Natural gas mainline extensions completed. - 1 completed b. 2% inaccurate marking from locating request. - 0.014% c. 90% Locating and Mapping work orders completed within 5 business days. - 99.25% d. 0.5% Natural gas system above ground line leaks resulting in injury or property damage. - 0.0% Program Budgets vs Actuals: Program Name: Natural Gas Administration Financials: 1. Salary expenditures are at 43.9%, which is 6.1% below budget due to vacancies. 2. Operating expenses are at 26.9%, which is 23.1% below budget due to: • C&M Regulatory Pipeline Consultants agreement was approved by the Utility Board in FY20 Q1, funds were not expedited during FY20 Q2. Consultant expenses for MCcarter & English were minimal for FY20 Q1 & Q2. 3. FY20 Q2 Revenues were down at $7.612M compared to $8.226M from last year, which is at 33.4% and 16.6% below budget: • Sales Volume: FY20 Q2 = 1,255,046 Dekatherm (DKTH). FY19 Q2 =1,250,865 DKTH. • Average Cost of Gas: FY20 Q2 = $2.43. FY19 Q2 = $3.36. Narrative: Main line extension process and projects have progressed in a manner that aligns with PEAK. Main concerns are vacancies and staffing to perform the additional work due to regulatory changes. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Natural Gas Construction & Maintenance Financials: 1. Salary expenditures are at 32.9%, which is 17.1% below budget due to vacancies. 2. Operating expenses are at 44.3%, which is 5.7% below budget due to: • Shop Supplies and Materials, electro fusion machines to be ordered in FY20 Q3. Narrative: Completed Main line extension and service for Luke Ranch Estates. 3 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review Capital Outlay & Equipment 1. One (1) FY19 F-550 Crew Truck. Program Name: Natural Gas Pressure & Service Financials: 1. Salary expenditures are at 38.1%, which is 11.9% below budget due to vacancies. 2. Operating expenses are at 36.8%, which is 13.2% below budget due to: • High vacancy has impacted number of vehicles in use therefore less fuel cost, vehicle repairs and maintenance, shop supplies, and uniforms. • GPS units to be ordered in FY20 Q3 for Gas Service Technicians. Narrative: Processes, workflow, and training completed in preparation for the Gas Meter Change Out Project. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Natural Gas Corrosion Financials: 1. Salary expenditures are at 41.0%, which is 9.0% below budget due to vacancies. 2. Operating expenses are at 21.4%, which is 28.6% below budget due to: • Recent purchase of new vehicles plus high vacancy has impacted number of vehicles in use therefore less fuel cost, and repair cost in vehicle repair and maintenance. Narrative: Vacancies, Crew Leader, and Leak Surveyor - due to additional vacancies, Corrosion is not able to perform efficiently. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Natural Gas Locating & Mapping Financials: 1. Salary expenditures are at 46.0%, which is 4.0% below budget due to vacancies. 2. Operating expenses are at 30.6%, which is 19.4% below budget due to: • Minor equipment has been ordered and will be invoiced in FY20 Q3. Narrative: All three PEAK results were met for the FY20 Q2, 5% customers who have service interruptions, 2% inaccurate marking from locate request, and 90% 4 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review L&M program work orders completed within 5 business days. Currently one vacancy, Gas Line Locator that is being reclassified to a Senior Gas Line Locator. Supported Location and potholing for the Valley Drive Project, University/I-25 interchange Karen/Richard/Jody, and Del-Rey High Pressure Main Line Extension. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. 5 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review CITY OF LAS CRUCES PEAK Highlights: 3.LOB: Water Operations & Maintenance a. By February 2019, the Utilities Board will review an action plan to implement the 40-year water plan over the next five years through 2023. - Completed b. 10% of Water customers who experience an unplanned interruption of service of 90 minutes or longer. - 6.3% c. By July 1, 2019, replacement and rehabilitation of critical water well infrastructure will begin. - Completed and ongoing d. d. 80% of all new meter requests will be completed within two business days. - 100% Program Budgets vs Actuals: Program Name: Water Administration Financials: 1. Salary expenditures are at 36.4%, which is 13.6% below budget due to vacancies. 2. Operating expenses are at 48.9% which is 1.1% below budget. 3. FY20 Q2 Revenues were up at $10.542M compared to $9.117M from last year, which is at 57.2% and 7.2% above budget: • Phase II of the new rates became effective December, 2019. • Sales Volume: FY20 Q2 = 3,364 MG. FY19 Q2 = 3,305 MG. Narrative: Working with Human Resources on an expedited hiring process for vacant operational positions. First Intern completed academic requirements for Associates Degree in Water Technology. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Water Line Maintenance Financials: 1. Salary expenditures are at 40.7%, which is 9.3% below budget due to vacancies. 2. Operating expenses are at 47.9%, which is 2.1% below budget. Narrative: Even though we are meeting the meter requests, we have continued vacancies which increase the delay times related to responding to service request and line leak replacements. 6 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Water Production Financials: 1. Salary expenditures are at 49.1%, which is 0.9% below budget. 2. Operating expenses are at 49.9%, which is 0.1% below budget. Narrative: Well 63 pump and motor were replaced with no adverse effect to the West Mesa Industrial Park. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Water Meters, Valves & Hydrants Financials: 1. Salary expenditures are at 45.5%, which is 4.5% below budget due to vacancies. 2. Operating expenses are at 38.9%, which is 11.1% below budget due to: • Purchased Services General has not had to be used. Narrative: Continued vacancies increase the delay in the program's ability to inspect hydrants and valves. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. 7 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review CITY OF LAS CRUCES PEAK Highlights: 4. LOB: Wastewater Operations & Maintenance a. 97% of gallons of recycled water resources that are safe for human contact. - 100% b. b. 97% of gallons of reclaimed water that are safe for human contact. - 100%By July 1, 2019, replacement and rehabilitation of critical water well infrastructure will begin. - Completed and ongoing Program Budgets vs Actuals: Program Name: Wastewater Administration Financials: 1. Salary expenditures are at 43.4%, which is 6.6% below budget. 2. Operating expenses are at 46.6%, which is 3.4% below budget due to: • Lower operating costs for the FY20 Q2. 3. FY20 Q2 Revenues were up at $6.482M compared to $5.709M from last year, which is at 46.0% and 4.0% below budget. • Sales Volume: FY20 Q2 = 1,813 MG. FY19 Q2 = 1,891 MG. Narrative: Administration is current in record keeping for PEAK. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Wastewater Line Maintenance Financials: 1. Salary expenditures are at 36.3%, which is 13.7% below budget due to vacancies. 2. Operating expenses are at 60.5%, which is 10.5% above budget due to: • Higher vehicle repairs costs than expected. Narrative: Replaced blocked sewer line on Griggs between Water Street and Alameda. Capital Outlay & Equipment: 1. One (1) FY19 F-550 Crew Truck with flatbed and crane. Program Name: Jacob Hands Wastewater Treatment Facility Financials: 1. Salary expenditures are at 36.4%, which is 13.6% below budget due to vacancies. 2. Operating expenses are at 51.2%, which is 1.2% above budget. 8 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review Narrative: Digestor #1 Heat Exchanger Project is 100% complete and in service. Source #1 project progressing along and on schedule. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: East Mesa Wastewater Reclamation Facility Financials: 1. Salary expenditures are at 45.6%, which is 4.4% below budget. 2. Operating expenses are at 40.9%, which is 9.1% below budget due to: • Maintenance and Repairs budget has been lightly used. Narrative: The East Mesa Reclamation Facility has replaced disinfection lamps. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: West Mesa Industrial Park Wastewater Facility Financials: 1. Salary expenditures are at 46.8%, which is 3.2% below budget. 2. Operating expenses are at 40.0%, which is 10.0% below budget due to: • Minimal equipment repairs have been scheduled or completed this quarter. A complete rebuild for aeration blower #3 is needed, but not enough budget is available. Funds requested in FY21 budget. Narrative: A concern is the lagoons are in need of thorough and complete maintenance. Solids removal from the lagoons is needed. Air diffuser inspections and leak repairs are required and need to be scheduled and budgeted for. Funds requested in FY21 budget. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. 9 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review CITY OF LAS CRUCES PEAK Highlights: 5.LOB: Solid Waste Collections a. Roll off containers delivered, emptied, returned, and removed within one business day. - 99% b. 97% Solid Waste Equipment available on a daily basis. - 163% c. 2% Residential container pickups not serviced. - 3.63% Program Budgets vs Actuals: Program Name: Solid Waste Administration Financials: 1. Salary expenditures are at 43.5%, which is 6.5% below budget due to vacancies. 2. Operating expenses are at 52.5%, which is 2.5% above budget. 3. FY20 Q2 Revenues were up at $7.574M compared to $7.360M from last year, which is at 53.0% and 3.0% above budget: • Tonnage: FY20 Q2 = 37,750.80 tons. FY19 Q2 = 37,562.41 tons. Narrative: Specification sheets for our budgeted vehicle replacements have been provided to Fleet Services along with quotes. Awaiting procurement of vehicles. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Solid Waste Residential Collections Financials: 1. Salary expenditures are at 47.2%, which is 2.8% below budget. 2. Operating expenses are at 44.0%, which is 6.0% below budget due to: • Purchased Services and Maintenance and Service Agreements line items have not been utilized at budgeted levels. Narrative: Routeware has helped us identify and correct billing discrepancies on levels of service some customers were receiving vs. what they are actually paying for. Capital Outlay & Equipment: 1. One (1) FY19 Forklift. Program Name: Solid Waste Commercial Collections Financials: 1. Salary expenditures are at 47.2%, which is 2.8% below budget. 2. Operating expenses are at 49.6%, which is 0.4% below budget. 10 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review Narrative: Commercial Collections is seeing continued growth in our roll-off side of our business as we have serviced 5% more roll-off containers over the same period last year. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Solid Waste Fleet Financials: 1. Salary expenditures are at 44.7%, which is 5.3% below budget due to vacancies. 2. Operating expenses are at 34.4%, which is 15.6% below budget due to: • Minimal purchases for shop supplies and materials have been made this fiscal year. Narrative: We have set a pilot program in place in conjunction with Solid Waste Fleet, selected drivers, and our tire vendor to monitor tire wear utilizing specific equipment, tires, and documented observation to determine the best path moving forward to increase the life of tires on solid waste route trucks. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. 11 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review CITY OF LAS CRUCES PEAK Highlights: 6.LOB: Utilities Environmental a. Water Conservation: 5% change of water waste violations from 535 to 508 (annually) - currently at 10.0% (51 violations). b. Solid Waste Green Waste, Compost, and Recycling: By 2020, the Las Cruces Utilities Department will increase its intake of green waste tonnage by 7% from 2,800 tons to 3,000 tons. Result: FY19 thru Q2 we took in 1,427 tons; FY20 thru Q2 we have taken in 1,800 tons. This is an increase of 26% over the same time last fiscal year. Program Budgets vs Actuals: Program Name: Water Conservation Financials: 1. Salary expenditures are at 48.0%, which is 2.0% below budget. 2. Operating expenses are at 38.5%, which is 11.5% below budget due to: • Water Festival budget will not be spent until FY20 Q4. Narrative: A concern is the use of temporary employees (to address water waste violations and monitoring) which is sporadic because they leave for other permanent employment opportunities. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Solid Waste Green Waste, Compost, and Recycling Financials: 1. Salary expenditures are at 49.1%, which is 0.9% below budget. 2. Operating expenses are at 48.5%, which is 1.5% below budget. Narrative: Our Green Waste intake is increasing as we have taken in 26% more tonnage than the same time last fiscal year. However, we have not reached our goals of increasing compost given back to the community. We have only given back 5 tons out of the 1,500 ton goal. This is due to the composting process not reaching optimal temperatures for the compost to be ready for release. Capital Outlay & Equipment: 1. One (1) FY19 Peterbilt Grappler Truck. 12 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review Program Name: Griggs Walnut Financials: 1. Salary expenditures are at 45.3%, which is 4.7% below. 2. Operating expenses are at 11.4%, which is 38.6% below budget due to: • Legal Services and Professional/Technical Services below budget due to delay in billings. Narrative: Treatment system continues to treat as designed. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. 13 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review CITY OF LAS CRUCES PEAK Highlights: 7. LOB: Customer Enaaaement a. 90% of utilities customer walk-in requests will be processed to completion. - 99% b. 85% Utilities Emergency calls will be dispatched within a 10-minute timeframe. - 100% c. 95% accurate meter readings. - 99% d. d. 90% of accurate and timely bills sent out. - 99% e. 38,067 Annual Customer Surveys were mailed in Utilities bills and 10,120 were sent to our e-billing customers via email. Program Budgets vs Actuals: Program Name: Customer Outreach Financials: 1. Salary expenditures are at 43.2%, which is 6.8% below budget due to Customer Service Supervisor vacancy. 2. Operating expenses are at 26.2%, which is 23.8% below budget due to: • Lower estimated expenses in Q1. Higher billings anticipated in the coming months. • Advertising: Resolution to award public outreach contract will be taken to LCU Board at the February 13, 2020 meeting for $100K. • Most of Water Conservation expenses will hit in FY20 Q4. Narrative: We had 25 articles published in the Sun-News and Bulletin. There were a total of 773 Customer Surveys received in FY20 Q2. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Customer Central Financials: 1. Salary expenditures are at 38.1%, which is 11.9% below budget due to vacancies. 2. Operating expenses are at 57.6%, which is 7.6% above budget due to: • Temporary employees that are being utilized. Narrative: An accomplishment is the creation of the Call Center within Customer Central which will be finalized with the hiring of personnel and purchase of equipment in FY20 Q3. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. 14 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review Program Name: Utilities Billing and Receivables Financials: 1. Salary expenditures are at 38.7%, which is 11.3% below budget due to vacancies. 2. Operating expenses are at 45.7%, which is 4.3% below budget. Narrative: An accomplishment is the use of door hangers to notify customers of disconnection, this has decreased the actual number of customers being disconnected. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: New Connections Financials: 1. Salary expenditures are at 48.2%, which is 1.8% below budget. 2. Operating expenses are at 47.5%, which is 2.5% below budget. Narrative: New Service Technicians have seen an increase in field work and have been able to assist all customer requests for utility hook ups. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Meter Reading Financials: 1. Salary expenditures are at 40.1%, which is 9.9% below budget due to vacancies. 2. Operating expenses are at 25.4%, which is 24.6% below budget due to: • Uniform invoices pending payment. Narrative: We will continue to do drive by meter reads until the network is fully covered. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Utilities Dispatch Financials: 1. Salary expenditures are at 48.6%, which is 1.4% below budget. 2. Operating expenses are at 80.9%, which is 30.9% above budget due to: • New dispatch consoles and equipment. 15 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review Narrative: With recent water leaks, Dispatchers have received many phone calls and have been able to assist the public and dispatch appropriate Program personnel. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Field Services Financials: 1. Salary expenditures are at 38.8%, which is 11.2% below budget due to vacancies. 2. Operating expenses are at 24.0%, which is 26.0% below budget due to: • Have not needed to use the contracted plumbers as much due to door hangers. Narrative: The physical delivery of door hangers to assist the lowered amount of customers being shut-off. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. 16 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review CITY OF LAS CRUCES PEAK Highlights: 8.LOB: Revenue & Financial Reuortina a. 90% Deliveries of materials and supplies to job site within one hour from the request being placed. - 91% b. 30% Budget corrections required. - 36% c. 85% program managers who get the financial reports they need to make a decision on time. - 100% d. 80% of utilities buildings repairs completed within 30 days from date requested. - 77% Program Budgets vs Actuals: Program Name: Rate & Economic Analysis Financials: 1. Salary expenditures are at 41.0%, which is 9.0% below budget due to vacancies. 2. Operating expenses are at 45.0%, which is 5.0% below budget due to: • Software that has yet to be purchased for staff. Narrative: Solid Waste Rate Review is in its final stages. Gas Rate Review data is being compiled. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Utilities Warehouse Financials: 1. Salary expenditures are at 47.3%, which is 2.7% below budget. 2. Operating expenses are at 34.4%, which is 15.6% below budget due to: • The purchase of the barcoding system and its components have not been ordered yet. Narrative: Completion of reclassification of warehouse positions is needed. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Utilities Building Administration Financials: 1. Salary expenditures are at 46.9%, which is 3.1% below budget. 2. Operating expenses are at 42.4%, which is 7.6% below budget due to: • Supplies invoices pending payment. 17 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review Narrative: An accomplishment is several improvements to the building which include upgrade of the sewer system to all outlying buildings, and HVAC unit replacements. A concern is not enough money to finish all building improvements. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Utilities Business Services Administration Financials: 1. Salary expenditures are at 57.3%, which is 7.3% above budget. 2. Operating expenses are at 51.6%, which is 1.6% above budget. Narrative: An accomplishment is preparing quarterly budget reports using the new org structure. It should be noted that significant staff resources are expended to report PEAK measures. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. 18 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review CITY OF LAS CRUCES PEAK Highlights: 9. LOB: Reaulatory Compliance & Trainina a. Utilities Regulatory Compliance: 90% of Inspections that do not result in findings or violations - currently at 100% b. Water Quality Lab: Minimum of 2,880 samples and 10,410 tests (13,290 combined) will be completed to ensure water is 100% safe - 13,722 (combined) c. Industrial Pollution Prevention: By 2020, all restaurant businesses that fail their inspection due to fat, oil, and grease disposal will be reduced by 50% (from 52 to 26) - currently reduced by 42% (currently at 30) Program Budgets vs Actuals: Program Name: Regulatory & Compliance Financials: 1. Salary expenditures are at 45.3%, which is 4.7% below budget. 2. Operating expenses are at 37.0%, which is 23.0% below budget due to: • Membership and Dues which are renewed in the FY20 Q3. Narrative: Operating budget is at 37.0% due to Membership and Dues to be utilized in the FY20 Q3. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Water Quality Laboratory Financials: 1. Salary expenditures are at 44.5% (Water) and 44.7% (Wastewater), which are 5.5% (Water) and 5.3% (Wastewater) below budget. 2. Operating (Water) expenses are at 28.4%, which is 21.6% below budget due to: • Reduced Private/Residential special sampling and analyses requests. • Awaiting scheduled sampling/analyses programs, certification/training and audit. 3. Operating (Wastewater) expenses are at 49.5%, which is 0.5% below budget. Narrative: Currently in process of Drinking Water Recertification of Lab #NM9415 for new laboratory facility designated to Drinking Water, RM#132, 2845 W. Amador Ave. 19 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Industrial Pollution Prevention Financials: 1. Salary expenditures (combined Water and Wastewater) are at 49.0%, which is 1.0% below budget. 2. Operating expenses (combined Water and Wastewater) are at 41.9%, which is 8.1% below budget due to: • Membership and Dues are not due until FY20 Q3, and Maintenance and Repairs are not due until the FY20 Q4. Narrative: A concern is that existing hydrogen sulfide meters (which will soon be obsolete) will need to be replaced no later than the V quarter due to the incompatibility between their existing software and Windows 10 Version 1903 which IT was unable to remedy, as requested during a mid-year adjustment. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: Foothills Landfill Closure Post-Closure Financials: 1. Salary expenditures are at 45.1%, which is 4.9% below budget. 2. Operating expenses are at 2.2%, which is 47.8% below budget due to: • Sampling and testing to be completed later this fiscal year. Narrative: First semi-annual long-term ground water testing has been completed as part of long-term monitoring of the Foothills Landfill Closure Post-Closure. Three Resolutions authorizing funds for the CLC Lohman Property Cleanup, approved by the Las Cruces Utilities Board at the December 2019 meeting - Environmental Consulting Contract (Parkhill, Smith & Cooper), Asbestos Abatement Contractor (KEERS), Landfill Equipment Rental Contract (Wagner). Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. 20 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review Program Name: Utilities Training Financials: 1. Salary expenditures are at 45.6%, which is 4.4% below budget. 2. Operating expenses are at 22.4%, which is 27.6% below budget due to: • Training usually done when the classes are provided and when certifications are due. Tracking sheets indicate trainings forth coming which will bring budget expenditures current. Narrative: LMS recently launched, continuing to develop strategies to better track training events (future and completed) in LMS. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. 21 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review CITY OF LAS CRUCES PEAK Highlights: 10. LOB: Utilities Support & Proiect Manaaement a. 90% Developer plan reviews completed within 10 days. - 91% b. 90% Projects completed on time and within budget. - 100% c. 95% Projects managed by Las Cruces Utilities, which do not experience failure due to design or construction within the first year of acceptance. - 100% d. 90% System alarms detected and mitigated before customer experience a service interruption. - 100% Program Budgets vs Actuals: Program Name: Technical Support Financials: 1. Salary expenditures are at 46.2%, which is 3.8% below budget. 2. Operating expenses are at 54.6%, which is 4.6% above budget due to: • Due to purchase of InoVize info-sewer software. Narrative: Midyear Budget adjustment was completed for software purchases. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. Program Name: SCADA Financials: 1. Salary expenditures are at 48.2%, which is 1.8% below budget. 2. Operating expenses are at 62.4%, which is 12.4% above budget due to: • Annual Emerson Software Support Contract ($21,575) paid for on August 13, 2019. Narrative: Installed new master and repeater radios at A-Mountain and West Mesa Repeater sites. Installed dual communications data concentrators and are now capable of monitoring a total of 254 remote sites. Capital Outlay & Equipment: 1. No vehicles or equipment expenditures during FY20 Q2. 22 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review Department Vacancies Total vacancies = 46: 0. Reclassifications Reclassifying has five (5) vacancies: 1. Five (5) positions were reviewed for reclassification to other programs. Those requests are sent in FY20 Q3. 1. LOB: Office of the Director Administration has one (1) vacancy: 1. One (1) Human Resources Coordinator, working with HR on PAQ. 2. LOB: Natural Gas Operations and Maintenance Total Vacancies =11: Natural Gas Administration has one (2) vacancies: 1. One (1) Gas Operation & Compliance Coordinator, Re-titled to Gas Systems Inspector Supervisor, Short PAQ submitted to HR. 2. One (1) Office Assistant Senior. Natural Gas Construction & Maintenance has four (4) vacancies: 1. One (1) Supervisor, Construction & Maintenance, PAQ submitted. 2. Two (2) Gas Service Worker, second attempt. 3. One (1) Senior Gas System Welder, HR conducting filter. Natural Gas Pressure & Service has two (2) vacancies: 1. One (1) Assistant Supervisor, PAQ Submitted to HR. 2. One (1) Gas Services Technician, Reposted Position open till filled. Natural Gas Corrosion has two (2) vacancies: 1. One (1) Senior Corrosion Technician, Reclassed to Gas Leak Surveyor, HR to filter applicants. 2. One (1) Crew Leader-Gas Cathodic Protection, HR to filter applicants. Natural Gas Locating & Mapping has one (1) vacancy: 1. One (1) Gas Locator, position is process of Reclassification, PAQ submitted to H R. 3. LOB: Water Operations and Maintenance Total Vacancies =13: Water Administration has one (1) vacancy: 1. One (1) Field Customer Service Representative, Hiring in Workflow. Water Line Maintenance has four (4) vacancies: 1. One (1) Water Distribution Crew Leaders, continuous posting. 2. Two (2) Water Resources Serviceman, continuous posting. 3. One (1) Water Resources Serviceman, request to reclassify underway for Assistant Supervisor position. Water Production has zero (0) vacancies. Water Meter, Valves & Hydrants has eight (8) vacancies: 1. Two (2) Crew Leaders, hired. 2. Two (2) Heavy Equipment Operators, one hired. 23 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review 3. Two (2) Senior Water Maintenance Workers, one hired. 4. One (1) Meter Mechanic, request to reclassify underway for Assistant Supervisor position. 5. One (1) Water System Line Locator, Hiring in Workflow. 4. LOB: Wastewater Operations and Maintenance Total Vacancies = 6: Wastewater Administration has zero (0) vacancies. Wastewater Line Maintenance has four (4) vacancies: 1. Two (2) WW Collection Workers, HR to give permission to begin interviews. 2. One (1) Maintenance Mechanic, applicants have been graded. 3. One (1) Lift Station Operator, requires reclassification. Jacob Hands Wastewater Treatment Facility has two (2) vacancies: 1. One (1) Assistant Plant Manager, PAQ submitted to HR, waiting for consultant. 2. One (1) WW Maintenance Worker, position has been hired, will start January 6, 2020. East Mesa Wastewater Reclamation Facility has zero (0) vacancies. West Mesa Industrial Park Wastewater Treatment Facility has zero (0) vacancies. 5. LOB: Solid Waste Collections Total Vacancies = 2: Solid Waste Administration has zero (0) vacancies. Solid Waste Residential Collections has one (1) vacancy: 1. One (1) Solid Waste Laborer, job re-posted. Solid Waste Commercial Collections has zero (0) vacancies. Solid Waste Fleet has one (1) vacancy: 1. One (1) Parts Supply Clerk, using existing hiring pool. 6. LOB: Utilities Environmental Total Vacancies =0: Water Conservation has zero (0) vacancies. Solid Waste Green Waste, Compost, and Recycling, has zero (0) vacancies. Griggs Walnut has zero (0) vacancies. 7. LOB: Customer Engagement Total Vacancies =6: Customer Outreach has zero (0) vacancies. Customer Central has two (2) vacancies: 1. One (1) Customer Service Representatives vacant, waiting on hiring of new supervisor to start hiring process. 2. One (1) Customer Service Supervisor, position has been hired, start date is January 21, 2020. 24 Department: Las Cruces Utilities Meeting Date: February 5, 2020 FY20 Second Quarter Budget and Performance Review Utilities Billing and Receivables has two (2) vacancies: 1. One (1) Senior Receivables Representative, waiting for HR to release Applicants, closing date for position was December 23, 2019. 2. One (1) Billing Technician, waiting for HR to approve interview applicants, closing date for position was October 2, 2019. New Connections has zero (0) vacancies. Meter Reading has one (1) vacancy: 1. One (1) Contract Meter Reader, received approval to fill position, next step is to enter into NeoGov. Utilities Dispatch zero (0) vacancies. Field Services has one (1) vacancy: 1. One (1) Field Service Technician positions vacant, posted until filled. 8. LOB: Revenue & Financial Reporting Total Vacancies = 0: Rate & Economic Analysis has zero (0) vacancies. Utilities Warehouse has zero (0) vacancies. Utilities Building Administration has zero (0) vacancies. Utilities Business Services Administration has zero (0) vacancies. 9. LOB: Regulatory Compliance & Training Total Vacancies = 0: Regulatory & Compliance has zero (0) vacancies. Water Quality Laboratory has zero (0) vacancies. Industrial Pollution Prevention has zero (0) vacancies. Foothills Landfill Closure Post-Closure has zero (0) vacancies. Utilities Training has zero (0) vacancies. 10. LOB: Utilities Support & Project Management Total Vacancies =2: Technical Support has two (2) vacancies. 1. One (1) Engineering Technician, interviews pending. 2. One (1) Administrative Assistant, interviews pending. SCADA has zero (0) vacancies. 25