Water Works Top Vendors Paid - March 2020

# Vendor Description Paid Grand Total Notes

1 City of WDM Municipal Service Fees Collected by WW 1,697,864.53

Insurance Coverage - Health and Dental 39,474.15 City & Water Works Mutual Benefit

Fuel Expense/Sign Renewals 2,321.97 2,234,017.20

Water Billing 494,356.55

2 Municipal Supply, Inc. Meters & Other Supplies 110,991.50 110,991.50 Sensus Meter Regional Rep

3 Des Moines Water Works Purchased Water 106,751.10 106,751.10 Wholesale Water Service Master Agreement

4 MidAmerican Energy Company Monthly Utilities 31,580.13 31,580.13 Sole Utility Provider

5 Mississippi Lime Co. Lime 28,095.09 28,095.09 Chemical Bid

6 Mail Services, LLC Billing & Postage 12,934.31 12,934.31 Billing & Postage

7 Kelderman Lime Lime Removal 10,133.37 10,133.37 Chemical Bid

8 HDR Engineering Inc. Future Water Evals/Joint Maffit Lake Booster Station 9,250.00 9,250.00 Board Approved Company

9 IT Services LLC Monthly Support/SecureSurf 2,147.50

COVID-19 Support 5,234.89 Board Approved Company

Anti-Virus Renewal 1,600.00 8,982.39

10 Brenntag Great Lakes LLC Soda Ash 7,549.56 7,549.56 Chemical Bid

Totals 2,560,284.65 2,560,284.65

Note:

This list does not include vendors paid for construction projects

Payment Year: 2020 Year To DateMonth Total

Payment Statistics 4/8/2020

Accounts BilledMar

223Total Final Bill Accounts Billed 692 0.88%

25972Total Regular Accounts Billed 77896 99.12%

26195Total Accounts Billed 78588

Payment Type

Payment

Total

Accounts Paid % of Payment

Total

6263 15956 24.50Auto Pay

906 2560 3.93Credit Card

513 1156 1.78Drop Box

3175 8747 13.43E-Check

3916 10014 15.38Flex Pay

8943 24294 37.31Lock Box

48 519 0.80Lock Box Returns

271 618 0.95Mail

247 1250 1.92Over Counter

24282 65114

Notice Description

Notice

Total

Late Payment Notices Sent% of Final or

Regular Bills

44 144 0.18Unpaid Final Bill - Notice

1560 4904 6.30Late Payment Notice (mailed)

347 1187 1.52Final Notice (Hand Delivered)

14 144 0.18Notice of Shut Off Due to Non-Payment

1965 6379

Late Payment Arrangements

Arrangement

Total

87Kept 339

Broken 22 68

109 407

Account Type

Account

Total

Water Works Bad Debt Accounts:

# Accounts settled 10 22

# Sent to collection agency 0 13

# Written off 1 18

$ 314$ 95$ Written off

Donations:

$ 726.48 $ 2198.17Dollar Donations Received:

34 98# Donations Received:

4/9/2020

List of Large Water Users

for March 2020

Company Name Usage

General Growth Properties #2236 2,667,822

Belcher & Long Corp. 2,288,611

Prof. Prop. Mgmt.,Inc. 2,084,447

Microsoft Corporation 1,912,783

Executive Laser Wash 1,352,690

R & R Realty Group 1,315,369

W.H., L.L.C. 1,101,475

True Parkway LLC 1,066,800

Wells Fargo Bank, 150496 1,061,559

Broadmoor Development Co. 1,042,481

DM Western Village LLC 972,390

WDM Artisan LLC 938,573

West Des Moines Schools 928,472

Polo Club Apts. 877,250

Cambridge Court 850,000

CCV I, LLC 848,660

GuideOne Insurance 791,585

West Glen Town Center 763,701

Mercy Medical Center 692,100

Capreit Inc. 672,698

24,229,466

List of Large Water Users

April 09, 2020

Company Name April May June July August September October November December January February March Total

General Growth Properties #2236 63,234,940 3,352,791 5,635,009 7,606,050 10,958,210 10,923,320 6,853,950 2,709,020 3,126,048 3,244,832 3,258,799 2,899,089 2,667,822

R & R Realty Group 57,759,123 2,314,770 3,500,199 7,550,968 14,162,825 13,721,991 6,335,096 2,655,565 2,022,756 1,323,461 1,443,211 1,412,912 1,315,369

Microsoft Corporation 36,061,518 2,327,721 2,110,772 2,424,412 4,264,789 5,537,036 4,012,921 3,738,979 3,233,290 2,471,193 1,854,768 2,172,854 1,912,783

