MANAGER'S REPORT

05/8/24

 

Budget Position Report

 

The Reconciled Budget Position Report is a little strange again this month. ​​ We had a small glitch in payroll that ended up being a rather stressful major event. ​​ 

 

Essentially, I neglected to check one small box. ​​ The result was that we re-ran March payroll instead of running April’s. ​​ The mistake was not caught until the ACH transfers had been made. ​​ The process of correcting the series of errors got rather complicated.

 

The effect on the report is that the $30,188.96 in Misc. Revenue reflects various transfers to record ACH deposits and reversals. ​​ It is not cash in the door. ​​ The other line item that does not reflect reality is the Salaries & Wages. ​​ Actual cash out the door for that line item was $21,827.94.

 

Actual cash in the door was $105,812.92. ​​ Actual cash out the door (Operational Expenses + Capital Expenditures) was $71,304.87. ​​ Revenues exceeded expenditures $34,508.05.

 

We contributed $54,732.79 to reserves:

       

Out to Capital Replacement Fund:   $ ​​ 14,753.00 ​​    ​​ 

Out to Major Repair Fund:    $ ​​ 35,779.79

Out to USDA Loan Reserve:    $  ​​ ​​​​ 4,200.00  

 

Treasurer’s Report:    Current  EOY 2023

Fund Balances:      ​​ ​​​​ 

Regular Maintenance Fund:  $  ​​ ​​​​ 26,699.77 ​​  $ ​​ 81,720.29

Capital Replacement Fund:  $ ​​ 248,881.45  $205,953.45

Major Repair Reserve:  $1,047,253.91  $666,893.55

General Facilities Fund:  $ ​​ 165,432.87   $162,586.55

 

Total Funds Available:   $1,488,268.00  $1,117,154.25

 

Monthly Utility Totals Report.

May billing (Section 1) is $128,439.12.

 

Claims Request

See enclosed Claims Request Form. ​​ $

 

Water Bill Appeal

None of which I am aware.

 

Receipt Register

Receipts for April according to the receipt register were $124,682.18. There will always be a difference between what is recorded in the Receipt Register and the actual cash receipts because the Receipt Register records credit card receipts that may, or may not, have cleared the bank.

 

IT Issues

The cybersecurity audit has been completed. ​​ The notification email indicates that no critical findings were identified. ​​ A formal report will follow. ​​ 

 

We are having a bit of a SCADA problem. ​​ We are having difficulty convincing the software to operate automatically on one pump. ​​ We are having to run the system manually.

 

Capital Asset Management

At the last meeting we decided to issue a specification for a new service truck. ​​ I have not had the time to develop a detailed specification.

 

Request for Public Information

We have gathered the data and sent a letter to the person requesting the information regarding the reimbursement. ​​ Once we have received the reimbursement we will deliver the information. ​​ 

 

Payroll Report

In your packets.  ​​​​ 

 

Isolation Valves

The as-built project is underway. ​​ 

 

Cross Connection Control

The transition from the old application to the new one is underway.

 

Production Data

See the report. ​​ It is too early to make predictions. ​​ 

 

Active Projects

Several projects are in process, but seem to be going slowly as preliminary work is moving forward. There is a lot on my plate and the highest priority projects get first call on my attention.

 

GENERATOR INVESTIGATION

My plate has been full and I have not been able to follow up with my sources. ​​ 

 

WATER SYSTEM PLAN

This is moving along and should be complete ready for submission to DOH soon. ​​ This project has sucked up quite a bit of my time.

 

EMERGENCY RESPONSE PLAN

Certification is due to EPA at the end of June. ​​ It is on track.

 

GHC TRANSIT

No news in March. This project may drag on for some few years.

 

REYNVAAN EXTENSION

The signed engineering contract has been forwarded to Northwest Water Systems, Inc. ​​ The project is in their queue.

 

SHOP FENCE

No action until Spring. We will be moving on this soon.

 

 

ACCESS ROADS

Both the North Bank and the Clemons Reservoir access road projects have been deferred. ​​ We may examine later in the year.

 

AS-BUILTS UPDATE

