Loading...
LCU Board FY19 Q2 Financial Reports Las Cruces Utilities Board of Commissioners FY19 — 2 �d Quarter Financial Reports gt�at�e�ment of Revenues and Expenses as of December 31 , 2018 Utility FY18 Revenues FY19 Revenues FY18 Expense FY19 Expense Gas $8,751,173 $8,514,750 $10,272,248 $9,435,245 Water $8,736,980 $9,132,032 $7,797,919 $8,426,972 Wastewater $5,724,952 $5,709,885 $6,399,745 $6,845,781 Solid Waste $7,154,055 $7,360,268 $5,999,178 $6,340,101 Total Utility $30,367,160 $30,716,935 $30,469,091 $31,048,098 $40,000,000 $35,000,000 $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 $0 Gas Water Wastewater Solid Waste ■ FY18 Revenues FY19 Revenues FY18 Expense FY19 Expense 0 Gas Statement of Revenues and Expenses as of December 31 , 2018 5200 GAS OPERATIONS ROLLUP Revised Actual Revised Actual FY19 Budget FY18 Budget FY19 Available % FY18 YTD FY19 YTD Budget Used Total Revenues $24,089,032 $8,751,173 $22,493,708 $8,514,750 $13,978,958 38% Total Expenses $25,612,640 $10,272,248 $25,106,622 $9,435,245 $15,671,377 38% $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 $0 Total Revenues Total Expenses FY18 Revised Budget FY18 YTD Actual FY19 Revised Budget FY19 YTD Actual Water Statement of Revenues and Expenses as of December 31 , 2018 5300 WATER OPERATIONS ROLLUP Revised Actual Revised Actual FY19 Budget FY18 Budget FY19 Available % FY18 YTD FY19 YTD Budget Used Total Revenues $16,295,947 $8,736,980 $16,334,796 $9,132,032 $7,202,764 5651 Total Expenses $16,175,612 $7,797,919 $14,740,226 $8,426,972 $6,313,254 57% $18,000,000 $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $0 Total Revenues Total Expenses M FY18 Revised Budget FY18 YTD Actual FY19 Revised Budget FY19 YTD Actual , 0 Wastewater Statement of Revenues and Expenses as of December 31 , 2018 5400 WASTEWATER OPERATIONS ROLLUP Revised Actual Revised Actual FY19 Budget FY18 Budget FY19 Available % FY18 YTD FY19 YTD Budget Used Total Revenues $11,729,886 $5,724,952 $11,770,765 $5,709,885 $6,060,880 49% Total Expenses $13,879,414 $6,399,745 $13,838,227 $6,845,781 $6,992,446 49% $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $0 T Total Revenues Total Expenses M FY18 Revised Budget FY18 YTD Actual M FY19 Revised Budget FY19 YTD Actual 0 Solid Waste Statement of Revenues and Expenses as of December 31 , 2018 5500 SOLID WASTE OPERATIONS ROLLUP Revised Actual Revised Actual FY19 Budget FY18 Budget FY19 Available % FY18 YTD FY19 YTD Budget Used Total Revenues $14,058,642 $7,154,055 $14,147,201 $7,360,268 $6,786,933 52% Total Expenses $12,940,798 $5,999,178 $14,882,314 $6,340,101 $8,542,213 43% $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 i $2,000,000 $0 — Total Revenues Total Expenses M FY18 Revised Budget FY18 YTD Actuals FY19 Revised Budget FY19 YTD Actuals Shared Services Statement of Revenues and Expenses as of December 31 , 2018 5100 UTILITIES SHARED SERVICES ROLLUP Revised Actual Revised Actual FY19 Budget FY18 Budget FY19 Available % FY18 YTD FY19 YTD Budget Used Total Expenses $10,588,539 $4,333,760 $11,339,707 $4,756,423 $6,583,284 42% $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $0 - Total Expenses FY18 Revised Budget FY18 YTD Actual FY19 Revised Budget FY19 YTD Actual i End of presentation . . . JycRvO,u+ City Manager Budget Review January 30, 2019 FY19 2QT Utility Operating Funds Percent of Budget 100.0% 90.0% 80.0% 70.0% 60.0% 50.0% 40.0% 30.0% 20.0% 10.0% 0.0% 5100 5200 5300 5400 5500 Salary �Operating Revenues Budget Par Utilities — Shared Services January 30, 2019 FY2019 Second Quarter Highlights/ Fund 5100 Budget Review CITY OF LAS CRUCES Budget Highlights & Major Accomplishments: 1. Water Utility Rate Review process approved by City Council in October, tariffs approved and became effective December 1, 2018. Wastewater Utility Rate Review presented to the LCU Board in December 2018. 2. Twenty(20) articles were published and posted for FY19 Q2. 3. Soledad Canyon Low Pressure Gas Distribution Network is under construction. Operating Expenditures: 1. Shared Services overall salary expenditures are at 38.9%, which is 11.1%below budget due to vacancies. 2. Shared Services overall operating expenditures are at 45.0%, which is 5.0% below budget due to: • Dispatch radio upgrades to be completed in FY19 Q3. 3. Director operating expenses are at 43.3%, which is 6.7% below budget due to: • Computers being purchased in FY19 Q3 and EPE legal billing delays. 4. Technical Support Operating expenses at 38.1%, which is 11.9%below budget due to: • Software to be purchased FY19 Q3 and temporary positions currently vacant. Personnel—Staffing Changes: Total vacancies = 16: 1. Administration has three (3)vacancies: • One (1)Assistant Utilities Director, selection committee to review applications. • Two (2) Office Assistant Senior, applications released from HR in late December. 2. Administrative Services has ten (10) vacancies: • Two (2) Customer Service Representatives Senior vacant, waiting on HR to release thru workflow. • One (1) Collection Representative vacant, waiting on HR to release external applicants. • One (1) Rate Analyst, Senior, offer was accepted and hiring packet approved, start date January 6, 2019. • One (1) Accountant, working with Finance to fill, applications received, and interviews scheduled for January. • One (1) Budget Analyst, interviews held December 5th&6th, scoring interviews and will make a tentative offer. • One (1) Regular Meter Reader and One (1) Contract Meter Reader, waiting on HR to release applicants. • One (1) Office Assistant New Connections/Dispatch, waiting on release of applicants for review from HR. • One (1) New Service Coordinator, waiting for approval from HR to start interviews. 3. Technical Support has three (3) vacancies: • One (1) Project Manager, position offered and start date will be January 7, 2019. • One (1) Senior Operations Engineer is currently posted until filled, no qualified candidates as of December 31. • One (1) SCADA Technician, outline revision completed, waiting on HR to release applications. Utilities — Gas Operations January 30, 2019 FY2019 Second Quarter Highlights/ Fund 5200 Budget Review CITY OF LAS CRUCES Budget Highlights & Major Accomplishments: 1. Sandhill Gas Main Extension. 2. Jacob Hands Wastewater Treatment Facility Gas Main Extension. 3. Competed Installation of 215 new gas services. 4. Completed staff Operations & Maintenance Training and Emergency Plan. Operating Expenditures: 1. Salary expenditures are at 38.4%, which is 11.6%below budget due to vacancies. 2. Operating expenditures are at 37.4%, which is 12.6%below budget due to: • Lower cost of gas expense due to lower average cost of gas, billing lag, and weather related. • Minor Equipment to be purchased in FY19 Q3. Personnel—Staffing Changes: Total vacancies = 13: • One (1) Pressure & Service, Meter Mechanic, reposted, third time. • One (1) Senior Corrosion Technician, job posted. • One (1) Gas Training/Safety Coordinator, position offered and accepted. • One (1) Gas Operation and Compliance Coordinator, scheduling interviews. • One (1) Pressure & Service Office Assistant Senior, offer accepted, start date January 6, 2019. • One (1) Pressure & Service Office Assistant Senior, Contract employee, offer accepted, start date January 6, 2019. • One (1) Crew Leader-Gas Cathodic Protection, scheduling interviews. • One (1) Supervisor, Construction and Maintenance, generating PAQ. • One (1) Pressure and Service, Assistant Supervisor, generating PAQ. • One (1) Office Manager, offered and accepted. • One (1) Gas Cathodic Protection technician, posted. • One (1) Pressure & Service, Service Worker, posted. • One (1) Locating & Mapping, Crew Leader, offered and accepted. Capital Outlay& Equipment: 1. No vehicles or equipment expenditures during FY19 Q2. 2. Metal Building, 65%complete, estimated completion date is May 2019. Revenue: 1. FY19 Q2 Revenues were down at$8.515M compared to $8.751 M from last vear, which is at 37.9%and 12.1% below Utilities —Water Operations January 30, 2019 FY2019 Second Quarter Highlights/ Fund 5300 Budget Review CITY OF LAS CRUCES Budget Highlights & Major Accomplishments: 1. The four (4) program interns in the DACC Water Technology program completed their semester and planning for the Spring 2019 semester. 2. One (1) employee participating in certification tutoring pilot for the November testing passed their certification test. 3. Water Conservation Plan is 99.9% complete, scheduled for Office of the State Engineer submission first of February 2019. Operating Expenditures: 1. Salary expenditures are at 45.1%, which is 4.9% below budget due to vacancies. 2. Operating expenditures are at 59.3%, which is 9.3%above budget due to: • Utility System Repair and Maintenance. • Purchased Services. Personnel—Staffing Changes: Total Vacancies = 12: • One (1) Office Assistant Senior, Meters, Valves, & Hydrants, position offered &accepted, start date January 6, 2019. • One (1) Supervisor, Water Line Maintenance, interviews completed, tentative offer made. • One (1) Supervisor, Meters, Valves, & Hydrants, tentative offer made and accepted. • One (1) Electrician in Water Production, requested re-posting until filled. • One (1) Field Customer Service Representative, A&G, reviewing applications to start setting interviews. • One (1) Serviceman in Water Line Maintenance waiting for HR to concur on tentative offer to internal applicant. • One (1) Crew Leader in Meters, Valves, & Hydrants, waiting for HR to approve requisition to post position. • Three (3) Senior Water Operators, Water Production, interviews completed, tentative offers made. • One (1) Office Assistant Senior, Water Line Maintenance, waiting for HR to release applications from OAS Pool. • One (1) Water Quality Lab Technician, in NEOGOV process, position reports to RES/Technical Support Section. Capital Outlay& Equipment: 1. No vehicles or equipment expenditures during the FY19 Q2. 2. Metal Building, 65%complete, estimated completion date is May 2019. Revenue: 1. FY19 Q2 Revenues were up at $9.132M compared to $8.737M from last year, which is at 55.9% and 5.9% above budget due to the hot and dry summer during FY19 Q1: • Sales Volume: FY19 Q2 = 3,305 MG. FY18 Q2 =3,206 MG. I Inrnminn Initiativac- Utilities —Wastewater Operations January 30, 2019 FY2019 Second Quarter Highlights/ Fund 5400 Budget Review CITY OF LAS CRUCES Budget Highlights & Major Accomplishments: 1. Jacob Hands Wastewater Treatment Facility(JHWWTF)Co-Gen system complete, finishing final punch list. Estimated ribbon cutting date for February 2019. Operating Expenditures: 1. Salary expenditures are at 38.8%, which is 11.2% below budget due to vacancies. 2. Operating expenditures are at 49.7%, which is 0.3%below budget but is almost on target. 3. Industrial Pollution Prevention expenditures are at 28.6%, which is 21.4% below budget due to: • Minor equipment to be purchased FY19 Q3. • Software to be purchased FY19 Q3. Personnel—Staffing Changes: Total Vacancies = 8: • One (1) Wastewater Administration Assistant, interview process likely to begin in February. • One (1) TV Van Inspector in Wastewater Collections System, interviews are being scheduled. • One (1) Equipment& Maintenance Worker, interview completed and working with HR. • Three (3) Maintenance Workers, scheduling interviews. • One (1)Assistant Plant Manager, submitted "Position Number Change Request Form" and memo to City Manager. • One (1) Office Assistant Senior, submitted request to post. Capital Outlay& Equipment: 1. One (1) FY18 Ford F-150, for JHWWTF. 2. Reinvestment project, Primary Digester heat blanket in progress, heat blanket on site, installation to begin in February. 3. Water Quality Lab, 63%complete, estimated completion date, March 2019. 4. Metal Building, 65%complete, estimated completion date is May 2019. Revenue: 1. FY19 Q2 Revenues were down at $5.710M compared to $5.725M from last year, which is at 48.5% and 1.5% from target: • Discharge Volume: FY19 Q2=1,890.7 MG. FY18 Q2=1,854.1 MG. Upcoming Initiatives: 1. PEAK Performance implementation and budget preparation. 2. Continue with Water/Wastewater Internship Program. Utilities — Solid Waste January 30, 2019 FY2019 Second Quarter Highlights/ Fund 5500 Budget Review CITY OF LAS CRUCES Budget Highlights & Major Accomplishments: 1. Five (5) Solid Waste staff members participated in HazWoper training in preparation for the Pre-65 Landfill Clean-up Project. 2. Began a new Grappler radio ad campaign as well as updated Green Grappler graphics for promotional use. Operating Expenditures: 1. Salary expenditures are at 43.0%, which is 7.0% below budget due to vacancies. 2. Operating expenditures are at 42.5%, which is 7.5% below budget due to: • Fuel charges only partially charged for the quarter. • Cost-savings on mailing Grappler Calendars instead of hiring temporary staff to hand-deliver. Personnel—Staffing Changes: Total vacancies = 0 Capital Outlay &Equipment: 1. One (1) FY18 Ford F-250, for commercial. 2. Metal Building at the Landfill has been erected and inside walls are up and sheet-rocked. 3. Purchased six (6) portable lifts for SW Fleet Maintenance Shop to work underneath Solid Waste vehicles. Revenue: 1. FY19 Q2 Revenues were up at$7.360M compared to$7.154M from last year, which is at 52.0%and 2.0%over budget: • Tonnage: FY19 Q2 =37,562.41 tons. FY18 Q2 =37,933.58 tons. Upcoming Initiatives: 1. Solid Waste Rate Review. 2. PEAK Performance implementation and budget preparation. City of Las Cruces- MOUNTAINS OF OPPORTUNITY DIRECTOR @December 31, 2018 as of month end close 1/9/2019 Revised YTD FY16 Budget Actual %Used $Avail Encumb Actual Actual Actual Net Income UTILITIES(340) $3,063,574 $1,235,771 40.3% $1,827,803 $255,620 $1,256,036 $1,264,636 $1,211,841 SALARY EXPENDITURES $696,896 $237,526 34.1% $459,370 $0 $256,609 $249,330 $241,928 OPERATING EXPEND $2,306,678 $998,245 43.3% $1,308,433 $255,620 $972,609 $904,497 $964,770 CAPITAL OUTLAY EXPEN $60,000 $0 0.0% $60,000 $0 $26,818 $110,809 $5,143 FY19 Revised YTD FY19 YTD FY18 YTD FY17 YTD FY16 Budget Actual %Used $Avail Encumb Actual Actual Actual FUND 5100 UTILITIES SHARED SERVICES $3,063,574 $1,235,771 40.3% $1,827,803 $255,620 $1,256,036 $1,264,636 $1,211,841 Percent Used 50.0% UT1 17ESD 40.0%- 30.0%- 20.0%- 10.0%- 0.0% 0.0%30.0%20.0%10.0%0.0% UTILITIES DIRECTORA&G Expenditures $2,500,000 $2,000,000 $1,500,000 YTD FY16 Actual YTD FY17 Actual $1,000,000 � YTD FY18 Actual $500,000 YTD FY19 Actual FY19 Revised Budget $0 SALARY EXPENDITURES OPERATING EXPEND CAPITAL OUTLAY EXPEN Expenditure Available Budget by Fiscal Period--AS OF RUN DATE: 1/14/2019 12:19:20 PM -� City of Las Cruces' '9 0 0 N T A I H S O F B PPO BTU NIT Y ADMINISTRATIVE SERVICES @December 31, 2018 as of month end close 1/9/2019 FY19 Revised YTD FY19 YTD FY18 YTD FY17 YTD FY16 Budget Actual %Used $Avail Encumb Actual Actual Actual Net Income UTILITIES(340) $6,422,668 $2,801,207 43.6% $3,621,461 $720,262 $2,273,589 $2,283,748 $2,209,037 SALARY EXPENDITURES $3,483,089 $1,415,493 40.6% $2,067,596 $0 $1,411,719 $1,454,772 $1,439,820 OPERATING EXPEND $2,929,966 $1,385,745 47.3% $1,544,221 $720,262 $861,869 $866,920 $769,217 CAPITAL OUTLAY EXPEN $9,613 $0 0.0% $9,613 t $0 $0 $0 $0 REVENUE ACCOUNTS $0 ($30) 0.0% $30 $0 $0 ($37,944) $0 FY19 Revised YTD FY19 YTD FY18 YTD FY17 YTD FY16 Budget Actual %Used $Avail Encumb Actual Actual Actual FUND 5100 UTILITIES SHARED SERVICES $6,422,668 $2,801,207 43.6% $3,621,461 $720,262 $2,273,589 $2,283,748 $2,209,037 Percent Used 60.0% CUSTOMERSE FIELDSERVI MEfERREADI 40.0%— N EWCDN N ECT v RATFANALYS UTBILLING& 20.0% UTBUILDING UTDISPATCH UTILITIESA 0.0% UTWAREHOUS UTI LITI ES ADMI NI STRATIVE SVC Expenditures $4,000,000 $3,000,000 $2,000,000 YTD FY16 Actual YTD FY17 Actual $1,000,000 YTD FY18 Actual $0 YTD FY19 Actual FY19 Revised Budget ($1,000,000) SALARY EXPENDITURES OPERATING EXPEND CAPITAL OUTLAY EXPEN REVENUE ACCOUNTS Expenditure Available Budget by Fiscal Period--AS OF RUN DATE: 1/14/2019 12:40:26 PM Will of las Cruces` M O 11 N T A I N R 11 F N P P n R T 11 N I T Y RES & TECHNICAL SUPPORT @ December 31, 2018 as of month end close 1/14/2019 FY19 Revised YTD FY18 YTD FY17 YTD FY16 Budget YTD FY19 Actual %Used $Avail Encumb Actual Actual Actual Net Income UTILITIES(340) $3,086,023 $1,242,533 40.3% $1,843,490 $181,542 $1,292,209 $1,142,534 $1,147,445 SALARY EXPENDITURES $2,300,000 $938,666 _ 40.8% $1,361,334 $0 $1,016,321 $924,193 $911,639 OPERATING EXPEND $753,023 $271,293 36.0% $481,730 $181,542 $275,887 $218,341 $235,805 CAPITAL OUTLAY EXPEN $33,000 $32,575 98.7% $425 $0 $0 $0 $0 FY19 Revised YTD FY18 YTD FY17 YTD FY16 Budget YTD FY19 Actual %Used $Avail Encumb Actual Actual Actual FUND 5100 UTILITIES SHARED SERVICES $1,956,078 $751,990 38.4% $1,204,088 $76,009 $830,954 $712,564 $728,431 FUND 5300 WATER OPERATIONS $252,175 $119,481 47.4% $132,694 $14,152 $107,986 $97,096 $146,599 FUND 5320 WATER ACQUISITION $178,960 $55,806 31.2% $123,154 $11,906 $55,845 $55,912 $0 FUND 5400 WASTEWATER OPERATIONS $698,810 $315,257 45.1% $383,553 $79,474 $297,424 $276,961 $272,414 Percent Used 60.0% REGULATORY SCADA UTILITIEST 40.0% WATERCONSE WATERLABOR WATERPOLLU 20.0% WTR CONSER WWLABORATO 0.0% W W POLLUTIO REGULATORY& ENVIRONMENTAL SVC UTILITIES TECHNICAL SUPPORT Expenditures $2,500,000 $2,000,000 $1,500,000 YTD FY16 Actual YTD FY17 Actual $1'000'000 YTD FY18 Actual $500,000 YTD FY19 Actual FY19 Revised Budget $0 SALARY EXPENDITURES OPERATING EXPEND CAPITAL OUTLAY EXPEN Expe nd itu re Available Budget by Fiscal Period--AS OF RUN DATE: 1/14/2019 1:01:23 PM City of Las Cruces' MOUNTAINS OF OPPORTUNITY GAS OPERATIONS @ December 31, 2018 as of month end close 1/9/2019 FY19 Revised YTD FY19 YTD FY18 YTD FY17 YTD FY16 Budget Actual %Used $Avail Encumb Actual Actual Actual Net Income NON DEPARTMENT(000) $2,612,914 $920,495 35.2% $1,692,419 $564,018 $1,521,076 $924,433 $1,891,0141 SALARY EXPENDITURES $4,280,689 $1,643,891 38.4% $2,636,798 $0 $1,683,542 $1,636,215 $1,635,166 OPERATING EXPEND $20,825,933 $7,791,354 37.4% $13,034,579 $564,018 $8,588,707 $8,812,210 $8,998,7231 CAPITAL OUTLAY EXPEN $0 $0 0.0% $0 $0 $0 $0 $5,1381 REVENUE ACCOUNTS ($22,493,708) ($8,514,750) 37.9% ($13,978,958) $0 ($8,751,173) ($9,523,992) ($8,748,013) FY19 Revised YTD FY19 rYTD FY18 YTD FY17 YTD FY16 Budget Actual %Used $Avail Encumb Actual Actual Actual FUND 5200 GAS OPERATIONS $2,612,914 $920,495 35.2% $1,692,419 $564,018 $1,521,076 $924,433 $1,891,014 Percent Used 60.0% GPS OP GASADMI N IS GASCONSTRU 40.0% GASCORROSI a v GAslocrn N GASPRESSUR 20.0%- 0.0% GAS ADMINI STRATION NON SECTION Expenditures $30,000,000 $20,000,000 $10,000,000 ■ $0 �' YTDFY16Actual . YTD FY17 Actual ($10,000,000) YTD FY18 Actual ($20,000,000) YTD FY19 Actual FY19 Revised Budget ($30,000,000) SALARY EXPENDITURES OPERATING EXPEND CAPITAL OUTLAY EXPEN REVENUE ACCOUNTS Expenditure Available Budget by Fiscal Period--AS OF RUN DATE: 1/14/2019 1:24:53 PM ;9jw City of Las Cruces' N 0 U N T A INS OF 9 P P OR T U N I - " WATER OPERATIONS @ December 31, 2018 as of month end close 1/9/2019 FY19 Revised YTD FY19 YTD FY18 YTD FY17 YTD FY16 Budget Actual %Used $Avail Encumb Actual Actual Actual Net Income UTILITIES(340) ($1,594,570) ($880,347) 55.2% ($714,223) $898,024 ($1,102,892) ($1,760,552) ($977,355 SALARY EXPENDITURES $3,470,869 $1,564,369 45.1% $1,906,500 $0 $1,478,424 $1,250,562 $1,238,42 OPERATING EXPEND $11,269,357 $6,687,316 59.3% $4,582,041 $898,024 $6,155,665 $5,198,626 $5,358,7091 CAPITAL OUTLAY EXPEN $0 $0 0.0% $0 $0 $0 $0 $1 REVENUE ACCOUNTS ($16,334,796) ($9,132,032) 55.9% ($7,202,764) $0 ($8,736,980) ($8,209,740) ($7,574,485 FY19 Revised YTD FY19 YTD FY18 YTD FY17 YTD FY16 Budget Actual %Used $Avail Encumb Actual Actual Actual FUND 5300 WATER OPERATIONS ($1,594,570) ($880,347) 55.2% ($714,223) $898,024 ($1,102,892) ($1,760,552) ($977,355) Percent Used 80.0%— WATERADMI N WATERLI N EM 66.6% WATERMErER WATERP RODU 40.0% WTR OP 20.0% 0.0% NON SECTION WATER ADMINISTRATION Expenditures $15,000,000 $10,000,000 $5,000,000 $0 ■ . YTD FY16 Actual v, ($5,000,000) YTD FY17 Actual ($10,000,000) YTD FY18 Actual ($15,000,000) YTD FY19 Actual FY19 Revised Budget ($20,000,000) SALARY EXPENDITURES OPERATING EXPEND CAPITAL OUTLAY EXPEN REVENUE ACCOUNTS Expenditure Available Budget by Fiscal Period--AS OF RUN DATE: 1/14/2019 3:31:03 PM �� City of Las Cruces' MOUNTAINS OF QPP " T 1NITY WASTEWATER OPERATIONS @ December 31, 2018 as of month end close 1/9/2019 FY19 Revised YTD FY19 YTD FY18 YTD FY17 YTD FY16 Budget Actual %Used $Avail Encumb Actual Actual Actual Net Income UTILITIES(340) $2,067,462 $820,639 39.7% $1,246,823 $437,500 $377,370 $279,553 $107,596 SALARY EXPENDITURES $3,160,282 $1,226,859 _ 38.8% $1,933,423 $0 $1,051,155 $1,062,634 $967,017 OPERATING EXPEND $10,677,945 $5,303,665 49.7% $5,374,280 $437,500 $5,051,167 $4,768,027 $4,579,935 CAPITAL OUTLAY EXPEN $0 $0 0.0% $0 $0 $0 $0 $0 REVENUE ACCOUNTS ($11,770,765) ($5,709,885) 48.5% ($6,060,880) $0 ($5,724,952) ($5,551,107) ($5,439,355) FY19 Revised YTD FY19 YTD FY18 YTD FY17 YTD FY16 Budget Actual %Used $Avail Encumb Actual Actual Actual FUND 5400 WASTEWATER OPERATIONS $2,067,462 $820,639 39.7% $1,246,823 $437,500 $377,370 $279,553 $107,596 Percent Used 50.0% EASTMESAI A JAKEHANDST 40.0% �WASTEWATER v 30.0% WESTMESATR a WW 4P 20.0%— WWLINEMAIN 10.0% 0.096 NON SECTION WASTEWATER ADMINISTRATION Expenditures $15,000,000 $10,000,000 $5,000,000 ■ YTD FY16 Actual W $q YTD FY17Actual ($5,000,000) YTD FY18 Actual ($10,000,000) YTD FY19 Actual FY19 Revised Budget ($15,000,000) SALARY EXPENDITURES OPERATING EXPEND CAPITAL OUTLAY EXPEN REVENUE ACCOUNTS Expenditure Available Budget by Fiscal Period--AS OF RUN DATE: 1/15/2019 9:30:13 AM City of Las Cruces` MON N T b I N S � 111` 0 P P 0N T N N 1 T '!SOLID WASTE OPERATIONS & LOSURE @ December 31, 2018 as of month end close 1/9/2019 FY19 Revised YTD FY19 YTD FY18 YTD FY17 YTD FY16 Budget Actual %Used $Avail Encumb Actual Actual Actual Net Income UTILITIES(340) $1,469,815 ($826,499) -56.2% $2,296,314 $464,884 ($1,147,319) ($1,168,141) ($1,387,256) SALARY EXPENDITURES $2,722,294 $1,169,584 43.0% $1,552,710 $0 $1,129,502 $1,162,150 $1,197,827 OPERATING EXPEND $12,160,020 $5,170,517 42.5% $6,989,5031 $329,081 $4,869,677 $4,600,384 $4,259,7041 CAPITAL OUTLAY EXPEN $734,702 $193,669 26.4% $541,033 $135,803 $7,558 $20,020 $4,4951 REVENUE ACCOUNTS ($14,147,201) ($7,360,268) 52.0% ($6,786,933) $0 ($7,154,055) ($6,950,694) ($6,849,282) FY19 Revised YTD FY19 r YTD FY18 YTD FY17 YTD FY16 Budget Actual %Used $Avail Encumb Actual Actual Actual FUND 5500 SOLID WASTE OPERATIONS ($495,185) ($859,030) 173.5% $363,845 $422,652 ($1,159,426) ($1,189,329) ($1,395,151) FUND 5510 SOLID WASTE LANDFILL CLOSURE $1,965,000 $32,531 1.7% $1,932,469 $42,232 $12,107 $21,188 $7,895 Percent Used 80.0%— SQU IDWASTE SW OP 60.0%— SWCOMMERCI SWFLEETMriI 40.090 SWRESIDENT SWYARDWAST 20.0 0.0 IX NON SECTION SOLID WASTE ADMINISTRATION Expenditures $15,000,000 $10,000,000 $5,000,000 $0 YTD FY16 Actual YTD FY17 Actual ($5,000,000)— YTD FY18 Actual ($10,000,000) =9 YTD FY19 Actual FY19 Revised Budget ($15,000,000) SALARY EXPENDITURES OPERATING EXPEND CAPITAL OUTLAY EXPEN REVENUE ACCOUNTS Expenditure Available Budget by Fiscal Period--AS OF RUN DATE: 1/15/2019 1:10:48 PM