Belcher & Long Corp. 29,148,652 2,427,286 2,423,384 2,124,999 3,265,077 2,794,614 2,755,215 2,306,581 1,943,240 1,903,285 2,554,164 2,362,196 2,288,611

Prof. Prop. Mgmt.,Inc. 25,449,417 1,953,821 2,271,719 2,062,890 2,019,061 2,323,577 2,096,736 2,012,937 2,260,075 2,040,874 2,306,276 2,017,004 2,084,447

Executive Laser Wash 18,947,976 2,006,242 1,454,001 1,640,990 1,830,051 1,811,743 1,255,081 921,735 1,600,180 1,693,203 1,191,238 2,190,822 1,352,690

City of West Des Moines 18,620,237 304,873 1,908,936 2,131,077 5,071,738 4,755,086 2,641,968 586,569 287,633 180,450 313,289 279,932 158,686

Broadmoor Development Co. 18,096,206 1,068,518 1,276,534 1,976,448 2,265,577 2,825,843 2,243,378 1,095,413 1,181,516 998,664 1,108,824 1,013,010 1,042,481

Wells Fargo Bank, 150496 17,340,808 1,334,387 1,399,241 1,598,373 2,182,749 2,274,956 1,988,055 1,266,575 1,152,897 926,598 1,033,241 1,122,177 1,061,559

West Des Moines Schools 16,896,179 974,089 1,654,267 1,536,384 2,314,141 2,261,331 2,279,816 1,516,898 1,120,457 946,927 712,673 650,724 928,472

GuideOne Insurance 14,865,179 851,938 1,038,078 1,735,226 2,252,301 2,500,386 1,595,079 812,911 906,652 762,245 834,370 784,408 791,585

West Glen Town Center 14,422,393 916,530 871,918 1,115,531 2,026,851 2,258,896 1,635,163 1,066,785 1,076,732 861,029 897,187 932,070 763,701

True Parkway LLC 14,204,450 1,131,080 1,608,810 1,482,570 1,361,410 1,231,550 1,007,260 979,088 1,086,482 1,055,460 1,151,915 1,042,025 1,066,800

W.H., L.L.C. 13,805,597 1,066,705 1,093,315 999,891 1,216,841 1,230,649 1,181,361 1,127,591 1,271,419 1,083,099 1,288,223 1,145,028 1,101,475

Polo Club Apts. 12,494,100 1,079,160 1,109,210 1,325,530 1,368,610 1,080,250 1,023,300 891,460 955,330 867,970 1,002,260 913,770 877,250

Mercy Medical Center 11,997,767 728,277 930,790 1,188,044 1,685,533 1,965,972 1,132,265 735,338 749,798 674,250 775,020 740,380 692,100

DM Western Village LLC 11,932,760 1,004,840 1,177,880 1,077,170 988,720 1,060,690 996,440 792,160 915,980 924,530 1,000,960 1,021,000 972,390

Pool IV Finance LLC DBA Des Moines Sheraton 11,739,481 847,142 1,230,000 949,388 1,704,410 1,675,086 972,734 830,721 900,000 740,000 700,000 720,000 470,000

Methodist West 11,214,879 600,373 857,749 1,059,994 1,359,727 1,437,620 1,304,752 902,848 895,610 756,600 835,902 656,794 546,910

Cambridge Court 11,180,000 870,000 950,000 830,000 1,140,000 1,520,000 910,000 810,000 840,000 790,000 890,000 780,000 850,000

429,411,662 22,945,131 24,856,195 25,152,320 24,244,670 27,526,095 27,759,174 44,220,570 65,190,596 63,438,621 42,415,935 34,501,812 27,160,543

WEST DES MOINES WATER WORKS

Operations Report

March 2020

Current Month Year to Date Prior Year to Date

Water Meters Installed:

3/4 & 5/8" Meters 144 617 708

1" Meters 11 67 31

1 1/2" Meters 18 22 5

2" Meters 1 4

3" Meters -

Totals 174 710 744

Purchased Water:

105 Elm Street - - -

5501 SW Maffitt Lake Dr 67,324.0 561,037.0 149,610.0

301 S 88th St 38,973,405.0 124,251,105.0 132,180,435.0

3505 SE 22nd St 4,084,353.0 13,345,212.0

14706 University 6,051,724.5

Meter #1 224,415.0 1,047,270.0

Meter #2 224,415.0 1,122,075.0

1,496,100.0

Grand Ave. & Glen Oaks 1,645,710.0

Meter #1 - -

Meter #2 - -

-

9170 University - - 74,805.0

1285 SW Army Post Rd. 164,571.0 508,674.0 -

Totals 43,738,483.0 140,835,373.0 141,598,384.5

Taps:

Total Taps 1 1 22

Iowa One Call:

One Call Requests 1,057 1,855 1,351