MARSHALLTOWN WATER WORKS BOARD OF TRUSTEES
REGULAR BOARD MEETING
JUNE 15, 2015
4:00 PM CDT
205 EAST STATE STREET
MARSHALLTOWN, IOWA 50158
1)
Roll Call
2)
Review and Approval of the Regular Board Meeting Minutes of May 20, 2015
3)
Review and Approval of Bill Schedule # 629 Totaling $615,416.62
4)
Review and Approval of Monthly Financial Statement, Investment Report, Capital
Report, and Departmental Reports
5)
Review and Approval of accounts with unpaid rates or charges that are eligible to be
certified to become a lien upon real estate
6)
Review and Approval of Pay Request #1 for the South 18th Avenue Water Main
Extension
7)
Review and Approval of Change Order #1 for the South 18th Avenue Water Main
Extension
8)
Review and Approval of the 2016-2020 Capital Improvement Plan
9)
Review and Approval of Accounts Receivable Write Offs
MARSHALLTOWN WATER WORKS BOARD OF TRUSTEES
REGULAR BOARD MEETING
WEDNESDAY, May 20, 2015
4:00 PM CDT
205 East State Street
Marshalltown, IA 50158
ROLL CALL:
PRESENT:
ABSENT:
ALSO PRESENT:
Trustees: Vinson, Young, Eilers,
None
Tim Wilson
The Board reviewed the Regular Board Meeting minutes of April 20, 2015. There was a motion by
Trustee Young and a second by Trustee Eilers to approve the minutes as printed and have them
placed on file.
ROLL CALL VOTE:
AYES:
NAYS:
Trustees: Vinson, Young, Eilers
None
The Board reviewed Bill Schedule #628 totaling $ 672,880.10. There was a question from
Chairman Vinson regarding the bills from Clapsaddle-Garber, Concrete Inc. and Fox Engineering.
The CEO and General Manager confirmed that the bill from Clapsaddle-Garber was for the S 18 th
Avenue Water Main design. The bill from Concrete Inc. was for pavement replacement after the
winter main breaks and the bill from Fox Engineering was for the Treatment Plant Improvements
and the Standby Generator. There was a motion by Trustee Eilers and a second by Trustee
Young to approve Bill Schedule #628 totaling $ 672,880.10.
ROLL CALL VOTE:
AYES:
NAYS:
Trustees: Vinson, Young, Eilers
None
The Board reviewed the monthly financial statement, investment report, capital report and
departmental reports. After some discussion there was a motion by Trustee Young and a second
by Trustee Eilers to approve the reports and have them placed on file.
ROLL CALL VOTE:
AYES:
NAYS:
Trustees: Vinson, Young, Eilers
None
The Board reviewed accounts with unpaid rates or charges that are eligible to be certified to
become a lien upon real estate. After some discussion there was a motion by Trustee Eilers and a
second by Trustee Young to approve the accounts with unpaid rates or charges that are eligible to
become certified as a lien upon real estate.
ROLL CALL VOTE:
AYES:
NAYS:
Trustees: Vinson, Young, Eilers
None
Chairman Vinson announced that this was the time and place for the Public Hearing on Proposed
Plans, Specifications, Form of Contract and Estimated Cost for the South 18th Avenue Water Main
Extension Project. The CEO and General Manager reported that no written or oral comments
have been received. Since there were no comments, there was a motion by Trustee Eilers
and a second by Trustee Young to close the Public Hearing on Proposed Plans, Specifications,
Form of Contract and Estimated Cost for the South 18th Avenue Water Main Extension Project.
ROLL CALL VOTE:
AYES:
NAYS:
Trustees: Vinson, Young, Eilers
None
Board Minutes
May 20, 2015
Page 2
The Board reviewed the Tabulation of Bids and the Resolution Accepting Bid and Authorizing the
Award of Contract for the Marshalltown Water Works South 18th Ave Water Main Extension
Project. There was a motion by Trustee Young and a second by Trustee Eilers to approve the
Resolution Accepting Bid and Authorizing the Award of Contract for the Marshalltown Water Works
South 18th Avenue Water Main Extension Project.
ROLL CALL VOTE:
AYES:
NAYS:
Trustees: Vinson, Young, Eilers
None
RESOLUTION ACCEPTING BID AND AUTHORIZING THE
AWARD OF CONTRACT FOR THE MARSHALLTOWN WATER WORKS
SOUTH 18TH AVENUE WATER MAIN EXTENSION PROJECT
WHEREAS, notice to bidders has been duly given as required by law by
publication in the Marshalltown Times Republican for the Marshalltown Water Works
South 18th Avenue Water Main Extension Project in Marshalltown, Iowa as described
in the plans and specifications therefore, and
WHEREAS, there has been filed with the Board in response to the published
notice to the bidders referred to above, certain proposals for the construction of the
above designated project with the required certified checks or bid bond accompanying
each proposal from the following bidders, to-wit:
BIDS FOR SOUTH 18TH AVENUE WATER MAIN EXTENSION
Name of Bidder:
Amount of Bid:
Hurst and Sons, Waterloo
$347,999.99
Morris Enterprises, Inc., Clutier
$397,309.00
Gehrke Inc., Eldora
$397,771.40
Con-Struct Inc., Marshalltown
$414,515.00
Synergy Contracting LLC, Bondurant
$496,874.70
After consideration of all bids filed, it was determined by the Board that the bid
of Hurst and Sons
is the best and lowest responsible bid for the public
improvement as is herein outlined.
NOW, THEREFORE, BE IT RESOLVED BY THE BOARD OF WATER
WORKS TRUSTEES OF THE CITY OF MARSHALLTOWN, IOWA;
Section 1. The bid of
Hurst and Sons
be and the same is hereby
accepted for the construction of the project as described in the specifications therefore,
as previously ordered by this Board, and that contract for this project of the same is
now awarded to said contractor in the total amount of $ 347,999.99.
Section 2. The Chairman and the Secretary of the Board are hereby
authorized and directed to execute the contract with the contractor for the project as is
herein referred to, and that upon the contractor filing the required bond that the said
Board Minutes
May 20, 2015
Page 3
bond and contract be then submitted to this Board for final approval as is provided by
law.
Section 3. The final settlement upon the contract, as referred to herein with the
said contractor, shall be upon the basis of the unit prices as are set forth in the bid of
each contractor and for the actual quantities for each item of materials furnished or
work performed in this project. The said contract is subject to all of the conditions of
this project, the terms of the bidders written proposal, the plans and specifications as
are provided therefore all of which are made a part of this resolution and the said
bidders contract by reference as though the same were set out herein verbatim and in
specific detail.
Section 4. This resolution as now adopted shall be in full force and effective
upon the Board of Trustees final approval of the completed contract with the
successful bidder and approval of the contractor's surety bond by resolution of this
Board.
Passed this 20th day of May, 2015 and signed this 20th day of May, 2015.
Tim Wilson, representing the Marshalltown Water Works Supplemental Pension Plan, presented a
request from the Pension Board to provide an additional $1,000 per payroll to the Pension Plan
beginning July 1st. The Pension Board believes this is a good start to amortizing the actuarial
unfunded liability. The CEO and General Manager reported that the additional funds are included
in the next fiscal year’s budget. There was a motion by Trustee Eilers and a second by Trustee
Young to approve the request from the Marshalltown Water Works Supplemental Pension Board to
contribute an additional $1,000.00 per payroll beginning July 1st and the progress will be reviewed
in six months.
ROLL CALL VOTE:
AYES:
NAYS:
Trustees: Vinson, Young, Eilers
None
The CEO and General Manager presented a proposal from Process Equipment Repair Services,
Inc. The proposal is for the inspection of the two upflow clarifiers at the Treatment Plant. It has
been nearly 20 years since they were last inspected. This summer is the perfect time for the
inspection since the Water Plant Improvements will be bid later this year. If any repairs are
necessary they can be included with the Treatment Plant project. There was a motion by Trustee
Young and a second by Trustee Eilers to approve the proposal from Process Equipment Repair
Services for the inspection of the two upflow clarifiers at the Treatment Plant.
ROLL CALL VOTE:
AYES:
NAYS:
Trustees: Vinson, Young, Eilers
None
The CEO and General Manager explained to the Board that Fox Engineering has determined that
soil sampling is necessary in order to complete the design of the new 2.0 MG Reservoir. Fox
Engineering has solicited proposals on our behalf for geotechnical engineering services. Fox
Engineering recommends the proposal from Terracon in the amount of $9,500.00. There was a
motion by Trustee Young and a second by Trustee Eilers to approve the proposal from Terracon
for Geotechncial Services in the amount of $9,500.00.
ROLL CALL VOTE:
AYES:
NAYS:
Trustees: Vinson, Young, Eilers
None
Board Minutes
May 20, 2015
Page 4
The CEO and General Manager reported to the Board that a recent situation with an employee
highlighted the need to update our FMLA policy. Since the current policy does not define whether
a calendar year or rolling year is to be used the most lenient or calendar year must be used. This
caused the absence of an employee for eight months. Corporate Counsel John Veldey and the
CEO and General Manager recommend the new policy which uses a rolling 12 month period for
the calculation of FMLA absences. There was a motion by Trustee Eilers and a second by Trustee
Young to approve the updates to the Employee Handbook regarding FMLA leave after the
correction of two typographical errors.
ROLL CALL VOTE:
AYES:
NAYS:
Trustees: Vinson, Young, Eilers
None
The CEO and General Manager reported to the Board that our financial consultant recommends
the use of the State Revolving Fund for the upcoming Treatment Plant Improvements. This loan
funding mechanism will provide the lowest interest rate. The State Revolving Fund program also
offers planning and design loans. These are offered at a 0% interest rate and can be rolled into
the construction loan when the project is ready to construct. The Board indicated their approval to
apply for the State Revolving Fund planning and design loan.
The CEO and General Manager reported to the Board that Task Order 14-1 with Fox Engineering
needed to be revised. While updating the Capital Improvement Plan it was determined that the
proposed painting schedule for the 18th Avenue Tower needed to be revised. The current plan
calls for the repainting of the 18th Avenue Tower after the High Street Tower repainting. It was
determined by staff that the current coating on the 18th Avenue Tower is in worse condition than
High Street. Additionally the current painting schedule calls for painting the 18th Avenue Tower
about the same time that the new MGS goes on line and our demand increases in the vicinity of
the tower. It was originally anticipated that the 1.5 MG reservoir near the Treatment Plant would
be replaced with a new water tower. Now that a new tower won’t be constructed it is better to paint
the 18th Avenue Tower before the MGS goes on line. Fox Engineering is at a stage in the project
where they can simply change the name of the tower in the bidding documents. The proposed
Task Order cancels the remaining work on the High Street Tower Painting and shifts all efforts to
the 18th Avenue Tower painting. Since no additional work is necessary the total design services
will remain the same. This includes the amount previously paid for Task Order 14-1 and the
balance to finish in Task Order 15-1. There was a motion by Trustee Eilers and a second by
Trustee Young to approve Task Order 15-1 with Fox Engineering for the 18th Avenue Water Tower
Recoating in the amount of $56,620.00.
ROLL CALL VOTE:
AYES:
NAYS:
Trustees: Vinson, Young, Eilers
None
The Board set the date for the next regular Board meeting as June 15, 2015 at 4:00 PM at the
Marshalltown Water Works office at 205 E State St.
The Board adjourned.
Respectfully submitted,
Steven Sincox, Secretary
MARSHALLTOWN WATER WORKS
BILL SCHEDULE # 629
BILLS TO BE PAID
MAY 2015
Arnold Motor Supply
oil filters,oil,truck & backhoe lights,
grease,gasket sealant,
Bens Tire & Auto Service
mower tires
Cartwright Druker & Ryden
legal services
Carus Corporation
poly-phosphate
Central Iowa Machine Shop
meter/strainer
Clappsaddle-Garber
design services
3,090.00
Concrete Inc
concrete
1,643.94
CPI International
lab supplies
239.02
Crescent Electric Supply Company
lamp
160.68
Ethanol Products Co
CO2
756.90
Fisher Scientific Company LLC
lab supplies
Fox Engineering Associates Inc
prelimimay designs
Grainger
disposible gloves
Graymont Western Lime Inc
lime
lab supplies & amperometric digital
gateway
Hach Company
100.85
40.00
420.00
2,142.00
106.25
1,159.31
30,781.50
27.70
25,738.92
3,176.65
John Deere Financial T
CL2,carbon dioxide & fluoride
grass seed,fertilizer,safety boots,bolts,
nuts,washers,cutting wheel,wrench
sets,hitch pins,paint
Menards
bolts,batteries,adapter,couplings,sump
pumps,elbows,conduit hanger,stripper,
painting supplies,rags
124.23
Pitney Bowes Inc
postage machine ink & sealing solution
379.06
Spahn & Rose Lumber Co
lumber,levels,siding
133.58
State Hygienic Laboratory
contract lab services
57.00
Storey Kenworthy
paper,rubber bands,file boxes
76.32
Thompson True Value
repellant
Times Republican
public notification & subscription
438.88
Van Meter Inc
relay output module
230.63
Hawkins Inc
Total
6,933.06
386.94
7.49
$78,350.91
MARSHALLTOWN WATER WORKS
BILL SCHEDULE # 629
BILLS PAID
MAY 2015
AFLAC
employee deductions
48.12
Alliant Energy
gas & electricity
72.85
Alliant Energy
gas & electricity
16,185.53
Alliant Energy
gas & electricity
1,320.24
Brian Kreimeyer
deductible paid
67.94
City of Marshalltown
sewer receipts - April 2015
City of Marshalltown
storm sewer receipts - April 2015
65,135.99
City of Marshalltown
landfill receipts -April 2015
12,732.09
Consumers Energy
electricity
117.79
Craig Schutt
office cleaning April 2015
460.00
ETS
bank fees
609.55
Gordon Woods
deductible paid
Internal Revenue Service
withholding taxes
9,662.37
Internal Revenue Service
withholding taxes
9,568.62
Iowa One Call
services
321.60
IPERS
pension
5,767.96
Jared Wall
deductible paid
1,136.95
Jared Wall
deductible paid
344.42
Jon Reuter
deductible paid
62.64
Kabel Business Services
employee flex
284.08
Lincoln National Life Insurance
employee life insurance
364.00
Marshall County Engineers Office
fuel - April 2015
764.31
Marshalltown Area United Way
employee contributions
Michael Brewster
deductible paid
Payroll
payroll
25,260.38
Payroll
payroll
25,052.04
Pitney Bowes Postage by Phone
postage
Rotary Club of Marshalltown
dues & meals
176.50
Steve Sincox
mileage -April 2015
181.07
Stone Sanitation
garbage service
312,517.93
78.20
43.86
201.84
2,800.00
96.45
Teamsters Local 238
employee union dues
189.00
Tim Wilson
mileage
343.28
Treasurer State of Iowa
sales tax
5,694.75
Treasurer State of Iowa
sales tax
9,810.14
Treasurer State of Iowa
state withholding taxes
3,347.00
United Bank & Trust
pension
5,586.69
United Bank & Trust
returned Nacha
United Bank & Trust
bank fees
United Bank & Trust
pension
United Healthcare Plan of the River
Valley
employee health insurance
United States Postal Service
annual fee - PO Box 1420
UPS
postage
35.79
UPS
postage
16.24
US Bank
credit card
165.00
US Cellular
cell phone service
124.52
US Cellular
internet
Alfonso & Maria Chavarria
overpayment refund
Elder Corporation
deposit return
46.70
S M Hentges & Sons Inc
deposit return
42.42
Tin Maung Tun
deposit return
23.23
Christian N Perez
deposit return
22.28
Camelia I Ortiz-Perdomo
deposit return
15.39
Michelle Huston
deposit return
21.64
Sonja M Zook
deposit return
44.69
Donald G Stokes
deposit return
2.45
Derrick N Crouch
deposit return
37.01
Anna M Squires
deposit return
19.98
Total
68.20
6.00
5,546.23
14,102.33
132.00
26.91
160.52
$537,065.71
SEWER DEPOSIT ACCOUNT
Activity for May
2015
Balance on May 1
Deposits for May
$94,684.50
$3,215.00
Interest paid to the City of Marshalltown
Check #2387
Interest for September
May
Balance on May 31
$9.50
$9.15
$97,899.15
MARSHALLTOWN WATER WORKS
Compiled Financial Statements
And Supplementary Information
For the One Month Ended
May 31, 2015
6-05-2015 11:49 AM
MARSHALLTOWN WATER WORKS
INCOME STATEMENT
PAGE:
1
MAY 31ST, 2015
CURRENT PERIOD
ACTUAL
Y-T-D
ACTUAL
ANNUAL
BUDGET
Y-T-D
PCT
CURRENT PERIOD
PRIOR YEAR
Y-T-D
PRIOR YEAR
_______________________________________________________________________________________________________________________
OPERATIONAL
RESIDENTIAL
MULTI-FAMILY
114,336.51
13,180.23
1,327,721.05
173,131.37
1,489,176.00
196,706.00
89.16
88.02
105,970.55
13,018.52
1,293,315.46
168,615.22
COMMERCIAL
28,796.26
402,861.18
483,090.00
83.39
26,183.94
392,845.26
IRRIGATION
2,336.99
21,921.33
59,003.00
37.15
768.42
57,788.43
INDUSTRIAL
WHOLESALE
41,972.99
56,038.85
408,798.81
604,287.56
467,730.00
712,134.00
87.40
84.86
34,196.79
62,046.97
401,602.74
644,030.45
73.60
2,836.39
1,246.00
227.64
1,074.40
256,735.43
2,941,557.69
3,409,085.00
86.29
243,259.59
2,961,654.90
5,189.83
56,943.68
62,000.00
91.84
5,189.28
56,955.23
3,593.32
1,719.00
35,521.51
17,379.00
36,000.00
20,000.00
98.67
86.90
4,728.38
2,199.00
33,371.15
19,509.00
TESTING LABORATORY
MERCHANDISE SALES
200.00
133.93
4,073.50
1,554.41
4,000.00
0.00
101.84
0.00
320.00
0.00
3,055.00
2,949.82
INTEREST
RENTALS
887.60
0.00
5,338.12
1,050.00
8,000.00
1,000.00
66.73
105.00
830.87
0.00
5,201.55
1,050.00
MISC INCOME
TIMBER SALES
116.00
0.00
11,649.43
0.00
8,000.00
0.00
145.62
0.00
70.00
0.00
6,326.11
0.00
CONNECTION FEES
TAPPING FEES
0.00
100.00
191,260.00
1,525.00
2,500.00
3,000.00
7,650.40
50.83
0.00
0.00
11,939.68
326,294.65
144,500.00
225.81
13,337.53
NON-METERED
TOTAL OPERATING REVENUE
NON-OPERATIONAL
CITY CONTRACT SERVICES
PENALTIES
CUSTOMER SERVICES
TOTAL NON-OPERATIONAL SALE
3,457.34_
600.00
825.00_
129,842.86
_______________________________________________________________________________________________________________________
TOTAL REVENUE
268,675.11
3,267,852.34
3,553,585.00
91.96
256,597.12
3,091,497.76
75,743.90
927,139.51
1,053,900.00
87.97
75,868.73
922,306.94
PAYROLL TAXES & BENEFITS
OPTIONAL BENEFITS
29,037.83
1,076.81
334,221.08
15,407.14
380,414.00
40,375.00
87.86
38.16
28,502.02
364.27
331,942.48
18,329.02
UTILITIES
FUELS
17,847.84
1,091.86
236,340.07
16,128.76
281,000.00
26,465.00
84.11
60.94
20,006.54
1,792.65
251,347.37
20,058.94
SUPPLIES
7,805.69
125,099.99
111,365.00
112.33
5,087.12
105,154.91
MAINTENANCE
8,082.18
80,790.40
90,900.00
88.88
4,271.46
67,478.00
CHEMICALS
CONTRACT SERVICES
24,799.70
27,353.11
300,496.70
302,798.98
418,000.00
519,350.00
71.89
58.30
24,798.37
35,722.74
328,234.06
412,361.66
OTHER OPERATING EXPENSES
DEPRECIATION
0.00
45,492.73
0.00
500,420.03
0.00
612,916.00
0.00
81.65
0.00
48,612.47
0.00
534,737.17
OPERATING EXPENSES
SALARIES AND WAGES
_______________________________________________________________________________________________________________________
TOTAL OPERATING EXPENSE
238,331.65
2,838,842.66
3,534,685.00
80.31
245,026.37
MISCELLANEOUS EXPENSES
ECONOMIC DEVELOPMENT
0.00
0.00
900.00
8,000.00
8,900.00
8,000.00
10.11
100.00
3,656.25
0.00
TOTAL NON-OPERATING EXPENSE
0.00
8,900.00
16,900.00
52.66
3,656.25
2,991,950.55
8,154.27
8,000.00_
16,154.27
_______________________________________________________________________________________________________________________
TOTAL EXPENSES
INCR(DECR) RETAINED EARNINGS
238,331.65
2,847,742.66
3,551,585.00
80.18
248,682.62
3,008,104.82
30,343.46
420,109.68
2,000.00
1,005.48
7,914.50
83,392.94
DETAILED WATER WORKS BALANCE SHEET
6-05-2015 01:19 PM
MARSHALLTOWN WATER WORKS
BALANCE SHEET
AS OF:
1
PAGE:
1
MAY 31ST, 2015
-WATER FUND
ACCOUNT#
TITLE
_____________________________________________________________________________________________
ASSETS
======
CASH ON HAND
330.00
PETTY CASH
CASH IN BANK
300.00
1,860,019.73
LESS : SINKING FUNDS
SEWER DEPOSIT FUND
38,718.76
0.00
SEWER CASH
STORM SEWER CASH
0.00
0.00
LANDFILL CASH
ACCOUNTS RECEIVABLE
ACCOUNTS RECEIVABLE-AMP
UNAPPLIED CREDITS
0.00
291,647.80
(
OTHER A/R
NON CURRENT RECEIVABLES
MISC AR BILLINGS
MISC AR UNAPPLIED CREDITS
0.00
3,812.57
(
INTEREST RECEIVABLE
CONTRACT RECEIVABLE
8,551.70
0.00
(
PREPAID LIME SLUDGE
PREPAID COMPUTER MAINT
0.00
0.00
(
LESS IMPROVEMENT FUND ALLOCATI
LESS RESERVE FUND ALLOCATION
CAPITAL RESERVE INVESTMEN
IMPROVEMENT FUND
5,120.19
9,889.68)
47,112.59
22,424.16
PREPAID HEALTH INS
STORED GRAIN
SINKING FUND
TEMP CASH INVESTMENT
35,877.64
9,947.84)
907.34
970.94
PREPAID INSURANCE
UNFINISHED CAP PRO
PREPAID BILLING SUPPLIES
MERCHANDISE FOR RESALE
1,701.16
35,148.47)
38,718.76)
300,000.00
0.00
0.00
(
RESERVE FUND
ECONOMIC DEVELOPEMENT FUND
500,802.47
100,000.00)
0.00
0.00
INVENTORY
LAND
0.00
1,112,720.58
PLANT & SOURCE OF SUPPLY
ACCUMULATED DEPR - PLANT
(
9,914,258.36
8,334,887.10)
DISTRIBUTION SYSTEM & PIPE
ACCUM DEPR DISTRIBUTION
(
11,002,987.13
3,486,400.98)
METERS
ACCUM DEPR - METERS
(
1,279,285.02
1,035,445.10)
MACHINE & EQUIPMENT
ACCUM DEPR - MACH & EQUIP
(
427,747.79
356,822.60)
VEHICLES
ACCUM DEPR - VEHICLES
(
198,689.69
162,823.75)
CAPITAL IMPROVEMENTS
ACCUM DEPR - CAPITAL IMPROVEME
(
82,654.68
42,229.85)
CAPITAL IMPROV - BUILDINGS
ACCUM DEPR - BUILDINGS
(
572,778.81
359,382.12)
OFFICE EQUIPMENT
390,111.59
6-05-2015 01:19 PM
MARSHALLTOWN WATER WORKS
BALANCE SHEET
AS OF:
1
PAGE:
2
MAY 31ST, 2015
-WATER FUND
ACCOUNT#
TITLE
_____________________________________________________________________________________________
ACCUM DEPR - OFFICE EQUIPMENT
(
367,942.76)
BOOSTER STATION
ACCUM DEPR - BOOSTER STATION
(
BOND ORIGINATION FEE
165,995.88
75,549.51)
0.00
13,850,338.06
TOTAL ASSETS
13,850,338.06
==============
LIABILITIES
===========
ACCOUNTS PAYABLE
A/P PENDING
PAYABLE TO SEWER FUND
66,522.08
(
PAYABLE TO STORM SEWER FUND
PAYABLE TO LANDFILL FUND
114.56)
0.00
0.00
0.00
PAYABLE TO METER DEPOSIT FUND
DEFERRED AMP REVENUE
0.00
1,600.44
CUSTOMER DEPOSITS - SEWER
CURRENT REFUNDS PAYABLE
0.00
1,963.92
SEWER INTEREST
FEDERAL WITHHOLDING
0.00
0.00
FICA/MED WITHHOLDING
STATE WITHHOLDING
3,243.04
0.00
UNITED WAY
UNION DUES
INS WITHHELD
PRETAX INSURANCE WITHHELD
0.00
0.05
(
UNREIMB MEDICAL
DEP CHILD CARE
0.00
0.00
PENSION
IPERS
1,842.92
1,988.26
COBRA
WATER WORKS INS PORTION
INS DEDUCTIBLE WITHHELD
VOLUNTARY LIFE INSURANCE
89.54
0.00
(
(
CHILD SUPPORT
AFLAC
AR MISC CITY SALES TAX
AR MISC SCHOOL SALES TAX
905.11)
23.21)
0.00
0.00
ACCRUED VACATION
ACCRUED PAYROLL
ACCRUED SALES TAX
AR MISC STATE SALES TAX
106.00)
150.36
95,789.17
44,214.04
(
(
10,887.50
17.64)
73.73)
0.00
CURRENT PORTION OF LT DEBT
WA REVENUE CAPITAL LOAN NOTE
0.00
0.00
LESS : CURRENT PORTION
TOTAL LIABILITIES
0.00
227,051.07
6-05-2015 01:19 PM
MARSHALLTOWN WATER WORKS
BALANCE SHEET
AS OF:
1
PAGE:
3
MAY 31ST, 2015
-WATER FUND
ACCOUNT#
TITLE
_____________________________________________________________________________________________
EQUITY
======
RETAINED EARNINGS
TOTAL BEGINNING EQUITY
TOTAL REVENUE
TOTAL EXPENSES
TOTAL REVENUE OVER/(UNDER) EXPENSES
13,204,088.31
13,204,088.31
3,267,852.34
2,848,653.66
419,198.68
TOTAL EQUITY & REV. OVER/(UNDER) EXP.
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP.
13,623,286.99
13,850,338.06
==============
DETAILED POOLED CASH
6-05-2015 01:20 PM
MARSHALLTOWN WATER WORKS
BALANCE SHEET
AS OF:
9
PAGE:
1
MAY 31ST, 2015
-POOLED CASH
ACCOUNT#
TITLE
_____________________________________________________________________________________________
ASSETS
======
POOLED CASH
POOL CASH - SW DEPOSITS
DUE FR0M WATER FUND
2,249,467.30
98,030.00
150.00
DUE FROM SEWER FUND
DUE FROM STORM SEWER FUND
0.00
0.00
DUE FROM LANDFILL FUND
DUE FROM SW MTR DEPOSIT
0.00
0.00
2,347,647.30
TOTAL ASSETS
2,347,647.30
==============
LIABILITIES
===========
ACCOUNT PAYABLE
DUE TO OTHER FUNDS
DUE TO SW MTR DEPOSITS
WAGES PAYABLE
150.00
2,250,992.30
96,505.00
0.00
ACCRUED SALES TAX
TOTAL LIABILITIES
0.00
2,347,647.30
EQUITY
======
RETAINED EARNINGS
TOTAL BEGINNING EQUITY
0.00
0.00
TOTAL REVENUE
0.00
TOTAL EXPENSES
TOTAL REVENUE OVER/(UNDER) EXPENSES
0.00
0.00
TOTAL EQUITY & REV. OVER/(UNDER) EXP.
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP.
0.00
2,347,647.30
==============
MARSHALLTOWN WATER WORKS
INVESTMENT BREAKDOWN
May 2015
ACCOUNT
FUND
UNITED BANK & TRUST
MAY
APRIL
INTEREST RATE INTEREST RATE
DATE ISSUED DATE MATURED CURRENT VALUE PREVIOUS VALUE
0.12%
0.12%
07/01/07
DAILY
$
2,236,924.66
$
2,244,819.27
CD 5033 (GNB Bank)
General
0.52%
0.52%
02/12/15
02/12/16
$
100,000.00
$
100,000.00
CD 55203 (GNB Bank)
General
0.53%
0.53%
08/19/14
08/19/15
$
100,000.00
$
100,000.00
CD 14339 (United Bank & Trust)
General
0.50%
0.50%
08/07/14
08/07/15
$
100,000.00
$
100,000.00
CD 14292 (United Bank & Trust)
Cap Reserve
0.00%
0.46%
05/22/14
05/22/15
$
$
300,000.00
CD 14475 (United Bank & Trust)
Cap Reserve
0.51%
05/22/15
05/22/16
$
300,000.00
CD 55243 (GNB Bank)
General
0.48%
09/10/14
09/10/15
$
$
100,000.00
2,936,924.66
$
$
100,000.00
2,944,819.27
0.48%
SUB TOTAL
CURRENT TOTAL
Current Average Monthly Yield
LAST MONTH TOTAL
Last Month Average Monthly Yield
LAST YEAR TOTAL
Last Year Average Monthly Yield
$ 2,936,924.66
0.213%
$2,944,819.27
0.207%
$2,272,890.52
0.236%
-
Project
#
1172-000-PLANT & SOURCE OF SUPPLY
Facility Plan Update
Generator Repair
Raise Well # 5
Lab Computer
Rehab Wells 6 & 15
Electrical Control Building Wells 3 & 4
New Phosphate Feed System
Treatment Facility Improvement Design
New Tower Design
Wellfield Capacitor Bank
Standby Power
1170-000-LAND
1174-000-DISTRIBUTION SYSTEM
Valve Replacement
Fire Hydrant Replacement
Water Main Replacement
W South St Main
Washington St Main
18th Ave Main Extention
16" Water Main to Alliant
Tower Painting
1176-000 - METERS
Meter Program
1178-000 - EQUIPMENT
Tractor with mower
Rotory Cutter
Trench Box
Radios
1180-000-VEHICLES
Meter Truck
72
11203
89
11402
95
21501
81
21302
93
11502
88
21402
92
11501
82
31401
83
31402
94
31502
91
41501
2013-2014
BUDGET
$22,500.00
$30,000.00
$2,500.00
$25,000.00
$30,000.00
MARSHALLTOWN WATER WORKS
PROPOSED
CAPITAL IMPROVEMENTS
JULY 1,2014-JUNE 30,2015
AS OF 5/31/15
2013-2014
2013-2014
APPROVED
EXPEND.
$21,841.00
$21,841.00
$774.59
$774.59
2014-2015
BUDGET
$50,000.00
2014-2015
EXPEND.
TOTAL
EXPENDITURES
$910.00
$1,022.33
$910.00
$1,022.33
$22,750.00
$1,022.33
$1,943.63
$15,545.00
$1,943.63
$15,545.00
$2,718.22
$15,545.00
$18,158.87
$24,210.00
$24,210.00
$24,210.00
$4,143.26
$2,775.00
$4,143.26
$2,775.00
$4,143.26
$2,775.00
$5,677.50
$5,677.50
$5,677.50
$30,000.00
$25,000.00
$18,158.87
$18,158.87
$5,000.00
$330,000.00
$375,000.00
$20,000.00
$30,000.00
$125,977.65
$1,968.75
$1,968.75
2014-2015
APPROVED
$7,696.30
$7,696.30
$3,549.00
$3,375.00
$3,549.00
$3,375.00
$14,196.76
$14,196.76
$17,000.00
$20,000.00
$16,500.00
$41,102.50
$843.75
$843.75
$7,210.00
$50,000.00
$1,000,000.00
$843.75
$843.75
$7,210.00
$843.75
$843.75
$7,210.00
$4,392.75
$4,218.75
$7,210.00
$20,480.00
$20,480.00
$20,480.00
$50,000.00
$14,750.04
$14,750.00
$14,750.04
$9,500.00
$4,000.00
$9,500.00
$4,000.00
$12,572.00
$1,628.00
$9,500.00
$4,000.00
$12,572.00
$1,628.00
$9,500.00
$4,000.00
$12,572.00
$1,628.00
$18,000.00
$260.99
$260.99
$260.99
$7,000.00
$3,450.00
$3,450.00
$3,450.00
$1,990,000.00
$131,765.25
$131,765.21
$179,462.71
1182-000-GENERAL
1184-000-BUILDING
1186-000-OFFICE EQUIPMENT
Billing Printer
1188-000 BOOSTER STATION
Totals
$356,915.15
$69,591.52
$69,591.52
MONTHLY REPORT
FOR THE MONTH OF
May 2015
DISTRIBUTION
THIS MONTH
2014/2015
YEAR TO DATE
2013/2014
YEAR TO DATE
NEW WATER MAINS (ft)
0
200
780
MAINS REPAIRED
0
20
37
HYDRANTS REPLACED
0
5
2
NEW HYDRANTS INSTALLED
0
0
1
HYDRANTS REPAIRED
1
3
6
VALVES INSTALLED
0
3
6
ACTIVITY
VALVES REPAIRED
0
0
3
Outside Crew worked on concrete patching from winter.
SPECIAL PROJECTS:
Also finished dirt work and seeding. Mowing.
Backhoe maintenance, E. Nevada flushing/testing.
CUSTOMER SERVICE
THIS MONTH
2014/2015
YEAR TO DATE
2013/2014
YEAR TO DATE
404
5031
5444
NEW METERS INSTALLED
2
29
11
METERS REPAIRED
0
3
0
TAPS FOR NEW SERVICE
1
5
3
RETAPS
0
0
16
FROZEN METERS
3
36
70
ACTIVITY
SERVICE CALLS
SIGNED
Production Report - May 2015
RAW MONTH
RAW YR TO DATE
2015
147,172,000
2014
141,460,000
FINISHED MONTH
2015
142,825,000
2014
140,690,000
FY14-15
1,420,501,000
FIN. YR TO DATE FY14-15
1,400,340,000
FY13-14
1,573,556,000
FY13-14
1,526,736,000
MINIMUM DAY
3,582,000
PUMPAGE
MAXIMUM DAY
5,650,000
NORTH RURAL WATER
5,664,604
AVERAGE DAY
4,607,258
SOUTH RURAL WATER
3,945,700
WEST RURAL WATER
6,907,032
COST PER 1000 GALLONS
CHEMICALS
0.4153
GRUNDY RURAL WATER
23,190,027
ENERGY
0.1334
RURAL WATER TOTAL
39,707,363
LABOR
0.1941
BOOSTER STATION
20,158,000
TOTAL COST
0.7428
PLANT USAGE
4,415,000
CHEMICAL USAGE
CHEMICAL
CHLORINE
CARBON DIOXIDE
FLUORIDE
LIME
PHOSPHATE
SODIUM CHLORITE
LIME RESIDUAL REMOVAL
#
3
4
5
6
7
8
9
11
14
15
MONTHLY
0
32,765,458
0
0
7,301,184
14,613
31,661,568
75,751,584
0
0
POUNDS
28,142
42,796
3,072
334,640
917
1,495
CONTRACT/MONTH
PRICE
0.1029
0.0450
$
$
COST
2,895.44
1,925.82
0.4081
0.0710
1.0200
0.7038
27500.0000
TOTAL
$
$
$
$
$
$
1,253.69
23,759.44
935.34
1,052.22
27,500.00
59,321.95
WELL PUMPAGE
YEAR TO DATE
45,103,113
215,922,577
9,140,572
108,128,218
98,396,613
67,553,512
246,698,008
542,875,458
0
88,895,919
Director of Water Production
MONTHLY FLOWS FOR THE TREATMENT PLANT,
CIWA AND THE BOOSTER STATION
PUMPAGE (1000'S)
CIWA
BOOSTER
CITY
MAX DAY
39,681
18,481
85,981
4,424
36,181
16,720
75,060
4,286
38,523
18,794
88,577
4,643
42,804
18,703
81,790
4,757
41,750
23,447
92,748
5,314
42,115
18,518
91,159
5,502
53,806
19,205
108,319
6,242
47,357
26,903
118,671
6,426
45,150
20,575
99,906
5,796
40,352
16,046
95,504
4,968
48,462
18,205
74,524
4,656
40,525
18,369
83,957
4,947
1,415.6
641.0
3,003.3
5,163.4
BOOSTER STATION %
TOTAL TOTAL -CIWA
15%
21%
15%
22%
15%
21%
15%
23%
17%
25%
14%
20%
12%
18%
16%
23%
14%
21%
12%
17%
15%
24%
15%
22%
15%
21%
MONTH
Jan-13
Feb-13
Mar-13
Apr-13
May-13
Jun-13
Jul-13
Aug-13
Sep-13
Oct-13
Nov-13
Dec-13
TOTAL
125,662
111,241
127,100
124,594
134,498
133,274
162,125
166,028
145,056
135,856
122,986
124,482
4,418.9
CIWA
32%
33%
30%
34%
31%
32%
33%
29%
31%
30%
39%
33%
32%
Jan-14
Feb-14
Mar-14
Apr-14
May-14
Jun-14
Jul-14
Aug-14
Sep-14
Oct-14
Nov-14
Dec-14
135,589
118,121
140,585
135,218
140,690
134,943
140,191
136,604
125,520
126,942
118,197
119,414
4,306.9
43,148
36,479
51,582
46,710
47,143
47,064
44,381
41,615
41,226
40,354
31,187
41,420
1,403.6
18,548
16,492
26,464
29,520
20,724
19,936
22,455
22,504
20,311
19,217
17,936
18,044
690.8
92,441
81,642
89,003
88,508
93,547
87,879
95,810
94,989
84,294
86,588
87,010
77,994
2,903.3
5,024
4,872
6,689
5,466
5,953
5,251
5,144
5,223
4,909
4,581
4,589
4,306
5,167.3
14%
14%
19%
22%
15%
15%
16%
16%
16%
15%
15%
15%
16%
20%
20%
30%
33%
22%
23%
23%
24%
24%
22%
21%
23%
24%
32%
31%
37%
35%
34%
35%
32%
30%
33%
32%
26%
35%
33%
Jan-15
Feb-15
Mar-15
Apr-15
May-15
Jun-15
Jul-15
Aug-15
Sep-15
Oct-15
Nov-15
Dec-15
121,024
108,692
129,290
131,641
142,825
36,211
33,620
39,253
39,160
39,707
17,721
15,835
18,144
19,610
20,158
84,813
75,072
90,037
92,481
103,118
4,536
4,424
4,996
4,778
5,650
15%
15%
14%
15%
14%
21%
21%
20%
21%
20%
30%
31%
30%
30%
28%
4,195.2
21%
30%
23%
23%
33%
29%
29%
39%
AVERAGE
MEDIAN
MAX
134,694
133,021
171,799
1,244.7
605.7
2,950.5
4,876.8
14%
MONTHLY AVERAGES - PAST 10 YEARS
39,229
22,220
95,465
5,231
16%
39,136
21,011
93,639
5,135
16%
57,412
34,049
128,282
7,290
22%
2ND LARGE
MIN
169,069
108,552
53,806
29,442
33,930
12,820
123,778
74,524
6,768
4,222
22%
10%
30%
14%
37%
24%
2ND SMALL
108,692
30,044
15,835
75,060
4,240
12%
17%
24%
PROPERTY TAX LIENS TO CERTIFY - JUNE 2015
NAME
SERVICE ADDRESS
AMOUNT
Robert D Hessenius
306 S 9th St Down
$203.64
Armando Jara-Cruz & Amber Lynn Jara
10 Lackey Ter
$39.46
Brant & Celeste Luense
812 E State St
$23.24
TOTAL
$266.34
Page 1 of 1
CONSTRUCTION PROGRESS PAYMENT
PROJECT DESCRIPTION:
SOUTH 18TH AVENUE WATER MAIN EXTENSION
CONTRACTOR:
HURST & SONS
OWNER:
MARSHALLTOWN WATER WORKS
ADDRESS
2425 W 4TH ST
205 E STATE STREET
WATERLOO IA 50701
PO BOX 1420
MARSHALLTOWN IA 50158
ESTIMATE #
1
FOR PERIOD:
PARTIAL PAYMENT
X
FROM:
FINAL PAYMENT
6/1/2015
TO:
BASE CONTRACT PRICE
$
6/10/2015
DATE OF CONTRACT
5/21/2015
COMPLETION DATE
7/31/2015
OWNER'S PROJECT NO.
31502
347,999.99
CHANGE ORDER
CONSTRUCTION COMPLETED
$ 181,376.05
CHANGE ORDER
PERCENT PROJECT COMPLETE
CHANGE ORDER
TOTAL AMOUNT EARNED
$ 181,376.05
CHANGE ORDER
LESS 5% RETAINAGE
$
CHANGE ORDER
LESS PREVIOUS PAYMENT
$
52%
9,068.80
-
CHANGE ORDER
TOTAL ADJUSTED
CONTRACT PRICE
$
REQUESTED BY
347,999.99
AMOUNT DUE THIS ESTIMATE
$ 172,307.25
APPROVED BY
CONTRACTOR
TITLE
OWNER
CEO/GENERAL MANAGER
TITLE
DATE
DATE
APPROVED FOR PAYMENT BY
MARSHALLTOWN WATER WORKS BOARD OF TRUSTEES
DATE
CHANGE ORDER #
PROJECT #
31502
PROJECT NAME:
1
DATE
6/12/2015
South 18th Avenue Water Main Extension
AMOUNT
ORIGINAL CONTRACT PRICE
$
DESCRIPTION OF CHANGE ORDER
Item # 5.11 Tapping Valve Assembly, 16"x16".
Change method of connecing to existing main from a "Live
Tap" to cutting in a Tee and Valve
$
(1,750.00)
Provide additional mechanical joint restraint at all valves and
fittings South of STA 25+00. Provide additional push joint
restraint with Field Lok 350 gaskets for 60' North of STA
25+74.
$
5,000.00
Item #7.01 PCC Paving, 8".
Change 8" PCC Class C Pavement to 9" PCC Class M Pavement
in order to match existing conditions and improve the curing
time. Change unit price from $60.00/SY to $80/SY. Estimated
quanity of 160 SY.
$
3,200.00
ADJUSTED CONTRACT PRICE
$
354,449.99
CONTRACTOR
OWNER
TITLE
CEO & GENERAL MANAGER
TITLE
DATE
DATE
347,999.99
Marshalltown Water Works
Capital Improvement Plan for Years 2016 to 2020
Year
Improvement
2016 Vehicle Replacement
Plant
Distribution
Meter
Equipment
Vehicles
Building
Office Equip
$25,000
2016 Meter Replacement
$50,000
2016 Water Main Replacement
$100,000
2016 S. 18th Ave Water Main
$380,000
2016 Valve Replacement
$20,000
2016 Fire Hyd. Replacement
$35,000
2016 Tower Painting - 18th Ave.
$600,000
2016 Handheld Computer
$10,000
2016 Cost of Service Study
$45,000
Treatment Facility
2016
Improvements
$6,913,200
2016 Generator & Electrical
$1,567,800
2016 SCADA Update
General
$300,000
2016 High Service Pump Rehab
$50,000
2016 Clarifier Inspection
$6,000
2016 Computer Replacement
$2,000
2016 Laptop Computer
$2,500
2016 Chlorine Analyzer
$5,000
2016 New Phosphate Feed Sys.
$5,000
New Chlorine Storage
2016
Tanks
$10,000
2016 Abandon Well 14
$13,000
2016 Raise Well 5
$30,000
Confined Space Equipment
2016
& Detector
$6,000
2016 New Office Roof
$50,000
Total
2016
6/12/2015
Sub-Total
$8,929,500
$1,135,000
$60,000
$6,000
$0
$45,000
$50,000
$0
$10,225,500
1 OF 3
Marshalltown Water Works
Capital Improvement Plan for Years 2016 to 2020
Year
Improvement
Plant
Distribution
Meter
Equipment
Vehicles
General
Building
Office Equip
2016
Less SRF Loan
$8,781,000
2016
Less Annual Depreciation
$573,418
2016
Net expenditures from cash currently on hand
$871,082
2017 Dump Truck Replacement
$45,000
2017 Backhoe Replacement
$70,000
2017 Meter Replacement
$100,000
2017 Water Main Replacement
$500,000
2017 Valve Replacement
$20,000
2017 Fire Hyd. Replacement
$35,000
2017 Rehab Wells 6 & 11
$25,000
2017 Computer Replacement
$30,000
Total
2017
Sub-Total
$25,000
2018 Vehicle Replacement
$600,000
$70,000
$0
$0
$0
$30,000
$825,000
$30,000
2018 Meter Replacement
$100,000
2018 Water Main Replacement
$500,000
2018 Valve Replacement
$20,000
2018 Fire Hyd. Replacement
$40,000
2018 Tower Painting - High St.
2018 Rehab Wells 3 & 4
$100,000
$1,000,000
$30,000
Total
2018
6/12/2015
Sub-Total
$30,000
$1,590,000
$100,000
$0
$0
$0
$0
$0
$1,720,000
2 OF 3
Marshalltown Water Works
Capital Improvement Plan for Years 2016 to 2020
Year
Improvement
Plant
Distribution
2019 Meter Replacement
Equipment
Vehicles
General
Building
Office Equip
$100,000
2019 Water Main Replacement
$500,000
2019 Valve Replacement
$20,000
2019 Fire Hyd. Replacement
$40,000
2019 Rehab Wells 7 & 9
Meter
$30,000
2019 Tower Painting - Austin Pl.
$250,000
Total
2019
Sub-Total
2020 Vehicle Replacement
$30,000
$810,000
$22,000
$0
$0
$0
$0
$0
$940,000
$22,000
2020 Meter Replacement
$100,000
2020 Water Main Replacement
$500,000
2020 Valve Replacement
$20,000
2020 Fire Hyd. Replacement
$40,000
2020 Rehab Well 8
$100,000
$15,000
Total
2020
6/12/2015
Sub-Total
$37,000
$560,000
$122,000
$0
$0
$0
$0
$0
$719,000
3 OF 3
CASH & INVESTMENT ASSET HISTORY
3,000,000
2,500,000
VALUE $
2,000,000
1,500,000
1,000,000
500,000
0
2005
INVESTMENTS 1,050,680
CASH
563,359
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015 (Est)
1,100,902
1,201,970
1,303,800
1,353,253
600,862
701,345
703,176
700,550
700,802
700,802
479,789
572,248
539,787
1,244,562
399,240
523,445
718,163
1,004,862
1,235,600
1,860,019