Loading...
FY20 Q3 Board Report for May 14 2020 Final with CM Budget Reports as Backup VJ W c '� O �/ �+ W c/) W U) o a O a� (.) -0 a) (D U cy) W 3 a) c J - U . o m N �o CZ O >- :3 J m L.L m I O ++ f0 � to3 V) C6 0 N N N I u�1 w W N Ln oo 4 } m m , I LL NHH 00 m LL ra I L Q X = mo00N0 m W wH000 � m i � 00 LL c v � 3 /'� C U) a) > N N d o N 41 3 o 0 't H 00 LL LL n, 3 O = N W H �N > cm-I � f N N Vn Ix ro 'tM m ,V � LLOVc c � LL LL cn L J � +'' O O O O O O O O O O O O O !/h 41 V) v 3 * O O O O O O - M4v30 o 0 0 0 0 0 3 4-1 °O °O °O °O °O °O M c 3 v) O u01 11 M N 0 'a o 0 } o ID Ln L� LL O ID ID �^/� M1 l0ra �f0 7 ID rs H 0 Q ^U) Q m o 0 W 0 0 v, 0 0 v LL ^� H N VI W 7 N 0 � LL > to x v XQLU W G 3 m v 'a ++ N 0 � by N M1 N v O �/� O�CmLL NN N ^v') 00 LL W _ N Ln �o W > n QLL }>' uim Q ^ W 00 v > }+ (C) p�5( m3LL J NN b�A J 00 '0 � O I ECV z � o 4- 0 LU a 3 O O O O O O LL Q 0 0 0 0 00 Uvl , Q O O O O O W O O O O O n� n� Ln C Ln C Ln V Ln H \ \ O } �' a LL V♦ 11 0 f0 3 m 0 0 N N ^♦ vi } ^W Ln � v LL vi l.L n n c X 0N � W000 0. wQ LL } O W bA 41 7 TS 0 m N W U) ON NIA ,� 0 a) 3LL � � } ^ U. C: W 001 co 00 0> U a) 3 0 1 Q L.L Q LL } rI 0 0 3 OvLL A--+ a Ln P C O J LL � �0 41 � � M 0 � v N � � ° 3 O z ♦—0 Q m �♦—0CY) W 0) 0) 0 0 0 0 0 0 0 0 0 0 0 H oG 0 0 0 0 0 0 0 0 0 0 +n } w 0 0 0 0 0 0 0 0 0 0 LL 00 0 0 0 0 0 0 0 0 0 0 1 > a 0 0 0 0 0 0 0 0 0 0 a, x 0 0 0 0 0 0 0 0 0 0 (� w 0 OG �0 i fV 0 00% W0% 1% N `u 0 f0 i N eel eel eel eel eel 0 0 0 0 M 0 0 Ln H H 0 '0 0 0 LL 4, l0 P 3 0 C 0 N N ID H LL H 1 QLL } Q� 0 m n 001 " N v�i b�A N p� � � W O y 7 LL Q N } f N � m 00 LL Ln O CY) 3 � U � aLL } � oE cu � o J C � a) 2 v1 r'I Ln 0) qf VJ O 0) ID F 00 m a) 0 �+ U) LU m " v cn Q ^♦ LU3 W 0 0 0 0 0 0 0 0 0 0 0 LL 4—I ^` vi > GJ 0 0 0 0 0 0 0 0 , 3 0 W 0 0 0 0 0 0 0 0 cu0 0 0 0 0 0 0 0 �J X 0 i lG 'i N G w w I N 0 0 V1 V1 V1 V1 0 0 0 0 W Ln 0 -0 0 0 } o IA 0 LL 0 v 0 0 0 Q > Nh .. 0 N } � LL N 00)o C ♦^ Q LL W v F LO v m 0 j 0 ri ri v N > 7 } Nei 0 0 0) N LL 4~ _ N N 0 Co ^C � Q LL F W � 2- E cu J j } J O N v LL Q) 0 +� N M 4-0 4-0�^ Q O LL � a � ♦"� 0 v U) N W � M v u Q IA 1A 01 7 0 0 0 0 0 0 0 0 ih } 0 = 0 0 0 0 0 0 0 0 LL ^, Q. 0 0 0 0 0 0 0 0 V^J J Q 0 W 0 0% N O x 0 co w LLM M o .0a } a\° LL 7 I m � On � 00 7 Ln Q > m o C� } O is LL m 41 } gym n QLL } ^ •� 1 na 3 m N v o41 N 3LLN O O O " } 4 N LL C N X m E 3 n' 1 } G o ,6 Q W i Q LL } L LL ♦^ � uj U O 3 LL , Ln IA gym V♦ W OTC W � G1 O O O O O O O O } W C O O O O O O OCL LL ^ O O O O O O O W X � li N% O 00% tD% 11 N V) LU L O V W Vv ' ) 1 n W f, V b� O W ■ Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review CITY OF LAS CRUCES PEAK Highlights: 1. LO6: 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. As of quarter-end, it takes an average of 38 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. Check-in on 3/27/2020 resulted in no change. 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 and launched in the Y6 Quarter. At the end of Q3, 9% had completed the LMS course. d. By July 2019, 25% vehicles for regular Fleet preventative maintenance will be completed within three days. - 100% 2. LO6: Natural Gas Operations & Maintenance a. # Natural gas mainline extensions completed. - 2 completed b. 2% inaccurate marking from locating request. - 0.006% c. 90% Locating and Mapping work orders completed within 5 business days. - 97.25% d. 0.5% Natural gas system above ground line leaks resulting in injury or property damage. - 0.0% 3. LO6: 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. 80% of all new meter requests will be completed within two business days. - 100% 1 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review 4. LOB: Wastewater Operations & Maintenance a. 97% of gallons of recycled water resources that are safe for human contact. - 100% b. 97% of gallons of reclaimed water that are safe for human contact. - 100% c. By July 1, 2019, replacement and rehabilitation of critical water well infrastructure will begin. - Completed and ongoing 5. LOB: Solid Waste Collections a. 90% Residential containers repaired within one business day. - 94% b. 97% Solid Waste Equipment available on a daily basis. - 160.5% c. 2% Residential container pickups not serviced. - 0.28% 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 Q3 we took in 2,267 tons; FY20 thru Q3 we have taken in 2,613 tons. This is an increase of 15% over the same time last fiscal year. 7. LOB: Customer Ennaciement 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. - 100% d. 90% of accurate and timely bills sent out. - 98% 8. LOB: Revenue & Financial Reporting a. 90% Deliveries of materials and supplies to job site within one hour from the request being placed. - 87% b. 30% Budget corrections required. - 45% 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. - 47% 9. LOB: Reciulatory Compliance & Traininci a. Utilities Regulatory Compliance: 90% of Inspections that do not result in findings or violations. - 80% 2 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review 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 - 15,445 (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 11.5% (currently at 46) 10. LOB: Utilities Support & Proiect Management a. 90% Developer plan reviews completed within 10 days. - 96% 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: Las Cruces Utilities Department: TOTAL UTILITIES Percent Revised Budget YTDActu����� Available Used Revenues ($70,411,278.00) ($48,831,627.34) $0.00 ($21,579,650.66) 69.4% TOTAL REVENUES ($70,411,278.00) ($48,831,627.34) $0.00 ($21,579,650.66) 69.4% Personnel $19,978,921.00 $12,830,373.83 $0.00 $7,148,547.17 64.2% Operating $55,932,169.00 $33,645,952.95 $4,486,511.79 $22,286,216.05 60.2% Capital $517,650.00 $79,028.84 $57,617.08 $438,621.16 15.3% TOTAL EXPENDITURES $76,428,740.00 $46,555,355.62 $4,544,128.87 $29,873,384.38 60.9% • Shared Services is primarily funded by transfers from Gas, Water, Wastewater, and Solid Waste via monthly entries at 1/12. 3 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review MIKAN Program Name:ADM INISTRATION-UT q Percent Category Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $687,509.00 $409,696.80 $0.00 $277,812.20 59.6% Operating $2,316,621.00 $1,447,520.67 $162,826.34 $869,100.33 62.5% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $3,004,130.00 $1,857,217.47 $162,826.34 $1,146,912.53 61.8•% • Salary expenditures are at 59.6%, which is 15.4% below budget. This is due to vacancies, positions filled later in the fiscal year and lower health insurance costs. • Operating expenses are at 62.5%, which is 12.5% below budget due to: • We have not encumbered $60K in our software expenses for Tyler Executime or EAM and expect to do so in Q4. • Only 10% of the advertising budget has been expended. • Engineering services and 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. • Travel has been suspended due to COVID-19 and expenditures cancelled. LINE OF BUSINESS: NATURAL GAS O & M .CategoryPercent Revenues ($22,793,594.00) ($13,632,157.51) $0.00 ($9,161,436.49) 59.8% TOTAL REVENUES ($22,793,594.00) ($13,632,157.51) $0.00 ($9,161,436.49) 59.8% Personnel $4,229,127.00 $2,537,395.25 $0.00 $1,691,731.75 60.0% Operating $17,902,969.00 $8,915,335.24 $499,643.30 $8,987,633.76 49.8% Capital $161,000.00 $17,240.00 $43,075.00 $143,760.00 - TOTAL EXPENDITURES $22,293,096.00 $11,469,970.49 $542,718.30 $10,823,125.51 51.5% • FY20 Q3 Revenues were down at $13.632M compared to $15.713M from last year, which is at 59.8% and 15.2% below budget: • Sales Volume: FY20 Q3 = 2,773,614 Dekatherm (DKTH). FY19 Q3 =2,733,845 DKTH. • Average Cost of Gas: FY20 Q3 = $1.38. FY19 Q3 = $2.49. 4 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review AM Program Name: NATURAL GAS ADMINISTRATION Percent Category- Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $909,187.00 $575,354.29 $0.00 $333,832.71 63.3% Operating $14,303,313.00 $6,359,211.63 $316,194.05 $7,944,101.37 44.5% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $15,212,500.00 $6,934,565.92 $316,194.05 $8,277,934.08 45.6% • Salary expenditures are at 63.3%, which is 11.7% below budget due to vacancies. • Operating expenses are at 44.5%, which is 30.5% below budget due to: • Professional/Technical Services with C&M Regulatory Pipeline Consultants and McCarter & English were minimal for FY20 Q1, Q2, and Q3. 16 Program Name: NATURAL GAS CONSTRUCTION&MAINT -F7, Percent Revised Budget D Actua!& Encumbrance Available Used Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $884,418.00 $435,046.77 $0.00 $449,371.23 49.2% Operating $2,313,352.00 $1,819,066.28 $57,284.67 $494,285.72 78.6% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $3,197,770.00 $2,254,113.05 $57,284.67 $943,656.95 70.5% • Salary expenditures are at 49.2%, which is 25.8% below budget due to vacancies. • Operating expenses are at 78.6%, which is 3.6% above budget. 5 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review Program Name: NATURAL GAS PRESSURE & SERVICE Percent Category Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $1,165,948.00 $696,218.90 $0.00 $469,729.10 59.7% Operating $993,500.00 $598,475.30 $73,565.95 $395,024.70 60.2% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $2,159,448.00 $1,294,694.20 $73,565.95 $864,753.80 60.0% • Salary expenditures are at 59.7%, which is 15.3% below budget due to vacancies. • Operating expenses are at 60.2%, which is 14.8% 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 Q4 for Gas Service Technicians. Program Name NATURAL GAS CORRC ._ rcent- WCaMteg!j="F Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $668,511.00 $422,143.73 $0.00 $246,367.27 63.1% Operating $182,804.00 $82,633.94 $38,437.67 $100,170.06 45.2% Capital $141,000.00 $0.00 $43,075.00 $141,000.00 0.0% TOTAL EXPENDITURES $992,315.00 $504,777.67 $81,512.67 $487,537.33 50.9% • Salary expenditures are at 63.1%, which is 11.9% below budget due to vacancies. • Operating expenses are at 45.2%, which is 29.8% 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. 6 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review AM Program Name: NATURAL GAS LOCATING & MAPPING Percent Category- Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $601,063.00 $408,631.56 $0.00 $192,431.44 68.0% Operating $110,000.00 $55,948.09 $14,160.96 $54,051.91 50.9% Capital $20,000.00 $17,240.00 $0.00 $2,760.00 86.2% TOTAL EXPENDITURES $731,063.00 $481,819.65 $14,160.96 $249,243.35 65.9% • Salary expenditures are at 68.0%, which is 7.0% below budget due to vacancies. • Operating expenses are at 50.9%, which is 24.1% below budget due to: • Minor equipment has been ordered and will be invoiced in FY20 Q4. - --.. --SS: WATER O & M Percent vailable Used Revised Budget D Actual EncumbranclEA Revenues ($19,026,182.00) ($14,062,756.18) $0.00 ($4,963,425.82) 73.9% TOTAL REVENUES ($19,026,182.00) ($14,062,756.18) $0.00 ($4,963,425.82) 73.9% Personnel $3,216,739.00 $2,182,042.07 $0.00 $1,034,696.93 67.8% Operating $10,738,638.00 $7,847,046.68 $639,009.13 $2,891,591.32 73.1% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $13,955,377.00 $10,029,088.75 $639,009.13 $3,926,288.25 71.9% • FY20 Q3 Revenues were up at $14.063M compared to $11.306M from last year, which is at 73.9% and 1.1% below budget: • Phase II of the new rates became effective December, 2019. • Sales Volume: FY20 Q3 = 4,385 MG. FY19 Q3 = 4,326 MG. 7 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review Program Name: WATER ADMINISTRATION Percent Category Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $215,344.00 $126,448.59 $0.00 $88,895.41 58.7% Operating $2,592,530.00 $1,917,170.80 $209,107.00 $675,359.20 73.9% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $2,807,874.00 $2,043,619.39 $209,107.00 $764,254.61 72.8% • Salary expenditures are at 58.7%, which is 16.3% below budget due to vacancies. • Operating expenses are at 73.9% which is 1.1% below budget. Program Name: WATER LINE MAINTENANCE Percent Category Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $900,384.00 $548,949.06 $0.00 $351,434.94 61.0% Operating $3,055,164.00 $2,185,358.58 $82,052.16 $869,805.42 71.5% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $3,955,548.00 $2,734,307.64 $82,052.16 $1,221,240.36 69.1% • Salary expenditures are at 61.0%, which is 14.0% below budget due to vacancies. • Operating expenses are at 71.5%, which is 3.5% below budget. 8 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review AM Program Name: WATER PRODUCTION Percent BudgetCategory- Revised Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $1,110,570.00 $813,158.16 $0.00 $297,411.84 73.2% Operating $4,368,944.00 $3,290,892.15 $269,268.58 $1,078,051.85 75.3% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $5,479,514.00 $4,104,050.31 $269,268.58 $1,375,463.69 74.9% • Salary expenditures are at 73.2%, which is 1.8% below budget. • Operating expenses are at 75.3%, which is 0.3% above budget. Program Name: WATER METERS VALVES HYDRANTS -ALTCategory � � Ai -Revised Bud2et Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $990,441.00 $693,486.26 $0.00 $296,954.74 70.0% Operating $722,000.00 $453,625.15 $78,581.39 $268,374.85 62.8% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $1,712,441.00 $1,147,111.41 $78,581.39 $565,329.59 67.0% • Salary expenditures are at 70.0%, which is 5.0% below budget due to vacancies. • Operating expenses are at 62.8%, which is 12.2% below budget due to: • The use of barricades, paid for out of Purchased Services General, is expected to increase after winter months. 9 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review LI N E O F BUSINESS: WASTEWATER O & M BudgetPercent .Category Revised Revenues ($14,090,179.00) ($9,656,711.85) $0.00 ($4,433,467.15) 68.5% TOTAL REVENUES ($14,090,179.00) ($9,656,711.85) $0.00 ($4,433,467.15) 68.5% Personnel $3,136,716.00 $1,854,555.25 $0.00 $1,282,160.75 59.1% Operating $8,158,501.00 $6,012,304.54 $623,789.34 $2,146,196.46 73.7% Capital $25,650.00 $0.00 $0.00 $25,650.00 0.0% TOTAL EXPENDITURES $11,320,867.00 $7,866,859.79 $623,789.34 $3,454,007.21 69.5% • FY20 Q3 Revenues were up at $9.6572M compared to $7.867M from last year, which is at 68.5% and 6.5% below budget. • Sales Volume: FY20 Q3 = 2,683 MG. FY19 Q3 = 2,768 MG. Program Name: WASTEWATER ADMINISTRATION Percent Category Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $157,788.00 $102,383.45 $0.00 $55,404.55 64.9% Operating $2,648,292.00 $1,959,348.85 $17,853.81 $688,943.15 74.0% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $2,806,080.00 $2,061,732.30 $17,853.81 $744,347.70 73.5% • Salary expenditures are at 64.9%, which is 10.1% below budget due to vacancies. • Operating expenses are at 74.0%, which is 1.0% below budget. 10 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review AM 6 Program Name: WASTEWATER LINE MAINTENANCE Percent Category- Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $1,034,543.00 $529,662.29 $0.00 $504,880.71 51.2% Operating $941,702.00 $941,792.49 $71,802.41 ($90.49) 100.0% Capital $25,650.00 $0.00 $0.00 $25,650.00 - TOTAL EXPENDITURES $2,001,895.00 $1,471,454.78 $71,802.41 $530,440.22 73.5% • Salary expenditures are at 51.2%, which is 23.8% below budget due to vacancies. • Operating expenses are at 100.0%, which is 25.0% above budget due to: • Higher vehicle repairs costs than expected. • Higher patching costs than expected. Program Name: JACOB HANDS WW TREATMENT FACILITY Percent Revised Budget f D Inctua Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $958,638.00 $531,598.22 $0.00 $427,039.78 55.5% Operating $3,796,340.00 $2,585,149.98 $481,530.33 $1,211,190.02 68.1% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $4,754,978.00 $3,116,748.20 $481,530.33 $1,638,229.80 65.5% • Salary expenditures are at 55.5%, which is 19.5% below budget due to vacancies. • Operating expenses are at 68.1%, which is 6.9% below budget. 11 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review Program Name: E MESA WW RECLAMATION FACILITY Percent Category Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 0 TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 0 Personnel $592,936.00 $410,556.09 $0.00 $182,379.91 69.2% Operating $662,328.00 $457,138.36 $44,241.25 $205,189.64 69.0% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $1,255,264.00 $867,694.45 $44,241.25 $387,569.55 69.1% • Salary expenditures are at 69.2%, which is 5.8% below budget. • Operating expenses are at 69.0%, which is 6.0% below budget due to: • Maintenance and Repairs budget being lightly used. Program Name: W MESA INDUSTRIAL PARK WW TREAT Percent Category Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $392,811.00 $280,355.20 $0.00 $112,455.80 71.4% Operating $109,839.00 $68,874.86 $8,361.54 $40,964.14 62.7% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $502,650.00 $349,230.06 $8,361.54 $153,419.94 69.5% • Salary expenditures are at 71.4%, which is 3.6% below budget. • Operating expenses are at 62.7%, which is 12.3% 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. 12 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review LINE OF BUSINESS: SOLID WASTE COLLECTIONS Percent Category Revised Budget D Actual Revenues ($14,297,323.00) ($11,378,240.52) $0.00 ($2,919,082.48) 79.6% TOTAL REVENUES ($14,297,323.00) ($11,378,240.52) $0.00 ($2,919,082.48) 79.6% Personnel $2,323,405.00 $1,617,878.36 $0.00 $705,526.64 69.6% Operating $8,361,862.00 $6,287,839.07 $83,364.55 $2,074,022.93 75.2% Capital $125,000.00 $61,788.84 $14,542.08 $63,211.16 49.4% TOTAL EXPENDITURES $10,810,267.00 $7,967,506.27 $97,906.63 $2,842,760.73 73.7% • FY20 Q3 Revenues were up at $11.378M compared to $10.426M from last year, which is at 79.6% and 4.6% above budget: • Tonnage: FY20 Q3 = 56,333.47 tons. FY19 Q3 = 55,822.04 tons. Program Name: SOLID WASTE ADMINISTRATION Percent Category Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $211,307.00 $142,142.36 $0.00 $69,164.64 67.3% Operating $3,597,949.00 $2,844,052.07 $3,451.67 $753,896.93 79.0% Capital $125,000.00 $61,788.84 $14,542.08 $63,211.16 - TOTAL EXPENDITURES $3,934,256.00 $3,047,983.27 $17,993.75 $886,272.73 77.5% • Salary expenditures are at 67.3%, which is 7.7% below budget due to vacancies earlier in the year. • Operating expenses are at 79.0%, which is 4.0% above budget 13 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review Program Name: SOLID WASTE RESIDENTIAL COLLECTIONS Percent BudgetCategory- Revised Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $842,436.00 $588,381.36 $0.00 $254,054.64 69.8% Operating $1,998,597.00 $1,411,256.85 $29,571.13 $587,340.15 70.6% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $2,841,033.00 $1,999,638.21 $29,571.13 $841,394.79 70.4% • Salary expenditures are at 69.8%, which is 5.2% below budget. • Operating expenses are at 70.6%, which is 4.4% below budget. Program Name: SOLID WASTE COMMERCIAL COLLECTIONS ercet Category -A Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $869,359.00 $619,428.37 $0.00 $249,930.63 71.3% Operating $2,702,866.00 $1,996,149.63 $48,201.93 $706,716.37 73.9% Capital $0.00 $0.00 $0.00 $0.00 0.0% TOTAL EXPENDITURES $3,572,225.00 $2,615,578.00 $48,201.93 $956,647.00 73.2% • Salary expenditures are at 71.3%, which is 3.7% below budget. • Operating expenses are at 73.9%, which is 1.1% below budget. 14 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review Program Name: SOLID WASTE FLEET Percent BudgetCategory- Revised Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $400,303.00 $267,926.27 $0.00 $132,376.73 66.9% Operating $62,450.00 $36,380.52 $2,139.82 $26,069.48 58.3% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $462,753.00 $304,306.79 $2,139.82 $158,446.21 65.8% • Salary expenditures are at 66.9%, which is 8.1% below budget due to vacancies. • Operating expenses are at 58.3%, which is 16.7% below budget due to: • Minimal expenditures in Purchased Services, Freight, and Fuel. LINE OF BUSINESS: UTILITIES ENVIRONMENTAL Percent .Cate%M& Revised Budget YTD Actual Encurn Wnce Available Used Revenues ($204,000.00) ($101,761.28) $0.00 ($102,238.72) 49.9% TOTAL REVENUES ($204,000.00) ($101,761.28) $0.00 ($102,238.72) 49.9% Personnel $401,780.00 $289,764.85 $0.00 $112,015.15 72.1% Operating $2,049,504.00 $415,030.25 $481,864.72 $1,634,473.75 20.3% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $2,451,284.00 $704,795.10 $481,864.72 $1,746,488.90 28.8% Program Name: WATER CONSERVATION Category -A Revised Buclge� D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 0.0% Personnel $39,714.00 $28,218.64 $0.00 $11,495.36 71.1% Operating $45,937.00 $21,624.25 $14,984.25 $24,312.75 47.1% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $85,651.00 $49,842.89 $14,984.25 $35,808.11 58.2% • Salary expenditures are at 71.1%, which is 3.9% below budget. 15 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review • Operating expenses are at 47.1%, which is 27.9% below budget due to: • Water Festival cancelation, budget to be reallocated. SOLID WASTE GREEN WASTE, COMPOST, & RECYCLING Per - Revised Budget D ActualU sr Revenues $0.00 $0.00 $0.00 $0.00 0 TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 0 Personnel $314,892.00 $229,284.41 $0.00 $85,607.59 72.8% Operating $162,161.00 $115,011.87 $6,629.37 $47,149.13 70.9% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $477,053.00 $344,296.28 $6,629.37 $132,756.72 72.2% • Salary expenditures are at 72.8%, which is 2.2% below budget. • Operating expenses are at 70.9%, which is 4.1% below budget. GRIGGS WALNV Revised Budget D Actual Revenues ($204,000.00) ($101,761.28) $0.00 ($102,238.72) 49.9% TOTAL REVENUES ($204,000.00) ($101,761.28) $0.00 ($102,238.72) 49.9% Personnel $47,174.00 $32,261.80 $0.00 $14,912.20 68.4% Operating $1,841,406.00 $278,394.13 $460,251.10 $1,563,011.87 15.1% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $1,888,580.00 $310,655.93 $460,251.10 $1,577,924.07 16.4% • Salary expenditures are at 68.4%, which is 6.6% below budget. • Operating expenses are at 15.1%, which is 59.9% below budget due to: • Legal Services and Professional/Technical Services below budget due to delay in billings. 16 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review LINE OF BUSINESS: CUSTOMER ENGAGEMENT .Category Revised Budget YTD Actual Encumbra, Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $2,547,804.00 $1,558,250.07 $0.00 $989,553.93 61.2% Operating $2,139,024.00 $1,313,560.39 $385,462.15 $825,463.61 61.4% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $4,686,828.00 $2,871,810.46 $385,462.15 $1,815,017.54 61.3% CUSTOMER OUTREACH L P. Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $72,506.00 $46,875.06 $0.00 $25,630.94 64.6% Operating $450,820.00 $194,871.39 $160,779.29 $255,948.61 43.2% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $523,326.00 $241,746.45 $160,779.29 $281,579.55 46.2% • Salary expenditures are at 64.6%, which is 10.4% below budget due to Customer Service Supervisor vacancy. • Operating expenses are at 43.2%, which is 31.8% below budget due to: • Lower estimated expenses in Q3. Higher billings anticipated in the coming months. • Advertising: Resolution for public outreach contract awarded in February 2020, still identifying projects to assign to new consultant, Agenda Global. • Most of Water Conservation expenses would have hit in FY20 Q4, however, due to COVID-19 most events have been cancelled. 17 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review AM Program Name: CUSTOMER CENTRAL Percent Category- Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $502,967.00 $283,326.41 $0.00 $219,640.59 56.3% Operating $96,650.00 $86,811.76 $6,607.74 $9,838.24 89.8% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $599,617.00 $370,138.17 $6,607.74 $229,478.83 61.7% • Salary expenditures are at 56.3%, which is 18.7% below budget due to vacancies. • Operating expenses are at 89.8%, which is 14.8% above budget due to: • Temporary employees that are being utilized. Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $485,750.00 $272,917.76 $0.00 $212,832.24 56.2% Operating $746,413.00 $577,097.74 $90,977.24 $169,315.26 77.3% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $1,232,163.00 $850,015.50 $90,977.24 $382,147.50 69.0% • Salary expenditures are at 56.2%, which is 18.8% below budget due to vacancies. • Operating expenses are at 77.3%, which is 2.3% above budget. 18 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review Program Name: NEW CONNECTIONS Percent BudgetCategory- Revised Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $207,371.00 $149,157.72 $0.00 $58,213.28 71.9% Operating $23,267.00 $17,563.52 $837.23 $5,703.48 75.5% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $230,638.00 $166,721.24 $837.23 $63,916.76 72.3% • Salary expenditures are at 71.9%, which is 3.1% below budget. • Operating expenses are at 75.5%, which is 0.5% above budget. Program Name: METERING INFRASTRUCTURE 9 Percent Category -A Revised Budeet D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $309,697.00 $181,572.95 $0.00 $128,124.05 58.6% Operating $117,005.00 $70,616.99 $4,484.25 $46,388.01 60.4% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $426,702.00 $252,189.94 $4,484.25 $174,512.06 59.1% • Salary expenditures are at 58.6%, which is 16.4% below budget due to vacancies. • Operating expenses are at 60.4%, which is 14.6% below budget due to: • Lower expenses for vehicle repair and maintenance, and fuel due to less use of vehicles. 19 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review Program Name: UTILITIES DISPATCH Percent Category Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $371,746.00 $272,760.28 $0.00 $98,985.72 73.4% Operating $235,079.00 $201,530.10 $10,661.26 $33,548.90 85.7% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $606,825.00 $474,290.38 $10,661.26 $132,534.62 78.2% • Salary expenditures are at 73.4%, which is 1.6% below budget. • Operating expenses are at 85.7%, which is 10.7% above budget due to: • Purchase of the new Everbridge Mass Notification system. FIELD SERVICES Percent - Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $597,767.00 $351,639.89 $0.00 $246,127.11 58.8% Operating $469,790.00 $165,068.89 $111,115.14 $304,721.11 35.1% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $1,067,557.00 $516,708.78 $111,115.14 $550,848.22 48.4% • Salary expenditures are at 58.8%, which is 16.2% below budget due to vacancies. • Operating expenses are at 35.1%, which is 39.9% below budget due to: • Have not needed to use the contracted plumbers as much due to door hangers. 20 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review LINE OF BUSINESS: REVENUE & FINANCIAL REPORTING BudgetPercent .Category Revised Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $1,151,666.00 $800,229.21 $0.00 $351,436.79 69.5% Operating $1,302,250.00 $804,246.03 $300,290.46 $498,003.97 61.8% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $2,453,93.6.00 $1,604,475.24 $300,290.46 $849,440.76 65.4% Nrogram Name: RATE & ECONOMIC ANALYSIS Percent Revised Budget Ann Encumbrance dL Available Used Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $443,041.00 $283,423.60 $0.00 $159,617.40 64.0% Operating $23,400.00 $16,447.08 $121.47 $6,952.92 70.3% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $466,441.00 $299,870.68 $121.47 $166,570.32 64.3% • Salary expenditures are at 64.0%, which is 11.0% below budget due to vacancies in prior quarters. • Operating expenses are at 70.3%, which is 4.7% below budget. Program Name: UTILITIES WAREHOUSE Percent Category Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $232,266.00 $150,439.03 $0.00 $81,826.97 64.8% Operating $125,641.00 $72,223.14 $8,014.17 $53,417.86 57.5% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $357,907.00 $222,662.17 $8,014.17 $135,244.83 62.2% • Salary expenditures are at 64.8%, which is 10.2% below budget. • Operating expenses are at 57.5%, which is 17.5% below budget due to: 21 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review • The purchase of the barcoding system and its components have not been ordered yet. Program Name: UT BUILDING ADMINISTRATION - Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $123,681.00 $86,720.10 $0.00 $36,960.90 70.1% Operating $940,719.00 $550,060.94 $263,634.55 $390,658.06 58.5% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $1,064,400.00 $636,781.04 $263,634.55 $427,618.96 59.8% • Salary expenditures are at 70.1%, which is 4.9% below budget. • Operating expenses are at 58.5%, which is 16.5% below budget due to: • Lower expenditures recorded for electricity and general utility services. UT BUSINESS SERVICES ADMINISTRATION I1P Percent Revised Budget D ActualUse Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $352,678.00 $279,646.48 $0.00 $73,031.52 79.3% Operating $212,490.00 $165,514.87 $28,520.27 $46,975.13 77.9% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $565,168.00 $445,161.35 $28,520.27 $120,006.65 78.8% • Salary expenditures are at 79.3%, which is 4.3% above budget. • Operating expenses are at 77.9%, which is 2.9% above budget. 22 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review LINE OF BUSINESS: REGULATORY COMPLIANCE &TRAINING Percent Category Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $962,454.00 $658,030.22 $0.00 $304,423.78 68.4% Operating $2,647,985.00 $391,698.33 $1,240,489.76 $2,256,286.67 14.8% Capital $206,000.00 $0.00 $0.00 $206,000.00 - TOTAL EXPENDITURES $3,816,439.00 $1,049,728.55 $1,240,489.76 $2,766,710.45 27.5% Nrogram ivame: UT REGULATORY AND COMPLIANCE Percent16 llllllllllllllll�YTD Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $122,306.00 $77,187.09 $0.00 $45,118.91 63.1% Operating $9,257.00 $5,389.58 $788.40 $3,867.42 58.2% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $131,563.00 $82,576.67 $788.40 $48,986.33 62.8% • Salary expenditures are at 63.1%, which is 11.9% below budget due to vacancies. • Operating expenses are at 58.2%, which is 16.8% below budget due to: • Minimal expenditures in Minor Equipment, will change in Q4 due to new laptop purchase along with required software. Program Name: WATER QUALITY LABORATORY Percent Category Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $424,877.00 $282,260.30 $0.00 $142,616.70 66.4% Operating $235,667.00 $130,184.84 $40,059.65 $105,482.16 55.2% Capital $6,000.00 $0.00 $0.00 $6,000.00 - TOTAL EXPENDITURES $666,544.00 $412,445.14 $40,059.65 $254,098.86 61.9% 23 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review • Salary expenditures are at 66.4% which is 8.6% below budget. • Operating expenses are at 55.2%, which is 19.8% below budget due to: • Reduced Private/Residential special sampling and analyses requests. • Awaiting scheduled sampling/analyses programs, certification/training and audit. Program Name: INDUSTRIAL POLLUTION PREVENTION Percent Category Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $308,061.00 $225,449.33 $0.00 $82,611.67 73.2% Operating $133,356.00 $64,900.22 $10,036.44 $68,455.78 48.7% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $441,417.00 $290,349.55 $10,036.44 $151,067.45 65.8% • Salary expenditures are at 73.2% which 1.8% below budget. • Operating expenses are at 48.7%, which is 26.3% below budget due to: • Supplies General and Shop Supplies and Materials are pending invoice payments and waiting for quotes, and Maintenance and Repairs are not due until the FY20 Q4. Program Name: FOOTHILLS LANDFILL CLOSURE POST-CLOSURE Percent Category Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $81,644.00 $55,563.79 $0.00 $26,080.21 68.1% Operating $1,943,117.00 $79,403.06 $1,177,837.24 $1,863,713.94 4.1% Capital $200,000.00 $0.00 $0.00 $200,000.00 - TOTAL EXPENDITURES $2,224,761.00 $134,966.85 $1,177,837.24 $2,089,794.15 6.1% • Salary expenditures are at 68.1%, which is 6.9% below budget. • Operating expenses are at 4.1%, which is 70.9% below budget due to: • Sampling and testing to be completed later this fiscal year. 24 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review • Pre-65 Landfill Cleanup started in March, Q4 will show large use of budget. Program Name: UTILITIES TRAINING Percent Category Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $25,566.00 $17,569.71 $0.00 $7,996.29 68.7% Operating $326,588.00 $111,820.63 $11,768.03 $214,767.37 34.2% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $352,154.00 $129,390.34 $11,768.03 $222,763.66 36.7% • Salary expenditures are at 68.7%, which is 6.3% below budget. • Operating expenses are at 34.2%, which is 40.8% below budget due to: • Asbestos Training completed in Q3 however final invoice has not been received. • National Common Ground Alliance Conference/Training was not approved by ACM. • Training events that were to take place at LCU were cancelled due to Covid-19, such as Hydra Stop Training and other Gas Section and Wastewater Line of Business trainings. LINE CIF BUSINESS: UTILITIES SUPPORT & PROJECT MANAGEMENT Percent Categoryd Revenues $0.00 $0.00 $0.00 $0.00 TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $1,321,721.00 $522,531.75 $0.00 $399,189.25 65.9% Operating 314,815.00 $211,371.75 $69,772.04 $103,443.25 67.1% Capital 0.00 0.00 $0.00 $0.00 - TOTAL EXPENDITURES 1,536,536.00 1,133,903.50 $69,772.04 $502,632.50 69.3% 25 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review Program Name: TECHNICAL SUPPORT Percent Category- Revised Budget D Actual Revenues $0.00 $0.00 $0.00 $0.00 0.0% TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 0.0% Personnel $1,075,040.00 $748,333.19 $0.00 $326,706.81 69.6% Operating $272,498.00 $182,609.20 $61,851.30 $89,888.80 67.0% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $1,347,538.00 $930,942.39 $61,851.30 $416,595.61 69.1% • Salary expenditures are at 69.6%, which is 5.4% below budget due to vacancies. • Operating expenses are at 67.0%, which is 8.0% above budget due to: • Due to low purchases in minor equipment, will change due to required replacement of computers. SCAD, Percent Revised Budget, � � Revenues $0.00 $0.00 $0.00 $0.00 - TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 - Personnel $246,681.00 $174,198.56 $0.00 $72,482.44 70.6% Operating $42,317.00 $28,762.55 $7,920.74 $13,554.45 68.0% Capital $0.00 $0.00 $0.00 $0.00 - TOTAL EXPENDITURES $288,998.00 $202,961.11 $7,920.74 $86,036.89 70.2% • Salary expenditures are at 70.6%, which is 4.4% below budget. • Operating expenses are at 68.0%, which is 7.0% below budget due to: • Minor Equipment purchase will not show up until Q4, replacement of laptop for SCADA Supervisor. 26 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review Department Vacancies Total vacancies = 42: 0. Reclassifications Total Vacancies =6: Customer Central has two (2) vacancies: 1. Two (2) Customer Service Representatives, waiting on reclassification from HR. Utilities Warehouse has one (1) vacancy: 1. One (1) Contract Warehouse Worker, awaiting reclassification by HR. Utilities Business Services Administration has one (1) vacancy: 1. One (1) Management Analyst, reclassification memo is with HR. Technical Support has two (2) vacancies: 1. One (1) GIS Manager, awaiting reclassification by HR. 2. One (1) Engineering Tech, awaiting reclassification by HR. 1. LOB: Office of the Director Total Vacancies =1: Administration has one (1) vacancy: 1. One (1) Human Resources Coordinator, working with HR on PAQ. HR has not approved PAQ. 2. LOB: Natural Gas Operations and Maintenance Total Vacancies =10: Natural Gas Administration has two (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, reviewing applicant. Natural Gas Construction & Maintenance has three (3) vacancies: 1. One (1) Supervisor, Construction & Maintenance, PAQ submitted. 2. Two (2) Gas Service Worker, interview completed, second attempt. Natural Gas Pressure & Service has two (2) vacancies: 1. One (1) Assistant Supervisor, PAQ Submitted to HR. 2. One (1) Supervisor, in progress, generating outline and questions. Natural Gas Corrosion has two (2) vacancies: 1. One (1) Senior Corrosion Technician, reclassed to Gas Leak Surveyor, Interviews in progress. 2. One (1) Crew Leader-Gas Cathodic Protection, recommendation to hire in process. Natural Gas Locating & Mapping has one (1) vacancy: 1. One (1) Gas Locator, position is process of Reclassification, PAQ submitted to H R. 27 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review 3. LOB: Water Operations and Maintenance Total Vacancies = 9: Water Administration has zero (0) vacancies. 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, reclassified to Senior Office Assistant. Water Production has zero (0) vacancies. Water Meter, Valves & Hydrants has five (5) vacancies: 1. One (1) Heavy Equipment Operator, continuous posting. 2. Three (3) Senior Water Maintenance Workers, continuous posting. 3. One (1) Meter Mechanic, request to reclassify underway for Senior Office Assistant. 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 = 3: Solid Waste Administration has zero (0) vacancies. Solid Waste Residential Collections has one (1) vacancy: 1. One (1) Solid Waste Laborer, waiting on HR to approve interviews. Solid Waste Commercial Collections has two (2) vacancies: 1. One (1) Solid Waste Laborer, need to post in NeoGov. 2. One (1) Heavy Equipment Operator, PA in process. 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. 28 Department: Las Cruces Utilities Meeting Date: April 28, 2020 FY20 Third Quarter Budget and Performance Review 7. LOB: Customer Engagement Total Vacancies = 5: Customer Outreach has zero (0) vacancies. Customer Central has zero (0) vacancies. Utilities Billing and Receivables has two (2) vacancies: 1. One (1) Receivables Representative, updating interview scores in NeoGov. 2. One (1) Billing Technician, awaiting workflow approval for selected applicant. New Connections has one (1) vacancy. 1. One (1) Office Assistant Senior, waiting on HR to complete testing and release applicants. Position closed on March 16, 2020. Meter Reading has one (1) vacancy: 1. One (1) Contract Meter Reader, waiting on HR to release list of candidates. Utilities Dispatch zero (0) vacancies. Field Services has one (1) vacancy: 1. One (1) Field Service Technician positions vacant, posted until filled. S. 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, additional interviews pending. SCADA has one (0) vacancies. 29