NWS was able to obtain a goodly amount of information from the county. ​​ They are also integrating information from JWM&A into their data.

 

NWS has delivered sample printouts. ​​ Very satisfactory.

 

They are close to the next step, which is a field survey.  ​​ ​​​​ 

 

ASHLEY & KAYLA

Deferred. ​​ Leaks will be repaired as found. ​​ The will no longer show in Active Projects.

 

GENERATOR TRANSFER SWITCH

I have requested a proposal from Richie at MB Electric. ​​ No response in March.

 

I have yet to decide which track to recommend, either a dedicated generator at the pump house or a portable unit. ​​ If we go dedicated, we don’t need the transfer switch.

 

ON-SITE CHLORINE GENERATION

In the last couple of months the cost of chlorine has jumped from $7.10/gallon to $10.40/gallon, a 45% increase. ​​ 

 

It may be time to take a serious look at this project.

 

LEAD SERVICE LINE INVENTORY

I am making good progress on this project. ​​ At this stage it is primarily data collection and entry. ​​ So far, all the data we need is in district files.  ​​​​ This project has consumed a good deal of my time.

 

DOLLAR GENERAL

Service connection is complete. ​​ This will be dropped from Active Projects.

 

CAMERAS

It has become apparent that we need additional surveillance cameras in the critical areas. ​​ I have contacted MB Electric for a proposal.

 

I haven’t seen a proposal yet.

 

ELECTRONIC LOCKS

First phase is completed.

 

We will work with these for awhile before I propose a second phase. So far I am very pleased.

 

Next steps may be padlocks on the Well Site gate, the Reynvaan Booster Station Gate, and the shop site gates. ​​ The padlocks we use are pretty basic and can be defeated with a basic bolt cutter. ​​ They need to be more robust.

 

I am not concerned about a terrorist incident. ​​ I think our size makes us unattractive to anything sophisticated. My main concern is vandalism and theft.  ​​​​ 

 

VAC-TRAILER

Due to the projected cost, this will have to be deferred.

 

MOBILE RADIOS

The base station has been installed. ​​ Two of the trucks are getting their radios as I write this.

 

REPLACEMENT SERVICE TRUCK

See comments under Capital Asset Management.

 

WELL #5 REPAIR

Repair is scheduled for 05/07.

 

Hydrant Maintenance

No action in March.

 

Leak Repairs

7200 Blaine Road

 

Rate Study

I have done considerable updating for the purposes of the Water System Plan. ​​ Sure wish my crystal ball were not so cloudy.

 

An assumed 5% inflation rate, which is pretty conservative for the range of products and services we use, really skates up the costs. ​​ 

 

New Regulations

None

 

Newsletter

The next one comes out the end of June. You will have a draft at the meeting.

 

Personnel

Succession

Manager

Commissioners

 

I have prepared a proposed announcement for the general manager position. A copy is in your packets. ​​ 

 

We need to figure out a more aggressive means of beating the bushes for the commissioners.

 

Maintenance Activity:

See enclosed report.

 

Contractor Repairs/Assistance

Dollar General

 

Shop Organization

The crew is doing a good job of keeping up with the shop. ​​ 

Training/Certifications

I have almost all my CEU’s. ​​ Kenny is up to date to the end of the year.

 

With the Warnke’s talking about retirement, we need to consider getting Kenny’s Backflow Assembly Tester certification. ​​ 

 

I will try and get a report of the Spring WASWD conference pulled together by the meeting.

 

Safety

We have a safety meeting every morning.  ​​​​ 

 

Vehicles

Vehicle #1:2015 HD2500 Service Truck. ​​ See comments above under Capital Asset Management.

Vehicle #2:2015 ½ Ton Pickup Truck:  ​​​​ No Issues

Vehicle #3:2019 ½ Ton Pickup Truck: ​​ No issues

Vehicle #4:2008 HD3500 Service Truck: ​​ No Issues

 

Web Site

At this writing I have some catching up to do. ​​ Hopefully that will be done by the time you read this.

 

New Connections

Nothing in March

 

Long Distance Service Laterals

No new issues pending.

 

Respectfully Submitted:

Reg Hearn

General Manager

5

Financial2404

Treasurer2404