Loading...
you. Any other questions? Seeing none, all in favor Aye. Aye. Any abstentions? Hearing on the motion passes. line item b 2023 Tech 127. I'd like to recommend to the Board of Water commissioners for the city of Detroit water and sewer department authorized directors to approve amendment number three to DWSD contract number 6002651. CS TAC 1943 With I Vantage group for temporary staffing services for I Tron application analysis by adding funding in the amount of $380,000 and extending the contract term for two years for new total amended not to exceed the amount of $965,000 in a term of 5.3 years. The Board of Water commissioners also authorized directors to take such other actions as may be necessary to accomplish the intent of this vote. I support. It has been moved and supported discussion, please. 
the Finance Committee met over a series of three special sessions to discuss numerous revisions to the procurement policy. Attached to the agenda is a PowerPoint of all the slides from all the sessions combined, which I will not go through in this meeting. It will take a good hour to do so. So there are many new new segments to the procurement policy. And I just want to outline for this committee, what our next steps will be. Basically, it's to recommend this to the full body for approval. And once it's approved, we will post this online and we are going to conduct conduct education sessions for our vendors, perhaps a webinar of some sort. So public affairs and procurement will work together to advise vendors, current vendors and potential vendors of all the changes to the procurement policy. So that's next steps and I need to share my screen to discuss the other two policies. But first, if there's any questions on the procurement policy, I'm happy to take those right now. 
afternoon, commissioners. Good afternoon Mr. Chair is to go around and CFO DWSD. Today I'll be going through the financial highlights for the month of March 2023. This is a quarter ending presentation and therefore a few more slides than our normal presentation especially we'll be talking about our Budget to Actual variance analysis. At the end of this presentation, just in the very outset, nothing unusual for the month or so far in the fiscal year doing this pretty business as usual, but I'll go through the highlights. First slide is caching investments. DWSD continues to maintain adequate reserves for our operating and capital programs on a system wide basis our total cash and investments stood at $229.5 million as of March 121.7 to 29 is in the water fund and having 7.8 is in the sewer fund. This is a decrease of approximately $13.4 million from last month and the main contributor to the decrease is the water fund to the extent of $4.8 million in the IND and then sewer ind $3.6 million decrease and then sewer operating $5 million. I'll go through those in the next few slides. Water operating cash amounted to $17.1 million and sewer operating cash at 32.8. The decrease in sewer operating cash as you'll see when I go through the sewer operating case, again is primarily due to our growing up of 20 fy 29 and 2022 2020 Sorry 2020 2019 and 2020 sales services accounts are GL WA and then below this slide are graphs just to show you the trend of our gas position. Over the last 12 months or so. The next slide is gassing investment for water Iranian construction fund. And with the spring and summer months we continue to spend on her Iranian construction gas, water and he guests stood at $38.8 million, which is a slight increase of approximately 900,000 from the previous month. In our construction gas we had $65.8 million. It represents a decrease of $4.8 million. Again, the decrease is due to increased activity in our construction space. And we expect such an increase during this summer spring summer months. As a whole over the last 12 months we have spent approximately $11.1 million in our water construction funds. The slides down below are again the trend trend analysis or gasp position for both water AMI and in water construction cash. The next slide 
is similar but this relates to the sewer fun. We had $31.9 million in our sewer ayeni gas which is a decrease of $3.6 million or some large payments that we had to make for construction projects. Our construction casts stood at 43 Point 1 million with no change from from the previous one for the sewer fund we spent around $5.6 million over the last 12 months. Let's talk briefly about our cash and investments cash held in trust with the GL ws trust account. That balance stood at $15.6 million, a slight increase of approximately 700,000 from last month. Retail water receipts in March exceeded February collection by approximately $2.3 million and it kind of stayed at par with our target collection our target collection each month is approximately $10.2 million to meet our operating needs. Sewer casts a GL wa was to $29.3 million and that represented an increase of $8.7 million over last month which is great news this increase is mainly because of sewer collection of approximately $32 million which exceeded our target collection of $23.3 million. So we expect to collect or we can break even if we collect $23.3 million on a monthly basis for sewer in the month of March. Obviously we collected $8.7 million more and it also exceeded our February collection by approximately $7.6 million. The main reason for sewer collection spike is because in March there was a MDOT highway drainage catch up payment of about $3.3 million. We received 1 million from DPS as well as 700,000 from DTE, and there were several other miscellaneous commercial collections 
right. We then go back, go to the next slide which is so this is a slide that I usually present on a quarterly basis. And it summarizes our cash position by fund which is water and sewer as well as some operating funds like operating Cass R I N E CAS and construction funds. Nothing much to look at here except that they represent all our cash, whether it's in our common gas pool or impress gas accounts, or our all our gas bank accounts. The next slide is similar it's again, something that I present on a quarterly basis. This is a quarterly Casin investment summary by financial institutions. So on the top part, you will see all the financial institutions where we have parked our cash and investments and the majority of our cash and investment is in government, which obviously gives us higher rate of return. You'd see 64.5% of our overall cash and investments are with the government. We also have some large balances in financing institutions that we are currently reviewing to see if we can diversify and move money across different institutions so as to reduce the risk of exposure. And the bottom 
half of this chart is again a breakdown by a water fund and the sewer fund. Only difference between this in the previous slide is this is all cash held in banks, whereas the previous slide was all cash in our trial balance in our accounting system. And the only difference between the two could be reconciling items because of timing differences. Then we have here this is a net operating cash and intra fund balance slide it kind of gives you an idea of our overall net operating cash positions when we when we factor in our Inter fund balances. Our net water operating cash and inter fund balances have increased over time. So over the last nine months, we have a positive we have an increase and this is all because of the positive budgetary results. Our March net water operating cash and interfund balances amounted to $38.3 million, which is an increase of 8.3 over the past 12 months. The next slide is a similar story just showing the suicide of the operations. The this also has steadily improved since we moved $50 million shortfall in the first two years after bifurcation. marches. Net Operating cash and interfund was $39 million, which represents a hefty $29.5 million over the past 12 months. We switch gears here now to talk about economy so that those were all caprylic acid investments related slides. We move on to accounts receivable our March sales amounted to $36.5 million, the slight decrease of 1.2 over previous one which is kind of expected sometimes due to the seasonal variation. Our total receivable for active accounts amounted to $280.7 million slight decrease on $4.4 million over the previous month. Now the average age of residential receivable increased by 20 days in the month of March compared to February. Residents and accounts receivable were flat from February to March. If you look at this chart, and this is due to a combination of factors. Number one the ongoing receipt of third party assistance payments, the lower sales revenue in February owing to fewer billable days in the month and also higher rate of customer cash payments during the tax refund season. We've seen that trend Trend during March April. We tend to get more collection because of tax refund people get during the tax filing process. I briefly go through the accounts receivable friends. Our water accounts receivable have increased about 16 and a half million dollars over the past 12 months. Residents and water accounts receivable increase 14 and a half out of that. Over the 12 months. non residents and accounts have slight increase of $1.9 million over the same period. From the sewer side we have $28.7 million increase in overall accounts receivable. Residential receivables represents about both of and most of it actually $30.9 million. non residential this increase is offset by a decrease in non residential receivable of $2.2 million over the same 12 months. Accounts receivable trend toward a 
receivable versus net receivable. We continue to increase bad debt allowance due to high average age of activist residential accounts are bad debt allowance. increased by $30.5 million since June of 2020 2022 and 4.8 million over the previous month. Although we have high accounts receivable balances, we have an offsetting allowance for bad debt of 227 and $68.4 million that just leaves us $54.3 million in net exposure in terms of receivables. DWSD anticipates resuming service interruptions on delinquent versus residential accounts in the near future. Overall our net accounts receivable has increased by $13 million over the last 12 months. Let's talk briefly about again this is a slide that comes up once in a quarter. This is aging report by customer class you see all the customer classes on the left hand side. It spread across the chart receivables that are new, that are overdue between zero and 30 days 30 to 6060 90. So on over one year in total receivable if you if he noticed this slide Rez residents and receive receivable accounts for 67% of total receivables and approximately 51% of these residents receivables are more than a year old uncollected accounts receivable are generally generally carried for five years that's a search term statutory lien expires. Just FYI, we have not yet finalized or write a policy for our long outstanding receivables. This is the primary factor is because of the current potential governmental funding opportunities that we are seeking that we continue to see. And that might allow us to collect on some of these long outstanding receivables. Once the dust is settled a little bit in the near future. We hope to have a write up policy written up and drafted for your review and who is certainly paying into the committee for review and approval. Overall for all customers combined all customer classes, you'll notice more than 53% of total receivables is over one year past you. Again, as I said the total valuation of receivables was reduced by an allowance of one in $16 million, leaving us a net receivable balance of $54.3 million at the end of March. I'd like to talk briefly about our collection rates and the trend. Residence and collection rates have shown steady improvement over several months now. The recent receipts of government government assistance program ongoing receipts of these assistant payments, the nine month average collection rate for residents and customers actually improved from 72.4% in July of 2022 to 84.8% in March of 2023. Although residents and collection rate has exceeded 80% In recent months, but still far below the pre pandemic collection rate of more which was in excess of 90%. We also believe the collection has improved for residential customers because of their response to the anticipated restart of service interruption and higher rate of customer gas payments during the tax season. As far as commercial and industrial collection rates, they have fluctuated over time, and they keep fluctuating as we go through and the slight decrease in the commercial line you'll see is mainly due to collections that are not allocated to specific customer accounts. When a customer writes a check and they don't write their account number it's hard to allocate that cast so it sits in an unallocated cash, unallocated bucket till we figure out which which account it actually relates once that's determined that gets posted and it's accounted for in our collection trends. Any questions so far? Okay, 
but the suicide it's sewer trended over budget by one point 161.3 MCF for the first nine months of the fiscal year and you can say this is due to the delay in implementing our gaps and residents and consumption in the first two months of the fiscal year. Overall sewer year to date, revenues exceeded budget by sewer meter counts have exceeded again. Budget levels for each of the months in fiscal year 2023. Year to date Council are trending at 2.8% ahead of budgeted estimate, and year to date, revenues exceeded budget by 3.2% and drainage fiscal year 23 year to date. Bia which is the billable impervious acres has exceeded it by 0.5%. Trends in recent months have been slightly negative. In terms of revenues, you will see a slight fall mainly because of highway highway drainage credits are currently at 170,000 more than what we budgeted for, as well as Wayne County roads continue to be billed at pre MDOT settlement rates. In addition to all that, we have green credits currently exceeding our budgeted levels by 95,000. So all of that contributes to a decrease in our drain hrs revenue. Now again, switching gear, the 
last three slides in my presentation these are quarterly slides representing comparison of our budget versus actual for our revenues and expenses. The first slide here is is a comparison of version revenues. The top person is the water part and the bottom portion is the sewer part. Nothing unusual but you'll see some differences in terms of commodity revenues where we are overburdened by $3.3 million or 4.5%. So far to March of 2023. Year to date, water service revenue, as I mentioned before, is trading at $1.5 million dollar over budget which was 8.5%. For the sewer side, again, commodities exceeded revenues by $8 million. The positive variance was driven by the delay in the implementation of our sewer gaps and suicide rate hrs revenue fell short as I mentioned, because of the reasons we just talked about, mainly the highway drainage as well as the relation between credits. This is the expense side. The main differences are variances you'll find in the three main areas of operations compliance and finance. And the reasons are on the right hand side and I can see the bigger differences and because of some personnel savings because of vacancies we have for all three categories, whether it's an operations compliance or finance, we have vacancy savings. We have also saved for contracts and services across the board. Mainly because of the timing differences. Some of those costs especially the IT projects are paid more towards the end of the fiscal year. And that will cover some variance between actual and budget by the end of the fiscal year. This is a variance analysis by natural classification of expenses. You'd see salaries and wages were 8.6% under budget for the first nine months. Again, the savings were due to vacancies across multiple cost centers. The savings were slightly offset by over overtime expenses exceeded budget by $1.4 million. Employee Benefits is related to salaries and wages and they were also $1.2 million under budget. Contractual services as I mentioned due to budgetary savings and timing of disbursements is showing positive variance now but that might change or will change by the time we close the fiscal year. search services and under budget because of the way we budgeted for we actually over budgeted some of the shared services where the actual numbers came in much lower. So we have a positive variance there. Other operating expenses were under budget due to savings and purchase services, rental equipment and our utility expenses. Now, that kind of concludes the presentation. It will be happy to answer any questions. 
Mr. Chair. Good afternoon, again is to go around and this is the CIP quarterly report to the committee. This is actually a Budget to Actual variance comparison variance analysis for all the CIP projects that we have in our CIP program. As I said, this is the third quarter report. You'll see the list of the projects behind this in the next couple of slides. But there are no projects that have exceeded the contract amounts, the amounts that are approved by the board. Majority of the projects currently active in all the unexpended money that you would see in those two lists are expected to be spent during the course of the contracts. All active CIP projects both for the water as well as the sewer funds will have the details like contract period, contract amount amount spent through March 31 and the variances you will see in the next two slides. Again in the next few slides, you will see there are four contracts in the water projects list and eight in the sewer projects list where the contract periods have expired. These contracts are highlighted in red in the in the list following the slide. So 
the first list is this water list. You can see all these all these active projects with the contract number and the period as well as the dollars that were approved, and the other is expanded through March of 2023 and the variances and you'll see the variances are mostly all positive which means there are monies available which will be spent during the course of the period the contract has been active for the four contracts that are expired. Two of those have closed. The third one, we don't expect any more payments retainage have been released. So that's going to be closed out to same thing with the the last and final one which is ws three 734. On the sewer slide again, there were eight there were eight yes eight contracts that have expired. For other contracts which are ongoing right now. You'll see them on the contract that was approved by the board as well as the amount spent so far. All of them have positive variances, meaning that our funds available to be spent over the next you know next few months years till the contract closes out. And here are the reasons for the eight contracts that contracts have expired. The first one says remaining to pay outstanding balance pending some settlement which hasn't happened yet. Most of those are four to be outstanding invoices and therefore once that's done, and it's all confirmed and we can close out those contracts it's a short one. If you have any questions. 
afternoon Chair Board of Water commissioners. Everybody can see my screen. Yes. All right. So I'm a no go sign Chief Strategy and process officer. I've been managing the engineering capital improvement program since 2016. When we started that major update around our CIP development for engineering, help or assist. Mohammed Farhat, our engineering construction director in delivering our capital and program for water and sewer recently, my portfolio's change to do to include it on top of our systems planning around our capital improvement program. That is part of a decision around being able to tie a lot of technology that we deployed through our capital program to understand how we do better use our data management strategy and an overall integrated architecture going forward to sustain a better infrastructure going ahead. So the purpose the goal of the CIP program is to address high risk assets within our infrastructure to reduce water main breaks operational and treatment costs. PwC participates in a biweekly infrastructure coordination meeting with multiple agencies to review work going on throughout the city. So we meet with DPW DTE m.bi. Weekly talks about projects they're doing the projects that we're doing. We've come up with instances where we can coordinate work within those areas. That's been a big change. It's started off as a small effort, but it's grown into an effort where a lot of the agencies and DWSD and the city agencies are finding value in it. From the onset of the CIP program, we made a decision to create a geographic information system centric environment that allows us to track and analyze our infrastructure. Be city works, which is our asset management solution, which we also utilize to leverage our Esri ArcGIS environment. So part of the reason that went in the early days of our capital improvement program, we decided to make sure that the systems in place to build upon we're interconnected between city works and GIS those are the two systems that runs a lot of what we do in terms of analysis. Front end, there's a lot of tools on the back end around hydraulics and project management that we utilize in the builder and other platforms like that. But a giant 
water system and investments. I'm sure everybody's gonna look at the green line on top it looked really really good. going downward trend we hit an uptrend in 20 We're working with internally and with glue to try turn that 2020 to peak up, back down. And as you can see the capital expenditure miles are slowly going back up since 2020 that we were on a pretty good trajectory up in 1617 and 18. As you look under sewers, I think we've gone back and maintained and try to get our spending levels up to replace the assets that was needed on the sewer side. 22 is going to be and 23 are going to be different years compared to prior years. But those are going to turn around as we look at the way though works getting scheduled back right now. 
I mentioned around the meeting with different agencies that through that infrastructure coordination team meeting, this is a typical map that we have that tracks current and planned projects that we share internally and externally. So we update this quarterly, and we have a very good idea around where projects are going in any part of the city on a quarterly basis that can get you faster but this is what's shared with other agencies as well. So on this one, I would like to say that, you know, DWG leadership has done a great job about performing outreach efforts to bring in new contractors to bid the various projects we've had. This region continues to be a very competitive market for construction jobs, engineers, and materials from the EU. As you can see from the money allocated for horizontal and vertical construction. This is this has kind of been the story for the last five, six years. The WC is competing in the region. For a lot of these things. And at the end of the day, we're able to pull in some of these contractors that are new and are working with us and are helping us deliver the rehabilitation of these contracts of these assets. And with that, I'd like to thank you for this opportunity to present what we've accomplished. And to let you know that the CIP delivery system that has been built over the last five years is built in a way that sustainable, transparent and the organization should be proud of 
you. 
thank you. So this is just by tears. I won't read any of this year. But this is just the information by tears. You know, who's who's eligible for the program, and enrolled financially gap are the gap payment, which is the difference between the tiered amount, the $80 amount and the actual bill and the arrearages overall, is nearly $19 million that has been assessed between the gap in arrears. The gap payment, which is just the payment between the difference between the average $80 Bill and $18 month payment is nearly $3 million. To Mr. Williams to Miko Williams made a point of you know, the 3000 individuals that have not paid their last invoice and I will I will make a clarification on that and some some some chips and news on that in just a minute. And then ineligible for Lifeline is 2500 And I think that's a to Commissioner Garcia you know with with 19,000 people in the program. In only 25 Haven't been eligible for the program and likely they haven't been eligible because either they didn't live in the city of Detroit or they're over income. I think that the success rate is extremely high with those that are applying and those getting you know into the program and being eligible to receive the benefits. So I think that's quite quite remarkable. 
So this is the last on the on the lifeline in general and to end to respond to some of the questions about you know who we've communicated to and when? On top of all the postcards but just wanted it to be noted that DWSD visited 48,590 low income households. I have attached the map that shows all the points of all the households we we visited but it just wanted to note that 49,590 homes were visited and all of those households whether we saw someone in person or not, which 4711 individuals did answer their door. But every single one of these residents was provided with information about lifeline and how they can receive the benefits of lifeline. So I just wanted to provide that data. It's been asked on a couple of occasions so I wanted to put this one to rest 
start off with the HR metrics. As of this month, we have 556 employees. That's a change of for additional employees in comparison to last month. We've also had two employees retire. We'd like to offer congratulations to two field former field service technicians. Alvin Coleman, who retired from our maintenance and repair division he had 27 and a half years with DWSD are at the city. So congratulations to Mr. Coleman. And also Jeffrey hitch. He had 39 years with the city and he retired from our meter Operations Division. We wish both of those ways well. 
other questions? Open requisitions. We have three additional from last month for a total of 21. And that equates to 72 open positions. And we have two pages here. You'll see we have 32 openings for field service technician and I'll talk about our recruiting fairs in just a second. So this is page one of open requisitions and this is page two, are there any questions? recruitment efforts regarding returning citizens. Um, Commissioner Garcia, I believe you had a question last month regarding how many returning citizens are still employed with DW FD Currently, we have 13 that are still employed with us. And I would like to add that our returning citizens are participating in learning about our s licensing. So they are taking our classes and that's the drinking water operator training certification program that Mr. Smiley teaches for us here. But our returning citizens are participating in that. And we've been told by the state that our organization has the most employees with s licensing that is so great. 
Commissioner Blackman you may have touched on this because as Commissioner Henry say that John Henry stayed at you are trailing off a little bit but I do want to say special thank you again to Sam Smalley you know with his large job, he still find the time to train the employees and to prep them for the certification exam for the S licensing. So he really inspires the team, the operations team. So we'd like to thank him for that. 
efforts, you will see that on May 17. We held our regular every last Wednesday of the month job fair with Detroit at work. We saw 23 candidates. Also on the 31st of May we had our Detroit at work job fair at the Durfee Auditorium, where we saw eight candidates, and today as we speak, my team there at Triumph church east and we're conducting a hiring fair today or DWSD positions. Only. But for tomorrow we are conducting a job fair. We are actually leading it, hosting it. First time ever so we're really excited. Job Fair also at Triumph church east and we've invited other city departments the seed, Department of Public Works DDOT the police general services and the Great Lakes Water Authority is participating also, and that will be tomorrow. From 10am to 2pm. Are there any questions? 
planning calendar for the month of June. We're going to go over the engagement, survey and action planning results. As you know the engagement survey was offered in 2020 and 2022. So the results from the 2022 survey are as follows. There was a four week window where employees could participate and take the survey. There were 49 questions across eight themes, and DWSD had a 67% participation rate. Approximately 500 employees were invited to take the survey and 337 participated in the survey. And here are some of our key outcomes and results DWSD improved in every area, every survey theme and they're listed in descending order. So we had an overall improvement on all categories. And here are survey themes listed by how many employees agreed? How many were neutral and how many disagreed. And again, we improved overall in comparison to 2020. And we also improved in comparison to the public sector are there any questions? Great job everyone at DWSD. 
so we're going to take these top four areas of opportunities for improvement. And we're going to show you an action plan. Let me show you two word clouds. This first one talks about what is the one thing that if changed, could have a positive impact on the workplace culture of the city of Detroit as a place to work. And communication is the largest word on the word chart, which means that was the greatest amount of feedback, and that's where we came out last year on 2020. Also, to improve our communication. The next word cloud focuses on what did you like best about working for the city of Detroit? And you'll see here that career and career path mobility was the most chosen comment. Are there any questions before we talk about our plans? 
hello, commissioners. Tomiko Williams. Chief Executive Director of I drink Detroit. I wanted to thank you for having this very important session. Just a few comments. There is a man that has been coming to the Board of Water commissioners meetings and have been suggesting to punish Detroit residents for drag racing and infractions and such by shutting off their water. I saw a letter that was published to that gentleman but I wish it would have been a little more clear into letting him know that we cannot do any of the sort that he is suggesting it is very dangerous. The ACLU will be on us like white on rice. So I'm just thankful for a communication for that gentleman to be told no, we cannot punish people for for civil infractions or wherever that's the police's job, let the police do their job. Um, in regards to the comment in regards to government, I'm just getting very concerned about the Arper money, the ARP aid the American rescue plan money. Have we utilized any of those funds have any of those funds been allocated for us and what is it gonna mean, when the United States signed the debt agreement? Are we still gonna have access to that money? The City of Detroit is currently sitting on that money and it could be taken away or sent back. Are we doing making any efforts to retrieve that money so we can get some of our capital water improvements and such, also our governmental representatives of the DWSD I would like to know more information about the lobbying being done such in Washington do we have anybody that's talking to these committees and officials other than the director, I mean, it's very important that we know who's advocating for us in Washington DC and how we can move on some of these things. So that we can be a leader in the country and delivering clean water. Shout out to all the legal persons Jacob Bari Nicaea and the rest that are working to retrieve businesses I would like to know some businesses that Oh, water bills, the most water bill, you know, we ever had any workers downtown. It's very important to learn from a legal standpoint, how many of those consumers business consumers that are owing money to DWSD that need to pay like Chris Elledge, Stephen Ross Dan Gilbert, you know, all of those corporate citizens who claim they are people and their people when they should be treated such as regular citizens. That's all my comment. Thank you so much and have a good day everyone. Peace and Love you. Thank you 
units are the keeper of the records. So records can be kept in paper or electronic and they're not destroyed until the specific time period elapses. So the IT team is basically going business unit by business unit and going through these rules and looking at all the documents that have been, for lack of a better word hoarded it in our offices to see what should be scanned in and retained in a more official way. We've asked that the legal team start first. We have at least 40 banker's boxes of cases and documents and things that are from the prior DWSD and the current that need to be properly indexed. So we ask that you refer this policy for approval.